{"text_format":"1","workbook":"xlsx","n_sheets":2,"sheets":["Input Payroll","stubs_template"],"not_rendered":{"charts":0,"images":0,"macros":1,"external_links":0,"defined_names":7,"comments":0,"pivot_tables":0},"unopened":[],"bounds":{"document_bytes":16777216,"sheet_cells":100000,"rows_first":2000,"rows_last":500,"rows_between":2000,"halvings":0,"cell_chars":16384,"cell_head_chars":4096},"cells_cut":0,"cells_raw":0,"read":"whole","date_system":"1900"}

{"sheet":"Input Payroll","index":0,"n_rows":13,"n_cols":24,"rows_kept":13,"cut":false,"hidden":false,"merged":[[0,13,0,14]]}
[null,"KALKULATOR GAJI",null,null,null,null,null,null,null,null,"AKHIR PERIODE:",41372,null,"NAMA PERUSAHAAN:",null,"ADVENTURE WORKS"]
[]
[null,"ID","Nama Karyawan","Jam Kerja Rutin","Jam Liburan","Jam Sakit","Jam Lembur","Tarif Lembur","Gaji Kotor","Pajak dan Potongan","Potongan Lain","Gaji Bersih"," ","Upah per Jam","Status Pajak","Tunjangan Negara","Pajak Negara","Pajak Penghasilan","Pajak Jaminan Sosial","Pajak Asuransi Sosial","Total Pajak Berjalan","Potongan Asuransi","Potongan Rutin Lainnya","Total Potongan Rutin"]
[null,1001,"Tony Smith",50,5,1,null,null,{"$f":"SUM(Employees[[#This Row],[Jam Kerja Rutin]:[Jam Sakit]])*Employees[[#This Row],[Upah per Jam]]+Employees[[#This Row],[Jam Lembur]]*Employees[[#This Row],[Tarif Lembur]]","v":560},{"$f":"Employees[[#This Row],[Gaji Kotor]]*Employees[[#This Row],[Total Pajak Berjalan]] + Employees[[#This Row],[Total Potongan Rutin]]","v":273.08000000000004},20,{"$f":"Employees[[#This Row],[Gaji Kotor]]-Employees[[#This Row],[Pajak dan Potongan]]-Employees[[#This Row],[Potongan Lain]]","v":266.91999999999996},null,10,1,4,2.3E-2,0.28000000000000003,6.3E-2,1.4500000000000001E-2,{"$f":"SUM(Employees[[#This Row],[Pajak Negara]:[Pajak Asuransi Sosial]])","v":0.38050000000000006},20,40,{"$f":"SUM(Employees[[#This Row],[Potongan Asuransi]:[Potongan Rutin Lainnya]])","v":60}]
[null,1002,"David Jones",40,null,null,null,null,{"$f":"SUM(Employees[[#This Row],[Jam Kerja Rutin]:[Jam Sakit]])*Employees[[#This Row],[Upah per Jam]]+Employees[[#This Row],[Jam Lembur]]*Employees[[#This Row],[Tarif Lembur]]","v":320},{"$f":"Employees[[#This Row],[Gaji Kotor]]*Employees[[#This Row],[Total Pajak Berjalan]] + Employees[[#This Row],[Total Potongan Rutin]]","v":131.76000000000002},null,{"$f":"Employees[[#This Row],[Gaji Kotor]]-Employees[[#This Row],[Pajak dan Potongan]]-Employees[[#This Row],[Potongan Lain]]","v":188.23999999999998},null,8,1,1,2.3E-2,0.28000000000000003,6.3E-2,1.4500000000000001E-2,{"$f":"SUM(Employees[[#This Row],[Pajak Negara]:[Pajak Asuransi Sosial]])","v":0.38050000000000006},0,10,{"$f":"SUM(Employees[[#This Row],[Potongan Asuransi]:[Potongan Rutin Lainnya]])","v":10}]
[null,1003,"Denise Smith",35,3,null,null,null,{"$f":"SUM(Employees[[#This Row],[Jam Kerja Rutin]:[Jam Sakit]])*Employees[[#This Row],[Upah per Jam]]+Employees[[#This Row],[Jam Lembur]]*Employees[[#This Row],[Tarif Lembur]]","v":532},{"$f":"Employees[[#This Row],[Gaji Kotor]]*Employees[[#This Row],[Total Pajak Berjalan]] + Employees[[#This Row],[Total Potongan Rutin]]","v":240.42600000000004},null,{"$f":"Employees[[#This Row],[Gaji Kotor]]-Employees[[#This Row],[Pajak dan Potongan]]-Employees[[#This Row],[Potongan Lain]]","v":291.57399999999996},null,14,1,3,2.3E-2,0.28000000000000003,6.3E-2,1.4500000000000001E-2,{"$f":"SUM(Employees[[#This Row],[Pajak Negara]:[Pajak Asuransi Sosial]])","v":0.38050000000000006},18,20,{"$f":"SUM(Employees[[#This Row],[Potongan Asuransi]:[Potongan Rutin Lainnya]])","v":38}]
[null,1008,"Sebastien Motte",50,5,1,null,null,{"$f":"SUM(Employees[[#This Row],[Jam Kerja Rutin]:[Jam Sakit]])*Employees[[#This Row],[Upah per Jam]]+Employees[[#This Row],[Jam Lembur]]*Employees[[#This Row],[Tarif Lembur]]","v":1120},{"$f":"Employees[[#This Row],[Gaji Kotor]]*Employees[[#This Row],[Total Pajak Berjalan]] + Employees[[#This Row],[Total Potongan Rutin]]","v":441.16000000000008},null,{"$f":"Employees[[#This Row],[Gaji Kotor]]-Employees[[#This Row],[Pajak dan Potongan]]-Employees[[#This Row],[Potongan Lain]]","v":678.83999999999992},null,20,1,0,2.3E-2,0.28000000000000003,6.3E-2,1.4500000000000001E-2,{"$f":"SUM(Employees[[#This Row],[Pajak Negara]:[Pajak Asuransi Sosial]])","v":0.38050000000000006},15,null,{"$f":"SUM(Employees[[#This Row],[Potongan Asuransi]:[Potongan Rutin Lainnya]])","v":15}]
[null,1011,"Isabelle Scemla",40,null,null,2,15,{"$f":"SUM(Employees[[#This Row],[Jam Kerja Rutin]:[Jam Sakit]])*Employees[[#This Row],[Upah per Jam]]+Employees[[#This Row],[Jam Lembur]]*Employees[[#This Row],[Tarif Lembur]]","v":430},{"$f":"Employees[[#This Row],[Gaji Kotor]]*Employees[[#This Row],[Total Pajak Berjalan]] + Employees[[#This Row],[Total Potongan Rutin]]","v":223.61500000000004},null,{"$f":"Employees[[#This Row],[Gaji Kotor]]-Employees[[#This Row],[Pajak dan Potongan]]-Employees[[#This Row],[Potongan Lain]]","v":206.38499999999996},null,10,1,0,2.3E-2,0.28000000000000003,6.3E-2,1.4500000000000001E-2,{"$f":"SUM(Employees[[#This Row],[Pajak Negara]:[Pajak Asuransi Sosial]])","v":0.38050000000000006},20,40,{"$f":"SUM(Employees[[#This Row],[Potongan Asuransi]:[Potongan Rutin Lainnya]])","v":60}]
[null,1012,"David Bristol",40,5,1,null,null,{"$f":"SUM(Employees[[#This Row],[Jam Kerja Rutin]:[Jam Sakit]])*Employees[[#This Row],[Upah per Jam]]+Employees[[#This Row],[Jam Lembur]]*Employees[[#This Row],[Tarif Lembur]]","v":552},{"$f":"Employees[[#This Row],[Gaji Kotor]]*Employees[[#This Row],[Total Pajak Berjalan]] + Employees[[#This Row],[Total Potongan Rutin]]","v":270.03600000000006},null,{"$f":"Employees[[#This Row],[Gaji Kotor]]-Employees[[#This Row],[Pajak dan Potongan]]-Employees[[#This Row],[Potongan Lain]]","v":281.96399999999994},null,12,1,4,2.3E-2,0.28000000000000003,6.3E-2,1.4500000000000001E-2,{"$f":"SUM(Employees[[#This Row],[Pajak Negara]:[Pajak Asuransi Sosial]])","v":0.38050000000000006},20,40,{"$f":"SUM(Employees[[#This Row],[Potongan Asuransi]:[Potongan Rutin Lainnya]])","v":60}]
[null,1025,"Anne Weiler",36,null,2,1,18,{"$f":"SUM(Employees[[#This Row],[Jam Kerja Rutin]:[Jam Sakit]])*Employees[[#This Row],[Upah per Jam]]+Employees[[#This Row],[Jam Lembur]]*Employees[[#This Row],[Tarif Lembur]]","v":474},{"$f":"Employees[[#This Row],[Gaji Kotor]]*Employees[[#This Row],[Total Pajak Berjalan]] + Employees[[#This Row],[Total Potongan Rutin]]","v":225.35700000000003},25,{"$f":"Employees[[#This Row],[Gaji Kotor]]-Employees[[#This Row],[Pajak dan Potongan]]-Employees[[#This Row],[Potongan Lain]]","v":223.64299999999997},null,12,1,2,2.3E-2,0.28000000000000003,6.3E-2,1.4500000000000001E-2,{"$f":"SUM(Employees[[#This Row],[Pajak Negara]:[Pajak Asuransi Sosial]])","v":0.38050000000000006},25,20,{"$f":"SUM(Employees[[#This Row],[Potongan Asuransi]:[Potongan Rutin Lainnya]])","v":45}]
[null,1032,"Luka Abrus",40,5,1,null,null,{"$f":"SUM(Employees[[#This Row],[Jam Kerja Rutin]:[Jam Sakit]])*Employees[[#This Row],[Upah per Jam]]+Employees[[#This Row],[Jam Lembur]]*Employees[[#This Row],[Tarif Lembur]]","v":460},{"$f":"Employees[[#This Row],[Gaji Kotor]]*Employees[[#This Row],[Total Pajak Berjalan]] + Employees[[#This Row],[Total Potongan Rutin]]","v":175.03000000000003},50,{"$f":"Employees[[#This Row],[Gaji Kotor]]-Employees[[#This Row],[Pajak dan Potongan]]-Employees[[#This Row],[Potongan Lain]]","v":234.96999999999997},null,10,1,3,2.3E-2,0.28000000000000003,6.3E-2,1.4500000000000001E-2,{"$f":"SUM(Employees[[#This Row],[Pajak Negara]:[Pajak Asuransi Sosial]])","v":0.38050000000000006},null,null,{"$f":"SUM(Employees[[#This Row],[Potongan Asuransi]:[Potongan Rutin Lainnya]])","v":0}]
[null,1049,"David Ludwig",40,1,null,null,null,{"$f":"SUM(Employees[[#This Row],[Jam Kerja Rutin]:[Jam Sakit]])*Employees[[#This Row],[Upah per Jam]]+Employees[[#This Row],[Jam Lembur]]*Employees[[#This Row],[Tarif Lembur]]","v":615},{"$f":"Employees[[#This Row],[Gaji Kotor]]*Employees[[#This Row],[Total Pajak Berjalan]] + Employees[[#This Row],[Total Potongan Rutin]]","v":259.00750000000005},23,{"$f":"Employees[[#This Row],[Gaji Kotor]]-Employees[[#This Row],[Pajak dan Potongan]]-Employees[[#This Row],[Potongan Lain]]","v":332.99249999999995},null,15,1,2,2.3E-2,0.28000000000000003,6.3E-2,1.4500000000000001E-2,{"$f":"SUM(Employees[[#This Row],[Pajak Negara]:[Pajak Asuransi Sosial]])","v":0.38050000000000006},25,null,{"$f":"SUM(Employees[[#This Row],[Potongan Asuransi]:[Potongan Rutin Lainnya]])","v":25}]
[null,"Total",{"$f":"SUBTOTAL(103,Employees[Nama Karyawan])","v":9},{"$f":"SUBTOTAL(109,Employees[Jam Kerja Rutin])","v":371},{"$f":"SUBTOTAL(109,Employees[Jam Liburan])","v":24},{"$f":"SUBTOTAL(109,Employees[Jam Sakit])","v":6},{"$f":"SUBTOTAL(109,Employees[Jam Lembur])","v":3},null,{"$f":"SUBTOTAL(109,Employees[Gaji Kotor])","v":5063},{"$f":"SUBTOTAL(109,Employees[Pajak dan Potongan])","v":2239.4715000000001},{"$f":"SUBTOTAL(109,Employees[Potongan Lain])","v":118},{"$f":"SUBTOTAL(109,Employees[Gaji Bersih])","v":2705.5284999999994},null,null,null,null,null,null,null,null,null,{"$f":"SUBTOTAL(109,Employees[Potongan Asuransi])","v":143},{"$f":"SUBTOTAL(109,Employees[Potongan Rutin Lainnya])","v":170},{"$f":"SUBTOTAL(109,Employees[Total Potongan Rutin])","v":313}]

{"sheet":"stubs_template","index":1,"n_rows":47,"n_cols":13,"rows_kept":47,"cut":false,"hidden":true,"merged":[[2,7,2,8],[14,7,14,8],[26,7,26,8],[38,7,38,8],[38,11,38,12],[26,11,26,12],[14,11,14,12],[2,11,2,12],[2,3,2,4],[14,3,14,4],[26,3,26,4],[38,3,38,4],[44,2,44,3],[8,2,8,3],[9,2,9,3],[45,2,45,3],[32,2,32,3],[33,2,33,3],[20,2,20,3],[21,2,21,3]]}
[]
[null,null,{"$f":"CompanyName","v":"ADVENTURE WORKS"}]
[null,null,"PERIODE",{"$f":"PeriodEnding","v":41372},null,null,"NAMA",{"$f":"IFERROR(INDEX(Employees[Nama Karyawan],Stub),\"\")","v":"Tony Smith"},null,null,"ID KARYAWAN",{"$f":"IFERROR(INDEX(Employees[ID],Stub),\"\")","v":1001}]
[null,null,"Status Pajak",null,{"$f":"IFERROR(INDEX(Employees[Status Pajak],Stub),\"\")","v":1},null,"Tunjangan Negara (Dari W-4)",null,{"$f":"IFERROR(INDEX(Employees[Tunjangan Negara],Stub),\"\")","v":4},null,"Jam Kerja",null,{"$f":"IFERROR(INDEX(Employees[Jam Kerja Rutin],Stub),\"\")","v":50}]
[null,null,"Tarif per Jam",null,{"$f":"IFERROR(INDEX(Employees[Upah per Jam],Stub),\"\")","v":10},null,"Tarif Lembur",null,{"$f":"IFERROR(INDEX(Employees[Tarif Lembur],Stub),\"\")","v":0},null,"Jam Sakit",null,{"$f":"IFERROR(INDEX(Employees[Jam Sakit],Stub),\"\")","v":1}]
[null,null,"Pajak Jaminan Sosial",null,{"$f":"IFERROR(INDEX(Employees[Pajak Jaminan Sosial],Stub)  *  INDEX(Employees[Gaji Kotor],Stub),\"\")","v":35.28},null,"Pajak Penghasilan ",null,{"$f":"IFERROR(INDEX(Employees[Pajak Penghasilan],Stub)  *  INDEX(Employees[Gaji Kotor],Stub),\"\")","v":156.80000000000001},null,"Jam Liburan",null,{"$f":"IFERROR(INDEX(Employees[Jam Liburan],Stub),\"\")","v":5}]
[null,null,"Pajak Asuransi Sosial ",null,{"$f":"IFERROR(INDEX(Employees[Pajak Asuransi Sosial],Stub)  *  INDEX(Employees[Gaji Kotor],Stub),\"\")","v":8.120000000000001},null,"Pajak Negara ",null,{"$f":"IFERROR(INDEX(Employees[Pajak Negara],Stub)  *  INDEX(Employees[Gaji Kotor],Stub),\"\")","v":12.879999999999999},null,"Jam Lembur",null,{"$f":"IFERROR(INDEX(Employees[Jam Lembur],Stub),\"\")","v":0}]
[null,null,"Potongan Asuransi",null,{"$f":"IFERROR(INDEX(Employees[Potongan Asuransi],Stub),\"\")","v":20},null,"Potongan Rutin Lain",null,{"$f":"IFERROR(INDEX(Employees[Potongan Rutin Lainnya],Stub),\"\")","v":40},null,"Gaji Kotor",null,{"$f":"IFERROR(INDEX(Employees[Gaji Kotor],Stub),\"\")","v":560}]
[null,null,"Total Pajak dan",null,{"$f":"IFERROR(INDEX(Employees[Pajak dan Potongan],Stub),\"\")","v":273.08000000000004},null,"Potongan Lain",null,{"$f":"IFERROR(INDEX(Employees[Potongan Lain],Stub),\"\")","v":20},null,"Total Pajak dan Potongan ",null,{"$f":"IFERROR(INDEX(Employees[Pajak dan Potongan],Stub)  +  INDEX(Employees[Potongan Lain],Stub),\"\")","v":293.08000000000004}]
[null,null,"Potongan Rutin "]
[null,null,null,null,null,null,null,null,null,null,"GAJI BERSIH",null,{"$f":"IFERROR(INDEX(Employees[Gaji Bersih],Stub),\"\")","v":266.91999999999996}]
[]
[]
[null,null,{"$f":"CompanyName","v":"ADVENTURE WORKS"}]
[null,null,"PERIODE",{"$f":"PeriodEnding","v":41372},null,null,"NAMA",{"$f":"IFERROR(INDEX(Employees[Nama Karyawan],Stub),\"\")","v":"David Jones"},null,null,"ID KARYAWAN",{"$f":"IFERROR(INDEX(Employees[ID],Stub),\"\")","v":1002}]
[null,null,"Status Pajak",null,{"$f":"IFERROR(INDEX(Employees[Status Pajak],Stub),\"\")","v":1},null,"Tunjangan Negara (Dari W-4)",null,{"$f":"IFERROR(INDEX(Employees[Tunjangan Negara],Stub),\"\")","v":1},null,"Jam Kerja",null,{"$f":"IFERROR(INDEX(Employees[Jam Kerja Rutin],Stub),\"\")","v":40}]
[null,null,"Tarif per Jam",null,{"$f":"IFERROR(INDEX(Employees[Upah per Jam],Stub),\"\")","v":8},null,"Tarif Lembur",null,{"$f":"IFERROR(INDEX(Employees[Tarif Lembur],Stub),\"\")","v":0},null,"Jam Sakit",null,{"$f":"IFERROR(INDEX(Employees[Jam Sakit],Stub),\"\")","v":0}]
[null,null,"Pajak Jaminan Sosial",null,{"$f":"IFERROR(INDEX(Employees[Pajak Jaminan Sosial],Stub)  *  INDEX(Employees[Gaji Kotor],Stub),\"\")","v":20.16},null,"Pajak Penghasilan ",null,{"$f":"IFERROR(INDEX(Employees[Pajak Penghasilan],Stub)  *  INDEX(Employees[Gaji Kotor],Stub),\"\")","v":89.600000000000009},null,"Jam Liburan",null,{"$f":"IFERROR(INDEX(Employees[Jam Liburan],Stub),\"\")","v":0}]
[null,null,"Pajak Asuransi Sosial ",null,{"$f":"IFERROR(INDEX(Employees[Pajak Asuransi Sosial],Stub)  *  INDEX(Employees[Gaji Kotor],Stub),\"\")","v":4.6400000000000006},null,"Pajak Negara ",null,{"$f":"IFERROR(INDEX(Employees[Pajak Negara],Stub)  *  INDEX(Employees[Gaji Kotor],Stub),\"\")","v":7.3599999999999994},null,"Jam Lembur",null,{"$f":"IFERROR(INDEX(Employees[Jam Lembur],Stub),\"\")","v":0}]
[null,null,"Potongan Asuransi",null,{"$f":"IFERROR(INDEX(Employees[Potongan Asuransi],Stub),\"\")","v":0},null,"Potongan Rutin Lain",null,{"$f":"IFERROR(INDEX(Employees[Potongan Rutin Lainnya],Stub),\"\")","v":10},null,"Gaji Kotor",null,{"$f":"IFERROR(INDEX(Employees[Gaji Kotor],Stub),\"\")","v":320}]
[null,null,"Total Pajak dan",null,{"$f":"IFERROR(INDEX(Employees[Pajak dan Potongan],Stub),\"\")","v":131.76000000000002},null,"Potongan Lain",null,{"$f":"IFERROR(INDEX(Employees[Potongan Lain],Stub),\"\")","v":0},null,"Total Pajak dan Potongan ",null,{"$f":"IFERROR(INDEX(Employees[Pajak dan Potongan],Stub)  +  INDEX(Employees[Potongan Lain],Stub),\"\")","v":131.76000000000002}]
[null,null,"Potongan Rutin "]
[null,null,null,null,null,null,null,null,null,null,"GAJI BERSIH",null,{"$f":"IFERROR(INDEX(Employees[Gaji Bersih],Stub),\"\")","v":188.23999999999998}]
[]
[]
[null,null,{"$f":"CompanyName","v":"ADVENTURE WORKS"}]
[null,null,"PERIODE",{"$f":"PeriodEnding","v":41372},null,null,"NAMA",{"$f":"IFERROR(INDEX(Employees[Nama Karyawan],Stub),\"\")","v":"Denise Smith"},null,null,"ID KARYAWAN",{"$f":"IFERROR(INDEX(Employees[ID],Stub),\"\")","v":1003}]
[null,null,"Status Pajak",null,{"$f":"IFERROR(INDEX(Employees[Status Pajak],Stub),\"\")","v":1},null,"Tunjangan Negara (Dari W-4)",null,{"$f":"IFERROR(INDEX(Employees[Tunjangan Negara],Stub),\"\")","v":3},null,"Jam Kerja",null,{"$f":"IFERROR(INDEX(Employees[Jam Kerja Rutin],Stub),\"\")","v":35}]
[null,null,"Tarif per Jam",null,{"$f":"IFERROR(INDEX(Employees[Upah per Jam],Stub),\"\")","v":14},null,"Tarif Lembur",null,{"$f":"IFERROR(INDEX(Employees[Tarif Lembur],Stub),\"\")","v":0},null,"Jam Sakit",null,{"$f":"IFERROR(INDEX(Employees[Jam Sakit],Stub),\"\")","v":0}]
[null,null,"Pajak Jaminan Sosial",null,{"$f":"IFERROR(INDEX(Employees[Pajak Jaminan Sosial],Stub)  *  INDEX(Employees[Gaji Kotor],Stub),\"\")","v":33.515999999999998},null,"Pajak Penghasilan ",null,{"$f":"IFERROR(INDEX(Employees[Pajak Penghasilan],Stub)  *  INDEX(Employees[Gaji Kotor],Stub),\"\")","v":148.96},null,"Jam Liburan",null,{"$f":"IFERROR(INDEX(Employees[Jam Liburan],Stub),\"\")","v":3}]
[null,null,"Pajak Asuransi Sosial ",null,{"$f":"IFERROR(INDEX(Employees[Pajak Asuransi Sosial],Stub)  *  INDEX(Employees[Gaji Kotor],Stub),\"\")","v":7.7140000000000004},null,"Pajak Negara ",null,{"$f":"IFERROR(INDEX(Employees[Pajak Negara],Stub)  *  INDEX(Employees[Gaji Kotor],Stub),\"\")","v":12.236000000000001},null,"Jam Lembur",null,{"$f":"IFERROR(INDEX(Employees[Jam Lembur],Stub),\"\")","v":0}]
[null,null,"Potongan Asuransi",null,{"$f":"IFERROR(INDEX(Employees[Potongan Asuransi],Stub),\"\")","v":18},null,"Potongan Rutin Lain",null,{"$f":"IFERROR(INDEX(Employees[Potongan Rutin Lainnya],Stub),\"\")","v":20},null,"Gaji Kotor",null,{"$f":"IFERROR(INDEX(Employees[Gaji Kotor],Stub),\"\")","v":532}]
[null,null,"Total Pajak dan",null,{"$f":"IFERROR(INDEX(Employees[Pajak dan Potongan],Stub),\"\")","v":240.42600000000004},null,"Potongan Lain",null,{"$f":"IFERROR(INDEX(Employees[Potongan Lain],Stub),\"\")","v":0},null,"Total Pajak dan Potongan ",null,{"$f":"IFERROR(INDEX(Employees[Pajak dan Potongan],Stub)  +  INDEX(Employees[Potongan Lain],Stub),\"\")","v":240.42600000000004}]
[null,null,"Potongan Rutin "]
[null,null,null,null,null,null,null,null,null,null,"GAJI BERSIH",null,{"$f":"IFERROR(INDEX(Employees[Gaji Bersih],Stub),\"\")","v":291.57399999999996}]
[]
[]
[null,null,{"$f":"CompanyName","v":"ADVENTURE WORKS"}]
[null,null,"PERIODE",{"$f":"PeriodEnding","v":41372},null,null,"NAMA",{"$f":"IFERROR(INDEX(Employees[Nama Karyawan],Stub),\"\")","v":"Sebastien Motte"},null,null,"ID KARYAWAN",{"$f":"IFERROR(INDEX(Employees[ID],Stub),\"\")","v":1008}]
[null,null,"Status Pajak",null,{"$f":"IFERROR(INDEX(Employees[Status Pajak],Stub),\"\")","v":1},null,"Tunjangan Negara (Dari W-4)",null,{"$f":"IFERROR(INDEX(Employees[Tunjangan Negara],Stub),\"\")","v":0},null,"Jam Kerja",null,{"$f":"IFERROR(INDEX(Employees[Jam Kerja Rutin],Stub),\"\")","v":50}]
[null,null,"Tarif per Jam",null,{"$f":"IFERROR(INDEX(Employees[Upah per Jam],Stub),\"\")","v":20},null,"Tarif Lembur",null,{"$f":"IFERROR(INDEX(Employees[Tarif Lembur],Stub),\"\")","v":0},null,"Jam Sakit",null,{"$f":"IFERROR(INDEX(Employees[Jam Sakit],Stub),\"\")","v":1}]
[null,null,"Pajak Jaminan Sosial",null,{"$f":"IFERROR(INDEX(Employees[Pajak Jaminan Sosial],Stub)  *  INDEX(Employees[Gaji Kotor],Stub),\"\")","v":70.56},null,"Pajak Penghasilan ",null,{"$f":"IFERROR(INDEX(Employees[Pajak Penghasilan],Stub)  *  INDEX(Employees[Gaji Kotor],Stub),\"\")","v":313.60000000000002},null,"Jam Liburan",null,{"$f":"IFERROR(INDEX(Employees[Jam Liburan],Stub),\"\")","v":5}]
[null,null,"Pajak Asuransi Sosial ",null,{"$f":"IFERROR(INDEX(Employees[Pajak Asuransi Sosial],Stub)  *  INDEX(Employees[Gaji Kotor],Stub),\"\")","v":16.240000000000002},null,"Pajak Negara ",null,{"$f":"IFERROR(INDEX(Employees[Pajak Negara],Stub)  *  INDEX(Employees[Gaji Kotor],Stub),\"\")","v":25.759999999999998},null,"Jam Lembur",null,{"$f":"IFERROR(INDEX(Employees[Jam Lembur],Stub),\"\")","v":0}]
[null,null,"Potongan Asuransi",null,{"$f":"IFERROR(INDEX(Employees[Potongan Asuransi],Stub),\"\")","v":15},null,"Potongan Rutin Lain",null,{"$f":"IFERROR(INDEX(Employees[Potongan Rutin Lainnya],Stub),\"\")","v":0},null,"Gaji Kotor",null,{"$f":"IFERROR(INDEX(Employees[Gaji Kotor],Stub),\"\")","v":1120}]
[null,null,"Total Pajak dan",null,{"$f":"IFERROR(INDEX(Employees[Pajak dan Potongan],Stub),\"\")","v":441.16000000000008},null,"Potongan Lain",null,{"$f":"IFERROR(INDEX(Employees[Potongan Lain],Stub),\"\")","v":0},null,"Total Pajak dan Potongan ",null,{"$f":"IFERROR(INDEX(Employees[Pajak dan Potongan],Stub)  +  INDEX(Employees[Potongan Lain],Stub),\"\")","v":441.16000000000008}]
[null,null,"Potongan Rutin "]
[null,null,null,null,null,null,null,null,null,null,"GAJI BERSIH",null,{"$f":"IFERROR(INDEX(Employees[Gaji Bersih],Stub),\"\")","v":678.83999999999992}]