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

Bitcoin - kurtster - Apr 21, 2021 - 12:22am
 
Things You Thought Today - islander - Apr 20, 2021 - 9:03pm
 
All Dogs Go To Heaven - Dog Pix - Prodigal_SOB - Apr 20, 2021 - 5:31pm
 
Breaking News - Ohmsen - Apr 20, 2021 - 5:14pm
 
Live Music - R_P - Apr 20, 2021 - 5:09pm
 
Radio Paradise Comments - Ohmsen - Apr 20, 2021 - 5:02pm
 
The Obituary Page - Ohmsen - Apr 20, 2021 - 4:06pm
 
Automotive Lust - Antigone - Apr 20, 2021 - 3:40pm
 
Immigration - Ohmsen - Apr 20, 2021 - 2:56pm
 
Biden's Lies - KurtfromLaQuinta - Apr 20, 2021 - 1:10pm
 
Name My Band - oldviolin - Apr 20, 2021 - 1:10pm
 
260,000 Posts in one thread? - oldviolin - Apr 20, 2021 - 1:08pm
 
Dialing 1-800-Manbird - oldviolin - Apr 20, 2021 - 12:47pm
 
Texas News - sirdroseph - Apr 20, 2021 - 12:11pm
 
Strips, cartoons, illustrations - sirdroseph - Apr 20, 2021 - 11:59am
 
Get the Money out of Politics! - R_P - Apr 20, 2021 - 11:43am
 
Counting with Pictures - ScottN - Apr 20, 2021 - 11:19am
 
Looting & vandalism isn't protest - westslope - Apr 20, 2021 - 11:15am
 
Philosophy (Meaty Metaphysical Munchables!) - sirdroseph - Apr 20, 2021 - 10:40am
 
Songs you hear too often on RP - Ohmsen - Apr 20, 2021 - 10:39am
 
COVID-19 - black321 - Apr 20, 2021 - 10:13am
 
New Music - R_P - Apr 20, 2021 - 9:48am
 
What makes you smile? - ScottFromWyoming - Apr 20, 2021 - 9:37am
 
Look what's going on in New York - ScottFromWyoming - Apr 20, 2021 - 9:28am
 
Those Lovable Policemen - sirdroseph - Apr 20, 2021 - 8:59am
 
Terrorist Watch! - sirdroseph - Apr 20, 2021 - 8:33am
 
Race in America - sirdroseph - Apr 20, 2021 - 5:41am
 
Thought For The Day - sirdroseph - Apr 20, 2021 - 5:02am
 
When Ethnic Music travels to different Countries - Manbird - Apr 19, 2021 - 9:02pm
 
The forbidden music - Manbird - Apr 19, 2021 - 8:58pm
 
Is it wrong to not want to listen to music I don't unders... - Manbird - Apr 19, 2021 - 8:52pm
 
The Rpeeps Favorite Triangle player list - Manbird - Apr 19, 2021 - 8:45pm
 
music that makes you dance with big wavy gestures - Manbird - Apr 19, 2021 - 8:41pm
 
Electronic Music - Manbird - Apr 19, 2021 - 8:35pm
 
Listeners' Bands and Music Projects - Manbird - Apr 19, 2021 - 8:30pm
 
Long Songs - Manbird - Apr 19, 2021 - 8:21pm
 
Talk Behind Their Backs Forum - geoff_morphini - Apr 19, 2021 - 6:41pm
 
Mars Exploration Rover Mission Status - miamizsun - Apr 19, 2021 - 4:00pm
 
• • • The Once-a-Day • • •  - haresfur - Apr 19, 2021 - 3:40pm
 
Rewind the Cache - ScottFromWyoming - Apr 19, 2021 - 11:37am
 
In My Room - Manbird - Apr 19, 2021 - 10:51am
 
Evolution! - R_P - Apr 19, 2021 - 10:31am
 
Russia - sirdroseph - Apr 19, 2021 - 8:54am
 
Afghanistan - R_P - Apr 19, 2021 - 8:43am
 
Tech & Science - miamizsun - Apr 19, 2021 - 7:48am
 
Movie Recommendation - rhahl - Apr 19, 2021 - 7:42am
 
Sweet horrible irony. - sirdroseph - Apr 19, 2021 - 6:31am
 
Media Bias - sirdroseph - Apr 19, 2021 - 5:12am
 
YouTube: Music-Videos - sirdroseph - Apr 19, 2021 - 3:35am
 
Air Travel Blues - Manbird - Apr 18, 2021 - 11:45pm
 
Crazy conspiracy theories - R_P - Apr 18, 2021 - 1:26pm
 
Today in History - GeneP59 - Apr 18, 2021 - 10:32am
 
Baseball, anyone? - GeneP59 - Apr 18, 2021 - 10:20am
 
Photography Forum - Your Own Photos - oldviolin - Apr 17, 2021 - 7:15pm
 
Trump - westslope - Apr 17, 2021 - 3:47pm
 
Jazz - rhahl - Apr 17, 2021 - 1:15pm
 
Radiohead - R_P - Apr 17, 2021 - 10:25am
 
Vocabulary Quiz - rhahl - Apr 17, 2021 - 10:08am
 
The Netherlands - second - StefanFlos - Apr 17, 2021 - 8:46am
 
Bug Reports & Feature Requests - pilgrim - Apr 17, 2021 - 7:45am
 
What the hell OV? - miamizsun - Apr 17, 2021 - 7:33am
 
Solar / Wind / Geothermal / Efficiency Energy - rhahl - Apr 17, 2021 - 7:19am
 
MQA Stream Coming to BLUOS - kd4ylq - Apr 17, 2021 - 7:02am
 
Those lovable acronym guys & gals - R_P - Apr 16, 2021 - 2:59pm
 
Outstanding Covers - rhahl - Apr 16, 2021 - 2:35pm
 
volcano! - KurtfromLaQuinta - Apr 16, 2021 - 12:15pm
 
RightWingNutZ - Red_Dragon - Apr 16, 2021 - 12:03pm
 
Amazing art - R_P - Apr 16, 2021 - 12:02pm
 
Guns - R_P - Apr 16, 2021 - 9:46am
 
what the hell, miamizsun? - oldviolin - Apr 16, 2021 - 9:30am
 
Ask an Atheist - black321 - Apr 16, 2021 - 9:25am
 
HALF A WORLD - oldviolin - Apr 16, 2021 - 9:22am
 
Cryptic Posts - Leave Them Guessing - oldviolin - Apr 16, 2021 - 8:33am
 
Ask the Libertarian - sirdroseph - Apr 16, 2021 - 8:33am
 
Be a Music Critic! - Proclivities - Apr 16, 2021 - 6:35am
 
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