Designer, Personal project
October 2021 – November 2021
Bullet points:
- Utilized Google forms to receive relevant user information
- Utilized Google Sheets to sort, filter, and correct user inputs before being exported to primary sheet.
- In Google Sheets, created a user-friendly GUI to filter through overall user data and display them on one easy to use page.
- Trained users in use of the sheet for gameplay usage.
Full description
In the game New World by Amazon Game Studios there is a player versus player element called ‘Wars’. In game, players are separated by faction, and further broken down into in-game companies (Guilds). For wars, player companies are allowed to own and operate regions of the game space for their faction, providing their faction and company benefits, and adding restrictions to enemy factions and companies. Regions are traded between player companies by waging war between each-other, starting with an enemy faction undertaking general PvP missions to ‘destabilize’ the region, leading to a large scale pvp battle where defending players try to protect points around a regional fort, while attacking players try to capture these points.
Because of the size of these battles (50 players each side), and time limits on pre-planning (15 minutes before battle), organization of players became a struggle for my company and allied faction. I found that during every war, the 15 minutes before battle were a major rush of direct messages and voice calls between hundreds of people, trying to figure out what players would pair best with the overall plan.
To ease this struggle, I decided to make a central repository of player information for easy searching and planning ahead of time. Having the individual players fill out their information, and be able to update that information. Providing extra time for in-game leadership to be able to create a battle plan.
To develop this project, I decided to use Google Sheets and Google forms. Both can be linked together, and shared using a simple URL, this let it have the widest reach possible as any player who could have played the game in the first place would be able to fill it out on the website.
The starting point for this was what information needed to be collected in the first place. For that, I used a Google Form sent out to all players in our faction, collecting the player’s name, discord handle, level and weapon. This form was then linked to a google sheet which used filters and and sorting to organize the players, eliminating double entries, false entries, and spelling errors.
From the interim ‘filter’ sheet, the compiled list of total players was sent to the final user-friendly sheet. On that workbook, the list of players is sent to a hidden filter list. This filter list takes the settings from the main page (Limiting the list based on weapons, roles, levels, or any combination therein) and runs a filter on the original input list before sorting and outputting back to the main page.
