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 RepliesI 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?
I 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 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 RelatedI 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.
I am studying, there is a weekly timetable made of 20 individual classes, each on 4 times a week. I would like to know how to make a spreadsheet so I can manually input all these classes and have it return a non conflicting pattern. By that I mean that I want a personal timetable that will let me visit each class at least once a week.
View 1 Replies View RelatedI have recently run a 13 page excel spread sheet for a budget on Windows and on transferring it to Numbers on my new mac, one of the formulas is not compatable. this is what I do. There is a balance figure on each of pages 2 to 13 which are then required to be transferred as a total figure in one of the columns on page 1.
This was the formula on windows: =SUM(xmas:Savings!F2)
I'm an independent contractor and keep track of my hours worked & amount paid for the year in numbers, and thus far its working Great! However, I'm attempting to figure out how much my "pay per hour, per day" is, and need am wondering if there is an easier way to do this.
My spreadsheet is setup like the following:
Rows = Days worked
Column F = Time worked
Column G = Amount paid.
So to figure out how much I made "per hour per day", I simply take Column G divided by Column F for each day. However, I'm currently manually entering this script into each row, and given that I worked over 200 days last year(i.e. I manually enter in row 1 =SUM(G1)/(F1); row 2 =SUM(G2)/(F2), etc.
Is there an easier way to do this? Is there a way to sequentially apply scripts, so instead of manually entering G2/F2, it will automatically apply the =Sum G / F's of that row? I'm on numbers 08
I have a list of expenses and there are columns such as "Description, Cost" the usual, but I also made one named "Type" that is populated with either "Business, Personal," or "Fixed Expenditures".
I would like, then, to make another table that links to the first with three rows. Each one adds the total cost of Business, Personal, and Fixed Expenditures. How can I accomplish this?
I want to divide the expenses into expenses types and create a sum for each type.
Basically, it categorizes the expenses and puts them in three different totals: one for each "Type" of expense.
I'm new to iworks and have trying to figure this one out for a while. I used a template to set up financial info and calculate how much was spent on items. This was the preset formula: =SUMIF(Transactions :: $Category,A2,Transactions :: Amount)
However, I only want the sum from a particular range of dates (e.g. 9/1/09 to 9/30/09, as in cells B2:B10) so I can budget accordingly. In excel, you just grab the highlighted corner and drag it to where you want- here I can't do that and it won't let me add any more "conditions". Any idea how to remedy this? It's driving me nuts. On a side note, I am NOT a programmer so programming language will unfortunately not help unless you get VERY specific about how to do it (which you probably don't want to do).
I have a "My book Pro" 250 GB external hard drive spinning at 7200 rpm. This thing is dog slow. It takes about 5 to 10 seconds to copy about 2 megabytes. I have another drive that copies about 160 megabytes in about 5 seconds. I called Western Digital (the maker of the "My Book Pro") and they said that USB 2.0 transfer rates are about 2 MB a second! That is not true but he insisted. My question to you all is how can i win this argument with them? Do you know a formula that would give me real world numbers. In other words how to translate 480 megabits (the USB 2.0 transfer spec) into megabytes? Ive searched the net and cant find anything. Its messed up cause both drives have basically the same specs. Ive even tried reformatting to every possibility, ive switched cables from the fast drive to the slow drive. Nothings working. Im gonna call WD back tomorrow but i wanted a way to talk about what could honestly be expected from USB 2.0. I just cant believe that USB 2.0 tops out at 2MB a second. And to top it all off, todays call ended up with me getting disconnected so i called back and guess what, they were closed...that guys a DOUCHE. I really cant put my faith into Western Digital after this. Are there drives that are geared more towards professionals seeking performance and reliability?
View 5 Replies View RelatedI 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'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 RelatedI'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.
how to change india numbers to arabic numbers?
Info:
MacBook
Pro, Mac OS X (10.6.7)
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 RelatedMy aunt spilled wine on her ibook G4 and the period key won't work and hasn't for ages Is there a way to assign a different key as the period? This copy and paste crap is really getting annoying She's running OS 10 3 9
View 4 Replies View RelatedLately I'm starting to notice that if I leave my Macbook just sitting there for awhile, when I return to it, it didn't go to sleep, but it rather logged me out, leaving me at the login screen. I then have to re log in and re-open everything I was working on.
View 2 Replies View RelatedThe screen turns red striped and you can still see the desktop in the background and it freezes up. I think it may be due to over heating because after forcing it to shut down it will restart after a short period. But if you try to restart it quickly it will beep at you. The laptop is about four years old but is used quite a bit. I try to keep it from being too beat up in transport but mostly it just sits on my desk. One thing that has changed is that I have been shutting it down every night before bed where I used to leave it running near constantly. The problems have only started after the new routine.Â
Info:
MacBook
I use Firewire 800, and my external has 80GB free on it. Both it and my iMac's drives are 320GB. What's with the extended period of preparation, going on 15 minutes now, maybe longer. Backup still didn't begin, this never used to happen me before. I only backed up 2 days ago?
Also, why when I click the Time Machine menubar item to open Time Machine prefs does the DVD (iLife '09) in my optical drive make a noise as if it's being accessed? It spins up a little too. Seems very odd, and it's not a coincidence, it happens exactly when I try to open Time Machine prefs from its menubar item. I could do it 5 times in succession and the optical drive would make the same accessing noise each time, on cue
I got mine yesterday, and am calibrating the battery. When you run it down to sleep, and recharge, can you use it during the full recharge period?
View 1 Replies View RelatedHey everyone, so I keep seeing posts about how much SSDs degrade over the first week/two after using an SSD (one that comes WITH the MBP). However, how much do they degrade after...say....6 months-1 year (or even longer)? I know they are still new hardware, but I'm sure some people have an idea. Is it really THAT significant of a speed and performance decrease?
View 1 Replies View RelatedHow do I prevent my Mac Book Pro from shutting down after a period of time? I have set Preferences, Energy saver to "never" but still it shuts down while trying to download a large file. The file is 4.14GB and at my slow connection speed may take 48hrs+.
Info:
Mac book pro, Mac OS X (10.6.3)
I discovered my iMac shut down and to start. I feared it had been fried in an electrical storm the day before, though the whole house is surge protected, and a printer on the same plug was unaffected. I tried unplugging briefly, still no luck. I tried hitting the start button ( on the iMac itself, not the keyboard) a few times over a couple of days with no luck, and unplugged it in prepartion to cart off to a repair shop, fearing the worst. A couple of days later, I plugged it in for one last try before taking it to the car and, bingo, it started! Everything was fine, everything in its place.
A couple of weeks later, I once again notice the computer is turned off and will not restart. I uplug and replug - no luck. I unplug, let it sit, and try it again about 24 hours later.
Info:
iMac, Mac OS X (10.6.8)
I recently got an 20' 2.4 GHz Intel Core 2 Duo Imac. It came with 1 gig of Ram. I purchased 2 2Gig SODIMM chips from New Egg. The ram specs matches what the little manual says. ddr2, pc2-5300 667MHz. When I install the new chips, the mac won't start. Period. No beeps, no nothing. I can sort of hear it try to start, then quits.
When I put back the original ram chip. Works again.When I have the original ram chip AND 1 of the new chips (for a total of 3 gigs of RAM) it works.Swapped one new chip with the other (as long as the original is in) Works.Original Chip is on the right side, New is on the left. Swapped places. Works.The mac will start ONLY if the original is in place. I should be able to start it with the nes ones in but it won't. I know both works because I swapped them.Anybody have any ideas on what's going on? Is there a setting somewhere I need to change or something?
is it recommended to have my Mac Pro set to go to sleep when inactive for a certain period of time? right now I just have my monitor set to to turn off after 45 minutes of inactivity, the computer stays on all the time. What do you guys do? Any reason why I shouldn't?
View 20 Replies View RelatedI have a very limited knowledge of Excel, but generally find that I can figure things out eventually. However, this time, I just can't seem to tweek it so the result is what I want.
I have a spreadsheet for tracking parts ordered, and simply need to display how many days a part has been on order. I have a column for date ordered, and one for date received. Is there a way to program the formula to tell me the days that a part has been on order without displaying today's date in the spreadsheet (leaving it blank), and still be able to enter the date that it does arrive for our records?
