{"text_format":"3","workbook":"xlsx","n_sheets":3,"sheets":["賞与明細書","社員マスター","使いかた"],"not_rendered":{"defined_names":3,"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,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":1}]
{"$rows_empty":8}
[null,"2020-01-25","賞与明細書"]
[]
[null,"部門名","経理","社員NO",1,"氏名",{"$f":"IF(E20=\"\",\"\",IF(ISNA(VLOOKUP(E20,社員マスター!$B$5:$C$25,2,FALSE)),\"未登録\",VLOOKUP(E20,社員マスター!$B$5:$C$25,2,FALSE)))","v":"阿部　信夫"},null,"殿"]
[]
[{"$nulls":6},"差引支給額"]
[]
[{"$nulls":6},{"$f":"IF(AND(H30=\"\",H35=\"\"),\"\",IF(AND(H30<>\"\",H35=\"\"),H30,H30-H35))","v":{"v":315000,"d":"315,000 "}}]
[]
[]
["支給","賞与額"]
[null,{"v":350000,"d":"350,000 "}]
[{"$nulls":7},"総支給額"]
[{"$nulls":7},{"$f":"IF(B28=\"\",\"\",SUM(B28:H28,B30:G30))","v":{"v":350000,"d":"350,000 "}}]
[]
["控除","健康保険（介護）","健康保険（健保）","厚生年金","雇用保険","社会保険料","所得税","住民税"]
[{"$nulls":6},{"v":35000,"d":"35,000 "}]
[{"$nulls":5},"積立金","返済","控除計"]
[{"$nulls":7},{"$f":"IF(G33=\"\",\"\",SUM(B33:H33,B35:G35))","v":{"v":35000,"d":"35,000 "}}]
[]
[]
[]
["備考"]

{"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,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":"G20","v":"阿部　信夫"},null,null,"殿"]
[]
[null,"部門名",{"$f":"IF(C20=\"\",\"\",C20)","v":"経理"}]
[null,"社員NO",{"$f":"IF(E20=\"\",\"\",E20)","v":1}]
{"$rows_empty":8}
[null,"2020-01-25","賞与明細書"]
[]
[null,"部門名","経理","社員NO",1,"氏名",{"$f":"IF(E20=\"\",\"\",IF(ISNA(VLOOKUP(E20,社員マスター!$B$5:$C$25,2,FALSE)),\"未登録\",VLOOKUP(E20,社員マスター!$B$5:$C$25,2,FALSE)))","v":"阿部　信夫"},null,"殿"]
[]
[{"$nulls":6},"差引支給額"]
[]
[{"$nulls":6},{"$f":"IF(B28=\"\",\"\",H30-H35)","v":{"v":315000,"d":"315,000 "}}]
[]
[]
["支給","賞与額"]
[null,{"v":350000,"d":"350,000 "}]
[{"$nulls":7},"総支給額"]
[{"$nulls":7},{"$f":"IF(B28=\"\",\"\",SUM(B28:H28,B30:G30))","v":{"v":350000,"d":"350,000 "}}]
[]
["控除","健康保険（介護）","健康保険（健保）","厚生年金","雇用保険","社会保険料","所得税","住民税"]
[{"$nulls":6},{"v":35000,"d":"35,000 "}]
[{"$nulls":5},"積立金","返済","控除計"]
[{"$nulls":7},{"$f":"IF(G33=\"\",\"\",SUM(B33:H33,B35:G35))","v":{"v":35000,"d":"35,000 "}}]
[]
[]
[]
["備考"]