{"text_format":"3","workbook":"xlsx","n_sheets":2,"sheets":["Kulud","Kategooria"],"not_rendered":{"defined_names":5},"read":"whole","date_system":"1900"}

{"sheet":"Kulud","index":0,"n_rows":25,"n_cols":7,"rows_kept":25,"merged":[[0,1,0,5],[1,1,1,6]]}
[null,"KULUDE EELARVE",{"$nulls":4},{"$f":"TODAY()","v":"2018-06-18"}]
[null,"Ettevõtte nimi"]
[null,"Kulu","Kategooria","Eelarve","Tegelik","Erinevus (€)","Erinevus (%)"]
[null,"Reklaam","Tegevus-",null,null,{"$f":"IFERROR(SUM(Kulud[Eelarve]-Kulud[Tegelik]), \"\")","v":0},{"$f":"IFERROR(SUM(Kulud[Erinevus (€)]/Kulud[Eelarve]),\"\")","v":""}]
[null,"Võlgnevused","Tegevus-",null,null,{"$f":"IFERROR(SUM(Kulud[Eelarve]-Kulud[Tegelik]), \"\")","v":0},{"$f":"IFERROR(SUM(Kulud[Erinevus (€)]/Kulud[Eelarve]),\"\")","v":""}]
[null,"Soodustused","Tegevus-",null,null,{"$f":"IFERROR(SUM(Kulud[Eelarve]-Kulud[Tegelik]), \"\")","v":0},{"$f":"IFERROR(SUM(Kulud[Erinevus (€)]/Kulud[Eelarve]),\"\")","v":""}]
[null,"Tarbeesemed","Tegevus-",null,null,{"$f":"IFERROR(SUM(Kulud[Eelarve]-Kulud[Tegelik]), \"\")","v":0},{"$f":"IFERROR(SUM(Kulud[Erinevus (€)]/Kulud[Eelarve]),\"\")","v":""}]
[null,"Postikulu","Tegevus-",null,null,{"$f":"IFERROR(SUM(Kulud[Eelarve]-Kulud[Tegelik]), \"\")","v":0},{"$f":"IFERROR(SUM(Kulud[Erinevus (€)]/Kulud[Eelarve]),\"\")","v":""}]
[null,"Üür või hüpoteek","Tegevus-",null,null,{"$f":"IFERROR(SUM(Kulud[Eelarve]-Kulud[Tegelik]), \"\")","v":0},{"$f":"IFERROR(SUM(Kulud[Erinevus (€)]/Kulud[Eelarve]),\"\")","v":""}]
[null,"Müügikulud","Tegevus-",null,null,{"$f":"IFERROR(SUM(Kulud[Eelarve]-Kulud[Tegelik]), \"\")","v":0},{"$f":"IFERROR(SUM(Kulud[Erinevus (€)]/Kulud[Eelarve]),\"\")","v":""}]
[null,"Maksud","Tegevus-",null,null,{"$f":"IFERROR(SUM(Kulud[Eelarve]-Kulud[Tegelik]), \"\")","v":0},{"$f":"IFERROR(SUM(Kulud[Erinevus (€)]/Kulud[Eelarve]),\"\")","v":""}]
[null,"Kommunaalid","Tegevus-",null,null,{"$f":"IFERROR(SUM(Kulud[Eelarve]-Kulud[Tegelik]), \"\")","v":0},{"$f":"IFERROR(SUM(Kulud[Erinevus (€)]/Kulud[Eelarve]),\"\")","v":""}]
[null,"Muu","Tegevus-",null,null,{"$f":"IFERROR(SUM(Kulud[Eelarve]-Kulud[Tegelik]), \"\")","v":0},{"$f":"IFERROR(SUM(Kulud[Erinevus (€)]/Kulud[Eelarve]),\"\")","v":""}]
[null,"Kindlustus","Tegevus-",null,null,{"$f":"IFERROR(SUM(Kulud[Eelarve]-Kulud[Tegelik]), \"\")","v":0},{"$f":"IFERROR(SUM(Kulud[Erinevus (€)]/Kulud[Eelarve]),\"\")","v":""}]
[null,"Intress","Tegevus-",null,null,{"$f":"IFERROR(SUM(Kulud[Eelarve]-Kulud[Tegelik]), \"\")","v":0},{"$f":"IFERROR(SUM(Kulud[Erinevus (€)]/Kulud[Eelarve]),\"\")","v":""}]
[null,"Telefoninumber","Tegevus-",null,null,{"$f":"IFERROR(SUM(Kulud[Eelarve]-Kulud[Tegelik]), \"\")","v":0},{"$f":"IFERROR(SUM(Kulud[Erinevus (€)]/Kulud[Eelarve]),\"\")","v":""}]
[null,"Hooldus ja remont","Tegevus-",null,null,{"$f":"IFERROR(SUM(Kulud[Eelarve]-Kulud[Tegelik]), \"\")","v":0},{"$f":"IFERROR(SUM(Kulud[Erinevus (€)]/Kulud[Eelarve]),\"\")","v":""}]
[null,"Õigusabikulud","Tegevus-",null,null,{"$f":"IFERROR(SUM(Kulud[Eelarve]-Kulud[Tegelik]), \"\")","v":0},{"$f":"IFERROR(SUM(Kulud[Erinevus (€)]/Kulud[Eelarve]),\"\")","v":""}]
[null,"Amortisatsioon","Tegevus-",null,null,{"$f":"IFERROR(SUM(Kulud[Eelarve]-Kulud[Tegelik]), \"\")","v":0},{"$f":"IFERROR(SUM(Kulud[Erinevus (€)]/Kulud[Eelarve]),\"\")","v":""}]
[null,"Tarnimine","Tegevus-",null,null,{"$f":"IFERROR(SUM(Kulud[Eelarve]-Kulud[Tegelik]), \"\")","v":0},{"$f":"IFERROR(SUM(Kulud[Erinevus (€)]/Kulud[Eelarve]),\"\")","v":""}]
[null,"Ladustamine","Tegevus-",null,null,{"$f":"IFERROR(SUM(Kulud[Eelarve]-Kulud[Tegelik]), \"\")","v":0},{"$f":"IFERROR(SUM(Kulud[Erinevus (€)]/Kulud[Eelarve]),\"\")","v":""}]
[null,"Pood","Isiklik",null,null,{"$f":"IFERROR(SUM(Kulud[Eelarve]-Kulud[Tegelik]), \"\")","v":0},{"$f":"IFERROR(SUM(Kulud[Erinevus (€)]/Kulud[Eelarve]),\"\")","v":""}]
[null,"Müüjad","Isiklik",null,null,{"$f":"IFERROR(SUM(Kulud[Eelarve]-Kulud[Tegelik]), \"\")","v":0},{"$f":"IFERROR(SUM(Kulud[Erinevus (€)]/Kulud[Eelarve]),\"\")","v":""}]
[null,"Muu","Isiklik",null,null,{"$f":"IFERROR(SUM(Kulud[Eelarve]-Kulud[Tegelik]), \"\")","v":0},{"$f":"IFERROR(SUM(Kulud[Erinevus (€)]/Kulud[Eelarve]),\"\")","v":""}]
[null,"Kogukulu",null,{"$f":"IFERROR(SUM(Kulud[Eelarve]), \"\")","v":0},{"$f":"IFERROR(SUM(Kulud[Tegelik]), \"\")","v":0},{"$f":"IFERROR(SUM(Kulud[Erinevus (€)]), \"\")","v":0},{"$f":"IFERROR(SUM(Kulud[[#Totals],[Erinevus (€)]]/Kulud[[#Totals],[Eelarve]]),\"\")","v":""}]

{"sheet":"Kategooria","index":1,"n_rows":4,"n_cols":2,"rows_kept":4}
[null,"Kategooria otsing"]
[null,"Kategooria"]
[null,"Tegevus-"]
[null,"Isiklik"]