{"text_format":"3","workbook":"xls","n_sheets":15,"sheets":["メニュー","社員データ入力","A6個人昇給額","B5個人賞与額表","A1昇給シミュレー","A2昇給；区分・上限","A3昇給；年齢給表","A4昇給額表","A5評価と昇給額表","A7給与分布図","B2賞与計算入力表","B3賞与；貢献賞与額表","B4賞与；役職分賞与","賞与；級ー評価一覧","職種等級上限一覧"],"not_rendered":{"charts":2,"images":20,"macros":1,"external_links":1,"defined_names":24,"comments":101},"read":"whole","date_system":"1900","formulas":"cached_only"}

{"sheet":"メニュー","index":0,"n_rows":0,"n_cols":0,"rows_kept":0,"flags":["formulas_cached_only"]}

{"sheet":"社員データ入力","index":1,"n_rows":16,"n_cols":12,"rows_kept":16,"flags":["formulas_cached_only"]}
["社員データ入力シート"]
["西暦　",2025,"年",9,"月"]
["Ｎｏ","社員名","役職","生れた年","昨年の年齢","一般職\n作業職","等級","基本給","役職手当","区分","定期評価結果","賞与評価結果"]
[1,"松下　力也","店長",1980,44,1,6,{"v":291000,"d":"291,000"},null,1,5,5]
[2,"山本　寛","主任",1988,36,1,5,{"v":252100,"d":"252,100"},null,1,4,5]
[3,"日野林",null,1990,34,1,3,{"v":225600,"d":"225,600"},null,1,4,5]
[4,"川本","主任",1995,29,1,3,{"v":198300,"d":"198,300"},null,1,4,5]
[5,"大石",null,2001,23,1,3,{"v":176500,"d":"176,500"},null,1,4,4]
[6,"原",null,2000,24,1,3,{"v":206000,"d":"206,000"},null,1,3,3]
[7,"城戸",null,2002,22,1,3,{"v":223400,"d":"223,400"},null,1,3,3]
[]
["パート社員データ入力",null,null,"→","パートの基準労働時間(月）→",{"$nulls":3},120]
["Ｎｏ","パート名","役職","月平均労働時間","時給","パート職","等級","見なしの基本給","役職手当","区分","定期評価結果","賞与評価結果"]
[1,"成川",null,60,810,3,1,{"v":48600,"d":"48,600"},null,3,4,4]
[2,"宮脇",null,120,799,3,1,{"v":95880,"d":"95,880"},null,3,4,4]
[3,"牧",null,120,810,3,1,{"v":97200,"d":"97,200"},null,3,4,4]

{"sheet":"A6個人昇給額","index":2,"n_rows":21,"n_cols":23,"rows_kept":21,"merged":[[15,0,15,4]],"flags":["formulas_cached_only"]}
[{"$nulls":4},"新能力給への換算テーブルおよび昇給計算"]
[]
[]
[]
["No.","氏名","年齢","役職","今の基本給","級","旧年齢給","旧能力給","新年齢給","評価","区分","職種等級","区分係数","年齢係数","基準昇給(能)","修正昇給","新能力給"," 昇給総額","新基本給","役職手当","調整額","新給与総額（含：役職手当）","  基本給の昇給率"]
[null,"合計",null,null,{"v":1814580,"d":"1,814,580 "},null,{"v":516500,"d":"516,500 "},{"v":1298080,"d":"1,298,080 "},{"v":524419,"d":"524,419 "},{"$nulls":5},{"v":196910,"d":"196,910 "},null,{"v":1487720,"d":"1,487,720 "},{"v":195280,"d":"195,280 "},{"v":1734582.8333333333,"d":"1,734,583 "},{"v":0,"d":"0 "},{"v":0,"d":"0 "},{"v":2009860,"d":"2,009,860 "},{"v":0.107617189652702,"d":"10.76%"}]
["-","-","-","-","-","-","-","-","-","-",{"$nulls":4},"-","-","-","-",{"$nulls":3},"-","-"]
[1,"松下　力也",44,"店長",{"v":291000,"d":"291,000"},6,{"v":81000,"d":"81,000 "},{"v":210000,"d":"210,000 "},{"v":81500,"d":"81,500 "},{"v":5,"d":"5 "},{"v":1,"d":"1 "},{"v":16,"d":"16 "},{"v":1,"d":"1.0"},{"v":1,"d":"1.0"},{"v":38800,"d":"38,800 "},{"v":38800,"d":"38,800"},{"v":248800,"d":"248,800"},{"v":39300,"d":"39,300 "},{"v":330300,"d":"330,300 "},0,0,{"v":330300,"d":"330,300 "},{"v":0.13505154639175257,"d":"13.51%"}]
[2,"山本　寛",36,"主任",{"v":252100,"d":"252,100"},5,{"v":77000,"d":"77,000 "},{"v":175100,"d":"175,100 "},{"v":77500,"d":"77,500 "},{"v":4,"d":"4 "},{"v":1,"d":"1 "},{"v":15,"d":"15 "},{"v":1,"d":"1.0"},{"v":1,"d":"1.0"},{"v":26190,"d":"26,190 "},{"v":26190,"d":"26,190"},{"v":201290,"d":"201,290"},{"v":26700,"d":"26,700 "},{"v":278800,"d":"278,800 "},0,0,{"v":278800,"d":"278,800 "},{"v":0.10591035303451012,"d":"10.59%"}]
[3,"日野林",34,0,{"v":225600,"d":"225,600"},3,{"v":76000,"d":"76,000 "},{"v":149600,"d":"149,600 "},{"v":76500,"d":"76,500 "},{"v":4,"d":"4 "},{"v":1,"d":"1 "},{"v":13,"d":"13 "},{"v":1,"d":"1.0"},{"v":1,"d":"1.0"},{"v":20370,"d":"20,370 "},{"v":20370,"d":"20,370"},{"v":169970,"d":"169,970"},{"v":20900,"d":"20,900 "},{"v":246500,"d":"246,500 "},0,0,{"v":246500,"d":"246,500 "},{"v":0.09264184397163121,"d":"9.26%"}]
[4,"川本",29,"主任",{"v":198300,"d":"198,300"},3,{"v":73500,"d":"73,500 "},{"v":124800,"d":"124,800 "},{"v":74000,"d":"74,000 "},{"v":4,"d":"4 "},{"v":1,"d":"1 "},{"v":13,"d":"13 "},{"v":1,"d":"1.0"},{"v":1,"d":"1.0"},{"v":20370,"d":"20,370 "},{"v":20370,"d":"20,370"},{"v":145170,"d":"145,170"},{"v":20900,"d":"20,900 "},{"v":219200,"d":"219,200 "},0,0,{"v":219200,"d":"219,200 "},{"v":0.1053958648512355,"d":"10.54%"}]
[5,"大石",23,0,{"v":176500,"d":"176,500"},3,{"v":70000,"d":"70,000 "},{"v":106500,"d":"106,500 "},{"v":71000,"d":"71,000 "},{"v":4,"d":"4 "},{"v":1,"d":"1 "},{"v":13,"d":"13 "},{"v":1,"d":"1.0"},{"v":1,"d":"1.0"},{"v":20370,"d":"20,370 "},{"v":20370,"d":"20,370"},{"v":126870,"d":"126,870"},{"v":21400,"d":"21,400 "},{"v":197900,"d":"197,900 "},0,0,{"v":197900,"d":"197,900 "},{"v":0.12124645892351275,"d":"12.12%"}]
[6,"原",24,0,{"v":206000,"d":"206,000"},3,{"v":71000,"d":"71,000 "},{"v":135000,"d":"135,000 "},{"v":71500,"d":"71,500 "},{"v":3,"d":"3 "},{"v":1,"d":"1 "},{"v":13,"d":"13 "},{"v":1,"d":"1.0"},{"v":1,"d":"1.0"},{"v":13580,"d":"13,580 "},{"v":13580,"d":"13,580"},{"v":148580,"d":"148,580"},{"v":14100,"d":"14,100 "},{"v":220100,"d":"220,100 "},0,0,{"v":220100,"d":"220,100 "},{"v":0.06844660194174758,"d":"6.84%"}]
[7,"城戸",22,0,{"v":223400,"d":"223,400"},3,{"v":68000,"d":"68,000 "},{"v":155400,"d":"155,400 "},{"v":70000,"d":"70,000 "},{"v":3,"d":"3 "},{"v":1,"d":"1 "},{"v":13,"d":"13 "},{"v":1,"d":"1.0"},{"v":1,"d":"1.0"},{"v":13580,"d":"13,580 "},{"v":13580,"d":"13,580"},{"v":168980,"d":"168,980"},{"v":15600,"d":"15,600 "},{"v":239000,"d":"239,000 "},0,0,{"v":239000,"d":"239,000 "},{"v":0.06982990152193375,"d":"6.98%"}]
[]
["パート社員の計算結果",{"$nulls":21},"新時給"]
["No.","氏名",null,"役職","今の見なし基本給","級","役職手当","今の支給額","今の時給","評価","区分","職種等級","区分係数",null,"基準昇給(能)","修正昇給","見なし新基本給","昇給総額","新時給額","役職手当","調整額","新給与総額","時給アップ額"]
[1,"成川",null,0,{"v":48600,"d":"48,600"},1,{"v":0,"d":"0 "},{"v":48600,"d":"48,600 "},{"v":810,"d":"810 "},{"v":4,"d":"4 "},{"v":3,"d":"3 "},{"v":31,"d":"31 "},{"v":1,"d":"1.0"},null,{"v":14550,"d":"14,550 "},{"v":7275,"d":"7,275"},{"v":55880,"d":"55,880 "},{"v":7280,"d":"7,280 "},{"v":931.3333333333334,"d":"931"},0,0,{"v":55880,"d":"55,880 "},{"v":121.33333333333337,"d":"121"}]
[2,"宮脇",null,0,{"v":95880,"d":"95,880"},1,{"v":0,"d":"0 "},{"v":95880,"d":"95,880 "},{"v":799,"d":"799 "},{"v":4,"d":"4 "},{"v":3,"d":"3 "},{"v":31,"d":"31 "},{"v":1,"d":"1.0"},null,{"v":14550,"d":"14,550 "},{"v":14550,"d":"14,550"},{"v":110430,"d":"110,430 "},{"v":14550,"d":"14,550 "},{"v":920.25,"d":"920"},0,0,{"v":110430,"d":"110,430 "},{"v":121.25,"d":"121"}]
[3,"牧",null,0,{"v":97200,"d":"97,200"},1,{"v":0,"d":"0 "},{"v":97200,"d":"97,200 "},{"v":810,"d":"810 "},{"v":4,"d":"4 "},{"v":3,"d":"3 "},{"v":31,"d":"31 "},{"v":1,"d":"1.0"},null,{"v":14550,"d":"14,550 "},{"v":14550,"d":"14,550"},{"v":111750,"d":"111,750 "},{"v":14550,"d":"14,550 "},{"v":931.25,"d":"931"},0,0,{"v":111750,"d":"111,750 "},{"v":121.25,"d":"121"}]
["-","-","-","-","-","-","-","-","-","-",{"$nulls":4},"-",null,"-","-",null,null,"-","-","-"]

{"sheet":"B5個人賞与額表","index":3,"n_rows":17,"n_cols":16,"rows_kept":17,"merged":[[2,0,2,2],[11,0,11,2]],"flags":["formulas_cached_only"]}
[null,"個人賞与額"]
["No","氏名","役職","年齢","等級","基本給","基本賞与額","役職分賞与","賞与評価","区分","区分係数","年齢係数","貢献賞与額","修正貢献賞与額","調整額","合計賞与額"]
["合計",{"$nulls":3},"--------",{"v":1814580,"d":"1,814,580"},{"v":810618,"d":"810,618"},{"v":100000,"d":"100,000"},"--------",{"$nulls":3},{"v":1245000,"d":"1,245,000"},{"v":1079000,"d":"1,079,000"},0,{"v":1989618,"d":"1,989,618"}]
[1,"松下　力也","店長",44,6,{"v":291000,"d":"291,000"},{"v":145500,"d":"145,500"},{"v":40000,"d":"40,000"},5,1,1,1,{"v":220000,"d":"220,000 "},{"v":220000,"d":"220,000"},0,{"v":405500,"d":"405,500"}]
[2,"山本　寛","主任",36,5,{"v":252100,"d":"252,100"},{"v":126050,"d":"126,050"},{"v":30000,"d":"30,000"},5,1,1,1,{"v":198000,"d":"198,000 "},{"v":198000,"d":"198,000"},0,{"v":354050,"d":"354,050"}]
[3,"日野林",0,34,3,{"v":225600,"d":"225,600"},{"v":112800,"d":"112,800"},0,5,1,1,1,{"v":154000,"d":"154,000 "},{"v":154000,"d":"154,000"},0,{"v":266800,"d":"266,800"}]
[4,"川本","主任",29,3,{"v":198300,"d":"198,300"},{"v":99150,"d":"99,150"},{"v":30000,"d":"30,000"},5,1,1,1,{"v":154000,"d":"154,000 "},{"v":154000,"d":"154,000"},0,{"v":283150,"d":"283,150"}]
[5,"大石",0,23,3,{"v":176500,"d":"176,500"},{"v":88250,"d":"88,250"},0,4,1,1,1,{"v":116000,"d":"116,000 "},{"v":116000,"d":"116,000"},0,{"v":204250,"d":"204,250"}]
[6,"原",0,24,3,{"v":206000,"d":"206,000"},{"v":103000,"d":"103,000"},0,3,1,1,1,{"v":77000,"d":"77,000 "},{"v":77000,"d":"77,000"},0,{"v":180000,"d":"180,000"}]
[7,"城戸",0,22,3,{"v":223400,"d":"223,400"},{"v":111700,"d":"111,700"},0,3,1,1,1,{"v":77000,"d":"77,000 "},{"v":77000,"d":"77,000"},0,{"v":188700,"d":"188,700"}]
[]
["パート社員の計算結果"]
["No","氏名","役職",null,"等級","見なし基本給","基本賞与額","役職分賞与","賞与評価","区分",null,"労働時間係数","貢献賞与額","修正貢献賞与額","調整額","合計賞与額"]
[1,"成川",0,null,1,{"v":48600,"d":"48,600"},{"v":4860,"d":"4,860"},0,4,3,0.4,0.5,{"v":83000,"d":"83,000 "},{"v":16600,"d":"16,600"},0,{"v":21460,"d":"21,460"}]
[2,"宮脇",0,null,1,{"v":95880,"d":"95,880"},{"v":9588,"d":"9,588"},0,4,3,0.4,1,{"v":83000,"d":"83,000 "},{"v":33200,"d":"33,200"},0,{"v":42788,"d":"42,788"}]
[3,"牧",0,null,1,{"v":97200,"d":"97,200"},{"v":9720,"d":"9,720"},0,4,3,0.4,1,{"v":83000,"d":"83,000 "},{"v":33200,"d":"33,200"},0,{"v":42920,"d":"42,920"}]
["-----","-----","-----",null,"-----","-----","-----","-----","-----","-----",null,null,"-----","-----",null,"-----"]

{"sheet":"A1昇給シミュレー","index":4,"n_rows":17,"n_cols":10,"rows_kept":17,"flags":["formulas_cached_only"]}
[{"$nulls":4},"昇給予算ー昇級額シミュレーション"]
[]
[{"$nulls":4},"級別評価別係数入力表"]
[{"$nulls":5},"評価別係数"]
[{"$nulls":4},"　　評語","S","A","B","C","D"]
[null,"級","係数",null,"評語倍率",2,1.5,1,0.5,0]
[null,"Ⅰ",1]
[null,"Ⅱ",1.2,{"$nulls":4},"この数字をいろいろ変えてみて"]
[null,"Ⅲ",1.4,{"$nulls":4},"総昇給総額に近くなるように"]
[null,"Ⅳ",1.6,{"$nulls":4},"する。"]
[null,"Ⅴ",1.8]
[null,"Ⅵ",2,{"$nulls":3},"Ⅰ級Ｂの昇給額",null,null,9700]
[{"$nulls":9},{"v":195280,"d":"195,280 "}]
[{"$nulls":4},"与えられた予算額＝",null,{"v":200000,"d":"200,000"}]
[]
[{"$nulls":7},"必要な総昇給額"]
[{"$nulls":7},"(自動的に計算してくれた数字)"]

{"sheet":"A2昇給；区分・上限","index":5,"n_rows":23,"n_cols":12,"rows_kept":23,"merged":[[14,5,14,7],[19,5,19,7]],"flags":["formulas_cached_only"]}
[]
[null,"昇給；係数入力シート"]
[]
[null,"区分の設定",{"$nulls":3},"一般職基本給の上限",{"$nulls":4},"年齢による昇給係数"]
[]
[null,"区分の意味","区分","係数",null,"等級",null,"上限",null,null,"年齢","係数"]
[null,null,0,0,null,null,0,0,null,null,50,1]
[null,"一般職",1,1,null,"Ⅰ",1,{"v":220000,"d":"220,000"},null,null,51,0.9]
[null,"作業職",2,1,null,"Ⅱ",2,{"v":260000,"d":"260,000"},null,null,52,0.8]
[null,"パート",3,1,null,"Ⅲ",3,{"v":300000,"d":"300,000"},null,null,53,0.7]
[null,null,4,1,null,"Ⅳ",4,{"v":350000,"d":"350,000"},null,null,54,0.6]
[null,null,5,1,null,"Ⅴ",5,{"v":390000,"d":"390,000"},null,null,55,0.5]
[null,null,6,1,null,"Ⅵ",6,{"v":480000,"d":"480,000"},null,null,56,0.4]
[{"$nulls":10},57,0.3]
[{"$nulls":5},"作業職の上限",{"$nulls":4},58,0.2]
[{"$nulls":5},"Ⅰ",1,{"v":160000,"d":"160,000"},null,null,59,0.1]
[{"$nulls":5},"Ⅱ",2,{"v":200000,"d":"200,000"},null,null,60,0]
[{"$nulls":5},"Ⅲ",3,{"v":240000,"d":"240,000"}]
[]
[{"$nulls":5},"パートの時給上限"]
[{"$nulls":5},"Ⅰ",1,960]
[{"$nulls":5},"Ⅱ",2,{"v":1100,"d":"1,100"}]
[{"$nulls":5},"Ⅲ",3,{"v":1200,"d":"1,200"}]

{"sheet":"A3昇給；年齢給表","index":6,"n_rows":47,"n_cols":5,"rows_kept":47,"flags":["formulas_cached_only"]}
[]
[null,null,"年齢給表"]
[null,"年齢","年齢給","ﾋﾟｯﾁ","ベース"]
[null,0,0]
[null,18,50000,null,50000]
[null,19,56000,6000]
[null,20,61000,5000]
[null,21,65000,4000]
[null,22,68000,3000]
[null,23,70000,2000]
[null,24,71000,1000]
[null,25,71500,500]
[null,26,72000,500]
[null,27,72500,500]
[null,28,73000,500]
[null,29,73500,500]
[null,30,74000,500]
[null,31,74500,500]
[null,32,75000,500]
[null,33,75500,500]
[null,34,76000,500]
[null,35,76500,500]
[null,36,77000,500]
[null,37,77500,500]
[null,38,78000,500]
[null,39,78500,500]
[null,40,79000,500]
[null,41,79500,500]
[null,42,80000,500]
[null,43,80500,500]
[null,44,81000,500]
[null,45,81500,500]
[null,46,82000,500]
[null,47,82500,500]
[null,48,83000,500]
[null,49,83500,500]
[null,50,83500,0]
[null,51,83500,0]
[null,52,83500,0]
[null,53,83500,0]
[null,54,83500,0]
[null,55,83500,0]
[null,56,83500,0]
[null,57,83500,0]
[null,58,83500,0]
[null,59,83500,0]
[null,60,83500,0]

{"sheet":"A4昇給額表","index":7,"n_rows":13,"n_cols":8,"rows_kept":13,"flags":["formulas_cached_only"]}
[]
[{"$nulls":4},"昇給額表"]
[null,"Ⅰ級Ｂの昇給額・・・",null,9700]
[{"$nulls":5},"級別昇給額表"]
[{"$nulls":3},"S","A","B","C","D"]
[{"$nulls":3},2,1.5,1,0.5,0]
[null,"  係数","級"]
[null,1,"Ⅰ",{"v":19400,"d":"19,400 "},{"v":14550,"d":"14,550 "},{"v":9700,"d":"9,700 "},{"v":4850,"d":"4,850 "},{"v":0,"d":"0 "}]
[null,1.2,"Ⅱ",{"v":23280,"d":"23,280 "},{"v":17460,"d":"17,460 "},{"v":11640,"d":"11,640 "},{"v":5820,"d":"5,820 "},{"v":0,"d":"0 "}]
[null,1.4,"Ⅲ",{"v":27160,"d":"27,160 "},{"v":20370,"d":"20,370 "},{"v":13580,"d":"13,580 "},{"v":6790,"d":"6,790 "},{"v":0,"d":"0 "}]
[null,1.6,"Ⅳ",{"v":31040,"d":"31,040 "},{"v":23280,"d":"23,280 "},{"v":15520,"d":"15,520 "},{"v":7760,"d":"7,760 "},{"v":0,"d":"0 "}]
[null,1.8,"Ⅴ",{"v":34920,"d":"34,920 "},{"v":26190,"d":"26,190 "},{"v":17460,"d":"17,460 "},{"v":8730,"d":"8,730 "},{"v":0,"d":"0 "}]
[null,2,"Ⅵ",{"v":38800,"d":"38,800 "},{"v":29100,"d":"29,100 "},{"v":19400,"d":"19,400 "},{"v":9700,"d":"9,700 "},{"v":0,"d":"0 "}]

{"sheet":"A5評価と昇給額表","index":8,"n_rows":40,"n_cols":5,"rows_kept":40,"flags":["formulas_cached_only"]}
[null,null,"成績-昇給額テーブル"]
[]
[null,"評価","級","キー","昇給額"]
["評価がない社員",0,0,0,0]
["（Ｂとして昇給）",0,1,1,0]
[null,0,2,2,0]
[null,0,3,3,0]
[null,0,4,4,0]
[null,0,5,5,0]
[null,0,6,6,0]
["評価がＤの昇給額",1,1,11,0]
[null,1,2,12,0]
[null,1,3,13,0]
[null,1,4,14,0]
[null,1,5,15,0]
[null,1,6,16,0]
["評価がCの昇給額",2,1,21,4850]
[null,2,2,22,5820]
[null,2,3,23,6790]
[null,2,4,24,7760]
[null,2,5,25,8730]
[null,2,6,26,9700]
["評価がＢの昇給額",3,1,31,9700]
[null,3,2,32,11640]
[null,3,3,33,13580]
[null,3,4,34,15520]
[null,3,5,35,17460]
[null,3,6,36,19400]
["評価がAの昇給額",4,1,41,14550]
[null,4,2,42,17460]
[null,4,3,43,20370]
[null,4,4,44,23280]
[null,4,5,45,26190]
[null,4,6,46,29100]
["評価がSの昇給額",5,1,51,19400]
[null,5,2,52,23280]
[null,5,3,53,27160]
[null,5,4,54,31040]
[null,5,5,55,34920]
[null,5,6,56,38800]

{"sheet":"A7給与分布図","index":9,"n_rows":2,"n_cols":4,"rows_kept":2,"flags":["formulas_cached_only"]}
[]
[{"$nulls":3},"賃金分布図"]

{"sheet":"B2賞与計算入力表","index":10,"n_rows":17,"n_cols":10,"rows_kept":17,"merged":[[7,5,8,5]],"flags":["formulas_cached_only"]}
[{"$nulls":4},"賞与計算入力表"]
[]
[]
[{"$nulls":5},"評価別係数"]
[null,"級","係数",null,"　　評語","S","A","B","C","D"]
[null,"Ⅰ",1,null,"評語倍率",2,1.5,1,0.5,0]
[null,"Ⅱ",1.2]
[null,"Ⅲ",1.4,null,null,"基本賞与額=","一般社員",0.5,"ケ月分"]
[null,"Ⅳ",1.6,{"$nulls":3},"パート",0.1,"ケ月分"]
[null,"Ⅴ",1.8,{"$nulls":3},"この数字をいろいろ変えてみて"]
[null,"Ⅵ",2,{"$nulls":3},"賞与総額に近くなるように"]
[{"$nulls":6},"する。"]
[{"$nulls":7},"必要な総賞与額"]
[null,null,"Ⅰ級Ｂの賞与額",null,null,{"v":55000,"d":"55,000"},null,"自動的に計算して"]
[{"$nulls":5},{"v":1989618,"d":"1,989,618 "},null,"くれた数字"]
[]
[null,null,"賞与の総予算額",null,null,{"v":2000000,"d":"2,000,000"}]

{"sheet":"B3賞与；貢献賞与額表","index":11,"n_rows":13,"n_cols":7,"rows_kept":13,"flags":["formulas_cached_only"]}
[{"$nulls":3},"貢献賞与額表"]
[]
["Ⅰ級Ｂ評価の貢献賞与額＝",null,null,55000]
[{"$nulls":4},"級別昇給額表"]
[null,null,"S","A","B","C","D"]
[null,"係数",2,1.5,1,0.5,0]
["級"]
["Ⅰ",1,{"v":110000,"d":"110,000 "},{"v":83000,"d":"83,000 "},{"v":55000,"d":"55,000 "},{"v":28000,"d":"28,000 "},{"v":0,"d":"0 "}]
["Ⅱ",1.2,{"v":132000,"d":"132,000 "},{"v":99000,"d":"99,000 "},{"v":66000,"d":"66,000 "},{"v":33000,"d":"33,000 "},{"v":0,"d":"0 "}]
["Ⅲ",1.4,{"v":154000,"d":"154,000 "},{"v":116000,"d":"116,000 "},{"v":77000,"d":"77,000 "},{"v":39000,"d":"39,000 "},{"v":0,"d":"0 "}]
["Ⅳ",1.6,{"v":176000,"d":"176,000 "},{"v":132000,"d":"132,000 "},{"v":88000,"d":"88,000 "},{"v":44000,"d":"44,000 "},{"v":0,"d":"0 "}]
["Ⅴ",1.8,{"v":198000,"d":"198,000 "},{"v":149000,"d":"149,000 "},{"v":99000,"d":"99,000 "},{"v":50000,"d":"50,000 "},{"v":0,"d":"0 "}]
["Ⅵ",2,{"v":220000,"d":"220,000 "},{"v":165000,"d":"165,000 "},{"v":110000,"d":"110,000 "},{"v":55000,"d":"55,000 "},{"v":0,"d":"0 "}]

{"sheet":"B4賞与；役職分賞与","index":12,"n_rows":24,"n_cols":7,"rows_kept":24,"flags":["formulas_cached_only"]}
[]
[]
[null,"役職分賞与表"]
[{"$nulls":4},"区分の設定"]
[null,"役職","賞与額",null,"区分","区分の意味","係数"]
[null,"部長",{"v":100000,"d":"100,000"},null,0,null,0]
[null,"工場長",{"v":100000,"d":"100,000"},null,1,"一般職",1]
[null,"次長",{"v":80000,"d":"80,000"},null,2,"作業職",0.6]
[null,"課長",{"v":60000,"d":"60,000"},null,3,"パート",0.4]
[null,"課長代理",{"v":40000,"d":"40,000"}]
[null,"課長補佐",{"v":30000,"d":"30,000"}]
[null,"店長",{"v":40000,"d":"40,000"},null,"年齢による係数の設定"]
[null,"係長",{"v":40000,"d":"40,000"},null,"年齢","年齢係数"]
[null,"主任",{"v":30000,"d":"30,000"},null,50,1]
[null,"班長",{"v":20000,"d":"20,000"},null,51,1]
[null,"リーダー",{"v":5000,"d":"5,000"},null,52,1]
[null,null,0,null,53,0.9]
[null,null,0,null,54,0.8]
[null,null,0,null,55,0.7]
[{"$nulls":4},56,0.6]
[{"$nulls":4},57,0.6]
[{"$nulls":4},58,0.6]
[{"$nulls":4},59,0.6]
[{"$nulls":4},60,0.6]

{"sheet":"賞与；級ー評価一覧","index":13,"n_rows":40,"n_cols":5,"rows_kept":40,"flags":["formulas_cached_only"]}
[null,null,"成績-昇給額テーブル"]
[]
[null,"評価","級","キー","昇給額"]
[null,0,0,0,0]
["評価がない社員",0,1,1,{"v":0,"d":"0 "}]
["（Ｂとして昇給）",0,2,2,{"v":0,"d":"0 "}]
[null,0,3,3,{"v":0,"d":"0 "}]
[null,0,4,4,{"v":0,"d":"0 "}]
[null,0,5,5,{"v":0,"d":"0 "}]
[null,0,6,6,{"v":0,"d":"0 "}]
["評価がＤの昇給額",1,1,11,{"v":0,"d":"0 "}]
[null,1,2,12,{"v":0,"d":"0 "}]
[null,1,3,13,{"v":0,"d":"0 "}]
[null,1,4,14,{"v":0,"d":"0 "}]
[null,1,5,15,{"v":0,"d":"0 "}]
[null,1,6,16,{"v":0,"d":"0 "}]
["評価がCの昇給額",2,1,21,{"v":28000,"d":"28,000 "}]
[null,2,2,22,{"v":33000,"d":"33,000 "}]
[null,2,3,23,{"v":39000,"d":"39,000 "}]
[null,2,4,24,{"v":44000,"d":"44,000 "}]
[null,2,5,25,{"v":50000,"d":"50,000 "}]
[null,2,6,26,{"v":55000,"d":"55,000 "}]
["評価がＢの昇給額",3,1,31,{"v":55000,"d":"55,000 "}]
[null,3,2,32,{"v":66000,"d":"66,000 "}]
[null,3,3,33,{"v":77000,"d":"77,000 "}]
[null,3,4,34,{"v":88000,"d":"88,000 "}]
[null,3,5,35,{"v":99000,"d":"99,000 "}]
[null,3,6,36,{"v":110000,"d":"110,000 "}]
["評価がAの昇給額",4,1,41,{"v":83000,"d":"83,000 "}]
[null,4,2,42,{"v":99000,"d":"99,000 "}]
[null,4,3,43,{"v":116000,"d":"116,000 "}]
[null,4,4,44,{"v":132000,"d":"132,000 "}]
[null,4,5,45,{"v":149000,"d":"149,000 "}]
[null,4,6,46,{"v":165000,"d":"165,000 "}]
["評価がSの昇給額",5,1,51,{"v":110000,"d":"110,000 "}]
[null,5,2,52,{"v":132000,"d":"132,000 "}]
[null,5,3,53,{"v":154000,"d":"154,000 "}]
[null,5,4,54,{"v":176000,"d":"176,000 "}]
[null,5,5,55,{"v":198000,"d":"198,000 "}]
[null,5,6,56,{"v":220000,"d":"220,000 "}]

{"sheet":"職種等級上限一覧","index":14,"n_rows":14,"n_cols":5,"rows_kept":14,"merged":[[2,0,7,0],[8,0,10,0],[11,0,13,0]],"flags":["formulas_cached_only"]}
[]
[null,"職種","等級","職種×10+等級","上限として設定された給与"]
["一般職",1,1,11,220000]
[null,1,2,12,260000]
[null,1,3,13,300000]
[null,1,4,14,350000]
[null,1,5,15,390000]
[null,1,6,16,480000]
["作業職",2,1,21,160000]
[null,2,2,22,200000]
[null,2,3,23,240000]
["パート",3,1,31,960]
[null,3,2,32,1100]
[null,3,3,33,1200]