Posts for 10/2008

20 October 2008 - 06:46

E-mail Obfuscators

Ever wanted to 'obfuscate' your email addresses? Ever heard of the term 'obfuscation'?

To start with the latter, Wiki says:

Obfuscation is the concealment of meaning in communication, making it confusing and harder to interpret.

In IT terms, obfuscation got a wider practice with the upcoming need to hide email addresses from search robots, email harvesters etc. It there refers to making the code obsolete or un-readable for robots or programs other than those the code is destinated for.

If you're still into search for some good tools here's just a grip out of the tools available on the net:

After obfuscation your code typically looks like this:

<a href="javascript:location='mailto:\u0069\u006e\u0066\u006f\u0040\u0065\u006d\u0061\u0069\u006c\u002e\u0063\u006f\u006d';void 0">Danny</a>


<a href="&#109;&#97;&#105;&#x6c;&#116;&#111;&#x3a;&#105;&#110; &#102;&#x6f;&#64;&#x65;&#x6d;&#97; &#105;&#x6c;&#46;&#x63;&#111;&#x6d;">Danny</a>

You can of course also use an image or a simple descriptive : danny'at' :-)


(0) Comments ·
18 October 2008 - 14:08

Median in MS Excel Pivot tables

Adding to a previous post on this blog, Excel pivottables and subtotals in % relative to row-values, I keep on receiving all kind of simular questions of things which are hard or not possible with Excel’s Pivot Table functionality .  One of these is e.g. calculating ‘median’ values or using ‘median’ functionality.

If you really need to tackle huge pivot tables and analyze lots of data, then consider using the digidb’s special add-on. It offers all kind of added value which can be use to fill the gaps in the otherwise really wonderful Pivot Table feature. And yes: one of these features consist in the possibility of calculating Medians.

(0) Comments ·
17 October 2008 - 14:56

How to fill out blank cells in Pivot Table rows in Excel?

If you want to further analyse your Pivot Table generated data, then you might have come across this question I get generally asked by course participants:
How to fill down the blank cells in Pivot Table rows, as by default only the grouped field label is shown?

It’s a three step process basically: Selecting all non blank cells, typing a simple reference formula and propagating it in all non blank cells.
filling blank cells in pivot table rows

  1. So copy the pivot table to a different location first. Then select all cells you want to fill out, including the non blank cells, but starting with the first row label cell.
    The first trick is to get all non blank cells: Press F5 (goto) or ctrl + G. This open the Go to dialog, which has a special feature hidden under the ‘special’ button to select all the ‘blanks’.  That’s where to go first.
    Press OK to close the dialogs. The blank cells are now selected.
  2. Next step is entering the formula.  So double check that the first ‘active’ cell is the one just below your first row label (highlighted in white). Type “=” and press the ‘up’ arrow once.
    You now have a formula, which basically is just a reference, for this first cell.
  3. Last step is to hold down Ctrl and to hit enter.  This is a trick to copy the formula throughout all blank cells.

And that’s it.  From here you can do whatever you like.

(5) Comments ·
11 October 2008 - 09:24

Print Outlook mail messages without header

Most articles on printing Outlook mail items would generally deal with message headers not appearing, but since some time I was wondering how to actually remove the header when I really want to print a mail message.
I found this article on the office site: Hide or remove e-mail message headers. It explains it all !

message in developer view

Basically, you have to

  1. activate the developer ribbon
  2. edit the mail form (design form)
  3. go to the field's properties you want to de-activate or not see when you print (right click)
  4. on the validation tab, you can de-select the item when printing

This basically only works for the message only, so it's a hard way i'd say. If you want it to be permanent you'd need to find out where to re-publish the form, and I'm not sure you can overwrite the embedded forms used by the program. Before this was much more clear as in the latest versions apparently...
so anyone with a more robust solution ?

(1) Comments ·
06 October 2008 - 14:00

Remove Costs easily in MS Project

A question which came up during a course recently went as follows : how can we remove costs inputs from all views when sending a MS Project schedule to our clients?

Well basically by zeroing out all cost related fields as well as the cost fields in the Resource Sheet, was my first approach, and remains the best strategy I would think.

Following macro illustrating this path works well in both Project 2003 and 2007, with one side-effect however; so far I haven't been able to put my finger on it.
Where Fixed Costs have been used, zeroing out the main values seem to trigger off negative values in the Fixed Costs column. Zeroing these ones out then re-enters the equivalent postive amounts in the total costs column ....

Anyone to solve this puzzle?

Sub RemoveCosts()

'first reset/remove default setting for autocalculating cost values in MS Project
OptionsCalculation AutoCalcCosts:=False

'remove Resource related costs
ViewApply Name:="Resource Sheet"
TableApply Name:="&Cost"
TableApply Name:="&Entry"
SelectResourceField Row:=0, Column:="Standard Rate", Width:=2
SelectResourceField Row:=0, Column:="Standard Rate", Width:=2, Height:=16, Extend:=True
EditClear Contents:=True

'activate the cost table with all cost related fields
ViewApply Name:="Gantt Chart"
TableApply Name:="&Cost"

'remove the main cost related fields triggering off all other cost values
SelectTaskColumn Column:="Actual Cost"
SelectTaskField Row:=0, Column:="Actual Cost"
SelectTaskField Row:=0, Column:="Actual Cost", Height:=40, Extend:=True
EditClear Contents:=True
SelectTaskField Row:=0, Column:="Baseline Cost"
SelectTaskField Row:=0, Column:="Baseline Cost", Height:=40, Extend:=True
EditClear Contents:=True
SelectTaskField Row:=0, Column:="Cost", Width:=4
SelectTaskField Row:=0, Column:="Cost", Width:=4, Height:=40, Extend:=True
EditClear Contents:=True

'remove other calculated cost fields
SelectTaskField Row:=0, Column:="Cost Variance"
SelectTaskField Row:=0, Column:="Cost Variance", Height:=40, Extend:=True
SelectTaskField Row:=0, Column:="Remaining Cost"
SelectTaskField Row:=0, Column:="Remaining Cost", Height:=40, Extend:=True
EditClear Contents:=True

'comment this out if you don't want other baseline values to be removed
BaselineClear All:=True, From:=0

'reset MS project to auto calculate costs
OptionsCalculation AutoCalcCosts:=True

'remove fixed cost values as well or reset them to zero
SelectTaskField Row:=0, Column:="Fixed Cost"
SelectTaskField Row:=0, Column:="Fixed Cost", Height:=40, Extend:=True
EditClear Contents:=True

'reactivate basic view
ViewApply Name:="Gantt Chart"
TableApply Name:="&Entry"

End Sub



(0) Comments ·
01 October 2008 - 10:11

programming resources for Access




SQL Server

Some Books

(2) Comments ·
Page 1 of 1 pages