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

{"sheet":"2020 Chain","index":1,"n_rows":23,"n_cols":66,"rows_kept":23,"cut":false,"hidden":false,"merged":[[15,51,15,55],[15,56,15,60],[15,61,15,65],[15,21,15,26],[15,27,15,32],[15,33,15,38],[15,39,15,44],[15,45,15,50]]}
["2020-10-01",null,{"$f":"COUNTIFS($B$21:$B$135,\">=\"&A1,$B$21:$B$135,\"<=\"&D1)","v":0},"2020-10-31"]
["2020-11-01",null,0,"2020-11-30"]
["2020-12-01",null,0,"2020-12-31"]
["2021-01-01",null,0,"2021-01-31"]
["2021-02-01",null,0,"2021-02-28"]
["2021-03-01",null,0,"2021-03-31"]
["2021-04-01",null,0,"2021-04-30"]
["2021-05-01",null,0,"2021-05-31"]
["2021-06-01",null,0,"2021-06-30"]
[]
[]
[]
[]
[]
[]
["(2) Store No.","Survey Due Date","(3) Location Name","(4) SOW","(8) Construction Start Date (CSD)","(14) Prototype","(23) Region","TAB Partner","Street Address","City","State","(27) Operator","SR Program Lead (SRPL)","SR Development Manager (DM)","SR Construction Manager (CM)","SR Program Manager (SRP)","FEQ Field Consultant","(37) Architect","Open Date","Location Phone","Location E-mail","AC1",null,null,null,null,null,"AC2",null,null,null,null,null,"AC3",null,null,null,null,null,"AC4",null,null,null,null,null,"AC5",null,null,null,null,null,"AC6",null,null,null,null,"AC7",null,null,null,null,"AC8"]
[1,null,"Northeast",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Serial #","HUMIDITROL","Model #","Mfg Date","Age","Type","Serial #","HUMIDITROL","Model #","Mfg Date","Age","Type","Serial #","HUMIDITROL","Model #","Mfg Date","Age","Type","Serial #","HUMIDITROL","Model #","Mfg Date","Age","Type","Serial #","HUMIDITROL","Model #","Mfg Date","Age","Type","Serial #","Model #","Mfg Date","Age","Type","Serial #","Model #","Mfg Date","Age","Type","Serial #","Model #","Mfg Date","Age","Type"]
[]
[]
[2131,{"$f":"E20-240","v":"2022-09-08"},"Ranson FSU","MLv2/BI","2023-05-06","S06C-R","Northeast",{"$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"},"156 Joshua M Freeman Blvd","Ranson","WV","Justin Burkhead","Doug Wolve","Tom Wilt","Ken Misso","Jeff Moran","Kevin Hiden","HFR","2009-03-05","(304) 728-1175","02131@chick-fil-a.com",null,"HUM","LGC180H2BH2",null,null,null,null,null,"LGA102H2",null,null,null,null,null,"LGA120H2",null,null,null,null,null,"LGA090H2 ",null,null,null,null,null,"LGA060H2 "]
[]
[]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"5614G02828","LCH120H4BN3Y","2014-07-01"]

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