tianzl66/Sheetpedia huggingface dataset:
Spreadsheet: 266487d1379625219-use-selections-from-two-data-validation-lists-to-lookup-and-return-a-combined-result-state-countyfipscode1
Sheet: ILLINOIS-12

 | COUNTY | CODE
 | Adams | 1
 | [NAME] | 3
 | Bond | 5
 | Boone | 7
 | [NAME] | 9
 | Bureau | 11
 | [NAME] | 13
 | Carroll | 15
 | [NAME] | 17
 | Champaign | 19
 | Christian | 21
 | [NAME] | 23
 | Clay | 25
 | [NAME] | 27
 | Coles | 29
 | [NAME] | 31
 | Crawford | 33
 | Cumberland | 35
 | DeKalb | 37
 | [NAME] | 39
 | [NAME] | 41
 | DuPage | 43
 | Edgar | 45
 | Edwards | 47
 | [NAME] | 49
 | Fayette | 51
 | Ford | 53
 | Franklin | 55
 | Fulton | 57
 | [NAME] | 59
 | Greene | 61
 | [NAME] | 63
 | [NAME] | 65
 | Hancock | 67
 | Hardin | 69
 | Henderson | 71
 | [NAME] | 73
 | Iroquois | 75
 | [NAME] | 77
 | Jasper | 79
 | [NAME] | 81
 | Jersey | 83
 | [NAME] | 85
 | [NAME] | 87
 | [NAME] | 89
 | Kankakee | 91
 | Kendall | 93
 | Knox | 95
 | Lake | 97
 | [NAME] | 99
 | [NAME] | 101
 | [NAME] | 103
 | [NAME] | 105
 | Logan | 107
 | McDonough | 109
 | McHenry | 111
 | McLean | 113
 | Macon | 115
 | Macoupin | 117
 | [NAME] | 119
 | Marion | 121
 | [NAME] | 123
 | Mason | 125
 | Massac | 127
 | Menard | 129
 | Mercer | 131
 | Monroe | 133
 | Montgomery | 135
 | Morgan | 137
 | Moultrie | 139
 | Ogle | 141
 | Peoria | 143
 | [NAME] | 145
 | [NAME] | 147
 | Pike | 149
 | Pope | 151
 | Pulaski | 153
 | Putnam | 155
 | Randolph | 157
 | Richland | 159
 | Rock Island | 161
 | St. Clair | 163
 | Saline | 165
 | Sangamon | 167
 | Schuyler | 169
 | Scott | 171
 | Shelby | 173
 | [NAME] | 175
 | [NAME] | 177
 | Tazewell | 179
 | Union | 181
 | Vermilion | 183
 | Wabash | 185
 | [NAME] | 187
 | Washington | 189
 | Wayne | 191
 | White | 193
 | Whiteside | 195
 | Will | 197
 | [NAME] | 199
 | Winnebago | 201
 | Woodford | 203
Spreadsheet: 124441d1318421242-delete-the-following-cell-delete
Sheet: Sheet1

One | Two | Three | Four
[NAME] | [NAME] | [NAME] | [NAME] |  |  |  |  | Names1 | Names2 | Names3 | Names4
 |  |  |  |  |  |  |  | [NAME] | Fred | [NAME] | [NAME]
 |  |  |  |  |  |  |  | [NAME] | [NAME] | [NAME] | [NAME]
 |  |  |  |  |  |  |  | [NAME] | [NAME] | [NAME] | Jodi
If I delete OR CHANGE the name in, say, cell C2 then D2 would become empty.
If I delete or change the name in cell [NAME], cells B2, C2 and D2 also become empty. So on.
Spreadsheet: 142080d1329634684-how-can-i-make-my-xls-sheet-shared-report
Sheet: Data

Box  No | Binders  name | Operator  Name | NO OF  PGS | Start Time  (24 hr Format) | Finish Time  (24 hr Format) | Total  Time | Time in  Minutes | Average | QC'ER | NO OF  PGS2 | COMMENTS | A4  Colour | A3  B&W | A3  Colour | A2  B&W | A2  Colour | A1  B&W | A1  Colour | A0  B&W | A0  Colour | Rebind | OCR | OCR QC | DATE EXPORTED
1 | Binder 1 | [NAME] | 50 | 11:00:00 | 12:00:00 | 01:00:00 | 60.00000000000003
1 | [NAME] | [NAME] | 30 | 12:30:00 | 13:00:00 | 00:30:00 | 29.99999999999989
1 | Binder 3 | [NAME] | 20 | 12:00:00 | 12:45:00 | 00:45:00 | 45
1 | [NAME] | [NAME] | 85 | 11:00:00 | 12:20:00 | 01:20:00 | 80.00000000000011
1 | Binder 5 | [NAME] | 80 | 10:00:00 | 13:00:00 | 03:00:00 | 179.9999999999999
1 | Binder 6 | [NAME] | 20 | 13:20:00 | 14:00:00 | 00:40:00 | 40.00000000000001
Spreadsheet: larry_campbell__20971__pg&esamp
Sheet: PG&E Page 3

CONFIDENTIAL
[NAME] and PG&E Samples and Analytical Results
Date | Sample ID |  | Volume Drained |  | Comments |  |  |  | PG&E PCB | TW PCB | Location of sample point
 |  |  |  |  |  |  |  |  |  |  | Filter Scrubbers Downstream of
1999-03-04 00:00:00 | SLX-TW | 3-4-99-L | o |  | No liquid for sample |  |  |  |  |  | Solexol Plant
 |  |  |  |  |  |  |  |  |  |  | TW's Filter Scrubber at TW/PG&E
1999-03-04 00:00:00 | PG&E-TW2 | 3-4-99-L | 6 oz |  |  |  |  |  | 93 PPM | 126 PPM | Metering Station
 |  |  |  |  |  |  |  |  |  |  | PG&E's Seperator at PG&E's
1999-03-04 00:00:00 | PG&E-Top3 | 3-4-99-L | 1/2 Gallon |  |  |  |  |  | 27 PPM | 36 PPM | Compressor Station
 |  |  |  |  |  |  |  |  |  |  | PG&E's Line A TCS
1999-03-04 00:00:00 | PG&E-A6 | 3-4-99-L |  |  | No sample taken per PG&E |  |  |  |  |  | Downstream Scrubber
 |  |  |  |  |  |  |  |  |  |  | PG&E's Line B TCS
1999-03-04 00:00:00 | PG&E-B6 | 3-4-99-L |  |  | No sample taken per PG&E |  |  |  |  |  | Downstream Scrubber
1999-03-04 00:00:00 | PG&E 10.84A | 3-4-99-L | 4 oz |  |  |  |  |  | 2 PPM | 2 PPM | PG&E's 34" Line A
1999-03-04 00:00:00 | PG&E 10.84B | 3-4-99-L | 4 oz |  |  |  |  |  | ND | ND | PG&E's 34" Line B
1999-03-04 00:00:00 | PG&E 8.58A | 3-4-99-L |  |  | No sample taken per PG&E |  |  |  |  |  | PG&E's 34" Line B
1999-03-04 00:00:00 | PG&E-TW4 | 3-4-99-L | 0 |  | No liquid for sample |  |  |  |  |  | TW 20" 1st Siphon
1999-03-04 00:00:00 | PG&E-TW5 | 3-4-99-L | 0 |  | No liquid for sample |  |  |  |  |  | TW 20" 2nd siphon
1999-03-04 00:00:00 | PG&E-TW6 | 3-4-99-L | 0 |  | No liquid for sample |  |  |  |  |  | TW 20" 3rd Siphon
 |  |  |  |  |  |  |  |  |  |  | Filter Scrubbers Downstream of
1999-03-11 00:00:00 | SLX-TW | 3-11-99-L | 0 |  | No liquid for sample |  |  |  |  |  | Solexol Plant
 |  |  |  |  |  |  |  |  |  |  | TW's Filter Scrubber at TW/PG&E
1999-03-11 00:00:00 | PG&E-TW2 | 3-11-99-L | 15 oz |  |  |  |  |  | 138 PPM | 158 PPM | Metering Station
 |  |  |  |  |  |  |  |  |  |  | PG&E's Seperator at PG&E's
1999-03-11 00:00:00 | PG&E-Top3 | 3-11-99-L | 15 oz |  |  |  |  |  | 93 PPM | 94 PPM | Compressor Station
 |  |  |  |  |  |  |  |  |  |  | PG&E's Line A TCS
1999-03-11 00:00:00 | PG&E-A6 | 3-11-99-L |  |  | No sample taken per PG&E |  |  |  |  |  | Downstream Scrubber
 |  |  |  |  |  |  |  |  |  |  | PG&E's Line B TCS
1999-03-11 00:00:00 | PG&E-B6 | 3-11-99-L |  |  | No sample taken per PG&E |  |  |  |  |  | Downstream Scrubber
1999-03-11 00:00:00 | PG&E 10.84A | 3-11-99-L | 3 oz |  |  |  |  |  | 2 PPM | 2 PPM | PG&Es 34" Line A
1999-03-11 00:00:00 | PG&E 10.84B | 3-11-99-L | 3 oz |  |  |  |  |  | <1 PPM | <1 PPM | PG&E's 34" Line B
1999-03-11 00:00:00 | PG&E 8.58A | 3-11-99-L |  |  | No sample taken per PG&E |  |  |  |  |  | PG&E's 34" Line B
1999-03-11 00:00:00 | PG&E-TW4 | 3-11-99-L | 0 |  | No liquid for sample |  |  |  |  |  | TW 20" 1st Siphon
1999-03-11 00:00:00 | PG&E-TW5 | 3-11-99-L | 0 |  | No liquid for sample |  |  |  |  |  | TW 20" 2nd siphon
1999-03-11 00:00:00 | PG&E-TW6 | 3-11-99-L | 0 |  | No liquid for sample |  |  |  |  |  | TW 20" 3rd Siphon
Spreadsheet: 73108d1273760067-comparing-two-sheets-on-one-spreadsheet-and-populating-with-figures-iserror-2-
Sheet: List

v | 23 | 24 | 25 | 26 | 27
c | 33 | 34 | 35 | 36 | 37
b | 43 | 44 | 45 | 46 | 47
m | 53 | 53 | 53 | 53 | 53
x | 63 | 64 | 65 | 66 | 67
w | 73 | 74 | 75 | 76 | 77
e | 83 | 84 | 85 | 86 | 87
r | 93 | 94 | 95 | 96 | 97
Spreadsheet: tracy_geaccone__40461__Book1
Sheet: Sheet1

Enron Trailblazer
Net Income Before Taxes
($000's)
 |  |  |  |  | 2002 |  | 2003
 |  | January |  |  | 933 |  | 2233
 |  | February |  |  | 926 |  | 2223
 |  | March |  |  | 933 |  | 2233
 |  | April |  |  | 931 |  | 2157
 |  | May |  |  | 919 |  | 2160
 |  | June |  |  | 2729 |  | 2157
 |  | July |  |  | 2732 |  | 2161
 |  | August |  |  | 2293 |  | 2161
 |  | September |  |  | 2289 |  | 2157
 |  | October |  |  | 2197 |  | 2160
 |  | November |  |  | 2266 |  | 2230
 |  | December |  |  | 2269 |  | 2233
 |  |  | Total
 |  |  | Enron's % |  | 0.31 |  | 0.31
 |  |  | Enron's Share
Notes: | In-service date of the expansion is June 1,2002
 | Trailblazer must file a rate case with the FERC to be effective 1/1/03.  A small rate decrease is anticipated
 |  | at this time with minimal impact on revenues for 2003
 | Enron's share of the Partnership Income Before Taxes is 31% and is based upon the last offer to CIG to settle
 |  | the on-going dispute regarding their level of equity participation.  Enron's percentage based upon
 |  | the FERC filing would be 31.9% and 29.9% based upon CIG's current position. |  |  |  |  |  |  | [NAME]This also is based
 |  | upon the file capital cost of $58 million with a 70/30 debt/equity structure.
 | The $6.6 million revenues for year 2002 represents an increase of $1.8 million over last year's plan
 |  | estimate of $4.8 million for year 2002.
Spreadsheet: 888352d1738840289-which-formula-would-be-best-to-use-formula-query-6-feb-v3
Sheet: Calculations

Sheffield
Opening hours
Monday | 420 | 2400
Tuesday | 420 | 2400
Wednesday | 420 | 2400
Thursday | 420 | 2400
Friday | 420 | 2400
Saturday | 420 | 2400
Sunday | 730 | 2400
Spreadsheet: 814431d1674389092-calculate-a-shift-from-day-and-time-sample
Sheet: Sheet1

Entered on | Material | Downtime | Time | Day | Shift
2023-01-16 00:00:00 | 87322 | 0.483 | 09:01:07 |  | DAYS
2023-01-17 00:00:00 | 87322 | 5.183 | 17:11:37 |  | BACKS
2023-01-18 00:00:00 | 87322 | 28.283 | 09:39:57 |  | DAYS
2023-01-19 00:00:00 | 87322 | 0 | 22:59:15 |  | BACKS
2023-01-20 00:00:00 | 87322 | 0 | 12:06:31 |  | DAYS
2023-01-21 00:00:00 | 87322 | 4.683 | 12:11:21 |  | WEEKEND DAYS
2023-01-22 00:00:00 | 87322 | 37.317 | 19:48:43 |  | [NAME] BACKS
2023-01-23 00:00:00 | 87322 | 0 | 14:08:13 |  | DAYS
2023-01-24 00:00:00 | 87322 | 27.017 | 23:24:51 |  | BACKS
Shifts
Monday - Friday | 06.30-15.30 | DAYS
Monday - Friday | 15.30-01.30 | BACKS
Saturday & Sunday | 05.30-17.30 | WEEKEND DAYS
Saturday & Sunday | 17.30-05.30 | WEEKENDS BACKS
Spreadsheet: fletcher_sturm__11008__fletch's new position manager
Sheet: Filter-old

 |  |  |  | CINERGY | Manitoba | ERCOT | INTO COMED | INTO TVA | MAPP | NEPOOL | INTO AEP | NY Zone A | [NAME] | SOCO | NSP | SPP | WESTERN HUB
[NAME] (PEAK)
2001
 |  |  | 2
MWs (PEAK)
HEAT RATES (PEAK) |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | FL-GA | FRCC
EQUIVALENT GAS CONTRACT (PEAK) |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | FL-GA | FRCC
[NAME] (offpeak)
2001
 |  |  | 2
MWs (offpeak)
Spreadsheet: daren_farmer__5712__HPLN0203
Sheet: Sheet1

HPLN0203.XLS |  | Fax # [PHONE]
TO:  DARREN FARMER / ENRON;  CARY METZ / ENRON;  [NAME] / HPL;  LIZ BELLAMY / ENRON
FROM:  MELISSA JONES - TXU ELECTRIC & GAS  (TU ELECTRIC)
SUBJECT:  TXU FUELS NOMINATION - February 03, 2001
 |  |  |  |  |  | **Sat/Sun | **Monday
HPL AND ENRON NOMINATIONS: |  |  |  |  |  | 2/3-4/2001 | 2001-02-05 00:00:00
 |  |  |  |  |  | Eff. 0900 hrs. | Eff. 0900 hrs.
 |  |  |  |  | PRIOR | NOMINATED | NOMINATED
CONTRACT |  | DELIVERY POINT |  | Upstream
 |  | Firm Summary
 |  | 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: 43b9bfc4-b940-4fdf-ac54-1d395471e9c2
Sheet: Sheet1

Permit No.: | Unnamed: 1 | WQ0007569 | Unnamed: 3 | Facility Name: | Unnamed: 5 | [NAME] | Unnamed: 7 | Unnamed: 8 | Unnamed: 9 | Unnamed: 10 | County: | [NAME] | Unnamed: 13 | Month: | Unnamed: 15 | Unnamed: 16 | Year: | Unnamed: 18
PPI: |  | 001 | Flow Measuring Point: |  |  |  |  |  |  | Parameter Monitoring Point:
Parameter Code |  |  | 50050
Day | ORC Arrival Time | ORC Time On Site | Flow
 | 24-hr | hrs | GPD
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
Average:
Daily Maximum:
Daily Minimum:
Sampling Type: |  |  | Recorder
Monthly Limit: |  |  | 150000
Daily Limit:
Sample Frequency: |  |  | [NAME]
 |  | Average
 |  | Geomean
 |  | MAX/MIN
Spreadsheet: 96712d1296037592-excel-2007-pivot-tables-combination-of-show-items-with-no-data-and-grouping-group-by-date-pivot_showitemswithnodate_vs_groupingdaterange
Sheet: STEP 1

Date | Summary |  |  |  | Count of Summary
2010-01-01 00:00:00 | Item 1 |  |  |  | Date | Total
2010-03-01 00:00:00 | Item 2 |  |  |  | 2010-01-01 00:00:00 | 1
2010-08-01 00:00:00 | Item 3 |  |  |  | 2010-03-01 00:00:00 | 1
2010-10-01 00:00:00 | Item 4 |  |  |  | 2010-08-01 00:00:00 | 1
2010-10-05 00:00:00 | Item 5 |  |  |  | 2010-10-01 00:00:00 | 1
2010-12-01 00:00:00 | Item 6 |  |  |  | 2010-10-05 00:00:00 | 1
2011-03-01 00:00:00 | Item 7 |  |  |  | 2010-12-01 00:00:00 | 1
2011-08-01 00:00:00 | Item 8 |  |  |  | 2011-03-01 00:00:00 | 1
 |  |  |  |  | 2011-08-01 00:00:00 | 1
 |  |  |  |  | Grand Total | 8
STEP 1 | Adding pivot based on data
Spreadsheet: 853119d1703063180-i-need-a-formula-to-display-the-specific-result-test-sheet
Sheet: Sheet1

 |  | Existing / New/ Open/ Follow up | [NAME] | Sampling done  (result required)
 |  | existing | Did sampling of | yes
 |  | existing | did demo of | yes
 |  | New | Did sampling of | yes
 |  | New | did demo of | yes
 |  | existing | line extension | yes
Sentences will be like this |  | existing | did demo of chipotle and mayonaise customer agreed and started business with us | yes
As it consists the word did demo of ( or did sampling of or met regarding line extension)  so I need the result to automatically write yes. What will be the formula? |  | existing | met regarding line extension of products customer agreed to work with us | yes
Spreadsheet: 48366d1247591233-cant-find-list-function-090213_sportsbetting_tipsterspro_forum_b
Sheet: Res. TFB

 | BETTING RESULTS - TFB |  |  |  | Graph >>> |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | return <<<
Key | Totals & Averages |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | BETTING RESULTS - ALL TIPSTERS (£'s)
 | Bet | Date | [NAME] | Sport | Event | Match |  | Pick | Odds | Unit (S) | Unit (A) | Stake $, E | Cur. Ex $ | Cur. Ex E | Stake £ | Bookie | Name | Result | Return | Return (U) | Profit | Profit (U) | Yield | Yield (U) | Bank | Bank (U) |  |  |  |  |  |  |  |  |  |  |  |  | Month | Bets | Odds (A) | Win | Loss | Void | Staked (£) | Stake (A) | Return (£) | Profit (£) | Bank (£) | Yield (%)
 | 0 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | >> |  |  |  |  |  |  |  |  |  |  | 2009-02-01 00:00:00
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 2009-03-01 00:00:00
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 2009-04-01 00:00:00
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 2009-05-01 00:00:00
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 2009-06-01 00:00:00
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 2009-07-01 00:00:00
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 2009-08-01 00:00:00
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 2009-09-01 00:00:00
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 2009-10-01 00:00:00
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 2009-11-01 00:00:00
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 2009-12-01 00:00:00
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 2010-01-01 00:00:00
Spreadsheet: 739950d1626099960-xirr-with-different-cutoff-dates-for-flows-and-valuation-and-non-contiguous-data-entries-xirr
Sheet: Sheet1

 |  |  | Investment 1 | Investment 2 | Investment 3
 | Valuation dates: |  | These are the desired XIRRS: |  |  |  | XIRR LOOKUP TABLE (I CALCULATED THE XIRRS MANUALLY TO ILLUSTRATE HOW TO GET THE RESULTS)
 | 2020-10-31 00:00:00 |  | 0.415705293416977 | 0.1549855172634125 | 0.1719762861728668 |  | 1
 | 2020-12-31 00:00:00 |  | 0.2977399289608003 | 0.09652213454246522 | 0.1060693323612213 |  | 2
 | 2020-09-30 00:00:00 |  | 0.3760811865329743 | 0.09418283402919768 | 0.1073243081569672 |  | 3
 | 2021-02-28 00:00:00 |  | 0.3159763276576996 | 0.14580824971199 | 0.2435581386089325 |  | 4
 | Valuation date: |  | 2021-02-28 00:00:00
 | This cutoff date essentially guides:
 | 1. The Cashflows. The last [NAME] has to match the Valuation date. This will capture a range of dates but the data [NAME] structure includes Cashflows beyond the desired XIRR calculation date.
 | 2. The Valuation date. Only one [NAME] should be included in the calculation. The data [NAME] structure includes several [NAME] for different periods. Only one [NAME] should be used.
 | The below formulas do not work because they capture only the Cashflows. I cannot find a way to incorporate the single needed Valuation Input entry for each Investment into the formulas.
 |  | XIRR
 |  | Cashflows
 |  | Date
 |  | Start ID
 |  | End ID
 |  | Valuation
 |  | Date
 |  | Start ID
 |  | End ID
 | Data Input Structure: new entries are constantly added under each investment column that include Cash In and Cash Out inputs and also the Valuations inputs for multiple periods
 |  |  | Investment 1 | Investment 2 | Investment 3
 | Date | Entry Type | Dollar Amt | Dollar Amt | Dollar Amt
1 | 2020-01-01 00:00:00 | Cash In | -100
 | 2020-01-08 00:00:00 | Cash In | -5
 | 2020-01-14 00:00:00 | Cash In | -5
 | 2020-01-22 00:00:00 | Cash In | -100
 | 2020-02-07 00:00:00 | Cash In |  | -300
 | 2020-02-14 00:00:00 | Cash In |  |  | -10
 | 2020-02-20 00:00:00 | Cash In |  |  | -75
 | 2020-02-28 00:00:00 | Cash In |  | -5
 | 2020-03-17 00:00:00 | Cash In | -50
 | 2020-03-24 00:00:00 | Cash Out | 20
 | 2020-03-30 00:00:00 | Cash Out |  | 70
 | 2020-04-07 00:00:00 | Cash Out |  |  | 5
 | 2020-04-23 00:00:00 | Cash Out |  |  | 5
 | 2021-01-05 00:00:00 | Cash Out |  | 10
 | 2021-01-06 00:00:00 | Cash Out | 10
 | 2021-02-07 00:00:00 | Cash Out |  |  | 10
 | 2020-10-31 00:00:00 | Valuation | 315.1875 | 262.65625 | 84.05
 | 2020-12-31 00:00:00 | Valuation | 307.5 | 256.25 | 82
 | 2020-09-30 00:00:00 | Valuation | 300 | 250 | 80
 | 2021-02-28 00:00:00 | Valuation | 315.34509375 | 262.787578125 | 84.09202499999999
 | XIRR CALCULATIONS WITH MANUAL TREATMENT OF DATA TO ACHIEVE REAL RESULTS:
 |  | XIRR |  |  |  |  |  | 1
 |  | XIRR |  |  |  |  |  | 2
 |  | XIRR |  |  |  |  |  | 3
 |  | XIRR |  |  |  |  |  | 4
 |  | XIRR |  |  |  |  |  |  | 1
 |  | XIRR |  |  |  |  |  |  | 2
 |  | XIRR |  |  |  |  |  |  | 3
 |  | XIRR |  |  |  |  |  |  | 4
 |  | XIRR |  |  |  |  |  |  |  | 1
 |  | XIRR |  |  |  |  |  |  |  | 2
 |  | XIRR |  |  |  |  |  |  |  | 3
 |  | XIRR |  |  |  |  |  |  |  | 4
Spreadsheet: 0b34cc75-b03a-4e19-a94e-2d2950c6ff31
Sheet: Sheet1

Battle ID | Date & Time | Side | Victory | Score | Opp. Score | Opp. ID | Opp. Name | Scenario ID | Front | Start Date | End Date | Name EN | Name FR
44379489 | 2014-12-10 02:23:10 | AXIS | 1 | 5 | 0 | 1214765 | S A Gundel | 6148 | western | 1944-07-25 | 1944-07-26 | Operation Cobra | Opération Cobra
44379612 | 2014-12-10 02:38:41 | ALLIES | 0 | 3 | 5 | 1214765 | S A Gundel | 6148 | western | 1944-07-25 | 1944-07-26 | Operation Cobra | Opération Cobra
44431043 | 2014-12-13 23:19:33 | AXIS | 1 | 6 | 1 | 1512168 | gregoryburbidge | 12505 | western | 1945-02-17 | 1945-02-20 | Moyland Wood | [NAME]
44431209 | 2014-12-13 23:29:52 | ALLIES | 1 | 6 | 3 | 1512168 | gregoryburbidge | 12505 | western | 1945-02-17 | 1945-02-20 | Moyland Wood | [NAME]
44431427 | 2014-12-14 00:15:17 | ALLIES | 1 | 10 | 7 | 799634 | lucky91 | 7662 | eastern | 1942-10-22 | 1942-10-22 | Red Barricades Factory | Les Barricades Rouges
44431977 | 2014-12-14 00:53:28 | AXIS | 1 | 10 | 7 | 799634 | lucky91 | 7662 | eastern | 1942-10-22 | 1942-10-22 | Red Barricades Factory | Les Barricades Rouges
44451749 | 2014-12-15 07:08:45 | AXIS | 0 | 6 | 7 | 521014 | [NAME] | 7661 | eastern | 1944-02-16 | 1944-02-17 | Breakout to Lisyanka | [NAME]
44451876 | 2014-12-15 07:23:28 | ALLIES | 0 | 5 | 7 | 521014 | [NAME] | 7661 | eastern | 1944-02-16 | 1944-02-17 | Breakout to Lisyanka | [NAME]
44480052 | 2014-12-17 07:40:48 | AXIS | 1 | 7 | 4 | 1330438 | Paynne | 7661 | eastern | 1944-02-16 | 1944-02-17 | Breakout to Lisyanka | [NAME]
44480149 | 2014-12-17 08:00:12 | ALLIES | 1 | 7 | 5 | 1330438 | Paynne | 7661 | eastern | 1944-02-16 | 1944-02-17 | Breakout to Lisyanka | [NAME]
Spreadsheet: 586975d1534775365-return-multiple-rows-values-for-two-search-criteria-using-index-match-function-register-sample-gk-
Sheet: Summary

 | Company | No. of PDC's Given | No. of Active PDC's | PDC Amount |  | Supplier | Contractor | Depositor | Employee | Bank
1
2 |  |  |  | a
3
4
5
6
7
PDC's DUE THIS WEEK
 | TODAY | THIS WEEK NUMBER
 |  |  | Active
 | Cheque Date | Cheque Number | Bank | Company | Cheque Given to | Cheque Amount | Cheque Given For:
Spreadsheet: 160982d1339351792-excel-2008-find-lower-price-from-multiple-sheets-book1-shokarta-oeldere2-
Sheet: Sumarry pivot table

id | price | shop
1 | 43 | sheet2 |  |  |  | Kolomlabels
2 | 12 | sheet2 |  |  |  | sheet2 |  | sheet3 |  | sheet4 |  | Eindtotaal Min van price | [NAME] van price
3 | 31 | sheet2 |  |  | Rijlabels | Min van price | [NAME] price | Min van price | [NAME] price | Min van price | [NAME] price
4 | 32 | sheet2 |  |  | 1 | 43 | 43 | 12 | 12 |  |  | 12 | 43
6 | 4 | sheet2 |  |  | 2 | 12 | 12 | 324 | 324 | 1 | 1 | 1 | 324
1 | 12 | sheet3 |  |  | 3 | 31 | 31 |  |  | 4 | 4 | 4 | 31
2 | 324 | sheet3 |  |  | 4 | 32 | 32 | 43 | 43 | 3 | 3 | 3 | 43
5 | 2 | sheet3 |  |  | 5 |  |  | 2 | 2 | 11 | 11 | 2 | 11
4 | 43 | sheet3 |  |  | 6 | 4 | 4 |  |  | 45 | 45 | 4 | 45
7 | 1 | sheet3 |  |  | 7 |  |  | 1 | 1 |  |  | 1 | 1
4 | 3 | sheet4 |  |  | Eindtotaal | 4 | 43 | 1 | 324 | 1 | 45 | 1 | 324
2 | 1 | sheet4
3 | 4 | sheet4
5 | 11 | sheet4
6 | 45 | sheet4
Spreadsheet: 120744d1315494824-projected-component-change-outs-budget
Sheet: 5205

5205 |  |  |  | Current Hours |  | Year
 |  |  |  |  |  | 2012 |  |  |  |  |  |  |  |  |  |  |  | 2013 |  |  |  |  |  |  |  |  |  |  |  | 2014 |  |  |  | 2015 |  |  |  | 2016
 |  |  |  |  |  | 744 | 696 | 744 | 720 | 744 | 720 | 744 | 744 | 720 | 744 | 720 | 744 | 744 | 672 | 744 | 720 | 744 | 720 | 744 | 744 | 720 | 744 | 720 | 744 | 2160 | 2184 | 2208 | 2208 | 2160 | 2184 | 2208 | 2208 | 2184 | 2184 | 2208 | 2208
 |  |  |  |  | Projected 2011 End | Jan | Feb | Mar | Apr | May | Jun | Jul | Aug | Sep | Oct | Nov | Dec | Jan | Feb | Mar | Apr | May | Jun | Jul | Aug | Sep | Oct | Nov | Dec | 1st | 2nd | 3rd | 4th | 1st | 2nd | 3rd | 4th | 1st | 2nd | 3rd | 4th
Projected Future Hours
Spreadsheet: 839208d1691751714-finding-value-with-2-criteria-attachment-tms
Sheet: Sheet1

 | Test 2 |  |  |  |  |  |  |  |  | 2023-08-21 00:00:00
DATE | 2023-08-22 00:00:00 | look to the column of this date |  |  |  | Test 1 | Test 2 | Test 3
Value | 2 | find this value in the selected date |  |  |  | AAA | Abcdef abcdef | NL |  | 4 | 4 | 4 | 4
 |  | show the name in column Test 2 |  |  |  | BBB | bcdefh bebe | BE |  | 1 |  | 1 | 1
 |  |  |  |  |  | CCC | cjcjccj cjcj | NL |  | 2 | 2 | 2 | 2
 |  |  |  |  |  | DDD | ddkk dkkd | D |  | 3 | 2 | 3
 |  |  |  |  |  | EEE | eeelk eek | NL |  | 5 | 5 | 5 | 5
FORMULA RESULT |  |  |  |  |  | FFF | fkjfjf jfkf | BE |  | 6 | 1 |  | 6
 |  |  |  |  |  | GGG | gkgj gjg | NL |  | 7 | 7 | 7 | 7
 |  |  |  |  |  | HHH | hmcc hhc | D |  | 8 | 8 | 8 | 8