tianzl66/Sheetpedia huggingface dataset:
Spreadsheet: dan_hyvl__4708__EngageCanada_amend
Sheet: Sheet1

Master Firm Purchase/Sale Amendment Agreement Worksheet
 |  | ATTORNEY: | [NAME]
DATE: | 2000-11-28 00:00:00 | DEAL MAKER:
COUNTERPARTY: | Engage Energy Canada, L.P. | CONTACT: | Suzzi Sethi
ADDRESS: | 1100, 421 - 7th Avenue SW | TITLE: | Legal
 | Calgary, AB T2P 4K9 | PHONE: | [PHONE]
 |  | FAX:
Incorporation State | Alberta | S&P Rating | DBRS:   A(low)
STRUCTURE | COUNTERPARTY | ECT
GUARANTOR (RATING) | Westcoast Energy Inc.(1) | Enron Corp. (2)
LIMIT $ MILLIONS | US $15MM | US $15MM
Incorporation State | British Columbia, Canada | OR
COLLATERAL  THRESHOLD
 | US$10MM | US$10MM
Specify Type of Debt:
COLLATERAL TYPE
Letter of Credit | OK | OK
Cash
MINIMUM TRANSFER $ | 1 | 1
COLLATERAL ROUNDING | 250000 | 250000 | USD
HOLDING and USE OF COLLATERAL
Permitted | X | X
Minimum S & P/Moody's
rating permitted
MATERIAL ADVERSE CHANGE TRIGGERS - if Matrix not applicable
APPLY TO:
-Counterparty
-Guarantor | X | X
Debt Ratings Change | X
-Below = S&P/Moody's | BBB   (DBRS) | BBB- | S&P
Financial Covenants
-Funded debt/Worth
-Minimum Net Worth
-EBITDA/Interest
Non-Specific
-Unilateral
Non-Standard Definitions
-Funded Debt
-Net Worth
EVENTS OF DEFAULT
3rd party debt | X | X
-Counterparty ($[NAME])
-Guarantor ($[NAME]) | US $65MM | US $100MM
Change in ownership
FINANCIAL STATEMENTS
-Standard | X | X
- Request financials on:
CREDIT DECISION: | APPROVED :  X | DECLINED:
OUTSTANDING SWAP TRANSACTIONS: |  | YES: x | NO:
ALL SWAPS TO ROLL UP UNDER NEW MASTER: |  | YES: x | NO:
CREDIT PROVISIONS OF MASTER TO GOVERN: |  | YES: x | NO:
OTHER COMMENTS:
Westcoast is the new guarantor for this counterparty per the restructuring in September.  I think a new Master
should be drafted to replace the current agreement dated 10/93.  With this, new guaranty's will need to be
drafted from both counterparts accordingly:
(1) Please include a draft of the Guaranty with Westcoast as the Guarantor, and include ENA and ECC
as the Guaranty'd counterparty's.  The guaranty should be for $15MM.
(2) Please include a draft of the Guaranty with Enron as the Guarantor, with Engage Enegry Canada as the
Guaranty'd counterparty.  This guaranty should also be in the amount of $15MM.
CREDIT REVIEW  PREPARED BY: |  | [NAME] | x3-0906
Spreadsheet: 3293c68e-f304-4c32-8686-babdd9a8d6c6
Sheet: Serviio

 | Serviio
 | OS | Status | Detect | Plays
 | Windows XP
 | Windows 7/8 | T | D | P
 | Linux
 | OS X
 | T= Test  NT=Not Tested
 | D=Detectable ND=Not Detectable (have not been able to get this working yet)
 | P=Plays Movies (refer to list below)  NP=Will not play any media
 | Container | Audio Codec | Video Codec | Plays | [NAME]? | Exceptions
 | .avi | [NAME] | ac3 | Y | Y
 | .avi | [NAME] | mp3 | Y | Y
 | .avi | msmpeg4v2 | mp3 | Y | Y
 | .avi | divx5 | mp3 | Y | Y
 | .avi | [NAME] | mp3 | Y | Y
 | .avi | [NAME] | divx audio v2 | Y | Y
 | .avi | divx4 | mp3 | Y | Y
 | .flv | h264 | aac | Y | Y
 | .m4v | h264 | aac | Y | Y
 | .mkv | h264 | ogg | Y | Y
 | .mkv | h264 | aac | Y | Y
 | .mp4 | h264 | aac | Y | Y
 | .mpg | mpeg1 | mp2 | Y | Y
 | .mpg | mpeg2 | mp2 | Y | Y
 | Y=Plays in full  N1=Plays but doesn't recognize audio codec N2=Plays but doesn't recognize video codec NP=does not play
 | Exceptions refers to the ability to get that type of file to be played via a particular OS
 | WXP=not working in Windows XP  W78=not working in Windows 7/8  [NAME]=not working in Linux MAC=not working in MAC
 | Notes
 | You need to find the IP address of your TV and then open the Serviio Console and in the status tab, find your IP Address and change it from a generic profile to [NAME] TV.
 | Serviio does play DTS audio.
Spreadsheet: 92622d1292199980-excel-2007-combinations-exa1
Sheet: Sheet1

1 | 1 | 1 | 1 | 1 | 1
1 | 1 | 1 | 1 | 1 | 2
1 | 1 | 1 | 1 | 1 | 3
1 | 1 | 1 | 1 | 1 | 4
1 | 1 | 1 | 1 | 1 | 5
1 | 1 | 1 | 1 | 1 | 6
1 | 1 | 1 | 1 | 1 | 7
1 | 1 | 1 | 1 | 1 | 8
1 | 1 | 1 | 1 | 1 | 9
1 | 1 | 1 | 1 | 1 | 10
1 | 1 | 1 | 1 | 1 | 11
1 | 1 | 1 | 1 | 1 | 12
1 | 1 | 1 | 1 | 1 | 13
1 | 1 | 1 | 1 | 2 | 1
1 | 1 | 1 | 1 | 2 | 2
1 | 1 | 1 | 1 | 2
1 | 1 | 1 | 1 | 2
1 | 1 | 1 | 1 | 2
1 | 1 | 1 | 1 | 2
1 | 1 | 1 | 1 | 2
1 | 1 | 1 | 1 | 2
1 | 1 | 1 | 1 | 2
13 | 13 | 13 | 13 | 13 | 13
Spreadsheet: 822676d1679484991-top-company-value-print-top-value-company-example
Sheet: Sheet1

Value | Company |  | Top Company
1 | a
2 | b
3 | c
4 | d
222 | e
6 | f
7 | g
8 | h
9 | i
10 | j
Spreadsheet: 297084d1392280530-how-to-search-and-remove-a-series-of-entries-based-on-adjacent-values-search-and-remove3
Sheet: Sheet1

The data to process is in Columns A and B.
A "series" has the same *****-*** at the beginning of the number.  E.g.  15263-001    . There may be various hyphens/numbers/letters joined to the right.
I want to delete a series if the average of the numbers in the adjacent cell B is less than 20.
In below example,  All of Series 1(15623-001) and 3(61232-851) will remain, but all of Series 2(76219-002) will be deleted.
15263-001-S | 24 | 001 | -
15263-001-M | 89 | 001 | -
15263-001-L | 3 | 001 | -
15263-001-XL | 62 | 001 | -
15263-001-XXL | 40 | 001 | -
76219-002-1 | 0 | 002 | Delete
76219-002-2 | 0 | 002 | Delete
76219-002-3 | 5 | 002 | Delete
76219-002-4 | 4 | 002 | Delete
76219-002-5 | 9 | 002 | Delete
76219-002-6 | 22 | 002 | Delete
76219-002-7 | 4 | 002 | Delete
76219-002-8 | 18 | 002 | Delete
76219-002-9 | 7 | 002 | Delete
76219-002-10 | 0 | 002 | Delete
76219-002-11 | 0 | 002 | Delete
61232-851-1 | 150 | 851 | Retain
61232-851-2 | 200 | 851 | Retain
61232-851-3 | 34 | 851 | Retain
61232-851-4 | 68 | 851 | Retain
61232-851-5 | 51 | 851 | Retain
61232-851-6 | 89 | 851 | Retain
61232-851-7 | 2 | 851 | Retain
61232-851-8 | 46 | 851 | Retain
61232-851-9 | 5 | 851 | Retain
61232-851-10 | 80 | 851 | Retain
Spreadsheet: 730492d1619717596-chained-xlookup-and-reverse-partial-lookup-search-lookup-sku-prefix-and-reverse-partial-lookup-colour-code-suffix
Sheet: B

Prefix | Colour code
B1063 | [NAME])
B1063 | Silver(2)
B1063 | Old Gold(22)
B1063 | Old Silver(23)
B72 | Black(1)
P910 | Natural(2)
B500 | Gold(22)
B900 | Old Gold(22)
K100 | Blue(22)
K101 | GOLD
Spreadsheet: phillip_m_love__30152__9905_OA
Sheet: TX-HPL-GL 

ENRON CAPITAL & TRADE RESOURCES
OPERATIONAL ANALYSIS - ACTUALS
COMPANY:  HPL
REGION:  TEXAS
 |  |  | Total |  | Reclasses |  |  |  |  |  |  |  |  |  | September |  | October |  | November |  | December |  | January |  | February |  | March |  | April |  | May |  | June |  | July |  | August |  | September
 |  |  | Volume | $'s | Volume | $'s | Volume | $'s | Volume | $'s | Volume | $'s | Volume | $'s | Volume | $'s | Volume | $'s | Volume | $'s | Volume | $'s | Volume | $'s | Volume | $'s | Volume | $'s | Volume | $'s | Volume | $'s | Volume | $'s | Volume | $'s | Volume | $'s | Volume | $'s
 | Sales:
1 |  | 3rd Party / Inter Enron |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | -1 | -2.21
2 |  | Liquidations
3 |  | Interdesk
4 |  | Option Premiums
5 |  | Dmd Reimbursements
 | Total Sales:
 | Purchases:
6 |  | 3rd Party / Inter Enron
7 |  | Liquidations
8 |  | Interdesk
9 |  | Option Premiums
10 |  | [NAME]
 | Total Purchases:
 | Intra CTS (EGM / HPL / LRC):
11 |  | Sales
12 |  | Purchases
 | Total Intra CTS Sales / Purchases
 | Imbalances:
13 |  | In Kind |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 10227 | 23399.38
14 |  | Cash Out
15 |  | Cash In
16 |  | Synthetic Storage
 | Total Imbalances:
 | Storage:
17 |  | Injection (Sales to Stg)
18 |  | W/D (Purchase from Stg)
19 |  | Inventory Profit
 |  | Total W/D
 | Total Storage:
20 | Linepack:
21 | Shrinkage:
22 | UA4: |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | -10226 | -22568.78
23 | Fuel:
 | Transport Expense:
24 |  | Commodity |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | -30000 | 73.16
25 |  | Demand |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 2998.89
 | Total Transport Expense:
 | Transport Revenue:
26 |  | Interstate
27 |  | Intrastate
 | Total Transport Revenue:
 | Intra CTS (EGM / HPL / LRC):
28 |  | Transport Expense
29 |  | Transport Revenue |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 1007
 | Total Intra CTS Transport
 | Tie Out Schedule Items:
 |  | MTM Income:
30 |  | Current Gross Book Balance
31 |  | Prior Month Book Balance
 |  | Total MTM Income
32 |  | Prudency
33 |  | Financial Liquidations
34 |  | Originations
35 |  | Broker Fees
36 |  | Asset Group Demand Charges
37 |  | [NAME]
38 |  | Interdesk Charges
39 |  | Canada
40 |  | Miscellaneous
 |  | TOTAL
Spreadsheet: 14d69778-0011-4d11-99b9-887826705697
Sheet: Sheet1

Adresseliste fra www.proff.no | Unnamed: 1 | Unnamed: 2 | Unnamed: 3 | Unnamed: 4 | Unnamed: 5 | Unnamed: 6 | Unnamed: 7
[NAME]:Alarm- og sikringsanlegg
FIRMANAVN | ADRESSE | POSTNR. | POSTSTED | TELEFON | TELEFAKS
[NAME] [NAME] | [NAME] 101 | 4376 | Helleland | 488 68 688
Bygg og Boligsikring AS | Sønsterudveien 26 | 1412 | Sofiemyr | 22 00 60 10 | 66 99 45 49
Optimal Sikkerhetssystemer AS | Storgata 61 | 1724 | Sarpsborg | 69 15 08 15
911-Tjenesten AS | Skippergata 12 | 3921 | Porsgrunn | 35 93 12 50
Prosec Bergen AS | Leirvikåsen 43B | 5179 | Godvik | 478 32 100
Vicon Norway A/S | Munkerudtunet 10 | 1164 | Oslo | 22 74 10 01 | 22 28 85 01
Adi-Alarmsystem Norge AS | Kanalveien 55 | 5068 | Bergen | 22 72 03 60
Oslo Bilstereo AS | Bedriftsveien 6 | 0950 | Oslo | 22 16 20 59 | 22 16 55 66
Phono-elektro-akustikk A/S | Hoff terrasse 2 | 0275 | Oslo | 22 50 87 00 | 22 50 87 03
Netcam Norge AS | Hoffsveien 16B | 0275 | Oslo | 21 68 23 00
[NAME] and Security AS | [NAME] | 4623 | Kristiansand | 38 06 61 00 | 38 06 61 01
[NAME] and Security AS Region Nord | Verkstedvegen 1 | 9406 | Harstad | 77 00 25 50 | 77 00 25 51
Nortronik AS | Flovegen 12 | 6800 | [NAME] | 57 83 20 00 | 57 83 07 81
[NAME] Security AS | [NAME] 23 | 1081 | Oslo | 23 28 70 00 | 23 28 70 01
[NAME] and Security AS Region Sør-Vest | Lagerveien 24 | 4033 | Stavanger | 51 84 09 00 | 51 84 09 49
[NAME] and Security AS | Norevegen 6 | 5542 | [NAME] | 52 83 88 50 | 52 83 88 51
Viste & Sømme AS | Prinsens vei 10A | 4315 | Sandnes | 51 96 12 00 | 51 96 12 01
Urheims Elektrokompani AS |  | 5012 | Bergen | 55 90 44 20
Noby A/S | [NAME] vei 5 | 1153 | Oslo | 23 03 14 00 | 23 03 14 01
Idteq AS | [NAME] 13 | 1383 | Asker | 66 98 82 00 | 66 98 82 01
[NAME] and Security AS avd [NAME] | Stalsbergveien 9 | 3128 | Nøtterøy | 33 38 25 00 | 33 38 25 25
Automatikk-Service AS | Strømsveien 346 | 1081 | Oslo | 950 60 138
Adi-Alarmsystem Norge AS | [NAME] | 3047 | Drammen | 32 20 28 60
Trygghetssystemer AS | Leirvikflaten 17 | 5179 | Godvik | 55 94 89 90
Alcom AS | [NAME] 18 | 1659 | Torp | 69 17 57 50 | 69 17 57 60
Trenger du oppdaterte adresselister til DM /TM? [NAME] (www.forvalt.no) tilbyr ett segmenterings- og uttekksverktøy hvor du [NAME] frem til din målgruppe og eksportere lister til Excel. Du kan gjøre oppslag så ofte du vil, med en begrensning på 3500 selskap per søk. Våre telefonnummere er hentet fra Telefonkatalogen og [NAME].  Med segmenteringsverktøy kan du: - Hente ut adresseliste før en DM utsendelse - Lage ringelister - Hente ut bransjestatistikker - Oppdatere din kundedatabase  Se http://forvalt.no/segmenteringsverktoy/
Spreadsheet: 837831d1690456913-array-formula-division-help-needed-array_formula
Sheet: Sheet1

Building | Capacity | Headcount
A | 1 | 1
A | 2 | 2
A | 3 | 3
A | 4 | 4
A | 5 | 5
B | 6 | 6
B | 7 | 7
B | 8 | 8
B | 9 | 9
B | 10 | 10
Spreadsheet: 72129d1272838441-need-formula-for-multiple-dates-example-of-multiple-dates
Sheet: Sheet1

Current |  |  |  | Desired
Date | Multiple? |  |  | Date | Additional rows?
2010-03-01 00:00:00 | 0 |  |  | 2010-03-01 00:00:00 | 0
2010-03-02 00:00:00 | 0 |  |  | 2010-03-02 00:00:00 | 0
2010-03-03 00:00:00 | 2 |  |  | 2010-03-03 00:00:00 | 2
2010-03-04 00:00:00 | 4 |  |  | 2010-03-03 00:00:00
2010-03-05 00:00:00 | 0 |  |  | 2010-03-03 00:00:00
2010-03-06 00:00:00 | 0 |  |  | 2010-03-04 00:00:00 | 4
2010-03-07 00:00:00 | 0 |  |  | 2010-03-04 00:00:00
2010-03-08 00:00:00 | 0 |  |  | 2010-03-04 00:00:00
2010-03-09 00:00:00 | 0 |  |  | 2010-03-04 00:00:00
2010-03-10 00:00:00 | 3 |  |  | 2010-03-04 00:00:00
2010-03-11 00:00:00 | 2 |  |  | 2010-03-05 00:00:00 | 0
2010-03-12 00:00:00 | 0 |  |  | 2010-03-06 00:00:00 | 0
2010-03-13 00:00:00 | 0 |  |  | 2010-03-07 00:00:00 | 0
2010-03-14 00:00:00 | 0 |  |  | 2010-03-08 00:00:00 | 0
2010-03-15 00:00:00 | 0 |  |  | 2010-03-09 00:00:00 | 0
2010-03-16 00:00:00 | 0 |  |  | 2010-03-10 00:00:00 | 3
2010-03-17 00:00:00 | 4 |  |  | 2010-03-10 00:00:00
2010-03-18 00:00:00 | 0 |  |  | 2010-03-10 00:00:00
 |  |  |  | 2010-03-10 00:00:00
 |  |  |  | 2010-03-11 00:00:00 | 2
 |  |  |  | 2010-03-11 00:00:00
 |  |  |  | 2010-03-11 00:00:00
 |  |  |  | 2010-03-12 00:00:00 | 0
 |  |  |  | 2010-03-13 00:00:00 | 0
 |  |  |  | 2010-03-14 00:00:00 | 0
 |  |  |  | 2010-03-15 00:00:00 | 0
 |  |  |  | 2010-03-16 00:00:00 | 0
 |  |  |  | 2010-03-17 00:00:00 | 4
 |  |  |  | 2010-03-17 00:00:00
 |  |  |  | 2010-03-17 00:00:00
 |  |  |  | 2010-03-17 00:00:00
 |  |  |  | 2010-03-17 00:00:00
 |  |  |  | 2010-03-18 00:00:00
Spreadsheet: 808521d1670505947-formula-to-extend-to-next-day-in-an-excel-table-table-extend-formula
Sheet: Sheet1

Date | Total Required | Total installed up to date | in percent | up to 26-Oct-22 | 27/10/2022 | 28/10/2022 | 28/10/2023
Item1 |  |  |  | 289066 | 0
Item2 | 57325.19 |  |  | 57164.25 | 7.53 | 15.06 | 20.25
Item3 | 58591.63 |  |  | 48480.47 | 0
Item4 | 145002.12 |  |  | 144780.06 | 0
Item5 | 162708.72 |  |  | 123461.49 | 1136.1 | 1216.3 | 1234
Item6 |  |  |  | 21486 | 0
Item7 | 144926.7 |  |  | 142176.7 | 331.28 |  | 123.45
Item8 | 37852.11 |  |  | 19023.71 | 0
Item9 | 23832.43 |  |  | 12463.03 | 137.66 | 181.2 | 234.56
Total |  |  |  |  |  |  | 1987.56
 |  | This is the current [NAME] in Col C
 |  | =SUM(Table1[@[up to 26-Oct-22]:[28/10/2022]]) |  |  |  |  | This does not gets inclued
 |  |  |  |  |  |  | in the SUM Function
 |  |  |  |  |  |  | in Column C
Spreadsheet: 694884d1599855296-vlookup-not-working-sample
Sheet: Export 2

VLOOKUP
 | Fra2 | 21 | 2020-08-29 00:00:00 | 1400 | 02 | Caen | [NAME] | 1 | 0 | 1 | 0 | 10 | 7 | 12 | 8 | 2.66 | 2.78 | 3.16 | 2.76 | 1.46
 | Fra2 | 21 | 2020-08-29 00:00:00 | 1400 | 02 | [NAME] | Guingamp | 2 | 2 | 0 | 0 | 14 | 9 | 16 | 14 | 2.94 | 2.79 | 2.83 | 2.64 | 1.49
 | Fra2 | 21 | 2020-08-29 00:00:00 | 1800 | 02 | Chateauroux | Auxerre | 1 | 2 | 0 | 0 | 5 | 12 | 17 | 7 | 3.19 | 3.02 | 2.45 | 2.36 | 1.6
 | Fra2 | 21 | 2020-08-29 00:00:00 | 1800 | 02 | Dunkerque | Clermont | 1 | 1 | 1 | 0 | 9 | 15 | 11 | 13 | 3.03 | 2.77 | 2.76 | 2.46 | 1.56
Spreadsheet: 164225d1340700710-breakup-phone-bill-pivottable-1-
Sheet: Pivot Table

Unit Number | 001
Call Type | [NAME]
Row Labels | Sum of Time | Sum of Call Duration | Count of Rate | Sum of Amount
2012-03-28 00:00:00 | 08:18:00 | 00:02:24 | 1 | 0.15
2012-03-29 00:00:00 | 1900-01-01 19:17:00 | 00:38:31 | 4 | 0.6
2012-04-01 00:00:00 | 17:31:00 | 00:37:24 | 1 | 0.15
2012-04-02 00:00:00 | 1900-01-01 10:24:00 | 00:09:16 | 3 | 0.45
2012-04-05 00:00:00 | 10:23:00 | 00:00:21 | 1 | 0.15
2012-04-10 00:00:00 | 08:34:00 | 00:32:08 | 1 | 0.15
2012-04-11 00:00:00 | 10:33:00 | 00:03:17 | 1 | 0.15
2012-04-18 00:00:00 | 21:34:00 | 00:32:55 | 2 | 0.3
2012-04-20 00:00:00 | 09:18:00 | 00:00:51 | 1 | 0.15
2012-04-22 00:00:00 | 1900-01-01 15:44:00 | 00:42:33 | 3 | 0.45
2012-04-23 00:00:00 | 1900-01-01 06:09:00 | 00:01:54 | 2 | 0.3
2012-04-25 00:00:00 | 19:10:00 | 00:00:26 | 1 | 0.15
2012-04-26 00:00:00 | 08:04:00 | 00:27:15 | 1 | 0.15
Grand Total | 1900-01-10 20:59:00 | 03:49:15 | 22 | 3.299999999999999
Spreadsheet: 117816d1313052591-using-excel-to-manage-worked-houres-staff-manager
Sheet: dataexport

Name | Door | Date/Time | DATE | TIME |  | Name | Door | Date/Time | DATE | TIME
[NAME] | IN_TK1 | 2011-07-24 06:35:00 | 2011-07-24 00:00:00 | 06:35:00 |  | [NAME] | OUT_TK1 | 2011-07-24 14:00:00 | 2011-07-24 00:00:00 | 14:00:00
[NAME] | IN_TK2 | 2011-07-24 06:36:00 | 2011-07-24 00:00:00 | 06:36:00 |  | [NAME] | OUT_TK4 | 2011-07-24 11:30:00 | 2011-07-24 00:00:00 | 11:30:00
[NAME] | IN_TK2 | 2011-07-24 22:40:00 | 2011-07-24 00:00:00 | 22:40:00 |  | [NAME] | OUT_TK3 | 2011-07-25 06:30:00 | 2011-07-25 00:00:00 | 06:30:00
[NAME] | IN_TK1 | 2011-07-25 15:25:00 | 2011-07-25 00:00:00 | 15:25:00 |  | [NAME] | OUT_TK2 | 2011-07-25 23:00:00 | 2011-07-25 00:00:00 | 23:00:00
[NAME] | IN_TK3 | 2011-07-25 23:43:00 | 2011-07-25 00:00:00 | 23:43:00 |  | [NAME] | OUT_TK2 | 2011-07-26 08:30:00 | 2011-07-26 00:00:00 | 08:30:00
[NAME] | IN_TK2 | 2011-07-26 07:10:00 | 2011-07-26 00:00:00 | 07:10:00 |  | [NAME] | OUT_TK3 | 2011-07-26 15:30:00 | 2011-07-26 00:00:00 | 15:30:00
 |  |  |  |  |  | [NAME] | OUT_TK1 | 2011-07-24 14:30:00 | 2011-07-24 00:00:00 | 14:30:00
Spreadsheet: 175574d1345571497-creating-drop-down-lists-and-filters-with-formulas-example2
Sheet: database

Company | Contact | [NAME] | Phone | Function | Registration number
Company1 | ContactA | [EMAIL] | not important | not important | not important
Company1 | ContactB | [EMAIL] | not important | not important | not important
Company3 | ContactC | [EMAIL] | not important | not important | not important
Company2 | ContactD | [EMAIL] | not important | not important | not important
Company3 | ContactE | [EMAIL] | not important | not important | not important
Company3 | ContactF | [EMAIL] | not important | not important | not important
Spreadsheet: 188ccb8c-5b6a-45b3-9be9-bb9c79ad0648
Sheet: Sheet1

Unnamed: 0 | Unnamed: 1 | Unnamed: 2 | Unnamed: 3 | Unnamed: 4 | Unnamed: 5 | Unnamed: 6 | Unnamed: 7 | Unnamed: 8 | Unnamed: 9 | Unnamed: 10 | Unnamed: 11
 | Climate-related bilateral and regional development assistance per sector and per year, based on Annex 3 (SEK million)
 | Mitigation |  |  |  |  |  | Adaptation |  |  | Other | TOTAL
 | Energy | Transport | Forestry | Agriculture | Waste management | Industry | Capacity building/ research | Management of coastal areas | Other vulnerability reduction
2000 | 312 | 36 | 51 | 134 | 64 | 32.5 | 318 | 130 | 23 | 384 | 1484
- of which credits | 41 | - | - | - | - | - | - | - | - | 20 | 61
2001 | 557 | 27 | 65 | 102 | 58 | 24.4 | 398 | 73 | 31 | 532 | 1867
- of which credits | 340 | - | - | - | 18 | - | - | - | - | 62 | 421
2002 | 350 | 47 | 100 | 120 | 80 | 19.7 | 512 | 47 | 46 | 435 | 1757
- of which credits | 60 | - | 5 | - | 11 | - | 45 | - | - | 18 | 139
2003 | 354 | 161.1 | 92 | 108 | 106 | 18.2 | 473 | 36 | 50 | 249 | 1646
- of which credits | 108 | - | - | - | - | - | - | - | - | 181 | 289
Note by the UNFCCC secretariat: Annual sector contributions, without specification of whether they are credits or not, are captured in the national communications module.
Spreadsheet: 8d79939f-0f22-4347-b0f1-a948f2bd6c0a
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
42836146 | 2014-08-22 21:35:46 | ALLIES | 0 | 3 | 6 | 704025 | secret_strategem | 7429 | mediterranean | 1941-06-15 | 1941-06-17 | [NAME] | [NAME]
42836344 | 2014-08-22 22:00:14 | AXIS | 0 | 1 | 6 | 704025 | secret_strategem | 7429 | mediterranean | 1941-06-15 | 1941-06-17 | [NAME] | [NAME]
42836749 | 2014-08-22 22:42:29 | ALLIES | 0 | 8 | 10 | 1001447 | Matsuri | 7662 | eastern | 1942-10-22 | 1942-10-22 | Red Barricades Factory | Les Barricades Rouges
Spreadsheet: 97089d1296298069-hiding-cells-amptd_test
Sheet: Data Sources

 | Data Sources
 | Call Stats
 |  | Calls Answered | [NAME] Global\Agent [NAME] Swansea\2011
 |  | AHT | [NAME] Global\Agent [NAME] Swansea\2011
 |  | Talk | [NAME] Global\Agent [NAME] Swansea\2011
 |  | Work | [NAME] Global\Agent [NAME] Swansea\2011
 |  | Hold | [NAME] Global\Agent [NAME] Swansea\2011
 |  | Transfers | [NAME] Global\Agent [NAME] Swansea\2011
 |  | Outbound | [NAME] Global\Agent [NAME] Swansea\2011
 | Fault Metrics
 |  | [NAME] | Log Rate Report created by AP Business
 |  | FDT | Daily Agent Performance Report Created by AP Business
 |  | FLC | Daily Agent Performance Report Created by AP Business
 |  | Wasted | Daily Agent Performance Report Created by AP Business
 |  | Repeats | Daily Agent Performance Report Created by AP Business
 |  | Truck rate | Daily Agent Performance Report Created by AP Business
 |  | Mobile Compliance | Daily Agent Performance Report Created by AP Business
 |  | Appointed | Daily Agent Performance Report Created by AP Business
 |  | Ticket | Daily Agent Performance Report Created by AP Business
 |  | CSDC | Daily Agent Performance Report Created by AP Business
 | Other KPI
 |  | FTR | Client Site Report
 |  | [NAME] | Team Manager to confirm
 |  | NPS | Team Manager to confirm
 |  | Attendance | Team Manager to confirm
 | Other Items
 |  | One to One | From the date it was completed
 |  | Team Brief | From the date it was completed
 | Training items
 |  | 1 | From the date it was completed
 |  | 2 | From the date it was completed
 |  | 3 | From the date it was completed
 |  | 4 | From the date it was completed
 |  | 5 | From the date it was completed
 |  | 6 | From the date it was completed
 |  | 7 | From the date it was completed
 |  | 8 | From the date it was completed
 |  | 9 | From the date it was completed
 |  | 10 | From the date it was completed
Spreadsheet: 818757d1677034214-return-value-based-on-multiple-ranges-return-value-based-on-multiple-ranges
Sheet: Sheet1

Total Sales: | 50289.45 |  |  | Monthly Cycle
Total Revenue: | 79811.73999999999 |  |  | Adj. Rev |  | Bonus %
Total TGL: | 90 |  |  | 40000 | 49999 | 0.02
Deduct Finance Fees: | 1845.96 |  |  | 50000 | 59999 | 0.025
Total Adjusted Revenue: | 63231.63499999999 |  |  | 60000 | 69999 | 0.03
 |  |  |  | 70000 | 79999 | 0.035
Bonus: |  |  |  | 80000 | 89999 | 0.04
 |  |  |  | 90000 | 99999 | 0.045
 |  |  |  | 100000 | 109999 | 0.05
 |  |  |  | 110000 | 119999 | 0.055
 |  |  |  | 120000 | 599999 | 0.06
Trying to determine the best formula to use without using VLOOKUP.
If [NAME] is between E3 and F3, C6 = G3, if [NAME] is between E4 and F4, C6 = G4, same until bottom of [NAME] chart.
Spreadsheet: 551725d1513110644-formula-good-until-row-5000-then-no-data-after-5000th-row-workbook1
Sheet: Sheet2

 |  |  | Sum of #'s Below
 |  |  | Add | Subtract
C8 + - C9
C8 + - C12
C8 + - C13
C8 + - L8
C8 + - L9
 |  |  | Sum of #'s Below
 |  |  | Sum of #'s Below
 |  |  | Add | Subtract
C12 + - C13
C12 + - C16
C12 + - C17
C12 + - L12
C12 + - L13
 |  |  | Sum of #'s Below
 |  |  | Sum of #'s Below
 |  |  | Add | Subtract
C16 + - C17
[NAME]
C16 + - C21
[NAME]
[NAME]
 |  |  | Sum of #'s Below
 |  |  | Sum of #'s Below
 |  |  | Add | Subtract
 |  |  | Sum of #'s Below
 |  |  | Sum of #'s Below
 |  |  | Add | Subtract
Spreadsheet: benjamin_rogers__1298__Caledonia model template  final version III
Sheet: DEPR

DEPRECIATION CALCULATIONS
 |  | Tax | Book | US GAAP
Total Project Cost
Less:  Other Costs |  |  |  |  | MACRS Schedule
Less:  Working Capital |  |  |  |  | 0.0375 | 0.07219 | 0.06667 | 0.06177 | 0.05713 | 0.05285 | 0.04888 | 0.04522 | 0.04462 | 0.04461
Total Depreciable Basis
Current Year |  |  |  |  | 1
Calendar Year |  |  |  |  |  |  |  |  |  |  |  |  |  |  | Totals
Months of Operation
Tax Depreciation: |  |  |  | Original
Current Tax Depreciation: |  |  |  | Basis
 | Asset 1
 | Total Current Tax Depreciation
 | Accumulated Tax Depreciation
 | Beginning Tax Basis |  |  |  | 0
 | Plus:  New Additions
 | Less: Current Depreciation
 | Ending Tax Basis
Book Depreciation:
Current Book Depreciation:
 | Asset 1
 | Total Current Book Depreciation
 | Accumulated Book Depreciation
 | Beginning Book Basis |  |  |  | 0
 | Plus:  New Additions
 | Less: Current Depreciation
 | Ending Book Basis
US GAAP Depreciation:
Current Book Depreciation:
 | Asset 1
 | Total Current Book Depreciation
 | Accumulated Book Depreciation
 | Beginning Book Basis |  |  |  | 0
 | Plus:  New Additions
 | Less: Current Depreciation
 | Ending Book Basis