tianzl66/Sheetpedia huggingface dataset:
Spreadsheet: sally_beck__33745__June Delainey Report
Sheet: Summary Volume Stats

ENRON NORTH AMERICA - ENERGY OPERATIONS
TRANSACTION COUNTS AND VOLUMETRIC INFORMATION FOR THE YEAR 2000
 | New Deals (1) |  |  |  |  |  |  |  |  |  |  |  |  |  |  | % Increase |  |  |  |  |  |  |  |  |  | Feb
 |  |  | 2000-01-01 00:00:00 | 2000-02-01 00:00:00 | 2000-03-01 00:00:00 | 2000-04-01 00:00:00 | 2000-05-01 00:00:00 | 2000-06-01 00:00:00 | 2000-07-01 00:00:00 | 2000-08-01 00:00:00 | 2000-09-01 00:00:00 | 2000-10-01 00:00:00 | 2000-11-01 00:00:00 | 2000-12-01 00:00:00 |  | New Deals |  | Active Deals |  |  |  |  |  |  |  | Mar
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | Apr
 | Natural Gas - Houston |  | 8698 | 10541 | 16886 | 14536 | 15918 | 16455
 | Natural Gas - Calgary |  | 3264 | 3731 | 4386 | 3507 | 5329 | 4863
 | Power |  | 12413 | 12595 | 15886 | 15208 | 16350 | 15453
 | Financial (a) |  | 8846 | 10406 | 14613 | 12550 | 22084 | 28888
 | Total
 | Active Deals (2) |  |  |  |  |  |  |  |  |  |  |  |  |  |  | % Increase |  |  |  |  |  |  |  |  |  | Feb
 |  |  | 2000-01-01 00:00:00 | 2000-02-01 00:00:00 | 2000-03-01 00:00:00 | 2000-04-01 00:00:00 | 2000-05-01 00:00:00 | 2000-06-01 00:00:00 | 2000-07-01 00:00:00 | 2000-08-01 00:00:00 | 2000-09-01 00:00:00 | 2000-10-01 00:00:00 | 2000-11-01 00:00:00 | 2000-12-01 00:00:00 |  | New Deals |  | Active Deals |  |  |  |  |  |  |  | Mar
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | Apr
 | Natural Gas - Houston |  | 12808 | 15431 | 15300 | 16154 | 15394 | 15460
 | Natural Gas - Calgary |  | 4087 | 4767 | 4411 | 4624 | 5532 | 5341
 | Power |  | 11788 | 10536 | 13715 | 14000 | 18028 | 16712
 | Financial (a) |  | 13469 | 16360 | 17948 | 16663 | 18199 | 21573
 | Total
 | Total Physical [NAME] (in millions)
 |  | Unit of |  |  |  |  |  |  |  |  |  |  |  |  |  | % Increase |  |  |  |  |  |  |  |  |  | Feb
 |  | Measure | 2000-01-01 00:00:00 | 2000-02-01 00:00:00 | 2000-03-01 00:00:00 | 2000-04-01 00:00:00 | 2000-05-01 00:00:00 | 2000-06-01 00:00:00 | 2000-07-01 00:00:00 | 2000-08-01 00:00:00 | 2000-09-01 00:00:00 | 2000-10-01 00:00:00 | 2000-11-01 00:00:00 | 2000-12-01 00:00:00 |  | New Deals |  | Active Deals |  |  |  |  |  |  |  | Mar
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | Apr
 | Natural Gas - Houston | MMBtu / day | 16.41932316129032 | 16.59881244827586 | 17.54829174193548 | 17.5065566 | 18.19183722580645 | 20.28338576666667
 | Natural Gas - Calgary | MMBtu / day | 4.016 | 4.569 | 5.657 | 6.016 | 6.361 | 6.3
 | Total Natural Gas | MMBtu / day
 | Power | [NAME] / day
 | Coal | Ton / day
 | Pulp and Paper | MT / day
 | (1) New Deals represent all trades that are initiated during the month, which will result in a confirmation being sent to the counterparty.
 | (2) Active Deals represent all liquidated trades which will result in a settlement (ie. Invoice or payment) during the month.
 | (a)  Financial Deals include Gas, Liquids, FX / Int, Weather and Pulp & Paper.
Spreadsheet: 0c3c9b9a-1f3b-4534-8710-c3366ecd187c
Sheet: Sheet1

Unnamed: 0 | Unnamed: 1 | Unnamed: 2 | Unnamed: 3 | Unnamed: 4 | Unnamed: 5
Winners Bracket
D'Posse
10:00  Red (1
PF Flyers |  |  |  |  | 8 Teams
 | 12:00 Blue  (7
Coors Light
10:00  Yellow (2
Oddfellows Out
 |  | 3:00 Red   (11
Warped Softball
10:00  Blue (3
Bears Den
 | 12:00 Yellow  (8
ChiTown Rockers
10:00  Green (4
Kum & Go |  |  |  | 5:00 Red  (14
 | Loser's | Bracket |  |  | If Game
 |  |  | L-11
 | L-8 |  |  |  | 6:00  Red (15
L-1 | 2:00 Red (10 |  | 4:00  Red (13
12:00 Green  (5
L-2 |  | 3:00  Green (12
 | L-7
[NAME] | 2:00  Green (9
 |  |  |  |  | L-14
12:00 Red  (6
L-4
Spreadsheet: 180167d1347497850-copy-text-to-different-tab-depending-on-pull-down-selection-ef187_excelexperts
Sheet: BBB

match |  | Name on Acct | Acct # | State | Agent | Received from | Notes |  | BBB
Spreadsheet: 714997d1611503157-formula-for-closing-balance-copie-de-forum-excel-24-jan-2021
Sheet: Épargnes Inv.

1) | [NAME] for latest balance (cells D6 to D9) |  |  |  |  | Thanks again for taking the time:) !! I appreciate it!
2) | [NAME] to update CLOSING BALANCE after each deposit/withdrawal and ANNUAL REPORT (Column G)
3) | [NAME] to know profit loss on the "ANNUAL REPORT" (Column F)
 | Solde actuel des comptes: | RED | [NAME]??
 |  | BLUE
 |  | YELLOW
 |  | GREEN
DATE | Description | ACCOUNT | AMOUNT | BALANCE REPORT | PROFIT/ LOSS | CLOSING BALANCE
2020-01-10 00:00:00 | Deposit | AR | 200 |  |  | FORMULA???
2020-03-01 00:00:00 | Deposit | FT | 300
2020-03-05 00:00:00 | Withdrawal | AR | -30
2020-03-11 00:00:00 | Withdrawal | FT | -45
2020-03-13 00:00:00 | Withdrawal | AR | 20
2020-06-15 00:00:00 | Withdrawal | AR | -50
2020-06-15 00:00:00 | Withdrawal | FT | -60
2020-07-01 00:00:00 | Semestrial report (balance now at 200$) | AR | 0 | 200 | 60 |  | Expected result would be 200$ (cell G19 "140$" + cell F21 "60$")
2020-07-01 00:00:00 | Semestrial report (balance now at 280$) | FT | 0 | 320
2021-01-01 00:00:00 | Semestrial report (balance now at 270$) | AR |  | 270
2021-01-01 00:00:00 | Semestrial report (balance now at 350$) | FT |  | 350
Spreadsheet: 494807d1482766866-i-need-to-hide-the-n-a-with-blanks-but-the-chart-does-not-show-value-has-zero-chart-solution
Sheet: Sheet1

2006-11-21 00:00:00 | 2006-11-22 00:00:00 | 2006-11-23 00:00:00 | 2006-11-24 00:00:00 | 2006-11-25 00:00:00 | MASK
0.03 | 0.25 | #N/A | 0.4444444444444444 | #N/A | #N/A
3 | 50 | 0 | 40 | #N/A | 0
100 | 200 | 0 | 90 | #N/A | #N/A
Spreadsheet: benjamin_rogers__1173__Wilton_New - GE 7EA
Sheet: Debt Amortization

Debt Amortization
EBITDA
DSCR - Tranche A
DSCR - Tranche B
DSCR - Tranche C
Interest Rate For Period, Tranche A
Interest Rate For Period, Tranche B
Interest Rate For Period, Tranche C
Total Annual CFAFDS
NPV of CFAFDS Tranche A
NPV of CFAFDS Tranche B
NPV of CFAFDS Tranche C
NPV of Total CFAFDS
Tranche A
Beginning Balance
Interest
Principal
Total Debt Service
Ending Balance
Average Life (years)
Tranche B
Beginning Balance
Interest
Principal
Total Debt Service
Ending Balance
Average Life (years)
Tranche C
Beginning Balance
Interest
Principal
Total Debt Service
Ending Balance
Average Life (years)
TOTAL ANNUAL DEBT AMORTIZATION
Beginning Balance
Interest
Principal
Total Debt Service
Ending Balance
Average Life (years)
Check
ALTERNATE DEBT STRUCTURE
TRANCHE 1
Beginning Prinipal
Interest Rate
Term
 |  | Project Period
Beginning Balance
Interests
Principal Payments
Debt Service
Ending Balance
Average Life (years)
 |  | Percentage of Principal Repaid |  | 0.25 | 0.25 | 0.25 | 0.25 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0
TRANCHE 2
Beginning Prinipal
Interest Rate
Term
 |  | Project Period
Beginning Balance
Interests
Principal Payments
Debt Service
Ending Balance
Average Life (years)
 |  | Percentage of Principal Repaid |  | 0 | 0 | 0.05 | 0.1 | 0.1 | 0.1 | 0.1 | 0.1 | 0.2 | 0.25 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0
TRANCHE 3
Beginning Prinipal
Interest Rate
Term
 |  | Project Period
Tranche A
Beginning Balance
Interests
Principal Payments
Debt Service
Ending Balance
Average Life (years)
 |  | Percentage of Principal Repaid |  | 0 | 0 | 0 | 0 | 0.02 | 0.02 | 0.03 | 0.03 | 0.03 | 0.04 | 0.04 | 0.05 | 0.05 | 0.05 | 0.05 | 0.05 | 0.1 | 0.12 | 0.15 | 0.17 | 0 | 0 | 0 | 0 | 0
Spreadsheet: 833118d1686796601-censor-email-addresses-partially-rooka1-email-censor-in-excel
Sheet: Sheet1

Client Name | Email address from files | Example of partially censored email address | Version 1 | Version 2 | Version 3
[NAME] | [EMAIL] | R****[EMAIL]
[NAME] | [EMAIL] | S*****[EMAIL]
[NAME] | [EMAIL] | J****h@d*****.com
Spreadsheet: 9693c14f-fc6d-4671-aa4a-a0e38e60e99b
Sheet: Sheet1

Battle ID | Date & Time | Side | Victory | Score | Opp. Score | Opp. ID | Opp. Name | Scenario ID | Front | Start Date | End Date | Name EN | Name FR
44020865 | 2014-11-14 20:03:51 | ALLIES | 1 | 7 | 4 | 752090 | lespieuch | 7668 | pacific | 1945-02-26 | 1945-03-06 | The Meat Grinder | Le Hachoir à viande
44021408 | 2014-11-14 20:31:31 | AXIS | 1 | 7 | 4 | 752090 | lespieuch | 7668 | pacific | 1945-02-26 | 1945-03-06 | The Meat Grinder | Le Hachoir à viande
44096912 | 2014-11-19 21:58:08 | AXIS | 1 | 6 | 2 | 1236591 | [NAME] | 6152 | western | 1944-12-20 | 1944-12-22 | [NAME] | St. Vith
44097249 | 2014-11-19 22:13:58 | ALLIES | 1 | 6 | 3 | 1236591 | [NAME] | 6152 | western | 1944-12-20 | 1944-12-22 | [NAME] | St. Vith
44134125 | 2014-11-22 18:41:40 | AXIS | 1 | 10 | 8 | 676105 | Didji | 7662 | eastern | 1942-10-22 | 1942-10-22 | Red Barricades Factory | Les Barricades Rouges
44135450 | 2014-11-22 20:18:49 | ALLIES | 1 | 10 | 7 | 676105 | Didji | 7662 | eastern | 1942-10-22 | 1942-10-22 | Red Barricades Factory | Les Barricades Rouges
44194416 | 2014-11-26 22:18:14 | AXIS | 1 | 10 | 2 | 954955 | [NAME] | 7662 | eastern | 1942-10-22 | 1942-10-22 | Red Barricades Factory | Les Barricades Rouges
44195583 | 2014-11-26 23:39:34 | ALLIES | 0 | 6 | 10 | 954955 | [NAME] | 7662 | eastern | 1942-10-22 | 1942-10-22 | Red Barricades Factory | Les Barricades Rouges
Spreadsheet: 99583d1298203573-freeze-panes-in-excel-2007-sample
Sheet: Sheet1

Vehicle | Per KM
[NAME] | 8
[NAME] | 7 |  | Guide Charge/Person
GM Travera | 7.5 |  | 0
Toyota [NAME] | 6.5 |  | 50
Tempo Traveller | 7.5
Food Expense/Day/Persom |  |  | Vehicle Rent | Per Day
300 |  |  | [NAME] | 1000
 |  |  | [NAME] | 800
Drinks/Person | Expense |  | GM Travera | 1200
Beer | 250 |  | Toyota [NAME] | 900
Wine | 350 |  | Tempo Traveller | 900
[NAME] | 230
Whiskey | 450 |  | Safari Charges/Person
Brandi | 100 |  | 0
[NAME] | 120 |  | 100
None | 0
Trekking Charge/Person | Expense |  | Hotel Room/Person | Expense
Water Bottles | 20 |  | Normal | 250
Food | 100 |  | Luxory | 500
Tent | 50
Carpet | 250
None | 0
Spreadsheet: 772315d1647196206-if-function-too-many-arguments-feature-valuation
Sheet: valueMapping

Usage | Monetization | Summary | Value index | Description
 |  | High usage, positive correlation with monetization | TO BE PRIORITIZED | Likely your most valuable features. Ensure these features are prioritized when it comes to resolving bugs and future enhancements.
 |  | High usage, negative correlation with monetization | TO BE INVESTIGATED | Customers use them so there is a need, but once used, they appear to correlate negatively. These are features that appear to fall short of your users’ expectation and cause them to renew at a lower rate; you should investigate if the feature experience is broken.
 |  | Low usage, positive correlation with monetization | TO BE PROMOTED | The minority of users that discover this feature renew at a higher than average rate, so investing in discoverability of this feature could potentially drive additional monetization.
 |  | Low usage, negative correlation with monetization | TO BE DEPRECATED | Likely your least valuable feature that is not highly used, and when used, correlates negatively with renewal rates. Consider deprecating feature to allow you to focus on the other quadrants.
% of Users | % of Renewed users | Usage | Monetization | Column1
0 - 49 | 60-79
50-100 | 60-79
0 - 49 | 80-100
50-100 | 80-100
Spreadsheet: 845745d1697113237-index-of-non-empty-cells-match-input-with-pool-of-texts-or-word-bank-excelforum3-updated
Sheet: Headcount

Company Names | No. |  |  |  | to be Dynamic List of Companies from Column A | Sum Of Head Count
MASSADR | 1 |  |  |  | ALYUSR INDUSTRIAL CONTRACTING CO.
ACIC | 3 |  |  |  | ARABIAN CONSOLIDATED INDUSTRIAL CLEANING CO. (TANDHEEF)
ACT |  |  |  |  | Arabian Consolidated Trading Est.
ACT | 3 |  |  |  | Arabian Pipeline & Services Co. Ltd (ANABEEB)
AYTB | 7 |  |  |  | Binzagr (BFIM)
Anabeeb (V-7645 Chemical Cleaning) |  |  |  |  | Eram Contracting Est.
AYTB | 12 |  |  |  | HI TECH
AYTB | 40 |  |  |  | JADARRAH
Binzagr | 10 |  |  |  | JAL Human Resources Company (JHR)
ERAM Engr. |  |  |  |  | Massadr Human Resource Services Company
BFIM | 10 |  |  |  | Plantech
ERAM |  |  |  |  | LIMOSINA
HI TECH | 25
[NAME]
[NAME] | 2
[NAME]
JADDARAH | 1
[NAME]
JAL
JAL HR | 1
LIMOSINA - (Contractors) | 1
LIMOUSINA
PLANT-TECH (Cleaning)
PLANT-TECH (IP-X093) | 8
Spreadsheet: 766031d1643729161-using-sumif-to-look-for-anything-where-the-first-4-characters-are-all-numbers-sample
Sheet: Summary

 |  |  | Week | 04
 | Sessions |  |  | Revenue |  |  | [NAME] |  |  | Conversion |  |  | Transactions
[NAME]
Back in Stock (EWIS)
Basket/Recovery
Lapsing
Reactivation
Welcome
CRM Total
APP Total
BAU Total
Spreadsheet: 701281d1603691490-looking-for-a-formula-to-count-the-number-of-times-a-specific-value-appears-in-sequence-in-sample-5
Sheet: Master_Dont_Touch

Positive | Negative | False/Fail | 1 | Answer Im Looking for
 | 1 |  |  |  |  | I want to count the number of times Column B has a value, while ignoring the values in Column C , A value I Column A is what halts the sequence. AliGW was good enough to write the formula in yellow for me for a totally different application . I have been trying to get it to work hear with helper rows etc , but Im stuck Answers Im after are in Column E--Thanks in anticipation
1
 |  | 1
 |  | 1
 | 1
 | 1
 |  | 1
 | 1
 | 1
 | 1 |  |  |  | 5
 |  | 1
 |  | 1
 |  | 1
1
 | 1
 |  | 1
 | 1
 | 1 |  |  |  | 3
1
1
 | 1
 | 1
 | 1
 |  | 1
 | 1
 | 1
 | 1 |  |  |  | 6
Spreadsheet: 812570d1673257324-count-with-two-conditions-book1
Sheet: COUNT

Districts | No | Resolved | In Progress | Unresolved
Delta Fly |  | Count result | count result | count result |  | Count project status for this district
Middle Fly |  | Count result | count result | count result
North Fly |  |  | count result | count result
South Fly |  | Count result | count result | count result
Spreadsheet: 0d2603a3-9f96-43e7-9bc7-5d47a2cf9923
Sheet: Balance Sheet

Lockheed [NAME]
Consolidated Balance Sheets
(unaudited; in millions, except par value)
 |  | March 30, 2014 |  | Dec. 31, 2013
Assets
Current assets
Cash and cash equivalents |  | 3264 |  | 2617
Receivables, net |  | 6255 |  | 5834
Inventories, net |  | 2949 |  | 2977
Deferred income taxes |  | 1135 |  | 1088
Other current assets |  | 631 |  | 813
Total current assets |  | 14234 |  | 13329
Property, plant, and equipment, net |  | 4612 |  | 4706
Goodwill |  | 10370 |  | 10348
Deferred income taxes |  | 2782 |  | 2850
Other noncurrent assets |  |  |  | 4955
Total assets |  | 36919 |  | 36188
Liabilities and stockholders' equity
Current liabilities
Accounts payable |  | 1942 |  | 1397
Customer advances and amounts in excess of costs incurred |  | 6197 |  | 6349
Salaries, benefits, and payroll taxes |  | 1722 |  | 1809
Other current liabilities |  |  |  | 1565
Total current liabilities |  | 11995 |  | 11120
Accrued pension liabilities |  | 9438 |  | 9361
Other postretirement benefit liabilities |  | 902 |  | 902
Long-term debt, net |  | 6152 |  | 6152
Other noncurrent liabilities |  | 3632 |  | 3735
Total liabilities |  | 32119 |  | 31270
Stockholders' equity
Common stock, $1 par value per share |  | 315 |  | 319
Additional paid-in capital |  | 0 |  | 0
Retained earnings |  | 13922 |  | 14200
Accumulated other comprehensive loss |  | -9437 |  | -9601
Total stockholders' equity |  | 4800 |  | 4918
Total liabilities and stockholders' equity |  | 36919 |  | 36188
Spreadsheet: 819208d1677297409-check-and-advise-next-document-sequence-number-document-control-revision-number-answer
Sheet: Sheet1

 | Checking for previous revision and prompt next revision no.
 | No. | Document No. | Revision No. | My answer
 | 1 | ABC-123 | A
 | 2 | DEF-456 | A
 | 3 | GHI-789 | A
 | 4 | GHI-789 | B
 | 5 | ABC-123 | B
 | 6 | ABC-123 | C
 | 7 | JKL-012 | <Check and Prompt next Sequence No.>
 | 8 | ABC-123 | <Check and Prompt next Sequence No.>
 | 9 | DEF-456 | <Check and Prompt next Sequence No.>
 | 10 | GHI-789 | <Check and Prompt next Sequence No.>
 | 11 | XYZ-123 | <Check and Prompt next Sequence No.>
 | 12
 | 13
 | 14
 | 15
Spreadsheet: 56531d1256722152-display-filter-box-only-on-one-column-resolutions-sample
Sheet: Sheet1

Resolutions
 | Start Date | Completion Date | # of Days | Resolution
 | 2009-10-28 00:00:00 | 2009-11-04 00:00:00 |  | Walk 1 Mile Everyday
 | 2009-10-27 00:00:00 | 2009-11-26 00:00:00 |  | No Sugar Foods
 | 2009-10-27 00:00:00 | 2009-12-13 00:00:00 |  | No Eating Out
Spreadsheet: 537017d1504792648-how-to-setup-a-record-in-a-table-that-may-have-multiple-rows-of-data-in-a-certain-field-book1
Sheet: Sheet1

[NAME] | Customer | Item | Quantity |  | [NAME] | Customer | Item | Quantity
1 | AAAA | Product1 | 2
1 | AAAA | Product2 | 1
2 | BBBB | Product3 | 4
2 | BBBB | Product1 | 2
2 | BBBB | Product4 | 1
3 | CCCC | Product1 | 3
4 | DDDD | Product3 | 5
5 | DDDD | Product1 | 2
3 | CCCC | Product2 | 3
Spreadsheet: 82111d1282148121-macro-to-auto-fill-rows-based-on-one-cell-value-excel-fruit-example2
Sheet: Copy to this Sheet

Fruit Spreadsheet
Title | Number of items | Unit Price | Total Price
Oranges | 5 | 0.4 | 2
Apples | 4 | 0.2 | 0.8
Bananas | 6 | 0.7 | 4.199999999999999
Plums | 2 | 0.9 | 1.8
 |  |  |  | This works great, however>>>
Animals | Number of items | Unit Price | Total Price
Sheep | 6 | 4.6 | 27.6 | >>>I need to separate the sections so it looks like this
Horses | 2 | 2.2 | 4.4
This is what I want to see in lines 4 & 5 above from 'Main Sheet', but automatically
Lemons | 4 | 0.6 | 2.4
Limes | 5 | 0.6 | 3
 | Only fill in lines where number of items is filled in
Spreadsheet: 127709d1320499982-index-match-function-how-to-make-row-lookup-array-dynamic-or-variable-index-match-example
Sheet: Raw Data

House | Period | Plan | Actual
5216 | 201106 | 100 | 85
5216 | 201107 | 100 | 105
5216 | 201109 | 100 | 75
5216 | 201110 | 100 | 93
5216 | 201112 | 78 | 3
4518 | 201101 | 45 | 68
4518 | 201102 | 45 | 0
4518 | 201105 | 60 | 53
4518 | 201106 | 60 | 0
4518 | 201111 | 50 | 40
4518 | 201112 | 25 | 10
5216 | 201101 | 54 | 0
4518 | 201104 | 75 | 32
5216 | 201102 | 133 | 67
4518 | 201107 | 0.35 | 65.8
Spreadsheet: 167833d1342114708-work-hours-remaining-in-month-if-only-working-4-3-2-or-1-day-a-week-hoursremainingpermonth
Sheet: Sheet1

2012  $ 2013Holidays | Date | Number of Work Days Left in Month | Number of Work Hours left in Month based on days worked per week
 |  |  | 5 | 4 | 3 | 2 | 1
2012-01-02 00:00:00 | 2012-01-01 00:00:00 | 21 | 168 | 136 | 104 | 64 | 32
2012-04-06 00:00:00 | 2012-01-02 00:00:00 | 21 | 168 | 136 | 104 | 64 | 32
2012-05-28 00:00:00 | 2012-01-03 00:00:00 | 21 | 168 | 136 | 104 | 64 | 32
2012-07-04 00:00:00 | 2012-01-04 00:00:00 | 20 | 160 | 128 | 96 | 64 | 32
2012-09-03 00:00:00 | 2012-01-05 00:00:00 | 19 | 152 | 120 | 88 | 64 | 32
2012-11-22 00:00:00 | 2012-01-06 00:00:00 | 18 | 144 | 112 | 88 | 56 | 32
2012-11-23 00:00:00 | 2012-01-07 00:00:00 | 17 | 136 | 112 | 80 | 56 | 24
2012-12-24 00:00:00 | 2012-01-08 00:00:00 | 17 | 136 | 112 | 80 | 56 | 24
2012-12-25 00:00:00 | 2012-01-09 00:00:00 | 17 | 136 | 112 | 80 | 56 | 24
2013-01-01 00:00:00 | 2012-01-10 00:00:00 | 16 | 128 | 104 | 80 | 48 | 24
2013-04-05 00:00:00 | 2012-01-11 00:00:00 | 15 | 120 | 96 | 72 | 48 | 24
2013-05-27 00:00:00 | 2012-01-12 00:00:00 | 14 | 112 | 88 | 64 | 48 | 24
2013-07-04 00:00:00 | 2012-01-13 00:00:00 | 13 | 104 | 80 | 64 | 40 | 24
2013-09-02 00:00:00 | 2012-01-14 00:00:00 | 12 | 96 | 80 | 56 | 40 | 16
2013-11-28 00:00:00 | 2012-01-15 00:00:00 | 12 | 96 | 80 | 56 | 40 | 16
2013-11-29 00:00:00 | 2012-01-16 00:00:00 | 12 | 96 | 80 | 56 | 40 | 16
2013-12-24 00:00:00 | 2012-01-17 00:00:00 | 11 | 88 | 72 | 56 | 32 | 16
2013-12-25 00:00:00 | 2012-01-18 00:00:00 | 10 | 80 | 64 | 48 | 32 | 16
 | 2012-01-19 00:00:00 | 9 | 72 | 56 | 40 | 32 | 16
 | 2012-01-20 00:00:00 | 8 | 64 | 48 | 40 | 24 | 16
 | 2012-01-21 00:00:00 | 7 | 56 | 48 | 32 | 24 | 8
 | 2012-01-22 00:00:00 | 7 | 56 | 48 | 32 | 24 | 8
 | 2012-01-23 00:00:00 | 7 | 56 | 48 | 32 | 24 | 8
 | 2012-01-24 00:00:00 | 6 | 48 | 40 | 32 | 16 | 8
 | 2012-01-25 00:00:00 | 5 | 40 | 32 | 24 | 16 | 8
 | 2012-01-26 00:00:00 | 4 | 32 | 24 | 16 | 16 | 8
 | 2012-01-27 00:00:00 | 3 | 24 | 16 | 16 | 8 | 8
 | 2012-01-28 00:00:00 | 2 | 16 | 16 | 8 | 8 | 0
 | 2012-01-29 00:00:00 | 2 | 16 | 16 | 8 | 8 | 0
 | 2012-01-30 00:00:00 | 2 | 16 | 16 | 8 | 8 | 0
 | 2012-01-31 00:00:00 | 1 | 8 | 8 | 8 | 0 | 0
Spreadsheet: 702624d1604440129-formula-for-specific-cell-to-trigger-from-multiple-drop-downs-book2
Sheet: Sheet2

GSR |  | Post Doc |  | Researcher |  |  |  |  |  | Junior Specialist |  | Specialist |  |  |  |  |  | Project Scientist
Step | Salary | Step | Salary | Assistant |  | Associate |  | Researcher |  | Step | Salary | Assistant |  | Associate |  | Specialist |  | Assistant |  | Associate |  | Project Scientist
 | 42729 | 0 | 53460 | Step | Salary | Step | Salary | Step | Salary | 1 | 44500 | Step | Salary | Step | Salary | Step | Salary | Step | Salary | Step | Salary | Step | Salary
2 | 46053 | 1 | 55596 | 1 | 78400 | 1 | 97600 | 1 | 114600 | 2 | 47400 | 1 | 53300 | 1 | 62300 | 1 | 78200 | 1 | 63100 | 1 | 77600 | 1 | 90400
3 | 51072 | 2 | 57456 | 2 | 83300 | 1.5 | 100200 | 1.5 | 119000 |  |  | 2 | 55500 | 2 | 66000 | 2 | 86000 | 2 | 66600 | 1.5 | 79500 | 1.5 | 93700
4 | 55163 | 3 | 59580 | 2.5 | 85500 | 2 | 102700 | 2 | 123400 |  |  | 3 | 57800 | 3 | 70100 | 3 | 96000 | 2.5 | 68300 | 2 | 81300 | 2 | 97000
5 | 58834 | 4 | 61800 | 3 | 87700 | 2.5 | 105500 | 2.5 | 128200 |  |  |  |  | 4 | 73900 | 4 | 107900 | 3 | 70000 | 2.5 | 83800 | 2.5 | 100900
6 | 61565 | 5 | 64008 | 3.5 | 90200 | 3 | 108100 | 3 | 132800 |  |  |  |  |  |  | 5 | 119600 | 3.5 | 72200 | 3 | 86100 | 3 | 104700
7 | 66497 |  |  | 4 | 92700 | 3.5 | 111300 | 3.5 | 137700 |  |  |  |  |  |  | 6 | 129600 | 4 | 74300 | 3.5 | 88200 | 3.5 | 109000
8 | 71787 |  |  | 4.5 | 95100 | 4 | 114500 | 4 | 142600 |  |  |  |  |  |  | 7 | 137600 | 4.5 | 75900 | 4 | 90300 | 4 | 113200
9 | 77547 |  |  | 5 | 97500 | 4.5 | 118900 | 4.5 | 147900 |  |  |  |  |  |  | 8 | 148800 | 5 | 77500 | 4.5 | 93600 | 4.5 | 117900
10 | 83727 |  |  | 5.5 | 100100 | 5 | 123300 | 5 | 153100 |  |  |  |  |  |  | 9 | 163800 | 5.5 | 79400 | 5 | 96900 | 5 | 122500
 |  |  |  | 6 | 102600 | 5.5 | 128100 | 5.5 | 159100 |  |  |  |  |  |  |  |  | 6 | 81200 | 5.5 | 100800 | 5.5 | 127800
 |  |  |  | 6.5 | 105400 |  |  | 6 | 165100 |  |  |  |  |  |  |  |  | 6.5 | 83700 |  |  | 6 | 133000
 |  |  |  |  |  |  |  | 6.5 | 171600 |  |  |  |  |  |  |  |  |  |  |  |  | 6.5 | 138800
 |  |  |  |  |  |  |  | 7 | 178100 |  |  |  |  |  |  |  |  |  |  |  |  | 7 | 144500
 |  |  |  | Assistant |  |  |  | 7.5 | 185500 |  |  |  |  |  |  |  |  |  |  |  |  | 7.5 | 150400
 |  |  |  | Associate |  |  |  | 8 | 192800 |  |  |  |  |  |  |  |  |  |  |  |  | 8 | 156300
 |  |  |  | Researcher |  |  |  | 8.5 | 200900 |  |  |  |  |  |  |  |  |  |  |  |  | 8.5 | 163100
 |  |  |  |  |  |  |  | 9 | 209000 |  |  |  |  |  |  |  |  |  |  |  |  | 9 | 169800
 |  |  |  |  |  |  |  | 9.5 | 217800 |  |  |  |  |  |  |  |  |  |  |  |  | 9.5 | 177100