How to: Harry Potter (or other fandom) glass pendants

Harry potter month

Occasionally, I like to pretend I’m a creative person, and I find something on Etsy (usually in somewhere far away like Canada!) and I think “I wonder if I could make that instead”.  That’s basically what started this project – I found a few I liked online, but none that were absolutely perfect, and I wanted to make my own!

They were surprisingly easy – after I found my images it took me less than twenty minutes to make all three – so I’m telling you how I did it in case you want to give it a go (you know you do!)


The finished pendants (bear in mind photos were taken before they were dry/I’d cleaned them up a bit, because I was too excited to share!)

You will need:

  • Glass cabochons
    (I used 19mm ones bought on ebay)
  • Images the same size as your cabochons
  • Bezels for your cabochons
  • Glue
    (I used glue from the jewellery section of a craft shop, but others report good results from standard PVA)
  • Paintbrush
  • Jump rings & pliars
    (may or may not be required depending on your bezel)


What to do:

Step 1: Find your images

This is the fun, but also tricky, bit! I had so many ideas, it took me a long time to pinpoint my first few images (and I can definitely see how this could be addictive!)

I chose to make mine in Photoshop, but you could also try using magazine images or (if you’re brave!) pages from an old book .

Cut them out to the same size and shape as your cabochons and you’re ready for step 2!


Step 2: Check your images & cabochons fit


Check your cut out image, and your cabochon, fit into your bezel well!  As you can see above, my bezel was a tiny bit too big (perhaps 20mm), but I naively thought I’d stick the cabochon central and you wouldn’t be able to tell…

See the Harry Potter quote at the top? I should have measured better!


Step 3: Stick it all together!

This bit is really really easy! Use your paintbrush to coat the inside of the bezel with a little bit of the glue, and stick your cut out image in.  Then coat the back of the cabochon with some more glue and stick it on top of the image!

You could stick the image to the glass first but I found it hard to get the glass centrally over the image and to make sure the image was at the right angle within the frame.


Step 4: Leave it to dry

I gave mine around 24 hours to be sure they were dry.  Any glue I’d managed to get in the wrong place came off easily with my finger nails, but if you’re struggling I suspect a little nail varnish remover and a cotton bud would do the job.


Step 5: Add a jump ring (optional), thread it on a chain & wear!

If your bezel doesn’t have one, add a jump ring to the top so that you can thread it onto a chain.

Thread it onto a chain (or cord, or choker, or whatever else suits your style).

Wear and show your fandom pride!

What do you think? Would you give these a go? And what shall I put on my next one?! (Though I have a few ideas…)

How to get your NetGalley Feedback to approval ratio up to 80% (or more)

When NetGalley added feedback to approval ratios to profiles, there were a lot of questions, and in my case at least, there was a moment of sheer terror.  Like a lot of bloggers, I went absolutely crazy with requests when I first signed up, and I also didn’t really pay attention to archive dates, so an awful amount of books I got approved for got archived before I got to downloading them.

My NetGalley ratio is nowhere near the recommended 80%, and I’m determined to increase it drastically this year. I know I’m not the only one whose approval ratio is lower than they’d like (though mine is pretty horrifically bad), so I thought I might as well do a post on HOW I’m planning to increase it in case it helps anyone else who wants to work on their ratio.

I’ll be using screen shots from NetGalley with made up numbers just for the sake of easy maths and explanations.

Step 1 – How bad is it, really?

There can’t be a plan for improvement until you know just how far you’ve got to go, so the first thing I did was take a deep breath and check my exact approval ratio.  For those of you who aren’t sure how to do this, log in to NetGalley, go to your dashboard and click the little arrow next to your picture.  Scroll down until you see this:

NetGalley screenshotThere’s three important bits here.

  • The most obvious is where it says ‘Yours is 25%’. On your profile, it’ll obviously have a different number, and this is your feedback to approval ratio right now.
  • The number of approvals (in the example screenshot it’s 200)
  • The number of pieces of feedback you’ve submitted (In the example it’s 50).

Okay, so now you know your current feedback to approval ratio, what’s next? (Hint, the answer is NOT get depressed about the fact you’ll never catch up and go on a requesting spree).

Step 2 – How far have you got to go?

Remember how I said the number of approvals and the amount of feedback you’ve submitted were important?  Here’s why:

You need to know how many reviews you have to submit to hit 80%!

Sure you could just keep reviewing until you get to 80%, but that’s not much of a plan!

This is where my favourite tool comes in: Excel! (you could of course use Google Docs or something similar, but I’m confident with Excel’s formula)

We’re going to use the first sheet of the workbook to:

  1. Find out how many books you need to review to get to 80% (and smaller milestones)
  2. Find out what each review is worth as a percentage

Here’s what my sheet looks like to do that:

netgalley excel1
You can see I’ve called Column A feedback, and underneath that I’ve put: the current number of approvals, 1, and 2.

I’ve called Column B approvals, and all three rows contain the number of books approved (200).

Column C is called % and I’ve put in a formula to tell us (exactly as it says) what each row is worth as a %.  The formula for row 2 is: =SUM((A2/B2%)) [just drag it down to lower rows].

This first section tells us that 50 books is 25% (as NetGalley currently says), but also what 1 book is worth as a percentage (a lowly half a percent) and that two books are worth 1%.

Next we want to work out how many books we need to review to get to 80%. To do that, I’ve filled column E with various percentage targets (make sure to include the % symbol for the formula to work), and to work out how many books I need to review to hit that milestone I’ve put a formula into F2.  The formula is =SUM(E2*200) [again just drag down as far as you need to].

So now we can see that a total of 160 books would need to be reviewed in order to get to a feedback to approval ratio of 80%.  Now how are we going to get there?!

Step 3 – What are those 200 approvals?

This is where it gets a bit tricky.  Who can remember what those 200 books are and which of those you’ve already read?  I haven’t figured out an easy way to figure that out yet I’m afraid!  Here’s how I’ve been doing it:

  1. Go to NetGalley, click the arrow next to your picture and select Activity
  2. Copy and paste the list of books under approved into a separate Excel sheet
  3. Click the drop down menu on the right hand side and go to archived
  4. Copy and paste the list of books that appear now into the same Excel sheet you just added the approved books to.

Now as far as I can tell, that should give you a complete list of all the books you’ve been approved for (it does for my account).  Here comes the time consuming bit: you need to figure out which of those you’ve read.  I literally just added a column next to the list, and put each book in one of the following categories

  • Read & reviewed
  • Read & Need to review
  • Unread, downloaded
  • Unread, archived but available at the library (Yes I literally went through and searched my library catalogue for these)
  • Unread, archived, no access

Step 4 – Is 80% the best goal?

If in the example above, the blogger had 100 books unread and archived, the most she could achieve would be 50%, so there’s not much point aiming desperately for a ratio of 80%!

To figure out your maximum possible ratio, add up all the books you have no access to, then go back and stick that number into A4 (where it used to say 2).  Then C4 will tell you what percentage those books are worth.  Take that away from 100 and you’ve got your maximum possible percentage.  If it’s below 80%, aim for whatever your maximum is.  If it’s above 80%, it’s up to you whether you want to go for your maximum or go for the recommended 80%.

Step 5 – How long will it take?

So now our example blogger knows she needs to write 160 reviews in order to hit 80%.  She’s already submitted 50, so that leaves her needing to write 110 more reviews to hit her goal.  But how long will that take?

This bit is of course completely up to you, your blogging schedule, and how often you want to write reviews!  To work out how long it’d take, divide the number of reviews you need by how many reviews you want to write a week.  Our example blogger could:

  • Write 1 review a week, which would take 110 weeks (~ 2 years)
  • Write 2 reviews a week, which would take 55 weeks (~ 1 year)
  • Write 3 reviews a week, which would take 37 weeks (~ 9 months)
  • Write 4 reviews a week, which would take 28 weeks (~ 7 months)
  • Write 5 reviews a week, which would take 22 weeks (~ 6 months)

Admittedly, she’s got a long way to go no matter how many reviews she manages a week, but there’s a huge difference between writing 1 review a week and 5 reviews a week.  Before you decide to go for loads of reviews a week though, you need to consider:

  1. Whether you really want to write that many reviews a week.  If you currently write one a fortnight, the step up to several a week may rapidly lead to blogger burn out!
  2. Will writing more reviews a week mean you have less time for things you currently love posting?
  3. How many of your requests have you actually read?  Go back to the list you made in Step 3 and see how many you’ve read but not reviewed.  If there’s only 5 on the list, you won’t be able to keep up a pace of five reviews a week for very long before you need to start reading again!

Step 6 – Get going!

I’m afraid there aren’t really any tips for this bit, it’s pretty much just sit down and write reviews!  It may be worth considering though whether you want to reduce your NetGalley usage, so your percentage isn’t going down further while you try and catch up.

For advice on writing reviews, being organised and scheduling your reviews, try a few of these great links:

Increasing your NetGalley Feeback to Approval ratio probably will be hard, I admit, but that doesn’t mean it’s not worth trying.  If your ratio is currently at 15%, think how great it’d feel to get to 50% or even 25%! (And if it means you’re more likely to get approved for that book you want, that’s a definite bonus!)

It may be slow, but watching that percentage go up, even a little is really satisfying!  Last year, my NetGalley ratio terrified me, so I pretty much avoided looking at it.  By forcing myself to face up to it, I’ve managed to get motivated, and increase my ratio by 8% since the start of 2014.

Is improving your NetGalley ratio one of your goals for 2014?  Do you have any helpful tips for reviewing or being organised?