RE: Submarine Reporter for Excel 2010 BETA (Full Version)

All Forums >> [New Releases from Matrix Games] >> War in the Pacific: Admiral's Edition >> Tech Support



Message

bk19@mweb.co.za -> RE: Submarine Reporter for Excel 2010 BETA (10/14/2011 10:38:21 AM)

quote:

ORIGINAL: nashvillen

I have loaded the SubmarineReporter_B11a, made the settings as they should be, turned on macros. All I can load is the last day's Allied sub kill (6/4/1943). I have tried to load other allied days and other japanese days with nothing loading. When I do an archive load, there will be a small window flash, then it jumps to the combat reports tab with no data.

I have no error messages. What am I missing, please?


HI,

I have been experiencing the same problem and have spent the past 24 hours trying to narrow down the problem.
The error is caused (in part) by a timing issue related to background overhead when copy/pasting. A similar issue exists that relates to file locking. A new version has been sent to Richard for review. This version attempts to mitigate these problems. Some new code exists that currently is restricted to run under pre MSO 2007 versions that is a slightly slower version of the Copy/Paste mechanisms that could be enabled for general use if your problems have not gone away. Please let us know more on this!

I have not yet addressed the notice posted about the apparent change in date formats. This will be addressed today.

Watch out in the meantime for new Beta Release from Richard.




nashvillen -> RE: Submarine Reporter for Excel 2010 BETA (10/14/2011 4:58:17 PM)

FWIW, I am running Excel 2003. I tried dates in both mm/dd/yyyy and dd/mm/yyyy format. I tried different dates also.



bk19@mweb.co.za -> RE: Submarine Reporter for Excel 2010 BETA (10/14/2011 5:06:56 PM)

Thanks Nashvillen

Richard is currently running tests under a VM and Excel 2003 and some issues have been identified.

It is still WIP though.

Oh and the date issue has been resolved. Code sent to Richard earlier today to sort this out.



nashvillen -> RE: Submarine Reporter for Excel 2010 BETA (10/14/2011 5:24:53 PM)

Great, look forward to trying this evening.



cantona2 -> RE: Submarine Reporter for Excel 2010 BETA (10/19/2011 5:04:40 PM)

Just like to say a big thanks for this handy little tool. loving it



cantona2 -> RE: Submarine Reporter for Excel 2010 BETA (10/20/2011 7:41:10 AM)

What changes does the 1.2a have? will it erase all exisiting records if I upgrade to it/



rcm1616 -> RE: Submarine Reporter for Excel 2010 BETA (10/20/2011 9:33:02 AM)


quote:

ORIGINAL: cantona2

What changes does the 1.2a have? will it erase all exisiting records if I upgrade to it/


Yes, it is new file with no records.

You can copy all records from old file (11a) and paste it to new file. Then you must manually refresh data ranges for pivot tables in MONTHS sheet, or just simply import another combat report (with Import reports or IR from archive functions) and pivot tables will be refreshed automatically.



dorjun driver -> RE: Submarine Reporter for Excel 2010 BETA (10/22/2011 12:03:19 AM)

Looks like a cool tool.  Is there an ETA as to when it will run under Excel 2003?[:(]



bk19@mweb.co.za -> RE: Submarine Reporter for Excel 2010 BETA (10/22/2011 2:08:11 PM)

Nope... I have been experimenting with a VMware based installation of XP and MSO 2003. Problem is that I have an original Dutch XP install CD, an original XP English Update CD from a few years earlier and a missing copy of a standard XP EN CD. So I installed the Dutch version in the Virtual machine followed by and English MSO.

When I test the VB code Excel complaints are triggered about missing libraries.

Worse I don't have an iso save anywhere so that I can recreate the darn CD.... otherwise I would already have installed a more consistent arrangement. I am not yet certain though with this language difference is the root cause though.

So I am kinda stuck at the moment.




dorjun driver -> RE: Submarine Reporter for Excel 2010 BETA (10/22/2011 4:58:42 PM)

Sigh.



nashvillen -> RE: Submarine Reporter for Excel 2010 BETA (10/28/2011 12:46:34 AM)

I am getting a run time error 6 overflow on the import archive. Running a Win7 64bit with Excel 2007.

Here is the debug report:

[image]http://i1190.photobucket.com/albums/z446/nashvillen/NewPicture4.jpg[/image]



bk19@mweb.co.za -> RE: Submarine Reporter for Excel 2010 BETA (10/28/2011 1:02:19 AM)

Ya got me..... [;)]

I have already come across this bug and fixed it.
I found a couple of other things I did not like too much either (Can't remember exactly what now) and have been testing some more.

This version is still for MSO 2007 and later though.

A new 'unofficial' Beta Version 1.3 is attached. The formal release will need to be done by Richard.

Bruce



n01487477 -> RE: Submarine Reporter for Excel 2010 BETA (1/1/2012 12:20:25 AM)


quote:

ORIGINAL: bk19@mweb.co.za

Ya got me..... [;)]

I have already come across this bug and fixed it.
I found a couple of other things I did not like too much either (Can't remember exactly what now) and have been testing some more.

This version is still for MSO 2007 and later though.

A new 'unofficial' Beta Version 1.3 is attached. The formal release will need to be done by Richard.

Bruce


I've also uploaded it to my video page for posterity.
https://sites.google.com/site/n01487477/





bk19@mweb.co.za -> RE: Submarine Reporter for Excel 2010 BETA (1/1/2012 12:30:21 AM)

For the record, I have been using this version 1.3 every single day since I posted it here. I have not found any further problems with it.

I am very happy with its behaviour indeed. This was an excellent idea and tool from Richard.

PS. Happy New Year to all



n01487477 -> RE: Submarine Reporter for Excel 2010 BETA (1/1/2012 12:32:07 AM)


quote:

ORIGINAL: bk19@mweb.co.za

For the record, I have been using this version 1.3 every single day since I posted it here. I have not found any further problems with it.

I am very happy with its behaviour indeed. This was an excellent idea and tool from Richard.

PS. Happy New Year to all

Agreed - I wonder it Richard would mind if I ported it to Java/C# or eventually into Tracker ?



bk19@mweb.co.za -> RE: Submarine Reporter for Excel 2010 BETA (1/2/2012 10:34:51 AM)

Hmmm...

COBOL - Common Business Oriented Language
FORTRAN -Formula Translation
ALGOL - Algorithmic Language
PL1 - Programming Language 1
ADA - A Data Algorithm
RPG 1/2/3 Report Program Generator 1/2/3
ALL A Language Liberator
BASIC - Beginners All Purpose Symbolic Instruction Code
...


I think you get the drift....


And then of course we also have

B - Bell Labs predecessor of C
C - The standard by which all things were measured from.
C++ - C on steroids
C# - C out of key. The M is for Microsoft not Musicality

JAVA - Just Another Virus Application.


Har Har... need I go on??? !!! [sm=00000622.gif]

I suggest you PM Richard and get his opinion.
For my part I do not expect he would have a problem, I certainly don't.

Well almost...

If you were to include this in Tracker, given the rate of release, would you finish the upgrade in this half of the current year?




n01487477 -> RE: Submarine Reporter for Excel 2010 BETA (1/2/2012 10:46:36 AM)

quote:

ORIGINAL: bk19@mweb.co.za

Hmmm...


JAVA - Just Another Virus Application.

Too right ... we only did it in Java originally cause Floyd and I wanted to learn the language a bit more... the joy ran out a while ago ...
quote:


If you were to include this in Tracker, given the rate of release, would you finish the upgrade in this half of the current year?

[sm=duel.gif]

At the rate we've proceeded last year, I'd say not until the end of the decade.[;)]



n01487477 -> RE: Submarine Reporter for Excel 2010 BETA (1/2/2012 10:54:38 AM)

Actually having thought about it more, it will probably never get into Tracker so it would be better for Bret from combatReporter to roll it in.

The program is good as is, except for xls users who are behind the times. Maybe I shouldn't be reinventing any wheels.

I'm just looking for a winter project to keep me occupied - maybe I should go back to working on my game ideas or God forbid my research for work [8|]




PaxMondo -> RE: Submarine Reporter for Excel 2010 BETA (1/2/2012 2:37:29 PM)


quote:

ORIGINAL: n01487477

Actually having thought about it more, it will probably never get into Tracker so it would be better for Bret from combatReporter to roll it in.

The program is good as is, except for xls users who are behind the times. Maybe I shouldn't be reinventing any wheels.

I'm just looking for a winter project to keep me occupied - maybe I should go back to working on my game ideas or God forbid my research for work [8|]



+1

Agreed on all accts. I love on my desktop, but I have to run '03 on my laptop so it won't run there. getting it folded into reporter would be perfect. then I only have to start TWO apps, not THREE!!! [:D]



bk19@mweb.co.za -> RE: Submarine Reporter for Excel 2010 BETA (1/2/2012 4:07:46 PM)

To N01487477

I have a project in mind that will require some sophisticated academic skills.

How up to speed are you with Linear and Non-linear Programming in the context of Operations Management or the Quantitative Management domain?




bk19@mweb.co.za -> RE: Submarine Reporter for Excel 2010 BETA (1/2/2012 4:09:13 PM)

PS.. it may well take a bit longer than winter just to come up with a model and software solution design.....



rcm1616 -> RE: Submarine Reporter for Excel 2010 BETA (1/3/2012 6:11:55 AM)

[/quote]
Agreed - I wonder it Richard would mind if I ported it to Java/C# or eventually into Tracker ?
[/quote]

That's great idea Damian! I had plan to develop new java version, but currently I'm overstacked with my work, family....
SubRep in Tracker - sounds like good idea. But to attach SubRep to CombatReporter maybe better idea.



Richard "Grimasa"



bk19@mweb.co.za -> RE: Submarine Reporter for Excel 2010 BETA (1/3/2012 2:41:50 PM)

BUMP

quote:

ORIGINAL: bk19@mweb.co.za

To N01487477

I have a project in mind that will require some sophisticated academic skills.

How up to speed are you with Linear and Non-linear Programming in the context of Operations Management or the Quantitative Management domain?






n01487477 -> RE: Submarine Reporter for Excel 2010 BETA (1/3/2012 11:18:34 PM)


quote:

ORIGINAL: bk19@mweb.co.za

BUMP

quote:

ORIGINAL: bk19@mweb.co.za

To N01487477

I have a project in mind that will require some sophisticated academic skills.

How up to speed are you with Linear and Non-linear Programming in the context of Operations Management or the Quantitative Management domain?


Will reply by PM later today as I've got to get off to work now.



seille -> RE: Submarine Reporter for Excel 2010 BETA (10/6/2013 2:03:09 PM)

Can you help with this?

I´m using 1.3 and followed your instructions, but when i simply open the sub tracker i get a
run time error, when i hit "debug" i get the screen you can see.

I changed the first tab as you wanted, but always get that same error.
Is there a typo in the code ?

[image]local://upfiles/25493/CC04C90841FA49418221895696D58C6E.jpg[/image]



rcm1616 -> RE: Submarine Reporter for Excel 2010 BETA (10/8/2013 10:38:45 AM)


quote:

ORIGINAL: seille

Can you help with this?

I´m using 1.3 and followed your instructions, but when i simply open the sub tracker i get a
run time error, when i hit "debug" i get the screen you can see.

I changed the first tab as you wanted, but always get that same error.
Is there a typo in the code ?

[image]local://upfiles/25493/CC04C90841FA49418221895696D58C6E.jpg[/image]


After 2 days of bugtracking with seille we identified problem as a bug in Excel 2007 version.
runtime error '40036' - some magic reason cause that excel did not read values from cells in opened worksheet.

There is a workaround - Mr. seille found it:

"Following a tip from the Internet i copied the Config Tab into a new tab and deleted the old one."

And it works!
[:)]



seille -> RE: Submarine Reporter for Excel 2010 BETA (10/8/2013 3:11:45 PM)

Yeah, the program works very good and i like it a lot. Want to thank Grimasa for his help with setting up
and for making the tool. Too bad tools like this are not implemented in AE Tracker.



Numdydar -> RE: Submarine Reporter for Excel 2010 BETA (12/11/2013 5:38:30 PM)

I cannot get this to work in Excel 2010 it keeps saying 'can't find project or library'



nashvillen -> RE: Submarine Reporter for Excel 2010 BETA (12/31/2013 12:06:30 AM)

Switched to Excel 2013, also getting the "Can't find project or library"

What else is needed to make this work? Playing a game as allies, and would really like to see how my hordes of subs do.



nashvillen -> RE: Submarine Reporter for Excel 2010 BETA (4/21/2014 11:21:34 PM)

Bump for those looking for this.



Page: <<   < prev  1 2 [3] 4   next >   >>

Valid CSS!




Forum Software © ASPPlayground.NET Advanced Edition 2.4.5 ANSI
2.4375