Results 1 to 6 of 6

Thread: Mah Jong score keeping - help with working out differences between scores

  1. #1
    Neophyte gordonrobb's Avatar
    Join Date
    Aug 2019
    Posts
    3
    Articles
    0
    Excel Version
    365

    Mah Jong score keeping - help with working out differences between scores



    Register for a FREE account, and/
    or Log in to avoid these ads!

    I'm putting together a spread sheet to keep track of the scores for Mah Jong and I'm stuck at a bit. Basically there are 4 players, and the one who goes Mah Jong get's a score that the other 3 pay them. If that person is East wind, everyone pays them double. Other wise the person who is east wind pays double. I've managed to figure all of that out. It's not elegant but it works.

    However, once the Mah Jong winner has been paid, the other 3 players pay each other the difference between their scores. So if the scores were 25, 50, 20, 5 and the first player was East Wind. If the second player (50) went Mah Jong, everyone pays that player. Then plare one would receive 5 from player 3 (25-20) and 20 from player 4 (25-5). But also, player 3 would receive 15 from player 4 (20-5). Can anyone help me with a way of figuring this out? It has to ignore who went Mah Jong out of the 4.

  2. #2
    Administrator AliGW's Avatar
    Join Date
    Nov 2015
    Location
    Ipswich, Suffolk, England
    Posts
    1,248
    Articles
    0
    Excel Version
    Office 365 Subscription
    Please attach your workbook so that we can see the context and help. We might even be able to suggest some improvements.
    Ali
    Enthusiastic self-taught user of MS Excel!

  3. #3
    Neophyte gordonrobb's Avatar
    Join Date
    Aug 2019
    Posts
    3
    Articles
    0
    Excel Version
    365
    Quote Originally Posted by AliGW View Post
    Please attach your workbook so that we can see the context and help. We might even be able to suggest some improvements.
    I have no doubts it can be improved, but I'm not bothered how it does what it does, as long as the result is the same. I'll attach the file, but it does not have the bit that I'm stuck with in it, as I'm stuck with it

    MahJong Scorer.xlsx

  4. #4
    Administrator AliGW's Avatar
    Join Date
    Nov 2015
    Location
    Ipswich, Suffolk, England
    Posts
    1,248
    Articles
    0
    Excel Version
    Office 365 Subscription
    OK - so I don't play MahJong, however this does not mean I cannot help you.

    What it DOES mean is that I need you to manually mock up two or three scanarios based on the scoring rules so that I can see (a) what you want it to look like and (b) how you've calculated it (already partly explained above).

    Please add the mocked up items to the spreadsheet and then I'll take a look for you.
    Ali
    Enthusiastic self-taught user of MS Excel!

  5. #5
    Neophyte gordonrobb's Avatar
    Join Date
    Aug 2019
    Posts
    3
    Articles
    0
    Excel Version
    365
    OK, thanks very much. I've added some comments to the bits I have already done, and then shown a couple of hands, trying to explain how it is supposed to work. it's complex which is why I'm trying to do it on a spread sheet

    Hopefully it all makes sense

    MahJong Scorer with comments.xlsx

  6. #6
    Administrator AliGW's Avatar
    Join Date
    Nov 2015
    Location
    Ipswich, Suffolk, England
    Posts
    1,248
    Articles
    0
    Excel Version
    Office 365 Subscription
    I know it's complex - it's notorious for being so! Let me have a look and see if I can help.
    Ali
    Enthusiastic self-taught user of MS Excel!

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •