tianzl66/Sheetpedia huggingface dataset:
Spreadsheet: kate_symes__18609__MeadMktplace (2)
Sheet: MeadMktplace

 |  |  | Firm | Volume | Firm | Volume | Non Firm | Volume | Non Firm | Volume
 | DATE |  | On [NAME] | [NAME] | [NAME] | [NAME] | On [NAME] | [NAME] | [NAME] | [NAME]
 | 2001-02-09 00:00:00 |  | 153.75 | 320 | 116.25 | 1760
 | 2001-02-08 00:00:00 |  | 176.25 | 960 | 148.1 | 2000 | 174.99 | 844 | 91.4 | 1905
 | 2001-02-07 00:00:00 |  | 169.28 | 4224 | 131.32 | 3628 | 190.46 | 1300 | 95.76 | 1283
 | 2001-02-06 00:00:00 |  | 149.44 | 720 | 146.14 | 1400 | 153.56 | 520 | 88.67 | 917
 | 2001-02-05 00:00:00 |  | 160.19 | 1864 | 143.63 | 1772 | 142.39 | 1579 | 82.26 | 1310
 | 2001-02-04 00:00:00 |  | 150 | 0 | 146.67 | 1200 | 94.46 | 2705 | 81.4 | 2734
 | 2001-02-03 00:00:00 |  | 165 | 0 | 152.1 | 2000 | 127.82 | 6039 | 83.63 | 2119
 | 2001-02-02 00:00:00 |  | 160 | 320 | 148.88 | 1600 | 145.26 | 2069 | 111.08 | 2227
 | 2001-02-01 00:00:00 |  | 231.82 | 176 | 161.58 | 696 | 171.56 | 2512 | 111.53 | 1611
 | 2001-01-31 00:00:00 |  | 250 | 64 | 145 | 32 | 196.22 | 2670 | 133.68 | 1348
 | 2001-01-30 00:00:00 |  | 200.83 | 384 | 142.84 | 592 | 205.28 | 1618 | 135.46 | 1365
 | 2001-01-29 00:00:00 |  | 232.86 | 224 | 197.1 | 1000 | 188.91 | 2740 | 130.63 | 1506
 | 2001-01-28 00:00:00 |  | 200 | 320 | 175 | 0 | 178.38 | 3068 | 130.84 | 1999
 | 2001-01-27 00:00:00 |  | 232.14 | 560 | 159 | 1000 | 196.47 | 1231 | 125.85 | 2421
 | 2001-01-26 00:00:00 |  | 241.67 | 720 | 159 | 1000 | 198.58 | 1670 | 142.36 | 652
 | 2001-01-25 00:00:00 |  | 239.29 | 560 | 151.67 | 600 | 144.13 | 2493 | 118.25 | 883
 | 2001-01-24 00:00:00 |  | 175 | 800 | 141.17 | 1200 | 131.25 | 2165 | 106.42 | 399
 | 2001-01-23 00:00:00 |  | 260 | 400 | 175.13 | 1600 | 153.02 | 1895 | 130.64 | 179
 | 2001-01-22 00:00:00 |  | 300 | 64 | 175 | 32 | 240.14 | 2002 | 135.3 | 335
 | 2001-01-21 00:00:00 |  | 175 | 0 | 130 | 0 | 156.73 | 1457 | 156.37 | 606
 | 2001-01-20 00:00:00 |  | 454 | 800 | 275.37 | 1080 | 176.21 | 3868 | 161.24 | 270
 | 2001-01-19 00:00:00 |  | 454 | 800 | 275.37 | 1080 | 206.29 | 1390 | 133.1 | 909
 | 2001-01-18 00:00:00 |  | 429.73 | 592 | 228.64 | 1704 | 275.21 | 3577 | 187.25 | 1153
 | 2001-01-17 00:00:00 |  | 235 | 160 | 150.91 | 880 | 284 | 1630 | 156.87 | 546
 | 2001-01-16 00:00:00 |  | 174.75 | 640 | 114.61 | 1264 | 198.32 | 1393 | 118.67 | 961
 | 2001-01-15 00:00:00 |  | 174.29 | 560 | 114.61 | 1264 | 163.34 | 2155 | 121.91 | 913
 | 2001-01-14 00:00:00 |  | 135 | 160 | 102.1 | 496 | 151.06 | 2920 | 119.25 | 1375
 | 2001-01-13 00:00:00 |  | 170 | 160 | 116.65 | 1696 | 149.38 | 3307 | 112.78 | 1208
 | 2001-01-12 00:00:00 |  | 167.65 | 544 | 116 | 2136 | 146.77 | 361 | 110.31 | 1207
 | 2001-01-11 00:00:00 |  | 159.09 | 704 | 116 | 2136 | 147.18 | 1708 | 100.51 | 774
 | 2001-01-10 00:00:00 |  | 150 | 960 | 94.32 | 2280 | 140.57 | 584 | 101.31 | 555
Spreadsheet: 763201d1642043029-vlookup-from-multiple-table-arrays-check-in-sheet-for-staff-covid-leave-excel
Sheet: Contractors

 | Quarantine Direction from Positive [NAME]
Region | First Name | Last Name | Contact Number | Type of Test (PCR / RAT) | Isolation Start Date | Isolation End Date | Day 2 Call | Day 5 Call | Test Date | Estimated Return to work | Comments
Spreadsheet: 87388d1287225785-excel-2007-complicated-truth-check-he-list
Sheet: Copy Sheet

 |  |  | # | Unit Type |  |  | Poss Upgrades/Options |  |  |  |  |  | Pts
 | [NAME]. |  | 1 | Archmage
 |  |  |  | Mount
 |  |  | 1 | Prince
 |  |  |  | Mount
 |  |  | 1 | Commander
 |  |  |  | Mount
 |  |  | 1 | Mage
 | Core |  | 10 | [NAME]
 |  |  |  | [NAME]
 |  |  | 10 | Spearman
 |  |  |  | Spearman Champ
 |  |  | 5 | [NAME]
 |  |  |  | Silver Helm Champ
 |  |  |  | [NAME]
 |  |  | 10 | Sea Guard
 |  |  |  | Sea Guard Champ
 | Spec. |  | 5 | Dragon Prince
 |  |  |  | Drakemaster
 |  |  |  | [NAME]
 |  |  | 5 | Ellyrian Reaver
 |  |  |  | [NAME]
 |  |  |  | [NAME]
 |  |  | 5 | Swordmaster
 |  |  |  | Blademaster
 |  |  | 5 | Shadow Warriors
 |  |  |  | Shadow-walker
 |  |  | 2 | Tiranoc Chariots
 |  |  |  | [NAME]
 |  |  |  | TC Elven Steed
 | Rare. |  | 10 | Phoenix Guard
 |  |  |  | Keeper of the [NAME]
 |  |  | 1 | [NAME]
 |  |  |  | Crew
 |  |  | 10 | White Lions
 |  |  |  | Guardian
 |  |  | 1 | Great Eagle
Spreadsheet: 825373d1681286404-please-correction-my-consecutive-formula-consecutive-win
Sheet: Sheet1

Result | Column1
Win
Win
Win
Loss
Win
Win
Win
Win
Loss
Spreadsheet: 91680d1291343262-horizontal-rolling-average-deb-pingel-rolling-average-test-for-excel-forum
Sheet: Sheet1

 | Production (000)
 |  |  | 2010-11-01 00:00:00 | 2010-11-02 00:00:00 | 2010-11-03 00:00:00 | 2010-11-04 00:00:00 | 2010-11-05 00:00:00 | 2010-11-06 00:00:00 | 2010-11-07 00:00:00 | 2010-11-08 00:00:00 | 2010-11-09 00:00:00 | 2010-11-10 00:00:00 | 2010-11-11 00:00:00 | 2010-11-12 00:00:00 | 2010-11-13 00:00:00 | 2010-11-14 00:00:00 | 2010-11-15 00:00:00 | 2010-11-16 00:00:00 | 2010-11-17 00:00:00 | 2010-11-18 00:00:00 | 2010-11-19 00:00:00 | 2010-11-20 00:00:00 | 2010-11-21 00:00:00 | 2010-11-22 00:00:00 | 2010-11-23 00:00:00 | 2010-11-24 00:00:00 | 2010-11-25 00:00:00 | 2010-11-26 00:00:00 | 2010-11-27 00:00:00 | 2010-11-28 00:00:00 | 2010-11-29 00:00:00 | 2010-11-30 00:00:00 | 2010-12-01 00:00:00 | 2010-12-02 00:00:00
 | Grind (BU) | Planned | 70 | 70 | 70 | 70 | 65 | 70 | 90 | 90 | 80 | 0 | 90 | 90 | 90 | 70 | 70 | 70 | 70 | 70 | 65 | 70 | 70 | 70 | 70 | 70 | 35 | 35 | 65 | 65 | 80 | 90
30day Planned Average |  | Actual | 70 | 65 | 70 | 66 | 82 | 99 | 74 | 66 | 50 | 9.8 | 91 | 92 | 103 | 36 | 41 | 101 | 90 | 83 | 96 | 88 | 71 | 71 | 58 | 44 | 24 | 29 | 76 | 92 | 99 | 52
 |  | EDT |  |  |  | 0 |  |  | 0 | 0 | 7 |  |  |  |  | 15 | 15 | 0 | 0 | 0 | 0 | 0 | 0 |  |  |  | 7.5 | 3.25 | 5 |  |  | 2
30day Actual Average |  | ERR |  |  |  | 14 |  |  | 18 | 24 |  |  |  |  |  |  | 0 | 0 | 0 | 0 | 0 | 0 | 24 |  |  | 4 |  |  |  |  |  | 6.5
 | this should actually be 69.3333
30-day rolling average |  | Planned |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | <-- continue to copy the formulas to the right as needed
30-day rolling average |  | Actual
Spreadsheet: 854135d1704114952-create-spread-for-actual-values-against-planned-plan-vs-actual-distribution-excelforum-windknife-2-
Sheet: Sheet1

Activity | Company | Month | Plan | Actual
Activity 1 | ABC | 2023-01-01 00:00:00 | 100 | 30 |  |  |  | /Actual | 2023-01-01 00:00:00 | 2023-02-01 00:00:00 | 2023-03-01 00:00:00
Activity 2 | ABC | 2023-01-01 00:00:00 | 100 | 60 |  |  | 2023-01-01 00:00:00 | 400 | 140 | 260 | 0
Activity 1 | DEF | 2023-01-01 00:00:00 | 200 | 50 |  |  | 2023-02-01 00:00:00 | 150 | 0 | 130 | 20
Activity 1 | ABC | 2023-02-01 00:00:00 | 100 | 150 |  |  | 2023-03-01 00:00:00 | 50 | 0 | 0 | 0
Activity 1 | ABC | 2023-03-01 00:00:00 | 50 | 20
Activity 1 | DEF | 2023-02-01 00:00:00 | 0 | 150
Activity 2 | ABC | 2023-02-01 00:00:00 | 50 | 90
Plan/Actual |  | 2023-01-01 00:00:00 | 2023-02-01 00:00:00 | 2023-03-01 00:00:00
2023-01-01 00:00:00 | 400 | 140 | 260
2023-02-01 00:00:00 | 150 |  | 130 | 20
2023-03-01 00:00:00 | 50 |  |  |  |  |  | Plan | /Actual | 2023-01-01 00:00:00 | 2023-02-01 00:00:00 | 2023-03-01 00:00:00
 |  |  |  |  |  |  | 2023-01-01 00:00:00 | 400 | 140 | 260 | 0
[NAME] for January |  |  |  |  |  |  | 2023-02-01 00:00:00 | 150 | 0 | 130 | 20
Activity | Company | 2023-01-01 00:00:00 | 2023-02-01 00:00:00 | 2023-03-01 00:00:00 |  |  | 2023-03-01 00:00:00 | 50 | 0 | 0 | 0
Activity 1 | ABC | 30 | 70
Activity 2 | ABC | 60 | 40
Activity 1 | DEF | 50 | 150
[NAME] for February
Activity | Company | 2023-01-01 00:00:00 | 2023-02-01 00:00:00 | 2023-03-01 00:00:00
Activity 1 | ABC |  | 80 | 20
Activity 2 | ABC |  | 50
[NAME] for March
Activity | Company | 2023-01-01 00:00:00 | 2023-02-01 00:00:00 | 2023-03-01 00:00:00
Activity 1 | ABC
Spreadsheet: 164998d1340981813-select-random-row-from-separate-sheet-without-duplicating-selected-rows-book1
Sheet: Sheet1

TASK | ITEM | ASSIGNED TO
Encode | Page1 | Red
Encode | Page2 | Blue
Encode | Page3 | Yellow
Encode | Page4 | Orange
Encode | Page5 | Green
Encode | [NAME] | White
Encode | Page7 | Red
Encode | Page8 | Blue
Encode | Page9 | Yellow
Encode | Page10 | Orange
Encode | Page11 | Green
Encode | Page12 | White
Encode | Page13 | Red
Encode | Page14 | Blue
Encode | Page15 | Yellow
Encode | Page16 | Orange
Encode | Page17 | Green
Encode | Page18 | White
Encode | Page19 | Red
Encode | Page20 | Blue
Encode | Page21 | Yellow
Encode | Page22 | Orange
Encode | Page23 | Green
Encode | Page24 | White
Encode | Page25 | Red
Encode | Page26 | Blue
Encode | Page27 | Yellow
Encode | Page28 | Orange
Encode | Page29 | Green
Encode | Page30 | White
Spreadsheet: 600604d1543865973-vlookup-if-formula-help-to-report-summary-of-tasks-sample-task-list-copy
Sheet: Bill

BILL
MONTHLY TASK LIST
CLIENT | TASK | DUE | PRIORITY
Spreadsheet: 04ac40d8-7e78-4352-97ce-9873fa4e62e3
Sheet: 4.2(CT) Major Group Enroll-Grad

Institution
Indicator 4: Student Enrollment and Graduation by Major Group
Table 4.2(CT): Major Group Fall Enrollment, Graduation & Post-Graduate / AY 2010-11
 | Major Group | CT - Computer Technology
 | Please enter the number of students enrolled in this major group for the fall semester.
 |  |  |  |  | Fall 2010 (October 15, 2010)
 | Fall Enrollment (Snapshot) |  | American Indian |  | Non-Indian
 |  |  | M | F | M | F | Total
 |  | Full Time | 0 | 0 | 0 | 0
 |  | Part Time | 0 | 0 | 0 | 0
 |  | Total
 | Please enter the number of diploma, certificates, and degrees earned in this major group.  Also enter the number of students graduating with degrees who earned a GPA of 3.0 or above, and the number who were admitted to a 4 year (Associate degree graduates), or graduate school (Bachelor's degree graduates).  Lastly, enter the number of all graduating students(certificate or degree) who secured employment after graduation.
 |  |  |  |  | July 1, 2010- June 30, 2011
 | Graduation |  | American Indian |  | Non-Indian
 |  |  | M | F | M | F | Total
Apprenticeship/Occupational Program |  |  | na | na | na | na
Diploma |  |  | na | na | na | na
Certificate |  |  | na | na | na | na
Associate Degree |  |  | 0 | 0 | 0 | 0
 | Assoc. graduates admitted to four-year program |  | 0 | 0 | 0 | 0
 | [NAME]. graduated with a GPA of 3.0 or above |  | 0 | 0 | 0 | 0
Bachelor's Degree |  |  | na | na | na | na
 | [NAME]. graduates admitted to graduate school |  | na | na | na | na
 | [NAME]. graduated with a GPA of 3.0 or above |  | na | na | na | na
Master's Degree |  |  | na | na | na | na
Employed after graduation |  |  | na | na | na | na
program discontinued
na = not offered; m = not tracked;
Spreadsheet: 767747d1644603537-multi-criteria-list-and-vlookup-sample-report
Sheet: Data

Name | Sequence | Score | Completion Time | [NAME] | Date | Trainer Session
[NAME] | Basics | 7000 | 00:10:00 | 60 | 2010-02-01 00:00:00 | [NAME]
[NAME] | Advanced | 5000 | 00:08:00 | 30 | 2010-02-01 00:00:00 | [NAME]
Ruchir | Basics | 6200 | 00:07:00 | 55 | 2010-02-02 00:00:00 | [NAME]
[NAME] | Basics | 7100 | 00:09:50 | 62 | 2010-02-02 00:00:00 | [NAME]
Ruchir | Bonus | 4000 | 00:02:00 | 80 | 2010-02-03 00:00:00 | [NAME]
[NAME] | Basics | 8000 | 00:09:00 | 98 | 2010-02-04 00:00:00 | [NAME]
[NAME] | Advanced | 6000 | 00:08:30 | 70 | 2010-02-04 00:00:00 | [NAME]
Ruchir | Basics | 6300 | 00:07:00 | 58 | 2010-02-04 00:00:00 | [NAME]
[NAME] | Advanced | 8000 | 00:07:00 | 80 | 2010-02-05 00:00:00
Ruchir | Advanced | 8500 | 00:07:15 | 99 | 2010-02-05 00:00:00
[NAME] | Basics | 8600 | 00:08:22 | 100 | 2010-02-05 00:00:00
Spreadsheet: 18d35cba-1eae-4288-8f3c-47e763859956
Sheet: FACULTY INFORMATION FORM

Please use capital letters & no punctuation | EXAMPLE | class 1 info | class 2 info | class 3 info | class 4 info | class 5 info | class 6 info
Last Name | LOGAN
First Name | SARAH
MI | M
Printed Course Prefix (e.g. BOR, CRIJ) and Number | PSY3303
Printed Date/Time (e.g. MW 08:00 AM, TR 12:30 PM or MWF 18:00 PM) | TR 18:00 PM
Bubbled in Meeting Days (MTWRFSN) NO [NAME] or Spaces | TR
In the Classroom = Face  OR  Online Course = Online | Face
Eight Week Course = Y (yes) or N (no).    If YES… 1 for first eight weeks or 2 for second eight weeks | Y-2
For On-line courses ONLY - Print course title. In addition, please provide a class roster with [NAME] "username@angelo .edu" with your FIF.  Dropped students can be withdrawn later. | Learning  and Cognition
Objectives:  (Scale - M = Minor or No Importance,  I = Important,                              E = Essential) | M, I, E | M, I, E | M, I, E | M, I, E | M, I, E | M, I, E | M, I, E
1.  Gaining factual knowledge (terminology, classifications, methods,       trends) | E
2.  Learning fundamental principles, generalizations, or theories | E
3.  Learning to apply course material (to improve thinking, problem       solving,  and decisions) | E
4.  Developing specific skills, competencies, and points of view needed       by professionals in the field most closely related to this course | I
5.  Acquiring skills in working with others as a member of a team | I
6.  Developing creative capacities (writing, inventing, designing,       performing in art, music, drama, etc.) | M
7.  Gaining a broader understanding and appreciation of       intellectual/cultural activity (music, science, literature, etc.) | M
8.  Developing skill in expressing oneself orally or in writing | M
9.  Learning how to find and use resources for answering questions or       solving problems | M
10.  Developing a clearer understanding of, and commitment to, personal         values | M
11.  Learning to analyze and critically evaluate ideas, arguments,         and points of view | M
12.  Acquiring an interest in learning more by asking questions and         seeking answers | M
[NAME] (e.g. BOR, CRIJ) | PSY
Discipline codes:  BORDER SECURITY = 4301,     CRIMINAL JUSTICE = 4301                                                     (4 digits) | 4200 | 4301 | 4301 | 4301 | 4301 | 4301 | 4301
[NAME] (e.g. 800, 1230, or 1800) | 800
Bubbled Course Number                                                 (4 digits) | 3303
Enrollment | 23
NO Local Code for Border Security or Criminal Justice       Leave Blank
Long (L) or Short (S) Forms | L
Number of Additional Questions to be answered on the Survey  ([NAME]. number of Additional questions that can be asked for Long form = 19 & Short form = 10) | 12
Is this class [NAME]?   Y or N | N
Spreadsheet: 674616d1587951616-list-multiple-pages-and-remove-duplicates-test123-xatomicx-
Sheet: Saturday

 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | Friday | Saturday (new) |  | Cumulative
 | [NAME]
 | [NAME]
 | [NAME]
 | [NAME]
 | [NAME]
 | Lorelei Daniel
 | Darsh Bartlett
 | [NAME]
 | [NAME]
Total
Spreadsheet: 867777d1714571587-really-really-need-help-with-this-contra-entries-with-customer-names-testingonline-updated-for-gleen
Sheet: Sheet1

Period | FY Year | FY Month Long Name | Invoice Date | Invoice Number | Invoice Separated | Customer Name | Sum of Revenue | ABS | Countif | Concat | Countif | customer same | Expected results
P1 | 2023 | October | 03/10/2022 | CSOL-1390946 | 1390946 | [NAME] | 995 |  |  |  |  |  | this should say 1 because even thought it has matched with row 9 it isnt john it is ollo
P1 | 2023 | October | 03/10/2022 | CSOL-1390946 | 1390946 | [NAME] | 96 |  |  |  |  |  | this is correct as 1's show that there is no matching entry
P1 | 2023 | October | 03/10/2022 | CSOL-1390947 | 1390947 | Gabby | 56 |  |  |  |  |  | this is correct as 1's show that there is no matching entry
P1 | 2023 | October | 03/10/2022 | CSOL-1390951 | 1390951 | [NAME] | 2985 |  |  |  |  |  | this is correct as 1's show that there is no matching entry
P1 | 2023 | October | 03/10/2022 | CSOL-1390951 | 1390951 | ALi | 368.15 |  |  |  |  |  | this is correct as 1's show that there is no matching entry
P1 | 2023 | October | 03/10/2022 | CSOL-1390951 | 1390951 | [NAME] | 378 |  |  |  |  |  | this is correct as 1's show that there is no matching entry
P1 | 2023 | October | 03/10/2022 | CSOL-1390953 | 1390953 | Kit | 3040.2 |  |  |  |  |  | this is correct as 1's show that there is no matching entry
P1 | 2023 | October | 03/10/2022 | CSOL-1390954 | 1390954 | Ollo | -995 |  |  |  |  |  | this should say 1 because even though it matched with row 1 it isnt john
P1 | 2023 | October | 03/10/2022 | CSOL-1390957 | 1390957 | mark | 2077.69 |  |  |  |  |  | this 2 is correct as in column G it is the same customer
P1 | 2023 | October | 03/10/2022 | CSOL-1390960 | 1390960 | mark | -2077.69 |  |  |  |  |  | this 2 is correct as in column G it is the same customer
P1 | 2023 | October | 03/10/2022 | CSOL-1390961 | 1390961 | Univar Speciality Consumables Limited | 1696.6 |  |  |  |  |  | this is correct as 1's show that there is no matching entry so there is no 1696.6
P1 | 2023 | October | 03/10/2022 | CSOL-1390962 | 1390962 | [NAME] | 565.64 |  |  |  |  |  | this is correct as 1's show that there is no matching entry
P1 | 2023 | October | 03/10/2022 | CSOL-1390963 | 1390963 | Tele | 678.19 |  |  |  |  |  | this is correct as 1's show that there is no matching entry
P1 | 2023 | October | 03/10/2022 | CSOL-1390963 | 1390963 | Tele | 3049.36 |  |  |  |  |  | this is correct as 1's show that there is no matching entry
P1 | 2023 | October | 03/10/2022 | CSOL-1390964 | 1390964 | Remington | 884.34 |  |  |  |  |  | this is correct as 1's show that there is no matching entry
 |  |  |  |  |  |  |  |  | but lets say the 1's in column L currently as above - if I put more data from row 17 - and if the lines I add  numbers match - it will say 2 in column L as its found a matching number but then we need to make sure it is also the same customer
Spreadsheet: 624148d1557760896-calculate-number-of-employees-working-each-hour-4-tens-schedule-sample
Sheet: 05.13 (2)

Hotel Reservations Schedule
 | Monday
 | 2019-05-13 00:00:00
NAME | 00:00:00 | 10:30:00
NAME | 06:00:00 | 16:30:00
NAME | 08:00:00 | 18:30:00
NAME | 10:00:00 | 20:30:00
NAME | 11:00:00 | 21:30:00
NAME | 11:00:00 | 22:30:00
NAME | 13:00:00 | 23:30:00
NAME | 13:00:00 | 23:30:00
NAME | 15:00:00 | 01:30:00
NAME | 23:00:00 | 09:30:00
NAME
NAME
NAME
NAME
NAME
NAME
NAME
NAME
NAME |  |  | Manual Calculations
NAME |  |  | Manual Calculations
NAME |  |  | Manual Calculations
NAME |  |  | Manual Calculations
NAME |  |  | Manual Calculations
NAME |  |  | Manual Calculations
NAME |  |  | Manual Calculations
NAME |  |  | Manual Calculations
NAME |  |  | Manual Calculations
NAME |  |  | Manual Calculations
NAME |  |  | Manual Calculations
 | [NAME] |  | Manual Calculations
07:00:00 |  | 07:00:00 | 1
08:00:00 |  | 08:00:00 | 2
09:00:00 |  | 09:00:00 | 2
10:00:00 |  | 10:00:00 | 3
11:00:00 |  | 11:00:00 | 5
12:00:00 |  | 12:00:00 | 5
13:00:00 |  | 13:00:00 | 7
14:00:00 |  | 14:00:00 | 7
15:00:00 |  | 15:00:00 | 8
16:00:00 |  | 16:00:00 | 8
17:00:00 |  | 17:00:00 | 7
18:00:00 |  | 18:00:00 | 7
19:00:00 |  | 19:00:00 | 6
20:00:00 |  | 20:00:00 | 6
21:00:00 |  | 21:00:00 | 5
22:00:00 |  | 22:00:00 | 4
23:00:00 |  | 23:00:00 | 4
1900-01-01 00:00:00 |  | 1900-01-01 00:00:00 | 3
1900-01-01 01:00:00 |  | 1900-01-01 01:00:00 | 3
1900-01-01 02:00:00 |  | 1900-01-01 02:00:00 | 2
1900-01-01 03:00:00 |  | 1900-01-01 03:00:00 | 2
1900-01-01 04:00:00 |  | 1900-01-01 04:00:00 | 2
1900-01-01 05:00:00 |  | 1900-01-01 05:00:00 | 2
1900-01-01 06:00:00 |  | 1900-01-01 06:00:00 | 2
Spreadsheet: 859905d1708115660-solved-extracting-text-left-and-right-of-a-word-extract-numbers
Sheet: Sheet1

 |  |  |  |  | Temperatures |  |  |  | Year of Occurrence
 |  |  |  |  | Warmest High | Coldest High | Warmest Low | Coldest Low | Warmest High | Coldest High | Warmest Low | Coldest Low
2024-06-20 00:00:00 | 102 in 1933 | 59 in 1946 | 72 in 1988 | 42 in 1992
2024-06-21 00:00:00 | 102 in 1988 | 61 in 1906 | 74 in 1943 | 40 in 1992
2024-06-22 00:00:00 | 97 in 1995 | 59 in 1992 | 75 in 1983 | 44 in 1902
2024-06-23 00:00:00 | 98 in 2005 | 61 in 1969 | 75 in 2005 | 42 in 1972
2024-06-24 00:00:00 | 97 in 1874 | 59 in 1957 | 78 in 1937 | 44 in 1887
2024-06-25 00:00:00 | 97 in 1983 | 63 in 1968 | 77 in 1954 | 45 in 1974
2024-06-26 00:00:00 | 100 in 1931 | 55 in 1968 | 77 in 1943 | 42 in 1926
2024-06-27 00:00:00 | 99 in 1933 | 62 in 1968 | 79 in 1991 | 44 in 1992
2024-12-22 00:00:00 | 59 in 1877 | -7 in 1989 | 50 in 1877 | -23 in 1983
2024-12-23 00:00:00 | 59 in 1877 | -18 in 1983 | 49 in 1877 | -28 in 1872
2024-12-24 00:00:00 | 61 in 1889 | -10 in 1983 | 41 in 2023 | -37 in 1872
2024-12-25 00:00:00 | 55 in 1936 | -11 in 1884 | 50 in 2023 | -26 in 2000
2024-12-26 00:00:00 | 54 in 1936 | 0 in 1925 | 49 in 1936 | -24 in 1914
2024-12-27 00:00:00 | 51 in 1936 | 5 in 1993 | 40 in 2003 | -23 in 1880
Spreadsheet: 132807d1323955442-managing-team-in-excel-___employeelist
Sheet: Sheet1

 |  |  |  |  |  | Manager | Employee |  | Managers
Manager: | Manager 2 |  |  |  |  | Manager 1 | Emp1 |  | Manager 1
 |  |  |  |  |  | Manager 1 | Emp 2 |  | Manager 2
 | Team Members |  |  |  |  | Manager 1 | Emp 3 |  | Manager 3
 | Emp 5 |  |  |  |  | Manager 1 | Emp 4
 | Emp 6 |  |  |  |  | Manager 2 | Emp 5
 | Emp 7 |  |  |  |  | Manager 2 | Emp 6
 |  |  |  |  |  | Manager 2 | Emp 7
 |  |  |  |  |  | Manager 3 | Emp 8
 |  |  |  |  |  | Manager 3 | Emp 9
 |  |  |  |  |  | Manager 3 | Emp 10
Spreadsheet: 835612d1688678551-conditional-formatting-highlight-cells-based-on-time-monthly-timesheet
Sheet: Example

CCSS Adult Daycare Participant Timesheet
Month: | FEBRUARY
Name: | [NAME]
Date | Time In | Time Out | Total Hours | Days Billed | $ [NAME]
1 | 07:00:00 | 15:00:00 |  | 1
 | 08:00:00 | 11:00:00 |  | 1
 | 08:30:00 | 16:45:00 |  | 1
 | 09:45:00 | 13:35:00 |  | 1
 | 11:00:00 | 16:00:00 |  | 1
 | 09:00:00 | 16:30:00 |  | 1
 | 08:15:00 | 12:00:00 |  | 1
 | 07:55:00 | 13:25:00 |  | 1
 | 10:00:00 | 17:15:00 |  | 1
Example: | 10:00:00 | 17:15:00 |  | 1
Nevada State Medicaid per diem daily rate
$57.20 per day
*Over four (4) hours, CCSS shall pay the full rate |  |  | 57.2
*Four (4) hours or less, CCSS shall pay 1/2 the daily rate |  |  | 28.6
 |  |  |  | Total Days | Invoice Amount
Spreadsheet: 701598d1603831454-adjustment-on-index-match-formula-to-accommodate-more-transactions-students-payment
Sheet: Cash Received

WATERFORD PRIMARY SCHOOL
Date | Student Number | Student Name | Receipt | Invoice | Amount | Notes
2020-01-12 00:00:00 | ST 001 | [NAME] | R010 | C001 | 300
2020-01-13 00:00:00 | ST 002 | [NAME] | R011 | 2 | 2000
2020-01-14 00:00:00 | ST 001 | [NAME] | R012 | 1 | 1000
2020-01-19 00:00:00 | ST 003 | [NAME] | R013 | 3 | 1500
2020-01-20 00:00:00 | ST 004 | O'Neil James | R014 | 4 | 2000
Spreadsheet: 219686d1362877984-counting-occurrences-count_occurances
Sheet: Feb05

INPUT
dates | priority
2011-01-11 00:00:00 | L
2011-01-18 00:00:00 | H |  | OUTPUT
2011-01-18 00:00:00 | L
2011-01-20 00:00:00 | F |  | uniq dates | L | H | F
2011-01-20 00:00:00 | F |  | 2011-01-11 00:00:00 | 1
2012-05-29 00:00:00 | H |  | 2011-01-18 00:00:00 | 1 | 1
2012-05-29 00:00:00 | H |  | 2011-01-20 00:00:00 |  |  | 2
2012-05-29 00:00:00 | H |  | 2012-05-29 00:00:00 | 1 | 3 | 1
2012-05-29 00:00:00 | F
2012-05-29 00:00:00 | L
Spreadsheet: 864622d1711719823-conditional-formatting-to-highlight-percentages-question
Sheet: Sheet1

 |  | Employees | Annual leave used as of today |  |  |  |  | Annual leave entitlement | 50% | 75%
 |  | [NAME] | 14 |  |  |  |  | 25
 |  | [NAME] | 23 |  |  |  |  | 27
 |  | [NAME] | 10 |  |  |  |  | 30
Spreadsheet: 723313d1615625451-index-match-with-multiple-criteria-book1-1-
Sheet: Source Data

Product | Box | Cost | Label | Cost | Bag | Cost
P1 | Box a | - | Label s | - | Bag s | -
P2 | Box b | - | Label s | - | Bag m | -
P3 | Box c | - | Label s | - | Bag l | -
P4 | Box d | - | Label s | - | Bag xl | -