tianzl66/Sheetpedia huggingface dataset:
Spreadsheet: 830218d1684803216-distinct-values-based-on-multiple-criteria-distinct-values-based-on-multiple-criteria
Sheet: Sheet2

Client | Order Date | Order Month | [NAME] | List: | Everyone | Number of Clients | Number of Distinct Clients
Client 3 | 2023-05-05 00:00:00 |  | [NAME] |  | July
Client 3 | 2023-01-06 00:00:00 |  | [NAME] |  | August
Client 3 | 2023-01-07 00:00:00 |  | [NAME] |  | September
Client 3 | 2023-02-08 00:00:00 |  | Shane |  | October
Client 3 | 2023-05-09 00:00:00 |  | [NAME] |  | November
Client 6 | 2023-05-10 00:00:00 |  | Simone |  | December
Client 6 | 2023-04-11 00:00:00 |  | Dwight |  | January
Client 6 | 2023-04-12 00:00:00 |  | Hugh |  | February
Client 9 | 2023-05-13 00:00:00 |  | [NAME] |  | March
Client 10 | 2023-05-14 00:00:00 |  | Rachel |  | April
Client 10 | 2023-05-15 00:00:00 |  | Rachel |  | May
Client 10 | 2023-05-16 00:00:00 |  | [NAME] |  | June
Client 10 | 2023-03-17 00:00:00 |  | [NAME] |  | Total
Client 14 | 2023-02-18 00:00:00 |  | Shane
Client 14 | 2023-05-19 00:00:00 |  | Simone
Client 14 | 2023-05-20 00:00:00 |  | Dwight |  |  |  | 0
Client 14 | 2023-03-21 00:00:00 | March | Rachel |  |  |  | 0
Client 14 | 2023-03-22 00:00:00 |  | Shane |  |  |  | 0 |  | Everyone
 |  |  |  |  |  |  | 0
 |  |  |  |  |  |  | 0
 |  |  |  |  |  |  | 0
 |  |  |  |  |  |  | 0
 |  |  |  |  |  |  | 0
 |  |  |  |  |  |  | 0
 |  |  |  |  |  |  | 0
 |  |  |  |  |  |  | 0
 |  |  |  |  |  |  | 0
 |  |  |  |  |  |  | 0
 |  |  |  |  |  |  | 0
 |  |  |  |  |  |  | 0
 |  |  |  |  |  |  | 0
 |  |  |  |  |  |  | 0
Spreadsheet: 682847d1592358472-formula-to-look-up-values-from-multiple-columns-separate-sheet-in-a-cell-with-text-site-masterlist-wip
Sheet: Membership Types

Associate | Cafeteria | Education Center
Bucket User | Day Care | Clean Supply
Cafe | Cafeteria | Conf Room | [NAME] | Coffee Area | Starbucks
Care Team Room | Day Care | Clinic
Chapel | [NAME]
Chute Room
Classroom | Class rm | Education Center | Education Room | EDU Room | Class Room
Clean Utility Room | Clean Utility | Clean Supply | Clean Utilities | Clean Holding | Utility Room | Clean Room | Clean Linen | Clean Supplies
Conference Room | Conference | Conf Room | Conf rm | Meeting Room | Board Room | Conference rooms | [NAME] | Multipurpose room | Community Room | Conf Room | Boardroom | Conf. Room | Auditorium | Conference
Consultation Room | [NAME] | Clinic | Consultation | Consult | Interview Room | [NAME] | Charting
Corridor | Hallway | [NAME] | [NAME] | Vending Area | Corr | Annex | Hallways
[NAME]
Curtain Associate
Day Room | Library | TV Lounge | TV Room | Family Room | Family Lounge | Public Areas | Sleep Center | Sleep Room | Lactation Room | Purpose Room | Doctors Lounge | Recreation Room | Day Care | Same Day Center
Day Room | Catering | Pantry
Director
Discussion Room | Counselling
[NAME]
Dorm Room
Elevator | Elevators
Elevator Landing
Entrance | Registration | Reception | Booking Area | Entry | Front Desk | Impression | entrances | Check In | Receptionist | Desk Areas | Desk Area
ER Associate
ER Bay | Holding Room | Bay | CDU Room | ER Room | Treatment | CDU
EVS Closet | EVS Cart | DES Closet | Janitor's Closet | Janitors Closet | ES Closet | Housekeeping | EVS | Closet | Cart Area | Sign in Room
Exam Room | Exam | Emergency Room
File Room | File Area | Med Records | Medical Records | History Room | [NAME] | Physician Reading | Reading Room
[NAME]
Hospital Exec
Imaging Room | [NAME] | Imaging | [NAME] | Radiographic Room | Ultrasound | Radiologist | [NAME] | Graphic Room | MRI | Mammography
Kitchen | [NAME] | Break Room | Breakroom
Laboratory | Lab Room | Lab
Laundry
Linen Cart/Closet | [NAME] | Linen Room | Linen
[NAME]
Locker Room
Manager
Medical Supply
Mid Shift Associate
Nourishment Room
Nursery
Nurses Station
Office
On Call Room | On Call | On-Call
OR Associate
OR Room
Other
Patient Experience
Patient Room
Patient Transport
Pharmacy
Procedure Room
Project Tech
Rehabilitation Room
Restroom | Washroom
Scrub Room Sterile
Shower
Sinks
Soiled Utility Room | Soiled Utility
Staff Lounge | Staff Room | Sleep Lounge
Staff Support Room
Stairwell
Sterile Utility Room
Storage Room
Suite
Supervisor
Supply Room
Supply Room Sterile
Training User
[NAME]
UV Tech
Virtual Manager
Waiting Area
[NAME] | Main Floor
Work Area | Work Room
Spreadsheet: 809431d1671089736-sort-text-with-number-as-prefix-within-a-cell-classeur4-hd
Sheet: Feuil1

 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | Everything in 1 go. Most present component first.
AA | 50 | BB |  | CC | 8 | DD | 12 | EE |  | FF
AA | 50 | BB | 100 | CC | 8 | DD | 12 | EE | 1 | FF | 2
Spreadsheet: benjamin_rogers__1112__Peaker Proj 99-00
Sheet: Sheet1

94kc | Southeastern [NAME] | New Albany Pwr 1, LLC | ABB Pwr T & D Co. Inc. | Transformer & Circuit Breaker Pkg | 1998-08-01 00:00:00 | Union County,MS
95kc | Southeastern [NAME] | New Albany Pwr 1, LLC | ABB | Transformer Pkg | 1998-08-01 00:00:00 | Union County,MS
96kc | Southeastern [NAME] | [NAME] I, LLC | ABB Pwr T & D Co. Inc. | Transformer & Circuit Breaker Pkg | 1998-08-01 00:00:00 | Brownsville, TN
97kc | Southeastern [NAME] | [NAME] I, LLC | ABB | Transformer Pkg | 1998-08-01 00:00:00 | Brownsville, TN
98kc | Southeastern [NAME] | [NAME], LLC | ABB Pwr T & D Co. Inc. | Transformer & Circuit Breaker Pkg | 1998-08-01 00:00:00 | Fulton, MS
99kc | Southeastern [NAME] | [NAME], LLC | ABB | Transformer Pkg | 1998-08-01 00:00:00 | Caledonia, MS
100kc | Southeastern [NAME] | [NAME], LLC | ABB Pwr T & D Co. Inc. | Transformer & Circuit Breaker Pkg | 1998-08-01 00:00:00 | Caledonia, MS
202kc | Yr 2000 [NAME] | ENA | ABB Pwr T & D Co. Inc. | Transformer & Circuit Breaker Pkg | 1999-11-19 00:00:00 | Monroe, [NAME]
207kc | Yr 2000 [NAME] | ECT | ABB | Transformer Pkg | 1999-03-22 00:00:00 | Wheatland, IN
208kc | Yr 2000 [NAME] | ECT | ABB | Transformer Pkg | 1999-03-22 00:00:00 | Gleason, TN
209kc | Yr 2000 [NAME] | ENA | ABB Pwr T & D Co. Inc. | Rewind Pkgs | 1999-07-29 00:00:00 | Monroe, [NAME]
210kc | Yr 2000 [NAME] | ECT | ABB | Transformer Pkg | 1999-03-22 00:00:00 | Lincoln Center, IL
101bb | SE [NAME] | ECT | Siemens Westinghouse Pwr Corp | Purch Contr CTG Pkg 501F | 1998-10-02 00:00:00 | Gleason, TN
16bb | [NAME] | [NAME] I, LLC | Westinghouse [NAME] | Purch Contr 501D5A | 1998-07-21 00:00:00 | Brownsville, TN
17bb | SE [NAME] | ECT | GE Co | [NAME] 7EA | 1998-10-12 00:00:00 | Caledonia, MS
172bb | YR2000, [NAME]98 | ECT | Siemens Westinghouse Pwr Corp | Purch Contr CTG Pkg 2 W501F | 1998-11-12 00:00:00 | Gleason, TN
173bb | YR2000, [NAME] | ECT | Siemens Westinghouse Pwr Corp | Purch Contr CTG Pkg W501D5A | 1998-11-20 00:00:00 | Wheatland,IN
82bb | [NAME] | ECT | GE Co | GTG Pkg GE 7EA Lincoln, Ctr | 1998-07-24 00:00:00 | Wilton,Illinois
177bb | PO # WC-Stack-99 | ECT | Braden Manufacturing, L.L.C. | Stacks for #82 | 1999-08-26 00:00:00 | Lincoln Center, IL
[NAME] | [NAME] | ENA | [NAME], L.L.C. | GTG Pkg Agmt | 1999-11-22 00:00:00 | Monroe, [NAME]
252kc | ECT 1999 Peaker-Contr/Parts | ENA(Westdeutsche [NAME]) | GE Pkgd Pwr, Inc | 24 LM6000 Enhances Sprint GTG sets | 2000-05-12 00:00:00 | USA
[NAME] | [NAME] | ENA | GE Co. | GTG Pkg GE 7FA | 1999-02-04 00:00:00 | Linden, NJ
224kc | Midwest [NAME] MW-2-98 | Westdeutch Landesbank Girozentrale(ENA) | GE | [NAME] GE 7FA | 1999-02-04 00:00:00 | [NAME], ILL
Spreadsheet: 846890d1698048617-excel-project-glenn-excel-help-2
Sheet: Timesheet

Project | Name | Hours | Task
1 | [NAME] | 10 | 1
1 | [NAME] | 2 | 2
1 | Martin | 3 | 1
1 | Ian | 4 | 1
1 | Bogdan | 5 | 1
2 | [NAME] | 20 | 2
2 | [NAME] | 2 | 2
2 | Martin | 3 | 1
2 | Ian | 111 | 1
2 | Bogdan | 222 | 1
Spreadsheet: 736359d1623537339-when-date-changes-so-should-a-number-excel_example
Sheet: Blad1

 |  | Week 1
 |  | Monday | Tuesday | Wednesday | Thursday | Friday | Saturday | Sunday
 | 2021-06-13 00:00:00 | 6 | 5 | 10 | 6 | 4 | 8 | 7
 | 2021-06-14 00:00:00 | 7 | 6 | 11 | 9 | 4 | 9 | 10
 | 2021-06-15 00:00:00 | 8 | 7 | 11 | 13 | 6 | 10 | 13
 | 2021-06-16 00:00:00 | 9 | 7 | 12 | 14 | 7 | 11 | 15
 | 2021-06-17 00:00:00 | 11 | 9 | 12 | 18 | 9 | 11 | 18
 | 2021-06-18 00:00:00 | 13 | 10 | 13 | 22 | 9 | 13 | 21
 | 2021-06-19 00:00:00 | 15 | 12 | 13 | 25 | 11 | 15 | 24
 | 2021-06-20 00:00:00 | 16 | 13 | 14 | 27 | 12 | 16 | 27
 | 2021-06-21 00:00:00 | 19 | 14 | 15 | 30 | 12 | 16 | 29
 | 2021-06-22 00:00:00 | 21 | 14 | 17 | 33 | 14 | 19 | 33
 | 2021-06-23 00:00:00 | 23 | 14 | 17 | 35 | 15 | 19 | 35
 | 2021-06-24 00:00:00 | 25 | 16 | 18 | 38 | 17 | 21 | 39
 | Todays date
 |  | <--------- | When date changes, so should the numbers below
Week 1 | Monday | 6
 | Tuesday | 5
 | Wednesday | 10
 | Thursday | 6
 | Friday | 4
 | Saturday | 8
 | Sunday | 7
Spreadsheet: 284f5f03-bdc8-485f-aab9-5ef101ba00c0
Sheet: Sheet1

Unnamed: 0 | Unnamed: 1 | Unnamed: 2 | Unnamed: 3 | Unnamed: 4 | [NAME] in Southern Ontario  - 2014 | Unnamed: 6 | Unnamed: 7 | Unnamed: 8 | Unnamed: 9 | Unnamed: 10 | Unnamed: 11 | Unnamed: 12 | Unnamed: 13 | Unnamed: 14 | Unnamed: 15
 |  |  | Contact Information |  |  |  | Types Accepted |  |  |  |  | Form Accepted
Company Name |  |  | Contact Name |  | Address and Phone | Flexible | Rigid | Post-Consumer | Post-Industrial | Pre-Consumer | Baled | Ground | Loose | Shredded | Whole
4A Plastic Recycling |  |  | [NAME] |  | 24 [NAME], Cambridge ON, N1R 4Z3 [NAME]. [PHONE] | yes | yes |  | yes |  |  | yes |  | yes
A &B Plastic Co. Ltd. |  |  | [NAME] |  | 269 Rimrock Rd., Toronto, ON, M3J 3C6 [NAME]. [PHONE] | yes | yes |  | yes |  | yes |  | tes |  | yes
[NAME] |  |  |  |  | 107 Dowty Road, Ajax, ON L1S 2G3 [NAME]. [PHONE] | yes | yes | yes | yes |  | Please Contact
Canadian Plastic Solutions |  |  | [NAME] |  | 1165 [NAME]., Oakville, ON L6H 4M1 [PHONE] | yes | yes | yes |  |  | yes | yes | yes | yes | yes
Connex Polymer |  |  | [NAME] |  | 107 Dowty Road, Ajax, ON L1S 2G3 [NAME]. [PHONE] | Ask for Specifics |  |  |  |  | Ask for Specifics
Cryo-Vision Inc |  |  | [NAME] |  | 95 Norwich Ave., [NAME], ON, N4S 3V3 Tel. [PHONE] | yes | yes |  | yes | yes | yes | yes | yes | yes | yes
EFS-Plastics Inc. |  |  | [NAME] |  | 63 Union Street, Elmira, ON, N3B 2Y3
[NAME] |  |  | [NAME] |  | 200 Universal Rd., [NAME], [NAME]. [PHONE] | yes | yes |  |  |  | yes | yes |  | yes
Kal-Trading |  |  | [NAME] |  | 2280 Drew Rd., [NAME], ON L5S 1B8 | yes | yes | yes | yes |  | yes | yes | yes | yes | yes
Miller Waste Systems |  |  | [NAME] |  | P.O Box 4080., [NAME], Markham, Ontario, L3R 9R8 Tel. [PHONE] | yes | yes | yes | yes | yes |  |  | yes
Nam Polymers |  |  | [NAME] |  | 414 Attwell Drive., Etobicoke, ON, [NAME]. [PHONE] | yes | yes |  |  | yes | Ask for specifics
Nexcycle Plastics |  |  | [NAME] |  | 235 Wilkinson Rd., Brampton, ON L6T 4M2 [PHONE]
Northern Polymers |  |  | [NAME] |  | 265 [NAME], Kitchener, [NAME]. [PHONE] |  | yes |  | yes |  | Can Accept Most Forms
Norwich Plastics |  |  | Tribu Persaud X32 |  | 400 Dolph St. N, Cambridge, ON  N3H [NAME]. [PHONE] | yes | toll only | yes, flex | yes | yes | yes | yes |  | yes | yes
Rehau Industries Inc. |  |  | Call main office |  | Facility is in Prescott Ontario Toronto office number: [PHONE] | yes | yes |  | yes | yes | yes | yes | yes | yes | yes
Solid Waste Reclamations Inc. |  |  | [NAME] |  | P.O. Box 200, Station A, [NAME], Ontario, L8N 3A2 [NAME]. [PHONE] | yes | yes |  | yes |  | yes | yes | yes | yes | yes
TCW Recycling |  |  | [NAME] |  | Facility is in Ottawa Ontario Tel. [PHONE] | yes | yes | yes | yes | yes | yes | no | yes | no | yes
West Coast Plastic Recyclers Inc. |  |  | [NAME] |  | 2480 Shell Road, Richmond, BC, V6X 2P1 Tel [PHONE]
 |  |  | www.simplas.ca |  | [PHONE], stuart@ simplas.ca | also accepts ABS and PE
CPIA Members
Spreadsheet: 111705d1308040178-vlookup-in-multiple-sheets-vlookup-in-multiple-sheets
Sheet: $250-500M

CompanyName | websites | employeerange | RevenueRange | state
Company 300 | 5000 | 6000 | 7000 | 8000
Company 301 | 5001 | 6001 | 7001 | 8001
Company 302 | 5002 | 6002 | 7002 | 8002
Company 303 | 5003 | 6003 | 7003 | 8003
Company 304 | 5004 | 6004 | 7004 | 8004
Company 305 | 5005 | 6005 | 7005 | 8005
Company 306 | 5006 | 6006 | 7006 | 8006
Company 307 | 5007 | 6007 | 7007 | 8007
Company 308 | 5008 | 6008 | 7008 | 8008
Company 309 | 5009 | 6009 | 7009 | 8009
Company 310 | 5010 | 6010 | 7010 | 8010
Company 311 | 5011 | 6011 | 7011 | 8011
Company 312 | 5012 | 6012 | 7012 | 8012
Company 313 | 5013 | 6013 | 7013 | 8013
Company 314 | 5014 | 6014 | 7014 | 8014
Company 315 | 5015 | 6015 | 7015 | 8015
Company 316 | 5016 | 6016 | 7016 | 8016
Company 317 | 5017 | 6017 | 7017 | 8017
Company 318 | 5018 | 6018 | 7018 | 8018
Company 319 | 5019 | 6019 | 7019 | 8019
Spreadsheet: 820850d1678308384-last-5-home-results-for-each-home-team-in-soccer-data-last-5
Sheet: Last 5

HomeTeam (HT) | Away Team | Date | HT result |  |  | Home Team | Last 5 Home Results
Leeds | Chelsea | 2023-01-01 00:00:00 | D |  | 1ST FORMULA | Chelsea
Liverpool | Man Utd | 2023-01-01 00:00:00 | W |  |  | Liverpool
Chelsea | Forest | 2023-01-05 00:00:00 | W
Man City | Liverpool | 2023-01-05 00:00:00 | D |  | 2ND FORMULA | Chelsea
Arsenal | Chelsea | 2023-01-09 00:00:00 | D |  |  | Liverpool
Liverpool | Newcastle | 2023-01-09 00:00:00 | W
Liverpool | Man City | 2023-01-15 00:00:00 | D
Chelsea | Everton | 2023-01-15 00:00:00 | D
Leeds | Liverpool | 2023-01-21 00:00:00 | L | 1ST FORMULA WORKS OK ON ROWS 2 TO 19 ONLY
Arsenal | Chelsea | 2023-01-21 00:00:00 | W |  | WHEN I ADD EXTRA ROWS 20 TO 31 THEN IT FAILS
Liverpool | West Ham | 2023-01-26 00:00:00 | L
Chelsea | Newcastle | 2023-01-26 00:00:00 | L | 2ND FORMULA IS PICKING UP RESULTS BUT THEY ARE NOT CORRECT (LAST 5)
Tottenham | Liverpool | 2023-02-01 00:00:00 | L
Chelsea | Arsenal | 2023-02-01 00:00:00 | W
Liverpool | Everton | 2023-02-11 00:00:00 | W
Newcastle | Chelsea | 2023-02-11 00:00:00 | L
Chelsea | [NAME] | 2023-02-20 00:00:00 | D
Fulham | Liverpool | 2023-02-20 00:00:00 | L
Liverpool | Man City | 2023-01-15 00:00:00 | D
Chelsea | Everton | 2023-01-15 00:00:00 | D
Leeds | Liverpool | 2023-01-21 00:00:00 | L
Arsenal | Chelsea | 2023-01-21 00:00:00 | W
Liverpool | West Ham | 2023-01-26 00:00:00 | L
Chelsea | Newcastle | 2023-01-26 00:00:00 | L
Tottenham | Liverpool | 2023-02-01 00:00:00 | L
Chelsea | Arsenal | 2023-02-01 00:00:00 | W
Liverpool | Everton | 2023-02-11 00:00:00 | W
Newcastle | Chelsea | 2023-02-11 00:00:00 | L
Chelsea | [NAME] | 2023-02-20 00:00:00 | D
Fulham | Liverpool | 2023-02-20 00:00:00 | L
Spreadsheet: larry_campbell__21327__AMP_COST_WORKSHEET
Sheet: Other Costs

Other Costs
Risk Premium
Background Assumptions:
Probability of outage between day-ahead and real-time (%) |  |  | 0
Assumed difference in price between day-ahead and real-time prices when the unit trips ($/MWh)
 | Under peak load conditions |  | 0
 | Under off-peak load conditions |  | 0
Assumed price volatility in day-ahead market |  |  | 0
Assumed price volatility in real-ahead market |  |  | 0
Other Assumptions
 | Describe Assumptions
1 |  |  | 0
2 |  |  | 0
3 |  |  | 0
4 |  |  | 0
Result of Calculation
 |  |  | $/MWH | $/MW
Total Risk Premium |  |  | 0 | 0
 | Specify method of calculation of Risk Premium
Emergency Output Costs
Background Assumptions:
Amount of Emergency Output (MW) |  |  | 0
Increase in forced outage probability in normal operating range (%) |  |  | 0
Increase in forced outage probability in emergency operating range (%) |  |  | 0
Reduction in unit efficiency (%) |  |  | 0
Other factors
 | Describe factors
1 |  |  | 0
2 |  |  | 0
3 |  |  | 0
4 |  |  | 0
Result of Emergency Output calculation
 |  |  | $/MWH | $/MW
Total Emergency Output Costs |  |  | 0 | 0
 | Specify method of calculation of Emergency Output Costs
Opportunity costs
Describe each source of cost and amount |  |  | $/MW | Detailed Description
 | Warranty risks |  | 0
 | Contract Sales |  | 0
 | External transactions |  | 0
 | Other: |  | 0
 | Other: |  | 0
 | Total
Environmental costs
 |  |  | Emmission Rate (Unit/MWh) | Allowance Cost ($/Unit) | Cost ($/MWh) | Units (e.g.-Lbs)
Nox |  |  | 0 | 0
Sox |  |  | 0 | 0
Other |  |  | 0 | 0
 | Specify
1 |  |  | 0 | 0
2 |  |  | 0 | 0
3 |  |  | 0 | 0
 | Total |  | 0
Spreadsheet: 92741d1292299260-recognizing-input-patterns-from-sheet-to-sheet-with-linked-cells-numbers-example
Sheet: Sheet1

 |  |  |  |  |  |  |  | STORE 1
 |  |  |  |  |  |  |  | Gross | Net |  | Late Night |  | Allowed |  | Adj |  | [NAME] | Act
 |  |  |  |  |  |  |  |  | +/- LY
 |  |  |  |  |  |  |  |  | Maint $ | Supply $ | Cash +/- | TLT |  | N/H | [NAME] |  | [NAME] |  | Gr. Profit
 |  |  |  |  |  |  |  | STORE 2
 |  |  |  |  |  |  |  | Gross | Net |  | Late Night |  | Allowed |  | Adj |  | [NAME] | Act
 |  |  |  |  |  |  |  |  | +/- LY
 |  |  |  |  |  |  |  |  | Maint $ | Supply $ | Cash +/- | TLT |  | N/H | [NAME] |  | [NAME] |  | Gr. Profit
 |  |  |  |  |  |  |  | STORE 3
 |  |  |  |  |  |  |  | Gross | Net |  | Late Night |  | Allowed |  | Adj |  | [NAME] | Act
 |  |  |  |  |  |  |  |  | +/- LY
 |  |  |  |  |  |  |  |  | Maint $ | Supply $ | Cash +/- | TLT |  | N/H | [NAME] |  | [NAME] |  | Gr. Profit
Spreadsheet: 109997d1306801116-xirr-question-book5
Sheet: CF

 | TOTAL |  | ACQUISITION | 2007
 |  |  | 2007-12-07 00:00:00 | 2007-12-31 00:00:00 | 2008-12-31 00:00:00 | 2009-12-31 00:00:00 | 2010-12-31 00:00:00 | 2011-12-31 00:00:00 | 2012-12-31 00:00:00 | 2013-12-31 00:00:00 | 2014-12-31 00:00:00 | 2015-12-31 00:00:00 | 2016-12-31 00:00:00 | 2017-12-31 00:00:00
CASH FLOW & RETURNS
Plus: Net Sales Proceeds |  |  | 0 | 0 | 13751843 | 1697434 | 8953552 | 12933928.96875 | 18134500.55625 | 12463157.048625 | 19279327.5 | 8281415.625 | 0 | 0
Less: Total Development Costs |  |  | -29623473 | -975292 | -20811305 | -1526231 | -3195753 | -3982311.109408743 | -6627607.773891514 | -9199434.644864015 | -11918451.27611127 | -3032321.401977242 | 0 | 0
Plus: Total Borrowings |  |  | 18077592 | 0 | 25774910 | 2314473 | 3195753 | 3982311.109408743 | 6281574.10093637 | 8500000 | 11000000 | 2750000 | 0 | 0
<Blank> |  |  | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0
<Blank> |  |  | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0
<Blank> |  |  | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0
<Blank> |  |  | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0
<Blank> |  |  | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0
Less: Total Repayments |  |  | 0 | 0 | -18077592 | 0 | -10639333 | -11381857.4925 | -15577830.71784512 | -8225683.6520925 | -15224316.3479075 | -2750000 | 0 | 0
Subtotal
Project Profits
Project IRR
0.12 |  |  | 0 | 0 | 0 | 0 | 0 | -1552071.47625 | -2176140.06675 | -1495578.845835 | -2313519.3 | 0 | 0 | 7537309.688835
Less: Acq Interest Facility - Add'l Interest |  |  | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0
Excess Land Release |  |  | 0 | 0 | -8144810 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 8144810
Intercompany working capital |  |  | 2935035 | 975292 | 7506954 | -2485676 | 1685781 | 0 | 4124345 | 0 | 0 | 0 | 0 | -14741731
<Blank> |  |  |  | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0
<Blank> |  |  |  | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0
<Blank> |  |  |  | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0
<Blank> |  |  |  | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0
<Blank> |  |  |  | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0
Cash Flow for IRR
IRR
Spreadsheet: 438083d1451738972-vlookup-to-return-certain-value-from-sheet-a-test2-4
Sheet: Sheet1

 | Company | ID | Name | Department Description | Location
 | Oxy | 44594 | Ranganathan,[NAME] | EH OMN Artifi Lift Eng Muk | Mukhaizna - Oil Field
 | Oxy | 52802 | [NAME],Doraisamy | EH OMN Artifi Lift Eng Muk | Mukhaizna - Oil Field
 | Oxy | 72737 | [NAME],[NAME] | EH OMN Artifi Lift Eng Muk | Mukhaizna - Oil Field
 | Oxy | 64288 | Ghawas,[NAME] | EH OMN Artifi Lift Eng Muk | Mukhaizna - Oil Field
 | Oxy | 64289 | [NAME],[NAME] | EH OMN Artifi Lift Eng Muk | Mukhaizna - Oil Field
 | Oxy | 64292 | [NAME],Abdulla [NAME] | EH OMN Artifi Lift Eng Muk | Mukhaizna - Oil Field
 | Oxy | 44594 | [NAME],[NAME] | EH OMN Artifi Lift Eng Muk | Mukhaizna - Oil Field
 | Oxy | 66429 | [NAME],Badar Sulaiyam Nasib | EH OMN Artifi Lift Eng Muk | Mukhaizna - Oil Field
 | Oxy | 66512 | [NAME],[NAME] | EH OMN Artifi Lift Eng Muk | Mukhaizna - Oil Field
 | Oxy | 59837 | [NAME],[NAME] | EH OMN Artifi Lift Eng Muk | Mukhaizna - Oil Field
 | Oxy | 59838 | [NAME],[NAME] | EH OMN Artifi Lift Eng Muk | Mukhaizna - Oil Field
 | Oxy | 80144 | [NAME],[NAME] | EH OMN Artifi Lift Eng Muk | Mukhaizna - Oil Field
 | Oxy | 53454 | [NAME],[NAME] | EH OMN Asset Protection | Mukhaizna - Oil Field
 | Oxy | 76495 | Vanderslice,[NAME] | EH OMN DRL MUK FLD | Mukhaizna - Oil Field
 | Oxy | 76590 | [NAME],[NAME] | EH OMN DRL MUK FLD | Mukhaizna - Oil Field
 | Oxy | 72906 | Grumley,[NAME] | EH OMN DRL MUK HES | Mukhaizna - Oil Field
 | Oxy | 75140 | [NAME],[NAME] | EH OMN DRL MUK HES | Mukhaizna - Oil Field
 | Oxy | 63742 | Johnston,[NAME] | EH OMN DRL MUK HES | Mukhaizna - Oil Field
 | Oxy | 64893 | [NAME],[NAME] | EH OMN DRL MUK HES | Mukhaizna - Oil Field
 | Oxy | 60227 | [NAME],[NAME] | EH OMN DRL MUK HES | Mukhaizna - Oil Field
 | Oxy | 60228 | [NAME],[NAME] | EH OMN DRL MUK HES | Mukhaizna - Oil Field
 | Oxy | 71730 | Bostock,[NAME] | EH OMN DRL Mukhaizna 1 | Mukhaizna - Oil Field
 | Oxy | 74930 | [NAME],[NAME] | EH OMN DRL Mukhaizna 1 | Mukhaizna - Oil Field
 | Oxy | 77195 | Norrie,[NAME] | EH OMN DRL Mukhaizna 1 | Mukhaizna - Oil Field
 | Oxy | 64038 | Spindler,Stephen | EH OMN DRL Mukhaizna 1 | Mukhaizna - Oil Field
 | Oxy | 67327 | Tiwari,Ajay Kumar | EH OMN DRL Mukhaizna 1 | Mukhaizna - Oil Field
 | Oxy | 58194 | [NAME],[NAME] | EH OMN DRL Mukhaizna 1 | Mukhaizna - Oil Field
 | Oxy | 61328 | [NAME],[NAME] | EH OMN DRL Mukhaizna 1 | Mukhaizna - Oil Field
 | Oxy | 55569 | [NAME],[NAME] | EH OMN DRL Mukhaizna 1 | Mukhaizna - Oil Field
 | Oxy | 56250 | Rush,[NAME] | EH OMN DRL Mukhaizna 1 | Mukhaizna - Oil Field
 | Oxy | 56573 | [NAME],[NAME] | EH OMN DRL Mukhaizna 1 | Mukhaizna - Oil Field
 | Oxy | 47966 | Breust,Garnet | EH OMN DRL Mukhaizna 1 | Mukhaizna - Oil Field
 | Oxy | 48404 | [NAME],[NAME] | EH OMN DRL Mukhaizna 1 | Mukhaizna - Oil Field
Spreadsheet: 583311d1532368627-macro-or-table-to-cut-paste-dates-vertically-example
Sheet: Input

person number | Startdato | Slutdato
1231 | 2018-07-01 00:00:00 | 2018-04-17 00:00:00
1232 | 2017-10-24 00:00:00 | 2018-03-26 00:00:00
 | 2016-06-03 00:00:00 | 2016-09-09 00:00:00
1233 | 29-02-2018 | 2018-05-30 00:00:00
 | 2017-09-22 00:00:00 | 2017-11-11 00:00:00
 | 2017-07-05 00:00:00 | 2017-09-03 00:00:00
 | 2016-12-28 00:00:00 | 2017-03-29 00:00:00
1234 | 2017-07-13 00:00:00 | 2018-05-23 00:00:00
 | 2016-10-09 00:00:00 | 2016-11-12 00:00:00
1235 | 2018-03-19 00:00:00 | 2999-12-31 00:00:00
 | 2017-01-04 00:00:00 | 2017-07-12 00:00:00
1236 | 2017-07-06 00:00:00 | 2999-12-31 00:00:00
1237 | 2016-11-12 00:00:00 | 2017-04-14 00:00:00
 | 2015-12-04 00:00:00 | 2016-07-25 00:00:00
1238 | 2017-09-06 00:00:00 | 2999-12-31 00:00:00
 | 2017-06-17 00:00:00 | 2017-08-29 00:00:00
 | 2016-10-01 00:00:00 | 2017-04-03 00:00:00
1239 | 2018-02-12 00:00:00 | 2018-07-14 00:00:00
 | 2017-11-25 00:00:00 | 2018-01-02 00:00:00
Spreadsheet: 762510d1641584777-lookup-multiple-criteria-multiple-results-excel-q
Sheet: P-1

DENVER - P-1  RTOU ( Jan 2-4 )
Zone | Trainee | Trainee GPID/Hire Date | RTO Trainer | Position | [NAME] | Room Nights
[NAME]
 | [NAME] | 80161181, 12/30/2018 |  | RSA |  | 0
 | [NAME] | 2018-12-30 00:00:00 |  | RSA |  | 0
Colorado Springs
[NAME]
Albuquerque | [NAME] | 80093714 |  | Merch | M | T,W
Spreadsheet: 707420d1607261797-using-a-list-to-reduce-worksheets-midshires-master-ans
Sheet: RyG

 |  |  |  | ADJUSTED HANDICAP |  |  |  |  |  | OFFICIAL HANDICAP |  |  |  |  | HANDICAPPING ALTERATIONS
hole | par | S/I | SHOTS | CALC | points | PAR 3 | SI/1 | SI/2 | S1/3 | SI/1 | S1/2 | S1/3 | CALC | points | EXACT | catagory | BUFFER | css | Nett | adjustment
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  | HANDICAP |  | ZONE |  | Differential
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  | sss | css adj | "RO"
in
out |  |  |  |  |  | TOTAL
total