Excel report for multiple data points using same named range

[iperry]

Heya,

I am trying to create an Excel report that details values for each sensor in the network every 10mins.

I can create the report setup and time period in the app for one sensor, i.e. L1-CS01-01 but when I try to assign the same named range to another data point, I get an error that the named range is already assigned.

If I try to create another time period in the report for the 2nd sensor, I get the same error when associating the data point to the named range.

Is it possible to create the report for multiple data points as I would like? Do I have to create a separate report for each sensor (set of data points)? I would like to avoid the separate reports as there may be 80+ sensors to report. Having a single report with multiple time periods would be tough to maintain.

Thanks
Ian

[phildunlap]

Hi Ian,

Why are you trying to do such a thing?

No, a named range can only be associated with one time period or series in one time range. The reason being is that the ranges expand and you would never want one series to overwrite another (which I believe you could still achieve by having two named ranges grow over one another, one down and one over).

If they are distinct time periods, why not put them on their own sheets? I would think Excel has the capacity to generate a column by appending columns on other sheets together.

I would expect you want 80+ named ranges for the columns in the report. You could have all the points in the same time period in the excel report setup, but you would probably want to separate each sheet into its own time period so that each sheet has timestamps that you could append together to create something like the example excel cells you posted.