tianzl66/Sheetpedia huggingface dataset:
Spreadsheet: 9452e28e-417b-47de-a7a8-672f36ca913f
Sheet: Sheet1

Date | Sport | Opponent | Time_Results
11/12/2012 | Men's Basketball | at Gonzaga | L, 50-84
11/22/2012 | Men's Basketball | vs. Marist ([NAME], Fla.) | W, 87-44
11/23/2012 | Men's Basketball | vs. [NAME] (Lake [NAME], Fla.) | L, 60-63
11/25/2012 | Men's Basketball | vs. Oklahoma (Lake [NAME], Fla.) | L, 70-77
11/28/2012 | Men's Basketball | VMI | W, 94-69
12/05/2012 | Men's Basketball | vs. [NAME] (Charleston, W.Va.) | W, 69-59
12/08/2012 | Men's Basketball | [NAME] | W, 68-67
12/11/2012 | Men's Basketball | at Duquesne | L, 56-60
12/15/2012 | Men's Basketball | vs. Michigan (Brooklyn, N.Y.) | L, 66-81
12/19/2012 | Men's Basketball | Oakland | W, 76-71
12/22/2012 | Men's Basketball | Radford | W, 72-62
12/30/2012 | Men's Basketball | Eastern Kentucky | W, 74-67
01/05/2013 | Men's Basketball | Oklahoma * | L, 57-67
01/09/2013 | Men's Basketball | at Texas * | W, 57-53
01/12/2013 | Men's Basketball | Kansas State * | L, 64-65
[NAME] | Men's Basketball | at Iowa State * | L, 67-69
01/19/2013 | Men's Basketball | at Purdue | L, 52-79
[NAME] | Men's Basketball | TCU * | W, 71-50
01/26/2013 | Men's Basketball | at Oklahoma State * | L, 66-80
01/28/2013 | Men's Basketball | Kansas * | L, 56-61
02/02/2013 | Men's Basketball | at Texas Tech * | W, 77-61
[NAME] | Men's Basketball | Texas * | W, 60-58
02/09/2013 | Men's Basketball | at TCU * | W, 63-50
02/13/2013 | Men's Basketball | at Baylor * | L, 60-80
02/16/2013 | Men's Basketball | Texas Tech * | W, 66-64
02/18/2013 | Men's Basketball | at Kansas State * | L, 61-71
02/23/2013 | Men's Basketball | Oklahoma State * | L, 57-73
02/27/2013 | Men's Basketball | Baylor * | L, 62-65
03/02/2013 | Men's Basketball | at Kansas * | L, 65-91
03/06/2013 | Men's Basketball | at Oklahoma * | L, 70-83
03/09/2013 | Men's Basketball | Iowa State * | L, 74-83
03/13/2013 | Men's Basketball | vs. Texas Tech (Big 12 Championship) | L, 69-71
Spreadsheet: 852922d1702909021-formula-for-making-multiple-sentences-form-new-sentences
Sheet: Sheet1

Pediste | que (1) | [NAME] | que (1) (2) (3) (16) | participara |  |  |  |  | t
Pedías | que | [NAME] hubiera permitdo | que Juan | hubiera participado |  |  |  | 1 | r |  |  |  | =LAMBDA(a;b; SE(a="";b&"u";teste(DESLOC(b;1;0))))
[NAME] pidiendo |  | [NAME] aceptara |  |  |  |  | 1 | 2 | g
Estabas pidiendo |  | [NAME] hubiera aceptado |  |  |  |  |  | 3 | h | Pedías que [NAME] hubiera permitdo que Juan hubiera participado
Habías pedido |  | fuera necesario |  |  |  |  | 3 | 4 | k | [NAME] pidiendo [NAME] aceptara que Juan
Pedirías |  | hubiera sido necesario |  |  |  |  |  | 5 | m | Estabas pidiendo [NAME] hubiera aceptado que [NAME]
Estarías pidiendo |  | [NAME] no dijera |  |  |  |  |  | 0 |  | Habías pedido que fuera necesario que Juan
Habrías pedido |  | [NAME] no hubiera dicho |  |  |  |  | 7 | 4 |  | Pedirías que hubiera sido necesario que Juan
 |  |  |  |  |  |  |  |  |  | Estarías pidiendo [NAME] no dijera que Juan
 |  |  |  |  |  |  |  |  |  | Habrías pedido que [NAME] no hubiera dicho  que Juan
PedíasqueJosé permitieraque Juanparticipara 0 |  |  | Pediste [NAME] pidiendo [NAME] permitiera que Juan participara 2
[NAME] 0 |  |  | Pediste [NAME] pidiendo [NAME] permitiera que Juan participara 3
 |  |  |  |  |  |  |  |  |  | =LAMBDA(a;b;c;d;e;f; SE(a="";a;b&" "&c&" "&d&" "&e&" "&f))
https://www.excelforum.com/excel-formulas-and-functions/1416549-formula-for-making-multiple-sentences.html
=LAMBDA(t;b;a; SE(b="";t;ReplaceText(SUBSTITUIR((t;b;a);DESLOC(b;1;0);DESLOC(a;1;0)))))
Spreadsheet: 672231d1586798710-calculating-based-on-three-or-more-conditions-data-sample
Sheet: Sheet1

SKU | OMH115P
Region | Central
QTY | 26 - 50x
Price | ? | Calculates price based on three conditions: SKU, Region and QTY and apllies the specific multiplier on the list price (details on sheet "Tables")
Example
IF | SKU | OMH120P
AND | Region | East
AND | QTY | 5x
Multiplier | 1.1
Final Price | 1.1 * 3.86
Spreadsheet: 46388d1245261874-ranking-ties-book1
Sheet: Sheet1

Match | a | b | c | d |  | a | b | c | d |  | a | b | c | d
1 | 7 | 8 | 5 | 9 |  |  |  |  |  |  | 2 | 3 | 1 | 4
2 | 13 | 8 | 23 | 9 |  |  |  |  |  |  | 3 | 1 | 4 | 2
3 | 24 | 24 | 5 | 9 |  |  |  |  |  |  | 3.5 | 3.5 | 1 | 2
4 | 45 | 24 | 5 | 9 |  |  |  |  |  |  | 4 | 3 | 1 | 2
5 | 24 | 12 | 25 | 24 |  |  |  |  |  |  | 2.5 | 1 | 4 | 2.5
Spreadsheet: 700825d1603362069-match-and-index-test-sales
Sheet: Sheet1

TOTAL DAYS | 1900-01-31 00:00:00
TODAY | 1900-01-21 00:00:00
REMAINING |  | Shop | Shop | Shop | Shop | Shop | Shop | Shop | Shop | Shop
DATE | DAY | 036 | 037 | 007 | 108 | 120 | 019 | 005 | 020 | 035
2020-10-01 00:00:00 | Thursday
2020-10-02 00:00:00 | Friday
2020-10-03 00:00:00 | Saturday
2020-10-04 00:00:00 | Sunday
2020-10-05 00:00:00 | Monday
2020-10-06 00:00:00 | Tuesday
2020-10-07 00:00:00 | Wednesday
2020-10-08 00:00:00 | Thursday
2020-10-09 00:00:00 | Friday
2020-10-10 00:00:00 | Saturday
2020-10-11 00:00:00 | Sunday
2020-10-12 00:00:00 | Monday
2020-10-13 00:00:00 | Tuesday
2020-10-14 00:00:00 | Wednesday
2020-10-15 00:00:00 | Thursday
2020-10-16 00:00:00 | Friday
2020-10-17 00:00:00 | Saturday
2020-10-18 00:00:00 | Sunday
2020-10-19 00:00:00 | Monday
2020-10-20 00:00:00 | Tuesday
2020-10-21 00:00:00 | Wednesday
2020-10-22 00:00:00 | Thursday
2020-10-23 00:00:00 | Friday
2020-10-24 00:00:00 | Saturday
2020-10-25 00:00:00 | Sunday
2020-10-26 00:00:00 | Monday
2020-10-27 00:00:00 | Tuesday
2020-10-28 00:00:00 | Wednesday
2020-10-29 00:00:00 | Thursday
2020-10-30 00:00:00 | Friday
2020-10-31 00:00:00 | Saturday
Total
Spreadsheet: 08309c3a-e586-405e-bb2d-a80c26a2801e
Sheet: Capital Costs

Table 5.2.1.  Capital Costs
Complete the areas shown in gray below.  Where shown, use pulldown menu to select options.  The spreadsheet will calculate the capital costs.
Project Administration ($):
Component | Unit Costa | Unit | Quantity | Total Cost
aUnit costs are in today's dollars, not future dollars. |  |  | Total Construction Cost:
 |  |  | Construction Contingency Cost:
 |  |  | Project Administration Cost:
 |  |  | Total Capital Cost:
Construction Contingency | 0.1
Spreadsheet: sally_beck__34340__2002 Budget Edie Format
Sheet: Canada Admins

 | Canada Admins
 | 2002 Plan
 |  |  |  |  |  |  |  | Per HC | New HC | Adjust Comp
 |  | 2001-09-01 00:00:00 |  | 2002 |  | 2002 |  |  |  |  |  |  |  | 2002
 |  | YTD Actual |  | Forecast |  | Plan |  |  |  |  |  |  |  | Plan
ENACOMP | Compensation |  |  |  |  |  | Compensation | 0
 | Special Pays |  |  |  |  | 0
 | Analysts & Associates | 0 |  | 0
ENABENTX | Benefits & Payroll Taxes |  |  |  |  | 0 | Other
ENAEMPEX | Employee Expense
ENAT&EEX | Travel & Entertainment Expense |  |  |  |  |  | Total
ENAOUTSV | Outside Services
ENASUPP | Supplies Expense
ENAMKTEX | Marketing |  |  |  |  |  | [NAME] | 33600 | 0
ENACONTR | Charitable Contributions |  |  |  |  |  | [NAME] | 52800 | 0
ENARENT | Rent |  |  |  |  |  | Staff | 54000 | 0
ENATECH | Technology |  |  |  |  |  | Specialist | 63000 | 0
ENATRANS | Transportation |  |  |  |  |  | Sr. Specialist | 78000 | 0
ENAOTHEX | Other Expenses |  |  |  |  |  | Analyst | 66000 | 0
ENATAXES | Taxes Other than Income |  |  |  |  |  | Associate | 97200 | 0
ENATOTDR | Total Direct Expenses |  |  |  |  |  | Manager | 120000 | 0
 |  |  |  |  |  |  | Director | 156000 | 0
 | Headcount |  |  |  |  |  | Sr. Director | 180000 | 0
 |  |  |  |  |  |  | VP | 216000 | 0
 | Analyst & Associate Headcount |  |  |  |  |  | CEO | 240000 | 0
 | Total Headcount |  |  |  |  |  |  |  |  |  |  |  |  | 1
ENAOUTLG | *  Analysts and Associates are billed through normal payroll for Canada. |  |  |  |  | Other Expense Calculation
ENAOUTTX
ENAINSUR |  |  |  |  |  | Total Misc Exp | Old HC | Exp/Old HC | New HC | Exp/New HC
ENASYSDV
ENACORIT
ENACORRN
ENAOTHAL
ENADEPR
Spreadsheet: 108183d1305235781-changing-conditional-formatting-based-on-a-reference-kessler-1
Sheet: Common sixed & pro forma income

5 Year Common Sized Income Statement
Item | 2005 | 2006 | 2007 | 2008 | 2009 | 2010 | 3 year Average | 5 Year Average
Sales | 1 | 1 | 1 | 1 | 1 | 1
[NAME] | 0.6505073628836129 | 0.6478192581305764 | 0.6416541395941342 | 0.6648943854618791 | 0.6458480997296474 | 0.5876946852888238
SG&A | 0.1995418504202243 | 0.2034861906478741 | 0.205684581119169 | 0.1943401757815182 | 0.179828899072496 | 0.1909675997748852 |  |  | 0.1956
Depr. & Amort. | 0.02663467565506252 | 0.02958055769827362 | 0.02686058638406288 | 0.02471191485855885 | 0.03127889598332798 | 0.03922489898884944 |  |  | 0.038
Op. Income After Depr. | 0.1233161315715289 | 0.119113975819414 | 0.1258006680398142 | 0.1160535601597993 | 0.1430440544592709 | 0.1821127828142574 |  |  |  |  | 0.23 | 0.28 | 0.23 | 0.23
Intrest Expense | 0.01103540028214035 | 0.01115037282775032 | 0.01087654329205101 | 0.01669258384974908 | 0.01662562873989101 | 0.01415481103906514 |  |  | 0.0145
Nonop Income/ Expense | 0.003131304008092124 | 0.002439753262552633 | 0.00340174209728881 | 0.004300979226341429 | 0.001034611288260044 | 0.001806401320577393 |  |  | 0.0024
Special Items | -0.01530131259615706 | -0.01035816130467208 | -0.00612751163139537 | -0.002746780561999672 | -0.02205866744206624 | -0.01108746924047715 |  |  | -0.0113
Pretax Income | 0.1001107224680233 | 0.1000452029162821 | 0.1121983614293615 | 0.1009151717637157 | 0.1053943727377773 | 0.1586768997136445
Total Taxes | 0.03628104872714329 | 0.03351516662931388 | 0.03900574351026417 | 0.03343229891599592 | 0.03462328781807548 | 0.051378969328956 |  |  | 0.046
Net Income | 0.0631510609528269 | 0.06653003628696821 | 0.07319261791909736 | 0.06748287284771977 | 0.07077108491970177 | 0.1072979336980069
Pro Forma Income Statement
Item | 2010 | 2011 Q1 | 2011 Q2 | 2011 Q3 | 2011 Q4 * | 2011 Total | 2012 | 2013 | 2014 | 2015
Sales** | 4605.2890625 | 1047.31 | 1278.91 | 1312.35
COGS*** | 2706.50390625
SG&A | 879.4609985351562 | 203.261 | 222.82 | 214.33
Depr. & Amort. | 180.6419982910156
Op. Income After Depr. | 838.6820068359375
Intrest Expense | 65.18699645996094
Nonop Income/ Expense | 8.319000244140625 | 0.693 | 3.76 | 0.17
Special Items | -51.06100082397461 | -1.37 | -3.38 | -0.51
Pretax Income | 730.7529907226562 | 149.754
Total Taxes | 236.615005493164 | 46.873 | 72 | 63.78
Net Income | 494.1380004882812 | 102.881 | 149.73 | 132
* 2011 Q4 is estimated values (predicted based on prior years fourth quarter results)
* Sales is based on a 19% annual growth rate
**COGS is based on a 1.9% annual detteriation as a percentage of sales
** COGS as a percentage of sales
Spreadsheet: phillip_m_love__30149__9908_OA
Sheet: STG_GL

ENRON CAPITAL & TRADE RESOURCES
OPERATIONAL ANALYSIS - ACTUALS
COMPANY:  ALL
REGION:  STORAGE
 |  |  | Total |  | Reclasses |  | August |  | September |  | October |  | November |  | December |  | January |  | February |  | March |  | April |  | May |  | June |  | July |  | August |  | September
 |  |  | 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 | Volume | $'s | Volume | $'s
 | Sales:
1 |  | 3rd Party / Inter Enron |  |  |  |  |  |  |  | 0
2 |  | Liquidations |  |  |  |  |  |  |  |  |  | 0
3 |  | Cost of Inventory |  |  |  |  |  |  |  |  |  | -4241659 |  |  |  |  |  | -110180
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: |  |  |  |  |  |  |  | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0
23 | Fuel: |  |  |  |  |  |  |  | 0 |  | 0 | 0 | 0 | -94192 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0
 | Transport Expense:
24 |  | Commodity
25 |  | Demand
 | Total Transport Expense:
 | Transport Revenue:
26 |  | Interstate
27 |  | Intrastate |  |  |  |  |  |  |  | 123637
 | 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 |  |  |  |  |  | 0 |  | 0
31 |  | Prior Month Book Balance
 |  | Total MTM Income
32 |  | Prudency
33 |  | Financial Liquidations |  |  |  |  |  |  |  | 0 |  | -1166544
34 |  | Originations
35 |  | Broker Fees
36 |  | Asset Group Demand Charges |  |  |  |  |  |  |  |  |  |  |  | -376583
37 |  | [NAME]
38 |  | Interdesk Charges
39 |  | Canada
40 |  | Miscellaneous |  |  |  |  |  | 14354 |  | -14354
 |  | TOTAL
Spreadsheet: 0ac7e5a4-7337-4750-ace4-f1f0d1a1671e
Sheet: Sheet1

Study Coach Application For SP13
Please print or type.  [NAME] and submit to
[NAME] – Library – ARC – Room A26
Or via email to [EMAIL]
Date of application:
Basic Information:
Name: |  |  |  | Phone:
BU Email: |  |  |  | Cell:
Address:
BU ID number:
Education Information:
Classification: | Freshman - Sophomore - Junior - Senior - Other
Major:
Cum. GPA:
Please complete the following information for these courses
Course Name |  | BU # |  | Final Grade |  | Professor
Prin of Fin Acct |  | (ACCT 101)
Prin of Managerial Acct |  | (ACCT 102)
Hum Anat & Physio. w/Lab I |  | (BIOL 108)
Principles of Biology |  | (BIOL 130)
Cell Biology |  | (BIOL 231)
Gen College Chemistry I |  | (CHEM 103)
Organic Chemistry I |  | (CHEM 205)
Prin of Macroeconomics |  | (ECON 110)
Prin of Microeconomics |  | (ECON 111)
Environmental Science |  | (ENVS 111)
Intro to Earth Science W/Lab |  | (ENVS 150)
Spanish |  | (Any level)
French |  | (Any level)
German |  | (Any level)
The West. World - 1450-1870 |  | (HIST 116)
The West. World - 1870-Present |  | (HIST 117)
Foundations of Math |  | (MATH 101)
College Algebra |  | (MATH 105)
Elem Functions & Coord Geom(Pre-Cal) |  | (MATH 116)
Calculus I |  | (MATH 117)
Discrete Math |  | (MATH 120)
Business Calculus |  | (MATH 125)
Statistics and Society |  | (MATH 200)
[NAME] |  | (MATH 205)
Calculus III |  | (MATH 216
Music Theory II |  | (MUSC 102)
Infection, Immunity, Genomics |  | (MDLS 200)
Nutrition |  | (NURS 200)
Foundations of Nursing |  | (NURS 205)
Med Surge II |  | (NURS 310)
Health Assessment |  | (NURS 311)
Pediatrics for Accelerated |  | (NURA 305)
Med Surge II for Accelerated |  | (NURA 310)
OB |  | (NURA 330)
College Physics I |  | (PHYS 201)
University Physics 1 |  | (PHYS 205)
American Nat. Gov. |  | (PS 101)
Introductory Psyc. |  | (PSYC 103)
Experience: | Please list experience related to tutoring, if any.
(1) Title: |  | (2) Title:
Employer: |  | Employer:
Description: |  | Description:
Begin Date/End Date: |  | Begin Date/End Date:
Availability:
Please list what times you would be willing to tutor this semester.
More flexibility in your times listed will provide you with more opportunities to tutor.
Days Available |  |  |  | Times Available
I certify that all answers to the questions are true to the best of my knowledge.  I authorize BU to  check my grades received in the classes I would like to tutor.
Applicant Signature
Spreadsheet: 886231d1736264168-how-to-automatically-remove-or-identify-the-most-recent-row-based-on-a-combo-of-data-latest-unique-rows-required
Sheet: Current

ID | Code | Value | EffectiveFrom | DESIRED OUTCOME
/SO9/ | Pension EE | 7 | 2024-06-01 00:00:00
/SO9/ | Pension ER | 12 | 2024-06-01 00:00:00
/xckh | Pension EE | 7 | 2021-04-01 00:00:00 | THIS SHOULD BE REMOVED AS THE COMBO OF COLUMN A AND B BUT ISNT THE LATEST DATED ENTRY
/xckh | Pension EE | 9 | 2024-04-01 00:00:00
/xckh | Pension ER | 12 | 2021-04-01 00:00:00
+5uKY | Pension EE | 3 | 2024-11-01 00:00:00
+5uKY | Pension ER | 6 | 2024-11-01 00:00:00
+67Rb | Pension EE | 3 | 2023-08-01 00:00:00
+67Rb | Pension ER | 6 | 2023-08-01 00:00:00
+7vOX | Pension EE | 9 | 2021-04-01 00:00:00 | THIS SHOULD BE REMOVED AS THE COMBO OF COLUMN A AND B BUT ISNT THE LATEST DATED ENTRY
+7vOX | Pension EE | 14 | 2024-04-01 00:00:00
+7vOX | Pension ER | 12 | 2021-04-01 00:00:00
+AiQq | Pension EE | 5 | 2023-08-01 00:00:00
+AiQq | Pension ER | 10 | 2023-08-01 00:00:00
+bxir | Pension EE | 5 | 2021-04-01 00:00:00 | THIS SHOULD BE REMOVED AS THE COMBO OF COLUMN A AND B BUT ISNT THE LATEST DATED ENTRY
+bxir | Pension EE | 5 | 2021-04-01 00:00:00
+bxir | Pension ER | 10 | 2021-04-01 00:00:00
+HPQk | Pension EE | 3 | 2024-03-01 00:00:00
+HPQk | Pension ER | 6 | 2024-03-01 00:00:00
+U65E | Pension EE | 5 | 2020-06-01 00:00:00 | THIS SHOULD BE REMOVED AS THE COMBO OF COLUMN A AND B BUT ISNT THE LATEST DATED ENTRY
+U65E | Pension EE | 5 | 2021-04-01 00:00:00
+U65E | Pension ER | 10 | 2020-06-01 00:00:00
Spreadsheet: 206700d1358260002-match-the-upper-closest-value-using-index-match-indexmatchupperclosestvalue_alongwithexactmatch
Sheet: B1.Est_Shell (3)

Table 1 |  |  |  | Table 2 (Database)
Value | Category | Result |  | Value | Category | Result
15 | A |  |  | 28 | A | 4.3
13 | A |  |  | 25 | A | 3.76
11.5 | C |  |  | 22 | A | 3.22
9.5 | A |  |  | 20 | A | 2.77
8 | A |  |  | 18 | A | 2.37
6.5 | A |  |  | 16 | A | 1.98
6 | B |  |  | 14 | A | 1.71
6 | A |  |  | 12 | A | 1.4
6 | D |  |  | 11 | A | 1.24
6 | A |  |  | 10 | A | 1.09
6 | A |  |  | 9 | A | 0.89
6 | C |  |  | 8 | A | 0.71
6 | A |  |  | 7 | A | 0.58
6 | A |  |  | 6 | A | 0.48
6 | A |  |  | 5 | A | 0.37
6 | A |  |  | 4 | A | 0.23
6 | A |  |  | 3 | A | 0.16
6 | A |  |  | 28 | B | 5.9
6 | C |  |  | 25 | B | 5.15
6 | A |  |  | 22 | B | 4.45
6 | A |  |  | 20 | B | 3.8
6 | A |  |  | 18 | B | 3.25
6 | A |  |  | 16 | B | 2.75
6 | B |  |  | 14 | B | 2.35
6 | A |  |  | 12 | B | 1.95
6 | A |  |  | 11 | B | 1.7
6 | A |  |  | 10 | B | 1.5
 |  |  |  | 9 | B | 1.25
 |  |  |  | 8 | B | 1
 |  |  |  | 7 | B | 0.8
 |  |  |  | 6 | B | 0.65
 |  |  |  | 5 | B | 0.5
 |  |  |  | 4 | B | 0.32
 |  |  |  | 3 | B | 0.22
 |  |  |  | 28 | C | 5.5
 |  |  |  | 25 | C | 4.89
 |  |  |  | 22 | C | 4.19
 |  |  |  | 20 | C | 3.6
 |  |  |  | 18 | C | 3.05
 |  |  |  | 16 | C | 2.57
 |  |  |  | 14 | C | 2.22
 |  |  |  | 12 | C | 1.82
 |  |  |  | 11 | C | 1.61
 |  |  |  | 10 | C | 1.42
 |  |  |  | 9 | C | 1.16
 |  |  |  | 8 | C | 0.92
 |  |  |  | 7 | C | 0.75
 |  |  |  | 6 | C | 0.62
 |  |  |  | 5 | C | 0.48
 |  |  |  | 4 | C | 0.3
 |  |  |  | 3 | C | 0.21
 |  |  |  | 28 | D | 6.9
 |  |  |  | 25 | D | 6
 |  |  |  | 22 | D | 5.2
 |  |  |  | 20 | D | 4.45
 |  |  |  | 18 | D | 3.8
 |  |  |  | 16 | D | 3.2
 |  |  |  | 14 | D | 2.75
 |  |  |  | 12 | D | 2.25
 |  |  |  | 11 | D | 2
 |  |  |  | 10 | D | 1.76
 |  |  |  | 9 | D | 1.44
 |  |  |  | 8 | D | 1.14
 |  |  |  | 7 | D | 0.93
 |  |  |  | 6 | D | 0.77
 |  |  |  | 5 | D | 0.59
 |  |  |  | 4 | D | 0.38
 |  |  |  | 3 | D | 0.26
Spreadsheet: 770754d1646241376-manipulating-text-string-data-into-separate-columns-formatting-per-person-cost
Sheet: Sheet1

Data |  |  | Desired Output [Manual]
$1,139 – $1,329 / Person |  |  | 1139 | 1329 | / Person
2450 |  |  | 2450
$1,139 – $1,329 |  |  | 1139 | 1329
$795 – $1,800 |  |  | 795 | 1800
$500 – $13,800 |  |  | 500 | 13800
$887 – $19,978 / Person |  |  | 887 | 19978 | / Person
$2,425 – $12,450 |  |  | 2425 | 12450
3100 |  |  | 3100
$1,613 / Person |  |  | 1613 |  | / Person
Spreadsheet: 676389d1588782627-reducing-values-randomly-to-zero-using-normal-distribution-function-example-file
Sheet: Sheet1

Fuel allowance (litres) | fuel tank capacity (litres) | Number of times fueled | Total amount charged
64.56060000000004 | 30
166.8204 | 40
89.02140000000001 | 50
2.698800000000037 | 60
123.3414 | 70
Penalty fee for every time top up |  | $16.78
Spreadsheet: 86623d1286556269-conditional-formatting-scottish-premier-league-2010-2011
Sheet: League Table

 | CLYDESDALE BANK SCOTTISH PREMIER LEAGUE SEASON 2010/2011
 | Position | Team | P | W | D | L | F | A | [NAME] | Pts | HOME GAME |  |  |  |  |  |  |  | AWAY GAME
 |  |  |  |  |  |  |  |  |  |  | P | W | D | L | F | A | [NAME] | Pts | P | W | D | L | F | A | [NAME] | Pts
 | 1 | Celtic | 7 | 7 | 0 | 0 | 16 | 3 | 13 | 21 | 4 | 4 | 0 | 0 | 12 | 2 | 10 | 12 | 3 | 3 | 0 | 0 | 4 | 1 | 3 | 9
 | 2 | Rangers | 7 | 7 | 0 | 0 | 18 | 6 | 12 | 21 | 3 | 3 | 0 | 0 | 8 | 2 | 6 | 9 | 4 | 4 | 0 | 0 | 10 | 4 | 6 | 12
 | 3 | Motherwell | 7 | 4 | 1 | 2 | 11 | 6 | 5 | 13 | 4 | 1 | 1 | 2 | 6 | 6 | 0 | 4 | 3 | 3 | 0 | 0 | 5 | 0 | 5 | 9
 | 4 | Dundee Utd | 7 | 3 | 2 | 2 | 8 | 12 | -4 | 11 | 3 | 2 | 0 | 1 | 4 | 5 | -1 | 6 | 4 | 1 | 2 | 1 | 4 | 7 | -3 | 5
 | 5 | Inverness CT | 7 | 3 | 1 | 3 | 10 | 7 | 3 | 10 | 4 | 1 | 0 | 3 | 3 | 5 | -2 | 3 | 3 | 2 | 1 | 0 | 7 | 2 | 5 | 7
 | 6 | Hearts | 7 | 2 | 2 | 3 | 10 | 10 | 0 | 8 | 4 | 0 | 2 | 2 | 3 | 6 | -3 | 2 | 3 | 2 | 0 | 1 | 7 | 4 | 3 | 6
 | 7 | Aberdeen | 7 | 2 | 1 | 4 | 9 | 10 | -1 | 7 | 3 | 1 | 0 | 2 | 6 | 4 | 2 | 3 | 4 | 1 | 1 | 2 | 3 | 6 | -3 | 4
 | 8 | Kilmarnock | 7 | 2 | 1 | 4 | 8 | 10 | -2 | 7 | 4 | 1 | 0 | 3 | 4 | 6 | -2 | 3 | 3 | 1 | 1 | 1 | 4 | 4 | 0 | 4
 | 9 | [NAME] | 7 | 2 | 1 | 4 | 6 | 8 | -2 | 7 | 4 | 2 | 0 | 2 | 4 | 4 | 0 | 6 | 3 | 0 | 1 | 2 | 2 | 4 | -2 | 1
 | 10 | Hibernian | 7 | 1 | 2 | 4 | 6 | 12 | -6 | 5 | 3 | 0 | 2 | 1 | 2 | 5 | -3 | 2 | 4 | 1 | 0 | 3 | 4 | 7 | -3 | 3
 | 11 | [NAME] | 7 | 1 | 2 | 4 | 6 | 16 | -10 | 5 | 3 | 0 | 1 | 2 | 3 | 8 | -5 | 1 | 4 | 1 | 1 | 2 | 3 | 8 | -5 | 4
 | 12 | [NAME] | 7 | 1 | 1 | 5 | 6 | 14 | -8 | 4 | 3 | 1 | 1 | 1 | 3 | 3 | 0 | 4 | 4 | 0 | 0 | 4 | 3 | 11 | -8 | 0
 |  | UEFA Champions League
 |  | UEFA Europa League
 |  | Relegation
Spreadsheet: 67211d1267801425-lists-comboboxes-and-lookup-tables-datevalidation
Sheet: Sheet4

Category | Item |  | SHS | RHS | Eq_Angle | Channel
SHS | SHS 1 |  | SHS 1 | RHS 1 | Eq_Angle 1 | Channel 1
Eq_Angle | Eq_Angle 3 |  | SHS 2 | RHS 2 | Eq_Angle 2 | Channel 2
 |  |  | SHS 3 | RHS 3 | Eq_Angle 3 | Channel 3
 |  |  | SHS 4 | RHS 4 | Eq_Angle 4 | Channel 4
 |  |  | SHS 5 | RHS 5 | Eq_Angle 5 | Channel 5
 |  |  |  | RHS 6 | Eq_Angle 6 | Channel 6
 |  |  |  | RHS 7 |  | Channel 7
 |  |  |  | RHS 8 |  | Channel 8
 |  |  |  |  |  | Channel 9
 |  |  |  |  |  | Channel 10
 |  |  |  |  |  | Channel 11
 |  |  |  |  |  | Channel 12
Spreadsheet: 50824d1250314843-keeping-track-of-payments-test
Sheet: Payments

Blue cells are to be invoiced |  | Highlight in green when invoiced |  | Highlight cell in red once paid |  |  |  | Blue cells are to be invoiced |  | Highlight in green when invoiced |  | Highlight cell in red once paid
Plot no. | Fix | Date | Name | Price | Paid | Balance |  | Plot no. | Fix | Invoice No. | Date | Price | Paid | Balance
1 | roof |  |  |  | 50
2 | roof |  |  |  | 50
 |  |  |  |  | 7
Spreadsheet: 328709d1404036327-index-match-if-function-wonder-why-excel-kept-refer-to-the-wrong-want-formula-error-dgk-4
Sheet: BySea

 | JOB NO.
 | SHIPPER/CONSIGNEE
 | POL
 | POD
 | Itemizing Services |  | Unit Selling Price | Qty LCL | Qty 20' | Qty 40' | Total Amount of Billing |  |  | Notes
 |  |  |  |  |  |  | LCL | 20' | 40'
 | Ocean Freight |  |  |  |  |  |  |  |  | SEA FREIGHT CURRENCY
 | Port Charges at Port Klang |  | Unit S.Rate | LCL | 20' | 40' | LCL | 20' | 40'
 | THC |  |  |  |  |  |  |  |  | AS PER RECEIPT.
 | EDI/IID
 | BL/DO
 | Container Cleaning Fee |  |  | 1 | 1 | 1
 | Container Cleaning Fee
 | Custom Clearance Charges |  | Unit S.Rate | LCL | 20' | 40' | LCL | 20' | 40'
 | SMK |  |  |  |  | 1
 | [NAME]
 | CFS/Warehouse Charges |  | Unit S.Rate | LCL | 20' | 40' | LCL | 20' | 40'
 | Storage
 | Heavy Lifting (3Tons & Above)
 | Transportation |  | Unit S.Rate | LCL | 20' | 40' | LCL | 20' | 40'
 | Haulage
 | Side Loader
 | Depot Gate Charges
 | Accessories Charges |  | Unit S.Rate | LCL | 20' | 40' | LCL | 20' | 40'
 | [NAME]
 | [NAME] Hired
 | Overtime (Min 2hrs)
 | Overtime on Weekends
 | Marine Insurance
 | Insurance Stamping Fee