Spreadsheet calculation problem
I have a workbook with multiple sheets. Two of the sheets each have a
different VBA function in several Cells. When I switch between the sheets,
the values returned by the function are gone and a "Calculate" has to be
done. I have Application.Volatile turned on, otherwise I have PF9 everytime.
How can I preserve the value when I switch between sheets?
"Bruce A. Julseth" <email@example.com> wrote in message
>I have a workbook with multiple sheets. Two of the sheets each ...Date-Time Calculations
I need to create a little spreadsheet to calculate dates for drug
The two inputs are (1) the date & time when the test was taken and (2)
the time period that the test covers. The output is the date when the
test coverage starts.
That's simple except that the units vary. Some tests are good for
hours and others for days. One test can detect alcohol usage for 80
hours. Another can detect drug use for 90 days.
If the test duration units are hours, something like this will work:
A B C D E
1 7/08/08 9:15 am Timesta...Calculate % from list of scores or ratings
I have eight responses to an evaluation that scored experience from 0 (worst)
to 10 (best). From the results posted below, I need to compute % of
responses received for each 0 -10 score received. I also need to compute one
overall combined % for the evaluations received.
Rating Score # of Responses
6 ...Calculate very slow
I have my calculate set to automatic and calculations are getting done
automatically, but at a very slow rate.
The word calculate is constantly on, on the status/task bar at the bottom of
the screen and when you enter a number or delete it, the 'Ready' changes to
'Calculating cells: ??%' and this is when it is now going slow.
Microsoft MVP - Excel
"Rayasiom" <Rayasiom@discussions.microsoft.com> wrote in message news:D1AF7DB1-7DE0-4412-B739-62317333273B@micros...Calculating the number of months
I have a column for start date and end date. I would like a formular that
tells me how many months it is including the start month and end month.
ex. Start date: 11/1/2009 end date: 4/1/2010 this would be 6 months if you
include November and April.
Thanks in advance
assuming that start date is in A1 and end date is in b1....
> I have a column for start date and end date. I would like a formular that
> tells me how many months it is including the start month and end month.
> e...Find formula not calculating?
I'm using Excel 2007 on Windows Vista.
I have a decription in column I like "S/back 2.0 TDI SE DSG " and in
column Q I have the formula FIND("DSG",$I2).
Looks simple enough to me but it isnt bringing the result I want! Just
an #VALUE! error value.
Can anyone see what I am doing wrong?
In column R I have FIND("multi",$I2) and thats working fine!!
If your description is accurate (i.e., that $I2 contains "S/back 2.0 TDI
SE DSG "), then your formula in column R (FIND("multi",$I2) should
return #VALUE!, so ar...Calculate #2
Calculate never goes away in the Status Bar. I have a rather small workbook
in which I've deleted all links to try and reduce the number of calculations.
Each time I hit F9 or Ctrl-Alt-F9 the Status bar flashes 6% and then still
Calculate. Any ideas?
XL: Calculate Message Remains in Status Bar If 65,536 Formula References
> Calculate never goes away in the Status Bar. I have a rather small workbook
> in which I've deleted all links to try and reduce the number of calculations.
> ...Showing + and
I have 3 number fields, all currency in a form.
I have Budget Amount, Estimate Amount and Difference.
What I would like to do is to make the Difference work automatically, I know
you would normally do the is the control source part of the field but what I
need is for it to also display a + or - in front of the answer so for example.
Difference will show +£20
Difference will show -£150
Can anyone help as to what the code would be for this?
Thank You !!
Message posted via AccessMonster.c...Subtotal a calculated field in a pivot table
I'm creating a pivot table listing Accounts Receivable transactions by
customer. It includes both payments and invoices in the results.
Unfortunately both payments and invoices are listed as positive
numbers, so I can't just subtotal the "amount" column.
I've created a formula field in the pivot called "calcamt" that
contains an if statement. The if statement examines the transaction
type code and if it indicates a payment, multiplies the amount column
by -1. Otherwise it just returns the amount column as a positive
When I drag the calcamt field int...Problem Calculating SUms in Tabular Reports
I have created a couple reports from Crosstab queries and when I go to
sum up the columns I seem to get the number of rows as the amount
My columns labeled 1 through 10 and there are 10 rows.
I use the following command: =sum(1) then =sum(2) etc.
I then get the following results: 10, 20, 30, as the totals of each
column. Access seems to be summing the number of rows and adding the
No guarantee, but the first thing I would try would be to make sure taht
Access is recognizes that you are referring to fields.
-- ...Reducing repetitive calculation not working
A B C
1 Fruit Qty =INDEX($1:$1048576,2,2):INDEX($1:$1048576,4,2)
2 Apple 1
3 Orange 2
4 Apple 3
Why does =SUMIF(A2:A4,"Apple",B2:B4) return the correct value ...
.... while =SUMIF(A2:A4,"Apple",C1) returns a #VALUE error ?
The reason I'm not including the formula in C1 as the sum_range in the
SUMIF formula is to reduce the number of duplicate calculations
I tried creating a name with the formula in C1 and using the name in
the SUMIF formula as the sum_range and that works.
But since the sum_range changes, I would have to use the OFFSET
function to inc...Gift Card Redeem
I setup and accept the multi tender Gift Card in my store. This is the
problem that I just find out. I have a $20 gift card and using it to redeem
a purchase of $25, the balance is 5 dollars. Another gift card tender is pop
up in order to allow me to accept another gift card. But the problem is that
I use the same gift card that I already redeem above and enter 5 dollars on
the second gift card tender. The RMS still accept it and processing the
completed transation and print out the receipt for customer with the balance
left is 15 dollars. But When I go back the jounal and check t...Calculating hours worked in a day
I'm trying to create a time sheet for employees to enter their daily time.
I want them to put in the time they came in (ex. 7:50 AM), and the time they
went home (5:15 PM). I want a to be able to calculate the number of hours
worked. In this case it would be 9.42 hours.
How would I be able to do that?
the time they came in in E6 (19:50) format, hh:mm
the time they went home in F6 (5:15) format, hh:mm
=MOD(F6-E6;1)/"1:" Format, standard gives 9.42
> I'm trying to create a time sheet for employ...Ytd Calculation In Pivot #3
For some reason that I do not know I could not read threads but now I a
I would like to thank you for your answer but I think that I confuse
What I actually try to present are the weekly sales of my compan
stores (about 100 stores) and number of customers for each shop, i
contrast with the previous year (2004 vs 2003) for every week and als
YTD for the current week (also 2004 vs 2003) for comparable shops.
I tried to do a pivot, with the following format:
Column A shops, column B 2004 sales for the running week, column C 200
sales for the running week, column D ytd sale...AMEX
I have 2 cards tied to my AMEX account. (3 total = Mine + wife's + Business)
The correct transactions download to the correct account numbers, but the
total shown for each card is still that of all three cards combined. Then,
in any report, Money adds this combined total three times to generate an
inaccurate total that is triple what it should be.
I have seen this too but it puts my Corp Amex in there too. Kind of
skewsmy spending on travel/ent. Hope and answer comes up soon.
The way I was able to seperate my Business Amex from my personal was to
cre...How do i calculate fiscal week of the year
I would like to know how to calculate fiscal week of the year. for
example, the first week of the year is started from Feb 1, 2005 instead
<firstname.lastname@example.org> wrote in message
> I would like to know how to calculate fiscal week of the year. for
> example, the first week of the year is started from Feb 1, 2005 instead
> of Jan.
Thanks Bob, i really appreciate it, i will try to see of this works for
T...calculating time 03-25-10
I have to calculate the following
Employee job in must be 9:00 am, but employee arrived 8.53 am.
Which formula must I use to calculate the 7 min ?
take a look at CPearson web has everything related to timesheet
> I have to calculate the following
> Employee job in must be 9:00 am, but employee arrived 8.53 am.
> Which formula must I use to calculate the 7 min ?
Start time in A1 and arrival time in b1
But this will fail if an employee is late so it'...PivotTable: Customized Calculations
I have salary data in an EXCEL spreadsheet (each row
contains the salary for one individual). I wish to
construct a PivotTable that counts the number of
individuals in each of several salary intervals that I
would specify ($0 - $19,999; $20,000 - $29,000, etc.) How
do I do this? I believe that reporting on such customized
calculations are possible, but I can't find any explicit
guidance. Thanks for your help.
You could add a column to the data table, and calculate the salary
Create a lookup table with the categories, e.g.:
20000 $20-$29...Trying to calculate a time sheet formula
I am trying to create a spread sheet that the user can put in there time and it will total the total hours owed then what is regular , overtime and double time. I have been able to put in the start time of 7:00 am and Finish 4:30 pm less lunch. I have the total hours but I can't figure out how to get the total hours to be pull into the cell as regular which is 8 hours or less and anything over 8 hours but less than 12 and anything over 12. If anyone has an idea has to what I can do I would greatly appreciate your help
have a look at
http://www.cpearson.com/excel/over...how do i set up automatically calculate or run expressions
im trying to program something and im trying to create expression on form but
it wont do it... i always have to go to properties then exit before the
expressions i made take effect...any body can help me
On Tue, 4 Dec 2007 18:03:01 -0800, help!!!!!!!!!!!!!!!!!!!!!!!!!!!!
>im trying to program something and im trying to create expression on form but
>it wont do it... i always have to go to properties then exit before the
>expressions i made take effect...any body can help me
Not unless you tell us what you...Bleed
I need a bleed on my business card composition with 2 differents colors
before I submit the work for print.
I need as well guiding lines to cut properly the business cards
Can somebody help me on this ?
If you are going to cut the cards yourself you would make it easier if
you bought Business card stock in whatever background you like and just
break it up at the micro perforations.
If you are going to a comercial printer, then I am sure he can cut to
dimensions and not need cut marks.
"Nicolas" <Nicolas@discussions.microsoft.com> ...Calculating Date difference in 2 ways
If in cell A1 I write -- = today() - date(2004,12,31)
then the answer I get is a number ( let's say 14 or 15)
But if in cell B1 If i write -- = C1 - D1
where C1 -- = Today() and D1 -- = date(2004,12,31), the answer I get is
in date format (in excel's 1900 base year)
Why is there a diference in formatting of results between the above 2
Hi Jim and Aladin,
I have not written my initial query properly.
My doubt is that inspite of the same formulas and with both A1 and B1 having
no previous formating, what causes excel to interpret these 2 approac...Downloading Credit Card Statements
Although I am a new subscriber to this newsgroup, I have used Money for many
I have Windows XP Pro and Money 2007 Premium.
Each month, I pay my credit card statement with a check. I can download my
credit card statement from my credit union in .qif format, showing each
I would like to be able to then use the downloaded information to assign
each transaction a category and sub-category, all under the check that I
Is there a procedure or FAQ that would detail the steps to accomplish this?
I think it should include deleting the payment transaction and somehow ...Calculating US Payroll
I am trying to run a payroll but after building and removing the build
several times, I am getting an error when I try to calculate "Checks cannot
be caluclated errors were found when building the checks"
I have tried to delete and use new transactions and batches and rebuild and
recalculate but no luck.
There are no errors showing when building the checks.
It appears it is 'stuck'
Have you been through the payroll scripts that clear the work tables? It
may be that something is stuck out there. There is KB article #851664 that
deals wit...testing smart card minidriver
when testing smart card minidriver in windows 7, got the following errors:
"cmck exec Reconnect" always show that
Testing through CAPI calls
Submitting CSP PIN for reader \\.\DMWZ ESAFE 0\
CryptAcquireContext - CRYPT_NEWKEYSET
CryptAcquireContext - CRYPT_DELETEKEYSET
CryptAcquireContext failed unexpectedly
d:\5429t\testsrc\dstest\security\core\credentials\smartcard\cmck\cmck\fnreconnect.cpp Line: 264
Keyset does not exist.
in windows xp, it always passed. i have no idea!
this is my log.
/* P:608 T:3380 8-30...