To-do page

Here are some techniques which we hope to cover soon. If you have any urgent need for any of them please let us know and we could prioritize them according to demand.

Efficient Data Management Techniques (On going)
I believe there are times when you need to handle large data which you may not be proficient enough to handle. I hope this will help you improve your work productivity with some simple tricks. Some of the topic covered includes...

• Complex Sorting
• Handling binary data

Excel with C#

• Recently, I heard from my friends that MS Excel seems to be shifting towards C# and doing away with VBA. So I thought it will be a good start to try and cover how this can be done.

Spreadsheet with C++ (on going)

This is a joint project proposed by me (Ken) and will be managed and implemented by both of us. The purpose of the project is to create a library of functions that allows developers to code with the spreadsheet image in mind. As far as possible, we would like to keep this library platform free so that most people can use it.

Currently, only very basic functions are implemented and many of these functions are not tested. You could go here to look at the currently available API. Please also let us know if you think any functions will be useful to include in this project.

Here are some thoughts:

1. Calendar feature
• Reading [ Completed]
• Left with writing to CSV or XLS
2. Interfacing with SQL
3. Sorting/Date sampling
• Ascending and descending order is available for the following data type:  
• double[ Completed]
• dates[ Completed]
4. Application functions e.g. conditional sum
5. Solver
• Simulated Newton Raphson [Completed]
6. Interpolation
• Natural Cubic Spline Interpolation [ Completed]