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 stan...

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/...

I recently notice my Virtual Box VM will show up error when running 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...

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 - - - ...

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 running 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 running (at least it's not listed in the task manager). Alteativ...

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...

I have Website form that is entering data in Google Spreadsheet and I need to calculate automatically by Google Spreadsheet formula Shipping Cost for all orders. Data consists of: Name Email Online Store Subcategory Price Online Store 2 Subcategory 2 Price 2 Online Store 3 Subcategory 3 Price 3 Here is how it looks like in Google Spreadsheet: Input data from Website Form When client submit inquiry on Website form data is entered in Google Spreadsheet and I would like to automatically calculate s...

I have 2 columns of data in OpenOffice Calc that look like this... A | B ------------ 12 | 12 8 | 8 9 | 11 98 | 9 123 | 123 I would like to check that columns A and B match and then put either 'Match' of 'No Match' in column C Is the MATCH function the best thing to use in this instance? ...

I have GPA and I want the cell just shows me if the student is passed or failed without showing the GPA as number. Can I? ...

Suppose I have a hard disk with 3 sectors, each containing 3MBytes. The seek time is 5 ms. What is the rotation speed (in RPM)? I know the answer is 4222,2 RPM, but I can't figure out how to get this value. ...

Autocomplete can be nice, but for me it's usually not what I want in LibreOffice Calc. Is there a way to disable it? ...

With the little knowledge I have with spreadsheets and with lots of help from Google, I've managed to create this little project management spreadsheet to help me tracking stuff and it works pretty nice so far. To keep it clean, I've put the services pricing on separate sheet. All nice and crisp so far. At this point I've managed to auto-populate the services names into the Projects sheet (column C) with the services names I have on Pricing sheet via Data validation. But... the formulas I've use...

I have battling to get this task right and I need some assistance: 1.Create a new Python file in this folder called InvestmentCalculator.py 2.At the top of the file include the line: import math 3.Ask the user to input: The amount that they are depositing, stored as ‘P’. The interest rate (as a percentage), stored as ‘i’. ○ The number of years of the investment. stored as ‘t’. ○ Then ask the user to input whether they want “simple” or “compound” interest, and store this in a variable called ‘int...

1) If the total amount to be subjected to tax is 30,000.00 2) The first 2,200.00 to 3,000.00 is taxed at 25%. 3) The second 3,000.01 to 5,900.00 is taxed at 30% 4) The remaining amount is taxed at 35% Help me calculate tax using the IF THEN ELSE syntax in a macro in excel. Let's block ads! بخوانید...

I want to calcuate the QPI bandwidth of the Intel E5-2600 processor. Wikipediea shows that the formula should be: CPU frequency × 2 bits/Hz (double data rate) × 16(20) (data bits/QPI link width) × 2 (unidirectional send and receive operating simultaneously) ÷ 8 (bits/byte) Therefore, the QPI bandwidth of E5-2600 is 20.8GB/s. But according to intel's specification, giga transfers per second is 8GT/s, which rendering a 32GB/s QPI bandwidth: 8 GT/s x 16 x 2 / 8 Can you tell me what's wrong with the...