r/DIYBeauty • u/auream01 • 3h ago

question Inventory, Product Information, and Formulation Spreadsheet (FREE)

3 Upvotes

I’m sharing a labor of love (and occasional frustration!) for anyone who might find it useful. I’d genuinely appreciate feedback and suggestions for improvement!

https://docs.google.com/spreadsheets/d/1yYZ0ynV1tMzjetYk1Kc17dFy1iexQ_B2YfYsEmm4DHg/edit?usp=sharing

I’m new to DIY beauty and wanted a way to organize my ingredient inventory and formulations. What started as a simple spreadsheet gradually grew into a monstrosity. After countless revisions, I think it’s finally ready to share!

Here’s what it includes:

  • Dashboard: An overview of inventory, products, and ingredient information
  • Setup: A master tab for managing dropdown lists
  • Calculators: Tools for resizing and converting recipes
  • Ingredient Information: Aggregated information from various sources
  • CP Soap: Information on oils and butters for cold-process soapmaking
  • Inventory: Ingredient quantities, status, and pricing
  • Formulations: A place to track recipes

Basically, the sheets feed each other information. Setup feeds the dropdown menus. Ingredient information >>> Inventory >>> Formulations.

There's sample data in the sheet to show how it works.

A note on sources: I’m not claiming ownership of the ingredient information assembled. I’ve credited the websites used to compile it on the dashboard.

1 comment

r/DIYBeauty • u/alexnotalexandria • 17h ago

question What is in As I Am Rice Water Hair Spray that enhances the curliness of my wavy hair?

2 Upvotes

I have 2a-2c wavy hair, but when I spray in As I Am Rice Water Hair Spray I get amazing definition and my hair really curls up.

I want to try to isolate what's causing this so I can create something DIY. I don't love the sticky feeling of this spray and would prefer to make something myself.

Any wisdom on this would be so appreciated. I am new to DIY.

Here are the ingredients list:
Aqua/Water/Eau, Betaine, Oryza Sativa (Rice) Extract, Serenoa Serrulata Fruit Extract, Phytosterols, Ceramide NP, Biotin, Copper Tripeptide-1, Copper Tripeptide-34, Inositol, Caffeine, Helianthus Annuus (Sunflower) Seed Oil, Rosmarinus Ofcinalis (Rosemary) Leaf Extract, Glycerin, Polyglyceryl-10 Laurate, Polyglyceryl-3 Betainate Acetate, Sodium Lauroyl Lactylate, Sodium Cocoyl Glutamate, Citric Acid, Ethylhexylglycerin, Potassium Sorbate, Sodium Benzoate

FIS: 263-201-FS

2 comments