{"text_format":"3","workbook":"xlsx","n_sheets":2,"sheets":["Kokkuvõte","Kingiloend"],"not_rendered":{"defined_names":10},"read":"whole","date_system":"1900"}

{"sheet":"Kokkuvõte","index":0,"n_rows":11,"n_cols":6,"rows_kept":11,"merged":[[0,1,2,1],[0,2,2,3]]}
[null,"püha","KINKIDE JÄLGIMINE",null,"EELARVE KOKKU",{"v":500,"d":"500.00 €"}]
[{"$nulls":4},"KULUNUD",{"$f":"IFERROR(SUMIFS(Kingitused[HIND],Kingitused[OSTETUD],\"Jah\"),\"\")","v":{"v":283,"d":"283.00 €"}}]
[{"$nulls":4},"EELARVEST JÄREL",{"$f":"IFERROR(Kogueelarve-F2,\"\")","v":{"v":217,"d":"217.00 €"}}]
[null,"Kas soovite eelarvet korrigeerida, kui kavandatud eelarve protsent ületab 100%? (Jah/Ei)",null,"Jah"]
[null,"SAAJA","KAVANDATUD EELARVE PROTSENT","ERALDATUD RAHA JÄREL","KAVANDATUD KINKIDE ARV","TEHA JÄÄNUD KINGID"]
[null,"Jüri",{"v":0.3,"d":"30%"},{"$f":"IFERROR(IF(Eelarve_korrigeerimine=\"Jah\",Eraldatud_Raha_Järel-SUMIFS(Kingitused[HIND],Kingitused[SAAJA],Kingisaajad[[#This Row],[SAAJA]]),(Kogueelarve*Kingisaajad[[#This Row],[KAVANDATUD EELARVE PROTSENT]])-SUMIFS(Kingitused[HIND],Kingitused[SAAJA],Kingisaajad[[#This Row],[SAAJA]])),\"\")","v":{"v":45,"d":"45.00 €"}},3,{"$f":"IFERROR(Kingisaajad[[#This Row],[KAVANDATUD KINKIDE ARV]]-COUNTIFS(Kingitused[SAAJA],Kingisaajad[[#This Row],[SAAJA]]), \"\")","v":1}]
[null,"Kristiina",{"v":0.3,"d":"30%"},{"$f":"IFERROR(IF(Eelarve_korrigeerimine=\"Jah\",Eraldatud_Raha_Järel-SUMIFS(Kingitused[HIND],Kingitused[SAAJA],Kingisaajad[[#This Row],[SAAJA]]),(Kogueelarve*Kingisaajad[[#This Row],[KAVANDATUD EELARVE PROTSENT]])-SUMIFS(Kingitused[HIND],Kingitused[SAAJA],Kingisaajad[[#This Row],[SAAJA]])),\"\")","v":{"v":54,"d":"54.00 €"}},3,{"$f":"IFERROR(Kingisaajad[[#This Row],[KAVANDATUD KINKIDE ARV]]-COUNTIFS(Kingitused[SAAJA],Kingisaajad[[#This Row],[SAAJA]]), \"\")","v":1}]
[null,"Paul",{"v":0.2,"d":"20%"},{"$f":"IFERROR(IF(Eelarve_korrigeerimine=\"Jah\",Eraldatud_Raha_Järel-SUMIFS(Kingitused[HIND],Kingitused[SAAJA],Kingisaajad[[#This Row],[SAAJA]]),(Kogueelarve*Kingisaajad[[#This Row],[KAVANDATUD EELARVE PROTSENT]])-SUMIFS(Kingitused[HIND],Kingitused[SAAJA],Kingisaajad[[#This Row],[SAAJA]])),\"\")","v":{"v":11,"d":"11.00 €"}},2,{"$f":"IFERROR(Kingisaajad[[#This Row],[KAVANDATUD KINKIDE ARV]]-COUNTIFS(Kingitused[SAAJA],Kingisaajad[[#This Row],[SAAJA]]), \"\")","v":1}]
[null,"Jaana",{"v":0.1,"d":"10%"},{"$f":"IFERROR(IF(Eelarve_korrigeerimine=\"Jah\",Eraldatud_Raha_Järel-SUMIFS(Kingitused[HIND],Kingitused[SAAJA],Kingisaajad[[#This Row],[SAAJA]]),(Kogueelarve*Kingisaajad[[#This Row],[KAVANDATUD EELARVE PROTSENT]])-SUMIFS(Kingitused[HIND],Kingitused[SAAJA],Kingisaajad[[#This Row],[SAAJA]])),\"\")","v":{"v":-1,"d":"-1.00 €"}},1,{"$f":"IFERROR(Kingisaajad[[#This Row],[KAVANDATUD KINKIDE ARV]]-COUNTIFS(Kingitused[SAAJA],Kingisaajad[[#This Row],[SAAJA]]), \"\")","v":0}]
[null,"Martin",{"v":0.1,"d":"10%"},{"$f":"IFERROR(IF(Eelarve_korrigeerimine=\"Jah\",Eraldatud_Raha_Järel-SUMIFS(Kingitused[HIND],Kingitused[SAAJA],Kingisaajad[[#This Row],[SAAJA]]),(Kogueelarve*Kingisaajad[[#This Row],[KAVANDATUD EELARVE PROTSENT]])-SUMIFS(Kingitused[HIND],Kingitused[SAAJA],Kingisaajad[[#This Row],[SAAJA]])),\"\")","v":{"v":0,"d":"0.00 €"}},1,{"$f":"IFERROR(Kingisaajad[[#This Row],[KAVANDATUD KINKIDE ARV]]-COUNTIFS(Kingitused[SAAJA],Kingisaajad[[#This Row],[SAAJA]]), \"\")","v":0}]
[null,"Kokku",{"$f":"SUM(Kingisaajad[KAVANDATUD EELARVE PROTSENT])","v":{"v":1,"d":"100%"}},{"$f":"IFERROR(SUM(Kingisaajad[ERALDATUD RAHA JÄREL]),\"\")","v":{"v":109,"d":"109.00 €"}},{"$f":"SUM(Kingisaajad[KAVANDATUD KINKIDE ARV])","v":10},{"$f":"SUM(Kingisaajad[TEHA JÄÄNUD KINGID])","v":3}]

{"sheet":"Kingiloend","index":1,"n_rows":9,"n_cols":6,"rows_kept":9}
[null,"püha","KINGILOEND"]
[null,"SAAJA","KINGITUS","HIND","OSTETUD","PAKITUD"]
[null,"Kristiina","Nukumaja",{"v":36,"d":"36.00 €"},"Jah","Jah"]
[null,"Paul","Jalgratas",{"v":89,"d":"89.00 €"},"Jah"]
[null,"Jaana","Meisterdamisvahendid",{"v":51,"d":"51.00 €"},"Jah","Jah"]
[null,"Jüri","Mängurong",{"v":48,"d":"48.00 €"}]
[null,"Jüri","Kampsun",{"v":57,"d":"57.00 €"},"Jah"]
[null,"Martin","Kinkekaart",{"v":50,"d":"50.00 €"},"Jah","Jah"]
[null,"Kristiina","Kleit",{"v":60,"d":"60.00 €"}]