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)
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.
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.
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 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'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 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?
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 RelatedI 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).
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 RelatedI 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 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 have these Numbers files but need to send them to someone who is using a pc with MS Excel. She won't be able to read the files if they are left as .numbers. The odd thing is that I have successfully saved some of the files as .xls and .xls.xls and even some as .xls.numbers.
However, I have lost data when doing some of these savings - I have been taking the .numbers file and trying to save it as .xls but when I open the newly-saved file there's nothing there. Please look at the attached snapshot of my folder structure. Can you anything in there that might be causing my problem? The red arrows are just to highlight the ones I'm particularly interested in.
My rows in Excel display in Numbers (1, 2, 3) instead of Alphabetical (A, B, C). Therefore I cannot type formulas for fields using A1, B2, C3, etc.
View 2 Replies View RelatedI am experienced in Excel VBA on the PC but not on the Mac. I am building an application on my PC that will run on my sister's Mac (latest OS, Excel V14.0.2). The problem involves the use of FormulaARRAY in my code. I have extracted the problem statement into a small example routine shown below:
Public Sub example()
Dim lastcol As Long
With ActiveSheet
lastcol = 12
.Cells(4, 6).FormulaArray = "=SUM((MOD(COLUMN(RC9:RC" & lastcol & ")
-COLUMN(RC9),3)=0)*(RC9:RC" & lastcol & "))" End With End Sub
Here is one of the correct and working formulas that resulted on the PC (note the brackets for the array formulas are missing but they are there. I got what I am showing by using the 'display formulas' option which apparently does not show the brackets):
=SUM((MOD(COLUMN(RC9:RC12)-COLUMN(RC9),3)=0)*(RC9:RC12))
Here is the incorrect and non working formula that resulted on my sister's Mac: (again the brackets are there)
=SUM((MOD(COLUMN(R[5]C[465]:R[8]C[465])-COLUMN(R[5]C[465]),3)=0)*(R[5]C[465]:R[8]C[465]))
Both systems were set to display R1C1 Reference Style. This is irrelevant on the PC and I would assume the same for the Mac. I bought an old G4 for $60 to use to debug my PC code in the Mac environment. Curiously the code runs fine on it under Excel 2004.
I have some .numbers files that I need a friend to look at on her pc with Excel 2003 SP3, but it's not working for her. I have changed the extension to .xls but it's no good, as when she tries to open them they are all gobbledegook.
Here's a snapshot of the various files I have, but notice how the icons for each is different, or rather that there are two distinct designs? Some of them DO open in Excel, but some do not.
Is there a way to do this ? When I try to open any file that is password protected, I get an error that the file 'in an incompatible format' (if memory serves, I'm away from my Mac right now). I can open it fine in NeoOffice, but it never works in Number '08. I'd consider going to iWork '09 if the problem has been addressed there.
View 2 Replies View RelatedIs there a size limit for importing an Excel File into Numbers? The error message says the file is too large. Has this been changed in i-work 09? The file has multiple sheets that refer to each other, but i can't even open at this point. It is 3.1 MB.
View 4 Replies View Relatedif you have more than one sheet in a Numbers document, is there a way to EXPORT just one sheet to Excel? There is no option to do that under the Export feature. The alternative is to copy the one sheet into a blank new numbers document then export.
View 5 Replies View Relatedhow can I send a Numbers file to someone who has excel
Info:
MacBook Pro, Mac OS X (10.6.8)
The planned mid-January release of Office 2008 offers a significant overhaul of the productivity suite's look and features.
The previous segment described new features in Word 2008, with some comparisons to Apple's Pages 08. This article examines what's new in Excel 2008 and contrasts Microsoft's oldest application to Apple's newest: the Numbers 08 spreadsheet included with iWork.
For all you people out there hooked on Excel. Have you been able to successfully convert to Numbers or are you using both at the same time or did you try Numbers but stay with Excel??
View 12 Replies View RelatedCan I export contacts from Address book to Numbers or Excel?
Info:
MacBook Pro, Mac OS X (10.7.3)
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"
How do i convert a excel spreadsheet to be compatible with a mac?
View 1 Replies View RelatedSee 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 am searching for a plugin, software or a solution for a situation I have with an Excel/Word Mail Merge.
It's a law firm we specialize in DUI/DWI and Reckless Driving defense. We subscribe to a data collection service that pulls data from various court systems around the state. We are then given this data by jurisdiction. The Excel files we receive come with 2 workbooks in one file for Traffic and Criminal arrests data with name, address, reason for arrest, etc, etc.
What I have been doing is opening each Excel file and copying and pasting into a new worksheet only grabbing the DUI and Reckless driving arrests because tis is all I am needing from the various files. I then save the new workbook and do a mail merge with Word from this newly created workbook.
Now my question is there such a plugin or software that will combine all the Excel files I receive from the Data collection house and then be able to filter out only the DUI and Reckless Driving arrests to a single Excel Workbook?
