tianzl66/Sheetpedia huggingface dataset:
Spreadsheet: 837407d1690141513-auto-populate-values-for-a-month-based-on-a-previous-months-value-book1-example-1-
Sheet: Sheet1

ADT040 | CURRENT HOURS | 10000 |  |  | HOURS PER MONTH | 450
Plant No | PM Task & Desc | Last Service ODO | [NAME] | UOM | Section | Cost | Sep-22 | Oct-22 | Nov-22 | Dec-22 | Jan-23 | Feb-23 | Mar-23 | Apr-23 | May-23 | Jun-23 | Jul-23 | Aug-23 | Sep-23 | Oct-23 | Nov-23 | Dec-23
ADT040 | 13 - CHANGEOUT POS1 TYRE TH551 SANDVIK  ([NAME]) | 8000 | 2000 | HRS | Components Change | 12229.06
ADT040 | 14 - CHANGEOUT POS2 TYRE TH551 SANDVIK  (TASK#14) | 10000 | 2000 | HRS | Components Change | 12229.06
ADT040 | 15 - CHANGEOUT POS3 TYRE TH551 SANDVIK  (TASK#15) | 10000 | 2000 | HRS | Components Change | 12229.06
ADT040 | 16 - CHANGEOUT POS4 TYRE TH551 SANDVIK  (TASK#16) | 10000 | 2000 | HRS | Components Change | 12229.06
ADT040 | 496 - CHANGEOUT FRONT AXLE TH551 SANDVIK TRUCK (TASK#496) | 10000 | 14000 | HRS | Components Change | 96080.53
ADT040 | 497 - CHANGEOUT REAR AXLE TH551 SANDVIK TRUCK (TASK#497) | 10000 | 14000 | HRS | Components Change | 96080.53
Spreadsheet: 861231d1709158814-summarizing-and-graphing-trends-energy-use-data-sample
Sheet: Sheet2 (2)

Solar Time | 9:00AM-4:59PM |  |  |  | [NAME] | 09:00:00 | Solar End | 16:59:00
BatteryTime | 5:00PM-8:59AM
DATE | START TIME | END TIME | USAGE | Time
2022-08-01 00:00:00 | 00:00:00 | 00:59:00 | 0.58
2022-08-01 00:00:00 | 01:00:00 | 01:59:00 | 0.55
2022-08-01 00:00:00 | 02:00:00 | 02:59:00 | 0.58
2022-08-01 00:00:00 | 03:00:00 | 03:59:00 | 0.58
2022-08-01 00:00:00 | 04:00:00 | 04:59:00 | 1.42
2022-08-01 00:00:00 | 05:00:00 | 05:59:00 | 1.58
2022-08-01 00:00:00 | 06:00:00 | 06:59:00 | 1.38
2022-08-01 00:00:00 | 07:00:00 | 07:59:00 | 0.57
2022-08-01 00:00:00 | 08:00:00 | 08:59:00 | 0.41
2022-08-01 00:00:00 | 09:00:00 | 09:59:00 | 1.63
2022-08-01 00:00:00 | 10:00:00 | 10:59:00 | 2.84
2022-08-01 00:00:00 | 11:00:00 | 11:59:00 | 3.75
2022-08-01 00:00:00 | 12:00:00 | 12:59:00 | 3.41
2022-08-01 00:00:00 | 13:00:00 | 13:59:00 | 2.64
2022-08-01 00:00:00 | 14:00:00 | 14:59:00 | 2.35
2022-08-01 00:00:00 | 15:00:00 | 15:59:00 | 2.08
2022-08-01 00:00:00 | 16:00:00 | 16:59:00 | 2.99
2022-08-01 00:00:00 | 17:00:00 | 17:59:00 | 1.59
2022-08-01 00:00:00 | 18:00:00 | 18:59:00 | 1.88
2022-08-01 00:00:00 | 19:00:00 | 19:59:00 | 1.39
2022-08-01 00:00:00 | 20:00:00 | 20:59:00 | 2.7
2022-08-01 00:00:00 | 21:00:00 | 21:59:00 | 1.54
2022-08-01 00:00:00 | 22:00:00 | 22:59:00 | 1.11
2022-08-01 00:00:00 | 23:00:00 | 23:59:00 | 1.08
Desired Results
Date | Type | Usage kWH
2022-08-01 00:00:00 | Solar time
2022-08-01 00:00:00 | Battery time
Spreadsheet: 600097d1543463487-enter-data-based-on-2-different-cells-2-columns-different-sheets-grading-excel-form
Sheet: T2 PD

First name | Surname | ID number | Institution | Department | Email address | Assignment: Professionalism | Attendance: Attendance | Assignment: Location | Assignment: Look Book | Assignment: Greeking | Assignment: [NAME] | Assignment: Ageing | Course total
[NAME] ([NAME]) | [NAME] |  |  |  | [EMAIL] | 90 | 100 | 64 | 100 | 90 | 100 | 100 | 92.9
Qiran ([NAME]) | [NAME] |  |  |  | [EMAIL] | 75 | 50 | 24 | 64 | 0 | 100 | 0 | 43.25
Muxin | [NAME] |  |  |  | [EMAIL] | 85 | 78.57 | 84 | 76 | 80 | 100 | 100 | 86.41
[NAME] ([NAME]) | [NAME] |  |  |  | [EMAIL] | 90 | 92.86 | 84 | 92 | 90 | 100 | 100 | 92.99
Yiming ([NAME]) | [NAME] |  |  |  | [EMAIL] | 90 | 85.71 | 36 | 76 | 90 | 100 | 100 | 85.07
[NAME] ([NAME]) | Fang |  |  |  | [EMAIL] | 90 | 100 | 56 | 64 | 90 | 100 | 100 | 86.7
Qianyun (Fay) | Fang |  |  |  | [EMAIL] | 90 | 92.86 | 84 | 84 | 80 | 100 | 100 | 89.79
Yichao | Fu |  |  |  | [EMAIL] | 85 | 100 | 68 | 76 | 100 | 100 | 100 | 90.95
Junjie (Riol) | He |  |  |  | [EMAIL] | 90 | 100 | 76 | 84 | 90 | 100 | 100 | 91.7
Jiaqing (Agnes) | Kang |  |  |  | [EMAIL] | 75 | 85.71 | 48 | 84 | 0 | 0 | 0 | 37.22
Yuetong (Isabel) | [NAME] |  |  |  | [EMAIL] | 90 | 100 | 72 | 84 | 80 | 100 | 100 | 89.3
[NAME]) | [NAME] |  |  |  | [NAME] | 85 | 85.71 | 76 | 72 | 90 | 100 | 100 | 87.72
[NAME] (Klader) | [NAME] |  |  |  | [EMAIL] | 80 | 92.86 | 92 | 92 | 80 | 100 | 100 | 90.29
Ruimin (Vic) | [NAME] |  |  |  | [EMAIL] | 75 | 78.57 | 36 | 0 | 0 | 0 | 0 | 22.71
[NAME]) | [NAME] |  |  |  | [EMAIL] | 80 | 92.86 | 12 | 24 | 0 | 0 | 100 | 41.09
[NAME]Seven ） | Qi |  |  |  | [EMAIL] | 85 | 85.71 | 68 | 76 | 70 | 100 | 100 | 83.52
Junqi (Voang) | [NAME] |  |  |  | [EMAIL] | 85 | 100 | 48 | 52 | 90 | 100 | 100 | 83.35
[NAME]） | Xiao |  |  |  | [EMAIL] | 90 | 92.86 | 76 | 92 | 90 | 100 | 100 | 92.19
[NAME] (Leo) | [NAME] |  |  |  | [EMAIL] | 80 | 85.71 | 76 | 76 | 80 | 100 | 100 | 85.57
Chenyi (Freddie) | Zhang |  |  |  | [EMAIL] | 85 | 85.71 | 56 | 0 | 80 | 100 | 100 | 72.92
Linfeng (Wayne) | Zhang |  |  |  | [EMAIL] | 85 | 100 | 68 | 84 | 90 | 100 | 100 | 90.15
[NAME] (Vlad) | [NAME] |  |  |  | [EMAIL] | 90 | 100 | 56 | 92 | 80 | 100 | 100 | 88.9
Xinwei (Will) | [NAME] |  |  |  | [EMAIL] | 90 | 100 | 92 | 84 | 90 | 100 | 100 | 93.3
Hui ([NAME]) | Zhu |  |  |  | [EMAIL] | 80 | 100 | 68 | 84 | 80 | 100 | 100 | 87.4
Spreadsheet: 84325ddd-b40e-44e2-b40e-80b61a8c56a9
Sheet: Sheet1

Unnamed: 0 | Unnamed: 1 | Unnamed: 2 | LỊCH CÔNG TÁC KHOA | Unnamed: 4 | Unnamed: 5
 |  |  | TUẦN 14 (05/12 -11/12/2011)
Thứ, ngày | Giờ | Nội dung công việc | Cán bộ  chủ trì | Cán bộ cùng thực hiện/ cùng tham dự | [NAME] điểm
Thứ Hai 14/11
 | 10h00 | Tổ chức đăng ký và bốc thăm lịch thi đấu bóng bàn | [NAME] | Thầy Dũng | Phòng 210 B
 | 14h00
[NAME] 15/11 | 8h30 | Họp giao ban tháng 12/2011 | [NAME] | [NAME], [NAME] | PH1
Thứ Tư 16/11
 | 18h00 | Dự giờ giảng dạy Cô Hương A (môn PP phân tích CNSH hiện đại) | T. Nam | [NAME] và các giảng viên thuộc BM CNSH | 309
[NAME]
Thứ Sáu 18/11
 | 14h00 | Hội nghị [NAME] công tác Đoàn - Hội và Phong trào  Thanh niên năm học 2010 - 2011 | [NAME] | T. Hưng | HT1 lầu 6
Thứ Bảy 19/11
[NAME] 20/11
Ghi chú: |  |  |  | TP. HCM, ngày 4 tháng 12 năm 2011
 |  |  |  | [NAME]
Spreadsheet: 147930d1333039358-data-validation-and-vlookup-counts
Sheet: Nurse Practitioner-1250

Nurse Practitioner: | 1250
Job Title | Count |  | Employed Type | Count
None | 121 |  | Independent - Retail | 68
NP-C | 1 |  | Chain - Retail | 6
aAdult NP C | 1 |  | Hospital | 121
AANP | 1 |  | Consultant | 8
ACNP | 9 |  | Institutional - Other | 89
ACNP, BC, PhD | 1 |  | Retired | 2
ACNP, MSN | 1 |  | Unemployed | 8
ACNP,BC | 1
ACNP-BC | 3
ACNP-BC, MSN | 1
ACNP-C | 1
Acute Care NP | 1
ADVANCED NURSE PRACTITIONER | 1
Advanced Practice Nurse | 1
Advanced Registered Nurse Practitioner | 1
AjKRqrllLxhQ | 1
ANP | 17
anp, gnp | 1
ANP-A | 1
ANP-BC | 3
ANP-C | 3
APMHCNS-BC, DNP | 1
APN | 16
APN-BC | 2
APN-C | 3
APN-S | 1
APNC | 1
APNP | 1
APRN | 34
APRN FNP-BC | 1
APRN, ANP-BC | 1
APRN, FNP | 1
APRN, NP-C | 1
APRN,APNP | 1
APRN-BC | 2
APRN-Psych | 1
arnp | 84
ARNP, FNP-C | 1
ARNP, MS | 1
ARNP., BC | 1
BC-FNP, RN | 1
BSN, RN | 1
BSNRNP | 1
C-FNP | 3
C-NP | 1
C.R.N.P. | 1
CFNP | 10
CFNP,BC | 1
Clinical Nurse Specialist | 1
CNM | 9
CNM CNP | 1
CNM, MSN | 1
CNM, PhD | 1
CNM, WHCNP, MSN | 1
CNOR | 1
CNP | 23
CNP, RN | 1
CNS | 2
CNS, APN | 1
cpht, rn, fnp | 1
CPNP | 2
crna | 2
CRNA, ARNP, MSNA | 1
CRNA, PhD | 1
CRNFA | 1
crnp | 71
CRNP, MSN | 1
crnp- bc | 1
CRNP-OB/Gyn, | 1
CS-FNP | 1
dental assistant | 1
DNP | 1
DNP, APRN-BC, FNP | 1
DNP, CRNP | 1
Dr. | 1
Dr. CRNP | 1
EdD, ARNP | 1
Family Nurse Practitioner | 3
FNP | 128
FNP BC | 1
FNP, | 1
FNP, BC | 1
FNP, CNM | 1
FNP, MFT | 1
FNP,MSN | 1
FNP-BC | 19
FNP-BC` | 1
FNP-C | 13
FNP-C MPH | 1
FNP_BC | 1
FNPC | 1
fnps | 1
GNP | 2
GNP-BC | 1
Instructor | 1
LPN | 3
LVN | 1
MN, PNP | 1
MS ANP-C | 1
MS RN | 1
MS, RN, ANP, BC | 1
msn | 1
MSN APN-BC | 1
MSN CRNP | 1
MSN FNP | 1
MSN, APNP | 1
MSN, CNP | 1
MSN, CRNP | 2
MSN, FNP | 2
MSN, FNP-BC | 2
MSN, PNP | 1
MSN, RNC-OB, APN/CNP, WHNP-BC, IBCLC, RLC | 1
MSN,RN,ACNP-BC,WCC | 1
MSN,RN,NP-C | 1
N.P. | 1
NNP | 2
NNP-BC | 1
NP | 194
NP-BC, APRN | 1
NP-C | 14
NPC | 1
nurse practioner | 1
Nurse Practitioner | 10
PharmD | 1
PhD, ANP-BC | 1
PNP-BC | 1
Public Health Manager | 1
qGMJStblZuAQWYmwZ | 1
R.N, N.P | 1
R.N., A.N.P. | 1
RN | 243
RN np | 1
RN ,APN, BC | 1
RN ACNP | 1
RN ANP | 1
RN APN | 1
RN CFNP | 1
RN CNP | 2
RN CRNP | 2
RN CS-FNP | 1
RN FNP | 1
RN FNP-C | 1
RN MSN FNP | 1
rn np | 2
RN, ACNP | 1
RN, ANP | 1
RN, APN | 2
RN, APRN | 1
RN, APRN, FNP-C | 1
RN, ARNP | 2
RN, CFNP | 1
RN, CNM | 1
rn, cnp | 3
RN, CNS | 2
RN, CNS-BC | 1
RN, CRNP | 3
RN, FNP | 11
RN, FNP, BC | 1
RN, FNP, DrPH | 1
RN, FNP-BC | 5
RN, FNP-C | 5
RN, GNP | 1
RN, GNP-BC | 1
RN, MSN | 2
RN, MSN, ANP | 1
RN, MSN, APRN, ACNP-BC | 1
RN, MSN, CNP | 1
RN, MSN, CRNP | 1
RN, MSN, FNP-C | 1
RN, MSN, OCN, FNP-BC | 1
RN, NNP-BC | 1
RN, NP | 4
RN, NP Student | 1
RN, NP-C | 1
RN,FNP | 1
RN,FNP-C | 1
RN,MS,CS | 1
RN,MSN, CRNP | 1
RN,MSN,APRN | 1
RN,MSN,NP-C | 1
RN. FNP | 1
RN/NP | 1
RNC, NNP, Pharm D | 1
RNC, WHNP | 1
RNC-FNP | 1
RNCNP | 1
RNP | 4
RPH | 1
WHNP | 1
WHNP, BC | 1
WHNP-BC | 3
Spreadsheet: 89403d1289212839-make-dropdown-list-without-repeated-value-question
Sheet: Sheet1

A1 |  |  |  | I want to take dropdown from list, must not type manually because there are many value in my table
B2 |  |  | [NAME] | Dropdown Should be Like this | Not like this that have value repeated
A3 |  |  |  | A1 | A1
B1 |  |  |  | A2 | B2
B1 |  |  |  | A3 | A3
B4 |  |  |  | A4 | B1
B3 |  |  |  | B1 | B1
A4 |  |  |  | B2 | B4
A1 |  |  |  | B3 | B3
B4 |  |  |  | B4 | A4
A3 |  |  |  |  | A1
B3 |  |  |  |  | B4
B2 |  |  |  |  | A3
A2 |  |  |  |  | B3
A4 |  |  |  |  | B2
A2 |  |  |  |  | A2
 |  |  |  |  | A4
 |  |  |  |  | A2
 |  |  | Why it is 10 there? How the excel calculate it to 10 (COUNTIF($A$1:$A$16,"<"&$A2))
Spreadsheet: vkaminski__40908__Raptor 3b
Sheet: Credit Analysis

Subsequent Credit Analysis
Raptor 3
Date | 2001-01-29 00:00:00
Rates |  | Full Monetization | Monetize 30MM | No Monetization
$50MM N/R | 0.07
$50MM N/P | 0.075
$259MM N/P | 0.0725
TNPC Screen | 9.75 | 15.42372177175631 | 9.81124244931266 | 9.099177499795088
Porcupine Balance Sheet
 | As of
Assets |  |  | Liabilities + Equity
Cash |  |  | Note Payable | 0
[NAME] |  |  | Note Payable
Note from ENE |  |  | Derivative Payable
Derivative Rec. |  |  | Minority Interest
 |  |  | LJM
 |  |  | ENE
Equity Rollforward
ENE Capital @ IPO
LJM Capital @ IPO
MI Capital @ IPO
Total Capital @ IPO
Plus Gain on TNPC Stock
Plus Derivative Gain/Loss
Less Net Interest Expense
Current Capital
Less ENE Capital
LJM Capital
MI Capital
Check
Credit Test
Value of Assets
Less:
Note Payable
Other Note
Minority Interest
Derivative
3% Test
Bal Sheet Foot
Plus:  Fees Paid By Enron
Less: 3rd Party Equity
Net
Req'd Equity %
[NAME]
Actual Equity
Excess Equity
Notional Capacity
Less Notional Hedged
Unused Capacity
Spreadsheet: 07141166-52fd-45bd-9b1b-682853940a2d
Sheet: 3ED OUT OF 61

ANON# | RANK
10873 | 8
11193 | 4
13910 | 13
16560 | 3
18496 | 11
25578 | 12
28547 | 2
28796 | 7
34618 | 6
36598 | 10
65308 | 14
73555 | 15
76835 | 5
77437 | 1
95821 | 9
Spreadsheet: 93409d1292986305-how-do-i-sum-up-all-cells-in-different-sheets-to-a-cell-in-sheet1-timesheet-1-
Sheet: Sheet1

Job Number | Job Name |  | [NAME] | [NAME] | Total
00Gen | General
00Holiday | Holiday/Vacation
00Sick | Sickness
9037 | [NAME]
9038 | Suny Radioactive
9046 | [NAME]
10010 | Public Theater
10025 | Project Trio
10033 | Aeropostale
10039 | Harbor Point
10045 | Lodewick/Spadaro
10048 | 44 West 18th St
10052 | Barclay's Capital
Spreadsheet: 876103d1722770388-match-function-maartenro-compare-numbers-aligw
Sheet: Blad2

sample 1 | sample 2 | sample 1 in sample 2
621339875 | 81827262
621339875 | [PHONE]
89200435 | [PHONE]
89200435 | 185177124194
81827262 | 185177124100
Spreadsheet: sally_beck__36212__Weekly Operating Report 5-30
Sheet: Weekly Report

Principal Projects / Deals: |  |  |  |  |  |  |  |  | New Deals |  |  |  |  |  |  |  | Traded Volume for Physical New Deals
Operational Risk: |  |  |  |  |  |  |  |  | 4/26-5/2 | 5/3-5/9 | 5/10-5/16 | 5/17-5/23 | 5/24-5/30 | Total |  |  | 4/26-5/2 | 5/3-5/9 | 5/10-5/16 | 5/17-5/23 | 5/24-5/30 | Total
 |  |  |  |  |  |  |  | EA |  |  |  |  |  |  |  | EA (in millions)
-  AEP transition work was the priority this week due to June 1 transition. |  |  |  |  |  |  |  | Gas |  |  |  |  | 17677 |  |  | Gas (MMBTU) |  |  |  |  | 5240
 |  |  |  |  |  |  |  | Power |  |  |  |  | 4845 |  |  | Power (MHtz) |  |  |  |  | 80
-  Unify testing being finalized; dry run conversion this weekend, on track for |  |  |  |  |  |  |  | % of EA from EOL |  |  |  |  | 0.77 |  |  | EGM (in thousands)
 | going live June 8. |  |  |  |  |  |  | EGM |  |  |  |  |  |  |  | Liquids (BBL) |  |  |  |  | 169988
 |  |  |  |  |  |  |  | IR/FX |  |  |  |  | 357 |  |  | Coal (Tonne) |  |  |  |  | 285
- Progress on Operational DPR Reporting. |  |  |  |  |  |  |  | Liquids |  |  |  |  | 2999 |  |  | Emissions (Contracts) |  |  |  |  | 15
 |  |  |  |  |  |  |  | Coal |  |  |  |  | 13 |  |  | EIM ([NAME])
-  Agreed review process for Merchant Portfolio with Commercial and RAC. |  |  |  |  |  |  |  | Weather |  |  |  |  | 15 |  |  | Newsprint |  |  |  |  | 2660
 |  |  |  |  |  |  |  | Emissions |  |  |  |  | 6 |  |  | Pulp |  |  |  |  | 23943
-  Working on Seoul SK Gas joint venture issue with the Global Assets |  |  |  |  |  |  |  | % of EGM from EOL |  |  |  |  | 0.43 |  |  | Lumber |  |  |  |  | 17176
 | Team. |  |  |  |  |  |  | EIM |  |  |  |  |  |  |  | Steel |  |  |  |  | 5586
 |  |  |  |  |  |  |  | Newsprint |  |  |  |  | 19
- Held 1st of three RAC / Risk Management meetings to review risk policy |  |  |  |  |  |  |  | Pulp |  |  |  |  | 22 |  |  |  | New Counterparties
 | and other risk aggregation issues. |  |  |  |  |  |  | Lumber |  |  |  |  | 90 |  |  |  | 4/26-5/2 | 5/3-5/9 | 5/10-5/16 | 5/17-5/23 | 5/24-5/30
 |  |  |  |  |  |  |  | Steel |  |  |  |  | 0 |  |  | E-Commerce | 11 | 6 | 7 | 7 | 4
 |  |  |  |  |  |  |  | % of EIM from EOL |  |  |  |  | 0.02
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | Non E-Commerce | 137 | 242 | 263 | 173 | 146
Spreadsheet: 30730d1226417722-auto-sum-a-varying-range-sample
Sheet: Reconcile

Vendor Name: | Any Vendor
Vendor #: | 015132
PO #: | B0093409 Chicago
Date: | 2008-10-10 00:00:00
[NAME]# | Vendor part # | PP | CAPA | Qty ordered | Qty confirmed | Invoice Qty | Qty Diff | Confirmed price | Invoice Price | Price Diff | AVAILABLE DATE | CUBF | Description
RAD019 | 19-A |  |  | 25 | 25 | 25 | 0 | 0 | 0 | 0
RAD1303 | 1303-A |  |  | 5 | 5 | 0 | 5 | 0 | 0 | 0
RAD1409 | 1409-A |  |  | 10 | 10 | 10 | 0 | 0 | 0 | 0
RAD1451 | 1451-A |  |  | 10 | 10 | 10 | 0 | 0 | 0 | 0
RAD1474 | 1474-A |  |  | 10 | 10 | 10 | 0 | 0 | 0 | 0
RAD1482 | 1482-A |  |  | 20 | 20 | 20 | 0 | 0 | 0 | 0
RAD1488 | 1488-A |  |  | 5 | 5 | 5 | 0 | 0 | 0 | 0
RAD1533 | 1533-A |  |  | 5 | 5 | 5 | 0 | 0 | 0 | 0
RAD161 | 161-A |  |  | 6 | 6 | 6 | 0 | 0 | 0 | 0
RAD162 | 162-A |  |  | 5 | 5 | 1 | 4 | 0 | 0 | 0
RAD1755 | 1755-A |  |  | 10 | 10 | 10 | 0 | 0 | 0 | 0
RAD1774 | 1774-A |  |  | 10 | 10 | 10 | 0 | 0 | 0 | 0
RAD1831 | 1831-A |  |  | 5 | 5 | 5 | 0 | 0 | 0 | 0
RAD1850 | 1850-A |  |  | 70 | 70 | 70 | 0 | 0 | 0 | 0
RAD1862 | 1862-A |  |  | 5 | 5 | 5 | 0 | 0 | 0 | 0
[NAME] | 1905-A |  |  | 25 | 25 | 25 | 0 | 0 | 0 | 0
RAD1912 | 1912-A |  |  | 5 | 5 | 0 | 5 | 0 | 0 | 0
RAD1994 | 1994-A |  |  | 5 | 5 | 5 | 0 | 0 | 0 | 0
RAD1995 | 1995-A |  |  | 15 | 15 | 15 | 0 | 0 | 0 | 0
RAD2023 | 2023-A |  |  | 5 | 5 | 0 | 5 | 0 | 0 | 0
RAD2075 | 2075-A |  |  | 10 | 10 | 0 | 10 | 0 | 0 | 0
RAD2139 | 2139-A |  |  | 5 | 5 | 5 | 0 | 0 | 0 | 0
RAD2171 | 2171-A |  |  | 20 | 20 | 20 | 0 | 0 | 0 | 0
[NAME] | 2172-A |  |  | 8 | 8 | 8 | 0 | 0 | 0 | 0
RAD2173 | 2173-A |  |  | 30 | 30 | 30 | 0 | 0 | 0 | 0
RAD2184 | 2184-A |  |  | 40 | 40 | 40 | 0 | 0 | 0 | 0
RAD2195 | 2195-A |  |  | 10 | 10 | 10 | 0 | 0 | 0 | 0
RAD2198 | 2198-A |  |  | 15 | 15 | 0 | 15 | 0 | 0 | 0
[NAME] | 2256-A |  |  | 10 | 10 | 10 | 0 | 0 | 0 | 0
RAD2261 | 2261-A |  |  | 10 | 10 | 10 | 0 | 0 | 0 | 0
[NAME] | 2305-A |  |  | 20 | 20 | 20 | 0 | 0 | 0 | 0
RAD2323 | 2323-A |  |  | 30 | 30 | 30 | 0 | 0 | 0 | 0
[NAME] | 2327-A |  |  | 3 | 3 | 3 | 0 | 0 | 0 | 0
RAD2329 | 2329-A |  |  | 20 | 20 | 20 | 0 | 0 | 0 | 0
RAD2363 | 2363-A |  |  | 20 | 20 | 20 | 0 | 0 | 0 | 0
RAD2387 | 2387-A |  |  | 40 | 40 | 40 | 0 | 0 | 0 | 0
RAD2410 | 2410-A |  |  | 20 | 20 | 15 | 5 | 0 | 0 | 0
RAD2412 | 2412-A |  |  | 10 | 10 | 10 | 0 | 0 | 0 | 0
RAD2434 | 2434-A |  |  | 20 | 20 | 20 | 0 | 0 | 0 | 0
RAD618 | 618-A |  |  | 20 | 20 | 20 | 0 | 0 | 0 | 0
RAD622 | 622-A |  |  | 20 | 20 | 20 | 0 | 0 | 0 | 0
RAD681 | 681-A |  |  | 9 | 9 | 9 | 0 | 0 | 0 | 0
RAD705 | 705-A |  |  | 8 | 8 | 8 | 0 | 0 | 0 | 0
RAD767 | 767-A |  |  | 20 | 20 | 20 | 0 | 0 | 0 | 0
RAD886 | 886-A |  |  | 5 | 5 | 5 | 0 | 0 | 0 | 0
RAD945 | 945-A |  |  | 8 | 8 | 8 | 0 | 0 | 0 | 0
RAD1553 | 1553-A |  |  | 20 | 0 | 0 | 0 | 0 | 0 | 0
RAD2401 | 2401-A |  |  | 12 | 0 | 0 | 0 | 0 | 0 | 0
 |  |  |  | 719 | 687 | 638
Spreadsheet: 861756d1709592058-how-to-calculate-the-difference-between-values-with-columns-of-different-codes-example-1
Sheet: Sheet1

FAC IND | OPPS CAP IND | PROC CODE | MODIFIER | FEE | NON PAR FEE | LC |  |  | PROC CODE | MODIFIER | FEE |  | PROC CODE | MODIFIER | FEE | NON PAR FEE | LC | FEE.1 | Subtraction
 |  | 10004 |  | 57.64 | 54.76 | 62.97 |  |  | 10004 |  | 133 |  | 10004 |  | 57.64 | 54.76 | 62.97 | 133 | 78.24000000000001
 |  | 10005 |  | 150.72 | 143.18 | 164.66 |  |  | 10005 |  | 320 |  | 10005 |  | 150.72 | 143.18 | 164.66 | 320 | 176.82
 |  | 10006 |  | 65.76 | 62.47 | 71.84 |  |  | 10006 |  | 152 |  | 10006 |  | 65.76 | 62.47 | 71.84 | 152 | 89.53
 |  | 10007 |  | 347.4 | 330.03 | 379.53 |  |  | 10007 |  | 722 |  | 10007 |  | 347.4 | 330.03 | 379.53 | 722 | 391.97
 |  | 10008 |  | 159.77 | 151.78 | 174.55 |  |  | 10008 |  | 407 |  | 10008 |  | 159.77 | 151.78 | 174.55 | 407 | 255.22
 |  | 10009 |  | 489.04 | 464.59 | 534.28 |  |  | 10009 |  | 1181 |  | 10009 |  | 489.04 | 464.59 | 534.28 | 1181 | 716.4100000000001
 |  | 10010 |  | 267.71 | 254.32 | 292.47 |  |  | 10010 |  | 712 |  | 10010 |  | 267.71 | 254.32 | 292.47 | 712 | 457.68
 |  | 10021 |  | 113.99 | 108.29 | 124.53 |  |  | 10021 |  | 350 |  | 10021 |  | 113.99 | 108.29 | 124.53 | 350 | 241.71
 |  | 10030 |  | 728.8 | 692.36 | 796.21 |  |  | 10021 | 26 | 192 |  | 10021 |  | 113.99 | 108.29 | 124.53 | 192 | 83.71
 |  | 10035 |  | 414.28 | 393.57 | 452.61 |  |  | 10030 |  | 2247 |  | 10030 |  | 728.8 | 692.36 | 796.21 | 2247 | 1554.64
 |  | 10036 |  | 341.59 | 324.51 | 373.19 |  |  | 10035 |  | 1356 |  | 10035 |  | 414.28 | 393.57 | 452.61 | 1356 | 962.4300000000001
 |  | 10040 |  | 132.51 | 125.88 | 144.76 |  |  | 10036 |  | 1178 |  | 10036 |  | 341.59 | 324.51 | 373.19 | 1178 | 853.49
 |  | 10060 |  | 143.99 | 136.79 | 157.31 |  |  | 10040 |  | 236 |  | 10040 |  | 132.51 | 125.88 | 144.76 | 236 | 110.12
 |  | 10061 |  | 241.45 | 229.38 | 263.79 |  |  | 10060 |  | 251 |  | 10060 |  | 143.99 | 136.79 | 157.31 | 251 | 114.21
 |  | 10080 |  | 288.74 | 274.3 | 315.45 |  |  | 10061 |  | 482 |  | 10061 |  | 241.45 | 229.38 | 263.79 | 482 | 252.62
 |  | 10081 |  | 392.55 | 372.92 | 428.86 |  |  | 10080 |  | 406 |  | 10080 |  | 288.74 | 274.3 | 315.45 | 406 | 131.7
 |  | 10120 |  | 173.64 | 164.96 | 189.7 |  |  | 10081 |  | 675 |  | 10081 |  | 392.55 | 372.92 | 428.86 | 675 | 302.08
 |  | 10121 |  | 298.65 | 283.72 | 326.28 |  |  | 10120 |  | 336 |  | 10120 |  | 173.64 | 164.96 | 189.7 | 336 | 171.04
 |  | 10140 |  | 192.69 | 183.06 | 210.52 |  |  | 10121 |  | 583 |  | 10121 |  | 298.65 | 283.72 | 326.28 | 583 | 299.28
 |  | 10160 |  | 146.96 | 139.61 | 160.55 |  |  | 10140 |  | 390 |  | 10140 |  | 192.69 | 183.06 | 210.52 | 390 | 206.94
 |  | 10180 |  | 298.56 | 283.63 | 326.17 |  |  | 10160 |  | 310 |  | 10160 |  | 146.96 | 139.61 | 160.55 | 310 | 170.39
 |  |  |  |  |  |  |  |  |  |  |  |  | 10180 |  | 298.56 | 283.63 | 326.17
Spreadsheet: sally_beck__33742__update for MF
Sheet: Sheet1

Office | Number of observations | Closed observations | Open observations with target date after 8/4/00 | Open observations having missed target date | Item that missed target date
[NAME] | 10 | 8 | 1 | 1 | 6 contracts still awaiting translation to English - someone has been hired to do all translations.
Calgary | 9 | 6 | 3
Frankfurt | 10 | 8 |  | 2 | Taping telephone lines, ability to produce geographical P&L
Helsinki | 7 | NA | NA | NA
[NAME] I | 23 |  | 10 | 1 | Taping of mobile phones
London Phase II | 25 |  | 13 | 2 | Deal info on credit deal tickets not always complete, master agreements not always in place
Oslo | 9 | 8 |  | 1 | Translation of contracts into English
Sao Paulo | 7 | 4 | 1 | 2 | Translation of older, settled contracts into English, Cuiba positions not centrally managed with golbal crude oil positions.
Seoul | 2 |  | 2
Singapore | 6 | 5 |  | 1 | Use of mobile phones to make trades.
Sydney | 6 | 6
Global issues
Taping of phone lines (cost issue)
Use of mobile phones (should there be a ban on use of mobile phones as most are impossible to tape?)
Translations of settled contracts (all active and new contracts translated but do no one has performed translations of settled contracts)
Use of Enpower - is it required for all power trading offices or only ones with critical mass?
Spreadsheet: 157077d1337612086-offset-doesnt-work-test
Sheet: 2

2012-04-01 00:00:00
2012-04-02 00:00:00 |  | 6 | 6
2012-04-03 00:00:00
2012-04-04 00:00:00
2012-04-08 00:00:00 |  | 1 | 1
2012-04-06 00:00:00 | 5 | 1
2012-05-01 00:00:00 | 6 | 1
2012-04-08 00:00:00 | 7 | 11
2012-04-09 00:00:00 |  | 12
2012-04-10 00:00:00 |  | 1 | 1
2012-05-02 00:00:00 |  | 1 | 1
2012-04-12 00:00:00
2012-04-13 00:00:00
2012-04-14 00:00:00 |  | 1 | 1
2012-04-15 00:00:00 | 2 | 12
2012-04-16 00:00:00 | 5 | 1
2012-04-17 00:00:00 |  | 2 | 2
2012-04-18 00:00:00 |  | 10 | 10
2012-04-19 00:00:00 |  | 1 | 1
Spreadsheet: 250191d1373864106-condition-formatting-for-a-negative-number-considers-it-still-positive-wow-characters
Sheet: Shivme

Item |  | [NAME] | steamed crab surprise | mogu fish | mad brew | sea mist | black pep | Banq grill | [NAME]. Pot | [NAME] | Eternal Blossom Fish | braised turtle | Fire Spirit Salmon | Valley Stir Fry | Charbroiled [NAME] | swirling mist soup | Shrimp Dumplings | Twin Fish Platter
 |  |  |  |  |  |  |  | 5 | 5 | 5
 |  |  |  | 1 | 1 |  | 1
 |  |  |  | 5 |  |  |  |  |  | 60 |  |  | 10
 |  |  |  |  |  |  | 5 |  |  |  |  |  |  |  |  |  | 20
 |  |  |  |  |  |  | 25
 |  |  |  |  |  |  |  |  |  |  | 10 |  |  |  |  | 10
 |  |  |  |  |  |  |  |  |  | 300
 |  |  | 5
 |  |  |  |  |  |  |  |  | 300 |  |  | 50
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 10
 |  |  |  | 25
 |  |  |  |  |  |  | 5 |  | 60
 |  |  |  |  | 50
 |  |  | 5 |  |  |  |  | 60
 |  |  |  | 5
 |  | 5 |  |  |  |  |  |  |  |  |  |  |  |  | 20
 |  |  |  |  |  | 5 |  |  |  |  |  | 10
 |  | 25
 |  | 5 |  |  |  |  |  | 60
 |  |  |  |  |  |  |  |  | 60 |  |  |  |  | 10
 |  | 1 | 1 |  |  | 1
 |  |  |  |  |  | 25 |  |  |  |  |  |  | 50
 |  |  |  |  |  |  |  |  |  |  | 50
 |  |  |  |  |  | 5
 |  |  | 25 |  |  |  |  | 300
 |  |  |  |  |  |  |  |  |  | 60 |  |  |  | 10
Spreadsheet: 99620d1298237518-vlookup-over-multiple-tabs-sheets-fundraising-1-
Sheet: Overzicht

algemeen nr
1 | [NAME] | test1 | tes2 | test3 | test4 | test5 | 0
2 | [NAME] | 0 | 0 | 0 | 0 | 0 | 0
3 | oost1 | 0 | 0 | 0 | 0 | 0 | 0
4 | [NAME] | 0 | 0 | 0 | 0 | 0 | 0
5 | west1 | 123 | no | asdgagdsahah'ja'j'ajd'g;jajsg'jadnangnangl;nal;gnlanglag | ddddddddddddddddddddddddddddd | wweweeeeeeeeewewewewewewewewe | 0
6 | limburg2 | 0 | 0 | 0 | 0 | 0 | 0
7 | brabant2 | imec | 10000 euro | [NAME] | blab | blob | [NAME]
8 | brabant3 | jsdkf | fgkls | sdhfg | ksgj | 0 | 0
9
 | enter formula in B2, drag down and sideways.