Username:    Password:      Remember me       
Great White Games/Pinnacle Entertainment Group Forum Index Great White Games/Pinnacle Entertainment Group
Discussion Forum for PEG/GWG
 
 FAQFAQ   SearchSearch   MemberlistMemberlist   UsergroupsUsergroups   RegisterRegister 
 ProfileProfile   Log in to check your private messagesLog in to check your private messages   Log inLog in 

The Junkman Cometh to Excel...
Goto page 1, 2  Next
 
Post new topic   Reply to topic    Great White Games/Pinnacle Entertainment Group Forum Index -> Deadlands: Hell on Earth & Lost Colony
View previous topic :: View next topic  

Do you think an Auto-Device spreadsheet for Junkers would be helpful?
Hells YEAH!
23%
 23%  [ 23 ]
Hells YEAH!
23%
 23%  [ 23 ]
Hells YEAH!
23%
 23%  [ 23 ]
Hells YEAH!
23%
 23%  [ 23 ]
Your crazy.
0%
 0%  [ 0 ]
Your crazy.
0%
 0%  [ 0 ]
Your crazy.
0%
 0%  [ 0 ]
Your crazy.
0%
 0%  [ 0 ]
I've tried, it can't be done.
2%
 2%  [ 2 ]
I've tried, it can't be done.
2%
 2%  [ 2 ]
I've tried, it can't be done.
2%
 2%  [ 2 ]
I've tried, it can't be done.
2%
 2%  [ 2 ]
Total Votes : 100

Author Message
Tank
Novice


Joined: 24 May 2005
Posts: 73
Location: St. Louis, MO

PostPosted: Tue Mar 14, 2006 9:38 am    Post subject: The Junkman Cometh to Excel... Reply with quote

Well, I figure that it's about damn time that somebody handles this, so I started out on it. Building a Junkers wet dream in Excel is turning out to be quite a task, especially since my skills there seem to be limited to the 1d6 region. I'm trying to build a database & automated tables for calculating devices/powers. Just plug in the power and your information on it, and the spreadsheet does the rest. Autocalcs slots, frames, components, target numbers, etc. I even went as far as including the three most commonly used tool tricks (as experienced by myself and other gamers I've played with) Miniturization, Flow, & Finish. Now, the problem here is that this project must be completed at all costs and I just don't have the know-how to get the job done by myself. Any takers on a collaborated effort?
_________________
Boot o' Doom!
Back to top
View user's profile Send private message
Psykoguy
Heroic


Joined: 14 May 2003
Posts: 1554
Location: Redwood City, CA

PostPosted: Wed Mar 15, 2006 4:20 am    Post subject: Reply with quote

I've been tinkering with the idea. I'm a bit worse off in the situation (defaulting on my rolls, to use your metaphor). Still, it's something that would just make things so much easier and faster, I think that it has to be done.
_________________
Highlander was a documentry, and it was filmed in real time!
Back to top
View user's profile Send private message Send e-mail Visit poster's website AIM Address Yahoo Messenger
ZombieRancher
Novice


Joined: 04 Jan 2006
Posts: 10
Location: London, OH

PostPosted: Tue Apr 04, 2006 3:46 pm    Post subject: Reply with quote

I can give it a go with you. Some friends and I used an older Excel spreadsheet for building vehicles for Car Wars a few years ago. We took it and made many modifications to it to improve and update it. I picked up a lot of handy and useful tricks on creating forms for Excel that way.
Back to top
View user's profile Send private message AIM Address MSN Messenger
Laces
Seasoned


Joined: 12 Mar 2006
Posts: 116
Location: A place where they wouldn't waste a ghost rock tac-nuke

PostPosted: Wed Apr 05, 2006 4:53 pm    Post subject: Reply with quote

Hey, let me know how it turns out. I wish I could help, but I never really used excel so I won't be much help. I would love to have something like that.
_________________
All unborn dream of birth, all birthed dream of life, all living dream of glory, all glorious dream of death, all dead dream of consuming the living's flesh, all eaten dream of turning, all turned gorge themselves beside their brethren.
Back to top
View user's profile Send private message
ZombieRancher
Novice


Joined: 04 Jan 2006
Posts: 10
Location: London, OH

PostPosted: Wed May 10, 2006 6:05 pm    Post subject: Reply with quote

It's coming along prety well. I haven't worked on it in a few weeks, but it's probably 80-85% done. Can we post attachements here, or will I need to figure out a way to post it for download somewhere?
Back to top
View user's profile Send private message AIM Address MSN Messenger
Old Patch
Veteran


Joined: 14 May 2003
Posts: 848
Location: Inside of a Dog

PostPosted: Thu May 11, 2006 6:52 am    Post subject: Reply with quote

You'll need to post it somewhere else. You can do a link here in the forums, but not files. I suggest trying the SAVAGE HEROES site - they are great for hosting file downloads for PEG stuff.
_________________
Old Patch

"Outside of a Dog, a Book is a Man's Best Friend. Inside of a Dog, it is too dark to read." ~Groucho Marx~
Back to top
View user's profile Send private message
Psykoguy
Heroic


Joined: 14 May 2003
Posts: 1554
Location: Redwood City, CA

PostPosted: Tue Sep 05, 2006 2:09 am    Post subject: Reply with quote

i know the thread's kind of quiet, but I'm a bit interested in the progress of this little program Smile
_________________
Highlander was a documentry, and it was filmed in real time!
Back to top
View user's profile Send private message Send e-mail Visit poster's website AIM Address Yahoo Messenger
ZombieRancher
Novice


Joined: 04 Jan 2006
Posts: 10
Location: London, OH

PostPosted: Tue Sep 05, 2006 10:36 am    Post subject: Reply with quote

I got pretty far along, but got sidelined around the end of April because of real life (I hate that Wink ). I can post what I have so far, and y'all can take a look and provide feedback, if you like.
Back to top
View user's profile Send private message AIM Address MSN Messenger
The One
Heroic


Joined: 14 May 2003
Posts: 1112

PostPosted: Tue Sep 05, 2006 12:38 pm    Post subject: Reply with quote

I'm pretty good with Excel when it comes to data retrieval (LOOKUPS and the like) as well as IF forumulas, post what you've got or shoot me an e-mail with the sheet and I can take a look
_________________
Life: Past trends are not an indication of future performance
Back to top
View user's profile Send private message Send e-mail Yahoo Messenger
ZombieRancher
Novice


Joined: 04 Jan 2006
Posts: 10
Location: London, OH

PostPosted: Tue Sep 05, 2006 6:04 pm    Post subject: Reply with quote

You can find it here:

home.columbus.rr.com/dlange/HOE/Junker.xls

Feel free to take a look at it and play around with it. The spreadsheet is in a pretty primitive state right now, as I said, it got put aside a couple of months ago. It's intended to cover the Junkman Cometh, plus other available supplements like Waste Warriors and Road Warriors. It's also intended for Classic Deadlands, not Savage Worlds or D20. If anyone has any feedback or suggestions, please post them here.
Back to top
View user's profile Send private message AIM Address MSN Messenger
ZombieRancher
Novice


Joined: 04 Jan 2006
Posts: 10
Location: London, OH

PostPosted: Sun Sep 17, 2006 3:49 pm    Post subject: Reply with quote

So, has anyone taken a look? Comments? Questions? Harsh but constructive criticisms?
Back to top
View user's profile Send private message AIM Address MSN Messenger
Psykoguy
Heroic


Joined: 14 May 2003
Posts: 1554
Location: Redwood City, CA

PostPosted: Mon Sep 18, 2006 7:07 pm    Post subject: Reply with quote

Sorry, I've had some school and work to deal with.

You were right though, it is pretty bare bones at the moment. Still, it's got a bit of the needed tables here, but I haven't really had time to get into the guts of the thing.
_________________
Highlander was a documentry, and it was filmed in real time!
Back to top
View user's profile Send private message Send e-mail Visit poster's website AIM Address Yahoo Messenger
ZombieRancher
Novice


Joined: 04 Jan 2006
Posts: 10
Location: London, OH

PostPosted: Mon Sep 18, 2006 7:56 pm    Post subject: Reply with quote

Mostly I'm concerned with how the individual powers are layed out for design purposes. I've tried to make them as consistent as possible, but the design rules aren't as streamlined as they could be, so there are several places where one-off power layouts were necessary.
Back to top
View user's profile Send private message AIM Address MSN Messenger
Electrocuted
Novice


Joined: 18 Dec 2006
Posts: 2

PostPosted: Mon Dec 18, 2006 4:55 pm    Post subject: Reply with quote

I, for one, not being the junker in the party, am absolutely excited about streamlining our factory generation of junker loo... I mean, facilitate our junk-inclined brethern... or somesuch.

What actually needs to be done on the project? It looks like you have it pretty well in hand from what I was able to poke around on there. Then again, I'm at work and using excel viewer... so no functionality for me.
Back to top
View user's profile Send private message
ZombieRancher
Novice


Joined: 04 Jan 2006
Posts: 10
Location: London, OH

PostPosted: Mon Dec 18, 2006 6:50 pm    Post subject: Reply with quote

Well, most of it is working through the remaining junker powers in the Junkman Cometh book, plus whatever other powers are scattered around the other books (just Waste Warriors and Road Warriors, I think). The powers need to be defined individually. The last bit would be to tie it all together and pretty it up, which shouldn't be much.

I've been hoping to get back to this, but haven't been able to. Maybe the new year will bring some more spare time. Smile
Back to top
View user's profile Send private message AIM Address MSN Messenger
WingRider
Novice


Joined: 07 Feb 2006
Posts: 12

PostPosted: Mon Dec 18, 2006 8:19 pm    Post subject: Reply with quote

There's a power or two in Iron Oasis, as well.
Back to top
View user's profile Send private message
Ferance
Novice


Joined: 18 Jan 2007
Posts: 16
Location: Overland Park, KS

PostPosted: Thu Jan 18, 2007 3:42 am    Post subject: Reply with quote

(bear with me as this was written over the course of several hours as i scoured my books for other junker powers)

I've heard people talk about these other mythical junker powers (mostly flow) but have yet to really find them.

I'm the junker player Electrocuted (a post or two above) is refering to. he sent me the link and the excel sheet a few days ago and aside from the fact that i'm a bit excel deficient i really can't make heads or tails of it.

it seemed there were a few powers missing from the spread sheet (correct me if i'm wrong but ...) specifically Gunsmith, Sensor, Shelter, Shield, Spirit Trap, Spirit Weapon, Spook Juice (though it's more a fomula rather than a power so i assume you could skip it), Super Strength, Targeting, Temperature, VTOL, and Weaponsmith

also maybe as a suggestion, i looked through the tricks as well and really nothing but Debug, Finish, and miniaturize affected the over all componants, slots, or stability so maybe those 3 merit an entry as well

another suggestion might be some way to add the effects of Side-effects both major and minor to the device as well. i'm sure ther are any number of 'extras' that could help with creation like selector switch, ports, dead space allocation, etc.

i purchased the PDF's of Iron Oasis and Waste Warriors and already have the Road Warriors book.

WW has plenty of weapons and vehicles to base junker stuff off of but no powers i could find.

RW has a lot of extra vehicle buff stuff a junker can make good non-stability check equipment with but no powers i could find.

IO has a few (understandably so cause it's a junker city). These are all the flight powers they couldn't cram into the Junkman Cometh specifically Balloon, Jet, Prop, Rotor, a reprint of VTOL, and another new one called Biomechanics that specifically for cyborg/scrapper stuff, plus an update to the warhead/explosive aspect of the Ammo power, and a change to the Sensor power as well (all in all a very busy book)

i couldn't find anything in the wasted west setting book, Brainburners, children of the atom, monsters muties and misfits, spirit warriors, or the last crusaders

that all sums up my HOE library and i know there are more out there so if i missed something or don't have a book and someone knows theres a power in there could they correct this or let me know.

Yeah yeah, all this to really say i don't know anything about excel but would like to see this finished.
Back to top
View user's profile Send private message Visit poster's website
Sitting Duck
Legendary


Joined: 15 May 2003
Posts: 4898
Location: Podunk Junction, State of Confusion

PostPosted: Thu Jan 18, 2007 8:15 am    Post subject: Reply with quote

Shattered Coast has a power for designing water vehicles. Other than that, you appear to have already collected all the books with junker powers.
_________________
The rabbit is cuddly. Kids like little cuddly sidekicks. I mean... The rabbit... It's a time-tested... Okay, the rabbit bites.
Blog: http://sittingduck1313.livejournal.com
The Gamer's Codex Reviewer
Back to top
View user's profile Send private message Yahoo Messenger
ZombieRancher
Novice


Joined: 04 Jan 2006
Posts: 10
Location: London, OH

PostPosted: Fri Jan 19, 2007 2:21 pm    Post subject: Reply with quote

The spreadsheet I posted was extremely preliminary, I was mostly just looking for feedback on how usable it was in its current state. I haven't worked on it in months (thus it's missing a bunch of powers), but it sounds like I should get back to work on it. Smile

Ferance, when you say you couldn't make heads or tails out of it, what do you mean? What I'm going for in the long run is for the user to able to select what powers are present in a device, and the sheet keeps track of slots, etc for you. In its present state, you probably need some Excel knowledge to try it. When it's done, it will be a matter of selecting powers and choosing options for those powers, all through standard drop-down lists and such.

As for the power Flow, it didn't make it into any of the main books, but I believe it was described in an Epitaph (?) later on. I'll have to go through them when I get home tonight to find where exactly I've seen it.
Back to top
View user's profile Send private message AIM Address MSN Messenger
Ferance
Novice


Joined: 18 Jan 2007
Posts: 16
Location: Overland Park, KS

PostPosted: Sat Jan 20, 2007 11:44 am    Post subject: Reply with quote

ahhhh, heh yeah things got a little convoluted i guess. so i'll try and critique what i can.

In it current state, with only a cursory understanding of excel (ie i know there are 3 pages Wink ) it seemed at least partially workable ... the stability calc seems like it has an issue and a few directions on what slide does what would help. perhaps some way to select frame size first or if no frame size is selected, to just start counting slots used (problem with that being the powers that require a frame size to work a percentage from.)

From what you state as your vision for the project i think it'll be easy to deal with as long as you include a guideline or two for functionality and the like. i'm getting very used to working with the junker powers (including the official accumulated errata/rulings) so if you need help with anything short of the programming in excel just let me know.

Also once you find Flow if you could let me know where it is i'd appreciate it.
Back to top
View user's profile Send private message Visit poster's website
Display posts from previous:   
Post new topic   Reply to topic    Great White Games/Pinnacle Entertainment Group Forum Index -> Deadlands: Hell on Earth & Lost Colony All times are GMT - 5 Hours
Goto page 1, 2  Next
Page 1 of 2

 
Jump to:  
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 vote in polls in this forum