tianzl66/Sheetpedia huggingface dataset:
Spreadsheet: darrell_schoolcraft__7804__imbalsumm0108
Sheet: NW

 | LaPlata Recpt |  | LaPlata Delivery
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | Monthly |  | Monthly
Day | Measured | Scheduled | Measured | Scheduled |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 56419 | 500516 | 500535 | 500539 | [NAME] | Index | Dollars
1 | 199740 | 206461 |  | -6136 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 1993-02-01 00:00:00 |  |  |  |  |  | 1.57
2 | 124221 | 140424 |  | -16997 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 1993-03-01 00:00:00 |  |  |  |  |  | 1.84
3 | 208560 | 226875 |  | -13759 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 1993-04-01 00:00:00 |  |  |  |  |  | 1.91
4 | 174497 | 201790 |  | -27623 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 1993-05-01 00:00:00 |  |  |  |  |  | 2.21
5 | 170484 | 195304 |  | -25217 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 1993-06-01 00:00:00 |  |  |  |  |  | 1.67
6 | 171739 | 196507 |  | -26132 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 1993-07-01 00:00:00 |  |  |  |  |  | 1.8
7 | 181261 | 192920 |  | -9874 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 1993-08-01 00:00:00 |  |  |  |  |  | 1.88
8 | 197070 | 204844 |  | -4417 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 1993-09-01 00:00:00 |  |  |  |  |  | 2.02
9 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 1993-10-01 00:00:00 |  |  |  |  |  | 1.81
10 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 1993-11-01 00:00:00 |  |  |  |  |  | 1.79
11 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 1993-12-01 00:00:00 |  |  |  |  |  | 2.28
12 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 1994-01-01 00:00:00 |  |  |  |  |  | 1.94
13 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 1994-02-01 00:00:00 |  |  |  |  |  | 2.2
14
15 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 1994-04-01 00:00:00 |  |  |  |  |  | 1.74
16 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 1994-05-01 00:00:00 |  |  |  |  |  | 1.58
17 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 1994-06-01 00:00:00 |  |  |  |  |  | 1.6
18
19
20
21
22
23
24
25
26
27
28
29
30
31
 | 2001-07-31 00:00:00 |  |  |  | 5110
 | 2001-08-08 00:00:00
 | CBS Dollars
 |  |  |  | -487771.44
Spreadsheet: 491029d1480271215-adding-cumulative-weekly-totals-avk-excel-forum-question1
Sheet: 11-2-16

 | DAILY HEARING ROSTER
 | MEETINGS TODAY:
Rank | Employee | Notes | Time In | Time Out | Time In | Time Out | Subtotal | Total Hours | NewRank | Cumulative | Cum_rank | Judge | Employee Name | Board No.
1 |  |  | 09:00:00 | 10:30:00 |  |  |  |  |  |  |  |  | Pretend Employee
2
3 |  |  |  |  |  |  |  |  |  |  |  |  | Pretend Employee
4
5
6
 | Travel
 |  |  |  | TOTAL TIME (Today): |  |  |  |  |  |  |  | TOTAL HEARINGS (Today):
 |  |  |  | TIME (Week End Total): |  |  |  |  |  |  |  | HEARING (Week End Total):
Spreadsheet: c3c1a5b9-fc76-4a4e-b02d-3d149dd7b89d
Sheet: Sheet1

Test Referenced | Entry Type | Mayo ID | Description | Reporting Description | Method | Collection Container | Temperature | Stability | [NAME] | Unit of Measure | [NAME] | Minimum Volume | Reject Due To | Reference Values | Days/Times Performed | Analytic Time | Maximum Lab Time | CPT Units | CPT Code | LOINC® Code | LOINC® Attributes | Always Performed | Orderable Separately | Performing Location
FSCHC | Test | FSCHC | Schistosoma [NAME], FMI (CSF) | Schistosoma [NAME] (CSF) | Fluorescent [NAME] (FMI) | [NAME], sterile container: SrwStlCont |  |  | 1 | mL | Collect 1 mL of spinal fluid. Ship refrigerate. | 0.1 mL | Specimens other than	CSF Anticoagulants other than	NA Hemolysis	NA Thawing	NA Lipemia	NA Icteric	NA | Reference Range:  <1.00   INTERPRETIVE CRITERIA:                     <1.00  Antibody Not Detected         > or = 1.00  Antibody Detected Diagnosis of central nervous system infections can be accomplished by demonstrating the presence of intrathecally-produced specific antibody. Interpreting results may be complicated by low antibody levels found in CSF, passive transfer of antibody from blood, and contamination via bloody taps. The interpretation of CSF results must consider CSF-serum antibody ratios to the infectious agent.  This test was developed and its performance characteristics have been determined by Focus Diagnostics. Performance characteristics refer to the analytical performance of the test.  Test Performed by: Focus Diagnostics, Inc.                                        5787 Corporate Ave.                                        Cypress, CA 90630-4750 | Wednesday | 1 - 8 days | 3 - 10 days | 1 | 86682 |  |  |  |  | Focus Diagnositics, Inc.
FSCHC | [NAME] | CSF | CSF |  |  |  | Refrigerated | 14 days
FSCHC | Result | Z0552 | [NAME] | [NAME] | Alphanumeric |  |  |  |  |  |  |  |  |  |  |  |  |  |  | In Process
Spreadsheet: 199943d1355368580-help-a-teacher-day-how-to-pull-data-from-a-sheet-to-enter-in-a-calendar-example1
Sheet: Monday

Date: Monday |  | 2012-12-10 00:00:00 |  | Daily Student Tracking Report
Student | On Time |  | On Task |  | Response |  | Talking |  | Disruption |  | Gum/food |  | Homework |  | Classwork |  | Absent |  | Tardy |  | Total (day)
Student1 | 0.5 | 2 | 0.5 | 2 | 0.5 | 0.5 | -0.5 | -0.5 | -0.5 | -1 | -1.5 | -0.5 | 2 | 1 | 1 | 1 | -0.5 | -0.5 | -0.5 | -2
Student 2 | 1
Student 3
Student 4
Student 5
Student 6
Student 7
Student 8
Student 9
Student 10
Student 11
Student 12
Student 13 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | some more directions below- you can not read unles u click on it
Student 14
Student 15 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | So, basically, I only want to input data on the 5 green sheets (Monday-Friday) and have this data come up automatically on the Weekly sheet (Gray color), on the Monthly sheet (Orange color) and on the individual Student sheet (blue color-This sheet I want to print out and give out each monday so that the student understands where they need to work on)
Student 16
Student 17
Student 18
Notes for Principal / Parent   |        Nòt pou Direktè / Paran              |        Notas para el Director / Padres  √
Name | Time | Reason      |      Rezon ki fè      |      Razón
Student1 | 09:03:00 | Student helped another student with his work - How can I make this a green color?
Student1 | 09:30:00 | Student cheated on a test  - How can I make this a red color? can I create another field before or after and have a conditional formating?
Student1 | 09:40:00 | How can I input this data automatically on the weekly sheet AND on the Student 1 sheet under comments?
Spreadsheet: 725071d1616517271-need-a-formula-to-help-with-an-order-form-pulling-through-correct-pricing-for-the-quantity-quotationexample-tora-v1-
Sheet: Sheet1

Item No. | Product Description | Flavour | Weight (kg) | Quantity | Price | Total
[NAME] |  |  |  | 600
LRF046E |  |  |  | 300
Spreadsheet: 7d91e734-8212-4258-9a4b-a74c89597e94
Sheet: Sheet1

analytica 2012 - Aussteller Liste | Unnamed: 1 | Unnamed: 2 | Unnamed: 3 | Unnamed: 4 | Unnamed: 5
 | Suche über Produkt- und Dienstleistungsverzeichnis (6 [NAME]):
 | 1 Applikationen 1.5 Feststoffanalytik 1.5.3 Glas
Nr. | Firma | Land | Ort | PLZ | Halle/Stand
1 | [NAME] | Frankreich | [NAME] | 27106 | [NAME]
2 | Helmut Fischer GmbH Institut für Elektronik und [NAME] | Deutschland | Sindelfingen | 71069 | A1.204
3 | LECO Instrumente GmbH | Deutschland | Mönchengladbach | 41199 | A1.324
4 | LEONI Fiber Optics GmbH | Deutschland | Neuhaus-Schierschnitz | 96524 | A2.234
5 | Spectruma Analytik GmbH | Deutschland | Hof | 95028 | A2.428
6 | Thermo Scientific | Deutschland | Dreieich | 63303 | B1.101/202
Spreadsheet: 12167dd7-ba27-46a7-8f88-9fa06bf612b0
Sheet: Sheet1

STATE REPRESENTATIVES - BELKNAP COUNTY ---   REPUBLICAN | Unnamed: 1 | Unnamed: 2 | Unnamed: 3 | Unnamed: 4 | Unnamed: 5 | Unnamed: 6 | Unnamed: 7
District No. 1 (1) | Simpson, r | Gulick ,d | [NAME]
Center Harbor | 182 | 2 | -
New Hampton | 280 | 17 | 1
TOTALS | 462 | 19 | 1
District No. 2 (2) | Tobin r | Fields, r | Merry, d | [NAME]
Sanbornton | 291 | 270 | 11 | 4
[NAME] | 181 | 232 | - | -
TOTALS | 472 | 502 | 11 | 4
District No. 3 (2) | Worseman, r | [NAME], r | Greemore, r | Horne, d | [NAME]
Meredith | 702 | 410 | 494 | 10 | 7
District No. 4 (5) | Flanders, r | Kingsbury, r | Luther, r | [NAME], r | [NAME], r | Accornero, r | [NAME]
[NAME] | 288 | 223 | 219 | 251 | 204 | 188 | 2
[NAME] | 145 | 119 | 124 | 143 | 87 | 129 | 1
[NAME] 3 | 223 | 150 | 177 | 208 | 138 | 148 | 6
[NAME] | 203 | 156 | 153 | 178 | 124 | 137 | 3
[NAME] | 110 | 89 | 93 | 108 | 73 | 105 | 7
[NAME] 6 | 265 | 203 | 195 | 230 | 159 | 205 | 5
TOTALS | 1234 | 940 | 961 | 1118 | 785 | 912 | 24
District No. 5 (7) | Swinford, r | Bolster, r | Boyce, r | Bungert, r | [NAME], r
Alton | 472 | 416 | 518 | 392 | 488
Barnstead | 320 | 265 | 275 | 211 | 295
Belmont | 322 | 376 | 351 | 296 | 324
Gilford | 532 | 606 | 626 | 495 | 560
TOTALS | 1646 | 1663 | 1770 | 1394 | 1667
District No. 5 (7) | Malone, r | Pilliod, r | St. Cyr, r
Alton | 476 | 390 | 590
Barnstead | 266 | 205 | 290
Belmont | 358 | 334 | 351
Gilford | 578 | 611 | 584
TOTALS | 1678 | 1540 | 1815
District No. 6 (1) | [NAME], r | Chase, d
Gilmanton | 424 | 12
Spreadsheet: 133448d1324401205-need-spreadsheet-to-find-similar-names-and-copy-paste-to-another-page-sample2
Sheet: Key

[NAME]
mw-625
sf-783
ca-5530
ca-190G
nc-26c
nc-270
[NAME]
ca-5500
ca-5510
nc-222/75
ca-350
ca-376
sf-784
sf-735
sf-693
nc-253
hs-8256
nc-250/70
ca-12
ex-8228
gr-133
32-91a
22-95a
gx-037-b
12-72a
37-50d
13-90a
33-85a
18-85a
12-50d
Spreadsheet: 232652d1367492720-advanced-filtering-0fquestion
Sheet: גיליון1

needed criterion
1.13B
1.13B
1.21B
1.24B
1.25B
1.29B
1.33B
1.43B
1.49B
1.53B
1.55B
1.83B
1.84B
1.87B
1.90B
1.93B
1.98B
11.07B
14.84B
15.51B
16.34B
16.47B
18.52B
19.23B
2.01B
2.04B
2.06B
2.32B
2.35B
2.37B
2.53B
2.58B
2.73B
2.78B
2.83B
2.96B
22.37B
23.58B
27.47B
3.25B
3.28B
3.34B
3.34B
3.37B
3.40B
3.60B
3.66B
3.69B
4.00B
4.08B
4.50B
4.54B
4.62B
4.65B
4.74B
4.80B
4.80B
5.05B
5.25B
5.99B
6.11B
6.13B
8.44B
8.83B
110.75M
131.90M
153.85M
192.49M
240.60M
246.84M
282.40M
343.43M
364.87M
400.86M
441.40M
490.21M
524.04M
536.92M
555.94M
651.58M
699.94M
716.76M
746.75M
889.02M
924.44M
925.95M
998.50M
Spreadsheet: 106528d1303809993-rearrange-first-last-and-middle-name-in-a-cell-book1_johnmerlino
Sheet: Sheet1

IN RIGHT OF AKA PAUL A HERMAN |  |  |  | HERMAN PAUL A |  | HERMAN AKA PAUL A
IN RIGHT OF AKA PAUL A HERMAN |  |  |  | HERMAN PAUL A |  | HERMAN AKA PAUL A
IN RIGHT OF PAUL A HERMAN |  |  |  |  |  | HERMAN PAUL A
IN RIGHT OF AKA PAUL A HERMAN |  |  |  | HERMAN PAUL A |  | HERMAN AKA PAUL A
IN RIGHT OF aka PAUL B HERMAN |  |  |  | HERMAN PAUL B |  | HERMAN AKA PAUL B
IN RIGHT OF AKA [NAME] |  |  |  | [NAME] MERLINO |  | AKA JOHN MERLINO
IN RIGHT OF AKA PAUL A HERMAN |  |  |  | HERMAN PAUL A |  | HERMAN AKA PAUL A
IN RIGHT OF AKA Alistair A Marcol |  |  |  | MARCOL ALISTAIR A |  | MARCOL AKA ALISTAIR A
IN RIGHT OF AKA PAUL A HERMAN |  |  |  | HERMAN PAUL A |  | HERMAN AKA PAUL A
IN RIGHT OF AKA PAUL A HERMAN |  |  |  | HERMAN PAUL A |  | HERMAN AKA PAUL A
Spreadsheet: 79649d1279866024-excel-2007-trace-amounts-from-2nd-sheet-with-below-cateria-formula-problem
Sheet: Sheet 2

 | Sr.No | SI/Age Band | 3 mon -5 | 0-35 | 35-40 | 40-45 | 45-50 | 50-55 | 55-60 | 60-65 | 65-70
 | 1 | 100000 | 1350 | 1270 | 1515 | 1895 | 2770 | 3120 | 3620 | 4050 | 4560
 | 2 | 200000 | 2660 | 2530 | 2915 | 3575 | 5450 | 6280 | 7130 | 8110 | 9110
 | 3 | 300000 | 3705 | 3530 | 4070 | 4985 | 7760 | 8980 | 10210 | 11670 | 13120
Spreadsheet: 683522d1592808247-conditional-formatting-shows-incorrect-icons-under-percent-conditonal_formatting_4_icon_percent
Sheet: Own_Data

 | >=80: Excellent
 | >=60: Good
 | >=50 and <60: Average
 | <=49: Need Improvement
 | No. | Label | Name | Group | Paper 1 | Paper 2 | Total | Target | % | Results
 | 1 | Excellent (8 pax) | EMP1 | GROUP A | 72 | 17 |  | 100
 | 2 |  | EMP2 | GROUP B | 68 | 15 |  | 100
 | 3 |  | EMP3 | GROUP B | 72 | 10 |  | 100
 | 4 |  | EMP4 | GROUP B | 72 | 10 |  | 100
 | 5 |  | EMP5 | GROUP A | 64 | 16 |  | 100
 | 6 |  | EMP6 | GROUP B | 60 | 20 |  | 100
 | 7 |  | EMP7 | GROUP B | 68 | 12 |  | 100
 | 8 |  | [NAME] | GROUP C | 68 | 12 |  | 100
 | 9 | Good (35 pax) | EMP9 | GROUP A | 64 | 14 |  | 100
 | 10 |  | EMP10 | GROUP A | 68 | 10 |  | 100
 | 11 |  | EMP11 | GROUP E | 64 | 13 |  | 100
 | 12 |  | EMP12 | GROUP B | 68 | 9 |  | 100
 | 13 |  | EMP13 | GROUP F | 60 | 17 |  | 100
 | 14 |  | EMP14 | GROUP B | 64 | 12 |  | 100
 | 15 |  | EMP15 | GROUP F | 60 | 14 |  | 100
 | 16 |  | EMP16 | GROUP A | 64 | 8 |  | 100
 | 17 |  | EMP17 | GROUP A | 60 | 12 |  | 100
 | 18 |  | EMP18 | GROUP C | 56 | 15 |  | 100
 | 19 |  | EMP19 | GROUP F | 56 | 15 |  | 100
 | 20 |  | EMP20 | GROUP E | 60 | 11 |  | 100
 | 21 |  | EMP21 | GROUP A | 60 | 10 |  | 100
 | 22 |  | EMP22 | GROUP C | 60 | 10 |  | 100
 | 23 |  | EMP23 | GROUP A | 64 | 5 |  | 100
 | 24 |  | EMP24 | GROUP A | 60 | 9 |  | 100
 | 25 |  | EMP25 | GROUP B | 64 | 5 |  | 100
 | 26 |  | EMP26 | GROUP G | 56 | 12.5 |  | 100
 | 27 |  | EMP27 | GROUP B | 64 | 4 |  | 100
 | 28 |  | EMP28 | GROUP D | 56 | 10 |  | 100
 | 29 |  | EMP29 | GROUP B | 56 | 9 |  | 100
 | 30 |  | EMP30 | GROUP B | 56 | 8 |  | 100
 | 31 |  | EMP31 | GROUP A | 64 | 0 |  | 100
 | 32 |  | EMP32 | GROUP F | 60 | 4 |  | 100
 | 33 |  | EMP33 | GROUP A | 56 | 7.5 |  | 100
 | 34 |  | EMP34 | GROUP D | 56 | 7.5 |  | 100
 | 35 |  | EMP35 | GROUP F | 60 | 3 |  | 100
 | 36 |  | EMP36 | GROUP F | 48 | 15 |  | 100
 | 37 |  | EMP37 | GROUP H | 52 | 11 |  | 100
 | 38 |  | EMP38 | GROUP F | 52 | 10 |  | 100
 | 39 |  | EMP39 | GROUP D | 52 | 10 |  | 100
 | 40 |  | EMP40 | GROUP F | 52 | 10 |  | 100
 | 41 |  | EMP41 | GROUP B | 44 | 17 |  | 100
 | 42 |  | EMP42 | GROUP A | 56 | 5 |  | 100
 | 43 |  | EMP43 | GROUP E | 56 | 5 |  | 100
 | 44 | Average (11 pax) | EMP44 | GROUP F | 56 | 3 |  | 100
 | 45 |  | EMP45 | GROUP D | 52 | 7 |  | 100
 | 46 |  | EMP46 | GROUP A | 48 | 10 |  | 100
 | 47 |  | EMP47 | GROUP C | 52 | 5 |  | 100
 | 48 |  | EMP48 | GROUP A | 56 | 0 |  | 100
 | 49 |  | [NAME] | GROUP A | 48 | 6 |  | 100
 | 50 |  | EMP50 | GROUP F | 52 | 2 |  | 100
 | 51 |  | EMP51 | GROUP A | 48 | 5 |  | 100
 | 52 |  | EMP52 | GROUP B | 52 | 0 |  | 100
 | 53 |  | EMP53 | GROUP D | 52 | 0 |  | 100
 | 54 |  | EMP54 | GROUP E | 48 | 2 |  | 100
 | 55 | Need Improvement (7 pax) | EMP55 | GROUP B | 44 | 5 |  | 100
 | 56 |  | EMP56 | GROUP B | 48 | 0 |  | 100
 | 57 |  | EMP57 | GROUP A | 44 | 4 |  | 100
 | 58 |  | EMP58 | GROUP A | 44 | 0 |  | 100
 | 59 |  | EMP59 | GROUP D | 44 | 0 |  | 100
 | 60 |  | EMP60 | GROUP C | 36 | 5 |  | 100
 | 61 |  | EMP61 | GROUP A | 40 | 0 |  | 100
Spreadsheet: 163434d1340300324-excel-2007-autofilterand-subtotal-autofilterproblem
Sheet: Sheet1

Item | Total | SubTotal
A | 3 | 15.5
A | 54 | 15.5
A | 2 | 15.5
B | 5 | 15.5
B | 2 | 15.5
B | 6 | 15.5
B | 3 | 15.5
Spreadsheet: 821855d1678950382-calculate-number-of-workdays-from-total-hours-workdays-per-task
Sheet: Sheet1

TASK | MINUTES TO COMPLETE | TOTAL MINUTES
PART 1 (STAFF MEMBER 1) | 25
PART 2 (STAFF MEMBER 2) | 15
PART 3 (STAFF MEMBER 3) | 5
PART 4 (STAFF MEMBER 4) | 15
TOTAL TIME TO COMPLETE TASK
NUMBER TIMES TO REPEAT | 3780
TOTAL TIME
TOTAL NUMBER OF WORKDAYS TO [NAME] (1 WORKDAY = 7:24)
TOTAL NUMBER OF WORKDAYS TO COMPLETE PART 1 (1 WORKDAY = 7:24)
TOTAL NUMBER OF WORKDAYS TO COMPLETE PART 2 (1 WORKDAY = 7:24)
TOTAL NUMBER OF WORKDAYS TO COMPLETE PART 3 (1 WORKDAY = 7:24)
TOTAL NUMBER OF WORKDAYS TO COMPLETE PART 4 (1 WORKDAY = 7:24)
HOW MANY STAFF REQUIRED TO COMPLETE IN 8 WORKING WEEKS (40 WORKDAYS)
HOW MANY STAFF REQUIRED TO COMPLETE PART 1 IN 8 WORKING WEEKS (40 WORKDAYS)
HOW MANY STAFF REQUIRED TO COMPLETE PART 2 IN 8 WORKING WEEKS (40 WORKDAYS)
HOW MANY STAFF REQUIRED TO COMPLETE PART 3 IN 8 WORKING WEEKS (40 WORKDAYS)
HOW MANY STAFF REQUIRED TO COMPLETE PART 4 IN 8 WORKING WEEKS (40 WORKDAYS)
Spreadsheet: 195796d1353664454-conditional-formatting-help-needed-conditional-formatting
Sheet: Sheet1

Points A | Points B
10 | 100
50 | 50
70 | 40
20 | 90
90 | 20
30 | 80
80 | 30
40 | 70
60 | 60
100 | 10
Spreadsheet: jeffrey_a_shankman__13930__EGM Scenario Analysis 11-14-01
Sheet: Sheet1

EGM Scenario Analysis
 |  |  |  |  | Scenario 1 |  |  | Scenario 2 |  |  | Scenario 3
Team / Group |  | Oct 31, 2001 Headcount | Total Compensation Cost (1) |  | Headcount Reduction | % Headcount Reduction | Annual Savings (1) | Cumulative Headcount Reduction | % Headcount Reduction | Cumulative Annual Savings (1) | Cumulative Headcount Reduction | % Headcount Reduction | Cumulative Annual Savings (1)
Crude & Products
Coal & Emissions / Vssl Trading
Weather
LNG
Freight
Insurance Risk Markets
Financial Trading
Japan
Finance & Structuring
Market Fundamentals
[NAME]
Office of the Chair |  | 4 | N/A
Sub-Total EGM
Energy Ops - Networks
Total
(1) Includes Salary, Payroll Taxes, and Benefits only.  Excludes bonus/special pays.
Spreadsheet: 110064d1306853463-match-function-returning-n-a-match-problem
Sheet: Sheet1

4 |  | Luke Espat Group
 | 1 |  |  |  |  |  |  |  |  |  |  |  | 10461.12
 | 2 |  |  |  |  |  |  |  |  |  |  |  | 102664.85
 | 3 |  |  |  |  |  |  |  |  |  |  |  | 3735876.3
 | 4 |  |  |  |  |  |  |  |  |  |  |  | 7993428.75
 | 5 |  |  |  |  |  |  |  |  |  |  |  | 828387.64
 | 6 |  |  |  |  |  |  |  |  |  |  |  | 12121680.29
 | 7 |  |  |  |  |  |  |  |  |  |  |  | 694674.92
 | 8 |  |  |  |  |  |  |  |  |  |  |  | 60610.75
Spreadsheet: 731470d1620357993-pivot-table-calculation-field-pivot-table-calculation-field
Sheet: calculation fiield

 |  |  | Dept# | Type | Amount
 |  |  | 1178 | Budget
 |  |  | 1178 | Grant
 |  |  | 1178 | Infrastucture
 | Table |  | 1178 | Projects
 |  |  | 1178 | Technology
 |  |  | 1982 | Budget
 |  |  | 1982 | Grant
 |  |  | 1982 | Infrastucture
 |  |  | 1982 | Projects
 |  |  | 1982 | Technology
 |  |  |  | Sum of Amount | Column Labels |  |  |  |  | I want to create this formula!
 |  |  |  | Row Labels | Budget | Grant | Infrastucture | Projects | Technology
 |  |  |  | 1178 | 5351608.430079562 | 6335703.767161363 | 2481183.520325623 | 666507.9105846069 | 255393.2201920023 | (budget + Grant) -( infrastucute +projects +technology) =
 |  |  |  | 1982 | 7885520.712215452 | 3413796.223045015 | 2056971.186506599 | 315493.1620303463 | 1582595.104725666 | (budget + Grant) -( infrastucute +projects +technology) =
Spreadsheet: 31097d1226855988-conditional-formulas-haxmania3
Sheet: Sheet1

DATE | INVOICE NO. | PRODUCT |  | QTY. | RATE (1% VAT) | 0.01 | RATE (4% VAT) | 0.04 | RATE (0% VAT) | VAT 0% | TOTAL
2008-11-01 00:00:00 | 1 | KG |  | 1 |  | 0 |  | 0 | 2950 | 0 | 2950
 | 2 | KG |  | 1 |  | 0 |  | 0 | 2950 | 0 | 2950
 | 3 | LK |  | 3 |  | 0 | 3269 | 130.76 |  |  | 9937.76
 | 4 | RK1 |  | 1 |  | 0 | 1106 | 44.24 |  |  | 1150.24
 | 5 | RK2 |  | 1 |  | 0 | 2019 | 80.76 |  |  | 2099.76
 | 6 | RK3 |  | 1 |  | 0 | 3462 | 138.48 |  |  | 3600.48
Spreadsheet: 764661d1642861352-data-analysis-for-attendance-attendance-data
Sheet: MAster attend (2)

FULL NAME | ZONE | Date | Day 1 | Day 2 | Day 3 | Day 4 | Day 5 | Day 6 | CERTIFICATE
[NAME] | central | 2019-09-01 00:00:00 | P | P | p | A | A | A | N
[NAME] | West | 2019-09-01 00:00:00 | P | P | P | P | P | P | Y
abel | east | 2019-09-01 00:00:00 | p | p | P | P | P | P | Y
carren | West | 2019-09-01 00:00:00 | P | P | P | P | P | P | Y
amilia | West | 2019-09-01 00:00:00 | p | p | p | A | A | A | N
parker | West | 2019-09-01 00:00:00 | L | L | A | A | A | A | N
[NAME] | east | 2019-09-01 00:00:00 | p | p | p | p | p | p | y
rose | east | 2019-09-01 00:00:00 | L | L | P | A | A | A | N
[NAME] | west | 2019-09-01 00:00:00 | A | A | p | A | A | A | N
[NAME] | east | 2019-09-01 00:00:00 | A | p | p | p | p | p | Y
adam | east | 2019-09-01 00:00:00 | A | p | p | p | p | p | Y
cane | central | 2019-09-01 00:00:00 | A | p | p | p | p | p | Y
Spreadsheet: 599875d1543343598-summing-numbers-based-on-multiple-conditions-across-a-range-automated-ioc-sheet-desensitized
Sheet: Team 1

Date | [NAME] |  |  |  | PI
 | Sickcall and Med Documentation |  |  |  | SSG J
 | Infection, Asepsis, & Sterile Techniques |  |  |  | SFC S
 | Medication Administration |  |  |  | SSG D
 | Injections |  |  |  | SSG J
 | Pharmacology |  |  |  | SFC S
 | Venipuncture |  |  |  | SSG J
 | EENT Primary Care |  |  |  | SSG D
 | Respiratory Primary Care |  |  |  | SFC S
 | Abdominal Primary Care |  |  |  | SSG F
 | Orthopedic Primary Care |  |  |  | SSG R
 | Basic Wound Primary Care |  |  |  | SFC S
 | Skin Disease Primary Care |  |  |  | SSG F
 | Primary Care Pre-Examination Review
 | Primary Care Exam
 | Intro to Battlefield Medicine |  |  |  | SFC S
 | Battlefield Communication/ Documentation |  |  |  | SSG F
 | Casualty Movement |  |  |  | SSG D
 | Combat Medical Aid Bag |  |  |  | SSG R
 | Combat Casualty Assessment |  |  |  | SSG R
 | Control Bleeding |  |  |  | SFC S
 | Airway Management |  |  |  | SSG R
 | [NAME] Trauma |  |  |  | SSG F
 | Shock |  |  |  | SSG J
 | Vascular Access |  |  |  | SSG R
 | Fieldcraft 1 Pre-Examination Review
 | Field Craft Exam
 | Head Injuries with Traumatic Brain Injuries |  |  |  | SSG F
 | Ocular Injuries |  |  |  | SSG J
 | Burns |  |  |  | SFC S
 | [NAME] |  |  |  | SSG F
 | Musculoskeletal Trauma |  |  |  | SSG R
 | [NAME]
 | Field Craft 2 Exam
 | [NAME] Training |  |  |  | SSG F
 | Casualty Triage |  |  |  | SSG J
 | Suicide Prevention |  |  |  | SSG J
 | [NAME] and Geneva Conv. |  |  |  | SSG R
 | Environmental Threat |  |  |  | SFC S
 | Fieldcraft 3 Pre-Examination Review
 | Field Craft Exam
 | Combat Caualty Assesment ( Table VIII Skills Validation
 | Combat Caualty Assesment ( Table VIII Skills Validation
 | Combat Caualty Assesment ( Table VIII Skills Validation