Utility: MapStat

[kingjoshi]

Hey IDSmoker,

I like your macro excel file. The totals are easier to view and the percentage are a nice touch. However, I think the original file is easier to sort through. Before, all one has to do is click on the cell "City", "Waste" or whatever, and then the sort button, Ascending or Descending. Whichever you prefer. however, with the macro you created, I don't know if the data will be sorted Ascending or Descending. I read through the code but was too tired to make sense of it. It seems you just tried to alternate every time a button is clicked, am I right? However, I can't seem to make out the order by which it goes.

Lovro,

I emailed ChiefPaco for the source for the program, but since you do the windows version, I guess I should ask you too. I remember the earlier Java version being GPLed, but I'm not sure about the Windows version.

I too would like to add more data for the city export. But I'd like to see the source and all the great info from the .sav file too if possible
If you'd like to share it , you can email me at kiran@joshi.com. thanks.

 

[IDSmoker]

Glad you like the spreadsheet kingjoshi!

Originally posted by kingjoshi
...however, with the macro you created, I don't know if the data will be sorted Ascending or Descending. ... It seems you just tried to alternate every time a button is clicked, am I right?...

Yes, the sort order will alternate every time you click the header button for the column you want to sort by. The first time you click it, I think it will sort descending for all columns except for "City Name" which made more sense to sort ascending (the first time).

The sort buttons were sorta of a compromise... I wanted to make it easy for the people who might be new to Excel (and not know about using the toolbar).

Let me know if you (or anyone else for that manner) can think of other things the spreadsheet should do.

 

[kingjoshi]

Well, with Lovro's help, I am now able to decompress the .SAV file and going through ChiefPaco's source, I was able to find the city data he has. I also found a couple of other data but I am waiting for Gramphos' reply (I emailed him today) about the file format so hopefully, I can extract much more information. After Friday, I assume the format will change a little again and then we'll see. So, after I extract all the info I want, then I'll need you to organize it well

 

[royfurr]

Hi chiefpaco,

I see you edited the start of the thread (1st post) in August but that the end of the thread has the last post as sometimes in July I think. So what?? Aug is post 1.29 and July is (kinda) pre 1.29?

Here's my question: has mapstat windows ver. 3.0 been upgraded (or is already compatable???) with the new Civ3 patch (1.29)? Or does it only work in up to the 1.21 patch.

Thanks, I'd like to try the program out but I just started running 1.29, so I'm unsure if it will work properly.

Thanks again.

 

[chiefpaco]

I think it should still be compatible. I'm not aware of any changes to the .sav format in 1.29 that would stop it from working.

 

[Cartouche Bee]

That cuts it! If Lovro doesn't get PTW this won't get updated. I'm not going back to counting tiles by hand, unless there is a utility like this for PTW, it is a no buy even when they fix MP.

 

[Bamspeedy]

Or maybe you'll have to stop milking games like you said you would a long time ago

Yes, mapstat (and probably Apollo) is not compatible with PTW until there is an update. If you try using mapstat with PTW you get outrageous numbers (like 4,440,000 tiles of grassland for example).

 

[chiefpaco]

Obviously, Lovro isn't getting enough income from Mapstat to cover the costs of PTW! And I'm not getting enough royalties to buy PTW either. Time to make it shareware! jk. I'd encourage and help anyone if they want to pick up the project but the nice version is really in Lovro's hands.

 

[Grey Fox]

Couldn't you just make it Open Source?

 

[Cartouche Bee]

chiefpaco, I fondly remember those first few versions of mapstat. If they would have been compatible with PTW I'm sure they would be on the PTW disk like alot of the other stuff that was "picked up".

Bamspeedy, my last 2 GOTM were not milked, one was lost by our famous leader Matrix, but I'm back on the milk wagon because I find a quick conquest or domination shallow now that I know what all is required to do a good milking.

Oh well, makes my decision much easier as we wait for real MP.

 

[kring]

I would like to see a PtW version as well.

 

[ezdraft]

Is there any other utility like this for ptw? I have ptw and cant fingure out if i have a chance for domination victory, how can you tell if you have 2/3 of the world and population?

 

[Padma]

In other words, CP, someone needs to pick up the existing java code and take it again from there, in order to make this PTW compatible?

 

[Aeson]

Because the GOTM will be switching over to PtW (still offering 'equivalent' 1.29f versions to play), there is a need for a PtW Mapstat utility. The Scoring utility I'm working on shouldn't be difficult to switch over to a Mapstat-like program. Would that be alright with you Chiefpaco (and Lovro)?

Here's the Scoring calc as it now stands. It gives a little of the map information (terrain counts, domination limit for the map, total food including resources and counted off base terrain) already, but doesn't deal with claimed tiles at all. It 'works' with PtW 1.14f, Civ 1.29f, 1.21f, 1.17f, and 1.16f saves, and 1.29f bic files. Not sure about any other versions.

Some things just plain don't work yet though (landform comes to mind).

EDIT: Seems I had the wrong file linked, doesn't look like it's applicable now anyways. Thanks Lovro!

 

[Lovro]

Hello.

An alpha version of Mapstat for PTW is ready.

I need a few chaps with some time on their hands to thoroughly test it for me and help me finish it in the coming week. I haven't dealt with BICs yet, only SAVs.

Please PM me if you're interested, and I'll get back to you with instructions.

 

[LKendter]

[dance] [dance]
PTW Mapstat is one the way.

I would help, but I am already max commited between 4 succession games, part time work, and gameing outside of civ.

 

[kring]

I PMed you; I have plenty of time in the late evening/early morning.

 

[bobah083]

is MapStat exist for PtW saves?
its kinda great tool!

 

[bobah083]

Sorry for previous post (i read only first page of a thread)

 

[cnburden]

Nice work on the app ChiefPace and Lavro!! My favorite Civ mod.

Also thanks to IDSmoker for the Excel macro.


You guys still making updates to the app? I have a small wishlist of things I'd like to see. I like to micro-manage my cities and one of the things I've noticed is the cities that need the most work are ones that have grown in size or produced a unit/building.

Anyway, what I'd be interested in seeing:

1. Number of Happy/Content/Unhappy/Specialists in each city. On the F1 screen, I can't tell by looking at the faces which city might fall into disorder the next turn, so adding that to the output would make it a lot easier to see.

2. What the city is currently working on, how many shields they've put into it and estimated time left to complete.

3. Number of extra food in the stockpile (you already have the surplus per turn) and also estimate turns till growth.

4. Currently, I alt-tab from Civ to the app, Click on File-Open Newest (love that feature), then click on File-Export. Is there a way to streamline this with maybe one/two buttons on the interface? Could also add a buttons for several of the other features (recalc, view terraign, view percentages, etc).

5. I also liked the idea of listing all the buildings that currently exist in the city, but like has been said, this would make the export a little large. Maybe a second export file? I'll have to think on this one a bit.


From all that, I could make the necessary updates to the Excel macro's to compare the two most recent SAV files to find out which cities have grown in size and/or produced something.


Now if y'all aren't making updates, is it possible to get a copy of the windows source code? I've not worked with Java, but have done a lot with VB and some with C++. Not familiar with opening a binary file (.SAV) and parsing that data, but once I got past that, I could add these features myself. Now if I have to, I guess I'll just have to go learn Java (which probably is a good idea in the long run anyway).

Thanks much,
Craig
cburden@yahoo.com