{"text_format":"3","workbook":"xlsx","n_sheets":3,"sheets":["従業員情報","給与計算","個人の給与明細表"],"not_rendered":{"defined_names":2},"read":"whole","date_system":"1900"}

{"sheet":"従業員情報","index":0,"n_rows":7,"n_cols":13,"rows_kept":7,"merged":[[1,0,1,12],[2,0,2,5]]}
[]
["従業員情報"]
["[会社名]"]
["従業員 ID","従業員名","時給","課税状況","連邦手当 (W-4 から)","州税","連邦所得税 \n(連邦手当に基づく割合)","社会保障税","医療税","源泉徴収税額の合計","保険控除","その他の通常控除","通常控除の合計 (税金を除く)"]
[1,"Jesper Aaberg",{"v":10,"d":"¥10.00"},1,4,{"v":0.023,"d":"2.30%"},{"v":0.28,"d":"28.00%"},{"v":0.063,"d":"6.30%"},{"v":0.0145,"d":"1.45%"},{"$f":"テーブル_1[[#This Row],[州税]]+テーブル_1[[#This Row],[連邦所得税 \n(連邦手当に基づく割合)]]+テーブル_1[[#This Row],[社会保障税]]+テーブル_1[[#This Row],[医療税]]","v":{"v":0.38050000000000006,"d":"38.05%"}},{"v":20,"d":"¥20.00"},{"v":40,"d":"¥40.00"},{"$f":"テーブル_1[[#This Row],[保険控除]]+テーブル_1[[#This Row],[その他の通常控除]]","v":{"v":60,"d":"¥60.00"}}]
[2,"Wilson Pais",{"v":13,"d":"¥13.00"},1,4,{"v":0.023,"d":"2.30%"},{"v":0.28,"d":"28.00%"},{"v":0.063,"d":"6.30%"},{"v":0.0145,"d":"1.45%"},{"$f":"テーブル_1[[#This Row],[州税]]+テーブル_1[[#This Row],[連邦所得税 \n(連邦手当に基づく割合)]]+テーブル_1[[#This Row],[社会保障税]]+テーブル_1[[#This Row],[医療税]]","v":{"v":0.38050000000000006,"d":"38.05%"}},{"v":20,"d":"¥20.00"},{"v":52,"d":"¥52.00"},{"$f":"テーブル_1[[#This Row],[保険控除]]+テーブル_1[[#This Row],[その他の通常控除]]","v":{"v":72,"d":"¥72.00"}}]
[3,"Kathie Flood",{"v":10,"d":"¥10.00"},1,4,{"v":0.023,"d":"2.30%"},{"v":0.28,"d":"28.00%"},{"v":0.063,"d":"6.30%"},{"v":0.0145,"d":"1.45%"},{"$f":"テーブル_1[[#This Row],[州税]]+テーブル_1[[#This Row],[連邦所得税 \n(連邦手当に基づく割合)]]+テーブル_1[[#This Row],[社会保障税]]+テーブル_1[[#This Row],[医療税]]","v":{"v":0.38050000000000006,"d":"38.05%"}},{"v":20,"d":"¥20.00"},0,{"$f":"テーブル_1[[#This Row],[保険控除]]+テーブル_1[[#This Row],[その他の通常控除]]","v":{"v":20,"d":"¥20.00"}}]

{"sheet":"給与計算","index":1,"n_rows":7,"n_cols":11,"rows_kept":7,"merged":[[0,0,1,8],[2,0,2,5]]}
["給与計算"]
[{"$nulls":9},"期間の終了日:",{"v":45688,"d":"4568800.00%"}]
[{"$f":"従業員情報!$A$3","v":"[会社名]"}]
["従業員 ID","従業員名","所定労働時間内の\n勤務時間","休暇時間","病欠時間","時間外労働時間","残業手当","総支給額","税金および控除 ","その他の控除","正味支給額"]
[1,{"$f":"VLOOKUP(A5,テーブル_1[],2,FALSE)","v":"Jesper Aaberg"},{"v":50,"d":"50.00"},{"v":5,"d":"5.00"},{"v":1,"d":"1.00"},null,null,{"$f":"(VLOOKUP(A5,テーブル_1[],3,FALSE)*(テーブル_2[[#This Row],[所定労働時間内の\n勤務時間]]+テーブル_2[[#This Row],[休暇時間]]+テーブル_2[[#This Row],[病欠時間]])+テーブル_2[[#This Row],[時間外労働時間]]*テーブル_2[[#This Row],[残業手当]])","v":{"v":560,"d":"¥560.00"}},{"$f":"VLOOKUP(A5,テーブル_1[],10,FALSE)*テーブル_2[[#This Row],[総支給額]]+テーブル_1[[#This Row],[通常控除の合計 (税金を除く)]]","v":{"v":273.08000000000004,"d":"¥273.08"}},{"v":20,"d":"¥20.00"},{"$f":"テーブル_2[[#This Row],[総支給額]]-テーブル_2[[#This Row],[税金および控除 ]]-テーブル_2[[#This Row],[その他の控除]]","v":{"v":266.91999999999996,"d":"¥266.92"}}]
[2,{"$f":"VLOOKUP(A6,テーブル_1[],2,FALSE)","v":"Wilson Pais"},{"v":40,"d":"40.00"},{"v":0,"d":"0.00"},{"v":0,"d":"0.00"},null,null,{"$f":"(VLOOKUP(A6,テーブル_1[],3,FALSE)*(テーブル_2[[#This Row],[所定労働時間内の\n勤務時間]]+テーブル_2[[#This Row],[休暇時間]]+テーブル_2[[#This Row],[病欠時間]])+テーブル_2[[#This Row],[時間外労働時間]]*テーブル_2[[#This Row],[残業手当]])","v":{"v":520,"d":"¥520.00"}},{"$f":"VLOOKUP(A6,テーブル_1[],10,FALSE)*テーブル_2[[#This Row],[総支給額]]+テーブル_1[[#This Row],[通常控除の合計 (税金を除く)]]","v":{"v":269.86,"d":"¥269.86"}},{"v":52,"d":"¥52.00"},{"$f":"テーブル_2[[#This Row],[総支給額]]-テーブル_2[[#This Row],[税金および控除 ]]-テーブル_2[[#This Row],[その他の控除]]","v":{"v":198.14,"d":"¥198.14"}}]
[3,{"$f":"VLOOKUP(A7,テーブル_1[],2,FALSE)","v":"Kathie Flood"},{"v":52,"d":"52.00"},{"v":0,"d":"0.00"},{"v":0,"d":"0.00"},{"v":2,"d":"2.00"},{"v":20,"d":"¥20.00"},{"$f":"(VLOOKUP(A7,テーブル_1[],3,FALSE)*(テーブル_2[[#This Row],[所定労働時間内の\n勤務時間]]+テーブル_2[[#This Row],[休暇時間]]+テーブル_2[[#This Row],[病欠時間]])+テーブル_2[[#This Row],[時間外労働時間]]*テーブル_2[[#This Row],[残業手当]])","v":{"v":560,"d":"¥560.00"}},{"$f":"VLOOKUP(A7,テーブル_1[],10,FALSE)*テーブル_2[[#This Row],[総支給額]]+テーブル_1[[#This Row],[通常控除の合計 (税金を除く)]]","v":{"v":233.08000000000004,"d":"¥233.08"}},{"v":20,"d":"¥20.00"},{"$f":"テーブル_2[[#This Row],[総支給額]]-テーブル_2[[#This Row],[税金および控除 ]]-テーブル_2[[#This Row],[その他の控除]]","v":{"v":306.91999999999996,"d":"¥306.92"}}]

{"sheet":"個人の給与明細表","index":2,"n_rows":48,"n_cols":8,"rows_kept":48,"merged":[[1,2,1,7],[13,2,13,7],[25,2,25,7],[38,2,38,7]]}
[]
[null,null,{"$f":"(従業員情報!$A$3)","v":"[会社名]"}]
[null,null,"期間:",{"$f":"給与計算!$K$2","v":{"v":45688,"d":"4568800.00%"}},"従業員名",{"$f":"IFERROR(VLOOKUP(H3,テーブル_1[],2),\"\")","v":"Jesper Aaberg"},"従業員 ID",1]
[]
[null,null,"課税状況",{"$f":"IFERROR(VLOOKUP(H3,テーブル_1[],4),\"\")","v":1},"連邦手当 (W-4 から)",{"$f":"IFERROR(VLOOKUP(H3,テーブル_1[],5,FALSE),\"\")","v":4},"勤務時間",{"$f":"IFERROR(VLOOKUP(H3,テーブル_2[],3,FALSE),\"\")","v":50}]
[null,null,"時給",{"$f":"IFERROR(VLOOKUP(H3,テーブル_1[],3,FALSE),\"\")","v":{"v":10,"d":"¥10.00"}},"残業手当",{"$f":"IFERROR(VLOOKUP(H3,テーブル_2[],7,FALSE),\"\")","v":0},"病欠時間",{"$f":"IFERROR(VLOOKUP(H3,テーブル_2[],5,FALSE),\"\")","v":1}]
[null,null,"社会保障税",{"$f":"IFERROR(IFERROR(VLOOKUP(H3,テーブル_1[],8,FALSE),\"\")*H9,\"\")","v":{"v":35.28,"d":"¥35.28"}},"連邦法人税 ",{"$f":"IFERROR(IFERROR(VLOOKUP(H3,テーブル_1[],7,FALSE),\"\")*H9,\"\")","v":{"v":156.8,"d":"¥156.80"}},"休暇時間",{"$f":"IFERROR(VLOOKUP(H3,テーブル_2[],4,FALSE),\"\")","v":5}]
[null,null,"医療税 ",{"$f":"IFERROR(IFERROR(VLOOKUP(H3,テーブル_1[],9,FALSE),\"\")*H9,\"\")","v":{"v":8.120000000000001,"d":"¥8.12"}},"州税 ",{"$f":"IFERROR(IFERROR(VLOOKUP(H3,テーブル_1[],6,FALSE),\"\")*H9,\"\")","v":{"v":12.879999999999999,"d":"¥12.88"}},"残業時間",{"$f":"IFERROR(VLOOKUP(H3,テーブル_2[],6,FALSE),\"\")","v":0}]
[null,null,"保険控除",{"$f":"IFERROR(VLOOKUP(H3,テーブル_1[],11,FALSE),\"\")","v":{"v":20,"d":"¥20.00"}},"その他の通常控除",{"$f":"IFERROR(VLOOKUP(H3,テーブル_1[],12,FALSE),\"\")","v":{"v":40,"d":"¥40.00"}},"総支払",{"$f":"IFERROR(VLOOKUP(H3,テーブル_2[],8,FALSE),\"\")","v":{"v":560,"d":"¥560.00"}}]
[null,null,"税合計と通常控除 ",{"$f":"IFERROR(SUM(F7:F9)+SUM(D7:D9),\"\")","v":{"v":273.08000000000004,"d":"¥273.08"}},"その他の控除",{"$f":"IFERROR(VLOOKUP(H3,テーブル_2[],10,FALSE),\"\")","v":{"v":20,"d":"¥20.00"}},"税合計および控除 ",{"$f":"IFERROR(IFERROR(VLOOKUP(H3,テーブル_2[],9,FALSE),\"\")+F10,\"\")","v":{"v":293.08000000000004,"d":"¥293.08"}}]
[{"$nulls":6},"正味支払",{"$f":"IFERROR(VLOOKUP(H3,テーブル_2[],11,FALSE),\"\")","v":{"v":266.91999999999996,"d":"¥266.92"}}]
[]
[]
[null,null,{"$f":"(従業員情報!$A$3)","v":"[会社名]"}]
[null,null,"期間:",{"$f":"給与計算!$K$2","v":{"v":45688,"d":"4568800.00%"}},"従業員名",{"$f":"IFERROR(VLOOKUP(H15,テーブル_1[],2),\"\")","v":"Wilson Pais"},"従業員 ID",2]
[]
[null,null,"課税状況",{"$f":"IFERROR(VLOOKUP(H15,テーブル_1[],4),\"\")","v":1},"連邦手当 (W-4 から)",{"$f":"IFERROR(VLOOKUP(H15,テーブル_1[],5,FALSE),\"\")","v":4},"勤務時間",{"$f":"IFERROR(VLOOKUP(H15,テーブル_2[],3,FALSE),\"\")","v":40}]
[null,null,"時給",{"$f":"IFERROR(VLOOKUP(H15,テーブル_1[],3,FALSE),\"\")","v":{"v":13,"d":"¥13.00"}},"残業手当",{"$f":"IFERROR(VLOOKUP(H15,テーブル_2[],7,FALSE),\"\")","v":0},"病欠時間",{"$f":"IFERROR(VLOOKUP(H15,テーブル_2[],5,FALSE),\"\")","v":0}]
[null,null,"社会保障税",{"$f":"IFERROR(IFERROR(VLOOKUP(H15,テーブル_1[],8,FALSE),\"\")*H21,\"\")","v":{"v":32.76,"d":"¥32.76"}},"連邦法人税 ",{"$f":"IFERROR(IFERROR(VLOOKUP(H15,テーブル_1[],7,FALSE),\"\")*H21,\"\")","v":{"v":145.60000000000002,"d":"¥145.60"}},"休暇時間",{"$f":"IFERROR(VLOOKUP(H15,テーブル_2[],4,FALSE),\"\")","v":0}]
[null,null,"医療税 ",{"$f":"IFERROR(IFERROR(VLOOKUP(H15,テーブル_1[],9,FALSE),\"\")*H21,\"\")","v":{"v":7.54,"d":"¥7.54"}},"州税 ",{"$f":"IFERROR(IFERROR(VLOOKUP(H15,テーブル_1[],6,FALSE),\"\")*H21,\"\")","v":{"v":11.959999999999999,"d":"¥11.96"}},"残業時間",{"$f":"IFERROR(VLOOKUP(H15,テーブル_2[],6,FALSE),\"\")","v":0}]
[null,null,"保険控除",{"$f":"IFERROR(VLOOKUP(H15,テーブル_1[],11,FALSE),\"\")","v":{"v":20,"d":"¥20.00"}},"その他の通常控除",{"$f":"IFERROR(VLOOKUP(H15,テーブル_1[],12,FALSE),\"\")","v":{"v":52,"d":"¥52.00"}},"総支払",{"$f":"IFERROR(VLOOKUP(H15,テーブル_2[],8,FALSE),\"\")","v":{"v":520,"d":"¥520.00"}}]
[null,null,"税合計と通常控除 ",{"$f":"IFERROR(SUM(F19:F21)+SUM(D19:D21),\"\")","v":{"v":269.86,"d":"¥269.86"}},"その他の控除",{"$f":"IFERROR(VLOOKUP(H15,テーブル_2[],10,FALSE),\"\")","v":{"v":52,"d":"¥52.00"}},"税合計および控除 ",{"$f":"IFERROR(IFERROR(VLOOKUP(H15,テーブル_2[],9,FALSE),\"\")+F22,\"\")","v":{"v":321.86,"d":"¥321.86"}}]
[{"$nulls":6},"正味支払",{"$f":"IFERROR(VLOOKUP(H15,テーブル_2[],11,FALSE),\"\")","v":{"v":198.14,"d":"¥198.14"}}]
[]
[]
[null,null,{"$f":"(従業員情報!$A$3)","v":"[会社名]"}]
[null,null,"期間:",{"$f":"給与計算!$K$2","v":{"v":45688,"d":"4568800.00%"}},"従業員名",{"$f":"IFERROR(VLOOKUP(H27,テーブル_1[],2),\"\")","v":"Kathie Flood"},"従業員 ID",3]
[]
[null,null,"課税状況",{"$f":"IFERROR(VLOOKUP(H27,テーブル_1[],4),\"\")","v":1},"連邦手当 (W-4 から)",{"$f":"IFERROR(VLOOKUP(H27,テーブル_1[],5,FALSE),\"\")","v":4},"勤務時間",{"$f":"IFERROR(VLOOKUP(H27,テーブル_2[],3,FALSE),\"\")","v":52}]
[null,null,"時給",{"$f":"IFERROR(VLOOKUP(H27,テーブル_1[],3,FALSE),\"\")","v":{"v":10,"d":"¥10.00"}},"残業手当",{"$f":"IFERROR(VLOOKUP(H27,テーブル_2[],7,FALSE),\"\")","v":{"v":20,"d":"¥20.00"}},"病欠時間",{"$f":"IFERROR(VLOOKUP(H27,テーブル_2[],5,FALSE),\"\")","v":0}]
[null,null,"社会保障税",{"$f":"IFERROR(IFERROR(VLOOKUP(H27,テーブル_1[],8,FALSE),\"\")*H33,\"\")","v":{"v":35.28,"d":"¥35.28"}},"連邦法人税 ",{"$f":"IFERROR(IFERROR(VLOOKUP(H27,テーブル_1[],7,FALSE),\"\")*H33,\"\")","v":{"v":156.8,"d":"¥156.80"}},"休暇時間",{"$f":"IFERROR(VLOOKUP(H27,テーブル_2[],4,FALSE),\"\")","v":0}]
[null,null,"医療税 ",{"$f":"IFERROR(IFERROR(VLOOKUP(H27,テーブル_1[],9,FALSE),\"\")*H33,\"\")","v":{"v":8.120000000000001,"d":"¥8.12"}},"州税 ",{"$f":"IFERROR(IFERROR(VLOOKUP(H27,テーブル_1[],6,FALSE),\"\")*H33,\"\")","v":{"v":12.879999999999999,"d":"¥12.88"}},"残業時間",{"$f":"IFERROR(VLOOKUP(H27,テーブル_2[],6,FALSE),\"\")","v":2}]
[null,null,"保険控除",{"$f":"IFERROR(VLOOKUP(H27,テーブル_1[],11,FALSE),\"\")","v":{"v":20,"d":"¥20.00"}},"その他の通常控除",{"$f":"IFERROR(VLOOKUP(H27,テーブル_1[],12,FALSE),\"\")","v":0},"総支払",{"$f":"IFERROR(VLOOKUP(H27,テーブル_2[],8,FALSE),\"\")","v":{"v":560,"d":"¥560.00"}}]
[null,null,"税合計と通常控除 ",{"$f":"IFERROR(SUM(F31:F33)+SUM(D31:D33),\"\")","v":{"v":233.08,"d":"¥233.08"}},"その他の控除",{"$f":"IFERROR(VLOOKUP(H27,テーブル_2[],10,FALSE),\"\")","v":{"v":20,"d":"¥20.00"}},"税合計および控除 ",{"$f":"IFERROR(IFERROR(VLOOKUP(H27,テーブル_2[],9,FALSE),\"\")+F34,\"\")","v":{"v":253.08000000000004,"d":"¥253.08"}}]
[{"$nulls":6},"正味支払",{"$f":"IFERROR(VLOOKUP(H27,テーブル_2[],11,FALSE),\"\")","v":{"v":306.91999999999996,"d":"¥306.92"}}]
[]
[]
[]
[null,null,{"$f":"(従業員情報!$A$3)","v":"[会社名]"}]
[null,null,"期間:",{"$f":"給与計算!$K$2","v":{"v":45688,"d":"4568800.00%"}},"従業員名",{"$f":"IFERROR(VLOOKUP(H40,テーブル_1[],2),\"\")","v":""},"従業員 ID"]
[]
[null,null,"課税状況",{"$f":"IFERROR(VLOOKUP(H40,テーブル_1[],4),\"\")","v":""},"連邦手当 (W-4 から)",{"$f":"IFERROR(VLOOKUP(H40,テーブル_1[],5,FALSE),\"\")","v":""},"勤務時間",{"$f":"IFERROR(VLOOKUP(H40,テーブル_2[],3,FALSE),\"\")","v":""}]
[null,null,"時給",{"$f":"IFERROR(VLOOKUP(H40,テーブル_1[],3,FALSE),\"\")","v":""},"残業手当",{"$f":"IFERROR(VLOOKUP(H40,テーブル_2[],7,FALSE),\"\")","v":""},"病欠時間",{"$f":"IFERROR(VLOOKUP(H40,テーブル_2[],5,FALSE),\"\")","v":""}]
[null,null,"社会保障税",{"$f":"IFERROR(IFERROR(VLOOKUP(H40,テーブル_1[],8,FALSE),\"\")*H46,\"\")","v":""},"連邦法人税 ",{"$f":"IFERROR(IFERROR(VLOOKUP(H40,テーブル_1[],7,FALSE),\"\")*H46,\"\")","v":""},"休暇時間",{"$f":"IFERROR(VLOOKUP(H40,テーブル_2[],4,FALSE),\"\")","v":""}]
[null,null,"医療税 ",{"$f":"IFERROR(IFERROR(VLOOKUP(H40,テーブル_1[],9,FALSE),\"\")*H46,\"\")","v":""},"州税 ",{"$f":"IFERROR(IFERROR(VLOOKUP(H40,テーブル_1[],6,FALSE),\"\")*H46,\"\")","v":""},"残業時間",{"$f":"IFERROR(VLOOKUP(H40,テーブル_2[],6,FALSE),\"\")","v":""}]
[null,null,"保険控除",{"$f":"IFERROR(VLOOKUP(H40,テーブル_1[],11,FALSE),\"\")","v":""},"その他の通常控除",{"$f":"IFERROR(VLOOKUP(H40,テーブル_1[],12,FALSE),\"\")","v":""},"総支払",{"$f":"IFERROR(VLOOKUP(H40,テーブル_2[],8,FALSE),\"\")","v":""}]
[null,null,"税合計と通常控除 ",{"$f":"IFERROR(SUM(F44:F46)+SUM(D44:D46),\"\")","v":0},"その他の控除",{"$f":"IFERROR(VLOOKUP(H40,テーブル_2[],10,FALSE),\"\")","v":""},"税合計および控除 ",{"$f":"IFERROR(IFERROR(VLOOKUP(H40,テーブル_2[],9,FALSE),\"\")+F47,\"\")","v":""}]
[{"$nulls":6},"正味支払",{"$f":"IFERROR(VLOOKUP(H40,テーブル_2[],11,FALSE),\"\")","v":""}]