Prompt

Mobile Game: Last War

Requirement: Squads 1 will require all tank heroes. Squad 2 will require all air heroes. Squad 3 will require all missile heroes. Squad four will be a mixture of the most powerful heroes that remain from those unused.

Issue: Assembling the correct heroes for each squad requires taking multiple items within a hero into consideration that could maximize its effectiveness. This includes placement slots (front left/right, back left/middle/right) that could impact how effective they are.
Objective: Utilizing this data, I need an excel sheet that could be updated regularly as upgrades are made, in order to identify what changes in squads i may need to make, either replacing heroes, and moving them to another slot or location within that slot. This excel sheet will be uploaded to AI to provide recommendations of changes

Additional Considerations: Check for redundancy of items and use the most terms/references to items. Check for sub categories when looking for items, this needs to be granular, from hero items in attributes, skills, tiers, exclusive weapons, items within each of the previously listed to identify each item that could impact the hero's effectiveness. Create a second sheet to identify where exactly each item is located, and provide detailed directions.

Impacts to effectiveness: Within the primary sheet there needs to be additional consideration for changes that could impact the heroes effectiveness that need to be tracked. These items are, but not limited to, decorations, and even the drone.