• Overview

How to use TK Solver and Excel in combination

Schematic showing multiple TK applications being accessed (inputs and outputs) from a centralized Excel Application

How to use TK Solver and Excel in combination

The TK Excel Interface:

  1. Provides a seamless, bi-directional transfer of information between TK Solver and Excel.
  2. The ability to split up a complex problem into one or more TK Solver models and then to link them together into powerful applications that can be developed far quicker. Most of the calculations can be configured in TK Solver with Excel being used as a “dashboard”. Data can be moved from one TK model to another using Excel as the linking mechanism.
  3. The combination of TK Solver and Excel also reduces life cycle maintenance problems and cost.
  4. VBA in Excel can also be used where appropriate.
  5. The TK Excel link significantly reduces spreadsheet complexity.
  6. The TK Excel link facilitates IP protection through separation of the calculation modules from the spreadsheet.
  7. TK is capable of reading data from MS Access or SQL Server, incorporating a powerful, centralized database.
  8. TK Solver has many other capabilities like interpolation, curve fitting, table look ups, differential equation solving, simulation, etc. which help in considerably reducing development time.
  9. The TK Excel Link accesses the back-solving and units management capability of TK Solver.
  10. The TK Excel interface is quick, reliable, and impressive.
  11. The TK Excel interface learning curve is short.
UTS would be glad to provide training to application developers so that they can be productive quickly.

Roark’s Formulas for Excel

A great example of a major application using TK ⇔ Excel Link.

  1. Menu
    rfe menu
  2. Wizard
    rfe wizard
  3. Layout
    rfe layout
    rfe layout
  4. Report
    rfe report
  5. Beam Superposition Wizard
    rfe Beam Superposition Wizard
    rfe Beam Superposition Wizard