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

volcano! - NoEnzLefttoSplit - Mar 4, 2021 - 12:53am
 
Biden's Lies - Jiggz - Mar 3, 2021 - 11:47pm
 
Minimum rating for favorites - jarro - Mar 3, 2021 - 11:18pm
 
YouTube: Music-Videos - oppositelock - Mar 3, 2021 - 9:03pm
 
New Music - oppositelock - Mar 3, 2021 - 8:59pm
 
Counting with Pictures - ScottN - Mar 3, 2021 - 8:45pm
 
Steven Wilson - kurtster - Mar 3, 2021 - 6:54pm
 
COVID-19 - miamizsun - Mar 3, 2021 - 5:00pm
 
The Future is here! - R_P - Mar 3, 2021 - 4:58pm
 
Terrorist Watch! - Red_Dragon - Mar 3, 2021 - 4:11pm
 
• • • The Once-a-Day • • •  - haresfur - Mar 3, 2021 - 2:20pm
 
Talk Behind Their Backs Forum - NoEnzLefttoSplit - Mar 3, 2021 - 11:50am
 
Radio Paradise Comments - BlueHeronDruid - Mar 3, 2021 - 10:24am
 
RP in a Tesla EV - BillG - Mar 3, 2021 - 10:23am
 
Race in America - westslope - Mar 3, 2021 - 9:12am
 
Today in History - ScottFromWyoming - Mar 3, 2021 - 8:29am
 
Trump Lies - westslope - Mar 3, 2021 - 8:21am
 
What Did You Do Today? - KurtfromLaQuinta - Mar 3, 2021 - 8:15am
 
Ukraine - sirdroseph - Mar 3, 2021 - 3:30am
 
Small-town news - kcar - Mar 3, 2021 - 12:40am
 
Surfing! - haresfur - Mar 2, 2021 - 11:04pm
 
What is the meaning of this? - ScottFromWyoming - Mar 2, 2021 - 8:14pm
 
Share a Website you love or hate… - whatshisname - Mar 2, 2021 - 6:36pm
 
Show us your NEW _______________!!!! - haresfur - Mar 2, 2021 - 5:24pm
 
Learn something every day - Antigone - Mar 2, 2021 - 4:50pm
 
Future of Human Race (in 500 years) - miamizsun - Mar 2, 2021 - 2:35pm
 
Propaganda - R_P - Mar 2, 2021 - 2:29pm
 
Pernicious Pious Proclivities Particularized Prodigiously - R_P - Mar 2, 2021 - 1:02pm
 
Baseball, anyone? - ScottFromWyoming - Mar 2, 2021 - 9:59am
 
Derplahoma! - Red_Dragon - Mar 2, 2021 - 9:46am
 
What are you listening to now? - davidharper - Mar 2, 2021 - 8:10am
 
Museum Of Bad Album Covers - ScottFromWyoming - Mar 2, 2021 - 7:42am
 
RP Daily Trivia Challenge - NoEnzLefttoSplit - Mar 2, 2021 - 7:23am
 
Where would you like to live? - westslope - Mar 2, 2021 - 7:02am
 
That's good advice - rhahl - Mar 2, 2021 - 4:52am
 
Music documentaries - miamizsun - Mar 2, 2021 - 4:50am
 
The war on funk is over! - Ohmsen - Mar 1, 2021 - 6:23pm
 
Mixtape Culture Club - KurtfromLaQuinta - Mar 1, 2021 - 6:18pm
 
Evolution! - NoEnzLefttoSplit - Mar 1, 2021 - 11:35am
 
Testing your Metal? - miamizsun - Mar 1, 2021 - 11:11am
 
Buddy's Haven - Coaxial - Mar 1, 2021 - 10:50am
 
Why are Nick Cave & The Bad Seeds censored? - the_jake - Mar 1, 2021 - 7:39am
 
Real Life vs. the Internet - miamizsun - Mar 1, 2021 - 5:15am
 
Things People Have Said That I'll Never Forget - sirdroseph - Mar 1, 2021 - 5:13am
 
Republican Party - westslope - Feb 28, 2021 - 3:29pm
 
Stuff I've Said Out Loud - Antigone - Feb 28, 2021 - 12:39pm
 
Australia - westslope - Feb 28, 2021 - 9:34am
 
Fitness • Health - westslope - Feb 28, 2021 - 8:15am
 
Automotive Lust - kurtster - Feb 27, 2021 - 10:50pm
 
Name My Band - Manbird - Feb 27, 2021 - 4:42pm
 
You really put butter on the hot dog? - Manbird - Feb 27, 2021 - 1:27pm
 
Great Old Songs You Rarely Hear Anymore - rhahl - Feb 27, 2021 - 8:41am
 
Gotta Get Your Drink On - Proclivities - Feb 27, 2021 - 6:11am
 
Things You Thought Today - BlueHeronDruid - Feb 26, 2021 - 7:35pm
 
Classical Music - R_P - Feb 26, 2021 - 7:31pm
 
Birthday wishes - BlueHeronDruid - Feb 26, 2021 - 5:36pm
 
Joe Biden - KarmaKarma - Feb 26, 2021 - 3:14pm
 
Saudi Arabia - R_P - Feb 26, 2021 - 2:31pm
 
Anti-War - Ohmsen - Feb 26, 2021 - 2:01pm
 
Jazz - Ohmsen - Feb 26, 2021 - 1:43pm
 
Live Music - miamizsun - Feb 26, 2021 - 12:50pm
 
Braking News - miamizsun - Feb 26, 2021 - 12:39pm
 
Acoustic Guitar - rhahl - Feb 26, 2021 - 9:14am
 
Messages in a bottle. - Coaxial - Feb 26, 2021 - 4:27am
 
Get the Quote - sirdroseph - Feb 26, 2021 - 4:03am
 
Lyrics that are stuck in your head today... - sirdroseph - Feb 26, 2021 - 4:02am
 
Australia has Disappeared - haresfur - Feb 26, 2021 - 1:55am
 
Health Care - Isabeau - Feb 25, 2021 - 8:03pm
 
Lets Rock! - jlind - Feb 25, 2021 - 6:58pm
 
Favorite Scriptures...Leave Pontificating at the Door - ScottFromWyoming - Feb 25, 2021 - 6:57pm
 
Back to the 70's - rhahl - Feb 25, 2021 - 12:59pm
 
You're welcome, manbird. - oldviolin - Feb 25, 2021 - 11:47am
 
NETFLIX - oldviolin - Feb 25, 2021 - 10:31am
 
Skip not working on Volumio - Grarea - Feb 25, 2021 - 9:55am
 
What Did You See Today? - GeneP59 - Feb 25, 2021 - 8:58am
 
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: planting flowers


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: planting flowers


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