{"text_format":"3","workbook":"xlsx","n_sheets":2,"sheets":["1. projekt teendőlistája","Beállítások és számítások"],"not_rendered":{"defined_names":6},"read":"whole","date_system":"1900"}

{"sheet":"1. projekt teendőlistája","index":0,"n_rows":18,"n_cols":8,"rows_kept":18,"merged":[[7,1,7,2]]}
[{"$nulls":7}," "]
[{"$nulls":7}," "]
[null,"Projekt teendőlistája"]
[]
[null,"Befejezés határideje:",null,null,"Határidő:",null,"Tevékenységek kiemelése"]
[null,"Harmath Zoltán",null,null,{"$f":"TODAY()+95","v":"2013-02-24"},null,"     Ezen a héten [jún. 18. - jún. 24.]"]
[]
[null,"1. projekt"]
[null,"Tevékenység","Esedékes","Költségvetés","% kész","Haladás","Megjegyzések"," "]
[null,"Tervezés",{"$f":"TODAY()-90","v":"2012-08-23"},{"v":476,"d":"476.00 Ft"},{"v":0.25,"d":"25%"},{"$f":"tblToDoList[[#This Row],[% kész]]","v":{"v":0.25,"d":"25%"}}]
[null,"Előkészületek",{"$f":"TODAY()-2","v":"2012-11-19"},{"v":301,"d":"301.00 Ft"},{"v":0.1,"d":"10%"},{"$f":"tblToDoList[[#This Row],[% kész]]","v":{"v":0.1,"d":"10%"}}]
[null,"A tevékenység",{"$f":"TODAY()-7","v":"2012-11-14"},{"v":429,"d":"429.00 Ft"},{"v":0,"d":"0%"},{"$f":"tblToDoList[[#This Row],[% kész]]","v":{"v":0,"d":"0%"}}]
[null,"B tevékenység",{"$f":"TODAY()+20","v":"2012-12-11"},{"v":332,"d":"332.00 Ft"},{"v":0.7,"d":"70%"},{"$f":"tblToDoList[[#This Row],[% kész]]","v":{"v":0.7,"d":"70%"}}]
[null,"C tevékenység",{"$f":"TODAY()+40","v":"2012-12-31"},{"v":471,"d":"471.00 Ft"},{"v":0.1,"d":"10%"},{"$f":"tblToDoList[[#This Row],[% kész]]","v":{"v":0.1,"d":"10%"}}]
[null,"D tevékenység",{"$f":"TODAY()+45","v":"2013-01-05"},{"v":418,"d":"418.00 Ft"},{"v":1,"d":"100%"},{"$f":"tblToDoList[[#This Row],[% kész]]","v":{"v":1,"d":"100%"}}]
[null,"Papírmunka",{"$f":"TODAY()+55","v":"2013-01-15"},{"v":150,"d":"150.00 Ft"},{"v":0,"d":"0%"},{"$f":"tblToDoList[[#This Row],[% kész]]","v":{"v":0,"d":"0%"}},"Kezdés a B tevékenység befejezésekor"]
[null,"Feladat kiadása",{"$f":"TODAY()+70","v":"2013-01-30"},{"v":330,"d":"330.00 Ft"},{"v":0.25,"d":"25%"},{"$f":"tblToDoList[[#This Row],[% kész]]","v":{"v":0.25,"d":"25%"}}]
[null,"Utólagos teendők",{"$f":"TODAY()+90","v":"2013-02-19"},{"v":353,"d":"353.00 Ft"},{"v":0.5,"d":"50%"},{"$f":"tblToDoList[[#This Row],[% kész]]","v":{"v":0.5,"d":"50%"}}]

{"sheet":"Beállítások és számítások","index":1,"n_rows":19,"n_cols":6,"rows_kept":19,"merged":[[3,1,3,4]]}
[]
[{"$nulls":5}," "]
[null,"Kiemelési beállítások"]
[null,"Az alábbi táblázatok a Tevékenységek kiemelése legördülő lista beállításait és számításait tartalmazzák. Bármilyen módosítás hibákat vagy funkciókiesést okozhat."]
[null,"Nincs kiemelés",null,null,{"$f":"B5","v":"Nincs kiemelés"}]
[null,"Intervallum:","Kezdete:","Vége:","Esedékes:"]
[null,"     Ezen a héten",{"$f":"TODAY()-WEEKDAY(TODAY(),2)+1","v":"2012-11-19"},{"$f":"C7+6","v":"2012-11-25"},{"$f":"B7&\" [\"&TEXT(C7,\"n hhh\")&\" - \"&TEXT(D7,\"n hhh\")&\"]\"","v":"     Ezen a héten [19 nov - 25 nov]"}]
[null,"     Ebben a hónapban",{"$f":"EOMONTH(TODAY(),-1)+1","v":"2012-11-01"},{"$f":"EDATE(C8,1)-1","v":"2012-11-30"},{"$f":"B8&\" [\"&TEXT(C8,\"n\")&\" - \"&TEXT(D8,\"n, hhh\")&\"]\"","v":"     Ebben a hónapban [1 - 30, nov]"}]
[null,"     Ebben a negyedévben",{"$f":"DATE(YEAR(TODAY()),INT(MONTH(TODAY())/3)+1,1)","v":"2012-04-01"},{"$f":"EDATE(C9,4)-1","v":"2012-07-31"},{"$f":"B9&\" [\"&TEXT(C9,\"d mmm\")&\" - \"&TEXT(D9,\"d mmm\")&\"]\"","v":"     Ebben a negyedévben [d 00 - d 00]"}]
[null,"     Az idei évben",{"$f":"DATE(YEAR(TODAY()),1,1)","v":"2012-01-01"},{"$f":"EDATE(C10,12)-1","v":"2012-12-31"},{"$f":"B10&\" [\"&TEXT(C10,\"éééé\")&\"]\"","v":"     Az idei évben [2012]"}]
[null,"Intervallum:",null,null,{"$f":"B11","v":"Intervallum:"}]
[null,"     Múlt héten",{"$f":"C7-7","v":"2012-11-12"},{"$f":"C12+6","v":"2012-11-18"},{"$f":"B12&\" [\"&TEXT(C12,\"n hhh\")&\" - \"&TEXT(D12,\"n hhh\")&\"]\"","v":"     Múlt héten [12 nov - 18 nov]"}]
[null,"     Múlt hónapban",{"$f":"EDATE(C8,-1)","v":"2012-10-01"},{"$f":"EDATE(C13,1)-1","v":"2012-10-31"},{"$f":"B13&\" [\"&TEXT(C13,\"n\")&\" - \"&TEXT(D13,\"n, hhh\")&\"]\"","v":"     Múlt hónapban [1 - 31, okt]"}]
[null,"     Múlt negyedévben",{"$f":"EDATE(C9,-3)","v":"2012-01-01"},{"$f":"EDATE(C14,3)-1","v":"2012-03-31"},{"$f":"B14&\" [\"&TEXT(C14,\"n hhh\")&\" - \"&TEXT(D14,\"n hhh\")&\"]\"","v":"     Múlt negyedévben [1 jan - 31 márc]"}]
[null,"     Múlt évben",{"$f":"EDATE(C10,-12)","v":"2011-01-01"},{"$f":"EDATE(C15,12)-1","v":"2011-12-31"},{"$f":"B15","v":"     Múlt évben"}]
[]
[null,"Beállított kiemelés:",{"$f":"IFERROR(MATCH(TevékenységekKiemelése,listaTeendőkKiemelve,0),\"\")","v":""},{"$f":"TevékenységekKiemelése","v":"     Ezen a héten [jún. 18. - jún. 24.]"},{"$f":"ISNUMBER(INDEX($C$6:$C$15,C17))","v":false}]
[null,"Kezdés kiemelése",{"$f":"IFERROR(IF(C17=1,\"\",IF(E17,INDEX($C$6:$C$15,$C$17),\"\")),\"\")","v":""}]
[null,"Befejezés kiemelése",{"$f":"IFERROR(IF(C17=1,\"\",IF(E17,INDEX($D$6:$D$15,$C$17),\"\")),\"\")","v":""}]