tianzl66/Sheetpedia huggingface dataset:
Spreadsheet: 833154d1686819288-power-query-how-to-get-prev-months-value-how-to-get-prev-months-value-example-spreadsheet-aligw
Sheet: Sheet1

Data Set |  |  |  | Fake Pivot Table with intended result |  |  |  | slicers non functional for demonstration
Date | Item | Stock |  | Row Labels | Sum of Stock | Stock Change |  |  |  |  |  |  |  |  | Date | Item | Stock | Stock Change |  |  |  |  | January
2023-01-01 00:00:00 | Box | 100 |  | Mar | 373 | 168 |  |  |  |  |  |  |  |  | 2023-03-01 00:00:00 | Bag | 137 | 11 |  |  |  |  | February
2023-01-01 00:00:00 | Bottle | 84 |  | Bag | 137 | 11 |  |  |  |  |  |  |  |  | 2023-03-01 00:00:00 | Barrel | 8 | 8 |  |  |  |  | March
2023-01-01 00:00:00 | Crate | 65 |  | Barrel | 8 | 8 |  |  |  |  |  |  |  |  | 2023-03-01 00:00:00 | Bottle | 22 | 22 |  |  |  |  | April
2023-01-01 00:00:00 | Barrel | 45 |  | Bottle | 22 | 22 |  |  |  |  |  |  |  |  | 2023-03-01 00:00:00 | Box | 152 | 86 |  |  |  |  | May
2023-01-01 00:00:00 | Bag | 67 |  | Box | 152 | 86 |  |  |  |  |  |  |  |  | 2023-03-01 00:00:00 | Crate | 54 | 41 |  |  |  |  | June
2023-02-01 00:00:00 | Box | 66 |  | Crate | 54 | 41 |  |  |  |  |  |  |  |  | Total |  |  |  |  |  |  |  | July
2023-02-01 00:00:00 | Bottle | 0 |  | Grand Total | 373 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | August
2023-02-01 00:00:00 | Crate | 13 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | September
2023-02-01 00:00:00 | Barrel | 0 |  |  |  |  |  |  |  |  |  |  |  |  | March | <<<< Select Month |  |  |  |  |  |  | October
2023-02-01 00:00:00 | Bag | 126 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | November
2023-03-01 00:00:00 | Box | 152 |  |  |  |  |  |  |  |  |  |  |  |  |  | Item | Stock | Stock Change |  |  |  |  | December
2023-03-01 00:00:00 | Bottle | 22 |  |  |  |  |  |  |  |  |  |  |  |  | 2023-03-01 00:00:00 | Box | 152 | 86
2023-03-01 00:00:00 | Crate | 54 |  |  |  |  |  |  |  |  |  |  |  |  | 2023-03-01 00:00:00 | Bottle | 22 | 22
2023-03-01 00:00:00 | Barrel | 8 |  |  |  |  |  |  |  |  |  |  |  |  | 2023-03-01 00:00:00 | Crate | 54 | 41
2023-03-01 00:00:00 | Bag | 137 |  |  |  |  |  |  |  |  |  |  |  |  | 2023-03-01 00:00:00 | Barrel | 8 | 8
2023-04-01 00:00:00 | Box | 100 |  |  |  |  |  |  |  |  |  |  |  |  | 2023-03-01 00:00:00 | Bag | 137 | 11
2023-04-01 00:00:00 | Bottle | 96 |  |  |  |  |  |  |  |  |  |  |  |  | Total |  | 373
2023-04-01 00:00:00 | Crate | 31
2023-04-01 00:00:00 | Barrel | 8
2023-04-01 00:00:00 | Bag | 218
2023-05-01 00:00:00 | Box | 147
2023-05-01 00:00:00 | Bottle | 4
2023-05-01 00:00:00 | Crate | 27
2023-05-01 00:00:00 | Barrel | 56
2023-05-01 00:00:00 | Bag | 222
Spreadsheet: 701929d1603989643-calculate-p-value-for-multiple-regression-stats-p-value
Sheet: Analyst

ANOVA: Single Factor |  |  |  |  |  |  |  |  |  |  |  | CONTRAST
 | [NAME] |  |  |  |  | Alpha | 0.05 |  |  |  |  |  |  |  | [NAME] (with [NAME] correction)
No. | Groups | Count | Sum | Mean | [NAME] | SS | [NAME] | Lower | Upper | SD |  | Groups | c | Mean | n | ss | c^2/n | c*mean
01
02
03
04
05
06
07
08
09
10
11
12
13
14
15
16
17
18
19
20
 | ANOVA |  |  |  |  |  |  |  |  |  |  | T TEST
 | Sources | SS | df | MS | F | P value | F crit | RMSSE | [NAME] |  |  | Standard Error | t-stat | df | P-value | t-crit | Lower | Upper | Significance | Cohen d | effect r
 | Between Groups
 | Within Groups
 | Total
 | Mean | Within Analyst |  | Between Analyst |  | Within Laboratory
 | S.D.
 | Mean
 | RSD
 | [NAME]
 | Within-Laboratory reproducibility
Spreadsheet: 870178d1716738827-how-to-use-additional-range-within-lambda-lambda_test
Sheet: Sheet1

 |  | inputs |  |  |  |  |  |  |  |  | desired output
 |  | condition strings |  | values |  | w/o the condition |  |  | ???
 |  | a | ab | aaa |  |  | works fine
 |  |  |  | bbb |  | 2 |  |  | 2 |  |  |  | 0 | False |  | 2 |  |  | 2 | bbb
 |  | b | bb | [NAME] |  | 3 |  |  | 1 |  |  |  | 3 | True |  | 1 |  |  | 3 | [NAME]
 |  |  | bc |  |  | 3 |  |  | 2 |  |  |  | 2 | True |  | 1 |  |  | 4
 |  |  |  | eee |  | 4 |  |  | 1 |  |  |  | 0 | False |  | 2 |  |  | 5 | eee
 |  | c | ca | ddd |  | 5 |  |  | 2 |  |  |  | 3 | True |  | 1 |  |  | 6 | ddd
 |  |  |  | [NAME] |  | 6 |  |  | 1 |  |  |  | 0 | False |  | 2 |  |  | 7 | [NAME]
 |  |  |  | ggg |  | 7 |  |  | 2 |  |  |  | 0 | False |  | 1 |  |  | 8 | ggg
Spreadsheet: daren_farmer__5710__HPLN0202
Sheet: Sheet1

HPLN0202.XLS |  | Fax # [PHONE]
TO:  DARREN FARMER / ENRON;  CARY METZ / ENRON;  [NAME] / HPL;  LIZ BELLAMY / ENRON
FROM:  MELISSA JONES - TXU ELECTRIC & GAS  (TU ELECTRIC)
SUBJECT:  TXU FUELS NOMINATION - February 02, 2001
 |  |  |  |  |  | **Friday
HPL AND ENRON NOMINATIONS: |  |  |  |  |  | 2001-02-02 00:00:00
 |  |  |  |  |  | Eff. 0900 hrs.
 |  |  |  |  | PRIOR | NOMINATED
CONTRACT |  | DELIVERY POINT |  | Upstream
 |  | Firm Summary
 |  | Enron North America Spot/3959
OTHER ENRON/HPL TRANSPORTS: |  |  |  | Downstream
 |  | Total Other Transports:
NOTE:  Additional swing volumes may be requested at Teco Tap, or Texoma by TUFCO Gas Control under either the
Wagner Brown K# 1901 or HPL K# 3949 agreements.
*  Nominations to continue until TU Electric changes such nominations.
CC:   [NAME] | [NAME]
R. Skerik | [NAME]
G. Green | K. English
B. Fleming | GCC Dispatcher
Spreadsheet: 890f7dfb-bf21-4005-990f-675c256e45c8
Sheet: Sheet1

3314 GÖDÖLLŐ HELY|4E vonal   Autóbusz-állomás–Klapka u.–Királytelep–Autóbusz-állomás | Unnamed: 1 | Unnamed: 2 | Unnamed: 3 | Unnamed: 4 | Unnamed: 5 | Unnamed: 6
(Érvényes: 2011. december 11-től)
Km | Km | Km | Km | VOLÁNBUSZ Zrt. | 2 | 4
 |  |  |  |  | I | I
0 | 0 | .. | .. | Gödöllő, aut. áll.
0.9 | 0.9 | .. | .. | Gödöllő, [NAME]. út
1.7 | 1.7 | .. | .. | Gödöllő, Tisza u.
2.2 | 2.2 | .. | .. | Gödöllő, [NAME]
2.9 | S | .. | .. | Gödöllő, (M.besnyő) óvoda
3.4 | S | .. | .. | Gödöllő, (M.besnyő) mh. [NAME]. út
3.9 | S | .. | .. | Máriabesnyő, templom
4.4 | S | .. | .. | Gödöllő, (M.besnyő) mh. [NAME]. út
4.9 | S | 0 | .. | Gödöllő, (M.besnyő) óvoda
S | 3 | 0.1 | 0 | Gödöllő, Klapka u. elág.
S | S | 0.6 | 0.5 | Gödöllő, Tél u.
S | S | 0.9 | 0.8 | Gödöllő, Fenyves közért
S | S | 1.1 | 1 | Gödöllő, [NAME]
S | S | 1.5 | 1.4 | Gödöllő, Klapka u. aut. ford.
S | S | 1.5 | 1.4 | Gödöllő, Klapka u. aut. ford. | 13:30:00 | 16:30:00
S | S | 1.1 | 1 | Gödöllő, [NAME] | 13:31:00 | 16:31:00
S | S | 0.9 | 0.8 | Gödöllő, Fenyves közért | 13:32:00 | 16:32:00
S | S | 0.6 | 0.5 | Gödöllő, Tél u. | 13:33:00 | 16:33:00
S | 3 | 0.1 | 0 | Gödöllő, Klapka u. elág. | 13:34:00 | 16:34:00
5.6 | 3.8 | .. | .. | Gödöllő, [NAME] isk. | 13:36:00 | 16:36:00
6.1 | 4.3 | .. | 0 | Gödöllő, Iskola u. | 13:38:00 | 16:38:00
S | S | .. | 0.3 | Gödöllő, Királytelep aut. ford. | 13:39:00 | 16:39:00
S | S | .. | 0.3 | Gödöllő, Királytelep aut. ford. | 13:40:00 | 16:40:00
6.1 | 4.3 | .. | 0.6 | Gödöllő, Iskola u. | 13:42:00 | 16:42:00
6.5 | 4.7 | .. | .. | Gödöllő, Szarvas u. | 13:43:00 | 16:43:00
6.8 | 5 | .. | .. | Gödöllő, [NAME] | 13:44:00 | 16:44:00
7.2 | 5.4 | .. | .. | Gödöllő, [NAME] u. | 13:45:00 | 16:45:00
7.7 | 5.9 | .. | .. | Gödöllő, [NAME]. | 13:47:00 | 16:47:00
8.1 | 6.3 | .. | .. | Gödöllő, [NAME] 24. | 13:48:00 | 16:48:00
8.5 | 6.7 | .. | .. | Gödöllő, Szölö u. 47. | 13:49:00 | 16:49:00
9 | 7.2 | .. | .. | Gödöllő, Szilhát u. 3. | 13:51:00 | 16:51:00
9.7 | 7.9 | .. | .. | Gödöllő, szökőkút | 13:54:00 | 16:54:00
10.4 | 8.6 | .. | .. | Gödöllő, aut. áll. | 13:56:00 | 16:56:00
[NAME]:
I | tanítási napokon
S | a járat nem érinti a megállóhelyet, [NAME]
Spreadsheet: rick_buy__32703__100901CashFlow
Sheet: Liquidity Forecast NPW

NewPower
Cash Flow Forecast
October 8, 2001 (NewPower)
 |  |  |  |  |  |  |  |  | Total |  |  |  |  |  | Total |  |  |  |  | Total | Total
($ in Millions) | Actual | Forecast | Total | Forecast | Forecast | Forecast | Forecast | Forecast | October | Forecast | Forecast | Forecast | Forecast | Forecast | November | Forecast | Forecast | Forecast | Forecast | December | Fourth Quarter
 | 9/17-9/21 | 9/24-9/28 | 9/17-9/28 | 10/1-10/5 | 10/8-10/12 | 10/15-10/19 | 10/22-10/26 | 10/29-10/31 | Forecast | 11/1-11/2 | 11/5-11/9 | 11/12-11/16 | 11/19-11/23 | 11/26-11/30 | Forecast | 12/3-12/7 | 12/10-12/14 | 12/17-12/21 | 12/24-12/28 | Forecast | Forecast
Payments
Commodity | 20.5 | 25
IBM | 4 | 0
IBM Escrow | 0.5 | 0
AGL (T&D) | 0 | 3.1
Construction | 0
Collateral | 0 | 0
T&E | 0 | 0
State Tax Payments | 0 | 0.5
Coral | 0 | 0
Payroll | 0 | 1.3
Deferred Comp | 0 | 1.4 |  | 0 | 0 | 0 | 0 | 0 |  | 0 |  |  |  |  |  |  | 0
A/P Checks clearing | 3.45 | 1.9
Total Payments
9/14/01 Liquidity Balance | 59.25
Receipts
Customer Collections | 8.4 |  |  |  |  |  |  |  | 25
Return of Collateral | 10 | 10.2 |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 40
Interest (Enron/CSAM) |  |  |  |  |  |  |  |  |  | 0.25 |  |  |  |  |  | 0.25
Forecasted Period End Liquidity
Prior Report Period End Liquidity | 0 | 0 | 26.9 | 21.1 | 23.8 | 8.1 | -8.9 | -7.7 | -7.7
[NAME])     (1)
(1) September month end liquidity higher than expected primarily due to delay of Coral payment ($4MM) initially anticipated in September
(2)  Overall negative variance due to revised commodity outflows for October.
Prior Forecast 10/5 |  |  | 32 |  |  |  |  |  | -0.6 |  |  |  |  |  | -20.3 |  |  |  |  |  | 25.2
Better/(worse) |  |  | 0 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | (A)
Changes since 10/3:
Eliminate Def. Comp contribution 11/1 & 12/10 |  |  | 12
AES revenues collections in Oct. |  |  | 2
Peco Escrow Interest 10/5 |  |  | 0.5
Exelon paymnt 10/22 |  |  | -1
NJN Surety Bond Collateral 10/24 |  |  | -0.6
Reduce revenue collections (AGL 45 days) Dec. |  |  | -4
Changes since 10/5:
PJM increased for uplift and congestion |  |  | -3.4
TCO previously excluded |  |  | -1.35
 |  |  |  | (A)
Changes since 10/8 (AM):
Mktg & Ops Saves |  |  | 9
Includes Transport & Storage (Oct) |  |  | -2.8
Includes Transport & Storage (Nov) |  |  | -6.9
Adjustment to original physical (Nov) |  |  | 0.7
Additional Physical (Nov) |  |  | -11.1
 |  |  |  | (A)
* Timing Difference due to delaying 10/24 AGL payment ($3.1MM) catch up 12/24
Note: IBM payments have been delayed by one week, disputed amounts to 1st business day of following month
Spreadsheet: 492394d1481064966-true-false-error-true-false
Sheet: As Found

 |  |  |  |  |  |  |  |  |  | 2800 [NAME], Unit 12  [NAME] L3R 0E2 [NAME]: [PHONE]                 Fax: [PHONE]  E-mail: [EMAIL]   www.calflow.com |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | Form: #045
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | Revision: 0 - 020416
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | Page: | 2 | of |  | 3
Calibration Certificate |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | ±% of F.S.
As Found Calibration
Standards Used
Standard I.D. |  |  |  |  |  |  |  |  | Serial No. |  |  |  |  |  |  |  |  | Trace No. |  |  |  |  |  |  |  | Due Date  (dd-mm-yyyy)
SCALE #1 |  |  |  |  |  |  |  |  | 95-223618 |  |  |  |  |  |  |  |  | 12403 |  |  |  |  |  |  |  | 2019-02-15 00:00:00
Calibration Conditions
Operating Conditions |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | Calibration Conditions
Process Fluid: |  |  |  |  |  |  |  |  |  | Water |  |  |  |  |  |  |  | Calibration Fluid: |  |  |  |  |  |  |  |  | Water
Min Rate: |  |  |  |  |  |  |  |  |  | 0.2 |  |  |  |  |  |  |  | Density: |  |  |  |  |  |  |  |  | 0.9997 |  |  |  |  | cm/3
[NAME]: |  |  |  |  |  |  |  |  |  | 30 |  |  |  |  |  |  | (USGP/M) | Fluid Temperature: |  |  |  |  |  |  |  |  | 18.7 |  |  |  |  | °C
Temperature: |  |  |  |  |  |  |  |  |  | NA |  |  |  | °C |  |  |  | Ambient Temperature: |  |  |  |  |  |  |  |  | 23 |  |  |  |  | °C
Pressure: |  |  |  |  |  |  |  |  |  | NA |  |  |  | PSIG |  |  |  | Pressure |  |  |  |  |  |  |  |  | NA |  |  |  |  | PSIG
Customer Reference No.: |  |  |  |  |  |  |  |  |  | LSAT 325
[NAME]: |  |  |  | 0.50 | % of reading |  |  |  |  |  |  |  |  |  |  |  |  | Position: |  |  |  |  |  |  |  |  | Horizontal
Results
The results of this ‘as found’ calibration pertain only to the item(s) indicated on page 1 of this certificate.
Point |  |  | Flow Rate |  |  |  |  |  | Test Standard |  |  |  |  |  | Device Under Test |  |  |  |  |  |  |  |  |  | Calculated Err. |  | Acceptable [NAME]. |  |  |  |  |  |  |  | True/false
 |  |  | (LPM) |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | Pulse Out |  |  |  |  | % of Reading
 |  |  | 1 |  |  |  |  |  | 7.015 |  |  |  |  |  | 7.08 |  |  |  |  | 0.98
Interpretation & Recommendations
Calibration conducted by: |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | Reviewed and approved by:
(Technician) |  |  |  |  | [NAME] |  |  |  |  |  |  |  |  |  |  |  |  |  | (Lab Manager) |  |  |  |  |  | [NAME]
Spreadsheet: 296870d1392218431-range-lookup-range-lookup
Sheet: Range Lookup Formula

 | Range Lookup Excel
 | Lookup Value | 100
 | [NAME] in | Row no. 3
 | Start | End | Value
 | 0 | 94.99 | 0
 | 95 | 99.99 | 25
 | 100 | 104.99 | 50
 | 105 | 109.99 | 75
 | 110 | 999 | 100
Spreadsheet: 885835d1735700518-formula-working-inconsistently-formula-not-working-on-all-instances
Sheet: Sheet1

Reporter | Date of Article | Was the article accurate? | Merger confirmed
[NAME] | 2024-02-23 00:00:00 | Yes | 2024-03-30 00:00:00
Ian | 2024-06-13 00:00:00 | No
Ian | 2024-05-28 00:00:00 | No
[NAME] | 2024-03-01 00:00:00 | Yes | 2024-06-18 00:00:00
[NAME] | 2024-02-09 00:00:00 | No
Ian | 2024-05-17 00:00:00 | No
Ian | 2024-05-07 00:00:00 | Yes | 2024-05-25 00:00:00
[NAME]
Ian
S/be:
Spreadsheet: 1470eacc-9603-4977-862f-f500431d9730
Sheet: 2015-2016

2015-2016 Class Schedule |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | You may select up to three classroom attributes.  Select only course requirements, as the number of available classrooms will be reduced with each attribute selected.
HSB- Undergraduate
Spring 2016
Subject | Course and Title | Subtitle/Alternate Title | Days | Times | Sec | Part of Term | Credits | Hamline Plan | Instructor(s) | Instructor ID | FT or Adj | [NAME] | Registration Approval Required? | [NAME] | Seats to be Saved | Saved Seats Type | Campus: [NAME], [NAME], Online, Blended |  |  |  | Cross list? SUBJ CRSE SEC | XLST total enrl | Areas of Study | Comments
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | Classroom Attribute A | Classroom Attribute B | Classroom Attribute C
Spreadsheet: phillip_m_love__31286__011010BOOKREQUEST - ED GD
Sheet: Sheet1

From: | Risk Management -Controls
 |  |  |  |  |  |  |  |  |  |  |  |  |  | Department: |  | Risk Management
Subject: | New Book Request
 |  |  |  |  |  |  |  |  |  |  |  |  |  | Date:
 | COUNTERPARTY |  | BOOK PURPOSE |  |  | TAGG |  |  |  |  |  |  |  |  |  | IT SECURITY | Reporting -Subledger
 |  |  | Internal | External | Both | Book Mapping |  |  |  |  |  |  |  |  |  | Book
 | Short Name | [NAME] | Transactions | Transactions | Transactions | Code | Region | P | B | Idx | [NAME] | PHY | Commodity/UOM/Curr | [NAME] | Reason for Book | Administrator* | MTM | Prud | Realized
 | CAND-ED | Enron Direct Gas Daily Book |  |  | X |  | Spreadsheet |  |  |  | X | X | NG/MMBTU/USD | [NAME] | To load [NAME] deals for Enron Direct into RisktRAC | See Below
 | FIN-ECTI-ENERGY | Financial ECTI-Energy |  |  |  | I7 | EQUITIES | X | - | - | - |  | TN10/CNTR/USD
 | FIN-ECTI-PROP | Financial ECTI-Prop |  |  |  | I8 | EQUITIES | X | - | - | - |  | TN10/CNTR/USD
 | FIN-ECTI-ST | Financial ECTI-ST |  |  |  | I3 | EQUITIES | X | - | - | - |  | TN10/CNTR/USD
 | FINLAND-JV-.2GO | Finland JV GASOIL.2 |  |  |  | QM | DESK | X | - | - | - |  | TN10/CNTR/USD
 | UK-FO-LSSR | UK -Fuel Oil-LSSR |  |  |  | V# | DESK | X | - | - | - |  | TN10/CNTR/USD
 | (Note 1) Please ensure access to both production and stage to enter deals, calculate books and set the official flag
 | Please provide a list of the people who need access to the above book(s).
 | ***'Please provide login names for book administrators.***
 | [NAME]
 | [NAME]
 | [NAME]
 | [NAME]
 | [NAME]
 | [NAME]
 | Brent Price
 | Access List:
 | bgillis
 | kreeves
 | cunger
 | mrenneb
 | aluc
 | [NAME]
 | [NAME]
 | [NAME]
 | [NAME]
 | Any questions, please contact me
 | (x31462)
Spreadsheet: 129603d1321729704-sensitivity-and-solution-space-solver77-nyc
Sheet: Sheet1

 |  |  |  | Chess Tournament
 | Number of players | Entering at a cost | training cost per hour | Hrs of training | Maximisise chess rating
Chess beginner players | 7.999999999999996 | 25 | 25 | 3 | 40
chess  mediocre players | 3.999999999999999 | 30 | 15 | 1.5 | 70
highly advanced chess players | 8.000000000000004 | 35 | 10 | 0.5 | 100
Total
Require | 20 | 600 | 1200 | 50 | 1000
Spreadsheet: 172074d1343979104-percentile-formula-help-scoring
Sheet: Sheet1

CATEGORY 1 |  | CATEGORY 2 |  | CATEGORY 3 |  | CATEGORY 4
Score | 0.25 | Score | 0.25 | Score | 0.25 | Score | 0.25 |  | Total
50 |  | 100 |  | 56 |  | 59
Spreadsheet: 713484d1610732596-formula-to-return-multiple-matches-from-a-reference-list-excel_help-1-
Sheet: Sheet1

groups_listed
Group A; Group M; Group T; Group B
Group J; Group S; Group C; Group T
Group M; Group Q
Group C; Group J; Group Q
Group F; Group A
Group B; Group C; Group D
Group W; Group Z
Group T
Group O; Group Y
Spreadsheet: 709503d1608353891-dynamic-named-range-and-drop-down-list-names
Sheet: Sheet1

 |  |  | Inputs |  |  |  |  |  | Dynamic Named Range and drop down list
 |  |  |  |  |  |  |  |  |  |  |  |  |  | Required Outcome
 |  |  | Names |  | Category |  | Concatenated List |  | (not in Category Order here)
 |  |  | [NAME] | Hsiu | 1
 |  |  | Moroz | Kathrine | 2
 |  |  | Leinen | [NAME] | 3 |  |  |  | ‘=OFFSET(Names!$H$7,0,0,COUNTA(Names!$H7:$H41),1)
 |  |  | Bernett | Roland | 5
 |  |  | Willsey | [NAME] | 6
 |  |  | Boden | Magdalena | 4
 |  |  | Demaris | [NAME] | 4
 |  |  | [NAME] | Morgan | 4
 |  |  | Leitner | Refugio | 2
 |  |  | Desir | Francisca | 2
 |  |  | Callery | [NAME] | 3
 |  |  | Reames | Theodore | 1
 |  |  | [NAME] | Santana | 6
 |  |  | Marshburn | [NAME] | 6
 |  |  | Horning | [NAME] | 3
 |  |  | Worthen | [NAME] | 4
 |  |  | Mccleskey | [NAME] | 4
 |  |  | [NAME] | Tamesha | 3
 |  |  | [NAME] | Kasey | 3
 |  |  | Helfrich | [NAME] | 3
 |  |  | Remmers | Titus | 5
 |  |  | Beahm | Shaniqua | 5
 |  |  | Underdahl | Love | 4
 |  |  | Anders | Hyun | 3
 |  |  | Hellmann | Ray | 2
 |  |  | [NAME] | Jermaine | 6
 |  |  | Cacciatore | Saul | 6
 |  |  | Lubbers | [NAME] | 3
 |  |  | Paneto | Nubia | 4
 |  |  | Labarge | Cheree | 2
Spreadsheet: 809491d1671116147-ranking-formular-rank333
Sheet: WASICHANA 5 BORA NA 5 DUNI

MTIHANI WA MUHULA WA KWANZA DARSA LA III NOVEMBA, 2022
G. WASICHANA 5 BORA
NA | JINA | JINSI 1=MV 2=MS | SHULE | KATA | MASOMO |  |  |  |  |  |  |  |  |  |  |  | JUMLA | WASTANI | DARAJA
 |  |  |  |  | KISW |  | ENGL |  | HIS |  | SAY |  | M/JAM |  | URA
 |  |  |  |  | A | D | A | D | A | D | A | D | A | D | A | D
1
2
3
4
5
G. WASICHANA 5 DUNI
NA | JINA | JINSI 1=MV 2=MS | SHULE | KATA | MASOMO |  |  |  |  |  |  |  |  |  |  |  | JUMLA | WASTANI | DARAJA
 |  |  |  |  | KISW |  | ENGL |  | HIS |  | SAY |  | M/JAM |  | URA
 |  |  |  |  | A | D | A | D | A | D | A | D | A | D | A | D
1
2
3
4
5
Spreadsheet: 294781d1391512162-migrate-row-when-adding-one-word-book2-1-
Sheet: BREAD PRODUCTS

 | Bread products | Measure | Cost Price
 | Chapati | Each | 0.05
 | [NAME] | Each | 0.08
 | Hot Dog Rolls | Each | 0.13
 | Seeded Burger Bun | Each | 0.09
 | White baguette | Each | 0.12
 | [NAME] | [NAME] | 0.2
Spreadsheet: darrell_schoolcraft__7882__SUNFLOWER - NNG1
Sheet: OCT

NORTHERN NATURAL GAS NOMINATION FORM
FOR SUNFLOWER ELECTRIC (S4 & S5)
ON BEHALF OF WEST PLAINS ENERGY
FOR MONTH OF: |  |  | OCTOBER
TO: | [NAME] |  | [PHONE] |  |  |  |  |  |  |  |  |  |  |  |  | FROM: | [NAME]
 | [NAME] |  | [PHONE] |  |  |  |  |  |  |  |  |  |  |  |  |  | [PHONE]
 | [NAME] |  | [PHONE] |  |  |  |  |  |  |  |  |  |  |  |  | FAX: | [PHONE]
 | [NAME] |  | [PHONE]
FAX: | [PHONE]
 |  |  |  |  |  | TOTAL |  |  |  |  | TOTAL |  |  |  |  | TOTAL
 | VOLUME |  |  |  |  | VOLUME |  |  |  |  | VOLUME |  |  |  |  | VOLUME
GAS | 1ST |  |  | CON | GAS | 2ND |  |  | CON | GAS | 3RD |  |  | CON | GAS | 4TH |  |  | CON | GAS
DAY | NOM | DATE | TIME | FIRM | PRICE | NOM | DATE | TIME | FIRM | PRICE | NOM | DATE | TIME | FIRM | PRICE | NOM | DATE | TIME | FIRM | PRICE
1 | 162 | 2001-09-28 00:00:00 | 08:13:00
2 | 162 | 2001-10-01 00:00:00 | 07:58:00
3 | 162 | 2001-10-02 00:00:00 | 07:58:00
4 | 162 | 2001-10-03 00:00:00 | 07:51:00
5 | 162 | 2001-10-04 00:00:00 | 07:50:00
6 | 162 | 2001-10-05 00:00:00 | 07:52:00
7 | 162 | 2001-10-05 00:00:00 | 07:52:00
8 | 162 | 2001-10-05 00:00:00 | 07:52:00
9 | 162 | 2001-10-08 00:00:00 | 07:51:00
10 | 162 | 2001-10-09 00:00:00 | 07:45:00
11 | 162 | 2001-10-10 00:00:00 | 07:53:00
12 | 162 | 2001-10-11 00:00:00 | 08:19:00
13 | 162 | 2001-10-12 00:00:00 | 07:52:00
14 | 162 | 2001-10-12 00:00:00 | 07:52:00
15 | 162 | 2001-10-12 00:00:00 | 07:52:00
16 | 162 | 2001-10-15 00:00:00 | 07:54:00
17 | 162 | 2001-10-16 00:00:00 | 07:48:00
18 | 162 | 2001-10-17 00:00:00 | 07:48:00
19 | 162 | 2001-10-18 00:00:00 | 07:50:00
20 | 162 | 2001-10-19 00:00:00 | 07:00:00
21 | 162 | 2001-10-19 00:00:00 | 07:00:00
22 | 162 | 2001-10-19 00:00:00 | 07:00:00
23 | 162 | 2001-10-22 00:00:00 | 07:08:00
24
25
26
27
28
29
30
31