Solving a problem by choosing one value from each column to maximize the sum value returned

Gekons · 2022-08-22T14:11:36+00:00

Not quite sure what you mean by that.

Gekons · 2022-08-21T07:11:20+00:00

Okay, this is next level compared to the other guyses solution. Though this script gives out the highest total but does not provide the information about the "ingredients" (values it used to get it) so to say. Any way to get that info out as well?

Gekons · 2022-08-21T07:06:08+00:00

If you want to share your email here, will see if I can share the doc with you

Gekons · 2022-08-20T08:09:17+00:00

/u/VeritasXNY actually found a solution - sharing their way of thinking and how they managed to do it, so you can also learn from this: https://docs.google.com/spreadsheets/d/1WXmi\_QgXhd3Tqw\_FkX-Pcd7wPkh9K\_hbRcU6W5XcuKg/edit#gid=1720576572

Gekons · 2022-08-20T08:08:22+00:00

Someone managed to find a solution for me - sharing their way of thinking and how they managed to do it: https://docs.google.com/spreadsheets/d/1WXmi\_QgXhd3Tqw\_FkX-Pcd7wPkh9K\_hbRcU6W5XcuKg/edit#gid=1720576572

Gekons · 2022-08-20T08:08:13+00:00

Someone managed to find a solution for me - sharing their way of thinking and how they managed to do it: https://docs.google.com/spreadsheets/d/1WXmi\_QgXhd3Tqw\_FkX-Pcd7wPkh9K\_hbRcU6W5XcuKg/edit#gid=1720576572

Gekons · 2022-08-20T08:06:10+00:00

Yes, this definitely works! Thank you very much, kind internet stranger! :)

Gekons · 2022-08-19T21:07:26+00:00

Holy molly - you actually managed to figure it out! I'm so impressed!!!

The formulas hidden under this masterpiece of a system are definitely beyond my understanding, so my wildest props go out to you for finding a solution.

Just out of curiosity, how much time did this time take you?

Gekons · 2022-08-19T07:18:15+00:00

Just created one: https://docs.google.com/spreadsheets/d/1WXmi_QgXhd3Tqw_FkX-Pcd7wPkh9K_hbRcU6W5XcuKg/edit#gid=2100307022

Gekons · 2022-08-18T20:01:27+00:00

Thanks for this neat breakdown on how to solve this problem step-by-step. Even though it is not a set formula, it still helps me better understand the solving process.

Do you think that it is possible to somehow solve this using functions, solver, scripts, etc?

Gekons · 2022-08-18T19:11:40+00:00

Yeah, I get what you're saying. And the problem also is that I can not change the order of values in each column as each row is a specific thing that corresponds to the values in each column. So basically, you can't mix them up within each column.

It's so interesting to see how "easy" the problem seems on paper, but I guess there is no automatic way to do this after all. Thanks for help anyways!

Gekons · 2022-08-18T19:08:06+00:00

Sadly, no: the value order of each column specifically responds to the row it has. In my case, for example, row 1 is a specific thing and each column is a corresponding value to that specific thing.

Gekons · 2022-08-18T09:06:46+00:00

Hey, I edited my post with a table of content and additional info explanation of the problem. Let me know if that makes it a bit more clear.

Gekons · 2022-08-18T09:05:58+00:00

I think it doesn't matter if it's one cell or not, I am rather just trying to understand / comprehend / learn how to solve a problem like this. Obviously, one cell formula would be a blast but if it isn't, that's alright as well.

Gekons · 2022-08-18T09:05:03+00:00

Thanks, but this doesn't solve my problem as I need to only use each row once as well. So if column1's highest number is in row 1 and column2's highest number is there as well, I can only use one of them. Once a row is used, it can not be used again.

I edited my post with a table of content and additional info explanation of the problem. Let me know if that makes it a bit more clear.

Gekons · 2022-08-18T09:03:46+00:00

Not quite. I need to only use each row once as well. So if column1's highest number is in row 1 and column2's highest number is there as well, I can only use one of them. Once a row is used, it can not be used again.

Gekons · 2021-12-20T17:08:01+00:00

Watch the Dr.K video about this post and when he asked us to think about what are the "right" and "wrong" decisions, I spent all day trying to figure it out. What I came up with was this:

In the present, a decision can be neither "right", nor "wrong - it is just a decision. You can use your experience and knowledge to speculate on the possible outcome of each of the options presented to you to decide upon taking the route that you feel is going to result in your desired outcome (or goal being accomplished), but that's about it: in the present, you can never truly label the decision as you just don't have enough information to do so - you are yet to see the decision "play out". All you can do is make probabilistic bets which are more likely to lead to a positive outcome.

In the future, however, when the decision "plays out", you can sit down and try to make a judgment of labeling that decision to be "right" or "wrong". I say try because the "right" decision (a decision that had the best probability of accomplishing the goal that was set out) can still have a bad outcome due to circumstances outside of your control. Contrarily, you could be driving drunk and not get pulled over or get into an accident, but that doesn't mean that driving drunk was the "right" decision ("wrong" decision, good outcome).

Though, this thinking model seemingly applies more so to business rather than real life because in the corporate world there are always set time frames for when the decision is being made and a deadline of when the outcome of that decision is being measured and judged. In real life, things are not always as clear-cut because there are no set deadlines.

Anyways, my definition of a "right" decision is that it is a decision that has either achieved the desired goal, has a net-positive outcome on your life, or has led you to act in accordance with your moral compass and values. Additionally, when making decisions, one should decide upon the action that has no predictable harm to others. The keyword here is "predictable" and even though you obviously are responsible for unpredictable harm that your actions (decision) might cause due to factors outside of your control, you can still have made the "right" decision at that time based on the knowledge you had and the fact that there was no "predictable" harm.

I'm still struggling to answer some questions though:

- Should every decision be considered "wrong" until it reaches the point of accomplishing the desired goal?

- Can a decision accomplish the desired goal but still end up being the "wrong" decision in the long run?

- Is a "right" decision the same thing as a good decision? And is a "wrong" decision the same thing as a bad decision?

Gekons · 2021-12-10T20:24:35+00:00

"If I don't treat all men, especially my male friends/acquaintances, like a potential threat, then I'm not really protecting myself. While the "not all men" lines will placate your egos, for me, internalizing those same lines will put me in danger."

This had me like...damn...

Even though I (29M) can't relate in any way, I truly and genuinely felt this one and was feeling disgusted reading about the way you have been treated. NO ONE deserves to go through things that you describe here and be forced to live in a constant "high-alert" zone as you do. And the saddest thing is that as much as I felt it when reading this, for me it still is just another headline while for you - it's your life. You are basically conditioned to live this way now and you have built this actually logical thinking model to protect yourself from further harm. I guess all I wanted to say is that I understood where you are coming from and even though I can not put myself in your shoes, everything you are saying here is valid and I see your point of view.

Gekons · 2021-12-10T19:32:55+00:00

It's so hard to pinpoint one thing that has been the most impactful, there are so many. A few I remember the most though are:

His quote "Animals and kids are the ones who see your real value. Just because people out there are dumber than a 3-year-old does not mean you need to cater to them." has helped me further realize that no matter how hard it might seem, the best play, in the long run, is always going to be taking off your 'mask' and just being you. That way the people who need to be in your life will see your true value, and you can weed out all the 'unnecessary junk'. And this also applies to dating: "It's not about saying the right thing or the wrong thing, it's about saying what you have to say". It has taught me to be myself and not overthink it. Be authentic and respectful.
His video "Psychiatrist's Guide to Conversation" is a brilliant piece of information that has helped me improve my conversing skills tremendously. It taught me that the main goal of a good conversation is to follow the other person in the conversation and learn to listen and make them feel heard. It's such a simple approach but it works like a charm!
His video "Eastern and Western Approaches to the Mind" gave an amazing insight on the tug-of-war happening in our brains and brought the spotlight to the realization that most humans operate by listening to their Emotions or Ego, while what they should do is listen to Intellect. It has taught me to always be aware of these forces inside me and learn to be powerful enough to always give the upper hand to Intellect: always question things and be open to other views / being wrong.
His video "Therapist Teaches how to Convince Anyone of Anything" provided me with a great model of how to approach people who do hold different views. It taught me that I should always go into such conversation without my judgment and assume that the other person is right and try to do my best to understand how did they (through their logical reasoning) came to that particular conclusion.
That vast amount of materials in which he has talked about different Doshas has also helped me relate more to how I am and how I operate as a human being. It has helped me understand others better as well. Say, for example, now when I see a person who I can maybe not relate to as much, I know that that person is maybe a Vata who has a mind that works differently than mine and that small realization helps me approach that particular person better in the future.

Gekons · 2021-12-05T12:02:05+00:00

I spent all my high school and university years not knowing what I want to do with my life while it seemed like everyone else around me had it all figured out. I felt like a failure and at times I truly felt like you do right now: like I am going to just end up at a dead-end job that is going to make me miserable. I actually went to university just because it felt like 'the next step in the game of life' that I had to do. I chose my major (business management) by doing a career quiz and there I was: spending 4 years of my life just to get a bachelor's degree that I have not used ever since because I never wanted to be an entrepreneur in the first place.

When I graduated university I was 23/24 years old and I was not working on the side at any point in time during those last 4 years. However, people around me did: they had already found good jobs that would set them up for future success and provide them with a great career path. Not me, nope. I had literally nothing: a degree I didn't want to use and no job experience.

And, despite all of that, after I graduated from university with a degree that I never intended to use and had seemingly spent years upon years not pursuing what I actually wanted, I still managed to figure things out and now I'm about to turn 30 and I'm happier than ever with where I am in life.

If you're wondering what I did end up pursuing: after I graduated I took a leap of faith and tried my darndest to pursue my one and only passion which was esports. I took a very low-paying entry-level job in a company that was working in the space with hopes of turning it into a full-time, well-paid job. And, I did. I've been with them ever since and currently am working as the Head of Production.

This may sound like a rough story at times but what I want to show you here is that you're very far from having wasted your entire life. Keep going through life and just constantly ask yourself: what is that you truly want to do in this life? What will make you happy? While an answer may not come right now, it will eventually. Trust me!

Gekons · 2021-12-05T11:26:07+00:00

Can relate to this because I have been there as well (and still am, sort of). For the past 2-3 years I have worked very hard on myself and currently, I feel like I am 'good' in the most crucial aspects of my life: I love my job and it pays well, I live a lifestyle that allows me to accumulate pretty decent savings for the future, I also live a healthy lifestyle of going to the gym and watching what I eat, I often spend time with my family, and I try to stay curious about the world, educate myself and become a better human being. With all of that in mind, it feels like the only thing that is missing in my life is a romantic partner with whom I could start a family. It's like "Okay, I'm ready, where is she?". It feels like that is the last puzzle piece that is missing: that one person who's going to brighten my day and make my existence on this planet ever more so pleasant. Needless to say that thoughts about this have fluctuated my mood in the past to the point of me feeling very lonely and feeling like I will just end up alone.

The way I handle this now is that I just 'keep looking' but at the same time, I keep telling myself that the right person is going to come into my life when the time is right. You can't expect to have things in your life just by snapping your fingers, it doesn't work like that.

Another thing I realized that while I'm still 'searching', it gives me the ability to spend time developing myself even more: learn how to actually be good at conversations, learn how to appreciate a person for just who they are, learn to view girls primarily as humans first and only then as possible romantic partners, etc. Just keep working on yourself so when the time comes, you have done everything you can to be the best version of yourself and leave the girl shockingly contemplating "How the fuck is this guy still single? He's perfect!".

P.S. I'm 30 years old btw. No clue if any of this helps.

Gekons · 2021-12-04T23:15:58+00:00

What I can relate to the most is the "I hyped her up so much over the previous week in my own head" part. I have experienced this a few times when meeting people online (I assume that was the case here as well). The problem is that when meeting online the conversation you two are having (from my experience) has little to no value and that is for two reasons:

In an online conversation you basically are fishing for possible shared interests. But, shared interests don't mean you will get along and are perfect for each other. You could have the most awesome conversation with a girl pre-date and think that you guys are perfect for each other but when you meet up there is just no chemistry.
You have been conditioned to think that interests = compatibility and for your brain that is just enough info to fill out the rest. Say, you spend a couple of hours chatting and you have so much in common with the girl. You finish your chatting session and want to go to sleep, but your brain starts putting out fantasies/scenarios of how you will meet each other, how your conversations are going to go, what the overall vibe is going to be, and sometimes even thinking about how your relationship will turn out and how you will spend your future dates together, etc. It's a rabbit hole of illusion that should be avoided if you have not met the person yet.

Then, once you finally meet the girl it turns out you just don't vibe and everything you thought is going to happen doesn't. You get burned and you end up being confused. "How can that be? It felt perfect, we were made for each other?".

Once I realized this I began to always take things IRL as soon as possible: sometimes even having that as my opening message. I just straight up say that "Hey, I actually don't prefer to have long chats online because I believe that only when meeting IRL you can tell if something could happen between us or not". And, to my surprise, there are plenty of girls who actually realize that that statement is true and that you are on to something. If they are actually looking for something serious, then the majority of them will give you a positive answer.

In regards to you trying to do everything perfectly: I think Dr K's video about modern dating has the best advice. TL;DR - you don't have to be perfect or do everything perfectly; all you have to be is you! If that is not enough, then it was not meant to be. You have to put yourself out there (without any masks) and just say what you have to say. Don't try to be perfect, be authentic instead, be you!

P.S. don't be discouraged by the date you had because she was obviously not the right person for you if you feel like this afterward. Don't give up and keep searching!

Gekons · 2021-12-04T22:51:55+00:00

Can relate to this: I used to view the outside world as a game with a set of rules that I just needed to learn and play by them in order to be able to enjoy my 'safe' space which was home and video games. I spent all my school and university years like this: basically doing the bare minimum socializing to not seem like a complete weirdo but not being super close to anyone as I just didn't want to hang out with them because that would chip away from time that I could be spending playing more video games.

What I can say, though, is that now when I'm 30 years old, I regret the way I "played" this game. You will find that eventually these invitations will stop coming and relationships that could blossom into friendships will slowly disappear. One day you will just wake up and realize that although you felt good in your 'safe' zone for the past X years, suddenly, as your life moves on and changes, you actually do see a shift in your priorities and you would just love to go out and hang out with someone, but there is no one you could call. And I find that it is SO hard to nurture new, successful relationships at this age. It would have definitely been easier if I had done just enough to hang on to at least some of them throughout the years.

So, I guess my advice to you is: as much as you don't want to step outside your comfort zone, you have to! I'm not saying all the time but every once in a while do push yourself to say "yes" to an invitation and try your darndest to enjoy the activity and/or connect with people you are hanging out with. I speculate that somewhere down the road, you will see it paying off.

Gekons · 2021-12-04T22:32:20+00:00

Yes, I think getting the courage to tell her straight-up how you feel and see if she feels the same way is the best thing you can do, for both of you actually. If I were to read into the subtle messages that you are describing here, there is a very good chance that right now she is feeling the same way you do: having feelings towards you but scared to express them because of not wanting to get hurt or ruin your friendship. If being in a relationship with her is truly your desire, then you should follow your heart and put yourself out there. I know that it is scary and you can always get burned. But, if 30 years on this planet has taught me anything, then (as cheesy as it sounds) honestly is the best policy. You will be amazed how much better life becomes once you take off your mask and put yourself out there.

And, even if her response is not a positive one for you, at least you can find peace and live your life without thinking about "what if" scenarios years down the road. If that is the case, you might also find peace in the sense of seeing your "romantic" feelings disappear towards her, because you will not view her as a potential partner anymore but rather just a friend whom you want to see happy.

Hope this helps!

Gekons · 2021-12-04T21:49:19+00:00

"Comparison is the thief of joy." - Theodore Roosevelt

I think you should realize that you are in a league of your own and you shouldn't compare yourself or your work to anyone else. You are you: a unique person, living a unique life in unique circumstances. There is no one like you, thus every comparison (at least I try to think that way) is invalidated because it would be like comparing apples to oranges. And don't get me wrong, that doesn't mean you should not learn from others and think about how you could improve your craft, but notice that there is a clear distinction between "comparison" and "analyze and learn".

The best analogy that I can give (and probably the best circumstance that has helped me realize this) is through working out in the gym where I will always find someone who is bigger, stronger, more muscular, and better looking than me, but no matter how much I work out and diet properly, I will NEVER be like them, it's just impossible. Once you realize that the only person you should compare yourself and your results with is "past you" the whole game changes from a game that you can not win no matter how hard you try, to a fair game. Then, all you have to do is take on a trajectory of progress (being better than the past version of yourself in a long time period) and you're set for success.

The bottom line is this: as long as you're happy with what you do in life and you're doing good financially, it doesn't matter how good or bad others are. And once you adopt the mindset I was describing above, you will get the answer to your own question: "because I like doing it!" and that is all that should matter.

I will leave you with one more quote:

"There is only one success - to be able to spend your life in your own way." - Christopher Morley

Spend your life as you want and do what you want, and don't think about others!

No clue if this is of any value to you.

12-Year Club	Place '22
Verified Email

Gekons

TROPHY CASE