tianzl66/Sheetpedia huggingface dataset:
Spreadsheet: 786212d1657039998-auto-spill-rearranged-data-across-range-sampletb2
Sheet: Table 1

CODE | PLATE | TEXT | NUM1 | NUM2 | NUM3 | NUM4 | NUM5 | ENTRY GATE | EXIT GATE
11126 | EVF703 | fada | 44 | 75 | 11 | 99 | 89 | SAMANDIRA | SULTANBEYLİ |  |  | EVF703 | fada | 44 | 75 | 11 | 99 | 89 | SAMANDIRA | SULTANBEYLİ
11126 | EVF703 | dad | 76 | 100 | 59 | 38 | 51 | OVAAKÇA | KÖPRÜ GİRİŞ VE ÇIKIŞ |  | 11126 | EVF703 | dad | 76 | 100 | 59 | 38 | 51 | OVAAKÇA | KÖPRÜ GİRİŞ VE ÇIKIŞ GİŞELERİ
 |  |  |  |  |  |  |  |  | GİŞELERİ |  | 11185 | EVF697 | sd | 72 | 66 | 80 | 40 | 65 | EDİRNE | ÇORLU
11185 | EVF697 | sd | 72 | 66 | 80 | 40 | 65 | EDİRNE | ÇORLU |  | 11185 CODE | EVF697 PLATE | sds TEXT | 62 NUM1 | 64 NUM2 | 26 NUM3 | 38 NUM4 | 38 NUM5 | SARAY ENTRY GATE | EDİRNE EXIT GATE
11185 | EVF697 | sds | 62 | 64 | 26 | 38 | 38 | SARAY | EDİRNE |  | 11153 | FJD609 | sdd | 29 | 39 | 43 | 90 | 68 | ODAYERİ | MECİDİYE
CODE | PLATE | TEXT | NUM1 | NUM2 | NUM3 | NUM4 | NUM5 | ENTRY GATE | EXIT GATE |  | 11153 | FJD609 | qwe | 5 | 22 | 48 | 52 | 87 | MECİDİYE | KURTKÖY
11153 | FJD609 | sdd | 29 | 39 | 43 | 90 | 68 | ODAYERİ | MECİDİYE |  | 11153 | FJD609 | sfff | 43 | 3 | 5 | 18 | 45 |  | 15 TEMMUZ ŞEHİTLER KÖPRÜSÜ KUZEY
11153 | FJD609 | qwe | 5 | 22 | 48 | 52 | 87 | MECİDİYE | KURTKÖY |  | 11141 | FJD490 | safss | 87 | 74 | 86 | 18 | 85 |  | FSM KÖPRÜSÜ KUZEY
11153 | FJD609 | sfff | 43 | 3 | 5 | 18 | 45 |  | 15 TEMMUZ ŞEHİTLER |  | 11141 | FJD490 | sffgg | 96 | 6 | 21 | 79 | 76
 |  |  |  |  |  |  |  |  | KÖPRÜSÜ KUZEY |  | 11166 | FJD739 | hdfs | 25 | 40 | 42 | 77 | 81 | KÖPRÜ GİRİŞ VE ÇIKIŞ GİŞELERİ | ALTINOVA
11141 | FJD490 | safss | 87 | 74 | 86 | 18 | 85 |  | FSM KÖPRÜSÜ KUZEY |  | 11166 | FJD739 | fgs | 26 | 41 | 88 | 7 | 48 | KÖPRÜ GİRİŞ VE ÇIKIŞ GİŞELERİ | ALTINOVA
11141 | FJD490 | sffgg | 96 | 6 | 21 | 79 | 76
11166 | FJD739 | hdfs | 25 | 40 | 42 | 77 | 81 | KÖPRÜ GİRİŞ VE ÇIKIŞ | ALTINOVA
 |  |  |  |  |  |  |  | GİŞELERİ
11166 | FJD739 | fgs | 26 | 41 | 88 | 7 | 48 | KÖPRÜ GİRİŞ VE ÇIKIŞ | ALTINOVA |  |  | EVF703 | fada | 44 | 75 | 11 | 99 | 89 | SAMANDIRA | SULTANBEYLİ
 |  |  |  |  |  |  |  | GİŞELERİ |  |  | 11126 | EVF703 | dad | 76 | 100 | 59 | 38 | 51 | OVAAKÇA | KÖPRÜ GİRİŞ VE ÇIKIŞ GİŞELERİ
 |  |  |  |  |  |  |  |  |  |  | 11185 | EVF697 | sd | 72 | 66 | 80 | 40 | 65 | EDİRNE | ÇORLU
 |  |  |  |  |  |  |  |  |  |  | 11185 | EVF697 | sds | 62 | 64 | 26 | 38 | 38 | SARAY | EDİRNE
 |  |  |  |  |  |  |  |  |  |  | 11153 | FJD609 | sdd | 29 | 39 | 43 | 90 | 68 | ODAYERİ | MECİDİYE
 |  |  |  |  |  |  |  |  |  |  | 11153 | FJD609 | qwe | 5 | 22 | 48 | 52 | 87 | MECİDİYE | KURTKÖY
 |  |  |  |  |  |  |  |  |  |  | 11153 | FJD609 | sfff | 43 | 3 | 5 | 18 | 45 |  | 15 TEMMUZ ŞEHİTLER KÖPRÜSÜ KUZEY
 |  |  |  |  |  |  |  |  |  |  | 11141 | FJD490 | safss | 87 | 74 | 86 | 18 | 85 |  | FSM KÖPRÜSÜ KUZEY
 |  |  |  |  |  |  |  |  |  |  | 11141 | FJD490 | sffgg | 96 | 6 | 21 | 79 | 76
 |  |  |  |  |  |  |  |  |  |  | 11166 | FJD739 | hdfs | 25 | 40 | 42 | 77 | 81 | KÖPRÜ GİRİŞ VE ÇIKIŞ GİŞELERİ | ALTINOVA
 |  |  |  |  |  |  |  |  |  |  | 11166 | FJD739 | fgs | 26 | 41 | 88 | 7 | 48 | KÖPRÜ GİRİŞ VE ÇIKIŞ GİŞELERİ | ALTINOVA
Spreadsheet: 754837d1636541037-help-with-conditional-formatting-and-time-value-template
Sheet: Mon, 01 Nov - _All times are UK

[All times are UK local - Local Time @ Target is UTC +2]
 |  |  |  |  |  | Criteria | Count
 |  |  |  |  |  | Wildlife
 |  |  |  |  |  | Cyclist
 |  |  |  |  |  | Walkers
 |  |  |  |  |  | Runners
 |  |  |  |  |  | Unknown
 |  |  |  |  |  | Other
Date | Time (Raw) | Time | Time UTC +2 | Country | Site | Location | Camera # | Weather | Day/Night | Alarm Type | Total Events | Car | Type | IN/OUT | Description | Action | Check
 |  | 01:02:03 |  |  |  |  |  |  |  |  |  |  |  |  | Check All Detectors
 |  | 03:05:07 |  |  |  |  |  |  |  |  |  |  | Movement |  | Vines
 |  | 2021-11-01 04:17:58 |  |  |  |  |  |  |  |  |  |  | Vehicle |  | Stop & Go
 |  | 2021-11-01 04:51:41 |  |  |  |  |  |  |  |  |  |  | Wildlife |  | Boar
 |  | 2021-11-01 05:49:51 |  |  |  |  |  |  |  |  |  |  |  |  | Cyclist
 |  | 2021-11-01 05:54:47 |  |  |  |  |  |  |  |  |  |  | Vehicle |  | Vehicle - Staff
 |  | 2021-11-01 05:58:18 |  |  |  |  |  |  |  |  |  |  | Wildlife |  | Fox
 |  | 2021-11-01 07:20:03 |  |  |  |  |  |  |  |  |  |  | Movement |  | Estate Staff
 |  | 2021-11-01 08:53:48 |  |  |  |  |  |  |  |  |  |  |  |  | Cyclist
 |  | 2021-11-01 08:53:50 |  |  |  |  |  |  |  |  |  |  |  |  | Runners
 |  | 2021-11-01 10:00:00 |  |  |  |  |  |  |  |  |  |  |  |  | Walkers
 |  | 2021-11-01 10:06:13 |  |  |  |  |  |  |  |  |  |  | Vehicle |  | Stop & Go
 |  | 2021-11-01 11:00:00 |  |  |  |  |  |  |  |  |  |  |  |  | Cyclist
 |  | 2021-11-01 11:10:46 |  |  |  |  |  |  |  |  |  |  | Wildlife |  | Deer
 |  | 2021-11-01 12:00:00 |  |  |  |  |  |  |  |  |  |  |  |  | Check All Detectors
 |  | 2021-11-01 12:02:35 |  |  |  |  |  |  |  |  |  |  | Vehicle |  | Vehicle - Other
 |  | 2021-11-01 13:17:30 |  |  |  |  |  |  |  |  |  |  |  |  | Walkers
 |  | 2021-11-01 15:43:20 |  |  |  |  |  |  |  |  |  |  | Vehicle |  | Stop & Go
 |  | 2021-11-01 17:16:30 |  |  |  |  |  |  |  |  |  |  | Vehicle |  | Stop & Go
 |  | 2021-11-01 17:18:37 |  |  |  |  |  |  |  |  |  |  | Wildlife |  | Deer
 |  | 2021-11-01 18:00:51 |  |  |  |  |  |  |  |  |  |  |  |  | Runners
 |  | 2021-11-01 18:05:08 |  |  |  |  |  |  |  |  |  |  |  |  | Walkers
 |  | 2021-11-01 19:16:54 |  |  |  |  |  |  |  |  |  |  | Wildlife |  | Fox
 |  | 2021-11-01 19:31:42 |  |  |  |  |  |  |  |  |  |  | Wildlife |  | Fox
 |  | 2021-11-01 19:58:57 |  |  |  |  |  |  |  |  |  |  | Vehicle |  | Unknown
 |  | 2021-11-06 22:28:34 |  |  |  |  |  |  |  |  |  |  | Wildlife |  | Boar
 |  | 2021-11-06 23:00:00 |  |  |  |  |  |  |  |  |  |  |  |  | Unknown
 |  | 2021-11-06 23:14:16 |  |  |  |  |  |  |  |  |  |  | Vehicle |  | Stop & Go
Spreadsheet: john_forney__15529__s_9-16-01
Sheet: Sheet1

Flow Date |  | Available Off Peak Capacity |  |  |  |  |  |  | Available On Peak Capacity |  |  |  |  |  |  |  |  |  |  |  |  |  |  | Available Off Peak Capacity
2001-09-16 00:00:00
Counterparty |  | 1 | 2 | 3 | 4 | 5 | 6 | 7 | 8 | 9 | 10 | 11 | 12 | 13 | 14 | 15 | 16 | 17 | 18 | 19 | 20 | 21 | 22 | 23 | 24
[NAME] |  |  |  |  |  |  |  |  |  |  |  | -50 | -50 | -50 | -50 | -50 | -50 | -50 | -50 | -50 | -50 | -50 | -50
Enron Call
Mirant Call |  |  |  |  |  |  |  |  |  |  |  | -50 | -50 | -50 | -50 | -50 | -50 | -50 | -50 | -50 | -50 | -50 | -50
CP1 |  |  |  |  |  |  |  |  |  |  |  | 50 | 50 | 50 | 50 | 50 | 50 | 50 | 50 | 50 | 50 | 50 | 50
Total
[NAME]: |  | Deal Details
23.5
Deal_id |  | CP | Volume | Price | Start Hour |  | End Hour
 |  | Mirant Call | -50 |  | 11 |  | 22
775425.1 |  | [NAME] | -50 | 23.5 | 11 |  | 22
775423.1 |  | CP1 | 50 | 23.5 | 11 |  | 22
Spreadsheet: 759057d1639266151-reporting-sum-of-all-sheets-into-a-master-sheet-example
Sheet: Sheet1

Some text/data | Some text/data | Some text/data |  |  |  |  | 2021-01-22 00:00:00
 |  | Date | 2021-12-06 00:00:00
 | Some text/data in this row | [NAME]
 | Some text/data in this row | [NAME]
 | Some text/data in this row | [NAME]
 | Some text/data in this row | [NAME]
 | Some text/data in this row | [NAME]
 | Some text/data in this row | Weekly summary | [NAME] | [NAME] | [NAME] | [NAME] | [NAME] | [NAME] | [NAME] | [NAME] | [NAME]
Protocol | Some text/data in this column | Some text/data in this column | Number of chickens
420065.1 |  |  | 1
420102.1 |  |  |  |  |  |  |  | 5
421012.1 |  |  | 0.25 | 0.5
420076.1 |  |  |  |  |  | 12
420051.1 |  |  | 0.25 | 0.25
421063.1 |  |  |  |  |  |  |  |  | 5
419078.1 |  |  |  | 0.1 | 5 |  |  |  |  | 8
421038.1 |  |  | 0.25
421053.1 |  |  |  |  | 8
420054.1 |  |  |  |  |  |  | 6
420139.1 |  |  |  |  |  |  |  |  | 5
421001.1
421003.1 |  |  |  |  |  |  |  |  |  |  | 5
421068.1 |  |  | 0.5 | 0.5
421082.1 |  |  |  |  |  |  |  | 5
421084.1
421085.1
421023.1 |  |  | 5 |  |  |  | 4
421071.1 |  |  |  | 2 |  | 5 |  |  | 4
420044.1
421096.1 |  |  |  |  |  |  |  |  |  |  | 5
421097.1 |  |  |  |  | 5
421104.1 |  |  |  |  |  |  |  |  | 5
421110.1 |  |  | 0.5 | 1
421105.1 |  |  | 0.5 | 1
621091.1 |  |  |  |  |  |  |  | 1
421117.1 |  |  | 0.25
421118.1 |  |  | 0.25
421126.1
Spreadsheet: 811867d1672844607-advanced-lookup-and-exclusions-230104-excel-help-1
Sheet: Sheet1

Window |  |  |  | CUT | CUT | WINDOW
Tag | MARK |  | [NAME] | WIDTH | HEIGHT | MODEL |  |  | Mark | QTY | [NAME] | Height | Model |  |  |  | QDH
15-1 | A | S | Room 1 | 51.5 | 101.5 | Marchand C.II |  |  | A | 4 | 51.5 | 101.5 | Marchand C.II |  |  |  | PDH
15-2 | A | S | Room 2 | 51.5 | 101.5 | Marchand C.II |  |  |  |  |  |  |  |  |  |  | PTBRDH
15-3 | B | S | Room 3 | 41.75 | 101.5 | Marchand C.II |  |  |  |  |  |  |  |  |  |  | PTBREGHDH
15-4 | B | S | Room 4 | 41.75 | 101.5 | Marchand C.II |  |  |  |  |  |  |  |  |  |  | DHPIC
15-5 | A | S | Room 5 | 51.5 | 101.5 | Marchand C.II |  |  |  |  |  |  |  |  |  |  | VPL
15-6 | A | S | Room 6 | 51.5 | 101.5 | Marchand C.II |  |  |  |  |  |  |  |  |  |  | VPR |  | Items to exclude from model range
15-7 | C | S | Room 7 | 36 | 72 | QDH |  |  |  |  |  |  |  |  |  |  | HP
15-8 | D | S | Room 8 | 42 | 72 | PDH |  |  |  |  |  |  |  |  |  |  | CPPIC
15-9 | A | S | Room 9 | 51.5 | 101.5 | Marchand C.II |  |  |  |  |  |  |  |  |  |  | VPLE
15-10 | E | S | Room 10 | 48 | 72 | VPR |  |  |  |  |  |  |  |  |  |  | VPRE
15-11 | F | S | Room 11 | 60 | 72 | CPPIC |  |  |  |  |  |  |  |  |  |  | HPE
15-12 | G | S | Room 12 | 38 | 72 | PTBRDH |  |  |  |  |  |  |  |  |  |  | CPPICE
15-13 | A | S | Room 13 | 51.5 | 101.5 | Marchand C.II |  |  |  |  |  |  |  |  |  |  | Choice 1
15-14 | A | S | Room 14 | 51.5 | 101.5 | Marchand C.II |  |  |  |  |  |  |  |  |  |  | Choice 2
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | Choice 3
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | Choice 4
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | Choice 5
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | Choice 6 |  | Items I would like to pull from
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | Choice 7
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | Choice 8
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | Choice 9
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | Choice 10
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | Marchand C.II
Spreadsheet: a54c4bdb-dbc4-4c61-9a3d-97e8bb9b64b5
Sheet: Sheet1

PROG ID | ATHLETE ID | ATHLETE FIRST | ATHLETE LAST | NATIONALITY | START NUMBER | RUN | T1 | BIKE | T2 | RUN.1 | POSITION | TOTAL TIME
6503 | 30687 | [NAME] | Perkins | GBR | 565 | 00:20:43 | 00:01:20 | 00:38:00 | 00:01:20 | 00:08:14 | 1 | 01:09:36
Spreadsheet: 783297d1654710975-filter-instead-of-index-and-small-sample
Sheet: FilteredResult

[NAME] |  | DATE | TIME | COURSE | CLASSROM |  |  |  |  | DATE | TIME | COURSE | CLASSROM
Name1 |  |  | 12:00:00 | Literature | 10A |  |  |  |  |  |  |  | 10A
 |  | 2020-11-05 00:00:00 | 12:00:00 | German | 11B |  |  |  |  |  |  |  | 11B
 |  | 2020-11-11 00:00:00 | 12:00:00 | Chemistry | 10A |  |  |  |  |  |  |  | 10A
 |  | 2020-11-12 00:00:00 | 12:00:00 | English | 10B |  |  |  |  |  |  |  | 10B
 |  | 2020-11-25 00:00:00 | 12:00:00 | Physics | 10A |  |  |  |  |  |  |  | 10A
 |  | 2020-11-26 00:00:00 | 12:00:00 | History | 10B |  |  |  |  |  |  |  | 10B
 |  | 2020-12-02 00:00:00 | 12:00:00 | Geometry | 10C |  |  |  |  |  |  |  | 10C
Spreadsheet: 874a5121-09b6-46d6-b246-0d4744c8cff9
Sheet: Report

Unit | Unit Priority | [NAME] | Objective Id | Objective Name | Objective Priority | Strategic Direction | Impact Type
Environmental Health & Safety | 1 | Attain staffing (Environmental Health & Safety Specialist/Technician) | 1.1 | Attain staffing (Environmental Health & Safety Specialist/Technician) to increase the effectiveness of EH&S policy and procedures in the District and provide a level of service to the SBCCD communities to ensure continued/increased compliance with all local state and federal, environmental health, safety, emergency preparedness and risk regulations. | 2 | None | -- Pick One --
Environmental Health & Safety | 2 | Provide promotional safety resources for the campus/district communities. | 2.1 | Provide promotional safety resources for the campus/district communities. | 3 | None | -- Pick One --
Spreadsheet: 716246d1612119371-holiday-work-schedule-internet-workschedule
Sheet: schedule

 | New Year's Day | [NAME] | Memorial Day | Independence Day | Labor Day | Veterans Day | Thanksgiving | Christmas Day
2015
2016
2017
2018
2019
2020
Highest chance to work next | [NAME]
 | 0 - Sarah
 | [NAME]
 | 2013 - James
 | 2014 - Pete
 | 2016 - Robert
 | 2017 - Mary
 | 2018 - Karen
 | 2019 - Susan
Lowest chance to work next | 2020 - John
Spreadsheet: 47916d1247086539-merge-worksheets-into-one-within-same-workbook-test
Sheet: Sheet2

MPD ITEM NUMBER | MRB ITEM NUMBER | CARD NUMBER | RELATED TASK | TASK | [NAME] BY MPD - CARDTITLE
12-13-01-3A |  | 79-409-02-2 |  | SERVICE | ENGINE 2 OIL LEVEL
12-13-01-3A |  | 79-506-01-1 |  | SERVICE | ENGINE 1 OIL LEVEL
12-13-01-3A |  | 79-506-01-2 |  | SERVICE | ENGINE 2 OIL LEVEL
12-13-02-3A |  | 79-508-01-1 |  | CHECK/INSP | ENGINE 1 STARTER OIL
12-13-02-3A |  | 79-508-01-2 |  | CHECK/INSP | ENGINE 2 STARTER OIL
12-13-02-3A |  | 80-208-01-1 |  | CHECK/INSP | ENGINE 1 STARTER OIL
12-13-02-3A |  | 80-208-01-2 |  | CHECK/INSP | ENGINE 2 STARTER OIL
12-13-02-3A |  | 80-209-01-1 |  | CHECK/INSP | ENGINE 1 STARTER OIL
12-13-02-3A |  | 80-209-01-2 |  | CHECK/INSP | ENGINE 2 STARTER OIL
12-13-02-3A | 80-309 | 80-309-01-1 |  | CHECK/INSP | ENGINE 1 STARTER OIL
12-13-02-3A | 80-309 | 80-309-01-2 |  | CHECK/INSP | ENGINE 2 STARTER OIL
12-13-02-3A |  | 80-310-01-1 |  | CHECK/INSP | ENGINE 1 STARTER OIL
12-13-02-3A |  | 80-310-01-2 |  | CHECK/INSP | ENGINE 2 STARTER OIL
12-13-02-3A |  | 80-311-01-1 |  | CHECK/INSP | ENGINE 1 STARTER OIL
12-13-02-3A |  | 80-311-01-2 |  | CHECK/INSP | ENGINE 2 STARTER OIL
12-13-02-3A |  | 80-312-01-1 |  | CHECK/INSP | ENGINE 1 STARTER OIL
12-13-02-3A |  | 80-312-01-2 |  | CHECK/INSP | ENGINE 2 STARTER OIL
12-13-02-3A | 80-501 | 80-501-01-1 |  | SERVICE | ENGINE 1 STARTER OIL
12-13-02-3A | 80-501 | 80-501-01-2 |  | SERVICE | ENGINE 2 STARTER OIL
12-13-03-3A | 24-001 | 24-001-01-1 |  | SERVICE | ENGINE 1 IDG OIL LEVEL
12-13-03-3A | 24-001 | 24-001-01-2 |  | SERVICE | ENGINE 2 IDG OIL LEVEL
12-13-03-3A | 24-001 | 24-001-09-1 |  | SERVICE | ENGINE 1 IDG OIL LEVEL
12-13-03-3A | 24-001 | 24-001-09-2 |  | SERVICE | ENGINE 2 IDG OIL LEVEL
12-13-03-3A |  | 24-001-11-1 |  | SERVICE | ENGINE 1 IDG OIL LEVEL
12-13-03-3A |  | 24-001-11-2 |  | SERVICE | ENGINE 2 IDG OIL LEVEL
12-13-03-3A |  | 24-015-02-1 |  | SERVICE | ENGINE 1 IDG OIL LEVEL
Spreadsheet: 0a32bd5c-8069-451f-9fac-dad2b9e315a1
Sheet: Sheet1

2010 official [NAME] | Unnamed: 1 | Unnamed: 2
State of North Dakota Results
Precincts Reporting: 505/505 - Total Ballots Cast: 102066
Downloaded at 5/22/2013 11:20:52 PM
 | Carol  Grieve  - NON | write-in  - NON
Park Board Member - NON | 103 | 54
TOTAL | 103 | 54
Write-In | Votes
[NAME] | 2
[NAME] | 2
[NAME] | 20
Jeremiah  Frisinger | 2
[NAME] | 2
Pete  Meyer | 5
[NAME] | 3
TOTAL | 36
 | write-in  - NON
Park Board Member Two Year Unexpired Term - NON | 13
TOTAL | 13
Write-In | Votes
[NAME] | 2
[NAME] | 2
[NAME] | 2
[NAME]  Hilde | 5
TOTAL | 11
Results provided by the Office of North Dakota Secretary of State
Spreadsheet: 108421d1305494687-call-top3-based-on-duplicate-data-and-ranking-info-776034_sophyex-v2
Sheet: Pivot

Row Labels | Sum of Value | Average of Value2
JAP | 2 | 2 |  |  | Top 4 Countries
[NAME] | 2 | 2
USA | 10 | 3.333333333333333 |  |  | 1 | USA | 3.33
[NAME] | 1 | 1 |  |  | 2 | CAN | 5.33
[NAME] | 3 | 3 |  |  | 3 | FRA | 12
[NAME] | 6 | 6 |  |  | 4 | MEX | 19
CAN | 16 | 5.333333333333333
[NAME] | 4 | 4 |  |  | Besides of picking the Bottom4 countries excluding the ones with less than 3 persons, it would be ideal if the Top 4 countries table above can be automatically populated based on the pivot
[NAME] | 5 | 5
[NAME] | 7 | 7
ITA | 10 | 10
[NAME] | 10 | 10
FRA | 36 | 12
[NAME] | 11 | 11
[NAME] | 12 | 12
[NAME] | 13 | 13
MEX | 57 | 19
[NAME] | 18 | 18
[NAME] | 19 | 19
[NAME] | 20 | 20
SPA | 47 | 23.5
[NAME] | 23 | 23
[NAME] | 24 | 24
Grand Total | 178 | 11.125
Spreadsheet: 753474d1635457302-spill-range-across-rows-and-columns-spillrangerowsandcolumns
Sheet: Sheet1

 |  | 2021-02-01 00:00:00 | 2021-03-01 00:00:00 | 2021-04-01 00:00:00 | 2021-05-01 00:00:00 | 2021-06-01 00:00:00 | 2021-07-01 00:00:00 | 2021-08-01 00:00:00 | 2021-09-01 00:00:00 | 2021-10-01 00:00:00 | 2021-11-01 00:00:00 | 2021-12-01 00:00:00
 |  |  |  |  |  |  |  | 1
2021-05-01 00:00:00 |  |  |  |  | 1
2021-06-01 00:00:00 |  |  |  |  |  | 1
2021-05-01 00:00:00 |  |  |  |  | 1
2021-02-01 00:00:00 |  | 1
2021-04-01 00:00:00 |  |  |  | 1
2021-03-01 00:00:00 |  |  | 1
2021-07-01 00:00:00 |  |  |  |  |  |  | 1
Spreadsheet: 220410d1363149212-creating-daily-report-report
Sheet: Daily Report

Sales Report |  | Store Name |  |  | Date:
 |  |  |  | Month Ending |  | End of Month Date
Department |  | Today Sales |  |  | MTD Sales
Grocery |  |  | Checks |  | Grocery
Drinks |  |  | Credit Cards |  | Drinks
Cig |  |  | Charges |  | Cig
Carton |  |  | Coupon |  | Carton
Tobbacco |  |  | Cash Pay Out |  | Tobbacco
Misc |  |  | Cash on Hand |  | Misc
Total Sales |  |  | Total |  | Total Sales
Tax-1 Amount |  |  | Diff -/+ |  | Tax-1
Tax-2 Amount |  |  |  |  | tax -2
Net Sales |  |  | Check Pay Out |  | Net Sales
 |  |  |  |  | Credit Cards
Previous Balance |  |  |  |  | Chargers
Present Balance |  |  |  |  | Coupon
[NAME] |  |  |  |  | Cash Pay Out
Deposit Balance |  |  |  |  | Check Pay Out
TotalBalance
Spreadsheet: 111129d1307595029-drop-down-box-for-months-test-bvj
Sheet: Sheet2

locations
1
2
3 |  |  |  | 3
4
5
3 |  | Names | Rating
7 |  | Harold | 75
8 |  | [NAME] | 94
9
10
11
12
13
14
15
 |  |  |  |  | 1. copy your locations to a COLUMN on a different sheet, name the column: locationlist
 |  |  |  |  | 2.  format your dropdown using locationlist as the input range.  Select some cell as the linked cell
 |  |  |  |  | 3.  select the names on sheet1 and name the range "namelist" or something and use that name as the source for the data validation
 |  |  |  |  | 4.  create a HLOOKUP formula: =IF(C8<>"",HLOOKUP(locationPicker,Sheet1!$B$1:$P$51,MATCH(Sheet2!C8,Sheet1!$A$2:$A$51,0),FALSE),"")
 |  |  |  |  | in cell C8 and copy down
Spreadsheet: 677717d1589482579-need-formula-to-extract-values-from-the-data-sample
Sheet: Rough

 |  |  |  |  |  |  |  |  | INDEX
1 | Jan | 1 | 1969 |  |  | 1 |  | 1 | 42045
2 | Feb | 2 | 1970 |  |  | 2 |  | 2 | 42081
3 | Mar | 3 | 1971 |  |  | 3 |  | 3 | 42083
4 | Apr | 4 | 1972 |  |  | 4 |  | 4 | 42101
5 | May | 5 | 1973 |  |  | 5 |  | 5 | 42103
6 | Jun | 6 | 1974 |  |  | 6 |  | 6 | 42111
7 | Jul | 7 | 1975 |  |  | 7 |  | 7 | 42123
8 | Aug | 8 | 1976 |  |  | 8 |  | 8 | 42131
9 | Sep | 9 | 1977 |  |  | 9 |  | 9 | 42137
10 | Oct | 10 | 1978 |  |  | 10 |  | 10 | 42147
11 | Nov | 11 | 1979 |  |  | 11 |  | 11 | 42165
12 | Dec | 12 | 1980 |  |  | 12 |  | 12 | 42170
 |  | 13 | 1981 |  |  | 13 |  | 13 | 42182
 |  | 14 | 1982 |  |  | 14 |  | 14 | 42189
 |  | 15 | 1983 |  |  | 15 |  | 15 | 42220
 |  | 16 | 1984 |  |  | 16 |  | 16 | 42242
 |  | 17 | 1985 |  |  | 17 |  | 17 | 42273
 |  | 18 | 1986 |  |  | 18 |  | 18 | 42299
 |  | 19 | 1987 |  |  | 19 |  | 19 | 42309
 |  | 20 | 1988 |  |  | 20 |  | 20 | 42314
 |  | 21 | 1989 |  |  | 21 |  | 21 | 42339
 |  | 22 | 1990 |  |  | 22 |  | 22 | 42343
 |  | 23 | 1991 |  |  | 23 |  | 23 | 42348
 |  | 24 | 1992 |  |  | 24 |  | 24 | 42361
 |  | 25 | 1993 |  |  | 25 |  | 25 | 42368
 |  | 26 | 1994 |  |  | 26 |  | 26 | 42410
 |  | 27 | 1995 |  |  | 27 |  | 27 | 42435
 |  | 28 | 1996 |  |  | 28 |  | 28 | 42451
 |  | 29 | 1997 |  |  | 29 |  | 29 | 42463
 |  | 30 | 1998 |  |  | 30 |  | 30 | 42479
 |  | 31 | 1999 |  |  | 31 |  | 31 | 42483
 |  | 32 | 2000 |  |  |  |  | 32 | 42492
 |  | 33 | 2001 |  |  |  |  | 33 | 42498
 |  | 34 | 2002 |  |  |  |  | 34 | 42500
 |  | 35 | 2003 |  |  |  |  | 35 | 42503
 |  | 36 | 2004 |  |  |  |  | 36 | 42515
 |  | 37 | 2005 |  |  |  |  | 37 | 42516
 |  | 38 | 2006 |  |  |  |  | 38 | 42539
 |  | 39 | 2007 |  |  |  |  | 39 | 42543
 |  | 40 | 2008 |  |  |  |  | 40 | 42559
 |  | 41 | 2009 |  |  |  |  | 41 | 42571
 |  | 42 | 2010 |  |  |  |  | 42 | 42587
 |  | 43 | 2011 |  |  |  |  | 43 | 42591
 |  | 44 | 2012 |  |  |  |  | 44 | 42618
 |  | 45 | 2013 |  |  |  |  | 45 | 42623
 |  | 46 | 2014 |  |  |  |  | 46 | 42634
 |  | 47 | 2015 |  |  |  |  | 47 | 42647
 |  | 48 | 2016 |  |  |  |  | 48 | 42667
 |  | 49 | 2017 |  |  |  |  | 49 | 42671
 |  | 50 | 2018 |  |  |  |  | 50 | 42675
 |  | 51 | 2019 |  |  |  |  | 51 | 42693
 |  | 52 | 2020 |  |  |  |  | 52 | 42708
 |  |  |  |  |  |  |  | 53 | 42724
 |  |  |  |  |  |  |  | 54 | 42730
 |  |  |  |  |  |  |  | 55 | 42731
 |  |  |  |  |  |  |  | 56 | 42737
 |  |  |  |  |  |  |  | 57 | 42748
 |  |  |  |  |  |  |  | 58 | 42754
 |  |  |  |  |  |  |  | 59 | 42763
 |  |  |  |  |  |  |  | 60 | 42779
 |  |  |  |  |  |  |  | 61 | 42807
 |  |  |  |  |  |  |  | 62 | 42809
 |  |  |  |  |  |  |  | 63 | 42830
 |  |  |  |  |  |  |  | 64 | 42838
 |  |  |  |  |  |  |  | 65 | 42891
 |  |  |  |  |  |  |  | 66 | 42909
 |  |  |  |  |  |  |  | 67 | 42933
 |  |  |  |  |  |  |  | 68 | 42934
 |  |  |  |  |  |  |  | 69 | 42971
 |  |  |  |  |  |  |  | 70 | 42973
 |  |  |  |  |  |  |  | 71 | 42976
Spreadsheet: 142517d1329882731-excel-2007-consolidating-different-values-under-different-names-indifferent-tabs-to-master-sheet-varification-doc
Sheet: QBIA

QBIA |  |  |  |  |  |  |  | PHQ-ITO |  |  |  | PHQ-ITO |  |  |  | PHQ-ITO |  |  |  | PHQ-ITO |  |  |  | PHQ-ITO |  |  |  | PHQ-ITO |  |  |  | PHQ-ITO |  |  |  | PHQ-ITO |  |  |  | PHQ-ITO |  |  |  | PHQ-ITO |  |  |  | PHQ-ITO |  |  |  | PHQ-ITO |  |  |  | PHQ-ITO |  |  |  | PHQ-ITO |  |  |  | PHQ-ITO |  |  |  | PHQ-ITO |  |  |  | PHQ-ITO |  |  |  | PHQ-ITO |  |  |  | PHQ-ITO |  |  |  | PHQ-ITO |  |  |  | PHQ-ITO |  |  |  | PHQ-ITO |  |  |  | PHQ-ITO |  |  |  | PHQ-ITO |  |  |  | PHQ-ITO |  |  |  | PHQ-ITO |  |  |  | PHQ-ITO |  |  |  | PHQ-ITO |  |  |  | PHQ-ITO |  |  |  | PHQ-ITO |  |  |  | PHQ-ITO |  |  |  | PHQ-ITO |  |  |  | PHQ-ITO |  |  |  | PHQ-ITO |  |  |  | PHQ-ITO |  |  |  | PHQ-ITO |  |  |  | PHQ-ITO |  |  |  | PHQ-ITO |  |  |  | PHQ-ITO |  |  |  | PHQ-ITO |  |  |  | PHQ-ITO |  |  |  | PHQ-ITO |  |  |  | PHQ-ITO |  |  |  | PHQ-ITO |  |  |  | PHQ-ITO |  |  |  | PHQ-ITO |  |  |  | PHQ-ITO |  |  |  | PHQ-ITO |  |  |  | PHQ-ITO |  |  |  | PHQ-ITO |  |  |  | PHQ-ITO |  |  |  | PHQ-ITO |  |  |  | PHQ-ITO |  |  |  | PHQ-ITO |  |  |  | PHQ-ITO |  |  |  | PHQ-ITO |  |  |  | PHQ-ITO |  |  |  | PHQ-ITO |  |  |  | PHQ-ITO |  |  |  | PHQ-ITO |  |  |  | PHQ-ITO |  |  |  | PHQ-ITO
SNO | Part Code | Description | Qty | Qty (As on Date 16th Jan-2012)
Section-V,  Part A, SNO-3, 5 | PE-SV Router, PE-SDN Router |  | 1
Existing Material Redeployment
A | Power System
 | 200 AH Battery |  | 2
Spreadsheet: 773060d1647601248-how-to-have-variable-input-baked-into-a-formula-book5
Sheet: Sheet1

 | 'Input' | 0.95
 | calculations table
 | calc 1
 | calc 2
 | calc 3
 | Output'
 |  | Input | Output
 | A | 0.9 | ?? | The output would be whatever cell C11 in the table if assumed the input was C17 and then C18 for the row below etc
 | B | 0.65
 | C | 0.7
 | D | 0.8
 | E | 0.22
 | F | 0.45
 | G | 0.81
 | etc