tianzl66/Sheetpedia huggingface dataset:
Spreadsheet: 692422d1598331282-allocate-value-on-fifo-basis-book2
Sheet: Sheet1

 | Date | Consumption | Allocation
 |  |  | 50 | This value can be zero/positive/negative
 | 2020-01-31 00:00:00 | 10 |  |  |  |  |  |  | 1
 | 2020-03-01 00:00:00 | -200 | 30 |  |  |  |  |  | 2
 | 2020-03-28 00:00:00 | 100 |  |  |  |  |  |  | 3
 | 2020-03-13 00:00:00 | 150 |  |  |  |  |  |  | 4
 | 2018-05-01 00:00:00 | -50 |  |  |  |  |  |  | 5
 | 2020-01-20 00:00:00 | 0 |  |  |  |  |  |  | 6
 | 2020-02-03 00:00:00 | 15 |  |  |  |  |  |  | 7
 | 2020-02-29 00:00:00 | 50 |  |  |  |  |  |  | 8
 | 2020-04-07 00:00:00 | 400 |  |  |  |  |  |  | 9
 | 2020-04-05 00:00:00 | 600 |  |  |  |  |  |  | 10
 | 2020-01-26 00:00:00 | 0 |  |  |  |  |  |  | 11
 | 2020-02-22 00:00:00 | -5 |  |  |  |  |  |  | 12
 | 2020-03-01 00:00:00 | -800 |  |  |  |  |  |  | 13
 | 2020-03-28 00:00:00 | 300 |  |  |  |  |  |  | 14
 |  | Check |  | Should always be zero
Spreadsheet: john_lavorato__16442__west prices
Sheet: Power West Price Off-Peak

 |  | 2000 |  |  |  | 2001 |  |  |  | 2002 | 2003 |  |  | 2004-2014
[NAME] | 2000-08-01 00:00:00 | 2000-09-01 00:00:00 | Q4-00 | Cal-00 | Q1-01 | Q2-01 | Q3-01 | Q4-01 | Cal-01 | Cal-02 | Cal-03 | Q1 | Q2 | Q3 | Q4 | Cal 04-14
MID-COLUMBIA
COB
NP15
ZP26
SP15
Palo Verde
ROCKIES
Change |  | 2000 |  |  |  | 2001 |  |  |  | 2002 | 2003 |  |  | 2004-2014
[NAME] | 2000-08-01 00:00:00 | 2000-09-01 00:00:00 | Q4-00 | Cal-00 | Q1-01 | Q2-01 | Q3-01 | Q4-01 | Cal-01 | Cal-02 | Cal-03 | Q1 | Q2 | Q3 | Q4 | Cal 04-14
MID-COLUMBIA
COB
NP15
ZP26
SP15
Palo Verde
ROCKIES
 |  | 2000 |  |  |  | 2001 |  |  |  | 2002 | 2003 |  |  | 2004-2014
[NAME] | 2000-08-01 00:00:00 | 2000-09-01 00:00:00 | Q4-00 | Cal-00 | Q1-01 | Q2-01 | Q3-01 | Q4-01 | Cal-01 | Cal-02 | Cal-03 | Q1 | Q2 | Q3 | Q4 | Cal 04-14
MID-COLUMBIA | 80 | 60.25 | 63.6173835125448 | 61.9336917562724 | 45.34331797235023 | 41.88131720430107 | 36.04193548387098 | 46.04525089605735 | 42.32795538914491 | 31.07859722862263 | 26.82859722862263 | 18.86403435274403 | 7.599531818181817 | 18.26011730205279 | 28.26343271423917 | 18.24677904680445
COB | 80 | 61.33333333333333 | 78.62544802867383 | 69.97939068100358 | 43.24270353302612 | 39.34202508960573 | 34.11935483870968 | 50.35528673835125 | 41.76484254992319 | 33.6265806233999 | 30.12658062339989 | 27.79326560536238 | 15.22932440208537 | 22.61480938416422 | 38.85074128380581 | 26.12203516885445
NP15 | 75 | 62.2 | 66.17007168458781 | 64.1850358422939 | 48.2550307219662 | 42.54633512544802 | 38.94618279569894 | 48.05864695340502 | 44.45154889912955 | 39.45154889912954 | 32.97083333333334 | 27.47878787878789 | 22.37878787878788 | 27.16909090909092 | 26.7021212121212 | 25.93219696969697
ZP26 | 50 | 50.83333333333333 | 52.64413082437276 | 51.73873207885305 | 36.72407834101382 | 28.88575268817204 | 28.81677419354839 | 34.45698924731183 | 32.22089861751152 | 27.42089861751152 | 24.8625 | 20.26666666666667 | 17.33666666666666 | 26.11060606060606 | 21.68666666666667 | 21.35015151515151
SP15 | 50 | 50.83333333333333 | 52.64413082437276 | 51.73873207885305 | 36.72407834101382 | 28.88575268817204 | 28.81677419354839 | 34.45698924731183 | 32.22089861751152 | 27.42089861751152 | 24.8625 | 20.26666666666667 | 17.33666666666666 | 26.84 | 21.68666666666667 | 21.5325
Palo Verde | 65 | 43.75 | 48.16442652329749 | 45.95721326164875 | 35.18817204301075 | 24.48091397849462 | 23.32096774193549 | 39.90120967741935 | 30.72281586021506 | 26.17339364290319 | 24.18907508321471 | 28.94381640671306 | 19.47532687056703 | 10.00346370706478 | 31.42698008962035 | 22.46239676849131
ROCKIES | 55 | 44.5 | 41.64560931899641 | 43.0728046594982 | 29.77342549923195 | 18.71478494623656 | 16.78870967741936 | 33.7856182795699 | 24.76563460061444 | 20.11540593168968 | 18.13108737200119 | 23.12584405648265 | 13.70919783830897 | 3.471205642548653 | 25.31138869177088 | 16.40440905727779
Spreadsheet: 857164d1706205498-vlookup-next-match-in-data-series-next-inventory-location-etaf
Sheet: Sheet1

Item | Lot | Location | Qty OH |  |  |  | Item | Location1 | Qty OH | Location2 | Qty oH | Location3 | Qty OH
8833U 25 ONESIZE NA | 000091229 | 14-026-E | 130 |  |  |  | 8833U 25 ONESIZE NA |  |  |  |  | 1,""),1)),"")
8833U 25 ONESIZE NA | 000091229 | 19-144-D | 59 |  |  |  | 8833U 432 ONESIZE NA
8833U 432 ONESIZE NA | 000090115 | 07-168-B | 52 |  |  |  | 8833U 433 ONESIZE NA
8833U 433 ONESIZE NA | 000089620 | 07-100-E | 172 |  |  |  | 8833U 61 ONESIZE NA
8833U 433 ONESIZE NA | 000089620 | 28-163-A-04 | 26 |  |  |  | 8833U 750 ONESIZE NA
8833U 433 ONESIZE NA | 000089620 | 08-004-D | 18
8833U 433 ONESIZE NA | 000089620 | 07-027-B | 17
8833U 433 ONESIZE NA | 000089620 | 17-042-B | 4
8833U 61 ONESIZE NA | 000088649 | 11-124-E | 272
8833U 61 ONESIZE NA | 000090111 | 20-112-D | 244
8833U 61 ONESIZE NA | 000090111 | 06-107-B | 242
8833U 61 ONESIZE NA | 000090111 | 05-038-F | 235
8833U 61 ONESIZE NA | 000088649 | 11-076-F | 200
8833U 61 ONESIZE NA | 000090111 | 12-047-B | 153
8833U 61 ONESIZE NA | 000088649 | 18-159-E | 81
8833U 61 ONESIZE NA | 000090111 | 17-103-F | 81
8833U 61 ONESIZE NA | 000090111 | 16-071-F | 43
8833U 61 ONESIZE NA | 000088649 | 04-071-D | 33
8833U 61 ONESIZE NA | 000089620 | 06-092-D | 25
8833U 61 ONESIZE NA | 000089620 | 09-160-E | 19
8833U 61 ONESIZE NA | 000088649 | 07-047-B | 14 |  |  |  |  | 07-168-B | 52
8833U 61 ONESIZE NA | 000088649 | 04-002-C | 8 |  |  |  |  | 07-100-E | 172
8833U 61 ONESIZE NA | 000089620 | 06-063-F | 6 |  |  |  |  | 11-124-E | 272
8833U 750 ONESIZE NA | 000090111 | 07-029-D | 218 |  |  |  |  | 07-029-D | 218
8833U 750 ONESIZE NA | 000090111 | 19-021-F | 168
8833U 750 ONESIZE NA | 000090111 | 20-072-F | 159
8833U 750 ONESIZE NA | 000090115 | 07-168-B | 45
8833U 750 ONESIZE NA | 000090115 | 09-129-F | 30
8833U 750 ONESIZE NA | 000090115 | 26-076-A-07 | 19
8833U 750 ONESIZE NA | 000090294 | 04-106-A | 2
8833U 750 ONESIZE NA | 000090115 | 18-161-A | 1
Spreadsheet: richard_shapiro__32395__Lisa - ENW Budget
Sheet: Scenario 2

Cost Center Owner
Cost Center Number
 | Please use this form only for Outside Services
 | Scenario 2:  Basic needs that are essential/necessary
 | Retainers and Identified Needs
 | [NAME] | Activity/Region | 2002 Est. $
 |  | Total:
 | [NAME]
 | [NAME] | Activity/Region | 2002 Est. $
 | Goals: | Protect EOL from regulation;
 |  | Manage regulatory risks associated with financial trading
 | To be determined | - CFTC counsel * | 120000
 | To be determined | - academic support on benefits of financial and electronic trading (ie, liquidity, transparency) | 100000
 | To be determined | - risk management white paper | 25000
 |  | Total:
* CFTC Counsel would advise on such things as:
- how financial products are regulated
- advice on changes in EnronOnline's structure
- assistance with comments to FERC, etc. on their efforts to regulate financial products
Spreadsheet: 870070d1716572605-i-need-help-on-average-sample1
Sheet: Sheet1

 |  |  | Data => |  | Time |  | Name |  | Percent |  | I want this result => |  | Average %
 |  |  |  |  | 2020-12-17 14:07:19 |  | L |  | 0.7126948775 |  |  | Name | 2021 | 2022 | YTD
 |  |  |  |  | 2021-01-11 08:45:47 |  | M |  | 0.4510385757 |  |  | L | 2.2583 | 0.8185 | 1.6412
 |  |  |  |  | 2021-01-11 10:06:53 |  | N |  | 0.4510385757 |  |  | M | 2.2513 | 0.451 | 1.4798
 |  |  |  |  | 2021-01-11 12:22:57 |  | L |  | 0.4510385757 |  |  | N | 1.4011 | 0.8185 | 1.1514
 |  |  |  |  | 2021-01-11 13:49:38 |  | M |  | 0.4510385757
 |  |  |  |  | 2021-01-12 06:36:53 |  | N |  | 0.4510385757
 |  |  |  |  | 2021-01-12 07:15:02 |  | L |  | 0.4510385757
 |  |  |  |  | 2021-01-12 11:57:55 |  | M |  | 0.4510385757
 |  |  |  |  | 2021-01-14 09:17:38 |  | N |  | 1.553398058
 |  |  |  |  | 2021-01-14 10:31:26 |  | L |  | 1.553398058
 |  |  |  |  | 2020-12-17 13:52:24 |  | M |  | 0.6846846847
 |  |  |  |  | 2020-12-21 06:39:11 |  | N |  | 0.6846846847
 |  |  |  |  | 2020-12-21 07:48:47 |  | L |  | 0.6846846847
 |  |  |  |  | 2020-12-21 08:23:46 |  | M |  | 0.6846846847
 |  |  |  |  | 2020-12-28 10:50:18 |  | N |  | 2.586206897
 |  |  |  |  | 2020-12-28 11:16:02 |  | L |  | 6.923076923
 |  |  |  |  | 2020-12-28 11:26:21 |  | M |  | 6.923076923
 |  |  |  |  | 2020-12-18 07:24:10 |  | N |  | 0.7126948775
 |  |  |  |  | 2020-12-18 10:15:30 |  | L |  | 0.7126948775
 |  |  |  |  | 2020-12-21 06:45:37 |  | M |  | 0.7126948775
 |  |  |  |  | 2020-12-28 09:28:30 |  | N |  | 1.620689655
Spreadsheet: 682127d1591909386-lookup-based-on-conditions-lookup-using-position-and-criteria
Sheet: Sheet1

Product Code | Product Name | Region | Country | 31 Dec 2015 | 31 Jan 2016 | 29 Feb 2016 | 31 Mar 2016
AAA | Apple | Europe | UK | 100 | - | - | -
AAA | Apple | Europe | France | - | 100 | - | -
AAA | Apple | Europe | Germany | - | - | 100 | -
Spreadsheet: michelle_lokay__26688__RedRockExpansionBids
Sheet: Sheet2

Transwestern Red Rock Expansion, June 2002
Shipper | Binding? | $[NAME]/mmbtu | Term | Term (months) | Term (days) | Receipt | Delivery | Volume | ROFR? | Gross Value ($) | NPV ($) | Notes
PPL | yes | 0.38 | 30 years, 1 month |  |  | EOT | Citizens/Griffith | 20000 | yes
PPL | yes | 0.225 | 5 years |  |  | EOT | Citizens/Griffith | 7500 | yes
Western | yes | 0.385 | 15 years |  |  | EOT | [NAME] | 10000 | yes
Oneok | yes | 1.75 | 10 months | 10 |  | EOT | [NAME] | 1700 | no
Oneok | yes | 0.75 | 2 months | 2 |  | EOT | [NAME] | 1700 | no
Oneok | yes | 0.75 | 10 months | 10 |  | EOT | [NAME] | 5000 | no
Calpine | no | 0.38 | 15 years |  |  | EOT | PG&E Topock | 40000 | no
US Gypsum | yes | 0.42 | 12 years, 3 months |  |  | EOT | [NAME] | 4500 | yes
BP Energy | yes | 0.38 | 10 years |  |  | EOT | [NAME] | 15000 | no
[NAME] | yes | 0.38 | 15 years |  |  | EOT | [NAME] | 2700 | no
[NAME] | yes | 2.2 | 1 year | 12 |  | EOT | [NAME] | 5300 | no
Spreadsheet: 48166372-b6e6-4fd7-b1ac-f619f6f3760f
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
NPM1 | Test | NPM1 | Nucleophosmin (NPM1) Mutation Analysis | Nucleophosmin Mutation Analysis | DNA Polymerase Chain Reaction (PCR) with Fragment Analysis by Capillary Gel Electrophoresis (PCR is utilized pursuant to a license agreement with Roche Molecular Systems, Inc.) |  |  |  |  |  | The following information is required: 1. Pertinent clinical history 2. Clinical or morphologic suspicion 3. Date of collection 4. Specimen source   Forms:  1. Hematopathology Patient Information Sheet (Supply T676) in Special Instructions 2. If not ordering electronically, please submit a Hematopathology/Molecular Oncology Request Form (Supply T241) with the specimen.  [NAME] must arrive within 168 hours of collection.   Submit only 1 of the following specimens:   Specimen Type: Blood Container/Tube: Lavender top (EDTA) or yellow top (ACD solution B) [NAME]: 3 mL Collection Instructions:  1. Invert several times to mix blood. 2. Send specimen in original tube. 3. Label specimen as blood.   Specimen Type: Bone marrow Container/Tube: Lavender top (EDTA) or yellow top (ACD solution B) [NAME]: 2 mL Collection Instructions: 1. Invert several times to mix bone marrow. 2. Send specimen in original tube. 3. Label specimen as bone marrow.   [NAME]: Extracted DNA from blood or bone marrow Container/Tube: 1.5- to 2-mL tube with indication of volume and concentration of the DNA [NAME] Volume: Entire specimen Collection Instructions: Label specimen as extracted DNA from blood or bone marrow.   [NAME]-embedded bone marrow aspirate clot Container/Tube: Paraffin block | Blood: 0.5 mL/Bone Marrow: 0.5 m | Hemolysis	Mild OK; Gross reject Thawing	Warm reject; Cold reject Lipemia	NA Icterus	NA Other	Bone marrow biopsies, slides, or paraffin shavings | An interpretive report will be provided. | Monday through Friday: 3 p.m. | 4 Days |  | 1 | 81401 |  |  |  |  | Rochester
NPM1 | [NAME] | VARIES | Varies |  |  |  | Ambient | 7 days
NPM1 | Order Question | MP011 | [NAME] |  | Plain Text
NPM1 | Result | MP011 | [NAME] | [NAME] | Alphanumeric |  |  |  |  |  |  |  |  |  |  |  |  |  |  | In Process
NPM1 | Result | 19729 | Final Diagnosis: | Final Diagnosis: | Alphanumeric |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 34574-4 | Path report.final diagnosis:Imp:Pt:[NAME]:Nom:
Spreadsheet: 781086d1652977018-getting-an-hourly-breakdown-of-labour-from-start-and-end-times-hourlylabour
Sheet: Timecard with Payroll Report (6

First Name | In time | Out time | Hours |  |  | 1900-04-09 05:00:00
[NAME] | 2022-04-24 09:00:00 | 2022-04-24 16:30:00 | 7.5 |  |  | 1900-04-09 06:00:00
[NAME] | 2022-04-24 10:00:00 | 2022-04-24 16:30:00 | 6.5 |  |  | 1900-04-09 07:00:00
Zac | 2022-04-24 11:00:00 | 2022-04-24 21:30:00 | 10.5 |  |  | 1900-04-09 08:00:00
Crystal | 2022-04-24 13:00:00 | 2022-04-24 20:30:00 | 7.5 |  |  | 1900-04-09 09:00:00 | 1
[NAME] | 2022-04-24 13:45:00 | 2022-04-24 22:00:00 | 8.25 |  |  | 1900-04-09 10:00:00 | 2
[NAME] | 2022-04-24 15:00:00 | 2022-04-24 21:30:00 | 6.5 |  |  | 1900-04-09 11:00:00 | 3
[NAME] | 2022-04-24 16:45:00 | 2022-04-24 23:00:00 | 6.25 |  |  | 1900-04-09 12:00:00 | 3
[NAME] | 2022-04-24 17:00:00 | 2022-04-24 21:30:00 | 4.5 |  |  | 1900-04-09 13:00:00 | 4.25
[NAME] | 2022-04-24 18:00:00 | 2022-04-25 01:30:00 | 7.5 |  |  | 1900-04-09 14:00:00 | 5
 |  |  |  |  |  | 1900-04-09 15:00:00 | 6
 |  |  |  |  |  | 1900-04-09 16:00:00 | 5.25
 |  |  |  |  |  | 1900-04-09 17:00:00 | 6
 |  |  |  |  |  | 1900-04-09 18:00:00 | 7
 |  |  |  |  |  | 1900-04-09 19:00:00 | 7
 |  |  |  |  |  | 1900-04-09 20:00:00 | 6.5
 |  |  |  |  |  | 1900-04-09 21:00:00 | 4.5
 |  |  |  |  |  | 1900-04-09 22:00:00 | 2
 |  |  |  |  |  | 1900-04-09 23:00:00 | 1
 |  |  |  |  |  | 1900-04-10 00:00:00 | 1
 |  |  |  |  |  | 1900-04-09 01:00:00 | 0.5
 |  |  |  |  |  | 1900-04-09 02:00:00
 |  |  |  |  |  | 1900-04-09 03:00:00
 |  |  |  |  |  | 1900-04-09 04:00:00
Spreadsheet: 464488d1465153087-how-count-occurences-in-multiple-separated-columns-using-countif-or-other-function-tr-eng
Sheet: R.Szubcilski ORG

MIESIĘCZNY  PLAN  TRAS
 | Region............................................ |  |  |  |  |  |  |  |  |  |  |  |  |  | [NAME] |  |  | [NAME]
Lp. | PONIEDZIAŁEK  I |  |  | TYP KLIENTA | TYP WIZYTY | WTOREK  I |  |  |  | TYP KLIENTA | TYP WIZYTY | ŚRODA  I |  |  |  | TYP KLIENTA | TYP WIZYTY | CZWARTEK  I |  |  | TYP KLIENTA | TYP WIZYTY | PIĄTEK  I |  |  | TYP KLIENTA | TYP WIZYTY
1. | pip poznań druskiennicka |  |  |  |  | [NAME] |  |  |  |  |  | [NAME] |  | 2 sklepy |  |  |  | [NAME] |  |  |  |  | [NAME]
2. | [NAME] tatrzańska |  |  |  |  | [NAME] | 5 sklepów |  |  |  |  | Sukces Kołobrzeg |  |  |  |  |  | [NAME] |  |  |  |  | [NAME]
3. | [NAME] [NAME] |  |  |  |  | [NAME] |  |  |  |  |  | [NAME] |  |  |  |  |  | [NAME] |  |  |  |  | [NAME]
4. | [NAME] marcelińska |  |  |  |  | MCC Koszalin |  |  |  |  |  | [NAME] |  |  |  |  |  | [NAME] |  |  |  |  | [NAME]
5. | [NAME] browar |  |  |  |  | [NAME] |  |  |  |  |  | [NAME] |  |  |  |  |  | Real Bukowska Poznań |  |  |  |  | [NAME]
6. | [NAME] gronowa |  |  |  |  |  |  |  |  |  |  | [NAME] |  |  |  |  |  | [NAME] |  |  |  |  | [NAME]
7. | [NAME] plaza |  |  |  |  |  |  |  |  |  |  | Real Ku Słońcu Szczecin |  |  |  |  |  | Levant Foods Poznań |  |  |  |  | [NAME]
8. | mmt chrobrego poznań |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | Poznańdis
9. | pss newa poznań
10.
11.
12.
13.
14.
15.
16.
17.
18.
Lp. | PONIEDZIAŁEK  II |  |  | TYP KLIENTA | TYP WIZYTY | WTOREK  II |  |  |  | TYP KLIENTA | TYP WIZYTY | ŚRODA  II |  |  |  | TYP KLIENTA | TYP WIZYTY | CZWARTEK  II |  |  | TYP KLIENTA | TYP WIZYTY | PIĄTEK  II |  |  | TYP KLIENTA | TYP WIZYTY
1. | pip poznań druskiennicka |  |  |  |  | [NAME] |  |  |  |  |  | [NAME] |  |  |  |  |  | [NAME] |  |  |  |  | MMT Stróżyńskiego
2. | [NAME] tatrzańska |  |  |  |  | [NAME] |  |  |  |  |  | [NAME] |  |  |  |  |  | [NAME] |  |  |  |  | MMT Sobieskiego
3. | [NAME] [NAME] |  |  |  |  | [NAME] |  |  |  |  |  | [NAME] |  |  |  |  |  | [NAME] |  |  |  |  | MMT [NAME]
4. | [NAME] marcelińska |  |  |  |  | PiP Piła Powstańców |  |  |  |  |  | [NAME] |  |  |  |  |  | MMT Suchy Las |  |  |  |  | MMT Przyjaźni
5. | [NAME] browar |  |  |  |  | [NAME] |  |  |  |  |  | [NAME] |  |  |  |  |  | Real Bukowska |  |  |  |  | MMT Pod Lipami
6. | [NAME] gronowa |  |  |  |  | Stogrosz Piła |  |  |  |  |  | [NAME] |  |  |  |  |  | [NAME] |  |  |  |  | MMT Muszkowska
7. | [NAME] plaza |  |  |  |  | [NAME] |  |  |  |  |  | [NAME] |  |  |  |  |  | WSSM Poznań |  |  |  |  | MMT Strzeszyńska
8. | mmt chrobrego poznań |  |  |  |  |  |  |  |  |  |  | [NAME] |  |  |  |  |  | [NAME]
9. | pss newa poznań |  |  |  |  |  |  |  |  |  |  | [NAME] |  |  |  |  |  | [NAME]
10.
11.
Spreadsheet: 708765d1608018777-combine-data-feom-2-rows-in-2-comlumns-into-one-row-and-column-d-and-p-ans
Sheet: Apr

name | bol date | am/pm | d/p |  |  | total
Column1 | Column2 | Column3 | Column4 | Column5 | Column6 | Column7
[NAME] | 2020-04-05 00:00:00 | am | p
Spreadsheet: 767547d1644514285-index-match-errors-index-match
Sheet: Campaign report (6)

Campaign report
November 1, 2021 - January 31, 2022
Campaign status | Campaign | Budget name | Currency code | Budget | Budget type | Status | Status reasons | Optimization score | Campaign type | Clicks | Impr. | CTR | Avg. CPC | Cost | Search impr. share | Search lost IS (budget) | Search lost IS (rank) | Bid strategy type | Conv. rate | Conversions | Cost / conv. | Assisted
Enabled | PPC_BR_Brand | -- | USD | 5 | Daily | Eligible (Limited) | bidding strategy limited; limited by budget; unknown | 86.63 | Search | 112 | 925 | 0.1211 | 2.17 | 242.71 | 0.3926 | 0.1531 | 0.4544 | Target Impression Share | 0.3036 | 34 | 7.14
Enabled | PPC_NB_Invisalign | -- | USD | 10 | Daily | Eligible | unknown | 79.21 | Search | 79 | 3095 | 0.0255 | 5.83 | 460.4 | 0.1341 | 0.4433 | 0.4226 | Maximize Conversions | 0.1139 | 9 | 51.16 | #N/A
Enabled | PPC_NB_Orthodontist | -- | USD | 20 | Daily | Eligible (Limited) | limited by budget; unknown | 63.03 | Search | 235 | 4880 | 0.0482 | 4.24 | 997.03 | < 10% | 0.8744 | 0.0511 | Target CPA | 0.3021 | 71 | 14.04 | #N/A
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | I'm trying to pull assisted values from another workbook. The amount of rows won't be the same as this sheet. Is that the issue?
Spreadsheet: 40180d1238508434-mass-editing-formulas-book1
Sheet: Sheet1

Points possible | 10
 |  | Average | Percentage
Maple | 5
Jasmine | 5
[NAME] | 10
[NAME] | 10
Carol/Karen | 10
Lily | 10
[NAME] | 10
Sabrine | 10
[NAME] | 10
Juice | 10
[NAME] | 10
Melody | 10
Michelle | 10
[NAME] | 10
[NAME] | 10
Anne | 10
Betty | 10
[NAME] | 10
Sailor | 10
Rhea | 10
[NAME] | 10
Kelly | 10
[NAME] | 10
Maria | 10
Elaine | 10
[NAME] | 10
Joleen | 10
Anna | 10
[NAME] | 10
Charity | 10
[NAME] | 10
[NAME] | 5
Angelica | 10
[NAME] | 10
[NAME] | 10
Candy | 10
Sunshine | 10
Emily | 10
[NAME] | 10
Emma | 10
Spreadsheet: 818675d1676994577-formula-for-reviewing-multiple-rows-and-pulling-cell-info-if-certain-criteria-is-met-table-example-etaf-v2
Sheet: Sheet1

Table |  |  |  |  |  |  |  | Desired results
Customer | PO | Ship from | Date | Qty sold | Account Name | Value |  | Customer | PO | Ship from | Date | Qty sold | Freight
JB&Stuff | 123456 | Dallas | 2023-01-01 00:00:00 | 18000 | Material | 9000 |  | JB&Stuff | 123456 | Dallas | 2023-01-01 00:00:00 | 18000 | 6000
JB&Stuff | 123456 | Dallas | 2023-01-01 00:00:00 | 6 | Pallet | 60 |  | JB&Stuff | 456789 | Dallas | 2023-02-02 00:00:00 | 14000 | 2000
JB&Stuff | 123456 | Dallas | 2023-01-01 00:00:00 | 1 | Freight | 6000
nonamesrus | 654321 | Chicago | 2023-01-01 00:00:00 | 40000 | Material | 20000
makerofstuff | 123123 | Fresno | 2023-01-08 00:00:00 | 25000 | Material | 10000 |  |  | 123456 | Dallas | 2023-01-01 00:00:00 | 18000
makerofstuff | 123123 | Fresno | 2023-01-08 00:00:00 | 1 | Freight 2 | 800 |  | JB&Stuff | 456789 | Dallas | 2023-02-02 00:00:00 | 14000
JB&Stuff | 456789 | Dallas | 2023-02-02 00:00:00 | 14000 | Material | 9000
JB&Stuff | 456789 | Dallas | 2023-02-02 00:00:00 | 4 | Pallet | 40
JB&Stuff | 456789 | Dallas | 2023-02-02 00:00:00 | 1 | Freight 2 | 2000
 |  |  |  |  | What I need: Sample attached. If column F contains any variation of the word "Freight" I need to populate column A, B, C, D, E if F = "Material" and E is less than 20,000, G for any variation of "Freight"
 |  |  |  | =SORT(UNIQUE(FILTER(FILTER(I23:M30,I23:I30<>""),{1,0,0,1,0})))
Spreadsheet: 0e0498ea-feac-4c91-8149-1d97f10ce706
Sheet: Sheet1

Table S3, [NAME] and cell capacity of esophageal luminal compartments (bulges) | Unnamed: 1 | Unnamed: 2 | Unnamed: 3 | Unnamed: 4
Dimensions of bulges (µm, mean +/- S.D.)
male | width | length | n
anterior | 16.33+/- 2.52 | 74.33+/- 5.03 | 3
posterior | 20.7+/-5.57 | 106.8+/-19.27 | 6
female | width | length
posterior | 13.13+/-3.45 | 54.68+/-3.37 | 6
Volume (mm^3) | short radius (mm) | long radius (mm)
male | a | b | * volume
anterior | 8.2x10^-3 | 37.0x10^-3 | 10.2x10^-6
posterior | 10.0x10^-3 | 53.0x10^-3 | 24.0x10^-6
female | a | b | * volume
posterior | 6.6x10^-3 | 27.5x10^-3 | 4.92x10^-6
Number of cells |  | Male |  | Female
 | 1mm^3 blood | anterior | posterior | posterior
erythrocytes | 5x10^6 | 52 | 125 | 25
platelets | 3x10^5 | 3 | 7 | 1.5
leucocytes | 7x10^3 | 0.07 | 0.17 | 0.034
* volume of a prolate spheroid = |  | 4/3pa^2b
Spreadsheet: 1c76e86d-fac6-4a68-9c21-70ef6818c4d8
Sheet: Sheet1

Troop Register | Unnamed: 1 | Unnamed: 2 | Unnamed: 3 | Unnamed: 4 | Unnamed: 5 | Unnamed: 6 | Unnamed: 7 | Unnamed: 8 | Unnamed: 9 | Unnamed: 10 | Unnamed: 11 | Unnamed: 12 | Unnamed: 13 | Unnamed: 14 | Unnamed: 15
1404 [NAME], Spokane, WA 99201
(509) 747-8091   ☼   (800) 827-9478
www .gsewni.org
 | Troop # |  | SU # |  |  | Membership Year: 20______
 |  | Income |  |  |  |  |  | Expenses
Date | Paid or Rec’d From | Troop Dues | Troop Sponsorship | Other Income/ Contributions | Cookie Sale Profits | Fall Product | Other Troop Money-Earning Projects | GSUSA Membership | Troop Program | Patches, [NAME], Insignia | Troop Camping | Service Projects | Extended Trips | Other | Explanation of other
 |  | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0
 |  | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  | Page 6
 |  |  | Membership 04/2011
Spreadsheet: mary_fischer__25725__20Q MTM Summary
Sheet: May

Enron Energy Services
MTM Summary
Company 20Q
 |  |  |  | Beginning |  |  |  | Ending
Date |  | Account MSA/SAP |  | Balance |  | Change |  | Balance
5/01 |  | 21060000 Asset-C |  | 1277047002 |  |  |  | 107381306
5/01 |  | 30300000 Liab-C |  | -1247510983 |  |  |  | -83390822
5/01 |  | 25100200 Prudency |  | 12033165 |  |  |  | 0
5/01 |  | 25100300 Prudency |  | 0 |  |  |  | -16022963
5/01 |  | 25100000 Asset-NC |  | 196011309 |  |  |  | 220121931
5/01 |  | 33100000 Liab-NC |  | -155003635 |  |  |  | -92408146
5/01 |  | 20032500 Liquidation |  | -8673064 |  |  |  | 0
 |  |  |  |  |  | Ending
Date |  | Account |  |  |  | Balance
5/01 |  | 42000000 MTM Rev |  |  |  | -61777512
 |  | Difference
Spreadsheet: 872037d1718383261-countifs-issue-sample
Sheet: Coaches

 |  |  |  | Access NI Check |  | IFA Disclosure |  | Child protection
Name | Squad | [NAME] | Phone | Complete | [NAME] | Complete | [NAME] | Complete | [NAME] | Comet | Qualification 1 | Qualification 2 | Qualification 3 | Qualification 4
Test Coach | U17 | [EMAIL] | 7841555555 | Y | 2024-07-30 00:00:00 | Y | 2024-07-30 00:00:00 | Y | 2024-07-30 00:00:00 | Y | NCC | UEFA C
Spreadsheet: 77313d1277817091-counting-down-h-mm-from-50-00-to-show-minus-hou-flightlog-2010-latest
Sheet: January 2011

 |  |  |  |  |  |  |  |  |  |  | 50 Hr Check |  | TT Engine Hrs | TT A/F Hrs | Prop Hours
Date | Flight No. | Captain | Passenger | Nature of flight | Brakes off | Take off | Landing | Brakes on | Flight time | Total time | 2 days, 2:00:00 |  | 4 days, 4:00:00 | 66 days, 16:00:00 | 104 days, 4:00:00