Paging Antti Lahtinen or anyone who can help with a spreadsheet question

[snrdg082102]

Hello everyone,

Background information:

I've been working on two spreadsheets based on the MT design sequence. The first sequence is based on the Wet Navy 3 part article spanning Challenge numbers 53, 54 , and 60. The other sequence is of course from the MT: Referee's Manual. I started with the Wet Navy article and had to drop back and re-learn the sequence in the Referee's Manual. The Referee's Manual design sequence spreadsheet was pretty close to being done when I got side tracked and forgot about both design sequence projects. Thanks to RichardP I've restarted work on both. One of the snags in the Craft Design sequence is how to calculate the UCP of turret weapons. RichardP, suggested contacting Antti Lahtinen. If anyone knows how to contact Antti please forward this post.

 

[snrdg082102]

Hello everyone,

Background information:

I've been working on two spreadsheets based on the MT design sequence. The first sequence is based on the Wet Navy 3 part article spanning Challenge numbers 53, 54 , and 60. The other sequence is of course from the MT: Referee's Manual. I started with the Wet Navy article and had to drop back and re-learn the sequence in the Referee's Manual. The Referee's Manual design sequence spreadsheet was pretty close to being done when I got side tracked and forgot about both design sequence projects. Thanks to RichardP I've restarted work on both. One of the snags in the Craft Design sequence is how to calculate the UCP of turret weapons. RichardP, suggested contacting Antti Lahtinen. If anyone knows how to contact Antti please forward this post.

 

[snrdg082102]

Hello everyone,

Background information:

I've been working on two spreadsheets based on the MT design sequence. The first sequence is based on the Wet Navy 3 part article spanning Challenge numbers 53, 54 , and 60. The other sequence is of course from the MT: Referee's Manual. I started with the Wet Navy article and had to drop back and re-learn the sequence in the Referee's Manual. The Referee's Manual design sequence spreadsheet was pretty close to being done when I got side tracked and forgot about both design sequence projects. Thanks to RichardP I've restarted work on both. One of the snags in the Craft Design sequence is how to calculate the UCP of turret weapons. RichardP, suggested contacting Antti Lahtinen. If anyone knows how to contact Antti please forward this post.

 

[TJP]

It seems he has moved his website to another server, but his e-mail address appears to be on the old one. BTW, it is Antti, not Annti.

E-mail: lahtinen AT ee DOT tut DOT fi
homepage: -click me-

 

[TJP]

It seems he has moved his website to another server, but his e-mail address appears to be on the old one. BTW, it is Antti, not Annti.

E-mail: lahtinen AT ee DOT tut DOT fi
homepage: -click me-

 

[TJP]

It seems he has moved his website to another server, but his e-mail address appears to be on the old one. BTW, it is Antti, not Annti.

E-mail: lahtinen AT ee DOT tut DOT fi
homepage: -click me-

 

[snrdg082102]

Hello TJP,

Thank-you for the information and for the correct spelling. Also, my apologies for being slow on responding, trying to work on two similar spreadsheets has kept me a little busy.
Again thank-you for your help.

Originally posted by TJP:
It seems he has moved his website to another server, but his e-mail address appears to be on the old one. BTW, it is Antti, not Annti.

E-mail: lahtinen AT ee DOT tut DOT fi
homepage: -click me-

 

[snrdg082102]

Hello TJP,

Thank-you for the information and for the correct spelling. Also, my apologies for being slow on responding, trying to work on two similar spreadsheets has kept me a little busy.
Again thank-you for your help.

Originally posted by TJP:
It seems he has moved his website to another server, but his e-mail address appears to be on the old one. BTW, it is Antti, not Annti.

E-mail: lahtinen AT ee DOT tut DOT fi
homepage: -click me-

 

[snrdg082102]

Hello TJP,

Thank-you for the information and for the correct spelling. Also, my apologies for being slow on responding, trying to work on two similar spreadsheets has kept me a little busy.
Again thank-you for your help.

Originally posted by TJP:
It seems he has moved his website to another server, but his e-mail address appears to be on the old one. BTW, it is Antti, not Annti.

E-mail: lahtinen AT ee DOT tut DOT fi
homepage: -click me-

 

[clair_rand]

what spreadsheet are you using? in Excel its not too hard to do this sort of thing, though it gets mind melting at times. Essentially your doing an X-Y lookup, as such you get *two* tables, one of which tells you which row to look in with the other one. Thus you start off knowing how many weapons you have, and what TL.. question: whats the UCP.. ok here we go. Table on is a list of weapon tech levels, literally just the tech levels, each with a row number tied to it. Note this is the row number in the other table.

Now you do a lookup in a row, looking for the first match, say you have 5 weapons, you would match the highest of 1,2,3,4,5 but not 6, thus if the table had entries for 1,3 & 6 you would get '3' as your UCP. the row value from the first table tells you where to look in the second.

Thus:

[table one]
TL row
7 2
13 3
16 4

[table two]
[ ucp ----------]
tl 1 2 3 4 5 6
7 1 3 6 - - -
13 - 1 3 6 - -
16 - - 1 3 6 -

thus a TL 13 weapon gets you row '3' (row one is the heading row with the UCP values in it) you can now do your look up, for say 3 weapons, this gives you the third column. looking at the thrid col or row one gives you the UCP (you could use the value direcly here but this methoid works where the UCP isn not sequential as well.

I've sort of got this bit working in my own spreadsheet, i'll post it when its working a bit better.

BTW: if i post a spreadsheet do i have to remove all the values from the data tables first? i'm assuming anything i've made up / exptrapolated i can do as i wish with, its the core data from the MT book i mean. the whole sheets basically not much use without the book, but it seems daft to make people re-enter it all to use it?

 

[clair_rand]

what spreadsheet are you using? in Excel its not too hard to do this sort of thing, though it gets mind melting at times. Essentially your doing an X-Y lookup, as such you get *two* tables, one of which tells you which row to look in with the other one. Thus you start off knowing how many weapons you have, and what TL.. question: whats the UCP.. ok here we go. Table on is a list of weapon tech levels, literally just the tech levels, each with a row number tied to it. Note this is the row number in the other table.

Now you do a lookup in a row, looking for the first match, say you have 5 weapons, you would match the highest of 1,2,3,4,5 but not 6, thus if the table had entries for 1,3 & 6 you would get '3' as your UCP. the row value from the first table tells you where to look in the second.

Thus:

[table one]
TL row
7 2
13 3
16 4

[table two]
[ ucp ----------]
tl 1 2 3 4 5 6
7 1 3 6 - - -
13 - 1 3 6 - -
16 - - 1 3 6 -

thus a TL 13 weapon gets you row '3' (row one is the heading row with the UCP values in it) you can now do your look up, for say 3 weapons, this gives you the third column. looking at the thrid col or row one gives you the UCP (you could use the value direcly here but this methoid works where the UCP isn not sequential as well.

I've sort of got this bit working in my own spreadsheet, i'll post it when its working a bit better.

BTW: if i post a spreadsheet do i have to remove all the values from the data tables first? i'm assuming anything i've made up / exptrapolated i can do as i wish with, its the core data from the MT book i mean. the whole sheets basically not much use without the book, but it seems daft to make people re-enter it all to use it?

 

[clair_rand]

what spreadsheet are you using? in Excel its not too hard to do this sort of thing, though it gets mind melting at times. Essentially your doing an X-Y lookup, as such you get *two* tables, one of which tells you which row to look in with the other one. Thus you start off knowing how many weapons you have, and what TL.. question: whats the UCP.. ok here we go. Table on is a list of weapon tech levels, literally just the tech levels, each with a row number tied to it. Note this is the row number in the other table.

Now you do a lookup in a row, looking for the first match, say you have 5 weapons, you would match the highest of 1,2,3,4,5 but not 6, thus if the table had entries for 1,3 & 6 you would get '3' as your UCP. the row value from the first table tells you where to look in the second.

Thus:

[table one]
TL row
7 2
13 3
16 4

[table two]
[ ucp ----------]
tl 1 2 3 4 5 6
7 1 3 6 - - -
13 - 1 3 6 - -
16 - - 1 3 6 -

thus a TL 13 weapon gets you row '3' (row one is the heading row with the UCP values in it) you can now do your look up, for say 3 weapons, this gives you the third column. looking at the thrid col or row one gives you the UCP (you could use the value direcly here but this methoid works where the UCP isn not sequential as well.

I've sort of got this bit working in my own spreadsheet, i'll post it when its working a bit better.

BTW: if i post a spreadsheet do i have to remove all the values from the data tables first? i'm assuming anything i've made up / exptrapolated i can do as i wish with, its the core data from the MT book i mean. the whole sheets basically not much use without the book, but it seems daft to make people re-enter it all to use it?