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).
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 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")
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.
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
setlocal set zombie1=firef set zombie2=SoftwareUpdate set hasargument=no_argument if not "%1"=="" set hasargument=%1 :maketimestamp
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
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%
ECHO FOR MORE DETAILS try command line: TASKLIST /M /FI "IMAGENAME eq SubSys*"