Newsletter - September 2013

Editorial

For the first time in many months, we have a full staff complement.  Gram Letoaba joined us as a intern programmer at the beginning of the month.  It is good to have a team in place again.  We are also concentrating on staff development generally with one goal in place already.  Judith took the certified Adobe reseller examinations and has qualified.  Thembekile is now going the same route.  Willy is doing his Autodesk exams and has passed two with 100%.  Rick has passed his first one also with 100%.

Our goal here is to become Silver resellers to compliment the hair colour of the oldest members of the team!

All this must be happening because it's Spring at last and the office is full of the perfumes of the Spring flowers.

Adobe Creative Cloud

Tired of difficulties collaborating with colleagues and customers?  This could be the solution and it also cuts out your administration costs.  In addition, Adobe is constantly updating the features in the Cloud offering.  Here's a Photoshop update:

And look at this one for Dreamweaver:

For enquiries and more information, please contact judith@softwareafrica.co.za to find out about the Team options in Creative Cloud that take professionalism and productivity to new heights.

dotPLOT and HotPlot

dot7014 was released with HotPlot 3.14.0 on 1 August. Two new symbols were added in the form of a warning triangle and an asterisk, invoked in the Notes Block by keywords CAUTION and WARNING. We found cases where users did not have rights to create files on the output path, and this crashed dotPLOT: Winston has now catered for this.  dot7012 and dot7013 draw the details first and the logo last, so large logos were overwriting parts of the page. This sequence has now been reversed, allowing big logos and even whole-page watermarks.  Free upgrades for existing dot7000 users are available at this link.

Green Tip

Pick 'n Pay supermarkets have bins for you to drop off recyclables like torch batteries and fluorescent light bulbs.  This guarantees that they do not go into landfill.

Autodesk Specials

All new seats are discounted from now until 18th October 2013:

AutoCAD Verticals and Standalone products are discounted by 10%

The Design Suites are discounted as follows:

With two exceptions - Factory and Product Design Suites are only discounted at the Ultimate level.

AutoCAD LT excluding the Mac version is now R10,828.86 inc VAT but excluding subscription.

Please contact Judith or Willy for quotes.

Autodesk Subscription Benefits

These give real value to your Autodesk product users.  They include the following:

For more information go to https://360.autodesk.com/landing and http://www.autodesk.com/subscription/overview

PC Tip: Change the Program that Opens a Type of File

For some freak reason all my Excel files were opening in Works (a dumbed-down version of Excel). I have no idea why this changed and can only suspect that it was a Windows update. Regardless, this is how to fix it...  To change the program that opens a type of file:

  1. Right-click the file that you want to change, and then click "Open With" and "Choose Default Program."
  2. Click the program that you want to use to open this file. From here on, the file will open with the correct program.

With thanks to Andy Lanning, Chief Nerd at Computer Super Secrets (Subscribe at www.ComputerSuperSecrets.com)..

Excel Tip #116 - The Data tab (VII): Data Tools - What-If - Scenario Manager

We continue looking at the "Data" tab on Excel 2010's Ribbon, in the "Data Tools" group.  After "Consolidate", which we looked at in the last Tip, comes "What-If Analysis".  This button has a submenu consisting of three items: Scenario Manager, Goal Seek, and Data Table.  We will look at Scenario Manager today.

Scenario Manager is a tool that automates what-if analysis.  It creates and saves different sets of data for the same cells, as separate scenarios. Each set of changing cells in a worksheet represents a set of what-if assumptions that you can apply to a workbook model to see the effects on other parts of the model. One uses the Scenario Manager to:

On our "Microsoft Excel 2010 for Engineers and Scientists" course we spend four pages on Scenario Manager, so this is going to be a brief summary!  To create a Scenario, do the following:

  1. Set up a spreadsheet containing formulas that depend on certain cells.  You might, for example, want to experiment with different growth rates.
  2. Select these variable cells.
  3. Go to the Data Ribbon (Data Tools group) > What-If Analysis and select the Scenario Manager.
  4. To add a scenario, click the Add button.
  5. The Add Scenario dialog box appears: Type the description of the scenario.  Click OK.
  6. Enter values for the changing cells.  Click OK.
  7. Repeat from step 4 for as many scenarios as are required.
  8. To show a particular scenario (and recalculate the results for it), click the Scenario name and the Show button.
  9. To produce a permanent record comparing the results, click the Summary button, select the cells containing the results, and click OK.

The next item in the Data Tools ribbon, under What-If Analysis, is Goal Seek, which we will look at in the next issue.

Computius Say:

Newspapers are disappearing.  How long before people use Kindle to light the fire?  (Probably they will call it "kindling").

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 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/1 ~ Fax: 011 802-4576 and 086-635-7902/3 ~ Cell: 082 389-3481/2 ~ e-mail: info@softwareafrica.co.za

This entire newsletter is Copyright 2013 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 | < 2011 October December | 2012 January |
June | July | August | September | October | November | December | January 2013 | February | < March | < April | < May | < June | < July | < August 2013 | October 2013 > Back to top | Updated 25 October 2013 | e-mail Webmaster.