tianzl66/Sheetpedia huggingface dataset:
Spreadsheet: 269367d1381144093-multiple-ifs-query-excel-fletchk-3-oeldere4-
Sheet: Oeldere

 |  |  |  |  | VLOOKUP($G2,$N$5:$O$7,2,0)-VLOOKUP(OFFSET($G2,0,(COUNTA($D2:$G2)-1)*-1,,),$N$5:$O$7,2,0)
 |  |  | [NAME] | Term 2 | Term 3 | Term 4 |  | Progress |  |  |  |  | 40-60a | 3
 |  |  |  |  |  |  |  |  |  |  |  |  | 30-50a | 2
 |  |  |  |  |  |  |  |  |  |  |  |  | 22-36a | 1
 |  |  | In I6 I want to look at the progress from the beginning to the end.
 |  |  | It is always calculated from Term 4 - so it would be term 4 take take 1, however if term 1 is blank, take it from [NAME], however if term 2 is blank take it from term 3, however if term 3 is blank return ""
 |  |  | The v look up table converts the numerical ranges to a number format.
Spreadsheet: 845214d1696749322-vba-hotel-gantt-chart-with-merged-cells-and-details-of-booking-hotel
Sheet: Reservations

Client | Reservation ID | Direct ou Booking | Room No. | [NAME] | Depart Date | Duration | Price per day | Price per stay | No. Adults | No. Children | Cleaning? | Towels? | Tax Rate | Total Tax | Total Price | Deposit 1 | Payment Method | Deposit 2 | Payment Method | Total Deposit | Total to be Paid | PAID
1 [NAME] | 1 | Direct | 12 | 2024-01-01 00:00:00 | 2024-01-10 00:00:00 |  |  |  | 2 | 1 | 30 | 0 | 1 |  |  | 118 | BACS |  |  |  |  | Yes
1 [NAME] | 2 | Direct | 1 | 2024-01-11 00:00:00 | 2024-01-20 00:00:00 |  |  |  | 4 | 1 | 0 | 0 | 1 |  |  | 118 | BACS
4 Karen Douglas | 1 | Direct | 10 | 2024-01-03 00:00:00 | 2024-01-18 00:00:00 |  |  |  | 4 | 0 | 0 | 15 | 1 |  |  | 400 | BACS | 100
5 [NAME] | 1 | Booking | 9 | 2024-01-03 00:00:00 | 2024-01-18 00:00:00 |  |  |  | 4 | 0 | 0 | 15 | 1 |  |  | 400 | BACS | 100
6 [NAME] | 3 | Direct | 12 | 2024-01-10 00:00:00 | 2024-01-20 00:00:00 |  |  |  | 2 | 1 | 30 | 0 | 1 |  |  | 118 | BACS
Spreadsheet: 222601d1363888255-automatically-generated-list-based-on-criteria-test-sheet1
Sheet: Schedules

 |  | Name | Team Leader | Code | From | Too
20130320 | Base | [NAME], [NAME] | [NAME], [NAME] | Open | 11:15:00 | 13:30:00
20130320 | Base | [NAME], [NAME] | [NAME], [NAME] | Break | 13:30:00 | 13:45:00
20130320 | Base | [NAME], [NAME] | [NAME], [NAME] | Open | 13:45:00 | 15:45:00
20130320 | Base | [NAME], [NAME] | [NAME], [NAME] | lunch | 15:45:00 | 16:15:00
20130320 | Base | [NAME], [NAME] | [NAME], [NAME] | Open | 16:15:00 | 18:00:00
20130320 | Base | [NAME], [NAME] | [NAME], [NAME] | Break | 18:00:00 | 18:15:00
20130320 | Base | [NAME], [NAME] | [NAME], [NAME] | Open | 18:15:00 | 19:45:00
Spreadsheet: 0a8791de-84e4-4eb4-bfac-22483612972b
Sheet: Medical Info Tech Cert 1

MEDICAL INFORMATION TECHNOLOGY                 Student Name:
Certificates                                                                     ID #
Medical Unit Coordinator | Semester | Grade
___ BIO 135 (4) Basic Anatomy and Physiology with Laboratory
OR ___ BIO 137 (4) Human Anatomy & Physiology I
AND ___ BIO 139 (4) Human Anatomy & Physiology II
___ CIT 105 (3) Introduction to Computers
___ OST 108 (3) Editing Skills for Office Professionals
OR ___ ENG 101 Writing I
___ OST 110 (3) Document Formatting and Word Processing
___ MIT 230 (3) Medical Information Management
___ MIT 103 (3) Medical Office Terminology
OR ___ AHS 115 (3) Medical Terminology
OR ___ CLA 131 (3) Medical Terminology from Greek and Latin
___ MIT 104 (3) Medical Insurance
___ MIT 217 (3) Medical Office Procedures
___ MIT 227 (3) Medical Office Software
___ MIT 278 (3) Electronic Medical Records
Hospital Admissions Specialist
___ CIT 105 (3) Introduction to Computers
___ OST 108 (3) Editing Skills for Office Professionals
OR ___ ENG 101 Writing I
___ OST 110 (3) Document Formatting and Word Processing
___ OST 235 (3) Business Communications Technology
___ MIT 230 (3) Medical Information Management
___ MIT 103 (3) Medical Office Terminology
OR ___ AHS 115 (3) Medical Terminology
OR ___ CLA 131 (3) Medical Terminology from Greek and Latin
___ MIT 104 (3) Medical Insurance
___ MIT 217 (3) Medical Office Procedures
___ MIT 227 (3) Medical Office Software
___ MIT 278 (3) Electronic Medical Records
Medical Receptionist
___ OST 108 (3) Editing Skills for Office Professionals
OR ___ ENG 101 Writing I
___ OST 110 (3) Document Formatting and Word Processing
___ MIT 230 (3) Medical Information Management
___ MIT 103 (3) Medical Office Terminology
OR ___ AHS 115 (3) Medical Terminology
OR ___ CLA 131 (3) Medical Terminology from Greek and Latin
___ MIT 103 (3) Medical Office Terminology
OR ___ AHS 115 (3) Medical Terminology
OR ___ CLA 131 (3) Medical Terminology from Greek and Latin
Southeast Kentucky Community & Technical College | Updated Spring 2013
Spreadsheet: 109262d1306179412-if-statement-logical-test-prob-finding-n-a-if-statement-help
Sheet: Sheet1

database |  | range of #'s | [NAME] | [NAME] pasted values | Output
100 |  | 95 |  | #N/A
90 |  | 80 |  | 80
80 |  | 65 |  | #N/A
70 |  | 60 |  | 60
60 |  | 75 |  | #N/A
50 |  | 50 |  | 50
Spreadsheet: chris_germany__2125__JanCohCHOICE-ENA
Sheet: Jan 10

 | CES/NPC COH CHOICE NOMINATIONS TO ACTUALS
 | FOR GAS DAY |  |  |  |  |  |  |  | 2001-01-10 00:00:00
 |  | MA | NOM ID |  | FT |  | AT |  | FORECASTED |  | ACTUALS |  | CONTRACT # | % Storage | Over | Sto | [NAME]
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | FT DROP |  | AT DROP
 | COH 3-15 | 22-15 | 3342 |  |  |  |  |  | 365 |  | 495 |  | 67694 |  |  |  |  |  | 29 | 1 | 29
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 30 | 2 | 31
 | COH 5-2 | 23N-02 | 3343 |  |  |  |  |  | 2910 |  | 2589 |  | 67694 |  |  |  |  |  | 30 | 3 | 29 |  |  | 15
 |  |  |  |  |  |  |  |  | 7000 |  | 7000 |  | 68918 | 0 |  |  |  |  | 28 | 4 | 27 |  |  | 23
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 32 | 5 | 30 |  |  | 15
 | COH 5-7 | 23N-07 | 3344 |  |  |  |  |  | 31 |  | 31 |  | 67694 |  |  |  |  |  | 31 | 6 | 30 |  |  | 22
 |  |  |  |  |  |  |  |  | 2400 |  | 2400 |  | 68915 | 0 |  |  |  |  | 30 | 7 | 30 |  |  | 15
 |  |  |  |  |  |  |  |  | 500 |  | 500 |  | 69148 | 0 |  |  |  |  | 31 | 8 | 30 |  |  | 14
 |  |  |  |  |  |  |  |  | 1600 |  | 1600 |  | 69693 | 0 |  |  |  |  | 30 | 9 | 29 |  |  | 20
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 32 | 15 | 29 |  |  | 16
 | COH 7-1 | 23-01 | 3788 |  |  |  |  |  | 2372 |  | 2372 |  | 67694 |  |  |  |  |  | 29 | 35 | 31 |  |  | 17
 |  |  |  |  |  |  |  |  | 85 |  | 85 |  | 68917 | 0 |  |  |  |  | 28 | 39 | 27 |  |  | 17
 |  |  |  |  |  |  |  |  | 1000 |  | 1000 |  | 69149 | 0 |  |  |  |  |  |  |  |  |  | 17
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 22
 | COH 7-3 | 23-03 | 3789 |  |  |  |  |  | 1581 |  | 1681 |  | 67694
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | %
 | COH 7-4 | 23-04 | 3345 |  |  |  |  |  | 1039 |  | 1117 |  | 67694 |  |  |  |  |  | Storage
 |  |  |  |  |  |  |  |  | 1915 |  | 1915 |  | 68916 | 0 |  |  |  |  | #67694
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 0.4
 | COH 7-5 | 23-05 | 2777 |  |  |  |  |  | 6724 |  | 7962 |  | 67694
 | COH 7-6 | 23-06 | 3346 |  |  |  |  |  | 1653 |  | 1760 |  | 67694
 | COH 7-8 | 23-08 | 3790 |  |  |  |  |  | 762 |  | 876 |  | 67694
 | COH 7-9 | 23-09 | 3791 |  |  |  |  |  | 973 |  | 1117 |  | 67694
 | COH 8-35 | 24-35 | 3348 |  |  |  |  |  | 1554 |  | 1398 |  | 67694
 |  |  |  |  |  |  |  |  | 200 |  | 200 |  | 69708 | 0
 |  |  |  |  |  |  |  |  | 1000 |  | 1000 |  | 69823 | 0
 | COH 8-39 | 24-39 | 3792 |  |  |  |  |  | 38 |  | 39 |  | 67694 | 1
 |  |  |  |  |  |  |  |  | 3 |  | 3 |  | 69708 | 0
 |  |  |  |  |  |  |  | x | 1.Nom to COH |  | 1. Email to COH |  |  |  |  |  |  | FOM
 |  |  |  |  |  |  |  | x | 2.Email to ENA |  | 2. Email to ENA |  |  |  |  |  | 27835 | Pull from ENA Pool to NPC Pool
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | [NAME] from/(Sell to) ENA
Spreadsheet: 139697d1328394091-random-list-generation-with-criterea-randomlistanswer
Sheet: Sheet1

Inputs | ODD | EVEN |  |  |  |  | Outputs
1 |  |  |  |  |  |  | 2x ODD |  | 2x EVEN |  | Press [NAME] all below are blank"
2
4
6
9
10
11
15
30 |  |  |  |  |  |  | Example of satisfactory result
31 |  |  |  |  |  |  | 9 | 11 | 2 | 4
32 |  |  |  |  |  |  | 1 | 15 | 6 | 10
33 |  |  |  |  |  |  | 31 | 33 | 10 | 30
43 |  |  |  |  |  |  | 1 | 31 | 30 | 32
45 |  |  |  |  |  |  | 9 | 15 | 4 | 10
54
55
58
60
Spreadsheet: 698172d1601826521-vlookup-with-rank-and-if-tournament
Sheet: 8

[NAME]: |  |  |  |  |  |  | Voor:
Raja paar |  | Mängijate nimed |  |  |  |  |  | [NAME]
12-11 | 1
 | 2
 | 3
14-13 | 1
 | 2
 | 3
16-15 | 1
 | 2
 | 3
10-9 | 1
 | 2
 | 3
16-15 | 1
 | 2
 | 3
 |  | [NAME] tulemus:
 |  | HCP
 |  | [NAME]:
 |  | [NAME]
 |  | V/punkt
[NAME]: |  | _____________________ |  | [NAME]: | ___________________________
Spreadsheet: 873090d1719510900-filter-two-or-more-sheets-with-1-action-financial-sample
Sheet: B

Country | Exports | Year
Canada | 926012 | 2024
Germany | 493054 | 2023
France | 428704 | 2022
Germany | 368953 | 2021
Mexico | 354467 | 2024
Germany | 341100 | 2024
Germany | 336143 | 2022
Canada | 291255 | 2023
France | 205191 | 2023
Spreadsheet: 840742d1692950644-formula-needed-for-different-price-when-brought-at-different-qty-book2-24-1-
Sheet: Sheet1

No of apple | Price | Average Price |  |  |  |  |  |  | Manual Trial & Error |  | [NAME] | Apple Left |  |  | Manual Trial & Error |  | [NAME] | Apple Left
1 | 6 |  |  |  |  |  |  | No of apple | Multiple | Amount |  |  |  | No of apple | Multiple | Amount |  | 87
3 | 17 |  |  |  | No of Apples | 87 |  | 13 | 6 |  |  |  |  | 12 | 7 |  | 84 | 3
5 | 25 |  |  |  | Price |  |  |  | 1 |  |  |  |  | 3 | 1 | 17 | 3 | 0
12 | 55 |  |  |  |  |  |  |  | 1
 |  |  |  |  |  |  |  |  | 1
 |  |  |  |  |  |  |  |  | Total Price |  |  |  |  |  | Total Price | 402
 |  |  |  |  |  |  |  | Is it possible to compute in a single formula?
Spreadsheet: 069e9432-6128-49ac-9493-5b885932c03e
Sheet: Conlin Park

 |  |  |  |  |  | 2013 Conlin Park, Lancaster
 | January |  |  |  |  |  | February |  |  |  |  |  | March
 | Mo | [NAME] | We | Th | Fr |  | Mo | [NAME] | We | Th | Fr |  | Mo | [NAME] | We | Th | Fr
 |  | 1 | 2 | 3 | 4 |  |  |  |  |  | 1 |  |  |  |  |  | 1
 | 7 | 8 | 9 | 10 | 11 |  | 4 | 5 | 6 | 7 | 8 |  | 4 | 5 | 6 | 7 | 8
 | 14 | 15 | 16 | 17 | 18 |  | 11 | 12 | 13 | 14 | 15 |  | 11 | 12 | 13 | 14 | 15
 | 21 | 22 | 23 | 24 | 25 |  | 18 | 19 | 20 | 21 | 22 |  | 18 | 19 | 20 | 21 | 22
 | 28 | 29 | 30 | 31 |  |  | 25 | 26 | 27 | 28 |  |  | 25 | 26 | 27 | 28 | 29
 | April |  |  |  |  |  | May |  |  |  |  |  | June
 | Mo | [NAME] | We | Th | Fr |  | Mo | [NAME] | We | Th | Fr |  | Mo | [NAME] | We | Th | Fr
 | 1 | 2 | 3 | 4 | 5 |  |  |  | 1 | 2 | 3
 | 8 | 9 | 10 | 11 | 12 |  | 6 | 7 | 8 | 9 | 10 |  | 3 | 4 | 5 | 6 | 7
 | 15 | 16 | 17 | 18 | 19 |  | 13 | 14 | 15 | 16 | 17 |  | 10 | 11 | 12 | 13 | 14
 | 22 | 23 | 24 | 25 | 26 |  | 20 | 21 | 22 | 23 | 24 |  | 17 | 18 | 19 | 20 | 21
 | 29 | 30 |  |  |  |  | 27 | 28 | 29 | 30 | 31 |  | 24 | 25 | 26 | 27 | 28
 | July |  |  |  |  |  | August |  |  |  |  |  | September
 | Mo | [NAME] | We | Th | Fr |  | Mo | [NAME] | We | Th | Fr |  | Mo | [NAME] | We | Th | Fr
 | 1 | 2 | 3 | 4 | 5 |  |  |  |  | 1 | 2 |  | 2 | 3 | 4 | 5 | 6
 | 8 | 9 | 10 | 11 | 12 |  | 5 | 6 | 7 | 8 | 9 |  | 9 | 10 | 11 | 12 | 13
 | 15 | 16 | 17 | 18 | 19 |  | 12 | 13 | 14 | 15 | 16 |  | 16 | 17 | 18 | 19 | 20
 | 22 | 23 | 24 | 25 | 26 |  | 19 | 20 | 21 | 22 | 23 |  | 23 | 24 | 25 | 26 | 27
 | 29 | 30 | 31 |  |  |  | 26 | 27 | 28 | 29 | 30 |  | 30
 | October |  |  |  |  |  | November |  |  |  |  |  | December
 | Mo | [NAME] | We | Th | Fr |  | Mo | [NAME] | We | Th | Fr |  | Mo | [NAME] | We | Th | Fr
 |  | 1 | 2 | 3 | 4 |  |  |  |  |  | 1 |  | 2 | 3 | 4 | 5 | 6
 | 7 | 8 | 9 | 10 | 11 |  | 4 | 5 | 6 | 7 | 8 |  | 9 | 10 | 11 | 12 | 13
 | 14 | 15 | 16 | 17 | 18 |  | 11 | 12 | 13 | 14 | 15 |  | 16 | 17 | 18 | 19 | 20
 | 21 | 22 | 23 | 24 | 25 |  | 18 | 19 | 20 | 21 | 22 |  | 23 | 24 | 25 | 26 | 27
 | 28 | 29 | 30 | 31 |  |  | 25 | 26 | 27 | 28 | 29 |  | 30 | 31
 | Every Wednesday.  [NAME] is subject to change.  Call CPFB with questions [PHONE]. Thank you.
 |  |  | Holiday closures. |  |  |  |  | Deliveries. |  |  |  | Inventory - warehouse closures.
Spreadsheet: 606549d1547658928-removing-front-space-bands
Sheet: Sheet1

#
A
[NAME] and the Ants | 1
B
Black Sabbath | 4
[NAME] | 12
C
CCR | 12
Chainsmokers | 3
Clash, The | 5
D
E
EMF | 1
F
Fleetwood Mac | 8
G
Guns N' Roses | 16
H
I
J
K
Kings of [NAME] | 2
L
M
N
O
Outkast | 6
P
[NAME] | 11
Q
R
Red Hot Chili Peppers | 20
Rihanna | 6
S
Steppenwolf | 2
T
[NAME] | 2
U
V
W
X
Y
Z
Avicii | 4
Foster the People | 1
Kygo | 0
[NAME] | 2
Ariana Grande | 3
[NAME] | 11
Imagine Dragons | 6
Spreadsheet: richard_ring__31655__Sample Invoice (10-15-01)
Sheet: Ancillary Cost Calcs

 | Enron Energy Services Operations, Inc.
 | BGE Index Product Ancillary Service Costs - Example Calculations
Maryland Customer
Attn:
 |  | From: | To:
Baltimore, MD |  | 2003-01-01 00:00:00 | 2003-01-31 00:00:00
SITE | Description
 | (A) | (B) | (C) | (D) | (E) | (F) | (G) | (H) | (I) | (J)
 |  |  | Regulation | Operating Reserves | Ancillary Services | PJM Scheduling & Dispatch | RTO Scheduling & Dispatch | Reactive Supply and Voltage Control | Regulation and Frequency Response | Total Ancillary Service Cost
Site 1 | Hour | kWh
 | 1 |  | 0.0001 | 0.0008 | 0.0006 | 0.0007 | 0.0005 | 0.0004 | 0.0002
Spreadsheet: 239160d1369835988-question-about-addin-and-a-special-function-bfes_interest
Sheet: Discrete TS models - trees

Discrete Term Structure Models
Function Names:
BDTtree |  | Computes spot rate tree for BDT model given input bond yields and volatilities
HoLeeTree |  | Computes spot rate tree for Ho/Lee model given input bond yields and volatility
HWTree |  | Computes spot rate tree and probabilities for Hull/White model given input bond yields and volatility
1) Black, [NAME] and Toy |  |  |  |  |  | 2) [NAME] and [NAME]
Time step | 1 | years |  |  |  | Time step | 1 | years
 |  |  |  |  |  | Volatility (bp) | 0.0045
Period | Yield | Volatility
 |  |  |  |  |  | Period | Yield
1 | 0.05 | 0.12
2 | 0.055 | 0.13 |  |  |  | 1 | 0.0399
3 | 0.057 | 0.12 |  |  |  | 2 | 0.0416
4 | 0.059 | 0.11 |  |  |  | 3 | 0.0433
5 | 0.06 | 0.105 |  |  |  | 4 | 0.046
 |  |  |  |  |  | 5 | 0.048
SPOT RATE TREE |  |  |  |  |  | SPOT RATE TREE
0 | 1 | 2 | 3 | 4 |  | 0 | 1 | 2 | 3 | 4
0.05 | 0.06724664314351167 | 0.07941815391271577 | 0.08721207904085881 | 0.08787505483474049 |  | #N/A | #N/A | #N/A | #N/A | #N/A
 | 0.05289808305988643 | 0.06002209862303683 | 0.07117257610631596 | 0.07469088521400329 |  | #N/A | #N/A | #N/A | #N/A | #N/A
 |  | 0.04536308319471945 | 0.05808295875203407 | 0.06348477784216326 |  | #N/A | #N/A | #N/A | #N/A | #N/A
 |  |  | 0.0474007023765873 | 0.053959957846546 |  | #N/A | #N/A | #N/A | #N/A | #N/A
 |  |  |  | 0.04586417641785048 |  | #N/A | #N/A | #N/A | #N/A | #N/A
3) Hull and White
Time step | 1 | years
Volatility (bp) | 0.01
Mean rev. | 0.1
Period | Yield
1 | 0.05
2 | 0.0575
3 | 0.0625
4 | 0.0675
5 | 0.07
6 | 0.0725
SPOT RATE TREE
Probabilities |  |  |  | 0 | 1 | 2 | 3 | 4 | 5
pu | pm | pd
0.8866666666666667 | 0.02666666666666673 | 0.08666666666666656 |  |  |  | 0.1073215161483655 | 0.1175082196795277 | 0.115232336866089 | 0.1204794398584241
0.1216666666666667 | 0.6566666666666666 | 0.2216666666666667 |  |  | 0.08237050807568062 | 0.09000100807267677 | 0.1001877116038389 | 0.09791182879040022 | 0.1031589317827353
0.1666666666666667 | 0.6666666666666666 | 0.1666666666666667 |  | 0.05 | 0.06504999999999185 | 0.072680499996988 | 0.08286720352815011 | 0.08059132071471145 | 0.08583842370704656
0.2216666666666667 | 0.6566666666666666 | 0.1216666666666667 |  |  | 0.04772949192430308 | 0.05535999192129923 | 0.06554669545246133 | 0.06327081263902268 | 0.06851791563135778
0.08666666666666666 | 0.02666666666666673 | 0.8866666666666666 |  |  |  | 0.03803948384561046 | 0.04822618737677256 | 0.0459503045633339 | 0.05119740755566901
Note: This model's rates are defined as continuously compounded interest rates
Spreadsheet: 40074d1238412507-excel-2007-changing-the-value-of-a-cell-via-a-formula-test-book
Sheet: Tech

Tech
 | Conserviative | Bottom 25% | Top 25% | Todays Extremes in Color |  |  | Current
Commodity | Target: Buy | Target: Buy | Target: Sell | Low | High | Range | Current Price | Current Low | Current High
Server Farm |  |  |  |  |  |  | 45
Robotic Pets Company
Video Games Company
E-Commerce Site
Information Technology Site
Call Center
Special Effects Company
Cellular Network
Business Software
Internet Dating Site
Pharmaceuticals Company
CPU Brand
Online Search Company
Global Satellite Network
Spreadsheet: 700444d1603197761-totals-from-two-different-tabs-into-a-third-tab-of-the-same-workbook-ledger-example-revb
Sheet: Credit Cards

Transaction Date | Post Date | Desacrption | Category | Type | Amount | Ref # | Balance
 | 2020-01-05 00:00:00 | Dining Out |  |  | -25 | 6
 | 2020-01-07 00:00:00 | Groceries |  |  | -14 | 7
 | 2020-01-12 00:00:00 | Dining Out |  |  | -28 | 6
 | 2020-01-18 00:00:00 | [NAME] |  |  | -12 | 8
 | 2020-02-04 00:00:00 | Dining Out |  |  | -26 | 6
 | 2020-02-06 00:00:00 | Groceries |  |  | -13 | 7
 | 2020-02-10 00:00:00 | Dining Out |  |  | -22 | 6
 | 2020-02-12 00:00:00 | [NAME] |  |  | -11 | 8
 | 2020-03-04 00:00:00 | Dining Out |  |  | -40 | 6
 | 2020-03-06 00:00:00 | Groceries |  |  | -12 | 7
 | 2020-03-10 00:00:00 | Dining Out |  |  | -24 | 6
 | 2020-03-12 00:00:00 | [NAME] |  |  | -8 | 8
 | 2020-04-04 00:00:00 | Dining Out |  |  | -37 | 6
 | 2020-04-06 00:00:00 | Groceries |  |  | -9 | 7
 | 2020-04-10 00:00:00 | Dining Out |  |  | -23 | 6
 | 2020-04-12 00:00:00 | [NAME] |  |  | -6 | 8
 | 2020-05-04 00:00:00 | Dining Out |  |  | -35 | 6
 | 2020-05-06 00:00:00 | Groceries |  |  | -12 | 7
 | 2020-05-10 00:00:00 | Dining Out |  |  | -18 | 6
 | 2020-05-12 00:00:00 | [NAME] |  |  | -9 | 8
Spreadsheet: 779678d1651993697-xlookup-not-returning-value-due-to-looking-up-dates-sample1a
Sheet: Sheet1

 | Lookup Date: | 2022-02-23 00:00:00
 | Return Field for C4 |  | [NAME] cell as "dddd"
 | [NAME] |  | Using formula=TEXT(C2,"dddd")
 |  | Monday | Tuesday | Wednesday | Thursday | Friday | Saturday | Sunday
 |  | 2022-02-21 00:00:00 | 2022-02-22 00:00:00 | 2022-02-23 00:00:00 | 2022-02-24 00:00:00 | 2022-02-25 00:00:00 | 2022-02-26 00:00:00 | 2022-02-27 00:00:00
 |  | 2022-02-28 00:00:00 | 2022-03-01 00:00:00 | 2022-03-02 00:00:00 | 2022-03-03 00:00:00 | 2022-03-04 00:00:00 | 2022-03-05 00:00:00 | 2022-03-06 00:00:00
 |  | 2022-03-07 00:00:00 | 2022-03-08 00:00:00 | 2022-03-09 00:00:00 | 2022-03-10 00:00:00 | 2022-03-11 00:00:00 | 2022-03-12 00:00:00 | 2022-03-13 00:00:00
 |  | 2022-03-14 00:00:00 | 2022-03-15 00:00:00 | 2022-03-16 00:00:00 | 2022-03-17 00:00:00 | 2022-03-18 00:00:00 | 2022-03-19 00:00:00 | 2022-03-20 00:00:00
Spreadsheet: 81ba464e-0605-4716-9d13-72a1242e261b
Sheet: Sheet1

Sample 4 Year Plan: NEUB Major
 | First Year |  | Second Year |  | Third Year |  | Fourth Year
 | Fall | Spring | Fall | Spring | Fall | Spring | Fall | Spring
Course 1 | BIOL-103 Intro Biology I (5 Cr) | BIOL-104 Intro Biology II 5  Cr) | NEUB Elective (3 Cr) | NEUB Elective (3 Cr) | BIOL-354 Synap. Tr. (3 Cr.) | Language (3 Cr) | BIOL-341 RISE (3 Cr) | BIOL-342 RISE (3 Cr) |  | Required for NEUB Major (28 credits)
Course 2 | Chem-01/09 [NAME] (5 Cr) | [NAME] (5 Cr) | Open (3 Cr.) | BIOL-195 Neurobiology (4 Cr) | Open (3 Cr.) | Open (3 Cr.) | BIOL-370, [NAME] (3 Cr.) | Gen. [NAME]. [NAME] (3 Cr) |  | NEUB electives (21 credits)
Course 3 | Math ([NAME]) | [NAME]. Hum writing (3 Cr) | Gen. [NAME]. Theol. (3 Cr) | Gen. [NAME]. [NAME] (3 Cr) | Language (3 Cr) | BIOL-376 [NAME] (3 Cr) | Gen. [NAME]. [NAME] (3 Cr) | BIOL-380 Sens. Syst. (3 Cr.) |  | General [NAME]
Course 4 | Gen Ed.- Hum writing (3 Cr) | Math ([NAME]) | Language (3 Cr) | Open (3 Cr.) | NEUB Elective (3 Cr.) | NEUB Elective (3 Cr.) | Gen. [NAME]. [NAME] (3 Cr) | Open (3 Cr.) |  | Open Courses
Course 5 |  | [NAME] [NAME] (3 Cr) | Open (3 Cr.) | Language (3 Cr) | Open (3 Cr.) | Open (3 Cr.) | NEUB Elective (3 Cr.) | Open (3 Cr.)
Course 6
Seminar | BIOL-101 [NAME] (1 Cr) |  |  |  |  |  | BIOL-401 (1 Cr)
 |  |  |  |  |  |  |  |  | Total
# of Courses | 4 | 5 | 5 | 5 | 5 | 5 | 5 | 5
NEUB elective credits | 0 | 0 | 3 | 3 | 3 | 3 | 6 | 3
Total # of Credits | 18 | 20 | 15 | 16 | 15 | 15 | 15 | 15
Sample 4 Year Plan: NEUB Major/Premed.
 | First Year |  | Second Year |  | Third Year |  | Fourth Year
 | Fall | Spring | Fall | Spring | Fall | Spring | Fall | Spring
Course 1 | BIOL-103 Intro Biology I (5 Cr) | BIOL-104 Intro Biology II (5 Cr) | NEUB Elective (3 Cr) | NEUB Elective (3 Cr) | BIOL-354 Synap. Tr. (3 Cr.) | Language (3 Cr) | BIOL-341 RISE (3 Cr) | BIOL-342 RISE (3 Cr) |  | Required for NEUB Major (28 credits)
Course 2 | Chem-01/09 [NAME] (5 Cr) | [NAME] (5 Cr) | Open (3 Cr.) | BIOL-195 Neurobiology (4 Cr) | Physics (4 Cr) | [NAME] (4 Cr) | BIOL-370, [NAME] (3 Cr.) | Gen. [NAME]. [NAME] (3 Cr) |  | NEUB electives (21 credits)
Course 3 | Math ([NAME]) | [NAME]. Hum writing (3 Cr) | Gen. [NAME]. Theol. (3 Cr) | Gen. [NAME]. [NAME] (3 Cr) | Language (3 Cr) | BIOL-376 [NAME] (3 Cr) | Gen. [NAME]. [NAME] (3 Cr) | BIOL-380 Sens. Syst. (3 Cr.) |  | General [NAME]
Course 4 | Gen Ed.- Hum writing (3 Cr) | Math ([NAME]) | Language (3 Cr) | Orgo (5 Cr) | NEUB Elective (3 Cr.) | NEUB Elective (3 Cr.) | Gen. [NAME]. [NAME] (3 Cr) | Open (3 Cr.) |  | Open Courses
Course 5 |  | [NAME] [NAME] (3 Cr) | Orgo (5 Cr) | Language (3 Cr) | Open (3 Cr.) | Course Release for MCAT | NEUB Elective (3 Cr.) | Open (3 Cr.) |  | Premed. Requirements
Course 6
Seminar | BIOL-101 [NAME] (1 Cr) |  |  |  |  |  | BIOL-401 (1 Cr)
 |  |  |  |  |  |  |  |  | Total
# of Courses | 4 | 5 | 5 | 5 | 5 | 4 | 5 | 5
NEUB elective credits | 0 | 0 | 3 | 3 | 3 | 3 | 6 | 3
Total # of Credits | 18 | 20 | 17 | 18 | 16 | 13 | 14 | 15
Spreadsheet: 113389d1309305154-place-data-from-sheet1-into-first-empty-row-on-sheet2-place-data-from-sheet1-into-first-empty-row-on-sheet2
Sheet: Sheet2

Row # | Date of Claim | Call Ref | Reason for Claim | Customer | Time Finished on Site | Time At Home | x1.5 or x2 | Hours to be Paid | Standby Payments
Spreadsheet: 142263d1329758041-need-help-with-copying-rows-of-data-from-a-table-in-one-sheet-to-another-worksheet-new-payroll
Sheet: Key

Name | Rate | Hourly rate | day | Job Site
[NAME] | 100 | 12.5 | Friday | [NAME]'s House
alvaro | 0 | 0 | Saturday | [NAME] beach
anselmo | 150 | 18.75 | Sunday | Rockaway
Arturo | 70 | 8.75 | Monday | Grote
brick | 0 | 0 | Tuesday | Banner Ave
dominicano | 80 | 10 | Wednesday | Harman
ecko | 140 | 17.5 | Thursday | [NAME]
francisco | 140 | 17.5
geraldo | 140 | 17.5
hendro | 100 | 12.5
[NAME] | 140 | 17.5
hugo | 140 | 17.5
[NAME] brick | 140 | 17.5
jay | 70 | 8.75
[NAME] | 200 | 25
[NAME] | 100 | 12.5
[NAME] | 140 | 17.5
June | 180 | 22.5
[NAME] | 100 | 12.5
Kosta | 100 | 12.5
[NAME] | 150 | 18.75
mara | 120 | 15
mario painter | 130 | 16.25
[NAME] | 100 | 12.5
Nemo | 100 | 12.5
old man labor | 70 | 8.75
pablo | 100 | 12.5
painters | 0 | 0
pedro | 140 | 17.5
Philipe | 140 | 17.5
Pisirco | 150 | 18.75
Puma | 140 | 17.5
[NAME] | 140 | 17.5
roofers | 0 | 0
[NAME] | 100 | 12.5
[NAME] | 100 | 12.5
[NAME] | 80 | 10