{"text_format":"3","workbook":"xlsx","n_sheets":4,"sheets":["開始","支出","收入","摘要"],"not_rendered":{"charts":1,"defined_names":2},"read":"whole","date_system":"1900"}

{"sheet":"開始","index":0,"n_rows":8,"n_cols":2,"rows_kept":8}
[null,"關於此範本"]
[null,"這個活動預算表活頁簿可用來追蹤活動過程所產生的支出和收入。"]
[null,"填入活動名稱，並在 [支出] 工作表和 [收入] 工作表中的表格中輸入相關詳細資料。"]
[null,"工作表會自動計算總支出和總收入。"]
[null,"損益摘要和圖表會於 [摘要] 工作表中自動更新。"]
[null,"附註： "]
[null,"我們已在每張工作表的 A 欄提供額外指示。此文字已刻意隱藏。若要移除文字，請選取欄 A，然後選取 [刪除]。若要取消隱藏文字，請選取 A 欄，然後變更字型色彩。"]
[null,"若要深入了解表格，請在表格內按 SHIFT 並按 F10，選取 [表格] 選項，然後選取 [替代文字]。"]

{"sheet":"支出","index":1,"n_rows":33,"n_cols":8,"rows_kept":33,"merged":[[0,5,0,7],[1,1,1,7],[2,6,2,7]]}
["在此工作表的個別表格中輸入各類別的預估與實際支出。工作表會自動計算總支出。此欄的儲存格為如何使用此工作表的實用指示。按向下鍵就能開始使用。"]
["在右側儲存格中輸入活動名稱，以自訂這個工作表和其他工作表的標題。","活動預算表\n活動名稱"]
["儲存格 G3 是 [支出] 標籤。",{"$nulls":5}," 支出"]
["儲存格 G4 是 [預估支出] 標籤，而儲存格 H4 是 [實際支出] 標籤。",{"$nulls":5},"預估","實際"]
["右側儲存格是 [總支出] 標籤。儲存格 G5 會自動計算預估總支出。儲存格 H5 會自動更新 [實際總支出 ] 和描述 [實際總支出] 的資料列。下一個指示在儲存格 A7。","總支出",{"$nulls":4},{"$f":"SUM(C12,C20,C26,C33,G12,G20,G25)","v":{"v":1145,"d":"NT$1,145.00"}},{"$f":"SUM(D12,D20,D26,D33,H12,H20,H25)","v":{"v":395,"d":"NT$395.00"}}]
[]
["在從右側儲存格開始的表格中輸入場地相關支出，並在從儲存格 F7 開始的表格中輸入茶點相關支出。下一個指示在儲存格 A14。","場地","預估","實際",null,"茶點","預估","實際"]
[null,"會議室和禮堂地費",{"v":500,"d":"NT$500.00"},{"v":250,"d":"NT$250.00"},null,"食物"]
[null,"現場工作人員",{"v":400,"d":"NT$400.00"},{"v":50,"d":"NT$50.00"},null,"飲料"]
[null,"設備",{"$nulls":3},"桌巾"]
[null,"桌椅",{"$nulls":3},"工作人員和小費"]
[null,"合計",{"$f":"SUBTOTAL(109,場地支出[預估])","v":{"v":900,"d":"NT$900.00"}},{"$f":"SUBTOTAL(109,場地支出[實際])","v":{"v":300,"d":"NT$300.00"}},null,"合計",{"$f":"SUBTOTAL(109,茶點支出[預估])","v":{"v":0,"d":"NT$0.00"}},{"$f":"SUBTOTAL(109,茶點支出[實際])","v":{"v":0,"d":"NT$0.00"}}]
[]
["在從右側儲存格開始的表格中輸入佈置裝飾相關支出，並在從儲存格 F14 開始的表格中輸入節目相關支出。下一個指示在儲存格 22。","佈置裝飾","預估","實際",null,"節目","預估","實際"]
[null,"花飾",{"v":200,"d":"NT$200.00"},{"v":50,"d":"NT$50.00"},null,"表演者"]
[null,"蠟燭",{"$nulls":3},"演講者"]
[null,"燈光",{"$nulls":3},"旅遊"]
[null,"氣球",{"$nulls":3},"住宿費"]
[null,"紙類用品",{"$nulls":3},"其他"]
[null,"合計",{"$f":"SUBTOTAL(109,佈置裝飾支出[預估])","v":{"v":200,"d":"NT$200.00"}},{"$f":"SUBTOTAL(109,佈置裝飾支出[實際])","v":{"v":50,"d":"NT$50.00"}},null,"合計",{"$f":"SUBTOTAL(109,節目支出[預估])","v":{"v":0,"d":"NT$0.00"}},{"$f":"SUBTOTAL(109,節目支出[實際])","v":{"v":0,"d":"NT$0.00"}}]
[]
["在從右側儲存格開始的表格中開始輸入宣傳相關支出，並在從儲存格 F22 開始的表格中輸入獎品相關支出。下一個指示在儲存格 A28。","宣傳","預估","實際",null,"獎品","預估","實際"]
[null,"平面設計",{"v":45,"d":"NT$45.00"},{"v":45,"d":"NT$45.00"},null,"獎徽/獎牌/獎盃"]
[null,"影印/列印",{"$nulls":3},"禮物"]
[null,"郵資",{"$nulls":3},"合計",{"$f":"SUBTOTAL(109,獎品支出[預估])","v":{"v":0,"d":"NT$0.00"}},{"$f":"SUBTOTAL(109,獎品支出[實際])","v":{"v":0,"d":"NT$0.00"}}]
[null,"合計",{"$f":"SUBTOTAL(109,宣傳支出[預估])","v":{"v":45,"d":"NT$45.00"}},{"$f":"SUBTOTAL(109,宣傳支出[實際])","v":{"v":45,"d":"NT$45.00"}}]
[]
["在從右側儲存格開始的表格中輸入雜項支出。","其他","預估","實際"]
[null,"電話"]
[null,"交通"]
[null,"文具用品"]
[null,"傳真服務"]
[null,"合計",{"$f":"SUBTOTAL(109,雜項支出[預估])","v":{"v":0,"d":"NT$0.00"}},{"$f":"SUBTOTAL(109,雜項支出[實際])","v":{"v":0,"d":"NT$0.00"}}]

{"sheet":"收入","index":2,"n_rows":30,"n_cols":7,"rows_kept":30,"merged":[[1,1,1,6],[2,5,2,6]]}
["在這個工作表的個別表格中輸入各類別的預估與實際收入。工作表會自動計算總收入。此欄的儲存格為如何使用此工作表的實用指示。按向下鍵就能開始使用。"]
["工作表會自動更新右側儲存格中的活動名稱。",{"$f":"支出!B2","v":"活動預算表\n活動名稱"}]
["儲存格 F3 是 [收入] 標籤。",{"$nulls":4}," 收入"]
["儲存格 F4 是 [預估支出] 標籤，而儲存格 G4 是 [實際支出] 標籤。",{"$nulls":4},"預估","實際"]
["右側儲存格是 [總收入] 標籤。儲存格 F5 會自動計算預估總收入。儲存格 G5 會自動更新 [實際總收入 ] 和描述 [實際總收入] 的資料列。","總收入",{"$nulls":3},{"$f":"SUM(門票[[#Totals],[預估總計]],計劃中的廣告[[#Totals],[預估總計]],參展者和廠商[[#Totals],[預估總計]],物品銷售[[#Totals],[預估總計]])","v":{"v":1936,"d":"NT$1,936.00"}},{"$f":"SUM(門票[[#Totals],[實際總計]],計劃中的廣告[[#Totals],[實際總計]],參展者和廠商[[#Totals],[實際總計]],物品銷售[[#Totals],[實際總計]])","v":{"v":1831,"d":"NT$1,831.00"}}]
["右側儲存格是 [門票] 標籤。","門票"]
["在從右側儲存格開始的表格中輸入預估和實際的門票數和票價。工作表會自動計算門票帶來的預估和實際收入。下一個指示位於儲存格 A12。","預估","實際","類型","價格","預估總計","實際總計"]
[null,300,278,"成人 @",{"v":5,"d":"NT$5.00"},{"$f":"B8*E8","v":{"v":1500,"d":"NT$1,500.00"}},{"$f":"C8*E8","v":{"v":1390,"d":"NT$1,390.00"}}]
[null,197,195,"兒童 @",{"v":2,"d":"NT$2.00"},{"$f":"B9*E9","v":{"v":394,"d":"NT$394.00"}},{"$f":"C9*E9","v":{"v":390,"d":"NT$390.00"}}]
[null,42,51,"其他 @",{"v":1,"d":"NT$1.00"},{"v":42,"d":"NT$42.00"},{"v":51,"d":"NT$51.00"}]
[null," ",{"$nulls":3},{"$f":"SUBTOTAL(109,門票[預估總計])","v":{"v":1936,"d":"NT$1,936.00"}},{"$f":"SUBTOTAL(109,門票[實際總計])","v":{"v":1831,"d":"NT$1,831.00"}}]
["右側儲存格是 [節目廣告] 標籤。","節目廣告"]
["在從右側儲存格開始的表格中輸入預估和實際的節目廣告數和廣告費用。工作表會自動計算廣告帶來的預估和實際收入。下一個指示在儲存格 A18。","預估","實際","類型","價格","預估總計","實際總計"]
[{"$nulls":3},"封面 @",null,{"$f":"B14*E14","v":{"v":0,"d":"NT$0.00"}},{"$f":"C14*E14","v":{"v":0,"d":"NT$0.00"}}]
[{"$nulls":3},"半版 @",null,{"$f":"B15*E15","v":{"v":0,"d":"NT$0.00"}},{"$f":"C15*E15","v":{"v":0,"d":"NT$0.00"}}]
[{"$nulls":3},"1/4 版 @",null,{"v":0,"d":"NT$0.00"},{"v":0,"d":"NT$0.00"}]
[null," ",{"$nulls":3},{"$f":"SUBTOTAL(109,計劃中的廣告[預估總計])","v":{"v":0,"d":"NT$0.00"}},{"$f":"SUBTOTAL(109,計劃中的廣告[實際總計])","v":{"v":0,"d":"NT$0.00"}}]
["右側儲存格是參展商或廠商。","參展商/廠商"]
["在從右側儲存格開始的表格中輸入預估和實際的參展商和廠商數以及攤位費用。工作表會自動計算預估和實際收入。下一個指示在儲存格 A24。","預估","實際","類型","價格","預估總計","實際總計"]
[{"$nulls":3},"大型攤位 @",null,{"$f":"B20*E20","v":{"v":0,"d":"NT$0.00"}},{"$f":"C20*E20","v":{"v":0,"d":"NT$0.00"}}]
[{"$nulls":3},"中型攤位 @",null,{"$f":"B21*E21","v":{"v":0,"d":"NT$0.00"}},{"$f":"C21*E21","v":{"v":0,"d":"NT$0.00"}}]
[{"$nulls":3},"小型攤位 @",null,{"v":0,"d":"NT$0.00"},{"v":0,"d":"NT$0.00"}]
[null," ",{"$nulls":3},{"$f":"SUBTOTAL(109,參展者和廠商[預估總計])","v":{"v":0,"d":"NT$0.00"}},{"$f":"SUBTOTAL(109,參展者和廠商[實際總計])","v":{"v":0,"d":"NT$0.00"}}]
["右側儲存格是 [銷售項目] 標籤。","銷售項目"]
["在從右側儲存格開始的表格中輸入預估和實際售出的項目數和項目金額。工作表會自動計算預估和實際收入。","預估","實際","類型","價格","預估總計","實際總計"]
[{"$nulls":3},"項目 @",null,{"$f":"B26*E26","v":{"v":0,"d":"NT$0.00"}},{"$f":"C26*E26","v":{"v":0,"d":"NT$0.00"}}]
[{"$nulls":3},"項目 @",null,{"$f":"B27*E27","v":{"v":0,"d":"NT$0.00"}},{"$f":"C27*E27","v":{"v":0,"d":"NT$0.00"}}]
[{"$nulls":3},"項目 @",null,{"v":0,"d":"NT$0.00"},{"v":0,"d":"NT$0.00"}]
[{"$nulls":3},"項目 @",null,{"v":0,"d":"NT$0.00"},{"v":0,"d":"NT$0.00"}]
[null," ",{"$nulls":3},{"$f":"SUBTOTAL(109,物品銷售[預估總計])","v":{"v":0,"d":"NT$0.00"}},{"$f":"SUBTOTAL(109,物品銷售[實際總計])","v":{"v":0,"d":"NT$0.00"}}]

{"sheet":"摘要","index":3,"n_rows":9,"n_cols":4,"rows_kept":9,"merged":[[1,1,1,3],[2,2,2,3],[8,1,8,4],[9,1,9,3]]}
["工作表會自動計算顯示總收入和總支出的 [損益摘要] 和 [圖表]。此欄的儲存格為如何使用此工作表的實用指示。按向下鍵就能開始使用。"]
["工作表會自動更新右側儲存格中的活動名稱。",{"$f":"支出!B2","v":"活動預算表\n活動名稱"}]
["[損益摘要] 標籤在儲存格 C3。下一個指示在儲存格 A5。",null,"損益摘要"]
[]
["從右側儲存格開始的 [總計] 表格會自動更新。下一個指示在儲存格 A9。","總計","預估","實際"]
[null,"總收入",{"$f":"收入!F5","v":{"v":1936,"d":"NT$1,936.00"}},{"$f":"收入!G5","v":{"v":1831,"d":"NT$1,831.00"}}]
[null,"總支出",{"$f":"支出!G5","v":{"v":1145,"d":"NT$1,145.00"}},{"$f":"支出!H5","v":{"v":395,"d":"NT$395.00"}}]
[null,"總收益 (或損失)",{"$f":"C6-C7","v":{"v":791,"d":"NT$791.00"}},{"$f":"D6-D7","v":{"v":1436,"d":"NT$1,436.00"}}]
["右側儲存格是顯示預估總收入/總支出和實際總收入/總支出比較的群組直條圖。","這個儲存格是顯示預估總收入/總支出和實際總收入/總支出比較的群組直條圖。"]