Mr.Lobot Spreadsheets

In the last few days, I've been wasting lots of time playing a game called SWGOH. When I started to play, I only cared about gathering some fragments of chars I liked, nothing else.

Somehow it changes a lot, and it seems far more complex I imagined. Guilds have some kind of hierarchies; you need to climb in your shard, you have to collect fragments of units you don't even like. Our selfish lover.

TL;DR;

You can add the bot to your server using the following link:

The no Rose Tico club.

One of the main complaints is the time we have to spend here.

Then, I realize that the time I spend is nothing compared with the workload of officers or higher rank guildmates. So, I decided to waste more time on making a tool, so other people don't waste their time.

So, what is this?

Mr.Lobot Spreadsheets (still in development) is a simple tool to trace statistics of any guild and then produce a spreadsheet on CSV format you can download.

The main use cases are addressed to:

trace your own guild progress
trace another guild opponent in TW

Usage

It works on 2 main stages:

Create or modify a spreadsheet template with the units you desire
Report this spreadsheet with the stat of your interest

Commands

Config

Config options for the bot

+mrlobot_config option value
        
        Aliases: [+config +c] 
        where: 
            option: Config option, possible values (guild).
            value: Value of the option

Spreadsheet template

Adds units to the spreadsheet template, it the spreadsheet does not exist, creates it.

+mrlobot_addsheet sheet_name unit1, unit2, … 
        
        Aliases: [+add +a] 
        where:
            sheet_name: Name of the sheet to add units, if the sheet does not exists creates it
            chars: comma separated units names

Removes the units to the spreadsheet template, if no unit is send deletes the complete spreadsheet.

+mrlobot_deletesheet sheet_name unit1, unit2, … 
        
        Aliases: [+delete +d]
        where:
            sheet_name: Name of the sheet to delete or delete units
            chars(Optional): comma separated units names, 
                if empty, deletes the complete spreadsheet

Spreadsheet report

Reports the selected stat for the spreadsheet template.

Available stats:

gp: Galactic Power
gear: Gear Level
relic: Relic Level

+mrlobot_reportsheet sheet_name to_report
            
            Aliases: [+report +r]
            
            where:
                sheet_name: Name of the sheet to report
                to_report: Stat to report 
                    (gp-Galactic Power, gear-Gear Level, relic-Relic Level)

Misc

Shows the spreadsheets that starts with start, if start=* shows all the spreadsheets.

+mrlobot_showsheet start
        
        Aliases:[+show +s] 
        where:
            start: Start expression to search (wildcard * to get all sheets)

Lists the available units, and their aliases, that can be added to the spreadsheet templates.

+mrlobot_listchars start
        
        Aliases:[+list +l]
        where:
            start(Optional): Start expression to search available units, 
                if empty, lists all units.

Workflow

An example of a common workflow is:

Config your guild with +config
```
+c guild your_guild_id
```
You will see a message like this:
Add/remove units to create the templates you want to trace, with +add, +delete
```
+a sheet_name unit1, unit2, unit3,
+d sheet_name unit1, unit2, unit3
```
A message, like the following, will appear:

That means, later you will create a spreadsheet report with these units.
Report the available stats of your complete (or another one) guild, with +report
Example:

This produce a spreadsheet of gear levels of all units in the guild. As seen: