Level Generation (level 2 & 3) - UQdeco2800/2021-studio-6 GitHub Wiki
Overview
An excel sheet was made to visualize the placements of the entities in level 2 and 3 (level2-3_layout_design.xlsm, sheet 1 is level 2, sheet 2 is level 3). It can also generate the GridPoint2 points for each specific entity on the map, saving time and effort to reduce the amount of time to manually update the positions in Java.
There are two buttons which are used to generate the positions for each entity column and another to clear if use had updated the positions of the entities on the grid map on excel. This was done using VBA excel code that is integrated inside the excel program which is then assigned to the GetTilePositions button. The VBA code to generate the GirdPoints2 can be seen here (VBA-Excel-Tile-Generation-Level2 and VBA-Excel-Tile-Generation-Level3) for Level 2 and 3 respectively as they have different assets.
Sidenote: Of course it would be even better to implement all of this within Java with just the grid map on a .txt file and parse through that instead of manually copying and paste the grid points for each entity into the GameArea spawn functions from Excel.