tianzl66/Sheetpedia huggingface dataset:
Spreadsheet: daren_farmer__5484__hpl0919
Sheet: Sheet1

HPLN0919.XLS |  | Fax # [PHONE]
TO:  DARREN FARMER / ENRON;  CARY METZ / ENRON;  [NAME] / HPL;  AMI_CHOSKI / ENRON
FROM:  MELISSA JONES - TXU ELECTRIC & GAS  (TU ELECTRIC)
SUBJECT:  TXU FUELS NOMINATION - September 19, 2000
 |  |  |  |  |  | ** Tuesday
HPL AND ENRON NOMINATIONS: |  |  |  |  |  | 2000-09-19 00:00:00
 |  |  |  |  |  | Eff. 0900 hrs.
 |  |  |  |  | PRIOR | NOMINATED
CONTRACT |  | DELIVERY POINT |  | Upstream
Enron (FM) |  | LS HPL [NAME] |  | HPL
 |  |  |  |  | 0 to 30  0900hrs | 0 to 30  0900hrs
 |  |  |  |  | 30  to 0 2100hrs | 30  to 0 2100hrs
 |  | Firm Summary
Enron (S) |  | Oasis Turbine |  | HPL | 10 | 0
 |  | Enron North America Spot/3959
OTHER ENRON/HPL TRANSPORTS: |  |  |  | Downstream
 |  | Total Other Transports:
NOTE:  Additional swing volumes may be requested at Teco Tap, or Texoma by TUFCO Gas Control under either the
Wagner Brown K# 1901 or HPL K# 3949 agreements.
*  Nominations to continue until TU Electric changes such nominations.
CC:   [NAME] | [NAME]
R. Skerik | [NAME]
G. Green | K. English
B. Fleming | GCC Dispatcher
Spreadsheet: 669558d1585462511-using-another-sheet-like-function-almost-curcular-function-from-other-sheet
Sheet: Sheet 2

a | b | c | d | e | f | g
 | 66 | 11 | 494 | 6 | 4 | 4
calculation 1 | calculation 2 | calculation 3 | calculation 4 | calculation 5 | calculation 6
 |  |  |  | … | …
calculation 6 | calculation 7 | calculation 8 | calculation 9 | calculation 10 | calculation 11
… | … | … | … | … | …
Some hard calculations
Result
Spreadsheet: 138279d1327591806-how-to-compare-two-columns-and-highlight-both-if-same-value-example
Sheet: Sheet1

1 |  | 3
2 |  | 4
3 |  | 5
4 |  | 6
5 |  | 7
6 |  | 8
7 |  | 9
8 |  | 10
9 |  | 11
10 |  | 12
690 |  | 33
33
 |  | 690
Spreadsheet: 887091d1737214183-cadet-qualifcation-tracker-dates-updating-overall-status-progress-cdt-tracker-draft-1
Sheet: First Aid

 |  |  |  |  | First Aid
Surname | Initial | Status | Primary survey | Chest pain | Recovery position | Resuscitation (Adult) | Resuscitation (children) | Choking | Bleeding | Assessment
 |  |  | 2025-01-17 00:00:00 | 2025-01-17 00:00:00 | 2025-01-17 00:00:00 | 2025-01-17 00:00:00 | 2025-01-17 00:00:00 | 2025-01-17 00:00:00 | 2025-01-17 00:00:00 | 2025-01-17 00:00:00
 |  |  | 2025-01-17 00:00:00 | 2025-01-17 00:00:00 | 2025-01-17 00:00:00 | 2025-01-17 00:00:00 | 2025-01-17 00:00:00 | 2025-01-17 00:00:00 | 2025-01-17 00:00:00 | 2025-01-17 00:00:00
Spreadsheet: tracy_geaccone__40231__enron corp infomation request 111601
Sheet: EGS IS

 |  | September
Gross Margin by Business Unit |  | Year-to-Date
ETS
EGAS
PGE
EOTT
EREC
Azurix/Wessex |  | -362.9
EEOS
Other
Total Gross Margin
Operating Expenses |  | 0
Depreciation and Amortization |  | 0
Taxes Other Than Income |  | 0
Other Income (Loss) |  | 0
Income / (Loss) Before Interest & Taxes
(3)
Spreadsheet: 13d4d1e9-e3cf-4352-aa3f-1e45ec264918
Sheet: Sheet1

Permit No.: | Unnamed: 1 | Unnamed: 2 | WQ0013348 | Unnamed: 4 | Unnamed: 5 | Facility Name: | Unnamed: 7 | Bay River MSD - Pamlico Regional Facility | Unnamed: 9 | Unnamed: 10 | Unnamed: 11 | Unnamed: 12 | Unnamed: 13 | County: | [NAME] | Unnamed: 16 | Month: | Unnamed: 18 | Unnamed: 19 | Year: | Unnamed: 21
Did irrigation occur    at this facility? |  |  |  |  |  | Field Name: |  | 01 |  | Field Name: |  | 02 |  | Field Name: |  | 03 |  | Field Name: |  | 04
 |  |  |  |  |  | Area (acres): |  | 11.73 |  | Area (acres): |  | 10.27 |  | Area (acres): |  | 15.24 |  | Area (acres): |  | 10.42
 |  |  |  |  |  | Cover Crop: |  |  |  | Cover Crop: |  |  |  | Cover Crop: |  |  |  | Cover Crop:
 |  |  |  |  |  | [NAME] (in): |  | 0.5 |  | [NAME] (in): |  | 0.5 |  | [NAME] (in): |  | 0.5 |  | [NAME] (in): |  | 0.5
 |  |  |  |  |  | Annual Rate (in): |  | 68.3 |  | Annual Rate (in): |  | 68.3 |  | Annual Rate (in): |  | 68.3 |  | Annual Rate (in): |  | 68.3
Day | Weather |  |  | Freeboard |  | Field Irrigated? |  |  |  | Field Irrigated? |  |  |  | Field Irrigated? |  |  |  | Field Irrigated?
 | Weather Code | Temperature | Precipitation | Storage | 5-Day Upset (if applicable) | Volume Applied | Time   Irrigated | Daily   Loading | Maximum Hourly Loading | Volume Applied | Time    Irrigated | Daily   Loading | Maximum Hourly Loading | Volume Applied | Time   Irrigated | Daily   Loading | Maximum Hourly Loading | Volume Applied | Time   Irrigated | Daily   Loading | Maximum Hourly Loading
 |  | ºF | in | ft | ft | gal | min | in | in | gal | min | in | in | gal | min | in | in | gal | min | in | in
1
2
3
4
5
6
7
8
9
10
11
12
13
14
15
16
17
18
19
20
21
22
23
24
25
26
27
28
29
30
31
Monthly Loading:
12 Month Floating Total (in):
Spreadsheet: e409a664-bcee-49e0-b1de-41ea9c8878ed
Sheet: Sheet1

Unnamed: 0 | Unnamed: 1 | TIB-The Independent BankersBank | Unnamed: 3 | Unnamed: 4 | Unnamed: 5 | .25 cost to Price to Waive Escrows | Unnamed: 7
 |  | 350 [NAME]., [NAME] |  |  |  | LTV must be 80% or less to qualify.
 |  | [PHONE] Toll Free//[PHONE] fax
 |  | Rate Sheet Effective: |  |  | 2012-03-08 09:22:27.700000
Product: Conv-Conforming Fixed Rate 30 Year |  |  |  |  |  | Loan Level Price Adjustment
Rate | 15 Day | 30 Day | 45 Day | 60 Day |  | Price adjustments are cumulative
4.375 | 102.125 | 102 | 101.875 | 101.5 |  | and are added to price quote
4.25 | 101.931 | 101.806 | 101.681 | 101.306
4.125 | 101.532 | 101.407 | 101.282 | 100.907 |  | Note: | Refer To Price [NAME]
4 | 101.083 | 100.958 | 100.833 | 100.458 |  |  | For all Price Adjs
3.875 | 100.177 | 100.052 | 99.927 | 99.302
3.75 | 99.348 | 99.223 | 99.098 | 98.473
3.625 | 98.894 | 98.769 | 98.644 | 98.019
 |  |  |  |  |  | NEW!!!!!
 |  |  |  |  |  | Please note availability of
 |  |  |  |  |  | Servicing Retained Product for
 |  |  |  |  |  | Conventional Loans Only.
 |  |  |  |  |  | A .25 adjustment to SRP
 |  |  |  |  |  | Will apply.
 |  |  |  |  |  | NEW!!!!
 |  |  |  |  |  | Improved 15 day price for
 |  |  |  |  |  | Conventional Product
Product: Conv-Conforming Fixed Rate 15 Year
Rate | 15 Day | 30 Day | 45 Day | 60 Day
3.625 | 101.829 | 101.704 | 101.579 | 101.204
3.5 | 101.489 | 101.364 | 101.239 | 100.864
3.375 | 100.948 | 100.823 | 100.698 | 100.323
3.25 | 100.302 | 100.177 | 100.052 | 99.677
3.125 | 99.812 | 99.687 | 99.562 | 98.937
3 | 99.468 | 99.343 | 99.218 | 98.593
2.875 | 98.895 | 98.77 | 98.645 | 98.02 |  | Minimum loan amount:
 |  |  |  |  |  | TIB does not have a minimum loan
 |  |  |  |  |  | loan amount, however a 1.00% price
 |  |  |  |  |  | discount will apply to loan amounts
 |  |  |  |  |  | less than $39,999.00
 |  |  |  |  |  | 2010 Conforming Loan Limits
 |  |  |  |  |  | 1 Unit-$417,000
 |  |  |  |  |  | 2 Unit-$533,850
 |  |  |  |  |  | 3 Unit-$645,300
 |  |  |  |  |  | 4 Unit-$801,950
A SERVICE RELEASE PREMIUM WILL BE PAID IN [NAME] WITH THE ATTACHED SCHEDULE.
 |  | TIB-The Independent BankersBank
 |  | 350 [NAME]., [NAME]
 |  | [PHONE] Toll Free//[PHONE] fax
 |  | Rate Sheet Effective:
 |  |  |  |  |  | Loan Level Price Adjustment
Rate | 15 Day | 30 Day | 45 Day |  |  | Price adjustments are cumulative
 |  |  |  |  |  | & adj. Made to the price quote
EXPIRATION DATES:
15 DAY | 2012-03-22 09:22:27.700000
30 DAY | 2012-04-06 09:22:27.700000
45 DAY | 2012-04-21 09:22:27.700000
60 DAY | 2012-05-06 09:22:27.700000
90 DAY | 2012-06-05 09:22:27.700000
A SERVICE RELEASE PREMIUM WILL BE PAID IN [NAME] WITH THE ATTACHED SCHEDULE.
Spreadsheet: 734945d1622617737-leave-calendar-to-count-the-number-of-days-of-leave-each-staff-has-left-leave-plan-draft-v3
Sheet: Team

Names | 2020 Leave Balance | 2021 Leave Balance | Time Off (Not included in 80%) | Leave Balance |  |  |  |  |  |  |  |  |  |  |  |  |  | Half Day | 0.5
[NAME] |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | Full Day | 1
[NAME]
[NAME]
[NAME] | 21 | 21
Mufid | 12.5 | 30
Nathan
[NAME]
Zaki | 0 | 12
Fadhli | 0 | 2.5
Spreadsheet: 833426d1686947659-counting-the-number-of-employees-everyday-over-24r-operation-optimum-dummy-rota-dtee86-v2
Sheet: Sheet2

 | Monday | 06:00:00 | 07:00:00 | 08:00:00 | 09:00:00 | 10:00:00 | 11:00:00 | 12:00:00 | 13:00:00 | 14:00:00 | 15:00:00 | 16:00:00 | 17:00:00 | 18:00:00 | 19:00:00 | 20:00:00 | 21:00:00 | 22:00:00 | 23:00:00 | 1900-01-01 00:00:00 | 1900-01-01 01:00:00 | 1900-01-01 02:00:00 | 1900-01-01 03:00:00 | 1900-01-01 04:00:00 | 1900-01-01 05:00:00
 | Tyrone Candee
 | [NAME]
 | [NAME]
 | [NAME]
 | [NAME]
 | [NAME]
 | [NAME] Do Sacramento
 | [NAME]
 | Vacancy 1
 | Vacancy 2
 | Vacancy 3
 | [NAME]
 | [NAME]
 | [NAME]
 | [NAME]
 | [NAME]
 | [NAME]
 | [NAME]
 | [NAME]
 | [NAME]
 | [NAME]
 | [NAME]
 | Nadine Soanes
 | [NAME]
 | Vacancy 1
 | Vacancy 2
 | [NAME]
 | [NAME]
 | [NAME]
 | Nadine Weatherley
 | [NAME]
Spreadsheet: 376741d1423690444-sorting-number-pairs-containing-a-dash-2015-02-11-excel-forum-oeldere-
Sheet: Blad1

5-1
5-2
5-3
5-4
5-5
5-6
5-7
5-8
5-9
5-100
5-101
5-104
5-10
5-105
5-102
5-103
5-106
5-107
5-108
5-109
5-11
5-110
5-111
5-112
5-113
5-114
5-115
5-12
5-13
5-14
5-15
5-16
5-17
5-18
5-19
5-20
5-21
5-22
5-23
5-24
5-25
5-26
5-27
5-28
5-29
5-30
5-31
5-32
5-33
5-34
5-35
5-36
5-37
5-38
5-39
5-40
5-41
5-42
5-43
5-44
5-45
5-46
5-47
5-48
5-49
5-50
5-51
5-52
5-53
5-54
5-55
5-56
5-57
5-57
5-58
5-59
5-60
5-61
5-62
5-63
5-64
5-65
5-66
5-67
5-68
5-69
5-70
5-71
5-72
5-73
5-74
5-75
5-76
5-77
5-78
5-79
5-80
5-81
5-82
5-83
5-84
5-85
5-86
5-87
5-88
5-89
5-90
5-91
5-92
5-93
5-94
5-95
5-96
5-97
5-98
5-99
Spreadsheet: 81973d1282062945-filtering-and-linking-dummybook
Sheet: Sheet1

New | d | 1
Old | e | 2
Old | g | 3
New | h | 4
New | h | 5
Old | r | 6
New | e | 7
New | e | 8
New | u | 9
Spreadsheet: 850649d1701062236-kind-of-reverse-index-match-mosom-8-h
Sheet: Sheet1 (2)

 |  |  |  |  | Role 1 | Role 2 | Role 3 | Role 4 | Role 5
Topic 1 | Module 1 | Area 1 | Focus 1 |  | Yes | Yes | Yes | Yes | No |  |  |  |  | Scenario 1
Topic 1 | Module 1 | Area 1 |  |  | No | Yes | Yes | No | No |  |  |  |  | When I select in a new cell from a drop down list of all "text fields":
Topic 1 | Module 1 | Area 1 |  |  | No | Yes | No | No | Yes |  |  |  |  | eg | text field 5
Topic 1 | Module 1 | Area 2 | Focus 1 |  | Yes | Yes | No | No | Yes
Topic 1 | Module 1 | Area 2 | Focus 2 |  | No | N/A | Yes | Yes | No |  |  |  |  | It will display next to it the leading row part and the column heading, with cell spacers:
Topic 1 | Module 1 | Summary |  |  | text field 1 | text field 2 | text field 3 | text field 4 | text field 5 |  |  |  |  | eg | Topic 1 | Module 1 | Summary |  | Role 5
Topic 1 | Module 2 | Area 1 | Focus 1 |  | Yes | No | No | Yes | Yes
Topic 1 | Module 2 | Area 1 | Focus 2 |  | N/A | No | Yes | Yes | Yes |  |  |  |  | So it will look like this:
Topic 1 | Module 2 | Area 2 | Focus 1 |  | N/A | Yes | Yes | Yes | No |  |  |  |  | text field 5 |  | Topic 1 | Module 1 | Summary |  | Role 5
Topic 1 | Module 2 | Area 3 | Focus 1 |  | No | Yes | Yes | Yes | No
Topic 1 | Module 2 | Area 3 | Focus 2 |  | Yes | N/A | Yes | No | Yes
Topic 1 | Module 2 | Summary |  |  | text field 6 | text field 7 | text field 8 |  | text field 10
 |  |  |  |  |  |  |  |  |  |  |  |  |  | Scenario 2
 |  |  |  |  |  |  |  |  |  |  |  |  |  | List all text fields and the info, as above
 |  |  |  |  |  |  |  |  |  |  |  |  |  | eg | text field 1 |  | Topic 1 | Module 1 | Summary |  | Role 1
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  | text field 2 |  | Topic 1 | Module 1 | Summary |  | Role 2
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  | text field 3 |  | Topic 1 | Module 1 | Summary |  | Role 3
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  | text field 4 |  | Topic 1 | Module 1 | Summary |  | Role 4
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  | text field 5 |  | Topic 1 | Module 1 | Summary |  | Role 5
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  | text field 6 |  | Topic 2 | Module 2 | Summary |  | Role 1
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  | text field 7 |  | Topic 2 | Module 2 | Summary |  | Role 2
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  | text field 8 |  | Topic 2 | Module 2 | Summary |  | Role 3
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  | text field 9 |  | Topic 2 | Module 2 | Summary |  | Role 4
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  | text field 10 |  | Topic 2 | Module 2 | Summary |  | Role 5
Spreadsheet: 873770d1720339919-how-to-find-total-of-working-hours-from-a-single-cell-2024
Sheet: july

[NAME] | 31 |  |  | ΡΕΠΟ
ΞΕΚΙΝΑΕΙ | 2024-07-01 00:00:00
ΒΗΜΑ | 1
 | ΙΟΥΛΙΟΣ |  | [NAME] ΡΑΦΑΕΛΑ | KROSHKINA MARIA | ΒΛΑΧΟΥ ΠΑΝΑΓΙΩΤΑ | ΚΑΛΛΟΥ ΓΕΩΡΓΙΑ | ΚΟΝΙΣΣΗ ΒΑΣΙΛΙΚΗ | ΟΙΚΟΝΟΜΟΥ ΒΑΡΒΑΡΑ | ΒΛΑΤΑΚΗΣ ΚΥΡΙΑΚΟΣ | ΚΟΝΙΣΣΗ ΙΟΥΛΙΑΝΗ |  |  | [NAME] ΡΑΦΑΕΛΑ | KROSHKINA MARIA | ΒΛΑΧΟΥ ΠΑΝΑΓΙΩΤΑ | ΚΑΛΛΟΥ ΓΕΩΡΓΙΑ | ΚΟΝΙΣΣΗ ΒΑΣΙΛΙΚΗ | ΟΙΚΟΝΟΜΟΥ ΒΑΡΒΑΡΑ | ΒΛΑΤΑΚΗΣ ΚΥΡΙΑΚΟΣ | ΚΟΝΙΣΣΗ ΙΟΥΛΙΑΝΗ
 |  | 11:00-22:00 |  | 09:00-17:00 | 11:00-17:00 | 16:00-22:00 | 09:00-22:00 | 17:00-22:00 | 09:00-22:00 | 15-00-21:00 |  | 11 hoursand 00 minutes
 | 2024-07-02 00:00:00 | 09:30-22:00 |  | 09:00-17:00 | 11:00-17:00 | 16:00-22:00 | 09:00-22:00 | 17:00-22:00 | 09:00-13:00  &  17:00-22:00 | 16-00-21:00 |  |  |  |  |  |  |  |  | 9 hours 00 minutes
 | 2024-07-03 00:00:00 | 09:30-22:00 |  | 09:00-17:00 | 11:00-17:00 | 16:00-22:00 | 09:00-22:00 | 17:00-22:00 | 09:00-13:00  &  17:00-22:00 | 16-00-21:00
 | 2024-07-04 00:00:00 | ΟΡΘΟΠΑΙΔΙΚΟΣ |  | 09:00-17:00 | 11:00-17:00 | 16:00-22:00 | 09:00-22:00 | 17:00-22:00 | 09:00-13:00  &  17:00-22:00 | 16-00-21:00
 | 2024-07-05 00:00:00 | ΔΕΝ ΗΡΘΕ |  | 09:00-17:00 | 11:00-17:00 | 16:00-22:01 | 09:00-22:00 | 17:00-22:00 | 09:00-13:00  &  17:00-22:00 | 16-00-21:00
 | 2024-07-06 00:00:00 | ΔΕΝ ΗΡΘΕ |  | 09:00-17:00 | 11:00-17:00 | ΡΕΠΟ | 09:00-22:00 | 17:00-22:00 | 09:00-22:00 | 16-00-21:00
 | 2024-07-07 00:00:00 | ΔΕΝ ΗΡΘΕ |  | ΡΕΠΟ | ΡΕΠΟ | 10:00-18:00 | 10:00-18:00 | ΡΕΠΟ | 10:00-18:00 | ΡΕΠΟ
 | 2024-07-08 00:00:00
 | 2024-07-09 00:00:00
 | 2024-07-10 00:00:00
 | 2024-07-11 00:00:00
 | 2024-07-12 00:00:00
 | 2024-07-13 00:00:00
 | 2024-07-14 00:00:00
 | 2024-07-15 00:00:00
 | 2024-07-16 00:00:00
 | 2024-07-17 00:00:00
 | 2024-07-18 00:00:00
 | 2024-07-19 00:00:00
 | 2024-07-20 00:00:00
 | 2024-07-21 00:00:00
 | 2024-07-22 00:00:00
 | 2024-07-23 00:00:00
 | 2024-07-24 00:00:00
 | 2024-07-25 00:00:00
 | 2024-07-26 00:00:00
 | 2024-07-27 00:00:00
 | 2024-07-28 00:00:00
 | 2024-07-29 00:00:00
 | 2024-07-30 00:00:00
 | 2024-07-31 00:00:00
Spreadsheet: 796825d1663584662-help-regarding-automatically-updating-data-in-source-sheet-sheet-1
Sheet: aug

235 | 2022-08-31 00:00:00 | mamagoto |  | 03:25:00 | 03:55:00 |  | Purchase manager | 8580512825 | QSR | New | veeba | 25 | No
236 | 2022-08-31 00:00:00 | guru nanak sweets |  | 04:25:00 | 04:55:00 |  | Purchase manager | 9779775788 | Restaurant | New | Veeba | 10 | No
237 | 2022-08-31 00:00:00 | [NAME] |  | 05:10:00 | 05:25:00 |  | Owner | 8289006442 | Qsr | Existing | Fun Foods | 25 | No
238 | 2022-08-31 00:00:00 | night food street |  | 05:40:00 | 05:55:00 |  | Owner | 8146246796 | Qsr | New | veeba | 96 | Yes
239 | 2022-08-31 00:00:00 | pgi canteen |  | 06:05:00 | 06:30:00 |  | Purchase manager | 977977773 | Canteen | New | food coast | 30 | yes
Spreadsheet: 718536d1613170309-calculate-standard-overtime-labor-time-and-per-diem-labor-calc
Sheet: Sheet1

 |  |  |  |  | Standard | Overtime | Per diem
 | Total Labor hours | 7 |  | 0 |  | 0 | 0
 | Total Standard Hours |  |  | 8.01 | 8 |  | 0
 | Total Overtime Hours |  |  |  |  | 0 | 1
 | Total Per Diem Days |  |  |  | 16 |  | 1
 |  |  |  |  |  | 0 | 2
 |  |  |  |  | 24 |  | 2
 |  |  |  |  |  | 0 | 3
 |  |  |  |  | 32 |  | 3
 |  |  |  |  |  | 0 | 4
Spreadsheet: 250004d1373717595-count-add-discriminate-and-give-me-an-answer-length-opt
Sheet: Sheet1

2232 | 549 | 1700 | 455 | 908 | 325 | sorted ascending>>>>> | 325 | 455 | 549 | 908 | 1700 | 2232 |  | 2240 | <length of piece
 |  |  |  |  |  |  | 325 | 780 | 1329 | 2237 |  |  | 1
 |  |  |  |  |  |  | 0 | 0 | 0 | 0 | 1700 |  | 1
 |  |  |  |  |  |  | 0 | 0 | 0 | 0 | 0 | 2232 | 1
 |  |  |  |  |  |  | 0 | 0 | 0 | 0 | 0 | 0 | 0
 |  |  |  |  |  |  | 0 | 0 | 0 | 0 | 0 | 0 | 0
 |  |  |  |  |  |  | pieces
 |  |  |  |  |  |  | 3
Spreadsheet: 587566d1535096805-rank-subgroups-without-duplicates-rank-exemplar
Sheet: Sheet1

Participant Number | Year | Rank
1 | 1994 | 1
1 | 1994 | 1
1 | 1995 | 2
1 | 1996 | 3
1 | 1997 | 4
1 | 1997 | 4
1 | 1997 | 4
2 | 1998 | 1
2 | 1998 | 1
2 | 1998 | 1
2 | 1998 | 1
2 | 1999 | 2
2 | 1999 | 2
2 | 2000 | 3
2 | 2000 | 3
3 | 1992 | 1
3 | 1993 | 2
3 | 1993 | 2
3 | 1993 | 2
3 | 1993 | 2
3 | 1994 | 3
3 | 1995 | 4
3 | 1995 | 4
Spreadsheet: 678748d1590049026-formula-not-calculating-charts
Sheet: WIP Mar 20

 | Daily |  |  | Last day of month |  | Fresh WIP | Aged WIP Level | WIP Level
 |  |  |  | Jan | 350 |  | 111.2 | 400
1 | 572 | 280 |  | Feb | 350 |  | 122.2 | 501
2 | 623 | 280 |  | Mar | 350 |  | 153.5 | 477
3 | 644 | 280 |  | Apr | 350 |  | 83.1 | 249
4 | 679 | 280 |  | May | 350 |  | 67 | 213
5 | 719 | 280 |  | Jun | 350 |  | 66.6 | 275
6 | 690 | 280 |  | Jul | 350 |  | 64.4 | 270
7 | 688 | 280 |  | Aug | 350 |  | 60.496 | 258
8 | 659 | 280 |  | Sept | 350 |  | 49.8 | 330.6
9 | 657 | 280 |  | Oct | 350 |  | 50.3 | 243
10 | 642 | 280 |  | Nov | 350 |  | 60.7 | 332
11 | 660 | 280 |  | Dec | 350 | 179 | 139
12 | 677 | 280 |  | Jan | 350 | 291 | 143 | 434
13 | 705 | 280 |  | Feb | 350 |  | 161 | 446
14 | 705 | 280 |  | Mar | 350 |  | 156 | 483
15 | 689 | 280 |  | Apr | 350 |  | 171 | 414
16 | 696 | 280 |  | May | 350 |  | 162 | 433
17 | 707 | 280 |  | Jun | 350 |  | 174 | 587
18 | 696 | 280 |  | Jul | 350 |  | 147 | 584
19 | 699 | 280 |  | Aug | 350 |  | 130 | 631
20 | 716 | 280 |  | Sep | 350 |  | 197 | 574
21 | 762 | 280 |  | Oct | 350 |  | 185 | 654
22 | 745 | 280 |  | Nov | 350 |  | 257 | 959
23 | 708 | 280 |  | Dec | 350 | 732
24 | 710 | 280 |  | Jan | 280 | 364 | 426 | 791
25 | 695 | 280 |  | Feb | 280 | 161 | 426 | 587
26 | 677 | 280 |  | Mar | 280 | 284 | 435 | 719
27 | 643 | 280 |  | Apr | 280
28 | 631 | 280 |  | May | 280
29 | 640 | 280 |  | June | 280
30 | 675 | 280 |  | July
31 | 719 | 280
Total
Spreadsheet: 222601d1363888255-automatically-generated-list-based-on-criteria-test-sheet1
Sheet: Sheet2

 | Date | 20130320 |  | Name | [NAME], [NAME] |  | OR | Team Leader
 | Actual |  |  |  |  |  | Schedule
 | Name | Activity | From | To | Duration |  | Name | Scheduled Activity | From | To | Duration
Spreadsheet: 85686d1285750676-sum-the-total-depand-on-two-or-more-criteria-example-1-
Sheet: detail

date | item | type | qty
2010-09-12 00:00:00 | amy | AL | 1
2010-09-13 00:00:00 | [NAME] | AL | 2
2010-09-13 00:00:00 | tom | MC | 1
2010-09-14 00:00:00 | mary | AL | 2
2010-09-14 00:00:00 | [NAME] | MC | 1
2010-09-14 00:00:00 | amy | MC | 2
2010-09-15 00:00:00 | [NAME] | MC | 2
2010-09-15 00:00:00 | tom | MC | 1
2010-09-16 00:00:00 | mary | MC | 1
2010-09-25 00:00:00 | amy | AL | 5
Spreadsheet: 826003d1681730263-credit-card-installment-ccard-aligw1
Sheet: Sheet1

A BANK |  |  |  |  |  | 2022 |  |  |  |  |  |  |  |  |  |  |  | 2023 |  |  |  |  |  |  |  |  |  |  |  | 2024
shopping date | product | account closing date | amount | number of installments |  | 2022-01-01 00:00:00 | 2022-02-01 00:00:00 | 2022-03-01 00:00:00 | 2022-04-01 00:00:00 | 2022-05-01 00:00:00 | 2022-06-01 00:00:00 | 2022-07-01 00:00:00 | 2022-08-01 00:00:00 | 2022-09-01 00:00:00 | 2022-10-01 00:00:00 | 2022-11-01 00:00:00 | 2022-12-01 00:00:00 | 2023-01-01 00:00:00 | 2023-02-01 00:00:00 | 2023-03-01 00:00:00 | 2023-04-01 00:00:00 | 2023-05-01 00:00:00 | 2023-06-01 00:00:00 | 2023-07-01 00:00:00 | 2023-08-01 00:00:00 | 2023-09-01 00:00:00 | 2023-10-01 00:00:00 | 2023-11-01 00:00:00 | 2023-12-01 00:00:00 | 2024-01-01 00:00:00 | 2024-02-01 00:00:00 | 2024-03-01 00:00:00 | 2024-04-01 00:00:00 | 2024-05-01 00:00:00 | 2024-06-01 00:00:00 | 2024-07-01 00:00:00 | 2024-08-01 00:00:00 | 2024-09-01 00:00:00 | 2024-10-01 00:00:00 | 2024-11-01 00:00:00 | 2024-12-01 00:00:00
2023-04-16 00:00:00 | nike | 2023-05-04 00:00:00 | 2350.53 | 9
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | In the installment distribution, it was supposed to be in April delivery.
 |  |  |  | formula  :
 |  | Installment starts missing
 |  | It needs to calculate based on the criteria in cell g8.
 |  | It needs to be revised by calculating the year.
 |  | your formula does not include the installment on the date of purchase.
 |  | There are installments between the shopping date and the account closing date. |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 261.17 |  |  |  |  |  | this installment won't be there
 |  | If we add the year criterion to the formula in cell [NAME], the problem is solved.
 |  | According to the example, installments should occur in April and December.
Spreadsheet: 852514d1702512141-create-a-third-table-with-unique-and-match-values-3-table-example
Sheet: Sheet1

A | B |  | a2 | b2
1 | 1 |  | 1 | 1
3 | 2 |  |  | 2
5 | 4 |  | 3
12 | 5 |  |  | 4
10 | 10 |  | 5 | 5
 |  |  | 10 | 10
 |  |  | 12
Spreadsheet: 542136d1507723907-check-count-between-two-cells-check-count-between-two-cells-check-count-10
Sheet: Check

 |  |  |  |  |  |  |  | Tue | Wed | Thur | Fri | Sat | Sun | Mon | Tue | Wed | Thur | Fri | Sat | Sun | Mon | Tue | Wed | Thur | Fri | Sat | Sun | Mon | Tue | Wed | Thur | Fri | Sat | Sun | Mon | Tue | Wed | Thur
STAFF NO. | NAME | NORMAL DAYS | SL(Full) | SL(Half) | SL(Nill) | OVERTIME (Off Days) | OVERTIME (Hours) | 1 | 2 | 3 | 4 | 5 | 6 | 7 | 8 | 9 | 10 | 11 | 12 | 13 | 14 | 15 | 16 | 17 | 18 | 19 | 20 | 21 | 22 | 23 | 24 | 25 | 26 | 27 | 28 | 29 | 30 | 31 | INTERVAL | EXPECTED RESULT |  |  | 1 | 2 | 3 | 4 | 5 | 6 | 7 | 8 | 9 |  | A | B | C | D | E | F | G | H | I | J | K
1 | [NAME] | 31 | 0 | 0 | 0 | 0 | 15 | - | - | - | OFF | OFF | - | - | - | - | - | OFF | OFF | - | - | - | - | - | OFF | OFF | - | - | - | - | - | OFF | OFF | - | - | - | - | - |  | 5-5-5
2 | Cameroon | 31 | 0 | 0 | 0 | 1 | 38 | - | - | - | OFF | OFF | - | - | - | - | - | OFF | OFF | - | - | - | - | - | OFF | OFF | - | - | - | - | - | OFF | OFF | - | - | - | - | - |  | 5-5-5
3 | Sachin | 31 | 0 | 0 | 0 | 1 | 11.5 | - | - | - | - | OFF | OFF | - | - | - | - | - | - | OFF | OFF | - | - | - | - | - | - | OFF | OFF | - | - | - | - | - | - | OFF | OFF | - |  | 6-6-6
4 | Tendulkar | 27 | 0 | 0 | 0 | 0 |  | - | - | - | - | OFF | OFF | - | - | - | - | - | OFF | OFF | - | - | - | - | - | OFF | OFF | - | - | - | - | - | OFF | OFF | - | - | - | - |  | 5-5-5
5 | Rahul | 30 | 1 | 0 | 0 | 0 |  | OFF | - | - | - | - | - | OFF | OFF | - | - | - | - | - | OFF | - | - | - | - | OFF | - | - | - | - | - | OFF | OFF | - | - | - | - | - |  | 5-5-4-5
6 | [NAME] | 31 | 0 | 0 | 0 | 0 |  | - | - | - | - | OFF | OFF | - | - | - | - | - | OFF | OFF | - | - | - | - | - | OFF | OFF | - | - | - | - | - | OFF | OFF | - | - | - | - |  | 5-5-5
7 | Narain | 20 | 0 | 0 | 0 | 0 |  | - | - | - | OFF | OFF | - | - | - | - | - | OFF | OFF | - | - | - | - | - | OFF | OFF | - | - | - | - | - | - | - | - | - | - | - | - |  | 5-5
8 | Karthik | 31 | 0 | 0 | 0 | 0 |  | - | - | OFF | OFF | - | - | - | - | - | OFF | OFF | - | - | - | - | - | OFF | OFF | - | - | - | - | - | OFF | OFF | - | - | - | - | - | - |  | 5-5-5
9 | Dhoni | 31 | 0 | 0 | 0 | 0 |  | - | OFF | OFF | - | - | - | - | - | OFF | OFF | - | - | - | - | - | OFF | OFF | - | - | - | - | - | OFF | OFF | - | - | - | - | OFF | OFF | - |  | 5-5-5-4
10 | Singh | 12 | 0 | 0 | 0 | 0 | 8.75 | - | - | - | OFF | OFF | - | - | - | - | - | OFF | OFF | - | - | - | - | OFF | - | - | - | - | - | - | - | - | - | - | OFF | - | - | - |  | 5-4-10
Spreadsheet: 839552d1692066186-spinner-button-doesnt-work-on-percentage-with-decimals-looking-for-a-fix-thank-you-book1-1-
Sheet: Sheet1 (2)

 |  |  |  |  |  |  |  | TARGET % BUY | TARGET BUY |  |  |  | TARGET % SALE
 |  |  |  |  |  |  |  | 5
 |  |  |  |  |  |  |  | 0.1