{"text_format":"3","workbook":"xlsx","n_sheets":1,"sheets":["予算計画シート"],"not_rendered":{"charts":1,"defined_names":1},"read":"whole","date_system":"1900"}

{"sheet":"予算計画シート","index":0,"n_rows":21,"n_cols":6,"rows_kept":21}
[null,"休暇の予算計画シート"]
[]
[null,"カテゴリ別の予算"]
[null,"カテゴリ","予定予算","予算の詳細","使用可能 / (超過)"]
[null,"交通",{"v":750,"d":"¥750"},{"$f":"SUMIF(表2[カテゴリ],表1[[#This Row],[カテゴリ]],表2[金額])","v":{"v":720,"d":"¥720"}},{"$f":"IFERROR(表1[[#This Row],[予定予算]]-表1[[#This Row],[予算の詳細]],\"\")","v":{"v":30,"d":"¥30"}}]
[null,"宿泊",{"v":250,"d":"¥250"},{"$f":"SUMIF(表2[カテゴリ],表1[[#This Row],[カテゴリ]],表2[金額])","v":{"v":300,"d":"¥300"}},{"$f":"IFERROR(表1[[#This Row],[予定予算]]-表1[[#This Row],[予算の詳細]],\"\")","v":{"v":-50,"d":"(¥50)"}}]
[null,"食事",{"v":100,"d":"¥100"},{"$f":"SUMIF(表2[カテゴリ],表1[[#This Row],[カテゴリ]],表2[金額])","v":{"v":80,"d":"¥80"}},{"$f":"IFERROR(表1[[#This Row],[予定予算]]-表1[[#This Row],[予算の詳細]],\"\")","v":{"v":20,"d":"¥20"}}]
[null,"アクティビティ",{"v":500,"d":"¥500"},{"$f":"SUMIF(表2[カテゴリ],表1[[#This Row],[カテゴリ]],表2[金額])","v":{"v":500,"d":"¥500"}},{"$f":"IFERROR(表1[[#This Row],[予定予算]]-表1[[#This Row],[予算の詳細]],\"\")","v":{"v":0,"d":"¥0"}}]
[null,"お土産",{"v":50,"d":"¥50"},{"$f":"SUMIF(表2[カテゴリ],表1[[#This Row],[カテゴリ]],表2[金額])","v":{"v":0,"d":"¥0"}},{"$f":"IFERROR(表1[[#This Row],[予定予算]]-表1[[#This Row],[予算の詳細]],\"\")","v":{"v":50,"d":"¥50"}}]
[null,"その他",{"v":50,"d":"¥50"},{"$f":"SUMIF(表2[カテゴリ],表1[[#This Row],[カテゴリ]],表2[金額])","v":{"v":0,"d":"¥0"}},{"$f":"IFERROR(表1[[#This Row],[予定予算]]-表1[[#This Row],[予算の詳細]],\"\")","v":{"v":50,"d":"¥50"}}]
[null,"臨時費",{"v":200,"d":"¥200"},{"$f":"SUMIF(表2[カテゴリ],表1[[#This Row],[カテゴリ]],表2[金額])","v":{"v":0,"d":"¥0"}},{"$f":"IFERROR(表1[[#This Row],[予定予算]]-表1[[#This Row],[予算の詳細]],\"\")","v":{"v":200,"d":"¥200"}}]
[null,"予算合計",{"$f":"SUBTOTAL(109,表1[予定予算])","v":{"v":1900,"d":"¥1,900"}},{"$f":"SUBTOTAL(109,表1[予算の詳細])","v":{"v":1600,"d":"¥1,600"}},{"$f":"SUBTOTAL(109,表1[使用可能 / (超過)])","v":{"v":300,"d":"¥300"}}]
[]
[null,"経費詳細"]
[null,"説明","カテゴリ","数量","単価","金額"]
[null,"航空運賃","交通",2,{"v":300,"d":"¥300"},{"$f":"IFERROR(表2[[#This Row],[数量]]*表2[[#This Row],[単価]],\"\")","v":{"v":600,"d":"¥600"}}]
[null,"バスとタクシー、2 日間","交通",4,{"v":30,"d":"¥30"},{"$f":"IFERROR(表2[[#This Row],[数量]]*表2[[#This Row],[単価]],\"\")","v":{"v":120,"d":"¥120"}}]
[null,"ホテル、2 泊","宿泊",2,{"v":150,"d":"¥150"},{"$f":"IFERROR(表2[[#This Row],[数量]]*表2[[#This Row],[単価]],\"\")","v":{"v":300,"d":"¥300"}}]
[null,"食事、2 日間","食事",2,{"v":40,"d":"¥40"},{"$f":"IFERROR(表2[[#This Row],[数量]]*表2[[#This Row],[単価]],\"\")","v":{"v":80,"d":"¥80"}}]
[null,"1 日目、コンサートのチケット","アクティビティ",2,{"v":250,"d":"¥250"},{"$f":"IFERROR(表2[[#This Row],[数量]]*表2[[#This Row],[単価]],\"\")","v":{"v":500,"d":"¥500"}}]
[null,"その他の費用項目を入力",{"$nulls":3},{"$f":"IFERROR(表2[[#This Row],[数量]]*表2[[#This Row],[単価]],\"\")","v":{"v":0,"d":"¥0"}}]