This post has been de-listed
It is no longer included in search results and normal feeds (front page, hot posts, subreddit posts, etc). It remains visible only via the author's post history.
I hate when my friends ask me to just do things for them but in this case the learning curve is steep, so hopefully someone who reads this finds it easy enough to just throw it together for me. I'll be very appreciative :)
I am trying to create a spreadsheet that tracks XP in my RPG like so:
Session Number:
Player Name:
Date Joined:
Current XP:
Bonus: TRUE / FALSE
Present at Last Session: TRUE / FALSE
Sessions Missed: Calculate how many FALSE
IF all players have TRUE in [Present at Last Session]:
Calculate the number of consecutive sessions in which all players were "TRUE" = X
Multiply X by 100
Add 100
Add to [Current XP] = Y
If [Bonus] = TRUE then also add 20% of Y
Calculate Total = Replace [Current XP]
If any players have FALSE in [Present at Last Session]:
Add 100 to [Current XP] for the players who are "TRUE" = Y
If [Bonus] = TRUE then also add 20% of Y
Calculate Total = Replace [Current XP]
Output (for all players, all in one document):
[Player Name 1] joined on [Date Joined], has missed [Sessions Missed] sessions and currently has [Current XP].
[Player Name 2] joined on [Date Joined], has missed [Sessions Missed] sessions and currently has [Current XP]. etc
Subreddit
Post Details
- Posted
- 8 years ago
- Reddit URL
- View post on reddit.com
- External URL
- reddit.com/r/spreadsheet...