tianzl66/Sheetpedia huggingface dataset:
Spreadsheet: 272392d1382371971-freight-calculator-for-ups-jetair-using-index-match-and-max-frieght_calculator_icmpl
Sheet: Calculator

 |  | [NAME] |  |  |  |  |  | FUEL SURCHARGE
UPS EXPORT FREIGHT CALCULATOR |  |  |  |  |  |  |  | 1.19
COUNTRY | ZONE | PRODUCTS | LxBxH | ACTUAL WEIGHT ([NAME]) | CHARGEABLE WEIGHT ([NAME]) | FREIGHT | FRIEGHT AMOUNT
Bangladesh |  | NON_DOC | 4 | 4 |  |  | #N/A
Spreadsheet: 673643d1587476960-how-can-i-dynamically-state-which-cell-i-want-to-read-from-dynamic-cell-reference-example
Sheet: Sheet1

Last value from column D posted into B1: |  |  | number of values: | 14
 |  |  | Value 1 | a
 |  |  | Value 2 | fa
In this example workbook, pasted data had 14 values, so 15 lines, so B1=E14.  But wat if there was 98 values? Or 7?  What would the B1 formula be to be universal for all these cases? |  |  | Value 3 | fs
 |  |  | Value 4 | fdsf
 |  |  | Value 5 | sd
 |  |  | Value 6 | ff
 |  |  | Value 7 | ff
 |  |  | Value 8 | sdf
 |  |  | Value 9 | fs
 |  |  | Value 10 | sdf
 |  |  | Value 11 | as
 |  |  | Value 12 | ht
 |  |  | Value 13 | te
 |  |  | Value 14 | rer
Spreadsheet: 86395d1286384511-how-to-paste-only-numeric-data-of-a-copied-column-sample
Sheet: Sheet1

 |  |  |  |  |  |  |  |  | What I Want
 |  | 01:36:30:00 | 01:47:11:00 |  |  |  |  |  | 01:36:30:00 | 01:47:11:00
 |  | [NAME] | 02:01:44:00 | 01:04:00:00 |  |  |  |  | 02:01:44:00 | 01:04:00:00
 |  | 02:01:44:00 | 01:04:00:00 |  |  |  |  |  | 02:01:44:00 | 01:04:00:00
 |  | Budjet | [NAME] | 02:12:39:00 | 02:17:21:00 |  |  |  | 02:12:39:00 | 02:17:21:00
 |  | 02:17:39:00 | 02:20:21:00 |  |  |  |  |  | 02:17:39:00 | 02:20:21:00
 |  | story | co-actors |  | 02:17:39:00 | 02:20:21:00 |  |  | 02:17:39:00 | 02:20:21:00
 |  |  | 01:02:00:00 | 01:03:52:00 | NULL | On [NAME] |  |  | 01:02:00:00 | 01:03:52:00
 |  |  | 01:03:53:00 | 01:07:24:00 | NULL | Event |  |  | 01:03:53:00 | 01:07:24:00
 |  |  | lollypop choreographer and a item number in pakistani films | Pakistani Actor | 01:14:15:00 | 01:14:10:00 |  |  | 01:14:15:00 | 01:14:10:00
 |  |  | Director and [NAME] | 01:16:39:00 | 01:20:37:00 | NULL |  |  | 01:16:39:00 | 01:20:37:00
 |  |  | ΓÇªabout [NAME]..Director..about the audience..and other projects | Actress | 01:20:40:00 | 01:31;03:00 |  |  | 01:20:40:00 | 01:31;03:00
Spreadsheet: fdafe556-6223-4c06-b187-ac2b6321d155
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
NICOS | Test | NICOS | Nicotine and [NAME], Serum | Nicotine and [NAME], S | Liquid Chromatography-Tandem Mass Spectrometry (LC-MS/MS) | Plain, Red-Top Tube: Red |  |  | 3 | mL | Container/Tube: Red top [NAME]: 1.4 mL | 0.4 mL | Hemolysis	Mild OK; Gross reject Thawing	Warm OK; Cold OK Lipemia	Mild OK; Gross reject Icterus	Mild OK; Gross reject Other	NA | NICOTINE <2.0 ng/mL   COTININE <2.0 ng/mL | Monday through Friday | 2 days | 4 days | 1 | 83887 |  |  |  |  | Rochester
NICOS | [NAME] | SRED | Serum Red |  |  |  | Refrigerated | 14 days
NICOS | Result | 21313 | Nicotine | Nicotine | Numeric |  |  |  |  | ng/mL |  |  |  |  |  |  |  |  |  | 3853-9
NICOS | Result | 21314 | [NAME] | [NAME] | Numeric |  |  |  |  | ng/mL |  |  |  |  |  |  |  |  |  | 10365-5
Spreadsheet: 44899d1243622873-data-formatting-excel-help-1-1
Sheet: Sheet2

Enter/Select Colour: |  | ABSOLUTE BLACK |  | Matches: | 2
 |  | HTO's Cost |  | HTO's Cost |  | Customer's Cost
 |  | Single Slab |  | Bundled Price |  | Single Slab |  | Bundled Price
SUPPLIER | COLORS | 2CM | 3CM | 2CM | 3 CM | 2CM | 3CM | 2CM 12+Slabs | 3 CM 12+Slabs
MSI | ABSOLUTE BLACK | 9.95 | 13.95 | 8.25 | 11.85 | 14.42028985507246 | 20.21739130434783 | 12.69230769230769 | 18.23076923076923
Nidi | ABSOLUTE BLACK | 0 | 0 | 9.586666666666668 | 12.942 | 0 | 0 | 14.74871794871795 | 19.91076923076923
Spreadsheet: 846523d1697701346-list-size-options-that-have-available-quantities-excel-forum
Sheet: Sheet1

SKU | formula (downwards) | [NAME] | Available Quantity
96379-001- | L-M-S | L | 8
96379-001- |  | M | 2
96379-001- |  | S | 30
96379-001- |  | XL | 0
96379-001- |  | XXL | 0
96379-008- | L-S | L | 8
96379-008- |  | M | 0
96379-008- |  | S | 18
96379-008- |  | XL | 0
96379-008- |  | XXL | 0
96407-001- | L-M-S-XL | 3XL | 0
96407-001- |  | L | 7
96407-001- |  | M | 1
96407-001- |  | S | 33
96407-001- |  | XL | 20
96407-001- |  | XXL | 0
96407-098- | 3XL-L-S-XL | 3XL | 1
96407-098- |  | L | 3
96407-098- |  | M | 0
96407-098- |  | S | 14
96407-098- |  | XL | 11
96407-098- |  | XXL | 0
96407-172- | 3XL-L-M-S-XL-XXL | 3XL | 9
96407-172- |  | L | 21
96407-172- |  | M | 17
96407-172- |  | S | 26
96407-172- |  | XL | 25
96407-172- |  | XXL | 6
96407-175- | L-S-XL | 3XL | 0
96407-175- |  | L | 4
96407-175- |  | M | 0
96407-175- |  | S | 14
96407-175- |  | XL | 15
96407-175- |  | XXL | 0
96518-005- | L-M | L | 10
96518-005- |  | M | 11
96518-005- |  | S | 0
96518-005- |  | XL | 0
96518-005- |  | XXL | 0
Spreadsheet: 476790d1472026771-if-statement-problem-construction-and-revenue-rollout
Sheet: Construction & Revenue rollout

 | Input Table
 | Construction |  | Year 1 | Year 2 | Year 3 | Year 4 | Year 5 | Year 6 | Year 7 | Year 8 | Year 9 | Year 10
 | Hotel 1 |  | 1 | 1 | 1 | 0 | 0 | 0 | 0 | 0 | 0 | 0
 | Hotel 2 |  | 0 | 1 | 1 | 0 | 0 | 0 | 0 | 0 | 0 | 0
 | Hotel 3 |  | 0 | 0 | 1 | 1 | 0 | 0 | 0 | 0 | 0 | 0
 | Hotel 4 |  | 0 | 0 | 0 | 1 | 1
 | Output Table
 | Revenue |  | Desired table: This is what the actual result should look like
 | Hotel 1 |  | 0 | 0 | 0 | 1 | 1 | 1 | 1 | 1 | 1 | 1
 | Hotel 2 |  | 0 | 0 | 0 | 1 | 1 | 1 | 1 | 1 | 1 | 1
 | Hotel 3 |  | 0 | 0 | 0 | 0 | 1 | 1 | 1 | 1 | 1 | 1
 | Hotel 4 |  | 0 | 0 | 0 | 0 | 0 | 1 | 1 | 1 | 1 | 1
 | Output Table
 | Revenue |  | What I am actually getting
 |  |  | =IF(D7=1,0,IF(C7=0,0,1))
 | Hotel 1
 | Hotel 2
 | Hotel 3
 | Hotel 4
Spreadsheet: 815177d1674784785-sumifs-with-multiple-criteria-sumifs-with-multiple-criteriagk
Sheet: desired result

report
 | 2023-01-01 00:00:00 |  |  | 2023-02-01 00:00:00 |  |  | 2023-03-01 00:00:00 |  |  | 2023-04-01 00:00:00 |  |  | 2023-05-01 00:00:00 |  |  | 2023-06-01 00:00:00
ACCOUNT NAME | PLT | CTN | TOTAL WT. | PLT | CTN | TOTAL WT. | PLT | CTN | TOTAL WT. | PLT | CTN | TOTAL WT. | PLT | CTN | TOTAL WT. | PLT | CTN | TOTAL WT.
ALLAN |  | 4 | 250 |  | 0 | 450 |  | 0 | 0 |  | 8 | 80 |  | 0 | 0 |  | 12 | 120
[NAME] |  | 5 | 50 |  | 14 | 140 |  | 0 | 0 |  | 0 | 0 |  | 0 | 0 |  | 0 | 0
[NAME] |  | 12 | 110 |  | 6 | 60 |  | 13 | 1700 |  | 0 | 0 |  | 0 | 0 |  | 0 | 0
[NAME] |  | 0 | 0 |  | 11 | 160 |  | 0 | 2400 |  | 0 | 100 |  | 0 | 0 |  | 0 | 0
TAKESHI |  | 0 | 0 |  | 0 | 0 |  | 0 | 0 |  | 0 | 0 |  | 0 | 0 |  | 0 | 0
Only "shipped" figure on the remarks will appear on the report
Spreadsheet: 868517d1715242784-subtract-x-amount-from-top-left-and-bottom-right-sides-of-array-subtract-left-right-side-array
Sheet: Sheet1

 |  | keep orange cells empty or see Sheet2
 | Original |  |  | 100 | 100 | 0 | 20 | 50 | 0 | 40 | 0
 |  |  |  | -100 | -50 |  |  | -35 |  | -40 | 0
try left only | intermediate steps
try right only | (helper rows)
Final formula | 150 | 75 | final result
 | Desired Dynamic Array |  |  | 0 | 50 | 0 | 20 | 15 | 0 | 0 | 0
 |  |  |  | Subtract 150 going right till zero |  |  |  |  |  | Subtract 75 going left till zero
Spreadsheet: 134350d1325243560-data-validation-candidate-recruitment-process
Sheet: Sheet1

 |  | Candidate Recruitment Process
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | Yes | A | ABC |  |  | Yes | Deployed
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | no | B | XYZ |  |  | No | Ready To Join
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | C | ABF |  |  | Issued | Didnot Join
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | D | CDS
Sr. No. | Name of Candidate | date of interview | First Round | date of interview 2 | Second Round | date of interview 3 | Final Round | Date Of Training | Training | Final Selection | Awaiting issue of App. Letter | Status | Date Of Appoinment | Deployed in Group |  |  |  | E | JMK
 | XYZ | 2011-05-19 00:00:00 | Yes |  | Yes |  | Yes |  | no | No | Issued | Didnot Join | 0 | C |  |  |  | F | PLK
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | G | SMF
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | H | JHF
Sr. No. | Name of Candidate | date of interview | First Round | date of interview 2 | Second Round | date of interview 3 | Final Round | Date Of Training | Training | Final Selection | Awaiting issue of App. Letter | Status | Date Of Appoinment | Deployed in Group |  |  |  | I
1 | ABC | 2011-05-15 00:00:00 | Yes |  | Yes |  | Yes |  | Yes | Yes | Yes | Ready To Join |  | A |  |  |  | J
2 | XYZ | 2011-05-19 00:00:00 | Yes |  | Yes |  | Yes |  | no | No | Issued | Didnot Join |  | C
3 | ABF | 2011-05-26 00:00:00 | Yes |  | Yes |  | Yes |  | no | No | Yes | Deployed |  | E
4 | CDS | 2011-05-24 00:00:00 | Yes |  | Yes |  | Yes |  | no | No | Issued | Deployed |  | A
5 | JMK | 2011-05-31 00:00:00 | no |  | Yes |  | Yes |  | no | No | Yes | Ready To Join |  | A
6 | PLK | 2011-05-28 00:00:00 | Yes |  | Yes |  | Yes |  | no | No | Issued | Deployed |  | A
7 | SMF | 2011-05-28 00:00:00 | Yes |  | Yes |  | Yes |  | no | No | Yes | Deployed |  | A
8 | JHF | 2011-05-13 00:00:00 | no |  | Yes |  | Yes |  | no | No | Issued | Deployed |  | A
Spreadsheet: 888085d1738440502-sumproduct-formulae-issue-sample
Sheet: Resulted Wanted

 |  |  |  | Jan-2025 |  |  |  |  |  | 2025-01-31 00:00:00
 |  |  |  | wants with formula | wants with formula |  | wants with formula | wants with formula | wants with formula
 |  | S.No. | Name | Opening | [NAME] | Total Balance | Cash | Batch | Payment | Net Balance
 |  | 1 | a | 0 | 5000
 |  |  | b | 228920 | 15000 |  | 5000 | 175000
 |  |  | c | 219200 | 0 |  | 25000 | 150000
 |  |  | d | 3025 | 0
 |  |  | e | 3090 | 0 |  | 2000
 |  |  | TOTAL
Spreadsheet: 174a123a-b730-4784-8753-600da4111155
Sheet: Gene Bergman

[NAME]
Fair Share Fee: Those Who Don't Pay Their Fair Share
Agree
Explain your fair share position, if you choose.
To get the benefit of the union and not pay for it is just not right and it undermines the bargaining power of all employees.
Teachers' Retirement: Support in the State Budget
Agree
Explain your teachers' retirement position, if you choose.
The choice people make to go into a profession includes whether or not they will have a pension to help them after they retire.
Teachers rely on the promise of a pension that will be there in retirement. If we say we value education we need to value
teachers. That includes making sure that Vermont honors our commitment to our teachers' retirement fund.
Health Care: Continuing System Reform
I'd like to explain my position
Explain your health care reform position, if you choose
Teachers and other organized workers have definitely made sacrifices and concessions to keep adequate health benefits;
indeed all middle and low income people have sacrificed and are suffering from our lack of universal health care coverage. We
need a system that recognizes that health care is a human right and decouples coverage from employment or income. Within
this system, employees should be allowed to negotiate for benefits that supplement health benefits that all Vermonters have
the right to. Overall, the cost of health care should go down under single payer, with all Vermonters sharing and being treated
equally, and employers should use those savings to help employees transition to this new system.
Teaching Career: Retaining New Teachers
Agree
Explain your teaching career position, if you choose
Investing in essential infrastructure includes human capital as well as buildings and other physical things. If Vermont is to
prosper in the new world economy, we are going to have to improve our support for young people who decide that teaching
makes economic sense and well as for personal satisfaction.
Teaching Profession: Simplifying Professional Relicensing
Agree
Explain your relicensing position, if you choose
There is no reason for teacher relicensing to be more difficult than relicensing for other professions. Relicensing should not be
cumbersome, time consuming or based on a non-objective process. A complicated licensing process discourages people from
going into teaching while a simplified relicensing process does not and allows for a proper focus on professional development
throughout the teacher's working life.
Name | email address | Address | Office sought | Are you an incumbent? |  | County
[NAME] | [EMAIL] | 102 St. Louis St., Burlington | State Representative-Chitt. 6-3 | No |  | Chittenden
Spreadsheet: 62b1ab65-1a70-41b3-b1b2-77b2403f0fdc
Sheet: Sheet1

Értékpapír | CF Dáum | [NAME] | [NAME] esemény | [NAME] mennyisége | Kamat esemény | Kamat | Kamat mennyisége | Kamat fizetés | Kamat nem fizetés
A161128I11 | 2011-11-28 00:00:00 | 1000 | Igen | -1000 | Nem | 0 | 0 | 0 | 0
A161128I11 | 2012-11-28 00:00:00 | 1000 | Nem | 0 | Igen | 7.4 | 74 | 74 | 0
A161128I11 | 2013-11-28 00:00:00 | 1000 | Nem | 0 | Igen | 9.5 | 95 | 95 | 0
A161128I11 | 2014-11-28 00:00:00 | 1000 | Nem | 0 | Igen | 4.4 | 44 | 44 | 0
A161128I11 | 2015-11-28 00:00:00 | 1000 | Nem | 0 | Igen | 0 | 0 | 0 | 0
A161128I11 | 2016-11-28 00:00:00 | 0 | Igen | 1000 | Igen | 0 | 0 | 0 | 0
Spreadsheet: louise_kitchen__23041__CFs by Industry and Erating
Sheet: IPP

Independent Power Producer Cash Flows
Sorted by E Rating
E rating | Data | Total
3 | Sum of Total CF | 11589811.56002
 | Sum of Positive CF | 11589811.56002
 | Sum of Negative CF | 0
4 | Sum of Total CF | 11172436.99
 | Sum of Positive CF | 11272478.7931
 | Sum of Negative CF | -100041.8031
5 | Sum of Total CF | 41415315.06593997
 | Sum of Positive CF | 54826799.72163997
 | Sum of Negative CF | -13411484.6557
6 | Sum of Total CF | 1359591.6169
 | Sum of Positive CF | 1391012.1657
 | Sum of Negative CF | -31420.5488
7 | Sum of Total CF | -1079898.30748
 | Sum of Positive CF | 36212.6229
 | Sum of Negative CF | -1116110.93038
8 | Sum of Total CF | -14070589.52746
 | Sum of Positive CF | 6183228.54507
 | Sum of Negative CF | -20253818.07253
9 | Sum of Total CF | -27169022.01032
 | Sum of Positive CF | 7758887.212359998
 | Sum of Negative CF | -34927909.22268
10 | Sum of Total CF | -2082057.2228
 | Sum of Positive CF | 2907984.4832
 | Sum of Negative CF | -4990041.705999999
11 | Sum of Total CF | -399915.8263400001
 | Sum of Positive CF | 3655419.02137
 | Sum of Negative CF | -4055334.84771
Total Sum of Total CF |  | 20735672.33845996
Total Sum of Positive CF |  | 99621834.12535997
Total Sum of Negative CF |  | -78886161.7869
Spreadsheet: 98598d1297453908-pivot-table-displaying-data-rows-into-columns-inventory
Sheet: Inv Purchase_Nick K

[NAME]
Date | Item Name | Quantity | Cost | Shipping | Total
2011-01-01 00:00:00 | [NAME] | 4 | 5 |  | 20
2011-01-01 00:00:00 | SATA80GB | 4 | 5 |  | 20
2011-01-10 00:00:00 | DDR2 400 1GB | 2 | 15 |  | 30
2011-01-10 00:00:00 | DDR2 533 512 | 4 | 7.5 |  | 30
2011-01-10 00:00:00 | SATA80GB | 2 | 10 |  | 20
2011-01-11 00:00:00 | [NAME] | 5 | 12 |  | 60
 |  |  |  |  | 0
 |  |  |  |  | 0
 |  |  |  |  | 0
 |  |  |  |  | 0
 |  |  |  |  | 0
 |  |  |  |  | 0
 |  |  |  |  | 0
 |  |  |  |  | 0
 |  |  |  |  | 0
 |  |  |  |  | 0
 |  |  |  |  | 0
 |  |  |  |  | 0
 |  |  |  |  | 0
 |  |  |  |  | 0
 |  |  |  |  | 0
 |  |  |  |  | 0
 |  |  |  |  | 0
 |  |  |  |  | 0
 |  |  |  |  | 0
 |  |  |  |  | 0
 |  |  |  |  | 0
 |  |  |  |  | 0
 |  |  |  |  | 0
 |  |  |  |  | 0
 |  |  |  |  | 0
 |  |  |  |  | 0
 |  |  |  |  | 0
 |  |  |  |  | 0
 |  |  |  |  | 0
 |  |  |  |  | 0
 |  |  |  |  | 0
 |  |  |  |  | 0
 |  |  |  |  | 0
 |  |  |  |  | 0
 |  |  |  |  | 0
 |  |  |  |  | 0
 |  |  |  |  | 0
 |  |  |  |  | 0
 |  |  |  |  | 0
 |  |  |  |  | 0
 |  |  |  |  | 0
 |  |  |  |  | 0
Spreadsheet: 676397d1588784972-how-can-i-calculate-realised-profits-loss-after-each-sell-trade-date-trading-dashboard
Sheet: Chart Info

[NAME] |  |  |  |  | Pie Chart
 |  |  | Balance |  | Cost
2020-04-27 00:00:00 | 0 | 0 |  |  | Profit/Loss
 |  |  |  |  | ROI
Spreadsheet: 888672d1739240675-returning-a-series-of-non-empty-results-based-on-a-reference-football-league
Sheet: Table

 | Matchday |  | 5
 | Date
 | Qualification |  | 0.3
 | # |  | Joueurs | Résultats |  |  |  | Différence de Buts |  |  |  |  |  |  |  | Classement
 |  |  |  | J | G | N | D | BP | BC | DIF |  |  |  |  |  | Qual? | Pts | % Vic. | PPM |  | # | Joueurs | Buts | Matchs | [NAME]
 | 1 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 1
 | 2 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 2
 | 3 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 3
 | 4 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 4
 | 5 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 5
 | 6 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 6
 | 7 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 7
 | 8 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 8
 | 9 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 9
 | 10 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 10
 | 11 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 11
 | 12 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 12
 | 13 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 13
 | 14 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 14
 | 15 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 15
 | 16 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 16
 | 17 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 17
 | 18 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 18
 | 19 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 19
 | 20 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 20
 | 21
 | 22
 | 23
 | 24
 | 25
Spreadsheet: 138747d1327877978-excel-2007-multiple-conditional-formulas-811251-multiple-conditional-formulas-managing
Sheet: sets

MANAGING AREA | CR TYPE | IMPORTED | PRIORITY | Color 1 | Size | Color 2 | Size | Color 3 | Size | Color 4 | Size
A | CR1 | Yes | 1 | Blue | 3 | Red | 10 | Yellow | 9 | Black | 0
A | CR1 | Yes | 2 | Blue | 2 | Red | 8 | Yellow | 7 | Black | 1
A | CR1 | Yes | 3 | Blue | 1 | Red | 6 | Yellow | 5 | Black | 2
B | CR1 | Yes | 4 | Blue | 3 | Red | 10 | Yellow | 9 | Black | 0
B | CR1 | Yes | 2 | Blue | 2 | Red | 8 | Yellow | 7 | Black | 1
B | CR1 | Yes | 3 | Blue | 1 | Red | 6 | Yellow | 5 | Black | 2
C | CR1 | Yes | 1 | Blue | 3 | Red | 10 | Yellow | 9 | Black | 0
C | CR1 | Yes | 2 | Blue | 2 | Red | 8 | Yellow | 7 | Black | 1
C | CR1 | Yes | 3 | Blue | 1 | Red | 6 | Yellow | 5 | Black | 2
D | CR1 | Yes | 1 | Blue | 3 | Red | 10 | Yellow | 9 | Black | 0
D | CR1 | Yes | 2 | Blue | 2 | Red | 8 | Yellow | 7 | Black | 1
D | CR1 | Yes | 3 | Blue | 1 | Red | 6 | Yellow | 5 | Black | 2
A | CR2 | Yes | 1 | Blue | 3 | Red | 10 | Yellow | 9 | Black | 0
A | CR2 | Yes | 2 | Blue | 2 | Red | 8 | Yellow | 7 | Black | 1
A | CR2 | Yes | 3 | Blue | 1 | Red | 6 | Yellow | 5 | Black | 2
B | CR2 | Yes | 4 | Blue | 3 | Red | 10 | Yellow | 9 | Black | 0
B | CR2 | Yes | 2 | Blue | 2 | Red | 8 | Yellow | 7 | Black | 1
B | CR2 | Yes | 3 | Blue | 1 | Red | 6 | Yellow | 5 | Black | 2
C | CR2 | Yes | 1 | Blue | 3 | Red | 10 | Yellow | 9 | Black | 0
C | CR2 | Yes | 2 | Blue | 2 | Red | 8 | Yellow | 7 | Black | 1
C | CR2 | Yes | 3 | Blue | 1 | Red | 6 | Yellow | 5 | Black | 2
D | CR2 | Yes | 1 | Blue | 3 | Red | 10 | Yellow | 9 | Black | 0
D | CR2 | Yes | 2 | Blue | 2 | Red | 8 | Yellow | 7 | Black | 1
D | CR2 | Yes | 3 | Blue | 1 | Red | 6 | Yellow | 5 | Black | 2
Spreadsheet: 749967d1633117645-replacing-nested-if-stetements-example
Sheet: Sheet1

 | Item | Plant | [NAME]. | Request |  | 1026 | 1002 | 1023 | 1040
 | C111 | 1002 | 10 | Can I allocate in 1002? |  | 0 | 10 | 0 | 0
 | E444 | 1002 | 10 | Can I move to 1026? |  | 30 | 5 | 20 | 5
 | C112 | 1002 | 10 | Can I move to 1040? |  | 0 | 0 | 10 | 20
 | C113 | 1002 | 10 | Can I move to 1023? |  |  | 0 | 20 | 0
 | E445 | 1002 | 10 | Out of stock |  | 0 | 0 | 0 | 0
 | D333 | 1023 | 10 | Can I move to 1002? |  | 0 | 10 | 0 | 0
 | D334 | 1023 | 10 | Can I allocate in 1023? |  | 30 | 5 | 20 | 5
 | F555 | 1026 | 10 | Can I move to 1040? |  | 0 | 0 | 10 | 20
 | F556 | 1026 | 10 | Out of stock |  | 0 | 0 | 0 | 0
 | B222 | 1040 | 10 | Can I move to 1002? |  | 0 | 10 | 0 | 0
 | B223 | 1040 | 10 | Can I move to 1026? |  | 30 | 5 | 20 | 5
 | B224 | 1040 | 10 | Can I allocate in 1040? |  | 0 | 0 | 10 | 20
Spreadsheet: d5c1afe8-12a3-4500-a9aa-bcd103405eb2
Sheet: Gold Standards

a) | HuRef as gold standard |  |  |  |  | Mills (2006) in NA12878 and NA12156 as gold standard
MEI insertions
 | huRef  MEI insertions | matched | % matched
Alu | 584 | 449
L1 | 52 | 24
SVA | 14 | 9
total
b) |  |  |  |  |  | c)
MEI deletions |  |  |  |  |  | MEI deletions
 | huRef  MEI deletions | matched | % matched |  |  |  | Mills  MEI deletions | matched | % matched
Alu | 701 | 654 | 0.93 |  |  | NA12878 | 18 | 17 | 0.94
L1 | 72 | 65 | 0.9 |  |  | NA12156 | 30 | 29 | 0.97
SVA | 30 | 30 | 1
total |  |  |  |  |  |  | Mills et. al. Genome Research 16, 1182 (2006)
 | [NAME], [NAME] Genome Research 19, 1516 (2009)
postion matching between our event list and previous studies are done using a window of 200bp for insertions and a 50% reciprocal overlap for MEI deletions
Spreadsheet: 161774d1339618937-need-to-sum-the-max-entry-over-0-in-a-group-sample1
Sheet: Sheet2

'42903063
 | 130351 |  |  |  |  |  |  | 100
 | 776286 |  |  |  |  |  |  | -125
 | 580552 |  |  |  |  |  |  | 5.32
71021551
 | 574396 |  |  |  |  |  |  | 251.13
 | 580936 |  |  |  |  |  |  | -637
'362020
 | 166227 |  |  |  |  |  |  | 13.02
'912611
 | 114406 |  |  |  |  |  |  | -46.52
 | 102315 |  |  |  |  |  |  | -674.54
Spreadsheet: 599992d1543409934-index-matching-pulling-through-a-link-query-copy-of-vlookup-with-hyperlinks
Sheet: Sheet1

 |  | Vlookup | Index Match | Index [NAME] |  | Name | Link | Underlying Hyperlink
 | Gio | Gio's Link | Gio's Link | Gio's Link |  | Gio | Gio's Link | http://www.bloomberg.com/
 | Oli | Oli's Link | Oli's Link | Oli's Link |  | Oli | Oli's Link | http://www.wsj.com/
 | [NAME] | [NAME]'s Link | [NAME]'s Link | [NAME]'s Link |  | [NAME] | [NAME]'s Link | http://www.afr.com/
 | Gio | #N/A | <Hlink & Vlookup don't work well together for some reason
 | Gio | Gio's Link
 | Gio | http://www.bloomberg.com/