Looking for a way to have Google forms/spreadsheet send an e-mail notification when a form has been filled out. [more inside]
posted by jmd82 on Oct 23, 2009 - 3 answers

How do I store a string in one cell in Excel and interpret it as a (or for a) function in another cell? More info inside. [more inside]
posted by nickerbocker on Oct 22, 2009 - 10 answers

I want to start using a spreadsheet to track and reconcile my various accounts. How do I start? [more inside]
posted by reenum on Sep 30, 2009 - 9 answers

Can I set up an Excel spreadsheet so the user is presented with a series of fields, like a form, instead of having to enter data directly into the cell? [I'm having a hard time even wording this question properly, so I haven't been able to find the answer anywhere. I turn to AskMe. Further explanation follows...] [more inside]
posted by The Deej on Aug 11, 2009 - 14 answers

Can you recommend a mini-spreadsheet program for Windows XP, preferably freeware? It will be running on a tiny laptop in a place with no internet access, so OpenOffice is too big and online solutions are too... online. [more inside]
posted by No-sword on Aug 7, 2009 - 19 answers

Fast functional iPhone Spreadsheet App? I'm looking for the best way to manage the conditioning progress of my volleyball players. Things like Google Docs, EditGrid, and Documents 2 are all too slow and clunky to be effective at practice. I need to be able to quickly add columns, and being able to lock first column (Player Names) so that I can see whose information I'm plugging in would be a huge plus. [more inside]
posted by DavidJ710 on Jul 15, 2009 - 4 answers

How do I create an inventory database using Excel? [more inside]
posted by Seeba on Jul 14, 2009 - 10 answers

How do I select the last number in a column in Open Office Calc? [more inside]
posted by tomble on Jul 9, 2009 - 3 answers

I'm looking for a randomized list of every nation state in the world, preferably in spreadsheet column form. Is there anything like this?
posted by billtron on Jun 29, 2009 - 8 answers

ExcelFilter: I want to calculate an average food spend, but the days I buy food are irregular throughout the month. How can I draw up a table/graph that gives an average based on a date and amount (for OpenOfficeCalc)? [more inside]
posted by Gisela on May 21, 2009 - 11 answers

Please help settle a bet: Is a spreadsheet a simple type of database, or are they fundamentally different things? [more inside]
posted by perrce on Apr 2, 2009 - 38 answers

I have hundreds of text strings entered through a form in a Google Spreadsheets which look like 4*3 9*2 17*3 22 37*4 52. I can easily substitute " " for "+" and concatenate a "=" in front =4*3+9*2+17*3+22+37*4+52. Now I have a text string which looks like a formula but isn't one. How can I make Google Spreadsheets interpret this string as a formula? [more inside]
posted by Akeem on Mar 12, 2009 - 3 answers

Editor for very large flat files? [more inside]
posted by ROU_Xenophobe on Feb 5, 2009 - 20 answers

Spreadsheet question: Display Greater Value? I know this is one of those "you-either-know-it-or-you-don't" situations, and I just don't know. [more inside]
posted by guptaxpn on Feb 5, 2009 - 6 answers

I need to create a database in Excel, with clickable column headers (clicking on them will sort by that column). More inside, of course. [more inside]
posted by Rubythursday on Feb 4, 2009 - 7 answers

What's the optimal design for a spreadsheet to track statistics for events (performer, type of program, location, attendance) and pull out various monthly totals? (Details follow) [more inside]
posted by mkny on Jan 27, 2009 - 9 answers

I need some help finding/creating a Calc/Excel formula that will help me track my breaks at work, depending on how long I work per day. [more inside]
posted by Solomon on Dec 18, 2008 - 7 answers

What are good options for cheap data entry? I have about 500 pages of scanned historical election data that I need turned into a spreadsheet. I know there are over-sea firms (i'm in the US) that do this cheaply, but I don't know where to start besides basic google searches. Any recommendations, tips, or past experiences? Any rough estimates on how much it will cost per page? [more inside]
posted by fdhidalgo on Dec 2, 2008 - 5 answers

I need to transform a big HTML table into something easier to update and maintain. Bonus: I'd like to put it (or its display widget) onto our staff wiki page. [more inside]
posted by lillygog on Nov 12, 2008 - 6 answers

I have a very large MS Excel spreadsheet in Mac Office 2008 (yuk). I want to find every cell that contains bold text and append an asterisk to it -- i.e. "bold cell text" becomes "bold cell text*". I can probably find a Windows machine if necessary. How can this be done automatically?
posted by beniamino on Nov 2, 2008 - 4 answers

How do I export email messages from Outlook into Excel (or CSV) while retaining the date/time stamp on each message? [more inside]
posted by geekgirl397 on Oct 29, 2008 - 4 answers

I need to enter the following information into excel, but excel wants to transform one of them into a date format. This is for a statistics class and being used to make a graph of some kind. [more inside]
posted by Jackie_Treehorn on Oct 24, 2008 - 9 answers

How can I create a chart in Excel 2007 showing the number of times a certain value occurs in a column? [more inside]
posted by niles on Oct 20, 2008 - 7 answers

Trying to find the best option to make a Google map using data entered into a Google docs spreadsheet. I'd prefer not to have to learn much about coding to do this, but would like the map to update with changes to the spreadsheet, including assorted details... [more inside]
posted by Unsomnambulist on Sep 13, 2008 - 1 answer

I want to build a web app based on an Excel spreadsheet using VBA and some Excel Solve functionality. Should I try to build my own online spreadsheet? Or is Microsoft about to release some nifty online development components compatible with Excel and VBA? [more inside]
posted by Mokusatsu on Sep 12, 2008 - 2 answers

How do I make an OpenOffice spreadsheet display a cell in bold if the date in the cell is in the past? [more inside]
posted by jesirose on Aug 20, 2008 - 2 answers

Help me set up an Excel spreadsheet to track my gas mileage on my car. [more inside]
posted by rossination on Aug 6, 2008 - 6 answers

NeoOffice (or OpenOffice) Filter: Can anybody point me to the NeoOffice/OpenOffice formulas for comparing time (in minutes or seconds) between two dates? [more inside]
posted by The Giant Squid on Aug 3, 2008 - 4 answers

I'm a quick learner of computer programs... but am currently looking for a job and am realizing that I need excel training... (another of the things I really should've studied in college.) Any recommendations on where to get training in New York City? [more inside]
posted by J.R. Benedict on Jul 31, 2008 - 11 answers

Excel 2007: How do I get "Sum of" out of the data headers of my Pivottable? [more inside]
posted by skryche on Jul 28, 2008 - 4 answers

I think I'm going to start tracking my finances using Excel, or maybe Google Docs. This will supplement my credit union's online banking; I've considered Mint, Wesabe, iBank, Moneydance, among others, but haven't been impressed. Info includes date, transaction description, amount, balance, category (withdrawal, deposit, etc.), tags (gas, groceries, etc.) My question: what are your best tips, tricks, and hints for doing this? Excel formulas, creating charts, formatting technique, automation. Anything in that vein would be great. Thanks in advance!
posted by jroybal on Jul 28, 2008 - 11 answers

How can I make readable Word tables out of a large Excel spreadsheet? [more inside]
posted by lunchbox on Jul 6, 2008 - 7 answers

Excel filter:: Making mailing labels out of an excel spreadsheet? [more inside]
posted by ThomThomThomThom on Jun 4, 2008 - 4 answers

Using OpenOffice Calc (Spreadsheets) - Is there any way to divide the strings in one column into two by the space in each cell? [more inside]
posted by l33tpolicywonk on May 30, 2008 - 5 answers

I want to take an Excel spreadsheet and just make it a dynamically sortable table I can put in a webpage or blog. I want people to be able to click a column, and have the table be sorted by that column. Best solutions? Also, if the table included locations, is it possible to make them selectable, and have the selected locations display on Google maps? Thanks.
posted by Malad on Apr 26, 2008 - 5 answers

I need a solution which will help me work out my revision plan automatically (Possible Excel filter?) Please help! [more inside]
posted by edbyford on Apr 15, 2008 - 3 answers

Excel Filter: I can't figure out how to make Excel show my budget the way I need it to. [more inside]
posted by stormygrey on Apr 14, 2008 - 9 answers

I have a few pdfs of tabular data that I would like to use in a spreadsheet and/or database. Acrobat Reader is not cooperating; it converts obvious tabs into spaces. Is there some way to get this data, properly formatted? [more inside]
posted by johnofjack on Apr 10, 2008 - 44 answers

I heard the Google Visualization API Query Language allows you to query Google Spreadsheet documents using a language similar to SQL. Is there a PHP library I can get to use a Google Spreadsheet as a simple database table?
posted by remi on Apr 4, 2008 - 2 answers

I need to do something very specific with Mail Merge (I think thats the best way to do it) but I have no idea how. Basically I want to take info from a spreadsheet and convert it into a variable number of different colored boxes of a constant size in a document. [more inside]
posted by DetonatedManiac on Mar 26, 2008 - 1 answer

Is there a way to automate this very tedious spreadsheet task? [more inside]
posted by [expletive deleted] on Mar 24, 2008 - 14 answers

Please recommend a free and very stupid spreadsheet for Mac. [more inside]
posted by eccnineten on Mar 24, 2008 - 8 answers

How can I work some data magic and save time looking up hundreds of phone numbers with data from an Excel spreadsheet? [more inside]
posted by abkadefgee on Mar 18, 2008 - 6 answers

How do you figure out daily interest from an APR on student loans due monthly? [more inside]
posted by johnofjack on Feb 28, 2008 - 8 answers

I'd like to create what amounts to a photo directory in Excel, and be able to sort by last name. Is this possible? If so, how? [more inside]
posted by uvaleg on Jan 24, 2008 - 6 answers

Excel 2003 question -- why do some of my cells show ####### in the contents? [more inside]
posted by crapmatic on Jan 22, 2008 - 26 answers

I'd like a spreadsheet (OpenOffice Calc) to give me the average of the numbers in a certain row that will be filled over a period of months, and I'd like the formula for the average to remain valid even as I fill it, cell by cell. How? [more inside]
posted by regicide is good for you on Jan 14, 2008 - 7 answers

Excel/OpenOffice: How can I use XIRR to show an estimated percentage return based on account deposits/withdrawals/balances? [more inside]
posted by spacewrench on Dec 16, 2007 - 3 answers

How do I parse a few lines from several hundred word documents into a spreadsheet? [more inside]
posted by gerg on Dec 2, 2007 - 7 answers

Question on converting numbers into formatted text with Excel. [more inside]
posted by Optimus Chyme on Nov 7, 2007 - 5 answers