Search the Community

My biggest problem up until I joined Nerd Fitness was that with just about everything else in life, I had an immediate gratification for nearly every action, and especially in video games. Every time you completed even a basic task, you could see that it was impacting your experience, stats, or both. And then I read one of the articles on here, I forget which, where the phrase, "Level up your life," came into my dictionary. And I wanted to know why it wasn't that simple. Why couldn't I gain experience points every time I did a half hour of intense martial arts training? Why didn't I have a strength stat that I could boost by going to the gym? So I wandered on over to my computer, and decided that no one, no where, said that I couldn't. I designed a spreadsheet in Microsoft Excel where I made a list of specific actions for the five attributes: Wisdom, Intelligence, Speed, Strength, and Dexterity. Every time an action is completed, I earn experience points, with 100 experience points earning me a level, and five experience points in one attribute earning me a stat point for that attribute. And then I took it a step further, by making quests: Main quests, and Side Quests. Side quests, I decided, would be daily things that I wanted to turn into habits, such as exercising for an hour straight, or taking 10,000 steps, and earned a little bit of experience. Main quests earned whole levels, and were the things that were major stepping stones towards my overall health goals, such as losing ten pounds, or being able to do fifty pushups in a row, and these were worth whole levels. And then I decided no roleplaying game was complete without classes, so I manufactured a formula that would give me a class based upon what was my highest stat, or if I had multiple stats at the same level. Wisdom is Druid, Intelligence is Monk, Speed is Scout, Strength is Warrior, and Dexterity is Assassin. That is how I solved my need for immediate gratification. And at this point, it serves as my fitness introduction, to show just how I decided to nerd out on fitness. P.S.: This was all done in Microsoft Excel. So if there is anyone out there who is proficient in Microsoft Excel, I'm having issues with a formula (below) where finding the second highest in the list of cells, renders a secondary class. However right now, it's saying that D10 does not equal D10, because I have to be able to extract the cell address to make it work. Any suggestions? =IF(CELL("address",OFFSET(D10,MATCH(MAX(D10:D14),D10:D14,0)-1,0))=$D$14,"Assasin",IF(CELL("address",OFFSET(D10,MATCH(MAX(D10:D14),D10:D14,0)-1,0))=$D$13,"Warrior",IF(CELL("address",OFFSET(D10,MATCH(MAX(D10:D14),D10:D14,0)-1,0))=$D$12,"Scout",IF(CELL("address",OFFSET(D10,MATCH(MAX(D10:D14),D10:D14,0)-1,0))=$D$11,"Monk",IF(CELL("address",OFFSET(D10,MATCH(MAX(D10:D14),D10:D14,0)-1,0))=$D$10,"Druid","None")))))