tianzl66/Sheetpedia huggingface dataset:
Spreadsheet: john_forney__15504__200107
Sheet: ERCOT-ASSET

EPMI-ERCOT-ASSET
 |  | Deal Number | Total |  | 7/1 - 7/2 | 7/3 - 7/4 | 2001-07-05 00:00:00 | 7/6 - 7/8 | 2001-07-09 00:00:00 | 2001-07-10 00:00:00
Static Scheduling | Reliant Energy HL&P | 628670 |  |  |  |  | 49 | 98
 | Texas New Mexico Power | 628673
 | [NAME] | 628674 |  |  | 80 | 80 | 40 | 120 |  | 40
 | [NAME] | 670636
Unplanned Losses | American Electric Power Services Corp | 628675 |  |  | -10.51 | -4373.6 | 5.68 | 36.54 | 5.76 | -1609.16
 | [NAME] | 628676 |  |  | -84.82 | -51.34 | 1.8 | 42.71 | -2.56 | 56.23
 | [NAME] | 628678 |  |  | -76.41 | -6.22 | -5.41 | -26.82 | -7.8 | -131.89
 | Bryan Texas Utilities | 628680 |  |  | 63.09 | 8.29 | -0.08 | 34.59 | 4.25 | 143.79
 | City of Denton Municipal Utilities
 | City of Garland | 628681 |  |  |  | 2.66 | -0.08 | -0.08 | -0.08
 | City Public Services | 628682 |  |  | -92.54 | -465.63 | 19.08 | 135.55 | -3.45 | -44.27
 | Farmer's Electric Cooperative
 | Grayson-Collin Electric Cooperative
 | Greenville Electric Utility System
 | Lower Colorado River Authority | 628684 |  |  | -11.22 | 88.75 | 152.06 | 776.03 | -2.66 | 395.17
 | Magic Valley Electric Cooperative | 628689 |  |  |  | -110.79 |  |  |  | -41.91
 | Public Utilities Board of Brownsville | 628703 |  |  |  | -14.22 |  |  |  | -5.47
 | Reliant Energy HL&P | 628704 |  |  | 33.65 | 1152.02 | 16.83 | -7.88 | 0.18 | 167.38
 | Rio Grande Electric Cooperative
 | South Texas Electric Cooperative | 628705 |  |  | -7.02 | -253.28 | 0.53 | 11.97 | -1.23 | -78.38
 | Southwest Electric Service Company | 670666
 | Texas Municipal Power | 628706 |  |  | 89.73 | 4.63 | -0.88 | 46.69 | 6.29 | 206.03
 | Texas New Mexico Power | 628707 |  |  | 32.25 | 1.44 |  | 15.89 | 0.97 | 73.28
 | Tex-La Electric Cooperative
 | TXU Electric Services | 628708 |  |  | -201.19 | 20.77 | -71.05 | -26.03 | -77.36 | -265.42
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 88
Seasonal loss matrix changes in July! Check website
password for Totals sheet = ercot
 | Counterparty Name
 | TXU Electric Services | TUET
 | Texas New Mexico Power | TNMP
 | Reliant Energy HL&P | REIT
 | City Public Services | CPST
 | American Electric Power Services Corp | WTUC
 | Lower Colorado River Authority | LCRA
 | American Electric Power Services Corp | CPLC
 | [NAME] | AENX
 | [NAME] | BEPCTMPP
 | Texas Municipal Power | TMPA
 | South Texas Electric Cooperative | STEC
 | South Texas Electric Cooperative | SMEC
 | Public Utilities Board of Brownsville | PUBX
 | Southwest Electric Service Company | SESC
 | Farmer's Electric Cooperative | FECX
 | TXU Electric Services | TNMPTUET
 | TXU Electric Services | COCS
 | Tex-La Electric Cooperative | TXLA
 | Magic Valley Electric Cooperative | MVEC
 | South Texas Electric Cooperative | MECX
 | TXU Electric Services | TVEC
 | City of Garland | COGX
 | Rio Grande Elerctic Cooperative | RGEC
 | Grayson-Collin Electric Cooperative | GCEC
 | Bryan Texas Utilities | BRYN
 | City of Denton Municipal Utilities | CODX
 | Grrenville Electric Utiliy System | GEUS
Spreadsheet: 715089d1611563175-vlookup-with-cell-background-color-vlookup-with-cell-background
Sheet: Sheet2

Districts | Values |  |  | I wish to vlookup in Sheet2 + ColumnB (please look sample in B2) with background cell color from sheet1 + ColumnB
Maharashtra
[NAME] |  |  |  | NOTE: I have huge actual data set around with 48,972 line items in sheet1 & sheet2 hence I need to vlookup with cell background color.
Anuppur
[NAME]
Balaghat
Barwani
[NAME]
Bhind
Bhopal
[NAME]
Chachauda
Chhatarpur
[NAME]
Damoh
Datia
Dewas
Dhar
Dindori
Guna
Gwalior
Harda
Hoshangabad
Indore
Jabalpur
Jhabua
[NAME]
Khandwa
Khargone
Maihar
Mandla
Mandsaur
Morena
Nagda
Narsinghpur
Neemuch
Niwari
[NAME]
Raisen
[NAME]
Ratlam
[NAME]
Sagar
[NAME]
Sehore
Seoni
[NAME]
[NAME]
Sheopur
Shivpuri
Sidhi
Singrauli
[NAME]
Ujjain
Umaria
Vidisha
Uttar Pradesh
Meghaliya
[NAME]
Nagpur
Spreadsheet: 68679d1d-6391-4c9b-a111-ebd085c0ddbd
Sheet: 2

 | Jul 26 |  | Aug 2 |  | Aug 9 |  | Aug 16
 | Long | Short | Long | Short | Long | Short | Long | Short
Total Interest Rate* | 415233742 | 415233742 | 416033383 | 416033383 | 418052416 | 418052416 | 418996714 | 418996714
SD/MSPs | N/A*** | N/A | N/A | N/A | N/A | N/A | N/A | N/A
Financials | N/A | N/A | N/A | N/A | N/A | N/A | N/A | N/A
End Users | N/A | N/A | N/A | N/A | N/A | N/A | N/A | N/A
Total Cross-Currency | 16491326 | 16491326 | 16487218 | 16487218 | 16590667 | 16590667 | 16560789 | 16560789
SD/MSPs | N/A | N/A | N/A | N/A | N/A | N/A | N/A | N/A
Financials | N/A | N/A | N/A | N/A | N/A | N/A | N/A | N/A
End Users | N/A | N/A | N/A | N/A | N/A | N/A | N/A | N/A
Total Credit | 20363235 | 20363235 | 20576003 | 20576003 | 20631539 | 20631539 | 20545182 | 20545182
Dealers** | 17079885 | 17053096 | 17272030 | 17230957 | 17326332 | 17283132 | 17199898 | 17155701
Buyside | 3283350 | 3310139 | 3303973 | 3345047 | 3305207 | 3348407 | 3345283 | 3389480
Total Equity | 5994004 | 5994004 | N/A | N/A | N/A | N/A | N/A | N/A
SD/MSPs | N/A | N/A | N/A | N/A | N/A | N/A | N/A | N/A
Financials | N/A | N/A | N/A | N/A | N/A | N/A | N/A | N/A
End Users | N/A | N/A | N/A | N/A | N/A | N/A | N/A | N/A
Total Other Commodity | 3091000 | 3091000 | 3091000 | 3091000 | 3091000 | 3091000 | 3091000 | 3091000
SD/MSPs | N/A | N/A | N/A | N/A | N/A | N/A | N/A | N/A
Financials | N/A | N/A | N/A | N/A | N/A | N/A | N/A | N/A
End Users | N/A | N/A | N/A | N/A | N/A | N/A | N/A | N/A
Weekly snapshot, estimated gross notional amount outstanding by asset class and participant type (millions of USD), all products, origins, currencies, tenors, and participant types, cleared and uncleared. Data are adjusted for double-counting of cleared trades to show a single exposure for each trade.
*See Data Dictionary for asset class descriptions.
**See Explanatory Notes for participant type descriptions.
***N/A indicates that data are not currently available.
The Commission requests feedback on the format and content of this CFTC Swaps Report table. Submit comments to [EMAIL]
Spreadsheet: 02e36d03-14a0-4c29-9e83-502963ef59c7
Sheet: 2-3T

 | Section 2: Inventory
 | Table 2-3Trend:  Domestic and Foreign Inventory by Year
 | Vehicle Type | 2009 | 2010 | 2011 | 2012 | 2013
 | Domestic Passenger Vehicles | 218936 | 228915 | 227689 | 222261 | 214074
 | Domestic Trucks | 379178 | 380209 | 378612 | 370765 | 367902
 | Domestic Other | 7701 | 7789 | 7809 | 8019 | 7851
 | Domestic | 605815 | 616913 | 614110 | 601045 | 589827
 | Foreign Passenger Vehicles | 20878 | 20444 | 21708 | 23539 | 21550
 | Foreign Trucks | 23238 | 22920 | 22426 | 23826 | 22673
 | Foreign Other | 1772 | 1877 | 1614 | 1651 | 1698
 | Foreign | 45888 | 45241 | 45748 | 49016 | 45921
 | Grand Total | 651703 | 662154 | 659858 | 650061 | 635748
Spreadsheet: 117609d1312909836-how-to-line-up-four-columns-of-data-lineup4columns
Sheet: Sheet1

SOURCE DATA
Name | Data | Name | Data Difference |  |  | All Names | Data | Data Difference
Jones | 300 | [NAME] | 500 |  |  | [NAME]
Newbie | 100 | Jones | 200 |  |  | Jones
Oldby | 400 | Smith | 100 |  |  | Newbie
[NAME] | 300 |  |  |  |  | Oldby
Smith | 100 |  |  |  |  | [NAME]
 |  |  |  |  |  | Smith
Spreadsheet: eric_saibi__9859__101101R
Sheet: Blackstone 01

Owner Name |  | American National Power Company
Station Name |  | Blackstone Power Plant
Unit Name |  | Unit 01 CT / HRSG
NERC Region |  | NPCC
State |  | TX
Fuel Type |  | Natural Gas
Capacity |  | 290 MW
Start Date |  | 2001-09-01 00:00:00
End Date |  | 2001-10-15 00:00:00
Prv. Start Date |  | 2001-09-01 00:00:00
Prv. End Date |  | 2001-10-12 00:00:00
Comments |  | Design Issues
SIC |  | 4931
Plant ID |  | 1033441
Unit ID |  | 1012822
Outage ID |  | 18240
Spreadsheet: 819517d1677555626-formula-for-pesky-time-formats-loadout-log-template
Sheet: Weekly Results

 |  | Week
 |  | 3
 |  | 1st Shift | Sunday | Monday | Tuesday | Wednesday | Thursday | Friday | Saturday | Totals
 |  |  |  |  |  |  |  |  |  | Averages
 |  | Total Loads by Day
 |  | [NAME] on 1st Shift
 |  | Total Case Count
 |  | Total Pallet Count
 |  | Average Load Time
 |  | Total Downtime on 1st Shift
 |  | Total Hours Worked | 10 | 10 | 10 | 10 | 10 | 10 | 10
 |  | Total Load Time
 |  | 2nd Shift | Sunday | Monday | Tuesday | Wednesday | Thursday | Friday | Saturday | Totals
 |  |  |  |  |  |  |  |  |  | Averages
 |  | Total Loads by Day
 |  | [NAME] on 2nd Shift
 |  | Total Case Count
 |  | Total Pallet Count
 |  | Average Load Time
 |  | Total Downtime on 2nd Shift
 |  | Total Hours Worked | 8 | 8 | 10 | 8 | 10 | 8 | 8
 |  | Total Load Time
Spreadsheet: 00d918fa-4f64-453d-b01d-86dbd8cd0e99
Sheet: OVERALL SUMMARY

[NAME]
OVERALL BUDGET SUMMARY
(Insert Overall Project Period)
CATEGORIES |  |  |  | Amendment        (If Applicable)
I.       PERSONNEL SERVICES
II.      CONSULTANT  SERVICES
III.     SUBCONTRACT SERVICES
IV.     PATIENT SERVICES
[NAME]
VI.     SUPPLIES
VII.    TRAVEL
VIII.   OTHER COSTS
TOTAL
-1-
Spreadsheet: 108466d1305548629-get-data-in-one-sheet-sample-sheet-mahju
Sheet: Leave Tracker

 | From | To | Request | My Id | Agent Id | Agent Name | Reason | Remarks | Days Applied
1-101-Leave | 2011-05-01 00:00:00 | 2011-05-02 00:00:00 | Leave | 100 | 101 | abc | Exams | Please approve | 2
1-102-Off | 2011-05-06 00:00:00 | 2011-05-06 00:00:00 | Off | 100 | 102 | xyz | Exams | Please approve | 1
1-103-Leave | 2011-05-11 00:00:00 | 2011-05-11 00:00:00 | Leave | 100 | 103 | Sharath | Exams | Please approve | 1
1-104-Leave | 2011-05-16 00:00:00 | 2011-05-16 00:00:00 | Leave | 100 | 104 | Vinay | Exams | Please approve | 1
1-105-Leave | 2011-05-21 00:00:00 | 2011-05-21 00:00:00 | Leave | 100 | 105 | [NAME] | Exams | Please approve | 1
1-106-Leave | 2011-05-26 00:00:00 | 2011-05-26 00:00:00 | Leave | 100 | 106 | Shanta | Exams | Please approve | 1
1-107-Leave | 2011-05-31 00:00:00 | 2011-05-31 00:00:00 | Leave | 100 | 107 | Rakesh | Exams | Please approve | 1
2-101-Leave | 2011-05-05 00:00:00 | 2011-05-15 00:00:00 | Leave | 100 | 101 | abc | Exams | Please approve | 11
2-102-Leave | 2011-06-10 00:00:00 | 2011-06-10 00:00:00 | Leave | 100 | 102 | xyz | Exams | Please approve | 1
1-110-Leave | 2011-06-15 00:00:00 | 2011-06-15 00:00:00 | Leave | 100 | 110 | Avinash | Exams | Please approve | 1
3-101-Off | 2011-06-20 00:00:00 | 2011-06-30 00:00:00 | Off | 100 | 101 |  |  |  | 11
Spreadsheet: 138491d1327681524-populate-table-from-other-sheets-based-on-drop-down-selection-fast-card-2012
Sheet: Machines Not Installed >60 Days

Machines Not Installed, Older than 60 Days
 |  | Rank |  | Rank |  | Rank |  | Rank |  | Rank |  | Rank |  | Rank
 | 2012 YTD |  | January 2012 |  | February 2012 |  | March 2012 |  | April 2012 |  | May 2012 |  | June 2012
Ahub |  |  | 100 |  | 200
Dhub
Hhub
Ihub
[NAME]
Lhub |  | - |  | - |  | - |  | - |  | - |  | - |  | -
Mhub
Nhub
Ohub
Shub
Uhub
Vhub
Wino
Yhub |  | - |  | - |  | - |  | - |  | - |  | - |  | -
Total |  | 13 |  | 2 |  | 3 |  | 4 |  | 5 |  | 6 |  | 7
 | July 2012 |  | August 2012 |  | September 2012 |  | October 2012 |  | November 2012 |  | December 2012
Ahub
Dhub
Hhub
Ihub
[NAME]
Lhub |  | - |  | - |  | - |  | - |  | - |  | -
Mhub
Nhub
Ohub
Shub
Uhub
Vhub
Wino
Yhub |  | - |  | - |  | - |  | - |  | - |  | -
Total |  | 9 |  | 10 |  | 11 |  | 8 |  | 13 |  | 12
Spreadsheet: theresa_staab__39621__12aug-23aug01
Sheet: Sheet1

DESERT POWER PLANT
ESTIMATED GAS NEEDS
(mmbtu)
 |  |  |  | 2232
Date | Estimated Maximum Daily Rate Required | Estimated Total Volume Required | Nomination | Estimated Actual | Cumulative Imbalance
12 Aug 01, Sun | 3000 | 1500 | 0 | 453.1
13 Aug 01, Mon | 3000 | 1500 | 0 | 0
14 Aug 01, Tue | 3000 | 1500 | 0 | 579.46
15 Aug 01, Wed | 3000 | 1500 | 0 | 1158.04
16 Aug 01, [NAME] | 3000 | 1500 | 1200 | 0
17 Aug 01, Fri | 3000 | 1500 | 0 | 0
18 Aug 01, Sat | 3000 | 1500 | 0 | 0
19 Aug 01, Sun | 3000 | 1500 | 0 | 0
20 Aug 01, Mon | 3000 | 1500 | 0 | 0
21 Aug 01, Tue | 3000 | 1500 | 0 | 0
22 Aug 01, Wed | 3000 | 1500 | 0 | 0
23 Aug 01,Thur | 3000 | 1500 | 4000 | 0
NOTE: | Gas total for 12 Aug 01 is cumulative value for 10 Aug through 12 Aug 2001
NOTE: | These are projections only based on plant start-up.  Actual may vary significantly
 | (probably downward) depending on how start-up progresses.  [NAME]
 | will coordinate intraday needs directly with Questar Gas Control as per prior instructions
Spreadsheet: 64553d1265377907-problem-with-choices-disappearing-in-forms-combobox-when-selected-problem
Sheet: Sheet2

 |  | ACTIVITY 1
A |  | COMMUNICATION
B |  | CONSULTATION
C |  | DATA ANALYSIS
D |  | DATA REPORTING
E |  | EVALUATION
F |  | IMPLEMENTATION
G |  | MANAGEMENT
H |  | MEETINGS
I |  | PROFESSIONAL DEVELOPMENT
J |  | TRAINING
K
L |  | ACTIVITY 2
M |  | COMMUNICATION
N |  | CONSULTATION
O |  | DATA ANALYSIS
P |  | DATA REPORTING
Q |  | EVALUATION
R |  | IMPLEMENTATION
S |  | MANAGEMENT
T |  | MEETINGS
U |  | PROFESSIONAL DEVELOPMENT
V |  | TRAINING
W
X |  | ACTIVITY 3
Y |  | COMMUNICATION
Z |  | CONSULTATION
 |  | DATA ANALYSIS
 |  | DATA REPORTING
 |  | EVALUATION
 |  | IMPLEMENTATION
 |  | MANAGEMENT
 |  | MEETINGS
 |  | PROFESSIONAL DEVELOPMENT
 |  | TRAINING
 |  | ACTIVITY 4
 |  | COMMUNICATION
 |  | CONSULTATION
 |  | DATA ANALYSIS
 |  | DATA REPORTING
 |  | EVALUATION
 |  | IMPLEMENTATION
 |  | MANAGEMENT
 |  | MEETINGS
 |  | PROFESSIONAL DEVELOPMENT
4 |  | TRAINING
11
19 |  | ACTIVITY 5
15 |  | COMMUNICATION
1 |  | CONSULTATION
1 |  | DATA ANALYSIS
1 |  | DATA REPORTING
1 |  | EVALUATION
1 |  | IMPLEMENTATION
1 |  | MANAGEMENT
1 |  | MEETINGS
1 |  | PROFESSIONAL DEVELOPMENT
1 |  | TRAINING
1
1
15
Spreadsheet: 755251d1636734146-spreading-contract-amount-across-months-by-start-end-date-revenuerecoghelp
Sheet: RevForecast-High Prob

 | SUMMARY
 | RevType1 |  |  | (I will hide these columns for the final workbook)
 | RevType2
 | RevType3
 | TOTAL
 | TOTAL VS BUDGET CHECK - SHOULD BE $0
 | Customer: Name | Item: Name | Amount | Number of months | Monthly Amount | Start Date | End Date | Revenue Type | 2022-01-31 00:00:00 | 2022-02-28 00:00:00 | 2022-03-31 00:00:00 | 2022-04-30 00:00:00 | 2022-05-31 00:00:00 | 2022-06-30 00:00:00 | 2022-07-31 00:00:00 | 2022-08-31 00:00:00 | 2022-09-30 00:00:00 | 2022-10-31 00:00:00 | 2022-11-30 00:00:00 | 2022-12-31 00:00:00 | Full Range | DIFFERENCE
 | Customer 1 | Product 1 | 85000 |  |  | 2022-02-01 00:00:00 | 2022-07-31 00:00:00 | RevType1
 | Customer 2 | Product 2 | 325000 |  |  | 2022-01-01 00:00:00 | 2022-12-31 00:00:00 | RevType2
 | Customer 3 | Product 3 | 152000 |  |  | 2022-06-01 00:00:00 | 2022-12-31 00:00:00 | RevType3
 | Customer 4 | Product 1 | 500000 |  |  | 2022-06-15 00:00:00 | 2023-06-14 00:00:00 | RevType1
 |  |  |  |  |  |  | Totals
Spreadsheet: john_griffith__16147__1_25_02LO
Sheet: Sheet1

 |  |  | SCS  OPTION  DATA
 | TICKER | STRIKE | STR BID | STR ASK | B VOL | A VOL | M STD/DAY | WHEN
 | CL H2 | 20 | 175 | 185 | 46.9 | 49.6 | 0.61 | 2002-01-25 10:05:00
 | CL J2 | 20 | 272 | 285 | 46.8 | 49 | 0.6 | 2002-01-25 10:05:00
 | CL K2 | 20 | 345 | 360 | 46.1 | 48.1 | 0.59 | 2002-01-25 10:05:00
 | CL M2 | 20 | 390 | 405 | 45 | 46.7 | 0.58 | 2002-01-25 10:05:00
 | CL N2 | 20.5 | 430 | 445 | 42.8 | 44.3 | 0.56 | 2002-01-25 10:05:00
 | CL Q2 | 20.5 | 450 | 470 | 40.9 | 42.7 | 0.54 | 2002-01-25 10:05:00
 | CL U2 | 20.5 | 460 | 480 | 38.8 | 40.5 | 0.51 | 2002-01-25 10:05:00
 | [NAME] | 20.5 | 470 | 490 | 36.9 | 38.5 | 0.49 | 2002-01-25 10:05:00
 | CL X2 | 20.5 | 475 | 495 | 35.2 | 36.7 | 0.46 | 2002-01-25 10:05:00
 | [NAME] | 20.5 | 485 | 500 | 34.3 | 35.4 | 0.45 | 2002-01-25 10:05:00
 | CL F3 | 20.5 | 490 | 510 | 33.1 | 34.5 | 0.44 | 2002-01-25 10:05:00
 | CL G3 | 20.5 | 495 | 515 | 32.1 | 33.5 | 0.42 | 2002-01-25 10:05:00
 | CL M3 | 20.5 | 520 | 540 | 29.7 | 30.9 | 0.39 | 2002-01-25 10:05:00
 | CL Z3 | 20.5 | 530 | 550 | 26.4 | 27.5 | 0.35 | 2002-01-25 10:05:00
 | CL M4 |  |  |  | 21.8 | 24.4 | 0.31 | 2002-01-04 13:39:00
 |  |  |  |  |  |  |  | ,
Spreadsheet: 1da7eaca-269e-4e2f-a8e9-db7cb9496951
Sheet: 2013 Interns by Function

2013 Interns
Function | % | Base Salary Range* | Median
Consulting | 0.2831050228310502
Management Consulting | 0.2328767123287671 | 2,000 - 12,083 | 11200
Strategic Planning | 0.0502283105022831 | 1,500 - 11,250 | 5000
Finance (Internal) | 0.0776255707762557
Business / Corporate Development | 0.0410958904109589 | 1,500 - 10,000 | 5700
Corporate Finance | 0.0365296803652968 | 1,200 - 8,333 | 6512
Financial Services | 0.367579908675799
Buy Side/Sell Side Research | 0.06621004566210045 | 3,000 - 12,083 | 8333
Investment Banking/M&A | 0.1529680365296804 | 4,000 - 10,833 | 8333
Investment Management | 0.05251141552511415 | 2,000 - 15,000 | 8183
Private Client Services / Wealth Mgmt | 0.01141552511415525 | 8,333 - 10,000 | 8333
Private Equity/LBO's | 0.0365296803652968 | 1,000 - 12,500 | 6500
Sales and Trading | 0.0136986301369863 | 4,000 - 8,333 | 8333
Other | 0.03424657534246575 | 3,222 - 8,333 | 7000
Management | 0.045662100456621
General Management | + | 2,500 - 8,000 | 6500
Operations | 0.0136986301369863 | 3,300 - 8,000 | 6500
Project Management | 0.01598173515981735 | 2,800 - 8,000 | 5500
Other | + | 4,000 - 6,000 | 5000
Marketing | 0.1141552511415525
Brand-Product Management | 0.0730593607305936 | 1,600 - 8,333 | 6604
Business/Product Development | 0.0228310502283105 | 3,200 - 8,800 | 6800
Other | 0.0182648401826484 | 5,000 - 10,000 | 7684
Other Functions | 0.0593607305936073
Development / Rotational Program | 0.0182648401826484 | 4,000 - 10,000 | 8000
Other | 0.0410958904109589 | 2,400 - 8,000 | 7040
Real Estate | 0.05251141552511415
Finance | 0.02511415525114155 | 2,500 - 9167 | 6250
Other | 0.0273972602739726 | 1,200 - 8,333 | 4900
Spreadsheet: 789027d1658848493-provide-the-2nd-lastest-price-value-from-a-row-lookup-2nd-last-value-issue-_new-2-
Sheet: Comparison

 |  |  |  | Years | Start Date |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | Month updated |  | PY | Pricing |  | Var
 |  |  |  | <1/1/2021 | 2021 |  |  |  |  |  |  |  |  |  | 2022 |  |  |  |  |  |  |  | 2021 | 2022 | 2021 | 2nd last | Latest
Country | Customer Name | Product Segment | Item Description |  | Jan | Apr | May | Jun | Jul | Aug | Sep | Oct | Nov | Dec | Jan | Feb | Mar | Apr | May | Jun | Jul | Aug | Month | Month | Price | Price | Price | % change
CA | OLD Reinhart - LaCr | BCS | 70213201 - IMA Choc Chip Bulk Bkd 2oz
CA | OLD Reinhart - LaCr | FCD | 70213002 - IMA Oatmeal Rsn 1oz
CA | OLD Reinhart - LaCr | FCD | 70213003 - IMA Peanut Btr 1oz |  |  |  |  |  |  | 29.56 |  |  |  |  |  |  |  |  |  |  | 33.13
CA | OLD Reinhart - LaCr | FCD | 70213027 - IMA Double Choc 1.5oz |  |  |  |  |  |  | 28.05 |  |  |  |  |  |  |  |  |  |  | 31.7
CA | OLD Rein - Shaw | BCS | 70213201 - IMA Choc Chip Bulk Bkd 2oz |  |  |  |  |  |  | 16.71 |  |  |  |  |  |  |  |  |  |  | 18.56
CA | OLD Rein - Shaw | FCD | 70213002 - IMA Oatmeal Rsn 1oz |  |  |  |  |  |  | 27.47 |  |  |  |  |  |  |  |  |  |  | 30.84
CA | OLD Rein - Shaw | FCD | 70213003 - IMA Peanut Btr 1oz |  |  |  |  |  |  | 29.56 |  |  |  |  |  |  |  |  |  |  | 33.13
CA | OLD Rein - Shaw | FCD | 70213027 - IMA Double Choc 1.5oz |  |  |  |  |  |  | 28.05 |  |  |  |  |  |  |  |  |  |  | 31.7
CA | PC | FCD | 70110434 - Wht Choc Mac 8lbx4 |  |  |  |  |  | 70.63000000000001 |  |  |  |  |  | 74.02 |  |  |  |  |  | 60.92
CA | QMCS | FCD | 7000962- Wht Choc Mac 3oz |  |  |  |  |  | 21.45 |  |  |  |  |  | 38.44 |  |  |  |  |  | 24.66
CA | QMCS | FCD | Flag 7000961 - Choc Chunk 3oz |  |  |  |  |  | 34.64 |  |  |  |  |  | 36.3 |  |  |  |  |  | 22.85
CA | RDP Foodservice | FCD | 7000761 - Choc Chunk 1.5oz |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 36.3 |  | 20.76
CA | Rein FS | BCS | 70213201 - IMA Choc Chip Bulk Bkd 2oz |  |  |  |  |  |  | 16.71 |  |  |  |  |  |  |  |  |  |  | 18.56
CA | Rein FS | FCD | 70213002 - IMA Oatmeal Rsn 1oz |  |  |  |  |  |  | 27.47 |  |  |  |  |  |  |  |  |  |  | 30.84
CA | Rein FS | FCD | 70213003 - IMA Peanut Btr 1oz |  |  |  |  |  |  | 29.56 |  |  |  |  |  |  |  |  |  |  | 33.13
CA | Rein FS | FCD | 70213027 - IMA Double Choc 1.5oz |  |  |  |  |  |  | 28.05 |  |  |  |  |  |  |  |  |  |  | 31.7
CA | Sy - DET | FCD | 7000110 - Oatmeal Rsn 2oz |  |  |  |  |  | 34.64 |  |  |  |  |  | 36.3 |  |  |  |  |  | 29.22
CA | Sy - DET | FCD | 7000160 - Double Choc 2oz |  |  |  |  |  | 34.64 |  |  |  |  |  | 36.3 |  |  |  |  |  | 29.22
CA | Sy - DET | FCD | Flag 70A0108 - Sugar 2oz |  |  |  |  |  | 34.64 |  |  |  |  |  | 36.3 |  |  |  |  |  | 17.44
CA | Sy - GR | BCS | 7000612 - Choc Chunk Bkd 1.35oz |  |  |  |  |  | 18.05 |  |  |  |  |  |  |  |  |  |  |  | 17.44
USA | [NAME] |  | FG - Choc Chip TH Ns BnB 16.5oz 12.37LB US |  |  |  |  |  |  |  |  |  |  |  |  | 18.04 |  | 22.44 |  |  | 22.16
USA | [NAME] |  | FG Ns 16ozx12 Choc Chip Lovers BNB
Spreadsheet: 218107d1362350312-assistance-with-array-or-advanced-filter-please-lmgtfy-4
Sheet: h

 | Group Name :
 | Group Count :
 | Birthday Range
 | Start Date:
 | End Date:
Parent's
First Name | Child | Child's dob
Spreadsheet: 606141d1547501121-vlookup-with-repeated-items-excel-forum
Sheet: Sheet1

 | A |  |  |  | B
 | No PO Code | AMT |  |  | No PO Code | Total Value
1 | ERRFSTX111818-2 | 3528 |  |  | ERRFSTX111818-2
2 | ERRFSTX111818-3 | 3528 |  |  | ERRFSTX111818-3
3 | ERRFVA111818-1 | 540 |  |  | ERRFVA111818-1
4 | ERRFVA111818-1 | 1008 |  |  | ERRFVA111818-1 |  | Need exactly the same amount in column C.
5 | ERRFVA111818-1 | 750 |  |  | ERRFVA111818-1
6 | ERRFVA111818-2 | 540 |  |  | ERRFVA111818-2
7 | ERRFVA111818-2 | 2700 |  |  | ERRFVA111818-2
8 | ERRFVA111818-63 | 36 |  |  | ERRFVA111818-63
9 | ERRFVA111818-3 | 504 |  |  | ERRFVA111818-3
10 | ERRFVA111818-4 | 1512 |  |  | ERRFVA111818-4
11 | ERRFVA111818-46 | 36 |  |  | ERRFVA111818-46
12 | ERRFVA111818-4 | 504 |  |  | ERRFVA111818-4
13 | ERRFTN111818-3 | 216 |  |  | ERRFTN111818-3
14 | ERRFTN111818-1 | 3024 |  |  | ERRFTN111818-1
15 | ERRFTN111818-4 | 216 |  |  | ERRFTN111818-4
16 | ERRFTN111818-2 | 3024 |  |  | ERRFTN111818-2
17 | ERRFIN0112518-1 | 1008 |  |  | ERRFIN0112518-1
18 | ERRFOK120218-20 | 304 |  |  | ERRFOK120218-20
19 | ERRFOK120218-2 | 2016 |  |  | ERRFOK120218-2
20 | ERRFOK120218-30 | 76 |  |  | ERRFOK120218-30
21 | ERRFOK120218-3 | 504 |  |  | ERRFOK120218-3
22 | ERRFOK120218-31 | 152 |  |  | ERRFOK120218-31
23 | ERRFOK120218-3 | 1008 |  |  | ERRFOK120218-3
24 | ERRFNTX120218-1 | 504 |  |  | ERRFNTX120218-1
25 | ERRFNTX120218-2 | 1160 |  |  | ERRFNTX120218-2
26 | ERRFNTX120218-3 | 1512 |  |  | ERRFNTX120218-3
27 | ERRFNTX120218-4 | 1512 |  |  | ERRFNTX120218-4
28 | ERRFNTX120218-8 | 152 |  |  | ERRFNTX120218-8
29 | ERRFNTX120218-4 | 1008 |  |  | ERRFNTX120218-4
Spreadsheet: 159547d1338739620-need-text-to-appear-when-conditions-met-my-excel-headache
Sheet: Sheet1

 | Post name | Employee# | User Name | Duty On | Duty Off | Duty Time | Duty On (rounded) | Duty Off (rounded) | Duty Time (rounded) | comments
 | 1300~10020~EA-G11 |  |  | 6/1/2012 11:01:41 AM | 6/1/2012 2:18:07 PM | 3:16 | 6/1/2012 11:00:00 AM | 6/1/2012 2:15:00 PM | 3:15 |  | Cells B-F are not important for final report. Cell A-J need to alternate color based on Post listed in cell [NAME] for G is: =$h2<$g3. I need that to result in cell J comment "change"
 | 1300~10020~EA-G11 |  |  | 6/1/2012 2:32:11 PM | 6/1/2012 2:32:56 PM | 0:01 | 6/1/2012 2:30:00 PM | 6/1/2012 2:30:00 PM | 0:00
 | 1300~10020~EA-G11 |  |  | 6/1/2012 2:35:38 PM | 6/1/2012 7:08:40 PM | 4:33 | 6/1/2012 2:30:00 PM | 6/1/2012 7:15:00 PM | 4:45
 | 1300~10020~EA-G13 |  |  | 6/1/2012 6:07:46 AM | 6/1/2012 7:28:40 AM | 1:21 | 6/1/2012 6:15:00 AM | 6/1/2012 7:30:00 AM | 1:15
Spreadsheet: 217810d1362198072-i-was-referred-to-this-forum-hoping-someone-will-be-kind-enough-to-help-me-out-like-access
Sheet: Sheet1

Agent name | Call type | Customer Name | Account Num | Langauge
2 | 1 |  |  | 1
 |  |  |  |  |  | Agent name | Call type | Customer Name | Account Num | Langauge
 |  |  |  |  |  | [NAME] | test | 0 | 0 | English