And the winner is …

29 04 2017

Building applications for small screen sizes is always a big challenge. Apple and Microsoft both offer their productivity suites iWork resp. Office for smartphones. If you never tried to create or use a spreadsheet on a smartphone I’m quite sure you would say that it’s against all right ideas about how things ought to be.

Well, I’m sure you would revise your opinion if you try it out for some days.


The first versions of Office for iOS were far behind Apple’s iWork suite but today the tables have turned. Microsoft overtook lots of innovative ideas Apple implemented in their mobile app versions. I don’t care about copycats. I’m a user and so I’m just interested in perfect solutions whoever created them.

Microsoft reconquered the pole position if it comes to Excel vs. Numbers.

And the reason is that Apple did a very poor job with its latest update for its spreadsheet app NUMBERS. Entering data and moving the focus from cell to cell is a disaster.

Well done, Microsoft.
Do your homework, Apple.

I would like to know who at Apple is responsible for the final inspection of the UI. Transfer him for disciplinary reasons, maybe he is better in testing the Apple car.

I would also like to know why Microsoft’s iOS versions of Office are a lot better than their Windows 10 Mobile counterparts. Sad but true.

Thanks.





Visualizing your Success

5 06 2015

Some people think that personal success can be measured in bucks, clicks, +1s, or Likes.

So I won’t be surprised if somebody wants to visualize his personal value with a chart created with Apple’s spreadsheet app Numbers for iOS.

Here is the tutorial.

  • Step 1
    Create a new spreadsheet within Numbers.
  • Step 2
    Create a table (table 1, top left) and enter the months and the corresponding number of bucks or clicks in a month.
    The last row should contain the sum. It’s needed to display the relative amount of success (the ratio bucks / total x 100).

2015/01/img_3776.png

  • Step 3
    Create another table (below the first table). This table isn’t really needed but usually it’s worth to separate the data from its visualization.
    Refer to the the first two columns of table 1 by using terms like ‘=Table 1::A1’. This will show the months and the absolute values of bucks.
  • Step 4
    Now let’s create the crux of the matter.
    Use the built-in function REPT (Repeat) with the money bag (from Apple’s Emoji keyboard; activation via Settings – General – Keyboard – Keyboards – Add New Keyboard and select Emoji).

Refer to Apple’s excellent help for this function and all the others to understand the parameters.

  • Param 1
    the symbol you want to use for the bar graph
  • Param 2
    the length of the bar (the monthly value in % of the total)

Use it and you will see that Numbers for iOS is perfectly adapted to touch screens.

Note
If you want to refer to a cell of an other table in a function, just tap on it instead of entering the table number and the coordinates. That’s perfect user experience, isn’t it?

Now your visualized success is always with you, on an iPhone, an iPad, or an  Watch.

I suggest to publish your stats quarterly on the internet like Apple does in its U.S. Securities and Exchange Commission (SEC) filings.

Summary …

The usage of functions in Numbers is explained in meaningful helps.
An alternative is to enter the values in a table and use the feature Create Chart from Table. But that would be too easy. Always following the KISS principle doesn’t help you to improve your knowledge.

Related links …

Avoid a Liquidity Bottleneck

An Invoice created with Numbers

If Then Else

Thanks for visiting iNotes4You.





Avoid a Liquidity Bottleneck

18 06 2014

To avoid a liquidity bottleneck at the end of a month you can use Apple’s iWork app Numbers. Once you created an appropriate spreadsheet with the necessary information you can predict your account balance more or less accurately (if the rare event of a crashed iOS device doesn’t happen and you are out of warranty claim).

Here is an example to create the spreadsheet using functions implemented in Numbers and some other tricky algorithms. The good news is, it’s synced with all your other devices via iCloud. So the information is available wherever you are.

The components …

What you need is

  • Apple’s iWork app Numbers
    It’s part of Apple’s iWork suite, the pendant to Microsoft’s Office suite with one important difference: it’s optimized for touch screens and seamless to use even on the small screen of an iPhone and all your documents are automatically synced with all your devices. You can even work on your documents if you don’t have access to one of your Apple devices because there is iWork for iCloud with which you can work on documents via browsers like Safari, Google’s Chrome, or Microsoft’s Internet Explorer.
    And it’s free for newly purchased devices.
  • A spreadsheet within Numbers
    which allows to predict the account balance
  • Access to your bank account
    to look up the transactions and the actual balance.

If you are not familiar with programming a spreadsheet don’t hesitate to download my template from my Box account. It’s free and there is no copyright on it. If you downloaded the template you can (easily) adapt it to your needs. The following description might help.

The spreadsheet …

The template contains two essential tables.
The first table is designed to enter the actual account balance, the performed transactions as well as periodical transactions. I call it the Dynamic table

The second table contains the dates for periodical transactions like rents or taxes to be paid in advance. I call it the Static Table.

Here is how it looks like:

20140314-185914.jpg

And here is the download link

Application File format
Apple Numbers numbers

Notes

If you tap on the link and downloaded the file you will see a control ‘Open in Numbers’ for a short time. If the message is gone just tap on the display again.

If you want to work with the template it’s highly recommended to do it with a copy of the original.

The dynamic table …

To predict the approximate liquidity at the end of a month you have to enter the actual account balance and monitor what’s expensed during the month by accessing the transactions with an online banking tool or a browser.

20140314-190023.jpg

The spreadsheet contains the necessary formulas to add or subtract incoming and outgoing money transfer. For cash payments (food, has, etc.) an approximate amount can be set on a weekly basis.

20140314-190850.jpg

Every time you get fresh cash from your bank you can reduce the remaining value with a so-called ‘Stepper’ control.
A Checkbox is used for payments on a monthly basis e.g. your health insurance. Just set it to true if the payment is expensed.

The static tables …

The first table is just for calculating a date 30 days prior to the actual date to point to an upcoming payment. The second table is for documentation purposes only and not used in any calculation.

The EOMONTH function returns a date 30 days prior to the actual date.

20140314-190209.jpg

This the conditional statement which sets the factor to -1 for all months (3, 6, 9, 12) with a due date. It can be easily adapted to other periods resp. months.

20140314-190303.jpg

This simple conditional statement sets a marker to emphasize upcoming payments.

20140314-190352.jpg

Summarized:

The kernel statement (image 2) sets the factor to -1 according to due dates.
Factor x Base Value defines the content in the column ‘Value’ which is part of the summarization to get the total liquidity.

The adaption …

You have to adapt the template by entering all the necessary values. A look on your last statements of account helps to find out the values. Some of them will be fixed values others vary and you have to define an average value.

You can use the COPY+PASTE feature to add more lines of similar type. In the context menu select ‘PASTE FORMULAS’ to let numbers adapt the clipboard content.

Summary …

If you run into the red it’s not my fault.
I’m sure the reason is your optimism bias or a shaking finger followed by wrong entries.

Related links …

An invoice created with numbers

If … Then … Else

Thanks for calculating with iNotes4You.