I have my first year project coming up and we decided to do a low accuracy tracking system.
This is what should happen in it.
Ill be using an RF transmitter to send a "code", eg - "B1" - Bus 1 to an arduino uno.
The arduino will then pick this up via a reciever. (i got it working up to this point only)
Once the arduino receives the code, it should then send a similar "code" in the form of "b1_s1" - bus 1 stop 1, to a certain column in an excel sheet. I searched all over the internet for about two weeks now. What i need excactly is to be able to send this data via gprs ( i got a module) but even USB would be fine now.
it should then send a similar "code" in the form of "b1_s1" - bus 1 stop 1, to a certain column in an excel sheet. ....... but even USB would be fine now.
Not sure what code is but, if data will do, try this.
This is reasonably doable with a high level scripting language (Perl, Python) and OLE. I only fiddled with the OLE stuff once about 15 years ago but had it working with just a couple days of effort -- was pulling call data from a PBX and building fancy executive reports with it. Anyway, below are some links to look at or otherwise try searching for OLE tutorials for the programming languages you're capable with.
Perl: Win32::OLE - OLE Automation extensions - metacpan.org