{"text_format":"1","workbook":"xlsx","n_sheets":3,"sheets":["Survey","2020 Chain","Sheet1"],"not_rendered":{"charts":0,"images":11,"macros":1,"external_links":0,"defined_names":0,"comments":0,"pivot_tables":0},"unopened":[],"bounds":{"document_bytes":16777216,"sheet_cells":100000,"rows_first":2000,"rows_last":500,"rows_between":2000,"halvings":0,"cell_chars":16384,"cell_head_chars":4096},"cells_cut":0,"cells_raw":0,"read":"whole","date_system":"1900"}

{"sheet":"Survey","index":0,"n_rows":340,"n_cols":83,"rows_kept":340,"cut":false,"hidden":false,"merged":[[94,30,94,32],[94,33,94,35],[94,36,94,38],[94,39,94,41],[94,42,94,44],[94,45,94,47],[94,48,94,50],[94,3,94,14],[94,15,94,17],[94,18,94,20],[94,21,94,23],[94,24,94,26],[94,27,94,29],[95,1,95,66],[96,48,96,50],[96,51,96,53],[96,27,96,29],[96,30,96,32],[96,33,96,35],[96,36,96,38],[96,39,96,41],[96,42,96,44],[96,45,96,47],[96,54,96,56],[96,57,96,59],[90,1,90,2],[92,1,92,2],[92,3,92,14],[92,15,92,17],[92,18,92,20],[92,21,92,23],[92,24,92,26],[94,1,94,2],[96,1,96,2],[96,3,96,14],[96,15,96,17],[96,18,96,20],[96,21,96,23],[96,24,96,26],[98,51,98,53],[98,54,98,56],[98,30,98,32],[98,33,98,35],[98,36,98,38],[98,39,98,41],[98,42,98,44],[98,45,98,47],[98,48,98,50],[93,1,93,66],[96,60,96,62],[96,63,96,65],[97,1,97,66],[94,51,94,53],[94,54,94,56],[94,57,94,59],[94,60,94,62],[94,63,94,65],[98,57,98,59],[98,60,98,62],[98,63,98,65],[98,1,98,2],[98,3,98,14],[98,15,98,17],[98,18,98,20],[98,21,98,23],[98,24,98,26],[98,27,98,29],[90,57,90,59],[90,60,90,62],[89,1,89,66],[90,3,90,14],[90,15,90,17],[90,18,90,20],[90,21,90,23],[90,24,90,26],[90,63,90,65],[92,48,92,50],[92,51,92,53],[92,54,92,56],[92,57,92,59],[92,60,92,62],[92,63,92,65],[92,27,92,29],[92,30,92,32],[92,33,92,35],[92,36,92,38],[92,39,92,41],[92,42,92,44],[92,45,92,47],[99,1,99,66],[100,1,100,66],[101,1,101,66],[102,1,102,66],[103,1,103,66],[104,1,104,66],[105,1,105,66],[110,51,110,53],[110,54,110,56],[110,30,110,32],[110,33,110,35],[110,36,110,38],[110,39,110,41],[110,42,110,44],[110,45,110,47],[110,48,110,50],[112,57,112,59],[112,60,112,62],[108,42,108,44],[108,45,108,47],[109,1,109,66],[108,48,108,50],[108,51,108,53],[108,54,108,56],[108,57,108,59],[108,60,108,62],[108,63,108,65],[112,63,112,65],[112,39,112,41],[112,42,112,44],[112,45,112,47],[106,1,106,2],[117,1,117,66],[106,51,106,53],[106,54,106,56],[106,57,106,59],[106,60,106,62],[106,63,106,65],[106,30,106,32],[106,33,106,35],[106,36,106,38],[106,39,106,41],[106,42,106,44],[106,45,106,47],[106,48,106,50],[106,3,106,14],[106,15,106,17],[106,18,106,20],[106,21,106,23],[106,24,106,26],[106,27,106,29],[107,1,107,66],[108,27,108,29],[108,30,108,32],[108,33,108,35],[108,36,108,38],[108,39,108,41],[118,1,118,2],[118,3,118,14],[118,15,118,17],[118,18,118,20],[118,21,118,23],[118,24,118,26],[118,60,118,62],[118,63,118,65],[112,54,112,56],[116,54,116,56],[116,57,116,59],[116,60,116,62],[116,63,116,65],[118,54,118,56],[118,57,118,59],[110,57,110,59],[110,60,110,62],[110,63,110,65],[110,3,110,14],[110,15,110,17],[110,18,110,20],[110,21,110,23],[110,24,110,26],[110,27,110,29],[111,1,111,66],[112,48,112,50],[112,51,112,53],[112,27,112,29],[112,30,112,32],[112,33,112,35],[112,36,112,38],[113,1,113,66],[108,1,108,2],[108,3,108,14],[108,15,108,17],[108,18,108,20],[108,21,108,23],[108,24,108,26],[110,1,110,2],[112,1,112,2],[112,3,112,14],[112,15,112,17],[112,18,112,20],[112,21,112,23],[112,24,112,26],[114,51,114,53],[114,54,114,56],[114,30,114,32],[114,33,114,35],[114,36,114,38],[114,39,114,41],[114,42,114,44],[114,45,114,47],[114,48,114,50],[114,1,114,2],[114,57,114,59],[114,60,114,62],[114,63,114,65],[114,3,114,14],[114,15,114,17],[114,18,114,20],[114,21,114,23],[114,24,114,26],[114,27,114,29],[115,1,115,66],[116,48,116,50],[116,51,116,53],[116,27,116,29],[116,30,116,32],[116,33,116,35],[116,36,116,38],[116,39,116,41],[116,42,116,44],[116,45,116,47],[116,1,116,2],[116,3,116,14],[116,15,116,17],[116,18,116,20],[116,21,116,23],[116,24,116,26],[118,48,118,50],[118,51,118,53],[118,27,118,29],[118,30,118,32],[118,33,118,35],[118,36,118,38],[118,39,118,41],[118,42,118,44],[118,45,118,47],[124,15,124,17],[124,18,124,20],[124,21,124,23],[124,24,124,26],[124,27,124,29],[124,30,124,32],[124,33,124,35],[124,36,124,38],[124,39,124,41],[124,42,124,44],[133,1,133,66],[134,1,134,66],[135,1,135,66],[136,1,136,66],[137,1,137,66],[138,1,138,66],[139,1,139,32],[139,34,139,36],[140,1,140,39],[140,41,140,43],[141,1,141,38],[141,40,141,42],[119,1,119,66],[120,1,120,66],[121,1,121,66],[122,1,122,66],[123,1,123,66],[124,1,124,2],[124,63,124,65],[126,48,126,50],[126,51,126,53],[126,54,126,56],[126,57,126,59],[130,57,130,59],[130,60,130,62],[130,63,130,65],[126,60,126,62],[126,63,126,65],[128,48,128,50],[128,51,128,53],[150,1,150,66],[151,1,151,66],[152,1,152,66],[153,1,153,66],[154,1,154,66],[155,1,155,66],[162,32,162,45],[162,46,162,66],[128,54,128,56],[128,57,128,59],[128,60,128,62],[128,63,128,65],[128,27,128,29],[128,30,128,32],[128,33,128,35],[128,36,128,38],[128,39,128,41],[128,42,128,44],[128,45,128,47],[129,1,129,66],[146,1,146,23],[146,25,146,27],[146,28,146,30],[146,32,146,34],[146,36,146,38],[128,24,128,26],[130,51,130,53],[130,54,130,56],[130,30,130,32],[130,33,130,35],[130,36,130,38],[130,39,130,41],[162,70,163,73],[162,74,163,80],[163,46,163,50],[163,51,163,56],[163,57,163,61],[163,62,163,66],[156,1,156,66],[157,1,157,66],[159,2,159,66],[161,3,161,29],[161,32,161,66],[162,3,162,9],[162,10,162,29],[163,10,163,14],[164,10,164,14],[165,3,165,9],[165,10,165,14],[163,41,164,45],[164,46,164,50],[164,51,164,56],[164,57,164,61],[164,62,164,66],[164,70,164,73],[164,74,164,80],[165,41,165,45],[165,46,165,50],[165,51,165,56],[165,57,165,61],[165,62,165,66],[165,70,165,73],[165,74,165,80],[163,3,164,9],[169,41,169,45],[169,46,169,50],[169,51,169,56],[169,57,169,61],[169,62,169,66],[169,70,169,73],[169,74,169,80],[169,3,169,9],[169,10,169,14],[169,15,169,19],[169,20,169,24],[169,25,169,29],[169,32,169,35],[169,36,169,40],[170,41,170,45],[170,46,170,50],[170,51,170,56],[170,57,170,61],[170,62,170,66],[170,70,170,73],[170,74,170,80],[170,3,170,9],[170,10,170,14],[170,15,170,19],[170,20,170,24],[170,25,170,29],[170,32,170,35],[170,36,170,40],[171,41,171,45],[171,46,171,50],[171,51,171,56],[171,57,171,61],[171,62,171,66],[171,70,171,73],[171,74,171,80],[171,3,171,9],[171,10,171,14],[171,15,171,19],[171,20,171,24],[171,25,171,29],[171,32,171,35],[171,36,171,40],[172,3,172,9],[172,10,172,14],[172,15,172,19],[172,20,172,24],[172,25,172,29],[172,32,172,35],[172,36,172,40],[172,41,172,45],[172,46,172,50],[172,51,172,56],[172,57,172,61],[172,62,172,66],[172,70,172,73],[172,74,172,80],[163,15,163,19],[163,20,163,24],[163,25,163,29],[163,32,164,35],[163,36,164,40],[164,25,164,29],[164,15,164,19],[164,20,164,24],[165,15,165,19],[165,20,165,24],[165,25,165,29],[165,32,165,35],[165,36,165,40],[166,41,166,45],[166,46,166,50],[166,51,166,56],[166,57,166,61],[166,62,166,66],[166,70,166,73],[166,74,166,80],[166,3,166,9],[166,10,166,14],[166,15,166,19],[166,20,166,24],[166,25,166,29],[166,32,166,35],[166,36,166,40],[167,41,167,45],[167,46,167,50],[167,51,167,56],[167,57,167,61],[167,62,167,66],[167,70,167,73],[167,74,167,80],[167,3,167,9],[167,10,167,14],[167,15,167,19],[167,20,167,24],[167,25,167,29],[167,32,167,35],[167,36,167,40],[173,70,173,73],[173,74,173,80],[174,70,174,80],[176,2,197,80],[199,1,199,7],[199,8,199,24],[199,25,199,32],[199,60,199,65],[243,1,245,32],[243,34,245,65],[247,1,247,6],[247,25,247,32],[247,34,247,41],[247,42,247,59],[247,60,247,65],[247,7,247,24],[249,1,265,32],[249,34,265,65],[223,2,223,8],[223,9,223,24],[223,25,223,32],[223,34,223,41],[223,42,223,57],[223,59,223,64],[225,1,241,32],[225,34,241,65],[199,34,199,41],[199,42,199,59],[201,1,217,32],[201,34,217,65],[219,1,221,32],[219,34,221,65],[267,1,269,32],[267,34,269,65],[271,2,271,7],[271,8,271,24],[273,1,289,32],[273,34,289,65],[291,1,293,32],[291,34,293,65],[295,1,295,6],[295,7,295,24],[295,25,295,32],[295,60,295,65],[319,8,319,24],[319,25,319,32],[321,1,337,32],[339,1,341,32],[319,34,319,41],[319,42,319,58],[321,34,337,65],[339,34,341,65],[295,34,295,41],[295,42,295,58],[297,1,313,32],[297,34,313,65],[315,1,317,32],[315,34,317,65],[319,2,319,7],[319,59,319,64],[223,0,245,0],[271,25,271,32],[271,34,271,41],[271,42,271,58],[271,59,271,64],[124,45,124,47],[124,48,124,50],[124,51,124,53],[124,54,124,56],[124,57,124,59],[124,60,124,62],[126,24,126,26],[126,27,126,29],[126,30,126,32],[126,33,126,35],[126,36,126,38],[126,39,126,41],[126,42,126,44],[126,45,126,47],[124,3,124,14],[125,1,125,66],[126,3,126,14],[126,15,126,17],[126,18,126,20],[126,21,126,23],[127,1,127,66],[126,1,126,2],[128,1,128,2],[128,3,128,14],[128,15,128,17],[128,18,128,20],[128,21,128,23],[130,27,130,29],[131,1,131,66],[130,1,130,2],[132,1,132,2],[132,3,132,14],[132,15,132,17],[132,18,132,20],[132,21,132,23],[132,24,132,26],[132,54,132,56],[132,57,132,59],[132,60,132,62],[132,63,132,65],[132,33,132,35],[132,36,132,38],[132,39,132,41],[132,42,132,44],[132,45,132,47],[132,48,132,50],[132,51,132,53],[130,42,130,44],[130,45,130,47],[130,48,130,50],[130,3,130,14],[130,15,130,17],[130,18,130,20],[130,21,130,23],[130,24,130,26],[132,27,132,29],[132,30,132,32],[145,32,145,36],[145,37,145,47],[145,56,145,65],[142,1,142,42],[142,44,142,46],[143,1,143,37],[143,39,143,41],[144,1,144,55],[144,56,144,60],[145,1,145,31],[147,61,147,63],[147,64,147,66],[147,40,147,42],[147,43,147,45],[147,46,147,48],[147,49,147,51],[147,52,147,54],[147,55,147,57],[147,58,147,60],[147,1,149,36],[147,37,147,39],[148,37,148,39],[148,40,148,42],[148,43,148,45],[148,46,148,48],[148,49,148,51],[148,52,148,54],[148,55,148,66],[149,37,149,66],[168,41,168,45],[168,46,168,50],[168,51,168,56],[168,57,168,61],[168,62,168,66],[168,70,168,73],[168,74,168,80],[168,3,168,9],[168,10,168,14],[168,15,168,19],[168,20,168,24],[168,25,168,29],[168,32,168,35],[168,36,168,40],[5,55,5,61],[5,62,5,73],[5,74,5,80],[5,1,5,9],[5,10,5,20],[5,21,5,29],[5,30,5,39],[5,40,5,44],[5,45,5,50],[5,51,5,54],[6,44,6,50],[6,51,6,54],[6,55,6,58],[6,59,6,63],[6,64,6,69],[6,70,6,73],[6,74,6,80],[8,41,8,43],[6,82,6,91],[6,1,6,3],[6,4,6,11],[6,12,6,22],[6,23,6,25],[6,26,6,30],[6,31,6,33],[6,34,6,43],[7,41,7,43],[7,44,7,50],[7,51,7,54],[7,55,7,58],[7,59,7,63],[7,64,7,69],[7,70,7,73],[7,74,7,80],[7,1,7,3],[7,4,7,11],[7,12,7,22],[7,23,7,25],[7,26,7,30],[7,31,7,33],[7,34,7,40],[8,44,8,50],[8,51,8,54],[8,55,8,58],[8,59,8,63],[8,64,8,69],[8,70,8,73],[8,74,8,80],[8,1,8,3],[8,4,8,11],[8,12,8,22],[8,23,8,25],[8,26,8,30],[8,31,8,33],[8,34,8,40],[9,41,9,43],[9,44,9,50],[9,51,9,54],[9,55,9,58],[9,59,9,63],[9,64,9,69],[9,70,9,73],[9,74,9,80],[9,1,9,3],[9,4,9,11],[9,12,9,22],[9,23,9,25],[9,26,9,30],[9,31,9,33],[9,34,9,40],[10,41,10,43],[10,44,10,50],[10,51,10,54],[10,55,10,58],[10,59,10,63],[10,64,10,69],[10,70,10,73],[10,74,10,80],[10,1,10,3],[10,4,10,11],[10,12,10,22],[10,23,10,25],[10,26,10,30],[10,31,10,33],[10,34,10,40],[11,41,11,43],[11,44,11,50],[11,51,11,54],[11,55,11,58],[11,59,11,63],[11,64,11,69],[11,70,11,73],[11,74,11,80],[11,1,11,3],[11,4,11,11],[11,12,11,22],[11,23,11,25],[11,26,11,30],[11,31,11,33],[11,34,11,40],[12,41,12,43],[12,44,12,50],[12,51,12,54],[12,55,12,58],[12,59,12,63],[12,64,12,69],[12,70,12,73],[12,74,12,80],[12,1,12,3],[12,4,12,11],[12,12,12,22],[12,23,12,25],[12,26,12,30],[12,31,12,33],[12,34,12,40],[13,41,13,43],[13,44,13,50],[13,51,13,54],[13,55,13,58],[13,59,13,63],[13,64,13,69],[13,70,13,73],[13,74,13,80],[13,1,13,3],[13,4,13,11],[13,12,13,22],[13,23,13,25],[13,26,13,30],[13,31,13,33],[13,34,13,40],[14,41,14,43],[14,44,14,50],[14,51,14,54],[14,55,14,58],[14,59,14,63],[14,64,14,69],[14,70,14,73],[14,74,14,80],[14,1,14,3],[14,4,14,11],[14,12,14,22],[14,23,14,25],[14,26,14,30],[14,31,14,33],[14,34,14,40],[0,1,0,80],[1,9,1,17],[1,18,1,21],[1,22,1,35],[1,36,1,55],[1,56,1,71],[1,72,1,80],[2,56,2,64],[2,65,2,80],[1,1,1,8],[2,1,2,4],[2,5,2,18],[2,19,2,31],[2,32,2,42],[2,43,2,44],[2,45,2,55],[3,5,3,18],[3,19,3,31],[3,32,3,42],[3,43,3,44],[3,45,3,55],[3,56,3,64],[3,65,3,80],[4,51,4,54],[4,55,4,61],[4,62,4,73],[4,74,4,80],[3,1,3,4],[4,1,4,9],[4,10,4,20],[4,21,4,29],[4,30,4,39],[4,40,4,44],[4,45,4,50],[19,45,19,47],[19,48,19,50],[19,51,19,53],[19,54,19,56],[19,57,19,59],[19,60,19,62],[21,27,21,29],[21,30,21,32],[25,30,25,32],[25,33,25,35],[25,36,25,38],[25,39,25,41],[25,42,25,44],[25,45,25,47],[25,48,25,50],[25,51,25,53],[25,54,25,56],[25,57,25,59],[25,60,25,62],[25,63,25,65],[23,27,23,29],[23,30,23,32],[24,1,24,66],[25,3,25,14],[25,15,25,17],[25,18,25,20],[25,21,25,23],[27,30,27,32],[27,33,27,35],[25,24,25,26],[25,27,25,29],[26,1,26,66],[27,3,27,14],[27,15,27,17],[27,18,27,20],[27,21,27,23],[23,33,23,35],[23,36,23,38],[23,39,23,41],[23,42,23,44],[23,45,23,47],[23,48,23,50],[23,51,23,53],[23,54,23,56],[23,57,23,59],[23,60,23,62],[21,3,21,14],[22,1,22,66],[23,3,23,14],[23,15,23,17],[23,18,23,20],[23,21,23,23],[23,24,23,26],[23,63,23,65],[15,1,15,44],[16,1,16,57],[17,1,17,64],[18,1,18,66],[19,15,19,17],[19,18,19,20],[19,63,19,65],[21,33,21,35],[21,36,21,38],[21,39,21,41],[21,42,21,44],[21,45,21,47],[21,48,21,50],[21,51,21,53],[21,54,21,56],[21,57,21,59],[21,60,21,62],[19,3,19,14],[20,1,20,66],[21,15,21,17],[21,18,21,20],[21,21,21,23],[21,24,21,26],[21,63,21,65],[19,21,19,23],[19,24,19,26],[19,27,19,29],[19,30,19,32],[19,33,19,35],[19,36,19,38],[19,39,19,41],[19,42,19,44],[27,51,27,53],[27,54,27,56],[27,57,27,59],[27,60,27,62],[27,63,27,65],[27,24,27,26],[27,27,27,29],[27,36,27,38],[27,39,27,41],[27,42,27,44],[27,45,27,47],[27,48,27,50],[29,36,29,38],[29,39,29,41],[29,42,29,44],[29,45,29,47],[29,48,29,50],[29,51,29,53],[29,54,29,56],[29,57,29,59],[29,60,29,62],[29,63,29,65],[28,1,28,66],[29,3,29,14],[29,15,29,17],[31,24,31,26],[31,27,31,29],[32,1,32,66],[33,3,33,14],[33,15,33,17],[33,18,33,20],[33,21,33,23],[29,18,29,20],[29,21,29,23],[29,24,29,26],[29,27,29,29],[31,30,31,32],[31,33,31,35],[31,36,31,38],[31,39,31,41],[31,42,31,44],[31,45,31,47],[31,48,31,50],[31,51,31,53],[31,54,31,56],[31,57,31,59],[31,60,31,62],[31,63,31,65],[29,30,29,32],[29,33,29,35],[30,1,30,66],[31,3,31,14],[31,15,31,17],[31,18,31,20],[31,21,31,23],[33,24,33,26],[33,27,33,29],[34,1,34,66],[35,3,35,14],[35,15,35,17],[35,18,35,20],[35,21,35,23],[33,30,33,32],[33,33,33,35],[33,36,33,38],[33,39,33,41],[33,42,33,44],[33,45,33,47],[33,48,33,50],[33,51,33,53],[33,54,33,56],[33,57,33,59],[33,60,33,62],[33,63,33,65],[35,24,35,26],[35,27,35,29],[36,1,36,66],[37,3,37,14],[37,15,37,17],[37,18,37,20],[37,21,37,23],[35,30,35,32],[35,33,35,35],[35,36,35,38],[35,39,35,41],[35,42,35,44],[35,45,35,47],[35,48,35,50],[35,51,35,53],[35,54,35,56],[35,57,35,59],[35,60,35,62],[35,63,35,65],[37,24,37,26],[37,27,37,29],[48,15,48,17],[48,18,48,20],[48,21,48,23],[48,24,48,26],[48,27,48,29],[48,30,48,32],[47,1,47,66],[37,30,37,32],[37,33,37,35],[37,36,37,38],[37,39,37,41],[37,42,37,44],[37,45,37,47],[37,48,37,50],[37,51,37,53],[37,54,37,56],[37,57,37,59],[37,60,37,62],[37,63,37,65],[38,1,38,66],[39,1,39,66],[40,1,40,66],[41,1,41,66],[42,1,42,66],[48,42,48,44],[48,45,48,47],[48,48,48,50],[48,51,48,53],[44,30,44,32],[44,33,44,35],[44,36,44,38],[44,39,44,41],[44,42,44,44],[44,45,44,47],[44,48,44,50],[44,51,44,53],[44,54,44,56],[44,57,44,59],[44,60,44,62]],"merged_total":1333,"flags":["merged_cut"]}
[null,"NOTE:  WHILE LENNOX UNITS CAN BE ORDERED, UNITS CANNOT BE DELIVERED UNTIL 1ST QUARTER OF 2023"]
[null,"TAB Partner -",null,null,null,null,null,null,null,{"$f":"'2020 Chain'!H20","v":"National TAB"},null,null,null,null,null,null,null,null,"Tech-",null,null,null,"Ian Fuller",null,null,null,null,null,null,null,null,null,null,null,null,null,"CONDITION SURVEY",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Survey Due Date -",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"'2020 Chain'!B20","v":"2022-09-22"}]
[null,"UNIT #",null,null,null,"UNIT NAME",null,null,null,null,null,null,null,null,null,null,null,null,null,"STREET ADDRESS",null,null,null,null,null,null,null,null,null,null,null,null,"CITY",null,null,null,null,null,null,null,null,null,null,"ST",null,"OPERATOR",null,null,null,null,null,null,null,null,null,null,"PHONE #",null,null,null,null,null,null,null,null,"EMAIL"]
[null,{"$f":"'2020 Chain'!A20","v":1703},null,null,null,{"$f":"'2020 Chain'!C20","v":"Boynton Beach Blvd FSU"},null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"'2020 Chain'!I20","v":"1560 W Boynton Beach Blvd"},null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"'2020 Chain'!J20","v":"Boynton Beach"},null,null,null,null,null,null,null,null,null,null,{"$f":"'2020 Chain'!K20","v":"FL"},null,{"$f":"'2020 Chain'!L20","v":"Justin Mize"},null,null,null,null,null,null,null,null,null,null,{"$f":"'2020 Chain'!T20","v":"(561) 752-0790"},null,null,null,null,null,null,null,null,{"$f":"'2020 Chain'!U20","v":"01703@chick-fil-a.com"}]
[null,"CONSTRUCTION MGR (CM)",null,null,null,null,null,null,null,null,"SR PROGRAM MGR (SRP)",null,null,null,null,null,null,null,null,null,null,"SR PROGRAM LEAD (SRPL)",null,null,null,null,null,null,null,null,"FEQ FIELD CONSULTANT",null,null,null,null,null,null,null,null,null,"PROTO-TYPE",null,null,null,null,"OPEN DATE",null,null,null,null,null,"UNIT AGE",null,null,null,"CONSTR START",null,null,null,null,null,null,"SCOPE OF WORK",null,null,null,null,null,null,null,null,null,null,null,"ARCHITECT"]
[null,{"$f":"'2020 Chain'!O20","v":"Mark Farol"},null,null,null,null,null,null,null,null,{"$f":"'2020 Chain'!P20","v":"Allison Doherty"},null,null,null,null,null,null,null,null,null,null,{"$f":"'2020 Chain'!M20","v":"Jacob Smith"},null,null,null,null,null,null,null,null,{"$f":"'2020 Chain'!Q20","v":"Pierre DuVentre"},null,null,null,null,null,null,null,null,null,{"$f":"'2020 Chain'!F20","v":"S04-100R"},null,null,null,null,{"$f":"'2020 Chain'!S20","v":"09/01/2005"},null,null,null,null,null,{"$f":"(TODAY()-AT6)/365","v":17.052054794520547},null,null,null,{"$f":"'2020 Chain'!E20","v":"2023-05-20"},null,null,null,null,null,null,{"$f":"'2020 Chain'!D20","v":"MLv2/BI"},null,null,null,null,null,null,null,null,null,null,null,{"$f":"'2020 Chain'!R20","v":"Interplan"}]
[null,"AC#",null,null,"SERIAL #",null,null,null,null,null,null,null,"MODEL #",null,null,null,null,null,null,null,null,null,null,"TON",null,null,"MFG.",null,null,null,null,"AGE",null,null,"HVAC UNIT TYPE/HUMIDITROL",null,null,null,null,null,null,null,null,null,"AREA SERVED",null,null,null,null,null,null,"HEAT EXCH.",null,null,null,"COND.DAM.",null,null,null,"HAIL GARD",null,null,null,null,"EVAP COIL",null,null,null,null,null,"POW EXH",null,null,null,"TOTAL",null,null,null,null,null,null,null,{"$f":"'2020 Chain'!M20","v":"Jacob Smith"}]
[null,"AC1",null,null,{"$f":"'2020 Chain'!V20","v":"5619J01023"},null,null,null,null,null,null,null,{"$f":"'2020 Chain'!X20","v":"LGH150H4BH1Y"},null,null,null,null,null,null,null,null,null,null,{"$f":"IF(MID(M8,7,2)=\"05\",\"4\",IF(MID(M8,7,2)=\"06\",\"5\",IF(MID(M8,7,2)=\"07\",\"6\",IF(MID(M8,7,2)=\"08\",\"7.5\",IF(MID(M8,7,2)=\"09\",\"8.5\",IF(MID(M8,7,2)=\"12\",\"10\",IF(MID(M8,7,2)=\"14\",\"12.5\",IF(MID(M8,7,2)=\"16\",\"15\",IF(MID(M8,4,3)=\"300\",\"25\",IF(MID(M8,4,3)=\"210\",\"17.5\",IF(MID(M8,4,3)=\"180\",\"15\",IF(MID(M8,4,3)=\"150\",\"12.5\",IF(MID(M8,4,3)=\"120\",\"10\",IF(MID(M8,4,3)=\"102\",\"8.5\",IF(MID(M8,4,3)=\"090\",\"7.5\",IF(MID(M8,4,3)=\"092\",\"7.5\",IF(MID(M8,4,3)=\"072\",\"6\",IF(MID(M8,4,3)=\"060\",\"5\",IF(MID(M8,4,3)=\"036\",\"3\",IF(MID(M8,4,3)=\"048\",\"4\",IF(MID(M8,4,3)=\"015\",\"15\",\"\")))))))))))))))))))))","v":"12.5"},null,null,{"$f":"IF(ISBLANK(M8),\"\",IF(MID(M8,1,2)=\"RN\",\"AAON\",IF(MID(M8,1,3)=\"LHC\",\"Lennox\",IF(MID(M8,1,3)=\"LHA\",\"Lennox\",IF(MID(M8,1,3)=\"KHA\",\"Lennox\",IF(MID(M8,1,3)=\"LCH\",\"Lennox\",IF(MID(M8,1,3)=\"LCA\",\"Lennox\",IF(MID(M8,1,3)=\"LGA\",\"Lennox\",IF(MID(M8,1,3)=\"LGC\",\"Lennox\",IF(MID(M8,1,3)=\"LGH\",\"Lennox\",\"Carrier\"))))))))))","v":"Lennox"},null,null,null,null,{"$f":"'2020 Chain'!Z20","v":3.043835616438356},null,null,{"$f":"IF(ISBLANK(E8),\"\",IF(MID(M8,1,2)=\"RN\",\"RN SERIES/\",IF(MID(M8,1,3)=\"YSC\",\"TRANE\",IF(MID(M8,1,3)=\"50K\",\"WEAMaker SE\",IF(MID(M8,1,4)=\"48ES\",\"Comfort\",IF(MID(M8,1,3)=\"48H\",\"WEAMaster HE\",IF(MID(M8,1,3)=\"48T\",\"WEAMaker SE\",IF(MID(M8,3,2)=\"HP\",\"HEAT PUMP\",IF(MID(M8,3,2)=\"KC\",\"WEAMaker SE\",IF(MID(M8,3,2)=\"FC\",\"WEAMaker EcoBlue\",IF(COUNT(FIND({5610,5611,5612,5613,5614,5615,5616,5617,5618,5619,5620,5621},E8))>0,\"ENERGENCE/\",\"L SERIES/\")))))))))))","v":"ENERGENCE/"},null,null,null,null,null,null,{"$f":"'2020 Chain'!W20","v":"HUM"},null,null,{"$f":"IF(MID(AO6,1,7)=\"S97-100\",\"RR/DIN A/ENTA\",IF(MID(AO6,1,7)=\"S97-110\",\"RR/DIN A/ENT A\",IF(MID(AO6,1,7)=\"S97-120\",\"RR/DIN A\",IF(MID(AO6,1,7)=\"S97-136\",\"RR/DIN A\",IF(MID(AO6,1,7)=\"S97-138\",\"RR/DIN A\",IF(MID(AO6,1,4)=\"S03C\",\"KITCHEN\",IF(MID(AO6,1,4)=\"S03E\",\"KITCHEN\",IF(MID(AO6,1,7)=\"S03-128\",\"KITHEN\",IF(MID(AO6,1,7)=\"S03-146\",\"KITCHEN\",IF(MID(AO6,1,9)=\"S03-150SW\",\"KITCHEN\",IF(MID(AO6,1,7)=\"S04-110\",\"KITCHEN\",IF(MID(AO6,1,3)=\"S04\",\"Kitchen\",IF(MID(AO6,1,4)=\"S06A\",\"KITCHEN\",IF(MID(AO6,1,4)=\"S06B\",\"KITCHEN\",IF(MID(AO6,1,4)=\"S06C\",\"KITCHEN\",IF(MID(AO6,1,4)=\"S06E\",\"KITCHEN\",IF(MID(AO6,1,4)=\"S08A\",\"KITCHEN\",IF(MID(AO6,1,4)=\"S08C\",\"KITCHEN/ELEC\",IF(MID(AO6,1,4)=\"S08E\",\"KITCHEN\",IF(MID(AO6,1,6)=\"S08N-T\",\"KITCHEN\",IF(MID(AO6,1,7)=\"S08N-LG\",\"KITCHEN\",IF(MID(AO6,9,2)=\"AZ\",\"KITCHEN\",IF(MID(AO6,1,2)=\"KK\",\"MECH/MP/KITCHEN\",\"\")))))))))))))))))))))))","v":"Kitchen"},null,null,null,null,null,null,{"$f":"VALUE(IF(V20=15,\"2518\",IF(V20=12.5,\"2518\",IF(V20=10,\"2352\",IF(V20=8.5,\"2352\",IF(V20=7.5,\"1911\",IF(V20=6,\"1911\",IF(V20=5,\"1828\",IF(V20=4,\"1828\",\"0\")))))))))","v":0},null,null,null,{"$f":"VALUE(IF(V22=15,\"9662\",IF(V22=12.5,\"9662\",IF(V22=10,\"6452\",IF(V22=8.5,\"6452\",IF(V22=7.5,\"5397\",IF(V22=6,\"5397\",IF(V22=5,\"4161\",IF(V22=4,\"4161\",\"0\")))))))))","v":0},null,null,null,{"$f":"VALUE(IF(V$24=15,\"475\",IF(V$24=12.5,\"475\",IF(V$24=10,\"475\",IF(V$24=8.5,\"475\",IF(V$24=7.5,\"475\",IF(V$24=6,\"475\",IF(V$24=5,\"475\",IF(V$24=4,\"475\",\"0\")))))))))","v":0},null,null,null,null,{"$f":"VALUE(IF(V$26=15,\"9662\",IF(V$26=12.5,\"9662\",IF(V$26=10,\"6452\",IF(V$26=8.5,\"6452\",IF(V$26=7.5,\"5397\",IF(V$26=6,\"5397\",IF(V$26=5,\"4161\",IF(V$26=4,\"4161\",\"0\")))))))))","v":0},null,null,null,null,null,{"$f":"VALUE(IF(V$28=15,\"537\",IF(V$28=12.5,\"537\",IF(V$28=10,\"537\",IF(V$28=8.5,\"537\",IF(V$28=7.5,\"437\",IF(V$28=6,\"537\",IF(V$28=5,\"537\",IF(V$28=4,\"537\",\"0\")))))))))","v":0},null,null,null,{"$f":"SUM(AZ8:BS8)","v":0}]
[null,"AC2",null,null,{"$f":"'2020 Chain'!AB20","v":"5617L01628"},null,null,null,null,null,null,null,{"$f":"'2020 Chain'!AD20","v":"LGH102H4BH3Y"},null,null,null,null,null,null,null,null,null,null,{"$f":"IF(MID(M9,7,2)=\"05\",\"4\",IF(MID(M9,7,2)=\"06\",\"5\",IF(MID(M9,7,2)=\"07\",\"6\",IF(MID(M9,7,2)=\"08\",\"7.5\",IF(MID(M9,7,2)=\"09\",\"8.5\",IF(MID(M9,7,2)=\"12\",\"10\",IF(MID(M9,7,2)=\"14\",\"12.5\",IF(MID(M9,7,2)=\"16\",\"15\",IF(MID(M9,4,3)=\"300\",\"25\",IF(MID(M9,4,3)=\"210\",\"17.5\",IF(MID(M9,4,3)=\"180\",\"15\",IF(MID(M9,4,3)=\"150\",\"12.5\",IF(MID(M9,4,3)=\"120\",\"10\",IF(MID(M9,4,3)=\"102\",\"8.5\",IF(MID(M9,4,3)=\"090\",\"7.5\",IF(MID(M9,4,3)=\"092\",\"7.5\",IF(MID(M9,4,3)=\"072\",\"6\",IF(MID(M9,4,3)=\"060\",\"5\",IF(MID(M9,4,3)=\"036\",\"3\",IF(MID(M9,4,3)=\"048\",\"4\",\"\"))))))))))))))))))))","v":"8.5"},null,null,{"$f":"IF(ISBLANK(M9),\"\",IF(MID(M9,1,2)=\"RN\",\"AAON\",IF(MID(M9,1,3)=\"LHC\",\"Lennox\",IF(MID(M9,1,3)=\"LHA\",\"Lennox\",IF(MID(M9,1,3)=\"KHA\",\"Lennox\",IF(MID(M9,1,3)=\"LCH\",\"Lennox\",IF(MID(M9,1,3)=\"LCA\",\"Lennox\",IF(MID(M9,1,3)=\"LGA\",\"Lennox\",IF(MID(M9,1,3)=\"LGH\",\"Lennox\",\"Carrier\")))))))))","v":"Lennox"},null,null,null,null,{"$f":"'2020 Chain'!AF20","v":4.8767123287671232},null,null,{"$f":"IF(ISBLANK(E9),\"\",IF(MID(M9,1,2)=\"RN\",\"RN SERIES/\",IF(MID(M9,1,3)=\"YSC\",\"TRANE\",IF(MID(M9,1,3)=\"50K\",\"WEAMaker SE\",IF(MID(M9,1,4)=\"48ES\",\"Comfort\",IF(MID(M9,1,3)=\"48H\",\"WEAMaster HE\",IF(MID(M9,1,3)=\"48T\",\"WEAMaker SE\",IF(MID(M9,3,2)=\"HP\",\"HEAT PUMP\",IF(MID(M9,3,2)=\"KC\",\"WEAMaker SE\",IF(MID(M9,3,2)=\"FC\",\"WEAMaker EcoBlue\",IF(COUNT(FIND({5610,5611,5612,5613,5614,5615,5616,5617,5618,5619,5620,5621},E9))>0,\"ENERGENCE/\",\"L SERIES/\")))))))))))","v":"ENERGENCE/"},null,null,null,null,null,null,{"$f":"'2020 Chain'!AC20","v":"HUM"},null,null,{"$f":"IF(MID(AO6,1,7)=\"S97-100\",\"KITCHEN\",IF(MID(AO6,1,7)=\"S97-110\",\"KITCHEN\",IF(MID(AO6,1,7)=\"S97-120\",\"KITCHEN\",IF(MID(AO6,1,7)=\"S97-136\",\"KITCHEN\",IF(MID(AO6,1,7)=\"S97-138\",\"KITCHEN\",IF(MID(AO6,1,4)=\"S03C\",\"MECH/RR/DIN A\",IF(MID(AO6,1,4)=\"S03E\",\"MECH/RR/DINA\",IF(MID(AO6,1,7)=\"S03-128\",\"RR/DIN A/MECH/ELEC\",IF(MID(AO6,1,7)=\"S03-146\",\"RR/DIN A\",IF(MID(AO6,1,9)=\"S03-150SW\",\"RR/DIN A/MECH\",IF(MID(AO6,1,7)=\"S04-110\",\"MECH/RR/DIN A\",IF(MID(AO6,1,3)=\"S04\",\"Mech/RR/Din A\",IF(MID(AO6,1,4)=\"S06A\",\"ENT A/SERV/DT\",IF(MID(AO6,1,4)=\"S06B\",\"MECH/RR/DIN A\",IF(MID(AO6,1,4)=\"S06C\",\"MECH/RR/DIN A\",IF(MID(AO6,1,4)=\"S06E\",\"MECH/RR/DIN A\",IF(MID(AO6,1,4)=\"S08A\",\"DT/SERV/ENT\",IF(MID(AO6,1,4)=\"S08C\",\"DIN A/RR/MECH/BRK\",IF(MID(AO6,1,4)=\"S08E\",\"DIN A/RR/BRK RM/MECH\",IF(MID(AO6,1,6)=\"S08N-T\",\"MECH/RR/DIN A/ENT A\",IF(MID(AO6,1,7)=\"S08N-LG\",\"MECH/RR/DIN A/ENT A\",IF(MID(AO6,9,2)=\"AZ\",\"DINING\",IF(MID(AO6,1,2)=\"KK\",\"RR/DIN A,/ENT A\",\"\")))))))))))))))))))))))","v":"Mech/RR/Din A"},null,null,null,null,null,null,{"$f":"VALUE(IF(AB20=15,\"2518\",IF(AB20=12.5,\"2518\",IF(AB20=10,\"2352\",IF(AB20=8.5,\"2352\",IF(AB20=7.5,\"1911\",IF(AB20=6,\"1911\",IF(AB20=5,\"1828\",IF(AB20=4,\"1828\",\"0\")))))))))","v":0},null,null,null,{"$f":"VALUE(IF(AB22=15,\"9662\",IF(AB22=12.5,\"9662\",IF(AB22=10,\"6452\",IF(AB22=8.5,\"6452\",IF(AB22=7.5,\"5397\",IF(AB22=6,\"5397\",IF(AB22=5,\"4161\",IF(AB22=4,\"4151\",\"0\")))))))))","v":0},null,null,null,{"$f":"VALUE(IF(AB$24=15,\"475\",IF(AB$24=12.5,\"475\",IF(AB$24=10,\"475\",IF(AB$24=8.5,\"475\",IF(AB$24=7.5,\"475\",IF(AB$24=6,\"475\",IF(AB$24=5,\"475\",IF(AB$24=4,\"475\",\"0\")))))))))","v":0},null,null,null,null,{"$f":"VALUE(IF(AB$26=15,\"9662\",IF(AB$26=12.5,\"9662\",IF(AB$26=10,\"6452\",IF(AB$26=8.5,\"6452\",IF(AB$26=7.5,\"5397\",IF(AB$26=6,\"5397\",IF(AB$26=5,\"4161\",IF(AB$26=4,\"4161\",\"0\")))))))))","v":0},null,null,null,null,null,{"$f":"VALUE(IF(AB$28=15,\"537\",IF(AB$28=12.5,\"537\",IF(AB$28=10,\"537\",IF(AB$28=8.5,\"537\",IF(AB$28=7.5,\"437\",IF(AB$28=6,\"537\",IF(AB$28=5,\"537\",IF(AB$28=4,\"537\",\"0\")))))))))","v":0},null,null,null,0]
[null,"AC3",null,null,{"$f":"'2020 Chain'!AH20","v":"5620H05565"},null,null,null,null,null,null,null,{"$f":"'2020 Chain'!AJ20","v":"LGH150H4BH2Y"},null,null,null,null,null,null,null,null,null,null,"12.5",null,null,"Lennox",null,null,null,null,{"$f":"'2020 Chain'!AL20","v":5.1287671232876715},null,null,{"$f":"IF(ISBLANK(E10),\"\",IF(MID(M10,1,2)=\"RN\",\"RN SERIES/\",IF(MID(M10,1,3)=\"YSC\",\"TRANE\",IF(MID(M10,1,3)=\"50K\",\"WEAMaker SE\",IF(MID(M10,1,4)=\"48ES\",\"Comfort\",IF(MID(M10,1,3)=\"48H\",\"WEAMaster HE\",IF(MID(M10,1,3)=\"48T\",\"WEAMaker SE\",IF(MID(M10,3,2)=\"HP\",\"HEAT PUMP\",IF(MID(M10,3,2)=\"KC\",\"WEAMaker SE\",IF(MID(M10,3,2)=\"FC\",\"WEAMaker EcoBlue\",IF(COUNT(FIND({5610,5611,5612,5613,5614,5615,5616,5617,5618,5619,5620,5621},E10))>0,\"ENERGENCE/\",\"L SERIES/\")))))))))))","v":"ENERGENCE/"},null,null,null,null,null,null,{"$f":"'2020 Chain'!AI20","v":"HUM"},null,null,{"$f":"IF(MID(AO6,1,7)=\"S97-100\",\"SERV/DT/ENT B\",IF(MID(AO6,1,7)=\"S97-110\",\"SERV/DT/ENT B\",IF(MID(AO6,1,7)=\"S97-120\",\"SERV/DIN B/DT\",IF(MID(AO6,1,7)=\"S97-136\",\"SERV/DT/ENTB\",IF(MID(AO6,1,7)=\"S97-138\",\"SERV/DT/DIN B/ENT B\",IF(MID(AO6,1,4)=\"S03C\",\"SERV/DT/DIN B/ENT B\",IF(MID(AO6,1,4)=\"S03E\",\"SERV/DIN B/ENT A&B\",IF(MID(AO6,1,7)=\"S03-128\",\"SERV/DIN B/ENT B/DT\",IF(MID(AO6,1,7)=\"S03-146\",\"ENT A/DIN B\",IF(MID(AO6,1,9)=\"S03-150SW\",\"ENT A/DIN B\",IF(MID(AO6,1,7)=\"S04-110\",\"DT/SERV/DIN B/ENT A&B\",IF(MID(AO6,1,3)=\"S04\",\"SERV/DT/DIN B/ENT B\",IF(MID(AO6,1,4)=\"S06A\",\"RR/DIN\",IF(MID(AO6,1,4)=\"S06B\",\"DT/SERV/DIN B/ENT B\",IF(MID(AO6,1,4)=\"S06C\",\"SERV/DT/DIN B/ENT B\",IF(MID(AO6,1,4)=\"S06E\",\"SERV/ENTA/ENTB,/DIN B\",IF(MID(AO6,1,4)=\"S08A\",\"RR/DINING\",IF(MID(AO6,1,4)=\"S08C\",\"DINB/SERV/DT/ENT B\",IF(MID(AO6,1,4)=\"S08E\",\"DINB/SERV/DT/ENT A&B\",IF(MID(AO6,1,6)=\"S08N-T\",\"DIN B\",IF(MID(AO6,1,7)=\"S08N-LG\",\"DIN B\",IF(MID(AO6,9,2)=\"AZ\",\"ENTRY/DINING\",IF(MID(AO6,1,2)=\"KK\",\"DIN B\",\"\")))))))))))))))))))))))","v":"SERV/DT/DIN B/ENT B"},null,null,null,null,null,null,{"$f":"VALUE(IF(AH20=15,\"2518\",IF(AH20=12.5,\"2518\",IF(AH20=10,\"2352\",IF(AH20=8.5,\"2352\",IF(AH20=7.5,\"1911\",IF(AH20=6,\"1911\",IF(AH20=5,\"1828\",IF(AH20=4,\"1828\",\"0\")))))))))","v":0},null,null,null,{"$f":"VALUE(IF(AH22=15,\"9662\",IF(AH22=12.5,\"9662\",IF(AH22=10,\"6452\",IF(AH22=8.5,\"6452\",IF(AH22=7.5,\"5397\",IF(AH22=6,\"5397\",IF(AH22=5,\"4161\",IF(AH22=4,\"4151\",\"0\")))))))))","v":0},null,null,null,{"$f":"VALUE(IF(AH$24=15,\"475\",IF(AH$24=12.5,\"475\",IF(AH$24=10,\"475\",IF(AH$24=8.5,\"475\",IF(AH$24=7.5,\"475\",IF(AH$24=6,\"475\",IF(AH$24=5,\"475\",IF(AH$24=4,\"475\",\"0\")))))))))","v":0},null,null,null,null,{"$f":"VALUE(IF(AH$26=15,\"9662\",IF(AH$26=12.5,\"9662\",IF(AH$26=10,\"6452\",IF(AH$26=8.5,\"6452\",IF(AH$26=7.5,\"5397\",IF(AH$26=6,\"5397\",IF(AH$26=5,\"4161\",IF(AH$26=4,\"4161\",\"0\")))))))))","v":0},null,null,null,null,null,{"$f":"VALUE(IF(AH$28=15,\"537\",IF(AH$28=12.5,\"537\",IF(AH$28=10,\"537\",IF(AH$28=8.5,\"537\",IF(AH$28=7.5,\"437\",IF(AH$28=6,\"537\",IF(AH$28=5,\"537\",IF(AH$28=4,\"537\",\"0\")))))))))","v":0},null,null,null,0]
[null,"AC4",null,null,{"$f":"'2020 Chain'!AN20","v":"5619H05552"},null,null,null,null,null,null,null,{"$f":"'2020 Chain'!AP20","v":"LGH060H4EH4Y"},null,null,null,null,null,null,null,null,null,null,"5",null,null,"Lennox",null,null,null,null,{"$f":"'2020 Chain'!AR20","v":3.128767123287671},null,null,{"$f":"IF(ISBLANK(E11),\"\",IF(MID(M11,1,2)=\"RN\",\"RN SERIES/\",IF(MID(M11,1,3)=\"YSC\",\"TRANE\",IF(MID(M11,1,3)=\"50K\",\"WEAMaker SE\",IF(MID(M11,1,4)=\"48ES\",\"Comfort\",IF(MID(M11,1,3)=\"48H\",\"WEAMaster HE\",IF(MID(M11,1,3)=\"48T\",\"WEAMaker SE\",IF(MID(M11,3,2)=\"HP\",\"HEAT PUMP\",IF(MID(M11,3,2)=\"KC\",\"WEAMaker SE\",IF(MID(M11,3,2)=\"FC\",\"WEAMaker EcoBlue\",IF(COUNT(FIND({5610,5611,5612,5613,5614,5615,5616,5617,5618,5619,5620,5621},E11))>0,\"ENERGENCE/\",\"L SERIES/\")))))))))))","v":"ENERGENCE/"},null,null,null,null,null,null,{"$f":"'2020 Chain'!AO20","v":"HUM"},null,null,{"$f":"IF(MID(AO6,1,7)=\"S97-100\",\"DIN B/ENT A\",IF(MID(AO6,1,7)=\"S97-110\",\"PLAYLAND\",IF(MID(AO6,1,7)=\"S97-120\",\"ENTA/DIN B\",IF(MID(AO6,1,7)=\"S97-136\",\"DIN B/ENT A\",IF(MID(AO6,1,7)=\"S97-138\",\"ENT A/DIN B\",IF(MID(AO6,1,4)=\"S03C\",\"ENT A/DIN B\",IF(MID(AO6,1,4)=\"S03E\",\"PLAYLAND\",IF(MID(AO6,1,7)=\"S03-128\",\"ENT A/DIN B\",IF(MID(AO6,1,7)=\"S03-146\",\"SERV/DIN B\",IF(MID(AO6,1,9)=\"S03-150SW\",\"SERV/DIN B\",IF(MID(AO6,1,7)=\"S04-110\",\"PLAYLAND\",IF(MID(AO6,1,3)=\"S04\",\"ENTA/DIN B\",IF(MID(AO6,1,4)=\"S06A\",\"PLAYLAND\",IF(MID(AO6,1,4)=\"S06B\",\"ENT A/DIN B\",IF(MID(AO6,1,4)=\"S06C\",\"ENT A/DIN B\",IF(MID(AO6,1,4)=\"S06E\",\"PLAYLAND\",IF(MID(AO6,1,4)=\"S08A\",\"PLAYLAND\",IF(MID(AO6,1,4)=\"S08C\",\"DIN B/ENT A\",IF(MID(AO6,1,4)=\"S08E\",\"PLAYLAND\",IF(MID(AO6,1,6)=\"S08N-T\",\"DT,SERV/DIN B\",IF(MID(AO6,1,7)=\"S08N-LG\",\"DT/SERV/DIN B\",IF(MID(AO6,9,2)=\"AZ\",\"SERV/DINING/RR/DT\",IF(MID(AO6,1,2)=\"KK\",\"SERV/DIN B\",\"\")))))))))))))))))))))))","v":"ENTA/DIN B"},null,null,null,null,null,null,{"$f":"VALUE(IF(AN20=15,\"2518\",IF(AN20=12.5,\"2518\",IF(AN20=10,\"2352\",IF(AN20=8.5,\"2352\",IF(AN20=7.5,\"1911\",IF(AN20=6,\"1911\",IF(AN20=5,\"1828\",IF(AN20=4,\"1828\",\"0\")))))))))","v":0},null,null,null,{"$f":"VALUE(IF(AN22=15,\"9662\",IF(AN22=12.5,\"9662\",IF(AN22=10,\"6452\",IF(AN22=8.5,\"6452\",IF(AN22=7.5,\"5397\",IF(AN22=6,\"5397\",IF(AN22=5,\"4161\",IF(AN22=4,\"4151\",\"0\")))))))))","v":0},null,null,null,{"$f":"VALUE(IF(AN$24=15,\"475\",IF(AN$24=12.5,\"475\",IF(AN$24=10,\"475\",IF(AN$24=8.5,\"475\",IF(AN$24=7.5,\"475\",IF(AN$24=6,\"475\",IF(AN$24=5,\"475\",IF(AN$24=4,\"475\",\"0\")))))))))","v":0},null,null,null,null,{"$f":"VALUE(IF(AN$26=15,\"9662\",IF(AN$26=12.5,\"9662\",IF(AN$26=10,\"6452\",IF(AN$26=8.5,\"6452\",IF(AN$26=7.5,\"5397\",IF(AN$26=6,\"5397\",IF(AN$26=5,\"4161\",IF(AN$26=4,\"4161\",\"0\")))))))))","v":0},null,null,null,null,null,{"$f":"VALUE(IF(AN$28=15,\"537\",IF(AN$28=12.5,\"537\",IF(AN$28=10,\"537\",IF(AN$28=8.5,\"537\",IF(AN$28=7.5,\"437\",IF(AN$28=6,\"537\",IF(AN$28=5,\"537\",IF(AN$28=4,\"537\",\"0\")))))))))","v":0},null,null,null,0]
[null,"AC5",null,null,{"$f":"'2020 Chain'!AT20","v":0},null,null,null,null,null,null,null,{"$f":"'2020 Chain'!AV20","v":0},null,null,null,null,null,null,null,null,null,null,"",null,null,"Carrier",null,null,null,null,{"$f":"'2020 Chain'!AX20","v":0},null,null,{"$f":"IF(ISBLANK(E12),\"\",IF(MID(M12,1,2)=\"RN\",\"RN SERIES/\",IF(MID(M12,1,3)=\"YSC\",\"TRANE\",IF(MID(M12,1,3)=\"50K\",\"WEAMaker SE\",IF(MID(M12,1,4)=\"48ES\",\"Comfort\",IF(MID(M12,1,3)=\"48H\",\"WEAMaster HE\",IF(MID(M12,1,3)=\"48T\",\"WEAMaker SE\",IF(MID(M12,3,2)=\"HP\",\"HEAT PUMP\",IF(MID(M12,3,2)=\"KC\",\"WEAMaker SE\",IF(MID(M12,3,2)=\"FC\",\"WEAMaker EcoBlue\",IF(COUNT(FIND({5610,5611,5612,5613,5614,5615,5616,5617,5618,5619,5620,5621},E12))>0,\"ENERGENCE/\",\"L SERIES/\")))))))))))","v":"L SERIES/"},null,null,null,null,null,null,{"$f":"'2020 Chain'!AU20","v":0},null,null,{"$f":"IF(MID(AO6,1,7)=\"S97-120\",\"PLAY LAND\",IF(MID(AO6,1,7)=\"S97-136\",\"PLAYLAND\",IF(MID(AO6,1,7)=\"S97-138\",\"PLAYLAND\",IF(MID(AO6,1,4)=\"S03C\",\"PLAYLAND\",IF(MID(AO6,1,7)=\"S03-128\",\"PLAYLAND\",IF(MID(AO6,1,7)=\"S03-146\",\"PLAYLAND\",IF(MID(AO6,1,9)=\"S03-150SW\",\"PLAYLAND\",IF(MID(AO6,1,3)=\"S04\",\"PLAYLAND\",IF(MID(AO6,1,4)=\"S06B\",\"PLAYLAND\",IF(MID(AO6,1,4)=\"S06C\",\"PLAYLAND\",IF(MID(AO6,1,4)=\"S08C\",\"PLAYLAND\",IF(MID(AO6,1,6)=\"S08N-T\",\"PLAYLAND\",IF(MID(AO6,1,7)=\"S08N-LG\",\"PLAYLAND\",IF(MID(AO6,9,2)=\"AZ\",\"KITCHEN/OFFICE\",IF(MID(AO6,1,2)=\"KK\",\"PLAYLAND\",\"\")))))))))))))))","v":"PLAYLAND"},null,null,null,null,null,null,{"$f":"VALUE(IF(AT20=15,\"2518\",IF(AT20=12.5,\"2518\",IF(AT20=10,\"2352\",IF(AT20=8.5,\"2352\",IF(AT20=7.5,\"1911\",IF(AT20=6,\"1911\",IF(AT20=5,\"1828\",IF(AT20=4,\"1828\",\"0\")))))))))","v":0},null,null,null,{"$f":"VALUE(IF(AT22=15,\"9662\",IF(AT22=12.5,\"9662\",IF(AT22=10,\"6452\",IF(AT22=8.5,\"6452\",IF(AT22=7.5,\"5397\",IF(AT22=6,\"5397\",IF(AT22=5,\"4161\",IF(AT22=4,\"4151\",\"0\")))))))))","v":0},null,null,null,{"$f":"VALUE(IF(AT$24=15,\"475\",IF(AT$24=12.5,\"475\",IF(AT$24=10,\"475\",IF(AT$24=8.5,\"475\",IF(AT$24=7.5,\"475\",IF(AT$24=6,\"475\",IF(AT$24=5,\"475\",IF(AT$24=4,\"475\",\"0\")))))))))","v":0},null,null,null,null,{"$f":"VALUE(IF(AT$26=15,\"9662\",IF(AT$26=12.5,\"9662\",IF(AT$26=10,\"6452\",IF(AT$26=8.5,\"6452\",IF(AT$26=7.5,\"5397\",IF(AT$26=6,\"5397\",IF(AT$26=5,\"4161\",IF(AT$26=4,\"4161\",\"0\")))))))))","v":0},null,null,null,null,null,{"$f":"VALUE(IF(AT$28=15,\"537\",IF(AT$28=12.5,\"537\",IF(AT$28=10,\"537\",IF(AT$28=8.5,\"537\",IF(AT$28=7.5,\"437\",IF(AT$28=6,\"537\",IF(AT$28=5,\"537\",IF(AT$28=4,\"537\",\"0\")))))))))","v":0},null,null,null,0]
[null,"AC6",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"",null,null,{"$f":"IF(ISBLANK(M13),\"\",IF(MID(M13,1,2)=\"LG\",\"Lennox\",\"Carrier\"))","v":""},null,null,null,null,{"$f":"'2020 Chain'!BC20","v":0},null,null,{"$f":"IF(ISBLANK(E13),\"\",IF(MID(M13,1,3)=\"50K\",\"WEAMaker SE\",IF(MID(M13,1,4)=\"48ES\",\"Comfort\",IF(MID(M13,1,3)=\"48H\",\"WEAMaster HE\",IF(MID(M13,1,3)=\"48T\",\"WEAMaker SE\",IF(MID(M13,1,3)=\"50H\",\"WEAMaster HP\",IF(COUNT(FIND({5610,5611,5612,5613,5614,5615,5616,5617,5618,5619,5620,5621},E13))>0,\"ENERGENCE\",\"L SERIES\")))))))","v":""},null,null,null,null,null,null,null,null,null,{"$f":"IF(MID(AO6,1,7)=\"S04-162\",\"OFFICE/BREAK ROOM\",IF(MID(AO6,9,2)=\"AZ\",\"PLAYLAND\",\"\"))","v":""},null,null,null,null,null,null,{"$f":"VALUE(IF(AZ20=15,\"2518\",IF(AZ20=12.5,\"2518\",IF(AZ20=10,\"2352\",IF(AZ20=8.5,\"2352\",IF(AZ20=7.5,\"1911\",IF(AZ20=6,\"1911\",IF(AZ20=5,\"1828\",IF(AZ20=4,\"1828\",\"0\")))))))))","v":0},null,null,null,{"$f":"VALUE(IF(AZ22=15,\"9662\",IF(AZ22=12.5,\"9662\",IF(AZ22=10,\"6452\",IF(AZ22=8.5,\"6452\",IF(AZ22=7.5,\"5397\",IF(AZ22=6,\"5397\",IF(AZ22=5,\"4161\",IF(AZ22=4,\"4151\",\"0\")))))))))","v":0},null,null,null,{"$f":"VALUE(IF(AZ$24=15,\"475\",IF(AZ$24=12.5,\"475\",IF(AZ$24=10,\"475\",IF(AZ$24=8.5,\"475\",IF(AZ$24=7.5,\"475\",IF(AZ$24=6,\"475\",IF(AZ$24=5,\"475\",IF(AZ$24=4,\"475\",\"0\")))))))))","v":0},null,null,null,null,{"$f":"VALUE(IF(AZ$26=15,\"9662\",IF(AZ$26=12.5,\"9662\",IF(AZ$26=10,\"6452\",IF(AZ$26=8.5,\"6452\",IF(AZ$26=7.5,\"5397\",IF(AZ$26=6,\"5397\",IF(AZ$26=5,\"4161\",IF(AZ$26=4,\"4161\",\"0\")))))))))","v":0},null,null,null,null,null,{"$f":"VALUE(IF(AZ$28=15,\"537\",IF(AZ$28=12.5,\"537\",IF(AZ$28=10,\"537\",IF(AZ$28=8.5,\"537\",IF(AZ$28=7.5,\"437\",IF(AZ$28=6,\"537\",IF(AZ$28=5,\"537\",IF(AZ$28=4,\"537\",\"0\")))))))))","v":0},null,null,null,0]
[null,"AC7",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"IF(MID(M14,4,3)=\"180\",\"15\",IF(MID(M14,4,3)=\"150\",\"12.5\",IF(MID(M14,4,3)=\"120\",\"10\",IF(MID(M14,4,3)=\"102\",\"8.5\",IF(MID(M14,4,3)=\"090\",\"7.5\",IF(MID(M14,4,3)=\"060\",\"5\",IF(MID(M14,4,3)=\"048\",\"4\",\"\")))))))","v":""},null,null,"",null,null,null,null,null,null,null,{"$f":"IF(ISBLANK(E14),\"\",IF(MID(M14,1,3)=\"50K\",\"WEAMaker SE\",IF(MID(M14,1,4)=\"48ES\",\"Comfort\",IF(MID(M14,1,3)=\"48H\",\"WEAMaster HE\",IF(MID(M14,1,3)=\"48T\",\"WEAMaker SE\",IF(COUNT(FIND({5610,5611,5612,5613,5614,5615,5616,5617,5618,5619,5620,5621},E14))>0,\"ENERGENCE\",\"L SERIES\"))))))","v":""},null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"VALUE(IF(BF20=15,\"2518\",IF(BF20=12.5,\"2518\",IF(BF20=10,\"2352\",IF(BF20=8.5,\"2352\",IF(BF20=7.5,\"1911\",IF(BF20=6,\"1911\",IF(BF20=5,\"1828\",IF(BF20=4,\"1828\",\"0\")))))))))","v":0},null,null,null,{"$f":"VALUE(IF(BF22=15,\"9662\",IF(BF22=12.5,\"9662\",IF(BF22=10,\"6452\",IF(BF22=8.5,\"6452\",IF(BF22=7.5,\"5397\",IF(BF22=6,\"5397\",IF(BF22=5,\"4161\",IF(BF22=4,\"4151\",\"0\")))))))))","v":0},null,null,null,{"$f":"VALUE(IF(BF$24=15,\"475\",IF(BF$24=12.5,\"475\",IF(BF$24=10,\"475\",IF(BF$24=8.5,\"475\",IF(BF$24=7.5,\"475\",IF(BF$24=6,\"475\",IF(BF$24=5,\"475\",IF(BF$24=4,\"475\",\"0\")))))))))","v":0},null,null,null,null,{"$f":"VALUE(IF(BF$26=15,\"9662\",IF(BF$26=12.5,\"9662\",IF(BF$26=10,\"6452\",IF(BF$26=8.5,\"6452\",IF(BF$26=7.5,\"5397\",IF(BF$26=6,\"5397\",IF(BF$26=5,\"4161\",IF(BF$26=4,\"4161\",\"0\")))))))))","v":0},null,null,null,null,null,{"$f":"VALUE(IF(BF$28=15,\"537\",IF(BF$28=12.5,\"537\",IF(BF$28=10,\"537\",IF(BF$28=8.5,\"537\",IF(BF$28=7.5,\"437\",IF(BF$28=6,\"537\",IF(BF$28=5,\"537\",IF(BF$28=4,\"537\",\"0\")))))))))","v":0},null,null,null,0]
[null,"AC8",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"",null,null,"",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"TOTAL",null,null,null,null,null,null,{"$f":"VALUE(SUM(AZ8:AZ14))","v":0},null,null,null,{"$f":"SUM(BD8:BD14)","v":0},null,null,null,{"$f":"SUM(BH8:BH14)","v":0},null,null,null,null,{"$f":"SUM(BM8:BM14)","v":0},null,null,null,null,null,{"$f":"SUM(BS8:BS14)","v":0},null,null,null,0]
[null,"CRITICAL - Unable to Perform T & B Scope until Corrected by Responsible Party."]
[null,"REVIEW & RECTIFY - If no action is taken T&B can be performed, but system performance will suffer."]
[null,"NON-CRITICAL - Noted for consideration by project team, but not critical to system performance or fnctionality."]
[null,"1.  Using punch/screwdriver, prod heat exchanger tubes.  If holes found and/or or prod test fail enter unit tonnage and lock out."]
[null,null,null,"CRITICAL",null,null,null,null,null,null,null,null,null,null,null,null,null,null,"AC1",null,null,null,null,null,"AC2",null,null,"C",null,null,"AC3",null,null,"C",null,null,"AC4",null,null,"C",null,null,"AC5",null,null,{"$f":"IF(ISBLANK($E$12),\"N/A\",\"\")","v":""},null,null,"AC6",null,null,{"$f":"IF(ISBLANK($E$13),\"N/A\",\"\")","v":"N/A"},null,null,"AC7",null,null,{"$f":"IF(ISBLANK($E$14),\"N/A\",\"\")","v":"N/A"},null,null,"AC8",null,null,{"$f":"IF(ISBLANK($E$15),\"N/A\",\"\")","v":"N/A"}]
[null,"2.  Quantify damage/deterioration to the condenser coil (0% to 100%).  If greater than 50% enter unit tonnage."]
[null,null,null,"CRITICAL",null,null,null,null,null,null,null,null,null,null,null,null,null,null,"AC1",null,null,{"$f":"IF(ISBLANK($E$8),\"N/A\",IF(MID($M$8,7,2)=\"14\",\"N/A\",IF(MID($M$8,7,2)=\"16\",\"N/A\",IF(MID($M$8,7,2)<\"14\",\"\",IF(MID($M$8,4,3)>\"149\",\"N/A\",\"\")))))","v":"N/A"},null,null,"AC2",null,null,"C",null,null,"AC3",null,null,"C",null,null,"AC4",null,null,"C",null,null,"AC5",null,null,{"$f":"IF(ISBLANK($E$12),\"N/A\",\"\")","v":""},null,null,"AC6",null,null,{"$f":"IF(ISBLANK($E$13),\"N/A\",\"\")","v":"N/A"},null,null,"AC7",null,null,{"$f":"IF(ISBLANK($E$14),\"N/A\",\"\")","v":"N/A"},null,null,"AC8",null,null,{"$f":"IF(ISBLANK($E$15),\"N/A\",\"\")","v":"N/A"}]
[null,"3.  Is there a hail guard installed on unit?  If NO, enter unit tonnage.  NOTE: If \"CRITICAL\", unit in top ten hail states."]
[null,null,null,{"$f":"IF(MID(AR4,1,2)=\"NC\",\"CRITICAL\",IF(MID(AR4,1,2)=\"IA\",\"CRITICAL\",IF(MID(AR4,1,2)=\"MN\",\"CRITICAL\",IF(MID(AR4,1,2)=\"TX\",\"CRITICAL\",IF(MID(AR4,1,2)=\"AR\",\"CRITICAL\",IF(MID(AR4,1,2)=\"OK\",\"CRITICAL\",IF(MID(AR4,1,2)=\"MO\",\"CRITICAL\",IF(MID(AR4,1,2)=\"KS\",\"CRITICAL\",IF(MID(AR4,1,3)=\"NEB\",\"CRITICAL\",IF(MID(AR4,1,2)=\"SD\",\"CRITICAL\",\"NON-CRITICAL\"))))))))))","v":"NON-CRITICAL"},null,null,null,null,null,null,null,null,null,null,null,null,null,null,"AC1",null,null,{"$f":"IF(ISBLANK($E$8),\"N/A\",IF(MID($M$8,7,2)=\"14\",\"N/A\",IF(MID($M$8,7,2)=\"16\",\"N/A\",IF(MID($M$8,7,2)<\"14\",\"\",IF(MID($M$8,4,3)>\"149\",\"N/A\",\"\")))))","v":"N/A"},null,null,"AC2",null,null,"C",null,null,"AC3",null,null,"C",null,null,"AC4",null,null,"C",null,null,"AC5",null,null,{"$f":"IF(ISBLANK($E$12),\"N/A\",\"\")","v":""},null,null,"AC6",null,null,{"$f":"IF(ISBLANK($E$13),\"N/A\",\"\")","v":"N/A"},null,null,"AC7",null,null,{"$f":"IF(ISBLANK($E$14),\"N/A\",\"\")","v":"N/A"},null,null,"AC8",null,null,{"$f":"IF(ISBLANK($E$15),\"N/A\",\"\")","v":"N/A"}]
[null,"4.  Check both sides of evaporator coil for deterioration.  Perform fin test. If greater than 50% enter unit tonnage"]
[null,null,null,"CRITICAL",null,null,null,null,null,null,null,null,null,null,null,null,null,null,"AC1",null,null,{"$f":"IF(ISBLANK($E$8),\"N/A\",IF(MID($M$8,7,2)=\"14\",\"N/A\",IF(MID($M$8,7,2)=\"16\",\"N/A\",IF(MID($M$8,7,2)<\"14\",\"\",IF(MID($M$8,4,3)>\"149\",\"N/A\",\"\")))))","v":"N/A"},null,null,"AC2",null,null,"C",null,null,"AC3",null,null,"C",null,null,"AC4",null,null,"C",null,null,"AC5",null,null,{"$f":"IF(ISBLANK($E$12),\"N/A\",\"\")","v":""},null,null,"AC6",null,null,{"$f":"IF(ISBLANK($E$13),\"N/A\",\"\")","v":"N/A"},null,null,"AC7",null,null,{"$f":"IF(ISBLANK($E$14),\"N/A\",\"\")","v":"N/A"},null,null,"AC8",null,null,{"$f":"IF(ISBLANK($E$15),\"N/A\",\"\")","v":"N/A"}]
[null,"5.  Check for power exhaust at AC units greater than ten tons.  If no power exhaust enter unit tonnage."]
[null,null,null,"CRITICAL",null,null,null,null,null,null,null,null,null,null,null,null,null,null,"AC1",null,null,{"$f":"IF(ISBLANK($E$8),\"N/A\",IF(MID($M$8,4,3)<=\"120\",\"N/A\",IF(MID($M$8,7,2)=\"14\",\"N/A\",IF(MID($M$8,7,2)=\"16\",\"N/A\",IF(MID($M$8,7,2)<\"14\",\"\",IF(MID($M$8,4,3)>\"149\",\"N/A\",\"\"))))))","v":"N/A"},null,null,"AC2",null,null,{"$f":"IF(ISBLANK($E$9),\"N/A\",IF(MID($M$9,4,3)<=\"120\",\"N/A\",IF(MID($M$9,7,2)=\"14\",\"N/A\",IF(MID($M$9,7,2)=\"16\",\"N/A\",IF(MID($M$9,7,2)<\"14\",\"\",IF(MID($M$9,4,3)>\"149\",\"N/A\",\"\"))))))","v":"N/A"},null,null,"AC3",null,null,"C",null,null,"AC4",null,null,{"$f":"IF(ISBLANK($E$11),\"N/A\",IF(MID($M$11,4,3)<=\"120\",\"N/A\",\"\"))","v":"N/A"},null,null,"AC5",null,null,{"$f":"IF(ISBLANK($E$12),\"N/A\",IF(MID($M$12,4,3)<=\"120\",\"N/A\",\"\"))","v":"N/A"},null,null,"AC6",null,null,{"$f":"IF(ISBLANK($E$13),\"N/A\",IF(MID($M$12,4,3)<=\"120\",\"N/A\",\"\"))","v":"N/A"},null,null,"AC7",null,null,{"$f":"IF(ISBLANK($E$14),\"N/A\",IF(MID($M$12,4,3)<=\"120\",\"N/A\",\"\"))","v":"N/A"},null,null,"AC8",null,null,{"$f":"IF(ISBLANK($E$15),\"N/A\",IF(MID($M$15,4,3)<=\"120\",\"N/A\",\"\"))","v":"N/A"}]
[null,"6.  Are there curb adaptors on any of the units?  If YES, enter unit tonnage."]
[null,null,null,"CRITICAL",null,null,null,null,null,null,null,null,null,null,null,null,null,null,"AC1",null,null,{"$f":"IF(ISBLANK($E$8),\"N/A\",IF(MID($M$8,7,2)=\"14\",\"N/A\",IF(MID($M$8,7,2)=\"16\",\"N/A\",IF(MID($M$8,7,2)<\"14\",\"\",IF(MID($M$8,4,3)>\"149\",\"N/A\",\"\")))))","v":"N/A"},null,null,"AC2",null,null,"C",null,null,"AC3",null,null,"C",null,null,"AC4",null,null,5,null,null,"AC5",null,null,{"$f":"IF(ISBLANK($E$12),\"N/A\",\"\")","v":""},null,null,"AC6",null,null,{"$f":"IF(ISBLANK($E$13),\"N/A\",\"\")","v":"N/A"},null,null,"AC7",null,null,{"$f":"IF(ISBLANK($E$14),\"N/A\",\"\")","v":"N/A"},null,null,"AC8",null,null,{"$f":"IF(ISBLANK($E$15),\"N/A\",\"\")","v":"N/A"}]
[null,"7.  See identified Humiditrol units below (HUM = HUMIDITROL)."]
[null,null,null,"NON CRITICAL",null,null,null,null,null,null,null,null,null,null,null,null,null,null,"AC1",null,null,{"$f":"IF(ISBLANK($E$8),\"N/A\",IF(MID(AP8,1,3)=\"HUM\",\"HUM\",\"NO\"))","v":"HUM"},null,null,"AC2",null,null,{"$f":"IF(ISBLANK($E$9),\"N/A\",IF(MID(AP9,1,3)=\"HUM\",\"HUM\",\"NO\"))","v":"HUM"},null,null,"AC3",null,null,{"$f":"IF(ISBLANK($E$10),\"N/A\",IF(MID(AP10,1,3)=\"HUM\",\"HUM\",\"NO\"))","v":"HUM"},null,null,"AC4",null,null,{"$f":"IF(ISBLANK($E$11),\"N/A\",IF(MID(AP11,1,3)=\"HUM\",\"HUM\",\"NO\"))","v":"HUM"},null,null,"AC5",null,null,{"$f":"IF(ISBLANK($E$12),\"N/A\",IF(MID(AP12,1,3)=\"HUM\",\"HUM\",\"NO\"))","v":"NO"},null,null,"AC6",null,null,{"$f":"IF(ISBLANK($E$13),\"N/A\",IF(MID(AP13,1,3)=\"HUM\",\"HUM\",\"NO\"))","v":"N/A"},null,null,"AC7",null,null,{"$f":"IF(ISBLANK($E$14),\"N/A\",\"\")","v":"N/A"},null,null,"AC8",null,null,{"$f":"IF(ISBLANK($E$15),\"N/A\",\"\")","v":"N/A"}]
[null,"8.  Is the humidity sensor wired?  If NO,  enter unit tonnage."]
[null,null,null,"CRITICAL",null,null,null,null,null,null,null,null,null,null,null,null,null,null,"AC1",null,null,{"$f":"IF(ISBLANK($E$8),\"N/A\",IF(MID($M$8,7,2)=\"14\",\"N/A\",IF(MID($M$8,7,2)=\"16\",\"N/A\",IF(MID($M$8,7,2)<\"14\",\"\",IF(MID($M$8,4,3)>\"149\",\"N/A\",IF(MID(V32,1,2)=\"NO\",\"N/A\",\"\"))))))","v":"N/A"},null,null,"AC2",null,null,"C",null,null,"AC3",null,null,"C",null,null,"AC4",null,null,"C",null,null,"AC5",null,null,{"$f":"IF(ISBLANK($E$12),\"N/A\",IF(LEN($M$12)>15,\"N/A\",IF(MID(AT32,1,2)=\"NO\",\"N/A\",\"\")))","v":"N/A"},null,null,"AC6",null,null,{"$f":"IF(ISBLANK($E$13),\"N/A\",\"\")","v":"N/A"},null,null,"AC7",null,null,{"$f":"IF(ISBLANK($E$14),\"N/A\",\"\")","v":"N/A"},null,null,"AC8",null,null,{"$f":"IF(ISBLANK($E$15),\"N/A\",\"\")","v":"N/A"}]
[null,"9. In table below record As-Built size of gas lines at gas meter riser, B1, B2, B3, B4, B5 etc. The cells below will auto populate when table is filled in."]
[null,null,null,"CRITICAL",null,null,null,null,null,null,null,null,null,null,null,null,null,null,"B1",null,null,{"$f":"P166","v":"2-1/2\""},null,null,"B2",null,null,{"$f":"P167","v":"2\""},null,null,"B3",null,null,{"$f":"P168","v":"2\""},null,null,"B4",null,null,{"$f":"P169","v":"1-1/2\""},null,null,"B5",null,null,{"$f":"P170","v":0},null,null,"B6",null,null,{"$f":"P171","v":0},null,null,"B7",null,null,null,null,null,"B8"]
[null,"10. In the table below record the As-Built gas line drops D1, D2, D3, D4, D5 etc.  The cells below will auto-populate when table in filled in."]
[null,null,null,"CRITICAL",null,null,null,null,null,null,null,null,null,null,null,null,null,null,"D1",null,null,{"$f":"AZ166","v":"1-1/4\""},null,null,"D2",null,null,{"$f":"AZ167","v":"1\""},null,null,"D3",null,null,{"$f":"AZ168","v":"1-1/4\""},null,null,"D4",null,null,{"$f":"AZ169","v":"1-1/4\""},null,null,"D5",null,null,{"$f":"AZ170","v":"1-1/4\""},null,null,"D6",null,null,{"$f":"AZ171","v":0},null,null,"D7",null,null,{"$f":"AZ172","v":0},null,null,"D8"]
[null,"ITEM 1 THROUGH 9 MISC. NOTES"]
[]
[]
[]
[]
[null,"11.  Record size of gas line going into unit.  NOTE: Pull down menu in cells."]
[null,null,null,"CRITICAL",null,null,null,null,null,null,null,null,null,null,null,null,null,null,"AC1",null,null,"3/4\"",null,null,"AC2",null,null,"3/4\"",null,null,"AC3",null,null,"3/4\"",null,null,"AC4",null,null,"3/4\"",null,null,"AC5",null,null,null,null,null,"AC6",null,null,null,null,null,"AC7",null,null,null,null,null,"AC8"]
[null,"12.  Is a smoke detector present in unit?  If NO, enter unit tonnage."]
[null,null,null,"CRITICAL",null,null,null,null,null,null,null,null,null,null,null,null,null,null,"AC1",null,null,"C",null,null,"AC2",null,null,"C",null,null,"AC3",null,null,"C",null,null,"AC4",null,null,"C",null,null,"AC5",null,null,{"$f":"IF(ISBLANK($E$12),\"N/A\",\"\")","v":""},null,null,"AC6",null,null,{"$f":"IF(ISBLANK($E$13),\"N/A\",\"\")","v":"N/A"},null,null,"AC7",null,null,{"$f":"IF(ISBLANK($E$14),\"N/A\",\"\")","v":"N/A"},null,null,"AC8",null,null,{"$f":"IF(ISBLANK($E$15),\"N/A\",\"\")","v":"N/A"}]
[null,"13.  Is the smoke detector inlet sampling tube capped?  If NO, enter unit tonnage."]
[null,null,null,"CRITICAL",null,null,null,null,null,null,null,null,null,null,null,null,null,null,"AC1",null,null,"C",null,null,"AC2",null,null,"C",null,null,"AC3",null,null,"C",null,null,"AC4",null,null,"C",null,null,"AC5",null,null,{"$f":"IF(ISBLANK($E$12),\"N/A\",\"\")","v":""},null,null,"AC6",null,null,{"$f":"IF(ISBLANK($E$13),\"N/A\",\"\")","v":"N/A"},null,null,"AC7",null,null,{"$f":"IF(ISBLANK($E$14),\"N/A\",\"\")","v":"N/A"},null,null,"AC8",null,null,{"$f":"IF(ISBLANK($E$15),\"N/A\",\"\")","v":"N/A"}]
[null,"14.  Check smoke detector module light. If light RED or an AMBER color, enter unit tonnage."]
[null,null,null,"CRITICAL",null,null,null,null,null,null,null,null,null,null,null,null,null,null,"AC1",null,null,"C",null,null,"AC2",null,null,"C",null,null,"AC3",null,null,"C",null,null,"AC4",null,null,"C",null,null,"AC5",null,null,{"$f":"IF(ISBLANK($E$12),\"N/A\",\"\")","v":""},null,null,"AC6",null,null,{"$f":"IF(ISBLANK($E$13),\"N/A\",\"\")","v":"N/A"},null,null,"AC7",null,null,{"$f":"IF(ISBLANK($E$14),\"N/A\",\"\")","v":"N/A"},null,null,"AC8",null,null,{"$f":"IF(ISBLANK($E$15),\"N/A\",\"\")","v":"N/A"}]
[null,"15.  Is smoke detector dust plugs capped?  If YES, enter unit tonnage."]
[null,null,null,"CRITICAL",null,null,null,null,null,null,null,null,null,null,null,null,null,null,"AC1",null,null,"C",null,null,"AC2",null,null,8.5,null,null,"AC3",null,null,12.5,null,null,"AC4",null,null,"C",null,null,"AC5",null,null,{"$f":"IF(ISBLANK($E$12),\"N/A\",\"\")","v":""},null,null,"AC6",null,null,{"$f":"IF(ISBLANK($E$13),\"N/A\",\"\")","v":"N/A"},null,null,"AC7",null,null,{"$f":"IF(ISBLANK($E$14),\"N/A\",\"\")","v":"N/A"},null,null,"AC8",null,null,{"$f":"IF(ISBLANK($E$15),\"N/A\",\"\")","v":"N/A"}]
[null,"16.  Is hub (hub houses bearings and located at center of pulley) at the tensioner intact?  If NO, enter unit tonnage."]
[null,null,null,"CRITICAL",null,null,null,null,null,null,null,null,null,null,null,null,null,null,"AC1",null,null,{"$f":"IF(ISBLANK($E$8),\"N/A\",IF(LEN($M$8)>15,\"N/A\",IF(VALUE(MID($E$8,3,2))<17,\"N/A\",IF(MID($M$8,7,2)=\"14\",\"N/A\",IF(MID($M$8,7,2)=\"16\",\"N/A\",IF(MID($M$8,4,3)>\"149\",\"N/A\",IF(MID($M$8,4,3)<=\"060\",\"N/A\",\"\")))))))","v":"N/A"},null,null,"AC2",null,null,"C",null,null,"AC3",null,null,"C",null,null,"AC4",null,null,{"$f":"IF(ISBLANK($E$11),\"N/A\",IF(LEN($M$11)>15,\"N/A\",IF(VALUE(MID($E$11,3,2))<17,\"N/A\",IF(MID($M$11,4,3)<=\"060\",\"N/A\",\"\"))))","v":"N/A"},null,null,"AC5",null,null,{"$f":"IF(ISBLANK($E$12),\"N/A\",IF(LEN($M$12)>15,\"N/A\",IF(VALUE(MID($E$12,3,2))<17,\"N/A\",IF(MID($M$12,4,3)<=\"060\",\"N/A\",\"\"))))","v":{"$error":"#VALUE!"}},null,null,"AC6",null,null,{"$f":"IF(ISBLANK($E$13),\"N/A\",IF(VALUE(MID($E$13,3,2))<17,\"N/A\",IF(MID($M$12,4,3)<=\"060\",\"N/A\",\"\")))","v":"N/A"},null,null,"AC7",null,null,{"$f":"IF(ISBLANK($E$14),\"N/A\",IF(VALUE(MID($E$14,3,2))<17,\"N/A\",IF(MID($M$14,4,3)<=\"060\",\"N/A\",\"\")))","v":"N/A"},null,null,"AC8",null,null,{"$f":"IF(ISBLANK($E$15),\"N/A\",IF(VALUE(MID($E$15,3,2))<17,\"N/A\",IF(MID($M$15,4,3)<=\"060\",\"N/A\",\"\")))","v":"N/A"}]
[null,"17. Is belt tensioner installed?  If NO, enter unit tonnage."]
[null,null,null,"CRITICAL",null,null,null,null,null,null,null,null,null,null,null,null,null,null,"AC1",null,null,{"$f":"IF(ISBLANK($E$8),\"N/A\",IF(LEN($M$8)>15,\"N/A\",IF(VALUE(MID($E$8,3,2))<17,\"N/A\",IF(MID($M$8,7,2)=\"14\",\"N/A\",IF(MID($M$8,7,2)=\"16\",\"N/A\",IF(MID($M$8,4,3)>\"149\",\"N/A\",IF(MID($M$8,4,3)<=\"060\",\"N/A\",\"\")))))))","v":"N/A"},null,null,"AC2",null,null,"C",null,null,"AC3",null,null,"C",null,null,"AC4",null,null,{"$f":"IF(ISBLANK($E$11),\"N/A\",IF(LEN($M$11)>15,\"N/A\",IF(VALUE(MID($E$11,3,2))<17,\"N/A\",IF(MID($M$11,4,3)<=\"060\",\"N/A\",\"\"))))","v":"N/A"},null,null,"AC5",null,null,{"$f":"IF(ISBLANK($E$12),\"N/A\",IF(LEN($M$12)>15,\"N/A\",IF(VALUE(MID($E$12,3,2))<17,\"N/A\",IF(MID($M$12,4,3)<=\"060\",\"N/A\",\"\"))))","v":{"$error":"#VALUE!"}},null,null,"AC6",null,null,{"$f":"IF(ISBLANK($E$13),\"N/A\",IF(VALUE(MID($E$13,3,2))<17,\"N/A\",IF(MID($M$12,4,3)<=\"060\",\"N/A\",\"\")))","v":"N/A"},null,null,"AC7",null,null,{"$f":"IF(ISBLANK($E$14),\"N/A\",IF(VALUE(MID($E$14,3,2))<17,\"N/A\",IF(MID($M$14,4,3)<=\"060\",\"N/A\",\"\")))","v":"N/A"},null,null,"AC8",null,null,{"$f":"IF(ISBLANK($E$15),\"N/A\",IF(VALUE(MID($E$15,3,2))<17,\"N/A\",IF(MID($M$15,4,3)<=\"060\",\"N/A\",\"\")))","v":"N/A"}]
[null,"ITEM 9 THROUGH 16 MISC. NOTES"]
[]
[]
[]
[]
[]
[null,"18. Look for damage/indentions at pulleys?  If damage found, enter unit tonnage."]
[null,null,null,"CRITICAL",null,null,null,null,null,null,null,null,null,null,null,null,null,null,"AC1",null,null,{"$f":"IF(ISBLANK($E$8),\"N/A\",IF(LEN($M$8)>15,\"N/A\",IF(MID($M$8,7,2)=\"14\",\"N/A\",IF(MID($M$8,7,2)=\"16\",\"N/A\",IF(MID($M$8,4,3)>\"149\",\"N/A\",IF(MID($M$8,4,3)<=\"060\",\"N/A\",\"\"))))))","v":"N/A"},null,null,"AC2",null,null,"C",null,null,"AC3",null,null,"C",null,null,"AC4",null,null,{"$f":"IF(ISBLANK($E$11),\"N/A\",IF(MID($M$11,4,3)<=\"060\",\"N/A\",\"\"))","v":"N/A"},null,null,"AC5",null,null,{"$f":"IF(ISBLANK($E$12),\"N/A\",IF(MID($M$12,4,3)<=\"060\",\"N/A\",\"\"))","v":"N/A"},null,null,"AC6",null,null,{"$f":"IF(ISBLANK($E$13),\"N/A\",\"\")","v":"N/A"},null,null,"AC7",null,null,{"$f":"IF(ISBLANK($E$14),\"N/A\",\"\")","v":"N/A"},null,null,"AC8",null,null,{"$f":"IF(ISBLANK($E$15),\"N/A\",\"\")","v":"N/A"}]
[null,"20. Check motor sheave to assure it can be adjusted.  If cannot be adJusted, enter unit tonnage, & part #'S in misc notes."]
[null,null,null,"CRITICAL",null,null,null,null,null,null,null,null,null,null,null,null,null,null,"AC1",null,null,{"$f":"IF(ISBLANK($E$8),\"N/A\",IF(LEN($M$8)>15,\"N/A\",IF(MID($M$8,7,2)=\"14\",\"N/A\",IF(MID($M$8,7,2)=\"16\",\"N/A\",IF(MID($M$8,4,3)>\"149\",\"N/A\",IF(MID($M$8,4,3)<=\"060\",\"N/A\",\"\"))))))","v":"N/A"},null,null,"AC2",null,null,8.5,null,null,"AC3",null,null,12.5,null,null,"AC4",null,null,{"$f":"IF(ISBLANK($E$11),\"N/A\",IF(MID($M$11,4,3)<=\"060\",\"N/A\",\"\"))","v":"N/A"},null,null,"AC5",null,null,{"$f":"IF(ISBLANK($E$12),\"N/A\",IF(MID($M$12,4,3)<=\"060\",\"N/A\",\"\"))","v":"N/A"},null,null,"AC6",null,null,{"$f":"IF(ISBLANK($E$13),\"N/A\",\"\")","v":"N/A"},null,null,"AC7",null,null,{"$f":"IF(ISBLANK($E$14),\"N/A\",\"\")","v":"N/A"},null,null,"AC8",null,null,{"$f":"IF(ISBLANK($E$15),\"N/A\",\"\")","v":"N/A"}]
[null,"21. Record belt size."]
[null,null,null,"N/A",null,null,null,null,null,null,null,null,null,null,null,null,null,null,"AC1",null,null,{"$f":"IF(ISBLANK($E$8),\"N/A\",IF(LEN($M$8)>15,\"N/A\",IF(MID($M$8,7,2)=\"14\",\"N/A\",IF(MID($M$8,7,2)=\"16\",\"N/A\",IF(MID($M$8,4,3)>\"149\",\"N/A\",IF(MID($M$8,4,3)<=\"060\",\"N/A\",\"\"))))))","v":"N/A"},null,null,"AC2",null,null,"BX68",null,null,"AC3",null,null,"BX68",null,null,"AC4",null,null,{"$f":"IF(ISBLANK($E$11),\"N/A\",IF(MID($M$11,4,3)<=\"060\",\"N/A\",\"\"))","v":"N/A"},null,null,"AC5",null,null,{"$f":"IF(ISBLANK($E$12),\"N/A\",IF(MID($M$12,4,3)<=\"060\",\"N/A\",\"\"))","v":"N/A"},null,null,"AC6",null,null,{"$f":"IF(ISBLANK($E$13),\"N/A\",\"\")","v":"N/A"},null,null,"AC7",null,null,{"$f":"IF(ISBLANK($E$14),\"N/A\",\"\")","v":"N/A"},null,null,"AC8",null,null,{"$f":"IF(ISBLANK($E$15),\"N/A\",\"\")","v":"N/A"}]
[null,"22.  Identify any damage to the blower.  If DAMAGE found, enter unit tonnage."]
[null,null,null,"CRITICAL",null,null,null,null,null,null,null,null,null,null,null,null,null,null,"AC1",null,null,{"$f":"IF(ISBLANK($E$8),\"N/A\",IF(MID($M$8,7,2)=\"14\",\"N/A\",IF(MID($M$8,7,2)=\"16\",\"N/A\",IF(MID($M$8,7,2)<\"14\",\"\",IF(MID($M$8,4,3)>\"149\",\"N/A\",\"\")))))","v":"N/A"},null,null,"AC2",null,null,"C",null,null,"AC3",null,null,"C",null,null,"AC4",null,null,"C",null,null,"AC5",null,null,{"$f":"IF(ISBLANK($E$12),\"N/A\",\"\")","v":""},null,null,"AC6",null,null,{"$f":"IF(ISBLANK($E$13),\"N/A\",\"\")","v":"N/A"},null,null,"AC7",null,null,{"$f":"IF(ISBLANK($E$14),\"N/A\",\"\")","v":"N/A"},null,null,"AC8",null,null,{"$f":"IF(ISBLANK($E$15),\"N/A\",\"\")","v":"N/A"}]
[null,"23.  Quantify cleanliness of blower.  If dirty, enter unit tonnage."]
[null,null,null,"NON CRITICAL",null,null,null,null,null,null,null,null,null,null,null,null,null,null,"AC1",null,null,{"$f":"IF(ISBLANK($E$8),\"N/A\",IF(MID($M$8,7,2)=\"14\",\"N/A\",IF(MID($M$8,7,2)=\"16\",\"N/A\",IF(MID($M$8,4,3)>\"149\",\"N/A\",\"\"))))","v":"N/A"},null,null,"AC2",null,null,"C",null,null,"AC3",null,null,"C",null,null,"AC4",null,null,"C",null,null,"AC5",null,null,{"$f":"IF(ISBLANK($E$12),\"N/A\",\"\")","v":""},null,null,"AC6",null,null,{"$f":"IF(ISBLANK($E$13),\"N/A\",\"\")","v":"N/A"},null,null,"AC7",null,null,{"$f":"IF(ISBLANK($E$14),\"N/A\",\"\")","v":"N/A"},null,null,"AC8",null,null,{"$f":"IF(ISBLANK($E$15),\"N/A\",\"\")","v":"N/A"}]
[null,"24.  At blower motor start up is there a concernng amount of noise or vibration?  If so, enter unit tonnage."]
[null,null,null,"CRITICAL",null,null,null,null,null,null,null,null,null,null,null,null,null,null,"AC1",null,null,{"$f":"IF(ISBLANK($E$8),\"N/A\",IF(MID($M$8,7,2)=\"14\",\"N/A\",IF(MID($M$8,7,2)=\"16\",\"N/A\",IF(MID($M$8,4,3)>\"149\",\"N/A\",\"\"))))","v":"N/A"},null,null,"AC2",null,null,"C",null,null,"AC3",null,null,"C",null,null,"AC4",null,null,"C",null,null,"AC5",null,null,{"$f":"IF(ISBLANK($E$12),\"N/A\",\"\")","v":""},null,null,"AC6",null,null,{"$f":"IF(ISBLANK($E$13),\"N/A\",\"\")","v":"N/A"},null,null,"AC7",null,null,{"$f":"IF(ISBLANK($E$14),\"N/A\",\"\")","v":"N/A"},null,null,"AC8",null,null,{"$f":"IF(ISBLANK($E$15),\"N/A\",\"\")","v":"N/A"}]
[null,"25.  Is blank plate secured on B-cabinets?  If NO, enter unit tonnage."]
[null,null,null,"REVIEW & RECTIFY",null,null,null,null,null,null,null,null,null,null,null,null,null,null,"AC1",null,null,{"$f":"IF(ISBLANK($E$8),\"N/A\",IF(LEN($M$8)>15,\"N/A\",IF(MID($M$8,4,3)<=\"072\",\"N/A\",IF(MID($M$8,4,3)>=\"180\",\"N/A\",IF(MID($M$8,7,2)=\"14\",\"N/A\",IF(MID($M$8,7,2)=\"16\",\"N/A\",IF(MID($M$8,4,3)>\"149\",\"N/A\",\"\")))))))","v":"N/A"},null,null,"AC2",null,null,"C",null,null,"AC3",null,null,12.5,null,null,"AC4",null,null,{"$f":"IF(ISBLANK($E$11),\"N/A\",IF(LEN($M$11)>15,\"N/A\",IF(MID($M$11,4,3)<=\"072\",\"N/A\",IF(MID($M$11,4,3)>\"150\",\"N/A\",\"\"))))","v":"N/A"},null,null,"AC5",null,null,{"$f":"IF(ISBLANK($E$12),\"N/A\",IF(LEN($M$12)>15,\"N/A\",IF(MID($M$12,4,3)<=\"072\",\"N/A\",IF(MID($M$12,4,3)>\"150\",\"N/A\",\"\"))))","v":"N/A"},null,null,"AC6",null,null,{"$f":"IF(ISBLANK($E$13),\"N/A\",IF(MID($M$13,4,3)<=\"072\",\"N/A\",IF(MID($M$13,4,3)>\"150\",\"N/A\",\"\")))","v":"N/A"},null,null,"AC7",null,null,{"$f":"IF(ISBLANK($E$14),\"N/A\",IF(MID($M$14,4,3)<=\"072\",\"N/A\",IF(MID($M$14,4,3)>\"150\",\"N/A\",\"\")))","v":"N/A"},null,null,"AC8",null,null,{"$f":"IF(ISBLANK($E$15),\"N/A\",IF(MID($M$15,4,3)<=\"072\",\"N/A\",IF(MID($M$15,4,3)>\"150\",\"N/A\",\"\")))","v":"N/A"}]
[null,"26.  Is ductwork lined?  If  YES, enter unit tonnage."]
[null,null,null,"REVIEW & RECTIFY",null,null,null,null,null,null,null,null,null,null,null,null,null,null,"AC1",null,null,{"$f":"IF(ISBLANK($E$8),\"N/A\",IF(MID($M$8,7,2)=\"14\",\"N/A\",IF(MID($M$8,7,2)=\"16\",\"N/A\",IF(MID($M$8,4,3)>\"149\",\"N/A\",\"\"))))","v":"N/A"},null,null,"AC2",null,null,"C",null,null,"AC3",null,null,"C",null,null,"AC4",null,null,"C",null,null,"AC5",null,null,{"$f":"IF(ISBLANK($E$12),\"N/A\",\"\")","v":""},null,null,"AC6",null,null,{"$f":"IF(ISBLANK($E$13),\"N/A\",\"\")","v":"N/A"},null,null,"AC7",null,null,{"$f":"IF(ISBLANK($E$14),\"N/A\",\"\")","v":"N/A"},null,null,"AC8",null,null,{"$f":"IF(ISBLANK($E$15),\"N/A\",\"\")","v":"N/A"}]
[null,"ITEM 17 THROUGH 23 MISC. NOTES"]
[null,"MOTOR SHEAVES FOR AC2 AND AC3 ARE RUSTED AND CANNOT BE ADJUSTED."]
[]
[]
[]
[]
[null,"27. Are turning vanes present in the supply ducts of the units?  IF NO, insert unit tonnage."]
[null,null,null,"REVIEW & RECTIFY",null,null,null,null,null,null,null,null,null,null,null,null,null,null,"AC1",null,null,{"$f":"IF(ISBLANK($E$8),\"N/A\",IF(MID($M$8,7,2)=\"14\",\"N/A\",IF(MID($M$8,7,2)=\"16\",\"N/A\",IF(MID($M$8,4,3)>\"149\",\"N/A\",\"\"))))","v":"N/A"},null,null,"AC2",null,null,"C",null,null,"AC3",null,null,"C",null,null,"AC4",null,null,"C",null,null,"AC5",null,null,{"$f":"IF(ISBLANK($E$12),\"N/A\",\"\")","v":""},null,null,"AC6",null,null,{"$f":"IF(ISBLANK($E$13),\"N/A\",\"\")","v":"N/A"},null,null,"AC7",null,null,{"$f":"IF(ISBLANK($E$14),\"N/A\",\"\")","v":"N/A"},null,null,"AC8",null,null,{"$f":"IF(ISBLANK($E$15),\"N/A\",\"\")","v":"N/A"}]
[null,"28. Are turning vanes single or double thickness?  If DOUBLE, enter unit tonnage."]
[null,null,null,"REVIEW & RECTIFY",null,null,null,null,null,null,null,null,null,null,null,null,null,null,"AC1",null,null,{"$f":"IF(ISBLANK($E$8),\"N/A\",IF(MID($M$8,7,2)=\"14\",\"N/A\",IF(MID($M$8,7,2)=\"16\",\"N/A\",IF(MID($M$8,4,3)>\"149\",\"N/A\",\"\"))))","v":"N/A"},null,null,"AC2",null,null,"C",null,null,"AC3",null,null,"C",null,null,"AC4",null,null,"C",null,null,"AC5",null,null,{"$f":"IF(ISBLANK($E$12),\"N/A\",\"\")","v":""},null,null,"AC6",null,null,{"$f":"IF(ISBLANK($E$13),\"N/A\",\"\")","v":"N/A"},null,null,"AC7",null,null,{"$f":"IF(ISBLANK($E$14),\"N/A\",\"\")","v":"N/A"},null,null,"AC8",null,null,{"$f":"IF(ISBLANK($E$15),\"N/A\",\"\")","v":"N/A"}]
[null,"29. Is duct work seated and aligned?  If NO, enter unit tonnage."]
[null,null,null,"N/A",null,null,null,null,null,null,null,null,null,null,null,null,null,null,"AC1",null,null,{"$f":"IF(ISBLANK($E$8),\"N/A\",IF(MID($M$8,7,2)=\"14\",\"N/A\",IF(MID($M$8,7,2)=\"16\",\"N/A\",IF(MID($M$8,4,3)>\"149\",\"N/A\",\"\"))))","v":"N/A"},null,null,"AC2",null,null,"C",null,null,"AC3",null,null,"C",null,null,"AC4",null,null,"C",null,null,"AC5",null,null,{"$f":"IF(ISBLANK($E$12),\"N/A\",\"\")","v":""},null,null,"AC6",null,null,{"$f":"IF(ISBLANK($E$13),\"N/A\",\"\")","v":"N/A"},null,null,"AC7",null,null,{"$f":"IF(ISBLANK($E$14),\"N/A\",\"\")","v":"N/A"},null,null,"AC8",null,null,{"$f":"IF(ISBLANK($E$15),\"N/A\",\"\")","v":"N/A"}]
[null,"30. Is canvas connector present?  If NO, enter unit tonnage."]
[null,null,null,"REVIEW & RECTIFY",null,null,null,null,null,null,null,null,null,null,null,null,null,null,"AC1",null,null,{"$f":"IF(ISBLANK($E$8),\"N/A\",IF(MID($M$8,7,2)=\"14\",\"N/A\",IF(MID($M$8,7,2)=\"16\",\"N/A\",IF(MID($M$8,4,3)>\"149\",\"N/A\",\"\"))))","v":"N/A"},null,null,"AC2",null,null,"C",null,null,"AC3",null,null,"C",null,null,"AC4",null,null,"C",null,null,"AC5",null,null,{"$f":"IF(ISBLANK($E$12),\"N/A\",\"\")","v":""},null,null,"AC6",null,null,{"$f":"IF(ISBLANK($E$13),\"N/A\",\"\")","v":"N/A"},null,null,"AC7",null,null,{"$f":"IF(ISBLANK($E$14),\"N/A\",\"\")","v":"N/A"},null,null,"AC8",null,null,{"$f":"IF(ISBLANK($E$15),\"N/A\",\"\")","v":"N/A"}]
[null,"31.  Quantify cleanliness of duct.  If dirty, enter unit tonnage."]
[null,null,null,"NON CRITICAL",null,null,null,null,null,null,null,null,null,null,null,null,null,null,"AC1",null,null,{"$f":"IF(ISBLANK($E$8),\"N/A\",IF(MID($M$8,7,2)=\"14\",\"N/A\",IF(MID($M$8,7,2)=\"16\",\"N/A\",IF(MID($M$8,4,3)>\"149\",\"N/A\",\"\"))))","v":"N/A"},null,null,"AC2",null,null,"C",null,null,"AC3",null,null,"C",null,null,"AC4",null,null,"C",null,null,"AC5",null,null,{"$f":"IF(ISBLANK($E$12),\"N/A\",\"\")","v":""},null,null,"AC6",null,null,{"$f":"IF(ISBLANK($E$13),\"N/A\",\"\")","v":"N/A"},null,null,"AC7",null,null,{"$f":"IF(ISBLANK($E$14),\"N/A\",\"\")","v":"N/A"},null,null,"AC8",null,null,{"$f":"IF(ISBLANK($E$15),\"N/A\",\"\")","v":"N/A"}]
[null,"32.  If turning vanes not present, is drop radiused?  If so, does radius equal the width of the duct? If not, enter tonnage."]
[null,null,null,"REVIEW & RECTIFY",null,null,null,null,null,null,null,null,null,null,null,null,null,null,"AC1",null,null,{"$f":"IF(ISBLANK($E$8),\"N/A\",IF(MID($M$8,7,2)=\"14\",\"N/A\",IF(MID($M$8,7,2)=\"16\",\"N/A\",IF(MID($M$8,4,3)>\"149\",\"N/A\",\"\"))))","v":"N/A"},null,null,"AC2",null,null,"N/A",null,null,"AC3",null,null,"C",null,null,"AC4",null,null,"C",null,null,"AC5",null,null,{"$f":"IF(ISBLANK($E$12),\"N/A\",\"\")","v":""},null,null,"AC6",null,null,{"$f":"IF(ISBLANK($E$13),\"N/A\",\"\")","v":"N/A"},null,null,"AC7",null,null,{"$f":"IF(ISBLANK($E$14),\"N/A\",\"\")","v":"N/A"},null,null,"AC8",null,null,{"$f":"IF(ISBLANK($E$15),\"N/A\",\"\")","v":"N/A"}]
[null,"33.  Do units have prodigy boards?  If no, enter unit tonnage (identify only if the AC unit is an Energence unit)."]
[null,null,null,"REVIEW & RECTIFY",null,null,null,null,null,null,null,null,null,null,null,null,null,null,"AC1",null,null,{"$f":"IF(ISBLANK($E$8),\"N/A\",IF(LEN($M$8)>15,\"N/A\",IF(VALUE(MID($E$8,3,2))<10,\"N/A\",IF(MID($M$8,7,2)=\"14\",\"N/A\",IF(MID($M$8,7,2)=\"16\",\"N/A\",IF(MID($M$8,4,3)>\"149\",\"N/A\",\"\"))))))","v":"N/A"},null,null,"AC2",null,null,"C",null,null,"AC3",null,null,"C",null,null,"AC4",null,null,"C",null,null,"AC5",null,null,{"$f":"IF(ISBLANK($E$12),\"N/A\",IF(LEN($M$12)>15,\"N/A\",IF(VALUE(MID($E$12,3,2))<10,\"N/A\",\"\")))","v":{"$error":"#VALUE!"}},null,null,"AC6",null,null,{"$f":"IF(ISBLANK($E$13),\"N/A\",IF(VALUE(MID($E$13,3,2))<10,\"N/A\",\"\"))","v":"N/A"},null,null,"AC7",null,null,{"$f":"IF(ISBLANK($E$14),\"N/A\",IF(VALUE(MID($E$14,3,2))<10,\"N/A\",\"\"))","v":"N/A"},null,null,"AC8",null,null,{"$f":"IF(ISBLANK($E$15),\"N/A\",IF(VALUE(MID($E$15,3,2))<10,\"N/A\",\"\"))","v":"N/A"}]
[null,"ITEM 24 THROUGH 30 MISC. NOTES"]
[]
[]
[]
[]
[]
[null,"34.  Identify prodigy boards New or Old.  Answer New Green, N or Old Red, R."]
[null,null,null,"REVIEW & RECTIFY",null,null,null,null,null,null,null,null,null,null,null,null,null,null,"AC1",null,null,{"$f":"IF(ISBLANK($E$8),\"N/A\",IF(LEN($M$8)>15,\"N/A\",IF(VALUE(MID($E$8,3,2))<10,\"N/A\",IF(MID($M$8,7,2)=\"14\",\"N/A\",IF(MID($M$8,7,2)=\"16\",\"N/A\",IF(MID($M$8,4,3)>\"149\",\"N/A\",\"\"))))))","v":"N/A"},null,null,"AC2",null,null,"N",null,null,"AC3",null,null,"N",null,null,"AC4",null,null,"N",null,null,"AC5",null,null,{"$f":"IF(ISBLANK($E$12),\"N/A\",IF(LEN($M$12)>15,\"N/A\",IF(VALUE(MID($E$12,3,2))<10,\"N/A\",\"\")))","v":{"$error":"#VALUE!"}},null,null,"AC6",null,null,{"$f":"IF(ISBLANK($E$13),\"N/A\",IF(VALUE(MID($E$13,3,2))<10,\"N/A\",\"\"))","v":"N/A"},null,null,"AC7",null,null,{"$f":"IF(ISBLANK($E$14),\"N/A\",IF(VALUE(MID($E$14,3,2))<10,\"N/A\",\"\"))","v":"N/A"},null,null,"AC8",null,null,{"$f":"IF(ISBLANK($E$15),\"N/A\",IF(VALUE(MID($E$15,3,2))<10,\"N/A\",\"\"))","v":"N/A"}]
[null,"35.  If economizer actuator open, turn unit off to assure it closes.  If does not CLOSE enter unit tonnage."]
[null,null,null,"CRITICAL",null,null,null,null,null,null,null,null,null,null,null,null,null,null,"AC1",null,null,{"$f":"IF(ISBLANK($E$8),\"N/A\",IF(MID($M$8,7,2)=\"14\",\"N/A\",IF(MID($M$8,7,2)=\"16\",\"N/A\",IF(MID($M$8,4,3)>\"149\",\"N/A\",\"\"))))","v":"N/A"},null,null,"AC2",null,null,"C",null,null,"AC3",null,null,"C",null,null,"AC4",null,null,"C",null,null,"AC5",null,null,{"$f":"IF(ISBLANK($E$12),\"N/A\",\"\")","v":""},null,null,"AC6",null,null,{"$f":"IF(ISBLANK($E$13),\"N/A\",\"\")","v":"N/A"},null,null,"AC7",null,null,{"$f":"IF(ISBLANK($E$14),\"N/A\",\"\")","v":"N/A"},null,null,"AC8",null,null,{"$f":"IF(ISBLANK($E$15),\"N/A\",\"\")","v":"N/A"}]
[null,"36.  Are actuator gears worn?  If yes, enter unit tonnage."]
[null,null,null,"CRITICAL",null,null,null,null,null,null,null,null,null,null,null,null,null,null,"AC1",null,null,{"$f":"IF(ISBLANK($E$8),\"N/A\",IF(MID($M$8,7,2)=\"14\",\"N/A\",IF(MID($M$8,7,2)=\"16\",\"N/A\",IF(MID($M$8,4,3)>\"149\",\"N/A\",\"\"))))","v":"N/A"},null,null,"AC2",null,null,"C",null,null,"AC3",null,null,"C",null,null,"AC4",null,null,"C",null,null,"AC5",null,null,{"$f":"IF(ISBLANK($E$12),\"N/A\",\"\")","v":""},null,null,"AC6",null,null,{"$f":"IF(ISBLANK($E$13),\"N/A\",\"\")","v":"N/A"},null,null,"AC7",null,null,{"$f":"IF(ISBLANK($E$14),\"N/A\",\"\")","v":"N/A"},null,null,"AC8",null,null,{"$f":"IF(ISBLANK($E$15),\"N/A\",\"\")","v":"N/A"}]
[null,"37.  Verify outdoor damper position  can be adjusted.  If cannot be adjusted enter unit tonnage."]
[null,null,null,"CRITICAL",null,null,null,null,null,null,null,null,null,null,null,null,null,null,"AC1",null,null,{"$f":"IF(ISBLANK($E$8),\"N/A\",IF(MID($M$8,7,2)=\"14\",\"N/A\",IF(MID($M$8,7,2)=\"16\",\"N/A\",IF(MID($M$8,4,3)>\"149\",\"N/A\",\"\"))))","v":"N/A"},null,null,"AC2",null,null,8.5,null,null,"AC3",null,null,"C",null,null,"AC4",null,null,5,null,null,"AC5",null,null,{"$f":"IF(ISBLANK($E$12),\"N/A\",\"\")","v":""},null,null,"AC6",null,null,{"$f":"IF(ISBLANK($E$13),\"N/A\",\"\")","v":"N/A"},null,null,"AC7",null,null,{"$f":"IF(ISBLANK($E$14),\"N/A\",\"\")","v":"N/A"},null,null,"AC8",null,null,{"$f":"IF(ISBLANK($E$15),\"N/A\",\"\")","v":"N/A"}]
[null,"38.  Is there any play in the actuator gear box?   If yes, enter unit tonnage"]
[null,null,null,"CRITICAL",null,null,null,null,null,null,null,null,null,null,null,null,null,null,"AC1",null,null,{"$f":"IF(ISBLANK($E$8),\"N/A\",IF(MID($M$8,7,2)=\"14\",\"N/A\",IF(MID($M$8,7,2)=\"16\",\"N/A\",IF(MID($M$8,4,3)>\"149\",\"N/A\",\"\"))))","v":"N/A"},null,null,"AC2",null,null,"C",null,null,"AC3",null,null,"C",null,null,"AC4",null,null,"C",null,null,"AC5",null,null,{"$f":"IF(ISBLANK($E$12),\"N/A\",\"\")","v":""},null,null,"AC6",null,null,{"$f":"IF(ISBLANK($E$13),\"N/A\",\"\")","v":"N/A"},null,null,"AC7",null,null,{"$f":"IF(ISBLANK($E$14),\"N/A\",\"\")","v":"N/A"},null,null,"AC8",null,null,{"$f":"IF(ISBLANK($E$15),\"N/A\",\"\")","v":"N/A"}]
[null,"39.  Check economizer setting at prodigy board.  If economizer set to zero, enter unit tonnage and re-set prodigy board to twenty percent."]
[null,null,null,"CRITICAL",null,null,null,null,null,null,null,null,null,null,null,null,null,null,"AC1",null,null,"C",null,null,"AC2",null,null,"C",null,null,"AC3",null,null,12.5,null,null,"AC4",null,null,"C",null,null,"AC5",null,null,{"$f":"IF(ISBLANK($E$12),\"N/A\",\"\")","v":""},null,null,"AC6",null,null,{"$f":"IF(ISBLANK($E$13),\"N/A\",\"\")","v":"N/A"},null,null,"AC7",null,null,{"$f":"IF(ISBLANK($E$14),\"N/A\",\"\")","v":"N/A"},null,null,"AC8",null,null,{"$f":"IF(ISBLANK($E$15),\"N/A\",\"\")","v":"N/A"}]
[null,"40.  Do filters meet CFA spec (2\" pleated polyester/cotton with MERV rating of 7).  If no, enter unit tonnage."]
[null,null,null,"NON CRITICAL",null,null,null,null,null,null,null,null,null,null,null,null,null,null,"AC1",null,null,"C",null,null,"AC2",null,null,"C",null,null,"AC3",null,null,"C",null,null,"AC4",null,null,"C",null,null,"AC5",null,null,{"$f":"IF(ISBLANK($E$12),\"N/A\",\"\")","v":""},null,null,"AC6",null,null,{"$f":"IF(ISBLANK($E$13),\"N/A\",\"\")","v":"N/A"},null,null,"AC7",null,null,{"$f":"IF(ISBLANK($E$14),\"N/A\",\"\")","v":"N/A"},null,null,"AC8",null,null,{"$f":"IF(ISBLANK($E$15),\"N/A\",\"\")","v":"N/A"}]
[null,"ITEM 31 THROUGH 35 MISC. NOTES"]
[null,"OA DAMPERS ARE NOT RESPONDING TO ADJUSTMENT"]
[]
[]
[null,"41.  Provide condensation pipe size.  Minimum 1\" at playland unit, and 1.25\" at all other units.  NOTE: DROP DOWN MENUS FOR PIPE SIZE."]
[null,null,null,"REVIEW & RECTIFY",null,null,null,null,null,null,null,null,null,null,null,null,null,null,"AC1",null,null,1,null,null,"AC2",null,null,1,null,null,"AC3",null,null,1,null,null,"AC4",null,null,1,null,null,"AC5",null,null,{"$f":"IF(ISBLANK($E$12),\"N/A\",\"\")","v":""},null,null,"AC6",null,null,{"$f":"IF(ISBLANK($E$13),\"N/A\",\"\")","v":"N/A"},null,null,"AC7",null,null,{"$f":"IF(ISBLANK($E$14),\"N/A\",\"\")","v":"N/A"},null,null,"AC8",null,null,{"$f":"IF(ISBLANK($E$15),\"N/A\",\"\")","v":"N/A"}]
[null,"42.  Do condensation traps meet provided detail.  If NO, enter unit tonnage."]
[null,null,null,"REVIEW & RECTIFY",null,null,null,null,null,null,null,null,null,null,null,null,null,null,"AC1",null,null,12.5,null,null,"AC2",null,null,8.5,null,null,"AC3",null,null,12.5,null,null,"AC4",null,null,5,null,null,"AC5",null,null,{"$f":"IF(ISBLANK($E$12),\"N/A\",\"\")","v":""},null,null,"AC6",null,null,{"$f":"IF(ISBLANK($E$13),\"N/A\",\"\")","v":"N/A"},null,null,"AC7",null,null,{"$f":"IF(ISBLANK($E$14),\"N/A\",\"\")","v":"N/A"},null,null,"AC8",null,null,{"$f":"IF(ISBLANK($E$15),\"N/A\",\"\")","v":"N/A"}]
[null,"43.  Do pre-filters need to be cleaned?  If YES, enter unit tonnage."]
[null,null,null,"REVIEW & RECTIFY",null,null,null,null,null,null,null,null,null,null,null,null,null,null,"AC1",null,null,"C",null,null,"AC2",null,null,"C",null,null,"AC3",null,null,"C",null,null,"AC4",null,null,"C",null,null,"AC5",null,null,{"$f":"IF(ISBLANK($E$12),\"N/A\",\"\")","v":""},null,null,"AC6",null,null,{"$f":"IF(ISBLANK($E$13),\"N/A\",\"\")","v":"N/A"},null,null,"AC7",null,null,{"$f":"IF(ISBLANK($E$14),\"N/A\",\"\")","v":"N/A"},null,null,"AC8",null,null,{"$f":"IF(ISBLANK($E$15),\"N/A\",\"\")","v":"N/A"}]
[null,"44.  Do pre-filters need to be replaced?  If YES, enter unit tonnage."]
[null,null,null,"REVIEW & RECTIFY",null,null,null,null,null,null,null,null,null,null,null,null,null,null,"AC1",null,null,"C",null,null,"AC2",null,null,"C",null,null,"AC3",null,null,"C",null,null,"AC4",null,null,"C",null,null,"AC5",null,null,{"$f":"IF(ISBLANK($E$12),\"N/A\",\"\")","v":""},null,null,"AC6",null,null,{"$f":"IF(ISBLANK($E$13),\"N/A\",\"\")","v":"N/A"},null,null,"AC7",null,null,{"$f":"IF(ISBLANK($E$14),\"N/A\",\"\")","v":"N/A"},null,null,"AC8",null,null,{"$f":"IF(ISBLANK($E$15),\"N/A\",\"\")","v":"N/A"}]
[null,"45.  Check Sun Coast panel terminal block for SINGLE PAIR TWISTED WITH FOIL SHIELD AND DRAIN WIRE.   If single pair twisted with foil shield NOT present enter unit tonnage.  See photo in insert twelve below."]
[null," ",null,"CRITICAL",null,null,null,null,null,null,null,null,null,null,null,null,null,null,"AC1",null,null,"C",null,null,"AC2",null,null,"C",null,null,"AC3",null,null,"C",null,null,"AC4",null,null,"C",null,null,"AC5",null,null,{"$f":"IF(ISBLANK($E$12),\"N/A\",\"\")","v":""},null,null,"AC6",null,null,{"$f":"IF(ISBLANK($E$13),\"N/A\",\"\")","v":"N/A"},null,null,"AC7",null,null,{"$f":"IF(ISBLANK($E$14),\"N/A\",\"\")","v":"N/A"},null,null,"AC8",null,null,{"$f":"IF(ISBLANK($E$15),\"N/A\",\"\")","v":"N/A"}]
[null,"ITEM 36 THROUGH 39 MISC. NOTES"]
[]
[]
[]
[]
[]
[null,"46.  Is bathroom exhaust fan running?  Enter YES or NO.",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"YES"]
[null,"47.  Is bathroom exhaust fan making excessive noise? Enter Yes or NO.",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"NO"]
[null,"48.  Is bathroom exhaust fan vibrating excessively? Enter YES or NO.",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"NO"]
[null,"49.  Does bathroom exhaust fan have a back draft damper?  Enter YES or NO.",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"NO"]
[null,"50.  Does bathroom exhaust fan duct have a liner? Enter YES OR NO.",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"  YES"]
[null,"51.  Visually inspect ductwork at bathroom exhaust fan, and rate cleanliness. Enter CLEAN OR DIRTY.",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"DIRTY"]
[null,"52.  Record model and serial number of Suncoast Panel.",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Model #",null,null,null,null,"CHICK-Fil-A CONTROL PANEL",null,null,null,null,null,null,null,null,null,null,null,null,null,"Serial #",null,null,null,null,"05-CFA-018"]
[null,"53.  Is there a HES control panel visible?  ",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Yes",null,null,"YES",null,null,null,"No"]
[null,"54.  Are thermostats Robert Shaw (Gray Display) or Network (Blue Display) ?  Enter \"RS\", \"NW\" for Robert Shaw and Network respectively.  If thermostat not Robert Shaw or Network, enter NO.",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"AC1 -",null,null,"NW",null,null,"AC2 -",null,null,"RS",null,null,"AC3 -",null,null,"RS",null,null,"AC4 -",null,null,"RS",null,null,"AC5 -"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"AC6 -",null,null,null,null,null,"AC7 -",null,null,null,null,null,"AC8 -"]
[]
[null,"MISCELLANEOUS NOTES"]
[]
[]
[]
[]
[]
[]
[]
[]
[null,null,"LONGEST RUN ______ ' - 2018 INTERNATIONAL FUEL GAS CODE - BRANCH LENGTH METHOD - TOTAL BTU'S _________"]
[]
[null,null,null,"BRANCH PIPING (B#)",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"DROP PIPING (D#)"]
[null,null,null,"DESCRIPTION",null,null,null,null,null,null,"BRANCH LENGTH/SIZE",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"DESCRIPTION",null,null,null,null,null,null,null,null,null,null,null,null,null,"DROP  LENGTH/SIZE",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"PIPE SIZE",null,null,null,"*OUTSIDE DIAMETER"]
[null,null,null,"GAS LINE",null,null,null,null,null,null,"LENGTH",null,null,null,null,"AS-BUILT",null,null,null,null,"DESIGN",null,null,null,null,"CALC",null,null,null,null,null,null,"DROP  ",null,null,null,"GAS LINE",null,null,null,null,"DEVICE",null,null,null,null,"LENGTH",null,null,null,null,"AS-BUILT",null,null,null,null,null,"DESIGN",null,null,null,null,"CALC"]
[null,null,null,null,null,null,null,null,null,null,"(ft)",null,null,null,null,"(in)",null,null,null,null,"(in)",null,null,null,null,"(in)",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"(ft)",null,null,null,null,"(in)",null,null,null,null,null,"(in)",null,null,null,null,"(in)",null,null,null,null,null,null,null,"1/2\"",null,null,null,"7/8\""]
[null,null,null," Meter to B1",null,null,null,null,null,null,{"$f":"51/12","v":4.25},null,null,null,null,"2-1/2\"",null,null,null,null,"2-1/2\"",null,null,null,null,null,null,null,null,null,null,null,"D1",null,null,null,"B1 to",null,null,null,null,"RTU 1",null,null,null,null,{"$f":"267/12","v":22.25},null,null,null,null,"1-1/4\"",null,null,null,null,null,"1-1/4\"",null,null,null,null,null,null,null,null,null,null,null,null,"3/4\"",null,null,null,"1\""]
[null,null,null,"B1 to B2",null,null,null,null,null,null,{"$f":"145/12","v":12.083333333333334},null,null,null,null,"2\"",null,null,null,null,"2-1/2\"",null,null,null,null,null,null,null,null,null,null,null,"D2",null,null,null,"B2 to",null,null,null,null,"WH",null,null,null,null,{"$f":"132/12","v":11},null,null,null,null,"1\"",null,null,null,null,null,"1\"",null,null,null,null,null,null,null,null,null,null,null,null,"1\"",null,null,null,"1-5/16\""]
[null,null,null,"B2 to B3",null,null,null,null,null,null,{"$f":"236/12","v":19.666666666666668},null,null,null,null,"2\"",null,null,null,null,"2\"",null,null,null,null,null,null,null,null,null,null,null,"D3",null,null,null,"B3 to",null,null,null,null,"RTU 2",null,null,null,null,{"$f":"168/12","v":14},null,null,null,null,"1-1/4\"",null,null,null,null,null,"1-1/4\"",null,null,null,null,null,null,null,null,null,null,null,null,"1-1/4\"",null,null,null,"1-5/8\""]
[null,null,null,"B3 to B4",null,null,null,null,null,null,{"$f":"424/12","v":35.333333333333336},null,null,null,null,"1-1/2\"",null,null,null,null,"1-1/2\"",null,null,null,null,null,null,null,null,null,null,null,"D4",null,null,null,"B4 to",null,null,null,null,"RTU 3",null,null,null,null,{"$f":"121/12","v":10.083333333333334},null,null,null,null,"1-1/4\"",null,null,null,null,null,"1-1/2\"",null,null,null,null,null,null,null,null,null,null,null,null,"1-1/2\"",null,null,null,"1-7/8\""]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"D5",null,null,null,"B5 to",null,null,null,null,"RTU 4",null,null,null,null,{"$f":"301/12","v":25.083333333333332},null,null,null,null,"1-1/4\"",null,null,null,null,null,"1\"",null,null,null,null,null,null,null,null,null,null,null,null,"2\"",null,null,null,"2-3/8\""]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"2-1/2\"",null,null,null,"2-7/8\""]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"3'",null,null,null,"3-1/2\""]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"3-1/2\"",null,null,null,"4\""]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"4\"",null,null,null,"4-1/2\""]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"*Approximate"]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[null,"Rooftop View #1",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Rooftop View #2"]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[null,"RTU#2 & 3 DUST CAPS INSTALLED",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"RTU#4 Curb Adaptor"]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[null,"Motor Sheave is not adjustable On AC#2 & 3, Rusted Threads",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Unable to adjust Economizers on AC#2 & 4"]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[null,"Blank Plate Not Secured on B cabinet in AC#3",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"RR Duct Missing Backdraft Damper & Dirty"]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[null,"INSERT 9",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"INSERT 10"]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[null,"INSERT 11",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"INSERT 12"]

{"sheet":"2020 Chain","index":1,"n_rows":23,"n_cols":66,"rows_kept":23,"cut":false,"hidden":false,"merged":[[15,51,15,55],[15,56,15,60],[15,61,15,65],[15,21,15,26],[15,27,15,32],[15,33,15,38],[15,39,15,44],[15,45,15,50]]}
["2020-10-01",null,{"$f":"COUNTIFS($B$21:$B$135,\">=\"&A1,$B$21:$B$135,\"<=\"&D1)","v":0},"2020-10-31"]
["2020-11-01",null,0,"2020-11-30"]
["2020-12-01",null,0,"2020-12-31"]
["2021-01-01",null,0,"2021-01-31"]
["2021-02-01",null,0,"2021-02-28"]
["2021-03-01",null,0,"2021-03-31"]
["2021-04-01",null,0,"2021-04-30"]
["2021-05-01",null,0,"2021-05-31"]
["2021-06-01",null,0,"2021-06-30"]
[]
[]
[]
[]
[]
[]
["(2) Store No.","Survey Due Date","(3) Location Name","(4) SOW","(8) Construction Start Date (CSD)","(14) Prototype","(23) Region","TAB Partner","Street Address","City","State","(27) Operator","SR Program Lead (SRPL)","SR Development Manager (DM)","SR Construction Manager (CM)","SR Program Manager (SRP)","FEQ Field Consultant","(37) Architect","Open Date","Location Phone","Location E-mail","AC1",null,null,null,null,null,"AC2",null,null,null,null,null,"AC3",null,null,null,null,null,"AC4",null,null,null,null,null,"AC5",null,null,null,null,null,"AC6",null,null,null,null,"AC7",null,null,null,null,"AC8"]
[1,null,"Northeast",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Serial #","HUMIDITROL","Model #","Mfg Date","Age","Type","Serial #","HUMIDITROL","Model #","Mfg Date","Age","Type","Serial #","HUMIDITROL","Model #","Mfg Date","Age","Type","Serial #","HUMIDITROL","Model #","Mfg Date","Age","Type","Serial #","HUMIDITROL","Model #","Mfg Date","Age","Type","Serial #","Model #","Mfg Date","Age","Type","Serial #","Model #","Mfg Date","Age","Type","Serial #","Model #","Mfg Date","Age","Type"]
[]
[]
[1703,{"$f":"E20-240","v":"2022-09-22"},"Boynton Beach Blvd FSU","MLv2/BI","2023-05-20","S04-100R","Southeast",{"$f":"IF(MID(G20,1,3)=\"Nor\",\"National TAB\", IF(MID(G20,1,3)=\"Atl\",\"National TAB\",IF(MID(G20,4,4)=\"thea\",\"National TAB\",\"Melink\")))","v":"National TAB"},"1560 W Boynton Beach Blvd","Boynton Beach","FL","Justin Mize","Jacob Smith","Greg Newkirk","Mark Farol","Allison Doherty","Pierre DuVentre","Interplan","09/01/2005","(561) 752-0790","01703@chick-fil-a.com","5619J01023","HUM","LGH150H4BH1Y","2019-09-01",{"$f":"(TODAY()-Y20)/365","v":3.043835616438356},{"$f":"IF(ISBLANK(V20),\"NODATA\",IF(MID(X20,1,2)=\"RN\",\"AAON\",IF(LEN(X20)>15,\"WeatherMaker\",IF(VALUE(MID(V20,3,2))>9,\"ENER\",IF(VALUE(MID(V20,3,2))<10,\"L-SER\")))))","v":"ENER"},"5617L01628","HUM","LGH102H4BH3Y","2017-11-01",{"$f":"(TODAY()-AE20)/365","v":4.8767123287671232},{"$f":"IF(ISBLANK(AB20),\"NODATA\",IF(MID(AD20,1,2)=\"RN\",\"AAON\",IF(LEN(AD20)>15,\"WeatherMaker\",IF(VALUE(MID(AB20,3,2))>9,\"ENER\",IF(VALUE(MID(AB20,3,2))<10,\"L-SER\")))))","v":"ENER"},"5620H05565","HUM","LGH150H4BH2Y","2017-08-01",{"$f":"(TODAY()-AK20)/365","v":5.1287671232876715},{"$f":"IF(ISBLANK(AH20),\"NODATA\",IF(LEN(AJ20)>15,\"WeatherMaker\",IF(VALUE(MID(AH20,3,2))>9,\"ENER\",IF(VALUE(MID(AH20,3,2))<10,\"L-SER\"))))","v":"ENER"},"5619H05552","HUM","LGH060H4EH4Y","2019-08-01",{"$f":"(TODAY()-AQ20)/365","v":3.128767123287671},{"$f":"IF(ISBLANK(AN20),\"NODATA\",IF(LEN(AP20)>15,\"WeatherMaker\",IF(VALUE(MID(AN20,3,2))>9,\"ENER\",IF(VALUE(MID(AN20,3,2))<10,\"L-SER\"))))","v":"ENER"}]
[]
[]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"5614G02828","LCH120H4BN3Y","2014-07-01"]

{"sheet":"Sheet1","index":2,"n_rows":15,"n_cols":4,"rows_kept":15,"cut":false,"hidden":false,"merged":[[1,0,2,0],[1,1,2,1],[1,3,2,3]]}
[]
["DEVICE","GAS PIPE SIZE","CONDENSATION","DROP"]
[null,null,"PIPE SIZE"]
["WH","1/2\"",0.75,"D1"]
["RTU 1","3/4\"",1,"D2"]
["RTU 2","1\"",1.25,"D3"]
["RTU 3","1-1/4\"",1.5,"D4"]
["RTU 4","1-1/2\"",null,"D5"]
["RTU 5","2\"",null,"D6"]
["RTU 6","2-1/2\"",null,"D7"]
["RTU 7","3\"",null,"D8"]
["RTU 8 ","3-1/2\"",null,"D9"]
["SLOC","4\""]
["DLOC"]
["OMDC"]