AP / GP Guild System Guide FULL - No need excel knowledge!

Welcome to my AP/GP System Guide Video FULL!
- Check the whole guide in google docs: docs.google.com/document/d/1D...
- Download the excel file: docs.google.com/spreadsheets/...
- Invite my Discord Bots: docs.google.com/document/d/1s...
- Guide for editors (Lite): • AP / GP System Guide f...
- Playlist with all parts of this video: • AP / GP System Guide
Hello my cuties and be very welcomed to my dear creation named the AP/GP System, proudly made about 5 years ago (around 2018)! (Actually, it’s real name was supposed to be “YAAS System”, but you know, I’ve had better ideas than this terrible name).
What is AP/GP? In it's simplest form, whenever guild members go to a maze or activity together, they will earn Attendance Points (AP), and any drop that is obtained will generate Guild Points (GP). Say, if a guild generated 100 APs by going to mazes in 10 days, and 50 GPs worth of items are dropped, then every AP will have a value of 0.5 GP, then that will be multiplied by the APs each member personally generated, so the ones who assisted more mazes will have more APs to get GPs from.
I've made this file to be as simple and user friendly as possible (though 2 of the tabs can still be improved, but I still gotta think how to fix them first...) so no excel knowledge should be required at all.
This system is meant to be used by Tales of Pirates based games guilds, however if the nature of another game allows for this system to be used, you're the most welcomed to use it there as well.
With some creativity you should be able to turn this into your very own system with your own rules. Go ahead and make your guild shine!
If you've got any doubts, suggestions, comments or ideas, please do let me know at Discord @luisarlz as this system was purely created from ideas, trial and failures until it became what it is today.
Chapters:
0:00 - What is AP/GP?
2:03 - Setting up your sheet!
6:12 - How to count APs and GPs
9:08 - How to sell GP Items
10:50 - GPs Buying and Selling
11:45 - Bonuses Tab
13:09 - Transferring old GPs
14:04 - Cleaning your sheet
16:49 - I screwed up, what do I do?
17:28 - How to add more items
18:09 - How to add item icons
18:51 - Publish your sheet as HTML
19:29 - Order names alphabetically
19:55 - Delete duplicated names
20:27 - Counting stuff other than mazes
21:33 - Customizing your sheet
22:25 - Locking your sheet
-------------------------------------
Visit my new website! (still building currently): luisarlzproductions.com/
Contact me at Discord: @luisarlz
My facebook page: / luisarlzproductions
More about me at linktree!: linktr.ee/luisarlz

[@conejaluisa99]

What is AP/GP? In it's simplest form, whenever guild members go to a maze or activity together, they will earn Attendance Points (AP), and any drop that is obtained will generate Guild Points (GP). Say, if a guild generated 100 APs by going to mazes in 10 days, and 50 GPs worth of items are dropped, then every AP will have a value of 0.5 GP, then that will be multiplied by the APs each member personally generated, so the ones who assisted more mazes will have more APs to get GPs from.
I've made this file to be as simple and user friendly as possible (though 2 of the tabs can still be improved, but I still gotta think how to fix them first...) so no excel knowledge should be required at all.
This system is meant to be used by Tales of Pirates based games guilds, however if the nature of another game allows for this system to be used, you're the most welcomed to use it there as well.
With some creativity you should be able to turn this into your very own system with your own rules. Go ahead and make your guild shine!
If you've got any doubts, suggestions, comments or ideas, please do let me know at Discord @luisarlz as this system was purely created from ideas, trial and failures until it became what it is today.

[@user-io3yi6kz9i]

Luisa te escribí al Discord… necesito tu ayuda soy A23