tianzl66/Sheetpedia huggingface dataset:
Spreadsheet: 130c354a-0924-4693-96ff-51b700b18ac5
Sheet: Calculator

 |  | HP | Atk | Def | SpA | SpD | Spe |  | SF | BST |  | PT | ST | PS | SS |  | BSR
 | 1 | 1 | 1 | 1 | 1 | 1 | 1 |  |  |  |  |  |  |  |  |  |  |  | PT / ST / PS / SS Range | Description
 | 2 | 1 | 1 | 1 | 1 | 1 | 1 |  |  |  |  |  |  |  |  |  |  |  | x < 25 | Horrible
 | 3 | 1 | 1 | 1 | 1 | 1 | 1 |  |  |  |  |  |  |  |  |  |  |  | 25 < x < 50 | Bad
 | 4 | 1 | 1 | 1 | 1 | 1 | 1 |  |  |  |  |  |  |  |  |  |  |  | 50 < x < 75 | Poor
 | 5 | 1 | 1 | 1 | 1 | 1 | 1 |  |  |  |  |  |  |  |  |  |  |  | 75 < x < 100 | Below Average
 | 6 | 1 | 1 | 1 | 1 | 1 | 1 |  |  |  |  |  |  |  |  |  |  |  | 100 < x < 125 | Above Average
 | 7 | 1 | 1 | 1 | 1 | 1 | 1 |  |  |  |  |  |  |  |  |  |  |  | 125 < x < 150 | Good
 | 8 | 1 | 1 | 1 | 1 | 1 | 1 |  |  |  |  |  |  |  |  |  |  |  | 150 < x < 175 | Very Good
 | 9 | 1 | 1 | 1 | 1 | 1 | 1 |  |  |  |  |  |  |  |  |  |  |  | 175 < x < 200 | Excellent
 | 10 | 1 | 1 | 1 | 1 | 1 | 1 |  |  |  |  |  |  |  |  |  |  |  | 200 < x < 225 | Fantastic
 | 11 | 1 | 1 | 1 | 1 | 1 | 1 |  |  |  |  |  |  |  |  |  |  |  | 225 < x | Amazing
 | 12 | 1 | 1 | 1 | 1 | 1 | 1
 | 13 | 1 | 1 | 1 | 1 | 1 | 1 |  |  |  |  |  |  |  |  |  |  |  | BSR Range | Description
 | 14 | 1 | 1 | 1 | 1 | 1 | 1 |  |  |  |  |  |  |  |  |  |  |  | x < 50 | Horrible
 | 15 | 1 | 1 | 1 | 1 | 1 | 1 |  |  |  |  |  |  |  |  |  |  |  | 50 < x < 100 | Bad
 | 16 | 1 | 1 | 1 | 1 | 1 | 1 |  |  |  |  |  |  |  |  |  |  |  | 100 < x < 150 | Poor
 | 17 | 1 | 1 | 1 | 1 | 1 | 1 |  |  |  |  |  |  |  |  |  |  |  | 150 < x < 200 | Below Average
 | 18 | 1 | 1 | 1 | 1 | 1 | 1 |  |  |  |  |  |  |  |  |  |  |  | 200 < x < 250 | Above Average
 | 19 | 1 | 1 | 1 | 1 | 1 | 1 |  |  |  |  |  |  |  |  |  |  |  | 250 < x < 300 | Good
 | 20 | 1 | 1 | 1 | 1 | 1 | 1 |  |  |  |  |  |  |  |  |  |  |  | 300 < x < 350 | Very Good
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 350 < x < 400 | Excellent
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 400 < x < 450 | Fantastic
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 450 < x | Amazing
Spreadsheet: 148396d1333386915-creating-a-report-to-show-vehicle-tax-due-tax-disc-log
Sheet: CU03 BXL

 |  |  |  |  | CU03 BXL
Registration number : | CU03 BXL |  | Date Taxed | Duration | Tax Expiry  Date | Cost (£)
Manufacturer : | SCANIA |  | 2003-05-12 00:00:00 | 12 Months + 2 Weeks | 2004-06-01 00:00:00 | 1245
Specification : | 6 x 2 A |  | 2004-05-28 00:00:00 | 12 Months | 2005-06-01 00:00:00 | 1200
Type : | RT124 LA 6x2/4NA420 |  | 2005-05-31 00:00:00 | 12 Months | 2006-06-01 00:00:00 | 1200
1st Registered : | 12.05.03 |  | 2006-05-31 00:00:00 | 12 Months | 2007-06-01 00:00:00 | 1200
Engine : | 420 12 litre Euro 3 |  | 2007-05-31 00:00:00 | 12 Months | 2008-06-01 00:00:00 | 1200
[NAME] : | 44,000kg |  | 2008-05-30 00:00:00 | 12 Months | 2009-06-01 00:00:00 | 1200
 |  |  | 2009-05-29 00:00:00 | 12 Months | 2010-06-01 00:00:00 | 1200
 |  |  | 2010-05-28 00:00:00 | 12 Months | 2011-06-01 00:00:00 | 1200
 |  |  | 2011-05-31 00:00:00 | 12 Months | 2012-06-01 00:00:00 | 1200
Back To Index |  |  | 2012-02-29 00:00:00 | 12 Months | 2013-06-01 00:00:00 | 700
 |  |  | Exchanged tax disc from HGV to RPC Euro 3 to Euro 4 By Eminox.
Spreadsheet: 5468cb07-b7fa-4004-9116-32869d084a2e
Sheet: Sheet1

 |  | GOAL:   100% Participation of Each Troop Family
Please List ALL Registered Girls In Troop  Indicate Any Who Are No Longer Active | Parent [NAME]/Phone | Date Delivered | Date of  Reminder Contact | [NAME] | Notes:
1.
2.
3.
4.
5.
6.
7.
8.
9.
10.
11.
12.
For Service Unit Chair Use Only:
No. of [NAME] __________  Total Cash ___________  Total Checks ____________ Total  AMEX/MC/Visa/DISC ____________ Troop Total ______________
Spreadsheet: 854879d1704634604-split-a-sequence-of-numbers-date-whole-part-aligw
Sheet: Sheet1

111 |  | 1
21112 | 2 | 2
3211123 | 3 | 3
432111234 | 4 | 4
54321112345 | 5 | 5
Spreadsheet: 160733d1339177448-excel-2007-look-up-question-lookup-from-multiple-tabs
Sheet: 109

Attendance Rules: 5 – 5.75   NoCorrective Action 6 – 7.00  No Corrective Action taken; Notice of Attendance Record 7.25 – 7.75   Verbal Warning 8 – 8.75  Written Warning 9 – 9.75  Final Written Warning with 120-day probation Next Point (10) - Review for Termination |  | Occurrence Rules: **Occurrences stay on the record for a rolling one year. **Occurrences stay on until an Approved FMLA letter is issued from UNUM. A doctors excuse does not remove an Occurrence. 8-15 minutes tardy, early departure or shift interruption~.25 16 or more minutes tardy, early departure or shift interruption ~ .50 3 hours or more absent when scheduled to work ~ 1 2 consecutive work days absent (10 hours for part-time)~2 3 or more consecutive days absent (15 hours for part-time)~2.25 Call-off or no-show for scheduled & communicated overtime~1 |  |  |  |  |  |  |  | 0 | n/a
 |  |  |  |  |  |  |  |  |  | 1 | Applied for
 |  |  |  |  |  |  |  |  |  | 0.25 | Approved
 |  |  |  |  |  |  |  |  |  |  | Denied
Tech Name | [NAME] Doe #3 | Total Occurrences
Tech Number | 109 | Corrective Action Step
Date | Occurrence Issued | FMLA   Applied for/ Approved/Denied | Comments
2011-06-24 00:00:00 | 1 | n/a
2011-10-01 00:00:00 | 1 | n/a
2011-01-31 00:00:00 | 1 | n/a
2011-03-08 00:00:00 | 1 | n/a
Spreadsheet: 859746d1708007921-displaying-information-with-dropdowns-testbook-1-
Sheet: Bylines

Site | Year | Month | Quarter | Byline | Count | Byline Type | External | Internal | Total
Red | 2020 | Dec | Q4 | Ibrahim | 350 | Internal
Red | 2020 | Dec | Q4 | Musa | 300 | Internal
Red | 2020 | Dec | Q4 | [NAME] | 200 | Internal
Yellow | 2020 | Dec | Q1 | [NAME] | 70 | Internal
Yellow | 2020 | Dec | Q1 | [NAME] | 60 | External
Blue | 2020 | Dec | Q1 | [NAME] | 50 | Internal
Yellow | 2020 | Dec | Q2 | Mark | 60 | External
Green | 2020 | Dec | Q2 | [NAME] | 70 | Internal
Green | 2020 | Dec | Q4 | Mark | 81 | External
Green | 2021 | Dec | Q4 | [NAME] | 91 | Internal
Green | 2020 | Dec | Q3 | [NAME] | 100 | Internal
Red | 2020 | Jan | Q1 | [NAME] | 200 | Internal
Red | 2020 | Dec | Q4 | [NAME] | 100 | Internal
Red | 2020 | Dec | Q4 | [NAME] | 90 | External
Red | 2020 | Jan | Q1 | [NAME] | 80 | External
 |  |  |  |  |  | Internal
 |  |  |  |  |  | Internal
Spreadsheet: daren_farmer__5552__HPLN1102
Sheet: Sheet1

HPLN1102.XLS |  | Fax # [PHONE]
TO:  DARREN FARMER / ENRON;  CARY METZ / ENRON;  [NAME] / HPL;  LAURA BELLAMY / ENRON
FROM:  MELISSA JONES - TXU ELECTRIC & GAS  (TU ELECTRIC)
SUBJECT:  TXU FUELS NOMINATION - November 2, 2000
 |  |  |  |  |  | **Thursday
HPL AND ENRON NOMINATIONS: |  |  |  |  |  | 2000-11-02 00:00:00
 |  |  |  |  |  | Eff. 0900 hrs.
 |  |  |  |  | PRIOR | NOMINATED
CONTRACT |  | DELIVERY POINT |  | Upstream
Enron (FM) |  | LS HPL [NAME] |  | HPL
 |  |  |  |  | 0 to 0  0900hrs | 0 to 0  0900hrs
 |  |  |  |  | 0  to 0 2100hrs | 0  to 0 2100hrs
Enron (FM) |  | [NAME] (DBND) |  |  | 0 | 2
 |  | Firm Summary
Enron (S) |  | Sandhills |  | HPL | 8 | 8
 |  | Enron North America Spot/3959
OTHER ENRON/HPL TRANSPORTS: |  |  |  | Downstream
 |  | Total Other Transports:
NOTE:  Additional swing volumes may be requested at Teco Tap, or Texoma by TUFCO Gas Control under either the
Wagner Brown K# 1901 or HPL K# 3949 agreements.
*  Nominations to continue until TU Electric changes such nominations.
CC:   [NAME] | [NAME]
R. Skerik | [NAME]
G. Green | K. English
B. Fleming | GCC Dispatcher
Spreadsheet: 221646d1363630741-how-do-i-find-the-offset-of-my-formula-next2
Sheet: Sheet1

Processor | Value |  | [NAME] | Keywords
Processor manufacturer | Intel |  |  | layer
L3 cache | 2 MB |  |  | Processor model
System bus | 5 GT/s |  |  | fsfs
Processor number of threads | 2
Processor number of cores | 2
Processor model | B830
Processor family* | Intel Pentium
Processor clock speed* | 1.8 GHz
Spreadsheet: 271680d1382021370-help-me-please-index-search-problem-jeparts100
Sheet: MAIN

PART NUMBER | [NAME] | COST | SELL | SUPPLIER PART NUMBER | SUPPLIER
00001 | APPLE TEST 1 | 1.5 | 1.875 | APPLE TEST 1000000 | APPLE
00002 | APPLE TEST 2 | 9.5 | 11.875 | APPLE TEST 2000000 | APPLE
00003 | APPLE TEST 3 | 6.4 | 8 | APPLE TEST 3000000 | APPLE
00004 | GOOGLE 4 | 100 | 125 | GOOGLE 4000000 | GOOGLE
00005 | GOOGLE 5 | 2.7 | 3.375 | GOOGLE 5000000 | GOOGLE
00006 | GOOGLE 6 | 1 | 1.25 | GOOGLE 6000000 | GOOGLE
00007 | YAHOO 2 | 0.5 | 0.625 | YAHOO 2000000 | YAHOO | 1
00008 | YAHOO 3 | 9.98 | 12.475 | YAHOO 3000000 | YAHOO | 2
00009 | YAHOO 4 | 5.7 | 7.125 | YAHOO 4000000 | YAHOO | 3
00006 | APPLE TEST 4 | 67 | 123 | APPLE TEST 4000000 | APPLE
Spreadsheet: 871131d1717567426-get-data-by-map-data-input-1-1-aligw
Sheet: Sheet1

No | FirstName | Lastname | ItaFirstName | ItalastName | Check | Result_Y | AliGW
1 | [NAME] | [NAME] | A | E | Y | 24
2 | Mo | Aa | B | R | Y | 23
3 | Ty | er | r | A | N | N
4 | Ty | rt | C | R | Y | 12
3 | Ty | er | r | B | N | N
Spreadsheet: 840790d1692981571-generating-an-if-statement-to-gather-an-average-sample-workbook-7-
Sheet: Data

 | Data
 | First Work Day
 | End of Month
 | Final Work Day
 |  |  |  |  |  |  |  |  |  |  |  | Drop down list
 | VLOOKUP TABLE | X | Y | Z |  | A | B |  | C |  |  | Month Average X
 |  | 23.25 | 2.75 | 21 |  | 63.25 | 61.5 |  | 6.5 |  |  | Month Average Y
 |  | 21.5 | 3.25 | 19.25 |  | 59.75 | 59.75 |  | 9.75 |  |  | Month Average Z
 |  | 16.5 | 6.25 | 14 |  | 47.25 | 47.25 |  | 18.5 |  |  | Date + 3
 |  | 16.75 | 5.5 | 14.25 |  | 52.25 | 52.25 |  | 13.25 |  |  | Fixed Date
 |  | 14 | 4.75 | 11.5 |  | 57 | 57 |  | 11.25
 |  | 12.25 | 0.5 | 9.75 |  | 57.5 | 57.5 |  | 12.25
 |  | 8.5 | -0.5 | 7.25 |  | 51.25 | 51.75 |  | 12.25
 |  | 19.75 | 12.75 | 18.5 |  | 58.5 | 59 |  | 7
 |  | 18.5 | 9.75 | 17.25 |  | 58.25 | 58.75 |  | 5
 |  | 19.75 | 10.75 | 18.5 |  | 60.5 | 59 |  | 5.75
 |  | 18.25 | 7.75 | 16.5 |  | 59.25 | 57.75 |  | 4.75
 |  | 16.5 | 6.5 | 14.25 |  | 59.5 | 58 |  | 4.25
 |  | 17 | 6 | 14.25 |  | 60.25 | 58.75 |  | 5.75
 |  | 17.25 | 3.75 | 14 |  | 62.25 | 60.75 |  | 5
 |  | 18.25 | 5.25 | 15 |  | 64.5 | 63 |  | 6.25
 |  | 19.75 | 6.25 | 16.5 |  | 63.75 | 62.25 |  | 7.75
 |  | 19.75 | 6 | 16.5 |  | 61.25 | 60.25 |  | 6.5
 |  | 18.75 | 6.25 | 15.5 |  | 55.25 | 57.25 |  | 9.5
 |  | 16.25 | 7.5 | 13 |  | 52 | 54 |  | 14.25
 |  | 18.75 | 7.25 | 15.5 |  | 50.75 | 52.75 |  | 18
 |  | 17 | 6.75 | 13.75 |  | 55 | 56.75 |  | 17.25
 | Month Average
Spreadsheet: 156136d1337186558-title-changes-when-reached-a-certain-amount-of-numbers-earned-title-sample
Sheet: Sheet1

 |  |  | Money Spent on my Goods ($)
 |  | Customer Name | May | June | July | August | Total | Title Earned |  |  |  |  |  |  |  |  | Money Spent ($) | Title Earned
 |  | [NAME] | 10 | 10 | 200 | 350 |  |  |  | I want auto-generated title as seeing from the |  |  |  |  |  |  | 0-100 | Shopper
 |  | [NAME] | 3 | 2 | 1 | 5 |  |  |  | total amount of money spent here |  |  |  |  |  |  | 101-200 | Shopaholic
 |  | [NAME] | 11 | 11 | 11 | 2 |  |  |  |  |  |  |  |  |  |  | 200-500 | VIP Shopper
 |  | Mana | 33 | 60 | 4 | 30 |  |  |  |  |  |  |  |  |  |  | >501 | VVIP Shopper
 |  | Adame | 100 | 50 | 22 | 60
Spreadsheet: 761462d1640920678-the-exact-same-formula-showing-different-values-homeloan-testing-1
Sheet: Final

Todays Date |  |  | Current Loan Balance |  |  |  | LENDER NAME |  | Finance Company
only fill in yellow squares
calculate before extra payments |  |  |  |  |  |  |  |  |  |  |  |  | Opening Balance
 |  |  |  |  |  |  |  |  |  |  |  |  | Purchase
Loan amount |  |  | 237500 |  | Scheduled payment |  |  | 625.22 |  |  |  |  | Repayment
Interest rate |  |  | 0.0269 |  | Scheduled number of payments |  |  | 489 |  |  |  |  | Interest
 |  | period |  |  | Actual number of payments
Loan term in years |  |  | 19 |  | Payments made to date
months |  |  | 4 |  | Number of payments saved
Payments made per year |  |  | 26 |  | Years saved off original loan term
Loan repayment start date |  |  | 2021-08-12 00:00:00 |  | Total early payments
Loan repayment end  date |  |  | 2040-11-20 00:00:00 |  | Total interest
New Loan repayment End date
Time saved
Optional extra payments |  |  | 25.78
 | Date | Details | Actual Interest as per statement | Debit | Credit | Total including Interest | Statement total | correcting value |  |  | days since last transaction | Month | Interest calculated for days between activity | Interest manual check
 | 2021-08-06 00:00:00 | Opening Balance |  |  |  | 0
 | 2021-08-06 00:00:00 | Purchase |  | 237500
1 | 2021-08-12 00:00:00 | Repayment |  |  | 625.22
 | 2021-08-26 00:00:00 | Repayment |  |  | 625.22
 | 2021-08-31 00:00:00 | Interest | 436.48 |  |  |  |  | 0.24
 | 2021-09-09 00:00:00 | Repayment |  |  | 651
 | 2021-09-23 00:00:00 | Repayment |  |  | 651
 | 2021-09-30 00:00:00 | Interest | 521.96 |  |  |  |  | 0.37
 | 2021-10-07 00:00:00 | Repayment |  |  | 651
 | 2021-10-21 00:00:00 | Repayment |  |  | 651
 | 2021-10-31 00:00:00 | Interest | 537.33 |  |  |  |  | 0.4
 | 2021-11-04 00:00:00 | Repayment |  |  | 651
 | 2021-11-18 00:00:00 | Repayment |  |  | 651
 | 2021-11-30 00:00:00 | Interest | 518.06 |  |  |  |  | 0.35
 | 2021-12-02 00:00:00 | Repayment |  |  | 651
 | 2021-12-16 00:00:00 | Repayment |  |  | 651
 | 2021-12-30 00:00:00 | Repayment |  |  | 651
Spreadsheet: 859576d1707916080-by-group-subtotal-subtotal-by-group
Sheet: Sheet1

Area | Core? | Spend |  | Area | Core? | Spend |  | Area | Core? | Sum of Spend
North | Core | 567 |  | North | Core | 567 |  | North | Core | 567
North | Non-Core | 22 |  | North | Non-Core | 22 |  | North | Non-Core | 22
South | Core | 5346 |  | North Total |  |  |  | North Total |  | 589
South | Non-Core | 345 |  | South | Core | 5346 |  | South | Core | 5346
East | Core | 6456 |  | South | Non-Core | 345 |  | South | Non-Core | 345
East | Non-Core | 9887 |  | South Total |  |  |  | South Total |  | 5691
West | Core | 234 |  | East | Core | 6456 |  | East | Core | 6456
West | Non-Core | 664 |  | East | Non-Core | 9887 |  | East | Non-Core | 9887
 |  |  |  | East Total |  |  |  | East Total |  | 16343
 |  |  |  | West | Core | 234 |  | West | Core | 234
 |  |  |  | West | Non-Core | 664 |  | West | Non-Core | 664
 |  |  |  | West Total |  |  |  | West Total |  | 898
 |  |  |  | Grant Total |  |  |  | Grand Total |  | 23521
Spreadsheet: 158010d1337952981-converting-formula-to-values-automatically-sample
Sheet: Sheet1

Seed | 2012-05-06 00:00:00
34
Spreadsheet: 788362d1658417927-count-student-with-teacher-student-level
Sheet: Data

teachercher Name | studentdent [NAME] | Level
 |  | One | Two | Three
teacher 1 | student 1 | 1
teacher 2 | student 2 |  | 2 |  | Request
teacher 3 | student 3 |  |  | 3 | 1 | It is required to copy studentdents in each level with the level teachercher in under sheets- teachercher1-teachercher2-teachercher3
teacher 2 | student 4 |  | 2 |  | 2 | count studentdent according to level In front of the teachercher in compare sheet
teacher 1 | student 5 | 1
teacher 2 | student 6 |  | 2
teacher 1 | student 7 |  |  | 3
teacher 2 | student 8 |  |  | 3
teacher 1 | student 9 | 1
teacher 2 | student 10 |  |  | 3
teacher 1 | student 11 |  | 2
teacher 2 | student 12 | 1
teacher 1 | student 13 |  |  | 3
teacher 2 | student 14 |  | 2
teacher 3 | student 15 | 1
teacher 2 | student 16 |  | 2
teacher 3 | student 17 | 1
teacher 2 | student 18 |  |  | 3
teacher 3 | student 19 | 1
teacher 1 | student 20 |  | 2
teacher 3 | student 21 | 1
teacher 1 | student 22 |  |  | 3
teacher 3 | student 23 | 1
Spreadsheet: cdb68398-3e86-41eb-8f4e-4323f3544900
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
PBGU | Test | PBGU | Porphobilinogen, Quantitative, Random, [NAME] | Porphobilinogen, QN, [NAME], U | Liquid Chromatography-Tandem Mass Spectrometry (LC-MS/MS) Stable Isotope Dilution Analysis | [NAME]: Urine |  |  | 20 | mL | Container/Tube: Amber, 60-mL urine bottle (Supply T596) [NAME]: 20 mL Collection Instructions:  1. Collect a random urine specimen. 2. No preservative necessary but pH must be >5.0.  3. Protect specimen from light. Forms: 1.     1. New York Clients-Informed consent is required. Please document on the request form or electronic order that a copy is on file. An Informed Consent for Genetic Testing (Supply T576) is available in Special Instructions. 2.     2. If not ordering electronically, submit a Biochemical Genetics Request Form (Supply T439) with the specimen. | 15 mL | Hemolysis	NA Thawing	Warm reject; Cold OK Lipemia	NA Icterus	NA Other	[NAME] not protected from light | < or =1.3 mcmol/L | Monday through Friday; 8 a.m. | 2 days (not reported on Saturday or Sunday) | 6 days | 1 | 84110 |  |  |  |  | Rochester
PBGU | [NAME] | URINE | [NAME] |  |  |  | Frozen | 7 days
PBGU | Result | 29365 | Porphobilinogen, U | Porphobilinogen, U | Numeric |  |  |  |  | mcmol/L |  |  |  |  |  |  |  |  |  | 2811-8 | Porphobilinogen:SCnc:Pt:[NAME]:Qn:
PBGU | Result | 29366 | Interpretation (PBGU) | Interpretation (PBGU) | Alphanumeric |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 59462-2
PBGU | Result | 35032 | Reviewed By | Reviewed By | Numeric |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 2811-8 | Porphobilinogen:SCnc:Pt:[NAME]:Qn:
Spreadsheet: 686048d1594325852-formula-copying-down-in-table-formula-copy-down
Sheet: Sheet1

Item | Cost | Margin | Total
A | 3 | 2
B | 5 | 3
C | 4 | 2
D | 3 | 2
E | 7 | 3
F | 4 | 1
Spreadsheet: 864445d1711615088-merging-multiple-tables-based-on-unique-id-merging-multiple-tables-based-on-unique-id-jt
Sheet: Summary

Sr. No. | Description | X1 | X2 | X3 | X4 | X5 | X6 |  | Sr. No. | Description | X1 | X2 | X3 | X4 | X5 | X6
1 | AAA | 1 | 1 | 1 | 3 | 1 | 1 |  | 1 | AAA | 1 | 1 | 1 | 3 | 1 | 1
2 | BBB | 2 | 2 | 2 | 2 | 2 | 2 |  | 2 | BBB | 2 | 2 | 2 | 2 | 2 | 2
3 | CCC | 1 | 1 | 3 | 1 | 1 | 1 |  | 3 | CCC | 1 | 1 | 3 | 1 | 1 | 1
4 | DDD | 3 | 0 | 4 | 1 | 3 | 2 |  | 4 | DDD | 3 | 0 | 4 | 1 | 3 | 2
5 | EEE | 1 | 2 | 3 | 2 | 0 | 1 |  | 5 | EEE | 1 | 2 | 3 | 2 | 0 | 1
6 | FFF | 0 | 1 | 2 | 1 | 1 | 3 |  | 6 | FFF | 0 | 1 | 2 | 1 | 1 | 3
7 | GGG | 2 | 3 | 1 | 3 | 2 | 2 |  | 7 | GGG | 2 | 3 | 1 | 3 | 2 | 2
8 | HHH | 1 | 1 | 4 | 2 | 4 | 1 |  | 8 | HHH | 1 | 1 | 4 | 2 | 4 | 1
9 | III | 0 | 4 | 1 | 1 | 2 | 1 |  | 9 | III | 0 | 4 | 1 | 1 | 2 | 1
10 | JJJ | 1 | 2 | 2 | 0 | 1 | 2 |  | 10 | JJJ | 1 | 2 | 2 | 0 | 1 | 2
11 | KKK | 2 | 1 | 2 | 4 | 0 | 1 |  | 11 | KKK | 2 | 1 | 2 | 4 | 0 | 1
12 | LLL | 1 | 0 | 0 | 2 | 1 | 0 |  | 12 | LLL | 1 | 0 | 0 | 2 | 1 | 0
let
Source = Excel.CurrentWorkbook(),
#"Filtered Rows" = Table.SelectRows(Source, each Text.StartsWith([Name], "t_")),
#"Removed Other Columns" = Table.SelectColumns(#"Filtered Rows",{"Content"}),
Custom1 = Table.Combine(#"Removed Other Columns"[Content]),
#"Unpivoted Other Columns" = Table.UnpivotOtherColumns(Custom1, {"Sr. No.", "Description"}, "Attribute", "Value"),
#"Pivoted Column" = Table.Pivot(#"Unpivoted Other Columns", [NAME].Distinct(#"Unpivoted Other Columns"[Attribute]), "Attribute", "Value", List.Sum)
in
#"Pivoted Column"
Spreadsheet: 148895d1333601842-indirect-sumproduct-counting-symbols-with-conditions-help-sample-pcr
Sheet: Daily Summary

 |  |  |  |  |  |  |  |  |  | Summary
 |  |  |  |  |  | Jan |  | 01 | 02 | 03 | 04 | 05 | 06 | 07 | 08 | 09 | 10 | 11 | 12 | 13 | 14 | 15 | 16 | 17 | 18 | 19 | 20 | 21 | 22 | 23 | 24 | 25 | 26 | 27 | 28 | 29 | 30 | 31
 |  |  |  |  |  |  |  | 01 | 02 | 03 | 04 | 05 | 06 | 07 | 08 | 09 | 10 | 11 | 12 | 13 | 14 | 15 | 16 | 17 | 18 | 19 | 20 | 21 | 22 | 23 | 24 | 25 | 26 | 27 | 28 | 29 | 30 | 31
 |  |  |  |  |  |  |  | Jan | Feb | Mar | Apr | May | Jun | Jul | Aug | Sep | Oct | Nov | Dec | 2012 | 一月 | 二月 | 三月 | 四月 | 五月 | 六月 | 次月 | 八月 | 九月 | 十月 | [NAME] | 十二月
 |  |  |  | 年初至今总合格接受报名 | Ttl. Qualified Enrolments MTD
 |  |  |  | 年初至今共有电邮捕捉 | Ttl. Email Capture MTD
 |  |  |  | 年初至今％的比率在 | Email Capture Ratio MTD (%)
Internal Qualified Enrolments |  |  |  | 采取行动。合格的参赛名额（英法俄） | Act. Qualified Enrolments (EFR)
Possible Fraud |  |  |  | 采取行动。电子邮件捕捉（英法俄） | Act. Email Capture (EFR)
INDIVIDUAL ENROLMENT PERFORMANCE
个人表现
Staff ID |  | Section | Target | PCR ID | EMP ID | MTD |  | 01 | 02 | 03 | 04 | 05 | 06 | 07 | 08 | 09 | 10 | 11 | 12 | 13 | 14 | 15 | 16 | 17 | 18 | 19 | 20 | 21 | 22 | 23 | 24 | 25 | 26 | 27 | 28 | 29 | 30 | 31
员工编号 |  | 部分 | 目标 | PCR ID | EMP ID | MTD |  | 01 | 02 | 03 | 04 | 05 | 06 | 07 | 08 | 09 | 10 | 11 | 12 | 13 | 14 | 15 | 16 | 17 | 18 | 19 | 20 | 21 | 22 | 23 | 24 | 25 | 26 | 27 | 28 | 29 | 30 | 31
FOVICKY | [NAME] | FD | 15 | 369078788 | 999765667 |  |  |  | check how many entries are present for the specified month (G2) and count how many of the entries have the staff ID remarked in A15.
 |  |  |  |  |  |  |  |  | check how many entries are present for the specified month (G2) and count how many of these entries have the staff id remarked (A16) and have an email address on file.
FOANDRES | [NAME] - 赵 军 | FD | 15 | 813015310 | 824930253
FODIANA | Diana - 胡梦莉 | FD | 15 | 369077816 | 999766018
FOEMMA | Emma - 吴益能 | FD | 15 | 379144939 | 999767254
FOSHELLEY | Shelley - 张妍雯 | FD | 15 | 824970752 | 231087492
FOYUKI | [NAME] | FD | 10
FOSARAH | [NAME] | CI | 10
FOSOPHIA | Sophia-  戚茹平 | CI | 10
FOAMANDA | Amanda -陆叶 | CI | 10
FOELLEN | ELLEN-胡小玲 | FD | 5
FOSARINA | SARINA-黄建美 | GRO | 5
FOANGELA | ANGELA-温岩 | GSM | 5
Spreadsheet: 3442da8d-e564-4c79-b099-92911d51646e
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
NAF | Test | NAF | Sodium, Random, Feces | Sodium, Random, F | Inductively Coupled Plasma-Optical Emission Spectrometry (ICP-OES) | Stool Container: Stool |  |  | 20 | g | Container/Tube: Stool container (Supply T291) [NAME]: 20 g Collection Instructions: 1. Collect a very liquid stool specimen. 2. See Stool Collection Information Sheet in Special Instructions. Additional Information: 1. Do not send formed stool. In the event a formed stool is submitted, the test will not be performed. The report will indicate "A formed stool specimen was submitted for analysis. This test was not performed because it only has clinical value if performed on a watery stool specimen." 2. High concentrations of gadolinium and iodine are known to interfere with most metals tests. If either gadolinium- or iodine-containing contrast media has been administered, a specimen must not be collected for 96 hours. | 3 g | Hemolysis	NA Thawing	Warm OK; Cold OK Lipemia	NA Icterus	NA Other	Formed stool | 0-15 years: not established > or =16 years: 0-159 mEq/kg | Monday through Friday; evening | 2 days | 5 days | 1 | 84302 |  |  |  |  | Rochester
NAF | [NAME] | FECAL | Fecal |  |  |  | Frozen | 14 days
NAF | Result | 32300 | Sodium, Random, F | Sodium, Random, F | Numeric |  |  |  |  | mEq/kg |  |  |  |  |  |  |  |  |  | 14055-8