{"text_format":"1","workbook":"xlsx","n_sheets":3,"sheets":["Sheet1","Patio_Profile","Trench"],"not_rendered":{"charts":1,"images":0,"macros":0,"external_links":0,"defined_names":0,"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":"Sheet1","index":0,"n_rows":90,"n_cols":11,"rows_kept":90,"cut":false,"hidden":false,"merged":[]}
[]
[null,"Actual",null,null,"Override",null,null,"Use"]
[null,"Northing (X)","Easting (Y)","Elevation (Z)","Northing (X)","Easting (Y)","Elevation (Z)","Northing (X)","Easting (Y)","Elevation (Z)"]
["Patio_East",3650070.872,11982619.697000001,0,0,0,0,{"$f":"IF(LEN(E4)>0,E4,B4)","v":0},{"$f":"IF(LEN(F4)>0,F4,C4)","v":0},{"$f":"IF(LEN(G4)>0,G4,D4)","v":0}]
["Patio_West",3650068.66,11982598.220000001,null,{"$f":"B7","v":21.590610760173163},0,null,{"$f":"IF(LEN(E5)>0,E5,B5)","v":21.590610760173163},{"$f":"IF(LEN(F5)>0,F5,C5)","v":0}]
["Delta:",{"$f":"B4-B5","v":2.2119999998249114},{"$f":"C4-C5","v":21.476999999955297}]
["Distance:",{"$f":"SQRT((ABS(C4-C5)^2)+(ABS(B4-B5)^2))","v":21.590610760173163},null,null,{"$f":"SQRT((ABS(F4-F5)^2)+(ABS(E4-E5)^2))","v":21.590610760173163},null,null,{"$f":"SQRT((ABS(I4-I5)^2)+(ABS(H4-H5)^2))","v":21.590610760173163}]
["Bearing:"]
[]
["PointName","From","DeltaX (ft)","DeltaY (ft)","DeltaZ (in)","DeltaZ (ft)","X (ft)","Y (ft)","Z (ft)",null,"Patio Point Elevation"]
["Patio_East",null,{"$f":"H4","v":0},{"$f":"I4","v":0},null,{"$f":"J4","v":0},{"$f":"C11","v":0},{"$f":"D11","v":0},{"$f":"F11","v":0},null,{"$f":"VLOOKUP(G11,Patio_Profile!$D$6:$G$17,3,FALSE)","v":0}]
["0-1",{"$f":"A11","v":"Patio_East"},0,3,-15.5,{"$f":"E12/12","v":-1.2916666666666667},{"$f":"VLOOKUP($B12,$A$11:$I1000,COLUMN(),FALSE)+C12","v":0},{"$f":"IF(RIGHT(A12,1)=\"0\",D12,VLOOKUP($B12,$A$11:$I1000,COLUMN(),FALSE)+D12)","v":3},{"$f":"IF(RIGHT(A12,1)=\"0\",K12,VLOOKUP($B12,$A$11:$I1000,COLUMN(),FALSE)+F12)","v":-1.2916666666666667},null,{"$f":"VLOOKUP(G12,Patio_Profile!$D$6:$G$17,3,FALSE)","v":0}]
["0-2",{"$f":"A12","v":"0-1"},0,3,-14,{"$f":"E13/12","v":-1.1666666666666667},{"$f":"VLOOKUP($B13,$A$11:$I1001,COLUMN(),FALSE)+C13","v":0},{"$f":"IF(RIGHT(A13,1)=\"0\",D13,VLOOKUP($B13,$A$11:$I1001,COLUMN(),FALSE)+D13)","v":6},{"$f":"IF(RIGHT(A13,1)=\"0\",K13,VLOOKUP($B13,$A$11:$I1001,COLUMN(),FALSE)+F13)","v":-2.4583333333333335},null,{"$f":"VLOOKUP(G13,Patio_Profile!$D$6:$G$17,3,FALSE)","v":0}]
["0-3","0-2",0,2,2,0.16666666666666666,{"$f":"VLOOKUP($B14,$A$11:$I1002,COLUMN(),FALSE)+C14","v":0},{"$f":"IF(RIGHT(A14,1)=\"0\",D14,VLOOKUP($B14,$A$11:$I1002,COLUMN(),FALSE)+D14)","v":8},{"$f":"IF(RIGHT(A14,1)=\"0\",K14,VLOOKUP($B14,$A$11:$I1002,COLUMN(),FALSE)+F14)","v":-2.291666666666667},null,{"$f":"VLOOKUP(G14,Patio_Profile!$D$6:$G$17,3,FALSE)","v":0}]
["0-4","0-3",0,2,0,0,{"$f":"VLOOKUP($B15,$A$11:$I1003,COLUMN(),FALSE)+C15","v":0},{"$f":"IF(RIGHT(A15,1)=\"0\",D15,VLOOKUP($B15,$A$11:$I1003,COLUMN(),FALSE)+D15)","v":10},{"$f":"IF(RIGHT(A15,1)=\"0\",K15,VLOOKUP($B15,$A$11:$I1003,COLUMN(),FALSE)+F15)","v":-2.291666666666667},null,{"$f":"VLOOKUP(G15,Patio_Profile!$D$6:$G$17,3,FALSE)","v":0}]
["0-5","0-4",0,2,3.625,0.30208333333333331,{"$f":"VLOOKUP($B16,$A$11:$I1004,COLUMN(),FALSE)+C16","v":0},{"$f":"IF(RIGHT(A16,1)=\"0\",D16,VLOOKUP($B16,$A$11:$I1004,COLUMN(),FALSE)+D16)","v":12},{"$f":"IF(RIGHT(A16,1)=\"0\",K16,VLOOKUP($B16,$A$11:$I1004,COLUMN(),FALSE)+F16)","v":-1.9895833333333337},null,{"$f":"VLOOKUP(G16,Patio_Profile!$D$6:$G$17,3,FALSE)","v":0}]
["0-6","0-5",0,2,5.125,0.42708333333333331,{"$f":"VLOOKUP($B17,$A$11:$I1005,COLUMN(),FALSE)+C17","v":0},{"$f":"IF(RIGHT(A17,1)=\"0\",D17,VLOOKUP($B17,$A$11:$I1005,COLUMN(),FALSE)+D17)","v":14},{"$f":"IF(RIGHT(A17,1)=\"0\",K17,VLOOKUP($B17,$A$11:$I1005,COLUMN(),FALSE)+F17)","v":-1.5625000000000004},null,{"$f":"VLOOKUP(G17,Patio_Profile!$D$6:$G$17,3,FALSE)","v":0}]
["0-7","0-6",0,2,6.75,0.5625,{"$f":"VLOOKUP($B18,$A$11:$I1006,COLUMN(),FALSE)+C18","v":0},{"$f":"IF(RIGHT(A18,1)=\"0\",D18,VLOOKUP($B18,$A$11:$I1006,COLUMN(),FALSE)+D18)","v":16},{"$f":"IF(RIGHT(A18,1)=\"0\",K18,VLOOKUP($B18,$A$11:$I1006,COLUMN(),FALSE)+F18)","v":-1.0000000000000004},null,{"$f":"VLOOKUP(G18,Patio_Profile!$D$6:$G$17,3,FALSE)","v":0}]
["1-0","0-7",2.5,2,0,0,{"$f":"VLOOKUP($B19,$A$11:$I1007,COLUMN(),FALSE)+C19","v":2.5},{"$f":"IF(RIGHT(A19,1)=\"0\",D19,VLOOKUP($B19,$A$11:$I1007,COLUMN(),FALSE)+D19)","v":2},{"$f":"IF(RIGHT(A19,1)=\"0\",K19,VLOOKUP($B19,$A$11:$I1007,COLUMN(),FALSE)+F19)","v":-8.3333333333333329E-2},null,{"$f":"VLOOKUP(G19,Patio_Profile!$D$6:$G$17,3,FALSE)","v":-8.3333333333333329E-2}]
["1-1","1-0",0,2,-2,-0.16666666666666666,{"$f":"VLOOKUP($B20,$A$11:$I1008,COLUMN(),FALSE)+C20","v":2.5},{"$f":"IF(RIGHT(A20,1)=\"0\",D20,VLOOKUP($B20,$A$11:$I1008,COLUMN(),FALSE)+D20)","v":4},{"$f":"IF(RIGHT(A20,1)=\"0\",K20,VLOOKUP($B20,$A$11:$I1008,COLUMN(),FALSE)+F20)","v":-0.25},null,{"$f":"VLOOKUP(G20,Patio_Profile!$D$6:$G$17,3,FALSE)","v":-8.3333333333333329E-2}]
["1-2","1-1",0,2,-3,-0.25,{"$f":"VLOOKUP($B21,$A$11:$I1009,COLUMN(),FALSE)+C21","v":2.5},{"$f":"IF(RIGHT(A21,1)=\"0\",D21,VLOOKUP($B21,$A$11:$I1009,COLUMN(),FALSE)+D21)","v":6},{"$f":"IF(RIGHT(A21,1)=\"0\",K21,VLOOKUP($B21,$A$11:$I1009,COLUMN(),FALSE)+F21)","v":-0.5},null,{"$f":"VLOOKUP(G21,Patio_Profile!$D$6:$G$17,3,FALSE)","v":-8.3333333333333329E-2}]
["1-3","1-2",0,2,0,0,{"$f":"VLOOKUP($B22,$A$11:$I1010,COLUMN(),FALSE)+C22","v":2.5},{"$f":"IF(RIGHT(A22,1)=\"0\",D22,VLOOKUP($B22,$A$11:$I1010,COLUMN(),FALSE)+D22)","v":8},{"$f":"IF(RIGHT(A22,1)=\"0\",K22,VLOOKUP($B22,$A$11:$I1010,COLUMN(),FALSE)+F22)","v":-0.5},null,{"$f":"VLOOKUP(G22,Patio_Profile!$D$6:$G$17,3,FALSE)","v":-8.3333333333333329E-2}]
["1-4","1-3",0,2,1.875,0.15625,{"$f":"VLOOKUP($B23,$A$11:$I1011,COLUMN(),FALSE)+C23","v":2.5},{"$f":"IF(RIGHT(A23,1)=\"0\",D23,VLOOKUP($B23,$A$11:$I1011,COLUMN(),FALSE)+D23)","v":10},{"$f":"IF(RIGHT(A23,1)=\"0\",K23,VLOOKUP($B23,$A$11:$I1011,COLUMN(),FALSE)+F23)","v":-0.34375},null,{"$f":"VLOOKUP(G23,Patio_Profile!$D$6:$G$17,3,FALSE)","v":-8.3333333333333329E-2}]
["1-5","1-4",0,2,3.875,0.32291666666666669,{"$f":"VLOOKUP($B24,$A$11:$I1012,COLUMN(),FALSE)+C24","v":2.5},{"$f":"IF(RIGHT(A24,1)=\"0\",D24,VLOOKUP($B24,$A$11:$I1012,COLUMN(),FALSE)+D24)","v":12},{"$f":"IF(RIGHT(A24,1)=\"0\",K24,VLOOKUP($B24,$A$11:$I1012,COLUMN(),FALSE)+F24)","v":-2.0833333333333315E-2},null,{"$f":"VLOOKUP(G24,Patio_Profile!$D$6:$G$17,3,FALSE)","v":-8.3333333333333329E-2}]
["1-6","1-5",0,2,4.625,0.38541666666666669,{"$f":"VLOOKUP($B25,$A$11:$I1013,COLUMN(),FALSE)+C25","v":2.5},{"$f":"IF(RIGHT(A25,1)=\"0\",D25,VLOOKUP($B25,$A$11:$I1013,COLUMN(),FALSE)+D25)","v":14},{"$f":"IF(RIGHT(A25,1)=\"0\",K25,VLOOKUP($B25,$A$11:$I1013,COLUMN(),FALSE)+F25)","v":0.36458333333333337},null,{"$f":"VLOOKUP(G25,Patio_Profile!$D$6:$G$17,3,FALSE)","v":-8.3333333333333329E-2}]
["1-7","1-6",0,2,5.25,0.4375,{"$f":"VLOOKUP($B26,$A$11:$I1014,COLUMN(),FALSE)+C26","v":2.5},{"$f":"IF(RIGHT(A26,1)=\"0\",D26,VLOOKUP($B26,$A$11:$I1014,COLUMN(),FALSE)+D26)","v":16},{"$f":"IF(RIGHT(A26,1)=\"0\",K26,VLOOKUP($B26,$A$11:$I1014,COLUMN(),FALSE)+F26)","v":0.80208333333333337},null,{"$f":"VLOOKUP(G26,Patio_Profile!$D$6:$G$17,3,FALSE)","v":-8.3333333333333329E-2}]
["2-0","1-7",2.5,2,0,0,{"$f":"VLOOKUP($B27,$A$11:$I1015,COLUMN(),FALSE)+C27","v":5},{"$f":"IF(RIGHT(A27,1)=\"0\",D27,VLOOKUP($B27,$A$11:$I1015,COLUMN(),FALSE)+D27)","v":2},{"$f":"IF(RIGHT(A27,1)=\"0\",K27,VLOOKUP($B27,$A$11:$I1015,COLUMN(),FALSE)+F27)","v":-0.28125},null,{"$f":"VLOOKUP(G27,Patio_Profile!$D$6:$G$17,3,FALSE)","v":-0.28125}]
["2-1","2-0",0,2,-1.5,-0.125,{"$f":"VLOOKUP($B28,$A$11:$I1016,COLUMN(),FALSE)+C28","v":5},{"$f":"IF(RIGHT(A28,1)=\"0\",D28,VLOOKUP($B28,$A$11:$I1016,COLUMN(),FALSE)+D28)","v":4},{"$f":"IF(RIGHT(A28,1)=\"0\",K28,VLOOKUP($B28,$A$11:$I1016,COLUMN(),FALSE)+F28)","v":-0.40625},null,{"$f":"VLOOKUP(G28,Patio_Profile!$D$6:$G$17,3,FALSE)","v":-0.28125}]
["2-2","2-1",0,2,-2.5,-0.20833333333333334,{"$f":"VLOOKUP($B29,$A$11:$I1017,COLUMN(),FALSE)+C29","v":5},{"$f":"IF(RIGHT(A29,1)=\"0\",D29,VLOOKUP($B29,$A$11:$I1017,COLUMN(),FALSE)+D29)","v":6},{"$f":"IF(RIGHT(A29,1)=\"0\",K29,VLOOKUP($B29,$A$11:$I1017,COLUMN(),FALSE)+F29)","v":-0.61458333333333337},null,{"$f":"VLOOKUP(G29,Patio_Profile!$D$6:$G$17,3,FALSE)","v":-0.28125}]
["2-3","2-2",0,2,-0.25,-2.0833333333333332E-2,{"$f":"VLOOKUP($B30,$A$11:$I1018,COLUMN(),FALSE)+C30","v":5},{"$f":"IF(RIGHT(A30,1)=\"0\",D30,VLOOKUP($B30,$A$11:$I1018,COLUMN(),FALSE)+D30)","v":8},{"$f":"IF(RIGHT(A30,1)=\"0\",K30,VLOOKUP($B30,$A$11:$I1018,COLUMN(),FALSE)+F30)","v":-0.63541666666666674},null,{"$f":"VLOOKUP(G30,Patio_Profile!$D$6:$G$17,3,FALSE)","v":-0.28125}]
["2-4","2-3",0,2,2.25,0.1875,{"$f":"VLOOKUP($B31,$A$11:$I1019,COLUMN(),FALSE)+C31","v":5},{"$f":"IF(RIGHT(A31,1)=\"0\",D31,VLOOKUP($B31,$A$11:$I1019,COLUMN(),FALSE)+D31)","v":10},{"$f":"IF(RIGHT(A31,1)=\"0\",K31,VLOOKUP($B31,$A$11:$I1019,COLUMN(),FALSE)+F31)","v":-0.44791666666666674},null,{"$f":"VLOOKUP(G31,Patio_Profile!$D$6:$G$17,3,FALSE)","v":-0.28125}]
["2-5","2-4",0,2,4,0.33333333333333331,{"$f":"VLOOKUP($B32,$A$11:$I1020,COLUMN(),FALSE)+C32","v":5},{"$f":"IF(RIGHT(A32,1)=\"0\",D32,VLOOKUP($B32,$A$11:$I1020,COLUMN(),FALSE)+D32)","v":12},{"$f":"IF(RIGHT(A32,1)=\"0\",K32,VLOOKUP($B32,$A$11:$I1020,COLUMN(),FALSE)+F32)","v":-0.11458333333333343},null,{"$f":"VLOOKUP(G32,Patio_Profile!$D$6:$G$17,3,FALSE)","v":-0.28125}]
["2-6","2-5",0,2,4.75,0.39583333333333331,{"$f":"VLOOKUP($B33,$A$11:$I1021,COLUMN(),FALSE)+C33","v":5},{"$f":"IF(RIGHT(A33,1)=\"0\",D33,VLOOKUP($B33,$A$11:$I1021,COLUMN(),FALSE)+D33)","v":14},{"$f":"IF(RIGHT(A33,1)=\"0\",K33,VLOOKUP($B33,$A$11:$I1021,COLUMN(),FALSE)+F33)","v":0.28124999999999989},null,{"$f":"VLOOKUP(G33,Patio_Profile!$D$6:$G$17,3,FALSE)","v":-0.28125}]
["2-7","2-6",0,2,5.125,0.42708333333333331,{"$f":"VLOOKUP($B34,$A$11:$I1022,COLUMN(),FALSE)+C34","v":5},{"$f":"IF(RIGHT(A34,1)=\"0\",D34,VLOOKUP($B34,$A$11:$I1022,COLUMN(),FALSE)+D34)","v":16},{"$f":"IF(RIGHT(A34,1)=\"0\",K34,VLOOKUP($B34,$A$11:$I1022,COLUMN(),FALSE)+F34)","v":0.70833333333333326},null,{"$f":"VLOOKUP(G34,Patio_Profile!$D$6:$G$17,3,FALSE)","v":-0.28125}]
["3-0","2-7",2.5,2,0,0,{"$f":"VLOOKUP($B35,$A$11:$I1023,COLUMN(),FALSE)+C35","v":7.5},{"$f":"IF(RIGHT(A35,1)=\"0\",D35,VLOOKUP($B35,$A$11:$I1023,COLUMN(),FALSE)+D35)","v":2},{"$f":"IF(RIGHT(A35,1)=\"0\",K35,VLOOKUP($B35,$A$11:$I1023,COLUMN(),FALSE)+F35)","v":-0.66666666666666663},null,{"$f":"VLOOKUP(G35,Patio_Profile!$D$6:$G$17,3,FALSE)","v":-0.66666666666666663}]
["3-1","3-0",0,2,-1.75,-0.14583333333333334,{"$f":"VLOOKUP($B36,$A$11:$I1024,COLUMN(),FALSE)+C36","v":7.5},{"$f":"IF(RIGHT(A36,1)=\"0\",D36,VLOOKUP($B36,$A$11:$I1024,COLUMN(),FALSE)+D36)","v":4},{"$f":"IF(RIGHT(A36,1)=\"0\",K36,VLOOKUP($B36,$A$11:$I1024,COLUMN(),FALSE)+F36)","v":-0.8125},null,{"$f":"VLOOKUP(G36,Patio_Profile!$D$6:$G$17,3,FALSE)","v":-0.66666666666666663}]
["3-2","3-1",0,2,-2.25,-0.1875,{"$f":"VLOOKUP($B37,$A$11:$I1025,COLUMN(),FALSE)+C37","v":7.5},{"$f":"IF(RIGHT(A37,1)=\"0\",D37,VLOOKUP($B37,$A$11:$I1025,COLUMN(),FALSE)+D37)","v":6},{"$f":"IF(RIGHT(A37,1)=\"0\",K37,VLOOKUP($B37,$A$11:$I1025,COLUMN(),FALSE)+F37)","v":-1},null,{"$f":"VLOOKUP(G37,Patio_Profile!$D$6:$G$17,3,FALSE)","v":-0.66666666666666663}]
["3-3","3-2",0,2,-0.5,-4.1666666666666664E-2,{"$f":"VLOOKUP($B38,$A$11:$I1026,COLUMN(),FALSE)+C38","v":7.5},{"$f":"IF(RIGHT(A38,1)=\"0\",D38,VLOOKUP($B38,$A$11:$I1026,COLUMN(),FALSE)+D38)","v":8},{"$f":"IF(RIGHT(A38,1)=\"0\",K38,VLOOKUP($B38,$A$11:$I1026,COLUMN(),FALSE)+F38)","v":-1.0416666666666667},null,{"$f":"VLOOKUP(G38,Patio_Profile!$D$6:$G$17,3,FALSE)","v":-0.66666666666666663}]
["3-4","3-3",0,2,0.5,4.1666666666666664E-2,{"$f":"VLOOKUP($B39,$A$11:$I1027,COLUMN(),FALSE)+C39","v":7.5},{"$f":"IF(RIGHT(A39,1)=\"0\",D39,VLOOKUP($B39,$A$11:$I1027,COLUMN(),FALSE)+D39)","v":10},{"$f":"IF(RIGHT(A39,1)=\"0\",K39,VLOOKUP($B39,$A$11:$I1027,COLUMN(),FALSE)+F39)","v":-1},null,{"$f":"VLOOKUP(G39,Patio_Profile!$D$6:$G$17,3,FALSE)","v":-0.66666666666666663}]
["3-5","3-4",0,2,4.125,0.34375,{"$f":"VLOOKUP($B40,$A$11:$I1028,COLUMN(),FALSE)+C40","v":7.5},{"$f":"IF(RIGHT(A40,1)=\"0\",D40,VLOOKUP($B40,$A$11:$I1028,COLUMN(),FALSE)+D40)","v":12},{"$f":"IF(RIGHT(A40,1)=\"0\",K40,VLOOKUP($B40,$A$11:$I1028,COLUMN(),FALSE)+F40)","v":-0.65625},null,{"$f":"VLOOKUP(G40,Patio_Profile!$D$6:$G$17,3,FALSE)","v":-0.66666666666666663}]
["3-6","3-5",0,2,4.5,0.375,{"$f":"VLOOKUP($B41,$A$11:$I1029,COLUMN(),FALSE)+C41","v":7.5},{"$f":"IF(RIGHT(A41,1)=\"0\",D41,VLOOKUP($B41,$A$11:$I1029,COLUMN(),FALSE)+D41)","v":14},{"$f":"IF(RIGHT(A41,1)=\"0\",K41,VLOOKUP($B41,$A$11:$I1029,COLUMN(),FALSE)+F41)","v":-0.28125},null,{"$f":"VLOOKUP(G41,Patio_Profile!$D$6:$G$17,3,FALSE)","v":-0.66666666666666663}]
["3-7","3-6",0,2,3.875,0.32291666666666669,{"$f":"VLOOKUP($B42,$A$11:$I1030,COLUMN(),FALSE)+C42","v":7.5},{"$f":"IF(RIGHT(A42,1)=\"0\",D42,VLOOKUP($B42,$A$11:$I1030,COLUMN(),FALSE)+D42)","v":16},{"$f":"IF(RIGHT(A42,1)=\"0\",K42,VLOOKUP($B42,$A$11:$I1030,COLUMN(),FALSE)+F42)","v":4.1666666666666685E-2},null,{"$f":"VLOOKUP(G42,Patio_Profile!$D$6:$G$17,3,FALSE)","v":-0.66666666666666663}]
["4-0","3-7",2.5,2,0,0,{"$f":"VLOOKUP($B43,$A$11:$I1031,COLUMN(),FALSE)+C43","v":10},{"$f":"IF(RIGHT(A43,1)=\"0\",D43,VLOOKUP($B43,$A$11:$I1031,COLUMN(),FALSE)+D43)","v":2},{"$f":"IF(RIGHT(A43,1)=\"0\",K43,VLOOKUP($B43,$A$11:$I1031,COLUMN(),FALSE)+F43)","v":-1.1666666666666665},null,{"$f":"VLOOKUP(G43,Patio_Profile!$D$6:$G$17,3,FALSE)","v":-1.1666666666666665}]
["4-1","4-0",0,2,-2.5,-0.20833333333333334,{"$f":"VLOOKUP($B44,$A$11:$I1032,COLUMN(),FALSE)+C44","v":10},{"$f":"IF(RIGHT(A44,1)=\"0\",D44,VLOOKUP($B44,$A$11:$I1032,COLUMN(),FALSE)+D44)","v":4},{"$f":"IF(RIGHT(A44,1)=\"0\",K44,VLOOKUP($B44,$A$11:$I1032,COLUMN(),FALSE)+F44)","v":-1.3749999999999998},null,{"$f":"VLOOKUP(G44,Patio_Profile!$D$6:$G$17,3,FALSE)","v":-1.1666666666666665}]
["4-2","4-1",0,2,-1.5,-0.125,{"$f":"VLOOKUP($B45,$A$11:$I1033,COLUMN(),FALSE)+C45","v":10},{"$f":"IF(RIGHT(A45,1)=\"0\",D45,VLOOKUP($B45,$A$11:$I1033,COLUMN(),FALSE)+D45)","v":6},{"$f":"IF(RIGHT(A45,1)=\"0\",K45,VLOOKUP($B45,$A$11:$I1033,COLUMN(),FALSE)+F45)","v":-1.4999999999999998},null,{"$f":"VLOOKUP(G45,Patio_Profile!$D$6:$G$17,3,FALSE)","v":-1.1666666666666665}]
["4-3","4-2",0,2,0.25,2.0833333333333332E-2,{"$f":"VLOOKUP($B46,$A$11:$I1034,COLUMN(),FALSE)+C46","v":10},{"$f":"IF(RIGHT(A46,1)=\"0\",D46,VLOOKUP($B46,$A$11:$I1034,COLUMN(),FALSE)+D46)","v":8},{"$f":"IF(RIGHT(A46,1)=\"0\",K46,VLOOKUP($B46,$A$11:$I1034,COLUMN(),FALSE)+F46)","v":-1.4791666666666665},null,{"$f":"VLOOKUP(G46,Patio_Profile!$D$6:$G$17,3,FALSE)","v":-1.1666666666666665}]
["4-4","4-3",0,2,-1,-8.3333333333333329E-2,{"$f":"VLOOKUP($B47,$A$11:$I1035,COLUMN(),FALSE)+C47","v":10},{"$f":"IF(RIGHT(A47,1)=\"0\",D47,VLOOKUP($B47,$A$11:$I1035,COLUMN(),FALSE)+D47)","v":10},{"$f":"IF(RIGHT(A47,1)=\"0\",K47,VLOOKUP($B47,$A$11:$I1035,COLUMN(),FALSE)+F47)","v":-1.5624999999999998},null,{"$f":"VLOOKUP(G47,Patio_Profile!$D$6:$G$17,3,FALSE)","v":-1.1666666666666665}]
["4-5","4-4",0,2,3.25,0.27083333333333331,{"$f":"VLOOKUP($B48,$A$11:$I1036,COLUMN(),FALSE)+C48","v":10},{"$f":"IF(RIGHT(A48,1)=\"0\",D48,VLOOKUP($B48,$A$11:$I1036,COLUMN(),FALSE)+D48)","v":12},{"$f":"IF(RIGHT(A48,1)=\"0\",K48,VLOOKUP($B48,$A$11:$I1036,COLUMN(),FALSE)+F48)","v":-1.2916666666666665},null,{"$f":"VLOOKUP(G48,Patio_Profile!$D$6:$G$17,3,FALSE)","v":-1.1666666666666665}]
["4-6","4-5",0,2,5.125,0.42708333333333331,{"$f":"VLOOKUP($B49,$A$11:$I1037,COLUMN(),FALSE)+C49","v":10},{"$f":"IF(RIGHT(A49,1)=\"0\",D49,VLOOKUP($B49,$A$11:$I1037,COLUMN(),FALSE)+D49)","v":14},{"$f":"IF(RIGHT(A49,1)=\"0\",K49,VLOOKUP($B49,$A$11:$I1037,COLUMN(),FALSE)+F49)","v":-0.86458333333333326},null,{"$f":"VLOOKUP(G49,Patio_Profile!$D$6:$G$17,3,FALSE)","v":-1.1666666666666665}]
["4-7","4-6",0,2,3.875,0.32291666666666669,{"$f":"VLOOKUP($B50,$A$11:$I1038,COLUMN(),FALSE)+C50","v":10},{"$f":"IF(RIGHT(A50,1)=\"0\",D50,VLOOKUP($B50,$A$11:$I1038,COLUMN(),FALSE)+D50)","v":16},{"$f":"IF(RIGHT(A50,1)=\"0\",K50,VLOOKUP($B50,$A$11:$I1038,COLUMN(),FALSE)+F50)","v":-0.54166666666666652},null,{"$f":"VLOOKUP(G50,Patio_Profile!$D$6:$G$17,3,FALSE)","v":-1.1666666666666665}]
["5-0","4-7",2.5,2,0,0,{"$f":"VLOOKUP($B51,$A$11:$I1039,COLUMN(),FALSE)+C51","v":12.5},{"$f":"IF(RIGHT(A51,1)=\"0\",D51,VLOOKUP($B51,$A$11:$I1039,COLUMN(),FALSE)+D51)","v":2},{"$f":"IF(RIGHT(A51,1)=\"0\",K51,VLOOKUP($B51,$A$11:$I1039,COLUMN(),FALSE)+F51)","v":-1.6666666666666665},null,{"$f":"VLOOKUP(G51,Patio_Profile!$D$6:$G$17,3,FALSE)","v":-1.6666666666666665}]
["5-1","5-0",0,2,-4.5,-0.375,{"$f":"VLOOKUP($B52,$A$11:$I1040,COLUMN(),FALSE)+C52","v":12.5},{"$f":"IF(RIGHT(A52,1)=\"0\",D52,VLOOKUP($B52,$A$11:$I1040,COLUMN(),FALSE)+D52)","v":4},{"$f":"IF(RIGHT(A52,1)=\"0\",K52,VLOOKUP($B52,$A$11:$I1040,COLUMN(),FALSE)+F52)","v":-2.0416666666666665},null,{"$f":"VLOOKUP(G52,Patio_Profile!$D$6:$G$17,3,FALSE)","v":-1.6666666666666665}]
["5-2","5-1",0,2,-2.25,-0.1875,{"$f":"VLOOKUP($B53,$A$11:$I1041,COLUMN(),FALSE)+C53","v":12.5},{"$f":"IF(RIGHT(A53,1)=\"0\",D53,VLOOKUP($B53,$A$11:$I1041,COLUMN(),FALSE)+D53)","v":6},{"$f":"IF(RIGHT(A53,1)=\"0\",K53,VLOOKUP($B53,$A$11:$I1041,COLUMN(),FALSE)+F53)","v":-2.2291666666666665},null,{"$f":"VLOOKUP(G53,Patio_Profile!$D$6:$G$17,3,FALSE)","v":-1.6666666666666665}]
["5-3","5-2",0,2,-1,-8.3333333333333329E-2,{"$f":"VLOOKUP($B54,$A$11:$I1042,COLUMN(),FALSE)+C54","v":12.5},{"$f":"IF(RIGHT(A54,1)=\"0\",D54,VLOOKUP($B54,$A$11:$I1042,COLUMN(),FALSE)+D54)","v":8},{"$f":"IF(RIGHT(A54,1)=\"0\",K54,VLOOKUP($B54,$A$11:$I1042,COLUMN(),FALSE)+F54)","v":-2.3125},null,{"$f":"VLOOKUP(G54,Patio_Profile!$D$6:$G$17,3,FALSE)","v":-1.6666666666666665}]
["5-4","5-3",0,2,1.25,0.10416666666666667,{"$f":"VLOOKUP($B55,$A$11:$I1043,COLUMN(),FALSE)+C55","v":12.5},{"$f":"IF(RIGHT(A55,1)=\"0\",D55,VLOOKUP($B55,$A$11:$I1043,COLUMN(),FALSE)+D55)","v":10},{"$f":"IF(RIGHT(A55,1)=\"0\",K55,VLOOKUP($B55,$A$11:$I1043,COLUMN(),FALSE)+F55)","v":-2.2083333333333335},null,{"$f":"VLOOKUP(G55,Patio_Profile!$D$6:$G$17,3,FALSE)","v":-1.6666666666666665}]
["5-5","5-4",0,2,4.5,0.375,{"$f":"VLOOKUP($B56,$A$11:$I1044,COLUMN(),FALSE)+C56","v":12.5},{"$f":"IF(RIGHT(A56,1)=\"0\",D56,VLOOKUP($B56,$A$11:$I1044,COLUMN(),FALSE)+D56)","v":12},{"$f":"IF(RIGHT(A56,1)=\"0\",K56,VLOOKUP($B56,$A$11:$I1044,COLUMN(),FALSE)+F56)","v":-1.8333333333333335},null,{"$f":"VLOOKUP(G56,Patio_Profile!$D$6:$G$17,3,FALSE)","v":-1.6666666666666665}]
["5-6","5-5",0,2,5.25,0.4375,{"$f":"VLOOKUP($B57,$A$11:$I1045,COLUMN(),FALSE)+C57","v":12.5},{"$f":"IF(RIGHT(A57,1)=\"0\",D57,VLOOKUP($B57,$A$11:$I1045,COLUMN(),FALSE)+D57)","v":14},{"$f":"IF(RIGHT(A57,1)=\"0\",K57,VLOOKUP($B57,$A$11:$I1045,COLUMN(),FALSE)+F57)","v":-1.3958333333333335},null,{"$f":"VLOOKUP(G57,Patio_Profile!$D$6:$G$17,3,FALSE)","v":-1.6666666666666665}]
["5-7","5-6",0,2,4.25,0.35416666666666669,{"$f":"VLOOKUP($B58,$A$11:$I1046,COLUMN(),FALSE)+C58","v":12.5},{"$f":"IF(RIGHT(A58,1)=\"0\",D58,VLOOKUP($B58,$A$11:$I1046,COLUMN(),FALSE)+D58)","v":16},{"$f":"IF(RIGHT(A58,1)=\"0\",K58,VLOOKUP($B58,$A$11:$I1046,COLUMN(),FALSE)+F58)","v":-1.0416666666666667},null,{"$f":"VLOOKUP(G58,Patio_Profile!$D$6:$G$17,3,FALSE)","v":-1.6666666666666665}]
["6-0","5-7",2.5,2,0,0,{"$f":"VLOOKUP($B59,$A$11:$I1047,COLUMN(),FALSE)+C59","v":15},{"$f":"IF(RIGHT(A59,1)=\"0\",D59,VLOOKUP($B59,$A$11:$I1047,COLUMN(),FALSE)+D59)","v":2},{"$f":"IF(RIGHT(A59,1)=\"0\",K59,VLOOKUP($B59,$A$11:$I1047,COLUMN(),FALSE)+F59)","v":-1.8541666666666665},null,{"$f":"VLOOKUP(G59,Patio_Profile!$D$6:$G$17,3,FALSE)","v":-1.8541666666666665}]
["6-1","6-0",0,2,-3.5,-0.29166666666666669,{"$f":"VLOOKUP($B60,$A$11:$I1048,COLUMN(),FALSE)+C60","v":15},{"$f":"IF(RIGHT(A60,1)=\"0\",D60,VLOOKUP($B60,$A$11:$I1048,COLUMN(),FALSE)+D60)","v":4},{"$f":"IF(RIGHT(A60,1)=\"0\",K60,VLOOKUP($B60,$A$11:$I1048,COLUMN(),FALSE)+F60)","v":-2.145833333333333},null,{"$f":"VLOOKUP(G60,Patio_Profile!$D$6:$G$17,3,FALSE)","v":-1.8541666666666665}]
["6-2","6-1",0,2,-2,-0.16666666666666666,{"$f":"VLOOKUP($B61,$A$11:$I1049,COLUMN(),FALSE)+C61","v":15},{"$f":"IF(RIGHT(A61,1)=\"0\",D61,VLOOKUP($B61,$A$11:$I1049,COLUMN(),FALSE)+D61)","v":6},{"$f":"IF(RIGHT(A61,1)=\"0\",K61,VLOOKUP($B61,$A$11:$I1049,COLUMN(),FALSE)+F61)","v":-2.3124999999999996},null,{"$f":"VLOOKUP(G61,Patio_Profile!$D$6:$G$17,3,FALSE)","v":-1.8541666666666665}]
["6-3","6-2",0,2,-0.5,-4.1666666666666664E-2,{"$f":"VLOOKUP($B62,$A$11:$I1050,COLUMN(),FALSE)+C62","v":15},{"$f":"IF(RIGHT(A62,1)=\"0\",D62,VLOOKUP($B62,$A$11:$I1050,COLUMN(),FALSE)+D62)","v":8},{"$f":"IF(RIGHT(A62,1)=\"0\",K62,VLOOKUP($B62,$A$11:$I1050,COLUMN(),FALSE)+F62)","v":-2.3541666666666661},null,{"$f":"VLOOKUP(G62,Patio_Profile!$D$6:$G$17,3,FALSE)","v":-1.8541666666666665}]
["6-4","6-3",0,2,0,0,{"$f":"VLOOKUP($B63,$A$11:$I1051,COLUMN(),FALSE)+C63","v":15},{"$f":"IF(RIGHT(A63,1)=\"0\",D63,VLOOKUP($B63,$A$11:$I1051,COLUMN(),FALSE)+D63)","v":10},{"$f":"IF(RIGHT(A63,1)=\"0\",K63,VLOOKUP($B63,$A$11:$I1051,COLUMN(),FALSE)+F63)","v":-2.3541666666666661},null,{"$f":"VLOOKUP(G63,Patio_Profile!$D$6:$G$17,3,FALSE)","v":-1.8541666666666665}]
["6-5","6-4",0,2,3.875,0.32291666666666669,{"$f":"VLOOKUP($B64,$A$11:$I1052,COLUMN(),FALSE)+C64","v":15},{"$f":"IF(RIGHT(A64,1)=\"0\",D64,VLOOKUP($B64,$A$11:$I1052,COLUMN(),FALSE)+D64)","v":12},{"$f":"IF(RIGHT(A64,1)=\"0\",K64,VLOOKUP($B64,$A$11:$I1052,COLUMN(),FALSE)+F64)","v":-2.0312499999999996},null,{"$f":"VLOOKUP(G64,Patio_Profile!$D$6:$G$17,3,FALSE)","v":-1.8541666666666665}]
["6-6","6-5",0,2,5.375,0.44791666666666669,{"$f":"VLOOKUP($B65,$A$11:$I1053,COLUMN(),FALSE)+C65","v":15},{"$f":"IF(RIGHT(A65,1)=\"0\",D65,VLOOKUP($B65,$A$11:$I1053,COLUMN(),FALSE)+D65)","v":14},{"$f":"IF(RIGHT(A65,1)=\"0\",K65,VLOOKUP($B65,$A$11:$I1053,COLUMN(),FALSE)+F65)","v":-1.5833333333333328},null,{"$f":"VLOOKUP(G65,Patio_Profile!$D$6:$G$17,3,FALSE)","v":-1.8541666666666665}]
["6-7","6-6",0,2,3.875,0.32291666666666669,{"$f":"VLOOKUP($B66,$A$11:$I1054,COLUMN(),FALSE)+C66","v":15},{"$f":"IF(RIGHT(A66,1)=\"0\",D66,VLOOKUP($B66,$A$11:$I1054,COLUMN(),FALSE)+D66)","v":16},{"$f":"IF(RIGHT(A66,1)=\"0\",K66,VLOOKUP($B66,$A$11:$I1054,COLUMN(),FALSE)+F66)","v":-1.2604166666666661},null,{"$f":"VLOOKUP(G66,Patio_Profile!$D$6:$G$17,3,FALSE)","v":-1.8541666666666665}]
["7-0","6-7",2.5,2,0,0,{"$f":"VLOOKUP($B67,$A$11:$I1055,COLUMN(),FALSE)+C67","v":17.5},{"$f":"IF(RIGHT(A67,1)=\"0\",D67,VLOOKUP($B67,$A$11:$I1055,COLUMN(),FALSE)+D67)","v":2},{"$f":"IF(RIGHT(A67,1)=\"0\",K67,VLOOKUP($B67,$A$11:$I1055,COLUMN(),FALSE)+F67)","v":-2.125},null,{"$f":"VLOOKUP(G67,Patio_Profile!$D$6:$G$17,3,FALSE)","v":-2.125}]
["7-1","7-0",0,2,-3.25,-0.27083333333333331,{"$f":"VLOOKUP($B68,$A$11:$I1056,COLUMN(),FALSE)+C68","v":17.5},{"$f":"IF(RIGHT(A68,1)=\"0\",D68,VLOOKUP($B68,$A$11:$I1056,COLUMN(),FALSE)+D68)","v":4},{"$f":"IF(RIGHT(A68,1)=\"0\",K68,VLOOKUP($B68,$A$11:$I1056,COLUMN(),FALSE)+F68)","v":-2.3958333333333335},null,{"$f":"VLOOKUP(G68,Patio_Profile!$D$6:$G$17,3,FALSE)","v":-2.125}]
["7-2","7-1",0,2,-3,-0.25,{"$f":"VLOOKUP($B69,$A$11:$I1057,COLUMN(),FALSE)+C69","v":17.5},{"$f":"IF(RIGHT(A69,1)=\"0\",D69,VLOOKUP($B69,$A$11:$I1057,COLUMN(),FALSE)+D69)","v":6},{"$f":"IF(RIGHT(A69,1)=\"0\",K69,VLOOKUP($B69,$A$11:$I1057,COLUMN(),FALSE)+F69)","v":-2.6458333333333335},null,{"$f":"VLOOKUP(G69,Patio_Profile!$D$6:$G$17,3,FALSE)","v":-2.125}]
["7-3","7-2",0,2,-0.25,-2.0833333333333332E-2,{"$f":"VLOOKUP($B70,$A$11:$I1058,COLUMN(),FALSE)+C70","v":17.5},{"$f":"IF(RIGHT(A70,1)=\"0\",D70,VLOOKUP($B70,$A$11:$I1058,COLUMN(),FALSE)+D70)","v":8},{"$f":"IF(RIGHT(A70,1)=\"0\",K70,VLOOKUP($B70,$A$11:$I1058,COLUMN(),FALSE)+F70)","v":-2.666666666666667},null,{"$f":"VLOOKUP(G70,Patio_Profile!$D$6:$G$17,3,FALSE)","v":-2.125}]
["7-4","7-3",0,2,1.25,0.10416666666666667,{"$f":"VLOOKUP($B71,$A$11:$I1059,COLUMN(),FALSE)+C71","v":17.5},{"$f":"IF(RIGHT(A71,1)=\"0\",D71,VLOOKUP($B71,$A$11:$I1059,COLUMN(),FALSE)+D71)","v":10},{"$f":"IF(RIGHT(A71,1)=\"0\",K71,VLOOKUP($B71,$A$11:$I1059,COLUMN(),FALSE)+F71)","v":-2.5625000000000004},null,{"$f":"VLOOKUP(G71,Patio_Profile!$D$6:$G$17,3,FALSE)","v":-2.125}]
["7-5","7-4",0,2,4.625,0.38541666666666669,{"$f":"VLOOKUP($B72,$A$11:$I1060,COLUMN(),FALSE)+C72","v":17.5},{"$f":"IF(RIGHT(A72,1)=\"0\",D72,VLOOKUP($B72,$A$11:$I1060,COLUMN(),FALSE)+D72)","v":12},{"$f":"IF(RIGHT(A72,1)=\"0\",K72,VLOOKUP($B72,$A$11:$I1060,COLUMN(),FALSE)+F72)","v":-2.1770833333333339},null,{"$f":"VLOOKUP(G72,Patio_Profile!$D$6:$G$17,3,FALSE)","v":-2.125}]
["7-6","7-5",0,2,5.125,0.42708333333333331,{"$f":"VLOOKUP($B73,$A$11:$I1061,COLUMN(),FALSE)+C73","v":17.5},{"$f":"IF(RIGHT(A73,1)=\"0\",D73,VLOOKUP($B73,$A$11:$I1061,COLUMN(),FALSE)+D73)","v":14},{"$f":"IF(RIGHT(A73,1)=\"0\",K73,VLOOKUP($B73,$A$11:$I1061,COLUMN(),FALSE)+F73)","v":-1.7500000000000007},null,{"$f":"VLOOKUP(G73,Patio_Profile!$D$6:$G$17,3,FALSE)","v":-2.125}]
["7-7","7-6",0,2,3.875,0.32291666666666669,{"$f":"VLOOKUP($B74,$A$11:$I1062,COLUMN(),FALSE)+C74","v":17.5},{"$f":"IF(RIGHT(A74,1)=\"0\",D74,VLOOKUP($B74,$A$11:$I1062,COLUMN(),FALSE)+D74)","v":16},{"$f":"IF(RIGHT(A74,1)=\"0\",K74,VLOOKUP($B74,$A$11:$I1062,COLUMN(),FALSE)+F74)","v":-1.4270833333333339},null,{"$f":"VLOOKUP(G74,Patio_Profile!$D$6:$G$17,3,FALSE)","v":-2.125}]
["8-0","7-7",2.5,2,0,0,{"$f":"VLOOKUP($B75,$A$11:$I1063,COLUMN(),FALSE)+C75","v":20},{"$f":"IF(RIGHT(A75,1)=\"0\",D75,VLOOKUP($B75,$A$11:$I1063,COLUMN(),FALSE)+D75)","v":2},{"$f":"IF(RIGHT(A75,1)=\"0\",K75,VLOOKUP($B75,$A$11:$I1063,COLUMN(),FALSE)+F75)","v":-2.5416666666666665},null,{"$f":"VLOOKUP(G75,Patio_Profile!$D$6:$G$17,3,FALSE)","v":-2.5416666666666665}]
["8-1","8-0",0,2,-5.75,-0.47916666666666669,{"$f":"VLOOKUP($B76,$A$11:$I1064,COLUMN(),FALSE)+C76","v":20},{"$f":"IF(RIGHT(A76,1)=\"0\",D76,VLOOKUP($B76,$A$11:$I1064,COLUMN(),FALSE)+D76)","v":4},{"$f":"IF(RIGHT(A76,1)=\"0\",K76,VLOOKUP($B76,$A$11:$I1064,COLUMN(),FALSE)+F76)","v":-3.020833333333333},null,{"$f":"VLOOKUP(G76,Patio_Profile!$D$6:$G$17,3,FALSE)","v":-2.5416666666666665}]
["8-2",{"$f":"A76","v":"8-1"},0,2,-3.25,{"$f":"E77/12","v":-0.27083333333333331},{"$f":"VLOOKUP($B77,$A$11:$I1065,COLUMN(),FALSE)+C77","v":20},{"$f":"IF(RIGHT(A77,1)=\"0\",D77,VLOOKUP($B77,$A$11:$I1065,COLUMN(),FALSE)+D77)","v":6},{"$f":"IF(RIGHT(A77,1)=\"0\",K77,VLOOKUP($B77,$A$11:$I1065,COLUMN(),FALSE)+F77)","v":-3.2916666666666665},null,{"$f":"VLOOKUP(G77,Patio_Profile!$D$6:$G$17,3,FALSE)","v":-2.5416666666666665}]
["8-3","8-2",0,2,0,0,{"$f":"VLOOKUP($B78,$A$11:$I1066,COLUMN(),FALSE)+C78","v":20},{"$f":"IF(RIGHT(A78,1)=\"0\",D78,VLOOKUP($B78,$A$11:$I1066,COLUMN(),FALSE)+D78)","v":8},{"$f":"IF(RIGHT(A78,1)=\"0\",K78,VLOOKUP($B78,$A$11:$I1066,COLUMN(),FALSE)+F78)","v":-3.2916666666666665},null,{"$f":"VLOOKUP(G78,Patio_Profile!$D$6:$G$17,3,FALSE)","v":-2.5416666666666665}]
["8-4","8-3",0,2,1.75,0.14583333333333334,{"$f":"VLOOKUP($B79,$A$11:$I1067,COLUMN(),FALSE)+C79","v":20},{"$f":"IF(RIGHT(A79,1)=\"0\",D79,VLOOKUP($B79,$A$11:$I1067,COLUMN(),FALSE)+D79)","v":10},{"$f":"IF(RIGHT(A79,1)=\"0\",K79,VLOOKUP($B79,$A$11:$I1067,COLUMN(),FALSE)+F79)","v":-3.145833333333333},null,{"$f":"VLOOKUP(G79,Patio_Profile!$D$6:$G$17,3,FALSE)","v":-2.5416666666666665}]
["8-5","8-4",0,2,4.5,0.375,{"$f":"VLOOKUP($B80,$A$11:$I1068,COLUMN(),FALSE)+C80","v":20},{"$f":"IF(RIGHT(A80,1)=\"0\",D80,VLOOKUP($B80,$A$11:$I1068,COLUMN(),FALSE)+D80)","v":12},{"$f":"IF(RIGHT(A80,1)=\"0\",K80,VLOOKUP($B80,$A$11:$I1068,COLUMN(),FALSE)+F80)","v":-2.770833333333333},null,{"$f":"VLOOKUP(G80,Patio_Profile!$D$6:$G$17,3,FALSE)","v":-2.5416666666666665}]
["8-6","8-5",0,2,5,0.41666666666666669,{"$f":"VLOOKUP($B81,$A$11:$I1069,COLUMN(),FALSE)+C81","v":20},{"$f":"IF(RIGHT(A81,1)=\"0\",D81,VLOOKUP($B81,$A$11:$I1069,COLUMN(),FALSE)+D81)","v":14},{"$f":"IF(RIGHT(A81,1)=\"0\",K81,VLOOKUP($B81,$A$11:$I1069,COLUMN(),FALSE)+F81)","v":-2.3541666666666665},null,{"$f":"VLOOKUP(G81,Patio_Profile!$D$6:$G$17,3,FALSE)","v":-2.5416666666666665}]
["8-7","8-6",0,2,4.25,0.35416666666666669,{"$f":"VLOOKUP($B82,$A$11:$I1070,COLUMN(),FALSE)+C82","v":20},{"$f":"IF(RIGHT(A82,1)=\"0\",D82,VLOOKUP($B82,$A$11:$I1070,COLUMN(),FALSE)+D82)","v":16},{"$f":"IF(RIGHT(A82,1)=\"0\",K82,VLOOKUP($B82,$A$11:$I1070,COLUMN(),FALSE)+F82)","v":-1.9999999999999998},null,{"$f":"VLOOKUP(G82,Patio_Profile!$D$6:$G$17,3,FALSE)","v":-2.5416666666666665}]
["9-0","8-7",2.5,2,0,0,{"$f":"VLOOKUP($B83,$A$11:$I1071,COLUMN(),FALSE)+C83","v":22.5},{"$f":"IF(RIGHT(A83,1)=\"0\",D83,VLOOKUP($B83,$A$11:$I1071,COLUMN(),FALSE)+D83)","v":2},{"$f":"IF(RIGHT(A83,1)=\"0\",K83,VLOOKUP($B83,$A$11:$I1071,COLUMN(),FALSE)+F83)","v":-2.8541666666666665},null,{"$f":"VLOOKUP(G83,Patio_Profile!$D$6:$G$17,3,FALSE)","v":-2.8541666666666665}]
["9-1","9-0",0,2,-3.75,-0.3125,{"$f":"VLOOKUP($B84,$A$11:$I1072,COLUMN(),FALSE)+C84","v":22.5},{"$f":"IF(RIGHT(A84,1)=\"0\",D84,VLOOKUP($B84,$A$11:$I1072,COLUMN(),FALSE)+D84)","v":4},{"$f":"IF(RIGHT(A84,1)=\"0\",K84,VLOOKUP($B84,$A$11:$I1072,COLUMN(),FALSE)+F84)","v":-3.1666666666666665},null,{"$f":"VLOOKUP(G84,Patio_Profile!$D$6:$G$17,3,FALSE)","v":-2.8541666666666665}]
["9-2","9-1",0,2,-2.5,-0.20833333333333334,{"$f":"VLOOKUP($B85,$A$11:$I1073,COLUMN(),FALSE)+C85","v":22.5},{"$f":"IF(RIGHT(A85,1)=\"0\",D85,VLOOKUP($B85,$A$11:$I1073,COLUMN(),FALSE)+D85)","v":6},{"$f":"IF(RIGHT(A85,1)=\"0\",K85,VLOOKUP($B85,$A$11:$I1073,COLUMN(),FALSE)+F85)","v":-3.375},null,{"$f":"VLOOKUP(G85,Patio_Profile!$D$6:$G$17,3,FALSE)","v":-2.8541666666666665}]
["9-3","9-2",0,2,0,0,{"$f":"VLOOKUP($B86,$A$11:$I1074,COLUMN(),FALSE)+C86","v":22.5},{"$f":"IF(RIGHT(A86,1)=\"0\",D86,VLOOKUP($B86,$A$11:$I1074,COLUMN(),FALSE)+D86)","v":8},{"$f":"IF(RIGHT(A86,1)=\"0\",K86,VLOOKUP($B86,$A$11:$I1074,COLUMN(),FALSE)+F86)","v":-3.375},null,{"$f":"VLOOKUP(G86,Patio_Profile!$D$6:$G$17,3,FALSE)","v":-2.8541666666666665}]
["9-4","9-3",0,2,1.75,0.14583333333333334,{"$f":"VLOOKUP($B87,$A$11:$I1075,COLUMN(),FALSE)+C87","v":22.5},{"$f":"IF(RIGHT(A87,1)=\"0\",D87,VLOOKUP($B87,$A$11:$I1075,COLUMN(),FALSE)+D87)","v":10},{"$f":"IF(RIGHT(A87,1)=\"0\",K87,VLOOKUP($B87,$A$11:$I1075,COLUMN(),FALSE)+F87)","v":-3.2291666666666665},null,{"$f":"VLOOKUP(G87,Patio_Profile!$D$6:$G$17,3,FALSE)","v":-2.8541666666666665}]
["9-5","9-4",0,2,4.5,0.375,{"$f":"VLOOKUP($B88,$A$11:$I1076,COLUMN(),FALSE)+C88","v":22.5},{"$f":"IF(RIGHT(A88,1)=\"0\",D88,VLOOKUP($B88,$A$11:$I1076,COLUMN(),FALSE)+D88)","v":12},{"$f":"IF(RIGHT(A88,1)=\"0\",K88,VLOOKUP($B88,$A$11:$I1076,COLUMN(),FALSE)+F88)","v":-2.8541666666666665},null,{"$f":"VLOOKUP(G88,Patio_Profile!$D$6:$G$17,3,FALSE)","v":-2.8541666666666665}]
["9-6","9-5",0,2,5,0.41666666666666669,{"$f":"VLOOKUP($B89,$A$11:$I1077,COLUMN(),FALSE)+C89","v":22.5},{"$f":"IF(RIGHT(A89,1)=\"0\",D89,VLOOKUP($B89,$A$11:$I1077,COLUMN(),FALSE)+D89)","v":14},{"$f":"IF(RIGHT(A89,1)=\"0\",K89,VLOOKUP($B89,$A$11:$I1077,COLUMN(),FALSE)+F89)","v":-2.4375},null,{"$f":"VLOOKUP(G89,Patio_Profile!$D$6:$G$17,3,FALSE)","v":-2.8541666666666665}]
["9-7","9-6",0,2,5,0.41666666666666669,{"$f":"VLOOKUP($B90,$A$11:$I1078,COLUMN(),FALSE)+C90","v":22.5},{"$f":"IF(RIGHT(A90,1)=\"0\",D90,VLOOKUP($B90,$A$11:$I1078,COLUMN(),FALSE)+D90)","v":16},{"$f":"IF(RIGHT(A90,1)=\"0\",K90,VLOOKUP($B90,$A$11:$I1078,COLUMN(),FALSE)+F90)","v":-2.0208333333333335},null,{"$f":"VLOOKUP(G90,Patio_Profile!$D$6:$G$17,3,FALSE)","v":-2.8541666666666665}]

{"sheet":"Patio_Profile","index":1,"n_rows":17,"n_cols":15,"rows_kept":17,"cut":false,"hidden":false,"merged":[]}
[]
[null,null,null,null,null,null,null,null,null,null,null,null,null,1,{"$f":"N2/8","v":0.125}]
[null,null,null,null,null,null,null,null,null,null,null,null,null,2,{"$f":"N3/8","v":0.25}]
[null,null,null,null,null,null,null,null,null,null,null,null,null,3,0.375]
["Point","Distance (in)","Vertical Offset (in)","Total Distance (ft)","Vertical Offset (ft)","Elevation","Slope to Next (%)",null,null,null,null,null,null,4,0.5]
["Patio_East",0,0,0,0,{"$f":"Sheet1!J4","v":0},{"$f":"(E7-E6)/(D7-D6)","v":-3.3333333333333333E-2},null,null,null,null,null,null,5,0.625]
["A",30,-1,{"$f":"D6+(B7/12)","v":2.5},{"$f":"E6+(C7/12)","v":-8.3333333333333329E-2},{"$f":"F6+E7","v":-8.3333333333333329E-2},{"$f":"(E8-E7)/(D8-D7)","v":-4.583333333333333E-2},null,null,null,null,null,null,6,0.75]
["B",30,-1.375,{"$f":"D7+(B8/12)","v":5},{"$f":"E7+(C8/12)","v":-0.19791666666666666},{"$f":"F7+E8","v":-0.28125},-7.4999999999999983E-2,null,null,null,null,null,null,7,0.875]
["C",30,-2.25,7.5,-0.38541666666666663,{"$f":"F8+E9","v":-0.66666666666666663},-4.5833333333333323E-2,null,null,null,null,null,null,8,1]
["D",30,-1.375,10,-0.49999999999999994,-1.1666666666666665,0]
["E",30,0,12.5,-0.49999999999999994,-1.6666666666666665,0.125]
["F",30,3.75,15,-0.18749999999999994,-1.8541666666666665,-3.3333333333333326E-2]
["G",30,-1,17.5,-0.27083333333333326,-2.125,-5.8333333333333348E-2]
["H",30,-1.75,20,-0.41666666666666663,-2.5416666666666665,4.1666666666666671E-2]
["I",30,1.25,22.5,-0.31249999999999994,-2.8541666666666665,-6.25E-2]
["J",30,-1.875,25,-0.46874999999999994,-3.3229166666666665,5.8333333333333327E-2]
["K",30,1.75,27.5,-0.32291666666666663,-3.645833333333333,-1.1742424242424242E-2]

{"sheet":"Trench","index":2,"n_rows":16,"n_cols":6,"rows_kept":16,"cut":false,"hidden":false,"merged":[[4,1,4,5],[4,0,5,0]]}
[]
[]
["Trench Points"]
[]
["X","Y"]
[null,"Feet","Inches","Num","Denom","Dec. Feet"]
[0,4,10,null,null,{"$f":"(((IF(E7=0,0,D7/E7)+C7)/12)+B7)","v":4.833333333333333}]
[2.5,4,10,1,2,{"$f":"(((IF(E8=0,0,D8/E8)+C8)/12)+B8)","v":4.875}]
[5,5,1,null,null,5.083333333333333]
[7.5,5,null,1,2,5.041666666666667]
[10,5,null,null,null,5]
[12.5,5,null,null,null,5]
[15,5,null,1,2,5.041666666666667]
[17.5,4,11,null,null,4.916666666666667]
[20,4,11,null,null,4.916666666666667]
[22.5,4,10,null,null,4.833333333333333]