{"text_format":"1","workbook":"xlsx","n_sheets":10,"sheets":["Survey","RTU1","RTU2","RTU3","RTU4","RTU5","RTU6","BR EF","2020 Chain","Sheet1"],"not_rendered":{"charts":0,"images":13,"macros":1,"external_links":3,"defined_names":2,"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":323,"n_cols":83,"rows_kept":323,"cut":false,"hidden":false,"merged":[[157,32,157,35],[157,36,157,40],[157,41,157,45],[157,46,157,50],[157,51,157,56],[157,57,157,61],[157,62,157,66],[0,1,0,80],[151,74,151,80],[151,70,151,73],[149,74,149,80],[149,70,149,73],[39,54,39,56],[21,57,21,59],[21,51,21,53],[37,63,37,65],[37,27,37,29],[19,15,19,17],[29,15,29,17],[36,1,36,66],[37,30,37,32],[33,60,33,62],[37,48,37,50],[30,1,30,66],[37,51,37,53],[9,74,9,80],[13,74,13,80],[45,42,45,44],[37,42,37,44],[6,55,6,58],[11,70,11,73],[12,70,12,73],[12,44,12,50],[11,44,11,50],[7,55,7,58],[8,55,8,58],[9,55,9,58],[11,59,11,63],[39,27,39,29],[29,42,29,44],[29,36,29,38],[25,18,25,20],[7,64,7,69],[31,15,31,17],[31,18,31,20],[31,42,31,44],[29,18,29,20],[31,33,31,35],[31,39,31,41],[31,63,31,65],[31,45,31,47],[31,51,31,53],[31,30,31,32],[11,34,11,43],[9,34,9,43],[34,1,34,66],[27,48,27,50],[27,60,27,62],[29,24,29,26],[29,27,29,29],[29,63,29,65],[27,33,27,35],[53,63,53,65],[27,42,27,44],[37,18,37,20],[31,48,31,50],[33,30,33,32],[35,60,35,62],[37,39,37,41],[33,42,33,44],[69,63,69,65],[63,60,63,62],[69,36,69,38],[55,60,55,62],[49,57,49,59],[49,63,49,65],[53,18,53,20],[56,1,56,66],[53,1,53,2],[55,1,55,2],[57,1,57,2],[59,1,59,2],[61,36,61,38],[59,51,59,53],[33,21,33,23],[33,45,33,47],[32,1,32,66],[39,63,39,65],[53,51,53,53],[43,21,43,23],[43,48,43,50],[59,3,59,14],[42,1,42,66],[114,1,114,36],[113,30,113,36],[112,30,112,36],[113,38,113,47],[43,3,43,14],[55,39,55,41],[55,45,55,47],[55,42,55,44],[67,18,67,20],[67,45,67,47],[67,24,67,26],[114,38,114,47],[55,33,55,35],[55,51,55,53],[53,54,53,56],[152,74,152,80],[148,74,148,80],[148,70,148,73],[147,74,147,80],[147,70,147,73],[145,74,146,80],[145,70,146,73],[150,62,150,66],[151,62,151,66],[152,62,152,66],[146,57,146,61],[147,57,147,61],[146,51,146,56],[150,46,150,50],[151,46,151,50],[59,33,59,35],[49,36,49,38],[6,82,6,91],[12,41,12,43],[10,55,10,58],[11,55,11,58],[12,55,12,58],[13,55,13,58],[14,55,14,58],[6,51,6,54],[7,51,7,54],[8,51,8,54],[9,51,9,54],[10,51,10,54],[11,51,11,54],[12,51,12,54],[13,51,13,54],[14,51,14,54],[9,64,9,69],[10,64,10,69],[11,64,11,69],[12,64,12,69],[13,70,13,73],[6,59,6,63],[7,59,7,63],[14,74,14,80],[12,74,12,80],[9,70,9,73],[10,70,10,73],[12,59,12,63],[14,59,14,63],[13,44,13,50],[13,41,13,43],[7,34,7,43],[1,72,1,80],[1,56,1,71],[2,65,2,80],[2,56,2,64],[3,56,3,64],[2,45,2,55],[3,45,3,55],[2,43,2,44],[3,43,3,44],[3,65,3,80],[2,32,2,42],[3,32,3,42],[2,19,2,31],[3,19,3,31],[11,23,11,25],[11,31,11,33],[4,74,4,80],[5,74,5,80],[6,74,6,80],[7,74,7,80],[8,74,8,80],[10,74,10,80],[11,74,11,80],[1,36,1,55],[1,22,1,35],[5,30,5,39],[8,59,8,63],[9,59,9,63],[6,64,6,69],[11,26,11,30],[11,12,11,22],[4,51,4,54],[1,1,1,8],[1,9,1,17],[1,18,1,21],[31,3,31,14],[33,3,33,14],[39,3,39,14],[41,45,41,47],[12,1,12,3],[17,1,17,64],[16,1,16,57],[13,1,13,3],[13,12,13,22],[15,1,15,44],[21,36,21,38],[21,18,21,20],[25,42,25,44],[33,15,33,17],[39,15,39,17],[41,15,41,17],[41,18,41,20],[9,12,9,22],[9,26,9,30],[5,10,5,20],[10,59,10,63],[39,33,39,35],[29,45,29,47],[23,36,23,38],[37,60,37,62],[4,45,4,50],[33,54,33,56],[33,36,33,38],[33,18,33,20],[89,1,89,2],[75,39,75,41],[77,33,77,35],[77,1,77,2],[77,45,77,47],[67,51,67,53],[65,30,65,32],[63,45,63,47],[65,54,65,56],[65,27,65,29],[63,21,63,23],[69,30,69,32],[73,18,73,20],[77,21,77,23],[79,57,79,59],[79,3,79,14],[81,3,81,14],[71,42,71,44],[63,51,63,53],[67,3,67,14],[65,15,65,17],[69,54,69,56],[79,1,79,2],[89,48,89,50],[89,15,89,17],[86,1,86,66],[83,21,83,23],[85,39,85,41],[81,60,81,62],[63,36,63,38],[63,15,63,17],[69,48,69,50],[81,1,81,2],[51,39,51,41],[87,60,87,62],[87,36,87,38],[73,15,73,17],[75,15,75,17],[77,15,77,17],[69,18,69,20],[69,42,69,44],[69,45,69,47],[69,21,69,23],[65,39,65,41],[63,48,63,50],[43,18,43,20],[59,24,59,26],[53,21,53,23],[77,39,77,41],[79,51,79,53],[81,30,81,32],[85,48,85,50],[69,27,69,29],[85,24,85,26],[73,54,73,56],[63,57,63,59],[55,57,55,59],[57,3,57,14],[57,30,57,32],[49,30,49,32],[55,27,55,29],[45,27,45,29],[54,1,54,66],[59,60,59,62],[59,63,59,65],[51,36,51,38],[61,63,61,65],[50,1,50,66],[61,54,61,56],[53,57,53,59],[55,15,55,17],[47,57,47,59],[57,33,57,35],[51,18,51,20],[51,42,51,44],[57,60,57,62],[55,54,55,56],[55,21,55,23],[57,18,57,20],[59,36,59,38],[53,15,53,17],[59,15,59,17],[59,45,59,47],[57,51,57,53],[53,30,53,32],[49,18,49,20],[59,39,59,41],[51,48,51,50],[53,39,53,41],[59,30,59,32],[59,27,59,29],[61,45,61,47],[61,42,61,44],[55,3,55,14],[53,42,53,44],[49,45,49,47],[55,63,55,65],[53,60,53,62],[35,21,35,23],[35,33,35,35],[35,24,35,26],[35,27,35,29],[38,1,38,66],[37,45,37,47],[37,36,37,38],[35,63,35,65],[35,36,35,38],[35,39,35,41],[53,27,53,29],[49,27,49,29],[49,33,49,35],[37,54,37,56],[37,57,37,59],[41,63,41,65],[41,42,41,44],[37,33,37,35],[39,60,39,62],[37,3,37,14],[37,15,37,17],[39,51,39,53],[39,39,39,41],[47,15,47,17],[49,15,49,17],[51,15,51,17],[52,1,52,66],[49,60,49,62],[49,39,49,41],[45,48,45,50],[41,51,41,53],[37,24,37,26],[39,36,39,38],[47,21,47,23],[49,21,49,23],[51,24,51,26],[39,21,39,23],[39,24,39,26],[35,18,35,20],[43,15,43,17],[45,15,45,17],[41,21,41,23],[43,57,43,59],[39,18,39,20],[46,1,46,66],[47,48,47,50],[35,30,35,32],[45,30,45,32],[45,33,45,35],[41,60,41,62],[39,30,39,32],[51,30,51,32],[45,18,45,20],[47,30,47,32],[47,39,47,41],[43,27,43,29],[43,60,43,62],[31,21,31,23],[33,33,33,35],[33,48,33,50],[33,39,33,41],[33,57,33,59],[35,42,35,44],[35,45,35,47],[35,48,35,50],[23,57,23,59],[25,48,25,50],[27,27,27,29],[26,1,26,66],[27,63,27,65],[29,51,29,53],[25,21,25,23],[29,57,29,59],[27,54,27,56],[23,33,23,35],[27,21,27,23],[29,39,29,41],[29,33,29,35],[33,24,33,26],[31,60,31,62],[33,63,33,65],[31,57,31,59],[33,27,33,29],[29,54,29,56],[27,3,27,14],[27,36,27,38],[29,30,29,32],[29,48,29,50],[27,18,27,20],[27,57,27,59],[13,23,13,25],[14,44,14,50],[13,59,13,63],[19,30,19,32],[21,48,21,50],[20,1,20,66],[21,3,21,14],[13,31,13,33],[25,51,25,53],[23,3,23,14],[25,57,25,59],[25,3,25,14],[23,21,23,23],[25,63,25,65],[23,51,23,53],[25,36,25,38],[25,39,25,41],[23,54,23,56],[25,33,25,35],[25,27,25,29],[25,45,25,47],[23,45,23,47],[23,63,23,65],[23,60,23,62],[23,42,23,44],[23,24,23,26],[21,15,21,17],[13,64,13,69],[21,63,21,65],[21,60,21,62],[21,54,21,56],[19,24,19,26],[19,48,19,50],[19,51,19,53],[14,31,14,33],[23,27,23,29],[24,1,24,66],[23,18,23,20],[23,48,23,50],[19,18,19,20],[23,30,23,32],[21,39,21,41],[21,21,21,23],[19,54,19,56],[25,30,25,32],[21,27,21,29],[19,45,19,47],[21,30,21,32],[19,60,19,62],[2,1,2,4],[9,1,9,3],[6,23,6,25],[7,23,7,25],[10,12,10,22],[2,5,2,18],[6,26,6,30],[8,23,8,25],[10,1,10,3],[10,4,10,11],[6,12,6,22],[9,23,9,25],[10,23,10,25],[7,12,7,22],[4,21,4,29],[5,21,5,29],[11,1,11,3],[11,4,11,11],[8,26,8,30],[4,1,4,9],[5,1,5,9],[8,12,8,22],[3,5,3,18],[3,1,3,4],[4,10,4,20],[7,26,7,30],[25,15,25,17],[22,1,22,66],[25,24,25,26],[12,23,12,25],[31,24,31,26],[31,27,31,29],[31,36,31,38],[33,51,33,53],[31,54,31,56],[29,60,29,62],[23,39,23,41],[25,60,25,62],[25,54,25,56],[23,15,23,17],[35,3,35,14],[35,15,35,17],[35,51,35,53],[19,63,19,65],[18,1,18,66],[14,1,14,3],[14,4,14,11],[14,34,14,40],[27,45,27,47],[27,39,27,41],[27,15,27,17],[29,3,29,14],[28,1,28,66],[27,24,27,26],[35,54,35,56],[35,57,35,59],[14,64,14,69],[19,33,19,35],[27,30,27,32],[27,51,27,53],[29,21,29,23],[21,24,21,26],[12,12,12,22],[12,26,12,30],[13,26,13,30],[14,26,14,30],[97,1,97,2],[93,15,93,17],[12,31,12,33],[13,34,13,40],[19,39,19,41],[19,57,19,59],[19,42,19,44],[19,3,19,14],[21,45,21,47],[14,41,14,43],[13,4,13,11],[14,23,14,25],[19,21,19,23],[21,42,21,44],[21,33,21,35],[19,27,19,29],[19,36,19,38],[41,24,41,26],[41,30,41,32],[41,48,41,50],[12,34,12,40],[75,51,75,53],[65,45,65,47],[12,4,12,11],[60,1,60,66],[63,33,63,35],[63,30,63,32],[40,1,40,66],[39,45,39,47],[39,42,39,44],[99,3,99,14],[43,30,43,32],[49,51,49,53],[67,48,67,50],[67,15,67,17],[65,42,65,44],[65,3,65,14],[67,27,67,29],[51,54,51,56],[51,57,51,59],[51,63,51,65],[51,60,51,62],[53,33,53,35],[49,54,49,56],[51,45,51,47],[41,54,41,56],[41,33,41,35],[45,24,45,26],[45,54,45,56],[45,60,45,62],[41,57,41,59],[41,36,41,38],[41,27,41,29],[97,18,97,20],[97,36,97,38],[97,39,97,41],[104,1,104,66],[103,42,103,44],[103,45,103,47],[97,33,97,35],[51,33,51,35],[51,51,51,53],[101,51,101,53],[99,30,99,32],[99,33,99,35],[91,51,91,53],[91,54,91,56],[95,54,95,56],[95,57,95,59],[101,39,101,41],[101,45,101,47],[101,21,101,23],[103,33,103,35],[93,60,93,62],[93,45,93,47],[101,3,101,14],[95,3,95,14],[83,48,83,50],[83,24,83,26],[71,3,71,14],[77,48,77,50],[73,60,73,62],[69,57,69,59],[81,48,81,50],[77,24,77,26],[79,36,79,38],[83,33,83,35],[79,24,79,26],[97,42,97,44],[103,36,103,38],[95,27,95,29],[95,30,95,32],[103,27,103,29],[103,30,103,32],[98,1,98,66],[94,1,94,66],[91,45,91,47],[91,63,91,65],[95,60,95,62],[99,63,99,65],[103,39,103,41],[103,57,103,59],[101,63,101,65],[95,63,95,65],[97,15,97,17],[91,3,91,14],[97,24,97,26],[101,1,101,2],[99,15,99,17],[93,1,93,2],[91,15,91,17],[91,1,91,2],[93,63,93,65],[91,57,91,59],[103,21,103,23],[302,34,302,41],[302,59,302,64],[304,1,320,32],[254,2,254,7],[105,42,105,44],[101,27,101,29],[41,39,41,41],[45,3,45,14],[105,63,105,65],[105,3,105,14],[105,60,105,62],[105,21,105,23],[95,1,95,2],[206,0,228,0],[226,1,228,32],[226,34,228,65],[202,1,204,32],[184,1,200,32],[182,1,182,7],[202,34,204,65],[184,34,200,65],[101,36,101,38],[101,57,101,59],[103,48,103,50],[103,51,103,53],[102,1,102,66],[101,54,101,56],[111,1,111,55],[111,56,111,60],[108,1,108,38],[103,63,103,65],[101,24,101,26],[322,1,324,32],[322,34,324,65],[278,1,278,6],[278,25,278,32],[278,34,278,41],[278,60,278,65],[256,1,272,32],[256,34,272,65],[274,1,276,32],[274,34,276,65],[280,1,296,32],[280,34,296,65],[298,1,300,32],[298,34,300,65],[302,2,302,7],[302,25,302,32],[115,64,115,66],[145,3,145,9],[145,10,145,29],[144,3,144,29],[146,10,146,14],[146,3,147,9],[117,37,117,66],[116,55,116,66],[146,15,146,19],[152,46,152,50],[254,25,254,32],[304,34,320,65],[115,1,117,36],[254,59,254,64],[254,34,254,41],[250,34,252,65],[250,1,252,32],[232,34,248,65],[105,36,105,38],[206,2,206,8],[106,34,106,36],[109,1,109,42],[182,25,182,32],[148,3,148,9],[206,25,206,32],[208,34,224,65],[230,34,230,41],[230,1,230,6],[105,45,105,47],[115,40,115,42],[115,43,115,45],[115,46,115,48],[115,49,115,51],[115,52,115,54],[115,55,115,57],[115,58,115,60],[105,39,105,41],[105,48,105,50],[105,54,105,56],[105,27,105,29],[105,33,105,35],[182,34,182,41],[110,39,110,43],[156,3,156,9],[206,42,206,57],[150,57,150,61],[105,57,105,59],[105,15,105,17],[152,70,152,73],[153,41,153,45],[154,41,154,45],[155,41,155,45],[153,57,153,61],[153,46,153,50],[154,46,154,50],[155,46,155,50],[131,1,133,3],[134,1,136,3],[230,60,230,65],[208,1,224,32],[116,49,116,51],[232,1,248,32],[230,25,230,32],[206,34,206,41],[116,43,116,45],[116,46,116,48],[156,10,156,14],[156,15,156,19],[156,20,156,24],[156,25,156,29],[156,32,156,35],[156,36,156,40],[156,41,156,45],[156,46,156,50],[156,51,156,56],[156,57,156,61],[156,62,156,66],[157,3,157,9],[122,4,124,66],[125,4,127,66],[115,37,115,39],[206,59,206,64],[118,1,118,66],[182,60,182,65],[145,32,145,45],[159,2,180,80],[154,3,154,9],[154,10,154,14],[154,15,154,19],[154,20,154,24],[154,25,154,29],[154,70,154,73],[154,74,154,80],[155,3,155,9],[155,10,155,14],[155,15,155,19],[152,36,152,40],[157,70,157,80],[153,36,153,40],[157,10,157,14],[157,15,157,19],[116,37,116,39],[116,40,116,42],[146,25,146,29],[147,15,147,19],[147,20,147,24],[147,25,147,29],[148,32,148,35],[146,46,146,50],[145,46,145,66],[157,20,157,24],[157,25,157,29],[110,1,110,37],[103,15,103,17],[103,60,103,62],[105,51,105,53],[107,41,107,43],[103,24,103,26],[93,33,93,35],[93,3,93,14],[85,15,85,17],[85,1,85,2],[83,15,83,17],[83,1,83,2],[95,39,95,41],[106,1,106,32],[99,57,99,59],[87,27,87,29],[105,1,105,2],[99,54,99,56],[83,54,83,56],[83,42,83,44],[83,45,83,47],[87,1,87,2],[85,33,85,35],[83,57,83,59],[89,21,89,23],[87,39,87,41],[92,1,92,66],[93,39,93,41],[100,1,100,66],[97,21,97,23],[108,40,108,42],[109,44,109,46],[75,21,75,23],[71,24,71,26],[77,30,77,32],[71,51,71,53],[63,54,63,56],[67,33,67,35],[71,45,71,47],[63,42,63,44],[71,21,71,23],[64,1,64,66],[65,33,65,35],[65,18,65,20],[69,33,69,35],[67,54,67,56],[77,3,77,14],[69,39,69,41],[63,39,63,41],[71,30,71,32],[65,24,65,26],[63,24,63,26],[67,57,67,59],[67,30,67,32],[67,21,67,23],[73,39,73,41],[71,27,71,29],[67,39,67,41],[75,33,75,35],[75,36,75,38],[73,51,73,53],[73,33,73,35],[63,1,63,2],[65,1,65,2],[65,60,65,62],[71,54,71,56],[66,1,66,66],[69,24,69,26],[69,1,69,2],[69,51,69,53],[65,57,65,59],[65,36,65,38],[61,51,61,53],[71,48,71,50],[61,30,61,32],[71,33,71,35],[69,60,69,62],[67,36,67,38],[63,63,63,65],[69,3,69,14],[69,15,69,17],[71,15,71,17],[67,42,67,44],[65,21,65,23],[61,15,61,17],[53,36,53,38],[57,36,57,38],[85,60,85,62],[83,36,83,38],[85,54,85,56],[72,1,72,66],[63,27,63,29],[61,39,61,41],[65,48,65,50],[65,51,65,53],[71,1,71,2],[71,60,71,62],[75,3,75,14],[76,1,76,66],[75,45,75,47],[75,27,75,29],[75,1,75,2],[73,1,73,2],[77,36,77,38],[81,36,81,38],[73,63,73,65],[77,51,77,53],[75,48,75,50],[77,42,77,44],[75,63,75,65],[71,57,71,59],[71,18,71,20],[75,30,75,32],[73,30,73,32],[73,24,73,26],[61,1,61,2],[43,36,43,38],[63,3,63,14],[49,48,49,50],[61,60,61,62],[70,1,70,66],[47,18,47,20],[51,21,51,23],[57,24,57,26],[57,15,57,17],[57,57,57,59],[57,27,57,29],[57,42,57,44],[61,57,61,59],[61,3,61,14],[61,18,61,20],[57,48,57,50],[53,45,53,47],[53,48,53,50],[55,30,55,32],[57,54,57,56],[61,24,61,26],[61,27,61,29],[61,21,61,23],[67,1,67,2],[53,24,53,26],[59,57,59,59],[57,21,57,23],[55,36,55,38],[59,18,59,20],[59,48,59,50],[59,21,59,23],[53,3,53,14],[7,1,7,3],[6,1,6,3],[8,4,8,11],[8,1,8,3],[7,4,7,11],[4,30,4,39],[5,45,5,50],[10,26,10,30],[8,31,8,33],[9,31,9,33],[10,31,10,33],[4,40,4,44],[6,34,6,43],[5,55,5,61],[5,51,5,54],[10,34,10,43],[7,70,7,73],[8,70,8,73],[8,64,8,69],[7,44,7,50],[8,44,8,50],[9,44,9,50],[6,70,6,73],[7,31,7,33],[10,44,10,50],[95,51,95,53],[93,36,93,38],[93,27,93,29],[85,57,85,59],[45,36,45,38],[89,18,89,20],[89,24,89,26],[89,30,89,32],[75,54,75,56],[75,24,75,26],[73,57,73,59],[55,18,55,20],[55,24,55,26],[55,48,55,50],[5,40,5,44],[5,62,5,73],[9,4,9,11],[6,4,6,11],[6,31,6,33],[14,70,14,73],[83,39,83,41],[71,39,71,41],[71,36,71,38],[74,1,74,66],[73,21,73,23],[65,63,65,65],[41,3,41,14],[51,3,51,14]],"merged_total":1324,"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,null,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-11-10"}]
[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":2665},null,null,null,{"$f":"'2020 Chain'!C20","v":"Des Peres FSU"},null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"'2020 Chain'!I20","v":"11997 Manchester Road"},null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"'2020 Chain'!J20","v":"Des Peres"},null,null,null,null,null,null,null,null,null,null,{"$f":"'2020 Chain'!K20","v":"MO"},null,{"$f":"'2020 Chain'!L20","v":"David Bruce"},null,null,null,null,null,null,null,null,null,null,{"$f":"'2020 Chain'!T20","v":"(314) 821-3452"},null,null,null,null,null,null,null,null,{"$f":"'2020 Chain'!U20","v":"02665@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":"Scott Lawhorne"},null,null,null,null,null,null,null,null,{"$f":"'2020 Chain'!P20","v":"Tony Gragg"},null,null,null,null,null,null,null,null,null,null,{"$f":"'2020 Chain'!M20","v":"Micah Dowdy"},null,null,null,null,null,null,null,null,{"$f":"'2020 Chain'!Q20","v":"Patrick Winkler"},null,null,null,null,null,null,null,null,null,{"$f":"'2020 Chain'!F20","v":"S08N SM"},null,null,null,null,{"$f":"'2020 Chain'!S20","v":"2011-02-03"},null,null,null,null,null,{"$f":"(TODAY()-AT6)/365","v":12.101369863013698},null,null,null,{"$f":"'2020 Chain'!E20","v":"2023-07-08"},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":"Chipman"}]
[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'!N20","v":"Matthew Zupancic"}]
[null,"AC1",null,null,{"$f":"'2020 Chain'!V20","v":"5610K13858"},null,null,null,null,null,null,null,{"$f":"'2020 Chain'!W20","v":"LGH180H4BH2Y"},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)=\"240\",\"20\",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":"15"},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'!Y20","v":12.443835616438356},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,null,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)=\"S03A\",\"KITCHEN\",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,7)=\"S08N SM\",\"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'!AA20","v":"5610K14147"},null,null,null,null,null,null,null,{"$f":"'2020 Chain'!AB20","v":"LGH060H4EH1Y"},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":"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'!AD20","v":12.443835616438356},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,null,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(A6,1,4)=\"S03A\",\"SERV/ENT A/\",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 SM\",\"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/ENT 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'!AF20","v":"5610K13975"},null,null,null,null,null,null,null,{"$f":"'2020 Chain'!AG20","v":"LGH150S4BH1Y"},null,null,null,null,null,null,null,null,null,null,"12.5",null,null,"Lennox",null,null,null,null,{"$f":"'2020 Chain'!AI20","v":12.443835616438356},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,null,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)=\"S03A\",\"DIN B/RR\",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 SM\",\"DINB/SERV/DT\",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":"DINB/SERV/DT"},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":537},null,null,null,537]
[null,"AC4",null,null,{"$f":"'2020 Chain'!AK20","v":"5610L00584"},null,null,null,null,null,null,null,{"$f":"'2020 Chain'!AL20","v":"LGH060H4EH1Y"},null,null,null,null,null,null,null,null,null,null,"5",null,null,"Lennox",null,null,null,null,{"$f":"'2020 Chain'!AN20","v":12.358904109589041},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,null,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)=\"S03A\",\"PLAYLAND\",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 SM\",\"PLAYLAND\",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":"PLAYLAND"},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,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"IF(MID(M12,7,2)=\"05\",\"4\",IF(MID(M12,7,2)=\"06\",\"5\",IF(MID(M12,7,2)=\"07\",\"6\",IF(MID(M12,7,2)=\"08\",\"7.5\",IF(MID(M12,7,2)=\"09\",\"8.5\",IF(MID(M12,7,2)=\"12\",\"10\",IF(MID(M12,7,2)=\"14\",\"12.5\",IF(MID(M12,7,2)=\"16\",\"15\",IF(MID(M12,4,3)=\"300\",\"25\",IF(MID(M12,4,3)=\"210\",\"17.5\",IF(MID(M12,4,3)=\"180\",\"15\",IF(MID(M12,4,3)=\"150\",\"12.5\",IF(MID(M12,4,3)=\"120\",\"10\",IF(MID(M12,4,3)=\"102\",\"8.5\",IF(MID(M12,4,3)=\"090\",\"7.5\",IF(MID(M12,4,3)=\"092\",\"7.5\",IF(MID(M12,4,3)=\"072\",\"6\",IF(MID(M12,4,3)=\"060\",\"5\",IF(MID(M12,4,3)=\"036\",\"3\",IF(MID(M12,4,3)=\"048\",\"4\",\"\"))))))))))))))))))))","v":""},null,null,"",null,null,null,null,{"$f":"'2020 Chain'!AS20","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":""},null,null,null,null,null,null,null,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":""},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,{"$f":"IF(MID(M13,7,2)=\"05\",\"4\",IF(MID(M13,7,2)=\"06\",\"5\",IF(MID(M13,7,2)=\"07\",\"6\",IF(MID(M13,7,2)=\"08\",\"7.5\",IF(MID(M13,7,2)=\"09\",\"8.5\",IF(MID(M13,7,2)=\"12\",\"10\",IF(MID(M13,7,2)=\"14\",\"12.5\",IF(MID(M13,7,2)=\"16\",\"15\",IF(MID(M13,4,3)=\"300\",\"25\",IF(MID(M13,4,3)=\"210\",\"17.5\",IF(MID(M13,4,3)=\"180\",\"15\",IF(MID(M13,4,3)=\"150\",\"12.5\",IF(MID(M13,4,3)=\"120\",\"10\",IF(MID(M13,4,3)=\"102\",\"8.5\",IF(MID(M13,4,3)=\"090\",\"7.5\",IF(MID(M13,4,3)=\"092\",\"7.5\",IF(MID(M13,4,3)=\"072\",\"6\",IF(MID(M13,4,3)=\"060\",\"5\",IF(MID(M13,4,3)=\"036\",\"3\",IF(MID(M13,4,3)=\"048\",\"4\",\"\"))))))))))))))))))))","v":""},null,null,{"$f":"IF(ISBLANK(M13),\"\",IF(MID(M13,1,2)=\"LG\",\"Lennox\",\"Carrier\"))","v":""},null,null,null,null,{"$f":"'2020 Chain'!AX20","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":537},null,null,null,537]
[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,{"$f":"'RTU1'!J6","v":"C"},null,null,"AC2",null,null,{"$f":"'RTU2'!J6","v":"C"},null,null,"AC3",null,null,{"$f":"'RTU3'!J6","v":"C"},null,null,"AC4",null,null,{"$f":"'RTU4'!J6","v":"C"},null,null,"AC5",null,null,{"$f":"'RTU5'!J6","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,"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":"'RTU1'!J7","v":"N/A"},null,null,"AC2",null,null,{"$f":"'RTU2'!J7","v":0.1},null,null,"AC3",null,null,{"$f":"'RTU3'!J7","v":0.06},null,null,"AC4",null,null,{"$f":"'RTU4'!J7","v":"C"},null,null,"AC5",null,null,{"$f":"'RTU5'!J7","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,"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":"CRITICAL"},null,null,null,null,null,null,null,null,null,null,null,null,null,null,"AC1",null,null,{"$f":"'RTU1'!J8","v":"N/A"},null,null,"AC2",null,null,{"$f":"'RTU2'!J8","v":"C"},null,null,"AC3",null,null,{"$f":"'RTU3'!J8","v":"C"},null,null,"AC4",null,null,{"$f":"'RTU4'!J8","v":"C"},null,null,"AC5",null,null,{"$f":"'RTU5'!J8","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,"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":"'RTU1'!J9","v":"N/A"},null,null,"AC2",null,null,{"$f":"'RTU2'!J9","v":"C"},null,null,"AC3",null,null,{"$f":"'RTU3'!J9","v":"C"},null,null,"AC4",null,null,{"$f":"'RTU4'!J9","v":"C"},null,null,"AC5",null,null,{"$f":"'RTU5'!J9","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,"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":"'RTU1'!J10","v":"N/A"},null,null,"AC2",null,null,{"$f":"'RTU2'!J10","v":"N/A"},null,null,"AC3",null,null,{"$f":"'RTU3'!J10","v":12.5},null,null,"AC4",null,null,{"$f":"'RTU4'!J10","v":"N/A"},null,null,"AC5",null,null,{"$f":"'RTU5'!J10","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":"'RTU1'!J11","v":"N/A"},null,null,"AC2",null,null,{"$f":"'RTU2'!J11","v":"C"},null,null,"AC3",null,null,{"$f":"'RTU3'!J11","v":"C"},null,null,"AC4",null,null,{"$f":"'RTU4'!J11","v":"C"},null,null,"AC5",null,null,{"$f":"'RTU5'!J11","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,"7.  Is unit a humiditrol type unit?"]
[null,null,null,"NON CRITICAL",null,null,null,null,null,null,null,null,null,null,null,null,null,null,"AC1",null,null,{"$f":"'RTU1'!J12","v":"Yes"},null,null,"AC2",null,null,{"$f":"'RTU2'!J12","v":"Yes"},null,null,"AC3",null,null,{"$f":"'RTU3'!J12","v":"Yes"},null,null,"AC4",null,null,{"$f":"'RTU4'!J12","v":"C"},null,null,"AC5",null,null,{"$f":"'RTU5'!J12","v":0},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":"'RTU1'!J13","v":"C"},null,null,"AC2",null,null,{"$f":"IF(ISBLANK($E$9),\"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\",IF(MID(AB32,1,2)=\"NO\",\"N/A\",\"\"))))))","v":""},null,null,"AC3",null,null,{"$f":"'RTU3'!J13","v":"C"},null,null,"AC4",null,null,{"$f":"'RTU4'!J13","v":"C"},null,null,"AC5",null,null,{"$f":"'RTU5'!J13","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":"'RTU1'!J14","v":"1-1/2\""},null,null,"B2",null,null,{"$f":"P150","v":"1-1/2\""},null,null,"B3",null,null,{"$f":"P151","v":0},null,null,"B4",null,null,{"$f":"P152","v":"1-1/4\""},null,null,"B5",null,null,{"$f":"P153","v":"1\""},null,null,"B6",null,null,{"$f":"P154","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":"'RTU1'!J15","v":0},null,null,"D2",null,null,{"$f":"AZ150","v":"3/4\""},null,null,"D3",null,null,{"$f":"AZ151","v":"3/4\""},null,null,"D4",null,null,{"$f":"AZ152","v":"3/4\""},null,null,"D5",null,null,{"$f":"AZ153","v":"3/4\""},null,null,"D6",null,null,{"$f":"AZ154","v":"3/4\""},null,null,"D7",null,null,{"$f":"AZ155","v":0},null,null,"D8"]
[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,{"$f":"'RTU1'!J16","v":"1-1/4\""},null,null,"AC2",null,null,{"$f":"'RTU2'!J16","v":"3/4\""},null,null,"AC3",null,null,{"$f":"'RTU3'!J16","v":1},null,null,"AC4",null,null,{"$f":"'RTU4'!J16","v":"3/4\""},null,null,"AC5",null,null,{"$f":"'RTU5'!J16","v":0},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,{"$f":"'RTU1'!J17","v":"C"},null,null,"AC2",null,null,{"$f":"'RTU2'!J17","v":"C"},null,null,"AC3",null,null,{"$f":"'RTU3'!J17","v":"C"},null,null,"AC4",null,null,{"$f":"'RTU4'!J17","v":"C"},null,null,"AC5",null,null,{"$f":"'RTU5'!J17","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,"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,{"$f":"'RTU1'!J18","v":"C"},null,null,"AC2",null,null,{"$f":"'RTU2'!J18","v":"C"},null,null,"AC3",null,null,{"$f":"'RTU3'!J18","v":"C"},null,null,"AC4",null,null,{"$f":"'RTU4'!J18","v":"C"},null,null,"AC5",null,null,{"$f":"'RTU5'!J18","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,"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,{"$f":"'RTU1'!J19","v":"C"},null,null,"AC2",null,null,{"$f":"'RTU2'!J19","v":"C"},null,null,"AC3",null,null,{"$f":"'RTU3'!J19","v":"C"},null,null,"AC4",null,null,{"$f":"'RTU4'!J19","v":"C"},null,null,"AC5",null,null,{"$f":"'RTU5'!J19","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,"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,{"$f":"'RTU1'!J20","v":"C"},null,null,"AC2",null,null,{"$f":"'RTU2'!J20","v":"C"},null,null,"AC3",null,null,{"$f":"'RTU3'!J20","v":"C"},null,null,"AC4",null,null,{"$f":"'RTU4'!J20","v":"C"},null,null,"AC5",null,null,{"$f":"'RTU5'!J20","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,"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":"'RTU1'!J21","v":"N/A"},null,null,"AC2",null,null,{"$f":"'RTU2'!J21","v":"N/A"},null,null,"AC3",null,null,{"$f":"'RTU3'!J21","v":"N/A"},null,null,"AC4",null,null,{"$f":"'RTU4'!J21","v":"N/A"},null,null,"AC5",null,null,{"$f":"'RTU5'!J21","v":"N/A"},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":"'RTU1'!J22","v":"N/A"},null,null,"AC2",null,null,{"$f":"'RTU2'!J22","v":"N/A"},null,null,"AC3",null,null,{"$f":"'RTU3'!J22","v":"N/A"},null,null,"AC4",null,null,{"$f":"'RTU4'!J22","v":"N/A"},null,null,"AC5",null,null,{"$f":"'RTU5'!J22","v":"N/A"},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,"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":"'RTU1'!J23","v":"N/A"},null,null,"AC2",null,null,{"$f":"'RTU2'!J23","v":"DD"},null,null,"AC3",null,null,{"$f":"'RTU3'!J23","v":"C"},null,null,"AC4",null,null,{"$f":"'RTU4'!J23","v":"N/A"},null,null,"AC5",null,null,{"$f":"'RTU5'!J23","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,"19. 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":"'RTU1'!J24","v":"N/A"},null,null,"AC2",null,null,{"$f":"'RTU2'!J24","v":"N/A"},null,null,"AC3",null,null,{"$f":"'RTU3'!J24","v":12.5},null,null,"AC4",null,null,{"$f":"'RTU4'!J24","v":"N/A"},null,null,"AC5",null,null,{"$f":"'RTU5'!J24","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. 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":"'RTU1'!J25","v":"N/A"},null,null,"AC2",null,null,{"$f":"'RTU2'!J25","v":"N/A"},null,null,"AC3",null,null,{"$f":"'RTU3'!J25","v":"BX57"},null,null,"AC4",null,null,{"$f":"'RTU4'!J25","v":"N/A"},null,null,"AC5",null,null,{"$f":"'RTU5'!J25","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.  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":"'RTU1'!J26","v":"N/A"},null,null,"AC2",null,null,{"$f":"'RTU2'!J26","v":"C"},null,null,"AC3",null,null,{"$f":"'RTU3'!J26","v":"C"},null,null,"AC4",null,null,{"$f":"'RTU4'!J26","v":"C"},null,null,"AC5",null,null,{"$f":"'RTU5'!J26","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.  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":"'RTU1'!J27","v":"N/A"},null,null,"AC2",null,null,{"$f":"'RTU2'!J27","v":5},null,null,"AC3",null,null,{"$f":"'RTU3'!J27","v":12.5},null,null,"AC4",null,null,{"$f":"'RTU4'!J27","v":5},null,null,"AC5",null,null,{"$f":"'RTU5'!J27","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,"23.  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":"'RTU1'!J28","v":"N/A"},null,null,"AC2",null,null,{"$f":"'RTU2'!J28","v":5},null,null,"AC3",null,null,{"$f":"'RTU3'!J28","v":12.5},null,null,"AC4",null,null,{"$f":"'RTU4'!J28","v":"C"},null,null,"AC5",null,null,{"$f":"'RTU5'!J28","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,"24.  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":"'RTU1'!J29","v":"N/A"},null,null,"AC2",null,null,{"$f":"'RTU2'!J29","v":"N/A"},null,null,"AC3",null,null,{"$f":"'RTU3'!J29","v":"C"},null,null,"AC4",null,null,{"$f":"'RTU4'!J29","v":"N/A"},null,null,"AC5",null,null,{"$f":"'RTU5'!J29","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,"25.  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":"'RTU1'!J30","v":"N/A"},null,null,"AC2",null,null,{"$f":"'RTU2'!J30","v":"C"},null,null,"AC3",null,null,{"$f":"'RTU3'!J30","v":"C"},null,null,"AC4",null,null,{"$f":"'RTU4'!J30","v":"C"},null,null,"AC5",null,null,{"$f":"'RTU5'!J30","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,"26. 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":"'RTU1'!J31","v":"N/A"},null,null,"AC2",null,null,{"$f":"'RTU2'!J31","v":"C"},null,null,"AC3",null,null,{"$f":"'RTU3'!J31","v":"C"},null,null,"AC4",null,null,{"$f":"'RTU4'!J31","v":"C"},null,null,"AC5",null,null,{"$f":"'RTU5'!J31","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,"27. 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":"'RTU1'!J32","v":"N/A"},null,null,"AC2",null,null,{"$f":"'RTU2'!J32","v":5},null,null,"AC3",null,null,{"$f":"'RTU3'!J32","v":12.5},null,null,"AC4",null,null,{"$f":"'RTU4'!J32","v":5},null,null,"AC5",null,null,{"$f":"'RTU5'!J32","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,"28. 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":"'RTU1'!J33","v":"N/A"},null,null,"AC2",null,null,{"$f":"'RTU2'!J33","v":"C"},null,null,"AC3",null,null,{"$f":"'RTU3'!J33","v":"C"},null,null,"AC4",null,null,{"$f":"IF(ISBLANK($E$11),\"N/A\",\"\")","v":""},null,null,"AC5",null,null,{"$f":"'RTU5'!J33","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,"29. 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":"'RTU1'!J34","v":"N/A"},null,null,"AC2",null,null,{"$f":"'RTU2'!J34","v":"C"},null,null,"AC3",null,null,{"$f":"'RTU3'!J34","v":"C"},null,null,"AC4",null,null,{"$f":"'RTU4'!J34","v":"C"},null,null,"AC5",null,null,{"$f":"'RTU5'!J34","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,"30.  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":"'RTU1'!J35","v":"N/A"},null,null,"AC2",null,null,{"$f":"'RTU2'!J35","v":5},null,null,"AC3",null,null,{"$f":"'RTU3'!J35","v":12.5},null,null,"AC4",null,null,{"$f":"'RTU4'!J35","v":5},null,null,"AC5",null,null,{"$f":"'RTU5'!J35","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,"31.  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":"'RTU1'!J36","v":"N/A"},null,null,"AC2",null,null,{"$f":"'RTU2'!J36","v":5},null,null,"AC3",null,null,{"$f":"'RTU3'!J36","v":12.5},null,null,"AC4",null,null,{"$f":"'RTU4'!J36","v":5},null,null,"AC5",null,null,{"$f":"'RTU5'!J36","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,"32.  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":"'RTU1'!J37","v":"N/A"},null,null,"AC2",null,null,{"$f":"'RTU2'!J37","v":"C"},null,null,"AC3",null,null,{"$f":"'RTU3'!J37","v":"C"},null,null,"AC4",null,null,{"$f":"'RTU4'!J37","v":"C"},null,null,"AC5",null,null,{"$f":"'RTU5'!J37","v":"N/A"},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,"33.  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":"'RTU1'!J38","v":"N/A"},null,null,"AC2",null,null,{"$f":"'RTU2'!J38","v":"R"},null,null,"AC3",null,null,{"$f":"'RTU3'!J38","v":"R"},null,null,"AC4",null,null,{"$f":"'RTU4'!J38","v":"R"},null,null,"AC5",null,null,{"$f":"'RTU5'!J38","v":"N/A"},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,"34.  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":"'RTU1'!J39","v":"N/A"},null,null,"AC2",null,null,{"$f":"'RTU2'!J39","v":"C"},null,null,"AC3",null,null,{"$f":"'RTU3'!J39","v":"C"},null,null,"AC4",null,null,{"$f":"'RTU4'!J39","v":"C"},null,null,"AC5",null,null,{"$f":"'RTU5'!J39","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,"35.  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":"'RTU1'!J40","v":"N/A"},null,null,"AC2",null,null,{"$f":"'RTU2'!J40","v":"C"},null,null,"AC3",null,null,{"$f":"'RTU3'!J40","v":"C"},null,null,"AC4",null,null,{"$f":"'RTU4'!J35","v":5},null,null,"AC5",null,null,{"$f":"'RTU5'!J40","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,"36.  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":"'RTU1'!J41","v":"N/A"},null,null,"AC2",null,null,{"$f":"'RTU2'!J41","v":"C"},null,null,"AC3",null,null,{"$f":"'RTU3'!J41","v":"C"},null,null,"AC4",null,null,{"$f":"'RTU4'!J41","v":"C"},null,null,"AC5",null,null,{"$f":"'RTU5'!J41","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,"37.  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":"'RTU1'!J42","v":"N/A"},null,null,"AC2",null,null,{"$f":"'RTU2'!J42","v":"C"},null,null,"AC3",null,null,{"$f":"'RTU3'!J42","v":12.5},null,null,"AC4",null,null,{"$f":"'RTU4'!J42","v":"C"},null,null,"AC5",null,null,{"$f":"'RTU5'!J42","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,"38.  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,{"$f":"'RTU1'!J43","v":"C"},null,null,"AC2",null,null,{"$f":"'RTU2'!J43","v":"C"},null,null,"AC3",null,null,{"$f":"IF(ISBLANK($E$10),\"N/A\",\"\")","v":""},null,null,"AC4",null,null,{"$f":"'RTU4'!J43","v":"C"},null,null,"AC5",null,null,{"$f":"'RTU5'!J43","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,"39.  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,{"$f":"'RTU1'!J44","v":"C"},null,null,"AC2",null,null,{"$f":"'RTU2'!J44","v":"C"},null,null,"AC3",null,null,{"$f":"'RTU3'!J44","v":"C"},null,null,"AC4",null,null,{"$f":"'RTU4'!J44","v":"C"},null,null,"AC5",null,null,{"$f":"'RTU5'!J44","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,"40.  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,{"$f":"'RTU1'!J45","v":1.25},null,null,"AC2",null,null,{"$f":"'RTU2'!J45","v":1},null,null,"AC3",null,null,{"$f":"'RTU3'!J45","v":1.25},null,null,"AC4",null,null,{"$f":"'RTU4'!J45","v":1},null,null,"AC5",null,null,{"$f":"'RTU5'!J45","v":0},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,"41.  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,{"$f":"'RTU1'!J46","v":15},null,null,"AC2",null,null,{"$f":"'RTU2'!J46","v":5},null,null,"AC3",null,null,{"$f":"'RTU3'!J46","v":12.5},null,null,"AC4",null,null,{"$f":"'RTU4'!J46","v":5},null,null,"AC5",null,null,{"$f":"'RTU5'!J46","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,"42.  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,{"$f":"'RTU1'!J47","v":15},null,null,"AC2",null,null,{"$f":"'RTU2'!J47","v":"C"},null,null,"AC3",null,null,{"$f":"'RTU3'!J47","v":"C"},null,null,"AC4",null,null,{"$f":"'RTU4'!J47","v":"C"},null,null,"AC5",null,null,{"$f":"'RTU5'!J47","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,"43.  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,{"$f":"'RTU1'!J48","v":15},null,null,"AC2",null,null,{"$f":"'RTU2'!J48","v":"C"},null,null,"AC3",null,null,{"$f":"'RTU3'!J48","v":"C"},null,null,"AC4",null,null,{"$f":"'RTU4'!J48","v":"C"},null,null,"AC5",null,null,{"$f":"'RTU5'!J48","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,"44.  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,{"$f":"'RTU1'!J49","v":15},null,null,"AC2",null,null,{"$f":"'RTU2'!J49","v":5},null,null,"AC3",null,null,{"$f":"'RTU3'!J49","v":12.5},null,null,"AC4",null,null,{"$f":"'RTU4'!J49","v":5},null,null,"AC5",null,null,{"$f":"'RTU5'!J49","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,"45.  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,{"$f":"'BR EF'!J5","v":"NO"}]
[null,"46.  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,{"$f":"'BR EF'!J6","v":"NO"}]
[null,"47.  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,{"$f":"'BR EF'!J7","v":"NO"}]
[null,"48.  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,{"$f":"'BR EF'!J8","v":"YES"}]
[null,"49.  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,{"$f":"'BR EF'!J9","v":"Yes"}]
[null,"50.  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,{"$f":"'BR EF'!J10","v":"DIRTY"}]
[null,"51.  Record model 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,"Model #",null,null,null,null,null,null,null,{"$f":"'BR EF'!J11","v":"CHICK-FIL-A CONTROL PANEL"}]
[null,"52.  Record 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,"Serial #",null,null,null,null,null,null,null,{"$f":"'BR EF'!J12","v":"10-CFA-064"}]
[null,"53.  Is there a HES control panel visible?  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,{"$f":"'BR EF'!J13","v":"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,{"$f":"'BR EF'!C15","v":"RS"},null,null,"AC2",null,null,{"$f":"'BR EF'!E15","v":"RS"},null,null,"AC3",null,null,{"$f":"'BR EF'!G15","v":"RS"},null,null,"AC4",null,null,{"$f":"'BR EF'!I15","v":"RS"},null,null,"AC5",null,null,{"$f":"'BR EF'!K15","v":0}]
[null,null,null,null,null,null,null,null,null,null,null,null,null,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,{"$f":"'BR EF'!C16","v":0},null,null,"AC7",null,null,{"$f":"'BR EF'!E16","v":0},null,null,"AC8",null,null,{"$f":"'BR EF'!G16","v":0}]
[]
[null,"MISCELLANEOUS NOTES"]
[null,"RTU 1",null,null,{"$f":"'RTU1'!B51","v":0}]
[]
[]
[null,"RTU 2",null,null,{"$f":"'RTU2'!B51","v":0}]
[]
[]
[null,"RTU 3",null,null,{"$f":"'RTU3'!B51","v":0}]
[]
[]
[null,"RTU 4",null,null,{"$f":"'RTU4'!B51","v":0}]
[]
[]
[null,"RTU 5",null,null,{"$f":"'RTU5'!B51","v":0}]
[]
[]
[null,"RTU 6",null,null,{"$f":"'RTU6'!B51","v":0}]
[]
[]
[null,"MISC NOTES",null,null,{"$f":"'BR EF'!B18","v":0}]
[]
[]
[]
[]
[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,11.25,null,null,null,null,"1-1/2\"",null,null,null,null,"2-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,"3/4\"",null,null,null,"1\""]
[null,null,null,"B1 to B2",null,null,null,null,null,null,2.25,null,null,null,null,"1-1/2\"",null,null,null,null,"1\"",null,null,null,null,null,null,null,null,null,null,null,"D1",null,null,null,"B2 to",null,null,null,null,"RTU 1",null,null,null,null,4.5,null,null,null,null,"3/4\"",null,null,null,null,null,"1-1/2\"",null,null,null,null,null,null,null,null,null,null,null,null,"1\"",null,null,null,"1-5/16\""]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,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,16,null,null,null,null,"3/4\"",null,null,null,null,null,"1\"",null,null,null,null,null,null,null,null,null,null,null,null,"1-1/4\"",null,null,null,"1-5/8\""]
[null,null,null,"B1 to B3",null,null,null,null,null,null,22.5,null,null,null,null,"1-1/4\"",null,null,null,null,"2-1/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,19.5,null,null,null,null,"3/4\"",null,null,null,null,null,"1\"",null,null,null,null,null,null,null,null,null,null,null,null,"1-1/2\"",null,null,null,"1-7/8\""]
[null,null,null,"B3 to B4",null,null,null,null,null,null,32.5,null,null,null,null,"1\"",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,7.6,null,null,null,null,"3/4\"",null,null,null,null,null,"1-1/4\"",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,"D5",null,null,null,"B4 to",null,null,null,null,"RTU 4",null,null,null,null,29.1,null,null,null,null,"3/4\"",null,null,null,null,null,"1\"",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,"AC-1 PREFILTERS DAMAGED/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,"AC-1,2,3,4 DUCTWORK DIRTY"]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[null,"AC-2,3,4 BlOWER 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,"AC-3 NO POWER EXHAUST"]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[null,"AC-3 PULLEY FROZEN",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"AC-1,2,3,4 CONDENSATE DRAINS DO NOT MEET SPEC"]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[null,"AC-2,3,4 TURNING VANES DOUBLE THICKNESS, RADIUS INCORRECT",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"AC TEMP SENSOR WIRING DOES NOT MEET SPEC"]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[null,"RR FAN 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,"RR FAN NOT OPERATING"]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[null,"ROOF VIEW/LAYOUT",null,null,null,null,null,null,null,null,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":"RTU1","index":1,"n_rows":50,"n_cols":13,"rows_kept":50,"cut":false,"hidden":false,"merged":[[0,1,0,4],[1,1,1,4],[2,1,2,4],[3,1,3,4],[48,1,48,8],[46,1,46,8],[47,1,47,8],[44,1,44,8],[45,1,45,8],[42,1,42,8],[43,1,43,8],[40,1,40,8],[41,1,41,8],[38,1,38,8],[39,1,39,8],[36,1,36,8],[2,5,2,9],[32,1,32,8],[33,1,33,8],[6,1,6,8],[7,1,7,8],[20,1,20,8],[21,1,21,8],[16,1,16,8],[17,1,17,8],[18,1,18,8],[19,1,19,8],[30,1,30,8],[31,1,31,8],[28,1,28,8],[29,1,29,8],[26,1,26,8],[4,1,4,3],[24,1,24,8],[25,1,25,8],[22,1,22,8],[49,1,49,9],[27,1,27,8],[37,1,37,8],[34,1,34,8],[35,1,35,8],[50,1,55,9],[1,5,1,9],[0,5,0,9],[3,5,3,9],[23,1,23,8],[5,1,5,8],[14,1,14,8],[15,1,15,8],[8,1,8,8],[9,1,9,8],[10,1,10,8],[11,1,11,8],[12,1,12,8],[13,1,13,8],[4,7,4,8],[4,4,4,5]]}
[null,"RTU UNIT MANUFACTURER",null,null,null,{"$f":"Survey!AA8","v":"Lennox"}]
[null,"RTU TYPE",null,null,null,{"$f":"Survey!AI8","v":"ENERGENCE"}]
[null,"MODEL NUMBER",null,null,null,{"$f":"Survey!M8","v":"LGH180H4BH2Y"}]
[null,"SERIAL NUMBER",null,null,null,{"$f":"Survey!E8","v":"5610K13858"}]
[null,null,null,null,"RTU AGE",null,{"$f":"Survey!AF8","v":12.443835616438356},"RTU TONNAGE",null,{"$f":"Survey!X8","v":"15"}]
[null,{"$f":"Survey!B19","v":"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,null,null,null,null,"C",null,null,{"$f":"SUM(Survey!CE18:CE21)","v":0}]
[null,{"$f":"Survey!B21","v":"2.  Quantify damage/deterioration to the condenser coil (0% to 100%).  If greater than 50% enter unit tonnage."},null,null,null,null,null,null,null,{"$f":"IF(ISBLANK(Survey!$E$8),\"N/A\",IF(MID(Survey!$M$8,7,2)<\"14\",\"\",IF(MID(Survey!$M$8,7,2)=\"14\",\"N/A\",IF(MID(Survey!$M$8,7,2)=\"16\",\"N/A\",IF(MID(Survey!$M$8,4,3)>\"149\",\"N/A\",\"\")))))","v":"N/A"}]
[null,{"$f":"Survey!B23","v":"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,null,null,null,null,{"$f":"IF(ISBLANK(Survey!$E$8),\"N/A\",IF(MID(Survey!$M$8,7,2)=\"14\",\"N/A\",IF(MID(Survey!$M$8,7,2)=\"16\",\"N/A\",IF(MID(Survey!$M$8,7,2)<\"14\",\"\",IF(MID(Survey!$M$8,4,3)>\"149\",\"N/A\",\"\")))))","v":"N/A"}]
[null,{"$f":"Survey!B25","v":"4.  Check both sides of evaporator coil for deterioration.  Perform fin test. If greater than 50% enter unit tonnage"},null,null,null,null,null,null,null,{"$f":"IF(ISBLANK(Survey!$E$8),\"N/A\",IF(MID(Survey!$M$8,7,2)=\"14\",\"N/A\",IF(MID(Survey!$M$8,7,2)=\"16\",\"N/A\",IF(MID(Survey!$M$8,7,2)<\"14\",\"\",IF(MID(Survey!$M$8,4,3)>\"149\",\"N/A\",\"\")))))","v":"N/A"}]
[null,{"$f":"Survey!B27","v":"5.  Check for power exhaust at AC units greater than ten tons.  If no power exhaust enter unit tonnage."},null,null,null,null,null,null,null,{"$f":"IF(ISBLANK(Survey!$E$8),\"N/A\",IF(MID(Survey!$M$8,4,3)<=\"120\",\"N/A\",IF(MID(Survey!$M$8,7,2)=\"14\",\"N/A\",IF(MID(Survey!$M$8,7,2)=\"16\",\"N/A\",IF(MID(Survey!$M$8,7,2)<\"14\",\"\",IF(MID(Survey!$M$8,4,3)>\"149\",\"N/A\",\"\"))))))","v":"N/A"}]
[null,{"$f":"Survey!B29","v":"6.  Are there curb adaptors on any of the units?  If YES, enter unit tonnage."},null,null,null,null,null,null,null,{"$f":"IF(ISBLANK(Survey!$E$8),\"N/A\",IF(MID(Survey!$M$8,7,2)=\"14\",\"N/A\",IF(MID(Survey!$M$8,7,2)=\"16\",\"N/A\",IF(MID(Survey!$M$8,7,2)<\"14\",\"\",IF(MID(Survey!$M$8,4,3)>\"149\",\"N/A\",\"\")))))","v":"N/A"}]
[null,{"$f":"Survey!B31","v":"7.  Is unit a humiditrol type unit?"},null,null,null,null,null,null,null,"Yes"]
[null,{"$f":"Survey!B33","v":"8.  Is the humidity sensor wired?  If NO,  enter unit tonnage."},null,null,null,null,null,null,null,"C"]
[null,{"$f":"Survey!B35","v":"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,null,null,null,null,{"$f":"Survey!P149","v":"1-1/2\""}]
[null,{"$f":"Survey!B37","v":"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,null,null,null,null,{"$f":"Survey!AZ149","v":0}]
[null,{"$f":"Survey!B39","v":"11.  Record size of gas line going into unit.  NOTE: Pull down menu in cells."},null,null,null,null,null,null,null,"1-1/4\""]
[null,{"$f":"Survey!B41","v":"12.  Is a smoke detector present in unit?  If NO, enter unit tonnage."},null,null,null,null,null,null,null,"C"]
[null,{"$f":"Survey!B43","v":"13.  Is the smoke detector inlet sampling tube capped?  If NO, enter unit tonnage."},null,null,null,null,null,null,null,"C"]
[null,{"$f":"Survey!B45","v":"14.  Check smoke detector module light. If light RED or an AMBER color, enter unit tonnage."},null,null,null,null,null,null,null,"C"]
[null,{"$f":"Survey!B47","v":"15.  Is smoke detector dust plugs capped?  If YES, enter unit tonnage."},null,null,null,null,null,null,null,"C"]
[null,{"$f":"Survey!B49","v":"16.  Is hub (hub houses bearings and located at center of pulley) at the tensioner intact?  If NO, enter unit tonnage."},null,null,null,null,null,null,null,{"$f":"IF(ISBLANK(Survey!$E$8),\"N/A\",IF(LEN(Survey!$M$8)>15,\"N/A\",IF(MID(Survey!$E$8,3,2)<\"17\",\"N/A\",IF(MID(Survey!$M$8,7,2)=\"14\",\"N/A\",IF(MID(Survey!$M$8,7,2)=\"16\",\"N/A\",IF(MID(Survey!$M$8,4,3)>\"149\",\"N/A\",IF(MID(Survey!$M$8,9,1)=\"E\",\"N/A\",\"\")))))))","v":"N/A"}]
[null,{"$f":"Survey!B51","v":"17. Is belt tensioner installed?  If NO, enter unit tonnage."},null,null,null,null,null,null,null,{"$f":"IF(ISBLANK(Survey!$E$8),\"N/A\",IF(LEN(Survey!$M$8)>15,\"N/A\",IF(VALUE(MID(Survey!$E$8,3,2))<17,\"N/A\",IF(MID(Survey!$M$8,7,2)=\"14\",\"N/A\",IF(MID(Survey!$M$8,7,2)=\"16\",\"N/A\",IF(MID(Survey!$M$8,4,3)>\"149\",\"N/A\",IF(MID(Survey!$M$8,9,1)=\"E\",\"N/A\",\"\")))))))","v":"N/A"}]
[null,{"$f":"Survey!B53","v":"18. Look for damage/indentions at pulleys?  If damage found, enter unit tonnage."},null,null,null,null,null,null,null,{"$f":"IF(ISBLANK(Survey!$E$8),\"N/A\",IF(MID(Survey!$M$8,7,2)<\"14\",\"\",IF(MID(Survey!$M$8,7,2)=\"14\",\"N/A\",IF(MID(Survey!$M$8,7,2)=\"16\",\"N/A\",IF(MID(Survey!$M$8,4,3)>\"149\",\"N/A\",IF(MID(Survey!$M$8,9,1)=\"E\",\"N/A\",\"\"))))))","v":"N/A"}]
[null,{"$f":"Survey!B55","v":"19. Check motor sheave to assure it can be adjusted.  If cannot be adJusted, enter unit tonnage, & part #'S in misc notes."},null,null,null,null,null,null,null,{"$f":"IF(ISBLANK(Survey!$E$8),\"N/A\",IF(MID(Survey!$M$8,7,2)<\"14\",\"\",IF(MID(Survey!$M$8,7,2)=\"14\",\"N/A\",IF(MID(Survey!$M$8,7,2)=\"16\",\"N/A\",IF(MID(Survey!$M$8,4,3)>\"149\",\"N/A\",IF(MID(Survey!$M$8,9,1)=\"E\",\"N/A\",\"\"))))))","v":"N/A"}]
[null,{"$f":"Survey!B57","v":"20. Record belt size."},null,null,null,null,null,null,null,{"$f":"IF(ISBLANK(Survey!$E$8),\"N/A\",IF(MID(Survey!$M$8,7,2)<\"14\",\"\",IF(MID(Survey!$M$8,7,2)=\"14\",\"N/A\",IF(MID(Survey!$M$8,7,2)=\"16\",\"N/A\",IF(MID(Survey!$M$8,4,3)>\"149\",\"N/A\",IF(MID(Survey!$M$8,9,1)=\"E\",\"N/A\",\"\"))))))","v":"N/A"}]
[null,{"$f":"Survey!B59","v":"21.  Identify any damage to the blower.  If DAMAGE found, enter unit tonnage."},null,null,null,null,null,null,null,{"$f":"IF(ISBLANK(Survey!$E$8),\"N/A\",IF(MID(Survey!$M$8,7,2)=\"14\",\"N/A\",IF(MID(Survey!$M$8,7,2)=\"16\",\"N/A\",IF(MID(Survey!$M$8,7,2)<\"14\",\"\",IF(MID(Survey!$M$8,4,3)>\"149\",\"N/A\",\"\")))))","v":"N/A"}]
[null,{"$f":"Survey!B61","v":"22.  Quantify cleanliness of blower.  If dirty, enter unit tonnage."},null,null,null,null,null,null,null,{"$f":"IF(ISBLANK(Survey!$E$8),\"N/A\",IF(MID(Survey!$M$8,7,2)<\"14\",\"\",IF(MID(Survey!$M$8,7,2)=\"14\",\"N/A\",IF(MID(Survey!$M$8,7,2)=\"16\",\"N/A\",IF(MID(Survey!$M$8,4,3)>\"149\",\"N/A\",\"\")))))","v":"N/A"}]
[null,{"$f":"Survey!B63","v":"23.  At blower motor start up is there a concernng amount of noise or vibration?  If so, enter unit tonnage."},null,null,null,null,null,null,null,{"$f":"IF(ISBLANK(Survey!$E$8),\"N/A\",IF(MID(Survey!$M$8,7,2)<\"14\",\"\",IF(MID(Survey!$M$8,7,2)=\"14\",\"N/A\",IF(MID(Survey!$M$8,7,2)=\"16\",\"N/A\",IF(MID(Survey!$M$8,4,3)>\"149\",\"N/A\",\"\")))))","v":"N/A"}]
[null,{"$f":"Survey!B65","v":"24.  Is blank plate secured on B-cabinets?  If NO, enter unit tonnage."},null,null,null,null,null,null,null,{"$f":"IF(ISBLANK(Survey!$E$8),\"N/A\",IF(LEN(Survey!$M$8)>15,\"N/A\",IF(MID(Survey!$M$8,4,3)<=\"072\",\"N/A\",IF(MID(Survey!$M$8,4,3)>=\"180\",\"N/A\",IF(MID(Survey!$M$8,7,2)=\"14\",\"N/A\",IF(MID(Survey!$M$8,7,2)=\"16\",\"N/A\",IF(MID(Survey!$M$8,4,3)>\"149\",\"N/A\",\"\")))))))","v":"N/A"}]
[null,{"$f":"Survey!B67","v":"25.  Is ductwork lined?  If  YES, enter unit tonnage."},null,null,null,null,null,null,null,{"$f":"IF(ISBLANK(Survey!$E$8),\"N/A\",IF(MID(Survey!$M$8,7,2)<\"14\",\"\",IF(MID(Survey!$M$8,7,2)=\"14\",\"N/A\",IF(MID(Survey!$M$8,7,2)=\"16\",\"N/A\",IF(MID(Survey!$M$8,4,3)>\"149\",\"N/A\",\"\")))))","v":"N/A"}]
[null,{"$f":"Survey!B69","v":"26. Are turning vanes present in the supply ducts of the units?  IF NO, insert unit tonnage."},null,null,null,null,null,null,null,{"$f":"IF(ISBLANK(Survey!$E$8),\"N/A\",IF(MID(Survey!$M$8,7,2)<\"14\",\"\",IF(MID(Survey!$M$8,7,2)=\"14\",\"N/A\",IF(MID(Survey!$M$8,7,2)=\"16\",\"N/A\",IF(MID(Survey!$M$8,4,3)>\"149\",\"N/A\",\"\")))))","v":"N/A"}]
[null,{"$f":"Survey!B71","v":"27. Are turning vanes single or double thickness?  If DOUBLE, enter unit tonnage."},null,null,null,null,null,null,null,{"$f":"IF(ISBLANK(Survey!$E$8),\"N/A\",IF(MID(Survey!$M$8,7,2)<\"14\",\"\",IF(MID(Survey!$M$8,7,2)=\"14\",\"N/A\",IF(MID(Survey!$M$8,7,2)=\"16\",\"N/A\",IF(MID(Survey!$M$8,4,3)>\"149\",\"N/A\",\"\")))))","v":"N/A"}]
[null,{"$f":"Survey!B73","v":"28. Is duct work seated and aligned?  If NO, enter unit tonnage."},null,null,null,null,null,null,null,{"$f":"IF(ISBLANK(Survey!$E$8),\"N/A\",IF(MID(Survey!$M$8,7,2)<\"14\",\"\",IF(MID(Survey!$M$8,7,2)=\"14\",\"N/A\",IF(MID(Survey!$M$8,7,2)=\"16\",\"N/A\",IF(MID(Survey!$M$8,4,3)>\"149\",\"N/A\",\"\")))))","v":"N/A"}]
[null,{"$f":"Survey!B75","v":"29. Is canvas connector present?  If NO, enter unit tonnage."},null,null,null,null,null,null,null,{"$f":"IF(ISBLANK(Survey!$E$8),\"N/A\",IF(MID(Survey!$M$8,7,2)<\"14\",\"\",IF(MID(Survey!$M$8,7,2)=\"14\",\"N/A\",IF(MID(Survey!$M$8,7,2)=\"16\",\"N/A\",IF(MID(Survey!$M$8,4,3)>\"149\",\"N/A\",\"\")))))","v":"N/A"}]
[null,{"$f":"Survey!B77","v":"30.  Quantify cleanliness of duct.  If dirty, enter unit tonnage."},null,null,null,null,null,null,null,{"$f":"IF(ISBLANK(Survey!$E$8),\"N/A\",IF(MID(Survey!$M$8,7,2)<\"14\",\"\",IF(MID(Survey!$M$8,7,2)=\"14\",\"N/A\",IF(MID(Survey!$M$8,7,2)=\"16\",\"N/A\",IF(MID(Survey!$M$8,4,3)>\"149\",\"N/A\",\"\")))))","v":"N/A"}]
[null,{"$f":"Survey!B79","v":"31.  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,null,null,null,null,{"$f":"IF(ISBLANK(Survey!$E$8),\"N/A\",IF(MID(Survey!$M$8,7,2)<\"14\",\"\",IF(MID(Survey!$M$8,7,2)=\"14\",\"N/A\",IF(MID(Survey!$M$8,7,2)=\"16\",\"N/A\",IF(MID(Survey!$M$8,4,3)>\"149\",\"N/A\",\"\")))))","v":"N/A"}]
[null,{"$f":"Survey!B81","v":"32.  Do units have prodigy boards?  If no, enter unit tonnage (identify only if the AC unit is an Energence unit)."},null,null,null,null,null,null,null,{"$f":"IF(ISBLANK(Survey!$E$8),\"N/A\",IF(LEN(Survey!$M$8)>15,\"N/A\",IF(VALUE(MID(Survey!$E$8,3,2))<10,\"N/A\",IF(MID(Survey!$M$8,7,2)=\"14\",\"N/A\",IF(MID(Survey!$M$8,7,2)=\"16\",\"N/A\",IF(MID(Survey!$M$8,4,3)>\"149\",\"N/A\",\"\"))))))","v":"N/A"}]
[null,{"$f":"Survey!B83","v":"33.  Identify prodigy boards New or Old.  Answer New Green, N or Old Red, R."},null,null,null,null,null,null,null,{"$f":"IF(ISBLANK(Survey!$E$8),\"N/A\",IF(LEN(Survey!$M$8)>15,\"N/A\",IF(VALUE(MID(Survey!$E$8,3,2))<10,\"N/A\",IF(MID(Survey!$M$8,7,2)=\"14\",\"N/A\",IF(MID(Survey!$M$8,7,2)=\"16\",\"N/A\",IF(MID(Survey!$M$8,4,3)>\"149\",\"N/A\",\"\"))))))","v":"N/A"}]
[null,{"$f":"Survey!B85","v":"34.  If economizer actuator open, turn unit off to assure it closes.  If does not CLOSE enter unit tonnage."},null,null,null,null,null,null,null,{"$f":"IF(ISBLANK(Survey!$E$8),\"N/A\",IF(MID(Survey!$M$8,7,2)<\"14\",\"\",IF(MID(Survey!$M$8,7,2)=\"14\",\"N/A\",IF(MID(Survey!$M$8,7,2)=\"16\",\"N/A\",IF(MID(Survey!$M$8,4,3)>\"149\",\"N/A\",\"\")))))","v":"N/A"}]
[null,{"$f":"Survey!B87","v":"35.  Are actuator gears worn?  If yes, enter unit tonnage."},null,null,null,null,null,null,null,{"$f":"IF(ISBLANK(Survey!$E$8),\"N/A\",IF(MID(Survey!$M$8,7,2)<\"14\",\"\",IF(MID(Survey!$M$8,7,2)=\"14\",\"N/A\",IF(MID(Survey!$M$8,7,2)=\"16\",\"N/A\",IF(MID(Survey!$M$8,4,3)>\"149\",\"N/A\",\"\")))))","v":"N/A"}]
[null,{"$f":"Survey!B89","v":"36.  Verify outdoor damper position  can be adjusted.  If cannot be adjusted enter unit tonnage."},null,null,null,null,null,null,null,{"$f":"IF(ISBLANK(Survey!$E$8),\"N/A\",IF(MID(Survey!$M$8,7,2)<\"14\",\"\",IF(MID(Survey!$M$8,7,2)=\"14\",\"N/A\",IF(MID(Survey!$M$8,7,2)=\"16\",\"N/A\",IF(MID(Survey!$M$8,4,3)>\"149\",\"N/A\",\"\")))))","v":"N/A"}]
[null,{"$f":"Survey!B91","v":"37.  Is there any play in the actuator gear box?   If yes, enter unit tonnage"},null,null,null,null,null,null,null,{"$f":"IF(ISBLANK(Survey!$E$8),\"N/A\",IF(MID(Survey!$M$8,7,2)<\"14\",\"\",IF(MID(Survey!$M$8,7,2)=\"14\",\"N/A\",IF(MID(Survey!$M$8,7,2)=\"16\",\"N/A\",IF(MID(Survey!$M$8,4,3)>\"149\",\"N/A\",\"\")))))","v":"N/A"}]
[null,{"$f":"Survey!B93","v":"38.  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,null,null,null,null,"C"]
[null,{"$f":"Survey!B95","v":"39.  Do filters meet CFA spec (2\" pleated polyester/cotton with MERV rating of 7).  If no, enter unit tonnage."},null,null,null,null,null,null,null,"C"]
[null,{"$f":"Survey!B97","v":"40.  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,null,null,null,null,1.25]
[null,{"$f":"Survey!B99","v":"41.  Do condensation traps meet provided detail.  If NO, enter unit tonnage."},null,null,null,null,null,null,null,15]
[null,{"$f":"Survey!B101","v":"42.  Do pre-filters need to be cleaned?  If YES, enter unit tonnage."},null,null,null,null,null,null,null,15]
[null,{"$f":"Survey!B103","v":"43.  Do pre-filters need to be replaced?  If YES, enter unit tonnage."},null,null,null,null,null,null,null,15]
[null,{"$f":"Survey!B105","v":"44.  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,null,null,null,null,null,15]
[null,"MISCELLENOUS NOTES"]

{"sheet":"RTU2","index":2,"n_rows":50,"n_cols":13,"rows_kept":50,"cut":false,"hidden":false,"merged":[[4,1,4,3],[47,1,47,8],[48,1,48,8],[49,1,49,9],[41,1,41,8],[30,1,30,8],[31,1,31,8],[32,1,32,8],[33,1,33,8],[34,1,34,8],[35,1,35,8],[36,1,36,8],[37,1,37,8],[38,1,38,8],[39,1,39,8],[40,1,40,8],[50,1,55,9],[42,1,42,8],[43,1,43,8],[44,1,44,8],[45,1,45,8],[46,1,46,8],[13,1,13,8],[14,1,14,8],[15,1,15,8],[29,1,29,8],[17,1,17,8],[18,1,18,8],[20,1,20,8],[21,1,21,8],[22,1,22,8],[23,1,23,8],[24,1,24,8],[25,1,25,8],[26,1,26,8],[27,1,27,8],[28,1,28,8],[0,5,0,6],[19,1,19,8],[0,1,0,4],[1,1,1,4],[2,1,2,4],[3,1,3,4],[16,1,16,8],[5,1,5,8],[6,1,6,8],[7,1,7,8],[8,1,8,8],[9,1,9,8],[10,1,10,8],[11,1,11,8],[4,4,4,5],[12,1,12,8]]}
[null,"RTU UNIT MANUFACTURER",null,null,null,{"$f":"Survey!AA9","v":"Lennox"}]
[null,"RTU TYPE",null,null,null,{"$f":"Survey!AI9","v":"ENERGENCE"}]
[null,"MODEL NUMBER",null,null,null,{"$f":"Survey!M9","v":"LGH060H4EH1Y"}]
[null,"SERIAL NUMBER",null,null,null,{"$f":"Survey!E9","v":"5610K14147"}]
[null,null,null,null,"RTU AGE",null,{"$f":"Survey!AF9","v":12.443835616438356},"RTU TONNAGE",null,{"$f":"Survey!X9","v":"5"}]
[null,{"$f":"Survey!B19","v":"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,null,null,null,null,"C",null,null,{"$f":"SUM(Survey!CE18:CE21)","v":0}]
[null,{"$f":"Survey!B21","v":"2.  Quantify damage/deterioration to the condenser coil (0% to 100%).  If greater than 50% enter unit tonnage."},null,null,null,null,null,null,null,0.1]
[null,{"$f":"Survey!B23","v":"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,null,null,null,null,"C"]
[null,{"$f":"Survey!B25","v":"4.  Check both sides of evaporator coil for deterioration.  Perform fin test. If greater than 50% enter unit tonnage"},null,null,null,null,null,null,null,"C"]
[null,{"$f":"Survey!B27","v":"5.  Check for power exhaust at AC units greater than ten tons.  If no power exhaust enter unit tonnage."},null,null,null,null,null,null,null,{"$f":"IF(ISBLANK(Survey!$E$9),\"N/A\",IF(MID(Survey!$M$9,4,3)<=\"120\",\"N/A\",IF(MID(Survey!$M$9,7,2)=\"14\",\"N/A\",IF(MID(Survey!$M$9,7,2)=\"16\",\"N/A\",IF(MID(Survey!$M$9,15,1)=\"A\",\"N/A\",IF(MID(Survey!$M$9,7,2)<\"14\",\"\",IF(MID(Survey!$M$9,4,3)>\"149\",\"N/A\",\"\")))))))","v":"N/A"}]
[null,{"$f":"Survey!B29","v":"6.  Are there curb adaptors on any of the units?  If YES, enter unit tonnage."},null,null,null,null,null,null,null,"C"]
[null,{"$f":"Survey!B31","v":"7.  Is unit a humiditrol type unit?"},null,null,null,null,null,null,null,"Yes"]
[null,{"$f":"Survey!B33","v":"8.  Is the humidity sensor wired?  If NO,  enter unit tonnage."},null,null,null,null,null,null,null,"C"]
[null,{"$f":"Survey!B35","v":"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,null,null,null,null,{"$f":"Survey!P149","v":"1-1/2\""}]
[null,{"$f":"Survey!B37","v":"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,null,null,null,null,{"$f":"Survey!AZ149","v":0}]
[null,{"$f":"Survey!B39","v":"11.  Record size of gas line going into unit.  NOTE: Pull down menu in cells."},null,null,null,null,null,null,null,"3/4\""]
[null,{"$f":"Survey!B41","v":"12.  Is a smoke detector present in unit?  If NO, enter unit tonnage."},null,null,null,null,null,null,null,"C"]
[null,{"$f":"Survey!B43","v":"13.  Is the smoke detector inlet sampling tube capped?  If NO, enter unit tonnage."},null,null,null,null,null,null,null,"C"]
[null,{"$f":"Survey!B45","v":"14.  Check smoke detector module light. If light RED or an AMBER color, enter unit tonnage."},null,null,null,null,null,null,null,"C"]
[null,{"$f":"Survey!B47","v":"15.  Is smoke detector dust plugs capped?  If YES, enter unit tonnage."},null,null,null,null,null,null,null,"C"]
[null,{"$f":"Survey!B49","v":"16.  Is hub (hub houses bearings and located at center of pulley) at the tensioner intact?  If NO, enter unit tonnage."},null,null,null,null,null,null,null,{"$f":"IF(ISBLANK(Survey!$E$9),\"N/A\",IF(LEN(Survey!$M$9)>15,\"N/A\",IF(VALUE(MID(Survey!$E$9,3,2))<17,\"N/A\",IF(MID(Survey!$M$9,7,2)=\"14\",\"N/A\",IF(MID(Survey!$M$9,7,2)=\"16\",\"N/A\",IF(MID(Survey!$M$9,4,3)>\"149\",\"N/A\",IF(MID(Survey!$M$9,9,1)=\"E\",\"N/A\",\"\")))))))","v":"N/A"}]
[null,{"$f":"Survey!B51","v":"17. Is belt tensioner installed?  If NO, enter unit tonnage."},null,null,null,null,null,null,null,{"$f":"IF(ISBLANK(Survey!$E$9),\"N/A\",IF(LEN(Survey!$M$9)>15,\"N/A\",IF(VALUE(MID(Survey!$E$9,3,2))<17,\"N/A\",IF(MID(Survey!$M$9,7,2)=\"14\",\"N/A\",IF(MID(Survey!$M$9,7,2)=\"16\",\"N/A\",IF(MID(Survey!$M$9,4,3)>\"149\",\"N/A\",IF(MID(Survey!$M$9,9,1)=\"E\",\"N/A\",\"\")))))))","v":"N/A"}]
[null,{"$f":"Survey!B53","v":"18. Look for damage/indentions at pulleys?  If damage found, enter unit tonnage."},null,null,null,null,null,null,null,"DD"]
[null,{"$f":"Survey!B55","v":"19. Check motor sheave to assure it can be adjusted.  If cannot be adJusted, enter unit tonnage, & part #'S in misc notes."},null,null,null,null,null,null,null,{"$f":"IF(ISBLANK(Survey!$E$9),\"N/A\",IF(MID(Survey!$M$9,7,2)<\"14\",\"\",IF(MID(Survey!$M$9,7,2)=\"14\",\"N/A\",IF(MID(Survey!$M$9,7,2)=\"16\",\"N/A\",IF(MID(Survey!$M$9,4,3)>\"149\",\"N/A\",IF(MID(Survey!$M$9,9,1)=\"E\",\"N/A\",\"\"))))))","v":"N/A"}]
[null,{"$f":"Survey!B57","v":"20. Record belt size."},null,null,null,null,null,null,null,{"$f":"IF(ISBLANK(Survey!$E$9),\"N/A\",IF(MID(Survey!$M$9,7,2)<\"14\",\"\",IF(MID(Survey!$M$9,7,2)=\"14\",\"N/A\",IF(MID(Survey!$M$9,7,2)=\"16\",\"N/A\",IF(MID(Survey!$M$9,4,3)>\"149\",\"N/A\",IF(MID(Survey!$M$9,9,1)=\"E\",\"N/A\",\"\"))))))","v":"N/A"}]
[null,{"$f":"Survey!B59","v":"21.  Identify any damage to the blower.  If DAMAGE found, enter unit tonnage."},null,null,null,null,null,null,null,"C"]
[null,{"$f":"Survey!B61","v":"22.  Quantify cleanliness of blower.  If dirty, enter unit tonnage."},null,null,null,null,null,null,null,5]
[null,{"$f":"Survey!B63","v":"23.  At blower motor start up is there a concernng amount of noise or vibration?  If so, enter unit tonnage."},null,null,null,null,null,null,null,5]
[null,{"$f":"Survey!B65","v":"24.  Is blank plate secured on B-cabinets?  If NO, enter unit tonnage."},null,null,null,null,null,null,null,{"$f":"IF(ISBLANK(Survey!$E$9),\"N/A\",IF(LEN(Survey!$M$9)>15,\"N/A\",IF(MID(Survey!$M$9,4,3)<=\"072\",\"N/A\",IF(MID(Survey!$M$9,4,3)>=\"180\",\"N/A\",IF(MID(Survey!$M$9,7,2)=\"14\",\"N/A\",IF(MID(Survey!$M$9,7,2)=\"16\",\"N/A\",IF(MID(Survey!$M$9,4,3)>\"149\",\"N/A\",\"\")))))))","v":"N/A"}]
[null,{"$f":"Survey!B67","v":"25.  Is ductwork lined?  If  YES, enter unit tonnage."},null,null,null,null,null,null,null,"C"]
[null,{"$f":"Survey!B69","v":"26. Are turning vanes present in the supply ducts of the units?  IF NO, insert unit tonnage."},null,null,null,null,null,null,null,"C"]
[null,{"$f":"Survey!B71","v":"27. Are turning vanes single or double thickness?  If DOUBLE, enter unit tonnage."},null,null,null,null,null,null,null,5]
[null,{"$f":"Survey!B73","v":"28. Is duct work seated and aligned?  If NO, enter unit tonnage."},null,null,null,null,null,null,null,"C"]
[null,{"$f":"Survey!B75","v":"29. Is canvas connector present?  If NO, enter unit tonnage."},null,null,null,null,null,null,null,"C"]
[null,{"$f":"Survey!B77","v":"30.  Quantify cleanliness of duct.  If dirty, enter unit tonnage."},null,null,null,null,null,null,null,5]
[null,{"$f":"Survey!B79","v":"31.  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,null,null,null,null,5]
[null,{"$f":"Survey!B81","v":"32.  Do units have prodigy boards?  If no, enter unit tonnage (identify only if the AC unit is an Energence unit)."},null,null,null,null,null,null,null,"C"]
[null,{"$f":"Survey!B83","v":"33.  Identify prodigy boards New or Old.  Answer New Green, N or Old Red, R."},null,null,null,null,null,null,null,"R"]
[null,{"$f":"Survey!B85","v":"34.  If economizer actuator open, turn unit off to assure it closes.  If does not CLOSE enter unit tonnage."},null,null,null,null,null,null,null,"C"]
[null,{"$f":"Survey!B87","v":"35.  Are actuator gears worn?  If yes, enter unit tonnage."},null,null,null,null,null,null,null,"C"]
[null,{"$f":"Survey!B89","v":"36.  Verify outdoor damper position  can be adjusted.  If cannot be adjusted enter unit tonnage."},null,null,null,null,null,null,null,"C"]
[null,{"$f":"Survey!B91","v":"37.  Is there any play in the actuator gear box?   If yes, enter unit tonnage"},null,null,null,null,null,null,null,"C"]
[null,{"$f":"Survey!B93","v":"38.  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,null,null,null,null,"C"]
[null,{"$f":"Survey!B95","v":"39.  Do filters meet CFA spec (2\" pleated polyester/cotton with MERV rating of 7).  If no, enter unit tonnage."},null,null,null,null,null,null,null,"C"]
[null,{"$f":"Survey!B97","v":"40.  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,null,null,null,null,1]
[null,{"$f":"Survey!B99","v":"41.  Do condensation traps meet provided detail.  If NO, enter unit tonnage."},null,null,null,null,null,null,null,5]
[null,{"$f":"Survey!B101","v":"42.  Do pre-filters need to be cleaned?  If YES, enter unit tonnage."},null,null,null,null,null,null,null,"C"]
[null,{"$f":"Survey!B103","v":"43.  Do pre-filters need to be replaced?  If YES, enter unit tonnage."},null,null,null,null,null,null,null,"C"]
[null,{"$f":"Survey!B105","v":"44.  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,null,null,null,null,null,5]
[null,"MISCELLENOUS NOTES"]

{"sheet":"RTU3","index":3,"n_rows":50,"n_cols":13,"rows_kept":50,"cut":false,"hidden":false,"merged":[[47,1,47,8],[48,1,48,8],[49,1,49,9],[50,1,55,9],[46,1,46,8],[43,1,43,8],[44,1,44,8],[35,1,35,8],[36,1,36,8],[37,1,37,8],[38,1,38,8],[39,1,39,8],[45,1,45,8],[34,1,34,8],[23,1,23,8],[24,1,24,8],[25,1,25,8],[26,1,26,8],[27,1,27,8],[28,1,28,8],[29,1,29,8],[30,1,30,8],[31,1,31,8],[32,1,32,8],[33,1,33,8],[40,1,40,8],[41,1,41,8],[42,1,42,8],[22,1,22,8],[11,1,11,8],[12,1,12,8],[13,1,13,8],[14,1,14,8],[15,1,15,8],[16,1,16,8],[17,1,17,8],[18,1,18,8],[19,1,19,8],[20,1,20,8],[21,1,21,8],[10,1,10,8],[0,1,0,4],[0,5,0,6],[1,1,1,4],[2,1,2,4],[3,1,3,4],[5,1,5,8],[6,1,6,8],[7,1,7,8],[8,1,8,8],[9,1,9,8],[4,4,4,5]]}
[null,"RTU UNIT MANUFACTURER",null,null,null,{"$f":"Survey!AA10","v":"Lennox"}]
[null,"RTU TYPE",null,null,null,{"$f":"Survey!AI10","v":"ENERGENCE"}]
[null,"MODEL NUMBER",null,null,null,{"$f":"Survey!M10","v":"LGH150S4BH1Y"}]
[null,"SERIAL NUMBER",null,null,null,{"$f":"Survey!E10","v":"5610K13975"}]
[null,null,null,null,"RTU AGE",null,{"$f":"Survey!AF10","v":12.443835616438356},"RTU TONNAGE",null,{"$f":"Survey!X10","v":"12.5"}]
[null,{"$f":"Survey!B19","v":"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,null,null,null,null,"C",null,null,{"$f":"SUM(Survey!CE18:CE21)","v":0}]
[null,{"$f":"Survey!B21","v":"2.  Quantify damage/deterioration to the condenser coil (0% to 100%).  If greater than 50% enter unit tonnage."},null,null,null,null,null,null,null,0.06]
[null,{"$f":"Survey!B23","v":"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,null,null,null,null,"C"]
[null,{"$f":"Survey!B25","v":"4.  Check both sides of evaporator coil for deterioration.  Perform fin test. If greater than 50% enter unit tonnage"},null,null,null,null,null,null,null,"C"]
[null,{"$f":"Survey!B27","v":"5.  Check for power exhaust at AC units greater than ten tons.  If no power exhaust enter unit tonnage."},null,null,null,null,null,null,null,12.5]
[null,{"$f":"Survey!B29","v":"6.  Are there curb adaptors on any of the units?  If YES, enter unit tonnage."},null,null,null,null,null,null,null,"C"]
[null,{"$f":"Survey!B31","v":"7.  Is unit a humiditrol type unit?"},null,null,null,null,null,null,null,"Yes"]
[null,{"$f":"Survey!B33","v":"8.  Is the humidity sensor wired?  If NO,  enter unit tonnage."},null,null,null,null,null,null,null,"C"]
[null,{"$f":"Survey!B35","v":"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,null,null,null,null,{"$f":"Survey!P151","v":0}]
[null,{"$f":"Survey!B37","v":"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,null,null,null,null,{"$f":"Survey!AZ151","v":"3/4\""}]
[null,{"$f":"Survey!B39","v":"11.  Record size of gas line going into unit.  NOTE: Pull down menu in cells."},null,null,null,null,null,null,null,1]
[null,{"$f":"Survey!B41","v":"12.  Is a smoke detector present in unit?  If NO, enter unit tonnage."},null,null,null,null,null,null,null,"C"]
[null,{"$f":"Survey!B43","v":"13.  Is the smoke detector inlet sampling tube capped?  If NO, enter unit tonnage."},null,null,null,null,null,null,null,"C"]
[null,{"$f":"Survey!B45","v":"14.  Check smoke detector module light. If light RED or an AMBER color, enter unit tonnage."},null,null,null,null,null,null,null,"C"]
[null,{"$f":"Survey!B47","v":"15.  Is smoke detector dust plugs capped?  If YES, enter unit tonnage."},null,null,null,null,null,null,null,"C"]
[null,{"$f":"Survey!B49","v":"16.  Is hub (hub houses bearings and located at center of pulley) at the tensioner intact?  If NO, enter unit tonnage."},null,null,null,null,null,null,null,{"$f":"IF(ISBLANK(Survey!$E$10),\"N/A\",IF(LEN(Survey!$M$10)>15,\"N/A\",IF(VALUE(MID(Survey!$E$10,3,2))<17,\"N/A\",IF(MID(Survey!$M$10,9,1)=\"E\",\"N/A\",\"\"))))","v":"N/A"}]
[null,{"$f":"Survey!B51","v":"17. Is belt tensioner installed?  If NO, enter unit tonnage."},null,null,null,null,null,null,null,{"$f":"IF(ISBLANK(Survey!$E$10),\"N/A\",IF(LEN(Survey!$M$10)>15,\"N/A\",IF(VALUE(MID(Survey!$E$10,3,2))<17,\"N/A\",IF(MID(Survey!$M$10,9,1)=\"E\",\"N/A\",\"\"))))","v":"N/A"}]
[null,{"$f":"Survey!B53","v":"18. Look for damage/indentions at pulleys?  If damage found, enter unit tonnage."},null,null,null,null,null,null,null,"C"]
[null,{"$f":"Survey!B55","v":"19. Check motor sheave to assure it can be adjusted.  If cannot be adJusted, enter unit tonnage, & part #'S in misc notes."},null,null,null,null,null,null,null,12.5]
[null,{"$f":"Survey!B57","v":"20. Record belt size."},null,null,null,null,null,null,null,"BX57"]
[null,{"$f":"Survey!B59","v":"21.  Identify any damage to the blower.  If DAMAGE found, enter unit tonnage."},null,null,null,null,null,null,null,"C"]
[null,{"$f":"Survey!B61","v":"22.  Quantify cleanliness of blower.  If dirty, enter unit tonnage."},null,null,null,null,null,null,null,12.5]
[null,{"$f":"Survey!B63","v":"23.  At blower motor start up is there a concernng amount of noise or vibration?  If so, enter unit tonnage."},null,null,null,null,null,null,null,12.5]
[null,{"$f":"Survey!B65","v":"24.  Is blank plate secured on B-cabinets?  If NO, enter unit tonnage."},null,null,null,null,null,null,null,"C"]
[null,{"$f":"Survey!B67","v":"25.  Is ductwork lined?  If  YES, enter unit tonnage."},null,null,null,null,null,null,null,"C"]
[null,{"$f":"Survey!B69","v":"26. Are turning vanes present in the supply ducts of the units?  IF NO, insert unit tonnage."},null,null,null,null,null,null,null,"C"]
[null,{"$f":"Survey!B71","v":"27. Are turning vanes single or double thickness?  If DOUBLE, enter unit tonnage."},null,null,null,null,null,null,null,12.5]
[null,{"$f":"Survey!B73","v":"28. Is duct work seated and aligned?  If NO, enter unit tonnage."},null,null,null,null,null,null,null,"C"]
[null,{"$f":"Survey!B75","v":"29. Is canvas connector present?  If NO, enter unit tonnage."},null,null,null,null,null,null,null,"C"]
[null,{"$f":"Survey!B77","v":"30.  Quantify cleanliness of duct.  If dirty, enter unit tonnage."},null,null,null,null,null,null,null,12.5]
[null,{"$f":"Survey!B79","v":"31.  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,null,null,null,null,12.5]
[null,{"$f":"Survey!B81","v":"32.  Do units have prodigy boards?  If no, enter unit tonnage (identify only if the AC unit is an Energence unit)."},null,null,null,null,null,null,null,"C"]
[null,{"$f":"Survey!B83","v":"33.  Identify prodigy boards New or Old.  Answer New Green, N or Old Red, R."},null,null,null,null,null,null,null,"R"]
[null,{"$f":"Survey!B85","v":"34.  If economizer actuator open, turn unit off to assure it closes.  If does not CLOSE enter unit tonnage."},null,null,null,null,null,null,null,"C"]
[null,{"$f":"Survey!B87","v":"35.  Are actuator gears worn?  If yes, enter unit tonnage."},null,null,null,null,null,null,null,"C"]
[null,{"$f":"Survey!B89","v":"36.  Verify outdoor damper position  can be adjusted.  If cannot be adjusted enter unit tonnage."},null,null,null,null,null,null,null,"C"]
[null,{"$f":"Survey!B91","v":"37.  Is there any play in the actuator gear box?   If yes, enter unit tonnage"},null,null,null,null,null,null,null,12.5]
[null,{"$f":"Survey!B93","v":"38.  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,null,null,null,null,"C"]
[null,{"$f":"Survey!B95","v":"39.  Do filters meet CFA spec (2\" pleated polyester/cotton with MERV rating of 7).  If no, enter unit tonnage."},null,null,null,null,null,null,null,"C"]
[null,{"$f":"Survey!B97","v":"40.  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,null,null,null,null,1.25]
[null,{"$f":"Survey!B99","v":"41.  Do condensation traps meet provided detail.  If NO, enter unit tonnage."},null,null,null,null,null,null,null,12.5]
[null,{"$f":"Survey!B101","v":"42.  Do pre-filters need to be cleaned?  If YES, enter unit tonnage."},null,null,null,null,null,null,null,"C"]
[null,{"$f":"Survey!B103","v":"43.  Do pre-filters need to be replaced?  If YES, enter unit tonnage."},null,null,null,null,null,null,null,"C"]
[null,{"$f":"Survey!B105","v":"44.  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,null,null,null,null,null,12.5]
[null,"MISCELLENOUS NOTES"]

{"sheet":"RTU4","index":4,"n_rows":50,"n_cols":13,"rows_kept":50,"cut":false,"hidden":false,"merged":[[10,1,10,8],[0,1,0,4],[0,5,0,6],[1,1,1,4],[2,1,2,4],[3,1,3,4],[5,1,5,8],[6,1,6,8],[7,1,7,8],[8,1,8,8],[9,1,9,8],[4,4,4,5],[22,1,22,8],[11,1,11,8],[12,1,12,8],[13,1,13,8],[14,1,14,8],[15,1,15,8],[16,1,16,8],[17,1,17,8],[18,1,18,8],[19,1,19,8],[20,1,20,8],[21,1,21,8],[45,1,45,8],[34,1,34,8],[23,1,23,8],[24,1,24,8],[25,1,25,8],[26,1,26,8],[27,1,27,8],[28,1,28,8],[29,1,29,8],[30,1,30,8],[31,1,31,8],[32,1,32,8],[33,1,33,8],[40,1,40,8],[41,1,41,8],[42,1,42,8],[43,1,43,8],[44,1,44,8],[35,1,35,8],[36,1,36,8],[37,1,37,8],[38,1,38,8],[39,1,39,8],[47,1,47,8],[48,1,48,8],[49,1,49,9],[50,1,55,9],[46,1,46,8]]}
[null,"RTU UNIT MANUFACTURER",null,null,null,{"$f":"Survey!AA11","v":"Lennox"}]
[null,"RTU TYPE",null,null,null,{"$f":"Survey!AI11","v":"ENERGENCE"}]
[null,"MODEL NUMBER",null,null,null,{"$f":"Survey!M11","v":"LGH060H4EH1Y"}]
[null,"SERIAL NUMBER",null,null,null,{"$f":"Survey!E11","v":"5610L00584"}]
[null,null,null,null,"RTU AGE",null,{"$f":"Survey!AF11","v":12.358904109589041},"RTU TONNAGE",null,{"$f":"Survey!X11","v":"5"}]
[null,{"$f":"Survey!B19","v":"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,null,null,null,null,"C",null,null,{"$f":"SUM(Survey!CE18:CE21)","v":0}]
[null,{"$f":"Survey!B21","v":"2.  Quantify damage/deterioration to the condenser coil (0% to 100%).  If greater than 50% enter unit tonnage."},null,null,null,null,null,null,null,"C"]
[null,{"$f":"Survey!B23","v":"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,null,null,null,null,"C"]
[null,{"$f":"Survey!B25","v":"4.  Check both sides of evaporator coil for deterioration.  Perform fin test. If greater than 50% enter unit tonnage"},null,null,null,null,null,null,null,"C"]
[null,{"$f":"Survey!B27","v":"5.  Check for power exhaust at AC units greater than ten tons.  If no power exhaust enter unit tonnage."},null,null,null,null,null,null,null,{"$f":"IF(ISBLANK(Survey!$E$11),\"N/A\",IF(MID(Survey!$M$11,15,1)=\"A\",\"N/A\",IF(MID(Survey!$M$11,4,3)<=\"120\",\"N/A\",)))","v":"N/A"}]
[null,{"$f":"Survey!B29","v":"6.  Are there curb adaptors on any of the units?  If YES, enter unit tonnage."},null,null,null,null,null,null,null,"C"]
[null,{"$f":"Survey!B31","v":"7.  Is unit a humiditrol type unit?"},null,null,null,null,null,null,null,"C"]
[null,{"$f":"Survey!B33","v":"8.  Is the humidity sensor wired?  If NO,  enter unit tonnage."},null,null,null,null,null,null,null,"C"]
[null,{"$f":"Survey!B35","v":"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,null,null,null,null,{"$f":"Survey!P151","v":0}]
[null,{"$f":"Survey!B37","v":"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,null,null,null,null,{"$f":"Survey!AZ151","v":"3/4\""}]
[null,{"$f":"Survey!B39","v":"11.  Record size of gas line going into unit.  NOTE: Pull down menu in cells."},null,null,null,null,null,null,null,"3/4\""]
[null,{"$f":"Survey!B41","v":"12.  Is a smoke detector present in unit?  If NO, enter unit tonnage."},null,null,null,null,null,null,null,"C"]
[null,{"$f":"Survey!B43","v":"13.  Is the smoke detector inlet sampling tube capped?  If NO, enter unit tonnage."},null,null,null,null,null,null,null,"C"]
[null,{"$f":"Survey!B45","v":"14.  Check smoke detector module light. If light RED or an AMBER color, enter unit tonnage."},null,null,null,null,null,null,null,"C"]
[null,{"$f":"Survey!B47","v":"15.  Is smoke detector dust plugs capped?  If YES, enter unit tonnage."},null,null,null,null,null,null,null,"C"]
[null,{"$f":"Survey!B49","v":"16.  Is hub (hub houses bearings and located at center of pulley) at the tensioner intact?  If NO, enter unit tonnage."},null,null,null,null,null,null,null,{"$f":"IF(ISBLANK(Survey!$E$11),\"N/A\",IF(LEN(Survey!$M$11)>15,\"N/A\",IF(VALUE(MID(Survey!$E$11,3,2))<17,\"N/A\",IF(MID(Survey!$M$11,9,1)=\"E\",\"N/A\",\"\"))))","v":"N/A"}]
[null,{"$f":"Survey!B51","v":"17. Is belt tensioner installed?  If NO, enter unit tonnage."},null,null,null,null,null,null,null,{"$f":"IF(ISBLANK(Survey!$E$11),\"N/A\",IF(LEN(Survey!$M$11)>15,\"N/A\",IF(VALUE(MID(Survey!$E$11,3,2))<17,\"N/A\",IF(MID(Survey!$M$11,9,1)=\"E\",\"N/A\",\"\"))))","v":"N/A"}]
[null,{"$f":"Survey!B53","v":"18. Look for damage/indentions at pulleys?  If damage found, enter unit tonnage."},null,null,null,null,null,null,null,{"$f":"IF(ISBLANK(Survey!$E$11),\"N/A\",IF(MID(Survey!$M$11,9,1)=\"E\",\"N/A\",\"\"))","v":"N/A"}]
[null,{"$f":"Survey!B55","v":"19. Check motor sheave to assure it can be adjusted.  If cannot be adJusted, enter unit tonnage, & part #'S in misc notes."},null,null,null,null,null,null,null,{"$f":"IF(ISBLANK(Survey!$E$11),\"N/A\",IF(MID(Survey!$M$11,9,1)=\"E\",\"N/A\",\"\"))","v":"N/A"}]
[null,{"$f":"Survey!B57","v":"20. Record belt size."},null,null,null,null,null,null,null,{"$f":"IF(ISBLANK(Survey!$E$11),\"N/A\",IF(MID(Survey!$M$11,9,1)=\"E\",\"N/A\",\"\"))","v":"N/A"}]
[null,{"$f":"Survey!B59","v":"21.  Identify any damage to the blower.  If DAMAGE found, enter unit tonnage."},null,null,null,null,null,null,null,"C"]
[null,{"$f":"Survey!B61","v":"22.  Quantify cleanliness of blower.  If dirty, enter unit tonnage."},null,null,null,null,null,null,null,5]
[null,{"$f":"Survey!B63","v":"23.  At blower motor start up is there a concernng amount of noise or vibration?  If so, enter unit tonnage."},null,null,null,null,null,null,null,"C"]
[null,{"$f":"Survey!B65","v":"24.  Is blank plate secured on B-cabinets?  If NO, enter unit tonnage."},null,null,null,null,null,null,null,{"$f":"IF(ISBLANK(Survey!$E$11),\"N/A\",IF(LEN(Survey!$M$11)>15,\"N/A\",IF(MID(Survey!$M$11,4,3)<=\"072\",\"N/A\",IF(MID(Survey!$M$11,4,3)>=\"180\",\"N/A\",\"\"))))","v":"N/A"}]
[null,{"$f":"Survey!B67","v":"25.  Is ductwork lined?  If  YES, enter unit tonnage."},null,null,null,null,null,null,null,"C"]
[null,{"$f":"Survey!B69","v":"26. Are turning vanes present in the supply ducts of the units?  IF NO, insert unit tonnage."},null,null,null,null,null,null,null,"C"]
[null,{"$f":"Survey!B71","v":"27. Are turning vanes single or double thickness?  If DOUBLE, enter unit tonnage."},null,null,null,null,null,null,null,5]
[null,{"$f":"Survey!B73","v":"28. Is duct work seated and aligned?  If NO, enter unit tonnage."},null,null,null,null,null,null,null,"C"]
[null,{"$f":"Survey!B75","v":"29. Is canvas connector present?  If NO, enter unit tonnage."},null,null,null,null,null,null,null,"C"]
[null,{"$f":"Survey!B77","v":"30.  Quantify cleanliness of duct.  If dirty, enter unit tonnage."},null,null,null,null,null,null,null,5]
[null,{"$f":"Survey!B79","v":"31.  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,null,null,null,null,5]
[null,{"$f":"Survey!B81","v":"32.  Do units have prodigy boards?  If no, enter unit tonnage (identify only if the AC unit is an Energence unit)."},null,null,null,null,null,null,null,"C"]
[null,{"$f":"Survey!B83","v":"33.  Identify prodigy boards New or Old.  Answer New Green, N or Old Red, R."},null,null,null,null,null,null,null,"R"]
[null,{"$f":"Survey!B85","v":"34.  If economizer actuator open, turn unit off to assure it closes.  If does not CLOSE enter unit tonnage."},null,null,null,null,null,null,null,"C"]
[null,{"$f":"Survey!B87","v":"35.  Are actuator gears worn?  If yes, enter unit tonnage."},null,null,null,null,null,null,null,"C"]
[null,{"$f":"Survey!B89","v":"36.  Verify outdoor damper position  can be adjusted.  If cannot be adjusted enter unit tonnage."},null,null,null,null,null,null,null,"C"]
[null,{"$f":"Survey!B91","v":"37.  Is there any play in the actuator gear box?   If yes, enter unit tonnage"},null,null,null,null,null,null,null,"C"]
[null,{"$f":"Survey!B93","v":"38.  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,null,null,null,null,"C"]
[null,{"$f":"Survey!B95","v":"39.  Do filters meet CFA spec (2\" pleated polyester/cotton with MERV rating of 7).  If no, enter unit tonnage."},null,null,null,null,null,null,null,"C"]
[null,{"$f":"Survey!B97","v":"40.  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,null,null,null,null,1]
[null,{"$f":"Survey!B99","v":"41.  Do condensation traps meet provided detail.  If NO, enter unit tonnage."},null,null,null,null,null,null,null,5]
[null,{"$f":"Survey!B101","v":"42.  Do pre-filters need to be cleaned?  If YES, enter unit tonnage."},null,null,null,null,null,null,null,"C"]
[null,{"$f":"Survey!B103","v":"43.  Do pre-filters need to be replaced?  If YES, enter unit tonnage."},null,null,null,null,null,null,null,"C"]
[null,{"$f":"Survey!B105","v":"44.  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,null,null,null,null,null,5]
[null,"MISCELLENOUS NOTES"]

{"sheet":"RTU5","index":5,"n_rows":50,"n_cols":13,"rows_kept":50,"cut":false,"hidden":false,"merged":[[47,1,47,8],[48,1,48,8],[49,1,49,9],[50,1,55,9],[46,1,46,8],[43,1,43,8],[44,1,44,8],[35,1,35,8],[36,1,36,8],[37,1,37,8],[38,1,38,8],[39,1,39,8],[45,1,45,8],[34,1,34,8],[23,1,23,8],[24,1,24,8],[25,1,25,8],[26,1,26,8],[27,1,27,8],[28,1,28,8],[29,1,29,8],[30,1,30,8],[31,1,31,8],[32,1,32,8],[33,1,33,8],[40,1,40,8],[41,1,41,8],[42,1,42,8],[22,1,22,8],[11,1,11,8],[12,1,12,8],[13,1,13,8],[14,1,14,8],[15,1,15,8],[16,1,16,8],[17,1,17,8],[18,1,18,8],[19,1,19,8],[20,1,20,8],[21,1,21,8],[10,1,10,8],[0,1,0,4],[0,5,0,6],[1,1,1,4],[2,1,2,4],[3,1,3,4],[5,1,5,8],[6,1,6,8],[7,1,7,8],[8,1,8,8],[9,1,9,8],[4,4,4,5],[4,1,4,3]]}
[null,"RTU UNIT MANUFACTURER",null,null,null,{"$f":"Survey!AA12","v":""}]
[null,"RTU TYPE",null,null,null,{"$f":"Survey!AI12","v":""}]
[null,"MODEL NUMBER",null,null,null,{"$f":"Survey!M12","v":0}]
[null,"SERIAL NUMBER",null,null,null,{"$f":"Survey!E12","v":0}]
[null,null,null,null,"RTU AGE",null,{"$f":"Survey!AF12","v":0},"RTU TONNAGE",null,{"$f":"Survey!X12","v":""}]
[null,{"$f":"Survey!B19","v":"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,null,null,null,null,{"$f":"IF(ISBLANK(Survey!$E$12),\"N/A\",\"\")","v":"N/A"},null,null,{"$f":"SUM(Survey!CE18:CE21)","v":0}]
[null,{"$f":"Survey!B21","v":"2.  Quantify damage/deterioration to the condenser coil (0% to 100%).  If greater than 50% enter unit tonnage."},null,null,null,null,null,null,null,{"$f":"IF(ISBLANK(Survey!$E$12),\"N/A\",\"\")","v":"N/A"}]
[null,{"$f":"Survey!B23","v":"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,null,null,null,null,{"$f":"IF(ISBLANK(Survey!$E$12),\"N/A\",\"\")","v":"N/A"}]
[null,{"$f":"Survey!B25","v":"4.  Check both sides of evaporator coil for deterioration.  Perform fin test. If greater than 50% enter unit tonnage"},null,null,null,null,null,null,null,{"$f":"IF(ISBLANK(Survey!$E$12),\"N/A\",\"\")","v":"N/A"}]
[null,{"$f":"Survey!B27","v":"5.  Check for power exhaust at AC units greater than ten tons.  If no power exhaust enter unit tonnage."},null,null,null,null,null,null,null,{"$f":"IF(ISBLANK(Survey!$E$12),\"N/A\",IF(MID($M$12,4,3)<=\"120\",\"N/A\",))","v":"N/A"}]
[null,{"$f":"Survey!B29","v":"6.  Are there curb adaptors on any of the units?  If YES, enter unit tonnage."},null,null,null,null,null,null,null,{"$f":"IF(ISBLANK(Survey!$E$12),\"N/A\",\"\")","v":"N/A"}]
[null,{"$f":"Survey!B31","v":"7.  Is unit a humiditrol type unit?"}]
[null,{"$f":"Survey!B33","v":"8.  Is the humidity sensor wired?  If NO,  enter unit tonnage."},null,null,null,null,null,null,null,{"$f":"IF(ISBLANK(Survey!$E$12),\"N/A\",IF(MID(J12,1,2)=\"NO\",\"N/A\",\"\"))","v":"N/A"}]
[null,{"$f":"Survey!B35","v":"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,null,null,null,null,{"$f":"Survey!P151","v":0}]
[null,{"$f":"Survey!B37","v":"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,null,null,null,null,{"$f":"Survey!AZ151","v":"3/4\""}]
[null,{"$f":"Survey!B39","v":"11.  Record size of gas line going into unit.  NOTE: Pull down menu in cells."}]
[null,{"$f":"Survey!B41","v":"12.  Is a smoke detector present in unit?  If NO, enter unit tonnage."},null,null,null,null,null,null,null,{"$f":"IF(ISBLANK(Survey!$E$12),\"N/A\",\"\")","v":"N/A"}]
[null,{"$f":"Survey!B43","v":"13.  Is the smoke detector inlet sampling tube capped?  If NO, enter unit tonnage."},null,null,null,null,null,null,null,{"$f":"IF(ISBLANK(Survey!$E$12),\"N/A\",\"\")","v":"N/A"}]
[null,{"$f":"Survey!B45","v":"14.  Check smoke detector module light. If light RED or an AMBER color, enter unit tonnage."},null,null,null,null,null,null,null,{"$f":"IF(ISBLANK(Survey!$E$12),\"N/A\",\"\")","v":"N/A"}]
[null,{"$f":"Survey!B47","v":"15.  Is smoke detector dust plugs capped?  If YES, enter unit tonnage."},null,null,null,null,null,null,null,{"$f":"IF(ISBLANK(Survey!$E$12),\"N/A\",\"\")","v":"N/A"}]
[null,{"$f":"Survey!B49","v":"16.  Is hub (hub houses bearings and located at center of pulley) at the tensioner intact?  If NO, enter unit tonnage."},null,null,null,null,null,null,null,{"$f":"IF(ISBLANK(Survey!$E$12),\"N/A\",IF(LEN(Survey!$M$12)>15,\"N/A\",IF(VALUE(MID(Survey!$E$12,3,2))<17,\"N/A\",IF(MID(Survey!$M$12,9,1)=\"E\",\"N/A\",\"\"))))","v":"N/A"}]
[null,{"$f":"Survey!B51","v":"17. Is belt tensioner installed?  If NO, enter unit tonnage."},null,null,null,null,null,null,null,{"$f":"IF(ISBLANK(Survey!$E$12),\"N/A\",IF(LEN(Survey!$M$12)>15,\"N/A\",IF(VALUE(MID(Survey!$E$12,3,2))<17,\"N/A\",IF(MID(Survey!$M$12,9,1)=\"E\",\"N/A\",\"\"))))","v":"N/A"}]
[null,{"$f":"Survey!B53","v":"18. Look for damage/indentions at pulleys?  If damage found, enter unit tonnage."},null,null,null,null,null,null,null,{"$f":"IF(ISBLANK(Survey!$E$12),\"N/A\",IF(MID(Survey!$M$12,9,1)=\"E\",\"N/A\",\"\"))","v":"N/A"}]
[null,{"$f":"Survey!B55","v":"19. Check motor sheave to assure it can be adjusted.  If cannot be adJusted, enter unit tonnage, & part #'S in misc notes."},null,null,null,null,null,null,null,{"$f":"IF(ISBLANK(Survey!$E$12),\"N/A\",IF(MID(Survey!$M$12,9,1)=\"E\",\"N/A\",\"\"))","v":"N/A"}]
[null,{"$f":"Survey!B57","v":"20. Record belt size."},null,null,null,null,null,null,null,{"$f":"IF(ISBLANK(Survey!$E$12),\"N/A\",IF(MID(Survey!$M$12,9,1)=\"E\",\"N/A\",\"\"))","v":"N/A"}]
[null,{"$f":"Survey!B59","v":"21.  Identify any damage to the blower.  If DAMAGE found, enter unit tonnage."},null,null,null,null,null,null,null,{"$f":"IF(ISBLANK(Survey!$E$12),\"N/A\",\"\")","v":"N/A"}]
[null,{"$f":"Survey!B61","v":"22.  Quantify cleanliness of blower.  If dirty, enter unit tonnage."},null,null,null,null,null,null,null,{"$f":"IF(ISBLANK(Survey!$E$12),\"N/A\",\"\")","v":"N/A"}]
[null,{"$f":"Survey!B63","v":"23.  At blower motor start up is there a concernng amount of noise or vibration?  If so, enter unit tonnage."},null,null,null,null,null,null,null,{"$f":"IF(ISBLANK(Survey!$E$12),\"N/A\",\"\")","v":"N/A"}]
[null,{"$f":"Survey!B65","v":"24.  Is blank plate secured on B-cabinets?  If NO, enter unit tonnage."},null,null,null,null,null,null,null,{"$f":"IF(ISBLANK(Survey!$E$12),\"N/A\",IF(LEN(Survey!$M$12)>15,\"N/A\",IF(MID(Survey!$M$12,4,3)<=\"072\",\"N/A\",IF(MID(Survey!$M$12,4,3)>=\"180\",\"N/A\",\"\"))))","v":"N/A"}]
[null,{"$f":"Survey!B67","v":"25.  Is ductwork lined?  If  YES, enter unit tonnage."},null,null,null,null,null,null,null,{"$f":"IF(ISBLANK(Survey!$E$12),\"N/A\",\"\")","v":"N/A"}]
[null,{"$f":"Survey!B69","v":"26. Are turning vanes present in the supply ducts of the units?  IF NO, insert unit tonnage."},null,null,null,null,null,null,null,{"$f":"IF(ISBLANK(Survey!$E$12),\"N/A\",\"\")","v":"N/A"}]
[null,{"$f":"Survey!B71","v":"27. Are turning vanes single or double thickness?  If DOUBLE, enter unit tonnage."},null,null,null,null,null,null,null,{"$f":"IF(ISBLANK(Survey!$E$12),\"N/A\",\"\")","v":"N/A"}]
[null,{"$f":"Survey!B73","v":"28. Is duct work seated and aligned?  If NO, enter unit tonnage."},null,null,null,null,null,null,null,{"$f":"IF(ISBLANK(Survey!$E$12),\"N/A\",\"\")","v":"N/A"}]
[null,{"$f":"Survey!B75","v":"29. Is canvas connector present?  If NO, enter unit tonnage."},null,null,null,null,null,null,null,{"$f":"IF(ISBLANK(Survey!$E$12),\"N/A\",\"\")","v":"N/A"}]
[null,{"$f":"Survey!B77","v":"30.  Quantify cleanliness of duct.  If dirty, enter unit tonnage."},null,null,null,null,null,null,null,{"$f":"IF(ISBLANK(Survey!$E$12),\"N/A\",\"\")","v":"N/A"}]
[null,{"$f":"Survey!B79","v":"31.  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,null,null,null,null,{"$f":"IF(ISBLANK(Survey!$E$12),\"N/A\",\"\")","v":"N/A"}]
[null,{"$f":"Survey!B81","v":"32.  Do units have prodigy boards?  If no, enter unit tonnage (identify only if the AC unit is an Energence unit)."},null,null,null,null,null,null,null,{"$f":"IF(ISBLANK(Survey!$E$12),\"N/A\",IF(LEN(Survey!$M$12)>15,\"N/A\",IF(VALUE(MID(Survey!$E$12,3,2))<10,\"N/A\",\"\")))","v":"N/A"}]
[null,{"$f":"Survey!B83","v":"33.  Identify prodigy boards New or Old.  Answer New Green, N or Old Red, R."},null,null,null,null,null,null,null,{"$f":"IF(ISBLANK(Survey!$E$12),\"N/A\",IF(LEN(Survey!$M$12)>15,\"N/A\",IF(VALUE(MID(Survey!$E$12,3,2))<10,\"N/A\",\"\")))","v":"N/A"}]
[null,{"$f":"Survey!B85","v":"34.  If economizer actuator open, turn unit off to assure it closes.  If does not CLOSE enter unit tonnage."},null,null,null,null,null,null,null,{"$f":"IF(ISBLANK(Survey!$E$12),\"N/A\",\"\")","v":"N/A"}]
[null,{"$f":"Survey!B87","v":"35.  Are actuator gears worn?  If yes, enter unit tonnage."},null,null,null,null,null,null,null,{"$f":"IF(ISBLANK($E$12),\"N/A\",\"\")","v":"N/A"}]
[null,{"$f":"Survey!B89","v":"36.  Verify outdoor damper position  can be adjusted.  If cannot be adjusted enter unit tonnage."},null,null,null,null,null,null,null,{"$f":"IF(ISBLANK(Survey!$E$12),\"N/A\",\"\")","v":"N/A"}]
[null,{"$f":"Survey!B91","v":"37.  Is there any play in the actuator gear box?   If yes, enter unit tonnage"},null,null,null,null,null,null,null,{"$f":"IF(ISBLANK(Survey!$E$12),\"N/A\",\"\")","v":"N/A"}]
[null,{"$f":"Survey!B93","v":"38.  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,null,null,null,null,{"$f":"IF(ISBLANK(Survey!$E$12),\"N/A\",\"\")","v":"N/A"}]
[null,{"$f":"Survey!B95","v":"39.  Do filters meet CFA spec (2\" pleated polyester/cotton with MERV rating of 7).  If no, enter unit tonnage."},null,null,null,null,null,null,null,{"$f":"IF(ISBLANK(Survey!$E$12),\"N/A\",\"\")","v":"N/A"}]
[null,{"$f":"Survey!B97","v":"40.  Provide condensation pipe size.  Minimum 1\" at playland unit, and 1.25\" at all other units.  NOTE: DROP DOWN MENUS FOR PIPE SIZE."}]
[null,{"$f":"Survey!B99","v":"41.  Do condensation traps meet provided detail.  If NO, enter unit tonnage."},null,null,null,null,null,null,null,{"$f":"IF(ISBLANK(Survey!$E$12),\"N/A\",\"\")","v":"N/A"}]
[null,{"$f":"Survey!B101","v":"42.  Do pre-filters need to be cleaned?  If YES, enter unit tonnage."},null,null,null,null,null,null,null,{"$f":"IF(ISBLANK(Survey!$E$12),\"N/A\",\"\")","v":"N/A"}]
[null,{"$f":"Survey!B103","v":"43.  Do pre-filters need to be replaced?  If YES, enter unit tonnage."},null,null,null,null,null,null,null,{"$f":"IF(ISBLANK(Survey!$E$12),\"N/A\",\"\")","v":"N/A"}]
[null,{"$f":"Survey!B105","v":"44.  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,null,null,null,null,null,{"$f":"IF(ISBLANK(Survey!$E$12),\"N/A\",\"\")","v":"N/A"}]
[null,"MISCELLENOUS NOTES"]

{"sheet":"RTU6","index":6,"n_rows":50,"n_cols":13,"rows_kept":50,"cut":false,"hidden":false,"merged":[[47,1,47,8],[48,1,48,8],[49,1,49,9],[50,1,55,9],[46,1,46,8],[43,1,43,8],[44,1,44,8],[35,1,35,8],[36,1,36,8],[37,1,37,8],[38,1,38,8],[39,1,39,8],[45,1,45,8],[34,1,34,8],[23,1,23,8],[24,1,24,8],[25,1,25,8],[26,1,26,8],[27,1,27,8],[28,1,28,8],[29,1,29,8],[30,1,30,8],[31,1,31,8],[32,1,32,8],[33,1,33,8],[40,1,40,8],[41,1,41,8],[42,1,42,8],[22,1,22,8],[11,1,11,8],[12,1,12,8],[13,1,13,8],[14,1,14,8],[15,1,15,8],[16,1,16,8],[17,1,17,8],[18,1,18,8],[19,1,19,8],[20,1,20,8],[21,1,21,8],[10,1,10,8],[0,1,0,4],[0,5,0,6],[1,1,1,4],[2,1,2,4],[3,1,3,4],[4,1,4,4],[4,5,4,8],[5,1,5,8],[6,1,6,8],[7,1,7,8],[8,1,8,8],[9,1,9,8]]}
[null,"RTU UNIT MANUFACTURER",null,null,null,{"$f":"Survey!AA13","v":""}]
[null,"RTU TYPE",null,null,null,{"$f":"Survey!AI13","v":""}]
[null,"MODEL NUMBER",null,null,null,{"$f":"Survey!M13","v":0}]
[null,"SERIAL NUMBER",null,null,null,{"$f":"Survey!E13","v":0}]
[null,null,null,null,null,"RTU TONNAGE",null,null,null,{"$f":"Survey!X13","v":""}]
[null,{"$f":"Survey!B19","v":"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,null,null,null,null,{"$f":"IF(ISBLANK(Survey!$E$13),\"N/A\",\"\")","v":"N/A"},null,null,{"$f":"SUM(Survey!CE18:CE21)","v":0}]
[null,{"$f":"Survey!B21","v":"2.  Quantify damage/deterioration to the condenser coil (0% to 100%).  If greater than 50% enter unit tonnage."},null,null,null,null,null,null,null,{"$f":"IF(ISBLANK(Survey!$E$13),\"N/A\",\"\")","v":"N/A"}]
[null,{"$f":"Survey!B23","v":"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,null,null,null,null,{"$f":"IF(ISBLANK(Survey!$E$13),\"N/A\",\"\")","v":"N/A"}]
[null,{"$f":"Survey!B25","v":"4.  Check both sides of evaporator coil for deterioration.  Perform fin test. If greater than 50% enter unit tonnage"},null,null,null,null,null,null,null,{"$f":"IF(ISBLANK(Survey!$E$13),\"N/A\",\"\")","v":"N/A"}]
[null,{"$f":"Survey!B27","v":"5.  Check for power exhaust at AC units greater than ten tons.  If no power exhaust enter unit tonnage."},null,null,null,null,null,null,null,{"$f":"IF(ISBLANK(Survey!$E$13),\"N/A\",IF(MID($M$13,4,3)<=\"120\",\"N/A\",))","v":"N/A"}]
[null,{"$f":"Survey!B29","v":"6.  Are there curb adaptors on any of the units?  If YES, enter unit tonnage."},null,null,null,null,null,null,null,{"$f":"IF(ISBLANK(Survey!$E$13),\"N/A\",\"\")","v":"N/A"}]
[null,{"$f":"Survey!B31","v":"7.  Is unit a humiditrol type unit?"},null,null,null,null,null,null,null,"NO"]
[null,{"$f":"Survey!B33","v":"8.  Is the humidity sensor wired?  If NO,  enter unit tonnage."},null,null,null,null,null,null,null,{"$f":"IF(ISBLANK(Survey!$E$13),\"N/A\",IF(MID(Survey!$M$13,7,2)=\"14\",\"N/A\",IF(MID(Survey!$M$13,7,2)=\"16\",\"N/A\",IF(MID(Survey!$M$13,7,2)<\"14\",\"\",IF(MID(Survey!$M$13,4,3)>\"149\",\"N/A\",IF(MID(J13,1,2)=\"NO\",\"N/A\",\"\"))))))","v":"N/A"}]
[null,{"$f":"Survey!B35","v":"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,null,null,null,null,{"$f":"Survey!P151","v":0}]
[null,{"$f":"Survey!B37","v":"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,null,null,null,null,{"$f":"Survey!AZ151","v":"3/4\""}]
[null,{"$f":"Survey!B39","v":"11.  Record size of gas line going into unit.  NOTE: Pull down menu in cells."}]
[null,{"$f":"Survey!B41","v":"12.  Is a smoke detector present in unit?  If NO, enter unit tonnage."},null,null,null,null,null,null,null,{"$f":"IF(ISBLANK(Survey!$E$13),\"N/A\",\"\")","v":"N/A"}]
[null,{"$f":"Survey!B43","v":"13.  Is the smoke detector inlet sampling tube capped?  If NO, enter unit tonnage."},null,null,null,null,null,null,null,{"$f":"IF(ISBLANK(Survey!$E$13),\"N/A\",\"\")","v":"N/A"}]
[null,{"$f":"Survey!B45","v":"14.  Check smoke detector module light. If light RED or an AMBER color, enter unit tonnage."},null,null,null,null,null,null,null,{"$f":"IF(ISBLANK(Survey!$E$13),\"N/A\",\"\")","v":"N/A"}]
[null,{"$f":"Survey!B47","v":"15.  Is smoke detector dust plugs capped?  If YES, enter unit tonnage."},null,null,null,null,null,null,null,{"$f":"IF(ISBLANK(Survey!$E$13),\"N/A\",\"\")","v":"N/A"}]
[null,{"$f":"Survey!B49","v":"16.  Is hub (hub houses bearings and located at center of pulley) at the tensioner intact?  If NO, enter unit tonnage."},null,null,null,null,null,null,null,{"$f":"IF(ISBLANK(Survey!$E$13),\"N/A\",IF(LEN(Survey!$M$13)>15,\"N/A\",IF(VALUE(MID(Survey!$E$13,3,2))<17,\"N/A\",IF(MID(Survey!$M$13,9,1)<=\"E\",\"N/A\",\"\"))))","v":"N/A"}]
[null,{"$f":"Survey!B51","v":"17. Is belt tensioner installed?  If NO, enter unit tonnage."},null,null,null,null,null,null,null,{"$f":"IF(ISBLANK(Survey!$E$13),\"N/A\",IF(LEN(Survey!$M$13)>15,\"N/A\",IF(VALUE(MID(Survey!$E$13,3,2))<17,\"N/A\",IF(MID(Survey!$M$13,9,1)<=\"E\",\"N/A\",\"\"))))","v":"N/A"}]
[null,{"$f":"Survey!B53","v":"18. Look for damage/indentions at pulleys?  If damage found, enter unit tonnage."},null,null,null,null,null,null,null,{"$f":"IF(ISBLANK(Survey!$E$13),\"N/A\",IF(MID(Survey!$M$13,9,1)<=\"E\",\"N/A\",\"\"))","v":"N/A"}]
[null,{"$f":"Survey!B55","v":"19. Check motor sheave to assure it can be adjusted.  If cannot be adJusted, enter unit tonnage, & part #'S in misc notes."},null,null,null,null,null,null,null,{"$f":"IF(ISBLANK(Survey!$E$13),\"N/A\",IF(MID(Survey!$M$13,9,1)<=\"E\",\"N/A\",\"\"))","v":"N/A"}]
[null,{"$f":"Survey!B57","v":"20. Record belt size."},null,null,null,null,null,null,null,{"$f":"IF(ISBLANK(Survey!$E$13),\"N/A\",IF(MID(Survey!$M$13,9,1)=\"E\",\"N/A\",\"\"))","v":"N/A"}]
[null,{"$f":"Survey!B59","v":"21.  Identify any damage to the blower.  If DAMAGE found, enter unit tonnage."},null,null,null,null,null,null,null,{"$f":"IF(ISBLANK(Survey!$E$13),\"N/A\",\"\")","v":"N/A"}]
[null,{"$f":"Survey!B61","v":"22.  Quantify cleanliness of blower.  If dirty, enter unit tonnage."},null,null,null,null,null,null,null,{"$f":"IF(ISBLANK(Survey!$E$13),\"N/A\",\"\")","v":"N/A"}]
[null,{"$f":"Survey!B63","v":"23.  At blower motor start up is there a concernng amount of noise or vibration?  If so, enter unit tonnage."},null,null,null,null,null,null,null,{"$f":"IF(ISBLANK(Survey!$E$13),\"N/A\",\"\")","v":"N/A"}]
[null,{"$f":"Survey!B65","v":"24.  Is blank plate secured on B-cabinets?  If NO, enter unit tonnage."},null,null,null,null,null,null,null,{"$f":"IF(ISBLANK(Survey!$E$13),\"N/A\",IF(LEN(Survey!$M$13)>15,\"N/A\",IF(MID(Survey!$M$13,4,3)<=\"072\",\"N/A\",IF(MID(Survey!$M$13,4,3)>=\"180\",\"N/A\",\"\"))))","v":"N/A"}]
[null,{"$f":"Survey!B67","v":"25.  Is ductwork lined?  If  YES, enter unit tonnage."},null,null,null,null,null,null,null,{"$f":"IF(ISBLANK(Survey!$E$13),\"N/A\",\"\")","v":"N/A"}]
[null,{"$f":"Survey!B69","v":"26. Are turning vanes present in the supply ducts of the units?  IF NO, insert unit tonnage."},null,null,null,null,null,null,null,{"$f":"IF(ISBLANK(Survey!$E$13),\"N/A\",\"\")","v":"N/A"}]
[null,{"$f":"Survey!B71","v":"27. Are turning vanes single or double thickness?  If DOUBLE, enter unit tonnage."},null,null,null,null,null,null,null,{"$f":"IF(ISBLANK(Survey!$E$13),\"N/A\",\"\")","v":"N/A"}]
[null,{"$f":"Survey!B73","v":"28. Is duct work seated and aligned?  If NO, enter unit tonnage."},null,null,null,null,null,null,null,{"$f":"IF(ISBLANK(Survey!$E$13),\"N/A\",\"\")","v":"N/A"}]
[null,{"$f":"Survey!B75","v":"29. Is canvas connector present?  If NO, enter unit tonnage."},null,null,null,null,null,null,null,{"$f":"IF(ISBLANK(Survey!$E$13),\"N/A\",\"\")","v":"N/A"}]
[null,{"$f":"Survey!B77","v":"30.  Quantify cleanliness of duct.  If dirty, enter unit tonnage."},null,null,null,null,null,null,null,{"$f":"IF(ISBLANK(Survey!$E$13),\"N/A\",\"\")","v":"N/A"}]
[null,{"$f":"Survey!B79","v":"31.  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,null,null,null,null,{"$f":"IF(ISBLANK(Survey!$E$13),\"N/A\",\"\")","v":"N/A"}]
[null,{"$f":"Survey!B81","v":"32.  Do units have prodigy boards?  If no, enter unit tonnage (identify only if the AC unit is an Energence unit)."},null,null,null,null,null,null,null,{"$f":"IF(ISBLANK(Survey!$E$13),\"N/A\",IF(LEN(Survey!$M$13)>15,\"N/A\",IF(VALUE(MID(Survey!$E$13,3,2))<10,\"N/A\",\"\")))","v":"N/A"}]
[null,{"$f":"Survey!B83","v":"33.  Identify prodigy boards New or Old.  Answer New Green, N or Old Red, R."},null,null,null,null,null,null,null,{"$f":"IF(ISBLANK(Survey!$E$13),\"N/A\",IF(LEN(Survey!$M$13)>15,\"N/A\",IF(VALUE(MID(Survey!$E$13,3,2))<10,\"N/A\",\"\")))","v":"N/A"}]
[null,{"$f":"Survey!B85","v":"34.  If economizer actuator open, turn unit off to assure it closes.  If does not CLOSE enter unit tonnage."},null,null,null,null,null,null,null,{"$f":"IF(ISBLANK(Survey!$E$13),\"N/A\",\"\")","v":"N/A"}]
[null,{"$f":"Survey!B87","v":"35.  Are actuator gears worn?  If yes, enter unit tonnage."},null,null,null,null,null,null,null,{"$f":"IF(ISBLANK($E$13),\"N/A\",\"\")","v":"N/A"}]
[null,{"$f":"Survey!B89","v":"36.  Verify outdoor damper position  can be adjusted.  If cannot be adjusted enter unit tonnage."},null,null,null,null,null,null,null,{"$f":"IF(ISBLANK(Survey!$E$13),\"N/A\",\"\")","v":"N/A"}]
[null,{"$f":"Survey!B91","v":"37.  Is there any play in the actuator gear box?   If yes, enter unit tonnage"},null,null,null,null,null,null,null,{"$f":"IF(ISBLANK(Survey!$E$13),\"N/A\",\"\")","v":"N/A"}]
[null,{"$f":"Survey!B93","v":"38.  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,null,null,null,null,{"$f":"IF(ISBLANK(Survey!$E$13),\"N/A\",\"\")","v":"N/A"}]
[null,{"$f":"Survey!B95","v":"39.  Do filters meet CFA spec (2\" pleated polyester/cotton with MERV rating of 7).  If no, enter unit tonnage."},null,null,null,null,null,null,null,{"$f":"IF(ISBLANK(Survey!$E$13),\"N/A\",\"\")","v":"N/A"}]
[null,{"$f":"Survey!B97","v":"40.  Provide condensation pipe size.  Minimum 1\" at playland unit, and 1.25\" at all other units.  NOTE: DROP DOWN MENUS FOR PIPE SIZE."}]
[null,{"$f":"Survey!B99","v":"41.  Do condensation traps meet provided detail.  If NO, enter unit tonnage."},null,null,null,null,null,null,null,{"$f":"IF(ISBLANK(Survey!$E$13),\"N/A\",\"\")","v":"N/A"}]
[null,{"$f":"Survey!B101","v":"42.  Do pre-filters need to be cleaned?  If YES, enter unit tonnage."},null,null,null,null,null,null,null,{"$f":"IF(ISBLANK(Survey!$E$13),\"N/A\",\"\")","v":"N/A"}]
[null,{"$f":"Survey!B103","v":"43.  Do pre-filters need to be replaced?  If YES, enter unit tonnage."},null,null,null,null,null,null,null,{"$f":"IF(ISBLANK(Survey!$E$13),\"N/A\",\"\")","v":"N/A"}]
[null,{"$f":"Survey!B105","v":"44.  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,null,null,null,null,null,{"$f":"IF(ISBLANK(Survey!$E$13),\"N/A\",\"\")","v":"N/A"}]
[null,"MISCELLENOUS NOTES"]

{"sheet":"BR EF","index":7,"n_rows":17,"n_cols":10,"rows_kept":17,"cut":false,"hidden":false,"merged":[[7,1,7,8],[8,1,8,8],[2,1,3,10],[16,1,16,10],[10,11,10,12],[4,1,4,8],[5,1,5,8],[6,1,6,8],[10,1,10,8],[9,1,9,8],[17,1,20,10],[12,1,12,8],[13,1,13,10],[15,7,15,10],[11,1,11,8]]}
[]
[]
[null,"BATHROOM EF/SUNCOAST PANEL/ THERMOSTATS"]
[]
[null,{"$f":"Survey!B107","v":"45.  Is bathroom exhaust fan running?  Enter YES or NO."},null,null,null,null,null,null,null,"NO"]
[null,{"$f":"Survey!B108","v":"46.  Is bathroom exhaust fan making excessive noise? Enter Yes or NO."},null,null,null,null,null,null,null,"NO"]
[null,{"$f":"Survey!B109","v":"47.  Is bathroom exhaust fan vibrating excessively? Enter YES or NO."},null,null,null,null,null,null,null,"NO"]
[null,{"$f":"Survey!B110","v":"48.  Does bathroom exhaust fan have a back draft damper?  Enter YES or NO."},null,null,null,null,null,null,null,"YES"]
[null,{"$f":"Survey!B111","v":"49.  Does bathroom exhaust fan duct have a liner? Enter YES OR NO."},null,null,null,null,null,null,null,"Yes"]
[null,{"$f":"Survey!B112","v":"50.  Visually inspect ductwork at bathroom exhaust fan, and rate cleanliness. Enter CLEAN OR DIRTY."},null,null,null,null,null,null,null,"DIRTY"]
[null,{"$f":"Survey!B113","v":"51.  Record model number of Suncoast Panel."},null,null,null,null,null,null,null,"CHICK-FIL-A CONTROL PANEL"]
[null,"52. Record serial number of Suncoast Panel.",null,null,null,null,null,null,null,"10-CFA-064"]
[null,"53.  Is there a HES control panel visible?  ",null,null,null,null,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,"AC1","RS","AC2","RS","AC3","RS","AC4","RS","AC5"]
[null,"AC6",null,"AC7",null,"AC8"]
[null,"MISCELLENOUS NOTES"]

{"sheet":"2020 Chain","index":8,"n_rows":23,"n_cols":61,"rows_kept":23,"cut":false,"hidden":false,"merged":[[15,46,15,50],[15,51,15,55],[15,56,15,60],[15,21,15,25],[15,26,15,30],[15,31,15,35],[15,36,15,40],[15,41,15,45]]}
["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,"AC2",null,null,null,null,"AC3",null,null,null,null,"AC4",null,null,null,null,"AC5",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 #","Model #","Mfg Date","Age","Type","Serial #","Model #","Mfg Date","Age","Type","Serial #","Model #","Mfg Date","Age","Type","Serial #","Model #","Mfg Date","Age","Type","Serial #","Model #","Mfg Date","Age","Type","Serial #","Model #","Mfg Date","Age","Type","Serial #","Model #","Mfg Date","Age","Type","Serial #","Model #","Mfg Date","Age","Type"]
[]
[]
[2665,{"$f":"E20-240","v":"2022-11-10"},"Des Peres FSU","MLv2/BI","2023-07-08","S08N SM","Midwest",{"$f":"IF(MID(G20,1,3)=\"Nor\",\"National TAB\",IF(MID(G20,1,3)=\"Atl\",\"National TAB\",IF(MID(G20,1,3)=\"Mid\",\"National TAB\",IF(MID(G20,4,4)=\"thea\",\"National TAB\",\"Melink\"))))","v":"National TAB"},"11997 Manchester Road","Des Peres","MO","David Bruce","Micah Dowdy","Matthew Zupancic","Scott Lawhorne","Tony Gragg","Patrick Winkler","Chipman","2011-02-03","(314) 821-3452","02665@chick-fil-a.com","5610K13858","LGH180H4BH2Y","2010-10-01",{"$f":"(TODAY()-X20)/365","v":12.443835616438356},{"$f":"IF(ISBLANK(V20),\"NODATA\",IF(MID(W20,1,2)=\"RN\",\"AAON\",IF(LEN(W20)>15,\"WeatherMaker\",IF(VALUE(MID(V20,3,2))>9,\"ENER\",IF(VALUE(MID(V20,3,2))<10,\"L-SER\")))))","v":"ENER"},"5610K14147","LGH060H4EH1Y","2010-10-01",{"$f":"(TODAY()-AC20)/365","v":12.443835616438356},{"$f":"IF(ISBLANK(AA20),\"NODATA\",IF(MID(AB20,1,2)=\"RN\",\"AAON\",IF(LEN(AB20)>15,\"WeatherMaker\",IF(VALUE(MID(AA20,3,2))>9,\"ENER\",IF(VALUE(MID(AA20,3,2))<10,\"L-SER\")))))","v":"ENER"},"5610K13975","LGH150S4BH1Y","2010-10-01",{"$f":"(TODAY()-AH20)/365","v":12.443835616438356},{"$f":"IF(ISBLANK(AF20),\"NODATA\",IF(LEN(AG20)>15,\"WeatherMaker\",IF(VALUE(MID(AF20,3,2))>9,\"ENER\",IF(VALUE(MID(AF20,3,2))<10,\"L-SER\"))))","v":"ENER"},"5610L00584","LGH060H4EH1Y","2010-11-01",{"$f":"(TODAY()-AM20)/365","v":12.358904109589041},{"$f":"IF(ISBLANK(AK20),\"NODATA\",IF(LEN(AL20)>15,\"WeatherMaker\",IF(VALUE(MID(AK20,3,2))>9,\"ENER\",IF(VALUE(MID(AK20,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,"LGH150S4BH5Y"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,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":9,"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"]