tianzl66/Sheetpedia huggingface dataset:
Spreadsheet: daren_farmer__6608__TransportFlash
Sheet: 9907

PRELIMINARY July 1999 Transport Expense Flash
Company | Company Number |  | Commodity Expenses |  | Demand Charges |  | Payable To Pipeline | Contract Numbers
HPLC | 12 |  |  |  |  |  | Long term deal commodity expense on HPL |  | Intrazone | 300000
 |  |  |  |  |  |  |  |  | Accrual | 200000
HPLC | 12 |  | 12182.32 |  |  |  | Black Marlin | 96022051 | Interzone
HPLC | 12 |  | 7527.59 |  |  |  | Channel Industries Gas Co. | 96006655/ 96017259
HPLC | 12 |  | 762.29 |  |  |  | Dow Pipeline Co | 96006998
HPLC | 12 |  | 4063.1 |  |  |  | Gulf Coast Pipeline Company | 96008709
HPLC | 12 |  | 170267.51 |  |  |  | Gulf Energy Pipeline, LLC | 96006421/ 96006950/ 96007179
HPLC | 12 |  | 16918.64 |  |  |  | Humble Gas Pipeline Company | 96013400/ 96013404
HPLC | 12 |  | 0 |  |  |  | King Ranch Gas Plant | 96016603
HPLC | 12 |  | 389.52 |  |  |  | MidCon Texas Pipeline | 96006770
HPLC | 12 |  | 15506.82 |  |  |  | Southland Energy Corporation | 96008703
HPLC | 12 |  | 1738.39 |  |  |  | Tejas Gas Operating, LLC | 96006817
HPLC | 12 |  | 10151.88 |  |  |  | Unit Gas Transmission Company | 96008706
ECT/Texas | 16 |  | 60461.08 |  |  |  | Northern Natural Gas/Black Marlin | 96020553
ECT/Texas | 16 |  | 97933.45 |  |  |  | Oasis Pipe Line Co. | 96015445/ 96016667/ 96019481/ 96019482
ECT/Texas | 16 |  | 440 |  |  |  | Pan Grande Pipeline, LLC | 96019628
ECT/Texas | 16 |  | 142157.14 |  |  |  | PG&E Texas Pipeline, L.P. | 96006479/ 96006482/ 96009903/ 96011842
 |  |  |  |  |  |  |  | 96016347/ 96016601
Texas Co. 16 |  |  |  |  | 93300 |  | Centana Storage Demand Charge | 96019236
Texas Co. 16 |  |  |  |  | 15000 |  | Tennessee/800 to HPL-Sabine Demand Charge - payable to East Desk
Totals |  |  | 1566965
DEMAND CHARGE NOTES: |  |  | $15,000 demand charge is in line 25 of OA Flash Page
 |  |  | $93,300 demand charge is in line 36 of OA Flash Page
ISSUES: | CPR estimate does not tie with Unify actuals as of 8/2/99
NOTE: | Because Unify does not tie with CPR, and because Unify does not seem to have flashed all pipelines, we used CPR tickets to flash
Spreadsheet: 029e54cc-a028-4ab9-af53-e54077b7aa74
Sheet: Sheet1

UNIVERSITETI I PRISHTINES | Unnamed: 1 | Unnamed: 2 | Unnamed: 3 | Unnamed: 4 | Unnamed: 5 | Unnamed: 6 | Unnamed: 7 | Unnamed: 8
FAKULTETI ARTEVE
[NAME] |  |  |  |  | PËR STUDIME MASTER
L I S T A
e kandidatëve që janë pranuar për regjistrim në vitin e parë të studimeve për [NAME] 2011-2012
Nr. | Emri, emri i prindit dhe mbiemri | Datëlindja | Vendlindja | Komuna | Shteti | Nota mesatare gjatë studimeve | Pikët në provim pranues | Gjithsej pikë
1 | Ilirjana [NAME] | 29.06.1984 | Prizren | Prizren | Kosovë | 9.13 | Piano
2 | Ilire [NAME] | 01.04.1987 | Prishtinë | Prishtinë | Kosovë | 9.31 | Klarinet
3 | Drilon ShabanÇoçaj | 11.10.1985 | Prizren | Prizren | Kosovë | 8.48 | Kitar
4 | [NAME] | 20.05.1988 | Prishtinë | Prishtinë | Kosovë | 9.1 | [NAME]
5 | [NAME] | 23.09.1986 | Prizren | Prizren | Kosovë | 8.81 | Violë
6 | Adhurim Selami Grezda | 27.10.1988 | Gjakovë | Gjakovë | Kosovë | 8.1 | Solokëndim
7 | Mrika Lutfi Hoxha | 24.12.1985 | Prishtinë | Prishtinë | Kosovë | 9.63 | Violinë
8 | Erlinda Fadil [NAME] | 16.04.1985 | Gjilan | Gjilan | Kosovë | 9.56 | Violinë
9 | Amanta Shefqet Istrefi | 10.09.1985 | Prishtinë | Prishtinë | Kosovë | 9.48 | [NAME]
10 | [NAME] | 29.06.1977 | Gjakovë | Gjakovë | Kosovë | 9.6 | Piano
11 | Dorian [NAME] | 17.01.1985 | [NAME] | [NAME] | [NAME] | 8.3 | Trombon
12 | Reinald Gëzim Foçi | 30.07.1986 | Tiranë | Tiranë | [NAME] | 9.7 | Tompetë
13 | Landrit [NAME] | 01.12.1985 | Gjilan | Gjilan | Kosovë | 7.46 | Trompetë
14 | [NAME] | 14.03.1987 | Gjilan | Gjilan | Kosovë | 7.13 | Korno
15 | [NAME] | 17.10.1987 | Gjakovë | Gjakovë | Kosovë |  | Klarinet
 |  |  |  |  | [NAME] i Fakultetit
UNIVERSITETI I PRISHTINES
FAKULTETI ARTEVE
[NAME] |  |  |  |  | PËR STUDIME MASTER
L I S T A
e kandidatëve që janë pranuar për regjistrim në vitin e parë të studimeve për [NAME] 2011-2012
Nr. | Emri, emri i prindit dhe mbiemri | Datëlindja | Vendlindja | Komuna | Shteti | Nota mesatare gjatë studimeve | Pikët në provim pranues | Gjithsej pikë
1 | [NAME] | 23.07.1987 | Prishtinë | Prishtinë | Kosovë | 8.42
2 | Astrit Enver Stafaj | 16.06.1980 | Prishtinë | Prishtinë | Kosovë | 7.9
3 | [NAME] | 27.01.1984 | Prizren | Prizren | Kosovë | 7.9
4 | [NAME] | 10.04.1986 | Gjilan | Gjilan | Kosovë | 7.68
5 | [NAME] | 22.12.1986 | Gjilan | Gjilan | Kosovë | 7.65
6 | [NAME] | 21.06.1978 | Gjakovë | Gjakovë | Kosovë | 7.5
7 | [NAME] | 20.06.1968 | Prishtinë | Prishtinë | Kosovë | 6.88
8 | [NAME] | 25.09.1970 | Gjakovë | Gjakovë | Kosovë | 7
9 | [NAME] | 09.04.1986 | Prishtinë | Prishtinë | Kosovë | 8.41 |  | privat
10 | [NAME] | 17.03.1987 | [NAME] i Madh | Lipjan | Kosovë | 8.57 |  | privat
11 | [NAME] | 23.04.1986 | Gjilan | Gjilan | Kosovë | 7.69 |  | privat
12 | Ahmet [NAME] | 03.07.1983 | Podujevë | Podujevë | Kosovë | 7.64 |  | privat
[NAME]: Kandidatët nën numrin rendor 9, 10, 11 dhe 12 në qershor të vitit 2012 i nënshtrohen provimeve nga 5 lëndë kryesore.
 |  |  |  |  | [NAME] i Fakultetit
Spreadsheet: 119688d1314660323-calculating-distance-from-origin-problem
Sheet: Sheet1

Time at origin |  |  | 5 | mins
Ave. speed to destination |  |  | 25 | km/h
Distance to origin |  |  | 5 | km
Time at destination |  |  | 10 | mins
Ave. return speed |  |  | 35 | km/h
 | 08:00:00
Vehicle A
Vehicle B
Values to be represented as km from origin
The chart should therefore appear as two irregular bell curves that are 5mins out of phase
Spreadsheet: 65360d1266021349-organize-data-based-on-criteria-and-date-voucher-maintence
Sheet: January C

Date | Last 6 | Driver # | Pick-up | 1 Stop | 2 Stop | 3 Stop | 4 Stop | W/T | Toll | Dri Fare | D Total | Co Fare | Profit
2010-01-22 00:00:00 | 123456 | 152 | 222 PICK UP | 333 1ST STOP | 3RD STOP |  |  |  |  | 36
2010-01-22 00:00:00 | 123456 | 241 | 222 ADDRESS | 333 [NAME] |  |  |  |  |  | 54
Spreadsheet: 1ae86d2d-6435-4f79-879c-eef918e551fa
Sheet: Sheet1

Table 1--Wheat: U.S. market year supply and disappearance, 2/12/2014 | Unnamed: 1 | Unnamed: 2 | Unnamed: 3 | Unnamed: 4 | Unnamed: 5 | Unnamed: 6 | Unnamed: 7 | Unnamed: 8 | Unnamed: 9
Item and unit |  |  | 2007/08 | 2008/09 | 2009/10 | 2010/11 | 2011/12 | 2012/13 | 2013/14
 | Area: Planted | Million acres | 60.46 | 63.193 | 59.168 | 53.593 | 54.409 | 55.666 | 56.156
 | Harvested | Million acres | 50.999 | 55.699 | 49.893 | 47.619 | 45.705 | 48.921 | 45.157
 | Yield | Bushels per acre | 40.2 | 44.9 | 44.5 | 46.3 | 43.7 | 46.3 | 47.2
 | Supply: Beginning stocks | Million bushels | 456.153 | 305.818 | 656.505 | 975.637 | 862.246 | 742.62 | 717.889
 | Production | Million bushels | 2051.088 | 2499.164 | 2218.061 | 2206.916 | 1999.347 | 2266.027 | 2129.695
 | Imports 1/ | Million bushels | 112.631 | 126.971 | 118.59 | 96.92 | 112.069 | 122.756 | 170
 | Total supply | Million bushels | 2619.872 | 2931.953 | 2993.156 | 3279.473 | 2973.662 | 3131.403 | 3017.584
 | Disappearance: Food use | Million bushels | 947.865 | 926.769 | 918.92 | 925.641 | 941.387 | 944.723 | 960
 | Seed use | Million bushels | 87.615 | 78.045 | 69.471 | 70.889 | 76.199 | 73.014 | 74.493
 | Feed and residual use | Million bushels | 15.962 | 255.219 | 149.831 | 129.251 | 162.372 | 388.415 | 250
 | Total domestic use | Million bushels | 1051.442 | 1260.033 | 1138.222 | 1125.781 | 1179.958 | 1406.152 | 1284.493
 | Exports 1/ | Million bushels | 1262.612 | 1015.415 | 879.297 | 1291.446 | 1051.084 | 1007.362 | 1175
 | Total disappearance | Million bushels | 2314.054 | 2275.448 | 2017.519 | 2417.227 | 2231.042 | 2413.514 | 2459.493
 | Ending stocks | Million bushels | 305.818 | 656.505 | 975.637 | 862.246 | 742.62 | 717.889 | 558.091
 | Stocks-to-use ratio |  | 13.2157 | 28.8517 | 48.3583 | 35.6709 | 33.2858 | 29.7446 | 22.6913
 | Loan rate | Dollars per bushel | 2.75 | 2.75 | 2.75 | 2.94 | 2.94 | 2.94 | 2.94
 | Contract/direct payment rate | Dollars per bushel | 0.52 | 0.52 | 0.52 | 0.52 | 0.52 | 0.52 | 0.52
 | Farm price 3/ | Dollars per bushel | 6.48 | 6.78 | 4.87 | 5.7 | 7.24 | 7.77 | 6.65-6.95
 | Government payments | Million dollars | 1118
 | Market value of production | Million dollars | 13289.326 | 16625.759 | 10654.115 | 12827.254 | 14322.909 | 17607.0298 | 14481.926
Latest market year is projected; previous market year is estimated. Totals may not add due to rounding. 1/ Includes flour and selected other products expressed in grain-equivalent bushels. 2/ Stocks owned by USDA's Commodity Credit Corporation (CCC). Most CCC-owned inventory is in the Bill Emerson Humanitarian Trust.
3/ U.S. season-average price based on monthly prices weighted by monthly marketings. Prices do not include an allowance for loans outstanding and government purchases. Source: USDA, World Agricultural Outlook Board, World Agricultural Supply and Demand Estimates and supporting materials.
Date run: 2/11/2014
Spreadsheet: 832229d1686195643-how-to-get-the-name-of-each-course-from-the-bottom-of-the-students-name-in-col-a-to-b-i-help0608
Sheet: Sheet1

student name
[NAME]
biology |  |  |  |  |  |  |  |  | biology
West Aerospace |  | language |  |  |  |  |  |  | Chemical
physics |  |  |  |  |  |  |  |  | English
language |  |  |  |  |  |  |  |  | history
West American Camp |  | Chemical | physics |  |  |  |  |  | information Technology
language |  |  |  |  |  |  |  |  | language
Chemical |  |  |  |  |  |  |  |  | math
physics |  |  |  |  |  |  |  |  | physics
[NAME] |  | physics | information Technology | English
Chemical
physics
information Technology
English
Sidney |  | math | physics | information Technology | English | language | biology
history
math
physics
information Technology
English
language
biology
[NAME] |  | language | physics | math | history
English
language
physics
math
history
[NAME] |  | English
math
English
Xizhang |  | physics | language | Chemical | history | math | information Technology | English
biology
physics
language
Chemical
history
math
information Technology
English
Spreadsheet: 124c34c2-43c7-4c7a-9260-aa6be592c0a3
Sheet: Sheet1

Unnamed: 0 | Unnamed: 1 | Unnamed: 2 | Unnamed: 3 | Unnamed: 4 | Unnamed: 5 | Unnamed: 6 | Unnamed: 7 | Unnamed: 8
 |  | POWER PLANT CAPABILITY
 |  | Unit |  | Unit Number |  | Type |  | MW(a)
 |  | Broward Gas Turbine, Power Park |  |  |  | Gas Turbines - 36 |  | 1260
 |  | Cutler |  | 5 |  | Gas |  | 68
 |  |  |  | 6 |  | Gas |  | 137
 |  |  |  |  |  | Total |  | 205
 |  | Ft. Lauderdale |  | 4 |  | Gas/Oil |  | 442
 |  |  |  | 5 |  | Gas/Oil |  | 442
 |  |  |  |  |  | Total |  | 884
 |  | Ft. Myers |  | 2 |  | Gas |  | 1432
 |  |  |  | 3 |  | Gas/Oil |  | 315
 |  |  |  |  |  | Gas Turbines - 12 |  | 648
 |  |  |  |  |  | Total |  | 2395
 |  | Manatee |  | 1 |  | Oil/Gas |  | 812
 |  |  |  | 2 |  | Oil/Gas |  | 812
 |  |  |  | 3 |  | Gas |  | 1111
 |  |  |  |  |  | Total |  | 2735
 |  | Martin |  | 1 |  | Oil/Gas |  | 826
 |  |  |  | 2 |  | Oil/Gas |  | 826
 |  |  |  | 3 |  | Gas |  | 469
 |  |  |  | 4 |  | Gas |  | 469
 |  |  |  | 8 |  | Gas/Oil/Solar Thermal |  | 1,132(b)
 |  |  |  |  |  | Total |  | 3722
 |  | Port Everglades |  | 1 |  | Oil/Gas |  | 213
 |  |  |  | 2 |  | Oil/Gas |  | 213
 |  |  |  | 3 |  | Oil/Gas |  | 387
 |  |  |  | 4 |  | Oil/Gas |  | 374
 |  |  |  |  |  | Total |  | 1187
 |  | Putnam |  | 1 |  | Gas/Oil |  | 249
 |  |  |  | 2 |  | Gas/Oil |  | 249
 |  |  |  |  |  | Total |  | 498
 |  | Scherer |  | 4 |  | Coal |  | 642(c)
 |  | St. Johns River |  | 1 |  | Coal/Petroleum Coke |  | 127(d)
 |  |  |  | 2 |  | Coal Petroleum Coke |  | 127(d)
 |  |  |  |  |  | Total |  | 254
 |  | St. Lucie |  | 1 |  | Nuclear |  | 839
 |  |  |  | 2 |  | Nuclear |  | 745(e)
 |  |  |  |  |  | Total |  | 1584
 |  | [NAME] |  | 3 |  | Oil/Gas |  | 138
 |  |  |  | 4 |  | Gas |  | 958
 |  |  |  | 5 |  | Gas |  | 972
 |  |  |  |  |  | Total |  | 2068
 |  | Turkey Point |  | 1 |  | Oil/Gas |  | 396
 |  |  |  | 2 |  | Oil/Gas |  | 392
 |  |  |  | 3 |  | Nuclear |  | 693
 |  |  |  | 4 |  | Nuclear |  | 693
 |  |  |  | 5 |  | Gas/Oil |  | 1148
 |  |  |  |  |  | Total |  | 3322
 |  | West County |  | 1 |  | Gas/Oil |  | 1219
 |  |  |  | 2 |  | Gas/Oil |  | 1219
 |  |  |  | 3 |  | Gas/Oil |  | 1219
 |  |  |  |  |  | Total |  | 3657
 |  |  |  |  |  | SYSTEM TOTAL (firm capacity) |  | 24413
 |  | Non-Firm Capacity
 |  | [NAME] |  | 1 |  | Solar PV |  | 25
 |  | Space Coast |  | 1 |  | Solar PV |  | 10
 |  |  |  |  |  | SYSTEM TOTAL (non-firm capacity) |  | 35
 |  |  |  |  | SYSTEM TOTAL (firm and non-firm capacity) |  |  | 24448
 |  | (a) Represents FPL's net ownership interest in plant capacity.
 |  | (b) The megawatts generated by the 75 mw solar thermal facility replace steam produced by this unit and therefore are not incremental.
 |  | (c) Represents FPL's approximately 76% ownership
 |  | (d) Represents FPL's 20% ownership interest in each of SJRPP Units Nos. 1 and 2.
 |  | (e) Represents FPL’s share of St. Lucie Unit No. 2, excluding Orlando Utilities Commission’s and FMPA's combined share of about 15%.
 |  | As of June 30, 2012
Spreadsheet: 799673d1665190351-merge-two-columns-and-sort-high-to-low-example-4
Sheet: Sheet1

 |  | 59
 |  | 49
 |  | 29
 | 90 |  | 90
 | 85 |  | 85
 | 80 |  | 80
 | 75 |  | 75
 | 70 |  | 70
 | 65 |  | 65
 | 60 |  | 60
 | 55 |  | 59
 | 50 |  | 55
 |  |  | 50
 |  |  | 49
 |  |  | 29
Spreadsheet: 79068d1279294705-quick-key-for-copying-cell-to-the-right-excel-help-example
Sheet: Sheet1

Value 1 | Value 2 | What I want
a | b | a
a | b | b
a | b | a
a | b | b
a | b | a
a | b | b
a | b | a
Spreadsheet: 704233d1605457771-sumifs-between-dates-and-times-vendas-online-2020
Sheet: Dashboard

[NAME] | Canal de Vendas | Em processo | Enviado | Manual sent | Cancelado | Entregue | [NAME] | Média Vendas P/Canal | Total | [NAME] | Beneficio %
2020-08-01 00:00:00 | FNAC
 | LOJA NA MÃO
 | Direto
2020-09-01 00:00:00 | FNAC
 | LOJA NA MÃO
 | Direto
2020-10-01 00:00:00 | FNAC
 | LOJA NA MÃO
 | Direto
2020-11-01 00:00:00 | FNAC
 | LOJA NA MÃO
 | Direto
2020-12-01 00:00:00 | FNAC
 | LOJA NA MÃO
 | Direto
 | Totals:
Spreadsheet: 7604175c-90fb-490c-93dd-06c638e45422
Sheet: Report

Department | Department Priority | Unit | Unit Priority | Unit Goal Id | [NAME] | Objective Id | Objective Name | Objective Priority | Strategic Direction | Impact Type
Accounting | 2 |  |  |  | Fiscal Service Training | 1.1 | Training Opportunities | 1 | None | -- Pick One --
Accounting | 3 |  |  |  | Improve Communications | 2.1 | Disseminate Fiscal Services Information | 1 | None | -- Pick One --
Accounting | 1 |  |  |  | Input Opportunities | 3.1 | Create Method of Submitting Suggestions | 1 | None | -- Pick One --
Accounting | 2 |  |  |  | Implementation of Effectiveness Measures | 4.1 | Assign Personnel | 2 | None | -- Pick One --
Spreadsheet: 113134d1309110839-modify-formula-to-not-execute-if-cell-contains-certain-text-example-2
Sheet: Sheet1

 |  | Primary Qualification Enrolled Into |  |  |  | Related Qualification
 |  | Code | Description | C/RPL/CT |  | Related Qualification | Related Required Units | Relationship | C/RPL/CT
Step 1 | [NAME] | PSP41404
 | Required Unit set out in Qualification Descriptor
 |  |  |  |  |  |  | Other Required Uits | Relationship | C/RPL/CT
Step 2 | Select Electives | Required Number of Electives | Code and Description | C/RPL/CT
 | Must be  at same or higher qualification level |  | PSPGOV422A Apply government processes
 |  |  | PSPETHC501B Promote the values and ethos of public service |  |  |  |  |  |  | Total REQ
 |  |  | PSPGOV402B Deliver and monitor service to clients
 |  |  | PSPFRAU407B Conduct fraud control awareness sessions
 |  |  | PSPFRAU401B Monitor data for indicators of fraud |  |  |  | Related Elective Units | Relationship | C/RPL/CT
 |  |  | [NAME] and validate data
 |  |  | PSPREG416A Conduct data analysis
 |  |  | Qualifications Achieved as part of selected program
 |  |  |  |  |  |  |  |  |  | Total ELEC
 |  | Qualification
 |  | Qualification
 |  | Qualification |  |  |  | Related Qualification | Related Required Units | Relationship | C/RPL/CT
 |  | Instructions for completing this form
 |  | This form is designed so that if an individual or agency desires to do additional units outside of the required number of electives, they can make an informed decisions as to what qualifications can be achieved by selecting certain units of competencies
 | Step 1 | Select the Qualification Code from the drop down list
 | Step 2 | Select the desired number of electrives from the drop down list
 |  | The right hand area displays what the additional qualifications the required units and selected electives go towards
 |  | The Related Qualification area is automatically updated from the dispayed/selected units in the Primary Qualification area
 |  | The relevant qualifications that are achieved as a result of the selected program are displayed above
 |  |  |  |  |  |  | Other Required Uits | Relationship | C/RPL/CT
 |  |  |  |  |  |  |  |  |  | Total REQ
Spreadsheet: 274293d1383065552-conditional-formatting-dates-based-on-date-range-and-day-gantt-cf-example
Sheet: Sheet1

Attendance |  |  | 21 Day | 48hr | Pilot Start | Pilot End | [NAME] | P1 End | [NAME] |  | [NAME]
Mon | Thu | Days | 2013-10-14 00:00:00 | 2013-10-31 00:00:00 | 2013-10-14 00:00:00 | 2013-10-31 00:00:00 | 2013-11-04 00:00:00 | 2013-11-14 00:00:00 | 2014-01-06 00:00:00 |  | 2014-02-28 00:00:00 |  | 2013-11-04 00:00:00 |  |  | 2013-11-05 00:00:00 |  |  | 2013-11-06 00:00:00 |  |  | 2013-11-07 00:00:00 |  |  | 2013-11-08 00:00:00 |  |  | 2013-11-09 00:00:00 |  |  | 2013-11-10 00:00:00 |  |  | 2013-11-11 00:00:00 |  |  | 2013-11-12 00:00:00 |  |  | 2013-11-13 00:00:00 |  |  | 2013-11-14 00:00:00 |  |  | 2013-11-15 00:00:00 |  |  | 2013-11-16 00:00:00 |  |  | 2013-11-17 00:00:00 |  |  | 2013-11-18 00:00:00 |  |  | 2013-11-19 00:00:00 |  |  | 2013-11-20 00:00:00 |  |  | 2013-11-21 00:00:00 |  |  | 2013-11-22 00:00:00 |  |  | 2013-11-23 00:00:00 |  |  | 2013-11-24 00:00:00 |  |  | 2013-11-25 00:00:00 |  |  | 2013-11-26 00:00:00 |  |  | 2013-11-27 00:00:00 |  |  | 2013-11-28 00:00:00 |  |  | 2013-11-29 00:00:00 |  |  | 2013-11-30 00:00:00 |  |  | 2013-12-01 00:00:00
Sun | Wed | Nights | N/A | N/A | N/A | N/A | 2013-10-13 00:00:00 | 2013-10-21 00:00:00 | 2013-10-27 00:00:00 |  | 2013-12-01 00:00:00 |  | 2013-11-04 00:00:00 |  |  | 2013-11-05 00:00:00 |  |  | 2013-11-06 00:00:00 |  |  | 2013-11-07 00:00:00 |  |  | 2013-11-08 00:00:00 |  |  | 2013-11-09 00:00:00 |  |  | 2013-11-10 00:00:00 |  |  | 2013-11-11 00:00:00 |  |  | 2013-11-12 00:00:00 |  |  | 2013-11-13 00:00:00 |  |  | 2013-11-14 00:00:00 |  |  | 2013-11-15 00:00:00 |  |  | 2013-11-16 00:00:00 |  |  | 2013-11-17 00:00:00 |  |  | 2013-11-18 00:00:00 |  |  | 2013-11-19 00:00:00 |  |  | 2013-11-20 00:00:00 |  |  | 2013-11-21 00:00:00 |  |  | 2013-11-22 00:00:00 |  |  | 2013-11-23 00:00:00 |  |  | 2013-11-24 00:00:00 |  |  | 2013-11-25 00:00:00 |  |  | 2013-11-26 00:00:00 |  |  | 2013-11-27 00:00:00 |  |  | 2013-11-28 00:00:00 |  |  | 2013-11-29 00:00:00 |  |  | 2013-11-30 00:00:00 |  |  | 2013-12-01 00:00:00
Mon | Fri | Nights | N/A | N/A | N/A | N/A |  |  | 2013-11-11 00:00:00 |  | 2013-11-22 00:00:00 |  | 2013-11-04 00:00:00 |  |  | 2013-11-05 00:00:00 |  |  | 2013-11-06 00:00:00 |  |  | 2013-11-07 00:00:00 |  |  | 2013-11-08 00:00:00 |  |  | 2013-11-09 00:00:00 |  |  | 2013-11-10 00:00:00 |  |  | 2013-11-11 00:00:00 |  |  | 2013-11-12 00:00:00 |  |  | 2013-11-13 00:00:00 |  |  | 2013-11-14 00:00:00 |  |  | 2013-11-15 00:00:00 |  |  | 2013-11-16 00:00:00 |  |  | 2013-11-17 00:00:00 |  |  | 2013-11-18 00:00:00 |  |  | 2013-11-19 00:00:00 |  |  | 2013-11-20 00:00:00 |  |  | 2013-11-21 00:00:00 |  |  | 2013-11-22 00:00:00 |  |  | 2013-11-23 00:00:00 |  |  | 2013-11-24 00:00:00 |  |  | 2013-11-25 00:00:00 |  |  | 2013-11-26 00:00:00 |  |  | 2013-11-27 00:00:00 |  |  | 2013-11-28 00:00:00 |  |  | 2013-11-29 00:00:00 |  |  | 2013-11-30 00:00:00 |  |  | 2013-12-01 00:00:00
Spreadsheet: 215531d1361398629-transfer-data-between-worksheets-using-criteria-ef359_excelexample2
Sheet: Worksheet "2"

A | B | C | D | E | F | G | H | I | J | K | L | M | N | seq
ABC123DEF456X | ABC123 | Yes | No | No | No | Yes | Yes | No | Yes | Georgia
GHI789JKL123Z | GHI789 | No | Yes | No | No | No | Yes | No | No | Alaska | [NAME] | [PHONE] | ([EMAIL])
MNO456PQR789 | MNO456 | No | No | Yes | No | No | Yes | Yes | No | Missouri |  | [PHONE]
STU123VWX456 | STU123 | No | No | No | Yes | Yes | Yes | No | No | Nevada |  |  | ([EMAIL])
YZA789BCD123 | YZA789 | Yes | No | No | No | Yes | Yes | Yes | No | Florida | [NAME]
Spreadsheet: 737570d1624476119-2-columns-instead-of-zz-example-forum-23062021
Sheet: Blad1

nummer | ref
1 | a | b | c | d | e | f | g | h | i | j | k | l | m | n | o | p
2 | a | b | c | d | e | f | g
3 | a | b | c | d | e | f | g | h | i | j | k
4 | k | l | m | n | o | p | q | r | s | t
Has to become
number | ref
1 | a
1 | b
1 | c
1 | d
1 | e
1 | f
1 | g
1 | h
1 | j
1 | k
1 | l
1 | m
1 | n
1 | p
2 | a
2 | b
2 | c
2 | d
2 | e
2 | f
2 | g
3 | a
3 | b
3 | c
3 | d
3 | e
3 | f
3 | g
3 | h
3 | j
3 | k
4 | k
4 | l
4 | m
4 | n
4 | o
4 | p
4 | q
4 | r
4 | s
4 | t
Spreadsheet: 102208d1300206739-excel-2007-nested-sumif-or-using-sumifs-test-1
Sheet: Sheet1

 | 1 | 2 | 3 | 4 | 5
Yes | 50 | 45 | 30 | 20 | 5
No | 45 | 40 | 25 | 15 | 4
Maybe | 40 | 35 | 20 | 10 | 3
NA | 35 | 30 | 15 | 5 | 2
Needs to Read like this:
Agency | Yes | No | Maybe | NA
1 | 50 | 45 | 40 | 35
5 | 5 | 4 | 3 | 2
3 | 30 | 25 | 20 | 15
2 | 45 | 40 | 35 | 30
4 | 20 | 15 | 10 | 5
I need to search indeffinate Columns for a specific ID then search Indeffinate Rows for a Specific Data Type and give the corresponding data.
 | A | B | C | D
Days | 365 | 250 | 159 | 73
Min | 1538 | 468 | 5497 | 25
Hours | 548 | 45 | 548 | 3
Visits | 154987 | 2155 | 5484 | 99
Units | 35484 | 321854 | 54984 | 875
Agency |  |  | * I want to be able to drop A-D in and the correct Units, Hrs, Days, etc drop in by searching for that data type.
Units
Hours
Visits
Days
Spreadsheet: sally_beck__33929__Weekly Operating Report 2-1
Sheet: EIM New Deals

New Deals for | JANUARY |  |  |  |  |  |  |  | FEBRUARY
 | Week Ending 4 |  | Week Ending 11 |  | Week Ending 18 |  | Week Ending 25 |  | Week Ending 1 |  | Week Ending 8 |  | Week Ending 16 |  | Week Ending 23
 | EOL | Non-EOL | EOL | Non-EOL | EOL | Non-EOL | EOL | Non-EOL | EOL | Non-EOL | EOL | Non-EOL | EOL | Non-EOL | EOL | Non-EOL
Financial
ENA
Gas (Calgary)
Gas (Houston)
Power (Houston)
Power (Calgary)
EIM
Lumber | 0 | 23 | 0 | 7 | 0 | 10 | 0 | 19 | 0 | 19
Newsprint | 0 | 2 | 2 | 0 | 0 | 2 | 0 | 2 | 0 | 0
Pulp (recycled paper) | 0 | 1 | 0 | 4 | 0 | 12 | 0 | 10 | 0 | 4
Steel | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 1
EGM
IR/FX
Weather
Liquids
Emissions
Physical
ENA
Gas (Houston)
Gas (Calgary)
Power (Houston)
Power (Calgary)
EIM
Lumber | 1 | 62 | 12 | 107 | 10 | 83 | 2 | 103 | 5 | 62
Newsprint | 0 | 3 | 0 | 15 | 1 | 6 | 0 | 22 | 0 | 4
Pulp (recycled paper) | 4 | 1 | 3 | 10 | 0 | 12 | 0 | 9 | 2 | 23
Steel | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0
EGM
Liquids
Coal