Oh no! More boring computer problems! Oh no!

Message Bookmarked

Bookmark Removed

Not all messages are displayed: show all messages (1739 of them)

You could end up paying a couple of hundred I reckon.

I can rescue you enough bits from the dump pile at work to make you a desktop. What apps do you need to run?

― Ed (dali), Monday, 12 June 2006 14:48 (twenty years ago)

I HAVE A QUESTION!

what are people using to tag and organise their digiphotos? Picasa seems to be surprisingly crappy. i know it's free and all, but really...

― Slumpman (Slump Man), Monday, 12 June 2006 21:29 (twenty years ago)

adobe bridge is great for professional use, i think.

― Sterling Clover (s_clover), Monday, 12 June 2006 22:11 (twenty years ago)

I installed Adobe Photoshop Album (which seems perfect and easy to use).

Now i just need to decide what sort of tags are sensible to use. People in the shot, place taken and year for starters...

― Slumpman (Slump Man), Tuesday, 13 June 2006 15:42 (twenty years ago)

Okay ILX, help me from tossing my laptop out the computer. Anyone know Excel?

I have a file with three sets of scores that are from 3-15. I would like to highlight any score that is more than 4 points from the other scores to get a list of ones that deviate highly.

I have gotten as far as knowing that I need to do Conditional Formatting and select Formula, but I cannot for the life of me get a formula that works. The ranges of the scores are C3:C300, D3:D300, and E3:E300.

Can anyone help puhleaze???

― Aaron W (Aaron W), Friday, 16 June 2006 18:25 (twenty years ago)

Why is Excel designed to only be used by people with engineering degrees? Eff you Bill Gates. I'm glad you're stepping down!!

― Aaron W (Aaron W), Friday, 16 June 2006 18:39 (twenty years ago)

Hint: people with engineering degrees don't use excel

― lord pooperton (ex machina), Friday, 16 June 2006 18:44 (twenty years ago)

Dammit I thought you were going to tell me how to set this up. Yeah, but if I did have an engineering degree I could figure out how to create a super simple formula.

― Aaron W (Aaron W), Friday, 16 June 2006 18:45 (twenty years ago)

aaron w, have you tried conditional formatting? i use it on a "scorecard" that measures different performance measures at our facilities.

― otto midnight (otto midnight), Friday, 16 June 2006 18:46 (twenty years ago)

aaron w, obviously i have a reading comprehension problem.

― otto midnight (otto midnight), Friday, 16 June 2006 18:50 (twenty years ago)

ok, you're looking to highlight any score that is more than 4 points from the other scores. what other scores? what are the baseline scores? i'm not sure what you're comparing.

― otto midnight (otto midnight), Friday, 16 June 2006 18:53 (twenty years ago)

Thanks in advance for the help.

So, there are three sets of scores, and I'd like to highlight any that are +/- 4 points away from the other scores... Kind of a real basic standard deviation analysis.

Here's as far as I have got, but I have a feeling I'm a long way off. For the C2:C300 range, I am using...

=NOT(D2:D300+3)OR(D2:D300-3)OR(E2:E300+3)OR(E2:E300-3)

Of course this doesn't work.

― Aaron W (Aaron W), Friday, 16 June 2006 18:55 (twenty years ago)

I went with 3 instead of 4 away, but hopefully you get the drift.

― Aaron W (Aaron W), Friday, 16 June 2006 18:57 (twenty years ago)

yeah i'm trying and can get it work in a single cell but it logic takes a step out the fucking window when i try to apply it to a range of cells. more as it develops.

― otto midnight (otto midnight), Friday, 16 June 2006 19:16 (twenty years ago)

Thanks for your help. I'm still playing around with it as well. Of course, with all the time I've spent on this I could've just manually gone through all the scores. Blurgh!!

― Aaron W (Aaron W), Friday, 16 June 2006 19:20 (twenty years ago)

this isn't even my stuff but i know i've done this before but it was so long ago i forget. i don't think i used a formula, i think i used cell value is equal to/does not equal but whatever. this is pissing me off and i have to figure it out.

― otto midnight (otto midnight), Friday, 16 June 2006 19:29 (twenty years ago)

Well at least I've ruined two people's days.

― Aaron W (Aaron W), Friday, 16 June 2006 19:30 (twenty years ago)

i can get it to work on a single cell but it won't let me do a range. when i use the format painter to copy the formatting it applys the formatting of the original range. so wile for cell C3 i have for condition one cell value is not between =$D$3-3 and +D$3+3 (then i have it set to format it with a bright green cell fill) then condition 2 cell value is not between =$E$3-3 and =$e$3+3 it will work in c3. but when i use the format painter to apply the formatting to cells c3:c9 it still uses D3 and E3 in the formatting.

fuck this i need a goddamn drink. 52 minutes til quitting time, i can be in a bar in 90 minutes.

― otto midnight (otto midnight), Friday, 16 June 2006 19:38 (twenty years ago)

Oh don't waste any more time with it! Thanks for your help, and please do go have a drink!!

― Aaron W (Aaron W), Friday, 16 June 2006 19:41 (twenty years ago)

when/if you figure it out post it here!

wait a minute, why don't i just go into that damn scorecard and see how i did it?

― otto midnight (otto midnight), Friday, 16 June 2006 19:47 (twenty years ago)

actually the scorecard isn't much help as i'm comparing facility scores to a set criteria. that's why i was able to use the format painter last time.

good luck.

― otto midnight (otto midnight), Friday, 16 June 2006 19:48 (twenty years ago)

Yeah I'm giving up. Cheers!

― Aaron W (Aaron W), Friday, 16 June 2006 19:54 (twenty years ago)

two weeks pass...

You still looking to do this? I can probably help.....

I've also made some Excel animation which you might be interested in.

― ZOT! (davidcorp), Wednesday, 5 July 2006 11:55 (nineteen years ago)

two weeks pass...

http://static.flickr.com/78/194563147_3530b8388d.jpg?v=0

― james madison duff (duff), Friday, 21 July 2006 06:53 (nineteen years ago)

Don't use PowerMax -- those assholes sold me a refurb disguised as a new computer. I had to wipe the HD and reinstall the OS because they hadn't done it yet and they didn't know what "Valued Customer"'s password was.

― Whitman Mayonnaise (Rock Hardy), Friday, 21 July 2006 12:28 (nineteen years ago)

wow, that's pretty bad!

― Machibuse '80 (ex machina), Friday, 21 July 2006 12:33 (nineteen years ago)

And I have 8 months of warranty left instead of a year because it starts when it was ORIGINALLY sold.

― Whitman Mayonnaise (Rock Hardy), Friday, 21 July 2006 12:37 (nineteen years ago)

the fuck is a usb music controller doing in startupitems?

― TOMBOT (TOMBOT), Friday, 21 July 2006 12:42 (nineteen years ago)

Can anybody advise me on the fake security alerts that have appeared in my winXP system tray? Adaware and Search&Destroy have failed to acknowledge them and googling brings up some false advise pointing to dodgy malware.

Anyone?

― Slumpman (Slump Man), Friday, 21 July 2006 12:52 (nineteen years ago)

Are they Spyfalcon?

― M. V. (M.V.), Friday, 21 July 2006 23:09 (nineteen years ago)

They're not the ones that say you may be using a non-legitimate copy of Windows, are they?

― Sean Carruthers (SeanC), Friday, 21 July 2006 23:29 (nineteen years ago)

Just got an Acer Aspire 5014WLMi laptop. Having a problem with audio playback through the dvd drive. Audio's fine from hard drive i.e mp3's, wmv, games etc but play an audio cd or movie dvd it's distorted and 'clicks' (though picture is fine in dvd). Have upated drivers for the sound card (Realtek AC97) and codecs for windows media player to no avail. The drive is a TSSTcorp TS-L532A DVDRW, couldn't find drivers for this.

Don't know if it's a hardware or software problem, girl I bought it from said she think it started after she installed nero media and windvd, which i've uninstalled. Pity she didn't mention it in her lising, grrr.

― Billy Dods (Billy Dods), Wednesday, 26 July 2006 11:11 (nineteen years ago)

um, might have seen something similar on linux box at home - sound card was ok playing back 44.1khz samples (ie cds and mp3s) but didn't like 48khz samples (dvds). maybe try to find some 48khz samples from somewhere (rip the audio from a dvd?) and see if it's that. see if there's a way of setting sample rate of card? dunno.

― Koogy Yonderboy (koogs), Wednesday, 26 July 2006 11:42 (nineteen years ago)

VLC can force the sample rate to an arbitary value.

― steal compass, drive north, disappear (tissp), Wednesday, 26 July 2006 11:47 (nineteen years ago)

(Well, it up/downsamples, but you know what I mean)

― steal compass, drive north, disappear (tissp), Wednesday, 26 July 2006 11:48 (nineteen years ago)

I've noticed lately that my PC has problems playing audio from the hard disk when the DVD drive is being accessed - it skips terribly.

― Forest Pines (ForestPines), Wednesday, 26 July 2006 11:49 (nineteen years ago)

Are they on the same IDE channel by any chance?

― steal compass, drive north, disappear (tissp), Wednesday, 26 July 2006 11:50 (nineteen years ago)

ok, quick work question.

web front ends to oracle? anybody know a good one? do they even exist? boss wants something that'll generate forms from the table definitions to allow people to browse (across tables, picking up details based on ids etc) AND insert data. i've already used the phrase 'moon on a stick' in my response but said i'd look for one. Access forms (that we'd have to write ourselves) is the only thing i can come up with and that's pushing the definition of what he wants. cheers.

― Koogy Yonderboy (koogs), Friday, 28 July 2006 11:08 (nineteen years ago)

is there any way to recover emptied trash in OSX? unlike the PC world, there seem to be a dearth of "undelete" type programs for macs.

-- renegade bear shot by cops on frat row (vfoz...), June 12th, 2006 3:27 AM. (vahid) (link)

way late on this one, but we successfully used this a few days ago:

http://www.prosofteng.com/products/data_rescue.php

― toby (tsg20), Friday, 28 July 2006 12:04 (nineteen years ago)

Andy,

I dunno much about it myself, but Oracle HTML DB exists, though it's more of a programming tool, if you know what I mean. Some of the people at my work use it, though I discourage it. I wouldn't use it; I'd use ASP.NET or JSF; something a bit more mainstream, you know. It's possible though it has some wizards for producing simple stuff like you're looking for.

http://www.oracle.com/technology/products/database/application_express/index.html

Looks like it's had a rebrand. Oh joy.

― KeefW (kmw), Friday, 28 July 2006 17:04 (nineteen years ago)

Whenever my Win XP laptop open dialogue box opens up (like in Winamp or when I'm uploading something through Firefox), all the files are sorted by SIZE. I want them to be sorted by filename, but I've tried restoring defaults and applying a certain style to all folders -- neither of which worked. Help?

― c('°c) (Leee), Monday, 31 July 2006 00:01 (nineteen years ago)

Are they on the same IDE channel by any chance?

No - the DVD drive is IDE, the hard disk SATA, on different controllers. This is why I'm puzzled.

― Forest Pines (ForestPines), Monday, 31 July 2006 05:22 (nineteen years ago)

ha. ok keith. yes, i had seen apex, sat through the little demo thing they have there. looks impressive but it appears to be for excel spreadsheets to web pages rather than databases (doesn't seem to be any support for normalised tables for instance. ours is actually 140+ tables with squillions of foreign keys etc. not all of it needs to be available though, just the core). cheers.

― Koogy Yonderboy (koogs), Monday, 31 July 2006 08:12 (nineteen years ago)

How do I set up a wireless network for file sharing across my two wireless pc's? I've got a broadband wireless router (Netgear DG834G), both pc's can access the internet but I'm lost as to how I get them to 'talk' to each other. Anyone care to help a simpleton in this respect?

― Billy Dods (Billy Dods), Monday, 31 July 2006 14:33 (nineteen years ago)

Make sure they are in the same IP range (on a PC, open the command prompt found in the Accessories and type ipconfigreturn). The first three sets of IP numbers will probably match and the fourth set should differ.

Open Explorer and right-click on the drive or folder you want to share. Click Sharing and Security (or it may just say Sharing). Click the New Share button near the bottom of the form. Give it a share name (like C, or C_Drive to be fancy). Click the Permissions button and give Everyone Full Control. Okay everything.

From the other computer, search for Computer or People from Explorer. Use the name of the computer you set the share on. It should show up in the search results and when you click on it, you should see the new share. Double-click on it. If a Username and Password form pops up, log in with the name and password of a user set up on the shared computer. It should let you in to the drive/folder.

― Jaq (Jaq), Monday, 31 July 2006 14:46 (nineteen years ago)

You also need to check if File and Print Sharing is installed on the network connection. Go to the desktop, right-click on My Network places and click Properties. If File and Printer Sharing isn't in the list on the General tab, install it.

― Jaq (Jaq), Monday, 31 July 2006 14:51 (nineteen years ago)

OK, done steps one and two, the IP addresses are in the same range, as you suggested. When I try to find the first (desktop) computer from the second (laptop) it can only find itself even when leaving the search box blank.

Second prob, have right clicked on My Network Places and clicked properties, but I can't see a general tab. I see the Wireless Network Connection icon and underneaths two wizards 'New connection' and 'network setup'.

― Billy Dods (Billy Dods), Monday, 31 July 2006 15:13 (nineteen years ago)

Sort by filename, View->Folder Options->Apply to All Folders

(or something like that)

― steal compass, drive north, disappear (tissp), Monday, 31 July 2006 15:15 (nineteen years ago)

Sorry, I just reread and noticed you already done this! Apologies. In this case, maybe the registry is broken?

― steal compass, drive north, disappear (tissp), Monday, 31 July 2006 15:15 (nineteen years ago)

Yay, got it sussed, though I'm not sure how. Put the IP addresses into my firewall and it worked ok. Cheers bud.

― Billy Dods (Billy Dods), Monday, 31 July 2006 16:06 (nineteen years ago)

Skipping 1639 messages at this point... Click here if you want to load them all.

You must be logged in to post. Please either login here, or if you are not registered, you may register here.