tianzl66/Sheetpedia huggingface dataset:
Spreadsheet: 7faa1762-60ca-4f8b-908f-548d46121549
Sheet: Sheet1

Scholarship | Amount | Deadline
Hearing, Hard of Hearing, and Deaf Students
ASL Scholarship Program - ASL Honor Society | 1000 | 2012-05-04 00:00:00
http://www.aslhonorsociety.org/Honor_Society_scholarship.html
The Millie Brother Scholarship for Hearing Children of Deaf Adults (CODA) | 3000 | 2012-04-06 00:00:00
http://coda-international.org/blog/scholarship/
Hard of Hearing/Deaf Students
Communication Contest for the Deaf and Hard of Hearing - Optimism International | 2500
http://www.optimist.org/e/visitor/scholarships.cfm
Scholarship Trust for the Deaf & Near Deaf - Travelers Protective Assoc. of America | Varies | 2012-03-01 00:00:00
http://www.tpahq.org/scholarshiptrust.html
Hard of Hearing or Deaf Scholarship - Sertoma International | 1000 | 2012-05-01 00:00:00
http://www.sertoma.org/scholarships
National Fraternal Society of the Deaf Scholarship | 1000 | 2012-07-01 00:00:00
http://www.nfsd.com
Registry of Interpreters for the Deaf Scholarships
For information on how to become a member, visit www.rid.org
Scholarship | Amount | Deadline
The Evelyn Zola Scholarship | 500 | 2012-04-28 00:00:00
http://www.rid.org/userfiles/File/pdfs/Scholarships_Awards/Zola_April2011_Revised_repost.pdf
[NAME] | 500 | 2012-04-28 00:00:00
http://www.rid.org/userfiles/File/pdfs/Scholarships_Awards/ScholarshipInfo_BursteinScholarship_March2011_repost.pdf
[NAME] Memorial Scholarship | Varies | 2012-03-01 00:00:00
http://www.rid.org/UserFiles/File/pdfs/Scholarships_Awards/DanielHPokorny_scholorship_appl.pdf
[NAME] | 500 | 2012-03-01 00:00:00
http://www.rid.org/UserFiles/File/pdfs/Scholarships_Awards/benson.pdf
Minority Scholarships | Amount | Deadline
Hispanic Scholarship Fund (List of Scholarships) | Varies | Varies
http://www.hsf.net/innerContent.aspx?id=426
Jack and Jill America Foundation Scholarship | 2500 | 2012-03-14 00:00:00
http://www.jackandjillfoundation.org/scholarships/
The Gates Millennium Scholarship | Varies | 2012-01-11 00:00:00
http://www.gmsp.org/
The Jackie Robinson Foundation | 7500 | 2012-03-30 00:00:00
http://www.jackierobinson.org/apply/general-applicants.php
[NAME] [NAME]
http://rmhc.org/what-we-do/rmhc-u-s-scholarships/
RMHC/Scholars (For any HS Senior) | Varies | 2012-01-27 00:00:00
RMHC/Asia (Asian-Pacific Heritage) | Varies | 2012-01-27 00:00:00
RMHC/African-American Future Achievers (African American/Black Carribbean Heritage) | Varies | 2012-01-27 00:00:00
RMHC/HACER (Hispanic/Latino Heritage) | Varies | 2012-01-27 00:00:00
FAFSA Required
Scholarship/Grant | Amount
Federal [NAME] | 5550
New York Resident Scholarship | $500-$1,500 | 2012-06-30 00:00:00
Spreadsheet: 123755d1317837646-using-a-command-button-to-switch-tabs-in-excel-2007-rosterphnyc
Sheet: Kitchen

 | August | Mon |  | [NAME] |  | Wed |  | Thurs |  | Fri |  | Sat |  | Sun
 | 2011 | 31 |  | 4
 | KITCHEN | AM | PM | AM | PM | AM | PM | AM | PM | AM | PM | AM | PM | AM | PM
 | Name | 10
 | Name
 | Name
 | Name
 | Name
 | Name
 | Name
Spreadsheet: 701452d1603773492-delete-repeated-duplicate-rows-based-on-2nd-column-value-remove-duplicate-values
Sheet: Sheet1

Product Code | Shipping Cost | Supplier | Outcome
ABC-1 | 10 | A | Remove
ABC-1 | 4 | B | Remove
ABC-1 | 2 | C
XYZ-4 | 60 | A | Remove
XYZ-4 | 30 | B
Spreadsheet: dc5af8a4-c57b-48da-8aea-c31572533c4b
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
PMLK | Test | PMLK | Milk, Processed, IgE | Milk, Processed, IgE | Fluorescence Enzyme Immunoassay (FEIA) | Serum Gel Tube: SGT |  |  | 0.5 | mL | Container/Tube:  Preferred: Red top Acceptable: Serum gel [NAME]: 0.5 mL for each 5 allergens requested Additional Information: Designate specific allergens from the list in Allergens-IgE Antibodies in Special Instructions. Forms: If not ordering electronically, submit an Allergen Request Form (Supply T236) with the specimen. | For 1 allergen: 0.3 mL/For more | Hemolysis	Mild OK; Gross OK Thawing	Warm reject; Cold OK Lipemia	Mild OK; [NAME] OK Icterus	NA Other	NA | Class	IgE kU/L	Interpretation 0	<0.35	Negative 1	0.35-0.69	Equivocal 2	0.70-3.49	Positive 3	3.50-17.4	Positive 4	17.5-49.9	Strongly positive 5	50.0-99.9	Strongly positive 6	> or =100	Strongly positive Reference values apply to all ages. | Monday through Friday, 9 a.m.-8 p.m. Saturday 8 a.m.-3 p.m. | Same day/1 day | 3 days | 1 | 86003 |  |  |  |  | Rochester
PMLK | [NAME] | SERUM | Serum |  |  |  | Refrigerated | 14 days
PMLK | Result | PMLK | Milk, Processed, IgE | Milk, Processed, IgE | Numeric |  |  |  |  | kU/L |  |  |  |  |  |  |  |  |  | 6174-7 | Milk Ab.IgE:ACnc:Pt:Ser:Qn:
Spreadsheet: geir_solberg__11298__2-1act
Sheet: Economics

 | Commodity Revenue (Cost) | Demand Charge | Total | Total Volume | $/Mwhr Commodity Cost | $/Mwhr Total Cost
Purchases
[NAME]. Cost Est. |  |  |  |  | 20 | 0
Incremental Purchases
[NAME]
4C Balancing
4C Realtime
[NAME]
PV Balancing
PV Realtime
SPS Pre
Artesia Balancing
Artesia Realtime
Sales
Incremental Sales
[NAME]
4C Balancing
4C Realtime
[NAME]
PV Balancing
PV Realtime
[NAME]
Artesia Balancing
Artesia Realtime
 |  |  |  |  |  |  | Heat | Fuel
Generation |  |  |  |  |  |  | Rate | Cost
4 Corners Unit 4 |  |  |  |  |  |  | 10.0576 | 1.3
4 Corners Unit 5 |  |  |  |  |  |  | 10.0576 | 1.3
PV Unit 1 |  |  |  |  |  |  | 10.16 | 0.6
PV Unit 2 |  |  |  |  |  |  | 10.16 | 0.6
PV Unit 3 |  |  |  |  |  |  | 10.16 | 0.6
Newman 1
Newman 2 |  |  |  |  |  |  |  | 1.96
Newman 3
GT 1
GT 2
GT1+ST1
GT2+ST1
Newman 4 |  |  |  |  |  |  |  | 1.96
Copper
Rio Grande 6
Rio Grande 7
Rio Grande 8
Total
Spreadsheet: 739104d1625511368-macro-to-compare-references-and-values-and-extract-items-not-matching-to-a-seperate-sheet-macro-to-compare-ref-numbers-and-extract-items-that-do-not-match
Sheet: Reconciling Items

Reference | Date Processed | Balance |  | Purchase.Reference | Purchase.Date Processed | Purchase.Balance
634985 | 03-MAY-2021 | 620.75 |  | 634985 | 2021-05-03 00:00:00 | 620.75
634654 | 03-MAY-2021 | 400.35 |  | 634654 | 2021-05-03 00:00:00 | 400.35
9285 | 03-MAY-2021 | 415.75 |  | 635080 | 2021-05-06 00:00:00 | 88.5
635080 | 06-MAY-2021 | 88.5 |  | 634958 | 2021-05-03 00:00:00 | 705.65
634958 | 03-MAY-2021 | 705.65 |  | 635146 | 2021-05-03 00:00:00 | 730.25
635146 | 03-MAY-2021 | 730.25 |  | 635196 | 2021-05-06 00:00:00 | 801.75
635196 | 06-MAY-2021 | 801.75
Spreadsheet: 8fbca4e8-083c-414a-828a-ccd0539c0d69
Sheet: Sheet1

PROG ID | ATHLETE ID | ATHLETE FIRST | ATHLETE LAST | NATIONALITY | START NUMBER | RUN | T1 | BIKE | T2 | RUN.1 | POSITION | TOTAL TIME
5240 | 29433 | Fabrizio | Vignali | ITA | 0 | 00:42:53 | 00:01:46 | 01:08:41 | 00:01:45 | 00:21:30 | 1 | 02:16:36
5240 | 7981 | [NAME] | [NAME] | USA | 0 | 00:47:40 | 00:01:34 | 01:10:06 | 00:01:47 | 00:33:36 | 2 | 02:34:47
5240 | 34078 | [NAME] | [NAME] | USA | 0 | 00:53:59 | 00:01:08 | 00:00:00 | 00:00:00 | 00:00:00 | DNF | 00:00:00
Spreadsheet: debra_perlingiere__8434__Co-Steel
Sheet: AMASTPSA 

MASTER FIRM PURCHASE/SALE AGREEMENT INFORMATION SHEET
ENA Entity: | ENA | ATTORNEY:
DATE: | 2001-10-24 00:00:00 | ENA CONTACT: | [NAME]
COUNTERPARTY: | Co-Steel Inc. | CONTACT: | [NAME]
ADDRESS: | 225 Elm Street | TITLE:
 | [NAME], NJ  08862 | PHONE: | [PHONE] x229
 |  | FAX: | [PHONE]
INCORPORATION STATE: |  | S&P RATING:
STRUCTURE | COUNTERPARTY | ENRON ENTITY
COLLATERAL
THRESHOLD  in $ | 3000000 | 15000000
COMMITTED VOLUMES
THRESHOLD in $[NAME] | N/A | N/A
COLLATERAL REQUIRED FOR:
ALL TRADES
OTHER | N/A | N/A
COLLATERAL TYPE
Letter of Credit | OK | OK
Cash | OK | OK
COLLATERAL  MULTIPLE | 250000 | 250000
GUARANTOR (RATING) | N/A | Enron Corp. (BBB+)
LIMIT in $[NAME] |  | 20000000
Incorporation State: |  | OR
MATERIAL ADVERSE CHANGE TRIGGERS  APPLY TO:
-Counterparty | X
-Guarantor |  | X
Debt Ratings Change |  | X
-Below = |  | BBB- (Standard & Poor's)
Financial Covenants
-Funded Debt/Net Worth
-Minimum Net worth | 500000000
-EBITDA/Interest | 2.5:1
-Current Ratio
Non-Specific
-Unilateral
Ownership Change
-Less than 51% owned by:
Non-Standard Definitions
-Funded Debt
-Net Worth
-Cash Flow
EVENTS OF DEFAULT
3rd party debt | X | X
-Counterparty | 5000000
-Guarantor ($[NAME]) |  | 100000000
FIN'L STATEMENTS
-Standard | X | X | Upon request
CREDIT DECISION: | APPROVED:  X | DECLINED:
OUTSTANDING PHYSICAL TRADES: |  | YES:  X | NO:
ALL TRADES TO ROLL UP UNDER NEW MASTER: |  | YES:    X | NO:
OTHER COMMENTS
CREDIT REVIEW  PREPARED BY: |  | [NAME] | Ext. 5-8261
Spreadsheet: 778059d1650826035-work-shifts-with-monthly-update-works-1-
Sheet: mese

Anno | 2022 |  | 1
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | ddd
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | ddd
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | ddd
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | ddd
Spreadsheet: 138557d1327711173-solved-2-way-lookup-between-tables-2waylookup
Sheet: PROGRAM EXPENSES

SpendingPattern | 10/1/2011 | 11/1/2011 | 12/1/2011 | 1/1/2012 | 2/1/2012 | 3/1/2012 | 4/1/2012 | 5/1/2012 | 6/1/2012 | 7/1/2012 | 8/1/2012 | 9/1/2012 | SUM
Flat | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0
Spring Seasonal | 0.006 | 0.017 | 0.044 | 0.092 | 0.15 | 0.191 | 0.191 | 0.15 | 0.092 | 0.044 | 0.017 | 0.006
Winter Seasonal | 0.05 | 0.1 | 0.25 | 0.3 | 0.25 | 0.05 | 0 | 0 | 0 | 0 | 0 | 0
Acct | Total | SpendingPattern | %Fixed | FixedMonthly$ | Total=MonthlySum | 10/1/2011 | 11/1/2011 | 12/1/2011 | 1/1/2012 | 2/1/2012 | 3/1/2012 | 4/1/2012 | 5/1/2012 | 6/1/2012 | 7/1/2012 | 8/1/2012 | 9/1/2012
Expense 1 | -100000 | Flat | 1
Expense 2 | -12000 | Spring Seasonal | 0.5
Expense 3 | -1000 | Winter Seasonal | 0
 |  |  |  |  |  | ^ The formula in this column of the blue table works, but I can't drag it across, I don't  know how to hold the structured reference column absolute. Is there any way to get the same INDEX result using the table's structured references?
 |  |  |  |  |  | And all of that wrapped up into a formula I can drag.
Spreadsheet: 8b0ee6c2-1a05-4668-8279-163fd5ac99b6
Sheet: Sheet1

Date | Sport | Opponent | Time_Results
09/02/2006 | Football | [NAME] | W, 42-10
09/09/2006 | Football | EASTERN WASHINGTON | W, 52-3
09/14/2006 | Football | MARYLAND | W, 45-24
09/23/2006 | Football | at East Carolina | W, 27-10
10/07/2006 | Football | at Mississippi State | W, 42-14
10/14/2006 | Football | SYRACUSE | W, 41-17
10/20/2006 | Football | at Connecticut | W, 37-11
11/02/2006 | Football | at Louisville | L, 34-44
11/11/2006 | Football | CINCINNATI | W, 42-24
11/16/2006 | Football | at Pitt | W, 45-27
11/25/2006 | Football | USF | L, 19-24
12/02/2006 | Football | RUTGERS | W, 41-39 (3OT)
[NAME] | Football | Georgia Tech (Gator Bowl) | W, 38-35
Spreadsheet: 136717d1326804941-display-name-along-with-score-tournament-stats-template-copy
Sheet: Bowling

 |  | Match 1 |  |  |  |  | Match 2 |  |  |  |  | Match 3 |  |  |  |  | Match 4 |  |  |  |  | Match 5 |  |  |  |  | Match 6 |  |  |  |  | Match7 |  |  |  |  | Match8 |  |  |  |  |  |  |  |  |  |  |  |  | TOURNAMENT STATS
Name | Team | Runs | Overs | Wickets | Maidens | ER | Runs | Overs | Wickets | Maidens | ER | Runs | Overs | Wickets | Maidens | ER | Runs | Overs | Wickets | Maidens | ER | Runs | Overs | Wickets | Maidens | ER | Runs | Overs | Wickets | Maidens | ER | Runs | Overs | Wickets | Maidens | ER | Runs | Overs | Wickets | Maidens | ER |  | Most Maidens | Most Wickets | 5 Wickets | Overall ER | Name |  |  | Most Maidens | Most Wickets | Best ER | 5 Wickets | Total Wickets | Total Maidens
a |  | 24 | 4 | 1 | 0 |  | 14 | 4 | 0 | 1 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | Score
b |  | 27 | 4 | 3 | 1 |  | 30 | 5 | 1 | 2 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | Name
c |  | 25 | 5 | 0 | 1 |  | 26 | 3 | 0 | 0
d |  | 58 | 8 | 0 | 0 |  | 20 | 4 | 2 | 0
e |  | 20 | 4 | 6 | 1 |  | 58 | 8 | 0 | 3
f |  | 26 | 3 | 0 | 0 |  | 25 | 5 | 4 | 0
g |  | 30 | 5 | 0 | 0 |  | 27 | 4 | 0 | 0
h |  | 14 | 4 | 0 | 2 |  | 24 | 4 | 0 | 0
Spreadsheet: daren_farmer__5910__leak
Sheet: PRESS

PRESSURE READINGS USED IN CALCULATIONS
PRESSURE FROM METER # 986501-10 VOLUME STATEMENT
USED THE DAILY PRESSURE AVERAGES
2000-04-01 00:00:00 |  |  |  | 2000-03-01 00:00:00 |  |  |  | 2000-02-01 00:00:00 |  |  |  | 2000-01-01 00:00:00
PSIA | PSIG | DAY |  | PSIA | PSIG | DAY |  | PSIA | PSIG | DAY |  | PSIA | PSIG | DAY
---- |  | --- |  | ---- |  | --- |  | ---- |  | --- |  | ---- |  | ---
589 |  | 1 |  | 630 |  | 1 |  | 616 |  | 1 |  | 638 |  | 1
597 |  | 2 |  | 571 |  | 2 |  | 581 |  | 2 |  | 679 |  | 2
584 |  | 3 |  | 613 |  | 3 |  | 625 |  | 3 |  | 670 |  | 3
610 |  | 4 |  | 657 |  | 4 |  | 586 |  | 4 |  | 627 |  | 4
622 |  | 5 |  | 661 |  | 5 |  | 585 |  | 5 |  | 625 |  | 5
637 |  | 6 |  | 634 |  | 6 |  | 660 |  | 6 |  | 623 |  | 6
615 |  | 7 |  | 645 |  | 7 |  | 670 |  | 7 |  | 591 |  | 7
615 |  | 8 |  | 657 |  | 8 |  | 610 |  | 8 |  | 632 |  | 8
624 |  | 9 |  | 669 |  | 9 |  | 655 |  | 9 |  | 674 |  | 9
643 |  | 10 |  | 659 |  | 10 |  | 669 |  | 10 |  | 639 |  | 10
620 |  | 11 |  | 640 |  | 11 |  | 642 |  | 11 |  | 604 |  | 11
557 |  | 12 |  | 638 |  | 12 |  | 649 |  | 12 |  | 563 |  | 12
616 |  | 13 |  | 631 |  | 13 |  | 667 |  | 13 |  | 564 |  | 13
624 |  | 14 |  | 622 |  | 14 |  | 665 |  | 14 |  | 583 |  | 14
641 |  | 15 |  | 630 |  | 15 |  | 633 |  | 15 |  | 651 |  | 15
657 |  | 16 |  | 640 |  | 16 |  | 633 |  | 16 |  | 660 |  | 16
653 |  | 17 |  | 638 |  | 17 |  | 633 |  | 17 |  | 655 |  | 17
564 |  | 18 |  | 628 |  | 18 |  | 601 |  | 18 |  | 601 |  | 18
570 |  | 19 |  | 616 |  | 19 |  | 568 |  | 19 |  | 606 |  | 19
570 |  | 20 |  | 640 |  | 20 |  | 595 |  | 20 |  | 593 |  | 20
658 |  | 21 |  | 646 |  | 21 |  | 582 |  | 21 |  | 561 |  | 21
654 |  | 22 |  | 654 |  | 22 |  | 583 |  | 22 |  | 599 |  | 22
627 |  | 23 |  | 625 |  | 23 |  | 647 |  | 23 |  | 610 |  | 23
578 |  | 24 |  | 623 |  | 24 |  | 679 |  | 24 |  | 591 |  | 24
576 |  | 25 |  | 603 |  | 25 |  | 606 |  | 25 |  | 577 |  | 25
589 |  | 26 |  | 636 |  | 26 |  | 583 |  | 26 |  | 580 |  | 26
573 |  | 27 |  | 639 |  | 27 |  | 615 |  | 27 |  | 604 |  | 27
582 |  | 28 |  | 632 |  | 28 |  | 612 |  | 28 |  | 592 |  | 28
632 |  | 29 |  | 636 |  | 29 |  | 592 |  | 29 |  | 600 |  | 29
642 |  | 30 |  | 637 |  | 30 |  |  |  |  |  | 642 |  | 30
 |  |  |  | 612 |  | 31 |  |  |  |  |  | 631 |  | 31
Spreadsheet: 161267d1339459399-count-of-style-in-a-range-of-sale-contribution-copy_book5-test
Sheet: Contribution

 |  | % CONTRIBUTION
Total Sales
2214325
% | 0.2 | 0.25 | 0.5 | 0.75 | 0.9 | 1
Row Position | 12 | 17 | 61 | 139 | 223 | 3499
Excluded: Accessories, [NAME] received last week & >90% check out (excluded In Transit & DC Stock)
 | SALES | 0% - 20% | 0% - 25% | 0% - 50% | 0% - 75% | 0% - 90% | 0% - 100%
CUMULATIVE | Styles | 12 | 17 | 61 | 137 | 215 | 343
 | Sales $ | 436775 | 536335 | 1104387 | 1657406 | 1991687 | 2214325
 | Sales $ / style | 36397.91666666666 | 31549.11764705883 | 18104.70491803279 | 12097.85401459854 | 9263.66046511628 | 6455.758017492712
SALES | 0%-20% | 21%-25% | 26%-50% | 51%-75% | 76%-90% | 91%-100% | TOTAL
Styles | 12 | 5 | 44 | 76 | 78 | 128 | 343
Sales $ | 436775 | 99560 | 568052 | 553019 | 334281 | 222638 | 2214325
Sales $ / style | 36397.91666666666 | 19912 | 12910.27272727273 | 7276.565789473684 | 4285.653846153846 | 1739.359375 | 6455.758017492712
Sales Units | 28261 | 6543 | 23431 | 23755 | 15630 | 14422 | 112042
EOH Units | 354299 | 76586 | 255683 | 267088 | 181997 | 138446 | 1274099
AVG WOS | 12.53667598457238 | 11.70502827449182 | 10.91216764115915 | 11.24344348558198 | 11.64408189379399 | 9.599639439744834 | 11.37161957123222
# of Styles under AVG WOS | 7 | 2 | 35 | 48 | 48 | 16 | 156
# of Styles over AVG WOS | 5 | 3 | 9 | 28 | 30 | 112 | 187
Spreadsheet: 881933d1730190142-extract-only-number-from-row-track-no
Sheet: Sheet1

TRACK NUMBER | OUT PUT
ADBDM08223298 | 8223298
[NAME] | 8237405
BRDM08270964 | 8270964
BRDM08277279 | 8277279
BRDM08282888 | 8282888
BWDM08254705 | 8254705
CHNM0827731 | 827731
DBRM82158016 | 82158016
GDAM08211478 | 8211478
GDAM08290744 | 8290744
GGNM08223895 | 8223895
[NAME] | 8217428
HAIERM08217014 | 8217014
HRDRM08256535 | 8256535
HVLM08287087 | 8287087
ITCM05077449 | 5077449
ITCM08238302 | 8238302
JCHBM08254304 | 8254304
JCHIM08220549 | 8220549
KNBM05192909 | 5192909
LGAM08213899 | 8213899
WHLM08300699 | 8300699
PLWC752024114472 | [PHONE]
Spreadsheet: 759875d1639769716-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: 884302d1733397604-headcount-allocation-by-month-headcount-allocation
Sheet: Sheet1

Name | Co #1 | Co #2 | Co #3 | Join Date | Last Day |  |  | 2024-01-31 00:00:00
[NAME] | 1 |  |  | 2023-01-25 00:00:00 |  |  | Co #1
[NAME] | 0.5 |  | 0.5 | 2024-01-01 00:00:00 |  |  | Co #2
[NAME] |  | 0.5 | 0.5 | 2024-03-03 00:00:00 | 2024-09-05 00:00:00 |  | Co #3
[NAME] |  | 1 |  | 2024-11-10 00:00:00
[NAME] | 1 |  |  | 2024-12-01 00:00:00
 |  |  |  |  |  |  | *Possible to have the yellow part dynamtically?
 |  |  |  |  |  |  | * I need to have the Headcount for Each company as at EOMONTH.
 |  |  |  |  |  |  | if a Person's Join date EOMONTH (example 31/01/2024), then it will appear under Jan'24 as well
 |  |  |  |  |  |  | if a Person's Last day is EOMONTH (example 31/01/2024), then it shall still appear under Jan'24
 |  |  |  |  |  |  | * For [NAME], the 0.5 in Co#2 and Co#3 onli exist from Mar'24 till Aug'24 since he left on [NAME]
Spreadsheet: 550838d1512573131-auto-generate-data-in-multiple-cells-example-workbook
Sheet: CODE 02

02 |  |  |  | Discount |  | Discount |  | Discount |  | Discount |  | Discount | Running Cost | Final Invoice |  |  |  |  |  |  |  | Running Cost | Final Invoice |  |  |  |  |  |  |  |  |  |  |  | Running Cost | Final Invoice |  |  |  |  |  |  |  |  |  |  |  | Running Cost | Final Invoice | Legend
Code |  | Description | QUOTE |  | QUOTE |  | QUOTE |  | QUOTE |  | QUOTE |  | QUOTE | QUOTE |  |  | Qty | Qty | Qty | Qty | Qty | Qty | Qty |  | COST | DISCOUNT | COST | DISCOUNT | COST | DISCOUNT | COST | DISCOUNT | COST | DISCOUNT | COST | COST |  |  | DISCOUNT |  | DISCOUNT |  | DISCOUNT |  | DISCOUNT |  | DISCOUNT | USD | USD |  | Price not given - Estimate as per highest cost
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | Quantity not given - Estimated quantity
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | Attention Required
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | Automatic formula
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | Comments
2.01 |  | Disposal of Tank Contents
 | a | Mud per tonne
 | b | Oil per tonne
 |  | Sludge per tonne
 | c | Water per m³
 | d | Oily water per m³
 |  | [NAME]
 |  | Click to add Job Line
 |  | Click to add New Job
2.01 | T | TOTAL
2.02 |  | Tank Access
 | a | Removal & refitting of manhole doors
 |  | [NAME]
 |  | Click to add Job Line
 |  | Click to add New Job
2.02 | T | TOTAL
2.03 |  | Tank Cleaning
 | a | Cargo tank per m³
 | b | Fuel oil tank per m³
 |  | Diesel oil tank per m³
 | c | Ballast tank per m³
 | d | Pump room per m³
 | e | ER void space / tank tops per m³
 | f | Waste oil tanks per m³
 | g | [NAME] tanks per m³
 |  | [NAME]
 |  | Click to add Job Line
 |  | Click to add New Job
2.03 | T | TOTAL
2.04 |  | Labour Costs
 | a | Tank digging per man hour
 |  | [NAME]
 |  | Click to add Job Line
 |  | Click to add New Job
2.04 | T | TOTAL
 |  | Total for code 02
Spreadsheet: 105098d1302558414-identifying-number-associated-with-most-recent-unique-id-sample-worksheet
Sheet: Sheet1

Unique ID | Activities | Total Number of Activities
JANUARY
1 | 1
2 | 1
3 | 1
4 | 1
FEBRUARY
1 | 1
2 | 1
3 | 1
4 | 1
5 | 1
6 | 1
7 | 1
[NAME]
1 | 1
2 | 1
3 | 1
4 | 1
7 | 1
8 | 1
9 | 1
Spreadsheet: 95370d1294954733-dynamic-data-validation-and-the-indirect-function-data-validation-indirect-function
Sheet: Abstract Team Tasks

 | [NAME] | No of Records | To Current Tasks | BACK TO Rollup-------------------------------------------------------------------------------------->
 | Ident | ID | Team | Action | Owner | Suspense | Notes | Andon | Updated
Spreadsheet: 221598d1363622090-filter-using-drop-down-list-test-for-forum-18-mar-2013
Sheet: Sheet1

Name | Laval | Y | N | Y
Name | Area | Night | Day | Summer |  |  | My drop down lists are there, I want to be able to choose from my list and have my table filter accordingly.
[NAME] | Laval | Y | N | Y
[NAME] | Arundel | Y | Y | N |  |  | If anyone could help it would be greatly appreciated.
[NAME] | Laval | N | N | N
[NAME] | Rosemere | N | N | Y