Floral Recipe Builder

This Google Sheets-based tool helps you build custom floral recipes for events of any size, including all required hard goods and mechanics for the full job scope. It automatically generates summary counts for product orders and pull lists, along with estimated costs to help calibrate your profitability. Scroll below to see sample screenshots.

The tool connects to a live inventory and price lookup file, which will be updated at least twice per year. Unlike other options that charge hundreds per month—or take a percentage of your invoice—this tool is a one-time cost and has proven effective, efficient, and reliable. It's now the only system we personally use for recipe building.

Special Launch Offer:
For the first two weeks, get the tool for half price — only $50 (regular price: $100). Price will be subject to increase as additional features are implemented.

Important:
You must purchase the tool using the same email address you intend to use for accessing the tool in Google Sheets. That email will be enrolled as an authorized user for the inventory/price lookup file.

---------------------------

License & Terms of Use:

This Google Sheets-based tool is licensed for use by the individual purchaser only. By purchasing and accessing this tool, you agree to the following terms:

• The purchaser/licensee may not share, distribute, or resell any copy or derivative version of this document with any third party without the express written permission of Amy Lauren Floral Design LLC.
• You are permitted to customize this tool for your personal business use. However, redistribution — including modified or adapted versions — is prohibited.
• Access to the live inventory and price lookup file is granted only to the registered purchaser’s Google account (i.e., the email used at time of purchase).
  • If you share the tool with an unregistered email account, the live pricing and inventory features will not function.
• This tool is provided as-is, with no guarantees of accuracy, performance, or compatibility. Amy Lauren Floral Design LLC is not liable for any loss, damages, or decisions resulting from its use.
• Support is limited to installation assistance and general troubleshooting. Updates to the live inventory and pricing file will be made at least twice per year through at least December 2026.

By completing your purchase, you acknowledge and accept these terms.
---------------------------

Overview/Instructions:

Across all tabs, you will only enter data into the blue cells. The tabs that have data entry options are also shaded blue. If you attempt to edit a cell that is not intended for user entry, you will receive a warning message. If you override the warning notice and change a protected cell, the tool may not continue to function as intended.

Generally, you will work left to right across tabs "Recipe Builder," Hard Good / Mechanics," and "Job Summary."

Recipe Builder: Header/Project Information

Before you begin creating recipes, populate the header level information (Job Name, Date, Location).

The number of "Unique Design Types" will auto-calculate based on how you populate the form. This exists to help you self-check your work.

The Job Date is a required field, as the available products and prices are sensitive to the season.

Recipe Builder: Design Type Information

For each "Design Type" (labeled 1 through 40) you will enter its name (such as "Large Centerpiece Head Table") and the total count required of that Design Type.

Just below, you will enter the associated Hard Goods and Mechanics with their Counts to support that Design Type. While optional, the tool will produce an inventory "Pull List" based on your inputs here.

If you would like to upload a design inspiration photo, click on the blue "Upload Image" cell, go to the main menu Insert, select Image, and "Insert Photo Over Cells." You will be prompted to identify the photo from your PC or online sources. Adjust/resize the photo and position it within the open area.

Recipe Builder: Product/Recipe Information

Now on to the flower design recipe building. Starting with "Product 1," click the drop-down selector to scroll or type to search for the desired Product.

Optionally, and if the color is not already specified in the Product name, you may manually type the required color. For multiple distinct colors of the same Product, use multiple Product lines and differentiate them by color.

For each Product, enter the stems required for one unit of that Design Type.

For some unique products, you will see that the units are not down to the stem despite the column label. You should be able to decipher what units you require, and can use fractional units (i.e. 0.3).

It's ok if you forget something or need to come back; all blue cells remain editable as a dynamic calculator as you go. You may even decide to build your recipes by the specific products you know will go into multiple Design Types first, before you go back and complete each Design Type with any ancillary products.

Once you've entered all products and stem counts, you can refer to the subtotals at bottom for the estimated costs at that Design Type level. You will see both the individual unit cost and subtotal for the full count of that Design Type.

Proceed on to Design Type 2, and continue through completion of all recipes.

If at any point you want to reset the form and start over, click the button in upper left of the sheet "Reset Form." Please allow 10 seconds for the reset script to run, and avoid making any changes while this runs.

Product Manual Adds

If you are unable to find a suitable product in the drop-down list, you may manually add up to 30 alternate products in the "Product Manual Adds" tab.

You must populate all five attributes (description, unit, price per unit, category, stems per unit), but then the product will appear among all the others in the drop-downs.

All of your manually added products will stay in that tab until you delete them.

Hard Good / Mechanics

This will give a simple summary of hard good and mechanic counts as a "pull list" in preparation for this job. For example, perhaps you own 20 large vases but the pull list indicates you need 40 for the job; you can quickly identify how many extra vases to procure or rent.

If you would like to include pricing for rental or sale of hard goods, you can add unit prices corresponding to each type in the blue column. The calculated costs will flow over to the next Job Summary tab.

Job Summary

This will provide your total product counts based on all the recipes. It will also calculate the number of units (rounding up to the nearest unit) and estimated cost for each product, with an estimated total product cost estimate.

The user should closely review this table and may override the Unit "Price Override" based on your local market, and the "Units Override" for each product, to enable some quick rebalancing before you place your orders.

For example, if you need 5.1 units (bunches), you may elect to order 5 rather than the prescribed/rounded 6.

To the right of the table, you may choose to enter your pricing multiple and client budget to further support the rebalancing of your recipes and unit counts. This is optional but potentially helpful.

Other Reference/Summary Tabs

As you build the recipes, you can refer to these three additional reference tabs; they may help you organize your approach to defining your design types and recipes.

Product Order: Provides a simple summary of counts by product to send to your supplier. If you have entered multiple suppliers, the table will be organized by supplier.

Hard Good / Mechanics Summary: Provides a simple summary of hard goods and mechanics per design type; intended to be shared with design team. For the inventory "Pull List" refer back to the prior Hard Good / Mechanics tab.

Design Recipe Summary: Provides a simple summary of stem counts per design type; intended to be shared with design team.

File Management:

You received a link to access your unique master copy of the online tool. As a best practice, you should retain your original copy of the tool unchanged, and just make a new copy for each instance you need to build.

To make a copy, go to File -> Make a Copy. Once the new copy loads, change the name to whatever best suits your needs. You can also make a copy of a completed jobs, to use as a template for a similar future job.

The master inventory/price list will be updated at least biannually, to account for changes in prices at a representative mid-size wholesaler.

Troubleshooting/Help:

Due to the complex tabulations, data validation, and security/protections, you may run into issues with the document that you cannot immediately resolve.

For assistance, please share your file with info@amylaurenfloraldesign.com and send an email explaining the issues.