tianzl66/Sheetpedia huggingface dataset:
Spreadsheet: 48763d1248070151-duplicate-contacts-find-contacts-list
Sheet: MY REQUIREMENT

SR# | NAME | CONTACT | COUNT | DUPLICATE IN CELL #
1 | [NAME] | 2023794 | 1
2 | [NAME] | 2296395 | 1
3 | [NAME] (Piyare Bhai) | 2683573 | 1
4 | [NAME] | 32034616 | 1
5 | [NAME] | 367694 | 1
6 | [NAME] | 3262150 | 1
7 | [NAME] | 3608799 | 1
8 | [NAME] | 3325486 | 1
9 | [NAME] | 2618619 | 1
10 | [NAME] | 3049473 | 1
11 | [NAME] | 2147912 | 1
12 | [NAME] | 8934402 | 1
13 | [NAME] | 2270542 | 2 | C30
15 | Adil Ur Rehman | 8286957 | 1
16 | Akaber Shah | 900020 | 1
17 | [NAME] | 2783034 | 1
18 | [NAME] | 2054712 | 1
19 | [NAME] | 3878251 | 1
20 | [NAME] | 3325547 | 1
21 | [NAME] | 2395135 | 1
22 | [NAME] | 3992688 | 1
23 | Ashfaq Pai wala | 2172049 | 1
24 | [NAME] | 2475374 | 1
25 | [NAME] | 37452594 | 1
26 | [NAME] | 2539729 | 1
27 | [NAME] | 2270542 | 2 | C17
28 | Farooq Amjad | 2495998 | 1
29 | [NAME] ([NAME]) | 2451934 | 1
32 | [NAME] | 2174518 | 1
33 | [NAME] | 2955655 | 1
34 | [NAME] | 2516947 | 1
35 | [NAME] [NAME] | 2027995 | 1
36 | [NAME] | 3946635 | 1
37 | [NAME] | 2296642 | 1
38 | Ibrahim | 2133405 | 1
39 | [NAME] | 2584659 | 1
40 | [NAME] | 8914168 | 1
41 | [NAME] | 2505947 | 1
42 | [NAME] | 3399237 | 1
43 | [NAME] | 3479404 | 1
44 | [NAME] | 2839958 | 1
45 | [NAME] | 2346921 | 1
46 | Javed Manzoor | 2533293 | 1
47 | [NAME] | 383913 | 1
48 | [NAME] | 6729381 | 1
49 | [NAME] | 2106907 | 1
50 | [NAME] | 2050558 | 1
51 | [NAME] | 2732794 | 1
52 | [NAME] | 2638730 | 1
53 | [NAME] | 2506290 | 1
54 | [NAME] | 2553513 | 1
55 | Manzoor Ellahi | 2489938 | 1
56 | [NAME] | 2318794 | 1
57 | Mehmood | 2158231 | 1
58 | [NAME] | 2158031 | 1
59 | [NAME] | 2808435 | 1
60 | [NAME] | 2450021 | 1
61 | [NAME] | 892216 | 1
62 | [NAME] | 2063986 | 1
63 | [NAME] | 308625 | 1
64 | [NAME] | 3513657 | 1
65 | [NAME] | 3995487 | 1
66 | [NAME] | 3312816 | 1
67 | [NAME] | 8700232 | 1
68 | [NAME] | 9206428 | 1
69 | [NAME] | 2664494 | 1
70 | [NAME] | 9229486 | 1
71 | [NAME] | 2298210 | 1
73 | [NAME] | 2620613 | 1
74 | [NAME] farhan | 2096078 | 1
75 | [NAME] | 2988624 | 1
76 | [NAME] | 2345534 | 1
77 | [NAME] | 3858307 | 1
78 | [NAME] | 3480545 | 2 | C82
79 | [NAME] | 3714943 | 1
80 | [NAME] | 2019393 | 1
81 | [NAME] | 2220838 | 1
82 | [NAME] | 3480545 | 2 | C78
83 | [NAME] | 3813817 | 1
129 | [NAME] | 2287319 | 1
130 | [NAME] | 9274091 | 4 | C95 , C96 , C99
131 | [NAME] Polish wala | 9223550 | 1
132 | [NAME] | 2181782 | 1
133 | Ronaq [NAME] | 2616635 | 1
134 | Saadat Bhai | 2127441 | 1
135 | [NAME] | 2368510 | 1
136 | [NAME] | 3140881 | 1
137 | [NAME] | 2620224 | 1
138 | Sajid Majeed | 2701141 | 1
139 | [NAME] | 2135513 | 1
140 | [NAME] | 9274091 | 4 | C85 , C96 , C99
141 | [NAME] | 9274091 | 4 | C85 , C95 , C99
142 | Shahnawaz | 5004251 | 1
143 | [NAME] | 8724469 | 1
144 | Shakeel Pan wala | 9274091 | 4 | C85 , C95 , C96
145 | [NAME] | 2118925 | 1
Spreadsheet: 268528d1380667045-average-last-three-number-with-vlookup-example-excel-sheet
Sheet: Data

Name | Date | Amount
A | 2013-10-01 00:00:00 | 24
A | 2013-10-02 00:00:00 | 7
A | 2013-10-03 00:00:00 | 12
A | 2013-10-04 00:00:00 | 48
A | 2013-10-05 00:00:00 | 9
A | 2013-10-06 00:00:00 | 19 |  | Actual Last 3 Average
A | 2013-10-07 00:00:00 | 26
B | 2013-10-01 00:00:00 | 24
B | 2013-10-02 00:00:00 | 2
B | 2013-10-03 00:00:00 | 3
B | 2013-10-04 00:00:00 | 37
B | 2013-10-05 00:00:00 | 30
B | 2013-10-06 00:00:00 | 34
B | 2013-10-07 00:00:00 | 34
B | 2013-10-08 00:00:00 | 42 |  | Actual Last 3 Average
B | 2013-10-09 00:00:00 | 33
C | 2013-10-01 00:00:00 | 13
C | 2013-10-02 00:00:00 | 37
C | 2013-10-03 00:00:00 | 6
C | 2013-10-04 00:00:00 | 23
C | 2013-10-05 00:00:00 | 46
C | 2013-10-06 00:00:00 | 24
C | 2013-10-07 00:00:00 | 24
C | 2013-10-08 00:00:00 | 28 |  | Actual Last 3 Average
C | 2013-10-09 00:00:00 | 32
d |  | 45
d |  | 6
d |  | 7
d |  | 23
d |  | 14
x |  | 1
x |  | 2
x |  | 3
x |  | 4
x |  | 5
x |  | 6
M |  | 12
M |  | 32
M |  | 45
M |  | 23
M |  | 77
Spreadsheet: 716553d1612268610-conditional-formatting-across-multiple-data-example-capacity-planner-v2
Sheet: Sheet1

 |  |  |  |  |  |  | February 2021
ACTIVITY | Job Start Date | Job Duration | Team 1 | Team 2 | Team 3 | Team 4
 |  |  |  |  |  |  | 1 | 2 | 3 | 4 | 5 | 6 | 7 | 8 | 9 | 10 | 11 | 12 | 13 | 14 | 15 | 16 | 17 | 18 | 19 | 20 | 21 | 22 | 23 | 24 | 25 | 26 | 27 | 28
Test 1 | 5 | 5 | 1 | 0 | 0 | 0
Test 2 | 10 | 3 | 0 | 1 | 0 | 0
Test 3 | 0 | 0 | 0 | 0 | 0 | 0
Test 4 | 3 | 4 | 1 | 0 | 0 | 0
Test 5 | 0 | 0 | 0 | 0 | 0 | 0
Test 6 | 0 | 0 | 0 | 0 | 0 | 0
Test 7 | 0 | 0 | 0 | 0 | 0 | 0
Test 8 | 0 | 0 | 0 | 0 | 0 | 0
Test 9 | 0 | 0 | 0 | 0 | 0 | 0
Test 10 | 0 | 0 | 0 | 0 | 0 | 0
Test 11 | 0 | 0 | 0 | 0 | 0 | 0
Test 12 | 0 | 0 | 0 | 0 | 0 | 0
Test 13 | 0 | 0 | 0 | 0 | 0 | 0
Test 14 | 0 | 0 | 0 | 0 | 0 | 0
Spreadsheet: 54019d1253983923-convert-repeating-data-into-a-list-excel-help
Sheet: Thanks for your help

Name | [NAME] |  | Name | Age | Gender | Grade
Age | 26 |  | [NAME] | 26 | M | A
Gender | M |  | [NAME] | 23 | F | C
Grade | A |  | Scott | 32 | M | B
Name | [NAME]
Age | 23
Gender | F
Grade | C
Name | Scott
Age | 32
Gender | M
Grade | B
Spreadsheet: 79342d1279632741-trying-to-copy-workbooks-to-new-folder-while-retaining-relative-links-between-workboo-july-sound-and-light-show
Sheet: Data

 | Enter Start Date Here |  | Write Day Name here
 | 2009-07-01 00:00:00 |  | Wednesday
 | Booking Officers | S & L Show Start Times | How Did You Hear About us |  | Prepaid
 | [NAME] | 06:00:00 |  |  | Yes | The values in "How did you hear about us?" should not be changed here - make all adjustments on the Yearly Summary spreadsheet as the results are based on Formulae and not on text values.
 |  | 06:30:00 |  |  | No
 |  | 07:00:00
 |  | 07:30:00
 |  | 08:00:00
 |  | 08:30:00
 | Note: To unprotect any sheet for modification - the Password should be left BLANK        (ie there is no password)
Spreadsheet: kate_symes__18187__EOL 1-29
Sheet: EOL Deals

EOL Deals | From: 1/1/2001   To: 1/29/2001 |  |  | EnPower Deals | From: 1/1/2001   To: 1/29/2001
Desk | Total MWH | Total Deals |  | Desk | Total MWH | Total Deals
EPMI Long Term California | 686800 | 61 |  | EPMI Long Term California | 3159965 | 132
EPMI Long Term Northwest | 1322425 | 79 |  | EPMI Long Term Northwest | 20008270 | 310
EPMI Long Term Southwest | 2304000 | 67 |  | EPMI Long Term Southwest | 8948189 | 196
EPMI Short Term California | 430000 | 677 |  | EPMI Short Term California | 906550 | 446
EPMI Short Term Northwest | 101400 | 192 |  | EPMI Short Term Northwest | 407800 | 202
EPMI Short Term Southwest | 913800 | 416 |  | EPMI Short Term Southwest | 1544800 | 346
Grand Total | 5758425 | 1492 |  | Grand Total | 34975574 | 1632
EOL Deals | From: 1/29/2001   To: 1/29/2001 |  |  | EnPower Deals | From: 1/29/2001   To: 1/29/2001
Desk | Total MWH | Total Deals |  | Desk | Total MWH | Total Deals
EPMI Long Term California | 94000 | 5 |  | EPMI Long Term California | 262050 | 9
EPMI Long Term Northwest | 71600 | 3 |  | EPMI Long Term Northwest | 1598400 | 11
EPMI Long Term Southwest | 61200 | 2 |  | EPMI Long Term Southwest | 614400 | 8
EPMI Short Term California | 44800 | 40 |  | EPMI Short Term California | 44400 | 29
EPMI Short Term Northwest | 2000 | 5 |  | EPMI Short Term Northwest | 11160 | 5
EPMI Short Term Southwest | 83000 | 24 |  | EPMI Short Term Southwest | 52200 | 16
Grand Total | 356600 | 79 |  | Grand Total | 2582610 | 78
Spreadsheet: 545919a2-f776-4d48-b1ff-7e516257d4f3
Sheet: Sheet1

Bevölkerung des Freistaates Sachsen nach ausgewählten Altersgruppen | Unnamed: 1 | Unnamed: 2 | Unnamed: 3 | Unnamed: 4
[NAME]
Alter von ... bis                     unter ... Jahren | 2011 | 2015 | 2020 | 2025
1 000
unter 15 | 9560 | 8952 | 8126 | 7127
15 - 65 | 49613 | 45528 | 40330 | 36300
65 und mehr | 18533 | 19853 | 21853 | 22767
Insgesamt | 77706 | 74333 | 70309 | 66194
%
unter 15 | 12.30278228193447 | 12.04310333230194 | 11.557553087087 | 10.76683687343264
15 - 65 | 63.84706457673796 | 61.24870515114418 | 57.36107752919256 | 54.83880714264132
65 und mehr | 23.85015314132757 | 26.70819151655389 | 31.08136938372044 | 34.39435598392603
Insgesamt | 100 | 100 | 100 | 100
Abhängigkeitsquotient
Jugendquotient | 19.26914316812126 | 19.66262519768055 | 20.14877262583685 | 19.633608815427
Altenquotient | 37.35512869610788 | 43.60613248989632 | 54.18546987354327 | 62.71900826446281
Gesamtquotient | 56.62427186422914 | 63.26875768757687 | 74.33424249938011 | 82.35261707988981
Gebietsstand: | 31. [NAME] 2008
Quelle: | 2011 Bevölkerungsfortschreibung auf Basis der [NAME] vom 03. Oktober 1990
 | 2012 - 2025 Bevölkerungsprognose
Bevölkerung jeweils am 31. Dezember
Prognoseergebnisse werden bei der Veröffentlichung immer auf volle [NAME] gerundet. [NAME] basieren [NAME] ungerundeten Werten. Beim [NAME] der [NAME] werden Ihnen die ungerundeten [NAME] zur Verfügung gestellt, damit [NAME] eigenen Berechnungen genauer durchführen können. Die Darstellung der Ergebnisse sollte dann aber wieder gerundet erfolgen.
Spreadsheet: 830184d1684770018-sum-up-revenue-of-customers-by-year-from-another-sheet-of-financial-data-s666-pq-sum-up-revenue-of-customers-by-year-from-another-sheet-of-financial-data
Sheet: Sheet1

Customer ID | 2018 | 2019 | 2020
19771 |  |  |  |  | Customer ID | 2018 | 2019 | 2020
12321 |  |  |  |  | 12314 | 24 | 32
21241 |  |  |  |  | 12321 | 232324 | 687 | 231
12314 |  |  |  |  | 19771 | 12323 | 5 | 2
 |  |  |  |  | 21241 | 234 | 233
Spreadsheet: phillip_allen__28920__MAPTTRA
Sheet: Mkt.

FUNDINGS | TOTAL | 0 | 1 | 2 | 3 | 4 | 5 | 6 | 7 | 7 | 8 |  | 9 | 10 | 11 | 12
Land/Taxes |  | 1121670 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 |  | 0 | 0 | 0 | 0
Improvements |  |  | 135770 | 98252 | 98252 | 98252 | 98252 | 98252 |  | 0 | 0 |  | 0 | 0 | 0 | 0
Amenities |  | 0 | 0 | 20543 | 20543 | 20543 | 20543 | 13843 | 0 | 106543 | 0 |  | 0 | 0 | 0 | 583087
 |  |  |  |  |  |  |  |  | 0
Direct Unit Costs |  | 0 | 290552 | 110245 | 363821 | 792926 | 917671 | 1248636 | 0 | 1288465 | 1097973 |  | 947482 | 564905 | 252233 | 54914
Const. Profit & Overhead |  | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 |  | 0 | 0 | 0 | 830000
 |  |  |  |  |  |  |  |  | 0
Origination & Closing |  | 145313 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 |  | 0 | 0 | 0 | 0
Interest Expense |  | 0 | 3053 | 4982 | 7206 | 12134 | 19519 | 28682 | 0 | 38744 | 48930 |  | 57516 | 63652 | 67554 | 69753
TOTAL
Less Developer's Equity @ Closing |  | 1121670 | 429375 | 234022 | 226369 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 1340957
Cumulative Principal Outstanding
Interest Only @ 8.65% |  | 0
Beginning Interest Reserve |  | 666632
Less: Interest
Ending Interest Reserve
Interest Coverage
Spreadsheet: 176599d1345963351-tidy-up-printed-invoice-factuur_excel-forum
Sheet: Print_Factuur

as the data in klant table
available
Factuurnummer: |  | 1207002
Debiteurnummer:
Omschrijving |  |  |  |  |  |  |  | BTW |  | Bedrag
 |  |  |  |  |  |  |  | Subtotaal | €
 |  |  |  |  |  |  |  | BTW | €
Spreadsheet: 453659d1459401767-populate-events-calendar-from-inputs-sample
Sheet: INPUTS

 | Date | Start Time | End Time | Description
 | 2016-04-01 00:00:00 | 09:00:00 | 10:00:00 | Breakfast
 | 2016-04-01 00:00:00 | 10:00:00 | 12:00:00 | Activity
 | 2016-04-01 00:00:00 | 12:00:00 | 13:00:00 | Lunch
 | 2016-04-01 00:00:00 | 13:00:00 | 15:00:00 | Activity
 | 2016-04-01 00:00:00 | 15:00:00 | 16:30:00 | Break
 | 2016-04-01 00:00:00 | 16:30:00 | 18:30:00 | Dinner
 | 2016-04-02 00:00:00 | 09:30:00 | 10:30:00 | Breakfast
 | 2016-04-02 00:00:00 | 10:30:00 | 12:30:00 | Activity
 | 2016-04-02 00:00:00 | 12:30:00 | 14:00:00 | Lunch
 | 2016-04-02 00:00:00 | 14:00:00 | 18:00:00 | Activity
 | 2016-04-02 00:00:00 | 18:00:00 | 19:00:00 | Dinner
 | 2016-04-03 00:00:00 | 09:00:00 | 10:00:00 | Breakfast
 | 2016-04-03 00:00:00 | 10:00:00 | 10:30:00 | Activity
 | 2016-04-03 00:00:00 | 10:30:00 | 11:30:00 | Break
 | 2016-04-03 00:00:00 | 11:30:00 | 12:30:00 | Activity
 | 2016-04-03 00:00:00 | 12:30:00 | 14:00:00 | Lunch
 | 2016-04-03 00:00:00 | 14:00:00 | 17:30:00 | Activity
Spreadsheet: sara_shackleton__36434__PHONE LIST_APRIL-2000
Sheet: ext. Argentina office

Enron South America
BUENOS AIRES OFFICE
STAFF & SUPPORT TELEPHONE
Name | Department | Direct Phone | Ext. | Tie line |  | Mobile
[NAME] | Legal | 4891-3651 | 251 | 1251 |  | 54 11 4560-1856
[NAME] | Systems | 4891-3643 | 243 | 1243 |  | 54 11 4496-5705
[NAME] | Origination & Trading | 4891-3657 | 257 | 1257 |  | 54 11 4474-9052
Brent Hendry | Legal | 4891-3650 | 250 | 1250 |  | 54 11 4560-0731
[NAME] | Trading | 4891-3633 | 233 | 1233 |  | 54 11 4141-2886
Cecília Morellato | Legal | 4891-3620 | 220 | 1220 |  | *  *  *
Cristian Folgar | Regulatory Affairs | 4891-3635 | 235 | 1235 |  | 54 11 4478-5164
[NAME] | Origination | 4891-3649 | 249 | 1249 |  | 54 11 4490-1510
[NAME] | HR/ Adm. Dept. | 4891-3613 | 213 | 1213 |  | *  *  *
[NAME] | Administrative Dept. | 4891-3607 | 207 | 1207 |  | *  *  *
[NAME] | Trading | 4891-3614 | 214 | 1214 |  | 54 11 4051-0166
[NAME] | Trading | 4891-3653 | 253 | 1253 |  | 54 11 4051-0163
[NAME] | Origination | 4891-3615 | 215 | 1215 |  | 54 11 4560-1793
[NAME] | Regulatory Affairs | 4891-3616 | 216 | 1216 |  | 54 11 4560-1044
[NAME] | Origination | 4891-3645 | 245 | 1245 |  | 54 11 4429-6307
[NAME] | Origination | 4891-3648 | 248 | 1248 |  | 54 11 4560-0122
[NAME] | Trading | 4891-3642 | 242 | 1242 |  | 54 11 4053-4338
[NAME] | Origination | 4891-3621 | 221 | 1221 |  | 54 11 4142-1369
[NAME] | Accounting | 4891-3619 | 219 | 1219 |  | *  *  *
[NAME] | Accounting | 4891-3626 | 226 | 1226 |  | 54 11 4560-1795
[NAME] | Reception | 4891-3610 | 210 | 1210 |  | *  *  *
[NAME] | Legal | 4891-3636 | 236 | 1236 |  | *  *  *
[NAME] | Administrative Dept. | 4891-3622 | 241 | 1241 |  | 54 11 4145-4235
[NAME] | Accounting | 4891-3622 | 222 | 1222 |  | *  *  *
[NAME] | Administrative Dept. | 4891-3607 | 207 |  |  | 54 11 4530-4627
[NAME] | Administrative Dept. | 4891-3637 | 237 | 1327 |  | 54 11 4429-6559
Nadia Rodriguez | Administrative Dept. | 4891-3644 | 244 | 1244 |  | *  *  *
[NAME] | Reception | 4891-3610 | 210 | 1210 |  | *  *  *
Pablo Acevedo | Trading | 4891-3624 | 224 | 1224 |  | 54 11 4030-2386
[NAME] | Accounting | 4891-3625 | 225 | 1225 |  | *  *  *
Paola Zingman | Trading | 4891-3654 | 254 | 1254 |  | *  *  *
[NAME] | Trading | 4891-3652 | 252 | 1252 |  | 54 11 4050-2114
[NAME] | Integrated Projects | 4891-3646 | 246 | 1246 |  | 54 11 4560-0071
[NAME] | Trading | 4891-3617 | 217 | 1217 |  | *  *  *
[NAME] | 9233-7450 Brazil
Other mobiles | 503-8136 USA
Conference Room |  | 4891-3611 | 211 | 1211
FAXES
General              54 11 4313-2916
Trading              54 11 4312-1692
Accountancy      54 11 4315-2514
Spreadsheet: 727732d1618061664-how-to-categorize-using-multiple-currency-rate-multiple-currency-rev3
Sheet: Revision

Core Group | Team | Location | Request Ticket | Item | Category | Case code | Total Value | Currency | USD | Threshold
[NAME] |  |  | 12580243 | 10 | X |  | 15000 | USD
[NAME] |  | Apac | 17185628 | 10 | X |  | 100000 | USD
[NAME] |  |  | 55723648 | 40 | X |  | 2300000 | EUR
[NAME] |  | Apac | 51858337 | 30 | X |  | 1700 | USD
[NAME] |  |  | 11467077 | 10 | X |  | 70000 | [NAME]
[NAME] |  | Apac | 4420109 | 10 |  | ABC54656 | 170.14 | EUR
[NAME] |  |  | 11518185 | 10 |  |  | 2920 | AUD
[NAME] |  | Apac | 11518185 | 20 |  |  | 5920 | USD
[NAME] |  |  | 11467077 | 20 |  |  | 1000000 | [NAME]
[NAME] |  |  | 4420109 | 20 |  |  | 50000 | EUR
[NAME] |  | Apac | 11467078 | 10 |  |  | 4000 | USD
[NAME] |  |  | 11467076 | 10 |  |  | 50000 | USD
Spreadsheet: phillip_allen__29919__Profit_sharing
Sheet: version 2

Costs |  | 10300000
Equity
Loan
Appraised Value |  | 12000000
LTV % |  | 0.8
Permanent Loan
Permanent Equity |  |  |  |  |  |  |  | 0.15
 |  |  |  |  |  |  | Cash Avail | Remain. | Cash after |  | Cash Flow
Year |  | Equity | NOI(3%) | Debt Service | Cash Flow | Reserve | to Partners | Equity | equity |  | PA & KH | CIS
1
2 |  |  | 1100000 | -785867
3 |  |  |  | -785867
4 |  |  |  | -785867
5 |  |  |  | -785867
6 |  |  |  | -785867
7 |  |  |  | -785867
8 |  |  |  | -785867
9 |  |  |  | -785867
10 |  |  |  | -785867
11 |  |  |  | -785867
12 |  |  |  | -785867
Spreadsheet: 131846d1323356576-nested-if-or-and-matched-indexed-statements-janine-2
Sheet: Venice

Rooming allocation for Rome |  |  |  |  |  |  |  |  |  |  | #N/A
Type | # of Rms
Singles |  | 0
Twins |  | 0
Triples |  | 0
Quads |  | 0
5 bed |  | 0
6 bed |  | 0
Total Pax |  | 0 | Tour leader
[NAME] | [NAME] | Single | Twin |  | Triple |  | Quad |  | 5 bed |  | 6 bed
#N/A |  | Driver
#N/A |  | Tour leader
#N/A |  |  | mr s | 1
#N/A |  |  | Mrs s | 1
#N/A |  |  |  |  | miss t | 1
#N/A |  |  |  |  | miss r | 1
#N/A |  |  |  |  | miss e | 1
#N/A |  |  | mr o | 2
#N/A |  |  | mr p | 2
#N/A |  |  | Mrs j | 3
#N/A |  |  | mr j | 3
#N/A | h
#N/A | k
b
#N/A | v
#N/A
#N/A
#N/A
#N/A
#N/A
#N/A
#N/A
#N/A
#N/A
#N/A
#N/A
#N/A
#N/A
#N/A
#N/A
#N/A
#N/A
#N/A
#N/A
#N/A
#N/A
#N/A
#N/A
#N/A
Spreadsheet: 756529d1637614928-adding-an-array-with-an-offset-array-addition-with-an-offset
Sheet: Sheet1

 |  | EXAMPLE 1 |  |  |  |  |  | EXAMPLE 2
 | TARGET |  | 8 | 6 | 8 |  | TARGET |  | 8 | 6 | 8
 |  | 5 | 7 | 1 |  |  |  |  | 7 | 1
 |  | 4 | 1 | 11 |  |  |  | 4 | 1 | 11
 |  | 2 | 0 | 10 |  |  |  | 2 | 0 | 10
 | RESULT |  |  |  |  |  | RESULT
 | New |  |  |  |  |  | New
 | RESULT |  |  |  |  |  | RESULT
Spreadsheet: 77038d1277476285-match-three-fields-and-input-into-a-different-cell-sample
Sheet: TimeSheet

Team | Name | Project Name | Req # | 2010-06-07 00:00:00 | 2010-06-14 00:00:00
1 | [NAME], [NAME] | TOAD | 146555 | 6.5 | 7.75
1 | [NAME], [NAME] | BULLFROG | 152847 |  | 1.5
1 | [NAME], [NAME] | LIONSHEAD | 254785 | 10 | 5.5
Spreadsheet: phillip_m_love__30655__9901_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
 |  |  | 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
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
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:
23 | Fuel:
 | Transport Expense:
24 |  | Commodity
25 |  | Demand
 | Total Transport Expense:
 | Transport Revenue:
26 |  | Interstate
27 |  | Intrastate
 | Total Transport Revenue:
 | Intra CTS (EGM / HPL / LRC):
28 |  | Transport Expense
29 |  | Transport Revenue
 | 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
 |  | Fuel Allocation:
 |  | Storage Book |  |  |  |  |  |  |  | 0 |  | 0 |  | 0 |  | 0 |  | 0 |  | 0 |  | 0 |  | 0 |  | 0 |  | 0 |  | 0 |  | 0 |  | 0 |  | 0 |  | 0
 |  | Transport Book
 |  | Texas Desk
 |  | Total
 |  | 3rd Party Commidity exp. to transport book
 |  | 3rd Party Demand exp. to transport book
 |  | Total
Spreadsheet: 703390d1604969483-copy-and-paste-a-sum-formula-but-change-column-reference-to-a-specific-column-example-summary-eba
Sheet: Detailed Info

Activity | Total Price | Net Margin % | Net Margin £ | Other Fees | Gross Margin % | Gross Margin £ | Total Cost | Labour | Materials
Work Package 1
WP1.1 |  |  |  | 20 | 0.25 |  |  | 100 | 100
WP1.2 |  |  |  | 20 | 0.25 |  |  | 100 | 100
WP1.3 |  |  |  | 20 | 0.25 |  |  | 100 | 100
WP1.4 |  |  |  | 20 | 0.25 |  |  | 100 | 100
WP1.5 |  |  |  | 20 | 0.25 |  |  | 100 | 100
Work Package 2
WP2.1 |  |  |  | 20 | 0.25 |  |  | 100 | 200
WP2.2 |  |  |  | 20 | 0.25 |  |  | 100 | 200
WP2.3 |  |  |  | 20 | 0.25 |  |  | 100 | 200
WP2.4 |  |  |  | 20 | 0.25 |  |  | 100 | 200
WP2.5 |  |  |  | 20 | 0.25 |  |  | 100 | 200
Work Package 3
WP3.1 |  |  |  | 20 | 0.25 |  |  | 100 | 150
WP3.2 |  |  |  | 20 | 0.25 |  |  | 100 | 150
WP3.3 |  |  |  | 20 | 0.25 |  |  | 100 | 150
WP3.4 |  |  |  | 20 | 0.25 |  |  | 100 | 150
WP3.5 |  |  |  | 20 | 0.25 |  |  | 100 | 150
WP3.6 |  |  |  | 20 | 0.25 |  |  | 100 | 150
WP3.7 |  |  |  | 20 | 0.25 |  |  | 100 | 150
WP3.8 |  |  |  | 20 | 0.25 |  |  | 100 | 150
WP3.9 |  |  |  | 20 | 0.25 |  |  | 100 | 150
END
Spreadsheet: chris_dorland__1607__xforecast_02062002
Sheet: X Forecast

Dorland's NWP / PGT X Forecast
 |  | Sumas | Sumas - Chehalis | Chehalis | Washougal | Kelso / [NAME] | Other Chehalis /  Roosevelt | Roosevelt | JP  INJ+ / WD- | JP Balance | % Full | Starr Road | Other [NAME] / Meacham | Stanfield Net | Meacham | Reno Lateral | Mystery Demand | Other Meecham/ Kemmerer | Kemmerer |  | [NAME] | Rathdrum | Spokane NWP | Spokane WWP | Other/ Fuel | NWP Stanfield | South Hermiston | Coyote Springs | [NAME] | [NAME] [NAME] | Malin
 |  |  |  |  |  |  |  |  |  | 10500 | 19000
2002-02-01 00:00:00 |  |  | 600 |  | -300 | -90 | -290 |  |  |  |  |  | -200 |  |  | -130 | -25 | -185 | -460 |  | 2400 | -40 | -135 | -15 | -80 |  | -80 | -40 | -90 | -80 | -1650
2002-03-01 00:00:00 |  |  | 505 |  | -250 | -90 | -225 |  |  |  |  |  | -180 |  |  | -120 | -25 | -130 | -460 |  | 2400 | -40 | -125 | -15 | -75 |  | -80 | -40 | -75 | -80 | -1750
2002-04-01 00:00:00 |  |  | 430 |  | -200 | -90 | -210 |  |  |  |  |  | -155 |  |  | -110 | -25 | -105 | -460 |  | 2400 | -30 | -115 | -15 | -65 |  | -75 | -40 | -60 | -80 | -1750
2002-05-01 00:00:00 |  |  | 390 |  | -200 | -90 | -205 |  |  |  |  |  | -130 |  |  | -110 | -25 | -90 | -460 |  | 2400 | -30 | -110 | -15 | -65 |  | -75 | -40 | -40 | -80 | -1750
2002-06-01 00:00:00 |  |  | 340 |  | -175 | -90 | -205 |  |  |  |  |  | -120 |  |  | -110 | -25 | -85 | -460 |  | 2400 | -30 | -75 | -15 | -65 |  | -75 | -40 | -40 | -80 | -1750
2002-07-01 00:00:00 |  |  | 310 |  | -175 | -90 | -205 |  |  |  |  |  | -110 |  |  | -110 | -25 | -85 | -460 |  | 2400 | -30 | -75 | -15 | -65 |  | -75 | -40 | -40 | -80 | -1800
2002-08-01 00:00:00 |  |  | 320 |  | -160 | -90 | -205 |  |  |  |  |  | -110 |  |  | -110 | -25 | -75 | -460 |  | 2400 | -30 | -75 | -15 | -65 |  | -75 | -40 | -40 | -80 | -1800
2002-09-01 00:00:00 |  |  | 320 |  | -160 | -90 | -205 |  |  |  |  |  | -120 |  |  | -125 | -25 | -80 | -460 |  | 2400 | -30 | -75 | -15 | -65 |  | -75 | -40 | -40 | -80 | -1800
2002-10-01 00:00:00 |  |  | 450 |  | -200 | -90 | -230 |  |  |  |  |  | -150 |  |  | -140 | -25 | -115 | -460 |  | 2400 | -30 | -100 | -15 | -80 |  | -75 | -40 | -60 | -80 | -1800
2002-11-01 00:00:00
2002-12-01 00:00:00
2003-01-01 00:00:00
2003-02-01 00:00:00
2003-03-01 00:00:00
2003-04-01 00:00:00
2003-05-01 00:00:00
2003-06-01 00:00:00
2003-07-01 00:00:00
2003-08-01 00:00:00
2003-09-01 00:00:00
2003-10-01 00:00:00
2003-11-01 00:00:00
Spreadsheet: 862731d1710380864-check-condition-with-2-file-report
Sheet: ความหมาย

1 | Feed Back | Wrong SR | หมายถึง สร้าง cat sub cat มาผิด แต่ Onwer มา Bill & Pay Resolution เช่น [NAME]
2 | Feed Back | Wrong Process 1 | หมายถึง สร้าง cat subcat  Issue ของ Bill & Pay Resolution มาถูกต้อง แต่ใส้ในผิด  หรือระบุข้อมูลไม่ครบถ้วน ไม่ชัดเจน ไม่แนบเอกสาร
2.1 | Feed Back | Wrong Process 2 | หมายถึง สร้าง cat subcat  Issue ของ Bill & Pay Resolution มาถูกต้อง  แต่เป็นเรื่องที่ตรวจสอบในประเด็นเบื้องต้น เช่น Content ,แพ็กเกจเสริม
3 | Handle | Enquiry | หมายถึง เคสที่สอบถามเรื่อง Bill & Pay แต่เป็นเรื่องที่หน้าบ้านสามารถให้ข้อมูลกับลูกค้าได้ด้วยตัวเอง  เช่น สอบถามยอดค่าบริการ ,สอบถามเรื่องใบแจ้งค่าบริการ,สอบถามเรื่องการชำระเงิน
3.1 | Handle | Enquiry 1 | [NAME] ,ตั้งหนี้,โยกหนี้ ,เก็บซ้ำ(แพ็กเกจเสริม)
 |  |  | ตรวจสอบเพิ่ม***ที่ตีกลับไม่ได้ทำให้ และไม่อยู่ในข้อ 1 และ 2 คืออะไร