{"text_format":"1","workbook":"xlsx","n_sheets":2,"sheets":["Survey","2020 Chain"],"not_rendered":{"charts":0,"images":10,"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":295,"n_cols":73,"rows_kept":295,"cut":false,"hidden":false,"merged":[[18,30,18,32],[22,21,22,23],[10,62,10,65],[52,45,52,47],[58,18,58,20],[102,36,102,38],[0,1,0,8],[0,9,0,17],[0,54,0,66],[0,34,0,53],[0,18,0,21],[0,22,0,33],[9,66,9,71],[10,66,10,71],[11,66,11,71],[30,3,30,14],[32,3,32,14],[40,3,40,14],[10,57,10,61],[11,57,11,61],[5,66,5,71],[6,66,6,71],[42,45,42,47],[8,57,8,61],[9,57,9,61],[11,1,11,3],[16,1,16,64],[15,1,15,57],[12,1,12,3],[18,36,18,38],[18,18,18,20],[12,12,12,22],[14,1,14,44],[20,36,20,38],[20,18,20,20],[13,41,13,47],[13,53,13,56],[11,53,11,56],[145,37,145,66],[144,55,144,66],[147,1,147,66],[148,1,148,66],[149,1,149,66],[150,1,150,66],[151,1,151,66],[152,1,152,66],[153,1,153,66],[44,18,44,20],[44,21,44,23],[86,63,86,65],[58,63,58,65],[54,1,54,66],[52,36,52,38],[24,51,24,53],[24,63,24,65],[24,18,24,20],[28,42,28,44],[28,36,28,38],[28,39,28,41],[28,33,28,35],[30,57,30,59],[52,39,52,41],[80,60,80,62],[80,51,80,53],[70,57,70,59],[80,48,80,50],[52,42,52,44],[20,48,20,50],[32,42,32,44],[62,18,62,20],[6,72,6,78],[5,72,5,78],[12,53,12,56],[12,62,12,65],[8,48,8,52],[9,48,9,52],[10,48,10,52],[11,48,11,52],[12,48,12,52],[13,48,13,52],[7,41,7,47],[8,41,8,47],[9,41,9,47],[10,41,10,47],[11,41,11,47],[12,41,12,47],[7,72,7,78],[8,72,8,78],[9,72,9,78],[10,72,10,78],[11,72,11,78],[12,72,12,78],[13,72,13,78],[7,66,7,71],[8,66,8,71],[12,66,12,71],[13,66,13,71],[13,57,13,61],[12,57,12,61],[55,1,55,66],[52,18,52,20],[58,33,58,35],[13,34,13,40],[80,27,80,29],[79,1,79,66],[32,24,32,26],[50,30,50,32],[50,27,50,29],[50,33,50,35],[42,3,42,14],[44,3,44,14],[42,39,42,41],[46,3,46,14],[50,18,50,20],[50,36,50,38],[53,1,53,66],[24,21,24,23],[24,36,24,38],[18,21,18,23],[24,39,24,41],[42,30,42,32],[34,1,34,66],[35,1,35,66],[36,1,36,66],[37,1,37,66],[38,1,38,66],[70,45,70,47],[46,18,46,20],[20,45,20,47],[48,54,48,56],[48,18,48,20],[60,48,60,50],[60,54,60,56],[22,3,22,14],[24,3,24,14],[58,3,58,14],[20,63,20,65],[22,60,22,62],[22,42,22,44],[20,57,20,59],[20,51,20,53],[20,27,20,29],[22,24,22,26],[26,48,26,50],[20,30,20,32],[50,51,50,53],[50,54,50,56],[52,33,52,35],[52,30,52,32],[59,1,59,66],[60,3,60,14],[58,42,58,44],[58,45,58,47],[58,48,58,50],[58,51,58,53],[22,48,22,50],[22,30,22,32],[22,33,22,35],[40,33,40,35],[104,33,104,35],[102,3,102,14],[104,3,104,14],[102,18,102,20],[82,54,82,56],[64,39,64,41],[84,54,84,56],[86,30,86,32],[82,42,82,44],[28,3,28,14],[26,36,26,38],[30,60,30,62],[84,21,84,23],[72,24,72,26],[70,30,70,32],[80,42,80,44],[70,21,70,23],[44,60,44,62],[42,18,42,20],[72,60,72,62],[72,51,72,53],[72,54,72,56],[58,27,58,29],[58,57,58,59],[72,3,72,14],[82,60,82,62],[74,1,74,66],[70,3,70,14],[70,18,70,20],[52,60,52,62],[64,57,64,59],[102,57,102,59],[122,3,122,14],[122,60,122,62],[122,63,122,65],[108,21,108,23],[108,24,108,26],[120,60,120,62],[108,30,108,32],[108,36,108,38],[108,39,108,41],[110,24,110,26],[110,45,110,47],[108,33,108,35],[110,54,110,56],[117,1,117,66],[110,30,110,32],[118,54,118,56],[110,51,110,53],[108,18,108,20],[122,51,122,53],[122,48,122,50],[118,51,118,53],[121,1,121,66],[118,24,118,26],[120,42,120,44],[122,18,122,20],[120,36,120,38],[22,57,22,59],[24,48,24,50],[80,21,80,23],[80,30,80,32],[100,42,100,44],[100,45,100,47],[88,33,88,35],[88,30,88,32],[88,45,88,47],[90,45,90,47],[90,39,90,41],[18,3,18,14],[72,36,72,38],[72,48,72,50],[82,33,82,35],[84,27,84,29],[80,36,80,38],[82,27,82,29],[82,30,82,32],[92,45,92,47],[92,27,92,29],[99,1,99,66],[100,63,100,65],[90,3,90,14],[92,3,92,14],[100,3,100,14],[100,30,100,32],[92,24,92,26],[100,39,100,41],[51,1,51,66],[13,4,13,11],[80,3,80,14],[80,33,80,35],[64,33,64,35],[88,57,88,59],[89,1,89,66],[18,45,18,47],[26,27,26,29],[26,33,26,35],[26,3,26,14],[24,42,24,44],[28,24,28,26],[24,27,24,29],[24,45,24,47],[24,60,24,62],[42,24,42,26],[70,27,70,29],[71,1,71,66],[26,24,26,26],[80,24,80,26],[80,39,80,41],[61,1,61,66],[58,39,58,41],[62,3,62,14],[48,57,48,59],[66,24,66,26],[84,57,84,59],[29,1,29,66],[28,48,28,50],[86,39,86,41],[30,45,30,47],[44,48,44,50],[90,30,90,32],[92,39,92,41],[92,42,92,44],[88,60,88,62],[86,60,86,62],[100,21,100,23],[88,63,88,65],[88,51,88,53],[88,39,88,41],[88,24,88,26],[100,51,100,53],[68,39,68,41],[70,48,70,50],[68,27,68,29],[70,36,70,38],[70,51,70,53],[80,54,80,56],[70,24,70,26],[73,1,73,66],[72,30,72,32],[70,42,70,44],[68,48,68,50],[81,1,81,66],[96,1,96,66],[97,1,97,66],[100,57,100,59],[100,33,100,35],[82,48,82,50],[87,1,87,66],[88,48,88,50],[86,42,86,44],[88,21,88,23],[98,1,98,66],[82,3,82,14],[68,60,68,62],[66,63,66,65],[68,21,68,23],[62,33,62,35],[62,21,62,23],[65,1,65,66],[62,57,62,59],[68,33,68,35],[62,27,62,29],[62,42,62,44],[62,48,62,50],[68,30,68,32],[64,45,64,47],[68,45,68,47],[62,63,62,65],[64,63,64,65],[66,57,66,59],[66,60,66,62],[64,42,64,44],[70,39,70,41],[80,63,80,65],[72,18,72,20],[72,45,72,47],[76,1,76,66],[70,63,70,65],[64,3,64,14],[88,27,88,29],[88,42,88,44],[64,36,64,38],[66,48,66,50],[13,31,13,33],[18,42,18,44],[12,23,12,25],[13,23,13,25],[10,53,10,56],[9,53,9,56],[70,33,70,35],[11,26,11,30],[12,26,12,30],[13,26,13,30],[11,31,11,33],[12,34,12,40],[22,45,22,47],[11,23,11,25],[62,24,62,26],[58,24,58,26],[69,1,69,66],[22,63,22,65],[22,36,22,38],[24,30,24,32],[52,21,52,23],[52,24,52,26],[52,27,52,29],[60,33,60,35],[44,45,44,47],[42,27,42,29],[62,60,62,62],[58,54,58,56],[58,36,58,38],[60,60,60,62],[60,36,60,38],[13,1,13,3],[48,45,48,47],[46,24,46,26],[46,36,46,38],[62,51,62,53],[60,39,60,41],[60,45,60,47],[60,27,60,29],[44,36,44,38],[60,18,60,20],[60,24,60,26],[60,30,60,32],[66,54,66,56],[64,21,64,23],[56,1,56,66],[52,48,52,50],[50,57,50,59],[48,24,48,26],[60,51,60,53],[52,54,52,56],[52,57,52,59],[52,63,52,65],[104,24,104,26],[80,18,80,20],[26,60,26,62],[28,63,28,65],[28,60,28,62],[28,51,28,53],[32,63,32,65],[25,1,25,66],[28,45,28,47],[28,21,28,23],[27,1,27,66],[26,18,26,20],[28,18,28,20],[40,54,40,56],[42,42,42,44],[40,27,40,29],[40,24,40,26],[40,30,40,32],[40,48,40,50],[40,57,40,59],[46,63,46,65],[46,60,46,62],[46,57,46,59],[66,33,66,35],[46,51,46,53],[46,48,46,50],[46,27,46,29],[46,30,46,32],[46,33,46,35],[46,39,46,41],[30,33,30,35],[26,42,26,44],[88,18,88,20],[28,54,28,56],[28,57,28,59],[26,54,26,56],[26,57,26,59],[50,63,50,65],[48,21,48,23],[50,21,50,23],[72,63,72,65],[68,42,68,44],[67,1,67,65],[66,36,66,38],[66,39,66,41],[86,57,86,59],[26,45,26,47],[46,45,46,47],[44,39,44,41],[46,54,46,56],[46,42,46,44],[48,48,48,50],[48,3,48,14],[44,27,44,29],[42,48,42,50],[47,1,47,66],[46,21,46,23],[44,33,44,35],[52,3,52,14],[68,18,68,20],[64,24,64,26],[66,18,66,20],[66,30,66,32],[66,27,66,29],[17,1,17,66],[22,51,22,53],[22,54,22,56],[24,33,24,35],[24,24,24,26],[24,57,24,59],[24,54,24,56],[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],[11,4,11,11],[12,4,12,11],[11,62,11,65],[19,1,19,66],[20,24,20,26],[20,42,20,44],[20,3,20,14],[12,31,12,33],[11,12,11,22],[13,12,13,22],[20,60,20,62],[20,54,20,56],[18,24,18,26],[11,34,11,40],[18,48,18,50],[18,51,18,53],[18,39,18,41],[18,57,18,59],[10,23,10,25],[10,31,10,33],[9,34,9,40],[7,34,7,40],[8,12,8,22],[8,26,8,30],[10,1,10,3],[10,34,10,40],[10,4,10,11],[10,26,10,30],[10,12,10,22],[9,26,9,30],[7,31,7,33],[8,31,8,33],[9,31,9,33],[7,26,7,30],[6,26,6,30],[6,31,6,33],[8,34,8,40],[3,1,3,9],[4,1,4,9],[7,12,7,22],[2,1,2,4],[2,5,2,18],[8,4,8,11],[5,4,5,11],[5,31,5,33],[8,62,8,65],[6,1,6,3],[5,1,5,3],[7,4,7,11],[7,1,7,3],[6,4,6,11],[5,34,5,40],[7,62,7,65],[9,62,9,65],[3,19,3,27],[7,53,7,56],[8,53,8,56],[4,19,4,27],[4,60,4,71],[4,54,4,59],[4,49,4,53],[4,43,4,48],[4,38,4,42],[4,28,4,37],[20,39,20,41],[20,21,20,23],[84,3,84,14],[1,1,1,4],[5,41,5,47],[5,48,5,52],[6,41,6,47],[6,48,6,52],[5,53,5,56],[6,53,6,56],[5,57,5,61],[6,57,6,61],[5,62,5,65],[6,62,6,65],[7,57,7,61],[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,48,7,52],[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,10,3,18],[4,10,4,18],[122,33,122,35],[178,2,178,8],[145,1,145,36],[143,37,143,39],[138,44,138,46],[141,56,141,65],[142,1,142,23],[132,1,132,66],[133,1,133,66],[13,62,13,65],[18,54,18,56],[18,63,18,65],[18,60,18,62],[30,54,30,56],[33,1,33,66],[44,24,44,26],[30,24,30,26],[30,27,30,29],[30,36,30,38],[43,1,43,66],[44,51,44,53],[44,63,44,65],[42,60,42,62],[104,60,104,62],[104,36,104,38],[104,39,104,41],[104,30,104,32],[88,3,88,14],[44,30,44,32],[44,42,44,44],[28,30,28,32],[18,33,18,35],[122,21,122,23],[122,24,122,26],[122,39,122,41],[122,45,122,47],[119,1,119,66],[108,48,108,50],[122,30,122,32],[122,27,122,29],[122,42,122,44],[178,0,200,0],[198,1,200,32],[198,34,200,65],[174,1,176,32],[156,1,172,32],[154,1,154,7],[174,34,176,65],[156,34,172,65],[122,36,122,38],[122,57,122,59],[124,48,124,50],[124,51,124,53],[123,1,123,66],[122,54,122,56],[140,1,140,55],[140,56,140,60],[139,39,139,41],[137,1,137,38],[137,40,137,42],[136,1,136,39],[136,41,136,43],[124,24,124,26],[124,27,124,29],[118,30,118,32],[108,51,108,53],[108,54,108,56],[110,18,110,20],[118,45,118,47],[120,39,120,41],[120,57,120,59],[120,3,120,14],[109,1,109,66],[110,60,110,62],[110,63,110,65],[108,45,108,47],[118,18,118,20],[118,36,118,38],[118,39,118,41],[118,42,118,44],[118,63,118,65],[110,21,110,23],[120,48,120,50],[120,45,120,47],[114,1,114,66],[115,1,115,66],[108,3,108,14],[120,24,120,26],[120,27,120,29],[120,30,120,32],[120,33,120,35],[110,3,110,14],[118,27,118,29],[116,1,116,66],[142,36,142,38],[141,1,141,31],[92,36,92,38],[92,48,92,50],[102,42,102,44],[101,1,101,66],[92,63,92,65],[144,49,144,51],[110,42,110,44],[110,57,110,59],[104,51,104,53],[124,30,124,32],[124,60,124,62],[124,54,124,56],[124,42,124,44],[124,45,124,47],[104,54,104,56],[118,33,118,35],[112,1,112,66],[104,27,104,29],[144,52,144,54],[135,1,135,32],[127,1,127,66],[103,1,103,66],[104,63,104,65],[141,32,141,36],[141,37,141,47],[139,1,139,37],[138,1,138,42],[135,34,135,36],[128,1,128,66],[124,63,124,65],[222,34,224,65],[202,60,202,65],[180,34,196,65],[294,1,296,32],[294,34,296,65],[250,1,250,6],[250,25,250,32],[250,34,250,41],[250,60,250,65],[228,1,244,32],[228,34,244,65],[246,1,248,32],[246,34,248,65],[252,1,268,32],[252,34,268,65],[270,1,272,32],[270,34,272,65],[274,2,274,7],[274,25,274,32],[274,34,274,41],[274,59,274,64],[276,1,292,32],[202,34,202,41],[226,2,226,7],[226,25,226,32],[276,34,292,65],[226,59,226,64],[226,34,226,41],[154,60,154,65],[106,57,106,59],[106,63,106,65],[104,48,104,50],[88,36,88,38],[102,45,102,47],[204,1,220,32],[202,25,202,32],[178,34,178,41],[142,25,142,27],[142,28,142,30],[142,32,142,34],[144,43,144,45],[144,46,144,48],[124,39,124,41],[124,57,124,59],[108,57,108,59],[104,57,104,59],[108,42,108,44],[102,48,102,50],[102,39,102,41],[92,33,92,35],[143,40,143,42],[143,43,143,45],[104,42,104,44],[110,48,110,50],[143,46,143,48],[143,49,143,51],[143,52,143,54],[143,55,143,57],[143,58,143,60],[143,61,143,63],[143,64,143,66],[144,37,144,39],[144,40,144,42],[82,39,82,41],[222,1,224,32],[204,34,220,65],[178,25,178,32],[82,36,82,38],[82,21,82,23],[202,1,202,6],[82,51,82,53],[86,54,86,56],[86,24,86,26],[86,33,86,35],[86,36,86,38],[84,51,84,53],[84,33,84,35],[84,18,84,20],[100,60,100,62],[90,57,90,59],[134,1,134,66],[154,25,154,32],[90,60,90,62],[90,33,90,35],[178,59,178,64],[154,34,154,41],[146,1,146,66],[144,1,144,36],[86,18,86,20],[84,60,84,62],[86,21,86,23],[180,1,196,32],[129,1,129,66],[130,1,130,66],[131,1,131,66],[113,1,113,66],[90,27,90,29],[90,51,90,53],[92,30,92,32],[93,1,93,66],[104,18,104,20],[104,21,104,23],[107,1,107,66],[91,1,91,66],[90,18,90,20],[90,21,90,23],[88,54,88,56],[90,54,90,56],[90,48,90,50],[118,3,118,14],[124,18,124,20],[106,3,106,14],[106,18,106,20],[106,24,106,26],[106,30,106,32],[106,36,106,38],[106,42,106,44],[106,48,106,50],[118,60,118,62],[106,51,106,53],[90,36,90,38],[100,36,100,38],[94,1,94,66],[95,1,95,66],[26,30,26,32],[26,21,26,23],[26,63,26,65],[62,30,62,32],[26,39,26,41],[26,51,26,53],[28,27,28,29],[30,42,30,44],[32,54,32,56],[30,30,30,32],[42,33,42,35],[40,51,40,53],[40,39,40,41],[41,1,41,66],[32,60,32,62],[40,45,40,47],[32,18,32,20],[42,51,42,53],[40,21,40,23],[32,21,32,23],[62,54,62,56],[31,1,31,66],[30,18,30,20],[52,51,52,53],[32,27,32,29],[30,21,30,23],[60,57,60,59],[60,63,60,65],[58,60,58,62],[57,1,57,66],[60,42,60,44],[50,24,50,26],[30,48,30,50],[30,51,30,53],[42,63,42,65],[42,57,42,59],[42,36,42,38],[64,51,64,53],[66,21,66,23],[64,30,64,32],[64,27,64,29],[58,21,58,23],[63,1,63,65],[84,30,84,32],[84,24,84,26],[84,42,84,44],[84,63,84,65],[70,54,70,56],[68,24,68,26],[32,48,32,50],[32,39,32,41],[39,1,39,66],[42,54,42,56],[32,57,32,59],[40,36,40,38],[32,45,32,47],[40,42,40,44],[32,51,32,53],[32,33,32,35],[48,33,48,35],[48,60,48,62],[50,60,50,62],[48,63,48,65],[48,27,48,29],[80,45,80,47],[72,21,72,23],[72,33,72,35],[102,60,102,62],[102,33,102,35],[102,63,102,65],[84,48,84,50],[84,36,84,38],[82,45,82,47],[83,1,83,66],[82,57,82,59],[84,45,84,47],[82,18,82,20],[102,54,102,56],[100,48,100,50],[100,24,100,26],[90,24,90,26],[86,45,86,47],[86,27,86,29],[86,48,86,50],[102,27,102,29],[102,30,102,32],[102,21,102,23],[102,51,102,53],[100,18,100,20],[100,54,100,56],[86,51,86,53],[86,3,86,14],[92,18,92,20],[92,21,92,23],[72,57,72,59],[80,57,80,59],[0,69,0,78],[1,64,1,78],[2,64,2,78],[1,41,1,42],[2,41,2,42],[1,30,1,40],[2,30,2,40],[1,43,1,53],[2,43,2,53],[1,54,1,63],[1,19,1,29],[2,54,2,63],[2,19,2,29],[77,1,77,66],[78,1,78,66],[3,72,3,78],[4,72,4,78],[3,60,3,71],[3,54,3,59],[3,49,3,53],[3,43,3,48],[3,38,3,42],[3,28,3,37],[70,60,70,62],[68,63,68,65],[72,42,72,44],[72,27,72,29],[48,36,48,38],[72,39,72,41],[66,3,66,14],[68,3,68,14],[75,1,75,66],[60,21,60,23],[44,54,44,56],[40,60,40,62],[42,21,42,23],[44,57,44,59],[40,18,40,20],[62,39,62,41],[62,45,62,47],[62,36,62,38],[64,18,64,20],[58,30,58,32],[64,48,64,50],[66,42,66,44],[68,57,68,59],[66,45,66,47],[68,54,68,56],[64,60,64,62],[66,51,66,53],[48,42,48,44],[49,1,49,66],[48,30,48,32],[48,39,48,41],[50,45,50,47],[50,48,50,50],[45,1,45,66],[50,3,50,14],[68,36,68,38],[68,51,68,53],[64,54,64,56],[50,39,50,41],[50,42,50,44],[48,51,48,53],[30,39,30,41],[30,63,30,65],[110,39,110,41],[104,45,104,47],[90,63,90,65],[90,42,90,44],[92,60,92,62],[102,24,102,26],[92,57,92,59],[92,51,92,53],[100,27,100,29],[108,27,108,29],[124,21,124,23],[118,57,118,59],[106,54,106,56],[106,60,106,62],[106,21,106,23],[106,27,106,29],[106,33,106,35],[106,39,106,41]],"merged_total":1044,"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,"Austin McFall",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,{"$f":"'2020 Chain'!B20","v":"2022-03-19"}]
[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,"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,null,"EMAIL"]
[null,{"$f":"'2020 Chain'!A20","v":2775},null,null,null,{"$f":"'2020 Chain'!C20","v":"Chapman Highway"},null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"'2020 Chain'!I20","v":"7565 Mountain Grove Dr"},null,null,null,null,null,null,null,null,null,null,{"$f":"'2020 Chain'!J20","v":"Knoxville"},null,null,null,null,null,null,null,null,null,null,{"$f":"'2020 Chain'!K20","v":"TN"},null,{"$f":"'2020 Chain'!L20","v":"Tim Whittemore"},null,null,null,null,null,null,null,null,null,null,{"$f":"'2020 Chain'!S20","v":"(865) 573-0023"},null,null,null,null,null,null,null,null,null,{"$f":"'2020 Chain'!T20","v":"02775@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,"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,null,"CONSTR. START",null,null,null,null,null,"SCOPE OF WORK",null,null,null,null,null,null,null,null,null,null,null,"ARCHITECT"]
[null,{"$f":"'2020 Chain'!N20","v":"George Watkins"},null,null,null,null,null,null,null,null,{"$f":"'2020 Chain'!O20","v":"Jim Anderson"},null,null,null,null,null,null,null,null,{"$f":"'2020 Chain'!M20","v":"Chad Ross"},null,null,null,null,null,null,null,null,{"$f":"'2020 Chain'!P20","v":"Cory Reese"},null,null,null,null,null,null,null,null,null,{"$f":"'2020 Chain'!F20","v":"S08N-LG"},null,null,null,null,{"$f":"'2020 Chain'!R20","v":"2011-03-03"},null,null,null,null,null,{"$f":"(TODAY()-AR5)/365","v":11.046575342465754},null,null,null,null,{"$f":"'2020 Chain'!E20","v":"2022-08-06"},null,null,null,null,null,{"$f":"'2020 Chain'!D20","v":"MLv2"},null,null,null,null,null,null,null,null,null,null,null,{"$f":"'2020 Chain'!Q20","v":"Interplan"}]
[null,"AC#",null,null,"SERIAL #",null,null,null,null,null,null,null,"MODEL #",null,null,null,null,null,null,null,null,null,null,"TON",null,null,"MFG.",null,null,null,null,"AGE",null,null,"HVAC UNIT TYPE",null,null,null,null,null,null,"AREA SERVED",null,null,null,null,null,null,"HEAT EXCH.",null,null,null,null,"COND.DAM.",null,null,null,"HAIL GARD",null,null,null,null,"EVAP COIL",null,null,null,"POW EXH",null,null,null,null,null,"TOTAL"]
[null,"AC1",null,null,{"$f":"'2020 Chain'!U20","v":"5610M05428"},null,null,null,null,null,null,null,{"$f":"'2020 Chain'!V20","v":"LGH180H4BH2Y"},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":"15"},null,null,{"$f":"IF(ISBLANK(M7),\"\",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'!X20","v":11.298630136986301},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(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":"IF(MID(AM5,1,7)=\"S97-100\",\"RR/DIN A/ENTA\",IF(MID(AM5,1,7)=\"S97-120\",\"RR/DIN A\",IF(MID(AM5,1,7)=\"S97-138\",\"RR/DIN A\",IF(MID(AM5,1,4)=\"S03C\",\"KITCHEN\",IF(MID(AM5,1,7)=\"S03-146\",\"KITCHEN\",IF(MID(AM5,1,9)=\"S03-150SW\",\"KITCHEN\",IF(MID(AM5,1,7)=\"S04-110\",\"KITCHEN\",IF(MID(AM5,1,3)=\"S04\",\"Kitchen\",IF(MID(AM5,1,4)=\"S06A\",\"KITCHEN\",IF(MID(AM5,1,4)=\"S06B\",\"KITCHEN\",IF(MID(AM5,1,4)=\"S06C\",\"KITCHEN\",IF(MID(AM5,1,4)=\"S06E\",\"KITCHEN\",IF(MID(AM5,1,4)=\"S08A\",\"KITCHEN\",IF(MID(AM5,1,6)=\"S08N-T\",\"KITCHEN\",IF(MID(AM5,1,7)=\"S08N-LG\",\"KITCHEN\",IF(MID(AM5,9,2)=\"AZ\",\"KITCHEN\",IF(MID(AM5,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,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,{"$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,null,null,{"$f":"SUM(AT7:BR7)","v":0}]
[null,"AC2",null,null,{"$f":"'2020 Chain'!Z20","v":"5610M05184"},null,null,null,null,null,null,null,{"$f":"'2020 Chain'!AA20","v":"LGH060H4EH1Y"},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":"5"},null,null,{"$f":"IF(ISBLANK(M8),\"\",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'!AC20","v":11.298630136986301},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,1,3)=\"50T\",\"WEAMaker\",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":"IF(MID(AM5,1,7)=\"S97-100\",\"KITCHEN\",IF(MID(AM5,1,7)=\"S97-120\",\"KITCHEN\",IF(MID(AM5,1,7)=\"S97-138\",\"KITCHEN\",IF(MID(AM5,1,4)=\"S03C\",\"MECH/RR/DIN A\",IF(MID(AM5,1,7)=\"S03-146\",\"RR/DIN A\",IF(MID(AM5,1,9)=\"S03-150SW\",\"RR/DIN A/MECH\",IF(MID(AM5,1,7)=\"S04-110\",\"MECH/RR/DIN A\",IF(MID(AM5,1,3)=\"S04\",\"Mech/RR/Din A\",IF(MID(AM5,1,4)=\"S06A\",\"ENT A/SERV/DT\",IF(MID(AM5,1,4)=\"S06B\",\"MECH/RR/DIN A\",IF(MID(AM5,1,4)=\"S06C\",\"MECH/RR/DIN A\",IF(MID(AM5,1,4)=\"S06E\",\"MECH/RR/DIN A\",IF(MID(AM5,1,4)=\"S08A\",\"DT/SERV/ENT\",IF(MID(AM5,1,6)=\"S08N-T\",\"MECH/RR/DIN A/ENT A\",IF(MID(AM5,1,7)=\"S08N-LG\",\"MECH/RR/DIN A/ENT A\",IF(MID(AM5,9,2)=\"AZ\",\"DINING\",IF(MID(AM5,1,2)=\"KK\",\"RR/DIN A,/ENT A\",\"\")))))))))))))))))","v":"MECH/RR/DIN A/ENT 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,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,{"$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,null,null,{"$f":"SUM(AT8:BO8)","v":0}]
[null,"AC3",null,null,{"$f":"'2020 Chain'!AE20","v":"5610M03729"},null,null,null,null,null,null,null,{"$f":"'2020 Chain'!AF20","v":"LGH120H4BH2Y"},null,null,null,null,null,null,null,null,null,null,"10",null,null,"Lennox",null,null,null,null,{"$f":"'2020 Chain'!AH20","v":11.298630136986301},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,1,3)=\"50T\",\"WEAMaker\",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":"IF(MID(AM5,1,7)=\"S97-100\",\"SERV/DT/ENT B\",IF(MID(AM5,1,7)=\"S97-120\",\"SERV/DIN B/DT\",IF(MID(AM5,1,7)=\"S97-138\",\"SERV/DT/DIN B/ENT B\",IF(MID(AM5,1,4)=\"S03C\",\"SERV/DT/DIN B/ENT B\",IF(MID(AM5,1,7)=\"S03-146\",\"ENT A/DIN B\",IF(MID(AM5,1,9)=\"S03-150SW\",\"ENT A/DIN B\",IF(MID(AM5,1,7)=\"S04-110\",\"DT/SERV/DIN B/ENT A&B\",IF(MID(AM5,1,3)=\"S04\",\"SERV/DT/DIN B/ENT B\",IF(MID(AM5,1,4)=\"S06A\",\"RR/DIN\",IF(MID(AM5,1,4)=\"S06B\",\"DT/SERV/DIN B/ENT B\",IF(MID(AM5,1,4)=\"S06C\",\"SERV/DT/DIN B/ENT B\",IF(MID(AM5,1,4)=\"S06E\",\"SERV/ENTA/ENTB,/DIN B\",IF(MID(AM5,1,4)=\"S08A\",\"RR/DINING\",IF(MID(AM5,1,6)=\"S08N-T\",\"DIN B\",IF(MID(AM5,1,7)=\"S08N-LG\",\"DIN B\",IF(MID(AM5,9,2)=\"AZ\",\"ENTRY/DINING\",IF(MID(AM5,1,2)=\"KK\",\"DIN B\",\"\")))))))))))))))))","v":"DIN 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,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,{"$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,null,null,0]
[null,"AC4",null,null,{"$f":"'2020 Chain'!AJ20","v":"5610L00593"},null,null,null,null,null,null,null,{"$f":"'2020 Chain'!AK20","v":"LGH060H4EH1Y"},null,null,null,null,null,null,null,null,null,null,"5",null,null,"Lennox",null,null,null,null,{"$f":"'2020 Chain'!AM20","v":11.38082191780822},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(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":"IF(MID(AM5,1,7)=\"S97-100\",\"DIN B/ENT A/PLAYLAND\",IF(MID(AM5,1,7)=\"S97-120\",\"ENTA/DIN B\",IF(MID(AM5,1,7)=\"S97-138\",\"ENT A/DIN B\",IF(MID(AM5,1,4)=\"S03C\",\"ENT A/DIN B\",IF(MID(AM5,1,7)=\"S03-146\",\"SERV/DIN B\",IF(MID(AM5,1,9)=\"S03-150SW\",\"SERV/DIN B\",IF(MID(AM5,1,7)=\"S04-110\",\"PLAYLAND\",IF(MID(AM5,1,3)=\"S04\",\"ENTA/DIN B\",IF(MID(AM5,1,4)=\"S06A\",\"PLAYLAND\",IF(MID(AM5,1,4)=\"S06B\",\"ENT A/DIN B\",IF(MID(AM5,1,4)=\"S06C\",\"ENT A/DIN B\",IF(MID(AM5,1,4)=\"S06E\",\"PLAYLAND\",IF(MID(AM5,1,4)=\"S08A\",\"PLAYLAND\",IF(MID(AM5,1,6)=\"S08N-T\",\"DT,SERV/DIN B\",IF(MID(AM5,1,7)=\"S08N-LG\",\"DT/SERV/DIN B\",IF(MID(AM5,9,2)=\"AZ\",\"SERV/DINING/RR/DT\",IF(MID(AM5,1,2)=\"KK\",\"SERV/DIN B\",\"\")))))))))))))))))","v":"DT/SERV/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,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,{"$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,null,null,0]
[null,"AC5",null,null,{"$f":"'2020 Chain'!AO20","v":"5610M05154"},null,null,null,null,null,null,null,{"$f":"'2020 Chain'!AP20","v":"LGH060H4E1Y"},null,null,null,null,null,null,null,null,null,null,"5",null,null,"Lennox",null,null,null,null,{"$f":"'2020 Chain'!AR20","v":11.298630136986301},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,1,3)=\"50T\",\"WEAMaker\",IF(MID(M11,1,3)=\"50H\",\"WEAMaster HP\",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":"IF(MID(AM5,1,7)=\"S97-120\",\"PLAY LAND\",IF(MID(AM5,1,7)=\"S97-138\",\"PLAYLAND\",IF(MID(AM5,1,4)=\"S03C\",\"PLAYLAND\",IF(MID(AM5,1,7)=\"S03-146\",\"PLAYLAND\",IF(MID(AM5,1,9)=\"S03-150SW\",\"PLAYLAND\",IF(MID(AM5,1,3)=\"S04\",\"PLAYLAND\",IF(MID(AM5,1,4)=\"S06B\",\"PLAYLAND\",IF(MID(AM5,1,4)=\"S06C\",\"PLAYLAND\",IF(MID(AM5,1,6)=\"S08N-T\",\"PLAYLAND\",IF(MID(AM5,1,7)=\"S08N-LG\",\"PLAYLAND\",IF(MID(AM5,9,2)=\"AZ\",\"KITCHEN/OFFICE\",IF(MID(AM5,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,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,{"$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,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'!AW20","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,{"$f":"IF(MID(AM5,1,7)=\"S04-162\",\"OFFICE/BREAK ROOM\",IF(MID(AM5,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,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,{"$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,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,{"$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,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,{"$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,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,"TOTAL",null,null,null,null,null,null,{"$f":"VALUE(SUM(AP7:AP13))","v":0},null,null,null,null,{"$f":"SUM(AT7:AT13)","v":0},null,null,null,{"$f":"SUM(AX7:AX13)","v":0},null,null,null,null,{"$f":"SUM(BB7:BB13)","v":0},null,null,null,{"$f":"SUM(BF7:BF13)","v":0},null,null,null,null,null,{"$f":"SUM(AW14:BO14)","v":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,"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,"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(AP3,1,2)=\"NC\",\"CRITICAL\",IF(MID(AP3,1,2)=\"IA\",\"CRITICAL\",IF(MID(AP3,1,2)=\"MN\",\"CRITICAL\",IF(MID(AP3,1,2)=\"TX\",\"CRITICAL\",IF(MID(AP3,1,2)=\"AR\",\"CRITICAL\",IF(MID(AP3,1,2)=\"OK\",\"CRITICAL\",IF(MID(AP3,1,2)=\"MO\",\"CRITICAL\",IF(MID(AP3,1,2)=\"KS\",\"CRITICAL\",IF(MID(AP3,1,3)=\"NEB\",\"CRITICAL\",IF(MID(AP3,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,"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,"7.  Are there any Humiditrol units?  If YES,  enter unit tonnage.  Unless climate dictates Humiditrol units at kitchen & play land only."]
[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,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,5,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,"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\",\"\")))))","v":"N/A"},null,null,"AC2",null,null,5,null,null,"AC3",null,null,10,null,null,"AC4",null,null,5,null,null,"AC5",null,null,5,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 1 THROUGH 8 MISC. NOTES"]
[null,"ALL AC UNITS HAVE DIRTY CONDESER COILS. NEED TO BE CLEANED"]
[null,"PERIMETER OF ALL EVAP COIL FOR UNITS HAVE COLLECTED DEBRIS."]
[null,"AC4 HUMIDITY SENSOR IS WIRED, BUT IT IS WIRED INCORRECTLY."]
[]
[]
[null,"9.  Record size of gas line going into unit."]
[null,null,null,"CRITICAL",null,null,null,null,null,null,null,null,null,null,null,null,null,null,"AC1",null,null,1,null,null,"AC2",null,null,0.75,null,null,"AC3",null,null,0.75,null,null,"AC4",null,null,0.75,null,null,"AC5",null,null,0.75,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,"10.  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,"11.  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,"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,"12.  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,"13.  Is smoke detector dust plugs capped?  If YES, enter unit tonnage."]
[null,null,null,"CRITICAL",null,null,null,null,null,null,null,null,null,null,null,null,null,null,"AC1",null,null,"C",null,null,"AC2",null,null,"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,"14.  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\",\"\"))))))","v":"N/A"},null,null,"AC2",null,null,"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\",\"\")))","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\",\"\")))","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,"15. 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\",\"\"))))))","v":"N/A"},null,null,"AC2",null,null,"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\",\"\")))","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\",\"\")))","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,"CANNOT VERIFY IF SMOKE SAMPLING TUBE IS CAPPED FOR AC 1"]
[]
[]
[null,"16. 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,"N/A",null,null,"AC3",null,null,"C",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,"17. 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\",\"\")))))","v":"N/A"},null,null,"AC2",null,null,"N/A",null,null,"AC3",null,null,10,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,"18. 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\",\"\")))))","v":"N/A"},null,null,"AC2",null,null,"N/A",null,null,"AC3",null,null,"A58",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,"19.  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,"20.  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,5,null,null,"AC3",null,null,10,null,null,"AC4",null,null,5,null,null,"AC5",null,null,5,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.  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,"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,"22.  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,{"$f":"IF(ISBLANK($E$8),\"N/A\",IF(LEN($M$8)>15,\"N/A\",IF(MID($M$8,4,3)<=\"072\",\"N/A\",IF(MID($M$8,4,3)>=\"180\",\"N/A\",IF(MID($M$8,7,2)=\"14\",\"N/A\",IF(MID($M$8,7,2)=\"16\",\"N/A\",IF(MID($M$8,4,3)>\"149\",\"N/A\",\"\")))))))","v":"N/A"},null,null,"AC3",null,null,"C",null,null,"AC4",null,null,{"$f":"IF(ISBLANK($E$10),\"N/A\",IF(LEN($M$10)>15,\"N/A\",IF(MID($M$10,4,3)<=\"072\",\"N/A\",IF(MID($M$10,4,3)>\"150\",\"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($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,"23.  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,"AC 2/4/5 ARE ALL DIRECT DRIVE UNITS"]
[null,"AC 3 MOTOR PULLEY GROOVES ARE RUSTED. WILL NOT BE ABLE TO MAKE ANY ADJUSTMENTS. SIZE IS VL50 1-3/4\""]
[]
[]
[]
[null,"24. 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,"25. 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,5,null,null,"AC3",null,null,10,null,null,"AC4",null,null,5,null,null,"AC5",null,null,5,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,"26. 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,"27. 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,"28.  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,"29.  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,"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.  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,"31.  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,"R",null,null,"AC3",null,null,"R",null,null,"AC4",null,null,"N",null,null,"AC5",null,null,"R",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,"32.  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,"33.  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,"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,"34.  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,5,null,null,"AC3",null,null,10,null,null,"AC4",null,null,"C",null,null,"AC5",null,null,5,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,"35.  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,"36.  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,"AC 1 OA DAMPER DOES NOT CLOSE WITH POWER OFF. MANAGER WITNESSED WATER LEAKING FROM CEILING"]
[null,"IN MANAGER'S OFFICE AREA NEAR THE LIGHT."]
[]
[]
[]
[null,"37.  Provide condensation pipe size.  Minimum 1\" at playland unit, and 1.25\" at all other units."]
[null,3,null,"REVIEW & RECTIFY",null,null,null,null,null,null,null,null,null,null,null,null,null,null,"AC1",null,null,1.25,null,null,"AC2",null,null,1.25,null,null,"AC3",null,null,1.25,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,"38.  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,15,null,null,"AC2",null,null,5,null,null,"AC3",null,null,10,null,null,"AC4",null,null,5,null,null,"AC5",null,null,5,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.  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,15,null,null,"AC2",null,null,"C",null,null,"AC3",null,null,10,null,null,"AC4",null,null,5,null,null,"AC5",null,null,5,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 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,15,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,"41.  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."]
[null," ",null,"CRITICAL",null,null,null,null,null,null,null,null,null,null,null,null,null,null,"AC1",null,null,15,null,null,"AC2",null,null,5,null,null,"AC3",null,null,10,null,null,"AC4",null,null,5,null,null,"AC5",null,null,5,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,"42.  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,"Y"]
[null,"43.  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,"N"]
[null,"43.  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,"N"]
[null,"44.  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,"Y"]
[null,"46.  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,"N"]
[null,"47.  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,"48.  Record model and serial number of Suncoast Panel.",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Model #",null,null,null,null,"CHICK-FIL-A CONTROL PANEL",null,null,null,null,null,null,null,null,null,null,null,null,null,"Serial #",null,null,null,null,"10-CFA-066"]
[null,"49.  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,"X"]
[null,"50.  Are thermostats Robert Shaw or Network?  Enter \"RS\", \"NW\"",null,null,null,null,null,null,null,null,null,null,null,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,"for Robert Shaw and Network respectively.  If thermostat not",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"AC6 -",null,null,null,null,null,"AC7 -",null,null,null,null,null,"AC8 -"]
[null,"Robertshaw or Network respectively enter \"NO\""]
[null,"MISCELLANEOUS NOTES"]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[null,"ROOF LAYOUT",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"ROOF LAYOUT"]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[null,"AC 3 MOTOR NOT ALIGNED",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"AC 2 OA DAMPER NOT CONNECTED"]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[null,"OA DAMPER FOR AC 1 DOES NOT CLOSE WITH POWER OFF",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"INCORRECT WIRE USED FOR TEMP SENSORS - \"COLEMAN\" BRAND"]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[null,"AC4 HUMIDITY SENSOR NOT WIRED CORRECTLY",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"CONDENSATE DRAIN TYPICAL"]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[null,"EVAP COIL TYPICAL",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"INSERT 10"]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[null,"INSERT 11",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"INSERT 12"]

{"sheet":"2020 Chain","index":1,"n_rows":23,"n_cols":60,"rows_kept":23,"cut":false,"hidden":false,"merged":[[15,45,15,49],[15,50,15,54],[15,55,15,59],[15,20,15,24],[15,25,15,29],[15,30,15,34],[15,35,15,39],[15,40,15,44]]}
["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","(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,"AC2",null,null,null,null,"AC3",null,null,null,null,"AC4",null,null,null,null,"AC5",null,null,null,null,"AC6",null,null,null,null,"AC7",null,null,null,null,"AC8"]
[1,null,"Northeast",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"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"]
[]
[]
[2775,{"$f":"E20-140","v":"2022-03-19"},"Chapman Highway","MLv2","2022-08-06","S08N-LG","Atlantic",{"$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"},"7565 Mountain Grove Dr","Knoxville","TN","Tim Whittemore","Chad Ross","George Watkins","Jim Anderson","Cory Reese","Interplan","2011-03-03","(865) 573-0023","02775@chick-fil-a.com","5610M05428","LGH180H4BH2Y","2010-12-01",{"$f":"(TODAY()-W20)/365","v":11.298630136986301},{"$f":"IF(ISBLANK(U20),\"NODATA\",IF(MID(V20,1,2)=\"RN\",\"AAON\",IF(LEN(V20)>15,\"WeatherMaker\",IF(VALUE(MID(U20,3,2))>9,\"ENER\",IF(VALUE(MID(U20,3,2))<10,\"L-SER\")))))","v":"ENER"},"5610M05184","LGH060H4EH1Y","2010-12-01",{"$f":"(TODAY()-AB20)/365","v":11.298630136986301},{"$f":"IF(ISBLANK(Z20),\"NODATA\",IF(MID(AA20,1,2)=\"RN\",\"AAON\",IF(LEN(AA20)>15,\"WeatherMaker\",IF(VALUE(MID(Z20,3,2))>9,\"ENER\",IF(VALUE(MID(Z20,3,2))<10,\"L-SER\")))))","v":"ENER"},"5610M03729","LGH120H4BH2Y","2010-12-01",{"$f":"(TODAY()-AG20)/365","v":11.298630136986301},{"$f":"IF(ISBLANK(AE20),\"NODATA\",IF(LEN(AF20)>15,\"WeatherMaker\",IF(VALUE(MID(AE20,3,2))>9,\"ENER\",IF(VALUE(MID(AE20,3,2))<10,\"L-SER\"))))","v":"ENER"},"5610L00593","LGH060H4EH1Y","2010-11-01",{"$f":"(TODAY()-AL20)/365","v":11.38082191780822},{"$f":"IF(ISBLANK(AJ20),\"NODATA\",IF(LEN(AK20)>15,\"WeatherMaker\",IF(VALUE(MID(AJ20,3,2))>9,\"ENER\",IF(VALUE(MID(AJ20,3,2))<10,\"L-SER\"))))","v":"ENER"},"5610M05154","LGH060H4E1Y","2010-12-01",{"$f":"(TODAY()-AQ20)/365","v":11.298630136986301},{"$f":"IF(ISBLANK(AO20),\"NODATA\",IF(LEN(AP20)>15,\"WeatherMaker\",IF(VALUE(MID(AO20,3,2))>9,\"ENER\",IF(VALUE(MID(AO20,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,"5614G02828","LCH120H4BN3Y","2014-07-01"]