If this is your first visit, be sure to check out the FAQ by clicking the link above. You may have to register before you can post: click the register link above to proceed. To start viewing messages, select the forum that you want to visit from the selection below. |
|
|
Thread Tools | Display Modes |
#1
|
|||
|
|||
EXCEL Formula
I just found out there is an Excel formula for Flynn backing. Would someone PLEASE send this to me. First time ever to use this.
|
Ads |
#2
|
|||
|
|||
EXCEL Formula
On Apr 21, 11:10*am, Gerry Neuroth Gerry.Neuroth.
wrote: I just found out there is an Excel formula for Flynn backing. Would someone PLEASE send this to me. *First time ever to use this. -- Gerry Neuroth http://www.eons.com/groups/topic/2209997-Quilt-Backs- |
#3
|
|||
|
|||
Thank You so much for an answer and now all I need to do is plug in my numbers on EXCEL. Think I will love this site. --
Gerry Neuroth[/i][/color] http://www.eons.com/groups/topic/2209997-Quilt-Backs-[/quote] |
#4
|
|||
|
|||
EXCEL Formula
I've just had a try with this, and the formula to put in your
spreadsheet runs: LF=(LQ)+LQ*(WQ-WF)/(2*WF)-WQ The brackets are in the wrong place in the website formula. Nel (GQ) |
#5
|
|||
|
|||
EXCEL Formula
That seems like a lot of work. For my own purposes, I'll just wing it!
Chop off a diagonal and shift the pieces and see what happens. I love an adventure! ;-) Leslie & The Furbabies in wet, stormy MO. "Sartorresartus" wrote in message ... I've just had a try with this, and the formula to put in your spreadsheet runs: LF=(LQ)+LQ*(WQ-WF)/(2*WF)-WQ The brackets are in the wrong place in the website formula. Nel (GQ) |
#6
|
|||
|
|||
EXCEL Formula
"Sartorresartus" wrote in message ... I've just had a try with this, and the formula to put in your spreadsheet runs: LF=(LQ)+LQ*(WQ-WF)/(2*WF)-WQ I am sorry. I am at a loss as to why a spreadsheet would be needed for that simple formula. I guess I don't understand why a formula is needed at all. I just make the front, measure it, then either cut or make (if the fabric I have isn't wide/long enough) a piece of backing that will fit the front. Though I usually plan out my block size so that the width I have is the width I need. Quilts were being made long before spreadsheets were even available. Brian Christiansen |
#7
|
|||
|
|||
EXCEL Formula
There is absolutely no need for anything if it is of no use to you.
But the question was asked, so an answer was given. The diagonal cut has some advantages, and can be used where fabric is a little short of that which would be needed if bought for the occasion. I have never used this myself, but I could see its use with those who make a great many. Also it can be useful to have a diagonal join instead of a vertical one if the fabric is too narrow to use in one piece. There are other ways of joining, according to preference, of course. Some like a central join, some like full with in the middle and a half width on each edge. It depends, as always, what and who and why. The spreadsheet is a bit of fun, otherwise, but could well be of assistance if a quilt is being designed to fit, most economically, a certain piece of fabric. Many calculations can be prepared and a decision made. Even a ready reckoner could be achieved and saved for future use. And, though the maths may be fairly simple, it might not be to all people. And why steam the brain when it can be done with a gadget? Why else would there be a calculator made specifically for quilters? Because then there is a choice. That is all; no higher purpose. And sometimes, life can be too short to spend time fathoming out something from first principles when someone else has ploughed the same furrow already. I spent altogether too much time working out, with pi, what diameter my finger was, last week. Yes, I'm sad that way... And, certainly, it is sometimes easy to make a design to fit the fabric, and other times the fabric needs to fit the design. TANQP. You are welcome to use whatever method you like. And it will be the right one. Nel (Gadget Queen) |
#8
|
|||
|
|||
EXCEL Formula
That's what I usually do too, Brian, but I once had a top that was
just a few inches too wide for the *perfect* backing. So this method worked great! Makes an almost-wide-enough piece usable, and the diagonal seam is far less obvious (unless your backing has stripes). Roberta in D On Fri, 22 Apr 2011 10:21:41 -0700, "Brian Christiansen" wrote: "Sartorresartus" wrote in message ... I've just had a try with this, and the formula to put in your spreadsheet runs: LF=(LQ)+LQ*(WQ-WF)/(2*WF)-WQ I am sorry. I am at a loss as to why a spreadsheet would be needed for that simple formula. I guess I don't understand why a formula is needed at all. I just make the front, measure it, then either cut or make (if the fabric I have isn't wide/long enough) a piece of backing that will fit the front. Though I usually plan out my block size so that the width I have is the width I need. Quilts were being made long before spreadsheets were even available. Brian Christiansen |
Thread Tools | |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Thread Starter | Forum | Replies | Last Post |
OT - sorting and Excel workbook | Karen, Queen of Squishies | Quilting | 10 | November 20th 08 05:10 PM |
OT - Excel question | Karen, Queen of Squishies | Quilting | 23 | April 29th 08 02:55 PM |
MS Excel file for John Flynn backing formula | hfw | Quilting | 1 | December 12th 04 01:12 PM |
OT - Directory - excel format | LN \(remove NOSPAM\) | Quilting | 0 | March 19th 04 12:38 PM |
Importing directory into Excel | AliceW | Quilting | 1 | July 31st 03 03:54 AM |