Matrix Games Forums

 Forums  Register  Login  Photo Gallery  Member List  Search  Calendars  FAQ 

My Profile  Inbox  Address Book  My Subscription  My Forums  Log Out

RE: Submarine Reporter for Excel 2010 BETA

 
View related threads: (in this forum | in all forums)

Logged in as: Guest
Users viewing this topic: none
  Printable Version
All Forums >> [New Releases from Matrix Games] >> War in the Pacific: Admiral's Edition >> Tech Support >> RE: Submarine Reporter for Excel 2010 BETA Page: <<   < prev  1 2 [3] 4   next >   >>
Login
Message << Older Topic   Newer Topic >>
RE: Submarine Reporter for Excel 2010 BETA - 10/14/2011 10:38:21 AM   
bk19@mweb.co.za

 

Posts: 258
Joined: 7/26/2011
Status: offline
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.


(in reply to nashvillen)
Post #: 61
RE: Submarine Reporter for Excel 2010 BETA - 10/14/2011 4:58:17 PM   
nashvillen


Posts: 3836
Joined: 7/3/2006
From: Christiana, TN
Status: offline 		FWIW, I am running Excel 2003. I tried dates in both mm/dd/yyyy and dd/mm/yyyy format. I tried different dates also.

< Message edited by nashvillen -- 10/14/2011 4:59:52 PM >

_____________________________


(in reply to bk19@mweb.co.za)
Post #: 62
RE: Submarine Reporter for Excel 2010 BETA - 10/14/2011 5:06:56 PM   
bk19@mweb.co.za

 

Posts: 258
Joined: 7/26/2011
Status: offline 		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.

(in reply to nashvillen)
Post #: 63
RE: Submarine Reporter for Excel 2010 BETA - 10/14/2011 5:24:53 PM   
nashvillen


Posts: 3836
Joined: 7/3/2006
From: Christiana, TN
Status: offline 		Great, look forward to trying this evening.

_____________________________


(in reply to bk19@mweb.co.za)
Post #: 64
RE: Submarine Reporter for Excel 2010 BETA - 10/19/2011 5:04:40 PM   
cantona2


Posts: 3749
Joined: 5/21/2007
From: Gibraltar
Status: offline 		Just like to say a big thanks for this handy little tool. loving it

_____________________________

1966 was a great year for English Football...Eric was born


(in reply to nashvillen)
Post #: 65
RE: Submarine Reporter for Excel 2010 BETA - 10/20/2011 7:41:10 AM   
cantona2


Posts: 3749
Joined: 5/21/2007
From: Gibraltar
Status: offline 		What changes does the 1.2a have? will it erase all exisiting records if I upgrade to it/

_____________________________

1966 was a great year for English Football...Eric was born


(in reply to rcm1616)
Post #: 66
RE: Submarine Reporter for Excel 2010 BETA - 10/20/2011 9:33:02 AM   
rcm1616


Posts: 30
Joined: 8/5/2009
From: Bratislava, Slovakia, EU
Status: offline
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.

_____________________________

Grimasa

(in reply to cantona2)
Post #: 67
RE: Submarine Reporter for Excel 2010 BETA - 10/22/2011 12:03:19 AM   
dorjun driver


Posts: 641
Joined: 4/20/2006
From: Port Townsend: hex 210,51
Status: offline 		Looks like a cool tool.  Is there an ETA as to when it will run under Excel 2003?

_____________________________

x - ARPAnaut
x - ACM
x - AES
Current - Bum



The paths of glory may lead you to the grave, but the paths of duty may not get you anywhere.
JT

(in reply to rcm1616)
Post #: 68
RE: Submarine Reporter for Excel 2010 BETA - 10/22/2011 2:08:11 PM   
bk19@mweb.co.za

 

Posts: 258
Joined: 7/26/2011
Status: offline 		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.



< Message edited by bk19@mweb.co.za -- 10/22/2011 2:12:05 PM >

(in reply to dorjun driver)
Post #: 69
RE: Submarine Reporter for Excel 2010 BETA - 10/22/2011 4:58:42 PM   
dorjun driver


Posts: 641
Joined: 4/20/2006
From: Port Townsend: hex 210,51
Status: offline 		Sigh.

(in reply to bk19@mweb.co.za)
Post #: 70
RE: Submarine Reporter for Excel 2010 BETA - 10/28/2011 12:46:34 AM   
nashvillen


Posts: 3836
Joined: 7/3/2006
From: Christiana, TN
Status: offline 		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:



_____________________________


(in reply to dorjun driver)
Post #: 71
RE: Submarine Reporter for Excel 2010 BETA - 10/28/2011 1:02:19 AM   
bk19@mweb.co.za

 

Posts: 258
Joined: 7/26/2011
Status: offline 		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


Attachment (1)

(in reply to nashvillen)
Post #: 72
RE: Submarine Reporter for Excel 2010 BETA - 1/1/2012 12:20:25 AM   
n01487477


Posts: 4779
Joined: 2/21/2006
Status: offline
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/




_____________________________

-Damian-
EconDoc
TrackerAE
Tutes&Java

(in reply to bk19@mweb.co.za)
Post #: 73
RE: Submarine Reporter for Excel 2010 BETA - 1/1/2012 12:30:21 AM   
bk19@mweb.co.za

 

Posts: 258
Joined: 7/26/2011
Status: offline 		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

(in reply to n01487477)
Post #: 74
RE: Submarine Reporter for Excel 2010 BETA - 1/1/2012 12:32:07 AM   
n01487477


Posts: 4779
Joined: 2/21/2006
Status: offline
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 ?

_____________________________

-Damian-
EconDoc
TrackerAE
Tutes&Java

(in reply to bk19@mweb.co.za)
Post #: 75
RE: Submarine Reporter for Excel 2010 BETA - 1/2/2012 10:34:51 AM   
bk19@mweb.co.za

 

Posts: 258
Joined: 7/26/2011
Status: offline 		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??? !!!

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?


(in reply to n01487477)
Post #: 76
RE: Submarine Reporter for Excel 2010 BETA - 1/2/2012 10:46:36 AM   
n01487477


Posts: 4779
Joined: 2/21/2006
Status: offline
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?



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

_____________________________

-Damian-
EconDoc
TrackerAE
Tutes&Java

(in reply to bk19@mweb.co.za)
Post #: 77
RE: Submarine Reporter for Excel 2010 BETA - 1/2/2012 10:54:38 AM   
n01487477


Posts: 4779
Joined: 2/21/2006
Status: offline 		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



_____________________________

-Damian-
EconDoc
TrackerAE
Tutes&Java

(in reply to n01487477)
Post #: 78
RE: Submarine Reporter for Excel 2010 BETA - 1/2/2012 2:37:29 PM   
PaxMondo


Posts: 9750
Joined: 6/6/2008
Status: offline
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



+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!!!

_____________________________

Pax

(in reply to n01487477)
Post #: 79
RE: Submarine Reporter for Excel 2010 BETA - 1/2/2012 4:07:46 PM   
bk19@mweb.co.za

 

Posts: 258
Joined: 7/26/2011
Status: offline 		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?



< Message edited by bk19@mweb.co.za -- 1/3/2012 2:39:59 PM >

(in reply to n01487477)
Post #: 80
RE: Submarine Reporter for Excel 2010 BETA - 1/2/2012 4:09:13 PM   
bk19@mweb.co.za

 

Posts: 258
Joined: 7/26/2011
Status: offline 		PS.. it may well take a bit longer than winter just to come up with a model and software solution design.....

(in reply to bk19@mweb.co.za)
Post #: 81
RE: Submarine Reporter for Excel 2010 BETA - 1/3/2012 6:11:55 AM   
rcm1616


Posts: 30
Joined: 8/5/2009
From: Bratislava, Slovakia, EU
Status: offline 		[/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"

< Message edited by rcm1616 -- 1/3/2012 6:29:03 AM >

_____________________________

Grimasa

(in reply to n01487477)
Post #: 82
RE: Submarine Reporter for Excel 2010 BETA - 1/3/2012 2:41:50 PM   
bk19@mweb.co.za

 

Posts: 258
Joined: 7/26/2011
Status: offline 		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?




(in reply to bk19@mweb.co.za)
Post #: 83
RE: Submarine Reporter for Excel 2010 BETA - 1/3/2012 11:18:34 PM   
n01487477


Posts: 4779
Joined: 2/21/2006
Status: offline
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.

_____________________________

-Damian-
EconDoc
TrackerAE
Tutes&Java

(in reply to bk19@mweb.co.za)
Post #: 84
RE: Submarine Reporter for Excel 2010 BETA - 10/6/2013 2:03:09 PM   
seille

 

Posts: 2134
Joined: 6/19/2007
From: Germany
Status: offline 		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 ?




Attachment (1)

(in reply to n01487477)
Post #: 85
RE: Submarine Reporter for Excel 2010 BETA - 10/8/2013 10:38:45 AM   
rcm1616


Posts: 30
Joined: 8/5/2009
From: Bratislava, Slovakia, EU
Status: offline
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 ?





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!



_____________________________

Grimasa

(in reply to seille)
Post #: 86
RE: Submarine Reporter for Excel 2010 BETA - 10/8/2013 3:11:45 PM   
seille

 

Posts: 2134
Joined: 6/19/2007
From: Germany
Status: offline 		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.

(in reply to rcm1616)
Post #: 87
RE: Submarine Reporter for Excel 2010 BETA - 12/11/2013 5:38:30 PM   
Numdydar

 

Posts: 3211
Joined: 2/13/2004
Status: offline 		I cannot get this to work in Excel 2010 it keeps saying 'can't find project or library'

(in reply to seille)
Post #: 88
RE: Submarine Reporter for Excel 2010 BETA - 12/31/2013 12:06:30 AM   
nashvillen


Posts: 3836
Joined: 7/3/2006
From: Christiana, TN
Status: offline 		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.

(in reply to Numdydar)
Post #: 89
RE: Submarine Reporter for Excel 2010 BETA - 4/21/2014 11:21:34 PM   
nashvillen


Posts: 3836
Joined: 7/3/2006
From: Christiana, TN
Status: offline 		Bump for those looking for this.

_____________________________


(in reply to nashvillen)
Post #: 90
Page:   <<   < prev  1 2 [3] 4   next >   >>
All Forums >> [New Releases from Matrix Games] >> War in the Pacific: Admiral's Edition >> Tech Support >> RE: Submarine Reporter for Excel 2010 BETA Page: <<   < prev  1 2 [3] 4   next >   >>
Jump to:





New Messages No New Messages
Hot Topic w/ New Messages Hot Topic w/o New Messages
Locked w/ New Messages Locked w/o New Messages
 Post New Thread
 Reply to Message
 Post New Poll
 Submit Vote
 Delete My Own Post
 Delete My Own Thread
 Rate Posts


Forum Software © ASPPlayground.NET Advanced Edition 2.4.5 ANSI

1.203