As of right now excel functions show up as the function and cells included. Having the excel functions show the actual equations and values can be useful for visualizing data and formulas.
Add functionality to add cells with text only to the calculation sheet. This would allow for the development of a full report rather than limiting the calculation sheet to a proof calculation of one (or many) equation. Maybe a new module is required to develop a "Report" rather than a "Sheet", including: • header/footer • allow for images • text input for notes/assumptions • allow for text input in the variables section so the variables can be categorized • say I want similar variables describing properties of "Beam A" and "Beam B" it would be nice to separate these under a different header • Or give the option to print the variables in line with the equations as they are entered into the excel sheet, sometimes its easier to not have all the variables in the beginning of the report rather show them where they are being used in the calculation sheet. As it stands, the calculations sheet function is very powerful but the application is limited, ideally this could be improved to the point where this "Calculation Report" is what gets printed as the final product rather than printing the excel sheet. If it is helpful I could create a PDF of what I would like to see this output look like? Thanks, Mario LoCoco
While the usage of the side bar tab view is amazing - the downside is the ability to drag/drop the arrangement.
Quick Navigator currently shows all sheets across all open workbooks sorted by most recently accessed. The idea is to change to display to show a single column of most recently used, then columns to the right, one per open workbook, that list the sheets in the workbook in index order (or alphabetically). This allows user to quick TAB between most recently used as well as use the same CTRL+TAB shortcut to quickly access any sheet, in an order that doesn't keep changing. Optionally incorporate recent bookmarks into the most recently accessed list.
I'm thinking of something like Visual Studio CTRL+K, CTRL+K. Then I can use shortcut keys to jump around quickly.
For any formula, show a calculation sheet of the build-up of the entire calculation, for use with manual verification of engineering formulas.
Using an existing formula as an example, create a new function by selecting which parts of a formula should be changed into variables by clicking on them.