Support Board
Support Board
Search Board
Control Panel
View My Posts / Threads
Direct MessagesDate/Time: Wed, 15 May 2024 01:03:35 +0000
Post From: tomgilb
| [2014-02-17 23:33:14] |
| Sawtooth - Posts: 3996 |
|
Can the writing of data back to the output file be prevented; is it necessary, it must create overhead??
You could conditionally prevent a value with a more complex formula, but if you keep the Number of Rows to the default 1000, the overhead will remain minimal. If you don't want to draw a zone, blank or zero the cell pair on the Zones input spreadsheet.How can I add more formulas in the columns beyond Z to use 30 zones; they fill up with data from other studies?
Set the Number Of Formula Columns to 60, then set the Draw Style pairs of the remaining subgraphs. The other study outputs will move to column BS and above. To remove the old study output data in columns AA and above, highlight the columns and press DEL (before you put formulas there).I see the formulas in the spreadsheet to indicate which input file cells to reference, but there must be code somewhere to draw the zones; where?
Using the values returned by the spreadsheet formulas, the zones are drawn by the Draw Styles on the spreadsheet study's Subgraphs tab. Columns K-Z...BR are SG1-SG16...SG60 respectively.Each time I change the zone output settings & inputs and subgraph colors and save them as default, reloading the zones indicator from the collection, sets everything back to the original.
Applying a study collection will override a saved default. Instead of saving a default, 'Save Single' the spreadsheet study as a study collection. This is done when viewing the Studies to Graphs list by highlighting only the spreadsheet study. |