Hello Guest

Author Topic: The General Geeky Thread, vol. 2  (Read 332337 times)

fugu13

  • Resident
  • *****
Re: The General Geeky Thread, vol. 2
« Reply #10800 on: August 04, 2014, 09:49:51 am »
Mostly it means yet more evidence the teams google have running product are both not very good and constantly meddled with.

BlackBlade

  • Resident
  • *****
Re: The General Geeky Thread, vol. 2
« Reply #10801 on: August 04, 2014, 11:18:58 am »
TOO MANY NESTED CONDITIONALS!

<brain explodes>
I see an explosion of #name #name and #div0.
I did too, because someone linked it and i'm easy like that. -Rivka

BlackBlade

  • Resident
  • *****
Re: The General Geeky Thread, vol. 2
« Reply #10802 on: August 05, 2014, 08:37:05 am »
I'm trying to plan out my time each day in Excel. What I'd like to do is have the yellow cell under "Time spent" sum all the cells that have an X in the "Done" column.

Here is what my sheet looks like,

http://gyazo.com/91d97a12d741db57f18b6e597b2c8608
I did too, because someone linked it and i'm easy like that. -Rivka

TomDavidson

  • Señor Member
  • *****
Indeed, a flavored hell goes deep sea fishing with some tripod defined by another hole puncher.

BlackBlade

  • Resident
  • *****
Re: The General Geeky Thread, vol. 2
« Reply #10804 on: August 05, 2014, 09:05:16 am »
Yeah, I though sumif. But I'm not sure how to setup the criteria so it looks for an X in the appropriate column and then sums the number.
I did too, because someone linked it and i'm easy like that. -Rivka

BlackBlade

  • Resident
  • *****
Re: The General Geeky Thread, vol. 2
« Reply #10805 on: August 05, 2014, 09:08:06 am »
I've got =SUMIF(E:F,"=x",C:C) but that only seems to Sum the "Not Done" column.

edit: I've removed the Xs from the Not Done column, and am only putting an X when something is done.
I did too, because someone linked it and i'm easy like that. -Rivka

BlackBlade

  • Resident
  • *****
Re: The General Geeky Thread, vol. 2
« Reply #10806 on: August 05, 2014, 09:10:51 am »
I got it working.
I did too, because someone linked it and i'm easy like that. -Rivka

Re: The General Geeky Thread, vol. 2
« Reply #10807 on: August 05, 2014, 01:41:32 pm »
With regards to turning mobile data off on an android phone is data is/only enabled then for wifi? I cancelled my data plan (yay it was free! No fees!) so I want to make sure that data is only used when I'm connected to wifi.

Following that guide works right?
AH WILL NOT BECOME ON'ER YER UNDHEAD MHINIONS!! IF Y KILL MEH, Y'LL HAVE TO KHILL ME F'REAL!!! AH AM AHLIVE!! AH WILL NOT SUFFA BE'N PAHLY DEAHD!! Ohh... Wheapon trails.. Pretty.. -- Largo.

Shigosei

  • Resident
  • *****
Re: The General Geeky Thread, vol. 2
« Reply #10808 on: August 17, 2014, 02:29:50 pm »
I got an old Droid X from my brother and need to replace the battery. Amazon has a bunch for around $7 being sold by various third-party vendors. Looks like more official outlets are selling it for closer to $20. From reading the reviews, it sounds like the ones on Amazon may be somewhat used. I don't have a data plan, so I doubt I'll be using the phone extensively; I'm not sure how important it will be to have really good battery life. Any advice?

Dro_Trebor

  • Resident
  • *****
Re: The General Geeky Thread, vol. 2
« Reply #10809 on: August 17, 2014, 02:39:01 pm »
I don't know specifically about the Droud X, but all of my android phones have developed battery life problems over time. Sometimes it has been because some background apps become activated when the OS updates and it takes awhile for me to figure out what unneeded thing is running done the battery. Other times it has just been that the battery is getting old and tired.

If you don't mind swapping batteries a lot, you can charge one whole using the other, is suppose.

I've had good luck with third party sellers, but I've read bad things as well.

Me, I would take a chance on a cheaper battery, and if it didn't work well, I'd just be out a few bucks.
It's a euphemism.

"Stop and smell the data."- Nate Silver

"I love the smell of confirmation bias in the morning."-Steve Rogers

Yes, but it's clever when I do it.  -Jake

Keith

  • Resident
  • *****
Re: The General Geeky Thread, vol. 2
« Reply #10810 on: August 17, 2014, 10:08:30 pm »
Cheap, non-OEM lithium ion batteries are known to explode or cause fires from time to time.  The chances are low - it's probably not more likely to happen to a typical user than various other risks we accept every day - but decreasing that chance is one of the things you pay for when you spend a bit more on an OEM battery. 
I'm just trying to figure out what it is about not knowing your salary that you're not happy with.
-- Jonathon

fugu13

  • Resident
  • *****
Re: The General Geeky Thread, vol. 2
« Reply #10811 on: August 17, 2014, 10:10:36 pm »
Yeah, I'd always spend on OEM batteries. Even more the case with OEM/licensed chargers -- knockoff chargers have killed people.

Dro_Trebor

  • Resident
  • *****
Re: The General Geeky Thread, vol. 2
« Reply #10812 on: August 18, 2014, 05:56:48 am »
I've had no such problems, but it'd be a good idea to look at where the supplier is based. I think the reports of fires and explosions are all from unregulated suppliers out of Asia.
It's a euphemism.

"Stop and smell the data."- Nate Silver

"I love the smell of confirmation bias in the morning."-Steve Rogers

Yes, but it's clever when I do it.  -Jake

Tante Shvester

  • Resident
  • *****
Re: The General Geeky Thread, vol. 2
« Reply #10813 on: August 18, 2014, 06:59:38 am »
But everything comes out of Asia.  How am I supposed to know who is regulating and being regulated?
If you weren't already in my sig, you would be now - Porter
I want to be buried in clown clothes, so I'll be extra scary in the event of  zombie epidemic. - Captain America
You should always follow your instincts - except for when they are wrong. - Moxie

BlackBlade

  • Resident
  • *****
Re: The General Geeky Thread, vol. 2
« Reply #10814 on: August 18, 2014, 08:16:11 am »
But everything comes out of Asia.  How am I supposed to know who is regulating and being regulated?
I could tell you first hand stories about Chinese manufacturing and quality control that would have you sprinting back to the hospital and checking every single medical device for Made in China markings.
I did too, because someone linked it and i'm easy like that. -Rivka

Shigosei

  • Resident
  • *****
Re: The General Geeky Thread, vol. 2
« Reply #10815 on: August 18, 2014, 09:40:42 am »
The Amazon listings say they're OEM. Whether or not that's true is hard to gauge, of course.

Dro_Trebor

  • Resident
  • *****
Re: The General Geeky Thread, vol. 2
« Reply #10816 on: August 18, 2014, 10:04:12 am »
I would (naively) assume that with Amazon as the supplier of record, you would be safe.

By supplier, I meant to imply the scenario where you went online, through maybe eBay, and picked an item without paying attention to where they shipped from. I've done that and received stuff direct from SouthEast Asia, and it was okay, but it dud make me concerned enough that I didn't leave the power supply plugged in and unattended.

Amazon, even if it is a third party seller, has some reasonable assurance behind it. I think...again, I could be fooling myself.
It's a euphemism.

"Stop and smell the data."- Nate Silver

"I love the smell of confirmation bias in the morning."-Steve Rogers

Yes, but it's clever when I do it.  -Jake

theCrowsWife

  • Resident
  • *****
Re: The General Geeky Thread, vol. 2
« Reply #10817 on: August 23, 2014, 05:43:55 am »
I just got a smartphone for the first time, and I know that there was some talk recently about people's favorite apps. I don't remember which thread it was in, though, and can't find it by searching. Anyone remember where that was?

--Mel
"All we who ask too much and have a dimension too many could not contrive to live at all if there were not another air to breathe outside the air of this world, if there were not eternity at the back of time; and this is the kingdom of truth."

Jake

  • Administrator
  • Resident
  • *****
Re: The General Geeky Thread, vol. 2
« Reply #10818 on: August 23, 2014, 06:32:21 am »
I can't easily link to it because I'm on my phone, but I just bumped the thread for you, Mel. It's over on the Pop Culture side.
So which one of you wants "America in arms against to find places stick and" and which one wants "is an race itself continually new to and"?
Dagonee

GoodyScrivener

  • Resident
  • *****
Re: The General Geeky Thread, vol. 2
« Reply #10819 on: August 26, 2014, 08:03:29 pm »
Any suggestions on a text messaging app that will work with both iPad and Android? Or separate apps for each platform that will talk to each other?  Mini now has an iPad for school, and I'd like to be able to send messages to her from my phone or Nook HD tablet while I'm at work and she's home after school.
I tried that back in the 60s. I'm not even sure where to find rolling papers big enough these days.

Aqua regia: the cure for the Midas touch.

The desire to eat one's offspring is only just barely weaker than the desire to see them survive.

BlackBlade

  • Resident
  • *****
Re: The General Geeky Thread, vol. 2
« Reply #10820 on: August 26, 2014, 08:09:17 pm »
Whatsapp should be what you need.
I did too, because someone linked it and i'm easy like that. -Rivka

GoodyScrivener

  • Resident
  • *****
Re: The General Geeky Thread, vol. 2
« Reply #10821 on: August 26, 2014, 08:16:32 pm »
If I'm reading this right, Whatsapp is only for phone-to-phone communication. Am I maybe missing something?
I tried that back in the 60s. I'm not even sure where to find rolling papers big enough these days.

Aqua regia: the cure for the Midas touch.

The desire to eat one's offspring is only just barely weaker than the desire to see them survive.

BlackBlade

  • Resident
  • *****
Re: The General Geeky Thread, vol. 2
« Reply #10822 on: August 26, 2014, 08:29:37 pm »
Oh my bad. My mind has fused the word texting with phones. There's also Facebook Messenger.
I did too, because someone linked it and i'm easy like that. -Rivka

Nighthawk

  • Resident
  • *****
Re: The General Geeky Thread, vol. 2
« Reply #10823 on: August 26, 2014, 09:27:03 pm »
Wouldn't Google Voice work? It's a website, an app and can send/receive SMS messages.
"When Alexander saw the breadth of his domain, he wept for there were no more worlds to conquer..."

Darklight Interactive - "Omne ignotum pro magnifico"

Scott R

  • Scooter
  • *****
Re: The General Geeky Thread, vol. 2
« Reply #10824 on: August 28, 2014, 06:54:27 pm »
Does anyone know anything about dot net nuke?  I may need to learn some basics very soon and very quickly.
I know not all that may be coming, but be it what it will, I'll go to it laughing.” ― Herman Melville, Moby-Dick

TomDavidson

  • Señor Member
  • *****
Re: The General Geeky Thread, vol. 2
« Reply #10825 on: August 28, 2014, 07:15:07 pm »
I've used it a bit. What will you be doing with it?
Indeed, a flavored hell goes deep sea fishing with some tripod defined by another hole puncher.

Scott R

  • Scooter
  • *****
Re: The General Geeky Thread, vol. 2
« Reply #10826 on: August 29, 2014, 03:16:03 am »
No idea. It was mentioned in passing and out of any kind of context as I was leaving work for the day.
« Last Edit: August 29, 2014, 05:10:53 am by Scott R »
I know not all that may be coming, but be it what it will, I'll go to it laughing.” ― Herman Melville, Moby-Dick

Scott R

  • Scooter
  • *****
Re: The General Geeky Thread, vol. 2
« Reply #10827 on: August 29, 2014, 07:13:41 am »
They've got a free webinar on basic administration; I am now completely knowledgeable about basic admin functions of DNN.

I'ma ask for a raise.
I know not all that may be coming, but be it what it will, I'll go to it laughing.” ― Herman Melville, Moby-Dick

Dro_Trebor

  • Resident
  • *****
Re: The General Geeky Thread, vol. 2
« Reply #10828 on: August 29, 2014, 07:30:49 am »
Go for it!
It's a euphemism.

"Stop and smell the data."- Nate Silver

"I love the smell of confirmation bias in the morning."-Steve Rogers

Yes, but it's clever when I do it.  -Jake

ElJay

  • Moderator
  • Resident
  • *****
Re: The General Geeky Thread, vol. 2
« Reply #10829 on: August 29, 2014, 07:35:58 am »
I think you actually just asked for more work. Have fun!
"MY testicle story is awesome." -quis