tianzl66/Sheetpedia huggingface dataset:
Spreadsheet: 802992d1667203691-combine-multiple-column-with-header-into-one-column-s666-pq-example-combine
Sheet: Sheet1

 |  |  |  |  |  |  |  |  |  | to combine B column with [NAME] column in C to F into one column
 |  |  |  |  |  |  | EXPECTED RESULT
 | CODE | BOX1 | [NAME] | BOX3 | BOX4 |  | CODE |  |  | Code | Value
 | BB1 | 0 | 12 | 77 | 0 |  |  | 0 |  | BB1BOX1 | 0
 | BB2 | 164 | 36 | 77 | 52 |  |  | 164 |  | BB2BOX1 | 164
 | BB3 | 4 | 9 | 73 | 0 |  |  | 4 |  | BB3BOX1 | 4
 | BB4 | 222 | 42 | 82 | 54 |  |  | 222 |  | BB4BOX1 | 222
 | BB5 | 17 | 11 | 0 | 0 |  |  | 17 |  | BB5BOX1 | 17
 | BB6 | 12 | 15 | 0 | 0 |  |  | 12 |  | BB6BOX1 | 12
 | BB7 | 864 | 377 | 1838 | 173 |  |  | 864 |  | BB7BOX1 | 864
 | BB8 | 0 | 45 | 302 | 0 |  |  | 0 |  | BB8BOX1 | 0
 | BB9 | 294 | 91 | 687 | 98 |  |  | 294 |  | BB9BOX1 | 294
 | BB10 | 233 | 64 | 523 | 96 |  |  | 233 |  | BB10BOX1 | 233
 | BB11 | 254 | 247 | 503 | 75 |  |  | 254 |  | BB11BOX1 | 254
 | BB12 | 0 | 16 | 16 | 0 |  |  | 0 |  | BB12BOX1 | 0
 | [NAME] | 140 | 30 | 134 | 29 |  |  | 140 |  | BB13BOX1 | 140
 | BB14 | 134 | 29 | 0 | 0 |  |  | 134 |  | BB14BOX1 | 134
 |  |  |  |  |  |  |  | 12 |  | BB1BOX2 | 12
 |  |  |  |  |  |  |  | 36 |  | BB2BOX2 | 36
 |  |  |  |  |  |  |  | 9 |  | [NAME] | 9
 |  |  |  |  |  |  |  | 42 |  | BB4BOX2 | 42
 |  |  |  |  |  |  |  | 11 |  | BB5BOX2 | 11
 |  |  |  |  |  |  |  | 15 |  | BB6BOX2 | 15
 |  |  |  |  |  |  |  | 377 |  | BB7BOX2 | 377
 |  |  |  |  |  |  |  | 45 |  | BB8BOX2 | 45
 |  |  |  |  |  |  |  | 91 |  | BB9BOX2 | 91
 |  |  |  |  |  |  |  | 64 |  | BB10BOX2 | 64
 |  |  |  |  |  |  |  | 247 |  | BB11BOX2 | 247
 |  |  |  |  |  |  |  | 16 |  | BB12BOX2 | 16
 |  |  |  |  |  |  |  | 30 |  | BB13BOX2 | 30
 |  |  |  |  |  |  |  | 29 |  | BB14BOX2 | 29
 |  |  |  |  |  |  |  | 77 |  | BB1BOX3 | 77
 |  |  |  |  |  |  |  | 77 |  | BB2BOX3 | 77
 |  |  |  |  |  |  |  | 73 |  | BB3BOX3 | 73
 |  |  |  |  |  |  |  | 82 |  | BB4BOX3 | 82
 |  |  |  |  |  |  |  | 0 |  | BB5BOX3 | 0
 |  |  |  |  |  |  |  | 0 |  | BB6BOX3 | 0
 |  |  |  |  |  |  |  | 1838 |  | BB7BOX3 | 1838
 |  |  |  |  |  |  |  | 302 |  | BB8BOX3 | 302
 |  |  |  |  |  |  |  | 687 |  | BB9BOX3 | 687
 |  |  |  |  |  |  |  | 523 |  | BB10BOX3 | 523
 |  |  |  |  |  |  |  | 503 |  | BB11BOX3 | 503
 |  |  |  |  |  |  |  | 16 |  | BB12BOX3 | 16
 |  |  |  |  |  |  |  | 134 |  | BB13BOX3 | 134
 |  |  |  |  |  |  |  | 0 |  | BB14BOX3 | 0
 |  |  |  |  |  |  |  | 0 |  | BB1BOX4 | 0
 |  |  |  |  |  |  |  | 52 |  | BB2BOX4 | 52
 |  |  |  |  |  |  |  | 0 |  | BB3BOX4 | 0
 |  |  |  |  |  |  |  | 54 |  | BB4BOX4 | 54
 |  |  |  |  |  |  |  | 0 |  | [NAME] | 0
 |  |  |  |  |  |  |  | 0 |  | BB6BOX4 | 0
 |  |  |  |  |  |  |  | 173 |  | BB7BOX4 | 173
 |  |  |  |  |  |  |  | 0 |  | BB8BOX4 | 0
 |  |  |  |  |  |  |  | 98 |  | BB9BOX4 | 98
 |  |  |  |  |  |  |  | 96 |  | [NAME] | 96
 |  |  |  |  |  |  |  | 75 |  | [NAME] | 75
 |  |  |  |  |  |  |  | 0 |  | BB12BOX4 | 0
 |  |  |  |  |  |  |  | 29 |  | BB13BOX4 | 29
 |  |  |  |  |  |  |  | 0 |  | BB14BOX4 | 0
Spreadsheet: 699887d1602812037-need-help-with-adding-two-more-columns-assessment-tracker2
Sheet: 1

Teacher: |  |  |  | Student:
Course Name:
Course Code:
 |  |  |  |  |  |  |  |  |  |  | Categories Evaluated |  |  |  |  | unn
Assessment Name | Date Submitted | P/O/C | Overall Expectations | Mark | Out Of | % Grade | Level | Weight |  | Assessment Name | K | T | C | A
Summatives | Date Submitted | P/O/C | Overall Expectations | Mark | Out Of | % Grade | Level | Weight |  | Summatives | K | T | C | A
 |  |  |  |  |  |  |  |  |  | Total:
Total Products |  |  |  | 0.7 |  | Raw Mean Grade:
Total Observations |  |  |  |  |  | Weighted Mean Grade:
Total Conversations
 |  |  |  | 0.3 |  | Raw Mean Grade: |  |  |  | Overall Expectation Tracker
Level 0 |  |  |  |  |  | Weighted Mean Grade: |  |  |  | A1/1.1 |  |  | D1/4.1
Level 1 |  |  |  |  |  |  |  |  |  | A2/1.2 |  |  | D2/4.2
Level 2 |  |  |  |  |  | Final Grade: |  |  |  | A3/1.3 |  |  | D3/4.3
Level 3 |  |  |  |  |  |  |  |  |  | A4/1.4 |  |  | [NAME]
Level 4 |  |  |  |  | Grade on Report Card: |  |  |  |  | A5/1.5 |  |  | D5/4.5
 |  |  |  |  |  |  |  |  |  | A6/1.6 |  |  | D6/4.6
 |  |  |  |  |  |  |  |  |  | B1/2.1 |  |  | E1/5.1
 |  |  |  |  |  |  |  |  |  | [NAME] |  |  | E2/5.2
 |  |  |  |  |  |  |  |  |  | B3/2.3 |  |  | E3/5.3
 |  |  |  |  |  |  |  |  |  | [NAME] |  |  | E4/5.4
 |  |  |  |  |  |  |  |  |  | B5/2.5 |  |  | E5/5.5
 |  |  |  |  |  |  |  |  |  | B6/2.6 |  |  | E6/5.6
 |  |  |  |  |  |  |  |  |  | C1/3.1 |  |  | F1/6.1
 |  |  |  |  |  |  |  |  |  | C2/3.2 |  |  | F2/6.2
 |  |  |  |  |  |  |  |  |  | C3/3.3 |  |  | F3/6.3
 |  |  |  |  |  |  |  |  |  | C4/3.4 |  |  | F4/6.4
 |  |  |  |  |  |  |  |  |  | C5/3.5 |  |  | F5/6.5
 |  |  |  |  |  |  |  |  |  | C6/3.6 |  |  | F6/6.6
Spreadsheet: 174599d1345123151-transpose-of-3-rows-a1-fotismetafora-dedomenon-1
Sheet: Φύλλο1

Α/Α | Names | Monday | Tusday | Wednesday | Thursday | Friday | Saturday | Sunday |  | Α/Α | Order |  |  |  | 1900-01-02 00:00:00 | 1900-01-03 00:00:00 | 1900-01-04 00:00:00 | 1900-01-05 00:00:00 | 1900-01-06 00:00:00 | 1900-01-07 00:00:00 | 1900-01-08 00:00:00 | 1900-01-09 00:00:00 | 1900-01-10 00:00:00 | 1900-01-11 00:00:00 | 1900-01-12 00:00:00 | 1900-01-13 00:00:00 | 1900-01-14 00:00:00 | 1900-01-15 00:00:00 | 1900-01-16 00:00:00 | 1900-01-17 00:00:00 | 1900-01-18 00:00:00 | 1900-01-19 00:00:00 | 1900-01-20 00:00:00 | 1900-01-21 00:00:00 | 1900-01-22 00:00:00 | 1900-01-23 00:00:00
1 | A | 1 | 2 | 3 | 4 | 5 | 6 | 7
1 | A | 8 | 9 | 10 | 11 | 12 | 13 | 14
1 | A | 15 | 16 | 17 | 18 | 19 | 20 | 21
2 | G | 1 | 2 | 3 | 4 | 5 | 6 | 7
2 | G | 8 | 9 | 10 | 11 | 12 | 13 | 14
2 | G | 15 | 16 | 17 | 18 | 19 | 20 | 21
3 | L | 1 | 2 | 3 | 4 | 5 | 6 | 7
3 | L | 8 | 9 | 10 | 11 | 12 | 13 | 14
3 | L | 15 | 16 | 17 | 18 | 19 | 20 | 21
 |  |  |  |  |  |  |  |  |  |  |  |  |  | We want like this
 |  | Table is like this.
Spreadsheet: 790897d1660054884-formula-for-totals-across-multiple-tabs-countifs-non-equal-columns2-eba
Sheet: 18

Name | Full Time Home Point | Full Time Away Point | Full Time ResultResult | Half Time Home Point | Half Time Away Point | Half Time Result |  |  | [NAME] | Helper
[NAME] | 0 | 0 | d | 0 | 0 | d
[NAME] | 1 | 0 | h | 0 | 0 | d
[NAME] | 0 | 1 | a | 0 | 0 | d
[NAME] | 1 | 1 | d | 1 | 0 | h
[NAME] | 1 | 0 | h | 0 | 0 | d
[NAME] | 2 | 1 | h | 1 | 0 | h
[NAME] | 0 | 0 | d | 0 | 0 | d
Bethany | 1 | 4 | a | 1 | 0 | h
[NAME] | 6 | 0 | h | 1 | 0 | h
[NAME] | 2 | 1 | h | 0 | 0 | d
Nicki | 0 | 0 | d | 0 | 0 | d
[NAME] | 0 | 1 | a | 0 | 0 | d
[NAME] | 3 | 0 | h | 1 | 0 | h
[NAME] | 0 | 1 | a | 0 | 0 | d
[NAME] | 0 | 0 | d | 0 | 0 | d
[NAME] | 2 | 1 | h | 1 | 0 | h
Nicki | 0 | 1 | a | 0 | 1 | a
[NAME] | 0 | 0 | d | 0 | 0 | d
[NAME] | 1 | 0 | h | 1 | 0 | a
[NAME] | 2 | 0 | h | 1 | 0 | a
[NAME] | 3 | 1 | h | 1 | 1 | d
Nicki | 1 | 0 | h | 0 | 0 | d
[NAME] | 2 | 1 | h | 1 | 0 | h
[NAME] | 1 | 1 | d | 0 | 1 | a
Nicki | 2 | 2 | d | 1 | 0 | h
[NAME] | 4 | 1 | h | 0 | 0 | d
[NAME] | 1 | 2 | a | 0 | 1 | a
[NAME] | 4 | 0 | h | 1 | 0 | h
Bethany | 0 | 2 | a | 0 | 1 | a
[NAME] | 0 | 0 | d | 0 | 0 | d
Nicki | 1 | 1 | d | 0 | 1 | a
[NAME] | 0 | 0 | d | 0 | 0 | d
[NAME] | 0 | 1 | a | 0 | 0 | d
[NAME] | 5 | 0 | h | 1 | 0 | h
[NAME] | 4 | 1 | h | 1 | 1 | d
[NAME] | 0 | 2 | a | 0 | 0 | d
[NAME] | 1 | 1 | d | 0 | 1 | a
[NAME] | 2 | 0 | h | 1 | 0 | h
Bethany | 1 | 0 | h | 0 | 0 | d
[NAME] | 0 | 4 | a | 0 | 2 | a
[NAME] | 1 | 1 | d | 0 | 1 | a
Bethany | 1 | 2 | a | 0 | 1 | a
[NAME] | 4 | 2 | h | 1 | 2 | a
Nicki | 3 | 1 | h | 1 | 1 | d
Spreadsheet: 769034d1645265068-remove-blank-data-in-printout-in-excel-sample-sheet-prinout-hide-aligw
Sheet: Sheet1

Price List |  |  |  |  | Price List
Description | Price | Qty | Amount |  | Description | Price | Qty | Amount
Product1 | 4557 | 96
Product2 | 2844 | 32
Product3 | 1189 | 0
Product4 | 4824 | 42
Product5 | 4929 | 100
Product6 | 4440 | 59
Product7 | 4890
Product8 | 4914 | 34
Product9 | 3283 | 26
Product10 | 4711 | 5
Product11 | 3346 | 36
Product12 | 3347 | 75
Product13 | 2133
Product14 | 4331 | 30
Product15 | 3316 | 24
 |  | Total
Spreadsheet: 93948d1293714178-conditional-aggregation-with-partial-match-testpostcodes
Sheet: Bookings

BookingID | [NAME] | ClientForeName | ClientLastNamer | CustomerAddress | CustomerState | CustomerZip | CustomerEmail | CustomerPhone | Created | [NAME] | Status | TotalCost | PropertyName | PropertyCity | Name | Departures
6658 | 6 | H | jh |  |  | AB45 6GA |  |  |  |  | Booked | 310.08 |  |  |  | 2007
1287 | 13 | T | dsfdsf |  |  | AL2 2JS |  |  |  |  | Booked | 1553 |  |  |  | 2007
1445 | 20 | h | sdfsd |  |  | B31 5BX |  |  |  |  | Booked | 1016 |  |  |  | 2007
482 | 31 | A | sdfds |  |  | BD23 I2D |  |  |  |  | Booked | 1437 |  |  |  | 2007
3441 | 38 | J | sdfds |  |  | BN1 1HD |  |  |  |  | Booked | 81 |  |  |  | 2007
Spreadsheet: 720854d1614325961-dynamically-change-data-in-an-index-formula-sample-excel
Sheet: Sum21

Renewal Item | Item Retrieved | Month
Product A Renewal Notice |  | Jan
Product B Renewal Notice |  | Feb
Product C Renewal Notice |  | Mar
Product D Renewal Notice |  | Mar
Product E Renewal Notice |  | Mar
Product F Renewal Notice |  | Mar
Product G Renewal Notice |  | Apr
Product H Renewal Notice |  | Jul
Product I Renewal Notice |  | Jul
Product J Renewal Notice |  | Aug
Product K Renewal Notice |  | Nov
Product L Renewal Notice |  | Nov
Spreadsheet: 646755d1572010717-sales-commission-formula-help-sales-commission-plan-mike
Sheet: Sheet1

[NAME] | January | February | March | April | May | June | July | August | September | October | November | December | 2020 Revenue
Target
Earned | 150000 |  | 150000 |  |  |  |  |  |  | 210000
Commission
Salary
Total
Monthly bonus:
Cumulative bonus:
Should be
Accum
0.03 |  |  |  |  |  |  |  |  |  |  |  |  | 3% of delivered revenue if under target
0.05 |  |  |  |  |  |  |  |  |  |  |  |  | 5% of delivered revenue if on target
Over
0.05
0.1
Total Over |  |  |  |  |  |  |  |  |  |  |  |  | 10% of revenue delivered that is over target (so you get 5% for hitting and then 10% for anything delivered above target)
Once hit 1.5m accumulative that month should be, 5% up to the 1.5m then 10% |  |  |  |  |  |  |  |  | 10% @
So in October that is hit so commission should be |  |  |  |  |  |  |  |  | 5% @
 | Target | Commission
Q1
Q2 |  |  |  |  |  |  |  |  | October commission should be
Q3
Q4
Commission Structure
3% of delivered revenue if under target
5% of delivered revenue if on target
10% of revenue delivered that is over target (so you get 5% for hitting and then 10% for anything delivered above target)
10% of revenue delivered after $1.5m
Spreadsheet: 159300d1338573418-consolidating-names-and-values-advname_reply
Sheet: Example

 |  |  |  |  |  |  |  |  |  |  | Sample Manual Entry
 |  |  |  |  |  |  |  | 140 | 55 |  |  | 140 | 55
Date | Hd2 | Hd3 | Name / Code |  | Value |  | Emp Name | 1 to 15 | 16 to 30 |  | Emp Name | 1st to 15th | 16th to 31st
2012-04-01 00:00:00 | other data | other data | [NAME] / Some text | other data | 10 |  | George | 20 | 0 |  | [NAME] | 10
2012-04-02 00:00:00 |  |  | [NAME] / Some text |  | 20 |  | [NAME] | 40 | 20 |  | [NAME] | 40 | 20
2012-04-03 00:00:00 |  |  | Apple |  | 40 |  | [NAME] | 10 | 5 |  | [NAME] | 10 | 5
2012-04-04 00:00:00 |  |  | [NAME] / Some text |  | 5 |  | Franchis | 60 | 30 |  | Franchis | 60 | 30
2012-04-05 00:00:00 |  |  | Mango |  | 50 |  | [NAME] | 10 | 0 |  | George | 20
2012-04-06 00:00:00 |  |  | Grapes |  | 12
2012-04-07 00:00:00 |  |  | Franchis / Some text |  | 30
2012-04-08 00:00:00 |  |  | [NAME] text |  | 10
2012-04-09 00:00:00 |  |  | [NAME] / Some text |  | 20
2012-04-10 00:00:00 |  |  | Apple |  | 40
2012-04-11 00:00:00 |  |  | [NAME] / Some text |  | 5
2012-04-12 00:00:00 |  |  | Mango |  | 50
2012-04-13 00:00:00 |  |  | Grapes |  | 12
2012-04-14 00:00:00 |  |  | Franchis / Some text |  | 30
2012-04-15 00:00:00 |  |  | [NAME] text |  | 10
2012-04-16 00:00:00 |  |  | [NAME] / Some text |  | 20
2012-04-17 00:00:00 |  |  | Apple |  | 40
2012-04-18 00:00:00 |  |  | [NAME] / Some text |  | 5
2012-04-19 00:00:00 |  |  | Mango |  | 50 |  | [NAME] | 2012-04-01 00:00:00 | 2012-04-16 00:00:00
2012-04-20 00:00:00 |  |  | Grapes |  | 12 |  |  | 2012-04-15 00:00:00 | 2012-04-30 00:00:00
2012-04-21 00:00:00 |  |  | Franchis / Some text |  | 30
Spreadsheet: 889acf6a-295c-4f41-95ea-a23b9caebc08
Sheet: Sheet1

Bevölkerung des Freistaates Sachsen nach ausgewählten Altersgruppen | Unnamed: 1 | Unnamed: 2 | Unnamed: 3 | Unnamed: 4
Delitzsch, Stadt - Variante 2
Alter von ... bis                     unter ... Jahren | 2011 | 2015 | 2020 | 2025
1 000
unter 3 | 641 | 536 | 442 | 356
3 -   6 | 620 | 571 | 495 | 410
6 - 11 | 967 | 948 | 879 | 765
11 - 17 | 953 | 1072 | 1048 | 985
17 - 19 | 288 | 310 | 342 | 344
19 - 25 | 1751 | 857 | 927 | 934
Insgesamt | 5220 | 4294 | 4133 | 3794
%
unter 3 | 12.27969348659004 | 12.48253376804844 | 10.69441083958384 | 9.383236689509753
3 -   6 | 11.87739463601533 | 13.29762459245459 | 11.97677232034841 | 10.80653663679494
6 - 11 | 18.52490421455939 | 22.07731718677224 | 21.26784418098234 | 20.16341591987348
11 - 17 | 18.25670498084291 | 24.96506753609688 | 25.35688361964675 | 25.96204533473906
17 - 19 | 5.517241379310345 | 7.219375873311598 | 8.274860875877087 | 9.066947812335266
19 - 25 | 33.544061302682 | 19.95808104331626 | 22.42922816356158 | 24.6178176067475
Insgesamt | 100 | 100 | 100 | 100
Gebietsstand: | 1. Januar 2012
Quelle: | 2011 Bevölkerungsfortschreibung auf Basis der [NAME] vom 03. Oktober 1990
 | 2012 - 2025 Bevölkerungsprognose
Bevölkerung jeweils am 31. Dezember
Prognoseergebnisse werden bei der Veröffentlichung immer auf volle [NAME] gerundet. [NAME] basieren [NAME] ungerundeten Werten. Beim [NAME] der [NAME] werden Ihnen die ungerundeten [NAME] zur Verfügung gestellt, damit [NAME] eigenen Berechnungen genauer durchführen können. Die Darstellung der Ergebnisse sollte dann aber wieder gerundet erfolgen.
Spreadsheet: 2287f6c6-9860-4fce-a478-ea7b532dcdbf
Sheet: Sheet1

Unnamed: 0 | FORMULARIO I | Unnamed: 2 | Unnamed: 3 | Unnamed: 4 | Unnamed: 5 | Unnamed: 6 | Unnamed: 7 | Unnamed: 8 | Unnamed: 9 | Unnamed: 10 | Unnamed: 11 | Unnamed: 12 | Unnamed: 13 | Unnamed: 14
 |  |  |  |  |  |  |  |  |  |  |  |  |  | Parte I
 | ORGANIZACIÓN DE AVIACIÓN CIVIL INTERNACIONAL
 | FORMULARIO DE INFORMACIÓN DEL TRANSPORTE AÉREO
 | TRÁFICO DE AEROPUERTOS
 | Persona contacto:
 | Organización: |  |  |  |  |  |  |  |  |  | Estado:
 | Tel: |  |  |  |  |  |  |  |  |  | Nombre del aeropuerto:
 | Fax: |  |  |  |  |  |  |  |  |  | Ciudad:
 | Correo-e: |  |  |  |  |  |  |  |  |  | [NAME] civil:
 |  |  |  |  |  |  |  |  |  |  | [NAME]:
 | Descripción |  |  | Movimientos de aeronaves    Total | Pasajeros |  |  |  | [NAME] |  |  | [NAME]
 |  |  |  |  | Embarcados | Desembarcados | Total             (Col. c + d) | En tránsito directo | Cargadas | Descargadas | Total              (Col. [NAME]) | Cargadas | Descargadas | Total                  (Col. j + k)
 |  |  |  |  |  |  | (c+d) | Transit |  |  |  |  |  | (c+d)
 | a |  |  | b | c | d | e | f | g | h | i | j | k | l
 | [NAME] aéreo comercial
 | 1. Internacional regular……………………………………………………………
 | 2. Internacional no regular……………………………………………………
 | 3. Total internacional (1+2)…………………………………………………………….
 | 4. Interior regular y no regular……………………………….
 | 5. Total del transporte aéreo comercial (1+2+4)…………………………………..
 | 6. Servicios exclusivamente de carga o correo1………………………………………………………………
 | 7. Taxi aéreo y vuelos comerciales [NAME] aviación de negocios2………………………………………………………………
 | [NAME] los demás movimientos………………………………………………………………………..
 | Observaciones (menciónese también toda desviación inevitable respecto de las instrucciones):
 | 1Este tráfico también debe incluirse en los puntos 1 a 5 (véanse las instrucciones). |  |  |  |  |  |  |  |  |  | [NAME] utilizarse hojas adicionales.
 | 2Este tráfico también debe incluirse en los puntos 2 a 5 (véanse las instrucciones).
Spreadsheet: 767653d1644573717-index-match-multiple-results-from-12-different-tables-copy-of-index-match-12-tables-into-1-table
Sheet: Results

 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | Range | 50 | rows | << Number is not total record of each month, it's how many rows to search after previous founded.
Data to Pull 1 | Column 2 | Column 3 | Data to Pull 2 | Data to Pull 3 | Data to Pull 4 | Column 7 | Column 8 | Column 9 | Column 10 | Column 11 | Column 12 | Column 13 | Column 14 | Column 15 |  |  | Sheet | 0 | [NAME]
Spreadsheet: 841445d1693608540-help-setting-a-formula-based-on-2-variable-conditions-help-setting-up-a-conclusion-with-2-conditions
Sheet: Sheet1

Condition 1: | This Cell B2 will either display: "Adjust with X," "Adjust with Y," or "No Adjustment"
Condition 2: | This Cell B4 will also either display: "Adjust with X," "Adjust with Y," or "No Adjustment". This cell also may be blank at times, based on another unmentioned condition.
Conclusion: | I want this cell (B7) to display "Adjust" if either B2 or B4 say either "Adjust with X" or "Adjust with Y"
 | I also want the cell B7 to say "No Adjustment" if B2 and B4 are BOTH no adjustment or B2 only (if B4 is blank)
Example scenarios below
Example 1:
Condition 1: | Adjust With X
Condition 2: | Adjust with Y
Conclusion: | Adjust
Example 2:
Condition 1: | No Adjustment
Condition 2: | No Adjustment
Conclusion: | No Adjustment
Example 3:
Condition 1: | No Adjustment
Condition 2: | Adjust with X
Conclusion: | Adjust
Example 4 (second option is blank):
Condition 1: | No Adjustment
Condition 2:
Conclusion: | No Adjustment
Example 5 (second option is blank):
Condition 1: | Adjust with Y
Condition 2:
Conclusion: | Adjust
Spreadsheet: joe_parks__15055__BridgeDPR0618
Sheet: Bridgeline DPR2

 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | BRIDGELINE GAS MARKETING
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | DAILY POSITION REPORT
 |  | Position |  |  | Maturity / Gap Risk |  |  | Value-at-Risk |  |  |  | P&L ($000)
Business Unit - Commodity Group |  | Net Open | Limit |  | Sensitivity | Limit |  | 1-Day |  | Limit |  | Today | 5 Day Rolling | MTD | QTD | YTD |  | Yesterday's MTD | Yesterday's QTD | Yesterday's YTD
BRIDGELINE GAS MARKETING
GAS TRADING |  |  | 15 Bcf |  |  |  |  |  |  | 2000
1 Month |  |  |  |  |  | 9 Bcf 1 Month
2-12 Months |  |  |  |  |  | 25 Bcf 2-12 Months
13-18 Months |  |  |  |  |  | 5 Bcf 13-18 Months
TOTAL TRADING
Notes to File
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | MTD | QTD | YTD
 |  |  |  |  |  |  |  |  |  |  |  |  | ENRON NORTH AMERICA | 1558.071714700003 | 6713.071714700003 | 12004.0717147
 |  |  |  |  |  |  |  |  |  |  |  |  | GAS TRADING | 1558.071714700003 | 6713.071714700003 | 12004.0717147
 | 0
 |  |  |  |  |  |  |  |  |  | 5923.328615262726
 |  |  |  |  |  |  |  |  |  | 0
 |  |  |  |  |  |  |  |  |  | 5923.328615262726
 |  |  |  |  |  |  |  |  |  | 0
 |  |  |  |  |  |  |  |  |  | -2243.48
 |  |  |  |  |  |  |  |  |  | 998027.0603850778
Spreadsheet: darrell_schoolcraft__7824__imbalsumm0110
Sheet: CIG

 | Tumbleweed
 | 9198
Day | Measured | Scheduled
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
2001-09-30 00:00:00 |  |  | 394424
2001-10-02 00:00:00
CBS Volume
 |  |  | 21580
Spreadsheet: 59909d1260441847-shiftting-of-data-temp_avk
Sheet: Sheet1

sr.no. | name | phone no | cell no | city | district | FORMULA
1 | ASHISH GANDHI | 1111 | 565656 | AAAA | CCCC
2 | ASHOK MOKHA | 2222 | 654656 | AAAA | CCCC
3 | ASHOK SAHANI | 333 | 36665 | AAAA | CCCC
4 | A.M. TIWARI | 4444 | 43666 | SSSS | DDDD
5 | [NAME] | 555 | 243654 | SSSS | DDDD
6 | [NAME] | 6666 | 3435454 | AAAA | CCCC
7 | [NAME] | 7777 | 2222222 | AAAA | CCCC
8 | [NAME] | 888 | 1234566 | SSSS | DDDD
9 | J.P. SINGH | 87777 | 1234566 | SSSS | DDDD
10 | MEHUL KRISHNA RATHOR | 11112 | 1234566 | SSSS | DDDD
Spreadsheet: 69908d1270576817-need-helping-adding-rows-2009-8teams-
Sheet: WEEK 1A

MUV | BET TEAM | VS TEAM | GAME 1 | [NAME] | G1 $ Win | [NAME] | G1 $ Risk | G1   Result | GAME 2 | [NAME] | G2 $ Win | [NAME] | G2 $ Risk | G2 Result | GAME 3 | [NAME] | G2 $ Win | [NAME] | G2 $ Risk | G3 Result | TOT Units Risked | TOT Units Won | TOT Units Lost | TOT Unit Profit | TOT $$$ Profit
0 | NYY |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 0
0 | BOS |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 0
 | MIN |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 0
 | CHC |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 0
 | WAS |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 0
 | PIT |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 0
 | KC |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 0
 | SD |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 0
 |  | 8 |  |  |  |  |  | 0 |  |  |  |  |  | 0 |  |  |  |  |  | 0 | 0 | 0 | 0 | 0 | 0
RETURN TO MLB OVERALL |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | TOT L | 0
WEEK 1A |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | TOT W | 0
Spreadsheet: 197701d1354538342-table-display-probably-a-match-or-sum-product-solution-needed-planning-table
Sheet: Sheet1

 | 2013-01-01 00:00:00 |  |  | 2013-02-01 00:00:00 |  |  | 2013-03-01 00:00:00 |  |  | 2013-04-01 00:00:00 |  |  |  |  |  | Data Input Table
 | P | E | C | P | E | C | P | E | C | P | E | C |  |  |  |  |  | 2013-01-01 00:00:00 | 2013-02-01 00:00:00 | 2013-03-01 00:00:00 | 2013-04-01 00:00:00
[NAME] | 12 |  |  | 3 |  |  |  |  |  |  |  |  |  |  |  | [NAME] | P | 6
[NAME] | 5 | 1 |  | 9 |  |  |  |  | 4 |  |  | 4 |  |  |  | [NAME] | E | 1
[NAME] |  |  |  |  |  | 14 |  |  |  |  |  |  |  |  |  | [NAME] | C |  | 7
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | [NAME] | P | 5 | 9
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | [NAME] | C |  |  | 4 | 4
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | [NAME] | P | 2 | 3
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | [NAME] | P | 4
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | [NAME] | C | 0 | 7
Spreadsheet: 539130d1505979112-scatter-chart-different-color-dots-1201756
Sheet: Before

Description | Side | price | B data | S data | B X's | S X's
Hog Dec17 | B | 345.25 |  |  |  |  |  | SCATTER CHART
Hog Dec17 | B | 335.25
Hog Dec17 | B | 330.25
Hog Dec17 | B | 349
Hog Dec17 | B | 349.5
Hog Dec17 | B | 351.25
Hog Dec17 | B | 350
Hog Dec17 | B | 349.25
Hog Dec17 | S | 352
Hog Dec17 | S | 351.75
Hog Dec17 | S | 381
Hog Dec17 | S | 376
Hog Dec17 | S | 363
Hog Dec17 | S | 422
Hog Dec17 | S | 409
Hog Dec17 | S | 424
Hog Dec17 | S | 420
Spreadsheet: 886445d1736459406-help-needed-with-date-calculations-warranty-records
Sheet: Sheet1

 | PURCHASE  ITEM  WARRANTY  STATUS  [NAME]
 | [NAME]UNDER WARRANTY | PLACE OF PURCHASE | ORIGINAL COST | MODEL # | SERIAL NUMBER | DATE OF PURCHASE | CURRENT DATE | WARRANTY DURATION IN YEARS | WARRANTY TIME ELAPSED | WARRANTY TIME REMAINING
 | A.O. Smith Water Heater | Lowes | 2021.36 | HP10 | 174710XYZ8311668 | 2017-11-21 00:00:00 |  | 10
Spreadsheet: 99045d1297817050-sumif-but-only-for-the-last-5-results-goaldiff-solution
Sheet: Sheet1

Date | HomeTeam | AwayTeam | Home Goals | Away Goals | Home Teams Goal Difference (Last 5 games) | [NAME] (Last 5 games)
2007-09-11 00:00:00 | [NAME] | Liverpool
2007-08-11 00:00:00 | [NAME] | Liverpool | 1 | 2
2007-07-11 00:00:00 | [NAME] | Portsmouth | 0 | 1
2007-07-11 00:00:00 | Everton | Liverpool | 1 | 2
2007-06-11 00:00:00 | [NAME] | [NAME] | 0 | 1
2007-06-11 00:00:00 | Sunderland | Liverpool | 1 | 2
2007-05-11 00:00:00 | [NAME] | Man City | 0 | 1
2007-05-11 00:00:00 | Arsenal | Liverpool | 1 | 2
2007-04-11 00:00:00 | [NAME] | Birmingham | 0 | 1
2007-04-11 00:00:00 | Man United | Liverpool | 1 | 2
2007-03-11 00:00:00 | [NAME] | Newcastle | 0 | 1
2007-02-11 00:00:00 | [NAME] | Sunderland | 5 | 0
2007-02-11 00:00:00 | Birmingham | Liverpool | 5 | 0 | 0 | 0