Fabric accountability part 2
I wish I knew how to do a spreadsheet, ha! I just use a printed form I made that has "yardage in" " yardage out" "Precuts in" and "Precuts out" for each month. If scraps in add up to 1/8 yard I count that it that way. If smaller than 1/8 yard it's free fabric and not counted.( Or you could use 1/4 yard as your lower limit, whatever works for you. )
I keep a running total by month, in fact I will calculate January today. I keep this sheet where I can easily see it and update it.
When new fabric goes into the sewing room I immediately write it down. After cutting a piece of fabric is when I write it under "yardage out". When making a quilt using many tiny pieces of fabric this doesn't work so well but I try. If I cut up a FQ and use half, then I write 1/8 yard out. If I cut 30" of yardage that's what I write down - I'll probably cut 6" sometime later that month so these two cuts will equal one yard in my monthly total.
I was surprised at how much fabric i was stashing just buying random FQs and remnants...
Gemm, does this help?