{"text_format":"1","workbook":"xlsx","n_sheets":2,"sheets":["INSTRUCTIONS","STEEL PRICE ADJUST WORKSHEET"],"not_rendered":{"charts":0,"images":1,"macros":1,"external_links":0,"defined_names":4,"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":0,"n_cols":0,"rows_kept":0,"cut":false,"hidden":false,"merged":[]}

{"sheet":"STEEL PRICE ADJUST WORKSHEET","index":1,"n_rows":60,"n_cols":14,"rows_kept":60,"cut":false,"hidden":false,"merged":[[4,1,4,13],[5,1,5,13],[24,3,24,4],[1,2,1,9],[3,2,3,9],[11,1,11,2],[11,3,11,10],[13,8,13,9],[14,8,14,9],[15,8,15,9],[13,10,13,11],[8,6,8,7],[8,3,8,4],[7,3,7,4],[7,6,7,7],[8,1,8,2],[18,3,18,4],[26,3,26,4],[27,3,27,4],[28,3,28,4],[33,3,33,4],[19,3,19,4],[20,3,20,4],[21,3,21,4],[22,3,22,4],[23,3,23,4],[29,3,29,4],[30,3,30,4],[31,3,31,4],[47,3,47,4],[49,9,49,12],[25,3,25,4],[37,3,37,4],[32,3,32,4],[34,3,34,4],[35,3,35,4],[36,3,36,4],[13,4,13,7],[14,10,14,12],[59,4,59,8],[38,3,38,4],[43,3,43,4],[39,3,39,4],[40,3,40,4],[41,3,41,4],[42,3,42,4],[44,3,44,4],[53,4,53,8],[55,4,55,8],[57,4,57,8],[51,4,51,8],[45,3,45,4],[46,3,46,4]]}
["MTC"]
[null,null,"FORM DC 160(S) STEEL PRICE ADJUSTMENT"]
[]
[null,null,"CALCULATION SHEET FOR ENGINEER'S ESTIMATE"]
[null,"For use when the Contract has 1,000,000 pounds (500,000 pounds for Contracts with a 3 year or greater duration from award to completion) of eligible steel Items."]
[null,"Beam Guide Rail, Rub Rail, Overhead Sign Structures and Cantilever Sign Structures may be included without meeting the pound requirement. "]
[]
[null,null,null,"Month",null,null,"Year"]
[null,"FOR THE PERIOD:",null,"November",null,null,2022]
[]
[]
[null,"PROJECT NAME:"]
[]
[null,null,"FEDERAL PROJECT NO. :",null,null,null,null,null,"ESTIMATE NO.:"]
[null,null,"DP NO. :",null,null,null,null,null,"PREPARED BY:"]
[null,null,"JOB NO. :",null,null,null,null,null,"LINE ITEM NO. :"]
[]
[]
[null,null,null,"ITEM",null,null,null,"PRICE INDEX","W","CB","MS","BS",null,"STEEL PRICE ADJUSTMENT"]
[null,null,null,"STRUCTURAL STEEL ",null,null,null,"WPU101704",null,null,null,null,null,{"$f":"IFERROR(IF((K20-L20)/L20>0.1,(((L20-K20)+(L20*0.1))/-L20)*J20*I20,IF((K20-L20)/L20<-0.1,((((K20-L20)+(L20*0.1))/L20)*J20*I20),\"INELIGIBLE\")),0)","v":0}]
[null,null,null,"REINFORCEMENT STEEL",null,null,null,"WPU101702",null,null,null,null,null,0]
[null,null,null,"REINFORCEMENT STEEL, EPOXY-COATED",null,null,null,"WPU101702",null,null,null,null,null,0]
[null,null,null,"REINFORCEMENT STEEL, GALVANIZED",null,null,null,"WPU101702",null,null,null,null,null,0]
[null,null,null,"REINFORCEMENT STEEL, STAINLESS",null,null,null,"WPU101702",null,null,null,null,null,0]
[null,null,null,"CAST-IN-PLACE CONCRETE PILE FURNISHED",null,null,null,"WPU101704",null,null,null,null,null,0]
[null,null,null,"STEEL H-PILE, FURNISHED",null,null,null,"WPU101704",null,null,null,null,null,{"$f":"IFERROR(IF((K26-L26)/L26>0.1,(((L26-K26)+(L26*0.1))/-L26)*J26*I26,IF((K26-L26)/L26<-0.1,((((K26-L26)+(L26*0.1))/L26)*J26*I26),\"INELIGIBLE\")),0)","v":0}]
[null,null,null,"BEAM GUIDE RAIL",null,null,null,"WPU101702",null,null,null,null,null,{"$f":"IFERROR(IF((K27-L27)/L27>0.1,(((L27-K27)+(L27*0.1))/-L27)*J27*I27,IF((K27-L27)/L27<-0.1,((((K27-L27)+(L27*0.1))/L27)*J27*I27),\"INELIGIBLE\")),0)","v":0}]
[null,null,null,"RUB RAIL",null,null,null,"WPU101702",null,null,null,null,null,0]
[null,null,null,"OVERHEAD SIGN STRUCTURE",null,"NO.",null,"WPU101702",null,null,null,null,null,0]
[null,null,null,"OVERHEAD SIGN STRUCTURE",null,"NO.",null,"WPU101702",null,null,null,null,null,0]
[null,null,null,"OVERHEAD SIGN STRUCTURE",null,"NO.",null,"WPU101702",null,null,null,null,null,0]
[null,null,null,"OVERHEAD SIGN STRUCTURE",null,"NO.",null,"WPU101702",null,null,null,null,null,0]
[null,null,null,"OVERHEAD SIGN STRUCTURE",null,"NO.",null,"WPU101702",null,null,null,null,null,0]
[null,null,null,"BUTTERFLY SIGN SUPPORT, DMS STRUCTURE",null,"NO.",null,"WPU101702",null,null,null,null,null,0]
[null,null,null,"BUTTERFLY SIGN SUPPORT, DMS STRUCTURE",null,"NO.",null,"WPU101702",null,null,null,null,null,0]
[null,null,null,"BUTTERFLY SIGN SUPPORT, DMS STRUCTURE",null,"NO.",null,"WPU101702",null,null,null,null,null,0]
[null,null,null,"BUTTERFLY SIGN SUPPORT, DMS STRUCTURE",null,"NO.",null,"WPU101702",null,null,null,null,null,0]
[null,null,null,"BUTTERFLY SIGN SUPPORT, DMS STRUCTURE",null,"NO.",null,"WPU101702",null,null,null,null,null,0]
[null,null,null,"CANTILEVER SIGN STRUCTURE",null,"NO.",null,"WPU101702",null,null,null,null,null,0]
[null,null,null,"CANTILEVER SIGN STRUCTURE",null,"NO.",null,"WPU101702",null,null,null,null,null,0]
[null,null,null,"CANTILEVER SIGN STRUCTURE",null,"NO.",null,"WPU101702",null,null,null,null,null,0]
[null,null,null,"CANTILEVER SIGN STRUCTURE",null,"NO.",null,"WPU101702",null,null,null,null,null,0]
[null,null,null,"CANTILEVER SIGN STRUCTURE",null,"NO.",null,"WPU101702",null,null,null,null,null,0]
[null,null,null,"CANTILEVER SIGN SUPPORT, DMS STRUCTURE",null,"NO.",null,"WPU101702",null,null,null,null,null,0]
[null,null,null,"CANTILEVER SIGN SUPPORT, DMS STRUCTURE",null,"NO.",null,"WPU101702",null,null,null,null,null,0]
[null,null,null,"CANTILEVER SIGN SUPPORT, DMS STRUCTURE",null,"NO.",null,"WPU101702",null,null,null,null,null,0]
[null,null,null,"CANTILEVER SIGN SUPPORT, DMS STRUCTURE",null,"NO.",null,"WPU101702",null,null,null,null,null,0]
[null,null,null,"CANTILEVER SIGN SUPPORT, DMS STRUCTURE",null,"NO.",null,"WPU101702",null,null,null,null,null,0]
[]
[null,null,null,null,null,null,null,null,null,"TOTAL STEEL PRICE ADJUSTMENT, S:",null,null,null,{"$f":"SUM(N20:N48)","v":0}]
[null,null,null,"WHERE:"]
[null,null,null,"S=","Steel Price Adjustment (Dollars)"]
[]
[null,null,null,"BS=","Benchmark Steel Price Index – the steel preliminary price index for the month before the project is bid."]
[]
[null,null,null,"MS=","Monthly Steel Price Index – the steel price index for the month steel is shipped from the mill."]
[]
[null,null,null,"CB=","Cost Basis ($/lb) "]
[]
[null,null,null,"W=","Weight of Steel (lb)"]