Language Selection

English French German Italian Portuguese Spanish

Big Bear's Helpful Hints-Google Docs Spreadsheets

Filed under

I like to jot down things that I learn how to do on the spur of the moment so that I can find it later.

I admit, in the 80's there was quite of bit of "herbal remedy" usage and my short term memory isn't what it could be. That's my story and I'm sticking to it.

I've decided that I might as well potentially help some other folks who might want to know about some of the things I discover, so I thought why not here?

For my very first post, I wanted to figure out how to sum cells across multiple pages in Google Docs spreadsheets.

The example I am using is related to a mileage spreadsheet, broken down as one month with 5 sheets , one for each week. "Week 1", Week 2", et al..

on my sheets, the weekly total for mileage and for the ederal assigned value to that mileage is in the same cell on each page. say, "F33"

In cell F36 on sheet 5, I wanted to put the monthly total of all miles from each sheet.

So, in that cell, I typed "=SUM('Week 1'!F33+'Week 2'!F33+'Week 3'!F33+'Week 4'!F33+'Week 5'!F33)"

Which, of course, allows me to have my total.

I did the same for total value on the mileage except for the corresponding cells (say G33). It's the same formula, just replacing "F33" with "G33".

Now I can always come back here to find this info, because I will forget. and maybe it wil lhelp someone else out while it's here.

The post titles will introduce the area that the post relates to, like this one shows "Google".

By the way... I am doing all of these things using Linux Mint Debian Editon. So yes, these are Linux do-able.

More in Tux Machines

today's leftovers

Proposed: A Tainted Performance State For The Linux Kernel

Similar to the kernel states of having a tainted kernel for using binary blob kernel modules or unsigned modules, a new tainting method has been proposed for warning the user about potentially adverse kernel performance. Dave Hansen of Intel has proposed a new "TAINT_PERFORMANCE" for the kernel that would proactively print a warning message about not using the kernel for any performance measurements. Dave explained in his RFC announcement, "I have more than once myself been the victim of an accidentally-enabled kernel configuration option being mistaken for a true performance problem. I'm sure I've also taken profiles or performance measurements and assumed they were real-world when really I was measuring the performance with an option that nobody turns on in production. A warning like this late in boot will help remind folks when these kinds of things are enabled." Read more

Scientific Linux 7.0 x86_64 BETA 3

Fermilab's intention is to continue the development and support of Scientific Linux and refine its focus as an operating system for scientific computing. Today we are announcing a beta release of Scientific Linux 7. We continue to develop a stable process for generating and distributing Scientific Linux, with the intent that Scientific Linux remains the same high quality operating system the community has come to expect. Please do not install Pre-Release software in your production environment. Read more

Ubuntu 14.10 (Utopic Unicorn) Now Features Linux Kernel 3.16.1

"The Utopic kernel has been rebased to the first v3.16.1 upstream stable kernel and uploaded to the archive, ie. linux-3.16.0-9.14. Please test and let us know your results," says Canonical's Joseph Salisbury, after the latest Ubuntu Kernel Team meeting. Read more