15 posts tagged with database and spreadsheet.
Displaying 1 through 15 of 15. Subscribe:

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

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

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

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

I've made a huge mistake?

How can I create a web-searchable database of indexed newspaper articles? [more inside]
posted by orrnyereg on Sep 19, 2012 - 6 answers

Spreadsheet vs. Database?

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

Keeping track of payments?

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

How do I turn Gmail into a database?

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

I can build it, I just need to know what kind of bricks.

[web programming filter] I need to build a web page that displays spreadsheet data. The data in the spreadsheet changes depending on which user is logged in to the site. Some of the data is preset and some is entered by the user (and saved between sessions). What might be the most efficient programming solution and the easiest to maintain? [more inside]
posted by Drasher on Aug 3, 2010 - 8 answers

Spreadsheets, Databases - Help Me. Please.

Well, I created a spreadsheet in Google docs. A simple, no frills document where there are various columns - one s for email addresses. Those addresses I want to go into my Address book in either Gmail or Thunderbird. Downloaded the spreadsheet into Excel - in CSV format - tried to save it to text - it's obviously not working. Someone online directed me to the Google Scripts and to API. This is so not my forte' and it's for a non-profit and am getting lost in a sea of geekage. Is there a simple way to just export the column of email addresses, convert them into a database separated by columns, fit for my email program? Thanks in advance.
posted by watercarrier on Jul 21, 2010 - 15 answers

Better than vi versus emacs!

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

Sort Me Out

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

Help me prioritize the people I bug for money

Excel-filter: I have a spreadsheet with a list of donations made over the past year. Unfortunately, when an individual has donated multiple times within a year there is a new row for each donation. Fortunately, that individual is assigned the same unique identifier. How do I make it so that each individual has one row with total donations for the year? [more inside]
posted by ewiar on May 1, 2007 - 6 answers

Database for a small merchant

Help, business owners! I run a mail order business -- about 3-5 orders a day, with about 15 items in stock. For years I have used an Excel spreadsheet to keep track of orders. Is there a better way? [more inside]
posted by hodyoaten on Oct 2, 2006 - 5 answers

How to run a SQL Query on an Excel Spreadsheet

I have an Excel Spreadsheet (using Excel 2003). Rather than creating formulas to answer ad hoc questions that I have, I would like to be able to quickly type in a SQL querty against the data in the spreadsheet. So, I could scroll down to the bottom of the sheet to see how many rows I have, OR I could type" select count(*) from data_table" instead. I prefer the latter. Any suggestions? [more inside]
posted by apark on Apr 7, 2006 - 6 answers

Page: 1