tianzl66/Sheetpedia huggingface dataset:
Spreadsheet: 103562d1301329025-how-do-i-convert-table-1-to-table-2-book1_cicihk_rows_to_column-1-
Sheet: Sheet1

Table 1
 | 1 | 2 | 3 | 4
a | 0 | 6 | 0 | 10
b | 5 | 50 | 0 | 0
c | 0 | 10 | 7 | 0
d | 8 | 11 | 0 | 8
convert to
Table 2
a1 | 0
a2 | 6
a3 | 0
a4 | 10
b1 | 5
b2 | 50
b3 | 0
b4 | 0
c1 | 0
c2 | 10
c3 | 7
c4 | 0
d1 | 8
d2 | 11
d3 | 0
d4 | 8
Spreadsheet: 843304d1695203042-using-date-to-populate-cell-excel-help-date
Sheet: Sheet1

Date | Apples | Apples
2023-09-01 00:00:00 |  | 4
2023-09-02 00:00:00 |  | 4
2023-09-03 00:00:00 |  | 4
2023-09-04 00:00:00 |  | 4
2023-09-05 00:00:00 |  | 4
2023-09-06 00:00:00 |  | 4
Spreadsheet: 679402d1590403851-count-number-of-unique-dates-based-on-criteria-data
Sheet: Data

ID | Due Date | Cost Code | CODE_TYPE | Code | UNITS | Value | Paid Date | Count
2 | 2019-06-30 00:00:00 | 80-08-90 | 1 | 1 | 64 | 1895.13 | 2019-07-03 00:00:00 | 6
2 | 2019-06-30 00:00:00 | 80-08-90 | 1 | 11 | -3.62 | -107.19 | 2019-07-03 00:00:00
2 | 2019-07-14 00:00:00 | 80-08-90 | 1 | 1 | 66.6 | 1972.12 | 2019-07-17 00:00:00
2 | 2019-07-14 00:00:00 | 80-08-90 | 1 | 11 | -3.6 | -106.6 | 2019-07-17 00:00:00
2 | 2019-07-14 00:00:00 | 80-08-90 | 7 | SUPR01 | 1 | 196.92 | 2019-07-17 00:00:00
2 | 2019-07-28 00:00:00 | 80-08-90 | 1 | 1 | 74 | 2191.24 | 2019-07-31 00:00:00
2 | 2019-08-11 00:00:00 | 80-08-90 | 1 | 1 | 59.2 | 1752.99 | 2019-08-14 00:00:00
2 | 2019-08-11 00:00:00 | 80-08-90 | 1 | 11 | -3.6 | -106.6 | 2019-08-14 00:00:00
2 | 2019-08-25 00:00:00 | 80-08-90 | 1 | 1 | 74 | 2191.24 | 2019-08-28 00:00:00
2 | 2019-09-08 00:00:00 | 80-08-90 | 1 | 1 | 74 | 2191.24 | 2019-09-11 00:00:00
2 | 2019-09-08 00:00:00 | 80-08-90 | 1 | 11 | -4 | -118.45 | 2019-09-11 00:00:00
24 | 2019-07-28 00:00:00 | 80-07-10 | 1 | 32 | 1.02 | 32.54 | 2019-07-31 00:00:00 | 7
24 | 2019-08-11 00:00:00 | 80-07-10 | 1 | 1 | 51.8 | 1652.32 | 2019-08-14 00:00:00
24 | 2019-08-11 00:00:00 | 80-07-10 | 1 | 32 | 7.4 | 236.05 | 2019-08-14 00:00:00
24 | 2019-08-25 00:00:00 | 80-07-10 | 1 | 1 | 59.2 | 1888.37 | 2019-08-28 00:00:00
24 | 2019-08-25 00:00:00 | 80-07-10 | 7 | SUPR01 | 1 | 179.39 | 2019-08-28 00:00:00
24 | 2019-09-08 00:00:00 | 80-07-10 | 1 | 1 | 59.2 | 1888.37 | 2019-09-11 00:00:00
24 | 2019-09-08 00:00:00 | 80-07-10 | 7 | SUPR01 | 1 | 179.39 | 2019-09-11 00:00:00
24 | 2019-09-22 00:00:00 | 80-07-10 | 1 | 1 | 59.2 | 1888.37 | 2019-09-25 00:00:00
24 | 2019-10-06 00:00:00 | 80-07-10 | 1 | 1 | 44.4 | 1416.28 | 2019-10-09 00:00:00
24 | 2019-10-06 00:00:00 | 80-07-10 | 1 | 8 | 7.4 | 236.05 | 2019-10-09 00:00:00
24 | 2019-10-06 00:00:00 | 80-07-10 | 1 | 9 | 7.4 | 236.05 | 2019-10-09 00:00:00
24 | 2019-10-06 00:00:00 | 80-07-10 | 7 | SUPR01 | 1 | 179.39 | 2019-10-09 00:00:00
24 | 2019-10-25 00:00:00 | 80-07-10 | 7 | SUPR01 | 1 | 179.39 | 2019-10-09 00:00:00
Spreadsheet: 807221d1669809234-if-or-and-formula-help-costing-test
Sheet: Sheet1

 |  | Dimension (mm) |  | Description |  | Cost
 | Dim 'A' | 300 |  | Dim A, B, C are all under 300mm | <300 | 30
 | Dim 'B' | 250 |  | Dim A or B or C are equal to or greater than 300mm AND Dim A and B and C are less than 500mm | >=300 and <500 | 60
 | Dim 'C' | 250 |  | Dim A, B, C are all equal to or greater than 500mm AND less than or equal to 750mm | >=500 and <=750 | 90
 |  |  |  | Dim A or B or C are greater than 750mm | >750 | POA
 |  |  |  |  | Cost
Spreadsheet: daren_farmer__5668__HPLN0110
Sheet: Sheet1

HPLN0110.XLS |  | Fax # [PHONE]
TO:  DARREN FARMER / ENRON;  CARY METZ / ENRON;  [NAME] / HPL;  LIZ BELLAMY / ENRON
FROM:  MELISSA JONES - TXU ELECTRIC & GAS  (TU ELECTRIC)
SUBJECT:  TXU FUELS NOMINATION - Januar 10, 2001
 |  |  |  |  |  | **Wednesday
HPL AND ENRON NOMINATIONS: |  |  |  |  |  | 2001-01-10 00:00:00
 |  |  |  |  |  | Eff. 0900 hrs.
 |  |  |  |  | PRIOR | NOMINATED
CONTRACT |  | DELIVERY POINT |  | Upstream
 |  | Firm Summary
 |  | Enron North America Spot/3959
OTHER ENRON/HPL TRANSPORTS: |  |  |  | Downstream
 |  | Total Other Transports:
NOTE:  Additional swing volumes may be requested at Teco Tap, or Texoma by TUFCO Gas Control under either the
Wagner Brown K# 1901 or HPL K# 3949 agreements.
*  Nominations to continue until TU Electric changes such nominations.
CC:   [NAME] | [NAME]
R. Skerik | [NAME]
G. Green | K. English
B. Fleming | GCC Dispatcher
Spreadsheet: phillip_m_love__30659__9909_OA
Sheet: WE-GL 

ENRON CAPITAL & TRADE RESOURCES
OPERATIONAL ANALYSIS - ACTUALS
COMPANY:  ECTR (EGM)
REGION:  WEST
 |  |  | Total |  | Reclasses |  | September |  | October |  | November |  | December |  | January |  | February |  | March |  | April
 |  |  | Volume | $'s | Volume | $'s | Volume | $'s | Volume | $'s | Volume | $'s | Volume | $'s | Volume | $'s | Volume | $'s | Volume | $'s | Volume | $'s | Volume | $'s | Volume | $'s | Volume | $'s | Volume | $'s
 | Sales:
1 |  | 3rd Party / Inter Enron
2 |  | Liquidations |  |  |  |  |  |  |  |  |  | -794249.91
3 |  | Interdesk
4 |  | Option Premiums
5 |  | Dmd Reimbursements
 | Total Sales:
 | Purchases:
6 |  | 3rd Party / Inter Enron
7 |  | Liquidations |  |  |  |  |  |  |  |  |  |  |  |  |  | 0 |  | 0 |  | 0 |  | 0
8 |  | Interdesk
9 |  | Option Premiums
10 |  | [NAME]
 | Total Purchases:
 | Intra CTS (EGM / HPL / LRC):
11 |  | Sales
12 |  | Purchases
 | Total Intra CTS Sales / Purchases
 | Imbalances:
13 |  | In Kind
14 |  | Cash Out
15 |  | Cash In
16 |  | Synthetic Storage
 | Total Imbalances:
 | Storage:
17 |  | Injection (Sales to Stg)
18 |  | W/D (Purchase from Stg)
19 |  | Inventory Profit
 |  | Total W/D
 | Total Storage:
20 | Linepack:
21 | Shrinkage:
22 | UA4:
23 | Fuel:
 | Transport Expense:
24 |  | Commodity
25 |  | Demand
 | Total Transport Expense:
 | Transport Revenue:
26 |  | Interstate
27 |  | Intrastate
 | Total Transport Revenue:
 | Intra CTS (EGM / HPL / LRC):
28 |  | Transport Expense
29 |  | Transport Revenue
 | Total Intra CTS Transport
 | Tie Out Schedule Items:
 |  | MTM Income:
30 |  | Current Gross Book Balance
31 |  | Prior Month Book Balance
 |  | Total MTM Income
32 |  | Prudency
33 |  | Financial Liquidations |  |  |  |  |  |  |  | 0 |  |  |  |  |  | -11100
34 |  | Originations
35 |  | Broker Fees
36 |  | Asset Group Demand Charges
37 |  | [NAME]
38 |  | Interdesk Charges
39 |  | Canada
40 |  | Miscellaneous
 |  | TOTAL
Spreadsheet: 761269d1640788593-combine-columns-datas-for-identical-values-in-first-column-test3
Sheet: test2

 |  | point | type | other | value
130 | 140 | 139 | +Z |  |  | 0.35
130 | 140 | 139 | X |  |  | 0.35 |  | -4
130 | 140
130 | 140
130 | 140
130 | 140
180 | 185 | 185 | +Z |  |  | 0.35
180 | 185 | 185 | Guide |  | 2 | 0.35
180 | 185 | 185 | LIM |  | 4 | 0.35 |  | -3
180 | 185
180 | 185
180 | 185
370 | 380 | 380 | ANC |  |  |  | 2000 | vessel E-106
370 | 380
370 | 380
370 | 380
370 | 380
370 | 380
5174 | 10000 | 10000 | +Z |  |  | 0.35
5174 | 10000 | 10000 | Guide |  | 2 | 0.35 |  | -1
5174 | 10000
5174 | 10000
5174 | 10000
5174 | 10000
5109 | 10020 | 10020 | +Z |  |  | 0.35 |  | -2
5109 | 10020
5109 | 10020
5109 | 10020
5109 | 10020
5109 | 10020
Spreadsheet: 267303d1380039079-alternative-to-multiple-nested-if-statements-to-sum-certain-values-example-if-problem
Sheet: Sheet1

 |  |  |  | December
 |  | YTD |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | January | February | March | April | May | June | July | August | September | October | November | December
Revenue
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 100 | 200 | 300 | 400 | 500 | 600 | 700 | 800 | 900 | 1000 | 1100 | 1200
Spreadsheet: 00cb7da7-9baf-4fd7-a3a9-07db31f1fa25
Sheet: Sheet1

SEATTLE UNIVERSITY | Unnamed: 1 | Unnamed: 2 | Unnamed: 3 | Unnamed: 4 | Unnamed: 5 | Unnamed: 6 | Unnamed: 7 | Unnamed: 8 | Unnamed: 9 | Unnamed: 10 | Unnamed: 11 | Unnamed: 12 | Unnamed: 13
NON-EXEMPT EMPLOYEE TIME REPORT
NAME: |  |  |  |  | DEPT: |  |  | (Use 4 letter-code as shown on paystub under DEPT)
Datatel ID Number:
PE: |  | 2014-01-01 00:00:00 | TO | 2014-01-31 00:00:00 |  | MO. NO.: |  | 1
Holiday Pay |  |  |  | HP | 15
Community Service Leave |  |  |  | CSL |  | (3 days per FY)
Sick Pay |  |  |  | SP
Vacation Pay |  |  |  | VP
[NAME] |  |  |  | BR |  | (up to 5 days of paid leave)
Jury Duty Leave |  |  |  | JL
[NAME] |  |  |  | DP
 |  |  |  |  |  |  |  |  | Employee Signature |  |  |  | Date
Regular Pay |  |  |  | RP | 157.5
SUB-TOTAL |  |  |  |  | 172.5 |  |  |  | Supervisor Signature |  |  |  | Date
Overtime (1.0 rate) |  |  |  |  |  | (If total hours worked (Sunday-Saturday) is between 37.50 and 40)
Overtime (1.5 rate) |  |  |  |  |  | (If total hours worked (Sunday-Saturday) is above 40)
TOTAL |  |  |  |  | 172.5
Sunday |  | Monday |  | Tuesday |  | Wednesday |  | Thursday |  | Friday |  | Saturday
 |  |  |  |  |  | HP | 7.5 |  | 7.5 |  | 7.5
 |  |  |  |  |  |  | 1 |  | 2 |  | 3 |  | 4
 |  |  | 7.5 |  | 7.5 |  | 7.5 |  | 7.5 |  | 7.5
 | 5 |  | 6 |  | 7 |  | 8 |  | 9 |  | 10 |  | 11
 |  |  | 7.5 |  | 7.5 |  | 7.5 |  | 7.5 |  | 7.5
 | 12 |  | 13 |  | 14 |  | 15 |  | 16 | Time sheets due | 17 |  | 18
 |  | HP | 7.5 |  | 7.5 |  | 7.5 |  | 7.5 |  | 7.5
 | 19 |  | 20 |  | 21 |  | 22 |  | 23 |  | 24 |  | 25
 |  |  | 7.5 |  | 7.5 |  | 7.5 |  | 7.5 |  | 7.5
 | 26 |  | 27 |  | 28 |  | 29 |  | 30 | Pay Day | 31
REMEMBER: Adjustment from Prior Month!! INCLUDE PRIOR MONTH ADJ HOURS IN THE ABOVE CALCULATION!
Spreadsheet: 214972d1361213135-find-add-and-return-values-from-multiple-worksheets-total-hour-on-subject
Sheet: Sheet2

Name | Course A | Time spent | Course B | Time spent | Course C | Time spent
Adam | English | 1 | Maths | 3 | Science | 4
Eve | Maths | 2 | Geography | 1 | Science | 2
[NAME] | Maths | 3 | Geography | 1 | History | 2
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
Spreadsheet: 681928d1591817049-conditional-format-but-stop-if-text-is-entered-upload
Sheet: Rec

 | Balance as at: | 2020-04-30 00:00:00 |  | Company Code | S101 |  |  | [NAME]
 | GL Code | 215040 |  | Region |  |  |  | Value match
 | GL Description |  |  | BU |  |  |  | Check 2
 | Currency | GBP |  | Contract |  |  |  | Check 3
 | Balance as per GL | 43023.98 |  | Profit Center No. | 1010363 |  |  | Check 4
 | Template | Prepayment |  | Frequency | Monthly |  |  | Check 5
 | Description |  |  |  |  | SAP doc # | WBS | Posting Date | Expected Resolution Date | Adequate third party backup exists | Total Value (LC) |  | Aging |  |  |  | Days Aged | Status |  | Action required to clear item | Actioned by (date) | Action Owner |  | ABS value
 |  |  |  |  |  |  |  |  |  |  |  |  | 0-30 days | 31-60 days | 61-90 days | 90 days +
 |  |  |  |  |  |  |  |  |  |  | -28984.66666667 |  |  |  |  |  | 119 | Closed |  |  |  |  |  |  |  | Rules
 |  |  |  |  |  |  |  |  |  |  | 9000 |  |  |  |  |  | 60 | Open |  |  |  |  |  |  |  | [NAME] if over 60 days (column R) and Status Open (column S)
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 70 | Closed |  |  |  |  |  |  |  | Next rule: if it contains text then remove the red
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 80 | Open
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 10 | Closed
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 61 | Open
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 4 | Closed
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 10 | Open
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 100 | Closed
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 50 | Open
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 70 | Closed
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 90 | Open |  |  | Test |  |  |  |  | Colour is removed as cell contains text
 | Reconciled
Spreadsheet: 84180d1284157246-determine-large-with-most-recent-data-point-excluded-test-sheet-3
Sheet: Sheet1

2010-07-01 00:00:00 | Prior | Current | Event | Event Date & Competitor Event Scores
Competitor | Best 8 | Best 8 | Count | 2010-01-01 00:00:00 |  | 2010-02-01 00:00:00 |  | 2010-03-01 00:00:00 |  | 2010-04-01 00:00:00 |  | 2010-05-01 00:00:00 |  | 2010-06-01 00:00:00 |  | 2010-07-01 00:00:00 |  | 2010-08-01 00:00:00 |  | 2010-09-01 00:00:00 |  | 2010-10-01 00:00:00 |  | 2010-11-01 00:00:00 |  | 2010-12-01 00:00:00
Mr A | 2200 | 2200 | 7 | 300 | aaaa | 300 | 800 | 300 |  | 300 |  | 300 |  | 300 |  | 400 |  | 400 |  | 400 |  | 400 |  | 0 |  | 0
Mr B | 1800 | 1800 | 7 | 250 | aaaa | 250 | 800 | 250 |  | 250 |  | 250 |  | 250 |  | 300 |  | 300 |  | 300 |  | 350 |  | 0 |  | 0
Mr C |  |  | 7 | 400 |  | 400 |  | 400 |  | 400 |  | 350 |  | 350 |  | 400 |  | 350 |  | 400 |  | 0 |  | 0 |  | 0
 | ^Mr A's value |  |  |  | ^spaces are |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | ^Mr C |  | ^Event |  | ^Event
 | should be 2700 |  |  |  | intentional as |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | did not |  | has not |  | has not
 |  |  |  |  | the real spreadsheet |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | attend |  | taken place |  | taken place
 | ^Mr B's value |  |  |  | has more data
 | should be 2150 |  |  |  | separating the |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | ^Since this is
 |  |  |  |  | score data entries |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | the latest event
 | ^Mr C's value |  |  |  | so individual |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | this should be the
 | should be 3100 |  |  |  | cell reference |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | one removed from
 |  |  |  |  | is required. |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | the equation to
 | ^Only the value |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | calculate previous
 | in column W |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | score.  The zero
 | should be |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | value by Mr C
 | excluded from |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | is essentially
 | the total score |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | his score and thus
 | as it is the most |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | his previous and
 | recent. |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | current score are
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | equal.
 | ^Highlighted cell |  | Without spaces between data:
 | is where I am
 | looking for a |  |  | 2010-01-01 00:00:00 | 2010-02-01 00:00:00 | 2010-03-01 00:00:00 | 2010-04-01 00:00:00 | 2010-05-01 00:00:00 | 2010-06-01 00:00:00 | 2010-07-01 00:00:00 | 2010-08-01 00:00:00 | 2010-09-01 00:00:00 | 2010-10-01 00:00:00 | 2010-11-01 00:00:00 | 2010-12-01 00:00:00
 | solution |  | 7 | 300 | 400 | 300 | 300 | 400 | 300 | 300 | 300 | 400 | 500 | 300 | 300
 |  |  | Prior 8 | 2000
 |  |  | Current 8 | 2300
Spreadsheet: 760226d1640087923-getting-data-from-different-tabs-book1
Sheet: WC 13th Dec

 |  | STARTS FROM (SCROLL RIGHT to see [NAME] IN --->)
[NAME] | [NAME] | 2021-12-13 00:00:00 | Daily site upload |  | Daily site upload |  | Daily site upload |  | Daily site upload |  | Daily site upload | in week total | previous week total
West London | A | 277 |  | 278 |  | 279 |  | 279 |  | 283
 | B | 600 |  | 600 |  | 602 |  | 602 |  | 604
 | C | 337 |  | 337 |  | 338 |  | 338 |  | 339
 | D | 672 |  | 679 |  | 683 |  | 683 |  | 700
 | E | 492 |  | 493 |  | 494 |  | 494 |  | 494
 | F | 267 |  | 267 |  | 269 |  | 269 |  | 269
 | G | 618 |  | 621 |  | 628 |  | 628 |  | 634
 | H | 285 |  | 286 |  | 289 |  | 289 |  | 292
 | I | 217 |  | 219 |  | 219 |  | 219 |  | 221
 | J | 246 |  | 249 |  | 249 |  | 249 |  | 254
 | K | 387 |  | 389 |  | 394 |  | 394 |  | 397
 | L | 356 |  | 357 |  | 359 |  | 359 |  | 361
 | M | 401 |  | 404 |  | 413 |  | 413 |  | 413
 | Totals
 |  |  | Day 1 |  | Day 1+2 | copied 23rd | Day 1+2+3 |  | Day 1+2+3+4 | copied 25th | Day 1+2+3+4+5
Spreadsheet: 174a123a-b730-4784-8753-600da4111155
Sheet: Kit Andrews

[NAME]
Fair Share Fee: Those Who Don't Pay Their Fair Share
Agree
Explain your fair share position, if you choose.
No response
Teachers' Retirement: Support in the State Budget
Agree
Explain your teachers' retirement position, if you choose.
No response
Health Care: Continuing System Reform
Agree
Explain your health care reform position, if you choose
No response
Teaching Career: Retaining New Teachers
Agree
Explain your teaching career position, if you choose
No response
Teaching Profession: Simplifying Professional Relicensing
Agree
Explain your relicensing position, if you choose
No response
Name | email address | Address | Office sought | Are you an incumbent? |  | County
[NAME] | [EMAIL] | 222 Park Street, Burlington | State Representative | No |  | Chittenden
Spreadsheet: 147731d1332950048-vlookup-higher-value-hdbolts
Sheet: Sheet1

H.D.BOLT ORDER SHEET
FILL IN BLUE PRINT PAGE 2
JOB | H4275-001
Title | [NAME]
TYPE | No of Bases | No of Bolts per base | [NAME] | Embedment | Grade | Washer | Washer Thickness |  |  |  | length
A | 30 | 4 | 20 | 400 | 8.8 | 100 | 10
TOTAL
Spreadsheet: diana_scholtes__8609__STNW PMA Preliminary
Sheet: Sheet1

EPMI ST NW prior month adjustments to be entered at the end of Sep 01':
Initial | Type | Del. Period | Desk | Counterparty | Reg | Vol | $ |  | Explanation
EL | DP | 2001-08-01 00:00:00 | EPMI-ST-NW | BPA | R9 | 0 |  | ok | 555367.1 capacity demand charge liquidated at -$33,064.52 daily, while it should have been -$37,962.96 daily.  (-37,962.96+33,064.52)* 27 peak days in Aug = -$132,257
AHC | DR | 2001-02-01 00:00:00 | EPMI-ST-NW | IDACORPENE | R9 | 0 | 8125 | ok | 746133.1 - SA added for LD's (DMS # 10634) other side is Power Ex Corp #746123.1
 |  |  |  |  |  |  |  |  | 082301-MP Entered due to LD's passed to us from PWX deal 517647.1 for a cut HE 7 by PAC.  See deal 488455.1 for $315.
 |  |  |  |  |  |  |  |  | $325 * 25 = 8125
EL | DR | 2001-05-01 00:00:00 | EPMI-ST-NW | TRANSCANPOWDIV | R9 | 0 | 6625 | ok | 650375.1 LD associated w/ tag MSOGH3F which was to flow 5/2/2001 hr 7 pdt
 |  |  |  |  |  |  |  |  | 082201 VT changed CP to Transcanada.  Per emails of 8-22-01, Transcanada has agree to accept the pass-thru of LD's
 |  |  |  |  |  |  |  |  | 072401 VT switched CP to Conagra.  This is to reverse payment already made thru deal # 650358.1.  [NAME] is at fault for the no-flow, so this deal to get refund from Conagra and they can get refund from [NAME].  Please see DMS 9192 and VT's email to [NAME] at Conagra on 7-23-01.
 |  |  |  |  |  |  |  |  | VT entered this annuity after listening to tapes with [NAME].  Per [NAME]'s tapes, [NAME] called after the fact about passing along LD's and [NAME] agreed to accept and pass along.  Morgan Stanley's [NAME] tag was denied because it was late. We sold to [NAME] and they passed LD's to us.
EL | DR | 2001-07-01 00:00:00 | EPMI-ST-NW | MIRANTAMEENE | R7 | 0 | 700 | is | DPR: $700 - net income from LD's between Mirant and Pinnacle DMS #10137
Spreadsheet: 0a8bce26-c259-4370-9454-3553150f3fae
Sheet: SS 2

 |  |  | 11-12 |  |  |  |  | 11-12 Total | 12-13 |  |  |  |  | 12-13 Total | 13-14 |  |  |  |  | 13-14 Total
Major | [NAME] | CrseNum | A | B | C | D | F |  | A | B | C | D | F |  | A | B | C | D | F
Social Studies Educ-Grds 6-12 / History | ECON | 203 | 1 | 3 | 1 |  |  | 5 |  | 2 | 1 |  |  | 3 |  | 1 | 2 |  |  | 3
 |  | 204 | 2 |  |  | 1 |  | 3 | 1 | 1 |  |  |  | 2
 | GEOG | 101 | 1 | 1 | 3 |  |  | 5 | 1 | 1 | 1 |  |  | 3 |  | 3 |  |  |  | 3
 |  | 102 | 1 | 3 | 1 |  |  | 5 | 1 | 2 |  |  |  | 3 | 1 | 2 |  | 1 |  | 4
 |  | 111 | 2 | 1 | 1 |  | 1 | 5 | 1 | 1 |  |  |  | 2 | 1 | 1 |  |  |  | 2
 | GOVT | 201 | 2 | 2 | 2 | 1 |  | 7 | 2 | 1 |  |  |  | 3 | 1 | 1 | 1 |  |  | 3
 |  | 301 | 5 | 1 |  |  |  | 6 | 2 | 1 |  |  |  | 3 |  | 2 |  |  |  | 2
 | HIST | 101 | 2 | 3 | 1 | 1 | 1 | 8 |  | 3 |  |  |  | 3 |  | 1 | 2 |  |  | 3
 |  | 102 | 3 | 2 | 1 |  | 1 | 7 | 1 |  | 1 |  |  | 2 |  | 1 |  |  |  | 1
 |  | 121 | 2 | 2 | 2 |  |  | 6 | 3 |  |  |  |  | 3 | 1 | 1 |  |  |  | 2
 |  | 122 | 3 | 2 | 1 |  |  | 6 | 1 | 1 |  |  |  | 2 | 2 | 1 |  |  |  | 3
 |  | 201 | 4 | 1 | 1 |  |  | 6 | 2 | 1 |  |  |  | 3 | 1 | 2 |  |  |  | 3
 |  | 202 | 3 | 1 | 1 |  |  | 5 | 2 | 1 |  |  |  | 3 | 1 | 2 |  |  |  | 3
 |  | 301 | 2 | 2 | 1 |  |  | 5 | 2 | 1 |  |  |  | 3 | 1 | 2 |  |  | 2 | 5
 |  | 320 | 2 |  |  |  |  | 2
 |  | 330 | 4 | 1 |  |  |  | 5 | 3 |  |  |  |  | 3 |  | 2 |  |  |  | 2
 |  | 342 |  |  |  |  |  |  | 1 |  |  |  |  | 1
 |  | 344 |  | 1 |  |  |  | 1 | 1 |  |  |  |  | 1
 |  | 415 | 1 | 2 |  |  |  | 3 | 1 | 1 |  |  |  | 2
 |  | 416 |  | 1 |  |  |  | 1
 |  | 417 |  |  |  |  |  |  |  |  |  |  |  |  | 1 |  |  |  |  | 1
 |  | 435 | 1 | 1 |  |  |  | 2 | 1 |  |  |  |  | 1 | 2 |  |  |  |  | 2
 |  | 455 | 1 |  |  |  |  | 1
 | PHIL | 201 |  |  |  | 1 |  | 1
Social Studies Educ-Grds 6-12 / History Total |  |  | 42 | 30 | 16 | 4 | 3 | 95 | 26 | 17 | 3 |  |  | 46 | 12 | 22 | 5 | 1 | 2 | 42
Spreadsheet: 869265d1715871802-schedule-formula-that-indicates-off-days-test-schedule
Sheet: MAY

INTERNS NAME |  | SUMMER SCHEDULE FOR THE MONTH OF |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | AUGUST |  |  |  | 2024
DATE
Enter "H" For Holiday - Enter "P" for PPED
DAY OF THE WEEK
DAFFY DUCK
1430-2300 | [NAME], Sun
NOTES
[NAME]
0700-1630 | 5/4/9 1st Mon off
NOTES
[NAME]
0800-1730 | 4/10 Fri off
NOTES
BRAD PITT
1530-2400 | 1st Mon, 2nd Mon, and Friday
NOTES
NOTES
NOTES
NOTES
NOTES
NOTES
NOTES
Spreadsheet: b56b9b06-01a3-4629-a4de-1528c5fcdc23
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
[NAME] | Test | [NAME] | Ehrlichia/Anaplasma, Molecular Detection, PCR, Blood | Ehrlichia/Anaplasma PCR, B | Real-Time Polymerase Chain Reaction (PCR)/DNA [NAME] (PCR is utilized pursuant to a license agreement with Roche Molecular Systems, Inc.) | EDTA (lavender-top) tube: EDTA |  |  | 1 | mL | Container/Tube: Lavender top (EDTA) [NAME]: 1 mL Forms: If not ordering electronically, submit a Microbiology Request Form (Supply T244) with the specimen. | 0.3 mL | Hemolysis	Mild OK; Gross OK Thawing	Warm OK; Cold OK Lipemia	Mild OK; Gross reject Icterus	NA Other	Anticoagulants other than EDTA | Negative | Monday through Saturday; Varies | Same day/1 day | 4 days | 1 | 87798 |  |  |  |  | Rochester
[NAME] | [NAME] | WBEDTA | [NAME] EDTA |  |  |  | Refrigerated | 7 days
[NAME] | Result | 84319 | Anaplasma phagocytophilum | Anaplasma phagocytophilum | Alphanumeric |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 30039-2 | Anaplasma phagocytophilum DNA:ACnc:Pt:[NAME]:Ord:Probe.amp.tar
[NAME] | Result | 23663 | Ehrlichia chaffeensis | Ehrlichia chaffeensis | Alphanumeric |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 27994-3 | Ehrlichia chaffeensis DNA:ACnc:Pt:[NAME]:Ord:Probe.amp.tar
[NAME] | Result | 23664 | Ehrlichia ewingii/canis | Ehrlichia ewingii/canis | Alphanumeric |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 48866-8 | Ehrlichia sp DNA:ACnc:Pt:[NAME]:[NAME]:Probe.amp.tar
[NAME] | Result | 32010 | Ehrlichia muris-like | Ehrlichia muris-like | Alphanumeric |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 48866-8 | Ehrlichia sp DNA:ACnc:Pt:[NAME]:[NAME]:Probe.amp.tar
Spreadsheet: 149592d1334040964-counting-dates-copy_sample-pcr2
Sheet: Daily Summary (2)

 |  |  |  |  |  |  |  |  |  | Summary
 |  |  |  |  |  | Feb |  | 01 | 02 | 03 | 04 | 05 | 06 | 07 | 08 | 09 | 10 | 11 | 12 | 13 | 14 | 15 | 16 | 17 | 18 | 19 | 20 | 21 | 22 | 23 | 24 | 25 | 26 | 27 | 28 | 29 | 30 | 31
 |  |  |  |  |  |  |  | 01 | 02 | 03 | 04 | 05 | 06 | 07 | 08 | 09 | 10 | 11 | 12 | 13 | 14 | 15 | 16 | 17 | 18 | 19 | 20 | 21 | 22 | 23 | 24 | 25 | 26 | 27 | 28 | 29 | 30 | 31
 |  |  |  |  |  |  |  | Jan | Feb | Mar | Apr | May | Jun | Jul | Aug | Sep | Oct | Nov | Dec | 2012 | 一月 | 二月 | 三月 | 四月 | 五月 | 六月 | 次月 | 八月 | 九月 | 十月 | [NAME] | 十二月
Total Entries
Entries with [NAME]
 |  |  |  | Jan | Feb | Mar
 | Correct figures: | Total entries |  | 216 | 211 | 287
 |  | Entries with [NAME] |  | 193 | 203 | 281
Spreadsheet: 858750d1707318075-formula-to-duplicate-cell-value-formula-example
Sheet: Sheet1

Desired input |  |  |  | Desired Output
Location | RWS Dates |  |  | Description | Week Ending | Location
Z1 | 1/12/2024 |  |  | RWS | 2024-01-12 00:00:00 | F7
F7 | 1/12/2024 |  |  | RWS Vacation | 2024-01-12 00:00:00 | F7
 |  |  |  | RWS | 2024-01-12 00:00:00 | Z1
 |  |  |  | RWS Vacation | 2024-01-12 00:00:00 | Z1