effort

  1. L

    Graph Question with 2 X-axis

    Hi I have 2 data columns A - Heart Rate (example 165) B - Perceived effort (8.5) I would like to chart both of these by having 2 X-axis... Heart rate on the left and Effort on the right... I can't see to set these up so that the lines are somewhat normalized and plotted to together... Can...
  2. T

    "Can't execute code in break mode" when copying worksheet array to a new file

    I am trying to execute the code below to create a set of workbooks to send out various people in my organization. It copies a series of worksheets to a new file, breaks the links, and saves with their name and position number. When I step through this code manually, it works as intended...
  3. M

    HELP PLEASE! Determine scorre by look at number that is between two cell values

    <style type="text/css">p.p1 {margin: 0.0px 0.0px 0.0px 0.0px; font: 12.0px 'Helvetica Neue'}p.p2 {margin: 0.0px 0.0px 0.0px 0.0px; font: 12.0px 'Helvetica Neue'; min-height: 14.0px}</style>Hi, I would like to use a vlookup to determine the effort scope in column L by referring to the table in...
  4. K

    Average score for each project by person

    I want to calculate average "Estimated Effort" for project associated to each EVP. For example, Wilber has two projects, one has an estimated effort of 2 and the other one is a 3, so I want to create a table that pulls the information for Wilbert and states looks something like this: Report...
  5. A

    Insert multiple columns based on cell value

    Hi All I need to insert columns 'Budget Hours' and 'Budget Cost' on the left of the column cells 'Planned Effort' and 'Planned Cost' respectively, and shift the data of Planned Effort and Planned Cost to the right as below: Before insert D3 Planned Effort F3 Planned Cost H3 Planned Effort J3...
  6. B

    Impact Effort Matrix

    Hello all I need help with my Impact Effort Matrix. The records results in column C and D starting at row 5 is my Impact and Effort results. see the sample chart below. I would like to do 2 things How do I create a formula for my chart starting F5 where it will address all of the following...
  7. P

    Power Pivot query

    I'm learning how to use the power pivot - which is an extraordinary improvement on normal pivottables. But I don't know the full capabilities. My challenge is this: I have data arranged as follows (the real data is more complex): <tbody> Activity Start Date End Date Total Effort A 1 Jan...
  8. V

    Import XML to Access

    Hii.. Im working on a personal project where I need to import an XML(several) file to Access. I play a game called War-hammer 40k that has about 14 different armies, each army with 70+ units, each unit with different stats. There is an open source platform with all of the data in XML with .cat...

We've detected that you are using an adblocker.

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.
Go back
Back
Top