{"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":40,"n_cols":7,"rows_kept":40,"cut":false,"hidden":false,"merged":[]}
[]
[]
[null,"Project Management - 6-9 Proposals"]
[]
[null,"The following template should be used to import Proposals into Sage 100 Contractor.  "]
[]
[]
[]
[null,"File Layout Specification"]
[]
[null,"Header","Reference","Data Type","Tab","Example","Description"]
[null,"filetype","Required","PJPROPSL",null,"PJPROPSL","PJPROPSL"]
[null,"colshw","Required","Numeric",null,"1=Cost Code;0=Bid Item (1)","Use Cost Code or Bid Item for proposal lines"]
[null,"lckedt","Required","Numeric",null,"1=Yes;0=No (1)","Lock Edit"]
[null,"hotlst","Required","Numeric",null,"1=Yes;0=No (1)","Hot List"]
[null,"setprpsl","Required","Numeric",null,"1=Yes;0=No (1)","Set Proposal"]
[null,"recnum","Required **","Numeric",null,null,"Job No"]
[null,"phsnum","**","Numeric",null,null,"Phase No"]
[null,"cstcde","Required **","Numeric (9,3)",null,null,"Cost Code"]
[null,"dscrpt",null,"String (50)",null,null,"Description"]
[null,"matprp",null,"Numeric (10,2)",null,null,"Material"]
[null,"labprp",null,"Numeric (10,2)",null,null,"Labor"]
[null,"eqpprp",null,"Numeric (10,2)",null,null,"Equipment"]
[null,"subprp",null,"Numeric (10,2)",null,null,"Subcontract"]
[null,"othprp",null,"Numeric (10,2)",null,null,"Other"]
[null,"usrcs6",null,"Numeric (10,2)",null,null,"User Def 6"]
[null,"usrcs7",null,"Numeric (10,2)",null,null,"User Def 7"]
[null,"usrcs8",null,"Numeric (10,2)",null,null,"User Def 8"]
[null,"usrcs9",null,"Numeric (10,2)",null,null,"User Def 9"]
[null,"usrdf1",null,"String (50)",null,null,"User Defined"]
[null,"ntetxt",null,"Text",null,null,"Notes"]
[]
[null,"** Validated Field - value must exist in the respective lookup table in Sage 100 Contractor"]
[null,"(1) For each job, this value must be the same for all lines in the file "]
[]
[null,"File Example:"]
[null,"filetype,colshw,lckedt,hotlst,setprpsl,recnum,phsnum,cstcde,dscrpt,matprp,labprp,eqpprp,subprp,othprp"]
[null,"PJPROPSL,1,1,0,0,2017008,,2120.000,\"Line 1\",1,2,3,4,5"]
[null,"PJPROPSL,1,1,0,0,2017008,,3010.000,\"Line 2\",1,2,3,4,5"]
[null,"PJPROPSL,1,1,0,0,2017008,,3060.000,\"Line 3\",1,2,3,4,5"]

{"sheet":"Template","index":1,"n_rows":10,"n_cols":21,"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","Use (1) Cost Code or (0) Bid Item for proposal lines","Lock Edit","Hot List","Set Proposal","Job No","Phase No","Cost Code","Description","Material","Labor","Equipment","Subcontract","Other","User Def 6","User Def 7","User Def 8","User Def 9","User Defined","Notes"]
[null,"PJPROPSL","Numeric","Numeric","Numeric","Numeric","Numeric","Numeric","Numeric (9,3)","String (50)","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)","String (50)","Text"]
[]
["First Line of File==>","filetype","colshw","lckedt","hotlst","setprpsl","recnum","phsnum","cstcde","dscrpt","matprp","labprp","eqpprp","subprp","othprp","usrcs6","usrcs7","usrcs8","usrcs9","usrdf1","ntetxt"]
[null,"PJPROPSL",1,0,0,0,2017008,null,"2010.00","line 1",100]
[null,"PJPROPSL",1,0,0,0,2017008,null,"2020.00","line 2",null,200]
[null,"PJPROPSL",1,0,0,0,2017008,null,"2030.00","line 3",null,null,null,300]