AutoMagic UPDATE

mepbmlist
#21

Actually, I misspoke (or miswrote). The Reset button will reset the
orders version number to the previous one, so if you submit #4 and hit
the reset, it will reset your next orders send to #4.

There is normally no reason to use this, as the orders version number is
reset to #1 whenever you import your XML file. I use the reset for when
I've hit the send button (but before I actually send the E-Mail), and I
realize I need to change something. If I've already sent the E-Mail out,
then I go ahead and let AutoMagic up the orders version number, since
that's the purpose of using version numbers.

The reset also works for what Drew talked about, if you just want to
output an orders file to check it.

Mike

From: mepbmlist@yahoogroups.com [mailto:mepbmlist@yahoogroups.com] On
Behalf Of ME Games Ltd
Sent: Wednesday, September 28, 2005 3:59 PM
To: mepbmlist@yahoogroups.com
Subject: RE: [mepbmlist] AutoMagic UPDATE

Be very careful doing this. We use the latest version number for turns

so

if you send us version 3 and then version 1 (having reset what would

have

···

-----Original Message-----
been version 4) then we'll process version 3.

Clint

Drew,

Actually, in the latest revision, there is a RESET button on the SEND
sheet (near the bottom) that resets the orders version number to 1.

#22

I had never noticed that reset button. But then again, I don't normally upgrade AM versions midgame, and upon looking, I am using Revision 2005a.2 in one game, 2004a.3 in another, and until a week or so ago, 2003e.3 in another (turn 70 something). No reset buttons on the last two.

I downloaded the most recent version from your website for one of the postions I play in that last game because I was getting multiple copies of characters imported, with some omitted. The newest AM version imported the XML data just fine, so I didn't worry about it (nor the other postion, since it didn't have an import problem). I *am* getting ###'s in the EconoCalc columns, but I'm not advocating you increase the column widths to accomodate a seven figure display; how often do you run across that anyway? <g>

Drew

Actually, I misspoke (or miswrote). The Reset button will reset the
orders version number to the previous one, so if you submit #4 and hit
the reset, it will reset your next orders send to #4.

There is normally no reason to use this, as the orders version number is
reset to #1 whenever you import your XML file. I use the reset for when
I've hit the send button (but before I actually send the E-Mail), and I
realize I need to change something. If I've already sent the E-Mail out,
then I go ahead and let AutoMagic up the orders version number, since
that's the purpose of using version numbers.

The reset also works for what Drew talked about, if you just want to
output an orders file to check it.

Mike

From: mepbmlist@yahoogroups.com [mailto:mepbmlist@yahoogroups.com] On
Behalf Of ME Games Ltd
Sent: Wednesday, September 28, 2005 3:59 PM
To: mepbmlist@yahoogroups.com
Subject: RE: [mepbmlist] AutoMagic UPDATE

Be very careful doing this. We use the latest version number for turns

so

if you send us version 3 and then version 1 (having reset what would

have

been version 4) then we'll process version 3.

Clint

Drew,

Actually, in the latest revision, there is a RESET button on the SEND
sheet (near the bottom) that resets the orders version number to 1.

Middle Earth PBM - hit reply to send to everyone
To Unsubscribe: http://www.yahoogroups.com
Website: http://www.MiddleEarthGames.com

SPONSORED LINKS
Computer role playing game Online role playing games Role playing games online Massive multiplayer online role playing games Star wars role playing game Wheel of time role playing game

···

Urzahil <urzahil@darkfortress.us> wrote:

-----Original Message-----

---------------------------------
YAHOO! GROUPS LINKS

    Visit your group "mepbmlist" on the web.
  
    To unsubscribe from this group, send an email to:
mepbmlist-unsubscribe@yahoogroups.com
  
    Your use of Yahoo! Groups is subject to the Yahoo! Terms of Service.

---------------------------------

---------------------------------
Yahoo! for Good
Click here to donate to the Hurricane Katrina relief effort.

[Non-text portions of this message have been removed]

#23

Hi Mike,
I did a little more research, found your replace formulas, and discovered
that the reason they don't work for me is my windows regional settings
(Control Panel -> Regional and Language Options), which are set to Greek
(I'm Greek). I changed my regional settings to English US and all character
names were imported just fine.
Apparently there may be a problem with the replace formulas for every non
English UK regional setting.
The reason behind all this is that Workbook.Open which is used in ImportMac
will open the XML file in Windows-ANSI encoding (which is dependent on the
regional settings) - to preserve the accented characters the XML file should
be opened in Unicode. As far as I know, there is no way to open a file from
VBA in excel in Unicode encoding (except maybe in Excel 2003, using the
Workbook.ReloadAs method).
The easiest solution at this point may be to extend the replace formulas
for other regional settings, based on player demand. I have 8 Greeks in my
team so I'd be happy to do the work for Greek regional settings.
Alternatively, you could add a sheet with two columns, where the player can
add name substitutions. Eg. since Eoder was being imported as Éoder for me,
I could go into that sheet and specify that Éoder should be replaced with
Eoder. Then Automagic could do the replacement for me in the Orders sheet.
The advantage of this is that the player need only specify these
substitutions once per game.
I'm not pasting my VBA code because according to the above it doesn't
provide a better solution than your replace formulas. It was doing the same
exact thing, only because of my regional settings I was replacing different
characters (eg instead of É, I was replacing Γ‰, etc). Besides, I had only
done it for 'Eoder and B'eawyn as I wanted a quick and dirty solution for my
current game :slight_smile:
Let me know if you still want to see the code or if you want some help in
extending the replace formulas or what not.
Regards,
Marios

···

On 9/28/05, Urzahil <urzahil@darkfortress.us> wrote:

Marios,

I thought I had dealt with this issue, but apparently I wasn't thorough
enough.

Currently I'm using formulas to replace these strange characters with
their proper ones. When Excel imports files, it replaces accented
characters with those strange, double-character symbols you've seen, and
the only way I knew of to get rid of them was by using formulas. If
you've got some VB code that works, I'd appreciate seeing a copy of what
you did.

Thanks,
Mike

>-----Original Message-----
>From: mepbmlist@yahoogroups.com [mailto:mepbmlist@yahoogroups.com] On
>Behalf Of Marios Skounakis
>Sent: Wednesday, September 28, 2005 2:57 AM
>To: mepbmlist@yahoogroups.com
>Subject: Re: [mepbmlist] AutoMagic UPDATE
>
>Hi Mike,
>
>I've had some problems importing character names with accents (e.g.
>Eoder, with an accent on E, Beawyn with an accent on e, etc). The
>names were not being imported correctly in fact the accented letters
>were being translated into two non-standard ascii characters. Maybe it
>has to do with my excel installation and charset settings, I'm not
>sure.
>
>Anyway, I tinkered with your code and edited Sub Import() to replace
>the accented letters with their non-accented equivalents.
>
>Just figured I'd bring this up in case others have had the same
>problem. It can be kinda annoying to have to edit the character names
>every time you import your XML file.
>
>By the way, I'm running WinXP and Excel 2000, if you think that might
>play a role.
>
>Marios

Middle Earth PBM - hit reply to send to everyone
To Unsubscribe: http://www.yahoogroups.com
Website: http://www.MiddleEarthGames.com/>

SPONSORED LINKS
  Computer role playing game<http://groups.yahoo.com/gads?t=ms&k=Computer+role+playing+game&w1=Computer+role+playing+game&w2=Online+role+playing+games&w3=Role+playing+games+online&w4=Massive+multiplayer+online+role+playing+games&w5=Star+wars+role+playing+game&w6=Wheel+of+time+role+playing+game&c=6&s=215&.sig=h1jZ-ZUL5Ehm19049vreaw> Online
role playing games<http://groups.yahoo.com/gads?t=ms&k=Online+role+playing+games&w1=Computer+role+playing+game&w2=Online+role+playing+games&w3=Role+playing+games+online&w4=Massive+multiplayer+online+role+playing+games&w5=Star+wars+role+playing+game&w6=Wheel+of+time+role+playing+game&c=6&s=215&.sig=wBeToL-HQu_qYO0qpkjEpQ> Role
playing games online<http://groups.yahoo.com/gads?t=ms&k=Role+playing+games+online&w1=Computer+role+playing+game&w2=Online+role+playing+games&w3=Role+playing+games+online&w4=Massive+multiplayer+online+role+playing+games&w5=Star+wars+role+playing+game&w6=Wheel+of+time+role+playing+game&c=6&s=215&.sig=ARxZYOEOBRTS0-OW_qV4Lw> Massive
multiplayer online role playing games<http://groups.yahoo.com/gads?t=ms&k=Massive+multiplayer+online+role+playing+games&w1=Computer+role+playing+game&w2=Online+role+playing+games&w3=Role+playing+games+online&w4=Massive+multiplayer+online+role+playing+games&w5=Star+wars+role+playing+game&w6=Wheel+of+time+role+playing+game&c=6&s=215&.sig=A03Yq28zAJKxwrIAZZGufw> Star
wars role playing game<http://groups.yahoo.com/gads?t=ms&k=Star+wars+role+playing+game&w1=Computer+role+playing+game&w2=Online+role+playing+games&w3=Role+playing+games+online&w4=Massive+multiplayer+online+role+playing+games&w5=Star+wars+role+playing+game&w6=Wheel+of+time+role+playing+game&c=6&s=215&.sig=1NsLpHDWwP8CNx6lNLy8UQ> Wheel
of time role playing game<http://groups.yahoo.com/gads?t=ms&k=Wheel+of+time+role+playing+game&w1=Computer+role+playing+game&w2=Online+role+playing+games&w3=Role+playing+games+online&w4=Massive+multiplayer+online+role+playing+games&w5=Star+wars+role+playing+game&w6=Wheel+of+time+role+playing+game&c=6&s=215&.sig=bfTsNVh6YMWJBvMLif4HSA>
------------------------------
YAHOO! GROUPS LINKS

   - Visit your group "mepbmlist<http://groups.yahoo.com/group/mepbmlist>"
   on the web.
    - To unsubscribe from this group, send an email to:
   mepbmlist-unsubscribe@yahoogroups.com<mepbmlist-unsubscribe@yahoogroups.com?subject=Unsubscribe>
    - Your use of Yahoo! Groups is subject to the Yahoo! Terms of
   Service <http://docs.yahoo.com/info/terms/>.

------------------------------

[Non-text portions of this message have been removed]

#24

I think I speak on behalf of (almost) the entire MEPBM community when I
say THANK YOU VERY MUCH for your time, effort, and devotion to this
product. It has freed up the time of most MEPBM'ers to focus on
strategy and tactics, rather than order input and nation runnning
mechanics. Just wanted you to "feel some love." :slight_smile:

b

Urzahil wrote:

I'm working on some enhancements to the next revision of AutoMagic, (as
well as fixing minor bugs), and I'd like to get some input from the
players. First, a couple of items I'm currently working on.

1. EXCEL 2003 & XML ISSUES: Thanks to some vital info from Richard
Farrer, the next revision of AutoMagic won't have problems importing XML
files, even if you're using Excel 2003. (For those of you currently
using Excel 2003, you know that you now need to convert your XML file to
a TXT file before importing. With the new revision, you won't have to.)

2. AUTO-COSTING: Thanks to some equally vital info from Kyle Caruthers,
I may finally be able to have AutoMagic automatically update the orders
costs on the Economy sheet as you enter your orders on the Orders sheet.
(Even the variable cost orders!)

My plan was to have all the orders costs automatically update on the
Economy sheet except for the actual buys & sells. However, I've had a
request to have all the 310/315/325 orders on the Orders sheet also
update the Econo sheet automatically.

The way I figure it, if I have all 310/315/325 orders automatically
update the Econo sheet, then you'll have to go back and forth between
the sheets every time you update the Orders sheet if you want to tweak
your natsells. Personally, I think it's better the way it is, as I can
tinker with the buy/sells right on the Econo sheet to see how it turns
out, but I'd like some opinions from you guys.

Next...Do you guys have any issues with AutoMagic that you'd like to see
resolved? I can't promise that I can fix everything, but I'd like to
hear about any problems you've encountered.

Lastly, are there any ideas for how to make AutoMagic better? Once
again, no promises that I can make your requests happen, but I'm open to
suggestions.

Thanks,
Mike Mulka

Middle Earth PBM - hit reply to send to everyone
To Unsubscribe: http://www.yahoogroups.com
Website: http://www.MiddleEarthGames.com

Yahoo! Groups Links

[Non-text portions of this message have been removed]

#25

Well... OK... Now I'm embarrassed.

Thanks for the kudos, but it really just started out as something to
make MY MePBM life easier. (Plus I like tinkering with Excel and VB.)

Still, your appreciation is... appreciated. :wink:

Mike

···

-----Original Message-----
From: mepbmlist@yahoogroups.com [mailto:mepbmlist@yahoogroups.com] On
Behalf Of Benjamin M. Shushan
Sent: Thursday, September 29, 2005 10:29 AM
To: mepbmlist@yahoogroups.com
Subject: Re: [mepbmlist] AutoMagic UPDATE

I think I speak on behalf of (almost) the entire MEPBM community when I
say THANK YOU VERY MUCH for your time, effort, and devotion to this
product. It has freed up the time of most MEPBM'ers to focus on
strategy and tactics, rather than order input and nation runnning
mechanics. Just wanted you to "feel some love." :slight_smile:

b

#26

Actually, I can just set the cells to 'shrink to fit'. That way, it
won't normally be any different, but in those rare games where it's
needed, the cells will at least show the amount, albeit in a little
smaller font.

Thanks,
Mike

From: Drukarzun
Sent: Wednesday, September 28, 2005 5:20 PM
To: mepbmlist@yahoogroups.com
Subject: RE: [mepbmlist] AutoMagic UPDATE

I am getting ###'s in the
EconoCalc columns, but I'm not advocating you increase the column

widths to

accomodate a seven figure display; how often do you run across that

anyway?

···

-----Original Message-----
<g>

Drew

#27

Hi Mike

I've said it before, but I'll say it again, I'm very impressed with
automagic.

I just wonder if by making it too easy to do the orders we are losing an
important element of the game. I've always thought that working out my
finances and who can and can't do things was part of the enjoyment.

David

···

I'm working on some enhancements to the next revision of AutoMagic, (as
well as fixing minor bugs), and I'd like to get some input from the
players. First, a couple of items I'm currently working on.

1. EXCEL 2003 & XML ISSUES: Thanks to some vital info from Richard
Farrer, the next revision of AutoMagic won't have problems importing XML
files, even if you're using Excel 2003. (For those of you currently
using Excel 2003, you know that you now need to convert your XML file to
a TXT file before importing. With the new revision, you won't have to.)

2. AUTO-COSTING: Thanks to some equally vital info from Kyle Caruthers,
I may finally be able to have AutoMagic automatically update the orders
costs on the Economy sheet as you enter your orders on the Orders sheet.
(Even the variable cost orders!)

My plan was to have all the orders costs automatically update on the
Economy sheet except for the actual buys & sells. However, I've had a
request to have all the 310/315/325 orders on the Orders sheet also
update the Econo sheet automatically.

The way I figure it, if I have all 310/315/325 orders automatically
update the Econo sheet, then you'll have to go back and forth between
the sheets every time you update the Orders sheet if you want to tweak
your natsells. Personally, I think it's better the way it is, as I can
tinker with the buy/sells right on the Econo sheet to see how it turns
out, but I'd like some opinions from you guys.

Next...Do you guys have any issues with AutoMagic that you'd like to see
resolved? I can't promise that I can fix everything, but I'd like to
hear about any problems you've encountered.

Lastly, are there any ideas for how to make AutoMagic better? Once
again, no promises that I can make your requests happen, but I'm open to
suggestions.

Thanks,
Mike Mulka