Ithikial_AU Posted April 30, 2016 Author Share Posted April 30, 2016 And I think I've PDF'd and uploaded the wrong version of the read me. That'll teach me for finishing this off while I'm flat out at work and other RL matters. Link below should be with correct Read Me. @IanL - Try copying and pasting over following the instructions in this read me. http://cmmodsiii.greenasjade.net/?p=3847 Apologies. 0 Quote Link to comment Share on other sites More sharing options...
A Canadian Cat Posted April 30, 2016 Share Posted April 30, 2016 Thanks @Ithikial_AU, I'll try that. 0 Quote Link to comment Share on other sites More sharing options...
A Canadian Cat Posted May 1, 2016 Share Posted May 1, 2016 Yes, the paste values was the ticket. Face palm of my own since I am not really an Excel novice - though clearly not as well versed as you. After doing that things went more smoothly. But not perfect... In the instructions you say: "I’m a loyal customer! How do I copy over data from a previous version? 1. Open a copy of both the old version (with existing game results) and the blank new version in Microsoft Excel. 2. On the older version with your existing data, click and drag to select all the rows holding your recorded games until ‘Column Z’ (Allied Other Vehicles Destroyed)." Step 2 goes to far and would stomp on some of those italic columns. You can go as far as Column V "Allied MIA" in one pass and then do the other green section and the two red sections each separately. It also did not help my "Casualties Caused by Country" graph. The top two are dataless while the bottom two have data: I PM'ed you a link to my excel file so you can have a look if you like. 0 Quote Link to comment Share on other sites More sharing options...
Ithikial_AU Posted May 2, 2016 Author Share Posted May 2, 2016 Grrrr.... yes I'll take look when I get home. Anyone else hit this stumbling block? 0 Quote Link to comment Share on other sites More sharing options...
Ithikial_AU Posted May 2, 2016 Author Share Posted May 2, 2016 Found the bug plaguing @IanL. All fixed but everybody will have it. CMMODS has just been updated (again) with the new file. Apologies. 1 Quote Link to comment Share on other sites More sharing options...
A Canadian Cat Posted May 2, 2016 Share Posted May 2, 2016 Thanks! 0 Quote Link to comment Share on other sites More sharing options...
AlessandroW Posted October 10, 2019 Share Posted October 10, 2019 I just started my CM career, amazing file! Thanks! 2 Quote Link to comment Share on other sites More sharing options...
Ithikial_AU Posted October 11, 2019 Author Share Posted October 11, 2019 Update planned for post R2V release. 2 Quote Link to comment Share on other sites More sharing options...
Bulletpoint Posted October 11, 2019 Share Posted October 11, 2019 On 4/13/2016 at 3:17 PM, Ithikial_AU said: I've always thought there was a good correlation between wargamers also being data nerds. You're very likely correct I have my own file where I note some basic details about the games I play, but nothing like your spreadsheet. I doubt I play enough games to really make the statistics features really fly, but will try it out. Thanks for sharing. 0 Quote Link to comment Share on other sites More sharing options...
Malaspina Posted February 1, 2021 Share Posted February 1, 2021 Hi! I've just started using this. Looks cool. How do I update the cells for "Real World Date"? The default options go from January 2011 to December 2020. How can I change that from, say, from January 2021 to December 2064? Thanks! 0 Quote Link to comment Share on other sites More sharing options...
A Canadian Cat Posted February 14, 2021 Share Posted February 14, 2021 On 2/1/2021 at 10:28 AM, Malaspina said: Hi! I've just started using this. Looks cool. It is totally cool! On 2/1/2021 at 10:28 AM, Malaspina said: How do I update the cells for "Real World Date"? The default options go from January 2011 to December 2020. How can I change that from, say, from January 2021 to December 2064? Sorry this took me so long to get to. You probably don't want to do all the work to get to 2064 right now :-). Here is what you do: Open the spread sheet to the "DO NOT TOUCH" tab - yeah we are touch'n it - sorry @Ithikial_AU 1) Enter some new dates - I don't recommend getting too carried away but you do you :-): Open the "Name Manager" (on the Formulas tab): Pick the "Real_World_Date" entry and update the range to include your newly added dates: That should cover it. 0 Quote Link to comment Share on other sites More sharing options...
Ithikial_AU Posted February 14, 2021 Author Share Posted February 14, 2021 What he said. You may need to manually update the pivot tables as well to read the new dates. Excel can be a bit funny in that area. There is an update planned a little while from now that has the real world date extended to 2030. 0 Quote Link to comment Share on other sites More sharing options...
Malaspina Posted February 17, 2021 Share Posted February 17, 2021 Thanks! 0 Quote Link to comment Share on other sites More sharing options...
A Canadian Cat Posted February 17, 2021 Share Posted February 17, 2021 On 2/14/2021 at 6:58 PM, Ithikial_AU said: What he said. You may need to manually update the pivot tables as well to read the new dates. Excel can be a bit funny in that area. There is an update planned a little while from now that has the real world date extended to 2030. Ooo I didn't think of that. I'll just wait for the update and avoid digging into that aspect. 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.