Alamaze & Fall of Rome Forum
Excel Alamaze Map & Order Tracker - Printable Version

+- Alamaze & Fall of Rome Forum (https://kingdomsofarcania.net/forum)
+-- Forum: ALAMAZE (https://kingdomsofarcania.net/forum/forumdisplay.php?fid=11)
+--- Forum: Alamaze Rules and Resources (https://kingdomsofarcania.net/forum/forumdisplay.php?fid=22)
+--- Thread: Excel Alamaze Map & Order Tracker (/showthread.php?tid=9731)

Pages: 1 2


Excel Alamaze Map & Order Tracker - Thudargh - 02-27-2015

***UPDATE 2***
Bananas has graciously posted the spreadsheet to bintray, so you can download it yourself without needing to email me.  This is a much better solution!  Thanks Bananas!


Here's the link:
Excel Alamaze Map and Order Tracker v4.0

***END UPDATE 2***

***UPDATE***
So I spent really too much time this weekend working on an updated version of this spreadsheet that would play nice with bananas' TurnParser.  To do so, I coded a bunch of macros.  Unfortunately, the forum won't allow me to attach a macro-enabled spreadsheet.  (This is probably a good thing - macros can be viruses.)  So version 2.0 is available, but you will need to contact me directly so I can email it to you.  It actually comes with some instructions, which hopefully will make it easier to use.

My email is aswersh@comcast.net.  I'm leaving a non-macro-enabled version attached to this post.

Thudargh

***END UPDATE***

I saw in a recent post that there may be some interest in an Excel-based version of the Alamaze map.  I've actually developed such a map, along with a method of tracking my orders & resources by turn.  It's certainly not as nice looking as the PowerPoint map and I'm sure most of the instructions on how to use it are just in my head rather than written down, but I thought I would share it anyway.

Thudargh


RE: Excel Alamaze Map & Order Tracker - bananas - 02-27-2015

If it would help any, my turn parser outputs a CSV file. That is also the format of the saved days files from the GUI.


RE: Excel Alamaze Map & Order Tracker - Jumpingfist - 02-27-2015

I find it wierd of myself to embrace a text based game but then find the excel map just not sexy enough. In practicality the excel file is better than the other. There are no question is that a sea area or is that graphic a forest or swamp. Yet I am still drawn to the nice looking map that is harder to manipulate. If only I could install a background onto the excel spreadsheet like I can do in an email or ppt. Maybe someone knows a way to do this already?


RE: Excel Alamaze Map & Order Tracker - Thudargh - 02-27-2015

(02-27-2015, 01:36 PM)bananas Wrote: If it would help any, my turn parser outputs a CSV file. That is also the format of the saved days files from the GUI.

Hmm, I am going to need to check that out.  Maybe there's some synergy to be had.  Or I'll get addicted to your parser and abandon Excel forever!


RE: Excel Alamaze Map & Order Tracker - bananas - 02-27-2015

(02-27-2015, 05:32 PM)Thudargh Wrote:
(02-27-2015, 01:36 PM)bananas Wrote: If it would help any, my turn parser outputs a CSV file. That is also the format of the saved days files from the GUI.

Hmm, I am going to need to check that out.  Maybe there's some synergy to be had.  Or I'll get addicted to your parser and abandon Excel forever!

For example, here is just the population center data output from the parser when run against a pdf turn results file.

Turn,Record Type,Data Source,Map Location,Kingdom,Name,Region,Type,Defense,Census,Food,Gold,Other

0,P,Self,JC,AN,COPPER PLATEAU,4,TOWN,15047,38920,2940,12236,NA

0,P,Self,MN,AN,NIMBUS SIGN,5,VILL,2604,19350,9163,2640,NA

0,P,Self,TA,AN,CORAL ISLAND,4,VILL,3259,19350,8855,3240,NA

0,P,Self,US,AN,BRAXTON,8,TOWN,8640,31080,803,3344,NA

It also parses out emissaries, groups, artifacts, and regional reactions. I left them off to keep the post short.

Prior to writing the GUI, all I had was the parser. I was kind of hoping that an Excel Guru would be able to use that data in some fantastic way.  If you need specific data in a special format, let me know and I'll see what I can do.


RE: Excel Alamaze Map & Order Tracker - Thudargh - 02-27-2015

(02-27-2015, 03:10 PM)Jumpingfist Wrote: I find it wierd of myself to embrace a text based game but then find the excel map just not sexy enough.  In practicality the excel file is better than the other.  There are no question is that a sea area or is that graphic a forest or swamp.  Yet I am still drawn to the nice looking map that is harder to manipulate.  If only I could install a background onto the excel spreadsheet like I can do in an email or ppt.  Maybe someone knows a way to do this already?

I have to agree - it's much better with the main map as the background.  I have updated the attachment in the first post of this thread to version 1.1 with two map sheets, one with the official Alamaze map and one with my practical, but less than inspiring one.  The Alamaze Map sheet can't be re-scaled or the background won't match the cells.  It took some experimentation to get things to match up decently well.  Hopefully opening it on different computers doesn't screw anything up - I've never built something for a wide audience before. 


RE: Excel Alamaze Map & Order Tracker - Thudargh - 02-27-2015

(02-27-2015, 05:58 PM)bananas Wrote:
(02-27-2015, 05:32 PM)Thudargh Wrote:
(02-27-2015, 01:36 PM)bananas Wrote: If it would help any, my turn parser outputs a CSV file. That is also the format of the saved days files from the GUI.

Hmm, I am going to need to check that out.  Maybe there's some synergy to be had.  Or I'll get addicted to your parser and abandon Excel forever!

For example, here is just the population center data output from the parser when run against a pdf turn results file.

Turn,Record Type,Data Source,Map Location,Kingdom,Name,Region,Type,Defense,Census,Food,Gold,Other

0,P,Self,JC,AN,COPPER PLATEAU,4,TOWN,15047,38920,2940,12236,NA

0,P,Self,MN,AN,NIMBUS SIGN,5,VILL,2604,19350,9163,2640,NA

0,P,Self,TA,AN,CORAL ISLAND,4,VILL,3259,19350,8855,3240,NA

0,P,Self,US,AN,BRAXTON,8,TOWN,8640,31080,803,3344,NA

It also parses out emissaries, groups, artifacts, and regional reactions. I left them off to keep the post short.

Prior to writing the GUI, all I had was the parser. I was kind of hoping that an Excel Guru would be able to use that data in some fantastic way.  If you need specific data in a special format, let me know and I'll see what I can do.

This type of output should be quite easy for Excel to work with.  Looks like I have a project for this weekend!


RE: Excel Alamaze Map & Order Tracker - bananas - 02-27-2015

(02-27-2015, 09:30 PM)Thudargh Wrote:
(02-27-2015, 05:58 PM)bananas Wrote:
(02-27-2015, 05:32 PM)Thudargh Wrote:
(02-27-2015, 01:36 PM)bananas Wrote: If it would help any, my turn parser outputs a CSV file. That is also the format of the saved days files from the GUI.

Hmm, I am going to need to check that out.  Maybe there's some synergy to be had.  Or I'll get addicted to your parser and abandon Excel forever!

For example, here is just the population center data output from the parser when run against a pdf turn results file.

Turn,Record Type,Data Source,Map Location,Kingdom,Name,Region,Type,Defense,Census,Food,Gold,Other

0,P,Self,JC,AN,COPPER PLATEAU,4,TOWN,15047,38920,2940,12236,NA

0,P,Self,MN,AN,NIMBUS SIGN,5,VILL,2604,19350,9163,2640,NA

0,P,Self,TA,AN,CORAL ISLAND,4,VILL,3259,19350,8855,3240,NA

0,P,Self,US,AN,BRAXTON,8,TOWN,8640,31080,803,3344,NA

It also parses out emissaries, groups, artifacts, and regional reactions. I left them off to keep the post short.

Prior to writing the GUI, all I had was the parser. I was kind of hoping that an Excel Guru would be able to use that data in some fantastic way.  If you need specific data in a special format, let me know and I'll see what I can do.

This type of output should be quite easy for Excel to work with.  Looks like I have a project for this weekend!

I built you a version of the command line parser. Just download it and run it from a dos shell, giving it the name of a pdf file to process as its only argument. 
parseTurn-1.1.2.exe

For example:
C:\users\thudargh\downloads> parseTurn-1.1.2.exe AN157R0.PDF


RE: Excel Alamaze Map & Order Tracker - Thudargh - 03-01-2015

Version 2.0 is now available, but can't be posted to the forum because it is macro-enabled. It can load in the DAT save files from the TurnParser, or be used independently. I've included some written instructions. I'm not sure it adds much if anything beyond what the TurnParser does, but if you like Excel spreadsheets, here you go! Besides, it was fun to develop.

For anyone interested in getting it, please email me at aswersh@comcast.net.

Thudargh


RE: Excel Alamaze Map & Order Tracker - bananas - 03-02-2015

Thudargh agreed that I could post the spreadsheet to bintray so that y'all would have a place to download it from. 

Excel Alamaze Map and Order Tracker v2.0