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

{"sheet":"Pledge Log","index":0,"n_rows":9,"n_cols":10,"rows_kept":9}
[null,"Pledge Log for","Name"]
[null,"Total amount pledged:",{"$f":"SUM(Data[Pledged amount])","v":{"v":0,"d":"$0.00"}}]
[null,"Total amount collected:",{"$f":"SUM(Data[Collected amount])","v":{"v":0,"d":"$0.00"}}]
[null,"Number of pledges:",{"$f":"COUNT(Data[Pledged amount])","v":{"v":0,"d":"0 "}}]
[null,"Donor name","Donor phone","Date of pledge","Pledged amount","Collected amount","Difference","Notes/Address"]
[{"$nulls":6},{"$f":"Data[[#This Row],[Collected amount]]-Data[[#This Row],[Pledged amount]]","v":{"v":0,"d":"$0.00"}},null,null,"TIP: The Difference column is automatically calculated for you, showing Collected minus Pledged amount."]
[{"$nulls":6},{"$f":"Data[[#This Row],[Collected amount]]-Data[[#This Row],[Pledged amount]]","v":{"v":0,"d":"$0.00"}}]
[{"$nulls":6},{"$f":"Data[[#This Row],[Collected amount]]-Data[[#This Row],[Pledged amount]]","v":{"v":0,"d":"$0.00"}}]
[null,"Total",null,null,{"$f":"SUBTOTAL(109,Data[Pledged amount])","v":{"v":0,"d":"$0.00"}},{"$f":"SUBTOTAL(109,Data[Collected amount])","v":{"v":0,"d":"$0.00"}},{"$f":"SUBTOTAL(109,Data[Difference])","v":{"v":0,"d":"$0.00"}}]