{"text_format":"1","workbook":"xlsx","n_sheets":1,"sheets":["PDSC Spreadsheet"],"not_rendered":{"charts":0,"images":1,"macros":1,"external_links":2,"defined_names":48,"comments":2,"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":"PDSC Spreadsheet","index":0,"n_rows":295,"n_cols":51,"rows_kept":295,"cut":false,"hidden":false,"merged":[[172,22,172,25],[173,22,173,25],[174,22,174,25],[175,22,175,25],[176,22,176,25],[177,22,177,25],[178,22,178,25],[179,22,179,25],[180,22,180,25],[291,16,291,25],[77,9,77,13],[77,2,77,8],[182,2,182,25],[183,2,183,25],[153,22,153,25],[154,22,154,25],[155,22,155,25],[156,22,156,25],[157,22,157,25],[158,22,158,25],[159,22,159,25],[160,22,160,25],[161,22,161,25],[162,22,162,25],[163,22,163,25],[164,22,164,25],[165,22,165,25],[166,22,166,25],[167,22,167,25],[168,22,168,25],[169,22,169,25],[134,22,134,25],[102,22,102,25],[103,22,103,25],[104,22,104,25],[105,22,105,25],[106,22,106,25],[107,22,107,25],[108,22,108,25],[109,22,109,25],[135,22,135,25],[145,22,145,25],[146,22,146,25],[147,22,147,25],[148,22,148,25],[149,22,149,25],[150,22,150,25],[113,22,113,25],[114,22,114,25],[115,22,115,25],[116,22,116,25],[117,22,117,25],[118,22,118,25],[119,22,119,25],[120,22,120,25],[121,22,121,25],[122,22,122,25],[123,22,123,25],[124,22,124,25],[125,22,125,25],[126,22,126,25],[127,22,127,25],[128,22,128,25],[85,22,85,25],[86,22,86,25],[87,22,87,25],[88,22,88,25],[89,22,89,25],[90,22,90,25],[91,22,91,25],[92,22,92,25],[93,22,93,25],[94,22,94,25],[95,22,95,25],[96,22,96,25],[97,22,97,25],[98,22,98,25],[99,22,99,25],[100,22,100,25],[101,22,101,25],[149,17,149,21],[150,17,150,21],[151,17,151,21],[152,17,152,21],[153,17,153,21],[154,17,154,21],[155,17,155,21],[156,17,156,21],[157,17,157,21],[158,17,158,21],[111,22,111,25],[112,22,112,25],[122,17,122,21],[123,17,123,21],[132,22,132,25],[133,22,133,25],[129,22,129,25],[136,22,136,25],[137,22,137,25],[138,22,138,25],[139,22,139,25],[140,22,140,25],[141,22,141,25],[142,22,142,25],[143,22,143,25],[144,22,144,25],[131,17,131,21],[132,17,132,21],[133,17,133,21],[134,17,134,21],[135,17,135,21],[136,17,136,21],[137,17,137,21],[138,17,138,21],[139,17,139,21],[140,17,140,21],[110,22,110,25],[143,17,143,21],[144,17,144,21],[145,17,145,21],[146,17,146,21],[147,17,147,21],[148,17,148,21],[102,17,102,21],[290,1,290,13],[62,12,62,15],[62,20,62,25],[62,18,62,19],[74,2,74,7],[74,8,74,16],[105,17,105,21],[106,17,106,21],[107,17,107,21],[108,17,108,21],[109,17,109,21],[110,17,110,21],[111,17,111,21],[112,17,112,21],[113,17,113,21],[114,17,114,21],[115,17,115,21],[116,17,116,21],[117,17,117,21],[118,17,118,21],[119,17,119,21],[120,17,120,21],[121,17,121,21],[159,17,159,21],[124,17,124,21],[125,17,125,21],[126,17,126,21],[127,17,127,21],[128,17,128,21],[129,17,129,21],[130,17,130,21],[85,17,85,21],[86,17,86,21],[87,17,87,21],[88,17,88,21],[89,17,89,21],[90,17,90,21],[91,17,91,21],[92,17,92,21],[93,17,93,21],[94,17,94,21],[95,17,95,21],[96,17,96,21],[97,17,97,21],[98,17,98,21],[99,17,99,21],[100,17,100,21],[101,17,101,21],[5,1,5,25],[4,1,4,25],[45,23,45,25],[51,23,51,25],[52,23,52,25],[22,17,22,25],[23,17,23,25],[24,2,24,7],[24,8,24,16],[24,17,24,25],[25,2,25,7],[25,8,25,16],[25,17,25,25],[26,2,26,7],[26,8,26,16],[26,17,26,25],[7,1,7,5],[33,13,33,25],[37,2,37,12],[37,13,37,14],[9,6,9,8],[9,9,9,10],[9,1,9,5],[43,2,43,25],[19,2,19,25],[17,7,17,25],[7,6,7,25],[39,2,39,16],[41,2,41,5],[41,6,41,8],[41,10,41,25],[9,12,9,14],[71,17,71,25],[72,2,72,7],[72,8,72,16],[72,17,72,25],[73,2,73,7],[73,8,73,16],[73,17,73,25],[9,15,9,25],[50,23,50,25],[46,23,46,25],[47,23,47,25],[30,3,30,8],[31,3,31,8],[32,3,32,8],[30,11,30,25],[31,11,31,25],[32,11,32,25],[33,11,33,12],[58,2,58,22],[58,23,58,25],[60,2,60,25],[62,2,62,7],[54,23,54,25],[55,23,55,25],[57,2,57,22],[57,23,57,25],[48,23,48,25],[49,23,49,25],[62,9,62,10],[85,2,85,4],[85,5,85,8],[85,9,85,12],[86,2,86,4],[86,5,86,8],[86,9,86,12],[86,13,86,16],[1,0,1,25],[66,2,66,25],[11,2,11,25],[13,7,13,25],[22,2,22,7],[21,2,21,7],[22,8,22,16],[21,8,21,16],[21,17,21,25],[23,2,23,7],[23,8,23,16],[53,23,53,25],[83,13,83,16],[84,13,84,16],[85,13,85,16],[81,13,81,16],[82,13,82,16],[77,14,77,15],[79,13,80,16],[68,2,68,25],[70,2,70,7],[70,8,70,16],[70,17,70,25],[71,2,71,7],[71,8,71,16],[75,2,75,7],[75,8,75,16],[75,17,75,25],[79,2,80,4],[81,2,81,4],[79,5,80,8],[81,5,81,8],[79,9,80,12],[81,9,81,12],[82,2,82,4],[82,5,82,8],[82,9,82,12],[83,2,83,4],[83,5,83,8],[83,9,83,12],[84,2,84,4],[84,5,84,8],[84,9,84,12],[77,18,77,25],[79,17,80,21],[81,17,81,21],[82,17,82,21],[83,17,83,21],[84,17,84,21],[79,22,80,25],[81,22,81,25],[82,22,82,25],[83,22,83,25],[84,22,84,25],[193,2,193,4],[193,5,193,7],[193,8,193,11],[193,12,193,16],[190,17,190,19],[190,20,190,22],[190,23,190,25],[191,17,191,19],[191,20,191,22],[191,23,191,25],[190,2,190,4],[190,5,190,7],[64,2,64,25],[179,13,179,16],[176,13,176,16],[177,13,177,16],[173,13,173,16],[174,13,174,16],[175,13,175,16],[170,13,170,16],[171,13,171,16],[172,13,172,16],[167,13,167,16],[168,13,168,16],[169,13,169,16],[164,13,164,16],[165,13,165,16],[166,13,166,16],[161,13,161,16],[162,13,162,16],[163,13,163,16],[74,17,74,25],[194,17,194,19],[194,20,194,22],[194,23,194,25],[195,17,195,19],[195,20,195,22],[195,23,195,25],[194,2,194,4],[194,5,194,7],[194,8,194,11],[194,12,194,16],[195,2,195,4],[195,5,195,7],[293,2,293,25],[294,2,294,25],[180,13,180,16],[192,17,192,19],[192,20,192,22],[192,23,192,25],[193,17,193,19],[193,20,193,22],[193,23,193,25],[192,2,192,4],[192,5,192,7],[192,8,192,11],[187,17,188,19],[187,20,188,22],[187,23,188,25],[189,17,189,19],[189,20,189,22],[189,23,189,25],[180,17,180,21],[192,12,192,16],[198,23,198,25],[199,17,199,19],[199,20,199,22],[199,23,199,25],[198,2,198,4],[198,5,198,7],[198,8,198,11],[198,12,198,16],[199,2,199,4],[199,5,199,7],[199,8,199,11],[199,12,199,16],[190,8,190,11],[190,12,190,16],[191,2,191,4],[191,5,191,7],[191,8,191,11],[191,12,191,16],[196,17,196,19],[196,20,196,22],[196,23,196,25],[197,17,197,19],[197,20,197,22],[197,23,197,25],[196,2,196,4],[196,5,196,7],[196,8,196,11],[196,12,196,16],[197,2,197,4],[197,5,197,7],[197,8,197,11],[197,12,197,16],[202,17,202,19],[202,20,202,22],[202,23,202,25],[203,17,203,19],[203,20,203,22],[203,23,203,25],[202,2,202,4],[202,5,202,7],[202,8,202,11],[202,12,202,16],[203,2,203,4],[203,5,203,7],[203,8,203,11],[203,12,203,16],[195,8,195,11],[195,12,195,16],[200,17,200,19],[200,20,200,22],[200,23,200,25],[201,17,201,19],[201,20,201,22],[201,23,201,25],[200,2,200,4],[200,5,200,7],[200,8,200,11],[200,12,200,16],[201,2,201,4],[201,5,201,7],[201,8,201,11],[201,12,201,16],[198,17,198,19],[198,20,198,22],[206,17,206,19],[206,20,206,22],[206,23,206,25],[207,17,207,19],[207,20,207,22],[207,23,207,25],[206,2,206,4],[206,5,206,7],[206,8,206,11],[206,12,206,16],[207,2,207,4],[207,5,207,7],[207,8,207,11],[207,12,207,16],[204,17,204,19],[204,20,204,22],[204,23,204,25],[205,17,205,19],[205,20,205,22],[205,23,205,25],[204,2,204,4],[204,5,204,7],[204,8,204,11],[204,12,204,16],[205,2,205,4],[205,5,205,7],[205,8,205,11],[205,12,205,16],[210,17,210,19],[210,20,210,22],[210,23,210,25],[211,17,211,19],[211,20,211,22],[211,23,211,25],[210,2,210,4],[210,5,210,7],[210,8,210,11],[210,12,210,16],[211,2,211,4],[211,5,211,7],[211,8,211,11],[211,12,211,16],[208,17,208,19],[208,20,208,22],[208,23,208,25],[209,17,209,19],[209,20,209,22],[209,23,209,25],[208,2,208,4],[208,5,208,7],[208,8,208,11],[208,12,208,16],[209,2,209,4],[209,5,209,7],[209,8,209,11],[209,12,209,16],[214,17,214,19],[214,20,214,22],[214,23,214,25],[215,17,215,19],[215,20,215,22],[215,23,215,25],[214,2,214,4],[214,5,214,7],[214,8,214,11],[214,12,214,16],[215,2,215,4],[215,5,215,7],[215,8,215,11],[215,12,215,16],[212,17,212,19],[212,20,212,22],[212,23,212,25],[213,17,213,19],[213,20,213,22],[213,23,213,25],[212,2,212,4],[212,5,212,7],[212,8,212,11],[212,12,212,16],[213,2,213,4],[213,5,213,7],[213,8,213,11],[213,12,213,16],[218,17,218,19],[218,20,218,22],[218,23,218,25],[219,17,219,19],[219,20,219,22],[219,23,219,25],[218,2,218,4],[218,5,218,7],[218,8,218,11],[218,12,218,16],[219,2,219,4],[219,5,219,7],[219,8,219,11],[219,12,219,16],[216,17,216,19],[216,20,216,22],[216,23,216,25],[217,17,217,19],[217,20,217,22],[217,23,217,25],[216,2,216,4],[216,5,216,7],[216,8,216,11],[216,12,216,16],[217,2,217,4],[217,5,217,7],[217,8,217,11],[217,12,217,16],[222,17,222,19],[222,20,222,22],[222,23,222,25],[223,17,223,19],[223,20,223,22],[223,23,223,25],[222,2,222,4],[222,5,222,7],[222,8,222,11],[222,12,222,16],[223,2,223,4],[223,5,223,7],[223,8,223,11],[223,12,223,16],[220,17,220,19],[220,20,220,22],[220,23,220,25],[221,17,221,19],[221,20,221,22],[221,23,221,25],[220,2,220,4],[220,5,220,7],[220,8,220,11],[220,12,220,16],[221,2,221,4],[221,5,221,7],[221,8,221,11],[221,12,221,16],[226,17,226,19],[226,20,226,22],[226,23,226,25],[227,17,227,19],[227,20,227,22],[227,23,227,25],[226,2,226,4],[226,5,226,7],[226,8,226,11],[226,12,226,16],[227,2,227,4],[227,5,227,7],[227,8,227,11],[227,12,227,16],[224,17,224,19],[224,20,224,22],[224,23,224,25],[225,17,225,19],[225,20,225,22],[225,23,225,25],[224,2,224,4],[224,5,224,7],[224,8,224,11],[224,12,224,16],[225,2,225,4],[225,5,225,7],[225,8,225,11],[225,12,225,16],[230,17,230,19],[230,20,230,22],[230,23,230,25],[231,17,231,19],[231,20,231,22],[231,23,231,25],[230,2,230,4],[230,5,230,7],[230,8,230,11],[230,12,230,16],[231,2,231,4],[231,5,231,7],[231,8,231,11],[231,12,231,16],[228,17,228,19],[228,20,228,22],[228,23,228,25],[229,17,229,19],[229,20,229,22],[229,23,229,25],[228,2,228,4],[228,5,228,7],[228,8,228,11],[228,12,228,16],[229,2,229,4],[229,5,229,7],[229,8,229,11],[229,12,229,16],[234,17,234,19],[234,20,234,22],[234,23,234,25],[235,17,235,19],[235,20,235,22],[235,23,235,25],[234,2,234,4],[234,5,234,7],[234,8,234,11],[234,12,234,16],[235,2,235,4],[235,5,235,7],[235,8,235,11],[235,12,235,16],[232,17,232,19],[232,20,232,22],[232,23,232,25],[233,17,233,19],[233,20,233,22],[233,23,233,25],[232,2,232,4],[232,5,232,7],[232,8,232,11],[232,12,232,16],[233,2,233,4],[233,5,233,7],[233,8,233,11],[233,12,233,16],[238,17,238,19],[238,20,238,22],[238,23,238,25],[239,17,239,19],[239,20,239,22],[239,23,239,25],[238,2,238,4],[238,5,238,7],[238,8,238,11],[238,12,238,16],[239,2,239,4],[239,5,239,7],[239,8,239,11],[239,12,239,16],[236,17,236,19],[236,20,236,22],[236,23,236,25],[237,17,237,19],[237,20,237,22],[237,23,237,25],[236,2,236,4],[236,5,236,7],[236,8,236,11],[236,12,236,16],[237,2,237,4],[237,5,237,7],[237,8,237,11],[237,12,237,16],[242,17,242,19],[242,20,242,22],[242,23,242,25],[243,17,243,19],[243,20,243,22],[243,23,243,25],[242,2,242,4],[242,5,242,7],[242,8,242,11],[242,12,242,16],[243,2,243,4],[243,5,243,7],[243,8,243,11],[243,12,243,16],[240,17,240,19],[240,20,240,22],[240,23,240,25],[241,17,241,19],[241,20,241,22],[241,23,241,25],[240,2,240,4],[240,5,240,7],[240,8,240,11],[240,12,240,16],[241,2,241,4],[241,5,241,7],[241,8,241,11],[241,12,241,16],[246,17,246,19],[246,20,246,22],[246,23,246,25],[247,17,247,19],[247,20,247,22],[247,23,247,25],[246,2,246,4],[246,5,246,7],[246,8,246,11],[246,12,246,16],[247,2,247,4],[247,5,247,7],[247,8,247,11],[247,12,247,16],[244,17,244,19],[244,20,244,22],[244,23,244,25],[245,17,245,19],[245,20,245,22],[245,23,245,25],[244,2,244,4],[244,5,244,7],[244,8,244,11],[244,12,244,16],[245,2,245,4],[245,5,245,7],[245,8,245,11],[245,12,245,16],[250,17,250,19],[250,20,250,22],[250,23,250,25],[251,17,251,19],[251,20,251,22],[251,23,251,25],[250,2,250,4],[250,5,250,7],[250,8,250,11],[250,12,250,16],[251,2,251,4],[251,5,251,7],[251,8,251,11],[251,12,251,16],[248,17,248,19],[248,20,248,22],[248,23,248,25],[249,17,249,19],[249,20,249,22],[249,23,249,25],[248,2,248,4],[248,5,248,7],[248,8,248,11],[248,12,248,16],[249,2,249,4],[249,5,249,7],[249,8,249,11],[249,12,249,16],[254,17,254,19],[254,20,254,22],[254,23,254,25],[255,17,255,19],[255,20,255,22],[255,23,255,25],[254,2,254,4],[254,5,254,7],[254,8,254,11],[254,12,254,16],[255,2,255,4],[255,5,255,7],[255,8,255,11],[255,12,255,16],[252,17,252,19],[252,20,252,22],[252,23,252,25],[253,17,253,19],[253,20,253,22],[253,23,253,25],[252,2,252,4],[252,5,252,7],[252,8,252,11],[252,12,252,16],[253,2,253,4],[253,5,253,7],[253,8,253,11],[253,12,253,16],[258,17,258,19],[258,20,258,22],[258,23,258,25],[259,17,259,19],[259,20,259,22],[259,23,259,25],[258,2,258,4],[258,5,258,7],[258,8,258,11],[258,12,258,16],[259,2,259,4],[259,5,259,7],[259,8,259,11],[259,12,259,16],[256,17,256,19],[256,20,256,22],[256,23,256,25],[257,17,257,19],[257,20,257,22],[257,23,257,25],[256,2,256,4],[256,5,256,7],[256,8,256,11],[256,12,256,16],[257,2,257,4],[257,5,257,7],[257,8,257,11],[257,12,257,16],[262,17,262,19],[262,20,262,22],[262,23,262,25],[263,17,263,19],[263,20,263,22],[263,23,263,25],[262,2,262,4],[262,5,262,7],[262,8,262,11],[262,12,262,16],[263,2,263,4],[263,5,263,7],[263,8,263,11],[263,12,263,16],[260,17,260,19],[260,20,260,22],[260,23,260,25],[261,17,261,19],[261,20,261,22],[261,23,261,25],[260,2,260,4],[260,5,260,7],[260,8,260,11],[260,12,260,16],[261,2,261,4],[261,5,261,7],[261,8,261,11],[261,12,261,16],[266,17,266,19],[266,20,266,22],[266,23,266,25],[267,17,267,19],[267,20,267,22],[267,23,267,25],[266,2,266,4],[266,5,266,7],[266,8,266,11],[266,12,266,16],[267,2,267,4],[267,5,267,7],[267,8,267,11],[267,12,267,16],[264,17,264,19],[264,20,264,22],[264,23,264,25],[265,17,265,19],[265,20,265,22],[265,23,265,25],[264,2,264,4],[264,5,264,7],[264,8,264,11],[264,12,264,16],[265,2,265,4],[265,5,265,7],[265,8,265,11],[265,12,265,16],[270,17,270,19],[270,20,270,22],[270,23,270,25],[271,17,271,19],[271,20,271,22],[271,23,271,25],[270,2,270,4],[270,5,270,7],[270,8,270,11],[270,12,270,16],[271,2,271,4],[271,5,271,7],[271,8,271,11],[271,12,271,16],[268,17,268,19],[268,20,268,22],[268,23,268,25],[269,17,269,19],[269,20,269,22],[269,23,269,25],[268,2,268,4],[268,5,268,7],[268,8,268,11],[268,12,268,16],[269,2,269,4],[269,5,269,7],[269,8,269,11],[269,12,269,16],[274,17,274,19],[274,20,274,22],[274,23,274,25],[275,17,275,19],[275,20,275,22],[275,23,275,25],[274,2,274,4],[274,5,274,7],[274,8,274,11],[274,12,274,16],[275,2,275,4],[275,5,275,7],[275,8,275,11],[275,12,275,16],[272,17,272,19],[272,20,272,22],[272,23,272,25],[273,17,273,19],[273,20,273,22],[273,23,273,25],[272,2,272,4],[272,5,272,7],[272,8,272,11],[272,12,272,16],[273,2,273,4],[273,5,273,7],[273,8,273,11],[273,12,273,16],[281,17,281,19],[281,20,281,22],[281,23,281,25],[276,17,276,19],[276,20,276,22],[276,23,276,25],[277,17,277,19],[277,20,277,22],[277,23,277,25],[276,2,276,4],[276,5,276,7],[276,8,276,11],[276,12,276,16],[277,2,277,4],[277,5,277,7],[277,8,277,11],[277,12,277,16],[278,17,278,19],[278,20,278,22],[278,23,278,25],[279,17,279,19],[279,20,279,22],[279,23,279,25],[278,2,278,4],[278,5,278,7],[278,8,278,11],[278,12,278,16],[279,2,279,4],[279,5,279,7],[279,8,279,11],[279,12,279,16],[280,17,280,19],[280,20,280,22],[280,23,280,25],[87,2,87,4],[87,5,87,8],[87,9,87,12],[88,2,88,4],[88,5,88,8],[88,9,88,12],[89,2,89,4],[89,5,89,8],[89,9,89,12],[94,2,94,4],[94,5,94,8],[94,9,94,12],[95,2,95,4],[95,5,95,8],[281,2,281,4],[89,13,89,16],[87,13,87,16],[88,13,88,16],[93,2,93,4],[281,5,281,7],[281,8,281,11],[281,12,281,16],[178,13,178,16],[95,13,95,16],[92,13,92,16],[93,13,93,16],[94,13,94,16],[90,13,90,16],[91,13,91,16],[96,2,96,4],[96,5,96,8],[96,9,96,12],[280,2,280,4],[280,5,280,7],[280,8,280,11],[280,12,280,16],[284,17,284,19],[284,20,284,22],[284,23,284,25],[285,17,285,19]],"merged_total":1441,"flags":["merged_cut"]}
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,false,"YesNo","Karst_Professional","No_Inf_Tests","Model that considers soil physics and variable hydraulic head conditions","Double Ring","Temperature","Adjustment","Karst_Professional","Sinkhole_Risk","Limiting_Zone","Infiltration_Test","Test_Locations","Test_Type","Exclusions"]
["Draft Version 1.0, April 2024",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,false,"Yes","Soil Scientist (CPSS)",0,"Other (e.g., PCSM Spreadsheet)","Single Ring",30,1.7,"PA-Licensed Professional Geologist","Low","Bedrock","Double Ring",{"$f":"_xlfn.UNIQUE(AB82:AB181,FALSE,FALSE)","v":""},"Test Pit",1,"Areas of a project site that will be disturbed for underground utilities or other infrastructure and then restored to approximate original condition."]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,false,"No","Soils Scientist (PAPSS)",1,null,"Other",31,1.68,"PA-Licensed Professional Engineer","Moderate","Compact Fill","Single Ring",null,"Soil Boring",2,"Areas that have been field verified, prior to or in conjunction with subsurface investigations for infiltration capabilities, as having shallow bedrock conditions that would not comply with separation distance guidelines contained in this Manual or local ordinances for infiltration-based SCMs."]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,false,null,"PG with soils expertise",2,null,null,32,1.66,"Other Certification/License","High","Fragipan","Cased Borehole",null,"Other",3,"Areas that have been field verified, prior to or in conjunction with subsurface investigations for infiltration capabilities, as having a seasonally high water table (SHWT) and/or hydric soil conditions that would not comply with separation distance guidelines contained in this Manual or local ordinances for infiltration-based SCMs."]
[null,"CHAPTER 102",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,false,null,"PE with soils expertise",3,null,null,33,1.64,"None",null,"Groundwater","Other",null,"Test Pit",4,"Areas that are impervious land cover in the pre-construction condition and will not be disturbed and areas where road maintenance activities will occur as defined at 25 Pa. Code § 102.1."]
[null,"PRE-DEVELOPMENT SITE CHARACTERIZATION SPREADSHEET",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,false,null,"Other License/Certification",4,null,null,34,1.62,null,null,"SHWT",null,null,"Other",5,"Areas that are defined at 25 Pa. Code § 102.1 as surface waters and waters of this Commonwealth and areas that are defined at 25 Pa. Code § 105.1 as floodways and floodplains."]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,false,null,null,5,null,null,35,1.6,null,null,"Other",null,null,null,6,"Areas where soils at horizons conducive to infiltration for a project are known to contain pollutant concentrations exceeding the medium-specific concentrations (MSCs) contained in 25 Pa. Code Chapter 250, Appendix A, Tables 3 and 4 (Soil to Groundwater Numeric Values, Used Aquifers, TDS ≤ 2,500 mg/L, for residential or non-residential development)."]
[null,"Project Site Name:",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,false,null,null,6,null,null,36,1.58,null,null,"None",null,null,null,7,"Existing areas on a site that will be protected long-term as a Natural Stormwater Feature SCM and areas intended for establishment or enhancement of a riparian buffer or riparian forest buffer SCM."]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,false,null,null,7,null,null,37,1.56,null,null,null,null,null,null,8,"Areas that will not be disturbed where slopes exceed 20%, including 10 feet from the top and top of slope."]
[null,"Project Site Area:",null,null,null,null,null,null,null,"acres",null,null,"Applicant:",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,false,null,null,8,null,null,38,1.54,null,null,null,null,null,null,9,"Areas that must be avoided to comply with laws regarding the protection of threatened and endangered species."]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,false,null,null,9,null,null,39,1.52,null,null,null,null,null,null,10,"Upland areas that are remote from earth disturbance activities and would be unable to receive stormwater from new impervious surfaces by gravity flow."]
[null,null,"Will PCSM requirements for the project be satisfied entirely by stormwater capture and use or riparian forest buffer SCMs or can the entire project be considered a site restoration activity?",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,false,null,null,10,null,null,40,1.5,null,null,null,null,null,null,11,"Areas where infiltration could, in the opinion of a licensed professional, lead to public safety concerns and/or pollution based on field observations or studies."]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,false,null,null,11,null,null,41,1.48,null,null,null,null,null,null,12,"Other areas that must be avoided to meet setback guidelines of the PCSM Manual or other requirements of local ordinances."]
[null,null,null,"Yes",null,"No",null,{"$f":"IF(AJ1=TRUE,\"A pre-development site characterization is not required\",\"\")","v":""},null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,false,null,null,12,null,null,42,1.46]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,false,null,null,13,null,null,43,1.44]
[null,null,"Is the project site located in an area of known karst terrain?",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,false,null,null,14,null,null,44,1.42]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,false,null,null,15,null,null,45,1.4]
[null,null,null,"Yes",null,"No",null,{"$f":"IF(AJ3=TRUE,\"Complete the information below\",\"\")","v":""},null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,false,null,null,16,null,null,46,1.38]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,false,null,null,17,null,null,47,1.36]
[null,null,"Identify the individual(s) responsible for the geotechnical investigation.",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,false,null,null,18,null,null,48,1.34]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,true,null,null,19,null,null,49,1.32]
[null,null,"Name",null,null,null,null,null,"Company",null,null,null,null,null,null,null,null,"License/Certification",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,20,null,null,50,1.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,null,null,null,null,null,null,21,null,null,51,1.28]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,22,null,null,52,1.26]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,23,null,null,53,1.24]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,24,null,null,54,1.22]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,25,null,null,55,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,26,null,null,56,1.18]
[null,null,"Geotechnical investigation techniques (check all that were completed):",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,27,null,null,57,1.1599999999999999]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,28,null,null,58,1.1399999999999999]
[null,null,null,"Geophysical survey",null,null,null,null,null,null,null,"Bedrock core borings",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,29,null,null,59,1.1200000000000001]
[null,null,null,"Geotechnical borings",null,null,null,null,null,null,null,"Field review of adjacent properties",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,30,null,null,60,1.1000000000000001]
[null,null,null,"Soil profiling",null,null,null,null,null,null,null,"Identification of sinkholes and closed depressions",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,31,null,null,61,1.08]
[null,null,null,"Downstream analysis",null,null,null,null,null,null,null,"Other:",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,32,null,null,62,1.06]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,33,null,null,63,1.04]
[null,null,null,"A geotechnical report has been completed and is attached to Module 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,34,null,null,64,1.02]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,35,null,null,65,1]
[null,null,"Predominant overburden depth across site:",null,null,null,null,null,null,null,null,null,null,null,null,"ft",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,36,null,null,66,0.98599999999999999]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,37,null,null,67,0.97199999999999998]
[null,null,{"$f":"IF(N38<>\"\",IF(N38>=50,\"An investigation of infiltration capabilities is recommended\",IF(AND(N38>=33,N38<50),\"A sinkhole risk assessment is recommended\",IF(N38<33,\"Infiltration may not be feasible (consider MRC Karst SCM(s))\"))),\"\")","v":""},null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,38,null,null,68,0.95799999999999996]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,39,null,null,69,0.94399999999999995]
[null,null,"Sinkhole risk:",null,null,null,null,null,null,null,{"$f":"IF(G42<>\"\",IF(G42=\"Low\",\"An investigation of infiltration capabilities is recommended\",\"Infiltration may not be feasible (consider MRC Karst SCM(s))\"),\"\")","v":""},null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,40,null,null,70,0.93]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,41,null,null,71,0.92]
[null,null,"Areas Excluded for Infiltration SCMs (attach map(s))",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,42,null,null,72,0.91]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,43,null,null,73,0.9]
[null,null,"Exclusion",null,null,"Description",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Area (ac)",null,null,null,null,null,null,null,null,null,null,null,null,null,null,44,null,null,74,0.89]
[null,null,null,null,null,{"$f":"IF(C47<>\"\",VLOOKUP(C47,$AX$2:$AY$13,2),\"\")","v":""},null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"IF(C47<>\"\",\"Y\",\"\")","v":""},null,null,null,null,null,null,null,null,null,null,45,null,null,75,0.88]
[null,null,null,null,null,{"$f":"IF(C48<>\"\",VLOOKUP(C48,$AX$2:$AY$13,2),\"\")","v":""},null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"IF(C48<>\"\",\"Y\",\"\")","v":""},null,null,null,null,null,null,null,null,null,null,46,null,null,76,0.86799999999999999]
[null,null,null,null,null,"",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"",null,null,null,null,null,null,null,null,null,null,47,null,null,77,0.85599999999999998]
[null,null,null,null,null,"",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"",null,null,null,null,null,null,null,null,null,null,48,null,null,78,0.84399999999999997]
[null,null,null,null,null,"",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"",null,null,null,null,null,null,null,null,null,null,49,null,null,79,0.83199999999999996]
[null,null,null,null,null,"",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"",null,null,null,null,null,null,null,null,null,null,50,null,null,80,0.82]
[null,null,null,null,null,"",null,null,null,null,null,null,null,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,null,null,81,0.81199999999999994]
[null,null,null,null,null,"",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"",null,null,null,null,null,null,null,null,null,null,52,null,null,82,0.80400000000000005]
[null,null,null,null,null,"",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"",null,null,null,null,null,null,null,null,null,null,53,null,null,83,0.79600000000000004]
[null,null,null,null,null,"",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"",null,null,null,null,null,null,null,null,null,null,54,null,null,84,0.78800000000000003]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,55,null,null,85,0.78]
[null,null,"Area Unsuitable for Infiltration SCMs (ac):",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"IF(SUM(X47:X56)>0,SUM(X47:X56),\"\")","v":""},null,null,null,{"$f":"IF(COUNTIF(AB47:AB56,\"Y\")=0,0,MAX(_xlfn._xlws.FILTER(ROW(AB47:AB56),AB47:AB56=\"Y\"))-46)","v":0},null,null,null,null,null,null,null,null,null,null,56,null,null,86,0.77]
[null,null,"Area Potentially Suitable for Infiltration SCMs (ac):",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"IF(G10<>\"\",IF(X58<>\"\",G10-X58,G10),\"\")","v":""},null,null,null,null,null,null,null,null,null,null,null,null,null,null,57,null,null,87,0.76]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,58,null,null,88,0.75]
[null,null,"Soils Investigation",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,59,null,null,89,0.74]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,60,null,null,90,0.73]
[null,null,"Investigation method(s):",null,null,null,null,null,null,"Test pits",null,null,"Soil borings",null,null,null,null,null,"Other:",null,null,null,null,null,null,null,null,{"$f":"IF(AND(AJ16=TRUE,AJ17=TRUE,AJ18=TRUE),\"Test_Type\",IF(AND(AJ16=TRUE,AJ17=TRUE,AJ18=FALSE),\"TP_SB\",IF(AND(AJ16=TRUE,AJ17=FALSE,AJ18=TRUE),\"TP_Other\",IF(AND(AJ16=TRUE,AJ17=FALSE,AJ18=FALSE),\"Test_Pit\",IF(AND(AJ16=FALSE,AJ17=TRUE,AJ18=TRUE),\"SB_Other\",IF(AND(AJ16=FALSE,AJ17=TRUE,AJ18=FALSE),\"SB\",IF(AND(AJ16=FALSE,AJ17=FALSE,AJ18=TRUE),\"Other\")))))))","v":false},"(Indirect for Investigation Method)",null,null,null,null,null,null,null,null,null,61,null,null,91,0.72199999999999998]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,62,null,null,92,0.71399999999999997]
[null,null,"Provide an explanation for completing soil borings in lieu of or in addition to test pits:",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,63,null,null,93,0.70599999999999996]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,64,null,null,94,0.69799999999999995]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,65,null,null,95,0.69]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,66,null,null,96,0.68199999999999994]
[null,null,"Name(s) of professional(s) overseeing soils investigation:",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,67,null,null,97,0.67400000000000004]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,68,null,null,98,0.66600000000000004]
[null,null,"Name",null,null,null,null,null,"Company",null,null,null,null,null,null,null,null,"License/Certification",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,69,null,null,99,0.65800000000000003]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"IF(C72<>\"\",\"Y\",\"\")","v":""},null,null,null,null,null,null,null,null,null,null,70,null,null,100,0.65]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"IF(C73<>\"\",\"Y\",\"\")","v":""},null,null,null,null,null,null,null,null,null,null,71,null,null,101,0.64200000000000002]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"",null,null,null,null,null,null,null,null,null,null,72,null,null,102,0.63400000000000001]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"",null,null,null,null,null,null,null,null,null,null,73,null,null,103,0.626]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"",null,null,null,null,null,null,null,null,null,null,74,null,null,104,0.61799999999999999]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,75,null,null,105,0.61]
[null,null,"Test Pit / Soil Boring Log",null,null,null,null,null,null,"No. Test Locations:",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"IF(COUNTIF(AB72:AB76,\"Y\")=0,0,MAX(_xlfn._xlws.FILTER(ROW(AB72:AB76),AB72:AB76=\"Y\"))-71)","v":0},null,null,null,null,null,null,null,null,null,null,76]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,77]
[null,null,"Test Location ID",null,null,"Investigation Method",null,null,null,"Total Depth Investigated (ft)",null,null,null,"Limiting Zone Elevation (ft)",null,null,null,"Limiting Zone Description",null,null,null,null,"Infiltration Test(s) Completed?",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,78]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,79]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"IF(AND(C82<>\"\",W82=\"Yes\"),C82,\"\")","v":""},{"$f":"_xlfn.UNIQUE(AB82:AB181,FALSE,FALSE)","v":""},{"$f":"IF(AND(AB82<>\"\",OR(F82=\"Soil Boring\",F82=\"Other\")),C82,\"\")","v":""},{"$f":"IF(AD82<>\"\",COUNTIF($C$190:$C$289,AD82),\"\")","v":""},{"$f":"IF(AE82<>\"\",IF(AE82<2,\"Y\",\"\"),\"\")","v":""},null,null,null,null,null,null,80]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"IF(AND(C83<>\"\",W83=\"Yes\"),C83,\"\")","v":""},null,{"$f":"IF(AND(AB83<>\"\",OR(F83=\"Soil Boring\",F83=\"Other\")),C83,\"\")","v":""},{"$f":"IF(AD83<>\"\",COUNTIF($C$190:$C$289,AD83),\"\")","v":""},{"$f":"IF(AE83<>\"\",IF(AE83<2,\"Y\",\"\"),\"\")","v":""},null,null,null,null,null,null,81]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"",null,"","",{"$f":"IF(AE84<>\"\",IF(AE84<2,\"Y\",\"\"),\"\")","v":""},null,null,null,null,null,null,82]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"",null,"","","",null,null,null,null,null,null,83]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"",null,"","","",null,null,null,null,null,null,84]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"",null,"","","",null,null,null,null,null,null,85]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"",null,"","","",null,null,null,null,null,null,86]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"",null,"","","",null,null,null,null,null,null,87]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"",null,"","","",null,null,null,null,null,null,88]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"",null,"","","",null,null,null,null,null,null,89]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"",null,"","","",null,null,null,null,null,null,90]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"",null,"","","",null,null,null,null,null,null,91]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"",null,"","","",null,null,null,null,null,null,92]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"",null,"","","",null,null,null,null,null,null,93]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"",null,"","","",null,null,null,null,null,null,94]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"",null,"","","",null,null,null,null,null,null,95]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"",null,"","","",null,null,null,null,null,null,96]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"",null,"","","",null,null,null,null,null,null,97]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"",null,"","","",null,null,null,null,null,null,98]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"",null,"","","",null,null,null,null,null,null,99]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"",null,"","","",null,null,null,null,null,null,100]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"",null,"","",""]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"",null,"","",""]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"",null,"","",""]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"",null,"","",""]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"",null,"","",""]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"",null,"","",""]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"",null,"","",""]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"",null,"","",""]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"",null,"","",""]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"",null,"","",""]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"",null,"","",""]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"",null,"","",""]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"",null,"","",""]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"",null,"","",""]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"",null,"","",""]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"",null,"","",""]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"",null,"","",""]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"",null,"","",""]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"",null,"","",""]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"",null,"","",""]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"",null,"","",""]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"",null,"","",""]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"",null,"","",""]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"",null,"","",""]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"",null,"","",""]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"",null,"","",""]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"",null,"","",""]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"",null,"","",""]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"",null,"","",""]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"",null,"","",""]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"",null,"","",""]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"",null,"","",""]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"",null,"","",""]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"",null,"","",""]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"",null,"","",""]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"",null,"","",""]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"",null,"","",""]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"",null,"","",""]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"",null,"","",""]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"",null,"","",""]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"",null,"","",""]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"",null,"","",""]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"",null,"","",""]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"",null,"","",""]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"IF(AND(C147<>\"\",W147=\"Yes\"),C147,\"\")","v":""},null,{"$f":"IF(AND(AB147<>\"\",OR(F147=\"Soil Boring\",F147=\"Other\")),C147,\"\")","v":""},{"$f":"IF(AD147<>\"\",COUNTIF($C$190:$C$289,AD147),\"\")","v":""},""]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"",null,"","",{"$f":"IF(AE148<>\"\",IF(AE148<2,\"Y\",\"\"),\"\")","v":""}]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"",null,"","",""]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"",null,"","",""]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"",null,"","",""]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"",null,"","",""]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"",null,"","",""]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"",null,"","",""]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"",null,"","",""]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"",null,"","",""]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"",null,"","",""]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"",null,"","",""]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"",null,"","",""]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"",null,"","",""]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"",null,"","",""]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"",null,"","",""]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"",null,"","",""]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"",null,"","",""]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"",null,"","",""]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"",null,"","",""]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"",null,"","",""]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"",null,"","",""]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"",null,"","",""]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"",null,"","",""]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"",null,"","",""]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"",null,"","",""]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"",null,"","",""]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"",null,"","",""]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"",null,"","",""]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"",null,"","",""]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"",null,"","",""]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"",null,"","",""]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"",null,"","",""]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"",null,"","",""]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"",null,"","",""]
[]
[null,null,"Explanation for not conducting infiltration tests:",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"IF(AND(O78<>\"\",COUNTA(C82:C181)=O78,COUNTIF(AB82:AB181,\"\")=100),\"Y\",\"\")","v":""}]
[]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"COUNTA(AC82:AC181)-IF(C181=\"\",1,0)","v":0},null,null,{"$f":"COUNTIF(AF82:AF181,\"Y\")","v":0}]
[null,null,"Infiltration Test Results",null,null,null,null,null,"No. Infiltration Tests:"]
[]
[null,null,"Test Location ID",null,null,"Infiltration Test ID",null,null,"Infiltration Test Elevation (ft)",null,null,null,"Infiltration Test Method",null,null,null,null,"Field Ksat (in/hr)",null,null,"Temp (°F)",null,null,"Adjusted Ksat (in/hr)"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"IF(N292<>\"\",IF(N292<0.5,1,IF(AND(N292<1,N292>=0.5,(_xlfn.STDEV.S(X82:X181)/AVERAGE(X82:X181))<=0.5),2,IF(AND(N292<1,N292>0.5,(_xlfn.STDEV.S(X82:X181)/AVERAGE(X82:X181))>0.5),3,IF(N292>=1,4)))),\"\")","v":""}]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"IF(AND(R190<>\"\",U190<>\"\",M190<>\"\"),R190*VLOOKUP(U190,$AP$2:$AQ$77,2,FALSE),\"\")","v":""},null,null,null,{"$f":"IF(X190<=0.25,\"Y\",\"\")","v":""},{"$f":"_xlfn.UNIQUE(C190:C289,FALSE,FALSE)","v":0},{"$f":"IF(X190<>\"\",\"Y\",\"\")","v":""}]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"IF(AND(R191<>\"\",U191<>\"\",M191<>\"\"),R191*VLOOKUP(U191,$AP$2:$AQ$77,2,FALSE),\"\")","v":""},null,null,null,{"$f":"IF(X191<=0.25,\"Y\",\"\")","v":""},null,{"$f":"IF(X191<>\"\",\"Y\",\"\")","v":""}]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"",null,null,null,"",null,""]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"",null,null,null,"",null,""]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"",null,null,null,"",null,""]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"",null,null,null,"",null,""]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"",null,null,null,"",null,""]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"",null,null,null,"",null,""]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"",null,null,null,"",null,""]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"",null,null,null,"",null,""]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"",null,null,null,"",null,""]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"",null,null,null,"",null,""]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"",null,null,null,"",null,""]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"",null,null,null,"",null,""]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"",null,null,null,"",null,""]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"",null,null,null,"",null,""]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"",null,null,null,"",null,""]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"",null,null,null,"",null,""]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"",null,null,null,"",null,""]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"",null,null,null,"",null,""]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"",null,null,null,"",null,""]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"",null,null,null,"",null,""]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"",null,null,null,"",null,""]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"",null,null,null,"",null,""]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"",null,null,null,"",null,""]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"",null,null,null,"",null,""]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"",null,null,null,"",null,""]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"",null,null,null,"",null,""]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"",null,null,null,"",null,""]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"",null,null,null,"",null,""]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"",null,null,null,"",null,""]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"",null,null,null,"",null,""]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"",null,null,null,"",null,""]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"",null,null,null,"",null,""]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"",null,null,null,"",null,""]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"",null,null,null,"",null,""]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"",null,null,null,"",null,""]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"",null,null,null,"",null,""]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"",null,null,null,"",null,""]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"",null,null,null,"",null,""]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"",null,null,null,"",null,""]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"",null,null,null,"",null,""]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"",null,null,null,"",null,""]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"",null,null,null,"",null,""]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"",null,null,null,"",null,""]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"",null,null,null,"",null,""]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"",null,null,null,"",null,""]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"",null,null,null,"",null,""]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"",null,null,null,"",null,""]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"",null,null,null,"",null,""]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"",null,null,null,"",null,""]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"",null,null,null,"",null,""]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"",null,null,null,"",null,""]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"",null,null,null,"",null,""]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"",null,null,null,"",null,""]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"",null,null,null,"",null,""]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"",null,null,null,"",null,""]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"",null,null,null,"",null,""]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"",null,null,null,"",null,""]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"",null,null,null,"",null,""]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"",null,null,null,"",null,""]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"",null,null,null,"",null,""]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"",null,null,null,"",null,""]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"",null,null,null,"",null,""]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"",null,null,null,"",null,""]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"IF(AND(R255<>\"\",U255<>\"\",M255<>\"\"),R255*VLOOKUP(U255,$AP$2:$AQ$77,2,FALSE),\"\")","v":""},null,null,null,{"$f":"IF(X255<=0.25,\"Y\",\"\")","v":""},null,{"$f":"IF(X255<>\"\",\"Y\",\"\")","v":""}]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"",null,null,null,"",null,""]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"",null,null,null,"",null,""]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"",null,null,null,"",null,""]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"",null,null,null,"",null,""]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"",null,null,null,"",null,""]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"",null,null,null,"",null,""]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"",null,null,null,"",null,""]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"",null,null,null,"",null,""]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"",null,null,null,"",null,""]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"",null,null,null,"",null,""]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"",null,null,null,"",null,""]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"",null,null,null,"",null,""]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"",null,null,null,"",null,""]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"",null,null,null,"",null,""]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"",null,null,null,"",null,""]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"",null,null,null,"",null,""]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"",null,null,null,"",null,""]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"",null,null,null,"",null,""]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"",null,null,null,"",null,""]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"",null,null,null,"",null,""]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"",null,null,null,"",null,""]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"",null,null,null,"",null,""]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"",null,null,null,"",null,""]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"",null,null,null,"",null,""]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"",null,null,null,"",null,""]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"",null,null,null,"",null,""]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"",null,null,null,"",null,""]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"",null,null,null,"",null,""]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"",null,null,null,"",null,""]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"",null,null,null,"",null,""]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"",null,null,null,"",null,""]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"",null,null,null,"",null,""]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"",null,null,null,"",null,""]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"",null,null,null,"",null,""]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"COUNTIF(AB190:AB289,\"Y\")","v":0},{"$f":"COUNTA(AC190:AC289)-IF(C289=\"\",1,0)","v":0},{"$f":"COUNTIF(AD190:AD289,\"Y\")","v":0}]
[null,"Recommended infiltration test location frequency:",null,null,null,null,null,null,null,null,null,null,null,null,1,null,"test / 40,000 square feet (4 minimum)"]
[null,null,"Actual infiltration test location frequency:",null,null,null,null,null,null,null,null,null,null,null,{"$f":"IF(AND(X59<>\"\",O78<>\"\",O78<>0,COUNTA(C82:C181)=O78),AC185/((X59*43560)/40000),\"\")","v":""},null,"test(s) / 40,000 square feet"]
[]
[null,null,{"$f":"IF(AND(O292<>\"\",AC185<>\"\",O186<>\"\",O186=AD290),IF(AC290>=AC185,IF(OR(O292<0.5,AC185<4,AF185>0),\"Additional infiltration tests are recommended.\",IF(AND(O292>=1,AC185>=4),\"Infiltration test location frequency is adequate.\",IF(AND(O292<1,O292>=0.5,(_xlfn.STDEV.S(X190:X289)/AVERAGE(X190:X289))<=0.5),CONCATENATE(\"The coefficient of variation (CV) for infiltration test results is relatively low (\",ROUND(_xlfn.STDEV.S(X190:X289)/AVERAGE(X190:X289),2),\").  Additional infiltration tests may be unnecessary at the discretion of the professional.\"),IF(AND(O292<1,O292>0.5,(_xlfn.STDEV.S(X190:X289)/AVERAGE(X190:X289))>0.5),CONCATENATE(\"The coefficient of variation (CV) for infiltration test results is moderate to high (\",ROUND(_xlfn.STDEV.S(X190:X289)/AVERAGE(X190:X289),2),\").  Additional infiltration tests are recommended.\"))))),\"The number of infiltration test results entered is less than the number of test pits or borings where infiltration tests were reported; enter all infiltration test results\"),\"\")","v":""},null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"IF(AND(O292<>\"\",AD290>0,AD290=O186),IF(O292<0.5,1,IF(AND(O292<1,O292>=0.5,(_xlfn.STDEV.S(X190:X289)/AVERAGE(X190:X289))<=0.5),2,IF(AND(O292<1,O292>0.5,(_xlfn.STDEV.S(X190:X289)/AVERAGE(X190:X289))>0.5),3,IF(O292>=1,4)))),\"\")","v":""}]
[null,null,{"$f":"IF(C294<>\"\",IF(AND(O186<>\"\",O186<>0),IF(AND(OR(AB294=2,AB294=4),AB290<>O186),\"Based on Ksat results alone (not considering limiting zones), opportunities for infiltration SCMs may exist on-site.  These opportunities must be maximized to the extent practicable.\",IF(AB290=O186,\"Infiltration potential may be limited and use of MRC SCMs may be considered.\",IF(OR(AB294=1,AB294=3,AB294=\"\"),\"\"))),\"\"),\"\")","v":""}]