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

{"sheet":"Pledge Log","index":0,"n_rows":12,"n_cols":8,"rows_kept":12}
[]
[null,"Pledge Log for [Name]"]
[]
[null,"Total amount pledged:",{"$f":"SUM(tblData[Pledged amount])","v":{"v":0,"d":"$0.00"}}]
[null,"Total amount collected:",{"$f":"SUM(tblData[Collected amount])","v":{"v":0,"d":"$0.00"}}]
[null,"Number of pledges",{"$f":"COUNT(tblData[Pledged amount])","v":0}]
[]
[null,"Donor name","Donor phone","Date of pledge","Pledged amount","Collected amount","Difference","Notes/Address"]
[{"$nulls":6},{"$f":"tblData[[#This Row],[Collected amount]]-tblData[[#This Row],[Pledged amount]]","v":{"v":0,"d":"$0.00"}}]
[{"$nulls":6},{"$f":"tblData[[#This Row],[Collected amount]]-tblData[[#This Row],[Pledged amount]]","v":{"v":0,"d":"$0.00"}}]
[{"$nulls":6},{"$f":"tblData[[#This Row],[Collected amount]]-tblData[[#This Row],[Pledged amount]]","v":{"v":0,"d":"$0.00"}}]
[null,"Total",null,null,{"$f":"SUBTOTAL(109,tblData[Pledged amount])","v":{"v":0,"d":"$0.00"}},{"$f":"SUBTOTAL(109,tblData[Collected amount])","v":{"v":0,"d":"$0.00"}},{"$f":"SUBTOTAL(109,tblData[Difference])","v":{"v":0,"d":"$0.00"}}]