// add_north_florida.js
// Agrega directorio marino de Florida Norte al Excel existente
const xlsx = require('xlsx');
const path = require('path');

const EXCEL_PATH = path.resolve(__dirname, 'Directorio_Marino_FL_Acumulativo_4.xlsx');

// Encabezados de columnas
const HEADERS = ['#', 'NOMBRE', 'DIRECCION', 'TELEFONO', 'EMAIL', 'CIUDAD', 'CONDADO', 'WEBSITE'];

// ══════════════════════════════════════════════════════════
// MARINAS — FLORIDA NORTE
// ══════════════════════════════════════════════════════════
const MARINAS = [
  // VOLUSIA
  ['Halifax Harbor Marina','450 Basin St, Daytona Beach, FL 32114','(386) 671-3601','halifaxharbormarina@gmail.com','halifaxharbormarina.com','Daytona Beach','Volusia'],
  ['Loggerhead Daytona Beach Marina','721 Ballough Rd, Daytona Beach, FL 32114','(386) 523-3100','daytona@equitylifestyle.com','loggerheadmarinas.com','Daytona Beach','Volusia'],
  ['Coquina Marina Daytona Beach','841 Ballough Rd, Daytona Beach, FL 32114','(386) 317-0555','coquinamarinas@gmail.com','coquinamarinadaytona.com','Daytona Beach','Volusia'],
  ['Halifax River Yacht Club','331 S Beach St, Daytona Beach, FL 32114','(386) 255-7459','hryc@hryc.com','hryc.com','Daytona Beach','Volusia'],
  ['Daytona Marina & Boat Works','645 S Beach St, Daytona Beach, FL 32114','(386) 252-6421','dawn645@thedaytonamarina.com','thedaytonamarina.com','Daytona Beach','Volusia'],
  ['Loggerhead Inlet Harbor Marina','133 Inlet Harbor Rd, Ponce Inlet, FL 32127','(386) 767-3266','','loggerheadmarinas.com','Ponce Inlet','Volusia'],
  ['Sea Love Boat Works & Marina','4877 Front St, Ponce Inlet, FL 32127','(386) 761-5434','sealoveboatworks@gmail.com','sealoveboatworks.com','Ponce Inlet','Volusia'],
  ['Lighthouse Boatyard & Marina','4958 S Peninsula Dr, Ponce Inlet, FL 32127','(386) 767-0683','','','Ponce Inlet','Volusia'],
  ['Seven Seas Marina & Boatyard','3300 S Peninsula Dr, Port Orange, FL 32127','(386) 761-3221','sevenseasmarina@bellsouth.net','sevenseasmarina.com','Port Orange','Volusia'],
  ['Adventure Yacht Harbor','3948 S Peninsula Dr, Port Orange, FL 32127','(386) 756-2180','','adventureyachtharbor.com','Port Orange','Volusia'],
  ['New Smyrna Marina','200 Boatyard St, New Smyrna Beach, FL 32169','(386) 427-4514','','newsmyrnamarina.com','New Smyrna Beach','Volusia'],
  ['City Marina New Smyrna Beach','201 N Riverside Dr, New Smyrna Beach, FL 32168','(386) 409-2042','','cityofnsb.com','New Smyrna Beach','Volusia'],
  ['River Deck Marina','111 N Riverside Dr, New Smyrna Beach, FL 32168','(386) 428-7827','','riverdeckmarina.com','New Smyrna Beach','Volusia'],
  ["Gerry's Marina",'179 N Causeway, New Smyrna Beach, FL 32169','(386) 428-2341','','gerrysmarina.net','New Smyrna Beach','Volusia'],
  ['Smyrna Yacht Club','1201 S Riverside Dr, New Smyrna Beach, FL 32168','(386) 427-4040','','smyrnayachtclub.com','New Smyrna Beach','Volusia'],
  ["Cameron's Marina",'2001 S Riverside Dr, Edgewater, FL 32132','(904) 428-3063','','','Edgewater','Volusia'],
  // FLAGLER
  ['Palm Coast Marina','15 Palm Coast Resort Blvd, Palm Coast, FL 32137','(386) 446-6370','','palmcoastmarina.net','Palm Coast','Flagler'],
  ['Hammock Beach Marina','102 Yacht Harbor Dr, Palm Coast, FL 32137','(386) 348-3114','info@hammockbeachmarina.com','hammockbeachmarina.com','Palm Coast','Flagler'],
  // INDIAN RIVER
  ['Loggerhead Marina Vero Beach','1221 Marina Village Cir, Vero Beach, FL 32967','(772) 770-4470','','loggerheadmarinas.com','Vero Beach','Indian River'],
  ['Vero Beach City Marina','3611 Rio Vista Blvd, Vero Beach, FL 32963','(772) 978-4960','','covb.org','Vero Beach','Indian River'],
  ['Vero Marine Center','12 Royal Palm Pointe, Vero Beach, FL 32960','(772) 562-7922','','veromarine.com','Vero Beach','Indian River'],
  ['Fins Marina','1660 Indian River Dr, Sebastian, FL 32958','(772) 589-4843','info@finsmarina.com','finsmarina.com','Sebastian','Indian River'],
  ['Sebastian River Marina & Boatyard','8525 US Hwy 1, Sebastian, FL 32976','(772) 664-3029','d.hillman@sebastian-river-marina.com','marinaharborinmiccofl.com','Sebastian','Indian River'],
  ['Sebastian Inlet Marina','8685 US-1, Micco, FL 32976','(772) 664-8500','SIMoffice@mywindward.com','sebastianinletmarina.com','Micco','Indian River'],
  ['Treasure Coast Marina','5185 S US-1, Grant, FL 32949','','','','Grant','Indian River'],
  ['Vero Beach Yacht Club','3601 Rio Vista Blvd, Vero Beach, FL 32963','','','','Vero Beach','Indian River'],
  // BREVARD - NORTE
  ['Titusville Municipal Marina','451 Marina Rd, Titusville, FL 32796','(321) 383-5600','tlawson@f3marina.com','titusvillemarina.com','Titusville','Brevard'],
  ['Westland Boatyard and Marina','419 N Washington Ave, Titusville, FL 32796','(321) 267-1667','','westlandmarina.com','Titusville','Brevard'],
  ['Kennedy Point Marina & Yacht Club','4749 S Washington Ave, Titusville, FL 32780','(321) 383-0280','','kennedypointmarina.com','Titusville','Brevard'],
  // BREVARD - CENTRO
  ['Cape Marina','800 Scallop Dr, Cape Canaveral, FL 32920','(321) 783-8410','dockmaster@capemarina.com','capemarina.com','Cape Canaveral','Brevard'],
  ['Sunrise Marina','505 Glen Cheek Dr, Cape Canaveral, FL 32920','(321) 783-9535','','sunrisemarina.com','Cape Canaveral','Brevard'],
  ['Ocean Club Marina at Port Canaveral','930 Mullet Rd, Cape Canaveral, FL 32920','(321) 783-9001','info@oceanclubmarina-pc.com','oceanclubmarina-pc.com','Cape Canaveral','Brevard'],
  ['Harbortown Marina Canaveral','2700 Harbortown Dr, Merritt Island, FL 32952','(321) 453-0160','info@harbortownmarina.com','harbortownmarina.com','Merritt Island','Brevard'],
  ['Marker 24 Marina','1360 S Banana River Dr, Merritt Island, FL 32952','(321) 453-7888','','marker24marina.com','Merritt Island','Brevard'],
  ['Cape Crossing Resort & Marina','201 Ivory Coral Ln, Merritt Island, FL 32953','(321) 576-4967','info@capecrossing.com','capecrossing.com','Merritt Island','Brevard'],
  ['Cocoa Village Marina','90 Delannoy Ave, Cocoa, FL 32922','(321) 632-5445','cvmarina@cfl.rr.com','cocoavillagemarina.com','Cocoa','Brevard'],
  ['Island Time Marina','400 W Cocoa Beach Cswy, Cocoa Beach, FL 32931','(321) 613-4852','','islandtimemarina.com','Cocoa Beach','Brevard'],
  // BREVARD - SUR
  ['Anchorage Yacht Basin','96 E Eau Gallie Cswy, Melbourne, FL 32937','(321) 773-3620','','anchorageyachtbasin.com','Melbourne','Brevard'],
  ['Melbourne Harbor Marina','2210 Front St #101, Melbourne, FL 32901','(321) 725-9054','info@melbourneharbor.com','melbourneharbor.com','Melbourne','Brevard'],
  ['Palm Bay Marina','4350 Dixie Hwy NE, Palm Bay, FL 32905','(321) 723-0851','','palmbaymarina.com','Palm Bay','Brevard'],
  // CITRUS
  ['Twin Rivers Marina','2880 N Seabreeze Pt, Crystal River, FL 34429','(352) 795-3552','','twinriversmarina.com','Crystal River','Citrus'],
  ["Pete's Pier Marina",'1 SW 1st Pl, Crystal River, FL 34429','(352) 795-3302','','petespier.com','Crystal River','Citrus'],
  ['Ozello Keys Marina','2355 S Ripple Path, Crystal River, FL 34429','(352) 228-8095','','ozellokeysmarina.com','Crystal River','Citrus'],
  ['Riverhaven Marina','5296 S Riverview Cir, Homosassa, FL 34448','(352) 628-5545','','riverhavenmarina.com','Homosassa','Citrus'],
  ['Homosassa Springs Marina','10806 W Halls River Rd, Homosassa, FL 34448','(352) 628-7334','','homosassaspringsmarina.com','Homosassa','Citrus'],
  // LEVY
  ['Cedar Key Marina II','12780 State Route 24, Cedar Key, FL 32625','(352) 543-6148','','cedarkeymarina.net','Cedar Key','Levy'],
  ['Cedar Key City Marina','Dock St, Cedar Key, FL 32625','(352) 543-5132','cityhall@cedarkeyfl.us','','Cedar Key','Levy'],
  // DIXIE
  ['Horseshoe Beach Marina','262 E 3rd St, Horseshoe Beach, FL 32648','(352) 498-5405','','horseshoebeachmarina.com','Horseshoe Beach','Dixie'],
  // TAYLOR
  ['Sea Hag Marina','322 S Riverside Dr, Steinhatchee, FL 32359','(352) 498-3008','','seahag.com','Steinhatchee','Taylor'],
  ['Steinhatchee River Inn & Marina','1111 Riverside Dr SE, Steinhatchee, FL 32359','(352) 498-4049','','riverinnandmarina.com','Steinhatchee','Taylor'],
  ['Steinhatchee River Haven Marina','1110 Riverside Drive, Steinhatchee, FL 32359','(352) 498-0709','riverhaven@bellsouth.net','riverhavenmarinaandmotel.com','Steinhatchee','Taylor'],
  ['Shelter Cove Marina','412 S Riverside Dr, Steinhatchee, FL 32359','(352) 210-1781','','sheltercovemarina.net','Steinhatchee','Taylor'],
  ['Good Times Motel and Marina','7022 SW Hwy 358, Steinhatchee, FL 32359','(352) 498-8088','','goodtimesmotelandmarina.com','Steinhatchee','Taylor'],
  ['Steinhatchee Landing Resort','203 Ryland Circle, Steinhatchee, FL 32359','(352) 498-0696','','steinhatcheelanding.com','Steinhatchee','Taylor'],
  ['Keaton Beach Marina & Motel','20650 Keaton Beach Dr, Perry, FL 32348','(850) 578-2897','','','Perry','Taylor'],
  ['Steinhatchee Marina at Deadman Bay','104 First Ave SW, Steinhatchee, FL 32359','(352) 578-1900','','shrmarina.com','Steinhatchee','Taylor'],
  // WAKULLA
  ['Shell Point Harbor Marina','85 Harbour Point Dr, Crawfordville, FL 32327','(850) 544-5658','Accounting@shellpointharbormarina.com','shellpointharbormarina.com','Crawfordville','Wakulla'],
  ['Shields Marina','95 Riverside Dr, St. Marks, FL 32355','(850) 925-6158','info@shieldsmarina.com','shieldsmarina.com','St. Marks','Wakulla'],
  ['Rock Landing Marina','91 Rock Landing Rd, Panacea, FL 32346','(850) 984-5844','','rocklandingmarina.com','Panacea','Wakulla'],
  // FRANKLIN
  ['Scipio Creek Marina','301 Market St, Apalachicola, FL 32320','(850) 653-8030','','scipiocreekmarina.com','Apalachicola','Franklin'],
  ['Water Street Hotel & Marina','329 Water St, Apalachicola, FL 32320','(850) 502-5134','','waterstreethotel.com','Apalachicola','Franklin'],
  ['Battery Park Marina','1 Bay Avenue, Apalachicola, FL 32320','(850) 653-9319','','','Apalachicola','Franklin'],
  ['Deep Water Marina','329 Water St, Apalachicola, FL 32320','(850) 653-8801','','','Apalachicola','Franklin'],
  ['Rainbow Inn & Marina','123 Water Street, Apalachicola, FL 32320','(850) 653-8139','','','Apalachicola','Franklin'],
  ['Sportsmans Lodge Marina','99 North Bayshore Dr, Eastpoint, FL 32328','(850) 670-8423','','','Eastpoint','Franklin'],
  ['The Moorings of Carrabelle','1000 Avenue A North, Carrabelle, FL 32322','','','themooringsofcarrabelle.com','Carrabelle','Franklin'],
  ['C-Quarters Marina','501 St James Ave Hwy 98, Carrabelle, FL 32322','(850) 697-8400','','c-quartersmarina.com','Carrabelle','Franklin'],
  ["Johnson's Carrabelle Marina",'803 NW Avenue A, Carrabelle, FL 32322','(850) 510-4196','','carrabelle-marina.com','Carrabelle','Franklin'],
  ['Carrabelle Boat Club','1570 Hwy 98 W, Carrabelle, FL 32322','(850) 697-5500','info@carrabelleboatclub.com','carrabelleboatclub.com','Carrabelle','Franklin'],
  ["Pirate's Cove Carrabelle Marina",'275 Timber Island Rd, Carrabelle, FL 32322','(850) 756-8144','','','Carrabelle','Franklin'],
  ['MS Dockside Marina & Boatyard','292 Graham Dr, Carrabelle, FL 32322','(850) 697-3337','msdocksidemarina@gmail.com','msdockside.com','Carrabelle','Franklin'],
  // GULF
  ['Point South Marina - Port St. Joe','340 Marina Drive, Port St Joe, FL 32456','(850) 460-9780','info.portstjoe@pointsouthmarina.com','pointsouthmarinaportstjoe.com','Port St. Joe','Gulf'],
  ["Captain's Cove Marina",'1646 Captain Carl Raffield Way, Port St Joe, FL 32456','(850) 227-3357','captaincove@yahoo.com','captainscovefl.com','Port St. Joe','Gulf'],
  // BAY
  ['Point South Marina - Bay Point','3824 Hatteras Ln, Panama City Beach, FL 32408','(850) 235-6911','BayPointMarina@StJoe.com','pointsouthmarinabaypoint.com','Panama City Beach','Bay'],
  ['Bayside Marina','6325 Big Daddy Drive, Panama City Beach, FL 32407','(850) 234-7650','','bluegatemarinas.com','Panama City Beach','Bay'],
  ['MarineMax Panama City Beach','3605 Thomas Dr, Panama City Beach, FL 32408','(850) 708-1317','','marinemax.com','Panama City Beach','Bay'],
  ["Capt. Anderson's Marina",'5550 N Lagoon Dr, Panama City, FL 32408','(850) 234-3435','captandersonsmktg@aol.com','captandersonsmarina.com','Panama City','Bay'],
  ['Treasure Island Marina','3605 Thomas Dr, Panama City Beach, FL 32408','(850) 234-6533','','treasureislandmarina.net','Panama City Beach','Bay'],
  ['St. Andrews Marina','3151 W 10th St, Panama City, FL 32401','(850) 872-7240','','','Panama City','Bay'],
  ["Pirate's Cove Marina PCB",'3901 Thomas Dr, Panama City Beach, FL 32408','(850) 234-3939','','piratescovemarinapcb.com','Panama City Beach','Bay'],
  // WALTON
  ["Tom's Landing Marina",'78 Ricker Ave, Santa Rosa Beach, FL','(850) 496-2741','tomslanding@gmail.com','tomslandingsrb.com','Santa Rosa Beach','Walton'],
  ['Shipyard Marina Freeport','116 Shipyard Rd, Freeport, FL','(850) 880-2324','info@shipyardmarinafreeport.com','shipyardmarinafreeport.com','Freeport','Walton'],
  // OKALOOSA
  ['HarborWalk Marina','66 Harbor Blvd, Destin, FL','(850) 650-2400','','harborwalkmarina.net','Destin','Okaloosa'],
  ['Fort Walton Beach Yacht Basin','104 Miracle Strip Pkwy SW, Fort Walton Beach, FL','(850) 244-5725','info@fwbyachtbasin.com','fwbyachtbasin.com','Fort Walton Beach','Okaloosa'],
  ['Adventure Marina','1201-B Miracle Strip Pkwy SE, Fort Walton Beach, FL','(850) 581-2628','','adventuremarina.com','Fort Walton Beach','Okaloosa'],
  ['Sunset Isle Yacht Club','1350 Miracle Strip Pkwy SE, Fort Walton Beach, FL','(850) 500-2628','','sunsetisle.com','Fort Walton Beach','Okaloosa'],
  // SANTA ROSA
  ['Santa Rosa Yacht & Boat Club','300 Pensacola Beach Rd, Gulf Breeze, FL','(850) 934-1005','','santarosayachtclub.com','Gulf Breeze','Santa Rosa'],
  ['Milton Marina','Quinn Street, Milton, FL 32570','(850) 983-5466','parksandrec@miltonfl.org','miltonfl.org','Milton','Santa Rosa'],
  ['Marquis Bayou Marina','7001 Old Spanish Trail, Milton, FL 32583','(850) 266-7728','','marquisbayou.com','Milton','Santa Rosa'],
  ['East River Smokehouse Marina','8491 Navarre Pkwy, Navarre, FL 32566','(850) 939-2802','','eastriversmokehouse.com','Navarre','Santa Rosa'],
  ['Bluewater Bay Marina','290 Yacht Club Drive, Niceville, FL 32578','','','bluewaterbaymarina.com','Niceville','Santa Rosa'],
  // ESCAMBIA
  ['Southwind Marina','10121 Sinton Dr, Pensacola, FL 32502','(850) 619-6348','gmsouthwind@gmail.com','southwindmarina.com','Pensacola','Escambia'],
  ['Palafox Pier Yacht Harbor Marina','997 S Palafox St, Pensacola, FL 32502','(850) 432-9620','','','Pensacola','Escambia'],
  ['Day Break Marina','811 South R Street, Pensacola, FL 32502','(850) 434-9022','','daybreakmarina.com','Pensacola','Escambia'],
  ['Chico Marina','3009 Barrancas Ave, Pensacola, FL 32507','(850) 453-8863','','','Pensacola','Escambia'],
  ["Mac's Marina",'31 Newman Avenue, Pensacola, FL 32507','(850) 453-3775','','macsmarinafl.com','Pensacola','Escambia'],
  ['MarineMax Pensacola','1901 Cypress St, Pensacola, FL 32502','(850) 477-1112','','marinemax.com','Pensacola','Escambia'],
  ['Island Cove Marina','806 Lakewood Rd, Pensacola, FL 32507','(850) 455-4552','office@segersmarine.com','segersmarine.com','Pensacola','Escambia'],
  ['Rod & Reel Marina','10045 Sinton Dr, Pensacola, FL 32502','(850) 492-0100','','','Pensacola','Escambia'],
  ['Pensacola Beach Marina','655 Pensacola Beach Blvd, Pensacola Beach, FL 32561','(850) 932-8466','','pensacolabeachmarina.com','Pensacola Beach','Escambia'],
  ['Sabine Marina','715 Pensacola Beach Blvd, Pensacola Beach, FL 32561','(850) 932-1904','','sabinemarina.com','Pensacola Beach','Escambia'],
  ['Pier One Marina','655 Pensacola Beach Blvd, Pensacola Beach, FL 32561','(850) 781-4180','','pieronemarina.com','Pensacola Beach','Escambia'],
  ['Holiday Harbor Marina','14050 Canal-A-Way, Pensacola, FL 32507','(850) 492-0555','office@myholidayharbor.com','myholidayharbor.com','Pensacola','Escambia'],
  // DUVAL
  ['Port 32 Jacksonville','4234 Lakeside Dr, Jacksonville, FL 32210','(904) 387-5538','','port32marinas.com','Jacksonville','Duval'],
  ['Ortega River Marina','4585 Lakeside Dr, Jacksonville, FL 32210','(904) 389-1199','ortegarivermarina@gmail.com','ortegarivermarinajax.com','Jacksonville','Duval'],
  ['Sadler Point Marina','4599 Lakeside Dr, Jacksonville, FL 32210','(904) 384-1383','brooks@sadlerpoint.com','sadlerpointmarina.com','Jacksonville','Duval'],
  ['Lakeshore Marine Center','3326 Lakeshore Blvd, Jacksonville, FL 32210','(904) 384-6447','info@lakeshoremarinecenter.com','lakeshoremarinecenter.com','Jacksonville','Duval'],
  ['Arlington Marina','5137 Arlington Rd, Jacksonville, FL 32211','(904) 743-2628','info@arlingtonmarina.com','arlingtonmarina.com','Jacksonville','Duval'],
  ['Seafarers Marina','455 Trout River Dr, Jacksonville, FL 32208','(904) 765-8152','seafarersmarina@aol.com','seafarersmarina.com','Jacksonville','Duval'],
  ['HarborTown Marina Jacksonville','13846 Atlantic Blvd, Jacksonville, FL 32225','(904) 220-3600','','jaxharbortownmarina.com','Jacksonville','Duval'],
  ['Julington Creek Marina','12807 San Jose Blvd, Jacksonville, FL 32223','(904) 268-5117','julingtoncreekmarina@outlook.com','marinaatjulingtoncreek.com','Jacksonville','Duval'],
  ['Palm Cove Marina','14603 Beach Blvd Ste 100, Jacksonville, FL 32250','(904) 223-4757','','palmcovemarina.com','Jacksonville','Duval'],
  ['Fort George Island Marina','9954 Heckscher Dr, Jacksonville, FL 32226','(904) 251-0050','','fortgeorgeislandmarina.com','Jacksonville','Duval'],
  ["Lamb's Yacht Center",'3376 Lake Shore Blvd, Jacksonville, FL 32210','(904) 327-2285','','lambsyachtcenter.com','Jacksonville','Duval'],
  ['Beach Marine','2315 Beach Blvd, Jacksonville Beach, FL 32250','(904) 249-8200','','jaxbeachmarine.com','Jacksonville Beach','Duval'],
  ['Morningstar Marinas Mayport','4852 Ocean St, Atlantic Beach, FL 32233','(904) 236-6210','','morningstarmarinas.com','Atlantic Beach','Duval'],
  // ST. JOHNS
  ['St. Augustine Municipal Marina','111 Avenida Menendez, St. Augustine, FL 32084','(904) 825-1026','marina@citystaug.com','citystaug.com','St. Augustine','St. Johns'],
  ['Camachee Cove Yacht Harbor','3070 Harbor Dr, St. Augustine, FL 32084','(904) 829-5676','CCYHoffice@MyWindward.com','camacheeisland.com','St. Augustine','St. Johns'],
  ['The Conch House Marina Resort','57 Comares Ave, St. Augustine, FL 32080','(904) 824-4347','info@conchhousemarinaresort.com','conchhousemarinaresort.com','St. Augustine','St. Johns'],
  ['English Landing Marina','509 S Ponce de Leon Blvd, St. Augustine, FL 32084','(904) 669-7363','info@englishlandingmarina.com','englishlandingmarina.com','St. Augustine','St. Johns'],
  ["Cat's Paw Marina",'220 Nix Boat Yard Rd, St. Augustine, FL 32084','(904) 829-8040','Info@CatsPawMarina.com','catspawmarina.com','St. Augustine','St. Johns'],
  ['Oasis Boatyard & Marina','256 Riberia St, St. Augustine, FL 32084','(904) 824-2520','','oasisboatyardandmarina.com','St. Augustine','St. Johns'],
  // NASSAU
  ['Fernandina Harbor Marina','3 S Front St, Fernandina Beach, FL 32034','(904) 310-3300','fernandinaharbor@alliancemarine.co','fernandinaharbormarina.com','Fernandina Beach','Nassau'],
  ['Amelia Island Marina','251 Creekside Dr, Fernandina Beach, FL 32034','(904) 277-4615','ameliaisland@suntex.com','ameliaislandmarina.com','Fernandina Beach','Nassau'],
  ['Olde Towne Marina','1420 N 14th St, Fernandina Beach, FL 32034','(904) 277-8511','oldetownemarina@bellsouth.net','oldetownemarina.com','Fernandina Beach','Nassau'],
];

// ══════════════════════════════════════════════════════════
// ASTILLEROS — FLORIDA NORTE
// ══════════════════════════════════════════════════════════
const ASTILLEROS = [
  ['Daytona Marina & Boat Works','645 S Beach St, Daytona Beach, FL 32114','(386) 252-6421','dawn645@thedaytonamarina.com','thedaytonamarina.com','Daytona Beach','Volusia'],
  ['Sea Love Boat Works','4877 Front St, Ponce Inlet, FL 32127','(386) 761-5434','sealoveboatworks@gmail.com','sealoveboatworks.com','Ponce Inlet','Volusia'],
  ['Lighthouse Boatyard','4958 S Peninsula Dr, Ponce Inlet, FL 32127','(386) 767-0683','','','Ponce Inlet','Volusia'],
  ['Seven Seas Marina & Boatyard','3300 S Peninsula Dr, Port Orange, FL 32127','(386) 761-3221','sevenseasmarina@bellsouth.net','sevenseasmarina.com','Port Orange','Volusia'],
  ['Westland Boatyard and Marina','419 N Washington Ave, Titusville, FL 32796','(321) 267-1667','','westlandmarina.com','Titusville','Brevard'],
  ['Port Canaveral Marine','960 Mullet Rd, Cape Canaveral, FL 32920','(321) 799-9444','','portcanaveralmarine.com','Cape Canaveral','Brevard'],
  ['Anchorage Yacht Basin','96 E Eau Gallie Cswy, Melbourne, FL 32937','(321) 773-3620','','anchorageyachtbasin.com','Melbourne','Brevard'],
  ['Sebastian River Marina & Boatyard','8525 US Hwy 1, Sebastian, FL 32976','(772) 664-3029','d.hillman@sebastian-river-marina.com','','Sebastian','Indian River'],
  ['Crystal River Marine Inc.','990 N Suncoast Blvd, Crystal River, FL 34429','(352) 795-2597','','crystalrivermarine.com','Crystal River','Citrus'],
  ['Three Rivers Marine','1038 N Suncoast Blvd, Crystal River, FL 34429','(352) 563-5510','sales@threeriversmarineinc.com','threeriversmarineinc.com','Crystal River','Citrus'],
  ['MS Dockside Marina & Boatyard','292 Graham Dr, Carrabelle, FL 32322','(850) 697-3337','msdocksidemarina@gmail.com','msdockside.com','Carrabelle','Franklin'],
  ['Eastern Shipbuilding Group','432 Howard Road, Port St. Joe, FL 32456','(850) 763-1900','','easternshipbuilding.com','Port St. Joe','Gulf'],
  ['Bay County Boatyard','101 N Church Ave, Panama City, FL 32401','(850) 215-9283','','baycountyboatyard.com','Panama City','Bay'],
  ['Panhandle Marina & Boatyard','101 N Church Ave, Panama City, FL 32401','(850) 481-0556','info@panboatyard.com','panboatyard.com','Panama City','Bay'],
  ['Marker 21 Boatyard & Marina','36 Miracle Strip Pkwy SW, Fort Walton Beach, FL','(850) 244-2722','markertwentyonemarina@gmail.com','marker21boatyardandmarina.com','Fort Walton Beach','Okaloosa'],
  ['Coastal Marine Works','2816 Gulf Breeze Pkwy, Gulf Breeze, FL','(850) 637-9585','','coastalmarineworks.com','Gulf Breeze','Santa Rosa'],
  ['Pensacola Marine Center','700 S Myrick St, Pensacola, FL 32501','(850) 439-1451','bob@pensacolamarinecenter.com','pensacolamarinecenter.com','Pensacola','Escambia'],
  ["Pelican's Perch Marina and Boatyard",'40 Audusson Ave, Pensacola, FL 32507','(850) 453-3471','','pelicansperchmarina.com','Pensacola','Escambia'],
  ['Huckins Yacht Corporation','3482 Lake Shore Blvd, Jacksonville, FL 32210','(904) 389-1125','service@huckinsyacht.com','huckinsyacht.com','Jacksonville','Duval'],
  ['Sadler Point Marine Center','4599 Lakeside Dr, Jacksonville, FL 32210','(904) 384-1383','brooks@sadlerpoint.com','sadlerpointmarina.com','Jacksonville','Duval'],
  ['Atlantic Coast Marine','13748 Atlantic Blvd, Jacksonville, FL 32225','(904) 221-0793','','atlanticcoastmarine.com','Jacksonville','Duval'],
  ['St. Augustine Marine Center','404 S Riberia St, St. Augustine, FL 32084','(904) 824-4394','','staugustinemarine.com','St. Augustine','St. Johns'],
  ['St. Augustine Shipyard','117 Dockside Dr, St. Augustine, FL 32084','','','camacheeyachtyard.com','St. Augustine','St. Johns'],
  ['Tiger Point Marina & Boat Works','997 Egans Creek Ln, Fernandina Beach, FL 32034','(904) 277-2720','tigerpointmarina@comcast.net','tigerpointmarina.biz','Fernandina Beach','Nassau'],
];

// ══════════════════════════════════════════════════════════
// ALMACENAMIENTO — FLORIDA NORTE
// ══════════════════════════════════════════════════════════
const ALMACENAMIENTO = [
  ['All Aboard Storage - Ormond Beach','305 W Granada Blvd, Ormond Beach, FL','(386) 333-6801','','allaboardstorage.com','Ormond Beach','Volusia'],
  ['Stor-It Boat & RV - Ormond Beach','99 Portland St, Ormond Beach, FL','(386) 676-5018','','storitboatandrv.com','Ormond Beach','Volusia'],
  ['Barracuda Boat & RV Storage','412 W Park Ave, Edgewater, FL','(386) 847-8112','info@boatrvstorage.com','boatrvstorage.com','Edgewater','Volusia'],
  ['RecNation RV & Boat Storage - Edgewater','403 Timaquan Trail, Edgewater, FL','(386) 433-8698','','recnationstorage.com','Edgewater','Volusia'],
  ['All Aboard Storage - Daytona Beach','1325 S Nova Road, Daytona Beach, FL','(386) 200-9442','','allaboardstorage.com','Daytona Beach','Volusia'],
  ['All Aboard Storage - Palm Coast','6372 SR 100 East, Palm Coast, FL','(386) 388-7739','','allaboardstorage.com','Palm Coast','Flagler'],
  ['Stor-It of Flagler County','3700 E Moody Blvd, Bunnell, FL','(386) 263-3067','','storitofflaglercounty.com','Bunnell','Flagler'],
  ['Sebastian Inlet Marina Dry Storage','8685 US-1, Micco, FL 32976','(772) 664-8500','SIMoffice@mywindward.com','sebastianinletmarina.com','Micco','Indian River'],
  ['Mr. Stor-It Merritt Island','500 Cone Rd, Merritt Island, FL 32952','(321) 453-3400','','mrstorit.com','Merritt Island','Brevard'],
  ['Crystal River Boat and RV Storage','S Suncoast Blvd, Crystal River, FL','','','crystalriverboatrvstorage.com','Crystal River','Citrus'],
  ['Wakulla Station RV & Boat Storage','Crawfordville, FL','','','wakullastationrvandboatstorage.com','Crawfordville','Wakulla'],
  ['Storage by the Sea','Navarre, FL','(850) 374-1648','','','Navarre','Santa Rosa'],
  ['East Bay Boat & RV Storage','Navarre, FL','(850) 939-9040','','','Navarre','Santa Rosa'],
  ['Old River Boat Storage','4837 Ocean St, Atlantic Beach, FL 32233','(904) 874-4132','oldriverboatstorage@gmail.com','oldriverboatstorage.com','Atlantic Beach','Duval'],
  ["Solomon's RV & Boat Storage",'14255 Beach Blvd, Jacksonville, FL 32250','(904) 223-0888','','solomons.net','Jacksonville','Duval'],
  ["Captain's Cove Dry Stack Storage",'1646 Captain Carl Raffield Way, Port St Joe, FL','(850) 227-3357','info@captainscovefl.com','captainscovefl.com','Port St. Joe','Gulf'],
];

// ══════════════════════════════════════════════════════════
// SUMINISTROS — FLORIDA NORTE
// ══════════════════════════════════════════════════════════
const SUMINISTROS = [
  ['West Marine - Daytona Beach','1300 W International Speedway Blvd, Daytona Beach, FL','(386) 255-2013','','westmarine.com','Daytona Beach','Volusia'],
  ['Aloha Marine Center','1700 N Nova Rd, Holly Hill, FL','(386) 255-2345','','alohamarine.com','Holly Hill','Volusia'],
  ['Bluewater Marine Daytona','730 Ridgewood Ave, Holly Hill, FL','(386) 255-7790','','bluewatermarine.com','Holly Hill','Volusia'],
  ['Atlantic Marine Port Orange','520 Dunlawton Ave, Port Orange, FL','(386) 788-1644','robert@atlanticmarinefl.com','atlanticmarinefl.com','Port Orange','Volusia'],
  ['North Causeway Marine','4 N Causeway, New Smyrna Beach, FL','(386) 427-5267','','northcausewaymarine.com','New Smyrna Beach','Volusia'],
  ['West Marine Palm Coast','250 Palm Coast Pkwy NE, Palm Coast, FL','(386) 276-7001','','westmarine.com','Palm Coast','Flagler'],
  ['Carp Coastal Marine & RV','4550 S US Hwy 1, Grant, FL','(321) 952-1303','carpcoastalmarine@carpindustries.com','carpcoastalmarine.com','Grant','Indian River'],
  ['Vero Marine Center','12 Royal Palm Pointe, Vero Beach, FL','(772) 562-7922','','veromarine.com','Vero Beach','Indian River'],
  ['West Marine West Melbourne','1001 W New Haven Ave, West Melbourne, FL','(321) 837-1113','','westmarine.com','West Melbourne','Brevard'],
  ['MarineMax Cocoa','1410 King St, Cocoa, FL 32922','(321) 636-3142','','marinemax.com','Cocoa','Brevard'],
  ['Boaters Exchange','2145 US-1, Rockledge, FL','(321) 638-0090','','boatersexchange.com','Rockledge','Brevard'],
  ['West Marine Crystal River','160 SE Hwy 19, Crystal River, FL','(352) 563-0003','','westmarine.com','Crystal River','Citrus'],
  ["Nobles' Marine Crystal River",'1931 NW Highway 19, Crystal River, FL','(352) 329-3739','','noblesmarine.com','Crystal River','Citrus'],
  ['Homosassa Marine','3120 S Suncoast Blvd, Homosassa, FL 34448','(352) 628-2991','','homosassamarine.com','Homosassa','Citrus'],
  ['Marina Hardware at Cedar Key','409 1st St, Cedar Key, FL','(352) 543-5804','','marinahardwarecedarkey.com','Cedar Key','Levy'],
  ['RMS Marine Supply','3026 Coastal Hwy, Crawfordville, FL','(850) 926-3114','','rmsmarinesupply.com','Crawfordville','Wakulla'],
  ['West Marine Panama City','427 E 23rd St, Panama City, FL','(850) 763-6104','','westmarine.com','Panama City','Bay'],
  ['West Marine Panama City Beach','2225 Thomas Dr, Panama City Beach, FL','(850) 234-7699','','westmarine.com','Panama City Beach','Bay'],
  ['Miller Marine Inc','7141 Grassy Point Rd, Panama City, FL','(850) 265-6768','','millermarineinc.net','Panama City','Bay'],
  ["Howell Marine & Tackle Supply",'3100 W Highway 98, Panama City, FL','(850) 785-8548','','howelltacklesupply.com','Panama City','Bay'],
  ['West Marine Destin','862-B Hwy 98 East, Destin, FL','','','westmarine.com','Destin','Okaloosa'],
  ['The Ships Chandler - Destin','646 Harbor Blvd, Destin, FL','(850) 837-2262','','theshipschandler.com','Destin','Okaloosa'],
  ['The Ships Chandler - Freeport','17309 Highway 331, Freeport, FL','(850) 880-6259','','theshipschandler.com','Freeport','Walton'],
  ['Emerald Coast Marine Group','115 W John Sims Pkwy, Niceville, FL','(850) 389-8318','','emeraldcoastmarine.com','Niceville','Okaloosa'],
  ['Gulf Breeze Marine','2933 Gulf Breeze Pkwy, Gulf Breeze, FL','(850) 932-1556','gbmarineshop@outlook.com','gulfbreezemarine.com','Gulf Breeze','Santa Rosa'],
  ['West Marine Pensacola','5303 N Davis Hwy, Pensacola, FL','(850) 483-5523','','westmarine.com','Pensacola','Escambia'],
  ['BGS Marine Sales & Service','3910 W Navy Blvd, Pensacola, FL','(850) 438-5934','sales@bgsmarinesales.com','bgsmarinesales.com','Pensacola','Escambia'],
  ['Perdido Marine Supply','12490 Gulf Beach Hwy, Pensacola, FL','(850) 361-1191','','perdidotradingcompany.com','Pensacola','Escambia'],
  ['Gulf Coast Marine Supply','7885 Pensacola Blvd, Pensacola, FL','(850) 476-4910','','gulfcoastmarine.com','Pensacola','Escambia'],
  ['West Marine Jacksonville','4874 Big Island Dr, Jacksonville, FL','(904) 520-4650','','westmarine.com','Jacksonville','Duval'],
  ['West Marine Jacksonville Beach','14180 Beach Blvd, Jacksonville, FL','(904) 821-5033','','westmarine.com','Jacksonville Beach','Duval'],
  ['Specialty Marine & Industrial Supplies','1420 Mayport Rd, Atlantic Beach, FL','(904) 247-3303','','specialtymarinefl.com','Atlantic Beach','Duval'],
  ['Main Street Marine','9211 N Main St, Jacksonville, FL','(904) 757-3100','','mainstmarine.com','Jacksonville','Duval'],
  ['MarineMax Jacksonville','2079 Beach Blvd, Jacksonville Beach, FL','(904) 338-9970','','marinemax.com','Jacksonville Beach','Duval'],
  ['Ocean Outboard Marine','1619 N 14th St, Fernandina Beach, FL','(904) 321-1422','','oceanoutboardmarine.com','Fernandina Beach','Nassau'],
  ['Chelsea Boat Center','96114 David Hallman Pkwy, Yulee, FL','(904) 261-8884','','chelseamarinesupply.com','Yulee','Nassau'],
];

function buildSheet(data, sheetTitle) {
  const rows = [[sheetTitle]];
  rows.push(HEADERS);
  data.forEach((row, i) => {
    rows.push([i + 1, ...row]);
  });
  return xlsx.utils.aoa_to_sheet(rows);
}

function main() {
  console.log('Leyendo Excel...');
  const wb = xlsx.readFile(EXCEL_PATH);

  // Crear hojas nuevas para Florida Norte
  const sheets = [
    { name: 'MARINAS_NORTE',      data: MARINAS,      title: 'Marinas — Florida Norte (Sesión 6)' },
    { name: 'ASTILLEROS_NORTE',   data: ASTILLEROS,   title: 'Astilleros — Florida Norte (Sesión 6)' },
    { name: 'ALMACENAMIENTO_NORTE', data: ALMACENAMIENTO, title: 'Almacenamiento — Florida Norte (Sesión 6)' },
    { name: 'SUMINISTROS_NORTE',  data: SUMINISTROS,  title: 'Suministros — Florida Norte (Sesión 6)' },
  ];

  for (const s of sheets) {
    if (wb.SheetNames.includes(s.name)) {
      wb.SheetNames.splice(wb.SheetNames.indexOf(s.name), 1);
    }
    wb.Sheets[s.name] = buildSheet(s.data, s.title);
    wb.SheetNames.push(s.name);
    console.log(`  ✅ ${s.name}: ${s.data.length} registros`);
  }

  // Actualizar RESUMEN
  const resWs = wb.Sheets['RESUMEN'];
  const resData = xlsx.utils.sheet_to_json(resWs, { header: 1 });
  // Agregar fila de totales norte FL
  resData.push(['Florida Norte', MARINAS.length, '-', '-', '-', '-', MARINAS.length, 'MARINAS_NORTE']);
  resData.push(['FL Norte Astilleros', '-', '-', '-', '-', '-', ASTILLEROS.length, 'ASTILLEROS_NORTE']);
  resData.push(['FL Norte Almacenamiento', '-', '-', '-', '-', '-', ALMACENAMIENTO.length, 'ALMACENAMIENTO_NORTE']);
  resData.push(['FL Norte Suministros', '-', '-', '-', '-', '-', SUMINISTROS.length, 'SUMINISTROS_NORTE']);
  wb.Sheets['RESUMEN'] = xlsx.utils.aoa_to_sheet(resData);

  xlsx.writeFile(wb, EXCEL_PATH);
  console.log(`\n🎉 Guardado exitosamente en: ${EXCEL_PATH}`);
  console.log(`\n📊 RESUMEN TOTAL:`);
  console.log(`   Marinas Norte FL:         ${MARINAS.length}`);
  console.log(`   Astilleros Norte FL:      ${ASTILLEROS.length}`);
  console.log(`   Almacenamiento Norte FL:  ${ALMACENAMIENTO.length}`);
  console.log(`   Suministros Norte FL:     ${SUMINISTROS.length}`);
  console.log(`   TOTAL NORTE FL:           ${MARINAS.length + ASTILLEROS.length + ALMACENAMIENTO.length + SUMINISTROS.length}`);
}

main();