![phoenix](https://d1a29h5kxv3oc2.cloudfront.net/dist/img/phoenix.81914efc7207f6a059bd10f5d3fd5f89.png)
Microsoft Excel Special Formatting for Poker Analysis Spreadsheet Output
- or -
Post a project like this4061
$20/hr
- Posted:
- Proposals: 2
- Remote
- #254124
- Awarded
Description
Experience Level: Intermediate
*EDIT: I realize now that this may not have been specific enough. I need to have some sort of formula or macro, one that would not be limited to specific columns/rows/cells, essentially having a "brain" that could potentially fill in missing information). This is not a one-time deal, so anyone who may have been hoping to just fill data manually into the grid need not apply- I can easily do this on my own.
--------------------------------------------------------------
I have provided a screenshot with added information that shows a sampling of Excel output from the popular poker tracking and analysis software Holdem Manager.
In the picture, the actual output is listed vertically in Column A. To the right of it, I have manually created two types of Holdem card grids. The top grid has every possible two card combination, while the bottom grid is a simplified version, containing just a row labeled A-2 and the same listing in a column, for cross referencing the cards.
WHAT I NEED
For a specified situation (not part of the project), Holdem Manager can generate a report the cards played, with an option to export this information in CSV format. The unchanged information lists the cards in order of profitability (these amounts have been removed from the graphic, as they are irrelevant), and thus, are not necessarily listed in order of strength or sample size.
I am interested in the card values and sample size, and therefore want the information to be read in such a way that it can auto-populate the grids on the right, according to sample size. Preferably, provided that this even within the limitations of the software, I would like to have the hand samples populate in the top grid in the same cells in which the specific hands are listed. Please reference the provided graphic to understand this better.
If the first request is possible, the second request is related and will be easy. Again, reference the graphic.
Lastly, I would like a list of the hole cards (sample not included) to be generated into a single cell that will provide an input string for easy copy and paste into a poker simulator. The order of the string does not matter, it need only convert the information in the first column into this specific format, i.e. AA,77,22,85s,KQo,88.
For applicants, I do not require that all three of these requests be met, but depending on the proposed skill level of applicants, anyone who is able to fulfill all 3 requirements in a way that is simple and one that I can replicate in the future will get the job. This person is also virtually guaranteed to get future work from me for similar tasks.
--------------------------------------------------------------
I have provided a screenshot with added information that shows a sampling of Excel output from the popular poker tracking and analysis software Holdem Manager.
In the picture, the actual output is listed vertically in Column A. To the right of it, I have manually created two types of Holdem card grids. The top grid has every possible two card combination, while the bottom grid is a simplified version, containing just a row labeled A-2 and the same listing in a column, for cross referencing the cards.
WHAT I NEED
For a specified situation (not part of the project), Holdem Manager can generate a report the cards played, with an option to export this information in CSV format. The unchanged information lists the cards in order of profitability (these amounts have been removed from the graphic, as they are irrelevant), and thus, are not necessarily listed in order of strength or sample size.
I am interested in the card values and sample size, and therefore want the information to be read in such a way that it can auto-populate the grids on the right, according to sample size. Preferably, provided that this even within the limitations of the software, I would like to have the hand samples populate in the top grid in the same cells in which the specific hands are listed. Please reference the provided graphic to understand this better.
If the first request is possible, the second request is related and will be easy. Again, reference the graphic.
Lastly, I would like a list of the hole cards (sample not included) to be generated into a single cell that will provide an input string for easy copy and paste into a poker simulator. The order of the string does not matter, it need only convert the information in the first column into this specific format, i.e. AA,77,22,85s,KQo,88.
For applicants, I do not require that all three of these requests be met, but depending on the proposed skill level of applicants, anyone who is able to fulfill all 3 requirements in a way that is simple and one that I can replicate in the future will get the job. This person is also virtually guaranteed to get future work from me for similar tasks.
![Lorin Y.](https://dw3i9sxi97owk.cloudfront.net/uploads/thumbs/d728e9256f988ffce2ef2705341b9b6d_150x150.jpg)
Lorin Y.
87% (6)Projects Completed
7
Freelancers worked with
3
Projects awarded
55%
Last project
14 Jun 2013
United States
New Proposal
Login to your account and send a proposal now to get this project.
Log inClarification Board Ask a Question
-
There are no clarification messages.
We collect cookies to enable the proper functioning and security of our website, and to enhance your experience. By clicking on 'Accept All Cookies', you consent to the use of these cookies. You can change your 'Cookies Settings' at any time. For more information, please read ourCookie Policy
Cookie Settings
Accept All Cookies