{"text_format":"3","workbook":"xlsx","n_sheets":4,"sheets":["開始","支出","收入","損益摘要"],"not_rendered":{"charts":1},"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，然後選取 [刪除]。 "]
[null,"若要深入了解表格，請在表格內按 SHIFT 並按 F10，選取 [表格] 選項，然後選取 [替代文字]"]

{"sheet":"支出","index":1,"n_rows":32,"n_cols":8,"rows_kept":32,"merged":[[0,1,0,2],[0,3,0,4],[2,1,3,1]]}
["在這個工作表中的個別表格中，輸入每個類別的預估支出和實際支出，然後在儲存格 D1 輸入活動名稱，以自訂這個工作表和其他工作表的標題。這個工作表的副標題在儲存格 H1。您可以在此欄的儲存格中找到有關此工作表的使用方式實用指示。下一個指示在儲存格 A3。","活動預算表",null,"活動名稱",{"$nulls":3},"支出"]
[]
["[總支出] 標籤在右側的儲存格、[預估支出] 標籤在儲存格 G3，[實際支出] 標籤在儲存格 H3。","總支出",{"$nulls":4},"預估","實際"]
["[總預估支出] 標籤在儲存格 G4，[總實際支出] 標籤在儲存格 H4，工作表會自動計算這兩項支出。下一個指示在儲存格 A6。",{"$nulls":5},{"$f":"SUM(C11,C19,C25,C32,G11,G19,G24)","v":{"v":882,"d":"NT$882.00"}},{"$f":"SUM(D11,D19,D25,D32,H11,H19,H24)","v":{"v":302,"d":"NT$302.00"}}]
[]
["在從右側儲存格開始的表格中輸入場地相關支出，並在從儲存格 F6 開始的表格中輸入茶點相關支出。下一個指示在儲存格 A13。","場地","預估","實際",null,"茶點","預估","實際"]
[null,"會議室和禮堂地費",{"v":500,"d":"NT$500.00"},null,null,"食物"]
[null,"現場工作人員",{"$nulls":3},"飲料",{"v":20,"d":"NT$20.00"}]
[null,"設備",{"$nulls":3},"桌巾",null,{"v":20,"d":"NT$20.00"}]
[null,"桌椅",{"$nulls":3},"工作人員和小費"]
[null,"合計",{"$f":"SUBTOTAL(109,網站支出[預估])","v":{"v":500,"d":"NT$500.00"}},{"$f":"SUBTOTAL(103,網站支出[實際])","v":{"v":0,"d":"NT$0.00"}},null,"合計",{"$f":"SUBTOTAL(109,茶點支出[預估])","v":{"v":20,"d":"NT$20.00"}},{"$f":"SUBTOTAL(103,茶點支出[實際])","v":{"v":1,"d":"NT$1.00"}}]
[]
["在從右側儲存格開始的表格中輸入佈置裝飾相關支出，並在從儲存格 F13 開始的表格中輸入節目相關支出。下一個指示在儲存格 A21。","佈置裝飾","預估","實際",null,"節目","預估","實際"]
[null,"花飾",{"v":200,"d":"NT$200.00"},{"v":300,"d":"NT$300.00"},null,"表演者"]
[null,"蠟燭",{"$nulls":3},"演講者",{"v":30,"d":"NT$30.00"}]
[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":300,"d":"NT$300.00"}},null,"合計",{"$f":"SUBTOTAL(109,計劃支出[預估])","v":{"v":30,"d":"NT$30.00"}},{"$f":"SUBTOTAL(103,計劃支出[實際])","v":{"v":0,"d":"NT$0.00"}}]
[]
["在從右側儲存格開始的表格中開始輸入宣傳相關支出，並在從儲存格 F21 開始的表格中輸入獎品相關支出。下一個指示在儲存格 A27。","宣傳","預估","實際",null,"獎品","預估","實際"]
[null,"平面設計",{"$nulls":3},"獎徽/獎牌/獎盃"]
[null,"影印/列印",{"v":20,"d":"NT$20.00"},null,null,"禮物",{"v":100,"d":"NT$100.00"}]
[null,"郵資",{"$nulls":3},"合計",{"$f":"SUBTOTAL(109,獎品支出[預估])","v":{"v":100,"d":"NT$100.00"}},{"$f":"SUBTOTAL(103,獎品支出[實際])","v":{"v":0,"d":"NT$0.00"}}]
[null,"合計",{"$f":"SUBTOTAL(109,公關支出[預估])","v":{"v":20,"d":"NT$20.00"}},{"$f":"SUBTOTAL(103,公關支出[實際])","v":{"v":0,"d":"NT$0.00"}}]
[]
["在從右側儲存格開始的表格中輸入雜項支出。","其他","預估","實際"]
[null,"電話",null,{"v":13,"d":"NT$13.00"}]
[null,"交通",{"v":12,"d":"NT$12.00"}]
[null,"文具用品"]
[null,"傳真服務"]
[null,"合計",{"$f":"SUBTOTAL(109,雜項支出[預估])","v":{"v":12,"d":"NT$12.00"}},{"$f":"SUBTOTAL(103,雜項支出[實際])","v":{"v":1,"d":"NT$1.00"}}]

{"sheet":"收入","index":2,"n_rows":29,"n_cols":7,"rows_kept":29,"merged":[[0,1,0,2],[2,1,3,1]]}
["在這個工作表的個別表格中輸入各類別的預估與實際收入。這個工作表的標題會自動在右側儲存格中更新。儲存格 G1 是副標題。您可以在此欄的儲存格中找到有關此工作表的使用方式實用指示。下一個指示在儲存格 A3。",{"$f":"支出!B1","v":"活動預算表"},null,{"$f":"支出!D1","v":"活動名稱"},null,null,"收入"]
[]
["[總收入] 標籤在右側的儲存格、[預估收入] 標籤在儲存格 F3，[實際收入] 標籤在儲存格 G3。","總收入",{"$nulls":3},"預估","實際"]
["儲存格 F4 會自動計算總預估收入，儲存格 G4 會自動計算總實際收入。",{"$nulls":4},{"$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"}}]
["右側儲存格是 [門票] 標籤。","門票"]
["在從右側儲存格開始的表格中輸入預估和實際的門票數和票價。工作表會自動計算門票帶來的預估和實際收入。下一個指示在儲存格 A11。","預估數量","實際數量","類型","價格","預估收入","實際收入"]
[null,300,278,"成人 @",{"v":5,"d":"NT$5.00"},{"$f":"B7*E7","v":{"v":1500,"d":"NT$1,500.00"}},{"$f":"C7*E7","v":{"v":1390,"d":"NT$1,390.00"}}]
[null,197,195,"兒童 @",{"v":2,"d":"NT$2.00"},{"$f":"B8*E8","v":{"v":394,"d":"NT$394.00"}},{"$f":"C8*E8","v":{"v":390,"d":"NT$390.00"}}]
[null,42,51,"其他 @",{"v":1,"d":"NT$1.00"},{"$f":"B9*E9","v":{"v":42,"d":"NT$42.00"}},{"$f":"C9*E9","v":{"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"}}]
["右側儲存格是 [節目廣告] 標籤。","節目廣告"]
["在從右側儲存格開始的表格中輸入預估和實際的節目廣告數和廣告費用。工作表會自動計算廣告帶來的預估和實際收入。下一個指示在儲存格 A17。","預估數量","實際數量","類型","價格","預估收入","實際收入"]
[null,12,null,"封面 @",null,{"$f":"B13*E13","v":{"v":0,"d":"NT$0.00"}},{"$f":"C13*E13","v":{"v":0,"d":"NT$0.00"}}]
[null,null,158,"半版 @",null,{"$f":"B14*E14","v":{"v":0,"d":"NT$0.00"}},{"$f":"C14*E14","v":{"v":0,"d":"NT$0.00"}}]
[null,4,null,"1/4 版 @",null,{"$f":"B15*E15","v":{"v":0,"d":"NT$0.00"}},{"$f":"C15*E15","v":{"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"}}]
["右側儲存格是參展商或廠商。","參展商/廠商"]
["在從右側儲存格開始的表格中輸入預估和實際的參展商和廠商數以及攤位費用。工作表會自動計算預估和實際收入。下一個指示在儲存格 A23。","預估數量","實際數量","類型","價格","預估收入","實際收入"]
[null,23,null,"大型攤位 @",null,{"$f":"B19*E19","v":{"v":0,"d":"NT$0.00"}},{"$f":"C19*E19","v":{"v":0,"d":"NT$0.00"}}]
[null,354,null,"中型攤位 @",null,{"$f":"B20*E20","v":{"v":0,"d":"NT$0.00"}},{"$f":"C20*E20","v":{"v":0,"d":"NT$0.00"}}]
[null,56,null,"小型攤位 @",null,{"$f":"B21*E21","v":{"v":0,"d":"NT$0.00"}},{"$f":"C21*E21","v":{"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":"B25*E25","v":{"v":0,"d":"NT$0.00"}},{"$f":"C25*E25","v":{"v":0,"d":"NT$0.00"}}]
[null,123,null,"項目 @",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"}}]
[null,13,null,"項目 @",null,{"$f":"B28*E28","v":{"v":0,"d":"NT$0.00"}},{"$f":"C28*E28","v":{"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":8,"n_cols":7,"rows_kept":8,"merged":[[0,1,0,2]]}
["工作表會自動計算顯示總收入和總支出的 [損益摘要] 和 [圖表]。這個工作表的標題會自動在右側儲存格中更新。儲存格 G1 和 G2 是副標題。您可以在此欄的儲存格中找到有關此工作表的使用方式實用指示。下一個指示在儲存格 A3。",{"$f":"支出!B1","v":"活動預算表"},null,{"$f":"支出!D1","v":"活動名稱"},null,null,"收益 "]
[{"$nulls":6},"損失摘要"]
["儲存格 E3 是比較預估收入/預估支出和實際收入/實際支出的橫條圖。",{"$nulls":3},"這個儲存格是顯示預估收入/支出和實際收入/支出比較的橫條圖。"]
["從右側儲存格開始的 [摘要] 表格會自動更新。下一個指示在儲存格 A8。"," 總計","預估","實際"]
[null,"總收入",{"$f":"收入!F10","v":{"v":1936,"d":"NT$1,936.00"}},{"$f":"收入!F4","v":{"v":1936,"d":"NT$1,936.00"}}]
[null,"總支出",{"$f":"支出!G4","v":{"v":882,"d":"NT$882.00"}},{"$f":"支出!H4","v":{"v":302,"d":"NT$302.00"}}]
[]
["儲存格 C8 會自動計算預估總損益，儲存格 D8 會自動計算實際總損益。","總收益\n(或損失)",{"$f":"C5-C6","v":{"v":1054,"d":"NT$1,054.00"}},{"$f":"D5-D6","v":{"v":1634,"d":"NT$1,634.00"}}]