tianzl66/Sheetpedia huggingface dataset:
Spreadsheet: 851763d1701897254-function-needed-to-select-data-point-from-range-of-price-values-protection-plan
Sheet: EPP Cost Breakdown

 | Combined Product Price
 | From | To | 2+ Years | 3+ Years | 4+ Years
1 Appliance | 0 | 499.99 | 70.99 | 106.99 | 141.99
 | 500 | 749.99 | 92.99 | 139.99 | 184.99
 | 750 | 999.99 | 103.99 | 155.99 | 206.99
 | 1000 | 1249.99 | 124.99 | 187.99 | 249.99
 | 1250 | 1499.99 | 130.99 | 195.99 | 260.99
 | 1500 | 1999.99 | 157.99 | 236.99 | 315.99
 | 2000 | 2499.99 | 173.99 | 260.99 | 347.99
 | 2500 | 3499.99 | 201.99 | 302.99 | 402.99
 | 3500 | 4999.99 | 206.99 | 309.99 | 412.99
 | 5000 | 7499.99 | 282.99 | 423.99 | 565.99
 | 7500 | 9999.99 | 423.99 | 635.99 | 847.99
 | 10000 | 12499.99 | 434.99 | 652.99 | 869.99
 | 12500 | 17499.99 | 652.99 | 978.99 | 1304.99
 | 17500 | 25000 | 923.99 | 1385.99 | 1847.99
 | From | To | 2+ Years | 3+ Years | 4+ Years
2 Appliances | 400 | 999.99 | 119.99 | 179.99 | 239.99
 | 1000 | 1249.99 | 152.99 | 228.99 | 304.99
 | 1250 | 1499.99 | 162.99 | 244.99 | 326.99
 | 1500 | 1749.99 | 179.99 | 269.99 | 358.99
 | 1750 | 2499.99 | 190.99 | 285.99 | 380.99
 | 2500 | 3499.99 | 244.99 | 367.99 | 489.99
 | 3500 | 4999.99 | 287.99 | 432.99 | 575.99
 | 5000 | 7499.99 | 353.99 | 530.99 | 706.99
 | 7500 | 9999.99 | 489.99 | 733.99 | 978.99
 | 10000 | 19999.99 | 815.99 | 1222.99 | 1630.99
 | 20000 | 34999.99 | 1358.99 | 2037.99 | 2716.99
 | 35000 | 50000 | 1956.99 | 2934.99 | 3912.99
 | From | To | 2+ Years | 3+ Years | 4+ Years
3+ Appliances | 900 | 1499.99 | 201.99 | 302.99 | 402.99
 | 1500 | 1999.99 | 233.99 | 351.99 | 467.99
 | 2000 | 2499.99 | 244.99 | 367.99 | 489.99
 | 2500 | 3499.99 | 282.99 | 423.99 | 565.99
 | 3500 | 4999.99 | 326.99 | 489.99 | 652.99
 | 5000 | 9999.99 | 489.99 | 733.99 | 978.99
 | 10000 | 14999.99 | 815.99 | 1222.99 | 1630.99
 | 15000 | 19999.99 | 1141.99 | 1711.99 | 2282.99
 | 20000 | 24999.99 | 1521.99 | 2282.99 | 3043.99
 | 25000 | 29999.99 | 1901.99 | 2852.99 | 3803.99
 | 30000 | 34999.99 | 2282.99 | 3423.99 | 4564.99
 | 35000 | 39999.99 | 2662.99 | 3993.99 | 5325.99
 | 40000 | 44999.99 | 3043.99 | 4564.99 | 6086.99
 | 45000 | 49999.99 | 3423.99 | 5135.99 | 6846.99
 | 50000 | 74999.99 | 3803.99 | 5705.99 | 7607.99
 | 75000 | 99999.99 | 6113.99 | 9170.99 | 1226.99
 | 100000 | 124999.99 | 8150.99 | 12226.99 | 16301.99
 | 125000 | 150000 | 10188.99 | 15283.99 | 20377.99
Spreadsheet: 3cc48a79-cc02-43c3-9097-8b9d2ffe5e05
Sheet: Sheet1

Unnamed: 0 | COMMERCIAL VALUATIONS for | Unnamed: 2 | Unnamed: 3 | Unnamed: 4 | Unnamed: 5 | Unnamed: 6 | Unnamed: 7 | Unnamed: 8 | Unnamed: 9
 | FIRE SPRINKLER WORKSHEET
 | Job Address:
 |  | USE | SQ. FT. |  | VALUE |  |  |  | VALUATION*
 |  | EXISTING NON-SPRINKLED BUILDING
 |  | ASSEMBLY |  | X | 131.81 |  |  | = | 0
 |  | BUSINESS |  | X | 121.32 |  |  | = | 0
 |  | EDUCATION  K-12 |  | X | 135.35 |  |  | = | 0
 |  | FACTORY |  | X | 64.39 |  |  | = | 0
 |  | HAZARDIOUS |  | X | 121.32 |  |  | = | 0
 |  | INSTITUTAL |  | X | 126.72 |  |  | = | 0
 |  | MERCANTILE |  | X | 88.45 |  |  | = | 0
 |  | RESIDENTIAL,  HOTEL |  | X | 128.36 |  |  | = | 0
 |  | STORAGE |  | X | 56.71 |  |  | = | 0
 |  | UTILITY |  | X | 42.48 |  |  | = | 0
 |  | TOTAL EXISTING VALUE |  |  |  | TOTAL A |  | = | 0
 |  | FACTORED EXISTING VALUE | 0 | X | 0.25 | TOTAL B |  | = | 0
 |  | FACTORED EXISTING VALUE FOR |  |  |  |  |  | =
 |  | ASSEMBLIES ONLY | 0 | X | 0.1 | TOTAL C |  | = | 0
 |  | NEW CONSTRUCTION/ADDITION
 |  | ASSEMBLY |  | X | 131.81 |  |  | = | 0
 |  | BUSINESS |  | X | 121.32 |  |  | = | 0
 |  | EDUCATION  K-12 |  | X | 135.35 |  |  | = | 0
 |  | FACTORY |  | X | 64.39 |  |  | = | 0
 |  | HAZARDIOUS |  | X | 121.32 |  |  | = | 0
 |  | INSTITUTAL |  | X | 126.72 |  |  | = | 0
 |  | MERCANTILE |  | X | 88.45 |  |  | = | 0
 |  | RESIDENTIAL,  HOTEL |  | X | 128.36 |  |  | = | 0
 |  | STORAGE |  | X | 56.71 |  |  | = | 0
 |  | UTILITY |  | X | 42.48 |  |  | = | 0
 |  |  |  |  |  | TOTAL D |  | = | 0
 |  | REMODELED AREAS, includes work requiring permit per  IBC as amended.
 |  | ASSEMBLY |  | X | 131.81 | X | 0.3 | = | 0
 |  | BUSINESS |  | X | 121.32 | X | 0.3 | = | 0
 |  | EDUCATION  K-12 |  | X | 135.35 | X | 0.3 | = | 0
 |  | FACTORY |  | X | 64.39 | X | 0.3 | = | 0
 |  | HAZARDIOUS |  | X | 121.32 | X | 0.3 | = | 0
 |  | INSTITUTAL |  | X | 126.42 | X | 0.3 | = | 0
 |  | MERCANTILE |  | X | 88.45 | X | 0.3 | = | 0
 |  | RESIDENTIAL,  HOTEL |  | X | 128.36 | X | 0.3 | = | 0
 |  | STORAGE |  | X | 56.71 | X | 0.3 | = | 0
 |  | UTILITY |  | X | 42.48 | X | 0.3 | = | 0
 |  |  |  |  |  | TOTAL E |  | = | 0
 |  | TOTAL NEW AND [NAME], (D+E) |  |  |  | TOTAL F |  | = | 0
 | IF F >B FIRE SPRINKLERS WILL BE REQUIRED
 | 0
 | ASSEMBLIES ONLY   IF F >C FIRE SPRINKLERS WILL BE REQUIRED
 | 0
 | IF TOTAL F >50% of TOTAL A
 | 0
 | * Values are based on the ICC Building Safety Journal, Feb 2014. |  |  |  |  |  | locked, revised 07/07/2014
 | The scope of work and related square footages provided are subject to field verification.  Where discrepancies are encountered by the inspector, work shall stop and a new worksheet shall be completed, inclusive of the entire known scope of work.  Sprinklers shall be installed if indicated on the revised worksheet.
Spreadsheet: 156968d1337584712-find-value-and-count-how-many-times-after-every-nth-row-value-appears-test_clarification
Sheet: Sheet1

 |  |  | 50 | 60 | 70 | 80 | 90 | 100 | 110 | 120 | 130 | 140 | 150 | 160 | 170 | 180 | 190 | 200 | 210 | 220
150 | 1 | 100 | looking for C2 in area A2:A47 and if D1 exist after C2, but only if B2 cells down from C2, count how many times D1 is appearing, manually count result is 1
150 | 2 | 150 | looking for C3 in area A2:A47 and if D1 exist after [NAME], but only if B3 cells down from C3, count how many times D1 is appearing, manually count result is 0
110 | 3 | 70
120 | 4 | 110
150 | 5 | 90
190 | 6 | 110
80 | 7 | 70
100 | 8 | 140
50 | 9 | 110
130 | 10 | 90
130
70
120
90
160
130
130
70
130
120
110
80
160
100
120
120
180
80
100
80
130
140
160
140
80
130
90
110
140
70
110
90
110
70
150
100
Spreadsheet: 212870d1360267960-running-balance-remaining-balance-chart
Sheet: Sheet1

Amount |  | 1000000 |  |  |  | 4000000
1 | 5000
2 | 10000
3 | 20000
4 | 30000
5 | 45000
6 | 25000
7 | 1000000
8
9
10
11
12
13
14
15
16
17
Spreadsheet: 08cae973-a59a-40cd-8bd1-14481440a549
Sheet: 1

 | Dec 21 | Dec 28 | Jan 4 | Jan 11 | Jan 18
Total Interest Rate* | 375002189 | 373145478 | 370621611 | 380218108 | 385395440
Cleared** | 171218535 | 170352573 | 169515426 | 175639239 | 178792699
Uncleared | 203783654 | 202792905 | 201106184 | 204578869 | 206602742
Total Cross-Currency | 16716689 | 16648654 | 16574252 | 16747192 | 17016046
Cleared | N/A*** | N/A | N/A | N/A | N/A
Uncleared | 16716689 | 16648654 | 16574252 | 16747192 | 17016046
Total Credit | 20541675 | 20639476 | 20564465 | 20885424 | 20946955
Cleared | 2540603 | 2551950 | 2576102 | 2606053 | 2624288
Uncleared | 18001072 | 18087527 | 17988362 | 18279372 | 18322667
Total Equity | 5166993 | 5166993 | N/A | N/A | N/A
Cleared | 0 | 0 | 0 | 0 | 0
Uncleared | 5166993 | 5166993 | N/A | N/A | N/A
Total Other Commodity | 3091000 | 3091000 | 3091000 | 3091000 | 3091000
Cleared | N/A | N/A | N/A | N/A | N/A
Uncleared | N/A | N/A | N/A | N/A | N/A
TOTAL | 420518546 | 418691601 | 410851328 | 420941724 | 426449441
Weekly snapshot, estimated gross notional amount outstanding by asset class and cleared status (millions of USD), all products, tenors, and participant types. Data are adjusted for double-counting of cleared trades to show a single exposure for each trade.
*See Data Dictionary for asset class descriptions and Explanatory Notes for data sources.
**See Explanatory Notes for cleared and uncleared descriptions.
***N/A indicates that data are not currently available.
The Commission requests feedback on the format and content of this CFTC Swaps Report table. Submit comments to [EMAIL].
Spreadsheet: 6634048b-6bfd-4e7f-8fb3-54090f625cb7
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
FIL4S | Test | FIL4S | Interleukin-4 (IL-4) Serum | IL-4, Serum | Electrochemiluminescence | Plain, Red-Top Tube: Red |  |  |  |  | Draw blood in a plain red-top tube(s), serum gel tube(s) is acceptable. Spin down and send 1 mL of serum frozen in a plastic vial. | 1 mL | Hemolysis:	NA Thawing:	Warm reject; Cold OK Lipemia:	NA Icterus:	NA Other:	NA | <4.0 pg/mL  Test Performed by:	Viracor-IBT Laboratories 			1001 NW Technology Dr.  			Lee's Summit, MO 64086 | Monday, Wednesday, Friday | 3 - 5 days | 5 - 11 days | 1 | 83520 |  |  |  |  | Viracor-IBT Laboratories
FIL4S | [NAME] | SERUM | Serum |  |  |  | Frozen | 28 days
FIL4S | Result | FIL4S | IL-4, Serum | IL-4, Serum | Alphanumeric |  |  |  |  |  |  |  |  |  |  |  |  |  |  | In Process
Spreadsheet: 442941d1453879801-count-games-played-sample
Sheet: Sheet1

Situation 1
PICKS | PLAYED BY | RESULTS |  | [NAME] | Game 1
Game 1 | [NAME] | Won |  | "In these cell should contain how many games [NAME] played" | "In these cell should contain how many times [NAME] played a certain game."
Game 2 | [NAME]
Game 3 | Juls
Game 4 | [NAME]
Game 5 | [NAME]
Game 1 | [NAME] | Won
Game 2 | [NAME]
Game 3 | Juls
Game 4 | [NAME]
Game 5 | [NAME]
Situation 2
RANK | Most Banned | Count |  |  | Game | Count
1 | "In this cell should show what game was played the most" | "In this cell should show how many times the game was played" |  |  | Game 1 | 5
2 |  |  |  |  | Game 2 | 2
3 |  |  |  |  | Game 3 | 1
4 |  |  |  |  | Game 4
5 |  |  |  |  | Game 5
6 |  |  |  |  | Game 6 | 6
7 |  |  |  |  | Game 7
8 |  |  |  |  | Game 8 | 10
9 |  |  |  |  | Game 9
10 |  |  |  |  | Game 10 | 8
 |  |  |  |  | Game 11
 |  |  |  |  | Game 12 | 4
 |  |  |  |  | Game 13
 |  |  |  |  | Game 14 | 9
 |  |  |  |  | Game 15
 |  |  |  |  | Game 16 | 10
 |  |  |  |  | Game 17 | 3
 |  |  |  |  | Game 18
 |  |  |  |  | Game 19
 |  |  |  |  | Game 20 | 4
Spreadsheet: 858291d1707027971-worksheet-with-dynamic-cell-references-example-excel-dj
Sheet: Sheet1

 |  | Main Data Table
 |  | Areas | Day 1 | Day 2 | Day 3 | Day 4 | Day 5 | Day 6 | Day 7 | Day 8 | Day 9 | Day 10 | Day 11 | Day 12 | Day 13 | Day 14 | Day 15 | Day 16 | Day 17 | Day 18 | Day 19 | Day 20 | Day 21
 |  | Area 1 | 80 | 75 | 64 | 73 | 69
 |  | Area 2 | 64 | 65 | 73 | 66 | 53
 |  | Area 3 | 72 | 64 | 66 | 50 | 67
 |  | Area 4 | 63 | 66 | 51 | 77 | 80
 |  | Area 5 | 74 | 50 | 63 | 53 | 60
 |  | Area 6 | 59 | 68 | 79 | 77 | 50
 |  | Area 7 | 76 | 50 | 64 | 75 | 51
 |  | Area 8 | 64 | 57 | 68 | 75 | 78
 |  | Area 9 | 56 | 69 | 75 | 75 | 61
 |  |  |  |  |  |  |  |  |  |  |  | Everyday, a new column of values will be added to this main data table
 |  | This Summary Section will be used to present the area values each day - it only needs to show that Days Values
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | Enter Day | Day 4
 |  |  | Sector A |  |  |  | Sector B |  |  |  | Sector C
 |  |  | Area 1 | 73 |  |  | Area 5 | 53 |  |  | Area 7 | 75 |  |  |  |  |  | "=formula that return the column [NAME] from Cell T20"
 |  |  | Area 2 | 66 |  |  | Area 6 | 77 |  |  | Area 8 | 75
 |  |  | Area 3 | 50 |  |  |  |  |  |  | Area 9 | 75
 |  |  | Area 4 | 77 |  |  |  |  |  |  |  |  |  |  |  |  |  |  | H
 |  |  |  |  |  | Sector A
 |  |  |  |  |  | Area 1
 |  |  |  |  |  | Area 2
 |  |  |  |  |  | Area 3
 |  |  |  |  |  | Area 4
 |  |  |  | TARGET  Summary Section
 |  |  |  |  | Sector A |  |  |  | Sector B |  |  |  | Sector C
 |  |  |  |  | Area 1 |  |  |  | Area 5 |  |  |  | Area 7
 |  |  |  |  | Area 2 |  |  |  | Area 6 |  |  |  | Area 8
 |  |  |  |  | Area 3 |  |  |  |  |  |  |  | Area 9
 |  |  |  |  | Area 4
Spreadsheet: 77818d1278323560-random-number-from-table-random-test
Sheet: TEST

1 | 2 | 3 | 4 | 5 | 6 | 7 | 8 | 9 | 10
 | 2 |  |  | 5 |  |  |  | 9
 | 2 |  |  | 5 |  |  | 8
 | 2 |  |  |  | 6
 |  |  |  |  | 6 | 7
 |  | 3 |  |  | 6 | 7
 |  | 3 |  |  | 6 | 7
 |  | 3 |  |  |  | 7
 |  |  |  |  |  |  |  |  | 10
1st [NAME]:J9 |  |  | 2nd [NAME]:J9 |  |  | 3rd [NAME]:J9
Spreadsheet: 210972d1359627020-how-can-i-get-the-latest-date-values-book1
Sheet: Sheet1

NAME | Draft1 | Draft2 | Date
ABY | 12 | 23 | 31-DEC-12 10.59.06AM
ABY | 21 | 43 | 24-DEC-12 09.13.06AM
ABY | 35 | 6 | 22-DEC-12 11.43.49AM
ABY | 45 | 76 | 21-DEC-12 12.04.40PM
YAN | 43 | 65 | 21-DEC-12 02.23.58PM
YAN | 46 | 54 | 19-DEC-12 05.42.08PM
YAN | 66 | 11.5 | 17-DEC-12 11.28.58AM
YAN | 13.8 | 66 | 13-DEC-12 08.59.44AM
AN | 6 | 11.5 | 10-DEC-12 02.05.49PM
AN | 33 | 5 | 24-DEC-12 09.28.32AM
CRYSTAL | 55 | 3 | 21-DEC-12 02.28.49PM
CRYSTAL | 5 | 6 | 31-DEC-12 10.59.06AM
CRYSTAL | 3 | 11.5 | 19-DEC-12 05.42.08PM
OUTCOME
NAME | Draft1 | Draft2 | Date
ABY | 12 | 23 | 31-DEC-12 10.59.06AM
YAN | 43 | 65 | 21-DEC-12 02.23.58PM
AN | 33 | 5 | 24-DEC-12 09.28.32AM
CRYSTAL | 5 | 6 | 31-DEC-12 10.59.06AM
Spreadsheet: 39386d1237547441-producing-automatic-reports-with-2-variables-sample
Sheet: Outbound Recording

 | Today |  |  | 2009-03-20 11:09:07 |  |  |  |  |  | Outbound
 | Marketing Conversion Cummulative YTD
 |  |  |  |  | Outcome
 | Source code | Outbound |  | Outcome 1 |  | Outcome 2 |  | Outcome 3 |  | Outcome 4 |  | Outcome 5 |  | Outcome 6 |  | Outcome 7 |  | Outcome 8 |  | Outcome 9 |  | Outcome 10
 |  | No | % | No | % | No | % | No | % | No | % | No | % | No | % | No | % | No | % | No | % | No | %
Spreadsheet: 822008d1679048456-compare-number-list-and-range-number-1-1-ans
Sheet: Sheet1

numbers | matches | num list
1 |  | 1
2 | 2 | 2 |  |  |  |  |  |  |  | D:I helper columns
3 | NotFound | 10 |  |  |  |  |  |  |  | Number of helper columns depend on numbers with "-".
4 | NotFound | 11
5 | NotFound | 12
6 | NotFound | 13
7 | NotFound | 14-15 |  | 15
8 | NotFound | 16
9 | NotFound | 17
10 | 10 | 18-19 |  | 19
11 | 11 | 20-22 |  | 21 | 22
12 | 12 | 31-32 |  | 32
13 | 13 | 35-37 |  | 36 | 37
14 | 14 | 39-41 |  | 40 | 41
15 | 15 | 51
16 | 16 | 53
17 | 17 | 58
18 | 18 | 65
19 | 19 | 69-73 |  | 70 | 71 | 72 | 73
20 | 20 | 75
21 | 21
22 | 22
23 | NotFound
24 | NotFound
25 | NotFound
26 | NotFound
27 | NotFound
28 | NotFound
29 | NotFound
30 | NotFound
31 | 31
32 | 32
33 | NotFound
34 | NotFound
35 | 35
36 | 36
37 | 37
38 | NotFound
39 | 39
40 | 40
41 | 41
42 | NotFound
43 | NotFound
44 | NotFound
45 | NotFound
46 | NotFound
47 | NotFound
48 | NotFound
49 | NotFound
50 | NotFound
51 | 51
52 | NotFound
53 | 53
54 | NotFound
55 | NotFound
56 | NotFound
57 | NotFound
58 | 58
59 | NotFound
60 | NotFound
61 | NotFound
62 | NotFound
63 | NotFound
64 | NotFound
65 | 65
66 | NotFound
67 | NotFound
68 | NotFound
69 | 69
70 | 70
71 | 71
72 | 72
73 | 73
74 | NotFound
75 | 75
Spreadsheet: 866571d1713480260-automatic-fill-up-essaie-date-perpetuel-pas-de-developpeur-eba
Sheet: Calendrier

 | [NAME]
Annee | 2024
Mois | [NAME]
Chalet | Chalet 3
 |  | 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
 | Chalet 1
 | Chalet 2
 | Chalet 3
 | Chalet 4
 | Chalet 5
 | Chalet 6
 | Chalet 7
 | Chalet 8
 | Chalet 9
 | Chalet 10
 | Chalet 11
 | Chalet 20
Spreadsheet: 58137d1258460700-adding-an-extra-condition-to-an-if-statement-if-statement-example
Sheet: Sheet1

 | Party ID | Name | DoB | Age | Start date | End date | Sessions Per Week | Total Cost Per Week | Number Weeks | Weekly Payments Gone | Weekly Payments to Go | Remain | Total Costs  For Year |  |  | Agreed Date | Review Date | Total Weeks | Projected Cost | YTD Weeks | YTD Cost
 | 2222 | Hughes | 1980-11-17 00:00:00 | 29 | 2009-04-01 00:00:00 | 2009-06-06 00:00:00 | 10 | 100 |  |  |  |  |  |  |  | 2008-05-15 00:00:00 | 2009-06-05 00:00:00 | 9.428571428571429 | 942.8571428571429 | 9.428571428571429 | 942.8571428571429
 | 2223 | [NAME] | 1981-11-18 00:00:00 | 28 | 2009-04-01 00:00:00 | 2009-11-20 00:00:00 | 10 | 100 |  |  |  |  |  |  |  | 2008-05-15 00:00:00 | 2008-06-05 00:00:00 | 33.28571428571428 | 3328.571428571428 | 32.85714285714285 | 3285.714285714285
 | 2224 | Wrathall | 1970-04-01 00:00:00 | 39 | 2009-04-01 00:00:00 | 2010-02-28 00:00:00 | 10 | 100 |  |  |  |  |  |  |  | 2008-05-15 00:00:00 | 2010-01-01 00:00:00 | 47.57142857142857 | 4757.142857142857 | 32.85714285714285 | 3285.714285714285
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  | U= | IF(SUM(TODAY()>C8),(C8-MAX(B8,M8))/7,SUM(TODAY()-MAX(B8,M8))/7)
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | How do I write in another condition that says if End Date in G is greater than Review Date in Q then
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | take the existing formula result and and subtract that from Q rather than G
Spreadsheet: darron_c_giron__8010__EMW0831a
Sheet: P&L

Enron Midwest P&L With Sharing
 |  |  |  | NSS1 |  | NSS2 |  | MEH |  | TP-NSS |  | EMW Total
CURRENT BOOK VALUE
 | Physical
 |  | Physical
 |  | Other |  | 0 |  | 0 |  | 0 |  | 0
 |  | Prompt
 |  | Reversal
 |  | TOTAL
 | Financial
 |  | Price Swaps
 |  | Options
 |  | Basis
 |  | Index
 |  | Gas Daily
 |  | Gas Daily Options
 |  | Broker Fees
 |  | TOTAL
 | Omicron
 |  | Physical |  | 0 |  | 0 |  | 0 |  | 0
 |  | Financial |  | 0 |  | 0 |  | 0 |  | 0
 |  | TOTAL
 | Transport - Accrued
 |  | Revenue (Gas Daily Spreads)
 |  | Commodity Expense
 |  | Fuel Expense
 |  | 3rd Party Demand Charges |  | 0 |  | 0 |  | 0 |  | 0
 |  | 3rd Party Demand Reimbursements |  | 0 |  | 0 |  | 0 |  | 0
 |  | Transport Book Demand Charges |  | 0 |  | 0 |  | 0 |  | 0
 |  | Transport Book Demand Reimbursements |  | 0 |  | 0 |  | 0 |  | 0
 |  | TOTAL
 | Transport - MTM
 |  | Revenue (Gas Daily Spreads)
 |  | Commodity Expense
 |  | Fuel Expense
 |  | 3rd Party Demand Charges |  | 0 |  | 0 |  | 0 |  | 0
 |  | 3rd Party Demand Reimbursements |  | 0 |  | 0 |  | 0 |  | 0
 |  | Transport Book Demand Charges |  | 0 |  | 0 |  | 0 |  | 0
 |  | Transport Book Demand Reimbursements |  | 0 |  | 0 |  | 0 |  | 0
 |  | TOTAL
 | Other
 |  | People's Share of P&L
 |  | Origination
 |  | Flash to Actual |  | 0 |  | 0 |  | 0 |  | 0
 |  | Origination's Share of P&L
 |  | TOTAL
NET CURRENT MONTH P&L
DAILY CHANGE
 | Physical
 |  | Physical
 |  | Other
 |  | Prompt
 |  | Reversal
 |  | TOTAL
 | Financial
 |  | Price Swaps
 |  | Options
 |  | Basis
 |  | Index
 |  | Gas Daily
 |  | Gas Daily Options
 |  | Broker Fees
 |  | TOTAL
 | Omicron
 |  | Physical
 |  | Financial
 |  | TOTAL
 | Transport - Accrued
 |  | Revenue (Gas Daily Spreads)
 |  | Commodity Expense
 |  | Fuel Expense
 |  | 3rd Party Demand Charges
 |  | 3rd Party Demand Reimbursements
 |  | Transport Book Demand Charges
 |  | Transport Book Demand Reimbursements
 |  | TOTAL
 | Transport - MTM
 |  | Revenue (Gas Daily Spreads)
 |  | Commodity Expense
 |  | Fuel Expense
 |  | 3rd Party Demand Charges
 |  | 3rd Party Demand Reimbursements
 |  | Transport Book Demand Charges
 |  | Transport Book Demand Reimbursements
 |  | TOTAL
 | Other
 |  | People's Share of P&L
 |  | Origination
 |  | Flash to Actual
 |  | Origination's Share of P&L
 |  | TOTAL
NET DAILY CHANGE P&L
MONTH TO DATE
YEAR TO DATE
 |  |  |  | NSS1 |  | NSS2 |  | MEH |  | TP-NSS |  | EMW Total
 |  | Physical:
 |  | Curve Shift
 |  | New Deals
 |  | Changed Deals
 |  | Trans. Reversal
 |  | Liquidated Day
 |  | New Financial Deals:
 |  | Price
 |  | Basis
 |  | Index
 |  | Gas Daily
Spreadsheet: 117693d1312971656-finding-a-ratio-by-shift-variation_calc
Sheet: Sheet1

1st Shift
 | 109-1 | 109-2 | 109-3 | 109-4 | 110-1 | 110-2 | 110-3 | 110-4
2nd Shift
 | 109-1 | 109-2 | 109-3 | 109-4 | 110-1 | 110-2 | 110-3 | 110-4
3rd Shift
 | 109-1 | 109-2 | 109-3 | 109-4 | 110-1 | 110-2 | 110-3 | 110-4
Spreadsheet: 115557d1311117374-copying-tables-daily-scratch-its-week-1-copy
Sheet: Pending Scratch-Its

Game | Price | Description | Book | Date | Initial | Value | Tickets | On [NAME]?
591 | 1 | Sweet Treats | 8225 |  |  | 250
579 | 2 | [NAME] Notes | 12468 | 2011-07-15 00:00:00 | PH | 200
584 | 2 | Black Jack | 15645 |  |  | 200
491 | 3 | Line Em Up | 10255 |  |  | 300
596 | 4 | Treasure Hunter | 6727 |  |  | 200
595 | 5 | X-Men First Class | 11026 |  |  | 250
908 | 5 | Cross Words | 118850 |  |  | 250
581 | 10 | Mega Money | 12921 |  |  | 300
576 | 1 | Happy Cash | 5651 | 2011-07-11 00:00:00 | JH | 250
584 | 2 | Black Jack | 15032 | 2011-07-11 00:00:00 | JH | 200
491 | 3 | Line em Up | 9231 | 2011-07-11 00:00:00 | JH | 300
569 | 4 | surf break | 12699 | 2011-07-11 00:00:00 | JH | 200
582 | 5 | black pearl | 11420 | 2011-07-11 00:00:00 | JH | 250
908 | 5 | Cross Words | 104438 | 2011-07-11 00:00:00 | JH | 250
585 | 15 | Black Edition | 54289 | 2011-07-11 00:00:00 | JH | 450
908 | 5 | Cross Words | 118851 | 2011-07-14 00:00:00 | JH | 250
Spreadsheet: 5d49a885-9dab-4965-aa49-a1df8da3d9e3
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
FVITB | Test | FVITB | [NAME] | [NAME] | Quantitative Radioimmunoassay |  |  |  | 1 | mL | Draw blood in a serum gel tube(s).  Spin down and send 1 mL of serum frozen in an amber vial (T192) protected from light. | 0.1 mL | Hemolysis	Mild OK; Gross reject Thawing	Warm reject; Cold OK Lipemia	NA Icterus	NA Other	NA | 800-2600 pg/mL   Test Information: [NAME] This assay measures the unsaturated binding capacity of serum for [NAME].   Test Performed By:  ARUP Laboratories                               500 [NAME]                               Salt Lake City, UT  84108 | Monday, Thursday | 1-5 days | 3-9 days | 1 | 82608 |  |  |  |  | ARUP Laboratories
FVITB | [NAME] | SERUM | Serum |  |  |  | Frozen | 30 days
FVITB | Result | Z2657 | [NAME] | [NAME] | Alphanumeric |  |  |  |  |  |  |  |  |  |  |  |  |  |  | In Process
Spreadsheet: 738550d1625110543-lookup-from-a-table-based-on-given-criteria-derive-the-respective-percentage-from-table
Sheet: Sheet1

 | Contract Price (M) | Area | Value
 | 21 | Urban
 | Contract Price | Rural |  | Urban
 |  | Low | High | Low | High
 | 0 to 50M | 0.02 | 0.04 | 0.04 | 0.06
 | 50M to 100M | 0.02 | 0.03 | 0.03 | 0.03
 | Over 100M | 0.01 | 0.02 | 0.02 | 0.02
Spreadsheet: 808343d1670423274-conditional-format-based-on-data-in-one-cell-column-unless-another-column-cell-has-data-call-record-etaf
Sheet: Sheet1

Date email sent | Time Sent | Due Date | Must Call | Date Called
2022-11-28 00:00:00 | 17:22:00 |  |  | 2022-12-02 00:00:00 |  |  |  | Many thanks for the reply. I have attached (I hope) as small example. I am trying to get Column D to show CALL based on the dates in Column A UNLESS Column E has an entry, in which case it should be blank
2022-11-28 00:00:00 | 17:23:00 |  |  | 2022-12-02 00:00:00
2022-12-02 00:00:00 | 09:23:00
2022-12-02 00:00:00 | 09:24:00
2022-12-02 00:00:00 | 09:25:00
2022-01-02 00:00:00 | 10:00:00
2022-12-02 00:00:00
2022-11-28 00:00:00 | 17:26:00 |  |  | 2022-12-02 00:00:00
2022-11-28 00:00:00 | 17:27:00 |  |  | 2022-12-02 00:00:00
2022-11-28 00:00:00 | 17:29:00 |  |  | 2022-12-02 00:00:00
2022-11-28 00:00:00 | 17:31:00 |  |  | 2022-12-02 00:00:00
2022-01-06 00:00:00 | 15:33:00