Code Calculating Incrementally
Mar 4, 2007
What I’m trying to do is based on a character level in cell “G1” I’m looking for “Z1” to show the experience need for the next level. For example:
Level=Experience
1=0
2=1000
3=3000
4=6000
5=10000
6=15000
7=21000
8=28000
9=36000
10=45000
11=etc…
Experience is calculated by 1000 x Previous Level + Previous Experience.
In this above, to reach fifth level experience is calculated as (4*1000+6000).
I know this can be done with a formula, but can a macro or VBA compute this also? For example:
If G1 indicates that a character is at level 5, I want Z1 to show the experience need for level 6. This means I need code to calculate experience from level 1 to level 6 like this:
IF(LEVEL>1,((1*1000+0)+(2*1000+CURRENT EXPERIENCE)+(3*1000+ CURRENT EXPERIENCE)+(4*1000+CURRENT EXPERIENCE)+(5*1000+CURRENT EXPERIENCE)),0) RESULT=15000 for LEVEL=6
That’s the formula equivalent of what I’m looking for code to do. Can this be done?
View 9 Replies
ADVERTISEMENT
Dec 7, 2010
I created a small block of cells on my worksheet where i have in separate cells, the day of the week, the days date and the month. I want to design a special memory calendar for my mom in early stages alzheimers.
There are cells with specific info which i do not want to re type for the whole month/year.
I want to be able to copy all the info into another block of cells and have the day of the week and date change also the month.
View 9 Replies
View Related
Dec 15, 2008
I have a worksheet where over time I add columns that need to be added in a "Total" cell.
=M3+W3+AG3+AQ3+BA3+BK3+BU3+CE3+CO3+CY3
Above example, the cell being added is 10 columns after the previous one.
Question:
What formula can I use to automatically pull the value from every 10th cell starting with M3?
Preferably every 10th cell till a value I determine... i.e every 10th cell but only for the first 15 occurrences.
(Is this anything to do with the Series command?)
View 9 Replies
View Related
Feb 20, 2013
I'm looking for vba code to use that will incrementally rotate an image based on values entered within a cell of an Excel spreadsheet.
I have two graphics, one is the face of a dial and the other is the pointer very much like a speedometer. I can achieve the desired outcome using two excel charts, one overlaid on top of the other, but, this doesn't give me the visual effect I'm looking for.
I'm using the face of the semicircle dial as the background image and I have a separate image for the pointer. When a value between 1 and 100 is entered in cell O3 i would like the pointer to rotate to that position on the dial. The pointer is to have a fixed position and arc left to right where the value of 1 is left-most and horizontally aligned, and for the value 100 the pointer would point in the opposite direction.
View 14 Replies
View Related
Jun 8, 2013
I am trying to find the frequency of lottery numbers that occur within 10-day periods (see row 7). Instead of having to manually write each formula for each column, is there a way I can automate it, so that each column will "advance" 10 days?
Excel 2010
A
B
C
D
E
F
G
H
I
J
K
1
ct
0
1
2
3
4
5
6
7
8
9
[Code] .........
Array FormulasCell
Formula
B8:B17
{=FREQUENCY(B3:HNR3,ball)}
Entered with Ctrl+Shift+Enter. If entered correctly, Excel will surround with curly braces {}.
Note: Do not try and enter the {} manually yourself
Worksheet Defined NamesName
Refers To
'am (2)'!ball
='am (2)'!$A$8:$A$17
View 3 Replies
View Related
Mar 25, 2014
I have what is probably a simple request to all the VBA experts out there, and simply want to take a template sheet in a workbook and copy it across to 100 sheets numbered/named 101 -200, and add the name of each sheet as a text reference, e.g. sheet name 101 will have a cell within the worksheet that refers to sheet 101.
I have attached a simplified spreadsheet which indicates what i'm trying to achieve.
View 7 Replies
View Related
May 2, 2014
I need vba macro code or excel function to calculate average for some intervals in my excel sheet which have more than one value... I need all those values to be get averaged and placed in one cell...
I have intervals like 0-2, 2-4, 4-6.... 22-24.
In these intervals, few have got more than one values like
16-1804/11/201416:29:2616503.9902
04/11/201417:52:4917390.0293
18-2004/11/201419:52:5517204.8086
Now I need 16503.9902 and 17390.0293 need to get averaged and placed in one cell like,
16-1804/11/201416:29:2616947.00975
18-2004/11/201419:52:5517204.8086
View 14 Replies
View Related
Jul 23, 2014
I have months ( 1 to 12 ). Every month, a set of tasks need to be executed which takes "x" number of hours.
So if I have 1 machine working 3 hour in the month 1, the total time spent is 3 hours. Fairly simple right !
Say on month 2, a set of tasks take 4 hours. total time that my first machine takes is 4 hours. But i want to introduce 3 new machines in this month, which will execute the first month's tasks. So total time spent here is ( 3*3 + 4*1) = 13 On month 3, task time is 6 hours. And I am introducing 2 new machines.
So total time is 2*3 ( time taken for 2 new machines to perform first month's tasks ) + 3 * 4 ( 3 new machines introduced last month will now execute second months task) + 6 * 1 ( time the first machine will spend on month 3 s tasks ) = 24
View 2 Replies
View Related
Jul 8, 2009
In my code, I'm calculating a very simple ratio and have the result displayed in a message box. However, I want to have this value only show 1 or 2 significant figures (e.g. if I take 9 / 7, I want to show 1.3 and not 1.28571).
View 2 Replies
View Related
Mar 5, 2014
I need to calculate SUM and AVERAGE of rainfall for each and every year separately and must be displayed separately in a separate column. For your easy understanding, I have done manually and attached the excel sheet.
View 6 Replies
View Related
Jan 27, 2009
I use excel 2002 but some of my office are on 97, i want to add a small workbook open event code which works for me but debugs for the others?? The code is basically, go to a tab, on that tab and that range sort..
View 2 Replies
View Related
Feb 8, 2007
I've developed a little software using Excel Macros & VB. To prevent people from accesing the code I protected the code blocking it from visualization. It seems not enough as an acquaintance of a friend cracked it in 25 minutes. Or so he says. So I'd like to know if there is a better way to protect the font code.
View 8 Replies
View Related
Mar 9, 2013
I have an excel file having part code,name,vendor and Qty ( Quantity ).
My problem is that I want to apply an excel formula to pick up that vendor code who have highest Qty of a part code.The condition is that S.No.should not be disturbed.This file is so large,but here I have taken an example,
View 2 Replies
View Related
Nov 4, 2009
im running a new bar in Leeds and im trying to create a spreadsheet which will tell me how much to charge per drink to gain a 80% GP on products, ive got as far as listing the products and prices and calculating how much every measure (25ml) will cost. In the past ive used formulas where I can input the price i charge and it will calculate the GP (=SUM(D10/E10)*100-100) for example but id like to be able to type in the GP I want and for it to tell me the price i need, im not sure if tis possible but it will be a massive time saver.
View 9 Replies
View Related
Mar 17, 2009
I have some activities that needs to be done ina specified time
Like for example
TAT HRShrsACT 14ACT 28ACT 324ACT 42ACT 54
And i have a sheet where in i need to calculate turn around time
ActivityStart timeEnd timeTATACT 1ACT 2ACT 3ACT 4ACT 5
Based on time entered in start time and end time the TAT column should calculate the TAT based on the above standards.
I also would liuke to exclude weekends(Saturday, sunday). Also the TAT should only be calculated during working hrs between 7:30 PM to 4:30 AM.
View 9 Replies
View Related
Oct 25, 2007
I'm trying to make a worksheet where I can calculate the cost of a mobile postpaid subscription. It is charged per minute and the cost differs depending on which of the 2 available networks the customer is calling to. The first 20 minutes are free, not depending on network.
Edit:
Charges to network A is 1,79,- per minute after the first 20 minutes are spent.
Charges to network B is 2,29,- per minute after the first 20 minutes are spent.
To sum up:
1. The customer makes a call.
2. If there there are available free minutes, these should be spent first.
3. The customer is charged per minute, depending on network called.
View 14 Replies
View Related
Mar 1, 2008
I am on an auto show board and want to come up with a way of calculating the ballots that come in, using excel. Ballot points are accrued as follows: 5 points for 1st place, 3 points for 2nd place, 1 point for 3rd place. With about 25 different categories (classes) and I am estimating participants at around 100.where I can in the automotive field knowing there is nothing besides personal gain.
View 12 Replies
View Related
Nov 9, 2008
I am having a problem with some of the cells in a spreadsheet not calculating.
For example, in column A, all the cells have formulas that pull data from another sheet. When I enter the formula, only the formula shows (not the result). I can't figure out what is wrong as the formulas in column B work fine (the results are showing, but not using the same data that column A is).
I am thinking it may have something to do with the data being used to calculate the formulas but not sure. How can I resolve this?
View 7 Replies
View Related
Dec 5, 2008
For my Intro to Engineering class, I collected data of two filter media in the laboratory. The data included the % of the media which passed through a sieve and the sieve openings. For use in a certain equation, I need the opening size at the 10th, 30th, 50th, 70th and 90th percentiles. I've tried searching on the Microsoft website but I don't think the PERCENTILE function will work correctly with the given data. I also tried using the slope between points to find the opening sizes at the percentiles mentioned, but doing so yielded different results from my professor's. Attached is the data I collected organized in tables and graphs of the data. I have also attached a pdf file of an example which my professor has given us.
View 5 Replies
View Related
Mar 10, 2009
I think a really easy no brianer, I need to find the difference in percentage terms of two values. I am using =(B2-A2)/ABS(A2)
where B2 = 24.09
and A2 = 21.08
View 2 Replies
View Related
Apr 17, 2009
Problem - billing spreadsheet for prisoner fee.
1 - 8 hrs = $55
9 - 24 hrs = $55 + $65 or $120
Anything over 24 hrs - $65 for each additional (24 hrs) ($185)
So if you were locked up for 6 hrs it is $55. If you were locked up for 18 hrs it is $120. If you were locked up for 28 hrs it is $185. And if you were locked up for 49 hrs it is $250. Cell F5 contains number of hours locked up - I would like cell I5 to calculate the cost of the stay. I am proud of myself for figuring out the date and time subtraction - but this part has me stumped.
View 5 Replies
View Related
Jun 9, 2009
In order to compute and forecast an estimate of the triennial rent adjustment, i need to compute the rise in the cpi (table) from the lease date (cell c3) and the present date (cell a2) or the closest publishe date existing in the table. The % rise is easy to calculate present index / opening index -1 = % rise in cpi. I update the index monthly when onthe bls publish it.
View 3 Replies
View Related
Jun 20, 2009
I input a month as a start date, and then want the next x number of cells to increment by one month based on the start date. I thought this would be easy using the preset DATE function but I can't get the thing to do what I want.
View 9 Replies
View Related
Nov 12, 2009
Firstly, i'd like cell G5 to show the amount of time worked i.e diff between E6 & F6. Secondly I'd like help with the formula for cells AF6 & AG6 which would require AB6-AC6 divided by the frames, every time I try it I get a messed up answer.
View 14 Replies
View Related
Nov 24, 2009
I had an excellent response last time I posted here, this time I’m stuck again with a new formula. I’m trying to calculated amounts between different times, but keep tying my self in knots with complicated IF formulas.
Is there an easier way to work out hours worked between 2 times, but too complicated things further I need three separate amounts so I’m guessing I’ll need three separate formulas
Hours between 00:00 – 06:00
Hours between 06:00 – 19:00
& hours between 19:00 – 00:00
An example could be, 05:00 – 20:00 should be 1,13,1
View 11 Replies
View Related
Jun 20, 2007
I have run into a problem I have not found a solution for surprisingly. I need to calculate several fields on the form prior to saving it and thus exporting the data to the worksheet. All I can find is how to calculate the field in a worksheet and then reference it with VB code on the form. Is what I want to do possible?
If I run into many more problems I may want to shop this project out as my schedule barely allows for the work I have let alone attempting to learn VBA on the fly.
If anyone is interested I can post the project so far along with the detail of what I want it do in the end.
View 9 Replies
View Related
Apr 1, 2009
I have the workbook set to Auto Calc the Cells, which seems to be a bad idea, because with the amount of formula in the workbook, it slows the whole thing down and makes it impossible to do anything within it.
Is there a way that I can speed this process up, using some code when I run certain sections?
There is a copy of what I am doing, so you can see the amount of formula.
View 13 Replies
View Related
Jul 27, 2009
I have a list of hotel IDs in one column of my spreadsheet. In the next few columns, I have ratings that customers gave the hotel for cleanliness, location, room, etc.
What I need to do is calculate the median of all the ratings for each specific hotel, in a separate column.
An example of what I have: ...
View 8 Replies
View Related
Jul 26, 2006
I'm sure this will be an easy calculation for most of you...........
If I have two numbers, ie. 390 and 217, how can I calculate the difference
between the two figures as a percentage? (These two figures represent sales
in two months and I need to know the difference in percentage terms).
View 10 Replies
View Related
Apr 3, 2008
I'm looking to calculate OT wages when they happen vs only at the End of Week totals. ie... if the employee hits 40 hours midshift on a Wed, I want to calculate what the total dollars would be for Wed.... a few hours at regular time plus what ever hours above 40 at time and a half.
View 9 Replies
View Related
