Skip to content

Latest commit

 

History

History
127 lines (114 loc) · 7.42 KB

release_notes.md

File metadata and controls

127 lines (114 loc) · 7.42 KB
Raw

Bugs:

  1. Missing error message when invalid ACBL player number entered into debug selectbox.
  2. Find where score_NS_1 and score_EW_1 have creeped into df.
  3. Don't let prompt create new columns. Check that dataframe results are all in results columns.
  4. regex in commands.sql not working. SD_Prob_Take_[0-9]+ not excluded.
  5. What to do with (tournament) sections not containing user's acbl_number? concat all sections by rows? concat may be correct if other sections' results are included in matchpoint calculations.
  6. Default API should be selected from json file, if exists.
  7. Change of player number is causing error.
  8. Neil's Instant Game errored out without sidebar. Find similar.
  9. Add game percentage to about.
  10. Kerry Feb tournament produced scores_l error.
  11. Missing error message when .streamlit, .streamlit/secrets.toml are missing or toml doesn't contain two secrets.
  12. show timestamps of data files.

Prompt Notes

  1. Does chat understand overtricks, justmade, undertricks? Or should result be used?
  2. Document SD_[Score,ParScore,Matchpoints,Pct][Max][Diff].
  3. Any interesting stats to grab from https://stats.lovebridge.com/statistics/lb_02_107602 ?

To Be Implemented

  1. Is there some way that logo url can be using file:///assets/...?
  2. Show list of acbl numbers, debug mode only, in landing page?
  3. Create .json or .toml file for settings. Use settings to turn off any debug output.
  4. Implement Checkbox for Debug Output in Advanced Settings. Use setting to turn off any debug output.
  5. Setting to disable single dummy calculations (avoid delay)?
  6. Don't perform string replacements on quoted prompts. Use as SQL.
  7. ACBL Individuals
  8. ACBL Teams
  9. Other online bridge services.
  10. Further reduce autosizing of columns. Dataframes doesn't look minimized although reportlab does.
  11. Show max SD contract NS, EW. If contract went down, is it a better expected value than letting opponents have bid?
  12. Implement downloading of chat session or perhaps output as markdown.
  13. Show rankings of declarers by parscore, sd, sd max, dd, dd max, actual.
  14. Show rankings of declarers by number of doubles, pct of hands doubled, pct making, pct beating par score (successful sacrifice).
  15. Show rankings of declarers by bidding of penalty double, success rate.
  16. Show rankings of declarers by bidding of sacrifice, success rate.
  17. Check if ACBL online games are in my DB.
  18. Howell movements.
  19. Write dataframe/SQL to in-memory SQL database? Perform queries on in-memory database instead of dataframe?
  20. What is the interaction between doubling and not doubling?
  21. Show rankings of declarers by successful contracts, unsuccessful contracts, successful doubles, unsuccessful doubles, successful sacrifices, unsuccessful sacrifices.
  22. Show BBO bidding, both ACBL human and BBO robot.
  23. Separate Release Notes from Project Notes?
  24. Speed up single dummy. write to file or sql database?.
  25. Highlight columns used in ORDER BY? Requires parsing of SQL statement.
  26. Experiment with charts. Use ChartAI?
  27. Flesh out README.md
  28. In default.favorites.json file, implement ability to specify a "help" for each "prompt" instead of just top one. Useful for NS, EW prompts.

Prompt Issues

  1. Show unlikely scores because out of range for contract. e.g. 3N wrong direction.
  2. Check each prompt for missing statistics. Make list of minimum statistics.
  3. Have expert review terminology used in prompts.
  4. Underbid means par or sd score is higher than either a double or pass out.
  5. Overbid means your contract result will be lower than parscore or sd score. although you might be able to make a higher contract in another strain.
  6. Overbid prompt uses score < sd score. Should be making contract score < sd score. e.g. 2N < 129 is False.
  7. Overbid prompt doubled contract looks like SD Contract Max is doubled too. Doesn't seem right.
  8. Overbid prompt should use Declarer DD Score?
  9. Implement list of best bids at any point in auction. It was done in 7NT.info?
  10. actual, parscore, dd, sd, sd max -- need matrix of pcts and score diffs.
  11. Show percentages loss/gain for in categories: gift, fix, luck, unlucky, ...
  12. Develop prompt to show variance between actual scores, DD, and SD for same contract.
  13. Distinguish underbids as contract mistakes if double dummy score < parscore and double dummy score < sd score.
  14. Use emojis in prompts? 🥸
  15. implement rankings. can this be done using a prompt or must webpage be scrapped?
  16. Overall and directional rankings. Or can this be done using a prompt?
  17. Historical Data: Calculate STDev of dealer DD, SD, Parscore, SD Max.
  18. Show list of prompts in Help tab.
  19. Create a single dataframe for DD, SD, SD Max, Par, and Actual instead of separate dataframes.
  20. Does low SD Max correlate to bad bidding/contract?
  21. What does low SD but high Pct say about a declarer?
  22. Show partnership declarer pct when showing declarer rankings.
  23. Show par score pct and sd pcts for boards played by partnership.

Column Issues

  1. Rename any column names?
  2. Drop useless columns.
  3. What is the distinction between game_id and event_id? Are they currently used in the correct way?
  4. What to do with BBO* columns?
  5. Show historical data. Similar to 7NT.info.
  6. Show pct lost/gained for each category: gift, fix, luck, unlucky, ...
  7. What can be shown using LoTT? Can some type of matchpoint pct be shown?
  8. What can be shown using Declarer_DD_SL_Diff (how much variance between DD and trump length?). Can some type of matchpoint pct be shown?

Far Future

  1. Ouput expert commentary about each board. Tag each board with flat, lucky, gift, fix, unlucky in preparation for commentary.
  2. Rewrite using Polars? Need example of Polars using SQL.
  3. Implement audio, avatar, video.
  4. Analyze opening leads; nth longest, top of sequence, top of nothing, etc. Probably requires DD analysis of opening lead.
  5. Show deal's cards, dd, sd, par using graphical output? Maybe not because ACBL link seems adequate enough.
  6. Allow inputting of PBN file and its analysis.
  7. Create command line interface which can read prompts (internal or external) and output report.
  8. Implement play engine for analysis of play.
  9. Implement bidding engine for analysis of bidding.

Test

  1. How many simultaneous users can be supported?
  2. Verify mlBridgeLib.Lott is correct for all callers: Morty, 7NT, board_results.ipynb.

Documentation Aids

  1. https://markdown.land/markdown-cheat-sheet
  2. https://www.color-hex.com/

Related Projects Bugs

  1. What's the diff between acbl_tournament_player_history and acbl_tournament_sessions?
  2. Delete tournaments/players directory. Only use players and tournaments/sessions?
  3. Looks like passed out hands are disappearing (row is dropped from results). Game ID 868296.

Non-Deterministic Prompt responses:

  1. CASE WHEN
  2. Pct (ChatGPT 3.5 but happened once in 4)
  3. Unique boards

Experiments:

Experimental prompts: "Rankings": { "title": "Rankings", "help": "Show rankings by matchpoint percentage for pairs in your section and direction.", "prompts": [ "Show distinct strat_rank_NS, final_standing_NS, strat_NS, section, strat_type_NS, player_name_n, player_name_s sort by strat_rank_NS ascending, final_standing_NS descending, strat_NS ascending, section ascending", "Show distinct strat_rank_EW, final_standing_EW, strat_EW, section, strat_type_EW, player_name_e, player_name_w sort by strat_rank_EW ascending, final_standing_EW descending, strat_EW ascending, section ascending" ] },

Enhancement Requests: