1 2 Previous Next 16 Replies Latest reply: Nov 13, 2012 1:14 AM by ronenhaim
ronenhaim Level 1 Level 1 (10 points)

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
  • 1. Re: New budget template
    Jerrold Green1 Level 7 Level 7 (28,990 points)

    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

  • 2. Re: New budget template
    ronenhaim Level 1 Level 1 (10 points)

    Thanks for your fast reply !

     

    I didn't look carefully because I didn't find  big budget template view .

     

    I amlooking for a solution for my expenses and incomes ...

  • 3. Re: New budget template
    Jerrold Green1 Level 7 Level 7 (28,990 points)

    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

  • 4. Re: New budget template
    ronenhaim Level 1 Level 1 (10 points)

    Thank you.

     

    Sorry for explaining myself hardly ...

     

    "big budget view " meaning  :

     

    I want to see how looks like the budget template in Numbers in a full screen  , I can't see this template in my full screen so I don't see any details / figures .

     

    To see it in a full screen mode I will have to buy the App !!! But I need to see it before buying .

     

    Is it possible to see somehow ?

     

    Thanks

  • 5. Re: New budget template
    Jerrold Green1 Level 7 Level 7 (28,990 points)

    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

  • 6. Re: New budget template
    ronenhaim Level 1 Level 1 (10 points)

    Additional important question please :

     

    in Numbers , Is it possible to build a MAIN SHEET ( Lets called it Home ) that's include Tables , Charts ect'

     

    These Tables , Charts ect' will be in another Different Sheets .

     

    Meaning : ( From the opposite "view" ) :

     

    I want to have some Sheets with Tables and Charts in several Sheet ,

    In every Sheet will be a Main Table / Main Chart , these Main Tables and Charts will be visible in the  MAIN SHEET ( Called Home )

     

    Any advice will be grateful.

     

    Ronen

  • 7. Re: New budget template
    Jerrold Green1 Level 7 Level 7 (28,990 points)

    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

  • 8. Re: New budget template
    ronenhaim Level 1 Level 1 (10 points)

    Thank you.


    I will have to read your reply a few times to fully understand.

     

    Please see my Pic att' .

     

    As you can see, at the bottom I have 4 Sheets,

     

    In every Sheet there is 3 tables , The Left table in every sheet  is the total of the other  two.

     

    The Main SHEET - HOME, in the Pic' head  Includes 3 Tables , The tables contains the Total of the left table of Sheets 1-4

     

    1.Sorry for the bad Pic..

    exampel.gif

    2. Is my explanation OK ?

     

    Thanks again,

     

    Ronen

  • 9. Re: New budget template
    Jerrold Green1 Level 7 Level 7 (28,990 points)

    Romen,

     

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

     

    Jerry

  • 10. Re: New budget template
    ronenhaim Level 1 Level 1 (10 points)

    Dear Jerry.

    Thank you so much for your help , Very appreciated !

    Now I will buy the App and think how to design my Sheets.

    Ronen

  • 11. Re: New budget template
    Jerrold Green1 Level 7 Level 7 (28,990 points)

    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

  • 12. Re: New budget template
    ronenhaim Level 1 Level 1 (10 points)

    Thanks.

     

    Is it possible to make / Change a Table to a  Rolling Table ?

     

    Meaning :

     

    The table will appear in the Sheet in a fix size , but the details inside will be visible when

    rolling the table ...

     

    Thanks

  • 13. Re: New budget template
    Barry Level 7 Level 7 (29,180 points)

    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

  • 14. Re: New budget template
    ronenhaim Level 1 Level 1 (10 points)

    Thank you !

     

    Is it possible to change the Graph colors ?Screen Shot 2012-11-11 at 6.06.07 PM.png

     

    Thank you.

    Ronen

1 2 Previous Next