For my new position at work, I'll be putting together a large number of Executive Overviews. This is a new area for me and I'd like to avoid unknowingly committing a spreadsheet faux pas.
[more inside]
posted by radiosilents
on Jun 17, 2013 -
24 answers
Is there a spreadsheet app that's geared more toward creating sortable lists of stuff? I know I can do this with Apple's Numbers app, but it feels so clunky. I don't want column "A" "B" "C" and so forth. I want to name the columns, just as the columns in iTunes are named (song, album, rating, etc). I don't want to right click a column and choose from a list of options to choose "Sort Ascending/Descending". I want to click the column title and have it sort based on that column, just as iTunes does when in song view, or in a playlist. Click song, the list is sorted by song. Click album the list is sorted by album. I'm not working with any calculations. I want to create easily sortable lists of my stuff... like wine!
[more inside]
posted by Mr Ected
on Jun 15, 2013 -
12 answers
I have two separate marketing lists on spreadsheets, both of which were originally opt-in, but have been residing on different systems - System A for email marketing and System B for SMS marketing. List A has the users' email addresses, cellphone numbers and names. List B just has the users' cellphone numbers (plus a column called "unsubscribed" for those people who. I want to combine the two spreadsheets to create one spreadsheet while keeping the column called "unsubscribed" so I know which people to keep permanently removed. Can you advise me on how to synchronise these two spreadsheets using the cellphone number as the common data? Thanks!
posted by skylar
on Jun 3, 2013 -
4 answers
How do I represent the fact that my team and I experience time-crunches caused by late submissions of documents to us on a spreadsheet showing the amount of work required of myself and my team for the coming year?
[more inside]
posted by LN
on May 24, 2013 -
11 answers
I'd like to make a spreadsheet, which would include not just text but images and sets of tags, and maybe other interesting fields of information. Is there a better spreadsheet out there which is more flexible and more like a database?
[more inside]
posted by htid
on May 20, 2013 -
17 answers
Hi, I have a .csv that exceeds the maximum number of rows that Excel can handle, and before I can import it into a geodatabase in ArcGIS, I need to make one small edit – I need to delete the first row. Is there any way to do this and resave the file (preferably in a format other than .csv) in a way that retains the rows unable to be loaded in Excel?
posted by avocet
on May 9, 2013 -
20 answers
I have a spreadsheet with about 3000 rows of data. I would like the contents of this spreadsheet to show up as a big list/table on a webpage. It's mostly text with one column of URLs. The contents will change not-infrequently (maybe every couple of months) and I would like people both inside and outside my organization (but not general visitors to the webpage) to be able to edit the contents.
[more inside]
posted by marylynn
on Apr 15, 2013 -
3 answers
Here a doc there a doc, everywhere a doc doc but how do I define a frimping printable area on a Google Doc spreadsheet? & page breaks. So tired of selecting content & printing one page at a time.
posted by tilde
on Apr 12, 2013 -
4 answers
I need a solution to a pretty simple problem with counting instances of different text phrases in Excel.
[more inside]
posted by clockzero
on Mar 26, 2013 -
8 answers
I'm hoping there's an easier way to do this than my current manual process: I want to highlight text cells in Excel 2010 that are a duplicate of ONLY the cell below. Specifics inside.
[more inside]
posted by bibbit
on Feb 25, 2013 -
4 answers
I'm creating a workout training program in excel, and I want to show a range of data based on certain conditions. Using Excel 2010 More after the jump.
[more inside]
posted by FireStyle
on Feb 23, 2013 -
9 answers
I have an Excel spreadsheet with couple hundred rows: URLs, a few fields of identifying information (outlet, etc.), for media hits on the organization I work for. I need to make this into a pretty (or at least semi-legible to the computer illiterate) document that I can give to board members, senior staff, etc.
What I would like is to use some form of scripting to automate this. Bonus points if the script can somehow open the URL and take a screenshot of the story so that I don't have to.
I have a Mac, and both the Adobe and Microsoft suites. How do I not spend tedious hours manually doing this? Especially since I have to do it each month and quarter.
posted by klangklangston
on Jan 31, 2013 -
8 answers
I want to create a spreadsheet from the hyperlinks and words in a word list on Wiktionary. Please take me through the steps. Thanks!
[more inside]
posted by iamkimiam
on Nov 20, 2012 -
8 answers
So, I got myself an Android tablet, specifically for DnD nerdery. Now I've got some specific desires for pdf and spreadsheet programs - but am having a hell of a time tracking down apps that can what I want. Are these things really that hard to do in Jelly Bean?
[more inside]
posted by FatherDagon
on Nov 4, 2012 -
6 answers
Need to get data from hundreds of pages of bank records into a spreadsheet. We have a scanner with a document feeder, but would love some recommendations on software/workflow ideas.
[more inside]
posted by capnsue
on Sep 29, 2012 -
6 answers
How do you make Excel automatically group years (1921, 1925, 1929) into decades (1920s)?
[more inside]
posted by goatdog
on Jun 19, 2012 -
7 answers
I have a large number of books that I want to donate to a library or sell. I want to give my friends and family first pick at anything they want (my primary aim is to quickly reclaim the physical space used up by the books). I need a workflow that will allow me to scan the books' UPCs, etc. with my iPhone 4's camera and end up with an email-able spreadsheet
pre-populated with ISBN/Title/Author. Columns for genre, edition and/or year, and short blurbs would also be welcome.
I have a PC laptop with the MS Office suite in addition to the iPhone. What are my options? Thanks, hivemind!
posted by Inspector.Gadget
on May 20, 2012 -
6 answers
What are some good references or software tools to help me teach my young kids some basic computer skills (including typing, spreadsheets, and more)?
[more inside]
posted by bove
on May 15, 2012 -
4 answers
Former excel magician attempts to use Google spreadsheets, fails. It should be easy to make a function that can tally a monthly total from a column of dates and a column of numbers, right?
[more inside]
posted by frecklefaerie
on Apr 6, 2012 -
7 answers
I have a PDF document and a spreadsheet in XLS format. We want to be able to put the spreadsheet into the PDF and allow users to click on the sheet's column headings to sort the data alphabetically depending on need. Is this possible? If so, what is the best way to do it?
[more inside]
posted by Servo5678
on Feb 17, 2012 -
5 answers
Numbers for iOS: how to recalculate a spreadsheet on command? Like, if a cell contains a RAND or a RANDRANGE function, how to get it to produce a different random number besides reentering the formula? As near as I can tell it just sits there with the same value forever, no matter what else I do.
posted by JHarris
on Jan 30, 2012 -
2 answers
I've been using a spreadsheet (actually, three or four different spreadsheets....) to keep track of names, contact info, and task completion for a large number of people. Would switching to a database ultimately be easier and less stressful? And if so, what would be the best software for a database newbie to use? Or is there some other perfect solution out there?
[more inside]
posted by kittenmarlowe
on Jan 29, 2012 -
6 answers
How is this site (example
1 and
2) embedding interactive spreadsheets into its web pages? All I can tell is that it’s using javascript. If it’s some sort of custom solution, are there alternatives (either paid or free) that would let me do something similar in WordPress?
posted by Jasper Friendly Bear
on Dec 10, 2011 -
3 answers
How do I take data from a spreadsheet (LibreOffice Impress, to be precise), and use it as input to a program in Java? This is fairly basic stuff, so I'm a little embarrassed to be having issues with this, but I don't have much time. I'm well aware of how to do file I/O with a text file using a Scanner object for input, but how does this work with a spreadsheet?
posted by bookman117
on Dec 5, 2011 -
5 answers
Looking for a user friendly way to let people sign up for an email newsletter at a live event. Other than forcing them to enter their emails right into the right website, how can I simplify the current process of a person writing their email down, and a different person writing it into a spread sheet, and then someone else uploading the emails into the newsletter system? Is there an iPad app for this?
[more inside]
posted by Potomac Avenue
on Nov 10, 2011 -
10 answers
How can I make a spreadsheet editable
within Firefox? Difficulty: the spreadsheet is stored locally.
[more inside]
posted by Solomon
on Oct 29, 2011 -
13 answers
How can I programaticaly copy ranges from google docs spreadsheet to a fusion table?
[more inside]
posted by Popcorn
on Aug 17, 2011 -
3 answers
I need an iPad2 spreadsheet app with some specific requirements concerning conditional formatting:
[more inside]
posted by amf
on Aug 7, 2011 -
3 answers
Spreadsheet question: I want a column containing all the names in THAT column EXCEPT all the names in THOSE columns.
[more inside]
posted by Salvor Hardin
on Aug 2, 2011 -
6 answers
Excel help needed in calculating times.
I need to calculate and predict times based on fixed distances and a known average speed.
[more inside]
posted by dg
on Jun 28, 2011 -
8 answers
I'm dusting off my rusty Excel skills to try to build an easy-to-use, easily updated very basic payroll spreadsheet for a userbase which is completely unfamiliar with Excel.
[more inside]
posted by nevercalm
on Jun 2, 2011 -
9 answers
Need ideas on how to keep track of people making multiple payments for large trips or activities, with the ability to report how much they still owe. Much more detail inside.
[more inside]
posted by kraigory
on May 23, 2011 -
5 answers
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?
posted by Philby
on Mar 24, 2011 -
5 answers
There has to be an answer for this, but I just can't figure it out. In Excel, I've got 5 columns (A-E). I need to return a list of values from column A if either column B or C equals 'foo', *and* if either column D or E equals 'bar'. What's the magical formula (or whathaveyou) that will make this happen? For bonus points, results need to appear on a separate tab than the source data.
asking on behalf of mrs spinturtle, I personally have no idea what I'm talking about.
posted by spinturtle
on Mar 17, 2011 -
6 answers
Is there a way to turn my Gmail account into a database? I have tons of valuable information in my 15 gigabytes Gmail box...can you recommend exciting ways of extracting it?
[more inside]
posted by skylar
on Feb 3, 2011 -
6 answers
Excel Spreadsheet - AutoMagically re-arrange data from one sheet to many based upon Alphabet?
[more inside]
posted by DrtyBlvd
on Jan 28, 2011 -
7 answers
What's the best way to edit a spreadsheet on my PC from across the room, using a Droid over Bluetooth (not WiFi)?
[more inside]
posted by Alabaster
on Jan 13, 2011 -
3 answers
I'm looking for some kind of web widget that will allow me to have a dynamically updateable, embeddable spreadsheet for a website. Can you help me?
[more inside]
posted by orville sash
on Jan 5, 2011 -
11 answers
Microsoft Excel Filter: When I type 0.000, I want the cell to display "0.000" and not "0". How do I stop all of this ridiculous autoformating in Excel for good?
[more inside]
posted by nickerbocker
on Nov 29, 2010 -
23 answers
My very important spreadsheet has become too big to use without excel/calc slowing so much that I want to take an axe to the computer. Help!
[more inside]
posted by pootler
on Oct 22, 2010 -
20 answers
Microsoft Excel substitute (Open Office seems not to work) needed to open a spreadsheet (directory of businesses) based on macros.
[more inside]
posted by mbarryf
on Aug 11, 2010 -
6 answers
