tianzl66/Sheetpedia huggingface dataset:
Spreadsheet: 828813d1683739334-nested-xlookup-formula-returns-value-error-copyplantmeasurements2023-v3-mo
Sheet: StandardCurve

Relative Height | Relative Time
0 | 0
0.05 | 0.1
0.14 | 0.2
0.29 | 0.3
0.46 | 0.4
0.52 | 0.5
0.75 | 0.6
0.85 | 0.7
0.92 | 0.8
0.97 | 0.9
1 | 1
Spreadsheet: 91239d1290997434-calculating-true-false-from-group-of-variables-sample
Sheet: Sheet1

ID | pclc_1 | pclc_2 | pclc_3 | pclc_4 | pclc_5 | pclc_6 | pclc_7 | pclc_8 | pclc_9 | pclc_10 | pclc_11 | pclc_12 | pclc_13 | pclc_14 | pclc_15 | [NAME] | pclc_17
 | 3 | 2 | 2 | 2 | 2 | 1 | 2 | 1 | 1 | 2 | 1 | 1 | 1 | 1 | 2 | 1 | 2
 | 1 | 2 | 1 | 1 | 1 | 1 | 2 | 1 | 1 | 2 | 1 | 1 | 1 | 1 | 2 | 2 | 2
Spreadsheet: 120073d1314965526-adding-values-based-on-both-month-and-text-criteria-saving-rev1
Sheet: Sheet1

 |  |  |  |  |  |  |  |  | 2011-08-31 00:00:00 | 2011-07-31 00:00:00 | 2011-06-30 00:00:00 | 2011-05-31 00:00:00 | 2011-04-30 00:00:00 | 2011-03-31 00:00:00 | 2011-02-28 00:00:00 | 2011-01-31 00:00:00 | Average
 |  |  |  |  |  |  |  | Rent
 |  |  |  |  |  |  |  | Food
 | Feb |  |  |  |  |  |  | Petrol
 | Mar |  |  |  |  |  |  | Social
 | Apr |  |  |  |  |  |  | Misc
 | May |  |  |  |  |  |  | Holiday 2011
 | Jun |  |  |  |  |  |  | Holiday 2012
 | Jul |  |  |  |  |  |  | Car Insurance
 | Aug |  |  |  |  |  |  | Car Service/MOT
 |  |  |  |  |  |  |  | Gym
 |  |  |  |  |  |  |  | Tattoo
 |  |  |  |  |  |  |  | Misc
 |  |  |  |  |  |  |  | Phone
 |  |  |  |  |  |  |  | clothes
 |  |  |  |  |  |  |  | income
 |  |  |  |  |  |  |  | Salary
Spreadsheet: 35825464-5fed-4738-8ee9-b8d11ef37ef5
Sheet: RebbachisaurusMNHN1512a

 | L1 | L2 | Ratio | Area | Scratch Length | Scratch Breadth
SCRATCHES | 454.8095196809304 | 4.288166333262067 | 106.0615387404878
 | 274.5766178265389 | 3.953494014977626 | 69.45163361480208
 | 160.0612295389627 | 3.032191493105461 | 52.78730908087662
 | 96.92109713991483 | 2.144083166631034 | 45.20398212547209
 | 71.18872741013601 | 2.144083166631034 | 33.20240955111542
 | 73.85736327094207 | 6.139719824921215 | 12.02943544282818
 | 32.61544470836834 | 4.288166333262067 | 7.605918747922569
PITS/GOUGES | 9.58863142 | 13.82892089853403 | 1.442220510185596
 | 10.93272190541745 | 15.46120359229478 | 1.414213562373095
 | 19.39180694933352 | 14.41487379998387 | 1.345263733724483
 | 17.68056273225708 | 13.72883089132695 | 1.287841832433569
 | 15.87200919460403 | 19.76747007488813 | 1.245429600784785
 | 14.25452538824183 | 17.28615112316754 | 1.212678125181665
 | 14.38294713 | 17.3657500911491 | 1.207384685084989
 | 11.58598742717134 | 13.72883089132695 | 1.184951302392253
 | 7.730601796147392 | 9.09657447931638 | 1.176696810829104
 | 10.93272190541745 | 12.50204580317314 | 1.143543749793732
 | 23.99074814806546 | 25.889304834 | 1.079137035419532
 | 15.72652483062181 | 16.77325456422665 | 1.066558234885225
 | 13.72883089132695 | 14.60496825809553 | 1.063817332568506
 | 5.424149039504316 | 5.424149039504316 | 1
Spreadsheet: 803960d1667825110-display-duplicates-rows-from-two-arrays-table-display_duplicates_two_columns-hd_emptycells
Sheet: Feuil1

DUPLICATES | yellow a (2), blue b (3)
 | expected result |  |  | actual result
level | color
a | yellow
b | yellow
c | black
a | black
a | yellow
b | blue
b | blue
b | black
b | blue
Spreadsheet: df0d23c0-a412-4180-a5d3-256e3bc4434f
Sheet: Sheet1

PROG ID | ATHLETE ID | ATHLETE FIRST | ATHLETE LAST | NATIONALITY | START NUMBER | RUN | T1 | SWIM | T2 | RUN.1 | POSITION | TOTAL TIME
260014 | 30688 | [NAME] | Smith | GBR | 10030 | 00:00:00 | 00:00:00 | 00:20:31 | [NAME] | 00:20:07 | 1 | 00:42:05
Spreadsheet: 887533d1737754000-generating-1-column-of-data-into-a-calendar-reviews-calendar-test2
Sheet: Aug

 |  |  | 2025-07-28 00:00:00 | 2025-07-29 00:00:00 | 2025-07-30 00:00:00 | 2025-07-31 00:00:00 | 2025-08-01 00:00:00 | 2025-08-02 00:00:00
 |  |  | 2025-08-04 00:00:00 | 2025-08-05 00:00:00 | 2025-08-06 00:00:00 | 2025-08-07 00:00:00 | 2025-08-08 00:00:00 | 2025-08-09 00:00:00
 |  |  | 2025-08-11 00:00:00 | 2025-08-12 00:00:00 | 2025-08-13 00:00:00 | 2025-08-14 00:00:00 | 2025-08-15 00:00:00 | 2025-08-16 00:00:00
 |  |  | 2025-08-18 00:00:00 | 2025-08-19 00:00:00 | 2025-08-20 00:00:00 | 2025-08-21 00:00:00 | 2025-08-22 00:00:00 | 2025-08-23 00:00:00
 |  |  | 2025-08-25 00:00:00 | 2025-08-26 00:00:00 | 2025-08-27 00:00:00 | 2025-08-28 00:00:00 | 2025-08-29 00:00:00 | 2025-08-30 00:00:00
 |  |  | 2025-09-01 00:00:00 | Notes
Spreadsheet: 80690d1280910973-multiple-conditional-formatting-conditional-formatting-issue
Sheet: Sheet1

 | Period | Result |  |  |  | 1
Income | Qtr1 | 1000
Income | Qtr2 | 2000
Income | Qtr3 | 3000
Income | Qtr4 | 4000
# Clients | Qtr1 | 50
# Clients | Qtr2 | 60
# Clients | Qtr3 | 70
# Clients | Qtr4 | 80
Product % | Qtr1 | 0.1
Product % | Qtr2 | 0.2
Product % | Qtr3 | 0.3
Product % | Qtr4 | 0.4
Spreadsheet: 721397d1614690364-need-help-to-remove-false-and-shorten-the-formula-sample-workbook-revised-
Sheet: Costs

 |  | Supplies Cost | Facility Cost | Other Cost
Specialist Outpatient Clinic | Standard subsidised clinic (per attendance) | 3 | 3 | 3
Specialist Outpatient Clinic | High volume subsidised clinic (per attendance) | 2 | 2 | 2
Specialist Outpatient Clinic | Private clinic (per attendance) | Not Applicable | 1 | Not Applicable
Inpatient Ward | Acute ward (per patient day) | 3 | 3 | 3
Inpatient Ward | Subacute ward (per patient day) | 2 | 2 | 2
Inpatient Ward | ICU/HD ward (per patient day) | 1 | 1 | 1
Operating Theatre | per procedure | 1 | 2 | 2
Operating Theatre | per session (4 hours) | Not Applicable | 1 | 1
Endoscopy Room | per procedure | 1 | 2 | 2
Endoscopy Room | per session (4 hours) | Not Applicable | 1 | 1
Spreadsheet: 77879d1278381288-excel-2007-excel-to-record-values-on-a-weekly-basis-finance
Sheet: Main

 | TOTALS | AUD |  | PLN |  | GBP |  | USD |  | EURO
 |  | Cash: |  | Cash: |  | Cash: |  | Cash: |  | Cash: |  |  | AUD ->
 |  |  |  | BZ: |  | Lloyds: |  | BZ: |  |  |  |  | PLN ->
 |  |  |  | Comp: |  | Lloyds IS: |  | PNC: |  |  |  |  | GBP ->
 |  |  |  |  |  | BZ: |  |  |  |  |  |  | USD ->
 |  |  |  |  |  |  |  |  |  |  |  |  | EUR ->
When? | What? | AUD $ | PLN zl | PLN BZ | GBP £ | GBP LL | GBP BZ | GBP LL IS | USD $ | USD BZ | USD PNC | EUR € | PLN CO
 | Starter | 1000 | 2000 | 1000 | 2000 | 1000 | 2000 | 1000 | 2000 | 1000 | 2000 | 1000 | 2000
2010-07-05 00:00:00 | Lunch | -8.5
2010-07-05 00:00:00 | Lunch | -2.4
2010-07-05 00:00:00 | Coffe | -2.5 |  |  |  |  |  |  |  |  |  |  |  |  |  | 1090.4 |  | 1382.36 | 3.55 | 80.86 |  | 7.25 | 1.81
2010-07-05 00:00:00 | Dinner | -14.9
2010-07-06 00:00:00 | Lunch
Spreadsheet: 147516d1332830110-need-help-with-a-hlookup-formula-example
Sheet: April

 | 2012 | April
 |  | 2012-03-27 00:00:00 | 2012-03-28 00:00:00 | 2012-03-29 00:00:00 | 2012-03-30 00:00:00 | 2012-03-31 00:00:00 | 2012-04-01 00:00:00 | 2012-04-02 00:00:00 | 2012-04-03 00:00:00 | 2012-04-04 00:00:00 | 2012-04-05 00:00:00 | 2012-04-06 00:00:00 | 2012-04-07 00:00:00 | 2012-04-08 00:00:00 | 2012-04-09 00:00:00 | 2012-04-10 00:00:00 | 2012-04-11 00:00:00 | 2012-04-12 00:00:00 | 2012-04-13 00:00:00 | 2012-04-14 00:00:00 | 2012-04-15 00:00:00 | 2012-04-16 00:00:00 | 2012-04-17 00:00:00 | 2012-04-18 00:00:00 | 2012-04-19 00:00:00 | 2012-04-20 00:00:00 | 2012-04-21 00:00:00 | 2012-04-22 00:00:00 | 2012-04-23 00:00:00 | 2012-04-24 00:00:00 | 2012-04-25 00:00:00 | 2012-04-26 00:00:00 | 2012-04-27 00:00:00 | 2012-04-28 00:00:00 | 2012-04-29 00:00:00 | 2012-04-30 00:00:00
 | Accounts
 | Rod | 0 | 0 | 0 | 0 | W | W |  |  |  |  | B | W | W | B | H | H | H | H | W | W |  |  |  |  |  | W | W |  |  |  |  |  | W | W |  |  |  |  | Y | Present
 | [NAME] | 0 | 0 | 0 | 0 | W | W |  |  |  |  | B | W | W | B |  |  |  |  | W | W |  |  |  | H |  | W | W |  |  |  |  |  | W | W
 | [NAME] | s | s | s | s | W | W |  |  |  |  | B | W | W | B |  |  |  |  | W | W |  |  |  |  |  | W | W |  |  |  |  |  | W | W |  |  |  |  | W | Weekend
 | Bungle | 0 | 0 | 0 | 0 | W | W |  |  |  |  | B | W | W | B |  |  |  |  | W | W |  |  |  |  | H | W | W |  |  |  |  |  | W | W |  |  |  |  | S | Sick Day
 | Zippy | 0 | 0 | 0 | 0 | W | W |  |  |  |  | B | W | W | B |  |  |  |  | W | W |  |  |  |  |  | W | W |  |  |  |  |  | W | W |  |  |  |  | S.5 | Half day sick
 | [NAME] | 0 | 0 | 0 | 0 | W | W |  |  |  |  | B | W | W | B |  |  |  |  | W | W |  |  |  |  |  | W | W |  |  |  |  |  | W | W |  |  |  |  | H | Holiday Full Day
 |  | 0 | 0 | 0 | 0 | W | W |  |  |  |  | B | W | W | B |  |  |  |  | W | W |  |  |  |  |  | W | W |  |  |  |  |  | W | W |  |  |  |  | H.5 | Holiday Half Day
 |  | 0 | 0 | 0 | 0 | W | W |  |  |  |  | B | W | W | B |  |  |  |  | W | W |  |  |  |  |  | W | W |  |  |  |  |  | W | W |  |  |  |  | A | Absent Day
 |  | 0 | 0 | 0 | 0 | W | W |  |  |  |  | B | W | W | B |  |  |  |  | W | W |  |  |  |  |  | W | W |  |  |  |  |  | W | W |  |  |  |  | B | Bank Holiday
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | √ | Time Recorded
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | Training
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | Not worked (part time)
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | L | Lieu day
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | C | Cover
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | NM | No more off
Spreadsheet: 686113d1594371319-finding-data-across-multiple-sheets-excelforum__help_file
Sheet: CZ_Jan

X
 |  | 1 | green
 |  | 2 | blue
 |  | 3
 |  | 4 | yellow
 |  | 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
Spreadsheet: 802567d1666918796-lazy-old-man-needs-formula-to-sum-values-by-month-need-formula-for-total-column-thanks-
Sheet: Sheet1

Input |  |  |  | Output
Dates | Numbers |  |  | Months Away | Total | Month |  | Note the "OUTPUT" list will automatically calculate so that "Months Away" = 0 will always be the actual current month and the next 24 months (after the current month) will always be displayed. Each month will show the sum of "Numbers" in the [NAME] table that fall within that month.  Any data with dates before the current month will be ignored.  "Months Away" ("0" equals current month, 1= Next month, etc.)  "Total" is the sum of all the Numbers from the [NAME] table in the month (I need a formula for this).  "Month" is the month and year of the month that is "Month's Away" number of months away from the current month. (I need a formula for this)  I just use Edate() for the Month column.  What I need is the formula for the "Total" column.  If possible please provide it as a single formula rather than broken into parts in additional columns.
2023-03-10 00:00:00 | 186 |  | (current month)> | 0 |  | 2023-03-01 00:00:00
2023-08-16 00:00:00 | 70.96 |  | (next month)> | 1 |  | 2023-04-01 00:00:00
2024-12-24 00:00:00 | 50 |  | etc. | 2 |  | 2023-05-01 00:00:00
2024-05-20 00:00:00 | 88.44 |  | . | 3 |  | 2023-06-01 00:00:00
2024-12-03 00:00:00 | 96 |  | . | 4 |  | 2023-07-01 00:00:00
2023-04-02 00:00:00 | 43.27 |  | . | 5 |  | 2023-08-01 00:00:00
2023-03-24 00:00:00 | 499.33 |  | . | 6 |  | 2023-09-01 00:00:00
2024-07-04 00:00:00 | 7 |  | . | 7 |  | 2023-10-01 00:00:00
 |  |  | . | 8 |  | 2023-11-01 00:00:00
Note data pairs in list will be in random date order. |  |  | . | 9 |  | 2023-12-01 00:00:00
 |  |  | . | 10 |  | 2024-01-01 00:00:00
 |  |  |  | 11 |  | 2024-02-01 00:00:00
 |  |  |  | 12 |  | 2024-03-01 00:00:00
 |  |  |  | 13 |  | 2024-04-01 00:00:00
 |  |  |  | 14 |  | 2024-05-01 00:00:00
 |  |  |  | 15 |  | 2024-06-01 00:00:00
 |  |  |  | 16 |  | 2024-07-01 00:00:00
 |  |  |  | 17 |  | 2024-08-01 00:00:00
 |  |  |  | 18 |  | 2024-09-01 00:00:00
 |  |  |  | 19 |  | 2024-10-01 00:00:00
 |  |  |  | 20 |  | 2024-11-01 00:00:00
 |  |  |  | 21 |  | 2024-12-01 00:00:00
 |  |  |  | 22 |  | 2025-01-01 00:00:00
 |  |  |  | 23 |  | 2025-02-01 00:00:00
 |  |  |  | 24 |  | 2025-03-01 00:00:00
Spreadsheet: 884593d1733827065-automatically-export-data-from-multiple-sheets-if-it-matches-into-a-combined-sheet-tester-2
Sheet: Names

No | [NAME] | Seller Company Name
1 | A1 | A
 | B2 | B
 | [NAME] | C
 | D4 | D
 | E5 | E
 | F6 | F
 | G7 | G
 | H8 | H
 | I9 | I
 | J10 | J
 | K11 | K
 | L12 | L
 | [NAME] | M
 | [NAME] | N
 | O15 | O
 | P16 | P
 | Q17 | Q
 | R18 | R
 | S19 | S
 | T20 | T
 | U21 | U
 | V22 | V
 | W23 | W
 | X24 | X
 | Y25 | Y
 | Z26 | Z
Spreadsheet: 218100d1362347231-employee-vacation-calendar-help-vacation-bid-results
Sheet: Results_input

Officer Name | Shift | Hours | Determination | Date
Larsen-Shields | First | 8 | Approved | 2013-01-05 00:00:00
Coyle | First | 8 | Approved | 2013-01-05 00:00:00
[NAME] | First | 8 | Approved | 2013-01-05 00:00:00
[NAME] | First | 8 | Approved | 2013-01-01 00:00:00
[NAME] | First | 100 | Approved | 2013-01-01 00:00:00
[NAME] | First | 8 | Approved | 2013-01-02 00:00:00
[NAME] | First | 8 | Approved | 2013-01-02 00:00:00
Larsen-Shields | First | 8 | Approved | 2013-01-03 00:00:00
Coyle | First | 8 | Approved | 2013-01-03 00:00:00
[NAME] | First | 8 | Approved | 2013-01-03 00:00:00
Fountain | First | 8 | Approved | 2013-01-03 00:00:00
Larsen-Shields | First | 8 | Approved | 2013-01-06 00:00:00
Coyle | First | 8 | Approved | 2013-01-06 00:00:00
[NAME] | First | 8 | Approved | 2013-01-06 00:00:00
[NAME] | First | 8 | Approved | 2013-01-06 00:00:00
[NAME] | Second | 8 | Approved | 2013-01-05 00:00:00
[NAME] | Second | 8 | Approved | 2013-01-05 00:00:00
[NAME] | Second | 8 | Approved | 2013-01-01 00:00:00
[NAME] | Second | 8 | Approved | 2013-01-01 00:00:00
[NAME] | Second | 8 | Approved | 2013-01-02 00:00:00
[NAME] | Second | 8 | Approved | 2013-01-02 00:00:00
Ycaza | Second | 8 | Approved | 2013-01-02 00:00:00
[NAME] | Second | 8 | Approved | 2013-01-03 00:00:00
[NAME] | Second | 8 | Approved | 2013-01-03 00:00:00
Ycaza | Second | 8 | Approved | 2013-01-03 00:00:00
[NAME] | Second | 132 | Approved | 2013-01-06 00:00:00
[NAME] | Second | 8 | Approved | 2013-01-06 00:00:00
Ycaza | Second | 8 | Approved | 2013-01-06 00:00:00
Fountain | First | 8 | Denied | 2013-01-05 00:00:00
Larsen-Shields | First | 8 | Denied | 2013-01-01 00:00:00
Coyle | First | 8 | Denied | 2013-01-01 00:00:00
Larsen-Shields | First | 8 | Denied | 2013-01-02 00:00:00
Coyle | First | 8 | Denied | 2013-01-02 00:00:00
Larsen-Shields | First | 8 | Denied | 2013-01-04 00:00:00
Coyle | First | 8 | Denied | 2013-01-04 00:00:00
[NAME] | First | 8 | Denied | 2013-01-04 00:00:00
Fountain | First | 8 | Denied | 2013-01-04 00:00:00
Ycaza | Second | 8 | Denied | 2013-01-05 00:00:00
Ycaza | Second | 8 | Denied | 2013-01-01 00:00:00
[NAME] | Second | 8 | Denied | 2013-01-04 00:00:00
[NAME] | Second | 8 | Denied | 2013-01-04 00:00:00
Ycaza | Second | 8 | Denied | 2013-01-04 00:00:00
Roche | First | 8 | Approved | 2013-01-20 00:00:00
Rodriguez, E | First | 114 | Approved | 2013-04-02 00:00:00
Spreadsheet: 22975d1212248545-score-calculation-scorecalculating
Sheet: Sheet1

1. Array formula
Grouping | Team | Score | Points | Max of Group | Min of Group | Result 1 | Result2 (Combind formula)
1 | A | 105 | 0.5 | 105 | 105 | 0.5 | 0.5
2 | B | 95 | 0 | 201 | 95 | 0 | 0
3 | C | 205 | 1 | 205 | 200 | 1 | 1
1 | D | 105 | 0.5 | 105 | 105 | 0.5 | 0.5 |  | Note: Ctrl+ Shift + Enter
2 | E | 201 | 1 | 201 | 95 | 1 | 1
3 | F | 200 | 0 | 205 | 200 | 0 | 0
2. Alternative way:
Grouping | Team | Score | Points | Result |  |  | Sort the data first based on [NAME], then on score
1 | A | 105 | 0.5 | 0.5 |  |  | The green cells have the same formula,and the yellow, another.
1 | D | 105 | 0.5 | 0.5 |  |  | type the first 2 formulas, select both cells, then fill down.
2 | B | 95 | 0 | 0
2 | E | 201 | 1 | 1
3 | F | 200 | 0 | 0
3 | C | 205 | 1 | 1
Spreadsheet: 8a24aa3b-0f41-49b3-a8a5-3f366462a618
Sheet: Sheet1

Unnamed: 0 | Unnamed: 1 | 4. Pielikums
Peldvietu saraksts
 | Balvi, Balvu rajons
1 | Balvu ezers | Kubuļu pag.
2 | Balvu ezers | Ezermalas - 2
3 | Bolupe, | Balvu pilsēta
4 | Cukusala | Rugāju pag.
5 | Viļakas ezers | Viļaka
 | Rēzekne, Rēzeknes rajons
1 | [NAME] ezers | [NAME].
2 | Bižu ezers. | Griškānu pag
3 | Feimaņu ezers | Feimaņu pag.
4 | Kovšu ezers | Rēzekne
5 | Bekšu ciema ūdenskrātuve | Ozolaines pag.
6 | Maltas upe | [NAME]
7 | [NAME] ezers . | [NAME] pag
8 | Rāznas ezers | Kaunatas pag.
9 | Rēzeknes upe | Rēzekne
10 | Ritiņu ezers | Ozolaines pag.
11 | Tiskādu ezers | [NAME] pag.
12 | Vertukšnes ezers | [NAME] pag.
 | [NAME], [NAME] rajons
1 | Cirmas ezers | Cirmas pag.
2 | [NAME] ezers | [NAME]
3 | [NAME] ezers | Isnaudas pag.
4 | Limankas ezers | Pelēču pag.
5 | [NAME] ezers | [NAME]
6 | Nirzas ezers | Nirzas pag.
7 | Pelēču ezers | Pelēču pag.
8 | Rītupe . | [NAME] pag
9 | Zilupes upe | Zilupe
10 | Zvirgzdenes ezers | Zvirgzdenes pag.
 | Preiļi, Preiļu rajons
1 | Cirīšu ezers | Aglonas pag.
2 | Daugavas upe | Līvāni
3 | Dubnas upe | [NAME]
4 | Eikša ezers | Rušonas pag.
5 | Feimankas ūdenskrātuve | Gailīšu pag.
6 | Gaiļīšu ezers | Rušonas pag.
7 | Līvānu ezers | Turku pag.
8 | Preiļupe | Preiļi
9 | [NAME] ezers | Aglonas pag.
 | Daugavpils, Daugavpils rajons
1 | Baltezers | Vaboles pag
2 | Briģenes ezers | Demenes pag.
3 | Daugavas upe | Dvietes pag.
4 | Daugavas upe | [NAME].
5 | Kirjanišķu ezers | Salienas pag.
6 | Klapiņu ezers | Salienas pag.
7 | Koša ezers | [NAME].
8 | Lielais stropu ezers | Daugavpils
9 | [NAME] ezers | Višķu pag.
10 | [NAME], | mikrorajons “Stropi” Daugavpils
11 | Meduma ezers | Meduma pag.
12 | [NAME] “Rugeļi” mākslīgā ūdenskrātuve | Daugavpils
13 | [NAME] ezers | Demenes pag.
14 | Sasaļu ezers | Sventes pag.
15 | Sila ezers | Skrudalienas pag.
16 | Subates ezers | Subate
17 | Sventes ezers | Sventes pag.
18 | [NAME] ezers | Subate
19 | [NAME] ezers | Eglaines pag.
20 | Šūņezers, | mikrorajons “Vecā Forštadte” Daugavpils
21 | Viragnes ezers | Višķu pag.
22 | Višķu ezers | Višķu pag.
 | Krāslava, [NAME] rajons
1 | Dagdas ezers . | Dagdas pag
2 | Daugavas upe | Ūdrīšu pag.
3 | Dridža ezers | Skaistas pag.
4 | Ežezers | Ezernieku pag.
5 | Ilzas-Geraņimovas ezers | [NAME] pag.
6 | Jazinka ezers | Gravieru pag.
7 | Ojatu ezers | [NAME] pag., [NAME]
8 | Sivera ezers | [NAME] pag., [NAME]
9 | Zirga ezers | [NAME]
Spreadsheet: 0c8f4421-1230-4c2c-bbbc-c4f1cec96ae0
Sheet: Sheet1

CD or FLOPPY DISKETTE RECORD LAYOUT | Unnamed: 1 | Unnamed: 2 | Unnamed: 3 | Unnamed: 4
 | COLUMN HEADING | FIELD SIZE | FORMAT | [NAME]
1 | LEASENO | 20 | GENERAL | Lessor's LEASE indentificaton number.
2 | LESSEENO | 20 | GENERAL | Lessor's LESSEE identification number.
3 | LESSEE | 25 | GENERAL | [NAME].
4 | LESSEECORP | 25 | GENERAL | [NAME] if a Corp if applicable.
5 | LESSEECORPDBA | 25 | GENERAL | [NAME] if applicable.
6 | EQUIPLOCSTRNO | 6 | GENERAL | Equipment LOCATION street number.
7 | EQUIPLOCSTRDIR | 1 | GENERAL | Equipment LOCATION street direction.
8 | EQUIPLOCSTRNME | 25 | GENERAL | Equipment LOCATION street name.
9 | EQUIPLOCSTRSFFX | 2 | GENERAL | Equipment LOCATION street suffix.
10 | EQUIPLOCUNITNO | 5 | GENERAL | Equipment LOCATION unit number.
11 | EQUIPLOCCITY | 25 | GENERAL | Equipment LOCATION city.
12 | EQUIPLOCZIP5 | 5 | GENERAL | Equipment LOCATION zip code 5-digits.
13 | EQUIPLOCZIP4 | 4 | GENERAL | Equipment LOCATION zip code 4-digits.
14 | EQUIPMADSTRNO | 6 | GENERAL | Equipment MAILING ADDRESS if different from location.
15 | EQUIPMADSTRDIR | 1 | GENERAL | Equipment MAILING ADDRESS if different from location.
16 | EQUIIPMADSTRNME | 25 | GENERAL | Equipment MAILING ADDRESS if different from location.
17 | EQUIPMADSTRSFFX | 2 | GENERAL | Equipment MAILING ADDRESS if different from location.
18 | EQUIPMADUNITNO | 5 | GENERAL | Equipment MAILING ADDRESS if different from location.
19 | EQUIPMADCITY | 25 | GENERAL | Equipment MAILING ADDRESS if different from location.
20 | EQUIPMADST | 2 | GENERAL | Equipment MAILING ADDRESS if different from location.
21 | EQUIPMADZIP5 | 5 | GENERAL | Equipment MAILING ADDRESS if different from location.
22 | EQUIPMADZIP4 | 4 | GENERAL | Equipment MAILING ADDRESS if different from location.
23 | EQUIPDESC | 30 | GENERAL | Equipment DESCRIPTION.
24 | STARTDATE | 8 | GENERAL | Lease START DATE (mm/dd/yy).
25 | ENDATE | 8 | GENERAL | Lease END DATE (mm/dd/yy).
26 | [NAME] | 6 | GENERAL | Equipment ACQUISITION DATE.
27 | EQUIPCOST | 9 | GENERAL | Equipment ACQUISITION COST.
28 | ANNUALRENT | 9 | GENERAL | Equipment ANNUAL RENT.
29 | ORIGSELLPR | 9 | GENERAL | Equipment SELLING PRICE (financing lease).
30 | ORIGSELLPRMFG | 9 | GENERAL | Equipment SELLING PRICE if lessor = manufacturer.
31 | LSETYPETRUELSE | 2 | GENERAL | Lease type TRUE LEASE/CONDITIONAL SALE
32 | LSETYPEOTHER | 30 | GENERAL | Lease type OTHER.
33 | TAXOBLIG | 2 | GENERAL | TAX OBLIGATION, lessee or lessor.
34 | ACCTNOLSOR | 12 | GENERAL | Assessor's use: LESSOR'S ACCOUNT NUMBER.
35 | ACCTNOLSEE | 12 | GENERAL | Assessor's use: [NAME]'S ACCOUNT NUMBER.
36 | TRDFIXTALLOC | 6 | GENERAL | Assessor's use: TRADE FIXTURE ALLOCATION.
37 | PERSPROPALLOC | 6 | GENERAL | Assessor's use: PERSONAL PROPERTY ALLOCATION.
38 | FCV | 9 | GENERAL | Assessor's use: FULL CASH VALUE.
Spreadsheet: 872399d1718797444-countifs-but-ignoring-duplicates-in-1-column-testdata-clientcountv2-aligw
Sheet: Data

Client | Team | Purchase Type | Review Completed |  |  |  |  | May-24 | Apr-25 | May-25
1 | ICT | SPOT | 2024-04-15 00:00:00
2 | ICT | Commission | 2024-04-15 00:00:00 |  |  | ICT
3 | BAU | Commission | 2024-04-15 00:00:00 |  |  | Review
4 | Review | Commission | 2024-04-15 00:00:00
5 | ICT | Commission | 2024-04-15 00:00:00
6 | Review | SPOT | 2024-04-15 00:00:00
6 | Review | SPOT | 2024-04-15 00:00:00
7 | Review | Commission | 2024-04-15 00:00:00
8 | BAU | SPOT | 2024-04-15 00:00:00
9 | BAU | SPOT | 2024-05-15 00:00:00
10 | ICT | Commission | 2024-05-15 00:00:00
10 | ICT | Commission | 2024-05-15 00:00:00
11 | ICT | SPOT | 2024-05-15 00:00:00
12 | BAU | SPOT | 2024-05-15 00:00:00
12 | BAU | SPOT | 2024-05-15 00:00:00
13 | BAU | Commission | 2024-05-15 00:00:00
14 | BAU | Commission | 2024-05-15 00:00:00
111 | ICT | SPOT | 2025-04-15 00:00:00
112 | ICT | Commission | 2025-04-15 00:00:00
113 | BAU | Commission | 2025-04-15 00:00:00
114 | Review | Commission | 2025-04-15 00:00:00
115 | BAU | Commission | 2025-04-15 00:00:00
116 | Review | SPOT | 2025-04-15 00:00:00
116 | Review | SPOT | 2025-04-15 00:00:00
117 | BAU | Commission | 2025-04-15 00:00:00
118 | BAU | SPOT | 2025-04-15 00:00:00
119 | BAU | SPOT | 2025-05-15 00:00:00
110 | BAU | Commission | 2025-05-15 00:00:00
110 | BAU | Commission | 2025-05-15 00:00:00
111 | ICT | SPOT | 2025-05-15 00:00:00
112 | ICT | SPOT | 2025-05-15 00:00:00
112 | ICT | SPOT | 2025-05-15 00:00:00
113 | ICT | Commission | 2025-05-15 00:00:00
114 | ICT | Commission | 2025-05-15 00:00:00
Spreadsheet: daren_farmer__5984__SMI128reveff061700
Sheet: Sheet1

To:   [NAME]          (Enron)
From: [NAME] ([NAME])
Date:  6/16/00
Subject:  Revised Availabilities Effective 6/17/00
Effective Date | CTP NAME | Gross Vol. (MMBtu/d) | PVR % | PVR Volume | Avail. After PVR (MMBtu/d) | DBQ | Excess
2000-06-17 00:00:00 | SMI 128 | 1385 | 0.1763 |  |  | 1141
1st of month DBQ = 1156/d
Spreadsheet: 77879d1278381288-excel-2007-excel-to-record-values-on-a-weekly-basis-finance
Sheet: Monit

Week ending | Total
2010-07-11 00:00:00 |  | <---- | i want this value to be recorded at the end of one week and stay like this even if the reference cells are changing
2010-07-18 00:00:00 |  |  | which will definitely happen (currency xr fluctuations and change in the total)
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