#e61919
Product Manager
12218
0
1
Mar 11, 2017 17:47:30 GMT -8
Matej
This is my status!
17,630
August 2003
wooper
|
Post by Matej on Feb 8, 2019 11:11:02 GMT -8
That image shows you at the top of the sheet, scroll all the way to the bottom Did you notice the box at the bottom right-hand side of that image I posted? Here is the real problem which I didn't explain fully: (here goes)---I can scroll down that sheet pretty much as infinitum. However, if I try to add another book to line 25 and save it - I get nothing. I am unable to post anything past line 24 on the spreadsheet. This is why I keep adding pages. I took a deeper look at your spreadsheet from the first post and noticed something peculiar. It appears you have the first 25 rows frozen - this will prevent you from scrolling when you only have a screen height that displays 25 rows - and I think it might be causing the message in the corner for a too small screen. Try to do the following: - Go to Sheet 1 - Click anywhere in the sheet - Click "View" in the menu -> Freeze -> No Rows The rows should now be unfrozen. Check if you can scroll lower down and if the message has disappeared. If the message is still there, try zooming out and see if that makes a difference. You can do this by pressing "CTRL" and "-" together one or two times. This will zoom you out to 90/80% of zoom. The sheet looks completely fine on my side, and I can even see the Add more rows thing on the bottom of your sheet (but can't click it, obviously), so I think it's just a display issue, rather than any problem with the sheet.
|
|
inherit
Passionate Peruser of Prose
89748
0
Feb 26, 2024 2:23:30 GMT -8
📚 Dianne 📚
"Never Judge A Book By Its Movie"
10,522
September 2006
cats57
|
Post by 📚 Dianne 📚 on Feb 8, 2019 13:03:27 GMT -8
Did you notice the box at the bottom right-hand side of that image I posted? Here is the real problem which I didn't explain fully: (here goes)---I can scroll down that sheet pretty much ad infinitum. However, if I try to add another book to line 25 and save it - I get nothing. I am unable to post anything past line 24 on the spreadsheet. This is why I keep adding pages. I took a deeper look at your spreadsheet from the first post and noticed something peculiar. It appears you have the first 25 rows frozen - this will prevent you from scrolling when you only have a screen height that displays 25 rows - and I think it might be causing the message in the corner for a too small screen. Try to do the following: - Go to Sheet 1 - Click anywhere in the sheet - Click "View" in the menu -> Freeze -> No Rows The rows should now be unfrozen. Check if you can scroll lower down and if the message has disappeared. If the message is still there, try zooming out and see if that makes a difference. You can do this by pressing "CTRL" and "-" together one or two times. This will zoom you out to 90/80% of zoom. The sheet looks completely fine on my side, and I can even see the Add more rows thing on the bottom of your sheet (but can't click it, obviously), so I think it's just a display issue, rather than any problem with the sheet. I can type my books on any line I want (BELOW what I have already)but when I go to save the spreadsheet the lines I added are gone. However, I'll give your advice a try. Thanks for the help!
|
|
inherit
23506
0
Nov 19, 2012 5:30:35 GMT -8
James [a_leon]
I feel a strong desire to XSS a cookie from Peter.
4,326
April 2004
mnstrgarge
|
Post by James [a_leon] on Feb 9, 2019 8:58:12 GMT -8
Spreadsheet help-- this is Google Docs --- what can I do to have a continuous scroll instead of having to have several different pages? In your menus, choose "View", "Freeze", "No Rows". That should allow it to let you enter data farther down and combine the sheets you currently have into one...I'd be happy to help with that if you need! How can I stop my borders from disappearing when I put something in that cell (?)I have to keep editing every time I add to the Author column. I was not able to recreate this, so I'm not sure. Let me ask some follow up on this. Are you saying that when you add a new author (as in, you're adding a new row of information), the borders that were there disappear? Is there a way to make my color choices for each column permanent (to the document)? You can do this per sheet, but not for the whole document. What you'll want to do is click on the column you want to add color to (let's use the Author column as an example, column C). When you click this, you'll notice it highlights the entire column. You can do your color changes as you would if it were an individual cell and it will apply to everything in that column. docs.google.com/spreadsheets/d/1ctT-OyDBQeGRByf9WrQWodplYI4wny9K39pIk9neTc0/edit?usp=sharingThere's the one I did really quick, so you can see what the changes I'm talking about will do (also made all borders consistent at double borders...something that can definitely be changed).
|
|
inherit
Passionate Peruser of Prose
89748
0
Feb 26, 2024 2:23:30 GMT -8
📚 Dianne 📚
"Never Judge A Book By Its Movie"
10,522
September 2006
cats57
|
Post by 📚 Dianne 📚 on Feb 10, 2019 5:36:42 GMT -8
James [a_leon]Oh, James -thank you, thank you, thank you. I will do everything you've suggested today. If I need more help I will message you okay?
|
|
inherit
23506
0
Nov 19, 2012 5:30:35 GMT -8
James [a_leon]
I feel a strong desire to XSS a cookie from Peter.
4,326
April 2004
mnstrgarge
|
Post by James [a_leon] on Feb 10, 2019 11:56:46 GMT -8
James [a_leon] Oh, James -thank you, thank you, thank you. I will do everything you've suggested today. If I need more help I will message you okay? Absolutely . If I don't respond in a reasonable amount of time, someone can ping me on discord (I'm sure they're lurking and seeing this thread).
|
|
inherit
Passionate Peruser of Prose
89748
0
Feb 26, 2024 2:23:30 GMT -8
📚 Dianne 📚
"Never Judge A Book By Its Movie"
10,522
September 2006
cats57
|
Post by 📚 Dianne 📚 on Feb 11, 2019 4:52:18 GMT -8
James [a_leon] Oh, James -thank you, thank you, thank you. I will do everything you've suggested today. If I need more help I will message you okay? Absolutely . If I don't respond in a reasonable amount of time, someone can ping me on discord (I'm sure they're lurking and seeing this thread). Oops! Matej had already given me this info and as I said to him, by doing that I can scroll till the cows come home but when I type on a line and save it - well, it won't save. (for lack of me thinking of a better word) And the next time I log on I', back in the same position -since this is for my year of reading this is going to be at least 24 or 25 sheets long *sigh*.
|
|
inherit
23506
0
Nov 19, 2012 5:30:35 GMT -8
James [a_leon]
I feel a strong desire to XSS a cookie from Peter.
4,326
April 2004
mnstrgarge
|
Post by James [a_leon] on Feb 11, 2019 7:50:51 GMT -8
Absolutely . If I don't respond in a reasonable amount of time, someone can ping me on discord (I'm sure they're lurking and seeing this thread). Oops! Matej had already given me this info and as I said to him, by doing that I can scroll till the cows come home but when I type on a line and save it - well, it won't save. (for lack of me thinking of a better word) And the next time I log on I', back in the same position -since this is for my year of reading this is going to be at least 24 or 25 sheets long *sigh*. What browser do you use? I cannot recreate this for the life of me.
|
|
inherit
Passionate Peruser of Prose
89748
0
Feb 26, 2024 2:23:30 GMT -8
📚 Dianne 📚
"Never Judge A Book By Its Movie"
10,522
September 2006
cats57
|
Post by 📚 Dianne 📚 on Feb 13, 2019 4:43:38 GMT -8
Oops! Matej had already given me this info and as I said to him, by doing that I can scroll till the cows come home but when I type on a line and save it - well, it won't save. (for lack of me thinking of a better word) And the next time I log on I'm back in the same position -since this is for my year of reading this is going to be at least 24 or 25 sheets long *sigh*. What browser do you use? I cannot recreate this for the life of me. Chrome.
|
|
inherit
29252
0
Sept 6, 2012 15:46:49 GMT -8
Derek‽
28,652
August 2004
kajiaisu
|
Post by Derek‽ on Feb 16, 2019 14:05:33 GMT -8
If you are a member of Goodreads I would give you the link to one of the readers. I tried to engage them in conversation to see if they would tell me how they could read so fast -they simply told me that they took a book with them everywhere and read every time they had a moment. I’m not on Goodreads. I don’t read enough these days to justify engaging in literary communities. If they’re happy reading that way—or pretending to read that way, which is more likely—never really comprehending what’s going on and bouncing from story to story without reflection, well, good for them, I guess. I’ll never read that way. Don’t worry about the “typical time to read” stat. You’re only competing with a formula, not other people. I turned to our old friend, Math, and went to town dissecting and cross-referencing every bit of data I could about a selection of books in my Kindle library to figure out how Amazon comes up with its reading time. Answers? Oh, I found ‘em. To make a long, boring story short: the time given is based on the number of pages for the Kindle edition of a book. It works out to between 0.9 and 1.0 pages per minute. This doesn’t hold true for every book, which caused me quite a bit of frustration. A whim, a fluke, and a poor calculation that seemed irrelevant caused me to stumble upon the reason why some books are different: the number of pages dictates the “pages per minute” rate used in the formula. Very short books (about 125 pages and under) use 0.5 pages per minute. Very long books presumably use 1.5 or possibly even 2.0 pages per minute, but the longest book in my library was 374 pages and still adhered to the 1.0-ish rate at 0.9144 ppm. Why Amazon uses different rates based on length isn’t immediately obvious, but I have a hunch it’s based on an assumed proficiency of the reader. That is, someone reading a very short book is expected to be a kid or of a lower literacy level, while someone reading a more average novel-length book is expected to be of more average skill, while, again, someone tackling a very long book is expected to be an avid reader and thus potentially faster. I’ll note that the standard “words per minute” gauge for reading speed doesn’t apply here. Not only does it not scale appropriately with the word (or page) count, but it also doesn’t hold up when working backwards from the supplied estimate and can vary wildly and inappropriately. As a final note of interest, I’ll point out that the standard English-language, non-technical, adult-focused novel length is around 100,000 words and the average reading speed is about 250-300 words per minute, usually skewing towards the former. Bram Stoker’s Dracula is the closest sampled book in my library to that average length at 102,480 words and it matches perfectly to 250 wpm (6h 49m). So when Amazon created their formula, they probably started with these averages as a baseline for determining how fast a page should be read before... I don’t know what they were thinking, really. Maybe they thought page counting was more user-friendly? Number fudging? So, if you’re having trouble keeping up at 0.9-1.0 pages per minute, well, you’re just slower. It is what it is and it doesn’t mean anything. If you’re reading long books and you can’t keep up, then you’re probably average and Amazon’s estimates are overly enthusiastic. Either way, you’re still competing only with a so-so formula and ultimately, yourself. (For clarity: this is all in regards to the “Typical time to read” stat found in the “About this Book” menu. The estimated time remaining found at the bottom-left of the screen is clearly based on how fast a person flips through the pages.)
|
|