tianzl66/Sheetpedia huggingface dataset:
Spreadsheet: 270862d1381723326-need-help-with-median-formula-based-on-a-set-criteria-dummy-workbook-median-formula-
Sheet: Data

Event Id | OpData Id | Organization Name | Organization Geography | Firm Name | Business Unit Type | Loss Amount | Current Loss Amount | Loss Type | Start Occurrence | End Occurrence | Settlement Date | Created Date | Status | Description
12888 |  | ABC Pty Ltd | Australia |  |  | 10000 |  |  | 2013-01-01 00:00:00 |  |  |  | Open | Testing 1, 2, 3
12793 |  | JKF Pty Ltd | Australia |  |  | 10201 |  |  | 2012-08-14 00:00:00 |  |  |  | Open | An instance whereby……….
12749 |  | XYZ Pty Ltd | Japan |  |  | 165946 |  |  | 2012-07-07 00:00:00 |  |  |  | Open | XYZ Pty Ltd recently identified…….
12618 |  |  | Japan |  |  | 156664 |  |  |  |  |  |  | Closed
12527 |  |  | New Zealand |  |  | 150685 |  |  |  |  |  |  | Open
12525 |  |  | New Zealand |  |  | 165864 |  |  |  |  |  |  | Open
12447 |  |  | Australia |  |  | 6315 |  |  |  |  |  |  | Open
12380 |  |  | Fiji |  |  | 166462 |  |  |  |  |  |  | Closed
12362 |  |  | Canada |  |  | 5456 |  |  |  |  |  |  | Open
12298 |  |  | Australia |  |  | 86562 |  |  |  |  |  |  | Closed
12265 |  |  | New Zealand |  |  | 13588 |  |  |  |  |  |  | Open
12260 |  |  | Japan |  |  | 13523 |  |  |  |  |  |  | Closed
12244 |  |  | Singapore |  |  | 131656 |  |  |  |  |  |  | Open
12218 |  |  | Australia |  |  | 5186 |  |  |  |  |  |  | Closed
12215 |  |  | Malaysia |  |  | 61338 |  |  |  |  |  |  | Open
12142 |  |  | Singapore |  |  | 61356 |  |  |  |  |  |  | Closed
12135 |  |  | Australia |  |  |  |  |  |  |  |  |  | Open
12117 |  |  | Australia |  |  | 10000 |  |  |  |  |  |  | Open
Spreadsheet: 835011d1688226123-getting-data-from-another-cell-sample_data-1-
Sheet: Sheet1

product | sector_name_Eurostat | value | type |  |  | HS2 | sector name | store* | sold*
1 | a | 93309.5859375 | store |  |  |  | a | 93309.5859375 | 2333017
1 | a | 2333017 | sold |  |  | 2 | b | 5727581 | 1362215.75
2 | b | 5727581 | store |  |  | 3 | c | 103031.53125 | 21325.849609375
2 | b | 1362215.75 | sold |  |  | 4 | d | 5031.3701171875 | 13443.16015625
3 | c | 103031.53125 | store |  |  | 5 | e | 9578.8203125 | 13868.4501953125
3 | c | 21325.849609375 | sold
4 | d | 5031.3701171875 | store
4 | d | 13443.16015625 | sold
5 | e | 9578.8203125 | store
5 | e | 13868.4501953125 | sold
Spreadsheet: john_hodge__16419__Enron - June 2001
Sheet: Sheet1

Supplier:  [NAME] [PHONE]
Pipeline:  Dominion Transmission
Delivery Point:  Dominion Southpoint
Date of Deal:  Daily Deals
Day | Vol. | Price | Total
2001-06-01 00:00:00 | 2047 | 3.92
 | 2047 | 3.92
 | 2047 | 3.92
 | 2047 | 3.92
 | 2047 | 4.18
 | 2047 | 4.11
 | 1637 | 4
 | 1637 | 4
 | 1637 | 4
 | 1637 | 4
 | 1637 | 4
 | 1637 | 4
 | 1637 | 4
 | 1637 | 4
 | 1637 | 4
 | 1637 | 4
 | 1637 | 4
 | 1637 | 4
 | 1637 | 4
 | 1637 | 4
 | 1637 | 4
 | 1637 | 4
 | 1637 | 4
 | 1637 | 4
 | 1637 | 4
 | 1637 | 4
 | 1637 | 4
 | 1637 | 4
 | 1637 | 4
 | 1637 | 4
Total Purchase Amount:
Spreadsheet: 721871d1614912648-formula-to-index-and-match-off-multiple-criteria-then-return-data-excel-forum-2021-03-03-a
Sheet: Sheet2

Name | Last 3 SSN | PSN | Unit | Address | City | State | Zip
K   VANG | 007 | [PHONE]-906 |  | 4836 E Main AVE | FRESNO | CA | 93727
F   HAMMOUDEH | 011 | [PHONE]-001 |  | 3447 N Main ST | VISALIA | CA | 93291
L N ARAIM | 021 | [PHONE]-001 |  | 1785 E Main AVE | FRESNO | CA | 93720
M A LOERA | 024 | [PHONE]-906 |  | 4136 W Main AVE | FRESNO | CA | 93722
A D VAWTER | 024 | [PHONE]-906 |  | 43271 Main DR | THREE RIVERS | CA | 93271
D A ISOM | 024 | [PHONE]-911 |  | 144 Main DR | PASO ROBLES | CA | 93446
L E PARRA PLASECIA | 032 | [PHONE]-906 |  | 5469 N Main AVE #238 | FRESNO | CA | 93710
B L HUGHES | 032 | [PHONE]-001 |  | 1426 N Main AVE | CLOVIS | CA | 93619
J   LOPEZ RODRIGUEZ | 034 | [PHONE]-001 |  | 785 Main LANE | PATTERSON | CA | 95363
A L DEFENSOR | 002 | [PHONE]-003 |  | 2771 Main RD | SAN JOSE | CA | 95133
Spreadsheet: 69374d1269917819-proportionate-weightings-prorata-weights-1-
Sheet: Sheet1

 | Weightings
Metrics | 50/50 | Proportionate
Call Quality Internal & External | 16 | 16
Attendance | 10 | 10
[NAME] | 18 | 18
Process Compliance | 12 | 12
PTP Realisation | 6
Cash collection | 14
OB THT | 12
IB CHT | 12
Total | 100
 | Hours | % in each | Divisor
Outbound | 6
Inbound | 4
If Outbound hours are 0, then cells C7 C8 and C9 must equal 0 and C10 must equal 44
If Inbound hours are 0, then cell 10 must equal 0 and cells C7 C8 and C9 must equal 44
Where inbound/outbound hours are equal, cells C7 through C8 must match their respective values in column B
Spreadsheet: 795461d1662709348-monthly-sums-from-different-workbooks-d3-problem
Sheet: Sheet1

2022-08-01 00:00:00 |  | non array | array
 |  | is working | not working
2022-07-15 00:00:00 | 10
2022-07-16 00:00:00 | 11 |  | answer
2022-07-17 00:00:00 | 12 |  | should
2022-07-18 00:00:00 | 13 |  | be
2022-07-19 00:00:00 | 14
2022-07-20 00:00:00 | 15
2022-07-21 00:00:00 | 16
2022-07-22 00:00:00 | 17
2022-07-23 00:00:00 | 18
2022-07-24 00:00:00 | 19
2022-07-25 00:00:00 | 20
2022-07-26 00:00:00 | 21
2022-07-27 00:00:00 | 22
2022-07-28 00:00:00 | 23
2022-07-29 00:00:00 | 24
2022-07-30 00:00:00 | 25
2022-07-31 00:00:00 | 26
2022-08-01 00:00:00 | 27
2022-08-02 00:00:00 | 28
2022-08-03 00:00:00 | 29
2022-08-04 00:00:00 | 30
2022-08-05 00:00:00 | 31
2022-08-06 00:00:00 | 32
2022-08-07 00:00:00 | 33
2022-08-08 00:00:00 | 34
2022-08-09 00:00:00 | 35
2022-08-10 00:00:00 | 36
2022-08-11 00:00:00 | 37
2022-08-12 00:00:00 | 38
2022-08-13 00:00:00 | 39
2022-08-14 00:00:00 | 40
2022-08-15 00:00:00 | 41
2022-08-16 00:00:00 | 42
2022-08-17 00:00:00 | 43
2022-08-18 00:00:00 | 44
2022-08-19 00:00:00 | 45
2022-08-20 00:00:00 | 46
2022-08-21 00:00:00 | 47
2022-08-22 00:00:00 | 48
2022-08-23 00:00:00 | 49
2022-08-24 00:00:00 | 50
2022-08-25 00:00:00 | 51
2022-08-26 00:00:00 | 52
2022-08-27 00:00:00 | 53
2022-08-28 00:00:00 | 54
2022-08-29 00:00:00 | 55
2022-08-30 00:00:00 | 56
2022-08-31 00:00:00 | 57
2022-09-01 00:00:00 | 58
2022-09-02 00:00:00 | 59
Spreadsheet: 56560d1256740671-deleting-symbols-find-text-box-in-excel
Sheet: Statemt of Compl

STATE OF CALIFORNIA      DEPARTMENT OF TRANSPORTATION
STATEMENT OF COMPLIANCE
CP-CEM-2503   (OLD HC-348 REV 8/96)
CONTRACTOR OR SUBCONTRACTOR |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | CONTRACT NUMBER
Southwest Construction Co., Inc. |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | San Clemente Island Torpedo Facility Contract # 68711-99-C-0000
FIRST DAY AND DATE OF PAY PERIOD |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | LAST DAY AND DATE OF PAY PERIOD
2009-09-27 00:00:00 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 2009-10-03 00:00:00
 | I do hereby certify under penalty of perjury:
(1) | That I pay or supervise payment to employees of the above-referenced contractor on the above-referenced contract.  All persons employed on said project for the above-referenced time period have been paid their full weekly wages earned, that no rebates hav
(3) | That any apprentices employed in the above period are duly registered in a bona fide apprenticeship program registered with a State apprenticeship agency.
(4) | That fringe benefits as listed in the contract:
 |  | (a) |  |  | Have been or will be paid to the approved plan(s), funds(s), or program(s) for the benefit of listed employee(s), except as noted below.
 |  | (b) |  |  | Have been paid directly to the listed employee(s), except as noted below.
 |  | (c) |  |  | See exceptions noted below.
[NAME] (CRAFT) |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | EXPLANATION
ALL CRAFTS/SKILLS |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | Pension Benefits are paid to an IRS-approved fund and deposited into individual employees' accounts at The Hartford Retirement Services after one full year of employment.  Prior to one year of service, Pension Benefits are paid in cash.
Remarks:
NAME (PLEASE PRINT) |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | TITLE
[NAME] |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | Operations Manager
SIGNATURE |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | DATE
On federally-funded projects, permissible deductions are defined in Regulations, Part 3 (29 CFR, [NAME]), issued by the Secretary of Labor under the Copelend Act, as amended (48 Stat. 948 Stat. 108, 72 Stat. 967;76 Stat 357:40 U.S.C. 276c).
Also, the willful falsification of any of the above statements may subject the contractor or subcontractor to civil or criminal prosecution (See Section 1001 of Title 18 and Section 231 of Title 31 of the United States Code).
Spreadsheet: 36525d1234386052-condtional-vlookup-small-if-accounts
Sheet: Data

account | account(1) | value
111111 | [NAME] | 123456
111111 | a2 | 32156
111111 | c5 | 31221
111111 | e7 | 1121312
222222 | [NAME] | 5464
222222 | c1 | 887895
333333 | d4 | 45454646
Spreadsheet: 63140d1264088442-freight-calculator-freight-20calculator-20request-1-
Sheet: Sheet1

 | Destination Country | Destination post Code |  | Weight
 |  | from | to | 50 | 100 | 200 | 300 | 400 | 500
 | Austria | 1000 | 1999 | 20 | 33 | 66 | 55 | 66 | 77
 | Austria | 2000 | 2900 | 20 | 33 | 44 | 55 | 66 | 77
 | Austria | 3000 | 3900 | 20 | 33 | 44 | 55 | 66 | 77
 | Austria | 4000 | 4900 | 35 | 33 | 44 | 55 | 66 | 77
 | Austria | 5000 | 5400 | 35 | 34.6 | 44 | 55 | 66 | 77
 | Austria | 5500 | 5700 | 37.16 | 34.6 | 44 | 55 | 66 | 77
 | Belgium | 1000 | 1999 | 29 | 32 | 44 | 55 | 66 | 77
 | Belgium | 2000 | 2999 | 30 | 33 | 44 | 55 | 66 | 77
 | Belgium | 3000 | 3999 | 40.5 | 45 | 44 | 55 | 66 | 77
 | Belgium | 4000 | 4999 | 40.5 | 45 | 44 | 55 | 66 | 77
 | Country | From | to | Weight | Price
 | [NAME] | 1000 | 1999 | 200
Spreadsheet: 216613d1361823613-need-a-formula-to-calculate-stats-for-multiple-classes-classtype
Sheet: Sheet1

Zone | ID | CLASS VALUE | COUNT
0 | 0 | 0 | 650 |  |  | 0 | 1 | 2 | 3 | 4 | 5
0 | 1 | 1 | 27885 |  | 0
0 | 2 | 2 | 1341 |  | 1
0 | 3 | 3 | 5 |  | 2
0 | 4 | 4 | 47 |  | 3
0 | 5 | 5 | 1 |  | 4
1 | 6 | 0 | 1746 |  | 5
1 | 7 | 1 | 27289 |  | 6
1 | 8 | 2 | 848 |  | 7
1 | 9 | 3 | 4 |  | 8
1 | 10 | 5 | 42 |  | 9
2 | 11 | 0 | 465 |  | 10
2 | 12 | 1 | 25904 |  | 11
2 | 13 | 2 | 2038 |  | 12
2 | 14 | 3 | 20 |  | 13
2 | 15 | 4 | 8
2 | 16 | 5 | 1494
3 | 17 | 0 | 2534
3 | 18 | 1 | 22535
3 | 19 | 2 | 2037
3 | 20 | 3 | 12
3 | 21 | 5 | 2984
4 | 22 | 1 | 17876
4 | 23 | 2 | 11389
4 | 24 | 3 | 555
4 | 25 | 5 | 109
5 | 26 | 1 | 19542
5 | 27 | 2 | 10032
5 | 28 | 3 | 337
5 | 29 | 5 | 18
6 | 30 | 0 | 17
6 | 31 | 1 | 27392
6 | 32 | 2 | 2489
6 | 33 | 3 | 19
6 | 34 | 5 | 12
7 | 35 | 1 | 28876
7 | 36 | 2 | 541
7 | 37 | 3 | 10
7 | 38 | 4 | 12
7 | 39 | 5 | 490
8 | 40 | 0 | 3629
8 | 41 | 1 | 24763
8 | 42 | 2 | 1378
8 | 43 | 3 | 43
8 | 44 | 4 | 2
8 | 45 | 5 | 114
9 | 46 | 0 | 367
9 | 47 | 1 | 28304
9 | 48 | 2 | 1297
9 | 49 | 3 | 7
9 | 50 | 4 | 1
9 | 51 | 5 | 126
10 | 52 | 1 | 28990
10 | 53 | 2 | 525
10 | 54 | 3 | 1
10 | 55 | 5 | 413
11 | 56 | 1 | 28310
11 | 57 | 2 | 1154
11 | 58 | 3 | 203
11 | 59 | 4 | 3
11 | 60 | 5 | 259
12 | 61 | 1 | 28440
12 | 62 | 2 | 1628
12 | 63 | 3 | 170
12 | 64 | 5 | 38
13 | 65 | 1 | 22575
13 | 66 | 2 | 510
13 | 67 | 3 | 102
13 | 68 | 5 | 6915
14 | 69 | 1 | 29413
14 | 70 | 2 | 621
14 | 71 | 3 | 185
14 | 72 | 5 | 57
15 | 73 | 1 | 28328
15 | 74 | 2 | 368
15 | 75 | 3 | 721
15 | 76 | 5 | 685
16 | 77 | 1 | 11534
16 | 78 | 2 | 15701
16 | 79 | 3 | 234
16 | 80 | 5 | 2807
17 | 81 | 1 | 16056
17 | 82 | 2 | 9310
17 | 83 | 3 | 57
17 | 84 | 5 | 4853
18 | 85 | 1 | 11511
18 | 86 | 2 | 4121
18 | 87 | 3 | 468
18 | 88 | 5 | 14002
19 | 89 | 0 | 1715
19 | 90 | 1 | 19804
19 | 91 | 2 | 8241
19 | 92 | 3 | 341
19 | 93 | 5 | 1
20 | 94 | 0 | 146
20 | 95 | 1 | 24575
20 | 96 | 2 | 4358
20 | 97 | 3 | 823
20 | 98 | 5 | 200
Spreadsheet: 273367d1382694530-rearranging-datewise-horizontally-in-a-specified-format-from-raw-data-vat1_sr_rev
Sheet: Result

Date | Name of Party | Particulars | Vch No. | Reference No. | Taxable Purchase | Taxable Import | [NAME] | [NAME] in Custom | Excise Duty | Total | TDS
Spreadsheet: 116430d1311830147-excel-2007-counting-with-criteria-problem-example
Sheet: International

Time | Date | Status | Subfleet Type
14:05:00 | 2011-07-27 00:00:00 | Arrived | 763
14:18:00 | 2011-07-27 00:00:00 | Arrived | 319
14:56:00 | 2011-07-27 00:00:00 | Arrived | 77W
14:57:00 | 2011-07-27 00:00:00 | Arrived | 763
15:00:00 | 2011-07-27 00:00:00 | Arrived | 319
15:28:00 | 2011-07-27 00:00:00 | Arrived | 77W
15:36:00 | 2011-07-27 00:00:00 | Arrived | 763
15:54:00 | 2011-07-27 00:00:00 | Arrived | 319
16:20:00 | 2011-07-27 00:00:00 | OnTime | 763
16:28:00 | 2011-07-27 00:00:00 | Arrived | 763
16:32:00 | 2011-07-27 00:00:00 | Arrived | 343
16:59:00 | 2011-07-27 00:00:00 | Arrived | 77W
17:08:00 | 2011-07-27 00:00:00 | Arrived | 333
17:38:00 | 2011-07-27 00:00:00 | Arrived | 763
18:04:00 | 2011-07-27 00:00:00 | Arrived | 77L
18:07:00 | 2011-07-27 00:00:00 | Arrived | 763
18:16:00 | 2011-07-27 00:00:00 | Arrived | 333
18:29:00 | 2011-07-27 00:00:00 | Arrived | 319
18:32:00 | 2011-07-27 00:00:00 | Arrived | 77W
19:00:00 | 2011-07-27 00:00:00 | Arrived | 77L
Time | Date | Status | Subfleet Type
19:01:00 | 2011-07-27 00:00:00 | Arrived | 319
19:09:00 | 2011-07-27 00:00:00 | Arrived | 763
19:15:00 | 2011-07-27 00:00:00 | Arrived | 319
19:56:00 | 2011-07-27 00:00:00 | Arrived | 333
20:33:00 | 2011-07-27 00:00:00 | Arrived | 319
21:01:00 | 2011-07-27 00:00:00 | Arrived | 319
Spreadsheet: tracy_geaccone__40323__3rd quarter curr est
Sheet: QtrComp_vs_Plan

2001 IBIT- Plan vs CE COMPARISON
(Millions of Dollars)
 |  | First Quarter |  |  |  |  |  | Second Quarter |  |  |  |  |  | Third Quarter |  |  |  |  |  | Fourth Quarter |  |  |  |  |  | Total Year
 |  | 2001 |  | 2001 |  |  |  | 2001 |  | 2001 |  |  |  | 2001 |  | 2001 |  |  |  | 2001 |  | 2001 |  |  |  | 2001 |  | 2001
 |  | Plan |  | Act. |  | Var |  | Plan |  | Act. |  | Var |  | Plan |  | For. |  | Var |  | Plan |  | For. |  | Var |  | Plan |  | For. |  | Var
x |  | 0 |  | 0 |  |  |  | 0 |  | 0 |  |  |  | 0 |  | 0 |  |  |  | 0 |  | 0
x | Portland General Electric | 61.30603705927771 |  | 70.2 |  |  |  | 64.50335570813922 |  | 73.4 |  |  |  | 22.9 |  | -5.1 |  |  |  | 83 |  | 90
x | Other PGG | -4.8 |  | -10.3 |  |  |  | -8.2 |  | -8.5 |  |  |  |  |  | 2.4 |  |  |  |  |  | -17
x |  | 0 |  | 0 |  |  |  | 0 |  | 0 |  |  |  | 0 |  | 0 |  |  |  | 0 |  | 0
x |  | 0 |  | 0 |  |  |  | 0 |  | 0 |  |  |  | 0 |  | 0 |  |  |  | 0 |  | 0
 | Other | 0 |  | 0 | 0 |  |  | 0 |  | 0 |  |  |  | 0 |  | 0 |  |  |  | 0 |  | 0
Income Before Interest and Taxes
Comments:
Q1-01 Plan vs. Forecast
Includes reserves for California receivables of $8.4 mm, offset by improved gross margin.
Q2-01 Plan vs. Forecast
Includes reserves for California receivables of $5.0 mm, offset by improved gross margin.
Q3-01 Plan vs. Forecast
Gross Margin, decline in market prices. Q3 also includes several accounting changes and rate case implementation issues that are currently being reviewed by AA&Co.
Note: Q2 plan adjusted for GATX fee of ($3.4) mm. Q3 and Q4 plan adjusted by $5.2 mm for goodwill transfer to ENA. Q3 and Q4 forecast also includes $5.2 million for
 | goodwill transfer to ENA. ENA forecast should include offsetting increase.
Spreadsheet: 58994d1259316218-changing-a-set-set-of-cells-by-a-date-cell-date-changes
Sheet: Sheet 2

 |  | week 1 | week 2 | week 3 | week 4 | week 5 | week 6 | week 7 | week 8 | week 9 | week 10 | week 11 | week 12 | week 13 | week 14 | week 15 | week 16 | week 17 | week 18 | week 19 | week 20 | week 21 | week 22 | week 23 | week 24 | week 25 | week 26 | week 27 | week 28 | total
 |  |  |  |  | from c5 to S14 but S14 can change each year according to date each year in row 2
 |  |  |  |  | then in T5 to AD14 which the T5 as well as AD14 can change each year as well
 |  |  |  |  | I have used COUNTA(Events!C5:S14) which works for one year but if dates change automatic  I need S5 and T5 and AD14 to change automatic as well
Spreadsheet: 177292d1346254498-formula-to-copy-from-one-column-to-another-and-exclude-duplicates-test2010
Sheet: TEST

FORMULAS | UNIQUES
[NAME] | [NAME]
NOW | NOW
[NAME] | [NAME]
NOW | tom
NOW | ACOSH
NOW | ASIN
[NAME] | ASINH
NOW | ROUNDUP
NOW | ASC
tom | SKEW
NOW | ABS
NOW | ENABLE.TOOL
NOW | ADD.BAR
ACOSH | ADD.TOOLBAR
ASIN | DELETE.TOOLBAR
ASINH
ASINH
ASINH
ASINH
ASINH
ASINH
ASINH
ASINH
ASINH
ROUNDUP
ASC
SKEW
ABS
ENABLE.TOOL
ADD.BAR
ADD.TOOLBAR
DELETE.TOOLBAR
Spreadsheet: 860480d1708561080-i-need-help-for-the-formula-time-sheet-tms
Sheet: TIME SHEET

 |  |  |  | START DATE | END DATE | PAY DATE |  |  | EMPLOYEE NAME
 |  |  |  | 2024-02-05 00:00:00
Testing
 | MON | TUE | WED | THU | FRI | SAT | SUN | MON | TUE | WED | THU | FRI | SAT | SUN
 | 2024-02-05 00:00:00
TIME ON | 10:00:00 | 10:00:00 | 09:00:00 | 09:00:00 | 09:00:00 | 09:00:00 |  |  | 09:00:00 | 09:00:00 | 09:00:00 | 09:00:00 | 09:00:00 | 09:00:00
TIME OFF | 14:00:00 | 18:00:00 | 18:00:00 | 18:00:00 | 18:00:00 | 18:00:00 |  |  | 18:00:00 | 18:00:00 | 18:00:00 | 18:00:00 | 18:00:00 | 18:00:00
TIME ON | 14:00:00
TIME OFF | 18:00:00
OT ON | 18:00:00 |  |  |  | 18:00:00
OT OFF | 22:00:00 |  |  |  | 22:00:00
DBL ON | 22:00:00 |  |  | 22:00:00
DBL OFF | 23:30:00 |  |  | 23:30:00
HOL ON |  | 10:00:00 | 10:00:00 |  |  |  | 09:00:00 | 09:00:00
HOL OFF |  | 18:00:00 | 18:00:00 |  |  |  | 18:00:00 | 18:00:00
PTO ON |  |  |  | 10:00:00
PTO OFF |  |  |  | 18:00:00
REG TIME |  | OT TIME |  | DBL TIME |  | HOL TIME |  | PTO |  | TOTAL HOURS |  | NOTES
Spreadsheet: 385ad3a6-e308-42e3-83b0-e96df4e104f8
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
43565435 | 2014-10-13 17:21:39 | ALLIES | 1 | 6 | 3 | 603439 | MickeyScott01 | 12498 | western | 1944-07-11 |  | [Normandy] Bretel Wood | [NAME]
43577836 | 2014-10-14 13:54:31 | ALLIES | 1 | 6 | 5 | 1651852 | player1651852 | 12498 | western | 1944-07-11 |  | [Normandy] Bretel Wood | [NAME]
43622625 | 2014-10-17 21:22:47 | ALLIES | 1 | 6 | 2 | 418671 | anejauneetbleu | 9579 | western | 1944-07-18 | 1944-07-20 | Operation Goodwood | Opération Goodwood
43623040 | 2014-10-17 21:45:52 | AXIS | 1 | 6 | 3 | 418671 | anejauneetbleu | 9579 | western | 1944-07-18 | 1944-07-20 | Operation Goodwood | Opération Goodwood
Spreadsheet: 889910d1740940438-power-query-how-to-keep-mixed-formats-in-same-column-forum_pq_try
Sheet: Table 1

Laufzeit in Jahren | Ganze_Periode
1 | 2.18
2 | 4.14
3 | 6.24
4 | 8.44
5 | 10.75
6 | 13.08
7 | 15.47
8 | 18
9 | 20.52
10 | 23.1
11 | 25.85
12 | 28.44
13 | 31.2
14 | 33.88
15 | 36.45
20 | 48.4
25 | 58.75
30 | 68.39999999999999
Swap-Mitte-Sätze per: | 28.02.2025
Fertiggestellt um: | 11:25
Konventionen: | jährlich, 30/360 gegen 3-Monats Euribor
Datengrundlage: | Die Swap-Mitte-Sätze wurden auf [NAME] produziert.
Spreadsheet: 272600d1382443304-need-to-be-able-to-populate-data-from-sheet-2-to-sheet-1-based-on-header-name-in-sheet-2-example1
Sheet: Summary

 | Jan | Feb | March | April | May | June | July | August | September | October | November | December
Galway
Kerry
Spreadsheet: 868857d1715587318-identify-the-missing-values-book1
Sheet: Sheet1

 | Situtation-1 |  |  |  | Situtation-2 |  |  |  | Situtation-3 |  |  |  | Ideal
 | REG-1 | EMP-1 |  |  | REG-1 | EMP-1 |  |  | REG-1 | EMP-1 |  |  | REG-1 | EMP-1
 | [NAME] | EMP-3 |  |  | [NAME] | EMP-3 |  |  | [NAME] | EMP-3 |  |  | [NAME] | EMP-3
 | REG-3 | EMP-2 |  |  | REG-3 | EMP-2 |  |  | REG-3 | EMP-2 |  |  | REG-3 | EMP-2
 | REG-4 |  | ï |  | REG-4 |  | ï |  | REG-4 | EMP-2 |  |  | REG-4 |  | ï | Emp ID Missing
 | REG-1 | EMP-4 |  |  | REG-1 | EMP-4 |  |  | REG-1 | EMP-4 |  |  | REG-1 | EMP-4
 | [NAME] | EMP-2 |  |  | [NAME] | EMP-2 |  |  | [NAME] | EMP-2 |  |  | [NAME] | EMP-2
 | REG-3 |  | ï |  | REG-3 | EMP-2 |  |  | REG-3 | EMP-2 |  |  | REG-3 | EMP-2
 | REG-4 | EMP-2 |  |  | REG-4 |  | ï |  | REG-4 | EMP-2 |  |  | REG-4 | EMP-2
 | REG-1 | EMP-4 |  |  | REG-1 | EMP-4 |  |  | REG-1 | EMP-4 |  |  | REG-1 | EMP-4
 | [NAME] | EMP-4 |  |  | [NAME] | EMP-4 |  |  | [NAME] | EMP-4 |  |  | [NAME] |  | ï | Emp ID Missing
 | REG-3 | EMP-2 |  |  | REG-3 | EMP-2 |  |  | REG-3 | EMP-2 |  |  | REG-3 | EMP-2
 | REG-4 | EMP-3 |  |  | REG-4 | EMP-3 |  |  | REG-4 | EMP-3 |  |  | REG-4 | EMP-3
 | REG-5 | EMP-2 |  |  | REG-5 | EMP-2 |  |  | REG-5 | EMP-2 |  |  | REG-5 | EMP-2
 |  | EMP-2 | ï |  |  |  |  |  |  | EMP-2 | ï |  |  |  |  |  | This is non-empty Row where other cells are not provided
 |  | EMP-2 | ï |  |  |  |  |  |  | EMP-2 | ï |  |  | EMP-2 | ï | [NAME]
Spreadsheet: 94f95693-b691-4af4-88d4-44be231e8984
Sheet: Sheet1

Permit No.: | Unnamed: 1 | Unnamed: 2 | WQ0017923 | Unnamed: 4 | Unnamed: 5 | Facility Name: | Unnamed: 7 | North Cary WRF Reclaimed Water Program | Unnamed: 9 | Unnamed: 10 | Unnamed: 11 | Unnamed: 12 | Unnamed: 13 | County: | Wake | Unnamed: 16 | Month: | Unnamed: 18 | Unnamed: 19 | Year: | Unnamed: 21
Did conjunctive utilization occur at this facility? |  |  |  |  |  | Field Name: |  | Bulk Distribution |  | Field Name: |  |  |  | Field Name: |  |  |  | Field Name:
 |  |  |  |  |  | Area (acres): |  |  |  | Area (acres): |  |  |  | Area (acres): |  |  |  | Area (acres):
Day | Weather |  |  | Freeboard |  | Field Irrigated? |  |  |  | Field Irrigated? |  |  |  | Field Irrigated? |  |  |  | Field Irrigated?
 | Weather Code | Temperature | Precipitation | Storage             (if applicable) | 5-Day Upset              (if applicable) | Volume Distributed |  |  |  | Volume Applied | Time    Irrigated | Daily   Loading | Maximum Hourly Loading | Volume Applied | Time   Irrigated | Daily   Loading | Maximum Hourly Loading | Volume Applied | Time    Irrigated | Daily   Loading | Maximum Hourly Loading
 |  | ºF | in | ft | ft | gal |  |  |  | gal | min | in | in | gal | min | in | in | gal | min | in | in
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
Monthly Loading (gallons): |  |  |  |  |  | 0 |  |  |  | 0 |  |  |  | 0 |  |  |  | 0
Spreadsheet: 883990d1732825944-incremental-cell-references-book1
Sheet: Sheet1

DATES | 2023-07-30 00:00:00
WEEK NUMBER
RESULT WANTED | 31 | 32 | 33 | 34 | 35 | 36
Spreadsheet: f9dcaa5f-afd0-47cb-b3da-786f98951294
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
IMPR | Test | IMPR | Imipramine and [NAME], Serum | Imipramine and [NAME], S | High-Performance Liquid Chromatography (HPLC) | Plain, Red-Top Tube: Red |  |  | 3 | mL | Container/Tube: Red top [NAME]: 3 mL Collection Instructions: 1. Draw specimen immediately before next scheduled dose (minimum 12 hours after last dose). 2. Serum must be separated from cells within 2 hours of draw. | 1.1 mL | Hemolysis	Mild OK; Gross reject Thawing	Warm OK; Cold OK Lipemia	Mild OK; Gross reject Icterus	Mild OK; Gross reject Other	Serum gel tube | IMIPRAMINE AND DESIPRAMINE Total therapeutic concentration: 175-300 ng/mL Total toxic concentration: > or =300 ng/mL   DESIPRAMINE ONLY Therapeutic concentration: 100-300 ng/mL Toxic concentration: > or =300 ng/mL  Note: Therapeutic ranges are for specimens drawn at trough (ie, immediately before next scheduled dose). Levels may be elevated in non-trough specimens. | Monday through Saturday; Varies | 2 days | 4 days |  | Profile |  |  |  |  | Rochester
IMPR | [NAME] | SRED | Serum Red |  |  |  | Refrigerated | 14 days
IMPR | Result | 8126 | Imipramine | Imipramine | Numeric |  |  |  |  | ng/mL |  |  |  |  |  |  |  |  |  | 3690-5 | Imipramine:MCnc:Pt:Ser/Plas:Qn:
IMPR | Result | 2452 | Desipramine | Desipramine | Numeric |  |  |  |  | ng/mL |  |  |  |  |  |  |  |  |  | 3531-1 | Desipramine:MCnc:Pt:Ser/Plas:Qn:
IMPR | Result | 2453 | Imipramine and [NAME] | Imipramine and [NAME] | Numeric |  |  |  |  | ng/mL |  |  |  |  |  |  |  |  |  | 9627-1 | Imipramine+Desipramine:MCnc:Pt:Ser/Plas:Qn:
IMPR | Billing Component | IMPR |  | Imipramine |  |  |  |  |  |  |  |  |  |  |  |  |  | 1 | 80174
IMPR | Billing Component | IMPR |  | Desipramine |  |  |  |  |  |  |  |  |  |  |  |  |  | 1 | 80160