Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
Creating a new formula(s) and/or macros
OK...I have a excel formula(s)/macro that I want to build and really have
gotten stuck on trying to finish it off. Here is why to what I would like this thing to pull off: I run this fanatsy sim hockey league with a friend...its a keeper league that has contracts and drafts and free agency. Well, its the free agency that consumes my time. This is what I'm trying to do... 1) we want to have a player randomly say what he is looking for (I have gottent that piece). 2) we would like the player to go to a team that makes an offer randomly (not quite there on this part, b/c of #3) 3) we would like to have percentages based on the teams' offer...meaning, if a team makes a better offer then what the player is looking for, that the team has better odds at picking him up. (I have how the odds increase or decrease, based on contract length and amount). Basically, What I have been doing in the past is taking the teams offers and putting the teams into a hat, the better the offer, the more times there name is in the hat. So, if anyone has any ideas, I would love to hear them. Thanks in advance Cheers |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Countif formulas change after doing a sort | Excel Worksheet Functions | |||
Cant find & delete invalid formulas or links | Excel Discussion (Misc queries) | |||
Creating formulas that allow the solutions to start with zeros. | Excel Discussion (Misc queries) | |||
Help, Urgent Excel Formulas are not calculating | Excel Discussion (Misc queries) | |||
Problem with named formula's | Excel Worksheet Functions |