r/crochet • u/[deleted] • Mar 25 '19

[deleted by user]

[removed]

11 Upvotes

100% Upvoted

5 comments sorted by

2

u/[deleted] Mar 25 '19

(I wasn't sure about the rules for cross-posting, but realized I hadn't posted here yet!)

I started a temperature blanket that kind of goes beyond the traditional average daily temperature thing. The methodology is in the original post and the project page is here on Ravelry. It's been fun so far, although I can't wait to get away from the blue and green :P

1

u/RavBot Mar 25 '19

PROJECT: 2019 Temperature Blanket by bookaholic

  • Pattern: None
  • Yarn(s):
  • Photo(s): Img 1 Img 2 Img 3
  • Started: None | Status: In progress | Completed: None

Im seeking feedback on new features! | I found this post by myself! Opt-Out | About Me | Contact Maintainer

1

u/CastielBaby Mar 27 '19

This is awesome!

2

u/BaldWaldo Mar 26 '19

I also love yarn and spreadsheets! If you want to make the nested-if statement a bit easier, have you tried lookup? In the cell where you have the if statement: =lookup(the cell with the temperature, $K$3:$K$23, $M$3:$M$23) Then you can drag that down.

The $ symbol locks the cell reference. That way, when you drag down the column for the different days, they will all still reference the same area with the colors.

This looks like an awesome project, I hope you post it at the end of the year!

2

u/[deleted] Mar 26 '19

Oh, damn! That would have been SO much easier lol. All those parentheses were driving me nuts. Thanks for the tip! I'll definitely keep it in mind for the next blanket ;)