{"text_format":"3","workbook":"xlsx","n_sheets":1,"sheets":["バスルーム改装費用"],"not_rendered":{"defined_names":3},"read":"whole","date_system":"1900"}

{"sheet":"バスルーム改装費用","index":0,"n_rows":24,"n_cols":10,"rows_kept":24,"merged":[[1,1,2,3],[2,4,2,6],[2,7,2,9],[22,1,22,3],[22,4,22,6],[22,7,22,9],[23,1,23,3],[23,4,23,6],[23,7,23,9]]}
[null,"バスルーム改装費用ワークシート"]
[null,"注:テーブルの差額列には、実際の金額が見積金額を超えたかどうかが示されます。超えた場合 (マイナス) は赤で、超えていない場合 (プラス) の場合は黒で表示されます。 "]
[{"$nulls":4},"項目別費用 (¥)",null,null,"合計費用 (¥)"]
[null,"区分","項目","数量","見積り","実際","差額","見積り ","実際 ","差額 "]
[null,"バス/シャワー","浴槽、鋳鉄、1.5 m、標準",1,{"v":250,"d":"¥250.00"},{"$f":"RANDBETWEEN(E5+2,E5+20)","v":{"v":267,"d":"¥267.00"}},{"$f":"IFERROR(コスト[[#This Row],[見積り]]-コスト[[#This Row],[実際]], \"\")","v":{"v":-17,"d":"(¥17.00)"}},{"$f":"IFERROR(コスト[[#This Row],[数量]]*コスト[[#This Row],[見積り]], \"\")","v":{"v":250,"d":"¥250.00"}},{"$f":"IFERROR(コスト[[#This Row],[数量]]*コスト[[#This Row],[実際]], \"\")","v":{"v":267,"d":"¥267.00"}},{"$f":"IFERROR(コスト[[#This Row],[見積り ]]-コスト[[#This Row],[実際 ]], \"\")","v":{"v":-17,"d":"(¥17.00)"}}]
[null,"バス/シャワー","シャワー ドア、ヒンジ、標準",1,{"v":200,"d":"¥200.00"},{"v":214,"d":"¥214.00"},{"$f":"IFERROR(コスト[[#This Row],[見積り]]-コスト[[#This Row],[実際]], \"\")","v":{"v":-14,"d":"(¥14.00)"}},{"$f":"IFERROR(コスト[[#This Row],[数量]]*コスト[[#This Row],[見積り]], \"\")","v":{"v":200,"d":"¥200.00"}},{"$f":"IFERROR(コスト[[#This Row],[数量]]*コスト[[#This Row],[実際]], \"\")","v":{"v":214,"d":"¥214.00"}},{"$f":"IFERROR(コスト[[#This Row],[見積り ]]-コスト[[#This Row],[実際 ]], \"\")","v":{"v":-14,"d":"(¥14.00)"}}]
[null,"バス/シャワー","シャワーヘッド、標準",1,{"v":50,"d":"¥50.00"},{"v":62,"d":"¥62.00"},{"$f":"IFERROR(コスト[[#This Row],[見積り]]-コスト[[#This Row],[実際]], \"\")","v":{"v":-12,"d":"(¥12.00)"}},{"$f":"IFERROR(コスト[[#This Row],[数量]]*コスト[[#This Row],[見積り]], \"\")","v":{"v":50,"d":"¥50.00"}},{"$f":"IFERROR(コスト[[#This Row],[数量]]*コスト[[#This Row],[実際]], \"\")","v":{"v":62,"d":"¥62.00"}},{"$f":"IFERROR(コスト[[#This Row],[見積り ]]-コスト[[#This Row],[実際 ]], \"\")","v":{"v":-12,"d":"(¥12.00)"}}]
[null,"バス/シャワー","タブ周りの壁、標準",1,{"v":200,"d":"¥200.00"},{"v":205,"d":"¥205.00"},{"$f":"IFERROR(コスト[[#This Row],[見積り]]-コスト[[#This Row],[実際]], \"\")","v":{"v":-5,"d":"(¥5.00)"}},{"$f":"IFERROR(コスト[[#This Row],[数量]]*コスト[[#This Row],[見積り]], \"\")","v":{"v":200,"d":"¥200.00"}},{"$f":"IFERROR(コスト[[#This Row],[数量]]*コスト[[#This Row],[実際]], \"\")","v":{"v":205,"d":"¥205.00"}},{"$f":"IFERROR(コスト[[#This Row],[見積り ]]-コスト[[#This Row],[実際 ]], \"\")","v":{"v":-5,"d":"(¥5.00)"}}]
[null,"キャビネット","薬棚、60 cm、デラックス",1,{"v":200,"d":"¥200.00"},{"v":214,"d":"¥214.00"},{"$f":"IFERROR(コスト[[#This Row],[見積り]]-コスト[[#This Row],[実際]], \"\")","v":{"v":-14,"d":"(¥14.00)"}},{"$f":"IFERROR(コスト[[#This Row],[数量]]*コスト[[#This Row],[見積り]], \"\")","v":{"v":200,"d":"¥200.00"}},{"$f":"IFERROR(コスト[[#This Row],[数量]]*コスト[[#This Row],[実際]], \"\")","v":{"v":214,"d":"¥214.00"}},{"$f":"IFERROR(コスト[[#This Row],[見積り ]]-コスト[[#This Row],[実際 ]], \"\")","v":{"v":-14,"d":"(¥14.00)"}}]
[null,"キャビネット","モジュール式化粧台、70 cm、標準",2,{"v":100,"d":"¥100.00"},{"v":111,"d":"¥111.00"},{"$f":"IFERROR(コスト[[#This Row],[見積り]]-コスト[[#This Row],[実際]], \"\")","v":{"v":-11,"d":"(¥11.00)"}},{"$f":"IFERROR(コスト[[#This Row],[数量]]*コスト[[#This Row],[見積り]], \"\")","v":{"v":200,"d":"¥200.00"}},{"$f":"IFERROR(コスト[[#This Row],[数量]]*コスト[[#This Row],[実際]], \"\")","v":{"v":222,"d":"¥222.00"}},{"$f":"IFERROR(コスト[[#This Row],[見積り ]]-コスト[[#This Row],[実際 ]], \"\")","v":{"v":-22,"d":"(¥22.00)"}}]
[null,"カウンター","セラミック タイル、デラックス (直線メートル単位数量)",5,{"v":22.5,"d":"¥22.50"},{"v":25,"d":"¥25.00"},{"$f":"IFERROR(コスト[[#This Row],[見積り]]-コスト[[#This Row],[実際]], \"\")","v":{"v":-2.5,"d":"(¥2.50)"}},{"$f":"IFERROR(コスト[[#This Row],[数量]]*コスト[[#This Row],[見積り]], \"\")","v":{"v":112.5,"d":"¥112.50"}},{"$f":"IFERROR(コスト[[#This Row],[数量]]*コスト[[#This Row],[実際]], \"\")","v":{"v":125,"d":"¥125.00"}},{"$f":"IFERROR(コスト[[#This Row],[見積り ]]-コスト[[#This Row],[実際 ]], \"\")","v":{"v":-12.5,"d":"(¥12.50)"}}]
[null,"蛇口","蛇口、浴槽、標準",1,{"v":90,"d":"¥90.00"},{"v":99,"d":"¥99.00"},{"$f":"IFERROR(コスト[[#This Row],[見積り]]-コスト[[#This Row],[実際]], \"\")","v":{"v":-9,"d":"(¥9.00)"}},{"$f":"IFERROR(コスト[[#This Row],[数量]]*コスト[[#This Row],[見積り]], \"\")","v":{"v":90,"d":"¥90.00"}},{"$f":"IFERROR(コスト[[#This Row],[数量]]*コスト[[#This Row],[実際]], \"\")","v":{"v":99,"d":"¥99.00"}},{"$f":"IFERROR(コスト[[#This Row],[見積り ]]-コスト[[#This Row],[実際 ]], \"\")","v":{"v":-9,"d":"(¥9.00)"}}]
[null,"蛇口","蛇口、シャワー、1 ハンドル、標準",1,{"v":115,"d":"¥115.00"},{"v":122,"d":"¥122.00"},{"$f":"IFERROR(コスト[[#This Row],[見積り]]-コスト[[#This Row],[実際]], \"\")","v":{"v":-7,"d":"(¥7.00)"}},{"$f":"IFERROR(コスト[[#This Row],[数量]]*コスト[[#This Row],[見積り]], \"\")","v":{"v":115,"d":"¥115.00"}},{"$f":"IFERROR(コスト[[#This Row],[数量]]*コスト[[#This Row],[実際]], \"\")","v":{"v":122,"d":"¥122.00"}},{"$f":"IFERROR(コスト[[#This Row],[見積り ]]-コスト[[#This Row],[実際 ]], \"\")","v":{"v":-7,"d":"(¥7.00)"}}]
[null,"蛇口","洗面台蛇口、標準",1,{"v":95,"d":"¥95.00"},{"v":104,"d":"¥104.00"},{"$f":"IFERROR(コスト[[#This Row],[見積り]]-コスト[[#This Row],[実際]], \"\")","v":{"v":-9,"d":"(¥9.00)"}},{"$f":"IFERROR(コスト[[#This Row],[数量]]*コスト[[#This Row],[見積り]], \"\")","v":{"v":95,"d":"¥95.00"}},{"$f":"IFERROR(コスト[[#This Row],[数量]]*コスト[[#This Row],[実際]], \"\")","v":{"v":104,"d":"¥104.00"}},{"$f":"IFERROR(コスト[[#This Row],[見積り ]]-コスト[[#This Row],[実際 ]], \"\")","v":{"v":-9,"d":"(¥9.00)"}}]
[null,"床材","セラミック タイル、標準 (平方メートル単位数量)",35,{"v":12,"d":"¥12.00"},{"v":18,"d":"¥18.00"},{"$f":"IFERROR(コスト[[#This Row],[見積り]]-コスト[[#This Row],[実際]], \"\")","v":{"v":-6,"d":"(¥6.00)"}},{"$f":"IFERROR(コスト[[#This Row],[数量]]*コスト[[#This Row],[見積り]], \"\")","v":{"v":420,"d":"¥420.00"}},{"$f":"IFERROR(コスト[[#This Row],[数量]]*コスト[[#This Row],[実際]], \"\")","v":{"v":630,"d":"¥630.00"}},{"$f":"IFERROR(コスト[[#This Row],[見積り ]]-コスト[[#This Row],[実際 ]], \"\")","v":{"v":-210,"d":"(¥210.00)"}}]
[null,"ハードウェア","タオル掛け、標準",2,{"v":15,"d":"¥15.00"},{"v":24,"d":"¥24.00"},{"$f":"IFERROR(コスト[[#This Row],[見積り]]-コスト[[#This Row],[実際]], \"\")","v":{"v":-9,"d":"(¥9.00)"}},{"$f":"IFERROR(コスト[[#This Row],[数量]]*コスト[[#This Row],[見積り]], \"\")","v":{"v":30,"d":"¥30.00"}},{"$f":"IFERROR(コスト[[#This Row],[数量]]*コスト[[#This Row],[実際]], \"\")","v":{"v":48,"d":"¥48.00"}},{"$f":"IFERROR(コスト[[#This Row],[見積り ]]-コスト[[#This Row],[実際 ]], \"\")","v":{"v":-18,"d":"(¥18.00)"}}]
[null,"ハードウェア","トイレット ペーパー ホルダー",1,{"v":10,"d":"¥10.00"},{"v":17,"d":"¥17.00"},{"$f":"IFERROR(コスト[[#This Row],[見積り]]-コスト[[#This Row],[実際]], \"\")","v":{"v":-7,"d":"(¥7.00)"}},{"$f":"IFERROR(コスト[[#This Row],[数量]]*コスト[[#This Row],[見積り]], \"\")","v":{"v":10,"d":"¥10.00"}},{"$f":"IFERROR(コスト[[#This Row],[数量]]*コスト[[#This Row],[実際]], \"\")","v":{"v":17,"d":"¥17.00"}},{"$f":"IFERROR(コスト[[#This Row],[見積り ]]-コスト[[#This Row],[実際 ]], \"\")","v":{"v":-7,"d":"(¥7.00)"}}]
[null,"照明","埋め込み式ライト、標準",4,{"v":25,"d":"¥25.00"},{"v":28,"d":"¥28.00"},{"$f":"IFERROR(コスト[[#This Row],[見積り]]-コスト[[#This Row],[実際]], \"\")","v":{"v":-3,"d":"(¥3.00)"}},{"$f":"IFERROR(コスト[[#This Row],[数量]]*コスト[[#This Row],[見積り]], \"\")","v":{"v":100,"d":"¥100.00"}},{"$f":"IFERROR(コスト[[#This Row],[数量]]*コスト[[#This Row],[実際]], \"\")","v":{"v":112,"d":"¥112.00"}},{"$f":"IFERROR(コスト[[#This Row],[見積り ]]-コスト[[#This Row],[実際 ]], \"\")","v":{"v":-12,"d":"(¥12.00)"}}]
[null,"洗面台","便器、標準",2,{"v":60,"d":"¥60.00"},{"v":80,"d":"¥80.00"},{"$f":"IFERROR(コスト[[#This Row],[見積り]]-コスト[[#This Row],[実際]], \"\")","v":{"v":-20,"d":"(¥20.00)"}},{"$f":"IFERROR(コスト[[#This Row],[数量]]*コスト[[#This Row],[見積り]], \"\")","v":{"v":120,"d":"¥120.00"}},{"$f":"IFERROR(コスト[[#This Row],[数量]]*コスト[[#This Row],[実際]], \"\")","v":{"v":160,"d":"¥160.00"}},{"$f":"IFERROR(コスト[[#This Row],[見積り ]]-コスト[[#This Row],[実際 ]], \"\")","v":{"v":-40,"d":"(¥40.00)"}}]
[null,"その他",null,1,{"v":20,"d":"¥20.00"},{"v":22,"d":"¥22.00"},{"$f":"IFERROR(コスト[[#This Row],[見積り]]-コスト[[#This Row],[実際]], \"\")","v":{"v":-2,"d":"(¥2.00)"}},{"$f":"IFERROR(コスト[[#This Row],[数量]]*コスト[[#This Row],[見積り]], \"\")","v":{"v":20,"d":"¥20.00"}},{"$f":"IFERROR(コスト[[#This Row],[数量]]*コスト[[#This Row],[実際]], \"\")","v":{"v":22,"d":"¥22.00"}},{"$f":"IFERROR(コスト[[#This Row],[見積り ]]-コスト[[#This Row],[実際 ]], \"\")","v":{"v":-2,"d":"(¥2.00)"}}]
[null,"小計",null,null,{"$f":"SUBTOTAL(109,コスト[見積り])","v":{"v":1464.5,"d":"¥1,464.50"}},{"$f":"SUBTOTAL(109,コスト[実際])","v":{"v":1612,"d":"¥1,612.00"}},{"$f":"SUBTOTAL(109,コスト[差額])","v":{"v":-147.5,"d":"(¥147.50)"}},{"$f":"SUBTOTAL(109,コスト[[見積り ]])","v":{"v":2212.5,"d":"¥2,212.50"}},{"$f":"SUBTOTAL(109,コスト[[実際 ]])","v":{"v":2623,"d":"¥2,623.00"}},{"$f":"SUBTOTAL(109,コスト[[差額 ]])","v":{"v":-410.5,"d":"(¥410.50)"}}]
[]
[null,"予定外コスト (見積もりの 30% を追加)",null,null,{"$f":"IFERROR(コスト[[#Totals],[見積り]]*0.3, \"\")","v":{"v":439.34999999999997,"d":"¥439.35"}},null,null,{"$f":"IFERROR(コスト[[#Totals],[見積り ]]*0.3, \"\")","v":{"v":663.75,"d":"¥663.75"}}]
[null,"総コスト",null,null,{"$f":"IFERROR(SUM(E21:E21), \"\")","v":{"v":1464.5,"d":"¥1,464.50"}},null,null,{"$f":"IFERROR(SUM(コスト[[#Totals],[見積り ]],Overage), \"\")","v":{"v":2876.25,"d":"¥2,876.25"}}]