formula between sheets

yes... clicking a tab will make a sheet active.

Good, I have to collect datasets from live instrumentation in real time and use that data to control ancillary devices. I use Excel to provide the data for control. Briefly various weather sensing devices (temp, humidity, wind speed and direction and air pressure) the output from these devices goes back to a PC running Excel and are input to the correct dataset column in Excel, this happens in 7 minute cycles for as long as the venue is active. From there they sum to a new column and an average value per cycle is generated. This transfers to a separate sheet in Excel for each parameter from which a value is derived, this value is then convert into a midi command and sent to control devices to affect the changes required. Reports are derived from the original sheet in Excel (providing values every 7 minutes) the summary sheet as well as controlling devices in real time provides the summary report of the behavior.

This covers my *ss on a number of requirements. I have a duty to provide the data to a number of gov't agencies, a duty to my audience (who do not want their ears damaged) and to local residents (who may not want to hear the show) I have strict pressure levels to adhere to, 1 spreadsheet (and a piece of custom software that runs as an Excel add-in to handle the midi translation) does it all.

It seems as if Numbers could do this if the midi translator could be recoded for it.

Thanks again.

Csound1 wrote:

It seems as if Numbers could do this if the midi translator could be recoded for it.

Thanks again.

So, Csound1, you have an apt username!

It seems as if Numbers could in theory handle the workflow you describe, as long as all those sheets are in the same document.

If you're using VBA to update values every 7 minutes in Excel then it might be tricky (though certainly possible) to duplicate that with AppleScript/Numbers.

SG

I am using VBA for some tasks, one thing that may be an issue with Numbers would be printing the various reports required, as it is now one day is represented by one of Excels sheets be it a summary or a detail page, this makes it simple to access and print. Hopefully that could be implemented in Numbers as simply. The bigger issue would be the Midi translator itself, our add in is for Excel, even porting it to Libre is a pain. But certainly it would be possible (just have to figure out who's paying for the time it would take) 🙂

This a bit of a summary itself, there are other tasks going on but nothing too complicated. A bigger issue would be that no gov't agency at the local or Federal level uses anything other than Excel, and compatibility with Excel is still a Numbers weakness.

Still better than I thought.

marknovom wrote:

Wow! I didn't realize my post would create so many responses about the differences between Sheets, Tables, and Tabs. Yes, Sheets in both Numbers and Google (I don't know about excel) is the same thing as Tabs.

Excels sheets are the same thing, they are called sheets but appear as tabs until selected

marknovom wrote:

But I think my original question got lost in the conversation. Can someone please tell me how to do what I need to do? It's not simply referencing a cell in a different Sheet (or Tab). I need the formula to put the difference from the number 24. So if the number is 20 on one sheet, I want the number 4 to go in "The Bank". If the number is 28 on one sheet, I want the number -4 to go in "The Bank".

Please look at my second post with the screenshots for the original explanations.

Mark

The formula =24-(banked cell value) will result in what you need to see, you can put that result wherever you want on the same or a different sheet.

Hi mark,

I still recommend INDIRECT() to retrieve your value from the 1st sheet. Revisit my post above and modify the formula to

=24−INDIRECT(A1&"::J18",addr-style).

"J18" if that is where your employee total hours is.

quinn