{"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":50,"n_cols":7,"rows_kept":50,"cut":false,"hidden":false,"merged":[[0,3,0,4]]}
[null,null,null,"Version: 2024-11-04"]
[]
[null,"Estimating - 9-5 Takeoff"]
[]
[null,"The following template should be used to import one or more equipment items into Sage 100 Contractor.  "]
[]
[null,"File Layout Specification"]
[]
[null,"Header Layout"]
[]
[null,"Field","Reference","Data Type","Tab","Example","Description"]
[null,"filetype","Required","ESTO",null,"ESTO","(File Type Code)"]
[null,"recnum","Required (1)","Numeric","Header",null,"Job No"]
[null,"prtprc","Required (1)","Numeric","Header","0=Default Cost;1=Billing Amt;2=Avg Cost;3=Lowest Vendor;4=Preferred Vendor","Part Cost Default"]
[null,"itmnum","** (1)","Numeric","Header","Default 0 - None","Bid Item No"]
[null,"phsnum","** (1)","Numeric","Header","Default 0 - None","Phase No"]
[null,"lckedt","(1)","Numeric","Header","1=Yes;0=No (default)","Lock Edit"]
[null,"asmnum","**","Numeric","Details",null,"Assembly No"]
[null,"asmchk","**","String (1)","Details","L=Assembly;R=Assembly Labor;(Blank)= Part","Check Arrow Direction"]
[null,"prtnum","**","Numeric","Details",null,"Part No"]
[null,"prtdsc",null,"String (75)","Details",null,"Part Description"]
[null,"untdsc",null,"String (10)","Details",null,"Unit of Measure"]
[null,"linqty",null,"Numeric (10,4)","Details",null,"Quantity"]
[null,"linprc","(2)","Numeric (9,6)","Details",null,"Cost"]
[null,"linlck",null,"String (1)","Details","L=Locked;(Blank)=Unlocked","Line Locked"]
[null,"qtyfrm",null,"String (50)","Details",null,"Quantity Formula"]
[null,"taxdst","**","Numeric","Details",null,"Tax District"]
[null,"ovhmrk",null,"Numeric (4,2)","Details",null,"Overhead Rate"]
[null,"pftmrk",null,"Numeric (4,2)","Details",null,"Profit Rate"]
[null,"prmvnd","**","Numeric","Details",null,"Vendor"]
[null,"cstcde","**","Numeric (11,3)","Details",null,"Cost Code"]
[null,"csttyp","**","Numeric","Details","1-Mat,2-Lab,3-equip,4-sub,5-oth,6-udf,7-udf,8-udf,9-udf","Cost Type"]
[null,"tsknum","**","Numeric (11,3)","Details",null,"Scheduled Task No"]
[null,"invloc","**","Numeric","Details",null,"Inventory Location"]
[null,"usrdf1",null,"String (50)","Details",null,"User Defined 1"]
[null,"ntetxt",null,"Text","Details",null,"Notes"]
[null,"expnte",null,"Text","Details",null,"Export Notes"]
[]
[null,"** Validated Field - value must exist in the respective lookup table in Sage 100 Contractor"]
[null,"(1) Value should repeat on every line for each unique Job Take Off"]
[null,"(2) Price may not be a negative value. If the line amount is negative you must make the \"Quantity\" negative"]
[]
[null,"Note: After a takeoff has been imported, the takeoff should be re-saved in Sage 100 Contractor's interface to ensure that the takeoff calculations and totals are correctly updated and calculated."]
[]
[]
[null,"File Example:"]
[null,"filetype,recnum,prtprc,itmnum,phsnum,asmnum,asmchk,prtnum,prtdsc,untdsc,linqty,linprc,linlck,qtyfrm,taxdst,ovhmrk,pftmrk,prmvnd,cstcde,csttyp,tsknum,invloc,usrdf1,ntetxt,expnte"]
[null,"ESTO,2017504,0,,,1,\"\",,\"Assembly 1\",\"\",,,\"\",\"\",,,,,,,,,\"\",\"\",\"\""]
[null,"ESTO,2017504,0,,,,\"L\",19101,\"line 1 part \",\"ea\",4,100,\"\",\"\",,,,,,,,,\"\",\"\",\"\""]
[null,"ESTO,2017504,0,,,,\"L\",19102,\"line 2 part\",\"ea\",5,200,\"\",\"\",,,,,,,,,\"\",\"\",\"\""]

{"sheet":"Template","index":1,"n_rows":11,"n_cols":27,"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","Job No","Part Cost Default","Bid Item No","Phase No","Lock Edit","Assembly No","Check Arrow Direction","Part No","Part Description","Unit of Measure","Quantity","Cost","Line Locked","Quantity Formula","Tax District","Overhead Rate","Profit Rate","Vendor","Cost Code","Cost Type","Scheduled Task No","Inventory Location","User Defined 1","Notes","Export Notes"]
[null,"ESTO","Numeric","Numeric","Numeric","Numeric","Numeric","Numeric","String (1)","Numeric","String (75)","String (10)","Numeric (10,4)","Numeric (9,6)","String (1)","String (50)","Numeric","Numeric (4,2)","Numeric (4,2)","Numeric","Numeric (11,3)","Numeric","Numeric (11,3)","Numeric","String (50)","Text","Text"]
[]
[null,null,null,"**","**","**",null,"**","**","**",null,null,null,null,null,null,"**",null,null,"**","**","**","**","**"]
["First Line of File==>","filetype","recnum","prtprc","itmnum","phsnum","lckedt","asmnum","asmchk","prtnum","prtdsc","untdsc","linqty","linprc","linlck","qtyfrm","taxdst","ovhmrk","pftmrk","prmvnd","cstcde","csttyp","tsknum","invloc","usrdf1","ntetxt","expnte"]
[null,"ESTO",2017504,0,null,null,0,1,null,null,"Assembly 1"]
[null,"ESTO",2017504,0,null,null,0,null,"L",19101,"line 1 part ","ea",4,100]
[null,"ESTO",2017504,0,null,null,0,null,"L",19102,"line 2 part","ea",5,200]