![\"\"](\"https:\/\/i0.wp.com\/www.foxquestsystems.net\/foxblog\/wp-content\/uploads\/2020\/02\/EDS-Review-Bids-All-Activities.jpg?resize=840%2C118&ssl=1\")
<\/figure><\/div>\n\n\n\nFor this exercise, suppose the Scheduler is required to produce a report or layout identifying all the \u201cReview Bids\u201d activities for Bidding Review Team. The natural approach would be to create a filter as shown below:<\/p>\n\n\n\n
- Type: (All of the following)<\/li>
- Where Parameter: Activity Name<\/li>
- Is: contains<\/li>
- Value: Review Bids<\/li><\/ul>\n\n\n\n
![\"\"](\"https:\/\/i0.wp.com\/www.foxquestsystems.net\/foxblog\/wp-content\/uploads\/2020\/02\/EDS-Review-Bids-Filter.jpg?resize=626%2C369&ssl=1\")
<\/figure>\n\n\n\nHowever, when the Filter is activated, P6 returns the following results:<\/p>\n\n\n\n
![\"\"](\"https:\/\/i0.wp.com\/www.foxquestsystems.net\/foxblog\/wp-content\/uploads\/2020\/02\/EDS-Review-Bids-Filter-Results.jpg?resize=840%2C114&ssl=1\")
<\/figure><\/div>\n\n\n\nUnbeknownst to the Scheduler, only 4 out of the 6 activities appear. What happened? Activities EDS1020 and EDS1040 were excluded from the filter results. <\/p>\n\n\n\n
Unfortunately, a common and\nsimple typographical error placed double blank spaces between the words \u201cReview\u201d\nand \u201cBid\u201d. Not only is this error easy to make, but is nearly impossible to detect\nespecially when you\u2019re dealing with a CPM network consisting of thousands of\nactivities and where activity copy\/pasting is used extensively.<\/p>\n\n\n\n
In Z\u00fcmmer Analysis Report: “[02] Activity Names with Embedded Double Space<\/strong>“, shown below, not only lists all instances, but the \u2018Set Group\u2019 column even shows you where to look. The report also tracks the Count Per Set and the Activity Count for each Set Group. Additional information on this report includes the Original Duration, Remaining Duration, and Total Float.<\/p>\n\n\n\n
![\"\"](\"https:\/\/i0.wp.com\/www.foxquestsystems.net\/foxblog\/wp-content\/uploads\/2020\/02\/EDS-Review-Bids-Report-02-Results.jpg?resize=840%2C242&ssl=1\")
<\/figure><\/div>\n\n\n\nSince this is such an easy mistake to make, possibly resulting in erroneous reports, this issue must be checked and resolved by the Submitting or Reviewing Scheduler<\/strong>.<\/p>\n\n\n\n
Using Z\u00fcmmer concurrently with P6 helps identify and eliminate embedded double spaces.<\/p>\n\n\n\n
Embedded Double Spaces can be resolved using the following Steps:<\/strong><\/p>\n\n\n\n
- Open the CPM Network as shown below, with the P6 Filter set to \u201cAll Activities\u201d.<\/li><\/ol>\n\n\n\n
![\"\"](\"https:\/\/i0.wp.com\/www.foxquestsystems.net\/foxblog\/wp-content\/uploads\/2020\/02\/EDS-Review-Bids-Solution-Step-1.jpg?resize=840%2C129&ssl=1\")
<\/figure>\n\n\n\n2. Click on the first Activity Name cell so that the Select Marquee is shown around the Activity Name. If the Select Marquee is not highlighted around the Activity Name cell, the solution will not work.<\/p>\n\n\n\n
3. Press \u201cCTRL-R\u201d to activate P6\u2019s Replace Window as shown below:<\/p>\n\n\n\n
![\"\"](\"https:\/\/i0.wp.com\/www.foxquestsystems.net\/foxblog\/wp-content\/uploads\/2020\/02\/EDS-Review-Bids-Replace-Solution-Step-3.jpg?resize=353%2C188&ssl=1\")
<\/figure>\n\n\n\n4. In the \u201cFind what:\u201d textbox, enter 2 blank spaces. The 2 blank spaces will not show. The illustration above represents the 2 blank spaces with the gray rectangles.<\/p>\n\n\n\n
5. In the \u201cReplace with:\u201d textbox, enter 1 blank space. The single blank space entry will cause the blinking cursor to shift 1 space to the right.<\/p>\n\n\n\n
6. Finally, click \u201cReplace All\u201d. The \u201cReplace All\u201d option will scan through all Activity Names replacing every embedded double space with a single space. <\/p>\n\n\n\n
7. If an Activity Name contains multiple embedded double spaces, the Find\/Replace procedure will pause and redisplay the Replace window. Click \u201cReplace All\u201d to continue the process until all double spaces have been removed.<\/p>\n\n\n\n
At the completion of the scanning process, all embedded double spaces have been replace by a single space as shown below. The highlight bar stops at the last replaced Activity Name.<\/p>\n\n\n\n
![\"\"](\"https:\/\/i0.wp.com\/www.foxquestsystems.net\/foxblog\/wp-content\/uploads\/2020\/02\/EDS-Review-Bids-Solved.jpg?resize=840%2C126&ssl=1\")
<\/figure>\n\n\n\nCopyright\u00a92020 FoxQuest Systems, Inc. – All Rights Reserved<\/p>\n","protected":false},"excerpt":{"rendered":"
…the Filter Killer.<\/p>\n","protected":false},"author":2,"featured_media":1661,"comment_status":"open","ping_status":"open","sticky":false,"template":"","format":"standard","meta":{"nf_dc_page":"","om_disable_all_campaigns":false,"_jetpack_newsletter_access":"","_jetpack_dont_email_post_to_subs":false,"_jetpack_newsletter_tier_id":0,"_jetpack_memberships_contains_paywalled_content":false,"_jetpack_feature_clip_id":0,"_jetpack_memberships_contains_paid_content":false,"footnotes":"","jetpack_post_was_ever_published":false},"categories":[2,15],"tags":[],"class_list":["post-1645","post","type-post","status-publish","format-standard","has-post-thumbnail","hentry","category-analysis","category-how-to"],"jetpack_sharing_enabled":true,"jetpack_featured_media_url":"https:\/\/i0.wp.com\/www.foxquestsystems.net\/foxblog\/wp-content\/uploads\/2020\/02\/EDS-Review-Bids-Feature-Image2.jpg?fit=823%2C453&ssl=1","_links":{"self":[{"href":"https:\/\/www.foxquestsystems.net\/foxblog\/wp-json\/wp\/v2\/posts\/1645","targetHints":{"allow":["GET"]}}],"collection":[{"href":"https:\/\/www.foxquestsystems.net\/foxblog\/wp-json\/wp\/v2\/posts"}],"about":[{"href":"https:\/\/www.foxquestsystems.net\/foxblog\/wp-json\/wp\/v2\/types\/post"}],"author":[{"embeddable":true,"href":"https:\/\/www.foxquestsystems.net\/foxblog\/wp-json\/wp\/v2\/users\/2"}],"replies":[{"embeddable":true,"href":"https:\/\/www.foxquestsystems.net\/foxblog\/wp-json\/wp\/v2\/comments?post=1645"}],"version-history":[{"count":8,"href":"https:\/\/www.foxquestsystems.net\/foxblog\/wp-json\/wp\/v2\/posts\/1645\/revisions"}],"predecessor-version":[{"id":1662,"href":"https:\/\/www.foxquestsystems.net\/foxblog\/wp-json\/wp\/v2\/posts\/1645\/revisions\/1662"}],"wp:featuredmedia":[{"embeddable":true,"href":"https:\/\/www.foxquestsystems.net\/foxblog\/wp-json\/wp\/v2\/media\/1661"}],"wp:attachment":[{"href":"https:\/\/www.foxquestsystems.net\/foxblog\/wp-json\/wp\/v2\/media?parent=1645"}],"wp:term":[{"taxonomy":"category","embeddable":true,"href":"https:\/\/www.foxquestsystems.net\/foxblog\/wp-json\/wp\/v2\/categories?post=1645"},{"taxonomy":"post_tag","embeddable":true,"href":"https:\/\/www.foxquestsystems.net\/foxblog\/wp-json\/wp\/v2\/tags?post=1645"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}
- Open the CPM Network as shown below, with the P6 Filter set to \u201cAll Activities\u201d.<\/li><\/ol>\n\n\n\n