{"text_format":"1","workbook":"xlsx","n_sheets":1,"sheets":["予算計画シート"],"not_rendered":{"charts":1,"images":0,"macros":0,"external_links":0,"defined_names":1,"comments":0,"pivot_tables":0},"unopened":[],"bounds":{"document_bytes":16777216,"sheet_cells":100000,"rows_first":2000,"rows_last":500,"rows_between":2000,"halvings":0,"cell_chars":16384,"cell_head_chars":4096},"cells_cut":0,"cells_raw":0,"read":"whole","date_system":"1900"}

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