You'll love this one...!! A book club & more discussion
note: This topic has been closed to new comments.
Off Topic Chat
>
Watcha Doing? Version 2015.5

I'll stop spamming this thread now :)"
Woohoo Peggy! :D

A truer word has never been said. Love the place, Peggy. Crossing fingers and toes for you. And good work for being so productive today!

It wouldn't be for a few months but now I'm not sure if I should keep applying for jobs here as we would be moving to northern Virginia. Hubby may be up for a job with his company but he could also be up for another job here as well. Good thing I haven't found anymore jobs to apply to lately anyways :)
I wouldn't mind moving again...I like living in bigger cities anyways :)


Yes, I agree with Stephanie. I think with house hunting you have to be quick and ruthless! ;)


Good luck on the house, Peggy! It is beautiful. I really hope it works out for you!
Wow, Sarah, I wish I could manage to get half that much done on my days off. This past Sunday I was planning to be super productive and get the house spotless (or at least less spotty lol), but I ended up spending most of the day curled up in the recliner reading. It was national book lovers' day, so I thought it was an appropriate way to spend the day! :D

That sounds like the BEST way to spend a Sunday :-)
I have 2 more hours of Excel studying/learning...tomorrow begins Powerpoint!!

@Sarah - come visit me now. I can put your productivity to work.
@Travis - lol! Life in the fast lane.
@Stephanie - enjoy the studying.

Thanks :-) I am officially done with with Excel!! My brain is numb so no more schoolwork for me tonight!

I agree with Stephanie! An ideal Sunday! Hoping to engage in some good lounge chair surfing myself during this weekend's 24 hour toppler :)
Glad you took some time for relaxing, KimeyDiann. That audit stuff preparation is some stressful stuff. I think it's very normal to feel more emotionally tapped out during such a time.
Lovely house, Peggy. Good luck. Hope you guys get it. Good for you to be proactive. When you really want something, go for it!
Stephanie, another move... Sigh... You're going to be a pro at this soon, lol. I moved a bunch in my twenty somethings. Not so difficult then as i didn't have much furniture or belongings.
Such a hassle now. My husband is a big collector of audio stuff. He has multiple sets of massive speakers and tons of other equipment. And of course walls and walls of recordings of assorted types. The old vinyl LPs take up the most space. Carrying those thoings upstairs at our current house when we moved 4 years ago really wore us out.



@Peggy, the house is beautiful! I hope you are luckier this time!
@Stephanie, I'm sure you are an expert in moving by now. You should convert this experience and know-how in an income!

A question for the bloggers here. I have been thinking for a while (more than a year maybe?) in doing a blog focused in reviews of children books, from picture books to middle schoolers books. What do you recommend to use? Google's blogger? WordPress? I'm absolutely illiterate in this, so any tip counts.
I finally opened a NetGalley account yesterday and got my first children book to read and review, Ghostly Thief of Time: An EMU Club Adventure. I plan to read it with my 10 years old son when we finish Who Was That Masked Man, Anyway (which is being great BTW). He says he doesn't like to read, and says reading 30 minutes daily is a penitence. So we are trying a shared read aloud time, and it's working. We read one chapter each. I'm surprised of hearing him repeating expressions from the books we read when playing. Ex: "Keep your eyes peeled". :)


@Peggy - Lovely house. Fingers crossed for you.
@Stephanie - I haven't moved in 37 years.
@Travis - LOL - can't imagine!
@Lisa - cloudy here too - no shooting stars
@Sarah - way to get things done. I am a terrible procrastinator. Any excuse to read and I am there.

Well I'm not feeling so motivated today. Plus it's raining outside so I think I'll take it a bit easier today. I want to get my coursework done for a course which I did 3 years ago. There was no formal deadline for it and because I wouldn't get the certificate for it anyway until I finished paying it off (June this year) then I kept on putting it off. Now I'm all paid up, I want to get it handed in and get my certificate then it's all done and dusted.


Peggy, any news on the house?

We won't know if we are for sure for another couple of months :)


Yes, blogger is google's now. I heard that is easier to use than wordpress too, but wordpress has more options for customization. Since I don't now nothing about blogging, the easiest the best, I guess. Thanks for the tip, Sarah.

We won't know if we are for sure for another couple of months :)"
got it. :)

My younger kids went back to school yesterday, this was a very short summer, my oldest has another month until he's off to college :-) I think I'm ready!

My younger kids went back to school yesterday, this was a very short summer, my ol..."
I wouldn't mind moving again..especially if we move to a bigger city. After we lived in Omaha and then back in Spokane and now in Charlottesville, I miss living in a big city like Omaha :)

Just keep moving, moving, moving! :( would it be a promotion for Jamey or just something else he'd rather do? Where in VA?
How was excel? I work most my day in it, just trained by Google though haha

Just keep moving, moving, moving! :( would it be a promotion for Jamey or just something else he'd rather do? Where in VA?
How was excel? I work most my day in it, just trained by Google t..."
Hi Melissa!!!!!
It would be a promotion of sorts for him :) we would have to move to Northern VA..maybe Woodbridge, Vienna, Manassas...closer to DC anyways :)
Excel was dreadful lol! Do you use PivotTables and PuvitCharts? I just don't get them, lol!
I'm on to PowerPoint now..I wonder if I will remember any of it from high school :)

I work a lot with vlookups, lots of data and spreadsheets and numbers and margins...I can't believe all the things Excel can do and I know I know just a tiny bit of what it is capable of...
Well, good luck to you guys, sounds like you're up for the change and to get a promotion (of sorts) I think sounds promising for your future! :) Probably lots of dog parks although where you're at now sure seems dog friendly!

Yes, where we are now is very dog friendly. It will be interesting if we do move :) but we could also be staying here.
I can't wait though to see you and the rest of the gang in just a few months :) I'm still not sure what the plans are though! I just know we fly to Spokane in just under 2 months:) it will be the longest I have been away from Blake :(


The accounting software I use at work has a feature that allows you to export reports to excel. This can be a great feature, but sometimes it is a bane. I have to give the auditors that are coming a specific report that looks like a job cost report but only includes the costs I billed for (bc they don't need to see the costs I didn't bill for). The problem is, this report isn't balancing to what I actually billed because of the way some of the cost was put into our system.
I have exported this report so I can input the missing data, but the way the system exports it, there are all of these merged cells and hidden rows. All of that has to be unmerged and the rows unhidden, which would normally take four mouse clicks and done. I guess because of the massive size of this report (over 800 pages and 30,000 rows), fixing it the normal way makes excel freeze. Which means I have to shut it down and restart. I tried doing half of the document: freezes. A quarter: freezes. I ended up having to do it in 200-800 row increments. That worked most of the time, but occasionally it would mess up again and because I was only saving every 5 minutes or so, I would have to redo a bunch again. After the third or fourth time this happened, I started saving after every single mouse click.
That finally worked and now I have over 2000 pages of data ready to balance to another spreadsheet I created that shows actual billed labor. I just reopened this spreadsheet and realized that even though I distinctly remember saving my work, over half of the data I entered is gone!!!! Apparently when excel froze earlier this morning, it somehow lost the couple of hours worth of work I had put into the second spreadsheet as well.
I don't know if I want to scream or cry. Instead of either, I ate a chocolate chip cookie and came to GR to relax my brain for a few minutes.
And once again, I'm sorry for the super long post! Venting helps and since Stephanie was talking about her excel class, I thought I'd share my nightmare day. :/

What are "vlookups" and "hlookups?" That terminology isn't ringing a bell in my half-brain-dead state right now. LOL.

The poor pup next door is whining! So so sad...it started doing that yesterday when the neighbors left :( I think it is new to being home alone for a bit:( I can hear it through our door and it breaks my heart..I wish Blake liked other dogs (he only likes his gf back in Spokane). Is offer to watch it while they were gone.

Hlookup per Google is: Excel HLOOKUP function can be used when you are dealing with huge datasheet and need to look up the values of the specific record. HLOOKUP stands for Horizontal lookup, used to find specific data from the datasheet. Unlike VLOOKUP function, it looks for the values horizontally which enables the user to extract a complete record. This post elaborates how & where you can use HLOOKUP function.
Not that I really understand any of that yet..


Thanks, Sandra. I'm calling it a day now... but packing up my computer so I can work from home over the weekend. Boo. :(

Hope you are able to get some relaxing in this weekend, KimeyDiann!

KimeyDiann, I also export mass amounts of data to excel from our directory and financial records. Sometimes it's such a dump because there are only so many ways to refine your parameters. I feel your pain! Even though I've never done a data dump even close to the size you are describing.

I use PivotTables all the time now, after not knowing about them at the beginning of the year. I needed to know how to use them for a job interview, so I just googled some YouTube videos. Recommend this Stephanie if you're a bit like me and need to see how it's done.
They are so bloody useful now I know how to use them. I'm using them to analyse the entire University's enrolments (so 20 000 students and up to 8 courses a year each), so a normal sheet would be ridiculous.


http://nomadicstate.com/
This topic has been frozen by the moderator. No new comments can be posted.
Books mentioned in this topic
It Starts with Food: Discover the Whole30 and Change Your Life in Unexpected Ways (other topics)The Whole 30: The Official 30-day Guide To Total Health And Food Freedom (other topics)
Fortunately, the Milk (other topics)
Fortunately, the Milk (other topics)
Where the Sidewalk Ends (other topics)
More...
Authors mentioned in this topic
Gillian Flynn (other topics)Fiona Wood (other topics)
Jay Feldman (other topics)
Kevin Hearne (other topics)
Cherie Currie (other topics)
I'll stop spamming this thread now :)