- Beyond Deadlines
- Posts
- We Got Jobs to Become a Manager, Progress and Comparing Two Sheets
We Got Jobs to Become a Manager, Progress and Comparing Two Sheets
Micah Piippo
September 24, 2024
In partnership with
Welcome back to Beyond Deadlines newsletter—a free perk for people looking to improve in Planning and Scheduling. Each week, we provide tactics, prompts, jobs and food for thought. We want you to succeed today, tomorrow and throughout the rest of your career.
What does our motivation depend on?
Mostly, on making consistent progress.
We can endure quite a bit of stress and frustration in the short term if we know it’s leading somewhere.
Identify your project's minimum acceptable productivity level—the point below which delays become inevitable.
This can be done in a variety of fashions.
Simple - comparing planned activity starts and finishes to actual activity starts and finishes.
Complex - Planned vs Actual quantity installs that include labor expended.
Start tracking this metric immediately. If productivity dips below this threshold, escalate the issue to keep the project on track.
Compare two different spreadsheets.
Act as an experienced Data Analyst proficient in Excel VBA scripting. Create a VBA script that compares a set of lines in one Excel workbook to another workbook, identifying any discrepancies between them.
The script should check for differences in specific columns and highlight any unmatched rows, based on a past example of a successful comparison script that flagged discrepancies for review.
Format the script with clear comments for each section and provide concise instructions on how to run it. Use a professional and instructional tone. Before you begin, ask me 3 questions to help improve your answer.
Company - Dragados
Location - Honolulu, Hawaii
Location - Turner
Location - North Central United States
Company - Mortenson
Location - Minneapolis, Minnesota
We have no connection to these jobs or companies. Our goal is simply to help you land the job of your dreams.
Looking for unbiased, fact-based news? Join 1440 today.
Upgrade your news intake with 1440! Dive into a daily newsletter trusted by millions for its comprehensive, 5-minute snapshot of the world's happenings. We navigate through over 100 sources to bring you fact-based news on politics, business, and culture—minus the bias and absolutely free.
This week’s episode we dive into metrics. Watch or Listen on Spotify, Apple Podcasts or Youtube.
Thank you for reading.
Check out Micah, Greg and Beyond Deadlines on LinkedIn.
Sign up for our LinkedIn newsletter.
Subscribe to our YouTube Channel.
Listen to the podcast on Spotify or Apple Podcasts. Visit our website.
Don’t ever hesitate to replay to this email if you are need of help!
See you next week,