Spreadsheet: 681231d1591418561-index-match-syntax-to-include-a-separate-tab-sheet-excel-forum-worksheet-for-index-match-across-multiple-sheets
Sheet: Slabs-Installs-Revenue 2021

 |  |  |  |  | WEEK 1 | WEEK 1 | WEEK 1 | WEEK 2 | WEEK 2 | WEEK 2 | WEEK 3 | WEEK 3 | WEEK 3 | WEEK 4 | WEEK 4 | WEEK 4 | WEEK 5 | WEEK 5 | WEEK 5 | WEEK 6 | WEEK 6 | WEEK 6 | WEEK 7 | WEEK 7 | WEEK 7 | WEEK 8 | WEEK 8 | WEEK 8 | WEEK 9 | WEEK 9 | WEEK 9 | WEEK 10 | WEEK 10 | WEEK 10 | WEEK 11 | WEEK 11 | WEEK 11 | WEEK 12 | WEEK 12 | WEEK 12 | WEEK 13 | WEEK 13 | WEEK 13 | WEEK 14 | WEEK 14 | WEEK 14 | WEEK 15 | WEEK 15 | WEEK 15 | WEEK 16 | WEEK 16 | WEEK 16 | WEEK 17 | WEEK 17 | WEEK 17 | WEEK 18 | WEEK 18 | WEEK 18 | WEEK 19 | WEEK 19 | WEEK 19 | WEEK 20 | WEEK 20 | WEEK 20 | WEEK 21 | WEEK 21 | WEEK 21 | WEEK 22 | WEEK 22 | WEEK 22 | WEEK 23 | WEEK 23 | WEEK 23 | WEEK 24 | WEEK 24 | WEEK 24 | WEEK 25 | WEEK 25 | WEEK 25 | WEEK 26 | WEEK 26 | WEEK 26 | WEEK 27 | WEEK 27 | WEEK 27 | WEEK 28 | WEEK 28 | WEEK 28 | WEEK 29 | WEEK 29 | WEEK 29 | WEEK 30 | WEEK 30 | WEEK 30 | WEEK 31 | WEEK 31 | WEEK 31 | WEEK 32 | WEEK 32 | WEEK 32 | WEEK 33 | WEEK 33 | WEEK 33 | WEEK 34 | WEEK 34 | WEEK 34 | WEEK 35 | WEEK 35 | WEEK 35 | WEEK 36 | WEEK 36 | WEEK 36 | WEEK 37 | WEEK 37 | WEEK 37 | WEEK 38 | WEEK 38 | WEEK 38 | WEEK 39 | WEEK 39 | WEEK 39 | WEEK 40 | WEEK 40 | WEEK 40 | WEEK 41 | WEEK 41 | WEEK 41 | WEEK 42 | WEEK 42 | WEEK 42 | WEEK 43 | WEEK 43 | WEEK 43 | WEEK 44 | WEEK 44 | WEEK 44 | WEEK 45 | WEEK 45 | WEEK 45 | WEEK 46 | WEEK 46 | WEEK 46 | WEEK 47 | WEEK 47 | WEEK 47 | WEEK 48 | WEEK 48 | WEEK 48 | WEEK 49 | WEEK 49 | WEEK 49 | WEEK 50 | WEEK 50 | WEEK 50 | WEEK 51 | WEEK 51 | WEEK 51 | WEEK 52 | WEEK 52 | WEEK 52 | WEEK 53 | WEEK 53 | WEEK 53
 |  |  |  | SLAB DATES |  | 2021-01-04 00:00:00 |  |  | 2021-01-11 00:00:00 |  |  | 2020-01-18 00:00:00 |  |  | 2021-01-25 00:00:00 |  |  | 2021-02-01 00:00:00 |  |  | 2021-02-08 00:00:00 |  |  | 2021-02-15 00:00:00 |  |  | 2021-02-22 00:00:00 |  |  | 2021-03-01 00:00:00 |  |  | 2021-03-08 00:00:00 |  |  | 2021-03-15 00:00:00 |  |  | 2021-03-22 00:00:00 |  |  | 2021-03-29 00:00:00 |  |  | 2021-04-05 00:00:00 |  |  | 2021-04-12 00:00:00 |  |  | 2021-04-19 00:00:00 |  |  | 2021-04-26 00:00:00 |  |  | 2021-05-03 00:00:00 |  |  | 2021-05-10 00:00:00 |  |  | 2021-05-17 00:00:00 |  |  | 2021-05-24 00:00:00 |  |  | 2021-05-31 00:00:00 |  |  | 2021-06-07 00:00:00 |  |  | 2021-06-14 00:00:00 |  |  | 2021-06-21 00:00:00 |  |  | 2021-06-28 00:00:00 |  |  | 2021-07-05 00:00:00 |  |  | 2021-07-12 00:00:00 |  |  | 2021-07-19 00:00:00 |  |  | 2021-07-26 00:00:00 |  |  | 2021-08-02 00:00:00 |  |  | 2021-08-09 00:00:00 |  |  | 2021-08-16 00:00:00 |  |  | 2021-08-23 00:00:00 |  |  | 2021-08-30 00:00:00 |  |  | 2021-09-06 00:00:00 |  |  | 2021-09-13 00:00:00 |  |  | 2021-09-20 00:00:00 |  |  | 2021-09-27 00:00:00 |  |  | 2021-10-04 00:00:00 |  |  | 2021-10-11 00:00:00 |  |  | 2021-10-18 00:00:00 |  |  | 2021-10-25 00:00:00 |  |  | 2021-11-01 00:00:00 |  |  | 2021-11-08 00:00:00 |  |  | 2021-11-15 00:00:00 |  |  | 2021-11-22 00:00:00 |  |  | 2021-11-29 00:00:00 |  |  | 2021-12-06 00:00:00 |  |  | 2021-12-31 00:00:00 |  |  | 2021-12-20 00:00:00 |  |  | 2021-12-27 00:00:00
 |  |  |  |  | JAN 4 - JAN 10 | JAN 4 - JAN 10 | JAN 4 - JAN 10 | JAN 11 - JAN 17 | JAN 11 - JAN 17 | JAN 11 - JAN 17 | JAN 18 - JAN 24 | JAN 18 - JAN 24 | JAN 18 - JAN 24 | JAN 25 - JAN 31 | JAN 25 - JAN 31 | JAN 25 - JAN 31 | FEB 1 - FEB 7 | FEB 1 - FEB 7 | FEB 1 - FEB 7 | FEB 8 - FEB 14 | FEB 8 - FEB 14 | FEB 8 - FEB 14 | FEB 15 - FEB 21 | FEB 15 - FEB 21 | FEB 15 - FEB 21 | FEB 22 - FEB 28 | FEB 22 - FEB 28 | FEB 22 - FEB 28 | MAR 1 - MAR 7 | MAR 1 - MAR 7 | MAR 1 - MAR 7 | MAR 8 - MAR 14 | MAR 8 - MAR 14 | MAR 8 - MAR 14 | MAR 15 - MAR 21 | MAR 15 - MAR 21 | MAR 15 - MAR 21 | MAR 22 - MAR 28 | MAR 22 - MAR 28 | MAR 22 - MAR 28 | MAR 29 - APR 4 | MAR 29 - APR 4 | MAR 29 - APR 4 | APR 5 - APR 11 | APR 5 - APR 11 | APR 5 - APR 11 | APR 12 - APR 18 | APR 12 - APR 18 | APR 12 - APR 18 | APR 19 - APR 25 | APR 19 - APR 25 | APR 19 - APR 25 | APR 26 - MAY 2 | APR 26 - MAY 2 | APR 26 - MAY 2 | MAY 3 - MAY 9 | MAY 3 - MAY 9 | MAY 3 - MAY 9 | MAY 10 - MAY 16 | MAY 10 - MAY 16 | MAY 10 - MAY 16 | MAY 17 - MAY 23 | MAY 17 - MAY 23 | MAY 17 - MAY 23 | MAY 24 - MAY 30 | MAY 24 - MAY 30 | MAY 24 - MAY 30 | MAY 31 - JUNE 6 | MAY 31 - JUNE 6 | MAY 31 - JUNE 6 | JUNE 7 - JUNE 13 | JUNE 7 - JUNE 13 | JUNE 7 - JUNE 13 | [NAME] 14 - JUN 20 | [NAME] 14 - JUN 20 | [NAME] 14 - JUN 20 | JUN 21 - JUNE 27 | JUN 21 - JUNE 27 | JUN 21 - JUNE 27 | JUNE 28 - JULY 4 | JUNE 28 - JULY 4 | JUNE 28 - JULY 4 | JULY 5 - JULY 11 | JULY 5 - JULY 11 | JULY 5 - JULY 11 | JULY 12 - JULY 18 | JULY 12 - JULY 18 | JULY 12 - JULY 18 | JULY 19 - JULY 25 | JULY 19 - JULY 25 | JULY 19 - JULY 25 | JULY 26 - AUG 1 | JULY 26 - AUG 1 | JULY 26 - AUG 1 | AUG 2 - AUG 8 | AUG 2 - AUG 8 | AUG 2 - AUG 8 | AUG 9 - AUG 15 | AUG 9 - AUG 15 | AUG 9 - AUG 15 | AUG 16 - AUG 22 | AUG 16 - AUG 22 | AUG 16 - AUG 22 | AUG 23 - AUG 29 | AUG 23 - AUG 29 | AUG 23 - AUG 29 | AUG 30 - SEPT 5 | AUG 30 - SEPT 5 | AUG 30 - SEPT 5 | SEPT 6 - SEPT 12 | SEPT 6 - SEPT 12 | SEPT 6 - SEPT 12 | SEPT 13 - SEPT 19 | SEPT 13 - SEPT 19 | SEPT 13 - SEPT 19 | SEPT 20 - SEPT 26 | SEPT 20 - SEPT 26 | SEPT 20 - SEPT 26 | SEPT 27 - OCT 3 | SEPT 27 - OCT 3 | SEPT 27 - OCT 3 | OCT 4 - OCT 10 | OCT 4 - OCT 10 | OCT 4 - OCT 10 | OCT 11 - OCT 17 | OCT 11 - OCT 17 | OCT 11 - OCT 17 | OCT 18 - OCT 24 | OCT 18 - OCT 24 | OCT 18 - OCT 24 | OCT 25 - OCT 31 | OCT 25 - OCT 31 | OCT 25 - OCT 31 | NOV 1 - NOV 7 | NOV 1 - NOV 7 | NOV 1 - NOV 7 | NOV 8 - NOV 14 | NOV 8 - NOV 14 | NOV 8 - NOV 14 | NOV 15 - NOV 21 | NOV 15 - NOV 21 | NOV 15 - NOV 21 | NOV 22 - NOV 28 | NOV 22 - NOV 28 | NOV 22 - NOV 28 | NOV 29 - DEC 5 | NOV 29 - DEC 5 | NOV 29 - DEC 5 | DEC 6 - DEC 12 | DEC 6 - DEC 12 | DEC 6 - DEC 12 | DEC 13 - DEC 19 | DEC 13 - DEC 19 | DEC 13 - DEC 19 | DEC 20 - DEC 26 | DEC 20 - DEC 26 | DEC 20 - DEC 26 | DEC 27 - JAN 2 | DEC 27 - JAN 2 | DEC 27 - JAN 2
Builder | Subdivision | Field Rep | Subdivision Average DAYS to Build  Time (Slab to Tile) | Average Price/Each | Number of Slabs | Estimated  Install Dates | Estimated Revenue | Number of Slabs | Estimated  Install Dates | Estimated Revenue | Number of Slabs | Estimated  Install Dates | Estimated Revenue | Number of Slabs | Estimated  Install Dates | Estimated Revenue | Number of Slabs | Estimated  Install Dates | Estimated Revenue | Number of Slabs | Estimated  Install Dates | Estimated Revenue | Number of Slabs | Estimated  Install Dates | Estimated Revenue | Number of Slabs | Estimated  Install Dates | Estimated Revenue | Number of Slabs | Estimated  Install Dates | Estimated Revenue | Number of Slabs | Estimated  Install Dates | Estimated Revenue | Number of Slabs | Estimated  Install Dates | Estimated Revenue | Number of Slabs | Estimated  Install Dates | Estimated Revenue | Number of Slabs | Estimated  Install Dates | Estimated Revenue | Number of Slabs | Estimated  Install Dates | Estimated Revenue | Number of Slabs | Estimated  Install Dates | Estimated Revenue | Number of Slabs | Estimated  Install Dates | Estimated Revenue | Number of Slabs | Estimated  Install Dates | Estimated Revenue | Number of Slabs | Estimated  Install Dates | Estimated Revenue | Number of Slabs | Estimated  Install Dates | Estimated Revenue | Number of Slabs | Estimated  Install Dates | Estimated Revenue | Number of Slabs | Estimated  Install Dates | Estimated Revenue | Number of Slabs | Estimated  Install Dates | Estimated Revenue | Number of Slabs | Estimated  Install Dates | Estimated Revenue | Number of Slabs | Estimated  Install Dates | Estimated Revenue | Number of Slabs | Estimated  Install Dates | Estimated Revenue | Number of Slabs | Estimated  Install Dates | Estimated Revenue | Number of Slabs | Estimated  Install Dates | Estimated Revenue | Number of Slabs | Estimated  Install Dates | Estimated Revenue | Number of Slabs | Estimated  Install Dates | Estimated Revenue | Number of Slabs | Estimated  Install Dates | Estimated Revenue | Number of Slabs | Estimated  Install Dates | Estimated Revenue | Number of Slabs | Estimated  Install Dates | Estimated Revenue | Number of Slabs | Estimated  Install Dates | Estimated Revenue | Number of Slabs | Estimated  Install Dates | Estimated Revenue | Number of Slabs | Estimated  Install Dates | Estimated Revenue | Number of Slabs | Estimated  Install Dates | Estimated Revenue | Number of Slabs | Estimated  Install Dates | Estimated Revenue | Number of Slabs | Estimated  Install Dates | Estimated Revenue | Number of Slabs | Estimated  Install Dates | Estimated Revenue | Number of Slabs | Estimated  Install Dates | Estimated Revenue | Number of Slabs | Estimated  Install Dates | Estimated Revenue | Number of Slabs | Estimated  Install Dates | Estimated Revenue | Number of Slabs | Estimated  Install Dates | Estimated Revenue | Number of Slabs | Estimated  Install Dates | Estimated Revenue | Number of Slabs | Estimated  Install Dates | Estimated Revenue | Number of Slabs | Estimated  Install Dates | Estimated Revenue | Number of Slabs | Estimated  Install Dates | Estimated Revenue | Number of Slabs | Estimated  Install Dates | Estimated Revenue | Number of Slabs | Estimated  Install Dates | Estimated Revenue | Number of Slabs | Estimated  Install Dates | Estimated Revenue | Number of Slabs | Estimated  Install Dates | Estimated Revenue | Number of Slabs | Estimated  Install Dates | Estimated Revenue | Number of Slabs | Estimated  Install Dates | Estimated Revenue
[NAME] | Crossings at Wells Branch | Darin | 135 | 4500
[NAME] | Diamond Oaks | Darin | 135 | 5000
[NAME] | Trails at Blackhawk | Darin | 135 | 4500
[NAME] | Addison | Manuel | 135 | 8302
[NAME] | Belterra | Mario | 135 | 8302
[NAME] | [NAME] | [NAME] | 135 | 8302
[NAME] | [NAME] | Mario | 135 | 8302
[NAME] | Creekside | [NAME] | 135 | 7636
[NAME] | [NAME] | [NAME] | 135 | 8302
[NAME] | Easton Park | Manuel | 135 | 8302
[NAME] | Kissing Tree - Cottages & Villas | [NAME] | 135 | 8302
[NAME] | Kissing Tree - Traditional | [NAME] | 135 | 12959
[NAME] | Provence | Alonzo | 135 | 8302
[NAME] | Santa Rita | [NAME] | 135 | 8302
[NAME] | Wild Rock | [NAME] | 135 | 8302
Buffington | [NAME] | [NAME] | 135 | 7654
Buffington | Colony | [NAME] | 135 | 7654
Buffington | [NAME] | Darin | 135 | 7654
Buffington | Penley Park | Darin | 135 | 7654
Buffington | Rutherford | Mario | 135 | 7654
Buffington | Shadow Glen | Manuel | 135 | 7654
Buffington | Trace | [NAME] | 135 | 7654
Buffington | University Park | Darin | 135 | 7654
Buffington | [NAME] | Manuel | 135 | 7654
Lennar | Mueller | Garza/Justin | 150 | 4911
M/I | Arrowhead | Mario | 120 | 10970
M/I | Bear Creek Crossing | [NAME] | 120 | 10368
M/I | Belterra | Mario | 120 | 12073
M/I | Morning Star | Darin | 90 | 7221
M/I | Plum Creek | [NAME] | 120 | 7019
Milestone | Grove | Garza/Justin | 120 | 23649
Milestone | Hills of Bear Creek | [NAME] | 120 | 8113
Milestone | S. Congress | Manuel | 120 | 6716
Milestone | Smithfield | [NAME] | 120 | 7595
Milestone | Summerow | [NAME] | 120 | 6985
Milestone | Vistas | Manuel | 120 | 5398
Newmark | Rough Hollow | Alonzo | 135 | 8302
Pacesetter | Saddlecreek | Darin | 120 | 3700
Prominence | [NAME] | [NAME] | 180 | 6988
Prominence | [NAME] | Darin | 240 | 6537
Prominence | [NAME] | [NAME] | 180 | 7248
Pulte | [NAME] | [NAME] | 150 | 9559
Pulte | Santa Rita | [NAME] | 150 | 7765
Pulte | [NAME] | [NAME] | 150 | 8661
[NAME] | Belterra | Mario | 150 | 24452
[NAME] | Mason Hills | [NAME] | 150 | 29564
[NAME] | [NAME] | [NAME] | 150 | 23826
Trendmaker | Belterra | Mario | 135 | 8302
Trendmaker | [NAME] | [NAME] | 135 | 8302
 |  |  |  |  | JAN 4 - JAN 10 | JAN 4 - JAN 10 | JAN 4 - JAN 10 | JAN 11 - JAN 17 | JAN 11 - JAN 17 | JAN 11 - JAN 17 | JAN 18 - JAN 24 | JAN 18 - JAN 24 | JAN 18 - JAN 24 | JAN 25 - JAN 31 | JAN 25 - JAN 31 | JAN 25 - JAN 31 | FEB 1 - FEB 7 | FEB 1 - FEB 7 | FEB 1 - FEB 7 | FEB 8 - FEB 14 | FEB 8 - FEB 14 | FEB 8 - FEB 14 | FEB 15 - FEB 21 | FEB 15 - FEB 21 | FEB 15 - FEB 21 | FEB 22 - FEB 28 | FEB 22 - FEB 28 | FEB 22 - FEB 28 | MAR 1 - MAR 7 | MAR 1 - MAR 7 | MAR 1 - MAR 7 | MAR 8 - MAR 14 | MAR 8 - MAR 14 | MAR 8 - MAR 14 | MAR 15 - MAR 21 | MAR 15 - MAR 21 | MAR 15 - MAR 21 | MAR 22 - MAR 28 | MAR 22 - MAR 28 | MAR 22 - MAR 28 | MAR 29 - APR 4 | MAR 29 - APR 4 | MAR 29 - APR 4 | APR 5 - APR 11 | APR 5 - APR 11 | APR 5 - APR 11 | APR 12 - APR 18 | APR 12 - APR 18 | APR 12 - APR 18 | APR 19 - APR 25 | APR 19 - APR 25 | APR 19 - APR 25 | APR 26 - MAY 2 | APR 26 - MAY 2 | APR 26 - MAY 2 | MAY 3 - MAY 9 | MAY 3 - MAY 9 | MAY 3 - MAY 9 | MAY 10 - MAY 16 | MAY 10 - MAY 16 | MAY 10 - MAY 16 | MAY 17 - MAY 23 | MAY 17 - MAY 23 | MAY 17 - MAY 23 | MAY 24 - MAY 30 | MAY 24 - MAY 30 | MAY 24 - MAY 30 | MAY 31 - JUNE 6 | MAY 31 - JUNE 6 | MAY 31 - JUNE 6 | JUNE 7 - JUNE 13 | JUNE 7 - JUNE 13 | JUNE 7 - JUNE 13 | [NAME] 14 - JUN 20 | [NAME] 14 - JUN 20 | [NAME] 14 - JUN 20 | JUN 21 - JUNE 27 | JUN 21 - JUNE 27 | JUN 21 - JUNE 27 | JUNE 28 - JULY 4 | JUNE 28 - JULY 4 | JUNE 28 - JULY 4 | JULY 5 - JULY 11 | JULY 5 - JULY 11 | JULY 5 - JULY 11 | JULY 12 - JULY 18 | JULY 12 - JULY 18 | JULY 12 - JULY 18 | JULY 19 - JULY 25 | JULY 19 - JULY 25 | JULY 19 - JULY 25 | JULY 26 - AUG 1 | JULY 26 - AUG 1 | JULY 26 - AUG 1 | AUG 2 - AUG 8 | AUG 2 - AUG 8 | AUG 2 - AUG 8 | AUG 9 - AUG 15 | AUG 9 - AUG 15 | AUG 9 - AUG 15 | AUG 16 - AUG 22 | AUG 16 - AUG 22 | AUG 16 - AUG 22 | AUG 23 - AUG 29 | AUG 23 - AUG 29 | AUG 23 - AUG 29 | AUG 30 - SEPT 5 | AUG 30 - SEPT 5 | AUG 30 - SEPT 5 | SEPT 6 - SEPT 12 | SEPT 6 - SEPT 12 | SEPT 6 - SEPT 12 | SEPT 13 - SEPT 19 | SEPT 13 - SEPT 19 | SEPT 13 - SEPT 19 | SEPT 20 - SEPT 26 | SEPT 20 - SEPT 26 | SEPT 20 - SEPT 26 | SEPT 27 - OCT 3 | SEPT 27 - OCT 3 | SEPT 27 - OCT 3 | OCT 4 - OCT 10 | OCT 4 - OCT 10 | OCT 4 - OCT 10 | OCT 11 - OCT 17 | OCT 11 - OCT 17 | OCT 11 - OCT 17 | OCT 18 - OCT 24 | OCT 18 - OCT 24 | OCT 18 - OCT 24 | OCT 25 - OCT 31 | OCT 25 - OCT 31 | OCT 25 - OCT 31 | NOV 1 - NOV 7 | NOV 1 - NOV 7 | NOV 1 - NOV 7 | NOV 8 - NOV 14 | NOV 8 - NOV 14 | NOV 8 - NOV 14 | NOV 15 - NOV 21 | NOV 15 - NOV 21 | NOV 15 - NOV 21 | NOV 22 - NOV 28 | NOV 22 - NOV 28 | NOV 22 - NOV 28 | NOV 29 - DEC 5 | NOV 29 - DEC 5 | NOV 29 - DEC 5 | DEC 6 - DEC 12 | DEC 6 - DEC 12 | DEC 6 - DEC 12 | DEC 13 - DEC 19 | DEC 13 - DEC 19 | DEC 13 - DEC 19 | DEC 20 - DEC 26 | DEC 20 - DEC 26 | DEC 20 - DEC 26 | DEC 27 - JAN 2 | DEC 27 - JAN 2 | DEC 27 - JAN 2
TOTALS (ALL SUBDIVISIONS)