- 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.
All your news. None of the bias.
Be the smartest person in the room by reading 1440! Dive into 1440, where 3.5 million readers find their daily, fact-based news fix. We navigate through 100+ sources to deliver a comprehensive roundup from every corner of the internet – politics, global events, business, and culture, all in a quick, 5-minute newsletter. It's completely free and devoid of bias or political influence, ensuring you get the facts straight.
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,