Spreadsheet studies on this site include an accompanying Study Collection to ensure the correct spreadsheet study and supporting studies are loaded, and have the necessary settings. This eliminates most sharing problems except for the following:
1) If you apply it to a chart number other than the one used to create it, parameters in non-repeating cells will not follow to the new sheet, e.g. columns H and J, cells I1 and I2, and row 1 cells in the Formula Columns K-Z…BR. 2) If you have an existing spreadsheet study on a chart, applying it could overwrite sheet data on the existing spreadsheet. 3) When applying a spreadsheet study to a chart with existing studies, supporting studies will not be in output columns that the formulas expect. You must either edit the formulas, or move the studies (in the correct order) to the top of the Studies to Graph list (but only if there are no existing spreadsheet studies). |