02-27-2015, 05:16 PM (This post was last modified: 05-03-2015, 10:24 PM by Thudargh.)
***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!
***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.
02-27-2015, 07:10 PM (This post was last modified: 02-27-2015, 07:10 PM by Jumpingfist.)
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?
(02-27-2015, 05: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!
(02-27-2015, 05: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.
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.
bananas (on the forums) Arch-Mage of Entropy (in games) - Wanderer of Alamaze
Player nominated - 157 - TR : Chancellor 161 - AN : Chancellor & Iron Willed
(02-27-2015, 07: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.
(02-27-2015, 05: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.
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!
(02-27-2015, 05: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.
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
bananas (on the forums) Arch-Mage of Entropy (in games) - Wanderer of Alamaze
Player nominated - 157 - TR : Chancellor 161 - AN : Chancellor & Iron Willed
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.
