Skip

44 posts tagged with spreadsheets.
Displaying 1 through 44 of 44. Subscribe:

Android Widget that displays Google Spreadsheet data?

Is there an Android Widget that will allow me to display a subset of data from Google Spreadsheets? I keep track of my budget in a spreadsheet, and I would like to display the balances in a quick way on my phone without actually having to open the Google Sheets application. [more inside]
posted by SpacemanStix on Sep 20, 2014 - 3 answers

Publish many Google Spreadsheets at once?

Is there a way to tell Google Drive to use the "publish to the web" option--but not for a single spreadsheet, but rather for an entire folder full of 450 spreadsheets? [more inside]
posted by johngoren on Sep 8, 2014 - 1 answer

What are some interesting facts about Microsoft Excel?

I work extensively with Microsoft Excel, and I'm putting together a list of little known facts about Excel for a presentation. I haven't found much on the interwebs that's exceptionally interesting. Does anyone have any facts they can share that come from off the beaten path? [more inside]
posted by scottso17 on Jun 25, 2014 - 52 answers

Parsing statistical data

I have a spreadsheet with 120,000 or so rows & need to pull out some data. [more inside]
posted by woodman on May 12, 2014 - 12 answers

Entering Data in Semi-Protected Google Spreadsheets

I work in a high school where we often want teachers to fill out a single Google spreadsheet with information about students in their homeroom class. [more inside]
posted by allison00 on Nov 14, 2013 - 7 answers

First Python script, as a web app, using APIs & Excel. What do I need?

This is a bit of a convoluted problem, but I'll try to keep it brief. I work for a SaaS company that is totally awesome. I love what I do, but I want to develop on my skills at coding to help further my career and give me more interesting work opportunities at said company. In order to do so, I've been learning a bit of Python here and there, hoping to build on my HTML/CSS knowledge for web app development. I have a project in mind that involves writing a Python script that will combine data from Salesforce, a web form, and an Excel spreadsheet into one shiny CSV file/spreadsheet. Bonus points if it can use the Salesforce AND GoToTraining APIs simultaneously, since it'll be combining information from both sources. This will be a slow project, since I'm a bit of a newbie to Python. What libraries should I use, and what resources can help me get there? After I finish some Python courses, where should I go? [more inside]
posted by summerteeth on Jul 8, 2013 - 3 answers

No, this isn't about EVE Online.

I need help taming a very long list of numbers into useful tabulated data, in Excel. [more inside]
posted by 256 on Feb 28, 2013 - 10 answers

Correlating names between two spreadsheets

I need to correlate two spreadsheets which relate to the same group of people. The name data is messy, however, and I'm having a hard time matching the names. [more inside]
posted by mammary16 on Jan 18, 2013 - 8 answers

Help me EXCEL at my new job. (Yes, I went for the obvious one.)

What books or websites should I look at if I want to master Excel? [more inside]
posted by synecdoche on Dec 16, 2012 - 9 answers

Excel colour schemes are making me go blind

How do I permanently change the colour scheme in Excel (2010) so that I don't keep on going blind due to other people's spreadsheets? [more inside]
posted by Katemonkey on Oct 18, 2012 - 16 answers

iTunes Viewing Options for a Table or Spreadsheet?

What Mac program should I use for a chart to keep track of my upcoming job applications? You know how in iTunes, you can see the same music library listed alphabetically by artist, or by album, or by genre, and so on? I'd like to be able to view the same bunch of jobs listed by deadline, or by ad number, or alphabetically by requirements. [more inside]
posted by Beardman on Oct 1, 2012 - 9 answers

Excel copy/paste question

Probably a simple Excel copy/paste issue... [more inside]
posted by xedrik on Jun 8, 2012 - 5 answers

Why don't they teach us how to prep the numbers as well as how to crunch them?

ExcelFilter: How to combine the data from three spreadsheets into one spreadsheet? (But wait, there's more!) [more inside]
posted by smirkette on Mar 26, 2012 - 10 answers

Help me become a spreadsheet power user

How do I become a spreadsheet power user? And do I have to get Excel to do it? (Or can I stick with LibreOffice/Google Docs?) [more inside]
posted by Busoni on Nov 19, 2011 - 10 answers

Can Google spreadsheets solve my problem?

I have a massive Google spreadsheet containing entry info for a small film festival. I need to be able to produce tailored reports from it that only contain need-to-know info, instead of making people look at the master sheet. Is this possible? If not, what online software should I use? [more inside]
posted by goatdog on Sep 23, 2011 - 5 answers

Show all formulas.

I'm an artist. Please help me find a day job that makes use of my bizarre love of spreadsheets. [more inside]
posted by HeroZero on May 15, 2011 - 8 answers

How do I important the data from hundreds of documents into spreadsheets?

How do I use OCR to scan a standard document into an excel spreadsheet? [more inside]
posted by perpetualstroll on May 3, 2011 - 3 answers

How can I edit someone's required google form list to include my unique entry?

How can I edit/alter a friend's Google Spreadsheet Form so I can put my own answer in required list items? [more inside]
posted by gryftir on Apr 13, 2011 - 2 answers

EXCEL Vs. Time Left

Excel Question! I have two dates on my spreadsheet. How can I accurately determine (retrieve) the time remaining on a warranty date. [more inside]
posted by TeachTheDead on Mar 25, 2011 - 9 answers

I need to create a website FAST for rapidly changing information

I need to slap together a website FAST that contains a map and a (sortable? filterable?) list of Wisconsin-related protest/rally events. I'd really, really like it if people could enter their own events and they'd show up on the map without a lot of intervention on my part. [more inside]
posted by desjardins on Mar 10, 2011 - 11 answers

Have paragraphs. Want just the hyperlinks. In Excel.

Need list of trade publications. Found huge one on Ulrich's web. How can I remove all information except for the (hyperlinked) titles, ideally in a way that keeps the titles on separate lines so I can then paste them into Excel? [more inside]
posted by randomname25 on May 19, 2010 - 10 answers

Excel Filter: Search the contents of one cell for the contents of another cell, then replace with the contents of yet another cell? Is it possible?

I need to search the text in column A for the text in column B, replace it with the text in column C, and return the new complete string to column D. I've Googled. I've read. I've cried. Can you please help me? [more inside]
posted by Salient on Feb 24, 2010 - 5 answers

I want to turn my Google Docs spreadsheet of a route into something prettier with photos and stats - how to do it easily?

I want to turn my Google Docs spreadsheet of a route into something prettier with photos and stats - how to do it easily? [more inside]
posted by soulbarn on Aug 12, 2009 - 3 answers

Excel AVERAGE questions.

Trying to get some modified AVERAGE results in Excel. [more inside]
posted by FatherDagon on Aug 5, 2009 - 5 answers

Concatewhat?

I need to merge two Excel sheets with some common fields, but the most advanced formula I've ever used is Autosum. [more inside]
posted by thebazilist on Jul 7, 2009 - 9 answers

Getting Google Spreadsheets to interpret string as formula

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

How do I unsquish my Google Docs spreadsheet?

My Google spreadsheet collapsed itself in the middle somehow. How do I get it back? [more inside]
posted by mathowie on Feb 5, 2009 - 5 answers

Compare and output greater value.

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

AutoFilter equivalent in Google Docs Spreadsheets?

I want to be able to filter my data in Google Docs Spreadsheets like the Data > Filter > AutoFilter function in Excel 2003. [more inside]
posted by Jacqueline on Oct 7, 2008 - 1 answer

I know, I know - I shouldn't even be using Excel!

ExcelFilter: How can I create a spreadsheet that automatically copies a certain type of cell from one column to another? [more inside]
posted by CXImran on Sep 26, 2008 - 7 answers

Sorting Embedded Google Spreadsheets

I am looking for a way to sort embedded Google Spreadsheets. I am not looking for advanced features or interacting with the data, but ONLY client side sorting. [more inside]
posted by joemako on Aug 11, 2008 - 2 answers

Google Spreadsheets / Charts Help

Let's say I have a two column chart, with the following values: [more inside]
posted by underdetermined on Apr 29, 2008 - 10 answers

How to get submission form fields from email to database and more!

How can a new company track leads submitted via its website through the sales and post-sales process, simply, automatically, and online? [more inside]
posted by prophetsearcher on Jan 30, 2008 - 12 answers

Open source spreadsheets for the excel-challenged

Looking for open source spreadsheet templates I can use commercially (if it comes to that) for recipes, fitness programs and the like. Why? Because my excel skills suck. [more inside]
posted by cameron.case on Dec 18, 2007 - 5 answers

Software to track project/client information?

What kind of software can I use to keep track of information on each client and/or project that I'm working on? [more inside]
posted by iguanapolitico on Apr 24, 2007 - 7 answers

How do I get my table rows to stay clumped in fives?

How do I get a the rows in a table to stay clumped in fives even if I add or change the data?I have a long list of data that I need to arrange in a table, and I want the rows grouped together in fives. I'm currently working in Microsoft Word, and what I've got looks something like this Google Doc. I want the table(s) to stay grouped like this even if I add, delete, or change the data. If I just use the Word tables, adding a new line to a group will just create an extra row. [more inside]
posted by bokinney on Mar 12, 2007 - 7 answers

iRows shutting down. How do I share my spreadsheets now?

Well, the people at iRows are shutting down their service at the end of the year and I need to find a way to share my spreadsheets with other people. As usual, there are some problems [more inside]
posted by killa62 on Nov 15, 2006 - 8 answers

What would be a good way to calculate "fuck-you money"?

What would be a good way to calculate "fuck-you money"? [more inside]
posted by ElfWord on Sep 28, 2006 - 30 answers

What is this even called?

What kind of jobs exist for people who think about numbers and money from a consumer perspective, in a weirdly logical and obsessive way? [more inside]
posted by croutonsupafreak on Sep 11, 2006 - 18 answers

Cell 64,999

I used to think I was good at Excel. I could add, subtract, multiply and even use PivotTables! But I have a big problem with Excel: Why does it jump to cell 65,000 occasionally when you try to copy and paste? [more inside]
posted by Happydaz on Jul 4, 2005 - 6 answers

ExcelFilter: I don't see an easy one-function way to get the initial letters of a text string in Excel. Is there such a beast?

ExcelFilter: I don't see an easy one-function way to get the initial letters of a text string in Excel. Is there such a beast? [=Text(MI)] [more inside]
posted by mwhybark on Sep 29, 2004 - 8 answers

Excel Spreadsheet Updating

Excel query. I have two Excel spreadsheets that I want to have automativally update each other. But, the format that they are in is generally incompatible. These are used as scheduling documents for the place where I work.

One spreadsheet is very wide. It lists each individual person at the top and their personal schedule below it. It lists breaks using "ONE" as the first half of a 30 minute block, "TWO" as the second half of a 30 minute block, and "LONG" as the entire 30 minute block.

The other spreadsheet is much less wide. It has 7 days listed and three columns. One is for "LONG" one is for "ONE" and the third is for "TWO." In each column, each person's name is entered in the appropriate block as defined in the first spreadsheet.

Can I get those two to talk to each other? Can I tell the first spreadsheet that if the word "TWO" is in a certain field to put the name of that person in another field on another spreadsheet?
posted by ajpresto on May 11, 2004 - 1 answer

OpenOffice Saves in MSOffice Format -- So Is Buying MS Office Worth It?

I've been thinking about plunking down the cash to buy a licensed copy of MS Office (or Office XP, or Office 2003, etc.) for my new laptop. Can anyone tell me why I shouldn't just run Openoffice instead? From what I've read, it appears that I can "save as" most MS formats with it. Any firsthand experience?
posted by trharlan on Feb 23, 2004 - 19 answers

Removing duplicates from excel sheet

I'm working with an alphabetical list of email addresses in Excel, approx. 8500 addresses long. Is there any quick way to remove duplicates outside of manually scrolling through and deleting them by hand?
posted by rocketman on Jan 7, 2004 - 7 answers

Page: 1
Posts