Report:Knovel/Productivity Tools/Excel Spreadsheets
|Report||Patent Coverage Map||Ratings||Comments|
|This search system report was created by the Intellogist Team and is available for viewing only. If you'd like to share your knowledge on Intellogist, please visit the Best Practices, Glossary, or Community Reports pages. Registered users may be notified of any substantial changes to this report by placing a "watch" on the Revisions page, which is the last page listed in the table of contents. To learn more about using the Intellogist "watchlist," see the Watchlist Help page.|| |
Some sections of full-text contain sample calculations and are accompanied by an Excel spreadsheet based off of the sample, but allowing the user to change parameters to see how it affects the resulting calculation. These spreadsheets are helpful when a user has a real world situation that fits the sample. The user can user the spreadsheet to check work already done, or to avoid spending time doing the calculations manually.
These Excel spreadsheets are useful by themselves, but there may be additional value for engineers and scientists in taking an example spreadsheet and using that as a template for similar calculations, as many of the calculations have already been entered into Excel using the proper syntax.
In June 2009, Knovel introduced a new productivity tool, Knovel Math, which provides Mathcad worksheets for engineering calculations. The data in the worksheets is taken from engineering reference works including Roark’s Formulas for Stress and Strain and Hick’s Handbook of Civil Engineering Calculations, and according to Knovel has been fully documented and validated. In its internal description of the feature, Knovel suggests that the templates can be helpful for users who need to perform calculations, analyze structures, and/or document and design engineering solutions.
The content is provided alongside full text excerpts from the original reference work, providing context to help users select the appropriate equations. The worksheets are available in both US customary and metric units.
Mathcad version 14.0 or higher is supported by the tool.
As an example of the functionality of a Mathcad-enabled entry, the following text describes the Mathcad-enabled content for Hick’s Handbook of Civil Engineering Calculations:
- Almost the entire book has been made interactive using Mathcad. Over 410 civil engineering calculation examples covering a wide scope of topics such as structural steel and timber engineering, soil and fluid mechanics, pumps, piping, and hydro power have been make interactive using Mathcad.