tianzl66/Sheetpedia huggingface dataset:
Spreadsheet: 773509d1647887282-formula-required-to-find-solitary-remaining-number-from-string-excel-help
Sheet: Sheet 2

 |  |  | 3 | 4 | 2 | 9 | 5 | 1 |  | A
 |  |  |  |  |  |  |  |  |  | B
 |  |  |  |  |  |  |  |  |  | C
4 | 5 | 3 | 9 | 2 | 6 | 8 | 1 | 7 |  | D
2 | 6 | 7 | 8 | 5 | 1 | 3 | 9 | 4 |  | E
9 | 1 |  | 4 | 7 | 3 | 2 | 6 | 5 |  | F
7 | 9 | 4 | 6 | 8 | 5 | 1 | 2 | 3 |  | G
6 | 2 | 1 | 7 | 3 | 4 | 5 | 8 | 9 |  | H
3 |  | 5 | 2 | 1 | 9 | 7 | 4 | 6 |  | I
 |  |  |  |  |  |  |  |  |  |  | A |  |  |  |  |  |  |  |  | B |  |  |  |  |  |  |  |  | C |  |  |  |  |  |  |  |  | D |  |  |  |  |  |  |  |  | E |  |  |  |  |  |  |  |  | F |  |  |  |  |  |  |  |  | G |  |  |  |  |  |  |  |  | H |  |  |  |  |  |  |  |  | I
1 | 2 | 3 | 4 | 5 | 6 | 7 | 8 | 9
BOX | L2 | AM2 | BN2 | L5 | AM5 | BN5 | L8 | AM8 | BN8 |  | ACROSS |  |  |  |  |  |  |  |  |  |  | DOWN |  |  |  |  |  |  |  |  |  |  | INDIVIDUAL
 | AL4 | BM4 | CN4 | AL7 | BM7 | CN7 | AL10 | BM10 | BN10 |  |  | 1 | 2 | 3 | 4 | 5 | 6 | 7 | 8 | 9 |  |  | A | B | C | D | E | F | G | H | I
1 |  |  |  |  |  |  |  |  |  |  | A |  |  |  |  |  |  |  |  |  |  | 1
2 |  |  |  |  |  |  |  |  |  |  | B |  |  |  |  |  |  |  |  |  |  | 2
3 |  |  |  |  |  |  |  |  |  |  | C |  |  |  |  |  |  |  |  |  |  | 3
4 |  |  |  |  |  |  |  |  |  |  | D |  |  |  |  |  |  |  |  |  |  | 4
5 |  |  |  |  |  |  |  |  |  |  | E |  |  |  |  |  |  |  |  |  |  | 5
6 |  |  |  |  |  |  |  |  |  |  | F |  |  |  |  |  |  |  |  |  |  | 6
7 |  |  |  |  |  |  |  |  |  |  | G |  |  |  |  |  |  |  |  |  |  | 7
8 |  |  |  |  |  |  |  |  |  |  | H |  |  |  |  |  |  |  |  |  |  | 8
9 |  |  |  |  |  |  |  |  |  |  | I |  |  |  |  |  |  |  |  |  |  | 9
Spreadsheet: 651af8b9-e5c9-49fb-b73e-ea669c288aac
Sheet: Sheet1

LABEL | UPC | ARTIST | TITLE | RELEASEDATE | PRODUCTTYPE | GENRE | PRICE | [NAME] | STATUS
Taseis | 801193153821 | [NAME] | Morning, The | 2013-08-27 | Compact Disc | Gospel | 13.99 | N | Available
Spreadsheet: eric_saibi__9839__100401R
Sheet: Gannon 05

Owner Name |  | Tampa Electric Company
Station Name |  | [NAME]
Unit Name |  | [NAME] 05
NERC Region |  | FRCC
State |  | FL
Fuel Type |  | Coal
Capacity |  | 239 MW
Start Date |  | 2001-10-05 00:00:00
End Date |  | 2001-11-01 00:00:00
Prv. Start Date |  | 2001-10-07 00:00:00
Prv. End Date |  | 2001-11-03 00:00:00
Comments |  | Boiler,valves
SIC |  | 4911
Plant ID |  | 1015700
Unit ID |  | 1008555
Outage ID |  | 14716
Spreadsheet: 465514d1465729561-my-macro-to-delete-accents-does-not-work-spread-sheet
Sheet: Feuil4

DEPUTADOS | Doaçao [NAME]
BRUNO COVAS | 1
JUTAHY JUNIOR | 1
NILSON LEITAO | 1
PAULO ABI-ACKEL | 1
ELMAR NASCIMENTO | 1
[NAME] | 1
ALEX MANENTE | 1
BEBETO | 1
DANILO FORTE | 1
FERNANDO COELHO FILHO | 1
PAULO PEREIRA DA SILVA | 1
EDUARDO BOLSONARO | 1
PASTOR MARCO FELICIANO | 1
JHONATAN DE JESUS | 1
MARCELO SQUASSONI | 1
MARCELO ARO | 1
MARCOS MONTES | 1
PAULO MAGALHÃ£ES | 1
WELITON PRADO | 1
FLAVIO NOGUEIRA | 1
LEONARDO PICCIANI | 1
WASHINGTON REIS | 1
OSMAR TERRA | 1
LUCIO VIEIRA LIMA | 1
PAULO MALUF | 1
AGUINALDO RIBEIRO | 1
ROBERTO BRITTO | 1
JERONIMO GOERGEN | 1
BENITO GAMA | 1
ARLINDO CHINAGLIA | 1
[NAME] | 1
PAULO TEIXEIRA | 1
VICENTE CANDIDO | 1
ZE GERALDO | 1
BACELAR | 1
EDIO LOPES | 1
[NAME] | 1
[NAME] | 1
SILVIO COSTA | 1
Spreadsheet: 808600d1670529496-need-to-exclude-weekends-from-total-countif-formula-2022-annual-leave-tracker-sample
Sheet: Summary

 |  | Start Date: | 2022-01-01 00:00:00 | End Date: | 2022-12-31 00:00:00
 | EMP ID | EMP Name | Grand Total
 |  |  | Vacation | Leave without Pay | [NAME] | Half Day Leave | Maternity Leave | Work From Home | Unexplained Absence | Total
 |  |  | V | LWP | SL | HD | ML | WH | UA
 | 10001 | test Person
 | 10002
 | 10003
 | 10004
 | 10005
 | 10006
 | 10007
 | 10008
 | 10009
 | 10010
 | 10011
 | 10012
 | 10013
 | 10014
 | 10015
 | 10016
 | 10017
 | 10018
 | 10019
 | 10020
 | 10021
 | 10022
 | 10023
 | 10024
 | 10025
 | 10026
 | 10027
 | 10028
 | 10029
 | 10030
 | 10031
 | 10032
 | 10033
 | 10034
 | 10035
Spreadsheet: 763075d1641979837-how-to-find-the-max-and-min-dates-from-duplicate-names-in-a-row-and-filter-the-names-max-min-date-ans
Sheet: Sheet1

Raw Data |  |  | RESULT TABLE |  |  |  |  |  | RESULT TABLE
Date | Name |  | Name | Start | End |  |  |  | Name | Start | End
2022-01-01 00:00:00 | [NAME] |  |  |  |  |  |  |  | [NAME] | 2022-01-01 00:00:00 | 2022-01-04 00:00:00
2022-01-02 00:00:00 | [NAME] |  |  |  |  |  |  |  | Zoe | 2022-01-05 00:00:00 | 2022-01-07 00:00:00
2022-01-03 00:00:00 | [NAME] |  |  |  |  |  |  |  | [NAME] | 2022-01-08 00:00:00 | 2022-01-09 00:00:00
2022-01-04 00:00:00 | [NAME] |  |  |  |  |  |  |  | [NAME] | 2022-01-10 00:00:00 | 2022-01-11 00:00:00
2022-01-05 00:00:00 | Zoe
2022-01-06 00:00:00 | Zoe
2022-01-07 00:00:00 | Zoe
2022-01-08 00:00:00 | [NAME]
2022-01-09 00:00:00 | [NAME]
2022-01-10 00:00:00 | [NAME] |  | Name: Name is listed down and removing duplicates
2022-01-11 00:00:00 | [NAME] |  | Start: The Minimum Date for said name
2022-01-12 00:00:00 |  |  | End: The Maximum Date for said name
2022-01-13 00:00:00
2022-01-14 00:00:00
2022-01-15 00:00:00
2022-01-16 00:00:00
2022-01-17 00:00:00
2022-01-18 00:00:00
2022-01-19 00:00:00
2022-01-20 00:00:00
2022-01-21 00:00:00
2022-01-22 00:00:00
2022-01-23 00:00:00
2022-01-24 00:00:00
2022-01-25 00:00:00
2022-01-26 00:00:00
2022-01-27 00:00:00
2022-01-28 00:00:00
2022-01-29 00:00:00
2022-01-30 00:00:00
2022-01-31 00:00:00
Spreadsheet: darrell_schoolcraft__7761__imbalsumm0106
Sheet: NGPL

 | 52862 |  | 6828
 | Measured | Scheduled | Measured | Scheduled | Imbalance
1 | 63620 | 62288
2 | 56372 | 61906 | -748
3 | 56757 | 62291
4 | 62916 | 62291
5 | 66527 | 69603
6
7
8
9
10
11
12
13
14
15
16
17
18
19
20
21
22
23
24
25
26
27
28
29
30
31
2001-05-31 00:00:00 |  |  |  |  | 95914
2001-06-05 00:00:00
Spreadsheet: 116639d1311962231-designing-a-survey-in-excel-and-vb-questionnaire-on-nat-testing-of-blood-donations
Sheet: 9. HIV

 |  | HIV test results |  |  |  |  | HIV test results | 0
 |  |  |  |  |  |  | Please indicate HIV-1 subtypes prevalent in your country:
 |  | Please indicate the 3 most prevalent HIV-1 subtypes in your country: |  |  |  |  | A, percentage (if data available) | 0 | 0
 |  |  |  |  |  |  | B, percentage (if data available) | 0 | 0
 |  | A, percentage (if data available) |  |  |  |  | C, percentage (if data available) | 0 | 0
 |  |  |  |  |  |  | D, percentage (if data available) | 0 | 0
 |  | B, percentage (if data available) |  |  |  |  | E, percentage (if data available) | 0 | 0
 |  |  |  |  |  |  | F, percentage (if data available) | 0 | 0
 |  | C, percentage (if data available) |  |  |  |  | G, percentage (if data available) | 0 | 0
 |  |  |  |  |  |  | H, percentage (if data available) | 0 | 0
 |  | D, percentage (if data available) |  |  |  |  | J, percentage (if data available) | 0 | 0
 |  |  |  |  |  |  | K, percentage (if data available) | 0 | 0
 |  | E, percentage (if data available) |  |  |  |  | CRF (circulating recombinant forms), please specify and indicate percentage | 0 | 0
 |  |  |  |  |  |  | O, percentage (if data available) | 0 | 0
 |  | F, percentage (if data available) |  |  |  |  | N, percentage (if data available) | 0 | 0
 |  | G, percentage (if data available) |  |  |  |  | Please indicate HIV-2 prevalence in your country | 0
 |  | H, percentage (if data available)
 |  | J, percentage (if data available)
 |  | K, percentage (if data available)
 |  | CRF (circulating recombinant forms), please specify and indicate percentage
 |  | (if data available)
 |  | O, percentage (if data available)
 |  | N, percentage (if data available)
 |  | Please indicate HIV-2 prevalence in your country
 |  |  |  | Page 12 of 34
Spreadsheet: 797718d1664096237-dynamic-sheet-references-and-aggregation-coop-1-
Sheet: Kerrigan

Commanders | # | % | Maps | # | % |  | [NAME] | Partner |  | Games
 |  |  |  |  |  |  | Cradle of Death | [NAME]
Kerrigan |  |  | Cradle of Death
Artanis |  |  | Dead of Night
Swann |  |  | Lock & Load
Zagara |  |  | Malwarfare
Vorazun |  |  | Miner Evacuation
Karax |  |  | Mist Opportunities
[NAME] |  |  | Oblivion Express
Alarak |  |  | Part and Parcel
Nova |  |  | Rifts to Korhal
Stukov |  |  | Scythe of Amon
Fenix |  |  | Temple of the Past
Dehaka |  |  | The Vermillion Problem
Horner |  |  | Void Launch
Tychus |  |  | [NAME]
Zeratul
Stetmann
Mengsk
Spreadsheet: 747835d1631719426-rank-order-including-manual-overriding-rank-order-input-example-rank-including-overriding-order-input-77highland-
Sheet: Sheet1

 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | Rank/Order including manual overriding rank/order input (excelforum.com)
 | Asset ID | Due Date | Order (Auto) | Order (Manual) | Order (Final)
 | Asset 1 | 2021-04-18 00:00:00 |  |  | 1 |  |  |  |  |  |  |  |  |  |  |  |  |  |  | = Variable Cell To allow manual  overriding entry of order
 | Asset 2 | 2021-10-17 00:00:00 |  |  | 2
 | Asset 3 | 2022-08-06 00:35:52.406000 |  | 3 | 3
 | Asset 4 | 2022-06-19 00:00:00 |  |  | 8
 | Asset 5 | 2022-02-12 01:55:18.075000 |  |  | 7 |  |  |  |  |  |  |  |  |  |  |  |  |  |  | = Expected result To return new order including any overriding manual inputs
 | Asset 6 | 2021-12-20 12:06:27.538000 |  |  | 5
 | Asset 7 | 2022-06-22 05:43:32.826000 |  | 2 | 10
 | Asset 8 | 2021-11-19 06:56:25.719000 |  |  | 4
 | Asset 9 | 2022-01-27 05:07:35.182000 |  |  | 6
 | Asset 10 | 2022-06-21 12:49:18.904000 |  |  | 9
Spreadsheet: 220888d1363292564-please-help-with-index-and-match-inbound-freight-jacc2
Sheet: Sheet1

BestWay Trucking
 |  |  |  |  |  |  |  | ZIP CODE
 |  |  |  | 0 | 10000 | 20000 | 30000 | 40000 | 50000 | 60000 | 70000 | 80000 | 90000
 |  |  |  | 9 | 19999 | 29999 | 39999 | 49999 | 59999 | 69999 | 79999 | 89999 | 99999
 | 0 | to | 499.9 | 31.2 | 30.75 | 30 | 34.2 | 34.52 | 34.6 | 37.2 | 37.63 | 38.02 | 39.12
 | 500 | to | 999.9 | 31.08 | 30.63 | 29.88 | 34.08 | 34.4 | 34.48 | 37.08 | 37.51 | 37.9 | 39
 | 1000 | to | 1999.9 | 30.97 | 30.52 | 29.77 | 33.97 | 34.29 | 34.37 | 36.97 | 37.4 | 37.79 | 38.89
Weight | 2000 | to | 4999.9 | 30.86 | 30.41 | 29.66 | 33.86 | 34.18 | 34.26 | 36.86 | 37.29 | 37.68 | 38.78
(lbs) | 5000 | to | 9999.9 | 30.76 | 30.31 | 29.56 | 33.76 | 34.08 | 34.16 | 36.76 | 37.19 | 37.58 | 38.68 |  | Weight | ZIP CODE | BestWay Trucking | Pohlen TransGlobal
 | 10000 | to | 19999.9 | 30.66 | 30.21 | 29.46 | 33.66 | 33.98 | 34.06 | 36.66 | 37.09 | 37.48 | 38.58 |  | 1500 | 55000
 | 20000 | to | 29999.9 | 30.57 | 30.12 | 29.37 | 33.57 | 33.89 | 33.97 | 36.57 | 37 | 37.39 | 38.49
 | 30000 | + |  | 30.45 | 30 | 29.25 | 33.45 | 33.77 | 33.85 | 36.45 | 36.88 | 37.27 | 38.37
Pohlen TransGlobal
 |  |  |  |  |  |  |  | ZIP CODE
 |  |  |  | 0 | 10000 | 20000 | 30000 | 40000 | 50000 | 60000 | 70000 | 80000 | 90000
 |  |  |  | 9 | 19999 | 29999 | 39999 | 49999 | 59999 | 69999 | 79999 | 89999 | 99999
 | 0 | to | 499.9 | 31.63 | 31.97 | 30.5 | 34.22 | 30.74 | 33.54 | 36.99 | 37.52 | 37.87 | 40.63
 | 500 | to | 999.9 | 31.51 | 31.85 | 30.38 | 30.38 | 30.62 | 34.42 | 36.87 | 37.4 | 37.75 | 40.51
 | 1000 | to | 1999.9 | 31.4 | 31.74 | 30.27 | 30.27 | 30.51 | 34.31 | 36.76 | 37.29 | 37.64 | 40.4
Weight | 2000 | to | 4999.9 | 31.29 | 31.63 | 30.16 | 30.16 | 30.4 | 34.2 | 36.65 | 37.18 | 37.53 | 40.29
(lbs) | 5000 | to | 9999.9 | 31.19 | 31.53 | 30.06 | 30.06 | 30.3 | 34.1 | 36.55 | 37.08 | 37.43 | 40.19
 | 10000 | to | 19999.9 | 31.09 | 31.43 | 29.96 | 29.96 | 30.2 | 34 | 36.45 | 36.98 | 37.33 | 40.09
 | 20000 | to | 29999.9 | 31 | 31.34 | 29.87 | 29.87 | 30.11 | 33.91 | 36.36 | 36.89 | 37.24 | 40
 | 30000 | + |  | 30.88 | 31.22 | 29.75 | 29.75 | 29.99 | 33.79 | 36.24 | 36.77 | 37.12 | 39.88
Spreadsheet: 63664d1264548017-conditional-statements-example
Sheet: Sheet1

 | Product Description | Code
Room 1 | [NAME] blah | 1
Room 1 | [NAME] | 2
Room 1 | [NAME] | 3
Room 1 | [NAME] | 1 |  |  | RESULTS
Room 2 | [NAME] | 1
Room 2 | [NAME] blah | 3 |  |  | Code 1 | Code 2 | Code 3 | Code 4
Room 2 | [NAME] | 4
Room 2 | [NAME] blah | 1 |  | Room 1 | 2 | 1 | 1 | 0
Room 2 | [NAME] | 2 |  | Room 2 | 2 | 1 | 1 | 1
Room 3 | [NAME] blah | 4 |  | Room 3 | 2 | 2 | 0 | 3
Room 3 | [NAME] | 1 |  | Total Count
Room 3 | [NAME] blah | 2
Room 3 | [NAME] | 4
Room 3 | [NAME] blah | 2
Room 3 | [NAME] | 1
Spreadsheet: 727780d1618099400-2d-spilled-range-sum-formula-question-total-rows-2-columns-spilled-range
Sheet: Question

 | Monthly sales report (in metric tons)
 | Monthly
 | Product | 2020-01-31 00:00:00
 | Pear | 2 | 2 | 3 | 3 | 3 | 3 | 3 | 3 | 1 | 1 | 1 | 1
 | [NAME] | 3 | 3 | 4 | 4 | 4 | 4 | 4 | 4 | 1 | 1 | 1 | 1
 | Apple | 2 | 2 | 2 | 2 | 2 | 2 | 2 | 2 | 0 | 0 | 0 | 0
 | Total
Spreadsheet: 59aa82d9-964f-4ed8-91c9-20045de312c1
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
 | 5625.0 Private New Capital Expenditure and Expected Expenditure, Australia
 | TABLE 11A. Actual and Expected Capital Expenditure by Asset - Tasmania:Current Prices $m
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
Actual Expenditure ;  Tasmania ;  Total (Industry) ;  [NAME] and [NAME] ;  Current Price ; |  |  | Original | A3516142C | 1989-06-01 00:00:00 | 2009-12-01 00:00:00 | 83 | $ Millions | FLOW | Quarter | 3
Actual Expenditure ;  Tasmania ;  Total (Industry) ;  Equipment, Plant and Machinery ;  Current Price ; |  |  | Original | A3516184A | 1989-06-01 00:00:00 | 2009-12-01 00:00:00 | 83 | $ Millions | FLOW | Quarter | 3
Actual Expenditure ;  Tasmania ;  Total (Industry) ;  Total (Type of Asset - Detailed Level) ;  Current Price ; |  |  | Original | A3511774K | 1989-06-01 00:00:00 | 2009-12-01 00:00:00 | 83 | $ Millions | FLOW | Quarter | 3
Long Term Expected Expenditure ;  Tasmania ;  Total (Industry) ;  [NAME] and [NAME] ;  Current Price ; |  |  | Original | A3516144J | 1989-06-01 00:00:00 | 2009-12-01 00:00:00 | 83 | $ Millions | FLOW | Quarter | 3
Long Term Expected Expenditure ;  Tasmania ;  Total (Industry) ;  Equipment, Plant and Machinery ;  Current Price ; |  |  | Original | A3516186F | 1989-06-01 00:00:00 | 2009-12-01 00:00:00 | 83 | $ Millions | FLOW | Quarter | 3
Long Term Expected Expenditure ;  Tasmania ;  Total (Industry) ;  Total (Type of Asset - Detailed Level) ;  Current Price ; |  |  | Original | A3511776R | 1989-06-01 00:00:00 | 2009-12-01 00:00:00 | 83 | $ Millions | FLOW | Quarter | 3
Short Term Expected Expenditure ;  Tasmania ;  Total (Industry) ;  [NAME] and [NAME] ;  Current Price ; |  |  | Original | A3516143F | 1989-06-01 00:00:00 | 2009-12-01 00:00:00 | 83 | $ Millions | FLOW | Quarter | 3
Short Term Expected Expenditure ;  Tasmania ;  Total (Industry) ;  Equipment, Plant and Machinery ;  Current Price ; |  |  | Original | A3516185C | 1989-06-01 00:00:00 | 2009-12-01 00:00:00 | 83 | $ Millions | FLOW | Quarter | 3
Short Term Expected Expenditure ;  Tasmania ;  Total (Industry) ;  Total (Type of Asset - Detailed Level) ;  Current Price ; |  |  | Original | A3511775L | 1989-06-01 00:00:00 | 2009-12-01 00:00:00 | 83 | $ Millions | FLOW | Quarter | 3
© Commonwealth of Australia  2010
Spreadsheet: 759867d1639765595-consolidate-multiple-tables-data-consolidate-multiple-tables-data
Sheet: Sheet1

BOM (Bill of materials)  ("A") |  |  |  |  | Child Parts ("B") |  |  |  |  | [NAME] ("C") |  |  |  |  | DESIRED RESULT
Parent Item | Parent Item Code | Qty. | Weight |  | Parent Item | Child Items | Parent Item Code | Unit [NAME]. |  | Parent & Child Items | Weight |  |  |  | All Items | Weight of "C" (Items Packed) | Weight of "A" (BOM) (or) "B" (Child Parts) | Difference
[NAME] | [NAME] | 1 | 1.5 |  | Gas Stove | Stove | HY-06789 | 1.7 |  | [NAME] | 1.5 |  |  |  | [NAME] |  | 1.5
Table | [NAME] | 2 | 2.25 |  | Gas Stove | Burners | HY-06789 | 1.4 |  | Table | 2 |  |  |  | Table |  | 2.25
Bag | HY-03456 | 3 | 2.8 |  | Sofa | Wood | HY-07890 | 1.5 |  | Bag | 3 |  |  |  | Bag |  | 2.8
Stool | HY-04567 | 4 | 3.4 |  | Sofa | Cushion | HY-07890 | 1 |  | Stool | 3.4 |  |  |  | Stool |  | 3.4
Book | HY-05678 | 5 | 5.9 |  | Sofa | Cloth Cover | HY-07890 | 2 |  | Book | 5 |  |  |  | Book |  | 5.9
 | HY-06789 | 2 | 6.5 |  | Ceiling Fan | Fan Base | HY-08901 | 1.2 |  | Stove | 6.35 |  |  |  | Stove
 | HY-07890 | 3 | 6 |  | Ceiling Fan | Blades | HY-08901 | 1.56 |  | Fan Base | 5 |  |  |  | Burners
 | HY-08901 | 4 | 5.5 |  | Ceiling Fan | Regulator | HY-08901 | 1.4 |  | Blades | 1.56 |  |  |  | Wood
 |  |  |  |  | Ceiling Fan | Bolt & Nut | HY-08901 | 1.8 |  | Regulator | 1 |  |  |  | Cushion
 |  |  |  |  |  |  |  |  |  | Bolt & Nut | 1 |  |  |  | Cloth Cover
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  | Fan Base
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  | Blades
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  | Regulator
Requirement: |  |  |  |  |  |  |  |  |  |  |  |  |  |  | Bolt & Nut
1. (Column P) First need to get all the items from "A" (BOM), "B" (Child Parts) and "C" (Items Packed) in to one table  (Ex: Red font from "C" and Blue font items from "B").
2. (Col.Q) Get the weight of "C" items with the help of [NAME].
3. (Col.R)  lookup values from either "A" or "B".  For the items found in "B", the wight (Col.I) should multiply with Qty. (Col.C) of respective parent code.
Spreadsheet: 150950d1334746257-call-and-list-multiple-strings-unknown-amount-according-to-criteria-excel-help
Sheet: Sheet1

 |  | CURRENT INPUT |  |  |  |  |  |  | DESIRED OUTPUT
 |  |  | TRENDY | HIGH F | LOW F | PRICE CAT |  |  |  | PRICE CAT
 |  | Brand 1 | X |  | X | 1 |  |  |  | 1 | 2 | 3 | 4
 |  | Brand 2 |  | X |  | 3 |  |  | TRENDY | Brand 1
 |  | Brand 3 | X |  |  | 1 |  |  |  | Brand 3
 |  | Brand 4 |  | X |  | 3 |  |  | HIGH F |  |  | Brand 2
 |  |  |  |  |  |  |  |  |  |  |  | Brand 4
 |  |  |  |  |  |  |  |  | LOW F | Brand 1
Spreadsheet: 3c3fb57a-02a8-4b86-afbe-ed320a1d0d5f
Sheet: External Interface

Annual Reconfiguration Auction Result Report
SP_ARARESULT_<customer id>_<commitment period begin>_<version>.CSV
<[NAME]
Date: <mm/dd/yyyy> and Version: <mm/dd/yyyy hh:[NAME]:ss> GMT
External Interface Information |  |  |  | External Interface RA Result
External Interface Name | Capacity Zone ID | Capacity Zone Name | External Control Area | Start Date | End Date | Total Supply Offers Submitted | Total Demand Bids Submitted | Total Supply Offers Cleared | Total Demand Bids Cleared | Net Capacity Cleared | ISO Supply Offer | ISO Supply Offer Cleared | Clearing Price
String | Number | String | String | Date | Date | MW | MW | MW | MW | MW | MW | MW | $/kW-Month
Spreadsheet: 887724d1738054705-merging-data-from-multiple-workbooks-sorting-alphabetically-creating-new-workbooks-new-class-workbook-with-formulas-for-new-year
Sheet: Segmenting

Rm | Surname | First Name | Oral Segmenting |  |  |  |  |  | Correct   /6
 |  |  | ham | net | dog | [NAME] | mud | lip
Spreadsheet: 881809d1730009566-table-planner-for-an-event-adding-peoples-names-to-a-specific-table-table-booking
Sheet: Tables 

Table 1 |  |  |  |  |  |  | Table 2
 | Name | Surname | Dietry needs |  | Status |  |  | Name | Surname | Dietry needs |  | Status
1 |  |  |  |  |  |  | 1
2 |  |  |  |  |  |  | 2
3 |  |  |  |  |  |  | 3
4 |  |  |  |  |  |  | 4
5 |  |  |  |  |  |  | 5
6 |  |  |  |  |  |  | 6
7 |  |  |  |  |  |  | 7
8 |  |  |  |  |  |  | 8
9 |  |  |  |  |  |  | 9
10 |  |  |  |  |  |  | 10
Table 3 |  |  |  |  |  |  | Table 4
 | Name | Surname | Dietry needs |  | Status |  |  | Name | Surname | Dietry needs |  | Status
1 |  |  |  |  |  |  | 1
2 |  |  |  |  |  |  | 2
3 |  |  |  |  |  |  | 3
4 |  |  |  |  |  |  | 4
5 |  |  |  |  |  |  | 5
6 |  |  |  |  |  |  | 6
7 |  |  |  |  |  |  | 7
8 |  |  |  |  |  |  | 8
9 |  |  |  |  |  |  | 9
10 |  |  |  |  |  |  | 10
Table 5 |  |  |  |  |  |  | Table 6
 | Name | Surname | Dietry needs |  | Status |  |  | Name | Surname | Dietry needs |  | Status
1 |  |  |  |  |  |  | 1
2 |  |  |  |  |  |  | 2
3 |  |  |  |  |  |  | 3
4 |  |  |  |  |  |  | 4
5 |  |  |  |  |  |  | 5
6 |  |  |  |  |  |  | 6
7 |  |  |  |  |  |  | 7
8 |  |  |  |  |  |  | 8
9 |  |  |  |  |  |  | 9
10 |  |  |  |  |  |  | 10
Table 7 |  |  |  |  |  |  | Table 8
 | Name | Surname | Dietry needs |  | Status |  |  | Name | Surname | Dietry needs |  | Status
1 |  |  |  |  |  |  | 1
2 |  |  |  |  |  |  | 2
3 |  |  |  |  |  |  | 3
4 |  |  |  |  |  |  | 4
5 |  |  |  |  |  |  | 5
6 |  |  |  |  |  |  | 6
7 |  |  |  |  |  |  | 7
8 |  |  |  |  |  |  | 8
9 |  |  |  |  |  |  | 9
10 |  |  |  |  |  |  | 10
Table 9 |  |  |  |  |  |  | Table 10
 | Name | Surname | Dietry needs |  | Status |  |  | Name | Surname | Dietry needs |  | Status
1 |  |  |  |  |  |  | 1
2 |  |  |  |  |  |  | 2
3 |  |  |  |  |  |  | 3
4 |  |  |  |  |  |  | 4
5 |  |  |  |  |  |  | 5
6 |  |  |  |  |  |  | 6
7 |  |  |  |  |  |  | 7
8 |  |  |  |  |  |  | 8
9 |  |  |  |  |  |  | 9
10 |  |  |  |  |  |  | 10
Table 11
 | Name | Surname | Dietry needs |  | Status
1
2
3
4
5
6
7
8
9
10
Spreadsheet: 135934d1326310852-sumif-index-match-with-multiple-column-headings-same-criteria-book1
Sheet: Sheet1

Data |  | appleSales units | orangeSales units | appleSales units | orangeSales units | orangeSales units
 |  | Sales units | Sales units | Sales units | Sales units | Sales units
 | NE | 1 | 1 | 5 | 1 | 1
 | NE | 2 | 2 | 6 | 2 | 2
 | NE | 3 | 3 | 8 | 3 | 3
 | NE | 5 | 3 | 1 | 5 | 3
 | NW | 6 | 4 | 6 | 6 | 4
 | NW | 4 | 5 | 4 | 4 | 5
 | NW | 8 | 5 | 5 | 8 | 5
 | NW | 9 | 5 | 9 | 9 | 5
 | NW | 7 | 5 | 1 | 7 | 5
 | SE | 5 | 6 | 2 | 5 | 6
 | SE | 3 | 7 | 5 | 3 | 7
 | SE | 5 | 8 | 5 | 5 | 8
 | SE | 5 | 9 | 4 | 5 | 9
Result
 |  | Apple | Sales units |  | Orange | Sales units
 |  | NE | 11 |  | NE | 9
 |  | NW | 34 |  | NW | 24
 |  | SE | 18 |  | SE | 30
Spreadsheet: 219342d1362727289-help-with-a-formula-function-if-its-possible-admit-dc-2013
Sheet: 30

Admission and Discharges
2013
Date: | 2013-01-30 00:00:00
ADMISSIONS |  |  |  |  |  |  | DISCHARGES
Room # | Name | Time | From | Status | Telemetry Box # |  | Room # | Name | Time | To
 | How many admits: 0001-0200: | 0 | How many  From ED | How many inpt | Total # Admits |  |  | How many d/c: 0001-0200: | 0 | Total #  Discharges
 | How many admits: 0201-0400: | 0 | 0 | 0 | 0 |  |  | How many d/c: 0201-0400: | 0 | 0
 | How many admits: 0401-0600: | 0 | How many  From CDU | How many obs |  |  |  | How many d/c: 0401-0600: | 0
 | How many admits: 0601-0800: | 0 | 0 | 0 |  |  |  | How many d/c: 0601-0800: | 0
 | How many admits: 0801-1000: | 0 | How many from ASU |  |  |  |  | How many d/c: 0801-1000: | 0
 | How many admits: 1001-1200: | 0 | 0 |  |  |  |  | How many d/c: 1001-1200: | 0
 | How many admits: 1201-1400: | 0 | How many from OR |  |  |  |  | How many d/c: 1201-1400: | 0
 | How many admits: 1401-1600: | 0 | 0 |  |  |  |  | How many d/c: 1401-1600: | 0
 | How many admits: 1601-1800: | 0 | How many from CV |  |  |  |  | How many d/c: 1601-1800: | 0
 | How many admits: 1801-2000: | 0 | 0 |  |  |  |  | How many d/c: 1801-2000: | 0
 | How many admits: 2001-2200: | 0 | How many DA |  |  |  |  | How many d/c: 2001-2200: | 0
 | How many admits: 2201-2400: | 0 | 0 |  |  |  |  | How many d/c: 2201-2400: | 0
ROOM TRANSFERS |  |  |  |  |  |  | TELEMETRY - ON / OFF
Room # | Name | To Room # |  |  |  |  | Room# | Name | On/Off | Box #
 | Maloney