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: https://docs.google.com/document/d/1DnGRLUJOHvqu95egD2u3PO6vSY50V9HsaitV8Ah1Veo/edit?usp=sharing - Download the excel file: https://docs.google.com/spreadsheets/d/1d6z-_6QJ29bQNztPP2hCQg0Gv2G5cuTtV0GdusT2ihE/edit?usp=sharing - Invite my Discord Bots: https://docs.google.com/document/d/1sTc4pvK4hVyZTdW2s9vqwNDrj9svubVGMI1TdpYFIls/edit - Guide for editors (Lite): https://www.youtube.com/watch?v=aKhHBPIVQvA - Playlist with all parts of this video: https://www.youtube.com/playlist?list=PLBP4m3xAa_2aAK_FZVJM3s36bZp4ecBAD 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): https://luisarlzproductions.com/ Contact me at Discord: @luisarlz My facebook page: https://www.facebook.com/LuisaRLZProductions/ More about me at linktree!: https://linktr.ee/luisarlz