tianzl66/Sheetpedia huggingface dataset:
Spreadsheet: 549434d1511715008-combine-cells-based-on-partial-string-rsmc-test
Sheet: PPOSEnew (2)

 |  |  |  |  |  |  |  | Code1 | Code2 |  | DESIRED RESULT 1 | GOT | DESIRED RESULT 2 | GOT
 |  |  |  |  |  |  |  | BRITAIN (BR) SS0029 | RSMC |  | RSMC BRITAIN |  | BRITAIN RSMC
 |  |  |  |  |  |  |  | BIG MAC | MAC |  | MAC |  | MAC
 |  |  |  |  |  |  |  | FRENCH FRY | FRY |  | FRY |  | FRY
 |  |  |  |  |  |  |  | CHICKEN NUGGETS | NUGGETS |  | NUGGETS |  | NUGGETS
 |  |  |  |  |  |  |  | HOT COFFEE | COFFEE |  | COFFEE |  | COFFEE
 |  |  |  |  |  |  |  | CHOCOLATE MUFFIN | MUFFIN |  | MUFFIN |  | MUFFIN
 |  |  |  |  |  |  |  | QUARTER POUNDER | POUNDER |  | POUNDER |  | POUNDER
 |  |  |  |  |  |  |  | CANADA (CA) SS00012 | RSMC |  | RSMC CANADA |  | CANADA RSMC
 |  |  |  |  |  |  |  | GARDEN SALAD | SALAD |  | SALAD |  | SALAD
 |  |  |  |  |  |  |  | GARDEN SALAD (AUS) SS89754 | RSMC |  | RSMC GARDEN SALAD |  | GARDEN SALAD RSMC
 |  |  |  |  |  |  |  | LARGE COKE (CH) SS11123 | RSMC |  | RSMC LARGE COKE |  | LARGE COKE RSMC
 |  |  |  |  |  |  |  | LARGE GINGER ALE | ALE |  | ALE |  | ALE
 |  |  |  |  |  |  |  | CHOCOLATE SUNDAE (USA) SS 98743 | RSMC |  | RSMC CHOCOLATE SUNDAE |  | CHOCOLATE SUNDAE RSMC
 |  |  |  |  |  |  |  | *** IF COL J HAS THE TEXT RSMC
 |  |  |  |  |  |  |  | STILL PROBLEMS WITH TWO WORDS
Spreadsheet: 78336d1278696619-copy-values-only-sample
Sheet: Sheet1

F
MP
C
SD
DD | 4 | 4 | 4 | 4 | 4 | 4 | 4 | 4 | 4 | 4 | 4 | 4 | 4 | 4 | 4 | 4 | 4
CD
CA
F
MP
C
SD
DD | 5 | 5 | 5 | 5 | 5 | 5 | 5 | 5 | 5 | 5 | 5 | 5 | 5 | 5 | 5 | 5 | 5
CD
CA
Spreadsheet: 169211d1342726547-conditional-formatting-highlighting-most-frequently-duplicated-cells-book1
Sheet: Sheet1

OUTCOME |  | NUMBER | COUNT
2 |  | 1
3 |  | 2
3 |  | 3
4 |  | 4
5 |  | 5
7 |  | 6
7 |  | 7
7 |  | 8
8 |  | 9
1 |  | 10
I would like these ↑ highlighted according to Column D
Spreadsheet: 53006d1252932867-formula-autofill-problem-grids_test
Sheet: Sheet10

AG0740101 | 1
AG0740102 | 1 | 1 | 2 | 3 | 4 | 5 | 6
AG0740103 | 1
AG0740104 | 1
AG0740105 | 1
AG0740106 | 1
AG0740107 | 1
AG0740108 | 1
AG0740109 | 1
AG0740110 | 1
AG0740111 | 1
AG0740112 | 1
Spreadsheet: darrell_schoolcraft__7309__imball0201
Sheet: Conoco

 | Maljamar |  | Zia |  |  |  |  |  |  |  |  | Avg
Day | Measured | Scheduled | Measured | Scheduled |  |  | Month | Measured | Scheduled | Imbalance | Index | Amount
1 | 41789 | 35858 | 30108 | 32000
2 | 37927 | 35858 | 30887 | 32000 |  |  | 2001-03-01 00:00:00 |  |  |  | 4.98
3 | 32549 | 35858 | 32901 | 32000 |  |  | 2001-04-01 00:00:00 |  |  |  | 4.87
4 | 30654 | 35620 | 34690 | 31782 |  |  | 2001-05-01 00:00:00 |  |  |  | 3.82
5 | 33190 | 33700 | 30637 | 30158 |  |  | 2001-06-01 00:00:00 |  |  |  | 3.2
6 | 31722 | 33700 | 34293 | 30158 |  |  | 2001-07-01 00:00:00 |  |  |  | 2.77
7 | 31843 | 33700 | 34597 | 30158
8 | 29795 | 32700 | 32940 | 34158
9 | 30149 | 32000 | 32215 | 33158
10 | 32222 | 32067 | 32379 | 34000
11 | 30694 | 32067 | 32638 | 34000
12 | 31245 | 27834 | 29946 | 31791
13 | 31719 | 32067 | 28145 | 32000
14 | 28127 | 27999 | 30808 | 28999
15 | 30588 | 32067 | 30690 | 32000
16 | 30738 | 31567 | 32451 | 31000
17 | 30149 | 31567 | 33775 | 31000
18 | 31912 | 30832 | 35106 | 30262
19 | 31669 | 31567 | 34216 | 31000
20 | 30840 | 31566 | 34939 | 30998
21 | 28062 | 31567 | 34728 | 31000
22 | 29987 | 31567 | 32775 | 34500
23
24
25
26
27
28
29
30
31
2001-12-31 00:00:00 |  |  |  |  | 460426.69
2002-01-22 00:00:00
CBS Volume
 |  |  | 17967
Spreadsheet: 54972d1255013490-can-vlookups-cope-with-spelling-errors-spelling-error-vlookup-example
Sheet: Cost Info

Name | Cost
[NAME] | 100
[NAME] | 100
[NAME] | 100
[NAME] | 100
Paul Thoms | 100
[NAME] | 100
[NAME] | 100
[NAME] | 100
[NAME] | 200
[NAME] | 200
Spreadsheet: 133907d1324813119-how-to-make-time-series-graph-for-phenological-calander
Sheet: Sheet1

 | leaf drop | leafing
Species A | 18th apr - 8th june | 8th June - 17 July
Species B | 23rd march - 19th may | 11th May- 28th june
Species C | 2nd feb - 22nd march | 20th march- 9 may
Species D | 5th jan - 18th march | 8th feb - 25th march
Species E | 16th march - 23 april | 17th feb - 23 march
Species F | 13th march - 29th apr | 29th feb - 12 apr
Species G | 9th feb - 17th april | 5th jan - 18th feb
Species H | 14nd feb - 5th apr | 18th Jan - 26th feb
Spreadsheet: 679348d1590343461-getting-data-from-multiple-workbooks-to-different-sheets-of-a-workbook-new-workbook
Sheet: Sheet1

Source.Name | Column1 | Column2
A.xlsx | workbook A data | 1
A.xlsx |  | 2
A.xlsx |  | 3
A.xlsx |  | 4
A.xlsx |  | 5
A.xlsx |  | 6
A.xlsx |  | 7
A.xlsx |  | 8
A.xlsx |  | 9
A.xlsx |  | 10
Spreadsheet: craig_dean__4436__10_12act
Sheet: Economics

 | Commodity Revenue (Cost) | Demand Charge | Total | Total Volume | $/Mwhr Commodity Cost | $/Mwhr Total Cost
Purchases
[NAME]. Cost Est. |  |  |  |  | 20 | 0
Incremental Purchases
[NAME]
4C Balancing
4C Realtime
[NAME]
PV Balancing
PV Realtime
SPS Pre
Artesia Balancing
Artesia Realtime
Sales
Incremental Sales
[NAME]
4C Balancing
4C Realtime
[NAME]
PV Balancing
PV Realtime
[NAME]
Artesia Balancing
Artesia Realtime
 |  |  |  |  |  |  | Heat | Fuel
Generation |  |  |  |  |  |  | Rate | Cost
4 Corners Unit 4 |  |  |  |  |  |  | 10.0576 | 1.3
4 Corners Unit 5 |  |  |  |  |  |  | 10.0576 | 1.3
PV Unit 1 |  |  |  |  |  |  | 10.16 | 0.6
PV Unit 2 |  |  |  |  |  |  | 10.16 | 0.6
PV Unit 3 |  |  |  |  |  |  | 10.16 | 0.6
Newman 1
Newman 2
Newman 3
GT 1
GT 2
GT1+ST1
GT2+ST1
Newman 4 |  |  |  |  |  |  |  | 1.96
Copper
Rio Grande 6
Rio Grande 7
Rio Grande 8
Total
Spreadsheet: daren_farmer__6363__CES INFO
Sheet: KMID

Purchase
 | Vols from [NAME] and Coowners
 | At Various Points
 |  | Comitas (LL-1-0030)
 |  | [NAME] (LL-1-0027)
 | For IF-.13 (Base vols) and GDA-.14 (Swing Vols)
Sale
 | Sold to the marketing affiliate at the wellhead
 | For IF-.12
Term
 | Evergreen
Other
 | Volumes of 1286 for january
 |  | 1194 Base
 |  | 92 Swing
Deal Numbers
 | Purchase | 143804
 |  | 143873
 |  | 144973
 |  | 144976
 |  | 144978
 |  | 145116
 | Sale | 144049
 |  | 144052
Spreadsheet: 093532a8-0569-45ce-b52e-45010cfeeb5c
Sheet: 5.7 Distance Learning

Institution
Indicator 5: Course Enrollment and Completion
Table 5.7: Online and Distance Course Enrollment and Successful Completion / AY 2010-11
Please enter Online and Distance Course Information.
I. Online Courses - Please enter the number of students enrolled in courses offered by your institution via the internet asynchronously, and the number of those students who passed.
Online courses were NOT offered in 2010-11: |  |  |  | Please place an X in the box if the highlighted statement is correct.
Number of |  | AY 2010-11
 | Summer 10 | Fall 10 | Spring 11 | [NAME] courses
Courses Offered | 0 | 10 | 15
Students Enrolled1 | 0 | 174 | 251
Students Passed2 | 0 | 132 | 194
Students Withdrew | 0 | 42 | 57
Faculty Teaching Online Courses3 | 0 | 6 | 10
II. Distance Courses Provided by Your Campus - Please enter the number of students enrolled in courses offered by your campus via satellite, interactive television, internet etc. to other campuses or institutions synchronously, and the number of those students who passed.
Distance courses were NOT provided BY your campus  in 2010-11: |  |  |  | Please place an X in the box if the highlighted statement is correct.
Number of |  | AY 2010-11
 | Summer 10 | Fall 10 | Spring 11 | Pictel courses
Courses Offered | 0 | 30 | 35
Students Enrolled1 | 0 | 187 | 210
Students Passed2 | 0 | 126 | 136
Students Withdrew | 0 | 61 | 74
Faculty Teaching Distance Courses3 | 0 | 12 | 17
Sites Courses sent to | 0 | 30 | 38
III. Distance Courses Provided to Your Campus - Please enter the number of students enrolled in courses offered on your campus synchronously taken via satellite, interactive television, internet etc. by external providers, and the number of those students who passed.
Distance courses were NOT provided TO your campus  in 2010-11: |  |  | X | Please place an X in the box if the highlighted statement is correct.
Number of |  | AY 2010-11
 | Summer 10 | Fall 10 | Spring 11
Courses Offered | na | na | na
Students Enrolled1 | na | na | na
Students Passed2 | na | na | na
Students Withdrew | na | na | na
1 Headcount of all students taking Distance Learning Courses through your institution.
2 Passed with grade 'C' or better.
3 Each faculty member (both FT and PT) is counted once (no duplicates).
Notes:
na = not applicable;
Spreadsheet: louise_kitchen__24045__West Power Consolidation
Sheet: Mid Market

 |  | 2001-09-01 00:00:00 |  | 2001-09-01 00:00:00 |  | % of
 |  | YTD Actual |  | Annualized |  | Total Exp
ENACOMP | Compensation
 | Special Pays | 5000
 | Analysts & Associates | 0 |  | 0
ENABENTX | Benefits & Payroll Taxes
ENAEMPEX | Employee Expense
ENAT&EEX | Travel & Entertainment Expense
ENAOUTSV | Outside Services
ENASUPP | Supplies Expense
ENAMKTEX | Marketing
ENACONTR | Charitable Contributions
ENARENT | Rent
ENATECH | Technology
ENATRANS | Transportation
ENAOTHEX | Other Expenses
ENATAXES | Taxes Other than Income
ENATOTDR | Total Direct Expenses
 | Headcount |  |  | 5
 | Analyst & Associate Headcount |  |  | 0
 | Total Headcount
ENAOUTLG | Outside Legal
ENAOUTTX | Outside Tax
ENAINSUR | Insurance
ENASYSDV | System Development
ENACORIT | Controllable Infrastructure
ENACORRN | Corporate Rent
ENAOTHAL | Other Allocated Direct  Expenses
ENADEPR | Depreciation & Amortization
Spreadsheet: a3a65de2-5e50-46ee-b35a-bb5db6679734
Sheet: Sheet1

Permit No.: | Unnamed: 1 | Unnamed: 2 | WQ0013348 | Unnamed: 4 | Unnamed: 5 | Facility Name: | Unnamed: 7 | Bay River MSD - Pamlico Regional Facility | Unnamed: 9 | Unnamed: 10 | Unnamed: 11 | Unnamed: 12 | Unnamed: 13 | County: | [NAME] | Unnamed: 16 | Month: | Unnamed: 18 | Unnamed: 19 | Year: | Unnamed: 21
Did infiltration occur at this facility? |  |  |  |  |  | Site Name: |  | IB-1 |  | Site Name: |  | IB-2 |  | Site Name: |  | IB-3 |  | Site Name:
 |  |  |  |  |  | Area (acres): |  | 4 |  | Area (acres): |  | 2.83 |  | Area (acres): |  | 14.97 |  | Area (acres):
 |  |  |  |  |  | Rate (GPD/ft2): |  | 0.37 |  | Rate (GPD/ft2): |  | 0.37 |  | Rate (GPD/ft2): |  | 0.34 |  | Rate (GPD/ft2):
Day | Weather |  |  | Freeboard |  | Site Infiltrated? |  |  |  | Site Infiltrated? |  |  |  | Site Infiltrated? |  |  |  | Site Infiltrated?
 | Weather Code | Temperature | Precipitation | Storage           (if applicable) | 5-Day Upset       (if applicable) | Volume Applied | Time   Infiltrated | Daily   Loading | [NAME] (Basins Only) | Volume Applied | Time    Infiltrated | Daily   Loading | [NAME] (Basins Only) | Volume Applied | Time   Infiltrated | Daily   Loading | [NAME] (Basins Only) | Volume Applied | Time    Infiltrated | Daily   Loading | [NAME] (Basins Only)
 |  | ºF | in | ft | ft | gal | min | GPD/ft2 | ft | gal | min | GPD/ft2 | ft | gal | min | GPD/ft2 | ft | gal | min | GPD/ft2 | ft
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
29
30
31
Monthly Loading (GPD/ft2):
Year to Date Loading (GPD/ft2):
Spreadsheet: 852801d1702747868-data-relocation-from-worksheet-to-worksheet-example
Sheet: Orchard

 | Orchard
Date | Payee | Description | Amount
2023-01-05 00:00:00 | P.G.&E. Veladao | Ag Pump Electricity, dates covering  11/23/22-12/22/22 | 62.63
2023-01-24 00:00:00 | [NAME]  0420 | Loan Reimbursement | 40000
2023-01-30 00:00:00 | AT&T | landline phone service  (1/17/23 - 2/16/23) | 128.91
2023-02-05 00:00:00 | P.G.&E. Veladao | Ag Pump Electricity, dates covering  12/23/22-1/24/23 | 68.91
2023-02-05 00:00:00 | Verizon | Cell Phone covering   12/26/22 - 1/25/23  Inv. 9556 | 185.66
2023-02-13 00:00:00 | Mid Valley Ag | Inv. 19964254, Strip spray Oakdale | 2615.5
 |  | Total
Spreadsheet: darrell_schoolcraft__7414__imball0201
Sheet: EOG

 | 500249 |  | 500260 |  | 500646 |  | 500598
 | Pronghorn |  | Pitchfork Ranch |  | Tristi Draw |  | EOG/TW Eddy
Day | Measured | Scheduled | Measured | Scheduled | Measured | Scheduled | Measured | Scheduled
1 | 10708 | 11500 | 8161 | 8800 |  | 7800
2 | 10744 | 11500 | 7789 | 8800 | 70 | 7800
3 | 10863 | 11500 | 7744 | 8800 | 3645 | 7800
4 | 10242 | 11500 | 8002 | 8800 | 5612 | 7800
5 | 10778 | 10500 | 8365 | 7800 | 7669 | 7800
6 | 10431 | 10500 | 8128 | 7800 | 7973 | 7800
7 | 10424 | 10500 | 8598 | 7800 | 7892 | 7800
8 | 10274 | 10500 | 7816 | 7800 | 7851 | 7800
9 | 10910 | 10500 | 8098 | 7800 | 7846 | 7800
10 | 10835 | 10414 | 8179 | 7737 | 7955 | 7800
11 | 10923 | 10500 | 8046 | 7800 | 7285 | 7800
12 | 10260 | 10500 | 8250 | 7800 | 7013 | 7800
13 | 10150 | 10500 | 8185 | 7800 | 6965 | 7800
14 | 9670 | 10500 | 7899 | 7800 | 7876 | 7800
15 | 9743 | 10500 | 8341 | 7800 | 4873 | 7800
16 | 9410 | 9350 | 8114 | 7517 | 7114 | 6967
17 | 10064 | 9700 | 7780 | 7900 | 8219 | 7400
18 | 9644 | 9700 | 7586 | 7900 | 8311 | 6400
19 | 9194 | 9000 | 8104 | 8000 | 7883 | 7000
20 | 9281 | 9000 | 8051 | 8000 | 12314 | 7000
21 | 8979 | 8927 | 7845 | 7935 | 7404 | 6943
22 | 5948 | 9000 | 7914 | 8000 | 8924 | 7000
23 | 7675 | 9000 | 8105 | 8000 | 8281 | 7000
24 | 8104 | 8500 | 8906 | 7500 | 8896 | 7000
25 | 8466 | 8500 | 8859 | 7500 | 11916 | 7000
26 | 8368 | 8499 | 8428 | 7500 | 7368 | 7000
27 | 8074 | 8499 | 8309 | 7500 | 8780 | 7000 | 547
28 | 7797 | 8500 | 8348 | 7500 | 7731 | 7000 | 7301 | 8999
29 | 7885 | 8500 | 8416 | 7500 | 7808 | 7000 | 7001 | 9000
30
31
2001-12-31 00:00:00 |  |  |  |  |  |  |  |  | 4536.21
2002-01-29 00:00:00
CBS Volume
 |  |  | -125538
Spreadsheet: 802889d1667127642-do-not-count-unique-if-another-column-has-a-higher-number-action-test
Sheet: Sheet1

ID | Name | Dept | Action
111 | A | DIGI | send
111 | A | TECH | do not send
222 | B | DIGI | send
111 | A | TECH | hold
333 | B | HR | send
111 | A | STAFF | do not send
222 | B | STAFF | hold
333 | B | STAFF | send
111 | A | DIGI | do not send
Spreadsheet: 42d0d58f-ea16-4fbf-92d5-00120f1f0427
Sheet: Sheet1

SITE | SITE.1 | TOTAL | TOTAL.1 | UNIQUE TITLES | % SOLELY | % SOLELY.1 | BIB RECS | ITEM | ORDER | CHECKIN
 | CODE | BIB RECS | MOBIUS | HELD BY THIS | HELD OF | HELD OF | WITH | RECORDS | RECORDS | RECORDS
 |  | [NAME] | MASTER | [NAME] | OWN | MOBIUS | HOLDINGS
 |  | FROM SITE | BIB RECS |  | RECORDS | UNIQUE
MERLIN | 6mrln | 4750273 |  | 2570377 | 0.5411009009376935 | 0.408973145861234 | 4710261 | 10019222 | 441831 | 216011
WASH U. | 6wash | 3096677 |  | 1480374 | 0.4780524413750611 | 0.2355425728720644 | 2053406 | 2981902 | 348146 | 151569
SLU | 6sluu | 1892544 |  | 754881 | 0.3988710434209192 | 0.1201092514136542 | 1106312 | 1260842 | 22749 | 41196
SWAN | 6swan | 1561659 |  | 370698 | 0.2373744844425063 | 0.05898182532152587 | 1539081 | 2383919 | 185348 | 53677
LANCE | 6lanc | 822061 |  | 211275 | 0.2570064751885809 | 0.0336160031745663 | 818275 | 1244125 | 67548 | 26973
QUEST | 6ques | 746361 |  | 138116 | 0.1850525415985026 | 0.02197566155228209 | 728687 | 997896 | 155 | 24525
BRIDGES | 6brid | 693966 |  | 195721 | 0.282032549145059 | 0.03114120344257149 | 689722 | 1175389 | 75243 | 9058
WILO | 6wilo | 647905 |  | 109181 | 0.1685139025011383 | 0.01737180850835321 | 563192 | 798671 | 29330 | 8175
TOWERS | 6towe | 588886 |  | 105657 | 0.1794184273356813 | 0.01681110423578347 | 571338 | 808155 | 22139 | 7665
GALAHAD | 6gala | 505130 |  | 61478 | 0.1217072832736127 | 0.009781775615505797 | 502411 | 599881 | 6328 | 17921
ARTHUR | 6arth | 502380 |  | 64884 | 0.1291532306222382 | 0.01032370488689414 | 488645 | 746690 | 30120 | 5270
ARCHWAY | 6arch | 388326 |  | 56216 | 0.1447649655186622 | 0.008944537850959267 | 383643 | 636364 | 1489 | 4017
SPRINGFIELD | 6spri | 306021 |  | 121209 | 0.3960806611310989 | 0.01928558574741927 | 303098 | 507299 | 24 | 0
MRRL | 6mrrl | 127525 |  | 44886 | 0.3519780435208782 | 0.007141819517186524 | 105729 | 126438 | 66266 | 1054
TOTAL |  | 16629714 | 9272826 | 6284953 | 0.6777818326365662 | 1 | 14563800 | 24286793 | 1296716 | 567111
LINKS |  | # OF | # OF | % OF
TO |  | LOCAL | RECORDS | TOTAL
LOCAL |  | SITES
SITES |  | [NAME]
 |  | 1 | 6284953 | 0.6777818326365662
 |  | 2 | 1239370 | 0.1336561259749725
 |  | 3 | 765679 | 0.08257234633756742
 |  | 4 | 360832 | 0.03891284059465798
 |  | 5 | 230945 | 0.02490556816228407
 |  | 6 | 144467 | 0.01557960863279436
 |  | 7 | 88870 | 0.009583917567309039
 |  | 8 | 54748 | 0.005904133216777712
 |  | 9 | 41553 | 0.004481158171198295
 |  | 10 | 27581 | 0.00297438990012322
 |  | 11 | 19281 | 0.002079301390967543
 |  | 12+ | 14547 | 0.001568777414781643
TOTAL |  |  | 9272826
Spreadsheet: 683754d1592926531-if-formula-not-working-test
Sheet: Data

Status | [NAME] | Description | Blank | Days
 | Plate plant | CHARIOT AUTOMOTEUR Nø24 |  | 80
 | Plate plant | CHARIOT AUTOMOTEUR Nø24 |  | 80
 | Plate plant | CHARIOT AUTOMOTEUR Nø24 |  | 89
 |  |  |  | 120
 | Plate plant | MATERIEL LA PLAINE |  | 60
 | Warehouse | BALAYEUSE EOLE |  | 80
Spreadsheet: 766906d1644159914-drag-a-formula-across-365-columns-skipping-1-row-every-3-columns-dragged-test10-ans-3
Sheet: TAB1

Hour | Day | Night | Hour | Day | Night | Hour | Day | Night
00:00:00 | 8 | 0 | 07:00:00 | 8 | 0 | 07:00:00 | 8 | 0
07:00:00 | U | 0 | 07:00:00 | 8 | 0 | 07:00:00 | 8 | 0
07:00:00 | O | 0 | 07:00:00 | 8 | 0 | 07:00:00 | 8 | 0
07:00:00 | S8 | 0 | 07:00:00 | 8 | 0 | 07:00:00 | 8 | 0
07:00:00 | S12 | 0 | 07:00:00 | 8 | 0 | 07:00:00 | 8 | 0
07:00:00 | P | 0 | 07:00:00 | 8 | 0 | 07:00:00 | 8 | 0
07:00:00 | C | 0 | 07:00:00 | 8 | 0 | 07:00:00 | 8 | 0
07:00:00 | S11 | 0 | 07:00:00 | 8 | 0 | 07:00:00 | 8 | 0
 | All letters are treated as 0:00
Spreadsheet: 63261d1264174675-copy-pasting-column-not-working-venderpivot
Sheet: Sheet1

Vendor # | [NAME] | Amount
456 | Owl [NAME] | 144
456 | Owl [NAME] | 34577
456 | Owl [NAME] | 324234
1432 | [NAME] | 15
2708 | [NAME] | 3
2708 | [NAME] | 565
2708 | [NAME] | 5345
8741 | [NAME] | 744
Sum of Amount
[NAME] | Vendor # | Total
[NAME] | 1432 | 15
[NAME] | 2708 | 5913
Owl [NAME] | 456 | 358955
[NAME] | 8741 | 744
Spreadsheet: 141847d1329481102-share-xls-sheet-report
Sheet: PT

 |  |  |  | Time in Minutes  & NO OF PGS
 | Valeurs
Operator Name | Time in Minutes | NO OF PGS | NO OF PGS/MN
[NAME] | 89.99999999999991 | 80 | 0.8888888888888897
[NAME] | 125.0000000000001 | 105 | 0.8399999999999992
[NAME] | 40.00000000000001 | 20 | 0.4999999999999998
[NAME] | 179.9999999999999 | 80 | 0.4444444444444446
(blank) |  |  | #N/A
Grand Total | 435 | 285 | 0.6551724137931034
Spreadsheet: 855050d1704773034-need-help-with-formulas-to-return-name-from-roster-on-calendar-resource-tracker
Sheet: Mar

 |  |  |  |  |  | CALENDAR MONTH | [NAME]
 |  |  |  |  |  | CALENDAR YEAR
 |  |  |  |  |  | 1ST DAY OF WEEK | MONDAY
daily notes
daily notes
daily notes
daily notes
daily notes
 |  |  | Notes
daily notes
Spreadsheet: 27e1dbf7-f1c1-411a-b889-7c91ea7ccb53
Sheet: 15a

Product1 | Cleared2 | Uncleared | TOTAL
Index Tranche | 60 | 3212
Index
Asia | - | 1648
Europe | 82661 | 37128
North America | 77008 | 73542
Other | 1067 | 1555
OTHER*
Exotic | - | 95
Swaptions | 7562 | 18662
Total Return Swap | - | 6
TOTAL
*OTHER variable includes exotic credit products, swaptions, and total return swaps.
Spreadsheet: 176706d1346078057-indexing-with-duplicates-issue-copy-of-department-position-status-working-file-2
Sheet: Finance

Finance
 | Filled Positions |  |  |  |  |  |  |  |  |  |  |  | Open Positions
 | Title | Location | Category | Hiring Manager | Number of Openings | Number Filled | Date Activated | Date Filled | Start Date | Business Days to Offer | Comments |  |  | Title | Location | Category | Hiring Manager | Created Date | Age | Comments
Spreadsheet: 779858d1652151445-populate-calendars-based-on-office-location-daf-office-scheduling-draft-aligw-1-
Sheet: WFH

Month: | May
Year: | 2022
Sunday | Monday | Tuesday | Wednesday | Thursday | Friday | Saturday
 | 2 | 3 | 4 | 5 | 6 | 7
Spreadsheet: 488695d1478788981-payback-formula-payback
Sheet: NPV

 | Discount Rate |  | 0.08
 | Improvement 1 |  |  | 0
 |  |  |  | 2016 | 2017 | 2018 | 2019 | 2020 | 2021
 | Costs (Investments out) |  |  | -20000
 | Benefits (compensation/savings) |  |  |  | 7000 | 7000 | 7000 | 7000 | 7000
 | Cash Flows
 | Discount Rate
 | Discounted Cash Value
 | NPV (From first Principles)
 | NPV |  |  |  |  |  | Payback
 | Check
Spreadsheet: 456465d1460885448-sumproduct-with-range-increment-distributor-data-february-2016
Sheet: Feb 16

 |  |  |  |  |  |  |  | Total |  |  | AF |  |  | B1 |  |  | B2 |  |  | CP |  |  | C |  |  | e1 |  |  | e2 |  |  | e3 |  |  | e4 |  |  | f1 |  |  | f2 |  |  | f3 |  |  | g1 |  |  | g2 |  |  | g3 |  |  | i |  |  | m |  |  | s |  |  | u
BROKER | [NAME] | a | b | c | d | d | f | Our | Ind | SoW | Our | Ind | SoW | Our | Ind | SoW | Our | Ind | SoW | Our | Ind | SoW | Our | Ind | SoW | Our | Ind | SoW | Our | Ind | SoW | Our | Ind | SoW | Our | Ind | SoW | Our | Ind | SoW | Our | Ind | SoW | Our | Ind | SoW | Our | Ind | SoW | Our | Ind | SoW | Our | Ind | SoW | Our | Ind | SoW | Our | Ind | SoW | Our | Ind | SoW | Our | Ind | SoW
528 | aaaaa |  |  |  |  |  |  | 797.9 | 5219.7 | 0.1528631913711516 |  |  | #N/A | 215.4 | 1322 | 0.1629349470499244 |  | 94.1 | 0 |  | 70.5 | 0 | 0.1 | 18.1 | 0.005524861878453038 | 0.5 | 234.6 | 0.002131287297527707 | 564.7 | 2903.4 | 0.1944961080112971 |  | 237.5 | 0 |  |  | #N/A |  | 1.1 | 0 |  |  | #N/A |  | 0.9 | 0 |  |  | #N/A |  | 1.1 | 0 |  | 41.6 | 0 |  |  | #N/A | 12.4 | 182 | 0.06813186813186814 |  | 21.2 | 0 | 4.8 | 91.6 | 0.05240174672489083
555 | ggg |  |  |  |  |  |  | 797.9 | 5219.7 | 0.1528631913711516 |  |  | #N/A | 215.4 | 1322 | 0.1629349470499244 |  | 94.1 | 0 |  | 70.5 | 0 | 0.1 | 18.1 | 0.005524861878453038 | 0.5 | 234.6 | 0.002131287297527707 | 564.7 | 2903.4 | 0.1944961080112971 |  | 237.5 | 0 |  |  | #N/A |  | 1.1 | 0 |  |  | #N/A |  | 0.9 | 0 |  |  | #N/A |  | 1.1 | 0 |  | 41.6 | 0 |  |  | #N/A | 12.4 | 182 | 0.06813186813186814 |  | 21.2 | 0 | 4.8 | 91.6 | 0.05240174672489083