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

{"sheet":"Survey","index":0,"n_rows":322,"n_cols":83,"rows_kept":322,"cut":false,"hidden":false,"merged":[[323,1,344,79],[58,1,58,66],[34,30,34,32],[34,33,34,35],[34,36,34,38],[34,39,34,41],[34,42,34,44],[34,45,34,47],[34,48,34,50],[34,51,34,53],[34,54,34,56],[34,57,34,59],[34,60,34,62],[34,63,34,65],[59,1,59,66],[51,24,51,26],[36,21,36,23],[36,24,36,26],[43,36,43,38],[111,36,111,38],[111,42,111,44],[118,1,118,66],[101,1,101,66],[111,27,111,29],[111,33,111,35],[97,42,97,44],[105,21,105,23],[127,63,127,65],[113,39,113,41],[125,21,125,23],[125,42,125,44],[121,1,121,66],[322,69,322,80],[109,45,109,47],[125,3,125,14],[127,21,127,23],[47,45,47,47],[55,51,55,53],[113,51,113,53],[113,54,113,56],[123,45,123,47],[127,27,127,29],[127,42,127,44],[115,36,115,38],[115,27,115,29],[116,1,116,66],[105,27,105,29],[107,60,107,62],[123,51,123,53],[107,36,107,38],[117,15,117,17],[117,18,117,20],[105,30,105,32],[97,24,97,26],[105,39,105,41],[111,45,111,47],[123,48,123,50],[113,60,113,62],[111,39,111,41],[97,51,97,53],[107,63,107,65],[115,51,115,53],[113,18,113,20],[161,1,161,66],[315,24,315,28],[9,26,9,30],[7,31,7,33],[8,31,8,33],[9,31,9,33],[7,26,7,30],[32,51,32,53],[49,51,49,53],[307,1,307,65],[45,27,45,29],[45,54,45,56],[42,1,42,66],[105,63,105,65],[95,3,95,14],[97,3,97,14],[105,3,105,14],[316,24,316,28],[156,1,156,66],[159,1,159,66],[160,1,160,66],[158,1,158,66],[157,1,157,66],[7,12,7,22],[3,62,3,73],[4,62,4,73],[3,55,3,61],[4,55,4,61],[3,51,3,54],[4,51,4,54],[310,2,311,8],[312,9,312,13],[310,14,310,18],[311,14,311,18],[313,9,313,13],[310,24,310,28],[311,24,311,28],[312,24,312,28],[313,24,313,28],[314,24,314,28],[109,1,109,2],[4,40,4,44],[3,30,3,39],[4,30,4,39],[33,1,33,66],[36,3,36,14],[36,15,36,17],[36,18,36,20],[30,48,30,50],[18,33,18,35],[7,41,7,43],[8,41,8,43],[9,41,9,43],[10,41,10,43],[13,31,13,33],[11,4,11,11],[12,4,12,11],[20,24,20,26],[20,42,20,44],[20,3,20,14],[12,31,12,33],[24,24,24,26],[18,42,18,44],[11,12,11,22],[10,1,10,3],[10,34,10,40],[10,4,10,11],[10,26,10,30],[10,12,10,22],[11,34,11,40],[3,1,3,9],[4,1,4,9],[120,1,120,66],[125,24,125,26],[125,27,125,29],[125,30,125,32],[125,33,125,35],[115,39,115,41],[115,30,115,32],[123,24,123,26],[113,27,113,29],[111,54,111,56],[111,60,111,62],[117,21,117,23],[117,24,117,26],[117,27,117,29],[117,30,117,32],[127,18,127,20],[125,36,125,38],[127,33,127,35],[127,24,127,26],[127,39,127,41],[127,45,127,47],[124,1,124,66],[51,21,51,23],[53,21,53,23],[71,36,71,38],[110,1,110,66],[114,1,114,66],[97,18,97,20],[127,30,127,32],[130,1,130,66],[131,18,131,20],[131,24,131,26],[131,30,131,32],[131,36,131,38],[131,42,131,44],[131,48,131,50],[131,54,131,56],[131,63,131,65],[131,3,131,14],[131,60,131,62],[131,21,131,23],[131,27,131,29],[131,33,131,35],[123,3,123,14],[125,48,125,50],[125,45,125,47],[129,3,129,14],[129,18,129,20],[127,3,127,14],[127,60,127,62],[123,54,123,56],[131,39,131,41],[127,51,127,53],[109,24,109,26],[95,24,95,26],[91,45,91,47],[91,27,91,29],[91,48,91,50],[107,27,107,29],[107,30,107,32],[107,21,107,23],[107,51,107,53],[105,18,105,20],[105,54,105,56],[91,51,91,53],[127,48,127,50],[91,18,91,20],[94,1,94,66],[93,27,93,29],[93,42,93,44],[93,60,93,62],[91,60,91,62],[97,57,97,59],[95,27,95,29],[95,45,95,47],[111,57,111,59],[111,63,111,65],[93,63,93,65],[93,51,93,53],[113,57,113,59],[109,57,109,59],[115,57,115,59],[113,33,113,35],[115,54,115,56],[109,18,109,20],[109,21,109,23],[105,33,105,35],[117,42,117,44],[117,45,117,47],[117,48,117,50],[117,51,117,53],[111,21,111,23],[125,39,125,41],[115,42,115,44],[109,51,109,53],[111,18,111,20],[111,24,111,26],[111,30,111,32],[111,51,111,53],[115,48,115,50],[113,21,113,23],[113,24,113,26],[115,21,115,23],[109,48,109,50],[107,45,107,47],[113,42,113,44],[117,33,117,35],[117,36,117,38],[117,39,117,41],[123,30,123,32],[115,18,115,20],[105,48,105,50],[105,24,105,26],[112,1,112,66],[109,39,109,41],[109,30,109,32],[113,3,113,14],[113,48,113,50],[111,3,111,14],[108,1,108,66],[115,33,115,35],[115,3,115,14],[107,15,107,17],[107,1,107,2],[105,15,105,17],[105,1,105,2],[123,63,123,65],[65,30,65,32],[105,51,105,53],[87,30,87,32],[97,45,97,47],[97,27,97,29],[97,54,97,56],[95,36,95,38],[105,36,105,38],[99,1,99,66],[96,1,96,66],[95,18,95,20],[95,21,95,23],[95,54,95,56],[95,48,95,50],[95,39,95,41],[95,42,95,44],[123,57,123,59],[107,54,107,56],[95,63,95,65],[104,1,104,66],[93,54,93,56],[93,57,93,59],[93,36,93,38],[92,1,92,66],[93,48,93,50],[89,60,89,62],[91,21,91,23],[89,63,89,65],[55,33,55,35],[69,51,69,53],[71,21,71,23],[69,30,69,32],[69,27,69,29],[63,21,63,23],[68,1,68,65],[71,33,71,35],[69,42,69,44],[55,54,55,56],[55,57,55,59],[55,63,55,65],[69,39,69,41],[55,48,55,50],[67,51,67,53],[65,33,65,35],[65,51,65,53],[65,57,65,59],[93,24,93,26],[87,57,87,59],[91,42,91,44],[93,21,93,23],[89,42,89,44],[91,3,91,14],[62,1,62,66],[53,63,53,65],[67,24,67,26],[74,1,74,66],[67,15,67,17],[75,33,75,35],[73,33,73,35],[73,30,73,32],[75,63,75,65],[73,36,73,38],[67,57,67,59],[67,27,67,29],[67,42,67,44],[71,57,71,59],[71,3,71,14],[73,3,73,14],[72,1,72,65],[71,18,71,20],[71,30,71,32],[71,27,71,29],[63,36,63,38],[55,3,55,14],[73,18,73,20],[67,36,67,38],[65,54,65,56],[55,27,55,29],[65,21,65,23],[53,42,53,44],[67,39,67,41],[67,45,67,47],[95,57,95,59],[137,1,137,66],[163,25,163,32],[95,60,95,62],[95,33,95,35],[187,59,187,64],[93,39,93,41],[149,1,149,66],[95,51,95,53],[97,30,97,32],[98,1,98,66],[134,1,134,66],[163,60,163,65],[67,54,67,56],[73,57,73,59],[71,45,71,47],[73,54,73,56],[69,60,69,62],[71,51,71,53],[77,27,77,29],[87,33,87,35],[89,27,89,29],[93,3,93,14],[87,3,87,14],[89,3,89,14],[87,63,87,65],[89,57,89,59],[77,30,77,32],[77,63,77,65],[77,21,77,23],[107,48,107,50],[107,39,107,41],[97,33,97,35],[146,40,146,42],[146,43,146,45],[109,42,109,44],[111,48,111,50],[146,46,146,48],[146,49,146,51],[146,52,146,54],[146,55,146,57],[146,58,146,60],[145,36,145,38],[144,1,144,31],[97,36,97,38],[97,48,97,50],[107,42,107,44],[106,1,106,66],[97,63,97,65],[146,64,146,66],[105,60,105,62],[97,21,97,23],[115,60,115,62],[115,45,115,47],[131,45,131,47],[131,51,131,53],[129,21,129,23],[125,51,125,53],[123,27,123,29],[100,1,100,66],[131,1,131,2],[129,15,129,17],[129,1,129,2],[127,15,127,17],[129,33,129,35],[125,54,125,56],[125,18,125,20],[129,36,129,38],[231,34,233,65],[211,60,211,65],[162,1,162,66],[189,1,205,32],[147,49,147,51],[213,1,229,32],[211,25,211,32],[187,34,187,41],[145,25,145,27],[145,28,145,30],[145,32,145,34],[147,43,147,45],[147,46,147,48],[129,39,129,41],[129,57,129,59],[147,37,147,39],[147,40,147,42],[231,1,233,32],[213,34,229,65],[187,25,187,32],[211,1,211,6],[125,60,125,62],[125,57,125,59],[144,56,144,65],[150,1,150,66],[151,1,151,66],[129,30,129,32],[123,60,123,62],[113,30,113,32],[113,36,113,38],[122,1,122,66],[119,1,119,66],[115,63,115,65],[115,24,115,26],[109,15,109,17],[131,15,131,17],[146,61,146,63],[189,34,205,65],[303,1,305,32],[303,34,305,65],[259,1,259,6],[259,25,259,32],[259,34,259,41],[259,60,259,65],[237,1,253,32],[237,34,253,65],[255,1,257,32],[255,34,257,65],[261,1,277,32],[261,34,277,65],[279,1,281,32],[279,34,281,65],[283,2,283,7],[283,25,283,32],[283,34,283,41],[283,59,283,64],[285,1,301,32],[211,34,211,41],[131,57,131,59],[235,2,235,7],[235,25,235,32],[285,34,301,65],[235,59,235,64],[235,34,235,41],[145,1,145,23],[135,1,135,66],[136,1,136,66],[138,34,138,36],[141,1,141,42],[129,60,129,62],[129,54,129,56],[129,42,129,44],[129,45,129,47],[109,54,109,56],[123,33,123,35],[109,27,109,29],[147,52,147,54],[138,1,138,32],[132,1,132,66],[109,63,109,65],[144,32,144,36],[144,37,144,47],[142,1,142,37],[113,45,113,47],[123,18,123,20],[123,36,123,38],[123,39,123,41],[123,42,123,44],[113,63,113,65],[125,63,125,65],[123,21,123,23],[53,24,53,26],[53,60,53,62],[53,39,53,41],[19,1,19,66],[187,0,209,0],[207,1,209,32],[207,34,209,65],[183,1,185,32],[165,1,181,32],[163,1,163,7],[183,34,185,65],[165,34,181,65],[127,36,127,38],[127,57,127,59],[129,48,129,50],[129,51,129,53],[128,1,128,66],[127,54,127,56],[143,1,143,55],[143,56,143,60],[142,39,142,41],[140,1,140,38],[140,40,140,42],[139,1,139,39],[139,41,139,43],[129,24,129,26],[129,27,129,29],[187,2,187,8],[146,37,146,39],[141,44,141,46],[53,45,53,47],[152,1,152,66],[47,33,47,35],[47,36,47,38],[49,45,49,47],[51,33,51,35],[30,21,30,23],[24,33,24,35],[39,1,39,66],[51,54,51,56],[48,1,48,66],[53,3,53,14],[32,45,32,47],[43,42,43,44],[41,1,41,66],[24,57,24,59],[47,24,47,26],[30,24,30,26],[30,27,30,29],[30,36,30,38],[46,1,46,66],[47,30,47,32],[52,1,52,66],[53,48,53,50],[51,60,51,62],[51,63,51,65],[51,27,51,29],[51,42,51,44],[51,51,51,53],[51,45,51,47],[51,36,51,38],[51,57,51,59],[47,39,47,41],[53,57,53,59],[17,1,17,66],[13,1,13,3],[13,4,13,11],[18,3,18,14],[20,45,20,47],[20,63,20,65],[20,57,20,59],[20,51,20,53],[20,27,20,29],[18,45,18,47],[22,51,22,53],[49,54,49,56],[49,42,49,44],[51,48,51,50],[51,3,51,14],[47,27,47,29],[45,48,45,50],[20,30,20,32],[18,36,18,38],[18,18,18,20],[49,36,49,38],[45,51,45,53],[43,21,43,23],[32,21,32,23],[49,24,49,26],[43,27,43,29],[50,1,50,66],[49,21,49,23],[47,42,47,44],[47,51,47,53],[47,63,47,65],[45,60,45,62],[1,1,1,4],[8,1,8,3],[5,23,5,25],[6,23,6,25],[9,12,9,22],[1,5,1,18],[5,26,5,30],[7,23,7,25],[9,1,9,3],[6,34,6,40],[9,4,9,11],[5,12,5,22],[8,23,8,25],[9,23,9,25],[6,12,6,22],[3,21,3,29],[4,21,4,29],[3,10,3,20],[6,26,6,30],[6,31,6,33],[8,34,8,40],[2,1,2,4],[2,5,2,18],[8,4,8,11],[5,4,5,11],[5,31,5,33],[6,1,6,3],[5,1,5,3],[7,4,7,11],[7,1,7,3],[6,4,6,11],[5,34,5,43],[11,26,11,30],[12,26,12,30],[13,26,13,30],[11,31,11,33],[12,34,12,40],[11,23,11,25],[13,59,13,63],[12,44,12,50],[13,44,13,50],[12,59,12,63],[18,30,18,32],[13,41,13,43],[51,30,51,32],[51,39,51,41],[45,63,45,65],[45,57,45,59],[45,36,45,38],[30,39,30,41],[30,63,30,65],[32,30,32,32],[43,63,43,65],[49,48,49,50],[49,27,49,29],[49,30,49,32],[49,33,49,35],[49,39,49,41],[30,33,30,35],[26,42,26,44],[49,63,49,65],[47,54,47,56],[43,60,43,62],[45,21,45,23],[38,1,38,66],[47,15,47,17],[49,15,49,17],[12,41,12,43],[12,23,12,25],[13,23,13,25],[47,57,47,59],[43,18,43,20],[31,1,31,66],[32,27,32,29],[32,48,32,50],[32,39,32,41],[32,57,32,59],[13,12,13,22],[20,60,20,62],[20,54,20,56],[18,24,18,26],[18,48,18,50],[18,51,18,53],[18,39,18,41],[18,57,18,59],[36,63,36,65],[37,1,37,66],[34,3,34,14],[34,15,34,17],[34,18,34,20],[34,21,34,23],[34,24,34,26],[34,27,34,29],[18,54,18,56],[18,63,18,65],[18,60,18,62],[30,54,30,56],[28,60,28,62],[28,51,28,53],[36,27,36,29],[36,36,36,38],[36,39,36,41],[36,42,36,44],[36,45,36,47],[35,1,35,66],[26,36,26,38],[36,30,36,32],[30,45,30,47],[28,30,28,32],[30,51,30,53],[29,1,29,66],[28,48,28,50],[30,30,30,32],[32,60,32,62],[32,18,32,20],[26,27,26,29],[32,33,32,35],[20,39,20,41],[20,21,20,23],[18,27,18,29],[20,33,20,35],[21,1,21,66],[22,27,22,29],[23,1,23,66],[22,18,22,20],[22,39,22,41],[36,48,36,50],[30,18,30,20],[26,21,26,23],[26,63,26,65],[26,39,26,41],[30,60,30,62],[22,45,22,47],[63,24,63,26],[22,63,22,65],[25,1,25,66],[32,63,32,65],[28,21,28,23],[27,1,27,66],[55,21,55,23],[43,24,43,26],[43,30,43,32],[43,48,43,50],[43,57,43,59],[28,54,28,56],[28,57,28,59],[26,54,26,56],[26,57,26,59],[26,45,26,47],[22,54,22,56],[26,3,26,14],[26,30,26,32],[26,51,26,53],[28,27,28,29],[28,63,28,65],[30,42,30,44],[32,54,32,56],[32,36,32,38],[40,1,40,66],[22,48,22,50],[22,30,22,32],[22,33,22,35],[73,60,73,62],[73,21,73,23],[55,30,55,32],[64,1,64,66],[65,3,65,14],[63,42,63,44],[49,18,49,20],[55,60,55,62],[69,57,69,59],[67,21,67,23],[70,1,70,66],[65,36,65,38],[67,63,67,65],[65,63,65,65],[63,60,63,62],[69,33,69,35],[69,24,69,26],[69,54,69,56],[67,60,67,62],[24,54,24,56],[63,15,63,17],[61,1,61,66],[75,24,75,26],[47,18,47,20],[47,21,47,23],[47,48,47,50],[36,33,36,35],[51,18,51,20],[65,48,65,50],[75,30,75,32],[22,3,22,14],[24,3,24,14],[63,3,63,14],[22,60,22,62],[22,42,22,44],[22,24,22,26],[26,48,26,50],[53,51,53,53],[26,60,26,62],[65,15,65,17],[28,24,28,26],[65,27,65,29],[69,36,69,38],[67,30,67,32],[69,18,69,20],[69,48,69,50],[71,42,71,44],[71,54,71,56],[69,21,69,23],[73,45,73,47],[75,54,75,56],[71,24,71,26],[55,24,55,26],[73,39,73,41],[75,48,75,50],[24,27,24,29],[24,45,24,47],[24,60,24,62],[45,24,45,26],[75,27,75,29],[67,48,67,50],[63,45,63,47],[63,48,63,50],[63,51,63,53],[65,18,65,20],[65,24,65,26],[53,54,53,56],[55,45,55,47],[63,18,63,20],[63,30,63,32],[53,30,53,32],[69,45,69,47],[26,33,26,35],[36,51,36,53],[36,54,36,56],[36,57,36,59],[36,60,36,62],[49,60,49,62],[49,57,49,59],[45,33,45,35],[43,51,43,53],[43,39,43,41],[44,1,44,66],[43,45,43,47],[73,24,73,26],[75,39,75,41],[77,57,77,59],[71,48,71,50],[77,36,77,38],[75,45,75,47],[75,36,75,38],[75,51,75,53],[85,54,85,56],[77,33,77,35],[87,45,87,47],[73,42,73,44],[82,1,82,66],[81,1,81,66],[73,48,73,50],[78,1,78,66],[71,63,71,65],[85,18,85,20],[73,51,73,53],[75,60,75,62],[73,27,73,29],[87,60,87,62],[79,1,79,66],[80,1,80,66],[87,39,87,41],[87,36,87,38],[87,21,87,23],[87,51,87,53],[85,42,85,44],[71,39,71,41],[87,24,87,26],[85,45,85,47],[77,48,77,50],[89,21,89,23],[77,24,77,26],[85,63,85,65],[85,21,85,23],[85,30,85,32],[85,60,85,62],[85,51,85,53],[75,57,75,59],[85,48,85,50],[77,42,77,44],[83,1,83,66],[89,45,89,47],[87,18,87,20],[91,30,91,32],[77,39,77,41],[89,30,89,32],[89,24,89,26],[91,54,91,56],[91,24,91,26],[91,33,91,35],[91,36,91,38],[89,51,89,53],[89,33,89,35],[89,39,89,41],[87,27,87,29],[88,1,88,66],[87,48,87,50],[85,57,85,59],[85,36,85,38],[76,1,76,66],[85,24,85,26],[85,39,85,41],[67,3,67,14],[69,3,69,14],[153,1,153,66],[154,1,154,66],[155,1,155,66],[20,48,20,50],[26,15,26,17],[28,15,28,17],[30,15,30,17],[75,15,75,17],[84,1,84,66],[32,24,32,26],[87,42,87,44],[28,3,28,14],[53,27,53,29],[53,33,53,35],[47,60,47,62],[63,63,63,65],[57,1,57,66],[55,36,55,38],[24,51,24,53],[102,1,102,66],[73,63,73,65],[85,3,85,14],[75,3,75,14],[93,18,93,20],[91,57,91,59],[89,48,89,50],[89,36,89,38],[13,34,13,40],[45,3,45,14],[47,3,47,14],[45,39,45,41],[49,3,49,14],[53,18,53,20],[53,36,53,38],[56,1,56,66],[24,21,24,23],[24,36,24,38],[18,21,18,23],[24,39,24,41],[45,30,45,32],[71,15,71,17],[69,15,69,17],[109,33,109,35],[107,3,107,14],[109,3,109,14],[107,18,107,20],[87,54,87,56],[97,60,97,62],[107,24,107,26],[89,54,89,56],[109,60,109,62],[109,36,109,38],[89,15,89,17],[91,15,91,17],[93,15,93,17],[18,15,18,17],[20,15,20,17],[22,15,22,17],[24,15,24,17],[0,1,0,8],[0,9,0,17],[0,18,0,21],[30,3,30,14],[32,3,32,14],[43,3,43,14],[45,45,45,47],[11,1,11,3],[16,1,16,64],[15,1,15,57],[12,1,12,3],[12,12,12,22],[14,1,14,44],[20,36,20,38],[20,18,20,20],[24,42,24,44],[32,15,32,17],[43,15,43,17],[45,15,45,17],[45,18,45,20],[8,12,8,22],[8,26,8,30],[4,10,4,20],[9,59,9,63],[43,33,43,35],[28,45,28,47],[22,36,22,38],[24,30,24,32],[26,18,26,20]],"merged_total":1304,"flags":["merged_cut"]}
[null,"TAB Partner -",null,null,null,null,null,null,null,{"$f":"'2020 Chain'!H20","v":"National TAB"},null,null,null,null,null,null,null,null,"Tech-",null,null,null,"DALE WHEELER ",null,null,null,null,null,null,null,null,null,null,null,null,null,"CONDITION SURVEY",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Survey Due Date -",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"'2020 Chain'!B20","v":"2022-06-11"}]
[null,"UNIT #",null,null,null,"UNIT NAME",null,null,null,null,null,null,null,null,null,null,null,null,null,"STREET ADDRESS",null,null,null,null,null,null,null,null,null,null,null,null,"CITY",null,null,null,null,null,null,null,null,null,null,"ST",null,"OPERATOR",null,null,null,null,null,null,null,null,null,null,"PHONE #",null,null,null,null,null,null,null,null,"EMAIL"]
[null,{"$f":"'2020 Chain'!A20","v":1763},null,null,null,{"$f":"'2020 Chain'!C20","v":"Clayton FSU"},null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"'2020 Chain'!I20","v":"151 Highway 441 N"},null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"'2020 Chain'!J20","v":"Clayton"},null,null,null,null,null,null,null,null,null,null,{"$f":"'2020 Chain'!K20","v":"GA"},null,{"$f":"'2020 Chain'!L20","v":"Jay Couey"},null,null,null,null,null,null,null,null,null,null,{"$f":"'2020 Chain'!T20","v":"(706) 212-0022"},null,null,null,null,null,null,null,null,{"$f":"'2020 Chain'!U20","v":"01763@chick-fil-a.com"}]
[null,"PROJ. SERV. PROVIDER",null,null,null,null,null,null,null,null,"STRATEGIC REINV CONS",null,null,null,null,null,null,null,null,null,null,"PROGRAM LEAD",null,null,null,null,null,null,null,null,"FIELD CONSULTANT",null,null,null,null,null,null,null,null,null,"PROTO-TYPE",null,null,null,null,"OPEN DATE",null,null,null,null,null,"UNIT AGE",null,null,null,"CONSTR START",null,null,null,null,null,null,"SCOPE OF WORK",null,null,null,null,null,null,null,null,null,null,null,"ARCHITECT"]
[null,{"$f":"'2020 Chain'!O20","v":"Dominic Llanos"},null,null,null,null,null,null,null,null,{"$f":"'2020 Chain'!P20","v":"Troy Buchanan"},null,null,null,null,null,null,null,null,null,null,{"$f":"'2020 Chain'!M20","v":"Rex Powell"},null,null,null,null,null,null,null,null,{"$f":"'2020 Chain'!Q20","v":"Zach Steele"},null,null,null,null,null,null,null,null,null,{"$f":"'2020 Chain'!F20","v":"S04-152"},null,null,null,null,{"$f":"'2020 Chain'!S20","v":"10/28/2004"},null,null,null,null,null,{"$f":"(TODAY()-AT5)/365","v":17.923287671232877},null,null,null,{"$f":"'2020 Chain'!E20","v":"2023-01-07"},null,null,null,null,null,null,{"$f":"'2020 Chain'!D20","v":"MLv2/BI"},null,null,null,null,null,null,null,null,null,null,null,{"$f":"'2020 Chain'!R20","v":"CPH"}]
[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":"IF(MID(AR3,1,2)=\"TX\",\"MARC JENNINGS\",IF(MID(AR3,1,2)=\"AR\",\"MARC JENNINGS\",IF(MID(AR3,1,2)=\"LA\",\"MARC JENNINGS\",IF(MID(AR3,1,2)=\"OK\",\"MARC JENNINGS\",\"\"))))","v":""}]
[null,"AC1",null,null,{"$f":"'2020 Chain'!V20","v":"5615F08095"},null,null,null,null,null,null,null,{"$f":"'2020 Chain'!X20","v":"LGH150S4BH4Y"},null,null,null,null,null,null,null,null,null,null,{"$f":"IF(MID(M7,7,2)=\"05\",\"4\",IF(MID(M7,7,2)=\"06\",\"5\",IF(MID(M7,7,2)=\"07\",\"6\",IF(MID(M7,7,2)=\"08\",\"7.5\",IF(MID(M7,7,2)=\"09\",\"8.5\",IF(MID(M7,7,2)=\"12\",\"10\",IF(MID(M7,7,2)=\"14\",\"12.5\",IF(MID(M7,7,2)=\"16\",\"15\",IF(MID(M7,4,3)=\"300\",\"25\",IF(MID(M7,4,3)=\"210\",\"17.5\",IF(MID(M7,4,3)=\"180\",\"15\",IF(MID(M7,4,3)=\"150\",\"12.5\",IF(MID(M7,4,3)=\"120\",\"10\",IF(MID(M7,4,3)=\"102\",\"8.5\",IF(MID(M7,4,3)=\"090\",\"7.5\",IF(MID(M7,4,3)=\"092\",\"7.5\",IF(MID(M7,4,3)=\"072\",\"6\",IF(MID(M7,4,3)=\"060\",\"5\",IF(MID(M7,4,3)=\"036\",\"3\",IF(MID(M7,4,3)=\"048\",\"4\",\"\"))))))))))))))))))))","v":"12.5"},null,null,{"$f":"IF(ISBLANK(M7),\"\",IF(MID(M7,1,3)=\"LHC\",\"Lennox\",IF(MID(M7,1,3)=\"LHA\",\"Lennox\",IF(MID(M7,1,3)=\"KHA\",\"Lennox\",IF(MID(M7,1,2)=\"LG\",\"Lennox\",\"Carrier\")))))","v":"Lennox"},null,null,null,null,{"$f":"'2020 Chain'!Z20","v":7.3260273972602743},null,null,{"$f":"IF(ISBLANK(E7),\"\",IF(MID(M7,1,3)=\"YSC\",\"TRANE\",IF(MID(M7,1,3)=\"50K\",\"WEAMaker SE\",IF(MID(M7,1,4)=\"48ES\",\"Comfort\",IF(MID(M7,1,3)=\"48H\",\"WEAMaster HE\",IF(MID(M7,1,3)=\"48T\",\"WEAMaker SE\",IF(MID(M7,3,2)=\"HP\",\"HEAT PUMP\",IF(COUNT(FIND({5610,5611,5612,5613,5614,5615,5616,5617,5618,5619,5620,5621},E7))>0,\"ENERGENCE/\",\"L SERIES/\"))))))))","v":"ENERGENCE/"},null,null,null,null,null,null,{"$f":"'2020 Chain'!W20","v":0},null,null,{"$f":"IF(MID(AO5,1,7)=\"S97-100\",\"RR/DIN A/ENTA\",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)=\"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,4)=\"S08A\",\"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(V19=15,\"2518\",IF(V19=12.5,\"2518\",IF(V19=10,\"2352\",IF(V19=8.5,\"2352\",IF(V19=7.5,\"1911\",IF(V19=6,\"1911\",IF(V19=5,\"1828\",IF(V19=4,\"1828\",\"0\")))))))))","v":0},null,null,null,{"$f":"VALUE(IF(V21=15,\"9662\",IF(V21=12.5,\"9662\",IF(V21=10,\"6452\",IF(V21=8.5,\"6452\",IF(V21=7.5,\"5397\",IF(V21=6,\"5397\",IF(V21=5,\"4161\",IF(V21=4,\"4161\",\"0\")))))))))","v":0},null,null,null,{"$f":"VALUE(IF(V$23=15,\"475\",IF(V$23=12.5,\"475\",IF(V$23=10,\"475\",IF(V$23=8.5,\"475\",IF(V$23=7.5,\"475\",IF(V$23=6,\"475\",IF(V$23=5,\"475\",IF(V$23=4,\"475\",\"0\")))))))))","v":0},null,null,null,null,{"$f":"VALUE(IF(V$25=15,\"9662\",IF(V$25=12.5,\"9662\",IF(V$25=10,\"6452\",IF(V$25=8.5,\"6452\",IF(V$25=7.5,\"5397\",IF(V$25=6,\"5397\",IF(V$25=5,\"4161\",IF(V$25=4,\"4161\",\"0\")))))))))","v":0},null,null,null,null,null,{"$f":"VALUE(IF(V$27=15,\"537\",IF(V$27=12.5,\"537\",IF(V$27=10,\"537\",IF(V$27=8.5,\"537\",IF(V$27=7.5,\"437\",IF(V$27=6,\"537\",IF(V$27=5,\"537\",IF(V$27=4,\"537\",\"0\")))))))))","v":0},null,null,null,{"$f":"SUM(AZ7:BS7)","v":0}]
[null,"AC2",null,null,{"$f":"'2020 Chain'!AB20","v":"5616J13617"},null,null,null,null,null,null,null,{"$f":"'2020 Chain'!AD20","v":"LGH102H4BH3Y"},null,null,null,null,null,null,null,null,null,null,{"$f":"IF(MID(M8,7,2)=\"05\",\"4\",IF(MID(M8,7,2)=\"06\",\"5\",IF(MID(M8,7,2)=\"07\",\"6\",IF(MID(M8,7,2)=\"08\",\"7.5\",IF(MID(M8,7,2)=\"09\",\"8.5\",IF(MID(M8,7,2)=\"12\",\"10\",IF(MID(M8,7,2)=\"14\",\"12.5\",IF(MID(M8,7,2)=\"16\",\"15\",IF(MID(M8,4,3)=\"300\",\"25\",IF(MID(M8,4,3)=\"210\",\"17.5\",IF(MID(M8,4,3)=\"180\",\"15\",IF(MID(M8,4,3)=\"150\",\"12.5\",IF(MID(M8,4,3)=\"120\",\"10\",IF(MID(M8,4,3)=\"102\",\"8.5\",IF(MID(M8,4,3)=\"090\",\"7.5\",IF(MID(M8,4,3)=\"092\",\"7.5\",IF(MID(M8,4,3)=\"072\",\"6\",IF(MID(M8,4,3)=\"060\",\"5\",IF(MID(M8,4,3)=\"036\",\"3\",IF(MID(M8,4,3)=\"048\",\"4\",\"\"))))))))))))))))))))","v":"8.5"},null,null,{"$f":"IF(ISBLANK(M8),\"\",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,2)=\"LG\",\"Lennox\",\"Carrier\")))))","v":"Lennox"},null,null,null,null,{"$f":"'2020 Chain'!AF20","v":6.0712328767123287},null,null,{"$f":"IF(ISBLANK(E8),\"\",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(COUNT(FIND({5610,5611,5612,5613,5614,5615,5616,5617,5618,5619,5620,5621},E8))>0,\"ENERGENCE/\",\"L SERIES/\"))))))))","v":"ENERGENCE/"},null,null,null,null,null,null,{"$f":"'2020 Chain'!AC20","v":0},null,null,{"$f":"IF(MID(AO5,1,7)=\"S97-100\",\"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(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,6)=\"S08N-T\",\"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(AB19=15,\"2518\",IF(AB19=12.5,\"2518\",IF(AB19=10,\"2352\",IF(AB19=8.5,\"2352\",IF(AB19=7.5,\"1911\",IF(AB19=6,\"1911\",IF(AB19=5,\"1828\",IF(AB19=4,\"1828\",\"0\")))))))))","v":0},null,null,null,{"$f":"VALUE(IF(AB21=15,\"9662\",IF(AB21=12.5,\"9662\",IF(AB21=10,\"6452\",IF(AB21=8.5,\"6452\",IF(AB21=7.5,\"5397\",IF(AB21=6,\"5397\",IF(AB21=5,\"4161\",IF(AB21=4,\"4151\",\"0\")))))))))","v":0},null,null,null,{"$f":"VALUE(IF(AB$23=15,\"475\",IF(AB$23=12.5,\"475\",IF(AB$23=10,\"475\",IF(AB$23=8.5,\"475\",IF(AB$23=7.5,\"475\",IF(AB$23=6,\"475\",IF(AB$23=5,\"475\",IF(AB$23=4,\"475\",\"0\")))))))))","v":0},null,null,null,null,{"$f":"VALUE(IF(AB$25=15,\"9662\",IF(AB$25=12.5,\"9662\",IF(AB$25=10,\"6452\",IF(AB$25=8.5,\"6452\",IF(AB$25=7.5,\"5397\",IF(AB$25=6,\"5397\",IF(AB$25=5,\"4161\",IF(AB$25=4,\"4161\",\"0\")))))))))","v":0},null,null,null,null,null,{"$f":"VALUE(IF(AB$27=15,\"537\",IF(AB$27=12.5,\"537\",IF(AB$27=10,\"537\",IF(AB$27=8.5,\"537\",IF(AB$27=7.5,\"437\",IF(AB$27=6,\"537\",IF(AB$27=5,\"537\",IF(AB$27=4,\"537\",\"0\")))))))))","v":0},null,null,null,0]
[null,"AC3",null,null,{"$f":"'2020 Chain'!AH20","v":"5616E03711"},null,null,null,null,null,null,null,{"$f":"'2020 Chain'!AJ20","v":"LGH092H4MM2Y"},null,null,null,null,null,null,null,null,null,null,"7.5",null,null,{"$f":"IF(ISBLANK(M9),\"\",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,2)=\"LG\",\"Lennox\",\"Carrier\")))))","v":"Lennox"},null,null,null,null,{"$f":"'2020 Chain'!AL20","v":6.4082191780821915},null,null,{"$f":"IF(ISBLANK(E9),\"\",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(COUNT(FIND({5610,5611,5612,5613,5614,5615,5616,5617,5618,5619,5620,5621},E9))>0,\"ENERGENCE/\",\"L SERIES/\"))))))))","v":"ENERGENCE/"},null,null,null,null,null,null,{"$f":"'2020 Chain'!AI20","v":0},null,null,{"$f":"IF(MID(AO5,1,7)=\"S97-100\",\"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)=\"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,6)=\"S08N-T\",\"DIN B\",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(AH19=15,\"2518\",IF(AH19=12.5,\"2518\",IF(AH19=10,\"2352\",IF(AH19=8.5,\"2352\",IF(AH19=7.5,\"1911\",IF(AH19=6,\"1911\",IF(AH19=5,\"1828\",IF(AH19=4,\"1828\",\"0\")))))))))","v":0},null,null,null,{"$f":"VALUE(IF(AH21=15,\"9662\",IF(AH21=12.5,\"9662\",IF(AH21=10,\"6452\",IF(AH21=8.5,\"6452\",IF(AH21=7.5,\"5397\",IF(AH21=6,\"5397\",IF(AH21=5,\"4161\",IF(AH21=4,\"4151\",\"0\")))))))))","v":0},null,null,null,{"$f":"VALUE(IF(AH$23=15,\"475\",IF(AH$23=12.5,\"475\",IF(AH$23=10,\"475\",IF(AH$23=8.5,\"475\",IF(AH$23=7.5,\"475\",IF(AH$23=6,\"475\",IF(AH$23=5,\"475\",IF(AH$23=4,\"475\",\"0\")))))))))","v":0},null,null,null,null,{"$f":"VALUE(IF(AH$25=15,\"9662\",IF(AH$25=12.5,\"9662\",IF(AH$25=10,\"6452\",IF(AH$25=8.5,\"6452\",IF(AH$25=7.5,\"5397\",IF(AH$25=6,\"5397\",IF(AH$25=5,\"4161\",IF(AH$25=4,\"4161\",\"0\")))))))))","v":0},null,null,null,null,null,{"$f":"VALUE(IF(AH$27=15,\"537\",IF(AH$27=12.5,\"537\",IF(AH$27=10,\"537\",IF(AH$27=8.5,\"537\",IF(AH$27=7.5,\"437\",IF(AH$27=6,\"537\",IF(AH$27=5,\"537\",IF(AH$27=4,\"537\",\"0\")))))))))","v":0},null,null,null,0]
[null,"AC4",null,null,{"$f":"'2020 Chain'!AN20","v":"5616G07446"},null,null,null,null,null,null,null,{"$f":"'2020 Chain'!AP20","v":"LGH120H4BH3Y"},null,null,null,null,null,null,null,null,null,null,"10",null,null,"Lennox",null,null,null,null,{"$f":"'2020 Chain'!AR20","v":6.2410958904109588},null,null,{"$f":"IF(ISBLANK(E10),\"\",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(COUNT(FIND({5610,5611,5612,5613,5614,5615,5616,5617,5618,5619,5620,5621},E10))>0,\"ENERGENCE/\",\"L SERIES/\"))))))))","v":"ENERGENCE/"},null,null,null,null,null,null,{"$f":"'2020 Chain'!AO20","v":0},null,null,{"$f":"IF(MID(AO5,1,7)=\"S97-100\",\"DIN B/ENT A/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)=\"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,6)=\"S08N-T\",\"DT,SERV/DIN B\",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":"ENTA/DIN B"},null,null,null,null,null,null,{"$f":"VALUE(IF(AN19=15,\"2518\",IF(AN19=12.5,\"2518\",IF(AN19=10,\"2352\",IF(AN19=8.5,\"2352\",IF(AN19=7.5,\"1911\",IF(AN19=6,\"1911\",IF(AN19=5,\"1828\",IF(AN19=4,\"1828\",\"0\")))))))))","v":0},null,null,null,{"$f":"VALUE(IF(AN21=15,\"9662\",IF(AN21=12.5,\"9662\",IF(AN21=10,\"6452\",IF(AN21=8.5,\"6452\",IF(AN21=7.5,\"5397\",IF(AN21=6,\"5397\",IF(AN21=5,\"4161\",IF(AN21=4,\"4151\",\"0\")))))))))","v":0},null,null,null,{"$f":"VALUE(IF(AN$23=15,\"475\",IF(AN$23=12.5,\"475\",IF(AN$23=10,\"475\",IF(AN$23=8.5,\"475\",IF(AN$23=7.5,\"475\",IF(AN$23=6,\"475\",IF(AN$23=5,\"475\",IF(AN$23=4,\"475\",\"0\")))))))))","v":0},null,null,null,null,{"$f":"VALUE(IF(AN$25=15,\"9662\",IF(AN$25=12.5,\"9662\",IF(AN$25=10,\"6452\",IF(AN$25=8.5,\"6452\",IF(AN$25=7.5,\"5397\",IF(AN$25=6,\"5397\",IF(AN$25=5,\"4161\",IF(AN$25=4,\"4161\",\"0\")))))))))","v":0},null,null,null,null,null,{"$f":"VALUE(IF(AN$27=15,\"537\",IF(AN$27=12.5,\"537\",IF(AN$27=10,\"537\",IF(AN$27=8.5,\"537\",IF(AN$27=7.5,\"437\",IF(AN$27=6,\"537\",IF(AN$27=5,\"537\",IF(AN$27=4,\"537\",\"0\")))))))))","v":0},null,null,null,0]
[null,"AC5",null,null,{"$f":"'2020 Chain'!AT20","v":"5616J01065"},null,null,null,null,null,null,null,{"$f":"'2020 Chain'!AV20","v":"LGH072H4BH4Y"},null,null,null,null,null,null,null,null,null,null,{"$f":"IF(MID(M11,7,2)=\"05\",\"4\",IF(MID(M11,7,2)=\"06\",\"5\",IF(MID(M11,7,2)=\"07\",\"6\",IF(MID(M11,7,2)=\"08\",\"7.5\",IF(MID(M11,7,2)=\"09\",\"8.5\",IF(MID(M11,7,2)=\"12\",\"10\",IF(MID(M11,7,2)=\"14\",\"12.5\",IF(MID(M11,7,2)=\"16\",\"15\",IF(MID(M11,4,3)=\"300\",\"25\",IF(MID(M11,4,3)=\"210\",\"17.5\",IF(MID(M11,4,3)=\"180\",\"15\",IF(MID(M11,4,3)=\"150\",\"12.5\",IF(MID(M11,4,3)=\"120\",\"10\",IF(MID(M11,4,3)=\"102\",\"8.5\",IF(MID(M11,4,3)=\"090\",\"7.5\",IF(MID(M11,4,3)=\"092\",\"7.5\",IF(MID(M11,4,3)=\"072\",\"6\",IF(MID(M11,4,3)=\"060\",\"5\",IF(MID(M11,4,3)=\"036\",\"3\",IF(MID(M11,4,3)=\"048\",\"4\",\"\"))))))))))))))))))))","v":"6"},null,null,"Lennox",null,null,null,null,{"$f":"'2020 Chain'!AX20","v":6.0712328767123287},null,null,{"$f":"IF(ISBLANK(E11),\"\",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(COUNT(FIND({5610,5611,5612,5613,5614,5615,5616,5617,5618,5619,5620,5621},E11))>0,\"ENERGENCE/\",\"L SERIES/\"))))))))","v":"ENERGENCE/"},null,null,null,null,null,null,{"$f":"'2020 Chain'!AU20","v":0},null,null,{"$f":"IF(MID(AO5,1,7)=\"S97-120\",\"PLAY LAND\",IF(MID(AO5,1,7)=\"S97-136\",\"PLAYLANAD\",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,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(AT19=15,\"2518\",IF(AT19=12.5,\"2518\",IF(AT19=10,\"2352\",IF(AT19=8.5,\"2352\",IF(AT19=7.5,\"1911\",IF(AT19=6,\"1911\",IF(AT19=5,\"1828\",IF(AT19=4,\"1828\",\"0\")))))))))","v":0},null,null,null,{"$f":"VALUE(IF(AT21=15,\"9662\",IF(AT21=12.5,\"9662\",IF(AT21=10,\"6452\",IF(AT21=8.5,\"6452\",IF(AT21=7.5,\"5397\",IF(AT21=6,\"5397\",IF(AT21=5,\"4161\",IF(AT21=4,\"4151\",\"0\")))))))))","v":0},null,null,null,{"$f":"VALUE(IF(AT$23=15,\"475\",IF(AT$23=12.5,\"475\",IF(AT$23=10,\"475\",IF(AT$23=8.5,\"475\",IF(AT$23=7.5,\"475\",IF(AT$23=6,\"475\",IF(AT$23=5,\"475\",IF(AT$23=4,\"475\",\"0\")))))))))","v":0},null,null,null,null,{"$f":"VALUE(IF(AT$25=15,\"9662\",IF(AT$25=12.5,\"9662\",IF(AT$25=10,\"6452\",IF(AT$25=8.5,\"6452\",IF(AT$25=7.5,\"5397\",IF(AT$25=6,\"5397\",IF(AT$25=5,\"4161\",IF(AT$25=4,\"4161\",\"0\")))))))))","v":0},null,null,null,null,null,{"$f":"VALUE(IF(AT$27=15,\"537\",IF(AT$27=12.5,\"537\",IF(AT$27=10,\"537\",IF(AT$27=8.5,\"537\",IF(AT$27=7.5,\"437\",IF(AT$27=6,\"537\",IF(AT$27=5,\"537\",IF(AT$27=4,\"537\",\"0\")))))))))","v":0},null,null,null,0]
[null,"AC6",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"IF(MID(M12,7,2)=\"05\",\"4\",IF(MID(M12,7,2)=\"06\",\"5\",IF(MID(M12,7,2)=\"07\",\"6\",IF(MID(M12,7,2)=\"08\",\"7.5\",IF(MID(M12,7,2)=\"09\",\"8.5\",IF(MID(M12,7,2)=\"12\",\"10\",IF(MID(M12,7,2)=\"14\",\"12.5\",IF(MID(M12,7,2)=\"16\",\"15\",IF(MID(M12,4,3)=\"300\",\"25\",IF(MID(M12,4,3)=\"210\",\"17.5\",IF(MID(M12,4,3)=\"180\",\"15\",IF(MID(M12,4,3)=\"150\",\"12.5\",IF(MID(M12,4,3)=\"120\",\"10\",IF(MID(M12,4,3)=\"102\",\"8.5\",IF(MID(M12,4,3)=\"090\",\"7.5\",IF(MID(M12,4,3)=\"092\",\"7.5\",IF(MID(M12,4,3)=\"072\",\"6\",IF(MID(M12,4,3)=\"060\",\"5\",IF(MID(M12,4,3)=\"036\",\"3\",IF(MID(M12,4,3)=\"048\",\"4\",\"\"))))))))))))))))))))","v":""},null,null,{"$f":"IF(ISBLANK(M12),\"\",IF(MID(M12,1,2)=\"LG\",\"Lennox\",\"Carrier\"))","v":""},null,null,null,null,{"$f":"'2020 Chain'!BC20","v":0},null,null,{"$f":"IF(ISBLANK(E12),\"\",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,1,3)=\"50H\",\"WEAMaster HP\",IF(COUNT(FIND({5610,5611,5612,5613,5614,5615,5616,5617,5618,5619,5620,5621},E12))>0,\"ENERGENCE\",\"L SERIES\")))))))","v":""},null,null,null,null,null,null,null,null,null,{"$f":"IF(MID(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(AZ19=15,\"2518\",IF(AZ19=12.5,\"2518\",IF(AZ19=10,\"2352\",IF(AZ19=8.5,\"2352\",IF(AZ19=7.5,\"1911\",IF(AZ19=6,\"1911\",IF(AZ19=5,\"1828\",IF(AZ19=4,\"1828\",\"0\")))))))))","v":0},null,null,null,{"$f":"VALUE(IF(AZ21=15,\"9662\",IF(AZ21=12.5,\"9662\",IF(AZ21=10,\"6452\",IF(AZ21=8.5,\"6452\",IF(AZ21=7.5,\"5397\",IF(AZ21=6,\"5397\",IF(AZ21=5,\"4161\",IF(AZ21=4,\"4151\",\"0\")))))))))","v":0},null,null,null,{"$f":"VALUE(IF(AZ$23=15,\"475\",IF(AZ$23=12.5,\"475\",IF(AZ$23=10,\"475\",IF(AZ$23=8.5,\"475\",IF(AZ$23=7.5,\"475\",IF(AZ$23=6,\"475\",IF(AZ$23=5,\"475\",IF(AZ$23=4,\"475\",\"0\")))))))))","v":0},null,null,null,null,{"$f":"VALUE(IF(AZ$25=15,\"9662\",IF(AZ$25=12.5,\"9662\",IF(AZ$25=10,\"6452\",IF(AZ$25=8.5,\"6452\",IF(AZ$25=7.5,\"5397\",IF(AZ$25=6,\"5397\",IF(AZ$25=5,\"4161\",IF(AZ$25=4,\"4161\",\"0\")))))))))","v":0},null,null,null,null,null,{"$f":"VALUE(IF(AZ$27=15,\"537\",IF(AZ$27=12.5,\"537\",IF(AZ$27=10,\"537\",IF(AZ$27=8.5,\"537\",IF(AZ$27=7.5,\"437\",IF(AZ$27=6,\"537\",IF(AZ$27=5,\"537\",IF(AZ$27=4,\"537\",\"0\")))))))))","v":0},null,null,null,0]
[null,"AC7",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"IF(MID(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)=\"060\",\"5\",IF(MID(M13,4,3)=\"048\",\"4\",\"\")))))))","v":""},null,null,"",null,null,null,null,null,null,null,{"$f":"IF(ISBLANK(E13),\"\",IF(MID(M13,1,3)=\"50K\",\"WEAMaker SE\",IF(MID(M13,1,4)=\"48ES\",\"Comfort\",IF(MID(M13,1,3)=\"48H\",\"WEAMaster HE\",IF(MID(M13,1,3)=\"48T\",\"WEAMaker SE\",IF(COUNT(FIND({5610,5611,5612,5613,5614,5615,5616,5617,5618,5619,5620,5621},E13))>0,\"ENERGENCE\",\"L SERIES\"))))))","v":""},null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"VALUE(IF(BF19=15,\"2518\",IF(BF19=12.5,\"2518\",IF(BF19=10,\"2352\",IF(BF19=8.5,\"2352\",IF(BF19=7.5,\"1911\",IF(BF19=6,\"1911\",IF(BF19=5,\"1828\",IF(BF19=4,\"1828\",\"0\")))))))))","v":0},null,null,null,{"$f":"VALUE(IF(BF21=15,\"9662\",IF(BF21=12.5,\"9662\",IF(BF21=10,\"6452\",IF(BF21=8.5,\"6452\",IF(BF21=7.5,\"5397\",IF(BF21=6,\"5397\",IF(BF21=5,\"4161\",IF(BF21=4,\"4151\",\"0\")))))))))","v":0},null,null,null,{"$f":"VALUE(IF(BF$23=15,\"475\",IF(BF$23=12.5,\"475\",IF(BF$23=10,\"475\",IF(BF$23=8.5,\"475\",IF(BF$23=7.5,\"475\",IF(BF$23=6,\"475\",IF(BF$23=5,\"475\",IF(BF$23=4,\"475\",\"0\")))))))))","v":0},null,null,null,null,{"$f":"VALUE(IF(BF$25=15,\"9662\",IF(BF$25=12.5,\"9662\",IF(BF$25=10,\"6452\",IF(BF$25=8.5,\"6452\",IF(BF$25=7.5,\"5397\",IF(BF$25=6,\"5397\",IF(BF$25=5,\"4161\",IF(BF$25=4,\"4161\",\"0\")))))))))","v":0},null,null,null,null,null,{"$f":"VALUE(IF(BF$27=15,\"537\",IF(BF$27=12.5,\"537\",IF(BF$27=10,\"537\",IF(BF$27=8.5,\"537\",IF(BF$27=7.5,\"437\",IF(BF$27=6,\"537\",IF(BF$27=5,\"537\",IF(BF$27=4,\"537\",\"0\")))))))))","v":0},null,null,null,0]
[null,"AC8",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"",null,null,"",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"TOTAL",null,null,null,null,null,null,{"$f":"VALUE(SUM(AZ7:AZ13))","v":0},null,null,null,{"$f":"SUM(BD7:BD13)","v":0},null,null,null,{"$f":"SUM(BH7:BH13)","v":0},null,null,null,null,{"$f":"SUM(BM7:BM13)","v":0},null,null,null,null,null,{"$f":"SUM(BS7:BS13)","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,"C",null,null,"AC2",null,null,"C",null,null,"AC3",null,null,"C",null,null,"AC4",null,null,"C",null,null,"AC5",null,null,"C",null,null,"AC6",null,null,{"$f":"IF(ISBLANK($E$12),\"N/A\",\"\")","v":"N/A"},null,null,"AC7",null,null,{"$f":"IF(ISBLANK($E$13),\"N/A\",\"\")","v":"N/A"},null,null,"AC8",null,null,{"$f":"IF(ISBLANK($E$14),\"N/A\",\"\")","v":"N/A"}]
[null,"2.  Quantify damage/deterioration to the condenser coil (0% to 100%).  If greater than 50% enter unit tonnage."]
[null,null,null,"CRITICAL",null,null,null,null,null,null,null,null,null,null,null,null,null,null,"AC1",null,null,{"$f":"IF(ISBLANK($E$7),\"N/A\",IF(MID($M$7,7,2)=\"14\",\"N/A\",IF(MID($M$7,7,2)=\"16\",\"N/A\",IF(MID($M$7,7,2)<\"14\",\"\",IF(MID($M$7,4,3)>\"149\",\"N/A\",\"\")))))","v":"N/A"},null,null,"AC2",null,null,"C",null,null,"AC3",null,null,"C",null,null,"AC4",null,null,"C",null,null,"AC5",null,null,"C",null,null,"AC6",null,null,{"$f":"IF(ISBLANK($E$12),\"N/A\",\"\")","v":"N/A"},null,null,"AC7",null,null,{"$f":"IF(ISBLANK($E$13),\"N/A\",\"\")","v":"N/A"},null,null,"AC8",null,null,{"$f":"IF(ISBLANK($E$14),\"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":"IF(ISBLANK($E$7),\"N/A\",IF(MID($M$7,7,2)=\"14\",\"N/A\",IF(MID($M$7,7,2)=\"16\",\"N/A\",IF(MID($M$7,7,2)<\"14\",\"\",IF(MID($M$7,4,3)>\"149\",\"N/A\",\"\")))))","v":"N/A"},null,null,"AC2",null,null,"C",null,null,"AC3",null,null,"C",null,null,"AC4",null,null,"C",null,null,"AC5",null,null,"C",null,null,"AC6",null,null,{"$f":"IF(ISBLANK($E$12),\"N/A\",\"\")","v":"N/A"},null,null,"AC7",null,null,{"$f":"IF(ISBLANK($E$13),\"N/A\",\"\")","v":"N/A"},null,null,"AC8",null,null,{"$f":"IF(ISBLANK($E$14),\"N/A\",\"\")","v":"N/A"}]
[null,"4.  Check both sides of evaporator coil for deterioration.  Perform fin test. If greater than 50% enter unit tonnage"]
[null,null,null,"CRITICAL",null,null,null,null,null,null,null,null,null,null,null,null,null,null,"AC1",null,null,{"$f":"IF(ISBLANK($E$7),\"N/A\",IF(MID($M$7,7,2)=\"14\",\"N/A\",IF(MID($M$7,7,2)=\"16\",\"N/A\",IF(MID($M$7,7,2)<\"14\",\"\",IF(MID($M$7,4,3)>\"149\",\"N/A\",\"\")))))","v":"N/A"},null,null,"AC2",null,null,"C",null,null,"AC3",null,null,"C",null,null,"AC4",null,null,"C",null,null,"AC5",null,null,"C",null,null,"AC6",null,null,{"$f":"IF(ISBLANK($E$12),\"N/A\",\"\")","v":"N/A"},null,null,"AC7",null,null,{"$f":"IF(ISBLANK($E$13),\"N/A\",\"\")","v":"N/A"},null,null,"AC8",null,null,{"$f":"IF(ISBLANK($E$14),\"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.  Check for barometric exhaust at AC units less than or equal ten tons.  If no barometic exhaust, enter unit tonnage."]
[null,null,null,"CRITICAL",null,null,null,null,null,null,null,null,null,null,null,null,null,null,"AC1",null,null,{"$f":"IF(ISBLANK($E$7),\"N/A\",IF(MID($M$7,7,2)=\"14\",\"N/A\",IF(MID($M$7,7,2)=\"16\",\"N/A\",IF(MID($M$7,7,2)<\"14\",\"\",IF(MID($M$7,4,3)>\"149\",\"N/A\",\"\")))))","v":"N/A"},null,null,"AC2",null,null,"C",null,null,"AC3",null,null,"C",null,null,"AC4",null,null,"C",null,null,"AC5",null,null,"C",null,null,"AC6",null,null,{"$f":"IF(ISBLANK($E$12),\"N/A\",\"\")","v":"N/A"},null,null,"AC7",null,null,{"$f":"IF(ISBLANK($E$13),\"N/A\",\"\")","v":"N/A"},null,null,"AC8",null,null,{"$f":"IF(ISBLANK($E$14),\"N/A\",\"\")","v":"N/A"}]
[null,"6.  Are there curb adaptors on any of the units?  If YES, enter unit tonnage."]
[null,null,null,"CRITICAL",null,null,null,null,null,null,null,null,null,null,null,null,null,null,"AC1",null,null,{"$f":"IF(ISBLANK($E$7),\"N/A\",IF(MID($M$7,7,2)=\"14\",\"N/A\",IF(MID($M$7,7,2)=\"16\",\"N/A\",IF(MID($M$7,7,2)<\"14\",\"\",IF(MID($M$7,4,3)>\"149\",\"N/A\",\"\")))))","v":"N/A"},null,null,"AC2",null,null,"C",null,null,"AC3",null,null,"C",null,null,"AC4",null,null,"C",null,null,"AC5",null,null,6,null,null,"AC6",null,null,{"$f":"IF(ISBLANK($E$12),\"N/A\",\"\")","v":"N/A"},null,null,"AC7",null,null,{"$f":"IF(ISBLANK($E$13),\"N/A\",\"\")","v":"N/A"},null,null,"AC8",null,null,{"$f":"IF(ISBLANK($E$14),\"N/A\",\"\")","v":"N/A"}]
[null,"7.  See identified Humiditrol units below (HUM = HUMIDITROL)."]
[null,null,null,"NON CRITICAL",null,null,null,null,null,null,null,null,null,null,null,null,null,null,"AC1",null,null,{"$f":"IF(ISBLANK($E$7),\"N/A\",IF(MID(AP7,1,3)=\"HUM\",\"HUM\",\"NO\"))","v":"NO"},null,null,"AC2",null,null,{"$f":"IF(ISBLANK($E$8),\"N/A\",IF(MID(AP8,1,3)=\"HUM\",\"HUM\",\"NO\"))","v":"NO"},null,null,"AC3",null,null,{"$f":"IF(ISBLANK($E$9),\"N/A\",IF(MID(AP9,1,3)=\"HUM\",\"HUM\",\"NO\"))","v":"NO"},null,null,"AC4",null,null,{"$f":"IF(ISBLANK($E$10),\"N/A\",IF(MID(AP10,1,3)=\"HUM\",\"HUM\",\"NO\"))","v":"NO"},null,null,"AC5",null,null,{"$f":"IF(ISBLANK($E$11),\"N/A\",IF(MID(AP11,1,3)=\"HUM\",\"HUM\",\"NO\"))","v":"NO"},null,null,"AC6",null,null,{"$f":"IF(ISBLANK($E$12),\"N/A\",IF(MID(AP12,1,3)=\"HUM\",\"HUM\",\"NO\"))","v":"N/A"},null,null,"AC7",null,null,{"$f":"IF(ISBLANK($E$13),\"N/A\",\"\")","v":"N/A"},null,null,"AC8",null,null,{"$f":"IF(ISBLANK($E$14),\"N/A\",\"\")","v":"N/A"}]
[null,"8.  Is the humidity sensor wired?  If NO,  enter unit tonnage."]
[null,null,null,"CRITICAL",null,null,null,null,null,null,null,null,null,null,null,null,null,null,"AC1",null,null,{"$f":"IF(ISBLANK($E$7),\"N/A\",IF(MID($M$7,7,2)=\"14\",\"N/A\",IF(MID($M$7,7,2)=\"16\",\"N/A\",IF(MID($M$7,7,2)<\"14\",\"\",IF(MID($M$7,4,3)>\"149\",\"N/A\",IF(MID(V31,1,2)=\"NO\",\"N/A\",\"\"))))))","v":"N/A"},null,null,"AC2",null,null,{"$f":"IF(ISBLANK($E$8),\"N/A\",IF(MID($M$8,7,2)=\"14\",\"N/A\",IF(MID($M$8,7,2)=\"16\",\"N/A\",IF(MID($M$8,7,2)<\"14\",\"\",IF(MID($M$8,4,3)>\"149\",\"N/A\",IF(MID(AB31,1,2)=\"NO\",\"N/A\",\"\"))))))","v":"N/A"},null,null,"AC3",null,null,{"$f":"IF(ISBLANK($E$9),\"N/A\",IF(LEN($M$9)>15,\"N/A\",IF(MID(AH31,1,2)=\"NO\",\"N/A\",\"\")))","v":"N/A"},null,null,"AC4",null,null,{"$f":"IF(ISBLANK($E$10),\"N/A\",IF(LEN($M$10)>15,\"N/A\",IF(MID(AN31,1,2)=\"NO\",\"N/A\",\"\")))","v":"N/A"},null,null,"AC5",null,null,{"$f":"IF(ISBLANK($E$11),\"N/A\",IF(LEN($M$11)>15,\"N/A\",IF(MID(AT31,1,2)=\"NO\",\"N/A\",\"\")))","v":"N/A"},null,null,"AC6",null,null,{"$f":"IF(ISBLANK($E$12),\"N/A\",\"\")","v":"N/A"},null,null,"AC7",null,null,{"$f":"IF(ISBLANK($E$13),\"N/A\",\"\")","v":"N/A"},null,null,"AC8",null,null,{"$f":"IF(ISBLANK($E$14),\"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":"Y313","v":"2\""},null,null,"B2",null,null,{"$f":"Y314","v":"2\""},null,null,"B3",null,null,{"$f":"Y315","v":"2\""},null,null,"B4",null,null,{"$f":"Y316","v":"1-1/2\""},null,null,"B5",null,null,{"$f":"Y317","v":"1-1/2\""},null,null,"B6",null,null,{"$f":"Y318","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":"AR313","v":"1\""},null,null,"D2",null,null,{"$f":"AR314","v":"1\""},null,null,"D3",null,null,{"$f":"AR315","v":"1-1/4\""},null,null,"D4",null,null,{"$f":"AR316","v":"1\""},null,null,"D5",null,null,{"$f":"AR317","v":"1\""},null,null,"D6",null,null,{"$f":"AR318","v":"1\""},null,null,"D7",null,null,null,null,null,"D8"]
[null,"ITEM 1 THROUGH 9 MISC. NOTES"]
[null,"AC3 POWER EXHAUST IS INSTALLED"]
[]
[]
[]
[null,"11.  Record size of gas line going into unit.  NOTE: Pull down menu in cells."]
[null,null,null,"CRITICAL",null,null,null,null,null,null,null,null,null,null,null,null,null,null,"AC1",null,null,"3/4\"",null,null,"AC2",null,null,"3/4\"",null,null,"AC3",null,null,"3/4\"",null,null,"AC4",null,null,"3/4\"",null,null,"AC5",null,null,"1/2\"",null,null,"AC6",null,null,null,null,null,"AC7",null,null,null,null,null,"AC8"]
[null,"12.  Is a smoke detector present in unit?  If NO, enter unit tonnage."]
[null,null,null,"CRITICAL",null,null,null,null,null,null,null,null,null,null,null,null,null,null,"AC1",null,null,"C",null,null,"AC2",null,null,"C",null,null,"AC3",null,null,"C",null,null,"AC4",null,null,"C",null,null,"AC5",null,null,"C",null,null,"AC6",null,null,{"$f":"IF(ISBLANK($E$12),\"N/A\",\"\")","v":"N/A"},null,null,"AC7",null,null,{"$f":"IF(ISBLANK($E$13),\"N/A\",\"\")","v":"N/A"},null,null,"AC8",null,null,{"$f":"IF(ISBLANK($E$14),\"N/A\",\"\")","v":"N/A"}]
[null,"13.  Is the smoke detector inlet sampling tube capped?  If NO, enter unit tonnage."]
[null,null,null,"CRITICAL",null,null,null,null,null,null,null,null,null,null,null,null,null,null,"AC1",null,null,"C",null,null,"AC2",null,null,"C",null,null,"AC3",null,null,"C",null,null,"AC4",null,null,10,null,null,"AC5",null,null,"C",null,null,"AC6",null,null,{"$f":"IF(ISBLANK($E$12),\"N/A\",\"\")","v":"N/A"},null,null,"AC7",null,null,{"$f":"IF(ISBLANK($E$13),\"N/A\",\"\")","v":"N/A"},null,null,"AC8",null,null,{"$f":"IF(ISBLANK($E$14),\"N/A\",\"\")","v":"N/A"}]
[null,"14.  Check smoke detector module light. If light RED or an AMBER color, enter unit tonnage."]
[null,null,null,"CRITICAL",null,null,null,null,null,null,null,null,null,null,null,null,null,null,"AC1",null,null,"C",null,null,"AC2",null,null,"C",null,null,"AC3",null,null,"C",null,null,"AC4",null,null,"C",null,null,"AC5",null,null,"C",null,null,"AC6",null,null,{"$f":"IF(ISBLANK($E$12),\"N/A\",\"\")","v":"N/A"},null,null,"AC7",null,null,{"$f":"IF(ISBLANK($E$13),\"N/A\",\"\")","v":"N/A"},null,null,"AC8",null,null,{"$f":"IF(ISBLANK($E$14),\"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,12.5,null,null,"AC2",null,null,"C",null,null,"AC3",null,null,"C",null,null,"AC4",null,null,"C",null,null,"AC5",null,null,"C",null,null,"AC6",null,null,{"$f":"IF(ISBLANK($E$12),\"N/A\",\"\")","v":"N/A"},null,null,"AC7",null,null,{"$f":"IF(ISBLANK($E$13),\"N/A\",\"\")","v":"N/A"},null,null,"AC8",null,null,{"$f":"IF(ISBLANK($E$14),\"N/A\",\"\")","v":"N/A"}]
[null,"16.  Is hub (hub houses bearings and located at center of pulley) at the tensioner intact?  If NO, enter unit tonnage."]
[null,null,null,"CRITICAL",null,null,null,null,null,null,null,null,null,null,null,null,null,null,"AC1",null,null,{"$f":"IF(ISBLANK($E$7),\"N/A\",IF(LEN($M$7)>15,\"N/A\",IF(VALUE(MID($E$7,3,2))<17,\"N/A\",IF(MID($M$7,7,2)=\"14\",\"N/A\",IF(MID($M$7,7,2)=\"16\",\"N/A\",IF(MID($M$7,4,3)>\"149\",\"N/A\",IF(MID($M$7,4,3)<=\"060\",\"N/A\",\"\")))))))","v":"N/A"},null,null,"AC2",null,null,{"$f":"IF(ISBLANK($E$8),\"N/A\",IF(LEN($M$8)>15,\"N/A\",IF(VALUE(MID($E$7,3,2))<17,\"N/A\",IF(MID($M$8,7,2)=\"14\",\"N/A\",IF(MID($M$8,7,2)=\"16\",\"N/A\",IF(MID($M$8,4,3)>\"149\",\"N/A\",IF(MID($M$8,4,3)<=\"060\",\"N/A\",\"\")))))))","v":"N/A"},null,null,"AC3",null,null,{"$f":"IF(ISBLANK($E$9),\"N/A\",IF(LEN($M$9)>15,\"N/A\",IF(VALUE(MID($E$9,3,2))<17,\"N/A\",IF(MID($M$9,4,3)<=\"060\",\"N/A\",\"\"))))","v":"N/A"},null,null,"AC4",null,null,{"$f":"IF(ISBLANK($E$10),\"N/A\",IF(LEN($M$10)>15,\"N/A\",IF(VALUE(MID($E$10,3,2))<17,\"N/A\",IF(MID($M$10,4,3)<=\"060\",\"N/A\",\"\"))))","v":"N/A"},null,null,"AC5",null,null,{"$f":"IF(ISBLANK($E$11),\"N/A\",IF(LEN($M$11)>15,\"N/A\",IF(VALUE(MID($E$11,3,2))<17,\"N/A\",\"\")))","v":"N/A"},null,null,"AC6",null,null,{"$f":"IF(ISBLANK($E$12),\"N/A\",IF(VALUE(MID($E$12,3,2))<17,\"N/A\",\"\"))","v":"N/A"},null,null,"AC7",null,null,{"$f":"IF(ISBLANK($E$13),\"N/A\",IF(VALUE(MID($E$13,3,2))<17,\"N/A\",\"\"))","v":"N/A"},null,null,"AC8",null,null,{"$f":"IF(ISBLANK($E$14),\"N/A\",IF(VALUE(MID($E$14,3,2))<17,\"N/A\",\"\"))","v":"N/A"}]
[null,"17. Is belt tensioner installed?  If NO, enter unit tonnage."]
[null,null,null,"CRITICAL",null,null,null,null,null,null,null,null,null,null,null,null,null,null,"AC1",null,null,{"$f":"IF(ISBLANK($E$7),\"N/A\",IF(LEN($M$7)>15,\"N/A\",IF(VALUE(MID($E$7,3,2))<17,\"N/A\",IF(MID($M$7,7,2)=\"14\",\"N/A\",IF(MID($M$7,7,2)=\"16\",\"N/A\",IF(MID($M$7,4,3)>\"149\",\"N/A\",IF(MID($M$7,4,3)<=\"060\",\"N/A\",\"\")))))))","v":"N/A"},null,null,"AC2",null,null,{"$f":"IF(ISBLANK($E$8),\"N/A\",IF(LEN($M$8)>15,\"N/A\",IF(VALUE(MID($E$7,3,2))<17,\"N/A\",IF(MID($M$8,7,2)=\"14\",\"N/A\",IF(MID($M$8,7,2)=\"16\",\"N/A\",IF(MID($M$8,4,3)>\"149\",\"N/A\",IF(MID($M$8,4,3)<=\"060\",\"N/A\",\"\")))))))","v":"N/A"},null,null,"AC3",null,null,{"$f":"IF(ISBLANK($E$9),\"N/A\",IF(LEN($M$9)>15,\"N/A\",IF(VALUE(MID($E$9,3,2))<17,\"N/A\",IF(MID($M$9,4,3)<=\"060\",\"N/A\",\"\"))))","v":"N/A"},null,null,"AC4",null,null,{"$f":"IF(ISBLANK($E$10),\"N/A\",IF(LEN($M$10)>15,\"N/A\",IF(VALUE(MID($E$10,3,2))<17,\"N/A\",IF(MID($M$10,4,3)<=\"060\",\"N/A\",\"\"))))","v":"N/A"},null,null,"AC5",null,null,{"$f":"IF(ISBLANK($E$11),\"N/A\",IF(LEN($M$11)>15,\"N/A\",IF(VALUE(MID($E$11,3,2))<17,\"N/A\",\"\")))","v":"N/A"},null,null,"AC6",null,null,{"$f":"IF(ISBLANK($E$12),\"N/A\",IF(VALUE(MID($E$12,3,2))<17,\"N/A\",\"\"))","v":"N/A"},null,null,"AC7",null,null,{"$f":"IF(ISBLANK($E$13),\"N/A\",IF(VALUE(MID($E$13,3,2))<17,\"N/A\",\"\"))","v":"N/A"},null,null,"AC8",null,null,{"$f":"IF(ISBLANK($E$14),\"N/A\",IF(VALUE(MID($E$14,3,2))<17,\"N/A\",\"\"))","v":"N/A"}]
[null,"ITEM 9 THROUGH 16 MISC. NOTES"]
[]
[]
[]
[]
[]
[null,"18. Look for damage/indentions at pulleys?  If damage found, enter unit tonnage."]
[null,null,null,"CRITICAL",null,null,null,null,null,null,null,null,null,null,null,null,null,null,"AC1",null,null,"C",null,null,"AC2",null,null,"C",null,null,"AC3",null,null,"C",null,null,"AC4",null,null,"C",null,null,"AC5",null,null,"C",null,null,"AC6",null,null,{"$f":"IF(ISBLANK($E$12),\"N/A\",\"\")","v":"N/A"},null,null,"AC7",null,null,{"$f":"IF(ISBLANK($E$13),\"N/A\",\"\")","v":"N/A"},null,null,"AC8",null,null,{"$f":"IF(ISBLANK($E$14),\"N/A\",\"\")","v":"N/A"}]
[null,"20. Check motor sheave to assure it can be adjusted.  If cannot be adJusted, enter unit tonnage, & part #'S in misc notes."]
[null,null,null,"CRITICAL",null,null,null,null,null,null,null,null,null,null,null,null,null,null,"AC1",null,null,{"$f":"IF(ISBLANK($E$7),\"N/A\",IF(LEN($M$7)>15,\"N/A\",IF(MID($M$7,7,2)=\"14\",\"N/A\",IF(MID($M$7,7,2)=\"16\",\"N/A\",IF(MID($M$7,4,3)>\"149\",\"N/A\",IF(MID($M$7,4,3)<=\"060\",\"N/A\",\"\"))))))","v":"N/A"},null,null,"AC2",null,null,"C",null,null,"AC3",null,null,"C",null,null,"AC4",null,null,"C",null,null,"AC5",null,null,"C",null,null,"AC6",null,null,{"$f":"IF(ISBLANK($E$12),\"N/A\",\"\")","v":"N/A"},null,null,"AC7",null,null,{"$f":"IF(ISBLANK($E$13),\"N/A\",\"\")","v":"N/A"},null,null,"AC8",null,null,{"$f":"IF(ISBLANK($E$14),\"N/A\",\"\")","v":"N/A"}]
[null,"21. Record belt size."]
[null,null,null,"N/A",null,null,null,null,null,null,null,null,null,null,null,null,null,null,"AC1",null,null,{"$f":"IF(ISBLANK($E$7),\"N/A\",IF(LEN($M$7)>15,\"N/A\",IF(MID($M$7,7,2)=\"14\",\"N/A\",IF(MID($M$7,7,2)=\"16\",\"N/A\",IF(MID($M$7,4,3)>\"149\",\"N/A\",IF(MID($M$7,4,3)<=\"060\",\"N/A\",\"\"))))))","v":"N/A"},null,null,"AC2",null,null,"L456",null,null,"AC3",null,null,"AX54",null,null,"AC4",null,null,"BX56",null,null,"AC5",null,null,"AX53",null,null,"AC6",null,null,{"$f":"IF(ISBLANK($E$12),\"N/A\",\"\")","v":"N/A"},null,null,"AC7",null,null,{"$f":"IF(ISBLANK($E$13),\"N/A\",\"\")","v":"N/A"},null,null,"AC8",null,null,{"$f":"IF(ISBLANK($E$14),\"N/A\",\"\")","v":"N/A"}]
[null,"22.  Identify any damage to the blower.  If DAMAGE found, enter unit tonnage."]
[null,null,null,"CRITICAL",null,null,null,null,null,null,null,null,null,null,null,null,null,null,"AC1",null,null,{"$f":"IF(ISBLANK($E$7),\"N/A\",IF(MID($M$7,7,2)=\"14\",\"N/A\",IF(MID($M$7,7,2)=\"16\",\"N/A\",IF(MID($M$7,7,2)<\"14\",\"\",IF(MID($M$7,4,3)>\"149\",\"N/A\",\"\")))))","v":"N/A"},null,null,"AC2",null,null,"C",null,null,"AC3",null,null,"C",null,null,"AC4",null,null,"C",null,null,"AC5",null,null,"C",null,null,"AC6",null,null,{"$f":"IF(ISBLANK($E$12),\"N/A\",\"\")","v":"N/A"},null,null,"AC7",null,null,{"$f":"IF(ISBLANK($E$13),\"N/A\",\"\")","v":"N/A"},null,null,"AC8",null,null,{"$f":"IF(ISBLANK($E$14),\"N/A\",\"\")","v":"N/A"}]
[null,"23.  Quantify cleanliness of blower.  If dirty, enter unit tonnage."]
[null,null,null,"NON CRITICAL",null,null,null,null,null,null,null,null,null,null,null,null,null,null,"AC1",null,null,{"$f":"IF(ISBLANK($E$7),\"N/A\",IF(MID($M$7,7,2)=\"14\",\"N/A\",IF(MID($M$7,7,2)=\"16\",\"N/A\",IF(MID($M$7,4,3)>\"149\",\"N/A\",\"\"))))","v":"N/A"},null,null,"AC2",null,null,"C",null,null,"AC3",null,null,"C",null,null,"AC4",null,null,"C",null,null,"AC5",null,null,"C",null,null,"AC6",null,null,{"$f":"IF(ISBLANK($E$12),\"N/A\",\"\")","v":"N/A"},null,null,"AC7",null,null,{"$f":"IF(ISBLANK($E$13),\"N/A\",\"\")","v":"N/A"},null,null,"AC8",null,null,{"$f":"IF(ISBLANK($E$14),\"N/A\",\"\")","v":"N/A"}]
[null,"24.  At blower motor start up is there a concernng amount of noise or vibration?  If so, enter unit tonnage."]
[null,null,null,"CRITICAL",null,null,null,null,null,null,null,null,null,null,null,null,null,null,"AC1",null,null,{"$f":"IF(ISBLANK($E$7),\"N/A\",IF(MID($M$7,7,2)=\"14\",\"N/A\",IF(MID($M$7,7,2)=\"16\",\"N/A\",IF(MID($M$7,4,3)>\"149\",\"N/A\",\"\"))))","v":"N/A"},null,null,"AC2",null,null,"C",null,null,"AC3",null,null,"C",null,null,"AC4",null,null,10,null,null,"AC5",null,null,"C",null,null,"AC6",null,null,{"$f":"IF(ISBLANK($E$12),\"N/A\",\"\")","v":"N/A"},null,null,"AC7",null,null,{"$f":"IF(ISBLANK($E$13),\"N/A\",\"\")","v":"N/A"},null,null,"AC8",null,null,{"$f":"IF(ISBLANK($E$14),\"N/A\",\"\")","v":"N/A"}]
[null,"25.  Is blank plate secured on B-cabinets?  If NO, enter unit tonnage."]
[null,null,null,"REVIEW & RECTIFY",null,null,null,null,null,null,null,null,null,null,null,null,null,null,"AC1",null,null,{"$f":"IF(ISBLANK($E$7),\"N/A\",IF(LEN($M$7)>15,\"N/A\",IF(MID($M$7,4,3)<=\"072\",\"N/A\",IF(MID($M$7,4,3)>=\"180\",\"N/A\",IF(MID($M$7,7,2)=\"14\",\"N/A\",IF(MID($M$7,7,2)=\"16\",\"N/A\",IF(MID($M$7,4,3)>\"149\",\"N/A\",\"\")))))))","v":"N/A"},null,null,"AC2",null,null,"C",null,null,"AC3",null,null,"C",null,null,"AC4",null,null,10,null,null,"AC5",null,null,{"$f":"IF(ISBLANK($E$11),\"N/A\",IF(LEN($M$11)>15,\"N/A\",IF(MID($M$11,4,3)<=\"072\",\"N/A\",IF(MID($M$11,4,3)>\"150\",\"N/A\",\"\"))))","v":"N/A"},null,null,"AC6",null,null,{"$f":"IF(ISBLANK($E$12),\"N/A\",IF(MID($M$12,4,3)<=\"072\",\"N/A\",IF(MID($M$12,4,3)>\"150\",\"N/A\",\"\")))","v":"N/A"},null,null,"AC7",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,"AC8",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,"26.  Is ductwork lined?  If  YES, enter unit tonnage."]
[null,null,null,"REVIEW & RECTIFY",null,null,null,null,null,null,null,null,null,null,null,null,null,null,"AC1",null,null,{"$f":"IF(ISBLANK($E$7),\"N/A\",IF(MID($M$7,7,2)=\"14\",\"N/A\",IF(MID($M$7,7,2)=\"16\",\"N/A\",IF(MID($M$7,4,3)>\"149\",\"N/A\",\"\"))))","v":"N/A"},null,null,"AC2",null,null,"C",null,null,"AC3",null,null,"C",null,null,"AC4",null,null,"C",null,null,"AC5",null,null,"C",null,null,"AC6",null,null,{"$f":"IF(ISBLANK($E$12),\"N/A\",\"\")","v":"N/A"},null,null,"AC7",null,null,{"$f":"IF(ISBLANK($E$13),\"N/A\",\"\")","v":"N/A"},null,null,"AC8",null,null,{"$f":"IF(ISBLANK($E$14),\"N/A\",\"\")","v":"N/A"}]
[null,"ITEM 17 THROUGH 23 MISC. NOTES"]
[]
[]
[]
[]
[]
[null,"27. Are turning vanes present in the supply ducts of the units?  IF NO, insert unit tonnage."]
[null,null,null,"REVIEW & RECTIFY",null,null,null,null,null,null,null,null,null,null,null,null,null,null,"AC1",null,null,{"$f":"IF(ISBLANK($E$7),\"N/A\",IF(MID($M$7,7,2)=\"14\",\"N/A\",IF(MID($M$7,7,2)=\"16\",\"N/A\",IF(MID($M$7,4,3)>\"149\",\"N/A\",\"\"))))","v":"N/A"},null,null,"AC2",null,null,"C",null,null,"AC3",null,null,"C",null,null,"AC4",null,null,"C",null,null,"AC5",null,null,"C",null,null,"AC6",null,null,{"$f":"IF(ISBLANK($E$12),\"N/A\",\"\")","v":"N/A"},null,null,"AC7",null,null,{"$f":"IF(ISBLANK($E$13),\"N/A\",\"\")","v":"N/A"},null,null,"AC8",null,null,{"$f":"IF(ISBLANK($E$14),\"N/A\",\"\")","v":"N/A"}]
[null,"28. Are turning vanes single or double thickness?  If DOUBLE, enter unit tonnage."]
[null,null,null,"REVIEW & RECTIFY",null,null,null,null,null,null,null,null,null,null,null,null,null,null,"AC1",null,null,{"$f":"IF(ISBLANK($E$7),\"N/A\",IF(MID($M$7,7,2)=\"14\",\"N/A\",IF(MID($M$7,7,2)=\"16\",\"N/A\",IF(MID($M$7,4,3)>\"149\",\"N/A\",\"\"))))","v":"N/A"},null,null,"AC2",null,null,"C",null,null,"AC3",null,null,"C",null,null,"AC4",null,null,"C",null,null,"AC5",null,null,"C",null,null,"AC6",null,null,{"$f":"IF(ISBLANK($E$12),\"N/A\",\"\")","v":"N/A"},null,null,"AC7",null,null,{"$f":"IF(ISBLANK($E$13),\"N/A\",\"\")","v":"N/A"},null,null,"AC8",null,null,{"$f":"IF(ISBLANK($E$14),\"N/A\",\"\")","v":"N/A"}]
[null,"29. Is duct work seated and aligned?  If NO, enter unit tonnage."]
[null,null,null,"N/A",null,null,null,null,null,null,null,null,null,null,null,null,null,null,"AC1",null,null,{"$f":"IF(ISBLANK($E$7),\"N/A\",IF(MID($M$7,7,2)=\"14\",\"N/A\",IF(MID($M$7,7,2)=\"16\",\"N/A\",IF(MID($M$7,4,3)>\"149\",\"N/A\",\"\"))))","v":"N/A"},null,null,"AC2",null,null,"C",null,null,"AC3",null,null,"C",null,null,"AC4",null,null,"C",null,null,"AC5",null,null,"C",null,null,"AC6",null,null,{"$f":"IF(ISBLANK($E$12),\"N/A\",\"\")","v":"N/A"},null,null,"AC7",null,null,{"$f":"IF(ISBLANK($E$13),\"N/A\",\"\")","v":"N/A"},null,null,"AC8",null,null,{"$f":"IF(ISBLANK($E$14),\"N/A\",\"\")","v":"N/A"}]
[null,"30. Is canvas connector present?  If NO, enter unit tonnage."]
[null,null,null,"REVIEW & RECTIFY",null,null,null,null,null,null,null,null,null,null,null,null,null,null,"AC1",null,null,{"$f":"IF(ISBLANK($E$7),\"N/A\",IF(MID($M$7,7,2)=\"14\",\"N/A\",IF(MID($M$7,7,2)=\"16\",\"N/A\",IF(MID($M$7,4,3)>\"149\",\"N/A\",\"\"))))","v":"N/A"},null,null,"AC2",null,null,"C",null,null,"AC3",null,null,"C",null,null,"AC4",null,null,"C",null,null,"AC5",null,null,"C",null,null,"AC6",null,null,{"$f":"IF(ISBLANK($E$12),\"N/A\",\"\")","v":"N/A"},null,null,"AC7",null,null,{"$f":"IF(ISBLANK($E$13),\"N/A\",\"\")","v":"N/A"},null,null,"AC8",null,null,{"$f":"IF(ISBLANK($E$14),\"N/A\",\"\")","v":"N/A"}]
[null,"31.  Quantify cleanliness of duct.  If dirty, enter unit tonnage."]
[null,null,null,"NON CRITICAL",null,null,null,null,null,null,null,null,null,null,null,null,null,null,"AC1",null,null,{"$f":"IF(ISBLANK($E$7),\"N/A\",IF(MID($M$7,7,2)=\"14\",\"N/A\",IF(MID($M$7,7,2)=\"16\",\"N/A\",IF(MID($M$7,4,3)>\"149\",\"N/A\",\"\"))))","v":"N/A"},null,null,"AC2",null,null,"C",null,null,"AC3",null,null,"C",null,null,"AC4",null,null,"C",null,null,"AC5",null,null,"C",null,null,"AC6",null,null,{"$f":"IF(ISBLANK($E$12),\"N/A\",\"\")","v":"N/A"},null,null,"AC7",null,null,{"$f":"IF(ISBLANK($E$13),\"N/A\",\"\")","v":"N/A"},null,null,"AC8",null,null,{"$f":"IF(ISBLANK($E$14),\"N/A\",\"\")","v":"N/A"}]
[null,"32.  If turning vanes not present, is drop radiused?  If so, does radius equal the width of the duct? If not, enter tonnage."]
[null,null,null,"REVIEW & RECTIFY",null,null,null,null,null,null,null,null,null,null,null,null,null,null,"AC1",null,null,{"$f":"IF(ISBLANK($E$7),\"N/A\",IF(MID($M$7,7,2)=\"14\",\"N/A\",IF(MID($M$7,7,2)=\"16\",\"N/A\",IF(MID($M$7,4,3)>\"149\",\"N/A\",\"\"))))","v":"N/A"},null,null,"AC2",null,null,"N/A",null,null,"AC3",null,null,"N/A",null,null,"AC4",null,null,"N/A",null,null,"AC5",null,null,"N/A",null,null,"AC6",null,null,{"$f":"IF(ISBLANK($E$12),\"N/A\",\"\")","v":"N/A"},null,null,"AC7",null,null,{"$f":"IF(ISBLANK($E$13),\"N/A\",\"\")","v":"N/A"},null,null,"AC8",null,null,{"$f":"IF(ISBLANK($E$14),\"N/A\",\"\")","v":"N/A"}]
[null,"33.  Do units have prodigy boards?  If no, enter unit tonnage (identify only if the AC unit is an Energence unit)."]
[null,null,null,"REVIEW & RECTIFY",null,null,null,null,null,null,null,null,null,null,null,null,null,null,"AC1",null,null,{"$f":"IF(ISBLANK($E$7),\"N/A\",IF(LEN($M$7)>15,\"N/A\",IF(VALUE(MID($E$7,3,2))<10,\"N/A\",IF(MID($M$7,7,2)=\"14\",\"N/A\",IF(MID($M$7,7,2)=\"16\",\"N/A\",IF(MID($M$7,4,3)>\"149\",\"N/A\",\"\"))))))","v":"N/A"},null,null,"AC2",null,null,"C",null,null,"AC3",null,null,"C",null,null,"AC4",null,null,"C",null,null,"AC5",null,null,"C",null,null,"AC6",null,null,{"$f":"IF(ISBLANK($E$12),\"N/A\",IF(VALUE(MID($E$12,3,2))<10,\"N/A\",\"\"))","v":"N/A"},null,null,"AC7",null,null,{"$f":"IF(ISBLANK($E$13),\"N/A\",IF(VALUE(MID($E$13,3,2))<10,\"N/A\",\"\"))","v":"N/A"},null,null,"AC8",null,null,{"$f":"IF(ISBLANK($E$14),\"N/A\",IF(VALUE(MID($E$14,3,2))<10,\"N/A\",\"\"))","v":"N/A"}]
[null,"ITEM 24 THROUGH 30 MISC. NOTES"]
[]
[]
[]
[]
[]
[null,"34.  Identify prodigy boards New or Old.  Answer New Green, N or Old Red, R."]
[null,null,null,"REVIEW & RECTIFY",null,null,null,null,null,null,null,null,null,null,null,null,null,null,"AC1",null,null,{"$f":"IF(ISBLANK($E$7),\"N/A\",IF(LEN($M$7)>15,\"N/A\",IF(VALUE(MID($E$7,3,2))<10,\"N/A\",IF(MID($M$7,7,2)=\"14\",\"N/A\",IF(MID($M$7,7,2)=\"16\",\"N/A\",IF(MID($M$7,4,3)>\"149\",\"N/A\",\"\"))))))","v":"N/A"},null,null,"AC2",null,null,"N",null,null,"AC3",null,null,"N",null,null,"AC4",null,null,"N",null,null,"AC5",null,null,"N",null,null,"AC6",null,null,{"$f":"IF(ISBLANK($E$12),\"N/A\",IF(VALUE(MID($E$12,3,2))<10,\"N/A\",\"\"))","v":"N/A"},null,null,"AC7",null,null,{"$f":"IF(ISBLANK($E$13),\"N/A\",IF(VALUE(MID($E$13,3,2))<10,\"N/A\",\"\"))","v":"N/A"},null,null,"AC8",null,null,{"$f":"IF(ISBLANK($E$14),\"N/A\",IF(VALUE(MID($E$14,3,2))<10,\"N/A\",\"\"))","v":"N/A"}]
[null,"35.  If economizer actuator open, turn unit off to assure it closes.  If does not CLOSE enter unit tonnage."]
[null,null,null,"CRITICAL",null,null,null,null,null,null,null,null,null,null,null,null,null,null,"AC1",null,null,{"$f":"IF(ISBLANK($E$7),\"N/A\",IF(MID($M$7,7,2)=\"14\",\"N/A\",IF(MID($M$7,7,2)=\"16\",\"N/A\",IF(MID($M$7,4,3)>\"149\",\"N/A\",\"\"))))","v":"N/A"},null,null,"AC2",null,null,"C",null,null,"AC3",null,null,"C",null,null,"AC4",null,null,"C",null,null,"AC5",null,null,"C",null,null,"AC6",null,null,{"$f":"IF(ISBLANK($E$12),\"N/A\",\"\")","v":"N/A"},null,null,"AC7",null,null,{"$f":"IF(ISBLANK($E$13),\"N/A\",\"\")","v":"N/A"},null,null,"AC8",null,null,{"$f":"IF(ISBLANK($E$14),\"N/A\",\"\")","v":"N/A"}]
[null,"36.  Are actuator gears worn?  If yes, enter unit tonnage."]
[null,null,null,"CRITICAL",null,null,null,null,null,null,null,null,null,null,null,null,null,null,"AC1",null,null,{"$f":"IF(ISBLANK($E$7),\"N/A\",IF(MID($M$7,7,2)=\"14\",\"N/A\",IF(MID($M$7,7,2)=\"16\",\"N/A\",IF(MID($M$7,4,3)>\"149\",\"N/A\",\"\"))))","v":"N/A"},null,null,"AC2",null,null,8.5,null,null,"AC3",null,null,7.5,null,null,"AC4",null,null,10,null,null,"AC5",null,null,6,null,null,"AC6",null,null,{"$f":"IF(ISBLANK($E$12),\"N/A\",\"\")","v":"N/A"},null,null,"AC7",null,null,{"$f":"IF(ISBLANK($E$13),\"N/A\",\"\")","v":"N/A"},null,null,"AC8",null,null,{"$f":"IF(ISBLANK($E$14),\"N/A\",\"\")","v":"N/A"}]
[null,"37.  Verify outdoor damper position  can be adjusted.  If cannot be adjusted enter unit tonnage."]
[null,null,null,"CRITICAL",null,null,null,null,null,null,null,null,null,null,null,null,null,null,"AC1",null,null,{"$f":"IF(ISBLANK($E$7),\"N/A\",IF(MID($M$7,7,2)=\"14\",\"N/A\",IF(MID($M$7,7,2)=\"16\",\"N/A\",IF(MID($M$7,4,3)>\"149\",\"N/A\",\"\"))))","v":"N/A"},null,null,"AC2",null,null,"C",null,null,"AC3",null,null,"C",null,null,"AC4",null,null,"C",null,null,"AC5",null,null,"C",null,null,"AC6",null,null,{"$f":"IF(ISBLANK($E$12),\"N/A\",\"\")","v":"N/A"},null,null,"AC7",null,null,{"$f":"IF(ISBLANK($E$13),\"N/A\",\"\")","v":"N/A"},null,null,"AC8",null,null,{"$f":"IF(ISBLANK($E$14),\"N/A\",\"\")","v":"N/A"}]
[null,"38.  Is there any play in the actuator gear box?   If yes, enter unit tonnage"]
[null,null,null,"CRITICAL",null,null,null,null,null,null,null,null,null,null,null,null,null,null,"AC1",null,null,{"$f":"IF(ISBLANK($E$7),\"N/A\",IF(MID($M$7,7,2)=\"14\",\"N/A\",IF(MID($M$7,7,2)=\"16\",\"N/A\",IF(MID($M$7,4,3)>\"149\",\"N/A\",\"\"))))","v":"N/A"},null,null,"AC2",null,null,"C",null,null,"AC3",null,null,"C",null,null,"AC4",null,null,"C",null,null,"AC5",null,null,"C",null,null,"AC6",null,null,{"$f":"IF(ISBLANK($E$12),\"N/A\",\"\")","v":"N/A"},null,null,"AC7",null,null,{"$f":"IF(ISBLANK($E$13),\"N/A\",\"\")","v":"N/A"},null,null,"AC8",null,null,{"$f":"IF(ISBLANK($E$14),\"N/A\",\"\")","v":"N/A"}]
[null,"39.  Check economizer setting at prodigy board.  If economizer set to zero, enter unit tonnage and re-set prodigy board to twenty percent."]
[null,null,null,"CRITICAL",null,null,null,null,null,null,null,null,null,null,null,null,null,null,"AC1",null,null,"C",null,null,"AC2",null,null,"C",null,null,"AC3",null,null,"C",null,null,"AC4",null,null,"C",null,null,"AC5",null,null,"C",null,null,"AC6",null,null,{"$f":"IF(ISBLANK($E$12),\"N/A\",\"\")","v":"N/A"},null,null,"AC7",null,null,{"$f":"IF(ISBLANK($E$13),\"N/A\",\"\")","v":"N/A"},null,null,"AC8",null,null,{"$f":"IF(ISBLANK($E$14),\"N/A\",\"\")","v":"N/A"}]
[null,"40.  Do filters meet CFA spec (2\" pleated polyester/cotton with MERV rating of 7).  If no, enter unit tonnage."]
[null,null,null,"NON CRITICAL",null,null,null,null,null,null,null,null,null,null,null,null,null,null,"AC1",null,null,"C",null,null,"AC2",null,null,"C",null,null,"AC3",null,null,"C",null,null,"AC4",null,null,"C",null,null,"AC5",null,null,"C",null,null,"AC6",null,null,{"$f":"IF(ISBLANK($E$12),\"N/A\",\"\")","v":"N/A"},null,null,"AC7",null,null,{"$f":"IF(ISBLANK($E$13),\"N/A\",\"\")","v":"N/A"},null,null,"AC8",null,null,{"$f":"IF(ISBLANK($E$14),\"N/A\",\"\")","v":"N/A"}]
[null,"ITEM 31 THROUGH 35 MISC. NOTES"]
[]
[]
[]
[null,"41.  Provide condensation pipe size.  Minimum 1\" at playland unit, and 1.25\" at all other units."]
[null,null,null,"REVIEW & RECTIFY",null,null,null,null,null,null,null,null,null,null,null,null,null,null,"AC1",null,null,1,null,null,"AC2",null,null,1,null,null,"AC3",null,null,1,null,null,"AC4",null,null,1,null,null,"AC5",null,null,1,null,null,"AC6",null,null,{"$f":"IF(ISBLANK($E$12),\"N/A\",\"\")","v":"N/A"},null,null,"AC7",null,null,{"$f":"IF(ISBLANK($E$13),\"N/A\",\"\")","v":"N/A"},null,null,"AC8",null,null,{"$f":"IF(ISBLANK($E$14),\"N/A\",\"\")","v":"N/A"}]
[null,"42.  Do condensation traps meet provided detail.  If NO, enter unit tonnage."]
[null,null,null,"REVIEW & RECTIFY",null,null,null,null,null,null,null,null,null,null,null,null,null,null,"AC1",null,null,12.5,null,null,"AC2",null,null,8.5,null,null,"AC3",null,null,7.5,null,null,"AC4",null,null,10,null,null,"AC5",null,null,6,null,null,"AC6",null,null,{"$f":"IF(ISBLANK($E$12),\"N/A\",\"\")","v":"N/A"},null,null,"AC7",null,null,{"$f":"IF(ISBLANK($E$13),\"N/A\",\"\")","v":"N/A"},null,null,"AC8",null,null,{"$f":"IF(ISBLANK($E$14),\"N/A\",\"\")","v":"N/A"}]
[null,"43.  Do pre-filters need to be cleaned?  If YES, enter unit tonnage."]
[null,null,null,"REVIEW & RECTIFY",null,null,null,null,null,null,null,null,null,null,null,null,null,null,"AC1",null,null,"C",null,null,"AC2",null,null,"C",null,null,"AC3",null,null,"C",null,null,"AC4",null,null,"C",null,null,"AC5",null,null,"C",null,null,"AC6",null,null,{"$f":"IF(ISBLANK($E$12),\"N/A\",\"\")","v":"N/A"},null,null,"AC7",null,null,{"$f":"IF(ISBLANK($E$13),\"N/A\",\"\")","v":"N/A"},null,null,"AC8",null,null,{"$f":"IF(ISBLANK($E$14),\"N/A\",\"\")","v":"N/A"}]
[null,"44.  Do pre-filters need to be replaced?  If YES, enter unit tonnage."]
[null,null,null,"REVIEW & RECTIFY",null,null,null,null,null,null,null,null,null,null,null,null,null,null,"AC1",null,null,"C",null,null,"AC2",null,null,"C",null,null,"AC3",null,null,"C",null,null,"AC4",null,null,"C",null,null,"AC5",null,null,"C",null,null,"AC6",null,null,{"$f":"IF(ISBLANK($E$12),\"N/A\",\"\")","v":"N/A"},null,null,"AC7",null,null,{"$f":"IF(ISBLANK($E$13),\"N/A\",\"\")","v":"N/A"},null,null,"AC8",null,null,{"$f":"IF(ISBLANK($E$14),\"N/A\",\"\")","v":"N/A"}]
[null,"45.  Check Sun Coast panel terminal block for SINGLE PAIR TWISTED WITH FOIL SHIELD AND DRAIN WIRE.   If single pair twisted with foil shield NOT present enter unit tonnage.  See photo in insert twelve below."]
[null," ",null,"CRITICAL",null,null,null,null,null,null,null,null,null,null,null,null,null,null,"AC1",null,null,12.5,null,null,"AC2",null,null,8.5,null,null,"AC3",null,null,7.5,null,null,"AC4",null,null,10,null,null,"AC5",null,null,6,null,null,"AC6",null,null,{"$f":"IF(ISBLANK($E$12),\"N/A\",\"\")","v":"N/A"},null,null,"AC7",null,null,{"$f":"IF(ISBLANK($E$13),\"N/A\",\"\")","v":"N/A"},null,null,"AC8",null,null,{"$f":"IF(ISBLANK($E$14),\"N/A\",\"\")","v":"N/A"}]
[null,"ITEM 36 THROUGH 39 MISC. NOTES"]
[]
[]
[null,"AC1, AC2, AC3, AC4, AC5 DO NOT HAVE THE CORRECT TEMP. SENSOR WIRING INSTALLED "]
[]
[]
[null,"46.  Is bathroom exhaust fan running?  Enter YES or NO.",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"YES"]
[null,"47.  Is bathroom exhaust fan making excessive noise? Enter Yes or NO.",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"NO"]
[null,"48.  Is bathroom exhaust fan vibrating excessively? Enter YES or NO.",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"NO"]
[null,"49.  Does bathroom exhaust fan have a back draft damper?  Enter YES or NO.",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"NO"]
[null,"50.  Does bathroom exhaust fan duct have a liner? Enter YES OR NO.",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"NO"]
[null,"51.  Visually inspect ductwork at bathroom exhaust fan, and rate cleanliness. Enter CLEAN OR DIRTY.",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"DIRTY "]
[null,"52.  Record model and serial number of Suncoast Panel.",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Model #",null,null,null,null,"CHICK-FIL-A",null,null,null,null,null,null,null,null,null,null,null,null,null,"Serial #",null,null,null,null,"04-CFA-045"]
[null,"53.  Is there a HES control panel visible?  ",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Yes",null,null,null,null,null,null,"No",null,null,null,"NO"]
[null,"54.  Are thermostats Robert Shaw (Gray Display) or Network (Blue Display) ?  Enter \"RS\", \"NW\" for Robert Shaw and Network respectively.  If thermostat not Robert Shaw or Network, enter NO.",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"AC1 -",null,null,"RS",null,null,"AC2 -",null,null,"RS",null,null,"AC3 -",null,null,"RS",null,null,"AC4 -",null,null,"RS",null,null,"AC5 -",null,null,"RS"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,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,"N/A",null,null,"AC7 -",null,null,"N/A",null,null,"AC8 -",null,null,"N/A"]
[]
[null,"MISCELLANEOUS NOTES"]
[]
[]
[]
[null,"D3 ADDITIONAL PIPE LENGTH: 4FT. 2'' / PIPE DIAMETER: 1.0'' / PIPE DROP: LENGTH: 3FT. 5'' DIAMETER: 0.75''"]
[null,"D4 ADDITIONAL PIPE LENGTH: 4FT. 5'' / PIPE DIAMETER: 0.75'' "]
[null,"D5 ADDITIONAL PIPE LENGTH: 4FT. 5'' / PIPE DIAMETER: 0.75'' "]
[null,"D6  ADDITIONAL PIPE LENGTH: 6FT. / PIPE DIAMETER: 0.75'' / PIPE DROP: LENGTH: 3'' / DIAMETER: 0.50''"]
[null,"GAS LINES ROUTED TO DRIVE THROUGH CANOPIES ARE SHOWN ON DIAGRAM IN RED & BLUE LINES. "]
[null,"RED & BLUE GAS LINES RAN OVER PARAPET WALLS NOT THROUGH THE WALL. "]
[null,"RED LINE: ADDITIONAL GAS PIPE LENTH: 20FT. 7'' / PIPE DIAMETER: 1.0'' "]
[null,"BLUE LINE: ADDITIONAL GAS PIPE LENTH: 52FT. 5'' / PIPE DIAMETER: 1.25'' "]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[null,"ROOFTOP ONE ",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"ROOFTOP TWO "]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[null,"AC5 CURB ADAPTOR ",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"AC4 BELT IS DAMAGED "]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[null,"AC4 BLANK PLATE 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,"AC4 TUBE NOT CAPPED "]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[null,"AC2/AC3/AC4/AC5 ACTUATOR GEARS ARE WORN ",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"RR BACKDRAFT DAMPER IS NOT INSTALLED "]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[null,"AC1/AC2/AC3/AC4/AC5 / UNIONS ARE NOT ON BOTH SIDES ",null,null,null,null,null,null,null,null,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 DUST PLUGS ARE INSTALLED "]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[null,"AC1/AC2/AC3/AC4/AC5 THE WRONG TEMP. SENSOR WIRING",null,null,null,null,null,null,null,null,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"]
[]
[]
[]
[null,"LONGEST RUN ___ ' - 2018 INTERNATIONAL FUEL GAS CODE - BRANCH LENGTH METHOD - TOTAL BTU'S _____"]
[]
[null,null,"DESCRIPTION",null,null,null,null,null,null,null,null,null,null,null,"BRANCH LINES",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"DROP LINE",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,"GAS LINE",null,null,null,null,null,null,"DEVICE",null,null,null,null,"LENGTH",null,null,null,null,"DESIGN",null,null,null,null,"AS-BUILT",null,null,null,null,"CALC",null,null,null,"LENGTH",null,null,null,null,"DESIGN",null,null,null,null,"AS-BUILT",null,null,null,null,null,"CALC"]
[null,null,null,null,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,"(ft)",null,null,null,null,"(in)",null,null,null,null,"(in)",null,null,null,null,null,"(in)",null,null,null,null,"1/2\"",null,null,null,"7/8\""]
[null,null," Meter to B1/D1",null,null,null,null,null,null,"RTU 1",null,null,null,null,"16FT. 2''",null,null,null,null,null,null,null,null,null,"2\"",null,null,null,null,"2''",null,null,null,"8FT. 7''",null,null,null,null,"1-1/4\"",null,null,null,null,"1\"",null,null,null,null,null,"1.0''",null,null,null,null,"3/4\"",null,null,null,"1\""]
[null,null,"B1 to B2/D2",null,null,null,null,null,null,"WH",null,null,null,null,"7FT 3''",null,null,null,null,null,null,null,null,null,"2\"",null,null,null,null,"1''",null,null,null,"17FT. 8''",null,null,null,null,"1\"",null,null,null,null,"1\"",null,null,null,null,null,"1.0''",null,null,null,null,"1\"",null,null,null,"1-5/16\""]
[null,null,"B2 to B3/D3",null,null,null,null,null,null,"RTU 2",null,null,null,null,"18FT. 4''",null,null,null,null,null,null,null,null,null,"2\"",null,null,null,null,"1.5''",null,null,null,"15''",null,null,null,null,"1-1/4\"",null,null,null,null,"1-1/4\"",null,null,null,null,null,"1.0''",null,null,null,null,"1-1/4\"",null,null,null,"1-5/8\""]
[null,null,"B3 to B4/D4",null,null,null,null,null,null,"RTU 3",null,null,null,null,"25FT. 11''",null,null,null,null,null,null,null,null,null,"1-1/2\"",null,null,null,null,"5''",null,null,null,"16FT. ",null,null,null,null,"1-1/4\"",null,null,null,null,"1\"",null,null,null,null,null,"1.0''",null,null,null,null,"1-1/2\"",null,null,null,"1-7/8\""]
[null,null,"B4 to B5/D5",null,null,null,null,null,null,"RTU 4",null,null,null,null,"11FT. 4''",null,null,null,null,null,null,null,null,null,"1-1/2\"",null,null,null,null,"1.5''",null,null,null,"2FT. 1''",null,null,null,null,"1-1/4\"",null,null,null,null,"1\"",null,null,null,null,null,1.25,null,null,null,null,"2\"",null,null,null,"2-3/8\""]
[null,null,"D6",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"1.25''",null,null,null,"22FT. 3''",null,null,null,null,"1\"",null,null,null,null,"1\"",null,null,null,null,null,"0.75''",null,null,null,null,"2-1/2\"",null,null,null,"2-7/8\""]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"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,"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,"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,"*Approximate"]

{"sheet":"2020 Chain","index":1,"n_rows":23,"n_cols":66,"rows_kept":23,"cut":false,"hidden":false,"merged":[[15,51,15,55],[15,56,15,60],[15,61,15,65],[15,21,15,26],[15,27,15,32],[15,33,15,38],[15,39,15,44],[15,45,15,50]]}
["2020-10-01",null,{"$f":"COUNTIFS($B$21:$B$135,\">=\"&A1,$B$21:$B$135,\"<=\"&D1)","v":0},"2020-10-31"]
["2020-11-01",null,0,"2020-11-30"]
["2020-12-01",null,0,"2020-12-31"]
["2021-01-01",null,0,"2021-01-31"]
["2021-02-01",null,0,"2021-02-28"]
["2021-03-01",null,0,"2021-03-31"]
["2021-04-01",null,0,"2021-04-30"]
["2021-05-01",null,0,"2021-05-31"]
["2021-06-01",null,0,"2021-06-30"]
[]
[]
[]
[]
[]
[]
["(2) Store No.","Survey Due Date","(3) Location Name","(4) SOW","(8) Construction Start Date (CSD)","(14) Prototype","(23) Region","TAB Partner","Street Address","City","State","(27) Operator","Program Lead","JLL Development Manager (DM)","(29) Project Service Provider (PSP PM)","(32) Strategic Reinvestment Consultant (SRC)","(33) Facilities Consultant","(37) Architect","Open Date","Location Phone","Location E-mail","AC1",null,null,null,null,null,"AC2",null,null,null,null,null,"AC3",null,null,null,null,null,"AC4",null,null,null,null,null,"AC5",null,null,null,null,null,"AC6",null,null,null,null,"AC7",null,null,null,null,"AC8"]
[1,null,"Northeast",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Serial #","HUMIDITROL","Model #","Mfg Date","Age","Type","Serial #","HUMIDITROL","Model #","Mfg Date","Age","Type","Serial #","HUMIDITROL","Model #","Mfg Date","Age","Type","Serial #","HUMIDITROL","Model #","Mfg Date","Age","Type","Serial #","HUMIDITROL","Model #","Mfg Date","Age","Type","Serial #","Model #","Mfg Date","Age","Type","Serial #","Model #","Mfg Date","Age","Type","Serial #","Model #","Mfg Date","Age","Type"]
[]
[]
[1763,{"$f":"E20-210","v":"2022-06-11"},"Clayton FSU","MLv2/BI","2023-01-07","S04-152","Southeast",{"$f":"IF(MID(G20,1,3)=\"Nor\",\"National TAB\", IF(MID(G20,1,3)=\"Atl\",\"National TAB\",IF(MID(G20,4,4)=\"thea\",\"National TAB\",\"Melink\")))","v":"National TAB"},"151 Highway 441 N","Clayton","GA","Jay Couey","Rex Powell","Greg Newkirk","Dominic Llanos","Troy Buchanan","Zach Steele","CPH","10/28/2004","(706) 212-0022","01763@chick-fil-a.com","5615F08095",null,"LGH150S4BH4Y","2015-06-01",{"$f":"(TODAY()-Y20)/365","v":7.3260273972602743},{"$f":"IF(ISBLANK(V20),\"NODATA\",IF(MID(X20,1,2)=\"RN\",\"AAON\",IF(LEN(X20)>15,\"WeatherMaker\",IF(VALUE(MID(V20,3,2))>9,\"ENER\",IF(VALUE(MID(V20,3,2))<10,\"L-SER\")))))","v":"ENER"},"5616J13617",null,"LGH102H4BH3Y","2016-09-01",{"$f":"(TODAY()-AE20)/365","v":6.0712328767123287},{"$f":"IF(ISBLANK(AB20),\"NODATA\",IF(MID(AD20,1,2)=\"RN\",\"AAON\",IF(LEN(AD20)>15,\"WeatherMaker\",IF(VALUE(MID(AB20,3,2))>9,\"ENER\",IF(VALUE(MID(AB20,3,2))<10,\"L-SER\")))))","v":"ENER"},"5616E03711",null,"LGH092H4MM2Y","2016-05-01",{"$f":"(TODAY()-AK20)/365","v":6.4082191780821915},{"$f":"IF(ISBLANK(AH20),\"NODATA\",IF(LEN(AJ20)>15,\"WeatherMaker\",IF(VALUE(MID(AH20,3,2))>9,\"ENER\",IF(VALUE(MID(AH20,3,2))<10,\"L-SER\"))))","v":"ENER"},"5616G07446",null,"LGH120H4BH3Y","2016-07-01",{"$f":"(TODAY()-AQ20)/365","v":6.2410958904109588},{"$f":"IF(ISBLANK(AN20),\"NODATA\",IF(LEN(AP20)>15,\"WeatherMaker\",IF(VALUE(MID(AN20,3,2))>9,\"ENER\",IF(VALUE(MID(AN20,3,2))<10,\"L-SER\"))))","v":"ENER"},"5616J01065",null,"LGH072H4BH4Y","2016-09-01",{"$f":"(TODAY()-AW20)/365","v":6.0712328767123287},{"$f":"IF(ISBLANK(AT20),\"NODATA\",IF(LEN(AV20)>15,\"WeatherMaker\",IF(VALUE(MID(AT20,3,2))>9,\"ENER\",IF(VALUE(MID(AT20,3,2))<10,\"L-SER\"))))","v":"ENER"}]
[]
[]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"5614G02828","LCH120H4BN3Y","2014-07-01"]

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