Applications :: Numbers - Formula To Calculate Pay Per Hour / Day

Mar 23, 2010

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

View 3 Replies


ADVERTISEMENT

Applications :: Unable To Use Numbers Formula

Mar 14, 2009

I'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.

View 5 Replies View Related

Applications :: Finding Mac Numbers Formula

May 27, 2009

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 Related

Applications :: Using Excel Formula In Numbers

Feb 22, 2010

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.

View 2 Replies View Related

Applications :: Numbers - Formula For Scheduling A Timetable

Oct 14, 2010

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 Related

Applications :: Excel To Numbers - Fx Formula Not Compatible

Jan 25, 2010

I 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)

View 4 Replies View Related

Applications :: IWork Numbers - Formula With Category

Aug 14, 2010

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.

View 3 Replies View Related

Applications :: Numbers - Formula Not Let To Select Cells - Only Whole Column

Oct 17, 2009

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).

View 2 Replies View Related

Numbers :: Formula To Budget On A Per Pay Period

May 3, 2010

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 Related

Hardware :: USB Transfer Rates - Formula For Real World Numbers

Oct 30, 2009

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 Related

Applications :: Utility To Calculate Disk Folder Size

Sep 20, 2009

I forgot the name of a small app that allows to browse a disk and calculate folder sizes in order to clean a disk. I think the icon was a disk with a broom over it.

View 2 Replies View Related

Applications :: How Do I Fill A Column With Numbers And Equations Automatically In Numbers

Jul 17, 2010

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"

View 1 Replies View Related

Applications :: Input Numbers In Numbers As Degrees Instead Of Radians?

Mar 24, 2009

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.

View 3 Replies View Related

MacBook Pro :: 1 Hour Phone Call, 2 Hour Drive To Store?

Jul 11, 2009

So my MBP 13" 2.26ghz worked up until the firmware update was installed, and then everything froze up and it took about 15 minutes to boot up, 5 minutes to shut down. So i called apple, and after a 1 hour phone call, they told me that i could get it replaced. I live an hours drive from the nearest apple store, and will have to drive up there to get it replaced, do you think i could ask for some kind of compensation for my problems, and having to drive 4 hours (2 to buy it the first time, 2 more to get it replace) to take care of the problem.

Do you think I could ask for the 2.53ghz model, or an apple/itunes gift card. or Should i even ask for anything, i mean i paid 1200 for this computer, and after 3 hours of owning it is not useable, and now i have to spend all this time trying to get it replaced.

View 24 Replies View Related

Applications :: Excel 2008 Date Formula ?

Feb 28, 2009

I 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?

View 4 Replies View Related

Applications :: Excel 2008 - Reset Formula Bar Position?

Mar 19, 2008

The left edge of my excel formula bar is not showing-almost as if it was pushed off the left side of the desktop (see picture). Unfortunately, the only part of the formula bar that allows it to move is now hidden, so I can no longer move the formula bar. I have tried switching the formula bar on and of in "View" and also tried re-loading excel, but it is stuck. Does anybody know how to reset the formula bar position?

View 6 Replies View Related

Applications :: Excel 08 Formula Builder With Multiple Worksheets

Apr 3, 2009

I am currently using excel 08 and have made a workbook with multiple worksheets in it. Each worksheet contains information on multiple products, such as description, UPC, cost, retail, sale cost, sale retail, how many items sold during sale, etc. Sales are two weeks, so every two weeks, I add a new worksheet with new information for sales I will be running a few weeks down the road. I would like to see if there is a way that I can have excel look through the past worksheets so when I enter a UPC into the new worksheet, there would be a column at the end that would take the average items sold during past sales.

For example, if I want to put UPC 1234500000 on sale in the new worksheet, that excel would look at past times I had 1234500000 on sale and take the average of how many sold during past sales and enter that number in a cell on the new worksheet. I don't know if this is relevant or not, but Column D is where I enter UPC info, Column P is where I put how many sold, and Column Q is where I want this average sold to appear (no matter what worksheet).

View 1 Replies View Related

OS X :: Lost Applications On The First Hour Of Using Mac

Apr 27, 2010

i will buy a macbook pro couple months later, so it will be my first mac. I made my PC a hackintosh after a days work, i am using leopard and i wanted the applications folder in my stacks, so i dragged it from the finder and its gone. where can i find it. also where do i open virtual keyboard to type different characters. i cant type apostrophe nor question mark because my keyboard is turkish, hackintosh understands its a us keyboard and all combinations are different. sorry for typing this bad.

View 1 Replies View Related

OS X :: What Does Calculate Image Checksum Crc - 32 And Md - 5 Mean?

Sep 2, 2009

Whenever I open disk utility, I need to choose between 'calculate image checksum (CRC-32)' and ' calculate image checksum (MD-5)' before I can open disk utility. I always click on either one of them because otherwise disk utility won't open. I am wondering what it means. I called the Apple support about it, but the girl on the phone didn't see it on her computer and couldn't find any info about it.

View 2 Replies View Related

OS X :: How Long To Calculate Size Of External Drive

Dec 12, 2009

I am in the process of migrating files from a Dell laptop running XP to my new iMac. Essentially an easy task as all the files are on an external drive.

I have 2 TB of storage on the iMac and thought it would be a relatively simple task to copy from the external hard drive to the iMac.

After connecting the drive to the iMac I then tried to get the size of a directory on the external drive. I've been waiting about 15 minutes now and it still says "Calculating Size".

Just after doing this I started a copy to move files from the external drive to the iMac. Unfortunately all I see at present is the spinning beach ball.

Just wondering if there's a way of cancelling the copy process or of getting some status as to what is happening?

View 1 Replies View Related

Safari :: Google Maps Does Not Calculate Routes

Mar 19, 2012

I am trying to calculate a route from germany to Spain on Google Maps in Safari Version 5.1.4, but I get stuck with a small window saying (loading) and nothing happens.Also - used to be that, once I enetered the departing or destination city in GM, there would be a list already generated, like in the regular "maps" window. Tried changing the DNS server, then turning it of and back on, nothing worked. 

Info:
MacBook Air, Mac OS X (10.7.2)

View 13 Replies View Related

MacBook Pro :: Change India Numbers To Arabic Numbers?

May 22, 2012

how to change india numbers to arabic numbers?

Info:
MacBook
Pro, Mac OS X (10.6.7)

View 3 Replies View Related

OS X :: Snow Leopard - How To Calculate Multiple Folder Sizes

Dec 9, 2009

In windows you can select multiple folders and right click and check the size of all the folders combined, on my mac, when I have multiple folders selected and GET INFO, it opens up a window for each corresponding folder and tells me the size of each folder not how much all are in total....aside from a calculator, is there a way to tell the size combined?

View 4 Replies View Related

OS X Server V10.6 Snow Leopard :: Calculate The Open Directory Size Of Every User Account?

Jun 13, 2012

We use on our Server the OD. About 25 User can ue with their Account every Computer in the Office. Now wo saw the size of the harddrive has very less free space. When we click Apple-I on the users we see it is very low space uses, but this is because all the private folders are blocked. Is their a way to calculate the Open Directory size of every User Account? 

View 2 Replies View Related

Applications :: Getting A Percent In Numbers?

Mar 8, 2010

I'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 Related

Applications :: Keep Blank Cell In Numbers?

Oct 4, 2010

The 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 Related

Applications :: Creating Graphs In Numbers?

Oct 19, 2010

I 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.

View 1 Replies View Related

Applications :: IWorks 08 - Numbers Freezing?

Jun 30, 2008

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.

View 21 Replies View Related

Applications :: Using Numbers For Accounts Receivable

Feb 13, 2009

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 Related

Applications :: Numbers - How To Rename Cells

Sep 26, 2009

In 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 Related







Copyrights 2005-15 www.BigResource.com, All rights reserved