{"text_format":"1","workbook":"xlsx","n_sheets":4,"sheets":["Overview","Change Order Form","Grid Sample","misc"],"not_rendered":{"charts":0,"images":1,"macros":1,"external_links":0,"defined_names":25,"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":95,"n_cols":8,"rows_kept":95,"cut":false,"hidden":false,"merged":[[4,1,4,6],[2,1,2,6],[6,1,6,6],[0,3,0,5]]}
[null,null,null,"Version: 2025-04-03"]
[]
[null,"Project Management - 6-4-1 Change Orders"]
[]
[null,"The following template should be used to import Change Orders into Sage 100 Contractor.  "]
[]
[null,"File Layout Specification"]
[]
[null,"Header Layout"]
[]
[null,"Header","Field","Reference","Data Type","Tab","Example","Description"]
[null,"COL1","filetype","Required","String (6)","Header","PJCO","(File Type Code)"]
[null,"COL2","linetype","Required","String (1)","Header","H","Header Record"]
[null,"COL3","jobnum","Required **","Numeric","Header",null,"Job No"]
[null,"COL4","chgnum","Required","String (20)","Header",null,"CO Number"]
[null,"COL5","chgdte","Required","Date","Header","yyyy-mm-dd","CO Date"]
[null,"COL6","dscrpt","Required","String (50)","Header",null,"CO Description"]
[null,"COL7","status","Required **","Numeric","Header","1-Approved,2-Open,3-Review,4-Disputed,5-Void,6-Rejected","CO Status"]
[null,"COL8","phsnum","**","Numeric","Header",null,"Job Phase No"]
[null,"COL9","reason",null,"String (50)","Header",null,"CO Reason"]
[null,"COL10","usrdf1",null,"String (50)","Header",null,"User Def 1"]
[null,"COL11","usrdf2",null,"String (50)","Header",null,"User Def 2"]
[null,"COL12","pchord",null,"String (30)","Header",null,"Client PO No"]
[null,"COL13","subdte",null,"Date","Header","yyyy-mm-dd","Submitted Date"]
[null,"COL14","aprdte",null,"Date","Header","yyyy-mm-dd","Approved Date"]
[null,"COL15","invdte",null,"Date","Header","yyyy-mm-dd","Invoiced Date"]
[null,"COL16","delreq",null,"Numeric","Header",null,"Delay Request Days"]
[null,"COL17","dysdly",null,"Numeric","Header",null,"Delay Approved Days"]
[null,"COL18","chgtyp","**","Numeric","Header",null,"Change Type"]
[null,"COL19","submto",null,"String (50)","Header",null,"Submitted To"]
[null,"COL20","submby","**","Numeric","Header",null,"Submitted By"]
[null,"COL21","hotlst",null,"Numeric","Header","1=Yes;0=No","Hot List"]
[null,"COL22","lckedt",null,"Numeric","Header","1=Yes;0=No","Lock Edit"]
[null,"COL23","upgrde",null,"Numeric","Header","1=Yes;0=No","Upgrade"]
[null,"COL24","ntetxt",null,"Text","Header",null,"Notes"]
[]
[null,"** Validated Field - value must exist in the respective lookup table in Sage 100 Contractor"]
[null,"COL: a placeholder must be provided for each column even if no value is provided "]
[]
[null,"Prime Change Details"]
[null,"COL1","filetype","Required","String (6)","Prime","PJCO","PJCO"]
[null,"COL2","linetype","Required","String (1)","Prime","P","Prime Detail Record"]
[null,"COL3","jobnum","Required","Numeric","Prime",null,"Job No"]
[null,"COL4","chgnum","Required","String (20)","Prime",null,"CO Number"]
[null,"COL5","dscrpt","Required","String (50)","Prime",null,"Line Description"]
[null,"COL6","estamt",null,"Numeric (10,2)","Prime",null,"Estimated Amount"]
[null,"COL7","ovhmrk",null,"Numeric (10,2)","Prime",null,"O/H Rate"]
[null,"COL8","pftmrk",null,"Numeric (10,2)","Prime",null,"Profit Rate"]
[null,"COL9","reqprc","(1)","Numeric (10,2)","Prime",null,"Requested"]
[null,"COL10","aprprc","Required","Numeric (10,2)","Prime",null,"Approved Amount"]
[null,"COL11","cstcde","Required","Numeric(9,3)","Prime",null,"Cost Code"]
[null,"COL12","csttyp","Required **","Numeric","Prime",null,"Cost Type"]
[null,"COL13","usrdf1",null,"String (50)","Prime",null,"User Defined"]
[null,"COL14","ntetxt",null,"Text","Prime",null,"Notes"]
[]
[null,"** Validated Field - value must exist in the respective lookup table in Sage 100 Contractor"]
[null,"COL: a placeholder must be provided for each column even if no value is provided"]
[null,"(1) If O/H Rate or Profit Rate then Request Amt is Calced "]
[]
[null,"Budget and Sub Change Details"]
[null,"COL1","filetype","Required","String (6)","Subcontract","PJCO","PJCO"]
[null,"COL2","linetype","Required","String (1)","Subcontract","S","Budget and Sub Change Detail Record"]
[null,"COL3","jobnum","Required","Numeric","Subcontract",null,"Job No"]
[null,"COL4","chgnum","Required","String (20)","Subcontract",null,"CO Number"]
[null,"COL5","dscrpt","Required","String (50)","Subcontract",null,"Line Description"]
[null,"COL6","chghrs",null,"Numeric (6,2)","Subcontract",null,"Budget Hours"]
[null,"COL7","chgunt",null,"Numeric (8,4)","Subcontract",null,"Budget Units"]
[null,"COL8","bdgprc",null,"Numeric (8,4)","Subcontract",null,"Budget Amount"]
[null,"COL9","vndnum","** (1)","Numeric","Subcontract",null,"Vendor"]
[null,"COL10","vndctc","** (2)","Numeric","Subcontract",null,"Subcontract"]
[null,"COL11","ctclin","** (3)","Numeric","Subcontract",null,"Subcontract Line No"]
[null,"COL12","ctchgnum","(4)","String (20)","Subcontract",null,"Change No"]
[null,"COL13","chgsts","** (5)","Numeric","Subcontract","1-Approved,2-Open,3-Review,4-Disputed,5-Void,6-Rejected","Line Status"]
[null,"COL14","chgdte",null,"Date","Subcontract",null,"Line Change Date"]
[null,"COL15","cstcde","Required **","Numeric(9,3)","Subcontract",null,"Cost Code"]
[null,"COL16","csttyp","Required **","Numeric","Subcontract",null,"Cost Type"]
[null,"COL17","usrdf1",null,"String (50)","Subcontract",null,"User Defined"]
[null,"COL18","ntetxt",null,"Text","Subcontract",null,"Notes"]
[null,"COL19","ovhmrk",null,"Numeric (5,2)","Subcontract",null,"Overhead Rate"]
[]
[null,"** Validated Field - value must exist in the respective lookup table in Sage 100 Contractor"]
[null,"COL: a placeholder must be provided for each column even if no value is provided"]
[null,"(1) Vendor No is required if a subcontract is Entered"]
[null,"(2) Subcontract No is required if a vendor is Entered"]
[null,"(3) If a Subcontract No is entered and and a contract line is not entered a new line will be added to the contract"]
[null,"(4) Change No is required if a subcontract is Entered"]
[null,"(5) Change Status is required if a subcontract is Entered otherwise 0"]
[]
[]
[null,"File Example:"]
[null,"PJCO,H,2017008,CO-2,2019-07-07,Test CO 2,1,,,udf1,udf2,PO2,,,,,,,,,,,,notes"]
[null,"PJCO,P,2017008,CO-2,prime line 1,100,5,10,115.5,100,2020.000,4,udf1,notes"]
[null,"PJCO,P,2017008,CO-2,prime line 2,200,10,10,242,206.04,2010.000,4,udf1,notes"]
[null,"PJCO,S,2017008,CO-2,sub line 1,0,0,150,231,108,1,1,1,44197,2120.000,4,udf1,notes,1"]
[null,"PJCO,S,2017008,CO-2,sub line 2 no contract,0,0,300,,,,,1,44197,2120.000,4,udf1,notes,1"]

{"sheet":"Change Order Form","index":1,"n_rows":28,"n_cols":17,"rows_kept":28,"cut":false,"hidden":false,"merged":[[11,2,11,3],[24,2,24,3],[14,2,14,3]]}
["Sample Change Order Form"]
[]
[]
[null,"Job: *",2017008,"Order Date: *","2019-07-24",null,"Status: *",1]
[null,"Phase: ",null,"Submitted: ",null,null,"Type: "]
[null,"Description: *","CO Test 12","Approved: ",null,null,"Client PO No: "]
[null,"Change No: *","CO 12","Invoiced: ",null,null,"Submitted To: "]
[null,"Reason: ",null,"Delay Request Days: ",null,null,"Submitted By: "]
[null,"User Def 1: ",null,"Delay Approved Days: ",null,null,null,null,false]
[null,"User Def 2:  ",null,null,null,false,null,null,false]
[]
[null,"Notes:",null,null,null,null,false]
[]
[]
[null,null,"Prime Change Details"]
[null,null,"Line Description *","Estimated Amount","O/H Rate ","Profit Rate ","Requested Amount","Approved Amount *","Cost Code *","Cost Type *","User Defined","Notes"]
[null,null,"Prime line 1",null,null,null,null,50,"2010.000","1",null,"xx"]
[null,null,"Prime Line 2",null,null,null,null,100,"2020.000","1",null,"xx"]
[]
[]
[]
[]
[]
[]
[null,null,"Budget and Sub Change Details"]
[null,null,"Line Description *","Budget Hours","Budget Units","Budget Amount","Vendor","Subcontract","Subcontract Line No","Change No","Change Status","Change Date","Cost Code *","Cost Type *","User Defined","Notes","O/H Rate"]
[null,null,"Budget Line 1",null,null,50,null,null,null,null,null,"2010.000","1",null,"yy"]
[null,null,"Budget Line2",null,null,100,null,null,null,null,null,"2020.000","1",null,"yy"]

{"sheet":"Grid Sample","index":2,"n_rows":14,"n_cols":25,"rows_kept":14,"cut":false,"hidden":false,"merged":[]}
["Sample Grid Template"]
[]
[]
[null,"COL1","COL2","COL3","COL4","COL5","COL6","COL7","COL8","COL9","COL10","COL11","COL12","COL13","COL14","COL15","COL16","COL17","COL18","COL19","COL20","COL21","COL22","COL23","COL24"]
[null,"PJCO","H","jobnum","chgnum","chgdte","dscrpt","status","phsnum","reason","usrdf1","usrdf2","pchord","subdte","aprdte","invdte","delreq","dysdly","chgtyp","submto","submby","hotlst","lckedt","upgrde","ntetxt"]
[null,"PJCO","P","jobnum","chgnum","dscrpt","estamt","ovhmrk","pftmrk","reqprc","aprprc","cstcde","csttyp","usrdf1","ntetxt"]
[null,"PJCO","S","jobnum","chgnum","dscrpt","chghrs","chgunt","bdgprc","vndnum","vndctc","ctclin","ctchgnum","chgsts","chgdte","cstcde","csttyp","usrdf1","ntetxt","ovhmrk"]
[]
[]
[null,"PJCO","H",2017008,"CO 13","2019-07-23","CO 13 Test",1]
[null,"PJCO","P",2017008,"CO 13","Prime Line 1 ",null,null,null,100,100,"2010.000","1"]
[null,"PJCO","P",2017008,"CO 13","Prime Line 2",null,null,null,50,50,"2020.000","1"]
[null,"PJCO","S",2017008,"CO 13","Sub Line 1",null,null,200,null,null,null,null,null,null,"2010.000","1"]
[null,"PJCO","S",2017008,"CO 13","Sub Line 2",null,null,150,null,null,null,null,null,null,"2020.000","1"]

{"sheet":"misc","index":3,"n_rows":6,"n_cols":1,"rows_kept":6,"cut":false,"hidden":false,"merged":[]}
["1 - Approved"]
["2 - Open"]
["3 - Review"]
["4 - Disputed"]
["5 - Void"]
["6 - Rejected"]