## 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.
posted by jjjjjjjijjjjjjj on Jan 17, 2017 - 12 answers

## Math For Spacing Out Three-Day Weekends, But Accounting for Holidays

I'm a big honkin' geek, and I would like to figure out an Excel formula I could reuse from year to year to space out my vacation day choices -- but including holidays, which would prevent even distribution. How can I still get as close as possible? More inside.
posted by WCityMike on Jan 13, 2017 - 10 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.
posted by nicebookrack on Jan 12, 2017 - 9 answers

## How can I sell myself on learning the skills to do office administration

I haven't worked in a long time due to my disability (bipolar) and also many years when I was a caregiver. I live in a city (Glasgow, Scotland) which is great for music and low cost of living, but quite hard to find jobs in outside of bar work and call centres. I have been working with a careers advisor from a mental health charity and we agree that me updating my skills in Microsoft Office would open a way to doing office admin or data entry work, which I could do for maybe 8-10 hours a week while managing my disability and trying to improve my health. Yet my skills are all in English and with words, and although not unintelligent I seem to have blocks about learning Office and resistance to it. How can I reframe this learning task so that I stop resisting it, embrace it, and start getting some office admin experience for my resume?
posted by AuroraSky on Jan 10, 2017 - 12 answers

## Reorganizing Excel data

I have two related but slightly different questions about how to rearrange Excel data so that I can analyze it properly. I've been struggling with these problems for a while, and finally just gave in and am throwing myself on the mercy of MeFites.
posted by Superplin on Jan 6, 2017 - 28 answers

## Excel PivotTable filter: how to calculate percentage?

One field, FieldA, is being summed in a column. Another field, FieldB, is being counted in a column. How do I get FieldA/FieldB as a percent in the pivot table?
posted by bologna on wry on Jan 6, 2017 - 5 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.
posted by edjusted on Dec 6, 2016 - 15 answers

## Vlookup Personal Projects

I am looking for an every day project to up my Excel Vlookup game. Any ideas would be useful.
posted by ihaveyourfoot on Dec 5, 2016 - 8 answers

## Best practices for Excel workbooks?

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

## ISBN to HTML in Excel

Last year I found instructions for turning a list of ISBNs into hyperlinks to our library computer using Excel. I am at a new library and have lost the file. I'll give more details below.
posted by Biblio on Nov 22, 2016 - 6 answers

## Excel Question: how do I paste some hyperlinks?

This seems like a simple question, but I can't figure out the answer. How do I paste a bunch of hyperlinks?
posted by zooropa on Nov 21, 2016 - 6 answers

## Calling all Excel PivotTable Gurus

How do I construct this PivotTable to show what I need?
posted by bologna on wry on Sep 14, 2016 - 3 answers

## FilemakerPro to .CSV to NeonCRM - How to Excel?

Excel experts and fundraising professionals, ho! I work for a small non-profit and we're currently transitioning from a janky FilemakerPro database to NeonCRM. I have all the data spread across three spreadsheets and my brain is collapsing trying to figure out the best way to deal with it. What's the best/most efficient way to compare data between three separate spreadsheets, and manipulate it into the format I need for this import? All the necessary/boring details lie within!
posted by adastra on Aug 19, 2016 - 11 answers

## App for that, or Excel magic? Grocery inventory w/ recipe matching

I'm looking for an app/program/spreadsheet/whatever that stores a grocery inventory with quantities, and a list of recipes (or just named sets of ingredient quantities). It would rank the recipes by % of ingredients on hand. If any part of this makes you think, "you could do that bit in [program] with/by [method]", I appreciate any pointers! Because I'll make it if I can't find it, but I'm not sure where to start.
posted by Baethan on Aug 18, 2016 - 5 answers

## How to sorting column with 10,000 rows?

I have a spreadsheet column with 10,000 rows, and I need to sort it. Is there a way to do this automatically, where certain rows with specific attributes are sent to a new column?
posted by My Dad on Aug 13, 2016 - 12 answers

## Building An Auto-Populating Task Calendar In Excel

I'm looking to create some way that I can track jobs I have coming up, as well as have them populate into available time slots in my scheduled based on anticipated completion time. Can this be done in an Excel sheet, or is there some sort of program that exists that is better suited for my needs?
posted by Malleable on Aug 8, 2016 - 3 answers

## Excel-Powerpoint Linking-Embedding Charts-Tables

I am trying to create charts in Excel and then copy them into Powerpoint. If I initially paste the charts with linked data, can I subsequently embed that data for sharing with others? Are there other convenient ways of sharing a Powerpoint file together with a linked Excel file? More tiny/related questions and details within.
posted by taltalim on Aug 8, 2016 - 6 answers

## I have excel and a sense that this is possible

So imagine I have a population of like 100,000 people. And I have goals for them to achieve for which they get money. Now I want to calculate what my budget might be.
posted by jander03 on Aug 7, 2016 - 4 answers

## Excel reverse conditional formatting

I'd like something like conditional formatting, but that works the other way - a cell's value changes depending upon the colour the cell is filled with.
posted by quinndexter on Jul 19, 2016 - 2 answers

## How to present and evaluate data relative to weight

I could use some help walking through this: I have Excel data that means more or less depending on where it comes from. When I'm working with it, presenting it, or thinking about it, I want to treat it differently depending on origin. Example within.
posted by A Terrible Llama on Jul 19, 2016 - 11 answers

## Help with Excel formula to compare 1 column of numbers to other columns.

I have an excel sheet with 4 columns of numbers. The first column is a recent donation amount. The other three columns were the prompts of donation amounts, (the Reach, the Target, and the Anchor). Is there an excel formula that can compare these four columns?
posted by andoatnp on Jul 19, 2016 - 8 answers

## Excel Formula to Weight Ratings By Number of Ratings?

How do I write an Excel formula to weight a rating by the number of ratings, so that a 4 with tens of thousands of ratings weighs more than a 5 with three ratings?
posted by WCityMike on Jul 5, 2016 - 13 answers

## Engine in Excel

Now this may be a ridiculous long shot but does anybody remember seeing an Excel workbook circa 1993 which featured an elaborate color drawing of an internal combustion engine? It had shading, many colors, and took a couple of minutes to "render" on the Mac we had at the time. I think it came from a magazine cover disk but I could be wrong. If anyone has this I'd love a copy.
posted by hoverboards don't work on water on Jun 30, 2016 - 0 answers

## Manager question: excel formatting

I have a question on how to set standards for an ambiguous process. Part of my job involves having my directs "body-shop" powerpoint/excel charts - i.e. organizing things on the page, making tables look nice, filling in / fleshing out commentary, etc. (I'm in consulting). How can I help them do this better?
posted by The Ted on Jun 25, 2016 - 8 answers

## How do I make a VBA macro run "silently" in the background?

I have a macro in an excel sheet that successfully displays or hides tabs in the workbook based on the value in a particular cell. I'm pleased with this! There's a problem, though...
posted by jefficator on Jun 9, 2016 - 1 answer

## 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.
posted by kitty teeth on Jun 1, 2016 - 7 answers

## Excel VBA filter: Copy/paste using offset

Based on the active cell's position, I need to copy cells in the next column over and paste them a few columns to the left. Help?
posted by bologna on wry on May 17, 2016 - 5 answers

## excel 2016 training help

When I got Excel 2010, I got a workbook that came with a disk of practice worksheets. It was dummy data, as it were. Now that I have updated to Excel 2016 I can't find anything similar. Every search brings me back to some kind of online video training. All of that is good as far as it goes but I won't retain much unless I can actually implement the lesson, not just watch it. Where can I find either a disk or downloadable dummy worksheets with which to practice? Thanks.
posted by jtexman1 on May 9, 2016 - 3 answers

## How to find out where an Excel macro is triggered from

How can I find out if 2 macros in an inherited Excel spreadsheet are actually needed, or if they are 'orphan'?
posted by cantthinkofagoodname on May 9, 2016 - 6 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).
posted by primethyme on Apr 30, 2016 - 4 answers

## Excel Question

Is it possible in excel to create a formula that says "if a value in this column is in this range of numbers, put label x in a different column."
posted by Lutoslawski on Apr 28, 2016 - 4 answers

## How can I model the response of a car to a sharp steering input?

I'm doing some work for an engineering company that certifies modifications to cars. One of the tests that they perform is a lane change manoeuvre test. This test simulates an emergency lane change and back to the original lane to prove the stability of the vehicle. Given testing is relatively expensive (as it involves hiring a suitable facility), and involves some risk to the test driver, they have asked me to come up with a spreadsheet or similar that they can use to have a high level of confidence that the test will be safe before they leave the workshop. i don't know how to do that.
posted by trialex on Apr 27, 2016 - 9 answers

## MS Office Reporting Service

Before writing this from scratch I'd like to know if something already exists. The need is for a server that accepts data, document type and an optional template id, and returns an MS Office doc (powerpoint or excel) containing the data, in the selected template.
posted by grubby on Apr 13, 2016 - 1 answer

## 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.
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!
posted by smirkyfodder on Apr 4, 2016 - 9 answers

## How might I randomise some spreadsheet rows once I populate it?

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.
posted by dowcrag on Apr 1, 2016 - 2 answers

## Fastest/Best Way to Get Up to Speed with Excel

TL;DR: Computer comfortable/literate, but only an excel lightweight. How do I become a guru (or at least enough to fake it till I make) and start changing my life?
posted by VillainProtagonist on Mar 24, 2016 - 10 answers

## Excel Question, make chart where each bar is the average of each column

This seems simple to me but can not find the answer on-line. If I have several columns of data, each column is just one variable with several entries. How can I make a chart from this data where each chart column is the average value of each data column. Then add Std. Dev bars to this?
posted by 1inabillionmistake on Mar 10, 2016 - 3 answers

## Excel arithmetic glitch explanation

This isn't getting in the way of anything practical, but it's niggling that I don't understand the technicalities.
posted by protorp on Feb 29, 2016 - 7 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
posted by arniec on Feb 23, 2016 - 11 answers

## Excel to HTML Converter

I have a work order built in excel that I want my database to auto-populate some fields instead of my QEs doing it manually. I've found an add on to do this, but if I want to make the new form look at all like the old form I have to do it in HTML. Is there a good converter for this?
posted by Caravantea on Feb 21, 2016 - 1 answer

## Help me streamline a data gathering workflow?

What started as a screen scraping project has evolved (devolved?) into working with lots of word files with embedded tables. I found and customized an excel macro to extract them on a file by file basis. I'll describe what I'm doing with it inside. Can you give me some pointers on further automating what I'm doing -- or point me to a forum that can?
posted by GPF on Feb 15, 2016 - 3 answers

## Good Excel/CSV data visualisation tools for Windows desktops?

How can I make Excel datasets look nice without too much mucking about?
posted by turbid dahlia on Feb 15, 2016 - 6 answers

## I like to solve problems. How do I get paid to do that?

I've flip flopped on what I want to go to school for and/or what kind of career track I want to aim for. Can you help?
posted by motioncityshakespeare on Feb 7, 2016 - 13 answers

## Writing MS Word macro to convert glossary formatting to Excel table

I need some guidance in writing a macro that will parse a glossary Word document and reformat it into an Excel spreadsheet with the term in one column and the definition in a second column.
posted by beammeup4 on Jan 25, 2016 - 5 answers

## Excel filter: How do I add only data for a given month?

I have an Excel worksheet that logs hikes. The columns are date, location, miles, notes. The rows are hikes. I have a summary worksheet in the same workbook that I use to track progression. Things like cumulative miles for the year, average miles per month. I'd like to add month by month totals. I want to write a formula that will sum the distance only for a particular month (for example, January). I need a formula that will test if the hike occurred in that month, then add the miles to the sum. What would this formula look like?
posted by OrangeDisk on Jan 21, 2016 - 5 answers

## Volunteered to add up the votes for my Book Club; No idea how to do it

This year my Book Club decided to vote on the books we'll read all at once instead of month-by-month. There are 17 books choose from in total and I gave each person a sheet with the books in alpha order. I then asked them to order the books by preference – i.e., their first choice is #1, their second #2 etc.
posted by Lescha on Jan 18, 2016 - 6 answers

## Need help wrangling spreadsheets

Spreadsheets are making me crazy.
posted by triggerfinger on Jan 12, 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.
posted by lost_lettuce on Jan 12, 2016 - 12 answers

## UK business plan financials excel sheet?

I am looking for a straightforward British economic business plan financials calculator for Excel so that I can look serious! I found a similar thing from startupmodels.com but it is really for the USA. Any signposting to something comprehensive with built in calculations?
posted by parmanparman on Dec 20, 2015 - 3 answers

Page: 1 2 3 4 5 6 7 8 ... 20