Support Board

Date/Time: Wed, 15 May 2024 07:21:02 +0000

Post From: tomgilb

[2014-02-18 04:58:15] Link To Thread - Link To Post [Go To First Post]
Sawtooth - Posts: 3996
I notice that you entered A1 and B1 in the last columns Y and Z, instead of placing the highest levels in the first two columns, K and L; any reason for that order? No reason. In hindsight, I'd do it as you suggest, especially since you are going to use all 60 columns. Is there a way to enter the formulas other than pasting a current cell's formula (for example, ='[Zones input.scwbf]Sheet1'!$B$1) and manually changing the numbers (for instance in Excel, you can drag cells and the formulas will increment and populate at the same time)? The only thing you change is the value in cells in the Zones input spreadsheet. You could just enter values in row 3 of the Zones output spreadsheet. The only reason this example uses the Zones input spreadsheet is because that user was pasting from another file. The absolute value in the formula ($B$1) is necessary because the spreadsheet study will advance the row# in rows below, and the value needs to be the same in all rows so that a horizontal zone is drawn.