Clean, Extract, and Summarise Messy Data in Excel
A spreadsheet can look tidy and still be wrong. Turn an awkward export or inherited worksheet into a refreshable.
Technician field notes
Make the useful method repeatable.
Turn real support patterns into bounded runbooks, scripts and decision guides that preserve context, protect customer data and explain what success actually means.
Start here
Choose the system you need.
Begin with the category that owns the evidence or outcome, then choose the most specific guide. Diagnose before changing and preserve a recovery path when the work can affect data or access.
7 guides
Business and Technician Tools
Use careful operational methods for the specialist tools and data tasks that support teams encounter in real work.
Back to the category mapEnterprise browser deployment and offline installer verification
An enterprise browser deployment has two products: the browser installed today and the update/policy process that keeps it trustworthy tomorrow.
Keep a Legacy Business Application Working Long Enough to Migrate It
A legacy application can still be essential even when its vendor, operating system, database or installer is no longer supported.
Markup vs Margin: Calculate a Selling Price Without Fooling Yourself
Markup and margin both describe gross profit, but they divide by different numbers. That is why a 25% markup does not produce a 25% margin.
Sage and Pastel update and runtime-error diagnosis
“Runtime error 91” or “Pastel update failed” is not enough to choose a fix. Diagnose a Sage/Pastel update or runtime error from the exact product.
SARS e@syFile Employer Troubleshooting With Backup-First Decisions
Protect employer records, identify whether the fault is installation, access, payroll import, reconciliation, online handoff, or submission status, and repair only the failed stage.
Technician scripting, file checks and repeatable automation
A script becomes operational automation when another person can predict its scope, interpret every outcome and run it again safely.
3 guides
Endpoint and RMM Operations
Keep device management, automation, monitoring and platform transitions accountable from enrolment through verified handover.
Back to the category mapEndpoint-management automation and custom attributes
Custom attributes can turn an endpoint platform into a useful operational database—or a pile of stale strings that trigger the wrong machines.
Migrate an RMM Platform Without Losing Devices, History, or Visibility
An RMM platform is a privileged control plane, not merely an asset list.
Repair or Reinstall a Broken RMM Patch Agent
“Agent offline” is a relationship failure between endpoint and platform. Determine whether an RMM patch agent is absent.
1 guide
Linux Operations
Diagnose Linux services, storage, networking, permissions and lifecycle from current state and distribution-appropriate evidence.
Back to the category mapLinux logs, timestamps and evidence searches
Build a reliable, privacy-conscious Linux incident timeline from bounded journal and file searches by recording the host, boot, clock, time zone.
1 guide
macOS Support
Work with Apple platform ownership, recovery and system controls without treating macOS as a Windows-shaped endpoint.
Back to the category mapmacOS update, startup and disk-recovery diagnosis
Safely distinguish a macOS update problem, login/startup-software problem, system-volume problem and likely hardware failure.
1 guide
Mobile Device Support
Protect data and account ownership while diagnosing mobile access, enrolment and recovery paths.
Back to the category mapMove and Clean Up Android Contacts Without Losing Ownership
The Contacts app is a view, not necessarily the address book. Find out which account or device actually owns each Android contact.
7 guides
Windows Operations
Diagnose Windows from effective configuration, logs and lifecycle state before applying repair commands or broad resets.
Back to the category mapFind a Missing Windows Printer and Diagnose Remote Printing
Locate the first missing or failing layer between an application and paper—physical printer.
Map Windows Disk, Driver, and Hardware Events to the Physical Device
Windows may report an error against Disk 3, \Device\Harddisk2\DR5, a volume GUID, a controller port or a PnP instance.
Open an Elevated Windows Terminal in the Folder You Actually Need
Open Windows Terminal or PowerShell with administrative rights in a known folder.
Windows Admin Consoles, Version Checks, and High-Value Shortcuts
Windows includes several administration interfaces because they answer different questions.
Windows event, crash and performance diagnosis
Windows can record thousands of warnings and errors on a healthy computer.
Windows services and application-installation diagnosis
A Windows service can be installed but stopped, running but unusable, or healthy while the application fails somewhere else.
WSL and cross-platform symbolic links
A link is small, but it crosses several boundaries: filesystem, path syntax, permissions and the program opening it.
Need a different system?
Search the complete guide library.
Browse every current guide or search by the symptom, platform or outcome you have in mind.
Browse every guide