Task Start and End Date Calculations with Part Time Resources
I have a project for a client that has a strict budget. The budget was
based on buckets of time assigned to high-level tasks. These buckets
(and dollars) are not based on calendar duration but actual billable
hours. I have to divide the hours across lower-level tasks, and my goal
is to drive out what my project milestone dates and final end-date might
be based on the task work estimates and my resource availability.
I have resources who are assigned to my project as well as other
projects. Their availability to my project varies -- some are 80% (32
hrs/week), some are 60% (24 hrs/w...Calculating Percentage in Query.
I have a query with the fields
Quantity (Count of ID's), Product, company.
My issue is to calculate the percentage for each company in a query
When I put Quantity/Sum(Quantity)) I am getting subquery warning. How can I
accomlish this in a query.
That is , I would like to get
Quantity, Percenage: Qty/Sum(Qty), Company.
Any help really appreciated.
Create a totals query to get your SUMs for the equation.
Join the query with your table in that output query to get percent.
Build a little - Test a little
> I have a query with the ...How do I keep my excel files in Excel 2003, not auto 2007
I loaded a trial version of excel 2007. I want to continue using 2003
instead of buying the full version, but my old spreadsheets keep
automatically changing to 2007.
Delete the trial version. Control Panel > Unistall Programs > Uninstall
XL2007 Trial Version.
"DorothyL" <DorothyL@discussions.microsoft.com> wrote in message
>I loaded a trial version of excel 2007. I want to continue using 2003
> instead of buying the full version, but my old spreadsheets keep
> automatic...Auto Fill?
I want to list dates in sequence by week day of Saturday. Where is the
How about an alternative.
Put your first Saturday in the topmost cell (say A1)
then put =a1+7 in A2 and drag down (or fill down)
"W. Wells" wrote:
> I want to list dates in sequence by week day of Saturday. Where is the
> option Autofill?
Using Autofill to repeat a specific sequence requires you to identify
the sequence in the first two cells.
Enter the first Saturday date in the first cell. If you were using
August 2006, you would enter a 5.
Enter the se...calculations not right....
in my report i have Qty, UP2, and NetAmount. NetAmount =[Qty]*[UP2]
my [Qty] is = 5
my [UP2] is = 170.86
now when my NetAmount comes up is says 854.32, when it should be 854.30.......
why is this? I have [UP2] format set to $#,##0.00;($#,##0.00); with decimal
places set to 2. NetAmount =Nz([Qty],0)*Nz([UP2],0) Currency, Decimal set
to 2..... I cant figure this out...
Message posted via AccessMonster.com
What "format" you are using has little/nothing to do with how the data is
What are the unde...Auto Fill button
Does anyone out there know how to program the autofill button to be used for
different applications. For instance, it is currently programmed to be used
with shipping carriers to fill out default customer and shipping info. I
would like to use it to fill out customer info into a booking program online.
...Auto copy for outgoing email #2
Hope someone can give me a idea.
Server: Microsoft Exchange Server 2000. Client: Microsoft Outlook 2003
I would like to setup auto copy outgoing email of selected mailbox to
For example, all emails sent by user A, the email be delivered to user B
automatically. But the user A does not know that the email is copied to user
Thank you for your attention in advance.
Message journaling by putting your users in dedicated store
SelectiveJournaling for MS Exchange 2000/2003
http://www.ivas...Calculating age #3
How to calculate ages of employees for benefits enrollment given the date of
see your other post
P.S.: please don't multipost
"Joe S." <JoeS@discussions.microsoft.com> schrieb im Newsbeitrag
> How to calculate ages of employees for benefits enrollment given the
> Joe S.
Use the DATEDIF function. E.g.,
For more information on DATEDIF, see
www.cpearson.com/excel/date...Form Field Auto Resizing
I've created a form based on a table that has mostly Memo fields.
I'd like to cut and paste varying length text into different form fields
(that are Memos) and have the field on the form "Auto Resize" to the length
of the text.
Is that possible?
You help is greatly appreciated!
...Calculating length of time with conditions
I would like to calculate the length of time a client spends in a program.
We use three columns (entry date, exit date, today's date). If a client is
still enrolled I would like to base the length of time on today's date. If
the client leaves the program, I would like to base the length of time on the
exit date. Preference is to display the length of time in months. Thank you.
You want Datedif, as in:
=Datedif(entry date, if(exit date = "",today(),exit date),"m")
"markg" <firstname.lastname@example.org> wrote in ...How do I get a value of a calculated point on an excel line chart?
I created a line chart in Excel and I wanted to find out if there was a way
to find out the value on any particular point on the line (not one of the
values I entered to create the line, but one in between)?
On a Line or an XY chart?
Bernard V Liengme
remove caps from email
"klc6778" <email@example.com> wrote in message
>I created a line chart in Excel and I wanted to find out if there was a way
> to find out the value on any particular point on the line (not on...Calculated Fields showing error results
I am trying to get a calculated field to work within a pivot table. The two
fields in the pivot table which I'm referencing are sales and Profit dollars.
I want the calculated field to show gross profit dollars (percent to total
sales represented by profit), but without any error values (!value, div/0,
etc.) where there are no sales for a particular line (i.e. customer) in the
timeframe I'm analyzing. The formulae I've tried are:
i would like to make an automatic e-mail that will send to a new user that i
for example if i make a user it must send an e-mail that i have earlear
created telling the new user from the company and all policies that the
can anyone help
exchange does not have built in functionality to do this. you can create a
script that will both create the user and send the email.
"Juan" <firstname.lastname@example.org> wrote in message
> Good Day
> i would like to make an au...Auto Renumbering in Excel
...Different Calculations in Pivot Table Subtotal Rows
I have a pivot table containing sales data in which the products are
in row headers and each month's net sales and cost of goods sold
(cogs) are the column headers.
January 05 January 04
Product Net Sales CoGS Net Sales CoGS
101 $5000 $2000 $4000 $1800
I have subtotals after every set of products in every product group
that simply add the Net Sales and CoGS data. I want to make a third
column heading named "Margin %" for each month which is equal to (Net
Sales - CoGS)/Net Sales....Auto Fill fields in table
I am creating a database for my small consultancy - around 30 clients.
In addition to the table containing names, addresses, etc. I want a table to
record invoices raised - dates, amounts, date paid, etc.
I'm assuming i make the Client ID field the primary key in the contacts
table. How do I use this to auto-complete the client firstname and surname
into the invoice table? In other words - I want to just be able to enter the
client ID into the invoice table and have it enter the firstname and surname
Thanks in advance.
On Mon, 28 May 2007 11:17:30 GMT, &q...COP AUTO-CREATE RETURN
When we use create return through extras and open Invoice Document Lookup no
invoices are listed. In our other company the feature works fine. I logged
in as sa and that did not help. This is a newer company, is there a setup
procedure that needs to be completed?
Thanks for your help
The only way I could replicate that behavior was by not selecting a customer
first from the Create Returns window.
Charles Allen, MVP
> When we use create return through extras and open Invoice Document Lookup no
> invoices are listed. In our other co...Calculating with named ranges
if I have a range named "Quantities" in cells C3:O3 and a range named
"UnitPrice" in cells C5:O5, can I enter formulas in each of cells C7:O7 that
use the range names to perform the multiplications of cells C3 * C5, D3 * D5,
in C7 the formula would be
and then just drag it across to O7.
> if I have a range named "Quantities" in cells C3:O3 and a range named
> "UnitPrice" in cells C5:O5, can I enter formulas in each of cells C7:O7 that
> use the range names to perfo...Auto Formatting an Excel Spreadsheet
I have an automated process (batch file) that is creating a text file (it
can't automatically generate an Excel file) from a database each night and
saving it on a network drive with an .xls extension. I then have an intranet
page (HTML) that is looking for that Excel file each day to present
up-to-date information from the database. However, the formatting (e.g.,
column widths, colors) is overwritten each night when the file is
regenerated. I know the column widths, colors, etc., that I want to apply to
Is there a formula to caluculate interest easly.
I have different deposit dates
Different dates that interest rates changed mostly in the middle of a month
never on the same day of a month.
I must calculate interest and interest must be added to the deposit after a
Do you mean simple interest or compound interest? - and is the firs
year interest free? - or is interest to be added to the account 1
months after it is calculated, or is the interest for a yea
accumulated and added to the due amount at the end of a year?
If the interest is 'Simple Interest', is there a...how to stop excel from auto formatting whole number to decimal %
how do i stop excel from auto formatting whole numbers into decimals?
input 3 --> excel would show 0.03
From the Excel main menu:
UNcheck: Fixed decimal places
Does that help?
> how do i stop excel from auto formatting whole numbers into decimals?
> input 3 --> excel would show 0.03
ron, you are amazing!
thank you soooooo much.
"Ron Coderre" wrote:
> Try this:
> From the Excel main menu:
> <...Auto Reply
How do I put an "Out of Office" auto reply, when I am away from the office?
If you do this, you will have to leave your computer on 24/7, be connected
to the Internet, and have your e-mail program open. If you want do this
anyway, the link below will explain how to do it. One thing I would
suggest is that where it says to create a rule and check For All Messages,
you change it and make the rule for people in your address book only.
Otherwise you will be replying to Spam as well and could end up in an
endless loop of bounces.
Your ISP may offer this service which woul...auto fill question
i'm trying to use the auto-fill function to populate a column with a
'countif' function. although the formula is counting the number of
occurrences of 'x' in a given column, i want to autofill vertically
while the reference columns run horizontally. must the autofill
function operate in the same direction as the reference data? is there
a way around this?
by way of a generic example:
so, when i pull down the autofill handle, the formula should change
=COUNTIF('widgets'!M:M,"x")...Calculating Hours and Minutes in Excel
I am doing payroll hours in an excel spreadsheet. Is
there a way to enter the time in and time out and have a
formula calculate how much time it comes to. For
example, I have an employee that started at 8:55am and
left at 10:40am. Is there a formula that calculates how
much time that comes too?
Thanks very much, Janet
If A1 stores the time the employee started working and B1 the check-out
time simply subtract both values:
If you want to use this number to calcualte his wage, multplky the
result with 24:
for more information have a look at
http...PDF icon in calculated cells
I have a calculated column and a PDF icon has appeared. If I delete the
contents of the cells, the PDF icon remains. How can I delete the PDF icon?
Right click on the icon and select cut from the popup menu.
"Texas Bald Eagle" <Texas Bald Eagle@discussions.microsoft.com> wrote in
> I have a calculated column and a PDF icon has appeared. If I delete the
> contents of the cells, the PDF icon remains. How can I delete the PDF