tianzl66/Sheetpedia huggingface dataset:
Spreadsheet: 598815d1542727334-help-with-formulas-to-perform-indexation-to-rental-income-on-annual-semi-annual-etc-dummy-file-1-ans3
Sheet: Income Calc

 | Helper column
 |  | Tenant 1 | 1
 |  | [NAME] | 1
 |  | Tenant 3 | 1
 |  |  | I want to add formulas here with the below outcome. The idea is to add a formula which takes into account number of years in tab "Rent Roll". I.e if [NAME] is 1 year then tenant 1 here have indexation every year - see correct end result below under tenant 1. Same for tenant 2 and so on, if tenant 2 has "2 year in D4 on tab "rent roll" the indexation will take place every second year. Indexation is supposed to happen in 1st quarter when the rent is subject to indexation
 | NOTE: Column D is changed
 |  | What I like to achieve by adding a dynamic formula
 |  |  | Tenant 1 | 1.01 | 1.01 | 1.01 | 1.01 | 1.0302 | 1.0302 | 1.0302 | 1.0302 | 1.061106 | 1.061106 | 1.061106 | 1.061106 | 1.08232812 | 1.08232812 | 1.08232812 | 1.08232812 | 1.136444526 | 1.136444526 | 1.136444526 | 1.136444526
 |  |  | [NAME] | 1 | 1 | 1 | 1 | 1.0302 | 1.0302 | 1.0302 | 1.0302 | 1.0302 | 1.0302 | 1.0302 | 1.0302 | 1.08232812 | 1.08232812 | 1.08232812 | 1.08232812 | 1.08232812 | 1.08232812 | 1.08232812 | 1.08232812
 |  |  | Tenant 3 | 1 | 1 | 1 | 1 | 1 | 1 | 1 | 1 | 1.061106 | 1.061106 | 1.061106 | 1.061106 | 1.061106 | 1.061106 | 1.061106 | 1.061106 | 1.061106 | 1.061106 | 1.061106 | 1.061106
 |  | Revised
 |  |  | 2017-12-31 00:00:00 | 2018-03-31 00:00:00 | 2018-06-30 00:00:00 | 2018-09-30 00:00:00 | 2018-12-31 00:00:00 | 2019-03-31 00:00:00 | 2019-06-30 00:00:00 | 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
 |  |  | Tenant 1 |  | 1.01 | 1.01 | 1.01 | 1.0302 | 1.0302 | 1.0302 | 1.0302 | 1.061106 | 1.061106 | 1.061106 | 1.061106 | 1.08232812 | 1.08232812 | 1.08232812 | 1.08232812 | 1.136444526 | 1.136444526 | 1.136444526 | 1.136444526
 |  |  | [NAME] | 1 | 1 | 1 | 1 | 1.01505 | 1.01505 | 1.01505 | 1.01505 | 1.01505 | 1.01505 | 1.01505 | 1.01505 | 1.0405785075 | 1.0405785075 | 1.0405785075 | 1.0405785075 | 1.0405785075 | 1.0405785075 | 1.0405785075 | 1.0405785075
 |  |  | Tenant 3 | 1 | 1 | 1 | 1 | 1 | 1 | 1 | 1 | 1.04562128125 | 1.04562128125 | 1.04562128125 | 1.04562128125 | 1.04562128125 | 1.04562128125 | 1.04562128125 | 1.04562128125 | 1.04562128125 | 1.04562128125 | 1.04562128125 | 1.04562128125
Spreadsheet: 328388d1403884258-how-to-delete-rows-depending-on-cell-content-sample-data
Sheet: Sheet1

HOW IT CURRENTLY READS: |  |  |  |  |  | HOW I WANT IT TO READ:
Code | Info1 | Info2 | Info3 | Size |  | Code | Info1 | Info2 | Info3 | Size
1850 |  | Size |  | (200x200mm) |  | 1850 |  | Size |  | (200x200mm)
1850 |  | Size |  | (200x200mm) |  | 1851 |  | Size |  | (100x150mm)
1851 |  | Size |  | (100x150mm) |  | 1851 |  | Size |  | (200x200mm)
1851 |  | Size |  | (100x150mm) |  | 1852 |  | Size |  | (100x150mm)
1851 |  | Size |  | (200x200mm) |  | 1852 |  | Size |  | (200x200mm)
1851 |  | Size |  | (200x200mm) |  | 1853 |  | Size |  | (200x200mm)
1852 |  | Size |  | (100x150mm) |  | 1854 |  | Size |  | (200x200mm)
1852 |  | Size |  | (100x150mm)
1852 |  | Size |  | (200x200mm)
1852 |  | Size |  | (200x200mm) |  | Basically - if the code is the same I want to delete any duplicate
1853 |  | Size |  | (200x200mm) |  | sizes for that code.
1853 |  | Size |  | (200x200mm)
1854 |  | Size |  | (200x200mm)
1854 |  | Size |  | (200x200mm)
Spreadsheet: larry_campbell__20963__Flagstaff1
Sheet: Gen Engines

[NAME]
RED ROCK EXPANSION PROJECT
FLAGSTAFF COMPRESSOR STATION
Table 2
GENERATOR ENGINES
Manufacturer: | Caterpillar 3508
Fuel Type: | Sweet Natural Gas
Site Elevation: | 7458
Rated Power: | 526 | hp @100% Load
Fuel Flow Rate: | 71 | scf/min | (mfr data)
 |  | scf/hr
 |  | [NAME]/yr
HHV | 1020 | Btu/scf | (estimate)
Heat Rate: |  | Btu/hp-hr
 |  | [NAME]/hr
Speed: | 1200 | rpm
Operating Schedule: | 8760 | hours/yr
Emission Factors
Pollutant | Rate | Units | Source
NOx | 24.9 | lb/hr | Mfr
CO | 1.76 | lb/hr | Mfr
NMHC | 0.21 | lb/hr | Mfr
PM | 0.04831 | lb/MMBtu | [NAME]
SO2 | 0.000588 | lb/MMBtu | [NAME]
Proposed Generator Engine  Emissions
 | Maximum | Annual
Pollutant | (lb/hr) | (tpy)
NOX
CO
VOC
PM
SO2
Note:
1.  TWP will install two Caterpillar G3508 generator engines.  However, only one unit will be run at a time
with the second unit in standby.  TWP requests the flexiblity to operate either engine as long as total
generator engine operating time does not exceed 8760 hours/year.
Spreadsheet: 454259d1459757242-problem-with-formula-when-opening-stock-is-greater-than-first-order-for-product-book1example-5-
Sheet: Purchases

 |  | Rolls - 25kg
 |  | Cost | Total Qty | Running Total
 | Opening Stock | 1.12 | 40
 |  | 1 | 1000
 |  | 2 | 1000
 |  | 2.2 | 1000
 |  | 1 | 2000
 | Purchased
 | Sold
 | Balance
 |  | Date | Quantity Bought | Price Paid
 |  | 2016-04-01 00:00:00 | 1000 | 1
 |  | 2016-04-23 00:00:00 | 1000 | 2
 |  | 2016-04-15 00:00:00 | 1000 | 2.2
 |  | 2016-05-02 00:00:00 | 2000 | 1
Spreadsheet: 2b02229e-a2d1-47f6-869d-924f9b88f6b3
Sheet: Sheet1

FLEXBASE 14-005 | Unnamed: 1 | Unnamed: 2 | Unnamed: 3 | Unnamed: 4 | Unnamed: 5 | Unnamed: 6 | Unnamed: 7
ITEM | QUANTITY | Unit | [NAME] | Big City Crushed Concrete |  | Blue Star Materials
 |  |  |  | UNIT PRICE | TOTAL PRICE | UNIT PRICE | TOTAL PRICE
1 | 11700 | tons | Type A Grade 1 crushed concrete Flexible base DELIVERY | 10.5 | 122850 | 20.09 | 235053
2 | 3200 | tons | Type A Grade 1 crushed concrete Flexible base PICKED UP | 7 | 22400 | 6.25 | 20000
 |  |  |  | 8.5 miles |  | 6.3 miles
Spreadsheet: phillip_m_love__30152__9905_OA
Sheet: ONT_FLSH

ENRON CAPITAL & TRADE RESOURCES
OPERATIONAL ANALYSIS - REPORTED
COMPANY:  ALL
REGION:  TRANSPORT
 |  |  | 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 | 7020222 | 16520575
2 |  | Liquidations | 0 | 0
3 |  | Interdesk | 2232777 | 5214825
4 |  | Option Premiums | 0 | 0
5 |  | Dmd Reimbursements | 0 | 0
 | Total Sales: |  | 9252999 | 21735400
 | Purchases:
6 |  | 3rd Party / Inter Enron | -6088585 | -14323204
7 |  | Liquidations | 0 | 0
8 |  | Interdesk | -2936881 | -6871475
9 |  | Option Premiums | 0 | 0
10 |  | [NAME] | 0 | 0
 | Total Purchases: |  | -9025466 | -21194679
 | Intra CTS (EGM / HPL / LRC):
11 |  | Sales | 0 | 0
12 |  | Purchases | 0 | 0
 | Total Intra CTS Sales / Purchases |  | 0 | 0
 | Imbalances:
13 |  | In Kind | 0 | 0
14 |  | Cash Out | -227533 | -532427.22
15 |  | Cash In | 0 | 0
16 |  | Synthetic Storage | 0 | 0
 | Total Imbalances: |  | -227533 | -532427.22
 | Storage:
17 |  | Injection (Sales to Stg) | 0 | 0
18 |  | W/D (Purchase from Stg) | 0 | 0
19 |  | Inventory Profit | 0 | 0
 |  | Total W/D | 0 | 0
 | Total Storage: |  | 0 | 0
20 | Linepack: |  | 0 | 0
21 | Shrinkage: |  | 0 | 0
22 | UA4: |  | 0 | 0
23 | Fuel: |  | 0 | 0
 | Transport Expense:
24 |  | Commodity | 0 | 0
25 |  | Demand | 0 | 0
 | Total Transport Expense: |  | 0 | 0
 | Transport Revenue:
26 |  | Interstate | 0 | 0
27 |  | Intrastate | 0 | 0
 | Total Transport Revenue: |  | 0 | 0
 | 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 | -808256.63
31 |  | Prior Month Book Balance | 0 | 952734
 |  | Total MTM Income | 0 | 144477.37
32 |  | Prudency | 0 | 0
33 |  | Financial Liquidations | 0 | 0
34 |  | Originations | 0 | 0
35 |  | Broker Fees | 0 | 0
36 |  | Asset Group Demand Charges | 0 | 0
37 |  | [NAME] | 0 | 0
38 |  | Interdesk Charges | 0 | 0
39 |  | Canada | 0 | 0
40 |  | Miscellaneous | 0 | -23232
 |  | TOTAL INTRA-MTH
FT-Ontario
 |  | Current Month MTM | 0 | 593800
 |  | Financial Liquidations | 0 | 0
 |  | Originations | 0 | 0
 |  | TOTAL FIRM TRADING
 |  | TOTAL NGPL
Spreadsheet: 884625d1733847265-bring-back-cell-based-on-a-few-factors-nambo-stelrad-compact-range-data-1-365-aligw-2-
Sheet: Rad Size

 |  |  |  |  |  |  |  | Workable space
 |  |  |  |  |  |  |  | Height | width | Calc
Room Name | Design Temp | Power(w/m2) | Area (m2) | Power (w) | Energy (kwh) | Number of rads | [NAME] in a Rad
Lounge | 21 | 113 | 26.76 | 3036 | 5560 | 1 |  | 450 | 600
Kitchen/Diner | 21 | 105 | 32.73 | 3424 | 6277 | 2
Bathroom | 22 | 185 | 3.82 | 706 | 880 | 1
bed 3 | 18 | 145.6 | 6.75 | 981 | 2245 | 2
Bed 2 | 18 | 28 | 11.22 | 314 | 1018 | 1
Bed 1 | 18 | 65 | 11.22 | 314 | 2210 | 1
[NAME] | 22 | 213 | 7.65 | 1626 | 2338 | 1
Hall | 18 | 33 | 9 | 301 | 604 | 1
Totals |  |  | 111.13 | 11250 | 21132
Spreadsheet: 741482d1627054307-calculate-reward-based-on-sales-figure-reward
Sheet: Sheet10

Sales | Reward |  |  | Sales | Reward
4000 | 5000 |  | [NAME] | 4500 | ???
5000 | 4000 |  | [NAME] | 5500 | ???
5800 | 7500 |  | [NAME] | 6500 | ???
6600 | 8500 |  | Zak | 700 | ??
Spreadsheet: 678133d1589727912-calculating-football-results-scores-for-fantasy-league-football-predicitions
Sheet: Sheet1

 |  |  |  |  | [NAME] |  |  |  | [NAME] |  |  |  | Will
Home Team | Away Team | Home Score | Away Score | [NAME] | Home Score | Away Score | Predicted [NAME] | Score | Home Score | Away Score | Predicted [NAME] | Score | Home Score | Away Score | Predicted [NAME] | Score
Borussia Dortmund | Schalke | 4 | 0 | HW | 2 | 1 | HW | 100 | 3 | 1 | HW | 100 | 2 | 1 | HW | 100
Augsburg | Wolfsburg | 1 | 2 | AW | 0 | 1 | AW |  | 1 | 0 | HW |  | 2 | 0 | HW
Dusseldorf | Paderborn | 0 | 0 | D | 1 | 1 | D |  | 2 | 1 | HW |  | 2 | 1 | HW
RB Leipzig | Freiburg | 1 | 1 | D | 3 | 0 | HW |  | 3 | 0 | HW |  | 4 | 0 | HW
Hoffenheim | [NAME] | 0 | 3 | AW | 2 | 0 | HW |  | 1 | 1 | D |  | 0 | 0 | D
Frankfurt | [NAME] | 1 | 3 | AW | 1 | 3 | AW |  | 1 | 3 | AW |  | 1 | 1 | D
Koln | [NAME] |  |  |  | 1 | 0 | HW |  | 0 | 0 | D |  | 1 | 0 | HW
Union Berlin | Bayern Munich |  |  |  | 1 | 4 | AW |  | 0 | 4 | AW |  | 0 | 3 | AW
[NAME] | [NAME] |  |  |  | 1 | 2 | AW |  | 1 | 1 | D |  | 0 | 0 | D
Spreadsheet: 791736d1660570313-collecting-certain-text-phrase-total-to-subtract-from-per-diem-expense-report-forum
Sheet: ExpenseReport

 | Expense Report
 | Name:
 | Department
 | Expenses
 | DATE | VENDOR | DESCRIPTION / BUSINESS PURPOSE | Expense Type | Subtotal | HST/GST | Total
 | 2022-08-12 00:00:00 |  |  | Meals & Entertainment | 23 | 1.14
 | 2022-08-13 00:00:00 |  |  | Meals & Entertainment | 15 | 1.14
 |  |  |  | Meals & Entertainment
 | Mileage
 | DATE | DESTINATION / DESCRIPTION |  |  |  | KM | Total
 |  |  |  |  |  | Total
 | Processed By:
 | Approved By: |  |  |  |  | Due to Employee
Spreadsheet: mark_whitt__25310__SJ PROPOSAL
Sheet: Sheet1

JM HUBER CORPORATION
ANALYSIS OF SAN JUAN PROPOSAL
SAN JUAN GAS IS CURRENTLY BEING SOLD ON THE SPOT MARKET AT EPNG-SJ LESS $0.XX)
PROPOSAL: |  | ACQUIRE FIRM TRANSPORTATION ON EL PASO FROM IGNACIO TO PG&E CITYGATE.
 |  | EPNG WILL GO FROM MASTER RECEIPT POINT LESS TO PRIMARY POINTS THROUGH
 |  | ALLOCATION PROCESS.  BEST GUESS IS THAT HUBER WOULD RECEIVE 72-80%
 |  | SAN JUAN CAPACITY WITH THE REMAINDER PERMIAN CAPACITY.
FEES: | 1. | RESERVATION FEE OF $0.3854/MMBTU
 | 2. | FUEL OF 3.47%
PRICING: | 1. | FOR FT VOLUMES CONFIRMED ON EPNG, PGE GAS DAILY AVG. LESS $0.05.
 | 2. | FOR FT VOLUMES NOT CONFIRMED, SELL CYCLE TWO INTO NWP AT GDA-0.10.
 | 3. | FOR VOLUMES OUTSIDE THE TRANSACTION EPNG-SJ LESS $0.XX, SAME AS
 |  | HUBER IS RECEIVING TODAY.
BENEFIT: |  | VOLUME | BASIS | DISC | [NAME] | FUEL | OFFSET
 | NOW | 40000 | -0.32 | -0.1 | 0 | 0
 | PROPOSAL: ACQUIRE 30,000 mmBUT/D, ASSUME 75% SAN JUAN ALLOCATION
 | 1. |  | 0.17 | -0.05 | -0.3854 | -0.07
 | 2. |  | -0.47 | -0.1 | -0.3854 | -0.07
 | 3. |  | -0.32 | -0.1 | 0 | 0
 |  |  |  | WEIGHTED AVG OFFSET
Spreadsheet: 67789d1268318818-validation-or-define-problem-database
Sheet: Sheet1

 |  |  |  |  |  |  | I need the put the validation data which direct link the supplier list(Coca Cola, K & N) (i.e)cokelist, chickenitem
 |  |  |  |  |  |  | item name come which drag down in another workbook (coke itam and chicken item)
 | Date | Outlet Name | [NAME] | Description | Head | Qty | Rate | Amounts | Sales Tax |  | Tax Amounts | [NAME]
 |  | [NAME] |  |  |  |  |  | 100 |  | 0 |  | Coca Cola
 |  |  |  |  |  |  |  | 200 |  | 0
 |  |  |  |  |  |  |  | 300 |  | 0
 |  |  |  |  |  |  |  | 400 |  | 0
 |  |  |  |  |  |  |  | 400 |  | 0
 |  |  |  |  |  |  |  | 400 |  | 0
 |  |  |  |  |  |  |  | 400 |  | 0
 |  |  |  |  |  |  |  | 400 |  | 0
 |  |  |  |  |  |  |  | 400 |  | 0
 |  |  |  |  |  |  |  | 400 |  | 0
 |  |  |  |  |  |  |  | 400 |  | 0
 |  |  |  |  |  |  |  | 400 |  | 0
 |  |  |  |  |  |  |  | 400 |  | 0
 |  |  |  |  |  |  |  | 400 |  | 0
 |  |  |  |  |  |  |  | 400 |  | 0
 |  |  |  |  |  |  |  | 400 |  | 0
 |  |  |  |  |  |  |  | 400 |  | 0
 |  |  |  |  |  |  |  | 400 |  | 0
 |  |  |  |  |  |  |  | 400 |  | 0
 |  |  |  |  |  |  |  | 400
 |  |  |  |  |  |  |  | 400
 |  |  |  |  |  |  |  | 400
 |  |  |  |  |  |  |  | 400
 |  |  |  |  |  |  |  | 400
 |  |  |  |  |  |  |  | 400
 |  |  |  |  |  |  |  | 400
 |  |  |  |  |  |  |  | 400
 |  |  |  |  |  |  |  | 400
 |  |  |  |  |  |  |  | 400
 |  |  |  |  |  |  |  | 400
 |  |  |  |  |  |  |  | 400
 |  |  |  |  |  |  |  | 400
 |  |  |  |  |  |  |  | 400
 |  |  |  |  |  |  |  | 400
 |  |  |  |  |  |  |  | 400
 |  |  |  |  |  |  |  | 400
 |  |  |  |  |  |  |  | 400
 |  |  |  |  |  |  |  | 400
 |  |  |  |  |  |  |  | 400
 |  |  |  |  |  |  |  | 400
 |  |  |  |  |  |  |  | 400
 |  |  |  |  |  |  |  | 400
 |  |  |  |  |  |  |  | 400
 |  |  |  |  |  |  |  | 400
 |  |  |  |  |  |  |  | 400
 |  |  |  |  |  |  |  | 400
 |  |  |  |  |  |  |  | 400
 |  |  |  |  |  |  |  | 400
 |  |  |  |  |  |  |  | 400
 |  |  |  |  |  |  |  | 400
 |  |  |  |  |  |  |  | 400
 |  |  |  |  |  |  |  | 400
 |  |  |  |  |  |  |  | 400
 |  |  |  |  |  |  |  | 400
 |  |  |  |  |  |  |  | 400
 |  |  |  |  |  |  |  | 400
Spreadsheet: 37cab6f0-5f87-48d3-9f0c-0cc60c70c8de
Sheet: kesbangpol

RENCANA UMUM PENGADAAN BARANG/JASA PEMERINTAH
PA/KPA |  | : Darmiadi, M.AP
K/L/D/I |  | :
SATKER/SKPD |  | : Kantor [NAME]
PPK |  | : Rahbiyah, S.Ag.[NAME]
[NAME] |  | : 2013
NO | KEGIATAN | SUB KEGIATAN/PEKERJAAN | NAMA PAKET PEKERJAAN | VOLUME | LOKASI PEKERJAAN (PROVINSI/KAB/KOTA) | RENCANA PENGANGGARAN |  |  | CARA PENGADAAN | PERKIRAAN WAKTU MULAI PELAKSANAAN PENGADAAN | WAKTU PELAKSANAAN (BULAN) | KET
 |  |  |  |  |  | PERKIRAAN BIAYA (Rp ,-) | [NAME] (APBN/APBD) | RENCANA PEMBIAYAAN
1 | 2 | 3 | 4 | 5 | 6 | 7 | 8 | 9 | 10 | 11 | 12 | 13
1 | Penyediaan Jasa peralatan  dan Perlengkapan Kantor |  | Pengadaan [NAME] | 1 (satu) buah | Kab.[NAME] | 11000000 | APBD | 11000000 | [NAME] | Semester I | Januari
2 | Penyediaan Jasa peralatan  dan Perlengkapan Kantor |  | Pengadaan Prnter | 2 (dua) buah | Kab.[NAME] | 1700000 | APBD | 1700000 | [NAME] | Semester I | Januari
3 | Penyediaan Jasa peralatan  dan Perlengkapan Kantor |  | Pengadaan Kamera | 1 (satu) buah | Kab.[NAME] | 2300000 | APBD | 2300000 | [NAME] | Semester I | Januari
4 | Penyediaan Jasa peralatan  dan Perlengkapan Kantor |  | Pengadaan Handycam | 1 (satu) buah | Kab.[NAME] | 8000000 | APBD | 8000000 | [NAME] | Semester I | Januari
5 | Penyediaan Jasa peralatan  dan Perlengkapan Kantor |  | Pengadaan Proyektor/LCD | 1 (satu) Paket | Kab.[NAME] | 10000000 | APBD | 10000000 | [NAME] | Semester I | Januari
6 | Penyediaan Jasa peralatan  dan Perlengkapan Kantor |  | Pengadaan Sound system | 1 (satu) buah | Kab.[NAME] | 9600000 |  | 9600000 | [NAME] | Semester I | Januari
 |  |  |  |  | [NAME] | 42600000 |  | 42600000
 |  |  |  |  |  |  |  |  | Batulicin, 11 Januari 2013
 |  |  |  |  |  |  |  |  | Pengguna Anggaran/Kuasa Pengguna Anggaran,
 |  |  |  |  |  |  |  |  | Darmiadi, MAP
 |  |  |  |  |  |  |  |  | NIP. 19670717 198902 1 004
Spreadsheet: 691815d1597892033-right-trim-with-concatenate-with-nested-if-statement-how-to-do-in-one-step-book1
Sheet: Sheet1

Resultant Cell - Before Right Trim | Resultant Cell - After Right Trim | Curly | [NAME] | Frizzy | Straight
 |  | Yes | Yes | Yes
 |  |  | Yes | Yes | Yes
 |  | Yes | Yes | Yes | Yes
 |  | Yes |  | Yes
 |  |  |  | Yes
Spreadsheet: 702916d1604607315-most-frequent-address-book1
Sheet: Sheet1

Excel Forum Example
Invoice No. | Address | Route | Codes | Freight Miles | [NAME] | [NAME] | [NAME] | Weight (lbs) |  |  |  | Address | Count of Address
398020105714 | 3501 Roosevelt Blvd., Middletown, OH |  |  |  |  |  |  | 125 |  |  |  | 1550 Ponce De Leon, San Juan, PR | 3
397358235299 | 1995 [NAME], Orange, CA |  |  |  |  |  |  | 150 |  |  |  | 5-823 Corydon Ave., [NAME], MB | 2
397390358354 | 135 [NAME]. NW., Albuquerque, NM |  |  |  |  |  |  | 115 |  |  |  | 13701 S. Alma Ave., Gardena, CA | 2
397358677973 | 13701 S. Alma Ave., Gardena, CA |  |  |  |  |  |  | 115 |  |  |  | 821 Tyson Rd., [NAME], AL | 2
397357982242 | 13701 S. Alma Ave., Gardena, CA |  |  |  |  |  |  | 115 |  |  |  | 1020-A Derita Rd., Concord, NC | 2
396883429790 | 3001 Bloomfield Hwy., Farmington, NW |  |  | 1645 |  |  |  | 220 |  |  |  | 3001 Bloomfield Hwy., Farmington, NW | 2
396883550994 | 3215 Hwy 64, Waterflow, NM |  |  | 1653 |  |  |  | 220
396883671057 | 3001 Bloomfield Hwy., Farmington, NW |  |  | 1645 |  |  |  | 220
395740536532 | 5006 Timberlea Blvd., [NAME], ON |  |  |  |  |  |  | 765
395256316026 | 1550 Ponce De Leon, San Juan, PR | Wixom(F)-Air-PR(F) | DEO/SJU | 256 |  |  |  | 585
395052368905 | 1550 Ponce De Leon, San Juan, PR | Wixom(F)-Air-PR(F) | DEO/SJU | 256 |  |  |  | 180
394212196515 | 5-823 Corydon Ave., [NAME], MB |  |  | 1132 |  |  |  | 370
394629516721 | 821 Tyson Rd., [NAME], AL |  |  | 930 |  |  |  | 125
394849267033 | 1550 Ponce De Leon, San Juan, PR | Wixom(F)-Air-PR(F) | DEO/SJU | 256 |  |  |  | 1000
394629516721 | 821 Tyson Rd., [NAME], AL |  |  | 930 |  |  |  | 125
394212196515 | 5-823 Corydon Ave., [NAME], MB |  |  | 1132 |  |  |  | 370
7218880255 | 10828 [NAME], Dallas, TX |  |  | 1214 |  |  |  | 1225
392732394061 | 6970 Van Buren Blvd., [NAME], CA |  |  | 2340 |  |  |  | 100
393291958977 | 7746 S. Union Park Ave., Midvale, UT |  |  | 1752 |  |  |  | 100
394097276185 | 351 Steelcase Road West, [NAME], ON |  |  | 272 |  |  |  | 285
390467063620 | 1442 Cliveden Ave., Delta, BC |  |  | 2453 |  |  |  | 613
390917362253 | Missing |  |  | 0 |  |  |  | 0
7218880093 | 1700 Northridge NW., Walker, MI |  |  | 172 |  |  |  | 200
7218880196 | 1020-A Derita Rd., Concord, NC |  |  | 678 |  |  |  | 543
779073626737 | 1735 West Front St., Plainfield, NJ |  |  | 647 |  |  |  | 1010
390192722655 | 4000 Eastdale Circle, Montgomery, AL |  |  | 866 |  |  |  | 125
779653759736 | 12610 Interuban Ave S., Seattle, WA |  |  | 2330 |  |  |  | 500
779756829896 | 1020-A Derita Rd., Concord, NC |  |  | 678 |  |  |  | 543
39020058890 | 11720 Montana Ave., El Paso, TX |  |  | 1744 |  |  |  | 135
390468918559 | 75 Aventura Court, Mississauga, ON |  |  | 248 |  |  |  | 735
390560773618 | 4700 Broadmoor Ave. SE., Kentwood, MI |  |  | 124 |  |  |  | 115
779576698132 | 1045 Middlegate Rd., [NAME], ON |  |  | 255 |  |  |  | 880
779552101996 | 10701 Gateway Blvd. S., El Paso, TX |  |  | 1714 |  |  |  | 105
779663003194 | 3131 [NAME]., Columbus, GA |  |  | 833 |  |  |  | 975
390669947752 | 222 West Merchandise Mart, Chicago, IL |  |  | 300 |  |  |  | 420
Totals
Spreadsheet: 135928d1326309973-can-i-extract-hyperlinks-from-images-busdocs1
Sheet: Sheet1

 | http://livelink.txu.com/livelink/livelink.exe?func=ll&objId=52977&objAction=browse | General Business
 | javascript:(0)
 | http://livelink.txu.com/livelink/livelink.exe?func=ll&objId=142583&objAction=browse
 | http://livelink.txu.com/livelink/livelink.exe?func=ll&objId=142583&objAction=browse | 2010 - 2011 SMB Process Alerts
 | javascript:(0)
 | http://livelink.txu.com/livelink/livelink.exe?func=ll&objId=1425759&objAction=browse
 | http://livelink.txu.com/livelink/livelink.exe?func=ll&objId=1425759&objAction=browse | 01/11
 | javascript:(0)
 | [NAME]
 | [NAME] | 2011-01-13 SMB Process Alert
 | javascript:(0)
 | http://livelink.txu.com/livelink/livelink.exe/1466215/2011-01-21_SMB_Process_Alert.doc?func=doc.Fetch&nodeid=1466215 | 2011-01-21 SMB Process Alert
 | http://livelink.txu.com/livelink/livelink.exe/1466215/2011-01-21_SMB_Process_Alert.doc?func=doc.Fetch&nodeid=1466215
 | javascript:(0) | 2011-01-28 SMB Process Alert
 | http://livelink.txu.com/livelink/livelink.exe/1481535/2011-01-28_SMB_Process_Alert.docx?func=doc.Fetch&nodeid=1481535
 | http://livelink.txu.com/livelink/livelink.exe/1481535/2011-01-28_SMB_Process_Alert.docx?func=doc.Fetch&nodeid=1481535 | 02/11
 | javascript:(0)
 | http://livelink.txu.com/livelink/livelink.exe?func=ll&objId=1425046&objAction=browse
 | http://livelink.txu.com/livelink/livelink.exe?func=ll&objId=1425046&objAction=browse | 2011-02-01 Emergency Process Alert
 | javascript:(0)
 | http://livelink.txu.com/livelink/livelink.exe/1493345/2011-02-01_Emergency_Process_Alert.doc?func=doc.Fetch&nodeid=1493345 | 2011-02-14 SMB Process Alert
 | http://livelink.txu.com/livelink/livelink.exe/1493345/2011-02-01_Emergency_Process_Alert.doc?func=doc.Fetch&nodeid=1493345
 | javascript:(0) | 2011-02-18 Apt/Const Services Process Alert
 | http://livelink.txu.com/livelink/livelink.exe/1528245/2011-02-14_SMB_Process_Alert.docx?func=doc.Fetch&nodeid=1528245
 | http://livelink.txu.com/livelink/livelink.exe/1528245/2011-02-14_SMB_Process_Alert.docx?func=doc.Fetch&nodeid=1528245
 | javascript:(0)
 | http://livelink.txu.com/livelink/livelink.exe/1534543/2011-02-18_Apt_Const_Services_Process_Alert.docx?func=doc.Fetch&nodeid=1534543
 | http://livelink.txu.com/livelink/livelink.exe/1534543/2011-02-18_Apt_Const_Services_Process_Alert.docx?func=doc.Fetch&nodeid=1534543
 | javascript:(0)
Spreadsheet: d3129ddb-c4c3-47c2-b908-98e6dd6c9097
Sheet: Sheet1

ĐẠI HỌC QUỐC GIA TP.HCM | Unnamed: 1 | Unnamed: 2 | Unnamed: 3 | Unnamed: 4 | Unnamed: 5 | Unnamed: 6
TRƯỜNG ĐẠI HỌC KHOA HỌC TỰ NHIÊN
THỜI KHÓA BIỂU LỚP ÔN THI HỆ HOÀN CHỈNH ĐẠI HỌC
NGÀNH CÔNG NGHỆ THÔNG TIN KHÓA 2011
(Thời gian học từ 31/10/2011 đến 11/12/2011)
THỨ 2 | THỨ 3 | THỨ 4 | THỨ 5 | THỨ 6 | THỨ 7 | CHỦ NHẬT
 | ĐS tuyến tính (Lớp 1) |  |  |  |  | Trí tuệ nhân tạo
 | GV: Lê Văn Hợp |  |  |  |  | GV: Lê Ngọc Thành
 | 7h30 - 10h30 |  |  |  |  | 8h - 11h
 | F301 |  |  |  |  | E403
 |  | Cấu trúc dữ liệu (Lớp 1) | KT lập trình (Lớp 1) | [NAME] tích (Lớp 1) |  | ĐS tuyến tính (Lớp 2)
 |  | GV: Ng Thanh Phương | GV: Ng T T Minh Khang | GV: [NAME] |  | GV: Lê Văn Hợp
 |  | 13h30 - 16h30 | 13h30 - 16h30 | 13h30 - 16h30 |  | 13h30 - 16h30
 |  | Giảng đường 1 | E403 | Giảng đường 2 |  | Giảng đường 2
 |  |  |  |  |  | [NAME] đầu học từ 13/11
 |  |  |  |  |  | [NAME] rời rạc
 |  |  |  |  |  | GV: Ng [NAME]
 |  |  |  |  |  | 13h30 - 16h30
 |  |  |  |  |  | C33
KT lập trình (Lớp 2) | Đồ họa | [NAME] tích (Lớp 2) | Cơ sở dữ liệu | Cấu trúc dữ liệu (Lớp 2) | Mạng [NAME]
GV: Ng T T Minh Khang | GV: Cao Xuân Nam | GV: [NAME] | GV: Ng Trần Minh Thư | GV: Ng Thanh Phương | GV: Đỗ Hoàng Cường
17h50 - 20h50 | 17h50 - 20h50 | 17h50 - 20h50 | 17h50 - 20h50 | 17h50 - 20h50 | 17h50 - 20h50
Giảng đường 2 | Giảng đường 2 | Giảng đường 2 | Giảng đường 2 | Giảng đường 2 | C23
 |  |  |  | Ngày 26 tháng 10 năm 2011
 |  |  |  | [NAME] tạo
Spreadsheet: 125145d1318906006-automatically-update-chart-over-column-testing
Sheet: ThinkPad(12m)

Cost per MM (rolling)
Total
Call Centre
Labor
Distribution
Parts
Parts - WAC
Parts - Redemption
RA Rate (rolling 12m)
Cost per Claim (rolling 12m)
Total
Call Centre
Labor
Distribution
Parts
Parts - WAC
Parts - Redemption
Cost per MM
Total
Call Centre
Labor
Distribution
Parts
Parts - WAC
Parts - Redemption
RA Rate
Cost per Claim
Total
Call Centre
Labor
Distribution
Parts
Parts - WAC
Parts - Redemption
Cost
Total
Call Centre
Labor
Distribution
Parts
Parts - WAC
Parts - Redemption
Claims
MM
Claims Breakdown