{"text_format":"1","workbook":"xlsx","n_sheets":4,"sheets":["入力欄","【非表示】入力欄（概要）","削除禁止【非表示】DATA","削除禁止【非表示】給付額計算式"],"not_rendered":{"charts":0,"images":0,"macros":1,"external_links":0,"defined_names":2,"comments":2,"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":22,"n_cols":13,"rows_kept":22,"cut":false,"hidden":false,"merged":[[21,0,21,14],[17,2,17,3],[8,2,8,3],[12,0,14,0],[16,0,18,0],[13,8,13,9],[12,11,12,12],[12,6,12,7],[12,2,12,3],[17,11,18,13],[1,0,1,14],[3,0,3,14],[5,6,5,7],[8,6,8,7],[5,11,5,12],[8,11,8,12]]}
[]
["船橋市住居確保給付金給付額シミュレーション（令和８年７月現在）"]
[]
["　・　黄色のセルに必要事項を選択もしくは入力してください。世帯人数１０人以下のシュミレーションが可能です。"]
[]
[null,null,"A",null,null,null,"B",null,null,null,null,"C"]
[null,"世帯人数",null,null,null,"家賃上限額",{"$f":"IFERROR(VLOOKUP(C7,DATAテーブル[],3,0),0)","v":0},"円",null,null,"金融資産基準額",{"$f":"IFERROR(VLOOKUP(C7,DATAテーブル[],4,0),0)","v":0},"円"]
[]
[null,null,"D",null,null,null,"E",null,null,null,null,"F"]
[null,"申請月収入額",null,"円",null,"実家賃額",null,"円",null,null,"金融資産額",null,"円"]
[]
[]
["自動入力",null,"G",null,null,null,"H",null,null,null,null,"I"]
[null,"BとEのうち　　少額のほう",{"$f":"IF(G10<100,ROUNDUP(G10,-2),MIN(G7,G10))","v":0},"円","＋","基準額",{"$f":"IFERROR(VLOOKUP(C7,DATAテーブル[],2,0),0)","v":0},"円","＝",null,"あなたの　　　　　　　収入基準額",{"$f":"IF(G10=\"\",0,C14+G14)","v":0},"円"]
[]
[]
["自動入力"]
[null,"判定",{"$f":"IF(L10=\"\",\"\",IF(AND(L7>=L10,L14>=C10),\"給付対象\",\"給付対象外\"))","v":""},null,null,"給付額",{"$f":"IF(C18=\"給付対象\",削除禁止【非表示】給付額計算式!D3,0)","v":0},"円"]
[]
[]
[]
["※給付額はあくまで目安です。実際の計算は、申請時に提出いただく書類にもとづいて行います。"]

{"sheet":"【非表示】入力欄（概要）","index":1,"n_rows":22,"n_cols":13,"rows_kept":22,"cut":false,"hidden":true,"merged":[[21,0,21,14],[12,0,14,0],[12,2,12,3],[12,6,12,7],[12,11,12,12],[13,8,13,9],[16,0,18,0],[17,2,17,3],[17,11,18,13],[17,10,18,10],[1,0,1,14],[3,0,3,14],[5,6,5,7],[5,11,5,12],[8,2,8,3],[8,6,8,7],[8,11,8,12]]}
[]
["船橋市住居確保給付金給付額シミュレーション（令和８年７月現在）"]
[]
["　・　黄色のセルに必要事項を選択もしくは入力してください。世帯人数１０人以下のシュミレーションが可能です。"]
[]
[null,null,"A",null,null,null,"B",null,null,null,null,"C"]
[null,"世帯人数",null,null,null,"家賃上限額",{"$f":"IFERROR(VLOOKUP(C7,DATAテーブル[],3,0),0)","v":0},"円",null,null,"金融資産基準額",{"$f":"IFERROR(VLOOKUP(C7,DATAテーブル[],4,0),0)","v":0},"円"]
[]
[null,null,"D",null,null,null,"E",null,null,null,null,"F"]
[null,"申請月収入額",null,"円",null,"実家賃額",null,"円",null,null,"金融資産額",null,"円"]
[]
[]
["自動入力",null,"G",null,null,null,"H",null,null,null,null,"I"]
[null,"BとEのうち　　少額のほう",{"$f":"IF(G10<100,ROUNDUP(G10,-2),MIN(G7,G10))","v":0},"円","＋","基準額",{"$f":"IFERROR(VLOOKUP(C7,DATAテーブル[],2,0),0)","v":0},"円","＝",null,"あなたの　　　　　　　収入基準額",{"$f":"IF(G10=\"\",0,C14+G14)","v":0},"円"]
[]
[]
["自動入力"]
[null,"判定",{"$f":"IF(L10=\"\",\"\",IF(AND(L7>=L10,L14>=C10),\"給付対象\",\"給付対象外\"))","v":""},null,null,"給付額",{"$f":"IF(C18=\"給付対象\",削除禁止【非表示】給付額計算式!D3,0)","v":0},"円",null,null,"入力内容をクリアについて→"]
[]
[]
[]
["※給付額はあくまで目安です。実際の計算は、申請時に提出いただく書類にもとづいて行います。"]

{"sheet":"削除禁止【非表示】DATA","index":2,"n_rows":12,"n_cols":7,"rows_kept":12,"cut":false,"hidden":true,"merged":[]}
[null,"列1",null,"列1","列2","列3","列4"]
[null,"単身",null,"世帯人数","基準額","家賃上限額","金融資産基準額"]
[null,"2人",null,"単身",92000,43000,552000]
[null,"3人",null,"2人",139000,52000,834000]
[null,"4人",null,"3人",172000,56000,1000000]
[null,"5人",null,"4人",214000,56000,1000000]
[null,"6人",null,"5人",255000,56000,1000000]
[null,"7人",null,"6人",297000,60000,1000000]
[null,"8人",null,"7人",334000,67000,1000000]
[null,"9人",null,"8人",370000,67000,1000000]
[null,"10人",null,"9人",407000,67000,1000000]
[null,null,null,"10人",443000,67000,1000000]

{"sheet":"削除禁止【非表示】給付額計算式","index":3,"n_rows":13,"n_cols":6,"rows_kept":13,"cut":false,"hidden":true,"merged":[[9,1,9,3],[11,1,11,3],[12,1,12,5]]}
[]
[null,"世帯収入額－基準額","支給額（端数あり）","支給額"]
[null,{"$f":"IF(入力欄!C10<=入力欄!G14,0,入力欄!C10-入力欄!G14)","v":0},{"$f":"IF(B3<>0,入力欄!G14+入力欄!G10-入力欄!C10,入力欄!C14)","v":0},{"$f":"MIN(ABS(ROUNDUP(C3,-2)),入力欄!G7)","v":0},null,{"$f":"入力欄!C18","v":""}]
[]
[]
[]
[null,"参考：支給額の算定"]
[]
[null,"①世帯収入額が基準額以下の場合"]
[null,"申請者が賃借する住宅の1か月あたりの家賃額"]
[]
[null,"②世帯収入額が基準額を超えている場合"]
[null,"基準額 + 申請者が賃借する住宅の1か月あたりの家賃額 - 世帯収入額"]