tianzl66/Sheetpedia huggingface dataset:
Spreadsheet: 94355d1294191040-excel-2007-referencing-a-spreadsheet-test-repair-estimator
Sheet: Sheet1

 |  | Other Brands |  |  |  |  |  | Cadillac |  |  |  |  | *New* Brake Calculator
 |  | Total Labor Hours |  | 0 |  |  |  | Total Labor Hours |  | 0 |  |  | Total Labor Hours |  | 0
 |  | Total Labor Price |  | 0 |  |  |  | Total Labor Price |  | 0 |  |  | Total Labor Price |  | 0
 |  | Total Parts Price |  | 0 |  |  |  | Total Parts Price |  | 0 |  |  | Total Parts Price |  | 0
 |  | Shop Charges |  | 0 |  |  |  | Shop Charges |  | 0 |  |  | Shop Charges |  | 0
 |  | Tax |  | 0 |  |  |  | Tax |  | 0 |  |  | Tax |  | 0
 |  | Exact Total |  | 0 |  |  |  | Exact Total |  | 0 |  |  | Exact Total |  | 0
 |  | Customer Estimate Total |  | 0 |  |  |  | Customer Estimate Total |  | 0 |  |  | Customer Estimate Total |  | 0
 |  |  |  |  |  |  |  | Wynns Warranty |  |  |  |  | Other Extended Warranty
 |  | Enter These Numbers
 |  |  |  |  |  |  |  | Total Labor Hours |  | 0 |  |  | Total Labor Hours |  | 0
 |  | Total Estimate Price
 |  |  |  |  |  |  |  | Total Labor Price |  | 0 |  |  | Total Labor Price |  | 0
 |  |  |  |  |  |  |  | Total Parts Price |  | 0 |  |  | Total Parts Price |  | 0
 |  |  |  |  |  |  |  | Shop Charges |  |  |  |  | Shop Charges
 |  |  |  |  |  |  |  | Tax |  | 0 |  |  | Tax |  | 0
 |  |  |  |  |  |  |  | Exact Total |  | 0 |  |  | Exact Total |  | 0
 |  |  |  |  |  |  |  | Customer Estimate Total |  |  |  |  | Customer Estimate Total
Spreadsheet: ea66734c-0583-4b27-91ce-117c8f6166da
Sheet: Sheet1

PROG ID | ATHLETE ID | ATHLETE FIRST | ATHLETE LAST | NATIONALITY | START NUMBER | RUN | T1 | BIKE | T2 | RUN.1 | POSITION | TOTAL TIME
265077 | 64072 | [NAME] | Parish | USA |  | 00:00:00 | 00:00:00 | 00:00:00 | 00:00:00 | 00:00:00 | 1 | 01:25:45
265077 | 80001 | [NAME] | Mcguire | USA |  | 00:00:00 | 00:00:00 | 00:00:00 | 00:00:00 | 00:00:00 | 2 | 01:28:14
265077 | 80002 | [NAME] | [NAME] | USA |  | 00:00:00 | 00:00:00 | 00:00:00 | 00:00:00 | 00:00:00 | 3 | 01:37:33
265077 | 33977 | [NAME] | Sheeks | USA |  | 00:00:00 | 00:00:00 | 00:00:00 | 00:00:00 | 00:00:00 | 4 | 01:25:51
265077 | 80003 | [NAME] | Bordine | USA |  | 00:00:00 | 00:00:00 | 00:00:00 | 00:00:00 | 00:00:00 | 5 | 01:27:24
Spreadsheet: 739122d1625537012-formula-that-tracks-with-date-as-it-progresses-with-the-month-pace-to-goal-calculator-
Sheet: Sheet1

Pace to goal Calculator
2021-07-05 00:00:00 | Percent of expected sales each day | Days Passed | Days to Go | Total Days
Mon-Thurs | 0.02
Friday
Sat
Sunday
Total days
Target | 100000
Actual |  | 60000
[NAME]
Spreadsheet: 694212d1599447463-how-to-reverse-this-lookup-formula-lookup-first-value
Sheet: Sheet 1 Formula

Name | Score (Last)
[NAME] |  |  | >>> Should say Week 1
[NAME] |  |  | >>> Should say Week 2
Cats Dogs |  |  | >>> Should say Week 4
 |  |  | Name | Week 1 | Week 2 | Week 3 | Week 4 | Week 5
 |  |  | JJ Cool | - | - | 3 | 4 | 1
 |  |  | Cats Dogs | - | - | - | 5 | 2
 |  |  | [NAME] | - | 4 | 8 | 6 | 5
 |  |  | [NAME] | 1 | 2 | 5 | 6 | 4
 |  |  | [NAME] | 7 | 3 | 2 | 6 | 5
Spreadsheet: 732452d1620967450-trying-to-populate-cells-in-a-specific-order-on-a-sheet-with-data-from-an-unsorted-sheet-book-1
Sheet: Cache Jr's

Cache County Team Total Points: |  |  |  |  |  |  | Cache Juniors RANK:
Cache | Test Review Ends at 1:30 pm
Test |  |  |  |  |  | Showmanship
Rank | [NAME] | Score | Points |  |  | Rank | [NAME] | Ribbon | Points
1 |  |  |  |  |  | 1
2 |  |  |  |  |  | 2
3 |  |  |  |  |  | 3
4 |  |  |  |  |  | 4
5 |  |  |  |  |  | 5
6 |  |  |  |  |  | 6
7 |  |  |  |  |  | 7
8 |  |  |  |  |  | 8
 | Event Top 5 Total Points: |  |  |  |  |  | Event Top 5 Total Points:
Horsemanship |  |  |  |  |  | Bareback Equitation on the Rail
Rank | [NAME] | Score | Points |  |  | Rank | [NAME] | Ribbon | Points
1 |  |  |  |  |  | 1
2 |  |  |  |  |  | 2
3 |  |  |  |  |  | 3
4 |  |  |  |  |  | 4
5 |  |  |  |  |  | 5
6 |  |  |  |  |  | 6
7 |  |  |  |  |  | 7
8 |  |  |  |  |  | 8
 | Event Top 5 Total Points: |  |  |  |  |  | Event Top 5 Total Points:
Barrels |  |  |  |  |  | Poles
Rank | [NAME] | Time | Ribbon | Points |  | Rank | [NAME] | Time | Ribbon | Points
1 |  |  |  |  |  | 1
2 |  |  |  |  |  | 2
3 |  |  |  |  |  | 3
4 |  |  |  |  |  | 4
5 |  |  |  |  |  | 5
6 |  |  |  |  |  | 6
7 |  |  |  |  |  | 7
8 |  |  |  |  |  | 8
 | Event Top 5 Total Points: |  |  |  |  |  | Event Top 5 Total Points:
Keyhole |  |  |  |  |  | Portfolio
Rank | [NAME] | Time | Ribbon | Points |  | Rank | [NAME] | Score | Ribbon | Points
1 |  |  |  |  |  | 1
2 |  |  |  |  |  | 2
3 |  |  |  |  |  | 3
4 |  |  |  |  |  | 4
5 |  |  |  |  |  | 5
6 |  |  |  |  |  | 6
7 |  |  |  |  |  | 7
8 |  |  |  |  |  | 8
 | Event Top 5 Total Points: |  |  |  |  |  | Bonus Top 5 Total Points:
 | Cache County Team Total Points: |  |  |  |  |  | Maximum event points possible is 75                                          Maximum team points possible is 600
Spreadsheet: 788955d1658822730-index-function-with-variable-columns-excel-forum
Sheet: Top 5 - 8 Wochen

Top 5 Losses
from 8 weeks
[NAME] | 20 | 21 | 22 | 23 | 24 | 25 | 26 | 27 | 28 | 29 | 30 | 31 | 32 | 33 | 34 | 35 | 36 | 37 | 38 | 39 | 40 | 41 | 42 | 43 | 44 | 45 | 46 | 47 | 48 | 49 | 50 | 51 | 52
Anwesenheitszeiten |  |  |  |  |  |  |  |  | 5637.75
Pausen |  |  |  |  |  |  |  |  | -648.9016666666668
Arbeitszeit |  |  |  |  |  |  |  |  | 4988.848333333333
[NAME] |  |  |  |  |  |  |  |  | 0
[NAME] |  |  |  |  |  |  |  |  | -0.8333333333333334
Rüsten |  |  |  |  |  |  |  |  | -35
Nettoarbeitszeit |  |  |  |  |  |  |  |  | 4953.015
[NAME] |  |  |  |  |  |  |  |  | -23.33333333333333
Logistikanlagenstörung |  |  |  |  |  |  |  |  | 0
Schulung / Einarbeitung |  |  |  |  |  |  |  |  | -1.666666666666667
Fehlteil |  |  |  |  |  |  |  |  | 0
[NAME] |  |  |  |  |  |  |  |  | -0.8333333333333334
[NAME] |  |  |  |  |  |  |  |  | -18.33333333333333
Sonstige Mikrostillstände |  |  |  |  |  |  |  |  | -2.5
[NAME] |  |  |  |  |  |  |  |  | 4906.348333333334
Teilequalität |  |  |  |  |  |  |  |  | -3.333333333333333
Rotverschraubung |  |  |  |  |  |  |  |  | -5.833333333333333
Nacharbeit |  |  |  |  |  |  |  |  | 5
Effektive Arbeitszeit |  |  |  |  |  |  |  |  | 4902.181666666668
Undokumentiert |  |  |  |  |  |  |  |  | -399.7813818000013
Rückgemeldete Te-Zeiten |  |  |  |  |  |  |  |  | 4502.400284866667
Gesamter Verlust in h |  |  |  |  |  |  |  |  | -486.448048466668
Gesamt Produktivität
 | [NAME] 20-28 in h |  |  |  |  | Top losses KW 29-36 in h
 | 1 |  |  |  |  | 1
 | 2 |  |  |  |  | 2
 | 3 |  |  |  |  | 3
 | 4 |  |  |  |  | 4
 | 5 |  |  |  |  | 5
RANKING
 | KW 20-28 |  |  |  |  | KW 29-36
Anwesenheitszeiten
Pausen
Arbeitszeit
[NAME]
[NAME]
Rüsten
Nettoarbeitszeit
[NAME]
Logistikanlagenstörung
Schulung / Einarbeitung
Fehlteil
[NAME]
[NAME]
Sonstige Mikrostillstände
[NAME]
Teilequalität
Rotverschraubung
Nacharbeit
Effektive Arbeitszeit
Undokumentiert
Rückgemeldete Te-Zeiten
Spreadsheet: 684254d1593229938-calendar-showing-multiple-assignments-on-one-date-follow-up
Sheet: Week View

 | ASSIGNMENTS | MONTH VIEW
 | Select Month: | Enter Year: | Select Week #:
 | July |  | Week 1
 | WEEK VIEW
 | SUNDAY | MONDAY | TUESDAY | WEDNESDAY | THURSDAY | FRIDAY | SATURDAY
Spreadsheet: c6c92bf5-d9b9-4165-94f2-3a7d401374e3
Sheet: PAG 11 - Table 1

HILA-Ex results |  |  | Currency Translation | Organic Growth |  | % As | %
R$ million | 4Q10 | Scope |  |  | 4Q11 | Reported | Organic
Volume total ('000 hl) | 1620.988989539972 | 0 | 0 | 56.0514741500001 | 1677.040463689973 | 0.03457856562363637 | 0.03457856562363647
Beer volume ('000 hl) | 596.034612539999 | 0 | 0 | 81.9960931600001 | 678.0307056999991 | 0.1375693482138127 | 0.1375693482138128
CSD volume ('000 hl) | 1024.954376999973 | 0 | 0 | -25.94461901 | 999.0097579899734 | -0.02531295010997414 | -0.02531295010997418
Net revenue | 125.683 | 1.540999999999997 | 9.3551112601685 | 23.54188873983149 | 160.121 | 0.2740068266989168 | 0.1850428279242241
Net revenue/hl | 77.53476477077622 | 0.9506542055152067 | 5.57834558122978 | 11.4145518378314 | 95.47831639535258 | 0.2314258858929239 | 0.1454353176260607
[NAME] | -82.288 | -1.036000000000001 | -6.215665348553586 | -4.456334651446413 | -93.996 | 0.1422807699786117 | 0.05348200580200679
[NAME]/hl | -50.7640709042403 | -0.6391160005929564 | -3.706329980182666 | -0.9392201819369461 | -56.04873706695287 | 0.1041024895872003 | 0.01827163330701262
Gross profit | 43.39500000000001 | 0.5049999999999955 | 3.139445911614914 | 19.08555408838507 | 66.12499999999999 | 0.5237930637170174 | 0.4347506626055825
Gross margin | 0.3452734260003342 | 0 | 0 | 0 | 0.4129689422374329 | 680 | 730
SG&A excl. deprec.&amort. | -38.084 | -0.9940000000000015 | -6.103141249120453 | -13.85585875087954 | -59.03700000000001 | 0.5501785526730385 | 0.3545692909278761
SG&A deprec.&amort. | -7.351000000000001 | -0.1059999999999999 | -0.7608651960268737 | -4.259134803973125 | -12.477 | 0.6973200925044207 | 0.5711592871091759
SG&A total | -45.435 | -1.100000000000009 | -6.864006445147325 | -18.11499355485267 | -71.51400000000001 | 0.5739848134697922 | 0.3892767498625264
Other operating income/expenses | 0.822 | 0.03000000000000003 | 0.03740919533152331 | -2.036409195331523 | -1.147 | nm | nm
Normalized EBIT | -1.217999999999992 | -0.565000000000013 | -3.687151338200888 | -1.06584866179912 | -6.536000000000024 | nm | -0.5977838821083103
Normalized EBIT margin | -0.009691048113109902 | 0 | 0 | 0 | -0.04081913053253493 | -310 | -50
Normalized EBITDA | 12.006 | -0.4259999999999984 | -1.071356718129939 | 1.488356718129938 | 11.997 | 0.0007496251874062887 | 0.1285282140008581
Normalized EBITDA margin | 0.09552604568636967 | 0 | 0 | 0 | 0.07492458828011317 | -210 | -40
Spreadsheet: 680076d1590764740-formatting-using-multiple-sheets-and-search-function-2020-05-29-oeldere-unlimited007-680071d1590763966-formatting-using-multiple-sheets-and-search
Sheet: Sheet1

 |  |  | Product Code | Value | criteria |  |  |  | I want to use conditional formatting on column E but I can’t seem to get the formula right. Let me explain what I’m trying to achieve with an example.
 |  |  | ABC123 | LA121
 |  |  | BCA231 | FO876
 |  |  | CAB321 | [NAME]
 |  |  | BAC132 | YU371
 |  |  | ABC123 | LA121 |  |  |  |  | I have 2 sheets in the same workbook. On sheet 1 in column D I have the product codes and in column E I have a value (Both columns have text).
 |  |  | CAB321 | TR841
 |  |  | BAC132 | TR841 |  |  |  |  | Then on sheet 2 I have a product reference list. Column A has the product codes and Column C then has a value (Again both columns have text). The same products in both sheets should have the same value in column E(sheet 1) and C(sheet 2).
 |  |  |  |  |  |  |  |  | What I’m trying to format is column E on sheet 1. I want it to fill orange if the value is not the same as the corresponding product on sheet 2 in the C column. Need help with the formula.
 |  |  |  |  |  |  |  |  | I hope this has been clear enough to understand.
 |  |  |  |  |  |  |  |  | I have tried using the =COUNTIF() function but cant get it to work with this.
 |  |  |  |  |  |  |  |  | Thanks in advance for any help.
Spreadsheet: 814201d1674225920-substitute-array-particular-element-index-array-x-y-substitute-array-element
Sheet: Feuil1

initial array
 | b | c |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | a | b | c
z | d | e |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | z | d | e
f | g | h |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | f | g | h
expected array |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | a | b | c
 | b | c |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | e | d | e
e | d | e |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | f | g | h
f | g | h
 |  |  |  | replace "z" with "e"
Spreadsheet: 0b8ab8db-88a2-4788-9bff-50a9333ff58c
Sheet: Sheet1

Unnamed: 0 | Unnamed: 1 | Unnamed: 2 | Unnamed: 3 | Unnamed: 4
 |  |  |  | v eurách
 | SUMARIZÁCIA  PROGRAMOV  ROZPOČTU | Rozpočet 2011 |  | Skutočnosť
 |  | pôvodný | upravený | 30.6.2011
 | Bežné príjmy | 15314227 | 15625424 | 7878079
 | Bežné výdavky | 14569497 | 14956194 | 6045840
 | v tom :
 | 1: Strategické plánovanie, regionálny rozvoj a majetok mesta | 367275 | 367275 | 47696
 | 2: Samospráva mesta a [NAME] aparát | 1808490 | 1844313 | 676261
 | 3: Verejný poriadok | 320000 | 320000 | 138880
 | 4: Sociálne služby | 460523 | 460523 | 203524
 | 5: Verejno-prospešné služby | 2127972 | 2198657 | 997715
 | 6: Kultúra a rôzne spoločenské aktivity pre každého | 485736 | 496736 | 214419
 | 7: Šport | 736000 | 736000 | 429331
 | 8: Vzdelávanie | 8263501 | 8532690 | 3338014
 | Prebytok bežného rozpočtu | 744730 | 669230 | 1832239
 | Kapitálové príjmy | 9906953 | 9906953 | 1195986
 | Kapitálové výdavky | 11016388 | 11460742 | 1219217
 | v tom:
 | 1: Strategické plánovanie, regionálny rozvoj a majetok mesta | 10866060 | 11310414 | 1209146
 | 2: Samospráva mesta a [NAME] aparát | 20328 | 20328 | 9431
 | 3: Verejný poriadok | 0 | 0 | 640
 | 4: Sociálne služby | 0 | 0 | 0
 | 5: Verejno-prospešné služby | 130000 | 130000 | 0
 | 6: Kultúra a rôzne spoločenské aktivity pre každého | 0 | 0 | 0
 | 7: Šport | 0 | 0 | 0
 | 8: Vzdelávanie | 0 | 0 | 0
 | [NAME]/prebytok kapitálového rozpočtu | -1109435 | -1553789 | -23231
 | Príjmy finančných operácií v tom: | 580573 | 1100427 | 21991
 | Peňažné fondy mesta | 553000 | 1072854 | 0
 | Zostatok prostriedkov z predchádzajúcich rokov | 27573 | 27573 | 21991
 | Úver ŠFRB | 0 | 0 | 0
 | Iný zdroj: úver, pôžička | 0 | 0 | 0
 | Výdavky finančných operácií | 215868 | 215868 | 111278
 | Schodok/Prebytok finančných operácií | 364705 | 884559 | -89287
Schodok/Prebytok po vylúčení finančných operácií | Schodok/Prebytok po vylúčení finančných operácií | -364705 | -884559 | 1809008
 | VÝSLEDOK  HOSPODÁRENIA | 0 | 0 | 1719721
Spreadsheet: 147488d1332818169-can-cells-have-the-bkground-color-changed-upon-selection-of-an-item-from-a-drop-down-list-postable-data-production-schedule-evening
Sheet: Top Sheet

1900-01-01 00:00:00
Manager | 0 |  |  |  |  |  |  |  | 0 |  | Station | Time
Manager | 0 |  |  |  |  |  |  |  | 0 |  | (blank) | 0
NAV/Sp NAV | 0 |  |  |  |  |  |  |  | 0 |  | Grand Total | 0
NAV | 0 |  |  |  |  |  |  |  | 0 |  | 0 | 0
Repeats | 0 |  |  |  |  |  |  |  | 0 |  | 0 | 0
Regional Lead | 0 |  |  |  |  |  |  |  | 0 |  | 0 | 0
Regional Associates | 0 |  | 0 |  | 0 |  |  |  | 0 |  | 0 | 0
 | 0 |  | 0 |  | 0 |  |  |  | 0 |  | 0 | 0
Data Production Staff |  |  |  |  |  |  |  |  | 0 |  | 0 | 0
 |  |  |  |  |  |  |  | 0 | 0 |  | 0 | 0
 |  | 0 |  | 0 |  | 0 |  | 0 | 0 |  | 0 | 0
 |  | 0 |  | 0 |  | 0 |  | 0 | 0 |  | 0 | 0
 |  | 0 |  | 0 |  | 0 |  | 0 | 0 |  | 0 | 0
 |  |  |  |  |  |  |  | 0 | 0 |  | 0 | 0
 |  | 0 |  | 0 |  | 0 |  | 0 | 0 |  | 0 | 0
 |  | 0 |  | 0 |  | 0 |  | 0 | 0 |  | 0 | 0
 |  | 0 |  | 0 |  | 0 |  | 0 | 0 |  | 0 | 0
 |  |  |  |  |  |  |  | 0 | 0 |  | 0 | 0
 |  | 0 |  | 0 |  | 0 |  | 0 | 0 |  | 0 | 0
 |  | 0 |  | 0 |  | 0 |  | 0 | 0 |  | 0 | 0
 |  | 0 |  | 0 |  | 0 |  | 0 | 0 |  | 0 | 0
 |  |  |  |  |  |  |  | 0 | 0 |  | 0 | 0
 |  | 0 |  | 0 |  | 0 |  | 0 | 0 |  | 0 | 0
 |  | 0 |  | 0 |  | 0 |  | 0 | 0 |  | 0 | 0
 |  | 0 |  | 0 |  | 0 |  | 0 | 0 |  | 0 | 0
 |  |  |  |  |  |  |  | 0 | 0 |  | 0 | 0
 |  | 0 |  | 0 |  | 0 |  | 0 | 0 |  | 0 | 0
 |  | 0 |  | 0 |  | 0 |  | 0 | 0 |  | 0 | 0
 |  | 0 |  | 0 |  | 0 |  | 0 | 0 |  | 0 | 0
 |  |  |  |  |  |  |  | 0 | 0 |  | 0 | 0
 |  | 0 |  | 0 |  | 0 |  | 0 | 0 |  | 0 | 0
 |  | 0 |  | 0 |  | 0 |  | 0 | 0 |  | 0 | 0
 |  | 0 |  | 0 |  | 0 |  | 0 | 0 |  | 0 | 0
 |  |  |  |  |  |  |  | 0 | 0 |  | 0 | 0
 |  | 0 |  | 0 |  | 0 |  | 0 | 0 |  | 0 | 0
 |  | 0 |  | 0 |  | 0 |  | 0 | 0 |  | 0 | 0
 |  | 0 |  | 0 |  | 0 |  | 0 | 0 |  | 0 | 0
 |  |  |  |  |  |  |  | 0 | 0 |  | 0 | 0
 |  | 0 |  | 0 |  | 0 |  | 0 | 0 |  | 0 | 0
 |  | 0 |  | 0 |  | 0 |  | 0 | 0 |  | 0 | 0
 |  | 0 |  | 0 |  | 0 |  | 0 | 0 |  | 0 | 0
 |  |  |  |  |  |  |  |  | 0 |  | 0 | 0
 |  |  |  |  |  |  |  |  |  |  | 0 | 0
 |  |  |  |  |  |  |  |  |  |  | 0 | 0
 |  |  |  |  |  |  |  |  |  |  | 0 | 0
 |  |  |  |  |  |  |  |  |  |  | 0 | 0
 |  |  |  |  |  |  |  |  |  |  | 0 | 0
 |  |  |  |  |  |  |  |  |  |  | 0 | 0
Spreadsheet: 54f5653b-cde2-4ca4-ac13-b329c1ddd692
Sheet: Sheet1

PROG ID | ATHLETE ID | ATHLETE FIRST | ATHLETE LAST | NATIONALITY | START NUMBER | SWIM | T1 | BIKE | T2 | RUN | POSITION | TOTAL TIME
3715 | 9817 | [NAME] | Dmitrieva | RUS | 0 | 00:23:05 | 00:00:00 | [NAME] | 00:00:00 | 00:39:45 | 1 | [NAME]
3715 | 21503 | Margaryta | Zubyak | UKR | 0 | 00:23:04 | 00:00:00 | 01:26:24 | 00:00:00 | 00:38:55 | 2 | 02:28:25
3715 | 21501 | [NAME] | Kamburova | BUL | 0 | 00:24:14 | 00:00:00 | 01:31:01 | 00:00:00 | 00:41:28 | 3 | 02:36:43
3715 | 21502 | Serap | Tok | TUR | 0 | 00:27:49 | 00:00:00 | [NAME] | 00:00:00 | 00:48:32 | 4 | 02:38:58
3715 | 72789 | [NAME] | Irmak | TUR | 0 | 00:27:54 | 00:00:00 | [NAME] | 00:00:00 | 00:47:04 | 5 | 02:44:17
3715 | 5495 | Anna | Ivanova | RUS | 0 | 00:23:01 | 00:00:00 | 01:18:26 | 00:00:00 | 00:00:00 | DNF | 00:00:00
Spreadsheet: 83489d1283450815-removing-one-to-the-greater-value-livro3
Sheet: Folha1

A | B | C |  |  | D | E | F
24 | 24 | 24 |  |  | 0 | 25 | 0
 |  |  |  |  |  |  |  |  | correct
 |  |  |  |  |  | in this case, most be 24 not 23.
Spreadsheet: 719540d1613722063-staffing-with-15mins-interval-minus-on-break-lunch-version-2
Sheet: Dashboard

TIME IN EST | VOICE |  |  |  | [NAME] |  |  |  | CHAT |  |  |  | CSR2 |  |  |  | 2021-02-18 00:00:00
 | CB | Actual Count | On Break | On Lunch | CB | Actual Count | On Break | On Lunch | CB | Actual Count | On Break | On Lunch | CB | Actual Count | On Break | On Lunch | 09:45:00 | VOICE | [NAME] | CHAT | CSR2
08:00:00
08:15:00
08:30:00
08:45:00
09:00:00
09:15:00
09:30:00
09:45:00
10:00:00
10:15:00
10:30:00
10:45:00
11:00:00
11:15:00
11:30:00
11:45:00
12:00:00
12:15:00
12:30:00
12:45:00
13:00:00
13:15:00
13:30:00
13:45:00
14:00:00
14:15:00
14:30:00
14:45:00
15:00:00
15:15:00
15:30:00
15:45:00
16:00:00
16:15:00
16:30:00
16:45:00
17:00:00
17:15:00
17:30:00
17:45:00
18:00:00
18:15:00
18:30:00
18:45:00
19:00:00
19:15:00
19:30:00
19:45:00
20:00:00
20:15:00
20:30:00
20:45:00
21:00:00
21:15:00
21:30:00
21:45:00
22:00:00
22:15:00
22:30:00
22:45:00
23:00:00
23:15:00
23:30:00
23:45:00
1900-01-01 00:00:00
1900-01-01 00:15:00
1900-01-01 00:30:00
1900-01-01 00:45:00
1900-01-01 01:00:00
1900-01-01 01:15:00
1900-01-01 01:30:00
1900-01-01 01:45:00
1900-01-01 02:00:00
1900-01-01 02:15:00
1900-01-01 02:30:00
1900-01-01 02:45:00
1900-01-01 03:00:00
1900-01-01 03:15:00
Spreadsheet: drew_fossum__8880__topten99nng
Sheet: TOP 25

NORTHERN NATURAL GAS COMPANY
TOP "25" LARGEST CUSTOMERS
GL MONTHS: 1/99 THRU 12/99
 |  |  |  |  |  | % of
LGEN # |  | CUSTOMER NAME |  | TOTAL REVENUES |  | Revenues
0000079 |  | RELIANT ENERGY MINNEGASCO |  | 75582932.65
0011453 |  | UTILICORP UNITED, INC. |  | 58224992.14
0000392 |  | MIDAMERICAN ENERGY COMPANY |  | 44545542.39
0000366 |  | NORTHERN STATES POWER COMPANY-MINNESOTA |  | 40553127.91999999
0000355 |  | METROPOLITAN UTILITIES DISTRICT |  | 18994404.35
0000286 |  | IES INDUSTRIES, INC. |  | 15945867.84
0000080 |  | NICOR GAS COMPANY |  | 14938995.89
0000371 |  | WISCONSIN GAS COMPANY |  | 13175615.75
0000020 |  | ANR PIPELINE COMPANY |  | 11428212.69
0000335 |  | NORTHERN STATES POWER CO. OF WISCONSIN |  | 9380293.399999999
0000349 |  | WISCONSIN POWER AND LIGHT COMPANY |  | 8372313.35
0000394 |  | NORTHWESTERN PUBLIC SERVICE COMPANY |  | 6147415.02
0000342 |  | INTERSTATE POWER COMPANY |  | 5571944.8
0002534 |  | MADISON GAS & ELECTRIC COMPANY |  | 5191048.27
0011797 |  | SEMCO ENERGY GAS COMPANY |  | 4824762.58
0002691 |  | MOBIL NATURAL GAS INC |  | 4099727.38
0000344 |  | CITY OF DULUTH, MN |  | 3791180.92
0011369 |  | L S P - COTTAGE GROVE, L.P. |  | 3535547.31
0000035 |  | TRANSCONTINENTAL GAS PIPE LINE CORP |  | 3380183.74
0011370 |  | L S POWER - WHITEWATER L.P. |  | 3267232.61
0000382 |  | CIBOLA ENERGY SERVICES CORPORATION |  | 3092703.93
0011781 |  | TERRA NITROGEN CORPORATION |  | 3082015.61
0011641 |  | PRODUCERS ENERGY MARKETING, LLC |  | 2979778.09
0011650 |  | RELIANT ENERGY RETAIL, INC. |  | 2725496.86
0000600 |  | IMC NITROGEN COMPANY |  | 2599389.36
 |  | SMALL CUSTOMERS |  | 77439854
 |  | TOTAL TAS REVENUE
 |  | Other adjustments made outside TAS by Financial Accounting |  | 9819421
 |  | INCOME STATEMENT
Spreadsheet: 376658d1423673437-indirect-function-on-this-formula-single-cell-array-formulas
Sheet: Sheet6

Is a value contained in a range?
Enter a Name --> |  | [NAME]
Al | [NAME] | Harold | [NAME] | [NAME]
[NAME] | [NAME] | Ian | [NAME] | [NAME]
[NAME] | [NAME] | [NAME] | [NAME] | [NAME]
[NAME] | Dennis | [NAME] | [NAME] | Rod
[NAME] | [NAME] | Jan | Mark | [NAME]
[NAME] | [NAME] | [NAME] | Marvin | [NAME]
Bernard | Doug | [NAME] | [NAME] | Russ
[NAME] | [NAME] | [NAME] | [NAME] | Sandra
[NAME] | [NAME] | [NAME] | [NAME] | Scott
[NAME] | [NAME] | [NAME] | [NAME] | [NAME]
[NAME] | [NAME] | [NAME] | [NAME] | Stacy
[NAME] | Fran | [NAME] | Michelle | Stephen
Cark | [NAME] | Kathy | [NAME] | [NAME]
[NAME] | Fred | Kathy | [NAME] | Stuart
[NAME] | [NAME] | [NAME] | [NAME] | [NAME]
[NAME] | George | [NAME] | [NAME] | [NAME]
[NAME] | [NAME] | [NAME] | [NAME] | [NAME]
[NAME] | [NAME] | [NAME] | [NAME] | Timothy
Curt | Greg | Leonard | Ray | Vincent
[NAME] | Gregory | [NAME] | Rebecca | [NAME]
Non-array formula:
Spreadsheet: keith_holst__19329__NG loc pos
Sheet: Sheet1

Contract | NG | NG |  |  |  | Contract | NG | NG | NG | NG | NG
 | NORCAN | MALOR |  |  |  |  | ELPPER | ELPPER | ELPSJB | ELPSJB | SOBCAL
 | FERC | [NAME] |  |  |  |  | FERC | GAS-DLY M | FERC | GAS-DLY M | NGI MEAN
--------- | ---------- | --------- |  |  |  | --------- | --------- | ---------- | --------- | --------- | --------
V01 | 0 | 0 |  |  |  | V01 | 0 | -21 | 0 | 5 | 0
X01 | -45 | 75 |  |  |  | X01 | -15 | 0 | 90 | 150 | -30
[NAME] | -47 | 31 |  |  |  | [NAME] | -46 | 0 | 124 | 62 | -19
F02 | -46 | 47 |  |  |  | F02 | 0 | 0 | 62 | 62 | 5
G02 | -42 | 42 |  |  |  | G02 | 0 | 0 | 28 | 56 | -10
H02 | -46 | 47 |  |  |  | H02 | 31 | 0 | 62 | 62 | 5
[NAME] | 0 | -15 |  |  |  | [NAME] | 30 | 0 | 75 | 15 | -7
K02 | 0 | -16 |  |  |  | K02 | 31 | 0 | 78 | 16 | -8
M02 | 0 | -15 |  |  |  | M02 | 30 | 0 | 75 | 15 | -7
N02 | 0 | -16 |  |  |  | N02 | 31 | 0 | 109 | 15 | -8
Q02 | 0 | -16 |  |  |  | Q02 | 31 | 0 | 108 | 16 | -8
U02 | 0 | -15 |  |  |  | U02 | 30 | 0 | 105 | 15 | -8
V02 | 0 | -16 |  |  |  | V02 | 31 | 0 | 78 | 15 | -8
X02 | 0 | -30 |  |  |  | X02 | 45 | 0 | -15 | 0 | 30
[NAME] | 0 | -31 |  |  |  | [NAME] | 46 | 0 | -16 | 0 | 31
1Q03 | 0 | -90 |  |  |  | 1Q03 | 45 | 0 | 0 | 0 | 90
2Q03 | 0 | -45 |  |  |  | 2Q03 | 46 | 0 | 0 | 0 | 46
3Q03 | 0 | -46 |  |  |  | 3Q03 | 46 | 0 | 0 | 0 | 0
4Q03 | 0 | -46 |  |  |  | 4Q03 | 46 | 0 | 0 | 0 | 0
1Q04 | 0 | -45 |  |  |  | 1Q04 | -45 | 0 | 0 | 0 | 0
2Q04 | 0 | -46 |  |  |  | 2Q04 | -45 | 0 | 0 | 0 | 0
3Q04 | 0 | -46 |  |  |  | 3Q04 | -46 | 0 | 0 | 0 | 0
4Q04 | 0 | -46 |  |  |  | 4Q04 | -46 | 0 | 0 | 0 | 0
Cal05 | 0 | 0 |  |  |  | Cal05 | 0 | 0 | 0 | 0 | 0
Cal06 | 0 | 0 |  |  |  | Cal06 | 0 | 0 | 0 | 0 | 0
Cal07 | 0 | 0 |  |  |  | Cal07 | 0 | 0 | 0 | 0 | 0
Cal08 | 0 | 0 |  |  |  | Cal08 | 0 | 0 | 0 | 0 | 0
Cal09 | 0 | 0 |  |  |  | Cal09 | 0 | 0 | 0 | 0 | 0
Total: | -226 | -338 |  |  |  | Total: | 275 | -21 | 963 | 504 | 93