Spreadsheet: 158111d1337981391-how-do-i-create-a-named-cell-that-moves-when-the-data-is-sorted-sample-schedule
Sheet: Sorted_View

PRODUCTION SCHEDULE
 | Customer: | Lot 4 Model Home | Lot #
 | Contract Date |  | Start Date | 2012-04-15 00:00:00 |  | Todays Date
Category | Phase |  | Proposed Start Date | Actual Start Date | Work Days | Actual Finish Date | % Comp
1 | Order: Trusses |  | 2012-06-01 00:00:00 |  | 0
1 | Order: [NAME] material |  | 2012-06-01 00:00:00 |  | 0
1 | Order: Windows and Exterior Doors |  | 2012-06-01 00:00:00 |  | 0
1 | Order: Steel |  | 2012-06-01 00:00:00 |  | 0
1 | Wallcheck |  | 2012-06-01 00:00:00 |  | 0
2 | Selection Order:Exterior Color Selections |  |  |  | 1
2 | Selection Order: Plumbing Fixtures |  |  |  | 1
2 | Selection Order: Stairs |  |  |  | 0
2 | Selection Order: Cabinets &Tops |  |  |  | 0
2 | Selection Order: Interior Doors |  |  |  | 0
2 | Selection Order: Rails |  |  |  | 0
2 | Selection Order: Garage Doors |  |  |  | 0
2 | Selection Order: Light Fixture Pkg |  |  |  | 1
2 | Selection Order: Finished-In-Place Hardwood |  |  |  | 0
2 | Selection Order: Ceramic |  |  |  | 0
2 | Selection Order: Trim |  |  |  | 0
2 | Selection Order: Interior Paint Selections |  |  |  | 0
2 | Selection Order: Mantel Installation |  |  |  | 0
2 | Selection Order: Appliances |  |  |  | 0
2 | Selection Order: Hardware |  |  |  | 0
2 | Selection Order: Shower Door |  |  |  | 0
2 | Selection Order: Carpet |  |  |  | 0
3 | Permit Application |  |  | 2012-03-14 00:00:00 | 28
3 | Pre-Construction Meeting w/ customer |  |  | 2012-02-15 00:00:00 | 1
3 | Structural Review |  |  |  | 0
3 | Make Plan revisions based on review |  |  |  | 2
3 | Distribute plan sets to contractors |  |  | 2012-01-15 00:00:00 | 2
3 | Install Sediment controls |  |  |  | 1
3 | Stakeout |  |  |  | 1
3 | Excavation |  | 2012-05-21 00:00:00 | 2012-05-21 00:00:00 | 2
3 | Footings |  | 2012-05-23 00:00:00 |  | 2
3 | Footing Inspection |  | 2012-05-24 00:00:00 |  | 0
3 | Foundation |  | 2012-05-25 00:00:00 |  | 5
3 | Drain Tile |  | 2012-06-04 00:00:00 |  | 1
3 | Dampproofing |  | 2012-06-04 00:00:00 |  | 0
3 | D&D Inspection |  | 2012-06-01 00:00:00 |  | 1
3 | Backfill |  | 2012-06-05 00:00:00 |  | 1
3 | Groundworks |  | 2012-06-06 00:00:00 |  | 1
3 | Groundworks Inspection |  | 2012-06-07 00:00:00 |  | 1
3 | Set Steel |  | 2012-06-08 00:00:00 |  | 0
3 | Slab Prep |  | 2012-06-08 00:00:00 |  | 1
3 | Termite |  | 2012-06-11 00:00:00 |  | 1
3 | Slab Inspection |  | 2012-06-11 00:00:00 |  | 0
3 | Slab Pour |  | 2012-06-12 00:00:00 |  | 1
3 | Septic Installation |  | 2012-06-07 00:00:00 | 2012-06-07 00:00:00 | 2
3 | Drywell Installation |  | 2012-06-06 00:00:00 |  | 0
3 | Drywell Inspection |  | 2012-06-11 00:00:00 |  | 0
3 | Framing |  |  |  | 14
3 | Roofing:  [NAME] |  |  |  | 1
3 | Roofing: Shingles |  |  |  | 2
3 | Fireplace |  |  |  | 1
3 | HVAC Rough |  |  |  | 6
3 | Plumbing Rough |  |  | 2012-06-26 00:00:00 | 7
3 | Sprinkler Rough |  |  | 2012-06-26 00:00:00 | 5
3 | Sprinkler Insulation |  |  | 2012-06-26 00:00:00 | 1
3 | Plumbing Inspection |  |  |  | 1
3 | Gas Inspection |  |  |  | 0
3 | Fire Marshall Inspection |  |  |  | 0
3 | Frame Check |  |  | 2012-06-27 00:00:00 | 2
3 | Customer Electrical W/T |  |  | 2012-06-28 00:00:00 | 1
3 | Electrical Rough |  |  |  | 10
3 | Alarm Prewire |  |  |  | 2
3 | Electrical Inspection |  |  |  | 1
3 | Framing Inspection |  |  |  | 1
3 | Schedule BGE |  |  |  | 1
3 | Airseal |  |  |  | 1
3 | Insulation |  |  |  | 1
3 | Insulation Inspection |  |  |  | 1
3 | Stucco Veneer |  |  |  | 4
3 | [NAME] |  |  |  | 3
3 | Siding Installation |  |  |  | 5
3 | Exterior Paint |  |  |  | 2
3 | Drywall Stock |  |  |  | 1
3 | Drywall Hang |  |  |  | 2
3 | Drywall Finish |  |  |  | 5
3 | Drywall Sand |  |  |  | 1
3 | Install Garage doors |  |  |  | 1
3 | Rough Grade/Box Out |  |  |  | 1
3 | Gutters and [NAME] |  |  |  | 1
3 | Exterior Concrete |  |  |  | 1
3 | Finished-In-Place Hardwood Installation |  |  |  | 3
3 | Ceramic Installation |  |  |  | 5
3 | Install Cabinets |  |  | 2012-08-06 00:00:00 | 2
3 | Interior Trim |  |  |  | 5
3 | Install Stair Rails |  |  | 2012-08-13 00:00:00 | 1
3 | Clean for Paint |  |  |  | 1
3 | Paint Prep |  |  |  | 2
3 | First Paint |  |  |  | 2
3 | Appliance Delivery |  |  |  | 1
3 | Final Electric |  |  |  | 5
3 | Final Plumbing |  |  | 2012-08-22 00:00:00 | 5
3 | Final Electrical Insp. |  |  |  | 0
3 | Final Plumbing Insp. |  |  |  | 0
3 | Basement Insulation |  |  |  | 0
3 | Hardware Installation |  |  |  | 2
3 | Driveway Paving
3 | Fine Grade |  |  |  | 1
3 | Landscaping |  |  |  | 1
3 | Seeding |  |  |  | 1
3 | Grading Inspection |  |  |  | 0
3 | Clean for Flooring |  |  |  | 1
3 | Finish Hardwood |  |  |  | 4
3 | Pre-Fin. [NAME] |  |  |  | 1
3 | Carpet installation |  |  |  | 2
3 | Order Final Location Srvy |  |  |  | 1
3 | Point-up |  |  | 2012-08-28 00:00:00 | 1
3 | Final Paint |  |  |  | 1
3 | Punchout |  |  |  | 5
3 | Pre- Walk |  |  |  | 1
3 | U/O
3 | Paint Touch-up
3 | Final Coat Hardwood
3 | Final W-T