BS2sx to Excel?
jhtoolman2000
Posts: 9
Hello guys,
Been along time member but haven't been on here awhile.· Breaking the stamp back out again to assist me in my small business.· I sketch portraits of NFL players and am getting big enough now that I would like to start inventoring·each picture·into·their own individual slots.· Right now as someone orders them, I grab them out of a pile and send them.· I need some organization.· As i was saying, I'm thinking I would like to put each picture into their own slot and and have a digital readout on each slot of how many prints are available for that picture.· As i take one out, I will hit a·button to select the slot that i want, then hit an up/down button to update that i have one less picture in that slot.·My question is this-as I select the print and update that slot, i want the BS2 to send that information to Excel where it will be keeping inventory for me.· It will keep track as i add or subtract from each picture.· I'm confident i can figure out something to do the selection process but getting hung up on the BS2 communication to Excel.· Anyone know of a quick code to get me started communicating to Excel?· Any help would be appreciated.· thanks.
jon
Been along time member but haven't been on here awhile.· Breaking the stamp back out again to assist me in my small business.· I sketch portraits of NFL players and am getting big enough now that I would like to start inventoring·each picture·into·their own individual slots.· Right now as someone orders them, I grab them out of a pile and send them.· I need some organization.· As i was saying, I'm thinking I would like to put each picture into their own slot and and have a digital readout on each slot of how many prints are available for that picture.· As i take one out, I will hit a·button to select the slot that i want, then hit an up/down button to update that i have one less picture in that slot.·My question is this-as I select the print and update that slot, i want the BS2 to send that information to Excel where it will be keeping inventory for me.· It will keep track as i add or subtract from each picture.· I'm confident i can figure out something to do the selection process but getting hung up on the BS2 communication to Excel.· Anyone know of a quick code to get me started communicating to Excel?· Any help would be appreciated.· thanks.
jon
Comments
The help files and examples should be enough to get you going on this. Just be sure to adjust the baud rate for the SX. Post if you run into problems.
http://www.parallax.com/html_pages/downloads/software/software_plxdaq.asp
-Martin
▔▔▔▔▔▔▔▔▔▔▔▔▔▔▔▔▔▔▔▔▔▔▔▔
StampPlot - GUI and Plotting, and XBee Wireless Adapters
Southern Illinois University Carbondale, Electronic Systems Technologies
Thanks Martin.· That should really help. thanks for the quick reply.·
Jon