Hello! I have a spreadsheet I use for creating invoices for our clients. We have formulas that calculate the raw rate (showing employees rate before any profit multipliers are applied) for each line. This is part of our checks and balances process for our client, as they look at the rates for...
I am tracking time for short projects and having trouble with rounding to the nearest quarter hour.
I am not sure why, but sometimes projects that are exactly 15 minutes round up to the next quarter hour and sometimes it remains at 15. I would like projects of 15 minutes or less to bill at 15...
Hello All,
Firstly, I'm glad to be a member on this community and excited to have my first post.
Here's my query: So I wanted column F to auto populate the CWT rate for our shipments. This column F would at least show how much cwt the carrier "column E" would charge us for that weight...
I have a sheet with pay rates. There are about 80 different pay rates that differ for age, gender and competition type.
Rather than have a sheet with a rate for every day of the year for the past 12 years I'm wondering if there is a way to do this with effective dates.
So when I'm looking up a...
We are trying to capture errors in rates. Rates can either be 0, 36.12 or 40. How do I conditional format a cell if it's anything other than one of those numbers? And can it be expanded for additional numbers if I have more than three rates
Hello
I am trying figure out the best way to figure out how to get the total # of rates per title in a given range. the rate ranges are uneven intervals.
ex
master sheet
a list of titles column A
a list of different rates column B
sheet 2
has the list of titles no dupes
and the rate ranges...
I am creating a pricing template for services, a section of which is based on an hourly rate. The rates, are by level of seniority which need to be added together then multiple by the number of hours.
I would like the option of only selecting the level of seniority and adding the hours, then...
How would one go about designing an excel sheet that calculates interest like a bank's savings account, meaning balances that change from day to day and interest rates that change during the year? Preferably, the interest rates would come from a table.
Hello!
Is there way to calculate the hours needed at two separate rates that add up to the total cost of a project? For instance, the estimate is 40,000, and the hourly rates are 120/hr for one position and 150/hr for another position. How many hours of each rate would I need to get to 40,000...
Hello, I'm trying to pull what a service rate would be based on a position and a specific rate card. For instance I have a list of titles and rates, and a list of titles and rates under different rate cards. I am looking to pull back the rate for a title under a specific rate card.
Sheet 1...
folks, i am trying to match and compare two data sets to ensure we are charging the correct amount. One contains the rates charged for medical procedures (Rates) and the associated service fee charged for ancillary items, and the other contains patient level data (Patients) including fees and...
What is the easiest way to calculate exchange rates in Excel? Is there a formula wherein the currency code can be entered and it returns the exchange rate into currency #2 for a given day? Seems like there should be a formula for that, but haven't found one. thanks!
Hello,
I am trying to pull current market data (bond rates) into excel from the below link:
https://rates.chathamfinancial.com/us-market/rates
In short, I am trying to pull the rates for each respective term in the 'Current' column as per the highlighted below. I have been able to do this...
hello,
i want to compare a set of roles and rates with another set of role and rates however the rates might have different names like Account Director and Account Director (12) or account manager and acc manager as examples.
is there a way to compare the data with 90% similar roles and then the...
GOMA 480000 250000
KASUMBALESA 480000 250000
KITWE 420000 200000
LUBUMBASHI 480000 250000
LUSAKA 420000 200000
NDOLA 420000 200000
These is the table of rates
I need one formula two pick those rates on b1 and c1 where a1 is location
I dont need this...
Hi all!,
Quick question: So im trying to create a financial model that uses the rand() and randbetween() functions to put in randomised growth rates for certain parameters for a company. Ive successfully set up the functions and output but i want to quick record the output each time I press F9...
Hi
Slightly weird question and I'm hoping Excel is not going to let me down.
I've prepared an IF statement to show if a hourly rate of pay falls with a band of two pay rates and to return "YES" if it does and "NO" if it doesn't -
=IF(AND(R3>=T3,R3<=U3),"No","Yes")
If I get back "NO" I then...
Hello All,
New to VBA and just bought a book to learn.
Trying to update labor rates in column B "not null" when column A = FY-19.
I have about 30 excel files and each one tracks the cost of the 30 individual projects. There are about 450 rows that have the individual manufacturing process's...
I have Cost centers in column G and interest in column Y, Cost centers are repeated and so interest rates accordingly, only one interest rate should be for one cost center, so if there are more than one rates there is an error, so for example
<tbody>
411044924
5.280613
411044924
5.280613...
This one has me stumped! Every day I have an XLSX file that I download from our payroll software and then I copy the data into an Excel template that feeds the information into different tabs. When the data is downloaded, the rates all have $ signs (ex. $10.50). In the template I am pasting...
We have a great community of people providing Excel help here, but the hosting costs are enormous. You can help keep this site running by allowing ads on MrExcel.com.
Allow Ads at MrExcel
Which adblocker are you using?
Disable AdBlock
Follow these easy steps to disable AdBlock
1)Click on the icon in the browser’s toolbar. 2)Click on the icon in the browser’s toolbar. 2)Click on the "Pause on this site" option.
Go back
Disable AdBlock Plus
Follow these easy steps to disable AdBlock Plus
1)Click on the icon in the browser’s toolbar. 2)Click on the toggle to disable it for "mrexcel.com".
Go back
Disable uBlock Origin
Follow these easy steps to disable uBlock Origin
1)Click on the icon in the browser’s toolbar. 2)Click on the "Power" button. 3)Click on the "Refresh" button.
Go back
Disable uBlock
Follow these easy steps to disable uBlock
1)Click on the icon in the browser’s toolbar. 2)Click on the "Power" button. 3)Click on the "Refresh" button.