Skip navigation

New budget template

5421 Views 16 Replies Latest reply: Nov 13, 2012 1:14 AM by ronenhaim RSS
1 2 Previous Next
ronenhaim Level 1 Level 1 (10 points)
Currently Being Moderated
Nov 6, 2012 10:32 AM

Hi

 

How can I create a "spreadsheet" with these items:

 

Monthly expenses ( like Gas, Electricity,Cables, health payments ..)

Monthly incomes (Like salary , Bank interest on deposits ...)

 

All these for every month ( Jan -Feb-Mar ... ) for 2011 AND 2012 AND 2013 

 

Any idea will be grateful

 

Thanks

iMac, OS X Mountain Lion, 10.8.2
  • Jerrold Green1 Level 7 Level 7 (28,215 points)
    Currently Being Moderated
    Nov 6, 2012 10:35 AM (in response to ronenhaim)

    Have you looked at the Budget Template in Numbers, and if so, how would you like to change it? We can help you if you know what you want it to look like.

     

    Jerry

  • Jerrold Green1 Level 7 Level 7 (28,215 points)
    Currently Being Moderated
    Nov 6, 2012 12:38 PM (in response to ronenhaim)

    All default templates are starting points. It is very unlikely that one of the included templates will suit you perfectly. It sounds to me as though you would like to triple the size of the included template to serve for three years at a time. Except for the problems with page layout, that's just a matter of scale. Could you describe what "big budget" view means to you?

     

    Jerry

  • Jerrold Green1 Level 7 Level 7 (28,215 points)
    Currently Being Moderated
    Nov 7, 2012 4:34 AM (in response to ronenhaim)

    Sorry, but the iWork apps no longer have a Trial mode. You may have to take a chance, or just use another app.

     

    Numbers is reasonably priced for what it does.

     

    Jerry

  • Jerrold Green1 Level 7 Level 7 (28,215 points)
    Currently Being Moderated
    Nov 7, 2012 8:46 AM (in response to ronenhaim)

    Ronen,

     

    Numbers is constructed as follows:

     

    Document: A single file containing one or more sheets. Documents have no provision for sharing data with other documents.

     

    Sheet: A Sheet is the canvas on which the contents are placed. Sheets may hold one or more Tables, Shapes, Text Boxes, and Graphics.

     

    Table: A Table in Numbers is a bounded array of cells which may be programmed to perform functions on data found in other cells, whether the other cells are in the same table or not, and without regard to what Sheet the referenced table is on. In the sense that there may be numerous tables per sheet, a Numbers Table is somewhat analogous to a Named Range in Excel. External references to cells must contain the External Table's name, and if that name isn't unique in the Document, the reference must also include the Sheet's Name.

     

    Sheets are just a way of organizing the content. Each may be displayed as a canvas without boundaries, or they may be organized in pages in a What You See Is What You Get format. When you Print, you may Print your entire document, or a particular sheet, or a particular page.

     

    Each Sheet may be individually formatted as either Landscape or Portrait, and all pages in a given Sheet must have the same orientation.

     

    Does that touch on any of your questions?

     

    Jerry

  • Jerrold Green1 Level 7 Level 7 (28,215 points)
    Currently Being Moderated
    Nov 7, 2012 10:50 AM (in response to ronenhaim)

    Romen,

     

    Numbers can handle your design with no difficulty that I can imagine.

     

    Jerry

  • Jerrold Green1 Level 7 Level 7 (28,215 points)
    Currently Being Moderated
    Nov 7, 2012 1:03 PM (in response to ronenhaim)

    I hopw that you are happy with Numbers. It is a nice departure from traditional spreadsheet programs. It isn't as powerful as others, but has some very nice features if your needs are modest.

     

    Jerry

  • Barry Level 7 Level 7 (29,095 points)
    Currently Being Moderated
    Nov 10, 2012 11:50 PM (in response to ronenhaim)

    No. You can freeze the header rows of a table and scroll the rest of the table under those rows, but you cannot similarly hide the bottom rows of the table.

     

    Regards,

    Barry

1 2 Previous Next

Actions

More Like This

  • Retrieving data ...

Bookmarked By (0)

Legend

  • This solved my question - 10 points
  • This helped me - 5 points
This site contains user submitted content, comments and opinions and is for informational purposes only. Apple disclaims any and all liability for the acts, omissions and conduct of any third parties in connection with or related to your use of the site. All postings and use of the content on this site are subject to the Apple Support Communities Terms of Use.