{"text_format":"3","workbook":"xlsx","n_sheets":3,"sheets":["支出","収入","損益の概要​​"],"not_rendered":{"charts":4,"images":6,"defined_names":1},"read":"whole","date_system":"1900"}

{"sheet":"支出","index":0,"n_rows":31,"n_cols":9,"rows_kept":31,"merged":[[6,1,7,1]]}
[{"$nulls":8}," "]
[]
[null,"製品発表パーティー"]
[null,"経費の詳細"]
[]
[]
[null,"経費の合計","予算","実際",null,"プログラム","予算","実際"]
[null,null,{"$f":"現場経費[[#Totals],[予算]]+飾りつけ経費[[#Totals],[予算]]+広告費[[#Totals],[予算]]+雑費[[#Totals],[予算]]+リフレッシュメント経費[[#Totals],[予算]]+プログラム経費[[#Totals],[予算]]+賞品費[[#Totals],[予算]]","v":{"v":2090,"d":"¥2,090.00"}},{"$f":"現場経費[[#Totals],[実際]]+飾りつけ経費[[#Totals],[実際]]+広告費[[#Totals],[実際]]+雑費[[#Totals],[実際]]+リフレッシュメント経費[[#Totals],[実際]]+プログラム経費[[#Totals],[実際]]+賞品費[[#Totals],[実際]]","v":{"v":1640,"d":"¥1,640.00"}},null,"パフォーマー",{"v":750,"d":"¥750.00"},{"v":700,"d":"¥700.00"}]
[{"$nulls":5},"スピーカー",{"v":150,"d":"¥150.00"},{"v":0,"d":"¥0.00"}]
[{"$nulls":5},"旅費"]
[null,"会場","予算","実際",null,"ホテル"]
[null,"会議室、ホール手数料",{"v":500,"d":"¥500.00"},{"v":450,"d":"¥450.00"},null,"その他"]
[null,"会場スタッフ",{"$nulls":3},"集計",{"$f":"SUBTOTAL(109,プログラム経費[予算])","v":{"v":900,"d":"¥900.00"}},{"$f":"SUBTOTAL(109,プログラム経費[実際])","v":{"v":700,"d":"¥700.00"}}]
[null,"機器"]
[null,"テーブルと椅子",{"$nulls":3},"宣伝","予算","実際"]
[null,"集計",{"$f":"SUBTOTAL(109,現場経費[予算])","v":{"v":500,"d":"¥500.00"}},{"$f":"SUBTOTAL(109,現場経費[実際])","v":{"v":450,"d":"¥450.00"}},null,"グラフィック アート"]
[{"$nulls":5},"コピー/印刷",{"v":20,"d":"¥20.00"},{"v":20,"d":"¥20.00"}]
[null,"飾りつけ","予算","実際",null,"送料"]
[null,"花",{"v":200,"d":"¥200.00"},{"v":100,"d":"¥100.00"},null,"集計",{"$f":"SUBTOTAL(109,広告費[予算])","v":{"v":20,"d":"¥20.00"}},{"$f":"SUBTOTAL(109,広告費[実際])","v":{"v":20,"d":"¥20.00"}}]
[null,"キャンドル"]
[null,"照明",{"$nulls":3},"賞品","予算","実際"]
[null,"風船",{"$nulls":3},"リボン/トロフィー"]
[null,"紙",{"$nulls":3},"ギフト",{"v":100,"d":"¥100.00"},{"v":100,"d":"¥100.00"}]
[null,"集計",{"$f":"SUBTOTAL(109,飾りつけ経費[予算])","v":{"v":200,"d":"¥200.00"}},{"$f":"SUBTOTAL(109,飾りつけ経費[実際])","v":{"v":100,"d":"¥100.00"}},null,"集計",{"$f":"SUBTOTAL(109,賞品費[予算])","v":{"v":100,"d":"¥100.00"}},{"$f":"SUBTOTAL(109,賞品費[実際])","v":{"v":100,"d":"¥100.00"}}]
[]
[null,"軽食","予算","実際",null,"その他","予算","実際"]
[null,"食べ物",{"$nulls":3},"電話料金",{"v":50,"d":"¥50.00"},{"v":50,"d":"¥50.00"}]
[null,"飲み物",{"v":220,"d":"¥220.00"},{"v":120,"d":"¥120.00"},null,"交通費",{"v":20,"d":"¥20.00"},{"v":20,"d":"¥20.00"}]
[null,"テーブルクロス等",{"v":80,"d":"¥80.00"},{"v":80,"d":"¥80.00"},null,"事務用具"]
[null,"スタッフ、心づけ",{"$nulls":3},"Fax サービス"]
[null,"集計",{"$f":"SUBTOTAL(109,リフレッシュメント経費[予算])","v":{"v":300,"d":"¥300.00"}},{"$f":"SUBTOTAL(109,リフレッシュメント経費[実際])","v":{"v":200,"d":"¥200.00"}},null,"集計",{"$f":"SUBTOTAL(109,雑費[予算])","v":{"v":70,"d":"¥70.00"}},{"$f":"SUBTOTAL(109,雑費[実際])","v":{"v":70,"d":"¥70.00"}}]

{"sheet":"収入","index":1,"n_rows":37,"n_cols":8,"rows_kept":37,"merged":[[6,1,7,1],[9,1,9,6],[16,1,16,6],[23,1,23,6],[30,1,30,6]]}
[{"$nulls":7}," "]
[]
[null,{"$f":"支出!B3","v":"製品発表パーティー"}]
[null,"収入の詳細"]
[]
[]
[null,"収入の合計","予算","実際"]
[null,null,{"$f":"SUM(入場料[[#Totals],[推定される収入]],プログラム内広告[[#Totals],[推定される収入]],出展者とベンダー[[#Totals],[推定される収入]],品目の売上[[#Totals],[推定される収入]])","v":{"v":4450,"d":"¥4,450.00"}},{"$f":"SUM(入場料[[#Totals],[実際の収入]],プログラム内広告[[#Totals],[実際の収入]],出展者とベンダー[[#Totals],[実際の収入]],品目の売上[[#Totals],[実際の収入]])","v":{"v":4170,"d":"¥4,170.00"}}]
[]
[null,"入場料"]
[null,"種類","予算","実際","価格","推定される収入","実際の収入"]
[null,"大人",30,25,{"v":20,"d":"¥20.00"},{"$f":"C12*E12","v":{"v":600,"d":"¥600.00"}},{"$f":"D12*E12","v":{"v":500,"d":"¥500.00"}}]
[null,"子供",20,22,{"v":10,"d":"¥10.00"},{"$f":"C13*E13","v":{"v":200,"d":"¥200.00"}},{"$f":"D13*E13","v":{"v":220,"d":"¥220.00"}}]
[null,"その他",10,10,{"v":10,"d":"¥10.00"},{"$f":"C14*E14","v":{"v":100,"d":"¥100.00"}},{"$f":"D14*E14","v":{"v":100,"d":"¥100.00"}}]
[null,"集計",{"$f":"SUBTOTAL(109,入場料[予算])","v":60},{"$f":"SUBTOTAL(109,入場料[実際])","v":57},null,{"$f":"SUBTOTAL(109,入場料[推定される収入])","v":{"v":900,"d":"¥900.00"}},{"$f":"SUBTOTAL(109,入場料[実際の収入])","v":{"v":820,"d":"¥820.00"}}]
[]
[null,"プログラム内の広告"]
[null,"種類","予算","実際","価格","推定される収入","実際の収入"]
[null,"表/裏表紙",2,4,{"v":50,"d":"¥50.00"},{"$f":"C19*E19","v":{"v":100,"d":"¥100.00"}},{"$f":"D19*E19","v":{"v":200,"d":"¥200.00"}}]
[null,"1/2 ページ",2,2,{"v":30,"d":"¥30.00"},{"$f":"C20*E20","v":{"v":60,"d":"¥60.00"}},{"$f":"D20*E20","v":{"v":60,"d":"¥60.00"}}]
[null,"1/4 ページ",2,2,{"v":20,"d":"¥20.00"},{"$f":"C21*E21","v":{"v":40,"d":"¥40.00"}},{"$f":"D21*E21","v":{"v":40,"d":"¥40.00"}}]
[null,"集計",{"$f":"SUBTOTAL(109,プログラム内広告[予算])","v":6},{"$f":"SUBTOTAL(109,プログラム内広告[実際])","v":8},null,{"$f":"SUBTOTAL(109,プログラム内広告[推定される収入])","v":{"v":200,"d":"¥200.00"}},{"$f":"SUBTOTAL(109,プログラム内広告[実際の収入])","v":{"v":300,"d":"¥300.00"}}]
[]
[null,"出展者/出店業者"]
[null,"種類","予算","実際","価格","推定される収入","実際の収入"]
[null,"ブース大",5,5,{"v":300,"d":"¥300.00"},{"$f":"C26*E26","v":{"v":1500,"d":"¥1,500.00"}},{"$f":"D26*E26","v":{"v":1500,"d":"¥1,500.00"}}]
[null,"ブース中",5,4,{"v":200,"d":"¥200.00"},{"$f":"C27*E27","v":{"v":1000,"d":"¥1,000.00"}},{"$f":"D27*E27","v":{"v":800,"d":"¥800.00"}}]
[null,"ブース小",1,0,{"v":100,"d":"¥100.00"},{"$f":"C28*E28","v":{"v":100,"d":"¥100.00"}},{"$f":"D28*E28","v":{"v":0,"d":"¥0.00"}}]
[null,"集計",{"$f":"SUBTOTAL(109,出展者とベンダー[予算])","v":11},{"$f":"SUBTOTAL(109,出展者とベンダー[実際])","v":9},null,{"$f":"SUBTOTAL(109,出展者とベンダー[推定される収入])","v":{"v":2600,"d":"¥2,600.00"}},{"$f":"SUBTOTAL(109,出展者とベンダー[実際の収入])","v":{"v":2300,"d":"¥2,300.00"}}]
[]
[null,"商品の販売"]
[null,"種類","予算","実際","価格","推定される収入","実際の収入"]
[null,"品目 1",2,2,{"v":150,"d":"¥150.00"},{"$f":"C33*E33","v":{"v":300,"d":"¥300.00"}},{"$f":"D33*E33","v":{"v":300,"d":"¥300.00"}}]
[null,"品目 2",5,5,{"v":50,"d":"¥50.00"},{"$f":"C34*E34","v":{"v":250,"d":"¥250.00"}},{"$f":"D34*E34","v":{"v":250,"d":"¥250.00"}}]
[null,"品目 3",5,5,{"v":20,"d":"¥20.00"},{"$f":"C35*E35","v":{"v":100,"d":"¥100.00"}},{"$f":"D35*E35","v":{"v":100,"d":"¥100.00"}}]
[null,"物件 4",5,5,{"v":20,"d":"¥20.00"},{"$f":"C36*E36","v":{"v":100,"d":"¥100.00"}},{"$f":"D36*E36","v":{"v":100,"d":"¥100.00"}}]
[null,"集計",{"$f":"SUBTOTAL(109,品目の売上[予算])","v":17},{"$f":"SUBTOTAL(109,品目の売上[実際])","v":17},null,{"$f":"SUBTOTAL(109,品目の売上[推定される収入])","v":{"v":750,"d":"¥750.00"}},{"$f":"SUBTOTAL(109,品目の売上[実際の収入])","v":{"v":750,"d":"¥750.00"}}]

{"sheet":"損益の概要​​","index":2,"n_rows":29,"n_cols":16,"rows_kept":29,"merged":[[28,1,28,3],[28,4,28,6]]}
[{"$nulls":7}," "]
[]
[null,{"$f":"支出!B3","v":"製品発表パーティー"}]
[null,"損益の概要"]
[]
[]
[null,"経費の概要","予算","実際",null,"実際の経費",{"$nulls":5},"ランク付け","経費","予算","実際","ランク付けの値"]
[null,{"$f":"VLOOKUP(1,$L$8:$O$14,2,FALSE)","v":"プログラム"},{"$f":"VLOOKUP(1,$L$8:$O$14,3,FALSE)","v":{"v":900,"d":"¥900.00"}},{"$f":"VLOOKUP(1,$L$8:$O$14,4,FALSE)","v":{"v":700,"d":"¥700.00"}},{"$nulls":7},{"$f":"_xlfn.RANK.AVG(P8,$P$8:$P$14)","v":2},"会場",{"$f":"現場経費[[#Totals],[予算]]","v":{"v":500,"d":"¥500"}},{"$f":"現場経費[[#Totals],[実際]]","v":{"v":450,"d":"¥450"}},{"$f":"O8+ROW(O8)/10000","v":450.0008}]
[null,{"$f":"VLOOKUP(2,$L$8:$O$14,2,FALSE)","v":"会場"},{"$f":"VLOOKUP(2,$L$8:$O$14,3,FALSE)","v":{"v":500,"d":"¥500.00"}},{"$f":"VLOOKUP(2,$L$8:$O$14,4,FALSE)","v":{"v":450,"d":"¥450.00"}},{"$nulls":7},5,"装飾",{"$f":"飾りつけ経費[[#Totals],[予算]]","v":{"v":200,"d":"¥200"}},{"$f":"飾りつけ経費[[#Totals],[実際]]","v":{"v":100,"d":"¥100"}},{"$f":"O9+ROW(O9)/10000","v":100.0009}]
[null,{"$f":"VLOOKUP(3,$L$8:$O$14,2,FALSE)","v":"軽食"},{"$f":"VLOOKUP(3,$L$8:$O$14,3,FALSE)","v":{"v":300,"d":"¥300.00"}},{"$f":"VLOOKUP(3,$L$8:$O$14,4,FALSE)","v":{"v":200,"d":"¥200.00"}},{"$nulls":7},3,"軽食",{"$f":"リフレッシュメント経費[[#Totals],[予算]]","v":{"v":300,"d":"¥300"}},{"$f":"リフレッシュメント経費[[#Totals],[実際]]","v":{"v":200,"d":"¥200"}},{"v":200.001,"d":"200.0010"}]
[null,{"$f":"VLOOKUP(4,$L$8:$O$14,2,FALSE)","v":"賞品"},{"$f":"VLOOKUP(4,$L$8:$O$14,3,FALSE)","v":{"v":100,"d":"¥100.00"}},{"$f":"VLOOKUP(4,$L$8:$O$14,4,FALSE)","v":{"v":100,"d":"¥100.00"}},{"$nulls":7},1,"プログラム",{"$f":"プログラム経費[[#Totals],[予算]]","v":{"v":900,"d":"¥900"}},{"$f":"プログラム経費[[#Totals],[実際]]","v":{"v":700,"d":"¥700"}},700.0011]
[null,{"$f":"VLOOKUP(5,$L$8:$O$14,2,FALSE)","v":"装飾"},{"$f":"VLOOKUP(5,$L$8:$O$14,3,FALSE)","v":{"v":200,"d":"¥200.00"}},{"$f":"VLOOKUP(5,$L$8:$O$14,4,FALSE)","v":{"v":100,"d":"¥100.00"}},{"$nulls":7},7,"宣伝",{"$f":"広告費[[#Totals],[予算]]","v":{"v":20,"d":"¥20"}},{"$f":"広告費[[#Totals],[実際]]","v":{"v":20,"d":"¥20"}},20.0012]
[null,{"$f":"VLOOKUP(6,$L$8:$O$14,2,FALSE)","v":"その他"},{"$f":"VLOOKUP(6,$L$8:$O$14,3,FALSE)","v":{"v":70,"d":"¥70.00"}},{"$f":"VLOOKUP(6,$L$8:$O$14,4,FALSE)","v":{"v":70,"d":"¥70.00"}},{"$nulls":7},4,"賞品",{"$f":"賞品費[[#Totals],[予算]]","v":{"v":100,"d":"¥100"}},{"$f":"賞品費[[#Totals],[実際]]","v":{"v":100,"d":"¥100"}},100.0013]
[null,{"$f":"VLOOKUP(7,$L$8:$O$14,2,FALSE)","v":"宣伝"},{"$f":"VLOOKUP(7,$L$8:$O$14,3,FALSE)","v":{"v":20,"d":"¥20.00"}},{"$f":"VLOOKUP(7,$L$8:$O$14,4,FALSE)","v":{"v":20,"d":"¥20.00"}},{"$nulls":7},6,"その他",{"$f":"雑費[[#Totals],[予算]]","v":{"v":70,"d":"¥70"}},{"$f":"雑費[[#Totals],[実際]]","v":{"v":70,"d":"¥70"}},70.0014]
[null,"集計",{"$f":"SUBTOTAL(109,経費概要[予算])","v":{"v":2090,"d":"¥2,090.00"}},{"$f":"SUBTOTAL(109,経費概要[実際])","v":{"v":1640,"d":"¥1,640.00"}}]
[]
[null,"収入の概要","予算","実際",null,"実際の収入",{"$nulls":5},"ランク付け","収入","予算","実際","ランク付けの値"]
[null,{"$f":"VLOOKUP(1,$L$18:$O$21,2,FALSE)","v":"出展者/出店業者"},{"$f":"VLOOKUP(1,$L$18:$O$21,3,FALSE)","v":{"v":2600,"d":"¥2,600.00"}},{"$f":"VLOOKUP(1,$L$18:$O$21,4,FALSE)","v":{"v":2300,"d":"¥2,300.00"}},{"$nulls":7},{"$f":"_xlfn.RANK.AVG(P18,$P$18:$P$21)","v":2},"入場料",{"$f":"入場料[[#Totals],[推定される収入]]","v":{"v":900,"d":"¥900"}},{"$f":"入場料[[#Totals],[実際の収入]]","v":{"v":820,"d":"¥820"}},{"$f":"O18+ROW(O18)/10000","v":820.0018}]
[null,{"$f":"VLOOKUP(2,$L$18:$O$21,2,FALSE)","v":"入場料"},{"$f":"VLOOKUP(2,$L$18:$O$21,3,FALSE)","v":{"v":900,"d":"¥900.00"}},{"$f":"VLOOKUP(2,$L$18:$O$21,4,FALSE)","v":{"v":820,"d":"¥820.00"}},{"$nulls":7},{"$f":"_xlfn.RANK.AVG(P19,$P$18:$P$21)","v":4},"プログラム内の広告",{"$f":"プログラム内広告[[#Totals],[推定される収入]]","v":{"v":200,"d":"¥200"}},{"$f":"プログラム内広告[[#Totals],[実際の収入]]","v":{"v":300,"d":"¥300"}},300.0019]
[null,"商品の販売",{"$f":"VLOOKUP(3,$L$18:$O$21,3,FALSE)","v":{"v":750,"d":"¥750.00"}},{"$f":"VLOOKUP(3,$L$18:$O$21,4,FALSE)","v":{"v":750,"d":"¥750.00"}},{"$nulls":7},1,"出展者/出店業者",{"$f":"出展者とベンダー[[#Totals],[推定される収入]]","v":{"v":2600,"d":"¥2,600"}},{"$f":"出展者とベンダー[[#Totals],[実際の収入]]","v":{"v":2300,"d":"¥2,300"}},{"v":2300.002,"d":"2,300.0020"}]
[null,{"$f":"VLOOKUP(4,$L$18:$O$21,2,FALSE)","v":"プログラム内の広告"},{"$f":"VLOOKUP(4,$L$18:$O$21,3,FALSE)","v":{"v":200,"d":"¥200.00"}},{"$f":"VLOOKUP(4,$L$18:$O$21,4,FALSE)","v":{"v":300,"d":"¥300.00"}},{"$nulls":7},3,"商品の販売",{"$f":"品目の売上[[#Totals],[推定される収入]]","v":{"v":750,"d":"¥750"}},{"$f":"品目の売上[[#Totals],[実際の収入]]","v":{"v":750,"d":"¥750"}},750.0021]
[null,"集計",{"$f":"SUBTOTAL(109,収入概要[予算])","v":{"v":4450,"d":"¥4,450.00"}},{"$f":"SUBTOTAL(109,収入概要[実際])","v":{"v":4170,"d":"¥4,170.00"}}]
[]
[null,"損益の概要​​","予算","実際"]
[null,"収入合計",{"$f":"収入概要[[#Totals],[予算]]","v":{"v":4450,"d":"¥4,450.00"}},{"$f":"収入概要[[#Totals],[実際]]","v":{"v":4170,"d":"¥4,170.00"}}]
[null,"経費の合計",{"$f":"経費概要[[#Totals],[予算]]","v":{"v":2090,"d":"¥2,090.00"}},{"$f":"経費概要[[#Totals],[実際]]","v":{"v":1640,"d":"¥1,640.00"}}]
[null,"利益または (損失)",{"$f":"C25-C26","v":{"v":2360,"d":"¥2,360.00"}},{"$f":"D25-D26","v":{"v":2530,"d":"¥2,530.00"}}]
[]
[null,"経費対利益 (損失) 比率",null,null,"推定されるコストと実際のコスト"]