{"text_format":"1","workbook":"xlsx","n_sheets":3,"sheets":["Sample","Regression","Valuation"],"not_rendered":{"charts":4,"images":0,"macros":1,"external_links":0,"defined_names":1,"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":"Sample","index":0,"n_rows":41,"n_cols":17,"rows_kept":41,"cut":false,"hidden":false,"merged":[[40,2,40,9],[1,2,2,13],[36,1,39,1],[36,2,36,9],[37,2,37,9],[38,2,38,9],[39,2,39,9],[0,4,0,10],[3,8,4,8],[3,9,4,9],[3,10,4,10],[2,16,3,21]]}
[]
[null,null,{"$f":"Valuation!D6","v":"ABC Plumbing Company"}]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Data Entry Instructions"]
[null,null,"Selling",null,"Gross",null,"Cash Flow",null,"Inventory                                (e)","Fixtures                                (f)","SDE%                   d  ÷  c",null,"Revenue","Cash Flow"]
[null,null,"Price                         (b)",null,"Revenues                     (c)",null,"(SDE)                    (d)",null,null,null,null,null,"Multiplier                          b  ÷  c","Multiplier                       b  ÷  d",null,null,"1)  Enter Comparable data in appropriate columns"]
[null,1,860000.14,null,1415000.14,null,214000.14,null,10000,10000,{"$f":"IF(G6=0,\"\",ROUND(G6/E6,3))","v":0.151},null,{"$f":"IF(C6=0,\"\",ROUND(C6/E6,2))","v":0.61},{"$f":"IF(G6=0,\"\",ROUND(C6/G6,2))","v":4.0199999999999996},null,null,"2)  Click \"HIDE\" or \"SHOW\"  buttons as desired."]
[null,2,665000.04,null,730242.04,null,125887.03999999999,null,50000,565000,{"$f":"IF(G7=0,\"\",ROUND(G7/E7,3))","v":0.17199999999999999},null,{"$f":"IF(C7=0,\"\",ROUND(C7/E7,2))","v":0.91},{"$f":"IF(G7=0,\"\",ROUND(C7/G7,2))","v":5.28}]
[null,3,450000.05,null,785955.05,null,153143.04999999999,null,136502,132104,0.19500000000000001,null,0.56999999999999995,2.94,null,null,"3)  Click \"SORT BY SDE%\"  button"]
[null,4,995000.18,null,1673000.18,null,329000.18,null,651000,125000,0.19700000000000001,null,0.59,3.02]
[null,5,1120000.17,null,1629000.17,null,330000.17,null,700000,20000,0.20300000000000001,null,0.69,3.39,null,null,"4)  GO TO the  \"REGRESSION\"   worksheet"]
[null,6,550000.03,null,662242.03,null,147272.03,null,15000,110000,0.222,null,0.83,3.73,null,null,"     Click on \"REFORMAT CHARTS\" button at top of worksheet."]
[null,7,708891.15,null,1495046.15,null,367516.15,null,163837,72612,0.246,null,0.47,1.93,null,null,"     Click \"Revenue Curved\"  or  \"Cash Flow Curved\" buttons as desired."]
[null,8,750000.08,null,908000.08,null,228000.08,null,7808,16191,0.251,null,0.83,3.29]
[null,9,520000.02,null,538871.02,null,141459.01999999999,null,3705,231060,0.26300000000000001,null,0.96,3.68,null,null,"5)  GO TO the   \"VALUATION\"   worksheet and enter in your company's data."]
[null,10,1330000.1599999999,null,1600000.16,null,439000.16,null,125000,1100000,0.27400000000000002,null,0.83,3.03]
[null,11,750000.06,null,807000.06,null,237000.06,null,400000,100000,0.29399999999999998,null,0.93,3.16]
[null,12,340000.01,null,501995.01,null,161998.01,null,71577,148422,0.32300000000000001,null,0.68,2.1]
[null,13,565000.12,null,1135715.1200000001,null,383368.12,null,31889,234650,0.33800000000000002,null,0.5,1.47]
[null,14,1025000.1,null,966576.1,null,329544.09999999998,null,24144,50066,0.34100000000000003,null,1.06,3.11]
[null,15,1576466.13,null,1232034.1299999999,null,527550.13,null,194558,403433,0.42799999999999999,null,1.28,2.99]
[null,16,885000.07,null,830000.07,null,375000.07,null,400000,100000,0.45200000000000001,null,1.07,2.36]
[null,17,1320000.1100000001,null,1079000.1100000001,null,490000.11,null,215000,22000,0.45400000000000001,null,1.22,2.69]
[null,18,1300000.0900000001,null,910000.09,null,439000.09,null,195212,404787,0.48199999999999998,null,1.43,2.96]
[null,19,null,null,null,null,null,null,null,null,"",null,"",""]
[null,20,null,null,null,null,null,null,null,null,"",null,"",""]
[null,21,null,null,null,null,null,null,null,null,"",null,"",""]
[null,22,null,null,null,null,null,null,null,null,"",null,"",""]
[null,23,null,null,null,null,null,null,null,null,"",null,"",""]
[null,24,null,null,null,null,null,null,null,null,"",null,"",""]
[null,25,null,null,null,null,null,null,null,null,"",null,"",""]
[null,26,null,null,null,null,null,null,null,null,"",null,"",""]
[null,27,null,null,null,null,null,null,null,null,"",null,"",""]
[null,28,null,null,null,null,null,null,null,null,"",null,"",""]
[null,29,null,null,null,null,null,null,null,null,"",null,"",""]
[null,30,null,null,null,null,null,null,null,null,"",null,"",""]
[null,"Avg =",{"$f":"AVERAGE(IF(C6:C35=0,\"\",C6:C35))","v":872797.70611111121},null,{"$f":"AVERAGE(IF(E6:E35=0,\"\",E6:E35))","v":1049982.095},null,{"$f":"AVERAGE(IF(G6:G35=0,\"\",G6:G35))","v":301041.03944444447},null,{"$f":"AVERAGE(IF(I6:I35=0,\"\",I6:I35))","v":188624},{"$f":"AVERAGE(IF(J6:J35=0,\"\",J6:J35))","v":213629.16666666666},"SDE % Range",null,"Revenue Mult Range","Cash Flow Mult Range"]
[null,null,"Lower Quartile",null,null,null,null,null,null,null,{"$f":"ROUND(QUARTILE($K$6:$K$35,1),3)","v":0.20799999999999999},null,{"$f":"ROUND(QUARTILE($M$6:$M$35,1),2)","v":0.63},{"$f":"ROUND(QUARTILE($N$6:$N$35,1),2)","v":2.75}]
[null,null,"Median",null,null,null,null,null,null,null,{"$f":"ROUND(MEDIAN($K$6:$K$35),3)","v":0.26900000000000002},null,{"$f":"ROUND(MEDIAN($M$6:$M$35),2)","v":0.83},{"$f":"ROUND(MEDIAN($N$6:$N$35),2)","v":3.03}]
[null,null,"Upper Quartile",null,null,null,null,null,null,null,{"$f":"ROUND(QUARTILE($K$6:$K$35,3),3)","v":0.34},null,{"$f":"ROUND(QUARTILE($M$6:$M$35,3),2)","v":1.04},{"$f":"ROUND(QUARTILE($N$6:$N$35,3),2)","v":3.37}]
[null,null,"Average",null,null,null,null,null,null,null,{"$f":"ROUND(AVERAGE($K$6:$K$35),3)","v":0.29399999999999998},null,{"$f":"ROUND(AVERAGE($M$6:$M$35),2)","v":0.86},{"$f":"ROUND(AVERAGE($N$6:$N$35),2)","v":3.06}]
[null,null,"Harmonic Mean",null,null,null,null,null,null,null,{"$f":"ROUND(HARMEAN(K6:K35),3)","v":0.26200000000000001},null,{"$f":"ROUND(HARMEAN(M6:M35),2)","v":0.78},{"$f":"ROUND(HARMEAN(N6:N35),2)","v":2.83}]

{"sheet":"Regression","index":1,"n_rows":95,"n_cols":58,"rows_kept":95,"cut":false,"hidden":false,"merged":[[19,30,21,30],[9,29,12,29],[13,29,16,29],[9,30,12,30],[9,31,12,31],[13,30,16,30],[13,31,16,31],[62,0,62,5],[62,14,62,19],[36,1,37,26],[3,24,4,24],[3,26,4,26],[38,8,38,10],[38,11,38,13],[38,22,38,24],[38,25,38,27],[3,27,4,27],[29,0,29,5],[29,14,29,19],[6,30,8,30],[6,29,8,29],[6,31,8,31],[4,29,5,31],[0,1,1,26],[2,9,2,13],[2,23,2,27],[3,9,4,9],[3,23,4,23],[3,10,4,10],[3,12,4,12],[3,13,4,13],[0,29,3,32]]}
[null,"FIRST REGRESSION - IDENTIFYING OUTLIERS",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Depending on your range of multipliers or range of the SDE%, you may have to right hand click on the multiplier Y-axis or  SDE%  X-axis and REFORMAT the spacing between the %  or multipliers for easier reading.",null,null,null,null,{"$f":"COLUMN()","v":35},{"$f":"COLUMN()","v":36},{"$f":"COLUMN()","v":37},"SUMMARY OUTPUT",null,null,null,null,null,null,null,null,null,null,{"$f":"COLUMN()","v":49},{"$f":"COLUMN()","v":50},{"$f":"COLUMN()","v":51},"SUMMARY OUTPUT"]
[]
[null,null,null,null,null,null,null,null,null,"Revenue Multiplier Data",null,null,null,null,null,null,null,null,null,null,null,null,null,"Cash Flow Multiplier Data",null,null,null,null,null,null,null,null,null,null,null,null,null,"Regression Statistics",null,null,null,null,null,null,null,null,null,null,null,null,null,"Regression Statistics"]
[null,null,null,null,null,null,null,null,null,"SDE%","Actual Multiplier",null,"Predicted Multiplier","Difference",null,null,null,null,null,null,null,null,null,"SDE%","Actual Multiplier",null,"Predicted Multiplier","Difference",null,null,null,null,null,null,null,null,null,"Multiple R",0.60396898616846495,null,null,null,null,null,null,null,null,null,null,null,null,"Multiple R",0.76814522273900043]
[null,null,null,null,null,null,0,0,null,null,null,null,null,null,null,null,null,null,null,null,0,0,null,null,null,null,null,null,null,"Polynomial Regression",null,null,null,null,null,null,null,"R Square",0.36477853625336337,null,null,null,null,null,null,null,null,null,null,null,null,"R Square",0.59004708321674859]
[null,null,null,null,null,null,{"$f":"IF(J6=\"\",\"\",IF(ABS(N6)>=$D$28,LARGE(G$5:$G5,1)+1,\"\"))","v":""},{"$f":"IF(J6=\"\",\"\",IF(ABS(N6)<$D$28,LARGE($H$5:H5,1)+1,\"\"))","v":1},1,{"$f":"IF(Sample!K6=\"\",\"\",Sample!K6)","v":0.151},{"$f":"IF(Sample!M6=\"\",\"\",Sample!M6)","v":0.61},null,{"$f":"IF(J6=\"\",\"\",IF($AE$10=\"X\",ROUND(AM26,2),ROUND(ROUND(SLOPE($K$6:$K$35,$J$6:$J$35),2)*J6+ROUND(INTERCEPT($K$6:$K$35,$J$6:$J$35),2),2)))","v":0.57999999999999996},{"$f":"IF(J6=\"\",\"\",ROUND(K6-M6,2))","v":0.03},null,null,null,null,null,null,{"$f":"IF(X6=\"\",\"\",IF(ABS(AB6)>=$R$28,LARGE($U$5:U5,1)+1,\"\"))","v":""},{"$f":"IF(X6=\"\",\"\",IF(ABS(AB6)<$R$28,LARGE($V$5:V5,1)+1,\"\"))","v":1},1,{"$f":"IF(Sample!K6=\"\",\"\",Sample!K6)","v":0.151},{"$f":"IF(Sample!N6=\"\",\"\",Sample!N6)","v":4.0199999999999996},null,{"$f":"IF(X6=\"\",\"\",ROUND(ROUND(SLOPE($Y$6:$Y$35,$X$6:$X$35),2)*X6 +ROUND(INTERCEPT($Y$6:$Y$35,$X$6:$X$35),2),2))","v":3.64},{"$f":"IF(X6=\"\",\"\",ROUND(Y6-AA6,2))","v":0.38},null,null,null,null,null,null,{"$f":"J6","v":0.151},{"$f":"IF(AI6=\"\",\"\",AI6^2)","v":2.2800999999999998E-2},{"$f":"K6","v":0.61},"Adjusted R Square",0.30125638987869968,null,null,null,null,null,null,null,null,null,{"$f":"X6","v":0.151},{"$f":"IF(AW6=\"\",\"\",AW6^2)","v":2.2800999999999998E-2},{"$f":"Y6","v":4.0199999999999996},"Adjusted R Square",0.54905179153842343]
[null,null,null,null,null,null,{"$f":"IF(J7=\"\",\"\",IF(ABS(N7)>=$D$28,LARGE(G$5:$G6,1)+1,\"\"))","v":1},{"$f":"IF(J7=\"\",\"\",IF(ABS(N7)<$D$28,LARGE($H$5:H6,1)+1,\"\"))","v":""},{"$f":"IF(J7=\"\",\"\",I6+1)","v":2},{"$f":"IF(Sample!K7=\"\",\"\",Sample!K7)","v":0.17199999999999999},{"$f":"IF(Sample!M7=\"\",\"\",Sample!M7)","v":0.91},null,{"$f":"IF(J7=\"\",\"\",IF($AE$10=\"X\",ROUND(AM27,2),ROUND(ROUND(SLOPE($K$6:$K$35,$J$6:$J$35),2)*J7+ROUND(INTERCEPT($K$6:$K$35,$J$6:$J$35),2),2)))","v":0.62},0.28999999999999998,null,null,null,null,null,null,{"$f":"IF(X7=\"\",\"\",IF(ABS(AB7)>=$R$28,LARGE($U$5:U6,1)+1,\"\"))","v":1},{"$f":"IF(X7=\"\",\"\",IF(ABS(AB7)<$R$28,LARGE($V$5:V6,1)+1,\"\"))","v":""},{"$f":"IF(X7=\"\",\"\",W6+1)","v":2},{"$f":"IF(Sample!K7=\"\",\"\",Sample!K7)","v":0.17199999999999999},{"$f":"IF(Sample!N7=\"\",\"\",Sample!N7)","v":5.28},null,{"$f":"IF(X7=\"\",\"\",ROUND(ROUND(SLOPE($Y$6:$Y$35,$X$6:$X$35),2)*X7 +ROUND(INTERCEPT($Y$6:$Y$35,$X$6:$X$35),2),2))","v":3.55},1.73,null,"Trendline","Revenue  Multiplier","Cash Flow  Multiplier",null,null,{"$f":"J7","v":0.17199999999999999},{"$f":"IF(AI7=\"\",\"\",AI7^2)","v":2.9583999999999996E-2},{"$f":"K7","v":0.91},"Standard Error",0.17569468676009944,null,null,null,null,null,null,null,null,null,{"$f":"X7","v":0.17199999999999999},{"$f":"IF(AW7=\"\",\"\",AW7^2)","v":2.9583999999999996E-2},{"$f":"Y7","v":5.28},"Standard Error",1.126198539702689]
[null,null,null,null,null,null,{"$f":"IF(J8=\"\",\"\",IF(ABS(N8)>=$D$28,LARGE(G$5:$G7,1)+1,\"\"))","v":""},{"$f":"IF(J8=\"\",\"\",IF(ABS(N8)<$D$28,LARGE($H$5:H7,1)+1,\"\"))","v":2},{"$f":"IF(J8=\"\",\"\",I7+1)","v":3},{"$f":"IF(Sample!K8=\"\",\"\",Sample!K8)","v":0.19500000000000001},{"$f":"IF(Sample!M8=\"\",\"\",Sample!M8)","v":0.56999999999999995},null,{"$f":"IF(J8=\"\",\"\",IF($AE$10=\"X\",ROUND(AM28,2),ROUND(ROUND(SLOPE($K$6:$K$35,$J$6:$J$35),2)*J8+ROUND(INTERCEPT($K$6:$K$35,$J$6:$J$35),2),2)))","v":0.67},-0.1,null,null,null,null,null,null,{"$f":"IF(X8=\"\",\"\",IF(ABS(AB8)>=$R$28,LARGE($U$5:U7,1)+1,\"\"))","v":""},{"$f":"IF(X8=\"\",\"\",IF(ABS(AB8)<$R$28,LARGE($V$5:V7,1)+1,\"\"))","v":2},{"$f":"IF(X8=\"\",\"\",W7+1)","v":3},{"$f":"IF(Sample!K8=\"\",\"\",Sample!K8)","v":0.19500000000000001},{"$f":"IF(Sample!N8=\"\",\"\",Sample!N8)","v":2.94},null,{"$f":"IF(X8=\"\",\"\",ROUND(ROUND(SLOPE($Y$6:$Y$35,$X$6:$X$35),2)*X8 +ROUND(INTERCEPT($Y$6:$Y$35,$X$6:$X$35),2),2))","v":3.46},-0.52,null,null,null,null,null,null,0.19500000000000001,3.8025000000000003E-2,0.56999999999999995,"Observations",23,null,null,null,null,null,null,null,null,null,0.19500000000000001,3.8025000000000003E-2,2.94,"Observations",23]
[null,null,null,null,null,null,{"$f":"IF(J9=\"\",\"\",IF(ABS(N9)>=$D$28,LARGE(G$5:$G8,1)+1,\"\"))","v":""},{"$f":"IF(J9=\"\",\"\",IF(ABS(N9)<$D$28,LARGE($H$5:H8,1)+1,\"\"))","v":3},4,{"$f":"IF(Sample!K9=\"\",\"\",Sample!K9)","v":0.19700000000000001},{"$f":"IF(Sample!M9=\"\",\"\",Sample!M9)","v":0.59},null,{"$f":"IF(J9=\"\",\"\",IF($AE$10=\"X\",ROUND(AM29,2),ROUND(ROUND(SLOPE($K$6:$K$35,$J$6:$J$35),2)*J9+ROUND(INTERCEPT($K$6:$K$35,$J$6:$J$35),2),2)))","v":0.67},-0.08,null,null,null,null,null,null,{"$f":"IF(X9=\"\",\"\",IF(ABS(AB9)>=$R$28,LARGE($U$5:U8,1)+1,\"\"))","v":""},{"$f":"IF(X9=\"\",\"\",IF(ABS(AB9)<$R$28,LARGE($V$5:V8,1)+1,\"\"))","v":3},4,{"$f":"IF(Sample!K9=\"\",\"\",Sample!K9)","v":0.19700000000000001},{"$f":"IF(Sample!N9=\"\",\"\",Sample!N9)","v":3.02},null,{"$f":"IF(X9=\"\",\"\",ROUND(ROUND(SLOPE($Y$6:$Y$35,$X$6:$X$35),2)*X9 +ROUND(INTERCEPT($Y$6:$Y$35,$X$6:$X$35),2),2))","v":3.45},-0.43,null,null,null,null,null,null,0.19700000000000001,3.8809000000000003E-2,0.59,null,null,null,null,null,null,null,null,null,null,null,0.19700000000000001,3.8809000000000003E-2,3.02]
[null,null,null,null,null,null,{"$f":"IF(J10=\"\",\"\",IF(ABS(N10)>=$D$28,LARGE(G$5:$G9,1)+1,\"\"))","v":""},{"$f":"IF(J10=\"\",\"\",IF(ABS(N10)<$D$28,LARGE($H$5:H9,1)+1,\"\"))","v":4},5,{"$f":"IF(Sample!K10=\"\",\"\",Sample!K10)","v":0.20300000000000001},{"$f":"IF(Sample!M10=\"\",\"\",Sample!M10)","v":0.69},null,{"$f":"IF(J10=\"\",\"\",IF($AE$10=\"X\",ROUND(AM30,2),ROUND(ROUND(SLOPE($K$6:$K$35,$J$6:$J$35),2)*J10+ROUND(INTERCEPT($K$6:$K$35,$J$6:$J$35),2),2)))","v":0.68},0.01,null,null,null,null,null,null,{"$f":"IF(X10=\"\",\"\",IF(ABS(AB10)>=$R$28,LARGE($U$5:U9,1)+1,\"\"))","v":""},{"$f":"IF(X10=\"\",\"\",IF(ABS(AB10)<$R$28,LARGE($V$5:V9,1)+1,\"\"))","v":4},5,{"$f":"IF(Sample!K10=\"\",\"\",Sample!K10)","v":0.20300000000000001},{"$f":"IF(Sample!N10=\"\",\"\",Sample!N10)","v":3.39},null,{"$f":"IF(X10=\"\",\"\",ROUND(ROUND(SLOPE($Y$6:$Y$35,$X$6:$X$35),2)*X10 +ROUND(INTERCEPT($Y$6:$Y$35,$X$6:$X$35),2),2))","v":3.43},-0.04,null,"Linear",null,null,null,null,0.20300000000000001,4.1209000000000003E-2,0.69,"ANOVA",null,null,null,null,null,null,null,null,null,null,0.20300000000000001,4.1209000000000003E-2,3.39,"ANOVA"]
[null,null,null,null,null,null,{"$f":"IF(J11=\"\",\"\",IF(ABS(N11)>=$D$28,LARGE(G$5:$G10,1)+1,\"\"))","v":""},{"$f":"IF(J11=\"\",\"\",IF(ABS(N11)<$D$28,LARGE($H$5:H10,1)+1,\"\"))","v":5},6,{"$f":"IF(Sample!K11=\"\",\"\",Sample!K11)","v":0.222},{"$f":"IF(Sample!M11=\"\",\"\",Sample!M11)","v":0.83},null,0.72,0.11,null,null,null,null,null,null,{"$f":"IF(X11=\"\",\"\",IF(ABS(AB11)>=$R$28,LARGE($U$5:U10,1)+1,\"\"))","v":""},{"$f":"IF(X11=\"\",\"\",IF(ABS(AB11)<$R$28,LARGE($V$5:V10,1)+1,\"\"))","v":5},6,{"$f":"IF(Sample!K11=\"\",\"\",Sample!K11)","v":0.222},{"$f":"IF(Sample!N11=\"\",\"\",Sample!N11)","v":3.73},null,{"$f":"IF(X11=\"\",\"\",ROUND(ROUND(SLOPE($Y$6:$Y$35,$X$6:$X$35),2)*X11 +ROUND(INTERCEPT($Y$6:$Y$35,$X$6:$X$35),2),2))","v":3.35},0.38,null,null,null,null,null,null,0.222,4.9284000000000001E-2,0.83,null,"df","SS","MS","F","Significance F",null,null,null,null,null,0.222,4.9284000000000001E-2,3.73,null,"df","SS","MS","F","Significance F"]
[null,null,null,null,null,null,{"$f":"IF(J12=\"\",\"\",IF(ABS(N12)>=$D$28,LARGE(G$5:$G11,1)+1,\"\"))","v":2},{"$f":"IF(J12=\"\",\"\",IF(ABS(N12)<$D$28,LARGE($H$5:H11,1)+1,\"\"))","v":""},7,{"$f":"IF(Sample!K12=\"\",\"\",Sample!K12)","v":0.246},{"$f":"IF(Sample!M12=\"\",\"\",Sample!M12)","v":0.47},null,0.77,-0.3,null,null,null,null,null,null,{"$f":"IF(X12=\"\",\"\",IF(ABS(AB12)>=$R$28,LARGE($U$5:U11,1)+1,\"\"))","v":2},{"$f":"IF(X12=\"\",\"\",IF(ABS(AB12)<$R$28,LARGE($V$5:V11,1)+1,\"\"))","v":""},7,{"$f":"IF(Sample!K12=\"\",\"\",Sample!K12)","v":0.246},{"$f":"IF(Sample!N12=\"\",\"\",Sample!N12)","v":1.93},null,3.25,-1.32,null,null,null,null,null,null,0.246,6.0516E-2,0.47,"Regression",2,0.35452867198578142,0.17726433599289071,5.7425410990025734,1.0696744984295705E-2,null,null,null,null,null,0.246,6.0516E-2,1.93,"Regression",2,36.510064696931508,18.255032348465754,14.393045129343855,1.3407253078684278E-4]
[null,null,null,null,null,null,{"$f":"IF(J13=\"\",\"\",IF(ABS(N13)>=$D$28,LARGE(G$5:$G12,1)+1,\"\"))","v":""},{"$f":"IF(J13=\"\",\"\",IF(ABS(N13)<$D$28,LARGE($H$5:H12,1)+1,\"\"))","v":6},8,{"$f":"IF(Sample!K13=\"\",\"\",Sample!K13)","v":0.251},{"$f":"IF(Sample!M13=\"\",\"\",Sample!M13)","v":0.83},null,0.78,0.05,null,null,null,null,null,null,{"$f":"IF(X13=\"\",\"\",IF(ABS(AB13)>=$R$28,LARGE($U$5:U12,1)+1,\"\"))","v":""},{"$f":"IF(X13=\"\",\"\",IF(ABS(AB13)<$R$28,LARGE($V$5:V12,1)+1,\"\"))","v":6},8,{"$f":"IF(Sample!K13=\"\",\"\",Sample!K13)","v":0.251},{"$f":"IF(Sample!N13=\"\",\"\",Sample!N13)","v":3.29},null,3.23,0.06,null,null,null,null,null,null,0.251,6.3001000000000001E-2,0.83,"Residual",20,0.61737245911458916,3.0868622955729459E-2,null,null,null,null,null,null,null,0.251,6.3001000000000001E-2,3.29,"Residual",20,25.366463016569387,1.2683231508284694]
[null,null,null,null,null,null,{"$f":"IF(J14=\"\",\"\",IF(ABS(N14)>=$D$28,LARGE(G$5:$G13,1)+1,\"\"))","v":""},{"$f":"IF(J14=\"\",\"\",IF(ABS(N14)<$D$28,LARGE($H$5:H13,1)+1,\"\"))","v":7},9,{"$f":"IF(Sample!K14=\"\",\"\",Sample!K14)","v":0.26300000000000001},{"$f":"IF(Sample!M14=\"\",\"\",Sample!M14)","v":0.96},null,0.8,0.16,null,null,null,null,null,null,{"$f":"IF(X14=\"\",\"\",IF(ABS(AB14)>=$R$28,LARGE($U$5:U13,1)+1,\"\"))","v":""},{"$f":"IF(X14=\"\",\"\",IF(ABS(AB14)<$R$28,LARGE($V$5:V13,1)+1,\"\"))","v":7},9,{"$f":"IF(Sample!K14=\"\",\"\",Sample!K14)","v":0.26300000000000001},{"$f":"IF(Sample!N14=\"\",\"\",Sample!N14)","v":3.68},null,3.18,0.5,null,"Curved",null,null,null,null,0.26300000000000001,6.9169000000000008E-2,0.96,"Total",22,0.97190113110037057,null,null,null,null,null,null,null,null,0.26300000000000001,6.9169000000000008E-2,3.68,"Total",22,61.876527713500892]
[null,null,null,null,null,null,{"$f":"IF(J15=\"\",\"\",IF(ABS(N15)>=$D$28,LARGE(G$5:$G14,1)+1,\"\"))","v":""},{"$f":"IF(J15=\"\",\"\",IF(ABS(N15)<$D$28,LARGE($H$5:H14,1)+1,\"\"))","v":8},10,{"$f":"IF(Sample!K15=\"\",\"\",Sample!K15)","v":0.27400000000000002},{"$f":"IF(Sample!M15=\"\",\"\",Sample!M15)","v":0.83},null,0.83,0,null,null,null,null,null,null,{"$f":"IF(X15=\"\",\"\",IF(ABS(AB15)>=$R$28,LARGE($U$5:U14,1)+1,\"\"))","v":""},{"$f":"IF(X15=\"\",\"\",IF(ABS(AB15)<$R$28,LARGE($V$5:V14,1)+1,\"\"))","v":8},10,{"$f":"IF(Sample!K15=\"\",\"\",Sample!K15)","v":0.27400000000000002},{"$f":"IF(Sample!N15=\"\",\"\",Sample!N15)","v":3.03},null,3.14,-0.11,null,null,null,null,null,null,0.27400000000000002,7.5076000000000018E-2,0.83,null,null,null,null,null,null,null,null,null,null,null,0.27400000000000002,7.5076000000000018E-2,3.03]
[null,null,null,null,null,null,{"$f":"IF(J16=\"\",\"\",IF(ABS(N16)>=$D$28,LARGE(G$5:$G15,1)+1,\"\"))","v":""},{"$f":"IF(J16=\"\",\"\",IF(ABS(N16)<$D$28,LARGE($H$5:H15,1)+1,\"\"))","v":9},11,{"$f":"IF(Sample!K16=\"\",\"\",Sample!K16)","v":0.29399999999999998},{"$f":"IF(Sample!M16=\"\",\"\",Sample!M16)","v":0.93},null,0.87,0.06,null,null,null,null,null,null,{"$f":"IF(X16=\"\",\"\",IF(ABS(AB16)>=$R$28,LARGE($U$5:U15,1)+1,\"\"))","v":""},{"$f":"IF(X16=\"\",\"\",IF(ABS(AB16)<$R$28,LARGE($V$5:V15,1)+1,\"\"))","v":9},11,{"$f":"IF(Sample!K16=\"\",\"\",Sample!K16)","v":0.29399999999999998},{"$f":"IF(Sample!N16=\"\",\"\",Sample!N16)","v":3.16},null,3.06,0.1,null,null,null,null,null,null,0.29399999999999998,8.6435999999999985E-2,0.93,null,"Coefficients","Standard Error","t Stat","P-value","Lower 95%","Upper 95%",null,null,null,null,0.29399999999999998,8.6435999999999985E-2,3.16,null,"Coefficients","Standard Error","t Stat","P-value","Lower 95%","Upper 95%"]
[null,null,null,null,null,null,{"$f":"IF(J17=\"\",\"\",IF(ABS(N17)>=$D$28,LARGE(G$5:$G16,1)+1,\"\"))","v":3},{"$f":"IF(J17=\"\",\"\",IF(ABS(N17)<$D$28,LARGE($H$5:H16,1)+1,\"\"))","v":""},12,{"$f":"IF(Sample!K17=\"\",\"\",Sample!K17)","v":0.32300000000000001},{"$f":"IF(Sample!M17=\"\",\"\",Sample!M17)","v":0.68},null,0.92,-0.24,null,null,null,null,null,null,{"$f":"IF(X17=\"\",\"\",IF(ABS(AB17)>=$R$28,LARGE($U$5:U16,1)+1,\"\"))","v":3},{"$f":"IF(X17=\"\",\"\",IF(ABS(AB17)<$R$28,LARGE($V$5:V16,1)+1,\"\"))","v":""},12,{"$f":"IF(Sample!K17=\"\",\"\",Sample!K17)","v":0.32300000000000001},{"$f":"IF(Sample!N17=\"\",\"\",Sample!N17)","v":2.1},null,2.94,-0.84,null,null,null,null,null,null,0.32300000000000001,0.10432900000000001,0.68,"Intercept",0.13601520499724393,0.14108602074214233,0.96405869470111327,0.34652935528242534,-0.15828507719105858,0.43031548718554646,null,null,null,null,0.32300000000000001,0.10432900000000001,2.1,"Intercept",6.6999853281804782,0.90435785772634025,7.4085554417860786,3.739202308289689E-7,4.8135278937156691,8.5864427626452873]
[null,null,null,null,null,null,{"$f":"IF(J18=\"\",\"\",IF(ABS(N18)>=$D$28,LARGE(G$5:$G17,1)+1,\"\"))","v":4},{"$f":"IF(J18=\"\",\"\",IF(ABS(N18)<$D$28,LARGE($H$5:H17,1)+1,\"\"))","v":""},13,{"$f":"IF(Sample!K18=\"\",\"\",Sample!K18)","v":0.33800000000000002},{"$f":"IF(Sample!M18=\"\",\"\",Sample!M18)","v":0.5},null,0.95,-0.45,null,null,null,null,null,null,{"$f":"IF(X18=\"\",\"\",IF(ABS(AB18)>=$R$28,LARGE($U$5:U17,1)+1,\"\"))","v":4},{"$f":"IF(X18=\"\",\"\",IF(ABS(AB18)<$R$28,LARGE($V$5:V17,1)+1,\"\"))","v":""},13,{"$f":"IF(Sample!K18=\"\",\"\",Sample!K18)","v":0.33800000000000002},{"$f":"IF(Sample!N18=\"\",\"\",Sample!N18)","v":1.47},null,2.88,-1.41,null,null,null,null,null,null,0.33800000000000002,0.11424400000000001,0.5,"X Variable 1",2.0015327338833813,1.4368311486940986,1.3930187522051749,0.17890592348718895,-0.99564452218553301,4.998709989952296,null,null,null,null,0.33800000000000002,0.11424400000000001,1.47,"X Variable 1",-34.567137887858181,9.2100516600603175,-3.7531969595523198,1.2519986936460291E-3,-53.7789689981743,-15.355306777542062]
[null,null,null,null,null,null,{"$f":"IF(J19=\"\",\"\",IF(ABS(N19)>=$D$28,LARGE(G$5:$G18,1)+1,\"\"))","v":""},{"$f":"IF(J19=\"\",\"\",IF(ABS(N19)<$D$28,LARGE($H$5:H18,1)+1,\"\"))","v":10},14,{"$f":"IF(Sample!K19=\"\",\"\",Sample!K19)","v":0.34100000000000003},{"$f":"IF(Sample!M19=\"\",\"\",Sample!M19)","v":1.06},null,0.96,0.1,null,null,null,null,null,null,{"$f":"IF(X19=\"\",\"\",IF(ABS(AB19)>=$R$28,LARGE($U$5:U18,1)+1,\"\"))","v":""},{"$f":"IF(X19=\"\",\"\",IF(ABS(AB19)<$R$28,LARGE($V$5:V18,1)+1,\"\"))","v":10},14,{"$f":"IF(Sample!K19=\"\",\"\",Sample!K19)","v":0.34100000000000003},{"$f":"IF(Sample!N19=\"\",\"\",Sample!N19)","v":3.11},null,2.87,0.24,null,null,null,null,null,null,0.34100000000000003,0.11628100000000002,1.06,"X Variable 2",-2.1553905973169458,3.0215174073031266,-0.71334707260242214,0.48387250131913384,-8.4581654642287951,4.1473842695949026,null,null,null,null,0.34100000000000003,0.11628100000000002,3.11,"X Variable 2",55.481124293594597,19.367850869829631,2.864598899820145,9.5808841305957838E-3,15.080495327033603,95.881753260155591]
[null,null,null,null,null,null,{"$f":"IF(J20=\"\",\"\",IF(ABS(N20)>=$D$28,LARGE(G$5:$G19,1)+1,\"\"))","v":""},{"$f":"IF(J20=\"\",\"\",IF(ABS(N20)<$D$28,LARGE($H$5:H19,1)+1,\"\"))","v":11},15,{"$f":"IF(Sample!K20=\"\",\"\",Sample!K20)","v":0.42799999999999999},{"$f":"IF(Sample!M20=\"\",\"\",Sample!M20)","v":1.28},null,1.1299999999999999,0.15,null,null,null,null,null,null,{"$f":"IF(X20=\"\",\"\",IF(ABS(AB20)>=$R$28,LARGE($U$5:U19,1)+1,\"\"))","v":""},{"$f":"IF(X20=\"\",\"\",IF(ABS(AB20)<$R$28,LARGE($V$5:V19,1)+1,\"\"))","v":11},15,{"$f":"IF(Sample!K20=\"\",\"\",Sample!K20)","v":0.42799999999999999},{"$f":"IF(Sample!N20=\"\",\"\",Sample!N20)","v":2.99},null,2.52,0.47,null,null,"Data Entry Instructions",null,null,null,0.42799999999999999,0.18318399999999999,1.28,null,null,null,null,null,null,null,null,null,null,null,0.42799999999999999,0.18318399999999999,2.99]
[null,null,null,null,null,null,{"$f":"IF(J21=\"\",\"\",IF(ABS(N21)>=$D$28,LARGE(G$5:$G20,1)+1,\"\"))","v":""},{"$f":"IF(J21=\"\",\"\",IF(ABS(N21)<$D$28,LARGE($H$5:H20,1)+1,\"\"))","v":12},16,{"$f":"IF(Sample!K21=\"\",\"\",Sample!K21)","v":0.45200000000000001},{"$f":"IF(Sample!M21=\"\",\"\",Sample!M21)","v":1.07},null,1.18,-0.11,null,null,null,null,null,null,{"$f":"IF(X21=\"\",\"\",IF(ABS(AB21)>=$R$28,LARGE($U$5:U20,1)+1,\"\"))","v":""},{"$f":"IF(X21=\"\",\"\",IF(ABS(AB21)<$R$28,LARGE($V$5:V20,1)+1,\"\"))","v":12},16,{"$f":"IF(Sample!K21=\"\",\"\",Sample!K21)","v":0.45200000000000001},{"$f":"IF(Sample!N21=\"\",\"\",Sample!N21)","v":2.36},null,2.42,-0.06,null,null,null,null,null,null,0.45200000000000001,0.20430400000000001,1.07,null,null,null,null,null,null,null,null,null,null,null,0.45200000000000001,0.20430400000000001,2.36]
[null,null,null,null,null,null,{"$f":"IF(J22=\"\",\"\",IF(ABS(N22)>=$D$28,LARGE(G$5:$G21,1)+1,\"\"))","v":""},{"$f":"IF(J22=\"\",\"\",IF(ABS(N22)<$D$28,LARGE($H$5:H21,1)+1,\"\"))","v":13},17,{"$f":"IF(Sample!K22=\"\",\"\",Sample!K22)","v":0.45400000000000001},{"$f":"IF(Sample!M22=\"\",\"\",Sample!M22)","v":1.22},null,1.18,0.04,null,null,null,null,null,null,{"$f":"IF(X22=\"\",\"\",IF(ABS(AB22)>=$R$28,LARGE($U$5:U21,1)+1,\"\"))","v":""},{"$f":"IF(X22=\"\",\"\",IF(ABS(AB22)<$R$28,LARGE($V$5:V21,1)+1,\"\"))","v":13},17,{"$f":"IF(Sample!K22=\"\",\"\",Sample!K22)","v":0.45400000000000001},{"$f":"IF(Sample!N22=\"\",\"\",Sample!N22)","v":2.69},null,2.41,0.28000000000000003,null,null,null,null,null,null,0.45400000000000001,0.20611600000000002,1.22,null,null,null,null,null,null,null,null,null,null,null,0.45400000000000001,0.20611600000000002,2.69]
[null,null,null,null,null,null,{"$f":"IF(J23=\"\",\"\",IF(ABS(N23)>=$D$28,LARGE(G$5:$G22,1)+1,\"\"))","v":5},{"$f":"IF(J23=\"\",\"\",IF(ABS(N23)<$D$28,LARGE($H$5:H22,1)+1,\"\"))","v":""},18,{"$f":"IF(Sample!K23=\"\",\"\",Sample!K23)","v":0.48199999999999998},{"$f":"IF(Sample!M23=\"\",\"\",Sample!M23)","v":1.43},null,1.24,{"$f":"IF(J23=\"\",\"\",ROUND(K23-M23,2))","v":0.19},null,null,null,null,null,null,{"$f":"IF(X23=\"\",\"\",IF(ABS(AB23)>=$R$28,LARGE($U$5:U22,1)+1,\"\"))","v":""},{"$f":"IF(X23=\"\",\"\",IF(ABS(AB23)<$R$28,LARGE($V$5:V22,1)+1,\"\"))","v":14},18,{"$f":"IF(Sample!K23=\"\",\"\",Sample!K23)","v":0.48199999999999998},{"$f":"IF(Sample!N23=\"\",\"\",Sample!N23)","v":2.96},null,2.2999999999999998,0.66,null,null,null,null,null,null,0.48199999999999998,0.23232399999999997,1.43,"RESIDUAL OUTPUT",null,null,null,null,null,null,null,null,null,null,0.48199999999999998,0.23232399999999997,2.96,"RESIDUAL OUTPUT"]
[null,null,null,null,null,null,{"$f":"IF(J24=\"\",\"\",IF(ABS(N24)>=$D$28,LARGE(G$5:$G23,1)+1,\"\"))","v":""},{"$f":"IF(J24=\"\",\"\",IF(ABS(N24)<$D$28,LARGE($H$5:H23,1)+1,\"\"))","v":""},"",{"$f":"IF(Sample!K24=\"\",\"\",Sample!K24)","v":""},{"$f":"IF(Sample!M24=\"\",\"\",Sample!M24)","v":""},null,"",{"$f":"IF(J24=\"\",\"\",ROUND(K24-M24,2))","v":""},null,null,null,null,null,null,{"$f":"IF(X24=\"\",\"\",IF(ABS(AB24)>=$R$28,LARGE($U$5:U23,1)+1,\"\"))","v":""},{"$f":"IF(X24=\"\",\"\",IF(ABS(AB24)<$R$28,LARGE($V$5:V23,1)+1,\"\"))","v":""},"",{"$f":"IF(Sample!K24=\"\",\"\",Sample!K24)","v":""},{"$f":"IF(Sample!N24=\"\",\"\",Sample!N24)","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(J25=\"\",\"\",IF(ABS(N25)>=$D$28,LARGE(G$5:$G24,1)+1,\"\"))","v":""},{"$f":"IF(J25=\"\",\"\",IF(ABS(N25)<$D$28,LARGE($H$5:H24,1)+1,\"\"))","v":""},"",{"$f":"IF(Sample!K25=\"\",\"\",Sample!K25)","v":""},{"$f":"IF(Sample!M25=\"\",\"\",Sample!M25)","v":""},null,"","",null,null,null,null,null,null,{"$f":"IF(X25=\"\",\"\",IF(ABS(AB25)>=$R$28,LARGE($U$5:U24,1)+1,\"\"))","v":""},{"$f":"IF(X25=\"\",\"\",IF(ABS(AB25)<$R$28,LARGE($V$5:V24,1)+1,\"\"))","v":""},"",{"$f":"IF(Sample!K25=\"\",\"\",Sample!K25)","v":""},{"$f":"IF(Sample!N25=\"\",\"\",Sample!N25)","v":""},null,"","",null,null,null,null,null,null,"","","","Observation","Predicted Y","Residuals","Standard Residuals",null,null,null,null,null,null,null,"","","","Observation","Predicted Y","Residuals","Standard Residuals"]
[null,null,"R Sq. =",{"$f":"IF($AE$10=\"X\",AM5,RSQ(K6:K35,J6:J35))","v":0.55451590287309793},null,null,{"$f":"IF(J26=\"\",\"\",IF(ABS(N26)>=$D$28,LARGE(G$5:$G25,1)+1,\"\"))","v":""},{"$f":"IF(J26=\"\",\"\",IF(ABS(N26)<$D$28,LARGE($H$5:H25,1)+1,\"\"))","v":""},"",{"$f":"IF(Sample!K26=\"\",\"\",Sample!K26)","v":""},{"$f":"IF(Sample!M26=\"\",\"\",Sample!M26)","v":""},null,"","",null,null,"R Sq. =",{"$f":"IF($AF$10=\"X\",BA5,RSQ(Y6:Y35,X6:X35))","v":0.24414370805464594},null,null,{"$f":"IF(X26=\"\",\"\",IF(ABS(AB26)>=$R$28,LARGE($U$5:U25,1)+1,\"\"))","v":""},{"$f":"IF(X26=\"\",\"\",IF(ABS(AB26)<$R$28,LARGE($V$5:V25,1)+1,\"\"))","v":""},"",{"$f":"IF(Sample!K26=\"\",\"\",Sample!K26)","v":""},{"$f":"IF(Sample!N26=\"\",\"\",Sample!N26)","v":""},null,"","",null,null,null,null,null,null,"","","",1,0.19616070280893735,3.619723064607408E-2,0.21607924793249891,null,null,null,null,null,null,null,"","","",1,5.6789000772785343,1.7946621961791092,1.6713372682280623]
[null,null,null,null,null,null,{"$f":"IF(J27=\"\",\"\",IF(ABS(N27)>=$D$28,LARGE(G$5:$G26,1)+1,\"\"))","v":""},{"$f":"IF(J27=\"\",\"\",IF(ABS(N27)<$D$28,LARGE($H$5:H26,1)+1,\"\"))","v":""},"",{"$f":"IF(Sample!K27=\"\",\"\",Sample!K27)","v":""},{"$f":"IF(Sample!M27=\"\",\"\",Sample!M27)","v":""},null,"","",null,null,null,null,null,null,{"$f":"IF(X27=\"\",\"\",IF(ABS(AB27)>=$R$28,LARGE($U$5:U26,1)+1,\"\"))","v":""},{"$f":"IF(X27=\"\",\"\",IF(ABS(AB27)<$R$28,LARGE($V$5:V26,1)+1,\"\"))","v":""},"",{"$f":"IF(Sample!K27=\"\",\"\",Sample!K27)","v":""},{"$f":"IF(Sample!N27=\"\",\"\",Sample!N27)","v":""},null,"","",null,null,null,null,null,null,"","","",2,0.21042959397724248,-3.0272406831457793E-2,-0.1807110318799347,null,null,null,null,null,null,null,"","","",2,5.4423083342590122,-0.79906425439521378,-0.74415445476197306]
[null,null,"Standard Error Outliers >",{"$f":"ROUND(IF($AE$10=\"X\",AM7,STEYX(K6:K35,J6:J35)),3)","v":0.19},null,null,{"$f":"IF(J28=\"\",\"\",IF(ABS(N28)>=$D$28,LARGE(G$5:$G27,1)+1,\"\"))","v":""},{"$f":"IF(J28=\"\",\"\",IF(ABS(N28)<$D$28,LARGE($H$5:H27,1)+1,\"\"))","v":""},"",{"$f":"IF(Sample!K28=\"\",\"\",Sample!K28)","v":""},{"$f":"IF(Sample!M28=\"\",\"\",Sample!M28)","v":""},null,"","",null,null,"Standard Error Outliers >",{"$f":"ROUND(IF($AF$10=\"X\",BA7,STEYX(Y6:Y35,X6:X35)),3)","v":0.76},null,null,{"$f":"IF(X28=\"\",\"\",IF(ABS(AB28)>=$R$28,LARGE($U$5:U27,1)+1,\"\"))","v":""},{"$f":"IF(X28=\"\",\"\",IF(ABS(AB28)<$R$28,LARGE($V$5:V27,1)+1,\"\"))","v":""},"",{"$f":"IF(Sample!K28=\"\",\"\",Sample!K28)","v":""},{"$f":"IF(Sample!N28=\"\",\"\",Sample!N28)","v":""},null,"","",null,null,null,null,null,null,"","","",3,0.28576587151421684,0.27410776127437186,1.6362853691143124,null,null,null,null,null,null,null,"","","",3,4.2367143403411198,2.5850644157302636,2.4074249226281683]
[null,null,null,null,null,null,{"$f":"IF(J29=\"\",\"\",IF(ABS(N29)>=$D$28,LARGE(G$5:$G28,1)+1,\"\"))","v":""},{"$f":"IF(J29=\"\",\"\",IF(ABS(N29)<$D$28,LARGE($H$5:H28,1)+1,\"\"))","v":""},"",{"$f":"IF(Sample!K29=\"\",\"\",Sample!K29)","v":""},{"$f":"IF(Sample!M29=\"\",\"\",Sample!M29)","v":""},null,"","",null,null,null,null,null,null,{"$f":"IF(X29=\"\",\"\",IF(ABS(AB29)>=$R$28,LARGE($U$5:U28,1)+1,\"\"))","v":""},{"$f":"IF(X29=\"\",\"\",IF(ABS(AB29)<$R$28,LARGE($V$5:V28,1)+1,\"\"))","v":""},"",{"$f":"IF(Sample!K29=\"\",\"\",Sample!K29)","v":""},{"$f":"IF(Sample!N29=\"\",\"\",Sample!N29)","v":""},null,"","",null,null,null,null,null,null,"","","",4,0.30309258407655626,-5.5797375421223955E-2,-0.33308224696833338,null,null,null,null,null,null,null,"","","",4,3.9715101990033368,-1.3048435323366703,-1.2151777807788493]
[{"$f":"IF($AE$10=\"X\",CONCATENATE(\"Regression Formula = \",ROUND(AM19,2),\"^2 x SDE% + \",ROUND(AM18,2),\" x SDE% + \",ROUND(AM17,2)),CONCATENATE(\"Regression Formula = \",ROUND(SLOPE(K6:K35,J6:J35),2),\" x SDE% + \",ROUND(INTERCEPT(K6:K35,J6:J35),2)))","v":"Regression Formula = 1.99 x SDE% + 0.28"},null,null,null,null,null,{"$f":"IF(J30=\"\",\"\",IF(ABS(N30)>=$D$28,LARGE(G$5:$G29,1)+1,\"\"))","v":""},{"$f":"IF(J30=\"\",\"\",IF(ABS(N30)<$D$28,LARGE($H$5:H29,1)+1,\"\"))","v":""},"",{"$f":"IF(Sample!K30=\"\",\"\",Sample!K30)","v":""},{"$f":"IF(Sample!M30=\"\",\"\",Sample!M30)","v":""},null,"","",{"$f":"IF($AF$10=\"X\",CONCATENATE(\"Regression Formula = \",ROUND(BA19,2),\"^2 x SDE% + \",ROUND(BA18,2),\" x SDE% + \",ROUND(BA17,2)),CONCATENATE(\"Regression Formula = \",ROUND(SLOPE(Y6:Y35,X6:X35),2),\" x SDE% + \",ROUND(INTERCEPT(Y6:Y35,X6:X35),2)))","v":"Regression Formula = -4.05 x SDE% + 4.25"},null,null,null,null,null,{"$f":"IF(X30=\"\",\"\",IF(ABS(AB30)>=$R$28,LARGE($U$5:U29,1)+1,\"\"))","v":""},{"$f":"IF(X30=\"\",\"\",IF(ABS(AB30)<$R$28,LARGE($V$5:V29,1)+1,\"\"))","v":""},"",{"$f":"IF(Sample!K30=\"\",\"\",Sample!K30)","v":""},{"$f":"IF(Sample!N30=\"\",\"\",Sample!N30)","v":""},null,"","",null,null,null,null,null,null,"","","",5,0.34178531436202331,-5.3498411236032328E-2,-0.3193585879122825,null,null,null,null,null,null,null,"","","",5,3.399324632751342,-0.95066986246576768,-0.88534208515846569]
[null,null,null,null,null,null,{"$f":"IF(J31=\"\",\"\",IF(ABS(N31)>=$D$28,LARGE(G$5:$G30,1)+1,\"\"))","v":""},{"$f":"IF(J31=\"\",\"\",IF(ABS(N31)<$D$28,LARGE($H$5:H30,1)+1,\"\"))","v":""},"",{"$f":"IF(Sample!K31=\"\",\"\",Sample!K31)","v":""},{"$f":"IF(Sample!M31=\"\",\"\",Sample!M31)","v":""},null,"","",null,null,null,null,null,null,{"$f":"IF(X31=\"\",\"\",IF(ABS(AB31)>=$R$28,LARGE($U$5:U30,1)+1,\"\"))","v":""},{"$f":"IF(X31=\"\",\"\",IF(ABS(AB31)<$R$28,LARGE($V$5:V30,1)+1,\"\"))","v":""},"",{"$f":"IF(Sample!K31=\"\",\"\",Sample!K31)","v":""},{"$f":"IF(Sample!N31=\"\",\"\",Sample!N31)","v":""},null,"","",null,null,null,null,null,null,"","","",6,0.35079804519266689,-1.7822993015476241E-2,-0.10639429751811642,null,null,null,null,null,null,null,"","","",6,3.2705107996346316,-0.58129777093534996,-0.54135236735392211]
[null,null,"Subject SDE% =",{"$f":"Valuation!$N$6","v":0.32502078137988361},null,null,{"$f":"IF(J32=\"\",\"\",IF(ABS(N32)>=$D$28,LARGE(G$5:$G31,1)+1,\"\"))","v":""},{"$f":"IF(J32=\"\",\"\",IF(ABS(N32)<$D$28,LARGE($H$5:H31,1)+1,\"\"))","v":""},"",{"$f":"IF(Sample!K32=\"\",\"\",Sample!K32)","v":""},{"$f":"IF(Sample!M32=\"\",\"\",Sample!M32)","v":""},null,"","",null,null,"Subject SDE% =",{"$f":"Valuation!$N$6","v":0.32502078137988361},null,null,{"$f":"IF(X32=\"\",\"\",IF(ABS(AB32)>=$R$28,LARGE($U$5:U31,1)+1,\"\"))","v":""},{"$f":"IF(X32=\"\",\"\",IF(ABS(AB32)<$R$28,LARGE($V$5:V31,1)+1,\"\"))","v":""},"",{"$f":"IF(Sample!K32=\"\",\"\",Sample!K32)","v":""},{"$f":"IF(Sample!N32=\"\",\"\",Sample!N32)","v":""},null,"","",null,null,null,null,null,null,"","","",7,0.35603819564098921,-3.8294863257859746E-2,-0.22860105883082768,null,null,null,null,null,null,null,"","","",7,3.1964731418591126,-0.70256540219457886,-0.6542867747230624]
[null,null,null,null,null,null,{"$f":"IF(J33=\"\",\"\",IF(ABS(N33)>=$D$28,LARGE(G$5:$G32,1)+1,\"\"))","v":""},{"$f":"IF(J33=\"\",\"\",IF(ABS(N33)<$D$28,LARGE($H$5:H32,1)+1,\"\"))","v":""},"",{"$f":"IF(Sample!K33=\"\",\"\",Sample!K33)","v":""},{"$f":"IF(Sample!M33=\"\",\"\",Sample!M33)","v":""},null,"","",null,null,null,null,null,null,{"$f":"IF(X33=\"\",\"\",IF(ABS(AB33)>=$R$28,LARGE($U$5:U32,1)+1,\"\"))","v":""},{"$f":"IF(X33=\"\",\"\",IF(ABS(AB33)<$R$28,LARGE($V$5:V32,1)+1,\"\"))","v":""},"",{"$f":"IF(Sample!K33=\"\",\"\",Sample!K33)","v":""},{"$f":"IF(Sample!N33=\"\",\"\",Sample!N33)","v":""},null,"","",null,null,null,null,null,null,"","","",8,0.36120709776083326,-0.10064371747914314,-0.60079233670277499,null,null,null,null,null,null,null,"","","",8,3.1240839778135356,-1.1348366659855786,-1.0568533829104443]
[null,null,"First Estimated Multiplier =",{"$f":"IF($AE$10=\"X\",ROUND(AM19*D32^2+AM18*D32+AM17,2),    ROUND(ROUND(SLOPE(K6:K35,J6:J35),2)*D32+ROUND(INTERCEPT(K6:K35,J6:J35),2),2))","v":0.93},null,null,{"$f":"IF(J34=\"\",\"\",IF(ABS(N34)>=$D$28,LARGE(G$5:$G33,1)+1,\"\"))","v":""},{"$f":"IF(J34=\"\",\"\",IF(ABS(N34)<$D$28,LARGE($H$5:H33,1)+1,\"\"))","v":""},"",{"$f":"IF(Sample!K34=\"\",\"\",Sample!K34)","v":""},{"$f":"IF(Sample!M34=\"\",\"\",Sample!M34)","v":""},null,"","",null,null,"First Estimated Multiplier =",{"$f":"IF($AF$10=\"X\",ROUND(BA19*R32^2+BA18*R32+BA17,2),    ROUND(ROUND(SLOPE(Y6:Y35,X6:X35),2)*R32+ROUND(INTERCEPT(Y6:Y35,X6:X35),2),2))","v":2.93},null,null,{"$f":"IF(X34=\"\",\"\",IF(ABS(AB34)>=$R$28,LARGE($U$5:U33,1)+1,\"\"))","v":""},{"$f":"IF(X34=\"\",\"\",IF(ABS(AB34)<$R$28,LARGE($V$5:V33,1)+1,\"\"))","v":""},"",{"$f":"IF(Sample!K34=\"\",\"\",Sample!K34)","v":""},{"$f":"IF(Sample!N34=\"\",\"\",Sample!N34)","v":""},null,"","",null,null,null,null,null,null,"","","",9,0.39069260392965893,-0.18343022962125746,-1.0949861455477321,null,null,null,null,null,null,null,"","","",9,2.7244279014025121,-1.3624745177231175,-1.2688485015897886]
[null,null,null,null,null,null,{"$f":"IF(J35=\"\",\"\",IF(ABS(N35)>=$D$28,LARGE(G$5:$G34,1)+1,\"\"))","v":""},{"$f":"IF(J35=\"\",\"\",IF(ABS(N35)<$D$28,LARGE($H$5:H34,1)+1,\"\"))","v":""},"",{"$f":"IF(Sample!K35=\"\",\"\",Sample!K35)","v":""},{"$f":"IF(Sample!M35=\"\",\"\",Sample!M35)","v":""},null,"","",null,null,null,null,null,null,{"$f":"IF(X35=\"\",\"\",IF(ABS(AB35)>=$R$28,LARGE($U$5:U34,1)+1,\"\"))","v":""},{"$f":"IF(X35=\"\",\"\",IF(ABS(AB35)<$R$28,LARGE($V$5:V34,1)+1,\"\"))","v":""},"",{"$f":"IF(Sample!K35=\"\",\"\",Sample!K35)","v":""},{"$f":"IF(Sample!N35=\"\",\"\",Sample!N35)","v":""},null,"","",null,null,null,null,null,null,"","","",10,0.40569123820985648,-0.15193183971361585,-0.90695661177272202,null,null,null,null,null,null,null,"","","",10,2.530837905264363,-0.97911376733332856,-0.91183139237199073]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,11,0.44759159245893793,0.20564406077671532,1.2275915367364485,null,null,null,null,null,null,null,null,null,null,11,2.0332678315995034,1.2692013042029657,1.181984801994667]
[null,"FINAL REGRESSION WITH OUTLIERS REMOVED",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,12,0.45010612788124232,3.1712053936939488E-2,0.18930500048715529,null,null,null,null,null,null,null,null,null,null,12,2.0058027223526262,0.40328818673828293,0.37557517942197827]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,13,0.45414187269955464,9.5635244685289389E-2,0.57089427502043255,null,null,null,null,null,null,null,null,null,null,13,1.9623786425146559,0.73835128449264342,0.68761353609827625]
[null,null,null,null,null,null,"SDE Range",null,"Relevant Comparables",null,null,"Outliers Removed",null,null,null,null,null,null,null,null,"SDE Range",null,"Relevant Comparables",null,null,"Outliers Removed",null,null,null,null,null,null,null,null,null,null,null,14,0.48753621766333566,-2.2223188898530255E-2,-0.13266125220485878,null,null,null,null,null,null,null,null,null,null,14,1.6390028874719356,0.33941437871511471,0.31609062793365378]
[null,null,null,null,null,null,{"$f":"IF(ROUNDDOWN(SMALL(J6:J35,1)-0.003,2)<0,0,ROUNDDOWN(SMALL(J6:J35,1)-0.003,2)-0)","v":0.14000000000000001},1,{"$f":"IF(ISERROR(VLOOKUP($H40,$H$6:$K$35,1,0)),\"\",VLOOKUP($H40,$H$6:$K$35,2,0))","v":1},{"$f":"IF(ISERROR(VLOOKUP($H40,$H$6:$K$35,1,0)),\"\",VLOOKUP($H40,$H$6:$K$35,3,0))","v":0.151},{"$f":"IF(ISERROR(VLOOKUP($H40,$H$6:$K$35,1,0)),\"\",VLOOKUP($H40,$H$6:$K$35,4,0))","v":0.61},{"$f":"IF(ISERROR(VLOOKUP($H40,$G$6:$H$35,1,0)),\"\",VLOOKUP($H40,$G$6:$K$35,3,0))","v":2},{"$f":"IF(ISERROR(VLOOKUP($H40,$G$6:$K$35,1,0)),\"\",VLOOKUP($H40,$G$6:$K$35,4,0))","v":0.17199999999999999},{"$f":"IF(ISERROR(VLOOKUP($H40,$G$6:$K$35,1,0)),\"\",VLOOKUP($H40,$G$6:$K$35,5,0))","v":0.91},null,null,null,null,null,null,{"$f":"IF(ROUNDDOWN(SMALL(X6:X35,1)-0.003,2)<0,0,ROUNDDOWN(SMALL(X6:X35,1)-0.003,2))","v":0.14000000000000001},1,{"$f":"IF(ISERROR(VLOOKUP($V40,$V$6:$X$35,1,0)),\"\",VLOOKUP($V40,$V$6:$X$35,2,0))","v":1},{"$f":"IF(ISERROR(VLOOKUP($V40,$V$6:$Y$35,1,0)),\"\",VLOOKUP($H40,$V$6:$Y$35,3,0))","v":0.151},{"$f":"IF(ISERROR(VLOOKUP($V40,$V$6:$Y$35,1,0)),\"\",VLOOKUP($V40,$V$6:$Y$35,4,0))","v":4.0199999999999996},{"$f":"IF(ISERROR(VLOOKUP($V40,$U$6:$V$35,1,0)),\"\",VLOOKUP($V40,$U$6:$Y$35,3,0))","v":2},{"$f":"IF(ISERROR(VLOOKUP($V40,$U$6:$X$35,1,0)),\"\",VLOOKUP($V40,$U$6:$X$35,4,0))","v":0.17199999999999999},{"$f":"IF(ISERROR(VLOOKUP($V40,$U$6:$Y$35,1,0)),\"\",VLOOKUP($V40,$U$6:$Y$35,5,0))","v":5.28},null,null,null,null,null,null,null,null,null,15,0.54292163580841757,-0.23711671249832539,-1.4154674264955607,null,null,null,null,null,null,null,null,null,null,15,1.3223850647087003,-0.30510621120677994,-0.28414003629397322]
[null,null,null,null,null,null,{"$f":"ROUNDUP(LARGE(J6:J35,1)+0.003,2)","v":0.49},2,3,0.19500000000000001,0.56999999999999995,7,0.246,0.47,null,null,null,null,null,null,{"$f":"ROUNDUP(LARGE(X6:X35,1)+0.003,2)","v":0.49},2,3,0.19500000000000001,2.94,7,0.246,1.93,null,null,null,null,null,null,null,null,null,16,0.54947674185359796,-1.7740214907490226E-2,-0.10590015387785334,null,null,null,null,null,null,null,null,null,null,16,1.3158800872911955,0.39840562699451865,0.37102813759902292]
[null,null,null,null,null,null,"Mult Range",3,4,0.19700000000000001,0.59,12,0.32300000000000001,0.68,null,null,null,null,null,null,"Mult Range",3,4,0.19700000000000001,3.02,12,0.32300000000000001,2.1,null,null,null,null,null,null,null,null,null,17,0.56077053836014423,0.19217063811044399,1.1471619849491668,null,null,null,null,null,null,null,null,null,null,17,1.3312786790899995,0.96262813094584265,0.89647860980180949]
[null,null,null,null,null,null,{"$f":"IF(ROUNDDOWN(SMALL(K6:K35,1)*100-0.002,-1)/100<0,0,ROUNDDOWN(SMALL(K6:K35,1)*100-0.002,-1)/100)","v":0.4},4,5,0.20300000000000001,0.69,13,0.33800000000000002,0.5,null,null,null,null,null,null,{"$f":"IF(ROUNDDOWN(SMALL(Y6:Y35,1)*100-0.005,-1)/100<0,0,ROUNDDOWN(SMALL(Y6:Y35,1)*100-0.005,-1)/100)","v":1.4},4,5,0.20300000000000001,3.39,13,0.33800000000000002,1.47,null,null,null,null,null,null,null,null,null,18,0.5685633395732046,0.37258579690750859,2.224149675241442,null,null,null,null,null,null,null,null,null,null,18,1.3681373414408817,1.381821286511578,1.2868658063309191]
[null,null,null,null,null,null,{"$f":"ROUNDUP(LARGE(K6:K35,1)*100+0.005,-1)/100","v":1.5},5,6,0.222,0.83,18,0.48199999999999998,1.43,null,null,null,null,null,null,{"$f":"ROUNDUP(LARGE(Y6:Y35,1)*100+0.005,-1)/100","v":5.3},5,6,0.222,3.73,"","","",null,null,null,null,null,null,null,null,null,19,0.57399678133857801,-0.14291701686193975,-0.85314265674723877,null,null,null,null,null,null,null,null,null,null,19,1.411440300908434,-0.19040682492555194,-0.17732251969233034]
[null,null,null,null,null,null,{"$f":"MATCH(LARGE(I9:I35,1),I9:I35)+8","v":23},6,8,0.251,0.83,"","","",null,null,null,null,null,null,{"$f":"MATCH(LARGE(W9:W35,1),W9:W35)+8","v":23},6,8,0.251,3.29,"","","",null,null,null,null,null,null,null,null,null,20,0.58038455640723741,-6.2202738225419218E-2,-0.37131903892068763,null,null,null,null,null,null,null,null,null,null,20,1.4882259111054053,-7.7334821996494441E-2,-7.2020556520166951E-2]
[null,null,null,null,null,null,"SDE Index",7,9,0.26300000000000001,0.96,"","","",null,null,null,null,null,null,"SDE Index",7,9,0.26300000000000001,3.68,"","","",null,null,null,null,null,null,null,null,null,21,0.59378457689598663,0.25492391018888427,1.5217674338741256,null,null,null,null,null,null,null,null,null,null,21,1.8295201967825694,0.25192776701833575,0.23461588861439367]
[null,null,null,null,null,null,{"$f":"ROUND((G41-G40)/12,2)","v":0.03},8,10,0.27400000000000002,0.83,"","","",null,null,null,null,null,null,{"$f":"ROUND((U41-U40)/12,2)","v":0.03},8,10,0.27400000000000002,3.03,"","","",null,null,null,null,null,null,null,null,null,22,0.59454679619160955,-0.29692990897389188,-1.7725221038892571,null,null,null,null,null,null,null,null,null,null,22,1.8644524546086902,-1.140265310520177,-1.0619089838730955]
[null,null,null,null,null,null,"Mult Index",9,11,0.29399999999999998,0.93,"","","",null,null,null,null,null,null,"Mult Index",9,11,0.29399999999999998,3.16,"","","",null,null,null,null,null,null,null,null,null,23,0.59537937864998347,-5.2155079584562891E-2,-0.31133957408739699,null,null,null,null,null,null,null,null,null,null,23,1.9066447904396213,-0.59678563551004382,-0.55577594262288688]
[null,null,null,null,null,null,{"$f":"ROUNDUP((G44-G43)/5,1)*0.5","v":0.15000000000000002},10,14,0.34100000000000003,1.06,"","","",null,null,null,null,null,null,{"$f":"ROUNDUP((U44-U43)/5,1)*0.5","v":0.39999999999999997},10,14,0.34100000000000003,3.11,"","",""]
[null,null,null,null,null,null,null,11,15,0.42799999999999999,1.28,"","","",null,null,null,null,null,null,null,11,15,0.42799999999999999,2.99,"","",""]
[null,null,null,null,null,null,null,12,16,0.45200000000000001,{"$f":"IF(ISERROR(VLOOKUP($H51,$H$6:$K$35,1,0)),\"\",VLOOKUP($H51,$H$6:$K$35,4,0))","v":1.07},"","","",null,null,null,null,null,null,null,12,16,0.45200000000000001,2.36,"","",""]
[null,null,null,null,null,null,null,13,17,0.45400000000000001,1.22,"","",{"$f":"IF(ISERROR(VLOOKUP($H52,$G$6:$K$35,1,0)),\"\",VLOOKUP($H52,$G$6:$K$35,5,0))","v":""},null,null,null,null,null,null,null,13,17,0.45400000000000001,2.69,"","",""]
[null,null,null,null,null,null,null,14,"","","","","","",null,null,null,null,null,null,null,14,18,0.48199999999999998,2.96,"",{"$f":"IF(ISERROR(VLOOKUP($V53,$U$6:$X$35,1,0)),\"\",VLOOKUP($V53,$U$6:$X$35,4,0))","v":""},""]
[null,null,null,null,null,null,null,15,"","","","","","",null,null,null,null,null,null,null,15,"","","","","",""]
[null,null,null,null,null,null,null,16,"","","","",{"$f":"IF(ISERROR(VLOOKUP($H55,$G$6:$K$35,3,0)),\"\",CONCATENATE(\"#\",VLOOKUP($H55,$G$6:$K$35,3,0),\"   \",           ROUND( VLOOKUP($H55,$G$6:$K$35,4,0),2),\"%\"))","v":""},"",null,null,null,null,null,null,null,16,"","","",{"$f":"IF(ISERROR(VLOOKUP($H55,$G$6:$V$35,1,0)),\"\",VLOOKUP($H55,$G$6:$Y$35,3,0))","v":""},{"$f":"IF(ISERROR(VLOOKUP($H55,$G$6:$Y$35,3,0)),\"\",CONCATENATE(\"#\",VLOOKUP($H55,$G$6:$Y$35,3,0),\"   \",           ROUND( VLOOKUP($H55,$G$6:$Y$35,4,0),2),\"%\"))","v":""},{"$f":"IF(ISERROR(VLOOKUP($H55,$G$6:$Y$35,1,0)),\"\",VLOOKUP($H55,$G$6:$Y$35,5,0))","v":""},null,null,null,null,null,null,null,null,null,"SUMMARY OUTPUT",null,null,null,null,null,null,null,null,null,null,null,null,null,"SUMMARY OUTPUT"]
[null,null,null,null,null,null,null,17,"","","",null,"",{"$f":"IF(ISERROR(VLOOKUP($H56,$G$6:$K$35,5,0)),\"\",VLOOKUP($H56,$G$6:$K$35,5,0))","v":""},null,null,null,null,null,null,null,17,"","","",null,"",{"$f":"IF(ISERROR(VLOOKUP($H56,$G$6:$Y$35,5,0)),\"\",VLOOKUP($H56,$G$6:$Y$35,5,0))","v":""}]
[null,null,null,null,null,null,null,18,"",{"$f":"IF(ISERROR(VLOOKUP($H57,$H$6:$K$35,1,0)),\"\",VLOOKUP($H57,$H$6:$K$35,3,0))","v":""},"",null,"","",null,null,null,null,null,null,null,18,"","","",null,"","",null,null,null,null,null,null,null,null,null,"Regression Statistics",null,null,null,null,null,null,null,null,null,null,null,null,null,"Regression Statistics"]
[null,null,null,null,null,null,null,19,"","","",null,"","",null,null,null,null,null,null,null,19,"","","",null,"","",null,null,null,null,null,null,null,null,null,"Multiple R",0.87734750055740962,null,null,null,null,null,null,null,null,null,null,null,null,"Multiple R",0.84836562940241755]
[null,null,null,null,null,null,null,20,"","","",null,"","",null,null,null,null,null,null,null,20,"","","",null,"","",null,null,null,null,null,null,null,null,null,"R Square",0.76973863673433385,null,null,null,null,null,null,null,null,null,null,null,null,"R Square",0.71972424115136002]
[null,null,null,null,null,null,null,21,"","","",null,"","",null,null,null,null,null,null,null,21,"","","",null,"","",null,null,null,null,null,null,{"$f":"J40","v":0.151},{"$f":"IF(AI60=\"\",\"\",AI60^2)","v":2.2800999999999998E-2},{"$f":"K40","v":0.61},"Adjusted R Square",0.73136174285672284,null,null,null,null,null,null,null,null,null,{"$f":"X40","v":0.151},{"$f":"IF(AW60=\"\",\"\",AW60^2)","v":2.2800999999999998E-2},{"$f":"Y40","v":4.0199999999999996},"Adjusted R Square",0.6766048936361847]
[null,null,"R Sq. =",{"$f":"IF($AE$10=\"X\",ROUND(AM59,2),RSQ(K40:K66,J40:J66))","v":0.86011827700049093},null,null,"SDE Range",22,"","","",null,"","",null,null,"R Sq. =",{"$f":"IF($AF$10=\"X\",ROUND(BA59,2),RSQ(Y40:Y66,X40:X66))","v":0.48058415197122939},null,null,"SDE Range",22,"","","",null,"","",null,null,null,null,null,null,{"$f":"J41","v":0.19500000000000001},{"$f":"IF(AI61=\"\",\"\",AI61^2)","v":3.8025000000000003E-2},{"$f":"K41","v":0.56999999999999995},"Standard Error",6.808726173228867E-2,null,null,null,null,null,null,null,null,null,{"$f":"X41","v":0.19500000000000001},{"$f":"IF(AW61=\"\",\"\",AW61^2)","v":3.8025000000000003E-2},{"$f":"Y41","v":2.94},"Standard Error",0.55577105761256251]
[null,null,null,null,null,null,{"$f":"ROUNDDOWN(SMALL(J40:J66,1)-0.003,2)","v":0.14000000000000001},23,"","","",null,"",null,null,null,null,null,null,null,{"$f":"ROUNDDOWN(SMALL(X40:X66,1)-0.003,2)","v":0.14000000000000001},23,"","","",null,"",null,null,null,null,null,null,null,0.19700000000000001,3.8809000000000003E-2,0.59,"Observations",15,null,null,null,null,null,null,null,null,null,0.19700000000000001,3.8809000000000003E-2,3.02,"Observations",16]
[{"$f":"IF($AE$10=\"X\",CONCATENATE(\"Regression Formula = \",ROUND(AM73,2),\"^2 x SDE% + \",ROUND(AM72,2),\" x SDE% + \",ROUND(AM71,2)),CONCATENATE(\"Regression Formula = \",ROUND(SLOPE(K39:K68,J39:J68),2),\" x SDE% + \",ROUND(INTERCEPT(K39:K68,J39:J68),2)))","v":"Regression Formula = 2.1 x SDE% + 0.28"},null,null,null,null,null,{"$f":"ROUNDUP(LARGE(J40:J66,1)+0.003,2)","v":0.46},24,"","","",null,null,null,{"$f":"IF($AF$10=\"X\",CONCATENATE(\"Regression Formula = \",ROUND(BA73,2),\"^2 x SDE% + \",ROUND(BA72,2),\" x SDE% + \",ROUND(BA71,2)),CONCATENATE(\"Regression Formula = \",ROUND(SLOPE(Y40:Y66,X40:X66),2),\" x SDE% + \",ROUND(INTERCEPT(Y40:Y66,X40:X66),2)))","v":"Regression Formula = -2.68 x SDE% + 3.98"},null,null,null,null,null,{"$f":"ROUNDUP(LARGE(X40:X66,1)+0.003,2)","v":0.49},24,"","","",null,null,null,null,null,null,null,null,null,0.20300000000000001,4.1209000000000003E-2,0.69,null,null,null,null,null,null,null,null,null,null,null,0.20300000000000001,4.1209000000000003E-2,3.39]
[null,null,null,null,null,null,"Mult Range",25,"","","",null,null,null,null,null,null,null,null,null,"Mult Range",25,"","","",null,null,null,null,null,null,null,null,null,0.222,4.9284000000000001E-2,0.83,"ANOVA",null,null,null,null,null,null,null,null,null,null,0.222,4.9284000000000001E-2,3.73,"ANOVA"]
[null,null,"Subject SDE% =",{"$f":"Valuation!$N$6","v":0.32502078137988361},null,null,{"$f":"IF(ROUNDDOWN(SMALL(K40:K66,1)*100,-1)/100-0.002<0,0,ROUNDDOWN(SMALL(K40:K66,1)*100,-1)/100-0.002)","v":0.498},26,"","","",null,null,null,null,null,"Subject SDE% =",{"$f":"Valuation!$N$6","v":0.32502078137988361},null,null,{"$f":"ROUNDDOWN(SMALL(Y40:Y66,1)*100-0.005,-1)/100","v":2.2999999999999998},26,"","","",null,null,null,null,null,null,null,null,null,0.251,6.3001000000000001E-2,0.83,null,"df","SS","MS","F","Significance F",null,null,null,null,null,0.251,6.3001000000000001E-2,3.29,null,"df","SS","MS","F","Significance F"]
[null,null,null,null,null,null,{"$f":"ROUNDUP(LARGE(K40:K66,1)*100,-1)/100+0.005","v":1.3049999999999999},27,"","",{"$f":"IF(ISERROR(VLOOKUP($H66,$H$6:$K$35,1,0)),\"\",VLOOKUP($H66,$H$6:$K$35,4,0))","v":""},null,null,null,null,null,null,null,null,null,{"$f":"ROUNDUP(LARGE(Y40:Y66,1)*100+0.005,-1)/100","v":4.0999999999999996},27,"","","",null,null,null,null,null,null,null,null,null,0.26300000000000001,6.9169000000000008E-2,0.96,"Regression",2,0.18596670568237686,9.298335284118843E-2,20.057345943346323,1.4904809494610183E-4,null,null,null,null,null,0.26300000000000001,6.9169000000000008E-2,3.68,"Regression",2,10.311356424356493,5.1556782121782465,16.691445548846975,2.5662915333467745E-4]
[null,null,"Predicted Multiplier =",{"$f":"IF($AE$10=\"X\",ROUND(AM73*D65^2+AM72*D65+AM71,2),    ROUND(ROUND(SLOPE(K40:K66,J40:J66),2)*D65+ROUND(INTERCEPT(K40:K66,J40:J66),2),2))","v":0.96},null,null,{"$f":"MATCH(LARGE(I40:I66,1),I40:I66)+39","v":52},null,null,null,null,null,null,null,null,null,"Predicted Multiplier =",{"$f":"IF($AF$10=\"X\",ROUND(BA73*R65^2+BA72*R65+BA71,2),    ROUND(ROUND(SLOPE(Y40:Y66,X40:X66),2)*R65+ROUND(INTERCEPT(Y40:Y66,X40:X66),2),2))","v":3.11},null,null,{"$f":"MATCH(LARGE(W40:W66,1),W40:W66)+39","v":53},null,null,null,null,null,null,null,null,null,null,null,null,null,0.27400000000000002,7.5076000000000018E-2,0.83,"Residual",12,5.5630502522414166E-2,4.6358752102011805E-3,null,null,null,null,null,null,null,0.27400000000000002,7.5076000000000018E-2,3.03,"Residual",13,4.015459090237222,0.30888146847978631]
[null,null,null,null,null,null,"SDE Index",null,null,null,null,null,null,null,null,null,null,null,null,null,"SDE Index",null,null,null,null,null,null,null,null,null,null,null,null,null,0.29399999999999998,8.6435999999999985E-2,0.93,"Total",14,0.24159720820479103,null,null,null,null,null,null,null,null,0.29399999999999998,8.6435999999999985E-2,3.16,"Total",15,14.326815514593715]
[null,null,null,null,null,null,{"$f":"ROUND((G63-G62)/12,2)","v":0.03},null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"ROUND((U63-U62)/12,2)","v":0.03},null,null,null,null,null,null,null,null,null,null,null,null,null,0.34100000000000003,0.11628100000000002,1.06,null,null,null,null,null,null,null,null,null,null,null,0.34100000000000003,0.11628100000000002,3.11]
[null,null,null,null,null,null,"Mult Index",null,null,null,null,null,null,null,null,null,null,null,null,null,"Mult Index",null,null,null,null,null,null,null,null,null,null,null,null,null,0.42799999999999999,0.18318399999999999,1.28,null,"Coefficients","Standard Error","t Stat","P-value","Lower 95%","Upper 95%",null,null,null,null,0.42799999999999999,0.18318399999999999,2.99,null,"Coefficients","Standard Error","t Stat","P-value","Lower 95%","Upper 95%"]
[null,null,null,null,null,null,{"$f":"ROUNDUP((G66-G65)/5,1)*0.5","v":0.1},null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"ROUNDUP((U66-U65)/5,1)*0.5","v":0.2},null,null,null,null,null,null,null,null,null,null,null,null,null,0.45200000000000001,0.20430400000000001,1.07,"Intercept",0.10999681150456304,6.0615788651129023E-2,1.814656114393626,9.4637640296519512E-2,-2.2073646488914064E-2,0.24206726949804014,null,null,null,null,0.45200000000000001,0.20430400000000001,2.36,"Intercept",4.232251550384154,0.60783221558262024,6.9628615296861982,9.8746209080450252E-6,2.9191098834511262,5.5453932173171818]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,0.45400000000000001,0.20611600000000002,1.22,"X Variable 1",2.0110566755281236,0.64964314626740671,3.0956328671869504,9.2648634337600573E-3,0.59560585373531394,3.4265074973209333,null,null,null,null,0.45400000000000001,0.20611600000000002,2.69,"X Variable 1",-11.260723226715378,5.8230876738596464,-1.9338062308877395,7.5208323478334255E-2,-23.84073932115659,1.3192928677258351]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"","","","X Variable 2",-2.4422236884962074,1.4235137932407156,-1.7156305053682248,0.1119102446123907,-5.5437938044173407,0.65934642742492588,null,null,null,null,0.48199999999999998,0.23232399999999997,2.96,"X Variable 2",9.1882381616154412,11.988698199838701,0.76640832961656014,0.45712546013176403,-16.711769661107994,35.088245984338876]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"","","",null,null,null,null,null,null,null,null,null,null,null,"","",""]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"","","",null,null,null,null,null,null,null,null,null,null,null,"","",""]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"","","",null,null,null,null,null,null,null,null,null,null,null,"","",""]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"","","","RESIDUAL OUTPUT",null,null,null,null,null,null,null,null,null,null,"","","","RESIDUAL OUTPUT"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"","","",null,null,null,null,null,null,null,null,null,null,null,"","",""]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"","","","Observation","Predicted Y","Residuals","Standard Residuals",null,null,null,null,null,null,null,"","","","Observation","Predicted Y","Residuals","Standard Residuals"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"","","",1,0.17016115377956739,6.2196779675444042E-2,0.98667795584981866,null,null,null,null,null,null,null,"","","",1,3.8091693823140673,0.83407469754973107,1.6120665752399259]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"","","",2,0.1843489212851642,-4.1917341393795104E-3,-6.649687803276684E-2,null,null,null,null,null,null,null,"","","",2,3.2669984901793443,-0.60033182351267778,-1.160297596343185]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"","","",3,0.2754906610525073,-2.8195452397174997E-2,-0.44728732710399577,null,null,null,null,null,null,null,"","","",3,3.0338536503857529,-0.58519888010017862,-1.1310492420507536]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"","","",4,0.31291240608798448,-2.4625502961993506E-2,-0.39065432408402168,null,null,null,null,null,null,null,"","","",4,2.9788283281575416,-0.28961529945825992,-0.55975699215707875]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"","","",5,0.32156143107228358,1.1413621104907068E-2,0.18106352771637538,null,null,null,null,null,null,null,"","","",5,2.9466978065808731,-0.45279006691633938,-0.875134726686705]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"","","",6,0.32657713659331705,-8.8338042101875902E-3,-0.14013780015569893,null,null,null,null,null,null,null,"","","",6,2.3643520840157946,0.93811705178667459,1.8131555210710015]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"","","",7,0.33151492220346856,-7.0951541921778438E-2,-1.1255618492320805,null,null,null,null,null,null,null,"","","",7,2.3476364315056961,6.1454477585213052E-2,0.11877678282890999]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,8,0.37355946368923953,-0.11980006519299891,-1.900485588677052,null,null,null,null,null,null,null,null,null,null,8,2.3207027200574926,0.38002720694980674,0.7345015498075842]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,9,0.41451919907033946,6.7298982747842351E-2,1.0676183409320419,null,null,null,null,null,null,null,null,null,null,9,2.0920515313998131,-0.11363426521276287,-0.21962781186096555]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,10,0.41817610700337893,0.1316010103814651,2.0876935524399838,null,null,null,null,null,null,null,null,null,null,10,1.6774691893163169,-0.66019033581439657,-1.2759897606165598]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,11,0.44789120299028545,1.742182577451995E-2,0.27637655087730723,null,null,null,null,null,null,null,null,null,null,11,1.6234178101908507,9.086790409486345E-2,0.17562588984387995]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,12,0.49881586516023457,3.2920661785873162E-2,0.52224715565029245,null,null,null,null,null,null,null,null,null,null,12,1.5260109047409094,0.76789590529493279,1.4841588239352579]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,13,0.51558966974707521,-8.4509905270436947E-2,-1.3406491624873864,null,null,null,null,null,null,null,null,null,null,13,1.4019386131149993,-0.18090513713211731,-0.3496462915331312]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,14,0.5191733446145641,-9.9152643274591501E-4,-1.5729387903005088E-2,null,null,null,null,null,null,null,null,null,null,14,1.3358896312386268,7.5001457870284005E-2,0.14495985033731504]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,15,0.523977648008777,1.9246651056643582E-2,0.30532523421017882,null,null,null,null,null,null,null,null,null,null,15,1.1563037263977809,-0.43211658230926764,-0.83517783358504083]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,16,1.1425154656050758,0.16734368932450172,0.32343526176955972]

{"sheet":"Valuation","index":2,"n_rows":35,"n_cols":18,"rows_kept":35,"cut":false,"hidden":false,"merged":[[33,15,33,18],[34,16,34,17],[23,15,23,18],[16,15,17,18],[18,15,18,18],[28,15,28,16],[28,17,28,18],[29,15,29,16],[30,15,30,18],[31,15,31,16],[31,17,31,18],[25,15,25,16],[25,17,25,18],[26,15,26,16],[26,17,26,18],[27,15,27,16],[9,1,10,13],[12,3,12,9],[27,17,27,18],[22,15,22,16],[20,17,20,18],[21,17,21,18],[22,17,22,18],[24,15,24,16],[24,17,24,18],[26,12,26,13],[21,7,21,9],[26,7,26,9],[19,17,19,18],[19,15,19,16],[20,15,20,16],[21,15,21,16],[6,3,6,6],[6,11,6,12],[7,3,7,6],[7,11,7,12],[8,4,8,6],[28,1,28,2],[28,3,28,4],[28,5,28,11],[28,12,28,13],[13,3,13,9],[22,7,22,8],[27,7,27,8],[24,3,24,11],[22,5,22,6],[27,5,27,6],[12,10,13,10],[12,11,13,11],[19,3,19,11],[22,12,22,13],[27,12,27,13],[21,12,21,13],[3,14,4,14],[4,3,4,6],[4,11,4,12],[5,3,5,6],[5,11,5,12],[0,3,0,11],[0,12,0,13],[2,8,3,10],[3,1,3,2],[3,3,3,6],[3,11,3,12],[1,11,1,12],[1,3,1,6]]}
[null,null,null,{"$f":"D6","v":"ABC Plumbing Company"}]
[null,null,null,"Company Information",null,null,null,null,null,null,null,"Financial Data"]
[null,null,null,null,null,null,null,null,"Date of Valuation /                                  Financial Statement Date:"]
[null,null,null,"2013-03-08",null,null,null,null,null,null,null,"2012-12-31",null,null,"Data Entry Instructions"]
[null,null,"Prepared For:","C. Fred Hall, III",null,null,null,null,null,null,"Annual Revenues  =",1203000,null,"SDE%"]
[null,null,"Company Name: ","ABC Plumbing Company",null,null,null,null,null,null,"Cash Flow (SDE)  =",391000,null,{"$f":"IF(L6=0,\"\",L6/L5)","v":0.32502078137988361}]
[null,null,"Address: ","123 Any Street",null,null,null,null,null,null,"Current Inventory  =",3400]
[null,null,"City, State:","Anytown, CA",null,null,null,null,null,null,"Current Fixtures  =",350000,null,null,{"$f":"IF(G13=\"\",\"\",CONCATENATE(\" ** Multiplier Formulas using Subject's SDE% of \",ROUND(G13,3)*100,\"%  (= \",ROUND(G13,3),\")\"))","v":""}]
[null,null,"SIC Code:",1711,"Plumbing Contractors"]
[null,"Statistical Analysis of Sold Comparables"]
[]
[]
[null,null,null,{"$f":"CONCATENATE(D6,\"'s SDE % is \",IF(L6=0,\"\",ROUND(L6/L5,3)*100),\"%\")","v":"ABC Plumbing Company's SDE % is 32.5%"},null,null,null,null,null,null,"Revenue    Multiplier Range","Cash Flow Multiplier Range"]
[null,null,null,{"$f":"IF(N6<AVERAGE(I15,I15,I16),\"The Subject is in the Lower Range of SDE%.\",IF(N6<AVERAGE(I15,I16,I16),\"The Subject is between the Lower to Middle Range of SDE%.\",IF(N6<AVERAGE(I16,I16,I17),\"The Subject is in the Middle Range of SDE%.\",IF(N6<AVERAGE(I16,I17,I17),\"The Subject is between the Mid to Upper Range of SDE%.\",\"The Subject is in the Upper Range of SDE%\"))))","v":"The Subject is between the Mid to Upper Range of SDE%."}]
[null,null,null,null,null,null,null,"The Lowest 16% of Companies have SDE% of Less Than",{"$f":"ROUND(AVERAGE(Regression!$J$40:$J$66) -   STDEV(Regression!$J$40:$J$66),3)","v":0.184},"=",{"$f":"(I15*SLOPE(Regression!$K$40:$K$66,Regression!$J$40:$J$66)+INTERCEPT(Regression!$K$40:$K$66,Regression!$J$40:$J$66))","v":0.66666732423694453},{"$f":"(I15*SLOPE(Regression!Y40:Y66,Regression!X40:X66)+INTERCEPT(Regression!Y40:Y66,Regression!X40:X66))","v":3.4816565162175439}]
[null,null,null,null,null,null,null,"The Mid Range of Companies have SDE% of",{"$f":"ROUND(AVERAGE(Regression!J40:J66),3)","v":0.28699999999999998},"=",{"$f":"(I16*SLOPE(Regression!$K$40:$K$66,Regression!$J$40:$J$66)+INTERCEPT(Regression!$K$40:$K$66,Regression!$J$40:$J$66))","v":0.88327831662008882},{"$f":"(I16*SLOPE(Regression!Y41:Y67,Regression!X41:X67)+INTERCEPT(Regression!Y41:Y67,Regression!X41:X67))","v":3.1577333810614632}]
[null,null,null,null,null,null,null,"The Highest 16% of Companies have SDE% of More Than",{"$f":"ROUND(AVERAGE(Regression!$J$40:$J$66) +   STDEV(Regression!$J$40:$J$66),3)","v":0.38900000000000001},"=",{"$f":"(I17*SLOPE(Regression!$K$40:$K$66,Regression!$J$40:$J$66)+INTERCEPT(Regression!$K$40:$K$66,Regression!$J$40:$J$66))","v":1.0977862896597075},{"$f":"(I17*SLOPE(Regression!Y42:Y68,Regression!X42:X68)+INTERCEPT(Regression!Y42:Y68,Regression!X42:X68))","v":2.9436921277699248},null,null,null,"Values Using Other Methodologies                                         (From Samples Worksheet)"]
[]
[null,null,null,null,null,"REVENUE MULTIPLIER VALUE",null,null,null,null,null,null,null,null,null,"Revenue Multipliers"]
[null,null,null,{"$f":"IF(N6=\"\",\"\",CONCATENATE(\"Regression Formula:   SDE% x \",ROUND(SLOPE(Regression!K40:K66,Regression!J40:J66),3),\" + \",ROUND(INTERCEPT(Regression!K40:K66,Regression!J40:J66),3),\"   =  .\",ROUND(D23,2)))","v":"Regression Formula:   SDE% x 2.103 + 0.28   =  .0.96"},null,null,null,null,null,null,null,null,null,null,null,"Median",null,"Harmonic Mean"]
[null,null,null,null,null,null,null,null,null,null,{"$f":"CONCATENATE(\"R Sq. = \",ROUND(Regression!D61,2))","v":"R Sq. = 0.86"},null,null,null,null,{"$f":"Sample!M38","v":0.83},null,{"$f":"Sample!M41","v":0.78}]
[null,null,null,"Multiplier",null,"Revenue",null,"Predicted Value",null,null,"Weight",null,"Weighted Value",null,null,{"$f":"L5","v":1203000},null,{"$f":"L5","v":1203000}]
[null,null,null,{"$f":"ROUND(Regression!D67,2)","v":0.96},"x",{"$f":"L5","v":1203000},null,{"$f":"ROUND(F23*D23,-3)","v":1155000},null,"x",{"$f":"Regression!D61/(Regression!D61+Regression!R61)","v":0.64154301388129553},"=",{"$f":"IF($P$22=\"x\",\"\",K23*H23)","v":740982.18103289639},null,null,{"$f":"P21*P22","v":998490},null,{"$f":"R21*R22","v":938340}]
[null,null,null,null,null,"CASH FLOW MULTIPLIER VALUE",null,null,null,null,null,null,null,null,null,"Cash Flow Multipliers"]
[null,null,null,{"$f":"IF(N6=\"\",\"\",CONCATENATE(\"Regression Formula:   SDE%  x \",ROUND(SLOPE(Regression!Y40:Y66,Regression!X40:X66),3),\" + \",ROUND(INTERCEPT(Regression!Y40:Y66,Regression!X40:X66),3),\"    =   \",ROUND(D28,2)))","v":"Regression Formula:   SDE%  x -2.681 + 3.975    =   3.11"},null,null,null,null,null,null,null,null,null,null,null,"Median",null,"Harmonic Mean"]
[null,null,null,null,null,null,null,null,null,null,{"$f":"CONCATENATE(\"R Sq. = \",ROUND(Regression!R61,2))","v":"R Sq. = 0.48"},null,null,null,null,{"$f":"Sample!N38","v":3.03},null,{"$f":"Sample!N41","v":2.83}]
[null,null,null,"Multiplier",null,"Cash Flow",null,"Predicted Value",null,null,"Weight",null,"Weighted Value",null,null,{"$f":"L6","v":391000},null,{"$f":"L6","v":391000}]
[null,null,null,{"$f":"ROUND(Regression!R67,2)","v":3.11},"x",{"$f":"L6","v":391000},null,{"$f":"ROUND(D28*F28,-2)","v":1216000},null,"x",{"$f":"Regression!R61/(Regression!R61+Regression!D61)","v":0.35845698611870458},"=",{"$f":"IF($P$22=\"x\",\"\",K28*H28)","v":435883.69512034475},null,null,{"$f":"P26*P27","v":1184730},null,{"$f":"R26*R27","v":1106530}]
[null,null,null,null,null,{"$f":"IF(L7>0,\"Probable Selling Price Including Inventory  = \",\"Probable Selling Price  = \")","v":"Probable Selling Price Including Inventory  = "},null,null,null,null,null,null,{"$f":"DOLLAR(ROUND(SUM($M$23:$N$28),IF(SUM(M23:N28)>999999,-4,-3)),0)","v":"$1,180,000"},null,null,{"$f":"AVERAGE(P28,P23)","v":1091610},null,{"$f":"AVERAGE(R28,R23)","v":1022435}]
[]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Spread between Above Multiplier Values"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"ABS(P23-P28)","v":186240},null,{"$f":"ABS(R23-R28)","v":168190}]
[]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Spread between Regression Values"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"ABS(H23-H28)","v":61000}]