ULTIMATE SCHEDULE I SPREADSHEET

I don’t play Schedule I like most people.
I optimize. I min-max. I dig into the code.
After hours of dissecting game files, reverse-engineering mechanics, testing formulas, and reaching the endgame in multiple playthroughs also recently started my most efficient playthrough.
I bring you the ULTIMATE SCHEDULE I SPREADSHEET.

Whether you’re here to build an empire or just want to understand how the game really works, this sheet's got your back.

🔗 Link to the Spreadsheet

📌 Current Version: v1.6 — PRODUCTION & data expansion Update

⚠️ Don’t forget to make a copy to use it!
This version includes major improvements: new REPUTATION sheet, reorganized layout, Data tables, and more!

👉 Click here to open the ULTIMATE SCHEDULE I SPREADSHEET 📊[docs.google.com]

📊 Spreadsheet Content

🧠 INFO – Basic info about the spreadsheet, latest version, features, and navigation.

💸 SPENDING CALCULATOR – Automatically calculates Max Daily Spending for each customer based on your rank, tier, and customer data.

👤 CUSTOMER DATA – Detailed data for each customer: location, product preferences, spending habits, favorite drugs, and more.

💼 DEALER INFO – Overview of every dealer, with suggested customers, stats, and zones covered.

📈 REPUTATION – XP requirements, rank & tier unlocks, and what each level gets you.

⚗️ PRODUCTION INFO – Full explanation of the production from A to Z.

🧪 MIXING INFO – Explanation of mixing rules, mechanics, ingredient synergy, and how prices are calculated.

💎 BEST MIXES – The most profitable mixes for each drug.

💊 DRUG DATA – Full list of suppliers and all available drugs.

🌿 INGREDIENT DATA – Detailed data on each ingredient.

🎭 EFFECT DATA – All known effect data.

📘 DEFINITIONS – Simple explanations of all data terms and values used across the sheet.

📅 CHANGE LOG – Detailed version history, update notes, and known issues.

📊 DATA TABLES – All reference data used in formulas: Ranks, XP, Tiers, Relationship scaling, and more.

🖼️ IMAGES DATA – Stores all icons and images used across the spreadsheet.

🧠 INFO – Overview & Navigation

This is your home base. The INFO sheet gives a clean overview of the spreadsheet and links to every other tab for easy access. It also includes:

• 📌 Version number & update date
• 🔗 Clickable hyperlinks to each sheet
• 🛠️ What makes this spreadsheet special

💸 SPENDING CALCULATOR – Maximize Your Profits

The SPENDING CALCULATOR is the heart of your financial management. This sheet helps you calculate how much each customer can spend daily based on their rank, tier, and other vital data. The formula is simplified to make it easy to use, it calculates as if you have a Loyal relationship with each customer.

💡How to use?

Simply input your current Rank and Tier and the formula will do the rest.

👤 CUSTOMER DATA – Deep Dive into Your Clients

The CUSTOMER DATA sheet holds all the details you need to understand your clientele. From spending habits to product preferences, it's your ultimate tool for tailoring deals and optimizing your empire. Key fields include:

• 🧑‍💼 Mugshot & Name – Get a quick visual cue and the identity of your customers.
• 📍 Area – The customer's location, helping you understand market spread.
• ⚖️ Standards – Their preferences, ensuring you only sell what they like.
• 💊 Effect Preference & Product Affinity – See which drugs they enjoy most.
• 💵 Base Weekly Spend & Orders – Your income estimate per customer.
• 🗓️ Preferred Order Times & Days – Adjust your schedule accordingly.
• 🚨 Call Police Chance – Keep track of risks when dealing with high-risk clients.
• 🔄 Suggested Dealer & Late-Night Location – Plan your strategy for late-night deals.

💼 DEALER INFO – Best Suggested Customers

Dealers are NPCs you can assign customers to via the Dealer Management app.
They take 20% cut but save your precious deal slots while still giving you XP!

🧠 Optimize by:

• Giving low spenders to dealers
• Keeping high spenders for yourself
• Grouping customers by region

🧍‍♂️Each dealer’s customer list is based on:

• Their location
• Customer proximity
• Spending potential

📊 Full breakdown included in the spreadsheet!

📈 REPUTATION DATA – Know What You Unlock

The REPUTATION DATA sheet tracks your progression through ranks and tiers in Schedule I. As you rise, you'll unlock new features, perks, and expand your empire. This sheet shows you what to expect at every step of the way.

• 🧪 Ranks & Tiers – Displays all ranks from Street Rat to Kingpin with tier breakdowns.
• 🎯 Required XP – Know exactly how much XP you need to reach the next Tier.
• 📊 Total XP – Tracks cumulative XP to see how far you’ve come.
• 🛠️ Unlocks Overview – Lists what region, drugs, equipment and ingredients are unlocked at each stage.

⚗️ PRODUCTION INFO – Full Production Process from A to Z

Covers the entire production pipeline step-by-step, from sourcing to sales.

🚚 Start to Finish:

• Suppliers, meetups, debt system, deliveries
• Drug-specific production: Marijuana, Meth, Cocaine
• Ingredient gathering, mixing, and effect handling
• Managing products and selling for profit

📦 Everything you need to know to master and scale your production operation is explained in detail!

🧪MIXING INFO – How Mixing & Pricing Work

Breaks down the rules behind effect mixing and how final product prices are calculated.

🧪 Mixing Mechanics:
• Effects can be added, replaced, or overwritten based on ingredient rules
• Each drug has a default effect it tries to add if there’s space
• Maximum of 8 total effects per mix – extras are discarded

💸 Pricing Formula:
• Final price = Base Price × (1 + Total Effect Multiplier)
• Base Prices: Weed = $35, Meth = $70, Cocaine = $150
• Each effect adds a % bonus – choose wisely for maximum profit

📊 Full explanation with examples included in the spreadsheet!

💎BEST MIXES – Most Profitable Mixes

The BEST MIXES sheet helps you identify the most profitable combinations for each drug. It’s a guide to maximizing profits by mixing ingredients efficiently. Key fields include:

• 💊 Drug – The base drug of your mix.
• 🧪 Ingredients (1-8) – The various substances used in the mix.
• 💰 Ingredient Cost – The cost of the ingredients you’ve used.
• 💵 Suggested Price – The suggested selling price for your mix.
• 📈 Profit – How much money you’ll make per batch.
• 🔢 Price Multiplier – A percentage increase based on the effects in the mix.
• 🚬 Addictiveness – How addictive the mix is.
• 🎭 Effects – The effects that the mix will have on your customers.
• 🔗 Mix Seed – A link to view the full breakdown of the mix and effects.

💊 DRUG DATA – Supplier & Drug Information

The DRUG DATA sheet provides crucial information about each supplier and their product offerings. Key fields include:

• 🖼️ Mugshot – A visual cue for the supplier.
• 🏙️ Name – The name of the supplier.
• 🌍 Region – The geographical area where the supplier operates.
• 📞 Connected Contact – The supplier’s primary contacts.
• 🛍️ Products – The drugs or substances the supplier offers.
• 📍 Stash Location – The location where the supplier stores their products.

Also, it holds essential details about each drug you can sell. Key fields include:

• 🖼️ Icon – An image representing the seed.
• 🏷️ Name – The name of the seed.
• 💵 Price – The price of the seed.
• 🎯 Type – The category of the drug.
• 🏅 Rank Requirement – The rank needed to access the drug.
• 🖼️ Icon – An image representing the drug.
• 💲 Suggested Price – The suggested retail price for the drug.
• 💀 Addictiveness – The level of addiction the drug causes.
• 🎭 Base Effect – The base effect the drug will have on customers.

🌿INGREDIENT DATA – Ingredient Information

The INGREDIENT DATA sheet contains key information about the ingredients used in mixing. Each ingredient has its own unique properties that affect the final product’s characteristics. Key fields include:

• 🖼️ Image – A visual representation of the ingredient.
• 🏷️ Name – The name of the ingredient.
• 💵 Price – The cost of the ingredient.
• 🎯 Reputation Requirement – The reputation level required to access the ingredient.
• 📜 Description – A brief description of the ingredient.
• 🎭 Base Effect – The primary effect the ingredient brings to the mix.
• 🔄 Effect Replacements – Any potential effects this ingredient can replace in a mix.

🎭EFFECT DATA – Effect Information

The EFFECT DATA sheet provides detailed information on various effects that can be applied to drugs. Each effect alters the properties of the mix and influences customer behavior. Key fields include:

• 🏷️ Name – The name of the effect.
• 🆔 Effect ID – A unique identifier for each effect.
• 🔢 Tier – The tier level of the effect (1 to 5).
• 💥 Addictiveness – The addictiveness factor of the effect.
• 💵 Price Multiplier – The price increase associated with the effect.
• 📜 Description – A brief description of the effect and its impact.
• 🎭 Effects – Actual effects.

📘 DEFINITIONS – What Does It All Mean?

The DEFINITIONS sheet is your glossary for the entire spreadsheet. If you’re unsure what a value represents, how a mechanic works, or what a stat actually affects—this is the place to check.

• 🔍 Clear Explanations – Definitions for all values used across the sheet (e.g., Dependence, Order Time, Call Police Chance).
• ⚙️ Calculation Notes – Insight into how values are calculated or where they come from in the game files.

No more guessing—know your numbers and master the game mechanics!

📅 CHANGE LOG

I'm working on this Spreadsheet in my free time and will update it regularly.
Here you can see when the latest patch was and what changed.

There was so much new stuff, so I had to split it into 2 separate updates.

🆕 Version 1.5 – OPTIMIZATION & Organization (April 29, 2025)
• Added IMAGES DATA sheet to store all used images in one place
• Added a script to automatically color Effects based on their official color codes
• Updated column structure and headers across all major sheets for better readability
• Updated internal consistency in naming and formatting
• Updated formula integration and data relationships across sheets
• All images are now pulled dynamically from the IMAGES DATA sheet
• Changed sheet layout into clear categories: INFO (explanations) and DATA (raw data)
• Other minor fixes to typos, cell alignment, and internal references

🆕 Version 1.6 – PRODUCTION & Data Expansion (April 29, 2025)
• Added PRODUCTION INFO sheet with full explanation of how production works
• Added MIXING INFO sheet covering rules of mixing, how effects interact, and pricing logic
• Added BEST MIXES sheet listing the most profitable mixes per drug
• Added DRUG DATA sheet with complete data about each supplier and drug
• Added INGREDIENT DATA sheet with complete data about ingredients
• Added EFFECT DATA sheet with complete data about effects

📊 DATA TABLES – All the Lookup Magic

The DATA TABLES sheet stores all backend values used in formulas across the spreadsheet. These tables are your reference point for game logic and balance.

• 📈 Ranks & Tiers – All rank names with corresponding XP thresholds and multipliers.
• ⬆️ XP Amount – List with all activities and XP gains in the game.
• 🤝 Relationship – List with all relationship stages.

🖼️ IMAGES DATA – Image Information

The IMAGES DATA sheet stores all images used throughout the spreadsheet, providing visual references. Key fields include:

• 🖼️ Image – The image preview.
• 🏷️ Name – The name or identifier of the image.
• 🗂️ Category – The main category the image belongs to.
• 📁 Sub Category – Further categorization, if applicable.
• 🔗 Link – A link to the source or location of the image.

🎯 WRAPPING IT UP

Thanks for checking out the ULTIMATE SCHEDULE I SPREADSHEET!

👤 Whether you're a casual player, an aspiring kingpin, or a min-maxing maniac like me, this tool was made to help you dominate your empire with knowledge and efficiency.

💬 If you have suggestions, bugs to report, or ideas for improvement—drop a comment below or message me directly.
I actively update this guide and the spreadsheet based on feedback and game patches.

🧪 Stay smart, stay efficient, and may your empire always stay one step ahead of the cops.

🎁 Support the Guide

I made this spreadsheet as a passion project for fellow nerds who love min-maxing the hell out of their games. From decoding customer behaviors to unraveling systems, this took a lot of time, testing, and a slightly worrying number of hours in Google Sheets 😅

If this guide helped you build a better empire:
👍 Rate it to boost visibility
⭐ Favorite it to keep it handy
🏆 And hey, if you’re feeling generous... a Steam Award would absolutely make my day!

[Bloom]

Your work on this spreadsheet is being put to good use. Thanks for making this excellent tool.

[SPARTA]

wtf

[MatasThor]

@Batza thanks for the note.

[Batza]

That's a great spreadsheet, just a note - the customer money caps at Kingpin 66 for some reason, so any level above that they'll still have the same money amount.

[MatasThor]

@Ink damn, I applaud your commitment but with this min-max'ing it feels more like a google sheets simulator then drug selling :D But if I ever try a speed run, there are a couple of tips I can use for sure.

[Ink]

here are my receipts, a surprise for me looking back was on day 8 when I ran out of the casino doors another jackpot triggered (twice, as four levers pulled, on the second jackpot win also had another jackpot next to it.. lucky me).
https://docs.google.com/spreadsheets/d/1ipF8JrViiqAsgSqRTuJP1yi73yrO_YvVy_0ScCVQPLw/edit?gid=1817303125#gid=1817303125

perhaps if someone wanted to rush it more, switch to a big bungalo setup on day 8, and hustler 3 is when you can trigger Dead or Alives remotely and farm xp to unlock bigger purses.

I didn't setup a botanist farm because there's a duplication glitch done by NPCs when attempting to fill a stack of items greater than 10, I reported it (15th) in the bug reports section but there's been two other people who asked about it since on steamforums/reddit.

[Ink]

I've replayed again, by Day 6 I was at 7K cash, then Day 7-Day 14 I've gone to the casino to hit on slots twice (+ ~15K daily,+ ~5~7K,+11K (downtown unlocked) from nightly deliveries), so when I start Day 15 (Hustler4) ($86.9K cash /51.4K credit) I'll already have a 5worker 3mix setup at the bungalo, laundromat/postoffice/tacoticklers(purchasing) all laundering money to get the warehouse with whatever setup by Day 19. I thought about getting the barn for that daily harvest XP after that described in another guide.

perhaps a 8mix warehouse product may or may not outscale the customers or casino soon.
Thought I'd let you know how I've supercharged my earning potential so far.

[MatasThor]

@Ink Yes, dealers do sell for your listed price when you're not listing it, but they don't negotiate, meaning they sell what customers offer (other lower than suggested price, especially in the early game). Just set your price at x1.6 of the suggested price, and you're good.

[Ink]

when a $259 item was marketed at $320, 22/24 also showed up (like at 167 marked up to 211), they have the cash but just refuse to pay the markup of ~40% vs 26%.

[Ink]

had some free time to use a dealer, still came up short
https://imgur.com/a/pqhnXww

I saw a yt video claim dealers sell for your listed price, when you're not listing it, and it was sorta true if price was low enough but for me, it doesn't appear to be worth using yet.