tianzl66/Sheetpedia huggingface dataset:
Spreadsheet: andy_zipper__112__mODEL 3 7 01 Base
Sheet: Assumptions

 | Assumptions
 | Penetration Rates and Fees
 |  |  |  |  | Fixed Fee Probability of signing up |  | Variable Fee per Transaction |  | Fixed Fee per Month |  | Annual Growth In Transaction Volume |  | Counterparties Signed-up US |  | Counterparties Signed-up Rest of the world |  | Average number of systems to integrate |  | Average number of transactions per month US |  | Average number of transactions rest of the world
 | Lower Threshold |  | 10 |  | 0.1 |  | 8.1 |  | 500 |  | 0.05 |  |  |  |  |  | 1
 | First Transaction Threshold |  | 50 |  | 0.2 |  | 8.1 |  | 1000 |  |  |  |  |  |  |  | 1
 | Second Transaction Threshold |  | 200 |  | 0.3 |  | 8.1 |  | 2500 |  |  |  |  |  |  |  | 1.2
 | Third Transaction Threshold |  | 400 |  | 0.4 |  | 8.1 |  | 6000 |  |  |  |  |  |  |  | 1.5
 | Fourth Transaction Threshold |  | 1000 |  | 0.5 |  | 8.1 |  | 15000 |  |  |  |  |  |  |  | 2
 | Consulting Fees
 | Implementation Hour Cost |  | 200 |  | Use Revenues from US only ? (1=yes, 0=no) |  |  |  |  |  |  |  |  |  |  |  |  |  | 1
 | Number of consultants |  | 1
 | Number of days |  | 25
 | Single project implementation cost |  |  |  | Use Revenues from Transaction Fee (0), [NAME] (1) or both (2) |  |  |  |  |  |  |  |  |  |  |  |  |  | 1
 | Overall implementation cost (Rest of the world)
 | Overall implementation cost (US)
 | Percentage Captured by Enron |  | 0.2
 | [NAME] to Enron (Rest of the world)
 | [NAME] to Enron (US)
 | Total Lumber Contracted
 | % of counterparties where consultant creates a new relationship |  | 0.4
 | Cost for creating a new relationship |  | 50000
 | Enron Share for new relationship [NAME] of the world)
 | Enron Share for new relationship (US)
 | Revenues to Enron
 | One Time development Cost (SPV)
 | Cost of the Solution (Web Methods)
 | Implementation Cost (Web Methods)
 | Additional Implementation (SPV) |  | 50000
 | Management & Staff Hiring |  | 90000
 | Legal Support |  | 100000
 | Travel and Admin
 | Financial Analysis
 | Recurring costs
 | Hosting Cost including Hardware per Year
 | Customer Service Cost per Year
 | Additional Licensing Oracle 8i |  | 25000
 | Yearly Staff Cost |  | 300000
 | Marketing and Communications |  | 20000
 | Billing Management & Administration |  | 50000
 | General Assumptions
 | Consultant Share in SPV
 | Inflation |  | 0.03
 | Discount Rate |  | 0.25
 | IT Property Valuation |  | 500000
Spreadsheet: 768734d1645104036-lock-unlock-cells-based-on-multiple-other-cells-dv-drop-down-to-lock-cells-aligw
Sheet: Sheet1

Course code | Course Title | Unit Code | Choose | Edexcel |  |  | UAL |  |  |  | Awarding Body
 |  |  |  | P | M | D | P1 | M2 | D3 | F0 |  |  |  |  |  |  | Yes |  | 1
1234 | [NAME] | 5847U | No |  |  |  |  |  |  |  | Edexcel |  |  |  |  |  | No |  | 2
1235 | [NAME] | 9857U | No |  |  |  |  |  |  |  | Edexcel |  |  |  |  |  |  |  | 3
1236 | [NAME] | 2648U | No |  |  |  |  |  |  |  | UAL |  |  |  |  |  |  |  | 4
1237 | [NAME] | 2567U | Yes |  |  |  |  |  |  |  | UAL |  |  |  |  |  |  |  | 5
1238 | L5 Sport | 1289U | Yes |  |  |  |  |  |  |  | UAL |  |  |  |  |  |  |  | 6
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 7
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 8
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 9
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 10
Spreadsheet: daren_farmer__5746__HPL Deals with 3rd Parties
Sheet: Caption

 |  |  |  |  |  |  | 2001-01-16 10:16:43.010000
DEAL | [NAME] | avail | electric power | DUMP | BUYSE | BUSINESSUNIT | COUNTERPARTY | PRO | TYPETERMFIRMNESS | TRADEDT | avail | STATUS | DEAL LIFE | avail | avail | CONTRACTS | avail | avail | DEAL COUNT | avail | avail | BEGIN MO | avail | avail | END MO | avail | avail | avail | VOLUME | MIN VOL | MAX VOL | COMMODITY | EXTERNALFEES | INTERNALFEES | TRADE ZONE | METER
70120 | <1,000 |  |  |  | Sell | ENA - IM Texas | D & H Gas Company, Inc. | Gas | Physical Forward/Term/Firm | 1999-03-22 11:13:18 |  | Validated | 04/01/1999 - 04/30/2001 |  |  | 96007529 |  |  | 1 |  |  | 1999-04-01 00:00:00 |  |  | 2001-04-30 00:00:00 |  |  |  | varies | 22 | 70 | HOU.SHIP-LGPKG.IF.M.I and .45 USD/MMBtu |  |  | A/S East/ | Zone 7 -0428
102177 | <1,000 |  |  |  | Sell | ENA - IM Texas | Unit Gas Transmission Company Inc. | Gas | Physical Forward/Term/Firm | 1999-07-28 10:59:44 |  | Validated | 04/01/1999 - 03/31/2006 |  |  | 96002879 |  |  | 1 |  |  | 1999-04-01 00:00:00 |  |  | 2006-03-31 00:00:00 |  |  |  | 1 |  |  | HOU.SHIP-LGPKG.IF.M.I and .05 USD/MMBtu |  | Other Transport .02 USD/MMBtu | Ship Channel/ East Texas/ East Texas/ | Zone 10 -2000Zone 8 -1046Zone 8 -1195
102181 | <1,000 |  |  |  | Sell | ENA - IM Texas | Reliant Energy - Entex | Gas | Physical Forward/Term/Firm | 1999-07-28 11:03:07 |  | Validated | 04/01/1999 - 03/31/2006 |  |  | 96004582 |  |  | 1 |  |  | 1999-04-01 00:00:00 |  |  | 2006-03-31 00:00:00 |  |  |  | 1 |  |  | HOU.SHIP-LGPKG.IF.M.I and .05 USD/MMBtu |  | Other Transport .02 USD/MMBtu | Ship Channel/ | Zone 10 -2000
70422 | <1,000 |  |  |  | Sell | ENA - IM Texas | Markham Gas Corp. | Gas | Physical Forward/Term/Firm | 1999-03-23 12:02:28 |  | Validated | 04/01/1999 - 02/28/2001 |  |  | 96003353 |  |  | 1 |  |  | 1999-05-01 00:00:00 |  |  | 2001-02-28 00:00:00 |  |  |  | 48 |  |  | 2.75 USD/MMBtu |  |  | A/S South/ | Zone 3 -1038
78628 | <1,000 |  |  |  | Sell | ENA - IM Texas | Merit Energy Partners III, L.P. | Gas | Physical Forward/Term/Interruptible | 1999-04-26 15:14:00 |  | Validated | 04/01/1999 - 02/28/2001 |  |  | 96002832 |  |  | 1 |  |  | 1999-06-01 00:00:00 |  |  | 2001-02-28 00:00:00 |  |  |  | 1 |  |  | HOU.SHIP-LGPKG.IF.M.I and .25 USD/MMBtu |  |  | Hardin/ | Zone 20 -1535
92661 | >2,500 |  |  | y | Sell | HPLC - IM HPLC | Air Liquide America Corporation | Gas | Physical Forward/Term/Firm | 1999-06-21 16:51:46 |  | Validated | 07/01/1999 - 11/30/2003 |  |  | 96000847 |  |  | 1 |  |  | 1999-07-01 00:00:00 |  |  | 2003-11-30 00:00:00 |  |  |  | varies | 0 | 11000 | HOU.SHIP-LGPKG.IF.M.I and -.02 USD/MMBtu |  | Other Transport -.02 USD/MMBtu | Robstown/ | Zone 2 -1005
92663 | >2,500 |  |  | y | Sell | HPLC - IM HPLC | Air Liquide America Corporation | Gas | Physical Forward/Term/Firm | 1999-06-21 16:53:36 |  | Validated | 07/01/1999 - 11/30/2003 |  |  | 96000847 |  |  | 1 |  |  | 1999-07-01 00:00:00 |  |  | 2003-11-30 00:00:00 |  |  |  | varies | 0 | 4000 | HOU.SHPCHAN.GD.D.A and .02 USD/MMBtu |  | Other Transport -.02 USD/MMBtu | Robstown/ | Zone 2 -1005
Spreadsheet: 39890d1238146326-vlookup-query-amended-pricing-sheet
Sheet: Sheet 2

A/ | STAFF SUPERVISOR |  | WEEKS @ |  | PER WEEK | 0
 | PROJECT MANAGER | 0 | HOURS @ |  | PER HOUR | 0
 | DESIGN ENGINEER |  | WEEKS @ |  | PER WEEK | 0
 | SUPERVISOR |  | WEEKS @ |  | PER WEEK | 0
 | COMM. ENGINEER |  | WEEKS @ |  | PER WEEK | 0
 | FOREMAN |  | WEEKS @ |  | PER WEEK | 0
 | DRAFTSMAN |  |  |  |  | 0
 | TYPIST |  | WEEKS @ |  | PER WEEK | 0
 | PURCH/STORES |  | WEEKS @ |  | PER WEEK | 0
 | SUB TOTAL: |  |  |  |  | 0
 | ACCOMODATION
 | ABOVE PERSONNEL |  | WEEKS @ |  | PER WEEK | 0
 | MOBILISE PERSONNEL |  | TRIPS @ |  | PER TRIP | 0
 | TOTAL FOR SECTION (A) | (sent to item 'M' - front sheet) |  |  |  | 0
[NAME] | PLANT ETC. |  | SITE BUILDINGS
 | OFFICE |  | WEEKS @ |  | PER WEEK | 0
 | SITE STORE |  | WEEKS @ |  | PER WEEK | 0
 | COMPOUND |  | WEEKS @ |  | PER WEEK | 0
 | WORKSHOP |  | WEEKS @ |  | PER WEEK | 0
 | CRIB ROOM |  | WEEKS @ |  | PER WEEK | 0
 | ABLUTION BLOCK |  | WEEKS @ |  | PER WEEK | 0
 | MOVE IN/MOVE OUT |  |  |  |  | 0
 | SCAFFOLDING
 | SCISSOR LIFT/CHERRY PICKER
 | EXCAVATOR
 | BOBCAT
 | CRANE
 | CABLE WINCH & ROLLERS
 | CORE DRILLING
 | CHASING
 | FIRE RATING
 | ENGRAVING
 | SMALL TOOLS & EXPENDABLES
 | THERMO SURVEYS
 | PROJECT MANAGER [NAME]
 | SUPERVISORS VEHICLE
 | AS CONS/ DRAFTSMAN
 | PLAN PRINTING
 | TOTAL SECTION B: |  |  |  |  | 0
Spreadsheet: 887837d1738168096-generating-list-of-people-in-groups-sixes
Sheet: Register Winter 24

 | Subs Pd | Census | Joining Fee Pd | 2024-09-10 00:00:00 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | Attendance
 |  |  |  | 1 | 2 | 3 | 4 | 5 | 6 | 7 | 8 | 9 | 10 | 11 | 12 | 13 | 14 | 15 | 16
 | 32 |  |  | P | P | P | P | P | P | P | B | A | P | P | P | P | P | p | B
 | 32 |  |  | P | A | P | P | P | P | P | B | A | P | A | P | P | P | P | B |  |  | Key
 | 32 |  |  | P | P | P | P | P | P | A | B | A | P | A | P | A | P | P | B |  |  | L = Late
 | 32 |  |  | P | P | P | P | P | P | P | B | P | P | P | P | P | P | P | B |  |  | O = Other
 | 32 |  |  | A | P | P | P | P | P | A | B | P | P | P | P | P | P | P | B |  |  | B = Break
[NAME] | 32 |  |  | P | A | P | P | P | P | P | B | A | A | P | P | P | A | P | B
 | 32 |  |  | P | P | P | P | P | P | P | B | P | P | P | P | P | P | P | B
 | 32 |  |  | P | P | A | P | A | A | P | B | A | A | A | A | A | A | A | B
 | 32 |  |  | P | P | A | P | P | P | P | B | P | A | P | P | P | A | P | B
 | 32 |  |  | P | P | P | P | P | A | P | B | A | P | P | P | P | P | P | B
 | 32 |  |  | P | P | P | P | A | P | P | B | P | P | P | P | P | P | P | B
 | 32 |  |  | P | P | P | P | P | P | P | B | A | P | P | P | A | P | P | B
 |  |  |  |  |  |  |  |  |  | B |  |  |  |  |  |  |  |  | B
 |  |  |  |  |  |  |  |  |  | B |  |  |  |  |  |  |  |  | B
 |  |  |  |  |  |  |  |  |  | B |  |  |  |  |  |  |  |  | B
 |  |  |  |  |  |  |  |  |  | B |  |  |  |  |  |  |  |  | B
 |  |  |  |  |  |  |  |  |  | B |  |  |  |  |  |  |  |  | B
[NAME] | 32 |  |  | P | P | P | P | P | P | A | b | P | P | P | P | P | P | P | B
 | 16 |  |  | o | o | o | o | o | P | P | b | P | P | P | P | P | P | P | B
 | 16 |  |  | o | o | o | o | o | o | o | b | o | p | P | P | A | P | P | b
 | 8 |  |  | o | o | o | o | o | o | o | b | o | o | P | P | A | P | P | b
 | 0 |  |  | O | O | O | O | O | O | O | B | O | O | O | O | O | P | P | b
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | B
[NAME] |  |  |  | A | A | A | A | A | A | P |  | A | A | A | A | A | A | A
[NAME] |  |  |  | p | p | P | P | P | P | P |  | P | P | P | P | P | P | P
[NAME] |  |  |  | p | p | P | P | P | P | P |  | A | P | P | P | P | P | P
Emma |  |  |  | p | p | A | A | A | A | P |  | A | A | A | A | A | A | A
[NAME] |  |  |  | P | P | P | P | P | p | A |  | P | P | P | P | P | P | P
[NAME] |  |  |  | p | A | P | A | A | A | P |  | A | A | A | A | A | P | P
[NAME] |  |  |  |  |  |  |  |  |  |  |  |  |  | P | A | P | P | P
Spreadsheet: 868692d1715351504-conditional-formatting-not-working-to-highlight-cell-differences-highlight-cell-difference
Sheet: Formula 2

Close Month | Month Reported
2024-03-01 00:00:00 | 2024-03-01 00:00:00
2024-03-01 00:00:00 | 2024-03-01 00:00:00
2024-02-01 00:00:00 | 2024-02-01 00:00:00
2024-02-01 00:00:00 | 2024-02-01 00:00:00
2024-02-01 00:00:00 | 2024-02-01 00:00:00
2024-02-01 00:00:00 | 2024-02-01 00:00:00
2024-05-01 00:00:00 | 2024-01-01 00:00:00 | DIFF
2024-02-01 00:00:00 | 2024-02-01 00:00:00
2024-03-01 00:00:00 | 2024-03-01 00:00:00
2024-05-01 00:00:00 | 2024-03-01 00:00:00 | DIFF
2024-05-01 00:00:00 | 2024-03-01 00:00:00 | DIFF
2024-03-01 00:00:00 | 2024-03-01 00:00:00
Spreadsheet: 19d975be-9232-4b88-9753-8dacb1f45f3e
Sheet: Sheet1

Unnamed: 0 | ФОРМА I-S | Unnamed: 2 | Unnamed: 3 | Unnamed: 4 | Unnamed: 5 | Unnamed: 6 | Unnamed: 7 | Unnamed: 8 | Unnamed: 9 | Unnamed: 10 | Unnamed: 11 | Unnamed: 12 | Unnamed: 13
 |  |  |  |  |  |  |  |  |  |  |  |  | страница      из
 | МЕЖДУНАРОДНАЯ ОРГАНИЗАЦИЯ ГРАЖДАНСКОЙ АВИАЦИИ
 | ФОРМА ОТЧЕТНОСТИ ПО ВОЗДУШНОМУ ТРАНСПОРТУ
 | [NAME] ЧЕРЕЗ АЭРОПОРТ
 | [NAME] для связи:
 | Организация: |  |  |  |  |  |  |  |  | Государство:
 | [NAME].:
 | Факс: |  |  |  |  |  |  |  |  |  |  | Календарный год:
 | E-mail:
 | ВИДЫ ПЕРЕВОЗОК |  | Всего     операций    воздушных судов | Пассажиры |  |  |  | [NAME] (тонны) |  |  | Почта (тонны)
 |  |  |  |  |  |  |  |  |  |  | Mail | (tonnes)
 |  |  |  | Отправленные | [NAME] | [NAME]c + d) | Прямой       транзит | Загружено | Разгружено | Всего                   (g + h) | Загружено | Разгружено | [NAME](j + k)
 |  |  |  |  | arked | (c+d) | Transit |  |  | (c+d) |  |  | (c+d)
 | a |  | b | c | d | e | f | g | h | i | j | k | l
 | [NAME] авиаперевозки
 | 1. Международные регулярные………………………………..……………….
 | 2. Международные нерегулярные………………………………………
 | 3. Всего по международным (1+2)……………………………………….…………
 | 4. [NAME] регулярные и нерегулярные…..
 | 5. Всего по коммерческим авиаперевозкам (1+2+4)……..
 | 6.Чистогрузовые/почтовые авиаперевозки1…………………………...……………………..
 | 7. Полеты авиатакси и коммерч. деловой авиации2…………………………...……………………..
 | [NAME] операции………………………………………………………………..
 | Ниже [NAME] дополнении указать названия всех аэропортов, данные о которых [NAME]. В приведенных выше [NAME] быть учтены и те аэропотры, данные о которых
 | представляются отдельно  в форме I.
 | [NAME] города/аэропорта:
 | Примечания (включая информацию о любых неизбежных отклонениях от инструкции по заполнению):
 | 1 Данные об этих перевозках следует включать также в строки 1–5 (см. [NAME]). |  |  |  |  |  |  |  |  | По мере [NAME] листы.
 | 2 Данные об этих перевозках следует включать также в строки 2–5 (см. [NAME]).
Spreadsheet: e0afceba-bbdb-4ab8-a1e5-ab249eba21e2
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
40315018 | 2014-03-02 13:41:36 | AXIS | 1 | 6 | 2 | 1527115 | player1527115 | 12493 | western | 1944-12-30 | 1944-12-30 | [NAME] | [NAME]
40315328 | 2014-03-02 13:56:39 | ALLIES | 1 | 6 | 3 | 1527115 | player1527115 | 12493 | western | 1944-12-30 | 1944-12-30 | [NAME] | [NAME]
40360054 | 2014-03-05 01:26:53 | AXIS | 1 | 7 | 3 | 1390059 | [NAME] | 7668 | pacific | 1945-02-26 | 1945-03-06 | The Meat Grinder | Le Hachoir à viande
40360333 | 2014-03-05 01:49:26 | ALLIES | 1 | 7 | 3 | 1390059 | [NAME] | 7668 | pacific | 1945-02-26 | 1945-03-06 | The Meat Grinder | Le Hachoir à viande
40367066 | 2014-03-05 14:35:37 | AXIS | 0 | 4 | 7 | 1249879 | baptiste879 | 7668 | pacific | 1945-02-26 | 1945-03-06 | The Meat Grinder | Le Hachoir à viande
40367316 | 2014-03-05 15:01:33 | ALLIES | 0 | 5 | 7 | 1249879 | baptiste879 | 7668 | pacific | 1945-02-26 | 1945-03-06 | The Meat Grinder | Le Hachoir à viande
40387303 | 2014-03-06 21:19:25 | AXIS | 1 | 7 | 4 | 580456 | JP [NAME] | 7668 | pacific | 1945-02-26 | 1945-03-06 | The Meat Grinder | Le Hachoir à viande
40387893 | 2014-03-06 21:52:59 | ALLIES | 1 | 7 | 4 | 580456 | JP [NAME] | 7668 | pacific | 1945-02-26 | 1945-03-06 | The Meat Grinder | Le Hachoir à viande
Spreadsheet: 864800d1711949502-from-static-to-dynamic-cell-reference-via-indirect-function-raw-materials-record-aligw
Sheet: TEDA (Cat - 1)

Raw Material |  | TEDA (Cat - 1)
Date | Description | Batch Processed Quantity |  | Quantity Stored ([NAME]'s) | Quantity Issued ([NAME]'s) | Total Quantity Remaining ([NAME]'s) | Bilty or Batch (Description)
 |  | Qty | [NAME]'s
Column1 | Column2 | Column3 | Column4 | Column5 | Column6 | Column7 | Column8
2023-09-30 00:00:00 |  |  |  |  |  | 937
2023-12-03 00:00:00 |  | 40 | 25
Total
Spreadsheet: 538540d1505695360-conditional-formate-for-task-schedule-task-schedule
Sheet: AFTER

TASK | LAST TASK DATE | No. OF DAYS TO NEXT TASK DAT | NEXT TASK DATE | DIFFERENCE | REMARKS
1 | 6, JUNE, 2017 | 20 | 26, JUNE, 2017 | 3 | OVER DUE
2 | 6, JUNE, 2017 | 21 | 29, JUNE, 107 | 0 | DUE TODAY
3 | 4, JULY, 2017 | 30 | 3, AUGUST, 2017 | -34 | NOT YET
 | * Current date is 29th, June, 2017
Spreadsheet: 779007d1651509198-spread-of-the-percentage-spreadtest-tresfjording-
Sheet: Ark1

 | Player 1 |  |  |  | Player 2 |  |  |  | Player 3 |  |  |  | Player 4 |  |  |  | Player 5 |  |  |  | Player 6 |  |  |  | Player 7 |  |  |  | Spread |  |  |  | Percentage |  |  |  |  | Adjusted Spread
Game | x | x |  |  | x | x |  |  | x | x |  |  | x | x |  |  | x | x
 | How can I get the percentage to be exact? |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | Never less than 10%
 | VBA?
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 8 | 3 | 3 | 2
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 1 | 7 | 6 | 3
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 3 | 6 | 9 | 7
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 6 | 3 | 9 | 1
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 4 | 5 | 1 | 7
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 7 | 3 | 6 | 2
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 7 | 7 | 9 | 1
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 3 | 6 | 3 | 4
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 2 | 9 | 7 | 9
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 2 | 3 | 2 | 2
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 7 | 5 | 5 | 9
Spreadsheet: 222050d1363735423-reduce-1-minute-data-to-30-minute-data-in-excel-5-minutes-to-30-minutes
Sheet: Sheet1

TIMESTAMP | WindSpeed | WindDirect | Air_temperature | RH | Pyranometer_Avg | Reference1_Avg | [NAME] | Month | Day |  | TIMESTAMP | WindSpeed | WindDirect | Air_temperature | RH | Pyranometer_Avg | Reference1_Avg | [NAME] | Month | Day
2012-12-11 04:05:00 | 3.4 | 180.1 | 9.4 | 71.6 | 453 | 435 | 354 | 12 | 11 |  | 2012-12-11 03:30:00
2012-12-11 04:10:00 | 4 | 177.4 | 9.5 | 70.4 | 450 | 345 | 345 | 12 | 11
2012-12-11 04:15:00 | 4.7 | 177.6 | 9.6 | 70.5 | 435 | 654 | 345 | 12 | 11
2012-12-11 04:20:00 | 4.7 | 178.3 | 9.6 | 71.1 | 756 | 345 | 567 | 12 | 11
2012-12-11 04:25:00 | 4.3 | 176.2 | 9.8 | 72.2 | 656 | 656 | 567 | 12 | 11
2012-12-11 04:30:00 | 4.4 | 172.8 | 9.7 | 70.9 | 543 | 656 | 786 | 12 | 11
2012-12-11 04:35:00 | 4.3 | 171.9 | 9.8 | 70.4 | 435 | 435 | 456 | 12 | 11
2012-12-11 04:40:00 | 3.5 | 167.5 | 9.6 | 71.9 | 463 | 366 | 675 | 12 | 11
2012-12-11 04:45:00 | 3 | 162.9 | 9.6 | 71.3 | 354 | 756 | 765 | 12 | 11
2012-12-11 04:50:00 | 3.7 | 175.5 | 9.6 | 71.6 | 654 | 456 | 568 | 12 | 11
2012-12-11 04:55:00 | 4.4 | 176.1 | 9.8 | 71.6 | 645 | 345 | 676 | 12 | 11
2012-12-11 05:00:00 | 4.4 | 172.6 | 9.6 | 71.7 | 345 | 355 | 456 | 12 | 11
Spreadsheet: 181928d1348207638-horizontal-extrapolation-of-a-rent-roll-sheet-after-expiry-of-the-actual-rent-rent-roll-sheet-after-expiry-of-the-actual-rent_rev_1
Sheet: Blad1

Year : |  |  | 2012 | 2012 | 2012 | 2012 | 2012 | 2012 | 2012 | 2012 | 2012 | 2012 | 2012 | 2012 | 2013 | 2013 | 2013 | 2013 | 2013 | 2013 | 2013 | 2013 | 2013 | 2013 | 2013 | 2013
Month : |  |  | 2012-01-01 00:00:00 | 2012-02-01 00:00:00 | 2012-03-01 00:00:00 | 2012-04-01 00:00:00 | 2012-05-01 00:00:00 | 2012-06-01 00:00:00 | 2012-07-01 00:00:00 | 2012-08-01 00:00:00 | 2012-09-01 00:00:00 | 2012-10-01 00:00:00 | 2012-11-01 00:00:00 | 2012-12-01 00:00:00 | 2013-01-01 00:00:00 | 2013-02-01 00:00:00 | 2013-03-01 00:00:00 | 2013-04-01 00:00:00 | 2013-05-01 00:00:00 | 2013-06-01 00:00:00 | 2013-07-01 00:00:00 | 2013-08-01 00:00:00 | 2013-09-01 00:00:00 | 2013-10-01 00:00:00 | 2013-11-01 00:00:00 | 2013-12-01 00:00:00
Period : |  |  | 1 | 2 | 3 | 4 | 5 | 6 | 7 | 8 | 9 | 10 | 11 | 12 | 13 | 14 | 15 | 16 | 17 | 18 | 19 | 20 | 21 | 22 | 23 | 24
Tenant1
Rent roll : |  |  |  |  | 12500 | 12500 | 12500 | 12500 | 12500 | 12500 | 12500 | 12500 | 12500 | 12500 | 12500 | 12500
Rent rebate : |  |  |  |  | 5000 | 5000 | 5000 | 5000 | 5000 | 5000 | 5000 | 5000 | 5000 | 5000 | 5000 | 5000
Subtotal : |  |  |  |  | 7500 | 7500 | 7500 | 7500 | 7500 | 7500 | 7500 | 7500 | 7500 | 7500 | 7500 | 7500
how it should work |  |  | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0
Tenant1
Rent roll : |  |  |  |  |  |  |  |  |  | 12500 | 12500 | 12500 | 12500 | 12500 | 12500 | 12500 | 12500 | 12500 | 12500 | 12500
Rent rebate : |  |  |  |  |  |  |  |  |  | 5000 | 5000 | 5000 | 5000 | 5000 | 5000 | 5000 | 5000 | 5000 | 5000 | 5000
Subtotal : |  |  |  |  |  |  |  |  |  | 7500 | 7500 | 7500 | 7500 | 7500 | 7500 | 7500 | 7500 | 7500 | 7500 | 7500
how it should work |  |  | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0
Tenant1
Rent roll : |  |  | 12500 | 12500 | 12500 | 12500 | 12500 | 12500 | 12500 | 12500 | 12500 | 12500 | 12500 | 12500 | 12500 | 12500 | 12500 | 12500
Rent rebate : |  |  | 5000 | 5000 | 5000 | 5000 | 5000 | 5000 | 5000 | 5000 | 5000 | 5000 | 5000 | 5000 | 5000 | 5000 | 5000 | 5000
Subtotal : |  |  | 7500 | 7500 | 7500 | 7500 | 7500 | 7500 | 7500 | 7500 | 7500 | 7500 | 7500 | 7500 | 7500 | 7500 | 7500 | 7500
how it should work |  |  | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0
Rent roll : |  |  | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0
Rent rebate : |  |  | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0
Subtotal : |  |  | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0
how it should work |  |  | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0
inflation | 0.05
 | the 12.500 should be multiplied with a fixed rate in a fixed cell like in B34
Spreadsheet: 842487d1694555372-how-to-get-mutilple-search-results-using-index-and-match-formulas-shreenivas_automobiles_price_list-slatad-
Sheet: Balmerol

Sr.No | Product_Name | Quantity | MRP | DLP | Combined_Name
1 | HP 140 | 1L | 360 | 214
2 | MP3 Grease | 5L |  | 1520
3 | MP3 Grease | 18L |  | 5100
Spreadsheet: 123673d1317801706-average-vlookup-over-multiple-sheets-test-data-file2
Sheet: 2

FLIGHTS | TIMES
VX921 | 00:14:00
VX751 | 00:09:00
VX300 | 00:25:00
VX925 | 00:18:00
VX833 | 00:13:00
VX67 | 00:18:00
VX853 | 00:13:00
VX903 | 00:16:00
VX11 | 00:27:00
VX953 | 00:12:00
VX927 | 00:28:00
VX351 | 00:30:00
VX905 | 00:30:00
VX69 | 00:25:00
[NAME] | 00:21:00
VX753 | 00:24:00
VX23 | 00:27:00
VX251 | 00:26:00
VX929 | 00:19:00
VX961 | 00:17:00
VX837 | 00:17:00
VX909 | 00:18:00
VX861 | 00:14:00
VX945 | 00:16:00
VX755 | 00:13:00
VX947 | 00:10:00
VX71 | 00:16:00
VX913 | 00:18:00
VX305 | 00:13:00
VX27 | 00:15:00
[NAME] | 00:15:00
VX949 | 00:14:00
VX759 | 00:13:00
VX349 | 00:14:00
VX865 | 00:17:00
VX969 | 00:14:00
VX917 | 00:12:00
VX77 | 00:17:00
VX29 | 00:16:00
VX357 | 00:20:00
Spreadsheet: 1638d671-5d6e-4cad-a72a-932257a68138
Sheet: Pub Date

Month | Titles | Percentage
Jan | 46
Feb | 35
Mar | 33
Apr | 53
May | 45
June | 48
July | 30
Aug | 24
Sept | 35
Oct | 38
Nov | 34
Dec | 21
Spreadsheet: 275465d1383528404-formula-required-for-retirement-planning-forecaster-formula-required
Sheet: Sheet1

 | Retirement Forecasting solution
 | Data: |  |  | Age | Pension 1 Income
 | Age Now | 50 |  | 50 | 40000
 | Retirement Age | 65
 | Life Expectancy age | 85
 | Pension 1: Deferred Annuity income value now | 40000
 | Pension 1: Annuity Revaluation rate pa before retirement age | 0.03
 | Pension 1: Annuity Escalation rate in payment pa after retirement age | 0.04
 | Points to note:
 | 1. No income is payable from Pension 1 until age 65
 | 2. The Deferred Annuity for Pension 1 should be revalued each year until payment at age 65
 | 3. The Pension 1 Annuity should escalate each year from age 65
 | 4. The Pension 1 Annuity income should stop at life expectancy age of 85