tianzl66/Sheetpedia huggingface dataset:
Spreadsheet: daren_farmer__5097__04-01-A-T-E Report-Assets
Sheet: A-T-E

GLOBAL ASSETS CONTRACTS - Assignments / Expirations / Terminations
Purchase, Sale and Service Contracts
2001-03-23 00:00:00
Type | Enron Entity | Existing C/P name | New C/P name | Contract Type | Global Contract # | New Global Contract # | Effective Date | [NAME] | Jurisdiction | Comments
Assignment | HPL | Union Pacific Resources Company | RME Petroleum Company | Transportation | 96006360 | n/a | 2001-03-13 00:00:00 |  |  | Name was overlayed by GCP 3/13/01 due to name change from Union to RME.
Assignment | HPL | Union Pacific Resources Company | RME Petroleum Company | Transportation | 96006356 | n/a | 2001-03-13 00:00:00 |  |  | Name was overlayed by GCP 3/13/01 due to name change from Union to RME.
Assignment | HPL | Union Pacific Resources Company | RME Petroleum Company | First Pur Ded Res | 96001877 | n/a | 2001-03-13 00:00:00 |  |  | Name was overlayed by GCP 3/13/01 due to name change from Union to RME.
Assignment | HPL | Union Pacific Resources Company | RME Petroleum Company | Other | 96001873 | n/a | 2001-03-13 00:00:00 |  |  | Facilities Agreement.  [NAME] was overlayed by GCP 3/13/01 due to name change from Union to RME.
Termination | HPL | Engelhard Corporation | Engelhard Corporation | GTC Sale Firm | 96049489 | 96057664 | 2000-11-01 00:00:00 | 8009 |  | Use 96057664, [NAME], effective 11/1/00.
Spreadsheet: eric_saibi__9716__010702
Sheet: Craig 02

Owner Name |  | Tri-State Generation
Station Name |  | Craig Power Station
Unit Name |  | [NAME] 02
NERC Region |  | WSCC
State |  | CO
Fuel Type |  | Coal
Capacity |  | 446 MW
Start Date |  | 2002-01-05 00:00:00
End Date |  | 2002-01-13 00:00:00
Comments |  | [NAME]
SIC |  | 4911
Plant ID |  | 1015365
Unit ID |  | 1007178
Outage ID |  | 19385
Spreadsheet: 2f57641e-d06d-4913-b08f-c3ab3085b539
Sheet: Sheet1

FINANCIAL RATIO CALCULATORS | Unnamed: 1 | Unnamed: 2 | Unnamed: 3 | Unnamed: 4 | Unnamed: 5 | Unnamed: 6 | Unnamed: 7 | Unnamed: 8
 |  |  |  |  |  |  |  | Actual
Traditional Debt Service Coverage
Net Profit | + |  |  | Principal Payments | +
Depreciation | + |  |  | Interest | + | 0
Amortization | + |  |  | Rent to Affiliates | + | 0
Interest | + |  | /
Rent to Affiliates | +
Distributions | - |  |  | <---enter as a negative
A/R & Adv Affiliates (Current) | - | 0 |  | <---pulled from Related Party Table below
Advances to Stockholders | - | 0 |  | <---pulled from Related Party Table below
Advances to Officers | - | 0 |  | <---pulled from Related Party Table below
Advances to Affiliates | - | 0 |  | <---pulled from Related Party Table below
 | Available for Debt Service | 0 | / |  | Total Payments | 0
 |  | Debt Service Coverage |  |  | =
Related Party Advances
 |  | Beginning |  | Ending |  | Advances
A/R & Adv Affiliates (Current) |  |  | - |  | = | 0
Advances to Stockholders |  |  | - |  | = | 0
Advances to Officers |  |  | - |  | = | 0
Advances to Affiliates |  |  | - |  | = | 0
Totals |  | 0 | - | 0 | = | 0 |  | 0
Working Capital/Current Ratio
 | - | 0 | - |  | = | 0 |  | 0
Current Assets | - | A/R Affiliates | - | Current Liabilites |  | Working Capital
 |  |  |  | Current Ratio | =
[NAME]
 | - |  | - | 0 | = | 0 |  | 0
Net Worth | - | Intangibles | - | A/R Affiliates |  | [NAME]
Debt-to-Tangible Net Worth
 |  | 0 |  |  | =
Total Liabilities | / | [NAME] |  |  |  | Debt / TNW
Unsubordinated debt-to-effective captial
0 |  |  | = | 0
Total Liabilities | - | Subordinated Debt
0 |  | 0 | = | 0 | =
[NAME] | + | Subordinated Debt
Inventory Days on Hand
 |  |  | = | 0
Inventory at end of period | * | Number of days into period |  |  | / | Cost of Goods Sold
 |  |  |  |  | =
 |  |  |  |  |  | Inventory Days on Hand
Account Receivable Days
 |  |  | = | 0
A/R at end of period | * | Number of days into period |  |  | / | Sales
 |  |  |  |  | =
 |  |  |  |  |  | A/R Days on Hand
Account Payable Days
 |  |  | = | 0
A/P at end of period | * | Number of days into period |  |  | / | Cost of Sales
 |  |  |  |  | =
 |  |  |  |  |  | A/P Days on Hand
Spreadsheet: 836357d1689302710-need-help-fixing-formula-to-check-if-date-is-in-current-month-major-minor-system
Sheet: INDEX

SELECT EMPLOYEE |  |  | DATE | NAME | MANAGER | [NAME] | LEVEL
Person 1 |  |  |  | Person 1 |  | Arrived at work late. (Less than 10 minutes) | Minor
 |  |  | 2023-07-08 00:00:00 | Person 1 |  | Arrived at work late. (Less than 10 minutes) | Minor
Minors this Month |  |  | 2023-07-07 00:00:00 | Person 1 | Manager 1 | Arrived at work late. (Less than 10 minutes) | Minor
Majors this Month |  |  | 2023-06-10 00:00:00 | Person 1 |  | Arrived at work late. (Less than 10 minutes) | Minor
 |  |  | 2023-02-02 00:00:00 | Person 1 | Manager 2 | Arrived at work late. (Less than 10 minutes) | Minor
 |  |  | 2023-01-11 00:00:00 | Person 1 |  | Did not show up for shift. (No contact) | Major
 |  |  | 2023-01-06 00:00:00 | Person 1 |  | Did not show up for shift. (No contact) | Major
 |  |  | 2023-01-05 00:00:00 | Person 1 | Manager 1 | Did not show up for shift. (No contact) | Major
 |  |  | 2023-01-04 00:00:00 | Person 1 | Manager 2 | Arrived at work late. (Less than 10 minutes) | Minor
TOTAL MINORS |  |  | 2023-01-01 00:00:00 | Person 1 | Manager 1 | Did not show up for shift. (No contact) | Major
TOTAL MAJORS
 |  |  |  |  | 2023-06-16 00:00:00
 |  |  |  |  | 2023-07-03 00:00:00
 |  |  |  |  | 2023-08-30 00:00:00
 |  |  |  |  | 2022-07-05 00:00:00
 |  |  |  |  | 2022-07-06 00:00:00
Spreadsheet: 81180d1281443935-copy-text-from-one-sheet-to-another-using-macro-request-form-template2
Sheet: Central Funding Invoice

 |  |  |  | Rectangle Group PLC, The Rectangle
 |  |  |  | 57 Grove Road
 |  |  |  | Harrogate
 |  |  |  | HG1 5EP
 |  |  |  | 01423 877100
 |  | Store Name: | Sainsbury's (Kettering)
 |  | Store Number: | 628
 |  | Date: | 2010-08-10 12:26:51
 |  | Address:
 |  | Post Code:
 |  | Costs:
 |  | [NAME] | Permanent |  | 0
 |  |  | Cost Per Hour | Total | Hours
 |  | Cost of Agent | 18 | 4464 | 248 | 4464
 |  | Total | 4464
 |  | Central Funding |  |  | 504
 |  | Total to be charge to Central funding |  | 28 | 504
 |  | [NAME]
 |  | Financial Director         Rectangle Group PLC
Spreadsheet: 815841d1675232999-unique-filter-sort-and-sumproduct-or-counta-all-together-unique_filter_sort_dynamic_array
Sheet: Sheet1

 |  |  |  | CUSTOMER | Status |  | CUSTOMER | TOTAL PAID | TOTAL PENDING
 |  |  |  | Customer A | Paid
 |  |  |  | Customer B | Paid |  | Customer B
 |  |  |  | Customer C | Pending |  | Customer C
 |  |  |  | Customer B | Pending
 |  |  |  | Customer C | Paid
 |  |  |  | Customer A | Paid
 |  |  |  | Customer A | Pending
 |  |  |  | Customer A | Paid
 |  |  |  | Customer A | Pending
 |  |  |  | Customer A | Pending
 |  |  |  | Customer A | Pending
 |  |  |  | Customer A | Pending
 |  |  |  | Customer C | Pending
 |  |  |  | Customer B | Pending
 |  |  |  | Customer B | Pending
 |  |  |  | Customer B | Pending
 |  |  |  | Customer A | Paid
 |  |  |  | Customer A | Pending
 |  |  |  | Customer C | Paid
 |  |  |  | Customer C | Paid
Spreadsheet: 267388d1380060157-index-match-vlookup-if-then-help-example-new-1
Sheet: Sheet1

Code | FANO | NSP2 | City
1608TEN
1613TEN
1614REY
1617REY
1620TEN
1626TEN
1627-29FOR
1631TEN
1632TEN
1637TEN
1638TEN
1644TEN
1703FOR
1707TEN
1708FOR
1708TEN
1711DES
1714TEN
1717-19DES
1720TEN
1724DES
1728REY
1735DES
1737TEN
1738REY
1744TEN
1807TEN
1809DES
1810REY
1813TEN
1814TEN
1815JOU
1817REY
1819TEN
1825TEN
1826REY
1826TEN
1827DES
1827JOU
1832DES
1835FOR
1843TEN
1845DES
1901DES
1901TEN
1904DES
1905DES
1907JOU
1910REY
1913DES
1914TEN
1919TEN
1925DES
1926REY
1927FOR
1932DES
1932REY
1937TEN
1938DES
1938TEN
1943TEN
1944TEN
2008TEN
2026TEN
4813PRI
4850DER
4934PRI
5005DER
5012DER
5018PRI
5019-21PRI
5035DER
1750TEN
1918DES
2014TEN
2019TEN
4819PRI
1607JOU
1744REY
1617-19JOU
5014ROM
1911DES
1818REY
Spreadsheet: 111884d1308146249-help-with-formula-if-and-and-statements-equation
Sheet: Sheet2

want to create a formula that will give me the correct
"Kz" value (yellow box) based on the main roof height and exposure category
Mean roof height & catergory are set up as lists. I want the "kz" value to automatically update with a change in exposure category and mean roof height
 |  |  |  |  |  |  | VELOCITY PRESSURE EXP. COEF. "KZ"
Exposure Category |  | = | Exposure B |  |  |  | Height (ft) | Exposure B | Exposure C
Mean [NAME] |  | = | 20 | ft |  |  | 20 | 0.7 | 1.1
 |  |  |  |  |  |  | 40 | 0.9 | 1.2
Velocity Pressure Exp. [NAME]. (Kz) |  | = | "kz" Value equation?? |  | what is "Kz" value if exposure C, with mean roof height of 40ft
Spreadsheet: 70163d1270854462-is-it-possible-to-have-excel-do-an-automated-break-schedule-for-work-newbreakschedule
Sheet: Break Overview

Meal/ [NAME] |  |  | 3.5 - 6 hrs - One 15 min break
 |  |  | 6.5 - 7 hrs - One 15 min break & one 30 min meal
 |  |  | 7.5 hrs or more - Two 15 min breaks &one 30 min meal
Day/Date:
Your MODs:
Zone | Name | Schdeule | 1st break | Meal | 2nd Break | Breaker
[NAME].
[NAME]
Dockers
Lingerie
Catalog
Womens Acc.
Traditionals
Womens Petites
Area
Home
Kids
Kids Zone
Shoes
Jewelry
Windows
Furniture
Fitting Rooms
Breakers
Spreadsheet: 113621d1309457987-making-a-table-with-id-rows-and-dates-as-columns-reorgdata-brewingcoder-ef782393-sdg12
Sheet: Sheet1

ID | Date | Value
1232 | 200405 | 2.39
1938 | 200608 | 2.59
1232 | 201003 | 5.39
1715 | 200109 | 6.34
1938 | 200406 | 8.23
 |  |  |  |  |  |  |  |  |  |  |  | ReorgData - BrewingCoder - EF782393 - SDG12.xls
 |  |  |  |  |  |  |  |  |  |  |  | Making a table with ID rows and [NAME] as columns
 |  |  |  |  |  |  |  |  |  |  |  | http://www.excelforum.com/excel-general/782393-making-a-table-with-id-rows-and-dates-as-columns.html
 |  |  |  |  |  |  |  |  |  |  |  | Hi Excel users...I have no idea why this is causing me so much trouble.
 |  |  |  |  |  |  |  |  |  |  |  | All I normally use are [NAME] tables to sum data,
 |  |  |  |  |  |  |  |  |  |  |  | but for the life of me I can not create a table to show values only.
 |  |  |  |  |  |  |  |  |  |  |  | The data I have is in this format:
 |  |  |  |  |  |  |  |  |  |  |  | ID Date Value | ID | Date | Value |  | ID | Date | Value
 |  |  |  |  |  |  |  |  |  |  |  | 1232 200405 2.39 | 1232 | 200405 | 2.39 |  | 1232 | 200405 | 2.39
 |  |  |  |  |  |  |  |  |  |  |  | 1938 200608 2.59 | 1938 | 200608 | 2.59 |  | 1938 | 200608 | 2.59
 |  |  |  |  |  |  |  |  |  |  |  | 1232 201003 5.39 | 1232 | 201003 | 5.39 |  | 1232 | 201003 | 5.39
 |  |  |  |  |  |  |  |  |  |  |  | 1715 200109 6.34 | 1715 | 200109 | 6.34 |  | 1715 | 200109 | 6.34
 |  |  |  |  |  |  |  |  |  |  |  | 1938 200406 8.23 | 1938 | 200406 | 8.23 |  | 1938 | 200406 | 8.23
 |  |  |  |  |  |  |  |  |  |  |  | and so forth
 |  |  |  |  |  |  |  |  |  |  |  | The date is formatted with the year followed by the month number.
 |  |  |  |  |  |  |  |  |  |  |  | As you can see, there are duplicate IDs.
 |  |  |  |  |  |  |  |  |  |  |  | How can I create a table that collapses all the same ID numbers
 |  |  |  |  |  |  |  |  |  |  |  | into the same row and uses the dates as columns, with the values corresponding to the ID and date?
 |  |  |  |  |  |  |  |  |  |  |  | Thanks!
Spreadsheet: 104327d1301956254-returning-additional-data-from-existing-code-sample
Sheet: Sheet1

 |  | 3 |  |  |  | DESIRED RESULTS
35 | 1.018192869898441 | 29.75 |  |  |  | 29.75
30 | 1.025448882436612 | 11.5 |  |  |  | 20
29.75 | 1.028745872816569 | 0 |  |  |  | 11.5
25 | 0.6804720337632341 |  |  | LS |  | 0
20 | 0.690285527119395
15 | 0.699487540024351 |  |  | LS
11.5 | 0.7055999924956381
10 | 0.6654174591260951
5 | 0.6738009556098922
0 | 0.6817500340105295
Spreadsheet: phillip_m_love__31150__InventoryMichCon
Sheet: InvP&L

Inventory Profit and Loss
Production Month | Michcon |  |  |  |  | [NAME] |  |  |  |  | Bistineau |  |  |  |  | Spindletop |  |  |  |  | Napoleonville
 | W/D Volume | Desk Price | Inventory Price | P/L |  | W/D Volume | Desk Price | Inventory Price | P/L |  | W/D Volume | Desk Price | Inventory Price | P/L |  | W/D Volume | Desk Price | Inventory Price | P/L |  | W/D Volume | Desk Price | Inventory Price | P/L | Total
2001-04-01 00:00:00
2001-05-01 00:00:00
2001-06-01 00:00:00
2001-07-01 00:00:00
2001-08-01 00:00:00
2001-09-01 00:00:00
2001-10-01 00:00:00
2001-11-01 00:00:00
2001-12-01 00:00:00
2002-01-01 00:00:00
2002-02-01 00:00:00
2002-03-01 00:00:00
2002-04-01 00:00:00
Spreadsheet: 722624d1615334806-sum-time-not-adding-up-test
Sheet: Sheet1

DAILY SHIFT TRACKER |  |  |  |  |  |  |  |  |  |  | 2021
NAME: |  |  |  |  |  |  |  | SHIFT LENGTH: |  |  | 08:15:00
JANUARY |  |  |  |  |  |  | FEBRUARY
D | SHIFT | START | END | TOTAL | OT |  | D | SHIFT | START | END | TOTAL | OT
1 | 1800X0215 | 18:00:00 | 1:15:00 |  |  |  | 1
2 | 1735X0150 | 17:35:00 | 6:30:00 |  |  |  | 2
3 | 1805X0220 | 18:05:00 | 3:45:00 |  |  |  | 3
4 | 1850X0305 | 20:20:00 | 3:05:00 |  |  |  | 4
5 | RDO | 0:00:00 | 0:00:00 |  |  |  | 5
6 | RDO | 0:00:00 | 0:00:00 |  |  |  | 6
7 | 0740X1555 | 7:40:00 | 19:25:00 |  |  |  | 7
8 | 1025X1840 | 10:25:00 | 18:40:00 |  |  |  | 8
9 | 0750X1605 | 7:50:00 | 18:50:00 |  |  |  | 9
10 | 0:00:00 | 0:00:00 | 0:00:00 |  |  |  | 10
11 | 0:00:00 | 0:00:00 | 0:00:00 |  |  |  | 11
12 | 0:00:00 | 0:00:00 | 0:00:00 |  |  |  | 12
13 | 0:00:00 | 0:00:00 | 0:00:00 |  |  |  | 13
14 | 0:00:00 | 0:00:00 | 0:00:00 |  |  |  | 14
15 | 0:00:00 | 0:00:00 | 0:00:00 |  |  |  | 15
16 | 0:00:00 | 0:00:00 | 0:00:00 |  |  |  | 16
17 | 0:00:00 | 0:00:00 | 0:00:00 |  |  |  | 17
18 | 0:00:00 | 0:00:00 | 0:00:00 |  |  |  | 18
19 | 0:00:00 | 0:00:00 | 0:00:00 |  |  |  | 19
20 | 0:00:00 | 0:00:00 | 0:00:00 |  |  |  | 20
21 | 0:00:00 | 0:00:00 | 0:00:00 |  |  |  | 21
22 | 0:00:00 | 0:00:00 | 0:00:00 |  |  |  | 22
23 | 0:00:00 | 0:00:00 | 0:00:00 |  |  |  | 23
24 | 0:00:00 | 0:00:00 | 0:00:00 |  |  |  | 24
25 | 0:00:00 | 0:00:00 | 0:00:00 |  |  |  | 25
26 | 0:00:00 | 0:00:00 | 0:00:00 |  |  |  | 26
27 | 0:00:00 | 0:00:00 | 0:00:00 |  |  |  | 27
28 | 0:00:00 | 0:00:00 | 0:00:00 |  |  |  | 28
29 | 0:00:00 | 0:00:00 | 0:00:00
30 | 0:00:00 | 0:00:00 | 0:00:00
31 | 0:00:00 | 0:00:00 | 0:00:00
TOTAL OVERTIME: |  |  |  |  |  |  | TOTAL OVERTIME:
[NAME] |  |  |  |  |  |  | APRIL
D | SHIFT | START | END | TOTAL | OT |  | D | SHIFT | START | END | TOTAL | OT
1 |  |  |  |  |  |  | 1
2 |  |  |  |  |  |  | 2
3 |  |  |  |  |  |  | 3
4 |  |  |  |  |  |  | 4
5 |  |  |  |  |  |  | 5
6 |  |  |  |  |  |  | 6
7 |  |  |  |  |  |  | 7
8 |  |  |  |  |  |  | 8
9 |  |  |  |  |  |  | 9
10 |  |  |  |  |  |  | 10
11 |  |  |  |  |  |  | 11
12 |  |  |  |  |  |  | 12
13 |  |  |  |  |  |  | 13
14 |  |  |  |  |  |  | 14
15 |  |  |  |  |  |  | 15
16 |  |  |  |  |  |  | 16
17 |  |  |  |  |  |  | 17
18 |  |  |  |  |  |  | 18
19 |  |  |  |  |  |  | 19
20 |  |  |  |  |  |  | 20
21 |  |  |  |  |  |  | 21
22 |  |  |  |  |  |  | 22
23 |  |  |  |  |  |  | 23
24 |  |  |  |  |  |  | 24
25 |  |  |  |  |  |  | 25
26 |  |  |  |  |  |  | 26
27 |  |  |  |  |  |  | 27
28 |  |  |  |  |  |  | 28
29 |  |  |  |  |  |  | 29
30 |  |  |  |  |  |  | 30
31
TOTAL OVERTIME: |  |  |  |  |  |  | TOTAL OVERTIME:
Spreadsheet: 39848d1238104629-excel-clothes-and-dragon-naturally-speaking-report
Sheet: example 1

 |  |  |  |  | Supplier |  |  |  |  |  |  |  |  | Date              /           /
 |  |  |  |  | Client |  |  |  |  |  | Order |  |  | Style
 |  |  |  |  | Description |  |  |  |  |  |  |  |  | Del. date       /           /
 |  |  |  |  | XS |  |  | S |  |  | M |  |  | L |  |  | XL
 | CHEST WIDH |  |  |  | 44 |  |  | 46 | -1 |  | 48.5 |  |  | 51.5 |  |  | 54.5
 | SHOULDER |  |  |  | 38.5 |  |  | 40 | +0.5 |  | 42 |  |  | 44 |  |  | 46
 | ARMHOLE |  |  |  | 18 |  |  | 18.5 | -1 |  | 19.5 |  |  | 20.5 |  |  | 21.5
 | BOTTOM WIDTH |  |  |  | 43.5 |  |  | 45.5 | -1.5 |  | 48 |  |  | 51 |  |  | 54
 | CUFF WIDTH |  |  |  | 10 |  |  | 10.5 | √ |  | 11 |  |  | 11.5 |  |  | 12
 | LENGTH FROM BACK |  |  |  | 55 |  |  | 56 | +3 |  | 57.5 |  |  | 59 |  |  | 60.5
 | WAIST |  |  |  | 39 |  |  | 41 | +2 |  | 43.5 |  |  | 46.5 |  |  | 49.5
 | SLEEVE LENGTH |  |  |  | 58 |  |  | 58.5 | √ |  | 59 |  |  | 59.5 |  |  | 60
 | BACK NECK WIDTH |  |  |  | 20.5 |  |  | 21 | -0.5 |  | 21.5 |  |  | 22 |  |  | 22.5
 | FRONT NECK DROP |  |  |  | 10 |  |  | 10 | -0.5 |  | 10 |  |  | 10 |  |  | 10
 | COLLAR HEIGHT |  |  |  | 3.5 |  |  | 3.5 | √ |  | 3.5 |  |  | 3.5 |  |  | 3.5
 | Make up/Construction |  |  | Material |  |  |  |  | Colours |  |  |  | [NAME] |  |  | Hangtags
 | Folding/Packing |  |  | [NAME]
 | Qty available            pcs |  |  |  |  | Qty checked            pcs |  |  |  |  |  |  | Rejected            pcs
 |  | Final decision: |  | ACCEPT |  |  |  | REJECT |  |  |  | REINSPECT
 | Comments:
 | Order checked by |  |  |  |  |  |  |  |  | Supplier
 | This report does not relieve the suppliers responsability for defects found on the merchandise shipped
 | Este relatório não iliba o fabricante da responsabilidade por defeitos encontrados [NAME]
Spreadsheet: 53516d1253431072-form-button-question-book1
Sheet: Sheet1

[NAME] | column2 | column3 | column4 | column5 | [NAME] | column7 | column8 | column9 | column10 | column11 | column12 | [NAME] | [NAME] | column15 | column16
a | Data 6 2 | Data 6 3 | Data 6 4 | Data 6 5 | Data 6 6 | Data 6 7 | Data 6 8 | Data 6 9 | Data 6 10 | Data 6 11 | Data 6 12 | Data 6 13 | Data 6 14 | Data 6 15 | Data 6 16
 | Data 7 2 | Data 7 3 | Data 7 4 | Data 7 5 | Data 7 6 | Data 7 7 | Data 7 8 | Data 7 9 | Data 7 10 | Data 7 11 | Data 7 12 | Data 7 13 | Data 7 14 | Data 7 15 | Data 7 16
a | Data 6 | Data 7 | Data 8 | Data 9 | Data 10 | Data 11 | Data 12 | Data 13 | Data 14 | Data 15 | Data 16 | Data 17 | Data 18 | Data 19 | Data 20
 | Data 6 | Data 7 | Data 8 | Data 9 | Data 10 | Data 11 | Data 12 | Data 13 | Data 14 | Data 15 | Data 16 | Data 17 | Data 18 | Data 19 | Data 20
a | Data 6 | Data 7 | Data 8 | Data 9 | Data 10 | Data 11 | Data 12 | Data 13 | Data 14 | Data 15 | Data 16 | Data 17 | Data 18 | Data 19 | Data 20
 | Data 6 | Data 7 | Data 8 | Data 9 | Data 10 | Data 11 | Data 12 | Data 13 | Data 14 | Data 15 | Data 16 | Data 17 | Data 18 | Data 19 | Data 20
Spreadsheet: 297740d1392563177-need-help-to-calculate-incentives-book1
Sheet: Sheet1

 |  |  |  | Desired output
Emp id | Actual | Target | Achievement | 90%-100% | 100%-110% | 110%-125% | Above 125% | Total |  | Look up table
E101 | 1000 | 1000 |  | 750 | 0 | 0 | 0 |  |  | Target Achievement | Eligible Range | Amount
E102 | 1100 | 1000 |  | 750 | 100 | 0 | 0 |  |  | Below 90% | Not Eligible | 0
E103 | 1100 | 1200 |  | 825.03 | 0 | 0 | 0 |  |  | 90%-100% | 1%-100% | 0.75
E104 | 1300 | 1000 |  | 750 | 100 | 225 | 100 |  |  | 100%-110% | 1% - 10% | 1
E105 | 800 | 1000 |  | 0 | 0 | 0 | 0 |  |  | 110%-125% | 1% - 15% | 1.5
E106 | 1250 | 1000 |  | 750 | 100 | 225 | 0 |  |  | Above 125% | Difference from 125% | 2
Spreadsheet: 874835d1721341890-count-block-of-empty-cells-within-range-urenadministratie
Sheet: Sheet1

 |  | Begin | lunch | Eind | Werkuren | [NAME] rust | Reden overtreding
2024-01-01 00:00:00 | Maandag | 09:00:00 | 00:30:00 | 17:00:00
2024-01-02 00:00:00 | Dinsdag | 06:30:00 | 00:30:00 | 20:30:00
2024-01-03 00:00:00 | Woensdag | 12:00:00 | 01:00:00 | 04:00:00
2024-01-04 00:00:00 | Donderdag | 08:00:00 | 00:30:00 | 16:00:00
2024-01-05 00:00:00 | Vrijdag | 09:00:00 | 00:30:00 | 13:00:00
2024-01-06 00:00:00 | Zaterdag | 06:00:00 | 01:00:00 | 23:00:00
2024-01-07 00:00:00 | Zondag
Totaal
2024-01-08 00:00:00 | Maandag | 09:00:00 | 00:30:00 | 17:00:00
2024-01-09 00:00:00 | Dinsdag | 06:30:00 | 00:00:00 | 18:00:00
2024-01-10 00:00:00 | Woensdag | 09:00:00 | 00:00:00 | 13:00:00
2024-01-11 00:00:00 | Donderdag | 09:00:00 | 00:00:00 | 13:00:00
2024-01-12 00:00:00 | Vrijdag | 09:00:00 | 00:00:00 | 13:00:00
2024-01-13 00:00:00 | Zaterdag | 06:00:00 | 01:00:00 | 23:00:00
2024-01-14 00:00:00 | Zonderdag
Totaal
2024-01-15 00:00:00 | Maandag | 09:00:00 | 00:00:00 | 14:00:00
2024-01-16 00:00:00 | Dinsdag
2024-01-17 00:00:00 | Woensdag
2024-01-18 00:00:00 | Donderdag
2024-01-19 00:00:00 | Vrijdag
2024-01-20 00:00:00 | Zaterdag
2024-01-21 00:00:00 | Zonderdag
Totaal
2024-01-22 00:00:00 | Maandag
2024-01-23 00:00:00 | Dinsdag
2024-01-24 00:00:00 | Woensdag
2024-01-25 00:00:00 | Donderdag
2024-01-26 00:00:00 | Vrijdag
2024-01-27 00:00:00 | Zaterdag
2024-01-28 00:00:00 | Zonderdag
Totaal
2024-01-29 00:00:00 | Maandag
2024-01-30 00:00:00 | Dinsdag
2024-01-31 00:00:00 | Woensdag
2024-02-01 00:00:00 | Donderdag
2024-02-02 00:00:00 | Vrijdag
2024-02-03 00:00:00 | Zaterdag
2024-02-04 00:00:00 | Zonderdag
Spreadsheet: 757768d1638450813-filter-formula-over-multiple-sheets-permit-register-example-2-12-2021
Sheet: BP

ABC Job Number | Address | Description | Client | Date of Confirmation  to Proceed | Permit  Number | BUILDING PERMIT | Job Notes
 | Address 23 | Description 23 | Client 23 | 2021-04-27 00:00:00 | 00:00:00 | BP | 00:00:00
ABC-21024 | Address 24 | Description 24 | Client 24 | 2021-04-28 00:00:00 | 00:00:00 | BP | 00:00:00
ABC-21025 | Address 25 | Description 25 | Client 25 | 2021-04-29 00:00:00 | 00:00:00 | BP | 00:00:00
Spreadsheet: 287434d1388785766-copying-from-pdf-into-excel-boom
Sheet: Sheet1

2013
November
2012
November
QTD
2013
November
QTD
2012
November
YTD
2013
November
YTD
2012
November
REGULAR WAGES-SALARY $46,298.19 $83,290.29 $93,141.14 $172,377.16 $543,012.75 $773,881.77
WAGES OVERTIME 325.57 486.92 1,712.84 4,938.69 21,013.31 33,068.78
PTO 4,215.98 4,129.26 8,696.92 8,831.46 33,576.35 44,015.03
HOLIDAY 0.00 0.00 0.00 0.00 15,864.70 18,659.59
OTHER TIME BASED COMPENSATION 313.96 0.00 609.96 224.00 3,140.26 3,352.93
COMMISSIONS 0.00 6,922.30 0.00 15,415.73 13,943.76 41,603.78
OTHER COMP - WELLNESS REWARDS 0.00 0.00 484.00 0.00 3,278.00 0.00
OTHER COMPENSATION 2,975.10 300.00 5,210.91 635.40 24,640.49 6,394.14
BONUS 0.00 0.00 0.00 0.00 6,250.00 0.00
BONUS (NON-AIP) 0.00 0.00 0.00 0.00 0.00 4,500.00
PAYROLL TAXES 4,097.84 8,406.53 8,334.42 17,829.40 61,718.91 92,735.72
GROUP INSURANCE 8,997.27 11,058.63 18,026.09 21,869.62 124,485.58 89,700.91
PERSONNEL 67,223.91 114,593.93 136,216.28 242,121.46 850,924.11 1,107,912.65
OFFICE SUPPLIES 0.00 0.00 14.23 0.00 203.24 11.39
OFFICE EXPENSE - PRINTING 0.00 0.00 14.23 0.00 203.24 11.39
COMPUTER SUPPLIES 0.00 0.00 8.22 0.00 532.71 956.69
DATA PROCESSING 0.00 0.00 8.22 0.00 532.71 956.69
SALES EXPENSE-PROMO GIFTS 0.00 0.00 0.00 135.00 1,355.81 615.20
SALES EXPENSE 0.00 0.00 0.00 135.00 1,355.81 615.20
TRAVEL & COMPANY MEETINGS 0.00 432.30 0.00 432.30 4,169.48 3,554.90
50% TRAVEL & COMPANY MEETING 0.00 301.68 0.00 301.68 1,370.18 1,868.35
TRAVEL-COMPANY MEETINGS 0.00 733.98 0.00 733.98 5,539.66 5,423.25
AUTO OPERATING EXPENSE 0.00 0.00 0.00 0.00 154.42 250.30
AUTO EXPENSE 0.00 0.00 0.00 0.00 154.42 250.30
LICENSES & FEES OTHER 0.00 0.00 0.00 0.00 6.00 0.00
LICENSES & FEES 0.00 0.00 0.00 0.00 6.00 0.00