Notifications
Clear all

Arduino to Excel

8 Posts
4 Users
4 Likes
299 Views
CrustyLarry
(@crustylarry)
Member
Joined: 2 years ago
Posts: 5
Topic starter  

This is probably the best I have seen on collecting data from a micro, Or sending to.


   
Quote
Ron
 Ron
(@zander)
Father of a miniature Wookie
Joined: 3 years ago
Posts: 6982
 

CSV?

First computer 1959. Retired from my own computer company 2004.
Hardware - Expert in 1401, and 360, fairly knowledge in PC plus numerous MPU's and MCU's
Major Languages - Machine language, 360 Macro Assembler, Intel Assembler, PL/I and PL1, Pascal, Basic, C plus numerous job control and scripting languages.
Sure you can learn to be a programmer, it will take the same amount of time for me to learn to be a Doctor.


   
ReplyQuote
(@dronebot-workshop)
Workshop Guru Admin
Joined: 5 years ago
Posts: 1085
 

@crustylarry Looks useful, thanks for posting it!

Posted by: @zander

CSV?

Is that a question, Ron?  Seems a little short on words!

😎

Bill

 

"Never trust a computer you can’t throw out a window." — Steve Wozniak


   
ReplyQuote
Will
 Will
(@will)
Member
Joined: 3 years ago
Posts: 2532
 

@zander 

CSV = comma separated values. It's a form of textifying spreadsheets and some oil database formats. The data is saved in a text file with words and strings enclosed in quotes; values are separated by commas and a carriage return (or newline or both) at the end of each record.

Anything seems possible when you don't know what you're talking about.


   
ron bentley and Ron reacted
ReplyQuote
Ron
 Ron
(@zander)
Father of a miniature Wookie
Joined: 3 years ago
Posts: 6982
 

@dronebot-workshop Sorry, I thought it was a universally understood term. I see @will already commented on it.

First computer 1959. Retired from my own computer company 2004.
Hardware - Expert in 1401, and 360, fairly knowledge in PC plus numerous MPU's and MCU's
Major Languages - Machine language, 360 Macro Assembler, Intel Assembler, PL/I and PL1, Pascal, Basic, C plus numerous job control and scripting languages.
Sure you can learn to be a programmer, it will take the same amount of time for me to learn to be a Doctor.


   
ReplyQuote
Ron
 Ron
(@zander)
Father of a miniature Wookie
Joined: 3 years ago
Posts: 6982
 

@dronebot-workshop I finally looked at the video. That is a nice automation of importing CSV data AND it adds real-time updates. It looks like there is quite a bit more to it. His setup didn't have a lot of variability in the data so it was hard to see how useful the result was. If the input was a weather station wind sensor, then showing 1st, 2nd, and 3rd order graphs might be of interest. I will (when I find time) add that to my station.

First computer 1959. Retired from my own computer company 2004.
Hardware - Expert in 1401, and 360, fairly knowledge in PC plus numerous MPU's and MCU's
Major Languages - Machine language, 360 Macro Assembler, Intel Assembler, PL/I and PL1, Pascal, Basic, C plus numerous job control and scripting languages.
Sure you can learn to be a programmer, it will take the same amount of time for me to learn to be a Doctor.


   
ReplyQuote
Ron
 Ron
(@zander)
Father of a miniature Wookie
Joined: 3 years ago
Posts: 6982
 

@dronebot-workshop @crustylarry @will I just discovered the version of Excell on myMac does not have that ability. That is one more reason for me buying the tiny Windows box.

What wasn't discussed was the ability to feed test data to the arduino from the spreadsheet, a feature I find much more compelling than the output side.

There are a few more YT vids on it.

First computer 1959. Retired from my own computer company 2004.
Hardware - Expert in 1401, and 360, fairly knowledge in PC plus numerous MPU's and MCU's
Major Languages - Machine language, 360 Macro Assembler, Intel Assembler, PL/I and PL1, Pascal, Basic, C plus numerous job control and scripting languages.
Sure you can learn to be a programmer, it will take the same amount of time for me to learn to be a Doctor.


   
ReplyQuote
Ron
 Ron
(@zander)
Father of a miniature Wookie
Joined: 3 years ago
Posts: 6982
 

Here is another 'Interesting thing'

First computer 1959. Retired from my own computer company 2004.
Hardware - Expert in 1401, and 360, fairly knowledge in PC plus numerous MPU's and MCU's
Major Languages - Machine language, 360 Macro Assembler, Intel Assembler, PL/I and PL1, Pascal, Basic, C plus numerous job control and scripting languages.
Sure you can learn to be a programmer, it will take the same amount of time for me to learn to be a Doctor.


   
ReplyQuote