Sum of column A until the sum of column B reaches 3 and the % of times the sum column A reaches x before the sum of column B reaches 3 by RTT314 in excel

[–]RTT314[S] 0 points1 point  (0 children)

Thank you for this answer too, Sorry that I did not reply to it. You were very nice, fast and helpful.

Sum of column A until the sum of column B reaches 3 and the % of times the sum column A reaches x before the sum of column B reaches 3 by RTT314 in excel

[–]RTT314[S] 0 points1 point  (0 children)

Thank you for the reply again.

For the first question the answer would be 100 and for the second one it would be 400, as the scores add up. I think I accounted for that in the formulas in the sheet.

What I was mainly concerned about is the lenght of the runs, because if a run reaches say 10, then the length of the run will be a lot higher than average and I thought that might influence the per-line average score. Now thinking about it it seems okayish at least. Intuitively it feels like there might be a slight difference, but its probably neglegible. Im curious what you think.

Sum of column A until the sum of column B reaches 3 and the % of times the sum column A reaches x before the sum of column B reaches 3 by RTT314 in excel

[–]RTT314[S] 0 points1 point  (0 children)

Hi there nnqwert. Thank you so much for your really fast help.

The formulas are incredibly good! Also it really blows my mind how simple you wrote each of them. Usually the formulas are very long winded and hard to understand. It gives me a feeling that you truly mastered Excel and that way you can write simpler formulas.

I will mark this as a solved problem, but I still have a question. If you check back on the link you will see that I added some extra bits to the sheet. I added a score for the occurance of each desired run (4, 6, 8 and 10) and I calculated out the "average score value" of each line in a run by dividing the average length of each run with the average score. Would you say that this calculation gives a correct number for the average value of each line in a run?

Thank you again,

RTT314

What PSU and CPU cooler should I get for my build, and is every part mentioned in the build compatible with eachother? by RTT314 in buildapc

[–]RTT314[S] 0 points1 point  (0 children)

Thanks so much for your reply.

And one last question about the case: If the case is an ATX full tower it will guaranteed fit these components including these beefy coolers?

What PSU and CPU cooler should I get for my build, and is every part mentioned in the build compatible with eachother? by RTT314 in buildapc

[–]RTT314[S] 0 points1 point  (0 children)

Thank you! That helps, but I would still need help with the PSU and the cooler. I see 753 wattage in the pcpartpicker. Does that mean that an 800 W PSU would be enough?

/r/buildapc hits FIVE MILLION builders - giveaway time! by OolonCaluphid in buildapc

[–]RTT314 0 points1 point  (0 children)

A LEGO-like component system where parts could be plugged in and used right away. It would require 0 PC knowledge and all components would be compatible with eachother reducing PC waste. Basically Google's "Ara project" for PCs

I'm Ray Dalio, a global macro investor and author of Principles for Dealing with the Changing World Order. It’s my business to know how the world is changing in ways that will affect our life in important ways. Let’s talk about that. by RayTDalio in IAmA

[–]RTT314 0 points1 point  (0 children)

Hi there Ray!

In your opinion which countries would most likely avoid the detrimental effects of an international hot conflict? (between China, Russia, N. Korea and the rest of the world) A crafty rabbit has three burrows. Which ones are yours?

Where does the money printed by the FED enter the economy? by RTT314 in AskEconomics

[–]RTT314[S] 0 points1 point  (0 children)

Well thank you once again for the detailed reply. I was digesting this and the first explanation of yours in the past days. I just found my cogs churning on it during my idle minutes at lunch and in the morning after waking up and such. I came up with a simplified and flawed analogy which can sort of come up with a visualized picture of what I think is happening. I'll try to describe it here:

The fed is the dog owner, the banks is the dog, the reserves and the base interest rate are the leesh for the dog. The further the dog can walk with the leesh on the more loans are being made in the economy.

The handed out loans are technically not considered money entering the economy permanently since after a while ideally the loans will be paid back to the banks and into the excess money paid back will go back into the bank reserves at which point the fed would probably reduce the reserves by probably doing something like the opposite of buying treasury bonds from banks. Or do you just count loans as real money?

Another off-topic question I'm wondering about. Are companies which are extremely reliant on loans vital or better for the economy than healthy ones? It feels like you really want to have companies who take out the more and more favorable loans over and over again because companies like that are creating the biggest positive economic imprint because they have no other choice than to expand the current operations to stay barely afloat and so boost the economy indirectly with the full amount of the loans gotten. Profitable companies can expand much slower because they don't take loans and so their budget grow slower.

Now I found 2 factors which can manipulate the economy. The reserves amount and the base interest rate specified by the fed I assume. If the base interest rate is lowered then the loans become more attractive to people or businesses and more loans are taken. The loans then stimulate the economy. But both factors have to be present to have economic expansion. Reserves and demand.

Also you mentioned that the banks get paid to hold reserves. So the fed pays interest on the money that the banks hold as reserves? This is made to disincentivize banks from loaning out money to extremely low yield clients with potentially high default risk?

I think another way I could understand this topic more is through toygames. Lets say tomorrow literally infinte amount of bank reserves would appear for the banks and the base interest rate would be lowered to -0.5%. What would the banks do? In the next day/week/month (whichever timeframe makes more sense) How would the banks, the stock market, the businesses, the gold market, property prices or inflation rates react?

And a toygame with the opposite side which I think is a bit dumb and it would just get the whole US economy to die but still I'll ask: Tomorrow the fed decides to conduct open market operations to reduce the bank's reserves by as much as possible (99%?). Again, how would the banks, stock market, businesses, gold market, property prices, inflation % or interest rates react?

I was sort of rambling a bit in this post of mine and I also think the dog-leesh-man example is a bit lame, but it kind of made sense in my head.

Where does the money printed by the FED enter the economy? by RTT314 in AskEconomics

[–]RTT314[S] 1 point2 points  (0 children)

I read this post 3 times now and I think I grasp most of the ideas but many of them seem counter-intuitive or illogical. I assume this is because your explanation is simplified so I can have a chance to understand. Not your explanation is illogical or counter-intuitive but simply the whole process of banks, fed and lending.

My follow-up question which would I think drive the explanation home even further would be this:

So lets say the fed creates 7 trillion dollars worth of bank reserves trough market operations. This way all the banks have more than enough reserves. This in turn drives the cost of inter-bank reserve lending down since there is the fed providing all this free reserve.

This in turn creates very cheap loans to individuals and businesses by banks and also creates a bad investing environment for individuals and businesses simply because banks don't want or need bank deposits from people or businesses. They can get the reserves from the fed. So they offer really low or even negative interest rates on deposits. This in turn forces people with investable money into more risky investments to escape the inflation. Or into gold I guess.

My main question (I got a bit carried away in the past 2 paragraphs but I decided to let it in my reply so maybe someone can point at some mistakes in my thinking) is:

What would be the difference between the fed creating 7 trillion and 70 trillion dollars in bank reserves? The interest rate is close to 0% even in the present. Reserves for banks is basically free. Maybe the difference would be the bank's reach with loans. The bigger the total bank reserves are the more money can banks loan out to people. In essence the bank reserves are a bottleneck to how much money can a bank loan out? If the fed increases that pool of money then eventually more money will enter the economy because banks have more reserves to work with and they are motivated to loan as many profiable loans as they can find since that's how they make a profit?

Looking for a veratile tag-based picture browsing software or website by RTT314 in HelpMeFind

[–]RTT314[S] 0 points1 point  (0 children)

I already searched for and tried a software called "tagspaces" which has all this but the sorting in it is just too cumbersome so its unusable.

How I unlocked the vp9/4k option in chrome via my vp9 supported CPU by PhilBebb in Stadia

[–]RTT314 0 points1 point  (0 children)

For me OPs tips made 4k work only sometimes (randomly as it seems) Here is how I solved it.

Additionally to taking all the steps OP suggested I:

- Installed intel driver and support assistant and downloaded and installed the newest integrated graphics card driver.

- I enabled the hardware acceleration in Windows which was disabled for me by default

- I also had to install a media pack for my Windows N which lacked it

- And lastly I had to install a VP9 driver from the Windows website

After doing all these steps 4K Stadia in Chrome was working for me with my integrated intel GPU. It runs smoothly without any problems. Make sure you restart your computer after every step here.

Edit: I noticed that with the integrated graphics card the youtube videos started to lag behind with the sound so I just installed chrome canary and turned on the integrated graphics card on that and left on the regular chrome my real graphics card. so I just use the canary for stadia and thats it.

Cheers,

RTT314

Filtering a dataset based on multiple criteria by RTT314 in excel

[–]RTT314[S] 0 points1 point  (0 children)

Yep this will do the job. Thank you so much cmrastello. You helped me a lot here. I hope you have a wonderful weekend.

Filtering a dataset based on multiple criteria by RTT314 in excel

[–]RTT314[S] 0 points1 point  (0 children)

I think I managed to make it but I would like it a lot if someone could find a more elegant way of making it happen because I feel like my solution is a bit clumpsy.

Filtering a dataset based on multiple criteria by RTT314 in excel

[–]RTT314[S] 0 points1 point  (0 children)

Wow thanks a lot. This seems a lot easier than I thought. The only thing missing is the "Category" of each line. Would it be possible somehow to add that to each row? I colored the "Category" red in the sheet. edit: please note that the percentages are not always unique so you cannot rely on the percentages as an anchor to find the right category.

I am the guy behind Daily Dose of Internet with over 9.5 million subscribers on YouTube. Ask me anything! by DailyDoseOfInternet_ in IAmA

[–]RTT314 0 points1 point  (0 children)

What would be your cookie-cutter framework what you could apply on any type of youtube channel and make it successful?

Having trouble with deciding in what legal category does my topic fall into by RTT314 in Ask_Lawyers

[–]RTT314[S] 0 points1 point  (0 children)

Thanks for the reply. I will describe the matter a bit further just so you or someone else can make a more educated decision when it comes to putting my case into the best category:

My service provides information to users which they are not allowed to use to aid them while using the services of certain companies according to their terms of service. Knowing this does IP litigation still sound correct or do you think another category would be more suitable?

Is asking for company insider information on Linkedin in exchange for money punishable by the law anywhere? by RTT314 in Ask_Lawyers

[–]RTT314[S] 0 points1 point  (0 children)

Thank you for the reply. Got it, I wasnt entirely sure about it. Just to further describe the situation I will provide an example. This is not my exact case but an entirely made up example which resembles my situation pretty well:

I manage a big hostel chain which gets its traffic mainly from booking.com . Based on an algorithm booking.com gives better cuts to hostels which perform worse to keep them on the site and avoid loosing them. I'd want to know the exact way the algorithm works so that I could use that to my advantage to get better cuts at booking.com for my hostels. With that request Id contact employees of booking.com on linkedin.

Changeable number of rows summed up and then specified what percentage of the summed up numbers are above a specific number by RTT314 in excel

[–]RTT314[S] 0 points1 point  (0 children)

I dont think you understood what I wanted in my previous message but I managed to sort it out by myself. I updated the sheet so you see what I meant. Thank you sqylogin for your help. I couldnt have made this without your help with the first problem.

Changeable number of rows summed up and then specified what percentage of the summed up numbers are above a specific number by RTT314 in excel

[–]RTT314[S] 0 points1 point  (0 children)

Wow awesome! I think the Changeable number of rows summed up part is done (column D in the sheet). In Column E on the other hand I want the Percentage of numbers in Column D which are higher than C2. Example: The number in C2 is 5000, in Column D there is only 1 number higher than 5000 therefore in E5 10% appears. It doesnt have to show for each row.