tianzl66/Sheetpedia huggingface dataset:
Spreadsheet: 161233d1339450742-finding-uniques-sample-vlee-oeldere2-
Sheet: Sheet1

Date | Merchant | filter | Kolom1
2012-01-01 00:00:00 | A | 12
2012-01-01 00:00:00 | A | 12
2012-01-01 00:00:00 | B | 5 |  |  |  | Merchant | A
2012-01-01 00:00:00 | C | 13
2012-01-01 00:00:00 | A | 12 |  |  |  | Rijlabels | Aantal [NAME]
2012-01-01 00:00:00 | C | 13 |  |  |  | 2012-01-01 00:00:00 | 4
2012-01-01 00:00:00 | C | 13 |  |  |  | 2012-01-02 00:00:00 | 3
2012-01-01 00:00:00 | A | 12 |  |  |  | 2012-01-03 00:00:00 | 1
2012-01-01 00:00:00 | C | 13 |  |  |  | 2012-01-04 00:00:00 | 2
2012-01-02 00:00:00 | B | 4 |  |  |  | 2012-01-05 00:00:00 | 2
2012-01-02 00:00:00 | C | 9 |  |  |  | Eindtotaal | 12
2012-01-02 00:00:00 | A | 8
2012-01-02 00:00:00 | A | 8
2012-01-02 00:00:00 | B | 4
2012-01-02 00:00:00 | C | 9
2012-01-02 00:00:00 | A | 8
2012-01-03 00:00:00 | C | 7
2012-01-03 00:00:00 | C | 7
2012-01-03 00:00:00 | A | 5
2012-01-03 00:00:00 | C | 7
2012-01-03 00:00:00 | B | 2
2012-01-03 00:00:00 | C | 7
2012-01-04 00:00:00 | A | 4
2012-01-04 00:00:00 | A | 4
2012-01-05 00:00:00 | B | 1 | Unique
2012-01-05 00:00:00 | C | 3
2012-01-05 00:00:00 | A | 2
2012-01-05 00:00:00 | C | 3
2012-01-05 00:00:00 | C | 3
2012-01-05 00:00:00 | A | 2
Spreadsheet: 7ec3734d-af81-46d6-b581-a195b64bd90e
Sheet: Sheet1

Ingenuity Canonical Pathways | Unnamed: 1 | -Log(P-value) | Ratio | Molecules
EGF Signaling |  | 1.67 | 0.0213 | FOS
Toll-like Receptor Signaling |  | 1.66 | 0.0185 | FOS
IL-2 Signaling |  | 1.62 | 0.0189 | FOS
IL-10 Signaling |  | 1.53 | 0.0141 | FOS
Erythropoietin Signaling |  | 1.5 | 0.0133 | FOS
TRK Signaling |  | 1.5 | 0.0135 | FOS
Spreadsheet: 873242d1719712864-sum-after-excluding-the-total-of-merged-cell-dates-ask630
Sheet: Sheet1

 | 64 | 2024-07-15 00:00:00 |  | MONTH | AMOUNT
 | 28 |  |  | 7 | 154
 | 12 |  |  | 8 | 2418
Total
 | 472 | 2024-08-06 00:00:00
 | 360
Total
 | 288 | 2024-08-08 00:00:00
 | 426
 | 96
Total
 | 144 | 2024-08-25 00:00:00
 | 256
 | 376
Total
 | 50 | 2024-07-30 00:00:00
Spreadsheet: 94143d1294021416-an-array-to-show-only-the-last-10-entries-forum-sample-7
Sheet: MASTER

E |  | 12
E |  | 02
E |  | 14
E |  | 15
E |  | 56
O |  | 78
O |  | 24
O |  | 56
E |  | 89
O |  | 12
O |  | 13
E |  | 10
O |  | 02
O |  | 06
E |  | 08
E |  | 19
E |  | 20
O |  | 30
E |  | 45
O |  | 60
E |  | 07
O |  | 88
E |  | 95
Spreadsheet: 107152d1304364775-excel-2007-paste-current-date-to-a-row-in-a-sheet-service-sample
Sheet: Price List

Price List
Item Number | Item Description | Customer Price | Supplier | Catalog Number | Dealer Price
100 | Labor Rate | 60
101 | Saxophone [NAME] | 280
102 | Clarinet [NAME] | 112
103 | Flute Repad | 115
104 | Saxophone Chem. Bath | 60
105 | Flute Chem. Bath | 40
106 | Saxophone Pad | 12
107 | clarinet [NAME] | 9
108 | Saxophone Neck Cork | 12
109 | Clarinet [NAME] | 9
110
111
112
113
114
115
116
Spreadsheet: 834345d1687712886-creating-another-sheet-from-a-master-excel-forum-planner-26-6-2023
Sheet: Master

Engineer Master Work Planner
Week Commencing |  |  |  |  | 2023-06-26 00:00:00
Name |  |  |  |  |  |  |  |  |  |  |  |  |  | Engine Service |  | S | Other Site Work |  | I
 | [NAME] |  |  |  | On call till Thursday |  |  |  |  |  |  |  |  | Engine Repair |  | D | Daily |  | J
 | [NAME] |  |  |  | Holiday Tuesday &Wednesday |  |  |  |  |  |  |  |  | Other |  | C | Weekly |  | W
 | [NAME] |  |  |  | Holiday Thursday |  |  |  |  |  |  |  |  | Training/Meeting |  | TM | Quarterly |  | Q
 | [NAME] |  |  |  | On call from Friday |  |  |  |  |  |  |  |  | Gas Balance |  | G | GF Maintenance |  | GFM
 | [NAME] |  |  |  |  |  |  |  |  |  |  |  |  | Availability |  | A
 | Joes uncle |  |  |  | Holiday Thursday & Friday
 |  | PS1 |  | PS2 |  | CMP |  | US |  | CS |  | WS |  | ES |  | NS |  | SS
 |  | Power plant 1 |  | Power site 2 |  | Comp site |  | Under stores site |  | Central site |  | West Site |  | East Site |  | North Site |  | South Site
Mon | AM | W | S |  |  | W | TM |  |  | D | D |  |  |  |  |  |  | W | J
 | PM | C | C |  |  | GFM | C |  |  | W | A | W | A |  |  |  |  | G | G
 |  | JB |  |  |  | JM |  |  |  |  |  |  |  |  |  |  |  | AL
[NAME] | AM |  |  |  |  |  |  | W | A | D | D | D | D |  |  | S | S
 | PM |  |  |  |  |  |  |  |  | D | TM | D | TM |  |  | W | TM
 |  |  |  |  |  |  |  | JM | JB
Wed | AM |  |  |  |  | TM | TM |  |  | D | D | TM | TM |  |  | D | D
 | PM |  |  |  |  | C | C |  |  | D | D | C | C |  |  | D | C
 |  |  |  |  |  | JS | JU |  |  | RB
Thurs | AM |  |  | W | J |  |  |  |  |  |  | TM | TM |  |  |  |  | G | G
 | PM |  |  | C | C |  |  |  |  |  |  | TM | TM |  |  |  |  | C | C
Fri | AM |  |  | I | I | TM | I | I | I |  |  | I |  | I | I |  |  | I | I
 | PM |  |  | I | I | I | I |  |  | I | I | I | I |  |  | I | I
 |  |  | Day | site works
 |  |  | Mon | Works to be done gardening and repair pipe work
 |  |  | [NAME]
 |  |  | Wed
 |  |  | Thurs
 |  |  | Fri
Spreadsheet: 734835d1622537311-too-many-arguments-using-nested-ifs-forum-help
Sheet: Holidays

2021-01-01 00:00:00
2021-03-28 00:00:00
2021-04-01 00:00:00
2021-04-02 00:00:00
2021-04-04 00:00:00
2021-04-05 00:00:00
2021-05-01 00:00:00
2021-05-13 00:00:00
2021-05-17 00:00:00
2021-05-23 00:00:00
2021-05-24 00:00:00
2021-12-25 00:00:00
2021-12-26 00:00:00
2022-01-01 00:00:00
2022-04-14 00:00:00
2022-04-15 00:00:00
2022-04-17 00:00:00
2022-04-18 00:00:00
2022-05-01 00:00:00
2022-05-17 00:00:00
2022-05-26 00:00:00
2022-06-05 00:00:00
2022-06-06 00:00:00
2022-12-25 00:00:00
2022-12-26 00:00:00
Spreadsheet: 220486d1363180098-extract-non-zero-value-data-sample
Sheet: MODEL MARY

 |  | Model
 |  | [NAME]
 | Product Code | Unit Price
 | Door x 40 | 100
 | Door x 41 | 110
 | Door x 43 | 95
 | Door x 44 | 81
 | Door x 45 | 95
 | Door x 48 | 112
 | Door x 50 | 83
 | Door x 52 | 110
 | Door x 54 | 112
 | Door x 56 | 95
 | Door x 58 | 102
 | Door x 59 | 100
 | Door x 60 | 100
Spreadsheet: 885512d1735176876-granulating-weekly-timesheet-to-days-vlookup-index-formula-timesheet-demo-1-
Sheet: Transformation Format

Date | Employee | Pay Item | Class/Project | Service/Role | Hours | Description
2024-12-02 00:00:00 | [NAME] | Regular Pay | [NAME] | Management | 4 | Working on this stupid spreadsheet
2024-12-03 00:00:00 | [NAME] | Sick | HR | Stat/Vac/Sick | 8 | [NAME]
2024-12-04 00:00:00 | [NAME] | Regular Pay | [NAME] | Management | 4 | Working on this stupid spreadsheet
2024-12-05 00:00:00 | [NAME] | Regular Pay | [NAME] | Management | 2 | Working on this stupid spreadsheet
2024-12-06 00:00:00 | [NAME] | Regular Pay | [NAME] | Management | 2 | Working on this stupid spreadsheet
2024-12-02 00:00:00 | Bojangles | Regular Pay | Lodge | Reporting | 4 | Building walls
2024-12-03 00:00:00 | Bojangles | Regular Pay | Lodge | Reporting | 2 | Building walls
2024-12-04 00:00:00 | Bojangles | Regular Pay | Lodge | Reporting | 1 | Building walls
2024-12-03 00:00:00 | Slugger | Regular Pay | Geese | Reporting | 1 | Reporting on Geese etc
Date | Employee | Pay Item | Class/Project | Service/Role | Hours | Description
 | Bojangles | Regular Pay | Lodge | Reporting | 7 | Building walls
2024-12-04 | Bojangles | Regular Pay | Lodge | Reporting | 7 | Building walls
2024-12-05 | Bojangles | Regular Pay | Lodge | Reporting | 7 | Building walls
2024-12-03 | [NAME] | Regular Pay | [NAME] | Management | 12 | Working on this stupid spreadsheet
2024-12-04 | [NAME] | Regular Pay | [NAME] | Management | 12 | Working on this stupid spreadsheet
2024-12-05 | [NAME] | Sick | HR | Stat/Vac/Sick | 8 | [NAME]
2024-12-06 | [NAME] | Regular Pay | [NAME] | Management | 12 | Working on this stupid spreadsheet
2024-12-07 | [NAME] | Regular Pay | [NAME] | Management | 12 | Working on this stupid spreadsheet
2024-12-04 | Slugger | Regular Pay | Geese | Reporting | 1 | Reporting on Geese etc
Spreadsheet: 326159d1403084421-24-combinations-for-any-4-digit-number-permutations2
Sheet: Sheet1

 | 5678 | <<<<my number
1234 | 5678
1243 | 5687
1324 | 5768
1342 | 5786
1423 | 5867
1432 | 5876
2134 | 6578
2143 | 6587
2314 | 6758
2341 | 6785
2413 | 6857
2431 | 6875
3124 | 7568
3142 | 7586
3214 | 7658
3241 | 7685
3412 | 7856
3421 | 7865
4123 | 8567
4132 | 8576
4213 | 8657
4231 | 8675
4312 | 8756
4321 | 8765
Spreadsheet: d3ae348a-66da-4fde-a060-03bda09f7743
Sheet: Sheet1

PROG ID | ATHLETE ID | ATHLETE FIRST | ATHLETE LAST | NATIONALITY | START NUMBER | SWIM | T1 | BIKE | T2 | RUN | POSITION | TOTAL TIME
259402 | 41312 | [NAME] | Walker | GBR | 444 | 00:18:45 | 00:01:10 | 00:35:19 | 00:00:00 | 00:27:06 | 1 | 01:22:20
259402 | 25110 | [NAME] | [NAME] | GBR | 441 | 00:16:30 | 00:01:08 | 00:36:33 | 00:00:00 | 00:32:33 | 2 | 01:26:43
259402 | 11683 | George | Vargha | GBR | 443 | [NAME] | 00:01:15 | 00:37:44 | 00:00:00 | 00:31:24 | 3 | 01:27:11
259402 | 11676 | [NAME] | Rozhkov | RUS | 446 | 00:18:31 | 00:01:09 | 00:41:41 | 00:00:00 | 00:28:48 | 4 | 01:30:07
259402 | 23048 | Roderick | Paton | GBR | 442 | 00:19:26 | 00:01:36 | 00:38:03 | 00:00:00 | 00:40:00 | 5 | 01:39:04
Spreadsheet: 490994d1480245265-vba-code-for-changing-font-colors-my-book
Sheet: Φύλλο3

1ST EXAMPLE |  |  |  |  |  | 2ND EXAMPLE
SUPERVISOR ID | LASTNAME & NAME | AGE | GENDER | PHONE |  | SUPERVISOR ID | LASTNAME & NAME | AGE | GENDER | PHONE
1 |  |  |  |  |  | 1
2 |  |  |  |  |  | 2
3 |  |  |  |  |  | 3
4 |  |  |  |  |  | 4
Can be done and here the same automatic coloring of all the rows of data?
For the 1st example, [NAME] is from table with blue font color, can it be with blue colors also here? And if it was in third row again with blue colors.
But in 2nd example in first row I have another name and I want to take font color from the table which exists the last name
Spreadsheet: 0128ce31-85f7-4968-8af8-12597b2ba9e3
Sheet: Sheet1

Month | Permit # | License # | [NAME] | # Of Fills Week 1 | # Of Fills Week 2 | # Of Fills Week 3 | # Of Fills Week 4
9 July to August 3, 2012
6 August to 31 August, 2012
3 September to 28 September, 2012
1 October to 26 October, 2012
29 October to 23 November, 2012
26 November to 21 December, 2012
24 December, 2012 to 18 January, 2013
21 January to 15 February, 2013
18 February to 15 March, 2013
18 March to 12 April, 2013
15 April to 10 May, 2013
13 May to 7 June, 2013
10 June to 5 July, 2013
[NAME] to link below:
[EMAIL]
Spreadsheet: 386184d1427648952-multiple-data-into-one-master-sheet-main-sheetall
Sheet: Sheet1

Name | Designation | Salary | Dept.
Rizwan | Logistic Co-Ordinator
Usman | Engineering
Kamran | Finance & Tax Implication
Owais | Owner
Hamza | Owner
Farooq | Owner
Imad | Owner
Ibad | Owner
iF(ISERROR(MATCH(A4, Jan!$A$2:$A$10, 0)), "", INDEX(Jan!$B$2:$B$10, MATCH(A4, Jan!$A$2:$A$10, 0))) + CTRL + SHIFT + ENTER
Spreadsheet: 45c7df4b-7ed7-4b99-8c11-68e9726ad186
Sheet: Sheet1

Adresseliste fra www.proff.no | Unnamed: 1 | Unnamed: 2 | Unnamed: 3 | Unnamed: 4 | Unnamed: 5 | Unnamed: 6 | Unnamed: 7
[NAME]:Oppføringer fra [NAME]
FIRMANAVN | ADRESSE | POSTNR. | POSTSTED | TELEFON | TELEFAKS
ANTONSENS REGNSKAPSTJENESTE | SOLBRÅTANVEIEN 40 | 1410 | Kolbotn
Trenger du oppdaterte adresselister til DM /TM? [NAME] (www.forvalt.no) tilbyr ett segmenterings- og uttekksverktøy hvor du [NAME] frem til din målgruppe og eksportere lister til Excel. Du kan gjøre oppslag så ofte du vil, med en begrensning på 3500 selskap per søk. Våre telefonnummere er hentet fra Telefonkatalogen og [NAME].  Med segmenteringsverktøy kan du: - Hente ut adresseliste før en DM utsendelse - Lage ringelister - Hente ut bransjestatistikker - Oppdatere din kundedatabase  Se http://forvalt.no/segmenteringsverktoy/
Spreadsheet: 81912d1282036753-link-selected-cells-in-new-sequence-dummy-timetable
Sheet: Class 1d

2010-08-23 00:00:00
Spreadsheet: 1ccfbb79-6239-4547-9809-a5efaa209adb
Sheet: Sheet1

BAYSIDE WINTER TRAINING FACILITIES | Unnamed: 1 | Unnamed: 2 | Unnamed: 3 | Unnamed: 4 | Unnamed: 5 | Unnamed: 6
WINTER 2010-11
 |  | TO/ |  |  | COST
 |  | FROM |  |  | PER
 | DAY | DATES | TIME | VENUE | HIRE | NOTES
AMATEURS | MONDAY | 13/9/10 - 28/3/11 | 9-10PM | PITCH 2 DALGETY BAY LEISURE CENTRE | 31.45 | CANCELLED
 | THURSDAY | 2010-10-07 00:00:00 | 8-9PM | PITCH 3 DALGETY BAY LEISURE CENTRE |  | ALREADY BOOKED
U19's | TUESDAY | 14/9/10 - 29/3/11 | 7-8.15PM | I.H.S. ASTRO PITCH |  | NO LONGER TRAINING - CANCELLED
 | THURSDAY | 16/9/10 - 31/3/11 | 8.30-10PM | I.H.S. ASTRO PITCH |  | CONFIRMED
94's | TUESDAY | 14/9/10 - 29/3/11 | 5-6.30PM | I.H.S. ASTRO PITCH |  | CONFIRMED
 | THURSDAY | 16/9/10 - 31/3/11 | 5-6.30PM | I.H.S. ASTRO PITCH |  | CONFIRMED
95's | WEDNESDAY | 15/9/10 - 30/3/11 | 7-8.30PM | DULOCH 7v7 | 44.63 | CONFIRMED
96's | MONDAY | 13/9/10 - 28/3/11 | 8-9PM | PITCH 1 DALGETY BAY LEISURE CENTRE | 22.1 | CONFIRMED.  COST IN SEPT IS £20.83 PRICE INCREASE 1/10/10
 | WEDNESDAY | 15/9/10 - 30/3/11 | 7-8PM | PITCH 1 DALGETY BAY LEISURE CENTRE | 22.1 | CONFIRMED.  COST IN SEPT IS £20.83 PRICE INCREASE 1/10/10
97's | TUESDAY | 14/9/10 - 29/3/11 | 7-8PM | WOODMILL ASTRO | 15.83 | CONFIRMED
 | THURSDAY | 16/9/10 - 31/3/11 | 7-8PM | WOODMILL ASTRO | 15.83 | CONFIRMED
98's | TUESDAY | 14/9/10 - 29/3/11 | 7-8.30PM | DULOCH 7v7 | 44.63 | CONFIRMED
 | THURSDAY | 16/9/10 - 31/3/11 | 7-8.30PM | DULOCH 7v7 | 44.63 | CONFIRMED
99's | MONDAY | 13/9/10 - 21/3/11 | 6-7PM | WOODMILL ASTRO | 31.66 | CONFIRMED
2000's | MONDAY | 13/9/10 - 21/3/11 | 6-7PM | DULOCH 7v7 | 22.1 | BOOKED 28/2/10 AND CONFIRMED VERBALLY BY DEBBIE.  COST IN SEPT IS £20.83 PRICE INCREASE 1/10/10
2001's | MONDAY | 13/9/10 - 21/3/11 | 6-7PM | PITCH 2 DALGETY BAY LEISURE CENTRE | 44.2 | BOOKED 28/2/10 AND CONFIRMED VERBALLY BY DEBBIE.  COST IN SEPT IS £20.83 PRICE INCREASE 1/10/10
 | MONDAY | 13/9/10 - 21/3/11 | 7-8PM | PITCH 2 DALGETY BAY LEISURE CENTRE
2002's | MONDAY | 13/9/10 - 21/3/11 | 6-7PM | I.H.S. ASTRO PITCH |  | CONFIRMED
2003's | MONDAY | 13/9/10 - 21/3/11 | 6-8PM | KINGS ROAD PRIMARY SCHOOL | 24.5 | CONFIRMED
2004's | MONDAY | 13/9/10 - 21/3/11 | 6-8PM | DALGETY BAY PRIMARY SCHOOL HALL | 24.5 | CONFIRMED - USE OF SOFT FOOTBALLS A CONDITION OF LET
GIRLS | MONDAY | 13/9/10 - 21/3/11 | 6-7PM | PITCH 1 DALGETY BAY LEISURE CENTRE | 22.1 | BOOKED 28/2/10 AND CONFIRMED VERBALLY BY DEBBIE.  COST IN SEPT IS £20.83 PRICE INCREASE 1/10/10
GOALIE
COACHING | THURSDAY | 16/9/10 - 31/3/11 | 6.30-8.30PM | I.H.S. ASTRO PITCH |  | CONFIRMED
96's training on grass at Inverkeithing High School temporarily as pitch 1 at DBLC closed for health and safety reasons on 13/9/10
Spare Slots
I.H.S. Astro | Tuesday | now only booked til 9pm
Spreadsheet: 178329d1346765539-using-vlookup-or-match-for-certain-criteria-to-return-a-drop-down-list-delivery-orders-example-better
Sheet: All

Company | Order Number | Description | Qty Ordered | Unit | Each | Price | Order Date | Date Received | Qty Received | Qty Short
GLENDINNING | M0020 | RC40 20 CEM 11/A-LL M300 W0.55 WRA | 6 | M3 | 20 | 120 | 2012-09-02 00:00:00 | 2012-08-30 00:00:00 | 6 | 0
GLENDINNING | M0020 | GEN 1 20MM CEM11/A-LL WRA 180KG/M3 70MM SLUMP READY MIX | 56 | M3 | 21 | 1176 |  |  |  | 56
GLENDINNING | M0020 | RC28/35 20MM CEM11/A-LL WRA 280 KG/M3 70MM SLUMP | 144 | M3 | 22 | 3168 |  |  |  | 144
GLENDINNING | M0020 | C32/40 20MM CEM11/A-LL WRA 70MM SLUMP READY MIX | 620 | M3 | 23 | 14260 |  |  |  | 620
GLENDINNING | M0020 | WAITING TIME IF APPROVED | 1 | NR | 24 | 24 |  |  |  | 1
GLENDINNING | M0020 | PART LOAD SURCHARGES | 1 | M3 | 25 | 25 |  |  |  | 1
HILTI | M0001 | VARIOUS ITEMS CREDIT | 1 | NO | 60 | 60 | 2012-09-02 00:00:00 | 2012-08-23 00:00:00 | 1 | 0
HILTI | M0001 | NATURAL PRE-MIXED MORTAR 36 HOURS LIFE | 2 | NO | 65 | 130 |  |  |  | 2
HILTI | M0001 | 0.25M3 [NAME] TUBS | 3 | NO | 70 | 210 |  |  |  | 3
HILTI | M0001 | NATURAL PRE-MIXED READY TO LAY MORTAR 12 HOUR RETARDER CLASS 1 FOR SUB-STRUCTURE | 4 | NO | 75 | 300 |  |  |  | 4
PARKER | M0011 | 380MM X 4.6MM BLACK CABLE TIE | 500 | NO | 0.01 | 5 | 2012-09-02 00:00:00 | 2012-08-28 00:00:00 | 500 | 0
PARKER | M0011 | THEODOLITE | 1 | PER WEEK | 12 | 12 |  |  |  | 1
PARKER | M0011 | DELIVERY | 1 | NO | 14 | 14 |  |  |  | 1
PARKER | M0011 | COLLECTION | 1 | NO | 16 | 16 |  |  |  | 1
 |  |  |  |  |  |  |  | From here you can use Auto Filters or Pivot Tables or other tools to
 |  |  |  |  |  |  |  | Track what has been ordered and what has been delivered.
Spreadsheet: 686469d1594648117-identifying-top-vendors-who-contribute-to-refunds-and-top-70-items-for-refunds-power-pivot-sample-data2
Sheet: Top 70% items for Pre-sell

Itemid | Count of orders | Sum of Refunds
7475 | 1 | 6808
6849 | 1 | 6578
1218 | 1 | 5977
8094 | 1 | 5849
5090 | 1 | 5765
2991 | 1 | 5622
7213 | 1 | 5536
3190 | 1 | 5237
2196 | 1 | 5033
3079 | 1 | 4776
2565 | 1 | 4500
Spreadsheet: 02d81e9d-93b2-4e71-899f-8db1b5e25959
Sheet: Yearly Count

Yearly Provider Head Count | K | 1 | 2 | 3 | 4 | 5 | 6 | 7 | 8 | 9 | 10 | 11 | 12 | Total | [NAME]
Supplementary (PT Enrollment) | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 |  | 0
Comprehensive (FT Enrollment) | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 |  | 0
Total Headcount
Yearly Provider Registrations | K | 1 | 2 | 3 | 4 | 5 | 6 | 7 | 8 | 9 | 10 | 11 | 12 | Total | [NAME]
Supplementary (PT Enrollment) | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 |  | 0
Comprehensive (FT Enrollment) | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 |  | 0
Total All Registrations
Yearly Course Completions | K | 1 | 2 | 3 | 4 | 5 | 6 | 7 | 8 | 9 | 10 | 11 | 12 | Total | [NAME]
Supplementary (PT Enrollment) | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 |  | 0
Comprehensive (FT Enrollment) | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 |  | 0
Total All Completions
Yearly Summer Registrations | 9 | 10 | 11 | 12 | Total
Supplementary (PT Enrollment) | 0 | 0 | 0 | 0
Comprehensive (FT Enrollment) | 0 | 0 | 0 | 0
Total All Registrations
Yearly Summer Course Completions | 9 | 10 | 11 | 12 | Total
Supplementary (PT Enrollment) | 0 | 0 | 0 | 0
Comprehensive (FT Enrollment) | 0 | 0 | 0 | 0
Total All Completions
PT = Part time, FT = Full time
*Course registration - Based on one student enrolled in one semester course counted on a census date two weeks after the student begins the course.
**Classes for graduation-Report the number of registrations that contributed to graduation for a 12th grade student at another (enrolling or transfer-out) school.
***Course completion - Based on one student completing one class (semester course) at the end of the academic year with a passing grade (A-D).
End of worksheet 3 of 4.
Spreadsheet: 761371d1640862524-sum-up-values-across-columns-in-table-sumifsexample-aligw
Sheet: Sheet1

 |  |  | Deployment | Name | Result
 |  |  | Dep1 | Name1 | 0
 |  |  | Dep1 | [NAME] | 1
 |  |  | Dep1 | Name3 | 0
 |  |  | Dep1 | Name4 | 2 |  |  | Expected result = 3 (Name1 + Name4 where Deployment = Dep1)
 |  |  | Dep2 | Name5 | 2
 |  |  | Dep2 | Name6 | 4
Spreadsheet: 723807d1615904069-working-with-dates-working-with-months2
Sheet: Sheet1

Date | $ |  |  |  |  |  | January | Months by Name
2021-02-12 00:00:00 | 39.07 |  |  |  |  |  | February
2021-02-01 00:00:00 | 33.54 |  |  |  |  |  | March
2021-03-09 00:00:00 | 39.47 |  |  |  |  |  | April
2020-12-12 00:00:00 | 34.03 | March |  |  |  |  | May
2021-03-13 00:00:00 | 11.05 |  |  |  |  |  | June
2020-12-29 00:00:00 | 17.43 |  |  |  |  |  | July
2021-03-09 00:00:00 | 23.42 |  |  |  |  |  | August
2021-03-07 00:00:00 | 37.91 |  |  |  |  |  | September
2021-02-13 00:00:00 | 14.01 |  |  |  |  |  | October
2021-02-19 00:00:00 | 37.92 |  |  |  |  |  | November
2021-01-24 00:00:00 | 31.62 |  |  |  |  |  | December
2021-01-19 00:00:00 | 13.91
2021-02-24 00:00:00 | 23.55
2020-12-28 00:00:00 | 7.62
2021-01-30 00:00:00 | 9.2
2021-03-04 00:00:00 | 26.74
2020-12-14 00:00:00 | 26.13
2020-12-30 00:00:00 | 22.73
2021-01-22 00:00:00 | 14.18
2020-12-21 00:00:00 | 15.36
2021-01-27 00:00:00 | 22.86
2021-01-24 00:00:00 | 46.87
2021-01-28 00:00:00 | 22.11
2021-02-09 00:00:00 | 38.69
2021-02-02 00:00:00 | 21.79
2021-01-14 00:00:00 | 14.46
2021-02-17 00:00:00 | 36.93
2021-01-21 00:00:00 | 41.07
2021-03-12 00:00:00 | 2.67
2021-02-13 00:00:00 | 30.3
2021-02-02 00:00:00 | 36.04
2021-01-18 00:00:00 | 1.03
2021-01-27 00:00:00 | 19.58
2021-02-07 00:00:00 | 21.74
2021-01-22 00:00:00 | 9.97
2021-03-15 00:00:00 | 12.97
2021-02-18 00:00:00 | 2.87
2021-03-11 00:00:00 | 28.96
2021-03-08 00:00:00 | 5.22
2021-01-26 00:00:00 | 15.2
2021-02-05 00:00:00 | 9.29
2020-12-13 00:00:00 | 11.39
2021-01-31 00:00:00 | 1.49
2021-01-28 00:00:00 | 9.06
2021-02-09 00:00:00 | 30.18
2021-03-15 00:00:00 | 19.62
2021-02-04 00:00:00 | 12.35
2021-02-09 00:00:00 | 37.35
2021-03-06 00:00:00 | 42.28
2020-12-31 00:00:00 | 42.97
2021-02-18 00:00:00 | 37.06
2021-03-15 00:00:00 | 2.78
2021-02-27 00:00:00 | 47.17
2021-02-08 00:00:00 | 43.1
2020-12-14 00:00:00 | 39.34
2020-12-27 00:00:00 | 13.65
2021-02-01 00:00:00 | 20.63
2021-01-19 00:00:00 | 12.6
2020-12-13 00:00:00 | 31.07
2021-01-18 00:00:00 | 26.31
2021-01-03 00:00:00 | 34.38
2021-01-06 00:00:00 | 30.7
2021-02-12 00:00:00 | 45.16
2020-12-20 00:00:00 | 37.51
2021-01-12 00:00:00 | 19.3
2021-01-12 00:00:00 | 36.22
2020-12-11 00:00:00 | 16.63
2021-01-22 00:00:00 | 27.53
2020-12-08 00:00:00 | 5.26
2020-12-23 00:00:00 | 15.36
2021-02-19 00:00:00 | 7.84
2021-01-25 00:00:00 | 15.01
2021-02-24 00:00:00 | 8.84
2020-12-06 00:00:00 | 33.12
2020-12-23 00:00:00 | 42.08
2020-12-06 00:00:00 | 14.05
2021-02-08 00:00:00 | 23.69
2020-12-07 00:00:00 | 12.54
2020-12-14 00:00:00 | 30.92
2021-03-14 00:00:00 | 18.17
2021-03-01 00:00:00 | 9.58
2020-12-15 00:00:00 | 7.97
2020-12-29 00:00:00 | 31.82
2021-01-26 00:00:00 | 22.56
2020-12-19 00:00:00 | 15.76
2020-12-24 00:00:00 | 24.52
2020-12-15 00:00:00 | 6.51
2020-12-10 00:00:00 | 49.2
2021-02-24 00:00:00 | 37.92
2021-01-07 00:00:00 | 39.5
2021-02-16 00:00:00 | 37.63
2021-02-06 00:00:00 | 30.32
2020-12-28 00:00:00 | 48.8
2021-03-05 00:00:00 | 25.5
2021-03-06 00:00:00 | 40.75
2021-01-03 00:00:00 | 48.81
2021-01-08 00:00:00 | 8.47
2021-01-25 00:00:00 | 27.2
2021-01-05 00:00:00 | 47.11
2021-02-03 00:00:00 | 42.94
Spreadsheet: 161326d1339499033-updating-a-mirror-list-with-new-rows-updatingrowsinlist
Sheet: Master price list

 | Car | Price lists: | 1 | 2 | 3
a | Estate |  | 100 | 110 | 120
b | Sporty |  | 150 | 150 | 180
 | Color
r | red |  | 40 | 38 | 40
w | white |  | 40 | 40 | 45
b | blue |  | 40 | 40 | 50
 | Engine
1 | 1,8l |  | 25 | 27 | 30
2 | 2,2l |  | 25 | 25 | 30
3 | 2,5l TD |  | 30 | 30 | 35
 | Options
s | sun roof |  | 10 | 10 | 15
c | cup holder |  | 5 | 5 | 60
Spreadsheet: 266487d1379625219-use-selections-from-two-data-validation-lists-to-lookup-and-return-a-combined-result-state-countyfipscode1
Sheet: NEBRASKA-26

 | COUNTY | CODE
 | Adams | 1
 | Antelope
 | [NAME]
 | [NAME]
 | Blaine
 | Boone
 | [NAME]
 | [NAME]
 | [NAME]
 | Buffalo
 | Burt
 | Butler
 | [NAME]
 | Cedar
 | Chase
 | [NAME]
 | [NAME]
 | Clay
 | Colfax
 | Cuming
 | Custer
 | Dakota
 | Dawes
 | Dawson
 | [NAME]
 | [NAME]
 | Dodge
 | [NAME]
 | [NAME]
 | Fillmore
 | Franklin
 | Frontier
 | Furnas
 | Gage
 | Garden
 | [NAME]
 | Gosper
 | Grant
 | [NAME]
 | Hall
 | [NAME]
 | Harlan
 | [NAME]
 | Hitchcock
 | Holt
 | Hooker
 | [NAME]
 | [NAME]
 | [NAME]
 | Kearney
 | [NAME]
 | [NAME]
 | Kimball
 | Knox
 | Lancaster
 | Lincoln
 | Logan
 | Loup
 | McPherson
 | [NAME]
 | Merrick
 | Morrill
 | Nance
 | Nemaha
 | Nuckolls
 | Otoe
 | Pawnee
 | Perkins
 | Phelps
 | Pierce
 | Platte
 | Polk
 | Red Willow
 | Richardson
 | Rock
 | Saline
 | Sarpy
 | Saunders
 | Scotts Bluff
 | Seward
 | [NAME]
 | [NAME]
 | Sioux
 | Stanton
 | [NAME]
 | [NAME]
 | Thurston
 | Valley
 | Washington
 | Wayne
 | [NAME]
 | Wheeler
 | York