tianzl66/Sheetpedia huggingface dataset:
Spreadsheet: 1a4df4af-ee78-4543-89cb-34ad76cd1fc5
Sheet: Rodent and lg animal

Annual Rodent and Large Animal Trianing as of 5/20/2013
 | First Name | Last Name | Curriculum | Date Completed
1 | [NAME] | Aliotta | Lifespan Annual Rodent Training | 2013-05-14 09:59:39
2 | [NAME] | [NAME] | Lifespan Annual Rodent Training | 2013-03-07 16:27:20
3 | [NAME] | [NAME] | Lifespan Annual Large Animal Training | 2013-02-08 11:12:47
4 | [NAME] | [NAME] | Lifespan Annual Large Animal Training | 2013-02-20 15:25:55
5 | [NAME] | [NAME] | Lifespan Annual Large Animal Training | 2013-02-21 11:21:45
6 | [NAME] | [NAME] | Lifespan Annual Large Animal Training | 2013-02-28 17:34:37
7 | [NAME] | [NAME] | Lifespan Annual Large Animal Training | 2013-03-12 16:30:35
8 | [NAME] | [NAME] | Lifespan Annual Large Animal Training | 2013-02-12 15:20:23
9 | Ling | [NAME] | Lifespan Annual Rodent Training | 2013-05-13 12:40:16
10 | [NAME] | [NAME] | Lifespan Annual Rodent Training | 2013-05-16 11:57:22
11 | Penny | Cloutier -Lyons | Lifespan Annual Rodent Training | 2013-05-09 16:34:41
12 | Penny | Cloutier -Lyons | Lifespan Annual Large Animal Training | 2013-05-09 16:45:25
13 | [NAME] | [NAME] | Lifespan Annual Rodent Training | 2013-04-29 20:22:23
14 | yan | ge | Lifespan Annual Rodent Training | 2013-05-14 10:00:33
15 | [NAME] | goldberg | Lifespan Annual Rodent Training | 2013-05-14 11:50:58
16 | rujun | gong | Lifespan Annual Rodent Training | 2013-05-14 09:57:16
17 | Lara | Helwig | Lifespan Annual Large Animal Training | 2013-05-13 14:17:18
18 | Lara | Helwig | Lifespan Annual Rodent Training | 2013-05-13 14:20:28
19 | [NAME] | Hulsebos | Lifespan Annual Rodent Training | 2013-05-14 12:44:08
20 | [NAME] | Hulsebos | Lifespan Annual Large Animal Training | 2013-05-08 16:34:25
21 | chunming | [NAME] | Lifespan Annual Rodent Training | 2013-05-17 23:31:02
22 | [NAME] | [NAME] | Lifespan Annual Rodent Training | 2013-05-17 14:43:15
23 | [NAME] | [NAME] | Lifespan Annual Rodent Training | 2013-05-17 12:41:42
24 | Christina | [NAME] | Lifespan Annual Rodent Training | 2013-05-14 11:50:38
25 | [NAME] | Pacheco | Lifespan Annual Large Animal Training | 2013-04-02 11:21:29
26 | Maria | Papp | Lifespan Annual Rodent Training | 2013-05-16 14:25:57
27 | Maria | Papp | Lifespan Annual Large Animal Training | 2013-05-16 14:11:56
28 | Mandy | Pereira | Lifespan Annual Rodent Training | 2013-05-20 13:37:40
29 | Mandy | Pereira | Lifespan Annual Large Animal Training | 2013-05-20 13:29:07
30 | [NAME] | Querfurth | Lifespan Annual Rodent Training | 2013-05-16 16:35:09
31 | [NAME] | Quesenberry | Lifespan Annual Rodent Training | 2013-05-17 13:33:15
32 | [NAME] | Rutledge | Lifespan Annual Rodent Training | 2013-04-30 13:54:34
33 | Juan | Sanchez-Esteban | Lifespan Annual Rodent Training | 2013-05-14 11:13:38
34 | Arina | [NAME] | Lifespan Annual Rodent Training | 2013-05-20 13:41:36
35 | Arina | [NAME] | Lifespan Annual Large Animal Training | 2013-05-20 13:26:38
36 | MIHAI | VANCEA | Lifespan Annual Rodent Training | 2013-05-15 14:48:02
37 | MIHAI | VANCEA | Lifespan Annual Large Animal Training | 2013-05-15 14:38:36
Spreadsheet: 818245d1676663265-need-formula-to-return-phrase-based-upon-drop-down-choice-example-data-validation-tms
Sheet: States

State Name | USPS Abbreviation | Traditional Abbreviation
Alabama | AL | Ala.
Alaska | AK | Alaska
Arizona | AZ | Ariz.
Arkansas | AR | Ark.
California | CA | Calif.
Colorado | CO | Colo.
Connecticut | CT | Conn.
Delaware | DE | Del.
Florida | FL | Fla.
Georgia | GA | Ga.
Hawaii | HI | Hawaii
Idaho | ID | Idaho
Illinois | IL | Ill.
Indiana | IN | Ind.
Iowa | IA | Iowa
Kansas | KS | Kans.
Kentucky | KY | Ky.
Louisiana | LA | La.
Maine | ME | Maine
Maryland | MD | Md.
Massachusetts | MA | Mass.
Michigan | MI | Mich.
Minnesota | MN | Minn.
Mississippi | MS | Miss.
Missouri | MO | Mo.
Montana | MT | Mont.
Nebraska | NE | Neb. or Nebr.
Nevada | NV | Nev.
New Hampshire | NH | N.H.
New Jersey | NJ | N.J.
New Mexico | NM | N.Mex.
New York | NY | N.Y.
North Carolina | NC | N.C.
North Dakota | ND | N.Dak.
Ohio | OH | Ohio
Oklahoma | OK | Okla.
Oregon | OR | Ore. or [NAME].
Pennsylvania | PA | Pa.
Rhode Island | RI | R.I.
South Carolina | SC | S.C.
South Dakota | SD | S.Dak.
Tennessee | TN | Tenn.
Texas | TX | Tex. or Texas
Utah | UT | Utah
Vermont | VT | Vt.
Virginia | VA | Va.
Washington | WA | Wash.
West Virginia | WV | W.Va.
Wisconsin | WI | Wis. or Wisc.
Wyoming | WY | Wyo.
Spreadsheet: 33352d1229646113-pivot-table-filtering-on-individual-counts-not-total-test4
Sheet: 47

Week Num | 47
Count of Case ID.
Name | Total
Name 1032 | 7
Name 1037 | 8
Name 1076 | 9
Name 1173 | 6
Name 1178 | 8
Name 1331 | 9
Name 1405 | 8
Name 1524 | 7
Name 188 | 6
Name 1929 | 9
Name 1960 | 7
Name 1994 | 12
Name 2073 | 9
Name 261 | 6
Name 285 | 8
Name 637 | 6
Name 721 | 6
Name 876 | 9
Name 877 | 6
Grand Total | 146
Spreadsheet: 879539d1727111312-duplicated-values-in-sum-c-lulas-repetidas-teste
Sheet: Sheet1

ED_DEMAND_TYPE | ED_ORDER_NUM | ED_ORDER_TYPE | [NAME] | ED_ITEM | ED_ITEM_DESCRIPTION | ED_DEMAND_QUANTITY | DEMAND_SUPPLY_DATE | ED_PROJECT_NUMBER | ED_TASK_NUMBER | SUP_PROJECT_NUMBER | SUP_TASK_NUMBER | SUPPLY_DEMAND_TYPE | SUP_Requisition_No | PO_DEMAND_NUMBER | PO_LINE_DEMAND_LINE_NUMBER | NSO_NUMBER | NSO_LINE_NUMBER | SUPPLY_DEMAND_DATE | SUPPLY_DEMAND_QUANTITY | Adjusted On Hand
Sales Orders | 481027 | BR REPAIR NATIONAL | 83.1 | 10032557-018 | Washer;Lock, Helical Spring;Nom Sz 0.500 in;Matl Steel;Zinc Plated;ASME B18.21.1;Thk .125 in | 8 | 2024-09-18 23:59:00 | 22404 | 1.6 | 22404 | 1.6 | On Hand |  |  |  |  |  | 2024-09-19 00:00:00 | 8
Sales Orders | 511346 | BR REPAIR NATIONAL | 27.1 | 10032557-018 | Washer;Lock, Helical Spring;Nom Sz 0.500 in;Matl Steel;Zinc Plated;ASME B18.21.1;Thk .125 in | 17 | 2024-09-18 23:59:00 | 25007 | 1.6 | 25007 | 1.6 | On Hand |  |  |  |  |  | 2024-09-19 00:00:00 | 47
Sales Orders | 511346 | BR REPAIR NATIONAL | 53.1 | 10032557-018 | Washer;Lock, Helical Spring;Nom Sz 0.500 in;Matl Steel;Zinc Plated;ASME B18.21.1;Thk .125 in | 22 | 2024-09-18 23:59:00 | 25007 | 1.6 | 25007 | 1.6 | On Hand |  |  |  |  |  | 2024-09-19 00:00:00 | 47
Sales Orders | 511346 | BR REPAIR NATIONAL | 86.1 | 10032557-018 | Washer;Lock, Helical Spring;Nom Sz 0.500 in;Matl Steel;Zinc Plated;ASME B18.21.1;Thk .125 in | 8 | 2024-09-18 23:59:00 | 25007 | 1.6 | 25007 | 1.6 | On Hand |  |  |  |  |  | 2024-09-19 00:00:00 | 47
Sales Orders | 481027 | BR REPAIR NATIONAL | 83.1 | 10032557-018 | Washer;Lock, Helical Spring;Nom Sz 0.500 in;Matl Steel;Zinc Plated;ASME B18.21.1;Thk .125 in | 8 | 2024-09-18 23:59:00 | 22404 | 1.6 | 22404 | 1.6 | Sales Orders |  | 481027 | 83.1 |  |  | 2024-09-18 23:59:00 | -8
Sales Orders | 511346 | BR REPAIR NATIONAL | 27.1 | 10032557-018 | Washer;Lock, Helical Spring;Nom Sz 0.500 in;Matl Steel;Zinc Plated;ASME B18.21.1;Thk .125 in | 17 | 2024-09-18 23:59:00 | 25007 | 1.6 | 25007 | 1.6 | Sales Orders |  | 511346 | 27.1 |  |  | 2024-09-18 23:59:00 | -17
Sales Orders | 511346 | BR REPAIR NATIONAL | 53.1 | 10032557-018 | Washer;Lock, Helical Spring;Nom Sz 0.500 in;Matl Steel;Zinc Plated;ASME B18.21.1;Thk .125 in | 22 | 2024-09-18 23:59:00 | 25007 | 1.6 | 25007 | 1.6 | Sales Orders |  | 511346 | 53.1 |  |  | 2024-09-18 23:59:00 | -22
Sales Orders | 511346 | BR REPAIR NATIONAL | 86.1 | 10032557-018 | Washer;Lock, Helical Spring;Nom Sz 0.500 in;Matl Steel;Zinc Plated;ASME B18.21.1;Thk .125 in | 8 | 2024-09-18 23:59:00 | 25007 | 1.6 | 25007 | 1.6 | Sales Orders |  | 511346 | 86.1 |  |  | 2024-09-18 23:59:00 | -8
Spreadsheet: 727324d1617836807-formula-multi-page-and-columns-commissions-test
Sheet: Health Partners

start | name | Group | Agent | Jan | Feb | March | April | May | June | July | August | Sept | October | November | December
2021-02-01 00:00:00 |  | [NAME] | [NAME] | NA | 16
2021-01-01 00:00:00 |  | GCJ | [NAME] | 16 | 16 | 16
2021-02-01 00:00:00 |  | FC | [NAME] | NA | 36
2021-02-01 00:00:00 |  | [NAME] | [NAME] | NA | 36
2021-02-01 00:00:00 |  | [NAME] | [NAME] | NA | 16
2021-01-01 00:00:00 |  | MF | [NAME] | 16
2021-01-01 00:00:00 |  | GCJ | [NAME] | 16
2021-01-01 00:00:00 |  | GCJ | [NAME] | 16
2021-01-01 00:00:00 |  | GCJ | [NAME] | 16
2021-01-01 00:00:00 |  | GCJ | [NAME] | 16
2021-01-01 00:00:00 |  | GCJ | [NAME] | 16
2021-01-01 00:00:00 |  | GCJ | [NAME] | 16
2021-01-01 00:00:00 |  | GCJ | [NAME] | 16
2021-01-01 00:00:00 |  | GCJ | [NAME] | 16
2021-01-01 00:00:00 |  | GCJ | [NAME] | 16
2021-01-01 00:00:00 |  | GCJ | [NAME] | 16
2021-04-01 00:00:00 |  | GS | [NAME] | NA | NA | NA
2021-04-01 00:00:00 |  | GS | [NAME] | NA | NA | NA
2021-04-01 00:00:00 |  | GS | [NAME] | NA | NA | NA
Spreadsheet: 684394d1593346608-how-to-count-same-numbers-products-from-another-data-from-each-rows-c2-i1000000-inventory
Sheet: Data

Sr no | SAP code | Product A | Product B | Product C | Product D | Product E | Product F | product G
JA-0090-20 | SS-002245 | 574 | 576 | 578 | 580 | 582 | 584 | 586
JA-0090-21 | SS-002246 | 5 | 10 | 15 | 20 | 25 | 30 | 35
JA-0090-22 | SS-002247 | 580 | 582 | 584 | 586 | 588 | 590 | 592
JA-0090-23 | SS-002248 | 565 | 567 | 569 | 571 | 573 | 575 | 577
JA-0090-24 | SS-002249 | 566 | 568 | 570 | 572 | 574 | 576 | 578
JA-0090-25 | SS-002250 | 567 | 569 | 571 | 573 | 575 | 577 | 579
JA-0090-26 | SS-002251 | 568 | 570 | 572 | 574 | 576 | 578 | 580
JA-0090-27 | SS-002252 | 569 | 571 | 573 | 575 | 577 | 579 | 581
JA-0090-28 | SS-002253 | 125666 | 125667 | 15 | 556 | 557 | 5599 | 556
JA-0090-29 | SS-002254 | 571 | 573 | 575 | 577 | 579 | 581 | 583
JA-0090-30 | SS-002255 | 572 | 574 | 576 | 578 | 580 | 582 | 584
JA-0090-31 | SS-002256 | 573 | 575 | 577 | 579 | 581 | 583 | 585
JA-0090-32 | SS-002257 | 574 | 576 | 578 | 580 | 582 | 584 | 586
JA-0090-33 | SS-002258 | 575 | 577 | 579 | 581 | 583 | 585 | 587
JA-0090-34 | SS-002259 | 576 | 578 | 580 | 582 | 584 | 586 | 588
JA-0090-35 | SS-002260 | 577 | 579 | 581 | 583 | 585 | 587 | 589
JA-0090-36 | SS-002261 | 333 | 67345986 | 475 | 6664423 | 323 | 67987 | 345934
JA-0090-37 | SS-002262 | 579 | 581 | 583 | 585 | 587 | 589 | 591
 |  | 1 | 2 | 3 | 4 | 5 | 6 | 7
Spreadsheet: sally_beck__35543__Energy Ops 98-01 headcount
Sheet: Active Deals vs Headcount

E N R O N   W H O L E S A L E   S E R V I C E S
Enron Networks - Energy Operations 2001 Plan
Comparison of Transaction Growth in Active Deals to Headcount Growth
 |  |  |  |  |  |  |  |  |  |  |  |  |  | Active Deals
 |  |  |  |  |  |  |  |  |  |  |  |  |  | 1999-09-01 00:00:00 |  | 2000-09-01 00:00:00 | 2000-10-01 00:00:00 | 2000-11-01 00:00:00 | 2000-12-01 00:00:00 | 2001-01-01 00:00:00 | 2001-02-01 00:00:00 | 2001-03-01 00:00:00 |  | Increase Sep 99 to Mar 01 |  | % Increase
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 32053 | 42394 | 36438 | 37218 | 42241 | 50164
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 23366 | 23944 | 22345 | 22738 | 24147 | 26917 | 22573
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 37661 | 45021 | 53765 | 56167 | 57684 | 57959
 |  |  |  |  |  |  |  |  |  |  |  |  | Total
 |  |  |  |  |  |  |  |  |  |  |  |  |  | Energy Operations Headcount
 |  |  |  |  |  |  |  |  |  |  |  |  |  | 1999-09-01 00:00:00 |  | 2000-09-01 00:00:00 | 2000-10-01 00:00:00 | 2000-11-01 00:00:00 | 2000-12-01 00:00:00 | 2001-01-01 00:00:00 | 2001-02-01 00:00:00 | 2001-03-01 00:00:00 |  | Increase |  | % Increase
 |  |  |  |  |  |  |  |  |  |  |  |  | Adj. Plan Headcount | 346 |  | 390
 |  |  |  |  |  |  |  |  |  |  |  |  | Actual Headcount | 346 |  | 393
Spreadsheet: 179638d1347334853-performing-pivot-calculation-not-using-pivot-aaa
Sheet: Sheet1

Product no. | Price | Date |  |  |  |  | Date | Price | Quantity of items sold |  |  | data | cena | Quantity of items sold
200A | 200 | 2012-09-10 00:00:00 |  |  |  | 200A | 2012-09-10 00:00:00 | 200 |  |  | 300B | 2012-09-10 00:00:00 | 295
300B | 295 | 2012-09-10 00:00:00 |  |  |  |  | 2012-09-09 00:00:00 | 210 |  |  |  | 2012-09-09 00:00:00 | 310
400C | 405 | 2012-09-10 00:00:00 |  |  |  |  | 2012-09-08 00:00:00 | 210 |  |  |  | 2012-09-08 00:00:00 | 350
500D | 502 | 2012-09-10 00:00:00
600E | 502 | 2012-09-10 00:00:00
200A | 200 | 2012-09-10 00:00:00
500D | 502 | 2012-09-10 00:00:00
300B | 295 | 2012-09-10 00:00:00
400C | 405 | 2012-09-10 00:00:00
400C | 405 | 2012-09-10 00:00:00
400C | 399 | 2012-09-09 00:00:00
400C | 399 | 2012-09-09 00:00:00
500D | 399 | 2012-09-09 00:00:00
300B | 310 | 2012-09-09 00:00:00
600E | 650 | 2012-09-09 00:00:00
300B | 320 | 2012-09-09 00:00:00
300B | 320 | 2012-09-09 00:00:00
200A | 210 | 2012-09-09 00:00:00
500D | 495 | 2012-09-09 00:00:00
200A | 210 | 2012-09-09 00:00:00
200A | 230 | 2012-09-08 00:00:00
500D | 366 | 2012-09-08 00:00:00
300B | 350 | 2012-09-08 00:00:00
200A | 210 | 2012-09-08 00:00:00
200A | 210 | 2012-09-08 00:00:00
200A | 210 | 2012-09-08 00:00:00 |  |  |  |  | [NAME] z Cena
200A | 210 | 2012-09-08 00:00:00 |  |  |  |  | Nr.Produkt | data | Suma
500D | 366 | 2012-09-08 00:00:00 |  |  |  |  | 200A | 2012-09-08 00:00:00 | 5
 |  |  |  |  |  |  |  | 2012-09-09 00:00:00 | 2
 |  |  |  |  |  |  |  | 2012-09-10 00:00:00 | 2
 |  |  |  |  |  |  | 200A Suma |  | 9
 |  |  |  |  |  |  | 300B | 2012-09-08 00:00:00 | 1
 |  |  |  |  |  |  |  | 2012-09-09 00:00:00 | 3
 |  |  |  |  |  |  |  | 2012-09-10 00:00:00 | 2
 |  |  |  |  |  |  | 300B Suma |  | 6
 |  |  |  |  |  |  | 400C | 2012-09-09 00:00:00 | 2
 |  |  |  |  |  |  |  | 2012-09-10 00:00:00 | 2
 |  |  |  |  |  |  | 400C Suma |  | 4
 |  |  |  |  |  |  | 500D | 2012-09-08 00:00:00 | 2
 |  |  |  |  |  |  |  | 2012-09-09 00:00:00 | 2
 |  |  |  |  |  |  |  | 2012-09-10 00:00:00 | 2
 |  |  |  |  |  |  | 500D Suma |  | 6
 |  |  |  |  |  |  | 600E | 2012-09-09 00:00:00 | 1
 |  |  |  |  |  |  |  | 2012-09-10 00:00:00 | 1
 |  |  |  |  |  |  | 600E Suma |  | 2
 |  |  |  |  |  |  | (puste) | 2012-09-10 00:00:00 | 1
 |  |  |  |  |  |  | (puste) Suma |  | 1
 |  |  |  |  |  |  | Suma końcowa |  | 28
Spreadsheet: 91fb8e33-828d-4b24-8935-ba5a5add9e99
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
PBORB | Test | PBORB | Lyme Disease (Borrelia burgdorferi), Molecular Detection, PCR, Blood | Lyme Disease PCR, B | Real-Time Polymerase Chain Reaction (PCR)/DNA [NAME] (PCR is utilized pursuant to a license agreement with Roche Molecular Systems, Inc.) | [NAME], leak proof vial: ScwLkPf |  |  |  |  | Container/Tube: Lavender top (EDTA) [NAME]: 1 mL Forms: If not ordering electronically, submit a Microbiology Request Form (Supply T244) with the specimen. | 0.3 mL | Hemolysis	Mild OK; Gross OK Thawing	Warm OK; Cold OK Lipemia	NA Icterus	NA Other	Anticoagulants other than EDTA | Negative | Monday through Saturday; (June through November) Monday through Friday; (December through May) | 1 day | 4 days | 1 | 87476 |  |  |  |  | Rochester
PBORB | [NAME] | WBEDTA | [NAME] EDTA |  |  |  | Refrigerated | 7 days
PBORB | Result | 56080 | Lyme Disease PCR, B | Lyme Disease PCR, B | Alphanumeric |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 32667-8
Spreadsheet: 1d462d95-c996-41ed-9a5d-444caf73c041
Sheet: Sheet1

Unnamed: 0 | Unnamed: 1 | Unnamed: 2 | Unnamed: 3 | Unnamed: 4 | Unnamed: 5 | Unnamed: 6 | Unnamed: 7 | Unnamed: 8 | Unnamed: 9 | Unnamed: 10 | Unnamed: 11
 | Time Series Workbook
 | 5671.0 Lending Finance, Australia
 | TABLE 9. FINANCE COMMITMENTS, For Motor Vehicles: Australia, Original ($000)
Related Information: | Summary Publication | Explanatory Notes | Inquiries
 | Glossary
Data Item Description |  |  | Series Type | Series ID | Series Start | Series End | No. Obs. | Unit | Data Type | [NAME]. | Collection Month
Personal Finance - New motor cars and station wagons ; |  |  | Original | A2414166T | 1985-01-01 00:00:00 | 2011-02-01 00:00:00 | 314 | $'000 | FLOW | Month | 1
Personal Finance - Used motor cars and station wagons ; |  |  | Original | A2414167V | 1985-01-01 00:00:00 | 2011-02-01 00:00:00 | 314 | $'000 | FLOW | Month | 1
Personal Finance - Motor cycles ; |  |  | Original | A2414168W | 1985-01-01 00:00:00 | 2011-02-01 00:00:00 | 314 | $'000 | FLOW | Month | 1
Personal Finance - Other motor vehicles ; |  |  | Original | A2414169X | 1985-01-01 00:00:00 | 2011-02-01 00:00:00 | 314 | $'000 | FLOW | Month | 1
Personal Finance - Total ; |  |  | Original | A2414170J | 1985-01-01 00:00:00 | 2011-02-01 00:00:00 | 314 | $'000 | FLOW | Month | 1
Commercial Finance ; |  |  | Original | A2414171K | 1985-01-01 00:00:00 | 2011-02-01 00:00:00 | 314 | $'000 | FLOW | Month | 1
Value of Lease Finance Commitments ; |  |  | Original | A2414172L | 1985-01-01 00:00:00 | 2011-02-01 00:00:00 | 314 | $'000 | FLOW | Month | 1
TOTAL ; |  |  | Original | A2414173R | 1985-01-01 00:00:00 | 2011-02-01 00:00:00 | 314 | $'000 | DERIVED | Month | 1
© Commonwealth of Australia  2011
Spreadsheet: 195477d1353525217-help-with-conditional-formating-eoghanmolloy-conditional-formatting-test_cf
Sheet: Sheet1

 | Example 1
 | Example 1
 | Example 1
 | Example 2
 | Example 2
 | Example 2
 | Example 3
 | Example 3
 | Example 3
 | Example 3
 | Example 4
 | Example 4
 | Example 4
 | Example 4
 | Example 5
 | Example 5
 | Example 5
 | Example 5
 | Example 5
 | Example 5
Spreadsheet: 881176d1729100534-custom-lambda-behaviour-depending-on-relative-or-absolute-references-test_byrow2_alternative
Sheet: Sheet1

1 | a |  |  |  |  | b | c |  |  | b | c
1 | b | 2 |  |  |  | a |  |  | c | a | #N/A
2 | c | 3 |  |  |  | d |  |  | d | d | #N/A
3 | d
3 | d
2 | a
1 | c
 |  |  |  |  |  |  |  |  |  | b | c
 |  |  |  |  |  |  |  |  | c | a | #N/A
 |  |  |  |  |  |  |  |  | d | d | #N/A
 |  |  |  |  |  |  |  |  |  | b | c
 |  |  |  |  |  |  |  |  | c | a | #N/A
 |  |  |  |  |  |  |  |  | d | d | #N/A
 |  |  |  |  |  |  |  |  | a | b | c
 |  |  |  |  |  |  |  | 2 | c | a | #N/A
 |  |  |  |  |  |  |  | 3 | d | d | #N/A
Spreadsheet: 156290d1337255719-excel-2007-help-with-sorting-data-into-a-summary-table-example-1
Sheet: Sheet1

Agent | Date | Team | Requires Feedback
bob | 2012-06-01 00:00:00 | sales 1 | Y
tom | 2012-06-01 00:00:00 | sales 2 | Y
bob | 2012-06-02 00:00:00 | sales 1 | N
tom | 2012-06-01 00:00:00 | sales 2 | Y
bob | 2012-06-02 00:00:00 | sales 1 | Y
tom | 2012-06-02 00:00:00 | sales 2 | N
Spreadsheet: 83031d1283057078-data-filters-for-making-dynamic-interactive-error-graphs-test
Sheet: Sheet1

 | Resources | R1 | R2 | R3 | R4 | R5 | R6 | R7 | R8 | R9 | R10 | TOTAL
 | Defects
 | D1 | 3 | 5 | 7 | 3 | 8 | 3 | 1 | 5 | 5 | 5
 | D2 | 5 | 2 | 3 | 7 | 4 | 4 | 3 | 3 | 7 | 2
 | D3 | 8 | 3 | 9 | 3 | 5 | 2 | 7 | 1 | 8 | 3
 | D4 | 4 | 1 | 2 | 3 | 6 | 5 | 3 | 6 | 2 | 3
 | D5 | 7 | 3 | 6 | 5 | 4 | 1 | 2 | 5 | 7 | 4
 | D6 | 3 | 7 | 3 | 6 | 2 | 3 | 6 | 5 | 4 | 7
 | D7 | 5 | 2 | 4 | 4 | 4 | 3 | 3 | 5 | 1 | 4
 | D8 | 2 | 1 | 7 | 2 | 3 | 2 | 5 | 6 | 4 | 6
 | D9 | 4 | 5 | 3 | 1 | 3 | 5 | 7 | 3 | 5 | 3
 | D10 | 10 | 8 | 5 | 4 | 7 | 3 | 4 | 6 | 5 | 6
 | TOTAL
Spreadsheet: 677139d1589210928-populate-calendar-and-summary-invercargill-leave-copy
Sheet: LeaveCal2

Location : | [NAME]
Month : | May
Year : | 2020
Date
Name
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | Names that appears on the list filtered by Location, Month and Year
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | So every single name that appears means they took [NAME]
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | on this following month, date and Location
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | You may break my formula by input manually [NAME]
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | In case you want to show that name although they don’t take leave schedule
Spreadsheet: 120531d1315356315-linear-interpolation-between-just-two-points-betweentwopoints
Sheet: Sheet1

original data | result | helper columns (can be hidden)
10 | 10 | 10 | 10 | 1
 | 12.5 | 10 | 20 |  | 4
 | 15 | 10 | 20 |  | 4
 | 17.5 | 10 | 20 |  | 4
20 | 20 | 20 | 20 | 5
 | 22.5 | 20 | 30 |  | 4
 | 25 | 20 | 30 |  | 4
 | 27.5 | 20 | 30 |  | 4
30 | 30 | 30 | 30 | 9
 | 28.75 | 30 | 25 |  | 4
 | 27.5 | 30 | 25 |  | 4
 | 26.25 | 30 | 25 |  | 4
25 | 25 | 25 | 25 | 13
 | 23.75 | 25 | 20 |  | 4
 | 22.5 | 25 | 20 |  | 4
 | 21.25 | 25 | 20 |  | 4
20 | 20 | 20 | 20 | 17
 | 16.66666666666667 | 20 | 10 |  | 3
 | 13.33333333333333 | 20 | 10 |  | 3
10 | 10 | 10 | 10 | 20
 | 8.333333333333334 | 10 | 5 |  | 3
 | 6.666666666666667 | 10 | 5 |  | 3
5 | 5 | 5 | 5 | 23
Spreadsheet: 30912d1226603823-multiple-row-contents-into-one-row-multiple-row-contents-into-one-row
Sheet: Catalog

Material | PO Text | OEM part no. | OEM name
90100100 | RANGE 3 CONDUCTOR BOX X PIN | 123-8954 | AB-SYSTEMS | RANGE 3 CONDUCTOR BOX X PIN, 309.72 LB/FT (1.000" WT), XLF CONNECTIONS
 | 309.72 LB/FT (1.000" WT)
 | XLF CONNECTIONS
90100101 | COND,30,310#,X52,XLF B,W/FS,R3 | 123-8955 | AB-SYSTEMS | COND,30,310#,X52,XLF B,W/FS,R3, RANGE 3 CONDUCTOR BOX X FLOAT SHOE, 309.72 LB/FT (1.000" WT), XLF BOX X WELD ON FLOAT SHOE
 | RANGE 3 CONDUCTOR BOX X FLOAT SHOE
 | 309.72 LB/FT (1.000" WT)
 | XLF BOX X WELD ON FLOAT SHOE
90100102 | RANGE 3 CONDUCTOR BOX X PIN WITH STABILIZER FINS TYPE ? | 123-8956 | AB-SYSTEMS | RANGE 3 CONDUCTOR BOX X PIN WITH STABILIZER FINS TYPE ?, 309.72 LB/FT (1.000" WT), XLF CONNECTIONS, W/STABILIZER FINS WELDED ON, [NAME],
 | 309.72 LB/FT (1.000" WT)
 | XLF CONNECTIONS
 | W/STABILIZER FINS WELDED ON
 | STARTER HEAD
90100103 | RANGE 3 CONDUCTOR BOX X PIN WITH CAMERON LOAD RING | 123-8958 | AB-SYSTEMS | RANGE 3 CONDUCTOR BOX X PIN WITH CAMERON LOAD RING, 309.72 LB/FT (1.000" WT), XLF CONNECTIONS
 | 309.72 LB/FT (1.000" WT)
 | XLF CONNECTIONS
90100104 | RANGE 3 CASING BOX X PIN | 1012235-1 | MANNESMAN | RANGE 3 CASING BOX X PIN, 87.5 LB/FT (0.435" WT), BIG OMEGA CONNECTIONS (WITH K-55 COUPLING),
 | 87.5 LB/FT (0.435" WT)
 | BIG OMEGA CONNECTIONS (WITH K-55 COUPLING)
90100105 | CASING COUPLING |  | STATES OIL | CASING COUPLING, 87.5 LB/FT (0.435" WT), BIG OMEGA CONNECTION
 | 87.5 LB/FT (0.435" WT)
 | BIG OMEGA CONNECTION
90100106 | RANGE 3 CASING PIN X PIN |  | STATES OIL | RANGE 3 CASING PIN X PIN, 87.5 LB/FT (0.435" WT), API BUTTRESS CONNECTIONS
 | 87.5 LB/FT (0.435" WT)
 | API BUTTRESS CONNECTIONS
90100107 | CASING COUPLING |  | STATES OIL | CASING COUPLING, 87.5 LB/FT (0.435" WT), BTC CONNECTION
 | 87.5 LB/FT (0.435" WT)
 | BTC CONNECTION
90100108 | RANGE 3 BOX X PIN CASING |  | SIDER | RANGE 3 BOX X PIN CASING, 68 LB/FT (0.480" WT), BUTTRESS CONNECTIONS, (CHECK 90100378,90100379,90100828 FOR DUPLICATIONS)
 | 68 LB/FT (0.480" WT)
 | BUTTRESS CONNECTIONS
 | (CHECK 90100378,90100379,90100828 FOR DUPLICATIONS)
90100109 | RANGE 3 PIN X PIN CASING |  | SIDER | RANGE 3 PIN X PIN CASING, 68 LB/FT (0.480" WT), BUTTRESS CONNECTIONS
 | 68 LB/FT (0.480" WT)
 | BUTTRESS CONNECTIONS
90100110 | CASING COUPLING |  | SIDER | CASING COUPLING
x