{"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":[]}
[null,null,null,null,null,null,null,null,null,null,null,"品目ごと按分"]
[null,"1　防犯カメラの設置","2　インターホン\n　　連携型防犯カメラ","3　ダミーカメラ",null,null,null,"申請者\n合計\n支払額","東京都補助金対象額","東京都\n最終\n補助金額",null,"1　防犯カメラの設置","2　インターホン\n連携型防犯カメラ","3　ダミーカメラ",null,null,null,"足立区\n補助金対象額","1　防犯カメラの設置","交付額","2　インターホン\n連携型防犯カメラ","交付額","3　ダミーカメラ","交付額"]
[null,null,null,null,null,null,null,{"$f":"B3+C3+D3+B6+C6+D6+E6+F6+B9+C9+D9+E9+F9+F12+E12+D12+C12+B12","v":0},{"$f":"H3/2","v":0},{"$f":"IF(I3>20000,20000,ROUNDDOWN(I3,-3))","v":0},null,{"$f":"IFERROR(ROUND(B3*($J3/$H3),0),0)","v":0},{"$f":"IFERROR(ROUND(C3*($J3/$H3),0),0)","v":0},0,null,null,null,{"$f":"H3-J3","v":0},{"$f":"B3-L3","v":0},{"$f":"MIN(40000,ROUNDDOWN(S3*2/3,-2))","v":0},{"$f":"C3-M3","v":0},{"$f":"MIN(20000,ROUNDDOWN(U3*2/3,-2))","v":0},{"$f":"D3-N3","v":0},{"$f":"MIN(1500,ROUNDDOWN(W3*2/3,-2))","v":0}]
[]
[null,"4　防犯ガラスの\n取付け又は交換","　　　 5　防犯性能の高い\n　　　　玄関錠の取付け又は交換","6　防犯フィルムの取付け\n　　又は交換（ＣＰマークあり）","7　防犯フィルムの取付け\n　　又は交換（ＣＰマークなし）","8　面格子の取付け又は交換",null,null,null,null,null,"4　防犯ガラスの\n取付け又は交換","5　防犯性能の高い玄関錠\nの取付け又は交換","6　防犯フィルムの取付け\n又は交換（ＣＰマークあり）","7　防犯フィルムの取付け\n又は交換（ＣＰマークなし）","8　面格子の取付け又は交換",null,null,"4　防犯ガラスの\n取付け又は交換","交付額","5　防犯性能の高い玄関錠\nの取付け又は交換","交付額","6　防犯フィルムの取付け\n又は交換（ＣＰマークあり）","交付額","7　防犯フィルムの取付け\n又は交換（ＣＰマークなし）","交付額","8　面格子の取付け又は交換","交付額"]
[null,null,null,null,null,null,null,null,null,null,null,{"$f":"IFERROR(ROUND(B6*($J3/$H3),0),0)","v":0},{"$f":"IFERROR(ROUND(C6*($J3/$H3),0),0)","v":0},0,0,0,null,null,{"$f":"B6-L6","v":0},{"$f":"MIN(66600,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(20000,ROUNDDOWN(W6*2/3,-2))","v":0},{"$f":"E6-O6","v":0},{"$f":"MIN(2000,ROUNDDOWN(Y6*2/3,-2))","v":0},{"$f":"F6-P6","v":0},{"$f":"MIN(20000,ROUNDDOWN(AA6*2/3,-2))","v":0}]
[]
[null,"9　センサーライトの設置","10　ガラス破壊センサーの\n取付け又は交換","11　センサー付きアラームの\n取付け又は交換","12　防犯砂利","13　玄関補助錠の取付け又は交換",null,null,null,null,null,"9　センサーライトの設置","10　ガラス破壊センサーの\n取付け又は交換","11　センサー付きアラームの\n取付け又は交換","12　防犯砂利","13　玄関補助錠の取付け又は交換",null,null,"9　センサーライトの設置","交付額","10　ガラス破壊センサーの\n取付け又は交換","交付額","11　センサー付きアラームの\n取付け又は交換","交付額","12　防犯砂利","交付額","13　玄関補助錠の取付け又は交換","交付額"]
[null,null,null,null,null,null,null,null,null,null,null,{"$f":"IFERROR(ROUND(B9*($J3/$H3),0),0)","v":0},{"$f":"IFERROR(ROUND(C9*($J3/$H3),0),0)","v":0},0,0,0,null,null,{"$f":"B9-L9","v":0},{"$f":"MIN(6600,ROUNDDOWN(S9*2/3,-2))","v":0},{"$f":"C9-M9","v":0},{"$f":"MIN(2000,ROUNDDOWN(U9*2/3,-2))","v":0},{"$f":"D9-N9","v":0},{"$f":"MIN(2000,ROUNDDOWN(W9*2/3,-2))","v":0},{"$f":"E9-O9","v":0},{"$f":"MIN(2000,ROUNDDOWN(Y9*2/3,-2))","v":0},{"$f":"F9-P9","v":0},{"$f":"MIN(1300,ROUNDDOWN(AA9*2/3,-2))","v":0}]
[]
[null,"14　窓への補助錠の\n取付け又は交換","15　録画（動画）機能付き\nインターホンの取付け又は交換（65歳以上）","16　録画（静止画・準動画）機能付き\nインターホンの取付けまたは交換（65歳以上）","17　録画（動画）機能付き\n　　インターホンの取付け又は交換","18　録画（静止画・準動画）機能付き\nインターホンの取付けまたは交換",null,null,null,null,null,"14　窓への補助錠の\n取付け又は交換","15　録画（動画）機能付き\nインターホンの取付け又は交換","16　録画（静止画・準動画）機能付き\nインターホンの取付けまたは交換","17　録画（動画）機能付き\nインターホンの取付け又は交換","18　録画（静止画・準動画）機能付き\nインターホンの取付けまたは交換",null,null,"14　窓への補助錠の\n取付け又は交換","交付額","15　録画（動画）機能付き\nインターホンの取付け又は交換","交付額","16　録画（静止画・準動画）機能付き\nインターホンの取付けまたは交換","交付額","17　録画（動画）機能付き\nインターホンの取付け又は交換","交付額","18　録画（静止画・準動画）機能付き\nインターホンの取付けまたは交換","交付額",null,null,"補助金交付申請額"]
[null,null,null,null,null,null,null,null,null,null,null,{"$f":"IFERROR(ROUND(B12*($J3/$H3),0),0)","v":0},{"$f":"IFERROR(ROUND(C12*($J3/$H3),0),0)","v":0},0,0,0,null,null,{"$f":"B12-L12","v":0},{"$f":"MIN(1300,ROUNDDOWN(S12*2/3,-2))","v":0},{"$f":"C12-M12","v":0},{"$f":"MIN(75000,ROUNDDOWN(U12*3/4,-2))","v":0},{"$f":"D12-N12","v":0},{"$f":"MIN(30000,ROUNDDOWN(W12*3/4,-2))","v":0},{"$f":"E12-O12","v":0},{"$f":"MIN(60000,ROUNDDOWN(Y12*2/3,-2))","v":0},{"$f":"F12-P12","v":0},{"$f":"MIN(25000,ROUNDDOWN(AA12*2/3,-2))","v":0},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,"19　ナンバー・ディスプレイ\n対応電話機",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":"B15","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}]