tianzl66/Sheetpedia huggingface dataset:
Spreadsheet: 840003d1692356074-producing-a-table-from-data-on-another-sheet-within-a-specific-time-frame-test2-4-aligw
Sheet: Sheet2

Workload
Job Number | Status | Project Name | Current LBE | Finish | DLA | Estimating Status
10001 | Live Tender | X1 | 1000000 | 2023-04-13 00:00:00 | 2023-09-12 00:00:00 | Ready for Review
10001 | Live Tender | X2 | 1000000 | 2023-07-27 00:00:00 | 2023-08-16 00:00:00 | DLA Achieved and Issued
10001 | Live Tender | X3 | 1000000 | 2023-07-28 00:00:00 | 2023-08-17 00:00:00 | DLA Achieved and Issued
10001 | Live Tender | X4 | 1000000 | 2023-07-28 00:00:00 | 2023-08-15 00:00:00 | DLA Achieved and Issued
10001 | Live Tender | X5 | 1000000 | 2023-08-04 00:00:00 | 2023-09-07 00:00:00 | Not Started
10001 | Live Tender | X6 | 1000000 | 2023-08-11 00:00:00 | 2023-08-24 00:00:00 | In Progress
10001 | Live Tender | X7 | 1000000 | 2023-08-11 00:00:00 | 2023-08-24 00:00:00 | In Progress
10001 | Live Tender | X2 | 1000000 | 2023-07-27 00:00:00 | 2023-08-16 00:00:00 | DLA Achieved and Issued
10001 | Live Tender | X3 | 1000000 | 2023-07-28 00:00:00 | 2023-08-17 00:00:00 | DLA Achieved and Issued
10001 | Live Tender | X4 | 1000000 | 2023-07-28 00:00:00 | 2023-08-15 00:00:00 | DLA Achieved and Issued
Spreadsheet: 148396d1333386915-creating-a-report-to-show-vehicle-tax-due-tax-disc-log
Sheet: PN60 FCD

 |  |  |  |  | PN60 FCD
Registration number : | PN60 FCD |  | Date Taxed | Duration | Tax Expiry  Date | Cost (£)
Manufacturer : | MAN |  |  | 12 Months | 2011-11-01 00:00:00 | 650
Specification : | 6 x 2 RTC (3 Axle) |  | 2011-10-31 00:00:00 | 12 Months | 2012-11-01 00:00:00 | 650
Type : | TGX 26.360
1st Registered : | 01.11.10
Engine : | D2066 LF 42
[NAME] : | 26,000kg
Back To Index
Spreadsheet: 327978d1403749360-find-number-in-array-that-is-less-than-index-match-number-in-array-less-than-index-match
Sheet: Sheet1

 |  |  | Change values here è | 5.3
15 |  |  | Result è
14
13
12
11
10
9
8
7
6
5
4
3
2
1
0
-1 | 100
-2
-3
Spreadsheet: 271911d1382105028-sum-values-from-different-sheets-to-summary-sheet-sum-values
Sheet: Qtr3

Our Global Company
[NAME], Third Quarter
Sales Group: | Consulting: | Marketing: | Outsourcing: | Bundling:
Northeast | 2752.177680819292 | 9020.290032896519 | 8575.83573065182 | 2383.830582191724
Southeast | 3457.018427036483 | 3930.924166631473 | 9607.631601141002 | 2575.810346103327
Northwest | 8550.528721095754 | 9591.935456691332 | 5189.546259000864 | 2947.804315946852
Southwest | 2284.157078680045 | 34.4896724944288 | 7990.651040570924 | 5130.338982178424
TOTAL
Spreadsheet: 7f4f71ab-4fec-4148-9937-9f21486049fa
Sheet: 14b

Product1 | HY6 | IG | Other | TOTAL
Index Tranche | 0 | 4 | 0 | 4
Index | 2247 | 2906 | 9047 | 14200
Other | 0 | 0 | 38 | 38
TOTAL | 2247 | 2910 | 9085 | 14242
Spreadsheet: 842850d1694826502-how-to-i-lookup-a-calculated-value-in-one-sheet-that-matches-a-value-on-another-sheet-example-default-formula-changed-mgianzero-
Sheet: Charged

 |  |  |  |  | TOTALS:
Date | Start Time | End Time | Duration | Duration (Rounded) | Overtime | Amount Due #1 | Amount Due #2
2023-01-01 00:00:00 | 05:59:00 | 08:22:00
2023-01-02 00:00:00 | 09:21:00 | 11:37:00
2023-01-03 00:00:00 | 06:00:00 | 08:23:00
Spreadsheet: 758023d1638576039-calculate-monthly-salary-based-on-hire-date-additional-headcount-charge
Sheet: People requests

Person | Description | Yearly Salary | EV % | EV $ | Est. Time frame | Notes |  | 2022-01-31 00:00:00
Project Manager | Project Manager for job management / tracking | 100000 | 1 |  | 2022-01-15 00:00:00 | Support Program Manager |  | 0 | 0 | 0
Engineer | Mid level network professional to assist on integrations, support network IP configurations | 85000 | 1 |  | 2022-03-01 00:00:00 |  |  |  |  | 0
Construction Project Manager | Additional resource | 90000 | 0.5 |  | 2022-05-15 00:00:00 | Typically CGS 50% EV work 50% X
Construction Manager | Experienced EV w/ build, testing, mgmt experience | 80000 | 0.9 |  | 2022-05-15 00:00:00 | 90% job costable - If needed based on workload - COGS
[NAME] Assistant | Additional resource | 50000 | 1 |  | 2022-02-01 00:00:00 | Support EV Team
TOTAL |  |  | EV Usage: |  | Count:
Spreadsheet: 98201d1297209120-possibly-an-easy-question-just-cant-figure-it-out-book1_paulishuku
Sheet: Sheet1

Assest ID | Total Downtime in Minutes
40 | 5 |  |  | Your Thread > | Possibly an easy question, just cant figure it out.
50 | 10
60 | 15
70 | 20
80 | 25
90 | 350
100 | 370
110 | 390
120 | 410
130 | 430
140 | 345
150 | 225
160 | 235
170 | 70
180 | 75
Spreadsheet: 740103d1626185533-filtering-a-row-and-returning-the-results-and-other-columns-to-another-sheet-book3
Sheet: Sheet2

 | DESIRE
 | I wanted to filter Column G>0 (FROM tab RAW) and return the results of the column (G) and other other columns mentioned below
 | EXPECTED RESULTS
COLUMN A | COLUMN U | COLUMN G | COLUMN F | COLUMN M | COLUMN N | COLUMN D | COLUMN L
Advert Id | Site | Unfilled Ending within 7 Days | No. Of Vacancies | Employer Name | Job Title | Created At | Closing Date
 | (Assending order A-z)
201525 | [NAME] | 3 | 4 | First Years Childcare Ltd | Nursery Practitioners | 2021-02-10 00:00:00 | 2021-07-12 00:00:00
201530 | [NAME] | 3 | 4 | First Years Childcare Ltd | Nursery Practitioners | 2021-02-10 00:00:00 | 2021-07-12 00:00:00
201549 | [NAME] | 1 | 1 | Cherry Red Records LTD | Label Assistant | 2021-02-16 00:00:00 | 2021-07-09 00:00:00
201965 | Fulham | 2 | 2 | D&D London Ltd. | BOH Kickstart | 2021-03-17 00:00:00 | 2021-07-11 00:00:00
201636 | Harlesden | 3 | 5 | STERLING WINSHAW SOLICITORS LTD | OFFICE ASSISTANT | 2021-02-22 00:00:00 | 2021-07-14 00:00:00
201654 | Harlesden | 1 | 5 | STERLING WINSHAW SOLICITORS LTD | LEGAL ASSISTANT | 2021-02-22 00:00:00 | 2021-07-14 00:00:00
201958 | Harlesden | 2 | 2 | Living Spring Nursery | Nursery Assistant | 2021-03-09 00:00:00 | 2021-07-07 00:00:00
201968 | Harlesden | 6 | 10 | STERLING WINSHAW SOLICITORS LTD | SOCIAL MEDIA ASSISTANT | 2021-02-22 00:00:00 | 2021-07-14 00:00:00
201972 | Harlesden | 9 | 10 | STERLING WINSHAW SOLICITORS LTD | MARKETING ASSISTANT | 2021-02-22 00:00:00 | 2021-07-14 00:00:00
201766 | [NAME] | 2 | 8 | Aarti Consulting Services Limited | Data Entry Assistant | 2021-03-08 00:00:00 | 2021-07-12 00:00:00
201944 | [NAME] | 1 | 2 | Aarti Consulting Services Limited | Project Admin Assistant | 2021-03-08 00:00:00 | 2021-07-12 00:00:00
201521 | [NAME] | 1 | 1 | Lords Builders Merchants Holdings Limited | Assistant Forklift Truck Driver | 2021-02-04 00:00:00 | 2021-07-09 00:00:00
201571 | [NAME] | 2 | 2 | [NAME] | Insulation fixer | 2021-02-18 00:00:00 | 2021-07-14 00:00:00
201581 | [NAME] | 2 | 2 | [NAME] | [NAME] Fixer | 2021-02-18 00:00:00 | 2021-07-14 00:00:00
201739 | Hounslow | 1 | 2 | Metroline Limited | Operations Support Assistant | 2021-03-03 00:00:00 | 2021-07-10 00:00:00
201971 | Hounslow | 7 | 8 | Cranford Community College | Teaching Assistant | 2021-05-20 00:00:00 | 2021-07-09 00:00:00
201967 | Kingston | 1 | 1 | COMFORT CARE AT HOME LIMITED | Communication and Social Media Trainee | 2021-03-18 00:00:00 | 2021-07-07 00:00:00
201960 | [NAME] | 1 | 1 | do not use  Achieving for Children | AfC [NAME] Youth Worker | 2021-03-12 00:00:00 | 2021-07-09 00:00:00
Spreadsheet: 703830d1605189712-populating-a-weekly-schedule-based-on-criterias-with-formula-covidscheduleoffice
Sheet: Sheet1

 |  |  | A: Custom (added manually, so empty)
 |  |  | B: Mondays and Wednesdays, every second friday on even week numbers.
 |  |  | C: Tuesdays and Thursdays, every second friday on odd week numbers.
 |  |  | D: One week at the office (full week), next week at home. |  |  | week 1 |  |  |  |  | week 2 |  |  |  |  | week 3
 |  |  |  |  | Schedule option | Monday | Tuesday | Wednesday | Thursday | Friday | Monday | Tuesday | Wednesday | Thursday | Friday | Monday | Tuesday | Wednesday | Thursday | Friday
 |  |  |  | Person 1 | B | X |  | X |  |  | X |  | X |  | X | X |  | X
 |  |  |  | Person 2 | C |  | X |  | X | X |  | X |  | X |  |  | X |  | X | X
 |  |  |  | Person 3 | C |  | X |  | X | X |  | X |  | X |  |  | X |  | X | X
 |  |  |  | Person 4 | B | X |  | X |  |  | X |  | X |  | X | X |  | X
 |  |  |  | Person 5 | D | X | X | X | X | X |  |  |  |  |  | X | X | X | X | X
 |  |  |  | Person 6 | A
 |  |  |  |  |  | Grey field filled in with X based on F (Schedule option) and even/odd week number.
 |  |  |  |  |  | Extra: to lock cells that shouldn't be able to be filled in (not necessary)
Spreadsheet: 81060d1281344719-counting-total-hours-for-breaks-training-at-half-hour-intervals-sampleworkbook
Sheet: Data Source

Segment_Start | Segment Finish | Segment Code | Name
14:00:00 | 14:30:00 | BREAK | [NAME]
15:00:00 | 15:30:00 | BREAK | Fred
16:00:00 | 17:00:00 | BREAK | George
16:00:00 | 16:30:00 | BREAK | [NAME]
17:00:00 | 17:30:00 | TRAINING | [NAME] |  | <--Data source contains various segment codes and the start/finish times
18:00:00 | 18:30:00 | TRAINING | George
19:00:00 | 19:30:00 | TRAINING | Fred
Spreadsheet: mary_fischer__25637__31T
Sheet: E14.XLS

ENRON CORP AND CONSOLIDATED SUBSIDIARIES
COMPANY # 031T
ANALYSIS OF OTHER DEFERRED CREDITS
 |  |  |  |  |  |  |  |  |  |  |  |  |  | E-14
 |  | 12-31-2000 Balance |  |  |  | Charged to |  | Transfer / Reclasses
[NAME] |  | DR. (CR.) |  | Cash Pd / (Rec'd) |  | Income Statement |  | Amount |  | Hyperion Acct. # |  | DR. (CR.)
 |  | BEGINNING BALANCE |  | DR. (CR.) |  | DR. (CR.) |  | DR. (CR.) |  | to / from |  | ENDING BALANCE |  | COMMENTS
(1)  PROVIDE DETAIL OF INDIVIDUAL ITEMS IN EXCESS OF $200,000
(2)  USE COMMENTS SECTION TO PROVIDE AN EXPLANATION OF WHY ANY REVENUE
ITEMS ARE DEFERRED AND WHAT EVENT WILL CAUSE REVENUE RECOGNITION
OTHER DEFERRED CREDITS:
 |  | 0
Total (Hyperion line 0860)
Asset/Expense Accts:  DR/(CR)
Reverse signs from Hyperion
 |  |  |  |  |  |  |  |  |  |  |  |  |  | E-14
Spreadsheet: aeef6be6-03e0-4af8-9f2b-4a4ef98d3d78
Sheet: Sheet1

FEBRUARY | Units are no longer allowed to bring their own firewood to camp | Unnamed: 2 | Unnamed: 3 | Unnamed: 4 | Unnamed: 5 | Unnamed: 6 | 2014-08-19 00:00:00
CHARTS ARE UPDATED DAILY. FOR UP TO THE MINUTE AVAILABILITY CALL (716) 891-4073 OR E-MAIL [EMAIL]
SCHOELLKOPF |  |  |  | 2015 | 2015 | 2015 | 2015
 | Capacity | Code | FEE | FEB 6 - 8 | FEB 13 - 15 | FEB 20 - 22 | FEB 27 - MAR 1
District/Council Events
**Phillip (Lower) | 8 | S,W,E | 48
**Schoellkopf (Upper) | 12 | S,W,E | 72
Schwartz | 14 | S,W | 70 |  |  |  | T58 W
Score | 18 | S,W,E | 108 | T457 | T457
**Self | 12 | S,W,E | 72
Sikes | 16 | S,W,E, | 96
**Toulmin | 18 | S,W,E | 108
Lean-To's
**Art Wood (Flats) | 12 | W | 48 |  |  | T931 W
**[NAME] (Northwoods) | 12 | W | 48
**Seibel (Northwoods) | 12 | W | 48
**Faso (Meyer Village) | 12 | W | 48
**[NAME] (Meyer Village) | 12 | W | 48
**[NAME] (Meyer Village) | 12 | W | 48
Troop 7 Shelter | 20 | S,W,E | 96
**Szymkowiak lean-to | 12 | W, E | 72
Tenting    $2 per person per night
Tenting    $2 per person per night
Tenting    $2 per person per night
**SEASONAL [NAME] MAY BE CLOSED FOR VEHICLE TRAFFIC, PLEASE CONTACT THE RANGER AT [PHONE]
SCOUTHAVEN |  |  |  | 2015 | 2015 | 2015 | 2015
 | Capacity | CODE | FEE | FEB 6 - 8 | FEB 13 - 15 | FEB 20 - 22 | FEB 27 - MAR 1
District/Council Events
[NAME] | 20 | S,W,E | 120
Loegler 1 | 20 | C,S,W,E | 120
Loegler 2 | 20 | C,S,W,E | 120
[NAME] | 30 | C,S,W,E | 180
Lean-To's
#1 Eagle | 12 | W | 48
#2 Whitetail | 12 | W | 48
#3 Dziedzic | 12 | W | 48
Moose | 10 | W | 40
Boss | 12 | W | 48
Tenting    $2 per person per night
Day Hike  $2 per person
[NAME] |  |  |  | 2015 | 2015 | 2015 | 2015
 | Capacity | CODE | FEE | FEB 6 - 8 | FEB 13 - 15 | FEB 20 - 22 | FEB 27 - MAR 1
District/Council Events |  |  |  |  | OA WINTER FELLOWSHIP
Cabin #1 | 24 | S,W,E | 144 |  | OA
Cabin #2 | 24 | S,W,E | 144
Leader's Lodge | 28 | S,W,E | 168 |  | OA
[NAME] | 30 | C,S,W,E | 180
Lean-To's
Stone Lean-To | 6 | [NAME] | 24
Troop 107 Shelter | 8 | W | 30
Ganosote Lean-To | 12 | W | 48
[NAME] | 12 | W | 48
[NAME] To | 12 | W | 48
Tenting    $2 per person per night
Tenting    $2 per person per night
Day Hike  $2 per person
Code: S=Cooking Stove; W=Wood Heating Stove; E=Electricity; C=Co-Ed Ready
Firewood is $50.00 per 1/2 face cord.
Spreadsheet: 83062d1283110727-excel-2007-penalties-for-cross-country-book1
Sheet: Sheet1

No | Start Time | Finish Time | Time Taken | Penalties
1 | 11:00:00 | 11:06:15
2 | 11:02:00 | 11:08:50
3 | 11:04:00 | 11:09:20 |  |  |  | 2860 | metres - Course distance
4 | 11:06:00 | 11:19:30
5 |  |  |  |  | say | 06:30:00 | minutes - Optimum Time (calculated seperately) |  |  |  |  | It would be nice if I could just type 6:30
6
7 |  |  |  |  |  | 0.4 | Penalty points - every second in excess of Optimum Time
8
9 |  |  |  |  |  |  | Minimum Time               = Course Distance: |  |  |  |  | metres / 520 metres per minute
10
11 |  |  |  |  |  | 1 | Penalty point - Every commenced second faster than a speed of 520m per minute (the Minimun Time)
12 |  |  |  |  |  |  | In other words, they get penalised if they go too fast:
13
14
15 |  |  |  |  |  | E | Elimination for exceeding the Time Limit (which is twice the optimum time)
16
17 |  |  |  |  |  | Note to self:
18 |  |  |  |  |  | Use auto-correct to change full stop to colon for entering times:
19
20
21
22
23
24
25
26
27
28
29
30
31
32
33
34
35
36
37
38
39
40
41
42
43
44
45
46
47
48
49
50
51
52
53
54
55
56
57
58
59
60
61
62
63
64
65
66
67
68
69
70
71
72
73
74
75
76
77
78
79
80
81
82
83
84
85
86
87
88
89
90
91
92
93
94
95
96
97
98
99
100
101
102
103
104
105
106
107
108
109
110
111
112
113
114
115
116
117
118
119
120
121
122
123
124
125
126
127
128
129
130
131
132
133
134
135
136
137
138
140
141
142
143
144
145
146
147
148
149
150
151
152
153
154
155
156
157
158
159
160
161
162
163
164
165
166
167
168
169
170
Spreadsheet: phillip_m_love__30658__9910_OA
Sheet: TOTAL

ENRON CAPITAL & TRADE RESOURCES
OPERATIONAL ANALYSIS - CONSOLIDATED VARIANCE
COMPANY:  ALL
REGION: ALL
 |  |  | Reported |  | Actuals |  | [NAME]
 |  |  | Volume | $'s | Volume | $'s | Volume | $'s
 | Sales:
1 |  | 3rd Party / Inter Enron
2 |  | Liquidations
3 |  | Interdesk
4 |  | Option Premiums
5 |  | Dmd Reimbursements
 | Total Sales:
 | Purchases:
6 |  | 3rd Party / Inter Enron
7 |  | Liquidations
8 |  | Interdesk
9 |  | Option Premiums
10 |  | [NAME]
 | Total Purchases:
 | Intra CTS (EGM / HPL / LRC):
11 |  | Sales
12 |  | Purchases
 | Total Intra CTS Sales / Purchases
 | Imbalances:
13 |  | In Kind
14 |  | Cash Out
15 |  | Cash In
16 |  | Synthetic Storage
 | Total Imbalances:
 | Storage:
17 |  | Injection (Sales to Stg)
18 |  | W/D (Purchase from Stg)
19 |  | Inventory Profit
 |  | Total W/D
 | Total Storage:
20 | Linepack:
21 | Shrinkage:
22 | UA4:
23 | Fuel:
 | Transport Expense:
24 |  | Commodity
25 |  | Demand
 | Total Transport Expense:
 | Transport Revenue:
26 |  | Interstate
27 |  | Intrastate
 | Total Transport Revenue:
 | Intra CTS (EGM / HPL / LRC):
28 |  | Transport Expense
29 |  | Transport Revenue
 | Total Intra CTS Transport
 | Tie Out Schedule Items:
 |  | MTM Income:
30 |  | Current Gross Book Balance
31 |  | Prior Month Book Balance
 |  | Total MTM Income
32 |  | Prudency
33 |  | Financial Liquidations
34 |  | Originations
35 |  | Broker Fees
36 |  | Asset Group Demand Charges
37 |  | [NAME]
38 |  | Interdesk Charges
39 |  | Canada
40 |  | Miscellaneous
 |  | TOTAL
FT-Ontario
 |  | Current Month MTM
 |  | Financial Liquidations
 |  | Originations
 |  | TOTAL FIRM TRADING
 |  | TOTAL GL
Spreadsheet: 4f0e57d8-c8ce-4ed7-af8f-48709c6e39de
Sheet: TIG Cohort 1 Yr 4 

Grant: |  | Tiered Intervention Grant Cohort 1
CFDA # |  | 84.377
GRANT NUMBER: |  | 7377
FISCAL YEAR: |  | 2013-14
[NAME]: |  | Not allowed on this grant
Question regarding payments: |  | [NAME]-866-6724 or [EMAIL]
Questions regarding grant: |  | [NAME]6389 or [EMAIL]
LAST DAY TO SUBMIT REQUESTS FOR THIS GRANT  - Septebmer 15, 2014
Code | School Name | ALLOCATION | PAYMENTS TO DATE | BALANCE | JULY  2013 | AUGUST  2013 | SEPTEMBER  2013 | OCTOBER  2013 | NOVEMBER  2013 | DECEMBER  2013 | JANUARY  2014 | FEBRUARY  2014 | [NAME]  2014 | APRIL  2014 | MAY  2014 | JUNE  2014 | JULY  2014 | AUGUST  2014 | SEPTEMBER  2014
1454-S | Central High School | 228583 |  |  |  |  |  |  |  | 21900 | 15081 | 25790
1686-S | Clifton Elementary School | 123416 |  |  |  |  |  |  |  |  | 2826 | 2056 | 6184
3054-S | Fort Logan Elementary | 61353 |  |  |  |  |  |  |  | 16771
3638-S | [NAME] | 276421
4376-S | Risley International Academy of Innovation | 146060 |  |  |  |  |  |  |  | 25526
5048-S | Pueblo Academy of Arts | 316314 |  |  |  |  |  |  |  | 63089
6314-S | North High School | 266513
Spreadsheet: 778857d1651402523-if-formula-if-cell-values-are-same-as-multiple-others-and-day-is-today-if-formula-example-chart
Sheet: list of all dates

Activity | Time | Person | Outcome | Date
Swimming | 13:00:00 | [NAME] | Completed | 2022-04-30 00:00:00
Gym | 14:00:00 | [NAME] | Not completed | 2022-04-30 00:00:00
Tennis | 15:00:00 | [NAME] | Not completed | 2022-04-30 00:00:00
Swimming | 13:00:00 | [NAME] | Not completed | 2022-05-01 00:00:00
Gym | 14:00:00 | [NAME] | Completed | 2022-05-01 00:00:00
Tennis | 15:00:00 | [NAME] | Completed | 2022-05-01 00:00:00
Spreadsheet: 66045d1266679729-making-a-word-or-phrase-in-one-worksheet-do-a-function-on-a-different-worksheet-master
Sheet: Mon

Technican | ACCT# | Address | Zip | Install Date | Service call date | Days old | Reason for T/C | Resolution
6402 | 645654 | 1000 hilltop st | 18641 | 2010-02-11 00:00:00 | 2010-02-20 00:00:00 |  | DIGI PRB
6402 | 618187 | 1 [NAME] | 18517 | 2010-02-15 00:00:00 | 2010-02-19 00:00:00 |  | VOD
6414 | 312645 | ASWELL ST | 18571 | 2010-02-18 00:00:00 | 2010-02-19 00:00:00 |  | NO PIX
6423 | 314561 | IRVING | 18644 | 2010-01-22 00:00:00 | 2010-02-19 00:00:00 |  | CDV CALQ
6466 | 235783 | CAPOUSE | 18664 | 2010-01-26 00:00:00 | 2010-02-19 00:00:00 |  | HDTV
6465 | 325987 | JERSEY ST | 18998 | 2010-02-15 00:00:00 | 2010-02-19 00:00:00 |  | DVR
6472 | 215879 | NEW ST | 18751 | 2010-02-14 00:00:00 | 2010-02-19 00:00:00 |  | HSI OUT
6414 | 265896 | HIGH ST | 18752 | 2010-01-29 00:00:00 | 2010-02-19 00:00:00 |  | HSI OUT
6423 | 235352 | BOOKING | 15875 | 2010-01-27 00:00:00 | 2010-02-19 00:00:00 |  | CDV CALQ
6409 | 123587 | NIGHT LN | 14587 | 2010-02-01 00:00:00 | 2010-02-19 00:00:00 |  | POOR PIX
6402 | 123654 | VICKTORY CT | 18851 | 2010-01-29 00:00:00 | 2010-02-19 00:00:00 |  | CONV PRB
Spreadsheet: 699913d1602825395-correcting-index-match-formula-students-receivables-ledger
Sheet: Cash Received

WATERFORD PRIMARY SCHOOL
Date | Student Number | Student Name | Receipt | Invoice | Amount | Notes
2020-01-12 00:00:00 | ST 001 | [NAME] | 100 | 210 | 300
2020-01-13 00:00:00 | ST 002 | [NAME] | 200 | 2 | 2000
2020-01-14 00:00:00 | ST 001 | [NAME] | 300 | 1 | 1000
2020-01-19 00:00:00 | ST 003 | [NAME] | 400 | 3 | 1500
2020-01-20 00:00:00 | ST 004 | O'Neil James | 500 | 4 | 2000
2020-02-01 00:00:00 | ST 001 | [NAME] | 600 | 1 | 1000
Spreadsheet: 56769d1256861371-kind-of-complicated-different-excel-sheets-linked-but-not-working-in-older-excel-exercices
Sheet: Ex 1

Mot anglais | Traduction 1 | Traduction 2 | Traduction 3 | Traduction 4 | Stephen | Colonne1 | [NAME] | Colonne2
table | table | * | * | *
wall | mur | * | * | *
phone | telephone | * | * | *
to break | casser | * | * | *
home | maison | * | * | *
armchair | fauteuil | * | * | *
lounge | salon | * | * | *
kitchen | cuisine | * | * | *
bedroom | chambre à coucher | * | * | *
read | lire | * | * | *
write | ecrire | * | * | *
eat | manger | * | * | *
take | prendre | * | * | *
desk | bureau | * | * | *
keep | conserver | * | * | *
pen | stylo | * | * | *
wallet | portefeuille | * | * | *
understand | comprendre | * | * | *
translate | traduire | * | * | *
book | livre | * | * | *
 |  |  |  |  | Résultat |  | Résultat
 |  |  |  |  | Décôte |  | Décôte
 |  |  |  |  | Note |  | Note
 |  |  |  |  | Note affichée |  | Note affichée
Titre leçon | Le bureau
Afficher résultats = 1 | 1
Spreadsheet: 113675d1309514921-looking-up-maximum-valus-in-a-cell-range-book2-mahju
Sheet: Sheet1

Highest Date range |  |  |  |  | Dates | HUK | HBUK | IMG | Bentley | MAN | BMW | HBE | HNL
HUK | 5 | 2010-10-09 00:00:00 | G |  | 2010-10-01 00:00:00 | 1 | 4 | 1 | 7 | 4 | 10 | 4 | 4
HBUK | 7 | 2010-10-11 00:00:00 | H |  | 2010-10-02 00:00:00 | 1 | 4 | 1 | 7 | 4 | 9 | 4 | 4
IMG | 2 | 2010-10-18 00:00:00 | I |  | 2010-10-03 00:00:00 | 1 | 4 | 1 | 7 | 5 | 9 | 4 | 5
BGBL | 8 | 2010-10-12 00:00:00 | J |  | 2010-10-04 00:00:00 | 1 | 2 | 1 | 7 | 3 | 9 | 2 | 3
MAN | 9 | 2010-10-15 00:00:00 | K |  | 2010-10-05 00:00:00 | 1 | 2 | 1 | 7 | 3 | 8 | 2 | 3
BMW | 10 | 2010-10-01 00:00:00 | L |  | 2010-10-06 00:00:00 | 2 | 3 | 1 | 7 | 2 | 7 | 3 | 2
HBE | 7 | 2010-10-11 00:00:00 | M |  | 2010-10-07 00:00:00 | 1 | 1 | 1 | 5 | 1 | 7 | 1 | 1
HNL | 9 | 2010-10-15 00:00:00 | N |  | 2010-10-08 00:00:00 | 4 | 1 | 1 | 5 | 2 | 7 | 1 | 2
 |  |  |  |  | 2010-10-09 00:00:00 | 5 | 2 | 1 | 4 | 3 | 5 | 2 | 3
 |  |  |  |  | 2010-10-10 00:00:00 | 4 | 3 | 1 | 4 | 4 | 4 | 3 | 4
 |  |  |  |  | 2010-10-11 00:00:00 | 4 | 7 | 1 | 4 | 8 | 1 | 7 | 8
 |  |  |  |  | 2010-10-12 00:00:00 | 4 | 3 | 1 | 8 | 8 | 3 | 3 | 8
 |  |  |  |  | 2010-10-13 00:00:00 | 3 | 4 | 1 | 3 | 8 | 2 | 4 | 8
 |  |  |  |  | 2010-10-14 00:00:00 | 3 | 5 | 1 | 3 | 7 | 8 | 5 | 7
 |  |  |  |  | 2010-10-15 00:00:00 | 3 | 5 | 1 | 3 | 9 | 9 | 5 | 9
 |  |  |  |  | 2010-10-16 00:00:00 | 2 | 6 | 1 | 2 | 8 | 9 | 6 | 8
 |  |  |  |  | 2010-10-17 00:00:00 | 1 | 6 | 1 | 2 | 6 | 7 | 6 | 6
 |  |  |  |  | 2010-10-18 00:00:00 | 1 | 6 | 2 | 1 | 6 | 6 | 6 | 6
 |  |  |  |  | 2010-10-19 00:00:00 | 1 | 6 | 1 | 1 | 6 | 6 | 6 | 6
 |  |  |  |  | 2010-10-20 00:00:00 | 1 | 6 | 1 | 1 | 6 | 6 | 6 | 6
Spreadsheet: 858381d1707100238-show-months-from-date-range-show-months-from-date-range-mycon73-
Sheet: Sheet1

 |  | Column B - Want to show months only from date range - Column D
 | Months |  | Date Range |  |  | Using Slicer
 |  |  | 2022-01-01 00:00:00 |  |  | -- Want to see months only & be ale to filter
 |  |  | 2022-01-01 00:00:00
 |  |  | 2023-01-02 00:00:00
 |  |  | 2023-01-02 00:00:00
 |  |  | 2024-01-04 00:00:00
 |  |  | 2024-01-05 00:00:00
 |  |  | 2024-01-05 00:00:00
 |  |  | 2024-01-08 00:00:00
 |  |  | 2024-01-11 00:00:00
 |  |  | 2024-01-11 00:00:00
 |  |  | 2024-01-12 00:00:00
 |  |  | 2024-01-12 00:00:00
 |  |  | 2024-01-13 00:00:00
 |  |  | 2024-01-15 00:00:00
 |  |  | 2024-01-15 00:00:00
 |  |  | 2024-01-15 00:00:00
 |  |  | 2024-01-15 00:00:00
 |  |  | 2024-01-15 00:00:00
 |  |  | 2024-01-16 00:00:00
 |  |  | 2024-01-18 00:00:00
 |  |  | 2024-01-20 00:00:00
 |  |  | 2024-01-20 00:00:00
 |  |  | 2024-01-21 00:00:00
 |  |  | 2024-01-25 00:00:00
 |  |  | 2024-01-27 00:00:00
 |  |  | 2024-01-27 00:00:00
 |  |  | 2024-01-27 00:00:00
 |  |  | 2024-01-27 00:00:00
 |  |  | 2024-01-28 00:00:00
 |  |  | 2022-02-01 00:00:00
 |  |  | 2022-02-01 00:00:00
 |  |  | 2023-02-02 00:00:00
 |  |  | 2023-02-02 00:00:00
 |  |  | 2024-02-04 00:00:00
 |  |  | 2024-02-05 00:00:00
 |  |  | 2024-02-05 00:00:00
 |  |  | 2024-02-08 00:00:00
 |  |  | 2024-02-11 00:00:00
 |  |  | 2024-02-11 00:00:00
 |  |  | 2024-02-12 00:00:00
 |  |  | 2024-02-12 00:00:00
 |  |  | 2024-02-13 00:00:00
 |  |  | 2024-02-15 00:00:00
 |  |  | 2024-02-15 00:00:00
 |  |  | 2024-02-15 00:00:00
 |  |  | 2024-02-15 00:00:00
 |  |  | 2024-02-15 00:00:00
 |  |  | 2024-02-16 00:00:00
 |  |  | 2024-02-18 00:00:00
 |  |  | 2024-02-18 00:00:00
 |  |  | 2024-02-18 00:00:00
 |  |  | 2024-02-20 00:00:00
 |  |  | 2024-02-20 00:00:00
 |  |  | 2024-02-21 00:00:00
 |  |  | 2024-02-25 00:00:00
 |  |  | 2024-02-27 00:00:00
 |  |  | 2024-02-27 00:00:00
 |  |  | 2024-02-27 00:00:00
 |  |  | 2024-02-27 00:00:00
 |  |  | 2024-02-28 00:00:00