tianzl66/Sheetpedia huggingface dataset:
Spreadsheet: 838085d1690703479-change-sheet-refernce-incrementally-in-adjacent-cells-2023-league-standings-sample-hd
Sheet: W4

Team # | Team Name | Players | Ave | Hcap | Game 1 Scratch | Game 1 Handicap | Points | Game 2 Scratch | Game 2 Handicap | Points | Game 3 Scratch | Game 3 Handicap | Points | Scratch Series | Handicap Series | Series Points | Indiv Points
 |  |  |  |  | (For a Blind Score type   -  B      For and Vacancy Score type    -    V
 |  |  |  |  | 1 |  |  | 55 |  |  | 109
 |  |  |  |  | 2 |  |  | 56 |  |  | 110
 |  |  |  |  | 3 |  |  | 57 |  |  | 111
 |  |  |  |  | 4 |  |  | 58 |  |  | 112
 |  |  |  |  | 5 |  |  | 59 |  |  | 113
 |  |  |  |  | 6 |  |  | 60 |  |  | 114
 |  |  |  |  | 7 |  |  | 61 |  |  | 115
 |  |  |  |  | 8 |  |  | 62 |  |  | 116
 |  |  |  |  | 9 |  |  | 63 |  |  | 117
 |  |  |  |  | 10 |  |  | 64 |  |  | 118
 |  |  |  |  | 11 |  |  | 65 |  |  | 119
 |  |  |  |  | 12 |  |  | 66 |  |  | 120
 |  |  |  |  | 13 |  |  | 67 |  |  | 121
 |  |  |  |  | 14 |  |  | 68 |  |  | 122
 |  |  |  |  | 15 |  |  | 69 |  |  | 123
 |  |  |  |  | 16 |  |  | 70 |  |  | 124
 |  |  |  |  | 17 |  |  | 71 |  |  | 125
 |  |  |  |  | 18 |  |  | 72 |  |  | 126
 |  |  |  |  | 19 |  |  | 73 |  |  | 127
 |  |  |  |  | 20 |  |  | 74 |  |  | 128
 |  |  |  |  | 21 |  |  | 75 |  |  | 129
 |  |  |  |  | 22 |  |  | 76 |  |  | 130
 |  |  |  |  | 23 |  |  | 77 |  |  | 131
 |  |  |  |  | 24 |  |  | 78 |  |  | 132
 |  |  |  |  | 25 |  |  | 79 |  |  | 133
 |  |  |  |  | 26 |  |  | 80 |  |  | 134
 |  |  |  |  | 27 |  |  | 81 |  |  | 135
 |  |  |  |  | 28 |  |  | 82 |  |  | 136
 |  |  |  |  | 29 |  |  | 83 |  |  | 137
 |  |  |  |  | 30 |  |  | 84 |  |  | 138
 |  |  |  |  | 31 |  |  | 85 |  |  | 139
 |  |  |  |  | 32 |  |  | 86 |  |  | 140
 |  |  |  |  | 33 |  |  | 87 |  |  | 141
 |  |  |  |  | 34 |  |  | 88 |  |  | 142
 |  |  |  |  | 35 |  |  | 89 |  |  | 143
 |  |  |  |  | 36 |  |  | 90 |  |  | 144
 |  |  |  |  | 37 |  |  | 91 |  |  | 145
 |  |  |  |  | 38 |  |  | 92 |  |  | 146
 |  |  |  |  | 39 |  |  | 93 |  |  | 147
 |  |  |  |  | 40 |  |  | 94 |  |  | 148
 |  |  |  |  | 41 |  |  | 95 |  |  | 149
 |  |  |  |  | 42 |  |  | 96 |  |  | 150
 |  |  |  |  | 43 |  |  | 97 |  |  | 151
 |  |  |  |  | 44 |  |  | 98 |  |  | 152
 |  |  |  |  | 45 |  |  | 99 |  |  | 153
 |  |  |  |  | 46 |  |  | 100 |  |  | 154
 |  |  |  |  | 47 |  |  | 101 |  |  | 155
 |  |  |  |  | 48 |  |  | 102 |  |  | 156
 |  |  |  |  | 49 |  |  | 103 |  |  | 157
 |  |  |  |  | 50 |  |  | 104 |  |  | 158
 |  |  |  |  | 51 |  |  | 105 |  |  | 159
 |  |  |  |  | 52 |  |  | 106 |  |  | 160
 |  |  |  |  | 53 |  |  | 107 |  |  | 161
 |  |  |  |  | 54 |  |  | 108 |  |  | 162
Spreadsheet: michelle_lokay__26576__Dec00pnr
Sheet: PG&E 500622

 |  |  |  |  |  |  |  |  |  |  |  |  |  |  | Maximum Inventory Calculation
DAY | NAME | CONTRACT NUMBER | MONTH | POI # | type_poi | SCHEDULED INJECTION | SCHEDULED WITHDRAWAL | NET SCHEDULED QTY | Carryover GIP | NET GIP | DAILY INJECTION   PRICE                (Inj + MIC) | DAILY WITHDRAWAL  PRICE               (Wd + MIC) | INJECTION AMOUNT       (Inj + MIC) | WITHDRAWAL  AMOUNT          (Wd + MIC) | Positive Inventory | Negative Inventory | Positive Inventory Components | Negative Inventory Components | [NAME] | Ride Amount
 | PG&E | 27404 | 00/12 | 500622 | PnR
1 |  |  |  |  |  |  |  |  |  |  | 0.05 | 0.3883
2 |  |  |  |  |  |  |  |  |  |  | 0.05 | 0.3883
3 |  |  |  |  |  |  |  |  |  |  | 0.05 | 0.3883
4 |  |  |  |  |  |  |  |  |  |  | 0.05 | 0.3883
5 |  |  |  |  |  |  |  |  |  |  | 0.05 | 0.3883
6 |  |  |  |  |  |  |  |  |  |  | 0.05 | 0.3883
7 |  |  |  |  |  |  | -294 |  |  |  | 0.05 | 0.3883
8 |  |  |  |  |  |  |  |  |  |  | 0.05 | 0.3883
9 |  |  |  |  |  |  |  |  |  |  | 0.05 | 0.3883
10 |  |  |  |  |  |  |  |  |  |  | 0.05 | 0.3883
11 |  |  |  |  |  |  |  |  |  |  | 0.05 | 0.3883
12 |  |  |  |  |  |  |  |  |  |  | 0.05 | 0.3883
13 |  |  |  |  |  |  | -563 |  |  |  | 0.05 | 0.3883
14 |  |  |  |  |  |  |  |  |  |  | 0.05 | 0.3883
15 |  |  |  |  |  |  |  |  |  |  | 0.3883 | 0.3883
16 |  |  |  |  |  |  |  |  |  |  | 0.3883 | 0.3883
17 |  |  |  |  |  |  |  |  |  |  | 0.3883 | 0.3883
18 |  |  |  |  |  |  |  |  |  |  | 0.3883 | 0.3883
19 |  |  |  |  |  |  |  |  |  |  | 0.3883 | 0.3883
20 |  |  |  |  |  |  |  |  |  |  | 0.3883 | 0.3883
21 |  |  |  |  |  |  |  |  |  |  | 0.3883 | 0.3883
22 |  |  |  |  |  |  |  |  |  |  | 0.3883 | 0.3883
23 |  |  |  |  |  |  |  |  |  |  | 0.3883 | 0.3883
24 |  |  |  |  |  |  |  |  |  |  | 0.3883 | 0.3883
25 |  |  |  |  |  |  |  |  |  |  | 0.3883 | 0.3883
26 |  |  |  |  |  |  |  |  |  |  | 0.3883 | 0.3883
27 |  |  |  |  |  |  |  |  |  |  | 0.3883 | 0.3883
28 |  |  |  |  |  |  |  |  |  |  | 0.3883 | 0.3883
29 |  |  |  |  |  |  |  |  |  |  | 0.3883 | 0.3883
30 |  |  |  |  |  |  |  |  |  |  | 0.3883 | 0.3883
31 |  |  |  |  |  |  |  |  |  |  | 0.3883 | 0.3883
 |  |  |  | Total Injection |  |  |  |  |  |  | Total Invoice Amount
 |  |  |  | Total W/D
 |  |  |  |  |  |  |  |  |  |  |  |  | INVOICE AMOUNT
 |  |  |  |  |  |  |  |  |  |  |  |  | Inj Charge
 |  |  |  |  |  |  |  |  |  |  |  |  | Wd Charge
 |  |  |  |  |  |  |  |  |  |  |  |  | MIC Charge
 |  |  |  |  |  |  |  |  |  |  |  |  | Total Charge
 |  |  |  |  |  |  |  |  |  |  |  |  | BILL AMOUNT
Spreadsheet: 831015d1685357129-referencing-spilled-array-to-create-spilled-array-test1-12-aligw
Sheet: Sheet1

Data Table |  |  |  | Set Target Name: |  | Yellow section should match Green sections |  |  |  |  |  |  |  |  |  |  |  |  |  | Scores Table
[NAME] | Report Year | Sales |  | [NAME] |  | Spilled arrays. |  |  |  |  |  | Expected Results |  |  |  |  |  |  |  |  | 2001 | 2002
Name1 | 2001 | 0.2601754007917111 |  |  |  | Automatically adjusting number of rows |  |  |  |  |  | Manually set number of Rows |  |  |  |  |  |  |  |  | 3 | 5
Name1 | 2001 | 0.5589487394348224 |  | Year List |  | Target Score | Target Value | Min Score | Min Name | Min Name Value |  | Target Score | Target Value | Min Score | Min Name | Min Name Value |  |  | [NAME] | 2 | 4 | 6
Name1 | 2002 | 0.0339131073571044
Name1 | 2003 | 0.6124610747021023 |  | 2001 |  |  | 1.352177124367662 |  |  | 0 |  | 0.5
Name1 | 2002 | 0.2151687574897279 |  | 2002 |  |  | 0.3461924333011996 |  |  | 0 |  | 0.3
[NAME] | 2000 | 0.0273300349704646
[NAME] | 2001 | 0.5169532134791222 |  |  |  |  | 0.0273300349704646 | 2 | [NAME] | 0.0273300349704646
[NAME] | 2001 | 0.8352239108885394 |  |  |  | 4 | 1.352177124367662 | 4 | [NAME] | 1.352177124367662
[NAME] | 2002 | 0.3439801552874848 |  |  |  | 6 | 0.3461924333011996 | 6 | [NAME] | 0.3461924333011996
[NAME] | 2002 | 0.002212278013714819
Name3 | 2005 | 0.33333
Spreadsheet: 272654d1382454629-formulas-re-check-or-could-be-a-better-formula-workbook
Sheet: Sheet3

Target | Actual | Achievement | 80%-100% | 100%-110% | 110%-125% | 125% above | 1% - 20% | 1% - 10% | 1% - 15% | above | Total Incentives |  | Lookup Table
1000 | 800 |  |  |  |  |  |  |  |  |  |  |  | Target | Qualified Incentives Range | Amount
1000 | 801 |  |  |  |  |  |  |  |  |  |  |  | Below 80% | Not Eligible | 0
1000 | 1000 |  |  |  |  |  |  |  |  |  |  |  | 80%-100% | 1% - 20% | 0.75
1000 | 1100 |  |  |  |  |  |  |  |  |  |  |  | 100%-110% | 1% - 10% | 1
1000 | 1125 |  |  |  |  |  |  |  |  |  |  |  | 110%-125% | 1% - 15% | 1.5
1000 | 1145 |  |  |  |  |  |  |  |  |  |  |  | Above 125% | Difference from 125% | 2
900 | 1000
800 | 1500
Spreadsheet: 86876d1286833093-summing-up-data-in-an-adjacent-cell-based-on-date-into-a-calendar-workbook-sample
Sheet: Data

Date | Type | % to Sell Projection | Event | # of goods Avail | Sales Projection | 0 | 1st day | 0 | 2nd Day | 0.1 | 3rd Day | 0.3 | 4th Day | 0.6 | 5th Day
2010-10-16 00:00:00 | Type 1 | 0.8 | 1 | 50 |  |  |  | 0 |  | 0 |  | 0 |  | 0
2010-10-16 00:00:00 | Type 2 | 0.35 | 2 | 75
2010-10-16 00:00:00 | Type 1 | 0.8 | 3 | 100 |  |  |  | 0 |  | 0 |  | 0 |  | 0
2010-10-17 00:00:00 | Type 1 | 0.8 | 4 | 98 |  |  |  | 0 |  | 0 |  | 0 |  | 0
2010-10-17 00:00:00 | Type 1 | 0.8 | 5 | 45 |  |  |  | 0 |  | 0 |  | 0 |  | 0
2010-10-18 00:00:00 | Type 1 | 0.8 | 6 | 120 |  |  |  | 0 |  | 0 |  | 0 |  | 0
2010-10-18 00:00:00 | Type 1 | 0.8 | 7 | 210 |  |  |  | 0 |  | 0 |  | 0 |  | 0
2010-10-20 00:00:00 | Type 2 | 0.35 | 8 | 15
2010-10-20 00:00:00 | Type 2 | 0.35 | 9 | 64
2010-10-21 00:00:00 | Type 1 | 0.8 | 10 | 78 |  |  |  | 0 |  | 0 |  | 0 |  | 0
2010-10-21 00:00:00 | Type 3 | 0.55 | 11 | 26
2010-10-21 00:00:00 | Type 4 | 0.25 | 12 | 84
Spreadsheet: ef554db2-6d81-4349-b667-85b357a34aa0
Sheet: Sheet1

electronica 2010 - List of exhibitors | Unnamed: 1 | Unnamed: 2 | Unnamed: 3 | Unnamed: 4 | Unnamed: 5
 | Search by product and service index (7 Entries):
 | 8 Passive components 8.9 Magnetic and electronic ceramic products 8.9.1 AlNiCo magnets
No. | Company | Country | City | [NAME] | Hall/Booth
1 | [NAME] | China | Shenzhen | 518048 | A2.538/4
2 | ARNOLD Magnetic Technologies AG | Switzerland | [NAME] | 5242 | B6.333
3 | Kolektor Magnet Technology GmbH | Germany | Essen | 45145 | A2.514
4 | matronic GmbH & Co Electronic [NAME] | Germany | Tübingen | 72070 | A2.336
5 | [NAME] | Finland | Ulvila | 28400 | B5.119
6 | Tridelta Magnetsysteme GmbH | Germany | Dortmund | 44287 | B6.342
7 | ZhiJiang Magnet Co., Ltd | China | [NAME], Xiaoshan, Hangzhou | 311215 | B6.437/4
Spreadsheet: 719302d1613605531-lookup-function-for-reporting-structure-supervisor-report
Sheet: Reports To

EEID | Supervisor EID | Employee #
42 |  | 1000
396 | 1 | 1813 |  | Row Labels
31 | 17 | 1003 |  | 1
502 | 17 | 1911 |  | 1813
129 | 17 | 1011 |  | 17
249 | 17 | 1534 |  | 1003
100 | 17 | 1611 |  | 1011
103 | 42 | 1049 |  | 1534
112 | 42 | 1178 |  | 1611
231 | 42 | 1191 |  | 1911
114 | 42 | 1310 |  | 42
184 | 42 | 1386 |  | 1014
128 | 42 | 1014 |  | 1049
183 | 42 | 1501 |  | 1051
148 | 42 | 1348 |  | 1178
17 | 42 | 1051 |  | 1179
39 | 42 | 1179 |  | 1191
283 | 100 | 1293 |  | 1310
492 | 100 | 1905 |  | 1348
1 | 100 | 1649 |  | 1386
395 | 114 | 1811 |  | 1501
136 | 181 | 1857 |  | 100
73 | 181 | 1330 |  | 1293
488 | 181 | 1901 |  | 1649
285 | 181 | 1123 |  | 1905
484 | 181 | 1897 |  | 114
252 | 181 | 1384 |  | 1811
110 | 181 | 1441 |  | 181
272 | 181 | 1563 |  | 1123
435 | 212 | 1842 |  | 1330
475 | 212 | 1893 |  | 1384
497 | 212 | 1908 |  | 1441
462 | 212 | 1889 |  | 1563
181 | 231 | 1373 |  | 1857
454 | 373 | 1887 |  | 1897
390 | 373 | 1808 |  | 1901
20 | 373 | 1682 |  | 212
28 | 373 | 1855 |  | 1842
457 | 373 | 1888 |  | 1889
501 | 373 | 1912 |  | 1893
327 | 373 | 1757 |  | 1908
420 | 373 | 1832 |  | 231
436 | 373 | 1843 |  | 1373
331 | 373 | 1756 |  | 373
453 | 373 | 1886 |  | 1682
506 | 420 | 1916 |  | 1756
212 | 420 | 1705 |  | 1757
498 | 480 | 1909 |  | 1808
16 | 480 | 1677 |  | 1832
382 | 480 | 1798 |  | 1843
464 | 480 | 1868 |  | 1855
469 | 480 | 1883 |  | 1886
468 | 480 | 1894 |  | 1887
467 | 480 | 1891 |  | 1888
480 | 502 | 1896 |  | 1912
373 | 502 | 1789 |  | 420
 |  |  |  | 1705
 |  |  |  | 1916
 |  |  |  | 480
 |  |  |  | 1677
 |  |  |  | 1798
 |  |  |  | 1868
 |  |  |  | 1883
 |  |  |  | 1891
 |  |  |  | 1894
 |  |  |  | 1909
 |  |  |  | 502
 |  |  |  | 1789
 |  |  |  | 1896
 |  |  |  | (blank)
 |  |  |  | 1000
 |  |  |  | Grand Total
Spreadsheet: 697104d1601182726-extracting-data-next-to-a-cells-that-match-a-given-range-extractingdata
Sheet: Sheet1

Rounded times (s) | Column B | Column C |  |  | Start of time | End of time |  | .19-.21 |  |  | .26-.28
0 | 0.436615113 | 0.168082837 |  |  | 0.19 | 0.21 |  | 0.0182248106 | -0.16842953 |  | 0.14798497 | 0.0060340081
0.01 | 0.445968241 | 0.0943808637 |  |  | 0.26 | 0.28 |  | 0.0119560645 | -0.163245196 |  | 0.180599478 | -0.0277181563
0.02 | 0.456019631 | 0.00128849983 |  |  |  |  |  | 0.013519234 | -0.164237293 |  | 0.243334462 | -0.036382763
0.03 | 0.474664405 | -0.0259805605 |  |  |  |  |  | 0.0280460746 | -0.13753721
0.04 | 0.47398606 | -0.015827239
0.04 | 0.436651512 | -0.0292964885
0.05 | 0.381592842 | -0.0626409786
0.06 | 0.306858966 | -0.0569509806
0.07 | 0.253640611 | -0.0257415794
0.08 | 0.22578023 | -0.0276231547
0.09 | 0.218065772 | -0.0703722406
0.09 | 0.22340346 | -0.102987684
0.1 | 0.208344996 | -0.0869649188
0.11 | 0.193554454 | -0.0871441744
0.12 | 0.177454016 | -0.122197417
0.13 | 0.171315875 | -0.144600012
0.14 | 0.177244745 | -0.107985052
0.14 | 0.162962113 | -0.0758412581
0.15 | 0.143044178 | -0.114925033
0.16 | 0.105401206 | -0.20484167
0.17 | 0.0687950792 | -0.241130688
0.18 | 0.0464342306 | -0.20391486
0.19 | 0.0182248106 | -0.16842953
0.19 | 0.0119560645 | -0.163245196
0.2 | 0.013519234 | -0.164237293
0.21 | 0.0280460746 | -0.13753721
0.22 | 0.0556539586 | -0.131645389
0.23 | 0.0685568476 | -0.161017327
0.24 | 0.0886820535 | -0.172119202
0.24 | 0.101402289 | -0.103877453
0.25 | 0.117366014 | -0.0184536219
0.26 | 0.14798497 | 0.0060340081
0.27 | 0.180599478 | -0.0277181563
0.28 | 0.243334462 | -0.036382763
0.29 | 0.317186956 | 0.00956971036
0.29 | 0.39375307 | 0.0381062967
0.3 | 0.454446977 | 0.0333174402
Spreadsheet: 850467d1700809407-help-with-countif-based-on-criteria-count-basis
Sheet: Sheet1

 |  | Item | Count Of Item
 |  | 86
 |  | 503
 |  | 142
 |  | 216
 |  | 125
 |  | 173
 |  | 35
 |  | 434
 |  | 627
 |  | 377
 |  | 508
 |  | 374
 |  | 374
 |  | 374
 |  | 321
 |  | 321
 |  | 321
 |  | 9
 |  | 141
 |  | 109
Spreadsheet: louise_kitchen__22839__Hot List Update 5-29-01
Sheet: Executive

Deal Description Sheet - 5/29/01
Executive
YTD P & L | 6163000
Project Name | Counterparty | Description | Valuation | Last Customer Contact | Probability | Expected Closing (Month/Year) | Weekly Updates / Comments
JM Huber | JM Huber | Assignment of transport capacity. | $5.8 MM |  |  | 2001-05-30 00:00:00 | [NAME] pipeline won final approval  from the FERC to expand system capacity from Colorado to Nebraska.  [NAME] signed binding precedent agreements for this firm capacity -- of which ENA had 41 million CFD.  We assigned the P.A. and in conjuntion with [NAME] tranport, did a producer netback deal with JM Huber. The entire earnings stream could not be released from Schedule C until the Ferc gave final approval on the [NAME] expansion (per [NAME]).  Earnings released with appropriate credit reserve allocation.
Total Upstream Products P & L
W/out Production Offshore
Note : All Upstream Products P&L includes other, origination and accrual.
The accrual numbers used are actual and do not include forecasts the remaining months of the year (May - Dec).
The P&L from Production Offshore is derived from the Pluto/ MEGS deal.
Spreadsheet: 674313d1587751555-frequency-formula-with-criteria-when-filtered-test
Sheet: Sheet2

First name | country
[NAME] | Spain
Frasewr | Taiwan |  |  |  |  |  |  |  | 71 | 70
[NAME] | England
[NAME] | England
[NAME] | Spain
Frasewr | Taiwan |  |  |  |  |  |  |  | 57
Frasewr | England |  |  |  |  |  |  |  | 86
[NAME] | Spain
[NAME] | England
[NAME] | Taiwan
 |  | count
Spreadsheet: mark_taylor__24728__ClickInTradingProducts
Sheet: MC Weather

Weather
Short Description Boxes for Weather:
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | ECT Market
Weather Instrument |  |  | Transaction Type |  | Transaction Reference Basis |  | Currency |  | Location & Station Ref. # |  | Term (month(s)) |  | Year |  | Payout per Transaction Unit |  | Maximum Payout Limit |  | Bid | Offer
Swap |  |  | CDD |  | 65F |  | USD |  | Miami WBAN# xxxxx |  | Apr-Oct |  | 2000 |  | 2500 |  | 500000 |  | 3000
460 | Call Option |  | HDD |  | 18C |  | GBP |  | London Heathrow IWMO 37720 |  | Nov-Mar |  | 1999-2000 |  | 10000 |  | 2000000 |  |  | 250000
5000 | Put Option |  | Precipitation |  | [NAME] |  | EUR |  | Oslo NMO 18700 |  | Jan-Mar (Q1) |  | 2000 |  | 2500 |  | 1000000 |  |  | 500000
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  | After entering a number this field would automatically enter the right reference unit and currency (eg 10,000 GBP/HDD) |  | After entering a number this field would automatically enter the right reference currency (eg 500,000 USD) |  | After entering a number in this field, if a swap the reference unit would be added (eg 3,000 CDDs), if an option the currency would be added (eg 500,000 EUR)
Spreadsheet: 636604d1565375671-help-calendar-correction-employee-absence-schedule-current-6-5-19
Sheet: March

 | Employee Absence Schedule
 | Absence Type Key | V | Vacation |  |  | P | Pick Up Shift |  |  | S | Sick |  |  | Custom 1 |  |  |  | Custom 2
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | Enter year:
 | March | Dates of Absence/Pick up |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 2019
 | Employee Name | 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 |  |  |  | Vacation Days Taken/Year | Vacation  Days Taken/Month | Days Picked Up/Month | Sick Days/Month
 | [NAME] | s
 | Lynda
 | [NAME]
 | Heather |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | p |  |  |  |  |  | v | v
 | [NAME] |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | p
 | Emili |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | s |  |  |  |  |  |  | p
 | Amber
 | Meredith
 | Julie
Spreadsheet: 1450fa48-2af4-480c-9435-d1334fa2c11f
Sheet: JVS District Name

JVS IRN | County | JVS District Name
50773 | [NAME] | APOLLO JVSD
50799 | [NAME] | SOUTHERN HILLS JVSD
50815 | Ashtabula | A-TECH JVSD
50856 | Belmont | BELMONT-HARRISON JVSD
50880 | Butler | BUTLER TECH JVSD
50906 | [NAME] | [NAME] JVSD
50922 | Cuyahoga | CUYAHOGA VALLEY JVSD
50948 | Cuyahoga | POLARIS JVSD
50963 | [NAME] | FOUR COUNTY JVSD
50989 | Delaware | DELAWARE AREA CAREER CENTER JV
51003 | Franklin | EASTLAND-FAIRFIELD CAREER/TECH
51029 | Erie | EHOVE JVSD
51045 | Greene | GREENE COUNTY JT VOC SD JVSD
51060 | [NAME] | GREAT OAKS INST OF TECHNOLOGY
51128 | [NAME] | JEFFERSON COUNTY JVSD
51144 | Knox | KNOX COUNTY JVSD
51169 | Lake | AUBURN JVSD
51185 | [NAME] | [NAME] JVSD
51201 | Licking | C-TEC JVSD
51227 | Lorain | LORAIN COUNTY JVS JVSD
51243 | Mahoning | MAHONING CO CAREER & TECH CTR
51284 | Montgomery | MIAMI VALLEY CAREER TECH JVSD
51300 | Muskingum | MID-EAST CAREER & TECH CENTERS
51334 | Logan | OHIO HI-POINT JVSD
51359 | Wood | PENTA JVSD
51375 | Pike | PIKE COUNTY AREA JVSD
51391 | Portage | MAPLEWOOD CAREER CENTER JVSD
51417 | Richland | PIONEER CAREER & TECHNOLOGY JV
51433 | [NAME] | PICKAWAY-ROSS JVSD JVSD
51458 | Sandusky | VANGUARD-SENTINEL JVSD
51474 | [NAME] | WARREN COUNTY JVSD
51490 | Scioto | SCIOTO COUNTY CTC JVSD
51532 | [NAME] | SPRINGFIELD-CLARK COUNTY JVSD
51607 | Athens | TRI-COUNTY CAREER CENTER JVSD
51631 | Trumbull | TRUMBULL CAREER & TECH CTR JVS
51656 | Tuscarawas | [NAME] JVSD
51672 | Van Wert | VANTAGE JVSD
51698 | Washington | WASHINGTON COUNTY JVSD
51714 | Wayne | WAYNE COUNTY JVSD JVSD
62026 | [NAME] | STARK COUNTY AREA JVSD
62042 | Ashland | ASHLAND COUNTY-WEST HOLMES JVS
62067 | Gallia | GALLIA-JACKSON-VINTON JVSD
62109 | Medina | MEDINA COUNTY JVSD JVSD
62125 | Miami | UPPER VALLEY CAREER CENTER JVS
62802 | Clermont | U S GRANT JVSD
63495 | Summit | PORTAGE LAKES JVSD
63511 | [NAME] | TOLLES JVSD
65227 | Coshocton | COSHOCTON COUNTY JVSD
65268 | Marion | TRI-RIVERS JVSD
50765 | * * * | State of Ohio
Spreadsheet: 2f926099-9f7a-4e18-8578-64a11ea4d860
Sheet: Exh 1

 | Expected |  | Expected | Booked | Estimated | Premium
Policy | Future Loss |  | Future | Prem From | Total | Booked @ | Premium
Period | Emergence | CPDLD | Premium | Prior Adj. | Premium | 1994-12-31 00:00:00 | Asset
1987.1 to 1987.4
1988.1 to 1988.4
1989.1 to 1989.4
1990.1 to 1990.4
1991.1 to 1991.4
1992.1 to 1992.4
1993.1 to 1994.4
Spreadsheet: 694014d1599297024-simple-vertical-to-horizontal-transpose-formula-help-simple-transpose-forum-question
Sheet: Sheet1

 | Inputs |  | Required output by formula (Don't want to use Paste Special Transpose and TRANSPOSE array formula)
 | F00658 |  | F00658 | [NAME] | DCz748 | BBD569 | ABz297 | AEC574 | 73F357 | 9Az509 | D7A397 | Az8736 | CAF465 | [NAME] | 9B8802 | DF9334 | CEE826 | 7AB208 | FzC560 | ADC642 | 9zA343 | F63650 | EB7665
 | [NAME]
 | DCz748 |  | Hello Friends
 | BBD569
 | ABz297 |  | From the given inputs I need to transpose the vertical list. I don't want to use the Paste Special Transpose since it leads to manual work when the data is getting changed or added in lost.
 | AEC574
 | 73F357 |  | Also willing to use Non array or Array formula but don't what to use the `Transpose' formula since it is uncomforatable.
 | 9Az509
 | D7A397 |  | Thanks in Advance
 | Az8736
 | CAF465 |  | Sekar
 | [NAME]
 | 9B8802
 | DF9334
 | CEE826
 | 7AB208
 | FzC560
 | ADC642
 | 9zA343 | This light green text will be edited at any time
 | F63650
 | EB7665
 |  | Here texts will be added
Spreadsheet: 675603d1588364402-copy-data-between-sheets-having-same-col-names-but-not-col-numbers-hlookup
Sheet: Normalized Template

 |  |  |  | Tags | Open Date | Close Date | Symbol | Action | Units/Lots | SL | TP | Open Price | Close Price | Commission | Swap | Pips
I will have other calcs in columns A-D
Spreadsheet: stacey_white__39204__HCurve_Shift_Deal896746
Sheet: Sheet1

Peak | OffPeak | Vol | Interest Rt | Discount Rt | Discount Vol
23.5 | 17 | -600 | 0.0177767 | 0.9983 | -598.9833
Hour | Hourly Factor | Hourly Price | Hourly Price + $1 |  | Hypothetic curve shift
1 | 1.152146175
2 | 0.865398541
3 | 0.674414778
4 | 0.636779386
5 | 0.854819328
6 | 1.119693215
7 | 0.753504131
8 | 0.930069584
9 | 0.946542195
10 | 1.030949084
11 | 1.055849875
12 | 1.036813946
13 | 1.029506092
14 | 1.04687167
15 | 1.026592735
16 | 1.001704364
17 | 0.990585371
18 | 0.994740593
19 | 1.068725272
20 | 1.070365588
21 | 1.051643579
22 | 0.965535922
23 | 1.504589805
24 | 1.192158772