{"text_format":"3","workbook":"xlsx","n_sheets":3,"sheets":["給料明細書","社員マスター","使い方"],"not_rendered":{"defined_names":4,"comments":1},"read":"whole","date_system":"1900"}

{"sheet":"給料明細書","index":0,"n_rows":39,"n_cols":9,"rows_kept":39,"merged":[[3,1,3,3],[4,2,4,4],[5,1,5,3],[17,2,17,6],[19,6,19,7],[21,0,24,0],[21,6,22,8],[23,6,24,8],[26,0,29,0],[26,7,26,8],[27,7,27,8],[28,7,28,8],[29,7,29,8],[31,0,34,0],[31,7,31,8],[32,7,32,8],[33,7,33,8],[34,7,34,8],[39,0,55,8]]}
[]
[]
[]
[null,"関東商事株式会社"]
[null,{"$f":"IF(B18=\"\",\"\",B18)","v":"2020-01-25"},"給料明細書"]
[null,{"$f":"IF(G20=\"\",\"\",G20)","v":"古田　典夫"},null,null,"殿"]
[]
[null,"部門名",{"$f":"IF(C20=\"\",\"\",C20)","v":"経理"}]
[null,"社員NO",{"$f":"IF(E20=\"\",\"\",E20)","v":2}]
{"$rows_empty":8}
[null,"2020-01-25","給料明細書"]
[]
[null,"部門名","経理","社員NO",2,"氏名",{"$f":"IF(E20=\"\",\"\",IF(ISNA(VLOOKUP(E20,社員マスター,2,FALSE)),\"未登録\",VLOOKUP(E20,社員マスター,2,FALSE)))","v":"古田　典夫"},null,"殿"]
[]
["勤怠","労働日数","出勤日数","有休休暇日数","慶弔休暇日数",null,"差引支給額"]
[null,20,null,1]
[null,"欠勤日数","遅刻回数","早退回数","超勤時間",null,{"$f":"IF(AND(H30=\"\",H35=\"\"),\"\",IF(AND(H30<>\"\",H35=\"\"),H30,H30-H35))","v":{"v":278300,"d":"278,300 "}}]
[null,null,1,null,7]
[]
["支給","基本給","役職手当","資格手当","家族手当","時間外手当","通勤手当"]
[null,{"v":270000,"d":"270,000 "},{"v":20000,"d":"20,000 "},{"v":30000,"d":"30,000 "},{"v":5000,"d":"5,000 "},{"v":17000,"d":"17,000 "},{"v":16800,"d":"16,800 "}]
[{"$nulls":6},"不就労控除","総支給額"]
[{"$nulls":7},{"$f":"IF(B28=\"\",\"\",SUM(B28:H28,B30:G30))","v":{"v":358800,"d":"358,800 "}}]
[]
["控除","健康保険（介護）","健康保険（健保）","厚生年金","雇用保険","社会保険料","所得税","住民税"]
[null,{"v":4500,"d":"4,500 "},{"v":12000,"d":"12,000 "},{"v":5000,"d":"5,000 "},{"v":5000,"d":"5,000 "},{"v":12000,"d":"12,000 "},{"v":12000,"d":"12,000 "}]
[{"$nulls":5},"積立金","返済","控除計"]
[{"$nulls":5},{"v":30000,"d":"30,000 "},null,{"$f":"IF(G33=\"\",\"\",SUM(B33:H33,B35:G35))","v":{"v":80500,"d":"80,500 "}}]
[]
[]
[]
["備考"]

{"sheet":"社員マスター","index":1,"n_rows":8,"n_cols":3,"rows_kept":8,"merged":[[3,1,3,2]]}
[null,"※コードNOと社員名を入力し、セルB5からセルC15に設定したコードマスターを完成させてください。"]
[null,"コードNOは重複しないように設定してください。"]
[]
[null,"コードマスター"]
[null,"コードNO","社員名"]
[null,1,"阿部　信夫"]
[null,2,"古田　典夫"]
[null,3,"正門　恵子"]

{"sheet":"使い方","index":2,"n_rows":39,"n_cols":9,"rows_kept":39,"merged":[[3,1,3,3],[4,2,4,4],[5,1,5,3],[17,2,17,6],[19,6,19,7],[21,0,24,0],[21,6,22,8],[23,6,24,8],[26,0,29,0],[26,7,26,8],[27,7,27,8],[28,7,28,8],[29,7,29,8],[31,0,34,0],[31,7,31,8],[32,7,32,8],[33,7,33,8],[34,7,34,8],[39,0,55,8]]}
[]
[]
[]
[null,"関東商事株式会社"]
[null,{"$f":"IF(B18=\"\",\"\",B18)","v":"2020-01-25"},"給料明細書"]
[null,{"$f":"IF(G20=\"\",\"\",G20)","v":"古田　典夫"},null,null,"殿"]
[]
[null,"部門名",{"$f":"IF(C20=\"\",\"\",C20)","v":"経理"}]
[null,"社員NO",{"$f":"IF(E20=\"\",\"\",E20)","v":2}]
{"$rows_empty":8}
[null,"2020-01-25","給料明細書"]
[]
[null,"部門名","経理","社員NO",2,"氏名",{"$f":"IF(E20=\"\",\"\",IF(ISNA(VLOOKUP(E20,社員マスター,2,FALSE)),\"未登録\",VLOOKUP(E20,社員マスター,2,FALSE)))","v":"古田　典夫"},null,"殿"]
[]
["勤怠","労働日数","出勤日数","有休休暇日数","慶弔休暇日数",null,"差引支給額"]
[null,20,null,1]
[null,"欠勤日数","遅刻回数","早退回数","超勤時間",null,{"$f":"IF(AND(H30=\"\",H35=\"\"),\"\",IF(AND(H30<>\"\",H35=\"\"),H30,H30-H35))","v":{"v":278300,"d":"278,300 "}}]
[null,null,1,null,7]
[]
["支給","基本給","役職手当","資格手当","家族手当","時間外手当","通勤手当"]
[null,{"v":270000,"d":"270,000 "},{"v":20000,"d":"20,000 "},{"v":30000,"d":"30,000 "},{"v":5000,"d":"5,000 "},{"v":17000,"d":"17,000 "},{"v":16800,"d":"16,800 "}]
[{"$nulls":6},"不就労控除","総支給額"]
[{"$nulls":7},{"$f":"IF(B28=\"\",\"\",SUM(B28:H28,B30:G30))","v":{"v":358800,"d":"358,800 "}}]
[]
["控除","健康保険（介護）","健康保険（健保）","厚生年金","雇用保険","社会保険料","所得税","住民税"]
[null,{"v":4500,"d":"4,500 "},{"v":12000,"d":"12,000 "},{"v":5000,"d":"5,000 "},{"v":5000,"d":"5,000 "},{"v":12000,"d":"12,000 "},{"v":12000,"d":"12,000 "}]
[{"$nulls":5},"積立金","返済","控除計"]
[{"$nulls":5},{"v":30000,"d":"30,000 "},null,{"$f":"IF(G33=\"\",\"\",SUM(B33:H33,B35:G35))","v":{"v":80500,"d":"80,500 "}}]
[]
[]
[]
["備考"]