Recent Posts

326

DC Gamer Club / Re: Amnesia: The Dark Descent for free during the next 24 hours (Sep. 15, 2015)

« Last post by Target on September 16, 2015, 12:17 AM »

not exactly my genre, but I had a look at one of the trailers - almost P'd myself when the person opened a door, then ran away and hid in a cupboard!!

perhaps that's a testimony to the game

327

General Software Discussion / Re: Test cell value for BLANK in Excel and take action (or not) based on it

« Last post by Target on September 11, 2015, 01:38 AM »

OK, let see what we can do here....

the simple answer is to substitute the formulas in columns C and D for the XXXX so the formula now becomes

   C3=if(trim(a3&B3) = "","",(LEFT(md5hash(A3&B3),8))

of course this doesn't cater for the situation where the (damn!!) user enters the same value twice, so

   C3=if(trim(a3&B3) = "","",if(trim(A3) = trim(B3), "GODAMMIT, I TOLD YOU NOT TO PUT THE SAME VALUE IN BOTH FIELDS, NOW GO BACK AND DO IT PROPERLY",(LEFT(md5hash(A3&B3),8))

this will test if the fields match (and prompt the user), or are empty, and do nothing).  Match this up with some conditional formatting and you've got a pretty good flag

Of course as IanB pointed out data quality is a key consideration, eg what are the criteria for generating the values in Ax and Bx?  Do they have to be numeric, or alpha, or alphanumeric?  Do they have to be a certain length, or within a set length (ie 6 to 8 chars), and so on.  Answering those questions in as much detail as possible will enable you too better refine the rulesets

328

General Software Discussion / Re: Test cell value for BLANK in Excel and take action (or not) based on it

« Last post by Target on September 10, 2015, 12:00 AM »

=if(trim(a3&B3) = "","",XXXX)?

this will check both Ax AND Bx for a value, and return nothing if true, or XXXX if false

still too many variables for me to say with any certainty (I can still think of several possible scenarios/solutions).

To work correctly, both A and B have to be a "real" value of some kind and if either one is empty it means somebody didn't fill in the sheet correctly

this infers some sort of some sort of data validation rules could be applied which might solve some (if not all) of your data quality issues.

329

Post New Requests Here / Re: I input a CSV file and you tell me if X is within the range of Y.

« Last post by Target on September 09, 2015, 04:36 PM »

can you provide some dummy data sets? and the 'matching' criteria?

330

Official Announcements / Re: Forum Upgraded August 30, 2015 - Report issues here

« Last post by Target on September 08, 2015, 06:00 PM »

I find that there isn't enough contrast between pinned threads and everything else (eg the living room) particularly when viewed on a small device (like my 10" netbook).  Did the old format have a dedicated icon (I can't remember, but it was quite plain)

-Target (September 07, 2015, 07:15 PM)

Check again now please (make sure to F5 to reload css).

-mouser (September 08, 2015, 05:58 AM)

contrast is the same, but the pins are quite plain

many thanks!!

331

Official Announcements / Re: Forum Upgraded August 30, 2015 - Report issues here

« Last post by Target on September 07, 2015, 07:15 PM »

could be this has already been discussed but I couldn't see it

I find that there isn't enough contrast between pinned threads and everything else (eg the living room) particularly when viewed on a small device (like my 10" netbook).  Did the old format have a dedicated icon (I can't remember, but it was quite plain)

Not a biggy by any means, it just takes me a bit longer to get to the 'current' threads

332

General Software Discussion / Re: HELP! AMD Catalyst update broke my PC - How best to reinstall Windows 7?

« Last post by Target on September 06, 2015, 11:59 PM »

If you can boot into Safe Mode see if you can remove the AMD Catalyst drivers and your AV program, (to stop it interfering in any other operation - the AV will cease to function after an In Place Upgrade anyway.)  This might allow the system to boot normally and you'd only need to reinstall any necessary drivers and your AV.

-4wd (September 06, 2015, 11:26 PM)

+1 for this

I've had experience with both AVG and Catalyst borking updates so I'd try this first.

and as a rule I just install the video drivers instead of the entire catalyst suite

333

General Software Discussion / Re: Test cell value for BLANK in Excel and take action (or not) based on it

« Last post by Target on September 03, 2015, 12:35 AM »

there are probably dozens of ways to do this, but without knowing more about your particular case you can try this (obviously this is for cell Cx)

=if(aX = "","",XXXX)

334

Announce Your Software/Service/Product / Re: Context Note

« Last post by Target on August 26, 2015, 05:36 PM »

And there are subtle issues when you do like it so much you create like 400 stickies over time.

-TaoPhoenix (August 26, 2015, 04:53 PM)

I think you might have misunderstood the term 'subtle'

335

General Software Discussion / Re: Firefox Extensions: Your favorite or most useful

« Last post by Target on August 25, 2015, 11:14 PM »

trying it now - interesting experience actually.  Tried 2 separate downloads from sourceforge on 2 different machines and while they 'installed' they wouldn't run.  After a bit of hunting around sourced from the cyberfox site and it's running (with onetab installed!!).  Time will tell if it's any better than native FF I suppose

-Target (August 25, 2015, 06:18 PM)

so this is getting bizarre - been running cyberfox today with onetab and noscript only.  Onetab was there this morning but has since vanished.  It's still installed, but no functionality is exposed.  wtf?

336

General Software Discussion / Re: Firefox Extensions: Your favorite or most useful

« Last post by Target on August 25, 2015, 06:18 PM »

Perhaps give Cyberfox Portable a go, I just copied my profile from PM and then installed OneTab and everything worked, (except PM specific add-ons, to be expected).

https://cyberfox.8pecxstudios.com/

-4wd (August 25, 2015, 04:32 AM)

trying it now - interesting experience actually.  Tried 2 separate downloads from sourceforge on 2 different machines and while they 'installed' they wouldn't run.  After a bit of hunting around sourced from the cyberfox site and it's running (with onetab installed!!).  Time will tell if it's any better than native FF I suppose

337

General Software Discussion / Re: Firefox Extensions: Your favorite or most useful

« Last post by Target on August 25, 2015, 02:04 AM »

To add insult to injury, I just installed FF 40.0.2 as a test and OneTab installed fine

-4wd (August 24, 2015, 08:41 PM)

maybe it's the portable part - just setup a fresh copy and it still doesn't work 

and FWIW I can't use a full install in this situation

338

General Software Discussion / Re: Firefox Extensions: Your favorite or most useful

« Last post by Target on August 24, 2015, 08:11 PM »

ok, I already had that setting in config, and I installed the tester tools app - net result was nil

seems like that addin might be a bit flakey (then again, FF might be being over zealous)

given the increasingly unstable nature of firefox it's looking like I'm going to have to change browsers.  trouble is, FF is the only one that seems to match some significant parts of my work flow 

339

Living Room / Re: silly humor - post 'em here! [warning some NSFW and adult content]

« Last post by Target on August 24, 2015, 04:43 PM »

Details seem missing from the story.

I agree.  Details seem a bit sketchy.

He was quick on the draw.
 

-cranioscopical (August 23, 2015, 12:26 PM)

It was only penciled in at the time.

-wraith808 (August 23, 2015, 02:07 PM)

Canvasing the comments has proven quite interesting.

-MilesAhead (August 23, 2015, 04:47 PM)

I still wouldn't draw any conclusions from it. I'd wait until we get the complete picture.

-x16wda (August 23, 2015, 05:34 PM)

I see the fountain of wisdom in that penning.

-wraith808 (August 23, 2015, 06:10 PM)

I think it's time that somebody here took the lead.
 

-cranioscopical (August 23, 2015, 11:18 PM)

All is well that pens well.

-MilesAhead (August 24, 2015, 06:51 AM)

That's penning review.

-wraith808 (August 24, 2015, 07:19 AM)

where there's a quill there's a way

340

General Software Discussion / Re: Firefox Extensions: Your favorite or most useful

« Last post by Target on August 24, 2015, 01:34 AM »

huh, it seems onetab won't work for me no way no how (FF40.0.2 portable).

it seems to install ok, but no controls or menus are exposed so if it is there I can't interact with it.

Tried disabling ALL addins, changing to the default appearance, etc, and no go 

sure would like to recover some resources...

341

General Software Discussion / Re: win update issues

« Last post by Target on August 20, 2015, 01:27 AM »

These may help you get back on track -

https://support.micr...67#/en-us/kb/2700567

http://pcsupport.abo...ws-update-frozen.htm

The Microsoft Fix It (first link) worked for my Vista Home Premium update freezes.

-crabby3 (August 20, 2015, 01:08 AM)

nope, the fixit tool...didn't.  And FWIW there are apparently 2 versions, one of which can be more 'aggressive' in its actions

342

General Software Discussion / Re: win update issues

« Last post by Target on August 20, 2015, 12:38 AM »

it never fails... within about 30 mins of posting this it started to update 

that said, i'm not at all confident that the issue has resolved itself 

343

General Software Discussion / win update issues

« Last post by Target on August 19, 2015, 11:55 PM »

looking for assistance in resolving a win update problem (essentially it doesn't)

On my win7 SE netbook windows update performance (?) has deteriorated over time, such that it hasn't displayed progress for some time, and has now refused to download or apply updates altogether.

I've googled and it appears to be a relatively common issue, but none of the common fixes seem to work in this case (ie it's been sitting on the desk for the last 6+ hours 'updating' without change - no progress, no change)

Anyone here got any suggestions (other than a rebuild)

344

Living Room / Re: silly humor - post 'em here! [warning some NSFW and adult content]

« Last post by Target on August 17, 2015, 12:59 AM »

How to vote?

-Renegade (August 17, 2015, 12:37 AM)

the ultimate rick-roll?

345

Non-Windows Software / Re: Thoughts on "next generation" forum systems? (Discourse, nodeBB, etc.)

« Last post by Target on July 20, 2015, 05:29 PM »

Isn't the difference in the attention span of the respective audiences? (and consequently the content)

-Target (July 20, 2015, 12:30 AM)

This has a lot of words in it! Can you make it simpler? Like in a meme gif?

-TaoPhoenix (July 20, 2015, 04:01 PM)

346

Non-Windows Software / Re: Thoughts on "next generation" forum systems? (Discourse, nodeBB, etc.)

« Last post by Target on July 20, 2015, 12:30 AM »

isn't the difference in the attention span of the respective audiences? (and consequently the content)

347

Post New Requests Here / Re: Script for replace any substring in a text file accodring a csv data file

« Last post by Target on July 08, 2015, 12:34 AM »

In my case i think is simpler. I need only one parameter.

-Contro (May 04, 2015, 08:28 AM)

simpler than that...

this is (untested) in AHK...

[Select]

inputbox, srch, Search String                      ; get a search string

inputbox, rep, Replacement string                  ;get a replacement string

fileselectfile, tmp_,,,Select a file, CSV(*.csv)   ; select a csv file

fileread, tmp_2, %tmp_%                            ; read in to a variable

stringreplace, %tmp_2%, tmp_2, %srch%, %rep%, all  ; replace all occurrences of the srch string with the rep string

fileappend, %tmp_2%, %tmp_%.csv                    ; write out to a new file

exitapp

348

Living Room / Re: Interesting "stuff"

« Last post by Target on June 30, 2015, 07:56 PM »

do androids use robotic dogs to round up sheep? (sorry,very weak pun )

Sony's robotic dogs are dying a slow death

349

General Software Discussion / Re: Software for planning wood bookcases/cabinets/tables etc?

« Last post by Target on June 24, 2015, 07:09 PM »

nice job, but now I want to look through your record collection

350

General Software Discussion / Re: automatically number images in word

« Last post by Target on June 23, 2015, 06:33 PM »

here's a word vba macro that will number the images for you

[Select]

Sub captions()
Dim i As Integer

For i = 1 To ActiveDocument.InlineShapes.Count
    If ActiveDocument.InlineShapes.Item(i).Type = wdInlineShapePicture Then
        ActiveDocument.InlineShapes(i).Select
        Selection.InsertCaption Label:="Figure", Title:=" - This is image #" & i, Position:=wdCaptionPositionBelow
    End If
Next i
End Sub

google is your friend...