{"text_format":"1","workbook":"xlsx","n_sheets":2,"sheets":["Overview","Template"],"not_rendered":{"charts":0,"images":1,"macros":1,"external_links":0,"defined_names":1,"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":"Overview","index":0,"n_rows":30,"n_cols":7,"rows_kept":30,"cut":false,"hidden":false,"merged":[]}
[]
[]
[null,"Payroll - 5-2-1 Employee Calculations"]
[]
[null,"The following template should be used to import one or more Employee Calculations into Sage 100 Contractor.  "]
[]
[]
[]
[null,"File Layout Specification"]
[]
[null,"Header","Reference","Data Type","Tab","Example","Description"]
[null,"filetype","Required","PREMPCALC",null,"PREMPCALC","PREMPCALC"]
[null,"recnum","Required **","Numeric","Calculations",null,"Employee No"]
[null,"clcnum","Required **","Numeric","Calculations",null,"Payroll Calc No"]
[null,"active",null,"String (1)","Calculations","Y=Yes;N=No (Default=Y)","Active"]
[null,"dedrte",null,"Numeric (6,4)","Calculations",null,"Rate"]
[null,"dedmax",null,"Numeric (10,4)","Calculations",null,"Maximum"]
[null,"mrtsts","**","Numeric","Calculations","1=Single; 2=Married; 3=Head of Household; 4=Married/Separate; 5=Married/Joint","Marital Status"]
[null,"allows",null,"Numeric","Calculations",null,"Standard Allowances"]
[null,"addall",null,"Numeric","Calculations",null,"Additional Allowances"]
[null,"tblnum",null,"Numeric","Calculations","value between 1-99","Table#"]
[null,"addste",null,"Numeric (5,2)","Calculations",null,"Additional Withholdings"]
[null,"offset",null,"Numeric (3,2)","Calculations",null,"Offset"]
[]
[null,"** Validated Field - value is either restricted to a defined list of values or exists in the fields respective lookup table in Sage 100 Contractor"]
[]
[null,"File Example:"]
[null,"filetype,recnum,clcnum,active,dedrte,dedmax,mrtsts,allows,addall,tblnum,addste,offset"]
[null,"PREMPCALC,20,26,\"Y\",24.5,,,,,,,"]
[null,"PREMPCALC,20,30,\"N\",26,,,,,,,"]

{"sheet":"Template","index":1,"n_rows":10,"n_cols":13,"rows_kept":10,"cut":false,"hidden":false,"merged":[]}
["Sample Template",null,"Note: you may delete any column from this template that is not used or needed other than the Required Columns"]
[]
[]
[null,"Filetype Code","Employee No","Payroll Calc No","Active","Rate","Maximum","Marital Status","Standard Allowances","Additional Allowances","Table#","Additional Withholdings","Offset"]
[null,"PREMPCALC","Numeric","Numeric","String (1)","Numeric (6,4)","Numeric (10,4)","Numeric","Numeric","Numeric","Numeric","Numeric (5,2)","Numeric (3,2)"]
[null,null,"Calculations","Calculations","Calculations","Calculations","Calculations","Calculations","Calculations","Calculations","Calculations","Calculations","Calculations"]
[]
["First Line of File==>","filetype","recnum","clcnum","active","dedrte","dedmax","mrtsts","allows","addall","tblnum","addste","offset"]
[null,"PREMPCALC",20,26,"Y",24.5]
[null,"PREMPCALC",20,30,"N",26]