tianzl66/Sheetpedia huggingface dataset:
Spreadsheet: 845933d1697218560-xlookup-from-table-where-the-looked-up-columns-may-move-example-spreadsheetxlookup
Sheet: Sheet1

Person ID | Status | Customer | Country | Age | Sex | Weight (kg) | Last Shipment | Decision Date | Units |  |  |  |  | Status | Customer | Country | Person ID | Age | Sex | Weight (kg) | Decision Date | Units | Last Shipment
AAA1 | Open | Customer A | United Kingdom | 64 | Male | 82 | 2023-03-21 00:00:00 | 2022-08-30 00:00:00 | 345 |  |  |  |  | Open | Customer A | United Kingdom | AAA1 | 64 | Male | 82 | 2022-08-30 00:00:00 | 345 | 2023-03-21 00:00:00
AAA2 | Open | Customer A | United Kingdom | 65 | Female | 100 | 2023-06-22 00:00:00 | 2022-09-14 00:00:00 | 43 |  | Person ID | Decision Date |  | Open | Customer A | United Kingdom | AAA2 | 65 | Female | 100 | 2022-09-14 00:00:00 | 43 | 2023-06-22 00:00:00
AAA3 | Open | Customer B | United Kingdom | 53 | Female | 63 | 2023-06-20 00:00:00 | 2022-10-12 00:00:00 | 23 |  | AAA5 |  |  | Open | Customer B | United Kingdom | AAA3 | 53 | Female | 63 | 2022-10-12 00:00:00 | 23 | 2023-06-20 00:00:00
AAA4 | Open | Customer B | United Kingdom | 43 | Female | 81 | 2023-07-24 00:00:00 | 2022-10-12 00:00:00 | 12 |  |  |  |  | Open | Customer B | United Kingdom | AAA4 | 43 | Female | 81 | 2022-10-12 00:00:00 | 12 | 2023-07-24 00:00:00
AAA5 | Open | Customer C | United Kingdom | 76 | Female | 102 | 2023-07-24 00:00:00 | 2022-10-25 00:00:00 | 43 |  |  |  |  | Open | Customer C | United Kingdom | AAA5 | 76 | Female | 102 | 2022-10-25 00:00:00 | 43 | 2023-07-24 00:00:00
AAA6 | Open | Customer C | United Kingdom | 45 | Female | 62 | 2023-07-12 00:00:00 | 2022-11-04 00:00:00 | 123 |  |  |  |  | Open | Customer C | United Kingdom | AAA6 | 45 | Female | 62 | 2022-11-04 00:00:00 | 123 | 2023-07-12 00:00:00
AAA7 | Open | Customer C | United Kingdom | 43 | Male | 86 | 2023-07-10 00:00:00 | 2022-11-04 00:00:00 | 12 |  |  |  |  | Open | Customer C | United Kingdom | AAA7 | 43 | Male | 86 | 2022-11-04 00:00:00 | 12 | 2023-07-10 00:00:00
Spreadsheet: 606034d1547467645-excluding-weekends-in-a-if-function-excel-test
Sheet: Planner

Unique ID | Vendor | Received Date | Qty | Delayed days | Test Commence | Tester No. | Urgency | 2 | 1 | [NAME] of 21504 hubs | full load | Total  samples | RATE PER DAY | Failure Level | Pass Target % | DAYS TO COMPLETE | EST COMPLETION | GAP (Rolling) | [NAME] | SKU
REF0003 | 1 | 2018-11-30 00:00:00 | 8960 | 40 |  | 1 | Standard | 8960 | 200 | 0 | 0 | 200 | 26 | 4 |  |  |  |  | Complete | SKU 2
REF0004 | 1 | 2018-11-30 00:00:00 | 8960 | 40 |  | 2 | Standard | 8960 | 200 | 0 | 0 | 200 | 26 | 4 |  |  |  |  | Complete | SKU 2
[NAME] | 1 | 2018-11-30 00:00:00 | 3584 | 0 |  | 1 | Standard | 3584 | 200 | 0 | 0 | 200 | 26 | 4 |  |  |  |  | Complete | SKU 2
REF0006 | 1 | 2018-12-06 00:00:00 | 8960 | 35 |  | 2 | Standard | 8960 | 200 | 0 | 0 | 200 | 26 | 4 |  |  |  |  | In Progress | SKU 1
REF0007 | 1 | 2018-12-06 00:00:00 | 6272 | 35 |  | 1 | Standard | 6272 | 200 | 0 | 0 | 200 | 26 | 4 |  |  |  |  | In Progress | SKU 1
REF0008 | 1 | 2018-12-06 00:00:00 | 1792 | 35 |  | 2 | Standard | 1792 | 125 | 0 | 0 | 125 | 26 | 3 |  |  |  |  | In Progress | SKU 1
REF0009 | 1 | 2018-12-19 00:00:00 | 8064 | 22 |  | 1 | Standard | 8064 | 200 | 0 | 0 | 200 | 26 | 4 |  |  |  |  | In Progress | SKU 2
REF0010 | 1 | 2018-12-19 00:00:00 | 8062 | 22 |  | 2 | Standard | 8062 | 200 | 0 | 0 | 200 | 26 | 4 |  |  |  |  | In Progress | SKU 2
REF0011 | 1 | 2018-12-19 00:00:00 | 2 | 0 |  | 1 | Standard | 2 | 2 | 0 | 0 | 2 | 26 | 1 |  |  |  |  | Exempt | SKU 1
Spreadsheet: 866500d1713432520-a-formula-to-select-the-highest-cell-in-a-column-that-then-shows-the-entire-row-walks
Sheet: Lee

 | # | Date | Name | Distance in       Miles | Total Elevation in Feet | Total Time HH:MM | Moving Time HH:MM | Stoped Time HH:MM | Avarage Speed MPH | Average Moving Speed MPH
 |  |  | 2017
 | 1 | 2017-09-10 00:00:00 | Scaffal Pike | 6.6 | 3136 |  | 04:46:00 | 01:59:00
 |  | 2017-09-24 00:00:00 | Brecon Beacon - Pen Y Fan | 9.5 | 2597 |  | 04:57:00 | 01:13:00
 |  | 2017-10-08 00:00:00 | Buckland Dinham Walk | 7.5 | 650 |  | 03:34:00 | 02:14:00
 |  |  | 2018
 |  | 2018-01-14 00:00:00 | County Gate - Lynmouth - Watersmeet - County Gate | 12.8 | 2850 |  | 05:46:00 | 01:40:00
 |  | 2018-02-25 00:00:00 | Stonehenge Landscape - Great Durnford - Amesbury | 12.2 | 1110 |  | 04:59:00 | 01:46:00
 |  | 2018-05-19 00:00:00 | Falls of Foyers | 3.5 | 703 |  | 01:36:00 | 00:23:00
 |  | 2018-05-20 00:00:00 | [NAME] | 10.7 | 4447 |  | 06:55:00 | 02:48:00
 |  | 2018-11-04 00:00:00 | Somerset 3 Peaks Southern loop and 2 Rivers Way | 14.1 | 1698 |  | 05:51:00 | 01:27:00
 |  |  | 2019
 |  | 2019-08-11 00:00:00 | Avon Three Peaks | 17 | 2451 |  | 05:59:00 | 00:51:00
 |  | 2019-08-25 00:00:00 | Pensford, Hunstrete, Stanton Wick Circular Hike | 10.3 | 1149 |  | 03:24:00 | 01:31:00
 |  | 2019-09-01 00:00:00 | Axbridge Reservoir - Crook Peak | 10.4 | 1781 |  | 03:22:00 | 01:48:00
 |  | 2019-09-08 00:00:00 | [NAME] Warren - Churchill | 8.3 | 2008 |  | 03:24:00 | 01:06:00
 |  | 2019-09-20 00:00:00 | [NAME] | 8.8 | 2883 |  | 03:16:00 | 01:44:00
 |  | 2018-10-06 00:00:00 | Pensford to [NAME] and Back | 11.1 | 831 |  | 03:28:00 | 01:24:00
 |  |  | 2020
 |  |  | 2021
 |  |  | 2022
Spreadsheet: 540001d1506466587-referencing-row-wise-data-in-a-column-test1
Sheet: CAN_data

CAN-ID | DLC | Data0 | Data1 | Data2 | Data 3 | Data4 | Data5 | Data6 | Data7
9 | 8 | FF | 0 | 64 | 0 | 19 | 0 | 14 | 0
10 | 8 | 0 | 0 | D0 | 7 | 1 | 0 | E8 | 3
11 | 8 | 19 | 0 | 1 | 0 | 0 | 0 | 0 | 0
9 | 0 | 64 | 0 | 64 | 0 | 19 | 0 | 14 | 0
10 | 0 | 1 | 0 | D0 | 7 | 1 | 0 | E8 | 3
11 | 0 | 19 | 0 | 1 | 0 | 0 | 0 | 0 | 0
Spreadsheet: 673722d1587499595-find-text-within-string-last-characters-in-string
Sheet: Sheet1

This formula is in Col B ---> | =TRIM(RIGHT(SUBSTITUTE(A2,"\",REPT(" ",[NAME])))
AST2_20200107\500\500\AboveGround\Piping\Equipment\MANIFOLD\LSMS-238
AST2_20200107\500\500\AboveGround\Piping\Equipment\MANIFOLD\LSMS-239
AST2_20200107\500\500\AboveGround\Piping\Equipment\MANIFOLD\LSMR-223
AST2_20200107\500\500\AboveGround\Piping\Equipment\MANIFOLD\LSMR-156
AST2_20200107\100\100\AboveGround\Instrumentation\Equipment\1-HSC-0038
AST2_20200107\100\100\AboveGround\Instrumentation\Equipment\1-HSO-0038
AST2_20200107\100\100\AboveGround\Instrumentation\Equipment\1-HSC-0023
AST2_20200107\100\100\AboveGround\Instrumentation\Equipment\1-HSO-0023
[NAME]
AST2_20200107\100\100\AboveGround\Instrumentation\Equipment\1-HSC-0132
AST2_20200107\100\100\AboveGround\Instrumentation\Equipment\1-HSO-0132
AST2_20200107\100\100\AboveGround\Instrumentation\Equipment\1-HSC-0017
AST2_20200107\100\100\AboveGround\Instrumentation\Equipment\1-HSO-0017
AST2_20200107\100\100\AboveGround\Instrumentation\Equipment\1-HSC-0137
AST2_20200107\100\100\AboveGround\Instrumentation\Equipment\1-HSO-0137
AST2_20200107\100\100\AboveGround\Instrumentation\Equipment\1-HSC-0034
AST2_20200107\100\100\AboveGround\Instrumentation\Equipment\1-HSO-0034
AST2_20200107\100\100\AboveGround\Instrumentation\Equipment\1-HSC-0035
AST2_20200107\100\100\AboveGround\Instrumentation\Equipment\1-HSO-0035
[NAME]
AST2_20200107\100\100\AboveGround\Instrumentation\Equipment\1-HSC-0039
AST2_20200107\100\100\AboveGround\Instrumentation\Equipment\1-HSO-0039
AST2_20200107\100\100\AboveGround\Instrumentation\Equipment\1-HS-0071X
AST2_20200107\100\100\AboveGround\Instrumentation\Equipment\1-HS-0071Y
AST2_20200107\100\100\AboveGround\Instrumentation\Equipment\1-LIT-3057
AST2_20200107\100\100\AboveGround\Instrumentation\Equipment\1-HSC-0022
AST2_20200107\100\100\AboveGround\Instrumentation\Equipment\1-HSO-0022
AST2_20200107\300\300\AboveGround\Instrumentation\Fire and Gas\3-FAP-0012
AST2_20200107\600\600\AboveGround\Telecommunication\Equipment\RCW-LSP-003
AST2_20200107\300\300\AboveGround\Telecommunication\Equipment\MFR-LSP-002
AST2_20200107\100\100\AboveGround\Telecommunication\Equipment\NPS-LSP-002
AST2_20200107\300\300\AboveGround\Telecommunication\Equipment\MFR-LSP-003
AST2_20200107\100\100\AboveGround\Telecommunication\Equipment\NPS-LSP-003
AST2_20200107\600\600\AboveGround\Telecommunication\Equipment\RCW-LSP-001
AST2_20200107\300\300\AboveGround\Instrumentation\Equipment\3-FR01-101
AST2_20200107\300\300\AboveGround\Instrumentation\Equipment\3-JB-101-D-N-G
AST2_20200107\100\100\AboveGround\Instrumentation\Equipment\1-FIT-1552
AST2_20200107\100\100\AboveGround\Instrumentation\Equipment\1-FT-0124
AST2_20200107\100\100\AboveGround\Instrumentation\Equipment\1-FT-0547B
AST2_20200107\100\100\AboveGround\Instrumentation\Equipment\1-FIT-0547A
AST2_20200107\100\100\AboveGround\Instrumentation\Equipment\1-FT-0176
Spreadsheet: 38659d1236798418-summarizing-data-over-several-sheets-bolts-list-r2
Sheet: BoltsP1

 | BOLTS LIST | BOLTS LIST
CLIENT |  |  |  |  |  | JOB No.
PLANT |  |  |  |  |  |  | LIST No.   1   of  3
 |  | ALL BOLTS GRADE 8.8 ZINC PLATED |  | BOLTS |  | NUTS |  | WASHERS
ITEM | GRIP | [NAME] OF JOINT | QTY | DIA | LGTH | NYLCK | HEX | FORM C | SPRING
1 | 6 |  | 5 | M10 | 25
2 | 20 |  | 10 | M24 | 55
3 | 16 |  | 5 | M8 | 30
4 | 16 |  | 12 | M12 | 35
5 | 18 |  | 4 | M12 | 40
6 | 6 |  | 8 | M12 | 25
7 | 14 |  | 17 | M24CSK | 50
8 | 16 |  | 18 | M12 | 35
9 | 18 |  | 52 | M12 | 40
10 | 24 |  | 45 | M12 | 45
11 | 32 |  | 26 | M12 | 55
12 | 44 |  | 12 | M8 | 60
13 |  |  |  |  | #N/A
14 |  |  |  |  | #N/A
15 |  |  |  |  | #N/A
16 |  |  |  |  | #N/A
17 |  |  |  |  | #N/A
18 |  |  |  |  | #N/A
19 |  |  |  |  | #N/A
Spreadsheet: 75308d1275903510-how-to-make-formulas-with-numbers-from-several-sheets-example
Sheet: SUM

 |  | Week1 | Week2 | Week3 | Week4 | Week5 | Week6 | Week7 | Week8 | Week9 | Week10 | Week11 | [NAME] | Week13 | Week14 | Week15 | Week16 | Week17 | Week18 | Week19 | Week20 | Week21 | Week22
Spreadsheet: 883410d1732031171-conditional-formating-triggered-by-length-of-service-tracker1
Sheet: Sheet1

 |  |  |  |  | Target
 |  |  |  |  | 25 | 50 | 75 | 85 | 85
 | Start date | Length of service | ID Number | 2024-10-07 00:00:00 | 2024-10-14 00:00:00 | 2024-10-21 00:00:00 | 2024-10-28 00:00:00 | 2024-11-04 00:00:00 | 2024-11-11 00:00:00
 | 2024-10-07 00:00:00 |  | 1407291276
 | 2024-10-07 00:00:00 |  | 1445300896
 | 2024-10-07 00:00:00 |  | 1380224144
 | 2024-10-07 00:00:00 |  | 1455218276
 | 2024-10-14 00:00:00 |  | 1423928616
 | 2024-10-14 00:00:00 |  | 1452791508
 | 2024-10-14 00:00:00 |  | 1448991942
 | 2024-10-14 00:00:00 |  | 1323203602
 | 2024-10-14 00:00:00 |  | 1429594198
 | 2024-10-21 00:00:00 |  | 1160519592 |  |  | 24 | 51 | 73 | 87
 | 2024-10-21 00:00:00 |  | 634852224
 | 2024-10-21 00:00:00 |  | 1255470074
 | 2024-10-21 00:00:00 |  | 1382213072
 | 2024-10-21 00:00:00 |  | 644502086
 | 2024-10-21 00:00:00 |  | 1431091824
 | 2024-10-21 00:00:00 |  | 1149076372
 | 2024-10-21 00:00:00 |  | 1263557366
 | 2024-10-28 00:00:00 |  | 999614916
 | 2024-10-28 00:00:00 |  | 1422124358
 | 2024-10-28 00:00:00 |  | 1227544118
 | 2024-11-04 00:00:00 |  | 1222559138
 | 2024-11-04 00:00:00 |  | 1230758008
 | 2024-11-04 00:00:00 |  | 1212104635
 | 2024-11-04 00:00:00 |  | 804469076
 | 2024-11-04 00:00:00 |  | 1241577772
 | 2024-11-04 00:00:00 |  | 1250811822
 | 2024-11-04 00:00:00 |  | 1283968536
 | 2024-11-04 00:00:00 |  | 1266019989
 | 2024-11-04 00:00:00 |  | 1260018692
 | 2024-11-04 00:00:00 |  | 399803830
 | 2024-11-04 00:00:00 |  | 1328334284
 | 2024-11-04 00:00:00 |  | 1313509254
 | 2024-11-04 00:00:00 |  | 1298513886
 | 2024-11-11 00:00:00 |  | 1221496580
 | 2024-11-11 00:00:00 |  | 1378389448
Spreadsheet: 840692d1692904189-automatic-email-with-changing-week-numbers-and-dates-sample-worksheet-automatic-email
Sheet: Sheet1 (2)

Week | 34 | Issues | ( | ) | Please provide the customer chargeback details for week | %0A%0AI need the customer, $ amount, P/N, reason - as much info as available. | ).
Date |  | Please confirm the following taken from your FRB for week | and please also, confirm that there were no additional issues. Thank you! | Please confirm that your plant had no issues for week | as there is nothing on your FRB. | Issues on FRB | Nothing on FRB | Missing Cust CB Details
City | To | CC | 2nd to: | 3rd to: | Subject 1 & 2 | Wkly Body 1 | Wkly Body 2 | Subject 3 | Wkly Body 3
Aurn | [EMAIL] | [EMAIL] | [EMAIL] | [EMAIL]
Avn | [EMAIL] | [EMAIL] | [EMAIL] | [NAME]
Brdstown | [EMAIL] | [EMAIL] | [EMAIL] | [EMAIL]
Bellevil | [EMAIL] | [EMAIL] | [EMAIL] | [EMAIL]
 | Wkly Body 1 | Wkly Body 2 | Wkly Body 3 | Closing
 |  |  |  | %0A%0A%0AK Cdzw%0A Corporate Quality Analyst%0A [EMAIL]%0A [PHONE] Ext. 11
 |  | %0A%0A%0AThank you!
Spreadsheet: 489999d1479554512-football-predictions-football-predictions
Sheet: Week 7

Fixtures | Week 7 |  |  |  |  | Player Scores
Home Team | Score |  |  | Away Team |  | [NAME] | [NAME] | [NAME] | [NAME] | [NAME] | [NAME] | [NAME] | [NAME] | Damian West | [NAME] | [NAME] | [NAME] | [NAME] | [NAME] | [NAME] | [NAME] | [NAME] | [NAME] | [NAME] | [NAME]
Everton |  | - |  | Crystal Palace |  | 0 | 0 | 5 | 0 | 2 | 2 | 5 | 0 | 2 | 0 | 5 | 5 | 5 | 0 | 0 | 0 | 0 | 0 | 0 | 0
Swansea City |  | - |  | Liverpool |  | 2 | 2 | 2 | 2 | 2 | 2 | 2 | 5 | 2 | 2 | 2 | 5 | 2 | 0 | 0 | 2 | 5 | 2 | 2 | 2
Hull City |  | - |  | Chelsea |  | 2 | 5 | 5 | 2 | 0 | 0 | 5 | 5 | 2 | 2 | 2 | 5 | 2 | 0 | 0 | 2 | 2 | 2 | 2 | 2
Sunderland |  | - |  | West Brom |  | 0 | 5 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 2 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 5 | 0
Watford |  | - |  | Bournemouth |  | 2 | 5 | 5 | 5 | 2 | 2 | 2 | 0 | 2 | 0 | 2 | 2 | 0 | 0 | 0 | 2 | 0 | 2 | 0 | 0
West Ham |  | - |  | Middlesbrough |  | 0 | 0 | 0 | 0 | 0 | 0 | 2 | 5 | 0 | 0 | 0 | 5 | 0 | 0 | 0 | 5 | 2 | 0 | 0 | 0
[NAME] |  | - |  | Stoke City |  | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0
Leicester City |  | - |  | Southampton |  | 0 | 0 | 2 | 0 | 0 | 2 | 2 | 2 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 2 | 2 | 0 | 2
Tottenham |  | - |  | Manchester City |  | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 2 | 0 | 0 | 2 | 0 | 0 | 0 | 0 | 0
Burnley |  | - |  | Arsenal |  | 2 | 2 | 2 | 2 | 2 | 2 | 2 | 2 | 2 | 2 | 2 | 2 | 0 | 0 | 0 | 2 | 2 | 2 | 2 | 2
Home Team | Score |  |  | Away Team | Weekly Total
Everton | 1 | - | 1 | Crystal Palace |  | 2-1 | 2-1 | 1-1 | 3-1 | 2-2 | 2-2 | 1-1 | 1-0 | 2-2 | 2-1 | 1-1 | 1-1 | 1-1 |  | 2-1 | 1-2 | 2-1 | 2-0 | 2-1 | 2-0
Swansea City | 1 | - | 2 | Liverpool |  | 0-2 | 1-3 | 0-3 | 1-3 | 0-3 | 1-3 | 1-3 | 1-2 | 1-3 | 0-2 | 0-2 | 1-2 | 0-3 |  | 2-1 | 1-3 | 1-2 | 1-3 | 1-3 | 0-3
Hull City | 0 | - | 2 | Chelsea |  | 1-3 | 0-2 | 0-2 | 1-2 | 1-1 | 2-2 | 0-2 | 0-2 | 1-2 | 0-1 | 1-2 | 0-2 | 1-2 |  | 2-1 | 1-2 | 0-1 | 1-2 | 0-4 | 1-2
Sunderland | 1 | - | 1 | West Brom |  | 1-0 | 1-1 | 2-1 | 0-2 | 1-2 | 1-2 | 0-2 | 1-0 | 2-0 | 1-2 | 0-0 | 1-0 | 2-1 |  | 2-1 | 1-2 | 1-0 | 2-1 | 1-1 | 2-1
Watford | 2 | - | 2 | Bournemouth |  | 1-1 | 2-2 | 2-2 | 2-2 | 1-1 | 1-1 | 1-1 | 2-1 | 1-1 | 3-1 | 1-1 | 1-1 | 2-0 |  | 2-1 | 1-1 | 2-1 | 1-1 | 2-1 | 2-0
West Ham | 1 | - | 1 | Middlesbrough |  | 2-0 | 2-1 | 1-0 | 1-3 | 1-2 | 1-0 | 0-0 | 1-1 | 3-1 | 2-0 | 1-0 | 1-1 | 1-0 |  | 2-1 | 1-1 | 1-1 | 2-1 | 1-2 | 2-1
[NAME] | 1 | - | 1 | Stoke City |  | 3-0 | 3-0 | 2-0 | 4-1 | 1-0 | 3-1 | 4-0 | 2-0 | 2-0 | 4-1 | 3-1 | 2-0 | 2-0 |  | 2-1 | 3-1 | 2-0 | 2-0 | 2-0 | 3-0
Leicester City | 0 | - | 0 | Southampton |  | 1-0 | 1-0 | 1-1 | 1-0 | 3-2 | 1-1 | 1-1 | 2-2 | 3-2 | 2-1 | 2-1 | 2-1 | 2-1 |  | 2-1 | 2-1 | 1-1 | 1-1 | 2-1 | 1-1
Tottenham | 2 | - | 0 | Manchester City |  | 2-3 | 0-3 | 1-3 | 1-3 | 2-2 | 1-1 | 0-3 | 1-2 | 1-1 | 1-3 | 1-3 | 2-1 | 1-4 |  | 2-1 | 1-3 | 1-1 | 1-2 | 1-3 | 1-3
Burnley | 0 | - | 1 | Arsenal |  | 1-3 | 1-3 | 1-2 | 1-3 | 1-3 | 1-2 | 0-2 | 1-3 | 1-4 | 0-2 | 0-3 | 1-3 |  |  | 2-1 | 1-3 | 0-2 | 1-3 | 0-3 | 0-2
Spreadsheet: 488984d1478957302-excel-help-vlook-up-index-small-formula-help-reporting-sheet-help-excel-help
Sheet: Report Sheet

Total number of Purchases
Item |  | Total Number Purchased | Cost Price per item | Total Spent
GLASSWARE
 | 1
 | 2
 | 3
 | 4
 | 5
 |  |  | TOTAL
SILVER
 | 1
 | 2
 | 3
 |  |  | TOTAL
CROCKERY
 | 1
 | 2
 | 3
 | 4
 | 5
 |  |  | TOTAL
MISC.
 | 1
 | 2
 |  |  | TOTAL
 |  |  | GRAND TOTAL:
Spreadsheet: tracy_geaccone__40485__GPG HR May YTD - Actual
Sheet: May YTD

Expense Category | May             Y-T-D |  | March - May      Actual
Headcount | 29 * |  | 29 *
Salaries & Wages | 764047 |  | 445213
Employee Expenses | 147528 |  | 44762
Office supplies [NAME] Expenses | 41576 |  | 23406
Outside Services | 104290 |  | 101104
Equipment Rental | 662 |  | 263
Computer Related (includes EDS) | 1453 |  | 9577
Advertising Expense | 2443 |  | 150
Benefits & Payroll Taxes | 170258 |  | 87237
Bonus | 148390 |  | 89034
Corp | 447320 |  | 268392
EPSC | 136876 |  | 62096
EIS | 2692 |  | 974
Total GPG HR
* Headcount represents actual - [NAME] has agreed to pick up four additional people from the SAP
initiative in the near future.
Spreadsheet: benjamin_rogers__1227__UAE with 2 LM's & debt structure 04-21-00
Sheet: Taxes

TAXES
('000 $)
STATE TAXES
Adjusted Pretax Book Income
Plus Book Depreciation & Amortization
Less State Tax Depreciation
State Taxable Income
State Income Tax Rate
Current State Income Tax Expense (Benefit)
Beginning NOL's | 0 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 0
New NOL's
Expired NOLs | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0
NOL Utilization (8 years)
Ending NOL's
TOTAL STATE TAXES UTILIZING NOLs
FEDERAL TAXES
State Taxable Income
Less: State Taxes
Federal Taxable Income
Federal Tax Rate
Federal Tax Expense/ (Benefit)
Beginning NOL's | 0 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 0
New NOL's
Expired NOLs | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0
NOL Utilization (15 years)
Ending NOL's
TOTAL STATE TAXES UTILIZING NOLs
Spreadsheet: 163835d1340478213-working-with-id-and-parentid-as-criteria-copy-of-workbook1
Sheet: Sheet2 (2)

 | ID | parentID | type | critA | critB
 | 27 |  | root | A | 1
 | 39 | 29 | branch | A | 0
 | 635 | 32 | terminal | A | 0
 | 33 | 32 | branch
 | 40 | 39 | branch
 | 775 | 33 | terminal | A | 1
 | 34 | 33 | branch
 | 812 | 40 | branch
 | 37 | 34 | terminal
 | 813 | 812 | terminal
 | 781 | 12 | branch | A | 0
 | 14 | 13 | internal
 | 784 | 781 | branch
 | 15 | 14 | internal
 | 782 | 784 | branch
 | 19 | 18 | final
Spreadsheet: 66474d1267118584-solved-trouble-with-conditional-formatting-referencing-an-alternative-cell-conditional_formatting_question
Sheet: Sheet1

 | Category | Field One | Field Two | Cost
 | qwer | 19258 | 577 | 8052.099999999999
 | asdf | 21825 | 2302 | 68248.18000000001
 | zxcv | 35544 | 2499 | 3296.13
 | wert | 34626 | 393 | 292095.42
 | sdfg | 294 | 207 | 124.89
 | xcvb | 10287 | 416 | 50366.82999999998
 | erty | 7734 | 3233 | 137398.768
 | cvbn | 104 | 70 | 93576.52
 | Grand Total
 | Last Week: | 119365 | 8843 | 758336
 | D from Last Week:
 |  | ↑ | ↑ | ↓
Spreadsheet: 0ffbbf19-3513-43d9-b6f7-ba180395f4c9
Sheet: 4 | Old editions

 |  |  |  | --> Return to first page
--> Return to first page
Previous Editions of MRWs not visible on SpringerReference
Following older editions are not on SpringerReference, as only the most recent one is visible:
Title | [NAME]. | eRef ISBN | Library | Copyright
Dictionary of Gems and Gemology | 2 | n/a | Earth and Environmental Science | 2005
Drug Discovery and Evaluation: Pharmacological Assays | 2 | 978-3-540-29837-3 | Biomedical and Life Sciences | 2002
Drug Discovery and Evaluation: Safety and Pharmakokinetic Assays | 2 | 978-3-540-29804-5 | Biomedical and Life Sciences | 2012
Encyclopedia of Cancer | 2 | 978-3-540-47648-1 | Biomedical and Life Sciences | 2008
Encyclopedia of Cryptography and Security | 1 | 978-0-387-23483-0 | Computer Science | 2005
Encyclopedia of Entomology | 1 | 978-0-306-48380-6 | Biomedical and Life Sciences | 2004
Encyclopedia of Multimedia | 1 | 978-0-387-30038-2 | Computer Science | 2006
Encyclopedia of Optimization | 1 | 978-0-306-48332-5 | Mathematics and Statistics | 2001
Encyclopedic Dictionary of Polymers | 1 | 978-0-387-30160-0 | Chemistry and Materials Science | 2007
Encyclopedic Reference of Cancer | 1 | 978-3-540-30683-2 | Biomedical and Life Sciences | 2001
Encyclopedia of Cancer | 2 | 978-3-540-47648-1 | Biomedical and Life Sciences | 2008
Encyclopedic Reference of Molecular Pharmacology | 1 | 978-3-540-29832-8 | Biomedical and Life Sciences | 2003
Encyclopedic Reference of Parasitology [set] | 2 | 978-3-540-29833-5 | Biomedical and Life Sciences | 2001
Encyclopedic Reference of Parasitology: Biology | 1 | 978-3-540-29834-2 | Biomedical and Life Sciences | 2001
Encyclopedic Reference of Parasitology: Diseases | 2 | 978-3-540-29835-9 | Biomedical and Life Sciences | 2001
Handbook of Nuclear Chemistry | 1 | 978-0-387-30682-7 | Chemistry and Materials Science | 2003
Polymer [NAME] | 1 | 978-0-306-48244-1 | Chemistry and Materials Science | 2003
The Springer Index of Viruses | 1 | 978-3-540-31042-6 | Biomedical and Life Sciences | 2002
--> Return to first page
Spreadsheet: louise_kitchen__22711__North America Plan 01-09 inc AA adj (2)
Sheet: Derivatives AA

 | Derivatives/Wellhead Analysts/Associates
 | 2002 Plan
 |  |  |  |  |  |  |  |  | Per HC | New HC | Adjust Comp
 |  | 2001-09-01 00:00:00 |  | 2001 |  | % | 2002
 |  | YTD Actual |  | Forecast |  | of Total | Plan
ENACOMP | Compensation |  |  |  |  |  | 0 | Compensation | 0
 | Special Pays |  |  | 0
 | Analyst & Associates |  |  |  |  |  | 60500
ENABENTX | Benefits & Payroll Taxes |  |  |  |  |  |  | Other
ENAEMPEX | Employee Expense |  |  |  |  |  | 7500
ENAT&EEX | Travel & Entertainment Expense |  |  |  |  |  | 25000 | Total
ENAOUTSV | Outside Services |  |  |  |  |  | 0
ENASUPP | Supplies Expense |  |  |  |  |  | 5000
ENAMKTEX | Marketing |  |  |  |  |  | 0 | Intern | 33000
ENACONTR | Charitable Contributions |  |  |  |  |  | 59 | [NAME] | 48400 | 0
ENARENT | Rent |  |  |  |  |  | 7500 | Staff | 49500 | 0
ENATECH | Technology |  |  |  |  |  | 10000 | Specialist | 57750 | 0
ENATRANS | Transportation |  |  |  |  |  | 0.2 | Sr. Specialist | 71500 | 0
ENAOTHEX | Other Expenses |  |  |  |  |  | 1500 | Analyst | 60500 | 1
ENATAXES | Taxes Other than Income |  |  |  |  |  | 0 | Associate | 89100 | 0
ENATOTDR | Total Direct Expenses |  |  |  |  |  |  | Manager | 110000
 |  |  |  |  |  |  |  | Director | 143000
 | Headcount |  |  |  |  |  | 0 | Sr. Director | 165000 | 0
 |  |  |  |  |  |  |  | VP | 198000 | 2
 | A&A Headcount |  |  |  |  |  | 1 | MD | 220000 | 0
 | Total Headcount |  |  |  |  |  |  |  |  |  | 0.2
 |  |  |  |  |  |  | Other Expense Calculation
 | Outside Services | 254512
 |  |  |  |  |  |  | Total Misc Exp | Old HC | Exp/Old HC | New HC | Exp/New HC
Spreadsheet: 673905d1587584361-formula-to-calculate-business-days-wwc-team-metrics
Sheet: Agent Ranking

 | WWC Agent | WR% | WR Target | % to Target | Complete WC | WC Target | % to WC Target | % to [NAME] | MTD Rank
 | [NAME] |  | 0.7 |  |  | 65
 | [NAME] |  | 0.7 |  |  | 65
 | [NAME] |  | 0.7 |  |  | 65
 | Cherelle Palmer2 |  | 0.7 |  |  | 65
 | [NAME] |  | 0.7 |  |  | 65
 | [NAME] |  | 0.7 |  |  | 65
 | Sage Roles |  | 0.7 |  |  | 65
 | WWC Agent | WR% | WR Target | % to Target | Complete WC | WC Target | % to WC Target | % to [NAME] | MTD Rank
 | Sage Roles | 0.848855690698631 | 0.7 | 1.21265098671233 | 81 | 65 | 1.246153846153846 | 1.229402416433088 | 1
 | [NAME] | 0.8934866694294793 | 0.7 | 1.276409527756399 | 73 | 65 | 1.123076923076923 | 1.199743225416661 | 2
 | Cherelle Palmer2 | 0.7839052211814894 | 0.7 | 1.119864601687842 | 68 | 65 | 1.046153846153846 | 1.083009223920844 | 3
 | [NAME] | 0.8115113833775256 | 0.7 | 1.159301976253608 | 61 | 65 | 0.9384615384615385 | 1.048881757357573 | 4
 | [NAME] | 0.881961847211114 | 0.7 | 1.259945496015877 | 54 | 65 | 0.8307692307692308 | 1.045357363392554 | 5
 | [NAME] | 0.8639728899227478 | 0.7 | 1.234246985603926 | 51 | 65 | 0.7846153846153846 | 1.009431185109655 | 6
 | [NAME] | 0.7660534641498703 | 0.7 | 1.094362091642672 | 39 | 65 | 0.6 | 0.847181045821336 | 7