tianzl66/Sheetpedia huggingface dataset:
Spreadsheet: dafb6b49-996f-4bc0-94e0-eedfb3cfbba6
Sheet: Enrollment

School Year | Fiscal Year | PreK(1) | K to 8(2) | Ungraded K to 8(3) | All K to 8(4) | 9 to 12(2) | Ungraded 9 to 12(3) | All 9 to 12(4) | All K to 12 in CPS Schools(2) | All Ungraded in CPS Schools(3) | All Enrolled in CPS Schools(4) | CPS Supported, Not Enrolled(5) | CPS System(6)
1994-1995 | FY 95 | 36 | 5574 | 473 |  | 2047 | 10 |  |  |  |  | 151
1995-1996 | FY 96 | 26 | 5528 | 451 |  | 1989 | 11 |  |  |  |  | 163
1996-1997 | FY 97 | 24 | 5539 | 321 |  | 1983 | 13 |  |  |  |  | 173
1997-1998 | FY 98 | 25 | 5497 | 232 |  | 1910 | 15 |  |  |  |  | 195
1998-1999 | FY 99 | 23 | 5271 | 237 |  | 1910 | 5 |  |  |  |  | 200
1999-2000 | FY 00 | 23 | 5119 | 215 |  | 1930 | 7 |  |  |  |  | 206
2000-2001 | FY 01 | 20 | 4947 | 192 |  | 1951 | 0 |  |  |  |  | 257
2001-2002 | FY 02 | 50 | 4935 | 98 |  | 1904 | 0 |  |  |  |  | 319
2002-2003 | FY 03 | 55 | 4722 | 112 |  | 1879 | 9 |  |  |  |  | 334
2003-2004 | FY 04 | 55 | 4417 |  |  | 1887 | 0 |  |  |  |  | 312
2004-2005 | FY 05 | 50 | 4213 |  |  | 1827 | 0 |  |  |  |  | 268
2005-2006 | FY 06 | 52 | 3920 |  |  | 1730 | 8 |  |  |  |  | 200
2006-2007 | FY 07 | 70 | 3837 | 98 |  | 1612 | 0 |  |  |  |  | 188
2007-2008 | FY 08 |  | 3942 | 98 |  |  | 6 |  |  |  |  | 170
2008-2009 | FY 09 |  |  | 100 |  |  | 11 |  |  |  |  | 179
2009-2010 | FY 10 |  | 4117 |  |  |  | 40 |  |  |  |  | 203
2010-2011 | FY 11 |  | 4199 | 102 |  |  | 9 |  |  |  |  | 204
2011-2012 | FY 12 |  | 4183 | 118 |  |  | 7 |  |  |  |  | 181
2012-2013 | FY 13 | 144 | 4279 | 115 |  | 1678 | 6 |  |  |  |  | 185
Spreadsheet: 839149d1691693975-lookup-example1
Sheet: Income

 | INCOME
 |  |  |  |  |  |  |  | Total Made
 | Date | Item | Income Stream | Price | Payment | Fees | Postage | Total | Notes |  |  | Fees | Pecentage | Column2
 | 20th May 2023 | Honeycomb | Craft Market | 20 | Cash |  | 0 |  | Lutterworth |  |  | Cash | 0
 | 20th May 2023 | [NAME] | Craft Market | 15 | SumUp |  | 0 |  | Lutterworth |  |  | Paypal | 0.029 | 0.3
 | 20th May 2023 | [NAME] | Craft Market | 15 | Cash |  | 0 |  | Lutterworth |  |  | SumUp | 0.0169
 | 20th May 2023 | Dragonfly | Craft Market | 10 | Cash |  | 0 |  | Lutterworth |  |  | Stripe | 0.015 | 0.3
 | 20th May 2023 | Honeycomb | Craft Market | 20 | Cash |  | 0 |  | Lutterworth
 | 27th May 2023 | [NAME] | Craft Market | 25 | SumUp |  | 0 |  | Hinckley
 | 27th May 2023 | Gothic Spinner & [NAME] | Craft Market | 35 | SumUp |  | 0 |  | Hinckley
 | 27th May 2023 | Rainbow Spinner & Squirly Heart | Craft Market | 35 | SumUp |  | 0 |  | Hinckley
 | 27th May 2023 | [NAME] | Craft Market | 15 | Cash |  | 0 |  | Hinckley
 | 3rd June 2023 | [NAME] | Craft Market | 25 | Cash |  | 0 |  | [NAME]
 | 8th June 2023 | Poppy Spinner | Craft Market | 25 | Paypal |  | 3.29 |  | March
 | 8th June 2023 | Dragonfly | Craft Market | 10 | Cash |  | 0 |  | March
 | 8th June 2023 | Honeycomb | Craft Market | 20 | Cash |  | 0 |  | March
 | 22nd June 2023 | Custom Dangle & Custom Heart | Craft Market | 40 | SumUp |  | 3.29 |  | Banbury
 | 22nd June 2023 | Dragonfly | Craft Market | 10 | Cash |  | 0 |  | Banbury
 | 22nd June 2023 | [NAME] | Craft Market | 10 | Cash |  | 0 |  | Banbury
 | 22nd June 2023 | Honeycomb | Craft Market | 20 | Cash |  | 0 |  | Banbury
 | 22nd June 2023 | Crystal Sqaure | Craft Market | 20 | Cash |  | 0 |  | Banbury
 | 22nd June 2023 | [NAME] | Craft Market | 25 | Cash |  | 0 |  | Banbury
 | 4th August | [NAME] | Website | 20 | Stripe |  | 3.29
Spreadsheet: 764398d1642708816-formula-to-adjust-a-rate-based-on-lookup-of-dept-payroll-sample
Sheet: Tab 2

No. | 100 |  |  | Base Rate |  | C61C | 0
Name |  |  |  | Adjusted Rate | 25 | C61CJ | 0
 |  |  |  |  |  | C61Q | 0.2
 |  |  |  |  |  | C61QJ | 0.2
 |  |  |  |  |  | C65D | 0.1
 |  |  |  |  |  | C65DJ | 0.1
 |  |  |  |  |  | C65F | 0.1
 |  |  |  |  |  | C65FJ | 0.1
 |  |  |  |  |  | C65L | 0.3
 |  |  |  |  |  | C65LJ | 0.3
 |  |  |  |  |  | C65S | 0.3
 |  |  |  |  |  | [NAME] | 0.3
 |  |  |  |  |  | C67G | 0.3
 |  |  |  |  |  | C67GJ | 0.3
Spreadsheet: 750820d1633654730-timesheet-functions-for-normal-hours-overtime-and-double-time-example-timesheet
Sheet: Sheet1

 |  | Start Date: | 2021-09-30 00:00:00 | End Date: | 2021-10-13 00:00:00 |  |  |  |  | Office Use only
Day | Date | Job Number/Client | Start Time | Finish 24hr | [NAME] | Living Away | On Call | Call Outs | Total Hours | Normal | 1.5 x (First 2hrs) | 2 x Hrs | Notes
Thursday | 2021-09-30 00:00:00 | 123456 | 06:00:00 | 10:00:00 | 0.5 | 0 | 0 |  | 3.5
 |  | 789123 | 10:00:00 | 12:00:00 | 0 | 0 | 0 |  | 2
 |  | 456789 | 12:00:00 | 15:00:00 | 0 | 0 | 0 |  | 3
 |  | 123455 | 15:00:00 | 18:00:00 | 0 | 0 | 0 |  | 3
 |  |  |  |  | 0 | 0 | 0 |  | 11.5
Friday | 2021-10-01 00:00:00 | 123456 | 06:00:00 | 10:00:00 | 0 | 0 | 0 |  | 4
 |  | 789123 | 10:00:00 | 12:00:00 | 0 | 0 | 0 |  | 2
 |  | 456789 | 12:00:00 | 15:00:00 | 0 | 0 | 0 |  | 3
 |  | 123455 | 15:00:00 | 18:00:00 | 0 | 0 | 0 |  | 3
 |  |  |  |  | 0 | 0 | 0 |  | 12
Saturday | 2021-10-02 00:00:00 |  | 00:00:00 | 00:00:00 | 0 | 0 | 0 |  | 0
Sunday | 2021-10-03 00:00:00 |  | 00:00:00 | 00:00:00 | 0 | 0 | 0 |  | 0
 |  |  |  |  | 0 | 0 | 0
Monday | 2021-10-04 00:00:00 | 123456 | 06:00:00 | 10:00:00 | 0 | 0 | 0 |  | 4
 |  | 789123 | 10:00:00 | 12:00:00 | 0 | 0 | 0 |  | 2
 |  | 456789 | 12:00:00 | 15:00:00 | 0 | 0 | 0 |  | 3
 |  | 123455 | 15:00:00 | 18:00:00 | 0 | 0 | 0 |  | 3
 |  |  |  |  | 0 | 0 | 0 |  | 12 | 8 | 2 | 2
Spreadsheet: 161810d1339629463-linking-cells-in-two-worksheets-in-the-same-workbook-figure-15-sales-forecast-and-market-share
Sheet: Market Share 2011-2012

MARKET SHARE |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | YEAR ENDING FEBRUARY 2012
FULL TITLE PROPERTY SALES - YEAR ENDING 29 FEBRUARY 2012
PROPERTY TYPE |  |  |  |  |  |  |  | NO.  OF UNITS SOLD |  |  |  |  |  | VALUE OF SALES |  |  |  |  |  | AVERAGE PRICE/UNIT |  |  |  |  |  | AVERAGE SIZE M² |  |  |  |  |  | AVERAGE PRICE /M²
RESIDENTIAL 1 STANDS |  |  |  |  |  |  |  | 13 |  |  |  |  |  | 4987800 |  |  |  |  |  |  |  |  |  |  |  | 486
RESIDENTIAL 2 STANDS |  |  |  |  |  |  |  | 1 |  |  |  |  |  | 1680000 |  |  |  |  |  |  |  |  |  |  |  | 4934
HOUSES |  |  |  |  |  |  |  | 6 |  |  |  |  |  | 11200000 |  |  |  |  |  |  |  |  |  |  |  | 300
TOWNHOUSES |  |  |  |  |  |  |  | 9 |  |  |  |  |  | 11435000 |  |  |  |  |  |  |  |  |  |  |  | 175
SECTIONAL TITLE PROPERTY SALES - YEAR ENDING 29 FEBRUARY 2012
PROPERTY TYPE |  |  |  |  |  |  |  | NO. OF UNITS SOLD |  |  |  |  |  | VALUE OF SALES |  |  |  |  |  | AVERAGE PRICE/UNIT |  |  |  |  |  | AVERAGE SIZE M² |  |  |  |  |  | AVERAGE PRICE /M²
TOWNHOUSES |  |  |  |  |  |  |  | 1 |  |  |  |  |  | 1400000 |  |  |  |  |  |  |  |  |  |  |  | 208
CLUSTER HOMES |  |  |  |  |  |  |  | 6 |  |  |  |  |  | 11450000 |  |  |  |  |  |  |  |  |  |  |  | 280
APARTMENTS |  |  |  |  |  |  |  | 2 |  |  |  |  |  | 2330000 |  |  |  |  |  |  |  |  |  |  |  | 144
TOTAL AREA SALES : |  |  |  |  |  |  |  |  |  |  |  |  |  | TOTAL AGENT SALES : |  |  |  |  |  | 6858000 |  |  |  |  |  | (3) MARKET SHARE : |  |  |  |  |  |  |  |  |  |  | %
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | (3) MARKET SHARE = TOTAL AGENT SALES ÷ TOTAL AREA SALES %
Spreadsheet: 59998d1260527182-sending-data-from-input-sheet-to-other-sheets-in-a-workbook-poss-new-budget-planner
Sheet: Next Furnature

Next Furnature
Month | Year | Paymet
January | 2008
February | 2008
March | 2008
April | 2008
May | 2008
June | 2008
July | 2008
August | 2008
September | 2008
October | 2008
November | 2008
December | 2008
January | 2009
February | 2009
March | 2009 | 19.65
April | 2009 | 19.65
May | 2009 | 19.65
June | 2009 | 19.65
July | 2009 | 19.65
August | 2009 | 19.65
September | 2009 | 19.65
October | 2009 | 19.65
November | 2009
December | 2009
January | 2010
February | 2010
March | 2010
April | 2010
May | 2010
June | 2010
July | 2010
August | 2010
September | 2010
October | 2010
November | 2010
December | 2010
Spreadsheet: 856529d1705741524-cross-reference-and-add-values-from-multiple-sheets-exceltestdata
Sheet: Master

Name | Qty
Name1 | 225 | <- Should = total of all 'Name1' from data sheets
[NAME] | 1734 | <- Should = total of all '[NAME]' from data sheets
Name3 | 111 | <- Should = total of all 'Name3' from data sheets
Name4 | 11 | <- Should = total of all 'Name4' from data sheets
Name5 | 72 | <- Should = total of all 'Name5' from data sheets
Name6 | -40 | <- Should = total of all 'Name6' from data sheets
 | 225
[NAME] | 1734
Name3 | 111
Name4 | 17
Name5 | 77
Name6 | -40
Spreadsheet: 862806d1710414250-lookinf-for-a-formula-to-compare-columns-ip-common-1-aligw
Sheet: Sheet1

IP1 | IP2 | IP3 | IP4
172.185.32.1 | 172.555.231.2 | 199.99.85.2 | 166.896.12.1 |  |  |  |  | False
199.258.2.1 | 144.254.32.25 | 198.87.65.2 | 123.454.65.8 |  |  |  | 136.258.35.2 | False
199.257.5.2 | 199.99.85.2 | 172.555.231.2 | 136.258.35.2 |  |  |  | 144.254.32.25 | True
166.896.12.1 | 172.185.32.1 | 144.254.32.25 | 172.555.231.2 |  |  |  | 166.896.12.1 | True
 |  |  | 172.185.32.1 |  |  |  | 172.185.32.1 | True
 |  |  |  |  |  |  | 172.555.231.2 | True
 |  |  |  |  |  |  | 198.87.65.2 | False
 |  |  |  |  |  |  | 199.257.5.2 | False
 |  |  |  |  |  |  | 199.258.2.1 | False
 |  |  |  |  |  |  | 199.99.85.2 | True
Spreadsheet: 71759d1272487481-comparing-two-columns-to-create-column-with-duplicates-book5
Sheet: Sheet1

Col1 | Col2
[NAME] | [NAME] | 1 | 4 | [NAME]
Mark | [NAME] |  |  | [NAME]
[NAME] | [NAME] |  |  | [NAME]
[NAME] | Marge |  |  | Vito
[NAME] | [NAME] | 2
[NAME] | [NAME] | 3
[NAME] | [NAME]
Vito | Lester
[NAME] | [NAME]
 | Vito | 4
Spreadsheet: 109891d1306710424-monthly-rollup-of-data-5-27-11
Sheet: GWG(DO NOT ENTER INFO)

DATE | P |  |  |  |  |  | PLANT
 | L | Propane | Propane | Butane | Butane | Sulfur | Sulfur | Gasoline | Condensate | Inlet | Plant | Mobile | Acid | Inlet |  | N2 | High | Field
 | A | Prod. | Delivered | Prod. | Delivered | Prod. | [NAME] | Prod. | Sales | Gas | Inj. Discharge | Sales Gas | Gas | Sulfur | Dupont | Vent | Press. Fuel | Fuel | Flare | Shrinkage | GWG
 | N | (gals) | (bbls) | (gals) | (bbls) | (L-ton) | (L-ton) | (gals) | (bbls) | (mcfd) | (mcfd) | (mcfd) | (mcfd) | (ltpd) | (lb/hr) | (mcfd) | (mcfd) | (mcfd) | (mcfd)
 | 130282
2011-05-27 00:00:00 |  | 14864 | 0 | 8147 | 0 | 0 | 0 | 8022 | 0 | 17702 | 5517 | 5878 | 349 | 0 | 0 | 1231 | 1978 | 266 | 256 | 999.9664809999999 | 9460.966481
 | O
 | N
 |  |  |  |  |  |  |  |  |  |  |  | 5878 |  |  |  | 1231 | 1978
Spreadsheet: 66612d1267228355-multiple-page-layout-in-worksheet-print
Sheet: Sheet3

ccccc | ccccc | ccccc | ccccc | ccccc | ccccc | ccccc | ccccc
ccccc | ccccc | ccccc | ccccc | ccccc | ccccc | ccccc | ccccc
ccccc | ccccc | ccccc | ccccc | ccccc | ccccc | ccccc | ccccc
ccccc | ccccc | ccccc | ccccc | ccccc | ccccc | ccccc | ccccc
ccccc | ccccc | ccccc | ccccc | ccccc | ccccc | ccccc | ccccc
ccccc | ccccc | ccccc | ccccc | ccccc | ccccc | ccccc | ccccc
ccccc | ccccc | ccccc | ccccc | ccccc | ccccc | ccccc | ccccc
ccccc | ccccc | ccccc | ccccc | ccccc | ccccc | ccccc | ccccc
ccccc | ccccc | ccccc | ccccc | ccccc | ccccc | ccccc | ccccc
ccccc | ccccc | ccccc | ccccc | ccccc | ccccc | ccccc | ccccc
ccccc | ccccc | ccccc | ccccc | ccccc | ccccc | ccccc | ccccc
ccccc | ccccc | ccccc | ccccc | ccccc | ccccc | ccccc | ccccc
ccccc | ccccc | ccccc | ccccc | ccccc | ccccc | ccccc | ccccc
ccccc | ccccc | ccccc | ccccc | ccccc | ccccc | ccccc | ccccc
ccccc | ccccc | ccccc | ccccc | ccccc | ccccc | ccccc | ccccc
ccccc | ccccc | ccccc | ccccc | ccccc | ccccc | ccccc | ccccc
ccccc | ccccc | ccccc | ccccc | ccccc | ccccc | ccccc | ccccc
ccccc | ccccc | ccccc | ccccc | ccccc | ccccc | ccccc | ccccc
ccccc | ccccc | ccccc | ccccc | ccccc | ccccc | ccccc | ccccc
Spreadsheet: 30281d1225736781-duplicates-and-consolidation-sumif2
Sheet: Sheet1

Product      Price 1    Price 2     Price 3
ball | 1 | 2 | 3
bat | 2 | 4 | 6
ball | 8 | 5 | 5
hat | 4 | 7 | 8
glove | 9 | 12 | 18
glove | 6 | 4 | 13
ball | 9 | 7 | 8
bat | 2 | 4 | 6 |  | Copy this whole chart,
hat | 4 | 7 | 8 |  | then PASTE SPECIAL > Values over itself
glove | 15 | 16 | 31 |  | to lock the data in. Now you can delete the
 |  |  |  |  | original data above, by removing the rows
Spreadsheet: 103666d1301404384-graph-automatic-update-chart
Sheet: Sheet1

 | Week | View | Sales | % Change | % to Target | Spend
 | 1 | 657812 | 1127 | 3.836909871244635 | 1.774213297416432 | 264.08
 | 2 | 743369 | 1234 | 0.09494232475598935 | 1.942661232486138 | 258.89
 | 3 | 824410 | 1405 | 0.1385737439222042 | 2.211863072644265 | 254.8499999999999
 | Grand Total | 7325362 | 15679 |  | 1.91979919186972 | 3277.680000000001
 | note:
 | I want to add a new row for week 4 and need to update the graph automatically
Spreadsheet: 679720d1590598285-matching-specific-words-in-text-string-to-column-header-sample-workbook-segregating-text
Sheet: Sheet1

 |  | Applications Out | In Process | Submitted | PreApproved TBD | Approved | Docs Out | Closed | Post Closing | Applications Out - Now Closed | Dormant | Cancelled | Leads
All Files/1. [NAME]'s loans with Jane/1.  Applications Out Loans/Sample1, Scott loan file/
All Files/1. [NAME]'s loans with Jane/1.  In Process Loans/Sample2, [NAME] loan file/
All Files/1. [NAME]'s loans with Jane/1.  Submitted Loans/Sample3, [NAME] loan file/
All Files/1. [NAME]'s loans with Jane/1.  PreApproved TBD Loans/Sample4, [NAME] loan file/
All Files/1. [NAME]'s loans with Jane/1.  [NAME]/Sample5, [NAME] loan file/
All Files/1. [NAME]'s loans with Jane/1.  Docs Out Loans/Sample6, Sam & Sample6a, [NAME] loan file/
All Files/1. [NAME]'s loans with Jane/1.  Closed Loans/Sample7, [NAME] loan file/
All Files/1. [NAME]'s loans with Jane/1.  Post Closing Loans/Sample8, Shay loan file/
All Files/1. [NAME]'s loans with Jane/1.  Applications Out - Now Closed Loans/Sample9, Timmy loan file/
All Files/1. [NAME]'s loans with Jane/1.  Dormant Loans/Sample10, [NAME] loan file/
All Files/1. [NAME]'s loans with Jane/1.  Cancelled Loans/Sample11, [NAME] loan file/
All Files/1. [NAME]'s loans with Jane/1.  [NAME], [NAME] loan file/
Spreadsheet: 126648d1319807471-calculate-a-due-date-cekidot
Sheet: OverHere!!!

 | Today =
 | Column1 | DATE 1 | NAME | AMOUNT | Given Due date | Given due date Range [Day(s)] | Settlement status | Formula 1 | Formula 2 | Formula 3 | Formula 4 | Formula 5 | Formula 6
 | ClickMe | 2011-10-28 00:00:00 | INCOME | 1000 | 2011-10-29 00:00:00 | 7 | NO
 | ClickMe | 2011-10-29 00:00:00 | INCOME | 1000 | 2011-10-26 00:00:00 | 8 | NO
 | ClickMe | 2011-10-28 00:00:00 | Expense | -200 | 2011-10-27 00:00:00 | 5 | [NAME]
 | ClickMe | 2011-10-26 00:00:00 | INCOME |  | 2011-10-28 00:00:00 | 15 | NO
 |  | 2011-11-01 00:00:00 | INCOME |  |  | 16 | [NAME]
 |  | 2011-10-27 00:00:00 | INCOME |  |  |  | NO
 |  | 2011-10-26 00:00:00 | INCOME |  |  |  | [NAME]
 |  | 2011-11-01 00:00:00 | INCOME |  |  |  | NO
 |  | 2011-11-07 00:00:00 | INCOME |  |  |  | NO
Spreadsheet: 2a42b82e-b2eb-4030-bbbd-3d3d98adb7c4
Sheet: 2.7 ounce ID Moment

Cost Model
If Westridge wants to make 'x' amount of 2.8 oz. bottle of ID Moments how long will it take and how much will it cost?
Input
Batch size (number of bottles) | 240
Output
Number of cases required
Overhead cost
Raw material cost
Labor cost
Total Cost
Revenue ($)
Profit ($)
 | Seconds per batch | Minutes per batch | Hours per batch
Time to complete (sec, min, hour)
Additional Output
Cost per individual step
 | Seconds per batch | Minutes per batch | Hours per batch
Set up cost ($)
Number of operators | 4
Time to set up (sec, min, hour)
Cost to label ($)
Number of operators | 2
Time to label (sec, min, hour)
Cost to fill ($)
Number of operators | 1
Time to fill (sec, min, hour)
Cost to cap ($)
Number of operators | 2
Time to cap (sec, min, hour)
Cost to wait ($)
number of operators | 1
time to wait
Cost to box ($)
Number of operators | 1
Time to box (sec, min, hour)
Total cost ($)
Total time (hours)
Variable Values
Factors included in cost model: |  | Sq. Feet | Rate
overhead (rent per month) |  | 1500 | 155
cost of raw materials per case
Average hourly wage (including taxes and benefits) | 10.52
Average employees working on 2.5 oz ID Millennium | 4
Allowance | 0.1
Time per step
 | Seconds per bottle | Seconds per case (24 bottles) | Fixed Time (sec)
Set up time  (sec)
Time to label  (sec)
Time to fill  (sec)
Time to cap  (sec)
Time to uncap  (sec) | 0
Time to recap  (sec) | 0
Time to box a case  (sec) | N/A
Wait time on conveyer  (sec) | 5
Time per step including allowances
 | Seconds per bottle | Seconds per case (24 bottles) | Fixed Time (sec)
Set up time  (sec)
Time to label  (sec)
Time to fill  (sec)
Time to cap  (sec)
Time to uncap  (sec)
Time to recap  (sec)
Time to box a case  (sec) | N/A
Wait time on conveyer  (sec)
Cost of a bottle of 2.5 oz Millenium ($) |  | 9.92
# in case |  | 24
Average number of bottles labeled per minute | 31.05
Average number of bottles filled per minute | 19.93
Average number of bottles placed on line per minute | 20.32
Average number of bottles uncapped per minute | 20.92
Average number of boxes filled per minute | 2
Cost of Raw Materials ($)
Back Label ($) | 0.02371
Front Label ($) | 0.02857
Bottle ($) | 0.09918
[NAME] ($) | 0.06585
Product ($) Includes waste and overfill | 0.5113
[NAME] ($) | 0.00595
[NAME] ($) one for each 24 bottles | 0.28
Spreadsheet: phillip_m_love__30649__9907_OA
Sheet: CE_GL

ENRON CAPITAL & TRADE RESOURCES
OPERATIONAL ANALYSIS - ACTUALS
COMPANY:  ECTR (EGM)
REGION:  CENTRAL
 |  |  | Total |  | Reclasses |  | July |  | Aug |  | September |  | October |  | November |  | December |  | January |  | February |  | March |  | April |  | ENTER MONTH |  | ENTER MONTH
 |  |  | Volume | $'s | Volume | $'s | Volume | $'s | Volume | $'s | Volume | $'s | Volume | $'s | Volume | $'s | Volume | $'s | Volume | $'s | Volume | $'s | Volume | $'s | Volume | $'s | Volume | $'s | Volume | $'s
 | Sales:
1 |  | 3rd Party / Inter Enron
2 |  | Liquidations
3 |  | Interdesk
4 |  | Option Premiums
5 |  | Dmd Reimbursements
 | Total Sales:
 | Purchases:
6 |  | 3rd Party / Inter Enron
7 |  | Liquidations
8 |  | Interdesk
9 |  | Option Premiums
10 |  | [NAME]
 | Total Purchases:
 | Intra CTS (EGM / HPL / LRC):
11 |  | Sales
12 |  | Purchases
 | Total Intra CTS Sales / Purchases
 | Imbalances:
13 |  | In Kind
14 |  | Cash Out
15 |  | Cash In
16 |  | Synthetic Storage
 | Total Imbalances:
 | Storage:
17 |  | Injection (Sales to Stg)
18 |  | W/D (Purchase from Stg)
19 |  | Inventory Profit
 |  | Total W/D
 | Total Storage:
20 | Linepack:
21 | Shrinkage:
22 | UA4:
23 | Fuel:
 | Transport Expense:
24 |  | Commodity
25 |  | Demand
 | Total Transport Expense:
 | Transport Revenue:
26 |  | Interstate
27 |  | Intrastate
 | Total Transport Revenue:
 | Intra CTS (EGM / HPL / LRC):
28 |  | Transport Expense
29 |  | Transport Revenue
 | Total Intra CTS Transport
 | Tie Out Schedule Items:
 |  | MTM Income:
30 |  | Current Gross Book Balance
31 |  | Prior Month Book Balance
 |  | Total MTM Income
32 |  | Prudency
33 |  | Financial Liquidations |  |  |  |  |  |  |  | 0 |  |  |  | 109021.76
34 |  | Originations
35 |  | Broker Fees
36 |  | Asset Group Demand Charges
37 |  | [NAME]
38 |  | Interdesk Charges
39 |  | Canada
40 |  | Miscellaneous
 |  | TOTAL
Spreadsheet: 764249d1642662661-index-required-by-matching-two-columns-index-with-match-two-columns
Sheet: Sheet1

Category | Grade | Slab |  |  |  |  | Category | Grade | Slab
Category-A | Outstanding | 0.15 |  |  |  |  | Category-A |  | 0.15
Category-A | Very Good | 0.12 |  |  |  |  | Category-A |  | 0.12
Category-B | Outstanding | 0.12 |  |  |  |  | Category-B |  | 0.12
Category-B | Very Good | 0.096 |  |  |  |  | Category-B |  | 0.096
Category-C | Outstanding | 0.1 |  |  |  |  | Category-C |  | 0.1
Category-C | Average | 0.04 |  |  |  |  | Category-C |  | 0.04
Category-D | Outstanding | 0.08 |  |  |  |  | Category-D |  | 0.08
Category-D | Below Average | 0 |  |  |  |  | Category-D |  | 0
 |  |  |  |  |  |  |  | I tried and failed 😫
 |  |  |  |  |  |  | Category | Slab | Grade.1
 |  |  |  |  |  |  | Category-A | 0.15 | Outstanding
 |  |  |  |  |  |  | Category-A | 0.12 | Very Good
 |  |  |  |  |  |  | Category-B | 0.12 | Outstanding
 |  |  |  |  |  |  | Category-B | 0.096 | Very Good
 |  |  |  |  |  |  | Category-C | 0.1 | Outstanding
 |  |  |  |  |  |  | Category-C | 0.04 | Average
 |  |  |  |  |  |  | Category-D | 0.08 | Outstanding
 |  |  |  |  |  |  | Category-D | 0 | Below Average
Spreadsheet: 728885d1618763814-count-duplicate-values-if-they-appear-in-the-same-month-example-1-1-
Sheet: Sheet1

Customer Email Address |  |  | Date |  |  |  |  | Multiple Subscription
Email Address T |  |  | 2020-12-01 00:00:00
Email Address T |  |  | 2020-12-04 00:00:00
Email Address T |  |  | 2020-12-25 00:00:00
Email Address T |  |  | 2021-01-08 00:00:00
Email Address V |  |  | 2021-01-28 00:00:00
[NAME] |  |  | 2021-02-12 00:00:00
Email Address X |  |  | 2021-01-16 00:00:00
Email Address Y |  |  | 2021-02-05 00:00:00
Email Address Y |  |  | 2021-02-12 00:00:00
Email Address Z |  |  | 2021-01-06 00:00:00
Email Address Z |  |  | 06/02/20201
Spreadsheet: 272645d1382452311-vlookup-help-please-best-light-images
Sheet: SALES

DATE | CATEGORY | [NAME] | PRICE SOLD
2013-09-01 00:00:00 | A6 Cards | Duke Of Portland | 2.5
2013-09-02 00:00:00 | A6 Cards | Duke Of Portland | 2.5
2013-09-03 00:00:00 | A6 Cards | Duke Of Portland | 2.5
2013-09-04 00:00:00 | A6 Cards | Duke Of Portland | 2.5
2013-09-05 00:00:00 | A6 Cards | Duke Of Portland | 2.5
2013-09-06 00:00:00 | A6 Cards | Duke Of Portland | 2.5
2013-09-07 00:00:00 | A6 Cards | Duke Of Portland | 2.5
2013-09-08 00:00:00 | A6 Cards | Duke Of Portland | 2.5
2013-09-09 00:00:00 | A6 Cards | Duke Of Portland | 2.5
Spreadsheet: 6f88567e-f5d5-4d4f-9f8e-4dbe1e3b535d
Sheet: Expenses

FUNDRAISING EVENT - RELATED EXPENSES/COSTS
*Please enter expense information in peach cells for all event costs incurred in the current fiscal year. For donated items/prizes, list item followed by "DONATED" in description column, donor name in vendor name and $0 in amount paid.
 | Non-cash prizes |  |  |  | Rent/facility costs
 | Description | Vendor | Amount Paid |  | Description | Vendor | Amount Paid
1 |  |  |  | 1
2 |  |  |  | 2
3 |  |  |  | 3
4 |  |  |  | 4
5 |  |  |  | 5
 | Other direct expenses
 | Description | Vendor | Amount Paid
1
2
3
4
5
 |  |  |  |  |  | Total Cash Prizes | 0
 |  |  |  |  |  | Total Exp Before Sales Tax
 |  |  |  |  |  | Total Sales Tax
 |  |  |  |  |  | Total Expenses
Spreadsheet: 673867d1587571860-time-between-duplicates-time-between-duplicates-etaf2
Sheet: Sheet1

Branch | Date | Time | Amount | Processing Date | Name | Reference | Code | Duplicate | Time Between Duplicates
Poole | 2020-01-10 00:00:00 | 01:00:00 | 725 | 2020-01-11 00:00:00 | [NAME] | 123 | AA01
Poole | 2020-01-10 00:00:00 | 07:04:00 | 324.84 | 2020-01-12 00:00:00 | [NAME] | 834 | AB09
Bournemouth | 2020-02-11 00:00:00 | 10:33:00 | 500 | 2020-01-12 00:00:00 | [NAME] | 176 | AB08
Poole | 2020-01-10 00:00:00 | 02:00:00 | 725 | 2020-01-11 00:00:00 | [NAME] | 124 | AA01
Bournemouth | 2020-01-10 00:00:00 | 06:20:00 | 70 | 2020-01-11 00:00:00 | [NAME] | 234 | AC11
Christchurch | 2020-01-10 00:00:00 | 09:54:00 | 190.83 | 2020-01-12 00:00:00 | [NAME] | 529 | BR87
Christchurch | 2020-02-11 00:00:00 | 12:31:00 | 201 | 2020-01-12 00:00:00 | [NAME] | 179 | BR90
Christchurch | 2020-01-10 00:00:00 | 19:43:00 | 398 | 2020-01-11 00:00:00 | [NAME] | 200 | AA03
Bournemouth | 2020-02-11 00:00:00 | 12:31:00 | 500 | 2020-01-12 00:00:00 | [NAME] | 176 | AB08
Poole | 2020-01-10 00:00:00 | 04:00:00 | 725 | 2020-01-11 00:00:00 | [NAME] | 125 | AA01