tianzl66/Sheetpedia huggingface dataset:
Spreadsheet: 860305d1708447685-counting-value-in-a-cell-if-a-cell-in-the-same-row-but-a-different-column-has-a-set-value-getting-help7
Sheet: Staff Review

Staff member | Manager | Placement | Sap/Resi | F2F Training Outstanding | F2F Training In Date | [NAME] | E-Learning Training Outstanding | E-Learning Training In Date | E-Learning Training RAG Rating
 |  |  | SAP
 |  |  | SAP
 |  |  | SAP
 |  |  | SAP
 |  |  | SAP
 |  |  | SAP
 |  |  | SAP
 |  |  | SAP
 |  |  | SAP
 |  |  | SAP
 |  |  | SAP
 |  |  | SAP
 |  |  | SAP
 |  |  | SAP
 |  |  | SAP
 |  |  | SAP
 |  |  | SAP
 |  |  | SAP
 |  |  | SAP
 |  |  | RESI
 |  |  | RESI
 |  |  | RESI
 |  |  | RESI
 |  |  | RESI
 |  |  | RESI
 |  |  | RESI
 |  |  | RESI
 |  |  | RESI
 |  |  | RESI
 |  |  | RESI
 |  |  | RESI
 |  |  | RESI
 |  |  | RESI
 |  |  | RESI
 |  |  | SAP
 |  |  | SAP
 |  |  | SAP
 |  |  | SAP
 |  |  | SAP
 |  |  | SAP
 |  |  | SAP
 |  |  | SAP
 |  |  | SAP
 |  |  | SAP
 |  |  | SAP
 |  |  | SAP
 |  |  | SAP
 |  |  | SAP
 |  |  | RESI
Spreadsheet: 705006d1605845753-formula-to-best-pull-in-values-from-a-chart-and-if-there-are-values-in-a-specific-column-att-summary
Sheet: Sheet3

Program & Site | Service Description (Code) | Attendance Type Option | Count
Fairfield | Community Integration Training (Daily) (055 ) | Present - Remote | 1
Fairfield | [NAME] (102 ) | Not Billable | 0
[NAME] | Transportation per Trip (880 ) | AM Transportation | 0.5
[NAME] | Transportation per Trip (880 ) | PM Transportation | 0.5
[NAME] | Transportation per Trip (880 ) | Round Trip | 1
Santa Rosa | Adult Day Program (510 ) | Absent | 0
Santa Rosa | Adult Day Program (510 ) | Present - Remote | 1
Vacaville | Adult Day Program (510 ) | Absent | 0
Vacaville | Adult Day Program (510 ) | Present - Remote | 1
Vacaville | Transportation per Trip (880 ) | Absent | 0
Vacaville | Transportation per Trip (880 ) | Present - Remote | 1
Spreadsheet: 50716d1250181749-drop-downs-to-drive-spreadheet-drop-downs-to-drive-spreadheet
Sheet: Sheet2

 |  | Item 1 | Item 2 | Item 3 | Item 4 | Item 5 | Item 6 | Item 7
 | AAA | 100 | 101 | 102 | 105 | 343 | 132 | 324
 | BBB | 569 | 415 | 143 | 241 | 264 | 154 | 413
 | CCC | 368 | 214 | 656 | 245 | 987 | 654 | 321
 | DDD | 147 | 258 | 369 | 963 | 852 | 741 | 159
 | EEE | 747 | 787 | 575 | 656 | 969 | 214 | 125
 | FFF | 121 | 259 | 264 | 589 | 361 | 179 | 654
 | GGG | 139 | 715 | 913 | 379 | 451 | 146 | 111
 | HHH | 889 | 445 | 665 | 337 | 119 | 698 | 415
Spreadsheet: 847401d1698343419-incorporating-a-unique-value-criteria-into-sumifs-excel-forum-unique-sumifs-dummy-data
Sheet: Sheet1

Name | Month | Model | Zip | Sales | [NAME] | Distance
[NAME] | 1 | x | 2155 | 1 | 100 | 4.12345
[NAME] | 1 | x | 19104 | 1 | 50 | 3.23456
[NAME] | 2 | x | 19104 | 1 | 50 | 3.23456
[NAME] | 2 | y | 19104 | 1 | 50 | 3.23456
[NAME] | 1 | x | 8830 | 1 | 75 | 9.12345
[NAME] | 1 | x | 8830 | 1 | 75 | 4.45678
Sandra | 1 | x | 2155 | 1 | 100 | 8.12345
Elise | 1 | x | 19104 | 1 | 50 | 2.12345
Spreadsheet: 143407d1330406923-what-is-the-easiest-way-to-copy-and-past-recently-entered-data-in-sheet-3-sample
Sheet: Sheet3

S.N. | NameNep | GenderNep | VDCCode | BDistrict | BVDCMunici | BWardNo. | PDistrict | PVDCMunici | PWardNo. | FatherNep | FCitizenship | FDistrict | FVDCMunici | FWardNo. | Coma | Dash | Fullstop | MotherNep | MCitizenship | MDistrict | MVDCMunici | MWardNo. | mComa | mDash | mFullstop | HusbandNep | HDistrict | HVDCMunici | HWardNo. | HCitizen | hComa | hDash | hFullstop | NYear | NMonth | NDay | EYear | EMonth | EDay | Name | EBDistrict | EBVDCMunici | EPDistrict | EPVDCMunici | Gender | DateofIssu | NepaliDate | EnglishDate | Signedby | EnglishforIssue
111034 | o1 g]kfnL | k'?if | 037 | ;'[NAME] | u'dL | 4 | ;'[NAME] | u'dL | 4 | k"0f{axfb'/ g]kfnL | g]kfnL | ;'[NAME] | u'dL | 4 | , | - | . |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 2045 | 9 | 23 | 1989 | 01 | 6 | [NAME] | Surkhet | Gumi | Surkhet | Gumi | M. | 2068/11/14 | 2045/9/23 | 1989/01/6 |  | 40965.49063310185
111035 | u+uf l;+x | dlxnf | 025 | ;'[NAME] | /fd3f6 | 4 | ;'[NAME] | /fd3f6 | 4 | [NAME] l;+x 7s'/L | g]kfnL | ;'[NAME] | /fd3f6 | 4 | , | - | . | wd{l;nf l;+x | g]kfnL | ;'[NAME] | /fd3f6 | 4 | , | - | . |  |  |  |  |  |  |  |  | 2048 | 5 | 29 | 1991 | 09 | 14 | [NAME] | Surkhet | Ramghat | Surkhet | Ramghat | F. | 2068/11/14 | 2048/5/29 | 1991/09/14 |  | 40965.49118171296
Spreadsheet: andy_zipper__782__10_25_01LO
Sheet: Sheet1

 |  |  | SCS  OPTION  DATA
 | TICKER | STRIKE | STR BID | STR ASK | B VOL | A VOL | M STD/DAY | WHEN
 | CL Z1 | 22.5 | 220 | 230 | 52.5 | 54.8 | 0.76 | 2001-10-25 13:06:00
 | CL F2 | 22.5 | 342 | 352 | 51.8 | 53.3 | 0.74 | 2001-10-25 13:06:00
 | CL G2 | 22.5 | 435 | 450 | 51.4 | 53.2 | 0.74 | 2001-10-25 13:06:00
 | CL H2 | 22.5 | 488 | 500 | 49.8 | 51.1 | 0.71 | 2001-10-25 13:06:00
 | CL J2 | 22.5 | 515 | 535 | 47 | 48.9 | 0.68 | 2001-10-25 13:06:00
 | CL K2 | 22.5 | 540 | 550 | 44.6 | 45.4 | 0.64 | 2001-10-25 13:06:00
 | CL M2 | 22.5 | 550 | 560 | 42.2 | 43 | 0.6 | 2001-10-25 13:06:00
 | CL N2 | 22.5 | 555 | 570 | 39.7 | 40.8 | 0.57 | 2001-10-25 13:06:00
 | CL Q2 | 22.5 | 560 | 575 | 37.9 | 38.9 | 0.54 | 2001-10-25 13:06:00
 | CL U2 | 22.5 | 565 | 575 | 36.5 | 37.1 | 0.52 | 2001-10-25 13:06:00
 | [NAME] | 22 | 565 | 580 | 35.5 | 36.5 | 0.5 | 2001-10-25 13:06:00
 | CL X2 | 22 | 565 | 585 | 34.1 | 35.3 | 0.48 | 2001-10-25 13:06:00
 | [NAME] | 22 | 570 | 580 | 33.3 | 33.9 | 0.46 | 2001-10-25 13:06:00
 | CL M3 | 21.5 | 560 | 580 | 28.4 | 29.4 | 0.39 | 2001-10-25 13:06:00
 | CL Z3 | 21.5 | 560 | 580 | 25.3 | 26.2 | 0.35 | 2001-10-25 13:06:00
Spreadsheet: 121976d1316534018-data-populate-after-choosing-a-field-from-a-drop-down-an-approach
Sheet: names

 | [NAME] |  |  |  | grade 8
 | [NAME] |  |  |  | grade 3
 | [NAME] |  |  |  | grade 2
 | Bess Vannostrand |  |  |  | grade 1
 | [NAME] |  |  |  | grade 5
 | [NAME] |  |  |  | grade 4
 | Julieann Segers |  |  |  | grade 7 | 7
 | [NAME] |  |  |  | grade 6
 | [NAME] |  |  |  | grade 2
 | [NAME] |  |  |  | grade 4
 | Illa Fye |  |  |  | grade 3
 | [NAME] |  |  |  | grade 7 | 12
 | [NAME] |  |  |  | grade 1
 | [NAME] |  |  |  | grade 3
 | [NAME] |  |  |  | grade 8
 | Raymundo Dinatale |  |  |  | grade 1
 | [NAME] |  |  |  | grade 1
 | [NAME] |  |  |  | grade 7 | 18
 | [NAME] |  |  |  | grade 8
 | [NAME] |  |  |  | grade 3
 | [NAME] |  |  |  | grade 4
 | [NAME] |  |  |  | grade 7 | 22
 | Gwyn [NAME] |  |  |  | grade 7 | 23
 | [NAME] |  |  |  | grade 1
 | [NAME] |  |  |  | grade 5
 | [NAME] |  |  |  | grade 7 | 26
 | [NAME] |  |  |  | grade 8
 | [NAME] |  |  |  | grade 6
 | [NAME] |  |  |  | grade 5
 | [NAME] |  |  |  | grade 6
 | [NAME] |  |  |  | grade 7 | 31
 | [NAME] |  |  |  | grade 6
 | [NAME] |  |  |  | grade 6
 | [NAME] |  |  |  | grade 1
 | [NAME] |  |  |  | grade 8
 | [NAME] |  |  |  | grade 5
 | Spring Renard |  |  |  | grade 1
 | [NAME] Frakes |  |  |  | grade 3
 | [NAME] |  |  |  | grade 5
 | In Cadogan |  |  |  | grade 3
 | Lucile Wolken |  |  |  | grade 5
 | [NAME] |  |  |  | grade 7 | 42
 | Mika Winland |  |  |  | grade 1
 | [NAME] |  |  |  | grade 6
 | [NAME] |  |  |  | grade 1
 | [NAME] |  |  |  | grade 8
 | Alisha Robichaux |  |  |  | grade 7 | 47
 | [NAME] |  |  |  | grade 7 | 48
Spreadsheet: 77402d1277891592-list-box-to-populate-results-query-1-
Sheet: Results

[NAME] | Band | REG | Forename | Surname | Gender | DOB | [NAME] | [NAME] | [NAME] | Info 5 | Number @ C+ | 5A*-C | [NAME] | English A*-C | Maths A*-C | Exam Entries
 | D | 1 | a | fds | F |  |  |  |  |  | 5 | 0 | 0 | 0 | 0 | 8
 | A | 2 | f | ds | F |  |  |  |  |  | 6 | 1 | 1 | 1 | 1 | 9
 | C | 3 | sdf | dsf | F |  |  |  |  |  | 7 | 1 | 0 | 0 | 0 | 10
 | D | 4 | dsf | sdf | M |  |  |  |  |  | 8 | 0 | 0 | 0 | 0 | 11
 | D | 5 | dd | dsf | M |  |  |  |  |  | 9 | 1 | 0 | 0 | 0 | 12
 | D | 6 | sd | sdf | M |  |  |  |  |  | 10 | 1 | 0 | 0 | 0 | 13
Spreadsheet: 111848d1308127581-cheking-through-data-and-show-status-sanlen_data
Sheet: Status (2)

Name | Status
Name1
[NAME]
Name3
Name4
Name5
Name6
Name7
Name8
Name9
Name10
Name11
Name12
Name13
Spreadsheet: 157126d1337624835-excel-2008-complex-searching-in-multiple-column-copy_timesheet
Sheet: Leave

EXIDE INDUSTRIES LIMITED |  | From | To | No of
[NAME] | 114 | 2012-03-21 00:00:00 | 2012-03-26 00:00:00 | 1
MANJUSHA PAUL | 1084 | 2012-03-26 00:00:00 | 2012-03-26 00:00:00 | 1 |  | 1. If the day exist in holiday sheet then it should be marked as “H” against all employee code in the corresponding column (Done, and its working fine)
 | 1084 | 2012-03-27 00:00:00 | 2012-03-27 00:00:00 | 1 |  | 2. Then is the employee has taken leave as given in Leave sheet then on the day column relevant it should be marked “L”
 | 1084 | 2012-03-28 00:00:00 | 2012-03-31 00:00:00 | 1 |  | 3. Again if the employees not taken leave and in Attend sheet -> Absent Column contain “TRUE” then it should be marked as “A”
SUBRATA GHOSH | 1173 | 2012-03-20 00:00:00 | 2012-03-23 00:00:00 | 4 |  | 4. Again if the employee not taken leave and in Attend Sheet ->Exception Column contain “TOUR” then it should be marked as “T”
[NAME] | 1230 | 2012-03-21 00:00:00 | 2012-03-21 00:00:00 | 1 |  | 5. Else rest marked with "P"
RAU MANDALIKA BHASKAR VENKATA | 1471 | 2012-03-23 00:00:00 | 2012-03-23 00:00:00 | 0.5
TILOTTAMA DAS | 1513 | 2012-04-07 00:00:00 | 2012-04-07 00:00:00 | 1 |  | P > Present
 | 1513 | 2012-04-20 00:00:00 | 2012-04-20 00:00:00 | 0.5 |  | H > Holiday / Weekly Off
[NAME] | 1756 | 2012-04-10 00:00:00 | 2012-04-11 00:00:00 | 2 |  | L > Leave
 | 1756 | 2012-04-20 00:00:00 | 2012-04-20 00:00:00 | 1 |  | T > On Duty / Tour
SANDIP PRADHAN | 1834 | 2012-03-31 00:00:00 | 2012-03-31 00:00:00 | 1 |  | A > Absent means unregularised absence
MANASI BISWAS | 6031 | 2012-03-21 00:00:00 | 2012-03-21 00:00:00 | 1
SUDIPTO ROY | 6057 | 2012-03-31 00:00:00 | 2012-04-08 00:00:00 | 9
MIR GEASHUDDIN AHAMMED | 6505 | 2012-04-06 00:00:00 | 2012-04-06 00:00:00 | 1
KRANTI CHOWDHURY MALLICK | 6510 | 2012-03-31 00:00:00 | 2012-03-31 00:00:00 | 0.5
SHIVENDER KUMAR GAUTAM | 7978 | 2012-03-19 00:00:00 | 2012-03-25 00:00:00 | 7
SUSHOVIT MISHRA | 8102 | 2012-03-21 00:00:00 | 2012-03-21 00:00:00 | 0.5
KALYANI BHOWMICK | 8211 | 2012-03-27 00:00:00 | 2012-03-27 00:00:00 | 1
[NAME] | 8327 | 2012-04-09 00:00:00 | 2012-04-09 00:00:00 | 1
MD ASIF IKBAL MUNSHI | 8489 | 2012-04-06 00:00:00 | 2012-04-13 00:00:00 | 8
KAUSTAV HALDER | 8569 | 2012-04-06 00:00:00 | 2012-04-06 00:00:00 | 0.5
 | 8569 | 2012-04-10 00:00:00 | 2012-04-16 00:00:00 | 0.5
Spreadsheet: 794829d1662349358-bill-of-measure-for-ingredient-consumptions-bom
Sheet: BOM

Recipe Yield |  |  |  |  |  |  |  |  |  | Ingredients Consumption
Final Product | Ingredients | UOM | Amount |  |  |  |  |  |  | Ingredients | UOM | Amount
Amatriciana | Mozzarella Cheese | Kg | 0.5 |  |  |  |  |  |  | Mozzarella Cheese | Kg
Amatriciana | Tomato Sauce | Kg | 0.2 |  |  | ITEM USED |  |  |  | Tomato Sauce | Kg
Amatriciana | Smoked Beef | Kg | 0.15 |  |  | ITEM USED | UOM | QTY |  | Smoked Beef | Kg
Amatriciana | Pecorino Cheese | Kg | 0.05 |  |  | Amatriciana | PIE | 1 |  | Pecorino Cheese | Kg
[NAME] | Mozzarella Cheese | Kg | 0.8 |  |  | [NAME] | PIE | 1
[NAME] | Tomato Sauce | Kg | 0.3
Spreadsheet: b416e31f-dd82-4914-8ee0-fecff4a2c820
Sheet: CLASS-FAMILY

Supplementary data  TABLE S1
Baltimore Classification. Major viral families infecting vertebrate (data retrived from ViralZone)
Class I | Class II | Class III | Class IV | Class V | Class VI | Class VII
[NAME] | Anelloviridae | Birnaviridae | Hepeviridae | [NAME] | Retroviridae | Hepadnaviridae
Alloherpesviridae | Circoviridae | Picobirnaviridae | Arteriviridae | Rhabdoviridae
Adenoviridae | Parvoviridae | Reoviridae | Coronaviridae | Filoviridae
Papillomaviridae |  |  | Picornaviridae | Filoviridae
Polyomaviridae |  |  | Astroviridae | Paramyxoviridae
Asfarviridae |  |  | Caliciviridae | Arenaviridae
Iridoviridae |  |  | Flaviviridae | Bunyaviridae
Poxviridae |  |  | Nodaviridae | Orthomyxoviridae
 |  |  | Togaviridae
(Phycodnaviridae)
Major viral families infecting vertebrate (Abbreviated)
Class I | Class II | Class III | Class IV | Class V | Class VI | Class VII
Her | Ane | Bir | [NAME] | [NAME] | Ret | [NAME]
All | Cir | Pic | Art | [NAME]
Ade | Par | Reo | Cor | Fil
Pap |  |  | Pic | Par
Pol |  |  | Ast | Are
Asf |  |  | Cal | Bun
Iri |  |  | Fla | Ort
Pox |  |  | Nod
 |  |  | [NAME]
(Phy)
Spreadsheet: 0421089d-3a82-4d7d-a081-06daf4726c25
Sheet: Sheet1

Character | Coding in Prieto-Márquez [30] | Revised coding (present study)
4 | 2 | 3
9 | ? | 1
10 | ? | 1
12 | ? | 1
71 | ? | 0
80 | 0 | 1
128 | ? | 1
144 | ? | 1
147 | ? | 0/1
153 | ? | 1
159 | ? | 1
160 | ? | 1
184 | ? | 6
192 | 0 | 2
193 | ? | 1
223 | ? | 1
236 | 2 | 1
244 | 0 | 1
Spreadsheet: 57513d1257738695-format-data-from-web-so-its-usable-hospital-births_revised
Sheet: Sample Data

Banner Desert Medical Center — Mesa, AZ
Hospital Type | General medical and surgical | ER Visits: | 83212
Admissions/Visits: | 41,542 Inpatient / 133,208 Outpatient | Births: | 7552
Surgeries: | 8,793 Inpatient / 9,581 Outpatient | Beds: | 518
Banner Thunderbird Medical Center — Glendale, AZ
Hospital Type | General medical and surgical | ER Visits: | 65827
Admissions/Visits: | 29,189 Inpatient / 256,950 Outpatient | Births: | 4821
Surgeries: | 10,448 Inpatient / 4,660 Outpatient | Beds: | 376
Flagstaff Medical Center — Flagstaff, AZ
Hospital Type | General medical and surgical | ER Visits: | 39552
Admissions/Visits: | 12,849 Inpatient / 526,176 Outpatient | Births: | 1591
Surgeries: | 5,443 Inpatient / 1,959 Outpatient | Beds: | 271
Maricopa Integrated Health System — Phoenix, AZ
Hospital Type | General medical and surgical | ER Visits: | 45428
Admissions/Visits: | 17,374 Inpatient / 323,370 Outpatient | Births: | 4598
Surgeries: | 3,712 Inpatient / 1,941 Outpatient | Beds: | 542
Phoenix Children's Hospital — Phoenix, AZ
Hospital Type | Children's general | ER Visits: | 59750
Admissions/Visits: | 11,996 Inpatient / 163,019 Outpatient | Births: | 0
Surgeries: | 4,405 Inpatient / 6,693 Outpatient | Beds: | 294
Phoenix Veterans Affairs Health Care System — Phoenix, AZ
Hospital Type | General medical and surgical | ER Visits: | 22587
Admissions/Visits: | 7,082 Inpatient / 626,237 Outpatient | Births: | 0
Surgeries: | 1,024 Inpatient / 2,887 Outpatient | Beds: | 177
Scottsdale Healthcare Shea — Scottsdale, AZ
Hospital Type | General medical and surgical | ER Visits: | N/A
Admissions/Visits: | 25,019 Inpatient / N/A Outpatient | Births: | 4725
Surgeries: | 9,265 Inpatient / 17,112 Outpatient | Beds: | 405
Sierra Vista Regional Health Center — Sierra Vista, AZ
Hospital Type | General medical and surgical | ER Visits: | 28568
Admissions/Visits: | 5,855 Inpatient / 85,126 Outpatient | Births: | 1401
Surgeries: | 1,571 Inpatient / 3,390 Outpatient | Beds: | 88
St. Joseph's Hospital and Medical Center — Phoenix, AZ
Hospital Type | General medical and surgical | ER Visits: | 65396
Admissions/Visits: | 33,966 Inpatient / 399,559 Outpatient | Births: | 5730
Surgeries: | 14,065 Inpatient / 0 Outpatient | Beds: | 690
Tucson Medical Center — Tucson, AZ
Hospital Type | General medical and surgical | ER Visits: | 88997
Admissions/Visits: | 34,427 Inpatient / 200,789 Outpatient | Births: | 6689
Surgeries: | 11,364 Inpatient / 9,493 Outpatient | Beds: | 547
Spreadsheet: 42970d1241593362-sum-across-multiple-sheets-demo2
Sheet: Summary (21-31)

No of Items Sold
 | 29 | 30 | 31 | 1 | 2 | 3 | 4
Apple | 12 | 12 | 12 | 24
Mango | 12
[NAME] | 15
Pine Apple | 30
Kiwi | 0
Spreadsheet: 89493d1289289216-formula-is-valid-but-not-with-named-range-index-match-sample
Sheet: Lists

Service_Type | ACTIVITIES | Backpacking | Canoeing | Caving | Kayaking | Mountain_Biking | Rafting | Rock_Climbing | Ropes_Course |  | FOOD | Europe | Americas | UK | France | Wales | England | US | Washington | Canada | Ontario |  | WEEKDAY |  | MONTH
ACTIVITIES | Backpacking |  |  |  |  |  |  |  |  |  |  | UK | US | England | Brittany | Cardiff | London | California | Seattle | Ontario | Toronto |  | Sunday |  | January
FOOD | Canoeing |  |  |  |  |  |  |  |  |  |  | France | Canada | Wales | Calvados | Swansea | Birmingham | Washington | [NAME] | Quebec | [NAME] |  | Monday |  | February
LODGING | Caving |  |  |  |  |  |  |  |  |  |  |  | Mexico | Scotland | Charente | Newport | [NAME] | Florida | Tacoma | British Columbia | [NAME] |  | Tuesday |  | March
TRANSPORT | Kayaking |  |  |  |  |  |  |  |  |  |  |  | Brazil | Ireland | Cote-D'or | Bangor | Liverpool | Texas |  | Alberta |  |  | Wednesday |  | April
Facility_Rental | Mountain_Biking |  |  |  |  |  |  |  |  |  |  |  | Argentina |  | Loire | Aberystwyth | Southampton |  |  | Manitoba |  |  | Thursday |  | May
 | Primitive_Teachings |  |  |  |  |  |  |  |  |  |  |  | Chile |  | Normandy |  | Leeds |  |  |  |  |  | Friday |  | June
 | Rafting |  |  |  |  |  |  |  |  |  |  |  |  |  | Pas-de-Calais |  | Newcastle |  |  |  |  |  | Saturday |  | July
 | Rock_Climbing |  |  |  |  |  |  |  |  |  |  |  |  |  | Rhone |  |  |  |  |  |  |  |  |  | August
 | Ropes_Course |  |  |  |  |  |  |  |  |  |  |  |  |  | Sarthe |  |  |  |  |  |  |  |  |  | September
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  | [NAME] |  |  |  |  |  |  |  |  |  | October
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  | Seine-Maritime |  |  |  |  |  |  |  |  |  | November
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | December
 |  |  |  |  | =Lists!$A$2:INDEX(Lists!$A:$A,COUNTA(Lists!$A:$A))
 |  |  |  |  | ProgramModules!$C$5:$C$400
Spreadsheet: 844586d1696352347-hi-i-need-a-few-things-adding-or-changing-on-this-fishing-results-workbook-please-golborne-results-master-copy
Sheet: 8

Name | lbs | oz | Oz (total) | Points
Spreadsheet: 795291d1662608505-returning-data-based-on-first-cell-being-greater-than-zero-example-2-hd
Sheet: Sheet3

 |  |  |  |  |  |  |  |  |  |  |  |  |  | 44809 | 1900-01-01 00:00:00 | 1900-01-02 00:00:00 | 1900-01-03 00:00:00 | 2022-09-06 00:00:00 | 1900-01-04 00:00:00 | 1900-01-05 00:00:00 | 1900-01-06 00:00:00 | 2022-09-08 00:00:00 | 1900-01-07 00:00:00 | 1900-01-08 00:00:00 | 1900-01-09 00:00:00
FC No. | Job Description | X | X | X | X | X | X | X | X | X | Task Start Date | Task Finish Date | X | Friday | Hrs per day | Check | Roll Over | Monday | Hrs per day | Check | Roll Over | Tuesday | Hrs per day | Check | Roll Over
FC10001 | Forecast trial 1 |  |  |  |  |  |  |  |  |  | 2022-09-05 00:00:00 | 2022-09-05 00:00:00 |  | 5 | 8 | 8 | 8 | 0 | 8 | 8 | 8 | 0 | 8 | 8 | 8
FC10001 | Forecast trial 1 |  |  |  |  |  |  |  |  |  | 2022-09-05 00:00:00 | 2022-09-05 00:00:00 |  | 5 | 8 | 8 | 8 | 0 | 8 | 8 | 8 | 0 | 8 | 8 | 8
FC10001 | Forecast trial 1 |  |  |  |  |  |  |  |  |  | 2022-09-05 00:00:00 | 2022-09-05 00:00:00 |  | 5 | 8 | 8 | 8 | 0 | 8 | 8 | 8 | 0 | 8 | 8 | 8
FC10001 | Forecast trial 1 |  |  |  |  |  |  |  |  |  | 2022-09-06 00:00:00 | 2022-09-06 00:00:00 |  | 0 | 8 | 8 | 8 | 5 | 8 | 8 | 8 | 0 | 8 | 8 | 8
FC10001 | Forecast trial 1 |  |  |  |  |  |  |  |  |  | 2022-09-06 00:00:00 | 2022-09-08 00:00:00 |  | 0 | 8 | 8 | 8 | 5 | 8 | 8 | 8 | 5 | 8 | 8 | 8
FC10001 | Forecast trial 1 |  |  |  |  |  |  |  |  |  | 2022-09-08 00:00:00 | 2022-09-08 00:00:00 |  | 0 | 8 | 8 | 8 | 0 | 8 | 8 | 8 | 5 | 8 | 8 | 8
FC10001 | Forecast trial 1 |  |  |  |  |  |  |  |  |  | 2022-09-08 00:00:00 | 2022-09-08 00:00:00 |  | 0 | 8 | 8 | 8 | 0 | 8 | 8 | 8 | 5 | 8 | 8 | 8
I want to only look at the cells in yellow. where the first cell is greater than zero - wish to bring back the date in blue into the field in green. example if O4>0, then return O2 into L4. example if O5>0, then return O2 into L5.  If O4 or O5 are zero, then the formula needs to look into S4 and S5 respectively.
 |  |  |  |  |  |  |  |  |  |  | HD
Spreadsheet: mark_guzman__24559__Rogers_Calculator
Sheet: Spin

 |  | California Spin |  |  |  |  | Total spin needed to Carry |  |  |  |  | California Replacement
 | MST HE | PST HE | Bid Amt (MW) | Awarded Capacity (MW) |  | MST HE | PNM  Reserves | EPE    Contingency | Total Contingency | Spin |  | HE | Bid Amt (MW) | Awarded Capacity (MW)
1 | 1 | 1 | 0 | 0 |  | 1 |  | 83 |  |  |  | 1 | 0 | 0
2 | 2 | 2 | 0 | 0 |  | 2 |  | 85 |  |  |  | 2 | 0 | 0
2 | 3 | 3 | 0 | 0 |  | 3 |  | 87 |  |  |  | 3 | 0 | 0
3 | 4 | 4 | 0 | 0 |  | 4 |  | 88 |  |  |  | 4 | 0 | 0
4 | 5 | 5 | 0 | 0 |  | 5 |  | 88 |  |  |  | 5 | 0 | 0
 | 6 | 6 | 0 | 0 |  | 6 |  | 85 |  |  |  | 6 | 0 | 0
 | 7 | 7 | 0 | 0 |  | 7 |  | 89 |  |  |  | 7 | 0 | 0
 | 8 | 8 | 0 | 0 |  | 8 |  | 87 |  |  |  | 8 | 0 | 0
 | 9 | 9 | 0 | 0 |  | 9 |  | 84 |  |  |  | 9 | 0 | 0
 | 10 | 10 | 0 | 0 |  | 10 |  | 82 |  |  |  | 10 | 0 | 0
 | 11 | 11 | 0 | 0 |  | 11 |  | 83 |  |  |  | 11 | 0 | 0
 | 12 | 12 | 0 | 0 |  | 12 |  | 86 |  |  |  | 12 | 15 | 17.1 | 222
 | 13 | 13 | 0 | 0 |  | 13 |  | 86 |  |  |  | 13 | 0 | 0 | 80
 | 14 | 14 | 0 | 0 |  | 14 |  | 87 |  |  |  | 14 | 0 | 0
 | 15 | 15 | 0 | 0 |  | 15 |  | 87 |  |  |  | 15 | 0 | 0
 | 16 | 16 | 0 | 0 |  | 16 |  | 87 |  |  |  | 16 | 0 | 0
 | 17 | 17 | 0 | 0 |  | 17 |  | 86 |  |  |  | 17 | 0 | 0
 | 18 | 18 | 0 | 0 |  | 18 |  | 85 |  |  |  | 18 | 0 | 0
 | 19 | 19 | 0 | 0 |  | 19 |  | 84 |  |  |  | 19 | 0 | 0
 | 20 | 20 | 0 | 0 |  | 20 |  | 84 | 84 |  |  | 20 | 0 | 0
 | 21 | 21 | 0 | 0 |  | 21 |  | 83 |  |  |  | 21 | 0 | 0
 | 22 | 22 | 0 | 0 |  | 22 |  | 78 |  |  |  | 22 | 0 | 0
 | 23 | 23 | 0 | 0 |  | 23 |  | 79 |  |  |  | 23 | 0 | 0
 | 24 | 24 | 0 | 0 |  | 24 |  | 82 |  |  |  | 24 | 0 | 0
 |  |  |  |  |  |  |  | Enter Blue Numbers
Spreadsheet: 65742d1266423070-formatting-formatting-issue
Sheet: Sheet1

budget
22923.47
29600.16
0
25918.53
29808.56
9589.74
15527.64
29808.56
31471.23
53168.84
19502.02
0
25918.53
24120.98
80906.56
24630.73
45855.93
33451.41
35775.17
40168.35
29808.56
22923.47
40168.35
32503.37
32503.37
32503.37
24719.74
30030.65
849.56
2160.94
167.48
124.85
209.09
429.35
249.69
2181.24
196.91
309.58
3194.21
1869.63
508.52
204.02
474.67
2326.38
162.4
575.55
1347.92
1552.95
1898.05
63426
207626.54
146428.73
89232
105377.13
60604.69
Spreadsheet: 773561d1647936726-function-for-count-out-of-spec-book1
Sheet: Sheet1

 |  |  |  | NC
 |  | LCL | UCL
 |  | 2 | 2.6 |  | 3 | 2.2
 |  | 1 | 2 |  | 0.9 | 1.5
 |  | 3 | 3.5 |  | 3.2 | 3.4
 |  | 2 | 3 |  | 3.1 | 3.3
Spreadsheet: darrell_schoolcraft__7805__imbalsumm0108
Sheet: mewborne

 | [NAME]
 | 500174 |  | 53888 |  | 78060 |  | 78062
Day | Measured | Scheduled | Measured | Scheduled | Measured | Scheduled | Measured | Scheduled
1 | 7793 | 6031 |  |  | 1235 | 1150 | 1454 | 1283
2 | 7791 | 6031 |  |  | 1177 | 1150 | 1476 | 1283
3 | 5994 | 6031 |  |  | 1174 | 1150 | 1523 | 1283
4 | 7564 | 6031 |  |  | 1155 | 1150 | 1485 | 1283
5 | 7266 | 6031 |  |  | 1111 | 1150 | 1460 | 1283
6 | 7106 | 6031 |  |  | 1102 | 1150 | 1390 | 1283
7 | 6854 | 6031 |  |  | 1149 | 1150 | 1444 | 1283
8 | 6932 | 6031 |  |  | 1096 | 1150 | 1417 | 1283
9 | 6825 | 6031 |  |  | 1073 | 1150 | 1479 | 1283
10 | 7236 | 6031 |  |  | 1025 | 1150 | 1307 | 1283
11 | 7066 | 6031 |  |  | 1044 | 1150 | 1444 | 1283
12 | 7041 | 6031 |  |  | 1011 | 1150 | 1426 | 1283
13 | 7412 | 6031 |  |  | 1008 | 1150 | 1419 | 1283
14 | 5169 | 6031 |  |  | 956 | 1150 | 1409 | 1283
15 | 7298 | 6531 |  |  | 1098 | 1150 | 1394 | 1283
16 | 4507 | 6531 |  |  | 1042 | 1150 | 1404 | 1283
17 | 5627 | 6513 |  |  | 1034 | 1150 | 1409 | 1283
18 | 6389 | 6531 |  |  | 1004 | 1150 | 1399 | 1283
19
20
21
22
23
24 |  |  |  |  |  |  |  |  |  |  | 377
25 |  |  |  |  |  |  |  |  |  |  | 725
26
27
28
29
30
31
2001-07-31 00:00:00 |  |  |  |  |  |  |  |  | 372841.88
2001-08-18 00:00:00
CBS Volume
 |  |  | 146405
Spreadsheet: 125427d1319027888-excel-2007-moving-values-between-sheets-by-using-number-commands-afhendingase-lar-and-loadinfo-1
Sheet: ULD9&10

Name of airline |  |  |  | Aircraft Position |  |  | Name of Airline |  |  |  | Aircraft Position
Built up by: | Hjortur |  | Origin | ULD Ident |  |  | Built up by: | Hjortur |  | Origin | ULD Ident
Total Pages: |  |  |  |  |  |  | Total Pages:
AWB | DEST | PCS | WEIGHT |  | Flight Number |  | AWB | DEST | PCS | WEIGHT |  | Flight Number
 |  |  |  |  | Offload Point |  |  |  |  |  |  | Offload Point
 |  |  |  |  | Final Dest |  |  |  |  |  |  | Final Dest
ULD Tare Weight: |  |  |  |  |  |  |  | ULD Tare Weight:
RMK | Total |  |  |  |  |  | RMK | Total