tianzl66/Sheetpedia huggingface dataset:
Spreadsheet: 0564c017-2f61-42dd-9481-f7ce18fab1a0
Sheet: Sheet1

Calendar weeks | 8/25-8/29 | 9/1-9/5 | 9/8-9/12 | 9/15-9/19 | 9/22-9/26 | 9/29-10/3 | 10/6-10/10 | 10/13-10/17 | 10/20-10/24 | 10/27-10/31 | 11/3-11/7 | 11/10-11/14 | 11/17-11/21 | 11/24-11/28 | 12/1-12/5 | 12/8-12/12
Week of term | 1 | 2 | 3 | 4 | 5 | 6 | 7 | 8 | 9 | 10 | 11 | 12 | 13 | 14 | 15 | Exams
UMW Calendar | UMW Classes begin |  |  |  |  |  |  |  |  |  |  |  |  | Thanksgiving break Wed 11/26-11/28
Public School Calendar | Teachers' work week in Stafford and Spotsy. | Students' first week of school starting on Tues. 9/3
Internship--EDUC 536 | x - Students in school for 5 hours (determine schedule with your MT) | Students in school full time on [NAME]. and Wed. | Students not in school; schedule and develop unit plan with MT and US. |  |  |  | Students in school full time all week; Conduct impact study (midterm eval-formal- 1 full lesson, MT and US) | Students in school full time all week | Students in school full time all week (self evaluation-video tape lesson) | Students in school full time all week (final evaluation-formal- 1 full lesson-MT and US) | Students not in school; impact study due to US. |  |  |  |  | Begin plan for spring semester student teaching
EDUC 531 (4-6:45, [NAME]) |  |  | no class this week | no class this week; communicate with MT about research project ideas. |  | annotated bibliography due | Class online | Class online; begin work on literature review | Class online | Class online |  | literature review due | methods due | final proposal draft due | IRB due by 12/1 | Present action research project proposal
EDUC 535 (1-3:45, [NAME]) |  | online class this week |  |  |  |  | NO CLASS
EDUC 515** (6-8:40, Thurs) |  |  |  |  |  |  |  |  |  |  |  |  |  | no class
*classes meet as scheduled | **only for students who | # Credits | Clock Hours necessary | Hours in school (about 6.5 hours per day)
unless noted | have not |  |  | Week1 | Week 2 | Week 7 | Week 8 | Week 9 | Week 10 | TOTAL HOURS
above | taken it | 5 | 30 hrs/credit = 150 hrs. | 5 | 13 | 33 | 33 | 33 | 33
Spreadsheet: 219187d1362679444-automatically-updating-multiple-sheets-to-a-master-sheet-master-test
Sheet: 6.

Test |  |  |  |  |  |  | Target |  | Actual |  |  |  |  | 2011 |  |  |  |  |  |  |  |  |  |  |  | 2012 |  |  |  |  |  |  |  |  |  |  |  | 2013 |  |  |  |  |  |  |  |  |  |  |  | 2014
Activity | Core | Stream | Task | Milestone | Accountable | External | Start | End | Actual | Actual End Date | Status | Funding | Notes/Location | Jan | Feb | Mar | Apr | May | Jun | Jul | Aug | Sep | Oct | Nov | Dec | Jan | Feb | Mar | Apr | May | Jun | Jul | Aug | Sep | Oct | Nov | Dec | Jan | Feb | Mar | Apr | May | Jun | Jul | Aug | Sep | Oct | Nov | Dec | Jan | Feb | Mar | Apr | May | Jun | Jul | Aug | Sep | Oct | Nov | Dec
6 | Main Title
6.1 | Title
6.1
6.1
6.1
6.1
6.1
6.1
6.1
6.1
6.1
6.1
6.2 | Title
6.2
6.2
6.2
6.3 | Title
6.3
6.3
Spreadsheet: 791177d1660198406-percentage-by-procedure-code-group-and-year-2022-08-11-oeldere-brawnystaff-percent_breakdown
Sheet: After

Group | Procedure | 2016 | 2017 | 2018 | 2019 | 2020 | 2021 | 2022
1 | 88711 | 0.0603 | 0.0623 | 0.0458 | 0.0408 | 0.0447 | 0.0441 | 0.0442 |  |  |  | Rijlabels | Som van 2016
1 | 88712 | 0.2549 | 0.2375 | 0.2249 | 0.2136 | 0.2106 | 0.1967 | 0.1641 |  |  |  | 1 | 0.03049650279690906
1 | 88713 | 0.6848 | 0.7001 | 0.7293 | 0.7456 | 0.7447 | 0.7592 | 0.7917 |  |  |  | 88711 | 0.06030504153663575
2 | 46511 | 0.0725 | 0.0726 | 0.0687 | 0.0679 | 0.0624 | 0.0661 | 0.0699 |  |  |  | 88712 | 0.2548898949496726
2 | 46512 | 0.2679 | 0.2611 | 0.256 | 0.25 | 0.2381 | 0.2463 | 0.2393 |  |  |  | 88713 | 0.6848050635136917
2 | 46513 | 0.6596 | 0.6663 | 0.6753 | 0.6821 | 0.6995 | 0.6876 | 0.6908 |  |  |  | 2 | 0.1776686137846445
3 | 72312 | 0.0759 | 0.0605 | 0.0736 | 0.0596 | 0.0749 | 0.0591 | 0.0816 |  |  |  | 46511 | 0.07250655755432774
3 | 72313 | 0.4338 | 0.4829 | 0.3927 | 0.3938 | 0.3797 | 0.3776 | 0.3734 |  |  |  | 46512 | 0.2679103595526528
3 | 72314 | 0.4902 | 0.4565 | 0.5337 | 0.5466 | 0.5455 | 0.5632 | 0.545 |  |  |  | 46513 | 0.6595830828930195
4 | 23523 | 0.0536 | 0.0539 | 0.052 | 0.0503 | 0.0473 | 0.0394 | 0.0378 |  |  |  | 3 | 0.01380392008274667
4 | 23524 | 0.4954 | 0.4809 | 0.4724 | 0.458 | 0.4336 | 0.4232 | 0.4158 |  |  |  | 72312 | 0.07593707516022528
4 | 23525 | 0.451 | 0.4652 | 0.4756 | 0.4917 | 0.5191 | 0.5374 | 0.5464 |  |  |  | 72313 | 0.4338382857512786
5 | 65911 | 0.0846 | 0.1127 | 0.1156 | 0.0828 | 0.0946 | 0.0873 | 0.0698 |  |  |  | 72314 | 0.4902246390884962
5 | 65912 | 0.3623 | 0.3818 | 0.3943 | 0.3867 | 0.3162 | 0.3032 | 0.3159 |  |  |  | 4 | 0.7021925105757894
5 | 65913 | 0.5532 | 0.5054 | 0.4901 | 0.5305 | 0.5892 | 0.6095 | 0.6143 |  |  |  | 23523 | 0.05362289394876609
6 | 99211 | 0.2566 | 0.2362 | 0.2153 | 0.2035 | 0.1882 | 0.1786 | 0.1589 |  |  |  | 23524 | 0.4954111831963995
6 | 99212 | 0.7434 | 0.7638 | 0.7847 | 0.7965 | 0.8118 | 0.8214 | 0.8411 |  |  |  | 23525 | 0.4509659228548345
 |  |  |  |  |  |  |  |  |  |  |  | 5 | 0.003143794319356689
 |  |  |  |  |  |  |  |  |  |  |  | 65911 | 0.08456509380329733
 |  |  |  |  |  |  |  |  |  |  |  | 65912 | 0.3622797043774872
 |  |  |  |  |  |  |  |  |  |  |  | 65913 | 0.5531552018192155
 |  |  |  |  |  |  |  |  |  |  |  | 6 | 0.07269465844055381
 |  |  |  |  |  |  |  |  |  |  |  | 99211 | 0.2565782599342328
 |  |  |  |  |  |  |  |  |  |  |  | 99212 | 0.7434217400657672
 |  |  |  |  |  |  |  |  |  |  |  | Eindtotaal | 1
Spreadsheet: 69211d1269726960-colouring-numbers-vehicle-status-chart-v3
Sheet: Sheet1

Vehicle Status Chart
Fully Charged |  |  |  |  |  |  | Flat
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  | Helper Columns
1 | 2 |  |  |  | 6 |  |  |  |  |  |  |  |  |  | 1 | 2 | 3 | 4 | 5 | 6
 |  | 9 | 10 |  |  |  |  |  |  |  |  |  |  |  | 7 | 8 | 9 | 10 | 11 | 12
 | 14 |  |  |  |  |  |  |  |  |  |  |  |  |  | 13 | 14 | 15 | 16 | 17 | 18
 |  |  |  |  | 24 |  |  |  |  |  |  |  |  |  | 19 | 20 | 21 | 22 | 23 | 24
Spreadsheet: d8d26f0c-4aad-40bf-abe1-64ad71374340
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
LDLM | Test | LDLM | Familial Hypercholesterolemia, LDLR Large Deletion/Duplication, Molecular Analysis | [NAME] | Dosage Analysis by [NAME] (MLPA) | Lavendar-top (EDTA) Tube: EDTA (<1 month old infant) |  |  | 3 | mL | Multiple cardiovascular-related gene sequencing tests can be performed on a single specimen after a single extraction. See Multiple Cardiovascular-Related Gene Sequencing Tests in Special Instructions for a list of tests that can be ordered together.  Container/Tube: Lavender top (EDTA) [NAME]: 3 mL  Collection Instructions: Send specimen in original tube. Additional Information: 1. Include physician name and phone number with the specimen. 2. Transfusions will interfere with testing for up to 4 to 6 weeks. DNA obtained from white cells may not provide useful information for patients who received a recent transfusion of blood that was not leukocyte-reduced. Wait 4 to 6 weeks until transfused cells have left the patient's circulation before drawing the patient's blood specimen for genotype testing. Forms: 1. Familial/Autosomal Dominant Hypercholesterolemia Patient Information Sheet (Supply T637) 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. | 0.5 mL | Hemolysis	NA Thawing	NA Lipemia	NA Icterus	NA Other	NA | An interpretive report will be provided. | Varies | 5 days | 10 days | 1 | 81405 |  |  |  |  | Rochester
LDLM | [NAME] | WBEDTA | [NAME] EDTA |  |  |  | Ambient
LDLM | Result | 28486 | Interp | Interp | Alphanumeric |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 69047-9 | Service comment 01:Imp:Pt:[NAME]:Nom:
LDLM | Result | 15598 | Comment | Comment | Alphanumeric |  |  |  |  |  |  |  |  |  |  |  |  |  |  | In Process
LDLM | Result | 28487 | Reviewed By | Reviewed By | Numeric
LDLM | Result | 31629 | Result | Result | Alphanumeric |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 69485-1
Spreadsheet: 739750d1625914334-sum-of-values-fundraising
Sheet: Fundraising

 | Category
105 | Recipe book sales
185 | Recipe book sales
5 | Recipe book sales
201.04 | Recipe book sales
75 | Recipe book sales
50 | Recipe book sales
20 | Recipe book sales
90 | Memorial & Wedding Donations
5 | Recipe book sales
10 | Recipe book sales
10 | Recipe book sales
30 | Recipe book sales
177 | General Donation
35 | Recipe book sales
15 | Recipe book sales
10 | Recipe book sales
10 | Recipe book sales
40 | Recipe book sales
45 | Recipe book sales
15 | Recipe book sales
110 | Cream teas
160.7 | Cream teas
30 | Donation
103.25 | Cream teas
25 | Recipe book sales
158.5 | Donation
15 | Recipe book sales
220.7 | Cream teas
30 | Donation
148.2 | Cream teas
20 | Recipe book sales
124.6 | Cream teas
62 | Cream teas
51 | Cream teas
10 | Recipe book sales
5 | Recipe book sales
Spreadsheet: 806591d1669400654-match-partial-or-complete-text-and-match-in-another-column-to-extract-index-value-help-4-ans
Sheet: INDEX-MATCH1 (3)

 |  |  | need to match partial title and chn and bring value from index column
 | Employee |  |  | =INDEX(F$7:F$11,MATCH(TRUE,ISNUMBER(SEARCH(B$6:[NAME]))
 | title | chn | index value | current formula I have | lookup data
 | [NAME] | AAA |  |  | index value | chn
 | Siyan | GGG |  |  | Kaisi | AAA
 | Farq E | AAA |  |  | siyani | GGG
 | Epilet habs | AAA |  |  | farq | AAA
 | magar | HHH |  |  | habs | AAA
 | [NAME] | GGG |  |  | agar | GGG
 | [NAME] | AAA |  |  | [NAME] | GGG
 | [NAME] | GGG
Spreadsheet: 46508d1245341997-merging-multiple-sets-of-cells-in-one-go-dummy
Sheet: Sheet1

333 | 2 | 333 2
333 | 4 | 4
333 | 7 | 7
324 | 11 | 324 11
324 | 17 | 17
325 | 8 | 325 8
325 | 9 | 9
325 | 17 | 17
325 | 21 | 21
325 | 13 | 13
325 | 31 | 31
325 | 27 | 27
Spreadsheet: marie_heard__24504__IspatmexicanaISDA071101
Sheet: ANEWSWP2

ISDA SWAP AGREEMENT INFORMATION SHEET
 |  | ATTORNEY:
DATE: |  | DEAL MAKER: | [NAME]
COUNTERPARTY: | Ispat Mexicana S.A. de C.V. | CONTACT:
ADDRESS: |  | TITLE:
 |  | PHONE:
 |  | FAX:
Incorporation State |  | S&P Rating
STRUCTURE | COUNTERPARTY | ENA
GUARANTOR (RATING) |  | Enron Corp.
LIMIT $ MILLIONS |  | 15
Incorporation State |  | OR
ELEGIBLE SWAP PARTICIPANT
Counterparty | X
Guarantor |  | X
COLLATERAL  THRESHOLD MATRIX in $ MILLIONS
based on S & P and
Moody's ratings | BB-
 | 5 | 10
Specify Type of Debt:
COLLATERAL TYPE
Letter of Credit | X | X
Cash | X | X
Treasuries/Maturity limit
MINIMUM TRANSFER $ | 0 | 0
COLLATERAL ROUNDING
Delivery Amount | 250000 | 50000
Return Amount | 250000 | 50000
HOLDING and USE OF COLLATERAL
Permitted |  | X
Minimum S & P/Moody's
rating permitted
MATERIAL ADVERSE CHANGE TRIGGERS - if Matrix not applicable
APPLY TO:
-Counterparty | X
-Guarantor |  | X
Debt Ratings Change |  | X
-Below = S&P/Moody's | BB- | BBB-
Financial Covenants
-Funded Debt to Worth
-Minimum Net Worth
-EBITDA/Interest Expense | 1.4x
-Funded Debt / EBITDA
Non-Specific
-Unilateral | X
Non-Standard Definitions
-Funded Debt
-Net Worth
EVENTS OF DEFAULT
3rd party debt | X | X
-Counterparty ($[NAME]) | 25
-Guarantor ($[NAME]) |  | 100
Change in ownership
SPECIFIED ENTITY
FINANCIAL STATEMENTS
-Standard | X | X
- Request financials on:
CREDIT DECISION: | APPROVED :  X | DECLINED:
OUTSTANDING SWAP TRANSACTIONS: |  | YES: | NO:
ALL SWAPS TO ROLL UP UNDER NEW MASTER: |  | YES: | NO:
CREDIT PROVISIONS OF MASTER TO GOVERN: |  | YES: | NO:
OTHER COMMENTS:
GLOBAL CREDIT:  Please complete the attached form below if the following conditions exist:
A)  No previous guidance limit exists or .....
B)  The proposed contractual limits exceed the existing guidance limits.
CREDIT REVIEW  PREPARED BY: |  | [NAME] | x54842
Spreadsheet: 274847d1383235170-how-to-get-index-to-search-two-different-columns-returnmatchingmonths
Sheet: Sheet1

2013-05-01 00:00:00 | A | B | 1 | 2013-06-01 00:00:00 | Test 1 |  | 6 | <-- Month required
2013-05-01 00:00:00 | A | B | 2 | 2013-07-13 00:00:00 | Test 2
2013-06-01 00:00:00 | A | B | 3 | 2013-08-04 00:00:00 | Test 3
2013-06-01 00:00:00 | A | B | 4 | 2013-06-16 00:00:00 | Test 4
 | =IFERROR(INDEX($F$1:$F$4,SMALL(IF((MONTH($A$1:$A$4)=$H$1)+ (MONTH($E$1:$E$4)=$H$1), ROW($A$1:$A$4),""),ROWS($A$1:$A1))),"")
Spreadsheet: 153330d1335875553-calculation-of-text-and-numbers-claims
Sheet: Mny

Policy | CLAIMS |  |  |  | TOTAL CLAIMS |  | DEDUCTIBLE/ | Claims Recorded At Nil
Year | Paid |  | Oustanding |  |  |  | EXCESS
 | No. | Amount | No. | Amount | No. | Amount | APPLICABLE
 | 0 | Nil | 0 | Nil
 | 0 | Nil | 0 | Nil
 | 0 | Nil | 0 | Nil
 | 0 | Nil | 0 | Nil
 |  | Not Insured
TOTALS
Spreadsheet: 106145d1303350012-simultaneous-updating-worksheets-overdue-ageing
Sheet: WH-2

NAME OF THE COMPANY |  |  | ABC & CO
 |  |  | WAREHOUSE-2
DETAILS OF AGE-WISE DEBTORS REPORT AS ON |  |  | 2011-04-15 00:00:00
Name of the Party | Party Status | Invoice Date | Invoice No. | Credit Period | Due Date | Delay (Days) | Invoice Amount | Outstanding Invoice Amount (Rs.) | < 0 | <0 - 30> | <31 - 60> | <61 - 90> | <91 - 120> | <121 - 150> | <151 - 180> | > 180 Days
JUMANJEE HARDWARE | DEALER | 2011-04-04 00:00:00 | 4 | 60 | 2011-06-03 00:00:00 | -49 | 75707 | 75707 | 75707 | 0 | 0 | 0 | 0 | 0 | 0 | 0
RAKSON STEEL TUBE | DEALER | 2010-10-20 00:00:00 | 26 | 60 | 2010-12-19 00:00:00 | 117 | 120776 | 120776 | 0 | 0 | 0 | 0 | 120776 | 0 | 0 | 0
ALEX PIPES | DEALER | 2010-12-27 00:00:00 | 81 | 60 | 2011-02-25 00:00:00 | 49 | 48311 | 48311 | 0 | 0 | 48311 | 0 | 0 | 0 | 0 | 0
LOPAX UTENSILS | DEALER | 2011-01-07 00:00:00 | 93 | 60 | 2011-03-08 00:00:00 | 38 | 100368 | 100368 | 0 | 0 | 100368 | 0 | 0 | 0 | 0 | 0
TOTAL OVERDUE AS ON DATE |  |  |  |  |  |  | 345162 | 345162 | 75707 | 0 | 148679 | 0 | 120776 | 0 | 0 | 0
Spreadsheet: 547663d1510671481-using-excel-to-match-data-sample-excel-sheet
Sheet: Topics

[NAME] | Chemistry of Life | Water, Acids, and Bases | Macromolecules | Energy and Enzymes | Structure of a Cell | Membranes and Transport | Cellular Respiration | Photosynthesis | Cell Signaling | Cell Division | Classical and Molecular Genetics | DNA as the Genetic Material | Central Dogma (Dna to RNA to protein) | [NAME] | Biotechnology | Bacteria and Archea | Evolution and the Tree of Life | Ecology | Biodiversity and Conservation | Scientific Method
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | x
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | x
 | x |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | x
 | x |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | x
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | x
 | x
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | x |  | x
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | x |  | x
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | x
 |  | x |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | x
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | x |  | x
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | x
 |  | x
 | x |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | xx
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | x
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | x
Spreadsheet: joe_parks__14598__Texas Quote List
Sheet: Texas

 |  |  | Quotes
Region | Curve Type | Curve Code | Have | Need
TEXAS | BASIS | IF-AGUA DULCE
TEXAS | BASIS | IF-A-S EAST OFF
TEXAS | BASIS | IF-CARTHAGE
TEXAS | BASIS | IF-HPL-SHPCHAN
TEXAS | BASIS | IF-KATY-TAIL
TEXAS | BASIS | IF-VALERO-TX
TEXAS | BASIS | KATY_TX-GD
TEXAS | BASIS | T-STX-VAL-AVG
TEXAS | INDEX | IF-HPL/SHPCHAN
TEXAS | INDEX | IF-KATY/TAIL
TEXAS | INDEX | IF-KATY/WOFLEX
Spreadsheet: 799967d1665417882-select-range-an-easier-way-to-implement-formula-over-different-ranges-example
Sheet: Sheet1

Returns |  | Output examples
0.049
-0.003
-0.024 |  | [NAME]
-0.037
-0.015 |  | Average Return
0.022
-0.035
0.015
0.027 |  | [NAME]
0.074
0.019 |  | Average Return
0.015
-0.072
0.039
0.032 |  | [NAME]
0.082
-0.038 |  | Average Return
-0.053
0.006
0.019
0.093
-0.077
0.033
-0.055
-0.079
0.083
0.07
-0.033
-0.048
0.088
-0.085
0.096
-0.056
-0.071
0.055
0.072
-0.054
-0.094
-0.045
0.065
-0.006
0.02
-0.028
-0.067
0.005
-0.093
-0.052
-0.081
0.079
-0.062
0.038
-0.017
0.05
0.069
0.064
-0.004
0.029
-0.022
-0.057
0.099
0.05
0.082
0.054
0.077
0.056
-0.082
0.028
0.097
-0.002
0.09
-0.076
-0.049
0.082
0.012
0.021
-0.007
0.05
-0.079
-0.01
0.048
-0.039
0.063
-0.014
0.012
0.018
0.083
-0.036
-0.041
-0.029
-0.021
-0.08
0.067
0.05
0.013
-0.021
0.049
0.039
0.07
0.071
0.09
-0.025
-0.059
-0.028
-0.013
-0.075
-0.085
-0.072
0.046
-0.08
Spreadsheet: 86784d1286759836-counting-frequency-of-transactions-by-time-sample
Sheet: Sheet1

Name | Date/Time
[NAME] | 2014-09-30 16:40:00
[NAME] | 2014-10-01 16:19:43
[NAME] | 2014-10-02 17:50:39
[NAME] | 2014-10-02 07:18:00
[NAME] | 2014-10-02 09:16:00
12:00:00
01:00:00
02:00:00
03:00:00
04:00:00
05:00:00
06:00:00
07:00:00 | 1
08:00:00
09:00:00 | 1
10:00:00
11:00:00
12:00:00
01:00:00
02:00:00
03:00:00
04:00:00 | 2
05:00:00 | 1
06:00:00
07:00:00
08:00:00
09:00:00
10:00:00
11:00:00
Spreadsheet: 803890d1667775424-calculate-final-price-using-tiered-pricing-more-elegantly-pricing-model
Sheet: Sheet1

 |  |  |  |  |  |  |  | 100 | 200 | 300 | 400 | 500 | price per 100g caffè more than 500g
0.65 | per unit cost |  |  |  |  |  |  |  |  |  |  |  | 130
4 | multiplier applied before 200g
cell F5 | starting price at 100 grams
 | price per 100g caffè more than 500g
 |  | Increase |  | Qty | Total price | Price per gram |  | Qty | Total usng IFS | Total
 |  | 0 |  | 100 |  |  |  | 1
 |  | 0.5 |  | 200 |  |  |  | 99
 |  | 0.25 |  | 300 |  |  |  | 100
 |  | 0.18 |  | 400 |  |  |  | 101
 |  | 0.13 |  | 500 |  |  |  | 199
 |  |  |  | 600 |  |  |  | 200
 |  |  |  | 700 |  |  |  | 201
 |  |  |  | 800 |  |  |  | 299
 |  |  |  | 900 |  |  |  | 300
 |  |  |  | 1000 |  |  |  | 301
 |  |  |  |  |  |  |  | 399
 |  |  |  |  |  |  |  | 400
 |  |  |  |  |  |  |  | 401
 |  |  |  |  |  |  |  | 499
 |  |  |  |  |  |  |  | 500
 |  |  |  |  |  |  |  | 501
 |  |  |  |  |  |  |  | 599
 |  |  |  |  |  |  |  | 250
 |  |  |  |  |  |  |  | 500
 |  |  |  |  |  |  |  | 750
 |  |  |  |  |  |  |  | 1000
Spreadsheet: 87444d1287324795-converting-currencies-using-exchange-rate-solution-cntr-freight-rates-3-
Sheet: test

 | exchange rates |  |  |  | tonnage
 | IEURUSD | 1.3958 |  | Apple | 22.5
 | IGBPUSD | 1.3958 |  | Orange | 23
 |  |  |  | Mango | 25
Origin | Destination | base rate/tc | BAF | THC +ISPS | ERS/EBS/SUEZ/ERC | rate /mt
Apple | A | 860 | INCL | INCL | 100 | 0
Mango | B | 860 | INCL | INCL | 100 | 0
Orange | C | 860 | INCL | INCL | 100 | 0
Apple | D | 2060 | INCL | 830 | 0 | 0
Mango | E | 1700 | INCL | 0 | 175 | 0
Spreadsheet: 70452d1271192235-check-ensure-all-values-in-a-range-are-unique-example
Sheet: Sheet1

 | Test ID | Test 2 ID | Test 3 ID | Test 4 ID
[NAME] | 1 | 5 | 9 | 13
[NAME] | 2 | 6 | 10 | 14
[NAME] | 3 | 7 | 11 | 15
[NAME] | 4 | 8 | 12 | 16
 |  |  |  |  | Duplicate Check | Pass
 | Test ID | Test 2 ID | Test 3 ID | Test 4 ID
[NAME] | 1 | 5 | 9 | 13
[NAME] | 2 | 1 | 10 | 14
[NAME] | 3 | 7 | 4 | 15
[NAME] | 4 | 8 | 12 | 2
 |  |  |  |  | Duplicate Check | Fail
Spreadsheet: 468227d1467189748-find-minimum-value-in-column-and-return-with-l1-l2-l3-find-minimum-value
Sheet: Sheet1

Amount in LC | Lowest Rank |  |  |  |  | L1
772.82 |  |  |  |  |  | L2
1451.33 |  |  |  |  |  | L3
34830.07 |  |  |  |  |  | [NAME]
4353.76 |  |  |  |  |  | L5
29025.07 |  |  |  |  |  | L6
29025.06 |  |  |  |  |  | L7
18866.29 |  |  |  |  |  | L8
4353.76 |  |  |  |  |  | L9
114649 |  |  |  |  |  | L10
1451
1451.25
725.63
2176.88
704.79
28896.23
772.82
70312.69
703.13
35156.35
6328.14
3515.63
6328.14
132891
5625
1451
2176.87
2176.88
5805
3515.63
2629
2629
772.82
1545.65
1545.65
5479.42
39138.7
47719.05
61604.44
35202.64
17210.18
5475.95
17210.22
35202.73
47875.45
53194.94
53194.94
17210.22
35202.73
13298.76
5475.95
7823
6258.24
19557
73821.94
14575
48937.5
10209.1
47642.49
952.85
74322.28
47435.47
45611.03
94605
17455.89
46375
46375
110372.5
911.77
4776.29
25763.47
12881.73
6440.87
12881.74
12881.73
12881.74
12881.73
12881.74
12881.73
5432.5
11660
36702.5
99375
911.77
25970
26897.5
8818.76
14310
46375
32065
79500
22525
30963.4
147140.12
27521.75
42891.07
14086.28
42268.05
150173
328750
14728.03
13216.83
299162.5
91721.25
5206.09
44620.39
44620.39
13150.03
1578
14728.03
44620.39
62842.61
55360.18
52102.63
189097.27
103146.55
128933.18
30590.85
398971
24306.59
92005.25
116311.84
13216.83
13216.83
32243.19
92005.25
24306.59
258470.76
24297.29
66824.89
13051.93
2350.39
21968.39
10709.36
21968.39
339927.5
32677.75
44904.52
28802.02
48177.16
72029.47
30537
34715
6812
4615.75
913.5
18270
18258.99
47338.13
913.5
136121.38
24795
29826.23
28992.58
41682.68
46932.67
93677.5
28992.58
26680.52
46375
102952.5
26180.47
8630.92
12129.84
1032.33
24130.64
12904.09
6452.04
12904.08
12904.09
12904.08
12904.09
12904.08
12904.09
1192.5
4505
95438
59625
6277.03
6277.03
8630.92
6277.03
43715.05
19615.73
39231.45
10088.09
135628.74
110278.67
38490
40858.24
81399
99581.19
35008.59
58935.88
117520.48
89777.93
63436.5
64182.08
39472.77
1847.33
26315.18
63940.63
131575.91
26315.18
93264
199844
Spreadsheet: 119226d1314277767-help-looking-up-and-pulling-value-aa
Sheet: IF

ID | Name | Current P/L
AA | [NAME] | -1.61
AA | [NAME] | -5.03
AA | [NAME] | -1093.93
AA | [NAME] | -4.98
AA | [NAME] | -13.99
AA | [NAME] | -15
AA | [NAME] | -38.12
AA | [NAME] | 0
BB | [NAME] | -1274.54
BB | [NAME] | 0
BB | [NAME] | 0
BB | [NAME] | 0
BB | [NAME] | 0
BB | [NAME] | 0
BB | [NAME] | 0
BB | [NAME] | 0
CC | [NAME] | 0
CC | [NAME] | 0
CC | [NAME] | 0
CC | [NAME] | 0
CC | [NAME] | 0
CC | [NAME] | 0
CC | [NAME] | 0
CC | [NAME] | -244.96
Spreadsheet: 485368d1476849234-merge-and-un-merge-issue-concatenation
Sheet: Sheet1

Query
Sr # | Description | Concatenated Output
1 | I | I am using excel
1 | am
1 | using
1 | excel
2 | This | This car is very fast
2 | car
2 | is
2 | very
2 | fast
3 | Lights | Lights * on
3 | *
3 | on
4 | It | It is _ morning
4 | is
4 | _
4 | morning
Spreadsheet: 07466b93-9fee-4cc1-a2c0-5189b737a5f5
Sheet: Equipment Services

Schedule B - Equipment Services
Item # | Item | Year | Install Price | Deinstall Price | Move Price | Relocate Price
 | 2500 Set | 1 | 13.64 | 13.64 | 17.05 | 13.64
 |  | 2 | 13.78 | 13.78 | 17.22 | 13.78
 |  | 3 | 13.92 | 13.92 | 17.4 | 13.92
 |  | 4 | 14.05 | 14.05 | 17.57 | 14.05
 |  | 5 | 14.19 | 14.19 | 17.74 | 14.19
 | 48 Port Cat 6 Patch Panel | 1 | 17.05
 |  | 2 | 17.22
 |  | 3 | 17.4
 |  | 4 | 17.57
 |  | 5 | 17.74
 | Cat 6 Patch Cord 3 ft | 1 | 6.82
 |  | 2 | 6.89
 |  | 3 | 6.96
 |  | 4 | 7.03
 |  | 5 | 7.1
 | Cat 6 [NAME] 10 ft | 1 | 6.82
 |  | 2 | 6.89
 |  | 3 | 6.96
 |  | 4 | 7.03
 |  | 5 | 7.1
 | Cat 6 Patch Cord 25 ft | 1 | 6.82
 |  | 2 | 6.89
 |  | 3 | 6.96
 |  | 4 | 7.03
 |  | 5 | 7.1
Spreadsheet: 806607d1669409249-filling-in-holiday-calendar-cells-based-on-holiday-records-using-lookups-book1
Sheet: Sheet1

 | 2022-01-01 00:00:00 | 2022-01-02 00:00:00 | 2022-01-03 00:00:00 | 2022-01-04 00:00:00 | 2022-01-05 00:00:00 | 2022-01-06 00:00:00 | 2022-01-07 00:00:00 | 2022-01-08 00:00:00 | 2022-01-09 00:00:00 | 2022-01-10 00:00:00 | 2022-01-11 00:00:00 | 2022-01-12 00:00:00 | 2022-01-13 00:00:00 | 2022-01-14 00:00:00
 | 1 | 2 | 3 | 4 | 5 | 6 | 7 | 8 | 9 | 10 | 11 | 12 | 13 | 13
Name
[NAME]
[NAME]