{"text_format":"3","workbook":"xlsx","n_sheets":2,"sheets":["予算の概要","予算の詳細"],"not_rendered":{"images":1,"defined_names":1},"read":"whole","date_system":"1900"}

{"sheet":"予算の概要","index":0,"n_rows":28,"n_cols":7,"rows_kept":28}
[{"$nulls":6}," "]
[]
[null,"集計結婚式の予算",{"v":20000,"d":"¥20,000"}]
[]
[null,"経費","割り当て\n%","割り当て済み予算","現在の見積\nコスト","実際\nコスト"]
[null,"披露宴",{"v":0.5,"d":"¥1"},{"$f":"結婚式_予算_集計*予算の概要!$C6","v":{"v":10000,"d":"¥10,000"}},{"$f":"テーブル_披露宴[[#Totals],[見積もりコスト​​]]","v":{"v":0,"d":"¥0"}},{"$f":"テーブル_披露宴[[#Totals],[実際のコスト]]","v":{"v":0,"d":"¥0"}}]
[null,"衣装",{"v":0.1,"d":"¥0"},{"$f":"結婚式_予算_集計*予算の概要!$C7","v":{"v":2000,"d":"¥2,000"}},{"$f":"テーブル_衣装[[#Totals],[見積もりコスト​​]]","v":{"v":0,"d":"¥0"}},{"$f":"テーブル_衣装[[#Totals],[実際のコスト]]","v":{"v":0,"d":"¥0"}}]
[null,"花および装飾",{"v":0.1,"d":"¥0"},{"$f":"結婚式_予算_集計*予算の概要!$C8","v":{"v":2000,"d":"¥2,000"}},{"$f":"テーブル_花と装飾[[#Totals],[見積もりコスト​​]]","v":{"v":0,"d":"¥0"}},{"$f":"テーブル_花と装飾[[#Totals],[実際のコスト]]","v":{"v":0,"d":"¥0"}}]
[null,"音楽",{"v":0.1,"d":"¥0"},{"$f":"結婚式_予算_集計*予算の概要!$C9","v":{"v":2000,"d":"¥2,000"}},{"$f":"テーブル_音楽[[#Totals],[見積もりコスト​​]]","v":{"v":0,"d":"¥0"}},{"$f":"テーブル_音楽[[#Totals],[実際のコスト]]","v":{"v":0,"d":"¥0"}}]
[null,"写真およびビデオ",{"v":0.1,"d":"¥0"},{"$f":"結婚式_予算_集計*予算の概要!$C10","v":{"v":2000,"d":"¥2,000"}},{"$f":"テーブル_写真と動画[[#Totals],[見積もりコスト​​]]","v":{"v":0,"d":"¥0"}},{"$f":"テーブル_写真と動画[[#Totals],[実際のコスト]]","v":{"v":0,"d":"¥0"}}]
[null,"記念品およびプレゼント",{"v":0.03,"d":"¥0"},{"$f":"結婚式_予算_集計*予算の概要!$C11","v":{"v":600,"d":"¥600"}},{"$f":"テーブル_記念品とギフト[[#Totals],[見積もりコスト​​]]","v":{"v":0,"d":"¥0"}},{"$f":"テーブル_記念品とギフト[[#Totals],[実際のコスト]]","v":{"v":0,"d":"¥0"}}]
[null,"式",{"v":0.02,"d":"¥0"},{"$f":"結婚式_予算_集計*予算の概要!$C12","v":{"v":400,"d":"¥400"}},{"$f":"テーブル_式[[#Totals],[見積もりコスト​​]]","v":{"v":0,"d":"¥0"}},{"$f":"テーブル_式[[#Totals],[実際のコスト]]","v":{"v":0,"d":"¥0"}}]
[null,"ステーショナリー",{"v":0.02,"d":"¥0"},{"$f":"結婚式_予算_集計*予算の概要!$C13","v":{"v":400,"d":"¥400"}},{"$f":"テーブル_便箋[[#Totals],[見積もりコスト​​]]","v":{"v":0,"d":"¥0"}},{"$f":"テーブル_便箋[[#Totals],[実際のコスト]]","v":{"v":0,"d":"¥0"}}]
[null,"結婚指輪",{"v":0.02,"d":"¥0"},{"$f":"結婚式_予算_集計*予算の概要!$C14","v":{"v":400,"d":"¥400"}},{"$f":"テーブル_結婚指輪[[#Totals],[見積もりコスト​​]]","v":{"v":0,"d":"¥0"}},{"$f":"テーブル_結婚指輪[[#Totals],[実際のコスト]]","v":{"v":0,"d":"¥0"}}]
[null,"交通費",{"v":0.01,"d":"¥0"},{"$f":"結婚式_予算_集計*予算の概要!$C15","v":{"v":200,"d":"¥200"}},{"$f":"テーブル_交通[[#Totals],[見積もりコスト​​]]","v":{"v":0,"d":"¥0"}},{"$f":"テーブル_交通[[#Totals],[実際のコスト]]","v":{"v":0,"d":"¥0"}}]
[null,"集計",{"$f":"SUM(C6:C15)","v":{"v":1,"d":"¥1"}},{"$f":"SUM(D6:D15)","v":{"v":20000,"d":"¥20,000"}},{"v":0,"d":"¥0"},{"v":0,"d":"¥0"}]
[]
[null,"事業主負担"]
[null,"資金源","出資金"]
[null,"貯蓄",{"v":10000,"d":"¥10,000"}]
[null,"パートナー 1 の両親",{"v":4000,"d":"¥4,000"}]
[null,"パートナー 1 の祖父母",{"v":2000,"d":"¥2,000"}]
[null,"パートナー 2 の両親",{"v":4000,"d":"¥4,000"}]
[null,"パートナー 2 の祖父母",{"v":4000,"d":"¥4,000"}]
[null,"その他の出資金",{"v":2000,"d":"¥2,000"}]
[null,"集計",{"$f":"SUBTOTAL(109,テーブル_出資金[出資金])","v":{"v":26000,"d":"¥26,000"}}]
[]
[null,{"$f":"IF(テーブル_出資金[[#Totals],[出資金]]<結婚式_予算_集計,\"構成の違い\",\"利用可能な追加の資金\")","v":"利用可能な追加の資金"},{"$f":"IF(テーブル_出資金[[#Totals],[出資金]]<結婚式_予算_集計,結婚式_予算_集計-テーブル_出資金[[#Totals],[出資金]],テーブル_出資金[[#Totals],[出資金]]-結婚式_予算_集計)","v":{"v":6000,"d":"¥6,000"}}]

{"sheet":"予算の詳細","index":1,"n_rows":80,"n_cols":4,"rows_kept":80}
[]
[null,"披露宴","見積もりコスト​​","実際のコスト"]
[null,"会場およびレンタル"]
[null,"食品およびサービス"]
[null,"飲み物"]
[null,"ケーキ"]
[null,"雑費"]
[null,"集計",{"$f":"SUBTOTAL(109,テーブル_披露宴[見積もりコスト​​])","v":{"v":0,"d":"¥0.00"}},{"$f":"SUBTOTAL(109,テーブル_披露宴[実際のコスト])","v":{"v":0,"d":"¥0.00"}}]
[]
[null,"衣装","見積もりコスト​​","実際のコスト"]
[null,"タキシード、スーツ、および/またはドレス"]
[null,"寸法直し"]
[null,"ティアラおよびベール"]
[null,"付属品"]
[null,"髪およびメイク"]
[null,"雑費"]
[null,"集計",{"$f":"SUBTOTAL(109,テーブル_衣装[見積もりコスト​​])","v":{"v":0,"d":"¥0.00"}},{"$f":"SUBTOTAL(109,テーブル_衣装[実際のコスト])","v":{"v":0,"d":"¥0.00"}}]
[]
[null,"花および装飾","見積もりコスト​​","実際のコスト"]
[null,"式用の生け花"]
[null,"フラワー ガールの花およびバスケット"]
[null,"リングピロー"]
[null,"ブーケ"]
[null,"ブートニエール"]
[null,"コサージュ"]
[null,"披露宴の装飾"]
[null,"照明"]
[null,"雑費"]
[null,"集計",{"$f":"SUBTOTAL(109,テーブル_花と装飾[見積もりコスト​​])","v":{"v":0,"d":"¥0.00"}},{"$f":"SUBTOTAL(109,テーブル_花と装飾[実際のコスト])","v":{"v":0,"d":"¥0.00"}}]
[]
[null,"音楽","見積もりコスト​​","実際のコスト"]
[null,"式の演奏者"]
[null,"カクテルアワーの演奏者"]
[null,"披露宴のバンド、ディージェー、またはエンターテイメント"]
[null,"サウンド システムまたはダンス フロアのレンタル"]
[null,"雑費"]
[null,"集計",{"$f":"SUBTOTAL(109,テーブル_音楽[見積もりコスト​​])","v":{"v":0,"d":"¥0.00"}},{"$f":"SUBTOTAL(109,テーブル_音楽[実際のコスト])","v":{"v":0,"d":"¥0.00"}}]
[]
[null,"写真およびビデオ","見積もりコスト​​","実際のコスト"]
[null,"写真"]
[null,"ビデオ撮影"]
[null,"追加の印刷物とアルバム"]
[null,"雑費"]
[null,"集計",{"$f":"SUBTOTAL(109,テーブル_写真と動画[見積もりコスト​​])","v":{"v":0,"d":"¥0.00"}},{"$f":"SUBTOTAL(109,テーブル_写真と動画[実際のコスト])","v":{"v":0,"d":"¥0.00"}}]
[]
[null,"記念品およびプレゼント","見積もりコスト​​","実際のコスト"]
[null,"ウェルカム ギフト"]
[null,"パーティーギフト"]
[null,"雑費"]
[null,"集計",{"$f":"SUBTOTAL(109,テーブル_記念品とギフト[見積もりコスト​​])","v":{"v":0,"d":"¥0.00"}},{"$f":"SUBTOTAL(109,テーブル_記念品とギフト[実際のコスト])","v":{"v":0,"d":"¥0.00"}}]
[]
[null,"式","見積もりコスト​​","実際のコスト"]
[null,"サイト料金"]
[null,"司式者の料金または教会寄付"]
[null,"雑費"]
[null,"集計",{"$f":"SUBTOTAL(109,テーブル_式[見積もりコスト​​])","v":{"v":0,"d":"¥0.00"}},{"$f":"SUBTOTAL(109,テーブル_式[実際のコスト])","v":{"v":0,"d":"¥0.00"}}]
[]
[null,"ステーショナリー","見積もりコスト​​","実際のコスト"]
[null,"セーブ ザ デート カード"]
[null,"招待状および出欠確認"]
[null,"プログラム"]
[null,"座席および位置カード"]
[null,"メニューカード"]
[null,"お礼状"]
[null,"送料"]
[null,"雑費"]
[null,"集計",{"$f":"SUBTOTAL(109,テーブル_便箋[見積もりコスト​​])","v":{"v":0,"d":"¥0.00"}},{"$f":"SUBTOTAL(109,テーブル_便箋[実際のコスト])","v":{"v":0,"d":"¥0.00"}}]
[]
[null,"結婚指輪","見積もりコスト​​","実際のコスト"]
[null,"結婚指輪"]
[null,"リング アクセサリ"]
[null,"集計",{"$f":"SUBTOTAL(109,テーブル_結婚指輪[見積もりコスト​​])","v":{"v":0,"d":"¥0.00"}},{"$f":"SUBTOTAL(109,テーブル_結婚指輪[実際のコスト])","v":{"v":0,"d":"¥0.00"}}]
[]
[null,"交通費","見積もりコスト​​","実際のコスト"]
[null,"メイン レンタカー"]
[null,"ゲスト レンタカー"]
[null,"郊外のお客様向け交通"]
[null,"バレー パーキング"]
[null,"雑費"]
[null,"集計",{"$f":"SUBTOTAL(109,テーブル_交通[見積もりコスト​​])","v":{"v":0,"d":"¥0.00"}},{"$f":"SUBTOTAL(109,テーブル_交通[実際のコスト])","v":{"v":0,"d":"¥0.00"}}]