{"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":"¥882.00"}},{"$f":"SUM(D11,D19,D25,D32,H11,H19,H24)","v":{"v":333,"d":"¥333.00"}}]
[]
[null,"会場","予算","実際",null,"軽食","予算","実際"]
[null,"会議室、ホール手数料",{"v":500,"d":"¥500.00"},null,null,"食べ物"]
[null,"会場スタッフ",{"$nulls":3},"飲み物",{"v":20,"d":"¥20.00"}]
[null,"機器",{"$nulls":3},"テーブルクロス等",null,{"v":20,"d":"¥20.00"}]
[null,"テーブルと椅子",{"$nulls":3},"スタッフ、心づけ"]
[null,"集計",{"$f":"SUBTOTAL(109,表1[予算])","v":{"v":500,"d":"¥500.00"}},{"$f":"SUBTOTAL(109,表1[実際])","v":{"v":0,"d":"¥0.00"}},null,"集計",{"$f":"SUBTOTAL(109,表3[予算])","v":{"v":20,"d":"¥20.00"}},{"$f":"SUBTOTAL(109,表3[実際])","v":{"v":20,"d":"¥20.00"}}]
[]
[null,"飾りつけ","予算","実際",null,"プログラム","予算","実際"]
[null,"花",{"v":200,"d":"¥200.00"},{"v":300,"d":"¥300.00"},null,"パフォーマー"]
[null,"キャンドル",{"$nulls":3},"スピーカー",{"v":30,"d":"¥30.00"}]
[null,"照明",{"$nulls":3},"旅費"]
[null,"風船",{"$nulls":3},"ホテル"]
[null,"紙",{"$nulls":3},"その他"]
[null,"集計",{"$f":"SUBTOTAL(109,表4[予算])","v":{"v":200,"d":"¥200.00"}},{"$f":"SUBTOTAL(109,表4[実際])","v":{"v":300,"d":"¥300.00"}},null,"集計",{"$f":"SUBTOTAL(109,表5[予算])","v":{"v":30,"d":"¥30.00"}},{"$f":"SUBTOTAL(109,表5[実際])","v":{"v":0,"d":"¥0.00"}}]
[]
[null,"宣伝","予算","実際",null,"賞品","予算","実際"]
[null,"グラフィック アート",{"$nulls":3},"リボン/銘板/トロフィー"]
[null,"コピー/印刷",{"v":20,"d":"¥20.00"},null,null,"プレゼント",{"v":100,"d":"¥100.00"}]
[null,"送料",{"$nulls":3},"集計",{"$f":"SUBTOTAL(109,表7[予算])","v":{"v":100,"d":"¥100.00"}},{"$f":"SUBTOTAL(109,表7[実際])","v":{"v":0,"d":"¥0.00"}}]
[null,"集計",{"$f":"SUBTOTAL(109,表6[予算])","v":{"v":20,"d":"¥20.00"}},{"$f":"SUBTOTAL(109,表6[実際])","v":{"v":0,"d":"¥0.00"}}]
[]
[null,"その他","予算","実際"]
[null,"電話料金",null,{"v":13,"d":"¥13.00"}]
[null,"交通費",{"v":12,"d":"¥12.00"}]
[null,"事務用具"]
[null,"Fax サービス"]
[null,"集計",{"$f":"SUBTOTAL(109,表8[予算])","v":{"v":12,"d":"¥12.00"}},{"$f":"SUBTOTAL(109,表8[実際])","v":{"v":13,"d":"¥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":"¥1,936.00"}},{"$f":"SUM(G11,G18,G25, G33)","v":{"v":1831,"d":"¥1,831.00"}}]
[]
[null,"入場者"]
[null,"見積もり数","実際の数","種類","価格","収入予算","収入実績"]
[null,300,278,"大人",{"v":5,"d":"¥5.00"},{"$f":"B8*E8","v":{"v":1500,"d":"¥1,500.00"}},{"$f":"C8*E8","v":{"v":1390,"d":"¥1,390.00"}}]
[null,197,195,"子供",{"v":2,"d":"¥2.00"},{"$f":"B9*E9","v":{"v":394,"d":"¥394.00"}},{"$f":"C9*E9","v":{"v":390,"d":"¥390.00"}}]
[null,42,51,"その他",{"v":1,"d":"¥1.00"},{"$f":"B10*E10","v":{"v":42,"d":"¥42.00"}},{"$f":"C10*E10","v":{"v":51,"d":"¥51.00"}}]
[null,"集計",{"$nulls":3},{"$f":"SUBTOTAL(109,表9[収入予算])","v":{"v":1936,"d":"¥1,936.00"}},{"$f":"SUBTOTAL(109,表9[収入実績])","v":{"v":1831,"d":"¥1,831.00"}}]
[]
[null,"プログラム内の広告"]
[null,"見積もり数","実際の数","種類","価格","収入予算","収入実績"]
[null,12,null,"表/裏表紙",null,{"$f":"B15*E15","v":{"v":0,"d":"¥0.00"}},{"$f":"C15*E15","v":{"v":0,"d":"¥0.00"}}]
[null,null,158,"1/2 ページ",null,{"$f":"B16*E16","v":{"v":0,"d":"¥0.00"}},{"$f":"C16*E16","v":{"v":0,"d":"¥0.00"}}]
[null,4,null,"1/4 ページ",null,{"$f":"B17*E17","v":{"v":0,"d":"¥0.00"}},{"$f":"C17*E17","v":{"v":0,"d":"¥0.00"}}]
[null,"集計",{"$nulls":3},{"$f":"SUBTOTAL(109,表10[収入予算])","v":{"v":0,"d":"¥0.00"}},{"$f":"SUBTOTAL(109,表10[収入実績])","v":{"v":0,"d":"¥0.00"}}]
[]
[null,"出展者/出店業者"]
[null,"見積もり数","実際の数","種類","価格","収入予算","収入実績"]
[null,23,null,"ブース大",null,{"$f":"B22*E22","v":{"v":0,"d":"¥0.00"}},{"$f":"C22*E22","v":{"v":0,"d":"¥0.00"}}]
[null,354,null,"ブース中",null,{"$f":"B23*E23","v":{"v":0,"d":"¥0.00"}},{"$f":"C23*E23","v":{"v":0,"d":"¥0.00"}}]
[null,56,null,"ブース小",null,{"$f":"B24*E24","v":{"v":0,"d":"¥0.00"}},{"$f":"C24*E24","v":{"v":0,"d":"¥0.00"}}]
[null,"集計",{"$nulls":3},{"$f":"SUBTOTAL(109,表11[収入予算])","v":{"v":0,"d":"¥0.00"}},{"$f":"SUBTOTAL(109,表11[収入実績])","v":{"v":0,"d":"¥0.00"}}]
[]
[null,"アイテムの販売"]
[null,"見積もり数","実際の数","種類","価格","収入予算","収入実績"]
[{"$nulls":3},"項目",null,{"$f":"B29*E29","v":{"v":0,"d":"¥0.00"}},{"$f":"C29*E29","v":{"v":0,"d":"¥0.00"}}]
[null,123,null,"項目",null,{"$f":"B30*E30","v":{"v":0,"d":"¥0.00"}},{"$f":"C30*E30","v":{"v":0,"d":"¥0.00"}}]
[{"$nulls":3},"項目",null,{"$f":"B31*E31","v":{"v":0,"d":"¥0.00"}},{"$f":"C31*E31","v":{"v":0,"d":"¥0.00"}}]
[null,13,null,"項目",null,{"$f":"B32*E32","v":{"v":0,"d":"¥0.00"}},{"$f":"C32*E32","v":{"v":0,"d":"¥0.00"}}]
[null,"集計",{"$nulls":3},{"$f":"SUBTOTAL(109,表12[収入予算])","v":{"v":0,"d":"¥0.00"}},{"$f":"SUBTOTAL(109,表12[収入実績])","v":{"v":0,"d":"¥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":"¥1,936.00"}},{"$f":"収入!G4","v":{"v":1831,"d":"¥1,831.00"}}]
[null,"支出合計",{"$f":"支出!G4","v":{"v":882,"d":"¥882.00"}},{"$f":"支出!H4","v":{"v":333,"d":"¥333.00"}}]
[]
[null,"利益合計 (または損失合計)",{"$f":"C6-C7","v":{"v":1054,"d":"¥1,054.00"}},{"$f":"D6-D7","v":{"v":1498,"d":"¥1,498.00"}}]