Forum
Forum » General ChatMD Gang War Sheet
- Author
- Post
-
Currently wars can feel a bit pointless and difficult to resolve - rarely are terms ever decided upon and they can often drag out with little hope of any tangible resolution.
To that end, I've tried my hand at putting together a little tool for use by the MD community.
You can find the blank sheet here: https://docs.google.com/spreadsheets/d/1dE-7DCyKo2T4OtD4sfEXG228sLQTgECuPnzTwAYuBx0/edit?usp=sharing
And an example sheet here: https://docs.google.com/spreadsheets/d/1GPK0kkWjKuFuIrei2Uc0eR3JgltswyjbxQMJejFYpg4/edit?usp=sharing
I've tried to automate it as much as possible to make managing it easy and have set out some guidelines regarding its use. Expanding it to include more than two gangs won't be difficult, but I thought I'd keep it simple to begin with.
To use it, a copy of the "Open" version just needs to be made for use by the two gangs involved. Please do not use the original "Open" sheet, make sure you create a copy for your own use - multiple people using the exact same sheet for different wars isn't liable to work too well.
If you have any thoughts or recommendations that could improve it, feel free to let me know. -
Awesome good idea man!
-
I like your thinking .
-
One thing that may need to be adjusted is its suitability for mobile use - it was created on a desktop and looks/functions fine there, but it probably isn't super mobile friendly
If people feel that they'd prefer to use it via mobile most of the time and it's currently too difficult to manage via mobile, I can look at making adjustments in order to make it more mobile friendly
To clarify on the automation present in the sheet:
- Entering a gang name in the area next to Gang Name 1 and/or Gang Name 2 in the "Gangs Involved" section of the Introduction/Terms page will populate all other relevant areas on the sheet with those names
- Once a hit log in the Online and Offline Hits page/s has been confirmed by the relevant auditor and the check box marked, the victory points for that hit will automatically be calculated and added
- Gang members only need to have their starting level and current level recorded, the difference between their current level and their start level will automatically be calculated and victory points will automatically be awarded based on how many levels have been gained
- All totals on the "Score Sheet" automatically update based on the victory points awarded in the Online Hits, Offline Hits and Level Gains pages -
What the heck Ethix - you have too much time in your hands
-
Since I took over the purchasing and logistics department of the company I work at, I've had to get better at using Excel and Google Sheets

Might as well put that to use, get something back for suffering through all the nonsense
Figured this might help act as a framework for people to even start friendly gang wars - in a way that's a bit more structured than just hitting each other until one side decides they've had enough -
In all fairness, that was a great effort. I just couldn't care to take a deeper look at this point since I'm at work
-
Can we have two auditors?
MD covers several timezones although we don't have many players at the moment: US, Australia, Asia.
I imagine one auditor would get their hands full when they log back on after sleeping and their friends were hitting like crazy. -
That makes plenty of sense and is an easy addition, consider it done

I won't worry about the example sheet as it's really just to showcase how it all looks with a bit of data inserted, but will update the "Open" sheet