Applications :: Cannot Replace Home Budget Spreadsheet To Numbers
Oct 31, 2010I spend my working life in Excel 2007 and I just can't bring myself to replace my home budget spreadsheet to a true numbers format.
View 5 RepliesI spend my working life in Excel 2007 and I just can't bring myself to replace my home budget spreadsheet to a true numbers format.
View 5 RepliesWould anyone have one of these or be able to point me in the right direction for one? I don't mind having to pay for it.
View 3 Replies View RelatedI just recently got a MacBook - I'm new to the Mac world, but so far I love it and its worlds better then Windows 7 or anything else I've used. I'm picking up everything ok, except for a few little things. My biggest problem is in the "Numbers" spreadsheet program. I've searched the help topics and cant figure out how to make the numbers in my budget add up.
For example:
Paycheck- $500
Rent-$100
Food-$50
Car-$25
Total Expenses- $175
Difference between income and expenses: I cant get it to fill in the gap between the income and expenses so I know how much I have left over without having to do all the math myslef. Excel used to do this, is there a way to make Numbers do it too?
Just bought my first iMac, and I'm trying to find a simple free home budget program. I used SimpleD Budget for Windows, and am looking for something similar. Any help would be appreciated!
View 6 Replies View RelatedI've created a spreadsheet for budgeting purposes and to keep track of my money (student). I know that on certain days (like Payday) the amount I will be paid and obviously the date. I want to be able to put this in my table but not to be added to the formula until that date is passed or met.
For Instance, If I get paid on 01/09/10 and put this in my table, the formula will add this amount to the total income for the month of September. The funds have not actually been paid to me however, so they need to be excluded until they are paid i.e on the 01/09/10.
I am creating a new budget sheet, and am trying to automate it as much as possible. I get paid bi-weekly, and I like to budget on a per pay period case rather than month to month. What this means is that on certain budgets I have one set of bills due, on another I'll have a different set of bills due.
View 5 Replies View RelatedHave used AppleWorks 6 for years - used for spreadsheet application. Range of sheet: A80 thru AG 80. Printing on Canon MX850 requires 2 (two) pages to legibly cover contents. Was told by Apple Tech to use "Numbers" application as found in Snow Leopard for future tech support, as AppleWorks is no longer recognized by Apple. Same spreadsheet was copied from AppleWorks to "Numbers". When asked to print, 48 (forty-eight) pages would be required! Apple Tech was unable to solve problem, after a one-hour telephone call with Level 2 Support.
View 2 Replies View RelatedHow can I make negative numbers red on a spreadsheet while keeping positive numbers black?
Info:
MacBook (13-inch Aluminum Late 2008), Mac OS X (10.7.3)
I don't know if it's even possible to sync to iPhones with a single application, but I'm looking for a simple financial application that does this.
I want to be able to use two iPhones to record information about daily transactions and then sync that information with a 'mother' app on the mac, spreading and updating information between the iPhones.
I'd like to know what are the best Personal budget softwares out there?
Please advise and share your experience.
I'd also prefer free ones but if i have to pay for a good one, i will.
I'll do really basic stuff and i dont it to link to my bank account. I can type in most of the information.
I've been ripping my hair out trying to find the answer to this.
In Numbers for Mac, I need to fill a column automatically with a series of integers (1 - 50) and then the next column with a function that interacts with the first column.
For example:
Column A - 1 - 5
Column B - (value in Column A * 5)
I can't figure out how to do it in Numbers When I try to fill column a with 1 - 50 all it does is fill all 1's and I cant find an option how to make that change so it automatically numbers when I highlight them.
The best I can describe is how in Excel you can type 1 in the first cell, then highlight a bunch of cells and the little box appears that lets you click "Fill Series"
See above title. i get that there's the "degree(cell)" function, but there has to be an easier way to change the settings so you can just input in degrees rather than radians.
like how calculators have a degrees and radians mode, i find it so hard to believe that there isn't one in numbers. if there really isn't, this is an incredibly flawed program.
I need a spreadsheet program that can:
1. Operate cross platform (my IT guy�s PC, I�m Mac)
2. Sort capabilities to five, ideally six, levels
3. Capable of using macros
4. Can convert spreadsheets for an html (online) environment
I founded a national grassroots movement thats gone viral. We list registered supporters on our site, using Google Apps forms, the copy the content into an Excel spreadsheet. A friend out of state (PC user) is able to work magic with macros that magically sorts, fixes, and converts the lists to appear in our online directory (you can see an example at http://www.the350project.net/states/states_a-d.html). I created the graphics; he somehow builds the page using those plus the spreadsheets.
This is something I really need to be able to do on my end, as the owner of the site, but MS took macros out of the Mac version of Office Excel....OpenOffice only sorts three levels, and he says we need at least five....
Since I have no intention of becoming a PC user, I need to find a software program that will work on a Mac and still be able to do all this. I realize many (most?) software programs are capable of opening and saving .xls files, but the multi-level sort, macros, and html are critical to any of this working, according to him.
Im currently using an Excel spreadsheet, but my business is expanding so I need to use something more functional. I have tried Sage and Quickbooks but didnt really like them, not to mention the price was ridiculous.
View 9 Replies View RelatedI'm building a mac computer and i wonder to know what are the parts of building a mac computer on a tight budget.
View 2 Replies View Relatedhow to change india numbers to arabic numbers?
Info:
MacBook
Pro, Mac OS X (10.6.7)
I have been asked to do a project at work in Excel. I am keeping track of around 7,000 properties all over the United States. My boss wants to know a lot about each one. I am really struggling with the weather part!! I need to somehow pull the temp and if its snowing or raining from the internet into excel. I have all the addresses and zip codes for each property. I was thinking i could write a formula that looks at an RSS feed or website (like yahoo or Google weather) based on the zip code of the address. I could also write the formula that pulls the weather to excel then VLOOKUP the zip. Does anyone have any ideas about this?? I am not sure what to do!!
View 3 Replies View RelatedI have been asked to do a project at work in Excel. I am keeping track of around 7,000 properties all over the United States. My boss wants to know a lot about each one. I am really struggling with the weather part!! I need to somehow pull the temp and if its snowing or raining from the internet into excel. I have all the addresses and zip codes for each property. I was thinking i could write a formula that looks at an RSS feed or website (like yahoo or Google weather) based on the zip code of the address. I could also write the formula that pulls the weather to excel then VLOOKUP the zip. Does anyone have any ideas about this?? I am not sure what to do
View 1 Replies View RelatedI'm having trouble get percentages in numbers. I want to get 5% of one cell and display the answer in another. Whats the formula for this.
View 4 Replies View RelatedThe v_products_url_1 column is blank, but it contains information from the previous column. Is there any way to not have the previous cell overlap the empty one?
View 3 Replies View RelatedI just have a quick question about Numbers (iWork '09). I need to graph some supply and demand graphs for school. How would I go about doing this? Whenever I create a graph based on a chart, it just plots each row as it's own line. I can only edit the values in the Y-axis, and obviously I need to be able to work with the X-axis as well.
Update: I played around with it more and figured it out. I guess you have to graph it as a scatter plot and then choose to connect the dots, and remove the dots, rather than choose the line graph, whose icon looks just like a graph of supply and demand.
I'm a recent switcher from Excel to Numbers. For the life of me, I cannot find a way in Numbers to "freeze" headings so that as you scroll down or across the sheet they remain visible.
I'd be grateful for help; the matter is not covered in the video tutorials, nor in my little manual that came with iWorks, nor on the Help Menu.
I am using numbers for my accounts receivable. I have a formula which some dude created for me *years* ago that I used in Claris Works and it *seems* to work most of the time in Numbers. Anyway, the formula provides for either a debit or a credit and a balance. This is how it normally looks. However, for some weird reason the balance gets all screwed up whenever I enter cents into the equation. Check this out. I entered 5192 in the credit section and it changed the balance accordingly. However, when I add the 70 cents (.70) to the credit, the balance looks all messed up.
View 2 Replies View RelatedI'm trying to create a template for legal billing. The only thing I'm really having a problem with is the formula that multiplies time by hourly rate. The time spent cells are formatted to show it as 4h 5m ... and that totals perfectly with the SUM formula. When I multiply it with a rate cell formatted to currency the math is fine, but the format stays as 00h 00m ... even when I format that cell to currency.
I want to set up a cell that has a number in it. That number is to decrease by one every seven days is there a formula that I can use to do this automatically
View 2 Replies View RelatedIn Excel, you can easily rename a cell to whatever you want. i.e from A1 to yaxis How do you do this in Numbers? I can't find it.
View 1 Replies View RelatedI recently bought a Macbook Pro (and loving it) with iWork 09 pre-installed. I really like using numbers compared to office. However, I have just started working in a group where all the other members use Windows with Office 2007. I have been able to save my numbers (and pages) documents as the office equivalent. My problem lies when I am working on a document in numbers that is the office format. I like to continuously save my progress but whenever i press save, I have to save it as a whole new document or replace the existing one. When I used to work in office 2007 I used to just press save every now and then and it would save my changes. Am I doing something wrong or is it because I am working on an excel spreadsheet in numbers (word document in pages)?
View 3 Replies View RelatedA sheet of ply comes 1220mm wide and my staircase is 1200 wide. Therefore I get two out of one cut of ply. Used an 'if' function <1220 to divide by two as I get two out of one sheet if it's less than 1220.
Cell D11 calculates the amount of ply (as width measurement) needed by using an 'if' function, and E11 works it out as an actual sheet. The problem is it's showing 0.47 instead of rounding it to the nearest whole sheet (1), even if only 10mm is used I need to buy a whole sheet.
I just wanted to know how I could start the page numbers in header and footer on the third page of my document. The first page is the title page and the second page is the table of contents, and of course I wouldn't want the page numbers to be on those pages.
I have searched on the web and in help but couldn't find anything.
I am a newly converted Mac user and have some entrenched Excel habits, and try as I might, I couldn't locate this Excel formula in Numbers.
In Excel, I use "=C55 (or cell reference)" to copy that particular value from one worksheet to another.
I do this by clicking on the cell where I want the value to be copied to, type = and then switch to the other worksheet and click on the cell I want to copy. And voila, I am now back onto my 1st worksheet with the value showing. I do this because the value I want to copy to this cell changes regularly.