Posts by Herbds7

Re: Bubble charts with custom shades for bubbles

Macro updates names correctly.
Show your troubleshooting effort.

Re: Copy rows from multiple sheet to master sheet - consolidation

Excel 2010
My code already accommodates a master sheet for each task.
Glad to help after you upgrade.

Re: Bubble charts and 4 types of value

Excel 2010 Bubble Chart
With five (5) categories
X, Y, Size, Color, Name
http://c718892.r92.cf0.rackcdn.com/01_11_10.xlsm
If you get *.zip, don't unzip, just rename *.xlsm

Re: Calculate amperage based on variables wire length and max amps at sockets

Excel 2010 (only)
Will not convert to an inferior version.
NICEIC example formulated and illustrated.
http://c3017412.r12.cf0.rackcdn.com/03_03_11.xlsx
If you get *.zip, don't unzip, just rename *.xlsx
http://www.mediafire.com/file/0s3abba7w0ijisw/03_03_11.pdf

Re: Copy rows from multiple sheet to master sheet - consolidation

Excel 2010 (only)
With macros, Tables, PivotTables, Structured References.
Will not convert to previous versions.
http://c3017412.r12.cf0.rackcdn.com/02_28_11.xlsm
If you get *.zip, don't unzip, just rename *.xlsm

Re: Copy rows from multiple sheet to master sheet - consolidation

Excel 2010 PivotTables, Tables
Sine qua non conditions:
Excel 2010, VBA, PivotTable proficiency.
http://c3017412.r12.cf0.rackcdn.com/02_28_11.pdf
More if you accept.

Re: Time Formula

Excel 2010, Tables
Count time between two dates/times, include only working hours,
exclude weekends and holidays.
Accurate to the minute.
With chart.
http://www.mediafire.com/file/bico1g3ixub44ri/02_26_11.xlsx
http://www.mediafire.com/file/4d241411jeyqkb5/02_26_11.pdf

Re: Transposing column information into multiple rows

Excel 2010 (only) PivotTable, Tables
Transpose columns to rows
No formulas, no code needed.
http://c3017412.r12.cf0.rackcdn.com/02_25_11.xlsm
If you get *.zip, don't unzip, just rename *.xlsm
http://www.mediafire.com/file/tyyy14chn4r2vo8/02_25_11.pdf

Re: Format color of a 3D barchart bar based on catagory name

Excel 2010 Chart
Here is another example of accent coloring and labeling points.
Anything simpler is just no fun.
http://c718892.r92.cf0.rackcdn.com/01_11_10.xlsm

Re: Datevalue function does not work for German Language Excel using English dates

=TEXT("3/24/2010","[$-0407]dddd,mmmm,yyyy")
Mittwoch,März,2010
http://msdn.microsoft.com/en-US/goglobal/bb964664.aspx

Re: Move Chart Elements by Mouse

Excel 2010
To trace any graphical object,
use your method to position the object,
then create a proper sized grid with a macro
and mouse over the object to get its X Y coordinates.
http://c3017412.r12.cf0.rackcdn.com/02_24_11a.xlsm
If you get *.zip, don't unzip, just rename *.xlsm

Re: Format color of a 3D barchart bar based on catagory name

Excel 2010
Format chart points according to category names.
With pictures instead of colors.
Animated.
With macro.
http://c3017412.r12.cf0.rackcdn.com/02_23_11.xlsm
If you get *.zip, don't unzip, just rename *.xlsm
http://www.mediafire.com/file/i9cemeqdz76zsck/02_23_11.pdf

Re: PivotTable calculated fields on non-field columns

Excel 2010 PivotTable
With helper Tables.
Tables resize, re-reference with refreshed PT.
With macro.
http://c3017412.r12.cf0.rackcdn.com/02_22_11.xlsm
If you get *.zip, don't unzip, just rename *.xlsm
http://www.mediafire.com/file/jbkcd73h5km5v9g/02_22_11.pdf

Re: Calculating Difference between two Dates

Excel 2010 (only) Tables
Calculate time between 2 dates/times
include only working hours, exclude Sunday,
Saturday has odd hours.
With formulas.
http://c3017412.cdn.cloudfiles…cecloud.com/02_09_11.xlsx
If you get *.zip, don't unzip, just rename *.xlsx

Re: Conditional setting for PivotItems in given Pivotfield

Excel 2010 (only) PivotTable
Filter Page Field with listed items.
With Slicer and macro.
http://c3017412.cdn.cloudfiles…cecloud.com/02_08_11.xlsm
If you get *.zip, don't unzip, just rename *.xlsm
http://www.mediafire.com/file/2bkh1q4ht9igvw4/02_08_11a.pdf

Re: formula for calculating hours between two dates

Excel 2010 (only) Tables
Hours between two dates/times,
during work hours, excluding partial weekend.
http://c3017412.cdn.cloudfiles…cecloud.com/02_08_11.xlsx
If you get *.zip, don't unzip, just rename *.xlsx
http://www.mediafire.com/file/z1zzpa7w3xhggbc/02_08_11.pdf

Re: Pivot Table with two date columns

Excel 2010 (only) PivotTable
Count dates.
No formulas, no code necessary.
http://c3017412.cdn.cloudfiles…cecloud.com/02_07_11.xlsm
If you get *.zip, don't unzip, just rename *.xlsm
http://www.mediafire.com/file/xm8575yxuc141s2/02_07_11.pdf

Re: Changing filter of pivot table with a cell value

Excel 2010 (only)
Multiple PivotTables.
Connected Slicers.
No formulas, no code.
http://c0718892.cdn.cloudfiles…ecloud.com/12_30_10a.xlsx

Re: Compute Project Start/End Date

Your first post says:
...9 contacts per week....
Your second post says:
...3.43 weeks to make 120 contacts...
The hours per contact do not match:
One Week * 40 Hours / 9 Contacts = 4:26:40 (h:mm:ss) per Contact
3.43 Weeks * 40 Hours / 120 Contacts = 1:08:36 (h:mm:ss) per Contact
If your forecast runs into decades, be sure to add all the holidays,
vacations, sick leaves, union strikes and blizzards for each year into Table1.

Re: Compute Project Start/End Date

It's easier for the forum community to work with hours.
If you work for 3.43 40 hour weeks on 120 contacts,
then each contact takes 1.14 hours (1:08:36)
Enter this time into Table4.
You'll be done by 6/19/2013 12:20 PM.