Banco/KENO

[blitzed]

Hello, someone emailed me asking if I had a spreadsheet they could use for Banco.

I slapped together a basic one, if anyone is interested.
http://crazynuts.hollosite.com/lottery_spreadsheets/BANCds

cya,
blitzed

 

[biuta]

Hello, someone emailed me asking if I had a spreadsheet they could use for Banco.

I slapped together a basic one, if anyone is interested.
http://crazynuts.hollosite.com/lottery_spreadsheets/BANCds

cya,
blitzed

Blitzed,

Thank you for sharing. Do you have some instructions on how to use / interpret it?

biuta

 

[blitzed]

Blitzed,

Thank you for sharing. Do you have some instructions on how to use / interpret it?

biuta

hiya biuta, most welcome.

spreadsheet was created in the free Libre Office Calc:
http://www.libreoffice.org/

first sheet 14_Draw_Distro, shows the number distribution, a tally of how many times each numbered ball 1-70 (in Column A), appear across ball slots B1-B20 (row 1).

Columns X-AX are tally stats, how many times have numbers been drawn 2x twice for example. AU column displays current percentage in the game for each tally value, and AV shows the percent probability to gauge how balanced the game currently is.

on BANCO sheet, instead of displaying 1-70 vertically like in the 14_Draw_Distro, I crammed it into wide screen, so a quick glance shows how many times each number hit. Conditional formatting underscores values below median which are more likely to hit again.

TEMP is the sheet to insert new results, then as indicated copy & paste the set of results over the Banco_Draws sheet. I am no spreadsheet expert, that is the only way I know how to do it without messing up the spreadsheet formulas heh!

the spreadsheet could be expanded out further than 14draws, but most Keno players I know do not use more history than that.

goodluck!
blitzed