User Input Precisio...
 
Notifications
Clear all

User Input Precision?

3 Posts
2 Users
0 Likes
332 Views
(@bo3b)
Trusted Member Customer
Joined: 2 years ago
Posts: 50
Topic starter  

Noticed, some User data input cells accept a fractional number but PRC displays a rounded whole number. AFAIK, underlying math associated with full actual input appears to be correct.

For instance, with $1M invested in 100% Bonds at 1% return;
With "Asset Class Taxation" of 100%, AGI = $10,000 and correctly (input match) displays 100% in Taxation table.
Change Taxation to 99.5% and PRC still displays 100% BUT returns $9,950 AGI.

Other areas?

Again, math is correct, and perhaps impact to User relatively trivial, but behavior would seem somewhat contrary to generally accepted software design practices and has potential to create confusion.

(NOTE: Excel provides "Options -> Advanced; When Calculating this Workbook; Set Precision as Displayed" setting that is perhaps related to this issue but reluctant to experiment for fear of potentially corrupting protected workbook...)

Bob

PRC2022.2.26
Windows 10 Home 64-bit Version: 19042.1526
Microsoft Office Professional Plus 2013
HP Spectre x360 Laptop w/16 GB


   
ReplyQuote
(@smatthews51)
Member Admin
Joined: 4 years ago
Posts: 718
 

User inputs are saved in the precision entered but I think it's safe for you to use the "Set Precision as Displayed" option if you wish. I've done a bit of testing with it and haven't seen any issues.

Stuart


   
ReplyQuote
(@bo3b)
Trusted Member Customer
Joined: 2 years ago
Posts: 50
Topic starter  

@smatthews51 Thanks, experimented somewhat with Excel "Set Precision as Displayed" option and setting does not appear to have any affect on the fact that PRC Inputs, in some areas, will appear rounded from actual User entry and therefore mismatch Outputs. Again, this may cause confusion and would seem non-standard software design.


   
ReplyQuote
Share: