tianzl66/Sheetpedia huggingface dataset:
Spreadsheet: 60405d1260959531-excel-2007-autocompleteseveral-sentences-over-and-over-again-excelforum
Sheet: Blad17 (2)

Ort | Längd | År | Vitalitet | Struktur | Information | Prio | Åtgärd
96. Lönn (Acer platanoides) | 9m | M | B | B | Torra grenar som kan utgöra en risk för allmänheten. Korsande grenar som kan orsaka grenröta och [NAME]. | 3 | Standardträdvårdsbeskärning
97. Lind (Tilia cordata) | 9m | M | B | B | Torra grenar som kan utgöra en risk för allmänheten. Korsande grenar som kan orsaka grenröta och [NAME]. | 3 | Standardträdvårdsbeskärning
98. Lind (Tilia cordata) | 11m | M | C | C | Torra grenar som kan utgöra en risk för allmänheten, korsande grenar som kan orsaka grenröta och [NAME]. Trädet har blivet för stora för den plats den växa på. | 2 | Helkronsreducering c:an 15% samt standardträdvårdsbeskärning, [NAME] gren över häck.
99. Lind (Tilia cordata) | 11m | M | C | C | Torra grenar som kan utgöra en risk för allmänheten, korsande grenar som kan orsaka grenröta och [NAME]. Trädet har blivet för stora för den plats den växa på. | 2 | Helkronsreducering c:an 15% samt standardträdvårdsbeskärning. Reducera gren över häck.
100. Lind (Tilia cordata) | 12m | M | C | D | Stamspricka | 1 | Sektionsfällning.
101. Asp (Populus tremula) | 14m | M | B | B | Tätt växande krona som kan orsaka rotvälta eller grenbrott, torra grenar som kan utgöra en risk för allmänheten, korsande grenar som kan orsaka grenröta och [NAME]. | 3 | Kronutglesning.
102. Björk (betula pendula) | 6m | U | D | D | RISKTRÄD/FALL RISK Allmänt dåligt skick/Svagväxande, lågt bevarande värde. | 3 | Sektionsfällning.
103. Björk (betula pendula) | 9m | U | D | D | RISKTRÄD/FALL RISK Allmänt dåligt skick/Svagväxande, lågt bevarande värde. | 1 | Sektionsfällning.
Spreadsheet: 739078d1625495089-vba-macro-to-get-amount-in-master-sheet-book1
Sheet: Master

 | 16000 | 22000 | 22025 | 22101 | 22102 | 22125 |  | 22150 | 22175 | 22200 | 22250 | 26100 | 27125 | 28025 | 34350 | 36900 | 37000 | 28028 | 22050 | 31560
#
10001
10002
10003
10005
10010
10011
10013
10014
10015
10016
10018
10019
10020
10021
10022
10043
10046
10050
10061
10065
10095
10099
10102
10108
10109
10114
10121
10137
20001
20005
20007
20009
20014
20015
20015RE
20016
20052
20053
20054
20056
20062
20068
30018
30027
30100
30450
40001
40013
50001
50096
70001
10012
10017
10036
10038
10041
10042
10049
10104
10135
10136
10138
10157
10158
20008
20010
20064
20075
20076
30019
30020
30023
30467
30476
30516
30527
30552
30588
30589
30627
30628
30644
30498
30421
10150
20049
30029
30464
30069
20020
20080
20081
10160
30228
30629
Spreadsheet: 86748d1286727487-searching-values-on-a-table-result
Sheet: Sheet1

Name | Date | Obs | Result |  | Name | Count Success | Not Success |  |  |  |  |  |  |  |  | Success
[NAME] | 2010-10-10 00:00:00 | ? | Success |  | [NAME] |  |  |  |  |  |  |  |  |  |  | Not Success
[NAME] | 2010-10-10 00:00:00 | ? | Not Success |  | [NAME]
[NAME] | 2010-10-10 00:00:00 | ? | Success |  | [NAME]
[NAME] | 2010-10-10 00:00:00 | ? | Not Success
[NAME] | 2010-10-10 00:00:00 | ? | Success
[NAME] | 2010-10-10 00:00:00 | ? | Not Success
[NAME] | 2010-10-10 00:00:00 | ? | Success
[NAME] | 2010-10-10 00:00:00 | ? | Not Success
[NAME] | 2010-10-10 00:00:00 | ? | Success
[NAME] | 2010-10-10 00:00:00 | ? | Not Success
[NAME] | 2010-10-10 00:00:00 | ? | Success
Spreadsheet: 718025d1612958154-index-and-match-function-with-several-columns-roster-vs-schedule-example
Sheet: Classes

Day | Monday | Monday | Monday | Monday | Tuesday | Tuesday | Tuesday | Tuesday | Wednesday | Wednesday | Wednesday | Wednesday | Wednesday | Thursday | Thursday | Thursday | Thursday | Friday | Friday
System | System 1 | System A | System 2 | System 3 | System 4 | System B | System 5 | System 6 | System 7 | System 8 | System C | System D | System 9 | System E | System F | System 10 | System G | System H | System 11
 | Monday | Tuesday | Wednesday | Thursday | Friday | Saturday | Sunday
Spreadsheet: 158444d1338245993-using-v-lookup-to-find-a-list-of-values-and-return-a-sum-example
Sheet: Sheet1

A2:B12 is the full list of information |  |  |  |  | I want to have cell F3 display the sum of units corresponding to product #'s in column D (here 1, 2, & 3). In this example the number is 300
Product # | Units |  | Product |  | Units:
1 | 50 |  | 1 |  | 300
2 | 100 |  | 2
3 | 150 |  | 3
4 | 200
5 | 10
6 | 50
7 | 100
8 | 500
9 | 100
10 | 1041
Spreadsheet: 137489d1327156669-tranpose-transpose-to-right
Sheet: Sheet1

a | b
Akin | 79 |  | Akin
Akin | 106 |  | [NAME]
Akin | 134
Akin | 121
[NAME] | 477
[NAME] | 423
[NAME] | 186
[NAME] | 129
[NAME] | 562
Spreadsheet: 732539d1621008189-upc-barcode-check-digit-as-a-conditional-format-sample2
Sheet: UPC MASTER LIST

MODEL NUMBER | PRODUCT DESCRIPTION | PACKAGE TYPE | PRODUCT UPC GTIN-12 | CHECK [NAME] | [NAME] | CASE PACK UPC GTIN-14 | CHECK [NAME] | CASE PACK | UPC ? | UPC ? | STATUS | REPLACED BY | CATEGORY | – | CLIENT | BRAND | CUSTOMER NUMBER | NOTES | ERROR | – | PRODUCT PHOTO | TRAY PHOTO | – | PRODUCT DIELINE | PRODUCT STICKER | PRODUCT HANGTAG | TRAY DIELINE | CASE PACK DIELINE
N/A | N/A |  | N/A | N/A |  | N/A | N/A |  |  |  | N/A | N/A | N/A | – | N/A | N/A | N/A | N/A | N/A | – | N/A | N/A | – | N/A | N/A | N/A | N/A | N/A
SAMPLE A |  | HANG TAG | 879640000004 |  |  | 10879640000001 |  |  |  |  | ACTIVE |  | ACCESSORIES
SAMPLE B |  | HALF HANG CARD | 879640000011 |  |  | 10879640000018 |  |  |  |  | ACTIVE |  | ACCESSORIES
SAMPLE C |  | HANG CARD | 879640010539 |  |  | 10879640010536
N/A |  |  | 87964001054 |  |  | 10879640010543
SAMPLE D |  |  | 879640010553 |  |  | 10879640010550
N/A |  |  | 87964001056 |  |  | 1087964001056
N/A |  |  | 87964002239 |  |  | 1087964002239
SAMPLE F |  |  | 87964002240 |  |  | 1087964002240
 | END OF PRODUCT    ••••••••••••••••••••••••••••••••••••••••••••••••••••••••••
Spreadsheet: 848583d1699290442-align-data-from-rows-to-columns-parent-1-and-2-example-2-aligw
Sheet: Sheet2

Student Last | Student First | Parent 1 Last | Parent 1 First | Parent 2 Last | Parent 2 First |  |  | student_firstName | Parent Last Name | Parent First Name
[NAME] | [NAME] | [NAME] | Mom | [NAME] | Dad |  | [NAME] | [NAME] | [NAME] | Mom
[NAME] | Kaylee | [NAME] | Mom | [NAME] | Dad |  | [NAME] | [NAME] | [NAME] | Dad
 |  |  |  |  |  |  | [NAME] | Kaylee | [NAME] | Mom
 |  |  |  |  |  |  | [NAME] | Kaylee | [NAME] | Dad
Spreadsheet: 729745d1619301165-help-with-countif-formula-for-calendar-countif-any-date-in-table-present-schedule-workbook-stat-holiday-help
Sheet: Employee List

Name | Number
Employee 1 | (123) 456-7890
Employee 2 | (123) 456-7891
Employee 3 | (123) 456-7892
Employee 4 | (123) 456-7893
Employee 5 | (123) 456-7894
Employee 6 | (123) 456-7895
Employee 7 | (123) 456-7896
Employee 8 | (123) 456-7897
Employee 9 | (123) 456-7898
Employee 10 | (123) 456-7899
Employee 11 | (123) 456-7900
Employee 12 | (123) 456-7901
Employee 13 | (123) 456-7902
Employee 14 | (123) 456-7903
Employee 15 | (123) 456-7904
Employee 16 | (123) 456-7905
Employee 17 | (123) 456-7906
Employee 18 | (123) 456-7907
Employee 19 | (123) 456-7908
Employee 20 | (123) 456-7909
Employee 21 | (123) 456-7910
Spreadsheet: 38806d1236953563-conditional-formatting-mearsy1
Sheet: Sheet2

 | 2009-02-09 00:00:00 | 2009-02-16 00:00:00 | 2009-02-23 00:00:00 | 2009-03-02 00:00:00 | 2009-03-09 00:00:00 | 2009-03-16 00:00:00 | 2009-03-23 00:00:00 | 2009-03-30 00:00:00 | 2009-04-06 00:00:00 | 2009-04-13 00:00:00
[NAME] | 0.8931863979848866 | 0.9113956466069142 | 0.8879028436018958 | 0.8863408521303258
Aberdeen | 0.9096216216216216 | 0.8890532544378698 | 0.8856862745098039 | 0.9080924855491329
Barking | 0.8632024793388431 | 0.8957461024498886 | 0.9157734204793029 | 0.9147877358490567
Ipswich | 0.8986446280991736 | 0.8940453074433656 | 0.8996061643835617 | 0.9108585055643879
Crawley | 0.796598114824336 | 0.788904593639576 | 0.781469465648855 | 0.7870338983050847
Totton | 0.792890365448505 | 0.8823611111111112 | 0.8692936802973977 | 0.8776953125
Bristol | 0.7844705882352941 | 0.8146237731733915 | 0.7800200400801603 | 0.8190909090909091
Plymouth | 0.6126013513513514 | 0.8326744186046511 | 0.8 | 0.8
Brinsworth | 0.8605641025641027 | 0.8653272101033295 | 0.8544619105199516 | 0.8939910313901345
CLS | 0.7312170385395538 | 0.8868632075471699 | 0.8507983193277311 | 0.8936902050113895
Wolves | 0.7972555205047318 | 0.8448989898989899 | 0.8688521882741536 | 0.8698817567567567
Spreadsheet: 39811d1238083927-vlookup-match-concatenate-example1
Sheet: Sheet2

A | B | C | D | E | F | G | H | I | J | K | L | M | N | O | P
10400787 | 1010 | 509 | G3AHTP08 | V63 | AF130067XUKU | 12 | A590628 | 16200 | EA | 2009-03-20 00:00:00 | 2009-03-13 00:00:00 |  | HIT | Yes
10400831 | 1010 | 509 | G3AHTP08 | V11 | AF130067XSP | 12 | A590643 | 6400 | EA | 2009-03-16 00:00:00 | 2009-03-13 00:00:00 |  | HIT | Yes
10405118 | 1010 | 509 | G3AHTP08 | V11 | AF130067XIT | 12 | A596839 | 800 | EA | 2009-03-27 00:00:00 | 2009-03-13 00:00:00 |  | HIT | Yes
10405119 | 1010 | 509 | G3AHTP08 | V11 | AF130067XPG | 12 | A596841 | 500 | EA | 2009-03-27 00:00:00 | 2009-03-13 00:00:00 |  | HIT | Yes
10405168 | 1010 | 509 | G3AHTP08 | V11 | AF130067XFN | 12 | A596837 | 700 | EA | 2009-03-26 00:00:00 | 2009-03-13 00:00:00 |  | HIT | Yes
10405169 | 1010 | 509 | G3AHTP08 | V11 | AF130067XSW | 12 | A596840 | 1600 | EA | 2009-03-13 00:00:00 | 2009-03-13 00:00:00 |  | HIT | No
10405152 | 2010 | 509 | Q1000041 | V11 | AF130001KPO | 12 | A596858 | 160 | EA | 2009-04-03 00:00:00 | 2009-03-09 00:00:00 |  | HIT | No
10405155 | 2010 | 509 | Q1000041 | V11 | AF130001KAB | 12 | A596861 | 900 | EA | 2009-03-25 00:00:00 | 2009-03-09 00:00:00 |  | HIT | No
10405172 | 2010 | 509 | Q1000041 | V11 | AF130001KGE | 12 | [NAME] | 1690 | EA | 2009-04-01 00:00:00 | 2009-03-09 00:00:00 |  | HIT | No
10405175 | 2010 | 509 | Q1000041 | V11 | AF130001KDA | 12 | A596865 | 630 | EA | 2009-04-02 00:00:00 | 2009-03-09 00:00:00 |  | HIT | No
10405151 | 3010 | 509 | Q1000042 | V11 | AF130001KIT | 12 | A596849 | 2944 | EA | 2009-03-24 00:00:00 | 2009-03-11 00:00:00 |  | HIT | No
10405152 | 3010 | 509 | Q1000042 | V11 | AF130001KPO | 12 | A596858 | 160 | EA | 2009-03-13 00:00:00 | 2009-03-11 00:00:00 |  | HIT | No
10405155 | 3010 | 509 | Q1000042 | V11 | AF130001KAB | 12 | A596861 | 900 | EA | 2009-03-13 00:00:00 | 2009-03-11 00:00:00 |  | HIT | No
10405172 | 3010 | 509 | Q1000042 | V11 | AF130001KGE | 12 | [NAME] | 1690 | EA | 2009-03-16 00:00:00 | 2009-03-11 00:00:00 |  | HIT | No
10405175 | 3010 | 509 | Q1000042 | V11 | AF130001KDA | 12 | A596865 | 630 | EA | 2009-03-16 00:00:00 | 2009-03-11 00:00:00 |  | HIT | No
10405182 | 3010 | 509 | Q1000042 | V11 | AF130001KNL | 12 | A596855 | 2873 | EA | 2009-03-17 00:00:00 | 2009-03-11 00:00:00 |  | HIT | No
10405151 | 4010 | 509 | Q1QP0002 | V11 | AF130001KIT | 12 | A596849 | 2944 | EA | 2009-03-27 00:00:00 | 2009-03-12 00:00:00 |  | HIT | No
10405182 | 4010 | 509 | Q1QP0002 | V11 | AF130001KNL | 12 | A596855 | 2873 | EA | 2009-03-20 00:00:00 | 2009-03-12 00:00:00 |  | HIT | No
10405152 | 4010 | 509 | Q1QP0002 | V11 | AF130001KPO | 12 | A596858 | 160 | EA | 2009-03-18 00:00:00 | 2009-03-13 00:00:00 |  | HIT | No
10405155 | 4010 | 509 | Q1QP0002 | V11 | AF130001KAB | 12 | A596861 | 900 | EA | 2009-03-18 00:00:00 | 2009-03-13 00:00:00 |  | HIT | No
Spreadsheet: 767488d1644497184-fill-cells-with-data-that-has-the-same-location-data-on-label
Sheet: Stock

AREA | AISLE | ADDRESS | PARTNR | [NAME] | FGRP | BAL
65 | 12 | 7011 | 1 | Rearview mirror RH | 1 | 5
65 | 12 | 7011 | 2 | Rearview mirror [NAME] | 1 | 1
65 | 5 | 8201 | 3 | Alternator | 5 | 2
65 | 6 | 8201 | 4 | Starter | 6 | 1
65 | 2 | 8201 | 5 | Alternator | 5 | 3
65 | 2 | 8201 | 6 | Starter | 6 | 5
66 | 3 | 12022 | 7 | Injector | 10 | 17
66 | 3 | 12022 | 8 | Carburettor | 15 | 2
65 | 12 | 7501 | 9 | Grille | 2 | 0
65 | 12 | 7011 | 10 | Mirror | 1 | 0
67 | 1 | 1 | 11 | windscreen | 1 | 0
65 | 12 | 7501 | 12 | Front Bumper | 35 | 1
65 | 12 | 7701 | 13 | Rear Bumper | 35 | 2
66 | 3 | 12022 | 14 | Injector | 10 | 6
Spreadsheet: 863123d1710687223-please-help-me-calculate-the-maximum-consecutive-negative-value-in-a-column-example
Sheet: Sheet1

5
10
-2
-5
5
2
5
-10
6
4
-11
-2
-5
-3
-7
54
61
-1023
-1
57
33
4
Spreadsheet: 0f6fc773-fcf3-4f39-9d87-0f011a5232c4
Sheet: Sheet1

AOP | [NAME] | KOLONA2 | KOLONA3 | [NAME] | KONTRBR | OPCPOD | DATUM | STO_JE_UNUTRA | RAZLIKE
1 | 0 | 0 | 0 | 0 | 0 | 0 | 00:00:00 | <ziro racun> | 0
2 | 0 | 0 | 0 | 0 | 0 |  |  | <maticni broj> | 0
3 | 0 | 0 | 0 | 0 | 0 |  |  | <naziv> | 0
4 | 0 | 0 | 0 | 0 | 0 | 0 |  | <postanski broj> | 0
5 | 0 | 0 | 0 | 0 | 0 |  |  | <mjesto> | 0
6 | 0 | 0 | 0 | 0 | 0 |  |  | <ulica i broj> | 0
7 | 0 | 0 | 0 | 0 | 0 |  |  | <djelatnost> | 0
8 | 0 | 0 | 0 | 0 | 0 | 0 |  | <zupanija> | 0
9 | 0 | 0 | 0 | 0 | 0 | 0 |  | <opcina> | 0
10 | 0 | 0 | 0 | 0 | 0 | 0 |  | <MB pripojenog 1> | 0
11 | 0 | 0 | 0 | 0 | 0 | 0 |  | <MB pripojenog 2> | 0
12 | 0 | 0 | 0 | 0 | 0 | 0 |  | <MB pripojenog 3> | 0
13 | 0 | 0 | 0 | 0 | 0 | 0 |  | <MB stat prom 1> | 0
14 | 0 | 0 | 0 | 0 | 0 | 0 |  | <MB stat prom 2> | 0
15 | 0 | 0 | 0 | 0 | 0 | 0 |  | <MB stat prom 3> | 0
16 | 0 | 0 | 0 | 0 | 0 | 0 |  | <sif obveze revizije> | 0
17 | 0 | 0 | 0 | 0 | 0 |  |  | <zakonski predst drustva> | 0
18 | 0 | 0 | 0 | 0 | 0 |  |  | <voditelj racunovodstva> | 0
19 | 0 | 0 | 0 | 0 | 0 |  |  | <kontakt osoba> | 0
20 | 0 | 0 | 0 | 0 | 0 |  |  | <telefon> | 0
21 | 0 | 0 | 0 | 0 | 0 |  |  | <telefax> | 0
22 | 0 | 0 | 0 | 0 | 0 |  |  | <e-mail> | 0
23 | 0 | 0 | 0 | 0 | 0 |  |  | <internet adresa> | 0
24 | 0 | 0 | 0 | 0 | 0 |  |  | <datum zadnje revizije> | 0
0 | 0 | 0 | 0 | 0 | 0 |  |  | <godina> | 0
0 | 0 | 0 | 0 | 0 | 0 | 0 |  | <kontrolni broj> | 0
0 | 0 | 0 | 0 | 0 | 0 | 0 |  | <vrsta izvjestaja> | 0
0 | 0 | 0 | 0 | 0 | 0 |  |  | <mjesec> | 0
0 | 0 | 0 | 0 | 0 | 0 | 303 |  | <verzija Excela> | 0
0 | 0 | 0 | 0 | 0 | 0 | 811 |  | <vrsta posla> | 0
0 | 0 | 0 | 0 | 0 | 0 | 0 |  | <oznaka> | 0
0 | 0 | 0 | 0 | 0 | 0 | 0 |  | <razina> | 0
0 | 0 | 0 | 0 | 0 | 0 | 0 |  | <razdjel> | 0
0 | 0 | 0 | 0 | 0 | 0 | 0 |  | <glava> | 0
0 | 0 | 0 | 0 | 0 | 0 | 0 |  | <rkp> | 0
0 | 0 | 0 | 0 | 0 | 0 | 0 |  | <razlike> | 0
 |  |  |  |  |  | 0 |  | <OIB>
Spreadsheet: 86392d1286382856-need-to-count-productivity-by-weekly-and-daily-basis-qc-report
Sheet: PMT

 | Reported Date is : | 2010-10-06 00:00:00 |  | Monthly Period |  | 2010-10-01 00:00:00 |  | To
 | Reported Date is : | 2010-10-06 00:00:00 |  | Weekly Period |  | 2010-10-04 00:00:00 |  | To
 | Reported Date is : | 2010-10-06 00:00:00 |  | Daily Period |  | 2010-10-06 00:00:00 |  | To
 | Processor Name | # of File Processed |  |  |  | QC Name | # of File QC'd
 |  | Monthly | Weekly | Daily |  |  | Monthly | Weekly | Daily
 | [NAME] |  |  |  |  | [NAME]
 | Vinod |  |  |  |  | Vinod
 | Hiren |  |  |  |  | Hiren
 | Nikhilesh |  |  |  |  | Nikhilesh
 | Prawin |  |  |  |  | Prawin
 |  |  |  |  |  | Kamran
 | Total |  |  |  |  | Total
 |  |  | {=SUMPRODUCT((FTS!$C$8:$C$6535>=$F$2)*1*(FTS!$C$8:$C$6535<=$I$2+1))
 |  |  | {=IF(B8="","",COUNTIF(QC!$CM$6:$CM$1050,$B8))
Spreadsheet: 817210d1676053662-hlookup-between-multiple-dates-excel-formula-issue
Sheet: Sheet1

Amendment
Amendment | Contract Effective Date | Visit 1 | Visit 2 | Visit 3 | Visit 4
 | 2020-10-14 00:00:00 | 1000 | 2000 | 3000 | 4000
AM01 | 2022-02-07 00:00:00 | 1001 | 2001 | 3001 | 4001 |  |  |  |  |  |  |  |  | Points Min | Points Max | Grade
AM02 | 2022-04-26 00:00:00 | 1002 | 2002 | 3002 | 4002 |  |  |  |  |  |  |  |  | 55 | 64 | 6
AM03 | 2022-10-26 00:00:00 | 1003 | 2003 | 3003 | 4003 |  |  |  |  |  |  |  |  | 65 | 74 | 7
 |  |  |  |  |  |  |  |  |  |  |  |  |  | 75 | 84 | 8
 |  |  |  |  |  |  |  |  |  |  |  |  |  | 85 | 94 | 9
 | Visit 1 | Visit 2 | Visit 3 | Visit 4 |  |  |  |  |  |  |  |  |  | 95 | 100 | 10
Visit Date | 2021-12-14 00:00:00 | 2022-03-07 00:00:00 | 2022-05-26 00:00:00 | 2022-12-01 00:00:00
Amount | 1000 | 2001 | 3001 | 4001
Should be | 1000 | 2001 | 3002 | 4003
Difference | 0 | 0 | -1 | -2
Spreadsheet: 598774d1542715448-combining-rows-and-data-example1
Sheet: Sheet1

[NAME] | Vendor & GL Text | PO No | EXT.SERVICES | Total Cost | # Materials Used | Actual PO Cost | Maintenance Cost
EG Substation HV Maintenance | # | # | 8717 | 8717 | 1 |  | 8717
2nd draw crane Invoice I53143u | # | # | 6456.56 | 6456.56 | 1 |  | 6456.56
[NAME] 1,2 and 3 Thoroughbred | # | # | 3600 | 3600 | 2 |  | 3600
V pulley and shaft made by jj | # | # | 3054 | 3054 | 1 |  | 3054
2018 Evoqua Water Blanket PO | # | # | 2666.66 | 2666.66 | 1 |  | 2666.66
Yearly Plant PM - Ivey Mechanical | # | # | 2375 | 2375 | 0 |  | 2375
[NAME] | # | # | 1117.99 | 1117.99 | 0 |  | 1117.99
[NAME] | # | # | 243.08 | 243.08 | 1 |  | 243.08
EG Crane Trolly track repair | # | # | 218.76 | 218.76 | 0 |  | 218.76
EG Substation HV Maintenance | RECO LLC | [PHONE] |  |  |  | 8717
2nd draw crane Invoice I53143u | BOHNERT EQUIPMENT CO INC | [PHONE] |  |  |  | 6456.56
[NAME] 1,2 and 3 Thoroughbred | THOROUGHBRED CONTRACTORS | [PHONE] |  |  |  | 1850
[NAME] 1,2 and 3 Thoroughbred | THOROUGHBRED CONTRACTORS | [PHONE] |  |  |  | 1750
Spreadsheet: 631703d1562806909-sum-until-next-non-blank-cell-in-another-column-example
Sheet: Sheet1

Product A | 10
 | 20
 | 30
 | 40
Product B | 50
 | 60
 | 80
Product C | 10
 | 20
Product D | 10
 | 10
 | 20
 | 20
 | 10
 | 20
Product E | 10
Spreadsheet: 799765d1665258184-additional-charge-on-incremental-year-additional-charge-on-incremental-year
Sheet: Sheet1

 | Additional Charge on Incremental Year
 |  |  |  |  | <--------------------------------------------------------- Expected Results --------------------------------------------------------->
 | Normal Inspection | Start Year | Annual Charge | No. of Units | 1
 | Machinery A | 1 | 100 | 1200
 | Machinery C | 3 | 200 | 1800
 | Machinery B | 5 | 300 | 2100
 | Additional Inspection | Increment Year* | Annual Charge | Machinery A | Machinery B | Machinery C
 | Special inspection #1 | 0 | 150 | 0.1 | 0 | 0.1
 | Special inspection #2 | 1 | 200 | 0.05 | 0.05 | 0.05
 | * incremental year from start year of respective machinery => for Type A Machinery, Normal Inspection starts on Year 1 while Special Inspection #2 starts on Year 2 (1+1)
 | 3 different types of machinery (Type A, B and C) and 3 different sets of inspections (Normal Inspection and 2 additional inspections: Special Inspection #1 and Special Inspection #2).
 | Special inspections start based on the incremental year from start year of respective machinery.
 |  |  | >>>>>>>>>>>>>>>>>>
Spreadsheet: 90280d1290028517-excel-2007-creating-a-list-based-off-selected-cells-list-test
Sheet: W20

20" Wall Cabinets
Cabinet [NAME].
location: |  | Kitchen, Upper
Height: |  | 20"/12" deep
Door: |  | [NAME]
Species: |  | Group 2
Interior: |  | [NAME]
 |  |  |  | Single door cabinets |  |  |  |  | Double Door Cabinets
 |  |  |  | 7 1/2" to 21" wide |  |  |  |  | 21" to 39" wide
 | [NAME] |  | Price |  | FG | Quantity | Total Price |  |  | page total |  |  |  | box price | door price | finish price
Single door cabinets | 7.5 | WS7.5.20
 | 9 | WS9.20
 | 10.5 | WS10.5.20
 | 12 | WS12.20 |  |  |  | 1 |  |  |  | Finished Gables
 | 13.5 | WS13.5.20
 | 15 | [NAME]
 | 16.5 | WS16.5.20
 | 18 | WS18.20
 | 19.5 | WS19.5.20 |  |  |  | 1
 | 21 | [NAME]
Double door Cabinets | 21 | WD21.20
 | 22.5 | WD22.5.20
 | 24 | WD24.20
 | 25.5 | WD25.5.20 |  |  |  | 1
 | 27 | WD27.20
 | 28.5 | WD28.5.20
 | 30 | WD30.20
 | 31.5 | WD31.5.20 |  |  |  | 1
 | 33 | WD33.20
 | 34.5 | WD34.5.20
 | 36 | WD36.20
 | 37.5 | WD37.5.20
 | 39 | WD39.20
May 5/2010
Spreadsheet: 186398d1350028008-combine-two-formulas-sumproduct-example-1
Sheet: Sheet1

 |  |  |  | Array 1 both match |  |  | both blanks
 | Alter to test |  |  | check | value |  | Column 1 | Column 2 | Result
 | cat | dog
 | cat
 |  | cat
 | dog
 | dog | cat
 | cat
 |  | cat
 | dog | dog
 |  |  |  |  |  |  |  |  |  |  | Result
 |  |  |  | count= |  |  |  | count=
 |  |  |  | [NAME] |  |  |  | count sumproduct =
list for validation
cat |  |  |  |  |  |  |  | it could also be writen in 1 formula like this
dog |  |  | =SUMPRODUCT(--(B4:B12=C4:C12)-(--(B4:B12="")*--(C4:C12="")))
Spreadsheet: b51c28b7-b623-4538-b013-9a4313453bc3
Sheet: Sheet1

Unnamed: 0 | Unnamed: 1 | Unnamed: 2 | Unnamed: 3 | Unnamed: 4 | Unnamed: 5 | Unnamed: 6
 |  | [NAME] distinct to medium | [NAME] used by organism 1 | [NAME] used by organism 2 | [NAME] exchanged [NAME] to Org2 | [NAME] exchanged Org 2 to Org1
Organism pair | (1) S. cerevisiae (2) E. coli | fmn, gua, met-L, zymst | fmn, met-L, so4, zymst | gua,  met-L | [NAME], pi | adn
 | (1) S. cerevisiae (2) E. coli | met-L, pi, pyr | met-L, pi, pyr | met-L, pi, pyr | [NAME] | ser-L
 | (1) E. coli  (2) H. pylori | butso3, tyrp, urea | butso3, tyrp | urea | ala-D, his-L, ile-L, leu-L, orn, pi, val-L | nh4
 | (1) E. coli  (2) H. pylori | ade, pi, so4 | ade, pi, so4 | ade, pi | akg, ala-D, arg-L, etoh, his-L, ile-L, leu-L, nh4, [NAME], val-L | [NAME], [NAME], orn
 | Table S4
 | This table describes the exchanged metabolites for two mutualism-inducing media for two different interacting pairs of organisms.  For the S. cerevisiae - E. coli pair, we verified that  individual species can grow on artificially added nutrients predicted to be provided by the symbiotic partner.
 | metabolite key: [NAME] (fmn); guanine (gua); [NAME] (met-L); zymosterol (zymst); inorganic phosphate (pi); pyruvate (pyr); butanesulfonate (butso3); tyrosine-phosphate (tyrp); urea (urea); adenine (ade); sulphate (so4); cysteine-L(cys-L); alanine-D (ala-D); histamine-L (his-L); ethanol (etoh); arginine-L (arg-L); isoleucine-L (ile-L); leucine-L (leu-L); ammonium (nh4); threonine-L (thr-L); [NAME] (val-L); serine-L (ser-L); acetaldehyde (acald); glutamine-L ([NAME]); ornithine (orn)
Spreadsheet: 105653d1302951191-2-way-lookup-with-rule-2-way-lookup
Sheet: Sheet1

Wall | 1 | 2 | 3 | 4 | 5 |  | Colors |  | Specific
Back wall | Green | Blue | Yellow | Red | Green |  | Green |  | Green
Front Wall | Yellow | Red | Orange | Blue | Green |  | Blue |  | Blue
Side Wall | Yellow | Green | Yellow | Orange | Orange |  | Yellow |  | Yellow
Ceiling | Blue | Red | Orange | Green | Yellow |  | Red
 |  |  |  |  |  |  | Orange
Wall | 1 | 2 | 3 | 4 | 5
Back wall
Front Wall
Side Wall
Ceiling