{"text_format":"3","workbook":"xlsx","n_sheets":4,"sheets":["Rahavoog","Kuusissetulek","Kuuväljaminek","DIAGRAMMI ANDMED"],"not_rendered":{"charts":1,"defined_names":10},"read":"whole","date_system":"1900"}

{"sheet":"Rahavoog","index":0,"n_rows":9,"n_cols":5,"rows_kept":9}
[null,"Nimi"]
[null,"Pere-eelarve"]
[null,{"$f":"TEXT(TODAY(),\"mmmm\")","v":"jaanuar"}]
[null,{"$f":"YEAR(TODAY())","v":2017}]
[null,"Märkus. Rahavoogude tabeli väärtused arvutatakse automaatselt kuusissetuleku ja kuuväljamineku töölehtede kirjete põhjal"]
[null,"Rahavoog","Prognoositud","Tegelik","Erinevus"]
[null,"Sissetulekud kokku",{"$f":"Sissetulekud[[#Totals],[Prognoositud]]","v":{"v":5700,"d":"5,700"}},{"$f":"Sissetulekud[[#Totals],[Tegelik]]","v":{"v":5500,"d":"5,500"}},{"$f":"Sissetulekud[[#Totals],[Hälve]]","v":-200}]
[null,"Väljaminekud kokku",{"$f":"Väljaminekud[[#Totals],[Prognoositud]]","v":{"v":3603,"d":"3,603"}},{"$f":"Väljaminekud[[#Totals],[Tegelik]]","v":{"v":3655,"d":"3,655"}},{"$f":"Väljaminekud[[#Totals],[Hälve]]","v":-52}]
[null,"Sularaha kokku",{"$f":"C7-C8","v":{"v":2097,"d":"2,097"}},{"$f":"D7-D8","v":{"v":1845,"d":"1,845"}},{"$f":"SUBTOTAL(109,Rahavoog[Erinevus])","v":-252}]

{"sheet":"Kuusissetulek","index":1,"n_rows":9,"n_cols":5,"rows_kept":9}
[null,{"$f":"Nimi","v":"Nimi"}]
[null,{"$f":"Eelarve_pealkiri","v":"Pere-eelarve"}]
[null,{"$f":"Kuu","v":"jaanuar"}]
[null,{"$f":"Aasta","v":2017}]
[null,"Kuusissetulek","Prognoositud","Tegelik","Hälve"]
[null,"Sissetulek 1",{"v":4000,"d":"4,000"},{"v":4000,"d":"4,000"},{"$f":"Sissetulekud[[#This Row],[Tegelik]]-Sissetulekud[[#This Row],[Prognoositud]]","v":0}]
[null,"Sissetulek 2",{"v":1400,"d":"1,400"},{"v":1500,"d":"1,500"},{"$f":"Sissetulekud[[#This Row],[Tegelik]]-Sissetulekud[[#This Row],[Prognoositud]]","v":100}]
[null,"Muu sissetulek",300,0,{"$f":"Sissetulekud[[#This Row],[Tegelik]]-Sissetulekud[[#This Row],[Prognoositud]]","v":-300}]
[null,"Sissetulekud kokku",{"$f":"SUBTOTAL(109,Sissetulekud[Prognoositud])","v":{"v":5700,"d":"5,700"}},{"$f":"SUBTOTAL(109,Sissetulekud[Tegelik])","v":{"v":5500,"d":"5,500"}},{"$f":"SUBTOTAL(109,Sissetulekud[Hälve])","v":-200}]

{"sheet":"Kuuväljaminek","index":2,"n_rows":26,"n_cols":5,"rows_kept":26}
[null,{"$f":"Nimi","v":"Nimi"}]
[null,{"$f":"Eelarve_pealkiri","v":"Pere-eelarve"}]
[null,{"$f":"Kuu","v":"jaanuar"}]
[null,{"$f":"Aasta","v":2017}]
[null,"Kuuväljaminek","Prognoositud","Tegelik","Hälve"]
[null,"Eluase",{"v":1500,"d":"1,500"},{"v":1500,"d":"1,500"},{"$f":"Väljaminekud[[#This Row],[Prognoositud]]-Väljaminekud[[#This Row],[Tegelik]]","v":0}]
[null,"Toit",250,280,{"$f":"Väljaminekud[[#This Row],[Prognoositud]]-Väljaminekud[[#This Row],[Tegelik]]","v":-30}]
[null,"Telefon",38,38,{"$f":"Väljaminekud[[#This Row],[Prognoositud]]-Väljaminekud[[#This Row],[Tegelik]]","v":0}]
[null,"Elekter/gaas",65,78,{"$f":"Väljaminekud[[#This Row],[Prognoositud]]-Väljaminekud[[#This Row],[Tegelik]]","v":-13}]
[null,"Vesi/kanalisatsioon/prügivedu",25,21,{"$f":"Väljaminekud[[#This Row],[Prognoositud]]-Väljaminekud[[#This Row],[Tegelik]]","v":4}]
[null,"Kaabeltelevisioon",75,83,{"$f":"Väljaminekud[[#This Row],[Prognoositud]]-Väljaminekud[[#This Row],[Tegelik]]","v":-8}]
[null,"Internet",60,60,{"$f":"Väljaminekud[[#This Row],[Prognoositud]]-Väljaminekud[[#This Row],[Tegelik]]","v":0}]
[null,"Majapidamine/remont",0,60,{"$f":"Väljaminekud[[#This Row],[Prognoositud]]-Väljaminekud[[#This Row],[Tegelik]]","v":-60}]
[null,"Lastehoid",180,150,{"$f":"Väljaminekud[[#This Row],[Prognoositud]]-Väljaminekud[[#This Row],[Tegelik]]","v":30}]
[null,"Õppemaks",250,250,{"$f":"Väljaminekud[[#This Row],[Prognoositud]]-Väljaminekud[[#This Row],[Tegelik]]","v":0}]
[null,"Lemmikloomad",75,80,{"$f":"Väljaminekud[[#This Row],[Prognoositud]]-Väljaminekud[[#This Row],[Tegelik]]","v":-5}]
[null,"Transport",280,260,{"$f":"Väljaminekud[[#This Row],[Prognoositud]]-Väljaminekud[[#This Row],[Tegelik]]","v":20}]
[null,"Isiklik hooldus",75,65,{"$f":"Väljaminekud[[#This Row],[Prognoositud]]-Väljaminekud[[#This Row],[Tegelik]]","v":10}]
[null,"Kindlustus",255,255,{"$f":"Väljaminekud[[#This Row],[Prognoositud]]-Väljaminekud[[#This Row],[Tegelik]]","v":0}]
[null,"Krediitkaardid",100,100,{"$f":"Väljaminekud[[#This Row],[Prognoositud]]-Väljaminekud[[#This Row],[Tegelik]]","v":0}]
[null,"Laenud",0,0,{"$f":"Väljaminekud[[#This Row],[Prognoositud]]-Väljaminekud[[#This Row],[Tegelik]]","v":0}]
[null,"Maksud",0,0,{"$f":"Väljaminekud[[#This Row],[Prognoositud]]-Väljaminekud[[#This Row],[Tegelik]]","v":0}]
[null,"Kingitused/heategevus",150,150,{"$f":"Väljaminekud[[#This Row],[Prognoositud]]-Väljaminekud[[#This Row],[Tegelik]]","v":0}]
[null,"Säästud",225,225,{"$f":"Väljaminekud[[#This Row],[Prognoositud]]-Väljaminekud[[#This Row],[Tegelik]]","v":0}]
[null,"Muu",0,0,{"$f":"Väljaminekud[[#This Row],[Prognoositud]]-Väljaminekud[[#This Row],[Tegelik]]","v":0}]
[null,"Kokku",{"$f":"SUBTOTAL(109,Väljaminekud[Prognoositud])","v":{"v":3603,"d":"3,603"}},{"$f":"SUBTOTAL(109,Väljaminekud[Tegelik])","v":{"v":3655,"d":"3,655"}},{"$f":"SUBTOTAL(109,Väljaminekud[Hälve])","v":-52}]

{"sheet":"DIAGRAMMI ANDMED","index":3,"n_rows":6,"n_cols":4,"rows_kept":6,"hidden":true}
[null,"DIAGRAMMI ANDMED"]
[]
[null,null,"Prognoositud","Tegelik"]
[null,"Rahavoog",{"$f":"Rahavoog[[#Totals],[Prognoositud]]","v":2097},{"$f":"Rahavoog[[#Totals],[Tegelik]]","v":1845}]
[null,"Kuusissetulek",{"$f":"Sissetulekud[[#Totals],[Prognoositud]]","v":5700},{"$f":"Sissetulekud[[#Totals],[Tegelik]]","v":5500}]
[null,"Kuuväljaminek",{"$f":"Väljaminekud[[#Totals],[Prognoositud]]","v":3603},{"$f":"Väljaminekud[[#Totals],[Tegelik]]","v":3655}]