AN Excel Ship Builder

[Duston Horacek]

Don't Modify the dark grey cells and all will be good.

Mike,

Is Armor the Only Damage Capacity a ship gets? what about shields?

This current excel sheet is as per the current rules, but if shields add to the Damage Capacity then I'll need to modify it.

[ME Brines]

On 10/12/2013 8:39 AM, Duston Horacek wrote:
> Don't Modify the dark grey cells and all will be good.
>
> Mike,
>
> Is Armor the Only Damage Capacity a ship gets? what about shields?

Shields prevent damage like point defense and lasers and sandcasters. If
the damage gets through the amount of damage it takes to destroy a ship
depend on size and armor. If nothing gets through, you're fine. But
having shields doesn't increase the damage capacity

>
> This current excel sheet is as per the current rules, but if shields
> add to the Damage Capacity then I'll need to modify it.
>
>

> --
> You received this message because you are subscribed to the Google
> Groups "Fantasy Nations PBEM" group.
> To unsubscribe from this group and stop receiving emails from it, send
> an email to fantasy-nations-...@googlegroups.com.
> For more options, visit https://groups.google.com/groups/opt_out.

--
Does the secret to the origin of Mankind lie within the Great Pyramid of
Mars? Download The Queen's Martian Rifles at
https://www.smashwords.com/books/view/102308

[The Janari]

Do lasers prevent damage from fighters and missiles at a full 0.5 per size or is their defensive rating diminished?  The entry in the rules seems to suggest the defensive capacity is less than the offensive capability.

On Oct 12, 2013 10:55 AM, "ME Brines" <s...@cox.net> wrote:

On 10/12/2013 8:39 AM, Duston Horacek wrote:

Don't Modify the dark grey cells and all will be good.

Mike,

Is Armor the Only Damage Capacity a ship gets? what about shields?

Shields prevent damage like point defense and lasers and sandcasters. If the damage gets through the amount of damage it takes to destroy a ship depend on size and armor. If nothing gets through, you're fine. But having shields doesn't increase the damage capacity

This current excel sheet is as per the current rules, but if shields add to the Damage Capacity then I'll need to modify it.


--
You received this message because you are subscribed to the Google Groups "Fantasy Nations PBEM" group.

To unsubscribe from this group and stop receiving emails from it, send an email to fantasy-nations-pbem+unsub...@googlegroups.com.

For more options, visit https://groups.google.com/groups/opt_out.

--
Does the secret to the origin of Mankind lie within the Great Pyramid of Mars? Download The Queen's Martian Rifles at https://www.smashwords.com/books/view/102308

--
You received this message because you are subscribed to the Google Groups "Fantasy Nations PBEM" group.

To unsubscribe from this group and stop receiving emails from it, send an email to fantasy-nations-pbem+unsub...@googlegroups.com.

[Duston Horacek]

Then the excel sheet should be correct, let me know if you find errors.

Interestingly enough I noticed a few errors of my current ships, and will list them in my packet when I send it in. (I didn't use this excel sheet all the time and should have. hehe)

So atm two of my ship designs have significantly less Damage Capacity listed then they should have.

On Sat, Oct 12, 2013 at 2:58 PM, ME Brines <s...@cox.net> wrote:

On 10/12/2013 8:39 AM, Duston Horacek wrote:

Don't Modify the dark grey cells and all will be good.

Mike,

Is Armor the Only Damage Capacity a ship gets? what about shields?

Shields prevent damage like point defense and lasers and sandcasters. If the damage gets through the amount of damage it takes to destroy a ship depend on size and armor. If nothing gets through, you're fine. But having shields doesn't increase the damage capacity

This current excel sheet is as per the current rules, but if shields add to the Damage Capacity then I'll need to modify it.

--
You received this message because you are subscribed to the Google Groups "Fantasy Nations PBEM" group.

To unsubscribe from this group and stop receiving emails from it, send an email to fantasy-nations-pbem+unsub...@googlegroups.com.

For more options, visit https://groups.google.com/groups/opt_out.

--
Does the secret to the origin of Mankind lie within the Great Pyramid of Mars? Download The Queen's Martian Rifles at https://www.smashwords.com/books/view/102308

--
You received this message because you are subscribed to the Google Groups "Fantasy Nations PBEM" group.

To unsubscribe from this group and stop receiving emails from it, send an email to fantasy-nations-pbem+unsub...@googlegroups.com.

[Geth Neural Network]

This is beautiful. It makes me want to cry!

--
You received this message because you are subscribed to the Google Groups "Fantasy Nations PBEM" group.

To unsubscribe from this group and stop receiving emails from it, send an email to fantasy-nations-...@googlegroups.com.

[Duston Horacek]

Ty, I love VLOOKUP in Excel. I used to use VBA and code in Basic to do what vlookup does much much easier. =D

[Geth Neural Network]

And now it's a Google sheet so I can use it from wherever.

I can't share it or we'd all be editing the same file, I think.

[Duston Horacek]

Does google use vlookup?

Sent from Mytouch4G

[Geth Neural Network]

Yes.

I found a bug. I think. If I pick 2 laser turrets and 1 armor, it spits out "L1-1A1/2".

[Duston Horacek]

Two separate laser turrets, or quantity 2?

Sent from Mytouch4G

[The Janari]

Wait, what?  Where does it say in the rules that those are two different things?

[Geth Neural Network]

Quantity 2.

[Geth Neural Network]

They're not. He was asking whether I did something like...

Laser turret 1

Laser turret 1

Or if I did

Laser turret 2

[Joey Browning]

There';s a bug when it comes to showing the damage points of the ship. It only seems to include the Armor value near as I can tell.

[Duston Horacek]

Here is a new one that adds TR and CV (Forgot those, thanks Joey!)

As for Laser Turrets, I did them both ways although adding 2 to Quantity would format the ship correctly.

It may be the conversion to google, because one shows L1 the other L.5-L.5

Any way this fixes the TR/CV ommision

[ME Brines]

It's the same

On 10/12/2013 9:57 AM, The Janari wrote:

Do lasers prevent damage from fighters and missiles at a full 0.5 per size or is their defensive rating diminished?  The entry in the rules seems to suggest the defensive capacity is less than the offensive capability.

On Oct 12, 2013 10:55 AM, "ME Brines" <s...@cox.net> wrote:

On 10/12/2013 8:39 AM, Duston Horacek wrote:

Don't Modify the dark grey cells and all will be good.

Mike,

Is Armor the Only Damage Capacity a ship gets? what about shields?

Shields prevent damage like point defense and lasers and sandcasters. If the damage gets through the amount of damage it takes to destroy a ship depend on size and armor. If nothing gets through, you're fine. But having shields doesn't increase the damage capacity

This current excel sheet is as per the current rules, but if shields add to the Damage Capacity then I'll need to modify it.


--
You received this message because you are subscribed to the Google Groups "Fantasy Nations PBEM" group.

To unsubscribe from this group and stop receiving emails from it, send an email to fantasy-nations-pbem+ unsub...@googlegroups.com.

For more options, visit https://groups.google.com/ groups/opt_out.

--
Does the secret to the origin of Mankind lie within the Great Pyramid of Mars? Download The Queen's Martian Rifles at https://www.smashwords.com/ books/view/102308

--
You received this message because you are subscribed to the Google Groups "Fantasy Nations PBEM" group.

To unsubscribe from this group and stop receiving emails from it, send an email to fantasy-nations-pbem+ unsub...@googlegroups.com.

For more options, visit https://groups.google.com/ groups/opt_out.

--
You received this message because you are subscribed to the Google Groups "Fantasy Nations PBEM" group.
To unsubscribe from this group and stop receiving emails from it, send an email to fantasy-nations-...@googlegroups.com.
For more options, visit https://groups.google.com/groups/opt_out.

[Geth Neural Network]

Then I must be using this incorrectly. I wasn't even on Google when I noticed that.

If I delete everything and pick nothing but "Laser turret...2", I get "L1-" as the ship designation. If I add 1 armor, I get "L1-1A1/2". That still isn't right, though, even ignoring the extra 1. Shouldn't it be L1-A1/3? Or am I still totally confused?

[Duston Horacek]

No, your correct.

I need to fix the damage capacity.

Sent from Mytouch4G

[Duston Horacek]

As soon as I get home I'll update it and send it out.

Sorry for the bugs, but thanks for finding them. Hehe

Sent from Mytouch4G