tianzl66/Sheetpedia huggingface dataset:
Spreadsheet: 100568d1298911900-adding-up-totals-from-drop-down-list-slections-gym-banking
Sheet: Daily Banking Sunday

Gym Daily Banking
Sunday
Checked By
[NAME]
Date | Name | Payment Form | Class | Fee | Subs | GP | P/T | Pre P | Total
2011-01-01 00:00:00 | [NAME] | Card | Boxercise | 3.5 | 26 | 38 | 38 | 35 | 140.5
2011-01-01 00:00:00 | [NAME] | Card | Stretch & Tone | 3.5 | 37 | 28 | 29 | 28 | 125.5
2011-01-01 00:00:00 | [NAME] | Card | Circuits | 3.5 | 89 | 45 | 2 | 34 | 173.5
2011-01-01 00:00:00 | [NAME] | Cash | Circuits | 3.5 | 10 | 10 | 20 | 10 | 53.5
2011-01-01 00:00:00 | [NAME] | Cash | Pilates Non Member | 7 | 20 | 34 | 63 | 10 | 134
2011-01-01 00:00:00 | [NAME] | Cash | Boxercise | 3.5 | 56 | 35 | 56 | 45 | 195.5
2011-01-01 00:00:00 | [NAME] | Cheque | Pilates Member | 4 | 10 | 20 | 30 | 20 | 84
2011-01-01 00:00:00 | [NAME] | Cheque | Circuits | 3.5 | 21 | 37 | 53 | 26 | 140.5
 |  | x | x | 0 |  |  |  |  | 0
 |  | x | x | 0 |  |  |  |  | 0
 |  | x | x | 0 |  |  |  |  | 0
 |  | x | x | 0 |  |  |  |  | 0
 |  | x | x | 0 |  |  |  |  | 0
 |  | x | x | 0 |  |  |  |  | 0
 |  | x | x | 0 |  |  |  |  | 0
 |  | x | x | 0 |  |  |  |  | 0
 |  | x | x | 0 |  |  |  |  | 0
 |  | x | x | 0 |  |  |  |  | 0
 |  | x | x | 0 |  |  |  |  | 0
 |  | x | x | 0 |  |  |  |  | 0
 |  | x | x | 0 |  |  |  |  | 0
 |  | x | x | 0 |  |  |  |  | 0
 |  | x | x | 0 |  |  |  |  | 0
 |  | x | x | 0 |  |  |  |  | 0
 |  | x | x | 0 |  |  |  |  | 0
 |  | x | x | 0 |  |  |  |  | 0
 |  | x | x | 0 |  |  |  |  | 0
 |  | x | x | 0 |  |  |  |  | 0
 |  | x | x | 0 |  |  |  |  | 0
 |  |  | Totals | 32 | 269 | 247 | 291 | 208 | 1047
Spreadsheet: 167828d1342111802-create-different-formulas-based-off-of-yes-or-no-firstthoughtson
Sheet: Sheet1

Y | 2 |  | [NAME] FOR EACH YES VALUE>>> | 2 | 1 | 2 | JUST TEST NUMBERS
N | 30 |  |  | 6 | 2 | 3
N | 30 |  |  | 12 | 3 | 4
N | 30 |  |  | 20 | 4 | 5
Y | 30 |  |  | 30 | 5 | 6
N | 90 |  |  | 42 | 6 | 7
N | 90 |  |  | 56 | 7 | 8
N | 90 |  |  | 72 | 8 | 9
Y | 90 |  |  | 90 | 9 | 10
N | 156 |  |  | 110 | 10 | 11
N | 156 |  |  | 132 | 11 | 12
Y | 156 |  |  | 156 | 12 | 13
N | 272 |  |  | 182 | 13 | 14
N | 272 |  |  | 210 | 14 | 15
N | 272 |  |  | 240 | 15 | 16
Y | 272 |  |  | 272 | 16 | 17
Y | 306 |  |  | 306 | 17 | 18
N | 462 |  |  | 342 | 18 | 19
N | 462 |  |  | 380 | 19 | 20
N | 462 |  |  | 420 | 20 | 21
Y | 462 |  |  | 462 | 21 | 22
Y | 506 |  |  | 506 | 22 | 23
N | 992 |  |  | 552 | 23 | 24
N | 992 |  |  | 600 | 24 | 25
N | 992 |  |  | 650 | 25 | 26
N | 992 |  |  | 702 | 26 | 27
N | 992 |  |  | 756 | 27 | 28
N | 992 |  |  | 812 | 28 | 29
N | 992 |  |  | 870 | 29 | 30
N | 992 |  |  | 930 | 30 | 31
Y | 992 |  |  | 992 | 31 | 32
N | NO MATCH |  |  | 1056 | 32 | 33
N | NO MATCH |  |  | 1122 | 33 | 34
N | NO MATCH |  |  | 1190 | 34 | 35
N | NO MATCH |  |  | 1260 | 35 | 36
Y | NO MATCH | <<<<<EXTRA Y TO TERMINATE LIST |  | NO MATCH
Spreadsheet: 127571d1320413611-copy-3rd-row-in-date-range-example
Sheet: Sheet1

Date | Sales
2011-11-01 00:00:00 | 23
2011-11-01 00:00:00 | 12
2011-11-01 00:00:00 | 345
2011-11-01 00:00:00 | 23
2011-11-01 00:00:00 | 546
2011-11-01 00:00:00 | 23
2011-11-01 00:00:00 | 12
2011-11-01 00:00:00 | 345
2011-11-01 00:00:00 | 23
2011-11-01 00:00:00 | 546
2011-11-02 00:00:00 | 34
2011-11-02 00:00:00 | 546
2011-11-02 00:00:00 | 435
2011-11-02 00:00:00 | 34
2011-11-03 00:00:00 | 45
2011-11-03 00:00:00 | 435
2011-11-03 00:00:00 | 345
2011-11-03 00:00:00 | 546
2011-11-03 00:00:00 | 45
2011-11-03 00:00:00 | 435
2011-11-03 00:00:00 | 345
2011-11-03 00:00:00 | 546
2011-11-04 00:00:00 | 234
2011-11-04 00:00:00 | 786
2011-11-04 00:00:00 | 564
2011-11-04 00:00:00 | 435
2011-11-04 00:00:00 | 56
2011-11-04 00:00:00 | 455
2011-11-04 00:00:00 | 4123
2011-11-04 00:00:00 | 123
Spreadsheet: 215440d1361379204-vlookup-or-if-not-sure-book2
Sheet: Sheet1

Column A |  |  |  |  |  |  |  |  |  | Column K
100 |  |  |  |  |  |  |  |  |  |  | <- need Sheet 2 Column B here IF Sheet 1 - A2 is found in Sheet 2 A:A (anywhere in the column)
103
105
110
117
135
150
149.428571428571
157.5
165.571428571429
173.642857142857
181.714285714286
189.785714285714
197.857142857142
205.928571428571
214
222.071428571428
230.142857142857
238.214285714285
Spreadsheet: 36512d1234380670-calculating-a-discount-based-on-certain-rules-feemonthly
Sheet: Sheet1

Fee | 100
Today | 2009-02-11 00:00:00
 | 2009-01-01 00:00:00 | Paid | 2009-02-01 00:00:00 | Paid | 2009-03-01 00:00:00 | Paid | 2009-04-01 00:00:00 | Paid | 2009-05-01 00:00:00 | Paid | 2009-06-01 00:00:00 | Paid | 2009-07-01 00:00:00 | Paid | 2009-08-01 00:00:00 | Paid | 2009-09-01 00:00:00 | Paid | 2009-10-01 00:00:00 | Paid | 2009-11-01 00:00:00 | Paid | 2009-12-01 00:00:00 | Paid
[NAME] | 100 | 100 | 100
Spreadsheet: 271401d1381929903-excel-countif-with-drop-down-selection-form
Sheet: Sheet1

 | Date (October) | Start | End |  |  | Date to Report
 | 1 | 2 | 6 |  |  | 1
 | 2 | 7 | 11
 | 3 | 12 | 16
 | 4 | 17 | 21
 | 5 | 22 | 26
 | 6 | 27 | 31
 | 7 | 32 | 36
 | 8 | 37 | 41
 | 9 | 42 | 46
 | 10 | 47 | 51
 | 11
 | 12
 | 13
 | 14
 | 15
 | 16
 | 17
 | 18
 | 19
 | 20
 | 21
 | 22
 | 23
 | 24
 | 25
 | 26
 | 27
 | 28
 | 29
 | 30
 | 31
 | Reason for [NAME] (10/14) | Logged
 | Reason1
 | Reason2
 | Reason3
 | Reason4
 | Reason5
 | Total
Spreadsheet: 215346d1361354530-if-at-least-one-number-fails-the-rest-of-the-field-must-be-failed-book1
Sheet: Sheet1

 | SO number | SO/LI number | Revision
 | 789 | 10 | 1
 | 789 | 20 | 0
 | 789 | 30 | 0
 | 564 | 10 | 0
 | 564 | 20 | 0
 | 564 | 30 | 0
 | 564 | 40 | 0
 | 321 | 10 | 1
 | 321 | 20 | 0
 | 321 | 30 | 0
Expected outcome
no of passed items (unique so numbers) |  |  | 1
no of failed items(unique so numbers) |  |  | 2
Total no of unique items |  |  | 3
Spreadsheet: 168734d1342552700-copy-across-multiple-rows-and-columns-the-data-to-one-column-removing-dupilicates-blank-15640
Sheet: Mar24-Mar30m

Main Arena
 | 2013-03-24 00:00:00 |  |  | Thru | 2013-03-30 00:00:00
 | SUN | MON | TUE | WED | THURS | FRI | SAT
 | 2013-03-24 00:00:00 | 2013-03-25 00:00:00 | 2013-03-26 00:00:00 | 2013-03-27 00:00:00 | 2013-03-28 00:00:00 | 2013-03-29 00:00:00 | 2013-03-30 00:00:00 |  |  |  | Blocks | Team | Hours
7:00AM |  |  |  |  |  |  |  | 7:00AM |  |  | 0 | 05 [NAME] | 0
 |  |  |  |  |  |  |  |  |  |  | 0 | 04 Flags | 0
[NAME] |  |  |  |  |  |  |  | [NAME] |  |  | 0 | 03 [NAME] | 0
 |  |  |  |  |  |  |  |  |  |  | 0 | 02 Flags | 0
[NAME] |  |  |  |  |  |  |  | [NAME] |  |  | 0 | 01 Flags | 0
 |  |  |  |  |  |  |  |  |  |  | 0 | 00 Flags | 0
10:00AM |  |  |  |  |  |  |  | 10:00AM |  |  | 0 | 99 Flags | 0
 |  |  |  |  |  |  |  |  |  |  | 0 | 98 Flags | 0
11:00AM |  |  |  |  |  |  |  | 11:00AM |  |  | 0 | Midget A | 0
 |  |  |  |  |  |  |  |  |  |  | 0 | Midget AA | 0
12:00PM |  |  |  |  |  |  |  | 12:00PM
1:00PM |  |  |  |  |  |  |  | 1:00PM
2:00PM |  |  |  |  |  |  |  | 2:00PM
3:00PM |  |  |  |  |  |  |  | 3:00PM
4:00PM |  |  |  |  |  |  |  | 4:00PM
5:00PM |  |  |  |  |  |  |  | 5:00PM
6:00PM |  |  |  |  |  |  |  | 6:00PM
7:00PM |  |  |  |  |  |  |  | 7:00PM
8:00PM |  |  |  |  |  |  |  | 8:00PM
9:00PM |  |  |  |  |  |  |  | 9:00PM
10:00PM |  |  |  |  |  |  |  | 10:00PM
11:00PM |  |  |  |  |  |  |  | 11:00PM
 | Cancellations or Corrections
 | Date | Time | Customer | Operations Personal | Comments
Spreadsheet: 757530d1638312363-index-and-match-with-2-dropdown-list-index-and-match-2-dropdowns
Sheet: Sheet1

 | Impact | Risk Score Matrix
 | Extreme | Lower Medium | Higher Medium | High | Extreme | Extreme
 | High | Low | Lower Medium | Higher Medium | High | Extreme
 | Moderate | Low | Lower Medium | Higher Medium | High | High
 | Low | Low | Lower Medium | Lower Medium | Higher Medium | High
 | Negligible | Low | Low | Lower Medium | Higher Medium | Higher Medium
 |  | Remote | Unlikely | Possible | Likely | Certain
 |  | Likelihood
 |  |  |  |  | Likelihood | Impact
 | Likelihood | Impact | Risk Score |  | Certain | Extreme
 |  |  | ?? |  | Likely | High
 |  |  |  |  | Possible | Moderate
 |  |  |  |  | Unlikely | Low
 |  |  |  |  | Remote | Negligible
Spreadsheet: 1344ffbd-b0c0-43ac-a032-6f2bacb9fe23
Sheet: Sheet1

Table 1--Wheat: U.S. market year supply and disappearance, 10/15/2012 | Unnamed: 1 | Unnamed: 2 | Unnamed: 3 | Unnamed: 4 | Unnamed: 5 | Unnamed: 6 | Unnamed: 7 | Unnamed: 8 | Unnamed: 9
Item and unit |  |  | 2006/07 | 2007/08 | 2008/09 | 2009/10 | 2010/11 | 2011/12 | 2012/13
 | Area: Planted | Million acres | 57.334 | 60.46 | 63.193 | 59.168 | 53.593 | 54.409 | 55.736
 | Harvested | Million acres | 46.8 | 50.999 | 55.699 | 49.893 | 47.619 | 45.705 | 48.991
 | Yield | Bushels per acre | 38.6 | 40.2 | 44.9 | 44.5 | 46.3 | 43.7 | 46.3
 | Supply: Beginning stocks | Million bushels | 571.19 | 456.153 | 305.818 | 656.505 | 975.637 | 862.246 | 742.62
 | Production | Million bushels | 1808.416 | 2051.088 | 2499.164 | 2218.061 | 2206.916 | 1999.347 | 2269.117
 | Imports 1/ | Million bushels | 121.862 | 112.631 | 126.971 | 118.59 | 96.92 | 112.064 | 130
 | Total supply | Million bushels | 2501.468 | 2619.872 | 2931.953 | 2993.156 | 3279.473 | 2973.657 | 3141.737
 | Disappearance: Food use | Million bushels | 937.911 | 947.865 | 926.769 | 918.92 | 925.641 | 941.387 | 950
 | Seed use | Million bushels | 81.869 | 87.615 | 78.045 | 69.471 | 70.889 | 76.271 | 73
 | Feed and residual use | Million bushels | 117.059 | 15.962 | 255.219 | 149.85 | 131.864 | 163.866 | 315
 | Total domestic use | Million bushels | 1136.839 | 1051.442 | 1260.033 | 1138.241 | 1128.394 | 1181.524 | 1338
 | Exports 1/ | Million bushels | 908.476 | 1262.612 | 1015.415 | 879.278 | 1288.833 | 1049.513 | 1150
 | Total disapperance | Million bushels | 2045.315 | 2314.054 | 2275.448 | 2017.519 | 2417.227 | 2231.037 | 2488
 | Ending stocks | Million bushels | 456.153 | 305.818 | 656.505 | 975.637 | 862.246 | 742.62 | 653.737
 | CCC inventory 2/ | Million bushels | 41
 | Stocks-to-use ratio |  | 22.3023 | 13.2157 | 28.8517 | 48.3583 | 35.6709 | 33.2859 | 26.2756
 | Loan rate | Dollars per bushel | 2.75 | 2.75 | 2.75 | 2.75 | 2.94 | 2.94 | 2.94
 | Contract/direct payment rate | Dollars per bushel | 0.52 | 0.52 | 0.52 | 0.52 | 0.52 | 0.52 | 0.52
 | Farm price 3/ | Dollars per bushel | 4.26 | 6.48 | 6.78 | 4.87 | 5.7 | 7.24 | 7.65-8.55
 | Government payments | Million dollars | 1120 | 1118
 | Market value of production | Million dollars | 7694.734 | 13289.326 | 16625.759 | 10654.115 | 12827.254 | 14475.2723 | 18379.8477
Latest market year is projected; previous market year is estimated. Totals may not add due to rounding. 1/ Includes flour and selected other products expressed in grain-equivalent bushels. 2/ Stocks owned by USDA's Commodity Credit Corporation (CCC). Most CCC-owned inventory is in the Bill Emerson Humanitarian Trust.
3/ U.S. season-average price based on monthly prices weighted by monthly marketings. Prices do not include an allowance for loans outstanding and government purchases. Source: USDA, World Agricultural Outlook Board, World Agricultural Supply and Demand Estimates and supporting materials.
Date run: 10/15/2012
Spreadsheet: 713800d1610948080-sumproduct-with-2-criteria-first-last-cell-in-a-row-and-return-another-cell-testlog
Sheet: Log

[NAME] | Reported | Executed | Adress | Bereich | TU | TP | TA | TR | QB | QU | PF | KE | HE | HUP | KAK | Total
GFI | 14.01.2021 | 2021-01-01 00:00:00 | acasa | VRS-007 | 1 | 3 | 4 | 2 | 5 | 6 | 7
GFI | 15.01.2021 | 2021-01-01 00:00:00 | ultima | VRS-008 | 1 | 3 | 4 | 2 | 5 | 6 | 7
GFI | 15.01.2021 | 2021-01-01 00:00:00 | test | VRS-009 | 10 | 10 | 10 | 10 | 10 | 10 | 10
GFI | 16.01.2021 | 2021-01-01 00:00:00 | sambata | VRS-010 | 2 | 2 | 2 | 2 | 2 | 2 | 2
GFI | 16.01.2021 | 2021-01-01 00:00:00 | SAMBATA 2 | [NAME] | 3 | 3 | 3 | 3 | 3 | 3 | 3
GFI | 16.01.2021 | 2021-01-01 00:00:00 | SAmbata 3 | VRS-012 | 1 | 1 | 1 | 1 | 1 | 1 | 1
HAS | 16.01.2021 | 2021-01-06 00:00:00 | has | VRS-013 | 1 | 1 | 1 | 1 |  |  |  |  | 1
GFI | 17.01.2021 | 2021-01-06 00:00:00 | test 1 | VRS-014 | 12 | 34 | 45 | 23 | 56 | 67 | 78
GFI | 17.01.2021 | 2021-01-06 00:00:00 | asdwf | VRS-015 | 23
GFI | 17.01.2021 | 2021-01-06 00:00:00 | test 5 | VRS-016 | 5 | 5 | 5 | 5 | 5 | 5 | 5
GFI | 17.01.2021 | 2021-01-07 00:00:00 | test 5 | VRS-017 | 5 | 5 | 5 | 5 |  |  |  | 5
GFI | 17.01.2021 | 2021-01-07 00:00:00 | ultima | VRS-018 | 2 | 2 |  | 2 | 2 | 2
GFI | 17.01.2021 | 2021-01-07 00:00:00 | qweqwr | VRS-019 | 12 | 12 |  | 12
GFI | 17.01.2021 | 2021-01-07 00:00:00 | 12 | VRS-020 | 23 |  |  | 23
GFI | 17.01.2021 | 2021-01-08 00:00:00 | has | VRS-021 | 12 |  |  | 23
HAS | 17.01.2021 | 2021-01-08 00:00:00 | has | VRS-022 | 12 |  |  | 13
GFI | 17.01.2021 | 2021-01-08 00:00:00 | final test | VRS-023 | 10 | 10 |  |  | 10 | 10 | 10
HAS | 17.01.2021 | 2021-01-08 00:00:00 | final test | VRS-024 | 12 | 12 |  |  |  |  |  | 12
GFI | 17.01.2021 | 2021-01-04 00:00:00 | final | VRS-025 |  | 1 |  | 1
HAS | 17.01.2021 | 2021-01-04 00:00:00 | final | VRS-026 | 12 | 23
GFI | 17.01.2021 | 2021-01-04 00:00:00 | [NAME] | VRS-025 | 23 | 32 |  |  | 32
GFI | 17.01.2021 | 2021-01-04 00:00:00 | duminica | VRS-026 | 1 | 1 | 1 | 1 | 1 | 1 | 1
HAS | 17.01.2021 | 2021-01-04 00:00:00 | duminica | VRS-025 | 1 | 1 | 1 | 1 |  |  |  | 1
HAS | 17.01.2021 | 2021-01-04 00:00:00 | duminica | VRS-026 | 2 | 2 | 2 | 2 |  |  |  | 2
GFI | 17.01.2021 | 2021-01-05 00:00:00 | duminica | VRS-007 | 10 | 10 | 10 | 10 | 10 | 10 | 10
HAS | 17.01.2021 | 2021-01-05 00:00:00 |  | VRS-008 | 23 |  |  | 23
GFI | 17.01.2021 | 2021-01-05 00:00:00 |  | VRS-024 | 12 |  |  | 23
HAS | 17.01.2021 | 2021-01-05 00:00:00 |  | VRS-025 | 12 |  |  | 13
GFI | 17.01.2021 | 2021-01-05 00:00:00 |  | VRS-019 | 10 | 10 |  |  | 10 | 10 | 10
GFI | 17.01.2021 | 15.01.2021 | sad |  | 10 | 10 | 10 | 10 | 10 | 10 | 10
GFI | 17.01.2021 | GFI - | asd |  | 2 | 2 | 2 | 2 | 2 | 29 m | 2
HAS | 17.01.2021 | 15.01.2021 | seara |  | 5 | 5 | 5 | 5 |  |  |  | 5
GFI | 17.01.2021 |  | asd |  | 1 | 3 | 4 | 2 | 4 | 7 | 8
GFI | 17.01.2021 | 15.01.2021 | iar |  | 12 | 12 | 12 | 12 | 12 | 12 | 12
GFI | 17.01.2021 | 15.01.2021 | final |  | 12
HAS | 17.01.2021 | 15.01.2021 | final |  | 23 |  |  | 28
GFI | 17.01.2021 | 15.01.2021 | final |  | 3 | 3 | 3 | 3 | 3 | 3 | 3
HAS | 17.01.2021 | 15.01.2021 | final |  | 3 | 3 | 3 | 3 |  |  |  | 3
Spreadsheet: 357e06ec-f935-446b-aee0-9b5d71af9834
Sheet: Sheet1

Test Referenced | Entry Type | Mayo ID | Description | Reporting Description | Method | Collection Container | Temperature | Stability | [NAME] | Unit of Measure | [NAME] | Minimum Volume | Reject Due To | Reference Values | Days/Times Performed | Analytic Time | Maximum Lab Time | CPT Units | CPT Code | LOINC® Code | LOINC® Attributes | Always Performed | Orderable Separately | Performing Location
HSMR | Test | HSMR | Herpes Simplex Virus (HSV) Antibody, IgM, by Immunofluorescence Assay (IFA), Serum | HSV Ab, IgM, S by IFA | Immunofluorescence Assay (IFA) |  |  |  | 1 | mL | Container/Tube:  Preferred: Red top Acceptable: Serum gel [NAME]: 1 mL | 0.2 mL | Specimens Other Than:		 Anticoagulants Other Than:	 Hemolysis:	 Thawing: Lipemia: | Negative |  | Same day/1 day | 3 days | 1 | 86694 |  |  |  |  | Rochester
HSMR | [NAME] | SERUM | Serum |  |  |  | Refrigerated | 14 days
HSMR | Result | 26589 | HSV Ab, IgM, S by IFA | HSV Ab, IgM, S by IFA | Alphanumeric |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 44507-2
Spreadsheet: phillip_m_love__30643__HS FT Ont Central
Sheet: Diff

 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | .
TIME BUCKET/KEY: |  |  | REPORT REGION | RISK TYPE | 1 |  | 2 |  | 3 |  | 4 |  | 5 |  | 6 |  | 7 |  | 8 |  | 9 |  | 10 |  | 11 |  | 12 |  | 13 |  | 14
(Positions in Cont. [NAME].)     From: | Post ID |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | Total ECT
To: | Order
FT - WEST
Gas Daily | 1 |  | NGPRICE | P
Index
Basis - Notional | 3 |  | NGLTX | P
Basis - Equivalent | 4 |  | NGFPL | P
Price | 5 |  | NGFPL | D
TOTAL:
Basis Roll-off
Spreadsheet: 836383d1689320260-count-number-of-rows-where-any-date-between-start-and-finish-are-between-2-dates-example
Sheet: Sheet1

Start | Finish |  | 2023-05-15 00:00:00
 |  | Count: | 3 | 3 | 3 | 4 | 4 | 6 | 6 | 6 | 8 | 17
2023-05-16 00:00:00 | 2023-06-19 00:00:00
2023-05-17 00:00:00 | 2023-06-23 00:00:00
2023-05-19 00:00:00 | 2023-07-03 00:00:00
2023-06-06 00:00:00 | 2023-07-27 00:00:00
2023-06-19 00:00:00 | 2023-08-02 00:00:00
2023-06-20 00:00:00 | 2023-07-28 00:00:00
2023-06-26 00:00:00 | 2023-08-03 00:00:00
2023-06-27 00:00:00 | 2023-07-31 00:00:00
2023-07-10 00:00:00 | 2023-08-04 00:00:00
2023-07-10 00:00:00 | 2023-08-11 00:00:00
2023-07-10 00:00:00 | 2023-08-11 00:00:00
2023-07-12 00:00:00 | 2023-08-08 00:00:00
2023-07-13 00:00:00 | 2023-08-09 00:00:00
2023-07-13 00:00:00 | 2023-08-09 00:00:00
2023-07-13 00:00:00 | 2023-08-09 00:00:00
2023-07-13 00:00:00 | 2023-08-09 00:00:00
2023-07-17 00:00:00 | 2023-08-11 00:00:00
2023-07-18 00:00:00 | 2023-08-21 00:00:00
2023-07-19 00:00:00 | 2023-08-15 00:00:00
2023-07-21 00:00:00 | 2023-08-17 00:00:00
2023-07-25 00:00:00 | 2023-08-21 00:00:00
2023-07-25 00:00:00 | 2023-08-21 00:00:00
2023-08-08 00:00:00 | 2023-09-04 00:00:00
2023-08-17 00:00:00 | 2023-09-20 00:00:00
2023-08-21 00:00:00 | 2023-09-01 00:00:00
2023-08-21 00:00:00 | 2023-09-15 00:00:00
2023-08-21 00:00:00 | 2023-09-22 00:00:00
2023-08-21 00:00:00 | 2023-09-22 00:00:00
2023-08-23 00:00:00 | 2023-09-19 00:00:00
2023-08-23 00:00:00 | 2023-09-19 00:00:00
2023-08-23 00:00:00 | 2023-09-19 00:00:00
2023-08-25 00:00:00 | 2023-09-21 00:00:00
2023-08-30 00:00:00 | 2023-09-27 00:00:00
2023-08-30 00:00:00 | 2023-09-27 00:00:00
2023-08-30 00:00:00 | 2023-09-27 00:00:00
2023-08-30 00:00:00 | 2023-09-27 00:00:00
2023-09-06 00:00:00 | 2023-10-04 00:00:00
Spreadsheet: 167655d1342049828-counting-rows-between-specified-descriptors-namedrangeoffsetbyone
Sheet: Sheet1

list |  | 4
Yes
Yes
Yes |  | 2 named ranges
Yes |  | [NAME] | = | a2:index(a:a,counta(a:a))
Yes |  | myrange2 | = | a3:index(a:A,counta(a:a)+1)
Yes
Yes
Yes
Yes
Yes
Yes
NA
NA
NA
NA
NA
NA
NA
NA
NA
NA
Yes
NA
NA
NA
yes
NA
YES
Spreadsheet: 886121d1736155687-subtraction-first-from-one-cell-then-from-another-substraction-from-first-cell
Sheet: Sheet1

 | 5 | 20 |  | D |  | D | D | D |  | D |  |  |  | D | D |  |  |  | D
 | After substraction formula should be:
 | 0 | 18 |  | D |  | D | D | D |  | D |  |  |  | D | D |  |  |  | D
Spreadsheet: 164384d1340741867-search-display-multiple-instances-of-unique-clients-and-related-cells-help-please-test-copy-timesheet
Sheet: Inputs

 | Client | Matter | Activity | Description | Participants | Hours
 | Chubb Insurance Group | A&E Reserves | Discussion Re: | Marketform Claims Review | [NAME] | 0.25
 | Great American Insurance Group | AFG | [NAME] re: | Port of Seattle | [NAME] | 0.5
 | Travellers Insurance Group | APU | Meeting Re: |  | [NAME] | 0.75
 |  | Claims |  |  | S. Cole | 1
 |  | CLJ |  |  | [NAME] | 1.25
 |  | Marketform |  |  |  | 1.5
 |  |  |  |  |  | 1.75
 |  |  |  |  |  | 2
 |  |  |  |  |  | 2.25
 |  |  |  |  |  | 2.5
 |  |  |  |  |  | 2.75
 |  |  |  |  |  | 3
 |  |  |  |  |  | 3.25
 |  |  |  |  |  | 3.5
 |  |  |  |  |  | 3.75
 |  |  |  |  |  | 4
 |  |  |  |  |  | 4.25
 |  |  |  |  |  | 4.5
 |  |  |  |  |  | 4.75
 |  |  |  |  |  | 5
 |  |  |  |  |  | 5.25
 |  |  |  |  |  | 5.5
 |  |  |  |  |  | 5.75
 |  |  |  |  |  | 6
 |  |  |  |  |  | 6.25
 |  |  |  |  |  | 6.5
 |  |  |  |  |  | 6.75
 |  |  |  |  |  | 7
 |  |  |  |  |  | 7.25
 |  |  |  |  |  | 7.5
 |  |  |  |  |  | 7.75
 |  |  |  |  |  | 8
Spreadsheet: 58a6191c-2a63-4d9c-992a-25f416e8725a
Sheet: 2011 H1 Sector Net Rev

GAAP to Non-GAAP Reconciliation
Net Revenues to Organic Net Revenues by Consumer Sector
For the Six Months Ended June 30,
($ in millions, except percentages) ([NAME])
Kraft Foods
 |  |  |  |  |  |  |  |  |  |  |  |  |  | % Change
 | As Reported (GAAP) |  | Impact of [NAME] |  | Impact of Acquisitions (2) |  | Impact of Accounting Calendar Changes |  | Impact of Currency |  | Organic  (Non-GAAP) |  |  | As Reported (GAAP) |  | Organic  (Non-GAAP)
2011
Biscuits | 5776 |  | 0 |  | 0 |  | -99 |  | -128 |  | 5549 |  |  | 0.1 |  | 0.069
Confectionery
Chocolate | 4513 |  | 0 |  | -285 |  | -43 |  | -259 |  | 3926 |  |  | 0.262 |  | 0.094
Gum & Candy | 2710 |  | 0 |  | -379 |  | 15 |  | -131 |  | 2215 |  |  | 0.243 |  | 0.016
Other Confectionery | 178 |  | 0 |  | -5 |  | -3 |  | -6 |  | 164 |  |  | -0.371 |  | -0.146
 | 7401 |  | 0 |  | -669 |  | -31 |  | -396 |  | 6305 |  |  | 0.225 |  | 0.058
Snacks (1) | 13177 |  | 0 |  | -669 |  | -130 |  | -524 |  | 11854 |  |  | 0.167 |  | 0.063
2010
Biscuits | 5252 |  | 0 |  | 0 |  | -59 |  | 0 |  | 5193
Confectionery
Chocolate | 3577 |  | 11 |  | 0 |  | 0 |  | 0 |  | 3588
Gum & Candy | 2180 |  | 0 |  | 0 |  | 0 |  | 0 |  | 2180
Other Confectionery | 283 |  | -91 |  | 0 |  | 0 |  | 0 |  | 192
 | 6040 |  | -80 |  | 0 |  | 0 |  | 0 |  | 5960
Snacks (1) | 11292 |  | -80 |  | 0 |  | -59 |  | 0 |  | 11153
(1)  Snacks is defined as the combination of the Biscuits sector, which includes cookies, crackers and salted snacks, and the Confectionery sector,
which includes chocolate, gum & candy and other confectionery.
(2)  Impact of acquisitions reflects the incremental January 2011 operating results from our Cadbury acquisition.
Spreadsheet: phillip_m_love__30743__OntarioEnronCanadaPMADetail
Sheet: SALES

Ontario Region
Enron Canada Sale
August 2000
CPR |  |  |  | Sitara |  |  |  | Tagg |  |  |  | [NAME]
Number | Volume | Amount |  | Number | Volume | Amount |  | Number | Volume | Amount |  | Volume | Amount | 3.9
405939 | 46996 | 182814.44 |  | 89095 | 46996 | 193044.06 |  | EX7446.2 |  | -10231.03
429616 | 443548 | 1725401.72 |  | 66332 | 443548 | 1766061.77 |  | EU2740.1 |  | -40690.45
442162 | 3645 | 20000.13 |  | 117248 | 3643 | 16375.44 |  | N22188.1 |  | 14229.62
450412 | 58776 | 228638.64 |  | 89094 | 58776 | 241432.41 |  | EX7446.1 |  | -12795.55
450413 | 149854 | 582932.06 |  | 114946 | 149823 | 595546.43 |  | EY9876.A |  | -12737.61
450469 | 408425 | 1588773.25 |  | 114954 | 408425 | 1623489.38 |  | EY9876.B |  | -34716.17
484798 | 1102174 | 4320522.08 |  | 145823 | 1102174 | 0 |  | N63076.7 |  | 4320521.75
484821 | 284859 | 1108386.37 |  | 145835 | 275670 | 0 |  | N63076.A |  | 1108386.28
561918 | 13634 | 42444.76 |  | 228586 | 13639 | 42507.7
635126 | 155000 | 612250 |  | 290652
664772 | 5704 | 22188.56 |  | 316781 | 5704 | 0
702072 | 1302 | 5142.89 |  | 348765 | 1302 | 5142.9
702074 | 15841 | 62571.95 |  | 348766 | 15841 | 62571.95
711909 | 47411 | 221409.37 |  | 365580 | 47391 | 233500
712161 | 29 | 126.88 |  | 356399 | 29 | 126.88
727981 | 31 | 139.5 |  | 370747 | 31 | 139.5
733438 | 1377 | 4650.82 |  | 375557 | 1376 | 4647.44
Totals |  |  |  |  |  |  | `
Additional  Liquidations |  |  |  |  |  |  |  | N22188.2 |  | -11130.67
Total Variance Including Lone Liquidations
Spreadsheet: 548584d1511214791-looking-for-a-way-to-adjust-match-formula-to-check-for-every-possible-match-and-not-stop-assistance-with-formula
Sheet: Read Status

Agent Name | I love [NAME] | Dogs Rule | *Doritos Are Fantastic* | The Color Red
[NAME]
Betty
Alicia
[NAME]
Christy
[NAME]
[NAME]
Spreadsheet: 715887d1611907639-unique-distinct-dependent-lists1-three-columns-test_unique-gk
Sheet: Sheet1

order # id | Product | Continent |  | Drop down list unique orders #
1010 | Graphics card | Europe |  | 1030
1010 | Soundcard | Asia
1010 | Motherboard | Us |  | Drop down list unique products
1010 | Soundcard | Europe |  | Harddisk
1020 | Graphics card | Asia
1020 | Keyboard | Us |  | Drop down list unique continents
1020 | Motherboard | Europe |  | Asia |  |  | Remark : If E8 = *, want to lookup to Sheet3 and show dropdown in E8 the list of 3 continents ie. Europe, Asia , US
1020 | Graphics card | Us
1020 | Keyboard | Us
1030 | Harddisk | *