tianzl66/Sheetpedia huggingface dataset:
Spreadsheet: 2d212763-2876-4dbe-af95-d5551a38a66f
Sheet: Sheet1

Species | voucher/culture | TEF1 | RPB1 | RPB2
Aigialus grandis | BCC 2000 | GU479839 |  | GU479814
Aliquandostipite khaoyaiensis | CBS 118232 | GU349048 |  | FJ238360
[NAME] | CBS 916.96 | DQ677927 |  | DQ677980
Apiosporina collinsii | CBS 118973 | GU349057 | GU357778
Ascochyta pisi | CBS 126.54 | DQ677913 |  | DQ677967
[NAME] manglicola | BCC 09270 | GU479846 |  | GU479821
Astrothelium cinnamomeum | DUKE 0000007 | DQ782896 | DQ782824 | AY584690
Aureobasidium pullulans | CBS 584.75 | DQ471075 | DQ471148 | DQ470906
Botryosphaeria dothidea | CBS 115476 | DQ767637 | GU357802 | DQ677944
Capnodium coffeae | CBS 147.52 | DQ471089 | DQ471162 | DQ247788
Cenococcum geophilum | 2005-01-01 00:00:00 | JN860113 | JN860099 | JN860087
Cenococcum geophilum | 1.58 |  | JN86011 | JN860098
Cladosporium cladosporioides | CBS 170.54 | DQ677898 | GU357790 | DQ677952
Coniosporium apollinis | CBS 100213 |  | GU250960 | GU250950
Coniosporium apollinis | CBS 109860 |  | GU250962 | GU250953
[NAME] cassiicola | CBS 100822 | GU349052 | GU357772 | GU371742
Davidiella tassiana | CBS 399.80 | DQ677918 | GU357793 | DQ677971
Dothidea sambuci | DAOM 231303 | DQ497606 |  | DQ522854
[NAME] centrolobi | CBS 222.50 | DQ677934 | GU357798
[NAME] phaseoli | CBS 165.31 | DQ677935 | GU357799
Guignardia bidwellii | CBS 237.48 |  | GU357794 | DQ677983
Hortaea werneckii | CBS 708.76 | GU349058 | GU357779 | GU371747
Hysterium angustatum | CBS 123334 | FJ161111 |  | FJ161129
[NAME] clavispora | CBS 247.34 | DQ677901 | FJ941903 | DQ677955
Leptosphaeria maculans | DAOM 229267 | DQ471062 | DQ471136 | DQ470894
Macrophomina phaseolina | CBS 227.33 | DQ677929 |  | DQ677986
Microthyrium microscopicum | CBS 115976 | GU349042 |  | GU371734
Mycosphaerella graminicola | CBS 292.38 |  |  | DQ677982
Mycosphaerella punctiformis | CBS 113265 | DQ471092 | DQ471165 | DQ470920
Myriangium duriaei | CBS 260.36 | DQ677900 |  | DQ677954
Mytilinidion mytilinellum | CBS 303.34 | FJ161100 | GU357810 | FJ161119
Mytilinidion scolecosporum | CBS 305.34 | FJ161102 | GU357811 | FJ161121
Opegrapha dolomitica | DUKE 0047528 | DQ883732 | DQ883717 | DQ883714
Patellaria atrata | CBS 958.97 | GU349038 | GU357749 | GU371726
Phaeotrichum benjaminii | CBS 541.72 | DQ677892 | GU357788 | DQ677946
Phoma herbarum | CBS 276.37 | DQ677909 | GU357792 | DQ677962
[NAME] | OSC 100066 | DQ677882
Rhytidhysterium rufulum | CBS 306.38 | GU349031 | FJ238444
Scorias spongiosa | CBS 325.33 | DQ677920 |  | DQ677973
Simonyella variegata | DUKE Printzen14310a | DQ782891 | DQ782819 | DQ782861
Teratosphaeria jonkershoekensis | CBS 112224 | GU349025 | GU357744 | GU371723
Trichodelitschia bisporula | CBS 262.69 | GU349020 | GU371812 | GU371802
Trypethelium nitidiusculum | AFTOL 2099 | GU327732 |  | GU561856
Tubeufia cerea | CBS 254.75 | DQ471105 | DQ471180 | DQ470934
Tubeufia paludosa | CBS 120503 | GU349024 | GU357754 | GU371731
Tyrannosorus pinicola | CBS 124.88 | DQ471098 | DQ471171 | DQ470928
Spreadsheet: larry_campbell__20969__Kingman Calcs
Sheet: Netting Calcs

[NAME]
RED ROCK EXPANSION PROJECT
KINGMAN COMPRESSOR STATION
1999 Emissions Based on Test Data
Unit | Nox (tpy) | CO (tpy) | VOC (tpy)
001
002
003
121 | 0 | 0 | 0
122 | 0 | 0 | 0
Total
2000 Emissions Based on Test Data
Unit | Nox (tpy) | CO (tpy) | VOC (tpy)
001
002
003
121
122 | 0 | 0 | 0
Total
Last 2-Year Emissions Average
Unit | Nox (tpy) | CO (tpy) | VOC (tpy)
001
002
003
121
122
Total
Proposed Emission Increases (tpy)
Turbine
[NAME]
TOTAL
Contemporaneous Emission Decreases (tpy)
Net Change (Increase - Decrease) (tpy)
Notes:
(1) Proposed NOx, CO, and VOC emissions based on turbine being operated at 64% load 100% of the time.
(2) Proposed increases are from proposed turbine and generator engines.
(3) Contemporaneous decreases are from permanent shutdown of Units 101, 102, 103, 121, and 122.
Spreadsheet: 878685d1725945169-conditional-formatting-for-dv-with-indirect-kenny_k-exampleexcel-cf-365-aligw
Sheet: Sheet1

Category | SubCategory | Colour |  |  |  |  |  |  |  |  |  | Gloss | [NAME] | [NAME] | Flint
Best | Matte | red |  | DV |  |  |  |  |  |  |  | red | black | yellow | pink
Best | Silk | marble |  | DV |  |  |  |  |  |  |  | black | navy | purple | [NAME]
 |  |  |  | DV |  |  |  |  |  |  |  | green | white | grey | orange
 |  |  |  | DV |  |  |  |  |  |  |  | white | teal | beige
 |  |  |  |  |  |  |  |  |  |  |  | Gloss_B | Matte | Silk | Nuance
 |  |  |  |  |  |  |  |  |  |  |  | black | flower | desert | sand
 |  | I want conditional formatting to alert if the selection in coloumn C "Colour" is not from the |  |  |  |  |  |  |  |  |  | antique | honey | marble | sky
 |  | "Sub Category" selected in column B. And like wise Column B "Sub Category from |  |  |  |  |  |  |  |  |  | Gold | silver | pewter | Ocean
 |  | column A "Category".
 |  | I have done this previously, but not using indirect. And my data tables are set up a
 |  | bit different this time.
Spreadsheet: 111447d1307816931-find-unique-values-and-string-concatenation-excel
Sheet: Sheet1

OrderKey
[PHONE]
[PHONE]
[PHONE]
[PHONE]
[PHONE]
[PHONE]
[PHONE]
[PHONE]
[PHONE]
[PHONE] |  | Order Count | 9
[PHONE] |  | Order No. | [PHONE],[PHONE],[PHONE],[PHONE],[PHONE],[PHONE],[PHONE],[PHONE],[PHONE]
[PHONE]
[PHONE]
[PHONE]
[PHONE]
[PHONE]
[PHONE]
[PHONE]
[PHONE]
[PHONE]
[PHONE]
[PHONE]
[PHONE]
[PHONE]
[PHONE]
[PHONE]
[PHONE]
[PHONE]
[PHONE]
[PHONE]
[PHONE]
[PHONE]
[PHONE]
Spreadsheet: 843156d1695103083-issue-with-dependent-combo-box-when-one-content-list-is-shorter-than-others-sample-combo-box-issue
Sheet: Reference

Assignee | Priority | Phase
Assignee A | High | Design
Assignee B | Low | Build
Assignee C | Medium | Test
Assignee D |  | Rollout
Assignee E |  | Close
Assignee F
Assignee G
Assignee H
Assignee I
Assignee J
Spreadsheet: 60731d1261259847-work-schedule-timesheet-copy-of-schedule-timesheet2
Sheet: Bob

[NAME]: [NAME] |  |  |  |  |  | [NAME]
PHONE:
EMPLOYEE#
POSITION: |  |  |  | Floor, Dishes | Cook, Mid/Drive | Start | End | Totals
 | Sun | No Work |  |  |  | 1900-01-01 00:00:00 | 1900-01-01 00:00:00 | 0
 | Mon | 07:50-13:00 |  |  |  | 07:50 | 13:00 | 5.166666666666666
 | Tue | No Work |  |  |  | 1900-01-01 00:00:00 | 1900-01-01 00:00:00 | 0
 | Wed | No Work |  |  |  | 1900-01-01 00:00:00 | 1900-01-01 00:00:00 | 0
 | Thu | 14:00-24:00 |  |  |  | 14:00 | 24:00 | 10
 | Fri | No Work |  |  |  | 1900-01-01 00:00:00 | 1900-01-01 00:00:00 | 0
 | Sat | No Work |  |  |  | 1900-01-01 00:00:00 | 1900-01-01 00:00:00 | 0
Est: | 15.16666666666667 | Hours: |  |  |  |  |  | 15.16666666666667
Date: 12/20-12/26
Uniform:
Meals:
Other:
Spreadsheet: 796348d1663233545-combining-2-tables-into-1-sorted-by-hour-combining_two_tables_sample
Sheet: Blad1

DAYS |  |  | Activities | From | To | Who | Total | Place | Remark |  |  | Activities | From | To | Who | Total | Place | Remark |  |  | Activities | From | To | Who | Total | Place | Remark
mon | 2022-10-03 00:00:00 | VM | [NAME] | 09:00:00 | 10:00:00 | anneleen | 20 | bib |  |  | VM | opleiding inclusie |  |  |  |  |  |  |  | VM |  | 09:00:00 | 10:00:00 | anneleen | 20 | bib | 0
 |  |  | klas 2 zoektocht | 10:00:00 | 11:00:00 | anneleen | 23 | bib |  |  |  | opleiding media |  |  |  |  |  |  |  |  | klas 2 zoektocht | 10:00:00 | 11:00:00 | anneleen | 23 | bib | 0
 |  |  | klas 3 zoektocht | 11:00:00 | 12:00:00 | carolien | 14 | bib |  |  |  | boetenbrieven |  |  |  |  |  |  |  |  | [NAME] | 10:30:00 | 10:45:00 | carolien | 17 | bib | 0
 |  |  | [NAME] | 10:30:00 | 10:45:00 | carolien | 17 | bib |  |  |  | [NAME] |  |  |  |  |  |  |  |  | klas 3 zoektocht | 11:00:00 | 12:00:00 | carolien | 14 | bib | 0
 |  |  |  |  |  |  |  |  |  |  |  | vergadering de faar | 10:00:00 | 12:00:00 | jan |  | de faar |  |  |  | 0 | 00:00:00 | 00:00:00 | 0 | 0 | 0 | 0
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 0 | 00:00:00 | 00:00:00 | 0 | 0 | 0 | 0
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 0 | 00:00:00 | 00:00:00 | 0 | 0 | 0 | 0
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 0 | 00:00:00 | 00:00:00 | 0 | 0 | 0 | 0
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 0 | 00:00:00 | 00:00:00 | 0 | 0 | 0 | 0
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 0 | 00:00:00 | 00:00:00 | 0 | 0 | 0 | 0
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 0 | 00:00:00 | 00:00:00 | 0 | 0 | 0 | 0
 |  | NM | [NAME] | 13:00:00 | 14:00:00 | carolien | 17 | bib |  |  | NM | opleiding inclusie |  |  |  |  |  |  |  | NM
 |  |  | [NAME] | 14:00:00 | 15:00:00 | anneleen | 28 | bib |  |  |  | opleiding media
 |  |  |  |  |  |  |  |  |  |  |  | [NAME]
 |  |  |  |  |  |  |  |  |  |  |  | overleg eddy stevens | 14:00:00 | 15:00:00 | jan | 2 | jan
 |  |  |  |  |  |  |  |  |  |  | AV | @ppcafé sessie 1 | 19:30:00 | 21:30:00 | karen | 7 | leeszaal |  |  | AV
TABLE 1: SCHOOL ACTIVITIES |  |  |  |  |  |  |  |  |  |  | TABLE 2: SPECIAL ACTIVITIES |  |  |  |  |  |  |  |  | TABLE 3: TABLE 1 & TABLE 2 COMBINED SORTED BY "FROM"
 |  |  |  | RANGES: D4:J14;  D15:J23 |  |  |  |  |  |  |  |  |  | RANGES: M4:S14;     M15:S22;        M23:S23;
Spreadsheet: lynn_blair__24484__NNGWKednotes_2001
Sheet: September 22 & 23, 2001

NNG WEEKEND NOTES
For cc Mail distribution:  [NAME], [NAME], [NAME], S. January, [NAME], [NAME], [NAME], TMS OnCall
SATURDAY |  |  | 2001-09-22 00:00:00
Mail distribution send to the above listing on Sunday evening.
H:\DATA\Process Guidelines\[NNGWKednotes Template.xls]Dec 25 & 26
 | PROCESS |  |  |  | COMMENTS:
 | Gas Day: | SAT |  |  | Access to TMS denied; entered through RAS.
 | 7:00 A.M. Non-grid: |  |  |  | Storage injections allocated, no further difficulties.
 | Gas Day: | FRI |  |  | Access to TMS denied, entered through RAS.
 | 8:00 AM Final Storage |  |  |  | No further difficulties.
 | Gas Day: | SAT |  |  | Allocated storage inj. No. problems with process.
 | 10:00 A.M. Intraday 1: |  |  |  | TMS access granted about 11:32 a.m.
 | Gas Day: | SAT |  |  | No difficulties with this process.
 | 5:00 P.M. Intraday 2:
 | Gas Day: | SUN |  |  | No difficulties with this process.
 | 11:30 A.M. Timely
 | Gas Day: | SUN |  |  | No difficulties with this process.
 | 6:00 P.M. Evening
 | Other Comments: |  | 6:25 a.m. | Access to TMS Hottap denied.  Notified help desk and went thru RAS
 |  |  |  | until approx 11:32 a.m.   Problem identified as reset permissions on
 |  |  |  | applications [NAME] per Justin/Steve.  Shippers not affected by problem.
 | On Call Reps. |  |  | [NAME] |  |  | 6:30 - 3:30
 |  |  |  | [NAME] |  |  | 6:30 - 3:30
 |  |  |  | [NAME] |  |  | 1:00 - 10:00
 |  |  |  | [NAME] |  |  | 1:00 - 10:00
SUNDAY
 | PROCESS |  |  |  | COMMENTS:
 | Gas Day: | SUN |  |  | No difficulties with this  process.
 | 7:00 A.M. Non-grid: |  |  |  | Allocated Storage.
 | Gas Day: | SAT |  |  | No difficulties with this process.
 | 8:00 AM Final Storage
 | Gas Day: | SUN |  |  | After allocations were made and prior to
 | 10:00 A.M. Intraday 1: |  |  |  | finish, TW/Halley POI 60749 appeared for alloc.
 |  |  |  |  | Called help desk ([NAME]) who called ([NAME]).  [NAME]
 |  |  |  |  | indicated it was due to [NAME]. Grp. Alloc.
 |  |  |  |  | Updated & Continued to finalize alloc. |  |  |  | Storage Allocated.
 | Gas Day: | SUN |  |  | No difficulties with this process.
 | 5:00 P.M. Intraday 2:
 | Gas Day: | MON |  |  | No difficulties with this process.
 | 11:30 A.M. Timely
 | Gas Day: | MON |  |  | No difficulties with this process.
 | 6:00 P.M. Evening
 | Other Comments:
 | On Call Reps: |  |  | [NAME] |  |  | 6:30 - 3:30
 |  |  |  | [NAME] |  |  | 6:30 - 3:30
 |  |  |  | [NAME] |  |  | 1:00 - 10:00
 |  |  |  | [NAME] |  |  | 1:00 - 10:00
Spreadsheet: 108314d1305325434-forecasting-and-etc-order1
Sheet: Sheet1

 | month | 1 | 2 | 3 | 4 | 5 | 6 | 7 | 8 | 9 | 10 | 11 | 12
Sales | Year 2006 | 1000 | 1000 | 1500 | 1500 | 1500 | 1500 | 2000 | 2000 | 2000 | 1500 | 1000 | 1000
 | 2007 | 2000 | 200 | 2000 | 2000 | 2500 | 500 | 2500 | 3000 | 3000 | 2000 | 2000 | 500
 | 2008 | 2500 | 2500 | 3000 | 3000 | 3000 | 3000 | 3500 | 4000 | 4000
 | 2009
Question | 1 | Please forcast sales in 10,11,12 of year 2008 and 2009
 | 2 | Please calcualte monthly order quantity for 10,11,12 of year 2008 and 2009
 |  | End of Sept , 2008 inventory is 6000 and we should have 2 month sales quantity as a inventory
 |  | It takes 2 month for production and 1 month for transportation
 |  | Existing orders for July is 2000, August is 1000, September is 3000
 | 3 | There are 5 factories who can supply above items and their evaluation are as follows :
 |  | How can we allocate monthly order to above 5 factoreis from Oct., 2008 - Dec. 2009 ?
 |  |  |  |  |  |  |  | factory | monthly | on time
 |  |  |  |  |  |  |  |  | capacity | shipping
 |  |  |  |  |  |  |  | A | 1500 | 1
 |  |  |  |  |  |  |  | B | 2000 | 1
 |  |  |  |  |  |  |  | C | 2000 | 0.5
 |  |  |  |  |  |  |  | D | 2000 | 0.5
 |  |  |  |  |  |  |  | E | 2000 | 0.2
Spreadsheet: 748950d1632422904-dynamic-column-table-into-dynamic-chart-example-book
Sheet: Sheet1

Service | Total | Customer 1 | Customer 2 | Customer 3
Level 1 service |  | 30 | 30 | 0
invoiced |  | 1 | 1 | 0
expected |  | 2 | 1 | 1
Level 2 service |  | 100 | 150 | 200
invoiced |  | 10 | 15 | 20
expected |  | 30 | 40 | 50
Spreadsheet: 717088d1612469476-help-production-scheduling-network-days-estimated-job-finish-time-formula-task-finish-time-based-on-start-time-and-duration-srk98-
Sheet: Feb 1st 2021

 |  |  |  |  |  | 0.8 |  |  |  |  |  | 09:00:00 | 17:00:00
Order | Batch | PRODUCT | MACHINE | [NAME] | Line speed/min | [NAME]/min | Changeover time | Start Time | Est finishtime |  | Duration (H:MM)
1 | `O420280 | ABC V1 | NJP1500 | 100000 | 1500 |  | 00:00:00 | 2021-02-01 10:30:00
2 | `0420167 | ABC V2 | NJP1500 | 473000 | 1500 |  | 01:00:00
3 | 0420281 | XYZ V1 | AF300 | 42000 | 1500 |  | 00:00:00 | 2021-02-01 10:30:00
4 | 0420282 | [NAME] | AF300 | 216000 | 1500 |  | 07:00:00 | 2021-02-02 10:05:00
Spreadsheet: 69292d1269846725-conditional-if-circular-pattern
Sheet: Sheet1

Date | Duplicates |  |  |  |  |  |  |  |  | Totals
2010-03-01 00:00:00 | 22 | 42 | 43 | 87 | 986 | 1034 | 1109 | 1235 | 22 | 9
2010-03-02 00:00:00 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0
2010-03-03 00:00:00 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0
2010-03-04 00:00:00 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0
2010-03-05 00:00:00 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0
2010-03-06 00:00:00 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0
2010-03-07 00:00:00 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0
2010-03-08 00:00:00 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0
2010-03-09 00:00:00 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0
2010-03-10 00:00:00 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0
 | Row 3 updates from another sheet and changes fairly often. The comparison I need to make is against anoth worksheet. In this example if the date in column A = the date in sheet 2 A2 then copy the numbers from row 3 into the relevant row. As you can see when I do it and drag the formula down of course the date is only valid on one line so it defaults everything else back to 0.
 |  | Conditional formatting is white font.
Spreadsheet: 689869d1596714980-library-users-excel-formula-for-making-a-list-and-count-excel_2020
Sheet: C

Surname Name | count
Spreadsheet: 376308d1423561355-count-group-direfently-if-one-parameter-is-different-tests-ndm
Sheet: Sheet1

Date | Location | Worker | Own/Contractor | Positive (Y/N) | Positive Own | Positive Contractor
2015-01-05 00:00:00 | Back Woods | abc | Own | N
2015-01-05 00:00:00 | Back Woods | abc | Own | N
2015-01-05 00:00:00 | Back Woods | abc | Contractor | N
2015-01-05 00:00:00 | Back Woods | abc | Contractor | Y |  |  |  | Date | Own/Contractor | Positive Own | Positive Contractor | Tests
2015-01-05 00:00:00 | Back Woods | abc | Contractor | N |  |  |  | 2015-01-05 00:00:00
2015-01-05 00:00:00 | Back Woods | abc | Own | N |  |  |  |  | Contractor | 0 | 1 | 3
2015-01-05 00:00:00 | Back Woods | abc | Own | N |  |  |  |  | Own | 2 | 0 | 7
2015-01-05 00:00:00 | Back Woods | abc | Own | Y |  |  |  | 2015-01-06 00:00:00
2015-01-05 00:00:00 | Back Woods | abc | Own | N |  |  |  |  | Contractor | 0 | 1 | 3
2015-01-05 00:00:00 | Back Woods | abc | Own | Y |  |  |  |  | Own | 0 | 0 | 7
2015-01-06 00:00:00 | Back Woods | abc | Own | N |  |  |  | Grand Total |  | 2 | 2 | 20
2015-01-06 00:00:00 | Back Woods | abc | Own | N
2015-01-06 00:00:00 | Back Woods | abc | Contractor | Y
2015-01-06 00:00:00 | Back Woods | abc | Contractor | N
2015-01-06 00:00:00 | Back Woods | abc | Contractor | N
2015-01-06 00:00:00 | Back Woods | abc | Own | N
2015-01-06 00:00:00 | Back Woods | abc | Own | N
2015-01-06 00:00:00 | Back Woods | abc | Own | N
2015-01-06 00:00:00 | Back Woods | abc | Own | N
2015-01-06 00:00:00 | Back Woods | abc | Own | N
Spreadsheet: 702797d1604540377-sum-formula-to-match-text-in-row-header-and-column-and-sum-matching-criterion-sum-match
Sheet: Form

 | 2023000138
 | 110018401 |  | NA Balance | PA Balance | [NAME] | CABalance | UP Balance | UD Balance | IVBalance | MEDI Balance | Debt Code | Debt Type Desc
 |  |  |  |  |  | CHILD SUPPORT
 |  |  |  |  |  | BENCH WARRANT/COURT COST |  | 500
 |  |  |  |  |  | GENETIC TEST
 |  |  |  |  |  | MEDICAL SUPPORT - MEDICAID
Spreadsheet: 205120d1357744997-filter-for-keywords-exemple
Sheet: Feuil1

Date | Title | KW1 | KW2 | KW3 | KW4
1802 | Référence 1 | histoire | traduction | XIX | espagnol
1841 | Référence 2 | traduction | italien | XIX | x
1802 | Référence 3 | histoire | italien | XIX | traduction
1828 | Référence 4 | histoire | traduction | XIX | y
1809 | Référence 5 | traduction | notes | XIX | y
1844 | Référence 6 | notes | histoire | XIX | y
1853 | Référence 7 | traduction | italien | XIX | z
1894 | Référence 8 | traduction | italien | XIX | z
1900 | Référence 9 | histoire | italien | XIX | x
Spreadsheet: 862856d1710432365-due-date-exercise-due-date-exercise-etaf
Sheet: Sheet1

 |  |  |  |  |  | DEADLINE (DAYS)
 |  |  |  |  |  | 30
 |  | Doc. No. | Title | Submitted Date | Review Status | DUE STATUS
 |  | NCR-C-0335 | Work Procedure for Corrective action | 2024-02-01 00:00:00 | PENDING
 |  | JFGP-HD-MNF-002 | [NAME] | 2024-03-10 00:00:00 | PENDING
 |  | JUS&ICS-ME-PD-7709 | Procedure for Gasket Installation and Bolt Tightening_AIC | 2024-01-20 00:00:00 | FOR INFORMATION
 |  | MME-J-623 | Request for Approval of Test Manifold (Valve) | 2024-02-12 00:00:00 | APPROVED
 |  | JUS&ICS-PM-PD-6031 | Construction NDT and PWHT Matrix per Line Class | 2024-03-01 00:00:00 | REJECTED
 |  |  |  | EXPECTED OUTPUT
 |  | Doc. No. | Title | Submitted Date | Review Status | DUE STATUS
 |  | NCR-C-0335 | Work Procedure for Corrective action | 2024-02-01 00:00:00 | PENDING | DUE
 |  | JFGP-HD-MNF-002 | [NAME] | 2024-03-10 00:00:00 | PENDING | NOT DUE
 |  | JUS&ICS-ME-PD-7709 | Procedure for Gasket Installation and Bolt Tightening_AIC | 2024-01-20 00:00:00 | FOR INFORMATION | DUE
 |  | MME-J-623 | Request for Approval of Test Manifold (Valve) | 2024-02-12 00:00:00 | APPROVED | NOT DUE
 |  | JUS&ICS-PM-PD-6031 | Construction NDT and PWHT Matrix per Line Class | 2024-03-01 00:00:00 | REJECTED | NOT DUE
1. Please, I need a formula / function that will help me identify on my document register of which document or documents review status was already in 30 days from the submitted date up to the current date (as per the setting of days in G2 cell, for me to easily toggle or change whatever days needed)
2. "DUE" will be the output for the document in which the review status was "PENDING" or "FOR INFORMATION" with reference to the submitted date to the today date
3. If possible please include in the formula the cell G2 for me to toggle or change to any date the deadline
Spreadsheet: 485796d1477072919-change-cell-colour-when-values-entered-in-separate-cells-test2
Sheet: Sheet2

STANDBY & TOIL HOURS LOG
16 DAY MONTH RECORD
 |  |  |  |  | Index!A1
Index
16 DAY MONTH
STAFF REQUIRED TO WORK 2 X 16 DAY MONTHS PER YEAR EXCLUDING FEBRUARY
NAME |  |  | YEAR
 |  |  | 2017 |  | 2018
[NAME] |  |  | January | January
[NAME]
[NAME]
DAN GLORIOSO
[NAME]
[NAME] TIMBERLAKE
LOUIS BROWN
KELLY WIGGIN
[NAME]
[NAME]
RICHARD BALL
[NAME]
Spreadsheet: b359f87d-be04-44c7-8c0a-dc19869f5115
Sheet: Sheet1

Test Referenced | Entry Type | Mayo ID | Description | Reporting Description | Method | Collection Container | Temperature | Stability | [NAME] | Unit of Measure | [NAME] | Minimum Volume | Reject Due To | Reference Values | Days/Times Performed | Analytic Time | Maximum Lab Time | CPT Units | CPT Code | LOINC® Code | LOINC® Attributes | Always Performed | Orderable Separately | Performing Location
FBBLE | Test | FBBLE | [NAME] (Sea [NAME]) (Centropristis striata) IgE | [NAME] | Radioimmunoassay (RIA) | Plain, Red-Top Tube: Red |  |  | 0.5 | mL | Draw blood in a plain red top tube(s), serum gel tube(s) is acceptable. Spin down and send 0.5 mL of serum refrigerated in a plastic vial. | 0.5 mL | Hemolysis	NA Thawing	Cold OK; Warm reject Lipemia	Mild OK; Gross reject Icterus	NA Other	NA | <[NAME]/L   Test Performed by: Viracor-IBT Laboratories                              1001 NW Technology Dr                              Lee's Summit, MO 64086 | Monday through Friday | 2 - 3 days | 4 - 7 days | 1 | 86003 |  |  |  |  | Viracor-IBT Laboratories
FBBLE | [NAME] | SERUM | Serum |  |  |  | Refrigerated | 28 days
FBBLE | Result | Z3076 | [NAME] | [NAME] | Alphanumeric |  |  |  |  |  |  |  |  |  |  |  |  |  |  | In Process
FBBLE | Result | Z3077 | Class | Class | Alphanumeric |  |  |  |  |  |  |  |  |  |  |  |  |  |  | In Process
Spreadsheet: 58351d1258626396-an-array-formula-to-lookup-two-values-and-produce-a-total-score-examplebook
Sheet: Sheet1

 |  | Score | Group1 | Group2 | Group3
Smith | [NAME] |  | Head | Director |  |  | Score should be (2*3) + (4*5) + (6*0) = 26
Jones | [NAME] |  |  | Member |  |  | (4*1) = 4
[NAME] | Mark |  |  |  | Director |  | (6*5) = 30
Group1 | 2
Group2 | 4
Group3 | 6
Director | 5
Head | 3
Member | 1
Spreadsheet: 685285d1593879942-fill-blanks-from-other-tabs-holiday-chart
Sheet: December

Name | Site |  |  | 2021-12-01 00:00:00 | 2021-12-02 00:00:00 | 2021-12-03 00:00:00 | 2021-12-04 00:00:00 | 2021-12-05 00:00:00 | 2021-12-06 00:00:00 | 2021-12-07 00:00:00 | 2021-12-08 00:00:00 | 2021-12-09 00:00:00 | 2021-12-10 00:00:00 | 2021-12-11 00:00:00 | 2021-12-12 00:00:00 | 2021-12-13 00:00:00 | 2021-12-14 00:00:00 | 2021-12-15 00:00:00 | 2021-12-16 00:00:00 | 2021-12-17 00:00:00 | 2021-12-18 00:00:00 | 2021-12-19 00:00:00 | 2021-12-20 00:00:00 | 2021-12-21 00:00:00 | 2021-12-22 00:00:00 | 2021-12-23 00:00:00 | 2021-12-24 00:00:00 | 2021-12-25 00:00:00 | 2021-12-26 00:00:00 | 2021-12-27 00:00:00 | 2021-12-28 00:00:00 | 2021-12-29 00:00:00 | 2021-12-30 00:00:00 | 2021-12-31 00:00:00 | Total holidays | Total sick days | Total training days | Total days in lieu | Total weekend working
A Sample | [NAME]
B
C
D
E
F
G
H
I