Jump to content

Dropsheet Ressource (G-Sheets/excel)

Competitive Ressource Excel

9 replies to this topic

#1 Halimede

    Member

  • PipPip
  • Clan Exemplar
  • Clan Exemplar
  • 29 posts

Posted 28 March 2016 - 04:13 PM

Hello,
In recent weeks i created an easy to maintain / expand / customize Dropsheet. The original idea came from a good friend of mine Queenblade from 228th and i expanded on that with new features and ideas to create these. I'am pretty happy with the end-result and wanted to share it here with the rest of the community. This publicly available Version is currently using the Maps made by BanditB17 (All Credit goes to him) and is missing Alpine and Terra Therma.

Feature Overview:
  • Easy to Maintain/Expand
  • Easy to Customize to fit any new Leagues/Mechs
  • Integration of a Pilot Proficiency Rating for chassis selection
  • Checks for Deck parameters to be Valid (Class/Weight/Tech/Duplicates)
  • Displays Map (Lances, Team Sides etc.)

Posted Image
Main Sheet - There are 5 Dropdecks to a template Sheet by Default.

Posted Image
Pilot Proficiency Sheet - Make this publicly editable and people can edit it for themself to match...


You can find a protected copy here:
https://docs.google....dit?usp=sharing
Go to "File" --> "Make a Copy". A new window pops up with your Copy and you can edit the entire thing and do whatever with it - Enjoy!

Edited by Halimede, 28 March 2016 - 04:27 PM.


#2 Ultimax

    Member

  • PipPipPipPipPipPipPipPipPipPip
  • Ace Of Spades
  • Ace Of Spades
  • 6,979 posts

Posted 28 March 2016 - 04:25 PM

Great resource, thanks for sharing!

#3 Not A Real RAbbi

    Member

  • PipPipPipPipPipPipPipPip
  • Survivor
  • Survivor
  • 1,688 posts
  • LocationDeath to Aladeen Cafe

Posted 28 March 2016 - 04:35 PM

GREAT STUFF!

#4 BanditB17

    Competitive Play Moderator & Shoutcaster

  • PipPipPipPipPipPipPip
  • WC 2017 Shoutcaster
  • WC 2017 Shoutcaster
  • 517 posts
  • LocationWisconsin, USA

Posted 28 March 2016 - 05:25 PM

Cool! I have my own spreadsheets but I may incorporate elements of your design into mine :)

Thanks for the map credit! Those came from smurfys, I just made them easier to read.

#5 C1vrock

    Rookie

  • Little Helper
  • Little Helper
  • 1 posts

Posted 28 March 2016 - 08:00 PM

This is awesome. Great work!

#6 Better Call Saul

    Member

  • PipPipPipPipPip
  • Bad Company
  • Bad Company
  • 144 posts

Posted 28 March 2016 - 09:47 PM

Great job! Sorry re-read the post about the missing images.

Edited by Better Call Saul, 29 March 2016 - 12:30 AM.


#7 Halimede

    Member

  • PipPip
  • Clan Exemplar
  • Clan Exemplar
  • 29 posts

Posted 28 March 2016 - 09:54 PM

View PostHalimede, on 28 March 2016 - 04:13 PM, said:

This publicly available Version is currently using the Maps made by BanditB17 (All Credit goes to him) and is missing Alpine and Terra Therma.


I am actually doing a different setup for the ones we are going to use and used Bandits Maps as they are provided (missing alpine and terra therma). Its very easy to edit / add / modify anything you need though ^^.

grab em here:
http://mwo.smurfy-ne...peaks&m=assault

and if you got trouble adding em feel free to ask.
I was going to add em either later today to tomorrow if you can wait

Edited by Halimede, 28 March 2016 - 10:06 PM.


#8 Night Fury76

    Member

  • PipPipPipPipPipPip
  • Ace Of Spades
  • Ace Of Spades
  • 300 posts
  • LocationAustralia

Posted 28 March 2016 - 11:07 PM

View PostHalimede, on 28 March 2016 - 04:13 PM, said:

Hello,
In recent weeks i created an easy to maintain / expand / customize Dropsheet. The original idea came from a good friend of mine Queenblade from 228th and i expanded on that with new features and ideas to create these. I'am pretty happy with the end-result and wanted to share it here with the rest of the community. This publicly available Version is currently using the Maps made by BanditB17 (All Credit goes to him) and is missing Alpine and Terra Therma.

Feature Overview:
  • Easy to Maintain/Expand
  • Easy to Customize to fit any new Leagues/Mechs
  • Integration of a Pilot Proficiency Rating for chassis selection
  • Checks for Deck parameters to be Valid (Class/Weight/Tech/Duplicates)
  • Displays Map (Lances, Team Sides etc.)
Posted Image
Main Sheet - There are 5 Dropdecks to a template Sheet by Default.

Posted Image
Pilot Proficiency Sheet - Make this publicly editable and people can edit it for themself to match...


You can find a protected copy here:
https://docs.google....dit?usp=sharing
Go to "File" --> "Make a Copy". A new window pops up with your Copy and you can edit the entire thing and do whatever with it - Enjoy!


You are going to so make me rework this old webpage into something workable now

#9 Halimede

    Member

  • PipPip
  • Clan Exemplar
  • Clan Exemplar
  • 29 posts

Posted 28 March 2016 - 11:17 PM

i did consider going for a website thing but figured "meh" too much work and its easier to add all the new stuff to a simple google sheet :P





1 user(s) are reading this topic

0 members, 1 guests, 0 anonymous users