{"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":86,"n_cols":7,"rows_kept":86,"cut":false,"hidden":false,"merged":[]}
[]
[]
[null,"Equipment Management - 8-3 Equipment"]
[]
[null,"The following template should be used to import one or more equipment items into Sage 100 Contractor.  "]
[]
[]
[]
[null,"File Layout Specification"]
[]
[null,"Header","Reference","Data Type","Tab","Example","Description"]
[null,"filetype","Required","EQUIP",null,"EQUIP","EQUIP"]
[null,"recnum","Required","Numeric","Header",null,"Equip No"]
[null,"eqpnme","Required(I)","String (50)","Header",null,"Equip Desc"]
[null,"shtnme","Required(I)","String (30)","Header",null,"Equip Short Name"]
[null,"status","Required(I) **","Numeric","Header","1-Available;2-Under Repair;3-Out of Service;4-Sold","Status"]
[null,"eqptyp","**","Numeric","Header",null,"Equip Type"]
[null,"srlnum",null,"String (30)","General Info",null,"Serial#"]
[null,"licnum",null,"String (30)","General Info",null,"License#"]
[null,"pucnum",null,"String (30)","General Info",null,"PUC#"]
[null,"usrdf1",null,"String (50)","General Info",null,"User Def1"]
[null,"usrdf2",null,"String (50)","General Info",null,"User Def2"]
[null,"lstloc",null,"String (75)","General Info",null,"Last Location"]
[null,"pchdte",null,"Date","General Info","yyyy-mm-dd","Purchase Date"]
[null,"slddte",null,"Date","General Info","yyyy-mm-dd","Sold Date"]
[null,"orghrs",null,"Numeric (10,2)","General Info",null,"Original Hours"]
[null,"orgmls",null,"Numeric (10,2)","General Info",null,"Original Miles"]
[null,"ttlhrs",null,"Numeric (10,2)","General Info",null,"Total Hours"]
[null,"ttlmls",null,"Numeric (10,2)","General Info",null,"Total Miles"]
[null,"intact","**","Numeric","Financial Info",null,"Interest Exp Acct"]
[null,"depact","**","Numeric","Financial Info",null,"Depreciation Exp Acct"]
[null,"depmnt","**","Numeric","Financial Info",null,"Department"]
[null,"lontyp","**","Numeric","Financial Info","0-None;1-Amortized;2-Principal + Interest;3-Lease","Loan Type"]
[null,"lender","**","Numeric","Financial Info",null,"Lender"]
[null,"lonnum",null,"String (30)","Financial Info",null,"Loan#"]
[null,"nxtpay",null,"Date","Financial Info","yyyy-mm-dd","Loan Pay Date"]
[null,"intrte",null,"Numeric (10,2)","Financial Info",null,"Loan Interest Rate"]
[null,"paymnt",null,"Numeric (10,2)","Financial Info",null,"Loan Pmt Amt"]
[null,"deprte",null,"Numeric (10,2)","Financial Info",null,"Monthly Depreciation"]
[null,"strdte",null,"Date","Cost Recov Wrksht","yyyy-mm-dd","Start Date"]
[null,"enddte",null,"Date","Cost Recov Wrksht","yyyy-mm-dd","End Date"]
[null,"strval",null,"Numeric (10,2)","Cost Recov Wrksht",null,"Start Value"]
[null,"endval",null,"Numeric (10,2)","Cost Recov Wrksht",null,"Ending Value"]
[null,"unttyp","**","Numeric","Cost Recov Wrksht","1-Hours;2-Days;3-Weeks;4-Months;5-Miles","Est Use Unit type"]
[null,"estuse",null,"Numeric (10,2)","Cost Recov Wrksht",null,"Est Use Amount"]
[null,"insrnc",null,"Numeric (10,2)","Cost Recov Wrksht",null,"Cost of Own - Insurance"]
[null,"taxlic",null,"Numeric (10,2)","Cost Recov Wrksht",null,"Cost of Own - Tax and Lic"]
[null,"inspct",null,"Numeric (10,2)","Cost Recov Wrksht",null,"Cost of Own - Inspection"]
[null,"storag",null,"Numeric (10,2)","Cost Recov Wrksht",null,"Cost of Own - Storage"]
[null,"ovrhed",null,"Numeric (10,2)","Cost Recov Wrksht",null,"Cost of Own - Overhaul"]
[null,"financ",null,"Numeric (10,2)","Cost Recov Wrksht",null,"Cost of Own - Financing"]
[null,"cstcap",null,"Numeric (10,2)","Cost Recov Wrksht",null,"Cost of Own - Cost of Capital"]
[null,"othcst",null,"Numeric (10,2)","Cost Recov Wrksht",null,"Cost of Own - Other Costs"]
[null,"fuloil",null,"Numeric (10,2)","Cost Recov Wrksht",null,"Cost of Oper - Fuel and Oil"]
[null,"oilchg",null,"Numeric (10,2)","Cost Recov Wrksht",null,"Cost of Oper - Oil Change"]
[null,"fluchg",null,"Numeric (10,2)","Cost Recov Wrksht",null,"Cost of Oper - Fluid Change"]
[null,"mntcst",null,"Numeric (10,2)","Cost Recov Wrksht",null,"Cost of Oper - Maintenance"]
[null,"csttir",null,"Numeric (10,2)","Cost Recov Wrksht",null,"Cost of Oper - Tires"]
[null,"minrpr",null,"Numeric (10,2)","Cost Recov Wrksht",null,"Cost of Oper - Minor Repair"]
[null,"othopr",null,"Numeric (10,2)","Cost Recov Wrksht",null,"Cost of Oper - Other Cost"]
[null,"oprcst",null,"Numeric (10,2)","Cost and Bill Rates",null,"Operated - Cost Rates"]
[null,"oprbll",null,"Numeric (10,2)","Cost and Bill Rates",null,"Operated - Bill Rates"]
[null,"dyopbl",null,"Numeric (10,2)","Cost and Bill Rates",null,"Operated - Daily"]
[null,"wkopbl",null,"Numeric (10,2)","Cost and Bill Rates",null,"Operated - Weekly"]
[null,"mtopbl",null,"Numeric (10,2)","Cost and Bill Rates",null,"Operated - Monthly"]
[null,"idlcst",null,"Numeric (10,2)","Cost and Bill Rates",null,"Idled - Cost Rates"]
[null,"idlbll",null,"Numeric (10,2)","Cost and Bill Rates",null,"Idled - Bill Rates"]
[null,"dyidbl",null,"Numeric (10,2)","Cost and Bill Rates",null,"Idled - Daily"]
[null,"wkidbl",null,"Numeric (10,2)","Cost and Bill Rates",null,"Idled - Weekly"]
[null,"mtidbl",null,"Numeric (10,2)","Cost and Bill Rates",null,"Idled - Monthly"]
[null,"stbcst",null,"Numeric (10,2)","Cost and Bill Rates",null,"Standby - Cost Rates"]
[null,"stbbll",null,"Numeric (10,2)","Cost and Bill Rates",null,"Standby - Bill Rates"]
[null,"dystbl",null,"Numeric (10,2)","Cost and Bill Rates",null,"Standby - Daily"]
[null,"wkstbl",null,"Numeric (10,2)","Cost and Bill Rates",null,"Standby - Weekly"]
[null,"mtstbl",null,"Numeric (10,2)","Cost and Bill Rates",null,"Standby - Monthly"]
[null,"moblbl",null,"Numeric (10,2)","Cost and Bill Rates",null,"Mobilization Billing Amt"]
[null,"ntetxt",null,"Text","Header",null,"Notes"]
[]
[null,"Required(I) - required for Inserts only"]
[null,"** Validated Field - value must exist in the respective lookup table in Sage 100 Contractor"]
[]
[null,"File Example:"]
[null,"filetype,recnum,eqpnme,shtnme,status,eqptyp,srlnum,licnum,pucnum"]
[null,"EQUIP,19101,\"Equip #101\",\"EQ101\",1,,\"\",\"\",\"\""]
[null,"EQUIP,19102,\"Equip #102\",\"EQ102\",1,,\"\",\"\",\"\""]
[null,"EQUIP,19103,\"Equip #103\",\"EQ103\",1,,\"\",\"\",\"\""]

{"sheet":"Template","index":1,"n_rows":11,"n_cols":67,"rows_kept":11,"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,"File Type","Equip No","Equip Desc","Equip Short Name","Status","Equip Type","Serial#","License#","PUC#","User Def1","User Def2","Last Location","Purchase Date","Sold Date","Original Hours","Original Miles","Total Hours","Total Miles","Interest Exp Acct","Depreciation Exp Acct","Department","Loan Type","Lender","Loan#","Loan Pay Date","Loan Interest Rate","Loan Pmt Amt","Monthly Depreciation","Start Date","End Date","Start Value","Ending Value","Est Use Unit type","Est Use Amount","Cost of Own - Insurance","Cost of Own - Tax and Lic","Cost of Own - Inspection","Cost of Own - Storage","Cost of Own - Overhaul","Cost of Own - Financing","Cost of Own - Cost of Capital","Cost of Own - Other Costs","Cost of Oper - Fuel and Oil","Cost of Oper - Oil Change","Cost of Oper - Fluid Change","Cost of Oper - Maintenance","Cost of Oper - Tires","Cost of Oper - Minor Repair","Cost of Oper - Other Cost","Operated - Cost Rates","Operated - Bill Rates","Operated - Daily","Operated - Weekly","Operated - Monthly","Idled - Cost Rates","Idled - Bill Rates","Idled - Daily","Idled - Weekly","Idled - Monthly","Standby - Cost Rates","Standby - Bill Rates","Standby - Daily","Standby - Weekly","Standby - Monthly","Mobilization Billing Amt","Notes"]
[null,"EQUIP","Numeric","String (50)","String (30)","Numeric","Numeric","String (30)","String (30)","String (30)","String (50)","String (50)","String (75)","Date","Date","Numeric (10,2)","Numeric (10,2)","Numeric (10,2)","Numeric (10,2)","Numeric","Numeric","Numeric","Numeric","Numeric","String (30)","Date","Numeric (10,2)","Numeric (10,2)","Numeric (10,2)","Date","Date","Numeric (10,2)","Numeric (10,2)","Numeric","Numeric (10,2)","Numeric (10,2)","Numeric (10,2)","Numeric (10,2)","Numeric (10,2)","Numeric (10,2)","Numeric (10,2)","Numeric (10,2)","Numeric (10,2)","Numeric (10,2)","Numeric (10,2)","Numeric (10,2)","Numeric (10,2)","Numeric (10,2)","Numeric (10,2)","Numeric (10,2)","Numeric (10,2)","Numeric (10,2)","Numeric (10,2)","Numeric (10,2)","Numeric (10,2)","Numeric (10,2)","Numeric (10,2)","Numeric (10,2)","Numeric (10,2)","Numeric (10,2)","Numeric (10,2)","Numeric (10,2)","Numeric (10,2)","Numeric (10,2)","Numeric (10,2)","Numeric (10,2)","Text"]
[null,null,"Header","Header","Header","Header","Header","General Info","General Info","General Info","General Info","General Info","General Info","General Info","General Info","General Info","General Info","General Info","General Info","Financial Info","Financial Info","Financial Info","Financial Info","Financial Info","Financial Info","Financial Info","Financial Info","Financial Info","Financial Info","Cost Recov Wrksht","Cost Recov Wrksht","Cost Recov Wrksht","Cost Recov Wrksht","Cost Recov Wrksht","Cost Recov Wrksht","Cost Recov Wrksht","Cost Recov Wrksht","Cost Recov Wrksht","Cost Recov Wrksht","Cost Recov Wrksht","Cost Recov Wrksht","Cost Recov Wrksht","Cost Recov Wrksht","Cost Recov Wrksht","Cost Recov Wrksht","Cost Recov Wrksht","Cost Recov Wrksht","Cost Recov Wrksht","Cost Recov Wrksht","Cost Recov Wrksht","Cost and Bill Rates","Cost and Bill Rates","Cost and Bill Rates","Cost and Bill Rates","Cost and Bill Rates","Cost and Bill Rates","Cost and Bill Rates","Cost and Bill Rates","Cost and Bill Rates","Cost and Bill Rates","Cost and Bill Rates","Cost and Bill Rates","Cost and Bill Rates","Cost and Bill Rates","Cost and Bill Rates","Cost and Bill Rates","Header"]
[]
["First Line of File==>","filetype","recnum","eqpnme","shtnme","status","eqptyp","srlnum","licnum","pucnum","usrdf1","usrdf2","lstloc","pchdte","slddte","orghrs","orgmls","ttlhrs","ttlmls","intact","depact","depmnt","lontyp","lender","lonnum","nxtpay","intrte","paymnt","deprte","strdte","enddte","strval","endval","unttyp","estuse","insrnc","taxlic","inspct","storag","ovrhed","financ","cstcap","othcst","fuloil","oilchg","fluchg","mntcst","csttir","minrpr","othopr","oprcst","oprbll","dyopbl","wkopbl","mtopbl","idlcst","idlbll","dyidbl","wkidbl","mtidbl","stbcst","stbbll","dystbl","wkstbl","mtstbl","moblbl","ntetxt"]
[null,"EQUIP",19101,"Equip #101","EQ101",1]
[null,"EQUIP",19102,"Equip #102","EQ102",1]
[null,"EQUIP",19103,"Equip #103","EQ103",1]