Excel and F# with Tsunami and FCell
?Download as PPTX, PDF?
1 like?1,647 views
This document discusses bridging the gap between Excel and .NET by introducing Tsunami and FCell. Tsunami/FCell allows two-way communication between Excel and .NET code, addressing issues like errors in Excel spreadsheets. It was demonstrated by pushing and pulling data between Excel and .NET. Future plans include a free public beta on May 3rd and low-cost versions for individuals with enterprise support available.
Excel and F# with Tsunami and FCell
- 1. Social @tsunamiide tsunami.io Earthquake Enterprises Better Together
- 2. Social @tsunamiide tsunami.io Earthquake Enterprises ? About Us ? The Excel Problem ? Bridging Excel and .Net ? Demo ? Pushing .Net to Excel ? Pulling .Net from Excel ? Future Plans
- 3. Social @tsunamiide tsunami.io Earthquake Enterprises Kennington Workspace
- 4. Social @tsunamiide tsunami.io Earthquake Enterprises
- 5. Social @tsunamiide tsunami.io Earthquake Enterprises ? > 1% of formulae cells contain errors ? 88% of Excel spreadsheets contain errors ? Large spreadsheets have > 12 errors
- 6. Social @tsunamiide tsunami.io Earthquake Enterprises
- 7. Social @tsunamiide tsunami.io Earthquake Enterprises ? Risk Management was modelled in Excel ? Run manually through copy / paste ? One of the errors ? Sum instead of Average -> halved reported risk
- 8. Social @tsunamiide tsunami.io Earthquake Enterprises ? Even renowned Economist write buggy code in Excel ? ¡°Growth in a Time of Debt¡± Reinhart and Rogoff ? Failed to manually select the correct columns ? Substantial effect on the outcome of the study ? Incorrect advice given to government policy makers
- 9. Social @tsunamiide tsunami.io Earthquake Enterprises
- 10. Social @tsunamiide tsunami.io Earthquake Enterprises ? Excel World ? 400 Million entrenched users ? Substantial Existing Investment ? .Net World ? Productivity ? Type Safety ? Testability / Deployment ? Security ? Tsunami / FCell ? Two way bridge between Excel and .Net ? Continue to leverage existing investment in Excel ? Light weight and extensible ? Opens the door to a whole new world of possibilities
- 11. Social @tsunamiide tsunami.io Earthquake Enterprises
- 12. Social @tsunamiide tsunami.io Earthquake Enterprises ? Free Public Beta 3rd May (Next Friday) ? FCell and Tsunami low cost for masses ? Enterprise Version on a quote basis ? Including Consulting and Full Support
- 13. Social @tsunamiide tsunami.io Earthquake Enterprises
- 14. Social @tsunamiide tsunami.io Earthquake Enterprises ? Automate Excel ? Whitelist Dlls to ensure integrity by limiting the code the end users can write