tianzl66/Sheetpedia huggingface dataset:
Spreadsheet: 97465d1296638031-creating-an-index-locking-lines-soils-help
Sheet: Sheet1

Hidden Column | SOILS 2 | Sub 1 | Sub2 | Sub 3 | Page #
 | Texture |  |  |  | 1
Organic Matter | Organic Matter |  |  |  | 3
Soil Fertility | Soil Fertility |  |  |  | 4
Cation exchange capacity | Cation exchange capacity |  |  |  | 4
Soil pH | Soil pH |  |  |  | 6-9
Soil Structure | Soil Structure |  |  |  | 10
Soil Structure |  | Sand |  |  | 11
Soil Structure |  | Silt |  |  | 11
Soil Structure |  | Clay |  |  | 11-12
Soil Structure |  | Organic Matter |  |  | 12
Compaction | Compaction |  |  |  | 12
Appendix | Appendix |  |  |  | 15-33
Appendix |  | ribbon test |  |  | 15
Appendix |  | sedimentary test |  |  | 16
Appendix |  | exchangeable cations |  |  | 17
Appendix |  | cation exchange capacity |  |  | 17,19
Appendix |  | base saturation / soil fertility |  |  | 17
Appendix |  | soil pH |  |  | 20-21
Appendix |  |  | factors effecting pH |  | 21
Appendix |  |  | measuring pH |  | 21
Appendix |  | soil tests for organic gardening |  |  | 22-25
Appendix |  |  | moisture |  | 24
Appendix |  |  | nitrogen |  | 24-25
Appendix |  |  | minerals |  | 25
Appendix |  |  | pH |  | 25
Appendix |  | soil compaction |  |  | 29-33
Appendix |  |  | bulk density |  | 29
Appendix |  |  | penetrometer method |  | 29-30
Appendix |  |  | visual method |  | 30
Appendix |  |  | effects on crops |  | 30
Appendix |  |  | factors |  | 31
Appendix |  |  | causes |  | 31
Appendix |  |  |  | natural | 31
Appendix |  |  |  | cultural practices | 31
Appendix |  |  |  | drainage | 31
Appendix |  |  |  | tillage | 32
Appendix |  |  |  | traffic | 32-33
Spreadsheet: 220154d1363085341-multiple-condition-if-pass-or-fail
Sheet: Sheet1

S.No. | Name | Hindi | English | Maths | Science | Social Study | Result
M | A | 23 | 34 | 33 | 23 | 11 | Fail
F | B | 24 | 45 | 33 | 43 | 22 | Supp
M | C | 32 | 66 | 33 | 25 | 22 | Fail
F | D | 45 | 78 | 44 | 76 | 33 | Pass
M | E | 65 | 98 | 55 | 34 | 34 | Pass
F | F | 45 | 90 | 66 | 12 | 54 | Supp
F | G | 34 | 9 | 76 | 98 | 87 | Supp
F | H | 21 | 12 | 54 | 99 | 65 | Supp
M | I | 78 | 35 | 23 | 667 | 43 | Supp
M | J | 90 | 46 | 12 | 56 | 45 | Supp
Conditions 1. | To pass each subject should have minimum of 33 Marks.
Conditions 2. | If 1 or 2 subjects have below 33 marks then supplementary
Conditions 3. | If more than 2 subjects have below 33 marks then Fail
Spreadsheet: 134310d1325186873-excel-2007-forecasting-donnies-forecast-model
Sheet: 12-29

Contacts |  |  |  | Schedule
Interval | Forecasted | Actual |  | Interval | Forecasted | Actual
08:00:00 | 129 | 141 |  | 08:00:00 | 53.63 | 66.99
08:30:00 | 197 | 219 |  | 08:30:00 | 76.74 | 88.51
09:00:00 | 180 | 209 |  | 09:00:00 | 71.41 | 94.82
09:30:00 | 190 | 282 |  | 09:30:00 | 71.59 | 100.9
10:00:00 | 212 | 364 |  | 10:00:00 | 80.78 | 107.85
10:30:00 | 240 | 391 |  | 10:30:00 | 88.69 | 115.69
11:00:00 | 236 | 452 |  | 11:00:00 | 87.78 | 112.87
11:30:00 | 249 | 442 |  | 11:30:00 | 89.37 | 124.18
12:00:00 | 243 | 439 |  | 12:00:00 | 87.8 | 131.33
12:30:00 | 237 | 437 |  | 12:30:00 | 86.32 | 132.96
13:00:00 | 257 | 459 |  | 13:00:00 | 82.01 | 130.17
13:30:00 | 254 |  |  | 13:30:00 | 81.16 | 134.16
14:00:00 | 246 |  |  | 14:00:00 | 90.53 | 147.57
14:30:00 | 253 |  |  | 14:30:00 | 94.79 | 149.18
15:00:00 | 240 |  |  | 15:00:00 | 83.85 | 145.36
15:30:00 | 242 |  |  | 15:30:00 | 90.48 | 160.89
16:00:00 | 260 |  |  | 16:00:00 | 96.38 | 165.91
16:30:00 | 253 |  |  | 16:30:00 | 92.17 | 136.55
17:00:00 | 251 |  |  | 17:00:00 | 89.76 | 117.11
17:30:00 | 231 |  |  | 17:30:00 | 80.88 | 112.32
18:00:00 | 222 |  |  | 18:00:00 | 82.06 | 110
18:30:00 | 217 |  |  | 18:30:00 | 75.26 | 100.5
19:00:00 | 200 |  |  | 19:00:00 | 72.66 | 99.84
19:30:00 | 179 |  |  | 19:30:00 | 65.65 | 91.33
20:00:00 | 156 |  |  | 20:00:00 | 56.56 | 85.17
20:30:00 | 154 |  |  | 20:30:00 | 53.98 | 80.51
21:00:00 | 125 |  |  | 21:00:00 | 46.13 | 72.84
21:30:00 | 105 |  |  | 21:30:00 | 39.97 | 67.5
22:00:00 | 79 |  |  | 22:00:00 | 28.92 | 56.5
22:30:00 | 73 |  |  | 22:30:00 | 25.81 | 55.5
Spreadsheet: errol_mclaughlin_jr__10087__Omicron Curves
Sheet: Sheet1

LA - Onshore South | HSC/East TX/Katy | Ok - Mid Con | Permian - SJ | Vent - Demarc | Market Area:  NE | Appalachia | Rockies | Alberta | Sithe Curve | Market Area:  Chicago | FGT | Transco/Z6 | Michcons | Socal | IF [NAME] | IF ONG/Oklahoma Peaker | IF CIG/RkMnt Peaker | Sumas (Canadian curve)
1 | 2 | 3 | 4 | 5 | 6 | 7 | 8 | 9 | 10 | 11 | 12 | 13 | 14 | 15 | 16 | 17 | 18 | 16
1 | 2 | 3 | 4 | 5 | 6 | 7 | 8 | 9 | 10 | 11 | 12 | 13 | 14 | 15 | 16 | 17 | 18 | 16
NG_OMICRON_1 | NG_OMICRON_2 | NG_OMICRON_3 | NG_OMICRON_4 | NG_OMICRON_5 | [NAME] | NG_OMICRON_7 | NG_OMICRON_8 | NG_OMICRON_9 | NG_OMICRON_10 | NG_OMICRON_11 | NG_OMICRON_12 | NG_OMICRON_13 | NG_OMICRON_14 | NG_OMICRON_15 | NG_OMICRON_16 | NG_OMICRON_17 | NG_OMICRON_18 | NG_OMICRON_51
Spreadsheet: 116029d1311522312-selective-columns-handicap-template-midshires
Sheet: A

Adams. [NAME] |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | HANDICAPPING
hole | par | stroke index | adjusted par | pts calc | [NAME] | strokes | points | PAR 3 | INDEX 1 | INDEX 2 | INDEX 3 | adjusted par | pts calc | [NAME] | points | handicap | handicap | handicap | catergory | Buffer Zone | css | Nett Differential | adjustment
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | Nett | Nett
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | points | points
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 0 | 18 | 36
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | par 3
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | sss | css adj | "RO"
in
out
total
Spreadsheet: 130510d1322404498-help-needed-with-information-retrieval-lookup-from-another-worksheet-forecast-test
Sheet: Bid Entry Sheet - ALL BIDS

Project Name | Scope / Progress / Notes | Expected Revenue | Expected Profit | Project Start | Project Duration | % chance of confirming | Status
Project A | Restore Plumbing | 100100.1 | 10000 | 2011-01-01 00:00:00 | 2 weeks | 1 | Confirmed
Project B | Adjust infrastructure | 40000 | 5000 | 2011-01-11 00:00:00 |  | 0.2 | Development
Project C | CAD Designs Only | 50000 | 8000 | 2012-04-01 00:00:00 |  | 0.5 | Proposed
Project D | Build Shuttle System | 20000 | 2000 | 2011-11-01 00:00:00 |  | 0 | Lost
Project F | Adjust infrastructure and renovate | 250 | 100 | 2011-12-30 00:00:00 |  | 1 | Confirmed
Project G | Labor for Install | 100 | 20 | 2012-02-04 00:00:00 |  | 0.7 | Development
Project H | Build Tables | 900000 | 200000 | 2012-02-01 00:00:00 | 1 month | 1 | Confirmed
Project I | Build Cans | 400000 | 70000 | 2012-01-08 00:00:00 | 1 week | 0.3 | Proposed
Project J | Redesign for System | 2000 | 500 | 2012-03-05 00:00:00 |  | 0.5 | Proposed
Project K | Foundation Install | 55 | 20 | 2012-08-01 00:00:00 |  | 0.99 | Proposed
Project L | Adjust Hinges | 95000 | 22000 | 2012-05-01 00:00:00 | 2 days | 0.75 | Proposed
Spreadsheet: 155236d1336737432-identifying-events-in-a-dataset-test_data
Sheet: Sheet1

12
12
8
9
8
11
10
11
10
11
12
10 |  | True
10 |  | True
10 |  | True
10 |  | True
10 |  | True
10 |  | True
11
8
10
9
12
10
8
12
10
12
11
10
9
Spreadsheet: 119782d1314737724-transpose-a-reference-moviemodelprogress
Sheet: film length

[NAME] | Senna | Aquinas | Duel | Sugarland Express | Suntrust | Near Dark | The Future | Two-Lane Blacktop |  | [NAME] | Weepies
01:55:00 | 01:56:00 | 07:00:00 | 01:40:00 | 01:50:00 | 03:00:00 | 01:44:00 | 01:41:00 | 01:52:00 | 00:00:00 | 11:30:00 | 08:00:00
platter | platter |  | 2000 ft | 2000 ft |  | 6000ft | platter | 6000ft
FLAT | FLAT |  | FLAT | SCOPE |  | FLAT | FLAT | SCOPE
35mm trailers: | 35[NAME] trailers |  | mp4 trailers: | no trailers:
The Future (3.5) | [NAME] and [NAME] (4.0) |  | mp4 trailers:
[NAME] (3.5) | The Interrupters (4.5) |  | Coming attractions (-20)
The Man Who Fell to Earth (3.5) | Gainsbourg (5.5) |  | World on a Wire (-20)
Bellflower (3.5) | [NAME] (4.0) |  | The Man Who Fell to Earth (-20)
Gainsbourg (3.5) | Bellflower (4.5) |  | Attack the Block (-20)
Feature (SR - 4.5) | Feature (6.0) |  | Bellflower (-20)
 |  |  | Feature (mono - 4.5)
Spreadsheet: michelle_cash__26514__Employee Search
Sheet: Combined Search Result List

Enron Corp
Individuals
 |  | (yes or no)
 | Individuals | Enron Employee | Dates of Employment
1 | [NAME] |  |  | No record in SAP
2 | [NAME] |  |  | No record in SAP
3 | [NAME] | Yes | 8/1/90 - 9/15/01
4 | [NAME] | Yes | 9/8/94 - 8/1/01
5 | [NAME] | Yes | 12/3/90 - LOA 10/24/01
6 | [NAME] |  |  | No record in SAP
7 | [NAME] | Yes | 10/25/93 - Current
8 | [NAME] | Yes | 1/23/95 - Current
9 | [NAME] | Yes | 9/3/96 - Current
10 | [NAME] |  |  | No record in SAP
11 | [NAME] |  |  | No record in SAP
12 | [NAME] | Yes | 9/6/87 - Current
13 | Rodger W.P. Yeomans |  |  | No record in SAP
14 | [NAME] |  |  | No record in SAP
15 | [NAME] |  |  | No record in SAP
16 | [NAME] |  |  | No record in SAP
17 | [NAME] |  |  | No record in SAP
18 | [NAME] |  |  | No record in SAP
19 | Little Joe |  |  | No record in SAP
20 | [NAME] |  |  | No record in SAP
21 | [NAME] |  |  | No record in SAP
22 | [NAME]
23 | [NAME]
24 | [NAME]
25 | [NAME]
26 | [NAME]
27 | [NAME]
28 | [NAME]
29 | [NAME]
30 | [NAME]
31 | [NAME]
32 | [NAME]
33 | [NAME]
34 | [NAME]
35 | [NAME]
36 | [NAME]
37 | [NAME]
38 | [NAME]
39 | [NAME]
40 | [NAME], Sr.
41 | [NAME]
42 | [NAME]
43 | [NAME]
44 | [NAME]
45 | [NAME]
46 | [NAME] and [NAME]
47 | [NAME]
Spreadsheet: 693674d1599082829-possible-sumifs-index-match-book25-excel-forum-example-
Sheet: Sheet1

 | YEARS |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | YEARS | MILEAGE
 | TASK | COST | 1 | 2 | 3 | 4 | 5 | 6 | 7 | 8 | 9 | 10 | COST TOTAL (BASED ON CONTRACT LENGTH) |  |  |  | CONTRACT LENGTH | 5 | 550000
 | TASK 1 | 1000 | X |  | X |  | X |  | X |  | X |  |  | <--- NEED FORMULA HERE TO SUM TASK COST BASED ON TASK FREQUENCY (SHOWN BY 'X'S) BASED ON CONTRCT LENGTH ("AC4")
 | TASK 2 | 5000 |  |  |  |  | X |  |  |  |  | X
 | TASK 3 | 20000 |  |  |  |  |  | X
 | MILEAGE
 | TASK | COST | 100000 |  |  |  |  |  |  |  |  |  | COST TOTAL (BASED ON CONTRACT LENGTH)
 | TASK 1 | 10000 | X | X | X | X | X | X | X | X | X | X |  | <--- NEED FORMULA HERE TO SUM TASK COST BASED ON TASK FREQUENCY (SHOWN BY 'X'S) BASED ON CONTRCT LENGTH ("AC4") …… BUT ALSO NEEDS TO ROUNDDOWN TO CLOSEST MILEAGE TO CONTRACT MILEAGE
 | TASK 2 | 5000 |  | X |  | X |  | X |  | X |  | X
 | TASK 3 | 50000 |  |  |  | X |  |  |  | X
Spreadsheet: 673696d1587491878-look-up-a-list-of-client-purchases-with-dates-2020-04-21-oeldere-re-arange-data-673683d1587488440-look-up
Sheet: Oeldere

Issue | Date | value
Client A | Book 2 | 2017-05-05 00:00:00
Client A | Book 5 | 2018-06-01 00:00:00
Client A | Book 6 | 2018-08-08 00:00:00
Client A | Book 9 | 2019-09-25 00:00:00
Client B | Book 3 | 2017-08-22 00:00:00
Client B | Book 7 | 2019-10-09 00:00:00
Client C | Book 4 | 2016-02-22 00:00:00
Client C | Book 11 | 2019-03-02 00:00:00
Client C | Book 12 | 2020-01-05 00:00:00
Client D | Book 2 | 2015-11-10 00:00:00
Client D | Book 6 | 2018-04-08 00:00:00
Client D | Book 9 | 2019-01-27 00:00:00
Client D | Book 10 | 2020-03-12 00:00:00
Client E | Book 11 | 2018-08-12 00:00:00
Client E | Book 12 | 2018-09-22 00:00:00
Spreadsheet: 220480d1363179334-split-month-to-date-data-into-weeks-sample
Sheet: Sheet1

Teams | Product A | Product B | Product C
Team A | 5 | 5 | 5 | these numbers manually updated every day
Team B | 6 | 6 | 6
Team C | 7 | 7 | 7
Week 1st-7th
Teams | Product A | Product B | Product C
Team A | 1 | 1 | 1
Team B | 1 | 1 | 1
Team C | 2 | 2 | 2
 |  |  |  | split data in Green cells into week based on [NAME]?
Week 7th-14th |  |  |  | right now I  have to copy and paste weekly data before updating the spreadsheet on 8th and start of every week
Teams | Product A | Product B | Product C | then the formulas become b15=b2-b9 and after a week b21=b2-b9-b15
Team A | 1 | 1 | 1
Team B | 1 | 1 | 1
Team C | 2 | 2 | 2
Week 14th-21st
Teams | Product A | Product B | Product C
Team A | 1 | 1 | 1
Team B | 1 | 1 | 1
Team C | 2 | 2 | 2
Week 21st-28th
Teams | Product A | Product B | Product C
Team A | 2 | 2 | 2
Team B | 3 | 3 | 3
Team C | 1 | 1 | 1
Spreadsheet: 850258d1700625775-compare-two-columns-and-find-differences-book1
Sheet: Sheet2

Column A | Column B
albania | albania
algeria | American flag
American flag | American Mask
American Mask | armenia
andora | australia
angola | [NAME]
Anguilla | belarus
[NAME] and [NAME] | bosnia
Argentina | bulgaria
armenia | Burkina
Aruba | Cameroon
australia | China
[NAME] | Colombia
Bahamas | cyprus
Barbados | czeia
belarus | Denmark
bosnia | Eagle
Bottle | EGYPT
Brazil | estonia
bulgaria | Faso
[NAME] | flag
Chile | Freedom
China | Freedom Red
Colombia | georgia
Costa Rica | Good People
croatia | greece
Crow | Hungery
CUBA FLAG | iceland
Curaçao | indonesia
cyprus | ireland
Denmark | japan
Dimension | Korea
Dont Stop | kuwait
Dont stress | latvia
EGYPT | lichestien
estonia | lithunia
Flag 8 | luxembourg
Freedom | macedonia
FREEDOM red | [NAME]
georgia | moldova
ghana | monaco
Ghost | montenangro
greece | north
[NAME] | phillipine
Grenada | qatar
Guadeloupe | saudia
Guyana | serbia
Honduras | singapore
Hungery | slovakia
I left my bed | swiss
iceland | Turkey
indonesia | uae
ireland | Usa
japan | Venezuela
Korea | vietname
kosovo
kuwait
latvia
Legalize
lichestien
lithunia
luxembourg
[NAME]
malta
Martinique
moldova
monaco
montenangro
morocco
Mozambique
Nicaragua
[NAME]
nigeria
north macedonia
PANAMA
[NAME]
phillipine
Puerto Rico
qatar
[NAME] Nevis
[NAME]
[NAME] and Miquelon
saudia
serbia
singapore
slovakia
South africa
spain
sudan
Suriname
swiss
Trinidad and Tobago
Turkey
uae
Uruguay
Usa flag
Venezuela
vietname
Spreadsheet: 82765d1282781623-extract-data-to-different-workbook-example-workbook
Sheet: 1

 |  |  | 2008-01-01 00:00:00
Location | Trips | Liters | Gallons
[NAME] | 1 | 378.5 | 100
Centurion | 2 | 757 | 200
Dragon | 3 | 1135.5 | 300
Bldg 0039 | 4 | 1514 | 400
Fac 1 | 5 | 1892.5 | 500
Man | 6 | 2271 | 600
Dog Pen | 7 | 2649.5 | 700
Canal | 8 | 3028 | 800
Hot | 9 | 3406.5 | 900
Fac2 | 10 | 3785 | 1000
 | 55 | 20817.5 | 5500
Spreadsheet: 82183d1282206302-find-entry-in-corresponding-sheet-and-return-related-value-tag-rubgy
Sheet: Initial Setup

Number of Clubs | 20 |  | No | Club Name
 |  |  | 1 | Team 7 | ç | Club Name entried here won't be processed
 |  |  |  | Team 12 | ç | Club Name entried here won't be processed
 |  |  |  | Team 1 | ç | Club Name entried here won't be processed
 |  |  |  | Team 14 | ç | Club Name entried here won't be processed
 |  |  |  | Team 11 | ç | Club Name entried here won't be processed
 |  |  |  | Team 2 | ç | Club Name entried here won't be processed
 |  |  |  | Team 10 | ç | Club Name entried here won't be processed
 |  |  |  | Team 8 | ç | Club Name entried here won't be processed
 |  |  |  | Team 3 | ç | Club Name entried here won't be processed
 |  |  |  | Team 4 | ç | Club Name entried here won't be processed
 |  |  |  | Team 15 | ç | Club Name entried here won't be processed
 |  |  |  | Team 9 | ç | Club Name entried here won't be processed
 |  |  |  | Team 16 | ç | Club Name entried here won't be processed
 |  |  |  | Team 6 | ç | Club Name entried here won't be processed
 |  |  |  | Team 20 | ç | Club Name entried here won't be processed
 |  |  |  | Team 19 | ç | Club Name entried here won't be processed
 |  |  |  | Team 18 | ç | Club Name entried here won't be processed
 |  |  |  | Team 13 | ç | Club Name entried here won't be processed
 |  |  |  | Team 17 | ç | Club Name entried here won't be processed
 |  |  |  | Team 5 | ç | Club Name entried here won't be processed
 |  |  |  |  | ç | Club Name entried here won't be processed
 |  |  |  |  | ç | Club Name entried here won't be processed
 |  |  |  |  | ç | Club Name entried here won't be processed
 |  |  |  |  | ç | Club Name entried here won't be processed
Spreadsheet: 856406d1705658644-lookup-a-date-list-multiple-events-in-one-cell-book3
Sheet: events

 |  | 2024-02-07 00:00:00
 | list all events  from B3:b18 that take place on C1 underneath each other in C2
 | mini cricket: 14:15-15:15 | 2024-01-15 00:00:00
 | mini cricket: 14:15-15:15 | 2024-01-19 00:00:00
 | swimming A&B: 06:30-07:15 | 2024-01-15 00:00:00
 | swimming c: 14:15-15:00 | 2024-01-17 00:00:00
 | tennis A: 15:15-16:15 | 2024-01-16 00:00:00
 | tennis B2: 14:15-15:15 | 2024-01-17 00:00:00
 | tennis B1: 14:15-15:15 | 2024-01-18 00:00:00
 | squash beginners: 14:15-15:15 | 2024-01-17 00:00:00
 | chess: 13:45-14:30 | 2024-01-18 00:00:00
 | athletics: 14:15-15:15 | 2024-01-16 00:00:00
 | athletics: 14:15-15:15 | 2024-01-18 00:00:00
 | band: 07:00-07:45 | 2024-01-15 00:00:00
 | marimba: 07:00-07:45 | 2024-01-17 00:00:00
 | choir: 08:00-08:45 | 2024-01-17 00:00:00
 | band: 07:00-07:45 | 2024-01-18 00:00:00
 | marimba: 07:00-07:45 | 2024-01-19 00:00:00
Spreadsheet: 132806d1323955163-count-number-of-days-from-the-most-recent-item-riddor
Sheet: Sheet1

Date | Accident | Section
2009-04-01 00:00:00 | RIDDOR | A |  |  |  | Section | No of Days RIDDOR free
2009-04-11 00:00:00 | Minor | B |  |  |  | A | x
2010-09-30 00:00:00 | RIDDOR | C |  |  |  | B | x
2010-08-30 00:00:00 | Minor | D |  |  |  | C | x
2011-01-01 00:00:00 | Minor | B |  |  |  | D | x
2011-01-02 00:00:00 | Minor | D
2011-01-03 00:00:00 | Minor | C
2011-01-04 00:00:00 | RIDDOR | B
2011-01-05 00:00:00 | RIDDOR | D
2011-03-24 00:00:00 | Minor | A
2011-04-27 00:00:00 | Minor | B
2011-05-30 00:00:00 | Minor | B
2011-06-12 00:00:00 | Non | B
2011-06-13 00:00:00 | Minor | C
2011-06-02 00:00:00 | RIDDOR | C
2011-06-02 00:00:00 | Minor | D
2011-06-02 00:00:00 | Minor | A
2011-11-24 00:00:00 | Minor | A
2011-11-27 00:00:00 | Minor | B
2011-11-28 00:00:00 | RIDDOR | A
2011-11-28 00:00:00 | RIDDOR | D
2011-11-28 00:00:00 | Minor | A
2011-11-28 00:00:00 | Minor | B
2011-11-28 00:00:00 | Minor | B
Spreadsheet: 51591d1251235426-auto-increment-from-linked-formula-problem-sample
Sheet: Sheet1

Sample Date
Good Data 1
Extra
Extra
Good Data 2
Extra
Extra
Good Data 3
Extra
Extra
Good Data 4
Extra
Extra
Good Data 5
Extra
Extra
Good Data 6
Extra
Extra
Good Data 7
Extra
Extra
Good Data 8
Extra
Extra
Good Data 9
Extra
Extra
Good Data 10
Extra
Extra
Good Data 11
Extra
Extra
Good Data 12
Extra
Extra
Spreadsheet: 163066d1340181922-finding-first-non-zero-value-in-a-column-and-then-return-all-values-non-zero-and-zero-returning-data
Sheet: Ark1

 |  |  | 5 | IN COLUMN D YOU WILL SEE HOW I WANT IT TO LOOK LIKE
 |  |  | 6 | In Column B is what I have managed so far.. But this is not correct
 |  |  | 7
5
6 |  |  | 6
7 |  |  | 3
 |  |  | 6
6 |  |  | 20
3 |  |  | 10
6
20
10
Spreadsheet: 26243d1218216686-spliting-numbers-basic
Sheet: Sheet1

[NAME] | BUY/SELL | GOAL_QTY | ORDER_TYPE | [NAME] | EXCHANGE | PRODUCT | CONTRACT_DESCRIPTION | [NAME] | ACCOUNT
1 | Buy | 4 | SCO | 94.565 | LIFFE | SH STERLNG | Short Sterling | H | 58963354
2 | Sell | 4 | AT OPEN |  | LIFFE | SH STERLNG | Short Sterling | H | 58963354
3 | Sell | 2 | SCO | 1.5483 | CME | GEUROFX | Euro | U | 58963354
4 | Sell | 3 | SCO | 1.8596 | CME | GEUROFX | Euro | U | 58963354
5 | Buy | 6 | SCO | 79.3332 | FINEX | DX | US Dollar Index | U | 58963354
6 | Buy | 6 | SCO | 84.0002 | FINEX | DX | US Dollar Index | U | 58963354
7 | Sell | 6 | SCO | 73.2256 | FINEX | DX | US Dollar Index | U | 58963354
8 | Buy | 5 | SCO | 101.2322 | CME | GEURDLLR | Eurodollar | Z | 58963354
9 | Sell | 5 | SCO | 14.2222 | CME | GEURDLLR | Eurodollar | Z | 58963354
10 | Sell | 1 | AT OPEN |  | CME | GEURDLLR | Eurodollar | Z | 58963354
11 | Buy | 1 | AT OPEN |  | CME | NYM_HG | Copper | U | 58963354
12 | Buy | 1 | SCO | 373.8 | CME | NYM_HG | Copper | U | 58963354
13 | Buy | 1 | SCO | 374.05 | CME | NYM_HG | Copper | U | 58963354
14 | Sell | 1 | SCO | 357.7 | CME | NYM_HG | Copper | U | 58963354
15 | Buy | 3 | SCO | 108 | CME | GLCATTLE | Live Cattle | V | 58963354
16 | Buy | 3 | SCO | 108.75 | CME | GLCATTLE | Live Cattle | V | 58963354
17 | Sell | 1 | SCO | 1352 | eCBOT | [NAME] | Soybean | X | 58963354
18 | Sell | 1 | SCO | 1339.5 | eCBOT | [NAME] | Soybean | X | 58963354
19 | Buy | 2 | SCO | 116.71875 | eCBOT | C30TBOND | 30 Year US Treasury Bond | U | 58963354
20 | Sell | 3 | SCO | 114.71875 | eCBOT | C30TBOND | 31 Year US Treasury Bond | U | 58963354
Spreadsheet: 735789d1623175704-countifs-always-returns-value-error-countifs-problem
Sheet: Assignments (2)

 | Ins # | Temp
-75C | INS-4936 | -75C (single Door) | a1 | a2 | MSCF | MSCF
5C | INS-2094 | 5C Single Door | a1 | a2 | a3 | a4
5C | [NAME] | 5C Single Door | MSCF | MSCF | xyz | xyz
5C | INS-6559 | 5C (3-Door) | MSCF | MSCF | xyz | xyz
5C |  |  | MSCF | MSCF | xyz | xyz
5C |  |  | MSCF | MSCF | xyz | xyz
5C |  |  | MSCF | MSCF | xyz | xyz |  | how many times "xyz" occurs in "-75C" row
-20C | pending | Freezer -20C (single door) | MSCF | MSCF | xyz | xyz
-20C | INS-0226 | Freezer -20C (single door) | a2 | a2 | a3 | a4
-75C | INS-0443 | 5C (3-Door) | xyz | xyz | xyz | xyz
5C |  |  | a1 | a2 | a3 | a4
5C |  |  | a1 | a2 | a3 | a4
5C |  |  | a1 | a2 | a3 | a4
Spreadsheet: 787197d1657683288-index-match-with-tie-sample-wb
Sheet: Supplier 1

 |  |  |  | (The details are to be consistent with the criteria outlined in the forms)
 |  |  |  |  | Score
 | Weighting Ratio |  | Price
 |  |  | Non-Price
 | Quotation 1 - Supplier/Service Provider Name:
 | Table 1 - Compliance Assessment Criteria
 |  |  |  |  |  |  |  |  |  |  |  |  |  | Consensus
 | 1 | fffg |  |  |  |  |  |  |  | Please Select PASS/ FAIL | PASS | Please Select PASS/ FAIL | FAIL
 | 2 | zzz |  |  |  |  |  |  |  | Please Select PASS/ FAIL | Please Select PASS/ FAIL | FAIL | PASS
 | 3 | dfff |  |  |  |  |  |  |  | Please Select PASS/ FAIL | Please Select PASS/ FAIL | Please Select PASS/ FAIL | Please Select PASS/ FAIL
 | 4 | fffg |  |  |  |  |  |  |  | Please Select PASS/ FAIL | Please Select PASS/ FAIL | Please Select PASS/ FAIL | Please Select PASS/ FAIL
 | 5 | kkk |  |  |  |  |  |  |  | Please Select PASS/ FAIL | Please Select PASS/ FAIL | Please Select PASS/ FAIL | Please Select PASS/ FAIL
 | 6 | aa |  |  |  |  |  |  |  | EXCEPTIONAL | SATISFACTORY | EXCEPTIONAL | SATISFACTORY
 | 7 | fffg |  |  |  |  |  |  |  | SATISFACTORY | EXCEPTIONAL | SATISFACTORY | EXCEPTIONAL
 | 8 | fffg |  |  |  |  |  |  |  | UNSATISFACTORY | UNSATISFACTORY | SATISFACTORY | SATISFACTORY