{"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":45,"n_cols":7,"rows_kept":45,"cut":false,"hidden":false,"merged":[]}
[null,null,null,"version: 2022-02-20"]
[]
[null,"Equipment Management - 8-4 Equipment Allocation"]
[]
[null,"The following template should be used to import equipement allocation entries into Sage 100 Contractor.  "]
[]
[]
[]
[null,"File Layout Specification"]
[]
[null,"Header","Reference","Data Type","Tab","Example","Description"]
[null,"filetype","Required","EQUIPALLOC",null,"EQUIPALLOC","EQUIPALLOC"]
[null,"trnnum","Required","String (20)",null,null,"Transaction Jrnl No"]
[null,"trndte","Required","Date",null,"yyyy-mm-dd","Transaction Date"]
[null,"dscrpt","Required","String (50)",null,null,"Transaction Desc"]
[null,"eqpnum","Required **","Numeric",null,null,"Operated Equipment"]
[null,"jobnum","Required (1) **","Numeric",null,null,"Job No"]
[null,"phsnum","**","Numeric",null,null,"Phase No"]
[null,"eqpmnt","Required (1) (2) **","Numeric",null,null,"Equip Repaired"]
[null,"cstcde","Required **","Numeric (9,3)",null,null,"Cost Code"]
[null,"cstoperqty",null,"Numeric (10,2)",null,null,"Cost - Operated Qty"]
[null,"cstoperrt",-3,"Numeric (10,2)",null,null,"Cost - Operated Unit Rate"]
[null,"cststdbyqty",null,"Numeric (10,2)",null,null,"Cost - Standby Qty"]
[null,"cststdbyrt",-3,"Numeric (10,2)",null,null,"Cost - Standby Unit Rate"]
[null,"cstidleqy",null,"Numeric (10,2)",null,null,"Cost - Idle Qty"]
[null,"cstidlert",-3,"Numeric (10,2)",null,null,"Cost - Idle Rate"]
[null,"rntunittyp",-3,"Numeric (10,2)",null,"1-Hours;2-Days;3-Weeks;4-Months;5-Miles","Rental - Unit Type"]
[null,"rntoperqty",null,"Numeric (10,2)",null,null,"Rental - Operated Qty"]
[null,"rntoperrt",-3,"Numeric (10,2)",null,null,"Rental - Operated Rate"]
[null,"rntstdbyqty",null,"Numeric (10,2)",null,null,"Rental - Standby Qty"]
[null,"rntstdbyrt",-3,"Numeric (10,2)",null,null,"Rental - Standby Rate"]
[null,"rntidleqty",null,"Numeric (10,2)",null,null,"Rental - Idle Qty"]
[null,"rntidlert",-3,"Numeric (10,2)",null,null,"Rental - Idle Rate"]
[]
[null,"** Validated Field - value must exist in the respective lookup table in Sage 100 Contractor"]
[null,"(1) Either Job or Equipment must be selected but not both"]
[null,"(2) If Equip Repaired is selected it can't be the same as the Operated Equipment"]
[null,"(3) If left blank or zero the rate will be derived from the equipment record"]
[]
[]
[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":24,"rows_kept":11,"cut":false,"hidden":false,"merged":[[2,11,2,16],[2,17,2,23]]}
["Sample Template",null,"Note: you may delete any column from this template that is not used or needed other than the Required Columns"]
[]
[null,null,null,null,null,null,null,null,null,null,null,"Operating Costs",null,null,null,null,null,"Rental/Billing Revenue"]
[null,"File Type","Transaction Jrnl No","Transaction Date","Accounting Date","Transaction Desc","Operated Equipment","Job No","Phase No","Equip Repaired","Cost Code","Operated\nQty","Operated\nUnit Rate","Standby\nQty","Standby\nUnit Rate","Idle\nQty","Idle\nRate","Rental\nUnit","Operated\nQty","Operated\nUnit Rate","Standby\nQty","Standby\nUnit Rate","Idle\nQty","Idle\nRate"]
[null,"EQUIPALLOC","String (20)","Date","Date","String (50)","Numeric","Numeric","Numeric","Numeric","Numeric (9,3)","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)"]
[]
[null,null,null,null,null,null,"**","**","**","**","**",null,null,null,null,null,null,"**"]
["First Line of File==>","filetype","trnnum","trndte","actgdte","dscrpt","eqpnum","jobnum","phsnum","eqpmnt","cstcde","cstoperqty","cstoperrt","cststdbyqty","cststdbyrt","cstidleqy","cstidlert","rntunittyp","rntoperqty","rntoperrt","rntstdbyqty","rntstdbyrt","rntidleqty","rntidlert"]
[null,"EQUIPALLOC","EQ 3","5/28/17","5/28/17","EQ 3 Test","19103","2017008",null,null,"2120.000",10,null,null,null,1]
[null,"EQUIPALLOC","EQ 3","5/28/17","5/28/17","EQ 3 Test","19103","2017008",null,null,"2120.000",15,null,5,null,1,null,1,20,null,11,null,1]
[null,"EQUIPALLOC","EQ 3","5/28/17","5/28/17","EQ 3 Test","19102",null,null,"1","2120.000",20,null,5,null,1,null,1,10,null,11,null,1]