tianzl66/Sheetpedia huggingface dataset:
Spreadsheet: 714762d1611346310-return-value-of-latest-balance-for-each-month-and-accounts-copie-de-forum-excel-22-jan-2021lookup
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
 |  | BLUE
 |  | YELLOW
 |  | GREEN
DATE | Description | ACCOUNT | AMOUNT | BALANCE REPORT | PROFIT/ LOSS | CLOSING BALANCE
2020-01-10 00:00:00 | Deposit | AR | 200
2020-01-21 00:00:00 | Deposit | AR | 200
2020-01-30 00:00:00 | Deposit | AR | 200
2020-03-01 00:00:00 | Deposit | FT | 300
2020-03-01 00:00:00 | Deposit | AR | 25
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-03-01 00:00:00 | Deposit | PL | 60
2020-03-01 00:00:00 | Deposit | UR | 80
2020-05-01 00:00:00 | Annual report (balance now at 230$) | AR | 0 | 230 |  | 230
2020-05-01 00:00:00 | Annual report (balance now at 280$) | FT | 0 | 320 |  | 320
2020-05-01 00:00:00 | Annual report (balance now at 55$) | PL | 0 | 55 |  | 65
2020-05-01 00:00:00 | Annual report (balance now at 77$) | UR | 0 | 77 |  | 77
2020-06-15 00:00:00 | Withdrawal | AR | -50
2020-06-15 00:00:00 | Withdrawal | FT | -60
2020-06-15 00:00:00 | Withdrawal | PL | -40
2020-06-15 00:00:00 | Withdrawal | UR | -70
2021-01-01 00:00:00 | Deposit | AR | 120
2021-01-01 00:00:00 | Deposit | FT | 100
2021-01-01 00:00:00 | Deposit | PL | 90
2021-01-01 00:00:00 | Deposit | UR | 80
Spreadsheet: 33948d1230911426-new-idea-on-creating-excel-files-to-automatically-determine-proper-entry-john-eastland-example-sheet-with-edward-bentley-sum-if-function-later-version-of-excel-revised
Sheet: 412 Min Fund

 | Minimum Funding – Money Purchase Plan IRC Section 412:
 | Plan formula - 10% of total compensation for each participant
 | Funding Standard Account - IRC section 412(a):
 |  | Charges:
 |  | Prior year funding deficiency |  |  |  | 0
 |  | Current year contributions |  |  |  | 0
 |  |  | Total Charges
 |  | Credits:
 |  | Prior year credit balance |  |  |  | 0
 |  | Current year contributions |  |  |  | 0
 |  |  | Total Credits |  |  | 0
 |  | Funding Deficiency (Charges minus Credits) |  |  |  | 0
 | Funding Requirement - IRC section 412(c)(10):
 | Payment must be made within 8 and 1/2 months after close of PY
 | IRC section 412(c)(10) date payment due - 9/15/01
 | Payment date | Check # | Amount
 |  |  | 0
 |  |  | 0
 |  | Total amount | 0
 |  | of cancelled
 |  | checks
 |  | Funding Deficiency - fail to deposit timely |  |  |  | 0
Spreadsheet: 00dba250-a258-4895-ad91-05c1e1363844
Sheet: Sheet1

HYPOTHETICAL EXAMPLE - Research Project Budget - 3 partners with  KDWPT, University, NGO and Fed Grant Funds | Unnamed: 1 | Unnamed: 2 | Unnamed: 3 | Unnamed: 4 | Unnamed: 5
2014 Chickadee Checkoff Small Grants Budget Spreadsheet
Please use this generic budget spreadsheet as a guideline to create the project budget.  Explanation of budget categories used should be provided in the Budget portion of the grant narrative.
Cost Category | KDWPT Grant Amount Requested | Primary Applicant Share  (non-federal match contribution) | Partner  Contributions (non-federal match) | Federal Grant Partners (federal match contribution) | Total
Name of Partner | KDWPT | University Name | NGO Name | Federal Agency Name
Personnel
PI/ Primary Applicant Salary | 2000 | 500 | 0 | 0 | 2500
Assistant and/or Temp Salaries | 0 | 0 | 500 | 0 | 500
[NAME] (25%) | 0 | 0 | 0 | 0 | 0
Travel/Vechicle Expense:
Hotel Lodging 10 nights | 1300 | 0 | 0 | 0 | 1300
Mileage at $0.50 per mile 1000 miles | 0 | 500 | 0 | 0 | 500
Other travel/vehicle expenses not list above | 0 | 0 | 0 | 0 | 0
Equipment: list individual equipment below
GPS | 0 | 0 | 0 | 100 | 100
Traps | 500 | 0 | 0 | 0 | 500
Item 3 | 0 | 0 | 0 | 0 | 0
Item 4 | 0 | 0 | 0 | 0 | 0
Supplies: list individual supplies below
Cloth for covering traps | 100 | 0 | 0 | 0 | 100
temporary fence | 100 | 0 | 0 | 0 | 100
Item 3 | 0 | 0 | 0 | 0 | 0
Item 4 | 0 | 0 | 0 | 0 | 0
Miscellaneous: [NAME] list below
Rental equipment | 1000 | 200 | 0 | 0 | 1200
Item 2 | 0 | 0 | 0 | 0 | 0
Item 3 | 0 | 0 | 0 | 0 | 0
Item 4 | 0 | 0 | 0 | 0 | 0
Total Direct Cost | 5000 | 1200 | 500 | 100 | 6800
Indirect Charges (Only Available as match) |  | 144 | 0 |  | 144
GRAND TOTAL | 5000 | 1344 | 500 | 100 | 6944
Grand Total (%) | 0.7200460829493087 | 0.1935483870967742 | 0.07200460829493087 | 0.01440092165898618 | 1
Total [NAME]  must be >25% |  |  |  |  | 0.2799539170506912
Entries may only be made to blue cells.
Spreadsheet: 547740d1510714337-reorganizing-inconsistent-columns-ingested-from-database-daily-example_2
Sheet: CUT_AND_PASTE_DATA

ITEM_AGE | ITEM_QUALITY | ITEM_NAME | ITEM_COLOR | ITEM_NUMBER | ITEM_REFERENCE
2 | Good | Car | Grey | 65395 | Sharp
2 | Good | Bus | Black | 66485 | Flat
8 | Poor | Bike | Black | 14863 | Flat
6 | Poor | Ship | Purple | 10862 | Flat
2 | Poor | Truck | Green | 98765 | Flat
Spreadsheet: 652477d1575378834-help-with-a-string-of-if-statements-example-dec
Sheet: Sheet1

 |  |  |  |  |  |  |  |  |  | Year 1 |  |  |  | Year 2 |  |  |  | Year 3 |  |  |  | Year 4 |  |  |  | Year 5
 |  |  |  |  |  |  |  |  |  | 2019-09-30 00:00:00 | 2019-12-31 00:00:00 | 2020-03-31 00:00:00 | 2020-06-30 00:00:00 | 2020-09-30 00:00:00 | 2020-12-31 00:00:00 | 2021-03-31 00:00:00 | 2021-06-30 00:00:00 | 2021-09-30 00:00:00 | 2021-12-31 00:00:00 | 2022-03-31 00:00:00 | 2022-06-30 00:00:00 | 2022-09-30 00:00:00 | 2022-12-31 00:00:00 | 2023-03-31 00:00:00 | 2023-06-30 00:00:00 | 2023-09-30 00:00:00 | 2023-12-31 00:00:00 | 2024-03-31 00:00:00 | 2024-06-30 00:00:00
Property Address | Tenant | Lease Start | Lease Break Exercised? | Lease Break Date | Lease Expiry | Rent | Rent Post Void | Post Void Lease Expiry | VOID (# [NAME]) | Q3 2019 | Q4 2019 | Q1 2020 | Q2 2020 | Q3 2020 | Q4 2020 | Q1 2021 | Q2 2021 | Q3 2021 | Q4 2021 | Q1 2022 | Q2 2022 | Q3 2022 | [NAME] | Q1 2023 | Q2 2023 | Q3 2023 | Q4 2023 | Q1 2024 | Q2 2024
 |  |  | Yes | 2022-04-10 00:00:00 | 2020-04-09 00:00:00 |  |  | 2021-04-09 00:00:00 | 3
Initial Loan Requirement |  |  |  |  | Opening Bal
Property Value |  |  |  |  | [NAME]
Annuity Loan Profile on |  |  |  |  | [NAME]
Term |  |  |  |  | Closing LTV
Gross Rent
Interest p.a.
Service Charges & Costs - lessee
Profit before tax
Tax Payable (estimated) @
Total Interest, Expenses & Tax
Cashflow available pre Principal Repayments p.a.
Net Cashflow Available per above
Add back interest
Cashflow available for Debt Servicing
Cashflow after Debt Servicing
Gross Interest Cover
DSCR Pre Tax
DSCR Post Tax
Surplus Cashflow Available p.a. - pre tax
Surplus Cashflow Available p.a. - post tax
Tax Calculation
Rent
Expenses
Interest
Interest Dissalowed |  |  |  | 0
Capital Allowance |  |  |  | 0
Taxable Surplus
Tax Payable @
Rent Reserve
Opening reserve |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 0
Surplus Cashflow Available p.a. - post tax
Cumulative reserve
Spreadsheet: 785795d1656690900-generate-names-based-on-multiple-criteria-and-sort-based-on-smallest-largest-value-sample-revised
Sheet: Pivot

 |  |  | School | (Multiple Items)
 |  |  | Station Code | (Multiple Items)
 |  |  | Employee ID | Name
 |  |  | 6412708 | Brooklyn Hobbs
 |  |  | 4256020 | [NAME]
 |  |  | 4257987 | [NAME]
 |  |  | 4770982 | [NAME]
 |  |  | 5286833 | Emmy Walker
 |  |  | 5293457 | Bea Loon
 |  |  | 5294436 | [NAME]
 |  |  | 5296754 | [NAME]
 |  |  | 5296792 | [NAME]
 |  |  | NEW | [NAME]
 |  |  | Grand Total
Spreadsheet: 86b1a17e-d4c4-40b6-876b-d6682d1dbd5c
Sheet: Sheet1

OPERATING/PROGRAMMATIC | Unnamed: 1 | Unnamed: 2 | Unnamed: 3 | Unnamed: 4 | Unnamed: 5 | Unnamed: 6 | Unnamed: 7 | Unnamed: 8 | Unnamed: 9 | Unnamed: 10 | Unnamed: 11
Legislative Fiscal Note |  |  |  |  |  |  | Ordinance Number
Ordinance Title (in Brief)
Comprehensive STD-HIV/AID Surv -Perinatal B
Does this Legislation Estimate New or Additional Revenues to the City? |  |  |  |  |  |  |  | x | No |  | Yes
 |  |  |  |  | Governmental Grants Fund
 | Revenue Detail |  |  |  | FY 2010-11 |  | FY 2011-12
 | General Fund
 | Special Revenue
 | Enterprise
 |  |  | Total:
Does this Legislation increase appropriations in the current budget? |  |  |  |  |  |  |  | x | No |  | Yes
 | If Yes, please complete the following budget information:
 | Expense Detail |  |  |  | FY 2010-11 |  | FY 2011-12
 | General Fund
 | Special Revenue
 | Enterprise/Other
 |  |  | Total: |  | 0 |  | 0
 | Please detail the extent to which these increased appropriations will be of a permanent nature (e.g. number of
 | additional staff, facilities, long-term contracts)
Does this Legislation expand the scope of current city services? |  |  |  |  |  |  |  | X | No |  | Yes
 | (Please detail estimate number of people to be served, who is delivering services currently to that population, service
 | performance expectations, and if grant supported, provisions for support if grant support ends.
Is this legislation the result of a federal or state legislative mandate? |  |  |  |  |  |  |  | X | No |  | Yes
 | (If yes, please detail the purpose and source for that mandate).
Reviewed by:
 | 0ffice of Management and Budget |  |  | OMB Approval Date
Spreadsheet: 1969f55b-8e34-4a3a-90ac-5fec6c34267d
Sheet: Sheet1

Unnamed: 0 | Unnamed: 1 | TIB-The Independent BankersBank | Unnamed: 3 | Unnamed: 4 | Unnamed: 5 | .25 cost to Price to Waive Escrows | Unnamed: 7
 |  | 350 [NAME]., [NAME] |  |  |  | LTV must be 80% or less to qualify.
 |  | [PHONE] Toll Free//[PHONE] fax
 |  | Rate Sheet Effective: |  |  | 2011-10-14 09:19:36.320000
Product: Conv-Conforming Fixed Rate 30 Year |  |  |  |  |  | Loan Level Price Adjustment
Rate | 15 Day | 30 Day | 45 Day | 60 Day |  | Price adjustments are cumulative
4.5 | 101.491 | 101.366 | 101.241 | 100.866 |  | and are added to price quote
4.375 | 100.984 | 100.859 | 100.734 | 100.359
4.25 | 100.228 | 100.103 | 99.978 | 99.603 |  | Note: | Refer To Price [NAME]
4.125 | 99.807 | 99.682 | 99.557 | 99.182 |  |  | For all Price Adjs
4 | 99.338 | 99.213 | 99.088 | 98.463
3.875 | 98.737 | 98.612 | 98.487 | 97.862
 |  |  |  |  |  | NEW!!!!!
 |  |  |  |  |  | Please note availability of
 |  |  |  |  |  | Servicing Retained Product for
 |  |  |  |  |  | Conventional Loans Only.
 |  |  |  |  |  | A .25 adjustment to SRP
 |  |  |  |  |  | Will apply.
 |  |  |  |  |  | NEW!!!!
 |  |  |  |  |  | Improved 15 day price for
 |  |  |  |  |  | Conventional Product
Product: Conv-Conforming Fixed Rate 15 Year
Rate | 15 Day | 30 Day | 45 Day | 60 Day
3.875 | 101.155 | 101.03 | 100.905 | 100.53
3.75 | 100.6 | 100.475 | 100.35 | 99.975
3.625 | 100.289 | 100.164 | 100.039 | 99.664
3.5 | 99.95 | 99.825 | 99.7 | 99.325
3.375 | 99.498 | 99.373 | 99.248 | 98.623
3.25 | 98.95 | 98.825 | 98.7 | 98.075
 |  |  |  |  |  | Minimum loan amount:
 |  |  |  |  |  | TIB does not have a minimum loan
 |  |  |  |  |  | loan amount, however a 1.00% price
 |  |  |  |  |  | discount will apply to loan amounts
 |  |  |  |  |  | less than $39,999.00
 |  |  |  |  |  | 2010 Conforming Loan Limits
 |  |  |  |  |  | 1 Unit-$417,000
 |  |  |  |  |  | 2 Unit-$533,850
 |  |  |  |  |  | 3 Unit-$645,300
 |  |  |  |  |  | 4 Unit-$801,950
A SERVICE RELEASE PREMIUM WILL BE PAID IN [NAME] WITH THE ATTACHED SCHEDULE.
 |  | TIB-The Independent BankersBank
 |  | 350 [NAME]., [NAME]
 |  | [PHONE] Toll Free//[PHONE] fax
 |  | Rate Sheet Effective:
 |  |  |  |  |  | Loan Level Price Adjustment
Rate | 15 Day | 30 Day | 45 Day |  |  | Price adjustments are cumulative
 |  |  |  |  |  | & adj. Made to the price quote
EXPIRATION DATES:
15 DAY | 2011-10-28 09:19:36.320000
30 DAY | 2011-11-12 09:19:36.320000
45 DAY | 2011-11-27 09:19:36.320000
60 DAY | 2011-12-12 09:19:36.320000
90 DAY | 2012-01-11 09:19:36.320000
A SERVICE RELEASE PREMIUM WILL BE PAID IN [NAME] WITH THE ATTACHED SCHEDULE.
Spreadsheet: 680945d1591273403-sum-aa17-f-17-aa257-f-257-help-an-versa
Sheet: STOCK ORDER

 |  | 182048 | 182050 | 182377 | 182422 | 182048 | 182050
 |  | 2020-06-29 00:00:00 | 2020-06-29 00:00:00 | 2020-06-29 00:00:00 | 2020-06-29 00:00:00 | 2020-07-06 00:00:00 | 2020-07-06 00:00:00
ERP 5ODES | Cost $
D5VRS-5HAR-168x22800 | 33.99 | 12
D5VRS-5HAR-228x13700 | 32.59
D5VRS-5HAR-228x18200 | 39.29
D5VRS-5HAR-228x22800 | 47.07 |  | 10 |  |  | 20
D5VRS-NATU-116x13700 | 17.4
D5VRS-NATU-116x18200 | 21.57
D5VRS-NATU-116x22800 | 25.82 |  | 12
D5VRS-NATU-168x13700 | 23.19 |  |  |  | 12
D5VRS-NATU-168x18200 | 28.68
D5VRS-NATU-168x22800 | 33.99 |  |  |  | 12
D5VRS-NATU-228x13700 | 32.59
D5VRS-NATU-228x18200 | 39.29 | 10
D5VRS-NATU-228x22800 | 47.07
D5VER-5HAR-168x27455 | 40.49
D5VER-5HAR-228x27455 | 56.19 | 10
D5VER-5HAR-284x13755 | 37.45
D5VER-5HAR-284x18255 | 46.14
D5VER-5HAR-284x22855 | 55.19
D5VER-NATU-168x27455 | 40.49 |  |  | 12
D5VER-NATU-228x27455 | 56.19 |  |  | 28
D5VER-NATU-284x13755 | 37.45
[NAME] | 46.14
D5VER-NATU-284x22855 | 55.19 |  |  |  |  | 10 | 10
[NAME] | 17.6
[NAME] | 21.8
[NAME] | 26.11
D5VER-SILV-168X13755 | 23.09
D5VER-SILV-168X18255 | 28.61
[NAME] | 33.98
[NAME] | 32.19
D5VER-SILV-228X18255 | 38.93
[NAME] | 46.77
[NAME]TB | 4.79
D5VER-SILV-045x0455F | 3.18
D5BVE-5HAR-117x13755 | 20.43
D5BVE-5HAR-117x18255 | 25.6
D5BVE-5HAR-117x22855 | 30.89
D5BVE-5HAR-168x13755 | 27.55
[NAME] | 34.58
D5BVE-5HAR-168x22855 | 41.45
D5BVE-5HAR-228x13755 | 38
D5BVE-5HAR-228x18255 | 47.48
D5BVE-5HAR-228x22855 | 57.4
D5BVE-NATU-117x13755 | 20.43
[NAME] | 25.6
D5BVE-NATU-117x22855 | 30.89 |  |  | 20
[NAME] | 27.55
[NAME] | 34.58
D5BVE-NATU-168x22855 | 41.45
D5BVE-NATU-228x13755 | 38
[NAME] | 47.48
D5BVE-NATU-228x22855 | 57.4
Spreadsheet: 823164d1679773355-retrieving-value-from-adjacent-table-based-on-value-within-table-eflookup
Sheet: CARCELLA

Airline | To | Sched. |  | Airline | To | To2 | First Flight | Last Flight
American Airlines | Doha | 11:00:00 |  | American Airlines
American Airlines | [NAME] | 11:10:00
American Airlines | Miami, FL | 11:15:00
American Airlines | Indianapolis, IN | 11:15:00
American Airlines | London | 11:20:00
American Airlines | Columbus, OH | 12:00:00
American Airlines | Cleveland, OH | 12:00:00
American Airlines | Boston, MA | 12:05:00
American Airlines | Worcester, [NAME] | 12:10:00
American Airlines | Boston, MA | 12:10:00
American Airlines | Norfolk, VA | 12:20:00
American Airlines | Jacksonville, FL | 12:20:00
American Airlines | Salt Lake City, UT | 12:27:00
American Airlines | Orlando, FL | 12:30:00
American Airlines | Miami, FL | 12:37:00
American Airlines | West Palm Beach, FL | 12:40:00
American Airlines | [NAME] | 12:41:00
American Airlines | Boston, MA | 13:05:00
American Airlines | Orlando, FL | 13:14:00
American Airlines | Boston, MA | 13:20:00
American Airlines | Tampa, FL | 13:28:00
American Airlines | Syracuse, NY | 13:30:00
American Airlines | San Francisco, CA | 13:30:00
American Airlines | Miami, FL | 13:40:00
American Airlines | Atlanta, GA | 13:40:00
American Airlines | Burlington, VT | 13:44:00
American Airlines | Buffalo, NY | 13:44:00
American Airlines | San Antonio, TX | 13:45:00
American Airlines | Tokyo | 13:45:00
American Airlines | Phoenix, AZ | 13:55:00
American Airlines | West Palm Beach, FL | 14:00:00
Spreadsheet: 35c18e6b-70d5-43fc-acca-f70a886b6e97
Sheet: Sheet1

2013 DIVISION 1 CIF-SS/FORD SOFTBALL CHAMPIONSHIPS, presented by Farmers | Unnamed: 1 | Unnamed: 2 | Unnamed: 3 | Unnamed: 4 | Unnamed: 5
1ST ROUND |  | 2ND ROUND | QTR FINALS | SEMI-FINALS | FINALS
THURS., MAY 16 |  | TUES., MAY 21 | THURS., MAY 23 | TUES., MAY 28 | Fri/Sat
 |  |  |  |  | May 31 & June 1
*Esperanza | Century #1 |  |  |  | [NAME]
 |  | Rosary |  |  | Stadium, [NAME]
Rosary | Trinity #3 | 5-3
*Valley View | Inland Valley #2 | F | *Rosary
 |  | *Edison | 14-6
Edison | Sunset #2 | 9-3
*Oxnard | Pacific View #1 |  |  | *Norco
 |  | *Norco |  | 8-0
Norco | Big VIII #3 | 3-0
*Los Osos | Baseline #1 | F | Norco
 |  | Cypress | 3-2
Cypress | Winner WC "A" | 5-2
*ML King | Big VIII #1
 |  | *ML King
Los Alamitos | Sunset #3 | 3-2
*Lutheran/Or. | Trinity #2 | F | *Lutheran/Or
 |  | Lutheran/Or | 2-0
Saugus | Foothill #2 | 2-1
*Murrieta Valley | Southwestern #1 |  |  | [NAME]/GG
 |  | Murrieta Valley |  | 13-1
Upland | Winner WC "B" | 8-2
*Pacifica/GG | Empire #1 | F | [NAME]/GG
 |  | *Pacifica/GG | 11-0 | REPORT SCORES @ WWW.CIFSSHOME.ORG/ HOME CAMPUS/TEAM TAB.   IMMEDIATELY AFTER COMPLETION OF CONTEST
El Modena | Century #3 | 7-2
*Marina | Sunset #1
 |  | Marina
Roosevelt | Winner WC "C" | 3-0
*Great Oak | Southwestern #2 |  | [NAME]
 |  | *Etiwanda | 6-5
[NAME] | Baseline #2 | 13-10
*Camarillo | Pacific View #2 |  | F | Yorba [NAME]
 |  | *Canyon/A |  | 8-2
Canyon/A | Century #2 | 9-0
*Yorba [NAME] | Empire #2 |  | *Yorba [NAME]
 |  | Yorba [NAME] | 5-2
Santa Margarita | Winner WC "D" | 2-1
*Santiago/Cor | Big VIII #2
 |  | Santiago/C
[NAME] | Winner WC "E" | 6-1
*Poly/Riv | Inland Valley #1 |  | Santiago/C
 |  | *Vista Murrieta | 11-2
Vista Murrieta | Southwestern #3 | 4-3
*West Ranch | Foothill #1 |  | F | *Santiago/C
 |  | West Ranch |  | 6-3
Rancho Cucamonga | Baseline #3 | 4-1
*[NAME] | Trinity #1 |  | *West Ranch
 |  | *Foothill | 8-4
Foothill | Winner WC "F" | 4-2
*Denotes Host Team
SOFTBALL -  DIVISION 1
Spreadsheet: 129933d1321978986-combo-box-dependent-listing-sample_comboboxlist
Sheet: Sheet1

 |  |  | Manager |  |  |  | List |  |  | Respective Manager
 |  | List | Newark - White Plains | Atlanta - Charleston | Calgary - Edmonton
 |  | Newark - White Plains | [NAME] | [NAME] | [NAME]
 |  | Atlanta - Charleston | [NAME] | [NAME] | [NAME]
 |  | Calgary - Edmonton | [NAME] |  | [NAME]
 |  |  |  |  | Tawanda Mudzana
 |  |  |  |  | [NAME]
Spreadsheet: 567865d1522258557-lookup-multiple-occurrences-of-the-same-value-in-two-different-columns-ef1136a_elo_adjustments
Sheet: ELO

Name | ELO 1 | ELO 2 | ELO 3 | ELO 4 | ELO 5 | ELO 6 | ELO 7 | ELO 8 | ELO 9 | ELO 10 | ELO 11 | ELO 12 | ELO 13 | ELO 14 | ELO 15
Adam | 1000
Alicia | 1000
[NAME] | 1000
Braxton | 1000
Ellie | 1000
[NAME] | 1000
Erin | 1000
Grace | 1000
Jessica | 1000
Olivia | 1000
[NAME] | 1000
[NAME] | 1000
[NAME] | 1000
Tyron | 1000
Spreadsheet: 700684d1603289908-furmula-to-reduce-3-columns-to-2-test26
Sheet: Sheet1

 |  |  |  | 0.4 | 0.6 |  | 0.48 | 0.52 |  | 0.42 | 0.58
 |  |  | GEN | TAP | LAB | GEN | TAP | LAB | GEN | TAP | LAB |  |  | TAP | LAB | TAP | LAB | TAP | LAB
 |  |  | 100 | 167 | 210 | 68 | 120 | 198 | 97 | 180 | 213
 |  |  | 104 | 173 | 200 | 79 | 128 | 204 | 111 | 200 | 220
 |  |  |  | Nos in Row 5 are the fraction of GEN to be added to TAP and LAB
 |  |  |  | so a table with columns grouped in threes becomes a table with columns grouped in twos
 |  |  |  | I have achieved this by entering formulas by hand but there are over 100 groups so I would like a formula inO8 which could be copied across.
Spreadsheet: 183948d1349100436-need-help-with-conditional-formatting-problem-please-help-tf-performance-2-latest-q3
Sheet: Total ops per client Data

Month | (Multiple Items)
Row Labels | Count of Client
(blank)
[NAME] | 1
[NAME] | 1
Conoil | 1
[NAME] | 1
Tonique | 1
[NAME] | 1
Marine | 1
Optima | 1
Aieto | 1
Union Maritime Ltd. | 1
[NAME] | 1
Delaney | 1
Yanaty | 1
Rain Oil | 1
Valeska | 1
Lingo | 1
Rainoil Limited | 1
Deejones | 1
Nadabo | 1
MRS Holding | 1
Northwest | 1
Origin | 1
Capital | 1
Ginvor | 1
Vitol/ Energy Culture | 1
Oilsep | 1
A-Z Petroleum Ltd | 1
Petroserve | 1
Arcadia Energy | 1
Quest Drilling | 1
Enegas | 1
Masters Energy | 1
Sea Petroleum | 1
Duport | 1
Bellpoint Energy Ltd | 1
Brila Energy | 1
Petrocam Trading (Pty) Ltd | 1
Sopetro | 1
Sirocco Shipping | 1
Eres | 1
Somerset | 1
Ontario Oil | 1
Mandarin | 1
Peak | 1
Techno Oil | 1
AX-Energy | 1
Octogone | 1
[NAME] | 2
First Deepwater | 2
Ascon | 2
Agri | 2
Augusta | 2
Conoil (OAN) | 2
Eres NV | 2
OAN | 2
UMN | 2
Fineshade Energy | 2
Taleveras | 2
Litasco SA | 2
[NAME] | 2
Arcadia | 2
Dee jones | 2
Taurus | 2
Augusta Energy SA | 2
Awaritse | 3
Sahara (NG) | 3
[NAME] | 3
MRS Holdings | 3
Spog | 3
Nipco | 3
Petrochina | 3
Rainoil | 4
[NAME] | 4
Ontario | 4
PPMC | 4
SK Shipping | 4
Sahara (CH) | 4
MRS Shipping | 4
Ax Energy | 4
MRS Holdingss | 4
Honeywell | 5
Oando | 5
Capital | 7
Litasco | 7
Sahara | 7
Pinnacle | 8
Nepal | 10
Matrix | 12
Noble | 12
Setana | 12
Petrocam | 12
Energy Culture | 13
Petrocam SA | 27
Trafigura | 36
Addax | 42
[NAME] | 50
Mercuria | 51
Nimex | 60
Vitol | 121
Glencore | 141
Grand Total | 776
Spreadsheet: 116643d1311964345-excel-2007-conditional-format-based-on-value-in-a-column-example
Sheet: Sheet1

Line | Family | Pump | Cover/Makes | EAU | Cycle Time | Pumps/Day
2 | 2 | MM-68 |  | 58232 | 15 | 4400
2 | 2 | [NAME] |  | 24863 | 15 | 4400
2 | 2 | MM-68A |  | 820 | 15 | 4400
2 | 1 | MM-74 |  | 37878 | 15 | 4400
2 | 1 | MM-74HV |  | 7054 | 15 | 4400
Spreadsheet: 1eba972e-b960-428a-b473-32f65d96f2e4
Sheet: Supplemental Table 4

Up-regulated | Down-regulated
[NAME] | AMIGO2
SLC38A4 | FFAR2
CCDC141 | SLC6A20
ORM1 | ABCA1
HPGD | MAN1A1
FKBP5+LOC285847 | LRRN1
ORM2 | DAB1
[NAME] | CCDC83
F5 | PLD1
SLC2A3 | SLC30A10
NPPC | SSTR5
SLC26A3 | ST6GALNAC5
C9orf66+DOCK8 | OPRK1
TMEM100 | IL1RN
NCAPD3 | NR4A2
TMCC3 | CXCR7
SNAI2 | HEPACAM
OR5B2 | MPP1
[NAME] | ADRA1A
MAF | CXorf36
TGM2 | SLC5A1
CTNNA2 | C1orf127
SDR9C7 | HOXC9
ERRFI1 | SLC7A5
PNLIP | C10orf81
EAF2 | PTPRB
ALPK2 | HOXA11-AS
PLA2G4E | SYTL2
PTGER4 | [NAME]
FAM105A | PMP22
CSGALNACT1 | BDKRB2
MAK | RFX3
EMP1 | TGM3
SPOCK1 | PAX1
CXCR4 | [NAME]
LIFR | OSR2
CYP2U1 | NOV
TG | HEPN1
NDRG1 | C1QTNF6
[NAME] | CD200
TBX15 | BMF
C16orf61+CENPN | COL3A1
[NAME] | HOXA11
RHOU | LOC100271702
PTCRA | CCNO
AKAP12 | TNFSF15
LOC100287227+TIPARP | [NAME]
LAMA1 | WNT2B
LAT2 | KCNK5
ACSL3 | RNF43
PKP1 | TGM6
PAK1IP1 | ZNF703
SLC15A2 | RASSF5
CHRNA2 | PRSS23
TMPRSS2 | HOXC8
TARP | CSRNP3
TNFAIP8 | PKIB
SGK223 | SAMD4A
ADH1C | KLHL32
MUM1L1 | FAM198B
C3orf58 | GRB10
NAT1 | FYN
STK39 | NDP
ELL2 | PLA2G2F
MBOAT2 | TSHZ3
MTMR9 | GRAMD1C
TUBA3D | CDH26
STK17B | LIPH
PMEPA1 | WSCD1
SLC41A1 | EDN2
PIK3AP1 | ABCA12
XKR5 | HOXB6
[NAME] | C21orf128+UMODL1
DSC1 | HOXC13
ATAD2 | NFATC2
IQUB | FAM184B
NBL1 | NTN4
MALT1 | CACNA1G
SLC16A6 | DGKH
IGF1R | VWA2
ELOVL7 | TERC
GNB4 | [NAME]
CACNG4 | TULP4
[NAME] | C20orf197
GRIN3A | TMEM144
ELOVL2 | LRIG3
C1orf113 | CNGA1
NNMT | TLE3
KRT19 | CD55
[NAME] | C17orf103
DBI | LOC286367
TNFAIP3 | MANEA
NR4A1 | C2orf54
RMRP | ARPM1
[NAME] | [NAME]
WWTR1 | NCOA7
REP15 | LRRTM3
HERC3 | C5orf30
[NAME] | [NAME]
[NAME] | ARHGAP20
WIPI1 | FAM19A2
SLC39A10 | SCGBL
MYOF | COL16A1
[NAME] | GUSBP1
SLC45A3 | SOX11
BHLHA15 | ADRA2C
CDH5 | LRRC4C
PNLIPRP3 | SPTLC3
[NAME] | MGAT3
PRKCA | HOXC12
MICAL1 | ZBTB43
ANGPT2 | HOXB5+LOC404266
JAM3 | GPR63
LRRFIP2 | RTN4RL1
FAM107A | TRIB1
ODC1 | SRGAP3
RFX6 | SRMS
CYP11A1 | CERK
MERTK | HOXA3
[NAME] | APOL4
SLC35F2 | FAM198A
NKX3-1 | [NAME]
ST6GALNAC1 | ALX4
FOXD4 | HOXA5
CAMKK2 | MID1
KLHL29 | TRIM29
[NAME] | TSLP
GNMT | MCTP1
LOX | ANKRD16
ANK1 | ABCG1
[NAME] | RASL11A
SPDEF | [NAME]
UGT2B28 | [NAME]
MYBPC1 | COL9A2
IQGAP2 | COL5A2
[NAME] | KRT20
SPHAR | [NAME]
[NAME]
SOCS2
APPBP2
LONRF1
CBLL1
SORD
RAB4A
ASIP
TRIM36
HOMER2
IRS2
INPP4B
PTPRM
ATRNL1
CBWD1
GADD45G
FZD5
PGC
HMGXB3+TIGD6
CADPS2
WNT7B
TMEM79
SMS
CDYL2
KRT18
SYNJ1
TPD52
TBC1D8
C17orf48
NDFIP2
C6orf81
TBRG1
KCTD3
LOC344595
ACAD8
C1orf26
F2RL1
HMGCR
LPAR3
SEPP1
ABHD2
NFKBIA
SAT1
CLDN8
ANKH
PPFIBP1
CYTH1
ABCC1
RAB3B
UBE2J1
VGF
FGD4
TBC1D1
C1orf21
PACS1
APLN
FAM174B
ALDH1A3
RNU12
[NAME]
SNORD88C
ZBTB10
CROT
FRYL
[NAME]