1. Download our Official Android App: Forums for Android!

The "Linux questions (and other stuff)" thread

Discussion in 'Computers' started by MoodyBlues, Jan 17, 2013.

  1. MoodyBlues

    MoodyBlues - Crazy peacock person -
    Thread Starter
    Rank:
    None
    Points:
    343
    Posts:
    3,353
    Joined:
    Jan 27, 2011

    Jan 27, 2011
    3,353
    1,580
    343
    Formerly UNIX/Linux programmer/sysadmin, now disab
    /home/LosAngeles
    Anyone here familiar enough with spreadsheets to help me out? I'm using LibreOffice, on Linux [obviously!], and although I have decades of experience doing database programming, I know virtually nothing about spreadsheets. I have what I think is a simple requirement, but since I have no idea how to do it...it's not so simple. :D

    Assume there's a spreadsheet with six fields (columns). Let's say columns 3 and 4 are the columns of interest; 3 will have whole numbers entered into it; 4 should automatically keep a running subtotal. In other words:

    Code (Text):
    1.  
    2. Column 3           Column 4
    3.      100                100
    4.       25                125
    5.      250                375
    6.      100                475
    7.  
    My brain isn't up to figuring this out myself right now, so any help--as in spelling out how to do this--will be greatly appreciated. :)
     

    Advertisement

  2. MoodyBlues

    MoodyBlues - Crazy peacock person -
    Thread Starter
    Rank:
    None
    Points:
    343
    Posts:
    3,353
    Joined:
    Jan 27, 2011

    Jan 27, 2011
    3,353
    1,580
    343
    Formerly UNIX/Linux programmer/sysadmin, now disab
    /home/LosAngeles
    (duplicate)
     
  3. Dngrsone

    Dngrsone Android Expert
    Rank:
     #39
    Points:
    643
    Posts:
    3,963
    Joined:
    Jan 24, 2013

    Jan 24, 2013
    3,963
    3,657
    643
    Male
    Avionics Bench Technician
    Centrally located far from everywhere
    Assuming a title row, then B2 would be =sum b2

    Then on C3 you would have =sum b2:b3

    And on C4 you'd want =sum b2:b4
     
  4. MoodyBlues

    MoodyBlues - Crazy peacock person -
    Thread Starter
    Rank:
    None
    Points:
    343
    Posts:
    3,353
    Joined:
    Jan 27, 2011

    Jan 27, 2011
    3,353
    1,580
    343
    Formerly UNIX/Linux programmer/sysadmin, now disab
    /home/LosAngeles
    Thanks, Dngrsone, for the help. However, I'm a bit stumped.

    Where did B2 come from? Yes, there's a title row, with names like "Total" for its fields/columns.

    Huh? :thinking:

    By "C3" are you referring to column 3, the column having whole numbers manually entered into the fields, and by "C4" column 4 that should automatically keep a running subtotal? I'm sorry, but I'm just not seeing what you're doing.
     
  5. Dngrsone

    Dngrsone Android Expert
    Rank:
     #39
    Points:
    643
    Posts:
    3,963
    Joined:
    Jan 24, 2013

    Jan 24, 2013
    3,963
    3,657
    643
    Male
    Avionics Bench Technician
    Centrally located far from everywhere
    Sorry, that was predicated on column two having the whole numbers and column three carrying the running total.

    Alternatively, you could have cell D2 =c2 and then cell D3 =sum d2+c3
     
  6. 9to5cynic

    9to5cynic Android Expert
    Rank:
    None
    Points:
    633
    Posts:
    4,873
    Joined:
    Feb 20, 2011

    Feb 20, 2011
    4,873
    1,766
    633
    /home/
    Moody, you're going to hate me for saying this... but I think MS Excel would be able to do this :rofl:

    ;)

    In all honesty, I just never used LibreOffice's Spreadsheet program to know how it's done

    Okay, (again, I'm using Excel)... you can make the first col. (C3) like it is.

    In C4, have it run this function "=sum(B2,C1)". This has it take the value of Column 3 horizontal of it, and add it to the Column 4 above it.
    This creates a running total (I think ;))

    Hope that makes sense, I've never tried to describe excel functions on forums before. :eek:
     
  7. MoodyBlues

    MoodyBlues - Crazy peacock person -
    Thread Starter
    Rank:
    None
    Points:
    343
    Posts:
    3,353
    Joined:
    Jan 27, 2011

    Jan 27, 2011
    3,353
    1,580
    343
    Formerly UNIX/Linux programmer/sysadmin, now disab
    /home/LosAngeles
    Thanks, guys. Will fiddle with it tomorrow.
     
  8. saptech

    saptech Android Expert
    Rank:
    None
    Points:
    343
    Posts:
    3,757
    Joined:
    Dec 9, 2011

    mikedt likes this.
  9. nickdalzell

    nickdalzell Android Expert
    Rank:
    None
    Points:
    243
    Posts:
    4,849
    Joined:
    Jun 17, 2011

    Jun 17, 2011
    4,849
    873
    243
    Owensboro, KY
    Mom's laptop is for the fourth time already resetting her kubuntu settings to the default (stock wallpaper, default panel, all her desktop settings reset and deleted) and I have the exact same operating system, kubuntu 12.10. I never have this bug and the only difference is her machine is a Hewlett Packard high end desktop replacement laptop computer while mine is a low end Toshiba satellite. I told her she is either doing an improper shutdown, letting the battery deplete to 0% or something. She is now begging me to reinstall Windows as she keeps getting frustrated and constantly chimes "Windows wasn't this hard!" And I really don't want to break out the recovery disks!
     
  10. matxor

    matxor Newbie
    Rank:
    None
    Points:
    16
    Posts:
    13
    Joined:
    May 11, 2013

    May 11, 2013
    13
    2
    16
    Is the hard drive full/too many write cycles on a SSD? Are the write permissions screwed up? Perhaps just format and reinstall, my kubuntu started acting strange and reinstalling fixed it
     
  11. nickdalzell

    nickdalzell Android Expert
    Rank:
    None
    Points:
    243
    Posts:
    4,849
    Joined:
    Jun 17, 2011

    Jun 17, 2011
    4,849
    873
    243
    Owensboro, KY
    It seems to do it on restart or when turned off then back on. I can shut it down and bring it up no problem but it happens only to her. I've lectured her many times about never shutting down Linux but she has windows habits that just won't quit. She often forgets to plug it in and the battery dies. The only time my computer forgets certain things is if shut down improperly. My guess is she is letting it run out of juice. Unlike Windows Linux forgets things like the wallpaper setting if that session wasn't properly logged out. Likewise my Android phone forgets some recent downloads if the device crashes, freezes or requires a hard reset that doesn't properly unmount the external SD card

    This laptop has no other issues and is a very expensive model with beats audio and a huge hard drive. I assure you it ain't full. It isn't a SSD
     
  12. matxor

    matxor Newbie
    Rank:
    None
    Points:
    16
    Posts:
    13
    Joined:
    May 11, 2013

    May 11, 2013
    13
    2
    16
    Perhaps try setting up a cronjob that checks the battery level every few minutes, and if it's too low, initiate a sudo poweroff
     
  13. nickdalzell

    nickdalzell Android Expert
    Rank:
    None
    Points:
    243
    Posts:
    4,849
    Joined:
    Jun 17, 2011

    Jun 17, 2011
    4,849
    873
    243
    Owensboro, KY
    I tried to enable hibernation but that option is greyed out for some reason. See she just forgets to plug it in and Kubuntu never warns her and she just sees it instantly shutting off. Again she chimes in 'Windows always told me! '

    The laptop also never tries to use standby even it just goes to 0% of charge and blinks out
     
  14. matxor

    matxor Newbie
    Rank:
    None
    Points:
    16
    Posts:
    13
    Joined:
    May 11, 2013

    May 11, 2013
    13
    2
    16
    Lookup crontab
     
  15. MoodyBlues

    MoodyBlues - Crazy peacock person -
    Thread Starter
    Rank:
    None
    Points:
    343
    Posts:
    3,353
    Joined:
    Jan 27, 2011

    Jan 27, 2011
    3,353
    1,580
    343
    Formerly UNIX/Linux programmer/sysadmin, now disab
    /home/LosAngeles
    I have yet to see that--and I'm in my 22nd year of using Linux.

    EVERY aspect of a user's experience on Linux is controllable by the user [or the sysadmin]. You might want to take a look at your mom's configuration files in ~/.kde/share. Again, EVERYTHING is controllable on Linux--unlike on window$--usually with plain English configuration files--unlike on window$--that can be hand-edited or can be modified via 'system settings' type menu entries in your GUI.

    I'm too tired and bored right now to offer any in-depth help, so I'll leave you with this simple, but not elegant, solution: Save a copy of her ~/.kde directory somewhere safe; make sure you save it when everything's working/looking as wanted. The next time she screws things up, just copy the backup back and you're good to go. Or, better yet, have a startup command that does it automatically. :D
     
    nickdalzell likes this.
  16. nickdalzell

    nickdalzell Android Expert
    Rank:
    None
    Points:
    243
    Posts:
    4,849
    Joined:
    Jun 17, 2011

    Jun 17, 2011
    4,849
    873
    243
    Owensboro, KY
    What about enabling hibernation so if the battery goes to a certain threshold her session is saved? Seems the option is greyed out in Ubuntu/kubuntu by default for some reason as my laptop also has it greyed out
     
  17. 9to5cynic

    9to5cynic Android Expert
    Rank:
    None
    Points:
    633
    Posts:
    4,873
    Joined:
    Feb 20, 2011

    Feb 20, 2011
    4,873
    1,766
    633
    /home/
    Can't believe I wrote off vi(m) so quickly. After a little bit of time last night with vimtutor, I feel like this is *the* text editor. :)

    (of course, emacs is swell, not looking for on of *those* threads ;) :p )

    If you've been using nano, might want to think about running vimtutor and trying it out one of these days :D
     
  18. MoodyBlues

    MoodyBlues - Crazy peacock person -
    Thread Starter
    Rank:
    None
    Points:
    343
    Posts:
    3,353
    Joined:
    Jan 27, 2011

    Jan 27, 2011
    3,353
    1,580
    343
    Formerly UNIX/Linux programmer/sysadmin, now disab
    /home/LosAngeles
    Yep, it's been my text editor for 28 years! :D

    Oh...one of THOSE threads. :laugh:

    [​IMG]
     
  19. sfbloodbrother

    sfbloodbrother Android Expert
    Rank:
    None
    Points:
    233
    Posts:
    6,109
    Joined:
    Jul 30, 2012

    Jul 30, 2012
    6,109
    733
    233
    Male
    Full time student, Part time McDonalds crew
    Chicago IL
    28 years. Wow. you been in computers a while then :)
     
  20. Dngrsone

    Dngrsone Android Expert
    Rank:
     #39
    Points:
    643
    Posts:
    3,963
    Joined:
    Jan 24, 2013

    Jan 24, 2013
    3,963
    3,657
    643
    Male
    Avionics Bench Technician
    Centrally located far from everywhere
    There are a few people around here who have rocked the command line for that long or longer...
     
  21. Haggistech

    Haggistech Well-Known Member
    Rank:
    None
    Points:
    43
    Posts:
    214
    Joined:
    May 26, 2011

  22. Dngrsone

    Dngrsone Android Expert
    Rank:
     #39
    Points:
    643
    Posts:
    3,963
    Joined:
    Jan 24, 2013

    Jan 24, 2013
    3,963
    3,657
    643
    Male
    Avionics Bench Technician
    Centrally located far from everywhere
    Considering the direction Ubuntu has been headed, and Mint is just... uncomfortable as yet, I might just go straight to Debian.

    That is, if I can find the time to do anything so drastic as install a new OS on my laptop. I have one last semester of school to do, plus working full-time, et cetera.

    I may end up with a new laptop before that happens. Then, I suppose, I would have to find time to install an OS, huh?
     
  23. Joelgp83

    Joelgp83 Android Enthusiast
    Rank:
     #331
    Points:
    68
    Posts:
    454
    Joined:
    Jul 30, 2012

    Jul 30, 2012
    454
    176
    68
    California
    Might be worth it to double-check the power control settings in the BIOS/UEFI. If the sleep state support is off, that would explain the lack of standby-ing.
     
  24. Joelgp83

    Joelgp83 Android Enthusiast
    Rank:
     #331
    Points:
    68
    Posts:
    454
    Joined:
    Jul 30, 2012

    Jul 30, 2012
    454
    176
    68
    California
    For the record, this appears to be possible:

    How to enable hibernation in Ubuntu 12.04

    I'm currently not in a position to confirm if this will work, but it certainly would be worth a try.
     
  25. jonbanjo

    jonbanjo Well-Known Member
    Rank:
    None
    Points:
    43
    Posts:
    208
    Joined:
    May 26, 2013

    May 26, 2013
    208
    49
    43
    UK
    I'm going back a few posts but I don't see the reason for sum used in the solutions I've looked at.

    Code (Text):
    1.  
    2. Column 3   Column4
    3. 100        =C2
    4. 25         =D2+C3
    5.  
    That is unless totalling on more than one column, eg.

    Code (Text):
    1.  
    2. Column 2   Column3  Column4
    3. 25         75       100
    4. 15         10       125
    5.  
    6. 25         75       =SUM(B2:C2)
    7. 15         10       =SUM(B3:C3)+D2
    8.  
     

Share This Page

Loading...