|
|
| Author |
Thread Statistics | Show CCP posts - 0 post(s) |
Driftward
Subdreddit
Test Alliance Please Ignore
101
   |
Posted - 2013.05.22 14:50:00 -
[1] - Quote
Hey look they did actually change it....who was it that already had fixed their spreadsheet.....jees I just can't seem to remember.
EDIT: I just saw your reply on my post, so I feel a little guilty about being this snarky. Just guilty, I'll leave it up though. heh heh. |
Driftward
Subdreddit
Test Alliance Please Ignore
113
|
Posted - 2013.05.24 20:21:00 -
[2] - Quote
Chankk Saotome wrote:Driftward wrote:Hey look they did actually change it....who was it that already had fixed their spreadsheet.....jees I just can't seem to remember.
EDIT: I just saw your reply on my post, so I feel a little guilty about being this snarky. Just guilty, I'll leave it up though. heh heh. It gave me a good morning chuckle. Thanks though. I'm wondering if I should leave skill modifiers and such on the primary page or if I should put those next to the actual items they'll eventually modify. I want to do with all the equipment and weaponry the same as I've done with the Module bonuses to show their overall effect based on your skill adjustment but would like some advice on the matter. Also, should I leave things colored as-is? I feel it's a bit of a mess... I've aligned modules and equipment based on their required levels and feel it's much prettier than the Weaponry tab if not exactly as clear upon immediate viewing the actual level of the item in question... Trying to figure out the best way to make this as easy for at-a-glance information as it can be.
The color is nice, but I guess I prefer my color scheme (crazy right, I like what I did). I know that I find it difficult to sometimes track across on the same line due to the solid color scheme though. Maybe add alternating rows? Or Darker and lighter rows (I was contemplating doing this, but hadn't done so yet because it's a pain to do in Google docs). Personally, I like having a buffer row between the sections, perhaps not black but something.
I would suggest adding a frozen 2 rows at the top to keep the headers in view. I also feel like the relevant information on the front page is very.....spread out.
I'm also not exactly sure what you're trying to show with the bonus and multiplier columns.... (nevermind just got it, however maybe a little esoteric. Has potential though. Just need right way to present the info. You could displace it to the far right or something so that it's there for people if they want it but not in the middle of your front page perhaps)
Toss me some comments if you feel like returning the favor. Any info you'd like to see added? |
Driftward
Subdreddit
Test Alliance Please Ignore
120
|
Posted - 2013.05.27 01:06:00 -
[3] - Quote
The front page looks a lot cleaner now with the useful columns nicely clustered. I also like the idea behind the shading, a little confusing still but certainly a step up from before. Kudos. Also, thanks for the advice on those dropboxes (data validation), it was frustrating to not be able to figure out how to do that. |
Driftward
Subdreddit
Test Alliance Please Ignore
120
|
Posted - 2013.05.27 02:38:00 -
[4] - Quote
V 23 wrote:Could you give a brief tutorial on how to use this thing? I am having a fair amount of trouble. 
Well #1, have you made a copy to your own google drive?
If so, then you need to be more descriptive if anyone is going to help you figure it out. What specifically are you having trouble with. Which column? What headers do you not understand? That kind of thing. |
Driftward
Subdreddit
Test Alliance Please Ignore
127
|
Posted - 2013.05.28 15:15:00 -
[5] - Quote
hydraSlav's wrote:Quote:"-20% Spreadsheet CPU/PG usage per lvl" Ahahaha!  I LOLed. Wish my spreadsheet had a 20% reduction to CPU usage These things can really get heavy on performance
Heh heh I liked that part too, but exactly why I do most of my spreadsheet work on my "work" computer. |
Driftward
Subdreddit
Test Alliance Please Ignore
127
|
Posted - 2013.05.28 20:41:00 -
[6] - Quote
hydraSlav's wrote:Driftward wrote:hydraSlav's wrote:Quote:"-20% Spreadsheet CPU/PG usage per lvl" Ahahaha! I LOLed. Wish my spreadsheet had a 20% reduction to CPU usage These things can really get heavy on performance Heh heh I liked that part too, but exactly why I do most of my spreadsheet work on my "work" computer. My dilemma is that my home computer is generally faster, and has higher resolution. However my work computer has 2 monitors which is a huge bonus when working with the spreadsheet. it's a tough choice...
Always is....though the avoidance of actual work is also a good motivator for me.
Alright joking aside. Chankk, I recently added a couple of features that I'm really proud of (ok mostly just two and I stole the other one from hydraslav).
1. The version updater from hydraslav's fitting tool. How he found out about this function I have no idea, but it's a nice implementation. Also, pretty easy to reverse engineer (the "key" is in the url of your page, literally says "key=....")
2. Filiter function: I JUST added this. I think it's pretty nice and cuts down on the clutter. Add a seperate column and make a formula that tosses a 1 if the skill is being used and a 0 if it's unused. Put a filter function on the "check box" column and voila.
3. Conditional formatting for pre-reqs: I realize you already have a nice implementation of your pre-reqs but I think that the strikethrough is a little....unappealing? Hard to see visually? W/e at any rate, I think that conditional formatting for that particular aspect is quite nice and doesn't require reformatting all of your pretty colors either.
EDIT: forgot to mention notes on the top frozen headers. Helps to reduce the clutter of instructions in the limited frozen rows at the top. (right click>insert notes its a pop-up note whenever you scroll across the cell) |
Driftward
Subdreddit
Test Alliance Please Ignore
128
|
Posted - 2013.05.29 16:05:00 -
[7] - Quote
Heads up.
WE have an issue. SP is not translating well between the game and our spreadsheets. I just double checked both of them and they are both off (underestimating how much you can get at least but off none the less). I think it's because CCP changed the amount of SP required for levels (independent of the multipliers). I have to check though.... |
Driftward
Subdreddit
Test Alliance Please Ignore
128
|
Posted - 2013.05.29 22:36:00 -
[8] - Quote
Apparently CCP thought that was too difficult and decided to say F*** it. They use a straight multiplication system to move to the different sp totals from the base stats on a 1 x skill. Not that it makes a big enough difference to actually effect if you can get a skill or not....just makes for some weird numbers down the line. and like a thousand skill point difference overall... |
Driftward
Subdreddit
Test Alliance Please Ignore
129
|
Posted - 2013.05.31 16:26:00 -
[9] - Quote
This might be helpful to you Chankk. Just have to fill in some of the gaps that CCP ommitted.
https://docs.google.com/spreadsheet/ccc?key=0AjhtV2Pl_-oLdExRYnM2TFpOaVN6bC1zdS13RmZPa3c&usp=sharing |
|
|
| |
|