Challenge Corner discussion

Glad you're having fun!

No, just the beginning and end of the table. It automatically does anything between them.

C.P. wrote: "No, just the beginning and end of the table. It automatically does anything between them."

I can't seem to make it work :/ . The table still looks weird :(

Now worries. I can look at it tonight or tomorrow and see if I can adjust it for you.

C.P. wrote: "Now worries. I can look at it tonight or tomorrow and see if I can adjust it for you."

Thank you so much!

Salha wrote: "C.P. wrote: "Now worries. I can look at it tonight or tomorrow and see if I can adjust it for you."

Thank you so much!"

___Name______|__Points____|___Buddy___|__Pages___|__Total___
_____________|____________|___Read____|___Read___|__Points__

Jamie_______|____________|___________|__________|________
Salha_______|____________|___________|__________|________
Kelli_______|____________|___________|__________|________
CharleyGirl_|____________|___________|__________|________
Lexi________|____________|___________|__________|________
Maddison____|______1_____|___________|____409___|__3.05__

Team__________|_____1____|___________|___409___|__3.05__

Does this help you?

Alaina wrote: "Salha wrote: "C.P. wrote: "Now worries. I can look at it tonight or tomorrow and see if I can adjust it for you."

Thank you so much!"

___Name______|__Points____|___Buddy___|__Pages___|__Total___
..."

Should I just copy and paste it?

Tried the copy and paste, but it didn't work :(

Alaina, your scoring templates look perfect in the September Challenge threads, how did you do it?

_____Name__|___Books___|___Buddy___|___Pages___|___Total___
___________|___Read___ |___Reads___|___Read___ |__Points___

Jamie___________|__________|__________|__________|__________
Salha__________ |__________|__________|__________|__________
Kelli___________|__________|__________|__________|__________
CharleyGirl_____|__________|__________|__________|__________
Lexi____________|__________|__________|__________|__________
Maddison________|____1_____|__________|____409___|___3.05___

Total___________|____1_____|__________|____409___|___3.05___

Here is how I adjusted it. Pretty much the same. Just include that pre html code in either mine or Alaina's and it should be good.

Salha wrote: "Alaina wrote: "Salha wrote: "C.P. wrote: "Now worries. I can look at it tonight or tomorrow and see if I can adjust it for you."

Thank you so much!"

___Name______|__Points____|___Buddy___|__Pages..."

Yeah, I think that will work. Just a heads up, I use a word document plus Excel. So I use Excel for calculating all the points so I don't have to use a calculator but I add all the numbers to a word document with the score template already pasted there. It helps you figure out how it should look when you copy and past it into the review thread.

I hope that helps you out. It has worked for me this month.

Salha wrote: "Tried the copy and paste, but it didn't work :(

Alaina, your scoring templates look perfect in the September Challenge threads, how did you do it?"

Yeah you have to add the <.pre> and the <./pre> to it.

So put the <.pre> with the lines before Name. and the <./pre> with the lines after the total points (the last possible line at the bottom). But without the "." before the pre. Like what C.P. said earlier.

C.P. wrote: "_____Name__|___Books___|___Buddy___|___Pages___|___Total___
___________|___Read___ |___Reads___|___Read___ |__Points___

Jamie___________|__________|__________|__________|__________
Salha__________..."

It woooooorked!

Thank you so much, guys! :)

Yay! Let me know if you need help adjusting the tables for all of the teams. It's mostly all the different length names that make it a little difficult to format.

haha yeah I learned that the hard way. Until I asked for help by so many people!!

Alaina: how do you format the excel sheet so that it does the calculations for you?

I might have forgotten to ask, but did my scoring template for the seasonal challenge look all right?

Jackie wrote: "Alaina: how do you format the excel sheet so that it does the calculations for you?"

Oh man, I hope I explain this correctly. So I will use one of the teams from this month as an example. I will explain what I did and then post what their current scores are. So again, I hope it makes sense.

So for example: let's look at Hogwarts.

So on Excel, I would have a category for name, points, BR, pages, and total points.
Then I would put each persons name under name.
Then for points I would give the points for each book. In the example, Trisha has read about 12 books so far this month. So that is her number.
For BR I would type in the amount of points (depending on what the scoring is for that particular challenge)
For pages, I would add up all of the pages that person has read. For example, Trisha has read about 4500 pages. (I rounded for the example).
Then for the total, I put in the formula: ((Pages/200)+points+BR+page point[this is depending if they reached 1,000 pages or not])
Also I totaled the Points, BR's, and Pages.

I also like to double check, to see if I'm completely correct or if I made an error. So for the total column I would add them all up together and see what the points equal.
Then I would use the total pages / 200 then add total points, total BR's, and then the total points from the people who read 1,000 pages or more.

___Name______|__Points____|___Buddy___|__Pages___|__Total___
_____________|____________|___Read____|___Read___|__Points__

Trisha_______|_____12_____|___________|__4,506___|__54.53__
Sibil________|_____16_____|___________|__5,071___|__66.36_
Liz__________|____________|___________|__________|________
Lexie________|____________|___________|__________|________
Hanna________|______9_____|_____1_____|__3,613___|__43.07_
Ashley_______|_____15_____|_____1_____|__5,000___|__66____
CP___________|______2_____|___________|__1,984___|__16.92_
Susan________|______4_____|___________|__1,461___|__16.31_

Team_________|_____58_____|_____2_____|_21,635___|_263.18_

I don't show that both columns equal each other when I post the score template, but on my Excel it shows.

Jackie wrote: "I might have forgotten to ask, but did my scoring template for the seasonal challenge look all right?"

It looked completely fine to me.

Alaina wrote: "Jackie wrote: "I might have forgotten to ask, but did my scoring template for the seasonal challenge look all right?"

It looked completely fine to me."

Thanks. :) It was my first time creating one on my own, so I just wanted to make sure.

I'm thinking maybe we should have each other's emails and have like one person create the score template on like word and another person create the score template on excel. So that way we can all use it. Just in case one person, or a lot, can't post the scores.

Just an idea.

And obviously the excel spreadsheet would have the formulas attached...except for adding the BR points and page points to the actual total number. Because those would have to change periodically.

How do you insert the formulas into excel so that it automatically calculates?

Just add the following formula:

= “books read cell”+”buddy reads cell”+(pages cell/200)

That’s how I did it. And then you can add whichever number in each cell, and it’ll calculate accordingly.

Oh yeah, like Salha said: I would just type in" =((pages #/200)+points+BR+1,000 page point) and that's how I did each total.

So you type in the cell numbers for each row, right? And you do this for each total? Sorry for all the questions.

Well I would technically type in a formula for all of the total columns. So I only have to type in information into the Points, Pages, and BR Columns. Plus add the points depending on the 1,000 pages.

Ahh, that's what I mean. Thanks for all the help! You've made my life loads easier!

Is there a way so that you can just enter a new page number into the pages column and it adds it to the original?
So for example:
Orriginal: 200
New number: 300
Output from excel: 500

=(200+300)

so every time someone adds a new review, you just keep adding the page numbers to the original

Thanks

No problem!

I've followed all this excel conversation and I should probably try using that at some point. It's actually easier for me to use a calculator, haha. Plus I'm not always on the same computer, but I guess a google sheet would probably work for that.

Good morning everyone! Did anyone post the final scores yet? If not I can look over everything and add them up! Do I post both team and individual? Or just team?

I have not done that yet. If you have time, that would be great! I'll get to the quarterly challenge final points.

Yes, team scores and individual. :)

Gotcha! I will put them up. Need coffee first!!

How many of you use google docs? I have the grid for Nov/Dec on a google doc and could send it to those who have it that way. Then I could message the categories to those who don't.

I have started using them again.

C.P. wrote: "How many of you use google docs? I have the grid for Nov/Dec on a google doc and could send it to those who have it that way. Then I could message the categories to those who don't."

I use OneNote. :/

I've never tried OneNote. Do you like it?

If it's easier for everyone I will just message the categories to you all. :) Probably a bit later this afternoon.

Whatever works.

C.P. wrote: "I've never tried OneNote. Do you like it?

If it's easier for everyone I will just message the categories to you all. :) Probably a bit later this afternoon."

I love it! If you like how you can organize binders you'll love OneNote. It's basically a computer binder!! :D

I won't be near a computer in the afternoon so I'll comment either when I get home or tomorrow depending on how tired I am. :)

I use Google Docs :)

Perfect! Salha, do I have your email? You can message it to me and I'll share the doc and then message Bookbuyer and whoever else doesn't use them.

I might have to try OneNote now. Sounds pretty great!

C.P. wrote: "Perfect! Salha, do I have your email? You can message it to me and I'll share the doc and then message Bookbuyer and whoever else doesn't use them.

I might have to try OneNote now. Sounds pretty ..."

I highly recommend it! ^-^

C.P. wrote: "How many of you use google docs? I have the grid for Nov/Dec on a google doc and could send it to those who have it that way. Then I could message the categories to those who don't."

I use them!

Send me your email so I can add you to the doc, Alaina. I don't think I have it.

[email protected]

I have a question: can you count the pages of a book that you started during a previous month for this challenge?

Say, you read like 40% during September, and you read the remaining 60% during October, can I count that for points?

Someone shared a review like that yesterday, and I counted it for points but forgot to ask you, guys.

But I took into consideration only the pages read during October for points, not the whole book.

I will say that as long as what they have read is over the 100 page minimum then yes, that will be fine.

Yeah, it was a bit over 400 pages read during October :)