Sign in to your account



This field is required


forgot your password?


New to the site? Create an account →

Blog Comments · page 171

Commenting on Dec 8th, 2017 at 11:09:25 am

keamoose keamoose · Dec 14, 2017 at 10:16 am

I’m unreasonably proud of this joke.


Commenting on Don't change the Excel

keamoose keamoose · Dec 14, 2017 at 10:15 am

Ouch. Funny thing with this one is, I did copy and paste it and there is no reasonable explanation for how it could have changed.


Commenting on Okay. This is getting out of hand.

tcr! tcr! · Dec 14, 2017 at 7:15 am

Dogs can get a little possessive with where they’ve decided to nap 😊


Commenting on Don't change the Excel

tcr! tcr! · Dec 14, 2017 at 7:13 am

I do my monthly payables/receivables in Apple’s Numbers.app. I have formulas to calculate my monthly budget, how much I can spend per week, day, etc. based on what’s coming in and what’s going out.

So one month according to my calculations I could live pretty high on the hog. But then when my bank account overdrew I soon realized a formula typo had given me an inflated sense of financial luxury.

I shallwould forevermore pay much closer attention to when copying and pasting cell formulae.


Commenting on Dec 8th, 2017 at 11:09:25 am

tcr! tcr! · Dec 14, 2017 at 7:08 am

🤣 🤣


Commenting on Be in love with someone.

tcr! tcr! · Dec 14, 2017 at 7:07 am

Marilyn’s got a pretty nice sweater in those videos.


Commenting on Okay. This is getting out of hand.

jimi hindrance experience jimi hindrance experience · Dec 14, 2017 at 1:48 am

I see the same thing everyday with Eorr and the girls. Stella would like to sit on her kneck and Phoebe won’t leave her lap.


Commenting on Okay. This is getting out of hand.

tcr! tcr! · Dec 13, 2017 at 10:22 pm

Now they’re both in bed with me. #neveralone

Cats on the bed a few minutes later


Commenting on Okay. This is getting out of hand.

tcr! tcr! · Dec 13, 2017 at 9:59 pm

I kicked them off and now Mirah is laying over there by her lonesome.

Mirah by her lonesome


Commenting on Pearl on my side

tcr! tcr! · Dec 13, 2017 at 5:24 pm

Pearl on my side 4


Commenting on Don't change the Excel

keamoose keamoose · Dec 13, 2017 at 5:14 pm

By the way, your IsNumeric code worked great, thanks :)


Commenting on Don't change the Excel

keamoose keamoose · Dec 13, 2017 at 4:27 pm

You know what’s REAL FUN? Realizing that for the past 2 hours the entire problem has been a typo in a cell reference. Ok, back to the copper thing.


Commenting on Don't change the Excel

keamoose keamoose · Dec 13, 2017 at 4:07 pm

Cool, I’ll give that a try!

I’m in deep trouble right now with a 2-dimensional lookup where I have to round the input in order to look it up. I AM LEARNING SO MUCH.


Commenting on Don't change the Excel

tcr! tcr! · Dec 13, 2017 at 3:50 pm

Also, getting oneself in trouble is half the fun!


Commenting on Don't change the Excel

tcr! tcr! · Dec 13, 2017 at 3:47 pm

I think you should be able to do something like…

Dim HardnessCheck As Boolean

HardnessCheck = IsNumeric(hardness)

If HardnessCheck Then
  Copper = 👍
Else
  Copper = 👎
End If

But keep in mind I haven’t been on Windows intentionally or in VB for literally years.


Commenting on Dec 8th, 2017 at 11:09:25 am

keamoose keamoose · Dec 13, 2017 at 3:41 pm

H8ers gonna H8.


Commenting on Dec 8th, 2017 at 11:09:25 am

tcr! tcr! · Dec 13, 2017 at 3:39 pm

What about E. coli O157:H8?


Commenting on The People of Alabama will do the right thing

tcr! tcr! · Dec 13, 2017 at 1:51 pm

Yep, asshole indeed. I saw this on FB a few minutes ago:

http://mcimaps.com/sweet-home-alabama-how-doug-jones-won/


Commenting on The People of Alabama will do the right thing

keamoose keamoose · Dec 13, 2017 at 12:44 pm

What an asshole. Write-in votes. Cheeto Hitler at his finest.

DQ5Zi23UMAAZYWr jpg large

DQ5afp UMAAdsUS


Commenting on Don't change the Excel

keamoose keamoose · Dec 13, 2017 at 12:12 pm

Haha, awesome :)
Do you remember any of it? I’d like to know how to make my function check whether the input is non-numeric, the issue being that the lab data it’s working with will sometimes have gaps in it, so the input cell might be blank or say ND (non-detectable) or something like <0.001 (less than the lowest amount the lab can measure). Right now I’ve settled for making the cell only accept numbers, but that will be a pain in the ass for entering the lab data because it won’t let you paste it in if it happens to be non-numeric. So, e.g. I have =COPPER(A1) and cell A1 is restricted to numeric data only, but I’d prefer that the COPPER function be able to check and return an appropriate value if A1 has something that isn’t a number or if it’s blank.

…I’m not a programmer. I know just enough to get myself in trouble. :P