Ok, so here's what I want to do (Excel/OOCalc question)

Factual Questions
1

I have a spreadsheet in OO Calc. It’s already full of numbers, I have to take each of these numbers and multiply it by something and add something to them (or maybe in the other order). So what I need to do is either find a way to do that to each cell in a highlighted area (easily) OR, what I would really like to do is to put some varibles in each cell. So if a cell says 4.17, I’d like it to say 4.17 X (A1) + (A2), where A1 and A2 would be numbers that I can change from time to time.

Now, there’s about 480 cells on this sheet and several sheets that I would like to do this to, so it is possible to do this by hand, but is there a way I can do it in one fell swoop?

Here’s what I’m doing if it helps.
I need to know what to charge our customers when they send things out. I downloaded the rate guide from UPS, but in order to figure out what we will actually get charged (and in turn what to charge our customers), I need to take the number from the guide (which is in excel form), add UPS’s residentail surcharge (all the numbers in their rate guide are based on deliveries to businesses, they charge another 2.10 to go to a house), and then multiply in their fuel surcharge which changes monthly.

Any thoughts?

2

Let’s say columns A, B, and C all contain numbers and column D is blank. In cell D1, you could enter a formula such as:

…and the cell should display the corresponding value. Then you could use the autofill feature to apply this operation to the numbers in each row by selecting cell D1, clicking once and holding on the little black square on the lower right corner of the selection box, and dragging the selection to include all the cells in column D. This should autofill all the formulas, such that D2=(A2 * B2) + C2, D3=(A3 + B3) + C3, etc. Make sense?

3

D’oh, I didn’t even think about just doing what amount to shifting the whole table over like that. Then, I can just delete gthe original part and slide the new stuff back over. It’s not as elegent as I was hoping for, but I think it’ll do.

4

Assuming that the rates start in Cell A2 and go vertically down the A column…

In Cell A1 put 2.10
In Cell B1 put the fuel surcharge
In Cell B2 (next to the first shipping rate, type =(B2+$A$1)*$B$1

Then Copy Cell B2 and Paste next to every other cell that a shipping rate in it.

5

Sorry for the bump, but I just wanted to say that I’ve been trying for two days now to download the rate sheet you’re talking about and it keeps hanging at 92% complete. UPS’s site sucks…

6

Odd, I’ve downloaded it several times. Never had a problem.