09-04 Contents: EuroCACS, EuroAfriCa, Excel Plus oddities
ISSN 1649-2374 This issue online at http://www.sysmod.com/praxis/prax0904.htm [Previous] [Index] [Next]
|Systems Modelling Ltd.: Managing reality in Information Systems - strategies for success|
IN THIS ISSUE
EuroCACS 2009 Frankfurt
|2) European research
EuroAfriCa ICT Forum
The Informatics Development and Social Research Institute
Plus Prefix entry weirdness
Plus wait, there's more...
XLTest 1.06 beta version available
April Fool stories
|9 Web links in this newsletter
|About this newsletter and Archives
Subscribe and Unsubscribe information
You learn something new at every event; I learned of two more Excel oddities this month!
A beta version 1.06 of my XLTest addin for
spreadsheet auditing is now available. It will go on sale at 199 euro
so now is your chance to try a time-limited version for free!
An attendee at our EuroCACS workshop told us of another oddity in Excel.
It fails in both Excel 2003 and 2007.
1) In a cell formatted General, enter +32768/6/3. The result, as expected, is 1820.444
Note carefully: type a plus sign first, rather than your habitual equals sign.
Excel changes the plus sign to an equals, that's the only change.
2) Now format a cell as Number, with the default 2 decimals . Make the same entry. It shows the formula as
=32768/2 and the result is 16384.00
It only fails when there are two slashes, the first number after the plus is 32768 or larger; and the cell is formatted as other than General.
When the final number has a decimal place, it raises "The formula you typed contains an error"
When the middle number has a decimal place, it leaves the formula untouched.
Now you may ask "Who other than an unreformed Lotus 123 user starts a formula with a plus sign?"
The reason is, the IT auditor who reported it is from Hungary. Their keyboard does not have the equals sign in a convenient unshifted position as the US & UK have. So their users are accustomed to starting formulas with the plus sign. When they attempted to divide 100,000 over 31 periods over 31 products, the entry of +100000/31/31 gave the answer of 100,000
from a formula of =100000/1 rather than the expected 104.058. They were concerned at this risk and said that MS acknowledged it as a bug.
A beta version 1.06 is now available. It will go on sale at 199 euro so now is your chance to try a time-limited version for free!
Email me for an evaluation copy.
Toolbar buttons are:
Start new test session Open workbook for testing, start new log, $APP sheet
Workbook Documentation Create $DOC sheet for Workbook documentation
Reset Hidden structure Reset workbook settings, hidden rows, columns, sheets
Detailed Inspection Create $INF sheets of detailed cell inspections
Cell Formulas List / Colour List / Colour cells by distinct formula (R1C1)
Conditional Format Formulas List / Colour Conditional Format Formulas
Data Validation Formulas List / Colour Data Validation Formulas
Colour Data Type and Usage Colours cells by data type and input/output type
Colour Precedents Colour by Precedents location
Colour Dependents Colour by Dependents location or count
Remove colours Remove interior fill colours of cells
Watch active cell Keeps an info window open on current selection Shortcut: Ctrl+Alt+w
Flag active cell Places a flag on the cell for a table of contents Shortcut: Ctrl+Alt+f
Add supporting sheets Add $Readme, Palette, Table of Contents sheets
Unprotect sheet Remove protection of sheet contents
Compare worksheets Compare two worksheets
Compare workbooks Compare two workbooks (same named sheets)
Options Options for what to search for when documenting
Help Help on colours and keyboard shortcuts Shortcut: Ctrl+Alt+h
About XLTest User and License information
Simply send your comments to FEEDBACK (at) SYSMOD (dot) COM
Thank you! Patrick O'Beirne, Editor
http://mail.google.com/mail/help/autopilot/index.html Google's version of autocomplete for email.
I particularly enjoyed the Wolfpigeon skit on ubiquitous wireless networking
MS had a techy "Negative Sleeps in VB":
Copyright (c) Systems Modelling Limited,
. Reproduction allowed provided this copyright notice is included.
We appreciate any feedback or suggestions for improvement. If you have received this newsletter from anybody else, we urge you to sign up for your personal copy by sending a blank email to EuroIS-subscribe (at) yahoogroups (dot) com
For those who would like to do more than receive the monthly newsletter, the EuroIS list makes it easy for you to discuss issues raised, to share experiences with the rest of the group, and to contribute files to a common user community pool independent of the sysmod.com web site. I moderate posts to the EuroIS list, to screen out inappropriate material.
Patrick O'Beirne, Editor
ABOUT THIS NEWSLETTER
"Praxis" means model or example, from the Greek verb "to do". The name is chosen to reflect our focus on practical solutions to IS problems, avoiding hype. If you like acronyms, think of it as "Patrick's reports and analysis across Information Systems".
Please tell a friend about this newsletter.
We especially appreciate a link to www.sysmod.com from your web site!
To read previous issues of this newsletter please visit our web site at http://www.sysmod.com/praxis.htm
This newsletter is prepared in good faith and the information has been taken from observation and other sources believed to be reliable. Systems Modelling Ltd. (SML) does not represent expressly or by implication the accuracy, truthfulness or reliability of any information provided. It is a condition of use that users accept that SML has no liability for any errors, inaccuracies or omissions. The information is not intended to constitute legal or professional advice. You should consult a professional at Systems Modelling Ltd. directly for advice that is specifically tailored to your particular circumstances.
We guarantee not to sell, trade or give your e-mail address to anyone.
To subscribe to this Newsletter send an email to
EuroIS-subscribe (at) yahoogroups (dot) com
To unsubscribe from this Newsletter send an email to
EuroIS-unsubscribe (at) yahoogroups (dot) com
EuroIS is the distribution list server of the PraxIS newsletter. It also offers a moderated discussion list for readers and a free shared storage area for user-contributed files. The archives of this group are on YahooGroups website http://finance.groups.yahoo.com/group/EuroIS/