Delete Rows using a Macro

[jrhguez]

from the report below I would like to create a macro that deletes all rows that make up the Total Amounts. In other words, I just want to show the total (bold on black)...thank you

[TABLE="width: 1655"]
<colgroup><col><col span="13"></colgroup><tbody>[TR]
[TD]Category[/TD]
[TD]Original Budget[/TD]
[TD]JV Change Order[/TD]
[TD]Revised Budget[/TD]
[TD]Commited[/TD]
[TD]Other Costs[/TD]
[TD]Current Projection[/TD]
[TD]Cost Incurred to Date[/TD]
[TD]Balance Complete[/TD]
[TD]Variance Current Month[/TD]
[TD]Variance Project to Date[/TD]
[TD]Cost Per Unit[/TD]
[TD]Cost Per Sq. Ft.[/TD]
[TD]% Complete[/TD]
[/TR]
[TR]
[TD]GENERAL CONDITIONS[/TD]
[TD] [/TD]
[TD] [/TD]
[TD] [/TD]
[TD] [/TD]
[TD] [/TD]
[TD] [/TD]
[TD] [/TD]
[TD] [/TD]
[TD] [/TD]
[TD] [/TD]
[TD] [/TD]
[TD] [/TD]
[TD] [/TD]
[/TR]
[TR]
[TD]Construction Payroll[/TD]
[TD]1,925,000.00[/TD]
[TD]277,052.00[/TD]
[TD]2,202,052.00[/TD]
[TD]0.00[/TD]
[TD]2,892,778.57[/TD]
[TD]2,892,778.57[/TD]
[TD]2,878,247.37[/TD]
[TD]14,531.20[/TD]
[TD](35,000.00)[/TD]
[TD]690,726.57[/TD]
[TD]9,242.10[/TD]
[TD]6.41[/TD]
[TD]99.50[/TD]
[/TR]
[TR]
[TD]Construction Travel[/TD]
[TD]20,000.00[/TD]
[TD]0.00[/TD]
[TD]20,000.00[/TD]
[TD]0.00[/TD]
[TD]43,943.86[/TD]
[TD]43,943.86[/TD]
[TD]43,943.86[/TD]
[TD]0.00[/TD]
[TD]0.00[/TD]
[TD]23,943.86[/TD]
[TD]140.40[/TD]
[TD]0.10[/TD]
[TD]100.00[/TD]
[/TR]
[TR]
[TD]Relocation Moving Expenses[/TD]
[TD]0.00[/TD]
[TD]0.00[/TD]
[TD]0.00[/TD]
[TD]0.00[/TD]
[TD]5,651.31[/TD]
[TD]5,651.31[/TD]
[TD]5,651.31[/TD]
[TD]0.00[/TD]
[TD]0.00[/TD]
[TD]5,651.31[/TD]
[TD]18.06[/TD]
[TD]0.01[/TD]
[TD]100.00[/TD]
[/TR]
[TR]
[TD]Recruiting Costs[/TD]
[TD]60,000.00[/TD]
[TD]0.00[/TD]
[TD]60,000.00[/TD]
[TD]0.00[/TD]
[TD]104,662.74[/TD]
[TD]104,662.74[/TD]
[TD]104,662.74[/TD]
[TD]0.00[/TD]
[TD]0.00[/TD]
[TD]44,662.74[/TD]
[TD]334.39[/TD]
[TD]0.23[/TD]
[TD]100.00[/TD]
[/TR]
[TR]
[TD]Office Supplies[/TD]
[TD]19,200.00[/TD]
[TD]0.00[/TD]
[TD]19,200.00[/TD]
[TD]0.00[/TD]
[TD]23,680.82[/TD]
[TD]23,680.82[/TD]
[TD]23,680.82[/TD]
[TD]0.00[/TD]
[TD]0.00[/TD]
[TD]4,480.82[/TD]
[TD]75.66[/TD]
[TD]0.05[/TD]
[TD]100.00[/TD]
[/TR]
[TR]
[TD]Postage & Delivery[/TD]
[TD]8,400.00[/TD]
[TD]0.00[/TD]
[TD]8,400.00[/TD]
[TD]0.00[/TD]
[TD]4,776.92[/TD]
[TD]4,776.92[/TD]
[TD]4,776.92[/TD]
[TD]0.00[/TD]
[TD]0.00[/TD]
[TD](3,623.08)[/TD]
[TD]15.26[/TD]
[TD]0.01[/TD]
[TD]100.00[/TD]
[/TR]
[TR]
[TD]Cell Phones[/TD]
[TD]21,600.00[/TD]
[TD]0.00[/TD]
[TD]21,600.00[/TD]
[TD]0.00[/TD]
[TD]22,147.86[/TD]
[TD]22,147.86[/TD]
[TD]22,147.86[/TD]
[TD]0.00[/TD]
[TD]0.00[/TD]
[TD]547.86[/TD]
[TD]70.76[/TD]
[TD]0.05[/TD]
[TD]100.00[/TD]
[/TR]
[TR]
[TD]Relations[/TD]
[TD]24,000.00[/TD]
[TD]0.00[/TD]
[TD]24,000.00[/TD]
[TD]0.00[/TD]
[TD]7,782.69[/TD]
[TD]7,782.69[/TD]
[TD]7,782.69[/TD]
[TD]0.00[/TD]
[TD]0.00[/TD]
[TD](16,217.31)[/TD]
[TD]24.86[/TD]
[TD]0.02[/TD]
[TD]100.00[/TD]
[/TR]
[TR]
[TD]Legal Fees[/TD]
[TD]20,000.00[/TD]
[TD]0.00[/TD]
[TD]20,000.00[/TD]
[TD]0.00[/TD]
[TD]147,818.60[/TD]
[TD]147,818.60[/TD]
[TD]147,818.60[/TD]
[TD]0.00[/TD]
[TD]0.00[/TD]
[TD]127,818.60[/TD]
[TD]472.26[/TD]
[TD]0.33[/TD]
[TD]100.00[/TD]
[/TR]
[TR]
[TD]Plans & Printing[/TD]
[TD]30,000.00[/TD]
[TD]8,000.00[/TD]
[TD]38,000.00[/TD]
[TD]0.00[/TD]
[TD]33,090.58[/TD]
[TD]33,090.58[/TD]
[TD]33,090.58[/TD]
[TD]0.00[/TD]
[TD]0.00[/TD]
[TD](4,909.42)[/TD]
[TD]105.72[/TD]
[TD]0.07[/TD]
[TD]100.00[/TD]
[/TR]
[TR]
[TD]Office Trailers & Storage[/TD]
[TD]62,700.00[/TD]
[TD]0.00[/TD]
[TD]62,700.00[/TD]
[TD]586.22[/TD]
[TD]39,705.76[/TD]
[TD]40,291.98[/TD]
[TD]40,291.98[/TD]
[TD]0.00[/TD]
[TD]0.00[/TD]
[TD](22,408.02)[/TD]
[TD]128.73[/TD]
[TD]0.09[/TD]
[TD]100.00[/TD]
[/TR]
[TR]
[TD]Office Equipment[/TD]
[TD]35,000.00[/TD]
[TD]0.00[/TD]
[TD]35,000.00[/TD]
[TD]0.00[/TD]
[TD]61,890.91[/TD]
[TD]61,890.91[/TD]
[TD]61,890.91[/TD]
[TD]0.00[/TD]
[TD]0.00[/TD]
[TD]26,890.91[/TD]
[TD]197.73[/TD]
[TD]0.14[/TD]
[TD]100.00[/TD]
[/TR]
[TR]
[TD]Office Electricity[/TD]
[TD]8,400.00[/TD]
[TD]0.00[/TD]
[TD]8,400.00[/TD]
[TD]0.00[/TD]
[TD]11,916.71[/TD]
[TD]11,916.71[/TD]
[TD]11,916.71[/TD]
[TD]0.00[/TD]
[TD]0.00[/TD]
[TD]3,516.71[/TD]
[TD]38.07[/TD]
[TD]0.03[/TD]
[TD]100.00[/TD]
[/TR]
[TR]
[TD]Office Water[/TD]
[TD]8,776.00[/TD]
[TD]0.00[/TD]
[TD]8,776.00[/TD]
[TD]0.00[/TD]
[TD]9,810.08[/TD]
[TD]9,810.08[/TD]
[TD]9,810.08[/TD]
[TD]0.00[/TD]
[TD]0.00[/TD]
[TD]1,034.08[/TD]
[TD]31.34[/TD]
[TD]0.02[/TD]
[TD]100.00[/TD]
[/TR]
[TR]
[TD]TOTAL GENERAL CONDITIONS[/TD]
[TD]2,243,076.00[/TD]
[TD]285,052.00[/TD]
[TD]2,528,128.00[/TD]
[TD]586.22[/TD]
[TD]3,409,657.41[/TD]
[TD]3,410,243.63[/TD]
[TD]3,395,712.43[/TD]
[TD]14,531.20[/TD]
[TD](35,000.00)[/TD]
[TD]882,115.63[/TD]
[TD]10,895.35[/TD]
[TD]7.55[/TD]
[TD]99.57[/TD]
[/TR]
[TR]
[TD]SITE WORK[/TD]
[TD] [/TD]
[TD] [/TD]
[TD] [/TD]
[TD] [/TD]
[TD] [/TD]
[TD] [/TD]
[TD] [/TD]
[TD] [/TD]
[TD] [/TD]
[TD] [/TD]
[TD] [/TD]
[TD] [/TD]
[TD] [/TD]
[/TR]
[TR]
[TD]Miscellaneous Site Work[/TD]
[TD]70,000.00[/TD]
[TD]0.00[/TD]
[TD]70,000.00[/TD]
[TD]63,392.39[/TD]
[TD]7,701.77[/TD]
[TD]71,094.16[/TD]
[TD]71,094.16[/TD]
[TD]0.00[/TD]
[TD]0.00[/TD]
[TD]1,094.16[/TD]
[TD]227.14[/TD]
[TD]0.16[/TD]
[TD]100.00[/TD]
[/TR]
[TR]
[TD]Street Lights[/TD]
[TD]0.00[/TD]
[TD]0.00[/TD]
[TD]0.00[/TD]
[TD]0.00[/TD]
[TD]66,500.18[/TD]
[TD]66,500.18[/TD]
[TD]66,500.18[/TD]
[TD]0.00[/TD]
[TD]0.00[/TD]
[TD]66,500.18[/TD]
[TD]212.46[/TD]
[TD]0.15[/TD]
[TD]100.00[/TD]
[/TR]
[TR]
[TD]Earthwork[/TD]
[TD]1,682,348.00[/TD]
[TD]161,493.61[/TD]
[TD]1,843,841.61[/TD]
[TD]2,113,768.72[/TD]
[TD]250.00[/TD]
[TD]2,114,018.72[/TD]
[TD]2,114,018.72[/TD]
[TD]0.00[/TD]
[TD]0.00[/TD]
[TD]270,177.11[/TD]
[TD]6,754.05[/TD]
[TD]4.68[/TD]
[TD]100.00[/TD]
[/TR]
[TR]
[TD]Shoring & Underpinning[/TD]
[TD]25,000.00[/TD]
[TD]0.00[/TD]
[TD]25,000.00[/TD]
[TD]50,572.16[/TD]
[TD]0.00[/TD]
[TD]50,572.16[/TD]
[TD]50,572.16[/TD]
[TD]0.00[/TD]
[TD]0.00[/TD]
[TD]25,572.16[/TD]
[TD]161.57[/TD]
[TD]0.11[/TD]
[TD]100.00[/TD]
[/TR]
[TR]
[TD]Piling[/TD]
[TD]152,274.00[/TD]
[TD]0.00[/TD]
[TD]152,274.00[/TD]
[TD]119,832.00[/TD]
[TD]0.00[/TD]
[TD]119,832.00[/TD]
[TD]119,832.00[/TD]
[TD]0.00[/TD]
[TD]0.00[/TD]
[TD](32,442.00)[/TD]
[TD]382.85[/TD]
[TD]0.27[/TD]
[TD]100.00[/TD]
[/TR]
[TR]
[TD]Asphalt Paving[/TD]
[TD]191,931.00[/TD]
[TD]0.00[/TD]
[TD]191,931.00[/TD]
[TD]248,651.00[/TD]
[TD]102.37[/TD]
[TD]248,753.37[/TD]
[TD]248,753.37[/TD]
[TD]0.00[/TD]
[TD]0.00[/TD]
[TD]56,822.37[/TD]
[TD]794.74[/TD]
[TD]0.55[/TD]
[TD]100.00[/TD]
[/TR]
[TR]
[TD]Utilities Relocation[/TD]
[TD]300,000.00[/TD]
[TD]0.00[/TD]
[TD]300,000.00[/TD]
[TD]0.00[/TD]
[TD]353,465.82[/TD]
[TD]353,465.82[/TD]
[TD]353,465.82[/TD]
[TD]0.00[/TD]
[TD]0.00[/TD]
[TD]53,465.82[/TD]
[TD]1,129.28[/TD]
[TD]0.78[/TD]
[TD]100.00[/TD]
[/TR]
[TR]
[TD]TOTAL SITE WORK[/TD]
[TD]2,421,553.00[/TD]
[TD]161,493.61[/TD]
[TD]2,583,046.61[/TD]
[TD]2,596,216.27[/TD]
[TD]428,020.14[/TD]
[TD]3,024,236.41[/TD]
[TD]3,024,236.41[/TD]
[TD]0.00[/TD]
[TD]0.00[/TD]
[TD]441,189.80[/TD]
[TD]9,662.10[/TD]
[TD]6.70[/TD]
[TD]100.00[/TD]
[/TR]
[TR]
[TD]LANDSCAPING[/TD]
[TD] [/TD]
[TD] [/TD]
[TD] [/TD]
[TD] [/TD]
[TD] [/TD]
[TD] [/TD]
[TD] [/TD]
[TD] [/TD]
[TD] [/TD]
[TD] [/TD]
[TD] [/TD]
[TD] [/TD]
[TD] [/TD]
[/TR]
[TR]
[TD]Miscellaneous Site Work[/TD]
[TD]1,288,740.00[/TD]
[TD]156,461.50[/TD]
[TD]1,445,201.50[/TD]
[TD]1,499,332.45[/TD]
[TD]5,579.86[/TD]
[TD]1,504,912.31[/TD]
[TD]1,504,912.31[/TD]
[TD]0.00[/TD]
[TD]0.00[/TD]
[TD]59,710.81[/TD]
[TD]4,808.03[/TD]
[TD]3.33[/TD]
[TD]100.00[/TD]
[/TR]
[TR]
[TD]Pool & Spa[/TD]
[TD]114,300.00[/TD]
[TD]0.00[/TD]
[TD]114,300.00[/TD]
[TD]121,300.00[/TD]
[TD]0.00[/TD]
[TD]121,300.00[/TD]
[TD]121,300.00[/TD]
[TD]0.00[/TD]
[TD]0.00[/TD]
[TD]7,000.00[/TD]
[TD]387.54[/TD]
[TD]0.27[/TD]
[TD]100.00[/TD]
[/TR]
[TR]
[TD]Landscaping[/TD]
[TD]200,000.00[/TD]
[TD]166,215.22[/TD]
[TD]366,215.22[/TD]
[TD]394,460.22[/TD]
[TD]4,992.00[/TD]
[TD]399,452.22[/TD]
[TD]399,452.22[/TD]
[TD]0.00[/TD]
[TD]0.00[/TD]
[TD]33,237.00[/TD]
[TD]1,276.21[/TD]
[TD]0.88[/TD]
[TD]100.00[/TD]
[/TR]
[TR]
[TD]TOTAL LANDSCAPING[/TD]
[TD]1,603,040.00[/TD]
[TD]322,676.72[/TD]
[TD]1,925,716.72[/TD]
[TD]2,015,092.67[/TD]
[TD]10,571.86[/TD]
[TD]2,025,664.53[/TD]
[TD]2,025,664.53[/TD]
[TD]0.00[/TD]
[TD]0.00[/TD]
[TD]99,947.81[/TD]
[TD]6,471.77[/TD]
[TD]4.49[/TD]
[TD]100.00[/TD]
[/TR]
[TR]
[TD]APARTMENT STRUCTURES[/TD]
[TD] [/TD]
[TD] [/TD]
[TD] [/TD]
[TD] [/TD]
[TD] [/TD]
[TD] [/TD]
[TD] [/TD]
[TD] [/TD]
[TD] [/TD]
[TD] [/TD]
[TD] [/TD]
[TD] [/TD]
[TD] [/TD]
[/TR]
[TR]
[TD]Final Cleaning[/TD]
[TD]83,102.00[/TD]
[TD]3,500.00[/TD]
[TD]86,602.00[/TD]
[TD]127,873.00[/TD]
[TD]13,575.71[/TD]
[TD]141,448.71[/TD]
[TD]141,448.71[/TD]
[TD]0.00[/TD]
[TD]0.00[/TD]
[TD]54,846.71[/TD]
[TD]451.91[/TD]
[TD]0.31[/TD]
[TD]100.00[/TD]
[/TR]
[TR]
[TD]Cast in Place Concrete[/TD]
[TD]994,841.00[/TD]
[TD]0.00[/TD]
[TD]994,841.00[/TD]
[TD]1,321,353.20[/TD]
[TD]79,064.15[/TD]
[TD]1,400,417.35[/TD]
[TD]1,400,417.35[/TD]
[TD]0.00[/TD]
[TD]0.00[/TD]
[TD]405,576.35[/TD]
[TD]4,474.18[/TD]
[TD]3.10[/TD]
[TD]100.00[/TD]
[/TR]
[TR]
[TD]PT & Reinforcing Steel[/TD]
[TD]372,461.00[/TD]
[TD]3,600.00[/TD]
[TD]376,061.00[/TD]
[TD]373,395.24[/TD]
[TD]48,385.74[/TD]
[TD]421,780.98[/TD]
[TD]421,780.98[/TD]
[TD]0.00[/TD]
[TD]0.00[/TD]
[TD]45,719.98[/TD]
[TD]1,347.54[/TD]
[TD]0.93[/TD]
[TD]100.00[/TD]
[/TR]
[TR]
[TD]Cast in Place Concrte-Material[/TD]
[TD]1,105,171.00[/TD]
[TD]4,000.00[/TD]
[TD]1,109,171.00[/TD]
[TD]1,406,719.35[/TD]
[TD]24,416.28[/TD]
[TD]1,431,135.63[/TD]
[TD]1,431,135.63[/TD]
[TD]0.00[/TD]
[TD]0.00[/TD]
[TD]321,964.63[/TD]
[TD]4,572.32[/TD]
[TD]3.17[/TD]
[TD]100.00[/TD]
[/TR]
[TR]
[TD]Post Tensioned Cable Mat[/TD]
[TD]238,700.00[/TD]
[TD]0.00[/TD]
[TD]238,700.00[/TD]
[TD]141,985.91[/TD]
[TD]0.00[/TD]
[TD]141,985.91[/TD]
[TD]141,985.91[/TD]
[TD]0.00[/TD]
[TD]0.00[/TD]
[TD](96,714.09)[/TD]
[TD]453.63[/TD]
[TD]0.31[/TD]
[TD]100.00[/TD]
[/TR]
[TR]
[TD]Formwork Cast in Plac Con[/TD]
[TD]1,180,746.00[/TD]
[TD]0.00[/TD]
[TD]1,180,746.00[/TD]
[TD]1,188,195.68[/TD]
[TD]1,142.76[/TD]
[TD]1,189,338.44[/TD]
[TD]1,189,338.44[/TD]
[TD]0.00[/TD]
[TD]0.00[/TD]
[TD]8,592.44[/TD]
[TD]3,799.80[/TD]
[TD]2.63[/TD]
[TD]100.00[/TD]
[/TR]
[TR]
[TD]Place and Finish Labor[/TD]
[TD]38,033.00[/TD]
[TD]0.00[/TD]
[TD]38,033.00[/TD]
[TD]38,033.00[/TD]
[TD]0.00[/TD]
[TD]38,033.00[/TD]
[TD]38,033.00[/TD]
[TD]0.00[/TD]
[TD]0.00[/TD]
[TD]0.00[/TD]
[TD]121.51[/TD]
[TD]0.08[/TD]
[TD]100.00[/TD]
[/TR]
[TR]
[TD]Concrete Pump[/TD]
[TD]565,165.00[/TD]
[TD]0.00[/TD]
[TD]565,165.00[/TD]
[TD]595,376.57[/TD]
[TD]161,622.12[/TD]
[TD]756,998.69[/TD]
[TD]756,998.69[/TD]
[TD]0.00[/TD]
[TD]0.00[/TD]
[TD]191,833.69[/TD]
[TD]2,418.53[/TD]
[TD]1.68[/TD]
[TD]100.00[/TD]
[/TR]
[TR]
[TD]PT & Reinforc Steel Instal[/TD]
[TD]275,735.00[/TD]
[TD]0.00[/TD]
[TD]275,735.00[/TD]
[TD]285,635.00[/TD]
[TD]1,203.75[/TD]
[TD]286,838.75[/TD]
[TD]286,838.75[/TD]
[TD]0.00[/TD]
[TD]0.00[/TD]
[TD]11,103.75[/TD]
[TD]916.42[/TD]
[TD]0.64[/TD]
[TD]100.00[/TD]
[/TR]
[TR]
[TD]Gypsum Cement Underlayment[/TD]
[TD]589,012.00[/TD]
[TD]0.00[/TD]
[TD]589,012.00[/TD]
[TD]748,928.00[/TD]
[TD]0.00[/TD]
[TD]748,928.00[/TD]
[TD]748,928.00[/TD]
[TD]0.00[/TD]
[TD]0.00[/TD]
[TD]159,916.00[/TD]
[TD]2,392.74[/TD]
[TD]1.66[/TD]
[TD]100.00[/TD]
[/TR]
[TR]
[TD]Concrete Fill Materials[/TD]
[TD]0.00[/TD]
[TD]0.00[/TD]
[TD]0.00[/TD]
[TD]0.00[/TD]
[TD]222,797.09[/TD]
[TD]222,797.09[/TD]
[TD]56,476.09[/TD]
[TD]166,321.00[/TD]
[TD]166,321.00[/TD]
[TD]222,797.09[/TD]
[TD]711.81[/TD]
[TD]0.49[/TD]
[TD]25.35[/TD]
[/TR]
[TR]
[TD]Brick Masonry[/TD]
[TD]0.00[/TD]
[TD]0.00[/TD]
[TD]0.00[/TD]
[TD]0.00[/TD]
[TD]314,008.00[/TD]
[TD]314,008.00[/TD]
[TD]322,472.52[/TD]
[TD](8,464.52)[/TD]
[TD]60,500.00[/TD]
[TD]314,008.00[/TD]
[TD]1,003.22[/TD]
[TD]0.70[/TD]
[TD]102.70[/TD]
[/TR]
[TR]
[TD]Concrete Unit Masonry[/TD]
[TD]1,448,718.00[/TD]
[TD]90,918.00[/TD]
[TD]1,539,636.00[/TD]
[TD]1,591,184.37[/TD]
[TD]36.18[/TD]
[TD]1,591,220.55[/TD]
[TD]1,591,184.37[/TD]
[TD]36.18[/TD]
[TD]0.00[/TD]
[TD]51,584.55[/TD]
[TD]5,083.77[/TD]
[TD]3.52[/TD]
[TD]100.00[/TD]
[/TR]
[TR]
[TD]Metal Railings[/TD]
[TD]495,668.00[/TD]
[TD]0.00[/TD]
[TD]495,668.00[/TD]
[TD]395,510.68[/TD]
[TD]0.00[/TD]
[TD]395,510.68[/TD]
[TD]395,510.68[/TD]
[TD]0.00[/TD]
[TD]0.00[/TD]
[TD](100,157.32)[/TD]
[TD]1,263.61[/TD]
[TD]0.88[/TD]
[TD]100.00[/TD]
[/TR]
[TR]
[TD]Misc. Metals[/TD]
[TD]854,842.00[/TD]
[TD]119,535.00[/TD]
[TD]974,377.00[/TD]
[TD]720,757.87[/TD]
[TD]247,005.74[/TD]
[TD]967,763.61[/TD]
[TD]967,763.61[/TD]
[TD]0.00[/TD]
[TD]0.00[/TD]
[TD](6,613.39)[/TD]
[TD]3,091.90[/TD]
[TD]2.14[/TD]
[TD]100.00[/TD]
[/TR]
[TR]
[TD]Rough Carpentry[/TD]
[TD]5,511,701.00[/TD]
[TD]122,942.49[/TD]
[TD]5,634,643.49[/TD]
[TD]5,153,875.01[/TD]
[TD]482,823.30[/TD]
[TD]5,636,698.31[/TD]
[TD]5,636,698.31[/TD]
[TD]0.00[/TD]
[TD]0.00[/TD]
[TD]2,054.82[/TD]
[TD]18,008.62[/TD]
[TD]12.48[/TD]
[TD]100.00[/TD]
[/TR]
[TR]
[TD]Interior Finish Carpentry[/TD]
[TD]181,606.00[/TD]
[TD]24,398.00[/TD]
[TD]206,004.00[/TD]
[TD]863,760.96[/TD]
[TD]0.00[/TD]
[TD]863,760.96[/TD]
[TD]863,760.96[/TD]
[TD]0.00[/TD]
[TD]0.00[/TD]
[TD]657,756.96[/TD]
[TD]2,759.62[/TD]
[TD]1.91[/TD]
[TD]100.00[/TD]
[/TR]
[TR]
[TD]Waterproofing & Dampproofing[/TD]
[TD]1,368,226.00[/TD]
[TD]800.00[/TD]
[TD]1,369,026.00[/TD]
[TD]1,138,583.35[/TD]
[TD]28,162.82[/TD]
[TD]1,166,746.17[/TD]
[TD]1,166,746.17[/TD]
[TD]0.00[/TD]
[TD]0.00[/TD]
[TD](202,279.83)[/TD]
[TD]3,727.62[/TD]
[TD]2.58[/TD]
[TD]100.00[/TD]
[/TR]
[TR]
[TD]Preventative Coating/Remediati[/TD]
[TD]77,624.00[/TD]
[TD]0.00[/TD]
[TD]77,624.00[/TD]
[TD]93,662.00[/TD]
[TD]0.00[/TD]
[TD]93,662.00[/TD]
[TD]93,662.00[/TD]
[TD]0.00[/TD]
[TD]0.00[/TD]
[TD]16,038.00[/TD]
[TD]299.24[/TD]
[TD]0.21[/TD]
[TD]100.00[/TD]
[/TR]
[TR]
[TD]Insulation[/TD]
[TD]524,728.00[/TD]
[TD]0.00[/TD]
[TD]524,728.00[/TD]
[TD]703,255.00[/TD]
[TD]1,180.51[/TD]
[TD]704,435.51[/TD]
[TD]704,435.51[/TD]
[TD]0.00[/TD]
[TD]0.00[/TD]
[TD]179,707.51[/TD]
[TD]2,250.59[/TD]
[TD]1.56[/TD]
[TD]100.00[/TD]
[/TR]
[TR]
[TD]Roofing[/TD]
[TD]879,281.00[/TD]
[TD]38,458.00[/TD]
[TD]917,739.00[/TD]
[TD]545,506.00[/TD]
[TD]17,100.00[/TD]
[TD]562,606.00[/TD]
[TD]562,606.00[/TD]
[TD]0.00[/TD]
[TD]0.00[/TD]
[TD](355,133.00)[/TD]
[TD]1,797.46[/TD]
[TD]1.25[/TD]
[TD]100.00[/TD]
[/TR]
[TR]
[TD]Siding[/TD]
[TD]1,136,736.00[/TD]
[TD]16,250.00[/TD]
[TD]1,152,986.00[/TD]
[TD]968,209.05[/TD]
[TD]5,929.83[/TD]
[TD]974,138.88[/TD]
[TD]974,138.88[/TD]
[TD]0.00[/TD]
[TD]0.00[/TD]
[TD](178,847.12)[/TD]
[TD]3,112.26[/TD]
[TD]2.16[/TD]
[TD]100.00[/TD]
[/TR]
[TR]
[TD]Fire stopping[/TD]
[TD]45,000.00[/TD]
[TD]0.00[/TD]
[TD]45,000.00[/TD]
[TD]0.00[/TD]
[TD]7,579.59[/TD]
[TD]7,579.59[/TD]
[TD]7,579.59[/TD]
[TD]0.00[/TD]
[TD]0.00[/TD]
[TD](37,420.41)[/TD]
[TD]24.22[/TD]
[TD]0.02[/TD]
[TD]100.00[/TD]
[/TR]
[TR]
[TD]Overhead Coiling Doors[/TD]
[TD]61,896.00[/TD]
[TD]83,148.00[/TD]
[TD]145,044.00[/TD]
[TD]159,491.00[/TD]
[TD]497.25[/TD]
[TD]159,988.25[/TD]
[TD]159,988.25[/TD]
[TD]0.00[/TD]
[TD]0.00[/TD]
[TD]14,944.25[/TD]
[TD]511.14[/TD]
[TD]0.35[/TD]
[TD]100.00[/TD]
[/TR]
[TR]
[TD]Entrance & Storefront[/TD]
[TD]347,553.00[/TD]
[TD]1,800.00[/TD]
[TD]349,353.00[/TD]
[TD]469,927.28[/TD]
[TD]1,563.34[/TD]
[TD]471,490.62[/TD]
[TD]471,490.62[/TD]
[TD]0.00[/TD]
[TD]0.00[/TD]
[TD]122,137.62[/TD]
[TD]1,506.36[/TD]
[TD]1.04[/TD]
[TD]100.00[/TD]
[/TR]
[TR]
[TD]Windows[/TD]
[TD]673,323.00[/TD]
[TD]0.00[/TD]
[TD]673,323.00[/TD]
[TD]968,699.73[/TD]
[TD]0.00[/TD]
[TD]968,699.73[/TD]
[TD]968,699.73[/TD]
[TD]0.00[/TD]
[TD]0.00[/TD]
[TD]295,376.73[/TD]
[TD]3,094.89[/TD]
[TD]2.15[/TD]
[TD]100.00[/TD]
[/TR]
[TR]
[TD]Door Hardware[/TD]
[TD]1,142,765.00[/TD]
[TD]6,260.00[/TD]
[TD]1,149,025.00[/TD]
[TD]775,713.54[/TD]
[TD]817.20[/TD]
[TD]776,530.74[/TD]
[TD]776,530.74[/TD]
[TD]0.00[/TD]
[TD]0.00[/TD]
[TD](372,494.26)[/TD]
[TD]2,480.93[/TD]
[TD]1.72[/TD]
[TD]100.00[/TD]
[/TR]
[TR]
[TD]Gypsum Board[/TD]
[TD]2,622,960.00[/TD]
[TD]160,942.00[/TD]
[TD]2,783,902.00[/TD]
[TD]3,134,502.00[/TD]
[TD]888.94[/TD]
[TD]3,135,390.94[/TD]
[TD]3,135,390.94[/TD]
[TD]0.00[/TD]
[TD]0.00[/TD]
[TD]351,488.94[/TD]
[TD]10,017.22[/TD]
[TD]6.94[/TD]
[TD]100.00[/TD]
[/TR]
[TR]
[TD]Tile/Stone[/TD]
[TD]1,331,925.00[/TD]
[TD]158,440.00[/TD]
[TD]1,490,365.00[/TD]
[TD]1,468,505.00[/TD]
[TD]1,219.69[/TD]
[TD]1,469,724.69[/TD]
[TD]1,469,724.69[/TD]
[TD]0.00[/TD]
[TD]0.00[/TD]
[TD](20,640.31)[/TD]
[TD]4,695.61[/TD]
[TD]3.26[/TD]
[TD]100.00[/TD]
[/TR]
[TR]
[TD]Painting[/TD]
[TD]755,456.00[/TD]
[TD]31,500.00[/TD]
[TD]786,956.00[/TD]
[TD]1,112,475.11[/TD]
[TD]0.00[/TD]
[TD]1,112,475.11[/TD]
[TD]1,112,475.11[/TD]
[TD]0.00[/TD]
[TD]0.00[/TD]
[TD]325,519.11[/TD]
[TD]3,554.23[/TD]
[TD]2.46[/TD]
[TD]100.00[/TD]
[/TR]
[TR]
[TD]Signage[/TD]
[TD]45,000.00[/TD]
[TD]0.00[/TD]
[TD]45,000.00[/TD]
[TD]0.00[/TD]
[TD]17,971.00[/TD]
[TD]17,971.00[/TD]
[TD]17,971.00[/TD]
[TD]0.00[/TD]
[TD]0.00[/TD]
[TD](27,029.00)[/TD]
[TD]57.42[/TD]
[TD]0.04[/TD]
[TD]100.00[/TD]
[/TR]
[TR]
[TD]Toilet/Bath Accessories[/TD]
[TD]241,843.00[/TD]
[TD]26,530.00[/TD]
[TD]268,373.00[/TD]
[TD]131,851.00[/TD]
[TD]269.66[/TD]
[TD]132,120.66[/TD]
[TD]132,120.66[/TD]
[TD]0.00[/TD]
[TD]0.00[/TD]
[TD](136,252.34)[/TD]
[TD]422.11[/TD]
[TD]0.29[/TD]
[TD]100.00[/TD]
[/TR]
[TR]
[TD]Fireplaces & Accessories[/TD]
[TD]35,000.00[/TD]
[TD]0.00[/TD]
[TD]35,000.00[/TD]
[TD]0.00[/TD]
[TD]68,745.00[/TD]
[TD]68,745.00[/TD]
[TD]68,745.00[/TD]
[TD]0.00[/TD]
[TD]0.00[/TD]
[TD]33,745.00[/TD]
[TD]219.63[/TD]
[TD]0.15[/TD]
[TD]100.00[/TD]
[/TR]
[TR]
[TD]Storage Units[/TD]
[TD]54,000.00[/TD]
[TD]0.00[/TD]
[TD]54,000.00[/TD]
[TD]0.00[/TD]
[TD]0.00[/TD]
[TD]0.00[/TD]
[TD]0.00[/TD]
[TD]0.00[/TD]
[TD]0.00[/TD]
[TD](54,000.00)[/TD]
[TD]0.00[/TD]
[TD]0.00[/TD]
[TD]0.00[/TD]
[/TR]
[TR]
[TD]Postal Specialties[/TD]
[TD]72,000.00[/TD]
[TD]0.00[/TD]
[TD]72,000.00[/TD]
[TD]43,370.00[/TD]
[TD]0.00[/TD]
[TD]43,370.00[/TD]
[TD]43,370.00[/TD]
[TD]0.00[/TD]
[TD]0.00[/TD]
[TD](28,630.00)[/TD]
[TD]138.56[/TD]
[TD]0.10[/TD]
[TD]100.00[/TD]
[/TR]
[TR]
[TD]Misc. Specialties[/TD]
[TD]10,000.00[/TD]
[TD]3,500.00[/TD]
[TD]13,500.00[/TD]
[TD]0.00[/TD]
[TD]13,393.59[/TD]
[TD]13,393.59[/TD]
[TD]13,393.59[/TD]
[TD]0.00[/TD]
[TD]0.00[/TD]
[TD](106.41)[/TD]
[TD]42.79[/TD]
[TD]0.03[/TD]
[TD]100.00[/TD]
[/TR]
[TR]
[TD]Residential Appliances[/TD]
[TD]837,531.00[/TD]
[TD]0.00[/TD]
[TD]837,531.00[/TD]
[TD]914,138.05[/TD]
[TD]24,682.82[/TD]
[TD]938,820.87[/TD]
[TD]938,820.87[/TD]
[TD]0.00[/TD]
[TD]0.00[/TD]
[TD]101,289.87[/TD]
[TD]2,999.43[/TD]
[TD]2.08[/TD]
[TD]100.00[/TD]
[/TR]
[TR]
[TD]Window Treatments[/TD]
[TD]150,723.00[/TD]
[TD]0.00[/TD]
[TD]150,723.00[/TD]
[TD]110,200.00[/TD]
[TD]0.00[/TD]
[TD]110,200.00[/TD]
[TD]110,200.00[/TD]
[TD]0.00[/TD]
[TD]0.00[/TD]
[TD](40,523.00)[/TD]
[TD]352.08[/TD]
[TD]0.24[/TD]
[TD]100.00[/TD]
[/TR]
[TR]
[TD]Residential Casework[/TD]
[TD]772,090.00[/TD]
[TD]37,488.00[/TD]
[TD]809,578.00[/TD]
[TD]782,136.00[/TD]
[TD]0.00[/TD]
[TD]782,136.00[/TD]
[TD]782,136.00[/TD]
[TD]0.00[/TD]
[TD]0.00[/TD]
[TD](27,442.00)[/TD]
[TD]2,498.84[/TD]
[TD]1.73[/TD]
[TD]100.00[/TD]
[/TR]
[TR]
[TD]Stone/Tile Countertops[/TD]
[TD]305,575.00[/TD]
[TD]11,502.00[/TD]
[TD]317,077.00[/TD]
[TD]386,586.00[/TD]
[TD]0.00[/TD]
[TD]386,586.00[/TD]
[TD]386,586.00[/TD]
[TD]0.00[/TD]
[TD]0.00[/TD]
[TD]69,509.00[/TD]
[TD]1,235.10[/TD]
[TD]0.86[/TD]
[TD]100.00[/TD]
[/TR]
[TR]
[TD]Elevators[/TD]
[TD]902,746.00[/TD]
[TD]3,984.00[/TD]
[TD]906,730.00[/TD]
[TD]1,060,554.08[/TD]
[TD]8,532.86[/TD]
[TD]1,069,086.94[/TD]
[TD]1,069,086.94[/TD]
[TD]0.00[/TD]
[TD]0.00[/TD]
[TD]162,356.94[/TD]
[TD]3,415.61[/TD]
[TD]2.37[/TD]
[TD]100.00[/TD]
[/TR]
[TR]
[TD]Trash Chutes[/TD]
[TD]101,602.00[/TD]
[TD]1,905.00[/TD]
[TD]103,507.00[/TD]
[TD]109,641.00[/TD]
[TD]0.00[/TD]
[TD]109,641.00[/TD]
[TD]109,641.00[/TD]
[TD]0.00[/TD]
[TD]0.00[/TD]
[TD]6,134.00[/TD]
[TD]350.29[/TD]
[TD]0.24[/TD]
[TD]100.00[/TD]
[/TR]
[TR]
[TD]Fire Sprinkler System[/TD]
[TD]780,698.00[/TD]
[TD]28,000.00[/TD]
[TD]808,698.00[/TD]
[TD]879,000.00[/TD]
[TD]2,805.49[/TD]
[TD]881,805.49[/TD]
[TD]881,805.49[/TD]
[TD]0.00[/TD]
[TD]0.00[/TD]
[TD]73,107.49[/TD]
[TD]2,817.27[/TD]
[TD]1.95[/TD]
[TD]100.00[/TD]
[/TR]
[TR]
[TD]Water Submetering[/TD]
[TD]42,255.00[/TD]
[TD]0.00[/TD]
[TD]42,255.00[/TD]
[TD]35,967.00[/TD]
[TD]0.00[/TD]
[TD]35,967.00[/TD]
[TD]35,967.00[/TD]
[TD]0.00[/TD]
[TD]0.00[/TD]
[TD](6,288.00)[/TD]
[TD]114.91[/TD]
[TD]0.08[/TD]
[TD]100.00[/TD]
[/TR]
[TR]
[TD]Plumbing System[/TD]
[TD]2,474,823.00[/TD]
[TD]47,278.63[/TD]
[TD]2,522,101.63[/TD]
[TD]2,471,859.48[/TD]
[TD]69,025.64[/TD]
[TD]2,540,885.12[/TD]
[TD]2,540,885.12[/TD]
[TD]0.00[/TD]
[TD]0.00[/TD]
[TD]18,783.49[/TD]
[TD]8,117.84[/TD]
[TD]5.63[/TD]
[TD]100.00[/TD]
[/TR]
[TR]
[TD]HVAC System[/TD]
[TD]1,863,910.00[/TD]
[TD]10,018.00[/TD]
[TD]1,873,928.00[/TD]
[TD]1,829,186.06[/TD]
[TD]19,420.69[/TD]
[TD]1,848,606.75[/TD]
[TD]1,848,606.75[/TD]
[TD]0.00[/TD]
[TD]0.00[/TD]
[TD](25,321.25)[/TD]
[TD]5,906.09[/TD]
[TD]4.09[/TD]
[TD]100.00[/TD]
[/TR]
[TR]
[TD]Electrical[/TD]
[TD]4,103,361.00[/TD]
[TD]637,001.47[/TD]
[TD]4,740,362.47[/TD]
[TD]5,660,906.65[/TD]
[TD]4,841.49[/TD]
[TD]5,665,748.14[/TD]
[TD]5,665,748.14[/TD]
[TD]0.00[/TD]
[TD]0.00[/TD]
[TD]925,385.67[/TD]
[TD]18,101.43[/TD]
[TD]12.55[/TD]
[TD]100.00[/TD]
[/TR]
[TR]
[TD]Electrical Switch Gear[/TD]
[TD]0.00[/TD]
[TD]46,495.00[/TD]
[TD]46,495.00[/TD]
[TD]0.00[/TD]
[TD]0.00[/TD]
[TD]0.00[/TD]
[TD]0.00[/TD]
[TD]0.00[/TD]
[TD]0.00[/TD]
[TD](46,495.00)[/TD]
[TD]0.00[/TD]
[TD]0.00[/TD]
[TD]0.00[/TD]
[/TR]
[TR]
[TD]Access Control System[/TD]
[TD]151,816.00[/TD]
[TD]0.00[/TD]
[TD]151,816.00[/TD]
[TD]0.00[/TD]
[TD]0.00[/TD]
[TD]0.00[/TD]
[TD]0.00[/TD]
[TD]0.00[/TD]
[TD]0.00[/TD]
[TD](151,816.00)[/TD]
[TD]0.00[/TD]
[TD]0.00[/TD]
[TD]0.00[/TD]
[/TR]
[TR]
[TD]TOTAL APARTMENT STRUCTURES[/TD]
[TD]37,847,947.00[/TD]
[TD]1,720,193.59[/TD]
[TD]39,568,140.59[/TD]
[TD]40,906,508.22[/TD]
[TD]1,890,708.23[/TD]
[TD]42,797,216.45[/TD]
[TD]42,639,323.79[/TD]
[TD]157,892.66[/TD]
[TD]226,821.00[/TD]
[TD]3,229,075.86[/TD]
[TD]136,732.32[/TD]
[TD]94.79[/TD]
[TD]99.63[/TD]
[/TR]
[TR]
[TD]LEASING OFFICE/CLUBHOUSE[/TD]
[TD] [/TD]
[TD] [/TD]
[TD] [/TD]
[TD] [/TD]
[TD] [/TD]
[TD] [/TD]
[TD] [/TD]
[TD] [/TD]
[TD] [/TD]
[TD] [/TD]
[TD] [/TD]
[TD] [/TD]
[TD] [/TD]
[/TR]
[TR]
[TD]Architectural Woodwork[/TD]
[TD]247,640.00[/TD]
[TD]0.00[/TD]
[TD]247,640.00[/TD]
[TD]278,608.85[/TD]
[TD]13,556.76[/TD]
[TD]292,165.61[/TD]
[TD]292,165.61[/TD]
[TD]0.00[/TD]
[TD]0.00[/TD]
[TD]44,525.61[/TD]
[TD]933.44[/TD]
[TD]0.65[/TD]
[TD]100.00[/TD]
[/TR]
[TR]
[TD]TOTAL LEASING OFFICE/CLUBHOUSE[/TD]
[TD]247,640.00[/TD]
[TD]0.00[/TD]
[TD]247,640.00[/TD]
[TD]278,608.85[/TD]
[TD]13,556.76[/TD]
[TD]292,165.61[/TD]
[TD]292,165.61[/TD]
[TD]0.00[/TD]
[TD]0.00[/TD]
[TD]44,525.61[/TD]
[TD]933.44[/TD]
[TD]0.65[/TD]
[TD]100.00[/TD]
[/TR]
[TR]
[TD]GARAGE/PARKING STRUCTURE[/TD]
[TD] [/TD]
[TD] [/TD]
[TD] [/TD]
[TD] [/TD]
[TD] [/TD]
[TD] [/TD]
[TD] [/TD]
[TD] [/TD]
[TD] [/TD]
[TD] [/TD]
[TD] [/TD]
[TD] [/TD]
[TD] [/TD]
[/TR]
[TR]
[TD]Precast Structural Concrete[/TD]
[TD]2,907,500.00[/TD]
[TD]0.00[/TD]
[TD]2,907,500.00[/TD]
[TD]2,872,150.00[/TD]
[TD]0.00[/TD]
[TD]2,872,150.00[/TD]
[TD]2,872,150.00[/TD]
[TD]0.00[/TD]
[TD]0.00[/TD]
[TD](35,350.00)[/TD]
[TD]9,176.20[/TD]
[TD]6.36[/TD]
[TD]100.00[/TD]
[/TR]
[TR]
[TD]TOTAL GARAGE/PARKING STRUCTURE[/TD]
[TD]2,907,500.00[/TD]
[TD]0.00[/TD]
[TD]2,907,500.00[/TD]
[TD]2,872,150.00[/TD]
[TD]0.00[/TD]
[TD]2,872,150.00[/TD]
[TD]2,872,150.00[/TD]
[TD]0.00[/TD]
[TD]0.00[/TD]
[TD](35,350.00)[/TD]
[TD]9,176.20[/TD]
[TD]6.36[/TD]
[TD]100.00[/TD]
[/TR]
[TR]
[TD]STAGING & LOGISTICS[/TD]
[TD] [/TD]
[TD] [/TD]
[TD] [/TD]
[TD] [/TD]
[TD] [/TD]
[TD] [/TD]
[TD] [/TD]
[TD] [/TD]
[TD] [/TD]
[TD] [/TD]
[TD] [/TD]
[TD] [/TD]
[TD] [/TD]
[/TR]
[TR]
[TD]Punch Carpenter[/TD]
[TD]109,550.00[/TD]
[TD]0.00[/TD]
[TD]109,550.00[/TD]
[TD]0.00[/TD]
[TD]159,930.99[/TD]
[TD]159,930.99[/TD]
[TD]159,930.99[/TD]
[TD]0.00[/TD]
[TD]0.00[/TD]
[TD]50,380.99[/TD]
[TD]510.96[/TD]
[TD]0.35[/TD]
[TD]100.00[/TD]
[/TR]
[TR]
[TD]General Labor[/TD]
[TD]82,548.00[/TD]
[TD]2,040.00[/TD]
[TD]84,588.00[/TD]
[TD]0.00[/TD]
[TD]481,074.57[/TD]
[TD]481,074.57[/TD]
[TD]481,074.57[/TD]
[TD]0.00[/TD]
[TD]0.00[/TD]
[TD]396,486.57[/TD]
[TD]1,536.98[/TD]
[TD]1.07[/TD]
[TD]100.00[/TD]
[/TR]
[TR]
[TD]Backcharge/Damage & Correction[/TD]
[TD]0.00[/TD]
[TD]0.00[/TD]
[TD]0.00[/TD]
[TD]0.00[/TD]
[TD]3,845.20[/TD]
[TD]3,845.20[/TD]
[TD]3,845.20[/TD]
[TD]0.00[/TD]
[TD]0.00[/TD]
[TD]3,845.20[/TD]
[TD]12.28[/TD]
[TD]0.01[/TD]
[TD]100.00[/TD]
[/TR]
[TR]
[TD]Technology Fees & Licenses[/TD]
[TD]30,000.00[/TD]
[TD]0.00[/TD]
[TD]30,000.00[/TD]
[TD]0.00[/TD]
[TD]28,113.17[/TD]
[TD]28,113.17[/TD]
[TD]28,113.17[/TD]
[TD]0.00[/TD]
[TD]0.00[/TD]
[TD](1,886.83)[/TD]
[TD]89.82[/TD]
[TD]0.06[/TD]
[TD]100.00[/TD]
[/TR]
[TR]
[TD]Professional Scheduling[/TD]
[TD]0.00[/TD]
[TD]0.00[/TD]
[TD]0.00[/TD]
[TD]0.00[/TD]
[TD]112,940.00[/TD]
[TD]112,940.00[/TD]
[TD]112,940.00[/TD]
[TD]0.00[/TD]
[TD]0.00[/TD]
[TD]112,940.00[/TD]
[TD]360.83[/TD]
[TD]0.25[/TD]
[TD]100.00[/TD]
[/TR]
[TR]
[TD]Safety Inspections[/TD]
[TD]24,000.00[/TD]
[TD]0.00[/TD]
[TD]24,000.00[/TD]
[TD]0.00[/TD]
[TD]13,425.26[/TD]
[TD]13,425.26[/TD]
[TD]13,425.26[/TD]
[TD]0.00[/TD]
[TD]0.00[/TD]
[TD](10,574.74)[/TD]
[TD]42.89[/TD]
[TD]0.03[/TD]
[TD]100.00[/TD]
[/TR]
[TR]
[TD]Temporary Electric[/TD]
[TD]70,000.00[/TD]
[TD]58,087.34[/TD]
[TD]128,087.34[/TD]
[TD]0.00[/TD]
[TD]336,331.03[/TD]
[TD]336,331.03[/TD]
[TD]336,331.03[/TD]
[TD]0.00[/TD]
[TD]0.00[/TD]
[TD]208,243.69[/TD]
[TD]1,074.54[/TD]
[TD]0.74[/TD]
[TD]100.00[/TD]
[/TR]
[TR]
[TD]Temp HVAC[/TD]
[TD]50,000.00[/TD]
[TD]0.00[/TD]
[TD]50,000.00[/TD]
[TD]0.00[/TD]
[TD]1,436.07[/TD]
[TD]1,436.07[/TD]
[TD]1,436.07[/TD]
[TD]0.00[/TD]
[TD]0.00[/TD]
[TD](48,563.93)[/TD]
[TD]4.59[/TD]
[TD]0.00[/TD]
[TD]100.00[/TD]
[/TR]
[TR]
[TD]Temp Storage/Trailer[/TD]
[TD]2,500.00[/TD]
[TD]0.00[/TD]
[TD]2,500.00[/TD]
[TD]0.00[/TD]
[TD]0.00[/TD]
[TD]0.00[/TD]
[TD]0.00[/TD]
[TD]0.00[/TD]
[TD]0.00[/TD]
[TD](2,500.00)[/TD]
[TD]0.00[/TD]
[TD]0.00[/TD]
[TD]0.00[/TD]
[/TR]
[TR]
[TD]Sanitary Facilities[/TD]
[TD]55,000.00[/TD]
[TD]0.00[/TD]
[TD]55,000.00[/TD]
[TD]0.00[/TD]
[TD]74,754.14[/TD]
[TD]74,754.14[/TD]
[TD]74,754.14[/TD]
[TD]0.00[/TD]
[TD]0.00[/TD]
[TD]19,754.14[/TD]
[TD]238.83[/TD]
[TD]0.17[/TD]
[TD]100.00[/TD]
[/TR]
[TR]
[TD]Misc. Tools & Materials[/TD]
[TD]15,000.00[/TD]
[TD]0.00[/TD]
[TD]15,000.00[/TD]
[TD]0.00[/TD]
[TD]172,162.24[/TD]
[TD]172,162.24[/TD]
[TD]172,162.24[/TD]
[TD]0.00[/TD]
[TD]0.00[/TD]
[TD]157,162.24[/TD]
[TD]550.04[/TD]
[TD]0.38[/TD]
[TD]100.00[/TD]
[/TR]
[TR]
[TD]Equipment Owned[/TD]
[TD]10,000.00[/TD]
[TD]0.00[/TD]
[TD]10,000.00[/TD]
[TD]0.00[/TD]
[TD]0.00[/TD]
[TD]0.00[/TD]
[TD]0.00[/TD]
[TD]0.00[/TD]
[TD]0.00[/TD]
[TD](10,000.00)[/TD]
[TD]0.00[/TD]
[TD]0.00[/TD]
[TD]0.00[/TD]
[/TR]
[TR]
[TD]Equipment Rented[/TD]
[TD]60,000.00[/TD]
[TD]50,433.00[/TD]
[TD]110,433.00[/TD]
[TD]103,256.98[/TD]
[TD]456,892.34[/TD]
[TD]560,149.32[/TD]
[TD]560,149.32[/TD]
[TD]0.00[/TD]
[TD]0.00[/TD]
[TD]449,716.32[/TD]
[TD]1,789.61[/TD]
[TD]1.24[/TD]
[TD]100.00[/TD]
[/TR]
[TR]
[TD]Construction Trash Chutes[/TD]
[TD]12,000.00[/TD]
[TD]0.00[/TD]
[TD]12,000.00[/TD]
[TD]0.00[/TD]
[TD]6,433.01[/TD]
[TD]6,433.01[/TD]
[TD]6,433.01[/TD]
[TD]0.00[/TD]
[TD]0.00[/TD]
[TD](5,566.99)[/TD]
[TD]20.55[/TD]
[TD]0.01[/TD]
[TD]100.00[/TD]
[/TR]
[TR]
[TD]Safety Equipment & Services[/TD]
[TD]12,000.00[/TD]
[TD]0.00[/TD]
[TD]12,000.00[/TD]
[TD]0.00[/TD]
[TD]42,974.24[/TD]
[TD]42,974.24[/TD]
[TD]42,974.24[/TD]
[TD]0.00[/TD]
[TD]0.00[/TD]
[TD]30,974.24[/TD]
[TD]137.30[/TD]
[TD]0.10[/TD]
[TD]100.00[/TD]
[/TR]
[TR]
[TD]Temporary Fencing[/TD]
[TD]25,000.00[/TD]
[TD]0.00[/TD]
[TD]25,000.00[/TD]
[TD]0.00[/TD]
[TD]44,999.50[/TD]
[TD]44,999.50[/TD]
[TD]44,999.50[/TD]
[TD]0.00[/TD]
[TD]0.00[/TD]
[TD]19,999.50[/TD]
[TD]143.77[/TD]
[TD]0.10[/TD]
[TD]100.00[/TD]
[/TR]
[TR]
[TD]Temp Environmental Controls[/TD]
[TD]30,000.00[/TD]
[TD]0.00[/TD]
[TD]30,000.00[/TD]
[TD]0.00[/TD]
[TD]76,285.46[/TD]
[TD]76,285.46[/TD]
[TD]76,285.46[/TD]
[TD]0.00[/TD]
[TD]0.00[/TD]
[TD]46,285.46[/TD]
[TD]243.72[/TD]
[TD]0.17[/TD]
[TD]100.00[/TD]
[/TR]
[TR]
[TD]Temporary Project Signage[/TD]
[TD]4,500.00[/TD]
[TD]0.00[/TD]
[TD]4,500.00[/TD]
[TD]0.00[/TD]
[TD]1,900.51[/TD]
[TD]1,900.51[/TD]
[TD]1,900.51[/TD]
[TD]0.00[/TD]
[TD]0.00[/TD]
[TD](2,599.49)[/TD]
[TD]6.07[/TD]
[TD]0.00[/TD]
[TD]100.00[/TD]
[/TR]
[TR]
[TD]Progress Cleaning[/TD]
[TD]10,000.00[/TD]
[TD]0.00[/TD]
[TD]10,000.00[/TD]
[TD]0.00[/TD]
[TD]5,128.40[/TD]
[TD]5,128.40[/TD]
[TD]5,128.40[/TD]
[TD]0.00[/TD]
[TD]0.00[/TD]
[TD](4,871.60)[/TD]
[TD]16.38[/TD]
[TD]0.01[/TD]
[TD]100.00[/TD]
[/TR]
[TR]
[TD]Construction Waste/Disposal[/TD]
[TD]234,750.00[/TD]
[TD]980.00[/TD]
[TD]235,730.00[/TD]
[TD]0.00[/TD]
[TD]298,106.05[/TD]
[TD]298,106.05[/TD]
[TD]298,106.05[/TD]
[TD]0.00[/TD]
[TD]0.00[/TD]
[TD]62,376.05[/TD]
[TD]952.42[/TD]
[TD]0.66[/TD]
[TD]100.00[/TD]
[/TR]
[TR]
[TD]Police Detail/Traffic Control[/TD]
[TD]57,000.00[/TD]
[TD]0.00[/TD]
[TD]57,000.00[/TD]
[TD]0.00[/TD]
[TD]421,922.87[/TD]
[TD]421,922.87[/TD]
[TD]421,922.87[/TD]
[TD]0.00[/TD]
[TD]0.00[/TD]
[TD]364,922.87[/TD]
[TD]1,348.00[/TD]
[TD]0.93[/TD]
[TD]100.00[/TD]
[/TR]
[TR]
[TD]Surveying[/TD]
[TD]30,000.00[/TD]
[TD]2,200.00[/TD]
[TD]32,200.00[/TD]
[TD]89,835.00[/TD]
[TD]9,987.87[/TD]
[TD]99,822.87[/TD]
[TD]99,822.87[/TD]
[TD]0.00[/TD]
[TD]0.00[/TD]
[TD]67,622.87[/TD]
[TD]318.92[/TD]
[TD]0.22[/TD]
[TD]100.00[/TD]
[/TR]
[TR]
[TD]Special Inspections & Testing[/TD]
[TD]50,000.00[/TD]
[TD]0.00[/TD]
[TD]50,000.00[/TD]
[TD]144,085.88[/TD]
[TD]21,926.41[/TD]
[TD]166,012.29[/TD]
[TD]166,012.29[/TD]
[TD]0.00[/TD]
[TD]0.00[/TD]
[TD]116,012.29[/TD]
[TD]530.39[/TD]
[TD]0.37[/TD]
[TD]100.00[/TD]
[/TR]
[TR]
[TD]TOTAL STAGING & LOGISTICS[/TD]
[TD]973,848.00[/TD]
[TD]113,740.34[/TD]
[TD]1,087,588.34[/TD]
[TD]337,177.86[/TD]
[TD]2,770,569.33[/TD]
[TD]3,107,747.19[/TD]
[TD]3,107,747.19[/TD]
[TD]0.00[/TD]
[TD]0.00[/TD]
[TD]2,020,158.85[/TD]
[TD]9,928.90[/TD]
[TD]6.88[/TD]
[TD]100.00[/TD]
[/TR]
[TR]
[TD]WARRANTY[/TD]
[TD] [/TD]
[TD] [/TD]
[TD] [/TD]
[TD] [/TD]
[TD] [/TD]
[TD] [/TD]
[TD] [/TD]
[TD] [/TD]
[TD] [/TD]
[TD] [/TD]
[TD] [/TD]
[TD] [/TD]
[TD] [/TD]
[/TR]
[TR]
[TD]Warranty[/TD]
[TD]91,800.00[/TD]
[TD]0.00[/TD]
[TD]91,800.00[/TD]
[TD]0.00[/TD]
[TD]51,000.00[/TD]
[TD]51,000.00[/TD]
[TD]42,135.46[/TD]
[TD]8,864.54[/TD]
[TD]0.00[/TD]
[TD](40,800.00)[/TD]
[TD]162.94[/TD]
[TD]0.11[/TD]
[TD]82.62[/TD]
[/TR]
[TR]
[TD]TOTAL WARRANTY[/TD]
[TD]91,800.00[/TD]
[TD]0.00[/TD]
[TD]91,800.00[/TD]
[TD]0.00[/TD]
[TD]51,000.00[/TD]
[TD]51,000.00[/TD]
[TD]42,135.46[/TD]
[TD]8,864.54[/TD]
[TD]0.00[/TD]
[TD](40,800.00)[/TD]
[TD]162.94[/TD]
[TD]0.11[/TD]
[TD]82.62[/TD]
[/TR]
[TR]
[TD]CONSTRUCTION INSURANCE[/TD]
[TD] [/TD]
[TD] [/TD]
[TD] [/TD]
[TD] [/TD]
[TD] [/TD]
[TD] [/TD]
[TD] [/TD]
[TD] [/TD]
[TD] [/TD]
[TD] [/TD]
[TD] [/TD]
[TD] [/TD]
[TD] [/TD]
[/TR]
[TR]
[TD]Builders Risk Insurance[/TD]
[TD]303,238.00[/TD]
[TD]0.00[/TD]
[TD]303,238.00[/TD]
[TD]0.00[/TD]
[TD]343,489.40[/TD]
[TD]343,489.40[/TD]
[TD]343,489.40[/TD]
[TD]0.00[/TD]
[TD]0.00[/TD]
[TD]40,251.40[/TD]
[TD]1,097.41[/TD]
[TD]0.76[/TD]
[TD]100.00[/TD]
[/TR]
[TR]
[TD]General Liability[/TD]
[TD]327,304.00[/TD]
[TD]0.00[/TD]
[TD]327,304.00[/TD]
[TD]0.00[/TD]
[TD]350,966.14[/TD]
[TD]350,966.14[/TD]
[TD]350,966.14[/TD]
[TD]0.00[/TD]
[TD]0.00[/TD]
[TD]23,662.14[/TD]
[TD]1,121.30[/TD]
[TD]0.78[/TD]
[TD]100.00[/TD]
[/TR]
[TR]
[TD]TOTAL CONSTRUCTION INSURANCE[/TD]
[TD]630,542.00[/TD]
[TD]0.00[/TD]
[TD]630,542.00[/TD]
[TD]0.00[/TD]
[TD]694,455.54[/TD]
[TD]694,455.54[/TD]
[TD]694,455.54[/TD]
[TD]0.00[/TD]
[TD]0.00[/TD]
[TD]63,913.54[/TD]
[TD]2,218.71[/TD]
[TD]1.54[/TD]
[TD]100.00[/TD]
[/TR]
[TR]
[TD]CONSTRUCTION FEES[/TD]
[TD] [/TD]
[TD] [/TD]
[TD] [/TD]
[TD] [/TD]
[TD] [/TD]
[TD] [/TD]
[TD] [/TD]
[TD] [/TD]
[TD] [/TD]
[TD] [/TD]
[TD] [/TD]
[TD] [/TD]
[TD] [/TD]
[/TR]
[TR]
[TD]Construction Fees[/TD]
[TD]2,127,143.00[/TD]
[TD]93,057.32[/TD]
[TD]2,220,200.32[/TD]
[TD]0.00[/TD]
[TD]2,220,200.62[/TD]
[TD]2,220,200.62[/TD]
[TD]2,220,200.32[/TD]
[TD]0.30[/TD]
[TD]0.00[/TD]
[TD]0.30[/TD]
[TD]7,093.29[/TD]
[TD]4.92[/TD]
[TD]100.00[/TD]
[/TR]
[TR]
[TD]TOTAL CONSTRUCTION FEES[/TD]
[TD]2,127,143.00[/TD]
[TD]93,057.32[/TD]
[TD]2,220,200.32[/TD]
[TD]0.00[/TD]
[TD]2,220,200.62[/TD]
[TD]2,220,200.62[/TD]
[TD]2,220,200.32[/TD]
[TD]0.30[/TD]
[TD]0.00[/TD]
[TD]0.30[/TD]
[TD]7,093.29[/TD]
[TD]4.92[/TD]
[TD]100.00[/TD]
[/TR]
[TR]
[TD]CONTINGENCY[/TD]
[TD] [/TD]
[TD] [/TD]
[TD] [/TD]
[TD] [/TD]
[TD] [/TD]
[TD] [/TD]
[TD] [/TD]
[TD] [/TD]
[TD] [/TD]
[TD] [/TD]
[TD] [/TD]
[TD] [/TD]
[TD] [/TD]
[/TR]
[TR]
[TD]Construction Contingency[/TD]
[TD]1,959,361.00[/TD]
[TD]31,251.11[/TD]
[TD]1,990,612.11[/TD]
[TD]0.00[/TD]
[TD]0.00[/TD]
[TD]0.00[/TD]
[TD]0.00[/TD]
[TD]0.00[/TD]
[TD]0.00[/TD]
[TD](1,990,612.11)[/TD]
[TD]0.00[/TD]
[TD]0.00[/TD]
[TD]0.00[/TD]
[/TR]
[TR]
[TD]TOTAL CONTINGENCY[/TD]
[TD]1,959,361.00[/TD]
[TD]31,251.11[/TD]
[TD]1,990,612.11[/TD]
[TD]0.00[/TD]
[TD]0.00[/TD]
[TD]0.00[/TD]
[TD]0.00[/TD]
[TD]0.00[/TD]
[TD]0.00[/TD]
[TD](1,990,612.11)[/TD]
[TD]0.00[/TD]
[TD]0.00[/TD]
[TD]0.00[/TD]
[/TR]
[TR]
[TD]Rebates[/TD]
[TD](203,450.00)[/TD]
[TD]0.00[/TD]
[TD](203,450.00)[/TD]
[TD]0.00[/TD]
[TD](216,070.00)[/TD]
[TD](216,070.00)[/TD]
[TD](216,070.00)[/TD]
[TD]0.00[/TD]
[TD]0.00[/TD]
[TD](12,620.00)[/TD]
[TD](690.32)[/TD]
[TD](0.48)[/TD]
[TD]100.00[/TD]
[/TR]
[TR]
[TD]Reimbursements[/TD]
[TD]0.00[/TD]
[TD]0.00[/TD]
[TD]0.00[/TD]
[TD]139,460.41[/TD]
[TD](375,830.68)[/TD]
[TD](236,370.27)[/TD]
[TD](236,370.27)[/TD]
[TD]0.00[/TD]
[TD]0.00[/TD]
[TD](236,370.27)[/TD]
[TD](755.18)[/TD]
[TD](0.52)[/TD]
[TD]100.00[/TD]
[/TR]
[TR]
[TD]TOTAL REBATES/REIMBURSEMENTS[/TD]
[TD](203,450.00)[/TD]
[TD]0.00[/TD]
[TD](203,450.00)[/TD]
[TD]139,460.41[/TD]
[TD](591,900.68)[/TD]
[TD](452,440.27)[/TD]
[TD](452,440.27)[/TD]
[TD]0.00[/TD]
[TD]0.00[/TD]
[TD](248,990.27)[/TD]
[TD](1,445.50)[/TD]
[TD](1.00)[/TD]
[TD]100.00[/TD]
[/TR]
[TR]
[TD]TOTAL FOR JOB 350011 [/TD]
[TD]52,850,000.00[/TD]
[TD]2,727,464.69[/TD]
[TD]55,577,464.69[/TD]
[TD]49,145,800.50[/TD]
[TD]10,896,839.21[/TD]
[TD]60,042,639.71[/TD]
[TD]59,861,351.01[/TD]
[TD]181,288.70[/TD]
[TD]191,821.00[/TD]
[TD]4,465,175.02[/TD]
[TD]191,829.52[/TD]
[TD]132.98[/TD]
[TD]99.70[/TD]
[/TR]
</tbody>[/TABLE]

 

[kweaver]

Trying to understand the logic here...

Without knowing what formulas are in the sample array, suppose the formulas are =SUM(the range of values in each respective category)

If the various total rows have SUM formulas (based on ranges), you're not deleting those rows (constants). However, if/when the formula-based rows are retained, won't the formulas be summing incorrect ranges?

 

[jrhguez]

Hello again: I've been testing it out, but I just realized that is deleting the last two categories toward the bottom of the report..Any ideas?

[TABLE="width: 1645"]
<colgroup><col><col span="13"></colgroup><tbody>[TR]
[TD] TOTAL CONTINGENCY[/TD]
[TD]1,959,361[/TD]
[TD]31,251[/TD]
[TD]1,990,612[/TD]
[TD]0[/TD]
[TD]0[/TD]
[TD]0[/TD]
[TD]0[/TD]
[TD]0[/TD]
[TD]0[/TD]
[TD](1,990,612)[/TD]
[TD]0[/TD]
[TD]0[/TD]
[TD]0[/TD]
[/TR]
[TR]
[TD]TOTAL REBATES/REIMBURSEMENTS[/TD]
[TD](203,450)[/TD]
[TD]0[/TD]
[TD](203,450)[/TD]
[TD]139,460[/TD]
[TD](591,901)[/TD]
[TD](452,440)[/TD]
[TD](452,440)[/TD]
[TD]0[/TD]
[TD]0[/TD]
[TD](248,990)[/TD]
[TD](1,445)[/TD]
[TD](1)[/TD]
[TD]100[/TD]
[/TR]
</tbody>[/TABLE]

 

[Fluff]

Ok, how about

   With Range("D2", Range("D" & Rows.Count).End(xlUp))
      .Value = Evaluate(Replace("if(isnumber(search(""total"",@)),@,"""")", "@", .Address))
      .SpecialCells(xlBlanks).EntireRow.Delete
   End With

 

[jrhguez]

I was wondering if I could bother you with one last favor. Right now all rows read:
TOTAL WARRANTY
TOTAL CONSTRUCTION INSURANCE etc

How possible (for the exception of the last row (TOTAL FOR JOB) to remove the word "TOTAL" from each row? When I recorded the macro, I was able to remove it by the "replacement function"; however, with the last code language you provided, it now deletes all rows that do not have the "total word". Is there way around that?

Thanks again

 

[Fluff]

Add this to the end of the code

   With Range("D2", Range("D" & Rows.Count).End(xlUp).Offset(-1))
      .Replace "Total ", "", xlPart, , False, , False, False
   End With