Make Your Reports Excellent!


Excel to the Horse Races

Excel to the Horse Races
A working demonstration of unit conversion between old and new methods.

In this case COMPARE same Horse in different TRACKS and CONDITIONS:
furlongs, meters, feet, yards!  (Screenshots and download links below).

Conversion Demonstration - furlongs, meters, yards, miles

BEST PRACTICE ALERT: TEST your default security
and SCAN BEFORE downloading ANY product with MACROs.
This can be handled by most modern anti-virus software (I use
Webroot) *AND* by setting your Excel, or Word Options | Trust settings to highest security.

Consumer bears full responsibility to scan for unexpected code errors, malware or viruses.

Excel macro worksheet (equus044b1.xlsm) (optional Active-X button and macro in first sheet to simplify default setting.)

Excel sheet ".xlsX" - no macro (button) (no local macro: ActiveX buttons only work in local tab: use a "form button" element to if you want to call a button handler from the local macro template in folder "XLStart")


Auto Metrics Chart Demo

Sample Chart Demo

auto progress chart
auto progress chart sample
The working, customizeable chart demonstrates "automatic metrics" - it gives you timely reporting with just a quick attachment or a screenshot from the current Test XLS Suite being executed.

click chart thumbnail at right for full screenshot. Download XLS from link[s] above. Downloading from Google will require (a) having and (b) signing in to a Google account.

The Sample Test Suite in left columns will automatically tabulate the
progress summmary and chart on the right. This is done without
pivot tables, to give more flexibility and less maintenance.The benefit is for both individuals AND teams to be able to report whenever asked yet with minimal interruption.


BUG: Outlook corrupts Textboxes

Summary:  Outlook replaces TEXTbox with Graphic on Send

Attachment: Outlook_bug.png

Traceability: MS-UI-190429  (Win 10 / Outlook ver 16.0.10325.20118)

      1. Lost time for sender and all recipients
      2. Breaks Requirement UI-CU-DB-190429 usability be usable  after sending/receiving
      3. Work around - time consuming and undocumented
  • Steps to reproduce:
    1. create and SEND an email in HTM format by Outlook containing a TextBox
      (Highlight TEXT then Alt-N-X-H or mouse "Tab: Insert | Textbox ")
    2. Receive the email: (or open from the SENT subfolder)
    3. Attempt to highlight, copy, paste the textbox CONTENTs to another application or file
  • Problem[s]:
    1. The object has been changed from TEXT to a NON-editable IMAGE
  • Frequency / Reproducibility:    100%
  • Workaround
    1. Forward or Reply to open Outlook's native EDITOR
    2. Right click on the broken Textbox graphic
    3. Choose "Format Autoshape"
    4. Click top right TAB "Alt Text"
    5. Copy / Recover the text: There may be a limit that truncates it.
  • Expected
    1. Behavior when opening Grid should throw no error,consistent with all other instances on this website.
    2. Data should not be lost, nor changed: Particularly Zip or Zip+4 should be accepted
    3. Any data loss or change should generate a useful error AND an error log entry

Batch: Kill Zombie Tasks

@echo off

rem TMstatus.bat set zombie vars to full or partial task name to test remove from Task Manager
Demonstrates (a) Timestamps (b) FOR parsing of delimited fields and (c) IF logical comparisons
Warning: Replace 'Zombie1' and 'Zombie2', currently set to kill CHROME and APPLEUPDATE

set zombie1=firef
set zombie2=SoftwareUpdate
set hasargument=no_argument
if not "%1"=="" set hasargument=%1

set xtime=%time::=%
set xtime=%xtime:.=_%
set xdate=%date: =_%
set xdate=%xdate:/=_%
rem set xdate=%xdate:~4%
set xtime=%xtime:~0,-3%
rem set timestamp=%xdate%_%xtime%
set timestamp=%xdate%
rem set newdir=_hold_%timestamp%
set outputfile=taskman%xdate%.log 

set randfile=delete%random%.txt
TASKLIST /NH /FI "IMAGENAME eq %zombie1%*"
TASKLIST /NH /FI "IMAGENAME eq %zombie2%*" 

TASKLIST /NH /FI "IMAGENAME eq %zombie1%*" >> %randfile%
TASKLIST /NH /FI "IMAGENAME eq %zombie2%*" >> %randfile% 

for /f "tokens=3" %%f in ('find /i /c "%zombie1%" %randfile%') do set whatcount1=%%f
for /f "tokens=3" %%g in ('find /i /c "%zombie2%" %randfile%') do set whatcount2=%%g
echo %timestamp% %0 count of %zombie1% is: %whatcount1%
echo %timestamp% %0 count of %zombie1% is: %whatcount2% 

echo %timestamp% %0 %hasargument% count of %zombie1% is: %whatcount1% >> %outputfile%
echo - %timestamp% %0 %hasargument% count of %zombie2% is: %whatcount2% >> %outputfile%
rem if %whatcount% GTE 2 TASKKILL /S system /U username /P password /FI "IMAGENAME eq note*"
if %whatcount1% GEQ 1 TASKKILL /FI "IMAGENAME eq %zombie1%*" >> %outputfile%
if %whatcount2% GEQ 1 TASKKILL /FI "IMAGENAME eq %zombie2%*" >> %outputfile% 

DEL %randfile%


if "%1"=="" echo end of %0
if "%1"=="" pause