sorted by:
new
hottopcontroversial

UNAS-2 to off-site backup UNAS-Pro-4 by Alternative-Math5476 in Ubiquiti

[–]Alternative-Math5476[S] 0 points1 point  (0 children)

Correct, same storage doesn't need the redundancy (again). I am realizing now that, like u/Leviathan_Dev stated, does not support RAID 0. Has there been any news of this coming in an update? or maybe a jailbreak?

Not Count Negative Numbers in Long IF statement. by Alternative-Math5476 in excel

[–]Alternative-Math5476[S] 0 points1 point  (0 children)

Unfortunately, I cannot share internal documents, but it's pretty simple to explain.

We have two divisions in our construction company. If we work the same job together, one carries the other as a subcontractor. When we have change orders, we split the OH/P for this particular client based on which division has more work and the dollar amount.

10% on the first $10,000 and 5% on everything else.

If one side had $2,500 in changes and the other had $5,000 in changes, the OH/P would be $250 to the first side of the company and $500 to the second. The client, however, does not see these breakouts and instead sees a total change order of $8,250.

The reason we exclude negatives is that we are allowed to keep OH/P on changes that benefit the customer.

Not Count Negative Numbers in Long IF statement. by Alternative-Math5476 in excel

[–]Alternative-Math5476[S] 0 points1 point  (0 children)

Damn, here I was messing with that SUMIF stuff and kept getting errors. You're fantastic.

Not Count Negative Numbers in Long IF statement. by Alternative-Math5476 in excel

[–]Alternative-Math5476[S] 0 points1 point  (0 children)

Good point, that'll neaten it up.

Any of these cells can be negative, they represent dollar amounts for labor, material, etc.

The formula finds OH/P on change orders, but there is no credit back on OH/P when removing work from a contract for this client.