Excel Tool - Submarine Reporter

Matrix Games Forums

Forums Register Login Photo Gallery Member List Search Calendars FAQ

My Profile Inbox Address Book My Subscription My Forums Log Out

Excel Tool - Submarine Reporter

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 >> Excel Tool - Submarine Reporter

Page: [1]

Message

<< Older Topic Newer Topic >>

Excel Tool - Submarine Reporter - 10/8/2011 8:02:11 AM

rcm1616

Posts: 30
Joined: 8/5/2009
From: Bratislava, Slovakia, EU
Status: offline

I have developed MS Excel 2010 tool for parsing submarine combat records data from combat and operational reports.

It is macro enabled spreadsheet that automatically process submarine combat reports and create reports like this:

I'd like to share it/upload it, but i don't know how.
Please can somebody give me hint, how i can upload file to this forum?

Attachment (1)

< Message edited by rcm1616 -- 10/8/2011 8:06:47 AM >

Post #: 1

RE: Excel Tool - Submarine Reporter - 10/8/2011 8:11:26 AM

n01487477

Posts: 4779
Joined: 2/21/2006
Status: offline

quote:

ORIGINAL: rcm1616

I'd like to share it/upload it, but i don't know how.
Please can somebody give me hint, how i can upload file to this forum?

Nice work... it's the same process by which you uploaded the picture. But you should rename the xls file extension to .txt.

If it's bigger that 500KB you'll need to put it in the tech section where there are more options including zip iirc

_____________________________

-Damian-
EconDoc
TrackerAE
Tutes&Java

(in reply to rcm1616)

Post #: 2

RE: Excel Tool - Submarine Reporter - 10/8/2011 8:20:48 AM

rcm1616

Posts: 30
Joined: 8/5/2009
From: Bratislava, Slovakia, EU
Status: offline

Thanks Damian.

It has 582kB ziped...

May be i can upload it somewhere to public file-sharing service (rapidshare or something like that)and post here just link.

(in reply to n01487477)

Post #: 3

RE: Excel Tool - Submarine Reporter - 10/8/2011 8:22:28 AM

n01487477

Posts: 4779
Joined: 2/21/2006
Status: offline

quote:

ORIGINAL: rcm1616

Thanks Damian.

It has 582kB ziped...

May be i can upload it somewhere to public file-sharing service (rapidshare or something like that)and post here just link.

The tech section allows larger files too ..[edit] sorry thought I mentioned that. Otherwise I'll host it on my googlesite if you want. http://sites.google.com/site/n01487477/Home

< Message edited by n01487477 -- 10/8/2011 8:26:31 AM >

_____________________________

-Damian-
EconDoc
TrackerAE
Tutes&Java

(in reply to rcm1616)

Post #: 4

RE: Excel Tool - Submarine Reporter - 10/8/2011 10:18:57 AM

seille

Posts: 2134
Joined: 6/19/2007
From: Germany
Status: offline

I would be interested in that file, too. Please find a way to upload it somehwere.

(in reply to n01487477)

Post #: 5

RE: Excel Tool - Submarine Reporter - 10/8/2011 10:26:41 AM

n01487477

Posts: 4779
Joined: 2/21/2006
Status: offline

quote:

ORIGINAL: seille
I would be interested in that file, too. Please find a way to upload it somehwere.

The OP sent the file to me and is going to upload it on this forum later.

I've uploaded it on my site for the time being, but as I don't have xls 2010, I couldn't get it working.
Site
https://sites.google.com/site/n01487477/ae-extra-files
Direct link
https://sites.google.com/site/n01487477/ae-extra-files/SubmarineReporter.zip?attredirects=0&d=1

I'll remove it later after he posts it here...Looks like good work from the code I read

Cheers

_____________________________

-Damian-
EconDoc
TrackerAE
Tutes&Java

(in reply to seille)

Post #: 6

RE: Excel Tool - Submarine Reporter - 10/8/2011 10:39:30 AM

janh

Posts: 1216
Joined: 6/12/2007
Status: offline

Awesome, this is a nice gimmick to check out the subs. For a while tried to do this by hand, for fun, but ufff. A cool thing. Thanks!

(in reply to n01487477)

Post #: 7

RE: Excel Tool - Submarine Reporter - 10/8/2011 10:59:39 AM

seille

Posts: 2134
Joined: 6/19/2007
From: Germany
Status: offline

I get only error messages it doesn�t matter what i do.

Would be nice to have a short guide.
For example: Which files do i have to put into the temp import folder ?

(in reply to seille)

Post #: 8

RE: Excel Tool - Submarine Reporter - 10/8/2011 11:01:49 AM

n01487477

Posts: 4779
Joined: 2/21/2006
Status: offline

quote:

ORIGINAL: seille

I get only error messages it doesn�t matter what i do.

Would be nice to have a short guide.
For example: Which files do i have to put into the temp import folder ?

I would imagine none. Do you have a temp folder set up?

_____________________________

-Damian-
EconDoc
TrackerAE
Tutes&Java

(in reply to seille)

Post #: 9

RE: Excel Tool - Submarine Reporter - 10/8/2011 11:19:55 AM

seille

Posts: 2134
Joined: 6/19/2007
From: Germany
Status: offline

I tried to use that temp folder. I also adjusted the game folder.
Copied all combat and operational reports into the temp folder.

"File not found"

Maybe the conversion to office 2000 doesn�t work, no idea.
However, it would be cool to have a few infos how to set it up.

< Message edited by seille -- 10/8/2011 11:20:03 AM >

(in reply to n01487477)

Post #: 10

RE: Excel Tool - Submarine Reporter - 10/8/2011 11:24:56 AM

n01487477

Posts: 4779
Joined: 2/21/2006
Status: offline

quote:

ORIGINAL: seille

I tried to use that temp folder. I also adjusted the game folder.
Copied all combat and operational reports into the temp folder.

"File not found"

Maybe the conversion to office 2000 doesn�t work, no idea.
However, it would be cool to have a few infos how to set it up.

As I said before I couldn't get it working in xls 2002 - it wouldn't convert properly. You need a recent version of office to run this I think. I don;t think you need to copy any files just make sure the configuration is correct in the first worksheet. And have a temp folder set.

_____________________________

-Damian-
EconDoc
TrackerAE
Tutes&Java

(in reply to seille)

Post #: 11

RE: Excel Tool - Submarine Reporter - 10/8/2011 11:29:04 AM

seille

Posts: 2134
Joined: 6/19/2007
From: Germany
Status: offline

Too bad. Would be a helpful tool.

(in reply to n01487477)

Post #: 12

RE: Excel Tool - Submarine Reporter - 10/8/2011 12:24:15 PM

felix83

Posts: 20
Joined: 8/13/2009
From: M�nchen, Bayern
Status: offline

too sad indeed, I encouter the same problems, due to old excel 2000. Tried to convert it to 2000 but no luck.

(in reply to seille)

Post #: 13

RE: Excel Tool - Submarine Reporter - 10/8/2011 12:42:41 PM

rcm1616

Posts: 30
Joined: 8/5/2009
From: Bratislava, Slovakia, EU
Status: offline

quote:

ORIGINAL: seille

I tried to use that temp folder. I also adjusted the game folder.
Copied all combat and operational reports into the temp folder.

"File not found"

Maybe the conversion to office 2000 doesn�t work, no idea.
However, it would be cool to have a few infos how to set it up.

I'm back online. Just give me some time, I'll upload it in Tech Support part of this forum.
(with short config guide...)

I have tested SubReporter strictly on 2010 version of Excel. I think Office 2000 is too old for it...

(in reply to seille)

Post #: 14

RE: Excel Tool - Submarine Reporter - 10/8/2011 1:00:02 PM

cantona2

Posts: 3749
Joined: 5/21/2007
From: Gibraltar
Status: offline

This looks great. It opens fine and I enable macros in Office 2007 however I cannot import database as it says there is a file missing in the scen folder. Looking forward to the config guide once its up. Great work

< Message edited by cantona2 -- 10/8/2011 1:01:25 PM >

_____________________________

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

(in reply to rcm1616)

Post #: 15

RE: Excel Tool - Submarine Reporter - 10/8/2011 2:13:22 PM

rcm1616

Posts: 30
Joined: 8/5/2009
From: Bratislava, Slovakia, EU
Status: offline

I have set new Submarine Reporter tread in Tech Support section.

Please all comments and questions there...

Grimasa.

(in reply to cantona2)

Post #: 16