Software Africa Newsletter & Festive Greetings - December 2017

Image may contain: sky, outdoor and nature


These are the beautiful matriarchs and their babies in the Pilanesberg. They made our last day there a complete delight - right up close and relaxed. We saw so many animals with their young there, and returned relaxed. They were a very special three days away. Now that everyone is going on holiday - may your holidays be safe and work for you as ours did for us.  Travel carefully!  It is better to be a bit late, than "the late Mr/Ms X"!


Moving to Annual Subscription from Maintenance

We have clarification on the move from Maintenance subscriptions to Annual subscriptions. If you move on the promotions to Annual subscription, that subscription will stay at the same price for at least three years.  Whereas, the maintenance subscriptions will increase by 20% next February. Promotions and other special offers will continue for this year. I suspect they will continue through Financial 2019 as well.

In addition, do not think that buying Inventor Pro and AutoCAD, for example, will cost you less than buying a Design Collection. The wealth of software in the Design Collection  at around R36 000 inc VAT (at the current exchange rate) way undercuts buying any two standalone packages.

BIM Collaboration Software for Constructability Reviews

“BIM 360 Glue has allowed us to bring 3D modelling to members of the team who are a bit removed from the design process. You don’t need much training to navigate the 3D model like a pro.” --Chris Swartout, M Moser Associates

This software range gives amazing results for its users, powering up the process of designing and documenting. For more information go here: and study the site.

Online Business Tip #14 - Team Collaboration with Slack

If your company works in teams, particularly if they are not all in the same office, you might like the oddly-named program, "Slack". Slack gives you one place to contact your people, share information, and find useful tools.  It runs in an internet browser or freestanding app on your PC, laptop, tablet or Smartphone. When your distributed team needs to kick off a project, hire a new employee, deploy some code, review a sales contract, finalise next year's budget, measure an A/B test, plan your next office opening, and more, Slack can be invaluable.  Two NGOs in which Rick is active use Slack successfully in different ways.

For free, you can see 10K of your most recent messages, have 10 third-party or custom integrations, one-on-one voice and video calls (no conferencing) and 5 GB total file storage. The Standard plan --with more options-- charges US$6.67 per active user per month billed annually (or US$8 billed monthly). The Plus Plan is approximately double.

Other new QuickBooks Developments

Because your customer experience has to be of the highest standard, resellers are to be certified. We met the standards set in the exams - one of us for QuickBooks and one for Payroll. I ran out of the ability to write during Payroll!  This promises you, as our customer, a reliable and nurturing relationship.

Currently you can buy QuickBooks and Quick Payroll for a whopping 30% discount.

Quick Payroll

Please contact Judith for the new KeyPlayer software and assistance in getting your data file to QuickBooks for conversion.

Green Tip

Please encourage your local restaurant to discontinue using plastic straws. They are one of the biggest sources of plastic pollution worldwide.

The World is changing rapidly

All Autodesk products have similar links to training and resources. Here's the one for BIM Glue 360

Excel Tip #160 -- What's New in Excel 2016 for Windows? New Statistical Pareto Charts

We are looking at what is new in Excel 2016 for Windows Desktop, compared with Excel 2010.  As we saw in Excel Tip #158, on the Insert ribbon, in the Charts group, the new button for the new Statistical charts produces Histogram charts (and Box and Whisker type charts).

histogram chart shows the frequencies within a distribution.  There are two sub-types: Plain Histogram and Pareto chart: We now look at the second one.  As with the Plain Histogram , this will create a bar graph. Each bar shows a count of the number of values that fall within a range, called a "bin".

In the picture alongside, we have taken the Plain Histogram we produced last month and turned it into a Pareto Chart. The difference here is that (a) the bars ("bins") are sorted into descending order by size, and (b) a red line is added giving the cumulative percentage of the total at each position.  A second axis on the right gives the percentages on the red line.

The bars are therefore not in their natural order, but pull out what might be the most important ones by having the biggest on the left.

Next year we will look at the Box and Whisker Statistical chart.

Computius Say:

Phone addiction, you might have, if you wake at 3 a.m. to go to toilet, take your cell phone and check WhatsApp while you are there.

Remember:  We can make your business run better by:

All the Best from the team!
Judith and Rick

Members, Communication in Action cc trading as Software Africa
"Empowering African Business with standard and custom PC programs, databases, and templates using Microsoft technologies"
Reg. 2009/007863/23 ~ VAT No 4500104387 ~ 126 Kelvin Drive, Morningside Manor, Sandton, 2191 South Africa.
Tel: 011 802-2685 / 011 802-6440 ~ Fax: 086-635-7902/3 ~ Cell: 082 389-3481/2 ~ e-mail:

This entire newsletter is Copyright © 2017 Communication in Action cc t/a Software Africa. All rights reserved. Information may be reproduced in full context as long as credit is given.
Newsletter Index | < January 2015 | < January 2016 | < January 2017 | < February | < March | < April | < May | < June | < July | < August | < September | < October | < November |
Back to top | Updated 13 December 2017 | e-mail Webmaster.