Re: Numbers 4.0.5

[Peter Hinchliffe]

> On 15 Feb 2017, at 7:01 pm, Alan Fenton  wrote:
> 
> Hello.
> I use Numbers ’09. My mum uses current Numbers to run her super fund and 
> share trading.
> We are frustrated with  current Numbers. I wish  to change mum’s back to 
> Numbers ’09.
> I can copy my Numbers ’09 to mum’s iMac ( about 2 months old) by Air Drop. 
> Will that do or do I need Numbers ’09 with Installer?
> 
> From Alan. 
> 
> 

The short answer is that she will need the installer. Be aware that all of her 
current Numbers documents will need to be exported to Number ’09 format first, 
and you’ll need to hold on to the current version in order to do that.It will 
also be important to uninstall the current version, otherwise it will remain as 
the default for opening numbers files.

I must add that I do agree that the current Numbers is not as easy to use as 
Numbers ’09, and is still missing some important features such as Categories 
and Summaries, and the ability to adjust your tables in Print Preview mode. 
Neither is as frustrating as Excel though...   


Peter HinchliffeApwin Computer Services
FileMaker Pro Solutions Developer
Perth, Western Australia
Phone (618) 9332 6482Mob 0403 046 948

Mac because I prefer it -- Windows because I have to.

-- The WA Macintosh User Group Mailing List --
Archives - 
Guidelines - 
Settings & Unsubscribe - 

Re: numbers

[Peter Hinchliffe]

On 19/11/2009, at 8:50 AM, Martin Sulkowski wrote:

 
 Hi Everyone 
 
 I'm using numbers at the moment and would like to know if it is possible to 
 do the same thing in Excel or export it to excel and have the same formulas.
 I use numbers for cuttinglists in cabinetmaking.
 On one sheet I have different tables...one for length ,,,one for 
 heightone for depth ...in total 5 tables on one page
 From these 5 tables the cuttinglists are created for all the cabinets.
 
 I tried to do a copy in excel but it looks so  different.
 The question is 1.: Does excel allow multiple tables on one page

Excel doesn't support tables at all, and the page concept in Excel is very 
basic. This is one of Numbers' main strengths.

 2. : Can i have another sheet with reference to the first sheet with all the 
 calculations?
 

Most definitely, and the implementation (tracing references, etc) is much 
clearer in Numbers in Excel, IMHO. 


--

Peter HinchliffeApwin Computer Services
FileMaker Pro Solutions Developer
Perth, Western Australia   
Phone (618) 9332 6482Mob 0403 064 948

Mac because I prefer it -- Windows because I have to.







-- The WA Macintosh User Group Mailing List --
Archives - http://www.wamug.org.au/mailinglist/archives.shtml
Guidelines - http://www.wamug.org.au/mailinglist/guidelines.shtml
Unsubscribe - mailto:wamug-unsubscr...@wamug.org.au

Re: numbers

[Rob Phillips]

Peter Hinchliffe wrote:

  
On 19/11/2009, at 8:50 AM, Martin Sulkowski wrote:

  
  
Hi Everyone 

I'm using numbers at the moment and would like to know if it is possible to do the same thing in Excel or export it to excel and have the same formulas.
I use numbers for cuttinglists in cabinetmaking.
On one sheet I have different tables...one for length ,,,one for heightone for depth ...in total 5 tables on one page
>From these 5 tables the cuttinglists are created for all the cabinets.

I tried to do a copy in excel but it looks so  different.
The question is 1.: Does excel allow multiple tables on one page

  
  
Excel doesn't support tables at all, and the "page" concept in Excel is very basic. This is one of Numbers' main strengths.
  

But a table is just a contiguous, two-dimensional collection of cells,
and you can have multiples of these on the same worksheet, or on
separate worksheets, and these can all be linked together. Feel free
to send me a copy of your file, and I'll play with it if you like.

Rob

  
  
  
2. : Can i have another sheet with reference to the first sheet with all the calculations?


  
  
Most definitely, and the implementation (tracing references, etc) is much clearer in Numbers in Excel, IMHO. 


--

Peter HinchliffeApwin Computer Services
FileMaker Pro Solutions Developer
Perth, Western Australia   
Phone (618) 9332 6482Mob 0403 064 948

Mac because I prefer it -- Windows because I have to.







-- The WA Macintosh User Group Mailing List --
Archives - http://www.wamug.org.au/mailinglist/archives.shtml
Guidelines - http://www.wamug.org.au/mailinglist/guidelines.shtml
Unsubscribe - mailto:wamug-unsubscr...@wamug.org.au


  


-- 
Associate Professor Rob Phillips
Educational Development Unit
Room 4.42 Level 4 Library North Wing, Murdoch University
r.phill...@murdoch.edu.au Phone: +61 8 9360 6054 Mobile: 0416 065 054
Fellow, Higher Education Research and Development Society of
Australasia
Currently on sabbatical leave




--TheWAMacintoshUserGroupMailingList--
Archives-http://www.wamug.org.au/mailinglist/archives.shtml
Guidelines-http://www.wamug.org.au/mailinglist/guidelines.shtml
Unsubscribe-mailto:wamug-unsubscr...@wamug.org.au

Re: numbers

[Neil Houghton]

Hi Martin,

Excel is hugely powerful and can do all that and more - I've been using it
for many years and still there are a huge amount of features, formulas etc
that I haven't even touched on. Typically that's why some people find it
harder to use - it's one thing to know Excel can do it but sometimes it's
less than obvious how!

With more specific reference to your questions:

1) Yes, of course, you can have as many tables as you like on a page. A page
in Excel is just a matrix of rows and columns - put a border around a
selection of cells and you have a table - put a border around another
selection of cells and you have a second table - you fill the relevant cells
with data (text, numbers, dates etc) and create formulas in other cells to
work with the data.

2) Yes Excel will cross-reference (link) between cells across multiple
sheets and across multiple files (workbooks) - in fact you can combine all
of these in a formula - ie a cell could contain a formula which referenced:

- a cell in the same table
- a cell in a different table on the same page
  (it's not another table to Excel, it's just a cell in a different
location)
- cells from different worksheets in the same workbook
- cells from different worksheets in a different workbook

In other words, it can reference cells from any combination of
tables/worksheets/workbooks.


I use this linking all the time - for example I create a Tax Workbook every
year with separate worksheet for different areas eg one for share dividends,
another for share capital gains, another for depreciation, another for
deductions and so on (several more!) then I have a summary worksheet which
basically just has the top level info needed for my tax return and which
pulls all this info from the various detailed worksheets.

So each tax year is covered by a single workbook containing multiple
worksheets - but there is also info which needs to flow from year to year -
for example on the depreciation worksheet, the closing value of one year
carries over to become the opening value of the subsequent year - so this
becomes a link between different workbooks.

I looked at numbers a while back and although it can open Excel files and
save in the Excel format I found that the conversion was far from
transparent - eg If I opened one of my Excel files in numbers, saved it as a
numbers file, re-opened it in numbers and saved it as an Excel file then
re-opened this file in Excel it looked very different from my original file!

So, yes, Excel will do what you want it to do but, given that your cutting
lists are very simple (in terms of spreadsheet functions) and you have it
all organised in numbers (which, as you say, is very intuitive) and given
that you tried Excel a year ago and didn't enjoy it much - then why do you
WANT to do it in Excel?

I mean, I'm very happy staying with Excel because:
- I have years of experience working with it
- I have much time invested in many existing spreadsheets
- I have to exchange spreadsheets with people (eg the accountants) who use
Excel.

However for anyone coming new to spreadsheets the only reasons I can think
of to pick Excel over numbers would be:
- you need to share spreadsheets frequently with Excel users
- you need a more powerful set of tools including some not yet covered by
numbers.

HTH


Cheers


Neil
-- 
Neil R. Houghton
Albany, Western Australia
Tel: +61 8 9841 6063
Email: n...@possumology.com



on 19/11/09 8:50 AM, Martin Sulkowski at msulkow...@reachnet.com.au wrote:

 
 Hi Everyone 
 
 I'm using numbers at the moment and would like to know if it is possible to do
 the same thing in Excel or export it to excel and have the same formulas.
 I use numbers for cuttinglists in cabinetmaking.
 On one sheet I have different tables...one for length ,,,one for heightone
 for depth ...in total 5 tables on one page
 From these 5 tables the cuttinglists are created for all the cabinets.
 
 I tried to do a copy in excel but it looks so  different.
 The question is 1.: Does excel allow multiple tables on one page
 2. : Can i have another sheet with reference to the first sheet with all the
 calculations?
 
 Thanks for all the answers Martin
 
 PS: Typical Apple numbers is so easy to learn and intuitive
Tried Excel a year ago , but did not enjoy it very much
 
 
 
 
 -- The WA Macintosh User Group Mailing List --
 Archives - http://www.wamug.org.au/mailinglist/archives.shtml
 Guidelines - http://www.wamug.org.au/mailinglist/guidelines.shtml
 Unsubscribe - mailto:wamug-unsubscr...@wamug.org.au
 





-- The WA Macintosh User Group Mailing List --
Archives - http://www.wamug.org.au/mailinglist/archives.shtml
Guidelines - http://www.wamug.org.au/mailinglist/guidelines.shtml
Unsubscribe - mailto:wamug-unsubscr...@wamug.org.au

Re: numbers

[Bob Jackson]

At 10:22 AM 19/11/09, Neil Houghton  eloquently proclaimed...


I use this linking all the time - for example I create a Tax Workbook every
year with separate worksheet for different areas eg one for share dividends,
another for share capital gains, another for depreciation, another for
deductions and so on (several more!) then I have a summary worksheet which
basically just has the top level info needed for my tax return and which
pulls all this info from the various detailed worksheets.

So each tax year is covered by a single workbook containing multiple
worksheets - but there is also info which needs to flow from year to year -
for example on the depreciation worksheet, the closing value of one year
carries over to become the opening value of the subsequent year - so this
becomes a link between different workbooks.


Great minds think alike as I do exactly the same! I also use a macro 
to calculate the tax payable (that's why I still use Office 2004 as 
Office 2008 does not have VBA).


Bob


-- The WA Macintosh User Group Mailing List --
Archives - http://www.wamug.org.au/mailinglist/archives.shtml
Guidelines - http://www.wamug.org.au/mailinglist/guidelines.shtml
Unsubscribe - mailto:wamug-unsubscr...@wamug.org.au

Re: numbers

[Martin Sulkowski]

Hi Neil

Yes it is about sharing in the long term with other cabinetmakers who do 
sometimes work for me. 
But I can still scan and e-mail if necessary.
It was good to hear that ex/import excel-numbers is complicated,,,so I do not 
need to invest any time in this.

Thanks for all the helpful answers
On 19/11/2009, at 10:22 AM, Neil Houghton wrote:

 
 Hi Martin,
 
 Excel is hugely powerful and can do all that and more - I've been using it
 for many years and still there are a huge amount of features, formulas etc
 that I haven't even touched on. Typically that's why some people find it
 harder to use - it's one thing to know Excel can do it but sometimes it's
 less than obvious how!
 
 With more specific reference to your questions:
 
 1) Yes, of course, you can have as many tables as you like on a page. A page
 in Excel is just a matrix of rows and columns - put a border around a
 selection of cells and you have a table - put a border around another
 selection of cells and you have a second table - you fill the relevant cells
 with data (text, numbers, dates etc) and create formulas in other cells to
 work with the data.
 
 2) Yes Excel will cross-reference (link) between cells across multiple
 sheets and across multiple files (workbooks) - in fact you can combine all
 of these in a formula - ie a cell could contain a formula which referenced:
 
 - a cell in the same table
 - a cell in a different table on the same page
  (it's not another table to Excel, it's just a cell in a different
 location)
 - cells from different worksheets in the same workbook
 - cells from different worksheets in a different workbook
 
 In other words, it can reference cells from any combination of
 tables/worksheets/workbooks.
 
 
 I use this linking all the time - for example I create a Tax Workbook every
 year with separate worksheet for different areas eg one for share dividends,
 another for share capital gains, another for depreciation, another for
 deductions and so on (several more!) then I have a summary worksheet which
 basically just has the top level info needed for my tax return and which
 pulls all this info from the various detailed worksheets.
 
 So each tax year is covered by a single workbook containing multiple
 worksheets - but there is also info which needs to flow from year to year -
 for example on the depreciation worksheet, the closing value of one year
 carries over to become the opening value of the subsequent year - so this
 becomes a link between different workbooks.
 
 I looked at numbers a while back and although it can open Excel files and
 save in the Excel format I found that the conversion was far from
 transparent - eg If I opened one of my Excel files in numbers, saved it as a
 numbers file, re-opened it in numbers and saved it as an Excel file then
 re-opened this file in Excel it looked very different from my original file!
 
 So, yes, Excel will do what you want it to do but, given that your cutting
 lists are very simple (in terms of spreadsheet functions) and you have it
 all organised in numbers (which, as you say, is very intuitive) and given
 that you tried Excel a year ago and didn't enjoy it much - then why do you
 WANT to do it in Excel?
 
 I mean, I'm very happy staying with Excel because:
 - I have years of experience working with it
 - I have much time invested in many existing spreadsheets
 - I have to exchange spreadsheets with people (eg the accountants) who use
 Excel.
 
 However for anyone coming new to spreadsheets the only reasons I can think
 of to pick Excel over numbers would be:
 - you need to share spreadsheets frequently with Excel users
 - you need a more powerful set of tools including some not yet covered by
 numbers.
 
 HTH
 
 
 Cheers
 
 
 Neil
 -- 
 Neil R. Houghton
 Albany, Western Australia
 Tel: +61 8 9841 6063
 Email: n...@possumology.com
 
 
 
 on 19/11/09 8:50 AM, Martin Sulkowski at msulkow...@reachnet.com.au wrote:
 
 
 Hi Everyone 
 
 I'm using numbers at the moment and would like to know if it is possible to 
 do
 the same thing in Excel or export it to excel and have the same formulas.
 I use numbers for cuttinglists in cabinetmaking.
 On one sheet I have different tables...one for length ,,,one for 
 heightone
 for depth ...in total 5 tables on one page
 From these 5 tables the cuttinglists are created for all the cabinets.
 
 I tried to do a copy in excel but it looks so  different.
 The question is 1.: Does excel allow multiple tables on one page
 2. : Can i have another sheet with reference to the first sheet with all the
 calculations?
 
 Thanks for all the answers Martin
 
 PS: Typical Apple numbers is so easy to learn and intuitive
   Tried Excel a year ago , but did not enjoy it very much
 
 
 
 
 -- The WA Macintosh User Group Mailing List --
 Archives - http://www.wamug.org.au/mailinglist/archives.shtml
 Guidelines - http://www.wamug.org.au/mailinglist/guidelines.shtml
 Unsubscribe - mailto:wamug-unsubscr...@wamug.org.au
 
 
 
 
 

Re: numbers

[Neil Houghton]

Hi Martin,

 It was good to hear that ex/import excel-numbers is complicated,,,so I do not
 need to invest any time in this.
It's not that it is complicated, the export/import is all simple - it's just
that if (like me) you have complex and carefully formatted spreadsheets they
don't go through the export/import cycles without at least the formatting
getting messed up.

If your spreadsheets are fairly simple, with basic formatting, you may find
it all works fine.

However, if you are just wanting to send them static info, rather than an
interactive spreadsheet, then I find using the print to pdf is the simplest
way (rather than scanning) - then send the pdf by email and everyone (mac or
windows) sees the same thing.


Cheers


Neil
-- 
Neil R. Houghton
Albany, Western Australia
Tel: +61 8 9841 6063
Email: n...@possumology.com


on 19/11/09 1:06 PM, Martin Sulkowski at msulkow...@reachnet.com.au wrote:

 
 Hi Neil
 
 Yes it is about sharing in the long term with other cabinetmakers who do
 sometimes work for me.
 But I can still scan and e-mail if necessary.
 It was good to hear that ex/import excel-numbers is complicated,,,so I do not
 need to invest any time in this.
 
 Thanks for all the helpful answers
 On 19/11/2009, at 10:22 AM, Neil Houghton wrote:
 
 
 Hi Martin,
 
 Excel is hugely powerful and can do all that and more - I've been using it
 for many years and still there are a huge amount of features, formulas etc
 that I haven't even touched on. Typically that's why some people find it
 harder to use - it's one thing to know Excel can do it but sometimes it's
 less than obvious how!
 
 With more specific reference to your questions:
 
 1) Yes, of course, you can have as many tables as you like on a page. A page
 in Excel is just a matrix of rows and columns - put a border around a
 selection of cells and you have a table - put a border around another
 selection of cells and you have a second table - you fill the relevant cells
 with data (text, numbers, dates etc) and create formulas in other cells to
 work with the data.
 
 2) Yes Excel will cross-reference (link) between cells across multiple
 sheets and across multiple files (workbooks) - in fact you can combine all
 of these in a formula - ie a cell could contain a formula which referenced:
 
 - a cell in the same table
 - a cell in a different table on the same page
  (it's not another table to Excel, it's just a cell in a different
 location)
 - cells from different worksheets in the same workbook
 - cells from different worksheets in a different workbook
 
 In other words, it can reference cells from any combination of
 tables/worksheets/workbooks.
 
 
 I use this linking all the time - for example I create a Tax Workbook every
 year with separate worksheet for different areas eg one for share dividends,
 another for share capital gains, another for depreciation, another for
 deductions and so on (several more!) then I have a summary worksheet which
 basically just has the top level info needed for my tax return and which
 pulls all this info from the various detailed worksheets.
 
 So each tax year is covered by a single workbook containing multiple
 worksheets - but there is also info which needs to flow from year to year -
 for example on the depreciation worksheet, the closing value of one year
 carries over to become the opening value of the subsequent year - so this
 becomes a link between different workbooks.
 
 I looked at numbers a while back and although it can open Excel files and
 save in the Excel format I found that the conversion was far from
 transparent - eg If I opened one of my Excel files in numbers, saved it as a
 numbers file, re-opened it in numbers and saved it as an Excel file then
 re-opened this file in Excel it looked very different from my original file!
 
 So, yes, Excel will do what you want it to do but, given that your cutting
 lists are very simple (in terms of spreadsheet functions) and you have it
 all organised in numbers (which, as you say, is very intuitive) and given
 that you tried Excel a year ago and didn't enjoy it much - then why do you
 WANT to do it in Excel?
 
 I mean, I'm very happy staying with Excel because:
 - I have years of experience working with it
 - I have much time invested in many existing spreadsheets
 - I have to exchange spreadsheets with people (eg the accountants) who use
 Excel.
 
 However for anyone coming new to spreadsheets the only reasons I can think
 of to pick Excel over numbers would be:
 - you need to share spreadsheets frequently with Excel users
 - you need a more powerful set of tools including some not yet covered by
 numbers.
 
 HTH
 
 
 Cheers
 
 
 Neil
 -- 
 Neil R. Houghton
 Albany, Western Australia
 Tel: +61 8 9841 6063
 Email: n...@possumology.com
 
 
 
 on 19/11/09 8:50 AM, Martin Sulkowski at msulkow...@reachnet.com.au wrote:
 
 
 Hi Everyone 
 
 I'm using numbers at the moment and would like to know if it is possible to
 do
 the same thing in Excel or