tianzl66/Sheetpedia huggingface dataset:
Spreadsheet: 756899d1637859395-corkscrew-array-corkscrew-array-amended
Sheet: Sheet1

 |  |  |  | EXAMPLE 1 |  |  |  |  |  |  | EXAMPLE 2
 |  |  |  | SOURCE |  |  |  |  |  |  | SOURCE
 |  |  | 1 | 0 | 9 | 11 | 25 | 0 |  | 1 | 0 | 22 | 11 | 3 | 0
 |  |  | 2 | 0 | 22 | 20 | 0 | 0 |  | 2 | 14 | 12 | 23 | 3 | 0
 |  |  | 3 | 0 | 11 | 16 | 0 | 0 |  | 3 | 21 | 19 | 24 | 0 | 0
 |  |  | 4 | 8 | 16 | 10 | 0 | 0 |  | 4 | 9 | 17 | 14 | 0 | 0
 |  |  | 5 | 0 | 0 | 0 | 0 | 0 |  | 5 | 6 | 4 | 1 | 0 | 0
 |  |  | 6 | 0 | 0 | 0 | 0 | 0 |  | 6 | 23 | 24 | 21 | 0 | 0
 |  |  | 7 | 0 | 0 | 0 | 0 | 0 |  | 7 | 0 | 0 | 0 | 0 | 0
 |  |  | 8 | 0 | 0 | 0 | 0 | 0 |  | 8 | 0 | 0 | 0 | 0 | 0
 |  |  | 9 | 0 | 0 | 0 | 0 | 0 |  | 9 | 0 | 0 | 0 | 0 | 0
 |  |  | 10 | 0 | 0 | 0 | 0 | 0 |  | 10 | 0 | 0 | 0 | 0 | 0
 |  |  | 11 | 0 | 0 | 0 | 0 | 0 |  | 11 | 0 | 0 | 0 | 0 | 0
 |  |  | 12 | 0 | 0 | 0 | 0 | 0 |  | 12 | 0 | 0 | 0 | 0 | 0
 |  |  |  |  |  |  |  |  |  |  | RESULT - SKIP OF 3
 |  |  |  | RESULT - SKIP OF 2
 |  |  | 1 | 0 | 0 | 11 | 16 | 0 |  | 1 | 0 | 9 | 17 | 14 | 0
 |  |  | 2 | 0 | 8 | 16 | 10 | 0 |  | 2 | 0 | 6 | 4 | 1 | 0
 |  |  | 3 | 0 | 9 | 11 | 25 | 0 |  | 3 | 0 | 23 | 24 | 21 | 0
 |  |  | 4 | 0 | 22 | 20 | 0 | 0 |  | 4 | 0 | 22 | 11 | 3 | 0
 |  |  | 5 | 0 | 0 | 0 | 0 | 0 |  | 5 | 14 | 12 | 23 | 3 | 0
 |  |  | 6 | 0 | 0 | 0 | 0 | 0 |  | 6 | 21 | 19 | 24 | 0 | 0
 |  |  | 7 | 0 | 0 | 0 | 0 | 0 |  | 7 | 0 | 0 | 0 | 0 | 0
 |  |  | 8 | 0 | 0 | 0 | 0 | 0 |  | 8 | 0 | 0 | 0 | 0 | 0
 |  |  | 9 | 0 | 0 | 0 | 0 | 0 |  | 9 | 0 | 0 | 0 | 0 | 0
 |  |  | 10 | 0 | 0 | 0 | 0 | 0 |  | 10 | 0 | 0 | 0 | 0 | 0
 |  |  | 11 | 0 | 0 | 0 | 0 | 0 |  | 11 | 0 | 0 | 0 | 0 | 0
 |  |  | 12 | 0 | 0 | 0 | 0 | 0 |  | 12 | 0 | 0 | 0 | 0 | 0
Spreadsheet: 105418d1302780522-any-formular-for-range-choose-example
Sheet: Sheet1

invoice No. | age | branch | NAME |  | age | name
1 | 30 | syd | B |  | 0 | A
2 | 14 | [NAME] | A |  | 16 | B
3 | 12 | adl | A |  | 31 | C
4 | 15 | syd | A
5 | 17 | syd | B
6 | 38 | adl | C
7 | 200 | [NAME] | C
Spreadsheet: hunter_shively__12698__Daily Prices
Sheet: Sheet1

Summary of Central Deals
All Central Deals: 11/21/2001 11:32:35 AM
Product ID | [NAME] | Weighted Average ($/MMBtu) | High Trade ($/MMBtu) | Low Trade ($/MMBtu) | [NAME] (MMBtu/day)
27760 | Consumers Pwr | 2.021923076923077 | 2.07 | 1.96 | 13520
27764 | [NAME] | 2.15790404040404 | 2.2 | 2.1 | 31680
27812 | ANR SE Trans | 1.97 | 1.97 | 1.97 | 26478
27813 | ANR SW Pool | 1.708305618149181 | 1.965 | 1.6 | 130915
27817 | NGPL LA Pool | 1.84797695699264 | 1.99 | 1.7625 | 117259
27818 | NGPL Midcont | 1.72587107940863 | 1.96 | 1.56 | 405296
27822 | NGPL TxOkGCPool | 1.762153846153846 | 2 | 1.65 | 30160
27824 | NNG Demarc | 1.759261581511038 | 1.94 | 1.665 | 337715
27826 | PEPL Pool | 1.673354211402998 | 1.935 | 1.56 | 249145
29490 | OGT | 1.620634422110553 | 2 | 1.55 | 1592
29602 | Dawn | 2.202041353383459 | 2.3 | 2.1 | 133000
29606 | [NAME], TCPL | 2.200191068651411 | 2.22 | 2.15 | 40509
32775 | Trunkline ELA | 1.964777231014763 | 1.97 | 1.56 | 15038
33427 | Trunkline STX | 2.01 | 2.01 | 2.01 | 6264
35041 | NGPL AmarilloML | 1.81508064516129 | 1.87 | 1.68 | 24800
36733 | Iroquois, TCPL | 2.161519986633808 | 2.2 | 2.1 | 23941
47095 | NNG Ventura | 1.793934180876467 | 1.91 | 1.685 | 148665
47186 | Harper | 1.935407409441683 | 1.99 | 1.81 | 36413
47636 | NBPL/Ventura | 1.74995382377127 | 1.78 | 1.695 | 15809
Chicago | Chicago City Gates | 1.894419824030722 | 2.165 | 1.75 | 1513446
Chicago City Gates composed of Peoples, NBPL Nicor, NGPL Nicor, and NIPSCO.
Spreadsheet: 879630d1727200533-dept-and-date-to-auto-calculate-based-on-todays-date-example
Sheet: Injury Trends

 | INJURY BY BODY PART
Hand | 3
Shoulder | 2
Ankle | 4
Arm | 1
Knee | 2
Thigh | 1
Back | 2
Glute | 1
 | INJURY TYPE
Contusion | 2
Sprain/Strain | 13
Laceration | 1
 | Yearly Injury Trend
2022 | 15
2021 | 18
2020 | 12
2019 | 11
2018 | 8
Spreadsheet: 76014135-8e1c-4d57-aac6-5838447ee199
Sheet: Sheet1

First Name | Last Name | Title | Organization | [NAME] | Phone
First Name | Amison | Advisor | Educational Opportunity Center, KU | [EMAIL]
First Name | [NAME] |  | Kansas Leadership Center, Wichita | [EMAIL]
[NAME] | Doll | Superintendent | USD 497 - Lawrence
[NAME] | Beckerman | Strengthening Family Services Director, Economic & Employment Services | Division of Children and Families | [EMAIL]
Shannon | [NAME] | President & CEO | Kansas Action for Children | [EMAIL]
Mildred | Edwards | Executive Director | Kansas African American Affairs Commission | [EMAIL]
Adrienne | [NAME] | Executive Director | Kansas Hispanic & Latino American Affairs Commission | [EMAIL]
[NAME] | Henderson | President | Kansas Association of School Boards | [EMAIL]
[NAME] | Murphy | Director, Policy & Administration Child Care Licensing Bureau of Family Health | Kansas Health & Environment | [EMAIL]
[NAME] | Neuenswander | Interim Commissioner | KSDE,  Learning Services Division | [EMAIL]
[NAME] | Rankin | Executive Director | Midwest Equity Assistance Center, KSU | [EMAIL]
[NAME] | Schodorf | Member | Kansas Senate | [EMAIL]
Idalia | [NAME] | Director, Teaching & Learning | Kansas National Education Association | [EMAIL]
Janice | Smith | Executive Director | Kansas Children's Cabinet and Trust Fund | [EMAIL]
Scott | Smith | Director | KSDE, [NAME], Standards and Assessments | [EMAIL]
Gayle | [NAME] | Coordinator | KSDE, Early Childhood, [NAME] and [NAME]. | [EMAIL]
Spreadsheet: 78409d1278757704-date-files-sample
Sheet: Sheet1

A | 717 | CARRIO | GARRIGUES | DESAMPARADOS | MUJER | 1956-04-02 00:00:00 | 20767796S | 32 | 9 | 13
A | 718 | CASTRO | MOLINA | [NAME] | MUJER | 1960-04-22 00:00:00 | 21441108W | 26 | 10 | 13
A | 719 | COMPAfl | ROSIQUE | ANTONIO FERNANDO | HOMBRE | 1961-03-27 00:00:00 | 21.425.151 F | 22 | 0 | 13
A | 720 | CORDERO | FORT | ALBERTO | HOMBRE | 1977-06-05 00:00:00 | 48344094A | 2 | 10 | 13
A | 721 | CUEVAS | HUERTAS | VICTORIA | MUJER | 1961-12-13 00:00:00 | 21438356X | 26 | 10 | 13
A | 722 | DE LOS SANTOS | TEJERO | MARIA TERESA | MUJER | 1959-05-24 00:00:00 | 30449411X | 27 | 11 | 13
Spreadsheet: 116639d1311962231-designing-a-survey-in-excel-and-vb-questionnaire-on-nat-testing-of-blood-donations
Sheet: 5. HBV

 |  | HBV test results |  |  |  |  | HBV test results | 0
 |  |  |  |  |  |  | Number of donations tested serologically during the indicated year
 |  | HBV test results |  |  |  |  | Donations from first time tested donors**, number | 0
 |  |  |  |  |  |  | Donations from repeat tested donors***, number | 0
 |  | Number of donations tested serologically during the indicated year |  |  |  |  | Number of donations tested by NAT during the indicated year
 |  |  |  |  |  |  | Donations from first time tested donors**, number | 0
 |  | Donations from first time tested donors**, number |  |  |  |  | Donations from repeat tested donors***, number | 0
 |  | Donations from repeat tested donors***, number |  |  |  |  | Number of invalid NAT test results during the indicated year (%) | 0
 |  | Number of donations tested by NAT during the indicated year
 |  | Donations from first time tested donors**, number
 |  | Donations from repeat tested donors***, number
 |  | Number of invalid NAT test results during the indicated year (%)
 |  | **         Donations from first time tested donors: From a person who was tested for the first time
 |  | without report of prior serological testing in the blood establishment.
 |  | ***       Donations from repeat tested donors:
 |  | From a donor who has been subjected to previous serological testing in a given blood establishment.
 |  |  |  | Page 27 of 34
Spreadsheet: 128631d1321121878-want-half-decimal-value-in-cell-sheetremovehalf
Sheet: Answer

Num1 | Num2 | Num3 | Num4 | Num5
 |  |  |  |  |  | <<This sheet is your answer
Spreadsheet: 79015d1279250966-excel-2007-transposing-3-columns-into-multiple-columns-excel-forum-transpose-data
Sheet: Tranpose

 | Subject | Helper |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | Subject
Name | Group | column |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | Group
[NAME], [NAME] | Art&Des |  | B |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | Art&Des
[NAME], [NAME] | CreatArt |  | A |  |  | Art&Des | CreatArt | D&T | English | Geography | History | Hu'ties | ICT | Maths | MFL | PE | Science |  |  | CreatArt
[NAME], [NAME] | D&T |  | A |  | [NAME], [NAME] | B | A | A | A | A* | A | A | A | A* | A | A | A* |  |  | D&T
[NAME], [NAME] | English |  | A |  | Allman, [NAME] | C | B | C | C | C | C | C | C | C | C | B | B |  |  | English
[NAME], [NAME] | Geography |  | A* |  | [NAME],Mary | A | A | A | A | A | A | A | B | C | B | B | B |  |  | Geography
[NAME], [NAME] | History |  | A |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | History
[NAME], [NAME] | Hu'ties |  | A |  |  | Art&Des | CreatArt | D&T | English | Geography | History | Hu'ties | ICT | Maths | MFL | PE | Science |  |  | Hu'ties
[NAME], [NAME] | ICT |  | A |  | [NAME], [NAME] |  |  |  |  |  |  |  |  |  |  |  |  |  |  | ICT
[NAME], [NAME] | Maths |  | A* |  | Allman, [NAME] |  |  |  |  |  |  |  |  |  |  |  |  |  |  | Maths
[NAME], [NAME] | MFL |  | A |  | [NAME],Mary |  |  |  |  |  |  |  |  |  |  |  |  |  |  | MFL
[NAME], [NAME] | PE |  | A |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | PE
[NAME], [NAME] | Science |  | A* |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | Science
Allman, [NAME] | Art&Des |  | C |  |  | Art&Des | CreatArt | D&T | English | Geography | History | Hu'ties | ICT | Maths | MFL | PE | Science
Allman, [NAME] | CreatArt |  | B |  | [NAME], [NAME]
Allman, [NAME] | D&T |  | C |  | Allman, [NAME]
Allman, [NAME] | English |  | C |  | [NAME],Mary
Allman, [NAME] | Geography |  | C
Allman, [NAME] | History |  | C |  | Transposing 3 columns into multiple columns - Excel Help Forum
Allman, [NAME] | Hu'ties |  | C
Allman, [NAME] | ICT |  | C
Allman, [NAME] | Maths |  | C
Allman, [NAME] | MFL |  | C
Allman, [NAME] | PE |  | B
Allman, [NAME] | Science |  | B
[NAME],Mary | Art&Des |  | A
[NAME],Mary | CreatArt |  | A
[NAME],Mary | D&T |  | A
[NAME],Mary | English |  | A
[NAME],Mary | Geography |  | A
[NAME],Mary | History |  | A
[NAME],Mary | Hu'ties |  | A
[NAME],Mary | ICT |  | B
[NAME],Mary | Maths |  | C
[NAME],Mary | MFL |  | B
[NAME],Mary | PE |  | B
[NAME],Mary | Science |  | B
Spreadsheet: 866500d1713432520-a-formula-to-select-the-highest-cell-in-a-column-that-then-shows-the-entire-row-walks
Sheet: 2024

 |  |  |  |  |  |  |  |  | 2024
 |  |  |  |  |  |  |  |  |  | Number   of       Walks | Total   Miles | Total Height  Feet | Total   Hours  Walked | Average Speed   mph
 |  |  |  |  |  |  |  |  | [NAME]
 |  |  |  |  |  |  |  |  | [NAME]
 |  |  |  |  |  |  |  |  | Jake
Spreadsheet: 59721d1260294452-sumproduct-returning-incorrect-value-sample
Sheet: Exec Summary Team View 

 | [NAME] (000's) |  |  |  |  |  |  |  |  |  |  |  |  | F11 (000's) | F10 Total FTE
Run Rate Reduction | ACT | FCST | FCST | FCST | FCST | FCST | FCST | FCST | FCST | FCST | FCST | FCST | Total
Team | 2009-11-01 00:00:00 | 2009-12-01 00:00:00 | 2010-01-01 00:00:00 | 2010-02-01 00:00:00 | 2010-03-01 00:00:00 | 2010-04-01 00:00:00 | 2010-05-01 00:00:00 | 2010-06-01 00:00:00 | 2010-07-01 00:00:00 | 2010-08-01 00:00:00 | 2010-09-01 00:00:00 | 2010-10-01 00:00:00
Client Services | 0 | 0 | 0 | 18.2 | 18.2 | 18.2 | 18.2 | 18.2 | 18.2 | 18.2 | 18.2 | 18.2 | 163.8 | 218.4
Total Target | 0 | 12.5 | 14.5 | 20 | 20 | 20 | 23 | 34.4 | 34.4 | 34.4 | 37.2 | 38.3 | 288.7 |  | 3.4
Net | 0 | -12.5 | -14.5 | -1.800000000000001 | -1.800000000000001 | -1.800000000000001 | -4.800000000000001 | -16.2 | -16.2 | -16.2 | -19 | -20.1 | -124.9
DTO - US | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0
Total Target | 0 | 1.8 | 2.1 | 2.9 | 2.9 | 2.9 | 3.4 | 5.1 | 5.1 | 5.1 | 5.5 | 5.6 | 42.40000000000001 |  | 0.5
Net | 0 | -1.8 | -2.1 | -2.9 | -2.9 | -2.9 | -3.4 | -5.1 | -5.1 | -5.1 | -5.5 | -5.6 | -42.40000000000001
Run Rate Reduction Total | 0 | 0 | 0 | 18.2 | 18.2 | 18.2 | 18.2 | 18.2 | 18.2 | 18.2 | 18.2 | 18.2 | 163.8 | 218.4
 | [NAME] (000's) |  |  |  |  |  |  |  |  |  |  |  |  | F11 (000's) | F10 Total FTE
Capacity Creation | ACT | FCST | FCST | FCST | FCST | FCST | FCST | FCST | FCST | FCST | FCST | FCST | Total
Team | 2009-11-01 00:00:00 | 2009-12-01 00:00:00 | 2010-01-01 00:00:00 | 2010-02-01 00:00:00 | 2010-03-01 00:00:00 | 2010-04-01 00:00:00 | 2010-05-01 00:00:00 | 2010-06-01 00:00:00 | 2010-07-01 00:00:00 | 2010-08-01 00:00:00 | 2010-09-01 00:00:00 | 2010-10-01 00:00:00
Client Services | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0
Total Target | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0
Net | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0
DTO - US | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0
Total Target | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0
Net | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0
Capacity Creation Total | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0
Spreadsheet: 5566003d-db4d-491e-83ec-8e862a27176b
Sheet: Marginal miljøeffekt

Miljøeffekt ved ændring i varmeforbrug
"Fjordbykøbing fjernvarmeværk"
Parameter | Besparelse* | enhed
Kuldioxid CO2
Kvælstofoxider NOx
[NAME]
Metan CH4 |  | kg/MWh
[NAME] N2O
* Et negativt fortegn medfører at en varmebesparelse marginalt set medfører en øget
udledning. Dette forekommer typisk ved, at den afledte elproduktion produceres et
sted, hvor udledningen ved elproduktion er større end [NAME] i det lokale værk.
Spreadsheet: 815253d1674833559-merge-if-statements-for-a-quotation-spreadsheet-quote-sheet
Sheet: US Dollar Exchange Rates Table 

US Dollar | 1.00 USD | inv. 1.00 USD
Euro | 0.92027 | 1.086638
British Pound | 0.808005 | 1.237616
[NAME] | 81.549598 | 0.012262
Australian Dollar | 1.407326 | 0.710568
Canadian Dollar | 1.331423 | 0.751076
Singapore Dollar | 1.314382 | 0.760814
Swiss Franc | 0.922483 | 1.08403
Malaysian Ringgit | 4.244221 | 0.235614
[NAME] | 129.892394 | 0.007699
Chinese Yuan Renminbi | 6.783567 | 0.147415
www.i-rates.com
Spreadsheet: 186719d1350169444-itemlist-orderlist-ef218_orderlist
Sheet: Order

Company
OrderDate
OrderNR
ItemNr | ItemDesc | QtyOrder
Spreadsheet: 750455d1633459002-auto-populate-table-columns-matching-criteria-wip-ef-hr-recruitment-tracker
Sheet: LA

Name | Position | MergedNamePosn | Offer Date | Order | Selection Phase | Orientation Date
[NAME] | Driver |  | 2021-09-25 00:00:00 |  | Offered |  |  |  | https://exceluser.com/706/use-excels-index-match-or-vlookup-functions-to-populate-invoices-and-pos/
[NAME] | Driver |  | 2021-09-25 00:00:00 |  | Offered |  |  |  | https://exceltable.com/en/formulas-ranges/autocomplete-cells-in-table
[NAME] | Driver |  | 2021-09-25 00:00:00 |  | Pending - Background Check
[NAME] | Driver |  | 2021-09-25 00:00:00 |  | Pending - Background Check |  |  |  | [NAME]
[NAME] | Driver |  | 2021-09-25 00:00:00 |  | Scheduled for Orientation
Lorelei Gapinski | Driver |  | 2021-09-25 00:00:00 |  | Hired
Maud Fleck | Driver |  | 2021-09-25 00:00:00 |  | Pending - Background Check
[NAME] | Driver |  | 2021-09-25 00:00:00 |  | Pending - Background Check
[NAME] | Driver |  | 2021-10-02 00:00:00 |  | Pending - Drug Test
[NAME] | Merch |  | 2021-10-02 00:00:00 |  | Pending - Drug Test
Princess Hou | Warehouse |  | 2021-10-02 00:00:00 |  | Failed Pre-Employment Screening
[NAME] | Warehouse |  | 2021-10-02 00:00:00 |  | Pending - Background Check
[NAME] | Warehouse |  | 2021-10-02 00:00:00 |  | Scheduled for Orientation
Syreeta Fain | Warehouse |  | 2021-10-02 00:00:00 |  | Offered
[NAME] | Warehouse |  | 2021-10-02 00:00:00 |  | Scheduled for Orientation
[NAME] | Merch |  | 2021-10-02 00:00:00 |  | Pending - Drug Test
Spreadsheet: 704570d1605626230-formula-to-populate-data-from-a-single-tab-to-other-tabs-and-then-back-to-the-single-tab-sample
Sheet: Tom

Date | Sales order number | Account owner | Order value | Vendor | Expected Month of Delivery | % Probability | Comments
2020-01-17 00:00:00 | [PHONE] | [NAME] | 6208.5 | Hikvision | DEC | [NAME] | Not happening
2020-02-04 00:00:00 | [PHONE] | [NAME] | 5367.5 | Hikvision | DEC | PIPELINE | DELETE
2020-02-10 00:00:00 | [PHONE] | [NAME] | 1835.29 | Hikvision | DEC | [NAME] | See [NAME]
Spreadsheet: 110752d1307374882-pivot-tables-with-new-entries-analyst_outreachlog_template
Sheet: Report

Investor Outreach Report
Count of Contact Method | Contact Method
Quarter | (blank) | Grand Total
(blank)
Grand Total
Count of Last Name | Contact Method
Last Name | [NAME] | In-person Meeting | Phone Call | Grand Total
Betty | 1 |  | 1 | 2
[NAME] |  | 1 | 1 | 2
Grand Total | 1 | 1 | 2 | 4
Spreadsheet: 267357d1380052350-use-selections-from-two-data-validation-lists-to-lookup-and-return-a-mailing-address-state-county-fips-codes
Sheet: ALASKA-50

 | COUNTY | CODE
 | Aleutians East | 13
 | Aleutians West | 16
 | Anchorage | 20
 | Bethel | 50
 | Bristol Bay | 60
 | Denali | 68
 | Dillingham | 70
 | Fairbanks North Star | 90
 | Juneau | 110
 | Kenai Peninsula | 122
 | [NAME] | 130
 | Kodiak Island | 150
 | Lake and Peninsula | 164
 | Matanuska-Susitna | 170
 | Nome | 180
 | North Slope | 185
 | Northwest Arctic | 188
 | Prince of Wales Outer Ketchikan | 201
 | [NAME] | 220
 | [NAME] | 231
 | Southeast Fairbanks | 240
 | [NAME] | 261
 | [NAME] | 270
 | Wrangell Petersburg | 280
 | Yukon-Koyukuk | 290
Spreadsheet: 741398d1627024849-summing-hours-worked-per-date-per-location-example
Sheet: Sheet1

Job Number | Date | Location | Labour Hours |  |  |  | Graph Source Data - Hours worked per day, per location
1 | 2021-07-20 00:00:00 | Melbourne | 5 |  |  |  | Date | Melbourne | Sydney | Tokyo
2 | 2021-07-23 00:00:00 | Sydney | 10 |  |  |  | 2021-07-10 00:00:00
3 | 2021-07-21 00:00:00 | Tokyo | 5 |  |  |  | 2021-07-11 00:00:00
4 | 2021-07-11 00:00:00 | Sydney | 10 |  |  |  | 2021-07-12 00:00:00
5 | 2021-07-14 00:00:00 | Melbourne | 5 |  |  |  | 2021-07-13 00:00:00
6 | 2021-07-17 00:00:00 | Melbourne | 10 |  |  |  | 2021-07-14 00:00:00
7 | 2021-07-22 00:00:00 | Tokyo | 10 |  |  |  | 2021-07-15 00:00:00
8 | 2021-07-19 00:00:00 | Sydney | 10 |  |  |  | 2021-07-16 00:00:00
9 | 2021-07-20 00:00:00 | Sydney | 5 |  |  |  | 2021-07-17 00:00:00
10 | 2021-07-21 00:00:00 | Sydney | 10 |  |  |  | 2021-07-18 00:00:00
11 | 2021-07-23 00:00:00 | Sydney | 5 |  |  |  | 2021-07-19 00:00:00
12 | 2021-07-20 00:00:00 | Sydney | 10 |  |  |  | 2021-07-20 00:00:00
13 | 2021-07-20 00:00:00 | Tokyo | 12 |  |  |  | 2021-07-21 00:00:00
14 | 2021-07-23 00:00:00 | Sydney | 12 |  |  |  | 2021-07-22 00:00:00
15 | 2021-07-21 00:00:00 | Melbourne | 5 |  |  |  | 2021-07-23 00:00:00
16 | 2021-07-11 00:00:00 | Melbourne | 4 |  |  |  | 2021-07-24 00:00:00
17 | 2021-07-14 00:00:00 | Tokyo | 15 |  |  |  | 2021-07-25 00:00:00
18 | 2021-07-17 00:00:00 | Sydney | 6 |  |  |  | 2021-07-26 00:00:00
19 | 2021-07-22 00:00:00 | Melbourne | 4 |  |  |  | 2021-07-27 00:00:00
20 | 2021-07-19 00:00:00 | Melbourne | 1 |  |  |  | 2021-07-28 00:00:00
21 | 2021-07-20 00:00:00 | Sydney | 8 |  |  |  | 2021-07-29 00:00:00
22 | 2021-07-21 00:00:00 | Sydney | 3 |  |  |  | 2021-07-30 00:00:00
23 | 2021-07-23 00:00:00 | Sydney | 3 |  |  |  | 2021-07-31 00:00:00
24 | 2021-07-20 00:00:00 | Paris | 1
25 | 2021-07-23 00:00:00 | Paris | 11
Spreadsheet: 780491d1652472606-how-to-count-empty-cells-empty-cells
Sheet: Computer

Computer |  |  |  |  |  |  |  |  |  | Computer
 |  |  |  |  |  |  |  |  |  | 1 | 2 | 3 | 4 | 5 | 6 | 7 | 8 | 9 | 10 | 11 | 12 | 13 | 14 | 15 | 16 | 17 | 18 | 19 | 20 | 21 | 22 | 23 | 24 | 25 | 26 | 27 | 28 | 29 | 30 | 31 | 32 | 33 | 34 | 35
1 | 8 | 10 | 20 | 22 | 26 | 30
1 | 2 | 10 | 12 | 13 | 22 | 32
1 | 4 | 6 | 7 | 8 | 19 | 32
14 | 18 | 19 | 22 | 23 | 27 | 35
4 | 8 | 10 | 12 | 18 | 21 | 22
4 | 9 | 10 | 14 | 19 | 27 | 34
4 | 14 | 15 | 20 | 21 | 22 | 28
3 | 6 | 8 | 15 | 25 | 27 | 31
2 | 18 | 24 | 30 | 31 | 32 | 34
2 | 6 | 11 | 16 | 27 | 32 | 35
2 | 7 | 20 | 22 | 25 | 27 | 32
1 | 2 | 16 | 17 | 25 | 27 | 29
2 | 7 | 18 | 30 | 31 | 34 | 35
13 | 18 | 22 | 23 | 24 | 26 | 31
5 | 12 | 19 | 25 | 28 | 29 | 35
2 | 4 | 25 | 29 | 30 | 33 | 35
4 | 18 | 19 | 21 | 22 | 26 | 30
4 | 5 | 11 | 15 | 19 | 20 | 32
3 | 10 | 13 | 16 | 17 | 18 | 19
2 | 13 | 19 | 25 | 28 | 29 | 33
9 | 15 | 23 | 25 | 29 | 30 | 32
5 | 8 | 16 | 21 | 23 | 24 | 32
9 | 12 | 19 | 22 | 28 | 31 | 33
3 | 19 | 23 | 25 | 28 | 34 | 35
7 | 11 | 17 | 21 | 23 | 28 | 34
4 | 6 | 9 | 12 | 23 | 25 | 31
4 | 7 | 9 | 10 | 15 | 25 | 27
1 | 7 | 20 | 22 | 27 | 28 | 30
1 | 11 | 16 | 18 | 24 | 26 | 33
Spreadsheet: 3b935453-4f64-4451-9bd0-f84f46bd5df7
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
XHIM | Test | XHIM | X-Linked Hyper IgM Syndrome, Blood | X-Linked Hyper IgM Syndrome, B | Flow Cytometry | Green-Top Tube (Sodium Heparin): GrnNaHp |  |  | 4 | mL | It is recommended that specimens arrive within 24 hours of draw. Specimens are required to be received in the laboratory on weekdays and by 4 p.m. on Friday. No weekend processing. Draw and package specimen as close to shipping time as possible. Ship specimen overnight.   Container/Tube: Green top (sodium heparin) [NAME]: 4 mL Additional Information: 1. Ordering physician's name and phone number are required. 2. For serial monitoring, we recommend that specimen draws be performed at the same time of day. | 1.2 mL | Hemolysis	Mild OK; Gross reject Thawing	NA Lipemia	Mild OK; Gross reject Icterus	NA Other	NA | Present | Monday through Friday  Specimens are required to be received in the laboratory on weekdays and by 4 p.m. on Friday. No weekend processing | 3 days | 4 days |  | Profile |  |  |  |  | Rochester
XHIM | [NAME] | WBNAH | WB Sodium Heparin |  |  |  | Ambient | 72 hours
XHIM | Result | 82964 | CD40 Ligand Expression | CD40 Ligand Expression | Alphanumeric |  |  |  |  |  |  |  |  |  |  |  |  |  |  | In Process
XHIM | Result | 29040 | CD40muIg (Function) | CD40muIg (Function) | Alphanumeric |  |  |  |  |  |  |  |  |  |  |  |  |  |  | In Process
XHIM | Result | 23901 | Interpretation | Interpretation | Alphanumeric |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 69052-9
Spreadsheet: 841689d1693859816-excel-formula-for-producing-student-report-student-progress-report
Sheet: Progress Report

 | Kindly asking for excel formula to produce academic progress report as shown on the desired solution using information on database sheet
 | ACADEMIC PROGRESS REPORT
 | Desired solution
 | Select student I.D on Cell B8
 | BHA234 | Name
 |  | Class
 | END OF SECOND TERM 2023
 | Subject | Class Average (%) | Actual Mark (%) | Grade | Teacher’s Comment | Signature
 |  | 53 | 97 | A | Excellent performance | [NAME]
 | Accounting | 60 | 80 | A | This is good performance. | [NAME]
 | Agriculture | 66 | 49 | D | Work hard | [NAME]
 | Biology | 62 | 90 | A | This is a splendiferous performance | [NAME]
 | B.Studies | 54 | 70 | B | Work hard | A. Mpala
 | English | 66 | 86 | A | A hardworking student | [NAME]
 | Geography | 61 | 93 | A | Good work | A. Mpala
 | FRS | 70 | 98 | A | Excellent work | [NAME]
 | Woodwork | 50 | 80 | A | Best student | [NAME]
 | Number of subjects recorded: |  |  | Passed : | 8
Spreadsheet: darrell_schoolcraft__7531__TW Recap UAF Jan 2002-MMBtu only
Sheet: TW Corrections

 |  |  |  |  | MCF @ 14.73 |  |  | MMBTU @ 14.73 |  | Corr | Corr | Corr | Reason for Correction
Station ID | POI | R/D | Station Name | Original | Corrrected | Difference | Original | Corrected | Difference | Hrs | MM/YY | By | Code and Description
32176 | 8516 | D | OASIS BLOCK 16-DEL | 0 | 31111 |  | 0 | 32620 |  |  | 2002-11-02 00:00:00 | V. METZLER | MNV-O MISSING VOLUME