Flight Group Sheet Creator - UPDATED WITH NEW VERSION

Squadron-level WW2 aerial combat
elsyr
Sub-Lieutenant
Sub-Lieutenant
Posts: 62
Joined: Fri Apr 08, 2005 3:33 pm
Location: Jacksonville, FL

Flight Group Sheet Creator - UPDATED WITH NEW VERSION

Postby elsyr » Tue Dec 12, 2006 7:50 pm

All:

Had a moment to fiddle in Excel today, and created the attached. Let me know what you think. Each of the 4 plane cards on the aircraft sheet tab can be selected independently, by clicking on the grey bar name field and selecting the short name from the drop down menu.

Hope you find it useful. Now all I need is more planes to enter into the aircraft data sheet (hint hint).

Doug
(whose forte is obviously not subtlety)

<<<attachment removed - see below>>>
Last edited by elsyr on Mon Dec 18, 2006 10:40 pm, edited 5 times in total.

mj12games
Admiral of the Fleet
Admiral of the Fleet
Posts: 3637
Joined: Sun Mar 27, 2005 9:56 pm
Location: Denver, CO
Contact:

Re: Flight Group Sheet Creator

Postby mj12games » Wed Dec 13, 2006 10:19 pm

elsyr wrote:Had a moment to fiddle in Excel today, and created the attached. Let me know what you think.


Nice work... although I don't know what I think about having all the plane data out there and available to any and all, even those who haven't bought the rulebook.

As far as more plane data goes, patience will be rewarded. :)
Daniel Kast
Majestic Twelve Games
www.mj12games.com

elsyr
Sub-Lieutenant
Sub-Lieutenant
Posts: 62
Joined: Fri Apr 08, 2005 3:33 pm
Location: Jacksonville, FL

Postby elsyr » Wed Dec 13, 2006 10:36 pm

Nice work... although I don't know what I think about having all the plane data out there and available to any and all, even those who haven't bought the rulebook.!



Ack! You know, I hadn't even thought about that. Sorry! :oops:

I guess I just assumed (and we all know how dangerous that is) that the folks reading the forum would be purchasers. Feel free to yank the file, or to knock it back to a couple of planes - or if you like I can do it and repost a stripped down version of it. It won't take long for people with the rulebook to enter the data themselves.

Doug
(who's now trying to figure out how to make excel do a conditional object embed so that when a plane is selected, the appropriate picture appears on its card)

mj12games
Admiral of the Fleet
Admiral of the Fleet
Posts: 3637
Joined: Sun Mar 27, 2005 9:56 pm
Location: Denver, CO
Contact:

Postby mj12games » Thu Dec 14, 2006 2:21 am

elsyr wrote:(who's now trying to figure out how to make excel do a conditional object embed so that when a plane is selected, the appropriate picture appears on its card)


Lemme know if/when you work that one out...
Daniel Kast
Majestic Twelve Games
www.mj12games.com

jimbeau
Vice Admiral
Vice Admiral
Posts: 960
Joined: Sun Mar 27, 2005 9:56 pm

Postby jimbeau » Thu Dec 14, 2006 3:34 am

sounds like it's time to break out the VBA and write a macro. Of course where you're going to store all those images is beyond me.

That might make the spread sheet a little big :)

and are there copyright issues associated with that?

thedugan
Admiral
Admiral
Posts: 1660
Joined: Mon Mar 28, 2005 5:01 am
Location: DFW area - Texas!
Contact:

Postby thedugan » Thu Dec 14, 2006 4:12 am

jimbeau wrote:sounds like it's time to break out the VBA and write a macro. Of course where you're going to store all those images is beyond me.


Heh.. and I gave up doing a spreadsheet for SFO, because I didn't feel like figuring out how to do lookup tables....

jimbeau wrote:That might make the spread sheet a little big :)


Yep...

jimbeau wrote:and are there copyright issues associated with that?


That's up to Dan, I'd ask it not be if I were him. <shrug>
Becuz I'm da friggin' ART FAIRY - dats why!

Big Bang = Let there be LIGHT!

jimbeau
Vice Admiral
Vice Admiral
Posts: 960
Joined: Sun Mar 27, 2005 9:56 pm

Postby jimbeau » Thu Dec 14, 2006 5:09 am

What mean by Copyright issues is that the pictures used may (and probably are) copyrighted

elsyr
Sub-Lieutenant
Sub-Lieutenant
Posts: 62
Joined: Fri Apr 08, 2005 3:33 pm
Location: Jacksonville, FL

Postby elsyr » Thu Dec 14, 2006 1:36 pm

The images are almost certainly copyrighted, but if the spreadsheet is for my own personal, non-commercial use, I don't see much of a problem with it. Oh, and yes - a tab full of jpg images would definitely make it a BIG excel file - but it sure would be cool. :)

Doug

p.s.

I've reuploaded the file, with only the data for the two French planes populated.

thedugan
Admiral
Admiral
Posts: 1660
Joined: Mon Mar 28, 2005 5:01 am
Location: DFW area - Texas!
Contact:

Postby thedugan » Thu Dec 14, 2006 2:52 pm

jimbeau wrote:What mean by Copyright issues is that the pictures used may (and probably are) copyrighted


..the original pix by Dan are covered under copyright to him as the artist.

..any pictures that are actually photographs are copyrighted to the photograper

...anyone that owns a copyright (and you do the moment you create it) may release it to public domain at any time, or through specific action to a named party. Failure to defend it usually results in it being considered public domain.

That's my understanding of how copyrights work.
Becuz I'm da friggin' ART FAIRY - dats why!

Big Bang = Let there be LIGHT!

mj12games
Admiral of the Fleet
Admiral of the Fleet
Posts: 3637
Joined: Sun Mar 27, 2005 9:56 pm
Location: Denver, CO
Contact:

Postby mj12games » Thu Dec 14, 2006 4:12 pm

thedugan wrote:That's my understanding of how copyrights work.


Your understanding is correct. For obvious reasons, I would hope that no one uses the graphics from Spitting Fire in anything that is going to be distributed, even freely.

However, there are plenty of non-copyrighted images of most of the planes -- check commons.wikimedia.org to start... it's where I got the cover pic for the rulebook.

Regarding the spreadsheet, I'd feel better if it were distributed sans data... that way, those who own the game can enter in the values relatively easily, and it's still a useful tool. Please note that "feel better" does not translate to "condone or endorse"... :)
Daniel Kast
Majestic Twelve Games
www.mj12games.com


Return to “Spitting Fire”

Who is online

Users browsing this forum: No registered users and 1 guest