{"text_format":"3","workbook":"xlsx","n_sheets":3,"sheets":["支出","收入","損益摘要"],"not_rendered":{"charts":1},"read":"whole","date_system":"1900"}

{"sheet":"支出","index":0,"n_rows":32,"n_cols":8,"rows_kept":32,"merged":[[0,1,0,3],[2,1,3,1]]}
[null,"[活動名稱] 的活動預算表 ",{"$nulls":5},"支出"]
[]
[null,"總支出",{"$nulls":4},"預估","實際"]
[{"$nulls":6},{"$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":333,"d":"NT$333.00"}}]
[]
[null,"場地","預估","實際",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,表格1[預估])","v":{"v":500,"d":"NT$500.00"}},{"$f":"SUBTOTAL(109,表格1[實際])","v":{"v":0,"d":"NT$0.00"}},null,"合計",{"$f":"SUBTOTAL(109,表格3[預估])","v":{"v":20,"d":"NT$20.00"}},{"$f":"SUBTOTAL(109,表格3[實際])","v":{"v":20,"d":"NT$20.00"}}]
[]
[null,"佈置裝飾","預估","實際",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,表格4[預估])","v":{"v":200,"d":"NT$200.00"}},{"$f":"SUBTOTAL(109,表格4[實際])","v":{"v":300,"d":"NT$300.00"}},null,"合計",{"$f":"SUBTOTAL(109,表格5[預估])","v":{"v":30,"d":"NT$30.00"}},{"$f":"SUBTOTAL(109,表格5[實際])","v":{"v":0,"d":"NT$0.00"}}]
[]
[null,"宣傳","預估","實際",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,表格7[預估])","v":{"v":100,"d":"NT$100.00"}},{"$f":"SUBTOTAL(109,表格7[實際])","v":{"v":0,"d":"NT$0.00"}}]
[null,"合計",{"$f":"SUBTOTAL(109,表格6[預估])","v":{"v":20,"d":"NT$20.00"}},{"$f":"SUBTOTAL(109,表格6[實際])","v":{"v":0,"d":"NT$0.00"}}]
[]
[null,"其他","預估","實際"]
[null,"電話",null,{"v":13,"d":"NT$13.00"}]
[null,"交通",{"v":12,"d":"NT$12.00"}]
[null,"文具用品"]
[null,"傳真服務"]
[null,"合計",{"$f":"SUBTOTAL(109,表格8[預估])","v":{"v":12,"d":"NT$12.00"}},{"$f":"SUBTOTAL(109,表格8[實際])","v":{"v":13,"d":"NT$13.00"}}]

{"sheet":"收入","index":1,"n_rows":33,"n_cols":7,"rows_kept":33,"merged":[[0,1,0,3],[2,1,3,1]]}
[null,"[活動名稱] 的活動預算表 ",{"$nulls":4},"收入"]
[]
[null,"總收入",{"$nulls":3},"預估","實際"]
[{"$nulls":5},{"$f":"SUM(F11, F18, F25, F33)","v":{"v":1936,"d":"NT$1,936.00"}},{"$f":"SUM(G11,G18,G25, G33)","v":{"v":1831,"d":"NT$1,831.00"}}]
[]
[null,"門票"]
[null,"預估數量","實際數量","類型","價格","預估收入","實際收入"]
[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"},{"$f":"B10*E10","v":{"v":42,"d":"NT$42.00"}},{"$f":"C10*E10","v":{"v":51,"d":"NT$51.00"}}]
[null,"合計",{"$nulls":3},{"$f":"SUBTOTAL(109,表格9[預估收入])","v":{"v":1936,"d":"NT$1,936.00"}},{"$f":"SUBTOTAL(109,表格9[實際收入])","v":{"v":1831,"d":"NT$1,831.00"}}]
[]
[null,"節目廣告"]
[null,"預估數量","實際數量","類型","價格","預估收入","實際收入"]
[null,12,null,"封面 @",null,{"$f":"B15*E15","v":{"v":0,"d":"NT$0.00"}},{"$f":"C15*E15","v":{"v":0,"d":"NT$0.00"}}]
[null,null,158,"半版 @",null,{"$f":"B16*E16","v":{"v":0,"d":"NT$0.00"}},{"$f":"C16*E16","v":{"v":0,"d":"NT$0.00"}}]
[null,4,null,"1/4 版 @",null,{"$f":"B17*E17","v":{"v":0,"d":"NT$0.00"}},{"$f":"C17*E17","v":{"v":0,"d":"NT$0.00"}}]
[null,"合計",{"$nulls":3},{"$f":"SUBTOTAL(109,表格10[預估收入])","v":{"v":0,"d":"NT$0.00"}},{"$f":"SUBTOTAL(109,表格10[實際收入])","v":{"v":0,"d":"NT$0.00"}}]
[]
[null,"參展商/廠商"]
[null,"預估數量","實際數量","類型","價格","預估收入","實際收入"]
[null,23,null,"大型攤位 @",null,{"$f":"B22*E22","v":{"v":0,"d":"NT$0.00"}},{"$f":"C22*E22","v":{"v":0,"d":"NT$0.00"}}]
[null,354,null,"中型攤位 @",null,{"$f":"B23*E23","v":{"v":0,"d":"NT$0.00"}},{"$f":"C23*E23","v":{"v":0,"d":"NT$0.00"}}]
[null,56,null,"小型攤位 @",null,{"$f":"B24*E24","v":{"v":0,"d":"NT$0.00"}},{"$f":"C24*E24","v":{"v":0,"d":"NT$0.00"}}]
[null,"合計",{"$nulls":3},{"$f":"SUBTOTAL(109,表格11[預估收入])","v":{"v":0,"d":"NT$0.00"}},{"$f":"SUBTOTAL(109,表格11[實際收入])","v":{"v":0,"d":"NT$0.00"}}]
[]
[null,"銷售項目"]
[null,"預估數量","實際數量","類型","價格","預估收入","實際收入"]
[{"$nulls":3},"項目 @",null,{"$f":"B29*E29","v":{"v":0,"d":"NT$0.00"}},{"$f":"C29*E29","v":{"v":0,"d":"NT$0.00"}}]
[null,123,null,"項目 @",null,{"$f":"B30*E30","v":{"v":0,"d":"NT$0.00"}},{"$f":"C30*E30","v":{"v":0,"d":"NT$0.00"}}]
[{"$nulls":3},"項目 @",null,{"$f":"B31*E31","v":{"v":0,"d":"NT$0.00"}},{"$f":"C31*E31","v":{"v":0,"d":"NT$0.00"}}]
[null,13,null,"項目 @",null,{"$f":"B32*E32","v":{"v":0,"d":"NT$0.00"}},{"$f":"C32*E32","v":{"v":0,"d":"NT$0.00"}}]
[null,"合計",{"$nulls":3},{"$f":"SUBTOTAL(109,表格12[預估收入])","v":{"v":0,"d":"NT$0.00"}},{"$f":"SUBTOTAL(109,表格12[實際收入])","v":{"v":0,"d":"NT$0.00"}}]

{"sheet":"損益摘要","index":2,"n_rows":9,"n_cols":7,"rows_kept":9,"merged":[[0,1,0,3]]}
[null,"[活動名稱] 的活動預算表 ",{"$nulls":4},"收益 "]
[{"$nulls":6},"損失摘要"]
[]
[]
[null,null,"預估","實際"]
[null,"總收入",{"$f":"收入!F4","v":{"v":1936,"d":"NT$1,936.00"}},{"$f":"收入!G4","v":{"v":1831,"d":"NT$1,831.00"}}]
[null,"總支出",{"$f":"支出!G4","v":{"v":882,"d":"NT$882.00"}},{"$f":"支出!H4","v":{"v":333,"d":"NT$333.00"}}]
[]
[null,"總收益(或損失)",{"$f":"C6-C7","v":{"v":1054,"d":"NT$1,054.00"}},{"$f":"D6-D7","v":{"v":1498,"d":"NT$1,498.00"}}]