(Read 2700 times)
When the going gets weird, the weird turn pro. - Hunter S. Thompson
Oct 10, 2012, 10:51 pm
It appears that the first column is simply a counter. It isn't really needed. (I recently went through this with my project.) It's trivial to number the data in the spreadsheet. If it goes to the first cell the row numbers should do it.
I don't know what you are doing with the data in the spreadsheet. Maybe you need each line numbered but if you think about it you might find that you don't.
Oct 17, 2012, 01:54 pm
The counter is not what I´m going to use. Later I insert a Real Time Clock Module.
So instead of counter, I´ll use time.
CODE is a mass noun and should not be used in the plural or with an indefinite article.
Adventures in Arduinoland
Oct 17, 2012, 02:40 pm
Very easy to parse data in Excel. Look for "Text to Columns" in the help. Can be parsed based on delimiters or fixed columns.
Oct 17, 2012, 02:43 pm
Here's how I get data into Excel columns, for experiments:
Serial.print() what I want to see, with a convenient delimiting character between data elements. A comma or a space usually works fine.
Copy and paste it into a single Excel column.
Data > Text to columns > Delimited > describe the delimiter
And, voila, it's in columns. For your application, you'll just want to be sure that your delimiter isn't a character that will show up in the timestamp you add later.