tianzl66/Sheetpedia huggingface dataset:
Spreadsheet: daren_farmer__5213__BMSPT041
Sheet: BMSPT066

BAMMEL STORAGE ACTIVITY
VOLUME SPLIT BY Counterparties
2001-04-01 00:00:00 |  |  |  |  |  |  |  |  |  |  | SWING CONTRACT VOLUMES |  |  |  |  | ECT LONG/(SHORT) |  |  |  | LONG/(SHORT)
 |  | HPL INDEX |  |  | HPL FIXED PRICE |  |  |  |  | TOTAL | HL&P | CP&L | TUFCO | TOTAL |  | ECT FIRST OF THE MONTH | TUFCO/ HL&P/ CP&L SWING VOLUME | ECT LONG OR (SHORT) |  | ECT TOTAL | HPLC Excluding 3rd Party | Net LONG/ (SHORT)
 |  | MTD Adjustment | CURRENT DAY | Total | MTD Adjustment | CURRENT DAY | Total | 3rd Party | HPLC Total |  | 0 | 0 |  |  |  |  |  |  |  |  |  |  | Reinject Fees
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | Injected Volume | Value
Beginning Balance
1 | Scheduled |  |  |  |  |  |  |  |  |  | 0 | 0
 | Scheduled
 | Scheduled
 | Scheduled
 | Scheduled
 | Scheduled
 | Scheduled
 | Scheduled
 | Scheduled
 | Scheduled
 | Scheduled
 | Scheduled
 | Scheduled
 | Scheduled
 | Scheduled
 | Scheduled
 | Scheduled
 | Scheduled
 | Scheduled
 | Scheduled
 | Scheduled
 | Scheduled
 | Scheduled
 | Scheduled
 | Scheduled
 | Estimated
 | Estimated
 | Projected
 | Projected
 | Projected
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | Index: | 0
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | Fuel: | 0.01
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | Fuel Rate:
Ending Balance |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | Prod.[NAME]:
Variances:
Total Projected
March 31 thru April 6
April 7 thru April 13 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | Previous Position: |  | 682656
April 14 thru April 20 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | [NAME]:
April 21 thru April 27
Spreadsheet: 867384d1714212627-calculation-of-scheme-amount-with-different-scheme-slab-not-dont-cross-that-eligible-amt-test
Sheet: Sheet2 (2)

 |  |  |  |  |  |  |  | 0
 |  |  |  | 0.08 | 0.075 | 0.07 | 0.065
Sum of TOTAL | 982633790.1199995 | 671955610.5800002 | 546296447.9599998 | 84500662.15000002 | 302248132.05 | 191057845.31 | 94148971.07000002 | -4.220055416226387e-10
CustNo | Total Inv Value | Total Collection | Eligible collection | Scheme 1 | Scheme 2 | Scheme 3 | Scheme 4 | Grand Total
3723231 | 133078.66 | 144148.43 | 133078.66 | 0 | 144148.43 | 0 | 0 | 0
3712685 | 9579808.689999996 | 15391330.48 | 9579808.689999996 | 0 | 0 | 3491330.479999997 | 11900000 | 0
3712716 | 2794469.03 | 2976153.52 | 2794469.03 | 1476153.52 | 1000000 | 500000 | 0 | 0
3712858 | 2488904.630000003 | 1760332.569999999 | 1760332.569999999 | 1107706.58 | 652625.9899999993 | 0 | 0 | 0
3712889 | 1453835.23 | 3358681.43 | 1453835.23 | 2358681.43 | 0 | 0 | 1000000 | 0
3712893 | 7688316.360000001 | 9583477.879999999 | 7688316.360000001 | 283477.879999999 | 6000000 | 1300000 | 2000000 | 0
3712923 | 3142179.65 | 4732786.500000001 | 3142179.65 | 1531867.94 | 1100918.560000001 | 2100000 | 0 | -4.656612873077393e-10
3712926 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0
3712935 | 31804675.61000001 | 61251935.14 | 31804675.61000001 | 6051935.139999999 | 35100000 | 20100000 | 0 | 0
Spreadsheet: 837659d1690333985-conditional-formatting-from-a-separate-range-roster-template-2023-07-25
Sheet: G1

Date: |  | 2023-07-15 00:00:00 |  |  | Field: | 3 |  | Start Time: |  | 11:30:00
Home: |  | SYB 8U All Star Black |  |  | 3rd | Set Up
Visitors: |  | CBDL - Rockets Blue |  |  | 1st | Clean Up
 |  |  |  |  | Inning
 |  | Player |  |  | Coach Pitch |  |  |  |  |  | Innings on Bench | Innings in Infield | Inninings in Outfield
Order |  | First | Last | # | 1 | 2 | 3 | 4 | 5 | 6
1 | 12 |  |  |  |  |  |  |  |  |  |  |  |  |  | P (1)
2 | 11 | Player 2 |  |  |  |  |  |  |  |  |  |  |  |  | C (2)
3 | 1 |  | Last Name 10 |  |  |  |  |  |  |  |  |  |  |  | 1B (3)
4 | 2 |  |  |  |  |  |  |  |  |  |  |  |  |  | 2B (4)
5 | 4 |  |  |  |  |  |  |  |  |  |  |  |  |  | 3B (5)
6 | 5 |  |  |  |  |  |  |  |  |  |  |  |  |  | SS (6)
7 | 10 |  |  |  |  |  |  |  |  |  |  |  |  |  | LF (7)
8 | 9 |  |  |  |  |  |  |  |  |  |  |  |  |  | CF (8)
9 | 6 |  |  |  |  |  |  |  |  |  |  |  |  |  | RF (9)
10 | 7 |  |  |  |  |  |  |  |  |  |  |  |  |  | SF (10)
11 | 8 |  |  |  |  |  |  |  |  |  |  |  |  |  | EH ()
12 | 8 |  |  |  |  |  |  |  |  |  |  |  |  |  | LCF ()
13 | 8 |  |  |  |  |  |  |  |  |  |  |  |  |  | [NAME] ()
Out
 | 9
 | 9
Notes:
 |  |  |  | Players on [NAME]
 |  | Only pull a players first name from the drop down
Spreadsheet: 75311d1275904140-order-horizontal-lines-by-skipping-empty-cells-example
Sheet: Sheet1

1 | RICHARD | *** | *** | *** |  | RICHARD | RICHARD | RICHARD | RICHARD
2 | *** | TOM | MIKE | *** |  | TOM | MIKE | TOM | MIKE
3 | SANDRA | SAM | [NAME] | [NAME] |  | SANDRA | SAM | [NAME] | [NAME]
4 | *** | *** | PETER | *** |  | PETER | PETER | PETER | PETER
5 | [NAME] | NICK | *** | STEVE |  | [NAME] | NICK | STEVE | [NAME]
Spreadsheet: 790842d1660027254-the-number-of-unique-values-in-a-matrix-number-of-unique-values-hd
Sheet: Sheet1

Column1 | Column2 | Column3 | Column4 | Column5 | Column6 | Column7 | Column8 | Column9 | Column10 | Column11 | Column12
emphasis | garbage | mud | feedback | accident | method | lake | gene | addition | cheek | library | addition
suggestion | worker | depth | teaching | meat | relation | birthday | pie | tradition | lake | addition | setting
audience | depth | income | physics | wife | wife | guest | community | birthday | physics | medicine | intention
community | wife | variation | historian | chest | meat | wife | article |  | meat | guest | photo
outcome | method | birthday | garbage | mud | variation | scene | equipment | garbage | article | accident | feedback
coffee | depth | gene | birthday | depth | language | river | language | medicine | photo | intention | garbage
pie | depth | user | garbage | garbage | accident | tradition | teaching | bonus | photo | scene | variation
pie | scene | relation |  | outcome | feedback | historian | feedback | physics | mud | gene | sympathy
article | intention | meat | language | addition | article | article | worker | equipment | user | marketing | wife
accident | marketing | tradition | chest | river | method | scene | chest | pie | sympathy | series | outcome
tradition | pie | bonus | birthday | teaching | disease | coffee | variation | photo | cheek | intention | guest
variation | sympathy | scene | feedback | worker | series | gene | lake | coffee | equipment | feedback | pie
#[NAME] values in A1:L12
 | please add other solutions, preferably simpler ones
Table1
46
Spreadsheet: chris_stokley__3921__0401 PGES Final
Sheet: Total

 |  | EPMI Charges To Customers |  |  |  |  |  |  | Total EPMI
Trans Type | (CAISO 0701 M) |  |  |  |  |  |  |  | Trans Type | (CAISO 0701 M)
 |  |  |  | Data |  |  |  |  |  |  | Data
Customer | ID | Desc. | SchedType | Expense | Revenue | Total | Volume |  | ID | Desc. | Expense | Revenue | Total | Volume
PGES | 111 | Spinning Reserve due ISO | PRA | -74395.7775 | 71951.3952 | -2444.3823 | -163.4612999999999 |  | 111 | Spinning Reserve due ISO | -71951.3952 | 74395.7775 | -2444.3823 | -163.4612999999999
 | 112 | Non -Spinning Reserve due [NAME] | PRA | -59999.58899999999 | 56528.3373 | -3471.251699999986 | -194.5192 |  | 112 | Non -Spinning Reserve due [NAME] | -56528.3373 | 59999.58899999999 | -3471.251699999986 | -194.5192
 | 114 | Replacement Reserves Due ISO | PRA | -3978.6826 | 16142.303 | 12163.62039999999 | -99.4625 |  | 114 | Replacement Reserves Due ISO | -16142.303 | 3978.6826 | 12163.62039999999 | -99.4625
 | 115 | Regulation UP due ISO | PRA | -1048.654500000001 | 918.3386000000004 | -130.3159 | 24.93459999999999 |  | 115 | Regulation UP due ISO | -918.3386000000004 | 1048.654500000001 | -130.3159 | 24.93459999999999
 | 116 | Regulation Down Due ISO | PRA | -191.781 | 626.3095000000003 | 434.5285 | -21.4086 |  | 116 | Regulation Down Due ISO | -626.3095000000003 | 191.781 | 434.5285 | -21.4086
 | 406 | UFE | PRA | -11924.7343 | 1299.4562 | -10625.2781 | 73.53350000000003 |  | 406 | UFE | -1299.4562 | 11924.7343 | -10625.2781 | 73.53350000000003
 | 487 | Allocation Excess Cost for IE | PRA | -412.32 | 210.57 | -201.75 | 0 |  | 487 | Allocation Excess Cost for IE | -210.57 | 412.32 | -201.75 | 0
 | 523 | Market Operations Charge | PRA | -38.21390000000001 | 173.9464 | 135.7325 | -142.6578159853916 |  | 523 | Market Operations Charge | -173.9464 | 38.21390000000001 | 135.7325 | -142.6578159853916
 | 1010 | Neutrality Adj | PRA | -432.3279000000001 | 2679.686199999999 | 2247.3583 | -902.2666 |  | 1010 | Neutrality Adj | -2679.686199999999 | 432.3279000000001 | 2247.3583 | -902.2666
 | 1011 | AS Rational Buyer Adj. | PRA | -112862.2157 | 101340.7345 | -11521.4812 | 223616.823 |  | 1011 | AS Rational Buyer Adj. | -101340.7345 | 112862.2157 | -11521.4812 | 223616.823
 | 1030 | No Pay Market Refund | PRA | -5.709100000000001 | 4.815400000000001 | -0.8936999999999997 | -0.1257 |  | 1030 | No Pay Market Refund | -4.815400000000001 | 5.709100000000001 | -0.8936999999999997 | -0.1257
 | 1210 | Existing Contract Neu Adj | PRA | -8928.713800000001 | 5638.932700000001 | -3289.781099999999 | -271229.6831 |  | 1210 | Existing Contract Neu Adj | -5638.932700000001 | 8928.713800000001 | -3289.781099999999 | -271229.6831
PGES Total |  |  |  | -274218.7193000001 | 257514.825 | -16703.8943 | -49038.29371598538 |  | Grand Total |  | -257514.825 | 274218.7193000001 | -16703.8943 | -49038.29371598538
Grand Total |  |  |  | -274218.7193000001 | 257514.825 | -16703.8943 | -49038.29371598538
 |  |  |  |  |  |  |  |  |  |  |  |  | -6072089.01
Spreadsheet: 466022d1465986220-how-to-do-addtion-in-pivot-and-make-it-decnding-order-sort
Sheet: Sheet4

Count of REMARKS | Column Labels
Row Labels | BEARISH | BULLISH | Grand Total
YESBANK | 8 | 1 | 9
INFY | 9 |  | 9
AXISBANK | 8 |  | 8
RECLTD | 1 | 7 | 8
SBIN |  | 8 | 8
HDFC | 7 |  | 7
HEROMOTOCO | 7 |  | 7
SYNDIBANK |  | 7 | 7
MARUTI | 6 |  | 6
CAIRN | 6 |  | 6
BANKBARODA | 1 | 5 | 6
COALINDIA | 6 |  | 6
LICHSGFIN | 4 | 2 | 6
[NAME] |  | 6 | 6
PNB |  | 6 | 6
BHARTIARTL | 6 |  | 6
RELIANCE | 5 | 1 | 6
TCS | 6 |  | 6
UPL | 5 | 1 | 6
IBREALEST |  | 6 | 6
TATAMOTORS |  | 6 | 6
ICICIBANK |  | 6 | 6
TECHM | 6 |  | 6
ASHOKLEY | 6 |  | 6
AUROPHARMA | 3 | 3 | 6
KPIT | 6 |  | 6
ITC |  | 6 | 6
TITAN |  | 5 | 5
ONGC | 5 |  | 5
M&M | 5 |  | 5
DLF |  | 5 | 5
PFC | 1 | 4 | 5
[NAME] |  | 5 | 5
WIPRO | 3 | 2 | 5
HINDPETRO | 5 |  | 5
NTPC | 5 |  | 5
IDEA | 5 |  | 5
PETRONET |  | 5 | 5
IFCI |  | 5 | 5
TATAGLOBAL | 5 |  | 5
JUSTDIAL |  | 5 | 5
UNIONBANK |  | 5 | 5
ASIANPAINT | 5 |  | 5
BPCL | 5 |  | 5
ADANIPORTS |  | 5 | 5
LT | 5 |  | 5
CROMPGREAV |  | 4 | 4
WOCKPHARMA | 1 | 3 | 4
RPOWER |  | 4 | 4
HCLTECH | 4 |  | 4
KOTAKBANK | 4 |  | 4
HINDUNILVR | 4 |  | 4
POWERGRID | 3 | 1 | 4
APOLLOTYRE |  | 4 | 4
TATASTEEL |  | 4 | 4
IDBI |  | 4 | 4
AMBUJACEM | 4 |  | 4
IGL |  | 4 | 4
L&TFH |  | 4 | 4
INDUSINDBK | 4 |  | 4
[NAME] |  | 4 | 4
INFRATEL | 2 | 2 | 4
RELCAPITAL |  | 4 | 4
ADANIENT |  | 4 | 4
SUNPHARMA |  | 4 | 4
JINDALSTEL |  | 4 | 4
BHEL |  | 4 | 4
JISLJALEQS | 3 | 1 | 4
ZEEL | 4 |  | 4
JUBLFOOD |  | 4 | 4
NMDC | 1 | 3 | 4
SKSMICRO | 3 |  | 3
ALBK |  | 3 | 3
DRREDDY | 3 |  | 3
JSWSTEEL | 3 |  | 3
VEDL |  | 3 | 3
ANDHRABANK |  | 3 | 3
SRTRANSFIN | 2 | 1 | 3
IBULHSGFIN | 2 | 1 | 3
TATAMTRDVR |  | 3 | 3
ARVIND | 2 | 1 | 3
UNITECH |  | 3 | 3
KSCL | 3 |  | 3
IRB | 3 |  | 3
HDFCBANK | 2 | 1 | 3
SRF | 3 |  | 3
[NAME] | 1 | 2 | 3
SUNTV |  | 3 | 3
GRANULES | 1 | 2 | 3
BHARATFORG | 1 | 2 | 3
DABUR |  | 3 | 3
TATAPOWER | 3 |  | 3
ORIENTBANK |  | 3 | 3
ULTRACEMCO | 3 |  | 3
CIPLA |  | 3 | 3
BIOCON | 3 |  | 3
HDIL |  | 3 | 3
VOLTAS | 1 | 2 | 3
JETAIRWAYS |  | 3 | 3
BANKINDIA |  | 3 | 3
AJANTPHARM | 1 | 2 | 3
UCOBANK |  | 2 | 2
NCC |  | 2 | 2
GLENMARK | 2 |  | 2
BAJFINANCE | 2 |  | 2
HINDALCO | 2 |  | 2
[NAME] | 2 |  | 2
CASTROLIND | 2 |  | 2
SAIL |  | 2 | 2
BAJAJ-AUTO | 2 |  | 2
CUMMINSIND |  | 2 | 2
NHPC |  | 2 | 2
M&MFIN | 1 | 1 | 2
HAVELLS | 1 | 1 | 2
ADANIPOWER |  | 2 | 2
DHFL |  | 2 | 2
HEXAWARE | 2 |  | 2
[NAME] | 2 |  | 2
BEL | 1 | 1 | 2
KTKBANK |  | 1 | 1
TVSMOTOR | 1 |  | 1
JPASSOCIAT |  | 1 | 1
BATAINDIA |  | 1 | 1
APOLLOHOSP |  | 1 | 1
SIEMENS | 1 |  | 1
IDFC | 1 |  | 1
CENTURYTEX |  | 1 | 1
TV18BRDCST |  | 1 | 1
SOUTHBANK |  | 1 | 1
STAR |  | 1 | 1
COLPAL | 1 |  | 1
FEDERALBNK |  | 1 | 1
CEATLTD | 1 |  | 1
PCJEWELLER |  | 1 | 1
PTC |  | 1 | 1
[NAME] |  | 1 | 1
IOC | 1 |  | 1
PIDILITIND | 1 |  | 1
ENGINERSIN |  | 1 | 1
ACC | 1 |  | 1
TATACHEM | 1 |  | 1
MOTHERSUMI | 1 |  | 1
Grand Total | 258 | 263 | 521
Spreadsheet: 124373d1318354819-conditional-formatting-based-on-the-file-save-date-sample-form
Sheet: Data

 | Mkt 1 |  | Visit Type Choices |  | Disposition Choices |  | Visit Number
 | Mkt 1 |  | Visit A |  | Disp 1 |  | 1
 | Mkt 1 |  | Visit B |  | Disp 2 |  | 2
 | Mkt 1 |  | Visit C |  | Disp 3 |  | 3
 | Mkt 1 |  |  |  | Disp 4
 | Mkt 1 |  | GC Amount |  | Disp 5 |  | Bonus
 | Mkt 1 |  | 1 |  | Disp 6 |  | Yes
 | Mkt 1 |  | 2 |  | Disp 7 |  | No
 | Mkt 1 |  | None |  | Disp 8
 | Mkt 1 |  |  |  | Disp 9 |  | GEN?
 | Mkt 1 |  |  |  | Disp 10
 | Mkt 1 |  |  |  | Dis 11 |  | Yes
 | Mkt 1 |  |  |  | Disp 12
 | Mkt 1 |  |  |  | Disp 13
 | Mkt 1
 | Mkt 1 |  | MR |  | SIPVC WI
 | Mkt 1 |  | [NAME] |  | Yes
 | Mkt 1 |  | [NAME] |  | No
 | Mkt 1 |  | [NAME]
 | Mkt 1 |  | [NAME]
 | Mkt 1 |  | [NAME]
 | Mkt 1 |  | [NAME]
 | Mkt 1 |  | [NAME]
 | Mkt 1 |  | [NAME]
 | Mkt 1 |  | [NAME] |  | Last Save Date
 | Mkt 1 |  | [NAME] |  | 2011-10-06 13:10:31
 | Mkt 1 |  | [NAME]
 | Mkt 1 |  | [NAME]
 | Mkt 1 |  | [NAME]
 | Mkt 1 |  | [NAME]
 | Mkt 1 |  | [NAME]
 | Mkt 1 |  | [NAME] |  | #N/A
 | Mkt 1 |  | [NAME]
 | Mkt 1 |  | [NAME]
 | Mkt 1 |  | [NAME]
 | Mkt 1 |  | [NAME]
 | Mkt 1 |  | [NAME]
 | Mkt 1 |  | [NAME]
 | Mkt 1 |  | [NAME]
 | Mkt 1 |  | [NAME]
 | Mkt 1 |  | [NAME]
 | Mkt 1 |  | [NAME]
 | Mkt 1 |  | [NAME]
 | Mkt 1 |  | [NAME]
 | Mkt 1 |  | [NAME]
 | Mkt 1 |  | [NAME]
 | Mkt 1 |  | [NAME]
 | Mkt 1 |  | [NAME]
 | Mkt 1 |  | [NAME]
 |  |  | [NAME]
 |  |  | [NAME]
 |  |  | [NAME]
 |  |  | [NAME]
 |  |  | [NAME]
 |  |  | [NAME]
 |  |  | [NAME]
 |  |  | [NAME]
 |  |  | [NAME]
 |  |  | [NAME]
 |  |  | [NAME]
 |  |  | [NAME]
 |  |  | [NAME]
 |  |  | [NAME]
 |  |  | [NAME]
 |  |  | [NAME]
 |  |  | [NAME]
Spreadsheet: 848013d1698830790-finding-latest-publication-date-that-conatins-data-finding_max_publication_date
Sheet: Sheet1

 |  |  |  |  |  |  | Value | Date
 |  |  |  |  |  |  |  | 01.10.2023 |  |  | Answer should be |  | 2023-09-01 00:00:00
 |  |  |  |  |  |  | 30.810961 | 01.09.2023
 |  |  |  |  |  |  | 30.469743 | 01.08.2023
 |  |  |  |  |  |  | 30.890926 | 01.07.2023
 |  |  |  |  |  |  | 29.939593 | 01.06.2023
 |  |  |  |  |  |  | 28.761806 | 01.05.2023
 |  |  |  |  |  |  | 28.764684 | 01.04.2023
 |  |  |  |  |  |  | 27.953041 | 01.03.2023
 |  |  |  |  |  |  | 28.919763 | 01.02.2023
 |  |  |  |  |  |  | 28.334813 | 01.01.2023
 |  |  |  |  |  |  | 28.316901 | 01.12.2022
 |  |  |  |  |  |  | 28.378949 | 01.11.2022
 |  |  |  |  |  |  | 27.080767 | 01.10.2022
Spreadsheet: 113864d1309758749-adding-two-hours-to-a-format-that-isnt-classified-as-a-time-channels
Sheet: EXAMPLE OF +2

Example of +2
So the original looks like this, say.
19/06/2011 | 30 | 5 | 06:00:00:00AM | 11:58:59:00PM | 06:18:54:00AM | XTRAI | 9 | XTRAI | ARENA | 99 | I1-N | AI6
20/06/2011 | 30 | 3 | 10:30:00:00PM | 11:29:59:00PM | 10:46:23:00PM | XTRAI | 3 | XTRAI | ARENA |  | I1-N | AI7
And I was to see the originals PLUS the +2 channels under it:
19/06/2011 | 30 | 5 | 06:00:00:00AM | 11:58:59:00PM | 06:18:54:00AM | XTRAI | 9 | XTRAI | ARENA | 99 | I1-N | AI6
20/06/2011 | 30 | 3 | 10:30:00:00PM | 11:29:59:00PM | 10:46:23:00PM | XTRAI | 3 | XTRAI | ARENA |  | I1-N | AI7
19/06/2011 | 30 | 5 | 00:00:00:00AM | 11:58:59:00PM | 08:18:54:00AM | XTRAI | 9 | XTRAI | ARENA2 | 99 | I1-N | AI6
20/06/2011 | 30 | 3 | 10:30:00:00PM | 11:29:59:00PM | 12:46:23:00AM | XTRAI | 3 | XTRAI | ARENA2 |  | I1-N | AI7
 |  |  |  |  | Notice when this +2 it changes from PM to AM (F17 to F19), as it turns to a new day, which may mean (annoyingly) the date may need changing...
Spreadsheet: 600097d1543463487-enter-data-based-on-2-different-cells-2-columns-different-sheets-grading-excel-form
Sheet: T4 Directing

First name | Surname | ID number | Institution | Department | Email address | Attendance: Attendance | Assignment: Professionalism | Assignment: Lesson 1: 25 Step Script Breakdown Assignment  25步剧本分解法课后作业 | Assignment: [NAME] 2: Advanced Blocking Assignment  高阶调度课后作业 | Assignment: Lesson 3: Using 2 Cameras: Deconstructing a Short Film" Assignment 双机位拍摄：短片解读 课后作业 | Assignment: Lesson 5: Directing Actors Assignment 指导演员课后作业 | Course total
[NAME] ([NAME]) | [NAME] |  |  |  | [EMAIL] | 9.5 | 8 | 17 | 18 | 16 | 17 | 85.5
Qiran ([NAME]) | [NAME] |  |  |  | [EMAIL] | 9.5 | 4 | 16 | 0 | 0 | 0 | 29.5
Muxin | [NAME] |  |  |  | [EMAIL] | 6 | 5 | 16 | 0 | 0 | 16 | 43
[NAME] ([NAME]) | [NAME] |  |  |  | [EMAIL] | 4.5 | 5 | 15 | 12 | 0 | 0 | 36.5
Yiming ([NAME]) | [NAME] |  |  |  | [EMAIL] | 5 | - | - | - | - | 0 | 5
[NAME] ([NAME]) | Fang |  |  |  | [EMAIL] | 8 | 7 | 13 | 17 | 14 | 0 | 59
Qianyun (Fay) | Fang |  |  |  | [EMAIL] | 9 | 8 | 12 | 15 | 0 | 18 | 62
Yichao | Fu |  |  |  | [EMAIL] | 7.5 | 8 | 16 | 15 | 17 | 17 | 80.5
Junjie (Riol) | He |  |  |  | [EMAIL] | 6 | 6 | 12 | 0 | 0 | 16 | 40
Jiaqing (Agnes) | Kang |  |  |  | [EMAIL] | 7 | 8 | 16 | 19 | 18 | 0 | 68
Yuetong (Isabel) | [NAME] |  |  |  | [EMAIL] | 6.67 | - | - | - | - | - | 6.67
[NAME]) | [NAME] |  |  |  | [NAME] | 9.5 | 6 | 17 | 16 | 0 | 0 | 48.5
[NAME] (Klader) | [NAME] |  |  |  | [EMAIL] | 9 | 8 | 18 | 17 | 19 | 0 | 71
Ruimin (Vic) | [NAME] |  |  |  | [EMAIL] | 9 | 8 | 14 | 16 | 0 | 15 | 62
[NAME]) | [NAME] |  |  |  | [EMAIL] | 10 | 8 | 12 | 16 | 0 | 15 | 61
[NAME]Seven ） | Qi |  |  |  | [EMAIL] | 6.67 | - | - | - | - | - | 6.67
Junqi (Voang) | [NAME] |  |  |  | [EMAIL] | 0 | - | - | - | - | - | 0
[NAME]） | Xiao |  |  |  | [EMAIL] | 5 | - | - | - | - | - | 5
[NAME] (Leo) | [NAME] |  |  |  | [EMAIL] | 8.89 | 8 | 14 | 16 | 0 | 14 | 60.89
Chenyi (Freddie) | Zhang |  |  |  | [EMAIL] | 10 | 5 | 13 | 14 | 0 | 0 | 42
Linfeng (Wayne) | Zhang |  |  |  | [EMAIL] | 9.5 | 8 | 18 | 16 | 13 | 15 | 79.5
[NAME] (Vlad) | [NAME] |  |  |  | [EMAIL] | 10 | 8 | 13 | 14 | 13 | 15 | 73
Xinwei (Will) | [NAME] |  |  |  | [EMAIL] | 10 | 8 | 15 | 15 | 13 | 15 | 76
Hui ([NAME]) | Zhu |  |  |  | [EMAIL] | 6 | 5 | 15 | 0 | 0 | 0 | 26
Spreadsheet: dutch_quigley__9380__bp
Sheet: Sheet1

 | BP Corp
 | 2001-12-01 00:00:00 | -497.33274323
 | 2002-01-01 00:00:00 | -1285.46494935
 | 2002-02-01 00:00:00 | -925.92532459
 | 2002-03-01 00:00:00 | -1087.92688759
 | 2002-04-01 00:00:00 | -698.27081073
 | 2002-05-01 00:00:00 | -729.26770362
 | 2002-06-01 00:00:00 | -831.56355276
 | 2002-07-01 00:00:00 | -797.31850981
 | 2002-08-01 00:00:00 | -795.73672736
 | 2002-09-01 00:00:00 | -746.25183394
 | 2002-10-01 00:00:00 | -727.35149135
 | 2002-11-01 00:00:00 | -268.95750933
 | 2002-12-01 00:00:00 | -281.38967873
 | 2003-01-01 00:00:00 | -157.67659284
 | 2003-02-01 00:00:00 | -328.72513407
 | 2003-03-01 00:00:00 | -363.97062425
 | 2003-04-01 00:00:00 | -319.09332118
 | 2003-05-01 00:00:00 | -328.78088315
 | 2003-06-01 00:00:00 | -317.19911155
 | 2003-07-01 00:00:00 | -326.76288309
 | 2003-08-01 00:00:00 | -325.68144625
 | 2003-09-01 00:00:00 | -314.1008858
 | 2003-10-01 00:00:00 | -323.47043168
 | 2003-11-01 00:00:00 | -139.28720082
 | 2003-12-01 00:00:00 | -143.41573664
 | 2004-01-01 00:00:00 | -39.82529087
 | 2004-02-01 00:00:00 | -37.11080089
 | 2004-03-01 00:00:00 | -39.52202495
 | 2004-04-01 00:00:00 | -10.32853718
 | 2004-05-01 00:00:00 | -10.63113764
 | 2004-06-01 00:00:00 | -10.24577426
 | 2004-07-01 00:00:00 | -10.54462495
 | 2004-08-01 00:00:00 | -10.50034951
 | 2004-09-01 00:00:00 | -10.11811558
 | 2004-10-01 00:00:00 | -10.41174785
 | 2004-11-01 00:00:00 | 20.22607269
 | 2004-12-01 00:00:00 | 20.81089959
Spreadsheet: 412820e3-d7be-4d8c-8277-ff0ae97a18d3
Sheet: Sheet1

Permit No.: | Unnamed: 1 | Unnamed: 2 | WQ0014091 | Unnamed: 4 | Unnamed: 5 | Facility Name: | Unnamed: 7 | White Oak Trailer Wash Facility | Unnamed: 9 | Unnamed: 10 | Unnamed: 11 | Unnamed: 12 | Unnamed: 13 | County: | Duplin | Unnamed: 16 | Month: | Unnamed: 18 | Unnamed: 19 | Year: | Unnamed: 21
Did irrigation occur    at this facility? |  |  |  |  |  | Field Name: |  | 1 |  | Field Name: |  | 2 |  | Field Name: |  | 3 |  | Field Name: |  | 4
 |  |  |  |  |  | Area (acres): |  | 2.22 |  | Area (acres): |  | 3.56 |  | Area (acres): |  | 3.81 |  | Area (acres): |  | 3.94
 |  |  |  |  |  | Cover Crop: |  |  |  | Cover Crop: |  |  |  | Cover Crop: |  |  |  | Cover Crop:
 |  |  |  |  |  | [NAME] (in): |  | 0.75 |  | [NAME] (in): |  | 0.75 |  | [NAME] (in): |  | 0.75 |  | [NAME] (in): |  | 0.75
 |  |  |  |  |  | Annual Rate (in): |  | 10.45 |  | Annual Rate (in): |  | 10.45 |  | Annual Rate (in): |  | 10.45 |  | Annual Rate (in): |  | 10.45
Day | Weather |  |  | Freeboard |  | Field Irrigated? |  |  |  | Field Irrigated? |  |  |  | Field Irrigated? |  |  |  | Field Irrigated?
 | Weather Code | Temperature | Precipitation | Storage | 5-Day Upset (if applicable) | 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 | Volume Applied | Time   Irrigated | Daily   Loading | Maximum Hourly Loading
 |  | ºF | in | ft | ft | gal | min | in | in | 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:
12 Month Floating Total (in):
Spreadsheet: 47071d1245964558-sumif-multiple-worksheets-add-all-cells-adjacent-to-cell-w-value-matching-query-kor-cart-quotas
Sheet: RAH - CS-SPD OR PACKS #2

K-BRO LINEN SYSTEMS - EDMONTON  PLANT
CS/SPD OR PACKS #2
FACILITY: | ROYAL ALEXANDRA HOSPITAL
Date:
 | SUNDAY | MONDAY | TUESDAY | WEDNESDAY | THURSDAY | FRIDAY | SATURDAY | STATS
DELIVERY DAYS: | X | X | X | X | X
[NAME] |  |  |  | PACK # |  | QUOTA | SHELF | REC | +/-/HOLD
LAPAROTOMY PACK |  |  |  | CP0005 |  | 8
LG SPLIT PACK |  |  |  | CP0006 |  | 16
SM SPLIT PACK |  |  |  | CP0007 |  | 3
BASIC PACK |  |  |  | CP0008 |  | 9
T.U.R. PACK |  |  |  | CP0013 |  | 1
MAJOR LITHOTOMY PACK |  |  |  | CP0002 |  | 1
LITHOTOMY PACK |  |  |  | CP0010 |  | 8
CHEST/BREAST PACK |  |  |  | CP0018 |  | 3
MAYO COVER |  |  |  | SP0003 |  | 7
SM SPLIT DRAPE |  |  |  | SP0009 |  | 1
LG SPLIT DRAPE |  |  |  | SP0010 |  | 10
LAP DRAPE |  |  |  | SP0018 |  | 1
HALF SHEET |  |  |  | SP0015 |  | 18
3/4 SHEET |  |  |  | SP0020 |  | 3
MED BARRIER |  |  |  | SP0016 |  | 6
TABLE COVER |  |  |  | SP0019 |  | 35
LG TABLE COVER |  |  |  | SP0037 |  | 1
45" WRAPPERS |  |  |  | SP0032 |  | 3
All changes or additions to this order must be faxed in to (780) 451-5788 before 07:30 a.m. the day of delivery.
UPDATED:
June 17th 2009
Spreadsheet: 132863d1323984195-hyperlink-to-take-me-on-a-worksheet-when-selected-sample
Sheet: total

TOTALS | group 6400-6449
RO | VEHICLE | DATE IN | DATE OUT | TOTAL COST | DEDUCT | CUST PAY
6400