{"text_format":"1","workbook":"xlsx","n_sheets":4,"sheets":["Overview","Subcontract Form","Grid Sample","misc"],"not_rendered":{"charts":0,"images":1,"macros":1,"external_links":0,"defined_names":26,"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":63,"n_cols":6,"rows_kept":63,"cut":false,"hidden":false,"merged":[]}
[]
[]
[null,"Project Management - 6-7-1 Subcontracts"]
[]
[null,"The following template should be used to import Subcontracts into Sage 100 Contractor.  "]
[]
[]
[]
[null,"File Layout Specification"]
[]
[null,"Header"]
[null,"COL1","Required","String (4)","PJSC","PJSC"]
[null,"COL2","Required","String (1)","H","Header Record"]
[null,"COL3","Required","String (20)",null,"Contract No"]
[null,"COL4","Required","Date","yyyy-mm-dd","Subcontract Date"]
[null,"COL5","Required **","Numeric",null,"Vendor"]
[null,"COL6","Required **","Numeric",null,"Job No"]
[null,"COL7","Required","String (50)",null,"Subcontract Description"]
[null,"COL8","**","Numeric",null,"Job Phase No"]
[null,"COL9","**","Numeric",null,"Cost Division"]
[null,"COL10",null,"String (50)",null,"User Def 1"]
[null,"COL11",null,"String (50)",null,"User Def 2"]
[null,"COL12","**","Numeric","1-Bid;2-Refused;3-Contract;4-Current;5-Complete;6-Closed","Status"]
[null,"COL13","**","Numeric",null,"Type"]
[null,"COL14",null,"Date","yyyy-mm-dd","Approved Date"]
[null,"COL15",null,"Date","yyyy-mm-dd","Sched Start Date"]
[null,"COL16",null,"Date","yyyy-mm-dd","Sched End Date"]
[null,"COL17",null,"Date","yyyy-mm-dd","Actual Start Date"]
[null,"COL18",null,"Date","yyyy-mm-dd","Subst Complete Date"]
[null,"COL19",null,"Date","yyyy-mm-dd","Actual Finish Date"]
[null,"COL20",null,"Numeric (10,2)",null,"Retention"]
[null,"COL21",null,"Numeric (10,2)",null,"Bid Bond"]
[null,"COL22",null,"Numeric (10,2)",null,"Perf. Bond"]
[null,"COL23",null,"Numeric","1=Yes;0=No","Hot List"]
[null,"COL24",null,"Numeric","1=Yes;0=No","Hold Payment"]
[null,"COL25",null,"Numeric","1=Yes;0=No","Lock Edit"]
[null,"COL26",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,"Details"]
[null,"COL1","Required","String (4)","PJSC","PJSC"]
[null,"COL2","Required","String (1)","D","Detail Record"]
[null,"COL3","Required","String (20)","(same as header)","Contract No"]
[null,"COL4","Required","String (50)",null,"Line Description"]
[null,"COL5","Required **","Numeric(9,3)",null,"Cost Code"]
[null,"COL6","Required **","Numeric","1-Mat,2-Lab,3-equip,4-sub,5-oth,6-udf,7-udf,8-udf,9-udf","Cost Type"]
[null,"COL7",null,"Numeric(10,2)",null,"Line Amount"]
[null,"COL8",null,"String (1)","Y or N for Canada; blank for US","Subject to GST (Canada)"]
[null,"COL9",null,"String (1)","Y or N for Canada; blank for US","Subject to PST (Canada)"]
[null,"COL10",null,"String (1)","Y or N for Canada; blank for US","Subject to HST (Canada)"]
[null,"COL11",null,"String (50)",null,"User Defined"]
[null,"COL12",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,"File Example:"]
[null,"PJSC,H,CN-101,2019-07-05,231,2017008,CN Contract 101,,,udf1,udf2,1,,,,,,,,,,,,,,"]
[null,"PJSC,D,CN-101,Line 1,2120.000,4,99,,,,udf line 1,notes"]
[null,"PJSC,D,CN-101,Line 2,2140.000,4,58,,,,udf line 2,notes"]

{"sheet":"Subcontract Form","index":1,"n_rows":19,"n_cols":11,"rows_kept":19,"cut":false,"hidden":false,"merged":[[12,2,12,3]]}
["Sample Subcontract Form"]
[]
[]
[null,"Job Number: *",2017008,null,"Subcontract Date: *","2019-07-20","Status: *",3]
[null,"Phase: ",null,null,"Approved:",null,"Type: "]
[null,"Vendor: *",231,null,"Scheduled Start:",null,"Perf. Bond:"]
[null,"Subcontract #: *","SC TEST 1",null,"Scheduled Finish:",null,"Bid Bond:"]
[null,"Description: *","Test 1 SC",null,"Actual Start:",null,"Retention:"]
[null,"Cost Division: ",null,null,"Subst Complete:"]
[null,"User Def 1: ",null,null,"Actual Finish:"]
[null,"User Def 2: ",null,null,"","",false]
[null,null,null,null,null,null,false]
[null,"Notes:",null,null,null,null,false]
[]
[]
[null,null,null,null,null,{"$f":"SUM(F18:F6000)","v":360}]
[null,null,"Line Description *","Cost Code *","Cost Type *","Line Amount","Subject to GST\n(Canada)","Subject to\nPST\n(Canada)","Subject to\nHST\n(Canada)","User Defined","Notes"]
[null,null,"SC Line 1","2100.000",4,120]
[null,null,"SC Line 2","2120.000",4,240]

{"sheet":"Grid Sample","index":2,"n_rows":11,"n_cols":27,"rows_kept":11,"cut":false,"hidden":false,"merged":[]}
["Sample 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","COL25","COL26"]
[null,"PJSC","H","ctcnum","condte","vndnum","jobnum","dscrpt","phsnum","divnum","usrdf1","usrdf2","status","contyp","appdte","orgstr","orgfin","strdte","subcmp","findte","rtnrte","pmtbnd","prfbnd","hotlst","paysts","lckedt","ntetxt"]
[null,"PJSC","D","ctcnum","dscrpt","cstcde","csttyp","amount","gstsbj","pstsbj","hstsbj","usrdf1","ntetxt"]
[]
[]
[null,"PJSC","H","SC Test #1","2017-07-20",231,2017008,"Test 1 SC",null,null,null,null,3,null,null,null,null,null,null,null,null,null,null,null,null,null,"xx"]
[null,"PJSC","D","SC Test #1","SC Line 1","2100.000",4,120,null,null,null,null,"z"]
[null,"PJSC","D","SC Test #1","SC Line 2","2120.000",4,240,null,null,null,null,"z"]

{"sheet":"misc","index":3,"n_rows":9,"n_cols":4,"rows_kept":9,"cut":false,"hidden":false,"merged":[]}
["1 - Bid",null,null,"1 - Mat"]
["2 - Refused",null,null,"2 - Lab"]
["3 - Contract",null,null,"3 - Equip"]
["4 - Current",null,null,"4 - Sub"]
["5 - Complete",null,null,"5 - Other"]
["6 - Closed",null,null,"6 - Udf 6"]
[null,null,null,"7 - Udf 7"]
[null,null,null,"8 - Udf 8"]
[null,null,null,"9 - Udf 9"]