New CK Google Spreadsheet

[grävling]

All the work in the revised sheet has been moved back to the original.
You should go there.
docs.google.com/spreadsheet/ccc?key=0Asim4pSuJZrIdHhrVlBSSnFlVGFRa1NMbFBHdklrSVE#gid=16

--Grävling


Calling All Chummers!

I made my own copy of the Reference Sheet and then started updating like crazy. That way if I screwed up, the old one would still be there and useful.

But already I think my sheet is a whole lot more useful than the official one.
docs.google.com/spreadsheet/ccc?key=0AscAfLkWPuRjdFRqc1hfakFMc2FhSzc3dlYzbHB3ZGc#gid=1

Weapons and Armour Done.
Implants I will start tomorrow. Done.
Persona-Fixers were updated with consistent pricing and missing items.

Right now the thing is sorted by Neighbourhood, Store, and the order in which it is displayed in the storefront.
This is a useful order for people who want to go into a store and check my work for errors. It's not very good for figuring out what weapon to buy. So you can reorder things as you like, as it is trivial to get it to sort on any column, or series of columns. (It's under Data. Select the whole sheet except for row 1, which are the titles and then click on 'sort range'. Do what the popup tells you.)

In order to get the same prices as I recorded, you will need a CK playing on Normal Difficulty, with Negotiate skill of 4. This is what Sandbox Faces start out of the box with, if you are considering checking with a new character. For MnB you will need to train your Negotiate to 4 before you get these prices. If you play a different difficulty, or with a different Negotiate skill, your numbers will be different. There is a note at the top of the spreadsheet column for price to remind you what you need.

I needed to use Google chrome to get this to work. Firefox sort of crapped out on me. I think it is the savage amount of cookie deletion I do programmatically there that got me into trouble, but if you are having problems, you might try Chrome.

There are 3 1.5 caveats.

1. I don't have the correct price for the special Aztek weapon you only get with great Aztek rep. in Tekka's and Killing Nagas. The only characters I have on hand who are that well loved by Aztek are not Difficulty Normal (nor, do I think, are they only 4 Negotiate). So that figure is left from before, which means that it is certainly wrong. Aztek loves me now. Added.

2. I don't have the prices for the secret backroom of FF&R, or Mars Corp Importers. I will try to add this later with this char, but again, there are rep requirements -- plus finding the correct V-chip in one case -- and I haven't done that at all with this char. Mars loves me now. Added. Still hoping Paddy Coogan's chip will drop. Did. Added. Now I think I just need to get into the Frontline Medi-Secure place. Paging Doctor Cure All!

3. fallen's new area -- the A12 Hab Stacks are not covered. I want to give fallen a chance to change this stuff at whim without worrying that he has made a whole lot of work I did obsolete.

And, lastly, I expect Metalvana to change a lot as I found mega-problems there. So what you see might not be what I have on the sheet, as I will only get around to changing this _after_ fallen does (as I expect he will).

Have fun everybody. I think that this sheet is set up so that you can all make changes. If not, let me know, and I will see what it is that I need to do to make it so. I am 'Jacob Hallén' on the sheet -- that is my lover, and we share a Google account and his name got on there first, because he actually uses he Google account for something, and all I do is buy TB games with it. And now this spreadsheet.

Have fun everybody, and let me know what errors I made.

Grävling

p.s. Hund weapons & armours are included.
p.p.s. So are some storefronts that were missing in the original, i.e. the second door of the Javat Spice Hall.
p.p.p.s Safehouses now have their own sheet. It is possible to find out, not just where the Real Estate Agent that sells the property lives, but the location of the Property as well.

[Jacob]

Badger, you're incredible...
Have we gotten anywhere near that 7K karma mk yet?

Sent from my rooted Falcon -- I want "Cerberus: By Hatred Born" back!! ASAP.

[slayernz]

grävling, you make me want to play the game even more. If only there were more hours in the day and more days in the week. mind you, no doubt work would make me fill in those spare hours and days with spreadsheets

[grävling]

Nov 6, 2014 22:49:05 GMT -5 slayernz said:

grävling, you make me want to play the game even more. If only there were more hours in the day and more days in the week. mind you, no doubt work would make me fill in those spare hours and days with spreadsheets

That's how I feel about ST4X. Damn Xenos ate me again ... But I thought I would put CK down and get better at colony development. But fallen has decided to open a whole new area ...

NEED time machines! NOT ENOUGH HOURS IN THE DAY.

[slayernz]

The thing that is daunting about CK is that I know for certain that it's going to be a very deep and complex game. If I were to pick up ST RPG for the first time, I think I would be frightened. HoS is actually super-simple in comparison (no offense fallen) ... straight RPGs like HoS are intuitively straight forward. CK and ST - not so much.

[fallen]

slayernz - I take that as a complement. It was one of the goals we set out to hit when we created Heroes of Steel. Intuitive and straightforward But ... surprisingly deep if you go looking.

[grävling]

Note: I have edited the first post a bit as I have got a few questions (well, 2) and I now gave good Mars and Aztek rep.

[Sineater]

Madame grävling, do maglock kits still exist in-game? I've never found one.

[grävling]

Nov 7, 2014 12:45:47 GMT -5 Sineater said:

Madame grävling, do maglock kits still exist in-game? I've never found one.

No. They never did anything, either, so were a complete waste of money. They did not make the medkits last any longer, for instance. The promise is that they will come back when we need to unlock doors in the future.

[grävling]

Implants done.

[grävling]

Persona-Fixers updated.

[grävling]

New sheet for safehouses created. safehouse info moved from the equipment sheet. The new sheets contain the missing information (because there were no columns for it) of where the property that is for sale is located, and which faction controls that area.

[grävling]

Hund Treats added.
Maglocks should all be dead now.
The new equipment list is very close to being done.

[bitsai]

Thanks so much for this!

Are there any particular parts where I can pitch in and help update things?

[grävling]

Everything is done, I think, except for some of the Equipment.

If you take a Negotiate 4 Normal Knight out to the NBZ you can find the left over places. I started at River Park and am working my way south, now in Commonwealth. I'm also making dinner and then we will be eating it, so feel free to go after any entries where the verified is not the dull green colour (and where the shop order entries are all blank).

If you manange to find Dr Cure all, fill that in for sure. I haven't got that chip to drop yet.

And I haven't filled in the Los V or Blue Ox ladder reward gear.