{"text_format":"3","workbook":"xlsx","n_sheets":3,"sheets":["Sledovanie osobných výdavkov","Mesačný súhrn","Údaje grafu"],"not_rendered":{"charts":2,"defined_names":8,"pivot_tables":2},"read":"whole","date_system":"1900"}

{"sheet":"Sledovanie osobných výdavkov","index":0,"n_rows":22,"n_cols":7,"rows_kept":22,"merged":[[8,3,8,6],[18,1,19,1],[20,1,22,1]]}
[null,"Sledovanie osobných výdavkov"]
[]
[{"$nulls":3},"Prehľad výdavkov v hotovosti"]
[{"$nulls":3},"Účet","Počiatočná hotovosť","Výdavky celkom","Zostatok hotovosti"]
[{"$nulls":3},"Bežný účet",{"v":3000,"d":"3000.00"},{"$f":"SUMIF('Sledovanie osobných výdavkov'!$G$12:$G$22,\"=\" &TabuľkaPrehľadVýdavkovVHotovosti[[#This Row],[Účet]],'Sledovanie osobných výdavkov'!$F$12:$F$22)","v":{"v":428,"d":"428.00"}},{"$f":"TabuľkaPrehľadVýdavkovVHotovosti[[#This Row],[Počiatočná hotovosť]]-TabuľkaPrehľadVýdavkovVHotovosti[[#This Row],[Výdavky celkom]]","v":{"v":2572,"d":"2572.00"}}]
[{"$nulls":3},"Sporiaci účet",{"v":500,"d":"500.00"},{"$f":"SUMIF('Sledovanie osobných výdavkov'!$G$12:$G$22,\"=\" &TabuľkaPrehľadVýdavkovVHotovosti[[#This Row],[Účet]],'Sledovanie osobných výdavkov'!$F$12:$F$22)","v":{"v":450,"d":"450.00"}},{"$f":"TabuľkaPrehľadVýdavkovVHotovosti[[#This Row],[Počiatočná hotovosť]]-TabuľkaPrehľadVýdavkovVHotovosti[[#This Row],[Výdavky celkom]]","v":{"v":50,"d":"50.00"}}]
[{"$nulls":3},"Iné",{"v":200,"d":"200.00"},{"$f":"SUMIF('Sledovanie osobných výdavkov'!$G$12:$G$22,\"=\" &TabuľkaPrehľadVýdavkovVHotovosti[[#This Row],[Účet]],'Sledovanie osobných výdavkov'!$F$12:$F$22)","v":{"v":30,"d":"30.00"}},{"$f":"TabuľkaPrehľadVýdavkovVHotovosti[[#This Row],[Počiatočná hotovosť]]-TabuľkaPrehľadVýdavkovVHotovosti[[#This Row],[Výdavky celkom]]","v":{"v":170,"d":"170.00"}}]
[{"$nulls":3},"Celkom",{"$f":"SUBTOTAL(109,TabuľkaPrehľadVýdavkovVHotovosti[Počiatočná hotovosť])","v":{"v":3700,"d":"3700.00"}},{"$f":"SUBTOTAL(109,TabuľkaPrehľadVýdavkovVHotovosti[Výdavky celkom])","v":{"v":908,"d":"908.00"}},{"$f":"SUBTOTAL(109,TabuľkaPrehľadVýdavkovVHotovosti[Zostatok hotovosti])","v":{"v":2792,"d":"2792.00"}}]
[]
[{"$nulls":3},"Výdavky v hotovosti"]
[{"$nulls":3},"Dátum","Popis","Čiastka","Účet"]
[{"$nulls":3},"2012-01-04","Výber z bankomatu",{"v":40,"d":"40.00"},"Bežný účet"]
[{"$nulls":3},"2012-01-05","Obed",{"v":5,"d":"5.00"},"Bežný účet"]
[{"$nulls":3},"2012-01-06","Splátka za auto",{"v":230,"d":"230.00"},"Sporiaci účet"]
[{"$nulls":3},"2012-02-03","Platba za elektrinu",{"v":70,"d":"70.00"},"Bežný účet"]
[{"$nulls":3},"2012-02-07","Večera",{"v":53,"d":"53.00"},"Bežný účet"]
[{"$nulls":3},"2012-03-01","Výber v hotovosti",{"v":100,"d":"100.00"},"Sporiaci účet"]
[{"$nulls":3},"2012-03-06","Splátka za auto",{"v":230,"d":"230.00"},"Bežný účet"]
[null,"Zostatok hotovosti:",null,"2012-04-06","Platba za elektrinu",{"v":70,"d":"70.00"},"Sporiaci účet"]
[{"$nulls":3},"2012-04-20","Výber z bankomatu",{"v":30,"d":"30.00"},"Bežný účet"]
[null,{"$f":"TabuľkaPrehľadVýdavkovVHotovosti[[#Totals],[Zostatok hotovosti]]/TabuľkaPrehľadVýdavkovVHotovosti[[#Totals],[Počiatočná hotovosť]]","v":{"v":0.7545945945945945,"d":"75%"}},null,"2012-05-03","Výber z bankomatu",{"v":50,"d":"50.00"},"Sporiaci účet"]
[{"$nulls":3},"2012-05-10","Výber z bankomatu",{"v":30,"d":"30.00"},"Iné"]

{"sheet":"Mesačný súhrn","index":1,"n_rows":26,"n_cols":11,"rows_kept":26}
[null,"Mesačný súhrn"]
[null,"Celkový prehľad transakcií na účte"]
[]
[]
[]
[]
[{"$nulls":10},"1900-01-12"]
{"$rows_empty":8}
[null,"Prehľad výdavkov"]
[null,"Podrobnosti"]
[null,null,"Bežný účet","Sporiaci účet","Iné","Celkový súčet"]
[null,"1",{"v":45,"d":"45.00"},{"v":230,"d":"230.00"},null,{"v":275,"d":"275.00"}]
[null,"2",{"v":123,"d":"123.00"},null,null,{"v":123,"d":"123.00"}]
[null,"3",{"v":230,"d":"230.00"},{"v":100,"d":"100.00"},null,{"v":330,"d":"330.00"}]
[null,"Splátka za auto",{"v":230,"d":"230.00"},null,null,{"v":230,"d":"230.00"}]
[null,"Výber v hotovosti",null,{"v":100,"d":"100.00"},null,{"v":100,"d":"100.00"}]
[null,"4",{"v":30,"d":"30.00"},{"v":70,"d":"70.00"},null,{"v":100,"d":"100.00"}]
[null,"5",null,{"v":50,"d":"50.00"},{"v":30,"d":"30.00"},{"v":80,"d":"80.00"}]
[null,"Celkový súčet",{"v":428,"d":"428.00"},{"v":450,"d":"450.00"},{"v":30,"d":"30.00"},{"v":908,"d":"908.00"}]

{"sheet":"Údaje grafu","index":2,"n_rows":10,"n_cols":6,"rows_kept":10}
[null,"Údaje kontingenčného grafu"]
[null,"Táto kontingenčná tabuľka je zdrojom údajov pre kontingenčný graf Celkový prehľad transakcií na účte, ktorý sa nachádza v hárku Mesačný súhrn."]
[null,"Súčet z Čiastka","Menovky stĺpcov"]
[null,"Menovky riadkov","Bežný účet","Sporiaci účet","Iné","Celkový súčet"]
[null,"1",{"v":45,"d":"45.00"},{"v":230,"d":"230.00"},null,{"v":275,"d":"275.00"}]
[null,"2",{"v":123,"d":"123.00"},null,null,{"v":123,"d":"123.00"}]
[null,"3",{"v":230,"d":"230.00"},{"v":100,"d":"100.00"},null,{"v":330,"d":"330.00"}]
[null,"4",{"v":30,"d":"30.00"},{"v":70,"d":"70.00"},null,{"v":100,"d":"100.00"}]
[null,"5",null,{"v":50,"d":"50.00"},{"v":30,"d":"30.00"},{"v":80,"d":"80.00"}]
[null,"Celkový súčet",{"v":428,"d":"428.00"},{"v":450,"d":"450.00"},{"v":30,"d":"30.00"},{"v":908,"d":"908.00"}]