tianzl66/Sheetpedia huggingface dataset:
Spreadsheet: 90210d1289959043-combining-conditional-formatting-rules-sample
Sheet: Data

2010-01-02 00:00:00 |  | Blue |  |  | Green |  | [NAME] |  | Red |  | Gray |  | Yellow |  | Blue | 2010-01-01 00:00:00
2010-01-16 00:00:00 |  | Saturday | Sunday |  | Monday |  | Tuesday |  | Wednesday |  | Thursday |  | Friday |  | Green | 2010-01-18 00:00:00
2010-01-30 00:00:00 |  | 2010-01-02 00:00:00 | 2010-01-03 00:00:00 |  | 2010-01-04 00:00:00 |  | 2010-01-05 00:00:00 |  | 2010-01-06 00:00:00 |  | 2010-01-07 00:00:00 |  | 2010-01-08 00:00:00 |  | [NAME] | 2010-02-15 00:00:00
2010-02-13 00:00:00 |  |  | 2010-01-10 00:00:00 |  |  |  |  |  |  |  |  |  |  |  | Red | 2010-05-31 00:00:00
2010-02-27 00:00:00 |  |  | 2010-01-17 00:00:00 |  |  |  |  |  |  |  |  |  |  |  | Gray | 2010-07-05 00:00:00
2010-03-13 00:00:00 |  |  | 2010-01-24 00:00:00 |  |  |  |  |  |  |  |  |  |  |  | Yellow | 2010-09-06 00:00:00
2010-03-27 00:00:00 |  |  | 2010-01-31 00:00:00 |  |  |  |  |  |  |  |  |  |  |  |  | 2010-10-11 00:00:00
2010-04-10 00:00:00 |  |  | 2010-02-07 00:00:00 |  |  |  |  |  |  |  |  |  |  |  |  | 2010-11-11 00:00:00
2010-04-24 00:00:00 |  |  | 2010-02-14 00:00:00 |  |  |  |  |  |  |  |  |  |  |  |  | 2010-11-25 00:00:00
2010-05-08 00:00:00 |  |  | 2010-02-21 00:00:00 |  |  |  |  |  |  |  |  |  |  |  |  | 2010-12-24 00:00:00
2010-05-22 00:00:00 |  |  | 2010-02-28 00:00:00
2010-06-05 00:00:00 |  |  | 2010-03-07 00:00:00
2010-06-19 00:00:00 |  |  | 2010-03-14 00:00:00
2010-07-03 00:00:00 |  |  | 2010-03-21 00:00:00
2010-07-17 00:00:00 |  |  | 2010-03-28 00:00:00
2010-07-31 00:00:00 |  |  | 2010-04-04 00:00:00
2010-08-14 00:00:00 |  |  | 2010-04-11 00:00:00
2010-08-28 00:00:00 |  |  | 2010-04-18 00:00:00
2010-09-11 00:00:00 |  |  | 2010-04-25 00:00:00
2010-09-25 00:00:00 |  |  | 2010-05-02 00:00:00
2010-10-09 00:00:00 |  |  | 2010-05-09 00:00:00
2010-10-23 00:00:00 |  |  | 2010-05-16 00:00:00
2010-11-06 00:00:00 |  |  | 2010-05-23 00:00:00
2010-11-20 00:00:00 |  |  | 2010-05-30 00:00:00
2010-12-04 00:00:00 |  |  | 2010-06-06 00:00:00
2010-12-18 00:00:00 |  |  | 2010-06-13 00:00:00
 |  |  | 2010-06-20 00:00:00
 |  |  | 2010-06-27 00:00:00
 |  |  | 2010-07-04 00:00:00
 |  |  | 2010-07-11 00:00:00
 |  |  | 2010-07-18 00:00:00
 |  |  | 2010-07-25 00:00:00
 |  |  | 2010-08-01 00:00:00
 |  |  | 2010-08-08 00:00:00
 |  |  | 2010-08-15 00:00:00
 |  |  | 2010-08-22 00:00:00
 |  |  | 2010-08-29 00:00:00
 |  |  | 2010-09-05 00:00:00
 |  |  | 2010-09-12 00:00:00
 |  |  | 2010-09-19 00:00:00
 |  |  | 2010-09-26 00:00:00
 |  |  | 2010-10-03 00:00:00
 |  |  | 2010-10-10 00:00:00
 |  |  | 2010-10-17 00:00:00
 |  |  | 2010-10-24 00:00:00
 |  |  | 2010-10-31 00:00:00
 |  |  | 2010-11-07 00:00:00
 |  |  | 2010-11-14 00:00:00
 |  |  | 2010-11-21 00:00:00
 |  |  | 2010-11-28 00:00:00
 |  |  | 2010-12-05 00:00:00
 |  |  | 2010-12-12 00:00:00
 |  |  | 2010-12-19 00:00:00
 |  |  | 2010-12-26 00:00:00
 |  |  | 2011-01-02 00:00:00
 |  |  | 2011-01-09 00:00:00
 |  |  | 2011-01-16 00:00:00
 |  |  | 2011-01-23 00:00:00
 |  |  | 2011-01-30 00:00:00
 |  |  | 2011-02-06 00:00:00
 |  |  | 2011-02-13 00:00:00
 |  |  | 2011-02-20 00:00:00
 |  |  | 2011-02-27 00:00:00
Spreadsheet: 695615d1600308431-return-values-in-the-first-and-subsequent-non-blank-cells-example
Sheet: Sheet1

Observations of Babies
Baby Date of birth | 2020-08-02 00:00:00
Gestational Age at birth | 38 | Weeks
Expected Review Date
Actual Observation Date |  |  |  |  | 2020-08-10 00:00:00 |  |  | 2020-09-01 00:00:00 |  | 2020-09-13 00:00:00
Gestational Baby Age - Weeks
Actual Baby Age |  |  |  | 0
Obervation code |  |  |  |  | Choice A |  |  | Choice B |  | Choice B |  |  |  |  |  | Choice C |  |  |  |  |  |  |  | Choice A
 | Observation Date | Actual [NAME] Observation | Observation Code
1st Observation |  |  |  |  | Required functions please:
2nd Observation |  |  |  |  | * When an actual observation date is added in row 9, the appropriate cell in B18:B22 populates based on which observation it relates to
3rd Observation |  |  |  |  | * When an actual observation date is added in row 9, the appropriate cell in c18:c22 for Actual Baby age populates based on which observation it relates to
4th Observation |  |  |  |  | * When an observation code is added in row 14 (using the data validation dropdown), the appropriate cell in D18:D22 populates based on which observation it relates to
5th Observation
Total Number of occurances of Observation Codes
Choice A
Choice B
Choice C
Observation Code Choice List Data validation Dropdown
Choice A
Choice B
Choice C
Spreadsheet: 689638d1596565358-need-help-summing-and-merging-tables-based-on-shared-column-datasetsample
Sheet: UR

ID | Survey ID | Species | Stems
1 | 3 | COCO | 18
2 | 3 | PRVI | 3
3 | 3 | Dead POTR | 2
4 | 3 | POTR | 1
5 | 3 | ALRU | 7
6 | 4 | POBA | 5
7 | 4 | ALRU | 6
8 | 4 | PRPE | 12
9 | 4 | Dead POBA | 2
10 | 7 | Dead POTR | 5
11 | 7 | Dead UNKNOWN | 3
12 | 7 | ALRU | 14
13 | 7 | COCO | 3
14 | 7 | POTR | 2
15 | 8 | ALRU | 5
16 | 8 | Dead POTR | 9
17 | 8 | POTR | 1
18 | 8 | FRNI | 1
19 | 8 | PRPE | 2
Spreadsheet: 685170d1593774500-vlookup-and-match-two-values-sample-data
Sheet: SOURCE

CONTACT_PERSON_ID | CONTACT_EFFECTIVE_END | CONTACT_BLOOD_TYPE | CONTACT_CORRESPONDENCE_LANG | CONTACT_BIRTH_COUNTRY | CONTACT_DOB | CONTACT_BIRTH_REGION | CONTACT_BIRTH_TOWN | PER_NUMBER
19679 | 4712-12-31 00:00:00 |  |  |  | 1955-08-26 00:00:00 |  |  | 190281
19859 | 4712-12-31 00:00:00 |  |  |  | 1966-05-31 00:00:00 |  |  | 185931
19901 | 4712-12-31 00:00:00 |  |  |  | 1940-12-05 00:00:00 |  |  | 187776
19907 | 4712-12-31 00:00:00 |  |  |  | 1944-01-27 00:00:00 |  |  | 191481
19949 | 4712-12-31 00:00:00 |  |  |  | 1942-11-09 00:00:00 |  |  | 191478
20064 | 4712-12-31 00:00:00 |  |  |  | 1942-05-24 00:00:00 |  |  | 194027
Spreadsheet: a51204e8-a4aa-444e-aa92-a9a68f83f7b0
Sheet: Sheet1

LABEL | UPC | ARTIST | TITLE | RELEASEDATE | PRODUCTTYPE | GENRE | PRICE | [NAME] | STATUS
Ilg Records Csr | 75597994070 | Akissforjersey | Victims | 2008-06-03 | Compact Disc | Rock | 14.99 | Y | Available
Spreadsheet: 886972d1737051403-find-and-highlight-multiple-names-across-entire-sheet-example
Sheet: Sheet1

Team |  | PHL | SXM | MUC | LAX
BOB |  | BOB | TINA | JOE | HANNA
JOE |  | DAN | RICH | GLEN | [NAME]
[NAME] |  | LYNN | BRIT | [NAME] | BILL
TINA |  | [NAME] |  | SAM | BOB
 |  | ALEX |  | ALEX | TINA
 |  |  |  | LYNN | SVEN
 |  |  |  |  | [NAME]
 |  |  |  |  | TAYLOR
 |  |  |  |  | HANK
Spreadsheet: 246d3e9c-b78b-47d1-8bdd-b473e322fcf2
Sheet: 8c

Product1 | 0-34 | 3-6 | 6-12 | 12-24 | 24-60 | 60-120 | 120-360 | 360+ | TOTAL
Basis | 7 | 3 | 4 | 29 | 60 | 93 | 81 | 39 | 316
Cap/Floor | 12 | 4 | - | 46 | 112 | 19 | 9 | - | 202
Debt Option | - | - | - | - | - | - | - | - | 0
Exotic | - | - | - | - | - | - | - | - | 0
Fixed-Fixed | 13 | - | 1 | 2 | 2 | 5 | - | - | 23
Fixed-Float | 101 | 134 | 468 | 1663 | 3757 | 4412 | 4057 | 1821 | 16413
FRA | 168 | 595 | 982 | 659 | 9 | - | - | - | 2413
Inflation | 16 | 5 | 19 | 45 | 79 | 62 | 64 | 26 | 316
OIS | 95 | 73 | 124 | 79 | 54 | 47 | 41 | 3 | 516
Swaption | - | - | 1 | 129 | 545 | 561 | 945 | 287 | 2468
TOTAL | 412 | 814 | 1599 | 2652 | 4618 | 5199 | 5197 | 2176 | 22667
Spreadsheet: 0069afa6-d6c6-4efe-96b4-2fede2775599
Sheet: Sheet 2

Support For Authorized Faculty Line Form: Data Section
 | Campus/School: |  | CW Post: School of Arts and Sciences
 | Department: |  | Psychology
 | Program, Concentration or Specialty: |  | Doctoral Program (Psy D)
 | Request for  Academic Year: |  | 2010-11
I) | Student Credits Generated; credits generated by the courses the department ran for the last 3 years (Fall & Spring combined)
 | Year: |  | 2008/09 |  | 2007/08 |  | 2006/07
 | (Ia) Graduate:
 | (Ib) Undergraduate:
 | (Ic)  Total
II) | Majors in the Department: list the majors associated with the department and provide the head count for each, for the last
 | 3 years - Fall semester's count: Obtained through IR
 |  |  | Head count by year - past 3 years-Fall Count
 | List Majors by Description) |  | 2008/09 |  | 2007/08 |  | 2006/07
 | (II) - Total Majors by [NAME]
III) | Faculty Resources provided to the Department:
 |  |  | 2008/09 |  | 2007/08 |  | 2006/07
 | a) Number of Full-time Faculty in the department
 | b) # of Workload Credits Available by FT Faculty.
 | c) Release Time Credits (chair, research, and 022)
 | Available Credits by FT Faculty
 | c) Total Workload Credits Processed for All Courses
IV) | Coverage Ratios
 | e) FT Faculty Coverage Ratio  = (IIIb / IIId)
 | f) Adjunct Coverage Ratio = (IIIc / IIId)
V) | Student/Faculty Ratios:
 | Student Credit Ratio:  ( Ic / IIIc )
 | Major/FT Faculty Ratio ( II / IIIa )
Spreadsheet: 2d2e10b6-2e29-407d-acad-4058e2f1cdd6
Sheet: Cash v Underlying profit rec

CASH V UNDERLYING PROFIT RECONCILIATION
AUD $M | Underlying | NZ Simplification programme | Acquisition related adjustments | Gain on sale of Visa shares | Capitalised software impairment | NZ Managed funds impacts | Non-continuing businesses | Policyholder liabilitiy discount valuation | Cash
Quarter ended Dec 11
Operating income |  | 1 | 1 | 0 | 0 | -1 | -2 | -17
Operating expenses |  | -11 | -22 | 0 | 0 | 0 | -2 | 0
Profit before credit impairment and tax |  | -10 | -21 | 0 | 0 | -1 | -4 | -17
Provision for credit impairment |  | 0 | 0 | 0 | 0 | 0 | -1 | 0
Profit before income tax |  | -10 | -21 | 0 | 0 | -1 | -5 | -17
Income tax expense & NCI |  | 2 | 4 | 0 | 0 | 1 | 0 | 5
Profit | 1478 | -8 | -17 | 0 | 0 | 0 | -5 | -12 | 1436
Quarter ended Mar 12
Operating income |  | 0 | 5 | 0 | 0 | -1 | 21 | 9
Operating expenses |  | -53 | -20 | 0 | 0 | 0 | -5 | 0
Profit before credit impairment and tax |  | -53 | -15 | 0 | 0 | -1 | 16 | 9
Provision for credit impairment |  | 0 | 0 | 0 | 0 | 0 | -4 | 0
Profit before income tax |  | -53 | -15 | 0 | 0 | -1 | 12 | 9
Income tax expense & NCI |  | 15 | 4 | 0 | 0 | 1 | -4 | -3
Profit | 1495 | -38 | -11 | 0 | 0 | 0 | 8 | 6 | 1460
Quarter ended Jun 12
Operating income |  | 0 | 0 | 0 | 0 | 0 | 10 | -40
Operating expenses |  | -10 | -17 | 0 | 0 | 0 | -4 | 0
Profit before credit impairment and tax |  | -10 | -17 | 0 | 0 | 0 | 6 | -40
Provision for credit impairment |  | 0 | 0 | 0 | 0 | 0 | -7 | 0
Profit before income tax |  | -10 | -17 | 0 | 0 | 0 | -1 | -40
Income tax expense & NCI |  | 3 | 5 | 0 | 0 | 0 | 1 | 11
Profit | 1488 | -7 | -12 | 0 | 0 | 0 | 0 | -29 | 1440
Quarter ended Sep 12
Operating income |  | 1 | 1 | 291 | 0 | 0 | 0 | -9
Operating expenses |  | -74 | -3 | 0 | -273 | 0 | -3 | 0
Profit before credit impairment and tax |  | -73 | -2 | 291 | -273 | 0 | -3 | -9
Provision for credit impairment |  | 0 | 0 | 0 | 0 | 0 | 0 | 0
Profit before income tax |  | -73 | -2 | 291 | -273 | 0 | -3 | -9
Income tax expense & NCI |  | 21 | 1 | -67 | 53 | 0 | 2 | 3
Profit | 1550 | -52 | -1 | 224 | -220 | 0 | -1 | -6 | 1494
Quarter ended Dec 12
Operating income |  | 1 | 0 | 0 | 0 | 0 | 1 | 17
Operating expenses |  | -14 | -14 | 0 | 0 | 0 | -1 | 0
Profit before credit impairment and tax |  | -13 | -14 | 0 | 0 | 0 | 0 | 17
Provision for credit impairment |  | 0 | 0 | 0 | 0 | 0 | 0 | 0
Profit before income tax |  | -13 | -14 | 0 | 0 | 0 | 0 | 17
Income tax expense & NCI |  | 4 | 4 | 0 | 0 | 0 | 0 | -5
Profit | 1533 | -9 | -10 | 0 | 0 | 0 | 0 | 12 | 1526
Spreadsheet: barry_tycholiz__814__calpinepayment
Sheet: Sheet1

 | ENRON NORTH AMERICA
 | CALPINE CORP
 | Volume | Volume |  |  | Payment To Calpine from ENA
 | Period 1 | Period 2 | Calpine Pays
 | 5/1/01 to | 11/1/08 to | Percent of |  |  | Monthly
 | 10/31/2008 | 2023-10-31 00:00:00 | Full Tolls |  | [NAME] | Annuity
 | MMBtu/d | MMBtu/d
Proposal 1 | 10000 | 67500 | 0.9 |  | 3506258.043337809 | 29799.36572972401
 | 15000 | 67500 | 0.9 |  | 3851649.945811154 | 32734.82071567258
 | 20000 | 67500 | 0.9 |  | 4197041.8482845 | 35670.27570162049
 | 25000 | 67500 | 0.9 |  | 4542433.750757845 | 38605.73068756895
 | 30000 | 67500 | 0.9 |  | 4887825.653231191 | 41541.18567351696
 | 35000 | 67500 | 0.9 |  | 5233217.555704535 | 44476.64065946513
 | 40000 | 67500 | 0.9 |  | 5578609.458177881 | 47412.08714650512
 | 47500 | 67500 | 0.9 |  | 6096697.311887899 | 51815.26962542719
Proposal  2 | 10000 | 10000 | 0.92 |  | 886312.8796185215 | 7532.693041415898
 | 15000 | 15000 |  |  | 1329469.319427783 | 11299.03531266964
 | 20000 | 20000 |  |  | 1772625.759237043 | 15065.38608283184
 | 25000 | 25000 |  |  | 2215782.199046309 | 18831.72835408557
 | 30000 | 30000 |  |  | 2658938.638855566 | 22598.0791242478
 | 35000 | 35000 |  |  | 3102095.078664836 | 26364.42139550147
 | 40000 | 40000 |  |  | 3545251.518474086 | 30130.77216566369
 | 47500 | 47500 |  |  | 4209986.178187985 | 35780.28557254429
 | Comments/Notes:
 | Payment based on % discount bid multiplied by ( ANG and PGT Tariff)
 | ANG tariff discount ends Oct 31, 2008.
 | Volume represents the delivered volume at Malin
 | No Spark Spread adjustment has been incorporated into this calculation
Spreadsheet: 791676d1660548635-formula-enhancement-for-detecting-numbers-lower-or-greater-by-1-in-row-above-lower-or-greater-by-1
Sheet: PRP

NUMBERS |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | LOWER by 1 | GREATER by 1 |  |  | PRIME | NON-prime | EVEN | ODD | NEXT |  |  |  |  |  |  |  |  |  | PRIME/NON-prime |  |  |  |  |  |  |  |  |  | EVEN/ODD
2 | 2 | 0 | 6
3 | 2 | 3 | 3
2 | 2 | 1 | 1
2 | 7 | 1
0 | 0 | 3 | 7
1 | 0 | 2 | 7
1 | 2 | 2 | 6
1 | 5 | 4 | 1
0 | 3 | 5
0 | 4 | 6
0 | 6 | 3
1 | 0 | 6 | 5
3 | 1 | 7
3 | 1 | 1 | 1
2 | 2 | 1 | 4
1 | 0 | 1
1 | 10
1 | 2 | 1 | 0
0 | 1 | 4 | 3
Spreadsheet: 810978d1672218688-divide-one-number-by-table-row-equally-test-file
Sheet: Sheet1

 | People | Divided Cost
 | Person 1 |  |  | Total Cost | 500
 | Person 2
 | Person 3
 | Person 4
 | Person 5
 | Person 6
 | Person 7
 | Person 8
 | Person 9
 | Person 10
 | person 11
Spreadsheet: 813516d1673832016-iferror-vlookup-help-when-lookup-is-not-found-or-column-sorted-different-vehicle-ef-gk
Sheet: July2022

Biosecurity Operations Branch Vehicle Fleet July 2022
[NAME] | Make | Lease | Location | Region | Cost Code | Responsible Area / Driver | Service Interval Mnths/Kms | Km carried forward | New car Km | vlookup lease | Current Kilometres | Current KM Decimal | Expected KM + 5000 | Expected KM - 5000 | Utilisation + or - 5 | Utilisation | Under / Over Agreement | Comments
G00DA | Toyota Rav4 | 36 mnths/60,000K | [NAME] | NW | BB8100112442 | Biosecurity Operations - Pool | 12 / 15,000 | 45 |  |  | 35668
G04CL | [NAME] Dual Cab 4x4 Ute | 36 mnths/60,000K | Mt Pleasant | N | BB8200402442 | Biosecurity Operations - Pool | 12 / 15,000 | 51.67 |  |  | 49735
G06CW | Toyota Corolla Hatchback | 36 mnths/60,000K | [NAME] | NW | BG2401302442 | Biosecurity Operations - Pool | 12 / 15,000 | 51.67 |  |  | 27844
Spreadsheet: 33882d1230742428-subtotal-and-data-source-workout
Sheet: Sheet1

 | Total    Daily   Workload | Ex 1 |  |  |  |  | Ex 2 |  |  |  |  | Ex 3 |  |  |  |  | Ex 4
 |  | 1 |  | 2 |  |  | 1 |  | 2 |  |  | Set 1 |  | Set 2 |  |  | Set 1 |  | Set 2
 |  | Rs | Kg | Rs | Kg | Total | Rs | Kg | Rs | Kg | Total | Rs | Kg | Rs | Kg | Total | Rs | Kg | Rs | Kg | Total
2008-12-16 00:00:00 | 3200 | 40 | 40 |  |  | 1600 |  |  |  |  | 0 | 40 | 40 |  |  | 1600 |  |  |  |  | 0
2008-12-19 00:00:00 | 3200 | 40 | 40 |  |  | 1600 |  |  |  |  | 0 | 40 | 40 |  |  | 1600 |  |  |  |  | 0
2008-12-24 00:00:00 | 3500 | 40 | 40 |  |  | 1600 | 20 | 15 |  |  | 300 | 40 | 40 |  |  | 1600 |  |  |  |  | 0
2008-12-29 00:00:00 | 3500 | 40 | 40 |  |  | 1600 | 20 | 15 |  |  | 300 | 40 | 40 |  |  | 1600 |  |  |  |  | 0
2008-12-31 00:00:00 | 0 |  |  |  |  | 0 |  |  |  |  | 0 |  |  |  |  | 0 |  |  |  |  | 0
Spreadsheet: tracy_geaccone__40500__Corp_2002_Alloc_2
Sheet: Summary

Corporate Staff Functions
Total Corporate Staff & Services Groups Charges
2002 Plan
(In thousands)
 |  |  |  |  |  |  |  | Northern |  | ETS |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | Total | Retained
 |  |  |  |  | TW | FGT | Citrus | Plains | NNG | HQ | EOTT | EEOS | NEPCO | ENA | Europe | EGM | EIM | EES | EBS | ENW | EGAS | EGF | EPI | PGG | Azurix | EPSC | Other | Allocated | At Corp
EXECUTIVE
LEGAL
RISK ASSESSMENT & CONTROL
ACCOUNTING & COMPLIANCE
CORPORATE TAX
INVESTOR RELATIONS
CORPORATE DEVELOPMENT
RISK MANAGEMENT
SAP ISC
STRATEGIC SOURCING
HUMAN RESOURCES & COMPENSATION
BENEFIT PLANS
PUBLIC AFFAIRS & ADMINISTRATION
COMMUNITY RELATIONS
EPSC |  |  |  |  | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0
 |  | GRAND TOTAL
Spreadsheet: 457065d1461183198-vacation-tracking-and-accruals-vacation-tracker-sample
Sheet: ACCRUALS

EMPLOYEE | START DATE | YEARS | ACCRUAL RATE (HRS)
EXAMPLE | 2005-06-09 00:00:00
EXAMPLE | 2015-07-29 00:00:00
EXAMPLE | 2012-11-02 00:00:00
VACATION DAYS POLICY
Years of Service |  |  | 0-1 | 1-5 | 5+
Annual Vaca Accruable Hours: |  |  | 40 | 80 | 120
Vaca Accrual Rate per Weekly Pay Period:
Spreadsheet: 49634d1248979833-how-to-recalculate-with-drop-down-menu-693671-how-to-recalculate-with-drop-down-menu
Sheet: Sheet3

(m) |  | (N) | (O) | (P) | (Q) | (R) |  | Now using
values |  | Tea | Coffee | Hot Chocolate | Milkshake | Water
1000
1500
500
100
500
 |  | the calculations above are based on sheet 2, column B: B2 to B6
 |  | what I need to do is to be able to use sheet 1 to choose option 1, or 2 or 3 from sheet 2
 |  | then I need the calculations above to be changed according to what drop down choice has been made
Spreadsheet: 781873d1653595860-sum-values-depending-on-several-criteria-text-and-number-criteria-test
Sheet: 538_odjeli

[NAME]
Šumarija:____Ogulin_______________________
Gospodarska jedinica:__Zagorska kosa________
Plan sječa za 2023.god. - G.J. po odjelima
 |  |  |  |  |  |  |  |  | T-1
R.br. | Odjel/ odsjek |  | [NAME]prihoda | [NAME] | Površina (ha) | Na cijeloj se površini sječe (m3) |  |  | [NAME]:
 |  |  |  |  |  | Etat | Do [NAME] | Plan za 2023.g.
1 | 8a |  | redoviti | [NAME] | 17.32 | 159 | 10 | 159 | raznodobna, panjača
 |  |  |  | otb |  | 9 | 2 | 9
 |  |  |  | o.bor |  | 21 |  | 21
2 | 9a |  | redoviti | [NAME] | 60.8 | 513 |  | 513 | raznodobna, panjača
 |  |  |  | otb |  | 44 |  | 44
3 | 27a |  | redoviti | [NAME] | 24.96 | 543 |  | 543 | preborna
 |  |  |  | [NAME] |  | 101 |  | 101
 |  |  |  | [NAME] |  | 1147 |  | 1147
 |  |  |  | smreka |  | 44 |  | 44
4 | 34a |  | redoviti | [NAME] | 49.47 | 2464 | 10 | 2454 | preborna
 |  |  |  | [NAME] |  | 148 |  | 148
 |  |  |  | [NAME] |  | 228 |  | 228
5 | 38a |  | redoviti | [NAME] | 30.76 | 921 |  | 921 | preborna
 |  |  |  | [NAME] |  | 181 |  | 181
 |  |  |  | [NAME] |  | 351 |  | 351
6 | 45a |  | redoviti | [NAME] | 33.27 | 799 |  | 799 | preborna
 |  |  |  | [NAME] |  | 82 |  | 82
 |  |  |  | [NAME] |  | 1540 |  | 1540
7 | 52a |  | redoviti | [NAME] | 47.32 | 934 |  | 934 | preborna
 |  |  |  | [NAME] |  | 2870 | 429 | 2441
8 | 53a |  | redoviti | [NAME] | 41.95 | 695 |  | 695 | preborna
 |  |  |  | [NAME] |  | 125 |  | 125
 |  |  |  | [NAME] |  | 1567 | 138 | 1429
9 | 999x |  | slučajni | [NAME] |  |  |  |  | sanitar
 |  |  |  | [NAME]
 |  |  |  | [NAME] |  | 250 |  | 250
 |  |  | Datum: |  |  |  | Revirnik:____________________________________
Spreadsheet: 859013d1707486123-linking-and-updating-worksheets-2026-2027-overview
Sheet: Sheet3

 | Week
 | Total Hours
 | [NAME]
 | Requested Hours
 | Approved Hours
 | Declined Hours
 | Remaining Hours
Spreadsheet: 128815d1321292581-multiple-conditional-formatting-overcoming-ve-divisors-portfolio-attribution
Sheet: Sheet1

Adventurous Portfolio
 |  |  |  |  |  |  |  | Attribution
Investment Funds/Sector | % Holding
Cash |  |  | WTD | 1m% | 3m% | YTD |  | WTD | 1m% | 3m% | YTD
Cash | 0.0411
 | 0.0411
Fixed Interest
 | 0
UK Equity
Std Life UK Smaller Companies | 0.0485 |  | 1.58 | 1.44 | -14.03 | -4.66 |  | 0.06721929824561404 | 0.06126315789473685 | -0.5968903508771931 | -0.1982543859649123
Invesco Income | 0.0425 |  | 1.45 | 5.18 | 0.54 | 7.15 |  | 0.05405701754385965 | 0.1931140350877193 | 0.02013157894736842 | 0.2665570175438597
 | 0.091
International Equity
i-shares MSCI AC Far East ex Japan | 0.0451 |  | 6.44 | 6.17 | -14.03 | -12.46 |  | 0.2547754385964913 | 0.2440938596491228 | -0.5550464912280703 | -0.4929350877192983
Premier Pan European Property | 0.0389
i-shares MSCI Emerging Markets | 0.0615
Threadneedle China Opportunities | 0.0348
 | 0.1803
Alternative Investments
[NAME] GARS | 0.0416
DB X Trackers FTSE 100 Short | 0.1021
DB X Trackers Short CAC 40 | 0.0617
DB X Trackers DJ Stoxx 600 [NAME] short | 0.1062
DB X Trackers Eurostoxx50 short | 0.0706
Eclectica Global Macro | 0.0752
 | 0.4574
Commodities
Investec Global Gold | 0.0628
Smith & Williamson Global Gold & Resources | 0.0412
ETFS Agriculture | 0.0281
ETFS Physical Gold | 0.0982
 | 0.2303
 | 1.0001 |  | 1.14 | 0.11 | -10.65 | -11.16
Spreadsheet: 676649d1588914520-powerquery-blank-query-with-excel-currentworkbook-not-loading-list-of-tables-sample
Sheet: Thursday

# | Date | Time | Symbol | Type | Price | Quantity | Commissions | Profit ($)
1 | 3/18/2016 | 6:00 AM | AAPL | Long Exit | 105.8 | 100 | 0 | 28
2 | 3/18/2016 | 6:00 AM | ABBV | Long Exit | 55.32 | 100 | 0 | -114
3 | 3/18/2016 | 6:00 AM | ABT | Long Exit | 40.29 | 100 | 0 | 9
4 | 3/18/2016 | 6:00 AM | ACN | Long Exit | 108.56 | 100 | 0 | 97
5 | 3/18/2016 | 6:00 AM | ADBE | Long Exit | 89.96 | 100 | 0 | 130
6 | 3/18/2016 | 6:00 AM | AGN | Long Exit | 272.7 | 100 | 0 | -65
7 | 3/18/2016 | 6:00 AM | AIG | Long Exit | 53.18 | 100 | 0 | 28
8 | 3/18/2016 | 6:00 AM | ALL | Long Exit | 67.2 | 100 | 0 | 87
9 | 3/18/2016 | 6:00 AM | AMGN | Long Exit | 144.13 | 100 | 0 | 41
Spreadsheet: 150722d1334669998-find-and-list-corresponding-values-in-a-column-in-descending-order-descending-order
Sheet: Sheet1

 |  |  |  |  |  |  |  |  |  |  |  | A | B | C | D | E | F | G | H | I | J | K | L | M | N | O | P | Q | R | S | T | U | V | W | X | Y | Z | AA | AB
 |  |  |  |  |  |  |  |  |  |  |  | 0.02021212727636582 | 0.07064238543125875 | 0.05263157894736842 | 0.08044826896137683 | 0.1420852511506904 | 0.06283770262157294 | 0.05143085851510906 | 0.1364818891334801 | 0.1060636381829097 | 0.0278166900140084 | 0.01681008605163098 | 0.05663398038823294 | 0.07164298579147488 | 0.03702221332799679 | 0.004802881729037423 | 0.002201320792475486 | 0.008805283169901942 | 0.01821092655593356 | 0.01600960576345807 | 0.009405643386031618 | 0.0006003602161296778 | 0 | 0.00100060036021613 | 0.001801080648389033 | 0.001600960576345807 | 0.001600960576345807 | 0.00100060036021613 | 0
 |  |  |  |  |  |  |  |  |  |  |  | E | 0.1420852511506904
 |  |  |  |  |  |  |  |  |  |  |  | H | 0.1364818891334801
 |  |  |  |  |  |  |  |  |  |  |  | I | 0.1060636381829097
 |  |  |  |  |  |  |  |  |  |  |  | D | 0.08044826896137683
 |  |  |  |  |  |  |  |  |  |  |  | M | 0.07164298579147488
 |  |  |  |  |  |  |  |  |  |  |  | B | 0.07064238543125875
 |  |  |  |  |  |  |  |  |  |  |  | .
 |  |  |  |  |  |  |  |  |  |  |  | .
 |  |  |  |  |  |  |  |  |  |  |  | .
 |  |  |  |  |  |  |  |  |  |  |  | .
 |  |  |  |  |  |  |  |  |  |  |  | .
 |  |  |  |  |  |  |  |  |  |  |  | .
Spreadsheet: 085235da-8fdd-4417-bc81-12b9f17ada2e
Sheet: Sheet1

PROG ID | ATHLETE ID | ATHLETE FIRST | ATHLETE LAST | NATIONALITY | START NUMBER | RUN | T1 | BIKE | T2 | SKI | POSITION | TOTAL TIME
7972 | 29863 | Romana | [NAME] | AUT | 48 | 00:29:10 | 00:00:00 | 00:39:00 | 00:00:00 | [NAME] | 1 | 01:44:07
7972 | 28247 | Tone | Dalen | NOR | 46 | 00:32:35 | 00:00:00 | [NAME] | 00:00:00 | 00:40:26 | 2 | 01:58:35
7972 | 28253 | Margarita | Ovsyannikva | RUS | 45 | 00:32:23 | 00:00:00 | 00:47:16 | 00:00:00 | 00:54:29 | 3 | 02:14:09
Spreadsheet: 851177d1701385992-filter-function-and-removing-duplicates-from-spill-array-filterspill
Sheet: Sheet2

Name | Random Food | Category | Random Color
[NAME] | [NAME] | Animals | Green
[NAME] | Cheese | Fruits | Pink
[NAME] | [NAME] | Animals | Blue
Amanda | Candy | Cars | Pink