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

NETFLIX - Manbird - Feb 24, 2021 - 10:51pm
 
Steven Wilson - westslope - Feb 24, 2021 - 6:42pm
 
COVID-19 - Lazy8 - Feb 24, 2021 - 6:10pm
 
RP works great with LMS - SqueezeGuy - Feb 24, 2021 - 4:04pm
 
Radio Paradise Comments - miamizsun - Feb 24, 2021 - 2:54pm
 
World Music - deltaindia - Feb 24, 2021 - 2:47pm
 
Mars Exploration Rover Mission Status - R_P - Feb 24, 2021 - 2:33pm
 
volcano! - geoff_morphini - Feb 24, 2021 - 1:52pm
 
Gardeners Corner - westslope - Feb 24, 2021 - 1:33pm
 
ALAC Stream Links? - rwyatt - Feb 24, 2021 - 1:32pm
 
Regarding cats - westslope - Feb 24, 2021 - 1:23pm
 
I am Thinking of: - oldviolin - Feb 24, 2021 - 1:20pm
 
Climate Change - NoEnzLefttoSplit - Feb 24, 2021 - 1:05pm
 
How's the weather? - GeneP59 - Feb 24, 2021 - 12:59pm
 
Baseball, anyone? - ScottFromWyoming - Feb 24, 2021 - 12:55pm
 
Photography Forum - Your Own Photos - deltaindia - Feb 24, 2021 - 12:41pm
 
Race in America - R_P - Feb 24, 2021 - 11:37am
 
Crazy conspiracy theories - R_P - Feb 24, 2021 - 11:28am
 
Acoustic Guitar - rhahl - Feb 24, 2021 - 11:16am
 
Capitalism and Consumerism... now what? - ScottFromWyoming - Feb 24, 2021 - 10:23am
 
Offline Cache not working anymore - jarro - Feb 24, 2021 - 9:26am
 
Trump - westslope - Feb 24, 2021 - 9:05am
 
The No Phone Zone - Proclivities - Feb 24, 2021 - 6:56am
 
LeftWingNutZ - islander - Feb 24, 2021 - 6:35am
 
Today in History - Red_Dragon - Feb 24, 2021 - 5:06am
 
Those Lovable Policemen - haresfur - Feb 24, 2021 - 12:55am
 
The All-Things Beatles Forum - kurtster - Feb 23, 2021 - 10:54pm
 
Vinyl Only Spin List - kurtster - Feb 23, 2021 - 7:14pm
 
American Justice - Red_Dragon - Feb 23, 2021 - 6:49pm
 
Questions. - Red_Dragon - Feb 23, 2021 - 6:32pm
 
Movie Quote - Antigone - Feb 23, 2021 - 3:56pm
 
Name My Band - rgio - Feb 23, 2021 - 12:26pm
 
• • • BRING OUT YOUR DEAD • • •  - sirdroseph - Feb 23, 2021 - 12:18pm
 
Marijuana: Baked News. - JrzyTmata - Feb 23, 2021 - 12:05pm
 
The Obituary Page - cc_rider - Feb 23, 2021 - 9:52am
 
• • • The Once-a-Day • • •  - Proclivities - Feb 23, 2021 - 9:36am
 
Bug Reports & Feature Requests - jarro - Feb 23, 2021 - 8:53am
 
Counting with Pictures - Proclivities - Feb 23, 2021 - 6:46am
 
Automotive Lust - kurtster - Feb 22, 2021 - 5:29pm
 
Photos you have taken of yourself - Ohmsen - Feb 22, 2021 - 4:46pm
 
Messages in a bottle. - Ohmsen - Feb 22, 2021 - 4:33pm
 
What did you have for lunch? - Ohmsen - Feb 22, 2021 - 4:03pm
 
2020 Elections - R_P - Feb 22, 2021 - 12:51pm
 
Ted Cruz - ScottFromWyoming - Feb 22, 2021 - 12:47pm
 
Trump Lies - R_P - Feb 22, 2021 - 12:09pm
 
Israel - R_P - Feb 22, 2021 - 11:47am
 
What is the meaning of this? - GeneP59 - Feb 22, 2021 - 9:19am
 
Brave Browser - rgio - Feb 22, 2021 - 8:12am
 
Pernicious Pious Proclivities Particularized Prodigiously - Red_Dragon - Feb 22, 2021 - 6:16am
 
YouTube: Music-Videos - Steely_D - Feb 21, 2021 - 12:38pm
 
Kodi Addon - ScottFromWyoming - Feb 21, 2021 - 11:58am
 
Great Old Songs You Rarely Hear Anymore - Zep - Feb 21, 2021 - 11:53am
 
songs that ROCK! - rhahl - Feb 21, 2021 - 10:44am
 
the Todd Rundgren topic - miamizsun - Feb 21, 2021 - 10:16am
 
Madonna's latest - miamizsun - Feb 21, 2021 - 8:15am
 
New Music - Proclivities - Feb 21, 2021 - 6:38am
 
Guns - Red_Dragon - Feb 20, 2021 - 8:10pm
 
Get the Quote - Red_Dragon - Feb 20, 2021 - 5:30pm
 
Career Opportunities - GeneP59 - Feb 20, 2021 - 4:05pm
 
Thanks, Grizzly Bear! - Red_Dragon - Feb 20, 2021 - 1:17pm
 
Outstanding Covers - sirdroseph - Feb 20, 2021 - 9:28am
 
Mixtape Culture Club - Lazy8 - Feb 20, 2021 - 9:26am
 
Queen - Red_Dragon - Feb 20, 2021 - 6:31am
 
Classical Music - rhahl - Feb 19, 2021 - 6:47am
 
what the hell, miamizsun? - sunybuny - Feb 19, 2021 - 5:58am
 
A Brave Woman - sirdroseph - Feb 19, 2021 - 5:23am
 
Whatever happened to Taco Wagon? - miamizsun - Feb 19, 2021 - 4:45am
 
Immigration - sirdroseph - Feb 19, 2021 - 4:39am
 
Terrorist Watch! - sirdroseph - Feb 19, 2021 - 3:17am
 
Questions I'd like to ask at tonight's debate - sirdroseph - Feb 19, 2021 - 3:12am
 
Republican Party - R_P - Feb 18, 2021 - 8:24pm
 
I play the drums... - KarmaKarma - Feb 18, 2021 - 8:04pm
 
NASA & other news from space - GeneP59 - Feb 18, 2021 - 6:30pm
 
China - Ohmsen - Feb 18, 2021 - 4:17pm
 
Pictures you have taken of your feet. *snort* - Ohmsen - Feb 18, 2021 - 3:39pm
 
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