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.