rate

Hello, I have a workbook with 2 sheets. Sheet 1 contains 3 rate plans all with their own checkbox (form) 1. Basic 2. Advantage 3. Gold I have a second sheet that all the inclusions of the rate plans. I have added on the top of the sheet the rate plans and a check box next to the inclusion...

Hello, I have a document that has a couple of sheets. Sheet 1 has 3 rate plans 1. Basic 2. Standard 3. Platinum Each rate plan has the inclusions documented on another sheet in the same workbook. What I would like to know is it possible for a rate plan to be selected and the inclusions on...

I have a table of data with multiple fields that I need to include to assign a classification, or "grade" to. For example, in my data, I have: department floor set date region average rate of sale I need to assign an "A" to those items who are in the top 30% of rate of sale for each...

Hi, I'm struggling to come up with an IF formula that works (If that's the right formula to even use), and I need an expert to point me in the right direction. I'm trying to come up with an price calculator that will calculate a pallet rate or a lift rate depending on the cubic volume or the...

hi all. i'm trying to work a reverse calculation on a finance repayment calculator. i have have the standard amortisation calcs.. $20k amount 84 months 10% interest $332 repayments per month Total interest component of $7890 If i bump the repayments up to $375 per month, it lowers the loan...

I have one tab and on it I have 3 columns date, dollar Amt and margin. On another tab I have two columns one is a list of dates and next to them is the Interest rate, this second tab basically is a historical listing of the fed lending rate. I want to place a field on the first tab that looks at...

Hi I am looking for a VBA to open a workbook (FX rate log) from a specific file path and the look for a specific date (Today()-1) and copy the rows including the date and various currency rates to another workbook (Working model) within worksheet (FX Rate). Data layout in FX Rate log –...

Pls help... I have a table like this ID , Rate ========== 1, 0.2 2, 0.5 3, 0.3 I want the query ID , Rate, result ========== 1, 0.2, 0.2 2, 0.5 , 0.1 3, 0.3, 0.03 What is the SQL to achieve this ? Any idea and interim table needed ? ie, accumulate multiplication (instead of sum) is...

Hi Could really do with some assistance on this one ...svp Table below . . . to achieve 16000 in A3 I've calc'd as follows; =$B3*((D3*E3)+(F3*G3)+(H3*I3)+(J3*K3)+(L3*M3)) ... this works but is 'long-hand' and doesn't address the rate changes in columns B & C. Does anyone know a way of using...

All, If I even change a name of a query or something in the last step, the query refreshes all previous queries and it's very slow. Is there a way to stop this behavior that doesn't result in me just completely forgetting to refresh older ones? It's 3-4 minutes I have a few joins which make...

Hi, this forum is awesome. I have researched my problem, and cannot find the correct resolution, so here goes: I need to be able to insert a employee hourly rate into a table. The employee hourly rate is identified by using a combination of 2 variables. Here is the source table with the roles...

I have Table A like this Country, Product, Sales ========== US, A, 100 UK, A, 200 US, B, 150 UK,B, 350 In Table A it is like this Country, Product, Rate =============== US, A, 0.9 UK, *, 0.7 I want to join these 2 tables if both Country and Product are same as those in Table B, so that Rate...

Hi, I need help on calculation FV. I need to know the FV of a $1M investment that pays out 5% interest on a monthly basis. PV $1m Number of years 5 Interest Rate 5% Payment $ this is where i don't know what to fill out FV ? Thanks

Hi Guys i have the table below with some results the score seems to be incorrect i am not sure if its my formula <tbody> a b c 1 Name Result 2 James 2% 3 Alex - score 20 </tbody> the formula i use to get the result are as follow for both james and Alex...

I'm creating a Level of Effort Calculator. I already have some complex VBA macros that help add or delete specific data in the various tables across the worksheets in my workbook, so if VBA is required, that's no big deal. The summary of it all is that in table1, I have a dynamic Data...

Hello, I have a large spread sheet that lists multiple currencyvalues. For each value there is anassociated daily fee, weekly fee, and monthly fee. For example: <tbody> Value Daily Rate Weekly Rate Monthly Rate Value Daily Rate Weekly Rate Monthly Rate Value Daily Rate...

Hello, I have a spreadsheet with the following 4 columns – Group,Type, Day Rate, Night Rate. Each row ofeach column has a drop down selection list. Based upon the selections made, I want the spreadsheet to populate theappropriate Day Rate and Night Rate. Data regarding the rates is in a...

I would appreciate someone sharing their Hyperbolic Decline macro or equation. Q=Qo/(1+Di*b*t)^(1/Di) Where: Q=production rate Qo=initial production rate Di=initial decline rate b=decline rate t=time My issue is D change at each time step Trendline doesn't have the Hyperbolic Decline option

Also posted to reddit at r/excel https://www.reddit.com/r/excel/comments/bjp4di/vba_split_strings_into_odd_and_even_arrays_then/. No replies yet. TL;DR Can I split a text string in such a way that each element can be used in an expression when I loop through the array? Can I format those...

Hi All, Any help is appreciated, I've been playing about with this trying to get the formulas right, assuming an IF formula, but not sure how to separate if it requires an answer between a certain range. For example, I'm trying to write cell formulas so whatever Gross income is entered it...