Ladder % into excel
Moderator: 2020vision
3 posts
• Page 1 of 1
Ladder % into excel
by TheGoldenVision » Fri May 14, 2010 4:22 pm
Is it possible to get the ladder percentages (shown at the top of the BACK and LAY columns) into excel?? I assume that this is the % of monies available in each column.
- TheGoldenVision
- Posts: 34
- Joined: Sat Nov 19, 2005 10:48 pm
by GaryRussell » Sat May 15, 2010 6:26 am
1) Put =C5+E5+G5+I5+K5+M5 in cell Y5
2) Put =(C5+E5+G5)/Y5 in cell Z5 and format as percentage.
3) Put =(I5+K5+M5)/Y5 in cell AA5 and format as percentage.
Unfortunately they won't be exactly the same as the best three back and lay amounts are rounded up on the ladder and rounded down on the grid. I think I maybe need to address this inconsistency.
2) Put =(C5+E5+G5)/Y5 in cell Z5 and format as percentage.
3) Put =(I5+K5+M5)/Y5 in cell AA5 and format as percentage.
Unfortunately they won't be exactly the same as the best three back and lay amounts are rounded up on the ladder and rounded down on the grid. I think I maybe need to address this inconsistency.
-
GaryRussell - Site Admin
- Posts: 9872
- Joined: Fri Nov 18, 2005 8:09 pm
- Location: Birmingham, UK
- TheGoldenVision
- Posts: 34
- Joined: Sat Nov 19, 2005 10:48 pm
3 posts
• Page 1 of 1
Who is online
Users browsing this forum: No registered users and 55 guests