{"text_format":"1","workbook":"xlsx","n_sheets":4,"sheets":["Landowner template","Scoring Template","Formulas","Revision Notes"],"not_rendered":{"charts":0,"images":0,"macros":1,"external_links":0,"defined_names":5,"comments":4,"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":"Landowner template","index":0,"n_rows":75,"n_cols":4,"rows_kept":75,"cut":false,"hidden":false,"merged":[[27,0,27,1],[0,0,0,3],[37,0,38,2],[74,0,74,3],[26,0,26,1],[23,0,23,1],[34,0,34,1],[35,0,35,1]]}
["SADC Statewide Formula Value Calculation"]
[]
["Farm Name:",{"$f":"'Scoring Template'!B3","v":0}]
["SADC ID:",{"$f":"'Scoring Template'!B4","v":0},"Total Score",{"$f":"'Scoring Template'!F4","v":0}]
["Farm Address:",{"$f":"'Scoring Template'!B5","v":0},"Maximum Score","Farm Score"]
["Agricultural Resource Factors - Max Add-on  % =",null,20,{"$f":"'Scoring Template'!F6","v":0}]
["Natural Resource Factors - Max Add-on % =",null,10,{"$f":"'Scoring Template'!F7","v":0}]
["Local Importance Factors - Max Add-on %=",null,15,{"$f":"'Scoring Template'!F8","v":0}]
[null,"Max Allowable Score of all of the above",30,{"$f":"'Scoring Template'!F9","v":0}]
["Additional Restrictions - Max Add-on % =",null,10,{"$f":"'Scoring Template'!F10","v":0}]
[]
["Agricultural Resource Factors",null,null,"Points"]
["Soils",null,null,{"$f":"'Scoring Template'!F13","v":0}]
["Size",null,null,{"$f":"'Scoring Template'!F14","v":0}]
["Tillability",null,null,{"$f":"'Scoring Template'!F15","v":0}]
["Contiguity to Preserved Farms",null,null,{"$f":"'Scoring Template'!F16","v":0}]
["Agricultural Water Availability (Y/N)",null,{"$error":"#N/A"},{"$f":"'Scoring Template'!F19","v":""}]
[null,"Top 3 Scores Max=",30,"Top 3 Scores"]
[null,"Each Point = %",{"$f":"(C6/C18)","v":0.66666666666666663},{"$f":"'Scoring Template'!F21","v":0}]
[null,null,null,"Agricultural Resource %"]
[null,null,null,{"$f":"'Scoring Template'!F23","v":0}]
[]
["Natural Resource Factors",null,null,"Points"]
["Groundwater Recharge Capability",null,null,{"$f":"'Scoring Template'!F26","v":0}]
["Upland Forest ",null,null,{"$f":"'Scoring Template'!F27","v":0}]
["Wetland & Open Water/Flood Hazard Mitigation",null,null,{"$f":"'Scoring Template'!F30","v":0}]
["Contiguity to Preserved Open Space",null,null,{"$f":"'Scoring Template'!F33","v":0}]
["Surface Water Quality Classification",null,null,{"$f":"'Scoring Template'!F36","v":0}]
[null,"Top 3 Scores Max=",30,"Top 3 Scores"]
[null,"Each Point = %",{"$f":"(C7/C29)","v":0.33333333333333331},{"$f":"'Scoring Template'!F38","v":0}]
[null,null,null,"Natural Resource  %"]
[null,null,null,{"$f":"'Scoring Template'!F40","v":0}]
[]
["Local Importance Factors",null,null,"Percent"]
["Risk of Conversion ",null,null,{"$f":"'Scoring Template'!F43","v":0}]
["Buffer to Critical Infrastructure",null,null,{"$f":"'Scoring Template'!F44","v":0}]
["Property of Unique Importance",null,null,{"$f":"'Scoring Template'!F45","v":0}]
[null,null,null,"Local Importance %"]
[null,null,null,{"$f":"'Scoring Template'!F47","v":0}]
[]
["Voluntary Deed Restrictions ",null,null,"Percent "]
["Impervious Cover Limit (10%)",null,null,{"$f":"'Scoring Template'!F50","v":0}]
["House Size Limit (2,500 sqft)",null,null,{"$f":"'Scoring Template'!F51","v":0}]
[null,null,null,"Additional Restrictions %"]
[null,null,null,{"$f":"'Scoring Template'!F53","v":0}]
[]
["Landowner Formula Offer Calculations",null,null,"Value"]
["Per Acre Values"]
["Certified Market Value Unrestricted, per acre",null,null,{"$f":"'Scoring Template'!F57","v":0}]
["Per Acre Formula Easement Value (unadjusted offer, per acre)",null,null,{"$f":"'Scoring Template'!F58","v":""}]
["Per Acre Value of Voluntary Deed Restrictions (each)",null,null,{"$f":"'Scoring Template'!F59","v":""}]
["Per Acre Value after Voluntary Deed Restrictions",null,null,{"$f":"'Scoring Template'!F60","v":""}]
["Net Acres",null,null,{"$f":"'Scoring Template'!F61","v":0}]
["Estimated Easement Values"]
["Estimated Unadjusted Total ",null,null,{"$f":"'Scoring Template'!F63","v":""}]
["Plus:  Adjustment for Voluntary Restrictions (+)",null,null,{"$f":"'Scoring Template'!F64","v":""}]
["Estimated offer before Residential Opportunities reduction",null,null,{"$f":"'Scoring Template'!F65","v":""}]
["Less:  Adjustment for Residential Opportunities (-)",null,null,{"$f":"'Scoring Template'!F66","v":""}]
["Estimated Total Offer After Reduction for Residential Opportunities",null,null,{"$f":"'Scoring Template'!F67","v":""}]
[]
["Legal Disclaimer"]
["Per Acre Base Value"]
["Additional Ag & Natural Resource Value"]
["Local Importance Factors"]
["Per Acre Formula Value w/o Voluntary Deed Restrictions"]
["Voluntary  Deed Restrictions"]
["Total Per Acre Value w/Voluntary Deed Restrictions"]
["Cap Offer (80% - 90% Fee, depending on voluntary restrictions taken)"]
[null,"Potential Max Offer to Landowner per Acre"]
[null,"Pre-adjusted Total Consideration"]
["Adjustment for Requested Residential Opportunities"]
[" Residential Opportunities","Number of opportunities Adjusted"]
[null,"Adjustment = \n4 x Potential Max Offer per opportunity"]
[null,"Total Adjusted Consideration (Net of Residential Opportunity Adjustment)"]
["This scoring template was developed by the New Jersey State Agriculture Development Committee (SADC) to estimate development easement values using the Statewide Formula Valuation methodology for farmland preservation set forth at N.J.A.C. 2:76-26.  Please note that the final development easement consideration will be based upon N.J.A.C. 2:76-6 and -11 through -17A, as applicable, along with the SADC's final approval for the purchase of a development easement or a cost sharing grant.  Scoring template users acknowledge the potential for accuracy limitations in this product.  If data is found to be incorrect prior to preservation, the final formula value is subject to change.  Any questions or concerns about the scoring template or the data upon which it is based should be forwarded to SADC staff."]

{"sheet":"Scoring Template","index":1,"n_rows":84,"n_cols":8,"rows_kept":84,"cut":false,"hidden":false,"merged":[[83,1,83,4],[0,0,0,5],[45,0,46,4],[82,0,82,5],[41,2,41,3],[42,2,42,3],[43,2,43,3],[44,2,44,3],[4,1,4,3],[25,0,25,1],[35,0,35,1],[43,0,43,1]]}
["SADC Statewide Formula Value Calculation"]
[]
["Farm Name:"]
["SADC ID:",null,null,null,"Total Score",{"$f":"SUM(F9:F10)","v":0}]
["Farm Address:",null,null,null,"Maximum Score","Farm Score"]
["Agricultural Resource Factors - Max Add-on  % =",null,null,null,20,{"$f":"F23","v":0}]
["Natural Resource Factors - Max Add-on % =",null,null,null,10,{"$f":"F40","v":0}]
["Local Importance Factors - Max Add-on %=",null,null,null,15,{"$f":"F47","v":0}]
[null,null,"Max Allowable Score of all of the above",null,30,{"$f":"IF(SUM(F6:F8)>30,30,SUM(F6:F8))","v":0}]
["Additional Restrictions - Max Add-on % =",null,null,null,10,{"$f":"F53","v":0}]
[]
["Agricultural Resource Factors",null,"Definition","Raw Value","Subfactor Points","Points"]
["Soils",null,"% Prime *0.1; % SW *0.08; % Unique *0.06 or 0; % Local*0.04.  ","See Report",null,{"$f":"ROUND(Formulas!B2,2)","v":0}]
["Size",null,"Relationship to Census Co. Avg.: >=100% =10; <100 & >=75% = 8; <75 & >= 50% = 6; <50 & >=25%= 4; <25 = 0",{"$f":"ROUND(Formulas!C2,2)/100","v":0},null,{"$f":"ROUND(Formulas!D2,2)","v":0}]
["Tillability",null,"100 & >=90% = 10; <90 & >= 80% = 9; <80 & >= 70% = 8; <70 & >= 60% = 7; < 60 & >= 50% = 6; <50 & >= 40% = 5; < 40 & >= 30% = 4; <30 & >= 20% = 3; <20 & >= 10% = 2; <10 & > 0 = 1; >25 acres= 5 points",{"$f":"ROUND(Formulas!F2,2)/100","v":0},null,{"$f":"ROUND(Formulas!G2,2)","v":0}]
["Contiguity to Preserved Farms",null,null,null,null,{"$f":"ROUND(Formulas!H2,2)","v":0}]
[null,"Adjacency","Preserved Farmland within 100' Farm Buffer. Present = 5; Not Present = 0",{"$f":"IF(E17=5, \"Present\", \"Not Present\")","v":"Not Present"},{"$f":"ROUND(Formulas!I2,2)","v":0}]
[null,"Project Area Infill","% Preserved Farmland within 1/2-mile Farm Buffer. >=50% = 5; <50 & >= 30%=4; <30 & >= 20%=3; < 20 & >= 10% = 2; <10% & >0%=1",{"$f":"ROUND(Formulas!J2,2)/100","v":0},{"$f":"Formulas!K2","v":0}]
["Agricultural Water Availability (Y/N)",null,"Applicant farm has an Agricultural Water Useage Certification or Registration",{"$f":"_xlfn.IFS(Formulas!L2=5,\"Yes-GIS\",Formulas!B7=\"Yes\",\"Yes-User Entered\",Formulas!B7=\"No\",\"No\",Formulas!B7=\"\",\"\")","v":""},null,{"$f":"_xlfn.IFS(D19=\"Yes-GIS\",5,D19=\"Yes-User Entered\",5,D19=\"NO\",0,D19=\"\",\"\")","v":""}]
[null,null,"Top 3 Scores Max=",null,30,"Top 3 Scores"]
[null,null,"Each Point = %",null,{"$f":"ROUND((E6/E20),2)","v":0.67},{"$f":"SUM(LARGE(('Scoring Template'!F13:F16,F19),{1,2,3}))","v":0}]
[null,null,null,null,null,"Agricultural Resource %"]
[null,null,null,null,null,{"$f":"ROUND(F21*E21,2)","v":0}]
[]
["Natural Resource Factors",null,"Definition","Raw Value","Subfactor Points","Points"]
["Groundwater Recharge Capability",null,"% 24\"-16\" *0.1; % 15\"-11\" *0.08; %  10\"-8\" *0.06; % 7\"-1\" *0.04","See Report",null,{"$f":"ROUND(Formulas!M2,2)","v":0}]
["Upland Forest ",null,"5 Contiguous Acre Minimum.  Full points if state forester approved woodland management or forest stewardship plan, points / 2 if not.",null,null,{"$f":"IF(D29=\"Yes\",E28,E28/2)","v":0}]
[null,"Forest Score",">=80% = 10; <80 & >=70% = 9; <70 & >=60% = 8; <60 & >=50% = 7; <50 & >=40% = 6; <40 & >= 30% = 5; <30 & >= 20% = 4; <20 & >=10% = 3; >0 = 2; >25 acres = 5.",{"$f":"ROUND(Formulas!AA2,2)/100","v":0},{"$f":"ROUND(Formulas!AB2,2)","v":0}]
[null,"Forest Plan (Y/N)","Yes = 100% forest score.  No = 50% forest score",null,{"$f":"IF(D29=\"yes\",\"100% Forest Score\",\"50% Forest Score\")","v":"50% Forest Score"}]
["Wetland & Open Water/Flood Hazard Mitigation",null,"Wetlands (Excl Mod Ag) & Flood Hazard Mitigation (5 points max each)",null,null,{"$f":"ROUND(Formulas!N2,2)","v":0}]
[null,"Open Water / Wetlands (Excl Ag. Mod Wetlands) ",">=50% = 5; <50 & >= 40%=4; <40 & >=30%=3; < 30 & >= 20%=2 & <20 & >0%=1; >25 acres =2.5",{"$f":"ROUND(Formulas!P2,4)/100","v":0},{"$f":"ROUND(Formulas!Q2,2)","v":0}]
[null,"Flood Hazard Mitigation",">=50% = 5; <50 & >= 40%=4; <40 & >=30%=3; < 30 & >= 20%=2 & <20 & >0%=1; >25 acres =2.5",{"$f":"IF(Formulas!T2=2.5,\"Acre Based\",Formulas!S2/100)","v":0},{"$f":"ROUND(Formulas!T2,2)","v":0}]
["Contiguity to Preserved Open Space",null,null,null,null,{"$f":"ROUND(Formulas!V2,2)","v":0}]
[null,"Adjacency","Open Space within 100' Farm Buffer.  Present = 5; Not Present = 0",{"$f":"IF(E34=5,\"Present\",\"Not Present\")","v":"Not Present"},{"$f":"Formulas!W2","v":0}]
[null,"Project Area Infill","% Open Space within 1/2-mile Farm Buffer. >=40% = 5; <40 & >= 30%=4; <30 & >= 20%=3; < 20 & >= 10%=2; <10 & >0%=1",{"$f":"ROUND(Formulas!X2,2)/100","v":0},{"$f":"ROUND(Formulas!Y2,2)","v":0}]
["Surface Water Quality Classification",null,"Outstanding National Resource Waters                                                                                                                              (FW1 or PL) = 10; Category One (C1) = 10; Category 2 (C2) = 5; Not Present = 0",{"$f":"_xlfn.IFS(F36=10, \"Cat 1, FW1, or PL\", F36=5, \"Cat 2\", F36=0,\"Not Present\",F36=\"\",\"\")","v":"Not Present"},null,{"$f":"ROUND(Formulas!U2,2)","v":0}]
[null,null,"Top 3 Scores Max=",null,30,"Top 3 Scores"]
[null,null,"Each Point = %",null,{"$f":"ROUND((E7/E37),2)","v":0.33},{"$f":"SUM(LARGE((F26:F33,F36),{1,2,3}))","v":0}]
[null,null,null,null,null,"Natural Resource  %"]
[null,null,null,null,null,{"$f":"ROUND((F38*E38),2)","v":0}]
[]
["Local Importance Factors",null,"Definition",null,"Y/N","Percent"]
["Risk of Conversion",null,"Within 1 mile of State Growth Areas ",null,{"$f":"IF(F43=5,\"Yes\",\"No\")","v":"No"},{"$f":"Formulas!AC2","v":0}]
["Buffer to Critical Infrastructure",null,"Parcel within 2 miles of a Department of Defence installation or 1/4 Mile of other Critical Infrastructure",null,{"$f":"_xlfn.IFS(Formulas!AD2=5,\"Yes-GIS\",Formulas!B8=\"Yes\",\"Yes-User Entered\",Formulas!B8=\"No\",\"No\",Formulas!AD2=0,\"No\",Formulas!B8=\"\",\"\")","v":"No"},{"$f":"_xlfn.IFS(E44=\"Yes-GIS\",5,E44=\"Yes-User Entered\",5,E44=\"No\",0,E44=\"\",)","v":0}]
["Property of Unique Importance",null,"Determined by the entity holding the easement consistent with the SADC definition",null,null,{"$f":"IF(E45=\"Yes\",5,0)","v":0}]
[null,null,null,null,null,"Local Importance %"]
[null,null,null,null,null,{"$f":"SUM(F43:F45)","v":0}]
[]
["Voluntary Deed Restrictions ",null,null,null,"Y/N","Percent "]
["Impervious Cover Limit (10%)",null,null,null,null,{"$f":"IF(E50=\"Yes\",5,0)","v":0}]
["House Size Limit (2,500 sqft)",null,null,null,null,{"$f":"IF(E51=\"Yes\",5,0)","v":0}]
[null,null,null,null,null,"Additional Restrictions %"]
[null,null,null,null,null,{"$f":"SUM(F50:F51)","v":0}]
[]
["Landowner Formula Offer Calculations",null,null,null,null,"Value"]
["Per Acre Values",null,null,null,null,null,null,"f"]
["Certified Market Value Unrestricted, per acre"]
["Per Acre Formula Easement Value (unadjusted offer, per acre)",null,null,null,null,{"$f":"IF(F57=\"\",\"\",ROUND((F57*(50+F9)%),0))","v":""}]
["Per Acre Value of Voluntary Deed Restrictions (each)",null,null,null,null,{"$f":"IF(F57=\"\",\"\",ROUND(F57*5%,0))","v":""}]
["Per Acre Value after Voluntary Deed Restrictions",null,null,"Number Restrictions selected:",{"$f":"COUNTIF(E50:E51,\"Yes\")","v":0},{"$f":"IF(F57=\"\",\"\",IF(E60=0,F58,((E60*F59)+F58)))","v":""}]
["Net Acres",null,null,null,null,{"$f":"ROUND(Formulas!AE2,2)","v":0}]
["Estimated Easement Values"]
["Estimated Unadjusted Total ",null,null,null,null,{"$f":"IF(F57=\"\",\"\",ROUND(F58*F61,0))","v":""}]
["Plus:  Adjustment for Voluntary Restrictions (+)",null,null,null,null,{"$f":"IF(F57=\"\",\"\",ROUND(F59*F61*COUNTIF(E50:E51,\"YES\"),0))","v":""}]
["Estimated offer before Residential Opportunities reduction",null,null,null,null,{"$f":"IF(F57=\"\",\"\",ROUND((F58*F61)+F64,0))","v":""}]
["Less:  Adjustment for Residential Opportunities (-)",null,null,"Additional opportunites retained:",null,{"$f":"IF(F57=\"\",\"\",ROUND(E66*(4*F58),0))","v":""}]
["Estimated Total Offer After Reduction for Residential Opportunities",null,null,null,null,{"$f":"IF(F57=\"\",\"\",ROUND(F65-F66,0))","v":""}]
[]
["Legal Disclaimer"]
["Per Acre Base Value"]
["Additional Ag & Natural Resource Value"]
["Local Importance Factors"]
["Per Acre Formula Value w/o Voluntary Deed Restrictions"]
["Voluntary  Deed Restrictions"]
["Total Per Acre Value w/Voluntary Deed Restrictions"]
["Cap Offer (80% - 90% Fee, depending on voluntary restrictions taken)"]
[null,null,"Potential Max Offer to Landowner per Acre"]
[null,null,"Pre-adjusted Total Consideration"]
["Adjustment for Requested Residential Opportunities"]
[" Residential Opportunities",null,"Number of opportunities Adjusted"]
[null,null,"Adjustment = \n4 x Potential Max Offer per opportunity"]
[null,null,"Total Adjusted Consideration (Net of Residential Opportunity Adjustment)"]
["This scoring template was developed by the New Jersey State Agriculture Development Committee (SADC) to estimate development easement values using the Statewide Formula Valuation methodology for farmland preservation set forth at N.J.A.C. 2:76-26.  Please note that the final development easement consideration will be based upon N.J.A.C. 2:76-6 and -11 through -17A, as applicable, along with the SADC's final approval for the purchase of a development easement or a cost sharing grant.  Scoring template users acknowledge the potential for accuracy limitations in this product.  If data is found to be incorrect prior to preservation, the final formula value is subject to change.  Any questions or concerns about the scoring template or the data upon which it is based should be forwarded to SADC staff."]
["SFV Score Template: ",{"$f":"Formulas!B3","v":0}]

{"sheet":"Formulas","index":2,"n_rows":9,"n_cols":32,"rows_kept":9,"cut":false,"hidden":true,"merged":[]}
["OBJECTID","Soil Score","Farm Size related to County Average","Size Score","Tillability Acres","Tillability Percent","Tillability Score","Contiguity to Preserved Farms Score","Preserved Farm Adjacency Score","Percent Preserved Farmland within Buffer","Preserved Farm Infill Score","Water Supply Score","Groundwater Recharge Score","Wetlands and Flood Hazard Area Score","Open Water and Wetlands Acres","Open Water and Wetlands Percent","Open Water and Wetlands Score","Flood Hazard Area Acres","Flood Hazard Area Percent","Flood Hazard Area Score","Stream Score","Contiguity to Open Space Score","Adjacency to Open Space Score","Percent Open Space within Buffer","Open Space Infill Score","Upland Forest Acres","Upland Forest Percent","Upland Forest Score","Risk of Conversion/Imminence of Change","Buffer to Critial Infrastructure",null,"acres"]
[]
["FilePathSourceData"]
["FileNameSourceData"]
["WorksheetNameSourceData",{"$f":"(RIGHT((LEFT(B4,LEN(B4)-9)),31))","v":{"$error":"#VALUE!"}}]
[]
["Water Allocation Response"]
["Critical Infrastructure Response"]
[null,"SADCSFV"]

{"sheet":"Revision Notes","index":3,"n_rows":15,"n_cols":3,"rows_kept":15,"cut":false,"hidden":true,"merged":[]}
["Date","Note","Revision"]
[]
[]
["2025-04-17","Updated formula for ag water question to correct an imporper cell reference.  IFS(Formulas!L2(formerly M2)=5,\"Yes-GIS\",Formulas!B7=\"Yes\",\"Yes-User Entered\",Formulas!B7=\"No\",\"No\",Formulas!B7=\"\",\"\")"]
["2025-04-17","Added macro for sadc to populate data into summary workbook."]
["2025-04-21","updated size definition, tillability definition, infill definition"]
["2025-04-21","removed imminecnce of change from risk of conversion, farm value from buffer to critical infrastructure, and amended properties to property of unique importance"]
["2025-04-21","changed definition of buffer to critical infrastructure from 'critical uses' to 'critical infrastructure'"]
["2025-04-21","changed definition of property of unique importance from cadb or aac to entity that holds the easement"]
["2025-04-21","changed groundwater recharge to groundwater recharge capability"]
["2025-04-21","changed Wetlands and Flood Hazard Area to Wetland & Open Water/Flood Hazard Mitigation"]
["2025-04-21","changed Farm Value as Buffer to Critical Infrastructure to  Buffer to Critical Infrastructure"]
["2025-04-21","changed Properties of Unique Importance to Property of Unique Importance"]
["2025-04-23","updated formula for risk of conversion (F43)   now reads =Formulas!AC2"]
["2025-05-01","Updated formula for adjustment for RDSO's  Cell F66 no reads : =IF(F57=\"\",\"\",ROUND(E66*(4*F58),0))  rather than =IF(F57=\"\",\"\",ROUND(E66*(4*F60),0)) which means the pre-deduction excludes additional restriction values"]