tianzl66/Sheetpedia huggingface dataset:
Spreadsheet: 866931d1713846774-complex-scheduling-in-excel-scheduler
Sheet: Schedule

 |  |  |  | TRAINEE SCHEDULING
 |  |  |  | AMER ONLY | Role | Salesforce | InContact | CSP | Objection Handling | Forecasting | Transformation Services | Implementation Plans | Pipeline Management | Calabrio | LC categories
 |  |  |  | Rep 1 | CS Advisor | YES | YES | YES
 |  |  |  | Rep 4 | CSM | YES | - | - | - | YES | YES | YES | YES
 |  |  |  | Rep 7 | Technical Rep | YES | - | - | - | - | YES | YES | - | YES | YES
 |  |  |  | Rep 10 | CS Specialist | YES | YES | YES | YES | - | - | - | - | - | -
 |  |  |  | Rep 13 | [NAME] | YES | - | YES | - | YES | YES | YES | YES | - | -
 |  |  |  | Presenter |  | Adam | Maria | Uma | Des | BB | Shao | Zyra | [NAME] | Chloe | Alaz
 |  |  |  | APAC ONLY | Role | Salesforce | InContact | CSP | Objection Handling | Forecasting | Transformation Services | Implementation Plans | Pipeline Management | Calabrio | LC categories
 |  |  |  | Presenter
 |  |  |  | [NAME] ONLY | Role | Salesforce | InContact | CSP | Objection Handling | Forecasting | Transformation Services | Implementation Plans | Pipeline Management | Calabrio | LC categories
 |  |  |  | Presenter
 |  |  |  | PRESENTER SCHEDULING
 |  |  |  | Presenter | Location | Salesforce | InContact | CSP | Objection Handling | Forecasting | Transformation Services | Implementation Plans | Pipeline Management | Calabrio | LC categories
 |  |  |  | Presenter 1 | AMER
 |  |  |  | Presenter 2 | APAC
 |  |  |  | Presenter 3 | EMEA
 |  |  |  | Presenter 4 | AMER
 |  |  |  | Presenter 5 | APAC
 |  |  |  | Presenter 6 | EMEA
 |  |  |  | Presenter 7 | AMER
 |  |  |  | Presenter 8 | APAC
 |  |  |  | Case: | Different trainees join the program with the different topics offered for their respective roles.  Since there are multiple topics, a lot of which are commonly offered to more than 1 role, we need a scheduling system in place so that it's easier to determine which sessions (topics) to offer for the month depending on which roles are joining.
 |  |  |  |  | We normally offer the sessions separately per geo but to maximize our resources (presenters), we combine 2 geos in 1 session in case there are only a few trainees joining in a certain geo for the month.
 |  |  |  | Problem: | We don't have allocated budget to pay a scheduling tool for this program so we will have to do manual scheduling but there should be a tracker to guide us which topics to offer in which geo (or which combined geo) for the month based on trainees roles joining.
 |  |  |  | The Ask: | Please help with formatting so that the trainee names will auto-populate in the above scheduling table based on entered roles under Trainees table
Spreadsheet: 872863d1719317538-countif-across-multiple-sheets-total
Sheet: January 2024

 | Nr | Name | Ref | Date | Rate | Location
 | 1 | Test 1 | 372/22 | 06.06.2021 | 1 | Location 2
 | 2 | Test 3 | 179/19 | 07.01.2019 | 1 | Location 3
 | 3 | Test 4 | 372/23 | 06.06.2022 | 1 | Location 4
 | 4 | Test 5 | 179/20 | 07.01.2020 | 1 | Location 5
 | 5 | Test 6 | 372/24 | 06.06.2023 | 1 | Location 6
 | 6 | Test 7 | 179/21 | 07.01.2021 | 1 | Location 7
 | 7 | Test 8 | 372/23 | 06.06.2022 | 1 | Location 8
 | 8 | Test 9 | 179/20 | 07.01.2020 | 1 | Location 9
 | 9 | Test 10 | 372/24 | 06.06.2023 | 1 | Location 10
 | 10 | Test 11 | 179/21 | 07.01.2021 | 1 | Location 11
 | 11 | Test 12 | 372/25 | 06.06.2024 | 1 | Location 12
 | 12 | Test 13 | 179/22 | 07.01.2022 | 1 | Location 13
 | 13 | Test 14 | 372/24 | 06.06.2023 | 1 | Location 14
 | 14 | Test 15 | 179/21 | 07.01.2021 | 1 | Location 15
 | 15 | Test 16 | 372/25 | 06.06.2024 | 1 | Location 16
 | 16 | Test 17 | 179/22 | 07.01.2022 | 1 | Location 17
 | 17 | Test 18 | 372/26 | 06.06.2025 | 1 | Location 18
 |  | ______________________________
 |  | Ferizaj
Spreadsheet: 193855d1352975306-selecting-a-group-of-4-numbers-from-within-a-string-of-8-by-matching-to-a-data-base-book1
Sheet: Sheet1

Item number | item | new item number | Helper | [NAME] | Number |  | Required
OR067342 | AGAVE DESMETTIANA VARIEGATA | 6734 | 067342 | 6734 | 6734 |  | 6734
006375 | CAESALPINIA GILLIESII | 637 | 006375 | 0637 | 637 |  | 637
GA09732PT | FERN-ATHYRIUM REGAL RED | 973 | 009732 | 9732 | 9732 |  | 9732
003455 | JASMINUM FLORIDUM | 345 | 003455 | 0345 | 345 |  | 345
CA072941 | YUCCA FIL GOLDEN SWORD | 7294 | 072941 | 7294 | 7294 |  | 7294
Spreadsheet: 845799d1697141906-manipulate-dynamic-array-change-column-order-apply-formula-by-column-dynamic-array-problems-3-
Sheet: Planilha1

 |  |  |  |  |  |  |  |  |  |  | Data |  |  |  | 1st attempt |  |  |  | FILTER | Grape Fruit
 |  |  | Other attemps |  |  |  |  |  |  |  | Item | Price | Date |  |  | Grape | 50
 |  |  | a | b | c |  | a | b | c |  | Grape Fruit | 100 | 2023-10-12 00:00:00 |  | 15-October | Grape | 95
 |  |  | 2 | 2 | 2 |  |  | 1 | 40 |  | Orange Fruit | 150 | 2023-10-13 00:00:00 |  | 17-October | Grape | 100
 |  |  | 2 | 2 | 2 |  | 2 | 1 | 40 |  | Orange Fruit | 50 | 2023-10-14 00:00:00
 |  |  | 2 | 2 | 2 |  | 2 | 1 | 40 |  | Grape Fruit | 190 | 2023-10-15 00:00:00 |  |  | Grape | 50
 |  |  | 2 | 2 | 2 |  | 2 | 1 | 40 |  | Orange Fruit | 300 | 2023-10-16 00:00:00 |  | 15-October | Grape | 95
 |  |  | 2 | 2 | 2 |  | 2 | 1 | 40 |  | Grape Fruit | 200 | 2023-10-17 00:00:00 |  | 17-October | Grape | 100
 |  |  | 2 | 2 | 2 |  | 2 | 1 | 40 |  | Orange Fruit | 110 | 2023-10-18 00:00:00
 |  |  |  |  |  |  |  |  |  |  | Apple Fruit | 50 | 2023-10-19 00:00:00
 |  |  |  |  |  |  |  |  |  | Want to column be | text replace | divide by 2 | format
 |  |  |  |  |  |  |  |  |  |  | What I Need
 |  |  |  |  |  |  |  |  |  |  | Date | Item | Price |  | *Is there a better or simple way?
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  | *COL(dados)=12 ==== I think this part of formula could broke so easy, maybe turn it dynamic, but I don’t know how..
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  | *Is LAMBDA the best way? Shoul I CHOOSE columns, then apply my needs, and then stack it again
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  | *FILTER, could I use my dynamic array in to the filter function criteria?
Spreadsheet: cb53847a-482f-4fbe-bc4b-5e4cd6d2f813
Sheet: Sheet1

Calculation of the Unit Cost for Transational Access | Unnamed: 1 | Unnamed: 2 | Unnamed: 3 | Unnamed: 4 | Unnamed: 5 | Unnamed: 6 | Unnamed: 7 | Unnamed: 8
Participant number |  | 1 | Organisation short name |  | UCL
Short name of Infrastructure |  | CRC | Installation number | 8.1 | Short name of Installation |  | NIF,LIF,GIF
Name of Installation |  | Centre de Recherches du Cyclotron (CRC) |  |  | Unit of access |  | Beam hour
A.  Estimated direct eligible costs of providing access within the project life-time excluding personnel costs | Describe the direct eligible costs for providing access to the installation over the project life-time (e.g. maintenance, utilities, consumable costs). All contributions to capital investments of the infrastructure are not eligible . |  |  |  |  |  |  | Eligible  Costs (€)
 | Electricity |  |  |  |  |  |  | 1292600
 | Maintenace (Consumables,Dosimetry) |  |  |  |  |  |  | 821532
 | Total A |  |  |  |  |  |  | 2114132
 | of which subcontracting (A’)
B.  Estimated personnel direct eligible costs needed to provide access within the project life-time | Category of staff |  |  |  | Nr. of hours |  | Hourly rate | (3) =
 | (scientific and technical only) |  |  |  | (1) |  | (2) | (1) x (2)
 | Scientific Staff (2 FTE) |  |  |  | 14400 |  | 44.22 | 636768
 | Enginneers (3 FTE) |  |  |  | 21600 |  | 41.4 | 894240
 | Technical Staff (10 FTE) |  |  |  | 72000 |  | 25.11 | 1807920
 |  |  |  |  |  |  |  | 0
 |  |  |  |  |  |  |  | 0
 |  |  |  |  |  |  |  | 0
 |  |  |  |  |  |  |  | 0
 |  |  |  |  |  |  |  | 0
 |  |  |  |  |  |  |  | 0
 | Total B |  |  |  |  |  |  | 3338928
[NAME] eligible costs = 7% x ([A-A’]+B) |  |  |  |  |  |  |  | 381714.2
D. Total estimated access eligible costs  = A+B+C |  |  |  |  |  |  |  | 5834774.2
E. Total estimated quantity of access provided to all normal users of the infrastructure      (i.e. both internal and external) within the project life-time |  |  |  |  |  |  |  | 10000
[NAME] of the Unit cost to be charged to the proposal [1] |  |  |  |  |  |  |  | 0.5
G. Estimated Unit cost charged to the proposal = F x (D/E) |  |  |  |  |  |  |  | 291.74
H. Quantity of access offered under the proposal (over the whole duration of the project) |  |  |  |  |  |  |  | 350
I.  Access Cost [2] = G x H |  |  |  |  |  |  |  | 102109
[1]  If only a fraction of the unit cost is being charged, please indicate the value of this fraction (in %) in line G.        If not, insert 100%.
[2]  In the case of a participant giving access to more than one infrastructure/installation with different unit costs, please         report in the administrative forms the sum of all the amounts coming from the individual unit cost calculation forms
Spreadsheet: vkaminski__40792__PnmaRegas021800
Sheet: Debt

Debt Service
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | TOTALS
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 9
Contract Year
Debt Periods
BOY Principal Outstanding
Principal Payment 1
Interest Payment 1
Debt Service 1
1st. Period Principal Out.
Principal Payment 2
Interest Payment 2
Debt Service 2
2nd. Period Principal Out.
% Principal Paid Pmt. 1
% Principal Paid Pmt. 2
BOY Principal Outstanding
Principal Payment 1
Interest Payment 1
Debt Service 1
1st. Period Principal Out.
Principal Payment 2
Interest Payment 2
Debt Service 2
2nd. Period Principal Out.
% Principal Paid Pmt. 1
% Principal Paid Pmt. 2
BOY Principal Outstanding
Principal Payment 1
Interest Payment 1
Debt Service 1
1st. Period Principal Out.
Principal Payment 2
Interest Payment 2
Debt Service 2
2nd. Period Principal Out.
% Principal Paid Pmt. 1
% Principal Paid Pmt. 2
Debt Service Summary
Annual Interest Payment
Annual Principal Payment
Total Debt Service
Spreadsheet: 300887d1393599298-expanding-a-data-set-in-one-column-by-inserting-a-data-set-from-another-column-index-match-answer
Sheet: Sheet1

 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | Look at orange cell formula.
 |  |  |  |  |  |  | Data Set 1 |  |  |  |  | Data Set 2 |  |  |  |  |  | Desired Result
 |  |  |  |  |  |  |  |  |  |  |  | J | 9 |  |  |  |  | A | 1
 |  |  |  |  |  |  |  |  |  |  |  | J | 7 |  |  |  |  | A | 2
 |  |  |  |  |  |  |  |  |  |  |  | A | 1 |  |  |  |  | A | 3
 |  |  |  |  |  |  |  |  |  |  |  | A | 2 |  |  |  |  | B | 2
 |  |  |  |  |  |  | 123 | A |  |  |  | A | 3 |  |  |  |  | B | 7
 |  |  |  |  |  |  | 123 | B |  |  |  | B | 2 |  |  |  |  | B | 4
 |  |  |  |  |  |  | 124 | F |  |  |  | B | 7 |  |  |  |  | B | 5
 |  |  |  |  |  |  | 124 | J |  |  |  | B | 4 |  |  |  |  | F | 7
 |  |  |  |  |  |  |  |  |  |  |  | B | 5 |  |  |  |  | F | 4
 |  |  |  |  |  |  |  |  |  |  |  | F | 7 |  |  |  |  | F | 5
 |  |  |  |  |  |  |  |  |  |  |  | F | 4 |  |  |  |  | J | 9
 |  |  |  |  |  |  |  |  |  |  |  | F | 5 |  |  |  |  | J | 7
 |  |  |  |  |  |  |  |  |  |  |  | Help needed
Spreadsheet: 133786d1324612721-doesnt-seem-right-from-previous-year-p-and-l2010help
Sheet: July

Profit and Loss Statement |  | Tax Year: |  | July
 |  | Monthly Summary | Total Income
 |  |  | Total Expense
Gross margin  [L/J]
Return on sales  [T/J] |  |  | Profit / (Loss)
Net Profit % Change from Prior Period
 | Prior Period | Current Period | Current Period as    % of Sales | % Change from Prior Period
Sales Revenue
Health Insurance
Medicare Advantage
Medicare Supplement
Life Insurance |  | 2500
Investment (Annuity)
Other
Total Sales Revenue  [J]
Cost of Sales
Specify
Total Cost of Sales  [K]
Gross Profit  [L=J-K]
Operating Expenses
Sales and Marketing
Advertising (Radio, TV, Print Media, etc)
Printing
Direct marketing
Seminar
Meals and Entertainment
Total Sales and Marketing Expenses  [M]
Research & Development
Licenses |  | 400
Education
Total Research & Development Expenses  [N]
General and Adminstrative
Rent
Payroll
Utilities
Telephone
Health Insurance
E&O Insurance
Software
Web Hosting and domains
Postage
Office Supplies
Equipment |  | 200
Repairs and maintenance
Other expenses (specify)
Auto (Tires, Fuel, Oil, Tolls, [NAME], etc)
Auto Mileage (IRS standard deduction; averaged) |  | 256
Total General & Adminstrative Expenses  [O]
Total Operating Expenses  [P=M+N+O]
Income from Operations  [Q=L-P]
Other Income (Bonuses) [R]
Taxes
Payroll Taxes
Property Taxes
Total Taxes  [S]
Net Profit  [T=Q+R-S]
Spreadsheet: benjamin_rogers__1249__MW Degradation for Scott
Sheet: Sheet1

 | MW Degradation
 |  |  |  | Avg. Heat
 |  |  | MW's | Rate (HHV)
 | GE Gross Output @ Sea Level |  | 48.5 | 9763.78
 | Avg. Altitude Adjustment |  | -0.75
 | Transformer Efficiency |  | -0.25
 | BOP & Auxiliary (Pumps, Fans, etc. ) |  | -0.75
 | Chillers (Adds 10 MW's) |  | -1.5
 | Gas Compression |  | -0.25
 | SCR's (Back Pressure) |  | -0.25
 | Total Plant Output |  |  | 10200
Spreadsheet: 54861d1254921144-a-formula-which-is-calculate-4-5-dates-formula-in-one-cell-form-1-
Sheet: Sheet1

1990-01-01 00:00:00 | 1994-09-30 00:00:00 |  |  | 4 years, 8 months, 29 days
1994-11-01 00:00:00 | 1995-07-30 00:00:00 |  |  | 0 years, 8 months, 29 days
1995-09-01 00:00:00 | 1997-12-30 00:00:00 |  |  | 2 years, 3 months, 29 days
1998-03-01 00:00:00 | 1999-09-01 00:00:00 |  |  | 1 years, 6 months, 0 days
1999-10-01 00:00:00 | 2000-01-01 00:00:00 |  |  | 0 years, 3 months, 0 days
2001-02-01 00:00:00 | 2002-07-01 00:00:00 |  |  | 1 years, 5 months, 0 days
2002-08-01 00:00:00 | 2005-09-01 00:00:00 |  |  | 3 years, 1 months, 0 days
2005-10-01 00:00:00 | 2007-03-01 00:00:00 |  |  | 1 years, 5 months, 0 days
2007-04-01 00:00:00 | 2008-12-01 00:00:00 |  |  | 1 years, 8 months, 0 days
2009-01-01 00:00:00 | 2009-10-07 00:00:00 |  |  | 0 years, 9 months, 6 days
TOTAL |  |  |  | 1917-11-29 00:00:00 | days
 |  |  |  | 17 years 3 month and 26 days
Spreadsheet: 109893d1306710464-monthly-rollup-of-data-201105-flare-events-
Sheet: 201105 Flare Events

 | Enter data only in Green cells from left to right.
 |  |  |  |  |  |  | Routine |  |  |  | Non Routine |  |  |  |  |  |  |  |  |  |  |  |  | All Codes | Routine | Non-Routine
DATE | Flare or Vent? | Event Type (Choose Code) | Start Time   (Military Format) | Stop Time    (Military Format) | Volume (MCF) | Operator Initial | Hours | Accum. Hrs | Released Volume (MCF) | Accum. Released Volume (MCF) | Hours | Accum. Hrs | Released Volume  (MCF) | Accum. Released Volume  (MCF) | Daily [NAME] (MCF) | Daily Routine Flare  Volume (MCF) | Daily Non- Routine Flare  Volume (MCF) | Daily Vent Metered Volume (MCF) | Daily Routine Methane Vent  Volume (MCF) | Daily Non- Routine Methane Vent Volume (MCF) |  |  | F |  | RO
2011-05-26 00:00:00 |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 256 |  |  | 237 |  |  |  |  | V | RO
 | F | PM | 01:15:00 | 01:24:00 | 3 | GLS |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | PM |  | PM
 | V | LC | 11:25:00 | 11:35:00 | 4 | GLS |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | LC |  | LC
 | F | SW | 15:30:00 | 18:20:00 | 55 | GLS |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | SW |  | SW
 | F | PM | 19:00:00 | 19:22:00 | 12 | GLS |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | UW |  | UW
2011-05-27 00:00:00 |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 185 |  |  | 245 |  |  |  |  |  | OL |  | OL
 | F | PM | 15:00:00 | 16:22:00 | 26 | test |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | OO |  | OO
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | CT |  | CT
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | WO |  | WO
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | NR |  | NR
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | LS |  | LS
Spreadsheet: phillip_m_love__30152__9905_OA
Sheet: EAST-LRC-FLSH

ENRON CAPITAL & TRADE RESOURCES
OPERATIONAL ANALYSIS - REPORTED
COMPANY:  LRC
 |  |  | NGP&L |  | CPR Adjustments |  | 3rd Day CPR |  | [NAME] |  | [NAME]
 |  |  | Volume | $'s | Volume | $'s | Volume | $'s | Volume | $'s | Volume | $'s
 | Sales:
1 |  | 3rd Party / Inter Enron | 8944488 | 21132760.95
2 |  | Liquidations | 0 | 0
3 |  | Interdesk | 3201196 | 7224493.05
4 |  | Option Premiums | 0 | 0
5 |  | Dmd Reimbursements | 0 | 0
 | Total Sales: |  | 12145684 | 28357254
 | Purchases:
6 |  | 3rd Party / Inter Enron | -1284613 | -2888637
7 |  | Liquidations | 0 | 0
8 |  | Interdesk | -11270806 | -25429998
9 |  | Option Premiums | 0 | 0
10 |  | [NAME] | 0 | 0
 | Total Purchases: |  | -12555419 | -28318635
 | Intra CTS (EGM / HPL / LRC):
11 |  | Sales | 1004508 | 2299953
12 |  | Purchases | -582660 | -1315137
 | Total Intra CTS Sales / Purchases |  | 421848 | 984816
 | Imbalances:
13 |  | In Kind | 0 | 0
14 |  | Cash Out | 0 | 0
15 |  | Cash In | 0 | 0
16 |  | Synthetic Storage | 0 | 0
 | Total Imbalances: |  | 0 | 0
 | Storage:
17 |  | Injection (Sales to Stg) | 947768 | 2227256
18 |  | W/D (Purchase from Stg) | -544397 | -1279332
19 |  | Inventory Profit | 0 | 0
 |  | Total W/D | -544397 | -1279332
 | Total Storage: |  | 403371 | 947924
20 | Linepack: |  | 0 | 0
 |  |  | 0 | 0
21 | Shrinkage: |  | 0 | 0
 |  |  | 0 | 0
22 | UA4: |  | -475484 | -1074270.939144055
 |  |  | 0 | 0
23 | Fuel: |  | 0 | 0
 |  |  | 0 | 0
 | Transport Expense: |  | 0 | 0
24 |  | Commodity | 0 | 0
25 |  | Demand | 0 | 0
 | Total Transport Expense: |  | 0 | 0
 | Transport Revenue:
26 |  | Interstate | 0 | 0
27 |  | Intrastate | 0 | 104001
 | Total Transport Revenue: |  | 0 | 104001
 | Intra CTS (EGM / HPL / LRC):
28 |  | Transport Expense | 0 | 0
29 |  | Transport Revenue | 0 | 0
 | Total Intra CTS Transport |  | 0 | 0
 | Tie Out Schedule Items:
 |  | MTM Income:
30 |  | Current Gross Book Balance | 0 | 0
31 |  | Prior Month Book Balance | 0 | 0
 |  | Total MTM Income | 0 | 0
32 |  | Prudency | 0 | 0
33 |  | Financial Liquidations | 0 | 0
34 |  | Originations | 0 | 0
35 |  | Broker Fees | 0 | 0
36 |  | Asset Group Demand Charges | 0 | -3897000
37 |  | [NAME] | 0 | 0
38 |  | Interdesk Charges | 0 | 0
39 |  | Canada | 0 | 0
40 |  | Miscellaneous | 0 | 0
 |  | TOTAL INTRA-MTH
Spreadsheet: 0434cb22-8701-4a2a-8b7f-3772680c1073
Sheet: Sheet2

TRANSFER REQUEST |  |  |  | ( TRANSFERRING FROM ONE ACCOUNT TO ANOTHER)
Date:
Amount: |  |  |  | $
Transferring FROM: |  |  | Account Name
(Transfer Out) |  |  | GL Acct Number
Transferring TO: |  |  | Account Name
(Transfer In) |  |  | GL Acct Number
Reason for Request:
Prepared By:
Telephone Ext.:
Approved By:
Telephone Ext.:
Approved By Financial Affairs:
Date:
NOTE:
This form is used to reclassify actual expenses or receipts from one business unit to another.  It should be submitted
to the Financial Affairs office by an authorized person responsible for the budget of the unit incurring the expense.
Examples might include:
(1) payment for an advertisement in the Navigator |  |  |  |  |  | Debit | 76120 | Advertising
 |  |  |  |  |  | (Credit) | 54115 | Adv. Income
(2) reclassify an expense that should be incurred by another unit |  |  |  |  |  | Debit | 80205 | Meals other than Travel
(e.g. absorbing a portion of a Sodexho event cost) |  |  |  |  |  | (Credit) | 80205 | Meals other than Travel
(3) make a "donation" from one business unit to another |  |  |  |  |  | Debit | 89150 | Transfer OUT
(such as sponsorship for the Women's Luncheon) |  |  |  |  |  | (Credit) | 59150 | Transfer IN
Spreadsheet: andy_zipper__108__test1
Sheet: Cost Structure

 |  |  |  |  | ENA Costs | BU Costs |  | EnronOnline Costs |  | Total Costs |  | Charge
 |  | New Market Area Launch
 |  |  | Set up New Country |  | 35454.54545454546 |  |  | 48275.16233766234
 |  |  | Set up New Business |  | 30389.6103896104 |  |  | 42366.07142857143
 |  | 1 | Set Up Product Types |  | 9602.272727272728 |  |  | 11607.14285714286
 |  | 2 | Set Up Counterparties |  | 23741.88311688312 |  |  | 5275.974025974027
 |  | 3 | Billed Costs |  | 25000 |  |  | 15500
 |  |  | Total Cost to launch a New Country
 |  |  | Total Cost to launch a New Business
 |  |  | Addition of new Product Type |  | 4801.428571428572 |  |  | 5803.571428571428
 |  |  | Addition of Product |  | 52.72077922077921 |  |  | 158.2792207792208
 |  |  | Addition of New Counterparty |  | 237.2402597402597 |  |  | 52.75974025974026
 |  | Annual Maintenance Fee
 |  |  | For first 2  Product types (15 products) |  |  |  |  |  |  | 20000
 |  |  | Incremental 10 Products/1 Product Type |  |  |  |  |  |  | 8000
 |  | New 3rd. Party Pipeline Launch
 |  |  | Set Up New Pipeline |  | 6331.168831168831 |  |  | 20312.5
 |  | 1 | Set Up Product Types |  |  |  |  | 10530.84415584416
 |  | 4 | Set Up Counterparties |  |  |  |  | 2532.467532467533
 |  |  | IT Infrastructure |  | 8400 |  |  | 0
 |  | 5 | Billed Costs |  | 10000 |  |  | 15000
 |  |  | Total Cost to launch a 3rd Party Pipeline
 |  |  | Total Cost to launch additional Pipeline
 |  |  | Hardware (Internal Servers) |  |  |  |  |  |  | 250000
 |  |  | Optional Bridging |  |  |  |  |  |  | 25000
 |  |  | Addition of new Pipeline Product Type |  |  |  |  | 5265.422077922078 |  | 5265.422077922078
 |  |  | Addition of pipeline Product |  |  |  |  | 211.038961038961 |  | 211.038961038961
 |  |  | Addition of New Counterparty for Pipeline |  |  |  |  | 84.41558441558442 |  | 84.41558441558442
 |  | Auctions
 |  |  | New Auction Set up (2 users) |  |  |  |  |  |  | 28010.14069264069
 |  |  | Incremental auction Type for BU |  |  |  |  |  |  | 738.6363636363636
 |  |  | Incremental Products |  |  |  |  |  |  | 7122.564935064935
 |  |  | Incremental Connection Fee: (per external user) |  |  |  |  |  |  | 2773.333333333333
 |  | Assumptions / Notes
 |  | 1.- | 2 Product Types included in cost calculation with a total of 15 Products.
 |  | 2.- | Cost includes existing customers plus 100 New Counterparties.
 |  | 3.- | Billed costs include:
 |  |  | $ 25,000 | : Local Counsel
 |  |  | $ 15,000 | : Travel for Bridging & Mapping set up, & Launch/Presentation
 |  |  | $ 500 | : Presentations
 |  | 4.- | Cost includes existing customers plus 30 New Counterparties.
 |  | 5.- | Billed costs include:
 |  |  | $ 10,000 | : 3rd. Party Counsel
 |  |  | $ 15,000 | : Travel for Project Management & Training
Spreadsheet: 773935d1648123819-wrong-nested-if-formula-ifnestedformula
Sheet: Example

Field | Formula 1 COUNTIF | [NAME] over 1 COUNTIF | LEFT | LEFT & COUNTIF | {MATCH}
Not Excellent [NAME]
Bad Super String
Bad Ideal String Bla Bla
[NAME] Just
Perfect String Rampam
[NAME]
[NAME]
Ignore Super String
[NAME]
Spreadsheet: 842922d1694915706-calculate-the-duration-book1
Sheet: Sheet1

start | end | duration
2023-09-15 09:00:00 | 2023-09-15 12:00:00 | 3 hours
2023-09-15 09:00:00 | 2023-09-18 12:00:00 | 1 day 3 hours
2023-09-15 09:00:00 | 2023-09-19 16:30:00 | 2 days 7 hours 30 Mins
2023-09-14 09:00:00 | 2023-09-15 10:00:00 | 1 day 1 hour
2023-09-15 00:00:00 | Friday
2023-09-16 00:00:00 | Saturday
2023-09-17 00:00:00 | Sunday
2023-09-18 00:00:00 | Monday
2023-09-19 00:00:00 | Tuesday
2023-09-20 00:00:00 | Wednesday
2023-09-21 00:00:00 | Thursday