Automated and Less-Automated Character Sheets

[Aqu]

Also, what exactly did you fix on the formulas? I can't see a difference.

You copy and pasted the formula from the normal ruleset sheet to Modd's, but in Modd's the cells were lower down, making some of the target areas off.

[TyrannisUmbra]

I wasn't really sure about the level 1 skill points. I looked into Mad_Modd's altered rule book and to me it just read as if he only meant the skill points you get for tagged skills anyway.

That's the way it works on his character sheet. You have both your tags and you have SP to spend at Lv1. I posted the formula his sheet uses earlier in the thread, which is multiplied by level, not by level-1 like normal sheets.

[Shady_steps]

awww, why did you not just make a list of names when naming the Topic? or better yet, mix the names together! kinda like shipping EF1qu?

[Aqu]

Too many names!

If you come up with a good combo with all three, I'd totally switch it though.

[f1r3w4rr10r]

I also sorted the skill in the normal sheet the same way and tinted the weapon skills slightly red on the front page. Tell me what you think.

[Aqu]

I also sorted the skill in the normal sheet the same way and tinted the weapon skills slightly red on the front page. Tell me what you think.

Looks good! Also, ED added perk descriptions that will auto-update to the perk revisions list.

[f1r3w4rr10r]

Two things: I just looked up "VLOOKUP()" and I want to know how it works! xD Because I couldn't quite grasp how you get from a reference to 'Perk Reference' with some cells referenced to the perk sheet.

The other thing: I noticed that some Perk names have a space (' ') at the end. Which is most likely a typo, but causes VLOOKUP() to fail. However, if you add a space in your own Perk name, it works. Now I see several solutions to this:
-ask the people who maintain the Perk list to check their spelling (unlikely)
-just let it be and inform the users about it (nah-ah!)
-find some code solution: Several programming languages have function called "trim" or similar, which removes all white space at the beginning and at the end of the given string. We could use that, if spreadsheet supports that.

//EDIT: Found it. It's called TRIM(). Testing it now.

//EDIT2: Yeah doesn't work...you have no access to the string VLOOKUP() is searching for, since it takes an array.

//EDIT3: Now I get it with the reference. ;P You forgot to hide it on Mad_Modd's sheet.

//EDIT4: Alright...I don't think there's a way to fix the spaces in the perk names. I tried all kinds of combinations with Trim() and ImportRange(), but nothing works...
I also had the idea, that we could maybe substitute the Effects column for Special and Skill requirements. Because I for one am a player that likes to plan ahead with his perks, so I like to have the prerequisites there to be able to plan my skill points accordingly.
But I want to hear your opinions first, before I make such drastic changes.

I could also ask Mad_Modd for access to his perk list to fix his typos.
I could also do the same for the normal one...but I don't think they will give me access... :S

Oh also: we should rather link Mad_Modd's perk list to the Mad_Modd sheet, since his perks are made for his rules and far more likely to be used with his rule set than the default perks. But I also don't want to make this change without your consent.

//EDIT5: I've sent a request for access to the owners of the Perk Revision list. I can ask Mad_Modd later personally.

[Aqu]

Yeah, we should have linked it to Modd's perk list. I can't change it at the moment, but if you want to, you can. Regardless, when I get home in about an hour, I'll fix it. *Fixed*

Let me know if they allow edit permissions, that would be a great-deal helpful.

[f1r3w4rr10r]

Alrighty, so this is what happened during the two days I couldn't reach this site:
I contacted the owner of the Perk List and Ilushia replied to me. He didn't give me edit rights, but offered to fix the names, if I can give him a list of the faulty ones. So I went through the whole list again and he fixed them.

Now that that is out of the way, we have the following stuff to do:
Mad_Modd's list consists out of multiple tabs. We have to import those as well and include them in the lookup. I think I already got an idea how to do it.
//EDIT: Strike that, all of the perks were already imported, you just forgot to expand the lookup range. ^^

Then there are still two other things I would like to discuss: The idea of replacing the Effects column with Level, Special and Skill requirements.
I would like to hear your thoughts on it. Or if we should even add an extra column for those.

Other than that: What were your further plans with the fully automated sheet? What needs to be done that doesn't work?

I also fixed some copy paste related issues on Mad_Modd's sheet. Namely the skill selection for holstered weapons and movement. I also made most of the cell references absolute, to prevent this from happening again.

[SilverlightPony]

Ilushia is female, silly.