Language Selection

English French German Italian Portuguese Spanish

Big Bear's Helpful Hints-Google Docs Spreadsheets

Filed under
Howtos

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

Leftovers: Gaming

Open Source Software: 10 Go To Solution for Small Businesses

While closed-source operating systems such as Windows and Mac OS may still dominate the OS market, not everyone can afford the high costs that they entail. For small- and medium-sized enterprises where every penny matters, taking advantage of open-source software such as Ubuntu’s Linux is a good bet to boost productivity and cost effectiveness. The fact that open-source softwares have evolved to become somewhat user-friendly and sleek also helps a good deal. Read more

Linux 4.11-rc8

So originally I was just planning on releasing the final 4.11 today, but while we didn't have a *lot* of changes the last week, we had a couple of really annoying ones, so I'm doing another rc release instead. I did get fixes for the issues that popped up, so I could have released 4.11 as-is, but it just doesn't feel right. It's not like another week of letting this release mature will really hurt. The most noticeable of the issues is that we've quirked off some NVMe power management that apparently causes problems on some machines. It's not entirely clear what caused the issue (it wasn't just limited to some NVMe hardware, but also particular platforms), but let's test it. Read more Also: Linux 4.11 delayed for a week by NVMe glitches and 'oops fixes' Linux 4.11 Pushed Back: 4.11-rc8 Released

Themes for Ubuntu

  • Flattiance is a Flat Fork of Ubuntu’s Ambiance Theme
    Flattiance is pitched as a “semi-flat fork” of the Ubuntu Ambiance theme. You know, the one that ships out of the box and by default. On the whole Flattiance keeps to the same color palette, with dark browns and orange accents, but it ditches the gradient in app headers in favour of a solid block.
  • A quick look at some essential GNOME Shell tweaks and extensions
    Now that Ubuntu is moving to GNOME Shell, many people will get a bit of a shock at how different the workflow is from Unity to Shell. Here’s a quick look at some essentials to get you going.