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 am trying to make a cell display a value dependent upon the value of another cell. e.g. If cell A1 contains "1st" i want cell b2 to calculate that as the number 25. Easy enough, but the trick is i want to also have Cell b2 calculate as 17 if i input the value 2nd into cell A1 and so forth. So far this is the formula i am using =SUM(IF(N40="1st",25)&SUM(IF(N40="2nd",18))) but the cell displays as 250, rather than 25. Then i want b2 to accumulate a series of cells with the same formula. This...

I already have a wsdl generated file given from the client and i need to write a client/server Soap app with php based on it, so that i can easily retrieve and use the functions ! here is the wsdl. I have searched a lot and all i find is the opposite. Any help will be appreciated. Let's block ads! بخوانید...

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

So I was following this tutorial: https://msdn.microsoft.com/en-us/library/windows/desktop/hh127427(v=vs.85).aspx when I cam across the sentence that casually says "Call the SHChangeNotify function". How do I do this? It is not recognized by powershell. Do I have to import some library in c++ and call it from a c++ program? I am on windows 10. Let's block ads! بخوانید...

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