Excel Thread - Computer Technical Help - Software and Hardware Forum

Two Plus Two Forums Other Topics Computer and Technical Help

Excel Thread

Post Reply Subscribe

...

12-02-2011 , 02:52 AM

gimmetheloot

banned

Join Date: Jan 2006 Posts: 15,371

I hope this hasnt been done, and I am certainly not going to be able to offer any advice for a while, but I am starting to use excel more and dont know how to do many of the things I would like to do with it.

Id like to use this thread for everyone to post questions about how to use excel in and compile a good amount of data for newbs like me.

My first question is:
My goal per day is 257 and I want excel to give me the per day goal from November 17th through the current day as my goal pace.

http://img843.imageshack.us/img843/9533/excelss.png

If there is any other information anyone needs I would be happy to provide it.

Thanks

Quote

150% up to $2,000 Welcome Bonus on CoinPoker

Join the action now

Daily Rewards • Splash Pots • CoinRaces

12-02-2011 , 07:10 AM

myNameIsInga

adept

Join Date: Apr 2010 Posts: 746

Might want to try the programming forum as well, may be some folks there who knows this stuff, although they prob read this forum too.

Quote

12-03-2011 , 12:47 AM

_dave_

_Pooh_Bah_

Join Date: Feb 2005 Posts: 13,154

Moved from Software, will prob go better in this one I think. can always move back if need be

Quote

12-03-2011 , 01:41 AM

stanek

grinder

Join Date: Apr 2006 Posts: 452

Not sure I understand your question. It would help if you label your column headers.

Are you saying that you expect to earn 257 per day? If so create a dummy column that acts as a counter and simply multiply by 257.

Ex. on the 10th day your expected earnings are 2570 but your totals to date are -342. You need to earn 2912 to get back on pace.

Quote

12-05-2011 , 04:41 AM

gimmetheloot

banned

Join Date: Jan 2006 Posts: 15,371

Here is the top with the headers:
http://img811.imageshack.us/img811/7486/toplq.png

and the bottom w/ totals:
http://img847.imageshack.us/img847/9098/bottomv.png

How do I make a dummy column to act as a counter? Will it auto update from there?

Quote

12-05-2011 , 07:56 AM

pingu2k4

journeyman

Join Date: Jun 2009 Posts: 214

your trying to get the bottom row where it says TOTAL to total each column? Easy.

=sum(B1:B24) in B26. same in the others across.

Quote

12-05-2011 , 12:14 PM

gimmetheloot

banned

Join Date: Jan 2006 Posts: 15,371

neg, I have those in there, I just want the square to the right of 'Pace:' to auto update itself for the pace/day*number of days in instead of having to manually do the multiplication. Everything else is set up for what I need so far

Quote

12-05-2011 , 12:30 PM

Bacon

Makes everything better

Join Date: Dec 2007 Posts: 3,001

Set g2 equal to = 1
Set g3 equal to = g2 + 1
copy paste g3 down as far as you want. (g24 I guess)

Set F2 = g2 *257
copy paste F2 down to where you finished your g column

Quote

12-05-2011 , 01:06 PM

gimmetheloot

banned

Join Date: Jan 2006 Posts: 15,371

hmm i guess that will work well enough, thanks guys

im sure ill have some more stuff to figure out soon

Quote

12-05-2011 , 11:23 PM

#10

Neko

Pooh-Bah

Join Date: Jul 2005 Posts: 4,000

FWIW there is a long and fairly active excel thread already in OOT: http://forumserver.twoplustwo.com/34...-excel-874910/

Quote

12-29-2011 , 11:04 AM

#11

stanek

grinder

Join Date: Apr 2006 Posts: 452

Say I want to put a formula in D5 that uses A5 + B5 + C5.

Is there a way to write it so that it doesnt use the numbers? ie Sum( thisRow(A) + thisRow(B) + thisRow(C) ) ?

Quote

12-29-2011 , 03:19 PM

#12

malloc

grinder

Join Date: Aug 2008 Posts: 628

Quote:

Originally Posted by stanek

Say I want to put a formula in D5 that uses A5 + B5 + C5.

Is there a way to write it so that it doesnt use the numbers? ie Sum( thisRow(A) + thisRow(B) + thisRow(C) ) ?

=Row() will return the row number of the current cell although I have no idea why you'd want to build your formula that way.

Quote

12-29-2011 , 05:38 PM

#13

stanek

grinder

Join Date: Apr 2006 Posts: 452

I was hoping to be able to throw a general formula say in cell A1 and be able to call it like a function from other sheets / rows. But apparently you can only do that with VBA and I only have starter edition to work with.

INDIRECT("B"&ROW()) worked to call the B column of the same row.

For what I was trying to do a VLOOKUP worked better anyhow.

Quote

04-11-2012 , 06:07 AM

#14

gimmetheloot

banned

Join Date: Jan 2006 Posts: 15,371

Is there a way to create a drop down tab? Having A60 be the start and A75 or whatever be the end?

http://img16.imageshack.us/img16/4280/dropboxji.png

So I could click A1(1st Hennerz and A2&A3 would get hidden under A1 and then I could later unhide them the same way?

Thanks

Quote

150% up to $2,000 Welcome Bonus on CoinPoker

Join the action now

Daily Rewards • Splash Pots • CoinRaces

Post Reply Subscribe

...