Recent Posts

676

Living Room / Re: WinXP is officially dead!

« Last post by rgdot on April 08, 2014, 12:19 PM »

MSE signatures *will* be updated for XP

677

Living Room / Re: WinXP is officially dead!

« Last post by rgdot on April 08, 2014, 08:21 AM »

XP is dead, long live XP

678

General Software Discussion / Re: Working with excel row and columns

« Last post by rgdot on April 08, 2014, 07:59 AM »

Thanks for the help/suggestions, will try/test them.

Pivot tables may be doable but I am not an expert. Not exactly a transpose.

@IainB I should post there, that's true. Not sure what to search for though, I mean what would be the search query, so yes post it is.
@AndyM. One time yes. ~40k rows.

679

General Software Discussion / Working with excel row and columns

« Last post by rgdot on April 07, 2014, 12:21 PM »

Spoiler

Posted this on stackoverflow but my initial question was confusingly worded and by the time I clarified I guess the question got lost in the maze there

I am trying to work with an Excel file (actually using Libreoffice) that is an export of a website content database. Since I am not even sure how to explain the problem I made a small version of what I am trying to do. The real file has many more records of course.

This is what I have:



This is what I need:



Any ideas on how I can do this?

680

Living Room / Re: April 1, 2014

« Last post by rgdot on March 31, 2014, 09:55 PM »

NSA: Log into mynsa dot com to view and download your data

681

General Software Discussion / Re: Firewalls and LAN

« Last post by rgdot on March 26, 2014, 08:07 PM »

Thanks, yes its own firmware supports MAC and IP restrictions similar to that. If all (software on) XP options fail I will go that route

682

General Software Discussion / Re: Firewalls and LAN

« Last post by rgdot on March 26, 2014, 02:20 PM »

I suppose the answer to that is ... not really, other than I want it to be as if it's offline. I don't want to manage it, for example ignore any software updates checks and request.

683

General Software Discussion / Firewalls and LAN

« Last post by rgdot on March 26, 2014, 01:37 PM »

I am trying to set up my XP to use internally within the home network, not for file and printer sharing but screen sharing to access the XP desktop (see Teamviewer in next paragraph). My set up is typical, router (Linksys E2000) to computers.

My reasoning for this is mainly to use Teamviewer's LAN feature (I also tested this with Dukto, a LAN file sharing software).

I thought this would be best served with something for XP as opposed to going into the router settings (Mac blocking, etc.) I came across posts that suggested changing the default gateway on the PC to a 'wrong' 0.0.0.0 address and I guess this is ok. But then I thought I would find lightweight firewalls that might be capable of blocking off the internet and leaving other communication open.

Found PrivateFirewall and an old download of Sygate Personal Firewall that would match the needs (lightweight and XP compatible). They have switches to completely turn off the internet but this affects other processes, for example with Teamviewer set to exclusively accept LAN connections PrivateFirewall still blocks it because I think Teamviewer is still triggering a another process (ntskernl?). I have tried to set exceptions based on internal network (all of 192.168.x.x) and make sure every port and/or exe that Teamviewer (and Dukto) supposedly use to "Allow" and still nope.

I suppose I can use bulkier firewalls like Comodo and see, but ... anyone have any thoughts or ideas?

684

Living Room / Re: How to tell if your cat is plotting to KILL you

« Last post by rgdot on March 24, 2014, 03:19 PM »

685

Living Room / Re: A three drive system - the sweet spot

« Last post by rgdot on March 23, 2014, 03:59 PM »

What are drive image backups doing staying on the PC itself?

686

Living Room / Re: OneNote now on Mac as well, +FREE everywhere, + Cloud service powered.

« Last post by rgdot on March 22, 2014, 07:29 AM »

It is because it's main marketer had no interest in seeing anything but its own logo on their devices, extrapolate that way of thinking into other business decisions and Macs are exactly what he wanted.

687

Screenshot Captor / Re: Flash video capture

« Last post by rgdot on March 20, 2014, 10:23 PM »

You need to try Easy Screencast Recorder https://www.donation...ouser/esr/index.html, though it's not really meant for that task, I think

688

Living Room / Re: OneNote now on Mac as well, +FREE everywhere, + Cloud service powered.

« Last post by rgdot on March 20, 2014, 06:17 PM »

Thanks Jibz, Deozaan and everybody. Setting aside all other concerns (privacy, new notebooks, owning data etc.) I can confirm what Deozaan sees, so as long as the aforementioned concerns are acceptable this is a very good tool for notes on the go.

689

Living Room / Re: OneNote now on Mac as well, +FREE everywhere, + Cloud service powered.

« Last post by rgdot on March 20, 2014, 08:14 AM »

Still haven't seen any restriction so still confused by the original comment.... like I said it may be I have no clue

690

Living Room / Re: OneNote now on Mac as well, +FREE everywhere, + Cloud service powered.

« Last post by rgdot on March 19, 2014, 12:43 PM »

Just synced my desktop notebook to Android and everything is there, I guess that's obvious.  Are they only stored in the cloud only, so this new OneNote won't function if the device(s) are offline (eventhough existing notebooks are synced pre-going offline)?

Yes, I definitely sound like I need an Internet 101 course

691

Living Room / Re: OneNote now on Mac as well, +FREE everywhere, + Cloud service powered.

« Last post by rgdot on March 19, 2014, 10:47 AM »

Not trying to be funny, but I don't get it. No offline notes at all or only in certain cases (created on PC?) it won't be available offline? Colour me confused 

692

Living Room / Re: OneNote now on Mac as well, +FREE everywhere, + Cloud service powered.

« Last post by rgdot on March 18, 2014, 06:02 PM »

^ Installed this 'new' free OneNote on Win7 computer that had no Office/OneDrive (it had trial version of Office when computer was bought but that was uninstalled)
Just its Program Files folder:

693

Living Room / Re: What happens when Hollywood gets involved with a Kickstarter

« Last post by rgdot on March 17, 2014, 05:33 PM »

Not one bit. Kickstarter should not be about established corporations, even though strictly speaking it wasn't them that started this campaign ... actress wanted the movie, etc.

694

General Software Discussion / Re: OneNote is now free

« Last post by rgdot on March 17, 2014, 04:43 PM »

April 1??   

I love this developement

695

Living Room / Re: Facebook likes? How?

« Last post by rgdot on March 12, 2014, 09:58 AM »

Thanks. A bit doubtful facebook apps are responsible, I had around a dozen and all except one were big, active company ones (contest entry, etc) and zero games. I removed most just in case. Will use Ghostery.

696

Living Room / Facebook likes? How?

« Last post by rgdot on March 11, 2014, 07:53 PM »

Over the last few days I began to notice that the Likes section in my facebook has likes that I didn't like, so to speak. I began to worry that my computer is compromised. I have checked every device* including android phone that I have with one or more of Malwarebytes, Avast and ESET online scanner. After seeing that they are clean (hoping so after using the aforementioned tools) I used the Linux machine to change my facebook password and made sure that I am logged out of Facebook everywhere. One day after doing that I log in again and noticed one of such likes again. After a bit of googling I guess I could have visited a comprised site, iframe hack(?), during that one day but I was logged out of Facebook for that day.

 

Any thoughts?

*Except the Linux Mint laptop

697

General Software Discussion / Re: XP to Windows 7 advice

« Last post by rgdot on March 03, 2014, 07:53 PM »

^ Thanks. Learn something new everyday:

the five Office 2013 installations you're allowed with your 365 subscription are each fully functioning local installations and they work just fine online or offline

698

Living Room / Re: Funny Animal Videos

« Last post by rgdot on March 03, 2014, 04:24 PM »

699

General Software Discussion / Re: Software longevity

« Last post by rgdot on March 01, 2014, 05:06 PM »

powerpro is near the top of the list.

700

Living Room / Re: YouTube finally forces creation of google+ A/C to comment

« Last post by rgdot on February 27, 2014, 08:23 PM »

Yes I have. I meant you can't escape giving your real name if you own Android.