DCSportbikes.net  
» Help Support .NET!
DCSportbikes Premier Membership for 25$ per year. Discounts! Click here for full information.

Now available in the .NET Shop:



Get your DCSBN Gear!
» Shoutbox
Sorry, only registered users have the ability to use our real-time shoutbox to chat with other members.

Register now, it's free!
» Online Users: 539
1 members and 538 guests
GRN96WS6
Most users ever online was 4,519, September 2, 2015 at 03:26 AM.
Go Back   DCSportbikes.net > Non-Sportbike Forums > Non-Sportbike Chat

Reply
LinkBack Thread Tools
Microsoft Excel Solver Help
Unread
  (#1)
AMA Superbike Champ
 
Macon663's Avatar
 
Posts: 756
Join Date: January 10, 2007
Location: Rockville, MD
Microsoft Excel Solver Help - November 8, 2012, 12:28 PM

I need some help w/ a spreadsheet I'm trying to create. Trying to use solver to answer some questions I need it to but can't get it to work right.

Anyone out there an excel wizard?

I don't think I'm using a linear equation which may be part of the issue. But I can't tell.
  Send a message via AIM to  
Reply With Quote
Unread
  (#2)
Im Always Down to Ride
 
bds120's Avatar
 
Posts: 2,865
Join Date: January 4, 2009
Location: Centreville
November 8, 2012, 12:31 PM

Man I been doing a lot of solver...whats up?


Remember when sex was safe and motorcycles were dangerous?

Speed kills, ride a Yamaha!

MotorSport/PowerSport Auctions
  Send a message via AIM to  
Reply With Quote
Unread
  (#3)
AMA Superbike Champ
 
Macon663's Avatar
 
Posts: 756
Join Date: January 10, 2007
Location: Rockville, MD
November 8, 2012, 12:44 PM

So, I'm using solver for fantasy basketball. I have a budget of 100 dollars.

I'm trying to get solver to tell me which player for each position is going to get me the most points for the budget I have.

So I have a pg, sg, sf, pf, and center positions. Players have different values, obviously good players cost more. But I can project how many points each player will get me on any given day. But I want to get solver to tell me, based on my projections of how many points I think each player will get me, what the best combination of players (pg, sg, sf, pf, c) is given the constraint of my budget.

Make sense? Is that possible?
  Send a message via AIM to  
Reply With Quote
Unread
  (#4)
Im Always Down to Ride
 
bds120's Avatar
 
Posts: 2,865
Join Date: January 4, 2009
Location: Centreville
November 8, 2012, 01:00 PM

So It makes sense.

But you have to have the defined differences in costs of the different players. That is the only way it will choose the best combination. Else given that you have a 100, it is going to split them evenly and give each 20. So you have to state that. As well, this would not be linear because I don't see how this could fit the y=mb + b for linear slope.


Remember when sex was safe and motorcycles were dangerous?

Speed kills, ride a Yamaha!

MotorSport/PowerSport Auctions
  Send a message via AIM to  
Reply With Quote
Unread
  (#5)
AMA Superbike Champ
 
Macon663's Avatar
 
Posts: 756
Join Date: January 10, 2007
Location: Rockville, MD
November 8, 2012, 01:08 PM

Right, so I have an excel file full of all the different pg, sg, sf etc in the league. Each one has a different cost and each one has a different projected points value.

Its definitely not linear.

I want solver to recognize that player A costs 10 dollars, plays the PG position and will get me a projected 10 points. Player B could be 15 dollars, play the SF position and will get me a projected 8 points.

But theres 150 players or so total to choose from.
  Send a message via AIM to  
Reply With Quote
Unread
  (#6)
I hate Hybrid drivers
 
david636's Avatar
 
Posts: 4,780
Join Date: May 25, 2006
Location: Woodbridge, VA
November 8, 2012, 01:14 PM

  Send a message via AIM to  
Reply With Quote
Unread
  (#7)
SUPERBITCHIN'
 
{SALVA}'s Avatar
 
Posts: 6,638
Join Date: September 2, 2008
Location: Ombelico del Mondo
November 8, 2012, 01:17 PM

you need excel to do that shit? pen and paper man...maybe an abacus. easy.


E che cazzo!
  Send a message via AIM to Send a message via AIM to {SALVA}  
Reply With Quote
Unread
  (#8)
Im Always Down to Ride
 
bds120's Avatar
 
Posts: 2,865
Join Date: January 4, 2009
Location: Centreville
November 8, 2012, 02:27 PM

Quote:
Originally Posted by Macon663 View Post
Right, so I have an excel file full of all the different pg, sg, sf etc in the league. Each one has a different cost and each one has a different projected points value.

Its definitely not linear.

I want solver to recognize that player A costs 10 dollars, plays the PG position and will get me a projected 10 points. Player B could be 15 dollars, play the SF position and will get me a projected 8 points.

But theres 150 players or so total to choose from.
Ok so you would definitely set your changing cells to be the different postions and then you need to set the different totals to ensure that they are <= 100.

From there it will give you the outcome. I will throw up a sample in a bit when I get some free time.


Remember when sex was safe and motorcycles were dangerous?

Speed kills, ride a Yamaha!

MotorSport/PowerSport Auctions
  Send a message via AIM to  
Reply With Quote
Unread
  (#9)
GP Champ
 
nootherids's Avatar
 
Posts: 2,662
Join Date: January 12, 2011
Location: Woodbridge, VA
November 8, 2012, 02:55 PM

I did a spreadsheet like this once. It said...

If I sleep with ___ women then that will yield a ___% probability of contracting ___ STD's.

Turned out that the more women the more STD's but the lower the probability. Hmmm, maybe I wrote the formula wrong. Be back later, I need to apply some ointment again.
  Send a message via AIM to  
Reply With Quote
Unread
  (#10)
Officially Addicted to Posting
 
Chris's Avatar
 
Posts: 5,660
Join Date: August 30, 2006
Location: Reston
November 8, 2012, 09:06 PM

so you want to calculate out the points of the players and based upon that pool of players, select the highest in each position that will still keep you below $100?


"I didn't bring artillery. But I'm pleading with you, with tears in my eyes: If you fuck with me, I'll kill you all." -MG James Mattis, Iraq 2003

Ruining .net one post at a time
  Send a message via AIM to  
Reply With Quote
Unread
  (#11)
Im Always Down to Ride
 
bds120's Avatar
 
Posts: 2,865
Join Date: January 4, 2009
Location: Centreville
November 9, 2012, 05:08 AM

No he is trying to calculate how many of each player he can buy with the allotted 100 he has given that each player can give him points.

So basically he wants to get the most of each position that will give him the most points without exceeding his 100 constraint.


Remember when sex was safe and motorcycles were dangerous?

Speed kills, ride a Yamaha!

MotorSport/PowerSport Auctions
  Send a message via AIM to  
Reply With Quote
Unread
  (#12)
Officially Addicted to Posting
 
Chris's Avatar
 
Posts: 5,660
Join Date: August 30, 2006
Location: Reston
November 9, 2012, 05:14 AM

This would probably go easier if i had ever played fantasy football


Do you have a draft excel doc of the players or anything youve already made?


"I didn't bring artillery. But I'm pleading with you, with tears in my eyes: If you fuck with me, I'll kill you all." -MG James Mattis, Iraq 2003

Ruining .net one post at a time
  Send a message via AIM to  
Reply With Quote
Unread
  (#13)
Im Always Down to Ride
 
bds120's Avatar
 
Posts: 2,865
Join Date: January 4, 2009
Location: Centreville
November 9, 2012, 05:42 AM

He was sending it to my personal email..

He might as well post it up.


Remember when sex was safe and motorcycles were dangerous?

Speed kills, ride a Yamaha!

MotorSport/PowerSport Auctions
  Send a message via AIM to  
Reply With Quote
Unread
  (#14)
AMA Superbike Champ
 
Macon663's Avatar
 
Posts: 756
Join Date: January 10, 2007
Location: Rockville, MD
November 9, 2012, 07:33 AM

I got it figured out. It literally takes my computer 5 minutes to solve the problem.

BDS hit the nail on the head w/ the intent.

Last edited by Macon663; November 9, 2012 at 07:39 AM..
  Send a message via AIM to  
Reply With Quote
Unread
  (#15)
Im Always Down to Ride
 
bds120's Avatar
 
Posts: 2,865
Join Date: January 4, 2009
Location: Centreville
November 9, 2012, 07:44 AM

Sweet. Its usually the backend formula behind the output cell and the formula/data in connection to the changing cells. Anyways...glad you got it. All I am/have been doing lately is using Solver, SolverTable, and the @Risk software to do linear programming models. Had to use stupid program called LINDO also to generate the actual written form then it would output all the data and sensitivity analysis.

Glad it worked for ya


Remember when sex was safe and motorcycles were dangerous?

Speed kills, ride a Yamaha!

MotorSport/PowerSport Auctions
  Send a message via AIM to  
Reply With Quote
Reply


Thread Tools

Posting Rules
You may not post new threads
You may not post replies
You may not post attachments
You may not edit your posts

BB code is On
Smilies are On
[IMG] code is On
HTML code is Off
Trackbacks are On
Pingbacks are On
Refbacks are On


Powered by vBadvanced CMPS v3.2.3


Powered by vBulletin® Version 3.8.7
Copyright ©2000 - 2019, vBulletin Solutions, Inc.
Search Engine Friendly URLs by vBSEO 3.6.0
vBulletin Skin developed by: vBStyles.com
All logos and trademarks in this site are property of their respective owner. The comments are property of their posters, all the rest 2002-2010 by DCSportbikes.net. DCSportbikes.net is owned by End of Time Studios, LLC.