{"text_format":"1","workbook":"xlsx","n_sheets":3,"sheets":["General Lic Fee Calculator","Dropdown Lists","Tide Ranges"],"not_rendered":{"charts":0,"images":2,"macros":1,"external_links":0,"defined_names":14,"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":"General Lic Fee Calculator","index":0,"n_rows":45,"n_cols":4,"rows_kept":45,"cut":false,"hidden":false,"merged":[[0,0,0,1],[43,0,43,3],[1,0,2,1],[42,0,42,3],[37,0,37,2],[3,0,3,3],[4,0,4,3],[5,0,5,3],[14,0,14,3],[10,0,10,3],[6,0,6,3],[23,0,23,3],[38,1,38,2]]}
["BRP WW24\nCoastal Structure(s) General License Fee Calculator - Tidal Waters",null,"Transmittal Number:"]
["This Fee Calculator is provided for your convenience.  You can choose to submit your own calculation worksheet or contact the Waterways Regulation Staff at (617) 292-5929 or dep.waterways@massmail.state.ma.us.",null,"Applicant Name:"]
[null,null,"Landowner Name (if not applicant):"]
["Mandatory Baseline General License Processing Fee: $75.00"]
["Directions: Sections that you need to fill out for this Fee Calculator are highlighted in Yellow.\n"]
["Step 1) Remainder of Term Ending on 4/13/2045: Use drop-down list to select the year that you submitted the GL Certification Application.\nStep 2) Tidal Range:  Select your Municipality (Note: The municipality determines the tide range value used for the displacement volume calculation.)\nDisplacement Calculations (Steps 3 & 4)\nStep 3) Pile/Post Sizes:  Select from dropdown menu the closest size of the Piles/Posts.  (If you have varying pile sizes/shapes, add a row for each; if pile size is not available in drop-down menu, pick the closest size.)*\nStep 4)  Number Piles:  You must enter the number of piles proposed.\nStep 5) Structures:  Select from the Dropdown Menu & Add Rows if needed.*\nStep 6) The Length of the proposed structure(s) in units of feet, that is seaward of Mean Low Water.\nStep 7) The Width of the proposed structure(s) in units of feet, that is seaward of Mean Low Water.\n\n*Note: If you add a row in step 3 or step 5 by mistake leave the fields for that row blank so that unnecessary fees are not added into the calculation."]
["Remainder of Term Ending on 4/13/2045 (Step 1)"]
["Select Year You Are Applying \n(You Select the Year)","Remaining Years"]
["Calendar Year - Click for Dropdown Menu -->",{"$f":"VLOOKUP(A9,'Dropdown Lists'!D2:E31,2,FALSE)","v":{"$error":"#N/A"}}]
[]
["Tide Range Calculation (Step 2)"]
["Municipality (You Select the Town)","Tide Range (Feet)"]
["Town - Click for Dropdown Menu ---->",{"$f":"ROUND(VLOOKUP(A13,'Dropdown Lists'!A34:B119,2,FALSE),1)","v":{"$error":"#N/A"}}]
[]
["Displacement Calculation (Steps 3 & 4)"]
["(Step 3) Piles/Posts (You Select the Type)","Displacement Volume (yd3) per Pile/Post","(Step 4) Number of Piles \n(You Enter #)","Total Displacement Volume (yd3)"]
["Piles/Posts- Click for Dropdown Menu ---->",{"$f":"B13*VLOOKUP(A17,'Dropdown Lists'!A2:B12,2,FALSE)","v":{"$error":"#N/A"}},null,{"$f":"C17 * B17","v":{"$error":"#N/A"}}]
[]
[]
[null,null,"Total Displacement Volume (yd3) \nRounded to nearest whole yd3",{"$f":"ROUND(SUM(D17:D18),0)","v":{"$error":"#N/A"}}]
[null,null,"Displacement Fee Rate","$2.00/yd3"]
[null,null,"Total Displacement Fees",{"$f":"IF($D$20*2 >= 2,$D$20*2, 0)","v":{"$error":"#N/A"}}]
[]
["Commonwealth Tideland Occupied (Steps 5, 6, & 7)"]
["(Step 5) Structures (You Select the Type)","(Step 6) Length in feet seaward \nof low water (You Enter #)","(Step 7) Width in feet seaward \nof low water (You Enter #)","Occupation Area (ft2)"]
["Structures - Click for Dropdown Menu ---->",null,null,{"$f":"B26*C26","v":0}]
[]
[]
[null,null,"Structures Occupation Area (ft2)",{"$f":"SUM(D26:D26)","v":0}]
[null,null,"Piles/Posts Occupation Area (ft2)",0]
[]
[null,null,"Total Occupation Area (ft2)",{"$f":"ROUND(SUM(structuresOccupationArea,pilesOccupationArea),1)","v":0}]
[null,null,"Total Occupation Area (yd2)",{"$f":"D32/9","v":0}]
[null,null,"Occupation Fee Rate","$1.00/yd2/year"]
[null,null,"Total Occupation Fee",{"$f":"($D$32/9)*1*B9","v":{"$error":"#N/A"}}]
[]
[]
["Subtotal of Displacement and Occupation Fee",null,null,{"$f":"SUM($D$22,$D$35)","v":{"$error":"#N/A"}}]
[null,"Mandatory Baseline General License Processing Fee",null,75]
[]
["Type/Write in Your Check/Money Order Number",null,"Total Fee Paid ",{"$f":"SUM(FeeSum, 75)","v":{"$error":"#N/A"}}]
[]
["Print this page and submit a copy of this calculator that includes the transmittal number, applicant/landowner name, a copy of your completed General License Certification and your check or money order payable to Commonwealth of Massachusetts and mail to:\nMassachusetts Department of Environmental Protection \nP.O. Box 4062\nBoston, MA 02211"]
["Make an additional copy of this completed calculator, a copy of your check payment and the original GL Certfication Application Form and send to:\nMassDEP's Waterways Regulation Program\nOne Winter Street, 5th Floor\nBoston, MA 02108"]
["Version 2.5, June 29, 2017"]

{"sheet":"Dropdown Lists","index":1,"n_rows":119,"n_cols":5,"rows_kept":119,"cut":false,"hidden":true,"merged":[]}
["Piles/Posts- Click for Dropdown Menu ---->","Unit Volume (cy/ft)","Area (ft2)","Calendar Year - Click for Dropdown Menu -->","Term (years)"]
["Piles/Posts- Click for Dropdown Menu ---->",0,0,2015,30]
["2-inch Diameter Pipe Circular",8.0999999999999996E-4,2.1999999999999999E-2,2016,29]
["4-inch Diameter Pipe Circular",3.2000000000000002E-3,8.6999999999999994E-2,2017,28]
["6-inch Diameter Circular",7.3000000000000001E-3,0.2,2018,27]
["8-inch Diameter Circular",1.2999999999999999E-2,0.35,2019,26]
["10-inch Diameter Circular",0.02,0.55000000000000004,2020,25]
["12-inch Diameter Circular",2.9000000000000001E-2,0.79,2021,24]
["4\" x 4\" Square",4.1099999999999999E-3,0.11,2022,23]
["4\" x 6\" square",6.1599999999999997E-3,0.17,2023,22]
["6\" x 6\" square",9.2399999999999999E-3,0.25,2024,21]
["8\" x 8\" square",1.643E-2,0.44,2025,20]
[null,null,null,2026,19]
["Geographic Areas (Select Area)","Tide Range 1983-2001 (feet)",null,2027,18]
["Merrimack River, Including Salisbury and Newburyport",{"$f":"AVERAGE('Tide Ranges'!C2:C7)","v":7.544999999999999},null,2028,17]
["Essex to Gloucester",{"$f":"AVERAGE('Tide Ranges'!C8:C9)","v":8.94},null,2029,16]
["Manchester to Revere",{"$f":"AVERAGE('Tide Ranges'!$C$11:$C$12)","v":9.0449999999999999},null,2030,15]
["Chelsea/Winthrop to Cohasset",{"$f":"AVERAGE('Tide Ranges'!$C$13:$C$18)","v":9.4400000000000013},null,2031,14]
["Scituate to Plymouth",{"$f":"AVERAGE('Tide Ranges'!$C$19:$C$22)","v":9.4175000000000004},null,2032,13]
["Bourne to Provincetown (Cape Cod Bay)",{"$f":"AVERAGE('Tide Ranges'!$C$23:$C$29)","v":8.0149285714285714},null,2033,12]
["Provincetown to Orleans (Outer Cape)",{"$f":"AVERAGE('Tide Ranges'!$C$29)","v":9.2899999999999991},null,2034,11]
["Chatham (including Orleans in Pleasant Bay)",{"$f":"AVERAGE('Tide Ranges'!C30:C31)","v":4.8599999999999994},null,2035,10]
["Harwich to Mashpee",{"$f":"AVERAGE('Tide Ranges'!C33:C34)","v":3.4550000000000001},null,2036,9]
["Falmouth to RI Border (Buzzards and Mount Hope Bays)",{"$f":"AVERAGE('Tide Ranges'!$C$38:$C$48)","v":3.4975272727272726},null,2037,8]
["Islands",{"$f":"AVERAGE('Tide Ranges'!$C$35:$C$37)","v":2.2533333333333334},null,2038,7]
[null,null,null,2039,6]
["Structures - Click for Dropdown Menu ---->",null,null,2040,5]
["Piers",null,null,2041,4]
["Ramp/Gangway",null,null,2042,3]
["Float",null,null,2043,2]
[null,null,null,2044,1]
[]
["Town - Click for Dropdown Menu ---->","Tide Range 1983-2001 (feet)"]
["Acushnet",{"$f":"AVERAGE('Tide Ranges'!$C$38:$C$48)","v":3.4975272727272726}]
["Amesbury",{"$f":"('Tide Ranges'!C2)","v":8.09}]
["Aquinnah",{"$f":"AVERAGE('Tide Ranges'!$C$35:$C$37)","v":2.2533333333333334}]
["Barnstable - Cape Cod Bay side",{"$f":"AVERAGE('Tide Ranges'!$C$24:$C$29)","v":8.0340833333333332}]
["Barnstable (Nantucket Sound)",{"$f":"AVERAGE('Tide Ranges'!$C$33:$C$34)","v":3.4550000000000001}]
["Berkley",{"$f":"AVERAGE('Tide Ranges'!$C$38:$C$48)","v":3.4975272727272726}]
["Beverly",{"$f":"AVERAGE('Tide Ranges'!$C$11:$C$12)","v":9.0449999999999999}]
["Boston",{"$f":"('Tide Ranges'!C14)","v":9.49}]
["Bourne - Buzzards Bay side",{"$f":"AVERAGE('Tide Ranges'!$C$38:$C$48)","v":3.4975272727272726}]
["Bourne (Cape Cod Bay)",{"$f":"AVERAGE('Tide Ranges'!$C$23:$C$29)","v":8.0149285714285714}]
["Braintree",{"$f":"AVERAGE('Tide Ranges'!$C$13:$C$18)","v":9.4400000000000013}]
["Brewster (Cape Cod Bay)",{"$f":"AVERAGE('Tide Ranges'!$C$24:$C$29)","v":8.0340833333333332}]
["Chatham",{"$f":"AVERAGE('Tide Ranges'!C31)","v":5.77}]
["Chatham (Pleasant Bay)",{"$f":"AVERAGE('Tide Ranges'!$C$32)","v":3.2266000000000004}]
["Chelsea",{"$f":"AVERAGE('Tide Ranges'!$C$13:$C$18)","v":9.4400000000000013}]
["Chilmark",{"$f":"AVERAGE('Tide Ranges'!$C$35:$C$37)","v":2.2533333333333334}]
["Cohassset",{"$f":"AVERAGE('Tide Ranges'!$C$13:$C$18)","v":9.4400000000000013}]
["Danvers",{"$f":"AVERAGE('Tide Ranges'!$C$11:$C$12)","v":9.0449999999999999}]
["Dartmouth",{"$f":"AVERAGE('Tide Ranges'!$C$38:$C$48)","v":3.4975272727272726}]
["Dennis (Cape Cod Bay)",{"$f":"AVERAGE('Tide Ranges'!$C$24:$C$29)","v":8.0340833333333332}]
["Dennis (Nantucket Sound)",{"$f":"AVERAGE('Tide Ranges'!$C$33:$C$34)","v":3.4550000000000001}]
["Dighton",{"$f":"AVERAGE('Tide Ranges'!$C$38:$C$48)","v":3.4975272727272726}]
["Duxbury",{"$f":"AVERAGE('Tide Ranges'!$C$19:$C$22)","v":9.4175000000000004}]
["Eastham (Cape Cod Bay)",{"$f":"AVERAGE('Tide Ranges'!$C$24:$C$29)","v":8.0340833333333332}]
["Eastham (Outer Cape)",{"$f":"AVERAGE('Tide Ranges'!$C$29)","v":9.2899999999999991}]
["Edgartown",{"$f":"AVERAGE('Tide Ranges'!$C$35:$C$37)","v":2.2533333333333334}]
["Essex",{"$f":"AVERAGE('Tide Ranges'!$C$8:$C$9)","v":8.94}]
["Fairhaven",{"$f":"AVERAGE('Tide Ranges'!$C$38:$C$48)","v":3.4975272727272726}]
["Fall River",{"$f":"AVERAGE('Tide Ranges'!$C$38:$C$48)","v":3.4975272727272726}]
["Falmouth (Buzzards Bay)",{"$f":"AVERAGE('Tide Ranges'!$C$38:$C$48)","v":3.4975272727272726}]
["Falmouth (Nantucket Sound)",{"$f":"AVERAGE('Tide Ranges'!$C$33:$C$34)","v":3.4550000000000001}]
["Flamouth (Woods Hole)",{"$f":"'Tide Ranges'!C38","v":1.79}]
["Freetown",{"$f":"AVERAGE('Tide Ranges'!$C$38:$C$48)","v":3.4975272727272726}]
["Gloucester",{"$f":"AVERAGE('Tide Ranges'!$C$8:$C$9)","v":8.94}]
["Gloucester (Annisquam River and Lobster Cove Only)",{"$f":"('Tide Ranges'!C10)","v":8.8463999999999992}]
["Gosnold",{"$f":"AVERAGE('Tide Ranges'!$C$35:$C$37)","v":2.2533333333333334}]
["Groveland",{"$f":"AVERAGE('Tide Ranges'!$C$2:$C$7)","v":7.544999999999999}]
["Harwich",{"$f":"AVERAGE('Tide Ranges'!$C$33:$C$34)","v":3.4550000000000001}]
["Haverhill",{"$f":"('Tide Ranges'!C6)","v":5.72}]
["Hingham",{"$f":"AVERAGE('Tide Ranges'!$C$13:$C$18)","v":9.4400000000000013}]
["Hull",{"$f":"AVERAGE('Tide Ranges'!$C$13:$C$18)","v":9.4400000000000013}]
["Ipswich",{"$f":"AVERAGE('Tide Ranges'!$C$2:$C$7)","v":7.544999999999999}]
["Kingston",{"$f":"AVERAGE('Tide Ranges'!$C$19:$C$22)","v":9.4175000000000004}]
["Lynn",{"$f":"AVERAGE('Tide Ranges'!$C$11:$C$12)","v":9.0449999999999999}]
["Manchester-By-The-Sea",{"$f":"AVERAGE('Tide Ranges'!$C$11:$C$12)","v":9.0449999999999999}]
["Marblehead",{"$f":"AVERAGE('Tide Ranges'!$C$11:$C$12)","v":9.0449999999999999}]
["Marion",{"$f":"AVERAGE('Tide Ranges'!$C$38:$C$48)","v":3.4975272727272726}]
["Marshfield",{"$f":"AVERAGE('Tide Ranges'!$C$19:$C$22)","v":9.4175000000000004}]
["Mashpee (Nantucket Sound)",{"$f":"AVERAGE('Tide Ranges'!$C$33:$C$34)","v":3.4550000000000001}]
["Mattapoisets",{"$f":"AVERAGE('Tide Ranges'!$C$38:$C$48)","v":3.4975272727272726}]
["Merimac",{"$f":"('Tide Ranges'!C5)","v":7.05}]
["Milton",{"$f":"AVERAGE('Tide Ranges'!$C$13:$C$18)","v":9.4400000000000013}]
["Nahant",{"$f":"AVERAGE('Tide Ranges'!$C$11:$C$12)","v":9.0449999999999999}]
["New Bedford",{"$f":"('Tide Ranges'!C39)","v":3.633}]
["Newburyport",{"$f":"('Tide Ranges'!C2)","v":8.09}]
["Oak Bluffs",{"$f":"AVERAGE('Tide Ranges'!$C$35:$C$37)","v":2.2533333333333334}]
["Orleans (Cape Cod Bay)",{"$f":"AVERAGE('Tide Ranges'!$C$24:$C$29)","v":8.0340833333333332}]
["Orleans (Outer Cape)",{"$f":"AVERAGE('Tide Ranges'!$C$29)","v":9.2899999999999991}]
["Orleans (Pleasant Bay)",{"$f":"AVERAGE('Tide Ranges'!$C$32)","v":3.2266000000000004}]
["Plymouth",{"$f":"AVERAGE('Tide Ranges'!$C$19:$C$22)","v":9.4175000000000004}]
["Provincetown (Cape Cod Bay)",{"$f":"AVERAGE('Tide Ranges'!$C$24:$C$29)","v":8.0340833333333332}]
["Provincetown (Outer Cape)",{"$f":"AVERAGE('Tide Ranges'!C29)","v":9.2899999999999991}]
["Quincy",{"$f":"AVERAGE('Tide Ranges'!$C$13:$C$18)","v":9.4400000000000013}]
["Revere",{"$f":"AVERAGE('Tide Ranges'!$C$11:$C$12)","v":9.0449999999999999}]
["Rockport",{"$f":"AVERAGE('Tide Ranges'!$C$8:$C$9)","v":8.94}]
["Rowley",{"$f":"AVERAGE('Tide Ranges'!$C$2:$C$7)","v":7.544999999999999}]
["Salem",{"$f":"AVERAGE('Tide Ranges'!$C$11:$C$12)","v":9.0449999999999999}]
["Salisbury",{"$f":"('Tide Ranges'!C4)","v":7.64}]
["Sandwich",{"$f":"AVERAGE('Tide Ranges'!$C$23:$C$29)","v":8.0149285714285714}]
["Saugus",{"$f":"AVERAGE('Tide Ranges'!$C$11:$C$12)","v":9.0449999999999999}]
["Scituate",{"$f":"AVERAGE('Tide Ranges'!$C$19:$C$22)","v":9.4175000000000004}]
["Somerset",{"$f":"AVERAGE('Tide Ranges'!$C$38:$C$48)","v":3.4975272727272726}]
["Swansea",{"$f":"AVERAGE('Tide Ranges'!$C$38:$C$48)","v":3.4975272727272726}]
["Tisbury",{"$f":"AVERAGE('Tide Ranges'!$C$35:$C$37)","v":2.2533333333333334}]
["Truro (Cape Cod Bay)",{"$f":"AVERAGE('Tide Ranges'!$C$24:$C$29)","v":8.0340833333333332}]
["Truro (Outer Cape)",{"$f":"AVERAGE('Tide Ranges'!$C$29)","v":9.2899999999999991}]
["Wareham",{"$f":"AVERAGE('Tide Ranges'!$C$38:$C$48)","v":3.4975272727272726}]
["Wellfleet (Cape Cod Bay)",{"$f":"AVERAGE('Tide Ranges'!$C$24:$C$29)","v":8.0340833333333332}]
["Wellfleet (Outer Cape)",{"$f":"AVERAGE('Tide Ranges'!$C$29)","v":9.2899999999999991}]
["West Newbury",{"$f":"AVERAGE('Tide Ranges'!$C$2:$C$7)","v":7.544999999999999}]
["West Tisbury",{"$f":"AVERAGE('Tide Ranges'!$C$35:$C$37)","v":2.2533333333333334}]
["Westport",{"$f":"AVERAGE('Tide Ranges'!$C$38:$C$48)","v":3.4975272727272726}]
["Weymouth",{"$f":"AVERAGE('Tide Ranges'!$C$13:$C$18)","v":9.4400000000000013}]
["Winthrop",{"$f":"AVERAGE('Tide Ranges'!$C$13:$C$18)","v":9.4400000000000013}]
["Yarmouth (Cape Cod Bay)",{"$f":"AVERAGE('Tide Ranges'!$C$24:$C$29)","v":8.0340833333333332}]
["Yarmouth (Outer Cape side)",{"$f":"AVERAGE('Tide Ranges'!$C$29)","v":9.2899999999999991}]

{"sheet":"Tide Ranges","index":2,"n_rows":52,"n_cols":7,"rows_kept":52,"cut":false,"hidden":true,"merged":[]}
["NOAA Station #","Station Name","Mean (feet, 1983-2001)","Diurnal (feet, 1983-2001)","NOAA Designation","Designation for This Sheet"]
[8440466,"Newburyport",8.09,8.76,"Merrimack Rver","Merrimack River"]
[8440452,"Plum Island, Merrimack River entrance",8,8.6999999999999993,"Merrimack Rver","Merrimack River"]
[8440273,"Salisbury Point",7.64,8.2799999999999994,"Merrimack Rver","Merrimack River"]
[8440369,"Merrimacport",7.05,7.66,"Merrimack Rver","Merrimack River"]
[8440889,"Riverside (Haverhill)",5.72,6.3,"Merrimack Rver","Merrimack River"]
[8441241,"Plum Island South",8.77,9.49,"Merrimack Rver","Merrimack River"]
[8441771,"Essex",9.18,9.92,"Merrimack Rver","Essex to Gloucester"]
[8441551,"Rockport",8.6999999999999993,9.4600000000000009,"Merrimack Rver","Essex to Gloucester"]
[8441571,"Annisquam, Lobster Cove",{"$f":"9.12*0.97","v":8.8463999999999992},{"$f":"9.9*0.97","v":9.6029999999999998},"Merimack River","Gloucester (Annisquam and Lobster Cove Only)","Subordinate Station (to Portland, ME, NOAA Sta #8418150 * 0.97 feet = Annisquam NOAA Station) "]
[8442645,"Salem, Salem Harbor",8.93,9.6999999999999993,"Merrimack Rver","Manchester to Revere"]
[8443187,"Lynn, Lynn Harbor",9.16,9.94,"Merrimack Rver","Manchester to Revere"]
[8444162,"Boston Light",9.0500000000000007,9.82,"Boston Harbor","Chelsea/Winthrop to Cohasset"]
[8443970,"Boston",9.49,10.27,"Boston Harbor","Chelsea/Winthrop to Cohasset"]
[8443662,"Amelia Earhart Dam, Mystic River",9.56,10.34,"Boston Harbor","Chelsea/Winthrop to Cohasset"]
[8443725,"Chelsea",9.56,10.35,"Boston Harbor","Chelsea/Winthrop to Cohasset"]
[8444525,"Nut Island",9.42,10.210000000000001,"Hingham Bay","Chelsea/Winthrop to Cohasset"]
[8444788,"Weymouth Fore River",9.56,10.35,"Hinham Bay","Chelsea/Winthrop to Cohasset"]
[8445138,"Scituate, Scituate Harbor",8.94,9.74,"Cohasset Harbor to Davis Bank","Scituate to Plymouth"]
[8446009,"Brant Rock, Green Harbor River",9.08,9.8699999999999992,"Cohasset Harbor to Davis Bank","Scituate to Plymouth"]
[8446166,"Duxbury, Duxbury Harbor",9.89,10.68,"Cape Cod Bay","Scituate to Plymouth"]
[8446493,"Plymouth",9.76,10.53,"Cape Cod Bay","Scituate to Plymouth"]
[8447173,"Sagamore, Cape Cod Canal (Sta 115)",7.9,8.59,"Cape Cod Bay","Bourne to Provincetown (Cape Cod Bay)"]
[8447191,"Bourndale, Cape Cod Canal (Sta 200)",6.18,6.82,"Cape Cod Bay","Bourne to Provincetown (Cape Cod Bay)"]
[8447259,"Bourne Bridge, Cape Cod Canal (Sta 320)",4.3,4.96,"Cape Cod Bay","Bourne to Provincetown (Cape Cod Bay)"]
[8447180,"Sandwich",8.74,9.4499999999999993,"Cape Cod Bay","Bourne to Provincetown (Cape Cod Bay)"]
[8447241,"Sesuit Harbor, East Dennis",9.73,10.46,"Cape Cod Bay","Bourne to Provincetown (Cape Cod Bay)","Provincetown to Orleans"]
[8446613,"Wellfleet",{"$f":"C14*1.05","v":9.964500000000001},{"$f":"D14*1.05","v":10.7835},"Cape Cod Bay",null,"Subordinate Station (to Boston, MA * 1.05 fet)"]
[8446121,"Provincetown",9.2899999999999991,10.08,"Cape Cod Bay","Bourne to Provincetown (Cape Cod Bay)"]
[8447505,"Chatham, Stage Harbor",3.95,4.58,"Cape Cod","Chatham (including Orleans in Pleasant Bay)"]
[8447435,"Chatham",5.77,6.41,"Cape Cod","Chatham (including Orleans in Pleasant Bay)"]
[8447291,"Pleasant Bay",{"$f":"C14*0.34","v":3.2266000000000004},{"$f":"D14*0.34","v":3.4918},"Cape Cod",null,"Subordinate Station (to Boston, MA * 0.34 feet)"]
[8447495,"SAQUATUCKET HARBOR",3.72,4.3499999999999996,"Nantucket Sound, North Side","Harwich to Mashpee"]
[8447605,"HYANNISPORT",3.19,3.8,"Nantucket Sound, North Side","Harwich to Mashpee"]
[8449130,"Nantucket Island",3.04,3.57,"Nantucket Isalnd","Islands"]
[8448157,"VINEYARD HAVEN, VINEYARD HVN HBR",1.59,2.13,"Martha's Vineyard","Islands"]
[8448558,"Edgartown",2.13,2.68,"Martha's Vineyard","Islands"]
[8447930,"Woods Hole",1.79,2.2000000000000002,"Vineyard Sound","Falmouth to RI Border (Buzzards and Mount Hope Bays)"]
[8447584,"New Bedford",{"$f":"3.46*1.05","v":3.633},{"$f":"3.85*1.05","v":4.0425000000000004},"Buzzards Bay",null,"Subordinate to Newport, RI #8452660 *1.05 feet"]
[8447385,"Marion, Sippican Harbor",{"$f":"3.46*1.13","v":3.9097999999999997},{"$f":"3.85*1.13","v":4.3504999999999994},"Buzzards Bay",null,"Subordinate to Newport, RI #8452660* 1.13 feet"]
[8448248,"PENIKESE ISLAND",3.41,3.8,"Buzzards Bay","Falmouth to RI Border (Buzzards and Mount Hope Bays)"]
[8447685,"Chappaquoit Point",3.82,4.25,"Buzzards Bay","Falmouth to RI Border (Buzzards and Mount Hope Bays)"]
[8447295,"Gray Gables",3.62,4.0999999999999996,"Buzzards Bay","Falmouth to RI Border (Buzzards and Mount Hope Bays)"]
[8447270,"Buzzards Bay",3.42,3.99,"Buzzards Bay","Falmouth to RI Border (Buzzards and Mount Hope Bays)"]
[8447368,"Great Hill",3.97,4.41,"Buzzards Bay","Falmouth to RI Border (Buzzards and Mount Hope Bays)"]
[8447416,"Piney Point",3.91,4.3600000000000003,"Buzzards Bay","Falmouth to RI Border (Buzzards and Mount Hope Bays)"]
[8447712,"Clarks Point",3.56,3.96,"Buzzards Bay","Falmouth to RI Border (Buzzards and Mount Hope Bays)"]
[8447842,"Round Hill Point",3.43,3.84,"Buzzards Bay","Falmouth to RI Border (Buzzards and Mount Hope Bays)"]
[]
[]
[null,null,{"$f":"SUM(C38:C48)","v":38.472799999999999}]
[null,null,{"$f":"AVERAGE(C38:C48)","v":3.4975272727272726}]