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]

 

[Fluff]

Assuming all the figures are values, rather than formulae, how about

Sub jrhguez()
   With Range("B3", Range("B" & Rows.Count).End(xlUp))
      .SpecialCells(xlConstants).Offset(-1).EntireRow.Delete
   End With
End Sub

 

[jrhguez]

I have started a macro because there are other formatting I am trying work with. I tried to copy your rule in my macro, but it gives me error messages.. This is my macro and tried to add your rule at the end..By the way, the "totals" are in column D, not on B...thanks again

Sub Macro4()
'
' Macro4 Macro
'


'
    Range("E2:H2").Select
    Selection.ClearContents
    Range("D3").Select
    Selection.ClearContents
End Sub
Sub PCR_One_Page()
'
' PCR_One_Page Macro
'


'
    Columns("A:A").Select
    Selection.Delete Shift:=xlToLeft
    Columns("D:D").Select
    Selection.Delete Shift:=xlToLeft
    Columns("K:K").Select
    Selection.Delete Shift:=xlToLeft
    Rows("1:4").Select
    Range("D4").Activate
    Selection.RowHeight = 35
    Range("E2:H2").Select
    Selection.ClearContents
    Range("D3").Select
    Selection.ClearContents
    Range("E3").Select
    Selection.ClearContents
    Range("G3:H3").Select
    Selection.Cut
    Range("D3").Select
    ActiveSheet.Paste
    Range("D1:F3").Select
    With Selection.Font
        .Name = "Tahoma"
        .Size = 14
        .Strikethrough = False
        .Superscript = False
        .Subscript = False
        .OutlineFont = False
        .Shadow = False
        .Underline = xlUnderlineStyleNone
        .ThemeColor = xlThemeColorLight1
        .TintAndShade = 0
        .ThemeFont = xlThemeFontNone
    End With
    Range("D3").Select
    With Selection
        .HorizontalAlignment = xlLeft
        .VerticalAlignment = xlBottom
        .WrapText = False
        .Orientation = 0
        .AddIndent = False
        .IndentLevel = 0
        .ShrinkToFit = False
        .ReadingOrder = xlContext
        .MergeCells = False
    End With
    Range("D4:Q4").Select
    With Selection.Font
        .Name = "Tahoma"
        .Size = 8
        .Strikethrough = False
        .Superscript = False
        .Subscript = False
        .OutlineFont = False
        .Shadow = False
        .Underline = xlUnderlineStyleNone
        .ThemeColor = xlThemeColorDark1
        .TintAndShade = 0
        .ThemeFont = xlThemeFontNone
    End With
    With Selection.Font
        .ColorIndex = xlAutomatic
        .TintAndShade = 0
    End With
    With Selection.Interior
        .Pattern = xlSolid
        .PatternColorIndex = xlAutomatic
        .Color = 65535
        .TintAndShade = 0
        .PatternTintAndShade = 0
    End With
    With Selection.Interior
        .Pattern = xlSolid
        .PatternColorIndex = xlAutomatic
        .ThemeColor = xlThemeColorDark1
        .TintAndShade = -4.99893185216834E-02
        .PatternTintAndShade = 0
    End With
    Selection.Font.Bold = False
    Range("E5:Q134").Select
    Selection.NumberFormat = "#,#[URL="https://www.mrexcel.com/forum/usertag.php?do=list&action=hash&hash=0_"]#0_[/URL] );(#,##0)"
    Columns("E:Q").Select
    Selection.ColumnWidth = 15
    Columns("D:D").Select
    Selection.ColumnWidth = 35
    Range("F3").Select
    ActiveWindow.SmallScroll Down:=-147
End Sub
[B]sub[/B]
[B]With Range("d5", Range("d" & Rows.Count).End(xlUp))[/B]
[B]      .SpecialCells(xlConstants).Offset(-1).EntireRow.Delete[/B]
[B]   End With[/B]
[B]End Sub[/B]

 

[Fluff]

Which column is "Category" in?

 

[jrhguez]

Originally is on F, but the original file we need to delete: Column A (Job), Column E (Category Code) and Column M(Cost for Current Month)..After deleting those 3 columns (which I recorded in the macro I sent you); "category" ends up on column D. I could send you the report it self if you are not clear

 

[Fluff]

In that case try

Sub jrhguez()
   With Range("E3", Range("E" & Rows.Count).End(xlUp))
      .SpecialCells(xlConstants).Offset(-1).EntireRow.Delete
   End With
End Sub

 

[jrhguez]

Do i just copy what you wrote to the bottom of the macro? Do i need to include "sub jrhguez()? The reason I am asking, is bc I am getting the following message:
"Compile error: only comments may appear after end sub, end function or End property"

 

[Fluff]

Firstly just run it on it's own (after running your code) to see if it does what you need

 

[jrhguez]

it looks like it worked..so how could i incorporate that into my existing macro, the one I sent you..thank you

 

[Fluff]

Simply add this

   With Range("E3", Range("E" & Rows.Count).End(xlUp))
      .SpecialCells(xlConstants).Offset(-1).EntireRow.Delete
   End With

just before the End Sub line of your code