tianzl66/Sheetpedia huggingface dataset:
Spreadsheet: tracy_geaccone__40381__San Juan
Sheet: Sheet1

ESTIMATED SAN JUAN IMBALANCE GAS [NAME]
 |  |  | [NAME] |  |  | AMOCO |  |  | EL PASO |  | ESTIMATED
 |  |  | FIELD |  |  | PRODUCTION |  |  | NATURAL |  | SAN JUAN
 |  |  | SERVICES |  |  |  |  |  | GAS* |  | TOTAL
 |  | CUM | CURRENT |  | CUM | CURRENT |  | CUM | CURRENT |  | CURRENT
 |  | -70145 |  |  | -55807 |  |  | 268892
2001-01-01 00:00:00 |  | -44467 |  |  | -32211 |  |  | 198073
2001-02-01 00:00:00 |  | -9747 |  |  | -38475 |  |  | 173680
2001-03-01 00:00:00 |  | 30129 |  |  | -32230 |  |  | 168646
2001-04-01 00:00:00 |  | 121747 |  |  | 82528 |  |  | 255346
2001-05-01 00:00:00 |  | 278779 |  |  | 94855 |  |  | 300960
2001-06-01 00:00:00 |  | 286331 |  |  | 59179 |  |  | 170528
2001-07-01 00:00:00 |  | 310268 |  |  | 54883 |  |  | 27596
2001-08-01 00:00:00 |  | 275390 |  |  | 87070 |  |  | -65974
2001-09-01 00:00:00 |  | 230460 |  |  | 50022 |  |  | -75692
 | * ASSUMING 100% FROM SAN JUAN
COMPARISON OF REVENUES FROM DIFFERENT USES OF EXCESS RETAINED FUEL - $
 |  |  |  |  |  | KEEP SHIPPERS WHOLE |  |  | CUT DELIVERIES
 |  |  |  |  |  | GET IMBALANCE GAS |  |  | SELL EXCESS RETAINED
 |  |  |  |  |  | BACK BY YEAR END |  |  | FUEL RIGHT AWAY
 |  | ESTIMATED |  |  | ASSUMED | EST |  | ASSUMED | EST
 |  | SAN JUAN |  |  | RATE / |  |  | SALE
 |  | IMBALANCE VOL |  |  | PRICE | REVENUES |  | PRICE | REVENUES
 |  | MMBTU |  |  | $/MMBTU | $ |  | $/MMBTU | $
 |  |  | NPV @ | 0.05
2001-01-01 00:00:00
2001-02-01 00:00:00 |  |  |  | T | 0.3823 |  | S | 5.62
2001-03-01 00:00:00 |  |  |  | T | 0.3823 |  | S | 4.99
2001-04-01 00:00:00 |  |  |  | T | 0.3823 |  | S | 4.87
2001-05-01 00:00:00 |  |  |  | T | 0.3823 |  | S | 3.82
2001-06-01 00:00:00
2001-07-01 00:00:00
2001-08-01 00:00:00
2001-09-01 00:00:00
2001-10-01 00:00:00
2001-11-01 00:00:00
2001-12-01 00:00:00 | PBG |  |  |  | 4.23
 | T | TRANSPORTATION RATE FROM SAN JUAN TO THOEAU AREA
 | S | SALE PRICE @ WEIGHTED AVERAGE GAS DAILY TW INDEX PRICES
 | PBG | PAY BACK GAS @ BREAK EVEN SETTLED CASH OUT PRICE (ASSUMING VOLUMETRIC OBA'S
 |  | WILL BE CONVERTED TO CASH IN CASH OUT OBA'S BY YEAR END)
Spreadsheet: gerald_nemec__11310__Bay2-23termsheet
Sheet: Retail Tariff

Electrical Tariff Analysis
Supplier: | Alabama Power
Tariff: | LPTL
EES (Discount)/Premium:
EES Quoted Term (Yrs)
EES Quoted Tariff |  | /kwh
ECS Calculated Tariff |  | /kwh
Total Electric Cost |  | $000
Total Kwhrs
Customer Charge: | 1000 | $/month
Monthly Demand Charges:
Billing Demand | 0 | $/kw
Peak Billing Demand | 0 | $/kw
Energy Charge:
On-Peak Energy Charge | 0 | $/kWh .1153 | Weighted Average Energy & Fuel Cost
Intermediate Energy Charge | 0.0375 | $/kWh | [NAME]. Off-Peak
AverageOnPeak/Intermediate |  | $/kWh | Avg. Intermediate
Off-Peak Energy Charge | 0.0109 | $/kWh | Avg. On-Peak
 |  |  | Weighted Avg
Energy Cost Recovery:
On-Peak Fuel Charge | 0 | $/kWh  .01463
Intermediate Fuel Charge | 0.014629 | $/kWh
AverageOnPeak/Intermediate
Off-Peak Fuel Charge | 0.014629 | $/kWh
Transformer Ownership Discount | -1.3 | $/kw Discount |  |  |  | $'s/hr
Metering Discount | 0 | off energy and billing demand
Tax Adjustment | -0.02645
ST. Util [NAME] | 0.018
State [NAME] | 0.039139
Monthly Minimum Charge | 2 | monthly minimums not being used in the cash flows
On-Peak Available Hours |  | (June 1- Sept 30 12:00 noon- 7:00)
Intermediate Avaible Hours |  | (June 1- Sept 30 10:00am-12:00 noon; 7:00-9:00pm, Oct 1-May 31 7:00 am - 9:00 pm)
Off-Peak Available Hours |  | All other times
Total Available Hours (annually)
 |  |  |  |  | on peak
Month | # days | # of Week Days | total hours | on-peak | Intermediate | off-peak | Average Off-Peak | Average Intermediate | Average On-peak | Intermediate
2000-01-01 00:00:00 |  | 21 |  | 0
2000-02-01 00:00:00 | 28 |  |  | 0
2000-03-01 00:00:00 |  | 21 |  | 0
2000-04-01 00:00:00 |  | 20 |  | 0
2000-05-01 00:00:00 |  | 21 |  | 0
2000-06-01 00:00:00 |  | 20 |  | 0
2000-07-01 00:00:00 |  | 21 |  | 0
2000-08-01 00:00:00 |  | 21 |  | 0
2000-09-01 00:00:00 |  | 20 |  | 0
2000-10-01 00:00:00 |  | 21 |  | 0
2000-11-01 00:00:00 |  | 20 |  | 0
2000-12-01 00:00:00 |  | 21 |  | 0
# wks/Month
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
 | 280 | 294 | 280 | 294 | 80 | 84 | 84 | 80 | 294 | 280 | 294
Spreadsheet: 88305d1288172907-conversion-within-sum-cntr-freight-rates-amm_send
Sheet: cee+egypte+guat

 | Exchange rates |  |  |  |  |  |  |  | tonnage
 | IEURUSD |  | 1.3814 |  |  |  | felixstowe |  | 22.5
 | IGBPUSD |  | 1.5813 |  |  |  | hamburg |  | 22.5
 | IGBPEUR |  | 1.144708266975532 |  |  |  | le havre |  | 23
 | IEURGBP |  | 0.8735850249794473 |  |  |  | antwerp |  | 23
 | IUSDEUR |  | 0.7239032865209208 |  |  |  | [NAME] |  | 23
 | IUSDGBP |  | 0.6323910706380826 |  |  |  | dunkirk |  | 23
 | IUSDUSD |  | 1 |  |  |  | [NAME] |  | 25
 | IEUREUR |  | 1 |  |  |  | sukhna |  | 25
 | IGBPGBP |  | 1 |  |  |  | PUERTO QUETZAL |  | 25
 |  |  |  |  |  |  | PARANAGUA |  | 27
 |  |  |  |  |  |  | SANTOS |  | 27
Origin | Destination | CR | base rate/tc | CR | BAF | CR | THC +ISPS ORIGIN | CR | ERS/EBS/SUEZ/ERC/LOC | rate /mt | CR |  | SPECIAL CONDITIONS
ANTWERP |  | USD | 860 | USD | 10 | USD | 10 | USD | 10 | #N/A | USD
FELIXSTOWE |  | USD | 860 | USD | INCL | GBP | INCL | GBP | 100 | #N/A | USD
HAMBURG |  | GBP | 860 | GBP | INCL | EUR | INCL | EUR | 100 | 0 | GBP
PUERTO QUETZAL |  | GBP | 2060 | GBP | INCL | USD | 0 | USD | 830 | #N/A | GBP
PUERTO QUETZAL |  | EUR | 1700 | EUR | INCL | GBP | 0 | GBP | 175 | #N/A | EUR
Spreadsheet: 799712d1665227935-additional-charge-on-incremental-year-additional-charge-on-incremental-year
Sheet: Sheet1

 | Additional Charge on Incremental Year
 |  |  |  |  | <--------------------------------------------------------- Expected Results --------------------------------------------------------->
 | Normal Inspection | Start Year | Annual Charge | No. of Units | 1
 | Type A Machinery | 1 | 100 | 1200
 | Type B Machinery | 3 | 200 | 1800
 | Type C Machinery | 5 | 300 | 2100
 | Additional Inspection | Increment Year* | Annual Charge | Machinery A | Machinery B | Machinery C
 | Special inspection #1 | 0 | 150 | 0.1 | 0 | 0.1
 | Special inspection #2 | 1 | 200 | 0.05 | 0.05 | 0.05
 | * incremental year from start year of respective machinery => for Type A Machinery, Normal Inspection starts on Year 1 while Special Inspection #2 starts on Year 2 (1+1)
 | 3 different types of machinery (Type A, B and C) and 3 different sets of inspections (Normal Inspection and 2 additional inspections: Special Inspection #1 and Special Inspection #2).
 | Special inspections start based on the incremental year from start year of respective machinery.
Spreadsheet: 874185d1720744491-trying-to-get-generate-accurate-trend-labels-example3
Sheet: Trend

 | Jan | Feb | Mar | Apr | May | Jun | Trend | Trendline
 | 15.8125 | 12.72222222222222 | 13.0625 | 14.05 | 11.35294117647059 | 11.41176470588235
 | 13.86363636363636 | 13.0625 | 9.666666666666666 | 14.3 | 13 | 11.66666666666667
 | 9.434782608695652 | 9.666666666666666 | 6.5 | 10.8 | 13.47058823529412 | 15.13333333333333
Spreadsheet: mike_grigsby__27820__HS_WESTall1029
Sheet: Run Query

Daily Hedge Strip
User ID:
Password:
Included Deals | ALL
Today
Days in Month | 30
Day of Month |  | 2001-10-26 00:00:00 | Update this cell daily
PromptMonth | 2001-11-01 00:00:00 | 2001-11-30 00:00:00
StartRange | D4
Enter EASTMEX Date:
[NAME] | NXB2 | NX1
2001-10-25 00:00:00 | 2001-10-26 00:00:00 | 2001-10-29 00:00:00
Please Note:  Once the 'RUN ' button has been pressed, please do not disturb Excel.  Doing so will make you a bad person.
Book Type | Book
Type
D | ENA-FT-WC-CAL-BAS
D | ENA-FT-WT-CAL-BAS
D | ENA-FT-WC-ROX-BAS
D | MGMT-WEST-BAS
D | FT-PGE-BAS
D | ENA-FT-WT-SJ-BAS
D | ENA-FT-WC-SJ-BAS
D | ENA-FT-WT-ROX-BAS
D | FT-DENVER-BAS
D | FT-REGS-BAS
D | ENA-FT-WT-SOCAL-BAS
D | FT-WEST-OPT-BAS
DO | FT-NW-XL-OPT-BAS
DO | FT-WE-XL-OPT-BAS
DO | MGMT-WE-XL-OPT-BAS
DO | GD-NEW-XL-OPT-BAS
D | TRANS-WEST-BAS
D | LT-TRANS-WE-BAS
M | ENA-FT-WC-CAL-GDL
M | ENA-FT-WT-CAL-GDL
M | ENA-FT-WC-ROX-GDL
M | MGMT-WEST-GDL
M | FT-PGE-GDL
M | ENA-FT-WT-SJ-GDL
M | ENA-FT-WC-SJ-GDL
M | ENA-FT-WT-ROX-GDL
M | FT-DENVER-GDL
M | FT-REGS-GDL
M | ENA-FT-WT-SOCAL-GDL
M | ENA-FT-WT-SCAN-GDL
PHY | ENA-IM-WC-CAL-PHY
PHY | ENA-IM-WT-CAL-PHY
PHY | ENA-IM-WC-ROX-PHY
PHY | MGMT-WEST-PHY
PHY | ENA-IM-WT-SJ-PHY
PHY | ENA-IM-WC-SJ-PHY
PHY | ENA-IM-WT-ROX-PHY
PHY | INTRA-DENVER-PHY
PHY | ENA-FT-WT-SOCAL-PHY
I | ENA-FT-WC-CAL-IDX
I | ENA-FT-WT-CAL-IDX
I | ENA-FT-WC-ROX-IDX
I | MGMT-WEST-IDX
I | FT-PGE-IDX
I | ENA-FT-WT-SJ-IDX
I | ENA-FT-WC-SJ-IDX
I | ENA-FT-WT-ROX-IDX
I | FT-DENVER-IDX
I | FT-REGS-IDX
I | ENA-FT-WT-SOCAL-IDX
Spreadsheet: 181917d1348203083-please-review-vba-having-trouble-auto-sending-email-reminder-from-excel-project-due-reminder-ver-1
Sheet: Test Notification

2012-09-15 00:00:00 | [NAME] | Subject: | You have a project bidding today! |  |  |  |  |  |  |  | %0a
 |  | Body: | Hey $,  I just wanted to remind you that you have a project bidding today. Give it some thought and I wish you the best of luck!  Sincerely, @ | Hey $,%0a%0aI just wanted to remind you that you have a project bidding today. Give it some thought and I wish you the best of luck!%0a%0aSincerely,%0a@
 |  | Your name: | [NAME]
PM First Name | PM First Initial | PM Last Name | PM Last Name | Mail Link
[NAME] | a | grazzini | [EMAIL]
Jon | j | trosvig | [EMAIL]
Greg | g | grazzini | [EMAIL]
Guido | g | gliori | [EMAIL]
Jed | j | simi | [EMAIL]
Mark | m | miranda | [EMAIL]
[NAME] | j | byrne | [EMAIL]
[NAME] | l | ahola | [EMAIL]
[NAME] | j | sheedy | [EMAIL]
Samantha | s | nathe | [EMAIL]
[NAME] | t | harju | [EMAIL]
Micah | m | vrieze | [EMAIL]
RoseMarie | r | barberio | [EMAIL]
Spreadsheet: 05a6b826-78f3-47d0-aade-fb44297d15f3
Sheet: Sheet1

Unnamed: 0 | Unnamed: 1
One of the best ways to assess where you stand financially is to calculate your net worth. When you add up all of your assets and subtract your debts at least once a year, you can clearly see if you’re progressing towards your goals or movingbackwards. You may be investing more money in your retirement accounts each year, for example, but your net worth may actually be shrinking if you’re also taking on more debt. Breaking down your assets and your liabilities into categories also makes it easier to see where you can beef up your savings, and which liabilities are holding you back.  To calculate your net worth, you (and your spouse) will need to dig up your recent financial statements and do a little research. Be sure to calculate your net worth once a year to see how your wealth grows over time.  The shaded cells will be automatically tallied based on the formulas in the worksheet. These fields are not editable.
Assets | Value
Bank Accounts Savings, checking, CDs, money market
Personal Property Home, home contents, automobile, boat/recreational vehicle, collectibles, jewelry
Investments Stocks, bonds, mutual funds, exchange-traded funds, real estate/REITs, life insurance (cash surrender value), college savings plans, other investments
Retirement Savings  Employer-sponsored plans (401(k), 403(b), 457,SIMPLE, [NAME] (including employer contribution if vested)), IRAs, defined benefit (pension) plan, annuities (cash surrender value)
Other  Money you are owed, other assets
Total Assets | 0
Liabilities: | Value
Credit Cards
Personal Loans  Mortgage, additional mortgage/home equity loan, car loan, student loan, bank loan, other personal loans
Investment Loans  Brokerage account loan, 401(k) loan, insurance loan, business loan, other investment loans
Other  Back taxes owed, other debts
Total Liabilities | 0
Net Worth  (Total Assets - Total Liabilities) | 0
Spreadsheet: 789462d1659105357-hlook-up-not-working-last-man-standing
Sheet: week 1

 | Week 1
 | NAME | TEAM
Spreadsheet: tracy_geaccone__40260__C0366-112458
Sheet: Dept_100193

ENRON PROPERTY & SERVICES CORP
1400 Smith Street
Houston, Texas   77251 - 1188
MONTHLY INVOICE DETAIL
ENRON BUILDING - Dept. 100193
June, 2001
0366  EOC - Executive
Date | Ticket Number | Work Order | Service Name | Service Description | # [NAME] | Unit Cost | UOM | Service | Ticket
 |  |  |  |  |  |  |  | Total | Total
 |  |  | R/C 112458
2001-06-21 00:00:00 | EBR01/06 -ECN 4145a |  | Building Rent | Sq. Ft. Occupied | 88 | 2.08 | /MNTH | 183.33
 |  |  |  |  |  |  | Ticket Total |  | 183.33
2001-06-21 00:00:00 | EBR01/06 -ECN 4155b |  | Building Rent | Sq. Ft. Occupied | 77 | 2.08 | /MNTH | 160.41
 |  |  |  |  |  |  | Ticket Total |  | 160.41
 |  |  |  |  |  |  | Total for R/C: 112458 |  | 343.74
 |  |  |  |  |  |  | Total for Dept_100193 |  | 343.74
Spreadsheet: 629525d1561393917-help-with-a-string-of-if-statements-sample
Sheet: Data Input & Output

Borrower:
Loan | Value | Rent | Initial Asset Yield | Initial Debt Yield | Initial ICR | Initial Post Tax DSCR | Entry LTV | [NAME] | EIR | WAULT | Debt psf | Borrower Grade | EIR
[NAME] |  |  |  |  | Model Output |  |  | Appetite | Entry | Year 3 | Exit | Notes
[NAME] (years) |  |  |  |  | Opening Loan Balance |  |  | < €15,000,000 |  |  | N/A | Maximum Connection Exposure €25m
Interest Rate |  |  |  |  | Opening LTV |  |  | 0.8 |  |  | N/A | Maximum Zone C LTV 75%
Service Charges & Costs |  |  |  |  | Stressed Case Pre-Tax ICR |  |  | 1.2 |  |  |  | Increased to 1.40 for Zone C
Tax Payable |  |  |  |  | Base Case Pre-Tax DSCR |  |  | 1.1
Arrangement Fee |  |  |  |  | Stressed Case Post-Tax DSCR |  |  | 1
Minimum Redemption Fee |  |  |  |  | Closing Loan Balance |  |  | < €15,000,000 | N/A |  |  | Maximum Connection Exposure €25m
Drawdown Commission |  |  |  |  | Closing LTV |  |  | N/A | N/A
Cashflow Assumptions
Spreadsheet: 97716d1296826291-conditional-formatting-for-stacked-bar-chart-stacked-gantt-bar-chart
Sheet: Sheet1

Researcher | Recruiting Participant | Planned start month | Duration in months | Type of researcher
1 | LES | 4 | 21 | ESR
2 | LES | 12 | 21 | ESR
3 | LES | 17 | 21 | ESR
4 | LES | 14 | 11 | ER
5 | LES | 24 | 6 | ER
6 | ULB | 4 | 21 | ESR
7 | ULB | 12 | 21 | ESR
8 | ULB | 17 | 21 | ESR
9 | ULB | 12 | 12 | ER
10 | ULB | 21 | 6 | ER
11 | Bocconi | 3 | 24 | ESR
12 | Bocconi | 12 | 24 | ESR
13 | Bocconi | 17 | 24 | ESR
14 | Bocconi | 14 | 12 | ER
15 | Bocconi | 24 | 6 | ER
16 | SIAWHSG | 5 | 24 | ESR
17 | SIAWHSG | 17 | 24 | ESR
18 | SIAWHSG | 17 | 6 | ER
19 | UW | 4 | 24 | ESR
20 | UW | 12 | 24 | ESR
21 | UW | 18 | 24 | ER
22 | UW | 12 | 12 | ER
Spreadsheet: 552481d1513607739-sumif-for-a-specific-item-code-edit-power-query
Sheet: Sheet2

To Number | 4424-9999 | 3647-5874 | 5746-0000 |  |  |  | Sum of Balance | Column Labels
TO605 | 7620 |  |  |  |  |  | Row Labels | 4424-9999 | 3647-5874 | 5746-0000
TO606 | 1688 |  |  |  |  |  | TO605 | 7620
TO607 | 620 |  |  |  |  |  | TO606 | 1688
TO608 | 0 |  |  |  |  |  | TO607 | 620
FS-20-006 |  | 6000 |  |  |  |  | TO608 | 0
FS-86-013 |  | 3000 |  |  |  |  | FS-20-006 |  | 6000
FS-467-001 |  | 5000 |  |  |  |  | FS-86-013 |  | 3000
FS-103-006 |  | 600 |  |  |  |  | FS-467-001 |  | 5000
100-19-844-ST |  |  | 14564.05 |  |  |  | FS-103-006 |  | 600
132-04 ST |  |  | 26 |  |  |  | 100-19-844-ST |  |  | 14564.05
143-11 ST |  |  | 8735 |  |  |  | 132-04 ST |  |  | 26
25-07 ST |  |  | 7876 |  |  |  | 143-11 ST |  |  | 8735
 |  |  |  |  |  |  | 25-07 ST |  |  | 7876
Spreadsheet: 724673d1616310100-excel-formula-to-match-variable-contributions-variable-contributions
Sheet: Sheet1

VARIABLE  DEDUCTIONS
 |  |  | PERIOD
Code | Name | [NAME] | 1 | 2 | 3 | 4 | 5 | 6 | 7 | 8 | 9 | 10 | 11 | 12
CA1 | MARGARET MADEGA | Funeral | 52 | 55 | 56 | 57 | 57 | 60 | 60 | 82 | 83 | 84 | 84 | 90
 |  | Medical AID | 10 | 12 | 14 | 16 | 18 | 20 | 22 | 24 | 26 | 28 | 30 | 32
 |  | Trade Union | 5 | 7 | 9 | 11 | 13 | 15 | 17 | 19 | 21 | 23 | 25 | 27
 |  | Others | 3 | 3.5 | 4 | 4.5 | 5 | 5.5 | 6 | 6.5 | 7 | 7.5 | 8 | 8.5
CA2 | OLIVIA CHINAKA | Funeral | 61 | 61 | 63 | 65 | 65 | 68 | 68 | 70 | 75 | 75 | 76 | 80
 |  | Medical AID | 10 | 12 | 14 | 16 | 18 | 20 | 22 | 24 | 26 | 28 | 30 | 32
 |  | Trade Union | 5 | 7 | 9 | 11 | 13 | 15 | 17 | 19 | 21 | 23 | 25 | 27
 |  | Others | 3 | 3.5 | 4 | 4.5 | 5 | 5.5 | 6 | 6.5 | 7 | 7.5 | 8 | 8.5
CA3 | BEAUTY GAVHURE | Funeral | 55 | 56 | 56 | 57 | 57 | 60 | 60 | 82 | 83 | 84 | 84 | 90
 |  | Medical AID | 10 | 12 | 14 | 16 | 18 | 20 | 22 | 24 | 26 | 28 | 30 | 32
 |  | Trade Union | 5 | 7 | 9 | 11 | 13 | 15 | 17 | 19 | 21 | 23 | 25 | 27
 |  | Others | 3 | 3.5 | 4 | 4.5 | 5 | 5.5 | 6 | 6.5 | 7 | 7.5 | 8 | 8.5
CA4 | JULIUS RWAFA | Funeral | 59 | 61 | 63 | 65 | 65 | 68 | 68 | 70 | 75 | 75 | 76 | 80
 |  | Medical AID | 10 | 12 | 14 | 16 | 18 | 20 | 22 | 24 | 26 | 28 | 30 | 32
 |  | Trade Union | 5 | 7 | 9 | 11 | 13 | 15 | 17 | 19 | 21 | 23 | 25 | 27
 |  | Others | 3 | 3.5 | 4 | 4.5 | 5 | 5.5 | 6 | 6.5 | 7 | 7.5 | 8 | 8.5
CA5 | ENITA MATAMBO | Funeral | 51 | 53 | 56 | 57 | 57 | 60 | 60 | 82 | 83 | 84 | 84 | 90
 |  | Medical AID | 10 | 12 | 14 | 16 | 18 | 20 | 22 | 24 | 26 | 28 | 30 | 32
 |  | Trade Union | 5 | 7 | 9 | 11 | 13 | 15 | 17 | 19 | 21 | 23 | 25 | 27
 |  | Others | 3 | 3.5 | 4 | 4.5 | 5 | 5.5 | 6 | 6.5 | 7 | 7.5 | 8 | 8.5
I am kindly asking for excel formula to match column F, G & H using the above data. The desired outcome is in column E29 to E38
Date | Period | Code | Employee Name | Funeral | Medical AID | Trade Union | Others
2021-01-28 00:00:00 | 1 | CA3 | BEAUTY GAVHURE | 55
2021-01-28 00:00:00 | 1 | CA5 | ENITA MATAMBO | 51
2021-01-28 00:00:00 | 1 | CA4 | JULIUS RWAFA | 59
2021-01-28 00:00:00 | 1 | CA1 | MARGARET MADEGA | 52
2021-01-28 00:00:00 | 1 | CA2 | OLIVIA CHINAKA | 61
2021-02-28 00:00:00 | 2 | CA3 | BEAUTY GAVHURE | 56
2021-02-28 00:00:00 | 2 | CA5 | ENITA MATAMBO | 53
2021-02-28 00:00:00 | 2 | CA4 | JULIUS RWAFA | 61
2021-02-28 00:00:00 | 2 | CA1 | MARGARET MADEGA | 55
2021-02-28 00:00:00 | 2 | CA2 | OLIVIA CHINAKA | 61
2021-03-28 00:00:00 | 3 | CA3 | BEAUTY GAVHURE
2021-03-28 00:00:00 | 3 | CA5 | ENITA MATAMBO
2021-03-28 00:00:00 | 3 | CA4 | JULIUS RWAFA
2021-03-28 00:00:00 | 3 | CA1 | MARGARET MADEGA
2021-03-28 00:00:00 | 3 | CA2 | OLIVIA CHINAKA
Spreadsheet: 89289d1289049449-auto-sorting-left-to-right-sort-left-to-right-simplified
Sheet: data

315 | 313 | 316 | 0313 | 0315 | 0316
5391 | 5396 | 5393 | 5391 | 5393 | 5396
8061 | 8060 | 8069 | 8060 | 8061 | 8069
6172 | 6171 | 6178 | 6171 | 6172 | 6178
8224 | 8225 | 8224 | 8224 | 8224 | 8225
2074 | 2071 | 2078 | 2071 | 2074 | 2078
4887 | 4880 | 4889 | 4880 | 4887 | 4889
7728 | 7724 | 7725 | 7724 | 7725 | 7728
8336 | 8334 | 8335 | 8334 | 8335 | 8336
2516 | 2517 | 2512 | 2512 | 2516 | 2517
218 | 210 | 219 | 0210 | 0218 | 0219
6175 | 6174 | 6175 | 6174 | 6175 | 6175
426 | 425 | 424 | 0424 | 0425 | 0426
1133 | 1132 | 1137 | 1132 | 1133 | 1137
756 | 752 | 757 | 0752 | 0756 | 0757
8923 | 8926 | 8923 | 8923 | 8923 | 8926
2303 | 2302 | 2307 | 2302 | 2303 | 2307
7268 | 7263 | 7266 | 7263 | 7266 | 7268
1333 | 1330 | 1339 | 1330 | 1333 | 1339
6538 | 6532 | 6537 | 6532 | 6537 | 6538
9315 | 9315 | 9314 | 9314 | 9315 | 9315
1834 | 1835 | 1834 | 1834 | 1834 | 1835
1321 | 1321 | 1328 | 1321 | 1321 | 1328
Spreadsheet: 97901d1297012249-identifying-the-lowest-number-in-a-row-book1_jay_hl
Sheet: Sheet1

10
9
8
7
6
5
4
3
2
1 | Lowest
5
10
9
8
7
6
5
4
3
2
1
5
Spreadsheet: 85292d1285324863-dynamic-sumif-ef-dynamic-sumif
Sheet: 5

ZoneConcat | ClusterConcate | Circle | Zone | Cluster | 2010-04-10 00:00:00 | 2010-05-10 00:00:00 | 2010-06-10 00:00:00 | 2010-07-10 00:00:00
 |  | ASSAM | [NAME] |  | 576 | 590 | 592 | 592
 |  | ASSAM | [NAME] |  | 514 | 520 | 520 | 520
 |  | ASSAM | Jorhat |  | 573 | 579 | 583 | 583
 |  | ASSAM | Shillong |  | 149 | 152 | 152 | 152
 |  | ASSAM | Tezpur |  | 273 | 279 | 282 | 282
 |  | NES | Manipur |  | 235 | 235 | 235 | 235
 |  | NES | Mizoram |  | 120 | 124 | 125 | 125
 |  | NES | Nagaland |  | 168 | 169 | 169 | 169
 |  | NES | Shillong |  | 172 | 172 | 173 | 173
 |  | NES | Tezpur |  | 34 | 34 | 34 | 34
 |  | NES | Tripura |  | 294 | 295 | 295 | 295
 |  | BH | [NAME] |  | 804 | 807 | 807 | 807
 |  | BH | Champaran |  | 734 | 741 | 753 | 753
 |  | BH | CHHAPRA |  | 563 | 563 | 563 | 563
 |  | BH | Darbhanga |  | 697 | 709 | 712 | 712
 |  | BH | Dhanbad |  | 471 | 472 | 472 | 472
 |  | BH | Patna |  | 795 | 797 | 813 | 813
 |  | BH | Purnea |  | 708 | 714 | 714 | 714
 |  | BH | Ranchi |  | 515 | 517 | 513 | 513
 |  | BH | Sasaram |  | 612 | 612 | 612 | 612
 |  | MP | BHOPAL |  | 886 | 885 | 905 | 905
 |  | MP | BILASPUR |  | 554 | 592 | 609 | 609
 |  | MP | GWALIOR |  | 749 | 749 | 753 | 753
 |  | MP | INDORE N |  | 642 | 654 | 660 | 660
 |  | MP | INDORE S |  | 768 | 771 | 782 | 782
 |  | MP | JABALPUR |  | 854 | 867 | 877 | 877
 |  | MP | RAIPUR |  | 679 | 659 | 667 | 667
 |  | MP | SATNA |  | 707 | 727 | 744 | 744
 |  | JK | Jammu |  | 574 | 574 | 574 | 574
 |  | JK | Batote |  | 291 | 291 | 291 | 291
 |  | JK | Srinagar |  | 516 | 516 | 516 | 516
 |  | JK | Baramulla |  | 358 | 358 | 358 | 358
 |  | JK | Anantnag |  | 408 | 408 | 408 | 408
 |  | HR | Hissar |  | 595 | 595 | 595 | 595
 |  | HR | Karnal |  | 566 | 566 | 566 | 566
 |  | HR | Rohtak |  | 502 | 502 | 502 | 502
 |  | UPW | Agra |  | 777 | 777 | 775 | 775
 |  | UPW | Bareilly |  | 586 | 586 | 584 | 584
 |  | UPW | Dehradun |  | 693 | 693 | 589 | 589
 |  | UPW | Meerut |  | 625 | 625 | 730 | 730
 |  | UPW | Moradabad |  | 656 | 656 | 659 | 659
 |  | UPE | Allahabad |  | 521 | 521 | 521 | 521
 |  | UPE | Faizabad |  | 531 | 531 | 531 | 531
 |  | UPE | [NAME] |  | 580 | 580 | 580 | 580
 |  | UPE | Jhansi |  | 352 | 352 | 352 | 352
 |  | UPE | [NAME] |  | 502 | 502 | 502 | 502
 |  | UPE | Lucknow |  | 601 | 601 | 601 | 601
 |  | UPE | Varanasi |  | 572 | 572 | 572 | 572
 |  | ORS | Bhubaneswar |  | 795 | 795 | 794 | 803
 |  | ORS | Balasore |  | 575 | 575 | 577 | 592
 |  | ORS | Bhawanipatna |  | 425 | 425 | 416 | 424
 |  | ORS | Berhampur |  | 452 | 452 | 454 | 455
 |  | ORS | Sambalpur |  | 572 | 572 | 586 | 589
Spreadsheet: 692252d1598236185-help-to-create-formula-with-multiple-if-statements-multiple-if-statements
Sheet: Sheet1

Wy | My | Answer
1.65 | 1.77 | ?? |  | If A is blank and B is blank then C = blank
1.38 | 0.97 | ?? |  | If A is blank and B is not blank then USE 100% of B
2.23 | 2.17 | ?? |  | If A is not blank and B is blank then USE 100% of A
1.93 | 1.35 | ?? |  | If A is not blank and B is not blank then USE 70% of A and 30% of B
0.4 | 0.43 | ??
0.37 |  | ??
0.58 | 0.66 | ??
1.04 |  | ??
2.02 |  | ??
 | 2.6 | ??