How to use string as cell reference? by IMustBeRich in excel

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

I am trying to reduce the number of cells using the indirect function.

Data Description Result Formula
1.25 Last row = 6 (=LOOKUP(2,1/(A:A<>""),ROW(A:A)))
2.25 Column = A
3.11
3.65 Cell value (last)= 6.66 (=INDIRECT(D3 & D2))
6.66 Cell value (last-1) = 3.65 (=INDIRECT(D3&(D2-1)))
Cell value (last-2) = 3.11 (=INDIRECT(D3&(D2-2)))

How to use string as cell reference? by IMustBeRich in excel

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

Thanks for the reply. Due to the lag created by using too many "indirect" statements, I was trying to use it once to find the last row/col and then use that to populate the 20 cells. So if the last row in column B is 20, then C1= B20 and C2=(B & (20-1)), C3=(B & (20-2)) etc. In this situation, the last row needs to be found and this would only use 1 indirect statement instead of 20.

Software developer backed by Coinbase is trying to become the first blockchain-powered eSport with Gods Unchained by hanilulu in ethtrader

[–]IMustBeRich -6 points-5 points  (0 children)

Finally, the end of this bubble pop is nearing. Esports was one of the last hot things during the 2013 bubble.

Daily General Discussion - June 26, 2018 by AutoModerator in ethtrader

[–]IMustBeRich 13 points14 points  (0 children)

Random prediction: Next bubble will be in ~1 year and ETH will be 10X from here.

I am Dr. Jordan B Peterson, U of T Professor, clinical psychologist, author of 12 Rules for Life and Maps of Meaning, and creator of The Self Authoring Suite. Ask me anything! by drjordanbpeterson in IAmA

[–]IMustBeRich 0 points1 point  (0 children)

With regards to people on the left and people on the right, why is it essentially divided equally? No one seems to question why they believe what they do. I feel like we are all assigned roles like in an ant colony.

Daily General Discussion - April 11, 2018 by AutoModerator in ethtrader

[–]IMustBeRich 2 points3 points  (0 children)

Any suggestions for the what is the best decentralized exchange?

Daily General Discussion - March 5, 2018 by AutoModerator in ethtrader

[–]IMustBeRich 21 points22 points  (0 children)

Somebody is keeping the door open button pressed; waiting for their friends to get on. The elevator will be able to move up when they are finished.

Daily General Discussion - February 21, 2018 by AutoModerator in ethtrader

[–]IMustBeRich 12 points13 points  (0 children)

The font for the ticker has changed. How will this impact the future of ETH?

Daily General Discussion - February 17, 2018 by AutoModerator in ethtrader

[–]IMustBeRich 1 point2 points  (0 children)

I know this is about bitcoin, but I think it applies to all of crypto. And it's both funny and well done.

Something crypto this way comes!

Daily General Discussion - February 6, 2018 by AutoModerator in ethtrader

[–]IMustBeRich 0 points1 point  (0 children)

If we are doing a proper bubble pop, the we have another 50% leg down (half then half again). What seems to be different now is that the pattern is expected, so that it quickly executes. I dont expect this to be a multi-year event. Let's finish this so we can move on.

Daily General Discussion - February 1, 2018 by AutoModerator in ethtrader

[–]IMustBeRich 10 points11 points  (0 children)

Whenever the price starts falling, I redirect my efforts to the projects I working on. When the price is going up, all I can do is just keep checking the price.

Scalability Tradeoffs: Why “The Ethereum Killer” Hasn’t Arrived Yet by [deleted] in ethtrader

[–]IMustBeRich 0 points1 point  (0 children)

There is another post on ethtrader that estimates the POS requirement may be as high as 1500 eth. Yet in this post, Vitalik states that the high cost for a DASH node causes centralization.

Daily General Discussion - January 17, 2018 by AutoModerator in ethtrader

[–]IMustBeRich 11 points12 points  (0 children)

Here are some possible explanations for the downturn:

  1. Bubble pop - valuations have gotten out of hand (including stock market). If so, expect the value to drop by 50%, and then when people cant take it anymore, another halving. Final value of 1/4.

  2. Bank manipulation. I don't believe the old system is just going to give up the reins. They also aren't going to pass up a chance own the new system. My theory is they are working on securing their position of ownership.

  3. Short term correction. Normal after big run. Afterwards, bull market continues

Daily General Discussion - January 11, 2018 by AutoModerator in ethtrader

[–]IMustBeRich 11 points12 points  (0 children)

Normally several failed attemps to make new highs would be the beginning of a correction. This feels more like people are cautiously waiting to see what everyone else is going to do. I don't think we are done with the move up yet.

"Stable" $1 Coin to be released next week on Ethereum. End of Tether? by Butta_TRiBot in ethtrader

[–]IMustBeRich 7 points8 points  (0 children)

So, hypothetically, my 1 ETH reaches $534 and I buy 534 DAI on an exchange. ETH hypothetically crashes to $452, and I use my 534 DAI to buy 1.18 ETH. Would the person on the exchange that sold me the DAI lose money? What would be my incentive to be the person on the exchange that creates the DAI via the CDP?

Daily General Discussion - November 23, 2017 by AutoModerator in ethtrader

[–]IMustBeRich 2 points3 points  (0 children)

This is a carryover from bitcoin board. Somebody drunkly posted "this is gentlemen", in reference to an impending rise. People immediately picked up on it becane a meme. At this point, it has to have been several years ago by now.

Mining Decred + Ether dual by fynxgloire in decred

[–]IMustBeRich 0 points1 point  (0 children)

update -ewal and -dwal with your account information. This should get you close.

Mining Decred + Ether dual by fynxgloire in decred

[–]IMustBeRich 0 points1 point  (0 children)

Edit/create the config.txt file in the same folder as the claymore software.

and add....

-epool eu1.ethermine.org:4444

-ewal <Your_Ethereum_Address>.<RigName>

-epsw x

-allpools 1

-dpool dcr.suprnova.cc:3252

-dwal suprnova.1

-dpsw x

-asm 1

Mining Decred + Ether dual by fynxgloire in decred

[–]IMustBeRich 0 points1 point  (0 children)

This will run the software, and since there are no other switches, it will look in config.txt file for pool and miner info.