From: Danie Kinkade <Danie.Kinkade@noaa.gov>
Subject: Question about accession 0070530 .csv file
Date: February 11, 2011 10:22:41 AM EST
To: Pat Caldwell <caldwell@hawaii.edu>
Cc: NODC.DataOfficer@noaa.gov

Hey Pat!
Okay, so here's one more, sorry for the barrage of questions!

Accession 0070530 contains (digital) benthic survey data for Keei and Wawaloli. 
In checking the .csv in the 1-data I noticed one file contains an error string 
where data values should be. Went back to the excel workbook file and looked at 
that particular spreadsheet to find that each cell also contains that error string.

The original .xls workbook is here:
https://archive.nodc.noaa.gov/data/ingest/0070530/data/0-data/Claisse%20Data%20to%20Caldwell/
Kona%20Benthic%20Transect%20Data.xlsx

the sheet in question is named "Wawaloli 2"

and the .csv transform of that sheet is here:
https://archive.nodc.noaa.gov/data/ingest/0070530/data/1-data/
Kona_Benthic_Transect_Data_Wawaloli_2.csv

I think there is a cell in the original spreadsheet needs to link to a file outside 
of the workbook (upon opening the file in excel, you're prompted to let the program link 
to other files on the computer in order to update workbook. When not found, it opens the
workbook anyway, but there are cells with the string [#VALUE!] throughout the entire sheet.)

Have any words of wisdom on this one; can we get an updated sheet, etc?