BABA YAGAS · LEADERSHIP REPORTING

Baba Yagas Alliance-Corp Report Builder

Baba Yagas Alliance-Corp Report Builder combines four required Alliance Auth exports plus an optional SIG membership report, maps linked characters to their main, pulls exact 30/90-day PvP activity from zKillboard, and exports a leadership workbook. An optional Google Drive integration publishes both a native Google Sheets copy and the Player Highlights PNG into one fixed report folder in the designated report-owner account.

Assign the FAT reports carefully Alliance Auth's FAT CSV does not identify whether it was generated for 30 or 90 days. Upload the correct export into each labeled FAT field. The app treats the upload slot as the period. The supplied ISK/activity report still provides 90-day ISK fields only.

LOCAL ZKILL ARCHIVE

Archive status

Completed character/months are stored locally and reused. Future reports only query zKillboard for missing or stale data.

Tracked characters—

Killmails archived—

Oldest activity—

Newest activity—

Last sync—

1. Upload Auth CSVs

Four reports are required. SIG membership is optional. The FAT exports must be placed in the correct 30-day and 90-day fields because the CSV itself does not contain its period.

30-Day FAT Report Alliance Auth FAT report configured/exported for the 30-day period. 90-Day FAT Report Alliance Auth FAT report configured/exported for the 90-day period. 90-Day ISK / Activity Report Report containing Ratting, Missions, Incursion, Pochven, and mining 90-day fields. Account / Linked Characters Report Account audit/list report containing each main and the JSON-linked character list. SIG Membership Report (Optional) Optional Auth export identifying SIG/group membership by main character. Each SIG is added as its own column at the far right of the Summary sheet.

2. Reporting end date

This date controls the zKillboard 30/90-day windows. For a clean monthly comparison, use Auth exports generated for the same reporting cutoff whenever possible.

End date/time Use current date/time

3. Director tracking & highlight eligibility

The current four Auth CSVs do not expose director status, so directors are maintained here by main-character name. This list is saved locally and reused on future runs. Enter one main character per line.

Tracked directors

Exclude directors from Player Highlights 30-day Kill Value leaderboard 30-day Kill Count leaderboard 30-day FAT Earners leaderboard Exclusions affect only the public highlights image. Directors remain fully tracked in the Excel report and corporation totals.

Saved settings are loaded automatically whenever the app opens.