tianzl66/Sheetpedia huggingface dataset:
Spreadsheet: 884898d1734234476-searching-values-within-a-numeric-range-matching-criteria-sample1
Sheet: List1

73.22 | 73.24 | 73.26 | 73.28 | 73.3 | 73.32 | 73.34 | 73.36 | 73.38 | 73.4 | 73.42 | 73.44 | 73.46 | 73.4799999999999 | 73.4999999999999 | 73.5199999999999 | 73.5399999999999 | 73.5599999999999 | 73.5799999999999 | 73.5999999999999
 |  |  |  |  |  |  |  |  | 73.4
 |  |  |  |  |  | 73.34 |  |  |  |  |  |  | 73.4799999999999
 |  |  |  | 73.3 |  |  |  |  | 73.4 |  |  |  |  | 73.4999999999999
Spreadsheet: 188089d1350672882-matching-two-columns-of-data-in-two-different-worksheets-dummy-worksheet
Sheet: TUES, JAN 1

 |  | DAILY DEPOSIT
 |  | Tuesday
 |  | Check Totals
 |  |  | Cash Totals
 |  | Deposit Total
[NAME] |  | clerk2 |  | clerk3 |  | clerk4 |  | clerk5
Checks |  | Checks |  | Checks |  | Checks |  | Checks
No. | Amount | No. | Amount | No. | Amount | No. | Amount | No. | Amount
Checks |  | Checks |  | Checks |  | Checks |  | Checks
Cash |  | Cash |  | Cash |  | Cash |  | Cash
Spreadsheet: 889616d1740492841-automate-numerical-identifier-formula-worked-example-v2
Sheet: Sheet2

 |  | Start No
 |  | 1001
Equipment | Equipment No | Numerical Identifier
Motor | Motor 1 | 1001
Motor | Motor 1 | 1001
Motor | Motor 1 | 1001 | These figures are what I want the formula to formulate automatically using the information in column B. All equipment must start at number in Cell C2. This is to automatically assign a unique numerical number against and equipment but the number shouldn’t change if the equipment is the same. example below
Fan | Fan 1 | 1001
Pump | Pump 1 | 1001
Pump | Pump 2 | 1002
Pump | Pump 2 | 1002 |  | If someone selects Motor 1 = 1001
Gearbox | Motor 1 | 1001 |  | If another Motor 1 is selcted it will also be 1001.
Pump | Pump 2 | 1002 |  | If [NAME] is selected that will NOT be 1002, it will be 1001 because Fan is unique to motor.
Gearbox | [NAME] | 1001 |  | If [NAME] is then selected the formula will know " Motor 1 - 1001" has already occurred and therefore will be 1002.
Gearbox | [NAME] | 1002
Gearbox | [NAME] | 1002
Spreadsheet: 682999d1592419926-conditional-formatting-help-trade-in_questioncf
Sheet: Sheet1

Quote #:
Customer (from quote):
Select your currency | Euro
Section 1
Traded-In Products * comes directly from quote |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | Traded-in Products List Price * look up values on online Pricebook
 | Existing Current Product ID's |  | (total count per product ID that is being traded) | Maint expiration Date | [NAME] (create down down, Quarterly, Monthly, Annual) | Existing Net (total for each product ID) | Choose the Factor 2X or 4X | calcuate the value | Prepaid Maint credit Months | Prepaid Maint Credit from current date | NOT SURE WE NEED THIS? Calculated value (should calculate between 2.0 and 4.0) |  |  |  |  | Pricebook Per Unit For Calculating Effective [NAME] |  |  | Quote quantity x [NAME] | Calculated value
 | Product Number | Product Name | Quantity |  |  | Annual [NAME] |  | Surrender Value |  | calculate G/J | Factor |  |  |  |  | [NAME] | [NAME] |  | Annual ME&S List | Effective [NAME] %
Traded In | NX11110 | Mach 1 | 1 | 2020-12-31 00:00:00 | Monthly | 3506 | 4 |  | 6
Traded In | NX12100 | [NAME] 2 | 1 | 2020-12-31 00:00:00 | Monthly | 4413 | 4 |  | 6
Traded In
Traded In |  |  |  |  | Monthly
Traded In
Traded In
Traded In
Traded In
Traded In
Traded In
Traded In
Traded In
Traded In
Traded In
Traded In
Traded In
Traded In
Traded In
Total
Spreadsheet: 706209d1606530040-a-formula-to-return-values-for-financial-statements-isnt-working-balans-2021
Sheet: Februari

 | Inkomsten |  |  | Uitgaven Maandelijks |  | Uitgaven Eten/drank |  | [NAME] |  |  | Uitgaven OV | Uitgaven gadgets/games/kleding |  |  | Balance
OPENING BALANCE:
2021-02-01 00:00:00 | 5000 | DUO | [NAME] |  |  | 60 |  | 42 |  |  | 26 | 75
 |  |  |  |  |  | 91 |  | 92 |  |  | 24 | 98
 |  |  |  |  |  | 10 |  | 36 |  |  | 13 | 99
 |  |  |  |  |  | 62 |  | 4 |  |  | 34 | 45
 |  |  |  |  |  | 56 |  | 31 |  |  | 84 | 3
 | 3000 | [NAME] | Dirk |  |  | 73 |  | 1 |  |  | 82 | 65
 |  |  |  |  |  | 81 |  | 86 |  |  | 58 | 10
 |  |  |  |  |  | 77 |  | 18 |  |  | 8 | 78
 |  |  |  |  |  | 73 |  | 53 |  |  | 2 | 45
 |  |  |  | 300 | tandarts | 71 |  | 85 |  |  | 79 | 87
 |  |  |  | 500 | school | 73 |  | 26 |  |  | 55 | 37
 |  |  |  | 300 | sportschool | 56 |  | 53 |  |  | 38 | 47
 |  |  |  | 400 | rijbewijs | 12 |  | 55 |  |  | 92 | 92
 |  |  |  |  |  | 10 |  | 92 |  |  | 68 | 84
 |  |  |  |  |  | 52 |  | 6 |  |  | 9 | 26
 |  |  |  |  |  | 87 |  | 51 |  |  | 46 | 79
 |  |  |  |  |  | 45 |  | 31 |  |  | 45 | 19
 |  |  |  |  |  | 3 |  | 22 |  |  | 38 | 69
 |  |  |  |  |  | 46 |  | 74 |  |  | 24 | 47
 |  |  |  |  |  | 65 |  | 91 |  |  | 66 | 46
 |  |  |  |  |  | 18 |  | 13 |  |  | 49 | 50
 |  |  |  |  |  | 51 |  | 25 |  |  | 70 | 7
 | 2000 | Zorgtoeslag | [NAME] | 200 | Spotify | 94 |  | 16 |  |  | 45 | 9
 |  |  |  | 500 | Disney+ | 8 |  | 62 |  |  | 28 | 85
 |  |  |  |  |  | 18 |  | 85 |  |  | 36 | 33
 |  |  |  |  |  | 81 |  | 90 |  |  | 32 | 21
 |  |  |  |  |  | 35 |  | 20 |  |  | 12 | 91
 |  |  |  |  |  | 93 |  | 75 |  |  | 6 | 50
CLOSING BALANCE
 | Inkomsten
 | Uitgaven Maandelijks
 | Uitgaven Eten/drank
 | [NAME]
 | Uitgaven OV
 | Uitgaven gadgets/games/kleding
 | Total Spent
 | Saved/Overspent
Spreadsheet: 783937d1655304742-powerpivot-measure-multiplication-2-tables-measure
Sheet: Sheet1

COST |  |  | ALLOCATION
ID | Cost |  | ID | Region | Allocation |  | Allocated Cost
0001 | 1000 |  | 0001 | A | 0.3
0002 | 250 |  | 0002 | A | 0.8
 |  |  | 0001 | B | 0.45
 |  |  | 0002 | B | 0
 |  |  | 0001 | C | 0.15
 |  |  | 0002 | C | 0.2
 |  |  | 0001 | D | 0.1
 |  |  | 0002 | D | 0
 |  |  |  |  |  |  |  |  | desired outcome
 |  | Column Labels |  |  |  |  |  |  |  | Column Labels
 | Row Labels | A | B | C | D | Grand Total |  |  | Row Labels | A | B | C | D | Grand Total
 | 0001 |  |  |  |  |  |  |  | 0001 | 300 | 450 | 150 | 100
 | 0002 |  |  |  |  |  |  |  | 0002 | 200 | 0 | 50 | 0
 | Grand Total |  |  |  |  |  |  |  | Grand Total
Spreadsheet: 67197d1267792284-whats-best-to-use-macro-or-formulas-book1
Sheet: Overall

 |  |  | Ref | Issue Title | Issue Description | Date Opened | Objective | Deadline | Days Remaining | Open / Closed | Additional Comments
 |  |  | 1 |  |  |  |  |  |  | Closed
 |  |  | 2 |  |  |  |  |  |  | Closed
 |  |  | 3 |  |  |  |  |  |  | Closed
 |  |  | 4 |  |  |  |  |  |  | Open
 |  |  | 5 |  |  |  |  |  |  | Open
 |  |  | 6 |  |  |  |  |  |  | Open
 |  |  | 7 |  |  |  |  |  |  | Closed
 |  |  | 8 |  |  |  |  |  |  | Closed
 |  |  | 9 |  |  |  |  |  |  | Open
 |  |  | 10 |  |  |  |  |  |  | Open
 |  |  | 11 |  |  |  |  |  |  | Open
 |  |  | 12 |  |  |  |  |  |  | Closed
Spreadsheet: kate_symes__18211__EESSales_dailymarch
Sheet: 3-1

NP15 | 2001-03-01 00:00:00 |  |  |  |  |  | SP15 |  |  |  |  |  |  | ZP26
Fixed Peak | 292.89 | Fixed Off Peak | 193 |  |  |  | Fixed Peak | 271.41 |  | Fixed Off Peak | 169.33 |  |  | Fixed Peak | 271.41 |  | Fixed Off Peak | 169.33
Index Peak |  | Index [NAME] |  |  |  |  | Index Peak |  |  | Index [NAME] |  |  |  | Index Peak |  |  | Index [NAME]
HE | Fixed | Other | DJ Index | Load | var |  | HE | Fixed | Other | DJ Index | Load | var |  | HE | Fixed | Other | DJ Index | Load | var
1 | -1.55 | 0 | 0 | -5.55 |  |  | 1 | -56.11 | 0 | 0 | -56.11 |  |  | 1 | -2.01 | 0 | 0 | -2.01
2 | -4.67 | 0 | 0 | -4.67 |  |  | 2 | -52.66 | 0 | 0 | -51.66 |  |  | 2 | -1.97 | 0 | 0 | -1.97
3 | -4.23 | 0 | 0 | -4.23 | 0 |  | 3 | -53.25 | 0 | 0 | -49.25 |  |  | 3 | -1.94 | 0 | 0 | -1.94
4 | -4.16 | 0 | 0 | -4.16 |  |  | 4 | -52.99 | 0 | 0 | -48.99 |  |  | 4 | -1.94 | 0 | 0 | -1.94
5 | -4.5 | 0 | 0 | -4.5 |  |  | 5 | -53.12 | 0 | 0 | -53.12 |  |  | 5 | -1.96 | 0 | 0 | -1.96
6 | -4.02 | 0 | 0 | -7.02 |  |  | 6 | -53.04 | 0 | 0 | -53.04 |  |  | 6 | -2.07 | 0 | 0 | -2.07
7 | -11.08 | 0 | 0 | -11.08 |  |  | 7 | -111.93 | 0 | 0 | -84.93 |  |  | 7 | -2.24 | 0 | 0 | -2.24
8 | -13.4 | 0 | 0 | -13.4 |  |  | 8 | -109.99 | 0 | 0 | -98.99 |  |  | 8 | -2.33 | 0 | 0 | -2.33
9 | -13.54 | 0 | 0 | -13.54 |  |  | 9 | -109.48 | 0 | 0 | -110.48 |  |  | 9 | -2.34 | 0 | 0 | -2.34
10 | -12.26 | 0 | 0 | -12.26 |  |  | 10 | -111.24 | 0 | 0 | -117.24 |  |  | 10 | -2.29 | 0 | 0 | -2.29
11 | -12.25 | 0 | 0 | -12.25 |  |  | 11 | -111.27 | 0 | 0 | -122.27 |  |  | 11 | -2.29 | 0 | 0 | -2.29
12 | -13.37 | 0 | 0 | -13.37 |  |  | 12 | -109.35 | 0 | 0 | -122.35 |  |  | 12 | -2.33 | 0 | 0 | -2.33
13 | -13.19 | 0 | 0 | -13.19 |  |  | 13 | -110.46 | 0 | 0 | -122.46 |  |  | 13 | -2.33 | 0 | 0 | -2.33
14 | -12.68 | 0 | 0 | -12.68 |  |  | 14 | -110.38 | 0 | 0 | -122.38 |  |  | 14 | -2.3 | 0 | 0 | -2.3
15 | -12.18 | 0 | 0 | -12.18 |  |  | 15 | -111.39 | 0 | 0 | -120.39 |  |  | 15 | -2.28 | 0 | 0 | -2.28
16 | -12.36 | 0 | 0 | -12.36 |  |  | 16 | -110.41 | 0 | 0 | -116.41 |  |  | 16 | -2.29 | 0 | 0 | -2.29
17 | -12.77 | 0 | 0 | -12.77 |  |  | 17 | -110.81 | 0 | 0 | -111.81 |  |  | 17 | -2.3 | 0 | 0 | -2.3
18 | -14.75 | 0 | 0 | -14.75 |  |  | 18 | -108.5 | 0 | 0 | -114.5 |  |  | 18 | -2.39 | 0 | 0 | -2.39
19 | -16.69 | 0 | 0 | -16.69 |  |  | 19 | -106.42 | 0 | 0 | -112.42 |  |  | 19 | -2.47 | 0 | 0 | -2.47
20 | -15.11 | 0 | 0 | -15.11 |  |  | 20 | -108.33 | 0 | 0 | -107.33 |  |  | 20 | -2.4 | 0 | 0 | -2.4
21 | -13.76 | 0 | 0 | -13.76 |  |  | 21 | -109.49 | 0 | 0 | -102.49 |  |  | 21 | -2.35 | 0 | 0 | -2.35
22 | -12.34 | 0 | 0 | -12.34 |  |  | 22 | -110.71 | 0 | 0 | -92.71 |  |  | 22 | -2.29 | 0 | 0 | -2.29
23 | -6.98 | 0 | 0 | -9.98 |  |  | 23 | -25.76 | 0 | 0 | -65.76 |  |  | 23 | -2.19 | 0 | 0 | -2.19
24 | -6.44 | 0 | 0 | -7.44 |  |  | 24 | -51.35 | 0 | 0 | -51.35 |  |  | 24 | -2.09 | 0 | 0 | -2.09
Spreadsheet: 704202d1605439474-formula-retrieving-data-from-other-worksheet-when-changing-month-_01-_02-_03-in-a-cell-exampleforformula
Sheet: Output

Product |  | Limestone |  | CB |  | …
MONTH
_01 | Item | QTY/T_01 | COST/T_01 | QTY/T_01 | COST/T_01
_01 for January
(_02 for February, _03 for March etc) |  |  |  | … | …
 |  | … | … | … | …
 |  | … | … | … | …
 | …
 |  | Depending on the Product (C1, E1) & month (cell [NAME]), it should find corresponding data of each item of sheets "Data_Limestone" respective "CB".
 |  | So for example for Month _01 it should find for Product Limestone above values in blue cells
 |  | If I change cell [NAME] to _02 for the month February, it should find corresponding data of February and give it back in the blue colored cells
 |  | And so on.
 |  | Which excel formula withouth [NAME] is able to do this?
 |  |  |  | Which excel formula solves this problem (w/o [NAME])?
Spreadsheet: 478343d1472742962-vlook-up-and-indexing-related-doubts-book21-1-
Sheet: Folha1

SI no | ID no | name | project code | Project Name | Percentage
1 | A-1 | xxxx | 123 | 123Project | 53
2 | A-1 | xxxx | 125 | 125Project | 28
3 | A-1 | xxxx | 128 | 128Project | 19
4 | A-2 | yyyy | 123 | 123Project | 26
5 | A-2 | yyyy | 125 | 125Project | 34
6 | A-2 | yyyy | 128 | 128Project | 35
7 | A-2 | yyyy | 129 | 129Project | 5
8 | A-3 | zzzz | 123 | 123Project | 45
9 | A-3 | zzzz | 129 | 129Project | 35
10 | A-3 | zzzz | 124 | 124Project | 20
11 | A-4 | kkkk | 124 | 124Project | 60
12 | A-3 | zzzz | 125 | 125Project | 40
ID no | name | project code | Project Name
A-1
A-2
A-3
A-4
Spreadsheet: mary_fischer__25616__34L
Sheet: E36.XLS

ENRON CORP AND CONSOLIDATED SUBSIDIARIES
COMPANY # 034L
COMPANY NAME   Enron EES Acquisition I Corp
EQUITY INVESTEE'S SUMMARIZED INFORMATION
FOR THE 3 MONTHS ENDED 6-30-2001
PREPARED BY: [NAME]
EXTENSION: 52580
 |  |  |  | E-36
NAME OF INVESTEE:
% OF OWNERSHIP:
THIS E-SCHEDULE IS REQUIRED FOR ALL OWNED EQUITY INVESTEES.
Please note the relationship and the differences between the E-3 (Analysis of Investment in Unconsolidated Equity Subsidiaries) and the E-36 (Equity
Investee's Summarized Information).  The E-3 seeks details of the Enron consolidating subsidiaries' (i.e. the investor) investment account.  The E-36
seeks summarized income statement and balance sheet information of the unconsolidated subsidiary (i.e. the investee).
If an E-3 has been prepared for an equity investment, then an E-36 for the related in investee needs to be completed.
Include all investees, regardless of Enron's ownership interest.
PLEASE PROVIDE THE FOLLOWING SUMMARIZED FINANCIAL INFORMATION AS IT
WOULD APPEAR IN THE INVESTEE'S FINANCIAL STATEMENTS (100%).
 |  |  |  | BALANCE AT
BALANCE SHEET (100%) |  |  |  | END OF QUARTER
CURRENT ASSETS |  |  |  | 0
PROPERTY, PLANT AND EQUIPMENT, NET. |  |  |  | 0
OTHER NONCURRENT ASSETS |  |  |  | 0
CURRENT LIABILITIES |  |  |  | 0
LONG-TERM DEBT |  |  |  | 0
ADVANCES FROM ENRON COMPANIES |  |  |  | 0
OTHER NON-CURRENT LIABILITIES |  |  |  | 0
OWNERS' EQUITY |  |  |  | 0
Memo:
AMOUNT RECEIVABLE FROM ENRON (included above) |  |  |  | 0
AMOUNT PAYABLE TO ENRON (included above) |  |  |  | 0
INVESTMENT IN UNCONSOLIDATED
EQUITY INVESTEE
(must tie to Hyperion acct TOT_INVEST_SUBS & E-3) |  | 0
Asset/Expense Accts:  DR/(CR)
INCOME STATEMENT (100%) |  |  |  | YEAR-TO-DATE
OPERATING REVENUES |  |  |  | 0
OPERATING EXPENSES |  |  |  | 0
GROSS INTEREST EXPENSE (3rd Party Only) |  |  |  | 0
OTHER INCOME & DEDUCTIONS |  |  |  | 0
INCOME TAXES |  |  |  | 0
NET INCOME
INVESTMENT IN NET INCOME
(must tie to Hyperion acct TOT_EQEARN_OTH & E-3) |  | 0
Income Accts:  DR/(CR)
Memo:
CAPITALIZED INTEREST |  |  |  | 0
RENTAL EXPENSE |  |  |  | 0
 |  |  |  | E-36
Spreadsheet: 107424d1304599166-need-formula-for-a-macro-function-example
Sheet: 2

935
Name | Amount
Name 1 | 102
Name 3 | 158
Name 2 | 150
Name 1 | 136
Name 2 | 191
Name 1 | 116
Name 3 | 157
Name 2 | 112
Name 3 | 121
Name 1 | 172
Name 1 | 131
Name 3 | 138
Name 2 | 174
Name 1 | 172
Name 3 | 116
Name 3 | 127
Name 3 | 108
Name 2 | 104
Name 1 | 106
Name 3 | 150
Name 3 | 155
Name 3 | 108
Name 3 | 140
Name 3 | 110
Name 3 | 159
Spreadsheet: sara_shackleton__36501__ENE MTM 0630 revised 2
Sheet: MLCO 6-28

Current Date
Termination Date
Interest Payment Date
Quarter End Date
Lowest Date
Phantom Stock Hedge |  | Effective Date | 2000-06-28 00:00:00
MLCO |  | Termination Date | 2001-06-20 00:00:00
 |  |  |  | Total |  |  |  | Total |  |  |  | Total |  |  |  |  |  | Total |  |  |  | Total
 |  |  | Quarter End | Quarter End |  | Quarter End | Quarter End | Quarter End |  | Quarter End | Quarter End | Quarter End |  |  |  | Quarter End | Quarter End | Quarter End |  | Quarter End | Quarter End | Quarter End
ENE |  |  | 2000-06-30 00:00:00 | 2000-06-30 00:00:00 |  | 2000-09-30 00:00:00 | 2000-09-30 00:00:00 | 2000-09-30 00:00:00 |  | 2000-12-31 00:00:00 | 2000-12-31 00:00:00 | 2000-12-31 00:00:00 |  | Year 2000 |  | 2001-03-31 00:00:00 | 2001-03-31 00:00:00 | 2001-03-31 00:00:00 |  | 2001-06-30 00:00:00 | 2001-06-30 00:00:00 | 2001-06-30 00:00:00 |  | Year 2001 |  | LTD
 | Market Price
Shares: | 110100
Opening price
Interest Payment Dates |  |  | 2000-07-28 00:00:00 |  |  | 2000-07-28 00:00:00 | 2000-08-24 00:00:00 |  |  | 2000-08-24 00:00:00 | 2000-08-24 00:00:00 |  |  |  |  | 2000-08-24 00:00:00 | 2000-08-24 00:00:00 |  |  | 2000-08-24 00:00:00 | 2000-08-24 00:00:00
Equity Payment (CSFB pays if price goes up/Enron pays if price goes down)
 | Opening value
 | Closing Value
 | MTM
Dividend Payment (CSBI pays)
Expected quarterly dividend |  |  | 0 |  |  | 0 |  |  |  | 0.125 |  |  |  |  |  | 0.125 |  |  |  | 0.125
Payment
6.2925
Interest Payment (Enron pays)
Interest Rate |  | (need rate) | 0.0661 |  |  |  | 0.0609 |  |  |  | 0.0609 |  |  |  |  |  | 0.0609 |  |  |  | 0.0609
Spread |  |  | 0.006
All in Rate
Annual Day Count |  |  | 360 |  |  | 360 | 360 |  |  | 360 | 360 |  |  |  |  | 360 | 360 |  |  | 360 | 360
Beginning of period
End of period
Day Count
Payment
Net receipt/(payment)
Spreadsheet: 881806d1729993726-how-to-have-return-results-of-a-function-split-across-multiple-lines-testfile
Sheet: Misc Stats

Customer Agents
Client-1 | Client-2 | Client-3 | [NAME] | HidFAST | CSMI | Doble | Leemco | Ganesh Imports | AllenTech
AGT-2 | AGT-2 | AGT5
AGT-3 | AGT6
AGT-4
Spreadsheet: 02fe0be7-b42d-4032-9a05-c68000232403
Sheet: MayAug 2013

 |  | 2013 SMU-in-TAOS
 |  | How Much Does It Cost?
 | MAY & AUGUST INTER-TERMS
 | May Inter-Term:  May 15 - June 1  (approximately 17 days in length)
 | August Inter-Term:  August 5 - 22  (approximately 17 days in length)
 |  |  |  | 3 Credit Hours |  |  | 4 Credit Hours
 |  |  |  | (1 Course) |  | (1 Course + Mountain Sports)
 | Academic Tuition |  |  | 2670 | (3 @ $890) |  | 3560 | (4 @ $890)
 | Academic Course Fee |  |  | 150 |  |  | 150
 | [NAME] |  |  | 750 |  |  | 750
 | Board (Meal Plan) |  |  | 795 |  |  | 795
 | Mountain Sports Course Fee |  |  | 0 |  |  | 750
 | TOTAL * |  |  | 4365
 | * Add $75 for Semi-Private Room, depending upon availability.
 | ENGINEERING SCHOOL SPECIAL STUDIES
 | Extended August Inter-Term
 | July 28 - August 22  (approximately 25 days in length)
 |  |  |  | 6 Credit Hours |  |  | 7 Credit Hours
 |  |  |  | (2 Courses) |  | (2 Courses + Mountain Sports)
 | Academic Tuition |  |  | 5340 | (6 @ $890) |  | 6230 | (7 @ $890)
 | Academic Course Fee |  |  | 300 | (2 @ $150) |  | 300 | (2 @ $150)
 | [NAME] |  |  | 1054 |  |  | 1054
 | Board (Meal Plan) |  |  | 1143 |  |  | 1143
 | Mountain Sports Course Fee |  |  | 0 |  |  | 750
 | TOTAL * |  |  | 7837
 | * Add $120 for Semi-Private Room, depending upon availability.
Spreadsheet: 692423d1598331394-excel-formula-to-calculate-employee-benefits-employee-benefits-2
Sheet: PAYROLL

Date | Period | Employee Code Number | Employee Name | Employee I.D Number | Age | Elderly benefit | Disability benefit | Vehicle Engine Capacity | Motoring Benefit
2020-01-20 00:00:00 | 1 | CA1
2020-01-20 00:00:00 | 1 | CA2
2020-01-20 00:00:00 | 1 | CA3
2020-01-20 00:00:00 | 1 | CA4
2020-01-20 00:00:00 | 1 | CA5
2020-01-20 00:00:00 | 1 | CA6
I am asking for the formula to calculate disiability and motor vehicle benefits
Desired outcome
Date | Period | Employee Code Number | Employee Name | Employee I.D Number | Age | Elderly benefit | Disability benefit | Vehicle Engine Capacity | Motoring Benefit
2020-01-20 00:00:00 | 1 | CA1 |  |  |  | 0 | 720 |  | 1800
2020-01-20 00:00:00 | 1 | CA2 |  |  |  | 720 |  |  | 2400
2020-01-20 00:00:00 | 1 | CA3 |  |  |  | 720 | 720 |  | 4800
2020-01-20 00:00:00 | 1 | CA4 |  |  |  | 0 |  |  | 0
2020-01-20 00:00:00 | 1 | CA5 |  |  |  | 0 |  |  | 0
2020-01-20 00:00:00 | 1 | CA6 |  |  |  | 0 |  |  | 3600
Spreadsheet: 606216d1547538999-how-to-use-if-and-with-text-contain-profit-share
Sheet: Sheet1

SHEET 1 |  |  |  |  |  | SHEET 2
WP004188 | Destination | 100 |  |  |  | WP004210
WP004188 | Profit Share | 125 |  |  |  | WP004120
WP004140 | Destination | 150 |  |  |  | WP004107
WP004140 | Profit Share | 135 |  |  |  | WP004127
WP004150 | Destination | 140 |  |  |  | WP004197
WP004150 | Profit Share | 132 |  |  |  | WP004206
WP004210 | Destination | 50 |  |  |  | WP004188
WP004210 | Profit Share | 75 |  |  |  | WP004209
WP004120 | Destination | 80 |  |  |  | WP004140
WP004120 | Profit Share | 95 |  |  |  | WP004150
WP004107 | Destination | 105
WP004107 | Profit Share | 110
WP004127 | Destination | 175
WP004127 | Profit Share | 170
WP004197 | Destination | 145
WP004197 | Profit Share | 137
WP004209 | Destination | 115
WP004209 | Profit Share | 120
WP004206 | Destination | 85
WP004206 | Profit Share | 97
Spreadsheet: 2cbb4e69-54ef-46f7-a53d-e9379eab32d9
Sheet: Sheet1

Table KS13 Qualifications and Students | Unnamed: 1 | Unnamed: 2 | Unnamed: 3 | Unnamed: 4 | Unnamed: 5
Key Statistics for Birmingham 2006 Districts and 2004 Wards.*
Key Statistics provide headline results about the main Census topics and facilitate comparisons between different areas.
The dataset contains around 380 statistics for each area.  The districts are those in place at 23rd May 2006.
* Best Fit Approximations issued by the Office for National Statistics in December 2004
Results for new wards are based on allocation of whole Census Output Areas.
Data for any Census Output Area that is split by a new ward boundary are allocated to the ward that contains the greatest
share of its population.
For reasons of confidentiality, National Statistics have altered the published results where very small numbers of people in an area fall into any of the categories in a table  (e.g. persons in a Birmingham ward working in the fishing industry). This means that:
- Population and household totals may vary among tables
- Published figures for a larger area may not match the sum of results for its smaller constituent parts.
For more information please visit our website: www.birmingham.gov.uk or the National Statistics Website:
www.statistics.gov.uk/neighbourhood
Copyright and Conditions of Use
The material presented is derived from the 2001 Census Area Statistics.  All census material is Crown Copyright.  Birmingham Council has a 'click user licence' issued by Her [NAME]'s Stationary Office.  This allows the re-use and publication of Census data.
 | Persons and organisations outside the City Council should check whether they need to obtain a licence to use and publish the data.  More information can be obtained from the national census website or from her [NAME]'s Stationary Office (HMSO):
http:/www.hmso.gov.uk/click-use-home.htm                                                                                                                                     HMSO,The Licensing Division, St Clements House,                                                                                                                                        2 to 16 Colegate, [NAME], NRS 1BQ(tel 01603 621000)
2001 Census Statistics incorporate measures to protect against the inadvertent disclosure of information relating specifically to an identified person or household.  The material should not be used to attempt to derive information relating specifically to an identified person or household nor should a claim be made that such information has been obtained or derived.
 |  |  |  |  | Development Directorate Demographic Information Service
Source: 2001 Census, [Key Statistics for Local Authorities].  Crown
copyright 2006. Crown copyright material is reproduced with the permission
of the [NAME] of HMSO .
Spreadsheet: 804013d1667842057-formula-to-create-a-date-from-a-cell-value-date-help
Sheet: Data

PASTE | PASTE | PASTE | PASTE | FORMULA
Date | Transaction ID | Amount | Currency | Dupe? | Correct Date | [NAME]
2022-05-11 00:00:00 |  | 250 | USD
2022-02-11 00:00:00 |  | 250 | USD
30/10/2022 |  | 175 | USD
29/10/2022 |  | 125 | USD
28/10/2022 |  | 75 | USD
27/10/2022 |  | 50 | USD
27/10/2022 |  | 35 | USD
27/10/2022 |  | 25 | USD
26/10/2022 |  | 15 | USD
26/10/2022 |  | 15 | USD
26/10/2022 |  | 10 | USD
26/10/2022 |  | 7 | USD
26/10/2022 |  | 5 | USD
26/10/2022 |  | 3 | USD
26/10/2022 |  | 3 | USD
26/10/2022 |  | 2 | USD
26/10/2022 |  | 2 | USD
26/10/2022 |  | 2 | USD
2022-02-11 00:00:00 |  | 600 | USD
31/10/2022 |  | 400 | USD
29/10/2022 |  | 250 | USD
29/10/2022 |  | 175 | USD
28/10/2022 |  | 125 | USD
28/10/2022 |  | 75 | USD
28/10/2022 |  | 75 | USD
27/10/2022 |  | 50 | USD
26/10/2022 |  | 35 | USD
26/10/2022 |  | 25 | USD
25/10/2022 |  | 15 | USD
25/10/2022 |  | 15 | USD
25/10/2022 |  | 10 | USD
25/10/2022 |  | 7 | USD
25/10/2022 |  | 5 | USD
25/10/2022 |  | 3 | USD
25/10/2022 |  | 3 | USD
25/10/2022 |  | 2 | USD
25/10/2022 |  | 2 | USD
25/10/2022 |  | 2 | USD
Spreadsheet: 168026d1342192826-excel-2007-making-formulas-based-on-the-fill-of-a-cell-ef120_windows-playing-formula
Sheet: Sheet4

42 | Killfield | Morris | 12 | 2012-06-02 00:00:00
44 | Killfield | Durrant | 12 | 2012-06-02 00:00:00
Rabbits | Killfield | [NAME] | 15 | 2012-06-02 00:00:00
123 | [NAME] | Jenkins | 12 | 2012-06-02 00:00:00
125 | [NAME] | Anne/Pete | 10 | 2012-06-02 00:00:00
Vineyards | Backinstone Lane | [NAME] | 20 | 2012-06-02 00:00:00 |  |  |  | Owes £50
39 | [NAME] | [NAME] | 7 | 2012-06-02 00:00:00
41 | [NAME] | [NAME] | 7 | 2012-06-02 00:00:00