{"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":26,"n_cols":7,"rows_kept":26,"merged":[[0,0,0,3]]}
["Pledge Log for [Name]"]
["Total amount pledged:",{"$f":"D26","v":{"v":0,"d":"$0.00"}},"Total amount collected:",{"$f":"E26","v":{"v":0,"d":"$0.00"}}]
["Donor name","Donor phone","Date of pledge","Pledged Amount","Collected Amount","Difference","Notes/Address"]
[{"$nulls":5},{"$f":"E4-D4","v":{"v":0,"d":"$0.00"}}]
[{"$nulls":5},{"v":0,"d":"$0.00"}]
[{"$nulls":5},{"v":0,"d":"$0.00"}]
[{"$nulls":5},{"v":0,"d":"$0.00"}]
[{"$nulls":5},{"v":0,"d":"$0.00"}]
[{"$nulls":5},{"v":0,"d":"$0.00"}]
[{"$nulls":5},{"v":0,"d":"$0.00"}]
[{"$nulls":5},{"v":0,"d":"$0.00"}]
[{"$nulls":5},{"v":0,"d":"$0.00"}]
[{"$nulls":5},{"v":0,"d":"$0.00"}]
[{"$nulls":5},{"v":0,"d":"$0.00"}]
[{"$nulls":5},{"v":0,"d":"$0.00"}]
[{"$nulls":5},{"v":0,"d":"$0.00"}]
[{"$nulls":5},{"v":0,"d":"$0.00"}]
[{"$nulls":5},{"v":0,"d":"$0.00"}]
[{"$nulls":5},{"v":0,"d":"$0.00"}]
[{"$nulls":5},{"v":0,"d":"$0.00"}]
[{"$nulls":5},{"v":0,"d":"$0.00"}]
[{"$nulls":5},{"v":0,"d":"$0.00"}]
[{"$nulls":5},{"v":0,"d":"$0.00"}]
[{"$nulls":5},{"v":0,"d":"$0.00"}]
[{"$nulls":5},{"v":0,"d":"$0.00"}]
[{"$f":"\"Number of pledges = \"&COUNT(D4:D25)","v":"Number of pledges = 0"},null,null,{"$f":"SUBTOTAL(109,Table1[Pledged Amount])","v":{"v":0,"d":"$0.00"}},{"$f":"SUBTOTAL(109,Table1[Collected Amount])","v":{"v":0,"d":"$0.00"}},{"$f":"SUBTOTAL(109,Table1[Difference])","v":{"v":0,"d":"$0.00"}}]