I have a project to do for a class and it's a cost benefit analysis.

I have one page with what should be variables

ex

currentPwrcost current power cost per KWH

currentServerPwr current server power usage

newServerPwr calculated server power usage for the new server


I have a column to the left of the variables that I have the values in.

How do I make it so I can use these variables on another page for the current cost per year and then the projected cost with the new setup


(I have a bunch of other variables these are just an example)

I am running Excel 2007

thanks guys

Can't you just redefine the variable on the second page as the same thing, or basically use the same reference?

on page 2
='Page1'!currentPwrcost

__________________
TC
Current stable:
- 2004 Mazda RALLYWANKEL
- 2007 Saturn sky redline
- 2004 Explorer...under surgery.

Past: 135i, GTI, 300E, 300SD, 300SD, Stealth

You can use any variable from any Excel worksheet on any other worksheet even if they're not in the same workbook. Just copy a variable on one sheet, switch to the other sheet and do a "paste link".

Then, they will stay sync'd. You can also put the reference worksheet name in front of the variable name like TC's example.

__________________
-Evan


Benz Fleet:
1968 UNIMOG 404.114
1998 E300
2008 E63


Non-Benz Fleet:
1992 Aerostar
1993 MR2
2000 F250

Does "page" substitute for "sheet"?

Hypothetically, say you've got your variables in sheet 1. cost/kwh is sheet 1 cell A4. Sheet 2 is server X, sheet 3 server Y, etc. Say you've got forecast kW in B4 on sheet 2 and you need a dollar value in cell C4. Is that sort of how you're setting it up?

I think tbo's comments are basically correct and to calculate the rate*demand you just need

for sheet 2 cell c4 it would be =sheet1!A4*B4

Copying and pasting SHOULD do this for you. If the sheets have names like "variables, server X, server Y" then you may have to replace the sheet number with the name. Don't underestimate the power of "paste special" and then pick your options, like "paste values". That simply pastes the numeric value of the cell and reduces broken references. But that's a one shot deal. If you change the original cell later on, it won't propagate.

Yak, it's something like that. Yes, 3 sheets.

So, cell A4 could be my 2455 watts and cell A5 would be my variable. Using that formula will make A5 = A4 then?

I think excel is the same as the open office spread sheet.

If you want to reference a cell on a different sheet then you can type in the = sign in the cell where you want the information; then click on the sheet you want and then click on the cell you want. Press return. You should go back to the cell where you've just entered this "formula"

If you want that to be a fixed value then you need to add in a $ sign for each part of the formula to fix it. So $SHEET $COLUMN $ ROW Then it won't move. If you want for example the whole column on another sheet just $ up to the column and leave the row. Copying from your new cell will reference to the subsequent values above or below the original cells...

__________________
1992 W201 190E 1.8 171,000 km - Daily driver
1981 W123 300D ~ 100,000 miles / 160,000 km - project car stripped to the bone
1965 Land Rover Series 2a Station Wagon CIS recovery therapy!
1961 Volvo PV544 Bare metal rat rod-ish thing

I'm here to chat about cars and to help others - I'm not here "to always be right" like an internet warrior



Don't leave that there - I'll take it to bits!

So, there is no way in Excel to assign the variables in my variables sheet an integer value? I cant stop thinking how to do it in C or Java, if you know what I mean.

I just want to do

newServerCost = 114196.00

(for example)

then be able to use that in my other sheets to perform math on.

Don -

The suggestions above SHOULD work for you - the best way to do this is like this below.

1) Start on the worksheet page that you want to produce the formula on (say Page2). Go to a cell and type "=" to start the formula. Then, while the formula is activated (will have a blinking border around it), navigate to the other page of the worksheet (say Page2) and click on the Cell that you want to use in your formula. This will pickup that cell from that page and place it in your formula - no problem. Formulas will looks something like the section shown below:

The above reads: Contents of Cell A4 on Sheet1 multiplied by contents of B4 cell on current sheet.... etc

Continue adding arithmetic signs as needed with values from any place on the worksheet - including different pages as you see fit. Use of parenthesis is useful to avoid confusion (to you, not the program)...

I've done this successfully with a work sheet that analyzes RE investment potential: property information all on one page; mortgage schedule an another (for readability). Values on one worksheet page, reference cells on another worksheet page. Works well.

Good luck -
James

__________________
1987 Mercedes 300SDL; SOLD
1985 Mercedes 300D; SOLD
2006 Honda Pilot - wife's ride; 122K;
1995 Toyota Land Cruiser - 3X locked; 182K

You have to kind of translate programming formula's into spreadsheet cells. You can think of every cell in the sheet as a variable. The names just happen to be "A4" and "GG6".

Now, you can put a number or a formula or a logic statement into a cell then you can use that cell number as part of another equasion in another cell and on and on.

So, in a cell type "New Server Cost". In the cell adjacent to that, enter 114196.00. Then, you can incorporate the label of the cell with the "114196.00" in it into other formulas on the same sheet or other worksheets. So, let's say that the label of the cell with the number in it is "F5". Any time you want to use the 114196.00 in an equasion, you simply substitute "F5".

If you have a crossloop setup, I can link to your computer and show you directly.

__________________
-Evan


Benz Fleet:
1968 UNIMOG 404.114
1998 E300
2008 E63


Non-Benz Fleet:
1992 Aerostar
1993 MR2
2000 F250

Hmm I guess I'm not quite sure what you're trying to do...whatever it is, my solution should have worked. I thought you were trying to carry over and assign a variable in multiple worksheets.

__________________
TC
Current stable:
- 2004 Mazda RALLYWANKEL
- 2007 Saturn sky redline
- 2004 Explorer...under surgery.

Past: 135i, GTI, 300E, 300SD, 300SD, Stealth

I think he's trying to do something really simple but he's approaching it like a program with defined variables and such that you don't need in Excel.

__________________
-Evan


Benz Fleet:
1968 UNIMOG 404.114
1998 E300
2008 E63


Non-Benz Fleet:
1992 Aerostar
1993 MR2
2000 F250

If all you want to do is have the variables visible in every sheet, a simple copy and past ought to do that. Highlight the relevant cells on sheet 1, paste them into sheets 2 and 3. You should see a number (integer) in the spreadsheet itself, but a reference to the location of the original number will be in the field above the table.

If you only want to paste the integer value, copy, then navigate to where you want to paste, right click, select "paste special", select "values" and that will only paste the current integer value of the copied cell into the pasted cell. This is useful for copying info from one file into another file. If you try to paste across files you can get errors or broken links.

I'm not sure I follow your example exactly, but putting an = in the beginning of a cell value tells that cell you're going to do something to it. When you say power (fixed number?) in A4 and variable in A5, all you need to do to multiply the constant times the variable is type in a different cell =A4*A5. If A4 is on sheet 1, that becomes =sheet1!A4*A5.

Think of each cell on each sheet as an address or location. The software assumes the cell is on the same sheet unless you tell it otherwise. =locationX[some math function]locationY should get it done.

I've done a mini template. Notice the sheets are named for the info on them. This affects the reference names. Sometimes it's a helpful touch if you're navigating through different items. I added a roundup function reference since you can't buy a fraction of a server. Excel, when used properly can be pretty powerful but you have to learn the quirks.

Attached Files

example.zip (6.6 KB, 15 views)

Pretty much......

Thanks yak. I'm going to see the TA tomorrow. Maybe he can show me what you are explaining and maybe he will be able to understand what I'm trying to do.

So what I understand is that I cannot assign a cell to just equal a variable name then?

Cell C3 = 114196.00
Cell C4 = newServerCost

so, on my second sheet if I'd like to show the cost for 4 servers I'd use

what yak and you mentioned

call sheet1 or what I have it as variables then multiply what I have in C3 by 4 on my sheet for virtulized like so

variable!C3*4

si?

then I can do whatever arthimatic I'd like then?

Close, the format of the cell formula on the second sheet would be: =Sheet1!$C$3*4

You can rename the variable sheet, just make sure the "Sheet1" is the exact same as the sheet name.

__________________
-Evan


Benz Fleet:
1968 UNIMOG 404.114
1998 E300
2008 E63


Non-Benz Fleet:
1992 Aerostar
1993 MR2
2000 F250