Saving Raw Sweep Data and Summary Parametric Data in Same file

[Bob_Schor]

Lay On, McDuff!  I definitely agree that breaking the Write Delimited Spreadsheet VI into a simpler series of Text Writes (which follow the "normal" convention of writing to the end of an open file, so you don't need the lower Boolean Shift Register and the silliness of opening and closing the file each time the While loop loops) makes more sense.  I was just trying to duplicate Gregory's RGT/Excel example using Write Delimited Spreadsheet just to show "what's possible" ...

Bob Schor

[mcduff]

@Bob_Schor

I don't like the Write Delimited Spreadsheet VI because there is always a buffer copy no matter what. Nothing against your VI, I thought it was a good example.

"Lay On", is that upsate New York vernacular?

mcduff

[Bob_Schor]

---

@mcduff wrote:

"Lay On", is that upsate New York vernacular?

mcduff

---

Nope, that's a phrase I learned as a junior in my (California) high school English class (I know McDuff gets it ...)

BS

[Michael_Munroe]

I had a similar problem with 20 columns of 5000 points of data.  Every point had to be corrected by a simple formula. 

I choose the multi-tab Excel file for my solution.  The data was written directly to the first tab.  The second tab contained just one row of the correction formulas.  A simple Excel macro expanded the formulas to match the number of rows on the first tab when the file was first opened.  The data files consumed the least amount of space until opened.

[Bob_Schor]

---

@Bob_Schor wrote:

---

@mcduff wrote:

"Lay On", is that upsate New York vernacular?

mcduff

---

Nope, that's a phrase I learned as a junior in my (California) high school English class (I know McDuff gets it ...)

BS

---

Sigh -- never so stupid as when trying to look smart!  The correct phrase is "Lay on, Macduff", from Shakespeare's "Macbeth".

BS