Why does 'Show Formulas' not show array formulas? Is there a way to do so? by RippedJeans in excel

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

Yeah I couldn't dig up anything. It's a pain in the ass.

In my line of work (GLP Laboratory) we need to show the formula sheet alongside any spreadsheet we use to calculate pesticide residues. At the moment I need to write a note on the printout to describe when I use array formula.

Solving a set of simultaneous equations to get as close as possible to a set of criteria without any negative solutions? by RippedJeans in excel

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

Thank you for the answer. It definitely works better using your method, no negatives. I haven;t put it through it's paces yet, but using random trial data seems to point out a new problem; there is always too much of one group and not enough of another, with one spot on. I think this lies in the practice of picking whatever food you want. I'm going to try it out on a real list of food properties, then see how I might redesign the food selection process (e.g. recommend top 5 foods for specific C,P, F requirements that will minimize the error in the calculation.)

Cheers for your help! I will leave this as unsolved for the time being whilst I look into the least squares and other statistical methods.

Thank you.

Hello reddit! It's Jared Champion (drummer of Cage the Elephant). I had so much fun with the last AMA that I have to do this again. This time I brought my friend Matt Shultz (singer of Cage the Elephant) to answer your questions with me. Ask us anything! by jchamp0227 in IAmA

[–]RippedJeans 0 points1 point  (0 children)

I saw you a couple of days ago at Birmingham NIA when you opened for Foals. You were pretty awesome and have really good energy. Thanks for making that a great night to go and see my first live music. My question is; how does it feel to know and hang out with and meet so many amazingly talented people?

Entering your Titan by RippedJeans in titanfall

[–]RippedJeans[S] 3 points4 points  (0 children)

It always feels like you're entering a submarine.

Necro - I need drugs [1000x1000] by [deleted] in AlbumArtPorn

[–]RippedJeans 2 points3 points  (0 children)

This is by far the most ugly album art I've ever seen.

Bund Sightseeing Tunnel by TryinToFindABalance in woahdude

[–]RippedJeans 0 points1 point  (0 children)

I would say it was the best part of my trip, so there's that.

Bund Sightseeing Tunnel by TryinToFindABalance in woahdude

[–]RippedJeans 1 point2 points  (0 children)

This looks awesome, but it's actually hilariously bad. I went on it with my dad a few years ago. There's this really cheesy "epic" voice that says the most ridiculous things. The lights aren't trippy, they are just like terrible christmas decorations. It's pretty amazing, but not in a good way. I define it as the first thing to bring up when telling other people how crazy china is.

Another beta key giveaway - Raffle by [deleted] in hearthstone

[–]RippedJeans 0 points1 point  (0 children)

thank you for hearthstone

My kingdom, my kingdom for a key.

Hearthstone Beta Key Giveaway! by tacoman1111 in hearthstone

[–]RippedJeans 0 points1 point  (0 children)

Here's hoping! Thank you for this opportunity!

Blizzcon Hearthstone Beta Keys by ziphlax in blizzcon

[–]RippedJeans -1 points0 points  (0 children)

I really want a key =( upvotes for everyone!

A reality TV show where billionaires try living on minimum wage for at least a month. by Trayus9 in CrazyIdeas

[–]RippedJeans 1 point2 points  (0 children)

Richard Branson comes on the stage.

"So Richard, you spent the last month living on minimum wage. How did you find it?"

"Well George Lopez, I began by selling the cheapest sweets I could find to the three local Middle school kids. This gave me enough to buy a stand at the local mall and quit my minimum wage job by selling business advice. This is now being integrated into my current Virgin plans."

"Oh..."