tianzl66/Sheetpedia huggingface dataset:
Spreadsheet: 38c56cf4-d67d-4e31-963b-7272a5c70041
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
FMUSK | Test | FMUSK | [NAME] | MuSK Quantitative Titers Antibody | Radioimmunoassay (RIA) | Plain, Red-Top Tube: Red |  |  | 2 | mL | Draw blood in plain red-top tube(s). (Serum gel tube is acceptable.) Spin down and send 2 mL of serum refrigerated.  Note: Collection date is required. | 1 mL | Specimens other than	Serum Anticoagulants other than	NA Hemolysis	NA Thawing	NA Lipemia	NA Icteric	NA | Negative: <10 Borderline: 10 Positive:  > or = 20  Test Performed by: Athena Diagnostics                                        377 Plantation Street                                        Four Biotech Park                                        Worcester, MA 01605 | Varies | 7-14 days | 8-15 days | 1 | 83519 |  |  |  |  | Athena Diagnostics
FMUSK | [NAME] | SERUM | Serum |  |  |  | Refrigerated | 14 days
FMUSK | Result | Z0082 | [NAME] | [NAME] | Alphanumeric |  |  |  |  |  |  |  |  |  |  |  |  |  |  | In Process
Spreadsheet: 747750d1631689575-repeated-customer-to-count-as-1-customer-excel-formula-help-cs-data
Sheet: Sheet1

 |  |  | [NAME]
 | SR # | CUSTOMER NAME | NO OF VISIT
 | 1 | A
 | 2 | B
 | 3 | C
 | 4 | D
 | 5 | E
 | 6 | A
 | 7 | B
 | 8 | B
 | 9 | D
 | 10 | D |  |  |  |  |  | CUSTOMER NAME | NO OF VISIT
 | 11 | A |  |  |  |  |  | A | 4
 | 12 | A |  |  |  |  |  | B | 3
 | 13 | D |  |  |  |  |  | C | 3
 | 14 | D |  |  |  |  |  | D | 6
 | 15 | E |  |  |  |  |  | E | 4
 | 16 | E
 | 17 | E
 | 18 | C
 | 19 | C
 | 20 | D
Spreadsheet: 847732d1698600321-searching-a-drop-down-list-to-select-data-but-actually-choosing-a-diff-column-of-data-validation-list
Sheet: Validation Lists

Last Name | First Name | Title | Suffix | Name last first | Full Name
[NAME] | [NAME] | PA | Pa
Doe | [NAME] | Dr | MD
Jones | [NAME] | Ms
Smith | [NAME] | Mr | [NAME]
White | [NAME] | Dr | PhD
Wilson | [NAME] | Dr | DO
[NAME] | Misty | Dr | DO
Spreadsheet: 250266d1373889438-clean-up-of-a-column-cleanup-sample
Sheet: Sheet1

Type | Product | Group | Name | Product Code | Description | Result | Imag
Gifting | Drinkware | Waterbottles - Plastic | 1 Litre Tritan Water Bottle | BW0020 | <ul>     <[NAME]: arial; font-size: 13px;">BPA Free Tritan Material</span></li>     <[NAME]: arial; font-size: [NAME] Capacity</span></li>     <[NAME]: arial; font-size: 13px;">Stainle | BPA Free Tritan Material 1 Litre Capacity Stainle | 15622_Thumb.png
Gifting | Drinkware | Flasks | 1.8l Plastic Vacuum Flask | BW0042 | <ul>     <[NAME] Steel</li>     <li>225ml Capacity</li>     <li>Twist Top</li>     <li>Hinged Metal Safety Lid Connector</li> </ul> | 18/8 Stainless Steel 225 ml Capacity Twist Top Hinged Metal Safety Lid Connector | 38305_Thumb.png
Gifting | Tools | Multi-Tools | 10 Function Stainless Pocket Knife | BT0001 | <ul>     <li>Includes:</li>     <[NAME]Knife</li>     <[NAME]Scissors</li>     <li>Can Opener</li>     <li>Phillips Head Screwdriver</li>     <[NAME] File</li>     <li>Punch</li>     <li>Corkscrew</li>     <[NAME] Ring</li>     <li>Flathead Screwdriver</li> |  | 14659_Thumb.png
Gifting | Leisure and Outdoor | Golf | 100% Cotton Golf Towel | BH0070 | <ul>     <li>100% [NAME] Towel</li>     <li>Metal Clip</li> </ul> |  | 38420_Thumb.png
Gifting | Office Accessories | Photo Frames | 10cm x 13cm Rounded Edge Photo Frame | BD0027 | <ul>     <[NAME]Rounded Outer Edge</li>     <li>Polished Aluminium</li>     <[NAME] Horizontal Or Vertical Display</li>     <[NAME] 10cm x 13cm Photo</li> </ul> |  | 15727_Thumb.png
Gifting | Office Accessories | Photo Frames | 10cm x 15cm Aluminium Photo Frame | BD0064 | <ul>     <[NAME] Finish</li>     <[NAME] 10cm x 15cm Photo</li> </ul> |  | 36544_Thumb.png
Gifting | Leisure and Outdoor | Coolers | 12 Can Cooler with 2 Exterior Pockets - 70D - PEVA Lining | BC0006 | <ul>     <li>Fully Insulated Main Compartment Holds 12 Cans</li>     <[NAME] PEVA Lining</li>     <[NAME] Pocket</li>     <li>Side Mesh Pocket</li>     <li>Adjustable Strap</li> </ul> |  | 14456_Thumb.png
Gifting | Drinkware | Decanters | 1240ml [NAME] and [NAME] | BW0029 | <ul>     <[NAME]: arial; font-size: 13px;">1240ml Decanter</span></li>     <[NAME]: arial; font-size: 13px;">Drinking Glass</span></li>     <[NAME]: arial; font-size: 13px;">Glass Serves As De |  | 30907_Thumb.png
Gifting | Tools | Multi-Tools | 12-in-1 Anodized Knife | BT0004 | <ul>     <li>Includes</li>     <[NAME]Knife</li>     <[NAME]Scissors</li>     <[NAME] Opener</li>     <li>Can Opener</li>     <li>Phillips Head Screwdriver</li>     <li>Flathead Screwdriver</li>     <[NAME] File</li>     <li>Corkscrew</li>     <li>Punch</li |  | 14661_Thumb.png
Spreadsheet: 10efd884-dea8-4f9e-a150-a6c901a0c9d2
Sheet: age graph

back to tables |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | Column Labels
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | Values | <18 | 18 & 19 | 20 to 24 | 25 to 29 | 30 to 34 | 35 to 39 | 40 to 49 | 50 + | Unknown | Grand Total
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | AY07-08# | 297 | 3297 | 4371 | 1505 | 865 | 730 | 1116 | 631 | 1 | 12813
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | AY08-09# | 427 | 3740 | 4888 | 1639 | 1007 | 764 | 1215 | 648 | 0 | 14328
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | AY09-10# | 337 | 3641 | 4940 | 1739 | 995 | 768 | 1212 | 670 | 1 | 14303
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | AY10-11# | 134 | 2877 | 4919 | 1645 | 902 | 639 | 1053 | 573 | 0 | 12742
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | AY11-12# | 105 | 2586 | 4966 | 1471 | 825 | 582 | 876 | 523 | 0 | 11934
Spreadsheet: 97569d1296704325-invalid-property-array-index-vbadiag
Sheet: Sheet2

Movie | Rating | Number | Actors
21 | Drama PG13 For some violence, and sexual content including partial nudity | 21 | [NAME], [NAME]
300 | Action & Adventure R For graphic battle sequences throughout,sexuality | 22 | [NAME], [NAME]
1408 | Horror PG13 Some material may be inappropriate for children under 13. | 23 | [NAME], [NAME]
2012 | PG13 | 24 | [NAME], Chiwetel Ejiofor
Items or Less | Comedy R For language | 25 | [NAME], [NAME]
Things I hate about You | [NAME]   [NAME], [NAME] | 26 | Julia Stiles, Heath Ledger
10000 BC | Action & Adventure PG13 For sequences of intense action and violence | 27 | [NAME], [NAME]
101 Dalmatians | Animated/adventure Rating: PG | 28 | [NAME], [NAME]
Days of Christmas Eve | Comedy, Drama, Rating PG | 22 | [NAME], Bonita Friedericy
Men of Christmas | NR | 210 | [NAME], [NAME]
3 Going on 30 | Comedy/drama Rating: PG | 211 | [NAME], [NAME]
5 Minutes | Mystery & Suspense  R   Violence, Profanity, | 212 | [NAME], [NAME]
6 Blocks | Mystery & Suspense Rated PG13 | 213 | [NAME], [NAME]
a |  | 1
b |  | 2
c |  | 3
d |  | 4
e |  | 5
f |  | 6
g |  | 7
h |  | 8
i |  | 9
j |  | 0
k |  | 11
l |  | 12
m |  | 12
n |  | 13
o |  | 14
p |  | 15
q |  | 16
r |  | 17
s |  | 18
t |  | 19
u |  | 50
v |  | 51
w |  | 52
x |  | 53
y |  | 54
z |  | 55
3:10 to Yuma | Action & Adventure R For violence and some language | 1096
40 Year Old Virgin | Comedy, [NAME], [NAME], Strong Sexual | 765
50 First Dates | Comedy/romance Rating: PG-13 | 385
7 Seconds | Action/Adventure Rating:  R | 666
8 Below | Action & Adventure, Drama, Family & Kids Rated PG Adult Language, | 882
88 Minutes | Thrillers Rated R For disturbing violent content, brief nudity and language | 1196
A Day Without a Mexican | Comedy | 495
A Beautiful Mind | Drama Rating: PG-13 | 36
A Christmas Carol | PG | 1384
A [NAME] | Teen/comedy Rating: PG | 474
A Civil Action | Drama  PG13   [NAME], Profanity | 200
Spreadsheet: 873236d1719702809-overlapping-schedule-conditional-formatting-issue-sync_tool_final_draft_fna_review-fazalnajeeb-
Sheet: Hourly Plan_new_edit

 | Starting Date |  | 2024-03-01 00:00:00
 |  |  | 0
ID | Measurement Station | Start Date & Time | End Date & Time | Start Date & Time Gamry1 | End Date & Time Gamry1 | Start Date & Time Gamry2 | End Date & Time Gamry2 | Start Date & Time Gamry3 | End Date & Time Gamry3 | Start Date & Time Gamry4 | End Date & Time Gamry4 | Start Date & Time Gamry5 | End Date & Time Gamry5 | Start Date & Time Gamry6 | End Date & Time Gamry6 | Start Date & Time Gamry7 | End Date & Time Gamry7 | Start Date & Time Gamry8 | End Date & Time Gamry8 | Start Date & Time Gamry9 | End Date & Time Gamry9 | Start Date & Time Gamry10 | End Date & Time Gamry10
1 | MS1 | 2024-03-01 08:00:00 | 2024-03-03 11:00:00
2 | MS2 | 2024-03-01 15:00:00 | 2024-03-03 15:00:00
3 | MS3 | 2024-03-02 15:00:00 | 2024-03-04 15:00:00
4 | MS4 | 2024-03-02 15:00:00 | 2024-03-05 15:00:00
5 | [NAME] | 2024-03-03 15:00:00 | 2024-03-05 08:00:00
6 | MS6 | 2024-03-03 15:00:00 | 2024-03-07 07:00:00
7 | MS7 | 2024-03-05 15:00:00 | 2024-03-08 22:00:00
8 | MS8 | 2024-03-05 15:00:00 | 2024-03-09 15:00:00
Credit: ExcelAir
Spreadsheet: 470231d1468404960-automatic-worksheet-saving-example-workbook-rvt
Sheet: Main RVT

 | Data | Data | Data | Data | Data | Data | Data | Data | Data | Data | Data | Data
 | Data | Data | Data | Data | Data | Data | Data | Data | Data | Data | Data | Data
 | Data | Data | Data | Data | Data | Data | Data | Data | Data | Data | Data | Data
 | Data | Data | Data | Data | Data | Data | Data | Data | Data | Data | Data | Data
 | Data | Data | Data | Data | Data | Data | Data | Data | Data | Data | Data | Data |  | Information is added onto this main worksheet, There is a formula that then pulls the relevant data onto the relevant worksheets. Usual process from here is to manually save each worksheet as a .mht format, it would be ideal to have it so that when the main workbook is saved the relevant worksheets are automatically saved into their relevant locations in the correct format and automatically overwriting previous versions of worksheet.
 | Data | Data | Data | Data | Data | Data | Data | Data | Data | Data | Data | Data
 | Data | Data | Data | Data | Data | Data | Data | Data | Data | Data | Data | Data
 | Data | Data | Data | Data | Data | Data | Data | Data | Data | Data | Data | Data
 | Data | Data | Data | Data | Data | Data | Data | Data | Data | Data | Data | Data
 | Data | Data | Data | Data | Data | Data | Data | Data | Data | Data | Data | Data
 | Data | Data | Data | Data | Data | Data | Data | Data | Data | Data | Data | Data
 | Data | Data | Data | Data | Data | Data | Data | Data | Data | Data | Data | Data
 | Data | Data | Data | Data | Data | Data | Data | Data | Data | Data | Data | Data
 | Data | Data | Data | Data | Data | Data | Data | Data | Data | Data | Data | Data
 | Data | Data | Data | Data | Data | Data | Data | Data | Data | Data | Data | Data
 | Data | Data | Data | Data | Data | Data | Data | Data | Data | Data | Data | Data
 | Data | Data | Data | Data | Data | Data | Data | Data | Data | Data | Data | Data
 | Data | Data | Data | Data | Data | Data | Data | Data | Data | Data | Data | Data
 | Data | Data | Data | Data | Data | Data | Data | Data | Data | Data | Data | Data
 | Data | Data | Data | Data | Data | Data | Data | Data | Data | Data | Data | Data
 | Data | Data | Data | Data | Data | Data | Data | Data | Data | Data | Data | Data
 | Data | Data | Data | Data | Data | Data | Data | Data | Data | Data | Data | Data
 | Data | Data | Data | Data | Data | Data | Data | Data | Data | Data | Data | Data
Spreadsheet: 118024d1313365235-linking-2-cells-together-pt-premier-league-fun
Sheet: Results

Newcastle | 0 | vs | 0 | Arsenal |  | Arsenal |  | vs |  | Liverpool |  | Man Utd |  | vs |  | Arsenal
Fulham | 0 | vs | 0 | [NAME] |  | [NAME] |  | vs |  | [NAME] |  | [NAME] |  | vs |  | Wolves
[NAME] | 1 | vs | 2 | Wolves |  | [NAME] |  | vs |  | Man City |  | [NAME] |  | vs |  | Everton
QPR | 0 | vs | 4 | [NAME] |  | Chelsea |  | vs |  | West Brom |  | Liverpool |  | vs |  | [NAME]
Stoke | 0 | vs | 0 | Chelsea |  | Everton |  | vs |  | QPR |  | Chelsea |  | vs |  | [NAME]
Everton | p | vs | p | Tottenham |  | Wolves |  | vs |  | Fulham |  | Newcastle |  | vs |  | Fulham
Liverpool | 1 | vs | 1 | Sunderland |  | Man Utd |  | vs |  | Tottenham |  | Tottenham |  | vs |  | Man City
Man City |  | vs |  | Swansea |  | Sunderland |  | vs |  | Newcastle |  | [NAME] |  | vs |  | QPR
West Brom | 1 | vs | 2 | Man Utd |  | [NAME] |  | vs |  | Stoke |  | West Brom |  | vs |  | Stoke
[NAME] | 1 | vs | 1 | [NAME] |  | Swansea |  | vs |  | [NAME] |  | Swansea |  | vs |  | Sunderland
13-08-11>15-08-11 |  |  |  |  |  | 20-8-11>22-8-11 |  |  |  |  |  | 27-8-11>28-8-11
Spreadsheet: 834394d1687791613-copy-cells-from-another-sheet-depending-on-date-sample
Sheet: Sheet1

 |  | Line 1
 |  | Line 2
 |  | Line 3
 |  | Line 4
 |  | Line 5
 |  | Line 6
 |  | Line 7
 |  | Line 8
 |  | Line 9
 |  | Line 10
 |  | Line 11
 |  | Line 12
 |  | Line 13
 |  | Line 14
 |  | Line 15
 |  | Line 16
 |  | Line 17
Spreadsheet: 705672d1606248373-if-countif-question-can-this-work-or-is-there-a-way-to-accomplish-what-im-trying-book1
Sheet: Sheet1

 | Height | 77 |  |  |  |  | BMI Low Range | BMI High Range | BMI Status | BMI Actual Status
 | Weight | 210 |  |  |  |  | 0 | 18.5 | Underweight
 | BMI |  |  |  |  |  | 18.5 | 25 | Normal
 | BMI Status |  |  |  |  |  | 25 | 30 | Overweight
 |  |  |  |  |  |  | 30 | 100 | Obese
Spreadsheet: 136010d1326371116-sum-all-values-in-same-month-sum_values_same_month
Sheet: Sheet1

Date | Unique project | Sum of unique projects within same month | Expected results of formula
2010-01-06 00:00:00 | 1 |  | 3
2010-01-07 00:00:00 | 0 |  | 3
2010-01-08 00:00:00 | 1 |  | 3
2010-01-09 00:00:00 | 1 |  | 3
2011-01-10 00:00:00 | 1 |  | 1
2010-02-11 00:00:00 | 1 |  | 2
2010-02-12 00:00:00 | 1 |  | 2
2010-02-13 00:00:00 | 0 |  | 2
2010-02-14 00:00:00 | 0 |  | 2
Spreadsheet: 58636d1258898957-sumif-two-columns-meet-criteria-book1
Sheet: Sheet1

Client | Event Type | Amount
Smith | Golf European | 2000
Jones | Football Domestic | 1000
Smith | Football Domestic | -3000
Jones | Cricket Domestic | -4000
Jones | Football Domestic | -1000
Smith | Golf European | -3000
[NAME] | Cricket Domestic | 1000
[NAME] | Football Domestic | 4000
[NAME] | Football Domestic | -3000
Smith | Golf European | 2000
Smith | Football Domestic | -2000
Smith | Golf European | 4000
Jones | Cricket Domestic | 3000
Smith | Football Domestic | 2000
Jones | Cricket Domestic | 2000
Smith | Golf European | 10000
Spreadsheet: 849883d1700247960-highlight-rows-conditional-formats-based-on-multiple-criteria-conditional-formatting-multiple-criteria
Sheet: Sheet1

[NAME] | Year | Status | Training | Start Date
10015 | 2010-2011 | In Progress | ASD 403123 | 2010-09-20 00:00:00
10015 | 2010-2011 | In Progress | FortitudeX989 | 2011-02-22 00:00:00
10015 | 2011-2012 | In Progress | ASD 403123 | 2011-04-22 00:00:00
10015 | 2012-2013 | In Progress | ASD 403123 | 2013-08-01 00:00:00
10015 |  | Completed | ASD 403123 | 2013-11-01 00:00:00
10015 |  | Required to Discontinue | ADD 42 | 2014-10-01 00:00:00
10015 |  | In Progress | ASD 403939 | 2015-10-01 00:00:00
10015 |  | In Progress | ADD 40 | 2016-09-01 00:00:00
… | … | … | … | …
Desired Result: | Highlight rows that meet the below objective as in sample table above
Objective: | To capture where the all duplicates (triplciates, etc.) "In progress" statuses that need to manually adjusted by creating a conditional format to highlight rows that meet the following criteria:
Explanation of Criteria: | Status must be "in progress"
 | Training must be a different name
 | In Progess must follow another in progress
Note: Data (20,000 rows) is sorted in order of priority as follows:
[NAME]
Year
Start Date
Spreadsheet: 845606d1697046202-number-of-hours-per-shift-inlcuding-minutes-mrshorty-time_across_shifts
Sheet: Sheet1

10/10/2023 05:00 (col A) & 10/10/2023 13:00 (Col B) |  |  |  |  |  | shifts |  |  |  |  |  |  |  |  |  |  |  |  |  |  | shifts
 |  | time only |  |  | table | 0 | 1 | 2 | 3 | 4 | 5 | 6 |  | sum for each shift |  |  |  | checksum |  | shift# | start | end | shift#
start | end | start | end |  | real |  |  |  |  |  |  |  |  | 1 | 2 | 3 |  | sum | diff | 0 | 00:00:00 | 6:00:00 | 3
2023-10-10 05:00:00 | 2023-10-10 13:00:00 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 1 | 06:00:00 |  | 1
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 2 | 14:00:00 | 22:00:00 | 2
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 3 | 22:00:00 | 1 day, 6:00:00 | 3
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 4 | 1 day, 6:00:00 | 1 day, 14:00:00 | 1
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 5 | 1 day, 14:00:00 | 1 day, 22:00:00 | 2
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 6 | 1 day, 22:00:00 | 2 days, 0:00:00 | 3
Spreadsheet: 794626d1662149531-employee-absence-tracker-rolling-12-month-window-needed-2022-exempt-sick-test
Sheet: Lists

Shift | Dept | Occasion
1 | FT | Sick
2 | GP | Personal
3 | Hotel | LOA
 | HP | FMLA
 | IC | Left Early
 | RL | Arrived Late
 | RM | School Function
 | Shipping | Other
 | SP
 | Trouble
 | [NAME]
Spreadsheet: 846833d1697987315-filter-time-intervals-between-2-date-time-intervals
Sheet: Sheet1

A | B |  | Time Intervals "A-B"
2022-03-25 00:00:00 | 2018-02-08 00:00:00
2022-04-28 06:00:00 | 2017-01-11 00:00:00
2022-05-12 19:00:00 | 2019-05-31 18:00:00
2022-06-13 01:00:00 | 1998-10-05 00:00:00
2022-06-14 23:00:00 | 1998-10-05 00:00:00
2022-07-07 18:00:00 | 2002-12-12 00:00:00
2022-08-23 08:00:00 | 2002-12-02 00:00:00
2022-09-05 08:00:00 | 2002-12-02 00:00:00
2022-09-08 01:00:00 | 2015-01-05 00:00:00
2022-09-28 09:00:00 | 2002-06-19 00:00:00
2022-10-11 05:00:00 | 2019-11-29 16:00:00
2023-07-13 05:00:00 | 2015-01-22 00:00:00
2023-07-14 04:00:00 | 2015-01-22 00:00:00
2023-08-30 19:00:00 | 2008-08-29 00:00:00
Spreadsheet: 30561d1226087068-making-excel-remember-a-pattern-based-on-variables-copy-of-power-patch-sheet
Sheet: Sheet1

Fixture # | Fixture Type | Circuit Name | Circuit Number | Amps | Voltage | [NAME] | Draw Y Leg | Draw Z Leg | Soco Output
101 | Mac 700 | ML1 | 1 | 4.6 | 208v | 4.6 | 4.6 |  | A
102 | Mac 700 | ML1 | 2 | 4.6 | 208v | 4.6 | 4.6 |  | A
103 | Mac 700 | ML1 | 3 | 4.6 | 120v | 4.6 |  | 4.6 | A
104 | Mac 700 | ML1 | 4 | 4.6 | 208v | 4.6 |  | 4.6 | A
105 | Mac 700 | ML1 | 5 | 4.6 | 208v |  | 4.6 | 4.6 | A
106 | Mac 700 | ML1 | 6 | 4.6 | 208v |  | 4.6 | 4.6 | A
107 | Mac 2000 | ML2 | 1 | 5 | 208v | 5 | 5 |  | B
108 | Mac 2000 | ML2 | 2 | 5 | 208v | 5 | 5 |  | B
109 | Mac 2000 | ML2 | 3 | 5 | 208v | 5 |  | 5 | B
110 | Mac 2000 | ML2 | 4 | 5 | 208v | 5 |  | 5 | B
111 | Mac 2000 | ML2 | 5 | 5 | 208v |  | 5 | 5 | B
112 | Mac 2000 | ML2 | 6 | 5 | 208v |  | 5 | 5 | B
501 | Chroma Q Par | ML3 | 1 | 8 | 120v | 8 |  |  | C
502 | Chroma Q Par | ML3 | 2 | 8 | 120v |  | 8 |  | C
503 | Chroma Q Par | ML3 | 3 | 8 | 120v | 8 |  | 8 | C
504 | Chroma Q Par | ML3 | 4 | 8 | 120v |  |  |  | C
505 | Chroma Q Par | ML3 | 5 | 8 | 120v |  | 8 |  | C
506 | Chroma Q Par | ML3 | 6 | 8 | 120v |  |  | 8 | C
 |  |  |  |  |  | Total X Draw | Total Y Draw | Total Z Draw
 |  |  |  |  |  | 54.4 | 54.4 | 54.4
Spreadsheet: 194730d1353317800-monthly-report-calendar-ef66_calendar_multi_lookup
Sheet: Calendar

 | Sunday | Monday | Tuesday | Wednesday | Thursday | Friday | Saturday
 |  |  |  |  |  |  | 2011-01-01 00:00:00 |  |  | January
1 |  |  |  |  |  |  | Project start |  | Month | 1
2 |  |  |  |  |  |  |  |  | Year | 2011
3
4
5
6
7
 | 2011-01-02 00:00:00 | 2011-01-03 00:00:00 | 2011-01-04 00:00:00 | 2011-01-05 00:00:00 | 2011-01-06 00:00:00 | 2011-01-07 00:00:00 | 2011-01-08 00:00:00
1 |  | Contact project leader | Assemble team | Identify site
2 |  | Organise temporary phones |  | Enter in database
3 |  | Arrange offices
4 |  | Contact utilities
5
6
7
 | 2011-01-09 00:00:00 | 2011-01-10 00:00:00 | 2011-01-11 00:00:00 | 2011-01-12 00:00:00 | 2011-01-13 00:00:00 | 2011-01-14 00:00:00 | 2011-01-15 00:00:00
1
2
3
4
5
6
7
 | 2011-01-16 00:00:00 | 2011-01-17 00:00:00 | 2011-01-18 00:00:00 | 2011-01-19 00:00:00 | 2011-01-20 00:00:00 | 2011-01-21 00:00:00 | 2011-01-22 00:00:00
1
2
3
4
5
6
7
 | 2011-01-23 00:00:00 | 2011-01-24 00:00:00 | 2011-01-25 00:00:00 | 2011-01-26 00:00:00 | 2011-01-27 00:00:00 | 2011-01-28 00:00:00 | 2011-01-29 00:00:00
1
2
3
4
5
6
7
 | 2011-01-30 00:00:00 | 2011-01-31 00:00:00
1
2
3
4
5
6
7
Spreadsheet: 858358d1707078206-harvey-balls-not-showing-color-in-drop-down-list-student-attendance-1
Sheet: 2nd Period

Attendance
2nd Semester | February
2nd Period | 8:32-9:28 / 8:05-8:35 |  |  |  | Key: |  | Red | Math |  | Gray | English |  | Yellow | Other Subject |  |  | Green | Lunch |  | Blue | After-School
 |  |  | Week 1 |  |  |  |  | Week 2 |  |  |  |  | Week 3 |  |  |  |  | Week 4 |  |  |  |  | Week 5
 |  |  | M | T | W | Th | F | M | T | W | Th | F | M | T | W | Th | F | M | T | W | Th | F | M | T | W | Th | F
 |  |  |  |  |  | 1 | 2 | 5 | 5 | 27 | 28 | 29 | 1 | 2 | 3 | 4 | 5 | 8 | 9 | 10 | 11 | 12 | 15 | 16 | 17 | 18 | 19
# | Students | Picture |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | Total Unexcused Absences | Total Excused Absences | Total Tardies | Total
ATND-001 | Annalise Vasquez | 8vaWRtiSTRq-duJAAlL4eA |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | Gray | Red | Yellow | Red | Red
ATND-002 | Cherish Grant | uyroswpESFmXIRFzDiv7cQ |  |  |  |  | Red
ATND-003 | [NAME] | RYO2sTrFQvqfqFsy3PYl1A | Gray |  |  |  |  |  |  | Gray |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | Yellow
ATND-004 | Dashawn Meyers | Jc2mdZqcTayMppkcrz_1mQ
ATND-005 | [NAME] | XGyLJCulSfa9FFqm-EXXYg |  |  | Gray |  |  |  |  |  |  |  |  |  |  |  |  |  |  | Yellow
ATND-006 | [NAME] | sCeD04bLTqqtcQbBWXLCeg |  |  |  |  |  |  |  |  | Red
ATND-007 | Ivy Li | uZ_B1f2hRWSNVCwU2Yavpw |  |  |  |  |  |  | Gray |  |  |  |  |  |  | Yellow | Yellow | Red |  |  | Yellow
ATND-008 | [NAME] | 7PPIyj5BQAmUrv0faFO85Q
ATND-009 | Keagan [NAME] | rRxo0vRDTwmnufXwwInPlw
ATND-010 | King Holt | OT8NiJv0RT68zanyQUb5Ag | Yellow |  |  |  |  |  |  |  |  |  |  |  |  |  |  | Gray
ATND-011 | [NAME] | fkDgXJXdTvaH2ej0W_yA1Q |  |  |  |  |  |  |  |  |  |  |  |  | Yellow
ATND-012 | [NAME] | KthEBR88S-uDW7thePXnbA | Gray
ATND-013 | [NAME] | eeeXhbCdQheKpufaA4yY3A |  |  |  |  |  | Yellow
ATND-014 | [NAME] | UalAcv1gRH2VkjW28ju5Kw
ATND-015 | Marques Klein | LnWV1okLQ36LP86VvI2wzw
ATND-016 | [NAME] | Z1Yk3GThTcitJJl1Iy5asw |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | Red
ATND-017 | [NAME] | 2IH2SBE4RwCSFvpKqmSYKQ
ATND-018 | Mya Page | J1yr6JXdQ9udQ964XOpYNg | Red
ATND-019 | Quinn Baird | rGfigAc7R46qKv_aTV_Qcg |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | Gray
ATND-020 | [NAME] | CWP2a5mJQcOcpPkGIwsciw
ATND-021 | [NAME] | FzfrbrM6TICkb9f2fv2AFA |  |  | Red |  | Red |  |  |  | Gray |  | Gray |  |  |  | Gray |  |  | Gray
ATND-022 | [NAME] | t4uYxZcgRP-OWWj5orMX-g |  |  |  |  |  |  |  |  |  | Yellow
ATND-023 | [NAME] | Yyt8ysQrTc-dWn9-2uLcOw
ATND-024 | Scarlet Harper | U6YOR9oVT5C4z6X3HaG1fg |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | Yellow
ATND-025 | [NAME] | yZDVsqmVQiWHeAAfvwHm_g
ATND-026 | Total Unexcused Absences
ATND-027 | Total Excused Absences
ATND-028 | Total Tardies
Spreadsheet: 770478d1646109691-using-an-if-statement-with-a-drop-down-list-data-validation-with-if
Sheet: Job Title

PRIMARY ROLE | Select Role
[NAME]. Secretary
Assistant Pastor
Before/After Care Asst.
Before/After Care Lead
Bell Choir
Business Coordinator
Communications Director
Dir. of Christian Education
ELC Aide
ELC Director
ELC Substitute Aide
ELC Teacher
Kidz Camp Instructor
[NAME].
[NAME]
[NAME] Out Asst.
Senior Pastor
Worship Accompanist
Worship Organist
[NAME]