{"text_format":"1","workbook":"xlsx","n_sheets":11,"sheets":["Survey","RTU1","RTU2","RTU3","RTU4","RTU5","RTU6","BR EF","Store Data","Drop Menus","SYNEXIS"],"not_rendered":{"charts":0,"images":2,"macros":1,"external_links":3,"defined_names":2,"comments":1,"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":[[137,4,137,66],[138,4,138,66],[139,4,139,66],[140,4,140,66],[5,38,5,58],[19,18,19,20],[23,30,23,32],[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],[7,55,7,58],[8,55,8,58],[55,1,55,2],[57,1,57,2],[59,1,59,2],[61,36,61,38],[61,1,61,2],[67,18,67,20],[57,3,57,14],[57,30,57,32],[49,30,49,32],[11,44,11,50],[11,59,11,63],[39,27,39,29],[29,42,29,44],[25,18,25,20],[42,1,42,66],[37,18,37,20],[41,21,41,23],[39,45,39,47],[39,42,39,44],[37,39,37,41],[40,1,40,66],[38,1,38,66],[5,59,5,80],[134,4,134,66],[135,4,135,66],[136,4,136,66],[69,36,69,38],[55,60,55,62],[49,57,49,59],[56,1,56,66],[55,27,55,29],[29,18,29,20],[39,18,39,20],[41,42,41,44],[37,54,37,56],[37,57,37,59],[37,33,37,35],[39,60,39,62],[43,60,43,62],[33,27,33,29],[33,48,33,50],[33,39,33,41],[33,57,33,59],[35,42,35,44],[45,42,45,44],[37,42,37,44],[31,42,31,44],[69,48,69,50],[23,33,23,35],[151,46,151,50],[37,45,37,47],[86,1,86,66],[83,39,83,41],[87,21,87,23],[97,54,97,56],[88,1,88,66],[91,21,91,23],[91,24,91,26],[97,45,97,47],[89,27,89,29],[89,33,89,35],[95,15,95,17],[95,18,95,20],[87,15,87,17],[87,33,87,35],[29,36,29,38],[113,38,113,47],[35,60,35,62],[33,42,33,44],[53,18,53,20],[33,21,33,23],[33,45,33,47],[59,33,59,35],[49,36,49,38],[59,60,59,62],[63,60,63,62],[61,54,61,56],[53,57,53,59],[12,59,12,63],[14,59,14,63],[14,70,14,73],[53,1,53,2],[57,33,57,35],[51,18,51,20],[61,15,61,17],[31,48,31,50],[33,30,33,32],[55,18,55,20],[55,24,55,26],[55,48,55,50],[39,54,39,56],[33,18,33,20],[89,48,89,50],[32,1,32,66],[53,63,53,65],[69,63,69,65],[49,63,49,65],[61,51,61,53],[55,36,55,38],[53,3,53,14],[53,36,53,38],[53,45,53,47],[53,48,53,50],[55,30,55,32],[31,15,31,17],[31,18,31,20],[63,57,63,59],[55,57,55,59],[6,82,6,91],[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],[10,70,10,73],[6,70,6,73],[11,70,11,73],[12,70,12,73],[8,64,8,69],[0,72,0,80],[0,56,0,71],[1,65,1,80],[1,56,1,64],[2,56,2,64],[1,45,1,55],[2,45,2,55],[1,43,1,44],[2,43,2,44],[2,65,2,80],[13,64,13,69],[14,64,14,69],[14,34,14,43],[13,44,13,50],[9,74,9,80],[13,74,13,80],[10,44,10,50],[9,55,9,58],[9,70,9,73],[1,32,1,42],[2,32,2,42],[11,34,11,43],[6,34,6,43],[7,31,7,33],[7,44,7,50],[2,19,2,31],[11,23,11,25],[11,31,11,33],[3,74,3,80],[13,34,13,43],[12,44,12,50],[4,74,4,80],[6,74,6,80],[7,74,7,80],[8,74,8,80],[10,74,10,80],[11,74,11,80],[0,36,0,55],[0,22,0,35],[4,30,4,39],[8,59,8,63],[9,59,9,63],[6,64,6,69],[11,26,11,30],[11,12,11,22],[3,40,3,44],[4,45,4,50],[10,26,10,30],[8,31,8,33],[9,31,9,33],[10,31,10,33],[4,40,4,44],[3,62,3,73],[3,55,3,61],[5,35,5,37],[3,51,3,54],[3,30,3,39],[10,34,10,43],[7,34,7,43],[8,34,8,43],[6,44,6,50],[7,70,7,73],[8,70,8,73],[0,1,0,8],[0,9,0,17],[0,18,0,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],[10,59,10,63],[39,33,39,35],[29,45,29,47],[23,36,23,38],[37,60,37,62],[3,45,3,50],[37,3,37,14],[37,15,37,17],[39,51,39,53],[39,39,39,41],[37,36,37,38],[35,63,35,65],[39,21,39,23],[39,24,39,26],[35,18,35,20],[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],[77,48,77,50],[65,3,65,14],[67,27,67,29],[75,15,75,17],[77,15,77,17],[77,30,77,32],[71,51,71,53],[63,54,63,56],[81,48,81,50],[77,24,77,26],[79,36,79,38],[79,24,79,26],[75,51,75,53],[65,45,65,47],[63,15,63,17],[61,24,61,26],[53,24,53,26],[60,1,60,66],[59,24,59,26],[59,3,59,14],[55,15,55,17],[47,57,47,59],[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],[55,33,55,35],[55,51,55,53],[53,54,53,56],[53,33,53,35],[51,45,51,47],[55,39,55,41],[55,45,55,47],[51,15,51,17],[52,1,52,66],[57,21,57,23],[59,18,59,20],[59,48,59,50],[59,21,59,23],[43,21,43,23],[43,48,43,50],[47,42,47,44],[47,33,47,35],[47,54,47,56],[44,1,44,66],[45,39,45,41],[45,63,45,65],[43,54,43,56],[48,1,48,66],[43,45,43,47],[43,51,43,53],[43,24,43,26],[57,36,57,38],[57,63,57,65],[57,48,57,50],[57,54,57,56],[49,15,49,17],[47,15,47,17],[43,15,43,17],[45,15,45,17],[51,54,51,56],[51,57,51,59],[51,60,51,62],[49,54,49,56],[45,30,45,32],[55,42,55,44],[53,27,53,29],[49,27,49,29],[49,33,49,35],[53,42,53,44],[49,45,49,47],[53,21,53,23],[39,15,39,17],[41,15,41,17],[41,18,41,20],[41,33,41,35],[45,24,45,26],[45,54,45,56],[39,36,39,38],[47,21,47,23],[49,21,49,23],[51,24,51,26],[46,1,46,66],[47,48,47,50],[41,3,41,14],[51,3,51,14],[51,27,51,29],[49,42,49,44],[49,24,49,26],[43,33,43,35],[43,36,43,38],[49,48,49,50],[45,45,45,47],[43,63,43,65],[43,42,43,44],[41,54,41,56],[39,63,39,65],[49,3,49,14],[45,18,45,20],[47,30,47,32],[47,51,47,53],[47,45,47,47],[51,39,51,41],[43,18,43,20],[27,27,27,29],[26,1,26,66],[27,63,27,65],[29,51,29,53],[29,63,29,65],[47,24,47,26],[47,63,47,65],[51,63,51,65],[45,60,45,62],[41,57,41,59],[41,36,41,38],[41,27,41,29],[37,21,37,23],[47,39,47,41],[47,36,47,38],[51,36,51,38],[50,1,50,66],[47,3,47,14],[34,1,34,66],[33,54,33,56],[43,3,43,14],[37,24,37,26],[27,54,27,56],[27,21,27,23],[29,39,29,41],[29,33,29,35],[33,24,33,26],[31,30,31,32],[35,36,35,38],[35,39,35,41],[35,30,35,32],[35,57,35,59],[27,57,27,59],[27,48,27,50],[27,60,27,62],[29,24,29,26],[29,27,29,29],[27,33,27,35],[31,21,31,23],[33,33,33,35],[27,30,27,32],[35,45,35,47],[35,48,35,50],[35,21,35,23],[27,42,27,44],[35,24,35,26],[33,36,33,38],[31,33,31,35],[31,39,31,41],[35,27,35,29],[31,60,31,62],[29,48,29,50],[35,33,35,35],[33,63,33,65],[31,57,31,59],[27,51,27,53],[29,21,29,23],[21,60,21,62],[21,54,21,56],[19,24,19,26],[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],[27,36,27,38],[29,30,29,32],[18,1,18,66],[14,1,14,3],[14,4,14,11],[19,33,19,35],[25,21,25,23],[29,57,29,59],[14,12,14,22],[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],[19,57,19,59],[19,42,19,44],[21,42,21,44],[23,27,23,29],[24,1,24,66],[23,18,23,20],[23,48,23,50],[21,45,21,47],[21,24,21,26],[21,63,21,65],[1,1,1,4],[9,1,9,3],[6,23,6,25],[7,23,7,25],[10,12,10,22],[1,5,1,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],[3,21,3,29],[4,21,4,29],[11,1,11,3],[11,4,11,11],[8,26,8,30],[3,1,3,9],[4,1,4,9],[8,12,8,22],[2,5,2,18],[2,1,2,4],[3,10,3,20],[7,26,7,30],[9,12,9,22],[9,26,9,30],[4,10,4,20],[1,19,1,31],[69,33,69,35],[31,63,31,65],[31,45,31,47],[31,51,31,53],[49,51,49,53],[12,4,12,11],[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],[27,45,27,47],[27,39,27,41],[27,15,27,17],[23,57,23,59],[25,48,25,50],[21,57,21,59],[21,51,21,53],[25,39,25,41],[77,39,77,41],[73,39,73,41],[71,57,71,59],[73,60,73,62],[75,39,75,41],[77,33,77,35],[77,1,77,2],[77,45,77,47],[79,1,79,2],[81,1,81,2],[97,24,97,26],[83,21,83,23],[85,39,85,41],[81,60,81,62],[73,51,73,53],[73,33,73,35],[73,27,73,29],[72,1,72,66],[85,48,85,50],[73,63,73,65],[77,51,77,53],[75,48,75,50],[77,42,77,44],[75,63,75,65],[85,24,85,26],[83,57,83,59],[73,54,73,56],[89,15,89,17],[51,30,51,32],[54,1,54,66],[51,33,51,35],[51,51,51,53],[71,3,71,14],[49,60,49,62],[49,39,49,41],[55,63,55,65],[53,60,53,62],[59,27,59,29],[69,39,69,41],[63,39,63,41],[67,45,67,47],[67,24,67,26],[63,36,63,38],[65,18,65,20],[67,54,67,56],[63,3,63,14],[71,27,71,29],[69,18,69,20],[69,42,69,44],[69,45,69,47],[69,21,69,23],[61,45,61,47],[61,42,61,44],[55,3,55,14],[67,1,67,2],[67,42,67,44],[69,57,69,59],[61,27,61,29],[61,21,61,23],[69,27,69,29],[85,15,85,17],[87,24,87,26],[97,60,97,62],[91,30,91,32],[83,51,83,53],[81,45,81,47],[83,27,83,29],[97,30,97,32],[83,30,83,32],[81,39,81,41],[81,51,81,53],[87,60,87,62],[87,36,87,38],[99,57,99,59],[87,27,87,29],[81,33,81,35],[85,60,85,62],[83,36,83,38],[85,54,85,56],[95,39,95,41],[83,33,83,35],[97,33,97,35],[89,21,89,23],[87,39,87,41],[92,1,92,66],[93,39,93,41],[97,1,97,2],[93,15,93,17],[81,36,81,38],[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,33,103,35],[93,60,93,62],[93,45,93,47],[101,3,101,14],[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],[302,34,302,41],[302,59,302,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],[150,57,150,61],[152,25,152,29],[114,1,114,36],[113,30,113,36],[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],[147,10,147,14],[122,1,124,3],[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],[142,2,142,80],[149,70,149,73],[153,51,153,56],[147,46,147,50],[151,20,151,24],[146,32,147,35],[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],[146,36,147,40],[152,41,152,45],[153,62,153,66],[151,41,151,45],[156,70,156,73],[156,74,156,80],[152,10,152,14],[153,20,153,24],[153,25,153,29],[154,51,154,56],[153,3,153,9],[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],[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],[152,70,152,73],[153,41,153,45],[154,41,154,45],[155,41,155,45],[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],[100,1,100,66],[97,21,97,23],[105,57,105,59],[105,15,105,17],[97,18,97,20],[97,36,97,38],[97,39,97,41],[97,42,97,44],[97,3,97,14],[101,60,101,62],[105,18,105,20],[105,24,105,26],[105,30,105,32],[101,1,101,2],[99,15,99,17],[93,1,93,2],[91,15,91,17],[93,24,93,26],[83,48,83,50],[83,24,83,26],[99,3,99,14],[97,15,97,17],[91,3,91,14],[91,42,91,44],[95,36,95,38],[67,39,67,41],[71,48,71,50],[61,30,61,32],[71,33,71,35],[69,60,69,62],[67,36,67,38],[63,63,63,65],[63,48,63,50],[65,60,65,62],[71,54,71,56],[66,1,66,66],[69,24,69,26],[79,51,79,53],[81,30,81,32],[67,33,67,35],[63,42,63,44],[71,45,71,47],[71,21,71,23],[71,63,71,65],[67,63,67,65],[81,63,81,65],[73,24,73,26],[77,3,77,14],[63,18,63,20],[79,42,79,44],[75,33,75,35],[65,1,65,2],[75,1,75,2],[77,60,77,62],[73,1,73,2],[75,36,75,38],[64,1,64,66],[13,4,13,11],[43,39,43,41],[45,57,45,59],[67,48,67,50],[8,44,8,50],[9,44,9,50],[6,55,6,58],[43,30,43,32],[41,63,41,65],[45,33,45,35],[45,48,45,50],[27,24,27,26],[35,54,35,56],[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],[8,4,8,11],[9,4,9,11],[6,4,6,11],[6,31,6,33],[27,18,27,20],[29,3,29,14],[28,1,28,66],[29,54,29,56],[27,3,27,14],[12,12,12,22],[12,26,12,30],[13,26,13,30],[14,26,14,30],[12,31,12,33],[19,39,19,41],[19,3,19,14],[21,39,21,41],[69,1,69,2],[69,51,69,53],[65,57,65,59],[65,36,65,38],[75,21,75,23],[71,24,71,26],[65,39,65,41],[65,33,65,35],[85,18,85,20],[81,21,81,23],[89,51,89,53],[83,60,83,62],[65,21,65,23],[85,1,85,2],[83,15,83,17],[83,1,83,2],[83,3,83,14],[67,15,67,17],[69,15,69,17],[71,15,71,17],[75,27,75,29],[71,30,71,32],[65,24,65,26],[65,42,65,44],[73,15,73,17],[75,30,75,32],[73,30,73,32],[53,51,53,53],[43,57,43,59],[59,63,59,65],[7,64,7,69],[9,34,9,43],[19,48,19,50],[19,51,19,53],[14,31,14,33],[4,55,4,61],[4,51,4,54],[41,60,41,62],[39,30,39,32],[59,51,59,53],[5,1,5,34],[12,34,12,43],[45,27,45,29],[41,51,41,53],[21,33,21,35],[19,27,19,29],[19,36,19,38],[41,24,41,26],[41,30,41,32],[41,48,41,50],[4,62,4,73],[8,1,8,3],[7,4,7,11],[39,48,39,50],[39,57,39,59],[14,23,14,25],[19,21,19,23],[7,1,7,3],[6,1,6,3],[45,21,45,23],[87,30,87,32],[95,51,95,53],[93,36,93,38],[93,27,93,29],[85,57,85,59],[45,36,45,38],[89,18,89,20]],"merged_total":1339,"flags":["merged_cut"]}
[null,"TAB Partner -",null,null,null,null,null,null,null,{"$f":"'Store Data'!H10","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":"'Store Data'!B10","v":"2023-08-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":"'Store Data'!A10","v":2175},null,null,null,{"$f":"'Store Data'!D10","v":"Mechanicsburg (VA) FSU"},null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"'Store Data'!I10","v":"7285 Battle Hill Drive"},null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"'Store Data'!J10","v":"Mechanicsville"},null,null,null,null,null,null,null,null,null,null,{"$f":"'Store Data'!K10","v":"VA"},null,{"$f":"'Store Data'!L10","v":"Mark Baldwin"},null,null,null,null,null,null,null,null,null,null,{"$f":"'Store Data'!T10","v":8047302638},null,null,null,null,null,null,null,null,{"$f":"'Store Data'!U10","v":"02175@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":"'Store Data'!O10","v":"Scott Lawhorne"},null,null,null,null,null,null,null,null,{"$f":"'Store Data'!P10","v":"Jim Anderson"},null,null,null,null,null,null,null,null,null,null,{"$f":"'Store Data'!M10","v":"Pamela Fowler"},null,null,null,null,null,null,null,null,{"$f":"'Store Data'!Q10","v":"Jeff Weaver"},null,null,null,null,null,null,null,null,null,{"$f":"'Store Data'!F10","v":"S06C-R"},null,null,null,null,{"$f":"'Store Data'!S10","v":"2008-06-12"},null,null,null,null,null,{"$f":"(TODAY()-AT5)/365","v":15.180821917808219},null,null,null,{"$f":"'Store Data'!C10","v":"2024-04-06"},null,null,null,null,null,null,{"$f":"'Store Data'!E10","v":"OC/BI"},null,null,null,null,null,null,null,null,null,null,null,{"$f":"'Store Data'!R10","v":"HFR"}]
[null,"SYNEXIS - ACTIVE/INACTIVE/NOT INSTALLED",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"IFERROR(VLOOKUP(B3,SYNEXIS!A2:C418,2,FALSE),\"NOT INSTALLED\")","v":"NOT INSTALLED"}]
[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":"'Store Data'!N10","v":"Tim Colburn"}]
[null,"AC1",null,null,{"$f":"'Store Data'!V10","v":"5616G11275"},null,null,null,null,null,null,null,{"$f":"'Store Data'!W10","v":"LGH30054H3Y"},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":"25"},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":"'Store Data'!Y10","v":7.1232876712328768},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(MID(M8,1,3)=\"KGB\",\"LANDMARK\",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(AO5,1,7)=\"S97-100\",\"RR/DIN A/ENTA\",IF(MID(AO5,1,7)=\"S97-110\",\"RR/DIN A/ENT A\",IF(MID(AO5,1,7)=\"S97-120\",\"RR/DIN A\",IF(MID(AO5,1,7)=\"S97-136\",\"RR/DIN A\",IF(MID(AO5,1,7)=\"S97-138\",\"RR/DIN A\",IF(MID(AO5,1,4)=\"S03A\",\"KITCHEN\",IF(MID(AO5,1,4)=\"S03C\",\"KITCHEN\",IF(MID(AO5,1,4)=\"S03E\",\"KITCHEN\",IF(MID(AO5,1,7)=\"S03-128\",\"KITHEN\",IF(MID(AO5,1,7)=\"S03-146\",\"KITCHEN\",IF(MID(AO5,1,9)=\"S03-150SW\",\"KITCHEN\",IF(MID(AO5,1,7)=\"S04-110\",\"KITCHEN\",IF(MID(AO5,1,3)=\"S04\",\"Kitchen\",IF(MID(AO5,1,4)=\"S06A\",\"KITCHEN\",IF(MID(AO5,1,4)=\"S06B\",\"KITCHEN\",IF(MID(AO5,1,4)=\"S06C\",\"KITCHEN\",IF(MID(AO5,1,4)=\"S06E\",\"KITCHEN\",IF(MID(AO5,1,7)=\"S08N SM\",\"KITCHEN\",IF(MID(AO5,1,4)=\"S08A\",\"KITCHEN\",IF(MID(AO5,1,4)=\"S08C\",\"KITCHEN/ELEC\",IF(MID(AO5,1,4)=\"S08E\",\"KITCHEN\",IF(MID(AO5,1,6)=\"S08N-T\",\"KITCHEN\",IF(MID(AO5,1,7)=\"S08N-LG\",\"KITCHEN\",IF(MID(AO5,9,2)=\"AZ\",\"KITCHEN\",IF(MID(AO5,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":"'Store Data'!AA10","v":"5621A08753"},null,null,null,null,null,null,null,{"$f":"'Store Data'!AB10","v":"LGH102H48H4Y"},null,null,null,null,null,null,null,null,null,null,{"$f":"IF(MID(M9,7,2)=\"05\",\"4\",IF(MID(M9,7,2)=\"06\",\"5\",IF(MID(M9,7,2)=\"07\",\"6\",IF(MID(M9,7,2)=\"08\",\"7.5\",IF(MID(M9,7,2)=\"09\",\"8.5\",IF(MID(M9,7,2)=\"12\",\"10\",IF(MID(M9,7,2)=\"14\",\"12.5\",IF(MID(M9,7,2)=\"16\",\"15\",IF(MID(M9,4,3)=\"300\",\"25\",IF(MID(M9,4,3)=\"210\",\"17.5\",IF(MID(M9,4,3)=\"180\",\"15\",IF(MID(M9,4,3)=\"150\",\"12.5\",IF(MID(M9,4,3)=\"120\",\"10\",IF(MID(M9,4,3)=\"102\",\"8.5\",IF(MID(M9,4,3)=\"090\",\"7.5\",IF(MID(M9,4,3)=\"092\",\"7.5\",IF(MID(M9,4,3)=\"072\",\"6\",IF(MID(M9,4,3)=\"060\",\"5\",IF(MID(M9,4,3)=\"036\",\"3\",IF(MID(M9,4,3)=\"048\",\"4\",\"\"))))))))))))))))))))","v":"8.5"},null,null,{"$f":"IF(ISBLANK(M9),\"\",IF(MID(M9,1,2)=\"RN\",\"AAON\",IF(MID(M9,1,3)=\"LHC\",\"Lennox\",IF(MID(M9,1,3)=\"LHA\",\"Lennox\",IF(MID(M9,1,3)=\"KHA\",\"Lennox\",IF(MID(M9,1,3)=\"LCH\",\"Lennox\",IF(MID(M9,1,3)=\"LCA\",\"Lennox\",IF(MID(M9,1,3)=\"LGA\",\"Lennox\",IF(MID(M9,1,3)=\"LGH\",\"Lennox\",\"Carrier\")))))))))","v":"Lennox"},null,null,null,null,{"$f":"'Store Data'!AD10","v":2.6164383561643834},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(MID(M9,1,3)=\"KGB\",\"LANDMARK\",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(AO5,1,7)=\"S97-100\",\"KITCHEN\",IF(MID(AO5,1,7)=\"S97-110\",\"KITCHEN\",IF(MID(AO5,1,7)=\"S97-120\",\"KITCHEN\",IF(MID(AO5,1,7)=\"S97-136\",\"KITCHEN\",IF(MID(AO5,1,7)=\"S97-138\",\"KITCHEN\",IF(MID(A5,1,4)=\"S03A\",\"SERV/ENT A/\",IF(MID(AO5,1,4)=\"S03C\",\"MECH/RR/DIN A\",IF(MID(AO5,1,4)=\"S03E\",\"MECH/RR/DINA\",IF(MID(AO5,1,7)=\"S03-128\",\"RR/DIN A/MECH/ELEC\",IF(MID(AO5,1,7)=\"S03-146\",\"RR/DIN A\",IF(MID(AO5,1,9)=\"S03-150SW\",\"RR/DIN A/MECH\",IF(MID(AO5,1,7)=\"S04-110\",\"MECH/RR/DIN A\",IF(MID(AO5,1,3)=\"S04\",\"Mech/RR/Din A\",IF(MID(AO5,1,4)=\"S06A\",\"ENT A/SERV/DT\",IF(MID(AO5,1,4)=\"S06B\",\"MECH/RR/DIN A\",IF(MID(AO5,1,4)=\"S06C\",\"MECH/RR/DIN A\",IF(MID(AO5,1,4)=\"S06E\",\"MECH/RR/DIN A\",IF(MID(AO5,1,4)=\"S08A\",\"DT/SERV/ENT\",IF(MID(AO5,1,4)=\"S08C\",\"DIN A/RR/MECH/BRK\",IF(MID(AO5,1,4)=\"S08E\",\"DIN A/RR/BRK RM/MECH\",IF(MID(AO5,1,6)=\"S08N-T\",\"MECH/RR/DIN A/ENT A\",IF(MID(AO5,1,7)=\"S08N SM\",\"MECH/RR/DIN A/ENT A\",IF(MID(AO5,1,7)=\"S08N-LG\",\"MECH/RR/DIN A/ENT A\",IF(MID(AO5,9,2)=\"AZ\",\"DINING\",IF(MID(AO5,1,2)=\"KK\",\"RR/DIN A,/ENT A\",\"\")))))))))))))))))))))))))","v":"MECH/RR/DIN A"},null,null,null,null,null,null,{"$f":"VALUE(IF(AB20=15,\"2518\",IF(AB20=12.5,\"2518\",IF(AB20=10,\"2352\",IF(AB20=8.5,\"2352\",IF(AB20=7.5,\"1911\",IF(AB20=6,\"1911\",IF(AB20=5,\"1828\",IF(AB20=4,\"1828\",\"0\")))))))))","v":0},null,null,null,{"$f":"VALUE(IF(AB22=15,\"9662\",IF(AB22=12.5,\"9662\",IF(AB22=10,\"6452\",IF(AB22=8.5,\"6452\",IF(AB22=7.5,\"5397\",IF(AB22=6,\"5397\",IF(AB22=5,\"4161\",IF(AB22=4,\"4151\",\"0\")))))))))","v":0},null,null,null,{"$f":"VALUE(IF(AB$24=15,\"475\",IF(AB$24=12.5,\"475\",IF(AB$24=10,\"475\",IF(AB$24=8.5,\"475\",IF(AB$24=7.5,\"475\",IF(AB$24=6,\"475\",IF(AB$24=5,\"475\",IF(AB$24=4,\"475\",\"0\")))))))))","v":0},null,null,null,null,{"$f":"VALUE(IF(AB$26=15,\"9662\",IF(AB$26=12.5,\"9662\",IF(AB$26=10,\"6452\",IF(AB$26=8.5,\"6452\",IF(AB$26=7.5,\"5397\",IF(AB$26=6,\"5397\",IF(AB$26=5,\"4161\",IF(AB$26=4,\"4161\",\"0\")))))))))","v":0},null,null,null,null,null,{"$f":"VALUE(IF(AB$28=15,\"537\",IF(AB$28=12.5,\"537\",IF(AB$28=10,\"537\",IF(AB$28=8.5,\"537\",IF(AB$28=7.5,\"437\",IF(AB$28=6,\"537\",IF(AB$28=5,\"537\",IF(AB$28=4,\"537\",\"0\")))))))))","v":0},null,null,null,0]
[null,"AC3",null,null,{"$f":"'Store Data'!AF10","v":"5608C00742"},null,null,null,null,null,null,null,{"$f":"'Store Data'!AG10","v":"LGA120H2BH3Y"},null,null,null,null,null,null,null,null,null,null,"10",null,null,"Lennox",null,null,null,null,{"$f":"'Store Data'!AI10","v":15.463013698630137},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(MID(M10,1,3)=\"KGB\",\"LANDMARK\",IF(COUNT(FIND({5610,5611,5612,5613,5614,5615,5616,5617,5618,5619,5620,5621},E10))>0,\"ENERGENCE\",\"L SERIES\"))))))))))))","v":"L SERIES"},null,null,null,null,null,null,null,null,null,{"$f":"IF(MID(AO5,1,7)=\"S97-100\",\"SERV/DT/ENT B\",IF(MID(AO5,1,7)=\"S97-110\",\"SERV/DT/ENT B\",IF(MID(AO5,1,7)=\"S97-120\",\"SERV/DIN B/DT\",IF(MID(AO5,1,7)=\"S97-136\",\"SERV/DT/ENTB\",IF(MID(AO5,1,7)=\"S97-138\",\"SERV/DT/DIN B/ENT B\",IF(MID(AO5,1,4)=\"S03A\",\"DIN B/RR\",IF(MID(AO5,1,4)=\"S03C\",\"SERV/DT/DIN B/ENT B\",IF(MID(AO5,1,4)=\"S03E\",\"SERV/DIN B/ENT A&B\",IF(MID(AO5,1,7)=\"S03-128\",\"SERV/DIN B/ENT B/DT\",IF(MID(AO5,1,7)=\"S03-146\",\"ENT A/DIN B\",IF(MID(AO5,1,9)=\"S03-150SW\",\"ENT A/DIN B\",IF(MID(AO5,1,7)=\"S04-110\",\"DT/SERV/DIN B/ENT A&B\",IF(MID(AO5,1,3)=\"S04\",\"SERV/DT/DIN B/ENT B\",IF(MID(AO5,1,4)=\"S06A\",\"RR/DIN\",IF(MID(AO5,1,4)=\"S06B\",\"DT/SERV/DIN B/ENT B\",IF(MID(AO5,1,4)=\"S06C\",\"SERV/DT/DIN B/ENT B\",IF(MID(AO5,1,4)=\"S06E\",\"SERV/ENTA/ENTB,/DIN B\",IF(MID(AO5,1,4)=\"S08A\",\"RR/DINING\",IF(MID(AO5,1,4)=\"S08C\",\"DINB/SERV/DT/ENT B\",IF(MID(AO5,1,4)=\"S08E\",\"DINB/SERV/DT/ENT A&B\",IF(MID(AO5,1,6)=\"S08N-T\",\"DIN B\",IF(MID(AO5,1,7)=\"S08N SM\",\"DINB/SERV/DT\",IF(MID(AO5,1,7)=\"S08N-LG\",\"DIN B\",IF(MID(AO5,9,2)=\"AZ\",\"ENTRY/DINING\",IF(MID(AO5,1,2)=\"KK\",\"DIN B\",\"\")))))))))))))))))))))))))","v":"SERV/DT/DIN B/ENT B"},null,null,null,null,null,null,{"$f":"VALUE(IF(AH20=15,\"2518\",IF(AH20=12.5,\"2518\",IF(AH20=10,\"2352\",IF(AH20=8.5,\"2352\",IF(AH20=7.5,\"1911\",IF(AH20=6,\"1911\",IF(AH20=5,\"1828\",IF(AH20=4,\"1828\",\"0\")))))))))","v":0},null,null,null,{"$f":"VALUE(IF(AH22=15,\"9662\",IF(AH22=12.5,\"9662\",IF(AH22=10,\"6452\",IF(AH22=8.5,\"6452\",IF(AH22=7.5,\"5397\",IF(AH22=6,\"5397\",IF(AH22=5,\"4161\",IF(AH22=4,\"4151\",\"0\")))))))))","v":0},null,null,null,{"$f":"VALUE(IF(AH$24=15,\"475\",IF(AH$24=12.5,\"475\",IF(AH$24=10,\"475\",IF(AH$24=8.5,\"475\",IF(AH$24=7.5,\"475\",IF(AH$24=6,\"475\",IF(AH$24=5,\"475\",IF(AH$24=4,\"475\",\"0\")))))))))","v":0},null,null,null,null,{"$f":"VALUE(IF(AH$26=15,\"9662\",IF(AH$26=12.5,\"9662\",IF(AH$26=10,\"6452\",IF(AH$26=8.5,\"6452\",IF(AH$26=7.5,\"5397\",IF(AH$26=6,\"5397\",IF(AH$26=5,\"4161\",IF(AH$26=4,\"4161\",\"0\")))))))))","v":0},null,null,null,null,null,{"$f":"VALUE(IF(AH$28=15,\"537\",IF(AH$28=12.5,\"537\",IF(AH$28=10,\"537\",IF(AH$28=8.5,\"537\",IF(AH$28=7.5,\"437\",IF(AH$28=6,\"537\",IF(AH$28=5,\"537\",IF(AH$28=4,\"537\",\"0\")))))))))","v":0},null,null,null,0]
[null,"AC4",null,null,{"$f":"'Store Data'!AK10","v":"5608C00861"},null,null,null,null,null,null,null,{"$f":"'Store Data'!AL10","v":"LGA090H2BH2Y"},null,null,null,null,null,null,null,null,null,null,"7.5",null,null,"Lennox",null,null,null,null,{"$f":"'Store Data'!AN10","v":15.463013698630137},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(MID(M11,1,3)=\"KGB\",\"LANDMARK\",IF(COUNT(FIND({5610,5611,5612,5613,5614,5615,5616,5617,5618,5619,5620,5621},E11))>0,\"ENERGENCE\",\"L SERIES\"))))))))))))","v":"L SERIES"},null,null,null,null,null,null,null,null,null,{"$f":"IF(MID(AO5,1,7)=\"S97-100\",\"DIN B/ENT A\",IF(MID(AO5,1,7)=\"S97-110\",\"PLAYLAND\",IF(MID(AO5,1,7)=\"S97-120\",\"ENTA/DIN B\",IF(MID(AO5,1,7)=\"S97-136\",\"DIN B/ENT A\",IF(MID(AO5,1,7)=\"S97-138\",\"ENT A/DIN B\",IF(MID(AO5,1,4)=\"S03A\",\"PLAYLAND\",IF(MID(AO5,1,4)=\"S03C\",\"ENT A/DIN B\",IF(MID(AO5,1,4)=\"S03E\",\"PLAYLAND\",IF(MID(AO5,1,7)=\"S03-128\",\"ENT A/DIN B\",IF(MID(AO5,1,7)=\"S03-146\",\"SERV/DIN B\",IF(MID(AO5,1,9)=\"S03-150SW\",\"SERV/DIN B\",IF(MID(AO5,1,7)=\"S04-110\",\"PLAYLAND\",IF(MID(AO5,1,3)=\"S04\",\"ENTA/DIN B\",IF(MID(AO5,1,4)=\"S06A\",\"PLAYLAND\",IF(MID(AO5,1,4)=\"S06B\",\"ENT A/DIN B\",IF(MID(AO5,1,4)=\"S06C\",\"ENT A/DIN B\",IF(MID(AO5,1,4)=\"S06E\",\"PLAYLAND\",IF(MID(AO5,1,4)=\"S08A\",\"PLAYLAND\",IF(MID(AO5,1,4)=\"S08C\",\"DIN B/ENT A\",IF(MID(AO5,1,4)=\"S08E\",\"PLAYLAND\",IF(MID(AO5,1,6)=\"S08N-T\",\"DT,SERV/DIN B\",IF(MID(AO5,1,7)=\"S08N SM\",\"PLAYLAND\",IF(MID(AO5,1,7)=\"S08N-LG\",\"DT/SERV/DIN B\",IF(MID(AO5,9,2)=\"AZ\",\"SERV/DINING/RR/DT\",IF(MID(AO5,1,2)=\"KK\",\"SERV/DIN B\",\"\")))))))))))))))))))))))))","v":"ENT A/DIN B"},null,null,null,null,null,null,{"$f":"VALUE(IF(AN20=15,\"2518\",IF(AN20=12.5,\"2518\",IF(AN20=10,\"2352\",IF(AN20=8.5,\"2352\",IF(AN20=7.5,\"1911\",IF(AN20=6,\"1911\",IF(AN20=5,\"1828\",IF(AN20=4,\"1828\",\"0\")))))))))","v":0},null,null,null,{"$f":"VALUE(IF(AN22=15,\"9662\",IF(AN22=12.5,\"9662\",IF(AN22=10,\"6452\",IF(AN22=8.5,\"6452\",IF(AN22=7.5,\"5397\",IF(AN22=6,\"5397\",IF(AN22=5,\"4161\",IF(AN22=4,\"4151\",\"0\")))))))))","v":0},null,null,null,{"$f":"VALUE(IF(AN$24=15,\"475\",IF(AN$24=12.5,\"475\",IF(AN$24=10,\"475\",IF(AN$24=8.5,\"475\",IF(AN$24=7.5,\"475\",IF(AN$24=6,\"475\",IF(AN$24=5,\"475\",IF(AN$24=4,\"475\",\"0\")))))))))","v":0},null,null,null,null,{"$f":"VALUE(IF(AN$26=15,\"9662\",IF(AN$26=12.5,\"9662\",IF(AN$26=10,\"6452\",IF(AN$26=8.5,\"6452\",IF(AN$26=7.5,\"5397\",IF(AN$26=6,\"5397\",IF(AN$26=5,\"4161\",IF(AN$26=4,\"4161\",\"0\")))))))))","v":0},null,null,null,null,null,{"$f":"VALUE(IF(AN$28=15,\"537\",IF(AN$28=12.5,\"537\",IF(AN$28=10,\"537\",IF(AN$28=8.5,\"537\",IF(AN$28=7.5,\"437\",IF(AN$28=6,\"537\",IF(AN$28=5,\"537\",IF(AN$28=4,\"537\",\"0\")))))))))","v":0},null,null,null,0]
[null,"AC5",null,null,{"$f":"'Store Data'!AP10","v":"5608C00861"},null,null,null,null,null,null,null,{"$f":"'Store Data'!AQ10","v":"LGA060H2BH2Y"},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":"5"},null,null,"Lennox",null,null,null,null,{"$f":"'Store Data'!AS10","v":15.463013698630137},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(MID(M12,1,3)=\"KGB\",\"LANDMARK\",IF(COUNT(FIND({5610,5611,5612,5613,5614,5615,5616,5617,5618,5619,5620,5621},E12))>0,\"ENERGENCE\",\"L SERIES\"))))))))))))","v":"L SERIES"},null,null,null,null,null,null,null,null,null,{"$f":"IF(MID(AO5,1,7)=\"S97-120\",\"PLAY LAND\",IF(MID(AO5,1,7)=\"S97-136\",\"PLAYLAND\",IF(MID(AO5,1,7)=\"S97-138\",\"PLAYLAND\",IF(MID(AO5,1,4)=\"S03C\",\"PLAYLAND\",IF(MID(AO5,1,7)=\"S03-128\",\"PLAYLAND\",IF(MID(AO5,1,7)=\"S03-146\",\"PLAYLAND\",IF(MID(AO5,1,9)=\"S03-150SW\",\"PLAYLAND\",IF(MID(AO5,1,3)=\"S04\",\"PLAYLAND\",IF(MID(AO5,1,4)=\"S06B\",\"PLAYLAND\",IF(MID(AO5,1,4)=\"S06C\",\"PLAYLAND\",IF(MID(AO5,1,4)=\"S08C\",\"PLAYLAND\",IF(MID(AO5,1,6)=\"S08N-T\",\"PLAYLAND\",IF(MID(AO5,1,7)=\"S08N-LG\",\"PLAYLAND\",IF(MID(AO5,9,2)=\"AZ\",\"KITCHEN/OFFICE\",IF(MID(AO5,1,2)=\"KK\",\"PLAYLAND\",\"\")))))))))))))))","v":"PLAYLAND"},null,null,null,null,null,null,{"$f":"VALUE(IF(AT20=15,\"2518\",IF(AT20=12.5,\"2518\",IF(AT20=10,\"2352\",IF(AT20=8.5,\"2352\",IF(AT20=7.5,\"1911\",IF(AT20=6,\"1911\",IF(AT20=5,\"1828\",IF(AT20=4,\"1828\",\"0\")))))))))","v":0},null,null,null,{"$f":"VALUE(IF(AT22=15,\"9662\",IF(AT22=12.5,\"9662\",IF(AT22=10,\"6452\",IF(AT22=8.5,\"6452\",IF(AT22=7.5,\"5397\",IF(AT22=6,\"5397\",IF(AT22=5,\"4161\",IF(AT22=4,\"4151\",\"0\")))))))))","v":0},null,null,null,{"$f":"VALUE(IF(AT$24=15,\"475\",IF(AT$24=12.5,\"475\",IF(AT$24=10,\"475\",IF(AT$24=8.5,\"475\",IF(AT$24=7.5,\"475\",IF(AT$24=6,\"475\",IF(AT$24=5,\"475\",IF(AT$24=4,\"475\",\"0\")))))))))","v":0},null,null,null,null,{"$f":"VALUE(IF(AT$26=15,\"9662\",IF(AT$26=12.5,\"9662\",IF(AT$26=10,\"6452\",IF(AT$26=8.5,\"6452\",IF(AT$26=7.5,\"5397\",IF(AT$26=6,\"5397\",IF(AT$26=5,\"4161\",IF(AT$26=4,\"4161\",\"0\")))))))))","v":0},null,null,null,null,null,{"$f":"VALUE(IF(AT$28=15,\"537\",IF(AT$28=12.5,\"537\",IF(AT$28=10,\"537\",IF(AT$28=8.5,\"537\",IF(AT$28=7.5,\"437\",IF(AT$28=6,\"537\",IF(AT$28=5,\"537\",IF(AT$28=4,\"537\",\"0\")))))))))","v":0},null,null,null,0]
[null,"AC6",null,null,{"$f":"'Store Data'!AU10","v":"5616L12772"},null,null,null,null,null,null,null,{"$f":"'Store Data'!AV10","v":"LAH036H4S4Y"},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":"3"},null,null,{"$f":"IF(ISBLANK(M13),\"\",IF(MID(M13,1,2)=\"LG\",\"Lennox\",\"Carrier\"))","v":"Carrier"},null,null,null,null,{"$f":"'Store Data'!BC10","v":0},null,null,{"$f":"IF(ISBLANK(E13),\"\",IF(MID(M13,1,2)=\"RN\",\"RN SERIES\",IF(MID(M13,1,3)=\"YSC\",\"TRANE\",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,3,2)=\"HP\",\"HEAT PUMP\",IF(MID(M13,3,2)=\"KC\",\"WEAMaker SE\",IF(MID(M13,3,2)=\"FC\",\"WEAMaker EcoBlue\",IF(MID(M13,1,3)=\"KGB\",\"LANDMARK\",IF(COUNT(FIND({5610,5611,5612,5613,5614,5615,5616,5617,5618,5619,5620,5621},E13))>0,\"ENERGENCE\",\"L SERIES\"))))))))))))","v":"ENERGENCE"},null,null,null,null,null,null,null,null,null,{"$f":"IF(MID(AO5,1,7)=\"S04-162\",\"OFFICE/BREAK ROOM\",IF(MID(AO5,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,{"$f":"'Store Data'!AZ10","v":0},null,null,null,null,null,null,null,{"$f":"'Store Data'!BA10","v":0},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,"Carrier",null,null,null,null,{"$f":"'Store Data'!AP11","v":0},null,null,{"$f":"IF(ISBLANK(E14),\"\",IF(MID(M14,1,2)=\"RN\",\"RN SERIES\",IF(MID(M14,1,3)=\"YSC\",\"TRANE\",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(MID(M14,3,2)=\"HP\",\"HEAT PUMP\",IF(MID(M14,3,2)=\"KC\",\"WEAMaker SE\",IF(MID(M14,3,2)=\"FC\",\"WEAMaker EcoBlue\",IF(MID(M14,1,3)=\"KGB\",\"LANDMARK\",IF(COUNT(FIND({5610,5611,5612,5613,5614,5615,5616,5617,5618,5619,5620,5621},E14))>0,\"ENERGENCE\",\"L SERIES\"))))))))))))","v":"L SERIES"},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,{"$f":"IF(ISBLANK(E15),\"\",IF(MID(M15,1,2)=\"RN\",\"RN SERIES\",IF(MID(M15,1,3)=\"YSC\",\"TRANE\",IF(MID(M15,1,3)=\"50K\",\"WEAMaker SE\",IF(MID(M15,1,4)=\"48ES\",\"Comfort\",IF(MID(M15,1,3)=\"48H\",\"WEAMaster HE\",IF(MID(M15,1,3)=\"48T\",\"WEAMaker SE\",IF(MID(M15,3,2)=\"HP\",\"HEAT PUMP\",IF(MID(M15,3,2)=\"KC\",\"WEAMaker SE\",IF(MID(M15,3,2)=\"FC\",\"WEAMaker EcoBlue\",IF(MID(M15,1,3)=\"KGB\",\"LANDMARK\",IF(COUNT(FIND({5610,5611,5612,5613,5614,5615,5616,5617,5618,5619,5620,5621},E15))>0,\"ENERGENCE\",\"L SERIES\"))))))))))))","v":""},null,null,null,null,null,null,null,null,null,"TOTAL",null,null,null,null,null,null,{"$f":"VALUE(SUM(AZ8:AZ14))","v":0},null,null,null,{"$f":"SUM(BD8:BD14)","v":0},null,null,null,{"$f":"SUM(BH8:BH14)","v":0},null,null,null,null,{"$f":"SUM(BM8:BM14)","v":0},null,null,null,null,null,{"$f":"SUM(BS8:BS14)","v":0},null,null,null,0]
[null,"CRITICAL - Unable to Perform T & B Scope until Corrected by Responsible Party."]
[null,"REVIEW & RECTIFY - If no action is taken T&B can be performed, but system performance will suffer."]
[null,"NON-CRITICAL - Noted for consideration by project team, but not critical to system performance or fnctionality."]
[null,"1.  Using punch/screwdriver, prod heat exchanger tubes.  If holes found and/or or prod test fail enter unit tonnage and lock out."]
[null,null,null,"CRITICAL",null,null,null,null,null,null,null,null,null,null,null,null,null,null,"AC1",null,null,{"$f":"'RTU1'!J6","v":""},null,null,"AC2",null,null,{"$f":"'RTU2'!J6","v":""},null,null,"AC3",null,null,{"$f":"'RTU3'!J6","v":""},null,null,"AC4",null,null,{"$f":"'RTU4'!J6","v":""},null,null,"AC5",null,null,{"$f":"'RTU5'!J6","v":""},null,null,"AC6",null,null,{"$f":"IF(ISBLANK($E$13),\"N/A\",\"\")","v":""},null,null,"AC7",null,null,{"$f":"IF(ISBLANK($E$14),\"N/A\",\"\")","v":""},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":""},null,null,"AC3",null,null,{"$f":"'RTU3'!J7","v":""},null,null,"AC4",null,null,{"$f":"'RTU4'!J7","v":""},null,null,"AC5",null,null,{"$f":"'RTU5'!J7","v":""},null,null,"AC6",null,null,{"$f":"IF(ISBLANK($E$13),\"N/A\",\"\")","v":""},null,null,"AC7",null,null,{"$f":"IF(ISBLANK($E$14),\"N/A\",\"\")","v":""},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(AR3,1,2)=\"NC\",\"CRITICAL\",IF(MID(AR3,1,2)=\"IA\",\"CRITICAL\",IF(MID(AR3,1,2)=\"MN\",\"CRITICAL\",IF(MID(AR3,1,2)=\"TX\",\"CRITICAL\",IF(MID(AR3,1,2)=\"AR\",\"CRITICAL\",IF(MID(AR3,1,2)=\"OK\",\"CRITICAL\",IF(MID(AR3,1,2)=\"MO\",\"CRITICAL\",IF(MID(AR3,1,2)=\"KS\",\"CRITICAL\",IF(MID(AR3,1,3)=\"NEB\",\"CRITICAL\",IF(MID(AR3,1,2)=\"SD\",\"CRITICAL\",\"NON-CRITICAL\"))))))))))","v":"NON-CRITICAL"},null,null,null,null,null,null,null,null,null,null,null,null,null,null,"AC1",null,null,{"$f":"'RTU1'!J8","v":"N/A"},null,null,"AC2",null,null,{"$f":"'RTU2'!J8","v":""},null,null,"AC3",null,null,{"$f":"'RTU3'!J8","v":""},null,null,"AC4",null,null,{"$f":"'RTU4'!J8","v":""},null,null,"AC5",null,null,{"$f":"'RTU5'!J8","v":""},null,null,"AC6",null,null,{"$f":"IF(ISBLANK($E$13),\"N/A\",\"\")","v":""},null,null,"AC7",null,null,{"$f":"IF(ISBLANK($E$14),\"N/A\",\"\")","v":""},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":""},null,null,"AC3",null,null,{"$f":"'RTU3'!J9","v":""},null,null,"AC4",null,null,{"$f":"'RTU4'!J9","v":""},null,null,"AC5",null,null,{"$f":"'RTU5'!J9","v":""},null,null,"AC6",null,null,{"$f":"IF(ISBLANK($E$13),\"N/A\",\"\")","v":""},null,null,"AC7",null,null,{"$f":"IF(ISBLANK($E$14),\"N/A\",\"\")","v":""},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":"N/A"},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":""},null,null,"AC3",null,null,{"$f":"'RTU3'!J11","v":""},null,null,"AC4",null,null,{"$f":"'RTU4'!J11","v":""},null,null,"AC5",null,null,{"$f":"'RTU5'!J11","v":""},null,null,"AC6",null,null,{"$f":"IF(ISBLANK($E$13),\"N/A\",\"\")","v":""},null,null,"AC7",null,null,{"$f":"IF(ISBLANK($E$14),\"N/A\",\"\")","v":""},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":0},null,null,"AC2",null,null,{"$f":"'RTU2'!J12","v":0},null,null,"AC3",null,null,{"$f":"'RTU3'!J12","v":0},null,null,"AC4",null,null,{"$f":"'RTU4'!J12","v":0},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":"NO"},null,null,"AC7",null,null,{"$f":"IF(ISBLANK($E$14),\"N/A\",\"\")","v":""},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":""},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":""},null,null,"AC4",null,null,{"$f":"'RTU4'!J13","v":""},null,null,"AC5",null,null,{"$f":"'RTU5'!J13","v":""},null,null,"AC6",null,null,{"$f":"IF(ISBLANK($E$13),\"N/A\",\"\")","v":""},null,null,"AC7",null,null,{"$f":"IF(ISBLANK($E$14),\"N/A\",\"\")","v":""},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":0},null,null,"B2",null,null,{"$f":"P150","v":0},null,null,"B3",null,null,{"$f":"P151","v":0},null,null,"B4",null,null,{"$f":"P152","v":0},null,null,"B5",null,null,{"$f":"P153","v":0},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":0},null,null,"D3",null,null,{"$f":"AZ151","v":0},null,null,"D4",null,null,{"$f":"AZ152","v":0},null,null,"D5",null,null,{"$f":"AZ153","v":0},null,null,"D6",null,null,{"$f":"AZ154","v":0},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":0},null,null,"AC2",null,null,{"$f":"'RTU2'!J16","v":0},null,null,"AC3",null,null,{"$f":"'RTU3'!J16","v":""},null,null,"AC4",null,null,{"$f":"'RTU4'!J16","v":0},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":""},null,null,"AC2",null,null,{"$f":"'RTU2'!J17","v":""},null,null,"AC3",null,null,{"$f":"'RTU3'!J17","v":""},null,null,"AC4",null,null,{"$f":"'RTU4'!J17","v":""},null,null,"AC5",null,null,{"$f":"'RTU5'!J17","v":""},null,null,"AC6",null,null,{"$f":"IF(ISBLANK($E$13),\"N/A\",\"\")","v":""},null,null,"AC7",null,null,{"$f":"IF(ISBLANK($E$14),\"N/A\",\"\")","v":""},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":""},null,null,"AC2",null,null,{"$f":"'RTU2'!J18","v":""},null,null,"AC3",null,null,{"$f":"'RTU3'!J18","v":""},null,null,"AC4",null,null,{"$f":"'RTU4'!J18","v":""},null,null,"AC5",null,null,{"$f":"'RTU5'!J18","v":""},null,null,"AC6",null,null,{"$f":"IF(ISBLANK($E$13),\"N/A\",\"\")","v":""},null,null,"AC7",null,null,{"$f":"IF(ISBLANK($E$14),\"N/A\",\"\")","v":""},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":""},null,null,"AC2",null,null,{"$f":"'RTU2'!J19","v":""},null,null,"AC3",null,null,{"$f":"'RTU3'!J19","v":""},null,null,"AC4",null,null,{"$f":"'RTU4'!J19","v":""},null,null,"AC5",null,null,{"$f":"'RTU5'!J19","v":""},null,null,"AC6",null,null,{"$f":"IF(ISBLANK($E$13),\"N/A\",\"\")","v":""},null,null,"AC7",null,null,{"$f":"IF(ISBLANK($E$14),\"N/A\",\"\")","v":""},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":""},null,null,"AC2",null,null,{"$f":"'RTU2'!J20","v":""},null,null,"AC3",null,null,{"$f":"'RTU3'!J20","v":""},null,null,"AC4",null,null,{"$f":"'RTU4'!J20","v":""},null,null,"AC5",null,null,{"$f":"'RTU5'!J20","v":""},null,null,"AC6",null,null,{"$f":"IF(ISBLANK($E$13),\"N/A\",\"\")","v":""},null,null,"AC7",null,null,{"$f":"IF(ISBLANK($E$14),\"N/A\",\"\")","v":""},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":""},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":{"$error":"#VALUE!"}},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":""},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":{"$error":"#VALUE!"}},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":""},null,null,"AC3",null,null,{"$f":"'RTU3'!J23","v":""},null,null,"AC4",null,null,{"$f":"'RTU4'!J23","v":""},null,null,"AC5",null,null,{"$f":"'RTU5'!J23","v":""},null,null,"AC6",null,null,{"$f":"IF(ISBLANK($E$13),\"N/A\",\"\")","v":""},null,null,"AC7",null,null,{"$f":"IF(ISBLANK($E$14),\"N/A\",\"\")","v":""},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":""},null,null,"AC3",null,null,{"$f":"'RTU3'!J24","v":""},null,null,"AC4",null,null,{"$f":"'RTU4'!J24","v":""},null,null,"AC5",null,null,{"$f":"'RTU5'!J24","v":""},null,null,"AC6",null,null,{"$f":"IF(ISBLANK($E$13),\"N/A\",\"\")","v":""},null,null,"AC7",null,null,{"$f":"IF(ISBLANK($E$14),\"N/A\",\"\")","v":""},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":""},null,null,"AC3",null,null,{"$f":"'RTU3'!J25","v":""},null,null,"AC4",null,null,{"$f":"'RTU4'!J25","v":""},null,null,"AC5",null,null,{"$f":"'RTU5'!J25","v":""},null,null,"AC6",null,null,{"$f":"IF(ISBLANK($E$13),\"N/A\",\"\")","v":""},null,null,"AC7",null,null,{"$f":"IF(ISBLANK($E$14),\"N/A\",\"\")","v":""},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":""},null,null,"AC3",null,null,{"$f":"'RTU3'!J26","v":""},null,null,"AC4",null,null,{"$f":"'RTU4'!J26","v":""},null,null,"AC5",null,null,{"$f":"'RTU5'!J26","v":""},null,null,"AC6",null,null,{"$f":"IF(ISBLANK($E$13),\"N/A\",\"\")","v":""},null,null,"AC7",null,null,{"$f":"IF(ISBLANK($E$14),\"N/A\",\"\")","v":""},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":""},null,null,"AC3",null,null,{"$f":"'RTU3'!J27","v":""},null,null,"AC4",null,null,{"$f":"'RTU4'!J27","v":""},null,null,"AC5",null,null,{"$f":"'RTU5'!J27","v":""},null,null,"AC6",null,null,{"$f":"IF(ISBLANK($E$13),\"N/A\",\"\")","v":""},null,null,"AC7",null,null,{"$f":"IF(ISBLANK($E$14),\"N/A\",\"\")","v":""},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":""},null,null,"AC3",null,null,{"$f":"'RTU3'!J28","v":""},null,null,"AC4",null,null,{"$f":"'RTU4'!J28","v":""},null,null,"AC5",null,null,{"$f":"'RTU5'!J28","v":""},null,null,"AC6",null,null,{"$f":"IF(ISBLANK($E$13),\"N/A\",\"\")","v":""},null,null,"AC7",null,null,{"$f":"IF(ISBLANK($E$14),\"N/A\",\"\")","v":""},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":""},null,null,"AC3",null,null,{"$f":"'RTU3'!J29","v":""},null,null,"AC4",null,null,{"$f":"'RTU4'!J29","v":""},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":""},null,null,"AC3",null,null,{"$f":"'RTU3'!J30","v":""},null,null,"AC4",null,null,{"$f":"'RTU4'!J30","v":""},null,null,"AC5",null,null,{"$f":"'RTU5'!J30","v":""},null,null,"AC6",null,null,{"$f":"IF(ISBLANK($E$13),\"N/A\",\"\")","v":""},null,null,"AC7",null,null,{"$f":"IF(ISBLANK($E$14),\"N/A\",\"\")","v":""},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":""},null,null,"AC3",null,null,{"$f":"'RTU3'!J31","v":""},null,null,"AC4",null,null,{"$f":"'RTU4'!J31","v":""},null,null,"AC5",null,null,{"$f":"'RTU5'!J31","v":""},null,null,"AC6",null,null,{"$f":"IF(ISBLANK($E$13),\"N/A\",\"\")","v":""},null,null,"AC7",null,null,{"$f":"IF(ISBLANK($E$14),\"N/A\",\"\")","v":""},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":""},null,null,"AC3",null,null,{"$f":"'RTU3'!J32","v":""},null,null,"AC4",null,null,{"$f":"'RTU4'!J32","v":""},null,null,"AC5",null,null,{"$f":"'RTU5'!J32","v":""},null,null,"AC6",null,null,{"$f":"IF(ISBLANK($E$13),\"N/A\",\"\")","v":""},null,null,"AC7",null,null,{"$f":"IF(ISBLANK($E$14),\"N/A\",\"\")","v":""},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":""},null,null,"AC3",null,null,{"$f":"'RTU3'!J33","v":""},null,null,"AC4",null,null,{"$f":"IF(ISBLANK($E$11),\"N/A\",\"\")","v":""},null,null,"AC5",null,null,{"$f":"'RTU5'!J33","v":""},null,null,"AC6",null,null,{"$f":"IF(ISBLANK($E$13),\"N/A\",\"\")","v":""},null,null,"AC7",null,null,{"$f":"IF(ISBLANK($E$14),\"N/A\",\"\")","v":""},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":""},null,null,"AC3",null,null,{"$f":"'RTU3'!J34","v":""},null,null,"AC4",null,null,{"$f":"'RTU4'!J34","v":""},null,null,"AC5",null,null,{"$f":"'RTU5'!J34","v":""},null,null,"AC6",null,null,{"$f":"IF(ISBLANK($E$13),\"N/A\",\"\")","v":""},null,null,"AC7",null,null,{"$f":"IF(ISBLANK($E$14),\"N/A\",\"\")","v":""},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":""},null,null,"AC3",null,null,{"$f":"'RTU3'!J35","v":""},null,null,"AC4",null,null,{"$f":"'RTU4'!J35","v":""},null,null,"AC5",null,null,{"$f":"'RTU5'!J35","v":""},null,null,"AC6",null,null,{"$f":"IF(ISBLANK($E$13),\"N/A\",\"\")","v":""},null,null,"AC7",null,null,{"$f":"IF(ISBLANK($E$14),\"N/A\",\"\")","v":""},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":""},null,null,"AC3",null,null,{"$f":"'RTU3'!J36","v":""},null,null,"AC4",null,null,{"$f":"'RTU4'!J36","v":""},null,null,"AC5",null,null,{"$f":"'RTU5'!J36","v":""},null,null,"AC6",null,null,{"$f":"IF(ISBLANK($E$13),\"N/A\",\"\")","v":""},null,null,"AC7",null,null,{"$f":"IF(ISBLANK($E$14),\"N/A\",\"\")","v":""},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":""},null,null,"AC3",null,null,{"$f":"'RTU3'!J37","v":"N/A"},null,null,"AC4",null,null,{"$f":"'RTU4'!J37","v":"N/A"},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":""},null,null,"AC7",null,null,{"$f":"IF(ISBLANK($E$14),\"N/A\",IF(VALUE(MID($E$14,3,2))<10,\"N/A\",\"\"))","v":{"$error":"#VALUE!"}},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":""},null,null,"AC3",null,null,{"$f":"'RTU3'!J38","v":"N/A"},null,null,"AC4",null,null,{"$f":"'RTU4'!J38","v":"N/A"},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":""},null,null,"AC7",null,null,{"$f":"IF(ISBLANK($E$14),\"N/A\",IF(VALUE(MID($E$14,3,2))<10,\"N/A\",\"\"))","v":{"$error":"#VALUE!"}},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":""},null,null,"AC3",null,null,{"$f":"'RTU3'!J39","v":""},null,null,"AC4",null,null,{"$f":"'RTU4'!J39","v":""},null,null,"AC5",null,null,{"$f":"'RTU5'!J39","v":""},null,null,"AC6",null,null,{"$f":"IF(ISBLANK($E$13),\"N/A\",\"\")","v":""},null,null,"AC7",null,null,{"$f":"IF(ISBLANK($E$14),\"N/A\",\"\")","v":""},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":""},null,null,"AC3",null,null,{"$f":"'RTU3'!J40","v":""},null,null,"AC4",null,null,{"$f":"'RTU4'!J35","v":""},null,null,"AC5",null,null,{"$f":"'RTU5'!J40","v":"N/A"},null,null,"AC6",null,null,{"$f":"IF(ISBLANK($E$13),\"N/A\",\"\")","v":""},null,null,"AC7",null,null,{"$f":"IF(ISBLANK($E$14),\"N/A\",\"\")","v":""},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":""},null,null,"AC3",null,null,{"$f":"'RTU3'!J41","v":""},null,null,"AC4",null,null,{"$f":"'RTU4'!J41","v":""},null,null,"AC5",null,null,{"$f":"'RTU5'!J41","v":""},null,null,"AC6",null,null,{"$f":"IF(ISBLANK($E$13),\"N/A\",\"\")","v":""},null,null,"AC7",null,null,{"$f":"IF(ISBLANK($E$14),\"N/A\",\"\")","v":""},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":""},null,null,"AC3",null,null,{"$f":"'RTU3'!J42","v":""},null,null,"AC4",null,null,{"$f":"'RTU4'!J42","v":""},null,null,"AC5",null,null,{"$f":"'RTU5'!J42","v":""},null,null,"AC6",null,null,{"$f":"IF(ISBLANK($E$13),\"N/A\",\"\")","v":""},null,null,"AC7",null,null,{"$f":"IF(ISBLANK($E$14),\"N/A\",\"\")","v":""},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":""},null,null,"AC2",null,null,{"$f":"'RTU2'!J43","v":""},null,null,"AC3",null,null,{"$f":"IF(ISBLANK($E$10),\"N/A\",\"\")","v":""},null,null,"AC4",null,null,{"$f":"'RTU4'!J43","v":""},null,null,"AC5",null,null,{"$f":"'RTU5'!J43","v":""},null,null,"AC6",null,null,{"$f":"IF(ISBLANK($E$13),\"N/A\",\"\")","v":""},null,null,"AC7",null,null,{"$f":"IF(ISBLANK($E$14),\"N/A\",\"\")","v":""},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":""},null,null,"AC2",null,null,{"$f":"'RTU2'!J44","v":""},null,null,"AC3",null,null,{"$f":"'RTU3'!J44","v":""},null,null,"AC4",null,null,{"$f":"'RTU4'!J44","v":""},null,null,"AC5",null,null,{"$f":"'RTU5'!J44","v":""},null,null,"AC6",null,null,{"$f":"IF(ISBLANK($E$13),\"N/A\",\"\")","v":""},null,null,"AC7",null,null,{"$f":"IF(ISBLANK($E$14),\"N/A\",\"\")","v":""},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":0},null,null,"AC2",null,null,{"$f":"'RTU2'!J45","v":0},null,null,"AC3",null,null,{"$f":"'RTU3'!J45","v":0},null,null,"AC4",null,null,{"$f":"'RTU4'!J45","v":0},null,null,"AC5",null,null,{"$f":"'RTU5'!J45","v":0},null,null,"AC6",null,null,{"$f":"IF(ISBLANK($E$13),\"N/A\",\"\")","v":""},null,null,"AC7",null,null,{"$f":"IF(ISBLANK($E$14),\"N/A\",\"\")","v":""},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":""},null,null,"AC2",null,null,{"$f":"'RTU2'!J46","v":""},null,null,"AC3",null,null,{"$f":"'RTU3'!J46","v":""},null,null,"AC4",null,null,{"$f":"'RTU4'!J46","v":""},null,null,"AC5",null,null,{"$f":"'RTU5'!J46","v":""},null,null,"AC6",null,null,{"$f":"IF(ISBLANK($E$13),\"N/A\",\"\")","v":""},null,null,"AC7",null,null,{"$f":"IF(ISBLANK($E$14),\"N/A\",\"\")","v":""},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":""},null,null,"AC2",null,null,{"$f":"'RTU2'!J47","v":""},null,null,"AC3",null,null,{"$f":"'RTU3'!J47","v":""},null,null,"AC4",null,null,{"$f":"'RTU4'!J47","v":""},null,null,"AC5",null,null,{"$f":"'RTU5'!J47","v":""},null,null,"AC6",null,null,{"$f":"IF(ISBLANK($E$13),\"N/A\",\"\")","v":""},null,null,"AC7",null,null,{"$f":"IF(ISBLANK($E$14),\"N/A\",\"\")","v":""},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":""},null,null,"AC2",null,null,{"$f":"'RTU2'!J48","v":""},null,null,"AC3",null,null,{"$f":"'RTU3'!J48","v":""},null,null,"AC4",null,null,{"$f":"'RTU4'!J48","v":""},null,null,"AC5",null,null,{"$f":"'RTU5'!J48","v":""},null,null,"AC6",null,null,{"$f":"IF(ISBLANK($E$13),\"N/A\",\"\")","v":""},null,null,"AC7",null,null,{"$f":"IF(ISBLANK($E$14),\"N/A\",\"\")","v":""},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":0},null,null,"AC2",null,null,{"$f":"'RTU2'!J49","v":""},null,null,"AC3",null,null,{"$f":"'RTU3'!J49","v":""},null,null,"AC4",null,null,{"$f":"'RTU4'!J49","v":""},null,null,"AC5",null,null,{"$f":"'RTU5'!J49","v":""},null,null,"AC6",null,null,{"$f":"IF(ISBLANK($E$13),\"N/A\",\"\")","v":""},null,null,"AC7",null,null,{"$f":"IF(ISBLANK($E$14),\"N/A\",\"\")","v":""},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":0}]
[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":0}]
[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":0}]
[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":0}]
[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":0}]
[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":0}]
[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":0}]
[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":0}]
[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":0}]
[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":0},null,null,"AC2",null,null,{"$f":"'BR EF'!E15","v":0},null,null,"AC3",null,null,{"$f":"'BR EF'!G15","v":0},null,null,"AC4",null,null,{"$f":"'BR EF'!I15","v":0},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,null,null,null,{"$f":"'RTU1'!B52","v":0}]
[null,null,null,null,{"$f":"'RTU1'!B53","v":0}]
[null,"RTU 2",null,null,{"$f":"'RTU2'!B51","v":0}]
[null,null,null,null,{"$f":"'RTU2'!B52","v":0}]
[null,null,null,null,{"$f":"'RTU2'!B53","v":0}]
[null,"RTU 3",null,null,{"$f":"'RTU3'!B51","v":0}]
[null,null,null,null,{"$f":"'RTU3'!B52","v":0}]
[null,null,null,null,{"$f":"'RTU3'!B53","v":0}]
[null,"RTU 4",null,null,{"$f":"'RTU4'!B51","v":0}]
[null,null,null,null,{"$f":"'RTU4'!B52","v":0}]
[null,null,null,null,{"$f":"'RTU4'!B53","v":0}]
[null,"RTU 5",null,null,{"$f":"'RTU5'!B51","v":0}]
[null,null,null,null,{"$f":"'RTU5'!B52","v":0}]
[null,null,null,null,{"$f":"'RTU5'!B53","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,"DEVELOPED LENGTH ______ ' - 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,null,null,null,null,null,null,null,null,null,null,"2-1/2\"",null,null,null,null,null,null,null,null,null,null,null,"D1",null,null,null,"B1 to",null,null,null,null,"RTU 6",null,null,null,null,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,null,null,null,null,null,null,null,null,null,null,"2-1/2\"",null,null,null,null,null,null,null,null,null,null,null,"D2",null,null,null,"B2 to",null,null,null,null,"WH",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"1\"",null,null,null,null,null,null,null,null,null,null,null,null,"1\"",null,null,null,"1-5/16\""]
[null,null,null,"B2 to B3",null,null,null,null,null,null,null,null,null,null,null,null,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 1",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"1-1/2\"",null,null,null,null,null,null,null,null,null,null,null,null,"1-1/4\"",null,null,null,"1-5/8\""]
[null,null,null,"B3 to B4",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"2\"",null,null,null,null,null,null,null,null,null,null,null,"D4",null,null,null,"B4 to",null,null,null,null,"RTU 2",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"1-1/4\"",null,null,null,null,null,null,null,null,null,null,null,null,"1-1/2\"",null,null,null,"1-7/8\""]
[null,null,null,"B4 to B5",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"2\"",null,null,null,null,null,null,null,null,null,null,null,"D5",null,null,null,"B5 to",null,null,null,null,"RTU 4",null,null,null,null,null,null,null,null,null,null,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,"B5 to B6",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"1-1/2\"",null,null,null,null,null,null,null,null,null,null,null,"D6",null,null,null,"B6 to",null,null,null,null,"RTU 3",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"1-1/4\"",null,null,null,null,null,null,null,null,null,null,null,null,"2-1/2\"",null,null,null,"2-7/8\""]
[null,null,null,"D7",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"1\"",null,null,null,null,null,null,null,null,null,null,null,"D7",null,null,null,"B7 to",null,null,null,null,"RTU 5",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"1\"",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,"INSERT 1",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"INSERT 2"]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[null,"INSERT 3",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"INSERT 4"]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[null,"INSERT 5",null,null,null,null,null,null,null,null,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 6"]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[null,"INSERT 7",null,null,null,null,null,null,null,null,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 8"]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[null,"INSERT 9",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"INSERT 10"]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[null,"INSERT 11",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"INSERT 12"]

{"sheet":"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],[30,1,30,8],[31,1,31,8],[28,1,28,8],[29,1,29,8],[26,1,26,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],[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],[4,1,4,3],[22,1,22,8],[50,1,50,9],[51,1,51,9],[52,1,52,9],[1,5,1,9],[24,1,24,8],[25,1,25,8],[49,1,49,9],[27,1,27,8],[37,1,37,8],[34,1,34,8],[35,1,35,8],[2,5,2,9],[32,1,32,8],[33,1,33,8],[6,1,6,8],[7,1,7,8]]}
[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":"LGH30054H3Y"}]
[null,"SERIAL NUMBER",null,null,null,{"$f":"Survey!E8","v":"5616G11275"}]
[null,null,null,null,"RTU AGE",null,{"$f":"Survey!AF8","v":7.1232876712328768},"RTU TONNAGE",null,{"$f":"Survey!X8","v":"25"}]
[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$8),\"N/A\",\"\")","v":""},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,{"$f":"Survey!B33","v":"8.  Is the humidity sensor wired?  If NO,  enter unit tonnage."},null,null,null,null,null,null,null,{"$f":"IF(MID(J12,1,2)=\"NO\",\"N/A\",\"\")","v":""}]
[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":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!AZ149","v":0}]
[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$8),\"N/A\",\"\")","v":""}]
[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$8),\"N/A\",\"\")","v":""}]
[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$8),\"N/A\",\"\")","v":""}]
[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$8),\"N/A\",\"\")","v":""}]
[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,{"$f":"IF(ISBLANK(Survey!$E$8),\"N/A\",\"\")","v":""}]
[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$8),\"N/A\",\"\")","v":""}]
[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$8),\"N/A\",\"\")","v":""}]
[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$8),\"N/A\",\"\")","v":""}]
[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$8),\"N/A\",\"\")","v":""}]
[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,"MISCELLENOUS NOTES"]

{"sheet":"RTU2","index":2,"n_rows":50,"n_cols":13,"rows_kept":50,"cut":false,"hidden":false,"merged":[[52,1,52,9],[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],[38,1,38,8],[39,1,39,8],[40,1,40,8],[25,1,25,8],[26,1,26,8],[46,1,46,8],[50,1,50,9],[51,1,51,9],[44,1,44,8],[45,1,45,8],[10,1,10,8],[11,1,11,8],[37,1,37,8],[42,1,42,8],[43,1,43,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],[4,4,4,5],[12,1,12,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]]}
[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":"LGH102H48H4Y"}]
[null,"SERIAL NUMBER",null,null,null,{"$f":"Survey!E9","v":"5621A08753"}]
[null,null,null,null,"RTU AGE",null,{"$f":"Survey!AF9","v":2.6164383561643834},"RTU TONNAGE",null,{"$f":"Survey!X9","v":"8.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,{"$f":"IF(ISBLANK(Survey!$E$9),\"N/A\",\"\")","v":""},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$9),\"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,7,2)<\"14\",\"\",IF(MID(Survey!$M$9,4,3)>\"149\",\"N/A\",\"\")))))","v":""}]
[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$9),\"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,7,2)<\"14\",\"\",IF(MID(Survey!$M$9,4,3)>\"149\",\"N/A\",\"\")))))","v":""}]
[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$9),\"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,7,2)<\"14\",\"\",IF(MID(Survey!$M$9,4,3)>\"149\",\"N/A\",\"\")))))","v":""}]
[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,{"$f":"IF(ISBLANK(Survey!$E$9),\"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,7,2)<\"14\",\"\",IF(MID(Survey!$M$9,4,3)>\"149\",\"N/A\",\"\")))))","v":""}]
[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(MID(J12,1,2)=\"NO\",\"N/A\",\"\")","v":""}]
[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":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!AZ149","v":0}]
[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$9),\"N/A\",\"\")","v":""}]
[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$9),\"N/A\",\"\")","v":""}]
[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$9),\"N/A\",\"\")","v":""}]
[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$9),\"N/A\",\"\")","v":""}]
[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":""}]
[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":""}]
[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$9),\"N/A\",IF(MID($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":""}]
[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":""}]
[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":""}]
[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$9),\"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,7,2)<\"14\",\"\",IF(MID(Survey!$M$9,4,3)>\"149\",\"N/A\",\"\")))))","v":""}]
[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$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\",\"\")))))","v":""}]
[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$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\",\"\")))))","v":""}]
[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":""}]
[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$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\",\"\")))))","v":""}]
[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$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\",\"\")))))","v":""}]
[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$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\",\"\")))))","v":""}]
[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$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\",\"\")))))","v":""}]
[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$9),\"N/A\",IF(MID(Survey!$M$9,7,2)<\"14\",\"\",IF(MID(Survey!$M$9,7,2)=\"14\",\"N/A\",IF(MID(Survey!$M9,7,2)=\"16\",\"N/A\",IF(MID(Survey!$M$9,4,3)>\"149\",\"N/A\",\"\")))))","v":""}]
[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$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\",\"\")))))","v":""}]
[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$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\",\"\")))))","v":""}]
[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$9),\"N/A\",IF(LEN(Survey!$M$9)>15,\"N/A\",IF(VALUE(MID(Survey!$E$9,3,2))<10,\"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":""}]
[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$9),\"N/A\",IF(LEN(Survey!$M$9)>15,\"N/A\",IF(VALUE(MID(Survey!$E$9,3,2))<10,\"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":""}]
[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$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\",\"\")))))","v":""}]
[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$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\",\"\")))))","v":""}]
[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$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\",\"\")))))","v":""}]
[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$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\",\"\")))))","v":""}]
[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$9),\"N/A\",\"\")","v":""}]
[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$9),\"N/A\",\"\")","v":""}]
[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$9),\"N/A\",\"\")","v":""}]
[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$9),\"N/A\",\"\")","v":""}]
[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$9),\"N/A\",\"\")","v":""}]
[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$9),\"N/A\",\"\")","v":""}]
[null,"MISCELLENOUS NOTES"]

{"sheet":"RTU3","index":3,"n_rows":50,"n_cols":13,"rows_kept":50,"cut":false,"hidden":false,"merged":[[51,1,51,9],[47,1,47,8],[48,1,48,8],[49,1,49,9],[46,1,46,8],[50,1,50,9],[44,1,44,8],[35,1,35,8],[36,1,36,8],[37,1,37,8],[38,1,38,8],[39,1,39,8],[33,1,33,8],[40,1,40,8],[41,1,41,8],[42,1,42,8],[43,1,43,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],[13,1,13,8],[14,1,14,8],[15,1,15,8],[16,1,16,8],[17,1,17,8],[52,1,52,9],[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]]}
[null,"RTU UNIT MANUFACTURER",null,null,null,{"$f":"Survey!AA10","v":"Lennox"}]
[null,"RTU TYPE",null,null,null,{"$f":"Survey!AI10","v":"L SERIES"}]
[null,"MODEL NUMBER",null,null,null,{"$f":"Survey!M10","v":"LGA120H2BH3Y"}]
[null,"SERIAL NUMBER",null,null,null,{"$f":"Survey!E10","v":"5608C00742"}]
[null,null,null,null,"RTU AGE",null,{"$f":"Survey!AF10","v":15.463013698630137},"RTU TONNAGE",null,{"$f":"Survey!X10","v":"10"}]
[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$10),\"N/A\",\"\")","v":""},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$10),\"N/A\",\"\")","v":""}]
[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$10),\"N/A\",\"\")","v":""}]
[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$10),\"N/A\",\"\")","v":""}]
[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$10),\"N/A\",IF(MID(Survey!$M$10,15,1)=\"A\",\"N/A\",IF(MID(Survey!$M$10,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$10),\"N/A\",\"\")","v":""}]
[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(MID(J12,1,2)=\"NO\",\"N/A\",\"\")","v":""}]
[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":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,{"$f":"IF(ISBLANK(Survey!$E$10),\"N/A\",\"\")","v":""}]
[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$10),\"N/A\",\"\")","v":""}]
[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$10),\"N/A\",\"\")","v":""}]
[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$10),\"N/A\",\"\")","v":""}]
[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$10),\"N/A\",\"\")","v":""}]
[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,{"$f":"IF(ISBLANK(Survey!$E$10),\"N/A\",IF(MID(Survey!$M$10,9,1)=\"E\",\"N/A\",\"\"))","v":""}]
[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$10),\"N/A\",IF(MID(Survey!$M$10,9,1)=\"E\",\"N/A\",\"\"))","v":""}]
[null,{"$f":"Survey!B57","v":"20. Record belt size."},null,null,null,null,null,null,null,{"$f":"IF(ISBLANK(Survey!$E$10),\"N/A\",IF(MID(Survey!$M$10,9,1)=\"E\",\"N/A\",\"\"))","v":""}]
[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$10),\"N/A\",\"\")","v":""}]
[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$10),\"N/A\",\"\")","v":""}]
[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$10),\"N/A\",\"\")","v":""}]
[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$10),\"N/A\",IF(LEN(Survey!$M$10)>15,\"N/A\",IF(MID(Survey!$M$10,4,3)<=\"072\",\"N/A\",IF(MID(Survey!$M$10,4,3)>=\"180\",\"N/A\",\"\"))))","v":""}]
[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$10),\"N/A\",\"\")","v":""}]
[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$10),\"N/A\",\"\")","v":""}]
[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$10),\"N/A\",\"\")","v":""}]
[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$10),\"N/A\",\"\")","v":""}]
[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$10),\"N/A\",\"\")","v":""}]
[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$10),\"N/A\",\"\")","v":""}]
[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$10),\"N/A\",\"\")","v":""}]
[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$10),\"N/A\",IF(LEN(Survey!$M$10)>15,\"N/A\",IF(VALUE(MID(Survey!$E$10,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$10),\"N/A\",IF(LEN(Survey!$M$10)>15,\"N/A\",IF(VALUE(MID(Survey!$E$10,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$10),\"N/A\",\"\")","v":""}]
[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$10),\"N/A\",\"\")","v":""}]
[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$10),\"N/A\",\"\")","v":""}]
[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$10),\"N/A\",\"\")","v":""}]
[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$10),\"N/A\",\"\")","v":""}]
[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$10),\"N/A\",\"\")","v":""}]
[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$10),\"N/A\",\"\")","v":""}]
[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$10),\"N/A\",\"\")","v":""}]
[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$10),\"N/A\",\"\")","v":""}]
[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$10),\"N/A\",\"\")","v":""}]
[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],[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],[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],[40,1,40,8],[41,1,41,8],[42,1,42,8],[50,1,50,9],[51,1,51,9],[52,1,52,9],[47,1,47,8],[48,1,48,8],[49,1,49,9]]}
[null,"RTU UNIT MANUFACTURER",null,null,null,{"$f":"Survey!AA11","v":"Lennox"}]
[null,"RTU TYPE",null,null,null,{"$f":"Survey!AI11","v":"L SERIES"}]
[null,"MODEL NUMBER",null,null,null,{"$f":"Survey!M11","v":"LGA090H2BH2Y"}]
[null,"SERIAL NUMBER",null,null,null,{"$f":"Survey!E11","v":"5608C00861"}]
[null,null,null,null,"RTU AGE",null,{"$f":"Survey!AF11","v":15.463013698630137},"RTU TONNAGE",null,{"$f":"Survey!X11","v":"7.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,{"$f":"IF(ISBLANK(Survey!$E$11),\"N/A\",\"\")","v":""},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$11),\"N/A\",\"\")","v":""}]
[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$11),\"N/A\",\"\")","v":""}]
[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$11),\"N/A\",\"\")","v":""}]
[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,{"$f":"IF(ISBLANK(Survey!$E$11),\"N/A\",\"\")","v":""}]
[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$11),\"N/A\",IF(MID(J12,1,2)=\"NO\",\"N/A\",\"\"))","v":""}]
[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":0}]
[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$11),\"N/A\",\"\")","v":""}]
[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$11),\"N/A\",\"\")","v":""}]
[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$11),\"N/A\",\"\")","v":""}]
[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$11),\"N/A\",\"\")","v":""}]
[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":""}]
[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":""}]
[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":""}]
[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$11),\"N/A\",\"\")","v":""}]
[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$11),\"N/A\",\"\")","v":""}]
[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$11),\"N/A\",\"\")","v":""}]
[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":""}]
[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$11),\"N/A\",\"\")","v":""}]
[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$11),\"N/A\",\"\")","v":""}]
[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$11),\"N/A\",\"\")","v":""}]
[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$11),\"N/A\",\"\")","v":""}]
[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$11),\"N/A\",\"\")","v":""}]
[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$11),\"N/A\",\"\")","v":""}]
[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$11),\"N/A\",\"\")","v":""}]
[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$11),\"N/A\",IF(LEN(Survey!$M$11)>15,\"N/A\",IF(VALUE(MID(Survey!$E$11,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$11),\"N/A\",IF(LEN(Survey!$M$11)>15,\"N/A\",IF(VALUE(MID(Survey!$E$11,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$11),\"N/A\",\"\")","v":""}]
[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$11),\"N/A\",\"\")","v":""}]
[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$11),\"N/A\",\"\")","v":""}]
[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$11),\"N/A\",\"\")","v":""}]
[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$11),\"N/A\",\"\")","v":""}]
[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$11),\"N/A\",\"\")","v":""}]
[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$11),\"N/A\",\"\")","v":""}]
[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$11),\"N/A\",\"\")","v":""}]
[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$11),\"N/A\",\"\")","v":""}]
[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$11),\"N/A\",\"\")","v":""}]
[null,"MISCELLENOUS NOTES"]

{"sheet":"RTU5","index":5,"n_rows":50,"n_cols":13,"rows_kept":50,"cut":false,"hidden":false,"merged":[[39,1,39,8],[47,1,47,8],[48,1,48,8],[49,1,49,9],[46,1,46,8],[43,1,43,8],[44,1,44,8],[45,1,45,8],[40,1,40,8],[41,1,41,8],[42,1,42,8],[33,1,33,8],[35,1,35,8],[36,1,36,8],[37,1,37,8],[38,1,38,8],[34,1,34,8],[28,1,28,8],[29,1,29,8],[30,1,30,8],[31,1,31,8],[32,1,32,8],[23,1,23,8],[24,1,24,8],[25,1,25,8],[26,1,26,8],[27,1,27,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],[50,1,50,9],[51,1,51,9],[52,1,52,9],[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":"Lennox"}]
[null,"RTU TYPE",null,null,null,{"$f":"Survey!AI12","v":"L SERIES"}]
[null,"MODEL NUMBER",null,null,null,{"$f":"Survey!M12","v":"LGA060H2BH2Y"}]
[null,"SERIAL NUMBER",null,null,null,{"$f":"Survey!E12","v":"5608C00861"}]
[null,null,null,null,"RTU AGE",null,{"$f":"Survey!AF12","v":15.463013698630137},"RTU TONNAGE",null,{"$f":"Survey!X12","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,{"$f":"IF(ISBLANK(Survey!$E$12),\"N/A\",\"\")","v":""},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":""}]
[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":""}]
[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":""}]
[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":""}]
[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":""}]
[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":0}]
[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":""}]
[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":""}]
[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":""}]
[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":""}]
[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":""}]
[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":""}]
[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":""}]
[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":""}]
[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":""}]
[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":""}]
[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":""}]
[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":""}]
[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":""}]
[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":""}]
[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":""}]
[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":""}]
[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":""}]
[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":""}]
[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":""}]
[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":""}]
[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":""}]
[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":""}]
[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":""}]
[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":""}]
[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":""}]
[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":""}]
[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":"Carrier"}]
[null,"RTU TYPE",null,null,null,{"$f":"Survey!AI13","v":"ENERGENCE"}]
[null,"MODEL NUMBER",null,null,null,{"$f":"Survey!M13","v":"LAH036H4S4Y"}]
[null,"SERIAL NUMBER",null,null,null,{"$f":"Survey!E13","v":"5616L12772"}]
[null,null,null,null,null,"RTU TONNAGE",null,null,null,{"$f":"Survey!X13","v":"3"}]
[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":""},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":""}]
[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":""}]
[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":""}]
[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":""}]
[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":""}]
[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":0}]
[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":""}]
[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":""}]
[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":""}]
[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":""}]
[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":""}]
[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":""}]
[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":""}]
[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":""}]
[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":""}]
[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":""}]
[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":""}]
[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":""}]
[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":""}]
[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":""}]
[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":""}]
[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":""}]
[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":""}]
[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":""}]
[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":""}]
[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":""}]
[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":""}]
[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":""}]
[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":""}]
[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":""}]
[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":""}]
[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":""}]
[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":""}]
[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":""}]
[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,{"$f":"Survey!B108","v":"46.  Is bathroom exhaust fan making excessive noise? Enter Yes or NO."}]
[null,{"$f":"Survey!B109","v":"47.  Is bathroom exhaust fan vibrating excessively? Enter YES or NO."}]
[null,{"$f":"Survey!B110","v":"48.  Does bathroom exhaust fan have a back draft damper?  Enter YES or NO."}]
[null,{"$f":"Survey!B111","v":"49.  Does bathroom exhaust fan duct have a liner? Enter YES OR NO."}]
[null,{"$f":"Survey!B112","v":"50.  Visually inspect ductwork at bathroom exhaust fan, and rate cleanliness. Enter CLEAN OR DIRTY."}]
[null,{"$f":"Survey!B113","v":"51.  Record model number of Suncoast Panel."}]
[null,"52. Record serial number of Suncoast Panel."]
[null,"53.  Is there a HES control panel visible?  "]
[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",null,"AC2",null,"AC3",null,"AC4",null,"AC5"]
[null,"AC6",null,"AC7",null,"AC8"]
[null,"MISCELLENOUS NOTES"]

{"sheet":"Store Data","index":8,"n_rows":14,"n_cols":61,"rows_kept":14,"cut":false,"hidden":false,"merged":[[6,46,6,50],[6,51,6,55],[6,56,6,60],[6,21,6,25],[6,26,6,30],[6,31,6,35],[6,36,6,40],[6,41,6,45]]}
[]
[]
[]
[]
[]
[]
["(2) Store No.","Survey Due Date","(8) Construction Start Date (CSD)","(3) Location Name","(4) SOW","(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,null,"Northeast",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"]
[]
[2175,{"$f":"C10-240","v":"2023-08-10"},"2024-04-06","Mechanicsburg (VA) FSU","OC/BI","S06C-R","Atlantic",{"$f":"IF(MID(G10,1,3)=\"Nor\",\"National TAB\",IF(MID(G10,1,3)=\"Atl\",\"National TAB\",IF(MID(G10,1,3)=\"Mid\",\"National TAB\",IF(MID(G10,4,4)=\"thea\",\"National TAB\",\"Melink\"))))","v":"National TAB"},"7285 Battle Hill Drive","Mechanicsville","VA","Mark Baldwin","Pamela Fowler","Tim Colburn","Scott Lawhorne","Jim Anderson","Jeff Weaver","HFR","2008-06-12",8047302638,"02175@chick-fil-a.com","5616G11275","LGH30054H3Y","2016-07-01",{"$f":"(TODAY()-X10)/365","v":7.1232876712328768},{"$f":"IF(ISBLANK(V10),\"NODATA\",IF(MID(W10,1,2)=\"RN\",\"AAON\",IF(LEN(W10)>15,\"WeatherMaker\",IF(VALUE(MID(V10,3,2))>9,\"ENER\",IF(VALUE(MID(V10,3,2))<10,\"L-SER\")))))","v":"ENER"},"5621A08753","LGH102H48H4Y","2021-01-01",{"$f":"(TODAY()-AC10)/365","v":2.6164383561643834},{"$f":"IF(ISBLANK(AA10),\"NODATA\",IF(MID(AB10,1,2)=\"RN\",\"AAON\",IF(LEN(AB10)>15,\"WeatherMaker\",IF(VALUE(MID(AA10,3,2))>9,\"ENER\",IF(VALUE(MID(AA10,3,2))<10,\"L-SER\")))))","v":"ENER"},"5608C00742","LGA120H2BH3Y","2008-03-01",{"$f":"(TODAY()-AH10)/365","v":15.463013698630137},{"$f":"IF(ISBLANK(AF10),\"NODATA\",IF(LEN(AG10)>15,\"WeatherMaker\",IF(VALUE(MID(AF10,3,2))>9,\"ENER\",IF(VALUE(MID(AF10,3,2))<10,\"L-SER\"))))","v":"L-SER"},"5608C00861","LGA090H2BH2Y","2008-03-01",{"$f":"(TODAY()-AM10)/365","v":15.463013698630137},{"$f":"IF(ISBLANK(AK10),\"NODATA\",IF(LEN(AL10)>15,\"WeatherMaker\",IF(VALUE(MID(AK10,3,2))>9,\"ENER\",IF(VALUE(MID(AK10,3,2))<10,\"L-SER\"))))","v":"L-SER"},"5608C00861","LGA060H2BH2Y","2008-03-01",{"$f":"(TODAY()-AR10)/365","v":15.463013698630137},{"$f":"IF(ISBLANK(AP10),\"NODATA\",IF(LEN(AQ10)>15,\"WeatherMaker\",IF(VALUE(MID(AP10,3,2))>9,\"ENER\",IF(VALUE(MID(AP10,3,2))<10,\"L-SER\"))))","v":"L-SER"},"5616L12772","LAH036H4S4Y","2016-08-01",{"$f":"(TODAY()-AW10)/365","v":7.0383561643835613},{"$f":"IF(ISBLANK(AU10),\"NODATA\",IF(LEN(AV10)>15,\"WeatherMaker\",IF(VALUE(MID(AU10,3,2))>9,\"ENER\",IF(VALUE(MID(AU10,3,2))<10,\"L-SER\"))))","v":"ENER"}]
[]
[]
[]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"5614G02828","LCH120H4BN3Y","2014-07-01"]

{"sheet":"Drop Menus","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"]

{"sheet":"SYNEXIS","index":10,"n_rows":418,"n_cols":2,"rows_kept":418,"cut":false,"hidden":false,"merged":[]}
[null,"Customer Status"]
[4941,"Active"]
[539,"Active"]
[2777,"Active"]
[3184,"Active"]
[2928,"Active"]
[2209,"Active"]
[4251,"Active"]
[3303,"Active"]
[3540,"Active"]
[1724,"Active"]
[2629,"Active"]
[1293,"Active"]
[1047,"Active"]
[1826,"Active"]
[9,"Active"]
[4574,"Active"]
[1414,"Active"]
[418,"Active"]
[2117,"Active"]
[4628,"Active"]
[1709,"Active"]
[2813,"Active"]
[4013,"Active"]
[2292,"Active"]
[2449,"Active"]
[2984,"Active"]
[1703,"Active"]
[718,"Active"]
[3642,"Active"]
[3381,"Active"]
[4006,"Active"]
[3497,"Active"]
[4175,"Active"]
[2858,"Active"]
[2821,"Active"]
[4102,"Active"]
[457,"Active"]
[3192,"Active"]
[1149,"Active"]
[2829,"Active"]
[1368,"Active"]
[4279,"Active"]
[3507,"Active"]
[799,"Active"]
[4325,"Active"]
[1227,"Active"]
[1976,"Active"]
[3740,"Active"]
[3778,"Active"]
[3829,"Active"]
[1763,"Active"]
[1585,"Active"]
[2913,"Active"]
[3312,"Active"]
[1130,"Active"]
[1544,"Active"]
[2869,"Active"]
[4133,"Active"]
[1086,"Active"]
[1706,"Active"]
[1601,"Active"]
[3154,"Active"]
[2981,"Active"]
[1222,"Active"]
[4324,"Active"]
[2784,"Active"]
[1951,"Active"]
[2363,"Active"]
[3180,"Active"]
[3749,"Active"]
[3146,"Active"]
[2665,"Active"]
[4081,"Active"]
[1454,"Active"]
[1449,"Active"]
[3755,"Active"]
[3693,"Active"]
[592,"Active"]
[1956,"Active"]
[1048,"Active"]
[92,"Active"]
[3675,"Active"]
[1639,"Active"]
[2571,"Active"]
[4566,"Active"]
[717,"Active"]
[792,"Active"]
[4093,"Active"]
[1085,"Active"]
[4791,"Active"]
[1980,"Active"]
[3449,"Active"]
[1814,"Active"]
[1867,"Active"]
[4028,"Active"]
[3255,"Active"]
[981,"Active"]
[2500,"Active"]
[4345,"Active"]
[4335,"Active"]
[1691,"Active"]
[1183,"Active"]
[1591,"Active"]
[4159,"Active"]
[791,"Active"]
[1883,"Active"]
[4451,"Active"]
[859,"Active"]
[1228,"Active"]
[2415,"Active"]
[528,"Active"]
[2034,"Active"]
[2918,"Active"]
[2797,"Active"]
[756,"Active"]
[4695,"Active"]
[3031,"Active"]
[3511,"Active"]
[745,"Active"]
[1999,"Active"]
[4215,"Active"]
[2193,"Active"]
[2425,"Active"]
[2763,"Active"]
[4103,"Active"]
[562,"Active"]
[1259,"Active"]
[869,"Active"]
[3309,"Active"]
[2616,"Active"]
[2436,"Active"]
[1546,"Active"]
[2825,"Active"]
[3904,"Active"]
[3664,"Active"]
[2545,"Active"]
[2942,"Active"]
[4344,"Active"]
[3334,"Active"]
[2086,"Active"]
[3571,"Active"]
[3273,"Active"]
[2664,"Active"]
[1089,"Active"]
[2884,"Active"]
[2906,"Active"]
[1210,"Active"]
[1493,"Active"]
[3592,"Active"]
[2047,"Active"]
[1463,"Active"]
[2957,"Active"]
[1769,"Active"]
[2493,"Active"]
[3072,"Active"]
[2435,"Active"]
[694,"Active"]
[3060,"Active"]
[2264,"Active"]
[3288,"Active"]
[2201,"Active"]
[2551,"Active"]
[3713,"Active"]
[771,"Active"]
[2103,"Active"]
[4717,"Active"]
[1682,"Active"]
[3468,"Active"]
[1111,"Active"]
[242,"Active"]
[2585,"Active"]
[4072,"Active"]
[2681,"Active"]
[3529,"Active"]
[3898,"Active"]
[1977,"Active"]
[1501,"Active"]
[2483,"Active"]
[1018,"Active"]
[1986,"Active"]
[3848,"Active"]
[3422,"Active"]
[2644,"Active"]
[1825,"Active"]
[2244,"Active"]
[3825,"Active"]
[3308,"Active"]
[3972,"Active"]
[3018,"Active"]
[1390,"Active"]
[1731,"Active"]
[701,"Active"]
[1072,"Active"]
[2621,"Active"]
[3619,"Active"]
[3925,"Active"]
[2849,"Active"]
[3138,"Active"]
[3032,"Active"]
[2956,"Active"]
[1125,"Active"]
[2587,"Active"]
[2931,"Active"]
[3141,"Active"]
[4000,"Active"]
[4769,"Active"]
[3366,"Active"]
[4023,"Active"]
[1649,"Active"]
[1635,"Active"]
[1284,"Active"]
[3957,"Active"]
[4473,"Active"]
[2822,"Active"]
[695,"Active"]
[3632,"Active"]
[3490,"Active"]
[4063,"Active"]
[1579,"Active"]
[1805,"Active"]
[1796,"Active"]
[3810,"Active"]
[4310,"Active"]
[1098,"Active"]
[1524,"Active"]
[3212,"Active"]
[643,"Active"]
[777,"Active"]
[2759,"Active"]
[2470,"Active"]
[1995,"Active"]
[288,"Active"]
[3077,"Active"]
[3562,"Active"]
[3489,"Active"]
[1509,"Active"]
[3795,"Active"]
[1280,"Active"]
[986,"Active"]
[1445,"Active"]
[358,"Active"]
[3106,"Active"]
[1942,"Active"]
[1661,"Active"]
[4621,"Active"]
[3526,"Active"]
[4073,"Active"]
[3262,"Active"]
[3343,"Active"]
[4235,"Active"]
[524,"Active"]
[3423,"Active"]
[1855,"Active"]
[3037,"Active"]
[1083,"Active"]
[737,"Active"]
[1772,"Active"]
[3300,"Active"]
[3790,"Active"]
[3533,"Active"]
[4139,"Active"]
[3794,"Active"]
[2289,"Active"]
[3248,"Active"]
[4323,"Active"]
[4329,"Active"]
[2698,"Active"]
[8,"Active"]
[930,"Active"]
[2508,"Active"]
[3901,"Active"]
[3750,"Active"]
[579,"Active"]
[4480,"Active"]
[2955,"Active"]
[2024,"Active"]
[2599,"Active"]
[1170,"Active"]
[2792,"Active"]
[1431,"Active"]
[1069,"Active"]
[2820,"Inactive - Cancelled"]
[2331,"Inactive - Cancelled"]
[3667,"Inactive - Cancelled"]
[4085,"Inactive - Cancelled"]
[3823,"Inactive - Cancelled"]
[3694,"Inactive - Cancelled"]
[3295,"Inactive - Cancelled"]
[3382,"Inactive - Cancelled"]
[3809,"Inactive - Cancelled"]
[2713,"Inactive - Cancelled"]
[482,"Inactive - Cancelled"]
[2456,"Inactive - Cancelled"]
[3374,"Inactive - Cancelled"]
[368,"Inactive - Cancelled"]
[829,"Inactive - Cancelled"]
[1704,"Inactive - Cancelled"]
[2817,"Inactive - Cancelled"]
[3791,"Inactive - Cancelled"]
[1433,"Inactive - Cancelled"]
[3840,"Inactive - Cancelled"]
[231,"Inactive - Cancelled"]
[3433,"Inactive - Cancelled"]
[4496,"Inactive - Cancelled"]
[430,"Inactive - Cancelled"]
[4627,"Inactive - Cancelled"]
[1385,"Inactive - Cancelled"]
[3827,"Inactive - Cancelled"]
[2407,"Inactive - Cancelled"]
[1446,"Inactive - Cancelled"]
[2066,"Inactive - Cancelled"]
[4437,"Inactive - Cancelled"]
[3432,"Inactive - Cancelled"]
[2947,"Inactive - Cancelled"]
[3189,"Inactive - Cancelled"]
[3486,"Inactive - Cancelled"]
[3769,"Inactive - Cancelled"]
[4068,"Inactive - Cancelled"]
[2050,"Inactive - Cancelled"]
[4271,"Inactive - Cancelled"]
[1764,"Inactive - Cancelled"]
[4144,"Inactive - Cancelled"]
[3748,"Inactive - Cancelled"]
[3544,"Inactive - Cancelled"]
[4457,"Inactive - Cancelled"]
[1732,"Inactive - Cancelled"]
[4264,"Inactive - Cancelled"]
[2968,"Inactive - Cancelled"]
[3239,"Inactive - Cancelled"]
[2185,"Inactive - Cancelled"]
[1031,"Inactive - Cancelled"]
[3040,"Inactive - Cancelled"]
[1540,"Inactive - Cancelled"]
[3912,"Inactive - Cancelled"]
[1647,"Inactive - Cancelled"]
[2640,"Inactive - Cancelled"]
[3431,"Inactive - Cancelled"]
[3817,"Inactive - Cancelled"]
[2788,"Inactive - Cancelled"]
[2793,"Inactive - Cancelled"]
[1827,"Inactive - Cancelled"]
[2509,"Inactive - Cancelled"]
[2367,"Inactive - Cancelled"]
[3695,"Inactive - Cancelled"]
[3440,"Inactive - Cancelled"]
[2194,"Inactive - Cancelled"]
[1103,"Inactive - Cancelled"]
[1186,"Inactive - Cancelled"]
[1815,"Inactive - Cancelled"]
[4827,"Inactive - Cancelled"]
[2501,"Inactive - Cancelled"]
[1053,"Inactive - Cancelled"]
[3307,"Inactive - Cancelled"]
[3843,"Inactive - Cancelled"]
[3424,"Inactive - Cancelled"]
[1886,"Inactive - Cancelled"]
[2131,"Inactive - Cancelled"]
[4070,"Inactive - Cancelled"]
[3688,"Inactive - Cancelled"]
[662,"Inactive - Cancelled"]
[2013,"Inactive - Cancelled"]
[4402,"Inactive - Cancelled"]
[3195,"Inactive - Cancelled"]
[3372,"Inactive - Cancelled"]
[3022,"Inactive - Cancelled"]
[1014,"Inactive - Cancelled"]
[3499,"Inactive - Cancelled"]
[2891,"Inactive - Cancelled"]
[3253,"Inactive - Cancelled"]
[1982,"Inactive - Cancelled"]
[2899,"Inactive - Cancelled"]
[998,"Inactive - Cancelled"]
[3808,"Inactive - Cancelled"]
[3613,"Inactive - Cancelled"]
[3020,"Inactive - Cancelled"]
[361,"Inactive - Cancelled"]
[4800,"Inactive - Cancelled"]
[3410,"Inactive - Cancelled"]
[57,"Inactive - Cancelled"]
[3622,"Inactive - Cancelled"]
[3578,"Inactive - Cancelled"]
[2662,"Inactive - Cancelled"]
[2320,"Inactive - Cancelled"]
[1939,"Inactive - Cancelled"]
[1895,"Inactive - Cancelled"]
[3773,"Inactive - Cancelled"]
[3685,"Inactive - Cancelled"]
[4149,"Inactive - Cancelled"]
[2000,"Inactive - Cancelled"]
[3763,"Inactive - Non-Renewed"]
[3662,"Inactive - Non-Renewed"]
[2636,"Inactive - Non-Renewed"]
[2141,"Inactive - Non-Renewed"]
[1739,"Inactive - Non-Renewed"]
[1139,"Inactive - Non-Renewed"]
[3830,"Inactive - Non-Renewed"]
[3700,"Inactive - Non-Renewed"]
[1911,"Inactive - Non-Renewed"]
[1223,"Inactive - Non-Renewed"]
[732,"Inactive - Non-Renewed"]
[2811,"Inactive - Non-Renewed"]
[1481,"Inactive - Non-Renewed"]
[1947,"Inactive - Non-Renewed"]
[2856,"Inactive - Non-Renewed"]
[2940,"Inactive - Non-Renewed"]
[1157,"Inactive - Non-Renewed"]
[1248,"Inactive - Non-Renewed"]
[617,"Inactive - Non-Renewed"]
[3056,"Inactive - Non-Renewed"]
[2680,"Inactive - Non-Renewed"]
[2554,"Inactive - Non-Renewed"]
[4386,"Inactive - Non-Renewed"]
[2688,"Inactive - Non-Renewed"]
[2724,"Inactive - Non-Renewed"]
[1489,"Inactive - Non-Renewed"]
[1697,"Inactive - Non-Renewed"]
[4040,"Inactive - Non-Renewed"]