tianzl66/Sheetpedia huggingface dataset:
Spreadsheet: 794197d1661940520-multiple-closest-matches-with-multiple-criteria-book1-tool_fairy-
Sheet: Summary

Current - With [NAME]
Name | Bk1 Rot | Bk1 Act | Bk1 Dif | Bk1 [NAME] | [NAME] | Lun Act | Lun Dif | [NAME] | Bk2 Rot | Bk2 Act | Bk2 Dif | Bk2 [NAME]
Staff 1
Staff 2
Staff 3
Staff 4
Staff 5
Staff 6
Staff 7
Staff 8
Staff 9
Staff 10
Staff 11
Staff 12
Expected - No formulas
Name | Bk1 Rot | Bk1 Act | Bk1 Dif | Bk1 [NAME] | [NAME] | Lun Act | Lun Dif | [NAME] | Bk2 Rot | Bk2 Act | Bk2 Dif | Bk2 [NAME]
Staff 1 | 11:15:00 | 11:47:00 | 32 | 9.999999999999964 | 13:15:00 | 13:38:00 | 23 | 30 | 15:15:00 | 15:35:00 | 20 | 9.999999999999964
Staff 2 | 10:15:00 | 10:20:00 | 5 | 9.999999999999964 | 12:15:00 | 12:13:00 | -2 | 30 | 14:15:00 | 14:30:00 | 15 | 9.999999999999964
Staff 3 | 11:00:00 | 11:02:00 | 2 | 10.99999999999996 | 13:15:00 | 13:17:00 | 2 | 30 | 15:00:00 | 15:04:00 | 4 | 10.00000000000012
Staff 4 | 10:00:00 | 10:14:00 | 14 | 9.999999999999964 | 11:45:00 | 11:59:00 | 14 | 33 | 13:45:00 | 13:51:00 | 6 | 7.999999999999972
Staff 5 | 12:00:00 | 12:03:00 | 3 | 9.999999999999964 | 13:45:00 | 13:55:00 | 10 | 30 | 16:00:00 | 16:12:00 | 12 | 8.999999999999968
Staff 6 | - | - | - | - | - | - | - | - | - | - | - | -
Staff 7 | 11:30:00 | 11:18:00 | -12 | 10 | 14:00:00 | 13:55:00 | -5 | 30 | 15:30:00 | 15:24:00 | -6 | 9.999999999999964
Staff 8 | 10:15:00 | 10:17:00 | 2 | 9.999999999999964 | 12:15:00 | 11:33:00 | -42 | 30 | 14:15:00 | 14:12:00 | -3 | 9.999999999999964
Staff 9 | - | - | - | - | - | - | - | - | - | - | - | -
Staff 10 | 12:00:00 | 12:00:00 | 0 | 9.999999999999964 | 13:45:00 | 13:42:00 | -3 | 29 | 16:00:00 | 16:09:00 | 9 | 8.999999999999968
Staff 11 | 10:45:00 | 10:48:00 | 3 | 11.00000000000004 | 13:00:00 | 13:05:00 | 5 | 30 | 15:15:00 | 15:38:00 | 23 | 9.999999999999964
Staff 12 | - | - | - | - | - | - | - | - | - | - | - | -
Spreadsheet: 48a55c27-e981-436f-8a8a-b3491e11b179
Sheet: Sheet1

Battle ID | Date & Time | Side | Victory | Score | Opp. Score | Opp. ID | Opp. Name | Scenario ID | Front | Start Date | End Date | Name EN | Name FR
42209957 | 2014-07-08 06:16:51 | AXIS | 1 | 5 | 2 | 1581268 | Dain Ironfoot | 6148 | western | 1944-07-25 | 1944-07-26 | Operation Cobra | Opération Cobra
42210104 | 2014-07-08 06:36:13 | ALLIES | 0 | 1 | 5 | 1581268 | Dain Ironfoot | 6148 | western | 1944-07-25 | 1944-07-26 | Operation Cobra | Opération Cobra
42361331 | 2014-07-19 06:23:59 | AXIS | 1 | 7 | 5 | 30486 | [NAME] | 7668 | pacific | 1945-02-26 | 1945-03-06 | The Meat Grinder | Le Hachoir à viande
42361476 | 2014-07-19 06:44:40 | ALLIES | 0 | 4 | 7 | 30486 | [NAME] | 7668 | pacific | 1945-02-26 | 1945-03-06 | The Meat Grinder | Le Hachoir à viande
Spreadsheet: phillip_m_love__30259__OntFRED
Sheet: Summary

Financial Liquidation Variance Summary
PRODUCTION MONTH:  6/00
DESK: Ontario
 |  |  |  |  | To be updated by Economic & Gas Acctng:
 | per OA reports |  | per [NAME] | var |  | Remaining | expl
NGP&L LIQUIDATIONS | -1627381 |  |  |  | Resolved Amount | To Be Resolved
Less:
Diff. between OA flash and details; (Unidentified) | 0 |  |  |  | 0
Discrepancies between Actuals & Flash | -971020.858 |  |  |  | 0
In Actuals, not [NAME] (unexplained) | -374721.1018 |  |  |  | 0
Not TAGG related:Reclass inv profits to storage reconciliation
Restated NGP&L
GL LIQUIDATIONS
Less:
Direct offset in Central & Ontario FL & GL, need reclass of value | 3361859.5696 |  |  |  | 0
In Central FL, [NAME], change mapping | -72500 |  |  |  | 0
In FL not GL, Acct to look at | 921034.6888 |  |  |  | 0
In [NAME], Central GL, change mapping | 1226261.3659 |  |  |  | 0
 | 0
Discrepancies between Actuals & Flash
[NAME]
GL Adjustments | 0
In [NAME], not Actuals (unexplained) | 0
Not TAGG related:Unknown entry in OA report
Restated Actuals
[NAME]
unexplained
Spreadsheet: 871301d1717679952-removing-zeros-from-blank-cells-in-filter-formula-test-179-aligw
Sheet: Sheet1

February
2024-02-05 00:00:00 | 2024-02-06 00:00:00 | G20 - 1st Education Working Group Meeting
2024-02-12 00:00:00 | 2024-02-14 00:00:00 | World Government Summit | Shaping Future Governments (Theme 4: Future Societies and Education)
2024-02-15 00:00:00 |  | VVOB Education for Development | School Leadership Matters: Promoting Effective School Leadership in Africa
2024-02-26 00:00:00 | 2024-02-29 00:00:00 | 14th International Policy Dialogue Forum on Teachers | Addressing global teacher shortages: Dignifying, diversifying, and valorizing the profession
2024-02-26 00:00:00 |  | 14th International Policy Dialogue Forum on Teachers - EVENT | 2024/5 GEM Report consultation empowering teacher leadership
2024-02-27 00:00:00 |  | 14th International Policy Dialogue Forum on Teachers - EVENT | 2024 SDG 4 Scorecard and trained teachers: mapping progress and data challenges
2024-02-28 00:00:00 |  | 14th International Policy Dialogue Forum on Teachers - EVENT | Towards education for all: Strengthening data systems in conflict and crisis settings
Spreadsheet: 153005d1335687896-excel-2007-count-how-many-a-value-occurs-with-given-set-of-criteria-book1_heartbreak_one
Sheet: Sheet1

ITEM | qty | Running Count of ITEMS
[NAME] | 10
hammer | 15
hammer | 5
flow | 20
disc brake | 15
flow | 5
flow | 20
Spreadsheet: 187596d1350519336-complicated-look-up-without-making-changes-to-the-values-in-the-table-complicated-look-up
Sheet: Sheet1

Type A | Type B | Result |  | Correct Result
CustomVue Key Cards | 1 Procedure |  |  | [NAME]
 | 10 Procedures |  |  | [NAME]
Standard Key Cards | 10 Procedures |  |  | [NAME]
[NAME] | ZCT100 |  |  | [NAME]
 | ZCT150 |  |  | [NAME] |  | LOOK UP TABLE
 | ZCT225 |  |  | [NAME]
 | ZCT300 |  |  | [NAME] |  | Type A | Type B | RESULT
 | ZCT400 |  |  | [NAME] |  | Standard Key Cards | 10 Procedures | STANDARD LASIK
[NAME] | ZMA00 |  |  | TECNIS MF 3PC (ACR) |  | CustomVue Key Cards | 1 Procedure | CUSTOM VUE
 | [NAME] |  |  | TECNIS MF 1 PC (ACR) |  | CustomVue Key Cards | 10 Procedures | CUSTOM VUE
 |  |  |  |  |  | [NAME] | ZCT100 | [NAME]
 |  |  |  |  |  | [NAME] | ZCT150 | [NAME]
 |  |  |  |  |  | [NAME] | ZCT225 | [NAME]
 |  |  |  |  |  | [NAME] | ZCT300 | [NAME]
 |  |  |  |  |  | [NAME] | ZCT400 | [NAME]
 |  |  |  |  |  | [NAME] | ZMA00 | TECNIS MF 3PC (ACR)
 |  |  |  |  |  | [NAME] | [NAME] | TECNIS MF 1 PC (ACR)
 |  | [NAME] to look up values in column A and B
 |  | from look Table column G & H and derive result from
 |  | column I.
 |  | Please note, no change to be made to the structure of
 |  | column A. Blan cells should remain as it is.
Spreadsheet: 777241d1650275108-formula-to-find-repeating-number-patterns-within-single-cells-book1
Sheet: Sheet1

Service Type | Prefix | Number Length | From | To | Status | Quantity
Special | 1500 | 10 | 1500007007 | 1500007007 | Okay | 1
Special | 1500 | 10 | 1500007009 | 1500007012 | Okay | 4
Special | 1500 | 10 | 1500007013 | 1500007013 | Okay | 1
Special | 1500 | 10 | 1500007014 | 1500007021 | Okay | 8
Special | 1500 | 10 | 1500007023 | 1500007032 | Okay | 10
Special | 1500 | 10 | 1500393392 | 1500393394 | Okay | 3
Special | 1500 | 10 | 1500007089 | 1500007099 | Okay | 11
Special | 1500 | 10 | 1500007116 | 1500007116 | Okay | 1
Special | 1500 | 10 | 1500007119 | 1500007119 | Okay | 1
Special | 1500 | 10 | 1500437124 | 1500437124 | Okay | 1
Special | 1500 | 10 | 1500007127 | 1500007128 | Okay | 2
Special | 1500 | 10 | 1500007132 | 1500007133 | Okay | 2
Special | 1500 | 10 | 1500007135 | 1500007135 | Okay | 1
Special | 1500 | 10 | 1500007137 | 1500007139 | Okay | 3
Special | 1500 | 10 | 1500007142 | 1500007143 | Okay | 2
Special | 1500 | 10 | 1500007145 | 1500007145 | Okay | 1
Special | 1500 | 10 | 1500007146 | 1500007146 | Okay | 1
Special | 1500 | 10 | 1500007149 | 1500007149 | Okay | 1
Spreadsheet: 678507d1589920292-count-numbers-by-a-set-of-words-that-are-delimited-memory-calcs
Sheet: Sheet1

Memory | Memory | Should be
4GB 2133 MHz|4GB 2133 MHz |  | 8GB
2GB 1333 MHz|2[NAME] 1333 MHz|2[NAME] 1333 MHz|2[NAME] 1333 MHz |  | 8GB
4GB 2133 MHz
4GB 1600 MHz
8GB 2400 MHz
0GB 0 MHz|1GB 667 MHz|0GB 667 MHz|1GB 667 MHz|1GB 800 MHz |  | 3GB
0GB 0 MHz|1GB 667 MHz|1GB 667 MHz |  | 2GB
2GB 800 MHz|2GB 800 MHz |  | 4GB
8GB 2400 MHz
TEXT TO COLUMNS Using Other: |  |  |  |  |  |  |  |  |  | SUM
4GB 2133 MHz | 4GB 2133 MHz
2GB 1333 MHz | 2GB 1333 MHz | 2GB 1333 MHz | 2GB 1333 MHz
4GB 2133 MHz
4GB 1600 MHz
8GB 2400 MHz
0GB 0 MHz | 1GB 667 MHz | 0GB 667 MHz | 1GB 667 MHz | 1GB 800 MHz
0GB 0 MHz | 1GB 667 MHz | 1GB 667 MHz
2GB 800 MHz | 2GB 800 MHz
8GB 2400 MHz
Spreadsheet: 4eafe385-6fcd-46d6-8915-de1a96a3739d
Sheet: Sheet1

Date | Sport | Opponent | Time_Results
11/14/2009 | Wrestling | at Washington & Jefferson College Open | NTS (5 champions)
11/21/2009 | Wrestling | Navy Classic | Result
11/22/2009 | Wrestling | vs. Wyoming (Vestal, N.Y.) | L, 18-19
11/22/2009 | Wrestling | vs. Illinois (Vestal, N.Y.) | L, 15-23
12/04/2009 | Wrestling | at Cliff [NAME] Vegas Invitational | 28th Place
12/11/2009 | Wrestling | PENN STATE | L, 12-33
12/20/2009 | Wrestling | at Reno Tournament of Champions | 12th Place
01/02/2010 | Wrestling | INDIANA | L, 9-29
01/09/2010 | Wrestling | at Michigan State | L, 9-24
[NAME] | Wrestling | at Lehigh | L, 3-39
01/22/2010 | Wrestling | CLARION | L, 14-20
01/24/2010 | Wrestling | BLOOMSBURG | W, 21-18
01/31/2010 | Wrestling | LOCK HAVEN | W, 32-12
02/09/2010 | Wrestling | PITT | L, 15-19
02/14/2010 | Wrestling | at Ohio (Saint Clairsville, Ohio) | L, 15-27
02/19/2010 | Wrestling | at Cleveland State | W, 34-11
02/20/2010 | Wrestling | at Edinboro | L, 6-29
[NAME] | Wrestling | EWL Championships (Morgantown, W.Va.) | 5th Place
03/18/2010 | Wrestling | at NCAA Championships (Omaha, Neb.) | TBD
03/19/2010 | Wrestling | at NCAA Championships (Omaha, Neb.) | TBD
03/20/2010 | Wrestling | at NCAA Championships (Omaha, Neb.) | 47th Place
Spreadsheet: 681829d1591777644-sum-calculation-displays-value-sales-2020
Sheet: Sheet3

Code | Merchant |  |  |  | Boxes | Date |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | WT | [NAME]
WL |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | WC | [NAME]
Vessel | Species | Presentation | Grade | Number of Boxes | [NAME] | Unit Price | Total Value |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | HD | [NAME]
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | JPL | JPL Shellfish
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | BL | Bells Seafood
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | PWELL | Pierowall Fish
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | ICEW | [NAME]
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | WL | Whitelink Seafoods
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | CS | Caithness Smoke House
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | OT | Fish In Crieff
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | CPM | Campbells Prime Meat
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | [NAME] | Captains Galley
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | NS | Norscot Seafoods
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | KB | Kirkwall Bay Shellfish
Spreadsheet: 699126d1602425531-sumif-according-to-value-within-interval-date-sum-ifs
Sheet: Folha1

 | [NAME]
 | DAY | TIPO PROCESSO | Processos feitos
Setembro | 2020-09-07 00:00:00 | OPEN CLIENT | 10
 | 2020-09-08 00:00:00 | OPEN CLIENT | 19
 | 2020-09-11 00:00:00 | OPEN CLIENT | 29
 | 2020-09-23 00:00:00 | OPEN CLIENT | 20
 | 2020-09-24 00:00:00 | OPEN CLIENT | 10
 | 2020-09-25 00:00:00 | PROCESSES | 20
 | 2020-09-28 00:00:00 | PROCESSES | 29 |  | RELATÓRIO
 | 2020-10-01 00:00:00 | OPEN CLIENT | 8
 | 2020-10-02 00:00:00 | OPEN CLIENT | 4 |  | START DATE |  | END DATE
 | 2020-10-05 00:00:00 | PROCESSES | 15
 | 2020-10-10 00:00:00 | OPEN CLIENT | 4
 | 2020-10-10 00:00:00 | OPEN CLIENT | 1 |  |  | OPEN CLIENT |  |  |  |  | ROW START
 | 2020-10-11 00:00:00 | OPEN CLIENT | 1 |  |  | PROCESSES |  |  |  |  | ROW END:
 | 2020-10-11 00:00:00 | PROCESSES | 1
 |  |  |  |  |  | HOW DO I SUM IF ACCORDING TO START AND END DATE
Spreadsheet: 754634d1636393397-writing-ifs-formula-looking-in-different-columns-to-return-text-example-workbook
Sheet: Sheet1

Accounts | Status | Current Units | Kickoff email | Assesssment call | Cust call | Deployment call | Order(s) placed
Account 1 |  | 30 | Done | Scheduled
Account 2 |  | 60 | Done | Done | Scheduled
Account 3 |  | 45 | Done | Done | Done | Scheduled
Account 4 |  | 60 | Done | Done | Done | Done
Account 5 |  | 67.5 | Done | Done | Done | Done | Scheduled
 |  |  | Done | Scheduled | blank | blank | blank | In Assessment
 |  |  | Done | Done | Scheduled | blank | blank | Plan Drafted
 |  |  | Done | Done | Done | Scheduled | blank | Customer contacted
 |  |  | Done | Done | Done | Done | blank | Set start end date
 |  |  | Done | Done | Done | Done | Scheduled | In Execution
 |  |  | Scheduled | Not Blank
 |  |  | Scheduled | or Blank
Spreadsheet: 152960d1335638955-formula-for-calculating-variable-one-time-vs-recurring-commissions-weekly-sales-projection-commission-and-profit
Sheet: Sheet1

Service Charge |  |  |  | Commission
1Time Fee | 2000 |  |  | Month 1 | Month 2 | Month 3 | Month 4+
Monthly | 1000 |  |  | 0.6 | 0.45 | 0.3 | 0.2
Week # | # Sales | Net/Wk | Week # | # Sales | Net/Wk | Week # | # Sales | Net/Wk | Week # | # Sales | Net/Wk
Week 1 | 5 |  | Week 14 | 5 |  | Week 27 | 5 |  | Week 40 | 5
Week 2 | 5 |  | Week 15 | 5 |  | Week 28 | 5 |  | Week 41 | 5
Week 3 | 5 |  | Week 16 | 5 |  | Week 29 | 5 |  | Week 42 | 5
Week 4 | 5 |  | Week 17 | 5 |  | Week 30 | 5 |  | Week 43 | 5
Week 5 | 5 |  | Week 18 | 5 |  | Week 31 | 5 |  | Week 44 | 5
Week 6 | 5 |  | Week 19 | 5 |  | Week 32 | 5 |  | Week 45 | 5
Week 7 | 5 |  | Week 20 | 5 |  | Week 33 | 5 |  | Week 46 | 5
Week 8 | 5 |  | Week 21 | 5 |  | Week 34 | 5 |  | Week 47 | 5
Week 9 | 5 |  | Week 22 | 5 |  | Week 35 | 5 |  | Week 48 | 5
Week 10 | 5 |  | Week 23 | 5 |  | Week 36 | 5 |  | Week 49 | 5
Week 11 | 5 |  | Week 24 | 5 |  | Week 37 | 5 |  | Week 50 | 5
Week 12 | 5 |  | Week 25 | 5 |  | Week 38 | 5 |  | Week 51 | 5
Week 13 | 5 |  | Week 26 | 5 |  | Week 39 | 5 |  | Week 52 | 5
Month 1 |  |  | Month 4 |  |  | Month 7 |  |  | Month 10
Month 2 |  |  | Month 5 |  |  | Month 8 |  |  | Month 11
Month 3 |  |  | Month 6 |  |  | Month 9 |  |  | Month 12
Quarter 1 |  |  | Quarter 2 |  |  | Quarter 3 |  |  | Quarter 4
Spreadsheet: 65374d1266054961-items-warehouses-book17
Sheet: Sheet1

 | Item1 | Item2 | Item3 | Item4 | Item5 | Item6 | Item7 | Item8 | Item9 | Item10 | Item11 | Item12 | Item13 | Item14 | Item15
Warehouse1 |  |  |  | X |  |  |  | X |  |  |  | X
Warehouse2 |  | X |  |  |  |  |  | X |  |  |  |  |  | X | X
Warehouse3 |  |  |  | X |  | X | X |  |  |  |  | X
Warehouse4 |  | X | X |  |  |  |  |  |  |  |  |  |  | X
Warehouse5 |  |  |  |  |  |  |  |  |  | X |  | X
Warehouse6 | X |  | X |  |  |  |  |  |  |  | X
Warehouse7 |  |  | X |  | X | X |  |  |  | X |  |  | X | X
Warehouse8 |  |  | X |  | X | X |  |  |  | X |  | X
Warehouse9 |  |  |  |  |  |  |  |  | X |  | X
Warehouse10 | X |  |  |  |  | X | X | X |  |  |  | X
Warehouse11 |  | X |  |  |  |  |  | X |  |  |  |  |  | X
Warehouse12 | X |  |  |  | X |  |  |  |  | X
Warehouse13 |  | X |  |  |  |  |  |  |  |  |  |  | X | X
Warehouse14 |  | X |  |  | X |  |  |  |  |  |  |  | X
Warehouse15
Warehouse16 |  |  | X | X |  |  |  |  | X |  |  | X
Warehouse17 | X |  |  |  | X |  |  |  |  |  |  |  | X | X
Warehouse18 |  |  |  |  |  |  |  |  |  | X | X |  |  | X | X
Warehouse19 |  | X |  |  |  |  |  |  |  | X | X | X
Warehouse20 |  |  | X |  | X |  |  | X
Warehouse21 |  |  |  |  |  |  |  |  | X |  |  |  | X
Warehouse22 |  |  |  |  | X |  |  | X |  |  |  | X | X | X
Warehouse23 |  |  |  |  |  |  | X |  |  |  | X | X | X | X
Warehouse24 | X |  | X |  | X |  | X |  |  |  | X |  | X
Warehouse25 | X | X | X |  |  |  |  |  |  |  |  |  |  | X
Warehouse26 | X |  | X | X | X | X
Warehouse27 | X | X | X |  |  |  |  |  | X | X |  |  |  | X
Warehouse28 |  |  |  |  |  | X |  | X |  |  |  | X
Warehouse29 |  |  |  |  |  |  | X |  |  | X
Warehouse30 |  |  | X |  |  |  |  | X |  |  | X |  | X
Spreadsheet: 853766d1703733485-combine-data-from-different-source-combine
Sheet: Combine

Prod_Index | Age_Year | Pocket | Ctry | Code_TX |  |  |  |  |  |  |  | Age_Year | Pocket | Ctry | Code_TX
#1 | 2.1 | A | SG | AxD_7611 |  | *Data come from Data1 and Data2 |  |  |  |  | #1 | 2.1 | A | SG | AxD_7611
#2 | 3.5 | A | CHN | AxD_7611 |  |  |  |  |  |  | #2 | 3.5 | A | CHN | AxD_7611
#3 | 3.9 | B |  | [NAME] |  |  |  |  |  |  | #3 | 3.9 | B |  | [NAME]
#4 | 1.5 | A |  | [NAME] |  |  |  |  |  |  | #4 | 1.5 | A |  | [NAME]
#5 |  | C | CHN |  |  |  |  |  |  |  | #5 |  | C | CHN
#6 |  | C | TW |  |  |  |  |  |  |  | #6 |  | C | TW
#7 |  | B | CHN |  |  |  |  |  |  |  | #7 |  | B | CHN
#8 | 8.3 | G |  | Gj_110 |  |  |  |  |  |  | #8 | 8.3 | G |  | Gj_110
Spreadsheet: 43570d1242218867-converting-excel-file-to-xml-clsclients
Sheet: Sheet1

CustID | FirstName | LastName | Sex | Age | Address1 | Address2 | Address3
1 | [NAME] | Smith | M | 21 | 12 | [NAME] | Bristol
2 | [NAME] | [NAME] | M | 32 | 13 | Park Place | Cardiff
3 | [NAME] | Mitchell | F | 43 | 45 | [NAME] | London
4 | [NAME] | Stone | F | 66 | 67 | [NAME] | Reading
5 | Francine | Jones | F | 53 | 78 | Tree Hill | Belfast
6 | Becky | Painter | F | 25 | 98 | [NAME] Street | [NAME]
7 | [NAME] | Perkins | M | 21 | 90 | Grange Street | Birmingham
8 | [NAME] | Shaw | M | 21 | 43 | The Haven | Hull
9 | Gertrude | [NAME] | F | 91 | 42 | [NAME] | London
10 | [NAME] | [NAME] | F | 21 | 12 | Richland Terrace | Bristol
CustID | 1 | 2 | 3 | 4 | 5 | 6 | 7 | 8 | 9
FirstName | [NAME] | [NAME] | Etc.
LastName | Smith | [NAME] | Etc.
Sex | M | M | Etc.
Age | Etc.
Address1 | Etc.
Address2 | Etc.
Address3 | Etc.
Spreadsheet: 26716d1219124418-regarding-index-and-match-function-problem-index-match2
Sheet: Sheet1

Date | Ref No | Impression | Profiles
2008-08-15 00:00:00 | 100 | 5414 | 20
2008-08-15 00:00:00 | 101 | 7541 | 34
2008-08-16 00:00:00 | 102 | 6514 | 84
2008-08-15 00:00:00 | 102 | 5214 | #N/A
Spreadsheet: 724546d1616227358-countif-matrix-test-countif-matrix-test
Sheet: Example 9x9 

 |  |  |  |  |  |  |  |  | 3 | 6 | 1 | 6 | 2 | 1 | 1 | 9 | 4 | 1 | 2 | 8 | 6 | 1 | 8 | 3 |  |  | 1 |  | 1
 |  |  |  |  |  |  |  |  | 2 | 9 | 7 | 3 | 4 | 7 | 5 | 8 | 2 | 3 | 8 | 7 | 3 | 5 | 8 | 4 |  |  | 2 |  | 0
 |  |  |  |  |  |  |  |  | 7 | 9 | 6 | 1 | 9 | 1 | 4 | 6 | 6 | 4 | 3 | 4 | 8 | 5 | 1 | 9 |  |  | 3 |  | 2
 |  |  | 9 |  |  |  |  |  | 4 | 1 | 2 | 8 | 7 | 6 | 1 | 4 | 3 | 1 | 3 | 6 | 5 | 4 | 1 | 4 |  |  | 4 |  | 2
 |  |  |  |  |  |  |  |  | 2 | 3 | 5 | 7 | 3 | 4 | 1 | 6 | 3 | 5 | 7 | 3 | 9 | 3 | 8 | 8 |  |  | 5 |  | 1
 |  |  |  |  |  |  |  |  | 1 | 2 | 4 | 7 | 1 | 6 | 3 | 9 | 1 | 6 | 2 | 9 | 8 | 3 | 2 | 4 |  |  | 6 |  | 1
 |  |  |  |  |  |  |  |  | 6 | 3 | 5 | 8 | 4 | 6 | 9 | 1 | 7 | 8 | 5 | 8 | 5 | 2 | 5 | 2 |  |  | 7 |  | 1
 |  |  |  |  |  |  |  |  | 5 | 8 | 6 | 2 | 4 | 6 | 7 | 9 | 3 | 8 | 4 | 9 | 7 | 8 | 4 | 2 |  |  | 8 |  | 0
 |  |  |  |  |  |  |  |  | 2 | 1 | 5 | 7 | 7 | 1 | 2 | 6 | 5 | 5 | 7 | 1 | 6 | 1 | 6 | 9 |  |  | 9 |  | 0
5 | 6 | 4 | 7 | 9 | 1 | 3 | 3 | 4
9 | 4 | 4 | 1 | 5 | 5 | 1 | 2 | 4
5 | 4 | 4 | 7 | 1 | 4 | 8 | 6 | 6
2 | 6 | 4 | 6 | 7 | 6 | 5 | 5 | 8
1 | 2 | 5 | 4 | 8 | 7 | 6 | 3 | 9
9 | 8 | 8 | 7 | 7 | 6 | 4 | 5 | 4
4 | 4 | 7 | 6 | 9 | 1 | 3 | 5 | 6
3 | 7 | 2 | 3 | 5 | 8 | 7 | 9 | 8
6 | 6 | 1 | 1 | 9 | 2 | 7 | 5 | 5
6 | 5 | 5 | 5 | 2 | 2 | 5 | 5 | 6
7 | 3 | 1 | 5 | 1 | 3 | 1 | 3 | 1
5 | 1 | 1 | 7 | 9 | 6 | 7 | 6 | 3
4 | 3 | 6 | 9 | 9 | 1 | 7 | 2 | 1
3 | 6 | 7 | 4 | 8 | 7 | 8 | 3 | 5
5 | 8 | 2 | 7 | 9 | 7 | 1 | 3 | 1
1 | 6 | 7 | 6 | 3 | 1 | 8 | 4 | 4
Spreadsheet: 117355d1312713309-excel-2008-almost-solved-vlookup-offset-match-and-countif-copy-of-student-records-and-database
Sheet: Member & Leader Lists

Membership Name | Title | First Name | Last Name | Membership No
 | Mr | [NAME] | [NAME] | 545
 | Mr | [NAME] | Ajob | 5454
 | Miss | Charlotte | Henroit | 567
 | Mr | [NAME] | Richman | 54
 | Mr | [NAME] | Saying | 21568
 | Mrs | [NAME] | Silverton | 964
 | Mrs | [NAME] | Witchman | 6548
 | Mr | Eamon | Nolan | 567
 | Mr | Geoff | Percival | 65
 | Ms | Gillian | Atkins | 689
 | Mrs | Helen | Goldstein | 56785
 | Miss | Jeanette | [NAME] | 659
 | Mrs | Julie | Edwards | 154247
 | Miss | [NAME] | [NAME] | 1564
 | Miss | [NAME] | Willis | 55555
 | Mr | [NAME] | Ithard | 5879
 | Mr | [NAME] | [NAME] | 247
 | Mr | [NAME] | Western | 4524
 | Ms | Rebecca | National | 258
 | Mr | [NAME] | Constanine | 16584
 | Mr | [NAME] | Nutbush | 657
 | Ms | Rose | Royce | 657
 | Mr | [NAME] | Carlton | 265
 | Ms | Tara | Scott | 264
 | Mrs | Thersa | Green | 5455
 | Ms | [NAME] | Hanratty | 2581
Leader No | Leader [NAME] | First Name | Last Name | Membership No.
No 0891-456 |  | [NAME] | [NAME] | 545
No 0891-457 |  | [NAME] | Richman | 54
No 0891-458 |  | [NAME] | Silverton | 264
No 0891-459 |  | [NAME] | Nutbush | 657
No 0891-460 |  | [NAME] | Carlton | 265
Spreadsheet: cd1b0c8c-fe58-44d0-a672-76fecc253c19
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
17BFP | Test | 17BFP | Fluticasone 17-Beta-Carboxylic Acid, [NAME] | Fluticasone 17-B Carboxylic Acid, U | Liquid Chromatography-Tandem Mass Spectrometry (LC-MS/MS) |  |  |  | 5 | mL | Collection Container/Tube: Clean, plastic urine collection container Submission Container/Tube: Plastic, 10-mL urine tube (Supply T068) [NAME]: 5 mL Collection Instructions: 1. Collect a random urine specimen. 2. No preservative. | 0.6 mL | Hemolysis	NA Thawing	Warm OK; Cold OK Lipemia	NA Icterus	NA Other	NA | Negative Cutoff concentration: 10 pg/mL  Values for normal patients not taking fluticasone propionate should be less than the cutoff concentration (detection limit). | Tuesday; 11 a.m. | 2 days | 8 days | 1 | 83789 |  |  |  |  | Rochester
17BFP | [NAME] | URINE | [NAME] |  |  |  | Frozen | 14 days
17BFP | Result | 89739 | Fluticasone 17-B Carboxylic Acid, U | Fluticasone 17-B Carboxylic Acid, U | Numeric |  |  |  |  | pg/mL |  |  |  |  |  |  |  |  |  | 46952-8 | Fluticasone propionate:MCnc:Pt:[NAME]:Qn: