{"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":6,"rows_kept":95,"cut":false,"hidden":false,"merged":[]}
[null,null,null,null,"version: 2022-08-24"]
[]
[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"]
[null,"COL1","Required","String (6)","PJCO","PJCO"]
[null,"COL2","Required","String (1)","H","Header Record"]
[null,"COL3","Required","Numeric",null,"Job No"]
[null,"COL4","Required","String (20)",null,"CO Number"]
[null,"COL5","Required","Date","yyyy-mm-dd","CO Date"]
[null,"COL6","Required","String (50)",null,"CO Description"]
[null,"COL7","Required **","Numeric","1-Approved,2-Open,3-Review,4-Disputed,5-Void,6-Rejected","CO Status"]
[null,"COL8","**","Numeric",null,"Job Phase No"]
[null,"COL9",null,"String (50)",null,"CO Reason"]
[null,"COL10",null,"String (50)",null,"User Def 1"]
[null,"COL11",null,"String (50)",null,"User Def 2"]
[null,"COL12",null,"String (30)",null,"Client PO No"]
[null,"COL13",null,"Date","yyyy-mm-dd","Submitted Date"]
[null,"COL14",null,"Date","yyyy-mm-dd","Approved Date"]
[null,"COL15",null,"Date","yyyy-mm-dd","Invoiced Date"]
[null,"COL16",null,"Numeric",null,"Delay Request Days"]
[null,"COL17",null,"Numeric",null,"Delay Approved Days"]
[null,"COL18","**","Numeric",null,"Change Type"]
[null,"COL19",null,"String (50)",null,"Submitted To"]
[null,"COL20","**","Numeric",null,"Submitted By"]
[null,"COL21",null,"Numeric","1=Yes;0=No","Hot List"]
[null,"COL22",null,"Numeric","1=Yes;0=No","Lock Edit"]
[null,"COL23",null,"Numeric","1=Yes;0=No","Upgrade"]
[null,"COL24",null,"Text",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"]
[null,"COL1","Required","String (6)","PJCO","PJCO"]
[null,"COL2","Required","String (1)","P","Prime Detail Record"]
[null,"COL3","Required","Numeric",null,"Job No"]
[null,"COL4","Required","String (20)",null,"CO Number"]
[null,"COL5","Required","String (50)",null,"Line Description"]
[null,"COL6",null,"Numeric (10,2)",null,"Estimated Amount"]
[null,"COL7",null,"Numeric (10,2)",null,"O/H Rate"]
[null,"COL8",null,"Numeric (10,2)",null,"Profit Rate"]
[null,"COL9",null,"Numeric (10,2)"]
[null,"COL10","Required","Numeric (10,2)",null,"Approved Amount"]
[null,"COL11","Required","Numeric(9,3)",null,"Cost Code"]
[null,"COL12","Required **","Numeric",null,"Cost Type"]
[null,"COL13",null,"String (50)",null,"User Defined"]
[null,"COL14",null,"Text",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"]
[null,"COL1","Required","String (6)","PJCO","PJCO"]
[null,"COL2","Required","String (1)","S","Prime Detail Record"]
[null,"COL3","Required","Numeric",null,"Job No"]
[null,"COL4","Required","String (20)",null,"CO Number"]
[null,"COL5","Required","String (50)",null,"Line Description"]
[null,"COL6",null,"Numeric (6,2)",null,"Budget Hours"]
[null,"COL7",null,"Numeric (8,4)",null,"Budget Units"]
[null,"COL8",null,"Numeric (8,4)",null,"Budget Amount"]
[null,"COL9","**","Numeric",null,"Vendor (1)"]
[null,"COL10","**","Numeric",null,"Subcontract (2)"]
[null,"COL11","**","Numeric",null,"Subcontract Line No (3)"]
[null,"COL12",null,"String (20)",null,"Change No (4)"]
[null,"COL13","**","Numeric","1-Approved,2-Open,3-Review,4-Disputed,5-Void,6-Rejected (5)","Line Status (5)"]
[null,"COL14",null,"Date",null,"Line Change Date"]
[null,"COL15","Required **","Numeric(9,3)",null,"Cost Code"]
[null,"COL16","Required **","Numeric",null,"Cost Type"]
[null,"COL17",null,"String (50)",null,"User Defined"]
[null,"COL18",null,"Text",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) 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"]
[]
[]
[]
[null,"File Example:"]
[null,"PJCO,H,2017008,CO-2,2019-07-07,Test CO 2,1,,,udf1,udf2,PO2,,,,,,,,,,,,"]
[null,"PJCO,P,2017008,CO-2,prime line 1,100,5,10,115.5,100,2020.000,4,udf1,"]
[null,"PJCO,P,2017008,CO-2,prime line 2,200,10,10,242,206.04,2010.000,4,udf1,"]
[null,"PJCO,S,2017008,CO-2,sub line 1,0,0,150,231,108,1,1,1,,2120.000,4,,"]
[null,"PJCO,S,2017008,CO-2,sub line 2 no contract,0,0,300,,,,,1,,2120.000,4,,"]

{"sheet":"Change Order Form","index":1,"n_rows":28,"n_cols":16,"rows_kept":28,"cut":false,"hidden":false,"merged":[[11,2,11,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 Changes"]
[null,null,"Line Description *","Estimated Amount","O/H Rate ","Profit Rate ","Requested\nAmount (1)","Approved\nAmount *","Cost\nCode *","Cost\nType *","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/Subcontract Changes"]
[null,null,"Line Description *","Budget\nHours","Budget\nUnits","Budget\nAmount","Vendor (1)","Subcontract (2)","Subcontract\nLine No (3)","Change No (4)","Change\nStatus (5)","Change\nDate","Cost\nCode *","Cost\nType *","User Defined","Notes"]
[null,null,"Budget Line 1",null,null,50,null,null,null,null,null,null,"2010.000","1",null,"yy"]
[null,null,"Budget Line2",null,null,100,null,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"]
[]
[]
[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"]