Guides

[img]https://dl.dropboxusercontent.com/s/fz2s7alqwhoe3lt/plaguetop.png[/img] [center][size=7][b][font=book antiqua]The Necrokeeper 5000[/font][/size] [size=5]A Necromancer Subspecies Tool[/b][/size][/center] [columns][color=transparent]xxxxx[/color][nextcol] [size=4]Welcome to the [i]Necrokeeper 5000[/i], the Council’s solution to keeping all your Necromancer and Necromancer-adjacent dragons straight. The Necrokeeper 5000 is a spreadsheet tool meant to be used in conjunction with [url=https://www1.flightrising.com/forums/qnc/2903785/1]The Necromantic Council RPG[/url], with the aim of helping the user keep track of all the things that can earn Council points. [center]Created for the 2024 Wymwound Awards community engagement challenge [url=https://www1.flightrising.com/forums/drs/3327210/1#post_3327210][img]https://file.garden/Zdww77wq23DtX_TK/Necros/WWA/Tools.png[/img][/url][/center] [nextcol][color=transparent]xxxxx[/color][/columns] [rule] [columns][color=transparent]xxxxx[/color][nextcol][center][url=https://www1.flightrising.com/forums/drs/2412017][img]https://imgur.com/7pOmtsa.png[/img][/url] [pinglist=140][/center] [nextcol][color=transparent]xxxxxxxx[/color][nextcol] [center][size=5][b]Credits[/b][/size][/center] [LIST] [*] Necromancer Subspecies, Necromantic Council RPG, and the original Council Point Calculator by @/3idolon [*] [url=https://www1.flightrising.com/dragon/60927224]Header images[/url] by @/Osiem [/LIST] Special thanks to 3idolon for enabling my spreadsheet nonsense, to @veilmochi for [s]doing their best to break this thing[/s] beta testing, and to the Necromancer Discord group for being my ever-patient sounding board for this project [color=transparent]xxxxx[/color][nextcol] [/columns] [rule] [columns][color=transparent]xxxxx[/color][nextcol] [size=4][b]Update Log[/b] [LIST] [*] 27/4/24 - Launch of the Necrokeeper 5000 v.1 [/LIST] [nextcol][color=transparent]xxxxx[/color][/columns] [center][img]https://dl.dropboxusercontent.com/s/335f8rj4xzh00m5/plaguebottom.png[/img][/center]

[img]https://dl.dropboxusercontent.com/s/fz2s7alqwhoe3lt/plaguetop.png[/img] [center][size=7][b][font=book antiqua]The Guide[/font][/size][/center] [size=6][b][font=book antiqua]What is the Necrokeeper 5000?[/font][/b][/size] The Necrokeeper 5000 is a Google Sheets-based tool meant to be used in conjunction with the [url=https://www1.flightrising.com/forums/qnc/2903785]Necromantic Council RPG System[/url]. I created it in order to keep better track of all my Necros, particularly in regards to all the things that could earn council points. The Necrokeeper 5000 is integrated with and can be used as an [i]alternative[/i] to the standard Council Point Calculator, meaning that your dragons and community engagement are automatically tallied based upon the data you input. No more manual counting and wondering if you got everything! [size=6][b][font=book antiqua]About the Necrokeeper 5000[/font][/b][/size] [indent] [b]The Necro Database Tab[/b] [list][*]The Necro Database tab has space for 250 dragons, which should (hopefully) be enough for even the most avid Necromancer fan [*] This tab contains four sections (Basic Info, Lore Details, Council Details, and a Council-specific point tallier based upon certain conditions (registry/lore/art/Necro-themed outfit etc.) for you to fill in for each dragon [*] Lore Details include whether or not your dragon is the leader of an entourage, whose entourage they belong to, if they belong to any factions etc. [*]Council Details focus on who's taking part in the Council RPG, what their standing is, and what their specialties and rankings are. [*] The Necromancer-specific Council Points tallier keeps track of whether or not a dragon has been registered, added to the elite registry, has a Necro-appropriate familiar and clothes etc. [/list] [b]The Community Participation Tab[/b] [list][*] A sheet specifically to help you keep track of your community engagement (and thus the Council points you earn) with the Necromancer Subspecies [*] To add to your tallies, simply add any relevant links, explanations, dragon ID numbers, tally marks etc. to a new row in each column[/list] [b]The Necro Statistics Tab[/b] [list][*] This tab has multiple charts to help visualize various statistics such as: [list][*] Subspecies/Divergence Stats [*] Variant Stats [*] Breed Stats [*] Element Stats [*] F vs M pose stats [/list][/list] [b]CPC Integration[/b] [list][*] The Necro Database tab has been integrated with the Necromancer Tally tab of the CPC, so all Necromancer-specific points are tallied automatically and added to your CPC total [*] The Community Participation tab has been integrated with the Thread and Contest Participation & Community Service tabs of the CPC, so every post/image link/dragon id/etc. related to community engagement can be recorded [*] The Necro Database tab is semi-integrated with the Council Dragon & Point Spending tab in that any dragon you indicate as a Council Member in the Database will then be added as an option to the list of council member dropdowns [*] The Necrokeeper 5000 can be linked to the Council Master Sheet just like the CPC! [/list] [/indent] [size=6][b][font=book antiqua]Getting Started[/font][/b][/size] [center][size=5][url=https://docs.google.com/spreadsheets/d/1hbPIYR0wXPLmV04JxGR8MwHCbM0jjDlH80ug2NBBXRI/edit?usp=sharing][b]-- The Necrokeeper 5000 - Master Copy --[/b][/url][/size][/center] [LIST=1] [*] Save a copy (File -> Make a Copy) of the Master Copy of the Necrokeeper 5000 above [*] Follow the CPC instructions to link your Necrokeeper 5000 to the Council Master Sheet [*] Add your dragons to the Necro Database tab. To quickly add all the basic info (name/id/breed/genes/colors etc.) of your Necromancers to the spreadsheet, use the [url=https://docs.google.com/spreadsheets/d/1ArbdC6XhWpUQVIqA3ojf-gN5RqKPgtFRWBmPgbZvFrU/edit?usp=sharing]FR Data Extraction Tool[/url] [*] Fill out the rest of the Necro Database with the relevant information for each dragon [*] Fill out the Community Participation tab [*] For more details on how to participate in the Necromantic Council and use the Council Point Calculator, read [url=https://www1.flightrising.com/forums/qnc/2903785/1#post_44496038]this post[/url]. [/LIST] [center][url=https://docs.google.com/spreadsheets/d/1f7LgN3d-StfbYOu-m4mj92b9LHkFzTHJffz5OChqFk8/edit?usp=sharing][size=5][b]-- See the Necrokeeper 5000 in action!--[/b][/size][/url][/center] [center][img]https://dl.dropboxusercontent.com/s/335f8rj4xzh00m5/plaguebottom.png[/img][/center]

[img]https://dl.dropboxusercontent.com/s/fz2s7alqwhoe3lt/plaguetop.png[/img] [center][size=6][b]FAQ[/size][/center] [columns][color=transparent]xxxxx[/color][nextcol] [size=4] [b]What if I just want to use the Necrokeeper to keep track of my Necros, and not for any Council-related things?[/b] [indent][size=4]You don't need to participate in Council shenanigans to use the Necrokeeper! I recommend hiding any tabs you don't use by right-clicking the tab and selecting 'Hide Tab'. [/indent] [size=4][b]I'm transferring community engagement info from the CPC to the Necrokeeper. How do I add my existing participation tallies to the new tallies on the Necrokeeper?[/b] [indent][size=4]Select the cell of the tally you want to change. The formula will look something like this: [i]=COUNTIf(A5:A, "<>")[/i] To add your tally pre-Necrokeeper, simply add [i]+n[/i] to the formula (with [i]n[/i] being whatever number you want to add): [i]=COUNTIf(A5:A, "<>") +n[/i][/indent] [b]CK, what if you decide to quit FR or lose interest in the Necromancer subspecies??[/b] [indent][size=4]In the event that I quit FR or leave the Necro community, I give full permission for folks to update and modify this tool should the need arise. I've also done my best to annotate both the front end (ie. the tabs you regularly see and use) and the back end (the hidden tabs responsible for calculations and such) so that any future Necrokeeper-keepers (or anyone curious as to how I've cobbled things together) can see how I've set things up.[/indent] [/size] [nextcol][color=transparent]xxxxx[/color][/columns] [center][img]https://dl.dropboxusercontent.com/s/335f8rj4xzh00m5/plaguebottom.png[/img][/center]

[img]https://dl.dropboxusercontent.com/s/fz2s7alqwhoe3lt/plaguetop.png[/img] [center][size=6][b]Reserved[/size][/center] [center][img]https://dl.dropboxusercontent.com/s/335f8rj4xzh00m5/plaguebottom.png[/img][/center]

[img]https://dl.dropboxusercontent.com/s/fz2s7alqwhoe3lt/plaguetop.png[/img] [center][size=6][b]Reserved[/size][/center] [center][img]https://dl.dropboxusercontent.com/s/335f8rj4xzh00m5/plaguebottom.png[/img][/center]