{"text_format":"1","workbook":"xlsx","n_sheets":2,"sheets":["INSTRUCTIONS","SPA (No-Bid) Calc"],"not_rendered":{"charts":0,"images":0,"macros":1,"external_links":0,"defined_names":0,"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":"INSTRUCTIONS","index":0,"n_rows":12,"n_cols":1,"rows_kept":12,"cut":false,"hidden":false,"merged":[]}
["Include Steel Price Adjustment (NO-BID) as a pay item when: \n(a) the Contract has 1,000,000 pounds of eligible steel items (or 500,000 pounds for Contracts with a 3 year or greater duration from award to completion), or \n(b) when Beam Guide Rail, Rub Rail, Overhead Span Sign Support Structures or Overhead Cantilever Sign Support Structures are pay items; these are not subject to the minimum weight requirement; include price adjustment for any quantity of these items. These items count towards the total weight when determining the eligibility of other steel items. Ineligible items will not count towards the price adjustment calculation. \n\nOnly pay items listed in Subsection 108.11, Table 108-2 are eligible for adjustment. \n\nRevise Subsection 108.11, Table 108-2 to identify which items steel price adjustment will apply to based on the calculation. "]
[]
["Complete the yellow cells in this Form accordingly."]
[]
["The latest cost basis values can be obtained from the NJDOT Steel Price Index webpage:\n"]
["https://www.nj.gov/transportation/business/aashtoware/SteelPriceIndex.shtm"]
["Select the cost basis (CB) value for each item based on the associated price index (WPU101702 or WPU101704)"]
[]
["The Index Period is the latest published Month and Year on the Steel Price Index webpage."]
[]
["For Columns E and F, use the Preliminary PPI value if Final PPI value has not yet been published."]
["For Column F, compare the latest published PPI against the last 12 months of PPI for that associated price index; use the value that has the largest difference (delta)."]

{"sheet":"SPA (No-Bid) Calc","index":1,"n_rows":34,"n_cols":9,"rows_kept":34,"cut":false,"hidden":false,"merged":[[33,2,33,8],[0,0,0,8],[32,2,32,8],[22,0,22,1],[23,0,23,1],[24,0,24,1],[25,0,25,1]]}
["STEEL PRICE ADJUSTMENT CALCULATION SHEET DURING DESIGN\n[Note to Engineer: Refer to the INSTRUCTIONS tab and Specifications Subsection 108.11.]"]
["INDEX PERIOD MONTH:","July"]
["INDEX PERIOD YEAR:",2025]
["CONTRACT NO.:"]
["CONTRACT TITLE:"]
["PREPARED BY:"]
["DATE PREPARED:"]
["ITEM","PRICE INDEX","W","CB for INDEX PERIOD MONTH","PPI for INDEX PERIOD MONTH","PPI in Last 12 Months with Largest Delta from Index Period ","ELIGIBLE?","STEEL PRICE ADJUSTMENT, S"]
["STRUCTURAL STEEL ","WPU101704",8750000,0.55000000000000004,280,250,{"$f":"IF(C9>0,IF($C$28>999999,\"YES\",IF(AND($C$28>499999,#REF!>35),\"YES\",\"NO\")),\"\")","v":"YES"},{"$f":"IF(G9=\"YES\",IF(ABS(E9-F9)/E9>0.1,C9*D9*(ABS(E9-F9)-F9*0.1)/F9,C9*D9*(0.1+F9*0.1)/F9),0)","v":96250}]
["REINFORCEMENT STEEL","WPU101702",null,null,null,null,{"$f":"IF(C10>0,IF($C$28>999999,\"YES\",IF(AND($C$28>499999,#REF!>35),\"YES\",\"NO\")),\"\")","v":""},{"$f":"IF(G10=\"YES\",IF(ABS(E10-F10)/E10>0.1,C10*D10*(ABS(E10-F10)-F10*0.1)/F10,C10*D10*(0.1+F10*0.1)/F10),0)","v":0}]
["REINFORCEMENT STEEL, EPOXY-COATED","WPU101702",null,null,null,null,{"$f":"IF(C11>0,IF($C$28>999999,\"YES\",IF(AND($C$28>499999,#REF!>35),\"YES\",\"NO\")),\"\")","v":""},0]
["REINFORCEMENT STEEL, GALVANIZED","WPU101702",null,null,null,null,{"$f":"IF(C12>0,IF($C$28>999999,\"YES\",IF(AND($C$28>499999,#REF!>35),\"YES\",\"NO\")),\"\")","v":""},0]
["REINFORCEMENT STEEL, STAINLESS STEEL","WPU101702",null,null,null,null,{"$f":"IF(C13>0,IF($C$28>999999,\"YES\",IF(AND($C$28>499999,#REF!>35),\"YES\",\"NO\")),\"\")","v":""},0]
["FURNISHING STEEL PILES","WPU101704",null,null,null,null,{"$f":"IF(C14>0,IF($C$28>999999,\"YES\",IF(AND($C$28>499999,#REF!>35),\"YES\",\"NO\")),\"\")","v":""},0]
["BEAM GUIDE RAIL","WPU101704",null,null,null,null,{"$f":"IF(C15>0,\"YES\",\"\")","v":""},0]
["RUB RAIL","WPU101702",null,null,null,null,{"$f":"IF(C16>0,\"YES\",\"\")","v":""},0]
["OVERHEAD SPAN SIGN STRUCTURE","WPU101702",null,null,null,null,{"$f":"IF(C17>0,\"YES\",\"\")","v":""},0]
["OVERHEAD CANTILEVER SIGN SUPPORT STRUCTURE","WPU101702",null,null,null,null,{"$f":"IF(C18>0,\"YES\",\"\")","v":""},0]
["OVERHEAD SIGN STRUCTURE",null,"WPU101702",null,null,null,null,{"$f":"IF(G19=\"YES\",IF(ABS(E19-F19)/E19>0.1,C19*D19*((ABS(E19-F19)+E19*0.1))/E19,C19*D19*(0.1+E19*0.1)/E19),0)","v":0},{"$f":"IF(H19=\"YES\",IF((((#REF!*#REF!/12)-0.1)*E19*G19)>0.01,((#REF!*#REF!/12)-0.1)*E19*G19,0.001*E19*G19),0)","v":0}]
["OVERHEAD SIGN STRUCTURE",null,"WPU101702",null,null,null,null,0,{"$f":"IF(H20=\"YES\",IF((((#REF!*#REF!/12)-0.1)*E20*G20)>0.01,((#REF!*#REF!/12)-0.1)*E20*G20,0.001*E20*G20),0)","v":0}]
["OVERHEAD SIGN STRUCTURE",null,"WPU101702",null,null,null,null,0,{"$f":"IF(H21=\"YES\",IF((((#REF!*#REF!/12)-0.1)*E21*G21)>0.01,((#REF!*#REF!/12)-0.1)*E21*G21,0.001*E21*G21),0)","v":0}]
["OVERHEAD SIGN STRUCTURE",null,"WPU101702",null,null,null,null,0,{"$f":"IF(H22=\"YES\",IF((((#REF!*#REF!/12)-0.1)*E22*G22)>0.01,((#REF!*#REF!/12)-0.1)*E22*G22,0.001*E22*G22),0)","v":0}]
["CANTILEVER SIGN SUPPORT, DMS STRUCTURE",null,"WPU101702",null,null,null,null,0,{"$f":"IF(H23=\"YES\",IF((((#REF!*#REF!/12)-0.1)*E23*G23)>0.01,((#REF!*#REF!/12)-0.1)*E23*G23,0.001*E23*G23),0)","v":0}]
["CANTILEVER SIGN SUPPORT, DMS STRUCTURE",null,"WPU101702",null,null,null,null,0,{"$f":"IF(H24=\"YES\",IF((((#REF!*#REF!/12)-0.1)*E24*G24)>0.01,((#REF!*#REF!/12)-0.1)*E24*G24,0.001*E24*G24),0)","v":0}]
["CANTILEVER SIGN SUPPORT, DMS STRUCTURE",null,"WPU101702",null,null,null,null,0,{"$f":"IF(H25=\"YES\",IF((((#REF!*#REF!/12)-0.1)*E25*G25)>0.01,((#REF!*#REF!/12)-0.1)*E25*G25,0.001*E25*G25),0)","v":0}]
["CANTILEVER SIGN SUPPORT, DMS STRUCTURE",null,"WPU101702",null,null,null,null,0,{"$f":"IF(H26=\"YES\",IF((((#REF!*#REF!/12)-0.1)*E26*G26)>0.01,((#REF!*#REF!/12)-0.1)*E26*G26,0.001*E26*G26),0)","v":0}]
[]
[null,"TOTAL WEIGHT (LBS):",{"$f":"SUM(C9:C26)","v":8750000},null,null,null,"TOTAL STEEL PRICE ADJUSTMENT, S:",{"$f":"IF(SUM(H9:H26)>100,SUM(H9:H26),IF(SUM(H9:H26)>0,100,0))","v":96250}]
[]
[null,"WHERE:"]
[null,"S=","Steel Price Adjustment (Dollars)"]
[null,"CB=","Cost Basis ($/lb) "]
[null,"W=","Weight of Steel (lb)"]
[null,"PPI=","Producer Price Index from NJDOT's webpage "]