My collection of things.

jKafer on the Net

September 5th, 2017 at 2:27 pm

New Favorite thing in Excel – Frequency

I love it when I can learn a new thing in software program.

I have had to do this function many times before, however, I have never run across this option:  “Frequency”.

A B C D
1 Purchased   Colors
2 Green   Green
3 Yellow    
4 Green    
5 Red    

 

=frequency(B2:B10,D2) Results = 2

Counts how many times in B2 thru B10 that match what is in D2 – Awesome.

so, let’s add a little bit to this (I love things that do multiple things at one time (multi-tasking!) )


IF… you wanted to know how many unique items are in a column:

=SUM( — (FREQUENCY(B2:B5,B2:B5)>0))

—   =  Double-unary: A single unary operator (-) coerces true/false values into -1/0. By using the double unary operaor, we coerce the values again to 1/0.

This can be used in place of the countif statement for large sets of data.

comments Comments (0)    -
September 4th, 2017 at 3:02 pm

Snowy Day Quilt II

Well last weekend we were on a day trip up north and on the way back it was early enough that I got to stop at a couple of small quilt shops.  It was awesome.  One shop had lots of finished quilts that are so fun to look at and see how they look done (not at my house, that’s what makes it so fun).  There were not many kits or samples at that shop, but I still love stopping there – lots of Up North Feel to it.

Then the second shop – they always have lots of kits available. Which are my weakness.  I swear, every single project they have on their walls screams out to me to take home and make. But I had to refrain, because I know how much is already here to do.

3 yard bundles from LQS – best thing ever in my book

I got all the way to the back of the store and I broke. They had 2 quilts up on the wall as samples of a 3 yard and a 5 yard quilt. And quess what – they had fabric bundles …. ready to go …  How the devil and I supposed to pass those up.  I picked up three of them.

Once I got them home I just knew that I had to make another Snowy Day Quilt with the bright purple & green pack. With a little white added, ok a lot of white it seems, it came together so cutely.

 

I so love the colors, it would have taken me a month to put together these fabrics for this quilt. It it just perfect.

But it was pretty close.  I have a small, small piece of green left (I even had to piece together 2 sqaures to complete one of these large ones of the green), and when I was sewing the little bit of sashing around the outside, I ran out of bobbin – 32″ from the end, and this is what I ended up with for top thread…  I don’t think there is 24″ left from here to the needle.  Good grief for cutting it close.

So because I had some extra fabric I decided to use on of the blocks (that I didn’t use in the original pattern) to make a small kid size throw blanket.  I can’t wait to get this one done, it so darn cute.

Tags: ,
comments Comments (0)    -
August 6th, 2017 at 5:20 pm

SnowDay Quilt – All put together?

in: Quilting

So got all the blocks made – falling deeper and deeper in love with this project every moment!!!

During the week, I was able to get them all ‘sashed‘ together and a border around the whole thing – love, love, love it!

Then it happened … I made the mistake of asking my hubby what he thought of it.

He said : “It’s kinds short isn’t it?”  – he’s 6’2″ I’m not!

So off I went to add another row. It took me longer to design/choose 3 new blocks, make them, take apart the end and attach the new row than it did to make all 9 blocks last week. Not quilted yet, but I have the perfect backing material and I love how this top turned out.

 

And the best thing is that I already have a coordinating fabric (that I love as much as this top) for the back of this quilt. Maybe, this will be the first one I actually finish all the way – my hubby sure hopes so, the fabulous quilt rack he made me is still hanging on the wall empty.

Tags:
comments Comments (0)    -
August 2nd, 2017 at 8:32 pm

Fly by Month

in: Quilting

I can’t believe that July
Flew by with the blink of my eye!  

I started a bunch of projects this past month, finished a couple, yes only a couple.

I made T-Shirts for family that we unexpectedly doing a project together – I can’t share them yet, because not everyone has gotten there’s yet. But they are hilarious!

But today, I was working in the craft room, feeling not very accomplished and I looked down and my heart was immediately warmed by this, simple sight…

the joy a simple garbage can can bring someone.

Seeing this made me feel accomplished – a garbage full of trimmings – AWESOME! 

Wait ’til you see what was being trimmed. I don’t know which I like more the front or the back – it’s a toss up for totally different reasons!!!

 

 

comments Comments (0)    -
July 29th, 2017 at 6:48 pm

SnowyDay Quilt – NQC Quilt Block Challenge

in: Quilting

So joined a new group on facebook – NQC Quilt Block Challenge and they had run a Snow Day Quilt Block challenge this winter. I fell deeply in love with the pattern they had so I set out to find fabric.

Well as things usually go, I ordered, I shopped, I reordered, I shopped other places…only to come across a bag of fabric that I had purchased some time ago for another BOM that I was in and never did. Good Grief Charlie Brown!!!

It was the perfect fabric and there was more than enough to do this challenge quilt.  So, I started cutting.

The pattern called for 3 fabrics plus background, the fabric stash I found had 4 colors and the background fabric in there had a lot of black so I decided to take this opportunity to step outside my comfort zone and use black for my background.

So, with everything laid out, I started to put my first block together. What I didn’t realize is that these blocks are 16″ – wow, now I know why I needed so much fabric.

Got my first block done and I just sat and stared at it.  REALLY!!! Usually this happens farther into the project, when I’m in Zombie mode. Not this one, first block and of course it’s in the middle of this 16″ block.  The 2 gray pieces  didn’t come together very well at the corner, but the bigger problem is that one of them is backside out. 

For the love of Pete, George and Ringo!!!  At least I caught it before the whole things was put together – which is when I usually do find them.

So I am calling it quilts – no sense in pushing the line tonight!

Tags:
comments Comments (0)    -
June 29th, 2017 at 2:57 pm

Painting on barnwood

So I have a crush on Barn Wood projects so I decided to try one for myself.

This is a project not for the faint of heart or for someone without patience!!

I spent 4 hours cleaning the barn wood, because true barn wood has worked all it’s life. It came covered in ants, a bit soft and for sure grungy.  Soaked it, scrubbed it – wait until dry and repeat.   I did a couple pieces at a time, but still, a putzy part of this project for sure.

I cut a vinyl stencil to do this, but this wood is by no means smooth. And when you are a perfectionist that can really drive you crazy. So the closer you look the choppier it is, but from a distance it’s pretty cool.

 

 

Tags: , ,
comments Comments (0)    -
June 26th, 2017 at 5:47 pm

HST Arrows – another pinterest project

So I snuck in some sewing time this past few weeks. I had to break it up but, this is such an easy pattern it could be done in one day or weekend for sure.

I am a “American Pickers” addict, it’s so romantic to go into those places and come out with ‘good stuff’ – the only thing better is ‘Flea Market Flip’ – we usually give our design ideas first then critique what the contestants did and then sit in awe at the prices they get for those thing – how romantic is that!!!!!

Anyway, I learned a term on Pickers lately – “Completest”

completest:  having all necessary parts, elements, or steps – in quilting terms: this is where you are obsessed and have to have the whole line of fabric – even if you don’t have any idea or plan for it.  I have come to realize that I am a completest! and to complicate it even worse, I am a purest. I cannot take a pattern and change even the colors – or I cannot image a pattern in a different color set.   I am not a doodler in the terms that I can sit and sketch things, I sketch words or phrases – not images.

So, any way, back to my mini project: I found this on Pinterest and total fell in love with it.

I had to find the exact fabric it was made in and this time it wasn’t out of production (you can’t imagine how many times that happens. Order it. There is no pattern exactly, she just tells you what you need for squares, then triangles then you put it together. But I had some alone time this weekend and I was able to get it put together. I am putting this on the top of my UFO pile to be quilted/finished – that pile is getting very tall, by the way.

Her directions are here, in her instagram account: https://www.instagram.com/p/BQnh3RfBp2B/

Here is mine and I LOVE LOVE LOVE IT.

 

comments Comments (0)    -
May 12th, 2017 at 5:07 pm

I have been on a wood/paint kick lately…so I just kept going

We have our last fundraising event for the Avon 39 walk to End Breast Cancer, so i said I would make a couple (??) more signs for them to raffle off.  Lots of sweaty palms getting these ready, but lots of fun too.

12″ x 12″ oak plywood

12″ x 18″ pine plywood, Pledge of Allegiance

 

12″ x 36″, pine plywood – this is huge

Because I am frugal (aka cheap!) I hate throwing away part 1/2 of the vinyl when I do one of these projects. So …. I decided to do a ying/yang version:

These are 12″ x 24″ inches, oak plywood signs. It was a little more work, but I hate throwing usable stuff away – said the scrapbook/craft hoarder!!!! I did these two signs a little different. I did not stain the boards before I painted them.

I stained them after…

It’s sort of hard to see in this picture, but by staining with a dark stain after painting, it aged these really well. I love how they turned out.

comments Comments (0)    -
April 23rd, 2017 at 6:10 pm

Barn Quilt – Installed

Lovin’ it even more now…

Tags: , ,
comments Comments (0)    -
April 19th, 2017 at 11:43 am

Access/VB do not print report with no data

Just a little bit of programming..after all it pays the bills.

I had setup the option to print different reports, depending on if something is manufactured in house or outsourced.  So I came up with this:

The code behind the button on the form:


Private Sub cmdPrintReport_click()

    On Error GoTo CatchErrNo

     
    If Me.JobNo > “” Then DoCmd.OpenReport “rptWorkOrder”, acViewPreview, , “JobNo = ” & Me.JobNo

 

CatchErrNo:

    If Err.Number > 0 Then
        ‘report will not open if there is no data, but throws an error. This will catch that error and print the workorder instead
        ‘jk – 4/18/2017
        If Err.Number = 2501 Then
            If Me.JobNo > “” Then DoCmd.OpenReport “rptPickList”, acViewPreview, , “JobNo = ” & Me.JobNo
        Else
            MsgBox Err.Number & ” – ” & Err.Description
        End If
    End If

End Sub


In the report design mode, you have to tell it what to do with no data (I never knew this was here)

Report – Event – On No Data


Private Sub Report_NoData(Cancel As Integer)
   Cancel = True
End Sub


Are there other ways to do this, yes, probably 100, but this is what works in the environment that I’m working in.

comments Comments (0)    -

  • Count per Day

    • 11Visitors today:
    • 29Visitors per day:
    • 0Visitors currently online:
  • ScrapBook Software - MyMemoriesSuite
  • Latest Pins on Pinterest

    • Virginia star quilt block

    • Jelly Roll Pattern IKAT feat. FRAGILE by Zen Chic

    • This is the Sweetest Seahorse quilt! <3

    • Warm/Cool Quilt along quilt from "Don't Call Me Betsy". Gorgeous stained glass shot!

    • ~ Sawtooth star block with half square triangle corners with the economy square for the alternate block...will have to come up with pattern????

    • How to bind a quilt using the sewing machine. Very good tutorial.

    • Learn to create and apply four styles of binding from one template. This acrylic color-coded template is easily marked to sew traditional, flange, mock piping and reversible binding without needing to measure. Simply align fabric and cut - Creative Quilt Bindings Template - Stress-free binding - Sewing With Nancy - Nancy's Notions

    • How to Bind a Quilt- The part I have to force myself to do sometimes years after the rest of it is finished

    • How to bind a quilt by machine tutorial