Reading data from Excel file into BS2

SharkBait

Is there a way to feed data from an excel sheet into a BASIC Stamp 2 so that the stamp will do math for us?

We are trying to get more code memory from the MS5607's sample code found here:
http://forums.parallax.com/showthread.php/134753-Parallax-s-New-Altimeter-Barometer-Module/page2?p=1055924&viewfull=1#post1055924

We don't have enough code memory to include all of the math in this program and also tie in other sensors we want for a balloon project.
We want to read out raw temperature and pressure (dT and and rawP in the code) through the radio into an Excel file for collection, then go back and have a stamp do the math to turn the numbers into something usable once the data is on the ground.

If worst comes to worst, we can digest all of the math in the code and have Excel do it, but we'd much rather have the pre-existing, working code do it if we can.

So, is there any way to set up the stamp to assign a string of data in Excel to variables so that we can treat it like measured data?

Thank you so much for your reply.

Mike Green

You should look at PLX-DAQ which is an Excel add-in that communicates with a Stamp using serial commands.

SharkBait

That's the software that we were planning to use to put the data into a spreadsheet to begin with, but I didn't see any indication of it being able to work in reverse.
Will it put data into​ a BS2?

Mike Green

The Stamp controls things, so the Stamp can request the value of a particular cell in the Excel spreadsheet. Look at the PLX-DAQ documentation and examples.

Tracy Allen

My immediate reaction is to move the project from the BS2 into a BS2pe. That immediately gives you 8x the program memory plus a 127 bytes of scratchpad RAM where you can store extra variables. More room for the computations and additional sensors.

-- Tracy