{"text_format":"3","workbook":"xlsx","n_sheets":3,"sheets":["2022 Floorplan","Converted 2019 Plan","2019 Floorplan"],"not_rendered":{"images":13,"macros":1,"defined_names":1,"comments":3},"read":"whole","date_system":"1900"}

{"sheet":"2022 Floorplan","index":0,"n_rows":31,"n_cols":46,"rows_kept":31,"merged":[[1,9,3,12],[1,16,1,17],[1,30,1,31],[1,38,1,39],[1,42,2,45],[3,24,4,24],[3,42,5,45],[5,7,5,14],[5,24,5,25],[5,36,5,37],[8,29,8,32],[9,18,12,19],[9,24,9,25],[9,36,9,37],[9,39,9,40],[9,42,9,43],[10,3,12,4],[10,24,10,25],[10,39,10,40],[11,21,12,22],[11,24,12,25],[11,36,12,37],[11,39,12,40],[11,42,12,43],[13,16,14,44],[15,3,15,5],[15,6,18,6],[15,18,16,19],[15,21,16,22],[15,24,16,25],[15,36,16,37],[15,39,16,40],[15,42,16,43],[16,1,17,5],[16,15,17,15],[17,7,23,14],[17,16,18,16],[17,21,17,22],[18,1,18,5],[18,21,19,21],[18,24,18,25],[18,36,18,37],[18,39,19,39],[19,1,22,2],[19,3,22,5],[19,24,19,25],[19,36,19,37],[20,19,21,19],[20,21,20,22],[20,24,20,25],[21,24,22,25],[21,27,22,29],[21,32,22,34],[21,36,22,37],[21,45,23,45],[24,16,24,17],[24,31,24,32],[24,38,24,39],[25,6,26,15],[29,8,29,9],[29,10,29,11],[29,14,29,15],[29,16,29,17],[29,20,29,21],[29,22,29,23],[29,26,29,27],[29,28,29,29],[29,32,29,33],[29,34,29,35],[29,38,29,39],[30,8,30,9],[30,10,30,11],[30,14,30,15],[30,16,30,17],[30,20,30,21],[30,22,30,23],[30,26,30,27],[30,28,30,29],[30,32,30,33],[30,34,30,35]]}
[]
[{"$nulls":9},"KITCHEN 40'x25'",{"$nulls":6},"FIRE",null,30,31,32,33,"FIRE",35,36,37,{"$nulls":4},"FIRE",{"$nulls":5},48,49,"FIRE",null,52,null,"VIP LOUNGE 36'x14'"]
[]
[{"$nulls":16},140,null,139,240,null,238,340,null," 337 & 339",440,{"$nulls":10},739,840,null,839,940,null,"40' x 30'"]
[{"$nulls":16},138,null,137,238,null,237,338,null,null,438,{"$nulls":10},737,838,null,837,938]
[{"$nulls":7},"SalesCamp / Education Area",{"$nulls":8},136,{"$nulls":4},235,336,null," 335 / 436",{"$nulls":11}," 735 / 836",null,null,835,936]
[{"$nulls":16},134,null,133,234,{"$nulls":25},1033]
[{"$nulls":16},132,null,131,232,null,231,332,null,331,432,{"$nulls":10},731,832,null,831,932,null,931,1032,null,1031]
[{"$nulls":16},130,{"$nulls":4},229,330,null,329,430,{"$nulls":3},"Food Serving",{"$nulls":6},729,830,null,829,930,null,929,1030,null,1029]
[{"$nulls":16},128,null,"$9,995 Huber Engineered Wood 121",null,null,227,328,null," 327 / 428",{"$nulls":11}," 727 / 828",null,null,"827 / 928",null,null," 927 / 1028",null,null,1027]
[{"$nulls":3},"KITCHEN",{"$nulls":12},126,{"$nulls":28},1025]
[{"$nulls":16},124,{"$nulls":4},"$5,995 SavariaUSA   221",null,null,"$5,995 Bartley Corp 321",{"$nulls":11},"$5,995 Forbes 721",null,null,"$5,995 OPEN 821",null,null,"$4,995 OPEN 921",null,null,1023]
[{"$nulls":16},122,{"$nulls":28},1021]
[{"$nulls":16},"                  BOOTHS IN RED = RESERVED / YELLOW = OCCUPIED",{"$nulls":28},1019]
[{"$nulls":45},1017]
[null,"HGRV",null,"SHOW OFFICE",{"$nulls":12},116,null,"$5,995  MBIA  115",null,null,"$5,995  Modern Foundations 215",null,null,"$5,995 GE           315",{"$nulls":11},"$5,995 Guaranteed Rate 715",null,null,"$5,995 Milwaukee Tool       815",null,null,"$4,995 Adrian Steel   915",null,null,1015]
[null,"Exhibitor Lounge",{"$nulls":14},114,{"$nulls":28},1013]
[{"$nulls":7},"REGISTRATION",{"$nulls":8},"110 & 112",{"$nulls":11},"_ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ ",{"$nulls":16},1011]
[null,"Restrooms",{"$nulls":16},109,210,null,"207 / 209",310,null,"309 / 410",{"$nulls":3},"_ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ ",{"$nulls":7}," 709 / 810",null,null,"807/809",910,null,909,1010,null,1009]
[null,"Women Restroom",null,"Men Restroom",{"$nulls":12},108,null,107,208,null,null,308,null,"307 / 408",{"$nulls":3},"_ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ ",{"$nulls":7},"707 / 808",{"$nulls":3},908,null,907,1008,null,1007]
[{"$nulls":16},106,null,105,"204 / 206",{"$nulls":25},1005]
[{"$nulls":16},104,null,103,null,null,203,304,null,"$5,995 Shelter Systems 301",null,null,"MBIA / HBCF ? (TBD)",{"$nulls":4},"SalesCentral / Demo Stage? (TBD)",{"$nulls":3},"$4,995 Royal Building Products 701",null,null,803,904,null,903,1004,null," 1000 - 1003"]
[{"$nulls":16},102,null,101,202,null,201,302,{"$nulls":16},801,902,null,901,1002]
[{"$nulls":16},100,null," "]
[{"$nulls":18},1,2,3,4,"FIRE",6,7,8,9,10,11,12,"FIRE","14/15",null,16,17,18,19,20,"FIRE",null,23,24,25,26]
[{"$nulls":6},"MAIN ENTRANCE",{"$nulls":28},"*Booths in red have pole in front or back corner of booth."]
[{"$nulls":28}," RED / YELLOW = RESERVED",{"$nulls":6},"*Booths along the front and back walls are 8x10 booths."]
[]
[{"$nulls":7},"# available",null,"Price:",{"$nulls":3},"# available",null,"Price:",{"$nulls":3},"# available",null,"Price:",{"$nulls":3},"# available",null,"Price:",{"$nulls":3},"# available",null,"Price:",{"$nulls":3},"# available",null,"Price:",null,null,"# reserved"]
[{"$nulls":7},{"$f":"CountCellsByColor(Q2:AT25, G30)","v":3},{"v":995,"d":"$995.00"},{"$nulls":4},{"$f":"CountCellsByColor(Q2:AT25, M30)","v":17},{"v":1395,"d":"$1,395.00"},{"$nulls":4},{"$f":"CountCellsByColor(Q2:AT25, S30)","v":24},{"v":1195,"d":"$1,195.00"},{"$nulls":4},{"$f":"CountCellsByColor(Q2:AT25, Y30)","v":1},{"v":1545,"d":"$1,545.00"},{"$nulls":4},{"$f":"CountCellsByColor(Q2:AT25, AE30)/2","v":1},{"v":2695,"d":"$2,695.00"},{"$nulls":4},{"$f":"CountCellsByColor(Q2:AT25, AK30)/3","v":0},{"v":3995,"d":"$3,995.00"},{"$nulls":3},{"$f":"CountCellsByColor(Q2:AT25, AP30)","v":16}]
[{"$nulls":7},{"$f":"CountCellsByColor(Q2:AT25, G31)","v":0},{"v":2995,"d":"$2,995.00"},{"$nulls":4},{"$f":"CountCellsByColor(Q2:AT25, M31)/4","v":1},{"v":5995,"d":"$5,995.00"},{"$nulls":4},{"$f":"CountCellsByColor(Q2:AT25, S31)/4","v":0},{"v":7995,"d":"$7,995.00"},{"$nulls":4},{"$f":"CountCellsByColor(Q2:AT25, Y31)/8","v":0},{"v":9995,"d":"$9,995.00"},{"$nulls":4},{"$f":"CountCellsByColor(Q2:AT25, AE31)/4","v":1},{"v":4995,"d":"$4,995.00"},{"$nulls":9},{"$f":"CountCellsByColor(Q3:AT26, AP31)","v":147}]

{"sheet":"Converted 2019 Plan","index":1,"n_rows":31,"n_cols":46,"rows_kept":31,"merged":[[1,9,3,12],[1,16,1,17],[1,30,1,31],[1,38,1,39],[1,42,2,45],[3,21,4,21],[3,22,5,22],[3,24,4,24],[3,42,5,45],[5,7,5,14],[5,24,5,25],[5,36,5,37],[9,18,12,19],[9,24,9,25],[9,36,9,37],[9,39,9,40],[9,42,9,43],[10,3,12,4],[10,24,10,25],[10,39,10,40],[11,21,12,22],[11,24,12,25],[11,36,12,37],[11,39,12,40],[11,42,12,43],[13,16,14,44],[15,3,15,5],[15,6,18,6],[15,18,16,19],[15,21,16,22],[15,24,16,25],[15,36,16,37],[15,39,16,40],[15,42,16,43],[16,1,17,5],[16,15,17,15],[17,16,18,16],[17,21,17,22],[18,1,18,5],[18,21,19,21],[18,24,18,25],[18,36,18,37],[19,1,22,2],[19,3,22,5],[19,24,19,25],[19,36,19,37],[20,7,23,14],[20,19,21,19],[20,21,20,22],[20,24,20,25],[21,24,22,25],[21,27,22,29],[21,32,22,34],[21,36,22,37],[21,45,23,45],[24,16,24,17],[24,31,24,32],[24,38,24,39],[25,6,26,15],[29,8,29,9],[29,10,29,11],[29,14,29,15],[29,16,29,17],[29,20,29,21],[29,22,29,23],[29,26,29,27],[29,28,29,29],[29,32,29,33],[29,34,29,35],[29,38,29,39],[30,8,30,9],[30,10,30,11],[30,14,30,15],[30,16,30,17],[30,20,30,21],[30,22,30,23],[30,26,30,27],[30,28,30,29],[30,32,30,33],[30,34,30,35]]}
[]
[{"$nulls":9},"KITCHEN 40'x25'",{"$nulls":6},"FIRE",null,30,31,32,33,"FIRE",35,36,37,{"$nulls":4},"FIRE",{"$nulls":5},48,49,"FIRE",null,52,null,"VIP LOUNGE 36'x14'"]
[]
[{"$nulls":16},140,null,139,240,null,"237 / 239"," 336 / 338 / 340",null," 337 & 339",440,{"$nulls":10},739,840,null,839,940,null,"40' x 30'"]
[{"$nulls":16},138,null,137,238,{"$nulls":5},438,{"$nulls":10},737,838,null,837,938]
[{"$nulls":7},"SalesCamp / Education Area",{"$nulls":8},136,{"$nulls":4},235,null,null," 335 / 436",{"$nulls":11}," 735 / 836",null,null,835,936]
[{"$nulls":16},134,null,133,234,{"$nulls":25},1033]
[{"$nulls":16},132,null,131,232,null,231,332,null,331,432,{"$nulls":10},731,832,null,831,932,null,931,1032,null,1031]
[{"$nulls":16},130,{"$nulls":4},229,330,null,329,430,{"$nulls":10},729,830,null,829,930,null,929,1030,null,1029]
[{"$nulls":16},128,null,"$9,995 Huber Engineered Wood 121",null,null,227,328,null," 327 / 428",{"$nulls":11}," 727 / 828",null,null,"827 / 928",null,null," 927 / 1028",null,null,1027]
[{"$nulls":3},"KITCHEN",{"$nulls":12},126,{"$nulls":28},1025]
[{"$nulls":16},124,{"$nulls":4},"$5,995 SavariaUSA   221",null,null,"$5,995 Bartley Corp 321",{"$nulls":11},"$5,995 Forbes 721",null,null,"$5,995 TW Perry 821",null,null,"$4,995 TOC 921",null,null,1023]
[{"$nulls":16},122,{"$nulls":28},1021]
[{"$nulls":16},"                  BOOTHS IN RED = RESERVED / YELLOW = OCCUPIED",{"$nulls":28},1019]
[{"$nulls":45},1017]
[null,"HGRV",null,"SHOW OFFICE",{"$nulls":12},116,null,"$5,995  Suburban Propane  115",null,null,"$5,995  Modern Foundations 215",null,null,"$5,995 GE           315",{"$nulls":3},"_ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ ",{"$nulls":7},"$5,995 Electrolux 715",null,null,"$5,995 BuilderUp       815",null,null,"$4,995 Adrian Steel   915",null,null,1015]
[null,"Exhibitor Lounge",{"$nulls":14},114,{"$nulls":11},"_ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ ",{"$nulls":16},1013]
[{"$nulls":16},"110 & 112",{"$nulls":11},"_ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ ",{"$nulls":16},1011]
[null,"Restrooms",{"$nulls":16},109,210,null,"207 / 209",310,null,"309 / 410",{"$nulls":3},"_ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ ",{"$nulls":7}," 709 / 810",null,null,809,910,null,909,1010,null,1009]
[null,"Women Restroom",null,"Men Restroom",{"$nulls":12},108,null,107,208,null,null,308,null,"307 / 408",{"$nulls":3},"_ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ ",{"$nulls":7},"707 / 808",null,null,807,908,null,907,1008,null,1007]
[{"$nulls":7},"REGISTRATION",{"$nulls":8},106,null,105,"204 / 206",{"$nulls":25},1005]
[{"$nulls":16},104,null,103,null,null,203,304,null,"$5,995 Shelter Systems 301",null,null,"MBIA / HBCF ? (TBD)",{"$nulls":4},"SalesCentral / Demo Stage? (TBD)",{"$nulls":3},"$4,995 701",null,null,803,904,null,903,1004,null," 1000 - 1003"]
[{"$nulls":16},102,null,101,202,null,201,302,{"$nulls":16},801,902,null,901,1002]
[{"$nulls":16},100,null," "]
[{"$nulls":18},1,2,3,4,"FIRE",6,7,8,12,13,14,15,"FIRE","17/18",null,19,20,21,22,23,"FIRE",null,26,27,28,29]
[{"$nulls":6},"MAIN ENTRANCE",{"$nulls":28},"*Booths in red have pole in front or back corner of booth."]
[{"$nulls":28}," RED / YELLOW = RESERVED",{"$nulls":6},"*Booths along the front and back walls are 8x10 booths."]
[]
[{"$nulls":7},"# available",null,"Price:",{"$nulls":3},"# available",null,"Price:",{"$nulls":3},"# available",null,"Price:",{"$nulls":3},"# available",null,"Price:",{"$nulls":3},"# available",null,"Price:",{"$nulls":3},"# available",null,"Price:",null,null,"# reserved"]
[{"$nulls":7},{"$f":"CountCellsByColor(Q2:AT25, G30)","v":13},{"v":995,"d":"$995.00"},{"$nulls":4},{"$f":"CountCellsByColor(Q2:AT25, M30)","v":47},{"v":1395,"d":"$1,395.00"},{"$nulls":4},{"$f":"CountCellsByColor(Q2:AT25, S30)","v":20},{"v":1195,"d":"$1,195.00"},{"$nulls":4},{"$f":"CountCellsByColor(Q2:AT25, Y30)","v":19},{"v":1545,"d":"$1,545.00"},{"$nulls":4},{"$f":"CountCellsByColor(Q2:AT25, AE30)/2","v":3},{"v":2695,"d":"$2,695.00"},{"$nulls":4},{"$f":"CountCellsByColor(Q2:AT25, AK30)/3","v":0},{"v":3995,"d":"$3,995.00"},{"$nulls":3},{"$f":"CountCellsByColor(Q2:AT25, AP30)","v":9}]
[{"$nulls":7},{"$f":"CountCellsByColor(Q2:AT25, G31)","v":4},{"v":2995,"d":"$2,995.00"},{"$nulls":4},{"$f":"CountCellsByColor(Q2:AT25, M31)/4","v":4},{"v":5995,"d":"$5,995.00"},{"$nulls":4},{"$f":"CountCellsByColor(Q2:AT25, S31)/4","v":0},{"v":7995,"d":"$7,995.00"},{"$nulls":4},{"$f":"CountCellsByColor(Q2:AT25, Y31)/8","v":0},{"v":9995,"d":"$9,995.00"},{"$nulls":4},{"$f":"CountCellsByColor(Q2:AT25, AE31)/4","v":3},{"v":4995,"d":"$4,995.00"},{"$nulls":9},{"$f":"CountCellsByColor(Q3:AT26, AP31)","v":83}]

{"sheet":"2019 Floorplan","index":2,"n_rows":28,"n_cols":36,"rows_kept":28,"merged":[[1,6,2,8],[1,10,1,11],[1,24,1,25],[1,32,1,33],[3,5,9,9],[3,15,4,15],[3,16,5,16],[3,18,4,18],[3,24,5,25],[5,18,5,19],[5,27,5,28],[7,3,12,4],[7,33,9,34],[8,25,9,25],[9,12,12,13],[9,18,9,19],[9,21,9,22],[9,30,9,31],[10,5,12,5],[10,18,10,19],[10,21,10,22],[10,24,10,25],[10,27,10,28],[10,33,10,34],[11,15,12,16],[11,18,12,19],[11,21,12,22],[11,24,12,25],[11,27,12,28],[11,30,12,31],[13,0,14,5],[13,10,14,34],[15,3,15,4],[15,5,18,5],[15,12,17,13],[15,15,16,16],[15,18,16,18],[15,19,16,19],[15,21,16,22],[15,24,16,25],[15,27,16,28],[15,31,19,32],[15,33,16,33],[16,1,17,4],[16,9,17,9],[17,10,18,10],[17,15,17,16],[17,21,17,22],[17,24,17,25],[17,27,17,28],[17,35,20,35],[18,1,18,4],[18,15,19,15],[18,22,19,22],[18,27,18,28],[19,1,22,4],[20,6,23,8],[20,13,21,13],[20,15,20,16],[20,18,20,19],[20,21,20,22],[21,15,22,16],[21,18,22,19],[21,30,23,30],[24,10,24,11],[24,22,24,23],[24,25,24,26],[24,32,24,33],[25,5,26,9],[28,16,28,19]]}
[]
[{"$nulls":6},"Kitchen",{"$nulls":3},"FIRE",{"$nulls":5},"FIRE",{"$nulls":7},"FIRE",{"$nulls":7},"FIRE"]
[]
[{"$nulls":10},140,null,139,240,null,"National Lumber 239","BGE 336 / 338 / 340",null,"Cummins 337 & 339",440,null,439,540,null,"Bartley Trailers 539"]
[{"$nulls":10},138,null,137,238,{"$nulls":5},438,null,437,538,{"$nulls":4},639,740]
[{"$nulls":10},136,{"$nulls":4},235,null,null,"MAPGA 335 / 436",null,null,435,536,{"$nulls":4},"L&L Co. 635/736"]
[{"$nulls":10},134,null,133,234]
[{"$nulls":3},"KITCHEN",{"$nulls":6},132,null,131,232,null,231,332,null,331,432,null,431,532,null,531,632,null,631,732,null,731,832,null,"Oyster Bar"]
[{"$nulls":10},130,{"$nulls":4},229,330,null,329,430,null,429,530,null,529,"Versatex 628 / 630",null,629,730,null,729,830]
[{"$nulls":10},128,null,"Huber Engineered Wood 121",null,null,227,328,null,"Atlantic Alum 327 / 428",null,null,"KBC 427 / 528",null,null,527,null,null,627,728,null,"BB&T 727 / 828"]
[{"$nulls":10},126]
[{"$nulls":10},124,{"$nulls":4},"SavariaUSA (Premier Lifts)  221",null,null,"Bartley Corp 321",null,null,"TOC Flooring 421",null,null," TW PERRY 521",null,null,"There Goes My Hero 621",null,null," Forbes 721",null,null,823,null,923]
[{"$nulls":10},122,{"$nulls":22},821,null,921]
["<--  EDUCATION HALL",{"$nulls":9},"EXHIBIT HALL",{"$nulls":24},919]
[{"$nulls":35},917]
[null,"HGRV",null,"OFFICE",{"$nulls":6},116,null," GE           115",null,null," Modern Foundations 215",null,null,"DECO 315","Cosentino 414",null,"Adrian Steel 415",null,null,"BuilderUp       515",null,null,"Electrolux   615",null,null,715,"SALES CENTRAL",null,"Wells Fargo 813",null,915]
[{"$nulls":9},"HBCF",114,{"$nulls":19},713]
[{"$nulls":10},"TrusJoist 110 & 112"]
[null,"Bathrooms",{"$nulls":13},"Res Title 207 / 209",310,null,309,410,null,409,"Comcast 510",null,509,610,null,"Pella 609 & 710",null,null,709]
[{"$nulls":10},108,null,107,208,null,null,308,null,307,408,null,407,null,null,507,608,null,607,708,null,707]
[{"$nulls":6},"REGISTRATION",{"$nulls":3},106,null,105,"SunTrust 204 / 206"]
[{"$nulls":10},104,null,103,null,null,"MBIA       201",null,null,"Shelter Systems 301",null,null,403,504,null,503,null,null,603,704,null,"Vintage Security 901"]
[{"$nulls":10},102,null,101,202,{"$nulls":7},401,502,null,501,null,null,601,702]
[{"$nulls":10},100,null," "]
[{"$nulls":12},1,2,3,4,"FIRE",6,7,8,12,null,"Mailbox Man 14 / 15",null,"FIRE",{"$nulls":7},"FIRE"]
[{"$nulls":5},"MAIN ENTRANCE",{"$nulls":11},"EARLY MOVE OUT DOORS",{"$nulls":7},"*Booths in green along back wall are 8x10 and $1095"]
[{"$nulls":25},"*Booths in red have pole in front or back corner of booth."]
[{"$nulls":13}," BLUE / YELLOW = RESERVED",{"$nulls":6}," WHITE = OPEN",{"$nulls":4},"*Booths along the front and back walls are 8x10 booths."]