Robert Olesen Posted October 24, 2004 Share Posted October 24, 2004 Edit 31.12.2004: Version 2.22. is out. Look below. There are a number of changes, summing up to a total effect that had me wondering if this should have been 3.0 instead of 2.2. I highly recommend an update if you're using ROQC. Get it at http://www.roqc.cdgroup.org/ Here's the change list: Snipers added as separate unit category (SN, see 5.3.1) with separate experience rules so that they have a better chance of gaining experience. Returning casualties modified to take into account the number of flags you hold at the end of the battle. The ability to use Favor to modify the battle size has been changed into an ability to use Favor to get more support (which you buy in the editor, so it is on top of the QB purchase). Enemy Force Handicap increased for Meeting Engagements at Normal difficulty and above. Tree Coverage, Hills and Damage modifiers increased for Raids to give a higher chance of terrain with cover. Favor calculation for Raids changed to start with negative Favor, which is then offset by accomplishing the mission. You now get a small number of replacements as a minimum after each battle. The ability to use pre-made maps has been added, through usage of Pyewackets map conversion tool. A list of maps has been added for easy comparison with the map settings of the current battle, and all these maps are available for download from the ROQC site. Reduced the chance of an Axis armored force mix in the Finnish region. You are now required to edit the ammo setting of exploiting units down to 20%. Options to disable Raid and Retreat battles added. You can now issue a few commendations to those units that performed exceptionally well in your opinion, providing them with some extra experience points at the cost of a few favor points. Experience gained from casualties/captured adjusted a bit. Medal requirements increased ca. 10% to compensate for the two experience additions. [ December 31, 2004, 03:07 AM: Message edited by: Robert Olesen ] 0 Quote Link to comment Share on other sites More sharing options...
Alech Posted October 24, 2004 Share Posted October 24, 2004 Weeeeeee!!! 0 Quote Link to comment Share on other sites More sharing options...
Gregore Posted October 25, 2004 Share Posted October 25, 2004 This looks insanly interesting.....I just cant figure out how to make it work:( EDIT* Ignore me....I just decided to read the Instruction booklet:P 0 Quote Link to comment Share on other sites More sharing options...
treadgrease Posted October 26, 2004 Share Posted October 26, 2004 Always wanted to try this, but don't have excel. Figured I'd give the printout sheets a try, but a problem; for some reason, I can't get the gif files to print correctly. Always end up clipped off, shortened, etc. Viewing and printing in Print Shop Pro. Ideas ? 0 Quote Link to comment Share on other sites More sharing options...
Robert Olesen Posted October 26, 2004 Author Share Posted October 26, 2004 You need to fit them to a page in the best format - portrait for the battle sheet, landscape for the others (I think). Microsoft photo editor is in fact my gavourite for easy graphics printing, but you probably don't have that. Irfanview is free and can do it, but it isn't too good on printing. Don't know Print Shop Pro. I'm sure there are others - Windows Paint may even do it if it can load jpeg. 0 Quote Link to comment Share on other sites More sharing options...
Robert Olesen Posted November 7, 2004 Author Share Posted November 7, 2004 Version 2.21 is out. It contains a spreadsheet correction, the rules are unchanged: You could not issue commendations in the spreadsheet because the cells were erroneously write protected. 0 Quote Link to comment Share on other sites More sharing options...
Robert Olesen Posted November 28, 2004 Author Share Posted November 28, 2004 There is a minor error in v2.21 Cell K59 of the Tables1 sheet should contain the value -1, not -2. To change it you need to unprotect the sheet (Tools > Protection, it has no password). Remember to protect it afterwards in order to avoid accidental overwrites. 0 Quote Link to comment Share on other sites More sharing options...
Robert Olesen Posted December 18, 2004 Author Share Posted December 18, 2004 As a consequence of a suggestion by DzrtFox I will implement the following in the rules: Note: A very low ammunition level increases the likelihood that Combat Mission will force an automatic ceasefire. To reduce the risk of a premature automatic ceasefire the sum of your ammunition percentage and the enemy ammunition percentage must be at least 100%. If the sum falls below 100%, increase both in steps of 10% until the sum is 100%. For example, if you roll up 60% and the enemy 20% the adjusted result would be 70% and 30%.Feel free to implement this manually until I get a fix out. And also feel free to tell me if you find a limit of 100% appropriate, or if it should be higher. 0 Quote Link to comment Share on other sites More sharing options...
DzrtFox Posted December 19, 2004 Share Posted December 19, 2004 Good thinking Rob. Are you applying this to only Retreat battles or for all battles in general? 0 Quote Link to comment Share on other sites More sharing options...
Robert Olesen Posted December 19, 2004 Author Share Posted December 19, 2004 All battles. Retreat battles are more likely to get there as you get a modifier in those, and te consequences are more severe, but the problem is annoying in all cases. 0 Quote Link to comment Share on other sites More sharing options...
SgtCheese Posted December 20, 2004 Share Posted December 20, 2004 Hi Rob, Is this usable in Open Office? 0 Quote Link to comment Share on other sites More sharing options...
Robert Olesen Posted December 20, 2004 Author Share Posted December 20, 2004 Originally posted by SgtCheese: Hi Rob, Is this usable in Open Office? No, not really. Open Office uses Java(Script?) and MS Office uses Visual Basic. You can open the spreadsheet in Open Office, but the macros won't work. This really should have been programmed in a separate utility, portable btw. Mac and Windows, but it just didn't work out that way. I guess you could use Open Office and do the math yourself. Probably works better than the pen and paper version. 0 Quote Link to comment Share on other sites More sharing options...
SgtCheese Posted December 20, 2004 Share Posted December 20, 2004 Well, I got excel and I ran my first battle with it. Very cool. 0 Quote Link to comment Share on other sites More sharing options...
TigerTiger Posted December 24, 2004 Share Posted December 24, 2004 This is good stuff. I don't have excel but have seen his AARs in the MZO forums. You guys gotta chk it out! Hai RobO! Merry Christmas everyone! 0 Quote Link to comment Share on other sites More sharing options...
Robert Olesen Posted December 25, 2004 Author Share Posted December 25, 2004 Thanks, and a merry Xmas to everyone too, if a bit late. I am, btw. turning 50 tomorrow 0 Quote Link to comment Share on other sites More sharing options...
TigerTiger Posted December 25, 2004 Share Posted December 25, 2004 Happy birthday Robo! You must be getting a lot of gifts this weekend! 0 Quote Link to comment Share on other sites More sharing options...
Robert Olesen Posted December 31, 2004 Author Share Posted December 31, 2004 Version 2.22 is now on the street. I recommend an update if you're using ROQC for CMBB. Here's the changelist: Force factor for assault corrected to 1.72 from 1.7 (see 4.3.2). Very low ammunition loads adjusted upwards to decrease the risk of a premature automatic ceasefire, see 4.3.9. Error corrections in spreadsheet: - Cell K59 of the Tables1 sheet should contain the value -1, not –2. - Autoceasefire tickbox for Raid battles in Favor sheet caused a cell protection error. - Commendation values are now cleared from the Core Force sheet when the next battle is generated. - Map sheet did not properly recognize ME battles when comparing maps with the battle parameters. - History sheet opinion of superior commander (column BP) corrected slightly in cases of negative Favor. 0 Quote Link to comment Share on other sites More sharing options...
Ardem Posted January 1, 2005 Share Posted January 1, 2005 hey mate, How do you incorporate this into a existing spreadsheet. If I copy across the coresheet and the history sheet in value form would this do it? 0 Quote Link to comment Share on other sites More sharing options...
Robert Olesen Posted January 1, 2005 Author Share Posted January 1, 2005 Originally posted by Ardem: hey mate, How do you incorporate this into a existing spreadsheet. If I copy across the coresheet and the history sheet in value form would this do it? Basically, yes. But I guess you've already figured that out. You need to transfer all the values you entered yourself (in white cells) and all die rolls (orange cells) - note that some of these are in the core force sheet at the right. 0 Quote Link to comment Share on other sites More sharing options...
Yskonyn Posted January 7, 2005 Share Posted January 7, 2005 RobO, again congrats on a continued job well done! I am reading through all the extensive homework your provided us with (a.k.a. the rules) and I am very eager to start my first battle. On problem however; when I try to press the Die-macro buttons in Word, it gives me an error telling me that either the macro is not found or due to security reasons it could not be activated. When I press help it tells me that I probably choose not to activate the macro when I opened the document, but I never got a question asking me! Do you know what's wrong? 0 Quote Link to comment Share on other sites More sharing options...
Robert Olesen Posted January 8, 2005 Author Share Posted January 8, 2005 Yskonyn, you need to change the macro security settings in MS Word (and Excel if you have that). It should be somewhere in the Tools > Macros menu. The location can vary with the version of Word. There are three settings: - High will automatically disable most macros - Medium will ask you if you want macros enabled - Low will automatically enable macros. You probably have the High setting and most likely want to use the Medium. It's the same in Excel but I'm not sure if it shares the settign with Word. I checked the die rolls in the rules for v2.22. They work for me. 0 Quote Link to comment Share on other sites More sharing options...
Yskonyn Posted January 8, 2005 Share Posted January 8, 2005 Ok, thanks. At least now I know where to take a look! 0 Quote Link to comment Share on other sites More sharing options...
nathangun Posted July 1, 2020 Share Posted July 1, 2020 (edited) I have found memories playing this way back when. Does anyone still have the rules and other stuff? EDIT: Ah found them! http://cmx1mods.greenasjade.net/mods/search?search=ROQC&commit=Search Edited July 1, 2020 by nathangun 0 Quote Link to comment Share on other sites More sharing options...
Recommended Posts
Join the conversation
You can post now and register later. If you have an account, sign in now to post with your account.