Recent Questions

first time on site. I have a range of LibreOffice Calc cells A1:M218. Most rows have a "Y', for Yes, in one of the columns but some rows are empty. Is there a function that can be entered in column N which will highlight the empty rows by retuing a specified character? If there is a function would it also work in MS Excel?LibreOffice Let's block ads! بخوانید...

I am creating a large tar archive and I would like to create the checksum of the archive too. I could achieve it like this: $ tar cfz archive.tar.gz files $ sha256sum archive.tar.gz > archive.tar.gz.sha256sum But the archive file is huge and on slow media, so I'd prefer not to have to read it all in again after writing it out. Can I build a pipeline that will hash the file as it writes it? I thought maybe I could do this with the tee utility, but that only writes to a file, not to the standard input of another command. Let's block ads! بخوانید...

I'm trying to teach my kids to save so I'm giving them the chance to deposit money into a "bank account" that pays interest (that I run). I'd like to create a spreadsheet to track the current value of their accounts. This seems like it would be easy but I'm having trouble figuring it out in excel. Given a worksheet of deposits and withdrawals on various dates - how do I calculate the current value of the accounts assuming a constant interest rate (interest rate never changes)? 1/1/2016 +$10 1/4/2016 +$4 1/10/2016 -$5 1/10/2016 +$2 etc Current Value with X% interest rate = ??? Thanks in advance! Let's block ads! بخوانید...

I recently notice my Virtual Box VM will show up error when ruing a multi thread application. If the thread number is low, there will be no error. Given n number of CPU assigned to the VM, is there any equation for maximum number of thread supported by Virtual Box? The OS is ubuntu 16.04. Let's block ads! بخوانید...

I need to calculate a three-tier progressive fee in Excel. X% for just the first $A then Y% between $A and $B and Z% for greater than $B. Just not sure how to translate this to Excel language. ...

I have devised Audit workbooks with up to 21 pages with Yes/No tick boxes for each question. I have linked each tick box with the Yes/No cell for each question (very time consuming) but I need to now have a final score on the last page to add up all Yes (True) answers so i can then do another formula to calculate the percentage. I have not really got room to add another column on each page as space is limited. I was hoping there is a formula i can use at the end to cover from Page 1 to end? Many thanks in advance Let's block ads! بخوانید...

I have RAID 10, that is my configuration: /opt/MegaRAID/storcli/storcli64 /c0/d0 show Controller = 0 Status = Success Description = Show Diskgroup Succeeded TOPOLOGY : ======== -------------------------------------------------------------------------- DG Arr Row EID:Slot DID Type State BT Size PDC PI SED DS3 FSpace -------------------------------------------------------------------------- 0 - - - - RAID10 Optl N 43.658 TB dflt N N dflt N 0 0 - - - RAID1 Optl N 7.276 TB dflt N N dflt N 0 0 0 12:0 14 DRIVE Onln N 3.638 TB dflt N N dflt - 0 0 1 12:1 16 DRIVE Onln N 3.638 TB dflt N N dflt - 0 0 2 12:2...

There's new default Calculator app in Windows 10. Is there a way to get rid of calc.exe file from system32 folder? Reason: I don't want any built-in apps, but I have a habit of ruing calc command via Win+R. I removed Calculator with Get-AppxPackage -allusers *windowscalc* | Remove-AppxPackage but every time I run calc it reinstalls back. When I try to delete/rename the file, it says that it's write-protected, although it's not ruing (at least it's not listed in the task manager). Alteatively, I also tried to create a file calc.bat in my folder and add it to PATH variable higher than other locations, so that my command would be found first, but for some reason this doesn't work, and Win+R ...

I have three rows in Libre Office I want to divide the third row by the second and multiply by the first row. After that I want to take everything and take the average. How do I do all that in one formula? I tried =MITTELWERT((K23:N23)/(K22:N22)) (MITTELWERT mean average) but that did not work yet. What to do? Let's block ads! بخوانید...

I'd like to create a parity storage space in Windows 10 with a 5 tb disk and two 3 tb disks. Is there a way to calculate how much usable space this will give me? ...

Here's a snapshot of my pivot table. I want to create a calculated field that displays the percentage from the Responded column (C) over the Ticket # column (B) as in column G. The Ticket # column is a column of value text strings (e.g. 413456, 464313) and the Responded column is a list of 1's and 0's. In my pivot table I am taking the count of all Ticket # and the sum of the Responded. I tried to create a calculated field with the following formula =Responded/COUNT('Ticket #') but this gave me the same as Sum of Responded. How can I create a field that gives me the % in column G? This entry passed through the Full-Text RSS service - if this is your content and you're reading it on someo...