Noob needs help...better way to calculate values than exporting to excel?

[dademurphy]

Hi.

Using Labview version 8.2.

I have 4 stripcharts outputting data to an excel spreadsheet (time and voltage), another excel spreadsheet importing those values and running some calculations on the numbers, and a word document (that must be used for company purposes) importing 4 calculated values.  There has got to be a better way to do this, seeing as the way word documents update links is such a pain, because I have to open up all the files consecutively to get them to update.  Please help!

Also, I have been waiting on my IT department to install the Office toolkit, would this help if it was installed? 

[MattBradley]

Doesn't sound like you need Excel at all.  Is there anything preventing you from doing all the calculations in LabVIEW?  What kind of calculations are you doing?

Office Toolkit could help you, but it sounds like you already have some way of getting data into Word (so it might not).

[jon_mcbee]

I agree with Matt.  It sounds like you should be able to do all this in LabVIEW and then use the Report Generation Toolkit to populate a word template with the results.  Can you talk more about your calculations?

[dademurphy]

Well, the calculations seem rather simple, but I guess I'm missing something...maybe it's the stripchart thing.

Measurements/calculations:

1-Max voltage value over the recorded time period X (times) a ratio

2-Slope (Voltage over Time), or more importantly change of slope, over the recorded time period X (times) a ratio

3-Slope (Voltage over Time), in between a specified set of voltages

[MattBradley]

So can you translate all of that into LabVIEW or do you need help with that?

[dademurphy]

I definitely need help with that. 

[altenbach]

---

dademurphy wrote:

Well, the calculations seem rather simple, but I guess I'm missing something...maybe it's the stripchart thing.

Measurements/calculations:

1-Max voltage value over the recorded time period X (times) a ratio

2-Slope (Voltage over Time), or more importantly change of slope, over the recorded time period X (times) a ratio

3-Slope (Voltage over Time), in between a specified set of voltages

---

Well, it's not quite clear what you need from these descriptions. Where does the "ratio" come from? How complicated is the slope behavior (just a smooth change or "all over the place"?) Who "specifies" the voltages in (3)?

Do you have a typical dataset and the expected results?

[STTLLER]

Hi friends

This is a nice thought. I am agree with you.

Joseph

[altenbach]

---

STTLLER wrote:

This is a nice thought. I am agree with you.

---

Which post are you referrring to?

[smercurio_fc]

Perhaps if you post the Excel file that does all the calculations then we could see what is meant by some of the terms you mention in your calculations.