{"text_format":"3","workbook":"xlsx","n_sheets":1,"sheets":["認捐記錄"],"not_rendered":{"defined_names":3},"read":"whole","date_system":"1900"}

{"sheet":"認捐記錄","index":0,"n_rows":9,"n_cols":10,"rows_kept":9,"merged":[[5,9,7,9]]}
[null,"姓名","的認捐記錄"]
[null,"總認捐金額：",{"$f":"SUM(資料[認捐金額])","v":{"v":0,"d":"NT$0.00"}}]
[null,"總募捐金額：",{"$f":"SUM(資料[募捐金額])","v":{"v":0,"d":"NT$0.00"}}]
[null,"認捐人數：",{"$f":"COUNT(資料[認捐金額])","v":0}]
[null,"捐贈者姓名","捐贈者電話","認捐日期","認捐金額","募捐金額","差額","附註/地址"]
[{"$nulls":6},{"$f":"資料[[#This Row],[募捐金額]]-資料[[#This Row],[認捐金額]]","v":{"v":0,"d":"NT$0.00"}},null,null,"提示：系統會自動為您計算 [差額] 欄，顯示募捐減去認捐後的金額。"]
[{"$nulls":6},{"$f":"資料[[#This Row],[募捐金額]]-資料[[#This Row],[認捐金額]]","v":{"v":0,"d":"NT$0.00"}}]
[{"$nulls":6},{"$f":"資料[[#This Row],[募捐金額]]-資料[[#This Row],[認捐金額]]","v":{"v":0,"d":"NT$0.00"}}]
[null,"總計",null,null,{"$f":"SUBTOTAL(109,資料[認捐金額])","v":{"v":0,"d":"NT$0.00"}},{"$f":"SUBTOTAL(109,資料[募捐金額])","v":{"v":0,"d":"NT$0.00"}},{"$f":"SUBTOTAL(109,資料[差額])","v":{"v":0,"d":"NT$0.00"}}]