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]
How can I create a web-searchable database of indexed newspaper articles? [more inside]
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]
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]
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]
[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]
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.
Please help settle a bet: Is a spreadsheet a simple type of database, or are they fundamentally different things? [more inside]
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]
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]
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?
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]