...
- Convert *.xlsx file to *.csv using conversion API so that you can see the content of the file on the VM. We are not installing any office software on the VM.
- use extraction API to extract columns from the file and
- Perform some analysis and add to the technical metadata
- Write an extractor
/converter for this problem- This should be an enticing yet simple problem that can handle many spreadsheets and get a result.
- Ideas
- An algebra 101, traveling trains problem. 2 trains leave 2 different stations on tracks heading toward a junction. Given a spreadsheet with departure times, distances, velocities, etc., upload all the spreadsheets and determine if they will crash.
- This problem is simple and would provide the user an easily understood problem that can clearly be scaled to much more involved traffic problems.
- However, it doesn't really present a cool new idea. It may be preferable to think of something more cutting edge technology
- A bacterial growth model. Given a culture with varied conditions, eg. pH, stored in multiple spreadsheets, determine the growth rate. Might be able to base this on http://mathinsight.org/bacteria_growth_initial_model
- This would require a few minutes of explanation of the model and would require some learning by the developer of the extractor.
- Still maybe not that enticing.
- Better Ideas?
- An algebra 101, traveling trains problem. 2 trains leave 2 different stations on tracks heading toward a junction. Given a spreadsheet with departure times, distances, velocities, etc., upload all the spreadsheets and determine if they will crash.
CSV files (Ameriflux), use BD for some gap-filing on the files and return result.- Problem 5: Obtaining Ameriflux data and converting into *.clim format (similar to csv format but tab separated) for SNIPET model. Calculate average air temperature and its standard deviation. (This will emphasize both conversion and analysis)
Think of a MATLAB clientWant to build a Web application on top of BD, (Similar to what Marcus build??)Use BD convert to convert a collection of images with old format to png or pdf. convert odp/odt to ppt/doc
...