{"text_format":"3","workbook":"xlsx","n_sheets":6,"sheets":["活动概述","支出","收入","收益项目","支出项目","名称"],"not_rendered":{"charts":1,"defined_names":19,"pivot_tables":2},"read":"whole","date_system":"1900"}

{"sheet":"活动概述","index":0,"n_rows":29,"n_cols":8,"rows_kept":29,"merged":[[0,1,1,5],[0,6,1,6],[0,7,1,7],[2,3,9,6],[3,1,3,2],[8,1,9,1],[8,2,9,2],[10,1,12,3],[10,4,12,6],[13,2,13,3],[13,4,13,5],[13,7,13,8]]}
[null,"募捐活动名称",{"$nulls":4},"名称","支出"]
[]
[null,"活动目标",null,"此单元格中具有显示实际收益和离目标所差的金额的饼图。"]
[null,{"v":5000,"d":"¥5,000.00"}]
[]
[null,"总收入",{"$f":"SUM(收入!$C$8:$C$19)","v":{"v":3400,"d":"¥3,400.00"}}]
[null,"总支出",{"$f":"SUM(支出!$C$8:$C$11)","v":{"v":230,"d":"¥230.00"}}]
[null,"实际收益",{"$f":"TOTAL_INCOME-TOTAL_EXPENDITURES","v":{"v":3170,"d":"¥3,170.00"}}]
[null,"离目标所差的金额",{"$f":"Goal_Amount-ACTUAL_INCOME","v":{"v":1830,"d":"¥1,830.00"}}]
[]
[null,"筹得总额（按姓名）",null,null,"支付费用（按名称）"]
[]
[]
[null,"按此单元格中筹款人筛选收益。","按此单元格中来源筛选收益。",null,"此单元格中具有来源筛选费用的切片器。 ",null,"此单元格中具有按消费者筛选费用的切片器。","切片器\n\n选择一个项目按这些值筛选列表。按住 Ctrl 键选择多个值。"]
[]
[null,"日期","(All)",null,null,"日期","(All)"]
[]
[null,"筹款人","收入金额",null,null,"消费者","支出金额"]
[null,"姓名 1",{"v":450,"d":"¥450.00"},null,null,"姓名 6",{"v":115,"d":"¥115.00"}]
[null,"姓名 2",{"v":50,"d":"¥50.00"},null,null,"姓名 7",{"v":45.5,"d":"¥45.50"}]
[null,"姓名 3",{"v":150,"d":"¥150.00"},null,null,"姓名 2",{"v":50,"d":"¥50.00"}]
[null,"姓名 8",{"v":550,"d":"¥550.00"},null,null,"姓名 5",{"v":19.5,"d":"¥19.50"}]
[null,"姓名 5",{"v":75,"d":"¥75.00"},null,null,"汇总",{"v":230,"d":"¥230.00"}]
[null,"姓名 4",{"v":725,"d":"¥725.00"}]
[null,"姓名 7",{"v":775,"d":"¥775.00"}]
[null,"姓名 6",{"v":350,"d":"¥350.00"}]
[null,"姓名 9",{"v":150,"d":"¥150.00"}]
[null,"姓名 10",{"v":125,"d":"¥125.00"}]
[null,"汇总",{"v":3400,"d":"¥3,400.00"}]

{"sheet":"支出","index":1,"n_rows":11,"n_cols":8,"rows_kept":11,"merged":[[0,1,1,5],[0,6,1,6],[0,7,1,7],[0,8,1,9],[3,1,5,4]]}
[null,"收入和支出",{"$nulls":4},"活动概述","收入"]
[]
[]
[null,"支出"]
[]
[]
[null,"来源","金额","日期","消费者"]
[null,"汽车租赁",{"v":115,"d":"¥115.00"},"2025-06-01","姓名 6"]
[null,"日用品",{"v":45.5,"d":"¥45.50"},"2025-06-02","姓名 7"]
[null,"日用品",{"v":50,"d":"¥50.00"},"2025-06-01","姓名 2"]
[null,"广告",{"v":19.5,"d":"¥19.50"},"2025-06-01","姓名 5"]

{"sheet":"收入","index":2,"n_rows":19,"n_cols":8,"rows_kept":19,"merged":[[0,1,1,5],[0,6,1,6],[0,7,1,7],[1,8,2,8],[3,1,5,4]]}
[null,"收入和支出",{"$nulls":4},"支出","收益项目"]
[]
[]
[null,"收入"]
[]
[]
[null,"来源","金额","日期","筹款人"]
[null,"买福利彩票",{"v":250,"d":"¥250.00"},"2025-06-01","姓名 1"]
[null,"现金捐赠",{"v":50,"d":"¥50.00"},"2025-06-01","姓名 2"]
[null,"匿名捐赠",{"v":150,"d":"¥150.00"},"2025-06-02","姓名 3"]
[null,"无声拍卖",{"v":550,"d":"¥550.00"},"2025-06-03","姓名 8"]
[null,"所售商品/服务",{"v":75,"d":"¥75.00"},"2025-06-03","姓名 5"]
[null,"现金捐赠",{"v":200,"d":"¥200.00"},"2025-06-04","姓名 1"]
[null,"匿名捐赠",{"v":500,"d":"¥500.00"},"2025-06-05","姓名 4"]
[null,"无声拍卖",{"v":775,"d":"¥775.00"},"2025-06-06","姓名 7"]
[null,"所售商品/服务",{"v":350,"d":"¥350.00"},"2025-06-08","姓名 6"]
[null,"买福利彩票",{"v":225,"d":"¥225.00"},"2025-06-09","姓名 4"]
[null,"买福利彩票",{"v":150,"d":"¥150.00"},"2025-06-11","姓名 9"]
[null,"买福利彩票",{"v":125,"d":"¥125.00"},"2025-06-11","姓名 10"]

{"sheet":"收益项目","index":3,"n_rows":11,"n_cols":5,"rows_kept":11,"merged":[[0,1,1,1],[0,2,1,2],[0,3,1,3]]}
[null,"列表","收入","支出项目"]
[{"$nulls":4}," "]
[{"$nulls":4}," "]
[null,"收益项目"]
[null,"买福利彩票"]
[null,"入场费"]
[null,"现金捐赠"]
[null,"捐赠的无声拍卖物品"]
[null,"所售商品/服务"]
[null,"匿名捐赠"]
[null,"无声拍卖"]

{"sheet":"支出项目","index":4,"n_rows":17,"n_cols":4,"rows_kept":17,"merged":[[0,1,1,1],[0,2,1,2],[0,3,1,3]]}
[null,"列表","收益项目","名称"]
[]
[]
[null,"支出项目"]
[null,"管理自愿者"]
[null,"提供自愿者"]
[null,"设施租赁"]
[null,"日用品"]
[null,"销售税"]
[null,"保险"]
[null,"营业执照"]
[null,"所售商品成本"]
[null,"汽车租赁"]
[null,"邮费"]
[null,"印刷资料"]
[null,"广告"]
[null,"商品或服务"]

{"sheet":"名称","index":5,"n_rows":14,"n_cols":4,"rows_kept":14,"merged":[[0,1,1,1],[0,2,1,2],[0,3,1,3]]}
[null,"列表","支出项目","活动概述"]
[]
[]
[null,"名称"]
[null,"姓名 1"]
[null,"姓名 2"]
[null,"姓名 3"]
[null,"姓名 4"]
[null,"姓名 5"]
[null,"姓名 6"]
[null,"姓名 7"]
[null,"姓名 8"]
[null,"姓名 9"]
[null,"姓名 10"]