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

{"sheet":"結婚式の予算","index":0,"n_rows":16,"n_cols":16,"rows_kept":16,"merged":[[1,1,1,5]]}
[]
[null,"KAYLA + JACOB\n結婚します"]
[]
[]
[null,"カテゴリ","見積コスト","実績費用","差額","予算に対する割合 (%)",{"$nulls":3},"並べ替えなし","見積もりコスト​​","実際のコスト","見積もりコスト​​ - 順位値","順位","#","並べ替え済み"]
[null,{"$f":"P6","v":"披露宴"},{"$f":"VLOOKUP(TBL_Summary[[#This Row],[カテゴリ]],TBL_RankingData,2,FALSE)","v":{"v":14500,"d":"¥14,500"}},{"$f":"IF(VLOOKUP(TBL_Summary[[#This Row],[カテゴリ]],TBL_RankingData,3,FALSE)=0,\"\",VLOOKUP(TBL_Summary[[#This Row],[カテゴリ]],TBL_RankingData,3,FALSE))","v":{"v":12800,"d":"¥12,800"}},{"$f":"IF(OR(TBL_Summary[[#This Row],[見積コスト]]=\"\",TBL_Summary[[#This Row],[実績費用]]=\"\"),\"\",TBL_Summary[[#This Row],[見積コスト]]-TBL_Summary[[#This Row],[実績費用]])","v":{"v":1700,"d":"¥1,700"}},{"$f":"TBL_Summary[[#This Row],[見積コスト]]/SUM(TBL_Summary[見積コスト])","v":{"v":0.48739495798319327,"d":"48.7%"}},{"$nulls":3},"披露宴",{"$f":"TBL_Reception[[#Totals],[見積もり]]","v":14500},{"$f":"TBL_Reception[[#Totals],[実績]]","v":12800},{"$f":"K6-O6/100","v":14499.99},{"$f":"_xlfn.RANK.AVG(M6,$M$6:$M$15)","v":1},1,{"$f":"INDEX(TBL_RankingData,MATCH(O6,$N$6:$N$15,0),1)","v":"披露宴"}]
[null,{"$f":"P7","v":"衣装"},{"$f":"VLOOKUP(TBL_Summary[[#This Row],[カテゴリ]],TBL_RankingData,2,FALSE)","v":{"v":4000,"d":"¥4,000"}},{"$f":"IF(VLOOKUP(TBL_Summary[[#This Row],[カテゴリ]],TBL_RankingData,3,FALSE)=0,\"\",VLOOKUP(TBL_Summary[[#This Row],[カテゴリ]],TBL_RankingData,3,FALSE))","v":{"v":2900,"d":"¥2,900"}},{"$f":"IF(OR(TBL_Summary[[#This Row],[見積コスト]]=\"\",TBL_Summary[[#This Row],[実績費用]]=\"\"),\"\",TBL_Summary[[#This Row],[見積コスト]]-TBL_Summary[[#This Row],[実績費用]])","v":{"v":1100,"d":"¥1,100"}},{"$f":"TBL_Summary[[#This Row],[見積コスト]]/SUM(TBL_Summary[見積コスト])","v":{"v":0.13445378151260504,"d":"13.4%"}},{"$nulls":3},"衣装",{"$f":"TBL_Attire[[#Totals],[見積もり]]","v":4000},{"$f":"TBL_Attire[[#Totals],[実績]]","v":2900},{"$f":"K7-O7/100","v":3999.98},2,2,"衣装"]
[null,"花および装飾",{"$f":"VLOOKUP(TBL_Summary[[#This Row],[カテゴリ]],TBL_RankingData,2,FALSE)","v":{"v":3000,"d":"¥3,000"}},{"$f":"IF(VLOOKUP(TBL_Summary[[#This Row],[カテゴリ]],TBL_RankingData,3,FALSE)=0,\"\",VLOOKUP(TBL_Summary[[#This Row],[カテゴリ]],TBL_RankingData,3,FALSE))","v":""},{"$f":"IF(OR(TBL_Summary[[#This Row],[見積コスト]]=\"\",TBL_Summary[[#This Row],[実績費用]]=\"\"),\"\",TBL_Summary[[#This Row],[見積コスト]]-TBL_Summary[[#This Row],[実績費用]])","v":""},{"$f":"TBL_Summary[[#This Row],[見積コスト]]/SUM(TBL_Summary[見積コスト])","v":{"v":0.10084033613445378,"d":"10.1%"}},{"$nulls":3},"花および装飾",{"$f":"TBL_FlowersAndDecor[[#Totals],[見積もり]]","v":3000},{"$f":"TBL_FlowersAndDecor[[#Totals],[実績]]","v":0},2999.97,3,3,"花および装飾"]
[null,"写真およびビデオ",{"$f":"VLOOKUP(TBL_Summary[[#This Row],[カテゴリ]],TBL_RankingData,2,FALSE)","v":{"v":2500,"d":"¥2,500"}},{"$f":"IF(VLOOKUP(TBL_Summary[[#This Row],[カテゴリ]],TBL_RankingData,3,FALSE)=0,\"\",VLOOKUP(TBL_Summary[[#This Row],[カテゴリ]],TBL_RankingData,3,FALSE))","v":""},{"$f":"IF(OR(TBL_Summary[[#This Row],[見積コスト]]=\"\",TBL_Summary[[#This Row],[実績費用]]=\"\"),\"\",TBL_Summary[[#This Row],[見積コスト]]-TBL_Summary[[#This Row],[実績費用]])","v":""},{"$f":"TBL_Summary[[#This Row],[見積コスト]]/SUM(TBL_Summary[見積コスト])","v":{"v":0.08403361344537816,"d":"8.4%"}},{"$nulls":3},"ミュージック",{"$f":"TBL_Music[[#Totals],[見積もり]]","v":1800},{"$f":"TBL_Music[[#Totals],[実績]]","v":0},1799.96,5,4,"写真およびビデオ"]
[null,"ミュージック",{"$f":"VLOOKUP(TBL_Summary[[#This Row],[カテゴリ]],TBL_RankingData,2,FALSE)","v":{"v":1800,"d":"¥1,800"}},{"$f":"IF(VLOOKUP(TBL_Summary[[#This Row],[カテゴリ]],TBL_RankingData,3,FALSE)=0,\"\",VLOOKUP(TBL_Summary[[#This Row],[カテゴリ]],TBL_RankingData,3,FALSE))","v":""},{"$f":"IF(OR(TBL_Summary[[#This Row],[見積コスト]]=\"\",TBL_Summary[[#This Row],[実績費用]]=\"\"),\"\",TBL_Summary[[#This Row],[見積コスト]]-TBL_Summary[[#This Row],[実績費用]])","v":""},{"$f":"TBL_Summary[[#This Row],[見積コスト]]/SUM(TBL_Summary[見積コスト])","v":{"v":0.06050420168067227,"d":"6.1%"}},{"$nulls":3},"写真およびビデオ",{"$f":"TBL_PhotographsAndVideo[[#Totals],[見積もり]]","v":2500},{"$f":"TBL_PhotographsAndVideo[[#Totals],[実績]]","v":0},2499.95,4,5,"ミュージック"]
[null,"記念品およびプレゼント",{"$f":"VLOOKUP(TBL_Summary[[#This Row],[カテゴリ]],TBL_RankingData,2,FALSE)","v":{"v":1100,"d":"¥1,100"}},{"$f":"IF(VLOOKUP(TBL_Summary[[#This Row],[カテゴリ]],TBL_RankingData,3,FALSE)=0,\"\",VLOOKUP(TBL_Summary[[#This Row],[カテゴリ]],TBL_RankingData,3,FALSE))","v":""},{"$f":"IF(OR(TBL_Summary[[#This Row],[見積コスト]]=\"\",TBL_Summary[[#This Row],[実績費用]]=\"\"),\"\",TBL_Summary[[#This Row],[見積コスト]]-TBL_Summary[[#This Row],[実績費用]])","v":""},{"$f":"TBL_Summary[[#This Row],[見積コスト]]/SUM(TBL_Summary[見積コスト])","v":{"v":0.03697478991596639,"d":"3.7%"}},{"$nulls":3},"記念品およびプレゼント",{"$f":"TBL_FavorsAndGifts[[#Totals],[見積もり]]","v":1100},{"$f":"TBL_FavorsAndGifts[[#Totals],[実績]]","v":0},1099.94,6,6,"記念品およびプレゼント"]
[null,{"$f":"P12","v":"結婚指輪"},{"$f":"VLOOKUP(TBL_Summary[[#This Row],[カテゴリ]],TBL_RankingData,2,FALSE)","v":{"v":1100,"d":"¥1,100"}},{"$f":"IF(VLOOKUP(TBL_Summary[[#This Row],[カテゴリ]],TBL_RankingData,3,FALSE)=0,\"\",VLOOKUP(TBL_Summary[[#This Row],[カテゴリ]],TBL_RankingData,3,FALSE))","v":""},{"$f":"IF(OR(TBL_Summary[[#This Row],[見積コスト]]=\"\",TBL_Summary[[#This Row],[実績費用]]=\"\"),\"\",TBL_Summary[[#This Row],[見積コスト]]-TBL_Summary[[#This Row],[実績費用]])","v":""},{"$f":"TBL_Summary[[#This Row],[見積コスト]]/SUM(TBL_Summary[見積コスト])","v":{"v":0.03697478991596639,"d":"3.7%"}},{"$nulls":3},"式",{"$f":"TBL_Ceremony[[#Totals],[見積もり]]","v":800},{"$f":"TBL_Ceremony[[#Totals],[実績]]","v":0},799.93,8,7,"結婚指輪"]
[null,"式",{"$f":"VLOOKUP(TBL_Summary[[#This Row],[カテゴリ]],TBL_RankingData,2,FALSE)","v":{"v":800,"d":"¥800"}},{"$f":"IF(VLOOKUP(TBL_Summary[[#This Row],[カテゴリ]],TBL_RankingData,3,FALSE)=0,\"\",VLOOKUP(TBL_Summary[[#This Row],[カテゴリ]],TBL_RankingData,3,FALSE))","v":""},{"$f":"IF(OR(TBL_Summary[[#This Row],[見積コスト]]=\"\",TBL_Summary[[#This Row],[実績費用]]=\"\"),\"\",TBL_Summary[[#This Row],[見積コスト]]-TBL_Summary[[#This Row],[実績費用]])","v":""},{"$f":"TBL_Summary[[#This Row],[見積コスト]]/SUM(TBL_Summary[見積コスト])","v":{"v":0.02689075630252101,"d":"2.7%"}},{"$nulls":3},"ステーショナリー",{"$f":"TBL_Stationery[[#Totals],[見積もり]]","v":500},{"$f":"TBL_Stationery[[#Totals],[実績]]","v":0},499.92,9,8,"式"]
[null,"ステーショナリー",{"$f":"VLOOKUP(TBL_Summary[[#This Row],[カテゴリ]],TBL_RankingData,2,FALSE)","v":{"v":500,"d":"¥500"}},{"$f":"IF(VLOOKUP(TBL_Summary[[#This Row],[カテゴリ]],TBL_RankingData,3,FALSE)=0,\"\",VLOOKUP(TBL_Summary[[#This Row],[カテゴリ]],TBL_RankingData,3,FALSE))","v":""},{"$f":"IF(OR(TBL_Summary[[#This Row],[見積コスト]]=\"\",TBL_Summary[[#This Row],[実績費用]]=\"\"),\"\",TBL_Summary[[#This Row],[見積コスト]]-TBL_Summary[[#This Row],[実績費用]])","v":""},{"$f":"TBL_Summary[[#This Row],[見積コスト]]/SUM(TBL_Summary[見積コスト])","v":{"v":0.01680672268907563,"d":"1.7%"}},{"$nulls":3},"結婚指輪",{"$f":"TBL_WeddingRings[[#Totals],[見積もり]]","v":1100},{"$f":"TBL_WeddingRings[[#Totals],[実績]]","v":0},1099.91,7,9,"ステーショナリー"]
[null,"交通費",{"$f":"VLOOKUP(TBL_Summary[[#This Row],[カテゴリ]],TBL_RankingData,2,FALSE)","v":{"v":450,"d":"¥450"}},{"$f":"IF(VLOOKUP(TBL_Summary[[#This Row],[カテゴリ]],TBL_RankingData,3,FALSE)=0,\"\",VLOOKUP(TBL_Summary[[#This Row],[カテゴリ]],TBL_RankingData,3,FALSE))","v":""},{"$f":"IF(OR(TBL_Summary[[#This Row],[見積コスト]]=\"\",TBL_Summary[[#This Row],[実績費用]]=\"\"),\"\",TBL_Summary[[#This Row],[見積コスト]]-TBL_Summary[[#This Row],[実績費用]])","v":""},{"$f":"TBL_Summary[[#This Row],[見積コスト]]/SUM(TBL_Summary[見積コスト])","v":{"v":0.015126050420168067,"d":"1.5%"}},{"$nulls":3},"交通費",{"$f":"TBL_Transportation[[#Totals],[見積もり]]","v":450},{"$f":"TBL_Transportation[[#Totals],[実績]]","v":0},449.9,10,10,"交通費"]
[null,"集計",{"$f":"SUBTOTAL(109,TBL_Summary[見積コスト])","v":{"v":29750,"d":"¥29,750"}},{"$f":"SUBTOTAL(109,TBL_Summary[実績費用])","v":{"v":15700,"d":"¥15,700"}},{"$f":"TBL_Summary[[#Totals],[見積コスト]]-TBL_Summary[[#Totals],[実績費用]]","v":{"v":14050,"d":"¥14,050"}},{"$f":"SUBTOTAL(109,TBL_Summary[予算に対する割合 (%)])","v":{"v":1,"d":"100%"}}]

{"sheet":"予算の詳細","index":1,"n_rows":91,"n_cols":5,"rows_kept":91}
[]
[null,"予算の詳細"]
[]
[null,"披露宴","見積もり","実績","差額"]
[null,"会場およびレンタル",{"v":8000,"d":"¥8,000.00"},{"v":7800,"d":"¥7,800.00"},{"$f":"IF(OR(TBL_Reception[[#This Row],[見積もり]]=\"\",TBL_Reception[[#This Row],[実績]]=\"\"),\"\",TBL_Reception[[#This Row],[見積もり]]-TBL_Reception[[#This Row],[実績]])","v":{"v":200,"d":"¥200.00"}}]
[null,"食品およびサービス",{"v":4000,"d":"¥4,000.00"},{"v":4200,"d":"¥4,200.00"},{"$f":"IF(OR(TBL_Reception[[#This Row],[見積もり]]=\"\",TBL_Reception[[#This Row],[実績]]=\"\"),\"\",TBL_Reception[[#This Row],[見積もり]]-TBL_Reception[[#This Row],[実績]])","v":{"v":-200,"d":"(¥200.00)"}}]
[null,"飲み物",{"v":1000,"d":"¥1,000.00"},{"v":800,"d":"¥800.00"},{"$f":"IF(OR(TBL_Reception[[#This Row],[見積もり]]=\"\",TBL_Reception[[#This Row],[実績]]=\"\"),\"\",TBL_Reception[[#This Row],[見積もり]]-TBL_Reception[[#This Row],[実績]])","v":{"v":200,"d":"¥200.00"}}]
[null,"ケーキ",{"v":1000,"d":"¥1,000.00"},null,{"$f":"IF(OR(TBL_Reception[[#This Row],[見積もり]]=\"\",TBL_Reception[[#This Row],[実績]]=\"\"),\"\",TBL_Reception[[#This Row],[見積もり]]-TBL_Reception[[#This Row],[実績]])","v":""}]
[null,"雑費",{"v":500,"d":"¥500.00"},null,{"$f":"IF(OR(TBL_Reception[[#This Row],[見積もり]]=\"\",TBL_Reception[[#This Row],[実績]]=\"\"),\"\",TBL_Reception[[#This Row],[見積もり]]-TBL_Reception[[#This Row],[実績]])","v":""}]
[null,"披露宴合計",{"$f":"SUBTOTAL(109,TBL_Reception[見積もり])","v":{"v":14500,"d":"¥14,500.00"}},{"$f":"SUBTOTAL(109,TBL_Reception[実績])","v":{"v":12800,"d":"¥12,800.00"}},{"$f":"TBL_Reception[[#Totals],[見積もり]]-TBL_Reception[[#Totals],[実績]]","v":{"v":1700,"d":"¥1,700.00"}}]
[]
[]
[null,"衣装","見積もり","実績","差額"]
[null,"タキシード、スーツ、および/またはドレス",{"v":3000,"d":"¥3,000.00"},{"v":2900,"d":"¥2,900.00"},{"$f":"IF(OR(TBL_Attire[[#This Row],[見積もり]]=\"\",TBL_Attire[[#This Row],[実績]]=\"\"),\"\",TBL_Attire[[#This Row],[見積もり]]-TBL_Attire[[#This Row],[実績]])","v":{"v":100,"d":"¥100.00"}}]
[null,"寸法直し",{"v":100,"d":"¥100.00"},null,{"$f":"IF(OR(TBL_Attire[[#This Row],[見積もり]]=\"\",TBL_Attire[[#This Row],[実績]]=\"\"),\"\",TBL_Attire[[#This Row],[見積もり]]-TBL_Attire[[#This Row],[実績]])","v":""}]
[null,"ティアラおよびベール",{"v":200,"d":"¥200.00"},null,{"$f":"IF(OR(TBL_Attire[[#This Row],[見積もり]]=\"\",TBL_Attire[[#This Row],[実績]]=\"\"),\"\",TBL_Attire[[#This Row],[見積もり]]-TBL_Attire[[#This Row],[実績]])","v":""}]
[null,"付属品",{"v":100,"d":"¥100.00"},null,{"$f":"IF(OR(TBL_Attire[[#This Row],[見積もり]]=\"\",TBL_Attire[[#This Row],[実績]]=\"\"),\"\",TBL_Attire[[#This Row],[見積もり]]-TBL_Attire[[#This Row],[実績]])","v":""}]
[null,"髪およびメイク",{"v":500,"d":"¥500.00"},null,{"$f":"IF(OR(TBL_Attire[[#This Row],[見積もり]]=\"\",TBL_Attire[[#This Row],[実績]]=\"\"),\"\",TBL_Attire[[#This Row],[見積もり]]-TBL_Attire[[#This Row],[実績]])","v":""}]
[null,"雑費",{"v":100,"d":"¥100.00"},null,{"$f":"IF(OR(TBL_Attire[[#This Row],[見積もり]]=\"\",TBL_Attire[[#This Row],[実績]]=\"\"),\"\",TBL_Attire[[#This Row],[見積もり]]-TBL_Attire[[#This Row],[実績]])","v":""}]
[null,"衣装の合計",{"$f":"SUBTOTAL(109,TBL_Attire[見積もり])","v":{"v":4000,"d":"¥4,000.00"}},{"$f":"SUBTOTAL(109,TBL_Attire[実績])","v":{"v":2900,"d":"¥2,900.00"}},{"$f":"TBL_Attire[[#Totals],[見積もり]]-TBL_Attire[[#Totals],[実績]]","v":{"v":1100,"d":"¥1,100.00"}}]
[]
[]
[null,"花および装飾","見積もり","実績","差額"]
[null,"式用の生け花",{"v":1000,"d":"¥1,000.00"},null,{"$f":"IF(OR(TBL_FlowersAndDecor[[#This Row],[見積もり]]=\"\",TBL_FlowersAndDecor[[#This Row],[実績]]=\"\"),\"\",TBL_FlowersAndDecor[[#This Row],[見積もり]]-TBL_FlowersAndDecor[[#This Row],[実績]])","v":""}]
[null,"フラワー ガールの花およびバスケット",{"v":500,"d":"¥500.00"},null,{"$f":"IF(OR(TBL_FlowersAndDecor[[#This Row],[見積もり]]=\"\",TBL_FlowersAndDecor[[#This Row],[実績]]=\"\"),\"\",TBL_FlowersAndDecor[[#This Row],[見積もり]]-TBL_FlowersAndDecor[[#This Row],[実績]])","v":""}]
[null,"リングピロー",{"v":100,"d":"¥100.00"},null,{"$f":"IF(OR(TBL_FlowersAndDecor[[#This Row],[見積もり]]=\"\",TBL_FlowersAndDecor[[#This Row],[実績]]=\"\"),\"\",TBL_FlowersAndDecor[[#This Row],[見積もり]]-TBL_FlowersAndDecor[[#This Row],[実績]])","v":""}]
[null,"ブーケ",{"v":500,"d":"¥500.00"},null,{"$f":"IF(OR(TBL_FlowersAndDecor[[#This Row],[見積もり]]=\"\",TBL_FlowersAndDecor[[#This Row],[実績]]=\"\"),\"\",TBL_FlowersAndDecor[[#This Row],[見積もり]]-TBL_FlowersAndDecor[[#This Row],[実績]])","v":""}]
[null,"ブートニエール",{"v":100,"d":"¥100.00"},null,{"$f":"IF(OR(TBL_FlowersAndDecor[[#This Row],[見積もり]]=\"\",TBL_FlowersAndDecor[[#This Row],[実績]]=\"\"),\"\",TBL_FlowersAndDecor[[#This Row],[見積もり]]-TBL_FlowersAndDecor[[#This Row],[実績]])","v":""}]
[null,"コサージュ",{"v":200,"d":"¥200.00"},null,{"$f":"IF(OR(TBL_FlowersAndDecor[[#This Row],[見積もり]]=\"\",TBL_FlowersAndDecor[[#This Row],[実績]]=\"\"),\"\",TBL_FlowersAndDecor[[#This Row],[見積もり]]-TBL_FlowersAndDecor[[#This Row],[実績]])","v":""}]
[null,"披露宴の装飾",{"v":300,"d":"¥300.00"},null,{"$f":"IF(OR(TBL_FlowersAndDecor[[#This Row],[見積もり]]=\"\",TBL_FlowersAndDecor[[#This Row],[実績]]=\"\"),\"\",TBL_FlowersAndDecor[[#This Row],[見積もり]]-TBL_FlowersAndDecor[[#This Row],[実績]])","v":""}]
[null,"照明",{"v":200,"d":"¥200.00"},null,{"$f":"IF(OR(TBL_FlowersAndDecor[[#This Row],[見積もり]]=\"\",TBL_FlowersAndDecor[[#This Row],[実績]]=\"\"),\"\",TBL_FlowersAndDecor[[#This Row],[見積もり]]-TBL_FlowersAndDecor[[#This Row],[実績]])","v":""}]
[null,"雑費",{"v":100,"d":"¥100.00"},null,{"$f":"IF(OR(TBL_FlowersAndDecor[[#This Row],[見積もり]]=\"\",TBL_FlowersAndDecor[[#This Row],[実績]]=\"\"),\"\",TBL_FlowersAndDecor[[#This Row],[見積もり]]-TBL_FlowersAndDecor[[#This Row],[実績]])","v":""}]
[null,"花および装飾の合計",{"$f":"SUBTOTAL(109,TBL_FlowersAndDecor[見積もり])","v":{"v":3000,"d":"¥3,000.00"}},{"$f":"SUBTOTAL(109,TBL_FlowersAndDecor[実績])","v":{"v":0,"d":"¥0.00"}},{"$f":"TBL_FlowersAndDecor[[#Totals],[見積もり]]-TBL_FlowersAndDecor[[#Totals],[実績]]","v":{"v":3000,"d":"¥3,000.00"}}]
[]
[]
[null,"音楽","見積もり","実績","差額"]
[null,"式の演奏者",{"v":700,"d":"¥700.00"},null,{"$f":"IF(OR(TBL_Music[[#This Row],[見積もり]]=\"\",TBL_Music[[#This Row],[実績]]=\"\"),\"\",TBL_Music[[#This Row],[見積もり]]-TBL_Music[[#This Row],[実績]])","v":""}]
[null,"カクテルアワーの演奏者",{"v":300,"d":"¥300.00"},null,{"$f":"IF(OR(TBL_Music[[#This Row],[見積もり]]=\"\",TBL_Music[[#This Row],[実績]]=\"\"),\"\",TBL_Music[[#This Row],[見積もり]]-TBL_Music[[#This Row],[実績]])","v":""}]
[null,"披露宴のバンド、ディージェー、またはエンターテイメント",{"v":200,"d":"¥200.00"},null,{"$f":"IF(OR(TBL_Music[[#This Row],[見積もり]]=\"\",TBL_Music[[#This Row],[実績]]=\"\"),\"\",TBL_Music[[#This Row],[見積もり]]-TBL_Music[[#This Row],[実績]])","v":""}]
[null,"サウンド システムまたはダンス フロアのレンタル",{"v":400,"d":"¥400.00"},null,{"$f":"IF(OR(TBL_Music[[#This Row],[見積もり]]=\"\",TBL_Music[[#This Row],[実績]]=\"\"),\"\",TBL_Music[[#This Row],[見積もり]]-TBL_Music[[#This Row],[実績]])","v":""}]
[null,"雑費",{"v":200,"d":"¥200.00"},null,{"$f":"IF(OR(TBL_Music[[#This Row],[見積もり]]=\"\",TBL_Music[[#This Row],[実績]]=\"\"),\"\",TBL_Music[[#This Row],[見積もり]]-TBL_Music[[#This Row],[実績]])","v":""}]
[null,"音楽の合計",{"$f":"SUBTOTAL(109,TBL_Music[見積もり])","v":{"v":1800,"d":"¥1,800.00"}},{"$f":"SUBTOTAL(109,TBL_Music[実績])","v":{"v":0,"d":"¥0.00"}},{"$f":"TBL_Music[[#Totals],[見積もり]]-TBL_Music[[#Totals],[実績]]","v":{"v":1800,"d":"¥1,800.00"}}]
[]
[]
[null,"写真およびビデオ","見積もり","実績","差額"]
[null,"写真",{"v":1000,"d":"¥1,000.00"},null,{"$f":"IF(OR(TBL_PhotographsAndVideo[[#This Row],[見積もり]]=\"\",TBL_PhotographsAndVideo[[#This Row],[実績]]=\"\"),\"\",TBL_PhotographsAndVideo[[#This Row],[見積もり]]-TBL_PhotographsAndVideo[[#This Row],[実績]])","v":""}]
[null,"ビデオ撮影",{"v":800,"d":"¥800.00"},null,{"$f":"IF(OR(TBL_PhotographsAndVideo[[#This Row],[見積もり]]=\"\",TBL_PhotographsAndVideo[[#This Row],[実績]]=\"\"),\"\",TBL_PhotographsAndVideo[[#This Row],[見積もり]]-TBL_PhotographsAndVideo[[#This Row],[実績]])","v":""}]
[null,"追加の印刷物とアルバム",{"v":500,"d":"¥500.00"},null,{"$f":"IF(OR(TBL_PhotographsAndVideo[[#This Row],[見積もり]]=\"\",TBL_PhotographsAndVideo[[#This Row],[実績]]=\"\"),\"\",TBL_PhotographsAndVideo[[#This Row],[見積もり]]-TBL_PhotographsAndVideo[[#This Row],[実績]])","v":""}]
[null,"雑費",{"v":200,"d":"¥200.00"},null,{"$f":"IF(OR(TBL_PhotographsAndVideo[[#This Row],[見積もり]]=\"\",TBL_PhotographsAndVideo[[#This Row],[実績]]=\"\"),\"\",TBL_PhotographsAndVideo[[#This Row],[見積もり]]-TBL_PhotographsAndVideo[[#This Row],[実績]])","v":""}]
[null,"写真およびビデオの合計",{"$f":"SUBTOTAL(109,TBL_PhotographsAndVideo[見積もり])","v":{"v":2500,"d":"¥2,500.00"}},{"$f":"SUBTOTAL(109,TBL_PhotographsAndVideo[実績])","v":{"v":0,"d":"¥0.00"}},{"$f":"TBL_PhotographsAndVideo[[#Totals],[見積もり]]-TBL_PhotographsAndVideo[[#Totals],[実績]]","v":{"v":2500,"d":"¥2,500.00"}}]
[]
[]
[null,"記念品および贈り物","見積もり","実績","差額"]
[null,"ウェルカム ギフト",{"v":700,"d":"¥700.00"},null,{"$f":"IF(OR(TBL_FavorsAndGifts[[#This Row],[見積もり]]=\"\",TBL_FavorsAndGifts[[#This Row],[実績]]=\"\"),\"\",TBL_FavorsAndGifts[[#This Row],[見積もり]]-TBL_FavorsAndGifts[[#This Row],[実績]])","v":""}]
[null,"パーティーギフト",{"v":200,"d":"¥200.00"},null,{"$f":"IF(OR(TBL_FavorsAndGifts[[#This Row],[見積もり]]=\"\",TBL_FavorsAndGifts[[#This Row],[実績]]=\"\"),\"\",TBL_FavorsAndGifts[[#This Row],[見積もり]]-TBL_FavorsAndGifts[[#This Row],[実績]])","v":""}]
[null,"雑費",{"v":200,"d":"¥200.00"},null,{"$f":"IF(OR(TBL_FavorsAndGifts[[#This Row],[見積もり]]=\"\",TBL_FavorsAndGifts[[#This Row],[実績]]=\"\"),\"\",TBL_FavorsAndGifts[[#This Row],[見積もり]]-TBL_FavorsAndGifts[[#This Row],[実績]])","v":""}]
[null,"記念品および贈り物の合計",{"$f":"SUBTOTAL(109,TBL_FavorsAndGifts[見積もり])","v":{"v":1100,"d":"¥1,100.00"}},{"$f":"SUBTOTAL(109,TBL_FavorsAndGifts[実績])","v":{"v":0,"d":"¥0.00"}},{"$f":"TBL_FavorsAndGifts[[#Totals],[見積もり]]-TBL_FavorsAndGifts[[#Totals],[実績]]","v":{"v":1100,"d":"¥1,100.00"}}]
[]
[]
[null,"式","見積もり","実績","差額"]
[null,"サイト料金",{"v":500,"d":"¥500.00"},null,{"$f":"IF(OR(TBL_Ceremony[[#This Row],[見積もり]]=\"\",TBL_Ceremony[[#This Row],[実績]]=\"\"),\"\",TBL_Ceremony[[#This Row],[見積もり]]-TBL_Ceremony[[#This Row],[実績]])","v":""}]
[null,"司式者の料金または教会寄付",{"v":200,"d":"¥200.00"},null,{"$f":"IF(OR(TBL_Ceremony[[#This Row],[見積もり]]=\"\",TBL_Ceremony[[#This Row],[実績]]=\"\"),\"\",TBL_Ceremony[[#This Row],[見積もり]]-TBL_Ceremony[[#This Row],[実績]])","v":""}]
[null,"雑費",{"v":100,"d":"¥100.00"},null,{"$f":"IF(OR(TBL_Ceremony[[#This Row],[見積もり]]=\"\",TBL_Ceremony[[#This Row],[実績]]=\"\"),\"\",TBL_Ceremony[[#This Row],[見積もり]]-TBL_Ceremony[[#This Row],[実績]])","v":""}]
[null,"式の合計",{"$f":"SUBTOTAL(109,TBL_Ceremony[見積もり])","v":{"v":800,"d":"¥800.00"}},{"$f":"SUBTOTAL(109,TBL_Ceremony[実績])","v":{"v":0,"d":"¥0.00"}},{"$f":"TBL_Ceremony[[#Totals],[見積もり]]-TBL_Ceremony[[#Totals],[実績]]","v":{"v":800,"d":"¥800.00"}}]
[]
[]
[null,"文房具","見積もり","実績","差額"]
[null,"セーブ ザ デート カード",{"v":50,"d":"¥50.00"},null,{"$f":"IF(OR(TBL_Stationery[[#This Row],[見積もり]]=\"\",TBL_Stationery[[#This Row],[実績]]=\"\"),\"\",TBL_Stationery[[#This Row],[見積もり]]-TBL_Stationery[[#This Row],[実績]])","v":""}]
[null,"招待状および出欠確認",{"v":100,"d":"¥100.00"},null,{"$f":"IF(OR(TBL_Stationery[[#This Row],[見積もり]]=\"\",TBL_Stationery[[#This Row],[実績]]=\"\"),\"\",TBL_Stationery[[#This Row],[見積もり]]-TBL_Stationery[[#This Row],[実績]])","v":""}]
[null,"プログラム",{"v":50,"d":"¥50.00"},null,{"$f":"IF(OR(TBL_Stationery[[#This Row],[見積もり]]=\"\",TBL_Stationery[[#This Row],[実績]]=\"\"),\"\",TBL_Stationery[[#This Row],[見積もり]]-TBL_Stationery[[#This Row],[実績]])","v":""}]
[null,"座席および位置カード",{"v":50,"d":"¥50.00"},null,{"$f":"IF(OR(TBL_Stationery[[#This Row],[見積もり]]=\"\",TBL_Stationery[[#This Row],[実績]]=\"\"),\"\",TBL_Stationery[[#This Row],[見積もり]]-TBL_Stationery[[#This Row],[実績]])","v":""}]
[null,"メニューカード",{"v":50,"d":"¥50.00"},null,{"$f":"IF(OR(TBL_Stationery[[#This Row],[見積もり]]=\"\",TBL_Stationery[[#This Row],[実績]]=\"\"),\"\",TBL_Stationery[[#This Row],[見積もり]]-TBL_Stationery[[#This Row],[実績]])","v":""}]
[null,"お礼状",{"v":50,"d":"¥50.00"},null,{"$f":"IF(OR(TBL_Stationery[[#This Row],[見積もり]]=\"\",TBL_Stationery[[#This Row],[実績]]=\"\"),\"\",TBL_Stationery[[#This Row],[見積もり]]-TBL_Stationery[[#This Row],[実績]])","v":""}]
[null,"送料",{"v":50,"d":"¥50.00"},null,{"$f":"IF(OR(TBL_Stationery[[#This Row],[見積もり]]=\"\",TBL_Stationery[[#This Row],[実績]]=\"\"),\"\",TBL_Stationery[[#This Row],[見積もり]]-TBL_Stationery[[#This Row],[実績]])","v":""}]
[null,"雑費",{"v":100,"d":"¥100.00"},null,{"$f":"IF(OR(TBL_Stationery[[#This Row],[見積もり]]=\"\",TBL_Stationery[[#This Row],[実績]]=\"\"),\"\",TBL_Stationery[[#This Row],[見積もり]]-TBL_Stationery[[#This Row],[実績]])","v":""}]
[null,"文房具の合計",{"$f":"SUBTOTAL(109,TBL_Stationery[見積もり])","v":{"v":500,"d":"¥500.00"}},{"$f":"SUBTOTAL(109,TBL_Stationery[実績])","v":{"v":0,"d":"¥0.00"}},{"$f":"TBL_Stationery[[#Totals],[見積もり]]-TBL_Stationery[[#Totals],[実績]]","v":{"v":500,"d":"¥500.00"}}]
[]
[]
[null,"結婚指輪","見積もり","実績","差額"]
[null,"結婚指輪",{"v":1000,"d":"¥1,000.00"},null,{"$f":"IF(OR(TBL_WeddingRings[[#This Row],[見積もり]]=\"\",TBL_WeddingRings[[#This Row],[実績]]=\"\"),\"\",TBL_WeddingRings[[#This Row],[見積もり]]-TBL_WeddingRings[[#This Row],[実績]])","v":""}]
[null,"リング アクセサリ",{"v":100,"d":"¥100.00"},null,{"$f":"IF(OR(TBL_WeddingRings[[#This Row],[見積もり]]=\"\",TBL_WeddingRings[[#This Row],[実績]]=\"\"),\"\",TBL_WeddingRings[[#This Row],[見積もり]]-TBL_WeddingRings[[#This Row],[実績]])","v":""}]
[null,"結婚指輪の合計",{"$f":"SUBTOTAL(109,TBL_WeddingRings[見積もり])","v":{"v":1100,"d":"¥1,100.00"}},{"$f":"SUBTOTAL(109,TBL_WeddingRings[実績])","v":{"v":0,"d":"¥0.00"}},{"$f":"TBL_WeddingRings[[#Totals],[見積もり]]-TBL_WeddingRings[[#Totals],[実績]]","v":{"v":1100,"d":"¥1,100.00"}}]
[]
[]
[null,"交通費  ","見積もり","実績","差額"]
[null,"メイン レンタカー",{"v":100,"d":"¥100.00"},null,{"$f":"IF(OR(TBL_Transportation[[#This Row],[見積もり]]=\"\",TBL_Transportation[[#This Row],[実績]]=\"\"),\"\",TBL_Transportation[[#This Row],[見積もり]]-TBL_Transportation[[#This Row],[実績]])","v":""}]
[null,"ゲスト レンタカー",{"v":100,"d":"¥100.00"},null,{"$f":"IF(OR(TBL_Transportation[[#This Row],[見積もり]]=\"\",TBL_Transportation[[#This Row],[実績]]=\"\"),\"\",TBL_Transportation[[#This Row],[見積もり]]-TBL_Transportation[[#This Row],[実績]])","v":""}]
[null,"郊外のお客様向け交通",{"v":100,"d":"¥100.00"},null,{"$f":"IF(OR(TBL_Transportation[[#This Row],[見積もり]]=\"\",TBL_Transportation[[#This Row],[実績]]=\"\"),\"\",TBL_Transportation[[#This Row],[見積もり]]-TBL_Transportation[[#This Row],[実績]])","v":""}]
[null,"バレー パーキング",{"v":50,"d":"¥50.00"},null,{"$f":"IF(OR(TBL_Transportation[[#This Row],[見積もり]]=\"\",TBL_Transportation[[#This Row],[実績]]=\"\"),\"\",TBL_Transportation[[#This Row],[見積もり]]-TBL_Transportation[[#This Row],[実績]])","v":""}]
[null,"雑費",{"v":100,"d":"¥100.00"},null,{"$f":"IF(OR(TBL_Transportation[[#This Row],[見積もり]]=\"\",TBL_Transportation[[#This Row],[実績]]=\"\"),\"\",TBL_Transportation[[#This Row],[見積もり]]-TBL_Transportation[[#This Row],[実績]])","v":""}]
[null,"交通費の合計",{"$f":"SUBTOTAL(109,TBL_Transportation[見積もり])","v":{"v":450,"d":"¥450.00"}},{"$f":"SUBTOTAL(109,TBL_Transportation[実績])","v":{"v":0,"d":"¥0.00"}},{"$f":"TBL_Transportation[[#Totals],[見積もり]]-TBL_Transportation[[#Totals],[実績]]","v":{"v":450,"d":"¥450.00"}}]