tianzl66/Sheetpedia huggingface dataset:
Spreadsheet: 0613a1cd-355f-40b1-b92d-22a4d8b18821
Sheet: Sheet1

Below is a list of certified and approved Minority and Women Owned Business Entreprises (MWBEs) that are registered with Metro under classification 8613 - Specialized Educational Services.  If you are aware of other MWBEs certified by the TN Minority Supplier Development Council, the Women Business Enterprise National Council (WBENC), the National Women Business Owners Corportation (NWBOC), Governor's Office of Diversity Business Enterprise, through the Small Business Administration 8a program, or having a Federal Disadvantaged Business Enterprise (DBE) Certification granted under the regulations governing the USDOT who are not on this list, you may still pursue partnership with them, however, their status as an MWBE must be approved prior to the opening of your response to Metro.  If you have any questions regarding the certifying entities recognized by Metro, please contact the BAO at [PHONE]. | Unnamed: 1 | Unnamed: 2 | Unnamed: 3 | Unnamed: 4 | Unnamed: 5 | Unnamed: 6 | Unnamed: 7 | Unnamed: 8 | Unnamed: 9 | Unnamed: 10 | Unnamed: 11
Please note that Metro provides this list as a service to offerors who desire assistance in locating potential MWBE subcontractors and suppliers, however, proposers are responsible for making contact with any vendors that are being considered for subcontract opportunities to ascertain said vendor's experience, capabilities, or capacity to perform.
ID | [NAME] | Contact First Name | Contact Last Name | Address Line 1 | Address Line 2 | City | State | Zip | Phone # | Fax # | Contact E-mail
31647 | [NAME] Consultant | [NAME] | [NAME] | 1521 Naples Avenue | 1521 Naples Avenue Nashville | Nashville | Tennessee | 37207 | (615)868-4060 | (615)868-4060 | [EMAIL]
27148 | Health e-Strategies | [NAME] | [NAME] | 717 Old Lebanon Dirt Rd |  | Hermitage | Tennessee | 37076 | (615) 972-4266 |  | [EMAIL]
23543 | Higher [NAME], Inc. | Clint | [NAME] | [NAME] 86 |  | Hendersonville | Tennessee | 37077 | [PHONE] | [PHONE] | [EMAIL]
34022 | Innertainment Delivery Systems | Phylanice A. | [NAME] | 115 Penn Warren Drive | Suite 300 # 213 | Brentwood | Tennessee | 37027 | [PHONE] | [PHONE] | [EMAIL]
20535 | MasterStaff, Inc. | [NAME] | Sheets | 611 Potomac Place Suite 103 |  | Smyrna | Tennessee | 37167 | [PHONE] | [PHONE] | [EMAIL]
28935 | MCH Corporation | [NAME] | [NAME] | 118 W Morris Street | Second Floor | Sweetwater | Tennessee | 37874 | [PHONE] | [PHONE] | [EMAIL]
34492 | [NAME] of Florida, LLC | [NAME] | [NAME] | 22710 Fairview Center Dr. |  | Fairview Park | Ohio | 44126 | [PHONE] | [PHONE] | [EMAIL]
29828 | Phase One Consultants | [NAME] | Bakari | 2522 Alameda Street |  | Nashville | Tennessee | 37208 | [PHONE] | [PHONE] | [EMAIL]
36286 | Scarab Behavioral Health Services, LLC | [NAME] | Urbanczyk | 3203 Brick Church Pike |  | Nashville | Tennessee | 37207 | [PHONE] | [PHONE] | [EMAIL]
30923 | [NAME] | Roxann | Shick | PO Box 6268 |  | Gulf Shores | Alabama | 36547 | (770)335-3117 |  | [EMAIL]
31605 | TA Staffing | [NAME] | Bates | 1100 Kermit Dr. |  | Nashville | Tennessee | 37217 | [PHONE] | [PHONE] | [EMAIL]
Spreadsheet: 150872d1334705096-excel-2007-index-match-or-multi-vlookup-multilookup
Sheet: Report

 | Desired Result |  | TableOfVals Sheet Coordinates
ID | Most Recent Non-Zero Value |  | Row | Column
123456 | 4 |  | 3 | 15
123456 | 2 |  | 12 | 18
123456 | 1 |  | 15 | 18
123457 | 1 |  | 4 | 18
123458 | 2 |  | 5 | 18
Goal:
Using ID from the A column above, lookup value in largest column number which doesn't contain a 0
Problem:
When dragging down the rows, index, match or vlookup will stop after first match.
Spreadsheet: 717820d1612867212-cell-reference-fails-because-pasted-data-is-variable-length-test
Sheet: Sheet1

 |  |  | [NAME]
4. Making [NAME] (7)
W: 57.0kgF: 0x22
J: [NAME] BenbowT: [NAME] Diplock
12.0015.0014.00
15
3.2
EW
Runner Comments
3yo [NAME]
Sire:Headwater (AUS)
Dam:Sequinella (AUS)
[NAME]:[NAME]
[NAME]:[NAME] Diplock
Location:Pakenham
Last 60x22
Career3: 0-2-0
Win %-
Place %66.67%
Track0: 0-0-0
Distance1: 0-0-0
Trk/Dist0: 0-0-0
Prize Money$10,920.00
1st Up2: 0-1-0
2nd Up1: 0-1-0
3rd Up0: 0 0 0
4th Up0: 0 0 0
Firm0: 0-0-0
Good2: 0-2-0
Soft0: 0-0-0
Heavy0: 0-0-0
Synthetic1: 0 0 0
SB Rating85
Expected Settling PositionOff Pace
Recent Starts
2nd/8
44219
YARRA GLEN
1009m
Good
Margin:2.5L
Jockey:J Benbow
Weight:56kg
Barrier:1
SP:$13.00
Class:Mdn
Time:00.59
Last 600m:0:35.60
1st:The Billionaire (58kg)
2nd:Making [NAME] (56kg)
2nd/9
44209
YARRA GLEN
1009m
Good
Margin:1.8L
Jockey:J Benbow
Weight:56.5kg
Barrier:7
SP:$51.00
Class:Mdn
Time:00.59.44
Last 600m:0:34.75
1st:Quality [NAME] (58kg)
2nd:Making [NAME] (56.5kg)
10th/11
44071
PAKENHAM SYNTHETIC
1100m
Synthetic
Margin:13.5L
Jockey:J Benbow
Weight:56kg
[NAME]
SP:$51.00
Class:Mdn
Time:01.05.00
Last 600m:0:34.72
1st:[NAME] (58kg)
2nd:[NAME] (58kg)
1st:Bargain (56.5kg)
2nd:True Faith (57kg)
SP:$26.00
Class:Mdn
Time:00.59.98
Last 600m:0:33.76
1st:[NAME] (57kg)
2nd:Royal Expectations (57.5kg)
Spreadsheet: 79873d1280135540-how-to-count-with-2-status-combined-test
Sheet: Sheet1

Serial number | Item Type | Status
1 | Apple | Used1
1 | Apple | Used2
1 | Apple | Used3
2 | Apple | NIL
8 | Apple | NIL
2 | Apple | Used Twice
3 | Apple | Used Once
4 | Apple | Used [NAME]
5 | Orange | NIL
6 | Orange | Used
6 | Orange | NIL
7 | Orange | Used
9 | Orange | Used
 |  | Correct number | Remark
Total fruits available: | 9 | 9 | Counted by Serial Number
Total different Fruits Used: | 2 | 2 | Orange and Apple
Total Apples Available: | 5 | 5 | Counted by Apple's serial number
Total Oranges Available: | 4 | 4 | Counted by Orange's serial number
Total Apples Used: | 3.5 | 4 | Counted by Apple's serial number AND [NAME] not equal to "NIL"
Total Orange Used: | 2.5 | 3 | Counted by Orange's serial number AND [NAME] not equal to "NIL"
Spreadsheet: 220806d1363270302-vlook-up-doesnt-give-correct-result-excelsheet-a
Sheet: 2009

Colonne1 | Colonne2 | Colonne4 | Colonne5 | Colonne6 | Colonne7
 |  |  |  | AV | RI
 | 1 | 1130007919 |  | 10-026835-03
 | 2 | 1130007978 |  | 09-15027-01
 | 3 | 1130014194 |  | 09-16351-01
 | 4 | 1130015272 |  | 09-011682-01
 | 5
 |  | 1130015272 |  | 09-011682-01
 |  | 1130015272 |  | 09-011682-01
 |  | 1130015272 |  | 09-011682-01
 |  | 1130015504 |  | 09-013978-02
 |  | 1130015664 |  | 09-015376-01
 |  | 1130015664 |  | 09-015376-01
 |  | 1130015664 |  | 09-015376-01
 |  | 1130015664 |  | 09-015376-01
 |  | 1130015664 |  | 09-015376-01
 |  | 1130015664 |  | 09-015376-01
 |  | 1130015664 |  | 09-015376-01
 |  | 1130015625 |  |  | 09-015029-01
 |  | 1130015625 |  |  | 09-015029-01
 |  | 1130015627 |  | 09-15027-01
 |  | 1130015629 |  |  | 09-015027-01
 |  | 1130015631 |  |  | 09-015027-01
 |  | 1130015633 |  | 09-015029-01
 |  | 1130015635 |  |  | 09-015027-01
 |  | 1130015637 |  |  | 09-015027-01
 |  | 1130015639 |  |  | 09-015027-01
 |  | 1130015641 |  | 09-15027-01
 |  | 1130015272 |  | 09-011682-01
 |  | 1130015623 |  |  | 09-15025-01
 |  | 1130014192 |  | 09-16352-01
 |  | 1130015625 |  | 09-015029-01
 |  | 1130015627 |  | 09-15027-01
 |  | 1130015627 |  | 09-15027-01
 |  | 1130015627 |  | 09-015027-01
 |  | 1130015627 |  | 09-15027-01
 |  | 1130014267 |  |  | 09-017918-02
 |  | 1130015627 |  | 09-15027-01
Spreadsheet: 875158d1721733205-display-name-not-code-from-a-cell-into-another-cell-room-inventory-template-new
Sheet: 64 Tables

 | Inventory Count: |  |  |  |  |  |  | TABLE COUNT DATA
 | As of: |  |  | Cultivar | # of Tables |  |  | Table | BPR # | Initial # Plants Plugged | Kill | Current room Count | Harvested Amount | Harvest Date | Density | BPR Variation | Pinched
 |  |  |  |  |  |  |  | 1
 | Plug Date: |  |  |  |  |  |  | 2
 | Cycle: |  |  |  |  |  |  | 3
 | Room: |  |  |  |  |  |  | 4
 | Status: | Flower |  |  |  |  |  | 5
 | Estimated Harvest Date |  |  |  |  |  |  | 6
 |  |  |  |  |  |  |  | 7
 | Room Total Counts |  |  |  |  |  |  | 8
 | Cultivar | Biotrack Count | Room Count | [NAME] | Initial # Plugged | % Remaining |  | 9
 |  |  |  |  |  |  |  | 10
 |  |  |  |  |  |  |  | 11
 |  |  |  |  |  |  |  | 12
 |  |  |  |  |  |  |  | 13
 |  |  |  |  |  |  |  | 14
 |  |  |  |  |  |  |  | 15
 | Total |  |  |  |  |  |  | 16
 |  |  |  |  |  |  |  | 17
 | Room Activity |  |  |  |  |  |  | 18
 | Date | Table | BPR # | Activity | Quantity |  |  | 19
 |  |  |  |  |  |  |  | 20
 |  |  |  |  |  |  |  | 21
 |  |  |  |  |  |  |  | 22
 |  |  |  |  |  |  |  | 23
 |  |  |  |  |  |  |  | 24
 |  |  |  |  |  |  |  | 25
 |  |  |  |  |  |  |  | 26
 |  |  |  |  |  |  |  | 27
 |  |  |  |  |  |  |  | 28
 |  |  |  |  |  |  |  | 29
 |  |  |  |  |  |  |  | 30
 |  |  |  |  |  |  | Rm4 - Short Tables | 31
 |  |  |  |  |  |  | Rm4 - Short Tables | 32
 |  |  |  |  |  |  |  | 33
 |  |  |  |  |  |  |  | 34
 |  |  |  |  |  |  |  | 35
 |  |  |  |  |  |  |  | 36
 |  |  |  |  |  |  |  | 37
 |  |  |  |  |  |  |  | 38
 |  |  |  |  |  |  |  | 39
 |  |  |  |  |  |  |  | 40
 |  |  |  |  |  |  |  | 41
 |  |  |  |  |  |  |  | 42
 |  |  |  |  |  |  |  | 43
 |  |  |  |  |  |  |  | 44
 |  |  |  |  |  |  |  | 45
 |  |  |  |  |  |  |  | 46
 |  |  |  |  |  |  |  | 47
 |  |  |  |  |  |  |  | 48
 |  |  |  |  |  |  |  | 49
 |  |  |  |  |  |  |  | 50
 |  |  |  |  |  |  |  | 51
 |  |  |  |  |  |  |  | 52
 |  |  |  |  |  |  |  | 53
 |  |  |  |  |  |  |  | 54
 |  |  |  |  |  |  |  | 55
 |  |  |  |  |  |  |  | 56
 |  |  |  |  |  |  |  | 57
 |  |  |  |  |  |  |  | 58
 |  |  |  |  |  |  |  | 59
 |  |  |  |  |  |  |  | 60
 |  |  |  |  |  |  |  | 61
 |  |  |  |  |  |  |  | 62
 |  |  |  |  |  |  | Rm4 - Short Tables | 63
 |  |  |  |  |  |  | Rm4 - Short Tables | 64
 |  |  |  |  |  |  |  | Total
Spreadsheet: 269825d1381299923-vlookup-or-index-0a225
Sheet: Sheet1

Rev. | Place | ID | Component |  | Place | Component | rev | ID
1 | 333 | 1000040 | 10001 |  | 333 | 10001
4 | 333 | 1000040 | 10001
2 | 444 | 1000040 | 10002
3 | 444 | 1000040 | 10003
 |  |  |  |  |  | Inputs
Spreadsheet: 275024d1383312979-filtering-data-rows-sample-data-file
Sheet: Sheet1

NAME, PATIENT 1
FIN | READMIT # | PATIENT | AGE | ARRIVAL D/T | DISCHARGE D/T | RFV | ED D/C DISPOSITION | ED PHYSICIAN | TRIAGE QUESTION | RESPONSE
123456 |  | NAME, PATIENT 1 | 34 | 2013-10-07 10:10:00 | 2013-10-07 16:23:00 | L EYE PAIN | Home | DR 1 | Visit to this ED in last 48 hrs | No
NAME, PATIENT 2
FIN | READMIT # | PATIENT | AGE | ARRIVAL D/T | DISCHARGE D/T | RFV | ED D/C DISPOSITION | ED PHYSICIAN | TRIAGE QUESTION | RESPONSE
234567 |  | NAME, PATIENT 2 | 40 | 2013-10-02 19:13:00 | 2013-10-03 18:30:00 | NEW ONSET AFIB | Admitted as inpatient | DR 2 | Visit to this ED in last 48 hrs | No
234567 |  | NAME, PATIENT 2 | 40 | 2013-10-15 09:04:00 | 2013-10-15 09:54:00 | LEFT EAR PAIN | Home | DR 2 | Visit to this ED in last 48 hrs | No
NAME, PATIENT 3
FIN | READMIT # | PATIENT | AGE | ARRIVAL D/T | DISCHARGE D/T | RFV | ED D/C DISPOSITION | ED PHYSICIAN | TRIAGE QUESTION | RESPONSE
567891 |  | NAME, PATIENT 3 | 84 | 2013-10-13 17:46:00 | 2013-10-13 23:31:00 | BACK PAIN | Home | DR 1 | Visit to this ED in last 48 hrs | No
Spreadsheet: 00b1ceb6-866d-43a5-9f36-4fbf8b127fe4
Sheet: 10a

Product |  | Cleared** | Uncleared | TOTAL
Swap* | Basis
 | FRA
 | Exotic
 | Inflation
 | IRS- [NAME]
 | OIS
 | VNS
 | Zero Coupon
With Optionality | Callable Swap
 | Cap/Floor
 | Debt Option
 | Exotic Option
 | Swaption
Cross-Currency | Exotic
 | Swap
TOTAL |  | N/A*** | N/A | N/A
Estimated net notional amount outstanding, December 7 weekly snapshot, by product type and tenor (millions of USD), all participant types and currencies.
Total(s) may be less than total shown for this asset class in the All Swaps reports and/or other CFTC Swaps Report tables if products were excluded from this table that (a) presented disclosure risk or (b) did not belong in the categories shown. See Explanatory Notes for more detail.
*See Data Dictionary for product descriptions and Explanatory Notes for data sources.
**See Explanatory Notes for cleared and uncleared descriptions.
***N/A indicates that data are not currently available.
The Commission requests feedback on the format and content of this CFTC Swaps Report table. Submit comments to [EMAIL].
Spreadsheet: 748456d1632151475-conditional-formatting-based-on-moving-average-cf-for-average-of-last-40-readings
Sheet: Sheet1

23
4
34
5 |  |  | Average of last 40 numbers
565
65 |  |  |  | FORMULA for CF |  | =AND(A1<>"",A1<AVERAGE(OFFSET(INDEX($A$1:$A$100000,AGGREGATE(14,6,ROW($A$1:$A$100000)/($A$1:$A$100000<>""),1)),0,0,-40,1)))
90
564
5
78
7657
9
8
454
8767
23
24
5
7
434
43
43
4
323
2
46
6
64
5
64
564
6
66
46
46
23
4
34
5
565
65
90
564
5
78
9
9
8
454
8767
23
24
5
7
434
43
43
4
323
2
46
6
64
5
64
564
6
66
46
46
23
4
34
5
565
65
90
564
5
78
9
9
8
454
8767
23
24
5
7
434
43
43
4
323
2
46
6
64
5
64
564
6
66
46
67
545
4654
576
78
Spreadsheet: 879366d1726847911-mismatched-date-formats-example
Sheet: Sheet1

 |  |  | Month | Salary |  |  |  |  |  | Cost | Description | Category | Date
 |  |  | January | 0 |  |  |  |  |  | 100 | Lowes | Materials | 2024-01-01 00:00:00
 |  |  | February | 0 |  |  |  |  |  | 250 | Lowes | Tools | 2024-02-01 00:00:00
 |  |  | March | 0 |  |  |  |  |  | 75 | Lowes | Materials | 2024-03-15 00:00:00
 |  |  | April | 0 |  |  |  |  |  | 60 | BP | Gas | 2024-04-18 00:00:00
 |  |  | May | 0 |  |  |  |  |  | 60 | BP | Gas | 2024-05-17 00:00:00
 |  |  | June | 510 |  |  |  |  |  | 300 | Adam | Salary | 2024-06-21 00:00:00
 |  |  | July | 0 |  |  |  |  |  | 22 | BP | Gas | 2024-07-09 00:00:00
 |  |  | August | 0 |  |  |  |  |  | 100 | Lowes | Materials | 2024-08-17 00:00:00
 |  |  | September | 0 |  |  |  |  |  | 150 | Adam | Salary | 2024-09-06 00:00:00
 |  |  | October | 0 |  |  |  |  |  | 15 | Lowes | Tools | 2024-10-20 00:00:00
 |  |  | November | 0 |  |  |  |  |  | 450 | Lowes | Materials | 2024-11-01 00:00:00
 |  |  | December | 0 |  |  |  |  |  | 60 | Adam | Salary | 2024-12-31 00:00:00
Spreadsheet: gstorey__12094__EOL Summary
Sheet: sum

 | Total
 | Central
 | East
 | West
 | Texas |  |  |  |  |  |  | Total
ANR SE Gath | Central |  |  |  |  | Jan
ANR SE Trans | Central |  |  |  |  | Feb
ANR SW Pool | Central |  |  |  |  | Mar
APC/ANR WillCo | Central |  |  |  |  | Apr
APC/VPC WillCo | Central |  |  |  |  | May
[NAME] | Central |  |  |  |  | Jun
ChiPeoplesIntra | Central |  |  |  |  | Jul
Consumers Pwr | Central |  |  |  |  | Aug
Harper | Central |  |  |  |  | Sep
[NAME] | Central |  |  |  |  | Oct
NBPL/ANR WillCo | Central |  |  |  |  | Nov
NBPL/Nicor | Central |  |  |  |  | Dec
NBPL/Ventura | Central
NGPL AmarilloML | Central |  |  |  |  |  |  | Central
NGPL IA-IL | Central
NGPL LA Intra | Central |  |  |  |  | Jan
NGPL LA Pool | Central |  |  |  |  | Feb
NGPL MidC Intra | Central |  |  |  |  | Mar
NGPL Midcont | Central |  |  |  |  | Apr
NGPL N Shore | Central |  |  |  |  | May
NGPL NICOR | Central |  |  |  |  | Jun
NGPL NIPSCO | Central |  |  |  |  | Jul
NGPL S TX Intra | Central |  |  |  |  | Aug
NGPL STX | Central |  |  |  |  | Sep
NGPL TxOk Intra | Central |  |  |  |  | Oct
NGPL TxOkGCPool | Central |  |  |  |  | Nov
NNG Demarc | Central |  |  |  |  | Dec
NNG Ventura | Central
OGT | Central
PEPL Pool | Central |  |  |  |  |  |  | East
Trunkline ELA | Central
Trunkline NTX | Central |  |  |  |  | Jan
Trunkline STX | Central |  |  |  |  | Feb
Trunkline WLA | Central |  |  |  |  | Mar
 |  |  |  |  |  | Apr
AlgonqinCtyGate | East |  |  |  |  | May
Carthage | East |  |  |  |  | Jun
CNG NP TT | East |  |  |  |  | Jul
CNG SP TT | East |  |  |  |  | Aug
COL Mainline | East |  |  |  |  | Sep
COL Onshore | East |  |  |  |  | Oct
Dom SP TT | East |  |  |  |  | Nov
[NAME] | East |  |  |  |  | Dec
HeHub | East
[NAME] | East
SONAT Z-0 Tier2 Pool | East |  |  |  |  |  |  | West
TCO Pool | East
TENN 500 | East |  |  |  |  | Jan
TENN 800 | East |  |  |  |  | Feb
TENN Dracut | East |  |  |  |  | Mar
[NAME] | East |  |  |  |  | Apr
TETCO ELA | East |  |  |  |  | May
TETCO M3 | East |  |  |  |  | Jun
TETCO STX | East |  |  |  |  | Jul
TETCO WLA | East |  |  |  |  | Aug
TGT Z-SL | East |  |  |  |  | Sep
Transco St.65 | East |  |  |  |  | Oct
[NAME] NY | East |  |  |  |  | Nov
TranscoZ6NNY | East |  |  |  |  | Dec
ExxonKaty | Texas
Waha | Texas
[NAME] | West
CIG Mainline | West
[NAME] | West
EPNG Keystone | West
EPNG [NAME] | West
NWPL RkyMtn Pool | West
NWPL SanJuan Pool | West
NWPL Wyoming Pool | West
Opal | West
PG&E CtyGte | West
PG&E Daggett | West
PG&E Topock | West
PGT Malin | West
PGT Stanfield | West
SoCal EHR | West
[NAME] | West
[NAME] | West
SoCal TW Needles | West
[NAME] | West
WIC | West
Spreadsheet: 90751d1290508672-another-vlookup-problem-copy-of-stocktake-19-11-10
Sheet: Not in lists

 | Item No. |  | Amount |  |  | Total
 | F910229 |  | 3 |  |  | 3
 | F810000 |  | 160 |  |  | 160
 | Batteries |  | 60 |  |  | 60
 | [NAME] |  | 18 |  |  | 18
 | F910334 |  | 9 |  |  | 9
 | [NAME] |  | 10 |  |  | 10
 | F930173 |  | 7 |  |  | 7
 | F930852 |  | 12 |  |  | 12
 | F910296 |  | 0 |  |  | 0
 | F920241 |  | 210 |  |  | 210
 | F930211 |  | 12 |  |  | 12
 | F910033 |  | 20 |  |  | 20
 | F810226 |  | 26 |  |  | 26
 | F810231 |  | 2 |  |  | 2
 | F810213 |  | 1 |  |  | 1
 | F910230 |  | 2 |  |  | 2
 | F910029 |  | 2 |  |  | 2
 | F910029 PKG |  | 2 |  |  | 2
 | F920114 |  | 4 |  |  | 4
 | F910201/200 |  | 100 |  |  | 100
 | 100/1900 |  | 1 |  |  | 1
 | F710535 |  | 4000 |  |  | 4000
 | F750515-RU |  | 19 |  |  | 19
 | F810075 |  | 144 |  |  | 144
 | F810087 |  | 56 |  |  | 56
 | F810075 |  | 2 |  |  | 2
 | F810210 |  | 4 |  |  | 4
 | F810012 |  | 20 |  |  | 20
 | F810072 |  | 54 | 6 |  | 60
 | F810074 |  | 36 | 4 |  | 40
 | F820009-A |  | 45 | 5 |  | 50
 | F810010 |  | 252 | 28 |  | 280
 | F810012 |  | 54 | 6 |  | 60
 | F810021 |  | 36 | 4 |  | 40
 | F810023 |  | 36 | 4 |  | 40
 | F810039 |  | 81 | 9 |  | 90
 | F810041 |  | 36 | 4 |  | 40
 | F810052 |  | 36 | 4 |  | 40
 | F810059 |  | 9 | 1 |  | 10
Spreadsheet: 837308d1690019669-filter-with-excluding-array-filter-1-aligw
Sheet: Feuil1

 |  |  |  |  |  |  |  | initial array |  | exclude array |  | initial with exclude |  | expected result
 |  |  |  |  |  |  |  |  |  |  |  |  |  | 46
 | 46 |  | 48 |  |  |  |  | 46 |  | 48 |  | 47 |  | 47
 | 47 |  | 49 |  |  |  |  | 47 |  | 49 |  | 50 |  | 50
 | 48 |  |  |  |  |  |  | 48 |  |  |  | 51 |  | 51
 | 49 |  |  |  |  |  |  | 49 |  |  |  | 52 |  | 52
 | 50 |  |  |  |  |  |  | 50 |  |  |  | 53 |  | 53
 | 51 |  |  |  |  |  |  | 51 |  |  |  | 54 |  | 54
 | 52 |  |  |  |  |  |  | 52 |  |  |  | 55 |  | 55
 | 53 |  |  |  |  |  |  | 53 |  |  |  | 56 |  | 56
 | 54 |  |  |  |  |  |  | 54 |  |  |  | 57 |  | 57
 | 55 |  |  |  |  |  |  | 55 |  |  |  | 58 |  | 58
 | 56 |  |  |  |  |  |  | 56 |  |  |  | 59 |  | 59
 | 57 |  |  |  |  |  |  | 57 |  |  |  | 60 |  | 60
 | 58 |  |  |  |  |  |  | 58
 | 59 |  |  |  |  |  |  | 59
 | 60 |  |  |  |  |  |  | 60
Spreadsheet: 843342d1695220697-xlookup-copying-formula-horizontally-while-skipping-certain-columns-book1
Sheet: Sheet1

WEEK 1
DAY 2 |  |  |  |  |  |  | DAY 3 |  |  |  |  |  |  | DAY 4 |  |  |  |  |  |  | DAY 5 |  |  |  |  |  |  | DAY 6
variety | amount | name | time start | time stop | time total | average | variety | amount | name | time start | time stop | time total | average | variety | amount | name | time start | time stop | time total | average | variety | amount | name | time start | time stop | time total | average | variety | amount | name | time start | time stop | time total | average
[NAME] | 1200 |  |  |  |  |  | [NAME] | 7 |  |  |  |  |  | [NAME] | 1200 |  |  |  |  |  | [NAME] | 7 |  |  |  |  |  | [NAME] | 1200
Dutchmaster | 3900 |  |  |  |  |  | [NAME] | 12 |  |  |  |  |  | Dutchmaster | 3900 |  |  |  |  |  | [NAME] | 12 |  |  |  |  |  | Dutchmaster | 3900
Brits Green | 5750 |  |  |  |  |  | Abbey. | 1 |  |  |  |  |  | Brits Green | 5750 |  |  |  |  |  | Abbey. | 1 |  |  |  |  |  | Brits Green | 5750
Roma Dark | 8950 |  |  |  |  |  | [NAME] | 2 |  |  |  |  |  | Roma Dark | 8950 |  |  |  |  |  | [NAME] | 2 |  |  |  |  |  | Roma Dark | 8950
[NAME] | 7400 |  |  |  |  |  | [NAME] | 3 |  |  |  |  |  | [NAME] | 7400 |  |  |  |  |  | [NAME] | 3 |  |  |  |  |  | [NAME] | 7400
Suncica | 150 |  |  |  |  |  | [NAME] | 9 |  |  |  |  |  | Suncica | 150 |  |  |  |  |  | [NAME] | 9 |  |  |  |  |  | Suncica | 150
[NAME] | 300 |  |  |  |  |  | Abbey. | 1 |  |  |  |  |  | [NAME] | 300 |  |  |  |  |  | Abbey. | 1 |  |  |  |  |  | [NAME] | 300
Abbey. | 100 |  |  |  |  |  | [NAME] | 2 |  |  |  |  |  | Abbey. | 100 |  |  |  |  |  | [NAME] | 2 |  |  |  |  |  | Abbey. | 100
[NAME] | 200 |  |  |  |  |  | [NAME] | 3 |  |  |  |  |  | [NAME] | 200 |  |  |  |  |  | [NAME] | 3 |  |  |  |  |  | [NAME] | 200
[NAME] | 300 |  |  |  |  |  | [NAME] | 8 |  |  |  |  |  | [NAME] | 300 |  |  |  |  |  | [NAME] | 8 |  |  |  |  |  | [NAME] | 300
[NAME] | 900 |  |  |  |  |  | [NAME] | 13 |  |  |  |  |  | [NAME] | 900 |  |  |  |  |  | [NAME] | 13 |  |  |  |  |  | [NAME] | 900
Abbey. | 100 |  |  |  |  |  | Insta | 11 |  |  |  |  |  | Abbey. | 100 |  |  |  |  |  | Insta | 11 |  |  |  |  |  | Abbey. | 100
[NAME] | 200 |  |  |  |  |  | Magnum | 17 |  |  |  |  |  | [NAME] | 200 |  |  |  |  |  | Magnum | 17 |  |  |  |  |  | [NAME] | 200
[NAME] | 300 |  |  |  |  |  | Mexicano | 5 |  |  |  |  |  | [NAME] | 300 |  |  |  |  |  | Mexicano | 5 |  |  |  |  |  | [NAME] | 300
Spreadsheet: 754507d1636281182-how-to-generate-a-range-of-values-between-2-points-with-a-given-average-rough-example
Sheet: Sheet1

 |  | High End: | 96 |  |  |  |  |  | 1
 |  | Low End: | 5
 |  | Approx. Average: | 60 |  |  |  |  | <-------------round 0,01
 |  | # of Data Points: | 16
min |  |  |  | point | bsalv | Rothstein
avg
[NAME]
Spreadsheet: 1766f70d-28d4-42c8-bfda-4526f53a7923
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
 | 6427.0 Producer Price Indexes, Australia
 | Table 20. Selected output of divisions J (information media and telecommunications), O (public administration and safety) and S (other services), group and class index numbers
Related Information: | Summary Publication | Explanatory Notes | Inquiries
Data Item Description |  |  | Series Type | Series ID | Series Start | Series End | No. Obs. | Unit | Data Type | [NAME]. | Collection Month
Index Numbers ;  541 Newspaper, periodical, book and directory publishing ; |  |  | Original | A3343938V | 2001-09-01 00:00:00 | 2011-09-01 00:00:00 | 41 | Index Numbers | INDEX | Quarter | 3
Index Numbers ;  5411 Newspaper publishing ; |  |  | Original | [NAME] | 2001-09-01 00:00:00 | 2011-09-01 00:00:00 | 41 | Index Numbers | INDEX | Quarter | 3
Index Numbers ;  5412 Magazine and other periodical publishing ; |  |  | Original | A2306528T | 1983-03-01 00:00:00 | 2011-09-01 00:00:00 | 115 | Index Numbers | INDEX | Quarter | 3
Index Numbers ;  5413 Book publishing ; |  |  | Original | A2306531F | 1989-09-01 00:00:00 | 2011-09-01 00:00:00 | 89 | Index Numbers | INDEX | Quarter | 3
Index Numbers ;  592 Data processing, web hosting and electronic information storage services ; |  |  | Original | A3343942K | 2001-09-01 00:00:00 | 2011-09-01 00:00:00 | 41 | Index Numbers | INDEX | Quarter | 3
Index Numbers ;  5921 Data processing and web hosting services ; |  |  | Original | A3343944R | 2001-09-01 00:00:00 | 2011-09-01 00:00:00 | 41 | Index Numbers | INDEX | Quarter | 3
Index Numbers ;  5922 Electronic information storage services ; |  |  | Original | A2314211V | 1997-12-01 00:00:00 | 2011-09-01 00:00:00 | 56 | Index Numbers | INDEX | Quarter | 3
Index Numbers ;  7712  Investigation and security services ; |  |  | Original | A2314256X | 1998-09-01 00:00:00 | 2011-09-01 00:00:00 | 53 | Index Numbers | INDEX | Quarter | 3
Index Numbers ;  9533 Parking services ; |  |  | Original | A2314112L | 1998-09-01 00:00:00 | 2011-09-01 00:00:00 | 53 | Index Numbers | INDEX | Quarter | 3
© Commonwealth of Australia  2011