{"text_format":"3","workbook":"xls","n_sheets":1,"sheets":["Metcalf and I-435"],"not_rendered":{"macros":1,"external_links":1,"defined_names":5},"read":"whole","date_system":"1900","formulas":"cached_only"}

{"sheet":"Metcalf and I-435","index":0,"n_rows":73,"n_cols":10,"rows_kept":73,"merged":[[7,1,9,1],[7,2,9,2],[7,3,9,3]],"flags":["formulas_cached_only"]}
["Project: Metcalf Avenue and I-435 Intersection Improvements"]
["KDOT Project No: 46 N-0213-01"]
["Pay Estimate No.: Final"]
["Period Ending: 9-6-01"]
["Contractor: APAC-Kansas, Inc. - Reno Construction Division"]
[]
[]
[null,"Item Description","Unit","Quantity",null,"Non-Partic.","Participating"]
["Item",{"$nulls":3},"Unit","Quantity","Quantity","Non-Partic.","Participating","Grand"]
["No.",{"$nulls":3},"Price","Complete","Complete","Total","Total","Total"]
[1,"Force Account (Set)","LS",1,{"v":20000,"d":"$20,000.00"},null,{"v":0.1375,"d":"13.75%"},null,{"v":2750,"d":"$2,750.00"},{"v":2750,"d":"$2,750.00"}]
[null,"Permanent seeding of disturbed areas","Letter 8-14-01",null,{"v":2750,"d":"$2,750.00"}]
[null,"Total Force Account",null,null,{"v":2750,"d":"$2,750.00"}]
[]
[2,"Removal Of Existing Structures","LS",1,{"v":63700,"d":"$63,700.00"},null,{"v":1,"d":"1.00"},null,{"v":63700,"d":"$63,700.00"},{"v":63700,"d":"$63,700.00"}]
[3,"Embankment (Contractor Furnished)","LS",1,{"v":2000,"d":"$2,000.00"},null,{"v":1,"d":"1.00"},null,{"v":2000,"d":"$2,000.00"},{"v":2000,"d":"$2,000.00"}]
[4,"Fly Ash","Megagram",33,{"v":35,"d":"$35.00"},null,{"v":33,"d":"33.00"},null,{"v":1155,"d":"$1,155.00"},{"v":1155,"d":"$1,155.00"}]
[5,"Manipulation for Fly Ash treated Subgrade","Square Meter",586,{"v":13.5,"d":"$13.50"},null,{"v":586,"d":"586.00"},null,{"v":7911,"d":"$7,911.00"},{"v":7911,"d":"$7,911.00"}]
[6,"Asphaltic Concrete Surface Course","Megagram",92,{"v":98.7,"d":"$98.70"},null,{"v":129.9,"d":"129.90"},null,{"v":12821.13,"d":"$12,821.13"},{"v":12821.13,"d":"$12,821.13"}]
[7,"Asphaltic Concrete Intermediate Course","Megagram",323,{"v":98.45,"d":"$98.45"},null,314.07,null,{"v":30920.19,"d":"$30,920.19"},{"v":30920.19,"d":"$30,920.19"}]
[8,"Milling (3.4m x 40mm)","Square Meter",459,{"v":9.8,"d":"$9.80"},null,{"v":459,"d":"459.00"},null,{"v":4498.2,"d":"$4,498.20"},{"v":4498.2,"d":"$4,498.20"}]
[9,"Street Washing","Lane Kilometer",0.3,{"v":2000,"d":"$2,000.00"},null,{"v":0.3,"d":"0.30"},null,{"v":600,"d":"$600.00"},{"v":600,"d":"$600.00"}]
[10,"Curb and Gutter, Combined (Type B) (AE)","Meter",152,{"v":63.75,"d":"$63.75"},null,160.48,null,{"v":10230.6,"d":"$10,230.60"},{"v":10230.6,"d":"$10,230.60"}]
[11,"Curb and Gutter, Combined (AE)","Meter",20,{"v":63.75,"d":"$63.75"},null,{"v":20,"d":"20.00"},null,{"v":1275,"d":"$1,275.00"},{"v":1275,"d":"$1,275.00"}]
[12,"Concrete Median Nose","Each",2,{"v":2100,"d":"$2,100.00"},null,{"v":1,"d":"1.00"},null,{"v":2100,"d":"$2,100.00"},{"v":2100,"d":"$2,100.00"}]
[13,"Concrete Paver Stones","Square Meter",467,{"v":67.8,"d":"$67.80"},null,{"v":467,"d":"467.00"},null,{"v":31662.6,"d":"$31,662.60"},{"v":31662.6,"d":"$31,662.60"}]
[14,"Sidewalk Construction (AE) (100mm)","Square Meter",11.5,{"v":237.3,"d":"$237.30"},null,23.29,null,{"v":5526.72,"d":"$5,526.72"},{"v":5526.72,"d":"$5,526.72"}]
[15,"Traffic Signal Installation (Metcalf / 107th)","LS",1,{"v":48800,"d":"$48,800.00"},null,{"v":1,"d":"1.00"},null,{"v":48800,"d":"$48,800.00"},{"v":48800,"d":"$48,800.00"}]
[16,"Traffic Signal Modification (Metcalf / S. of I-435)","LS",1,{"v":96800,"d":"$96,800.00"},null,{"v":1,"d":"1.00"},null,{"v":96800,"d":"$96,800.00"},{"v":96800,"d":"$96,800.00"}]
[17,"Permanent Signing","LS",1,{"v":975,"d":"$975.00"},null,{"v":1,"d":"1.00"},null,{"v":975,"d":"$975.00"},{"v":975,"d":"$975.00"}]
[18,"Traffic Control","LS",1,{"v":16100,"d":"$16,100.00"},null,{"v":1,"d":"1.00"},null,{"v":16100,"d":"$16,100.00"},{"v":16100,"d":"$16,100.00"}]
[19,"100mm White Line (Thermoplastic)","Meter",152,{"v":6.9,"d":"$6.90"},null,153.01,null,{"v":1055.77,"d":"$1,055.77"},{"v":1055.77,"d":"$1,055.77"}]
[20,"600mm White Stop Line (Thermoplastic)","Meter",43,{"v":10.6,"d":"$10.60"},null,{"v":38.4,"d":"38.40"},null,{"v":407.04,"d":"$407.04"},{"v":407.04,"d":"$407.04"}]
[21,"Thru-Traffic Arrows (Preformed Thermoplastic)","Each",2,{"v":320,"d":"$320.00"},null,{"v":2,"d":"2.00"},null,{"v":640,"d":"$640.00"},{"v":640,"d":"$640.00"}]
[22,"Water Pollution Control (Soil Erosion)(Set)","LS",1,{"v":2000,"d":"$2,000.00"},null,{"v":0,"d":"0.00"},null,{"v":0,"d":"$0.00"},{"v":0,"d":"$0.00"}]
[23,"Kentucky Bluegrass Sod","Square Meter",530,{"v":8.4,"d":"$8.40"},null,{"v":0,"d":"0.00"},null,{"v":0,"d":"$0.00"},{"v":0,"d":"$0.00"}]
[24,"Project Sign (City-Type 1)","Each",1,{"v":500,"d":"$500.00"},{"v":1,"d":"1.00"},null,{"v":500,"d":"$500.00"},{"v":0,"d":"$0.00"},{"v":500,"d":"$500.00"}]
[25,"Contractor Construction Staking","LS",1,{"v":2800,"d":"$2,800.00"},null,{"v":1,"d":"1.00"},null,{"v":2800,"d":"$2,800.00"},{"v":2800,"d":"$2,800.00"}]
[]
[]
[]
[null,"Change Order No. 1    Deduction  7-27-01    ","LS",1,{"v":-1125,"d":"-$1,125.00"},null,{"v":1,"d":"1.00"},null,{"v":-1125,"d":"$(1,125.00)"},{"v":-1125,"d":"-$1,125.00"}]
[null,"Early Incentive Bonus @$3000 per 24 hr. period","Each","-",{"v":3000,"d":"$3,000.00"},{"v":16,"d":"16.00"},null,{"v":48000,"d":"$48,000.00"},null,{"v":48000,"d":"$48,000.00"}]
[]
[{"$nulls":4},"Total to Date:",null,null,{"v":48500,"d":"$48,500.00"},{"v":343603.25,"d":"$343,603.25"},{"v":392103.25,"d":"$392,103.25"}]
[]
[{"$nulls":4},"Less 0% Retainage:",null,null,0,0,0]
[{"$nulls":4},"Subtotal:",null,null,{"v":48500,"d":"$48,500.00"},{"v":343603.25,"d":"$343,603.25"},{"v":392103.25,"d":"$392,103.25"}]
[]
[{"$nulls":4},"Pay Estimate No. 1",null,null,{"v":450,"d":"$450.00"},{"v":306767.925,"d":"$306,767.93"},{"v":307217.925,"d":"$307,217.93"}]
[]
[{"$nulls":4},"Less Previous Payments",null,null,{"v":450,"d":"$450.00"},{"v":306767.925,"d":"$306,767.93"},{"v":307217.925,"d":"$307,217.93"}]
["Approved:"]
[{"$nulls":4},"Total Amount Due:",null,null,{"v":48050,"d":"$48,050.00"},{"v":36835.32500000001,"d":"$36,835.33"},{"v":84885.32500000001,"d":"$84,885.33"}]
["                                                                                                        ",null,"                    "]
["Contractor",null,"Date"]
[{"$nulls":4},"65.9% of KDOT Participating Total",{"$nulls":3},{"v":24274.479175000008,"d":"$24,274.48"}]
["                                                                                                        ",null,"                     "]
["Project Engineer",null,"Date",null,"Max. KDOT Participation = $240,000"]
[]
["                                                                                                        ",null,"                    "]
["Project Inspector",null,"Date"]
[]
[]
[null,null,"mlm","             "]
[]
[null,"Work Type Summary"]
[]
[null,"Common Items",{"$nulls":5},{"v":48000,"d":"$48,000.00"},{"v":66500,"d":"$66,500.00"},{"v":114500,"d":"$114,500.00"}]
[null,"Roadway",{"$nulls":5},{"v":500,"d":"$500.00"},{"v":74722.73,"d":"$74,722.73"},{"v":75222.73,"d":"$75,222.73"}]
[null,"Surfacing",{"$nulls":6},{"v":56780.51999999999,"d":"$56,780.52"},{"v":56780.51999999999,"d":"$56,780.52"}]
[null,"Bridges"]
[null,"Traffic Signals",{"$nulls":6},{"v":145600,"d":"$145,600.00"},{"v":145600,"d":"$145,600.00"}]