NFL Footballpool help

I am making a football Pool for NFL games and need help on the followin
items:

1.  Need cell f5 on worksheet 2 to automatically show same data as cel
f5 on worksheet 1.

2.  I run a confidence point league, so players pick game winners, the
rank those winners by their confidence. (1-16 for 16 game weekend;1-1
for 14 game weekend)

now...I currently manually place a 0 or a 1 next to each players' pick
and get a total value for points diplayed in my 'total' Cell.

how...Can i make a table of the games played that week, manually inpu
the scores of each team, and have this make the 0 or 1 appear next t
players picks?

Thanks for the help.

There are probably alot of people interested in creating their own NFL
confidence type database so lets use this thread as a help section fo
such

--
Message posted from http://www.ExcelForum.com

0
12/22/2003 9:12:32 PM
excel.misc 78881 articles. 5 followers. Follow

3 Replies
268 Views

Similar Articles

[PageSpeed] 8

I just figured out the answer to my first Question...I had been puttin
the sheet statement in wrong place

--
Message posted from http://www.ExcelForum.com

0
12/22/2003 9:28:58 PM
Hi Bent,

We would need to know the layout that you have. I have a 
small group that I manage and I go about it entirely 
differently. If it's possible, you can send me a copy of 
the file and I'll take a look at it. I'm sure that I can 
come up with something. You'll need to change my address 
to biff_in_pitt

Biff
 
>-----Original Message-----
>I just figured out the answer to my first Question...I 
had been putting
>the sheet statement in wrong place.
>
>
>---
>Message posted from http://www.ExcelForum.com/
>
>.
>
0
biffinpitt (3172)
12/23/2003 2:20:10 AM
Here's a picture (jpg) of my layout. 

http://server5.uploadit.org/files2/231203-W16P.jpg

Would you be interested in something like this ?

Biff

>-----Original Message-----
>I just figured out the answer to my first Question...I 
had been putting
>the sheet statement in wrong place.
>
>
>---
>Message posted from http://www.ExcelForum.com/
>
>.
>
0
biffinpitt (3172)
12/23/2003 4:44:03 AM
Reply:

Similar Artilces:

flag for follow up Help
Using Microsoft Outlook 2000 SP-3. My Flag for Follow Up quit working, in my in box, but I can flag in other folders. Anyone else ever have this problem? Please advise. Thank you, Chris Jametski ...

New Outlook user needing help
After trying to sync my mobile phone & Pocket PC with Outlook 2000 on my computer the '+' prefix (i.e. + 44 1234 567890) which I have for all my telephone numbers do not show up in Outlook contacts. Even when I enter the '+' manually at the beginning of the number when I press save it disappears. What is most annoying of all is when I sync my phone with outlook again it even replaces all the numbers in my phone without the '+'. Can someone shed some light as to what settings I need to go into to resolve this problem...Many thanks ...

Need offset function help, I think
I have 10 products rows with a cost in column BW of rows 21 thru 30, i.e., cells BW21 down to BW30. Those 10 products have the # of units sold each month, for 22 months, shown in rows 41 thru 50, in columns E thru Z, so column E is month #1 ... col Z is month #22. The total range is cells E40 thru Z40. There is a cost factor vector that has six factors in row 70, cells G70 thru L70. These are to be used =91for all time periods=92 and for all products. Any time there is a sale of a product in a certain month, I want to enter six months of cost associated with producing the item...

How zoom/increase font size of Office 2004 "Help" text?
Font sizes can be set for Word, Excel and Entourage. You also can zoom in to enlarge the View of text in Office 2004 components� documents. How does one do this with the small-font text in Help? Respectfully, Norm On 9/14/04 1:36 AM, in article BD6BFBA9.49F3%nnager@vnoxsxpxaxmv.fullerton.edu, "Norman R. Nager, Ph.D." <nnager@vnoxsxpxaxmv.fullerton.edu> wrote: > Font sizes can be set for Word, Excel and Entourage. You also can zoom in > to enlarge the View of text in Office 2004 components� documents. > > How does one do this with the small-font text in Help...

Please Help #2
I am trying to share out a users calander to a group of managers. When I go to properties on the calander it adds them ok. When I go to add them in the properties under the users mailbox in Outlook 2002 on Windows NT it gives me the message "The modified permission could not be saved. The client operation failed." I have read article 323611 on a workaround, but this did not work. We are using Exchange 2000, and I know when I started my predisesor was backing up the M drive on the Exchange server, so when I look at the security settings on the users box on the M drive it...

Help with Excel Workbook
I am updating a workbook and very behind. It's a construction workbook, so there many separate categories that have to total costs For example, electric, plumbing, misc....etc...and then theres a totals page. What is the easiest way to input info? Can I input all info on one page. thanks Not sure if this has anything to do with Outlook. You might have better luck posting in an Excel newsgroup. "Nina" <Nina@discussions.microsoft.com> wrote in message news:0E171EE5-5679-4210-9D00-E7649A0FB909@microsoft.com... >I am updating a workbook and very behind. It's a...

Please help w/formula
I want to create a formula for an employee schedule to compute the totals hrs scheduled, multiply total hrs scheduled by rate of pay to get a gross rate of pay. I can only get it to add up to 24 hrs then it starts over at 1. Example I am using: Start:17:00 End: 19:00 Total: =(end-start) =IF(A3<A2,A3+1-A2,A3-A2)*24*B2 Where A2 is start, A3 is finished, B2 is rate of pay Format cell to currency or accounting. -- Best Regards, Luke M *Remember to click "yes" if this post helped you!* "Dave" wrote: > I want to create a formula for an employee schedule to co...

New to excel Help
hello I am new to this forum and not good with excel. this is a brief explaination of what i need to do to kick things off. hop somebosy can help have a calculation for temperature that i have 25 deg figures for. need to be able to create a excel calculation for any given value (i deg). I have a table of values run from a line of best fit basis. so far my equation is eg D1=(A1*B1)*C1 F1=D1/ratio in table pre determinded by the temp in E1 Can anybody help Scott sdminus@yahoo.co.u -- swa ----------------------------------------------------------------------- sway's Profile: http...

Frank Kabel...need your help
I've got MSQuery setup to retrieve data from an external database. I have a macro that automatically refreshes the data when the file is open. It's very cool because I've got it setup to prompt for the parameters (e.g., beginning date, ending date) I'd like to complete the automation of this spreadsheet by telling Excel to refresh all the pivot tables in this workbook, AFTER the data is DONE being downloaded. Hi Jonathan first: you may use a different header for this kind of postings: Just stae your problem and don't address a question directly to one of the regulars....

Please help! MS Exchange Server is sending personal info!
I have all my personal banking, credit card numbers, passwords, drivers license #, ect, on in my contacts. And some sensitive info in notes. My company just changed to an inhouse server and is using ms exchange and it copied my contacts folder to the server, which can certainly be viewed by anybody in the office. And I run the risk of all this going everywhere. I went on the internet site and deleted everything I could, but now I can never go into outlook while being connected to the internet. Please help! What is the best solution? Thanks, Wendy Mark your contact properties in the permissi...

pivot table help #2
I am extremely new to pivot tables and trying to just get ave, max, and min of a couple of columns ... I keep getting #DIV/0! errors and don't know what the problem is. any ideas anyone??? -- evg1 ------------------------------------------------------------------------ evg1's Profile: http://www.excelforum.com/member.php?action=getinfo&userid=35043 View this thread: http://www.excelforum.com/showthread.php?threadid=547887 Do you have errors in any of those fields in the raw data? Do you have any numbers in the field that you're averaging? evg1 wrote: > > I am ...

network key pw help
I have forgotten my network key pw for my wireless router my lap top has the pw saved so i can get onwith that pc but i need the pw so i connect with another lap to is there any way to retrive this pw??? I am useing the window connection for connection Thanks Mike Mike <Mike@discussions.microsoft.com> wrote: >I have forgotten my network key pw for my wireless router >my lap top has the pw saved so i can get onwith that pc but i need the pw so >i connect with another lap to is there any way to retrive this pw??? I am >useing the window connection for connection You wi...

help-planning
We carry circa 25 products. Each product needs to be processed in 2-3 stages. circa 20 minutes/ stage. Raw materials come in several times a month. However for some products the raw materials are readily available while for others 1-2 months are necessary. Each product is packaged differently. Each consignment consists of a product mix. (between 1 and 25) There are circa 5 large customers (2000 products/month) , 5 medium ones (200/ month) and 10 small ones (20/month). (but none of these order every single month). At the moment most customers need to wait circa 2 months but the planning must be...

What is wrong with this IF statement? need help.
This statement works fine but I want the cell to say 0" if the cell H6 has a zero in it. As the stetments stands right now it displayes 6" in the cell if H6 is 0. How can I make that happen? =IF(H6<101,"6""",IF(AND(H6>101.1,H6<151),"7""",IF(AND(H6>151.1,H6<201),"8""",IF(AND(H6>200.1,H6<275.1),"9""",IF(AND(H6>275.2,H6<350.1),"10""",IF(AND(H6>350.2,H6<601),"12""",IF(AND(H6>601.1,H6<901),"14"""))))))) Pleas...

help me please
Hello! I have a nice problem for you - so please help me! I have a property sheet with three pages in it. I make a pointer to the doc class. I receive a value from the doc class. When I�'m going to use that value - the value has changed, so I receive an exception. How can I get the right value from the doc class? Is a doc class' value a word or a dword? -- - Lars The doc class reference is a pointer. It is not a word, and it is not a dword, it is an address. This means it could be 64 bits on a 64-bit machine. Never assume that a pointer is 32 bits. The pointer to a CDocume...

Loven test for there help
...

Need some help from you smart people...
I have a spreadsheet that has multiple columns (13) that are variou milestones. These columns contain dates that range over a period o time given in day, month and year (11/18/2003). My question is, how ca I filter, sort, etc...by a given date range i.e. for a 3 month period? I hope that this is clear enough to get some feedback. Thank you. Healu ----------------------------------------------- ~~ Message posted from http://www.ExcelTip.com ~~View and post usenet messages directly from http://www.ExcelForum.com If I understand your intent, you need to use Data > Filter >AutoFilter....

Trying to understand rules, please help
I have an Exchange 2003 and I needed to create aliases that would forward to several external email address (like jdoe@localdomain.com forwarding to jdoe@yahoo.com). What I did was to create a user named buttler@localdomain.com, assigned all the aliases to it (jdoe, janedoe, somebody and help) and create rules that will redirect based on "Sent to" to the external addresses. For better understanding of my problem I post two examples below: Apply this rule after the message arrives sent to jdoe@localdomain.com redirect to jdoe@yahoo.com and delete it and stop processing more rules A...

Help! Need to add/delete email users
We are a nonprofit in a sticky situation - our old consultants are terrible and we are replacing them next week, but in the meantime I have a new assistant starting on Monday and need to get rid of the old assistant's email/login and set her up. I am the most skilled at computers in our office unfortunately, and am in the network room (luckily it is logged on) but have no idea where to find a place to change it or how to change it. I am guessing its not too difficult if I'm pointed in the right direction. We can't have the original consultants come in to do this so any...

Can not receive Email.. Need Help
Hi all, Earlier this morning, my exchange server 2007 (hosted on SBS 2008) just stopped receiving external e-mail. We can send interoffice e-mails and we can send out e-mails to other locations fine, but we are unable to receive any e-mail. All internet connections are normal as well, and the port 25 is open on the firewall. The error from when we try to send an e-mail to the server is this: “This is an automatically generated Delivery Status Notification. Delivery to the following recipients failed.” Earlier today I installed the anti-spam update from MS “Microsoft excha...

Help please? #3
sorry thanks its working! : -- H4F ----------------------------------------------------------------------- H4Fi's Profile: http://www.excelforum.com/member.php?action=getinfo&userid=1625 View this thread: http://www.excelforum.com/showthread.php?threadid=27657 ...

Self joining table and grouping help
Hi All, Could some help me with the SQL without using PARTITION and RANKING functions? Or would that be asking too much? pk_id, parent_id, trx_date, amt ====================================== 1, 0, 3/7/2008, 2500 3, 0, 5/2/2008, 5000 48, 0, 12/4/2009, 2000 109, 0, 12/9/2009, 5000 101, 48, 12/6/2009, 2000 118, 48, 12/13/2009, 4000 145, 48, 12/13/2009, 2000 229, 48, 12/20/2009, 2000 313, 48, 12/27/2009, 2000 397, 48, 1/3/2010, 2000 482, 48, 1/10/2010, 48400 122, 109, 12/13/2009, 1365 149, 109, 12/13/2009, 5000 233, 109, 12/20/2009, 5000 317, 109, 12/27/2009, 5000 401, 109...

Excel 2003, Auto Filter Help!
I have a 21,000 row XML file that I pull into Excel every morning: Data / Import Data / Select Data Source / OK ...and all is well ....until I updated to a new PC and had to reload Excel. Now I get autofilters at the top of each column, and it won't load all the data. I know I can go in AFTER I load and uncheck Data / filter / autofilter and it will remove the filter queues on the top row, but I DON'T know how to set up an option where it will not format with auto filters from the get-go. ...so I can load this data completely. What am I missing here?! Thanks! - Hu - ...

Getting Creative With Notes
While I realise that this is totally unsupported I was wondering if anyone had ever tried the following: I have added an iFrame to a Service Activity to which I am assigning the URL during the form's load event. If the SA has a Case (incident) specified in the "Regarding" field I use the GUID of this case to build up a URL that references that Case's Notes for example: /ORG_Name/_controls/notes/notesdata.aspx?id={Case_GUID} &ParentEntity=112&EnableInlineEdit=true&EnableInsert=true This works in so much that you can now see any Notes that have been created on th...

Can I remove Calendar Help-area... Please? #2
In Outlook 2007, I have an area in the navigation pane below 'My Calendars', which displays 4 or 5 hyperlinks. They say: "How to Share Calendars", "Search Calendars Online" "Send a Calendar via E-mail..." "Publish My Calendar..." "Add New Group" I don't want this hyperlink area, how can I switch it off or minimise it? I would love to use this space for other more useful things. We've been trying to remove it for ages and I'd be very grateful for any help. Thanks Michelle & Sara Sorry, those links can't b...