{"text_format":"3","workbook":"xlsx","n_sheets":1,"sheets":["저축 기록표"],"not_rendered":{"charts":1,"defined_names":19},"read":"whole","date_system":"1900"}

{"sheet":"저축 기록표","index":0,"n_rows":28,"n_cols":7,"rows_kept":28,"merged":[[0,0,0,6],[4,2,4,4],[5,2,5,4],[5,5,5,6],[9,2,9,3],[10,2,10,3],[13,2,13,3],[17,2,17,3],[18,2,18,3]]}
["겨울 방학 멕시코 여행"]
[]
[]
[]
[null," 저축 시작:"," 저축 완료:",{"$nulls":3}," 저축 주기:"]
[null,{"$f":"TODAY()-120","v":"2012-09-17"},{"$f":"저축_시작_날짜+180","v":"2013-03-16"},null,null,"격주"]
[]
[]
[]
[null,"여행 비용:",{"v":6000000,"d":"₩6,000,000"}]
[null,"기존 저축:",{"v":300000,"d":"₩300,000"}]
[]
[]
[null,"현재 저축 목표:",{"$f":"이벤트_비용-저축액","v":{"v":5700000,"d":"₩5,700,000"}}]
[]
[]
[{"$f":"IF(저축_계획_정보>0,\" 저축할 경우 \"&TEXT(저축_계획_정보,\"₩#,##0 \")&PROPER(저축_빈도)&\", 시작 날짜 \"&TEXT(TODAY(),\"yy/mm/dd\"&\":\"),\"  이벤트 날짜가 너무 가까움 \"&PROPER(저축_빈도)&\" 저축 계획\")","v":" 저축할 경우 ₩475,000 격주, 시작 날짜 13/01/15:"}]
[null,"지금까지 저축액:",{"$f":" IF(저축_계획_정보>0,IF(TODAY()>저축_시작_날짜,(TODAY()-저축_시작_날짜)*일간_저축,0)+저축액,저축액)","v":{"v":4100000,"d":"₩4,100,000"}}]
[null,"부족액:",{"$f":"MAX(0,이벤트_비용-지금까지_저축액)","v":{"v":1900000,"d":"₩1,900,000"}}]
[]
[]
[]
["저축 계획 세부 정보"]
[null,"저축 간격","매일","매주","격주","매월","매년"]
[null,"저축 금액:",{"$f":"MIN(목표,IF(이벤트까지_일수=\"\",0,목표/이벤트까지_일수))","v":{"v":31666.666666666668,"d":"₩31,667"}},{"$f":"MIN(목표,IF(이벤트까지_주수=\"\",0,IF(ROUNDUP(이벤트까지_주수,0)=0,0,목표/이벤트까지_주수)))","v":{"v":221666.66666666666,"d":"₩221,667"}},{"$f":"IF(OR(이벤트까지_격주=0,이벤트까지_격주=\"\"),0,MIN(목표,IF(D25=\"\",0,목표/이벤트까지_격주)))","v":{"v":475000,"d":"₩475,000"}},{"$f":"MIN(목표,IF(목표=\"\",0,IF(OR(이벤트까지_월수=0,이벤트까지_월수=\"\"),0,목표/이벤트까지_월수)))","v":{"v":1140000,"d":"₩1,140,000"}},{"$f":"IF(OR(목표=\"\",목표=0),0,IF(OR(이벤트까지_연수=0,이벤트까지_연수=\"\"),0,목표/이벤트까지_연수))","v":{"v":0,"d":"₩0"}}]
[]
[null,"시간 간격","일","주","격주","개월","년"]
[null,"목표 달성까지 남은 시간:",{"$f":"IF(저축_시작_날짜<>\"\",DATEDIF(저축_시작_날짜,이벤트_날짜,\"D\"),\"\")","v":180},{"$f":"IF(이벤트까지_일수<>\"\",이벤트까지_일수/7,\"\")","v":{"v":25.714285714285715,"d":"26"}},{"$f":"IF(OR(이벤트까지_주수=0,이벤트까지_주수=\"\"),0,ROUNDDOWN(이벤트까지_주수/2,0))","v":12},{"$f":"IF(저축_시작_날짜<>\"\",DATEDIF(저축_시작_날짜,이벤트_날짜,\"M\"),\"\")","v":5},{"$f":"IF(저축_시작_날짜<>\"\",DATEDIF(저축_시작_날짜,이벤트_날짜,\"Y\"),\"\")","v":0}]