The Junkman Cometh to Excel...

All discussions about the Wasted West and Way Out West settings. If system specific, please note in the subject line, [SW], [Classic], or [d20].

Moderators: PEG Jodi, The Moderators

Do you think an Auto-Device spreadsheet for Junkers would be helpful?

Hells YEAH!
23
23%
Hells YEAH!
23
23%
Hells YEAH!
23
23%
Hells YEAH!
23
23%
Your crazy.
0
No votes
Your crazy.
0
No votes
Your crazy.
0
No votes
Your crazy.
0
No votes
I've tried, it can't be done.
2
2%
I've tried, it can't be done.
2
2%
I've tried, it can't be done.
2
2%
I've tried, it can't be done.
2
2%
 
Total votes: 100

Message
Author
User avatar
Tank
Novice
Posts: 73
Joined: Tue May 24, 2005 7:04 pm
Location: St. Louis, MO

The Junkman Cometh to Excel...

#1 Postby Tank » Tue Mar 14, 2006 9:38 am

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!

Psykoguy
Heroic
Posts: 1554
Joined: Wed May 14, 2003 4:33 pm
Location: Redwood City, CA
Contact:

#2 Postby Psykoguy » Wed Mar 15, 2006 4:20 am

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!

ZombieRancher
Novice
Posts: 10
Joined: Wed Jan 04, 2006 1:47 pm
Location: London, OH

#3 Postby ZombieRancher » Tue Apr 04, 2006 3:46 pm

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.

User avatar
Laces
Seasoned
Posts: 116
Joined: Sun Mar 12, 2006 7:36 pm
Location: A place where they wouldn't waste a ghost rock tac-nuke

#4 Postby Laces » Wed Apr 05, 2006 4:53 pm

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.

ZombieRancher
Novice
Posts: 10
Joined: Wed Jan 04, 2006 1:47 pm
Location: London, OH

#5 Postby ZombieRancher » Wed May 10, 2006 6:05 pm

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?

Old Patch
Veteran
Posts: 848
Joined: Wed May 14, 2003 7:35 pm
Location: Inside of a Dog

#6 Postby Old Patch » Thu May 11, 2006 6:52 am

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~

Psykoguy
Heroic
Posts: 1554
Joined: Wed May 14, 2003 4:33 pm
Location: Redwood City, CA
Contact:

#7 Postby Psykoguy » Tue Sep 05, 2006 2:09 am

i know the thread's kind of quiet, but I'm a bit interested in the progress of this little program :)
Highlander was a documentry, and it was filmed in real time!

ZombieRancher
Novice
Posts: 10
Joined: Wed Jan 04, 2006 1:47 pm
Location: London, OH

#8 Postby ZombieRancher » Tue Sep 05, 2006 10:36 am

I got pretty far along, but got sidelined around the end of April because of real life (I hate that ;-) ). I can post what I have so far, and y'all can take a look and provide feedback, if you like.

User avatar
The One
Heroic
Posts: 1382
Age: 35
Joined: Wed May 14, 2003 7:19 pm

#9 Postby The One » Tue Sep 05, 2006 12:38 pm

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

ZombieRancher
Novice
Posts: 10
Joined: Wed Jan 04, 2006 1:47 pm
Location: London, OH

#10 Postby ZombieRancher » Tue Sep 05, 2006 6:04 pm

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.

ZombieRancher
Novice
Posts: 10
Joined: Wed Jan 04, 2006 1:47 pm
Location: London, OH

#11 Postby ZombieRancher » Sun Sep 17, 2006 3:49 pm

So, has anyone taken a look? Comments? Questions? Harsh but constructive criticisms?

Psykoguy
Heroic
Posts: 1554
Joined: Wed May 14, 2003 4:33 pm
Location: Redwood City, CA
Contact:

#12 Postby Psykoguy » Mon Sep 18, 2006 7:07 pm

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!

ZombieRancher
Novice
Posts: 10
Joined: Wed Jan 04, 2006 1:47 pm
Location: London, OH

#13 Postby ZombieRancher » Mon Sep 18, 2006 7:56 pm

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.

Electrocuted
Novice
Posts: 2
Joined: Mon Dec 18, 2006 4:39 pm

#14 Postby Electrocuted » Mon Dec 18, 2006 4:55 pm

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.

ZombieRancher
Novice
Posts: 10
Joined: Wed Jan 04, 2006 1:47 pm
Location: London, OH

#15 Postby ZombieRancher » Mon Dec 18, 2006 6:50 pm

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. :)

WingRider
Novice
Posts: 12
Joined: Tue Feb 07, 2006 4:55 pm

#16 Postby WingRider » Mon Dec 18, 2006 8:19 pm

There's a power or two in Iron Oasis, as well.

Ferance
Novice
Posts: 16
Joined: Thu Jan 18, 2007 1:28 am
Location: Overland Park, KS
Contact:

#17 Postby Ferance » Thu Jan 18, 2007 3:42 am

(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.

User avatar
Sitting Duck
Legendary
Posts: 5551
Joined: Thu May 15, 2003 6:47 am
Location: Podunk Junction, State of Confusion

#18 Postby Sitting Duck » Thu Jan 18, 2007 8:15 am

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

ZombieRancher
Novice
Posts: 10
Joined: Wed Jan 04, 2006 1:47 pm
Location: London, OH

#19 Postby ZombieRancher » Fri Jan 19, 2007 2:21 pm

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. :)

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.

Ferance
Novice
Posts: 16
Joined: Thu Jan 18, 2007 1:28 am
Location: Overland Park, KS
Contact:

#20 Postby Ferance » Sat Jan 20, 2007 11:44 am

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 ;-) ) 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.


Return to “Deadlands: Hell on Earth & Lost Colony”

Who is online

Users browsing this forum: No registered users and 0 guests