186 posts tagged with Spreadsheet.
Displaying 1 through 50 of 186. Subscribe:

Data Munge: Uknown combination of 7 numbers produces a given number.

Data Munging Pros: In a spreadsheet with ten data columns, Column "A" is related to columns "B" through "J" in that some unknown combination or interaction of some or all of them will produce the data in Column "A". How do we determine what that combination is? (I can't even find what this type of problem is called, and I've not been able to find any productive Google search terms.) A more thorough explanation/example is provided in-thread. [more inside]
posted by jjjjjjjijjjjjjj on Jan 17, 2017 - 13 answers

Excel fractions filter: add cells, display as fraction, add fractions

I'm converting an old hand-tally chart into Excel, but I'm unsure how to translate a simple portion/total fraction of cells into Excel and then add more fractions in that row. "D / (B+C)," basically. [more inside]
posted by nicebookrack on Jan 12, 2017 - 9 answers

Need spreadsheet with pivot tables, but can't really use Excel or Sheets

We have a very large Excel spreadsheet with a lot of raw sales data. I'm then creating pivot tables to look at the info in various ways to help our sales team. However, we're bumping into some severe limitations with regards security, sharing, and user-friendliness of the UI and trying to figure out if there are alternatives. [more inside]
posted by edjusted on Dec 6, 2016 - 15 answers

Best practices for Excel workbooks?

What are your best practices for error checking when creating and maintaining Excel workbooks? [more inside]
posted by peacheater on Nov 29, 2016 - 13 answers

Why is Numbers (the spreadsheet app) for ios doing this?

I use a Numbers spreadsheet on my iPhone 5S to keep track of my mileage for work. Sometimes -- but not always -- when I do a calculation, it gives me an almost-accurate but borked up number. [more inside]
posted by kitty teeth on Jun 1, 2016 - 7 answers

Summarizing daily reports in Excel

I get a daily report of activity from a set of items and I want to make a automatically-updating summary sheet (I'm fine doing this in Excel, Google Sheets, or Apple Numbers). [more inside]
posted by primethyme on Apr 30, 2016 - 4 answers

Excel Wizards, Help Me Make My Dream Calendar

Hi! I an Excel novice surrounded by fellow novices and I need help with what looks like an unexpectedly difficult setup. I make a comprehensive calendar of activities and events for a retirement home every month. This takes most of a month to plan and transcribe, and is tedious and error-prone. I want to make something better. Assume I am smart but have little programming knowledge or power user experience. [more inside]
posted by skookumsaurus rex on Apr 4, 2016 - 7 answers

How should we manage all of these RSVPs for events at our non-profit?

Hello Mefites! I'm seeking some help finding a better method for a very inefficient RSVP process here at the nonprofit where I work. Please help me come up with a better solution! [more inside]
posted by smirkyfodder on Apr 4, 2016 - 9 answers

Help me develop complicated spreadsheet

Note: NOT Homework. Real world application here. I have to come up with a spreadsheet based on a formula that allocates dollars to people based upon role and participation. I'm good at Excel but this one is boggling my mind. Details and example inside [more inside]
posted by arniec on Feb 23, 2016 - 11 answers

New Year, new spreadsheet for tracking joint and personal expenses

My partner and I have decided to track more accurately our expenses and this task is on me. We are looking for an Excel spreadsheet template that will allow us to track all our expenses by category (groceries, eating out, etc), making a distinction between personal and joint expenses. On top of that, we would like to be able to see clearly who spent how much on what. [more inside]
posted by lost_lettuce on Jan 12, 2016 - 12 answers

Excel 2013 - I have no explanation for this chart behavior. Do you?

Excel 2013 - I have no explanation for this chart behavior. Do you? [more inside]
posted by radiosilents on Dec 15, 2015 - 6 answers

Help me escape Excel hell

I need to build a database that's viewable on the web, but for internal use only, among friends. How to do this painlessly? Google spreadsheet is not exactly making it any easier. [more inside]
posted by pleasebekind on Sep 10, 2015 - 9 answers

Spreadsheet - Naming calendar quarters with custom date

I'm struggling to do something in a spreadsheet (I'm using Google Spreadsheets, but could use Mac Excel or Numbers if needed). I want to automatically fill one cell with the name of the calendar quarter (e.g. "Q3-2015") based on a user-entered date in another cell. To make it more complicated, the "quarters" don't begin/end on standard dates. [more inside]
posted by primethyme on Aug 29, 2015 - 4 answers

I want to build a digital catalog of my art collection.

Software suggestions for the Mac? I have simple needs. I want a catalog number, date of origin, artist name, and a photograph of each piece. Sorting, filtering and searchability required. [more inside]
posted by Devils Rancher on Jul 18, 2015 - 7 answers

Excel 2013 - Using data from two columns to identify a row in a third

I have data on one sheet of an Excel document with three columns. I want to extract this for use on another sheet as follows: If a row in Column A contains X (text string) and a row in column B contains Y (also a text string) then what does the row in column C (always a value) which matches these two criteria contain? With the data I have, this will always return a single result. [more inside]
posted by Len on Mar 5, 2015 - 13 answers

LibreOffice Calc Conditional Date Magic

Wondering if some conditional work with dates, working across multiple sheets, is possible in LibreOffice Calc. [more inside]
posted by circular on Feb 28, 2015 - 3 answers

Synchronizing a Spreadsheet to a Time Line

I am looking for a program that synchronizes movement through a timeline to identical times as successively displayed in a spreadsheet. Specifically, I want to play an audio file and as the file plays, I want unique elements in the audio file that I've identified at specific times to be highlighted in the spreadsheet. I want to show very detailed and subtle changes in B as they occur in A. Does anything like that exist or does it have to be built?
posted by CollectiveMind on Feb 21, 2015 - 8 answers

Budget tablet recommendations for D&D

I'm thinking of picking up a tablet for playing Dungeons & Dragons. I need some advice on which tablets do well with both graphics-heavy PDFs and spreadsheets. Under $200 preferred. [more inside]
posted by chaosys on Dec 28, 2014 - 5 answers

Help me quantify extra hours, please, please, a please please.

I need help with gmail functionality. I need to figure out how many(ish) extra hours I generally work. I think an easy way to capture part of this is to check out the volume of email sent outside of my working hours. Is there a reasonably easy way to do this? [more inside]
posted by stormygrey on Dec 1, 2014 - 5 answers

Another "data management & research database for dummies" question

I'm undertaking a research project in which I'm evaluating several different organizations based on specific yet qualitative criteria, e.g. "promotes outreach", "reports on progress", etc. I need to able to capture the information and then display the results in some sort of meaningful way so that it can be incorporated into a report. [more inside]
posted by ladybird on Nov 27, 2014 - 5 answers

Counting rows in Excel that match condition?

Can an Excel expert help me with counting rows in a spreadsheet that can match one of 15 possible combinations? [more inside]
posted by dukes909 on Nov 24, 2014 - 15 answers

Tracking reimbursements for employees

I'm in charge of a tuition reimbursement process in my company-- people give me their approved applications along with their grades and receipts and I calculate the reimbursement and send it along to accounting. Part of this process is keeping tabs on what's being spent on what. Right now, I'm using a massive Excel sheet to do this and it is messy. [more inside]
posted by thefang on Sep 25, 2014 - 3 answers

Taking data from a PDF and putting it into a spreadsheet

I have a PDF with several hundred pages. Each page is formatted identically and contains data on a single person, divided into various tables. I want to parse the PDF so that each person's data is a single row in a spreadsheet, with various key points (e.g. "name") in the same column. I feel like this has to be an already-solved problem. How can I do this?
posted by LSK on Aug 11, 2014 - 7 answers

Excel Filter: IF Statements and Concatenate

I'm trying to test if a a series of cells exist, and then concatenate the values that do exist with a paragraph I have. [more inside]
posted by trogdole on Aug 7, 2014 - 10 answers

Help Me Hack My PT

I'm an obsessive tracker. I have an awesome to-do list that helps me get shit done. I just started physical therapy for an ankle injury (yet again). I want to keep track of the exercises and how much I'm able to do. [more inside]
posted by kathrynm on Jul 22, 2014 - 6 answers

Help me use Excel to save my job

So, I just got promoted to a new position at my company (Yay!). Unfortunately, the new requirements involve scheduling a ridiculous number of people. It turns out my predecessor has just been doing dozens of iterations manually until one kind of worked, but every slight change puts a bunch of other things out of wack. I feel like Excel could probably be capable of doing it, but I have no idea how I would go about designing such a spread sheet. [more inside]
posted by cacofonie on Jun 19, 2014 - 17 answers

Google spreadsheet to generate list of styled links in html document

I'd like to have a simple html page of styled links that can be updated using a Google spreadsheet. [more inside]
posted by Sreiny on Jun 9, 2014 - 1 answer

Need help with getting things to sort correctly in Excel

I have a spreadsheet with items that I am trying to organize by part numbers made up of both letters and numbers. When I sort them, though, "HMDL32000" comes ahead of "HMDL3700", even though 32000 is a bigger number. In the warehouse, HMDL32000 is behind HMDL3700 and it seems unintuitive to have it appear first on the spreadsheet. How can I get Excel to organize first by the alphabetical portion of the part number, and then in the correct numeric order?
posted by BuddhaInABucket on Apr 29, 2014 - 3 answers

Mapping real-time points to a spreadsheet

I'm looking for a tool that will let me have a map interface open (Google Maps, OSM, Bing, I don't mind), click on a location, enter a brief comment, then have that data (lat/long, comment, timestamp) stored for later retrieval - something like a Google Docs spreadsheet would be ideal. [more inside]
posted by Jimbob on Jan 6, 2014 - 7 answers

Extra-applicational extraction of Excel form

I have an MS Excel spreadsheet which uses drop-down menus which affect the content in multiple fields. It's used for buying inventory, so you'd change the "category" menu to "paperware," upon which the fields "account number" "responsible admin" etc. would all populate depending on what I've chosen in "paperware." Now we're redoing the form and I'm tasked with mapping all available functions and how they are related [more inside]
posted by monocultured on Oct 29, 2013 - 5 answers

How can I get Excel to create multiple averages from a single table?

I have a table of data that I need to average, but I need to come up with averages using multiple different rows. For example average A=row 1, row 2, row 4: Average B= row 1, row 2, row 3: Average C= row 2, row 3. I would like to add a column that has the names of each average I need, (A, B, C) and then let excel average them based on which set they belong to. I have been looking around at other excel related forums, but I am not sure what this process is called, so I don't know how to find it. Right now I have been copying rows for each time they show up in a set I need averaged. It would be nicer to have column that says, this row belongs to set A and C, next one belongs to set A, B, and C.
posted by djpuddings on Oct 24, 2013 - 11 answers

We have the budget. Now let's analyze.

Last year, my SO posted this question about making a budget for our family. Your answers were very helpful. August 31 was the last day of our first budget year, and we did pretty well. But we wondered what are good ratios or metrics to gauge just how well we did and where we need to improve. [more inside]
posted by 5845(f)(1)(D) on Sep 6, 2013 - 4 answers

Excel to Word mail merge for envelopes. Should be super-simple. ISN'T.

Whoever is formatting this excel sheet sucks. I need to find a way to fix it that doesn't entail me retyping the whole thing each week. [more inside]
posted by A neighbourhood park all covered with cheese on Aug 23, 2013 - 34 answers

What is the Comic Sans of Excel spreadsheets?

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

I need a different kind of spreadsheet app for OSX

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

Matching two spreadsheets via one matching column

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

Showing a time crunch in a spreadsheet?

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

Is there a better type of spreadsheet?

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

Adventures in giant-CSV land

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

How do I embed a Google spreadsheet into a non-Sites webpage?

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

Calling the powers of the Doc Google collective

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

simple excel 2007 question

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

Using Excel conditional formatting to do a name/ID data check?

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

Need help with conditional lists in excel

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

Excel spreadsheet to pretty clips report?

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

please help my create a spreadsheet from a list of links.

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

Not so much to ask, really

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

The simple weight loss spreadsheet that eludes me...

This simple weight loss/calorie defect spreadsheet from years ago eludes me...hivemind, help! [more inside]
posted by poolsidemuse on Oct 24, 2012 - 5 answers

How to turn Google Forms results back into the forms that were submitted?

Using Google Forms, is there any easy to to turn a form response (displayed as a line on a spreadsheet) back into the form that was submitted so it can be printed or saved as a PDF? [more inside]
posted by a box and a stick and a string and a bear on Oct 18, 2012 - 1 answer

Solution to OCR many bank statements into excel

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

Page: 1 2 3 4