I'm developing a training resource for a client and the brief requires me to provide some spreadsheets that summarise employment data for a small fictitious company. The spreadsheets must have one row per employee. I want to populate the rows as if the spreadsheet has already been sorted, for example by grouping employees by age, and then randomise the rows so students are given spreadsheets where there is no row by row pattern to the data, for example as if employees had been entered in alphabetical order. [more inside]
What kind of algorithm can I use to create optimal group assignments for people, given each person's ranked preferences and limitations on group size? I'm having a hard time coming up with good search terms for this kind of thing. If an example helps: I have 115 people and 16 groups. Each person needs to go in a group. Each person will submit a list of their preferred groups in their preferred order. Some groups can hold up to 10 people, while others can hold up to 5. For the purposes of this exercise, let's pretend that no one cares who else is in their group with them.
I've got a web page of static content that I need to make sortable by multiple columns. Essentially, it's a calendar that has these columns: date, location, event. I need to put this information onto a simple, fast-loading web page in such a fashion that I can have a primary method of sorting and then also sort things in a secondary and/or tertiary way within those results. [more inside]
My mom has inherited my dad's 2,000 record albums, most of which are movie soundtracks. She is trying to decide whether to sell them or donate them, and step one is sorting and cataloging. They're not in any order. Is there some good way of alphabetizing them where they live, in a small room without lots of floor space to make piles? [more inside]
After four years of working for film festivals in various cities, and another few years living and working at a private school, I've come back to New York City to get my Master's while living at la maison famille. But nearly everything I own other than my clothes and my laptop is in boxes, either in my family's house or in storage. Some of those boxes haven't been opened since 2004. What I have now is a three part challenge, and if you can help with any part I'd be grateful. [more inside]
I'm looking for a way to sort through my mountain of photos while I'm on the go, using an iPhone. (I shoot in RAW, so I guess it would need to involve exporting small JPGs to a Dropbox folder or an app.) I don't need to rate the photos, only flag/unflag/set as rejected (like Lightroom). The catch is that I'd like the changes I make on the go to somehow sync back to Lightroom on my computer. Is there an app for this that comes to mind, or any ideas you guys could suggest? Thanks!
I have a list of 625 English words, translations in a bunch of languages, and what-not in a giant excel file. We'll call that excel file "the Data." The Data is in alphabetical order. I also have a separate list of those same English words in a different order. Is there a way to sort the Data so that it's in the same order as my new, non-alphabetical list? [more inside]
Question about sorting in the Backbone.js framework. [more inside]
Since enabling iTunes in the Cloud, my music is sorted/grouped incorrectly on my iPhone. Albums starting with "S" will appear under "T", for instance. See this image for an example. [more inside]
I was recently placed in charge of a large database which is probably 90% irrelevant information. What should my plan of action be for cleaning it up? [more inside]
How do I sort the (potentially) real email addresses from the garbage data in Excel 2003? [more inside]
PHPfilter: in a bit over my head: is there a native function to sort an array by a word which isn't always in a fixed position, or do I need to create one? (And if I need to create one, is this the best way to do it?) [more inside]
Historical dates for blog posts? [more inside]
How do I get Excel 2007 default to using column headers when I'm sorting? [more inside]
Excel Filter: I have a long list of file names in numerical order in an Excel spreadsheet. I need to know what numbers are missing, so I can track down the related files. Is there a quick and (relatively) painless way of doing this without having to sift through all the numbers manually?
How to sort data WITHIN a cell in Microsoft Excel 2007 on Windows? [more inside]
Sorting and keeping track of my research: is Excel the best solution? [more inside]
What's the best system to store and transport laundry? [more inside]
I'm trying to implement a sorting algorithm in Excel known as "relative placement." Here's the setup: [more inside]
Filemaker Pro 11: Best way to create a ranked, ordered list that can be re-ordered easily, without knowing how many elements the list may contain? [more inside]
Extract Multiple Data (email, names, dates, and IDs) from a Huge Messy Text File, and Sort Them into a CSV: How do I do this? I've read this on extracting emails, but I can't figure out how to do this with several different data points. [more inside]
Why does GMail (mistakenly) append new messages to older threads with identical subject lines? [more inside]
How can I merge two directory trees, one arranged "Last, First", the other arranged "First Last"? [more inside]
Is there a way to sort by blank or null id3 fields in iTunes?
Given, for example, a table and a deck of cards or numbered sheets or whatever, what's a good way to put them in order? I feel like this is the sort of knowledge that would be passed around as tricks of the trade among secretaries, but, more generally, is there any field that makes systematic study of algorithms for humans instead of computers?
Can Windows Mail update the sorting of conversations, so that conversations with a new message are placed at the top of the inbox? [more inside]
Can I combine and sort MySQL search results? [more inside]
Help me stop cluttering up my (OS X) desktop. [more inside]
MySQL sorting issue. When I have "first name" and "last name" columns, and I'm sorting primarily by "last name." Some entries have only a "first name," and rather than have those end up at either the start or end of the sort, I'd like it to pretend the "first name" IS the "last name" and sort accordingly. Is there a way to do this with the SQL SELECT statement or should I just edit the data? [more inside]
Thunderbird: How can I make messages 'sticky'? [more inside]
How do I convert European dates to American in Excel? [more inside]
Is there an easy way to resort my iTunes folder back into by albums, instead of by artists? [more inside]
How does one sort hexadecimal colors properly? [more inside]
Where can I find image 'sorting' software (for OSX)? [more inside]
I'm trying to sort and clean up a media library that contains a total of 16431 items, 51.2 days, 108 GB. So hand sorting is out of the question. Itunes seems to have found Some Duplicates, That need to be deleted. This has proven to be a grueling task if its to be done manually. [more inside]
Where can I get free or cheap coin sorting in Toronto? [more inside]
mySQLfilter: How can I ignore "A, An, & The" at the beginning of book titles when sorting results alphabetically by title? [more inside]
MacOSXFilter: Is there any way to set up a folder in the finder that automatically sends stuff to other folders based on date? My downloads folder and my desktop are both a perpetual mess. I'd love it if there was a way to use applescript or what-not so that whenever I opened my downloads folder, I saw my most recently downloaded files, then a few folders containing "1 Week old downloads" "2-4 Weeks old" "+1 Month old", etc. Is this possible?