good morning,
I have a set of data where each subject has multiple peaks in its wave form and when processed through the peak analyzer come out looking like (image A). From this output I reorganize the data so that each measure (ex. peak amplitude) gets its own sheet with each column representing a single subject and each row the data from the corresponding peak (image B). The analysis code I have has been working well, however, I run into an issue when my subject count gets around 1000 as the number of sheets needing to be made exceeds the maximum sheet allowance of 1000. What I need is a viable work around that will allow the analysis to move forward in the case of a subject count over 1000. Critically, this needs to be done with minimal changes to how the data is structured in the final output, as the rest of my analysis script rely on this format. Below is the current script I'm utilizing to reorganize the data. Thanks in advance -ZTK
wsplit mode:=ref ref:=[NCONT1ROI]1!A"Dataset ID" keepref:=0 missing:=0 keep:=0 sparkline:=0 owp:=<input> name:=<[<%V>]>;
wAppend irng:=[NCONT1ROI] ow:=[NCONT1ROI]<new name:=Sorted>;
wsplit iw:=[NCONT1ROI]Sorted! owp:=[NCONT1Peak] mode:=label label:=L copyform:=copyexc;
ZTK
wsplit/wAppend 1000 sheet limit
Posted - 09/30/2022 : 09:00:09 AM
