World War Spreadsheet v5.5 ** 7/20/2010 Update ** - Page 11

mangan · #**201** 07-01-2010, 07:59 PM

Just want to say thanks for supplying a great worksheet. One bug I found though, when I save it to my desktop, there seems to be a problem opening it again due to a macro problem. I'm able to correct it by saving it without macros, but that's one of the great things about your spreadsheet, saves constant updating. Not trying to complain, just pointing out a bug I found. Thanks again.

Supervolcano · #**202** 07-02-2010, 02:47 AM

Quote:

Originally Posted by mangan

Just want to say thanks for supplying a great worksheet. One bug I found though, when I save it to my desktop, there seems to be a problem opening it again due to a macro problem. I'm able to correct it by saving it without macros, but that's one of the great things about your spreadsheet, saves constant updating. Not trying to complain, just pointing out a bug I found. Thanks again.

Can you quote the exact error message it displays to you?

What program are you using to open the file?

nouse4aname16 · #**203** 07-02-2010, 09:53 PM

When I download the new updated spreadsheet, the buildings tab is in disarray. I don't know if it's just me.

Supervolcano · #**204** 07-02-2010, 10:00 PM

Quote:

Originally Posted by nouse4aname16

When I download the new updated spreadsheet, the buildings tab is in disarray. I don't know if it's just me.

Are you using Microsoft Excel?

mangan · #**205** 07-03-2010, 08:33 AM

I am using the new version of Excel.

I attached a couple of screenshots.

KOUSA · #**206** 07-03-2010, 10:21 AM

Is anybody else having trouble with the battle section of the new spreadsheet? It populates with my data only and nothing for the opponent. After entering all data mine still says "Enter Opponent Data for Analysis". Any help would be much appreciated and thank you to SKT168 and Supervolcano for such a great spreadsheet and all the work you put into it.

KOUSA · #**207** 07-03-2010, 10:29 AM

Also is there a way to copy or save all the data from the previous version 5.0 into the updated version 5.1 without having to re-enter it all each time? I have almost 40 sheets saved as I create one for each major opponent and it would awesome if someone has a shortcut so I dont have to enter all the data again. Thanks.

Supervolcano · #**208** 07-04-2010, 11:44 AM

Quote:

Originally Posted by KOUSA

Also is there a way to copy or save all the data from the previous version 5.0 into the updated version 5.1 without having to re-enter it all each time? I have almost 40 sheets saved as I create one for each major opponent and it would awesome if someone has a shortcut so I dont have to enter all the data again. Thanks.

No, all of the unit columns were changed obviously.

Supervolcano · #**209** 07-04-2010, 11:55 AM

Quote:

Originally Posted by nouse4aname16

When I download the new updated spreadsheet, the buildings tab is in disarray. I don't know if it's just me.

Quote:

Originally Posted by mangan

I am using the new version of Excel.

I attached a couple of screenshots.

Quote:

Originally Posted by KOUSA

Is anybody else having trouble with the battle section of the new spreadsheet? It populates with my data only and nothing for the opponent. After entering all data mine still says "Enter Opponent Data for Analysis". Any help would be much appreciated and thank you to SKT168 and Supervolcano for such a great spreadsheet and all the work you put into it.

I have attached the spreadsheet in Excel 2007 (xlsm) format.

Can all 3 of you please try this version.

1) Tell me if it fixes your current problems.
2) Tell me exactly what version of which program you using to open the fie.

KOUSA · #**210** 07-04-2010, 12:07 PM

Thanks bro but I can't open the file. I have Excel 2002.

Supervolcano · #**211** 07-04-2010, 12:15 PM

Quote:

Originally Posted by KOUSA

Thanks bro but I can't open the file. I have Excel 2002.

Yes, you need to stick with the original files I have in post #1.

The xlsm file I just posted is only going to work in Excel 2007 or maybe Excel 2010.

As for your particular problem, I have no idea what you are doing wrong.
Post a screenshot of your dashboard.

MauledMariner · #**212** 07-04-2010, 07:02 PM

I'm on level 103 and the spreadseet is saying that the Albion Landing Dock is my optimum "Best total points unit" to purchase. The dilemma is that it's not available until Level 106. Is there a simple fix for this. I double checked to make sure that I had entered in my correct level on the Dashboard.

Lastly, the spreadsheet is AWESOME! Good Job! (& thanks!)

EJ258 · #**213** 07-04-2010, 07:06 PM

Kanimbla AT Ship is available sooner than level 93, I have it unlocked by level 92. Also my next naval unit to be unlock is the Houbei Missile Ship at level 97, not 98.

Supervolcano · #**214** 07-04-2010, 07:10 PM

Quote:

Originally Posted by MauledMariner

I'm on level 103 and the spreadseet is saying that the Albion Landing Dock is my optimum "Best total points unit" to purchase. The dilemma is that it's not available until Level 106. Is there a simple fix for this. I double checked to make sure that I had entered in my correct level on the Dashboard.

Lastly, the spreadsheet is AWESOME! Good Job! (& thanks!)

The levels which are blue on the dashboard and the units tab were guesses by me because I didn't want to hold off on releasing the file until I aquired them.

Just change the level number for that unit on the UNITS tab.

The optimizer tab will then fix itself.

MauledMariner · #**215** 07-04-2010, 07:12 PM

Seriously. You are awesome!

Supervolcano · #**216** 07-04-2010, 07:22 PM

If anyone else can verify at what level the following units unlock, I'd appreciate it:

Ground:
MIM-72 Charparral
G6 Howitzer
2S19 Msta
Astros-II MLRS

Water:
Mukha Antisubmarine Ship
Type 23 Frigate

Air:
F-14 Tomcat
Bird of Prey Stealth Jet

Please do not just copy values quoted by some forum, website, or spreadsheet.
I want values seen with your own eyes in your game.

gregg79 · #**217** 07-05-2010, 05:26 AM

MIM-72 Charparral unlocks at level 94.

nouse4aname16 · #**218** 07-05-2010, 04:39 PM

I downloaded the file you provided, I see the Buildings tab and every thing looks in order.

Thanks again.

Supervolcano · #**219** 07-05-2010, 04:58 PM

Quote:

Originally Posted by nouse4aname16

I downloaded the file you provided, I see the Buildings tab and every thing looks in order.

Thanks again.

You didn't answer my questions.

What program (and version of it) are you using to open the spreadsheet?

mangan · #**220** 07-05-2010, 05:03 PM

Quote:

Originally Posted by Supervolcano

I have attached the spreadsheet in Excel 2007 (xlsm) format.

Can all 3 of you please try this version.

1) Tell me if it fixes your current problems.
2) Tell me exactly what version of which program you using to open the fie.

I'm using 2007, still didn't fix it, but obviously I can live with it, especially since it's free!

Thanks anyways, nice of you to do the work & offer it freely like this.