Re: FrigginFraggin Spread Sheet!
David,
In MS Excel
put your formula in the first cell of the total column.
highlight this cell and as many cells below in the same column as
you wish.
Ctrl-D (or EDIT>FILL>DOWN) to supply the relative formula to each
row.
Good luck,
Rav
In MS Excel
put your formula in the first cell of the total column.
highlight this cell and as many cells below in the same column as
you wish.
Ctrl-D (or EDIT>FILL>DOWN) to supply the relative formula to each
row.
Good luck,
Rav
You don't have to enter the formula in every cell. You simple the
copy and paste that cell down the column and voila, it will
automatically increment the row in the formula for the rest of the
sheet. In MS Excel, the easiest way to copy is to grab the little
square in the lower right hand corner of the cell and drag it down.
You may eventually want to look up how absolute and relative
addressing works. Hint: that's what they are doing when you see the
'$' signs in formulas.
Hope this helps.
JB 678.819.4631
copy and paste that cell down the column and voila, it will
automatically increment the row in the formula for the rest of the
sheet. In MS Excel, the easiest way to copy is to grab the little
square in the lower right hand corner of the cell and drag it down.
You may eventually want to look up how absolute and relative
addressing works. Hint: that's what they are doing when you see the
'$' signs in formulas.
Hope this helps.
JB 678.819.4631
> FBBB,
>
> Now that I've got an actual drawing to look at, I'm redoing my
> estimate. For the sake of being able to easily add things up I'm
> trying to use a spread sheet, something I've never done before, not
> even on film projects with budgets 4 or 5 times higher than what I
> think the i60 will cost.
>
> Five columns: A: Part of the boat (topsides), B: Material (1/2 MDO),
> C - Quantity (16), D: Cost per ($40), E: Total ($640)
>
> But in this case I seem to be too dense to make the last one, the
> total, appear automatically.
>
> I can get it to work if I go into each row individually and assign
> cell E = Cx*Dx (x = row number) but that sort of defeats the purpose.
FBBB,
Now that I've got an actual drawing to look at, I'm redoing my
estimate. For the sake of being able to easily add things up I'm
trying to use a spread sheet, something I've never done before, not
even on film projects with budgets 4 or 5 times higher than what I
think the i60 will cost.
Five columns: A: Part of the boat (topsides), B: Material (1/2 MDO),
C - Quantity (16), D: Cost per ($40), E: Total ($640)
But in this case I seem to be too dense to make the last one, the
total, appear automatically.
I can get it to work if I go into each row individually and assign
cell E = Cx*Dx (x = row number) but that sort of defeats the purpose.
Help?
YIBB,
David
--
C.E.P.
415 W.46th Street
New York, New York 10036
http://www.crumblingempire.com
Mobile (646) 325-8325
Office (212) 247-0296
Now that I've got an actual drawing to look at, I'm redoing my
estimate. For the sake of being able to easily add things up I'm
trying to use a spread sheet, something I've never done before, not
even on film projects with budgets 4 or 5 times higher than what I
think the i60 will cost.
Five columns: A: Part of the boat (topsides), B: Material (1/2 MDO),
C - Quantity (16), D: Cost per ($40), E: Total ($640)
But in this case I seem to be too dense to make the last one, the
total, appear automatically.
I can get it to work if I go into each row individually and assign
cell E = Cx*Dx (x = row number) but that sort of defeats the purpose.
Help?
YIBB,
David
--
C.E.P.
415 W.46th Street
New York, New York 10036
http://www.crumblingempire.com
Mobile (646) 325-8325
Office (212) 247-0296