excel poker app
Budget: €8 – €30 EUR
I have many excel sheets divided in these categories https://i.imgur.com/WH4MnQj.png https://i.imgur.com/dHpXTX2.png The hands are starting hands in pot limit Omaha. I need someone who understands the difference in value. For example AsKsQdJc has different value than AdKsQsJc. I have 4 groups at the moment I would like to have an app/macro which breaks down the groups in more subcategories
1) First I want to isolated the pairs in every subcategory. For example Qs9s9d8d is considered a pair since it has 99 in it. Then I want to separate the pairs in each category depending where they are suited. For example in single suit category https://i.imgur.com/sjp50HE.png KTT2 is suited with three different combinations (suited to the 2nd+4th card, suited to the 1st+4th, suited to the 1st+2nd) , in the double suited the pairs have one as an example, rainbow and quadra don’t have any subcategories
2) After all pair are sorted in different columns I need the remaining hands. Example a triple suited hand like AsKsQsJd have the different combinations AsKsQsJd, AsKdQdJd, AsKdQsJs, AsKsQdJs, AsKsQsJd the subcategories can be named 1st3suited, 1st+3rd+4th suited etc. This need to be done for double suited hands (I think 2 categories), single suited (I think 6 categories you need check), rainbow and quadra. Please recheck everything to make sure I don’t forget something
3) The last step I have all the templates like this one https://i.imgur.com/IyZUNvb.png I want as an example if the hand is found in the column of 1st3suited from above, the cell to be yellow. If a hand is not found then it should remain white. Another example in single suited. I have a template for single suited 9 high starting hands. 9s8s7d6c is played so the background should be yellow in the template with the name 1st2SingleSuited, a hand like 9s8s3d2c is not in any of the columns and should remain white (because it is not played)
1) First I want to isolated the pairs in every subcategory. For example Qs9s9d8d is considered a pair since it has 99 in it. Then I want to separate the pairs in each category depending where they are suited. For example in single suit category https://i.imgur.com/sjp50HE.png KTT2 is suited with three different combinations (suited to the 2nd+4th card, suited to the 1st+4th, suited to the 1st+2nd) , in the double suited the pairs have one as an example, rainbow and quadra don’t have any subcategories
2) After all pair are sorted in different columns I need the remaining hands. Example a triple suited hand like AsKsQsJd have the different combinations AsKsQsJd, AsKdQdJd, AsKdQsJs, AsKsQdJs, AsKsQsJd the subcategories can be named 1st3suited, 1st+3rd+4th suited etc. This need to be done for double suited hands (I think 2 categories), single suited (I think 6 categories you need check), rainbow and quadra. Please recheck everything to make sure I don’t forget something
3) The last step I have all the templates like this one https://i.imgur.com/IyZUNvb.png I want as an example if the hand is found in the column of 1st3suited from above, the cell to be yellow. If a hand is not found then it should remain white. Another example in single suited. I have a template for single suited 9 high starting hands. 9s8s7d6c is played so the background should be yellow in the template with the name 1st2SingleSuited, a hand like 9s8s3d2c is not in any of the columns and should remain white (because it is not played)