tl;dr - Putting together a basis for studying my game and would like advice from you about what looks right/wrong and helpful/useless, skip first paragraph.

So I've decided to reconsider my approach to the game. I find that when I sit down and look at hand histories, I'm able to put together a consistent range and strategy for a given hand. My problem is always (and likely the same as every other new player) that I don't think fast enough while playing to do it in the moment. I've always had my opening ranges down pat in my mind, but when it came to playing against other players' opening ranges, my game would start getting reduced to playing "by feel". Now I could go on and on about how I play and discuss all of my ideologies and where I see the flaws and all that but it would just take way too long. So below I'm going to explain what I'm doing to help myself here and I'd like to ask you guys what is putting me on the right track, where I could focus a little more, what might just be overkill and not be actually helping me, or any other general advice about studying the game.

I've put together a couple excel sheets to keep notes for myself. In one sheet I have the opening ranges that I use for my 6max cash games. On the next sheet I have charts for each hand Vs. those ranges. I understand that there is so much more to the game than preflop action, but I'm trying to give myself a very solid foundation and I need to start somewhere, why not with constructing ranges. I haven't explored how different preflop actions will change the ranges but I do plan to if this seems like a decent idea, right now I'm just looking at equity vs. these ranges and considering my play with those particular hands. For instance, against a tight UTG range (22+, AJ+, KQ), KQo is less than 40%, so does that mean its best to 3bet or fold if we're on the BTN? What if we're in CO with BTN still to act? Probably the most inherent problem that I see with this is how it doesn't consider implied odds at all.

At times I start feeling like I'm insane for putting this much work into something but I don't have any friends that are into poker enough for me to bounce ideas off of them and I happen to love all this kind of shit!

So if there's any advice you guys can give me, I would really appreciate it! Right now my plan is to just consider equity against these ranges, then to look at 3betting ranges and how different positions will react to them which will allow me to build up 3bet/GII, 3bet/fold, raise/call ranges and more.

And of course, please understand that this does not mean I'm not studying post-flop play, I absolutely am. This is just HOW I'm studying preflop and if it has the effect I'm hoping it will then it will benefit my post flop while giving me a stronger ability to study and improve my post as well.