LinkBack Thread Tools Search this Thread Display Modes
Prev Previous Post   Next Post Next
  #9   Report Post  
Junior Member
 
Posts: 5
Default

Joe is understandably busy and hopefully doing well. For anyone else still looking, there's been a notable change to the way the to numbers being compared are calculated. Ten more rows have been added, and so the two numbers now being compared are J37 and W37. Further, they are now calculated by summing the same columns, but then multiplied a static percentage, then further multiplied further by a random percentage, set by the sheet's user columns S and T at the top. Then a static number is added. The version of the sheet I have uploaded can increase or decrease the value of J37 and W37 by as much as 20%. Directly to the right of those settings, it shows the current result of the random generation in the current calculation.

Latest sheet he https://rapidshare.com/files/3231189247/Combat.xlsm
 
Thread Tools Search this Thread
Search this Thread:

Advanced Search
Display Modes

Posting Rules

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


Similar Threads
Thread Thread Starter Forum Replies Last Post
Calculating probabilities Raul Sousa Excel Worksheet Functions 9 October 19th 09 06:44 PM
Calculating Probabilities Daisy Excel Worksheet Functions 3 March 3rd 08 08:01 PM
Question about use of Poisson probabilities Dora Smith Excel Worksheet Functions 1 February 4th 07 07:09 PM
Probabilities phil2006[_30_] Excel Programming 2 July 22nd 06 05:05 PM
Macro and probabilities MrKermit Excel Programming 2 March 31st 06 10:01 AM


All times are GMT +1. The time now is 02:38 PM.

Powered by vBulletin® Copyright ©2000 - 2025, Jelsoft Enterprises Ltd.
Copyright ©2004-2025 ExcelBanter.
The comments are property of their posters.
 

About Us

"It's about Microsoft Excel"