tianzl66/Sheetpedia huggingface dataset:
Spreadsheet: judy_townsend__17745__Tport Max Rates Calculations 10-27-01
Sheet: Entitlements

 |  | Offer #19996 |  |  |  |  |  | Offer #19997 |  |  |  |  |  | Offer #19998 |  |  |  |  |  | Offer #19998
 | Access Area Exit Entitlements to M1 |  |  |  |  |  | Access Area Exit Entitlements to M1 |  |  |  |  |  | Access Area Exit Entitlements to M1 |  |  |  |  |  | Modifications Required
 |  |  | Current | Contracted |  |  |  |  | Current | Contracted |  |  |  |  | Current | Contracted |  |  |  |  | Required
 |  |  | (MM/Day) |  |  |  |  |  | (MM/Day) |  |  |  |  |  | (MM/Day) |  |  |  |  |  | (MM/Day)
 | ETX to M1 |  | 452 |  |  |  | ETX to M1 |  | 670 |  |  |  | ETX to M1 |  | 2884 |  |  |  | ETX to M1 |  | 1976
 | ETX to [NAME] |  | 189 |  |  |  | ETX to [NAME] |  | 279 |  |  |  | ETX to [NAME] |  | 1202 |  |  |  | ETX to [NAME] |  | 0
 | ELA to M1 |  | 2456 |  |  |  | ELA to M1 |  | 3637 |  |  |  | ELA to M1 |  | 15656 |  |  |  | WLA - ELA |  | 523
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | ELA - M1 |  | 14545
 |  |  |  | 3660 |  |  |  |  |  | 5078 |  |  |  |  |  | 35208
 |  | Offer #19996 |  |  |  |  |  | Offer #19997 |  |  |  |  |  | Offer #19998
 | Current Exit Entitlements Granted by Zones |  |  |  |  |  | Current Exit Entitlements Granted by Zones |  |  |  |  |  | Current Exit Entitlements Granted by Zones
 | STX - WLA |  | 0 |  |  |  | STX - WLA |  | 867 |  |  |  | STX-ETX |  | 2360
 |  |  |  |  |  |  | STX-ETX |  | 548 |  |  |  | STX - WLA |  | 3731
 | WLA-ELA |  | 1470 |  |  |  | WLA-ELA |  | 2178 |  |  |  | WLA- ELA |  | 9375
 |  | Total
 | Access Area Operational EntitlementsGranted
 |  |  | Current | Contracted
 | STX |  | 7506 | 402
 | ETX |  | 5676 | 7652
 | WLA |  | 13023 | 13546
 | ELA |  | 21749 | 22346
Spreadsheet: 236000d1368655342-insert-rows-thru-conditional-formatting-book2-solution
Sheet: Sheet1

 | 2384216840000071 | 2384216840000071 |  | 1
 | 2384216840000089 | 2384216840000089 |  | 2
 | 2384216840000113 | 2384216840000097 |  | 3
 | 2384216840000121 | 2384216840000105 |  | 4
 | 2384216840000162 | 2384216840000113 |  | 5
 | 2384216840000170 | 2384216840000121 |  | 6
 | 2384216840000188 | 2384216840000139 |  | 7
 | 2384216840000204 | 2384216840000147 |  | 8
 | 2384216840000238 | 2384216840000154 |  | 9
 | 2384216840000246 | 2384216840000162 |  | 10
 | 2384216840000253 | 2384216840000170 |  | 11
 | 2384216840000287 | 2384216840000188 |  | 12
 | 2384216840000345 | 2384216840000196 |  | 13
 | 2384216840000378 | 2384216840000204 |  | 14
 | 2384216840000402 | 2384216840000212 |  | 15
 | 2384216840000410 | 2384216840000220 |  | 16
 | 2384216840000428 | 2384216840000238 |  | 17
 | 2384216840000436 | 2384216840000246 |  | 18
 | 2384216840000451 | 2384216840000253 |  | 19
Spreadsheet: 443506d1454082149-count-games-played-sample2
Sheet: banpick

 | Heroes | MarsTV Dota 2 League
 |  | Banned | Picked | Rank | Win | Loss
1 | Abaddon | 2 | 1 |  |  |  |  |  | TOTAL GAMES PLAYED |  |  |  | TOP 10
2 | Alchemist | 3 | 7
3 | Ancient Apparition | 4 | 8 |  |  |  |  |  |  |  |  |  | # | Most Banned | Count | # | Most Picked | Count | # | Most Win | Count | # | Most Loss | Count |  | Most Picked | Picked | Win | Loss
4 | Anti-Mage | 1 | 10 |  |  |  |  |  |  |  |  |  | 1 |  |  | 1 |  |  | 1 |  |  | 1
5 | [NAME] | 10 | 10 |  |  |  |  |  | TOTAL HEROES DRAFTED |  |  |  | 2 |  |  | 2 |  |  | 2 |  |  | 2
6 | Axe | 10 | 6 |  |  |  |  |  |  |  |  |  | 3 |  |  | 3 |  |  | 3 |  |  | 3
7 | [NAME] | 8 |  |  |  |  |  |  |  |  |  |  | 4 |  |  | 4 |  |  | 4 |  |  | 4
8 | Batrider | 6 |  |  |  |  |  |  |  |  |  |  | 5 |  |  | 5 |  |  | 5 |  |  | 5
9 | Beastmaster |  | 8 |  |  |  |  |  |  |  |  |  | 6 |  |  | 6 |  |  | 6 |  |  | 6
10 | Bloodseeker |  | 2 |  |  |  |  |  |  |  |  |  | 7 |  |  | 7 |  |  | 7 |  |  | 7
11 | [NAME] | 5 |  |  |  |  |  |  |  |  |  |  | 8 |  |  | 8 |  |  | 8 |  |  | 8
12 | Brewmaster |  | 5 |  |  |  |  |  |  |  |  |  | 9 |  |  | 9 |  |  | 9 |  |  | 9
13 | Bristleback |  |  |  |  |  |  |  |  |  |  |  | 10 |  |  | 10 |  |  | 10 |  |  | 10
14 | Broodmother
Spreadsheet: 99578d1298196132-count-by-month-count_by_month-1-
Sheet: Sheet2

 |  | 2010-11-01 00:00:00 | 2010-12-01 00:00:00 | 2011-01-01 00:00:00 | 2011-02-01 00:00:00 | 2011-03-01 00:00:00 | 2011-04-01 00:00:00 | 2011-05-01 00:00:00 | 2011-06-01 00:00:00 | 2011-07-01 00:00:00 | 2011-08-01 00:00:00 | 2011-09-01 00:00:00 | 2011-10-01 00:00:00 | 2011-11-01 00:00:00 | 2011-12-01 00:00:00 | 2012-01-01 00:00:00
Activity1 | Planned
 | Actual
Spreadsheet: 135175d1325858797-subtotal-countif-range-subtotal-and-countif-in-1-formula-solved-wip-pulse-scope-model-v2
Sheet: Planned Scope 100%(Draft)

 |  |  | Open Positions
 | Department | Position ID | Position | Notes | Employee ID | Employee Name | Salary | Hire Date | Term Date | Jan | Feb | Mar | Apr | May | Jun | Jul | Aug | Sep | Oct | Nov | Dec |  | Total
 |  |  |  |  |  |  |  |  |  | 2011-01-01 00:00:00 | 2011-02-01 00:00:00 | 2011-03-01 00:00:00 | 2011-04-01 00:00:00 | 2011-05-01 00:00:00 | 2011-06-01 00:00:00 | 2011-07-01 00:00:00 | 2011-08-01 00:00:00 | 2011-09-01 00:00:00 | 2011-10-01 00:00:00 | 2011-11-01 00:00:00 | 2011-12-01 00:00:00
 | Account | 1000 | Account Supervisor |  | 100 | A1 | 90000 | 2011-01-01 00:00:00
 | Account | 1001 | Account Executive |  | 101 | A2 | 60000 | 2011-03-02 00:00:00
 | Account | 1002 | Assitant Account Executive | A3 was hired on 6/21/11 - 11/28/11 with total salary of $ 13,166.67 | 102 | A3 | 30000 | 2011-06-21 00:00:00 | 2011-11-28 00:00:00
 | Account | 1003 | Account Intern |  | 103 | A4 | 20000 | 2011-08-01 00:00:00
 | Account
 | Public Relations | 1004 | PR Associate |  | 104 | B1 | 45000 | 2011-02-01 00:00:00
 | Public Relations | 1005 | Senior PR Associate |  | 105 | B2 | 30000 | 2011-07-12 00:00:00
 | Public Relations
 | Creative | 1006 | Copywriter |  | 106 | C1 | 50000 | 2011-01-25 00:00:00
 | Creative | 1007 | Asisstant Copywriter |  | 107 | C2 | 30000 | 2011-05-17 00:00:00
 | Creative
 | Analytics | 1008 | Digital Analyst |  | 108 | D1 | 80000 | 2011-07-26 00:00:00
 | Analytics
 | Media | 1009 | Estimator |  | 109 | E1 | 55000 | 2011-01-11 00:00:00
 | Media | 1010 | Assistant Media Planner |  | 110 | E2 | 80000 | 2011-10-18 00:00:00
 | Media
 | Digital | 1011 | Digital Traffic |  | 111 | F1 | 35000 | 2011-03-08 00:00:00
 | Digital | 1012 | Business Analyst |  | 112 | F2 | 20000 | 2011-08-16 00:00:00
 | Digital
 | Total Salary
 | Count of open positions/month
 | Open Position Reporting
 | X- Limit budget salary total per department
 | - Determine count of open positions and amount budget remaining
Spreadsheet: 637ee5e7-78e5-43ff-afcd-85bcc8040bbb
Sheet: Sheet1

Educational Partner | RttT Region | Primary Contact | Title | Office Phone | Cell Phone | [NAME] | Secondary Contact | Title | Office Phone | Cell Phone | [NAME] | Third Contact | Title | Office Phone | Cell Phone | [NAME] | Fourth Contact | Title | Office Phone | Cell Phone | [NAME]
ESC of Central Ohio | Central | Dr. [NAME] | Superintendent | 614/445-3750 | 614/554-4546 | [EMAIL] | Dr. [NAME] | Deputy Superintendent/ Chief of Staff | [PHONE] | 614/296-6705 | [EMAIL] | Dr. [NAME] | Executive Director of Achievement and Leadership Services | [PHONE] |  | [EMAIL]
Mid-Ohio ESC | Central | [NAME] | Deputy Superintendent | 419/774-2505 | 419/709-7259 | [NAME] | [NAME] | Consultant | 419/774-2511 | 419/565-7258 | [EMAIL]
ESC of  Cuyahoga County | Northeast | Dr. [NAME] | Superintendent | 216/524-3000 | 937/974-4966 | [EMAIL] | [NAME] | Coordinator of Research and Planning | [PHONE]. | 440/725-6447 | [EMAIL]
Mahoning County | Northeast | [NAME] | Superintendent | 330/965-7828 |  | [EMAIL] | [NAME] | Director of Teaching and Learning | 330/965-7828 |  | [EMAIL]
[NAME] | Northwest | [NAME] | Superintendent | 419/738-3422 |  | [EMAIL] | Deb Munis |  | [PHONE] |  | [EMAIL]
North Central Ohio ESC (Also Central on RFI) | Northwest | Dr. [NAME] | Superintendent | 419/447-2927 x 105 | 419/217-0121 | [EMAIL] | [NAME] | Deputy Superintendent | 419/447-2927 | 419/217-0121 | [EMAIL] | [NAME] | Deputy Superintendent | 740/387-6625 | 740/262-8135 | [EMAIL] | [NAME] | Director of Operations | 419/447-2927 | 419/564-6831 | [EMAIL]
Muskingum Valley ESC | Southeast | [NAME] | Superintendent | 740/452-4518 | 740/819-3601 | [EMAIL] | [NAME] | Assistant Superintendent | 740/452-4518 x 107 | 740/586-7695 | [NAME]
Lawrence/Scioto Collaboration (Also SW on RFI) | Southeast/ Southwest | Brett Justice ( South Central ESC) | Assistant Superintendent | 740/354-0226 | 740/935-2716 | [EMAIL] | [NAME] (South Central ESC) | Curriculum Consultant | 740/354-0251 | 740/464-4338 | [EMAIL] | Theresa Adkins (Lawrence Co. ESC) | Curriculum Supervisor | 740/532-4223 |  | [EMAIL]
[NAME] (and Collaborative ESCs) | Southwest | Vikki Clemons | Executive Director of Service Delivery | 513/674-4212 | 513/703-2816 | [EMAIL] | [NAME] | Director of Instructional Services | 513/674-4212 | 513/266-8863 | [EMAIL]
Montgomery County ESC (and Collaborative ESCs) | Southwest | [NAME] | Superintendent | 937/225-4598 | 937/477-3834 | [EMAIL] | [NAME] | Curriculum Supervisor | [PHONE] | 937/479-5122 | [EMAIL] | [NAME] | Director of School Improvement - Region 10 State Support Team | 937/236-9965 | 937/838-5600 | [EMAIL]
Spreadsheet: 679740d1590603254-how-to-extract-data-from-a-table-using-a-colum-index-test-report
Sheet: CIS Report

 | Print CIS record
 |  |  | Index no
 | Staff | Name 2
Date | Invoice | CIS | Pay
Spreadsheet: 272052d1382172264-vlookup-to-return-multiple-cells-based-on-month-holiday-disply-ans
Sheet: Sheet1

NO | DATE | HOLIDAY |  |  | 2013-01-10 00:00:00
1 | 2013-01-14 00:00:00 | Pongal
2 | 1933-01-26 00:00:00 | Republic
3 | 1933-03-27 00:00:00 | Holi
4 | 2013-04-11 00:00:00 | Ugadi
5 | 2013-08-09 00:00:00 | [NAME]
6 | 2013-08-15 00:00:00 | Independence
7 | 2013-09-09 00:00:00 | Ganesh Chaturthi
8 | 2013-10-13 00:00:00 | Vijaya Dashami
9 | 2013-10-14 00:00:00 | Vijaya Dashami
10 | 2013-11-03 00:00:00 | Diwali
11 | 2013-12-25 00:00:00 | Christmas
Spreadsheet: 183231d1348755706-chart-axis-label-not-showing-sample
Sheet: Averages Chart

 | NE Lewis | NE Jacques | NE Rappa | [NAME] | [NAME] | ME Schrader | [NAME] | ME Agonis | CENTRAL Inman | CENTRAL Meyer | WEST Solaro | WEST Swart | WEST Wood | NATIONAL Average
Pharmacy Average
Ease of ordering
Medication accuracy
Routine del
STAT del
[NAME] accuracy
[NAME] on time
Billing accuracy
Overall needs met:
Expertise IV staff
Expertise Consultant RPh
Expertise of other pharmacy services
Staff education
Drug information
Assistance resolving fac/pat concerns
Timely response fac/pat concerns
Understanding of fac/pat concerns
Courtesy pharmacy staff
Explanation-medications availability
Overall expectations met:
Spreadsheet: 776934d1650006392-indirect-referencing-to-a-different-worksheet-and-table-2010_sold
Sheet: January

Color | Zone | Column2 | Column3 | Current Price | Column4 | Column5 | Column6 | Column7
red | W |  |  | 1750000
yellow | W |  |  | 1700000
red | W |  |  | 1600000
yellow | W |  |  | 1450000
red | W |  |  | 1315000
yellow | W |  |  | 1300000
red | W |  |  | 1225000
yellow | W |  |  | 1195000
red | W |  |  | 1100000
yellow | W |  |  | 1100000
red | W |  |  | 1100000
yellow | W |  |  | 1034000
red | W |  |  | 975000
yellow | W |  |  | 970000
red | W |  |  | 950000
yellow | W |  |  | 950000
red | W |  |  | 947500
Spreadsheet: 876709d1723445572-sumifs-formula-to-add-multiple-columns-based-on-same-criteria-vadivelan-sumifs-1-365-aligw
Sheet: Sheet1

 |  |  |  |  |  |  |  |  | I need to use [NAME] formula without helper column
CAT | Name | Salary | OT |  |  | INCENTIVE | PF |  |  |  |  | Name | Total
Engineer | Raju | 10000 | 2000 |  |  | 1000 | 1000 |  |  |  | Engineer | Raju | 14000
Senior Engineer | Ramu | 20000 | 4000 |  |  | 2000 | 2000 |  |  |  | Engineer | Vijay | 11200
Senior Engineer | Ravi | 18000 | 3600 |  |  | 1800 | 1800 |  |  |  | Senior Engineer | Ramu | 28000
Engineer | Vijay | 8000 | 1600 |  |  | 800 | 800 |  |  |  | Senior Engineer | Ravi | 25200
Spreadsheet: mary_hain__25906__ENE Analysis of PGE Financials
Sheet: Multiples

Utilities | EV/EBITDA
 | Current | 1999
Constellation Energy | 7 | 6.36
CMS Energy | 7.64 | 7.69
Dominion Resources | 10.12 | 7.76
DPL Inc. | 14.52 | 7.92
Duke Energy | 10.66 | 10.21
Consolidated Edison | 6.47 | 6.47
FPL | 6.66 | 5.35
Pinnacle West | 5.29 | 4.95
PPL | 8.16 | 7.71
IPALCO | 7.79 | 6.55
IDACORP | 9.4 | 7.22
Kansas City Power and Light | 8.34 | 7.71
Empire District | 7.93 | 7.65
Cleco | 9.37 | 8.19
MDU Resources | 9.33 | 6.85
Sierra Pacific Resources | 16.96 | 13.4
Black Hills Corp | 9.9 | 8.26
PG&E | 3.16 | 4.9
PSEG | 7.67 | 6.53
Reliant Energy | 7.31 | 7.13
TXU Corp | 6.93 | 7.85
Southern Co. | 8.26 | 8.1
Ameren Corp. | 6.41 | 6.01
Progress Energy | 7.88 | 5.76
Cinergy Corp | 7.16 | 7.05
DTE Energy | 6.21 | 5.63
FirstEnergy | 5.31 | 5.14
P.S. New Mexico | 6.63 | 6.25
Montana Power Co. | 10.95 | 11.69
Northwestern Corp. | 16.61 | 11.93
Puget Energy Inc. | 7.3 | 7.13
Unisource Energy | 8.61 | 8.64
Average
Min
[NAME]
P50
Discount of 15% (Adj. For California)
Adjusted EBITDA Multiple
Spreadsheet: 144953d1331223774-count-and-totals-for-each-name-in-a-list-test-worksheet
Sheet: Sheet1

Row Labels
'BLOX Slim Base Frame'
'ED11 Seamless Frame 0.9x2.7'
'ED11 Seamless Frame 1.8x2.7'
'NEW column 1800'
'NEW column 300'
'NEW column 900'
'NEW Column A1800'
'NEW Column A300'
'NEW Column A900 '
'NG08 [NAME]
'NG11 Printer [NAME] 115Âº - check laminate'
'NG11 Printer [NAME]
'NG11 Stock Wall 900x2700'
'NG11 White Box 900x900'
'NG12 [NAME]
'NG12 Printer Aperture [NAME]
'NG12 Printer Counter Upright 2100 - Levante'
'NG12 Printer Counter Upright 900'
'NG12 [NAME] 1800'
'NG12 [NAME]
'NG12 [NAME]
'NG12 Slatwall Store Liner 900x2400'
'NG12 [NAME]
(blank)
Grand Total
Spreadsheet: 153226d1335808828-making-a-schedule-with-auto-time-format-and-adding-total-hours-se-schedule
Sheet: nov 21

 | Monday | Tuesday | Wednesday | Thursday | Friday | Saturday
 | 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
[NAME] | off | 9:30-5:30 | 8:00-5:00 | Thanksgiving | 8:30-5:30 | 9:15-5:15
 |  | 12:00-1:00 | 12:00-1:00 |  | 12:00-1:00 | 11:30-12:30 | 38
[NAME] | 8:30-5:30 | 8:30-5:30 | 9:30-5:30 | Thanksgiving | 8:30-5:30 | off
 | 2:00-3:00 | 2:00-3:00 | 2:00-3:00 |  | 2:00-3:00 |  | 38
Ray | 8:00-5:00 | 8:00-5:00 | off | Thanksgiving | B-Day | 9:00-5:00
 | 12:00-1:00 | 12:00-1:00 |  |  |  | 12:30-1:30 | 38
Mark | 8:00-5:00 | 9:00-4:00 | 8:30-5:30 | Thanksgiving | 8:00-5:00 | off
 | 1:00-2:00 | 1:00-2:00 | 1:00-2:00 |  | 1:00-2:00 |  | 38
[NAME] | 9:30-5:30 | off | 8:00-5:00 | Thanksgiving | 7:00-4:00-homer | 9:15-5:15
ctr 12-2 | 11:00-12:00 |  | 11:00-12:00 |  | 11:00-12:00 | 1:30-2:30 | 38
Kat |  |  | 8:00-5:00 |  |  | 9:15-5:15
 |  |  | 12:00-1:00 |  |  | 11:30-12:30
 |  |  | 12:00-1:00
 |  |  |  |  |  | total hours
Spreadsheet: louise_kitchen__22747__list of potential buyers june 25 01
Sheet: Turbines

Sale of Turbines |  |  |  |  |  |  |  |  |  |  |  |  | Sale of Moore\Target [NAME]
Prospective Investors List |  |  |  |  |  |  |  |  | Last update:
Company | Enron Contact Person | Enron Contact Phone | Customer Contact Person | Customer E-Mail Address | Customer Contact Phone # | Date Called | Message/Spoke to Contact | Interested in Turbines Y/N | Action | Turbine Package Sent | Comment | Priority/Probability
Aquilla Energy | [NAME] | (403)974-6741 | [NAME] | [EMAIL] | (403) 543-8102 | 2000-08-18 00:00:00 |  |  |  | 2000-09-21 00:00:00 | Trading possibility | Low
 |  |  |  |  |  |  |  |  |  |  | Sent Turbine sale docs also
Avista | [NAME]
Foster Power |  |  | [NAME] | [EMAIL] | (603)532-7333
Indeck | [NAME] | (212)702-3938 | [NAME]
 |  |  |  |  |  |  |  |  |  |  | May want turbines alone
Intercontinental Machinery Sales |  | [NAME] Dain | [NAME] |  | (780)987-4663 | 2000-09-12 00:00:00 |  |  |  | 2000-09-12 00:00:00
ITM Associates | [NAME] Croasdale |  | [NAME] | [EMAIL] | (831)475-4278 |  |  |  |  | 2000-09-22 00:00:00
NEPCO | [NAME] |  |  | [EMAIL] | (425)415-3106 | 2000-09-22 00:00:00
Tenaska | [NAME] | (212)702-3938 | [NAME] |  | (402)691-9505 |  | Spoke to [NAME] who will talk to [NAME] |  |  | E-mailed Turbine Data | Desperate for Turbines | Turbine Sale
 |  |  |  |  |  |  |  |  |  | [NAME] 716-1389
TP Energy | [NAME] |  | [NAME] | [EMAIL] | (281)364-4019 | 2000-09-21 00:00:00 | Will test the level of interest in the turbines |  |  |  |  |  | Talking to Dominion Energy, unregulated arm of Virginia Power
Turbines.Com
Package sent to [NAME]
Spreadsheet: 142040d1329596853-auto-populate-data-from-sheet-1-to-correct-location-in-subsequent-sheets-2012-fantasy-golf
Sheet: John Deere

 |  | WEEK 15 [NAME]
 |  | Total Earnings |  |  |  | Rankings Through Week 15 | Total
 | [NAME] | 0 |  | 2 |  | [NAME] | 5000
 | [NAME] | 5000 |  | 1 |  | [NAME] | 0
 | [NAME] | 0 |  | 3 |  | [NAME] | 0
 |  | 0 |  | 4 |  | 0 | 0
 |  | 0 |  | 5 |  | 0 | 0
 |  | 0 |  | 6 |  | 0 | 0
 |  | 0 |  | 7 |  | 0 | 0
 |  | 0 |  | 8 |  | 0 | 0
 |  | 0 |  | 9 |  | 0 | 0
 |  | 0 |  | 10 |  | 0 | 0
 |  | 0 |  | 11 |  | 0 | 0
 |  | 0 |  | 12 |  | 0 | 0
 |  | 0 |  | 13 |  | 0 | 0
 |  | [NAME] |  | YTD
 |  |  |  | 0
 |  |  |  | 0
 |  |  |  | 0
 |  |  |  | 0
 |  |  |  | 0
 |  |  |  | 0
 |  |  |  | 0
 |  |  |  | 0
 |  |  |  | 0
 |  |  |  | 0
 | Total | 0 |  | 0
 |  |  |  | 5000
 |  |  |  | 0
 |  |  |  | 0
 |  |  |  | 0
 |  |  |  | 0
 |  |  |  | 0
 |  |  |  | 0
 |  |  |  | 0
 |  |  |  | 0
 |  |  |  | 0
 | Total | 0 |  | 5000
 |  |  |  | 0
 |  |  |  | 0
 |  |  |  | 0
 |  |  |  | 0
 |  |  |  | 0
 |  |  |  | 0
 |  |  |  | 0
 |  |  |  | 0
 |  |  |  | 0
 |  |  |  | 0
 | Total | 0 |  | 0
 |  |  |  | 0
 |  |  |  | 0
 |  |  |  | 0
 |  |  |  | 0
 |  |  |  | 0
 |  |  |  | 0
 |  |  |  | 0
 |  |  |  | 0
 |  |  |  | 0
 |  |  |  | 0
 | Total | 0 |  | 0
 |  |  |  | 0
 |  |  |  | 0
 |  |  |  | 0
 |  |  |  | 0
 |  |  |  | 0
 |  |  |  | 0
 |  |  |  | 0
 |  |  |  | 0
 |  |  |  | 0
 |  |  |  | 0
 | Total | 0 |  | 0
 |  |  |  | 0
 |  |  |  | 0
 |  |  |  | 0
 |  |  |  | 0
 |  |  |  | 0
 |  |  |  | 0
 |  |  |  | 0
 |  |  |  | 0
 |  |  |  | 0
 |  |  |  | 0
 | Total | 0 |  | 0
 |  |  |  | 0
 |  |  |  | 0
 |  |  |  | 0
 |  |  |  | 0
 |  |  |  | 0
 |  |  |  | 0
 |  |  |  | 0
 |  |  |  | 0
 |  |  |  | 0
 |  |  |  | 0
 | Total | 0 |  | 0
 |  |  |  | 0
 |  |  |  | 0
 |  |  |  | 0
 |  |  |  | 0
 |  |  |  | 0
 |  |  |  | 0
 |  |  |  | 0
 |  |  |  | 0
 |  |  |  | 0
 |  |  |  | 0
 | Total | 0 |  | 0
 |  |  |  | 0
 |  |  |  | 0
 |  |  |  | 0
 |  |  |  | 0
 |  |  |  | 0
 |  |  |  | 0
 |  |  |  | 0
 |  |  |  | 0
 |  |  |  | 0
 |  |  |  | 0
 | Total | 0 |  | 0
 |  |  |  | 0
 |  |  |  | 0
 |  |  |  | 0
 |  |  |  | 0
 |  |  |  | 0
 |  |  |  | 0
 |  |  |  | 0
 |  |  |  | 0
 |  |  |  | 0
 |  |  |  | 0
 | Total | 0 |  | 0
 |  |  |  | 0
 |  |  |  | 0
 |  |  |  | 0
 |  |  |  | 0
 |  |  |  | 0
 |  |  |  | 0
 |  |  |  | 0
 |  |  |  | 0
 |  |  |  | 0
 |  |  |  | 0
 | Total | 0 |  | 0
 |  |  |  | 0
 |  |  |  | 0
 |  |  |  | 0
 |  |  |  | 0
 |  |  |  | 0
 |  |  |  | 0
 |  |  |  | 0
 |  |  |  | 0
 |  |  |  | 0
 |  |  |  | 0
 | Total | 0 |  | 0
 |  |  |  | 0
 |  |  |  | 0
 |  |  |  | 0
 |  |  |  | 0
 |  |  |  | 0
 |  |  |  | 0
 |  |  |  | 0
 |  |  |  | 0
 |  |  |  | 0
 |  |  |  | 0
 | Total | 0 |  | 0
Spreadsheet: 274892d1383251384-income-for-overlapping-months-to-be-split-daily-ef517_sales-by-month-2
Sheet: From Pete

Data From Report |  |  |  |  | Days Split by month |  |  |  |  |  |  | Monthly sales income
Opening Date | Closed Date | Period | Revenue Rentals
2013-09-01 00:00:00 | 2013-09-05 00:00:00 | 5 | 83.01689999999999
2013-10-15 00:00:00 | 2013-10-27 00:00:00 | 13 | 305.09496
2013-10-15 00:00:00 | 2013-10-22 00:00:00 | 8 | 85.38135
2013-09-01 00:00:00 | 2013-11-10 00:00:00 |  | 619.70325
2013-10-28 00:00:00 | 2013-11-10 00:00:00 | 14 | 350
 |  |  |  |  |  |  |  |  |  |  | Total for month:
Spreadsheet: 174321d1345022165-vlookup-with-drop-down-functionality-____vlookup-with-a-drop-down-menu
Sheet: Result

PRODUCTS | 2011-02-01 00:00:00 | YEAR TO DATE |  | 2011-02-01 00:00:00 | YEAR TO DATE |  |  |  |  |  |  | 2011-01-01 00:00:00 | 2012-01-01 00:00:00
 | Actual Units | ActualValue | Plan Units | Plan Value | Actual Units | Actual Value |  |  |  |  |  | 2011-02-01 00:00:00 | 2012-02-01 00:00:00
Product A | 30 | 470 | 30 | 900 | 140 | 1335 |  |  |  |  |  | 2011-03-01 00:00:00 | 2012-03-01 00:00:00
Product B | 77 | 6882 | 50 | 777 | 133 | 1020 |  |  |  |  |  | 2011-04-01 00:00:00 | 2012-04-01 00:00:00
Product C | 66 | 5821 | 45 | 1510 | 187 | 1137
Product D | 88 | 6792 | 50 | 804 | 144 | 2555
1,  Need to put a drop down menu that will give me monthly year to date figures eg- February YTD, March YTD. Which will automatically update figures
2, To do a V LookUP
Spreadsheet: 700211d1603058153-sorting-mixed-list-into-two-separate-lists-index-small-if-example
Sheet: Desired Output

 | Casual Employees |  |  | Regular Employees
 | Employee 1 | Casual |  | Employee 2 | Regular
 | Employee 3 | Casual |  | Employee 4 | Regular
 | Employee 5 | Casual |  | Employee 6 | Regular
 | Employee 7 | Casual |  | Employee 8 | Regular
 | Employee 9 | Casual |  | Employee 10 | Regular
 | Employee 11 | Casual |  | Employee 12 | Regular
 | Employee 13 | Casual |  | Employee 14 | Regular
 | Employee 15 | Casual |  | Employee 16 | Regular
 | Employee 17 | Casual |  | Employee 18 | Regular
 | Employee 19 | Casual |  | Employee 20 | Regular
 | Employee 21 | Casual |  | Employee 22 | Regular
 | Employee 23 | Casual |  | Employee 24 | Regular
 | Employee 25 | Casual |  | Employee 26 | Regular
 | Employee 27 | Casual |  | Employee 28 | Regular
 | Employee 29 | Casual |  | Employee 30 | Regular
 | Employee 31 | Casual |  | Employee 32 | Regular
 | Employee 33 | Casual |  | Employee 34 | Regular
 | Employee 35 | Casual |  | Employee 36 | Regular
 | Employee 37 | Casual |  | Employee 38 | Regular
 | Employee 39 | Casual |  | Employee 40 | Regular
 | Employee 41 | Casual |  | Employee 42 | Regular
 | Employee 43 | Casual |  | Employee 44 | Regular
 | Employee 45 | Casual |  | Employee 46 | Regular
 | Employee 47 | Casual |  | Employee 48 | Regular
 | Employee 49 | Casual |  | Employee 50 | Regular
Spreadsheet: 69053d1269551803-help-with-index-match-index-match
Sheet: Sheet2

Name | Project | Date
Jones | 118-102 | 2010-02-19 00:00:00 | 3
Smith | 119-102 | 2009-06-01 00:00:00 | 7
Green | 118-102 | 2010-02-19 00:00:00 | 3
[NAME] | 120-101 | 2009-09-22 00:00:00 | 12
 |  |  | '=IF(ISERROR(SMALL(IF(Sheet1!$A$2:$A$17=$A2,ROW(Sheet1!$B$2:$B$17)),ROW(A1))),"", SMALL(IF(Sheet1!$C$2:$C$17=$C2,ROW(Sheet1!$B$2:$B$17)),ROW(A1)))
 | '=IF($D2="","",IF(INDEX(Sheet1!B:B,$D2)="","",INDEX(Sheet1!B:B,$D2)))
Spreadsheet: 854029d1703989698-calculating-annual-days-of-business-wrkday-
Sheet: Sheet1

 |  | 2024
 | HOLIDAY | DAY |  | Reflected |  | 2024-04-01 00:00:00 | 2024-06-22 00:00:00 |  |  | 2024-06-23 00:00:00 | 2024-08-31 00:00:00 |  |  | 2024-09-01 00:00:00 | 2025-01-25 00:00:00 |  |  | 2025-01-26 00:00:00 | 2025-03-31 00:00:00
 | Memorial Day |  |  | SUN |  | SUN | WEEK | SAT |  | SUN | WEEK | SAT |  | SUN | WEEK | SAT |  | SUN | WEEK | SAT
 | Juneteenth |  |  | WEEK
 | Fourth of July |  |  | SUN |  | 12 | 59 | 12 |  | 11 | 49 | 10 |  | 26 | 98 | 23 |  | 10 | 45 | 10
 | Labor Day |  |  | SUN
 | Columbus Day |  |  | SAT
 | Election Day |  |  | WEEK
 | Veteran's Day |  |  | SAT
 | Thanksgiving |  |  | SUN
 | Christmas |  |  | SUN
 | New Year's Day |  |  | SUN
 | MLK Day |  |  | SUN
 | Presidents Day |  |  | SAT
 | Christmas Eve
 | New Year's Eve
Spreadsheet: 726585d1617303768-sumifs-issue-template-etaf
Sheet: JUN

 | Company 1
 | Date | Payment Type | Name | Description | Ref |  | AMOUNT | TOTAL |  | Comment
EX | 2021-06-01 00:00:00 | Cash | Wawa | Auto Gas | Receipt |  | 17
Spreadsheet: michelle_lokay__26750__imball0112
Sheet: PNM

PNM imbalance
 | Measured | Scheduled | Imbalance
9236 |  | -17720
9238 |  |  |  |  |  |  |  |  |  | 2000-01-06 00:00:00 | paper | 0.5
56422 |  | -988318
58710 | -36012 | -23128
60921 |  | -267542
78026
500084 |  | -30000
500085 | -2
500097 | -15406 | -10000
INDEX
2001-11-30 00:00:00 |  |  | 504796.07
2001-12-10 00:00:00
CBS Volume
 |  |  | 190825