In Excel, how do I calculate the average of every 300 data points in a large data set? [more inside]
posted by Midnight Rambler on Oct 18, 2009 - 10 answers

Do you know any good books on print production? I was recently given the responsibility to obtain quotes and manage print jobs for my company. I need to understand paper types and weights, binding, print methods, folding, etc. so I can speak the language of printers.
posted by 4chrisd on Dec 14, 2008 - 7 answers

What are the best printing companies in Manhattan? [more inside]
posted by Optimus Chyme on Aug 19, 2008 - 3 answers

Home Improvement Filter: why is it so hard to find an offset tool to remove stuff that is mounted on the wall? What do you use for that purpose? [more inside]
posted by jak68 on Jun 28, 2008 - 16 answers

HaplessArtistFilter: I have a very particular, somewhat odd project that I'd like to have offset printed. Can anyone tell me a: if I'm communicating what I want correctly, and b: if this is something that any printer would even consider doing? (It's a small run involving 22 individual spot colors) [more inside]
posted by wreckingball on Apr 12, 2008 - 16 answers

Attention SQL gurus. This has me completely stumped. How can I find the index (position) of a row in a table without querying the entire set? [more inside]
posted by Civil_Disobedient on Sep 3, 2006 - 12 answers

US graphic designer needs to learn about best practices in prepress for offset printing in the UK. Software, file formats, etc. [more inside]
posted by junkbox on Jun 27, 2006 - 3 answers

WordPress Filter: I am trying to show the local time on my WP sidebar. I am located in Sydney, AUS but my server is in the US. I have set the the offset on the WP>Options page under "Times in the weblog should differ by: to the correct setting and posting times are correct. However, when I add the PHP function echo date("M d, h:ia") in my sidebar.php, I get the local time/date of my server. How to I offset this function call to show the correct local time here in Sydney?
posted by qwip on Dec 3, 2005 - 10 answers