tianzl66/Sheetpedia huggingface dataset:
Spreadsheet: 825393d1681296291-data-validation-and-dropdown-lists-book1-data
Sheet: Sheet1

 |  | Job |  | Phase |  | Job | Phase
 |  | A |  | Planning |  | A | Planning
 |  | B |  | Fieldwork |  | B | Fieldwork
 |  | C |  | Completion |  | C | Completion
 |  |  |  | Dropdown
 |  |  |  | A Planning
 |  | [NAME] |  |  |  | A Planning
 |  | A Planning |  |  |  | A Fieldwork
 |  | A Fieldwork |  | A Planning |  | B Completion
 |  | A Completion |  | A Fieldwork |  | B Planning
 |  | B Planning |  | B Completion |  | B Fieldwork
 |  | B Fieldwork |  | B Planning |  | C Completion
 |  | B Completion |  | B Fieldwork |  | C Planning
 |  | C Planning |  | C Completion |  | C Fieldwork
 |  | C Fieldwork |  | C Planning
 |  | C Completion |  | C Fieldwork
Spreadsheet: kimberly_watson__20592__Michelle - timeline
Sheet: TW Line Pack

ET&S REVENUE Enhancement 2001 Goals / Objectives
High Level Timeline
TW Line Pack
 |  | 2001-01-01 00:00:00 | 2001-02-01 00:00:00 | 2001-03-01 00:00:00 | 2001-04-01 00:00:00 | 2001-05-01 00:00:00 | 2001-06-01 00:00:00 | 2001-07-01 00:00:00 | 2001-08-01 00:00:00 | 2001-09-01 00:00:00 | 2001-10-01 00:00:00 | 2001-11-01 00:00:00 | 2001-12-01 00:00:00
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | Training | Training | Training
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | Design/Req | Design/Req | Design/Req
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | R & D | Design/Req. | Design/Req.
 |  |  |  | Design/Req | Training | Design/Req
 |  |  |  | Design/Req | Training
 |  |  |  | Training | Design/Req
Spreadsheet: 41296d1239792899-vlookup-from-multiple-sheets-shift-schedule
Sheet: CLEARING

CLEARING
[NAME]. | SAP NO. | NAME | SECTION
 | 185 |  |  | C
 | 196 |  |  | B
Spreadsheet: 824355d1680517620-multiple-options-in-one-column-h-and-s-training-record-20230104
Sheet: Procedures 2023

 | Procedures
Item | P1 | P2 | P3 | P4 | P5 | P6 | P7 | P8 | P9 | P10 | P11 | P11E | P12
Version | V1 | V1
 | Date | Date | Date | Date | Date | Date | Date | Date | Date | Date | Date | Date | Date
Employee name
 | 23/03/23 LT | 27/03/2023 LT
 | 23/03/23 LT | 27/03/2023 LT
 | 23/03/23 LT | 27/03/2023 LT
 | 23/03/23 LT | 27/03/2023 LT
 | 23/03/23 LT | 27/03/2023 LT
 | 23/03/23 LT | 27/03/2023 LT
 | 23/03/23 LT | 27/03/2023 LT
 | 23/03/23 LT | 27/03/2023 LT
 | 23/03/23 LT | 27/03/2023 LT
 | 23/03/23 LT | 27/03/2023 LT
 | 23/03/23 LT | 27/03/2023 LT
 | 23/03/23 LT | 27/03/2023 LT
 | 23/03/23 LT | 27/03/2023 LT
 | 23/03/23 LT | 27/03/2023 LT
Spreadsheet: 68860d1269391790-bring-over-only-data-only-data
Sheet: Sheet1

 | Values
1 | 25
2 | 34
3
3 | 32
4 | 64
5
5 | 15
6
6 | 63
7 | 101
8
8 | 25
9 | 34
Spreadsheet: 768255d1644904485-unique-values-formula-returning-zero-query-for-excel-forum
Sheet: Sheet1

 | List1 |  | Unique items
 | [NAME]
 | [NAME]
 | [NAME]
 | [NAME]
 | [NAME]
 | [NAME]
 | [NAME]
 | [NAME]
 | [NAME]
 | [NAME]
 | [NAME]
 | [NAME]
 | [NAME]
Spreadsheet: 713512d1610745578-meal-plan-hyperlink-vlookup-result-to-worksheet-in-same-workbook-meal-plan
Sheet: Breakfast Sides

KID APPROVAL? | SIDES CODE | SIDE | INGREDIANTS
 | CHEESE | CHEESE | CHEESE
 | BISCUITS | BISCUITS | BISCUITS, JAM?
 | APPLES | APPLES | APPLES
 | BANANA | BANANA | BANANA
 | GRAPES | GRAPES | GRAPES
 | FRUIT SALAD | FRUIT SALAD | APPLES, STRAWBERRIES, RASPBERRIES, GRAPES, PINEAPPLE, BANANA
 | PINEAPPLE | PINEAPPLE | PINEAPPLES
 | BKSIDES8 | SIDE 8 | SIDES INGREDIANTS 8
 | BKSIDES9 | SIDE 9 | SIDES INGREDIANTS 9
 | BKSIDES10 | SIDE 10 | SIDES INGREDIANTS 10
 | BKSIDES11 | SIDE 11 | SIDES INGREDIANTS 11
 | BKSIDES12 | SIDE 12 | SIDES INGREDIANTS 12
 | BKSIDES13 | SIDE 13 | SIDES INGREDIANTS 13
 | BKSIDES14 | SIDE 14 | SIDES INGREDIANTS 14
 | BKSIDES15 | SIDE 15 | SIDES INGREDIANTS 15
 | BKSIDES16 | SIDE 16 | SIDES INGREDIANTS 16
 | BKSIDES17 | SIDE 17 | SIDES INGREDIANTS 17
 | BKSIDES18 | SIDE 18 | SIDES INGREDIANTS 18
 | [NAME] | SIDE 19 | SIDES INGREDIANTS 19
 | BKSIDES20 | SIDE 20 | SIDES INGREDIANTS 20
 | NONE | NONE | NONE
 | TBD | TO BE DETERMINED | TO BE DETERMINED
Spreadsheet: 464645d1465236653-dynamic-weighted-average-problem-excelforumexample
Sheet: Grade Sheet

 |  |  |  |  |  |  |  | Weights | Total
 |  | Introduction | Growth | Maturity | Decline |  |  |  |  |  | 2 | None | Low | Average | High
 | Small | 0.5 | 0.4 | 0.3 | 0.2 |  |  |  |  |  | None | 0 | 0.33 | 0.66 | 1
 | Mid | 0.7 | 0.6 | 0.5 | 0.4 |  |  |  |  |  | Low | 0.33 | 0.66 | 1 | 1.33
 | Large | 0.9 | 0.8 | 0.7 | 0.6 |  |  |  |  |  | Average | 0.66 | 1 |  | 1.667
 |  |  |  |  |  |  |  |  |  |  | High | 1 | 1.33 | 1.667 | 2
 |  | Introduction | Growth | Maturity | Decline
 | Introduction | 0.9 | 0.7 | 0.4 | 0.4 |  |  |  |  |  |  | 0 | 0.33 | 0.66 | 1
 | Growth | 0.7 | 0.8 | 0.5 | 0.3 |  |  |  |  |  |  | 0.33 | 0.66 | 1 | 1.33
 | Maturity | 0.6 | 0.5 | 0.6 | 0.2 |  |  |  |  |  |  | 0.66 | 1 |  | 1.667
 | Decline | 0.4 | 0.3 | 0.2 | 0.1 |  |  |  |  |  |  | 1 | 1.33 | 1.667 | 2
 |  | Low | Medium | High
 | Low | 0.4 | 0.4 | 0.6
 | Medium | 0.2 | 0.6 | 0.8
 | High | 0 | 0.8 | 0.9
 |  | Low | Medium | High
 | Low | 0.1 | 0.3 | 0.5
 | Medium | 0.2 | 0.5 | 0.7
 | High | 0.4 | 0.7 | 0.9
 |  | Introduction | Growth | Maturity | Decline
 | Low | 0.8 | 0.7 | 0.4 | 0.2
 | Medium | 0.5 | 0.5 | 0.5 | 0.5
 | High | 0.2 | 0.4 | 0.7 | 0.8
 |  | Introduction | Growth | Maturity | Decline
 | Low | 0.4 | 0.5 | 0.7 | 0.8
 | Medium | 0.6 | 0.7 | 0.6 | 0.5
 | High | 0.8 | 0.5 | 0.5 | 0.3
 |  | Introduction | Growth | Maturity | Decline
 | Low | 0.5 | 0.7 | 0.9 | 0.7
 | Medium | 0.6 | 0.6 | 0.8 | 0.6
 | High | 0.8 | 0.7 | 0.7 | 0.5
 |  | Introduction | Growth | Maturity | Decline
 | Low | 0 | 0.2 | 0.4 | 0.1
 | Medium | 0.5 | 0.5 | 0.5 | 0.5
 | High | 1 | 0.8 | 0.7 | 0.6
 |  | Introduction | Growth | Maturity | Decline
 | Low | 0.5 | 0.4 | 0.2 | 0.1
 | Medium | 0.7 | 0.6 | 0.5 | 0.5
 | High | 0.9 | 0.8 | 0.7 | 0.6
 |  | Small | Mid | Large
 | Low | 0.7 | 0.8 | 0.9
 | Medium | 0.5 | 0.6 | 0.7
 | High | 0.3 | 0.4 | 0.5
Spreadsheet: 4de74216-7eae-4a11-a76b-b94c623beb98
Sheet: Sheet1

Public Service Commissioner - REP (North Dakota) | Unnamed: 1 | Unnamed: 2 | Unnamed: 3
Downloaded at 5/21/2013 9:11:19 AM
Precincts Reporting: 505/505 - Total Ballots Cast: 102066
2010 Primary Election - OFFICIAL RESULTS
Precinct | [NAME] | write-in | TOTALS
Precinct 01 | 126 | 0 | 126
Precinct 02 | 91 | 0 | 91
Precinct 03 | 95 | 0 | 95
Precinct 04 | 111 | 0 | 111
Precinct 05 | 69 | 0 | 69
TOTAL | 492 | 0 | 492
Results provided by the Office of North Dakota Secretary of State
Spreadsheet: 721279d1614621990-excel-formula-to-transpose-data-from-a-master-sheet-to-other-worksheets-sample-for-discussion
Sheet: B

[NAME] | Order Number: | Date: | Abbey Products: | Product Code: | Colour: | [NAME]: | Quantity | Ordered? | In stock? | If Not - Due Date? | Comments
Spreadsheet: 663417d1582082833-help-make-a-formula-adding-ingredient-unit-conversion_carton_box_pump_cup-2-
Sheet: Sheet1

1 carton | = | 16 box
1 box | = | 5 pump
1 pump | = | 3 cup
customer | usage (pump) | stock in (cartoon) | balance ingredient | office balance | worker 1 | worker 2 | worker 3 | worker 4 | worker 5 | total
 |  |  | 1b
[NAME] | 2b 3p 1cu | 5ca |  |  |  |  |  |  |  |  |  |  |  |  |  |  | Carton | 1
Cally | 8b 4p 2cu |  |  |  |  |  |  |  |  |  |  |  | ca |  |  |  | Box
[NAME] | 9b 3p 2cu |  |  | 1ca | 0 | 0 | 1ca | 1ca | 11b 3p 1cu | 3ca 11b 3p 1cu | make a formula E15+F15+G15+H15+I15+J15 |  | b |  |  |  | Pump
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | Cup
ca= carton, b=box, p=pum, cu=cup
 |  |  |  |  |  |  |  |  |  |  |  |  | 0
 |  |  |  |  |  |  |  |  |  |  |  | 2
Spreadsheet: 122018d1316554458-list-content-from-row-in-columns-if-different-from-0-book3
Sheet: Sheet1

1 |  |  |  |  |  | 7 | 8 | 9 |  |  |  | 13 | 14 | 15 | 16 | 17 | 18 | 19 | 20 |  | 22 |  | 24 | 25 | 26 | 27 | 28 | 29 | 30 | 31 | 32 | 33 | 34 | 35 | 36 |  |  |  |  |  |  |  |  |  | 46 | 47 | 48 | 49 |  | 51 |  | 53 |  | 55 |  |  |  |  | 60 | 61 |  |  |  | 65 |  | 67 |  |  |  | 71 | 72
some month 1 | 0 | 0 | 0 | 0 | 0 | some month 7 | some month 8 | some month 9 | 0 | 0 | 0 | some month 13 | some month 14 | some month 15 | some month 16 | some month 17 | some month 18 | some month 19 | some month 20 | 0 | some month 22 | 0 | some month 24 | some month 25 | some month 26 | some month 27 | some month 28 | some month 29 | some month 30 | some month 31 | some month 32 | some month 33 | some month 34 | some month 35 | some month 36 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | some month 46 | some month 47 | some month 48 | some month 49 | 0 | some month 51 | 0 | some month 53 | 0 | some month 55 | 0 | 0 | 0 | 0 | some month 60 | some month 61 | 0 | 0 | 0 | some month 65 | 0 | some month 67 | 0 | 0 | 0 | some month 71 | some month 72
Spreadsheet: 725514d1616712220-how-to-count-greater-than-value-in-filtered-list-book2
Sheet: Sheet1

Name | Count
[NAME] | 6
Praveen | 10
[NAME] | 7
[NAME] | 1
Praveen | 2
[NAME] | 7
Praveen | 1
Praveen | 2
Praveen - Greater than 5 is | 1
Spreadsheet: 139503d1328279044-excel-2007-countif-problem-2011-stats
Sheet: MON

Pos | Driver | Team | Nation | Points | Laps | [NAME] | Grid | Gained | Classification | Race Distance | Qualifying Time
1 | [NAME] |  |  | 25 | 78 | 00:01:16.267000 | 1 |  | 1 |  | 00:01:13.556000
2 | [NAME] |  |  | 18 | 78 | 00:01:16.471000 | 4 |  | 2 |  | 00:01:14.483000
3 | [NAME] |  |  | 15 | 78 | 00:01:16.463000 | 2 |  | 3 |  | 00:01:13.997000
4 | [NAME] |  |  | 12 | 78 | 00:01:16.234000 | 3 |  | 4 |  | 00:01:14.019000
5 | [NAME] |  |  | 10 | 78 | 00:01:18.308000 | 12 |  | 5 |  | 00:01:15.973000
6 | [NAME] |  |  | 8 | 78 | 00:01:17.847000 | 9 |  | 6 |  | 00:01:14.275000
7 | [NAME] |  |  | 6 | 77 | 00:01:18.872000 | 14 |  | 7 |  | 00:01:16.121000
8 | [NAME] |  |  | 4 | 77 | 00:01:17.857000 | 15 |  | 8 |  | 00:01:16.214000
9 | [NAME] |  |  | 2 | 77 | 00:01:18.584000 | 11 |  | 9 |  | 00:01:15.826000
10 | Sebastien Buemi |  |  | 1 | 77 | 00:01:18.832000 | 16 |  | 10 |  | 00:01:16.300000
11 | [NAME] |  |  | 0 | 76 | 00:01:18.699000 | 7 |  | 11 |  | 00:01:15.766000
12 | [NAME] |  |  | 0 | 76 | 00:01:18.724000 | 13 |  | 12 |  | 00:01:16.118000
13 | Jarno [NAME] |  |  | 0 | 76 | 00:01:21.277000 | 18 |  | 13 |  | 00:01:17.381000
14 | [NAME] |  |  | 0 | 76 | 00:01:20.678000 | 17 |  | 14 |  | 00:01:17.343000
15 | [NAME] |  |  | 0 | 75 | 00:01:21.391000 | 21 |  | 15 |  | 00:01:18.736000
16 | [NAME] |  |  | 0 | 75 | 00:01:21.566000 | 23 |  | 16
17 | Narain Karthikeyan |  |  | 0 | 74 | 00:01:22.731000 | 22 |  | 17
18 | Pastor Maldonado |  |  | 0 | 73 | 00:01:18.904000 | 8 |  | 18 |  | 00:01:16.528000
19 | [NAME] |  |  | - | 67 | 00:01:20.058000 | 10 |  | RET |  | 00:01:15.815000
20 | [NAME] |  |  | - | 66 | 00:01:18.608000 | 19 |  | RET |  | 00:01:17.820000
21 | [NAME] |  |  | - | 32 | 00:01:20.202000 | 6 |  | RET |  | 00:01:14.877000
22 | [NAME] |  |  | - | 32 | 00:01:19.801000 | 5 |  | RET |  | 00:01:14.682000
23 | [NAME] |  |  | - | 30 | 00:01:22.102000 | 20 |  | RET |  | 00:01:17.914000
24 | [NAME] |  |  | - | 0 |  | 24 |  | DNS
Spreadsheet: 60638d1261137989-merging-fields-to-carry-over-figures-invoice-help
Sheet: Invoice

 |  |  |  |  |  |  |  |  |  |  |  |  | INVOICE
 |  |  | Example 1 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 18 |  |  | 31 |  | 18 |  |  | 31
 |  |  | Example 2 x 2 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 19 |  |  | 28 |  | 38 |  |  | 56
 |  |  | Example 3 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 20 |  |  | 65 |  | 20 |  |  | 65
 |  |  | Delivery |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 10 |  |  | 99 |  | 10 |  |  | 99
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 86 |  |  | 251 |  |  |  |  |  | Should be 88.51
 |  | VAT REGISTRATION NUMBER 610 8834 50 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 88 |  |  | 51
 |  | ERIKS INDUSTRIAL SERVICES LTD
Spreadsheet: 122437d1316797132-gantt-schedule-chart-with-single-series-onelineganttchart
Sheet: Sheet2

Name | Start | Finish | Diff
[NAME] | 0 | 3 | 3
[NAME] | 3 | 4 | 1
[NAME] | 4 | 8 | 4
[NAME] | 8 | 10 | 2
OffShift | 10 | 11 | 1
[NAME] | 11 | 13 | 2
[NAME] | 13 | 15 | 2
Spreadsheet: 862981d1710525617-function-to-find-value-if-index-row-overlaps-formula-to-find-new-values-2
Sheet: Sheet1

Index | 1 | 2 | 3 | 4 | 5 | 6 | Total |  |  |  |  |  | A
A | 0 | 100 | 100 | 300 | 500 | 0 |  |  |  |  |  |  | B
B | 0 | 100 | 100 | 100 | 100 | 100 |  |  |  |  |  |  | A
A | 200 | 200 | 200 | 0 | 0 | 0 |  |  |  |  |  |  | C
C | 0 | 0 | 0 | 10 | 23 | 7 |  |  |  |  |  |  | A
A | 300 | 100 | 500 | 1000 | 10 | 8 |  |  |  |  |  |  | c
c | 100 | 0 | 100 | 0 | 100 | 0 |  |  |  |  |  |  | B
B | 200 | 200 | 0 | 0 | 0 | 2 |  |  |  |  |  |  | X
X | 0 | 10 | 100 | 1000 | 10 | 20 |  |  |  |  |  |  | B
B | 200 | 200 | 200 | 0 | 0 | 0 |  |  |  |  |  |  | A
A | 200 | 200 | 200 | 0 | 0 | 0
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | Equal 100% Each
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | A
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | B
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | C
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | X
 |  |  |  |  |  |  | A
 |  |  |  |  |  |  | B
 |  |  |  |  |  |  | C
 |  |  |  |  |  |  | X
Spreadsheet: 36010d1233760694-create-a-formated-inventory-export-model
Sheet: unit E12

 | Unit E-12 |  |  |  |  |  | TITANIUM
 | XS Up | out | in | [NAME] | out | in | Small Up | out | in | [NAME] | out | in | Medium Up | out | in
 | 454 |  |  | X |  |  | 1625 |  |  | 1540 |  |  | 2563
 | 408 |  |  | X |  |  | 1626 |  |  | 1592 |  |  | 2569
 | X |  |  | X |  |  | 1537 |  |  | 1599 |  |  | 2571
 | X |  |  | X |  |  | 1628 |  |  | X |  |  | 2399
 | X |  |  | X |  |  | 1533 |  |  | X |  |  | 2600
 | X |  |  | X |  |  | X |  |  | X |  |  | 2602
 | X |  |  | X |  |  | X |  |  | X |  |  | X
 | X |  |  | X |  |  | X |  |  | X |  |  | X
 | X |  |  | X |  |  | X |  |  | X |  |  | X
 | X |  |  | X |  |  | X |  |  | X |  |  | X
 | X |  |  | X |  |  | X |  |  | X |  |  | X
 | Total  (XS Up) |  |  | Total  ([NAME]) |  |  | Total (S Up) |  |  | Total  (S Drop) |  |  | Total (M Up)
 | 2 |  |  | 0 |  |  | 5 |  |  | 3 |  |  | 6
 | Medium Drop | out | in | Large Up | out | in | [NAME] | out | in | XL Up | out | in | XL Drop | out | in
 | 2564 |  |  | 3425 |  |  | 3300 |  |  | 4332 |  |  | 4319
 | 2574 |  |  | 3377 |  |  | 3309 |  |  | X |  |  | 4313
 | 2575 |  |  | 3437 |  |  | 3364 |  |  | X |  |  | X
 | 2576 |  |  | 3337 |  |  | X |  |  | X |  |  | X
 | X |  |  | 3444 |  |  | X |  |  | X |  |  | X
 | X |  |  | X |  |  | X |  |  | Total  (XL UP) |  |  | Total (XL Drop)
 | X |  |  | X |  |  | X |  |  | 1 |  |  | 2
 | X |  |  | X |  |  | X
 | X |  |  | X |  |  | X |  |  | XXL Up | out | in | [NAME] | out | in
 | X |  |  | X |  |  | X |  |  | 5315 |  |  | X
 | X |  |  | X |  |  | X |  |  | X |  |  | X
 | Total  (M Drop) |  |  | Total  (L Up) |  |  | Total (L Drop) |  |  | Total  (XXL UP) |  |  | Total (XXL Drop)
 | 4 |  |  | 5 |  |  | 3 |  |  | 1 |  |  | 0
 | KIDS BIKES |  |  |  |  |  | BURLEY |  |  | # OF FLAGS |  |  | BARS (inc. 2 spare @)
 | 20" Kids |  |  | 24" Kids |  |  | X |  |  | 1 |  |  | Up |  | 22
 | FA 3003 |  |  | FA 4042 |  |  | X |  |  |  |  |  | [NAME] |  | 14
 | FA 3009 |  |  | FA 4039 |  |  | PICCOLO |  |  | # PIC. RACKS
 | X |  |  | FA 4016 |  |  | P 008 |  |  | 2
 | X |  |  | X |  |  | X
 |  |  |  |  |  |  | X
 |  |  |  |  |  |  | X
Bike Totals
 | [NAME] |  |  |  |  |  | Kids |  |  |  |  |  | For Mechanic Use
 | X-Small |  |  | 2 |  |  | 20" |  |  | 0
 | Small |  |  | 8 |  |  | 24" |  |  | 0 |  |  | Staged by:
 | Medium |  |  | 10 |  |  | Burley |  |  | 0
 | Large |  |  | 8 |  |  | Piccolo |  |  | 0 |  |  | Returned by:
 | X-Large |  |  | 3 |  |  | Total |  |  | 0
 | XX-Large |  |  | 1 |  |  | Remember Flags & Racks! |  |  |  |  |  | Date of return:
 | Total |  |  | 32
Spreadsheet: 208512d1358853491-please-help-urgent-need-help-formula-problem-code-problem-and-need-advice-prova
Sheet: Foglio1

AG | Sicilia
AL | Piemonte
AN | Marche
AO | [NAME]
AQ | Abruzzo
AR | Toscana
AP | Marche
AT | Piemonte
AV | Campania
BA | Puglia
BT | Puglia
BL | Veneto
BN | Campania
BG | Lombardia
BI | Piemonte
BO | Emilia-Romagna
BZ | Trentino-Alto Adige
BS | Lombardia
BR | Puglia
CA | Sardegna
CL | Sicilia
CI | Sardegna
CB | Molise
CE | Campania
CT | Sicilia
CZ | Calabria
CH | Abruzzo
CO | Lombardia
CS | Calabria
CR | Lombardia
KR | Calabria
CN | Piemonte
EN | Sicilia
FM | Marche
FE | Emilia-Romagna
FI | Toscana
FG | Puglia
FC | Emilia-Romagna
FR | [NAME]
GE | [NAME]
GO | Friuli-Venezia Giulia
GR | Toscana
IM | [NAME]
IS | Molise
SP | [NAME]
LT | [NAME]
LE | Puglia
LC | Lombardia
LI | Toscana
LO | Lombardia
LU | Toscana
MC | Marche
MN | Lombardia
MS | Toscana
MT | Basilicata
ME | Sicilia
MI | Lombardia
MO | Emilia-Romagna
MB | Lombardia
NA | Campania
NO | Piemonte
NU | Sardegna
OG | Sardegna
OT | Sardegna
OR | Sardegna
PD | Veneto
PA | Sicilia
PR | Emilia-Romagna
PV | Lombardia
PG | Umbria
PU | Marche
PE | Abruzzo
PC | Emilia-Romagna
PI | Toscana
PT | Toscana
PN | Friuli-Venezia Giulia
PZ | Basilicata
PO | Toscana
RG | Sicilia
RA | Emilia-Romagna
RC | Calabria
RE | Emilia-Romagna
RI | [NAME]
RN | Emilia-Romagna
RM | [NAME]
RO | Veneto
SA | Campania
SP | [NAME]
SS | Sardegna
SV | [NAME]
SI | Toscana
SR | Sicilia
SO | Lombardia
TA | Puglia
TE | Abruzzo
TR | Umbria
TO | Piemonte
TP | Sicilia
TN | Trentino-Alto Adige
TV | Veneto
TS | Friuli-Venezia Giulia
UD | Friuli-Venezia Giulia
VA | Lombardia
VE | Veneto
VB | Piemonte
VC | Piemonte
VR | Veneto
VS | Sardegna
VV | Calabria
VI | Veneto
VT | [NAME]
Spreadsheet: 241517d1370624174-cascading-two-tier-drop-downs-in-form-control-sample-of-data-layout
Sheet: Sample data layout

Customer | Product | Amount | Acct month
Customer1 | Product1 | 200 | 1
Customer1 | Product2 | 100 | 2
CUstomr2 | prodcut 1 | 500 | 1
Customer2 | product1 | 300 | 2
Customer2 | product1 | 500 | 3
Customer3 | product2 | 100 | 1
Customer3 | product4 | 100 | 2
Customer3 | product4 | 100 | 3
Customer 4 | product3 | 100 | 1
customer4 | product3 | 100 | 2
customer4 | prodcu3 | 100 | 3
Spreadsheet: 212643d1360180866-excel-help-excel_question
Sheet: Work

 | Current View |  |  |  |  |  | After Populating the view should look like this
 | Product | Platform | Servers |  |  |  | Product | Platform | Servers
1 | ABC | [NAME] | ?? |  |  | 1 | ABC | [NAME] | Server1
2 | DEF | .NET | ?? |  |  |  |  |  | Server2
 |  |  |  |  |  |  |  |  | Server3
 |  |  |  |  |  | 2 | DEF | .NET | Server1
 |  |  |  |  |  |  |  |  | Server2
Spreadsheet: 267605d1380119990-need-help-adding-1-to-cell-from-cell-above-example-rfi-help
Sheet: Sheet1

 | Column1 | Column2 | Column3 | Column4 | Column5 | Column6 | Column7 | Column8 | Column9 | Column10 | Column11 | Column12 | Column13
 | RFI Number: | Open? | Date Received: | Subject: | Response Required By: | Issued to Consultant Date: | Return Date: | Issue to GC Date: | Days open: | Remarks/Comments: | Owner Document Number (if applicable): | Not an RFI? | [NAME] to Change Order #:
 |  |  | 2013-08-01 00:00:00 | Example subject | [NAME] |  |  | 2013-08-02 00:00:00
 |  |  | 2013-08-30 00:00:00 | RFI 2 | ELEC | 2013-09-01 00:00:00 | 2013-09-02 00:00:00 | 2013-09-03 00:00:00
 |  |  | 2013-09-25 00:00:00 | NOT A TRUE RFI…SO I WANT RFI NUMBER TO NOT BE IN COLUMN B | MECH | 2013-09-25 00:00:00 | 2013-09-26 00:00:00 |  |  |  |  | X
 |  |  | 2013-09-30 00:00:00 | THIS SHOULD BE RFI 003 in column B | [NAME]
 |  |  | 2013-09-30 00:00:00 |  |  |  |  |  |  |  |  | x
 |  |  |  |  |  |  |  |  |  |  |  | x
 |  |  |  |  |  |  |  |  |  |  |  | x
 |  |  |  |  |  |  |  |  |  |  |  | x
Spreadsheet: 846959d1698084848-stuck-with-match-function-match-data_new
Sheet: Φύλλο1

 |  |  |  | ONE |  |  | TWO |  |  | THREE |  |  | FOUR
 |  | STATUS | 1 | X | 2 | 1 | X | 2 | 1 | X | 2 | 1 | X | 2
 |  | TWO | 0.466395599138962 | 0.3016024874431954 | 0.2320019134178426 | 0.466395599138962 | 0.3016024874431954 | 0.2320019134178426 | 0.466395599138962 | 0.3016024874431954 | 0.2320019134178426 | 0.466395599138962 | 0.3016024874431954 | 0.2320019134178426
 |  | FOUR | 0.4836783049718997 | 0.2783010554761392 | 0.2380206395519612 | 0.4836783049718997 | 0.2783010554761392 | 0.2380206395519612 | 0.4836783049718997 | 0.2783010554761392 | 0.2380206395519612 | 0.4836783049718997 | 0.2783010554761392 | 0.2380206395519612
 |  | ONE | 0.330553901131626 | 0.2644431209053008 | 0.4050029779630732 | 0.330553901131626 | 0.2644431209053008 | 0.4050029779630732 | 0.330553901131626 | 0.2644431209053008 | 0.4050029779630732 | 0.330553901131626 | 0.2644431209053008 | 0.4050029779630732
 |  | ONE | 0.5176035207041408 | 0.2730546109221845 | 0.2093418683736747 | 0.5176035207041408 | 0.2730546109221845 | 0.2093418683736747 | 0.5176035207041408 | 0.2730546109221845 | 0.2093418683736747 | 0.5176035207041408 | 0.2730546109221845 | 0.2093418683736747
 |  |  | X
 |  |  | 2
 |  |  | 1
 |  |  | 1
 |  |  | 0.301602 |  |  | In cell [NAME] I need a formula to do this( look at C7 , it says TWO , then go to the TWO SECTION which is g6:i6 and match the d14 to the proper cell of the TWO SECTION. In my example is 0,301602)
 |  |  | 0.238021
 |  |  | 0.330554
 |  |  | 0.517604
Spreadsheet: 708588d1607941167-reference-cell-content-balance-owing
Sheet: Sheet1

ID | unit cost | quantity | total | paid | Due
1 | 1 | 1 |  | 0.5
2 | 1 | 10 |  | 10
1 | 1 | 1
Spreadsheet: e33a65ae-8ac9-4b18-838a-15f667de9f72
Sheet: Sheet1

PROG ID | ATHLETE ID | ATHLETE FIRST | ATHLETE LAST | NATIONALITY | START NUMBER | SWIM | T1 | BIKE | T2 | RUN | POSITION | TOTAL TIME
7678 | 57859 | [NAME] | Claasen | RSA | 0 | 00:21:22 | 00:00:00 | 01:15:55 | 00:00:00 | 00:36:12 | 1 | 02:13:30
Spreadsheet: 112233d1308336531-auditing-a-list-to-very-the-contents-are-within-certain-limits-error-checks
Sheet: Sheet1

 | Q=Check | 9 Character Check | Final 8 Digit Check | Error-Free Record
Q00012345 | 1 | 1 | 1 | 1
Q09327Q8 | 1 | 0 | 0 | 0
87dvs2 | 0 | 0 | 0 | 0
[NAME] | 1 | 1 | 1 | 1
Q98*6902- | 1 | 1 | 0 | 0
 | 0 | 0 | 0 | 0
 | 0 | 0 | 0 | 0
Spreadsheet: 745760d1630165391-compare-two-columns-in-two-sheets-to-remove-duplicates-and-return-one-copy-only-book1-4-
Sheet: Sheet3

Column3, Master
Column1
2021 - NTOR ( 3.0 -AM )
2021 - Cor T ( 1.4-Sty-Cloth )
2021 - NTOR ( 3.0 -AM-PLUS )
2021 - TERA ( 3.6 - CL )
2021 - GIT ( 2.0 -R Line )
2021 - GIT ( 2.0 -Eleg )
2021 - TERA ( 3.6 - HL )
2021 - GIT ( 1.4 -Life )
2021 - ITG - P2 ( Leather )
2021 - SSAP ( 2.5 -TL )
2021 - Cor T ( 1.4-TL )
2021 - Cor T ( 1.4-Sty-Leather )
2021 - ITG - P1 ( Cloth )
2021 - SSAP ( 2.5 -CL )
2021 - SSAP ( 2.5 -HL )
2021 - Cor T (1.4-Sty-R Line )
2021 - ARET ( 3.6 - CL )
2021 - ARET ( 3.6 - HL )