tianzl66/Sheetpedia huggingface dataset:
Spreadsheet: 713231d1610611329-help-with-a-formula-to-average-if-cell-value-appears-in-one-of-two-columns-average-when-looking-at-a-table-with-data-in-two-rows-ii
Sheet: Sheet1

 | America Mineiro
 | Avai
 | Botafogo SP
 | Brazil de Pelotas
 | Chapecoense
 | Confianca
 | CRB
 | Cruzeiro
 | CS Alagoano
 | Cuiaba
 | Figueirense
 | Guarani SP
 | [NAME]
 | Nautico
 | Oeste
 | [NAME]
 | Parana
 | [NAME]
 | [NAME]
 | Vitoria
 |  | I need a formula to find the average of the numbers in column C: of Oeste's (cell B1) games  within the table below, but with the following conditions
 |  | If [NAME] appears in Column A, use the value in the equivalent cell in column C
 |  | If instead [NAME] appears in Column B, use the value *-1 of the equivalent cell in column C
 |  | Therefore it should be the average of the following numbers:
 | 0.06 | vs Chapecoense from row 19
 | -1.02 | vs CRB on row 28
 | 0.76 | vs Brazil de Pelotas on row 33
 | -0.84 | vs [NAME] on row 40
 |  | AVERAGE of those numbers
Confianca | Parana | 1.432
[NAME] | CRB | 1.272
[NAME] | Figueirense | 0.7179999999999999
Vitoria | [NAME] | 0.7879999999999998
Avai | Nautico | 0.692
Cruzeiro | Botafogo SP | 0.2669999999999999
CS Alagoano | Guarani SP | -0.365
[NAME] | America Mineiro | -0.5469999999999999
Oeste | Chapecoense | 0.057 | [NAME]
Botafogo SP | Confianca | -0.03500000000000003
Brazil de Pelotas | [NAME] | -0.9469999999999998
[NAME] | [NAME] | -0.09400000000000008
Guarani SP | Cruzeiro | -1.038
Parana | Avai | -0.04400000000000004
Nautico | [NAME] | 0.264
Figueirense | Vitoria | -0.008000000000000007
America Mineiro | Cuiaba | -0.4739999999999999
CRB | Oeste | 1.022 | [NAME]
America Mineiro | [NAME] | 0.607
[NAME] | Vitoria | -0.08199999999999985
Parana | [NAME] | 1.707
Botafogo SP | Guarani SP | 0.55
Brazil de Pelotas | Oeste | -0.76 | [NAME]
Nautico | CRB | -0.542
Chapecoense | [NAME] | 1.883
Figueirense | Cruzeiro | 0.7189999999999999
[NAME] | America Mineiro | -1.169
[NAME] | CS Alagoano | 1.061
Avai | Botafogo SP | -2.03
Oeste | [NAME] | -0.8420000000000001 | [NAME]
Guarani SP | Parana | -0.4320000000000001
CRB | Brazil de Pelotas | 2.499
Spreadsheet: 0e996812-4a3d-469b-a1d3-3cfcf51510cc
Sheet: LRC_Changes_DIST_2012

County | District Name | Report Card Measure | Revised | Original
Mahoning | Campbell City | Overall Annual Yearly Progress (AYP) | Met | Not Met
[NAME] | Cincinnati City | State Indicators Met | 10 | 11
Montgomery | Northridge Local | State Indicators Met | 15 | 16
[NAME] | Cincinnati City | Performance Index | 88.4 | 88.5
Cuyahoga | Cleveland Municipal | Performance Index | 75.3 | 75.4
Franklin | Columbus | Performance Index | 80.3 | 80.5
Montgomery | Northridge Local | Performance Index | 90.9 | 91.6
Spreadsheet: be15e780-920e-475c-b32a-9cac9d08b637
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
BART | Test | BART | Bartonella Antibody Panel, IgG and IgM, Serum | Bartonella Ab Panel, IgG and IgM | Immunoflourescence Assay (IFA) Includes [NAME] henselae and [NAME] quintana. | Serum Gel Tube: SGT |  |  | 0.5 | mL | Collection Container/Tube:  Preferred: Red top Acceptable: Serum gel Submission Container/Tube: Plastic vial [NAME]: 0.5 mL Forms: If not ordering electronically, submit a General Request Form (Supply T239) with the specimen. | 0.15 mL | Hemolysis	Mild OK; Gross reject Thawing	Warm reject; Cold OK Lipemia	Mild OK; Gross reject Icterus	NA Other	NA | [NAME] henselae IgG: <1:128 IgM: <1:20  [NAME] quintana [NAME]: <1:128 IgM: <1:20 | Monday through Saturday; 9 a.m. | Same day/1 day | 3 days | 4 | 86611 |  |  |  |  | Rochester
BART | [NAME] | SERUM | Serum |  |  |  | Refrigerated | 7 days
BART | Result | 15659 | Bart Henselae IgG | Bart Henselae IgG | Alphanumeric |  |  |  |  | titer |  |  |  |  |  |  |  |  |  | 6954-2 | [NAME] henselae [NAME].IgG:Titr:Pt:Ser:Qn:IF
BART | Result | 15660 | Bart Henselae IgM | Bart Henselae IgM | Alphanumeric |  |  |  |  | titer |  |  |  |  |  |  |  |  |  | 6955-9 | [NAME] henselae Ab.IgM:Titr:Pt:Ser:Qn:IF
BART | Result | 15661 | [NAME] | [NAME] | Alphanumeric |  |  |  |  | titer |  |  |  |  |  |  |  |  |  | 44827-4 | Bartonella [NAME].[NAME]:Titr:Pt:Ser:Qn:IF
BART | Result | 15662 | Bart Quintana IgM | Bart Quintana IgM | Alphanumeric |  |  |  |  | titer |  |  |  |  |  |  |  |  |  | 44825-8 | Bartonella [NAME].IgM:Titr:Pt:Ser:Qn:IF
Spreadsheet: 105282d1302695064-normalising-data-normalising
Sheet: Sheet1

 | Set 1 Results (250 people) | Set 2 Results (80 people) |  |  |  |  | Set 1 Results (each people) | Set 2 Results (each people)
Jan | 4985 | 1959 |  |  |  | Jan | 19.94 | 24.4875
Feb | 4593 | 1415 |  |  |  | Feb | 18.372 | 17.6875
Mar | 5146 | 2184 |  |  |  | Mar | 20.584 | 27.3
Apr | 4582 | 2203 |  |  |  | Apr | 18.328 | 27.5375
May | 5066 | 1659 |  |  |  | May | 20.264 | 20.7375
Jun | 6169 | 5521 |  |  |  | Jun | 24.676 | 69.0125
Jul | 7769 | 3952 |  |  |  | Jul | 31.076 | 49.4
Aug | 6131 | 4214 |  |  |  | Aug | 24.524 | 52.675
Sep | 7415 | 3919 |  |  |  | Sep | 29.66 | 48.9875
Oct | 4538 | 1921 |  |  |  | Oct | 18.152 | 24.0125
Nov | 4959 | 1846 |  |  |  | Nov | 19.836 | 23.075
Dec | 5142 | 1892 |  |  |  | Dec | 20.568 | 23.65
Spreadsheet: 107021d1304171566-scatter-graphs-774334
Sheet: Sheet1

 | Finish |  |  | [NAME] | Fred | [NAME] |  |  |  | Xvalue
[NAME] | 09:30:00 |  | 2.5 | #N/A | #N/A | 09:30:00 |  |  | [NAME] | 0.5
Fred | 09:35:00 |  | 1.5 | #N/A | 09:35:00 | #N/A |  |  | Fred | 1.5
[NAME] | 10:15:00 |  | 0.5 | 10:15:00 | #N/A | #N/A |  |  | [NAME] | 2.5
[NAME] | 10:05:00 |  | 2.5 | #N/A | #N/A | 10:05:00
Fred | 10:30:00 |  | 1.5 | #N/A | 10:30:00 | #N/A
[NAME] | 11:00:00 |  | 0.5 | 11:00:00 | #N/A | #N/A
[NAME] | 14:18:00 |  | 2.5 | #N/A | #N/A | 14:18:00
Fred | 14:23:00 |  | 1.5 | #N/A | 14:23:00 | #N/A
[NAME] | 15:03:00 |  | 0.5 | 15:03:00 | #N/A | #N/A
[NAME] | 14:53:00 |  | 2.5 | #N/A | #N/A | 14:53:00
[NAME] | 15:18:00 |  | 2.5 | #N/A | #N/A | 15:18:00
[NAME] | 15:48:00 |  | 0.5 | 15:48:00 | #N/A | #N/A
Spreadsheet: 714492d1611245195-generate-sequence-number-based-on-nth-order-sample-7-
Sheet: Sheet1

Date | CustomerNum | Last | First | PurchaseNum | OrderSeq
2021-01-05 00:00:00 | 12345A | [NAME] | Action | 11567893 | 1
2021-01-05 00:00:00 | 12345A | [NAME] | Action | 11567893 | 1
2021-01-10 00:00:00 | 12345A | [NAME] | Action | 50087451 | 2
2021-01-10 00:00:00 | 12345A | [NAME] | Action | 50087451 | 2
2021-01-20 00:00:00 | 12345A | [NAME] | Action | 600986744 | 3
2021-01-12 00:00:00 | 56473C | Smith | [NAME] | 30918372 | 1
2021-01-12 00:00:00 | 56473C | Smith | [NAME] | 55552101 | 2
2021-01-01 00:00:00 | 98761A | Jones | [NAME] | 13685483 | 1
2021-01-01 00:00:00 | 98761A | Jones | [NAME] | 13685483 | 1
2021-01-15 00:00:00 | 98761A | Jones | [NAME] | 55489342 | 2
2021-01-15 00:00:00 | 98761A | Jones | [NAME] | 55489342 | 2
 |  |  |  |  | Looking to have order sequence generated by formula
Spreadsheet: 53613d1253558500-excel-2007-pushing-certain-data-to-sheet2-from-sheet1-test2
Sheet: Sheet1

a | 1 | test
b | 2 | of
c | 3 | the
d | 4 | ability
e | 5 | of
f | 6 | excel
a | 7 | to
b | 8 | pull
c | 9 | data
d | 10 | from
e | 11 | a
f | 12 | spreadsheet
a | 13 | without
b | 14 | adding
c | 15 | blank
d | 16 | line
e | 17 | entries
f | 18 | to
a | 19 | the
b | 20 | cooresponding
c | 21 | spreadsheet
Spreadsheet: 20a392d2-7dd8-4e31-8937-15c2a7566f34
Sheet: Non-Western

NON-WESTERN CAR
Course color corresponds with term of offering.  RED for fall semester, PURPLE for J-term, GREEN for both fall and J-term.
[NAME] | ARTH 210 |  | cross-listed with CLAS 210
 | ARTH 211 |  | cross-listed with CLAS 211
 | ARTH 227
 | ARTH 228
 | ARTH 235
Asian Studies | ASTU 230 |  | cross-listed with FLET 230
 | ASTU 231 |  | cross-listed with FLET 231
 | ASTU 232 |  | cross-listed with FLET 232
 | ASTU 233 |  | cross-listed with FLET 233
 | ASTU 290 |  | cross-listed with HIST 290
 | ASTU 292 |  | cross-listed with FILM 292
 | ASTU 390
Black Studies | BLST 160
Chinese | CHIN 221
Classical Studies | CLAS 210 |  | cross-listing with ARTH 210
 | CLAS 211 |  | cross-listed with ARTH 211
Communication Studies | COMM 332
Economics | ECON 481 |  | Fall 2009 (Contemporary China's Economy)
English | ENGL 272
 | ENGL 369
 | ENGL 370
Environmental Studies | EVST 245 |  | cross-listed with INST 245
Film Studies | FILM 292 |  | cross-listed with ASTU 292
Foreign Literature in English Translation | FLET 230 |  | cross-listed with ASTU 230
 | FLET 231 |  | cross-listed with ASTU 231
 | FLET 232 |  | cross-listed with ASTU 232
 | FLET 233 |  | cross-listed with ASTU 233
 | FLET 248
 | FLET 249
History | HIST 100 |  | Modern Iraq only
 | HIST 221 |  | cross-listed with JAPN 221
 | HIST 251
 | HIST 252
 | HIST 281
 | HIST 282
 | HIST 290
 | HIST 320
 | HIST 332
 | HIST 347
 | HIST 348
 | HIST 361
 | HIST 365
 | HIST 367
 | HIST 391
 | HIST 392
 | HIST 394
 | HIST 395
 | HIST 396
 | HIST 397
International Studies | INST 245 |  | cross-listed with EVST 245
Japanese | JAPN 220
 | JAPN 221 |  | cross-listed with HIST 221
 | JAPN 381 & 382
Mathematics | MATH 270
Music | MUSC 240
 | MUSC 381 |  | J-term 2013(Music of Brazil)
Philosophy | PHIL 220
 | PHIL 343
 | PHIL 381 |  | Spring 2010 (Confucian Tradition)
Political Science | PSCI 328
 | PSCI 333
 | PSCI 334
 | PSCI 335
 | PSCI 336
 | PSCI 337
 | PSCI 338
 | PSCI 381 |  | Spring 2011 (Political Islam in the Middle East)
Psychology | PSYC 160
 | PSYC 162
 | PSYC 175
 | PSYC 180
 | PSYC 186
Religious Studies | RELS 221
 | RELS 223
 | RELS 225
 | RELS 229
 | RELS 245
 | RELS 248
Sociology | SOCI 210
 | SOCI 215
 | SOCI 230
 | SOCI 260
 | SOCI 265
 | SOCI 273
 | SOCI 383 |  | J-Term 2009, 2011 (Global, Env, Social Dynamics Brazil)
 | SOCI 383 |  | J-Term 2008, 2010 (Globalization & Social Change Ghana)
Honors Program | HONR 215
 | HONR 259
 | HONR 290
Spreadsheet: 129147d1321469722-auto-populating-excel-calendar-calendar
Sheet: Calendar

Go Green Committee Calendar |  |  |  |  |  |  |  |  |  | 2011-11-30 00:00:00
Month of: | 2011-11-16 00:00:00 |  | 2011-11-01 00:00:00 | 3 |  |  |  |  |  | 2011-12-31 00:00:00
 |  |  |  |  |  |  |  |  |  | 2012-01-31 00:00:00
2011-10-30 00:00:00 | 2011-10-31 00:00:00 | 2011-11-01 00:00:00 | 2011-11-02 00:00:00 | 2011-11-03 00:00:00 | 2011-11-04 00:00:00 | 2011-11-05 00:00:00 |  |  |  | 2012-02-29 00:00:00
2011-10-30 00:00:00 | 2011-10-31 00:00:00 | 2011-11-01 00:00:00 | 2011-11-02 00:00:00 | 2011-11-03 00:00:00 | 2011-11-04 00:00:00 | 2011-11-05 00:00:00 |  |  |  | 2012-03-31 00:00:00
 |  |  |  |  |  |  |  |  |  | 2012-04-30 00:00:00
2011-11-06 00:00:00 | 2011-11-07 00:00:00 | 2011-11-08 00:00:00 | 2011-11-09 00:00:00 | 2011-11-10 00:00:00 | 2011-11-11 00:00:00 | 2011-11-12 00:00:00 |  |  |  | 2012-05-31 00:00:00
 |  |  |  |  |  |  |  |  |  | 2012-06-30 00:00:00
2011-11-13 00:00:00 | 2011-11-14 00:00:00 | 2011-11-15 00:00:00 | 2011-11-16 00:00:00 | 2011-11-17 00:00:00 | 2011-11-18 00:00:00 | 2011-11-19 00:00:00 |  |  |  | 2012-07-31 00:00:00
 |  |  |  |  |  | Appointment 1 |  |  |  | 2012-08-31 00:00:00
2011-11-20 00:00:00 | 2011-11-21 00:00:00 | 2011-11-22 00:00:00 | 2011-11-23 00:00:00 | 2011-11-24 00:00:00 | 2011-11-25 00:00:00 | 2011-11-26 00:00:00 |  |  |  | 2012-09-30 00:00:00
 |  |  |  | Appointment 2 |  |  |  |  |  | 2012-10-31 00:00:00
2011-11-27 00:00:00 | 2011-11-28 00:00:00 | 2011-11-29 00:00:00 | 2011-11-30 00:00:00 | 2011-12-01 00:00:00 | 2011-12-02 00:00:00 | 2011-12-03 00:00:00 |  |  |  | 2012-11-30 00:00:00
 |  |  |  |  |  |  |  |  |  | 2012-12-31 00:00:00
Spreadsheet: 140907d1328950131-apparent-defined-name-problem-gpra-samples
Sheet: Individual Scorecard

[NAME] |  |  |  | GPRA Dashboard for PS Clinics
 |  |  |  |  |  | Weekly Report
 |  | Goal | 1/2 | 1/9 | 1/16 | 1/23 | 1/30 | 2/6 | 2/13 | 2/14
Behavioral Health | Alcohol Screen Females 15-44 | 58.7 | 100 | 66.7 | 66.7 | 96.3 | 100 |  |  |  |  | GOAL:
 | Depression: Screening or Diagnosis 18+ | 56.5 | 77.4 | 55.6 | 55.6 | 92.2 | 91.1 |  |  |  |  | Numerator:
 | IPV/DV Screen Females 15-40 | 55.3 | 100 | 60 | 60 | 97.7 | 100 |  |  |  |  | Denominator:
Cancer-Related | Colorectal Cancer Screen 51-80 | 60 | 18.8 | 0 | 0 | 36.4 | 35.1 |  |  |  |  | Data run: From iCare panel select Natl Aggregated, filter 2012 goals to (NonBlanks), ctrl+a, click the "Export to Excel" icon and save to desktop, open saved file, copy F4-F25, click on row 2 of this sheet in the appropriate column, click on the down arrow underneath the paste icon and then hit "v"
 | Mammogram Rates 52-64 | 51.7 | 36.8 | 33.3 | 33.3 | 51.7 | 61.5
 | Pap Smear Rates 21-64 | 59.5 | 52.8 | 42.9 | 42.9 | 53.4 | 48.6
 | Tobacco Cessation: Counseling or RX | 30 | 8.3 | 0 | 0 | 12 | 10 |  |  |  |  | DATA ANALYSIS:
CVD-Related | IHD: Comp CVD Assessment | 40.6 | 14.3 | 100 | 100 | 31.3 | 31.8 |  |  |  |  | •
Dental | Dental Access | 26.9 | 39.4 | 39.3 | 39.3 | 39.5 | 44.4 |  |  |  |  | •
 | Dental Sealants | 276893 |  |  |  |  |  |  |  |  |  | ACTIONS:
 | Topical Fluoride Pts | 161461 | 10.6 | 17.9 | 17.9 | 16.9 | 18.5 |  |  |  |  | •
Diabetes | DM: A1c Glycemic Control Ideal <7 | 32.7 | 32.4 | 20 | 20 | 24.7 | 31.9 |  |  |  |  | •
 | DM: A1c Glycemic Control Poor >9.5 (GPRA) | 18.6 | 17.6 | 40 | 40 | 35.1 | 27.7 |  |  |  |  | •
 | DM: BP Controlled <130/80 | 38.7 | 41.2 | 40 | 40 | 30 | 21.3 |  |  |  |  | •
 | DM: LDL Assessed | 70.3 | 76.5 | 60 | 60 | 76.3 | 80.9 |  |  |  |  | ACTIONS:
 | DM: [NAME] | 57.8 | 52.9 | 80 | 80 | 69.1 | 66 |  |  |  |  | •
 | DM: Retinal Evaluation | 54.8 | 29.4 | 20 | 20 | 28.9 | 29.8 |  |  |  |  | •
Vaccines | Influenza IZ 65+ | 63.4 | 57.1 | 100 | 100 | 80 | 88.9 |  |  |  |  | •
 | Peds IZ 4:3:1:3:3:1:4 Active IMM | 77.8 |  | 100 | 100 | 100 | 100 |  |  |  |  | •
 | Pneumovax Ever 65+ | 87.5 | 92.9 | 100 | 100 | 93.3 | 94.4 |  |  |  |  | •
Other Clinical | Breastfeed Screen @ 2 mos: exclusive/mostly breastfed | 27.4 |  |  |  |  |  |  |  |  |  | Responsible Person(s), Content Expert, Chief/Supervisor or Team Leader(s):
STI-Related | STI: Prenatal HIV Screening | 81.8 | 0 |  |  | 76.9 | 66.7
Spreadsheet: 109534d1306361826-average-completion-time-average_time
Sheet: TEST

NAME | TICKET OPEN | TICKET CLOSE | COUNT
BOB | 2011-04-01 16:04:00 | 2011-04-04 11:16:41 | 1 |  | NAME | TOTAL TICKETS | AVG COMPLETION TIME
CINDY | 2011-04-04 16:28:44 | 2011-04-07 12:34:42 | 1 |  | BOB
[NAME] | 2011-04-22 12:44:05 | 2011-04-25 08:53:33 | 1 |  | CINDY
JESSICA | 2011-04-25 12:12:52 | 2011-04-28 08:54:39 | 1 |  | [NAME]
FRANK | 2011-04-05 17:58:20 | 2011-04-08 14:48:36 | 1 |  | JESSICA
MIKE | 2011-04-01 13:17:22 | 2011-04-04 10:25:51 | 1 |  | FRANK
SARAH | 2011-04-30 13:29:42 | 2011-05-03 11:23:49 | 1 |  | MIKE
BOB | 2011-04-21 18:01:41 | 2011-04-26 11:46:27 | 1 |  | SARAH
CINDY | 2011-04-08 13:53:55 | 2011-04-13 07:47:15 | 1
[NAME] | 2011-04-28 12:51:19 | 2011-05-03 08:20:23 | 1
JESSICA | 2011-04-13 12:35:26 | 2011-04-18 08:50:12 | 1
FRANK | 2011-04-14 12:26:34 | 2011-04-19 09:49:29 | 1
MIKE | 2011-04-01 14:17:28 | 2011-04-06 11:49:00 | 1
SARAH | 2011-04-04 11:13:15 | 2011-04-13 10:48:13 | 1
BOB | 2011-04-27 11:01:46 | 2011-05-06 10:43:43 | 1
CINDY | 2011-04-11 15:43:23 | 2011-04-20 15:48:38 | 1
[NAME] | 2011-04-18 13:40:45 | 2011-04-27 13:58:31 | 1
JESSICA | 2011-04-27 10:17:44 | 2011-05-06 10:35:35 | 1
FRANK | 2011-04-26 15:10:13 | 2011-05-05 15:28:12 | 1
MIKE | 2011-04-26 15:08:33 | 2011-05-05 15:27:46 | 1
SARAH | 2011-04-06 10:49:37 | 2011-04-15 11:22:55 | 1
Spreadsheet: 741077d1626798457-countifs-and-dates-stats-wip
Sheet: Calculation

Current Open Tickets
Closed Calls
Total Calls
Calls Per SVD for June | OPEN | CLOSED
HUBBLE
SEAS AP & VENDOR
SEAS DEVELOPMENT
SEAS ASSESSMENT
SEAS Helpdesk
SEAS Interfaces
SEAS SME Escalation
SEAS sys admin
SEAS T & B
Totals
Weekly totals Open | 2021-05-31 00:00:00 | 2021-06-07 00:00:00 | 2021-06-14 00:00:00 | 2021-06-21 00:00:00 | 2021-06-28 00:00:00 | 2021-07-05 00:00:00 | 2021-07-12 00:00:00 | 2021-07-19 00:00:00
HUBBLE
SEAS AP & VENDOR
SEAS DEVELOPMENT
SEAS ASSESSMENT
SEAS Helpdesk
SEAS Interfaces
SEAS SME Escalation
SEAS sys admin
SEAS T & B
Weekly totals closed
HUBBLE
SEAS AP & VENDOR
SEAS DEVELOPMENT
SEAS ASSESSMENT
SEAS Helpdesk
SEAS Interfaces
SEAS SME Escalation
SEAS sys admin
SEAS T & B
Spreadsheet: 82901d1282906495-vlookup-incorrect-answer-lv-rates11
Sheet: POSTCODES

POSTCODE | AREA
AB | A
AL | C
AL2 | D
AL4 | D
AL8 | D
B | D
B10 | G
B11 | G
B12 | G
B13 | G
B16 | G
B18 | G
B19 | G
[NAME] | G
B21 | G
B30 | G
B1 | F
B2 | F
B30 | F
B4 | F
B5 | F
B6 | F
B7 | F
B8 | F
B9 | F
B15 | F
B23 | F
B26 | F
B31 | F
B33 | F
B14 | E
B17 | E
B24 | E
B27 | E
B29 | E
B34 | E
B35 | E
B37 | E
BA | A
BB | E
[NAME] | E
BB2 | E
BB3 | E
BB7 | E
BD | D
BD3 | G
BD2 | E
BD6 | E
BD15 | E
BH | A
BL | F
BN | C
BR | D
BS | B
CA | B
CB | A
CF | D
CH | E
CM | D
CO | B
CR | E
CT | C
[NAME] | C
CW | B
DA | F
DD | A
DE | C
DG | A
DH | C
DL | B
DN | B
DN11 | D
DN12 | D
DN34 | D
DN35 | D
DN55 | D
DT | A
DY | C
E | G
EH | B
EN | D
EN2 | E
EN3 | E
EX | A
FK | A
FY | D
G | C
[NAME] | F
G2 | F
G3 | F
G14 | F
G40 | F
G41 | F
G42 | F
[NAME] | G
[NAME] | G
G17 | G
G18 | G
G19 | G
G20 | G
G21 | G
G22 | G
G33 | G
G34 | G
G51 | G
G52 | G
G53 | G
G79 | G
G11 | D
G12 | D
G13 | D
G23 | D
G31 | D
G42 | D
[NAME] | D
G44 | D
G45 | D
G46 | D
GL | B
GU | C
GU8 | D
GU9 | D
GY | A
HA | E
HD | D
HD1 | E
HD2 | E
HD7 | E
HD9 | E
HG | B
HP | C
HR | A
HS | A
[NAME] | B
HX | D
IG | F
IM | A
IP | A
IV | A
KA | A
KT | D
KT2 | E
KT3 | E
KW | A
KY | A
L | G
LA | B
LD | B
LE | D
LL | B
LN | B
LS | D
[NAME] | E
LS2 | E
LS3 | E
LS4 | E
LU | D
M | G
ME | C
MK | C
ML | C
N | G
NE | C
NE12 | E
NE13 | E
NE29 | E
NE35 | E
NE36 | E
NE1 | D
NE29 | D
NE3 | D
NE4 | D
NE5 | D
NE6 | D
NE7 | D
NE8 | D
NE9 | D
NE10 | D
NE11 | D
NE15 | D
NE28 | D
NE30 | D
NE31 | D
NE32 | D
[NAME] | D
NE34 | D
NE38 | D
NE39 | D
NE40 | D
NE41 | D
NG | D
NN | C
NP | B
NR | B
NW | F
OL | G
OX | B
PA | C
PE | B
PH | B
PL | A
PO | B
PR | E
RG | D
RH | D
RM | D
S | D
SA | B
SE | G
SG | D
SK | F
SL | D
SM | D
SN | B
SO | B
SP | A
SR | D
SS | C
ST | D
SW | G
SY | B
TA | A
TD | A
TF | A
TN | B
TQ | A
TR | A
TS | C
TW | D
UB | G
W | G
WA | D
WD | D
WF | C
WN | D
WR | A
WS | D
VW | D
VW6 | E
VW12 | E
YO | B
Spreadsheet: 192917d1352627937-duplicating-only-the-formatting-of-a-row-not-content-scheduletest
Sheet: TOTAL MONTH

FREIGHT
 |  |  |  |  |  |  |  |  | Fuel
DATE | Receiver |  | CITY | CON NOTE | PALLETS | M3 | Cost | Total | [NAME]
2012-10-02 00:00:00 | WOOL WARNERVALE |  | WARN | 4974087982 | 1 | 2.1 | #N/A | #N/A | 1.0794
2012-10-30 00:00:00 | BIG W MONARTO |  | MO | 4974088811 | 13 | 20.9 | #N/A | #N/A
2012-10-31 00:00:00 | WOOL GEPPS CROSS |  | A | 4974088897 | 4 | 5.2 | #N/A | #N/A
2012-10-31 00:00:00 | [NAME] |  | BW | 4974088903 | 2 | 3.8 | #N/A | #N/A
2012-10-31 00:00:00 | BUNNINGS ASHFIELD |  | S | 4974088910 | 1 | 1.17 | #N/A | #N/A
2012-10-31 00:00:00 | WOOLWORTHS WARNERVALE | 2250-01 | B | 4974088927 | 1 | 1.16 | 72.2108 | 77.94433752
Spreadsheet: 89428d1289231268-lookup-from-fixed-rows-and-dynamic-columns-sample-1-
Sheet: 1

USER NAME | ID | CALLS | TIMECLOCK | AGENTTIME | WAIT | TALK | [NAME] | PAUSE | LOGIN | Comf | Coach | CALLB
Agent1 | 4024 | 293
Agent2 | 4121 | 185
Agent3 | 4094 | 325
Agent4 | 4159 | 247
Agent5 | 4148 | 299
Agent6 | 4104 | 302
Agent7 | 4139 | 291
Agent8 | 4157 | 207
Agent9 | 4125 | 243
Agent10 | 4107 | 253
Agent11 | 4141 | 232
Agent12 | 4097 | 208
Agent13 | 4068 | 160
Agent14 | 4017 | 138
Agent15 | 4164 | 168
Agent16 | 4103 | 307
Agent17 | 4146 | 281
Agent18 | 4156 | 200
Agent19 | 4078 | 353
Agent20 | 4061 | 272
Spreadsheet: rick_buy__32805__NP Daily Marks
Sheet: Breakdown

The New Power Company
Breakdown by Product
 |  |  |  | Per CAS | Capacity Corr. |  |  | Per CAS | Capacity Corr. |  |  | Per CAS | Capacity Corr. |  |  | Per CAS | Capacity Corr. |  |  | Per CAS | Capacity Corr. |  |  | Per CAS |  |  |  | Per CAS
 | COB 8/27/01 | COB 8/28/01 |  | COB 8/29/01 | COB 8/29/01 | Difference |  | COB 9/4/01 | COB 9/4/01 | Difference |  | COB 9/6/01 | COB 9/6/01 | Difference |  | COB 9/10/01 | COB 9/10/01 | Difference |  | COB 9/12/01 | COB 9/12/01 | Difference |  | COB 9/17/01 | COB 9/17/01 | Difference |  | COB 9/18/01 | COB 9/18/01 | Difference | COB 9/19/01 | COB 9/20/01 | COB 9/21/01 | COB 9/24/01 |  | Daily Change
Financial MTM | 49947286 | 55858213 |  | 57692146 | 57692146 |  |  | 46484930 | 46484930 |  |  | 46043210 | 46043210 |  |  | 44910437 | 44910437 |  |  | 42269727 | 42269727 |  |  | 41763715 |  |  |  | 48406572 |  |  |  | 54912946 |  | 61351647
Gas MTM | 4691838 | 4946778 |  | 5061950 | 5061950 |  |  | 4923532 | 4923532 |  |  | 4872850 | 4872850 |  |  | 10151598 | 10151598 |  |  | 4747637 | 4747637 |  |  | 5004111 |  |  |  | 5458453 |  |  | 5910950 | 5809999 | 5739531 | 6028749 |  | 6759288
Gas Purchases |  | -596668 |  | -601718 | -601718 |  |  | -1209051 | -1209051 |  |  | -1333842 | -1333842 |  |  | -1333845 | -1333845 |  |  | -1333852 | -1333852 |  |  | -1333861 |  |  |  | -1408374 |  |  | -804194 | -804194 | -804191 | -804191 |  | 6759288
Gas Sales |  | 7435080 |  | 7435080 | 7435080 |  |  | 15290816 | 15290816 |  |  | 15053482 | 15053482 |  |  | 15054186 | 15054186 |  |  | 15054427 | 15054427 |  |  | 15060666 |  |  |  | 15066560 |  |  | 8027587 | 8033044 | 8056777 | 8059302 |  | 6759288
Total Gas
Power MTM | 52787394 | 54029592 |  | 54402992 | 54402992 |  |  | 53378304 | 53378304 |  |  | 7690871 | 7690871 |  |  | 48353305 | 48353305 |  |  | 46016089 | 46016089 |  |  | 37433537 |  |  |  | 45334327 |  |  | 49514316 | 51629206 | 51512135 | 54909855
Power Purchases | -82546945 | -85660468 |  | -88773990 | -18720422 |  |  | -102241362 | -19885207.79999999 |  |  | -37773032 | -19885207.79999999 |  |  | -45558719 | -19885207.79999999 |  |  | -53584206 | -19885207.79999999 |  |  | -66720218 | -19885207.79999999 |  |  | -50001684 | -19885207.79999999 |  | -6923427.8 | -7158407.8 | -7623547.8 | -7858527.8
Power Sales | 108806923 | 112835527 |  | 116864132 | 16183721 |  |  | 135064396 | 16702984 |  |  | 41539165 | 16702984 |  |  | 52171599 | 16702984 |  |  | 62833553 | 16702984 |  |  | 80573957 | 16702984 |  |  | 67422539 | 16702984 |  | 5220184 | 5267164 | 5378584 | 5425564
Total Power
Total Exposure
Treashold Amt. | -15000000 | -15000000 |  | -15000000 | -15000000 |  |  | -15000000 | -15000000 |  |  | -15000000 | -15000000 |  |  | -15000000 | -15000000 |  |  | -15000000 | -15000000 |  |  | -15000000 | -15000000 |  |  | 0 | 0 |  | 0 | 0 | 0 | 0
Collateral Posted | -87300000
Margin due to ENE
Spreadsheet: 599245d1542922205-nba-running-tally-winning-percentage-nba-winning-tracker
Sheet: Sheet1

Date | [NAME] | Prediction | Actual | Winning %
2018-11-23 00:00:00 | Timberwolves vs Nets | Nets | Nets
2018-11-23 00:00:00 | Rockets vs Pistons | Pistons | Pistons
2018-11-23 00:00:00 | Celtics vs Hawks | Hawks | Celtics
2018-11-23 00:00:00 | Grizzlies vs Clippers | Grizziers | Grizzlies
2018-11-23 00:00:00 | Cavaliers vs 76ers | 76ers | 76ers
2018-11-23 00:00:00 | Wizards vs Raptors | Raptors | Raptors
Spreadsheet: 156258d1337246039-one-lookup-value-multiple-matches-book1
Sheet: Landlords

Ref | [NAME]
l1
l2
l3
[NAME]
l6
L7
l9
L11 | [NAME]
l14
l15 | [NAME]
L16
L19
L20
[NAME]
L22
[NAME]
L26
L27