tianzl66/Sheetpedia huggingface dataset:
Spreadsheet: 78305d1278682107-filters-applied-to-creat-a-percentage-pie-chart-736439
Sheet: Results

 | Q1.4 |  |  |  | 0 | Q1.1 | Q1.2 | Q1.3 | Q1.4 | Q1.5 | Q1.6
Excellent | 0.3333333333333333 |  |  |  | Excellent | 0.3333333333333333 | 0.3333333333333333 | 0.3333333333333333 | 0.3333333333333333 | 0.3333333333333333 | 0.3333333333333333
Good | 0.1666666666666667 |  |  |  | Good | 0.1666666666666667 | 0.1666666666666667 | 0.1666666666666667 | 0.1666666666666667 | 0.1666666666666667 | 0.1666666666666667
Average | 0.3333333333333333 |  |  |  | Average | 0.3333333333333333 | 0.3333333333333333 | 0.3333333333333333 | 0.3333333333333333 | 0.3333333333333333 | 0.3333333333333333
Poor | 0.1666666666666667 |  |  |  | Poor | 0.1666666666666667 | 0.1666666666666667 | 0.1666666666666667 | 0.1666666666666667 | 0.1666666666666667 | 0.1666666666666667
Very Poor | 0 |  |  |  | Very Poor | 0 | 0 | 0 | 0 | 0 | 0
Year | Month | Day | Location | Course Title | Trainer | Q1.1 | Q1.2 | Q1.3 | Q1.4 | Q1.5 | Q1.6 | Visible
2010 | Jan | 5 | Sheffield | Keystone | [NAME] | Good | Good | Good | Good | Good | Good | 1
2010 | Jan | 5 | Sheffield | Keystone | [NAME] | Average | Average | Average | Average | Average | Average | 1
2010 | Jan | 12 | Sheffield | Keystone | [NAME] | Excellent | Excellent | Excellent | Excellent | Excellent | Excellent | 1
2010 | Jan | 12 | Sheffield | Keystone | [NAME] | Excellent | Excellent | Excellent | Excellent | Excellent | Excellent | 1
2010 | Jan | 12 | Sheffield | Keystone | [NAME] | Excellent | Excellent | Excellent | Excellent | Excellent | Excellent | 1
2010 | May | 9 | Sheffield | Keystone | [NAME] | Poor | Poor | Poor | Poor | Poor | Poor | 1
2010 | May | 9 | Sheffield | Keystone | [NAME] | Poor | Poor | Poor | Poor | Poor | Poor | 1
2010 | May | 9 | Sheffield | Keystone | [NAME] | Excellent | Excellent | Excellent | Excellent | Excellent | Excellent | 1
2010 | May | 9 | Sheffield | Keystone | [NAME] | Average | Average | Average | Average | Average | Average | 1
2010 | May | 26 | Sheffield | Keystone | [NAME] | Average | Average | Average | Average | Average | Average | 1
2010 | June | 1 | Sheffield | Keystone | [NAME] | Average | Excellent | Excellent | Excellent | Excellent | Excellent | 1
2010 | June | 1 | Sheffield | Keystone | [NAME] | Good | Good | Good | Good | Good | Good | 1
Spreadsheet: 128488d1321006395-listing-items-without-empty-cells-auction
Sheet: Auction

Buyer | [NAME] | Item | Price | Quantity | Total
1 | 11 | knife | 5 | 1
2 | 11 | knife | 5 | 1
3 | 11 | knife | 5 | 1
1 | 12 | towels | 3 | 2
2 | 12 | towels | 3 | 1
3 | 12 | towels | 3 | 1
1 | 13 | candy | 1 | 5
2 | 13 | candy | 1 | 7
3 | 13 | candy | 1 | 3
1 | 11 | toy | 6 | 2
2 | 11 | toy | 6 | 1
3 | 11 | toy | 6 | 1
1 | 12 | lamp | 12 | 2
2 | 12 | lamp | 12 | 2
3 | 12 | lamp | 12 | 2
1 | 13 | lighter | 0.5 | 5
2 | 13 | lighter | 0.5 | 3
3 | 13 | lighter | 0.5 | 1
Spreadsheet: 773131d1647629577-conditional-format-cells-based-upon-matching-cells-and-date-range-from-today-cycle_count_sample_generator_sample
Sheet: Cycle_Count_Sample

 |  |  |  |  | Q1 | Q2 | Q3 | Q4
060825 | MUFFLER 1/4 NPT MALE, 30SCFM@100 PSI FLOW CTRL
998552 | CHAIN , COUPLING CHAIN SPRIAL ELEV N411
060825 | MUFFLER 1/4 NPT MALE, 30SCFM@100 PSI FLOW CTRL
994101 | ELEC, ALLEN BRADLEY SLC 5/04 PROCESSOR (1747L541)
994101 | ELEC, ALLEN BRADLEY SLC 5/04 PROCESSOR (1747L541)
Spreadsheet: 703882d1605206233-if-isnumber-search-and-or-with-extra-criteria-erf-log-projects
Sheet: Won

EQUALS FORMULA | Site [NAME] | Date (Estimate Complete) | Start  Date | Notes | SN# or PO# or  WBS# | SO# (ZM02, ZM03) OR MHPS Standard Order |  |  |  |  |  |  |  |  | Kickoff
Spreadsheet: 275342d1383473701-another-countif-problem-countif
Sheet: COUNT

 | Graph
 | O | AMOUNT
 | 9 |  | <---- Odkloni is the name of the range
 | 8.9
 | 8.8
 | 8.7
 | 8.6
 | 8.5
 | 8.4
 | 8.3
 | 8.2
 | 8.1
 | 8
 | 7.9
 | 7.8
 | 7.7
 | 7.6
 | 7.5
 | 7.4
 | 7.3
 | 7.2
 | 7.1
 | 7
 | 6.9
 | 6.8
 | 6.7
 | 6.6
 | 6.5
 | 6.4
 | 6.3
 | 6.2
 | 6.1
 | 6
 | 5.9
 | 5.8
 | 5.7
 | 5.6
 | 5.5
 | 5.4
 | 5.3
 | 5.2
 | 5.1
 | 5
 | 4.9
 | 4.8
 | 4.7
 | 4.6
 | 4.5
 | 4.4
 | 4.3
 | 4.2
 | 4.1
 | 4
 | 3.9
 | 3.8
 | 3.7
 | 3.6
 | 3.5
 | 3.4
 | 3.3
 | 3.2
 | 3.1
 | 3
 | 2.9
 | 2.8
 | 2.7
 | 2.6
 | 2.5
 | 2.4
 | 2.3
 | 2.2
 | 2.1
 | 2
 | 1.9
 | 1.8
 | 1.7
 | 1.6
 | 1.5
 | 1.4
 | 1.3
 | 1.2
 | 1.1
 | 1
 | 0.9
 | 0.8
 | 0.7
 | 0.6
 | 0.5
 | 0.4
 | 0.3
 | 0.2
 | 0.1
 | 0
 | -0.1
 | -0.2
 | -0.3
 | -0.4
 | -0.5
 | -0.6
 | -0.7
 | -0.8
 | -0.9
 | -1
 | -1.1
 | -1.2
 | -1.3
 | -1.4
 | -1.5
 | -1.6
 | -1.7
 | -1.8
 | -1.9
 | -2
 | -2.1
 | -2.2
 | -2.3
 | -2.4
 | -2.5
 | -2.6
 | -2.7
 | -2.8
 | -2.9
 | -3
 | -3.1
 | -3.2
 | -3.3
 | -3.4
 | -3.5
 | -3.6
 | -3.7
 | -3.8
 | -3.9
 | -4
 | -4.1
 | -4.2
 | -4.3
 | -4.4
 | -4.5
 | -4.6
 | -4.7
 | -4.8
 | -4.9
 | -5
 | -5.1
 | -5.2
 | -5.3
 | -5.4
 | -5.5
 | -5.6
 | -5.7
 | -5.8
 | -5.9
 | -6
 | -6.1
 | -6.2
 | -6.3
 | -6.4
 | -6.5
 | -6.6
 | -6.7
 | -6.8
 | -6.9
 | -7
 | -7.1
 | -7.2
 | -7.3
 | -7.4
 | -7.5
 | -7.6
 | -7.7
 | -7.8
 | -7.9
 | -8
 | -8.1
 | -8.2
 | -8.3
 | -8.4
 | -8.5
 | -8.6
 | -8.7
 | -8.8
 | -8.9
 | -9
 |  |  | <--- Should be 603 as the number of ratings
Spreadsheet: 863882d1711288230-exchanging-no-s-for-names-examplebook1golf
Sheet: Sheet2

player 1 |  | player 1 |  | player 7
player 2 |  | player7
player 3
player 4 |  | player 2 |  | player 2 |  | player 2
player 5 |  | player5 |  |  |  |  |  |  |  | these players corespond to the list in sheet 1
player 6 |  |  |  |  |  |  |  | player 8
player 7 |  | player 3
player 8 |  | [NAME] |  | player 4 |  | player 8
 |  | player 6
 |  | player 8 |  | player 8
 |  |  | 0 |  | 0
fred (player 2) |  |  | 1
bill
[NAME] |  |  | 1 |  | 1 |  | 0
[NAME] |  |  | 0
alf
[NAME] |  |  | 0
[NAME] |  |  | 1 |  | 0 |  | 1
 |  |  | 0
 |  |  | 1 |  | 1
Spreadsheet: 694123d1599374524-extract-unique-values-from-across-column-p2-r10-count_exact_now_unique
Sheet: Sheet1

Head-0 | [NAME] | Head2 | Head3 | Head4 | Head5 | Head6 | [NAME] | Head8 | Head9 | Head10 | Head11 | Head12 | Head13
2nd Crop
2nd Crop | Apple
2nd Crop | Apple | Apple | Apple | Pen | Pen | Pen | Bee
Tank | [NAME] | [NAME] | [NAME]
Tank | Apple | Mango | [NAME]
Tank | Avocado | Avocado | Avocado
Tank | Blueberry | Blueberry | Blueberry | Blueberry | Blueberry | Blueberry
Copa | Mango | Mango | Mango | Mango | Mango | Mango | Mango | Mango | Mango | Mango | Mango | Mango | Mango
Copa | Guava
Spreadsheet: 600344d1543607023-get-total-from-other-cells-w-formulas-testing-inventory-template
Sheet: Inventory Worksheet

Item | Description | Pallet | Cartons | Pieces | Physical Count
1610-00 | [NAME]
1610-30 | X16 Server w/CO Card
1630-00 | CO Exp Card (2 Port)
1645-00 | [NAME]
1670-00 | CH X16 EKT
1670-75 | PINK X16 EKT
1670-76 | RM X16 EKT
1670-86 | TM X16 EKT
1670-92 | VB X16 EKT
47-2501 | X-25 Server
4COLA | 4 Port FXO Module
47-9001 | X-50  Server
47-9001XL | [NAME]
47-7002 | X-3030 IP Phone
X4040 | Color LCD
24BTNDSS | [NAME]
47-9002 | X2020 IP Telephone
47-9003 | X2020 Sidecar
2499-01 | X-7 USB Recorder
47-9004 | 8 Port Network Switch
47-7005 | [NAME]
XB1698-XB | [NAME]
47-9006 | Ethernet Cable
91-1045 | 7ft Telephone Line Cords
4poeswitch | 4 Port PoE Switch
8poeswitch | 8 Port PoE Switch
Cordless Basic Phone | Basic Cordless Telephone
COsurge | Phone Line Surge Protection
Fax Switch | Fax Switch
MOH PLAYER | X16 Music on Hold Player
SP2014 | Skype Phone
91-1004 | Handset-CH (45P)
91-1029 | Power Supply - X16
91-1030 | [NAME]
91-1031 | [NAME]
91-1032 | [NAME]
91-1033 | [NAME]
91-1034 | [NAME]
47-7004 | [NAME]
47-9007 | [NAME]
91-1036 | Power Supply-X2020& X3030 VoIP phone
91-1037 | Power Adapter X2020 Phone
91-1038 | Power Adapter X25$X50 Server
91-1039 | X2020 Handset - CH
SurgPro | Surge Protector
Wired Headset | Wired Headset
Wireless Headset | Wireless Headset
X25X50ant | [NAME] X50 VoIP Systems
X25X50stand | X25& X50 Server Stand
Spreadsheet: 58298d1258568323-calculate-totals-from-one-sheet-to-another-daily-20countl-20matrix-1-
Sheet: Daily Count

Month | NOVEMBER |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | DECEMBER |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | JANUARY
Day of the Week | SU | M | T | W | TH | F | S | SU | M | T | W | TH | F | S | SU | M | T | W | TH | F | S | SU | M | T | W | TH | F | S | SU | M | T | W | TH | F | S | SU | M | T | W | TH | F | S | SU | M | T | W | TH | F | S | SU | M | T | W | TH | F | S | SU | M | T | W | TH | F | S | SU | M | T | W | TH | F | S | SU | M | T | W | TH | F | S | SU | M | T | W | TH | F | S | SU | M | T | W | TH | F | S | SU
Dates | 1 | 2 | 3 | 4 | 5 | 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 | 1 | 2 | 3 | 4 | 5 | 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 | 1 | 2 | 3 | 4 | 5 | 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
NorthStar |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | NorthStar
DAILY PROJECT COUNT
EQIP (SBPR/PPR) REVIEWS
30 DAY INTERIM CASES REQUIRING LOJ:
RFA ASSOCIATION (SCI SCREEING)
SSN CHANGE
HARD COPY INCIDENT REPORTS
NON-U.S. CITIZEN
AGING INTERIMS
REO/RSI RESEARCH
FILE RETENTION
STATE DEPARTMENT REQUESTS
RFA/DOHA TRANSFER
[NAME]
TRANSFER/SEPERATIONS
DISCONTINUE NOTICES
OPM/DSS FILE REQUEST
DOHA FILE REQUEST
SF 312
REO/RSI FAXING TO OPM
INCOMING FAXES
FSO INQURIES FROM OPM
UNACCEPTABLE CASE NOTICES
UNCLASSAFIABLE FINGERPRINTS RESUBMISSIONS
TERMS
USIS REQUEST
FAXING TO CAF’S
SUPPLEMENTAL CASE FILES
TRICARE TRUSTWORTINESS
FORWARDING TRICARE ADVANCED NAC NOTICES
E-ADJUDICATION
PRP Listing
INCIDENT LISTINGS
Spreadsheet: 482572d1475113560-importing-from-another-worksheet-problems-revenuechecker
Sheet: Print Copy Two

Unposted Checks
Copy Two
 |  |  | Check Number | Value
Total
Spreadsheet: 59998d1260527182-sending-data-from-input-sheet-to-other-sheets-in-a-workbook-poss-new-budget-planner
Sheet: United Utilities

UNITED UTILITIES | (Water)
Month | Year | Paymet
January | 2008
February | 2008
March | 2008
April | 2008
May | 2008
June | 2008
July | 2008
August | 2008
September | 2008
October | 2008
November | 2008
December | 2008
January | 2009
February | 2009
March | 2009 | 14.5
April | 2009 | 21.06
May | 2009 | 21.06
June | 2009 | 21.13
July | 2009 | 18.57
August | 2009 | 18.5
September | 2009 | 18.5
October | 2009
November | 2009
December | 2009
January | 2010
February | 2010
March | 2010
April | 2010
May | 2010
June | 2010
July | 2010
August | 2010
September | 2010
October | 2010
November | 2010
December | 2010
Spreadsheet: 454526d1459873291-audit-scoring-with-different-weightage-audit
Sheet: HSSE MS Elements

 | ELEMENT 1: Objectives and Targets |  |  |  |  |  |  |  | N/A
 | Sl.No | Questions/Audit Criteria | Weightage | Observations /Findings | Recommendations | RATING | Score | Final Score | 0
 | Process Defined | Does the project have established and maintained HSSE objectives and targets (KPI's)? Are the HSSE objectives and targets set in line with significant HSSE risks, operational and business requirements?  Are they set in line with Corporate HSSEIA Policy Objectives and Targets? | 0.2 |  |  | 100 |  |  | 5
 | Effective Implementation | Does the project management team review HSSE KPIs (Performance vs. Targets) at least monthly to identify actions aimed at promoting continual improvements? | 0.3 |  |  | 100 |  |  | 10
 |  | Are Petrofac HSSEIA Policies and Project Commitment Statement effectively communicated to all project employees including subcontractor personnel? | 0.4 |  |  | 100 |  |  | 15
 |  | Has the legal and other requirements/regulations applicable to the project been identified? Are the laws/regulations applicable to the project available and accessible? Is the Project Legal Register established and reviewed periodically? Has approvals/licences/permits/other legal requirements identified for the project been obtained? Are the obtained approvals/licences/permits, etc. current and being implemented correctly?                                                                                            Is the legal compliance review done periodically to ensure adequate implementation of the applicable legal and other requirements? | 0.1 |  |  | N/A |  |  | 20
 |  |  |  |  |  | COMPLIANCE SCORE |  |  | 25
 |  |  |  |  |  |  |  |  | 30
 |  |  |  |  |  |  |  |  | 35
 |  |  |  |  |  |  |  |  | 40
 |  |  |  |  |  |  |  |  | 45
 |  |  |  |  |  |  |  |  | 50
 |  |  |  |  |  |  |  |  | 55
 |  |  |  |  |  |  |  |  | 60
 |  |  |  |  |  |  |  |  | 65
 |  |  |  |  |  |  |  |  | 70
 |  |  |  |  |  |  |  |  | 75
 |  |  |  |  |  |  |  |  | 80
 |  |  |  |  |  |  |  |  | 85
 |  |  |  |  |  |  |  |  | 90
 |  |  |  |  |  |  |  |  | 95
 |  |  |  |  |  |  |  |  | 100
Spreadsheet: 299821d1393297931-match-date-and-autimatically-add-to-another-sheet-test-1
Sheet: Sheet2

MONTH | PRODUCT | DATE
2014-03-25 00:00:00 | A | 3
 | B | 1
 | C
 | D | 1
 | E
2014-04-25 00:00:00 | A
 | B
 | C | 1
 | D
 | E
2014-05-25 00:00:00 | A
 | B
 | C
 | D
 | E
2014-06-25 00:00:00 | A
 | B
 | C
 | D
 | E | 1
2014-07-25 00:00:00 | A
 | B
 | C
 | D
 | E
2014-08-25 00:00:00 | A | 1
 | B
 | C
 | D
 | E
2014-09-25 00:00:00 | A
 | B
 | C
 | D
 | E
2014-10-25 00:00:00 | A
 | B
 | C
 | D
 | E
2014-11-25 00:00:00 | A | 1
 | B
 | C
 | D
 | E
2014-12-25 00:00:00 | A | 1
 | B
 | C
 | D
 | E
2015-01-25 00:00:00 | A
 | B
 | C
 | D
 | E
2015-02-25 00:00:00 | A
 | B
 | C
 | D
 | E
Spreadsheet: 746008d1630431654-need-to-exclude-cell-values-test
Sheet: Sheet2

Month | PU% | PPH |  | Month | PPH
January | 68.82 |  |  | January | 9.074606080211735
February | 66.17 |  |  | January | 9.190904270224395
March | 70.62 |  |  | January | 9.35690637787955
April | 71.57 |  |  | January | 8.870531779467036
May | 73.41 |  |  | February | 8.464473117089339
June | 73.51 |  |  | February | 7.878329608313203
July | 72.69 |  |  | February | 7.853573206945841
August | 73.32 |  |  | February | 6.191230555197802
September | 72.37 |  |  | March | 7.114350640191963
October | 71.68 |  |  | March | 6.76493935210702
November | 72.21 |  |  | March | 7.102567695629617
December | 70 |  |  | March | 7.729743484705668
 |  |  |  | March | 8.353107232310176
 |  |  |  | April | 8.284284356516704
 |  |  |  | April | 7.646704653708684
 |  |  |  | April | 7.373601200283542
 |  |  |  | April | 7.158827099465253
 |  |  |  | May | 7.290229720787364
 |  |  |  | May | 7.224270041916893
 |  |  |  | May | 7.84700422562629
 |  |  |  | May | 7.636986058311946
 |  |  |  | June | 7.517600178072258
 |  |  |  | June | 7.398347794236477
 |  |  |  | June | 7.501410321556665
 |  |  |  | June | 6.979170659179047
 |  |  |  | June | 6.870550442887036
 |  |  |  | July | 7.123975107214906
 |  |  |  | July | 7.206922983722471
 |  |  |  | July | 6.905126899228886
 |  |  |  | July | 6.573638936985649
 |  |  |  | August | 6.794290679459399
 |  |  |  | August | 6.934690007834454
 |  |  |  | August | 6.848952253470754
 |  |  |  | August | 6.964677276440522
 |  |  |  | September | 7.3498764560206
 |  |  |  | September | 7.938867593235345
 |  |  |  | September | 8.038811931103325
 |  |  |  | September | 8.15913295232263
 |  |  |  | September | 8.37188131895717
 |  |  |  | October | 7.569080704391627
 |  |  |  | October | 7.259653865702033
 |  |  |  | October | 7.408934210334526
 |  |  |  | October | 7.059313877467066
 |  |  |  | November | 7.301651530327748
 |  |  |  | November | 7.555095921600114
 |  |  |  | November | 7.359163619232487
 |  |  |  | November | 7.128840636604012
 |  |  |  | December | 7.262136949621869
 |  |  |  | December | 7.106202092703236
 |  |  |  | December | 6.015731503406974
 |  |  |  | December | 5.287250242939352
 |  |  |  | December | 6.1612091131277
Spreadsheet: 329042d1404177046-vlookup-between-two-sheets-including-entire-row-fmsonline-wip
Sheet: Deliveries

 | SIR 5
Date | Tank | Reading |  | Delivery |  | Sales | Over/Short | Cummlative O/S
 |  | Reading* | Gallons | Gross Delivery | Net Delivery
2014-03-08 00:00:00 | Unleaded | 29.5 | 104.5 | 6000 | 6087
 | Premium | 29.5 | 35 | 501 | 509
 | Diesel | 34 | 40 | 502 | 506
Spreadsheet: 798983d1664851558-formula-to-create-number-series-book3
Sheet: Sheet1

 |  |  | 2
 |  |  | 2
 |  |  | 2
 |  |  | 2
 |  |  | 2
 |  |  | 2
 |  |  | 2
 |  |  | 2
 |  |  | 2
 |  |  | 2
 |  |  | 2
 |  |  | 2
 |  |  | 2
 |  |  | 2
 |  |  | 4
 |  |  | 4
 |  |  | 4
 |  |  | 4
 |  |  | 4
 |  |  | 4
 |  |  | 4
 |  |  | 4
 |  |  | 4
 |  |  | 4
 |  |  | 4
 |  |  | 4
 |  |  | 4
 |  |  | 4
 |  |  | 8
 |  |  | 8
 |  |  | 8
 |  |  | 8
 |  |  | 8
 |  |  | 8
 |  |  | 8
 |  |  | 8
 |  |  | 8
 |  |  | 8
 |  |  | 8
 |  |  | 8
 |  |  | 8
 |  |  | 8
 |  |  | 16
 |  |  | 16
 |  |  | 16
 |  |  | 16
 |  |  | 16
 |  |  | 16
 |  |  | 16
 |  |  | 16
 |  |  | 16
 |  |  | 16
 |  |  | 16
 |  |  | 16
 |  |  | 16
 |  |  | 16
 |  |  | 32
 |  |  | 32
 |  |  | 32
 |  |  | 32
 |  |  | 32
 |  |  | 32
 |  |  | 32
 |  |  | 32
 |  |  | 32
 |  |  | 32
 |  |  | 32
 |  |  | 32
 |  |  | 32
 |  |  | 32
 |  |  | 64
 |  |  | 64
 |  |  | 64
 |  |  | 64
 |  |  | 64
 |  |  | 64
 |  |  | 64
 |  |  | 64
 |  |  | 64
 |  |  | 64
 |  |  | 64
 |  |  | 64
 |  |  | 64
 |  |  | 64
Spreadsheet: 701705d1603893942-summing-values-in-one-column-using-vlookup-dummy-dataset-1-
Sheet: payments

Vendor Number | USD paid
5789 | 12500
5902 | 16849
4910 | 10000
5656 | 10000
4779 | 10000
4665 | 8030
4862 | 9000
6252 | EUR 3 221,00
4030 | 20000
6231 | 13006.44
5976 | 20826.44
5981 | 30534.23
5980 | 41586.07
6240 | 9900
5845 | 10770
4693 | 12500
6109 | 40340
5774
4546 | 9000
3599 | 11000
6009 | 22824
6245 | 26168.38
4855 | 5969
5201
5982 | 9350
5727 | 10682
6121 | 14320
5037 | 8000
5827 | 8000
4727 | 10000
6197 | 18210
6004 | 25000
5789 | 11500
5252 | 8000
6231 | 15000
4141 | 10000
Spreadsheet: 888541d1739057980-update-needed-to-formula-to-only-show-data-for-month-example
Sheet: January

 | Note: Rep names must be entered in exactly as they are shown in the survey report. Enter the supervisor name in the green boxes.
 | Claim Rep | Number of Promoters | Number of Detractors | Total Survey Count | Overall Score
 | [NAME]
 | [NAME]
 | [NAME]
 | [NAME]
 | [NAME]
 | [NAME]
 |  |  |  | Team Score
 | Raymi [NAME]
 | [NAME]
 | Ricardo Herrera
 | [NAME]
 | [NAME]
 | [NAME]
 |  |  |  | Team Score
 | [NAME]
 | [NAME]
 | [NAME]
 | [NAME]
 | [NAME]
 | [NAME]
 |  |  |  | Team Score
 | [NAME]
 | [NAME]
 | Alexis Jaimes
 | [NAME]
 | Alexis Jaimes
 |  |  |  | Team Score
 | Sup 5
 |  |  |  | Team Score
 | Sup 6
 |  |  |  | DRG Score
 |  |  |  | Updated 11.15.24
Spreadsheet: 157315d1337698521-how-to-sum-values-depending-on-other-columns-related-variables-please-see-example-countingconsecutive1sin4columns
Sheet: Sheet1

0 | 1 | 0 | 0
1 | 0 | 0 | 0
1 | 0 | 0 | 0
0 | 0 | 1 | 0
0 | 1 | 0 | 0
1 | 0 | 0 | 0
0 | 1 | 0 | 0
1 | 0 | 0 | 0
1 | 0 | 0 | 0
1 | 0 | 0 | 0
0 | 1 | 0 | 0
0 | 0 | 1 | 0
0 | 0 | 1 | 0
0 | 0 | 1 | 0
0 | 0 | 1 | 0
0 | 0 | 0 | 0
Spreadsheet: 477670d1472460962-please-help-conditional-formatting-and-counting-based-on-cell-color-excel-exercise
Sheet: Data

DATA
Color explanation |  | Sold |  |  | Deposit |  |  | Agency |  | Not available |  |  |  |  | Sold | Depotsit | Agency | Not available
Floor | Apartment number | Condition
5th | 5.01
 | 5.02
 | 5.03
 | 5.04
 | 5.05
 | 5.06
 | 5.07
 | 5.08
 | 5.09
 | 5.1
 | 5.11
 | 5.12
6th | 6.01
 | 6.02
 | 6.03
 | 6.04
 | 6.05
 | 6.06
 | 6.07
 | 6.08
 | 6.09
 | 6.1
 | 6.11000000000001
 | 6.12000000000001
Spreadsheet: monika_causholli__28245__consumption
Sheet: Sheet1

 | Source: RISI 2001 |  |  |  | Market Pulp Consumption By Grade
 |  |  |  |  | 2000 Apparent Consumption
 |  |  |  |  | in 000s of metric tons
 |  | Bleached Softwood | [NAME] | Sulfite | [NAME] | Semichemical | Mechanical | Total Papergrade
 | US | 4312 | 2580 | 78 | 148 | 0 | 293
 | Canada | 646 | 308 | 2 | 5 | 0 | 72
 | North America
 | Sweden | 387 | 387 | 94 | 19 | 15 | 139
 | Finland | 138 | 169 | 30 | 13 | 0 | 38
 | Norway | 102 | 72 | 35 | 4 | 1 | 14
 | Other Western Europe | 7268 | 6198 | 873 | 237 | 44 | 986
 | Eastern Europe & Russia | 369 | 329 | 191 | 62 | 75
 | Europe
 | Brazil | 263 | 599 | 27 | 57 | 0 | 60
 | Other Latin America | 741 | 292 | 3 | 41 | 0 | 104
 | Latin America
 | Japan | 1343 | 1462 | 43 | 333 | 5 | 502
 | Other Far East | 2568 | 3498 | 120 | 788 | 0 | 949
 | Asia
 | Other | 583 | 447 | 48 | 123 | 4 | 119
 | World Total
Spreadsheet: 687054d1594928941-heavy-file-for-calculation-and-save-dates
Sheet: AD Test

Sr.
 | File Name | Ext | Date | File Name | Ext | Date | File Name | Ext | Date | File Name | Ext | Date | File Name | Ext | Date
 | 03-01) 30-03-2020 | pdf |  | 12-01) 26-12-2019 | pdf |  | 03-01) 25-03-2020 | pdf
 | 04-02) 21-04-2020 | pdf
 | 05-01) 20-05-2020 | pdf
Spreadsheet: 4df2ad32-cd3d-4263-9951-1e7c35f06320
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
SEPTK | Test | SEPTK | [NAME], Known Mutation | [NAME], Known Mutation | Polymerase chain reaction (PCR) followed by DNA sequencing and/or gene dosage analysis by [NAME] probe amplification (MLPA) of SEPT9 genes is utilized to test for the presence of mutations previously identified in an affected family member. (PCR is utilized pursuant to a license agreement with Roche Molecular Systems, Inc.) | Varies: Var |  |  |  |  | This test can only be performed if a mutation has previously been identified in a family member of this individual.   [NAME] must arrive within 96 hours of draw.  	 [NAME] blood Container/Tube: Preferred: Lavender top (EDTA) or yellow top (ACD) Acceptable: Any anticoagulant [NAME]: 3 mL Collection Instructions: 1. Invert several times to mix blood. 2. Send specimen in original tube. Forms: 1. Molecular Genetics-Congenital Inherited Diseases Patient Information Sheet (Supply T521) in Special Instructions 2. 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. | 1 mL | No specimen should be rejected. If specimen not received at appropriate temperature or in wrong anticoagulant, include note to laboratory. If questions, contact laboratory. | An interpretive report will be provided. | Monday; 10 a.m. | 10 days | 16 days | 1 | 81479 |  |  |  |  | Rochester
SEPTK | [NAME] | VARIES | Varies |  |  |  | Ambient
SEPTK | Result | 33744 | [NAME] | [NAME] | Alphanumeric
SEPTK | Result | 33745 | [NAME] | [NAME] | Alphanumeric
SEPTK | Result | 33746 | Source | Source | Alphanumeric |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 31208-2 | [NAME] source:Prid:Pt:[NAME]:Nom:
SEPTK | Result | 33747 | Order Date | Order Date | Alphanumeric
SEPTK | Result | 33748 | Reason for Referral | Reason for Referral | Alphanumeric |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 42349-1 | Reason for referral:Find:Pt:^Patient:Nar:
SEPTK | Result | 33749 | Method | Method | Alphanumeric |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 49549-9 | Reference lab test method:Type:XXX:Reference lab test:Nar:
SEPTK | Result | 33750 | Result | Result | Alphanumeric
SEPTK | Result | 33751 | Interpretation | Interpretation | Alphanumeric
SEPTK | Result | 33752 | Amendment | Amendment | Alphanumeric |  |  |  |  |  |  |  |  |  |  |  |  |  |  | In Process
SEPTK | Result | 33753 | Reviewed By: | Reviewed By: | Alphanumeric
SEPTK | Result | 33754 | Release Date | Release Date | Alphanumeric