Gazz Posted November 30, 2016 Share Posted November 30, 2016 Hundreds of A15 gamestages and accompanying horde group setups were so not written by hand. Did they write themselves? They kinda did. =) Google Spreadsheet. Warning! Math ahead! What you should do first: File menu -> Make a copy... Then you can mess around with your copy. (you cannot edit the original) Guppycur said that he managed to export it to a local XLS file but how or if that works is none of my concern. Guppycur made a how-to video on that. Or maybe it's a how-not-to, I haven't seen it, yet. =) Link to comment Share on other sites More sharing options...
Guppycur Posted November 30, 2016 Share Posted November 30, 2016 If that does what I think it does, and I'm on my phone so can't really check, I'm flying to Germany to kiss you. Link to comment Share on other sites More sharing options...
Guppycur Posted November 30, 2016 Share Posted November 30, 2016 Soooo much easier for those of us adding custom zombies... Link to comment Share on other sites More sharing options...
Gazz Posted November 30, 2016 Author Share Posted November 30, 2016 I can see how making a one line entry is easier than working it into hundreds of groups with a scaling probability. (without eating your keyboard) Link to comment Share on other sites More sharing options...
Guppycur Posted November 30, 2016 Share Posted November 30, 2016 Still stuck on my phone and the xls editor sucks; does this version contain the cell code or just the values? Yes, and editable version would be fantastic. - - - Updated - - - Oh crap, that's just a pdf. Share the xls. Link to comment Share on other sites More sharing options...
Guppycur Posted November 30, 2016 Share Posted November 30, 2016 I can see how making a one line entry is easier than working it into hundreds of groups with a scaling probability. (without eating your keyboard) The idea of even generating the xml via xls is genius... I would have never thought of that. I've been looking at ways to do it programmatically, but I'm not a very good programmer so the task was always too daunting... but I AM good inside EXCEL, so now I'm wondering how many other xml's I can write an "editor" for using EXCEL. Link to comment Share on other sites More sharing options...
Gazz Posted November 30, 2016 Author Share Posted November 30, 2016 Well, there really is no to little programming in there. It's all data, arranged, filtered, and sorted to... fit. Managing the game data is a lot of what I do here. Naturally there were several iterations of this during A15 but with this setup it is trivial to change the balancing or adding a new zombie type. Adding new rules is some work... but much less than redoing everything by hand. Link to comment Share on other sites More sharing options...
Guppycur Posted November 30, 2016 Share Posted November 30, 2016 @Gazz: RawHordeStages seems to be the main place where higher zombie levels get assigned to higher game stages; the issue I'm having is, I've just appended about 60 zombies, thus overwriting your system of repeating harder zombies in ZombieTypes to get the harder ones to spawn at higher levels. Have you thought about assigning "Levels" to the ZombieTypes based on hitpoints, then using that system to determine what zombies go in RawHordeStages? Link to comment Share on other sites More sharing options...
Gazz Posted November 30, 2016 Author Share Posted November 30, 2016 I don't understand what controls what happens at ID 17 (dogs and worse)? See TypeRND!C Link to comment Share on other sites More sharing options...
Guppycur Posted November 30, 2016 Share Posted November 30, 2016 @Gazz: Can you elaborate on this? Scale for GS: IF a probability from/to is entered for a zombie type then it will have the base prob at GS 1. Then it scales up linear but DOES increase beyond the Scale for max GS cap. Link to comment Share on other sites More sharing options...
Gazz Posted November 30, 2016 Author Share Posted November 30, 2016 @Gazz: RawHordeStages seems to be the main place where higher zombie levels get assigned to higher game stages; the issue I'm having is, I've just appended about 60 zombies, thus overwriting your system of repeating harder zombies in ZombieTypes to get the harder ones to spawn at higher levels. Have you thought about assigning "Levels" to the ZombieTypes based on hitpoints, then using that system to determine what zombies go in RawHordeStages? You can already assign a probability so that scales automatically. Or you can adjust the existing system that expands the range of picks as GS increases. @Gazz: Can you elaborate on this? Just look at the last entries in GroupOutput. See how it scales. Link to comment Share on other sites More sharing options...
Guppycur Posted November 30, 2016 Share Posted November 30, 2016 Thanks; I have a habit of figuring out an answer after I ask a question; I saw the probabilities, got it covered. Complicated stuff man, nice job. It's going to be fun extrapolating it for use for my UMA collection. Link to comment Share on other sites More sharing options...
Guppycur Posted November 30, 2016 Share Posted November 30, 2016 Are you using UMA and Strength in ZombieTypes for anything other than reference? If not, were you planning to? - - - Updated - - - @Saving locally I can save locally, but damn if Excel in 2007, 2010 or 365 recognizes some of the formula's... as a result it removes them when opening. Because Microsoft sucks. I haven't tried Open Office, but it's best just to keep it on your googledrive. Working fine. Link to comment Share on other sites More sharing options...
Gazz Posted November 30, 2016 Author Share Posted November 30, 2016 The UMA stuff is just notes. The console has no UMA zombies so it has it's own version anyway. Link to comment Share on other sites More sharing options...
DUST2DEATH Posted November 30, 2016 Share Posted November 30, 2016 Are you using UMA and Strength in ZombieTypes for anything other than reference? If not, were you planning to? - - - Updated - - - @Saving locally I can save locally, but damn if Excel in 2007, 2010 or 365 recognizes some of the formula's... as a result it removes them when opening. Because Microsoft sucks. I haven't tried Open Office, but it's best just to keep it on your googledrive. Working fine. Libreoffice is far better with office docs and translations than openoffice is. Oo is dead now anyway. Link to comment Share on other sites More sharing options...
Tin Posted December 2, 2016 Share Posted December 2, 2016 The UMA stuff is just notes. The console has no UMA zombies so it has it's own version anyway. Hey Gazz, When the next update is released can you put in a few more comments about this in the files? please and ty Link to comment Share on other sites More sharing options...
Guppycur Posted December 2, 2016 Share Posted December 2, 2016 Libreoffice is far better with office docs and translations than openoffice is. Oo is dead now anyway. Oh? Good to know. Either way I thought it odd some functions weren't available in even the latest office, but the online version works well enough. Even if a little slow. @tin I'm getting pretty handy with the basic functions, got any specific questions that I can answer and gazz can correct me on? Link to comment Share on other sites More sharing options...
Gazz Posted December 2, 2016 Author Share Posted December 2, 2016 When the next update is released can you put in a few more comments about this in the files? please and ty Comments about...? Link to comment Share on other sites More sharing options...
Guppycur Posted December 2, 2016 Share Posted December 2, 2016 Things like the relationship between TypeRND:A8 and other cells have would be nice; right now we have to go backwards, i.e. find the cell, see what cell affects that number, follow those branches to see what cells affect THOSE numbers, just to find out what A8 does, as an example. It's doable, but commenting your work would be awesome. Link to comment Share on other sites More sharing options...
Gazz Posted December 2, 2016 Author Share Posted December 2, 2016 Well, it's never been an issue because no one on the team is really interested in how it's done - as long as it works. At most someone took a peek and was like . Link to comment Share on other sites More sharing options...
Guppycur Posted December 2, 2016 Share Posted December 2, 2016 Yeh, but now you have thousands of hungry mouths to feed with that ambrosia you call a spreadsheet. Link to comment Share on other sites More sharing options...
Gazz Posted December 2, 2016 Author Share Posted December 2, 2016 Probably less than 10. It is pretty technical. =P Link to comment Share on other sites More sharing options...
Guppycur Posted December 2, 2016 Share Posted December 2, 2016 Are you free to scale how you please, or are you running this by the rest of the team? Just curious how the internal workings work. I'm having a blast with this; I haven't actually copy/pasted my changes to my server yet, but it's nice to see ahead of time what affects what, and how. Link to comment Share on other sites More sharing options...
Gazz Posted December 2, 2016 Author Share Posted December 2, 2016 Most of it I just set up and no one complained so that was that. What zombies can go in and what distribution usually comes down to some haggling between designers and coders. I haven't actually copy/pasted my changes to my server yet, but it's nice to see ahead of time what affects what, and how. That's the big plus of using spreadsheets for that kinda stuff. Link to comment Share on other sites More sharing options...
Tin Posted December 2, 2016 Share Posted December 2, 2016 Comments about...? Just more.. I ask because MM has Posted that more of the gamestage mechanic is being fitted into the spawning mechanic (Wandering/screamer ect,.) Basically, If you have some on the dev team saying: it would be cool to have your lingo toned down a bit more and translate better Link to comment Share on other sites More sharing options...
Recommended Posts
Archived
This topic is now archived and is closed to further replies.