Welcome Guest.   Make a donation to an author on the site April 24, 2014, 05:44:59 PM  *

Please login or register.
Or did you miss your validation email?


Login with username and password (forgot your password?)
Why not become a lifetime supporting member of the site with a one-time donation of any amount? Your donation entitles you to a ton of additional benefits, including access to exclusive discounts and downloads, the ability to enter monthly free software drawings, and a single non-expiring license key for all of our programs.


You must sign up here before you can post and access some areas of the site. Registration is totally free and confidential.
 
Learn about the DonationCoder.com microdonation system (DonationCredits).
   
  Forum Home Thread Marks Chat! Downloads Search Login Register  
  Show Posts
      View this member's profile 
      donate to someone Donate to this member 
Pages: Prev 1 ... 3 4 5 6 7 [8] 9 10 11 12 13 ... 306 Next
176  Main Area and Open Discussion / Living Room / Re: Recommend some music videos to me! on: February 01, 2014, 04:39:27 PM
@40hz which brought me here - completely off-topic and I guess NSFW
(still Smack the Pony though)

177  Main Area and Open Discussion / General Software Discussion / Re: SOLVED: One of these thing is not like the other - Finding Unique Numbers on: January 31, 2014, 05:07:54 PM
I guess I could create a text file from each column, and compare somehow (dont have anything installed for that so if this the course to take, pleaase recommend something)
You might try a port of Unix comm, which I mentioned in DONE: Are any of the files missing???

thanks rj - I just changed the thread title to reflect that I got a solution (as quoted in reply #3). Not sure if this would work the same in other spreadsheet programmes, but using Planmaker:

apply this formula below in conditional formatting dialogue to cell B2 (B1 is column header)
=MATCH(B2;$A$1:$A$xxx;0)>=1
where xxx is the number of rows in column A that you want to compare with the rest e.g 400.
Apply some sort of highlighting formatting in the dialogue
you then transfer that formatting to all other cells that you want to compare with column A. This automatically adjusts the formula (you can tell I'm a real spreadsheet noob here lol)
Everthing that is duplicated is highlighted - so my numbers were the ones that werent highlighted

Resulting in the image in my previous post
178  Main Area and Open Discussion / General Software Discussion / Re: One of these thing is not like the other - Finding Unique Numbers on: January 31, 2014, 07:15:19 AM
After a bit of messing around - I got a simpler variation on that one working using conditional formatting with formula.
I found quite a few that had been missed (the info should all have been transferred already to the 'default' file, i.e. column A).

I hope I havent put you to too much trouble on this one Ath, and thanks for the offer Thmbsup

[attachthumb=#]

179  Main Area and Open Discussion / General Software Discussion / Re: One of these thing is not like the other - Finding Unique Numbers on: January 31, 2014, 06:27:45 AM
I should have said embarassed I also posted in the Softmaker forum and just got an answer using conditional formatting.
I'll have to study it a bit (I'm a very basic spreadsheet user).

This can be done via conditional formatting.
In the attached sample document, columns B and C got a red background as standard format.
Then, all cells in columns B and C got conditional formatting using the formula =MATCH(B1;$A$1:$A$36;0)>=1, which renders the background transparent if the condition is fulfilled, i. e. the number in the cell matches with any number in column A.
(NB: This is the original formula for cell B1; it was then transferred to the other cells using "Transfer cell formatting".)
Now, if in columns B or C any cell contains a number existing in column A, the conditional formatting makes the background transparent. If the number in a cell is not present in column A, conditional formatting doesn't work and the original red background is visible (as in cell C11).
180  Main Area and Open Discussion / General Software Discussion / Re: One of these thing is not like the other - Finding Unique Numbers on: January 31, 2014, 05:44:16 AM
A few questions upfront:
  • 1) How to determine the number of columns?
  • 2) What's the standard file-format, Excel (xls, xlsx), CSV, LibreOffice (odf)?
  • 3) What's the desired output? Messagebox, console, file: format?
(I numbered them)

1) There's the 'Default' column and seven six others (one was almost the same as the 'Default' so I was able to rule that out 'manually')

2) current file format is .xls (created with Planmaker/Softmaker)

3) Output doesnt matter - there wont be many (there might not even be any). I just need to know from which column the number came (column indicates a particular file with related info). Even if I can only get a screenshot of the results, I'll be happy ;-)


Edit// FWIW, I may have to do this again at a later stage (if I get more info from a different source)
181  Main Area and Open Discussion / General Software Discussion / SOLVED: One of these thing is not like the other - Finding Unique Numbers on: January 31, 2014, 03:48:46 AM
First, I dont have excel - I use Softmaker Office/Planmaker and Libre Office. I can get access to Excel though if the solution lies there.

Summary:
I'm wondering if it's possible -- using any type of software --to find numbers in a spreadsheet that are NOT shown in the first column?

[attachthumb=#]

In the screenshot, '674', in cell C131, does not exist in the first column.

The first column should contain all the numbers shown elsewhere -- but I'm not 100% certain it does.
So, if there is a number elsewhere in the sheet which is not duplicated in column one, I need to know the number, and also to know which column it is in (FWIW, it's location within the column is not important). This is (possibly) complicated by the fact that a number could exist twice in one column -- but still not be in first column; or a number could be shown in multiple columns, except for first (the latter is unlikely and should not be the case).

I guess I could create a text file from each column, and compare somehow (dont have anything installed for that so if this the course to take, pleaase recommend something)

TIA, Tom
182  Main Area and Open Discussion / General Software Discussion / Re: The nightmare of the programmer languages on: January 30, 2014, 04:59:08 PM
Owwww simplicity !!!!!


undecided doesnt seem to be working out too simple for you though (?)
(I know, I know, it can be difficult too with today's software...)
183  Special User Sections / N.A.N.Y. 2013 / Re: NANY 2013 Release: sImgurUploader on: January 30, 2014, 04:46:45 PM
sImgurUploader only works with an anonymous API account so I'd choose the "Anonymous usage without user authorization" option (and leave the second part blank).

I'm not allowed to leave part two blank :-(

[attachthumb=#]

So,
I tried 1b (see post #35) and got this:

[attachthumb=#]

which looked to me that, for authorisation, I type
Authorization: Client-ID xxxxxxxxxxxxxxxxxxxxxx (xxxxx... being the client ID given)
no joy, so I tried variations with the 'Application name'; then with both Client ID's, and then everything (I think embarassed) without 'Authorisation' before - tbh I made the mistake of not keeping track of everything I tried ... undecided

Any ideas smiley


edit // here's the link shown in image #2 - https://api.imgur.com/oauth2
edit #2 // maybe I have to give it a bit of time (and make a sacrificial offering Grin ) before it will work?
184  Special User Sections / N.A.N.Y. 2013 / Re: NANY 2013 Release: sImgurUploader on: January 30, 2014, 05:30:18 AM
You must have your own Imgur Anonymous API key for this application to work.  On its first run, sImgurUploader will ask you to enter your API key.  Without one, the application will exit.  If you do not have an Imgur Anonymous API key, you can get one here: http://imgur.com/register/api_anon.

anyone got any tips for getting the API key?
Dont know what to select here at #1. Also no clue with #2:

[attachthumb=#]

=> I'm veering towards 'b' for #1 (with #2 empty then), but thought I'd better check smiley

thanks
185  Main Area and Open Discussion / Living Room / Re: silly humor - post 'em here! [warning some NSFW and adult content] on: January 29, 2014, 05:03:41 PM
no bigger insult than telling someone to feck off back to the wrong country ;-)
186  DonationCoder.com Software / Screenshot Captor / Re: transfer error on: January 29, 2014, 05:01:26 PM
this related? (from the 21st)

This is crazy but IMM.IO has been down for weeks. I do hope they get back up and running again but if they do not I am afraid that ICUP will be down also.... well I guess I can just take out the upload part, but that was why I mainly wrote the app.
187  DonationCoder.com Software / N.A.N.Y. 2014 / Re: NANY 2014 Release: Blasteroids on: January 29, 2014, 01:24:06 PM
Try whatever you think is best deo -
I'll give it a go and let you know how I get on thumbs up
188  Main Area and Open Discussion / Living Room / Re: Interesting "stuff" on: January 29, 2014, 04:23:28 AM
Anyone here interested in this version right now?

I've been avoiding 8.1 so far, will chance this one when it comes out.
Bummer it's not out till March/April...
189  Main Area and Open Discussion / General Software Discussion / Re: Tips for Windows 8 (got any?) on: January 28, 2014, 04:28:46 PM
In a similar vein I have Windows Update set to Never Check for Updates.  After a couple of weeks passed I got a splash page "Windows Update Needs Your Help.. It hasn't been able to check for updates" etc..  Help it?  I want to kill it dead dead dead.  Seems there's no happy medium.  No fixes at all or 50 a day.   thumb down

Notifications of updates doesnt work well here either - I think I've gotten one notification in three months. (In fairness, there *is* some sort of reminder as you boot, but it's too discreet -- for me anyway).

And if you set if to 'Notify', the antivirus (Defender?) doesnt update at all huh
I found a way to get it to update using the scheduler, but it's not very nice...
190  Main Area and Open Discussion / General Software Discussion / Re: Tips for Windows 8 (got any?) on: January 28, 2014, 04:23:21 PM
Anyone have a tip to show what file types are assigned to Metro apps?  I am disgusted... I was emailed a wav file (for a voice message) and started playing it. About 5 seconds in, a blasted box pops up "This app needs an update, please download it from the Store to continue".  Really, Microsoft?  Can't listed to a stinkin' wav file without an update??  I will gladly reassign all file types possible away from behavior like this!

music and images get sent to Metro. There may be other casualties, I'm not sure.

I'm wondering if we dont update all these apps - is there a security risk? They're very free and easy with an internet connection - might even be worth looking at options to block them all (?)
191  Main Area and Open Discussion / General Software Discussion / Simple Checklist for repeating actions (fast turnover) on: January 28, 2014, 05:52:09 AM
Looking for a simple checklist (windows) app:

Background:
I have a very long list of entries/numbers - I have to double-check these with info from other sources.
Occasionally due to new info that also relates to other entries, I have lost track of what has been checked.
(Not good if I miss something embarassed)


I thought a simple checklist would be helpful:

  • Once the list is done I would need to be able to clear the [ticks] easily
  • Ideally I would be able to enter the entry/number I'm working on somewhere in the window
  • Ideally I could have multiple instances


Did do a search but couldnt see anything that fitted my needs - but my search-fu aint so good...
any ideas?
TIA
192  DonationCoder.com Software / N.A.N.Y. 2014 / Re: NANY 2014 Release: Blasteroids on: January 27, 2014, 06:52:57 PM
Didnt get back to it till today- I'd say it's almost impossible for a beginner now. I have made it to 26k but that was one of those super-fit days - mostly I'm getting below 10k :-/


Some thoughts/queries:

Is there a way of having the speed accelerate at the game progresses? (Sounds complex).

Otherwise I'd say a solution could be more bullets - and lots of 'em cheesy
Currently
1) you get a pulse of bullets, then a pause before the next pulse - this pause is the biggest killer in the current version...
2) if you rotate quickly, no bullets fire - not 100% sure here, but *think* it would be good if firing continued

A faster rate of bullets would be good too imo.
193  Main Area and Open Discussion / General Software Discussion / Re: Looking for iTunes alternative (WMP? or other?) on: January 27, 2014, 01:54:36 PM
Thanks wraith,
will try it out for myself anyways thumbs up
194  Main Area and Open Discussion / General Software Discussion / Re: Looking for iTunes alternative (WMP? or other?) on: January 27, 2014, 11:56:17 AM
As an alternative to music bee there is mediamonkey.  I've been making use of it with no problems for a while.

thanks wraith,
it got a mixed review at that techsupportalert page linked above - I cant link directly to the review - I'll chance copying most of it here:

Quote
Right from installation, my immediate impression of MediaMonkey is that it is not a monkey, at all, but a 1000 lb. gorilla. Just like another well-known media player that will remain nameless, it wants flex its muscles all over your computer and be your be all-do all media player. It instantaneously began searching my hard drives for media files, without my permission, while registering itself as the player of record making it necessary to go through my files and reset their associations so that all would be well once I uninstalled this beast. With all that off my chest, let's get on to the features as there are many.

First and most important MediaMonkey can organize music and edit tags in your audio library with a potent and insightful interface. It will rip and burn cd's. Its audio converter can convert MP3s, OGG, FLAC and WMA files into other formats. It will download and show album art. For those who want to play DJ for your church group or social organization, there is a Party Mode which lock down your media files while still allowing requests. Last of all, but most important some, is MediaMonkey's ability to synchronize with iPods and other MP3 players. There are more features, but they are too numerous to mention here.
[...]
I have no idea how they managed to fit all this functionality into 34.2 MB, but as far as I'm concerned MediaMonkey is just bit too over the top and is far more than I or the average music fan needs and far more than the novice can handle. If I were a professional DJ, then all bets would be off.

It does sound impressive after the initial complaints. BTW are you using the paid or free version?
195  Main Area and Open Discussion / General Software Discussion / Re: RightNote version 3.0.0 released on: January 27, 2014, 11:49:08 AM
@peter.s
thanks for the clarifications.
God be with the days when Latin was learned in schools - I did a few months of it myself aged about 12, but moved on when I got a choice (probably more to do with the teacher than the language itself).


PS, I sent you a PM related to your off-topic comments.
196  Main Area and Open Discussion / General Software Discussion / Re: Looking for iTunes alternative (WMP? or other?) on: January 27, 2014, 10:35:17 AM
What with having a largeish music collection, I think I'll recommend Music Bee - will probably mean I'll have to talk through adding codec for ripping, but once setup it seems easy to use thumbs up

Thanks people!
197  Main Area and Open Discussion / Living Room / Re: NSA restraints? Yes we can! (not) on: January 27, 2014, 12:22:41 AM
OMG REN, JUSTIN BIEBER'S IN COURT-I DIDNT KNOW!!!
Thanks for the heads up lol

Other news distinctly suspicious undecided
198  Main Area and Open Discussion / General Software Discussion / Looking for iTunes alternative (WMP? or other?) on: January 26, 2014, 03:28:34 PM
Summary:
what's WMP like as an iTunes replacement, for someone who isnt overly fussy -- but likes ease of use?

~~~~
Looking for a friend of mine - who is a long time computer user but, eh, doesnt tweak things (why I'm asking, and not her).
Disillusioned with iPod hardware and iTunes DRM, she's looking for an alternative. (Only allowed one more hardware transfer of music bought through iTunes - she's burned this music to cd.)

I used use JRiver Media Jukebox on windows xp - liked that a lot - nice user friendly interface. But it doesnt seem to have been updated since then. It's fueled by advertising which might not be so bad, the lack of updates would bother me more. The paid version is overkill.

Wondering what people think of WMP?
I've used it about twice in my life and both times it started chewing my hd and hogging cpu afterwards, which I found offensive. But I guess that if I actually used it and allowed it to import my music (or whatever it does), it might not be so bad after. Any experiences there?


If the WMP verdict is unfavourable, I'll probably go with Music Bee as recommended as techsupportalert
http://www.techsupportale...uick_Selection_Guide_Full
Have installed it, requires a bit of initial tweaking (lame codec; manually setting My Music folder for ripped music). Seems good thumbs up
199  Main Area and Open Discussion / Living Room / Re: NSA restraints? Yes we can! (not) on: January 26, 2014, 03:04:42 PM
^ seems to me you're both agreeing there - just looking at it from different perspectives...
200  Main Area and Open Discussion / General Software Discussion / Re: RightNote version 3.0.0 released on: January 26, 2014, 02:53:59 PM
Very interesting post peter. Some of it is over my head - I'm one of those causal readers ;-)
I've only used tags in fairly basic manner but am curious (and would like to get more efficiently organised).

FWIW, sorting is very important to me in file management and email client so can understand your emphasis on it.

Wondering what is
            1) a "viable tag M" is?
            2) is illac a typo of illic (I could find illic online, but not illac)


On the side: I'm unhappy with the use of the word 'clones' to indicate the same item shown in different locations, but have heard it's fairly universal at this stage - is that the case?
(If that's a clone, what do you call an identical copy :-/ )
Pages: Prev 1 ... 3 4 5 6 7 [8] 9 10 11 12 13 ... 306 Next
DonationCoder.com | About Us
DonationCoder.com Forum | Powered by SMF
[ Page time: 0.044s | Server load: 0.07 ]