Login |  Register |  FAQ
   
Post new topic Reply to topic  Page 7 of 8
  [ 111 posts ]  Go to page Previous  1 ... 4, 5, 6, 7, 8  Next

Unit Summary Tables on Excel?
HAL9000
 Post subject: Re: Unit Summary Tables on Excel?
PostPosted: Tue Oct 15, 2013 7:20 pm 
Brood Brother
Brood Brother

Joined: Fri Oct 04, 2013 12:48 pm
Posts: 13
Yes.
It looks like you solved it.
And I think you are right. It depends on the version of excel that I am using.
I use excel 2008 for Mac, and I have to admit it often gives me some problems.

It looks like the version of excel you are using is able to recognize merged cells, which my version of excel appears unable to. I am guessing the original tables have a lot of merged cells.

I also found that copying the tables from the pdf's takes a long time, before my computer responds and I am able to paste anything in excel, but I just thought that my computer is old and slow.

If you can copy from the army statistics tables in the pdf's to an excel spreadsheet, I would like copies of the resulting excel-files.
Would you be able to post them here on the forum?

Thanks.
Top
 Profile Send private message  
 
primarch
 Post subject: Re: Unit Summary Tables on Excel?
PostPosted: Tue Oct 15, 2013 7:27 pm 
Brood Brother
Brood Brother
User avatar

Joined: Fri Feb 14, 2003 12:46 am
Posts: 27069
Location: Edmond, Oklahoma USA
HAL9000 wrote:
Yes.
It looks like you solved it.
And I think you are right. It depends on the version of excel that I am using.
I use excel 2008 for Mac, and I have to admit it often gives me some problems.

It looks like the version of excel you are using is able to recognize merged cells, which my version of excel appears unable to. I am guessing the original tables have a lot of merged cells.

I also found that copying the tables from the pdf's takes a long time, before my computer responds and I am able to paste anything in excel, but I just thought that my computer is old and slow.

If you can copy from the army statistics tables in the pdf's to an excel spreadsheet, I would like copies of the resulting excel-files.
Would you be able to post them here on the forum?

Thanks.


Hi!

Yes you can upload files and make them available as part of your post.

So as not to incur in redundant labor. Which book(s) you tackling?

Primarch

_________________
Primarch


The Primarchload
Magnetized Titans Tutorial
Net Epic Gold
Heresy Rules
Top
 Profile Send private message  
 
Mattman
 Post subject: Re: Unit Summary Tables on Excel?
PostPosted: Wed Oct 16, 2013 2:07 pm 
Brood Brother
Brood Brother
User avatar

Joined: Fri Dec 31, 2010 12:16 am
Posts: 1003
primarch wrote:
Hi!

This worked for me. I think I can proceed quickly now.

On a separate note does anyone know how to make an army builder in excel or open office. I have seen some nifty things done with it (I have dirtside 2 one thats very nice) and I wondered if anyone had the now how on how to do it.

Primarch


I have done something in excel using drop down boxes and look up tables. First version just uses the formation data, but I have been thinking about seeing if I can do it with the full stats as well.

Attachment:
NetEpic Space Marine Army List Creator.xls [83 KiB]
Downloaded 280 times


You just select the boxes under the formation heading for each formation you want and it brings up the info. If you don't want anything, then select the bottom option in the list to fill the box as blank.
Titans have to be constructed in the boxes at the bottom. As with the formation selection, it uses to drop down boxes to bring up the various weapon options. Select the "None" option to not put anything in that slot.

Matt
Top
 Profile Send private message  
 
primarch
 Post subject: Re: Unit Summary Tables on Excel?
PostPosted: Sat Oct 19, 2013 4:04 pm 
Brood Brother
Brood Brother
User avatar

Joined: Fri Feb 14, 2003 12:46 am
Posts: 27069
Location: Edmond, Oklahoma USA
Mattman wrote:
primarch wrote:
Hi!

This worked for me. I think I can proceed quickly now.

On a separate note does anyone know how to make an army builder in excel or open office. I have seen some nifty things done with it (I have dirtside 2 one thats very nice) and I wondered if anyone had the now how on how to do it.

Primarch


I have done something in excel using drop down boxes and look up tables. First version just uses the formation data, but I have been thinking about seeing if I can do it with the full stats as well.

Attachment:
NetEpic Space Marine Army List Creator.xls


You just select the boxes under the formation heading for each formation you want and it brings up the info. If you don't want anything, then select the bottom option in the list to fill the box as blank.
Titans have to be constructed in the boxes at the bottom. As with the formation selection, it uses to drop down boxes to bring up the various weapon options. Select the "None" option to not put anything in that slot.

Matt


Wow!

This is exactly what I meant!

Once all the excel files are done can you do this for all the army lists?

Awesome. ;D

Primarch

_________________
Primarch


The Primarchload
Magnetized Titans Tutorial
Net Epic Gold
Heresy Rules
Top
 Profile Send private message  
 
Mattman
 Post subject: Re: Unit Summary Tables on Excel?
PostPosted: Sat Oct 19, 2013 5:44 pm 
Brood Brother
Brood Brother
User avatar

Joined: Fri Dec 31, 2010 12:16 am
Posts: 1003
I am sure I can knock them up for the rest.
Top
 Profile Send private message  
 
primarch
 Post subject: Re: Unit Summary Tables on Excel?
PostPosted: Sat Oct 19, 2013 7:00 pm 
Brood Brother
Brood Brother
User avatar

Joined: Fri Feb 14, 2003 12:46 am
Posts: 27069
Location: Edmond, Oklahoma USA
Mattman wrote:
I am sure I can knock them up for the rest.


Hi!

I have completed a straight "copy paste" from the books to separate spreadsheet files.

I will now make them look pretty and update the information where necessary to reflect what has been discussed so far.

Once this is done I will forward them to you so you can make those builder files. :)

Primarch

_________________
Primarch


The Primarchload
Magnetized Titans Tutorial
Net Epic Gold
Heresy Rules
Top
 Profile Send private message  
 
primarch
 Post subject: Re: Unit Summary Tables on Excel?
PostPosted: Sun Oct 20, 2013 6:59 pm 
Brood Brother
Brood Brother
User avatar

Joined: Fri Feb 14, 2003 12:46 am
Posts: 27069
Location: Edmond, Oklahoma USA
Hi!

Finished!

Attached are all the spreadsheet files with updated information and stats (not all of them, but quite a few). I have already include many of the recommendations across the different army discussions.

Also I eliminated all the mentions of "optional". that was done when these were new. That was 10 years ago. So all units are "standard".

You can work you magic now Mattman! ;)

Primarch


Attachments:
Tyranids.xls [21.5 KiB]
Downloaded 289 times
Tau.xls [32 KiB]
Downloaded 257 times
Squats.xls [34 KiB]
Downloaded 349 times
Space Marine.xls [54.5 KiB]
Downloaded 263 times
Orks.xls [37.5 KiB]
Downloaded 244 times
Imperial Guard.xls [55 KiB]
Downloaded 272 times
Eldar.xls [57 KiB]
Downloaded 251 times
Chaos.xls [61.5 KiB]
Downloaded 306 times
Adeptus Ministorum.xls [33.5 KiB]
Downloaded 261 times
Adeptus Mechanicus.xls [28 KiB]
Downloaded 292 times

_________________
Primarch


The Primarchload
Magnetized Titans Tutorial
Net Epic Gold
Heresy Rules
Top
 Profile Send private message  
 
The Bissler
 Post subject: Re: Unit Summary Tables on Excel?
PostPosted: Sun Oct 20, 2013 8:50 pm 
Brood Brother
Brood Brother
User avatar

Joined: Thu Sep 27, 2012 5:34 pm
Posts: 3220
Location: Glasgow, Scotland
Excellent work on the Excel tables my friend. Look forward to seeing what Matt does with them.

I'm sure these will prove to be an incredibly valuable resource for the Net Epic community.

_________________
Clickable links for more Epic goodness:

Life of Die Channel including Epic Podcasts and Battle Reports

Epic 40K Players Page on Facebook
Net Epic Evolution Rules
Net Epic War! Campaign Rules
Top
 Profile Send private message  
 
primarch
 Post subject: Re: Unit Summary Tables on Excel?
PostPosted: Sun Oct 20, 2013 9:18 pm 
Brood Brother
Brood Brother
User avatar

Joined: Fri Feb 14, 2003 12:46 am
Posts: 27069
Location: Edmond, Oklahoma USA
The Bissler wrote:
Excellent work on the Excel tables my friend. Look forward to seeing what Matt does with them.

I'm sure these will prove to be an incredibly valuable resource for the Net Epic community.


Hi!

I'll update these regularly as more changes additions are made.

I think having Mattman's nice army builder excel files will be really useful. I wanted something like that for a long while. :)

Primarch

_________________
Primarch


The Primarchload
Magnetized Titans Tutorial
Net Epic Gold
Heresy Rules
Top
 Profile Send private message  
 
HAL9000
 Post subject: Re: Unit Summary Tables on Excel?
PostPosted: Mon Oct 21, 2013 8:26 pm 
Brood Brother
Brood Brother

Joined: Fri Oct 04, 2013 12:48 pm
Posts: 13
Perfect. Brilliant work. Thanks a million. This is exactly what I was after.
Thank you so much for putting these together.

With a bit of luck I can start a war off the shoulder of Orion before Christmas. I promise to post photos and a battle report once it happens :)
Top
 Profile Send private message  
 
primarch
 Post subject: Re: Unit Summary Tables on Excel?
PostPosted: Mon Oct 21, 2013 8:30 pm 
Brood Brother
Brood Brother
User avatar

Joined: Fri Feb 14, 2003 12:46 am
Posts: 27069
Location: Edmond, Oklahoma USA
HAL9000 wrote:
Perfect. Brilliant work. Thanks a million. This is exactly what I was after.
Thank you so much for putting these together.

With a bit of luck I can start a war off the shoulder of Orion before Christmas. I promise to post photos and a battle report once it happens :)


Hi!

Once Mattman does the army builder files off of these then we'll have the "Full Monty". ;) ;D

Primarch

_________________
Primarch


The Primarchload
Magnetized Titans Tutorial
Net Epic Gold
Heresy Rules
Top
 Profile Send private message  
 
The Bissler
 Post subject: Re: Unit Summary Tables on Excel?
PostPosted: Mon Oct 21, 2013 8:41 pm 
Brood Brother
Brood Brother
User avatar

Joined: Thu Sep 27, 2012 5:34 pm
Posts: 3220
Location: Glasgow, Scotland
HAL9000 wrote:
Perfect. Brilliant work. Thanks a million. This is exactly what I was after.
Thank you so much for putting these together.

With a bit of luck I can start a war off the shoulder of Orion before Christmas. I promise to post photos and a battle report once it happens :)


Great news, it sounds like Xmas will be coming early this year! Can't wait! :)

_________________
Clickable links for more Epic goodness:

Life of Die Channel including Epic Podcasts and Battle Reports

Epic 40K Players Page on Facebook
Net Epic Evolution Rules
Net Epic War! Campaign Rules
Top
 Profile Send private message  
 
Mattman
 Post subject: Re: Unit Summary Tables on Excel?
PostPosted: Mon Oct 21, 2013 10:25 pm 
Brood Brother
Brood Brother
User avatar

Joined: Fri Dec 31, 2010 12:16 am
Posts: 1003
primarch wrote:
Once Mattman does the army builder files off of these then we'll have the "Full Monty". ;) ;D
Primarch


Don't think you want to see me doing the Full Monty :o
Top
 Profile Send private message  
 
primarch
 Post subject: Re: Unit Summary Tables on Excel?
PostPosted: Mon Oct 21, 2013 10:54 pm 
Brood Brother
Brood Brother
User avatar

Joined: Fri Feb 14, 2003 12:46 am
Posts: 27069
Location: Edmond, Oklahoma USA
Mattman wrote:
primarch wrote:
Once Mattman does the army builder files off of these then we'll have the "Full Monty". ;) ;D
Primarch


Don't think you want to see me doing the Full Monty :o


Hi!

If that will help getting those files done, yes, yes I would. ;) ;D

Primarch

_________________
Primarch


The Primarchload
Magnetized Titans Tutorial
Net Epic Gold
Heresy Rules
Top
 Profile Send private message  
 
Mattman
 Post subject: Re: Unit Summary Tables on Excel?
PostPosted: Tue Oct 22, 2013 10:41 am 
Brood Brother
Brood Brother
User avatar

Joined: Fri Dec 31, 2010 12:16 am
Posts: 1003
primarch wrote:
Mattman wrote:
primarch wrote:
Once Mattman does the army builder files off of these then we'll have the "Full Monty". ;) ;D
Primarch


Don't think you want to see me doing the Full Monty :o


Hi!

If that will help getting those files done, yes, yes I would. ;) ;D

Primarch


Not sure it would help, would most probably drive players away ;D
Top
 Profile Send private message  
 
Display posts from previous:  Sort by  
  Print view Previous topic | Next topic 
Post new topic Reply to topic  Page 7 of 8
  [ 111 posts ]  Go to page Previous  1 ... 4, 5, 6, 7, 8  Next


Who is online

Users browsing this forum: No registered users and 5 guests

You cannot post new topics in this forum
You cannot reply to topics in this forum
You cannot edit your posts in this forum
You cannot delete your posts in this forum
You cannot post attachments in this forum

Search for:
Jump to:  


Powered by phpBB ® Forum Software © phpBB Group
CoDFaction Style by Daniel St. Jules of Gamexe.net