tianzl66/Sheetpedia huggingface dataset:
Spreadsheet: 708735d1607997613-how-to-obtain-the-relevant-percentage-data-and-number-problem-1215
Sheet: Sheet1

percentage %
5 |  |  |  |  | Description | QTY
10 |  | Less than 60 percent |  |  | 5,10,15,20,25,30,35,40,45,50,55 | 11
15 |  | >=60 ~ <=70 |  |  | 60,65,70 | 3
20 |  | >70 ~ <=80 |  |  | 75,80 | 2
25 |  | >80 ~ <=90 |  |  | 85,90 | 2
30 |  | >90 ~ <=100 |  |  | 95100 | 2
35
40
45
50
55
60
65
70
75
80
85
90
95
100
Spreadsheet: 736897d1623936973-need-an-alternate-to-vlookup-book6
Sheet: Sheet2

SML | 1234 | US | UK | IT | FR | DAN/GER | RUSSIA | AUSTRALIA | JAPAN | JEANS
[NAME] |  | US 0 | UK 4 | IT 36 | FR 32 | 30 | 38 | AU 4 | JP 3 | 23
XS |  | US 2 | UK 6 | IT 38 | FR 34 | 32 | 40 | AU 6 | JP 5 | 24-25
S | 0 | US 4 | UK 8 | IT 40 | FR 36 | 34 | 42 | AU 8 | JP 7 | 26-27
M | 1 | US 6 | UK 10 | IT 42 | FR 38 | 36 | 44 | AU 10 | JP 9 | 27-28
L | 2 | US 8 | UK 12 | IT 44 | FR 40 | 38 | 46 | AU 12 | JP 11 | 23-30
XL | 3 | US 10 | UK 14 | IT 46 | FR 42 | 40 | 48 | AU 14 | JP 13 | 31-32
XXL | 4 | US 12 | UK 16 | IT 48 | FR 44 | 42 | 50 | AU 16 | JP 15 | 32-33
Spreadsheet: 166509d1341603613-vlookup-issues-2nd-try-weekly-report-date-working
Sheet: MACPAC

 | Date
 | 2012-05-28 00:00:00 | Baltimore | Beckley | Martinsburg | Richmond | Salem | Washington | Asheville | Charleston | Columbia | [NAME] | Fayetteville | Hampton | Salisbury | Atlanta | Augusta | B-Ham | CAVHCS | Dublin | Tuscaloosa | MACPAC
 | Pre-Service:  IP not complete
 | Pre-Service:  OP not complete
 | Pre-Service:  MH not complete
 | Post-Service:  IP not complete
 | Post-Service:  OP not complete
 | Post-Service:  MH not complete
 | SC Determination Backlog
 | Coding Pending:  Inpatient
 | Coding Pending:  Outpatient
 | RUR Delinquetn QUIC Numbers
 | Facility Revenue Delinquent QUIC
 | ONTRAC:  Days Out
 | "Zero Scheduled Admissions":  Yes or No
 | Comments
Spreadsheet: 58862d1259142424-vlookup-from-3-different-work-sheets-vlookup-help
Sheet: Data

Ship To | Ref |  | Module | Account manager name
35668 | 5911422 |  | 1455
33195 | 5912985 |  | 5003
33195 | 5912985 |  | HIN
33195 | 5912985 |  | 8540
39343 | 5912998 |  | 8541
39343 | 5912998 |  | 8542
39343 | 5912998 |  | 8543
39343 | 5912998 |  | 5545
36767 | 5913010 |  | 1662
33540 | 5913021 |  | 6062
33540 | 5913021 |  | 1675
33540 | 5913021 |  | 6058
33540 | 5913021 |  | AC
33540 | 5913021 |  | KII
33540 | 5913021 |  | 1032
42227 | 5913077 |  | 4032
42227 | 5913077 |  | 1033
42227 | 5913077 |  | 4033
42227 | 5913077 |  | TPM
42227 | 5913077 |  | 1675
32301 | 5913080 |  | 6058
32301 | 5913080 |  | 1718
32301 | 5913080 |  | 6160
32301 | 5913080 |  | 6062
32301 | 5913080 |  | 1662
32301 | 5913080 |  | 5418
35191 | 5913088 |  | 5005
35191 | 5913088 |  | HPI
35191 | 5913088 |  | AC
35191 | 5913088 |  | 1032
42251 | 5913096 |  | 4032
42251 | 5913096 |  | 1033
42251 | 5913096 |  | 4033
42251 | 5913096 |  | TPM
42251 | 5913096 |  | 8565
32539 | 5913118 |  | 8604
32539 | 5913118 |  | SPI
32539 | 5913118 |  | 5206
34972 | 5913135 |  | 5005
34972 | 5913135 |  | HPI
34972 | 5913135 |  | 8095
33961 | 5913163 |  | SPI
33961 | 5913163 |  | 1654
34770 | 5913184 |  | 6069
34770 | 5913184 |  | 6150
34770 | 5913184 |  | 1632
34770 | 5913184 |  | 6140
34770 | 5913184 |  | 1653
34770 | 5913184 |  | 6141
34770 | 5913184 |  | 6068
34770 | 5913184 |  | 6075
34770 | 5913184 |  | 1642
34770 | 5913184 |  | 6142
34770 | 5913184 |  | KIN
34770 | 5913184 |  | AC
34770 | 5913184 |  | 6073
34770 | 5913184 |  | 1401
35668 | 5913200 |  | HII
35668 | 5913200 |  | 1768
36003 | 5913206 |  | 1655
38771 | 5913213 |  | 6056
38771 | 5913213 |  | AC
38771 | 5913213 |  | KII
38771 | 5913213 |  | 1025
1256833 | 5913368 |  | 1546
36767 | 5913400 |  | HIN
36767 | 5913400 |  | 5346
36767 | 5913400 |  | 8691
1532957 | 5913458 |  | SPI
1532957 | 5913458 |  | 866419
36003 | 5913537 |  | 1655
36003 | 5913537 |  | 6056
36003 | 5913537 |  | 1662
36003 | 5913537 |  | 6062
36003 | 5913537 |  | 1675
36003 | 5913537 |  | 6058
36003 | 5913537 |  | KII
36003 | 5913537 |  | 961706
36003 | 5913537 |  | 960770
36003 | 5913537 |  | 960540
36003 | 5913537 |  | 960102
36003 | 5913537 |  | 960089
36003 | 5913537
Spreadsheet: 704850d1605779095-editing-weekly-monthly-assignment-template-project-tracker-test
Sheet: Week View

 | ASSIGNMENTS | MONTH VIEW
 | Select Month: | Enter the Year: | Select Week No.:
 | November |  | Week 4
 | WEEK VIEW
 | SUNDAY | MONDAY | TUESDAY | WEDNESDAY | THURSDAY | FRIDAY | SATURDAY
Spreadsheet: 693201d1598858141-how-to-apply-filter-formula-for-multiple-conditions-copy-of-processing-efficiency
Sheet: WEEKLY DATA

 |  |  | SS LOOMTEX |  |  |  |  |  |  |  |  |  |  |  |  | SINGHANIA FINISHERS |  |  |  |  |  |  | SINGHANIA FINISHERS
 |  | PARTY NAME | PROCESS | [NAME] | KGS SENT |  |  |  | PARTY NAME | PROCESS | METER RECEIVED | KGS RECEIVED |  |  |  | PARTY NAME | PROCESS | [NAME] | KGS SENT |  |  |  | PARTY NAME | PROCESS | METER RECEIVED | KGS RECEIVED
2020-06-19 00:00:00 |  |  |  |  |  |  |  |  |  |  |  |  |  | 2020-06-19 00:00:00 |  |  |  |  |  |  | 2020-06-19 00:00:00
2020-06-26 00:00:00 |  |  |  |  |  |  |  |  |  |  |  |  |  | 2020-06-26 00:00:00 |  |  |  |  |  |  | 2020-06-26 00:00:00
2020-06-27 00:00:00 |  |  |  |  |  |  |  |  |  |  |  |  |  | 2020-06-27 00:00:00 |  |  |  |  |  |  | 2020-06-27 00:00:00
2020-07-04 00:00:00 |  |  |  |  |  |  |  |  |  |  |  |  |  | 2020-07-04 00:00:00 |  |  |  |  |  |  | 2020-07-04 00:00:00
2020-07-05 00:00:00 |  |  |  |  |  |  |  |  |  |  |  |  |  | 2020-07-05 00:00:00 |  |  |  |  |  |  | 2020-07-05 00:00:00
2020-07-12 00:00:00 |  |  |  |  |  |  |  |  |  |  |  |  |  | 2020-07-12 00:00:00 |  |  |  |  |  |  | 2020-07-12 00:00:00
2020-07-13 00:00:00 |  |  |  |  |  |  |  |  |  |  |  |  |  | 2020-07-13 00:00:00 |  |  |  |  |  |  | 2020-07-13 00:00:00
2020-07-20 00:00:00 |  |  |  |  |  |  |  |  |  |  |  |  |  | 2020-07-20 00:00:00 |  |  |  |  |  |  | 2020-07-20 00:00:00
 |  |  |  |  |  |  |  |  |  |  |  |  |  | 2020-07-21 00:00:00 |  |  |  |  |  |  | 2020-07-21 00:00:00
2020-07-21 00:00:00 |  |  |  |  |  |  |  |  |  |  |  |  |  | 2020-07-28 00:00:00 |  |  |  |  |  |  | 2020-07-28 00:00:00
2020-07-28 00:00:00 |  |  |  |  |  |  |  |  |  |  |  |  |  | 2020-07-29 00:00:00 |  |  |  |  |  |  | 2020-07-29 00:00:00
 |  |  |  |  |  |  |  |  |  |  |  |  |  | 2020-08-05 00:00:00 |  |  |  |  |  |  | 2020-08-05 00:00:00
2020-07-29 00:00:00 |  |  |  |  |  |  |  |  |  |  |  |  |  | 2020-08-06 00:00:00 |  |  |  |  |  |  | 2020-08-06 00:00:00
2020-08-05 00:00:00 |  |  |  |  |  |  |  |  |  |  |  |  |  | 2020-08-13 00:00:00 |  |  |  |  |  |  | 2020-08-13 00:00:00
 |  |  |  |  |  |  |  |  |  |  |  |  |  | 2020-08-14 00:00:00 |  |  |  |  |  |  | 2020-08-14 00:00:00
2020-08-06 00:00:00 |  |  |  |  |  |  |  |  |  |  |  |  |  | 2020-08-21 00:00:00 |  |  |  |  |  |  | 2020-08-21 00:00:00
2020-08-13 00:00:00 |  |  |  |  |  |  |  |  |  |  |  |  |  | 2020-08-22 00:00:00 |  |  |  |  |  |  | 2020-08-22 00:00:00
 |  |  |  |  |  |  |  |  |  |  |  |  |  | 2020-08-29 00:00:00 |  |  |  |  |  |  | 2020-08-29 00:00:00
2020-08-14 00:00:00
2020-08-21 00:00:00
2020-08-22 00:00:00
2020-08-29 00:00:00
Spreadsheet: 555699d1515700189-stats-points-tracking-for-a-disc-golf-league-golf-disc-tournament-2018-3-
Sheet: Tournament 7

 |  |  | Tournament 7 |  |  |  |  |  |  | DNP
 |  |  |  |  |  |  |  |  | # of Members Played | Did not Play | # of Players with Low Score | # of Players with MAX Score
 |  |  |  | Tournament |  | After Adjustments
 |  |  | Player | Score | Sub - Points | Actual Score | Actual Points |  | Tournament low score [NAME] (s)
 |  |  |  |  |  |  |  |  | Player | Points | Low Score
 |  |  |  |  |  |  |  | 1
 |  |  |  |  |  |  |  | 2
 |  |  |  |  |  |  |  | 3
 |  |  |  |  |  |  |  | 4
 |  |  |  |  |  |  |  | 5
 |  |  |  |  |  |  |  |  | Enter Data into the Tournament Score column only
 |  |  |  |  |  |  |  |  | Enter DNP against the Members who DID NOT PLAY
 |  | x | x | x
Spreadsheet: 707187d1607089555-vlookup-functions-to-generate-report-excel_app-copy
Sheet: Sheet2

 |  |  |  |  |  |  |  | REPORT
Table: |  |  |  |  |  |  |  | Supplier | Nature of Job | Total Amount | Total Paid | Balance
Date | Supplier | Nature of Job | Contract Amount | Payment made |  |  |  | [NAME] | Phase 1- Job 1
 | [NAME] | Phase 1- Job 1 | 50000 |  |  |  |  | [NAME] | Phase 1- Job 2
 | [NAME] | Phase 1- Job 1 |  | 5000 |  |  |  | [NAME] | Phase 2 - Job 1
 | [NAME] | Phase 1- Job 1 | 30000 |  |  |  |  | [NAME] | Phase 1- Job 1
 | [NAME] | Phase 1- Job 1 |  | 10000 |  |  |  | [NAME] | Phase 1- Job 2
 | [NAME] | Phase 1- Job 1 |  | 7000 |  |  |  | [NAME] | Phase 2 - Job 2
 | [NAME] | Phase 1- Job 2 | 70000 |  |  |  |  | [NAME] | Phase 1 - Job 3
 | [NAME] | Phase 1- Job 2 | 60000 |  |  |  |  | [NAME] | Phase 2 - Job 1
 | [NAME] | Phase 1- Job 2 |  | 20000
 | [NAME] | Phase 1 - Job 3 | 25000
 | [NAME] | Phase 1- Job 2 |  | 13000
 | [NAME] | Phase 2 - Job 1 | 15000
 | [NAME] | Phase 1- Job 2 |  | 5000
 | [NAME] | Phase 1- Job 1 |  | 8000
 | [NAME] | Phase 1- Job 1 |  | 6500
 | [NAME] | Phase 1 - Job 3 |  | 2500
 | [NAME] | Phase 2 - Job 1 | 45000
 | [NAME] | Phase 2 - Job 2 | 35000
 | [NAME] | Phase 2 - Job 1 |  | 7500
 | [NAME] | Phase 1 - Job 3 |  | 4500
 | [NAME] | Phase 2 - Job 2 |  | 6500
 | [NAME] | Phase 2 - Job 1 |  | 5500
Spreadsheet: 126289d1319616876-macro-to-ignore-or-only-recognise-certain-characters-in-a-range-mdbaker85-workbook
Sheet: BLOGGS

EXAMPLE 1
BLOGGS
 | 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 |  |  | Projected Qual Date
OCT |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 2011-12-26 00:00:00
NOV
DEC
JAN
FEB
Spreadsheet: 144974d1331230400-auto-fill-data-from-multiple-sheets-ex-schedual_mahju
Sheet: emp1

Monthy Days to work
 | Cashier | [NAME] | [NAME]
2012-03-08 00:00:00
2012-03-09 00:00:00
2012-03-10 00:00:00
2012-03-11 00:00:00
2012-03-12 00:00:00
2012-03-13 00:00:00
2012-03-14 00:00:00
2012-03-15 00:00:00
Spreadsheet: 848800d1699444210-ways-to-make-workbook-set-up-more-efficient-run-faster-081123-example
Sheet: Project name

Hidden tab | Drop down | Drop down | Free text | Drop down | Drop down | Free text | Hidden tab | Auto generated |  | Hidden tab
Helper | Region | Team | Name of project | Priority | Project Type | Number of tasks | Asset type | Project name | Folder name | Project number
1 | US | Team 1 | Project 1 | Low | Solo | 2 | Project |  |  | 1
 | India | Team 3 | Project 2 | Medium | Collaborative | 3 | Project |  |  | 2
 | APAC | Team 2 | Project 3 | High | Collaborative | 4 | Project |  |  | 3
 |  |  |  |  |  |  | Project |  |  | 4
 |  |  |  |  |  |  | Project |  |  | 5
 |  |  |  |  |  |  | Project |  |  | 6
 |  |  |  |  |  |  | Project |  |  | 7
 |  |  |  |  |  |  | Project |  |  | 8
 |  |  |  |  |  |  | Project |  |  | 9
 |  |  |  |  |  |  | Project |  |  | 10
 |  |  |  |  |  |  | Project |  |  | 11
 |  |  |  |  |  |  | Project |  |  | 12
 |  |  |  |  |  |  | Project |  |  | 13
 |  |  |  |  |  |  | Project |  |  | 14
 |  |  |  |  |  |  | Project |  |  | 15
 |  |  |  |  |  |  | Project |  |  | 16
 |  |  |  |  |  |  | Project |  |  | 17
 |  |  |  |  |  |  | Project |  |  | 18
 |  |  |  |  |  |  | Project |  |  | 19
 |  |  |  |  |  |  | Project |  |  | 20
 |  |  |  |  |  |  | Project |  |  | 21
 |  |  |  |  |  |  | Project |  |  | 22
 |  |  |  |  |  |  | Project |  |  | 23
 |  |  |  |  |  |  | Project |  |  | 24
 |  |  |  |  |  |  | Project |  |  | 25
 |  |  |  |  |  |  | Project |  |  | 26
Spreadsheet: 142366d1329794585-find-all-occurrences-of-a-name-in-one-column-and-return-data-from-other-columns-sample-5-copy
Sheet: Sheet1

 | Data |  |  |  | Output
 | Name | Create Date | Delivered Date |  | Name | Report 1 |  | Report 2 |  | Report 3
 | [NAME] | 2012-01-12 00:00:00 | 2012-01-13 00:00:00 |  |  | Created | Delivered | Created | Delivered | Created | Delivered
 | [NAME] | 2012-01-08 00:00:00 | 2012-01-09 00:00:00 |  | [NAME]
 | [NAME] | 2012-01-17 00:00:00 | 2012-01-18 00:00:00 |  | [NAME]
 | [NAME] | 2012-01-03 00:00:00 | 2012-01-04 00:00:00 |  | [NAME]
 | [NAME] | 2012-01-07 00:00:00 | 2012-01-08 00:00:00 |  | [NAME]
 | Fred | 2012-01-21 00:00:00 | 2012-01-22 00:00:00 |  | [NAME]
 | [NAME] | 2012-01-04 00:00:00 | 2012-01-05 00:00:00 |  | Fred
 | Sue | 2012-01-10 00:00:00 | 2012-01-11 00:00:00 |  | Sue
 | Sue | 2012-01-02 00:00:00 | 2012-01-03 00:00:00 |  | Julie
 | Fred | 2012-01-05 00:00:00 | 2012-01-06 00:00:00
 | Fred | 2012-01-13 00:00:00 | 2012-01-14 00:00:00 |  | this is the formula
 | [NAME] | 2012-01-11 00:00:00 | 2012-01-12 00:00:00
 | Sue | 2012-01-18 00:00:00 | 2012-01-19 00:00:00 |  | IF(ISERROR(VLOOKUP("Mary1",$A$1:$D$100,3,FALSE)),"",VLOOKUP("Mary1",$A$1:$D$100,3,FALSE))
 | [NAME] | 2012-01-19 00:00:00 | 2012-01-20 00:00:00
 | Julie | 2012-01-22 00:00:00 | 2012-01-23 00:00:00 |  | change the "Mary1" with appropriate name:"
 | Julie | 2012-01-06 00:00:00 | 2012-01-07 00:00:00
 | [NAME] | 2012-01-15 00:00:00 | 2012-01-16 00:00:00
 | [NAME] | 2012-01-20 00:00:00 | 2012-01-21 00:00:00
 | [NAME] | 2012-01-16 00:00:00 | 2012-01-17 00:00:00
 | [NAME] | 2012-01-09 00:00:00 | 2012-01-10 00:00:00
 | Julie | 2012-01-14 00:00:00 | 2012-01-15 00:00:00
 | [NAME] | 2012-01-01 00:00:00 | 2012-01-02 00:00:00
this is helper column can be hidden
Spreadsheet: 674803d1588019760-matrix-of-ifs-to-generate-a-set-of-characters-and-finally-join-these-characters-multiple-ifs-bittubadri-
Sheet: Sheet1

 |  | 33 |  | i | i p h |  | i | 1
 |  | 55 |  |  |  |  | i | 2
 |  |  |  |  |  |  | i
 |  |  |  |  |  |  | i
 |  |  |  |  |  |  | i
 |  |  |  |  |  |  | i
 |  |  |  |  |  |  | i
 |  |  |  |  |  |  | i
 |  |  |  |  |  |  | i
 |  |  |  |  |  |  | i
 |  |  |  |  |  |  | i
 |  |  |  |  |  |  | i
 |  |  |  |  |  |  | i
 |  | 11 |  | p |  |  | i p | 3
 |  | 55 |  |  |  |  | i p | 4
 |  | 22 |  | h |  |  | i p h | 5
Spreadsheet: sally_beck__33769__DEAL BREAKDOWN ANALYSIS 09-06-00 EM
Sheet: PHYSICAL

ENRON North American Gas - EOL vs NON-EOL Analysis
PHYSICAL
LTD
REGION | REGION |  | DEAL COUNT | % OF TOTAL DEAL COUNT | VOLUME | % OF TOTAL VOLUME | NOTIONAL VALUE | % OF TOTAL NOTIONAL VALUE
CENTRAL | EOL |  | 47871 | 79.69600612649208 | 775809963 | 38.36472592702072 | 2715688651.090762 | 39.67663990281335
 | NON-EOL |  | 12196 | 20.30399387350792 | 1246386062.78625 | 61.63527407297929 | 4128864359.806214 | 60.32336009718665
 | TOTAL |  | 60067 |  | 2022196025.78625 |  | 6844553010.896976
EAST | EOL |  | 32307 | 59.03409713847167 | 949227388 | 18.74775983281362 | 3786313762.113601 | 21.32645757055947
 | NON-EOL |  | 22419 | 40.96590286152834 | 4113923604.251335 | 81.25224016718637 | 13967754158.38573 | 78.67354242944053
 | TOTAL |  | 54726 |  | 5063150992.251335 |  | 17754067920.49933
ECC-CANADA WEST | EOL |  | 30735 | 71.13759981483625 | 2402075563.464041 | 59.33526947383487 | 7632980082.576266 | 59.26972838081988
 | NON-EOL |  | 12470 | 28.86240018516376 | 1646234294.677391 | 40.66473052616512 | 5245398629.627103 | 40.73027161918012
 | TOTAL |  | 43205 |  | 4048309858.141431 |  | 12878378712.20337
ENA-CANADA EAST | EOL |  | 2374 | 47.78582930756844 | 297132946.011 | 40.44624527099079 | 1079223379.565016 | 43.20067412201943
 | NON-EOL |  | 2594 | 52.21417069243156 | 437503715.6128474 | 59.5537547290092 | 1418939904.917007 | 56.79932587798056
 | TOTAL |  | 4968 |  | 734636661.6238475 |  | 2498163284.482023
G-DAILY-EST | EOL
 | NON-EOL
 | TOTAL
NG-PRICE | EOL |  | 1 | 0.5263157894736842 | 10000 | 0.00139020745237275 | 27000 | 0.0009945531673115969
 | NON-EOL |  | 189 | 99.47368421052632 | 719307105.007055 | 99.99860979254763 | 2714759990.522027 | 99.99900544683268
 | TOTAL |  | 190 |  | 719317105.007055 |  | 2714786990.522027
TEXAS | EOL |  | 4734 | 43.74018294373094 | 148591668 | 9.271047579115594 | 565772210.3215001 | 9.942861013629956
 | NON-EOL |  | 6089 | 56.25981705626906 | 1454157824.244272 | 90.7289524208844 | 5124463321.945555 | 90.05713898637005
 | TOTAL |  | 10823 |  | 1602749492.244272 |  | 5690235532.267055
WEST | EOL |  | 23204 | 71.11465260964172 | 270919860 | 21.22343770996399 | 1107388626.642 | 24.08380334573871
 | NON-EOL |  | 9425 | 28.88534739035827 | 1005592756.393 | 78.77656229003601 | 3490675104.176234 | 75.9161966542613
 | TOTAL |  | 32629 |  | 1276512616.393 |  | 4598063730.818233
TOTAL | EOL |  | 141226 | 68.35456516688609 | 4843767388.47504 | 31.31704428111897 | 16887393712.30915 | 31.87608872160686
 | NON-EOL |  | 65382 | 31.64543483311392 | 10623105362.97215 | 68.68295571888103 | 36090855469.37987 | 68.12391127839315
 | TOTAL |  | 206608 |  | 15466872751.44719 |  | 52978249181.68901
Spreadsheet: 778720d1651243101-vlookup-other-formula-adv-filter-using-or
Sheet: Sheet1

Raw data |  |  |  |  |  |  |  | Require table
Name | Code | [NAME] | Category | Current Nos | Past Numbers | Region |  | Name | Code | [NAME] | Category | Current Nos
ABC Comp | COMP | ABC | A | 61 | 53 | NY |  | ABC Comp | COMP | ABC | A | 61
[NAME] | KGN | ABC | A | 76 | 90 | NY |  | [NAME] | KGN | ABC | A | 76
Digital Edge | [NAME] | LMN | C | 2 | 9 | SC |  | Spring Solutions | SPRIN | ABC | B | 5
Solutions | SOL12 | LMN | B | 11 | 15 | SC |  | Others |  | ABC | C | 2
Computers | PC345 | LMN | A | 15 | 8 | SC |  | Computers | PC345 | LMN | A | 15
Spring Solutions | SPRIN | ABC | B | 5 | 10 | NY |  | Solutions | SOL12 | LMN | B | 11
Sun Computer | Sun001 | LMN | C | 1 | 5 | SC |  | Others |  | LMN | C | 3
Soft Sol | SOFT | ABC | C | 1 | 3 | NY
Zebra sys | ZEBRA | ABC | C | 1 | 7 | NY
 |  |  |  |  |  |  |  | Name | Code | [NAME] | Category | Current Nos
 | Advanced Filter data above. |  |  |  |  | [NAME]> |  | Digital Edge
 |  |  |  |  |  |  |  | Zebra sys
 |  |  |  |  |  | Answer >>> |  | Name | Code | [NAME] | Category | Current Nos
 |  |  |  |  |  |  |  | Digital Edge | [NAME] | LMN | C | 2
 |  |  |  |  |  |  |  | Zebra sys | ZEBRA | ABC | C | 1
Spreadsheet: 15f96759-1b9c-4674-9a8a-7d8b88280454
Sheet: Sheet1

Program | Flow Rate of Sample Column #1 | Flow Rate of Sample Column #2 | Volume of Sample (in mL) | Time for separation*Including 2.5min for QRinse between samples
POSSEL | 4mL/min |  | 1
POSSEL_S | 1mL/min |  | 1
POSSELD | 4mL/min | 1mL/min | 1
POSSELD2 | 4mL/min | 4mL/min | 1
POSSELDS | 1mL/min | 1mL/min | 1
POSSELWB** | 4mL/min | 4mL/min | 1
DEPLETE | 4mL/min |  | 1
DEPLETES | 1mL/min |  | 1
DEPLETE05 | 0.5mL/min |  | 1
DEPLETE025 | 0.25mL/min |  | 1
**Program automatically dilutes sample 3:1
*None of these times including the autolabeling.  To judge time per sample with autolabeling,
you must know the incubation time of the Microbeads or other reagents needed and add that time.
Spreadsheet: 207897d1358603142-check-if-the-values-of-a-list-are-in-progressive-order-copy-of-example
Sheet: Sheet1

String | Result |  | What the string is checked as
0 1 0 14 18 3 3 0 0 0 0 0 1 | 0 |  | 1 14 18 3 3 1
0 19 0 20 18 10 10 3 1 1 1 0 1 | 0 |  | 19 20 18 10 10 3 1 1 1 1
0 1 1 0 0 3 3 0 9 6 6 0 9 | 0 |  | 1 1 3 3 9 6 6 9
1 1 1 0 0 3 3 0 6 8 8 0 9 | 1 |  | 1 1 1 3 3 6 8 8 9
2 1 1 0 0 3 3 0 6 8 8 0 9 | 0 |  | 2 1 1 3 3 6 8 8 9
0 15 2 0 13 7 0 1 0 0 0 1 1 | 0 |  | 15 2 13 7 1 1 1
Spreadsheet: 789386d1659076890-index-match-with-three-criteria-one-of-them-being-the-max-value-indexmatch3criteria
Sheet: Tabelle7

 | ID | FileID | TNA | No |  | ID | 23097
 | 23097 | [PHONE]-10-000046 | 266.9 | 2937 |  | File | [PHONE]-10-000046
 | 23097 | [PHONE]-10-000046 | 207.2 | 2938 |  | TNA | MAX
 | 23097 | [PHONE]-11-000022 | 152.6 | 3227 |  | No
 | 23097 | [PHONE]-12-008765 | 323.4 | 2939
 | 23097 | [PHONE]-12-008765 | 90.8 | 3228
Spreadsheet: 709562d1608391157-change-formula-to-ignore-hidden-tabs-programme-test
Sheet: Site total

Item Name | Price | 52 | 53 | 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 | 32 | 33 | 34 | 35 | 36 | 37 | 38 | 39 | 40 | Total | Totals
Product 1 | 0.05
Product 2 | 0.1
Product 3 | 0.15
Product 4 | 0.2
Product 5 | 0.25
Product 6 | 0.3
Product 7 | 0.35
Product 8 | 0.4
Product 9 | 0.45
Product 10 | 0.5
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | @ |  | 0.0001 |  |  |  |  |  | Pol:
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | + 20% VAT
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | Total:
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | Block | Area | Area | Perimeter (glass/path)
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | Block 1 | 23490 | A | 950
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | Block 2 | 6441 | B | 840
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | Block 3 | 5698 | C | 420
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | Block 4 | 8728 | D | 1120
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | Block 5 | 2508 | E | 400
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | Block 6 | 13440 | F | 760
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | Block 7 | 14976 | G | 820
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | Block 8 | 14940 | H | 820
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | Block 9 | 5455 | I | 430
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | Block 10 | 5698 | J | 430
Spreadsheet: 878786d1726062588-conditional-formatting-pairs-cond-form
Sheet: main

Raw data |  |  | expected result
145677 |  |  | 145677
145677 |  |  | 145677
145677 |  |  | 145677
145677 |  |  | 145677
145677 |  |  | 145677
145677 |  |  | 145677
101014 |  |  | 101014
101014 |  |  | 101014
197545 |  |  | 197545
197545 |  |  | 197545
197545 |  |  | 197545
162936 |  |  | 162936
162936 |  |  | 162936
197593 |  |  | 197593
197593 |  |  | 197593
198661 |  |  | 198661
198661 |  |  | 198661
122073 |  |  | 122073
122073 |  |  | 122073
Spreadsheet: 119002d1314128695-assign-values-to-dropdown-menu-selections-reference-doc
Sheet: Sheet3

Dropdown Table
Wellness
TDS
[NAME]
[NAME]
Open
Wellness | Choice 1 | Choice 2
Percentage 1 | 0.24 | 0.35
Percentage 2 | 0.36 | 0.25
Percentage 3 | 0.58 | 0.24
Percentage 4 | 0.6 | 0.68
Percentage 5 | 0.21 | 0.68
Percentage 6 | 0.2 | 0.68
TDS
Percentage 1 | 0.33 | 0.35
Percentage 2 | 0.35 | 0.25
Percentage 3 | 0.78 | 0.24
Percentage 4 | 0.65 | 0.68
Percentage 5 | 0.46 | 0.1
Percentage 6 | 0.6 | 0.8
[NAME]
Percentage 1 | 0.2 | 0.45
Percentage 2 | 0.6 | 0.87
Percentage 3 | 0.54 | 0.35
Percentage 4 | 0.28 | 0.25
Percentage 5 | 0.69 | 0.24
Percentage 6 | 0.2 | 0.68
[NAME]
Percentage 1 | 0.45 | 0.1
Percentage 2 | 0.22 | 0.35
Percentage 3 | 0.39 | 0.25
Percentage 4 | 0.85 | 0.24
Percentage 5 | 0.2 | 0.68
Percentage 6 | 0.1 | 0.69
Spreadsheet: 299305d1393100416-first-payment-of-each-group-thau-khoan-ver2
Sheet: Ct

 |  |  |  |  |  |  |  | thu
Payment [NAME]
No | id | id code | Date | Content | Contract | Settlement |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | Tổng
 |  |  |  | Tổng