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]
We are storing information about application hits in a database. Sadly my database/excel skills are pretty limited and I'd like some help getting more info out of the information we have. [more inside]
I'm designing and managing a very ambitious data visualization app for the arts and culture sector, and am trying to find the best way to organize the data types and attributes. Excel just ain't doin' it anymore. [more inside]
I'm compiling an Excel spreadsheet full of personal data. What my employer would like to do is add that information to their existing website and make it searchable and filterable, so that researchers can filter out all guys who were born in year X or town Y, search for all guys named Cohen, etc. [more inside]
Android/cloud-based note app query. I'm looking for recommendations for an Android app that'll accept the large chunk of csv data I have and keep it synced with my PC. [more inside]
Part of my current job involves manipulating a large amount of data. I need to learn how to do this more efficiently and on a larger scale. What should I use? What should I learn? What is the best (free) way to teach myself? [more inside]
Microsoft Access 2007 - how on earth do I cut / copy / export / do anything with my Pivot Chart, besides print it? [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.
I need help visually and clearly showing/analyzing surname data retrieved from 23andme.com's Relative Finder feature. [more inside]
I'm making an archival database (in Excel) with about 10,000 rows and 6-7 columns for each row. I'm doing this so the information will be easy to cross-reference and search. I've never done anything like this before and am looking for books, blogs, etc. for tips, suggestions, and anything that will make my life and this project easier.
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]
Crazy excel help needed... again. Every month I have a monotonous series of tasks to perform in excel and I have exhausted all of the possibilities I know of to make things easier- more details inside. [more inside]
Looking ideas on what systems can be used for efficient internal business reporting in a small / medium business
What efficient systems can one use to report different internal working data generated in a small / medium sized business - excel is too clumsy and a customized database based application feels like an overkill? [more inside]
How to extract data automatically from a group of HTML pages to an Excel file or to a database? [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]
I am tasked with preparing a multi-category, filterable timeline as a work project. I think Access is probably the best way to do this, but I need some help with the mechanics, or suggestions on where to find a template. [more inside]
My friend works in database applications each day to create in house reports. He's bored and wants to go it alone. [more inside]
Excel Filter : I've got a list of a lot of names. All the names are in one column with a different name on each row. The names repeat a varying number of times. How can I get Excel to count how many times each name repeats and then put that number in a column next to the name? [more inside]
cp /mnt/com/ebay/completed_auctions/ps3 ~/ps3.txt ?? [more inside]
What's the easiest way to merge data from multiple Excel worksheets into one big worksheet [more inside]
How can I get data from the USDA's food database into excel? [more inside]
I need suggestions for an application (or database) to help my employer keep better track of live-trivia scorekeeping results. They are currently doing it all in various separate Excel spreadsheets, and this is (almost) 2008, so I'm sure there must be a better way. [more inside]
Please help me create an expandable excel function that can find and extract cell rows. [more inside]
How do I add a 4,000 name MS Excel file to an existing MS Access database? [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]
Is there an easy, preferably open source way of editing MySQL table contents? I was hoping for something which would let me use Excel (or OO Calc) to edit the live database. I need to search/replace many items in a poorly imported database. [more inside]
I have a data set of approximately 9,000 hip-hop tracks. It's in an Excel file. I have the song title, the artist, and the album. Now I just need the year. How can I find and automatically import the year into the Excel file without manually looking up every track on Google? Is there a way to do this with MusicBrainz or a similar database?
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]
Basic Microsoft Excel question. How do I join two databases together when they share elements but are not coextensively equal? (More) [more inside]
Database 101... I have two tables, with one common field, an ID number. One table has many more records than the other. How can I tell which records in the 'big' table are also in the 'small' table? [more inside]
Invoicing with MS Excel--squeezing relational database features out [MI]