Spreadsheet data analysis SS featured games UPDATED: 26-06-2018 81% Complete

[corvusd]

Hi community!

I want share my little research of the technical use of the games developed in the past to our machine. To learn and discover  how deep use the machine.

The intention I have is to share and help grow the community of our great console. A small contribution and tribute to this great machine. Which he owed for a long time.

I share a spreadsheet where I am compiling technical data of a selection of games(258, aprox 20% total games)  that I think are outstanding of the system. That can help us to better understand how effects were made or how they used the machine better. Currently this half-translated into English, since my native language is Spanish.

UPDATE table and data at 26-06-2018, view better whit 65% zoom level in google docs viewer:
https://docs.google.com/spreadsheets/d/1tcTUC9oZ70ZGzVV58ca20bfwn0YEWzyJbxAMVFrAVwE/edit?usp=sharing

Some notes:
With respect to the use of memory, it has been one of the last aspects that I am compiling. They are in column AA. I have tried to break them down by the different memory wells. The data is approximate, since even the Yabause does not quantify in total values ​​the use of memory. Column AB recollect the staff credits, to find the best programmers or teams. Column AC recollect dates release to see how the delay the version or port to SS respect PSX or others...

I started by analyzing the use of transparency of VDP1, VDP2 and VDP1 + VDP2. Afterwards, with depth of color in textures and total, use of gouraud and lighting, use of layers of VDP2 and color calculation ... to gradually embrace many aspects. [EDIT 03-01-2018] Like type of FMV formats, data of the archive an quality, use of SCU for FMV or 3D, Use of VDP1 or VDP2 or both to FMV. Use of sound system of the CDXA or DSP... etc...

[EDIT 14-12-2017] It would help a lot, that Yabause not count the number of elements in the VDP1, to see how many polygons are on the scene. <- Now we can know how many elements in the scene whit the last Git version of the Yabause. I update the "Z" column whit the data of the many games. Not possible filter by types of color calculation or type or data, but is very useful new feature. Or the amount of elements that are using Gouraud, or half-transparent, filter them somehow. Since the debugger lists them all and their properties. Or ideally show the % use of the processors, this last more complicated.

I will update and translate the sheet as I can. If someone wants to contribute in the edition only that asks me, the more we are better.

Regards!

[XL2]

Good job! Keep up your good work!

[corvusd]

Thanks to you for your awesome work whit Sonic Z-Treme!!! GO GO GO!!

[corvusd]

UPDATE 04-02-2018: I add two new columns. M y N is a VDP1+VDP2 effects or use. M is new column to known the use or "table fog" effect or similar. N column is a reorder VDP1>VDP2 transparency effect data. The other new column is a AB. In this column check is a game make "tesselation" effect to render polys.

Other improvements: Simplify data to make better filters data. Add more date in a lot of games.

[corvusd]

UPDATE 17-02-2018:
- Complete Sonic Team games analysis.
- Improve SCU data % in some games.
- Added new data of "Table fog" and "Tesselation" columns in a few games.
- Added some new game credits in Perfect/Tantalus games
- Start analysis a Altron games.
- Improve simplification data entries and English entries.
- Improve and add more color filter to know level of analysis in a lot of games.

[mindslight]

Thx for the update

[corvusd]

Thank you Johannes!

I will make more update, but more slow I believe. Right now I think that It is a good database to knowledge the "state of art" in SS.

I want more forward also. I will do you proposals of functions to get to do with the SS what was not done and more.

More work for you and XL2! XD

Greetings!

[corvusd]

UPDATE 24-02-2018:
- Complete Treasure games analysis.
- Start to translate all text to English.
- Improve simplification data entries for simplify filters.

[corvusd]

UPDATE 04-03-2018:
- Add new column to analyse possible "Render to texture" in a few games.
- Improve data analysis from the SCSP-DSP column. CD-XA games fill by own mistake knowledge. Change to CD-DA and Analyse if use DSP for something.
- Improve SCU-DSP data in a lot of games.
- Complete more games.
- Continue to translate all text to English.
- Continue improve simplification data entries for simplify filters.

[corvusd]

UPDATE 05-03-2018:
- Add new game. I hope the last XD
- Improve more data analysis from the SCSP-DSP  and SCU-DSP columns.
- Improve in a lot of games.
- Improve data analysis of games and classification for new column "O": Render-to-texture. Separate Frame buffer render to, and CPU render to... Different possible target.

[corvusd]

UPDATED: 24-03-2018 73% Complete:
- New games. Up to 240. My curiosity has no limit. XD
- Improve a lot of games, in various columns.
- Complete more games.

[corvusd]

UPDATED: 23-05-2018 79% Complete:
- New games. Up to 257. No comment. 
- Improve a lot of games, in various columns.
- Improve title columns.
- Improve some most important SEGA games.
- Complete more games.
- Add more credits games.
- Improve Lighting column data.
- Basis Analysis to Altron games.

[corvusd]

UPDATED: 28-05-2018 80% Complete:
- Complete analysis of: SEGA GAME SAMPLE 1 for SBL 1.1 (1994-08-01)
- Complete Dragon Ball Z Games.
- Improve description and data analysis of "Lighting" and "Layers / Color BPP and Type" columns.

[XL2]

Thanks for the update.
Have you seen a single game doing paletted gouraud?
Also, have you seen a game using RBG1?

[ponut64]

Thanks for the update.
Have you seen a single game doing paletted gouraud?
Also, have you seen a game using RBG1?

MechWarrior 2 ACE, as I understand it, has RBG0 as the ground plane and RBG1 as the sky plane.