Spreadsheet: 149189d1333737065-excel-2007-data-table-total-row-wont-calculate-time-employee-2-timecard
Sheet: DATA

 | Client List |  | Cost Code # | Cost Code Category | Cost Code Name |  | Cost Code Combined |  | Time
 | Testing 1 |  | 100.610 | General Condition | Debris Removal & Cleanup |  | 000.001   Lewand Building Companies |  | 05:00:00
 | Testing 2 |  | 100.615 | General Condition | Silt Fencing |  | 000.002   Lunch |  | 05:15:00
 | Testing 3 |  | 100.620 | General Condition | Safety & Control Measures |  |  |  | 05:30:00
 | Testing 4 |  | 100.630 | General Condition | Punchlist & Misc. Construction |  |  |  | 05:45:00
 | Testing 5 |  | 100.635 | General Condition | Final Cleaning,Windows,Ducts |  |  |  | 06:00:00
 | Testing 6 |  | 100.640 | General Condition | Supervision |  |  |  | 06:15:00
 | Testing 7 |  | 101.110 | Sitework | Tree Care |  |  |  | 06:30:00
 | Testing 8 |  | 101.120 | Sitework | Tree Removal |  |  |  | 06:45:00
 | Testing 9 |  | 101.130 | Sitework | Fence Removal |  |  |  | 07:00:00
 | Testing 10 |  | 101.210 | Sitework | Gas Disconnect |  |  |  | 07:15:00
 | Testing 11 |  | 101.220 | Sitework | Electric Disconnect |  |  |  | 07:30:00
 | Testing 12 |  | 101.230 | Sitework | Phone Disconnect |  |  |  | 07:45:00
 | Testing 13 |  | 101.240 | Sitework | Cable TV Disconnect |  |  |  | 08:00:00
 | Testing 14 |  | 101.250 | Sitework | Water Disconnect |  |  |  | 08:15:00
 |  |  | 101.260 | Sitework | Well Capping |  |  |  | 08:30:00
 |  |  | 101.270 | Sitework | [NAME] |  |  |  | 08:45:00
 |  |  | 101.280 | Sitework | Septic Abandonment |  |  |  | 09:00:00
 |  |  | 101.310 | Sitework | Whole-Structure Demolition |  |  |  | 09:15:00
 |  |  | 101.315 | Sitework | Dumpster & Debris Hauling |  |  |  | 09:30:00
 |  |  | 101.320 | Sitework | Interior Demolition |  |  |  | 09:45:00
 |  |  | 101.330 | Sitework | House Moving |  |  |  | 10:00:00
 |  |  | 101.410 | Sitework | Excavation |  |  |  | 10:15:00
 |  |  | 101.415 | Sitework | Soil Hauling |  |  |  | 10:30:00
 |  |  | 101.420 | Sitework | Backfilling |  |  |  | 10:45:00
 |  |  | 101.425 | Sitework | Clean Fill Soil |  |  |  | 11:00:00
 |  |  | 101.510 | Sitework | Storm Drainage |  |  |  | 11:15:00
 |  |  | 101.520 | Sitework | Water Installation |  |  |  | 11:30:00
 |  |  | 101.530 | Sitework | Well Connection |  |  |  | 11:45:00
 |  |  | 101.540 | Sitework | Sewer Installation |  |  |  | 12:00:00
 |  |  | 101.550 | Sitework | Septic System |  |  |  | 12:15:00
 |  |  | 101.560 | Sitework | Natural Gas Service |  |  |  | 12:30:00
 |  |  | 101.565 | Sitework | Propane Tank & Connection |  |  |  | 12:45:00
 |  |  | 101.570 | Sitework | Electric Service |  |  |  | 13:00:00
 |  |  | 101.580 | Sitework | Phone Service |  |  |  | 13:15:00
 |  |  | 101.590 | Sitework | Cable/Satelite TV |  |  |  | 13:30:00
 |  |  | 102.110 | Structure | Foundation Walls |  |  |  | 13:45:00
 |  |  | 102.120 | Structure | Waterproofing |  |  |  | 14:00:00
 |  |  | 102.130 | Structure | Foundation Insulation |  |  |  | 14:15:00
 |  |  | 102.135 | Structure | Helical Piers |  |  |  | 14:30:00
 |  |  | 102.140 | Structure | Trench Foundation Walls |  |  |  | 14:45:00
 |  |  | 102.150 | Structure | Concrete Slab Floors |  |  |  | 15:00:00
 |  |  | 102.210 | Structure | Steel Columns |  |  |  | 15:15:00
 |  |  | 102.220 | Structure | Steel Beams |  |  |  | 15:30:00
 |  |  | 102.230 | Structure | Framing Connectors |  |  |  | 15:45:00
 |  |  | 102.235 | Structure | Steel Erection |  |  |  | 16:00:00
 |  |  | 102.310 | Structure | Conventional Lumber |  |  |  | 16:15:00
 |  |  | 102.320 | Structure | Engineered Lumber |  |  |  | 16:30:00
 |  |  | 102.330 | Structure | Trusses |  |  |  | 16:45:00
 |  |  | 102.340 | Structure | Structural Insulated Panels |  |  |  | 17:00:00
 |  |  | 102.350 | Structure | Post & Beam Timbers |  |  |  | 17:15:00
 |  |  | 102.360 | Structure | Log Home Timbers |  |  |  | 17:30:00
 |  |  | 102.390 | Structure | [NAME]. Framing Materials |  |  |  | 17:45:00
 |  |  | 102.410 | Structure | General Carpentry |  |  |  | 18:00:00
 |  |  | 102.420 | Structure | Cranes, Skytracks, Equip. |  |  |  | 18:15:00
 |  |  | 102.430 | Structure | Temporary Power |  |  |  | 18:30:00
 |  |  | 103.110 | Systems | Plumbing Labor & Piping |  |  |  | 18:45:00
 |  |  | 103.120 | Systems | Gas Piping & Labor |  |  |  | 19:00:00
 |  |  | 103.130 | Systems | Plumbing Equipment |  |  |  | 19:15:00
 |  |  | 103.140 | Systems | Plumbing Fixtures |  |  |  | 19:30:00
 |  |  | 103.150 | Systems | Reverse Osmosis System |  |  |  | 19:45:00
 |  |  | 103.210 | Systems | Air Heating & Duct System |  |  |  | 20:00:00
 |  |  | 103.220 | Systems | Air Conditioning |  |  |  | 20:15:00
 |  |  | 103.230 | Systems | Humidification |  |  |  | 20:30:00
 |  |  | 103.240 | Systems | Air Cleaners |  |  |  | 20:45:00
 |  |  | 103.250 | Systems | [NAME] |  |  |  | 21:00:00
 |  |  | 103.255 | Systems | Boiler System |  |  |  | 21:15:00
 |  |  | 103.260 | Systems | Snowmelt |  |  |  | 21:30:00
 |  |  | 103.270 | Systems | Other Duct Work |  |  |  | 21:45:00
 |  |  | 103.280 | Systems | Miscellaneous HVAC |  |  |  | 22:00:00
 |  |  | 103.310 | Systems | Electric Wiring System |  |  |  | 22:15:00
 |  |  | 103.350 | Systems | Electric Fixtures |  |  |  | 22:30:00
 |  |  | 103.390 | Systems | Automated Lighting Systems |  |  |  | 22:45:00
 |  |  | 103.410 | Systems | A/V, Phone, Data Wiring |  |  |  | 23:00:00
 |  |  | 103.415 | Systems | Phone Equipment |  |  |  | 23:15:00
 |  |  | 103.420 | Systems | Cable/Satellite TV Wiring |  |  |  | 23:30:00
 |  |  | 103.425 | Systems | Cable/Satellite TV Equipment |  |  |  | 23:45:00
 |  |  | 103.430 | Systems | Computer Network Wiring |  |  |  | 00:00:00
 |  |  | 103.435 | Systems | Computer Network Equipment
 |  |  | 103.440 | Systems | Automation Wiring
 |  |  | 103.445 | Systems | Automation Equipment
 |  |  | 103.450 | Systems | Audio Wiring
 |  |  | 103.455 | Systems | Audio Equipment
 |  |  | 103.460 | Systems | Theater Wiring
 |  |  | 103.465 | Systems | Theater Equipment
 |  |  | 103.510 | Systems | Alarm Wiring
 |  |  | 103.515 | Systems | Alarm Equipment
 |  |  | 103.520 | Systems | Fire Supression Systems
 |  |  | 103.530 | Systems | Safes
 |  |  | 103.535 | Systems | Safe Installation
 |  |  | 103.540 | Systems | Safe Room Equipment
 |  |  | 103.545 | Systems | Safe Room Installation
 |  |  | 103.610 | Systems | Central Vacuum Piping
 |  |  | 103.615 | Systems | Central Vacuum Equipment
 |  |  | 103.620 | Systems | Fireplace Unit & Installation
 |  |  | 103.625 | Systems | Fireplace Accessories
 |  |  | 103.630 | Systems | Sauna
 |  |  | 103.640 | Systems | Spa
 |  |  | 103.650 | Systems | Steam Room
 |  |  | 103.655 | Systems | Wine Room/Storage Room
 |  |  | 103.660 | Systems | Wine Racks
 |  |  | 103.665 | Systems | Wine Cellar Equipment
 |  |  | 103.670 | Systems | Dumb Waiter/Wood Waiter
 |  |  | 103.680 | Systems | Reverse Osmosis System
 |  |  | 103.710 | Systems | Elevator
 |  |  | 103.810 | Systems | Fiberglass Insulation
 |  |  | 103.820 | Systems | Sound Control
 |  |  | 103.830 | Systems | Icynene Insulation
 |  |  | 103.840 | Systems | Cellulose Insulation
 |  |  | 103.910 | Systems | Drywall
 |  |  | 103.920 | Systems | Plaster
 |  |  | 103.930 | Systems | Suspended Ceilings
 |  |  | 104.110 | Exterior Finishes | Windows
 |  |  | 104.115 | Exterior Finishes | Leaded [NAME]
 |  |  | 104.120 | Exterior Finishes | Exterior Doors
 |  |  | 104.130 | Exterior Finishes | Garage Doors
 |  |  | 104.210 | Exterior Finishes | Soffit, Facia & Freize Trim
 |  |  | 104.211 | Exterior Finishes | Hewing & Pegs
 |  |  | 104.212 | Exterior Finishes | Brackets
 |  |  | 104.220 | Exterior Finishes | Rake Trim
 |  |  | 104.230 | Exterior Finishes | Window & Door Trim
 |  |  | 104.240 | Exterior Finishes | Cornerboards, Belt Lines, Etc.
 |  |  | 104.250 | Exterior Finishes | Porch Ceilings
 |  |  | 104.260 | Exterior Finishes | Columns
 |  |  | 104.310 | Exterior Finishes | Siding
 |  |  | 104.315 | Exterior Finishes | [NAME]
 |  |  | 104.320 | Exterior Finishes | [NAME]
 |  |  | 104.330 | Exterior Finishes | Stucco
 |  |  | 104.340 | Exterior Finishes | [NAME]. Veneers
 |  |  | 104.410 | Exterior Finishes | Brick
 |  |  | 104.420 | Exterior Finishes | Stone Veneers
 |  |  | 104.430 | Exterior Finishes | Cut Limestone Trims
 |  |  | 104.440 | Exterior Finishes | Chimney & Fireplaces
 |  |  | 104.445 | Exterior Finishes | Mortar & Sand
 |  |  | 104.446 | Exterior Finishes | [NAME]. Mason Supplies
 |  |  | 104.510 | Exterior Finishes | Asphalt Roofing
 |  |  | 104.520 | Exterior Finishes | Wood Shingle Roofing
 |  |  | 104.530 | Exterior Finishes | Composite Roofing
 |  |  | 104.540 | Exterior Finishes | Metal Roofing
 |  |  | 104.550 | Exterior Finishes | EPDM Roofing
 |  |  | 104.590 | Exterior Finishes | Skylights
 |  |  | 104.595 | Exterior Finishes | [NAME]
 |  |  | 104.610 | Exterior Finishes | Metal Flashing
 |  |  | 104.615 | Exterior Finishes | [NAME]
 |  |  | 104.620 | Exterior Finishes | Caulking
 |  |  | 104.630 | Exterior Finishes | Flashing Tape
 |  |  | 104.650 | Exterior Finishes | Gutters
 |  |  | 104.710 | Exterior Finishes | Trim Paint
 |  |  | 104.720 | Exterior Finishes | Siding Painting
 |  |  | 104.730 | Exterior Finishes | Garage Door Finish
 |  |  | 104.740 | Exterior Finishes | Soffit Staining
 |  |  | 104.780 | Exterior Finishes | Exterior Doors Painting
 |  |  | 104.810 | Exterior Finishes | Porches
 |  |  | 104.820 | Exterior Finishes | Screened Porches
 |  |  | 104.830 | Exterior Finishes | Purgola
 |  |  | 104.840 | Exterior Finishes | Deck
 |  |  | 104.910 | Exterior Finishes | Decorative Railings
 |  |  | 104.915 | Exterior Finishes | Shutters
 |  |  | 104.920 | Exterior Finishes | Gates
 |  |  | 104.925 | Exterior Finishes | Metal Railings
 |  |  | 104.930 | Exterior Finishes | [NAME]
 |  |  | 104.935 | Exterior Finishes | Metal Awning
 |  |  | 105.101 | Interior Finishes | Tile Material
 |  |  | 105.102 | Interior Finishes | Tile Installation Labor
 |  |  | 105.103 | Interior Finishes | [NAME]
 |  |  | 105.104 | Interior Finishes | [NAME]
 |  |  | 105.105 | Interior Finishes | Fireplace Hearths & Surrounds
 |  |  | 105.106 | Interior Finishes | Backsplashes
 |  |  | 105.151 | Interior Finishes | [NAME]
 |  |  | 105.152 | Interior Finishes | Designer [NAME]
 |  |  | 105.153 | Interior Finishes | Pergo-type Laminates
 |  |  | 105.201 | Interior Finishes | Carpet
 |  |  | 105.202 | Interior Finishes | [NAME]
 |  |  | 105.203 | Interior Finishes | Exercise Flooring
 |  |  | 105.204 | Interior Finishes | Flooring - Other
 |  |  | 105.251 | Interior Finishes | Interior Doors
 |  |  | 105.253 | Interior Finishes | Base, Casing, Crown Moldings
 |  |  | 105.255 | Interior Finishes | Basic Trim Carpentry
 |  |  | 105.301 | Interior Finishes | Wood Mantles
 |  |  | 105.302 | Interior Finishes | [NAME]
 |  |  | 105.303 | Interior Finishes | Stone Mantles
 |  |  | 105.305 | Interior Finishes | Interior Deco. Columns
 |  |  | 105.307 | Interior Finishes | [NAME]. [NAME]
 |  |  | 105.351 | Interior Finishes | Stair Treads & Stringers
 |  |  | 105.353 | Interior Finishes | Railings, Spindles & Newels
 |  |  | 105.401 | Interior Finishes | Basic Closet Shelving
 |  |  | 105.402 | Interior Finishes | [NAME]
 |  |  | 105.403 | Interior Finishes | Walk-in Closet Systems
 |  |  | 105.451 | Interior Finishes | Built-in Cabinetry
 |  |  | 105.453 | Interior Finishes | Paneling
 |  |  | 105.501 | Interior Finishes | [NAME]
 |  |  | 105.503 | Interior Finishes | Bath Cabinetry
 |  |  | 105.505 | Interior Finishes | Bar/Butler's Pantry Cabinetry
 |  |  | 105.507 | Interior Finishes | Laundry Cabinets
 |  |  | 105.508 | Interior Finishes | Study Cabinetry
 |  |  | 105.509 | Interior Finishes | Mud Room Cabinetry
 |  |  | 105.545 | Interior Finishes | Cabinetry Installation
 |  |  | 105.551 | Interior Finishes | Stone Counters
 |  |  | 105.553 | Interior Finishes | Corion/Composite Counters
 |  |  | 105.555 | Interior Finishes | Formica Countertops
 |  |  | 105.556 | Interior Finishes | Glass Countertops
 |  |  | 105.557 | Interior Finishes | Tile Countertops
 |  |  | 105.601 | Interior Finishes | Basic Painting
 |  |  | 105.605 | Interior Finishes | Built-in Finishing
 |  |  | 105.607 | Interior Finishes | Interior Staining
 |  |  | 105.651 | Interior Finishes | Wall Paper
 |  |  | 105.653 | Interior Finishes | Faux Finishing
 |  |  | 105.701 | Interior Finishes | Kitchen Appliances
 |  |  | 105.703 | Interior Finishes | Washer & Dryer
 |  |  | 105.707 | Interior Finishes | Bar & Butler's Pantry
 |  |  | 105.709 | Interior Finishes | Delivery & Installation
 |  |  | 105.751 | Interior Finishes | Door Hardware
 |  |  | 105.753 | Interior Finishes | Bath Hardware
 |  |  | 105.755 | Interior Finishes | Cabinet Hardware
 |  |  | 105.757 | Interior Finishes | [NAME]. Hardware
 |  |  | 105.801 | Interior Finishes | Mirrors
 |  |  | 105.803 | Interior Finishes | Shower Doors
 |  |  | 105.853 | Interior Finishes | [NAME]
 |  |  | 105.901 | Interior Finishes | Ornamental Ironwork
 |  |  | 105.903 | Interior Finishes | Exercise Equipment
 |  |  | 106.110 | Site Finishes & Landscape | Paving Base
 |  |  | 106.120 | Site Finishes & Landscape | Asphalt
 |  |  | 106.130 | Site Finishes & Landscape | [NAME]. Concrete
 |  |  | 106.140 | Site Finishes & Landscape | Stamped Concrete
 |  |  | 106.150 | Site Finishes & Landscape | Concrete Pavers
 |  |  | 106.160 | Site Finishes & Landscape | Stone Pavers
 |  |  | 106.210 | Site Finishes & Landscape | [NAME]
 |  |  | 106.220 | Site Finishes & Landscape | Patios & Terraces
 |  |  | 106.230 | Site Finishes & Landscape | Finished Landscape Fence
 |  |  | 106.310 | Site Finishes & Landscape | Finish Grade
 |  |  | 106.320 | Site Finishes & Landscape | Topsoil Finish
 |  |  | 106.330 | Site Finishes & Landscape | Planting Beds
 |  |  | 106.410 | Site Finishes & Landscape | Trees
 |  |  | 106.420 | Site Finishes & Landscape | Shrubs
 |  |  | 106.430 | Site Finishes & Landscape | Annual Plantings
 |  |  | 106.440 | Site Finishes & Landscape | Mulching
 |  |  | 106.510 | Site Finishes & Landscape | Sprinkler Systems
 |  |  | 106.520 | Site Finishes & Landscape | Landscape Lighting
 |  |  | 106.610 | Site Finishes & Landscape | Pool
 |  |  | 106.620 | Site Finishes & Landscape | Tennis Courts
 |  |  | 106.630 | Site Finishes & Landscape | Playscapes
 |  |  | 999.999 | Site Finishes & Landscape | Warranty