{"text_format":"3","workbook":"xlsx","n_sheets":1,"sheets":["Rahalubaduste logi"],"not_rendered":{"defined_names":3},"read":"whole","date_system":"1900"}

{"sheet":"Rahalubaduste logi","index":0,"n_rows":9,"n_cols":10,"rows_kept":9,"merged":[[5,9,7,9]]}
[null,"Rahalubaduste logi","Nimi"]
[null,"Lubatud kogusumma:",{"$f":"SUM(Andmed[Lubatud summa])","v":{"v":0,"d":"0.00 €"}}]
[null,"Kogutud kogusumma:",{"$f":"SUM(Andmed[Kogutud summa])","v":{"v":0,"d":"0.00 €"}}]
[null,"Lubaduste arv:",{"$f":"COUNT(Andmed[Lubatud summa])","v":0}]
[null,"Annetaja nimi","Annetaja telefon","Lubaduse kuupäev","Lubatud summa","Kogutud summa","Erinevus","Märkmed/aadress"]
[{"$nulls":6},{"$f":"Andmed[[#This Row],[Kogutud summa]]-Andmed[[#This Row],[Lubatud summa]]","v":{"v":0,"d":"0.00 €"}},null,null,"NÄPUNÄIDE. Veerg Erinevus arvutatakse automaatselt, see näitab kogutud summa ja lubatud summa vahet."]
[{"$nulls":6},{"$f":"Andmed[[#This Row],[Kogutud summa]]-Andmed[[#This Row],[Lubatud summa]]","v":{"v":0,"d":"0.00 €"}}]
[{"$nulls":6},{"$f":"Andmed[[#This Row],[Kogutud summa]]-Andmed[[#This Row],[Lubatud summa]]","v":{"v":0,"d":"0.00 €"}}]
[null,"Kokku",null,null,{"$f":"SUBTOTAL(109,Andmed[Lubatud summa])","v":{"v":0,"d":"0.00 €"}},{"$f":"SUBTOTAL(109,Andmed[Kogutud summa])","v":{"v":0,"d":"0.00 €"}},{"$f":"SUBTOTAL(109,Andmed[Erinevus])","v":{"v":0,"d":"0.00 €"}}]