tianzl66/Sheetpedia huggingface dataset:
Spreadsheet: 836883d1689695424-adding-hours-for-weekly-total-excel-help
Sheet: Sheet1

 | SUNDAY |  |  |  | MONDAY |  |  |  | TUESDAY |  |  |  | WEDNESDAY |  |  |  | THURSDAY |  |  |  | FRIDAY |  |  |  | SATURDAY
Week/Hours | On | Off | Turn | Hours | On | Off | Turn | Hours | On | Off | Turn | Hours | On | Off | Turn | Hours | On | Off | Turn | Hours | On | Off | Turn | Hours | On | Off | Turn | Hours
 |  |  |  |  | REST DAY |  |  |  | REST DAY |  |  |  | 13:05:00 | 21:50:00 | A/R |  | 12:36:00 | 21:43:00 | 43 |  | 12:47:00 | 21:15:00 | 44 |  | 13:05:00 | 21:50:00 | A/R
 |  |  |  |  | 21:00:00 | 04:05:00 | AR |  |  |  |  |  | REST DAY |  |  |  | REST DAY
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | REST DAY |  |  |  | REST DAY
 |  |  |  |  | REST DAY |  |  |  | REST DAY
 |  |  |  |  |  |  |  |  |  |  |  |  | REST DAY |  |  |  | REST DAY
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | REST DAY |  |  |  | REST DAY
 |  |  |  |  | REST DAY |  |  |  | REST DAY
 |  |  |  |  |  |  |  |  |  |  |  |  | REST DAY |  |  |  | REST DAY
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | REST DAY |  |  |  | REST DAY
 |  |  |  |  | REST DAY |  |  |  | REST DAY
 |  |  |  |  |  |  |  |  |  |  |  |  | REST DAY |  |  |  | REST DAY
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | REST DAY |  |  |  | REST DAY
 |  |  |  |  | REST DAY |  |  |  | REST DAY
Spreadsheet: 60f1f268-3cc1-43f5-a23e-f0a459bc3fdf
Sheet: Invsigtns, Exams, and Commts

 |  | Pre-Sentence Investigation Reports (I.C. 19-2524) |  |  | Designated Examinations  by Ordering County |  |  |  |  | Civil Commitments (I.C. 66-329)  by Ordering County
 |  | Monthly | [NAME] |  | Monthly County Total | Monthly Regional Total | [NAME] | [NAME] |  | Monthly County Total | Monthly Regional Total | [NAME] | [NAME]
Region 1 | Benewah
 | [NAME] |  |  |  | 9 |  | 15 |  |  | 1 |  | 4
 | Boundary
 | Kootenai |  |  |  | 48 |  | 84 |  |  | 7 |  | 17
 | Shoshone |  |  |  | 1 |  | 3 |  |  | 1 |  | 2
Region 2 | Clearwater |  |  |  | 1 |  | 2 |  |  |  |  | 1
 | Idaho |  |  |  | 1 |  | 3 |  |  |  |  | 1
 | Latah |  |  |  | 2 |  | 6 |  |  | 1 |  | 3
 | Lewis
 | Nez Perce |  |  |  | 11 |  | 22 |  |  | 4 |  | 8
Region 3 | Adams |  |  |  | 1 |  | 2 |  |  | 1 |  | 1
 | Canyon |  |  |  | 68 |  | 146 |  |  | 14 |  | 23
 | Gem |  |  |  | 6 |  | 10 |  |  | 2 |  | 2
 | Owyhee |  |  |  | 1 |  | 3 |  |  |  |  | 1
 | Payette |  |  |  |  |  | 2
 | Washington |  |  |  | 3 |  | 6 |  |  | 1 |  | 1
Region 4 | [NAME] |  |  |  | 148 |  | 311 |  |  | 35 |  | 66
 | Boise |  |  |  | 1 |  | 1
 | Elmore |  |  |  | 11 |  | 12 |  |  | 2 |  | 2
 | Valley |  |  |  |  |  | 2
Region 5 | Blaine |  |  |  | 4 |  | 9 |  |  |  |  | 1
 | [NAME] |  |  |  | 1 |  | 1
 | Cassia |  |  |  | 4 |  | 9 |  |  |  |  | 1
 | Gooding |  |  |  | 6 |  | 8 |  |  | 2 |  | 3
 | [NAME] |  |  |  | 1 |  | 6 |  |  |  |  | 1
 | Lincoln |  |  |  |  |  | 1
 | Minidoka
 | [NAME] |  |  |  | 32 |  | 61 |  |  | 5 |  | 6
Region 6 | Bannock |  |  |  | 23 |  | 52 |  |  | 11 |  | 19
 | Bear Lake
 | [NAME]
 | Franklin |  |  |  | 2 |  | 2
 | Oneida
 | Power |  |  |  |  |  | 1
Region 7 | Bingham |  |  |  | 14 |  | 20 |  |  | 6 |  | 7
 | [NAME] |  |  |  | 23 |  | 42 |  |  | 7 |  | 13
 | [NAME]
 | [NAME]
 | Custer
 | Fremont |  |  |  |  |  | 3
 | [NAME] |  |  |  | 3 |  | 5
 | Lemhi |  |  |  | 3 |  | 6 |  |  | 1 |  | 3
 | [NAME] |  |  |  |  |  | 5 |  |  |  |  | 2
 | Teton
Unknown |  | . | . |  | 2 |  | 3
Statewide |  |  |  |  | 430 |  | 864 |  |  | 101 |  | 188
 | 19 2524 Assessments
IDHW, DBH, Region 1 | 6 | 9
IDHW, DBH, Region 2 | 0 | 1
IDHW, DBH, Region 3 | 14 | 34
IDHW, DBH, Region 4 | 20 | 43
IDHW, DBH, Region 5 | 7 | 17
IDHW, DBH, Region 6 | 9 | 20
IDHW, DBH, Region 7 | 16 | 31
Statewide Month Totals
Spreadsheet: 767240d1644353186-overlapping-dates-overlapping
Sheet: Sheet1

MemberID | Insurance Start Date | Insurance End Date | No.Of.Days
M1 | 2017-01-01 00:00:00 | 2017-11-20 00:00:00
M1 | 2017-12-31 00:00:00 | 2018-02-01 00:00:00
M1 | 2018-02-15 00:00:00 | 2018-04-30 00:00:00
M1 | 2018-06-10 00:00:00 | 2018-12-31 00:00:00
M1 | 2017-01-01 00:00:00 | 2017-11-20 00:00:00 |  |  | Sum of No.Of.Days | Column Labels
M1 | 2017-12-31 00:00:00 | 2018-02-01 00:00:00 |  |  | Row Labels | 2017 | 2018 | 2020 | Grand Total
M1 | 2018-02-15 00:00:00 | 2018-04-30 00:00:00 |  |  | M1 | 710 | 615 |  | 1325
M1 | 2018-06-10 00:00:00 | 2018-12-31 00:00:00 |  |  | M2 | 355 |  |  | 355
M1 | 2018-01-31 00:00:00 | 2018-03-31 00:00:00 |  |  | M3 |  | 278 |  | 278
M2 | 2017-01-01 00:00:00 | 2017-11-20 00:00:00 |  |  | M4 | 355 |  |  | 355
M2 | 2017-12-31 00:00:00 | 2018-02-01 00:00:00 |  |  | M5 |  | 278 |  | 278
M3 | 2018-02-15 00:00:00 | 2018-04-30 00:00:00 |  |  | M6 | 1094 |  |  | 1094
M3 | 2018-06-10 00:00:00 | 2018-12-31 00:00:00 |  |  | M7 | 364 |  |  | 364
M4 | 2017-01-01 00:00:00 | 2017-11-20 00:00:00 |  |  | M8 |  |  | 365 | 365
M4 | 2017-12-31 00:00:00 | 2018-02-01 00:00:00 |  |  | M9 |  | 580 |  | 580
M5 | 2018-02-15 00:00:00 | 2018-04-30 00:00:00 |  |  | Grand Total | 2878 | 1751 | 365 | 4994
M5 | 2018-06-10 00:00:00 | 2018-12-31 00:00:00
M6 | 2017-01-01 00:00:00 | 2019-12-31 00:00:00
M7 | 2017-12-31 00:00:00 | 2018-12-30 00:00:00
M8 | 2020-01-01 00:00:00 | 2020-12-31 00:00:00
M9 | 2018-06-30 00:00:00 | 2020-01-31 00:00:00
Spreadsheet: 92673d1292253595-counting-occurrences-of-data-in-multiple-columns-counting-issue
Sheet: Sheet1

Target List | Clinical Services |  | Capacity Building & TA
APIWC | ACMC |  | AETC
Black Coalition on AIDS | AETC |  | AIDS Legal Referral
Cal-PEP | AIDS Project East Bay |  | AIDS Project East Bay
East Bay AIDS Center | APEB |  | Alameda Health Consortium
Family Care Network | APIWC | 1 | APEB
Get Screened Oakland | Arc of Refuge |  | APIWC | 1
OAA | Asian American Recovery Services |  | Arc of Refuge
Rainbow Community Center | CCMC |  | Black Coalition on AIDS
WORLD | CDBG-Contra Costa |  | Cal-PEP | 1
 | Childrens Hope Clinic |  | CDBG-Contra Costa
 | Community Clinics-Berkeley |  | CDC
 | Concord Health Clinic |  | CoCo Office of AIDS
 | CPMC |  | Compass Point
 |  |  | Downtown Youth
 | Downtown Youth |  | Dr. [NAME]
 | Dr. [NAME] |  | East Bay Aids Center | 1
 | East Bay AIDS Center | 1 | EBCF
 | Family Care Network | 1 | Family Care Network | 1
 | [NAME] |  | Food Bank of Cococo & Solano
 | Grupo Fremont |  | Get Screened Oakland | 1
 | [NAME] |  | Grupo Fremont
 | [NAME] |  | HEP
 | LGBT Centers |  | Horizons Foundation
 | [NAME] |  | [NAME]
 | Neighborhood House of North Richmond |  | LGBT Centers
 | No. Richmond Health Centre |  | Magnet
 | Office of AIDS-Oakland EFA |  | Neighborhood House of North Richmond
 | SF General |  | No. Richmond Health Centre
 | SFDPH |  | Nonprofit Support Center
 | South of Market Clinic |  | OAA | 1
 | Southeast Community Health |  | Office of AIDS-Oakland EFA
 | St. Anthony's Clinic |  | Pacific Center
 | Tenderloin Health |  | Positive Resource Center
 | Tricities |  | Prevention Training Center
 | UC California |  | Project Inform
 | UCSF |  | Project Open Hands
 | YWCA |  | Rubicon
 |  |  | RYSE
 |  |  | San Francisco AIDS Foundation
 |  |  | SF General
 |  |  | SFDPH
 |  |  | State Office of AIDS
 |  |  | Stop AIDS Project
 |  |  | UC California
 |  |  | UCSF
 |  |  | WORLD | 1
Spreadsheet: 674571d1587918527-random-numbers-without-duplicates-tournament
Sheet: Sheet1

Tennis Tournament Players |  |  |  | Solution
Name | Opponent |  |  | Name | Series | Randbetween | Opponent
[NAME] |  |  |  | [NAME] | 1
Mark |  |  |  | Mark | 2
[NAME] |  |  |  | [NAME] | 3
[NAME] |  |  |  | [NAME] | 4
[NAME] |  |  |  | [NAME] | 5
[NAME] |  |  |  | [NAME] | 6
Jerter |  |  |  | Jerter | 7
Sudan |  |  |  | Sudan | 8
Micheal |  |  |  | Micheal | 9
Rikcy |  |  |  | Rikcy | 10
Mustar |  |  |  | Mustar | 11
Sandwar |  |  |  | Sandwar | 12
Bariona |  |  |  | Bariona | 13
[NAME] |  |  |  | [NAME] | 14
Mikalaah |  |  |  | Mikalaah | 15
Hiposu |  |  |  | Hiposu | 16
Jikanu |  |  |  | Jikanu | 17
Miaena |  |  |  | Miaena | 18
Louisiana |  |  |  | Louisiana | 19
Spreadsheet: 217482d1362079388-if-statements-with-text-and-numbers-across-multiple-tabs-test
Sheet: TEST

Project Open | Submitted to Department 1 | Submitted to Department 2 | Completed by Department 2 | Submitted to Department 3 | Completed by Department 3 | Completed by Department 1 | Days Open with Dept 2 | Days Open with Dept 1 | Days Open with Dept 3 | Work Order Life Span
2012-11-29 00:00:00 | 2012-12-01 00:00:00 | 2012-12-13 00:00:00 | 2013-01-09 00:00:00 | 2013-01-17 00:00:00 | 2013-01-17 00:00:00 | 2013-01-17 00:00:00
2012-12-20 00:00:00 | 2012-12-20 00:00:00 | 2013-01-02 00:00:00 | 2013-01-10 00:00:00 | 2013-01-15 00:00:00 | 2013-01-22 00:00:00 | 2013-01-22 00:00:00
2012-12-19 00:00:00 | 2012-12-21 00:00:00 | 2013-01-11 00:00:00 | 2013-01-15 00:00:00 | 2013-01-16 00:00:00 | 2013-01-23 00:00:00 | 2013-01-25 00:00:00
2012-12-20 00:00:00 | 2012-12-21 00:00:00 | 2013-01-25 00:00:00 | 2013-02-13 00:00:00 | 2013-02-13 00:00:00 | 2013-02-14 00:00:00 | 2013-02-14 00:00:00
2013-01-28 00:00:00 | 2013-01-02 00:00:00 | 2013-01-28 00:00:00 | 2013-02-19 00:00:00 | 2013-02-19 00:00:00 | 2013-02-25 00:00:00 | 2013-02-25 00:00:00
2013-01-30 00:00:00 | 2013-01-30 00:00:00 | 2013-01-30 00:00:00 | 2013-02-20 00:00:00 | 2013-02-20 00:00:00 | 2013-02-20 00:00:00 | 2013-02-28 00:00:00
2012-12-19 00:00:00 | 2012-12-20 00:00:00 | 2013-01-25 00:00:00 | 2013-02-07 00:00:00 | 2013-02-07 00:00:00 | 2013-02-13 00:00:00 | 2013-02-13 00:00:00
2012-12-17 00:00:00 | 2012-12-18 00:00:00 | 2013-01-25 00:00:00 | 2013-02-07 00:00:00 | 2013-02-07 00:00:00 | 2013-02-13 00:00:00
2013-01-24 00:00:00 | 2013-01-24 00:00:00 | 2013-01-24 00:00:00 | 2013-02-04 00:00:00 | 2013-02-04 00:00:00 | 2013-02-13 00:00:00 | 2013-02-13 00:00:00
Spreadsheet: 53299d1253195274-if-function-fifa_night_2009-1-
Sheet: Teams and Rules

Butchers Arms FIFA 09 Tournament
 |  |  |  | Friday 25th September 2009
 | www.butchersarmsfc.co.uk
 | Teams and Rules
 | Teams will be selected on the night at random
 | Names will be pulled from a hat and the first person out gets first pick of team and so forth
 | Teams will be chosen from the following - all 4.5 stars on the game
 |  | [NAME] |  |  |  |  | Everton |  |  |  |  | Liverpool
 |  | Manchester City |  |  |  |  | [NAME] |  |  |  |  | Fiorentina
 |  | Roma |  |  |  |  | Athletico Madrid |  |  |  |  | Sevilla
 |  | [NAME] |  |  |  |  | Villareal |  |  |  |  | Bordeaux
 |  | Lyon |  |  |  |  | Leverkusen |  |  |  |  | Schalke
 |  | [NAME]
 | Games are to be played as per the schedule but [NAME] reserves the right to change the times on the night
 | Halves will be 6 minutes long in the group stages
 | From the Quarter Finals onwards the half length will be increased to 8 minutes
 | The Home Team can have the choice of ground
 | In the Group stage, if scores are level after 90mins then the game is a draw
 | Extra Time and Penalties will be played from the Quarter Finals onwards
 | Team line ups/formations/tactics can be changed but only 1 minute is allowed to do this as time is precious
 | If after 1 minute you have not completed any changes you will be told to start the game regardless
 | Points are awarded as follows.  3 points for a win, 1 point for a draw.
 | The top 2 from each group go through to the quarter finals plus the best 2 third placed players
 | Group placings are decided on points, goal difference and then team name (not player name)
 | Drinking is permitted but no responsibility will be taken for poor performance due to alcohol
Spreadsheet: 180742d1347729561-individual-record-to-show-in-one-click-dummy-for-individual-training-record-2-
Sheet: Sheet2

Enter an Employee | Total Hours
Kunal Kumar
Training Topic | Hours |  | 0
Spreadsheet: 070d6fab-5220-4479-9cc0-fe8875bc67a3
Sheet: Sheet1

analytica 2012 - List of exhibitors | Unnamed: 1 | Unnamed: 2 | Unnamed: 3 | Unnamed: 4 | Unnamed: 5
 | Search by product and service index (6 Entries):
 | 5 Laboratory apparatus 5.4 Laboratory technology and equipment 5.4.6 Supplies and consumables 5.4.6.3 Burettes
No. | Company | Country | City | [NAME] | Hall/Booth
1 | BRAND GMBH + CO KG Fabrik für Laborgeräte | Germany | Wertheim | 97877 | B1.323/422
2 | [NAME] [NAME] | Germany | Eberstadt | 74246 | B1.231
3 | Isolab Laborgeräte GmbH | Germany | Wertheim | 97877 | B1.215
4 | [NAME], a.s. | Czech Republic | Prag | 150 00 | B1.431
5 | Thermo Scientific | Germany | Dreieich | 63303 | B1.101/202
6 | [NAME] | Germany | Großostheim | 63762 | B1.205
Spreadsheet: 165740d1341330504-vlookup-wanting-2nd-3rd-occurrence-etc-25
Sheet: .50

Availability Exceptions by Date | Dates affected:  1/1/2012 to 7/31/2012 | [NAME] |  | 2012-05-30 00:00:00 | Off (.50) from 12:30PM -  9:00PM; source: One-click (Sick or Other) |  | Report template modified: 6/12/2012 | 1 | 2012-06-12 00:00:00
Availability Exceptions by Date | Dates affected:  1/1/2012 to 7/31/2012 | [NAME] |  | 2012-06-04 00:00:00 | Off (.50) from  8:00AM -  4:30PM; source: One-click (Sick or Other) |  | Report template modified: 6/12/2012 | 1 | 2012-06-12 00:00:00
Availability Exceptions by Date | Dates affected:  1/1/2012 to 7/31/2012 | [NAME] |  | 2012-06-05 00:00:00 | Off (.50) from  8:00AM -  4:30PM; source: One-click (Sick or Other) |  | Report template modified: 6/12/2012 | 1 | 2012-06-12 00:00:00
Availability Exceptions by Date | Dates affected:  1/1/2012 to 7/31/2012 | [NAME] |  | 2012-06-05 00:00:00 | Off (.50) from  8:00AM -  4:30PM; source: One-click (Sick or Other) |  | Report template modified: 6/12/2012 | 1 | 2012-06-12 00:00:00
Availability Exceptions by Date | Dates affected:  1/1/2012 to 7/31/2012 | [NAME] |  | 2012-06-06 00:00:00 | Off (.50) from  8:00AM -  4:30PM; source: One-click (Sick or Other) |  | Report template modified: 6/12/2012 | 1 | 2012-06-12 00:00:00
Availability Exceptions by Date | Dates affected:  1/1/2012 to 7/31/2012 | [NAME] |  | 2012-06-11 00:00:00 | Off (.50) from 10:00AM -  6:30PM; source: One-click (Sick or Other) |  | Report template modified: 6/12/2012 | 1 | 2012-06-12 00:00:00
Spreadsheet: 106145d1303350012-simultaneous-updating-worksheets-overdue-ageing
Sheet: WH1

NAME OF THE COMPANY |  |  |  | ABC & Co
 |  |  |  | WAREHOUSE-1
DETAILS OF AGE-WISE DEBTORS REPORT AS ON |  |  |  | 2011-04-15 00:00:00
Name of the Party |  | Party Status | Invoice Date | Invoice No. | Credit Period | Due Date | Delay (Days) | Invoice Amount | Outstanding Invoice Amount (Rs.) | < 0 | <0 - 30> | <31 - 60> | <61 - 90> | <91 - 120> | <121 - 150> | <151 - 180> | > 180 Days
ALFAEX EXIM | DELHI | DIRECT PARTY | 2010-09-04 00:00:00 | 141 | 60 | 2010-11-03 00:00:00 | 163 |  | 239 | 0 | 0 | 0 | 0 | 0 | 0 | 239 | 0
CLASSIC CLASSIDYY | NORTH | DIRECT PARTY | 2011-01-20 00:00:00 | 342 | 60 | 2011-03-21 00:00:00 | 25 | 33264 | 33264 | 0 | 33264 | 0 | 0 | 0 | 0 | 0 | 0
ALUTEX COATING | NORTH | DEALER | 2011-02-23 00:00:00 | 395 | 60 | 2011-04-24 00:00:00 | -9 | 26611 | 2760 | 2760 | 0 | 0 | 0 | 0 | 0 | 0 | 0
ROSEX BINDERS | NORTH | DEALER | 2011-03-08 00:00:00 | 417 | 60 | 2011-05-07 00:00:00 | -22 | 83160 | 1970 | 1970 | 0 | 0 | 0 | 0 | 0 | 0 | 0
TOTAL OVERDUE AS ON DATE |  |  |  |  |  |  |  | 143035 | 38233 | 4730 | 33264 | 0 | 0 | 0 | 0 | 239 | 0
Spreadsheet: 74076d1274692374-date-calculation-certain-periods-thread
Sheet: Sheet1

Name | Period 1 | Period 2 | Period3
[NAME]
[NAME]
[NAME]
Name | From | Until | From | Until | From | Until
[NAME] | 2010-04-20 00:00:00 | 2010-05-10 00:00:00 | 2010-05-20 00:00:00 | 2010-05-25 00:00:00 | 2010-06-01 00:00:00 | 2010-06-15 00:00:00
[NAME] | 2010-03-18 00:00:00 | 2010-04-06 00:00:00 | 2010-05-04 00:00:00 | 2010-04-23 00:00:00 | 2010-05-02 00:00:00 | 2010-05-15 00:00:00
[NAME] | 2010-03-12 00:00:00 | 2010-03-24 00:00:00 | 2010-04-07 00:00:00 | 2010-04-18 00:00:00 | 2010-05-03 00:00:00 | 2010-05-26 00:00:00
Period 1 |  | Period 2 |  | Period 3
From | Until | From | Until | From | Until
2010-03-01 00:00:00 | 2010-04-15 00:00:00 | 2010-04-16 00:00:00 | 2010-05-19 00:00:00 | 2010-05-20 00:00:00 | 2010-06-30 00:00:00
Spreadsheet: 792169d1660759988-calculate-the-penalty-amount-based-of-payment-date-penalty-charge-1
Sheet: Sheet1

Sr | BILL AMOUNT | DUE DATE | LATE PAYMENT CHARGES | PAYMENT DATE |  | LATE PAYMENT CHARGES DAYS | LATE PAYMENT CHARGE @ 15 % PER ANNUM | Calculation of column D is based on calculation of Column G and H
1 | 8743.140000000001 | 2020-09-07 00:00:00 | 0
2 | 3594.4 | 2020-09-25 00:00:00 | 0
3 | 8548.1 | 2020-10-29 00:00:00 | 0 | 2020-10-15 00:00:00
4 | 14506.26 | 2020-12-01 00:00:00 |  | 2020-11-27 00:00:00
5 | 6657.780000000001 | 2020-12-28 00:00:00 | 0
6 | 6906.080000000001 | 2021-01-12 00:00:00 | 0 | 2021-01-12 00:00:00
7 | 7817.9 | 2021-02-16 00:00:00
8 | 2976.68 | 2021-03-15 00:00:00 | 0 | 2021-03-14 00:00:00
 | >> in above example there are three bills due (Cell B2) 8743.14, (Cell B3) 3594.4, (Cell B4) 8548.1 on different dates as shown in Cell C2, [NAME] and C4 respectively. But payment of all three Bills are done on 15-10-2020. Now, Due Date of First bill is 07-09-2020 and Payment done on 15-10-2020 so Day difference in this case is (15-10-2020 – 07-09-2020 = 38 days). This bills amount is 8743.14, so late payment charge calculation will be doen as per below ((8743.14*15%)*38)/365 = [PHONE] Due Date of Second bill is 25-09-2020 and payment date is 15-10-2020 so day difference is (15-10-2020 – 15-10-2020 = 20 days). This bills amount is 3594.4, so late payment charge calculation will be done as per below ((3594.4*15%)*20)/365 = 29.5430137 Due date of third bill is 29-10-2020 and payment done date is 15-10-2020, which means on this bill late payment charges will not be levied since payment has been done prior to due date. So the late payment charge [PHONE] ([PHONE] + 29.5430137) will be recoverable with fourth bill amount. Due date of fourth bill is 01-12-2020 and payment was done on 27-11-2020, so in this case there is no Late payment charge since payment was done before due date. Payment of fifth and Sixth bill was done on 12-01-2021, in this case sixth bill was paid on due date so there is no Late payment charge for that bill. Due date of fifth bill was 28-12-2020 and payment date is 12-01-2021, Late payment charge will be levied on (12-01-2021 – 28-12-2020 = 15 Days) ((6657.78*15%)*15)/365 = 41.04110959 Which will be recoverable with seventh bill.
Spreadsheet: 14f93eff-6033-457e-bdda-537ff33efdc8
Sheet: EPR CF

Consolidated Statements of Cash Flows (Unaudited and Condensed)
 | Years Ended
 | September 30,
 | 2013 |  | 2012
(In millions)
Operating
Net income | 272.6999999999999 |  | 245.9000000000003
Adjustments:
Depreciation and amortization | 231.6 |  | 240.3
Acquisition-related contingent earn-out costs | 35 |  | 27.5
Other non-cash items | 95.3 |  | 98.10000000000002
Changes in operating assets and liabilities, excluding acquisitions:
Receivables | -93.1 |  | -101.1
Inventories | 14.2 |  | -11.7
Accounts payable and accrued liabilities | -33.6 |  | 53.8
Jackpot liabilities | -73.6 |  | -47.50000000000001
Income taxes, net of employee stock plans | -27.1 |  | -40.8
Other assets and deferred costs | 28.6 |  | -18
Settlement of treasury lock contracts | 12.6 |  | 0
Net operating cash flows | 462.5999999999999 |  | 446.5000000000003
Investing
Capital expenditures | -127.8 |  | -208.7
Investment securities, net | -28.8 |  | 0
Jackpot annuity investments, net | 48.6 |  | 51.8
Changes in restricted cash | 14.9 |  | 10.7
Loans receivable, net | 32.4 |  | 29
Business acquisitions, net of cash acquired | 0 |  | -233.9
Other | 24.6 |  | 42.3
Net investing cash flows | -36.10000000000002 |  | -308.7999999999999
Financing
Debt-related proceeds (payments), net | 351.4 |  | 140
Employee stock plan proceeds | 30 |  | 15.7
Share repurchases | -190.5 |  | -475.2
Noncontrolling interest acquired | 0 |  | -2.5
Dividends paid | -79 |  | -70.6
Acquisition-related contingent consideration | -27.9 |  | 0
Net financing cash flows | 84 |  | -392.6
Foreign exchange rates effect on cash | -3.5 |  | 1.2
Net change in cash and equivalents | 506.9999999999998 |  | -253.6999999999995
Beginning cash and equivalents | 206.3 |  | 460
Ending cash and equivalents | 713.2999999999998 |  | 206.3000000000005
Spreadsheet: 878077d1725032049-i-want-a-result-as-index-with-match-a-range-book1
Sheet: Sheet1

Index | [NAME] |  |  | Result |  |  |  | Criteria
1 | a |  |  | 1 |  |  |  | a
2 | b |  |  | 2 |  |  |  | b
3 | c |  |  | 3 |  |  |  | c
4 | d |  |  | 4 |  |  |  | d
5 | e |  |  | 5 |  |  |  | e
6 | f |  |  | 10
7 | g |  |  | 11
8 | h |  |  | 12
9 | i |  |  | 13
10 | a |  |  | 14
11 | b |  |  | 19
12 | c |  |  | 20
13 | d |  |  | 21
14 | e |  |  | 22
15 | f |  |  | 23
16 | g |  |  |  |  |  |  | I want highlighted result matching the criteria
17 | h
18 | i
19 | a
20 | b
21 | c
22 | d
23 | e
24 | f
25 | g
26 | h
27 | i
Spreadsheet: 729549d1619161325-formula-to-count-days-worked-that-are-on-weekends-schedule-help-needed
Sheet: LOCKED

START
END |  |  | NUMBERS  FORMULA | IF(COLUMNS($B2:B2)>DAY(LOCKED!$B$4),"",LOCKED!$B$3+COLUMNS($B2:B2)-1)
 |  |  | WEEKDAY FORMULA | IF(COLUMNS($B17:B17)>DAY(LOCKED!$B$4),"",LOCKED!$B$3+COLUMNS($B17:B17)-1)
Month | Year |  | Conditional Formatting | OR(COUNTIF(B$3:B$15,1)<>2,COUNTIF(B$3:B$15,2)<>2)
January | 2018 |  | Two line of text in one cell |  | ALT + ENTER
February | 2019
March | 2020
April | 2021
May | 2022
June | 2023
July | 2024
August | 2025
September | 2026
October | 2027
November | 2028
December | 2029
 | 2030
 | 2031
 | 2032
 | 2033
 | 2034
 | 2035
 | 2036
 | 2037
 | 2038
 | 2039
 | 2040
 | 2041
 | 2042
 | 2043
 | 2044
 | 2045
 | 2046
 | 2047
 | 2048
 | 2049
 | 2050
Spreadsheet: 274064d1382996884-help-with-a-two-dimensional-lookup-index-function-please-example-problematic-table
Sheet: Sheet1

 | 5 | 10 | 15 | 20 | 25 | 30 | 35 | 40
0.5 | 2 | 5 | 7 | 10 | 12 | 14 | 16 | 18
0.6 | 3 | 6 | 9 | 11 | 14 | 16 | 19 | 21
0.7 | 3 | 7 | 10 | 13 | 16 | 19 | 22 | 24
0.8 | 4 | 8 | 11 | 15 | 18 | 21 | 24 | 27
0.9 | 4 | 9 | 13 | 16 | 20 | 24 | 27 | 30
1 | 5 | 10 | 14 | 18 | 22 | 26 | 30 | 33
1.1 | 5 | 10 | 15 | 20 | 24 | 28 | 32 | 36
1.2 | 6 | 11 | 16 | 21 | 26 | 30 | 34 | 38
1.3 | 6 | 12 | 18 | 23 | 28 | 32 | 37 | 41
1.4 | 7 | 13 | 19 | 24 | 30 | 34 | 39 | 43
1.5 | 7 | 14 | 20 | 26 | 31 | 36 | 41 | 45
1.6 | 8 | 15 | 21 | 27 | 33 | 38 | 43 | 47
1.7 | 8 | 16 | 23 | 29 | 35 | 40 | 45 | 49
1.8 | 9 | 16 | 24 | 30 | 36 | 42 | 47 | 51
1.9 | 9 | 17 | 25 | 32 | 38 | 43 | 49 | 53
2 | 10 | 18 | 26 | 33 | 39 | 45 | 50 | 55
2.1 | 10 | 19 | 27 | 34 | 41 | 47 | 52 | 57
2.2 | 10 | 20 | 28 | 36 | 42 | 48 | 54 | 58
2.3 | 11 | 21 | 29 | 37 | 44 | 50 | 55 | 60
2.4 | 11 | 21 | 30 | 38 | 45 | 51 | 57 | 62
2.5 | 12 | 22 | 31 | 39 | 46 | 53 | 58 | 63
Look Up | Expected Result | [NAME]
2.2 | 42
25
Spreadsheet: 76348d1276855014-check-for-repeated-series-repeatedseries
Sheet: Sheet1

fill in series |  |  | warning if last filled in series already exists above | last of existing series
12 | 22 | 90 |  | 23 | 1 | 49
49 | 12 | 5
11 | 32 | 50
23 | 1 | 49 |  |  |  |  | x
 |  |  |  | helper columns
Spreadsheet: robin_rodrigue__33293__cross commodity list
Sheet: Sheet1

Summary of Cross-Commodity Positions
2001-01-17 00:00:00
 | Cross-Commodity | Counterparty |  | Commodity |  | Commodity |  | Commodity |  | Commodity
Commodity Group | Position | (Specify which Enron | NOP | Group Where | M/G | Group Where | VaR | Group Where | P/L | Group Where
 |  | desk, or if 3rd party) |  | NOP Captured |  | M/G Captured |  | VaR Captured | YTD | P/L Captured
Gas | 125 | NG-Price,FT-NY,G-Daily-Est,FT-Northwest,Ft-West,FT-Ontario,FT-West-EOL, |  |  | -29.5 | Gas | 220528 | [NAME] | -4755000 | Cross Commodity Trading
Power | 940 | Hedgecdn,EPMI-Midwest,EPMI-LT-Ercot,EPMI-LT-Mgmt,EPMI-LT-NW |  |  |  |  | 317853 | [NAME] | -1174000 | Cross Commodity Trading
Crude | 25 | Wti-GW-NXC2,Phyoil-Price |  |  |  |  | 25479 | [NAME] | 145000 | Cross Commodity Trading
Coal | 8 | Coal-East-II |  |  |  |  | 2949 | [NAME] | -10000 | Cross Commodity Trading
NOTE:  All amounts above are meant to represent what is being reported in the DPR - so if some positions with other Enron desks are classified as affiliate positions
an therefore, or otherwise, excluded from the DPR reporting, then identify as such so we understand the related reporting for each side of the transaction.