{"text_format":"1","workbook":"xlsx","n_sheets":3,"sheets":["【このシートに入力】利子助成計算表","【記入方法】利子助成計算表","保証料所補助について"],"not_rendered":{"charts":0,"images":0,"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":24,"n_cols":7,"rows_kept":24,"cut":false,"hidden":false,"merged":[]}
["利子助成額等計算表"]
["金融機関名"]
["支店名",null,null,"【市利子助成率の考え方】"]
["事業者名",null,null,"事業者負担率が下限0％以上となるよう、0.5％以内で市の利子助成率を調整する"]
["基準金利or金融機関所定金利"]
["県利子補給率",null,"0.67以内"]
["市利子助成率",{"$f":"IF((B5-B6)>=0.5,0.5,B5-B6)","v":0},"0.5以内","保証料額"]
["事業者負担率",{"$f":"IF((B5-B6-B7)<0,0,(B5-B6-B7))","v":0},null,"市利子助成率"]
[]
[]
["返済月","約定利息","戻し利息","利子助成額",null,null,"保証料助成額"]
["10月",null,null,{"$f":"TRUNC((B12-C12)*($B$7/($B$5-$B$6)),0)","v":{"$error":"#DIV/0!"}}]
["11月",null,null,{"$f":"TRUNC((B13-C13)*($B$7/($B$5-$B$6)),0)","v":{"$error":"#DIV/0!"}}]
["12月",null,null,{"$error":"#DIV/0!"}]
["1月",null,null,{"$error":"#DIV/0!"}]
["2月",null,null,{"$error":"#DIV/0!"}]
["3月",null,null,{"$error":"#DIV/0!"}]
["4月",null,null,{"$error":"#DIV/0!"}]
["5月",null,null,{"$error":"#DIV/0!"}]
["6月",null,null,{"$error":"#DIV/0!"}]
["7月",null,null,{"$error":"#DIV/0!"}]
["8月",null,null,{"$error":"#DIV/0!"}]
["9月",null,null,{"$error":"#DIV/0!"}]
["合計",{"$f":"SUM(B12:B23)","v":0},{"$f":"SUM(C12:C23)","v":0},{"$f":"SUM(D12:D23)","v":{"$error":"#DIV/0!"}},null,null,{"$f":"TRUNC(E7*E8,0)","v":0}]

{"sheet":"【記入方法】利子助成計算表","index":1,"n_rows":24,"n_cols":7,"rows_kept":24,"cut":false,"hidden":false,"merged":[[1,3,5,6]]}
["利子助成額等計算表"]
["金融機関名",null,null,"入力方法\n・黄色セルの値を入力し、それ以外のセルへは入力しない。\n・数値を入力する際は半角で入力。\n・保証料の市利子助成率については、基本的に25％を選択し、別シート\n「保証料補助について」にて条件を満たす事業者のみ75%を選択してください。"]
["支店名"]
["事業者名"]
["基準金利or金融機関所定金利"]
["県利子補給率",null,"0.67以内"]
["市利子助成率",{"$f":"IF((B5-B6)>=0.5,0.5,B5-B6)","v":0},"0.5以内","保証料額"]
["事業者負担率",{"$f":"IF((B5-B6-B7)<0,0,(B5-B6-B7))","v":0},null,"市利子助成率"]
[]
[]
["返済月","約定利息","戻し利息","利子助成額",null,null,"保証料助成額"]
["10月",null,null,{"$f":"TRUNC((B12-C12)*($B$7/($B$5-$B$6)),0)","v":{"$error":"#DIV/0!"}}]
["11月",null,null,{"$f":"TRUNC((B13-C13)*($B$7/($B$5-$B$6)),0)","v":{"$error":"#DIV/0!"}}]
["12月",null,null,{"$error":"#DIV/0!"}]
["1月",null,null,{"$error":"#DIV/0!"}]
["2月",null,null,{"$error":"#DIV/0!"}]
["3月",null,null,{"$error":"#DIV/0!"}]
["4月",null,null,{"$error":"#DIV/0!"}]
["5月",null,null,{"$error":"#DIV/0!"}]
["6月",null,null,{"$error":"#DIV/0!"}]
["7月",null,null,{"$error":"#DIV/0!"}]
["8月",null,null,{"$error":"#DIV/0!"}]
["9月",null,null,{"$error":"#DIV/0!"}]
["合計",{"$f":"SUM(B12:B23)","v":0},{"$f":"SUM(C12:C23)","v":0},{"$f":"SUM(D12:D23)","v":{"$error":"#DIV/0!"}},null,null,{"$f":"TRUNC(E7*E8,0)","v":0}]

{"sheet":"保証料所補助について","index":2,"n_rows":13,"n_cols":3,"rows_kept":13,"cut":false,"hidden":false,"merged":[[1,0,1,1],[3,2,12,2],[0,0,0,2],[4,1,6,1],[7,1,9,1],[11,1,12,1],[10,0,10,1],[3,0,3,1],[2,0,2,1]]}
["保証料補助について"]
["対象者",null,"保証料補助率"]
["①利用者全員（※下記の対象者を除く）",null,"保証料の25%"]
["②被表彰者等",null,"保証料の75%"]
["　●静岡市CSRパートナー企業表彰の被表彰者","受賞後\n10年未満"]
["　●静岡市多様な人材の活躍応援事業所表彰の被表彰者（旧静岡市女性の活躍応援事業所表彰）"]
["　●静岡市中小企業技術表彰の被表彰者"]
["　●静岡市創業支援等事業計画に記載された特定創業支援等事業の修了者（※支援証明書発行対象者）","創業後\n５年未満"]
["　●しずおかビジネスプランコンテスト一般部門の被表彰者"]
["　●次に掲げるインキュベーション施設の入居者及び卒業者\n　・静岡市産学交流センター及び静岡市清水産業・情報プラザの創業者育成室\n　・静岡市クリエーター支援センターのクリエーター育成室"]
["③各種計画の承認企業"]
["　●先端設備等導入計画認定企業","各計画の\n認定期間"]
["　●地域経済牽引事業計画認定企業"]