📌 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]

🧠 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.

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

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.

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.

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!

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.

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!

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!

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.

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.

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.

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.

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!

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

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.

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.

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.

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!