Lantyssa
Terracotta Army
Posts: 20848
|
Excel's not really very good at what you are trying to do. It treats each cell as a separate entity. Probably the right thing to do would be to import this into Access or Oracle. Then it would be a true "database" and you could just write SQL to get what you wanted.
Why would you recommend anyone use Access? Did they shoot your dog or something? |
Hahahaha! I'm really good at this!
|
|
|
Yegolev
Moderator
Posts: 24440
2/10 WOULD NOT INGEST
|
I'm actually ignoring both of those in favor of text files.  |
Why am I homeless? Why do all you motherfuckers need homes is the real question.
They called it The Prayer, its answer was law
Mommy come back 'cause the water's all gone
|
|
|
|
DevilsAdvocate25
Terracotta Army
Posts: 321
|
Excel's not really very good at what you are trying to do. It treats each cell as a separate entity. Probably the right thing to do would be to import this into Access or Oracle. Then it would be a true "database" and you could just write SQL to get what you wanted.
Why would you recommend anyone use Access? Did they shoot your dog or something? LOL, no. It's supposed to be a database program and that is really what i was getting at. I did some training on it a year or two ago and it was OK for what it was doing. It doesn't have the functions that Excel has, but it does the SQL bits fine. I messed with the data a little bit and was going to make it a table and then do VLOOKUP off it, but it started getting complicated. I thought about doing IF, but yeah, the easiest way is just to filter and copy and paste It's just tedious and time consuming. |
|
|
|
|
|
ghost
|
It's a real bitch to get documents onto and off of iPads in a seamless fashion. Anyone doing this in a reliable and easy way?
|
|
|
|
|
Yegolev
Moderator
Posts: 24440
2/10 WOULD NOT INGEST
|
Masking tape.
|
Why am I homeless? Why do all you motherfuckers need homes is the real question.
They called it The Prayer, its answer was law
Mommy come back 'cause the water's all gone
|
|
|
rattran
Moderator
Posts: 4258
Unreasonable
|
Use the blue kind. More festive, less residue.
|
|
|
|
|
Merusk
Terracotta Army
Posts: 27449
Badge Whore
|
It's a real bitch to get documents onto and off of iPads in a seamless fashion. Anyone doing this in a reliable and easy way?
icloud, dropbox for ipad or photocopy the screen.  |
The past cannot be changed. The future is yet within your power.
|
|
|
|
Hammond
Terracotta Army
Posts: 637
|
They have a skydrive app for ipads also.
|
|
|
|
|
|
ghost
|
Dropbox is okay. I don't know why they just can't set it up where you can access a shared folder on your local network. My problem is that I already use dropbox for things I don't want the staff to see, so I'll have to move shit around. I was using Sugarsync for general office docs, but they don't seem to have the iPad to Mac conduit down yet. You can get stuff from the mac to the iPad pretty easily. Of course Apple wants you to put shit on iTunes and sync which is just bloody idiotic.
|
|
|
|
|
Merusk
Terracotta Army
Posts: 27449
Badge Whore
|
You're overthinking it.
Create a dropbox account for the iPad using another office e-mail account. Share a folder in it with your personal dropbox that has the files you don't want the staff to see. iPad now has the files you want to share and they pop-up on your PC whenever they're updated.
|
The past cannot be changed. The future is yet within your power.
|
|
|
|
pxib
Terracotta Army
Posts: 4701
|
|
if at last you do succeed, never try again
|
|
|
Signe
Terracotta Army
Posts: 18942
Muse.
|
That was tl:but I read it anyway. I don't know what it was but it's strangely entertaining. I don't know why.
|
My Sig Image: hath rid itself of this mortal coil.
|
|
|
|
Nevermore
Terracotta Army
Posts: 4740
|
|
Over and out.
|
|
|
|
Reg
Terracotta Army
Posts: 5281
|
Hah, that's awesome! The Obama administration is ridiculously good at stuff like that. edit: took out unnecessary political stuff once I realized where I was posting.  |
|
|
|
« Last Edit: January 13, 2013, 02:10:10 AM by Reg »
|
|
|
|
|
|
satael
Terracotta Army
Posts: 2431
|
While the petition itself is silly, it's nice to see the effort they took to give an answer. Even "stupid" petitions deserve an answer if they have enough signatures (since one man's stupid can be another man's serious business)
|
|
|
|
|
Lantyssa
Terracotta Army
Posts: 20848
|
|
Hahahaha! I'm really good at this!
|
|
|
Ssath
Terracotta Army
Posts: 26
|
So, not only is today my 40th birthday, but my 5th child was born this morning.
Best birthday present ever!
|
|
|
|
|
|
ghost
|
Congrats. That's pretty cool. I was born on my dad's birthday too. His is 7/4/47 and mine is 7/4/74. Weird.
|
|
|
|
|
Signe
Terracotta Army
Posts: 18942
Muse.
|
|
My Sig Image: hath rid itself of this mortal coil.
|
|
|
|
ghost
|
My house is fully of 20 plus 4 year olds and their parents. There isn't enough alcohol for this. |
|
|
|
|
Evildrider
Terracotta Army
Posts: 5521
|
Gratz Ssath!
Oh and Ghost, situations like that are why I still smoke weed.
|
|
|
|
|
|
ghost
|
There isn't enough weed, either. |
|
|
|
|
rattran
Moderator
Posts: 4258
Unreasonable
|
Just add some hits of nitrous.
|
|
|
|
|
bhodi
Moderator
Posts: 6817
No lie.
|
ubisoft's launcher is such a piece of shit. Apparently the new one doesn't allow + in the email address field. Which is a problem since that is my registered email. I had to go in and change it, but the launcher still doesn't work. God, fuck that company so hard. Finally had to reset and recreate a password for it to work. How can they be so incompetent?
|
|
|
|
« Last Edit: January 14, 2013, 08:15:18 AM by bhodi »
|
|
|
|
|
Bunk
Contributor
Posts: 5828
Operating Thetan One
|
Email is a finicky thing. We just (like ten minutes ago) found a bug in our system where if you create an email address for a contact with three w's in it, it appends http:// in front of it in the contact record.
|
"Welcome to the internet, pussy." - VDL
"I have retard strength." - Schild
|
|
|
Tale
Terracotta Army
Posts: 8567
sıɥʇ ǝʞıן sʞןɐʇ
|
|
|
|
|
|
Ingmar
Terracotta Army
Posts: 19280
Auto Assault Affectionado
|
What's good about a mentally ill guy and a mistreated dog?
|
The Transcendent One: AH... THE ROGUE CONSTRUCT.
Nordom: Sense of closure: imminent.
|
|
|
rattran
Moderator
Posts: 4258
Unreasonable
|
Jury Duty sucks. I'm feeling contempt and disdain for the whole system already, and it was only day 1.
Woohoo, $13 a day nearly covers parking and a cup of coffee!
|
|
|
|
|
Trippy
Administrator
Posts: 23657
|
It's better when you are the foreperson and can boss people around |
|
|
|
|
Signe
Terracotta Army
Posts: 18942
Muse.
|
Just boss them around anyway.
|
My Sig Image: hath rid itself of this mortal coil.
|
|
|
rattran
Moderator
Posts: 4258
Unreasonable
|
At the rate the voir dire is going, the jury won't even be chosen for days. It's a combo of slow, repetitive questions, and slow, repetitive lawyers.
|
|
|
|
|
Der Helm
Terracotta Army
Posts: 4025
|
What's good about a mentally ill guy and a mistreated dog?
Well, not good, but hilarious. After making his getaway on the bulldozer, he had driven so slowly that a 5km tailback built up behind him on the motorway. |
"I've been done enough around here..."- Signe
|
|
|
IainC
Developers
Posts: 6538
Wargaming.net
|
I like that the related links for the article include the German Hells Angels website.
|
|
|
|
Sky
Terracotta Army
Posts: 32117
I love my TV an' hug my TV an' call it 'George'.
|
Just got a random email from our library contact form on the website. My best friend from 4/5th grade trying to find me :) Such an awesome day!
|
|
|
|
|
Rasix
Moderator
Posts: 15024
I am the harbinger of your doom!
|
He needs a place to crash for a few days.
|
-Rasix
|
|
|
|
Author
