{"text_format":"1","workbook":"xlsx","n_sheets":4,"sheets":["Sheet1","Sheet2","Sheet3","Sheet4"],"not_rendered":{"charts":0,"images":0,"macros":1,"external_links":0,"defined_names":0,"comments":0,"pivot_tables":0},"unopened":[],"bounds":{"document_bytes":16777216,"sheet_cells":100000,"rows_first":2000,"rows_last":500,"rows_between":2000,"halvings":0,"cell_chars":16384,"cell_head_chars":4096},"cells_cut":0,"cells_raw":0,"read":"whole","date_system":"1900"}

{"sheet":"Sheet1","index":0,"n_rows":11,"n_cols":4,"rows_kept":11,"cut":false,"hidden":false,"merged":[]}
["Reserve Name","Latitude (DMS)","Longitude (DMS)"]
["Emerald Valley Reserve","34° 12' 30\" N","118° 15' 45\" W",{"$f":"_xlfn.TEXTBEFORE(B2, \"°\")+_xlfn.TEXTBEFORE(_xlfn.TEXTAFTER(B2, \"°\"), \"'\")/60+_xlfn.TEXTBEFORE(_xlfn.TEXTAFTER(B2,\"'\"),\"\"\"\")/3600","v":34.208333333333336}]
["Silver Lake Preserve","45° 30' 15\" N","120° 45' 30\" W",{"$f":"_xlfn.TEXTBEFORE(B3, \"°\")+_xlfn.TEXTBEFORE(_xlfn.TEXTAFTER(B3, \"°\"), \"'\")/60+_xlfn.TEXTBEFORE(_xlfn.TEXTAFTER(B3,\"'\"),\"\"\"\")/3600","v":45.50416666666667}]
["Golden Meadow Sanctuary","36° 45' 0\" N","98° 30' 0\" W",36.75]
["Crystal Falls Reserve","39° 15' 30\" N","105° 30' 15\" W",39.258333333333333]
["Blue Ridge Wildlife Refuge","38° 20' 0\" N","82° 15' 0\" W",38.333333333333336]
["Mystic Forest Preserve","42° 10' 0\" N","74° 5' 0\" W",42.166666666666664]
["Twilight Canyon Reserve","33° 45' 15\" N","116° 30' 30\" W",33.75416666666667]
["Starlight Marsh Sanctuary","29° 30' 0\" N","81° 15' 0\" W",29.5]
["Whispering Pines Reserve","37° 25' 0\" N","122° 10' 0\" W",37.416666666666664]
["Frosty Peaks Nature Reserve","40° 30' 0\" N","105° 15' 0\" W",40.5]

{"sheet":"Sheet2","index":1,"n_rows":11,"n_cols":4,"rows_kept":11,"cut":false,"hidden":false,"merged":[]}
["Reserve Name","Latitude (DMS)","Longitude (DMS)"]
["Emerald Valley Reserve","34° 12' 30\" N","118° 15' 45\" W",{"$f":"LEFT(B2, FIND(\"°\", B2) - 1) + (MID(B2, FIND(\"°\", B2) + 1, FIND(\"'\", B2) - FIND(\"°\", B2) - 1) / 60) + (MID(B2, FIND(\"'\", B2) + 1, FIND(\"\"\"\", B2) - FIND(\"'\", B2) - 1) / 3600)","v":34.208333333333336}]
["Silver Lake Preserve","45° 30' 15\" N","120° 45' 30\" W",{"$f":"LEFT(B3, FIND(\"°\", B3) - 1) + (MID(B3, FIND(\"°\", B3) + 1, FIND(\"'\", B3) - FIND(\"°\", B3) - 1) / 60) + (MID(B3, FIND(\"'\", B3) + 1, FIND(\"\"\"\", B3) - FIND(\"'\", B3) - 1) / 3600)","v":45.50416666666667}]
["Golden Meadow Sanctuary","36° 45' 0\" N","98° 30' 0\" W",36.75]
["Crystal Falls Reserve","39° 15' 30\" N","105° 30' 15\" W",39.258333333333333]
["Blue Ridge Wildlife Refuge","38° 20' 0\" N","82° 15' 0\" W",38.333333333333336]
["Mystic Forest Preserve","42° 10' 0\" N","74° 5' 0\" W",42.166666666666664]
["Twilight Canyon Reserve","33° 45' 15\" N","116° 30' 30\" W",33.75416666666667]
["Starlight Marsh Sanctuary","29° 30' 0\" N","81° 15' 0\" W",29.5]
["Whispering Pines Reserve","37° 25' 0\" N","122° 10' 0\" W",37.416666666666664]
["Frosty Peaks Nature Reserve","40° 30' 0\" N","105° 15' 0\" W",40.5]

{"sheet":"Sheet3","index":2,"n_rows":11,"n_cols":4,"rows_kept":11,"cut":false,"hidden":false,"merged":[]}
["Reserve Name","Latitude (DMS)","Longitude (DMS)"]
["Emerald Valley Reserve","34° 12' 30\" N","118° 15' 45\" W",{"$f":"SUM(_xlfn.DROP(_xlfn.TEXTSPLIT(B2,{\"°\",\"'\",\"\"\"\"}), , -1)/{1,60,3600})","v":34.208333333333336}]
["Silver Lake Preserve","45° 30' 15\" N","120° 45' 30\" W",{"$f":"SUM(_xlfn.DROP(_xlfn.TEXTSPLIT(B3,{\"°\",\"'\",\"\"\"\"}), , -1)/{1,60,3600})","v":45.50416666666667}]
["Golden Meadow Sanctuary","36° 45' 0\" N","98° 30' 0\" W",{"$f":"SUM(_xlfn.DROP(_xlfn.TEXTSPLIT(B4,{\"°\",\"'\",\"\"\"\"}), , -1)/{1,60,3600})","v":36.75}]
["Crystal Falls Reserve","39° 15' 30\" N","105° 30' 15\" W",{"$f":"SUM(_xlfn.DROP(_xlfn.TEXTSPLIT(B5,{\"°\",\"'\",\"\"\"\"}), , -1)/{1,60,3600})","v":39.258333333333333}]
["Blue Ridge Wildlife Refuge","38° 20' 0\" N","82° 15' 0\" W",{"$f":"SUM(_xlfn.DROP(_xlfn.TEXTSPLIT(B6,{\"°\",\"'\",\"\"\"\"}), , -1)/{1,60,3600})","v":38.333333333333336}]
["Mystic Forest Preserve","42° 10' 0\" N","74° 5' 0\" W",{"$f":"SUM(_xlfn.DROP(_xlfn.TEXTSPLIT(B7,{\"°\",\"'\",\"\"\"\"}), , -1)/{1,60,3600})","v":42.166666666666664}]
["Twilight Canyon Reserve","33° 45' 15\" N","116° 30' 30\" W",{"$f":"SUM(_xlfn.DROP(_xlfn.TEXTSPLIT(B8,{\"°\",\"'\",\"\"\"\"}), , -1)/{1,60,3600})","v":33.75416666666667}]
["Starlight Marsh Sanctuary","29° 30' 0\" N","81° 15' 0\" W",{"$f":"SUM(_xlfn.DROP(_xlfn.TEXTSPLIT(B9,{\"°\",\"'\",\"\"\"\"}), , -1)/{1,60,3600})","v":29.5}]
["Whispering Pines Reserve","37° 25' 0\" N","122° 10' 0\" W",{"$f":"SUM(_xlfn.DROP(_xlfn.TEXTSPLIT(B10,{\"°\",\"'\",\"\"\"\"}), , -1)/{1,60,3600})","v":37.416666666666664}]
["Frosty Peaks Nature Reserve","40° 30' 0\" N","105° 15' 0\" W",{"$f":"SUM(_xlfn.DROP(_xlfn.TEXTSPLIT(B11,{\"°\",\"'\",\"\"\"\"}), , -1)/{1,60,3600})","v":40.5}]

{"sheet":"Sheet4","index":3,"n_rows":11,"n_cols":4,"rows_kept":11,"cut":false,"hidden":false,"merged":[]}
["Reserve Name","Latitude (DMS)","Longitude (DMS)"]
["Emerald Valley Reserve","34° 12' 30\" N","118° 15' 45\" W",{"$f":"ConvertToDecimal(B2)","v":34.208333333333336}]
["Silver Lake Preserve","45° 30' 15\" N","120° 45' 30\" W",{"$f":"ConvertToDecimal(B3)","v":45.50416666666667}]
["Golden Meadow Sanctuary","36° 45' 0\" N","98° 30' 0\" W",{"$f":"ConvertToDecimal(B4)","v":36.75}]
["Crystal Falls Reserve","39° 15' 30\" N","105° 30' 15\" W",{"$f":"ConvertToDecimal(B5)","v":39.258333333333333}]
["Blue Ridge Wildlife Refuge","38° 20' 0\" N","82° 15' 0\" W",{"$f":"ConvertToDecimal(B6)","v":38.333333333333336}]
["Mystic Forest Preserve","42° 10' 0\" N","74° 5' 0\" W",{"$f":"ConvertToDecimal(B7)","v":42.166666666666664}]
["Twilight Canyon Reserve","33° 45' 15\" N","116° 30' 30\" W",{"$f":"ConvertToDecimal(B8)","v":33.75416666666667}]
["Starlight Marsh Sanctuary","29° 30' 0\" N","81° 15' 0\" W",{"$f":"ConvertToDecimal(B9)","v":29.5}]
["Whispering Pines Reserve","37° 25' 0\" N","122° 10' 0\" W",{"$f":"ConvertToDecimal(B10)","v":37.416666666666664}]
["Frosty Peaks Nature Reserve","40° 30' 0\" N","105° 15' 0\" W",{"$f":"ConvertToDecimal(B11)","v":40.5}]