← 様式一覧へ戻る

プレビュー: 1人当たり給与支給総額の確認書.xlsx

ダウンロード

※ 概観プレビューです。実際のレイアウトはダウンロードしたファイルでご確認ください。

改訂履歴

   
Ver日付改定内容
12026-01-22新規作成
1.12026-01-28数式誤り、表記ゆれ、台帳項目の追加
1.22026-03-06第6回用に修正、表記ゆれ、書式の修正

宣誓書

             
             
    
   1人当たり給与支給総額の確認書
    第6回公募受付用 
             
        株式会社サンプル金属加工 
             
  応募申請時点における対象となる従業員及び1人当たり給与支給額について          
  記載した内容に間違いがないことを証明します。          
             
  対象となる従業員及び算定対象となる給与の考え方については以下になります。          
  詳細は公募要領・申請の手引きをご確認ください。          
  ■対象となる従業員          
   基準年度及びその算出対象となる各事業年度において、全月分の給与等の支給を受けた従業員とします。          
   中途採用や退職等で全月分の給与等の支給を受けていない従業員については、          
   全月分の給与等の支給を受けていない事業年度に限り、算出の対象から除く必要があります          
  ■算定対象となる給与          
   給料、賃金、賞与、各種手当(残業手当、休日出勤手当、職務手当、地域手当、家族(扶養)手当、住宅手当)等、          
   給与所得として課税対象となる経費を指します。福利厚生費、法定福利費や退職金は除きます。           
   当該事業年度において、産前・産後休業、育児休業、介護休業など事業者の福利厚生等により          
   時短勤務を行っている従業員は、算定対象から除くことができます。          
  ※直近決算の期間によって使用するシートが異なります。記入例をご確認の上、該当するシートにご記載ください。          
   両シートに記載していただく必要はございません。          
             
  賃金台帳における給与支給総額の算定対象となる科目          
     
     
     
     
     

直近決算 1年(12か月)

         
 ■基準年度(直近の決算期)が1年(12か月)の事業者       
 ※直近の決算期が1年(12か月)の事業者のみご使用ください。       
         
 2024-04-012025-03-31全月分の給与等の支給を受けた
従業員の給与支給総額
全月分の給与等の支給を受けた
従業員数
従業員1人当たり給与支給総額   
   {"formula":"IFERROR(SUMIFS($F$11:$F$3010,$J$11:$J$3010,FALSE,$I$11:$I$3010,TRUE),\"\")"}{"formula":"COUNTIF($I$11:$I$3010,TRUE)-COUNTIFS($J$11:$J$3010,TRUE,$I$11:$I$3010,TRUE)"}-   
         
         
NO従業員番号等対象従業員名全月分の給与支給の
対象外
福利厚生等による時短勤務給与支給額  入力チェック
  
1E001田中 一郎  4200000  {"formula":"IF(AND(C11<>\"\",F11<>\"\"),TRUE,FALSE)"}
{"formula":"IF(C12=\"\",\"\",A11+1)"}E002佐藤 花子  3900000  {"formula":"IF(AND(C12<>\"\",F12<>\"\"),TRUE,FALSE)","ref":"I12:I75","shareType":"shared"}
{"formula":"IF(C13=\"\",\"\",A12+1)","ref":"A13:A76","shareType":"shared"}E003鈴木 二郎  3200000  {"sharedFormula":"I12"}
{"sharedFormula":"A13"}E004高橋 三郎  2800000  {"sharedFormula":"I12"}
{"sharedFormula":"A13"}E005渡辺 四郎  4500000  {"sharedFormula":"I12"}
{"sharedFormula":"A13"}       {"sharedFormula":"I12"}
{"sharedFormula":"A13"}       {"sharedFormula":"I12"}
{"sharedFormula":"A13"}       {"sharedFormula":"I12"}
{"sharedFormula":"A13"}       {"sharedFormula":"I12"}
{"sharedFormula":"A13"}       {"sharedFormula":"I12"}
{"sharedFormula":"A13"}       {"sharedFormula":"I12"}
{"sharedFormula":"A13"}       {"sharedFormula":"I12"}
{"sharedFormula":"A13"}       {"sharedFormula":"I12"}
{"sharedFormula":"A13"}       {"sharedFormula":"I12"}
{"sharedFormula":"A13"}       {"sharedFormula":"I12"}
{"sharedFormula":"A13"}       {"sharedFormula":"I12"}
{"sharedFormula":"A13"}       {"sharedFormula":"I12"}
{"sharedFormula":"A13"}       {"sharedFormula":"I12"}
{"sharedFormula":"A13"}       {"sharedFormula":"I12"}
{"sharedFormula":"A13"}       {"sharedFormula":"I12"}
{"sharedFormula":"A13"}       {"sharedFormula":"I12"}
{"sharedFormula":"A13"}       {"sharedFormula":"I12"}
{"sharedFormula":"A13"}       {"sharedFormula":"I12"}
{"sharedFormula":"A13"}       {"sharedFormula":"I12"}
{"sharedFormula":"A13"}       {"sharedFormula":"I12"}
{"sharedFormula":"A13"}       {"sharedFormula":"I12"}
{"sharedFormula":"A13"}       {"sharedFormula":"I12"}
{"sharedFormula":"A13"}       {"sharedFormula":"I12"}
{"sharedFormula":"A13"}       {"sharedFormula":"I12"}
{"sharedFormula":"A13"}       {"sharedFormula":"I12"}
{"sharedFormula":"A13"}       {"sharedFormula":"I12"}
{"sharedFormula":"A13"}       {"sharedFormula":"I12"}
{"sharedFormula":"A13"}       {"sharedFormula":"I12"}
{"sharedFormula":"A13"}       {"sharedFormula":"I12"}
{"sharedFormula":"A13"}       {"sharedFormula":"I12"}
{"sharedFormula":"A13"}       {"sharedFormula":"I12"}
{"sharedFormula":"A13"}       {"sharedFormula":"I12"}
{"sharedFormula":"A13"}       {"sharedFormula":"I12"}
{"sharedFormula":"A13"}       {"sharedFormula":"I12"}
{"sharedFormula":"A13"}       {"sharedFormula":"I12"}
{"sharedFormula":"A13"}       {"sharedFormula":"I12"}
{"sharedFormula":"A13"}       {"sharedFormula":"I12"}
{"sharedFormula":"A13"}       {"sharedFormula":"I12"}
{"sharedFormula":"A13"}       {"sharedFormula":"I12"}
{"sharedFormula":"A13"}       {"sharedFormula":"I12"}
{"sharedFormula":"A13"}       {"sharedFormula":"I12"}
{"sharedFormula":"A13"}       {"sharedFormula":"I12"}
{"sharedFormula":"A13"}       {"sharedFormula":"I12"}
{"sharedFormula":"A13"}       {"sharedFormula":"I12"}
{"sharedFormula":"A13"}       {"sharedFormula":"I12"}
{"sharedFormula":"A13"}       {"sharedFormula":"I12"}
{"sharedFormula":"A13"}       {"sharedFormula":"I12"}
{"sharedFormula":"A13"}       {"sharedFormula":"I12"}
{"sharedFormula":"A13"}       {"sharedFormula":"I12"}
{"sharedFormula":"A13"}       {"sharedFormula":"I12"}
{"sharedFormula":"A13"}       {"sharedFormula":"I12"}
{"sharedFormula":"A13"}       {"sharedFormula":"I12"}
{"sharedFormula":"A13"}       {"sharedFormula":"I12"}
{"sharedFormula":"A13"}       {"sharedFormula":"I12"}
{"sharedFormula":"A13"}       {"sharedFormula":"I12"}
{"sharedFormula":"A13"}       {"sharedFormula":"I12"}
{"sharedFormula":"A13"}       {"sharedFormula":"I12"}
{"sharedFormula":"A13"}       {"sharedFormula":"I12"}
{"sharedFormula":"A13"}       {"sharedFormula":"I12"}
{"sharedFormula":"A13"}       {"sharedFormula":"I12"}
{"sharedFormula":"A13"}       {"formula":"IF(AND(C76<>\"\",F76<>\"\"),TRUE,FALSE)","ref":"I76:I139","shareType":"shared"}
{"formula":"IF(C77=\"\",\"\",A76+1)","ref":"A77:A140","shareType":"shared"}       {"sharedFormula":"I76"}
{"sharedFormula":"A77"}       {"sharedFormula":"I76"}
{"sharedFormula":"A77"}       {"sharedFormula":"I76"}
{"sharedFormula":"A77"}       {"sharedFormula":"I76"}
{"sharedFormula":"A77"}       {"sharedFormula":"I76"}
{"sharedFormula":"A77"}       {"sharedFormula":"I76"}
{"sharedFormula":"A77"}       {"sharedFormula":"I76"}
{"sharedFormula":"A77"}       {"sharedFormula":"I76"}
{"sharedFormula":"A77"}       {"sharedFormula":"I76"}
{"sharedFormula":"A77"}       {"sharedFormula":"I76"}
{"sharedFormula":"A77"}       {"sharedFormula":"I76"}
{"sharedFormula":"A77"}       {"sharedFormula":"I76"}
{"sharedFormula":"A77"}       {"sharedFormula":"I76"}
{"sharedFormula":"A77"}       {"sharedFormula":"I76"}
{"sharedFormula":"A77"}       {"sharedFormula":"I76"}
{"sharedFormula":"A77"}       {"sharedFormula":"I76"}
{"sharedFormula":"A77"}       {"sharedFormula":"I76"}
{"sharedFormula":"A77"}       {"sharedFormula":"I76"}
{"sharedFormula":"A77"}       {"sharedFormula":"I76"}
{"sharedFormula":"A77"}       {"sharedFormula":"I76"}
{"sharedFormula":"A77"}       {"sharedFormula":"I76"}
{"sharedFormula":"A77"}       {"sharedFormula":"I76"}
{"sharedFormula":"A77"}       {"sharedFormula":"I76"}
{"sharedFormula":"A77"}       {"sharedFormula":"I76"}
{"sharedFormula":"A77"}       {"sharedFormula":"I76"}
{"sharedFormula":"A77"}       {"sharedFormula":"I76"}
{"sharedFormula":"A77"}       {"sharedFormula":"I76"}
{"sharedFormula":"A77"}       {"sharedFormula":"I76"}
{"sharedFormula":"A77"}       {"sharedFormula":"I76"}
{"sharedFormula":"A77"}       {"sharedFormula":"I76"}
{"sharedFormula":"A77"}       {"sharedFormula":"I76"}
{"sharedFormula":"A77"}       {"sharedFormula":"I76"}
{"sharedFormula":"A77"}       {"sharedFormula":"I76"}
{"sharedFormula":"A77"}       {"sharedFormula":"I76"}
{"sharedFormula":"A77"}       {"sharedFormula":"I76"}
{"sharedFormula":"A77"}       {"sharedFormula":"I76"}
{"sharedFormula":"A77"}       {"sharedFormula":"I76"}
{"sharedFormula":"A77"}       {"sharedFormula":"I76"}
{"sharedFormula":"A77"}       {"sharedFormula":"I76"}
{"sharedFormula":"A77"}       {"sharedFormula":"I76"}
{"sharedFormula":"A77"}       {"sharedFormula":"I76"}
{"sharedFormula":"A77"}       {"sharedFormula":"I76"}
{"sharedFormula":"A77"}       {"sharedFormula":"I76"}
{"sharedFormula":"A77"}       {"sharedFormula":"I76"}
{"sharedFormula":"A77"}       {"sharedFormula":"I76"}
{"sharedFormula":"A77"}       {"sharedFormula":"I76"}
{"sharedFormula":"A77"}       {"sharedFormula":"I76"}
{"sharedFormula":"A77"}       {"sharedFormula":"I76"}
{"sharedFormula":"A77"}       {"sharedFormula":"I76"}
{"sharedFormula":"A77"}       {"sharedFormula":"I76"}
{"sharedFormula":"A77"}       {"sharedFormula":"I76"}
{"sharedFormula":"A77"}       {"sharedFormula":"I76"}
{"sharedFormula":"A77"}       {"sharedFormula":"I76"}
{"sharedFormula":"A77"}       {"sharedFormula":"I76"}
{"sharedFormula":"A77"}       {"sharedFormula":"I76"}
{"sharedFormula":"A77"}       {"sharedFormula":"I76"}
{"sharedFormula":"A77"}       {"sharedFormula":"I76"}
{"sharedFormula":"A77"}       {"sharedFormula":"I76"}
{"sharedFormula":"A77"}       {"sharedFormula":"I76"}
{"sharedFormula":"A77"}       {"sharedFormula":"I76"}
{"sharedFormula":"A77"}       {"sharedFormula":"I76"}
{"sharedFormula":"A77"}       {"sharedFormula":"I76"}
{"sharedFormula":"A77"}       {"sharedFormula":"I76"}
{"sharedFormula":"A77"}       {"formula":"IF(AND(C140<>\"\",F140<>\"\"),TRUE,FALSE)","ref":"I140:I203","shareType":"shared"}
{"formula":"IF(C141=\"\",\"\",A140+1)","ref":"A141:A204","shareType":"shared"}       {"sharedFormula":"I140"}
{"sharedFormula":"A141"}       {"sharedFormula":"I140"}
{"sharedFormula":"A141"}       {"sharedFormula":"I140"}
{"sharedFormula":"A141"}       {"sharedFormula":"I140"}
{"sharedFormula":"A141"}       {"sharedFormula":"I140"}
{"sharedFormula":"A141"}       {"sharedFormula":"I140"}
{"sharedFormula":"A141"}       {"sharedFormula":"I140"}
{"sharedFormula":"A141"}       {"sharedFormula":"I140"}
{"sharedFormula":"A141"}       {"sharedFormula":"I140"}
{"sharedFormula":"A141"}       {"sharedFormula":"I140"}
{"sharedFormula":"A141"}       {"sharedFormula":"I140"}
{"sharedFormula":"A141"}       {"sharedFormula":"I140"}
{"sharedFormula":"A141"}       {"sharedFormula":"I140"}
{"sharedFormula":"A141"}       {"sharedFormula":"I140"}
{"sharedFormula":"A141"}       {"sharedFormula":"I140"}
{"sharedFormula":"A141"}       {"sharedFormula":"I140"}
{"sharedFormula":"A141"}       {"sharedFormula":"I140"}
{"sharedFormula":"A141"}       {"sharedFormula":"I140"}
{"sharedFormula":"A141"}       {"sharedFormula":"I140"}
{"sharedFormula":"A141"}       {"sharedFormula":"I140"}
{"sharedFormula":"A141"}       {"sharedFormula":"I140"}
{"sharedFormula":"A141"}       {"sharedFormula":"I140"}
{"sharedFormula":"A141"}       {"sharedFormula":"I140"}
{"sharedFormula":"A141"}       {"sharedFormula":"I140"}
{"sharedFormula":"A141"}       {"sharedFormula":"I140"}
{"sharedFormula":"A141"}       {"sharedFormula":"I140"}
{"sharedFormula":"A141"}       {"sharedFormula":"I140"}
{"sharedFormula":"A141"}       {"sharedFormula":"I140"}
{"sharedFormula":"A141"}       {"sharedFormula":"I140"}
{"sharedFormula":"A141"}       {"sharedFormula":"I140"}
{"sharedFormula":"A141"}       {"sharedFormula":"I140"}
{"sharedFormula":"A141"}       {"sharedFormula":"I140"}
{"sharedFormula":"A141"}       {"sharedFormula":"I140"}
{"sharedFormula":"A141"}       {"sharedFormula":"I140"}
{"sharedFormula":"A141"}       {"sharedFormula":"I140"}
{"sharedFormula":"A141"}       {"sharedFormula":"I140"}
{"sharedFormula":"A141"}       {"sharedFormula":"I140"}
{"sharedFormula":"A141"}       {"sharedFormula":"I140"}
{"sharedFormula":"A141"}       {"sharedFormula":"I140"}
{"sharedFormula":"A141"}       {"sharedFormula":"I140"}
{"sharedFormula":"A141"}       {"sharedFormula":"I140"}
{"sharedFormula":"A141"}       {"sharedFormula":"I140"}
{"sharedFormula":"A141"}       {"sharedFormula":"I140"}
{"sharedFormula":"A141"}       {"sharedFormula":"I140"}
{"sharedFormula":"A141"}       {"sharedFormula":"I140"}
{"sharedFormula":"A141"}       {"sharedFormula":"I140"}
{"sharedFormula":"A141"}       {"sharedFormula":"I140"}
{"sharedFormula":"A141"}       {"sharedFormula":"I140"}
{"sharedFormula":"A141"}       {"sharedFormula":"I140"}
{"sharedFormula":"A141"}       {"sharedFormula":"I140"}
{"sharedFormula":"A141"}       {"sharedFormula":"I140"}
{"sharedFormula":"A141"}       {"sharedFormula":"I140"}
{"sharedFormula":"A141"}       {"sharedFormula":"I140"}
{"sharedFormula":"A141"}       {"sharedFormula":"I140"}
{"sharedFormula":"A141"}       {"sharedFormula":"I140"}
{"sharedFormula":"A141"}       {"sharedFormula":"I140"}
{"sharedFormula":"A141"}       {"sharedFormula":"I140"}
{"sharedFormula":"A141"}       {"sharedFormula":"I140"}
{"sharedFormula":"A141"}       {"sharedFormula":"I140"}
{"sharedFormula":"A141"}       {"sharedFormula":"I140"}

【記入例】宣誓書

             
             
    
   1人当たり給与支給総額の確認書
    第6回公募受付用 
             
        事業者名 
             
  応募申請時点における対象となる従業員及び1人当たり給与支給額について          
  記載した内容に間違いがないことを証明します。          
             
  対象となる従業員及び算定対象となる給与の考え方については以下になります。          
  詳細は公募要領・申請の手引きをご確認ください。          
  ■対象となる従業員          
   基準年度及びその算出対象となる各事業年度において、全月分の給与等の支給を受けた従業員とします。          
   中途採用や退職等で全月分の給与等の支給を受けていない従業員については、          
   全月分の給与等の支給を受けていない事業年度に限り、算出の対象から除く必要があります          
  ■算定対象となる給与          
   給料、賃金、賞与、各種手当(残業手当、休日出勤手当、職務手当、地域手当、家族(扶養)手当、住宅手当)等、          
   給与所得として課税対象となる経費を指します。福利厚生費、法定福利費や退職金は除きます。           
   当該事業年度において、産前・産後休業、育児休業、介護休業など事業者の福利厚生等により          
   時短勤務を行っている従業員は、算定対象から除くことができます。          
  ※直近決算の期間によって使用するシートが異なります。記入例をご確認の上、該当するシートにご記載ください。          
   両シートに記載していただく必要はございません。          
             
  賃金台帳における給与支給総額の算定対象となる科目          
     
     

【記入例】直近決算 1年(12か月)

         
 ■基準年度(直近の決算期)が1年(12か月)の事業者       
 ※直近の決算期が1年の事業者のみご使用ください。       
         
 直近の決算期(自)直近の決算期(至)全月分の給与等の支給を受けた
従業員の給与支給総額
全月分の給与等の支給を受けた
従業員数
従業員1人当たり給与支給総額   
 2024-04-012025-03-311150000033833333.33   
         
         
         
         
         
         
         
         
         
         
NO従業員番号等対象従業員名全月分の給与支給の
対象外
福利厚生等による時短勤務給与支給額  対象外チェック
  
111111a  4000000  {"formula":"IF(D19=\"☑\",TRUE,FALSE)"}
222222b  5000000  {"formula":"IF(D20=\"☑\",TRUE,FALSE)","ref":"I20:I83","shareType":"shared"}
333333C 4500000  true
444444d 2500000  {"sharedFormula":"I20"}
{"sharedFormula":"A21"}       {"sharedFormula":"I20"}
{"sharedFormula":"A21"}       {"sharedFormula":"I20"}
{"sharedFormula":"A21"}       {"sharedFormula":"I20"}
{"sharedFormula":"A21"}       {"sharedFormula":"I20"}
{"sharedFormula":"A21"}       {"sharedFormula":"I20"}
{"sharedFormula":"A21"}       {"sharedFormula":"I20"}
{"sharedFormula":"A21"}       {"sharedFormula":"I20"}
{"sharedFormula":"A21"}       {"sharedFormula":"I20"}
{"sharedFormula":"A21"}       {"sharedFormula":"I20"}
{"sharedFormula":"A21"}       {"sharedFormula":"I20"}
{"sharedFormula":"A21"}       {"sharedFormula":"I20"}
{"sharedFormula":"A21"}       {"sharedFormula":"I20"}
{"sharedFormula":"A21"}       {"sharedFormula":"I20"}
{"sharedFormula":"A21"}       {"sharedFormula":"I20"}
{"sharedFormula":"A21"}       {"sharedFormula":"I20"}
{"sharedFormula":"A21"}       {"sharedFormula":"I20"}
{"sharedFormula":"A21"}       {"sharedFormula":"I20"}
{"sharedFormula":"A21"}       {"sharedFormula":"I20"}
{"sharedFormula":"A21"}       {"sharedFormula":"I20"}
{"sharedFormula":"A21"}       {"sharedFormula":"I20"}
{"sharedFormula":"A21"}       {"sharedFormula":"I20"}
{"sharedFormula":"A21"}       {"sharedFormula":"I20"}
{"sharedFormula":"A21"}       {"sharedFormula":"I20"}
{"sharedFormula":"A21"}       {"sharedFormula":"I20"}
{"sharedFormula":"A21"}       {"sharedFormula":"I20"}
{"sharedFormula":"A21"}       {"sharedFormula":"I20"}
{"sharedFormula":"A21"}       {"sharedFormula":"I20"}
{"sharedFormula":"A21"}       {"sharedFormula":"I20"}
{"sharedFormula":"A21"}       {"sharedFormula":"I20"}
{"sharedFormula":"A21"}       {"sharedFormula":"I20"}
{"sharedFormula":"A21"}       {"sharedFormula":"I20"}
{"sharedFormula":"A21"}       {"sharedFormula":"I20"}
{"sharedFormula":"A21"}       {"sharedFormula":"I20"}
{"sharedFormula":"A21"}       {"sharedFormula":"I20"}
{"sharedFormula":"A21"}       {"sharedFormula":"I20"}
{"sharedFormula":"A21"}       {"sharedFormula":"I20"}
{"sharedFormula":"A21"}       {"sharedFormula":"I20"}
{"sharedFormula":"A21"}       {"sharedFormula":"I20"}
{"sharedFormula":"A21"}       {"sharedFormula":"I20"}
{"sharedFormula":"A21"}       {"sharedFormula":"I20"}
{"sharedFormula":"A21"}       {"sharedFormula":"I20"}
{"sharedFormula":"A21"}       {"sharedFormula":"I20"}
{"sharedFormula":"A21"}       {"sharedFormula":"I20"}
{"sharedFormula":"A21"}       {"sharedFormula":"I20"}
{"sharedFormula":"A21"}       {"sharedFormula":"I20"}
{"sharedFormula":"A21"}       {"sharedFormula":"I20"}
{"sharedFormula":"A21"}       {"sharedFormula":"I20"}
{"sharedFormula":"A21"}       {"sharedFormula":"I20"}
{"sharedFormula":"A21"}       {"sharedFormula":"I20"}
{"sharedFormula":"A21"}       {"sharedFormula":"I20"}
{"sharedFormula":"A21"}       {"sharedFormula":"I20"}
{"sharedFormula":"A21"}       {"sharedFormula":"I20"}
{"sharedFormula":"A21"}       {"sharedFormula":"I20"}
{"sharedFormula":"A21"}       {"sharedFormula":"I20"}
{"sharedFormula":"A21"}       {"sharedFormula":"I20"}
{"sharedFormula":"A21"}       {"sharedFormula":"I20"}
{"sharedFormula":"A21"}       {"sharedFormula":"I20"}
{"sharedFormula":"A21"}       {"sharedFormula":"I20"}
{"sharedFormula":"A21"}       {"sharedFormula":"I20"}
{"sharedFormula":"A21"}       {"sharedFormula":"I20"}
{"sharedFormula":"A21"}       {"sharedFormula":"I20"}
{"sharedFormula":"A21"}       {"formula":"IF(D84=\"☑\",TRUE,FALSE)","ref":"I84:I147","shareType":"shared"}
{"formula":"IF(C85=\"\",\"\",A84+1)","ref":"A85:A148","shareType":"shared"}       {"sharedFormula":"I84"}
{"sharedFormula":"A85"}       {"sharedFormula":"I84"}
{"sharedFormula":"A85"}       {"sharedFormula":"I84"}
{"sharedFormula":"A85"}       {"sharedFormula":"I84"}
{"sharedFormula":"A85"}       {"sharedFormula":"I84"}
{"sharedFormula":"A85"}       {"sharedFormula":"I84"}
{"sharedFormula":"A85"}       {"sharedFormula":"I84"}
{"sharedFormula":"A85"}       {"sharedFormula":"I84"}
{"sharedFormula":"A85"}       {"sharedFormula":"I84"}
{"sharedFormula":"A85"}       {"sharedFormula":"I84"}
{"sharedFormula":"A85"}       {"sharedFormula":"I84"}
{"sharedFormula":"A85"}       {"sharedFormula":"I84"}
{"sharedFormula":"A85"}       {"sharedFormula":"I84"}
{"sharedFormula":"A85"}       {"sharedFormula":"I84"}
{"sharedFormula":"A85"}       {"sharedFormula":"I84"}
{"sharedFormula":"A85"}       {"sharedFormula":"I84"}
{"sharedFormula":"A85"}       {"sharedFormula":"I84"}
{"sharedFormula":"A85"}       {"sharedFormula":"I84"}
{"sharedFormula":"A85"}       {"sharedFormula":"I84"}
{"sharedFormula":"A85"}       {"sharedFormula":"I84"}
{"sharedFormula":"A85"}       {"sharedFormula":"I84"}
{"sharedFormula":"A85"}       {"sharedFormula":"I84"}
{"sharedFormula":"A85"}       {"sharedFormula":"I84"}
{"sharedFormula":"A85"}       {"sharedFormula":"I84"}
{"sharedFormula":"A85"}       {"sharedFormula":"I84"}
{"sharedFormula":"A85"}       {"sharedFormula":"I84"}
{"sharedFormula":"A85"}       {"sharedFormula":"I84"}
{"sharedFormula":"A85"}       {"sharedFormula":"I84"}
{"sharedFormula":"A85"}       {"sharedFormula":"I84"}
{"sharedFormula":"A85"}       {"sharedFormula":"I84"}
{"sharedFormula":"A85"}       {"sharedFormula":"I84"}
{"sharedFormula":"A85"}       {"sharedFormula":"I84"}
{"sharedFormula":"A85"}       {"sharedFormula":"I84"}
{"sharedFormula":"A85"}       {"sharedFormula":"I84"}
{"sharedFormula":"A85"}       {"sharedFormula":"I84"}
{"sharedFormula":"A85"}       {"sharedFormula":"I84"}
{"sharedFormula":"A85"}       {"sharedFormula":"I84"}
{"sharedFormula":"A85"}       {"sharedFormula":"I84"}
{"sharedFormula":"A85"}       {"sharedFormula":"I84"}
{"sharedFormula":"A85"}       {"sharedFormula":"I84"}
{"sharedFormula":"A85"}       {"sharedFormula":"I84"}
{"sharedFormula":"A85"}       {"sharedFormula":"I84"}
{"sharedFormula":"A85"}       {"sharedFormula":"I84"}
{"sharedFormula":"A85"}       {"sharedFormula":"I84"}
{"sharedFormula":"A85"}       {"sharedFormula":"I84"}
{"sharedFormula":"A85"}       {"sharedFormula":"I84"}
{"sharedFormula":"A85"}       {"sharedFormula":"I84"}
{"sharedFormula":"A85"}       {"sharedFormula":"I84"}
{"sharedFormula":"A85"}       {"sharedFormula":"I84"}
{"sharedFormula":"A85"}       {"sharedFormula":"I84"}
{"sharedFormula":"A85"}       {"sharedFormula":"I84"}
{"sharedFormula":"A85"}       {"sharedFormula":"I84"}
{"sharedFormula":"A85"}       {"sharedFormula":"I84"}
{"sharedFormula":"A85"}       {"sharedFormula":"I84"}
{"sharedFormula":"A85"}       {"sharedFormula":"I84"}
{"sharedFormula":"A85"}       {"sharedFormula":"I84"}
{"sharedFormula":"A85"}       {"sharedFormula":"I84"}
{"sharedFormula":"A85"}       {"sharedFormula":"I84"}
{"sharedFormula":"A85"}       {"sharedFormula":"I84"}
{"sharedFormula":"A85"}       {"sharedFormula":"I84"}
{"sharedFormula":"A85"}       {"sharedFormula":"I84"}
{"sharedFormula":"A85"}       {"sharedFormula":"I84"}
{"sharedFormula":"A85"}       {"sharedFormula":"I84"}
{"sharedFormula":"A85"}       {"formula":"IF(D148=\"☑\",TRUE,FALSE)","ref":"I148:I211","shareType":"shared"}
{"formula":"IF(C149=\"\",\"\",A148+1)","ref":"A149:A212","shareType":"shared"}       {"sharedFormula":"I148"}
{"sharedFormula":"A149"}       {"sharedFormula":"I148"}
{"sharedFormula":"A149"}       {"sharedFormula":"I148"}
{"sharedFormula":"A149"}       {"sharedFormula":"I148"}
{"sharedFormula":"A149"}       {"sharedFormula":"I148"}
{"sharedFormula":"A149"}       {"sharedFormula":"I148"}
{"sharedFormula":"A149"}       {"sharedFormula":"I148"}
{"sharedFormula":"A149"}       {"sharedFormula":"I148"}
{"sharedFormula":"A149"}       {"sharedFormula":"I148"}
{"sharedFormula":"A149"}       {"sharedFormula":"I148"}
{"sharedFormula":"A149"}       {"sharedFormula":"I148"}
{"sharedFormula":"A149"}       {"sharedFormula":"I148"}
{"sharedFormula":"A149"}       {"sharedFormula":"I148"}
{"sharedFormula":"A149"}       {"sharedFormula":"I148"}
{"sharedFormula":"A149"}       {"sharedFormula":"I148"}
{"sharedFormula":"A149"}       {"sharedFormula":"I148"}
{"sharedFormula":"A149"}       {"sharedFormula":"I148"}
{"sharedFormula":"A149"}       {"sharedFormula":"I148"}
{"sharedFormula":"A149"}       {"sharedFormula":"I148"}
{"sharedFormula":"A149"}       {"sharedFormula":"I148"}
{"sharedFormula":"A149"}       {"sharedFormula":"I148"}
{"sharedFormula":"A149"}       {"sharedFormula":"I148"}
{"sharedFormula":"A149"}       {"sharedFormula":"I148"}
{"sharedFormula":"A149"}       {"sharedFormula":"I148"}
{"sharedFormula":"A149"}       {"sharedFormula":"I148"}
{"sharedFormula":"A149"}       {"sharedFormula":"I148"}
{"sharedFormula":"A149"}       {"sharedFormula":"I148"}
{"sharedFormula":"A149"}       {"sharedFormula":"I148"}
{"sharedFormula":"A149"}       {"sharedFormula":"I148"}
{"sharedFormula":"A149"}       {"sharedFormula":"I148"}
{"sharedFormula":"A149"}       {"sharedFormula":"I148"}
{"sharedFormula":"A149"}       {"sharedFormula":"I148"}
{"sharedFormula":"A149"}       {"sharedFormula":"I148"}
{"sharedFormula":"A149"}       {"sharedFormula":"I148"}
{"sharedFormula":"A149"}       {"sharedFormula":"I148"}
{"sharedFormula":"A149"}       {"sharedFormula":"I148"}
{"sharedFormula":"A149"}       {"sharedFormula":"I148"}
{"sharedFormula":"A149"}       {"sharedFormula":"I148"}
{"sharedFormula":"A149"}       {"sharedFormula":"I148"}
{"sharedFormula":"A149"}       {"sharedFormula":"I148"}
{"sharedFormula":"A149"}       {"sharedFormula":"I148"}
{"sharedFormula":"A149"}       {"sharedFormula":"I148"}
{"sharedFormula":"A149"}       {"sharedFormula":"I148"}
{"sharedFormula":"A149"}       {"sharedFormula":"I148"}
{"sharedFormula":"A149"}       {"sharedFormula":"I148"}
{"sharedFormula":"A149"}       {"sharedFormula":"I148"}
{"sharedFormula":"A149"}       {"sharedFormula":"I148"}
{"sharedFormula":"A149"}       {"sharedFormula":"I148"}
{"sharedFormula":"A149"}       {"sharedFormula":"I148"}
{"sharedFormula":"A149"}       {"sharedFormula":"I148"}
{"sharedFormula":"A149"}       {"sharedFormula":"I148"}
{"sharedFormula":"A149"}       {"sharedFormula":"I148"}

※直近決算 1年(12か月)未満のみ使用※

         
 ■基準年度(直近の決算期)が1年(12か月)未満の事業者  直近の決算期(自)直近の決算期(至)   
 ※直近の決算期が1年に満たない事業者のみご使用ください。       
  上記に該当しない事業者はこちらをクリックしてください。     
         
 直近決算期における月数直近決算期における
従業員の給与支給総額
12か月換算における
従業員の給与支給総額
全月分の給与等の支給を受けた
従業員数
12か月分換算
従業員1人当たり給与支給総額
   
 {"formula":"IF(AND(E3=\"\",F3=\"\"),\"\",IFERROR(DATEDIF(E3,F3,\"M\")+1,\"\"))"}{"formula":"IFERROR(SUMIFS($F$12:$F$3011,$J$12:$J$3011,FALSE,$I$12:$I$3011,TRUE),\"\")"}{"formula":"IFERROR(C7/B7*12,0)"}{"formula":"COUNTIF($I$12:$I$3011,TRUE)-COUNTIFS($J$12:$J$3011,TRUE,$I$12:$I$3011,TRUE)"}-   
         
         
NO従業員番号等対象従業員名全月分の給与支給の
対象外
福利厚生等による時短勤務給与支給額  入力チェック
  
1       {"formula":"IF(AND(C12<>\"\",F12<>\"\"),TRUE,FALSE)"}
{"formula":"IF(C13=\"\",\"\",A12+1)"}       {"formula":"IF(AND(C13<>\"\",F13<>\"\"),TRUE,FALSE)","ref":"I13:I76","shareType":"shared"}
{"formula":"IF(C14=\"\",\"\",A13+1)","ref":"A14:A77","shareType":"shared"}       {"sharedFormula":"I13"}
{"sharedFormula":"A14"}       {"sharedFormula":"I13"}
{"sharedFormula":"A14"}       {"sharedFormula":"I13"}
{"sharedFormula":"A14"}       {"sharedFormula":"I13"}
{"sharedFormula":"A14"}       {"sharedFormula":"I13"}
{"sharedFormula":"A14"}       {"sharedFormula":"I13"}
{"sharedFormula":"A14"}       {"sharedFormula":"I13"}
{"sharedFormula":"A14"}       {"sharedFormula":"I13"}
{"sharedFormula":"A14"}       {"sharedFormula":"I13"}
{"sharedFormula":"A14"}       {"sharedFormula":"I13"}
{"sharedFormula":"A14"}       {"sharedFormula":"I13"}
{"sharedFormula":"A14"}       {"sharedFormula":"I13"}
{"sharedFormula":"A14"}       {"sharedFormula":"I13"}
{"sharedFormula":"A14"}       {"sharedFormula":"I13"}
{"sharedFormula":"A14"}       {"sharedFormula":"I13"}
{"sharedFormula":"A14"}       {"sharedFormula":"I13"}
{"sharedFormula":"A14"}       {"sharedFormula":"I13"}
{"sharedFormula":"A14"}       {"sharedFormula":"I13"}
{"sharedFormula":"A14"}       {"sharedFormula":"I13"}
{"sharedFormula":"A14"}       {"sharedFormula":"I13"}
{"sharedFormula":"A14"}       {"sharedFormula":"I13"}
{"sharedFormula":"A14"}       {"sharedFormula":"I13"}
{"sharedFormula":"A14"}       {"sharedFormula":"I13"}
{"sharedFormula":"A14"}       {"sharedFormula":"I13"}
{"sharedFormula":"A14"}       {"sharedFormula":"I13"}
{"sharedFormula":"A14"}       {"sharedFormula":"I13"}
{"sharedFormula":"A14"}       {"sharedFormula":"I13"}
{"sharedFormula":"A14"}       {"sharedFormula":"I13"}
{"sharedFormula":"A14"}       {"sharedFormula":"I13"}
{"sharedFormula":"A14"}       {"sharedFormula":"I13"}
{"sharedFormula":"A14"}       {"sharedFormula":"I13"}
{"sharedFormula":"A14"}       {"sharedFormula":"I13"}
{"sharedFormula":"A14"}       {"sharedFormula":"I13"}
{"sharedFormula":"A14"}       {"sharedFormula":"I13"}
{"sharedFormula":"A14"}       {"sharedFormula":"I13"}
{"sharedFormula":"A14"}       {"sharedFormula":"I13"}
{"sharedFormula":"A14"}       {"sharedFormula":"I13"}
{"sharedFormula":"A14"}       {"sharedFormula":"I13"}
{"sharedFormula":"A14"}       {"sharedFormula":"I13"}
{"sharedFormula":"A14"}       {"sharedFormula":"I13"}
{"sharedFormula":"A14"}       {"sharedFormula":"I13"}
{"sharedFormula":"A14"}       {"sharedFormula":"I13"}
{"sharedFormula":"A14"}       {"sharedFormula":"I13"}
{"sharedFormula":"A14"}       {"sharedFormula":"I13"}
{"sharedFormula":"A14"}       {"sharedFormula":"I13"}
{"sharedFormula":"A14"}       {"sharedFormula":"I13"}
{"sharedFormula":"A14"}       {"sharedFormula":"I13"}
{"sharedFormula":"A14"}       {"sharedFormula":"I13"}
{"sharedFormula":"A14"}       {"sharedFormula":"I13"}
{"sharedFormula":"A14"}       {"sharedFormula":"I13"}
{"sharedFormula":"A14"}       {"sharedFormula":"I13"}
{"sharedFormula":"A14"}       {"sharedFormula":"I13"}
{"sharedFormula":"A14"}       {"sharedFormula":"I13"}
{"sharedFormula":"A14"}       {"sharedFormula":"I13"}
{"sharedFormula":"A14"}       {"sharedFormula":"I13"}
{"sharedFormula":"A14"}       {"sharedFormula":"I13"}
{"sharedFormula":"A14"}       {"sharedFormula":"I13"}
{"sharedFormula":"A14"}       {"sharedFormula":"I13"}
{"sharedFormula":"A14"}       {"sharedFormula":"I13"}
{"sharedFormula":"A14"}       {"sharedFormula":"I13"}
{"sharedFormula":"A14"}       {"sharedFormula":"I13"}
{"sharedFormula":"A14"}       {"sharedFormula":"I13"}
{"sharedFormula":"A14"}       {"sharedFormula":"I13"}
{"sharedFormula":"A14"}       {"formula":"IF(AND(C77<>\"\",F77<>\"\"),TRUE,FALSE)","ref":"I77:I140","shareType":"shared"}
{"formula":"IF(C78=\"\",\"\",A77+1)","ref":"A78:A141","shareType":"shared"}       {"sharedFormula":"I77"}
{"sharedFormula":"A78"}       {"sharedFormula":"I77"}
{"sharedFormula":"A78"}       {"sharedFormula":"I77"}
{"sharedFormula":"A78"}       {"sharedFormula":"I77"}
{"sharedFormula":"A78"}       {"sharedFormula":"I77"}
{"sharedFormula":"A78"}       {"sharedFormula":"I77"}
{"sharedFormula":"A78"}       {"sharedFormula":"I77"}
{"sharedFormula":"A78"}       {"sharedFormula":"I77"}
{"sharedFormula":"A78"}       {"sharedFormula":"I77"}
{"sharedFormula":"A78"}       {"sharedFormula":"I77"}
{"sharedFormula":"A78"}       {"sharedFormula":"I77"}
{"sharedFormula":"A78"}       {"sharedFormula":"I77"}
{"sharedFormula":"A78"}       {"sharedFormula":"I77"}
{"sharedFormula":"A78"}       {"sharedFormula":"I77"}
{"sharedFormula":"A78"}       {"sharedFormula":"I77"}
{"sharedFormula":"A78"}       {"sharedFormula":"I77"}
{"sharedFormula":"A78"}       {"sharedFormula":"I77"}
{"sharedFormula":"A78"}       {"sharedFormula":"I77"}
{"sharedFormula":"A78"}       {"sharedFormula":"I77"}
{"sharedFormula":"A78"}       {"sharedFormula":"I77"}
{"sharedFormula":"A78"}       {"sharedFormula":"I77"}
{"sharedFormula":"A78"}       {"sharedFormula":"I77"}
{"sharedFormula":"A78"}       {"sharedFormula":"I77"}
{"sharedFormula":"A78"}       {"sharedFormula":"I77"}
{"sharedFormula":"A78"}       {"sharedFormula":"I77"}
{"sharedFormula":"A78"}       {"sharedFormula":"I77"}
{"sharedFormula":"A78"}       {"sharedFormula":"I77"}
{"sharedFormula":"A78"}       {"sharedFormula":"I77"}
{"sharedFormula":"A78"}       {"sharedFormula":"I77"}
{"sharedFormula":"A78"}       {"sharedFormula":"I77"}
{"sharedFormula":"A78"}       {"sharedFormula":"I77"}
{"sharedFormula":"A78"}       {"sharedFormula":"I77"}
{"sharedFormula":"A78"}       {"sharedFormula":"I77"}
{"sharedFormula":"A78"}       {"sharedFormula":"I77"}
{"sharedFormula":"A78"}       {"sharedFormula":"I77"}
{"sharedFormula":"A78"}       {"sharedFormula":"I77"}
{"sharedFormula":"A78"}       {"sharedFormula":"I77"}
{"sharedFormula":"A78"}       {"sharedFormula":"I77"}
{"sharedFormula":"A78"}       {"sharedFormula":"I77"}
{"sharedFormula":"A78"}       {"sharedFormula":"I77"}
{"sharedFormula":"A78"}       {"sharedFormula":"I77"}
{"sharedFormula":"A78"}       {"sharedFormula":"I77"}
{"sharedFormula":"A78"}       {"sharedFormula":"I77"}
{"sharedFormula":"A78"}       {"sharedFormula":"I77"}
{"sharedFormula":"A78"}       {"sharedFormula":"I77"}
{"sharedFormula":"A78"}       {"sharedFormula":"I77"}
{"sharedFormula":"A78"}       {"sharedFormula":"I77"}
{"sharedFormula":"A78"}       {"sharedFormula":"I77"}
{"sharedFormula":"A78"}       {"sharedFormula":"I77"}
{"sharedFormula":"A78"}       {"sharedFormula":"I77"}
{"sharedFormula":"A78"}       {"sharedFormula":"I77"}
{"sharedFormula":"A78"}       {"sharedFormula":"I77"}
{"sharedFormula":"A78"}       {"sharedFormula":"I77"}
{"sharedFormula":"A78"}       {"sharedFormula":"I77"}
{"sharedFormula":"A78"}       {"sharedFormula":"I77"}
{"sharedFormula":"A78"}       {"sharedFormula":"I77"}
{"sharedFormula":"A78"}       {"sharedFormula":"I77"}
{"sharedFormula":"A78"}       {"sharedFormula":"I77"}
{"sharedFormula":"A78"}       {"sharedFormula":"I77"}
{"sharedFormula":"A78"}       {"sharedFormula":"I77"}
{"sharedFormula":"A78"}       {"sharedFormula":"I77"}
{"sharedFormula":"A78"}       {"sharedFormula":"I77"}
{"sharedFormula":"A78"}       {"sharedFormula":"I77"}
{"sharedFormula":"A78"}       {"formula":"IF(AND(C141<>\"\",F141<>\"\"),TRUE,FALSE)","ref":"I141:I204","shareType":"shared"}
{"formula":"IF(C142=\"\",\"\",A141+1)","ref":"A142:A205","shareType":"shared"}       {"sharedFormula":"I141"}
{"sharedFormula":"A142"}       {"sharedFormula":"I141"}
{"sharedFormula":"A142"}       {"sharedFormula":"I141"}
{"sharedFormula":"A142"}       {"sharedFormula":"I141"}
{"sharedFormula":"A142"}       {"sharedFormula":"I141"}
{"sharedFormula":"A142"}       {"sharedFormula":"I141"}
{"sharedFormula":"A142"}       {"sharedFormula":"I141"}
{"sharedFormula":"A142"}       {"sharedFormula":"I141"}
{"sharedFormula":"A142"}       {"sharedFormula":"I141"}
{"sharedFormula":"A142"}       {"sharedFormula":"I141"}
{"sharedFormula":"A142"}       {"sharedFormula":"I141"}
{"sharedFormula":"A142"}       {"sharedFormula":"I141"}
{"sharedFormula":"A142"}       {"sharedFormula":"I141"}
{"sharedFormula":"A142"}       {"sharedFormula":"I141"}
{"sharedFormula":"A142"}       {"sharedFormula":"I141"}
{"sharedFormula":"A142"}       {"sharedFormula":"I141"}
{"sharedFormula":"A142"}       {"sharedFormula":"I141"}
{"sharedFormula":"A142"}       {"sharedFormula":"I141"}
{"sharedFormula":"A142"}       {"sharedFormula":"I141"}
{"sharedFormula":"A142"}       {"sharedFormula":"I141"}
{"sharedFormula":"A142"}       {"sharedFormula":"I141"}
{"sharedFormula":"A142"}       {"sharedFormula":"I141"}
{"sharedFormula":"A142"}       {"sharedFormula":"I141"}
{"sharedFormula":"A142"}       {"sharedFormula":"I141"}
{"sharedFormula":"A142"}       {"sharedFormula":"I141"}
{"sharedFormula":"A142"}       {"sharedFormula":"I141"}
{"sharedFormula":"A142"}       {"sharedFormula":"I141"}
{"sharedFormula":"A142"}       {"sharedFormula":"I141"}
{"sharedFormula":"A142"}       {"sharedFormula":"I141"}
{"sharedFormula":"A142"}       {"sharedFormula":"I141"}
{"sharedFormula":"A142"}       {"sharedFormula":"I141"}
{"sharedFormula":"A142"}       {"sharedFormula":"I141"}
{"sharedFormula":"A142"}       {"sharedFormula":"I141"}
{"sharedFormula":"A142"}       {"sharedFormula":"I141"}
{"sharedFormula":"A142"}       {"sharedFormula":"I141"}
{"sharedFormula":"A142"}       {"sharedFormula":"I141"}
{"sharedFormula":"A142"}       {"sharedFormula":"I141"}
{"sharedFormula":"A142"}       {"sharedFormula":"I141"}
{"sharedFormula":"A142"}       {"sharedFormula":"I141"}
{"sharedFormula":"A142"}       {"sharedFormula":"I141"}
{"sharedFormula":"A142"}       {"sharedFormula":"I141"}
{"sharedFormula":"A142"}       {"sharedFormula":"I141"}
{"sharedFormula":"A142"}       {"sharedFormula":"I141"}
{"sharedFormula":"A142"}       {"sharedFormula":"I141"}
{"sharedFormula":"A142"}       {"sharedFormula":"I141"}
{"sharedFormula":"A142"}       {"sharedFormula":"I141"}
{"sharedFormula":"A142"}       {"sharedFormula":"I141"}
{"sharedFormula":"A142"}       {"sharedFormula":"I141"}
{"sharedFormula":"A142"}       {"sharedFormula":"I141"}
{"sharedFormula":"A142"}       {"sharedFormula":"I141"}
{"sharedFormula":"A142"}       {"sharedFormula":"I141"}
{"sharedFormula":"A142"}       {"sharedFormula":"I141"}
{"sharedFormula":"A142"}       {"sharedFormula":"I141"}
{"sharedFormula":"A142"}       {"sharedFormula":"I141"}
{"sharedFormula":"A142"}       {"sharedFormula":"I141"}
{"sharedFormula":"A142"}       {"sharedFormula":"I141"}
{"sharedFormula":"A142"}       {"sharedFormula":"I141"}
{"sharedFormula":"A142"}       {"sharedFormula":"I141"}
{"sharedFormula":"A142"}       {"sharedFormula":"I141"}

【記入例】直近決算 1年(12か月)未満

        
 ■基準年度(直近の決算期)が1年(12か月)未満の事業者  直近の決算期(自)直近の決算期(至)  
 ※直近の決算期が1年に満たない事業者のみご使用ください。  2025-04-012025-11-30  
  上記に該当しない事業者はこちらをクリックしてください。      
        
 直近決算期における月数直近決算期における
従業員の給与支給総額
全月分の給与等の支給を受けた
従業員の給与支給総額
全月分の給与等の支給を受けた
従業員数
12か月分換算
従業員1人当たり給与支給総額
  
 8115000001725000035750000  
        
        
        
        
        
        
        
        
        
        
NO従業員番号等対象従業員名全月分の給与支給の
対象外
福利厚生等による時短勤務給与支給額  
  
111111a  4000000  
222222b  5000000  
333333C 4500000  
444444d 2500000  
{"sharedFormula":"A22"}       
{"sharedFormula":"A22"}       
{"sharedFormula":"A22"}       
{"sharedFormula":"A22"}       
{"sharedFormula":"A22"}       
{"sharedFormula":"A22"}       
{"sharedFormula":"A22"}       
{"sharedFormula":"A22"}       
{"sharedFormula":"A22"}       
{"sharedFormula":"A22"}       
{"sharedFormula":"A22"}       
{"sharedFormula":"A22"}       
{"sharedFormula":"A22"}       
{"sharedFormula":"A22"}       
{"sharedFormula":"A22"}       
{"sharedFormula":"A22"}       
{"sharedFormula":"A22"}       
{"sharedFormula":"A22"}       
{"sharedFormula":"A22"}       
{"sharedFormula":"A22"}       
{"sharedFormula":"A22"}       
{"sharedFormula":"A22"}       
{"sharedFormula":"A22"}       
{"sharedFormula":"A22"}       
{"sharedFormula":"A22"}       
{"sharedFormula":"A22"}       
{"sharedFormula":"A22"}       
{"sharedFormula":"A22"}       
{"sharedFormula":"A22"}       
{"sharedFormula":"A22"}       
{"sharedFormula":"A22"}       
{"sharedFormula":"A22"}       
{"sharedFormula":"A22"}       
{"sharedFormula":"A22"}       
{"sharedFormula":"A22"}       
{"sharedFormula":"A22"}       
{"sharedFormula":"A22"}       
{"sharedFormula":"A22"}       
{"sharedFormula":"A22"}       
{"sharedFormula":"A22"}       
{"sharedFormula":"A22"}       
{"sharedFormula":"A22"}       
{"sharedFormula":"A22"}       
{"sharedFormula":"A22"}       
{"sharedFormula":"A22"}       
{"sharedFormula":"A22"}       
{"sharedFormula":"A22"}       
{"sharedFormula":"A22"}       
{"sharedFormula":"A22"}       
{"sharedFormula":"A22"}       
{"sharedFormula":"A22"}       
{"sharedFormula":"A22"}       
{"sharedFormula":"A22"}       
{"sharedFormula":"A22"}       
{"sharedFormula":"A22"}       
{"sharedFormula":"A22"}       
{"sharedFormula":"A22"}       
{"sharedFormula":"A22"}       
{"sharedFormula":"A22"}       
{"sharedFormula":"A22"}       
{"sharedFormula":"A22"}       
{"sharedFormula":"A22"}       
{"formula":"IF(C86=\"\",\"\",A85+1)","ref":"A86:A149","shareType":"shared"}       
{"sharedFormula":"A86"}       
{"sharedFormula":"A86"}       
{"sharedFormula":"A86"}       
{"sharedFormula":"A86"}       
{"sharedFormula":"A86"}       
{"sharedFormula":"A86"}       
{"sharedFormula":"A86"}       
{"sharedFormula":"A86"}       
{"sharedFormula":"A86"}       
{"sharedFormula":"A86"}       
{"sharedFormula":"A86"}       
{"sharedFormula":"A86"}       
{"sharedFormula":"A86"}       
{"sharedFormula":"A86"}       
{"sharedFormula":"A86"}       
{"sharedFormula":"A86"}       
{"sharedFormula":"A86"}       
{"sharedFormula":"A86"}       
{"sharedFormula":"A86"}       
{"sharedFormula":"A86"}       
{"sharedFormula":"A86"}       
{"sharedFormula":"A86"}       
{"sharedFormula":"A86"}       
{"sharedFormula":"A86"}       
{"sharedFormula":"A86"}       
{"sharedFormula":"A86"}       
{"sharedFormula":"A86"}       
{"sharedFormula":"A86"}       
{"sharedFormula":"A86"}       
{"sharedFormula":"A86"}       
{"sharedFormula":"A86"}       
{"sharedFormula":"A86"}       
{"sharedFormula":"A86"}       
{"sharedFormula":"A86"}       
{"sharedFormula":"A86"}       
{"sharedFormula":"A86"}       
{"sharedFormula":"A86"}       
{"sharedFormula":"A86"}       
{"sharedFormula":"A86"}       
{"sharedFormula":"A86"}       
{"sharedFormula":"A86"}       
{"sharedFormula":"A86"}       
{"sharedFormula":"A86"}       
{"sharedFormula":"A86"}       
{"sharedFormula":"A86"}       
{"sharedFormula":"A86"}       
{"sharedFormula":"A86"}       
{"sharedFormula":"A86"}       
{"sharedFormula":"A86"}       
{"sharedFormula":"A86"}       
{"sharedFormula":"A86"}       
{"sharedFormula":"A86"}       
{"sharedFormula":"A86"}       
{"sharedFormula":"A86"}       
{"sharedFormula":"A86"}       
{"sharedFormula":"A86"}       
{"sharedFormula":"A86"}       
{"sharedFormula":"A86"}       
{"sharedFormula":"A86"}       
{"sharedFormula":"A86"}       
{"sharedFormula":"A86"}       
{"sharedFormula":"A86"}       
{"sharedFormula":"A86"}       
{"formula":"IF(C150=\"\",\"\",A149+1)","ref":"A150:A213","shareType":"shared"}       
{"sharedFormula":"A150"}       
{"sharedFormula":"A150"}       
{"sharedFormula":"A150"}       
{"sharedFormula":"A150"}       
{"sharedFormula":"A150"}       
{"sharedFormula":"A150"}       
{"sharedFormula":"A150"}       
{"sharedFormula":"A150"}       
{"sharedFormula":"A150"}       
{"sharedFormula":"A150"}       
{"sharedFormula":"A150"}       
{"sharedFormula":"A150"}       
{"sharedFormula":"A150"}       
{"sharedFormula":"A150"}       
{"sharedFormula":"A150"}       
{"sharedFormula":"A150"}       
{"sharedFormula":"A150"}       
{"sharedFormula":"A150"}       
{"sharedFormula":"A150"}       
{"sharedFormula":"A150"}       
{"sharedFormula":"A150"}       
{"sharedFormula":"A150"}       
{"sharedFormula":"A150"}       
{"sharedFormula":"A150"}       
{"sharedFormula":"A150"}       
{"sharedFormula":"A150"}       
{"sharedFormula":"A150"}       
{"sharedFormula":"A150"}       
{"sharedFormula":"A150"}       
{"sharedFormula":"A150"}       
{"sharedFormula":"A150"}       
{"sharedFormula":"A150"}       
{"sharedFormula":"A150"}       
{"sharedFormula":"A150"}       
{"sharedFormula":"A150"}       
{"sharedFormula":"A150"}       
{"sharedFormula":"A150"}       
{"sharedFormula":"A150"}       
{"sharedFormula":"A150"}       
{"sharedFormula":"A150"}       
{"sharedFormula":"A150"}       
{"sharedFormula":"A150"}       
{"sharedFormula":"A150"}       
{"sharedFormula":"A150"}       
{"sharedFormula":"A150"}       
{"sharedFormula":"A150"}       
{"sharedFormula":"A150"}       
{"sharedFormula":"A150"}       
{"sharedFormula":"A150"}       
{"sharedFormula":"A150"}