Thread Rating:
  • 0 Vote(s) - 0 Average
  • 1
  • 2
  • 3
  • 4
  • 5
[Jungle Fighting] Fog of War
03-25-2013, 01:43 PM,
#3
RE: [Jungle Fighting] Fog of War
It was faster to determine the exact odds than to write this email.

Start an Excel spreadsheet with 1 in cells A1 to F1, =SUM(A1:F1) in cell G1 and =IF(G1>=15, 1, 0) in cell H1
In A2: =IF(AND(B1=6, C1=6, D1=6, E1=6, F1=6), IF(A1 < 6, A1+1, 1), A1)
In B2: =IF(AND(C1=6, D1=6, E1=6, F1=6), IF(B1 < 6, B1+1, 1), B1)
In C2: =IF(AND(D1=6, E1=6, F1=6), IF(C1 < 6, C1+1, 1), C1)
In D2: =IF(AND(E1=6, F1=6), IF(D1 < 6, D1+1, 1), D1)
In E2: =IF(F1=6, IF(E1 < 6, E1+1, 1), E1)
In F2: =IF(F1 < 6, F1+1, 1)
In G2: =SUM(A2:F2)
In H2: =IF(G2>=15, 1, 0)

Copy A2-H2 to A3-H45656 and then H46657 is = SUM(H1:H46656) is the number of combinations which total to 15 or more.

VoilĂ .
Reply


Messages In This Thread
[Jungle Fighting] Fog of War - by Hugmenot - 03-25-2013, 12:32 PM
RE: [Jungle Fighting] Fog of War - by Shad - 03-25-2013, 12:56 PM
RE: [Jungle Fighting] Fog of War - by Hugmenot - 03-25-2013, 01:43 PM
RE: [Jungle Fighting] Fog of War - by rerathbun - 03-25-2013, 04:46 PM
RE: [Jungle Fighting] Fog of War - by Shad - 03-25-2013, 05:00 PM
RE: [Jungle Fighting] Fog of War - by rerathbun - 03-26-2013, 04:00 AM
RE: [Jungle Fighting] Fog of War - by campsawyer - 03-25-2013, 08:44 PM
RE: [Jungle Fighting] Fog of War - by hawkeyeted - 03-26-2013, 12:35 AM

Forum Jump:


Users browsing this thread: 1 Guest(s)