{"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":29,"n_cols":7,"rows_kept":29,"cut":false,"hidden":false,"merged":[]}
[]
[]
[null,"Project Management - 6-5 Cost Codes"]
[]
[null,"The following template should be used to import Cost Codes into Sage 100 Contractor.  "]
[]
[]
[]
[null,"File Layout Specification"]
[]
[null,"Header","Reference","Data Type","Tab","Example","Description"]
[null,"filetype","Required","PJCC",null,"PJCC","PJCC"]
[null,"recnum","Required","Numeric(9,3)",null,2010,"Cost Code"]
[null,"cdenme","Required","String(50)",null,"Interior Demolition","Cost Code Name"]
[null,"divnum","Required **","Numeric",null,null,"Division"]
[null,"untdsc",null,"String(10)",null,null,"Unit Desc"]
[null,"cmpcde","**","Numeric",null,null,"Comp Code 1"]
[null,"maxwge",null,"Numeric(3,2)",null,null,"Max Wage"]
[null,"cmpcd2","**","Numeric",null,null,"Comp Code 2"]
[null,"dptnum","**","Numeric",null,null,"Department"]
[null,"ntetxt",null,"TEXT",null,null,"Notes"]
[null,"inactv",null,"String(1)",null,"Y=Yes;N=No","Inactive"]
[]
[null,"** Validated Field - value must exist in the respective lookup table in Sage 100 Contractor "]
[]
[null,"File Example:"]
[null,"filetype,recnum,cdenme,divnum"]
[null,"PJCC,2011.000,\"Interior Demo\",2"]
[null,"PJCC,2012.000,\"Exterior Demo\",2"]

{"sheet":"Template","index":1,"n_rows":10,"n_cols":12,"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","Cost Code","Cost Code Name","Division","Unit Desc","Comp Code 1","Max Wage","Comp Code 2","Department","Notes","Inactive"]
[null,"PJCC","Numeric(9,3)","String(50)","Numeric","String(10)","Numeric","Numeric(3,2)","Numeric","Numeric","TEXT","String(1)"]
[]
["First Line of File==>","filetype","recnum","cdenme","divnum","untdsc","cmpcde","maxwge","cmpcd2","dptnum","ntetxt","inactv"]
[null,"PJCC","2011.000","Interior Demo 1",2]
[null,"PJCC","2012.000","Interior Demo 2",2]
[null,"PJCC","2013.000","Interior Demo 3",2]