Smart Crab
Dive Into Spreadsheets
Swim past setup and jump straight to the work. Smart Crab gives you dashboards, trackers, budgets, timelines, calculators, and much more that run in Excel and Google Sheets. Open a template and start filling in your data.
Hide
Track production jobs in one place with fields for customer names, products, quantities, progress, priority, dates, workstations, and operators. It also includes dropdowns for status and priority.
Use this contact list template to organize event contacts by type, company, name, role, phone number, email, service hours, website, address, and notes. It works well for tracking clients, vendors, partners, and other key people in one Excel workbook.
Not sure what you can afford. This Excel calculator balances your income and debts with mortgage terms and housing costs. Change the DTI cap, interest rate, or down payment and watch the payment breakdown update instantly. It is helpful for first-time buyers, investors, and planners.
This Balance Transfer Calculator template compares keeping your balance on your current card vs moving it to a new card. Enter APR, payment method, transfer fee, intro 0% months, and post-promo rate. The sheet shows interest, total paid, and months saved.
This PV to FV Calculator helps you convert present value into future value using a fixed growth rate and time period, then adjusts the result for inflation. It is useful for estimating future savings, investment growth, debt cost, and long-term financial targets.
The workbook opens with an assumptions block for launch month, starting cash, contingency, revenue growth, gross margin and tax rates. From there it totals one-time purchases and recurring operating costs, records your funding plan, and carries every figure into a 12-month cash flow.
This premade template helps you map out four different kinds of competitors: Leaders, Contenders, Niche, and High Performers. Use this template to compare your competitor’s products, market share, sales marketing strategies, prices, and growth projections to your own.
Use this Home Ownership Expense Calculator to map the full cost of running a house. Enter your mortgage details plus taxes, insurance, PMI, HOA, HVAC, and other maintenance. The template totals your ownership cost per payment period and shows an after-tax view based on mortgage interest rules.
Use this sales leads call tracking template to keep sales call data organized and never miss an opportunity. Record important call details, follow-up dates, and notes, and successfully convert leads into sales.
This Retirement Withdrawal Calculator helps you model retirement income by showing how withdrawals, inflation, and investment growth affect your balance over time. It includes a results table, a year-by-year payout schedule, and support for extra withdrawals in specific periods.
This weekly attendance template pulls staff from your list, applies your weekend rules, auto updates the weekly calendar, tracks leaves, and totals attendance days for you so you can easily manage weekly attendance.
The template is designed to schedule your employees to work 40 hours a week, compressed into 10-hour shifts in 4 days, not the typical 8-hour shifts in 5 days. It has calendar to manage multiple teams on alternate schedules with wage calculations.
Use this Gap Analysis Template to compare where you are vs. where you want to be. Identify gaps, define goals, and plan actions—all in a ready-to-edit Excel sheet made for teams, managers, and planners working toward performance or strategy goals.
This free Purchase Order template comes with four linked sheets: PO form, Vendor list, Ship-to addresses, and Item list. The lookup sheets help you fill out orders faster and more accurately by pulling data directly into the main PO sheet.
Before starting a project, use this CBA template to estimate ROI, compare scenarios, and make better financial decisions. Includes a structured layout for itemizing costs and gains, a 5-year projection, and visual summaries to evaluate if benefits truly outweigh the costs.
The template calculates loan payments based on amount, interest rate, term, frequency, and compounding. It breaks down each payment into principal and interest, shows total interest paid, handles rounding, and adjusts final payments.
An action plan helps break down goals into clear, manageable steps. This template assigns tasks, sets priorities, and tracks timelines to keep projects on course. It ensures team alignment by outlining responsibilities, resources, and potential risks for each step.
Plan 24/7 staffing with this Continental Shift Schedule template. Supports rotating 8-hour shifts (Day, Swing, Night) across 7-day work blocks. Includes team setup, real-time labor cost tracking, and auto-updating schedules via linked sheets.
Enhance your sales process with this easy-to-use sales call log template. Document inbound and outbound calls, and maintain a database of customers to stay organized in your sales efforts.
Everything sits on a single line-item table, so a claim is built by typing one row per cost. The reporting period and employee details sit at the top, the categories come from a configuration sheet, and the total expense adds up at the bottom.
This free wedding guest list template helps you track RSVPs, meal choices, seating, contact details, guest groups, costs, and thank-you notes in one template. It also includes visual charts for a quick planning overview.
log daily tasks by category, record activity details, track start and end times, and monitor status. It includes automatic duration calculation, a pie chart showing task progress, and a bar chart for time spent by category over a selected date range.
Use this free Annuity Calculator to model retirement income from a lump sum and test how long your money may last. The template calculates annual withdrawals, net payments, taxes, interest earned, remaining balance, and inflation-adjusted payout scenarios in Excel.
8-hour rotating Shift Schedule template helps you organize your workforce to take on 8-hour alternating day, swing, and night shifts to provide 24/7 business operations. It comes with team planning, wages, and hours calculation per team.
This template helps you organize job details, assign work, track labor and materials, calculate costs and tax, set priorities, and log updates. It provides a single place to manage work order tasks from start to completion.
This Excel workbook holds four linked worksheets: a configuration sheet, the main petty cash log, an expenses sheet and a cash-in sheet. Every transaction records the voucher number, purpose, recipient, date and approval status, and the remaining balance updates itself as entries are added.
Use this free Savings Snowball Calculator to apply the snowball method across savings and debt goals. Enter starting balances, goal amounts, interest rates, and minimum payments, and the sheet will calculate how your monthly savings move from one goal to the next over time.
This user-friendly, simple call log template is designed to simplify the tracking of calls for any business. Record essential call details effortlessly and achieve greater efficiency in your administrative procedures.
Use this attendance tracker to log daily status codes, track leave by type, flag heavy leave takers, get customized reports, and see charts by month, team, and employees or a single employee.
This workbook projects a full fiscal year month by month, from January through December. Revenue lines cover up to five products, three services and an other row, and cost of goods sold, operating expenses and additional expenses each carry their own grouped section.
