Jump to content
Search In
  • More options...
Find results that contain...
Find results in...

Recommended Posts

VERSION 2 IS HERE:

Added multi faction support via drop down's to aid in filtering model selection!
Added ability to add multiple heroes to the roster and select warband leader from the models you've chosen!

Let me know what you think of it in the comments and if anything needs improving!

Click here to use the AoS Skirmish roster creator!

NOTE: Please hit "File" then "Make A Copy" to allow you to save your own version that isn't edited by others at the same time!

hope its useful to you all and the dice gods look upon you favourably!

Edited by TomTheHobbit
Version 2 now live
  • Like 5

Share this post


Link to post
Share on other sites

Ok all!

I've created a copy of the front page so that you can just print it out with all blank slots to fill in at a later date, should you need to make updates during a campaign, let me know how this works for you.

T.

Share this post


Link to post
Share on other sites
3 minutes ago, muggins said:

How is this document supposed to work?

You select, grand alliance, then can begin typing the unit name under warscrolls to begin filling out your roster. When you add the amount of models of that unit it will calculate the cost.

Was anything, in particular, you needed help with?

Share this post


Link to post
Share on other sites
Just now, TomTheHobbit said:

You select, grand alliance, then can begin typing the unit name under warscrolls to begin filling out your roster. When you add the amount of models of that unit it will calculate the cost.

Was anything, in particular, you needed help with?

It doesn't seem like the 'vlookup' or whatever you're using worked for me, perhaps i just downloaded the wrong file?

Share this post


Link to post
Share on other sites
Just now, muggins said:

It doesn't seem like the 'vlookup' or whatever you're using worked for me, perhaps i just downloaded the wrong file?

 

I've just restored to an earlier version, as it would appear people had been mucking about with it, sadly I cant control that but I can restore, have another go now and see if it's any better :)

Share this post


Link to post
Share on other sites
1 minute ago, muggins said:

When I open in Excel, I get this:

 

 

Capture.PNG

 

I havent tested it in excel, I wrote it in google sheets, I can test it in excel when im home later but for now as far as im aware it only works in google sheets. sorry!

Share this post


Link to post
Share on other sites

Having done a similar exercise for a Necron spreadsheet from excel to google sheets back in 6th and 7th edition I can say that at that time Excel and Google sheets handled formulas and lookups differently.

To convert it to excel would likely require a manual remake of the formulas. :(

Share this post


Link to post
Share on other sites

As a big fan all things Google, this pleases me it's in Google Sheets.

Just had a quick play and quite like it. Thanks!

  • Like 1

Share this post


Link to post
Share on other sites
2 hours ago, Gaz Taylor said:

As a big fan all things Google, this pleases me it's in Google Sheets.

Just had a quick play and quite like it. Thanks!

 

 

4 minutes ago, kaaras said:

works pretty well. thanks

Thanks guys!

If anyone has any suggestions I'm open to tweaking it and trying to make improvements, next on my list is the ability to choose multiple heroes should you want too!

  • Like 1

Share this post


Link to post
Share on other sites

Join the conversation

You can post now and register later. If you have an account, sign in now to post with your account.

Guest
Reply to this topic...

×   Pasted as rich text.   Paste as plain text instead

  Only 75 emoji are allowed.

×   Your link has been automatically embedded.   Display as a link instead

×   Your previous content has been restored.   Clear editor

×   You cannot paste images directly. Upload or insert images from URL.


×
×
  • Create New...