tianzl66/Sheetpedia huggingface dataset:
Spreadsheet: 868628d1715315771-generate-spill-array-to-determine-the-performance-of-a-department-grades
Sheet: Sheet1

 | Excellent | Good | Better | Fair | Poor | % |  |  |  | Criteria
Department-1 |  |  |  |  |  | 0 |  |  |  | Min | [NAME]
Department-2 |  |  |  | ü |  | 0.54 |  |  |  | 0 | 0.01
Department-3 | ü |  |  |  |  | 0.89 |  |  | Poor | 0.01 | 0.4
[NAME] | ü |  |  |  |  | 0.9 |  |  | Fair | 0.4 | 0.6
Department-5 |  |  |  | ü |  | 0.49 |  |  | Better | 0.6 | 0.7
Department-6 |  | ü |  |  |  | 0.7 |  |  | Good | 0.7 | 0.85
Department-7 | ü |  |  |  |  | 0.85 |  |  | Excellent | 0.85 | 1
Department-8 |  |  |  |  | ü | 0.36
Spreadsheet: 755643d1637003899-offset-function-for-another-sheet-reference-point-error-allocation3-copy
Sheet: Allocation Final

Allocation
Click Consulting
Purpose | To allocate the amount of each item based on a daily amount and the number of dates in each column.
Allocation
 | Amount | Alloc Start | Alloc End |  | Days | DailyAmt |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | Total | Diff
 | 1000 | 2014-01-01 00:00:00 | 2014-03-31 00:00:00
 | 600 | 2014-01-01 00:00:00 | 2014-06-30 00:00:00
 | 900 | 2014-01-01 00:00:00 | 2014-12-31 00:00:00
 | -750 | 2014-01-01 00:00:00 | 2014-03-31 00:00:00
 | 800 | 2014-01-15 00:00:00 | 2014-04-15 00:00:00
 | 650 | 2012-01-01 00:00:00 | 2012-03-31 00:00:00
 | 850 | 2016-01-01 00:00:00 | 2016-03-31 00:00:00
Spreadsheet: joe_parks__14714__POSTION05_02
Sheet: M-V_SWAP

 | SELL |  |  |  | BUY
BEGINNING |  |  |  |  | 38.2 | 3.71 |  |  |  |  | MTM
 |  |  |  |  |  |  |  |  |  |  | ROLLOFF VAULE
 |  |  |  |  |  |  |  |  |  |  | NEW DEALS
 |  |  |  |  |  |  |  |  |  |  | TOTAL  P&L
 |  |  |  |  |  |  |  |  |  |  | POSTION
 |  |  |  |  |  |  |  |  |  |  | ROLL OFF
 |  |  |  |  |  |  |  |  |  |  | NET POSTION
 |  |  |  |  |  |  |  |  |  |  |  | 153
 |  |  |  |  |  |  |  |  |  |  | 0.25
 |  |  |  |  |  |  |  |  |  |  | 0.5
 |  |  | <- Current MTM
 |  |  |  |  |  |  | <- Realized PL
 |  |  |  |  |  |  | <- MTM PL w/o Real PL
 |  |  |  |  |  |  | <- MTM PL with Real PL
 |  |  |  |  |  |  | <- Total Pl
Spreadsheet: 722453d1615278138-count-how-many-times-a-row-has-a-high-score-count-how-many-times-a-row-has-a-high-score-ans
Sheet: Scores (3)

 | Pl note the changes header in Columns B & C
 | High Score Count |  | Saturday | Tuesday | Saturday | Tuesday | Saturday | Tuesday | Saturday | Tuesday
Team | Tuesday | Saturday | Week 1 | Week 2 | Week 3 | Week 4 | Week 5 | Week 6 | Week 7 | Week 8
Team 1 |  |  | 87053 | 235164 | 419681 | 229298 | 336665 | 124490 | 276520 | 213741
Team 2 |  |  | 98756 | 313755 | 310982 | 461552 | 409059 | 232472 | 358539 | 298877
Team 3 |  |  | 98154 | 171662 | 245269 | 320015 | 298377 | 102806 | 385596 | 104853
Team 4 |  |  | 105414 | 156609 | 298681 | 202908 | 234378 | 96359 | 145347 | 396075
Team 5 |  |  | 97734 | 171193 | 152645 | 106796 | 179979 | 91051 | 162031 | 156313
Team 6 |  |  | 100855 | 200621 | 120116 | 113525 | 238812 | 52829 | 161166 | 158281
Team 7 |  |  | 63043 | 78780 | 103742 | 53064 | 51527 | 62151 | 168507 | 144656
Team 8 |  |  | 83204 | 183772 | 159791 | 135222 | 178601 | 57728 | 140619 | 85641
Team 9 |  |  | 50201 | 361132 | 198429 | 88334 | 108503 | 0 | 95503 | 179619
Team 10 |  |  | 42686 | 140523 | 60380 | 82860 | 0 | 83655 | 87245 | 77316
Team 11 |  |  | 97397 | 0 | 113977 | 168296 | 122610 | 52053 | 46332 | 48472
Team 12 |  |  | 114366 | 109633 | 95280 | 118191 | 128877 | 132087 | 48008 | 137865
Team 13 |  |  | 79270 | 60011 | 150435 | 93796 | 117169 | 105736 | 160663 | 78305
Team 14 |  |  | 41384 | 67039 | 111816 | 81707 | 79288 | 68811 | 71744 | 110830
Team 15 |  |  | 83933 | 64858 | 56551 | 54203 | 49057 | 71949 | 54299 | 108726
Team 16 |  |  | 95700 | 165361 | 106045 | 195700 | 113780 | 57654 | 100559 | 81486
Team 17 |  |  | 7075 | 160164 | 111844 | 195694 | 77249 | 118858 | 341482 | 73250
Team 18 |  |  | 19555 | 72578 | 66781 | 74521 | 68673 | 0 | 67917 | 75301
Team 19 |  |  | 0 | 156439 | 0 | 65588 | 27395 | 33110 | 65703 | 100699
Team 20 |  |  | 12364 | 34706 | 0 | 18730 | 40001 | 22826 | 32220 | 31694
Spreadsheet: 71595d1272366681-batch-inserting-blank-rows-insert5blank
Sheet: Sheet2

 | before sort |  | after sort
1 | a | 1 | a
2 | b | 2 | b
3 | c | 3 | c
4 | d | 4 | d
5 | e | 5 | e
6 | f | 6 | f
7 | g | 7 | g
8 | h | 7
9 | i | 7
10 | j | 7
11 | k | 7
12 | l | 7
13 | m | 8 | h
14 | n | 8
15 | o | 8
16 | p | 8
17 | q | 8
18 | r | 8
19 | s | 9 | i
20 | t | 9
7 |  | 9
8 |  | 9
9 |  | 9
10 |  | 9
11 |  | 10 | j
12 |  | 10
7 |  | 10
8 |  | 10
9 |  | 10
10 |  | 10
11 |  | 11 | k
12 |  | 11
7 |  | 11
8 |  | 11
9 |  | 11
10 |  | 11
11 |  | 12 | l
12 |  | 12
7 |  | 12
8 |  | 12
9 |  | 12
10 |  | 12
11 |  | 13 | m
12 |  | 14 | n
7 |  | 15 | o
8 |  | 16 | p
9 |  | 17 | q
10 |  | 18 | r
11 |  | 19 | s
12 |  | 20 | t
Spreadsheet: 783004d1654519368-sum-different-text-as-numbers-book-1
Sheet: Schedule

 | Position | TOTAL |  | Mon, Aug 1 | Tue, Aug 2 | Wed, Aug 3 | Thu, Aug 4 | Fri, Aug 5 | Sat, Aug 6 | Sun, Aug 7 | Mon, Aug 8 | Tue, Aug 9 | Wed, Aug 10 | Thu, Aug 11 | Fri, Aug 12 | Sat, Aug 13 | Sun, Aug 14 | Mon, Aug 15 | Tue, Aug 16 | Wed, Aug 17 | Thu, Aug 18 | Fri, Aug 19 | Sat, Aug 20 | Sun, Aug 21 | Mon, Aug 22 | Tue, Aug 23 | Wed, Aug 24 | Thu, Aug 25 | Fri, Aug 26 | Sat, Aug 27 | Sun, Aug 28 | Mon, Aug 29 | Tue, Aug 30 | Wed, Aug 31
 |  | VACATION | OFFICE
Employee 1 | AHS Executives |  |  | VACATION | FULL | FULL |  | AM |  |  | FULL |  | FULL |  | PM |  |  | FULL |  | FULL |  | FULL |  |  | FULL |  | FULL |  | FULL |  |  | FULL |  | FULL
 |  |  |  | FULL | Full day = 1
 |  |  |  | AM | Half day = 0.5
 |  |  |  | PM | Half day = 0.5
Spreadsheet: 74982d1275507704-adjusting-a-markup-formula-to-obtain-a-different-price-example
Sheet: Sheet1

Product Price | Product Cost | Initial [NAME]
105.018 | 76.1 | 0.38
26.3 | 18.92 | 0.3900634249471457
280.75 | 213.73 | 0.3135731998315632
60.5 | 40.16 | 0.5064741035856575
94.5 | 67.34 | 0.4033264033264032
127.65 | 86.24 | 0.4801716141001857
145.5 | 100.45 | 0.4484818317570931
169.99 | 120 | 0.4165833333333333
89.99 | 63.15 | 0.4250197941409342
73.5 | 56.62 | 0.2981278700105969
26.5 | 18.81 | 0.4088250930356194
151.6 | 103.48 | 0.4650173946656357
152.6 | 102.47 | 0.489216356006636
68.25 | 46.67 | 0.4623955431754874
296.99 | 224.27 | 0.3242520176572881
31.8 | 21.2 | 0.5
47.5 | 34.4 | 0.3808139534883721
44.4 | 34.15 | 0.3001464128843339
38.5 | 26.56 | 0.4495481927710845
58.5 | 46.36 | 0.2618636755823986
77.94 | 54.89 | 0.4199307706321733
108 | 76.05 | 0.4201183431952664
81.25 | 58.64 | 0.3855729877216916
99.99 | 69.51 | 0.438498057833405
Spreadsheet: 31721310-8da0-4389-8beb-28457b44cc16
Sheet: Sedans&PassAmbs

 | Equip. | Federal | 2014 Monthly | 2014 Mileage
Vehicle Description | Code | Std. Item | Rate | Rate
PASSENGER VEHICLES
Sedan, Midsize | 1100 | 10B | 260 | 0.18
Sedan, Midsize, Special Services | 1125 | 17Z | 308 | 0.2
Sedan, Midsize, Special Services | 1126 | 17, 17F | 350 | 0.2
Sedan, Midsize, Special Services, Charger | 1127 | 17R | 373 | 0.2
Sedan, Compact | 1200 | 9C, 9J, 9Z | 171 | 0.15
Sedan, Compact (Hybrid) | 1203 | 9H | 171 | 0.11
Sedan, Subcompact | 1300 | 8C, 8Z | 160 | 0.135
Sedan, Subcompact (Hybrid) | 1301 | 8H, 8J | 160 | 0.105
Sedan/Station Wagon Subcompact (Electric) | 1305 | 8E | 171 | 0.059
Sedan/Station Wagon Subcompact (Electric) | 1307 | 8P | 171 | 0.075
Sedan, Subcompact (CNG) | 1330 | 8N | 160 | 0.135
Sedan, Microcompact | 1358 | 7, 7Z | 204 | 0.136
Sedan, Large, Special Services | 1426 | 17A, 17R | 376 | 0.24
Motorcycle (Electric) | 1701 | 2E | 256 | 0
Station Wagon, Subcompact | 2000 | 12A, 12Z | 189 | 0.145
Station Wagon, Subcompact | 2100 | 13B, 13Z | 242 | 0.16
*  Federal  Standard Item Numbers are provided for information only.  Because of changes in the Federal
Standards, GSA Fleet vehicles may be available for which a Standard Item Number no longer exists.
AMBULANCES AND MEDICAL VEHICLES
Ambulances with capital values greater than $75K will receive a unique rate; please contact FSR for details
Patient [NAME], Wheel Chair Vans | 3150 | 281, 282, 283, 287 | 496 | 0.37
Type I-AD, Conventional Cab & Chassis, Additional Duty 4X2 | 3178 | 210 | 752 | 0.545
Type I-AD, Conventional Cab & Chassis, Additional Duty 4X4 | 3179 | 210 | 752 | 0.545
Type I, Conventional Cab &  Chassis w/ Narrow Modular Body 4X2 | 3180 | 211 | 752 | 0.545
Type I, Conventional Cab &  Chassis w/ Narrow Modular Body 4X4 | 3181 | 211 | 791 | 0.59
Ambulance, Air Transportable, Conv, Cab Chassis W/Modular Body 4x2 | 3160 | 216 | [NAME]
Ambulance, Air Transportable, Conv, Cab Chassis W/Modular Body 4x4 | 3161 | 216 | [NAME]
Type III-AD, Cutaway C&C W/Narrow Modular Body, Additional Duty | 3186 | 215 | 1306 | 0.545
Type III, Cutaway C&C W/Narrow Modular Body 4x2 | 3188 | 213 | 650 | 0.515
Indian Health Service Ambulance, [NAME] | 3195 | 213 | 342 | 0.41
Indian Health Service Ambulance, 4X4 | 3196 | 211 | 377 | 0.41
Spreadsheet: 298918d1392944498-conditional-formatting-query-conditional-scale
Sheet: Sheet1

RUNNING PROGRESS INDICATOR
TARGETS
11
ACTUAL |  | Target Set by Entering Figure into A5 | Target Set by Auto Filled Figure in A7
8
DISCREPANCY
 |  | Math | Math
Math | Scale
 |  | Targets Helper Columns | Actual Figures Helper Columns
 | 20
 | 19
 | 18
 | 17
 | 16
 | 15
 | 14
 | 13
 | 12 |  |  |  |  |  | The scale needs to show the colour range upto the number 11 (the target) but needs to cap itself off at the actual running figure. This has been indicated by the placement of grey boxes over the 9,10 & 11 figures to indicate the desired display.
11 | 11
10 | 10
9 | 9
8 | 8 |  | 8
7 | 7
6 | 6
5 | 5
4 | 4
3 | 3
2 | 2
1 | 1
0 | 0
Spreadsheet: 63890a1a-14a6-4693-9513-f1a49158afdd
Sheet: Sheet1

PROG ID | ATHLETE ID | ATHLETE FIRST | ATHLETE LAST | NATIONALITY | START NUMBER | RUN | T1 | SWIM | T2 | RUN.1 | POSITION | TOTAL TIME
8007 | 69374 | Ivana | Kuriackova | SVK | 28 | 00:00:00 | 00:00:00 | 00:13:58 | 00:01:24 | 00:18:32 | 1 | 00:33:54
Spreadsheet: 871569d1718018578-formula-error-in-generating-repteated-sequence-book2
Sheet: Sheet2

 | Region | Employee | Product | Location
 | Region-1 | EMP-1 | PRO-1 | Central Region |  |  | Central Region
 | Region-1 | EMP-2 | PRO-2 | Central Region |  | [NAME] | Eastern Region |  | 1 |  | #[NAME]! |  |  | 1
 | Region-1 | EMP-3 | PRO-4 | Central Region |  | Region-3 | Eastern Region |  | 2 |  | #[NAME]! |  |  | 2
 | Region-1 | EMP-4 | PRO-2 | Central Region |  | [NAME] | Eastern Region |  | 3 |  | #[NAME]! |  |  | 3
 | Region-1 | EMP-5 | PRO-1 | Central Region |  | Region-4 | Western Region |  | 1 |  | #[NAME]! |  |  | 1
 | Region-1 | [NAME] | PRO-2 | Central Region |  | Region-6 | Western Region |  | 2 |  | #[NAME]! |  |  | 2
 | [NAME] | EMP-1 | PRO-3 | Eastern Region |  | Region-5 | Western Region |  | 3 |  | #[NAME]! |  |  | 3
 | [NAME] | EMP-2 | PRO-2 | Eastern Region
 | [NAME] | EMP-3 | PRO-3 | Eastern Region
 | [NAME] | EMP-4 | PRO-2 | Eastern Region
 | Region-4 | EMP-1 | PRO-3 | Western Region
 | Region-4 | EMP-2 | PRO-2 | Western Region
 | Region-4 | EMP-3 | PRO-3 | Western Region
 | Region-4 | EMP-4 | PRO-2 | Western Region
 | Region-6 | EMP-1 | PRO-3 | Western Region
 | Region-6 | EMP-2 | PRO-1 | Western Region
 | Region-6 | EMP-3 | PRO-3 | Western Region
 | Region-6 | EMP-4 | PRO-2 | Western Region
 | Region-5 | EMP-1 | PRO-1 | Western Region
 | Region-5 | EMP-2 | PRO-3 | Western Region
 | Region-5 | EMP-3 | PRO-3 | Western Region
 | Region-3 | EMP-1 | PRO-1 | Eastern Region
 | Region-3 | EMP-2 | PRO-3 | Eastern Region
 | Region-3 | EMP-3 | PRO-3 | Eastern Region
 | Region-3 | EMP-4 | PRO-1 | Eastern Region
 | Region-3 | EMP-5 | PRO-3 | Eastern Region
 | Region-3 | [NAME] | PRO-1 | Eastern Region
 | Region-3 | EMP-7 | PRO-3 | Eastern Region
 | Region-3 | EMP-8 | PRO-3 | Eastern Region
 | [NAME] | EMP-1 | PRO-1 | Eastern Region
Spreadsheet: 738797d1625239774-vlookup-with-a-row-from-another-sheet-eh_vlookup-db
Sheet: Sheet1

Flavour |  |  |  |  |  |  |  |  |  |  |  |  |  | Flavour | Country of Origin | Meat Fish Poultry Sector and Sub Type | Prism Sub Market | Prism Type | Pack Type | Ambient Chilled frozen | Protein
Country of Origin
Meat Fish Poultry Sector and Sub Type
Prism Sub Market
Prism Type
Pack Type
Ambient Chilled frozen
Protein
Spreadsheet: 125605d1319124697-help-with-multiple-if-statements-gates1
Sheet: Sheet1

GATE SELECT |  | INPUT A | INPUT B | OUTPUT | GATE TYPE
1 | 0 | 0 | 1 | 1 | NAND
AND GATE TRUTH TABLE |  |  | OR GATE TRUTH TABLE |  |  | NAND GATE TRUTH TABLE |  |  | NOR GATE TRUTH TABLE
INPUT A | INPUT B | OUTPUT | INPUT A | INPUT B | OUTPUT | INPUT A | INPUT B | OUTPUT | INPUT A | INPUT B | OUTPUT
0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 1 | 0 | 0 | 1
0 | 1 | 0 | 0 | 1 | 1 | 0 | 1 | 1 | 0 | 1 | 0
1 | 0 | 0 | 1 | 0 | 1 | 1 | 0 | 1 | 1 | 0 | 0
1 | 1 | 1 | 1 | 1 | 1 | 1 | 1 | 0 | 1 | 1 | 0
Spreadsheet: 746811d1631040374-count-a-column-value-if-2-other-column-conditions-match-count-if
Sheet: Sheet1

User | Year | Usage
A1 | 2009 | Heavy
A1 | 2009 | Heavy
A1 | 2009 | Heavy
A1 | 2010 | Moderate
A1 | 2010 | Moderate
A1 | 2011 | Light
A2 | 2010 | Light
A2 | 2011 | Heavy
A2 | 2011 | Heavy
A2 | 2011 | Heavy
A2 | 2009 | Moderate
A2 | 2009 | Moderate
A3 | 2009 | Light
A3 | 2010 | Heavy
A3 | 2010 | Heavy
A3 | 2010 | Heavy
A3 | 2011 | Light
A3 | 2011 | Light
Spreadsheet: chris_germany__2304__2001new01
Sheet: 3rd Party Deals

 | EES |  |  |  | EES |  |  |  | ENA |  |  |  | EOG |  |  |  | EES
 | A3 - Maumee |  |  |  | A06 |  |  |  | A06 |  |  |  | [NAME] |  |  |  | [NAME] |  |  |  | Total | Net
 | 551050 | Price | Amount |  | 551052 | Price | Amount |  | 547583 / 551053 | Price | Amount |  | 551056 | Price | Amount |  | 551058 | Price | Amount |  | Receipt | Citygate
1 | 0 |  |  |  | 2374 |  |  |  | 1600 |  |  |  | 4000 |  |  |  | 3674
 | 6005
 | 1946
 | 13801
 | 3114
 | 14823
Spreadsheet: 884480d1733672842-sorting-a-list-of-authors-some-first-names-are-initials-some-cells-have-2-authors-nardar-author-list-test-tms
Sheet: Sheet1

 | [NAME]
 | [NAME] |  | Jacobs, [NAME] |  | [NAME] |  | [NAME], [NAME]
 | [NAME] |  | [NAME], [NAME] |  | [NAME], [NAME] translator |  | [NAME], [NAME]; [NAME] translator
 | [NAME] |  | Runyan, [NAME] |  | [NAME] |  | Jacobs, [NAME]
 | [NAME] |  | Sansom, C.J. |  | [NAME] |  | [NAME], [NAME]
 | [NAME] |  | Smith, [NAME] |  | [NAME] |  | Runyan, [NAME]
 |  |  |  |  | [NAME] |  | Sansom, C.J.
 | [NAME], [NAME] |  |  |  | [NAME] |  | Smith, [NAME]
 | [NAME], [NAME] translator |  | [NAME], [NAME]; [NAME] translator |  | [NAME], [NAME], The Pop Ups |  | [NAME], [NAME]; [NAME], The Pop Ups
 | [NAME], [NAME] |  | [NAME], [NAME]; [NAME], The Pop Ups |  | [NAME], [NAME] |  | Tolkien, [NAME]; [NAME]
 | [NAME], [NAME], The Pop Ups |  | Tolkien, [NAME]; [NAME] |  | 0
 |  |  |  |  | [NAME]
 |  |  |  |  | [NAME], [NAME] translator
 |  |  |  |  | [NAME]
 |  |  |  |  | [NAME]
 |  |  |  |  | [NAME]
 |  |  |  |  | [NAME]
 |  |  |  |  | [NAME]
 |  |  |  |  | [NAME], [NAME], The Pop Ups
 |  |  |  |  | [NAME], [NAME]
Spreadsheet: 355323d1414659805-removing-all-duplicates-remove-dup
Sheet: Sheet1

 | aaa
 | aaa
 | bbb
 | bbb
 | [NAME]
 | [NAME]
 | [NAME]
 | ddd
 | eee
 | [NAME]
Spreadsheet: 748765d1632327187-check-if-time-range-is-within-another-time-range-counting-multiple-rows-of-time-overlap-with-conditions-desgostoso-
Sheet: Sheet1

 |  | 2021-09-01 00:00:00 | 2021-09-02 00:00:00 | 2021-09-03 00:00:00 | 2021-09-04 00:00:00 | 2021-09-05 00:00:00 | 2021-09-06 00:00:00 | 2021-09-07 00:00:00 |  | Question:
Test | Name | 08:00-16:00 | 08:00-16:00 | 08:00-16:00 | 08:00-16:00 | 08:00-16:00 | 08:00-16:00 | 08:00-16:00 |  | How to shorten the formula. If I would put lets say 40 more rows I will reach the max of 9000~ characters in 1 cell
Different | Name | 08:00-16:00 | 08:00-16:00 | 08:00-16:00 | 08:00-16:00 | 08:00-16:00 | 08:00-16:00 | 08:00-16:00
Test | Name | HOL | HOL | HOL | HOL | HOL | HOL | HOL
Different | Name | 16:00-24:00 | 16:00-24:00 | 16:00-24:00 | 16:00-24:00 | 16:00-24:00 | 16:00-24:00 | 16:00-24:00
Different | Name | HOL | HOL | HOL | HOL | HOL | HOL | HOL
Test | Name | 08:00-16:00 | 08:00-16:00 | 08:00-16:00 | 08:00-16:00 | 08:00-16:00 | 08:00-16:00 | 08:00-16:00
Different | Name | 08:00-16:00 | 08:00-16:00 | 08:00-16:00 | 08:00-16:00 | 08:00-16:00 | 08:00-16:00 | 08:00-16:00
Different | Name | 08:00-16:00 | 08:00-16:00 | 08:00-16:00 | 08:00-16:00 | 08:00-16:00 | 08:00-16:00 | 08:00-16:00
Test | Name | 08:00-16:00 | 08:00-16:00 | 08:00-16:00 | 08:00-16:00 | 08:00-16:00 | 08:00-16:00 | 08:00-16:00
 |  |  |  |  |  |  |  |  |  | in C3 | Result | [NAME]
 | 08:00-09:00 |  |  |  |  |  |  |  |  | IF A2 contains "Test"  and time in C2 falls in B13 | 1
 | 09:00-10:00 |  |  |  |  |  |  |  |  | IF A3 contains "Test"  and time in C3 falls in B13 | False
 | 10:00-11:00 |  |  |  |  |  |  |  |  | IF A4 contains "Test"  and time in C4 falls in B13 | 0
 | 11:00-12:00 |  |  |  |  |  |  |  |  | IF A5 contains "Test"  and time in C5 falls in B13 | False
 | 12:00-13:00 |  |  |  |  |  |  |  |  | A6 etc.. | False
 | 13:00-14:00 |  |  |  |  |  |  |  |  | A7 etc.. | 1
 | 14:00-15:00 |  |  |  |  |  |  |  |  | A8 etc.. | False
 | 15:00-16:00 |  |  |  |  |  |  |  |  | A9 etc.. | False
 | 16:00-17:00 |  |  |  |  |  |  |  |  | A10 etc.. | 1
 | 17:00-18:00
 | 18:00-19:00 |  |  |  |  |  |  |  |  | All those formulas above in 1 cell like in C13 | 3
 | 19:00-20:00
 | 20:00-21:00
 | 21:00-22:00
 | 22:00-23:00
 | 23:00-24:00
Spreadsheet: phillip_m_love__30523__Sithe_Jun29_01
Sheet: Summary

VALUE OF SITHE DEAL AT EMPRESS AS OF JUNE 29, 2001
IN CANADA'S BOOKS
JULY 2001 FORWARD
 | Value of Annuity Required from Houston - USD
 |  | P7 Unwind
 |  | IM cost |  |  |  |  |  |  | IM bid | 3.27
 |  | Sithe Fee |  |  |  |  |  |  | July MI
 |  | Total |  |  |  |  |  |  | fx
 |  |  |  |  |  |  |  |  | IM cost
 |  |  |  |  |  |  | POSTID'S | Annuities | Unwind
 |  |  |  |  |  |  | P7 | 1184476 | 1184478
 |  |  |  |  |  |  | INDEX | 1184477 | 1184479
Spreadsheet: 78581cfd-7baf-415b-bbce-994cf3bae6b4
Sheet: Sheet1

State [NAME] (North Dakota) | Unnamed: 1 | Unnamed: 2 | Unnamed: 3 | Unnamed: 4 | Unnamed: 5
Downloaded at 4/20/2014 1:23:26 PM
Precincts Reporting: 528/528 - Total Ballots Cast: 102886
2008 Primary Election - OFFICIAL RESULTS
District | [NAME] | [NAME] | [NAME] | Whitney Hauz | TOTALS
District 02 | 1 | 0 | 0 | 0 | 1
District 03 | 0 | 0 | 0 | 0 | 0
District 04 | 0 | 0 | 0 | 0 | 0
District 05 | 0 | 1 | 0 | 0 | 1
District 06 | 0 | 0 | 0 | 0 | 0
District 11 | 0 | 0 | 0 | 0 | 0
District 13 | 0 | 0 | 0 | 0 | 0
District 20 | 0 | 0 | 0 | 0 | 0
District 21 | 0 | 0 | 0 | 0 | 0
District 22 | 0 | 0 | 0 | 0 | 0
District 27 | 0 | 0 | 0 | 0 | 0
District 36 | 0 | 0 | 0 | 0 | 0
District 37 | 0 | 0 | 0 | 0 | 0
District 38 | 0 | 0 | 0 | 0 | 0
District 40 | 0 | 0 | 0 | 0 | 0
District 41 | 0 | 0 | 0 | 0 | 0
District 44 | 1 | 0 | 1 | 1 | 3
Results provided by the Office of North Dakota Secretary of State | 0 | 0 | 1 | 0 | 1
District 46 | 0 | 0 | 0 | 0 | 0
TOTAL | 2 | 1 | 2 | 1 | 6
Spreadsheet: mike_carson__27664__BrokerQuote(SouthEast)
Sheet: Sheet1

Broker | Prebon
Date | 2002-01-28 00:00:00
Time | 11.00AM |  |  |  | Please time stamp the quote sheet before sending back
ONPEAK |  |  |  |  |  |  |  | [NAME]
PRICE | SOUTHEAST |  |  |  |  |  |  | PRICE | SOUTHEAST
 | SOCO |  | Entergy |  |  |  |  |  | SOCO |  | Entergy
 | Bid | Offer | Bid | Offer |  |  |  |  | Bid | Offer | Bid | Offer
Dailies | 20.25 | 20.75 | 17.5 | 18.5 |  |  |  | Dailies
Next Week | 20 | 21.5 | 17.5 | 18.5 |  |  |  | Next Week
[NAME] | 20 | 21.5 | 17.5 | 18.5 |  |  |  | [NAME]
2002-02-02 00:00:00 | 22.75 | 23.25 | 18.3 | 18.5 |  |  |  | 2002-02-02 00:00:00 | 19.25 | 20
M/A 02 | 21.75 | 22.5 | 19.5 | 19.75 |  |  |  | M/A 02
2002-05-01 00:00:00 | 24.75 | 25.25 | 22.5 | 23 |  |  |  | 2002-05-01 00:00:00
2002-06-01 00:00:00 | 29.75 | 30.5 | 26.25 | 27 |  |  |  | 2002-06-01 00:00:00
Sum 02 | 39 | 39.25 | 33.25 | 33.5 |  |  |  | Sum 02
2002-09-01 00:00:00 | 23 | 23.75 | 21.25 | 21.5 |  |  |  | 2002-09-01 00:00:00
Q4 02 | 22.9 | 23.4 | 21.25 | 21.45 |  |  |  | Q4 02
Bal CAL-02 | 26.4 | 27 | 23.25 | 23.75 |  |  |  | CAL-02
W 03 | 26.25 | 26.75 | 24 | 24.5 |  |  |  | W 03
M/A 03 | 25.25 | 26 | 22.75 | 23.25 |  |  |  | M/A 03
2003-05-01 00:00:00 | 27 | 27.75 | 24.5 | 25.25 |  |  |  | 2003-05-01 00:00:00
2003-06-01 00:00:00 | 32.75 | 33.5 | 29.5 | 30.25 |  |  |  | 2003-06-01 00:00:00
Sum 03 | 40.25 | 40.75 | 34.5 | 34.75 |  |  |  | Sum 03
2003-09-01 00:00:00 | 24.75 | 25.25 | 23 | 23.75 |  |  |  | 2003-09-01 00:00:00
Q4 03 | 25.25 | 26 | 23.75 | 24.5 |  |  |  | Q4 03
CAL-03 | 28.5 | 29.25 | 25.75 | 26.35 |  |  |  | CAL-03
[NAME] | 30 | 31 | 27 | 27.75 |  |  |  | [NAME]
Cal-05 | 30.75 | 32 | 28.5 | 29.5 |  |  |  | Cal-05
Cal-06 | - | - | - | - |  |  |  | Cal-06
Cal-07-10 | - | - | - | - |  |  |  | Cal-04-06 | 21.5 | 22.5
Spreadsheet: 681798d1591754214-importing-data-from-several-sheets-indirect-vlookup
Sheet: BILLING

 |  |  |  |  |  |  |  |  |  |  | Office | Gross | 0.05 | 0.02 | Net Amount | Telephone Expenses - Landline | Internet Subscription Expense | Auditing Services | Due to BIR - Withholding Tax on Suppliers/Creditors | Cash - Modified Disbursement System (MDS), Regular
 | 652949266 | I Gate DFA HO1-092015-60603 | 114664611 | OAMSS-ITRCD | 62500 |  |  | 375000.01 | 6696.43 | 2006-01187 | OAMSS-ITRCD | 62500 | 2790.18 | 1116.07 | 58593.75 | 0 | 62500 | 0 | 3906.25 | 58593.75
 | 19887 | 831-8939 | 114664573 | COA | 1720.75 |  |  | 7266.83 | 184.37 | 2006-01195 | COA | 1720.75 | 76.82 | 30.73 | 1613.2 | 0 | 0 | 1720.75 | 107.55 | 1613.2
 | 504483 | 832-1508 | 114666022 | PISU | 1410.15 |  |  | 3643.32 | 151.09 | 2006-01199 | PISU | 9021.05 | 402.72 | 161.09 | 8457.24 | 4541.05 | 4480 | 0 | 563.8100000000001 | 8457.24
 | #N/A |  |  |  | 65630.9 | 0 | 0 | 385910.16
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | * Red font data, taken from sheets with DVs name
Spreadsheet: 295d60fd-3b5a-4f35-9b2b-f8a3ed6126c5
Sheet: Sheet1

PROG ID | ATHLETE ID | ATHLETE FIRST | ATHLETE LAST | NATIONALITY | START NUMBER | RUN | T1 | BIKE | T2 | SKI | POSITION | TOTAL TIME
8918 | 68536 | [NAME] | Sulbi | EST | 283 | 00:24:41 | 00:00:45 | 00:58:00 | 00:02:05 | 00:36:25 | 1 | 02:01:56
Spreadsheet: 868015d1714730920-why-is-this-not-working-test
Sheet: YTD24

Test
Profit & Loss Account
 |  |  |  |  |  | Last year
 |  | Actual |  | Budget |  | Actual
Turnover
FC
EF
S
T
E
A
D
Other incl accrued income adj
Spreadsheet: 753823d1635778254-help-with-customized-recipe-list-that-filters-to-what-ingredients-you-have-on-hand-shopping-list-and-recipes
Sheet: Bacon Corn Chowder

Dish | Ingredient | Amount | Category | Notes:
Bacon Corn Chowder | Carrot | 2 large carrots | Vegetable | Recipe is either drained corn OR frozen corn
 | Onion | 1 large onion | Vegetable
 | Potatoes | 4 potatoes | Vegetable
 | Corn | 32 oz drained canned corn | Vegetable
 | Corn | 32 oz creamed corn | Vegetable
 | [NAME] | 4 cups | Liquid Goods
 | Bacon | 1 lb cooked and crumbled | Meat
 | Thyme | 0.5 teaspoon | Herbs and Spices
 | Parsley | 1 teaspoon | Herbs and Spices
 | [NAME] | 0.5 teaspoon | Herbs and Spices
 | Salt | to taste | Staple
 | Pepper | to taste | Staple
 | Evaporated Milk | 12 oz | Dairy
 | Cornstarch | 2 tablespoons | Dry Goods
 | Butter | 3 tablespoons | Dairy
 | Corn | 12 oz bag of frozen corn | Frozen