A formula for your entertainment (that calculates what an employee would be entitled to for stat pay):
=IF(A3<>"",(IF(((((COUNTIFS('All (Span)'!A:A,A3,'All (Span)'!H:H,">=8"))*8)+(SUMIFS('All (Span)'!H:H,'All (Span)'!A:A,A3,'All (Span)'!H:H,"<8")))*0.05)>8,8,(((COUNTIFS('All (Span)'!A:A,A3,'All (Span)'!H:H,">=8"))*8)+(SUMIFS('All (Span)'!H:H,'All (Span)'!A:A,A3,'All (Span)'!H:H,"<8")))*0.05)),"")
Tater /
npub1dn…5ljsv
2024-08-15 16:20:45
in reply to nevent1q…sq3e
Author Public Key
npub1dnuq898usnw7g6tped7mduucwd9sy63z52aj4ra090pwcum0mkcsy5ljsvPublished at
2024-08-15 16:20:45Event JSON
{
"id": "2c8853b425da492154373880fc9df50cb8853d3ab42dabd6c54f384b9f55ad75",
"pubkey": "6cf80394fc84dde46961cb7db6f398734b026a22a2bb2a8faf2bc2ec736fddb1",
"created_at": 1723738845,
"kind": 1,
"tags": [
[
"e",
"f6589e1298e5f7ad11bd6bf11582fa2f21e532de510f9e5ee40cb6adf334647d",
"",
"reply",
"52b8760564993749a04c6aed164426d3aa861456c1decf2f6355fd70b9be9458"
],
[
"p",
"52b8760564993749a04c6aed164426d3aa861456c1decf2f6355fd70b9be9458"
],
[
"p",
"6cf80394fc84dde46961cb7db6f398734b026a22a2bb2a8faf2bc2ec736fddb1"
],
[
"content-warning"
],
[
"proxy",
"https://fosstodon.org/@tatertot/112966948961699110",
"web"
],
[
"p",
"c9985b530d17e39e6cc7c73b635841f53fc2f441bede8b6fff01e3d5e1e1be7d"
],
[
"e",
"7b1d4ec3bddad6b395fbb32386630e43a03360a3d069133ce7f8c3ecf4f49d89",
"",
"root",
"6cf80394fc84dde46961cb7db6f398734b026a22a2bb2a8faf2bc2ec736fddb1"
],
[
"proxy",
"https://fosstodon.org/users/tatertot/statuses/112966948961699110",
"activitypub"
],
[
"L",
"pink.momostr"
],
[
"l",
"pink.momostr.activitypub:https://fosstodon.org/users/tatertot/statuses/112966948961699110",
"pink.momostr"
],
[
"-"
]
],
"content": "A formula for your entertainment (that calculates what an employee would be entitled to for stat pay):\n=IF(A3\u003c\u003e\"\",(IF(((((COUNTIFS('All (Span)'!A:A,A3,'All (Span)'!H:H,\"\u003e=8\"))*8)+(SUMIFS('All (Span)'!H:H,'All (Span)'!A:A,A3,'All (Span)'!H:H,\"\u003c8\")))*0.05)\u003e8,8,(((COUNTIFS('All (Span)'!A:A,A3,'All (Span)'!H:H,\"\u003e=8\"))*8)+(SUMIFS('All (Span)'!H:H,'All (Span)'!A:A,A3,'All (Span)'!H:H,\"\u003c8\")))*0.05)),\"\")",
"sig": "bbe20df4a394b72e65ef9161b9db2216b5fd7b1d60dbb37fb0f2ebdeaa8028051e8fc3a75a75a49972e5efb5c12f96c6c52e44f683fc819bcd531eb2c24213fe"
}