tianzl66/Sheetpedia huggingface dataset:
Spreadsheet: 120551d1315369816-conditional-insertion-of-objets-new-microsoft-office-excel-worksheet
Sheet: Sheet1

 |  | Erection Schedule
 | S.No | Task | Duration | Start | Finish | 2011-11-01 00:00:00
 | 1 | GTG | 30 | 2011-11-01 00:00:00
 | 2 | [NAME] | 45 | 2011-12-02 00:00:00
 | 3 | [NAME] | 30 | 2011-01-17 00:00:00
 | 4 | BOP | 30 | 2011-02-17 00:00:00
Spreadsheet: 104994d1302478163-if-then-functions-sampl-payroll
Sheet: Sampl Payroll

 |  | Check Date | Gross | SS | Med | Fed W/H | State  W/H | FICA  SS | FICA Med | FUTA | SUTA | Net Pay | Total Pd By Comp
 |  | 2010-06-16 00:00:00 | 1035.81 | 64.22 | 15.02 | 150.42 | 56.15 | 64.22 | 15.02 | 8.29 | 23.82
 |  | 2010-06-23 00:00:00 | 1445.71 | 89.64 | 20.96 | 254.37 | 80.74 | 89.64 | 20.96 | 11.57 | 33.25
 |  | This shows my table when an american works
 |  | This is my table when I have seasonal help.
 |  | Dates  Worked | Hrs | Rate | Gross | Check | OT | SS | Med | Fed W/H | State  W/H | [NAME] | Total Pd | Paid
 |  | 6/6-6/12 | 40 | 8 |  | 320 |  |  |  | 29.42 |  |  |  | 2010-06-21 00:00:00
 |  | 6/13-6/19 | 40 | 8 |  | 320 |  |  |  | 29.42 |  |  |  | 2010-06-28 00:00:00
 |  |  | This year I am trying to make it so everyone can be put in the same chart without my having to put "0" in all of the blank spots.  That’s where I was hoping to use an If statemnt. Something to put the "0" in if the tax status number =2
 |  | Employee | Status- Current/Past | Store # | Tax Status  1-All 2- Fed | Week Ending | Hours | Rate | Gross | Check # | SS | Med | Fed | State | FICA SS | FICA Med | FUTA | Net Pay | Date Paid | Total [NAME]
 |  | Name 1 | 1 | 6 | 2 | 2011-01-21 00:00:00 | 19.5 | 7.5 |  | 1234 | 0 | 0 | 9.62 | 0 | 0 | 0 | 0 |  | 2011-01-21 00:00:00
 |  | Name 2 | 1 | 4 | 2 | 2/25 | 34 | 7.25 |  | 1235 | 0 | 0 | 18.39 | 0 | 0 | 0 | 0 |  | 2011-03-08 00:00:00
Spreadsheet: 38054d1236180615-maintenance-schedule-checklist-mod-673980_matthemj2
Sheet: Sheet1 (2)

ITEM | Cycle (weeks) |  |  |  |  | 2009-02-16 00:00:00 | 2009-02-23 00:00:00 | 2009-03-02 00:00:00 | 2009-03-09 00:00:00 | 2009-03-16 00:00:00 | 2009-03-23 00:00:00 | 2009-03-30 00:00:00 | 2009-04-06 00:00:00 | 2009-04-13 00:00:00 | 2009-04-20 00:00:00 | 2009-04-27 00:00:00
1 | 1 |  |  |  |  | OVERDUE | OVERDUE | DONE | X
2 | 2 |  |  |  |  | OVERDUE | OVERDUE | DONE |  | X
3 | 3 |  |  |  |  | OVERDUE | OVERDUE | DONE |  |  | X
4 | 4 |  |  |  |  | OVERDUE | OVERDUE | DONE |  |  |  | X
5 | 7 |  |  |  |  | OVERDUE | OVERDUE | DONE
6 | 1 |  |  |  |  | OVERDUE | OVERDUE | DONE | X | DONE | X
7 | 9 |  |  |  |  | OVERDUE | OVERDUE | DONE
8 | 7 |  |  |  |  | OVERDUE | OVERDUE | DONE
9 | 2 |  |  |  |  | OVERDUE | OVERDUE | DONE |  | DONE |  | X
10 | 7 |  |  |  |  | OVERDUE | OVERDUE | DONE
11 | 3 |  |  |  |  | OVERDUE | OVERDUE | DONE |  |  | X
12 | 1 |  |  |  |  | OVERDUE | OVERDUE | DONE | X
13 | 6 |  |  |  |  | OVERDUE | OVERDUE | DONE
14 | 1 |  |  |  |  | OVERDUE | OVERDUE | DONE | X
15 | 2 |  |  |  |  | OVERDUE | OVERDUE | DONE |  | X
16 | 6 |  |  |  |  | OVERDUE | OVERDUE | DONE
17 | 6 |  |  |  |  | OVERDUE | OVERDUE | DONE
18 | 3 |  |  |  |  | OVERDUE | OVERDUE | DONE |  | DONE |  |  | X
19 | 1 |  |  |  |  | OVERDUE | OVERDUE | DONE | X
20 | 4 |  |  |  |  | OVERDUE | OVERDUE | DONE |  |  |  | X
21 | 9 |  |  |  |  | OVERDUE | OVERDUE | DONE
22 | 2 |  |  |  |  | OVERDUE | OVERDUE | DONE |  | X
23 | 2 |  |  |  |  | OVERDUE | OVERDUE | DONE |  | X
24 | 4 |  |  |  |  | OVERDUE | OVERDUE | DONE |  |  |  | X
25 | 1 |  |  |  |  | OVERDUE | OVERDUE | DONE | X
26 | 1 |  |  |  |  | OVERDUE | OVERDUE | DONE | X
27 | 3 |  |  |  |  | OVERDUE | OVERDUE | DONE |  |  | X
28 | 5 |  |  |  |  | OVERDUE | OVERDUE | DONE
29 | 6 |  |  |  |  | OVERDUE | OVERDUE | DONE
30 | 1 |  |  |  |  | OVERDUE | OVERDUE | DONE | X
31 | 5 |  |  |  |  | OVERDUE | OVERDUE | DONE
32 | 8 |  |  |  |  | OVERDUE | OVERDUE | DONE
33 | 8 |  |  |  |  | OVERDUE | OVERDUE | DONE
34 | 3 |  |  |  |  | OVERDUE | OVERDUE | DONE |  |  | X
35 | 5 |  |  |  |  | OVERDUE | OVERDUE | DONE
36 | 8 |  |  |  |  | OVERDUE | OVERDUE | DONE
37 | 5 |  |  |  |  | OVERDUE | OVERDUE | DONE
38 | 2 |  |  |  |  | OVERDUE | OVERDUE | DONE |  | X
39 | 8 |  |  |  |  | OVERDUE | OVERDUE | DONE
40 | 5 |  |  |  |  | OVERDUE | OVERDUE | DONE
41 | 8 |  |  |  |  | OVERDUE | OVERDUE | DONE
42 | 3 |  |  |  |  | OVERDUE | OVERDUE | DONE |  |  | X
43 | 1 |  |  |  |  | OVERDUE | OVERDUE | DONE | X
44 | 1 |  |  |  |  | OVERDUE | OVERDUE | DONE | X
45 | 7 |  |  |  |  | OVERDUE | OVERDUE | DONE
46 | 9 |  |  |  |  | OVERDUE | OVERDUE | DONE
47 | 6 |  |  |  |  | OVERDUE | OVERDUE | DONE
48 | 8 |  |  |  |  | OVERDUE | OVERDUE | DONE
49 | 8 |  |  |  |  | OVERDUE | OVERDUE | DONE
50 | 1 |  |  |  |  | OVERDUE | OVERDUE | DONE | X
Spreadsheet: 164758d1340884159-excel-2007-trying-to-build-a-time-sheet-work-book-and-am-stuck-on-seperating-the-day-and-night-shift-new-project-pay-roll-and-time-sheet-beta-day-night-test-1
Sheet: Monday Timesheeet

 |  |  | TRI TOOL INC.
 | Customer: |  |  |  |  |  |  |  |  | CUSTOMER CONTACT: |  |  |  |  |  | JOB NO: |  |  |  |  |  | Home Page
 | Work Location: |  |  |  |  |  |  |  |  | CUST. P.O. NO. |  |  |  |  |  | DATE:
 | Employee: |  |  |  |  | TOTAL HRS: |  | WORK [NAME]/WORK ORDER NO. |  |  |  |  |  |  |  |  | CONSUMABLES: |  |  |  |  | Payroll
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | QUAN: | PART NO:
 |  |  |  |  | Verify the following SAFTY ITEM CHECKLIST as required on this site. |  |  |  |  |  |  |  |  | Equipment Usage: |  |  |  |  | Tech Initial
 |  | NO | YES
 |  |  |  | 1 | If required, has the site specific training been completed?
 |  |  |  | 2 | If permits are required, do you have the proper papers?
 |  |  |  | 3 | Is Scaffolding correct and safe?
 |  |  |  | 4 | If lockout is required, has the proper procedure been followed?
 |  |  |  | 5 | Do you know the emergency signals?
 |  |  |  | 6 | Do you know the escape routes and assembley points?
 |  |  |  | 7 | Are safety glasses required?
 |  |  |  | 8 | Is a face sheild required?
 |  |  |  | 9 | Is a hard hat required?
 |  |  |  | 10 | Are flame resistant clothes required?
 |  |  |  | 11 | Is hearing protection required?
 |  |  |  | 12 | Are safety toed shoes required?
 |  |  |  | 13 | Are respirators required? |  |  |  |  |  |  |  |  | SIGNATURES:
 |  |  |  | 14 | Is fall protection equipment required?
 |  |  |  | 15 | Other: |  |  |  |  |  |  |  | CUSTOMER:
 |  |  |  |  |  |  |  |  |  |  |  |  | TRI TOOL:
Spreadsheet: 120744d1315494824-projected-component-change-outs-budget
Sheet: New Crane

New Excavator |  |  |  | Current Hours |  | Year
 |  |  |  |  |  | 2012 |  |  |  |  |  |  |  |  |  |  |  | 2013 |  |  |  |  |  |  |  |  |  |  |  | 2014 |  |  |  | 2015 |  |  |  | 2016
 |  |  |  |  |  | 744 | 696 | 744 | 720 | 744 | 720 | 744 | 744 | 720 | 744 | 720 | 744 | 744 | 672 | 744 | 720 | 744 | 720 | 744 | 744 | 720 | 744 | 720 | 744 | 2160 | 2184 | 2208 | 2208 | 2160 | 2184 | 2208 | 2208 | 2184 | 2184 | 2208 | 2208
 |  |  |  |  | Projected 2011 End | Jan | Feb | Mar | Apr | May | Jun | Jul | Aug | Sep | Oct | Nov | Dec | Jan | Feb | Mar | Apr | May | Jun | Jul | Aug | Sep | Oct | Nov | Dec | 1st | 2nd | 3rd | 4th | 1st | 2nd | 3rd | 4th | 1st | 2nd | 3rd | 4th
Projected Future Hours
Spreadsheet: 648596d1573124763-add-arrows-whenvalue-of-cell-changes-book1-1-
Sheet: Sheet1

 | Number of games | Victories | % of victories | Blah 5
Player 1 | 13 | 4
Player 2 | 8 | 3
Player 3 | 60 | 40
Player 4 | 3 | 2
Player 5 | 6 | 4
Player 6 | 6 | 3
Player 7 | 5 | 1
[NAME] on column D -> column C/ column B
Spreadsheet: 599914d1543357044-change-cell-colour-based-on-the-value-of-one-cell-2019-cohort-qla
Sheet: Higher Listening

 |  | Section A |  |  |  |  |  |  |  |  |  | Section B - Questions in Spanish
 | Question | 1&2 | 3 to 7 | 8 | 9 to 11 | 12&13 | 14 | 15&16 | 17&18 | 19 to 22 | 23&24 | 25&26 | 27&28 | 29&30
 | Out of | 4 | 5 | 3 | 3 | 8 | 3 | 5 | 2 | 4 | 3 | 4 | 2 | 4
 | Topic | Town | News Headlines | Friendship issues | Social Media | Holidays | Education, [NAME] and [NAME] | Environment | Helping the needy | Films | Smoking | Studies | Weeks plans | Relationships | Total
 | OP1
 | OP3 | 3 | 3 | 0 | 0 | 5 | 2 | 0 | 1 | 0 | 0 | 2 | 0 | 2
 | OP1
 | OP3 | 0 | 3 | 0 | 2 | 5 | 1 | 0 | 0 | 0 | 0 | 0 | 0 | 0
 | OP2
 | OP1
 | OP3
 | OP3
 | OP1
 | OP2
 | OP3 | 1 | 0 | 0 | 0 | 4 | 2 | 0 | 0 | 0 | 0 | 0 | 0 | 1
 | OP3
 | OP2
 | OP1
 | OP2
 | OP3
 | OP1
 | OP2
 | OP1
 | OP3 | 2 | 1 | 0 | 3 | 5 | 1 | 0 | 0 | 1 | 1 | 0 | 1 | 1
 | OP2
 | OP2
 | OP1
 | OP2
 | OP1
 | OP2
 | OP3
 | OP1
 | OP1
 | OP3 | 2 | 2 | 0 | 3 | 6 | 3 | 2 | 2 | 0 | 0 | 1 | 0 | 4
 | OP2
 | OP1
 | OP2
 | OP2
 | OP2
 | OP2
 | OP2
 | OP2
 | OP3
 | OP2
 | OP2
 | OP3
 | OP2
 | OP3 | 1 | 1 | 0 | 1 | 2 | 3 | 0 | 0 | 0 | 0 | 0 | 1 | 1
 | OP2
 | OP3
 | OP3 | 2 | 5 | 0 | 1 | 5 | 3 | 0 | 1 | 1 | 0 | 1 | 2 | 0
 | OP2
 | OP3 | 3 | 1 | 0 | 2 | 4 | 2 | 0 | 0 | 0 | 0 | 0 | 0 | 2
 | OP3 | 0 | 2 | 0 | 2 | 3 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 2
 | OP1
 | OP1
 | OP2
 | OP2
 | OP2
 | OP1
 | OP2
 | OP1
 | OP2
 | OP3
 | OP3
 | OP1
 | OP2
 | OP1
 | OP1
 | OP1
Spreadsheet: 90001d1289764645-turn-static-range-to-dynamic-cars
Sheet: Sheet1

Date | 2010-11-13 00:00:00 | 2010-11-20 00:00:00 | 2010-11-27 00:00:00 | 2010-12-04 00:00:00 | 2010-12-11 00:00:00
Total Cars | 977 | 977 | 977 | 977 | 977
Golf | 45 | 45 | 45 | 45 | 45
Skoda | 36 | 36 | 36 | 36 | 36
Toyota | 694 | 694 | 694 | 694 | 694
Renault | 202 | 202 | 202 | 202 | 202
Approved Cars
Spreadsheet: tracy_geaccone__40271__AEL 06 01
Sheet: Income State. - LY

Azurix Europe Ltd
Statement of Income - Variance to Last year
June 2001
(US GAAP & USD thousands)
Average exchange rate used |  |  | 1.402 |  | 1.5092
 |  |  | June
 |  |  | 2001 |  | 2000 |  | [NAME]
Revenues:
 | WWSL Potable Water |  | 9855 |  | 9838
 | WWSL Sewage |  | 19711 |  | 21074
 | WWSL Unregulated |  | 1428 |  | 477
 | Swiss Combi |  | 1735 |  | 1405
 | Wessex Water Enterprises |  | 669 |  | 0
Net operating revenues
Operating and maintenance expenses:
 | Personnel |  | 1742 |  | 2113
 | Power |  | 1148 |  | 755
 | Chemicals and materials |  | 129 |  | 302
 | Equipment costs |  | 381 |  | 100
 | Abstraction/Discharge fees |  | 632 |  | 504
 | Transportation |  | 741 |  | 302
 | Rent and rates |  | 1268 |  | 1038
 | Other operations costs |  | 1404 |  | 755
 | WWSL Unregulated |  | 1009 |  | 301
 | Swiss Combi |  | 1932 |  | 1170
 | Wessex Water Enterprises |  | 654 |  | 0
Total O&M expense
General and administrative expense
 | Billing and customer services |  | 1483 |  | 1593
 | Other overhead departments |  | 1207 |  | 904
 | Azurix Corp share options |  | 0 |  | 0
Total G&A expense
EBITDA
Depreciation and amort. expense |  |  | 6985 |  | 5744
Goodwill amortization expense |  |  | 1553 |  | 1672
Total D&A expense
Equity in (gain)/loss of unconsolidated affiliates
Interest income - affiliates (list separately) |  |  | -818 |  | -151
Interest income - 3rd party |  |  | -518 |  | -1056
Interest expense, gross - affiliates (list separately) |  |  | 532 |  | 604
Interest expense, gross - 3rd parties |  |  | 5120 |  | 5480
Amort. & W/O, deferred financing costs |  |  | 109 |  | 151
(Capitalized interest) |  |  | -359 |  | -604
Dividend Income
(Gain)/loss on disposition of assets
Currency transaction (gain)/loss
Total other (income)/expense
Income tax expense, current |  |  | 996 |  | 151
Income tax expense, deferred |  |  | 1590 |  | 3686
Total income tax expense
Minority Interest
Net Income
Spreadsheet: 86577d1286525343-inventory-stock1
Sheet: LOCAL ITEMS

S.No | [NAME] | MODEL  NO | SERIAL NO | QTY
1 | Surface box |  |  | 4
2 | MX Universal Conversion Plug | MX-1356 |  | 1
3 | 3 Pin Plug UK type | MX-1864 |  | 23
4 | Multi plug | MX-3008 |  | 1
5 | 3 pin plug [NAME] | MX-1863 |  | 5
6 | Stereo pins |  |  | 19
7 | 1.5 mt Power cable |  |  | 10
8 | 3mt Power cable |  |  | 9
9 | 2pin power code |  |  | 6
10 | Dust caps |  |  | 94
11 | VGA Male pins |  |  | 53
12 | VGA Female pins |  |  | 53
13 | Junction box |  |  | 2
14 | Laser pointers |  |  | 4
15 | XLR Male connectors
16 | Voltage 500 watts convertors |  |  | 2
17 | E.P Plug metal (stereo pins) |  |  | 50
18 | 9volts battaries |  |  | 20
19 | EP st/2RCA cable |  |  | 2
20 | Extension box |  |  | 9
21 | XLR Female connectors |  |  | 2
22 | Armstrong optra black (1200 x 600 x 20mm) |  |  | 60
 | BACK
Spreadsheet: 705555d1606189863-excel-lookup-with-multiple-date-criteria-aggregate-aggregate-formula-malcmalcmalc-
Sheet: Sheet1

 | RFP_TrackerName | [NAME] | RFP_SubmittedDate | RFP_StartDate | RFP_EndDate | RFP_ID
 | XYZ Corp. | Rancho Cucamonga, CA -- Tracy, CA | 2019-10-01 00:00:00 | 2019-10-01 00:00:00 | 2020-09-30 00:00:00 | 1008
 | XYZ Corp. | Rancho Cucamonga, CA -- Tracy, CA | 2020-08-28 00:00:00 | 2020-08-28 00:00:00 | 2021-08-28 00:00:00 | 1124
 | LMNOP Inc. | San Diego, CA -- Chicago, IL | 2020-06-01 00:00:00 | 2020-06-01 00:00:00 | 2021-05-30 00:00:00 | 1181
 | Executed_TrackerName | [NAME] | ExecutedDate | Desired Result | Column1 |  | [NAME] | Earliest Start | Lastest End
 | XYZ Corp. | Rancho Cucamonga, CA -- Tracy, CA | 2019-09-30 00:00:00 | Executed before RFP Start
 | XYZ Corp. | Rancho Cucamonga, CA -- Tracy, CA | 2021-08-29 00:00:00 | Executed after RFP End
 | XYZ Corp. | Rancho Cucamonga, CA -- Tracy, CA | 2020-08-27 00:00:00 | 1008
 | XYZ Corp. | Rancho Cucamonga, CA -- Tracy, CA | 2020-09-01 00:00:00 | 1124 | When ExecutedDate has overlap with Start/End Date for multiple RFP_IDs, use the SubmittedDate to determine the RFP_ID
 | XYZ Corp. | Rancho Cucamonga, CA -- Tracy, CA | 2020-10-01 00:00:00 | 1124
 | LMNOP Inc. | San Diego, CA -- Seattle, WA | 2020-09-15 00:00:00 | Not in RFP
Spreadsheet: 860010d1708247475-formula-to-check-overlapping-dates-by-another-column-formula-to-check-overlapping-dates-by-another-column
Sheet: Sheet1 (2)

ITEM | QUANTITY | INSTALL DATE | PICK UP DATE | PACKAGE | NO. WEEKS | Availaility |  |  | Workings: | First Occurance Dates |  | Availaility | Combined Formula
01_2.0 SEAT UPHOLSTERED SOFA | 1 | 2023-08-08 00:00:00 | 2023-10-03 00:00:00 | Essential | 8 |  | <-- the first occurance of this item, so should show "Available"
01_2.0 SEAT UPHOLSTERED SOFA | 1 | 2023-08-21 00:00:00 | 2023-10-16 00:00:00 | Essential | 8 |  | <-- correct as the item is not available until after 3/10 (line 2)
01_2.0 SEAT UPHOLSTERED SOFA | 1 | 2023-08-22 00:00:00 | 2023-10-03 00:00:00 | Essential | 6 |  | <-- correct as the item is not available until after 3/10 (line 2)
01_2.0 SEAT UPHOLSTERED SOFA | 1 | 2023-08-28 00:00:00 | 2023-10-09 00:00:00 | Essential | 6 |  | <-- correct as the item is not available until after 3/10 (line 2)
01_2.0 SEAT UPHOLSTERED SOFA | 1 | 2024-01-09 00:00:00 | 2024-02-13 00:00:00 | DESIGNER | 5 |  | <-- correct as the item is not available until after 3/10 (line 2)
01_2.5 SEAT UPHOLSTERED SOFA | 1 | 2023-07-17 00:00:00 | 2023-09-11 00:00:00 | Essential | 8 |  | <-- the first occurance of this item, so should show "Available"
01_2.5 SEAT UPHOLSTERED SOFA | 1 | 2023-07-18 00:00:00 | 2023-08-29 00:00:00 | Essential | 6 |  | <-- correct as the item is not available until after 11/9 (line 7)
01_2.5 SEAT UPHOLSTERED SOFA | 1 | 2023-07-18 00:00:00 | 2023-09-12 00:00:00 | Essential | 8 |  | <-- correct as the item is not available until after 11/9 (line 7)
01_2.5 SEAT UPHOLSTERED SOFA | 1 | 2023-08-11 00:00:00 | 2023-10-06 00:00:00 | Essential | 8 |  | <-- correct as the item is not available until after 11/9 (line 7)
01_2.5 SEAT UPHOLSTERED SOFA | 1 | 2023-08-17 00:00:00 | 2023-09-28 00:00:00 | Essential | 6 |  | <-- should show as "Available" because the date is after 11/9
01_2.5 SEAT UPHOLSTERED SOFA | 1 | 2023-08-22 00:00:00 | 2023-10-17 00:00:00 | Essential | 8 |  | <-- correct as the item is not available until after 11/9 (line 7)
01_2.5 SEAT UPHOLSTERED SOFA | 1 | 2023-08-29 00:00:00 | 2023-10-24 00:00:00 | Essential | 8
01_2.5 SEAT UPHOLSTERED SOFA | 1 | 2023-08-29 00:00:00 | 2023-10-24 00:00:00 | Essential | 8
01_2.5 SEAT UPHOLSTERED SOFA | 1 | 2023-09-25 00:00:00 | 2023-11-06 00:00:00 | Essential | 6
01_2.5 SEAT UPHOLSTERED SOFA | 1 | 2023-09-26 00:00:00 | 2023-11-07 00:00:00 | Essential | 6 |  | <-- what happens when the item is avail, so now it is taken (row above) and this row should be Check
[NAME] to check overlapping dates by another column
[NAME] to check overlapping dates by another column - Reply to Topic (excelforum.com)
Spreadsheet: 801740d1666352616-timeattandance-raw-data-processing-tijdklok_export_test
Sheet: DATA

User name | First name | Last name | Department | Personnel no | When | Device | In/Out | [NAME] | Project | Remark | User update | Changed
Ibrahim | Ibrahim | Hassani | Manager | 1 | 2022-09-26 09:01:37 | TM616 | In | RFID
Ibrahim | Ibrahim | Hassani | Manager | 1 | 2022-09-26 12:00:59 | TM616 | Out | RFID
Ibrahim | Ibrahim | Hassani | Manager | 1 | 2022-09-26 13:01:37 | TM616 | In | RFID
Ibrahim | Ibrahim | Hassani | Manager | 1 | 2022-09-26 15:10:59 | TM616 | Out | RFID
 |  |  |  | 1 | 2022-09-27 06:42:00 |  | In
 |  |  |  | 1 | 2022-09-27 10:42:00 |  | Out
 |  |  |  | 1 | 2022-09-27 11:42:00 |  | In
 |  |  |  | 1 | 2022-09-27 13:42:00 |  | Out
 |  |  |  | 1 | 2022-09-27 14:42:00 |  | In
 |  |  |  | 1 | 2022-09-27 16:46:00 |  | Out
Spreadsheet: 802480d1666879633-percentiles-with-1-criteria-needing-to-be-met-example
Sheet: Sheet1

Name | DATES | points | percentile
[NAME] | 71176 | 64.4 | 0.9 |  | <= I want column D, to take column C and compare his total to everybody else who matches colum B
[NAME] | 66451 | 64.1 | 0.95
[NAME] | 70894 | 61.9 | 0.97 |  | so just because he scored more points on 1 day, he may place in a lower percentile, depending on the other scores with that same day
[NAME] | 65053 | 58.2 | 0.9
[NAME] | 67629 | 57.6
[NAME] | 66333 | 53.3
[NAME] | 65726 | 50.3
[NAME] | 70937 | 62
[NAME] | 72516 | 55.5
[NAME] | 73829 | 53.1
[NAME] | 71018 | 62.1
[NAME] | 70937 | 58
[NAME] | 71440 | 57.9
[NAME] | 66451 | 53.5
[NAME] | 66333 | 51.4
[NAME] | 65726 | 51
[NAME] | 66333 | 51.7
[NAME] | 66451 | 49.5
CJ McCollum | 65611 | 55.7
Damian Lillard | 67541 | 52.2
[NAME] | 74365 | 52
De'Aaron Fox | 67629 | 52.2
[NAME] | 73804 | 66
[NAME] | 72411 | 55.8
[NAME] | 68051 | 49.8
[NAME] | 70861 | 63.4
[NAME] | 66551 | 56.2
Domantas Sabonis | 71995 | 59.3
Domantas Sabonis | 69513 | 55.8
[NAME] | 71711 | 58.1
[NAME] | 69516 | 53.7
Draymond Green | 68009 | 58.3
[NAME] | 69589 | 61.8
[NAME] | 72788 | 51.1
[NAME] | 72788 | 51.1
[NAME] | 71779 | 67.7
[NAME] | 65053 | 64.3
[NAME] | 70937 | 60.1
[NAME] | 73311 | 55.9
[NAME] | 65611 | 55.8
[NAME] | 72308 | 52.9
[NAME] | 75559 | 75.6
[NAME] | 69286 | 74.1
[NAME] | 73485 | 62.5
[NAME] | 75559 | 52
[NAME] | 75559 | 52.6
Jerami Grant | 67968 | 53.7
[NAME] | 71779 | 63.3
[NAME] | 71199 | 62.6
[NAME] | 73374 | 62.5
[NAME] | 70894 | 52.3
[NAME] | 71440 | 58.7
[NAME] | 67541 | 56.9
[NAME] | 71018 | 64.2
[NAME] | 70894 | 58.4
[NAME] | 74365 | 61.5
[NAME] | 72724 | 56.3
[NAME] | 65053 | 56.2
Kristaps Porzingis | 69286 | 64.3
[NAME] | 74365 | 54.6
[NAME] | 69516 | 77.8
[NAME] | 72788 | 67.4
[NAME] | 72788 | 67.4
[NAME] | 65053 | 56.7
[NAME] | 71711 | 54.6
[NAME] | 66333 | 51.8
[NAME] | 67629 | 50.9
[NAME] | 73829 | 50.6
[NAME] | 71199 | 74.1
[NAME] | 70861 | 49.5
[NAME] | 66393 | 57.8
Mitchell Robinson | 72411 | 56.5
Nassir Little | 69286 | 50
Nikola Jokic | 72516 | 92.9
Nikola Jokic | 73829 | 71.8
Nikola Jokic | 73551 | 70.4
Nikola Jokic | 73311 | 69.8
Nikola Jokic | 71995 | 65.9
Nikola Jokic | 71711 | 65.4
Nikola Jokic | 66159 | 64.3
Nikola Jokic | 72724 | 51.9
[NAME] | 69589 | 49.4
Pascal Siakam | 72788 | 49.4
[NAME] | 65763 | 62
[NAME] | 74365 | 55.9
[NAME] | 74545 | 54.4
[NAME] | 69513 | 56.2
[NAME] | 73804 | 52.4
[NAME] | 67629 | 60.5
[NAME] | 69516 | 50.6
[NAME] | 72724 | 53.3
[NAME] | 65053 | 53
[NAME] | 70894 | 52.6
[NAME] | 67629 | 52.4
[NAME] | 71440 | 52.4
[NAME] | 68152 | 49.6
Trae Young | 74545 | 54.1
Tyrese Haliburton | 66393 | 53.3
Tyrese Haliburton | 67629 | 51.7
Spreadsheet: 159795d1338845759-how-to-group-and-sum-the-data-for-each-resource-from-daily-to-weekly-sample-data-oeldere-
Sheet: Sheet1

Date | Logged Hour | Week Num | Resource
2012-01-13 00:00:00 | 0.5 | 2 | R1
2012-01-16 00:00:00 | 1 | 3 | R2
2012-01-19 00:00:00 | 6 | 3 | R2 |  | Rijlabels | [NAME]
2012-01-19 00:00:00 | 6 | 3 | R2 |  | 2 | 0.5
2012-01-20 00:00:00 | 8 | 3 | R2 |  | R1 | 0.5
2012-01-20 00:00:00 | 8 | 3 | R3 |  | 3 | 29
2012-01-25 00:00:00 | 0.75 | 4 | R4 |  | R2 | 21
2012-01-27 00:00:00 | 0.5 | 4 | R4 |  | R3 | 8
2012-02-02 00:00:00 | 0.5 | 5 | R5 |  | 4 | 1.25
2012-02-01 00:00:00 | 4 | 5 | R6 |  | R4 | 1.25
2012-02-03 00:00:00 | 4 | 5 | R6 |  | 5 | 10.5
2012-02-03 00:00:00 | 2 | 5 | R6 |  | R5 | 0.5
2012-02-06 00:00:00 | 0.75 | 6 | R4 |  | R6 | 10
2012-02-06 00:00:00 | 6 | 6 | R4 |  | 6 | 23.25
2012-02-07 00:00:00 | 6 | 6 | R1 |  | R1 | 6
2012-02-07 00:00:00 | 0.5 | 6 | R2 |  | R2 | 0.5
2012-02-07 00:00:00 | 2 | 6 | R8 |  | R3 | 2
2012-02-08 00:00:00 | 2 | 6 | R8 |  | R4 | 10.75
2012-02-08 00:00:00 | 2 | 6 | R3 |  | R8 | 4
2012-02-08 00:00:00 | 4 | 6 | R4 |  | Eindtotaal | 64.5
Spreadsheet: 255a7701-b42b-440e-ba29-fd17b5a649c4
Sheet: Sheet1

Battle ID | Date & Time | Side | Victory | Score | Opp. Score | Opp. ID | Opp. Name | Scenario ID | Front | Start Date | End Date | Name EN | Name FR
44051480 | 2014-11-16 18:23:41 | ALLIES | 1 | 4 | 0 | 1659188 | Pasteques | 7269 | mediterranean | 1940-11-06 | 1940-11-06 | Gallabat & Metemma | Gallabat & Metemma
44206002 | 2014-11-27 18:43:45 | ALLIES | 1 | 5 | 3 | 1485314 | [NAME] 62 | 6153 | western | 1944-08-24 | 1944-08-24 | Liberation of Paris | Libération de Paris
44206144 | 2014-11-27 19:02:20 | ALLIES | 0 | 1 | 4 | 1485314 | [NAME] 62 | 6151 | western | 1944-07-21 | 1944-07-21 | [NAME] | [NAME]