tianzl66/Sheetpedia huggingface dataset:
Spreadsheet: 0a8791de-84e4-4eb4-bfac-22483612972b
Sheet: Business Certificate 3

BUSINESS
Certificates
Students Name:
ID #
General Business
___ [NAME] (3) introduction to Business
___ CIT 105 (3) Introduction to Computers OR ___ OST 105 (3) Intro to Information Systems
___ ACT 101 (3) Fundamentals of Accounting (ACC 201 may be substituted)
___ ECO 101 (3) Contemporary Economic Issues
OR ___ ECO 201 (3) Principles of Microeconomics
OR ___ ECO 202 (3) Principles of Macroeconomics
Hospitality Management
Required
___ HOS 100 (3) Introduction to Hospitality
___ CUL 100 (3) Culinary Arts Profession
___ HOS 282 (3) Tourism Marketing
Choose 9 hours from the following Technical Courses.  Students may select other courses (HOS or CUL) as
approved by the Business Administration Systems Program Coordinator.
___ [NAME] (3) Small Business Management
___ [NAME] (3) Human Resource Management
___ COE 199 (1-3) Cooperative Education: Business Administration
OR ___ [NAME] (1-3) Business Internship
OR ___ [NAME] (1-3) Management, Ethics and Society
___ CUL 200 (2) Sanitation & Safety
___ CUL 105 (2) Applied Fundamentals of the Culinary Arts Profession
___ CUL 280 (3) Cost & Control
___ HOS 160 (3) Security for the Hospitality Industry
___ HOS 200 (3) Cultural Heritage Tourism
___ HOS 210 (3) Front Office Operations & Management
___ HOS 220 (3) Housekeeping & Maintenance Management
___ CUL 270 (3) Human Relations Management
Leadership
Required
___ [NAME] (3) Personal and Organizational Leadership
___ [NAME] (3) Introductin to Business
___ ECO 101 (3) Contemporary Economic Issues
OR ___ ECO 201 (3) Principles of Microeconomics
OR ___ ECO 202 (3) Principles of Macroeconomics
___ COM 181 (3) Basic Public speaking
OR ___ COM 252 (3) Introduction to Interpersonal Communication
Southeast Kentucky Community & Technical College | Updated Spring 2013
Spreadsheet: 36966d1234907915-how-do-i-perform-an-array-multiplication-if-a-cell-contains-a-specific-text-string-sample
Sheet: Sheet1

DATA
[NAME] | [SPREAD] | [SIZE]
[NAME],C,MS,BARC | 6.5 | 333
JPM,[NAME],MS | 4 | 1500
MS | 1 | 400
MS,JPM,GS,C | 5.5 | 750
GS,[NAME],BARC | 6 | 2000
LLYD,JPM,MS | 2 | 2200
DESIRED RESULTS
BARC | 14164.5
[NAME] | 20164.5
C | 6289.5
GS | 16125
JPM | 14525
LLYD | 4400
MS | 17089.5
Spreadsheet: 858724d1707303434-to-map-old-code-to-new-code-base-on-date-sum-if-lookup-with-date-criteria-1-1-
Sheet: Sheet1

Code | Tag | WEF |  |  | 2023-11-30 00:00:00 | 2023-12-31 00:00:00 | 2024-01-31 00:00:00 | 2024-02-29 00:00:00 | 2024-03-31 00:00:00 | 2024-04-30 00:00:00 |  |  | 2023-11-30 00:00:00 | 2023-12-31 00:00:00 | 2024-01-31 00:00:00 | 2024-02-29 00:00:00 | 2024-03-31 00:00:00 | 2024-04-30 00:00:00
300500 | 7000 | 2000-01-01 00:00:00 |  | 300500 | 50000 | 50000 | 50000 | 50000 | 50000 | 50000 |  | 7000 | 50000
300500 | 8000 | 2023-12-31 00:00:00 |  | 300501 | 12500 | 12500 | 12500 | 11000 | 11000 | 11000 |  | 8000 |  | 50000 | 50000
300501 | 5000 | 2000-01-01 00:00:00 |  |  |  |  |  |  |  |  |  | 9000 |  |  |  | 50000 | 50000 | 50000
300501 | 5500 | 2024-01-31 00:00:00 |  |  |  |  |  |  |  |  |  | 5000 | 12500 | 12500
300500 | 9000 | 2024-02-29 00:00:00 |  |  |  |  |  |  |  |  |  | 5500 |  |  | 12500 | 11000 | 11000 | 11000
 |  |  |  | This is my Old Mapping |  |  |  |  |  |  |  | This is new Mapping
 |  |  |  |  |  |  |  |  |  |  |  | * How do I pas on A:C and do up M:S base on E:K?
 |  |  |  |  |  |  |  |  |  |  |  | Column A is Old Mapping
 |  |  |  |  |  |  |  |  |  |  |  | Column B is New Tagging
 |  |  |  |  |  |  |  |  |  |  |  | Column C is when the New Tagging take place
Spreadsheet: 43923d1242583680-creating-a-list-from-across-sheets-problem-2
Sheet: DEL 1

 | Month: |  |  | Year:
Date of | [NAME] of | Regular | Super | Plus | Diesel | Date of | [NAME] of | Regular | Super | Plus | Diesel
Loads | Lading # |  |  |  |  | Loads | Lading #
1 | 20991 | 6827
1 | 0074 | 5000 | 2500
1 | 21030 | 5601 |  |  | 1005
2 | 99870 | 3798 | 1200 | 2903
2 | 21095 | 8699
3 | 564414 | 6003 | 2500
3 | 21182 | 6002 | 2002
3 | 21205 | 5650 | 1903 | 1150
3 | 21218 | 6500 | 806 | 806
4 | 21282 | 8703
Subtotals |  | 62783 | 10911 | 4859 | 1005 | Subtotals |  | 0 | 0 | 0 | 0
4 | 21333 | 2000
Subtotals |  | 2000 | 0 | 0 | 0 | Subtotals |  | 0 | 0 | 0 | 0
Subtotals |  | 0 | 0 | 0 | 0 | Subtotals |  | 0 | 0 | 0 | 0
Subtotals |  | 0 | 0 | 0 | 0 | Subtotals |  | 0 | 0 | 0 | 0
Total | Regular | 64783 | Total | Super | 10911 | Total | Plus | 4859 | Total | Diesel | 1005
Spreadsheet: 167100d1341901330-filtering-one-specific-name-in-excel-2010-copy-of-morning-attendance-2-
Sheet: 5 March 2012

Daily Morning Staff |  |  |  |  | Monday
 | 07:30-14:30 |  | 2012-03-05 00:00:00
Name | Staff No. | Title | Time In | Out | Locations | Remarks
Naima Mohamed | 2166 | Client Ralation Supervisor | 07:30:00 | 14:30:00 | EFS
Sheikha [NAME] | 2120 | Reservation Officer | 07:30:00 | 14:30:00 | TOPS
Syed Sultan | 2888 | Supervisor | 07:30:00 | 14:30:00 | EFS
[NAME] | 4143 | Aircraft Team Leader | 07:30:00 | 14:30:00 | EFS
Jalil Nushadi | 1889 | Driver | 05:45:00 | 14:30:00 | EFS
[NAME] | 624 | Driver | 07:30:00 | 14:30:00 | EFS
Soud Sharar | 2097 | [NAME] Officer | 07:30:00 | 14:30:00 | [NAME]
[NAME] | 1897 | Manager | 07:30:00 | 14:30:00 | EFS | Sick leave
[NAME] | 4440 | Attendant | 07:30:00 | 14:30:00 | EFS
[NAME] | 1861 | Duty Officer | 07:30:00 | 14:30:00 | EFS
Spreadsheet: 89934d1289682190-changing-rows-to-columns-rows-to-columns
Sheet: Sheet1

FIG 1
TITLE | INITIALS | SURNAME | PERSNO | ELEMENTNAME | OLDAMOUNT | New Amount
Mrs | L | Scully | P2274 | Pre 97 Excess | 439.44 | 539.44
Mrs | L | Scully | P2274 | Post 88 GMP | 223.6 | 323.6
Mrs | L | Scully | P2274 | Post 97 Excess | 641.16 | 741.16
Mrs | S | [NAME] | P6175 | Pre 97 Excess | 2324.01 | 2424.01
Mrs | S | [NAME] | P6175 | Post 88 GMP | 609.44 | 709.44
Mrs | S | [NAME] | P6175 | Post 97 Excess | 1087.5 | 1187.5
Mrs | R | [NAME] | P6178 | Pre 97 Excess | 4912.49 | 5012.49
Mrs | R | [NAME] | P6178 | Pre 88 GMP | 1342.64 | 1442.64
Mrs | R | [NAME] | P6178 | Post 88 GMP | 2017.08 | 2117.08
FIG 2
TITLE | INITIALS | SURNAME | PERSNO | Pre 97 Excess | Post 88 GMP | Post 97 Excess | Pre 88 GMP | Pre 97 Excess | Post 88 GMP | Post 97 Excess | Pre 88 GMP
Mrs | L | Scully | P2274 | 439.44 | 223.6 | 641.16 |  | 539.44 | 323.6 | 741.16
Mrs | S | [NAME] | P6175 | 2324.01 | 609.44 | 1087.5 |  | 2424.01 | 709.44 | 1187.5
Mrs | R | [NAME] | P6178 | 4912.49 | 2017.08 |  | 1342.64 | 5012.49 | 2117.08 |  | 1442.64
Spreadsheet: 71475d1272217281-excel-2007-two-pivot-table-queries-how-to-add-a-cumulative-column-and-a-data-sort-query-cum-column-and-data-sort-query
Sheet: Pivot

Row Labels | Sum of £
2009/1 | 1644481.722239753
2009/10 | 2351568.917131228
2009/11 | 2244425.369599727
2009/12 | 1213182.3709102
2009/2 | 1504414.859426825
2009/3 | 1944232.2245984
2009/4 | 1103421.239076966
2009/5 | 1959383.498760629
2009/6 | 1828743.441150289
2009/7 | 1097578.562382243
2009/8 | 2415689.308712553
2009/9 | 2200469.36567962
Grand Total | 21507590.87966844
Spreadsheet: 143886d1330617991-maxa-if-formula-needed-excel-help
Sheet: Sheet1

2004FOXYes
I am trying to find anything that matches [NAME] in A8-A104. Once I find all the market shares for that, I want the single MAX value of column B. All of this needs to be in 1 full Maxa/if equation. I cannot do a vlookup then asking for [NAME] of those results.
Array | % OF Market
2004NBCFALSE | 0.26
2004CBSFALSE | 0.153
2004ABCFALSE | 0.156
2004FOXFALSE | 0.125
2004MyFALSE | 0.02300000000000001
2004CWFALSE | 0.011
2004INDFALSE | 0.001999999999999998
2004IONFALSE | 0.07100000000000001
2004ColFALSE | 0.03
2004TCNFALSE | 0.015
2004NBCFALSE | 0.115
2004FOXFALSE | 0.143
2004INDFALSE | 0.144
2004ABCFALSE | 0.044
2004CBSFALSE | 0.072
2004MyFALSE | 0.066
2004CWFALSE | 0.016
2004UNIFALSE | 0.031
2004FALSE | 0
2004INDFALSE | 0.067
2004IONFALSE | 0.02
2004TLFFALSE | 0.013
2004FALSE | 0.079
2004TELFALSE | 0.03
2004FALSE | 0.015
2004MeFALSE | 0.08
2004RTVFALSE | 0.03
2004FALSE | 0.015
2004FOXYes | 0.166
2004NBCYes | 0.196
2004ABCYes | 0.169
2004CBSYes | 0.077
2004MyYes | 0.085
2004CWYes | 0.03700000000000001
2004Yes | 0.066
2004Yes | 0.026
2004Yes | 0.013
2004Yes | 0.079
2004MeYes | 0.03
2004ThsYes | 0.015
2004RELYes | 0.08
2004Yes | 0.03
2004Yes | 0.015
2004FOXYes | 0.104
2004CBSYes | 0.113
2004NBCYes | 0.124
2004ABCYes | 0.051
2004UNIYes | 0.086
2004CWYes | 0.083
2004TELYes | 0.001999999999999988
2004MyYes | 0.03700000000000001
2004IONYes | 0.006999999999999999
2004TLFYes | 0.07300000000000001
2004Yes | 0.03
2004INSYes | 0.015
2004MGAYes | 0.08
2004AZTYes | 0.03
2004Yes | 0.015
2004LATYes | 0.08
2004NBCYes | 0.3179999999999999
2004CBSYes | 0.146
2004ABCYes | 0.05600000000000001
2004FOXYes | 0.102
2004CWYes | 0.094
2004MyYes | 0.009000000000000008
2004UNIYes | 0.006999999999999999
2004Yes | 0.005999999999999998
2004Yes | 0.075
2004Yes | 0.027
2004Yes | 0.015
2004TELYes | 0.08
2004Yes | 0.03
2004NBCYes | 0.207
2004CBSYes | 0.117
2004FOXYes | 0.153
2004ABCYes | 0.149
2004MyYes | 0.015
2004CWYes | 0.05
2004UNIYes | 0.026
2004IONYes | 0.069
2004Yes | 0.023
2004LWNYes | 0.015
2004ThsYes | 0.08
2004TLFYes | 0.03
2004ABCYes | 0.225
2004NBCYes | 0.143
2004CBSYes | 0.153
2004FOXYes | 0.116
2004CWYes | 0.04300000000000001
2004MyYes | 0
2004INDYes | 0.012
2004UNIYes | 0.056
2004IONYes | 0.018
2004TLFYes | 0.012
2004Yes | 0.08
2004ThsYes | 0.03
2005FOXYes | 0.785
Spreadsheet: 70658d1271358941-npv-vs-manual-npv-npv
Sheet: Sheet1

 |  |  |  |  | 1 | 2 | 3 | 4 | 5 | 6 | 7 | 8 | 9 | 10
 | Rent | 6.5 |  |  | 6.5 | 6.63 | 6.7626 | 6.897852 | 7.03580904 | 7.1765252208 | 7.320055725216 | 7.46645683972032 | 7.615785976514727 | 85.44911865649523
 | Yield | 0.1
 | Index | 0.02
 | Disc | 0.12
 | Value | 65
 | NPV | 64.4997758309517
 |  | 0.5002241690482947
Spreadsheet: 785175d1656228867-consolidate-sheets-into-one-master-book1
Sheet: Consolidated

 |  | Sheet 1 and sheet 2 consolidated into this tab like this:
 |  | Also to put into age descending order automatically if possible |  |  |  | First Name | Sir [NAME] | Age | Start Date | Finish Date
 |  |  |  |  |  | [NAME] | Smith | 66 | 1999-01-01 00:00:00 | 2020-06-07 00:00:00
 |  |  |  |  |  | [NAME] | Wayne | 68 | 2010-11-07 00:00:00 | 2021-08-01 00:00:00
 |  |  |  |  |  | Elvis | Presley | 71 | 1998-05-04 00:00:00 | 2005-11-15 00:00:00
 |  |  |  |  |  | [NAME] | Travolta | 51 | 1999-01-01 00:00:00 | 2020-06-07 00:00:00
 |  |  |  |  |  | [NAME] | [NAME] | 68 | 2010-11-07 00:00:00 | 2021-08-01 00:00:00
 |  |  |  |  |  | Elvis | Presley | 71 | 1998-05-04 00:00:00 | 2005-11-15 00:00:00
 |  |  |  |  |  | [NAME] | [NAME] | 75 | 2000-12-15 00:00:00 | 2006-03-03 00:00:00
 |  |  |  |  |  | Ringo | [NAME] | 73 | 1988-09-10 00:00:00 | 2004-07-15 00:00:00
Spreadsheet: 875671d1722282005-complex-let-vstack-filter-sort-choosecols-formula-example-004
Sheet: HybridDays

 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | Calcs  >>
Period
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | Change of Days Worked Calc
A | B | C | D | E | F | G | H | I | J | K | L | M | N | O | P |  | Change to Days Worked | Old Days Worked | New Days Worked | Date of Change |  | Fractional Month? | Fractional Months | Rate | RVU Threshold | Adj. [NAME] | Total Adj. Days Worked | Changed days worked ratio | Adj. [NAME] | Period RVU less Adj. [NAME] | Adj. Bonus
Bhama, [NAME] | NP | Active | 3 | 6 | 20 | Yes | WA | Yes |  | 2024-02-29 00:00:00 |  | HybridDays | 187.5 | 233.9800000000003 | 697.2
Alphonse, [NAME] | PA | Active | 1 | 3 | 20 | Yes | WA | Yes |  | 2023-02-27 00:00:00 |  | HybridDays | 93.75 | 85.78000000000016 | 0
Spreadsheet: 155904d1337099426-excel-2007-help-with-comparing-cells-examplesheet2
Sheet: Sheet1

A |  | 1 | 3 | 2 | 3
B |  | 4 | 6 | 1 | 6
C |  | 3 | 5 | 3 | 1
A |  | 2 | 2 | 6 | 5
B |  | 6 | 1 | 4 | 4
C |  | 5 | 4 | 5 | 2
Spreadsheet: 00b1ceb6-866d-43a5-9f36-4fbf8b127fe4
Sheet: 10b

Product | EUR** | GBP | [NAME] | USD | TOTAL
Basis*
FRA
IRS- [NAME]
OIS
VNS
Zero Coupon
TOTAL | N/A*** | N/A | N/A | N/A | N/A
Estimated net notional amount outstanding, December 7 weekly snapshot, by product type and supermajor currency (millions of USD), cleared swaps only, all participant types and tenors.
Total(s) may be less than total shown for this asset class in the All Swaps reports and/or other CFTC Swaps Report tables if products were excluded from this table that (a) presented disclosure risk or (b) did not belong in the categories shown. See Explanatory Notes for more detail.
*See Data Dictionary for product descriptions.
**See Explanatory Notes for currency descriptions.
***N/A indicates that data are not currently available.
The Commission requests feedback on the format and content of this CFTC Swaps Report table. Submit comments to [EMAIL].
Spreadsheet: louise_kitchen__24119__North America Plan 12-27
Sheet: Competitive Ana

 | 2002 Plan
 |  | 2001-09-01 00:00:00 |  | 2001 | 2002 |  |  |  | Per HC | New HC | Adj Comp |  |  | 2002
 |  | YTD Actual |  | Forecast | Plan |  |  |  |  |  |  |  |  | Plan
ENACOMP | Compensation
 | Special Pays | 0 |  |  |  |  |  | Compensation | 0
 | Analysts & Associates | 0
ENABENTX | Benefits & Payroll Taxes
ENAEMPEX | Employee Expense |  |  |  |  |  |  | Other
ENAT&EEX | Travel & Entertainment Expense
ENAOUTSV | Outside Services |  |  |  |  |  |  | Total
ENASUPP | Supplies Expense
ENAMKTEX | Marketing
ENACONTR | Charitable Contributions |  |  |  |  |  |  | [NAME]
ENARENT | Rent |  |  |  |  |  |  | Admins | 48000 | 0
ENATECH | Technology |  |  |  |  |  |  | Staff | 49200 | 0
ENATRANS | Transportation |  |  |  |  |  |  | Analysts | 57600 | 0
ENAOTHEX | Other Expenses |  |  |  |  |  |  | Associate | 72000 | 0
ENATAXES | Taxes Other than Income |  |  |  |  |  |  | Specialist | 62400 | 0
ENATOTDR | Total Direct Expenses |  |  |  |  |  |  | Sr Specialst | 74400 | 0
 |  |  |  |  |  |  |  | Managers | 90000 | 1
 | Headcount |  |  | 28 |  |  |  | Directors | 120000 | 2
 |  |  |  |  |  |  |  | General Counsel Asst | 178800 | 0
 | Analysts & Associate Headcount |  |  | 0 | 0 |  |  | Vice President | 216000 | 0
 |  |  |  |  |  |  |  | [NAME] | 312000
 | Total Headcount |  |  |  |  |  |  |  |  |  |  |  |  | 1
ENAOUTLG | Outside Legal |  |  |  |  |  |  | Benefits & Taxes |  |  | 0.2
ENAOUTTX | Outside Tax
ENAINSUR | Insurance
ENASYSDV | System Development
ENACORIT | Controllable Infrastructure
ENACORRN | Corporate Rent
ENAOTHAL | Other Allocated Direct  Expenses |  |  |  |  | Other Expense Calculation
ENADEPR | Depreciation & Amortization
 | Outside Services | 1140923 |  |  |  | Total Misc Exp |  | Old HC | Exp/Old HC | New HC | Exp/New HC
Spreadsheet: 131031d1322697089-vlookup-copy-of-december
Sheet: 18

 |  |  |  | 2011-12-18 00:00:00
Newspaper | Price | Quantity | Total
Value | 1.1 |  | 0
Value1 | 0.98 |  | 0
Value2 | 1.63 |  | 0
Value3 | 1.63 |  | 0
Value4 | 0.83 |  | 0
Value5 | 1.01 |  | 0
Value6 | 1.03 |  | 0
Value7 | 1.01 |  | 0
Value8 | 0.8 |  | 0
Value9 | 1.2 |  | 0
Value10 | 1.2 |  | 0
Value11 | 1.2 |  | 0
Total |  |  | 0
 | Grand Total |  | 0
Spreadsheet: d149f34b-51df-4c14-ab55-26a5b307ef95
Sheet: Sheet1

Unnamed: 0 | Unnamed: 1 | Unnamed: 2 | Unnamed: 3 | Unnamed: 4
 |  | U.S. Census Bureau
 |  | Source: Quarterly Services Survey
 |  | 51: Information: U.S. Total
 |  | Not Seasonally Adjusted Total Revenue [Millions of Dollars]
 |  | Period: 2003 to 2014
 |  | Data Extracted on: October 23, 2014 (6:13 pm)
Year | 1st Quarter | 2nd Quarter | 3rd Quarter | 4th Quarter
2003 | X | X | X | 237399
2004 | 223675 | 233241 | 232983 | 246201
2005 | 236033 | 244136 | 244711 | 255856
2006 | 245182 | 254735 | 255745 | 271401
2007 | 257973 | 265739 | 267325 | 281304
2008 | 270223 | 277650 | 277603 | 282873
2009 | 261921 | 266862 | 265511 | 280665
2010 | 267597 | 274785 | 276049 | 291794
2011 | 277416 | 289110 | 288779 | 305253
2012 | 291952 | 300081 | 298950 | 322308
2013 | 306040 | 313234 | 314646 | 340055
2014 | 324502 | 330908 | X | X
Spreadsheet: 48376d1247596978-calculate-number-of-occurences-with-last-3-and-6-months-calcnumber_months
Sheet: Sheet1

 |  |  |  |  | This Month | Last 3 Months | Last 6 Months
 | 1 | 2009-05-01 00:00:00 | [NAME] | 12/09/1993 | 4
 | 1 | 2009-05-15 00:00:00 | [NAME] | 12/09/1993 | 4
 | 1 | 2009-06-16 00:00:00 | [NAME] | 12/09/1993 | 2
 | 1 | 2009-07-14 00:00:00 | [NAME] | 12/09/1993 | 2
 |  | 2009-05-01 00:00:00 | [NAME] | 12/09/1993 | 4
 |  | 2009-03-01 00:00:00 | [NAME] | 12/09/1993 | 1
 |  | 2009-04-01 00:00:00 | [NAME] | 12/09/1993 | 1
 |  | 2009-07-14 00:00:00 | [NAME] | 12/09/1993 | 2
 |  | 2009-05-01 00:00:00 | [NAME] | 12/09/1993 | 1
 |  | 2009-05-15 00:00:00 | [NAME] | 12/09/1993 | 4
 |  | 2009-06-16 00:00:00 | [NAME] | 12/09/1993 | 2
 |  |  |  |  | 0
 |  |  |  |  | 0
Spreadsheet: 328348d1403876654-formula-to-add-up-totals-from-lots-of-worksheets-testings
Sheet: sheet3

 |  |  | Item | Location in Room | Date of PAT Test | [NAME] |  | [NAME] key
 |  |  | 1 | 2 | TBA |  |  | Test Due
 |  |  | 1 | 2 | TBA |  |  | Test in 30 days
 |  |  | 1 | 2 | TBA
 |  |  | 1 | 2 | TBA
 |  |  | 1 | 2 | 2013-09-30 00:00:00 | 2014-09-30 00:00:00
 |  |  | 1 | 2 |  | 2013-02-26 00:00:00
 |  |  | 1 | 2 | TBA
 |  |  | 1 | 2 | TBA
 |  |  | 1 | 2 |  | 2013-02-25 00:00:00
 |  |  | 1 | 2 | TBA
 |  |  | 1 | 2 | TBA
 |  |  | 1 | 2 |  | 2013-02-25 00:00:00
 |  |  | 1 | 2 | 2013-09-30 00:00:00 | 2014-09-30 00:00:00
 |  |  | 1 | 2 |  | 2014-02-26 00:00:00
 |  |  | 1 | 2 | 2013-09-30 00:00:00 | 2014-09-30 00:00:00
 |  |  | 1 | 2 | 2013-02-26 00:00:00 | 2014-02-26 00:00:00
 |  |  | 1 | 2 | 2013-09-30 00:00:00 | 2014-09-30 00:00:00
 |  |  | 1 | 2 |  | 2013-02-25 00:00:00
 |  |  | 1 | 2 | TBC (tower connect)
 |  |  | 1 | 2 |  | 2014-09-30 00:00:00
 |  |  | 1 | 2 | TBA
 |  |  | 1 | 2 | TBA
 |  |  | 1 | 2 |  | 2014-09-30 00:00:00
 |  |  | 1 | 2 | TBA
 |  |  | 1 | 2 | 2013-09-30 00:00:00 | 2014-09-30 00:00:00
 |  |  | 1 | 2 |  | 2013-02-26 00:00:00
 |  |  | 1 | 2 | 2013-09-30 00:00:00 | 2014-09-30 00:00:00
 |  |  | 1 | 2 | TBA
 |  |  | 1 | 2 |  | 2013-02-10 00:00:00
 |  |  | 1 | 2 | TBA
 |  |  | 1 | 2 | TBA
 |  |  | 1 | 2 | TBA
 |  |  | 1 | 2 | TBA
 |  |  | 1 | 2 | 2013-09-30 00:00:00 | 2014-09-30 00:00:00
 |  |  | 1 | 2 | 2012-08-21 00:00:00 | 2013-08-21 00:00:00
 |  |  | In need of first test:
 |  |  | Overdue for PAT test:
 |  |  | Total
Spreadsheet: 106105d1303324332-consolidating-a-list-into-another-in-the-same-worksheet-new-commission-sheet_wip
Sheet: Sheet1

 | HMC April Scorecard Summary
 | Employee | Units | Volume | Gross Commission | Monthly Capture Rate Bonus | Quarterly IFQ Bonus |  | Assistant/ Associate Name | Assistant / Associate Bonus Expense |  | Miscellaneous Expense | Payable  Commission
 | [NAME] |  |  |  |  |  |  | [NAME]
 |  |  |  |  |  |  |  | Billy | 2000
 |  |  |  |  |  |  |  | Suzie | 3000
 |  |  |  |  |  |  |  | [NAME]
 |  |  |  |  |  |  |  | [NAME] | 3500
 |  |  |  |  |  |  |  | [NAME]
 |  |  |  |  |  |  |  | Billy | 1500
 | TOTAL | 0 | 0 | 0 | 0 |  | 0 | 0 | 0 |  | 0 | 0
 | Assistant / Associate Name |  | Bonus Amt
 | Billy |  | 2000
 | Suzie |  | 3000
 | [NAME] |  | 3500
 | Billy |  | 1500
 |  |  | 10000
 | HMC - Employee Name
 | [NAME] | TOP |  |  |  |  | IFQ | Monthly | Quarterly
 |  | Units | Volume |  |  |  | Total Loans | 5 | 12 |  | Gross Commission |  | 16991.8592
 | PRODUCTION | 12 | 2654978 |  | Amount |  | Loans >= 85% | 4 | 10
 | Loans less than min |  |  |  | 0 |  |  | 0.8 | 0.8333333333333334 |  | IFQ Quarterly Bonus |  | 796.4934
 | Loans above [NAME] |  |  | Tier (bps) | 0 |  |  |  |  |  | Capture Rate Bonus
 | Home Equity Loans |  |  | 45 | 0 |  | Capture Rate | Monthly | YTD |  | Asst / Assoc Salary |  | 0
 | Prefer to [NAME] |  |  | 25 | 0 |  | Total Loans |  |  |  | Asst / Assoc Bonus
 | Standard Production |  | 2654978 | 64 | 16991.8592 |  | L&F Loans
 | Gross Commission |  |  |  | 16991.8592 |  |  | #N/A | #N/A
 |  |  |  |  |  |  | L&F Volume |  |  |  | [NAME]
 |  | [NAME] (bps)
 |  |  |  |  |  |  | Asst / Assoc | Monthly | Exp Amt
 |  |  |  |  |  |  |  |  | 0
 |  |  |  |  |  |  |  | [NAME] ($)
 | 2011 Standard Commission Schedule (000s) |  |  | Min Loan Amt | [NAME]
 | 1 - 3 | $0 - $499 | 29 | 172413.7931034483 | 3448275.862068966 |  | Assistant / Associate HMC Schedule
 | 4 - 6 | $500 - $899 | 44 | 113636.3636363636 | 2272727.272727272 |  | 0 - 5 units   OR   $0 - $2M |  | 100% of salary
 | 7 - 9 | $900 - $1399 | 49 | 102040.8163265306 | 2040816.326530612 |  | 6 - 10 units   OR   $2.01M - $3M |  | 50% of salary |  |  |  | 0
 | 10 - 12 | $1400 - $1899 | 59 | 84745.76271186442 | 1694915.254237288 |  | 11 - 14 units   OR   $3.01M - $4.5M |  | 33% of salary
 | 13+ | $1900+ | 64 | 78125 | 1562500 |  | 15+ units   OR   $4.501M+ |  | 0% of salary |  | Net (payable) Commission |  | 17788.3526
Spreadsheet: 846419d1697631606-how-to-split-a-cell-value-into-multiple-cells-split-order-into-multiple-payments-test
Sheet: Units to order

 | 2023-08-01 00:00:00 | 2023-09-01 00:00:00 | 2023-10-01 00:00:00 | 2023-11-01 00:00:00 | 2023-12-01 00:00:00 | 2024-01-01 00:00:00 | 2024-02-01 00:00:00 | 2024-03-01 00:00:00 | 2024-04-01 00:00:00
Product A |  |  |  | 200 |  |  | 300 |  | 500
Product B |  |  |  |  | 300 |  | 500
Product C |  |  | 200 |  |  | 200 |  |  | 400
Spreadsheet: tracy_geaccone__40530__ETS - Total IC 10-19
Sheet: IT Development

Cost Center | Project Manager | Activity | Project Name | ETS $ Expense | ETS $ [NAME]
103152 | Ogg | DEVELOPMENT SUPPORT | Oracle Software Maintenance** | 351424.8136782113 | 0
103152 | Ogg | DEVELOPMENT SUPPORT | [NAME] renewal | 92711.416781293 | 0
103153 | S.Cleverly | INTRANET | IZZIE Maintenance* | 16203.91567464527 | 0
Totals
ETS Company |  | Desktop Counts | Percentage | Oracle | Tibco | Other* | Total Projects
Northern Plains Natural Gas |  | 119 | 0.1187624750499002
Enron Transportation Services |  | 168 | 0.1676646706586826
Northern Natural Gas |  | 368 | 0.3672654690618762
[NAME] |  | 57 | 0.05688622754491018
Citrus Corp |  | 136 | 0.1357285429141717
Enron Asset Management Resources |  | 141 | 0.1407185628742515
Enron Pipeline Services Co. |  | 13 | 0.01297405189620758
ETS Total
*Other - remaining projects broken out by desktop counts.
**Please note tht the above Oracle amount is subject to change based on renegotiation of the project.
Spreadsheet: 744984d1629635294-use-a-value-from-sheet-2-to-find-the-matching-value-in-a-string-in-sheet-1-orders-35
Sheet: orders-35

Order ID | [NAME] | Financial Status | Paid at | Fulfillment Status | Fulfilled at | Currency | Subtotal | Shipping | Taxes | Amount Refunded | Total | Discount Code | Discount Amount | Shipping Method | Created at | Lineitem quantity | Billing Name | Private Notes | Channel Type | Channel Name | Channel Order Number | Checkout Form: Special Instructions for seller | Fees | Checkout Form: Recipient's Name | Location | Payment Method | Payment Reference
1349 |  | PAID | 2021-08-21 00:00:00 | FULFILLED | 2021-08-21 20:57:00 | USD | 12.38 | 0 | 0 | 0 | 12.38 |  | 0 |  | 2021-08-21 20:57:00 | 1 | Cash Sales | [2021-08-21 20:57:51 -0700] [NAME] | POS | Squarespace | 1349 | 12.38 |  | Cash Sales: 1349 |  | [NAME] | {"locationId":"L94F75VZ8ZV5C","transactionId":"kkG8x5Q0cZWvFjLzgexQZ7veV","clientTransactionId":null,"transactionTime":null}
1349 |  |  | 2021-08-21 00:00:00 |  |  |  |  |  |  |  |  |  |  |  |  | 1 |  |  |  |  |  |  |  | Cash Sales: 1349
1349 |  |  | 2021-08-21 00:00:00 |  |  |  |  |  |  |  |  |  |  |  |  | 1 |  |  |  |  |  |  |  | Cash Sales: 1349