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!

[Syrinia]

I'd like to thank you for your time and effort with your guide and spreadsheet. I mainly use the customer data sheet as i'm not overly concerned with all the min/maxing (I just like to know where they're at and worth keeping to self) and noticed you have Javier at 0/0 for min/max orders per week. Very minor, but I'd say he's a daily buyer since i kept him to myself for quite some time mid game.

[Bad Kelcsi]

I see,I miss the Leo section. Thanks to point it out!

What type of mix do you pass to the dealers? It's random or
covers most liked effects or something else?

[MatasThor]

@Bad Kelcsi did you fully read it? I mentioned that I personally don't use Leo and keep those clients for myself, it's just a suggestion for those who want to sell the least themselves.

[Bad Kelcsi]

Based on the spreadseet Customer data some of the npc customer suggested dealer is yourself while the dealers info page suggests different customers to you. (eg.: Alison Knight) So which one is the optional one?
Grouping the customers by location, weakly spending and liked effects is not "better" in the long run?

[Robosium]

the ingredient data spreadhseets are wack, like cuke turning slippery into atlhetic if muchines is in the mix when it's still munchies turning into athletic but then slippery is turning into munchies

[Ink]

New <11hr playlog, ~16 Days and I've unlocked The Docks by becoming Enforcer I
https://docs.google.com/spreadsheets/d/1ipF8JrViiqAsgSqRTuJP1yi73yrO_YvVy_0ScCVQPLw/edit?gid=2107326145#gid=2107326145

No way to really leverage cash in my previous savefile at Huster III, I decided to 'buy xp' by doing those face to face sales. From what I've gathered in practice, you'd want to offer to the Night and Late Night callers before Noon, then any Morning or Afternoon callers after they didn't call in, that way the internal cooldown allows the >6pm callers to ring you for a deal so you sell to them at least twice. Morning/Noon can be sold to but has less margin in it.

[MVDU01]

You are crazy bro ! Thanks for this spredsheet !

[pavilionvolant]

this is awesome! so organized i love it

[MatasThor]

@[Linux] ivdok thanks for the tip.

[[Linux] ivdok]

@MatasThor Why don't you use ARABIC() function for tier calculator? It's supported by both Google Docs and Excel 2013+, and you don't have to maintain big-ass switch case, meaning if 100 ever gets breached you won't have to redo this part of spreadsheet.