[ ]   [ ]   [ ]                        [ ]      [ ]   [ ]

Breaking News - kurtster - Mar 28, 2024 - 11:41am
 
The Obituary Page - ScottFromWyoming - Mar 28, 2024 - 11:31am
 
Talk Behind Their Backs Forum - VV - Mar 28, 2024 - 11:27am
 
March 2024 Photo Theme - Many - NoEnzLefttoSplit - Mar 28, 2024 - 11:07am
 
Wordle - daily game - rgio - Mar 28, 2024 - 11:00am
 
Baseball, anyone? - zevon - Mar 28, 2024 - 10:02am
 
Ukraine - Beaker - Mar 28, 2024 - 9:41am
 
Bug Reports & Feature Requests - Beaker - Mar 28, 2024 - 9:30am
 
NY Times Strands - geoff_morphini - Mar 28, 2024 - 8:37am
 
NYTimes Connections - geoff_morphini - Mar 28, 2024 - 8:29am
 
Radio Paradise Comments - pilgrim - Mar 28, 2024 - 8:19am
 
Business as Usual - black321 - Mar 28, 2024 - 8:09am
 
• • • The Once-a-Day • • •  - black321 - Mar 28, 2024 - 7:44am
 
Trump - rgio - Mar 28, 2024 - 7:29am
 
Outstanding Covers - thisbody - Mar 28, 2024 - 5:51am
 
Today in History - DaveInSaoMiguel - Mar 28, 2024 - 4:28am
 
USA! USA! USA! - R_P - Mar 27, 2024 - 7:40pm
 
Little known information...maybe even facts - haresfur - Mar 27, 2024 - 6:21pm
 
Live Music - oldviolin - Mar 27, 2024 - 5:08pm
 
RightWingNutZ - R_P - Mar 27, 2024 - 3:48pm
 
Lyrics that strike a chord today... - miamizsun - Mar 27, 2024 - 2:44pm
 
Please Don't Post Here - Red_Dragon - Mar 27, 2024 - 11:02am
 
Motivational Office Cliches... - NoEnzLefttoSplit - Mar 26, 2024 - 10:20pm
 
(Big) Media Watch - Red_Dragon - Mar 26, 2024 - 6:18pm
 
YouTube: Music-Videos - miamizsun - Mar 26, 2024 - 4:10pm
 
Israel - R_P - Mar 26, 2024 - 12:24pm
 
Photos you have taken of your walks or hikes. - Steely_D - Mar 26, 2024 - 12:04pm
 
Solar / Wind / Geothermal / Efficiency Energy - islander - Mar 26, 2024 - 8:00am
 
Is there any DOG news out there? - Beez - Mar 26, 2024 - 7:24am
 
Food - Steely_D - Mar 26, 2024 - 1:41am
 
Vinyl Only Spin List - kurtster - Mar 25, 2024 - 6:56pm
 
Derplahoma! - Red_Dragon - Mar 25, 2024 - 3:48pm
 
Frequent drop outs (The Netherlands) - kingen - Mar 25, 2024 - 2:43pm
 
China - R_P - Mar 25, 2024 - 11:59am
 
Musky Mythology - R_P - Mar 25, 2024 - 11:20am
 
Play history seems to indicate that I"m streaming 24/7, b... - jarro - Mar 25, 2024 - 10:44am
 
April 8th Partial Solar Eclipse - Coaxial - Mar 24, 2024 - 6:22pm
 
New Music - KurtfromLaQuinta - Mar 24, 2024 - 5:07pm
 
Dental Floss Tycoons, and other Montana Myths, Facts, and... - Red_Dragon - Mar 24, 2024 - 12:32pm
 
Orbiting Earth - oldviolin - Mar 24, 2024 - 9:42am
 
Basketball - oldviolin - Mar 23, 2024 - 2:50pm
 
What Makes You Laugh? - ScottFromWyoming - Mar 23, 2024 - 1:54pm
 
Joe Biden - kurtster - Mar 23, 2024 - 11:17am
 
Technical Streaming Note for Nerdy RP DIYers - sjagminas1 - Mar 23, 2024 - 10:16am
 
Museum Of Bad Album Covers - Proclivities - Mar 23, 2024 - 8:56am
 
Other Medical Stuff - Antigone - Mar 22, 2024 - 3:06pm
 
Country Up The Bumpkin - oldviolin - Mar 22, 2024 - 11:06am
 
Pernicious Pious Proclivities Particularized Prodigiously - Red_Dragon - Mar 22, 2024 - 9:17am
 
Memorials - Remembering Our Loved Ones - Bill_J - Mar 21, 2024 - 8:54pm
 
Can you afford to retire? - DaveInSaoMiguel - Mar 21, 2024 - 2:15pm
 
Mixtape Culture Club - KurtfromLaQuinta - Mar 21, 2024 - 11:10am
 
What Did You See Today? - KurtfromLaQuinta - Mar 20, 2024 - 5:13pm
 
Annoying stuff. not things that piss you off, just annoyi... - ScottFromWyoming - Mar 20, 2024 - 4:31pm
 
Upcoming concerts or shows you can't wait to see - Antigone - Mar 20, 2024 - 3:10pm
 
Russia - NoEnzLefttoSplit - Mar 20, 2024 - 11:44am
 
Photography Forum - Your Own Photos - Proclivities - Mar 20, 2024 - 9:33am
 
2024 Elections! - Lazy8 - Mar 20, 2024 - 7:26am
 
Economix - R_P - Mar 19, 2024 - 4:36pm
 
Name My Band - DaveInSaoMiguel - Mar 19, 2024 - 10:53am
 
RP automation with iOS Shortcuts App - jarro - Mar 19, 2024 - 10:15am
 
Delicacies: a..k.a.. the Gross Food forum - DaveInSaoMiguel - Mar 19, 2024 - 10:12am
 
Irony 101 - Proclivities - Mar 19, 2024 - 6:02am
 
New Forum Member on "What Makes RP Great" - miamizsun - Mar 19, 2024 - 4:38am
 
Cache stopped working on old Android Phone - Eisenwindel - Mar 19, 2024 - 1:50am
 
Cryptic Posts - Leave Them Guessing - Bill_J - Mar 18, 2024 - 8:23pm
 
Damn Dinosaurs! - oldviolin - Mar 18, 2024 - 8:16pm
 
One Partying State - Wyoming News - geoff_morphini - Mar 18, 2024 - 3:58pm
 
Great guitar faces - skyguy - Mar 18, 2024 - 3:33pm
 
Despots, dictators and war criminals - R_P - Mar 18, 2024 - 12:41pm
 
Uploading Music - dischuckin - Mar 18, 2024 - 11:55am
 
Media Matters - thisbody - Mar 18, 2024 - 10:03am
 
NASA & other news from space - miamizsun - Mar 18, 2024 - 4:13am
 
MEALTICKET - drinpt - Mar 17, 2024 - 4:13am
 
What makes you smile? - Steely_D - Mar 16, 2024 - 7:31pm
 
Apple Computer - GeneP59 - Mar 16, 2024 - 12:02pm
 
Index » Radio Paradise/General » General Discussion » Google Docs (Docs, Spreadsheets, etc) Page: 1, 2  Next
Post to this Topic
ScottFromWyoming

ScottFromWyoming Avatar

Location: Powell
Gender: Male


Posted: Jan 19, 2021 - 1:54pm



 oldviolin wrote:


 ScottFromWyoming wrote:


 rgio wrote:
 ScottFromWyoming wrote:
Um, I don't understand how it figured out what I want it to do but I manually entered the formula for the first 6 cells in my column, then used those numbers +1 in the next 6 cells and dragged that out to 500 cells and it worked. I have avoided giving any praise to Excel for my whole life but (LibreOffice) did it! Still no idea how it figured out what I wanted to achieve.

Thanks!
 
You don't have to know...the robots can read your mind.  Once you get the vaccine...you won't even have to do the research....just think about it and Bill Gates will do it for you!
 

I don't know if that's good for America but I'll take it.
Define 'America'
but wait a sec so I can get the mic ready...

 
*tap* *tap*

oldviolin

oldviolin Avatar

Location: esse quam videri
Gender: Male


Posted: Jan 19, 2021 - 11:48am



 ScottFromWyoming wrote:


 rgio wrote:
 ScottFromWyoming wrote:
Um, I don't understand how it figured out what I want it to do but I manually entered the formula for the first 6 cells in my column, then used those numbers +1 in the next 6 cells and dragged that out to 500 cells and it worked. I have avoided giving any praise to Excel for my whole life but (LibreOffice) did it! Still no idea how it figured out what I wanted to achieve.

Thanks!
 
You don't have to know...the robots can read your mind.  Once you get the vaccine...you won't even have to do the research....just think about it and Bill Gates will do it for you!
 

I don't know if that's good for America but I'll take it.
Define 'America'
but wait a sec so I can get the mic ready...
ScottFromWyoming

ScottFromWyoming Avatar

Location: Powell
Gender: Male


Posted: Jan 19, 2021 - 11:41am



 rgio wrote:
 ScottFromWyoming wrote:
Um, I don't understand how it figured out what I want it to do but I manually entered the formula for the first 6 cells in my column, then used those numbers +1 in the next 6 cells and dragged that out to 500 cells and it worked. I have avoided giving any praise to Excel for my whole life but (LibreOffice) did it! Still no idea how it figured out what I wanted to achieve.

Thanks!
 
You don't have to know...the robots can read your mind.  Once you get the vaccine...you won't even have to do the research....just think about it and Bill Gates will do it for you!
 

I don't know if that's good for America but I'll take it.
rgio

rgio Avatar

Location: West Jersey
Gender: Male


Posted: Jan 19, 2021 - 11:13am

 ScottFromWyoming wrote:
Um, I don't understand how it figured out what I want it to do but I manually entered the formula for the first 6 cells in my column, then used those numbers +1 in the next 6 cells and dragged that out to 500 cells and it worked. I have avoided giving any praise to Excel for my whole life but (LibreOffice) did it! Still no idea how it figured out what I wanted to achieve.

Thanks!
 
You don't have to know...the robots can read your mind.  Once you get the vaccine...you won't even have to do the research....just think about it and Bill Gates will do it for you!
ScottFromWyoming

ScottFromWyoming Avatar

Location: Powell
Gender: Male


Posted: Jan 19, 2021 - 11:08am



 ScottFromWyoming wrote:


 rgio wrote:


 ScottFromWyoming wrote:
Sorry if I've asked this before. It's an ongoing problem that I may have asked for help with before. I'm doing raffle tickets that need to be numbered. I get various tickets out of a sheet depending on the design. If I print them 123456 on the first page and 789101112 on the second page... they'll be all mixed up when I cut them apart. So I need to know how to create a list of numbers like this:

Where the first number is *whatever* but usually 001
Where the last number is *whatever* say 500
Where X is what I call the "repeat," which is the number of tickets per sheet...


From what I understand, this can all be accomplished with some calculation in Excel but I'm an idiot so if anyone can show me ... 

 
This is Word/Excel based.  Good luck.  10 min Mark is the "data" section. 

 

That gets close; it'll have to do for this job, thanks!

(the layout program I'm using does a data merge that does one more step, so I don't need the columns she uses, I need the pattern to repeat in one column. It's a mess. I know it can be done but I'll use this today and get the job out...)
 

Um, I don't understand how it figured out what I want it to do but I manually entered the formula for the first 6 cells in my column, then used those numbers +1 in the next 6 cells and dragged that out to 500 cells and it worked. I have avoided giving any praise to Excel for my whole life but (LibreOffice) did it! Still no idea how it figured out what I wanted to achieve.

Thanks!
ScottFromWyoming

ScottFromWyoming Avatar

Location: Powell
Gender: Male


Posted: Jan 19, 2021 - 10:32am



 rgio wrote:


 ScottFromWyoming wrote:
Sorry if I've asked this before. It's an ongoing problem that I may have asked for help with before. I'm doing raffle tickets that need to be numbered. I get various tickets out of a sheet depending on the design. If I print them 123456 on the first page and 789101112 on the second page... they'll be all mixed up when I cut them apart. So I need to know how to create a list of numbers like this:

Where the first number is *whatever* but usually 001
Where the last number is *whatever* say 500
Where X is what I call the "repeat," which is the number of tickets per sheet...


From what I understand, this can all be accomplished with some calculation in Excel but I'm an idiot so if anyone can show me ... 

 
This is Word/Excel based.  Good luck.  10 min Mark is the "data" section. 

 

That gets close; it'll have to do for this job, thanks!

(the layout program I'm using does a data merge that does one more step, so I don't need the columns she uses, I need the pattern to repeat in one column. It's a mess. I know it can be done but I'll use this today and get the job out...)
rgio

rgio Avatar

Location: West Jersey
Gender: Male


Posted: Jan 18, 2021 - 2:10pm



 ScottFromWyoming wrote:
Sorry if I've asked this before. It's an ongoing problem that I may have asked for help with before. I'm doing raffle tickets that need to be numbered. I get various tickets out of a sheet depending on the design. If I print them 123456 on the first page and 789101112 on the second page... they'll be all mixed up when I cut them apart. So I need to know how to create a list of numbers like this:

Where the first number is *whatever* but usually 001
Where the last number is *whatever* say 500
Where X is what I call the "repeat," which is the number of tickets per sheet...


From what I understand, this can all be accomplished with some calculation in Excel but I'm an idiot so if anyone can show me ... 

 
This is Word/Excel based.  Good luck.  10 min Mark is the "data" section. 

ScottFromWyoming

ScottFromWyoming Avatar

Location: Powell
Gender: Male


Posted: Jan 18, 2021 - 1:22pm

Sorry if I've asked this before. It's an ongoing problem that I may have asked for help with before. I'm doing raffle tickets that need to be numbered. I get various tickets out of a sheet depending on the design. If I print them 123456 on the first page and 789101112 on the second page... they'll be all mixed up when I cut them apart. So I need to know how to create a list of numbers like this:

Where the first number is *whatever* but usually 001
Where the last number is *whatever* say 500
Where X is what I call the "repeat," which is the number of tickets per sheet...

001
002
003
004
005
006
007... will give me a stack of tickets that are sequenced 1,7,13,19,25... so what I need is a .csv of numbers that go by a repeat of 84 (500/6=83.?):

001
085
169
253
337
421
002
086
170
254
338
422... repeating up until 505 in this case. When stacked up and cut apart, I'll have stacks of 001-084, 085-168 etc. 

There used to be a script online that I used and I've asked them to let me share it, but never heard back from them and now the website's defunct. Here's the page at the wayback machine but it doesn't load the script...

From what I understand, this can all be accomplished with some calculation in Excel but I'm an idiot so if anyone can show me ... 
rosedraws

rosedraws Avatar

Location: close to the edge
Gender: Female


Posted: Mar 6, 2010 - 1:00pm

 ScottFromWyoming wrote:

Have you used Google Docs to collaborate on a file with others? That's where I need help: People say they're getting this error or that (MOST people can open the files, just not everyone). If all's I wanted to do was use a basic word doc or spreadsheet etc on my own, I would have no problem.

Being able to create a file, save it, then next week open that file on a different computer... cool. I have Dropbox, etc. but this is simpler.
 
Our summer camp planning group has used it.  Never a problem.  Except for remembering the sign in information...

BlueHeronDruid

BlueHeronDruid Avatar

Location: Заебани сме луѓе


Posted: Mar 6, 2010 - 10:39am

 ScottFromWyoming wrote:

Have you used Google Docs to collaborate on a file with others? That's where I need help: People say they're getting this error or that (MOST people can open the files, just not everyone). If all's I wanted to do was use a basic word doc or spreadsheet etc on my own, I would have no problem.

Being able to create a file, save it, then next week open that file on a different computer... cool. I have Dropbox, etc. but this is simpler.
 
I think hobbitt has fooled around with it. I'll point him to this thread when he gets home.

Xeric

Xeric Avatar

Location: Montana
Gender: Male


Posted: Mar 6, 2010 - 6:27am

 OlderThanDirt wrote:

Probably hiding in MS Office.

And last I heard, Apple was still holding on to about 10% of the personal computer market.  Wonder what the 90% might be? {#Wink}
 
Sad.  Really, really sad.

Or, perhaps (or maybe it's "and"), inexplicable.  

{#Lol}

 
DownHomeGirl

DownHomeGirl Avatar

Location: American Russia
Gender: Female


Posted: Mar 6, 2010 - 5:56am

 ScottFromWyoming wrote:
Anyone using Google Docs to collaborate/share information? I've put a few things up and shared them with 25 people. Some have no problem reading, downloading, whatever. Some people get server errors, blank pages, or have other problems that I can't begin to figure out what is going on...

What's your best option for sharing a file with many people, some of whom don't/won't have a gmail account?

Yeah it's 10:15 on a Saturday Night. What's your point? Okay, 9:50 on Friday but still...

 
I use this all the time for school group projects.  No one ever had a hard time using it that I know of— I didn't.  The only weird things I can think of are:

1) sometimes if two people are editing the document at the same time, weird things happen
2) formatting doesn't always work when you cut and paste, in either direction.

Otherwise it's been great.  Perhaps the people having problems are getting into the document at the same time others are editing... have they tried refreshing the page?  I dunno what could be causing them to see a blank page though. Or have a server error.

Proclivities

Proclivities Avatar

Location: Paris of the Piedmont
Gender: Male


Posted: Mar 6, 2010 - 5:39am

 ScottFromWyoming wrote:

Have you used Google Docs to collaborate on a file with others? That's where I need help: People say they're getting this error or that (MOST people can open the files, just not everyone). If all's I wanted to do was use a basic word doc or spreadsheet etc on my own, I would have no problem.

Being able to create a file, save it, then next week open that file on a different computer... cool. I have Dropbox, etc. but this is simpler.
 
I have done some collaborated spreadsheets and word documents through there, but only with two or three other users, and didn't experience any problems then.  Other people have told me that with more users there were errors or some files not updating.  I have a friend who uses it extensively with his co-workers; their lab is mostly Mac users, but I'll ask if they have PC-related issues.  There may be some unwritten procedure.

ScottFromWyoming

ScottFromWyoming Avatar

Location: Powell
Gender: Male


Posted: Mar 6, 2010 - 4:45am

 Proclivities wrote:

Google docs will let you create pdf's on a PC: you have to "Download As PDF".  Once that pdf is created, though, you can not edit it through the Google docs platform.  Each successive version would have to be downloaded again as a pdf.  It does change the formatting sometimes, particularly on things like resumes, so I always look at the pdf to make sure it bears some resemblance to the original.
 
Have you used Google Docs to collaborate on a file with others? That's where I need help: People say they're getting this error or that (MOST people can open the files, just not everyone). If all's I wanted to do was use a basic word doc or spreadsheet etc on my own, I would have no problem.

Being able to create a file, save it, then next week open that file on a different computer... cool. I have Dropbox, etc. but this is simpler.

Proclivities

Proclivities Avatar

Location: Paris of the Piedmont
Gender: Male


Posted: Mar 6, 2010 - 4:17am

 OlderThanDirt wrote:

Not on a PC, unless you have the full Acrobat package.  I have MS Word, and it allows me to save to pdf.  Most home users won't spring for the $400 or so to get Acrobat.  Acrobat Reader is a free download, though.
 
Google docs will let you create pdf's on a PC: you have to "Download As PDF".  Once that pdf is created, though, you can not edit it through the Google docs platform.  Each successive version would have to be downloaded again as a pdf.  It does change the formatting sometimes, particularly on things like resumes, so I always look at the pdf to make sure it bears some resemblance to the original.

OlderThanDirt

OlderThanDirt Avatar

Location: In Transit
Gender: Male


Posted: Mar 5, 2010 - 10:19pm

 ScottFromWyoming wrote:
How the HELL did this turn into an Apple/Windows war? Google Docs is platform-independent. Dammit!
 
OTD I input some stuff, just raw typing, someone else needs to proofread it, then I'll format it and PDF it. Other stuff I want a lot of people to be able to edit certain parts of a larger, fluid document. So hey. 

I wondered.  So what was your question again? {#Lol}

*edit*  You know you can create editable pdf's, right?

*edit2*  I wasn't familiar with Google Docs. so I Googled it.  The idea of platform independent data exchange sounds like a great idea, but if, as you say, there are glitches, maybe that isn't yet as helpful as it might be in later versions.  And I haven't used editable pdfs enough to know whether there might be glitches there as well.  Considering the cost of a full Acrobat package, it might just be worth waiting for Google to patch their system.


ScottFromWyoming

ScottFromWyoming Avatar

Location: Powell
Gender: Male


Posted: Mar 5, 2010 - 10:13pm

 OlderThanDirt wrote:

I don't know what their move to Intel from Motorola means for the hardware, but I suspect it gives them more flexibility in terms of software compatibility.  And I've never been a fan of Apple's "don't ask how it works, just use it" OS philosophy.  Especially in the early years of limited RAM, I appreciated being able (with MS) to adjust memory allocation to the application I happened to be using at the time.  I wrote a start-up routine that allowed me to choose something like 5 different configurations.  Not only did it make specific applications run faster, it avoided crashes.  That was sort of fun in itself.
 
In the early Mac OS, you could allocate (increase) memory to each app as needed.

ScottFromWyoming

ScottFromWyoming Avatar

Location: Powell
Gender: Male


Posted: Mar 5, 2010 - 10:11pm

How the HELL did this turn into an Apple/Windows war? Google Docs is platform-independent. Dammit!
 
OTD I input some stuff, just raw typing, someone else needs to proofread it, then I'll format it and PDF it. Other stuff I want a lot of people to be able to edit certain parts of a larger, fluid document. So hey.


OlderThanDirt

OlderThanDirt Avatar

Location: In Transit
Gender: Male


Posted: Mar 5, 2010 - 10:10pm

 BlueHeronDruid wrote:

I have no doubt that Macs are great. But Microsloth suffered from the same successful disease that IBM did - all things to all people, and all developers.
 
I don't know what their move to Intel from Motorola means for the hardware, but I suspect it gives them more flexibility in terms of software compatibility.  And I've never been a fan of Apple's "don't ask how it works, just use it" OS philosophy.  Especially in the early years of limited RAM, I appreciated being able (with MS) to adjust memory allocation to the application I happened to be using at the time.  I wrote a start-up routine that allowed me to choose something like 5 different configurations.  Not only did it make specific applications run faster, it avoided crashes.  That was sort of fun in itself.

BlueHeronDruid

BlueHeronDruid Avatar

Location: Заебани сме луѓе


Posted: Mar 5, 2010 - 9:49pm

 OlderThanDirt wrote:

Both my daughter and her husband worked for Apple at one time, but I still had to go with MS for the sake of software available for my work.  They still use Macs, but their son, GS#1, has a PC laptop. {#Lol}

 
I have no doubt that Macs are great. But Microsloth suffered from the same successful disease that IBM did - all things to all people, and all developers.

Page: 1, 2  Next