{"text_format":"1","workbook":"xlsx","n_sheets":1,"sheets":["計算式"],"not_rendered":{"charts":0,"images":1,"macros":1,"external_links":0,"defined_names":0,"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":15,"n_cols":31,"rows_kept":15,"cut":false,"hidden":false,"merged":[[11,30,11,32]]}
[null,null,null,null,null,null,null,null,null,null,null,"品目ごと按分"]
[null,"1　防犯カメラの設置",null,null,null,null,null,"申請者\n合計\n支払額","東京都補助金対象額","東京都\n最終\n補助金額",null,"1　防犯カメラの設置",null,null,null,null,null,"足立区\n補助金対象額","1　防犯カメラの設置","交付額"]
[null,null,null,null,null,null,null,{"$f":"B3+C3+D3+B6+C6+D6+E6+F6+B9+C9+D9+E9+F9","v":0},{"$f":"H3/2","v":0},{"$f":"IF(I3>10000,10000,ROUNDDOWN(I3,-3))","v":0},null,{"$f":"MIN(10000, IFERROR(ROUND(B3 * ROUND($J3/$H3, 4), 0), 0))","v":0},null,null,null,null,null,{"$f":"H3-J3","v":0},{"$f":"B3-L3","v":0},{"$f":"MIN(40000,ROUNDDOWN(S3*2/3,-2))","v":0}]
[]
[null,"2　防犯ガラスの\n取付け又は交換","　　　 3　防犯性能の高い\n　　　　玄関錠の取付け又は交換","4　防犯フィルムの取付け\n　　又は交換（ＣＰマークあり）","5　面格子の取付け又は交換","6　センサーライトの設置",null,null,null,null,null,"2　防犯ガラスの\n取付け又は交換","　　　 3　防犯性能の高い\n　　　　玄関錠の取付け又は交換","4　防犯フィルムの取付け\n　　又は交換（ＣＰマークあり）","5　面格子の取付け又は交換","6　センサーライトの設置",null,null,"2　防犯ガラスの\n取付け又は交換","交付額","　　　 3　防犯性能の高い\n　　　　玄関錠の取付け又は交換","交付額","4　防犯フィルムの取付け\n　　又は交換（ＣＰマークあり）","交付額","5　面格子の取付け又は交換","交付額","6　センサーライトの設置","交付額"]
[null,null,null,null,null,null,null,null,null,null,null,{"$f":"MIN(10000, IFERROR(ROUND(B6 * ROUND($J3/$H3, 4), 0), 0))","v":0},{"$f":"MIN(10000, IFERROR(ROUND(C6 * ROUND($J3/$H3, 4), 0), 0))","v":0},{"$f":"MIN(10000, IFERROR(ROUND(D6 * ROUND($J3/$H3, 4), 0), 0))","v":0},{"$f":"MIN(10000, IFERROR(ROUND(E6 * ROUND($J3/$H3, 4), 0), 0))","v":0},{"$f":"MIN(10000, IFERROR(ROUND(F6 * ROUND($J3/$H3, 4), 0), 0))","v":0},null,null,{"$f":"B6-L6","v":0},{"$f":"MIN(120000,ROUNDDOWN(S6*2/3,-2))","v":0},{"$f":"C6-M6","v":0},{"$f":"MIN(33300,ROUNDDOWN(U6*2/3,-2))","v":0},{"$f":"D6-N6","v":0},{"$f":"MIN(40000,ROUNDDOWN(W6*2/3,-2))","v":0},{"$f":"E6-O6","v":0},{"$f":"MIN(20000,ROUNDDOWN(Y6*2/3,-2))","v":0},{"$f":"F6-P6","v":0},{"$f":"MIN(6600,ROUNDDOWN(AA6*2/3,-2))","v":0}]
[]
[null,"7　防犯砂利","8　録画（動画）機能付き\nインターホンの取付け又は交換（65歳以上）","9　録画（静止画・準動画）機能付き\nインターホンの取付けまたは交換（65歳以上）","10　録画（動画）機能付き\n　　インターホンの取付け又は交換","11　録画（静止画・準動画）機能付き\nインターホンの取付けまたは交換",null,null,null,null,null,"7　防犯砂利","8　録画（動画）機能付き\nインターホンの取付け又は交換（65歳以上）","9　録画（静止画・準動画）機能付き\nインターホンの取付けまたは交換（65歳以上）","10　録画（動画）機能付き\n　　インターホンの取付け又は交換","11　録画（静止画・準動画）機能付き\nインターホンの取付けまたは交換",null,null,"7　防犯砂利","交付額","8　録画（動画）機能付き\nインターホンの取付け又は交換（65歳以上）","交付額","9　録画（静止画・準動画）機能付き\nインターホンの取付けまたは交換（65歳以上）","交付額","10　録画（動画）機能付き\n　　インターホンの取付け又は交換","交付額","11　録画（静止画・準動画）機能付き\nインターホンの取付けまたは交換","交付額"]
[null,null,null,null,null,null,null,null,null,null,null,{"$f":"MIN(10000, IFERROR(ROUND(B9 * ROUND($J3/$H3, 4), 0), 0))","v":0},{"$f":"MIN(10000, IFERROR(ROUND(C9 * ROUND($J3/$H3, 4), 0), 0))","v":0},{"$f":"MIN(10000, IFERROR(ROUND(D9 * ROUND($J3/$H3, 4), 0), 0))","v":0},{"$f":"MIN(10000, IFERROR(ROUND(E9 * ROUND($J3/$H3, 4), 0), 0))","v":0},{"$f":"MIN(10000, IFERROR(ROUND(F9 * ROUND($J3/$H3, 4), 0), 0))","v":0},null,null,{"$f":"B9-L9","v":0},{"$f":"MIN(13300,ROUNDDOWN(S9*2/3,-2))","v":0},{"$f":"C9-M9","v":0},{"$f":"MIN(75000,ROUNDDOWN(U9*3/4,-2))","v":0},{"$f":"D9-N9","v":0},{"$f":"MIN(30000,ROUNDDOWN(W9*3/4,-2))","v":0},{"$f":"E9-O9","v":0},{"$f":"MIN(60000,ROUNDDOWN(Y9*2/3,-2))","v":0},{"$f":"F9-P9","v":0},{"$f":"MIN(25000,ROUNDDOWN(AA9*2/3,-2))","v":0}]
[]
[null,"12　ナンバー・ディスプレイ\n対応電話機",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"補助金交付申請額"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"T3+V3+X3+T6+V6+X6+Z6+AB6+T9+V9+X9+Z9+AB9+T12+V12+X12+Z12+AB12+J3+T15","v":0}]
[]
[null,null,null,null,null,null,null,null,null,null,null,"15　ナンバー・ディスプレイ対応電話機",null,null,null,null,null,null,"19　ナンバー・ディスプレイ対応電話機","交付額"]
[null,null,null,null,null,null,null,null,null,null,null,{"$f":"B12","v":0},null,null,null,null,null,null,{"$f":"L15","v":0},{"$f":"MIN(7500,ROUNDDOWN(S15*3/4,-2))","v":0},null,null,null,null,null,null,null,{"$f":"T3+V3+X3+T6+V6+X6+Z6+AB6+T9+V9+X9+Z9+AB9+T12+V12+X12+Z12+AB12+T15","v":0}]