Reputation
323
Top tag
Next privilege 500 Rep.
Access review queues
Badges
2 11
Newest
 Critic
Impact
~3k people reached

  • 0 posts edited
  • 0 helpful flags
  • 28 votes cast
Mar
9
comment Replacing Excel with Mathematica Using 2D Tables
So to summarize, I keep the calculation notebook as straightforward as possible, laid out just like a typical hand calculation (problem description, assumptions, inputs, calculations, results), and create a pretty output report for the customer.
Mar
9
comment Replacing Excel with Mathematica Using 2D Tables
The calculations and results output can be separated into other sections. Finally, I save this notebook with functions and placeholders and any explanatory text needed, and then open a copy for each calculation. For larger calculations I will use an output function to create a new notebook suitable for a customer submittal document.
Mar
9
comment Replacing Excel with Mathematica Using 2D Tables
I don't find any problems with finding the inputs in a mass of code. First off, you can put your functions in a package or in an initialization section of your notebook, with the cell closed to hide it until a checker needs to review it. Second, I use sections to group all the inputs together. Third, I use Placeholder to show the places that need to be filled in. For the previous example, you would type P=Quantity[Placeholder["peak power transmitted"],"Watts"] then select the placeholder code and use Evaluate in Place to replace it with the resulting placeholder box.
Mar
9
comment Replacing Excel with Mathematica Using 2D Tables
I only use Manipulates in a very limited fashion for inputs. I don't like to have dynamic elements in a calculation because it increases the complexity, makes it harder for others to understand and check, and can cause problems saving the state of the inputs so the notebook can be reopened. When I do use them, usually for situations where I want to see live graphics or calculations to guide the inputs, I set them up to CellPrint an Input cell setting each of the input variables, e.g. P=Quantity[1000000,"Watts"].
Mar
8
comment Replacing Excel with Mathematica Using 2D Tables
I successfully use Mathematica for similar engineering calculations. You should let go of the idea that it needs to be organized the same as in Excel. Hand calculations on paper are laid out similarly to the Notebook format, and served engineers very well for many decades. I find Notebooks easier to read, check and pass on to others. You can use Grid to summarize inputs and results, and the new template features can generate reports suitable for customers.
Feb
1
comment Front End options
You could cover the use of Inherited to unset an option without using the Option Inspector.
Sep
17
awarded  Critic
Sep
3
comment notebook scrolling problem in 10.2: worse than ever? how to fix?
Try turning off the Predictive interface
Aug
25
answered Change Notebook's Default Context
Aug
18
awarded  Necromancer
Aug
18
awarded  Yearling
Jul
31
comment How accurate is GeoDistance?
I received a response from Wolfram Tech Support that they have forwarded an incident report to the developers regarding this.
Jul
31
comment How accurate is GeoDistance?
They are slightly different. (1) gives 11144873.39798774 m and 0.00000000007791086747713033 deg, (2) gives 5572436.698995231 m and 0.0000000001298175198786149 deg, and (3) gives 5572436.698995231 m and -82.9990873583041 deg. Max relative error on distance is 5E-10 %, on direction it is 0.3 % for example (1).
Jul
31
answered How accurate is GeoDistance?
Jul
27
comment Front End does not respond to keys (version 10.2, Linux)
I can't reproduce this in Windows with 10.0.2, but we have had problems with key mappings getting mixed up when launching from Eclipse. All of the Cntl key combos stop working properly, and a relaunch is required to fix it.
Apr
13
awarded  Commentator
Apr
13
comment Guidance for CDF Development, Security and Future of CDF?
Since you are physically present for the reviews, the best option is to do away with the CDs and bring a computer that has no network adaptor to the reviewer. For applications on the intranet I use CDFs that get all their data from a file server that we control and log access to. Loss of the CDF is not an issue because they contain no sensitive information.
Mar
18
awarded  Popular Question
Oct
14
asked How to use named arguments in .NET/Link (COM interface to Excel)
Sep
24
awarded  Autobiographer