tianzl66/Sheetpedia huggingface dataset:
Spreadsheet: 858671d1707280724-summary-table-lease-liability-sumif-filter-lease-liability-summary-problem
Sheet: Sheet1

Lease Liability - Data Table
Finance Org | Asset No | Asset Class | 2023-07-31 00:00:00 | 2023-08-31 00:00:00 | 2023-09-30 00:00:00 | 2023-10-31 00:00:00 | 2023-11-30 00:00:00 | 2023-12-31 00:00:00 | 2024-01-31 00:00:00 | 2024-02-29 00:00:00 | 2024-03-31 00:00:00 | 2024-04-30 00:00:00 | 2024-05-31 00:00:00 | 2024-06-30 00:00:00 | 2024-07-31 00:00:00 | 2024-08-31 00:00:00 | 2024-09-30 00:00:00
Bank A | EX01 | EX | 12883.69 | 12883.69 | 12883.69 | 12883.69 | 12883.69 | 12883.69 | 12883.69 | 12883.69 | 12883.69 | 12883.69 | 12883.69 | 12883.69 | 12883.69
Bank C | EX02 | EX | 28975.07 | 28975.07 | 28975.07 | 28975.07 | 28975.07 | 28975.07 | 28975.07 | 28975.07 | 28975.07 | 28975.07 | 28975.07 | 28975.07 | 28975.07 | 28975.07 | 28975.07
Bank B | GR33 | GR | 16403.51 | 16403.51 | 16403.51 | 16403.51 | 16403.51 | 16403.51 | 16403.51 | 16403.51 | 16403.51 | 16403.51
Bank A | DT41 | DT | 21596.13 | 21596.13 | 21596.13 | 21596.13 | 21596.13 | 21596.13 | 21596.13 | 21596.13 | 21596.13 | 21596.13 | 21596.13 | 21596.13
Bank C | WL20 | WL | 14006.89 | 14006.89 | 14006.89 | 14006.89 | 14006.89 | 14006.89 | 14006.89 | 14006.89 | 14006.89 | 14006.89 | 14006.89 | 14006.89 | 14006.89 | 14006.89
Summary Table - Example
Finance Org | Asset No | Asset Class | Date from | Liability
Bank A | EX01 | EX | 2023-09-30 00:00:00 |  | sum of liability from the month after 30/9/23
Bank A | DT41 | DT | 2023-09-30 00:00:00 |  | sum of liability from the month after 30/9/23
Flexability to select Finance Org / Asset No. / Asset Class / Date & or all of the above
The Liability number is the value I am needing to report on.
Summary Table - Example
Finance Org | Asset No | Asset Class | Date from | Liability
Bank A | EX01 | EX | 2023-12-31 00:00:00 |  | sum of liability from the month after 31/12/23
Bank C | EX02 | EX | 2023-12-31 00:00:00 |  | sum of liability from the month after 31/12/23
Spreadsheet: 2079aec6-0517-451a-b778-7c42acf7f5d5
Sheet: Sheet1

FINISH LINE INC /IN/ | Unnamed: 1 | Unnamed: 2
8-K
[NAME]
CURRENT REPORT
Indiana | 0-20184 | 35-1537210
(State or other jurisdiction of incorporation) | (Commission File Number) | (I.R.S. Employer Identification No.)
3308 North Mitthoeffer Road |  | 46235
Indianapolis, Indiana
(Address of principal executive offices) |  | (Zip Code)
____________________________
Created by Morningstar Document Research.
http://documentresearch.morningstar.com/
Spreadsheet: 830962d1685309247-how-to-use-xlookup-with-a-max-date-criteria-sample
Sheet: Sheet1

 |  |  |  |  |  | Result | Result
[NAME] | Value | Value Date |  |  | [NAME] | Value | Value Date
21185 | -1.27 | 2020-12-12 00:00:00 |  |  | 21185 | -1.27 | 2020-12-12 00:00:00
21185 | -0.25 | 2020-10-21 00:00:00 |  |  | 21219
21185 | -0.25 | 2020-09-30 00:00:00 |  |  | 24011
21219 | -1.1 | 2020-12-12 00:00:00 |  |  | 24015
21219 | -0.4 | 2020-08-29 00:00:00 |  |  | 24031
21219 | -1.29 | 2020-04-11 00:00:00
21219 | 0 | 2020-03-05 00:00:00
24011 | -0.95 | 2020-11-10 00:00:00
24011 | 0 | 2020-09-30 00:00:00
24011 | -0.52 | 2020-02-20 00:00:00
24015 | -0.43 | 2020-02-20 00:00:00
24015 | -0.45 | 2020-04-04 00:00:00
24031 | -0.38 | 2020-03-28 00:00:00
24031 | 0.111 | 2020-09-30 00:00:00
24031 | -0.71 | 2020-05-18 00:00:00
21182
21216
24014
24015
24031
Spreadsheet: 33778d1230569650-nested-lookups-or-tieredlookup
Sheet: Sheet1

scale | sales% | points |  |  |  |  | 5 | 10 | 15 | 20 | 25 | 30 | 35 | 40 | 45 | 50
5 | 50 | 0 | 5 | Scale |  | 0 | 0 | 0 | 0 | 0 | 0
5 | 75 | 3 | 77 | % |  | 50 | 0 | 0 | 5 | 7 | 10
5 | 100 | 5 | 3 | Points |  | 75 | 3 | 7 | 10 | 10 | 12
10 | 50 | 0 |  |  |  | 100 | 5 | 10 | 15 | 15 | 18
10 | 75 | 7
10 | 100 | 10
15 | 50 | 5
15 | 75 | 10
15 | 100 | 15
20 | 50 | 7
20 | 75 | 10
20 | 100 | 15
25 | 50 | 10
25 | 75 | 12
25 | 100 | 18
30 | 50
30 | 75
30 | 100
35 | 50
35 | 75
35 | 100
40 | 50
40 | 75
40 | 100
45 | 50
45 | 75
45 | 100
50 | 50
50 | 75
50 | 100
Spreadsheet: 886874d1736971365-importing-data-from-one-tab-into-a-template-audit-trial
Sheet: Sheet1

MULTI-RESIDENTIAL FEL CONTRACT MANAGEMENT - SITE AUDIT
Date: |  |  |  |  |  |  |  | Name of Project Lead:
[NAME]: |  |  |  |  |  |  | Sunny                              Overcast                              Rain                            Snow
Temperature: |  |  |  |  |  |  |  | Normal                             Extreme Heat                             Extreme cold
Collection Day |  | Site Product Inspection |  |  |  |  |  | Communication / Instructions to PM / Superintendant
 |  |  | Material
Mon |  |  | Garbage
Tue |  |  | Organics
Wed |  |  | Recycle
Thu |  |  | Bulky
Fri |  |  | DGMS
INSPECTIONS
Address |  |  |  |  |  |  | Conditions of Bins |  |  |  | Contamination |  |  |  |  | Access issues to Compound |  |  |  | Organic Services
 |  |  |  |  |  |  | Good |  | Poor |  | Yes |  | No |  |  | Yes |  | No |  | Yes | No
Comments:
MULTI-RESIDENTIAL FEL CONTRACT MANAGEMENT - SITE AUDIT
Date: |  |  |  |  |  |  |  | Name of Project Lead:
[NAME]: |  |  |  |  |  |  | Sunny                              Overcast                              Rain                            Snow
Temperature: |  |  |  |  |  |  |  | Normal                             Extreme Heat                             Extreme cold
Collection Day |  | Site Product Inspection |  |  |  |  |  | Communication / Instructions to PM / Superintendant
 |  |  | Material
Mon |  |  | Garbage
Tue |  |  | Organics
Wed |  |  | Recycle
Thu |  |  | Bulky
Fri |  |  | DGMS
INSPECTIONS
Address |  |  |  |  |  |  | Conditions of Bins |  |  |  | Contamination |  |  |  |  | Access issues to Compound |  |  |  | Organic Services
 |  |  |  |  |  |  | Good |  | Poor |  | Yes |  | No |  |  | Yes |  | No |  | Yes | No
Comments:
Spreadsheet: 4547bdc9-d899-42f0-b282-9085d641ac92
Sheet: Back-End

Key Stats
Key Stats |  |  |  |  |  |  |  |  |  | Office
 | Owned | Leased | Owned | Leased |  |  |  |  |  | Office
 |  |  |  |  |  |  |  |  |  | Office | 2011 | 2012
2011 |  |  |  |  |  |  |  |  |  | Civilian Agencies
2012 |  |  |  |  |  |  |  |  |  | Defense Agencies
 |  |  |  |  |  |  |  |  |  | Total CFO Act
 |  |  |  |  |  |  |  |  |  | Warehouse
Cost per SF |  |  |  |  |  |  |  |  |  | Warehouse
Cost per GSF |  |  |  |  |  |  |  |  |  | Agency | FY 2011 | FY 2012
 | Owned | Leased |  |  |  |  |  |  |  | Civilian
FY 2008 | 0 | 0 |  |  |  |  |  |  |  | Defense
FY 2009 |  |  |  |  |  |  |  |  |  | Total
FY 2010
FY 2011
FY 2012 |  |  |  |  |  |  |  |  |  | StructureUsee
 |  |  |  |  |  |  |  |  |  | Structure USE
Building Use |  |  |  |  |  |  |  |  |  |  | Owned | Leased
Building Use |  |  |  |  |  |  |  |  |  | Utility Systems | 92965 | 4645
Office |  |  |  |  |  |  |  |  |  | All Other | 87424 | 2662
Service |  |  |  |  |  |  |  |  |  | Roads and [NAME] | 46703 | 867
All Other**** |  |  |  |  |  |  |  |  |  | Recreational (other than buildings) | 42597 | 746
Dormitories/Barracks |  |  |  |  |  |  |  |  |  | [NAME] | 38478 | 1837
School |  |  |  |  |  |  |  |  |  | Miscellaneous Military Facilities | 33461 | 965
Other Institutional Uses |  |  |  |  |  |  |  |  |  | Storage (other than buildings) | 30194 | 1167
Laboratories |  |  |  |  |  |  |  |  |  | Navigation and Traffic Aids (other than buildings) | 26390 | 371
Warehouses |  |  |  |  |  |  |  |  |  | Communications Systems | 12202 | 1930
All Remaining Uses |  |  |  |  |  |  |  |  |  | Service (other than buildings) | 12047 | 515
 |  |  |  |  |  |  |  |  |  | Reclamation and Irrigation | 11873 | 125
AOC/GSF |  |  |  |  |  |  |  |  |  | All Remaining Use Categories | 34655 | 1047
AOC/SF
FY 2011 | FY 2012
Spreadsheet: 0f159fdd-e5ae-41e4-ab59-d4dfff4c77ca
Sheet: Sheet1

9311 unaligned sequence: | Unnamed: 1 | Unnamed: 2 | Unnamed: 3 | assembled size:
 |  |  |  | 98849075
 |  | Total (bp) | % of data set | % of repeats
Simple repeats | SSRs | 1568689 | 1.586953646253139 | 6.061142664194384
 | Low_complexity | 1003965 | 1.01565442064076 | 3.879146914944846
 | Subtotal | 2572654 | 2.602608066893898 | 9.940289579139229
Class I | LINEs | 546856 | 0.5532231839296422 | 2.112956891245291
 | SINEs | 66511 | 0.06728540454222763 | 0.2569869870562187
 | gypsy-like | 13545477 | 13.7031904446248 | 52.33737761376777
 | copia-like | 3194753 | 3.2319503242696 | 12.34397239342088
 | Subtotal | 17353597 | 17.55564935736627 | 67.05129388549015
Class II | Ac/Ds TEs | 100506 | 0.1016762170005132 | 0.3883377805336308
 | En/Spm TEs | 266403 | 0.2695047980975037 | 1.02933506206098
 | MULEs | 2003657 | 2.026986089652331 | 7.741783697795884
 | Subtotal | 2370566 | 2.398167104750348 | 9.159456540390494
Class III | Stowaway-like | 1440615 | 1.457388447995087 | 5.566286905293779
 | Tourist-like | 1940943 | 1.963541894549848 | 7.49946766125691
 | Unknown MITEs | 202702 | 0.205062111102203 | 0.7832054284294274
 | Subtotal | 3584260 | 3.625992453647138 | 13.84895999498012
 | Grand Total | 25881077 | 26.18241698265765 | 100
Spreadsheet: 136403d1326619250-how-to-lookup-two-random-strings-from-text-book1
Sheet: Sheet1

column A | Column B |  |  | find this string in column A | return this label to column B
ATW AARPRE SENS2342 | CASH WITHDRAWAL |  |  | ATW | CASH WITHDRAWAL
ECS DR SUNDMF 20112011 CAMS-[PHONE] | MF SUND FUND |  |  | ECS SUND | MF SUND FUND
ECS DR TP DSPBRMF-[PHONE] | MF DSP FUND |  |  | ECS DSP | MF DSP FUND
ECS DR IILECS - HDFC MF-[PHONE] | MF HDFC FUND |  |  | ECS HDFC | MF HDFC FUND
ATW-5264190205285926 -SAHAR PLAZA | CASH WITHDRAWAL |  |  | CC 6511 | CREDIT CARD 6511
CC 5243XXXXXXXX6511 autopay SI-TAD | CREDIT CARD 6511 |  |  | SAL | [NAME]
[NAME] | [NAME]
strings may be just one set of 3 alpabets like ATW
Or may be a combination like ECS and SUND
String maybe or may not be the first 3 alphabets
Spreadsheet: 270116d1381387371-can-i-get-a-list-with-unique-products-fullperiodreport-1
Sheet: Sheet2

LILA | [NAME] code | Total Quantites | total price | color np | color nk | color 050 | color 301 | color 302 | … | … | … | … | …
LPR | 080000 | 25 | 3225 | 5 | 5 | 10 | 2 | 3
LSR | 080030 | 30 | 322522 | 6 | 4 | 2 | 10 | 8
LSR | 080040 | 14 | 3223 | 9 |  | 5
LZI | 040040 | 36 | 321214 | 20 |  | 4 | 2 | 10
LZI | 080030 | 17 | 654 | … | … | … | … | …
LZI | 100030 | 20 | 322563 | … | … | … | … | …
LZV | 048040 | 15 | 65546 | … | … | … | … | …
LZV | 188030 | 30 | 25252 | … | … | … | … | …
LAP | 060050 | 35 | 636 | … | … | … | … | …
LAP | 060070 | 68 | 3332 | … | … | … | … | …
LAP | 060080 | 10 | 3266 | … | … | … | … | …
Spreadsheet: 129936d1321979877-pivot-tables-volunteer-feedback-data
Sheet: data

Volunteer feedback data
 |  | Q1 | When you applied to be a volunteer were you? 1=Employed Full time 2=Employed part time 3=self employed 4=retired 5=in full time education 6=unemployed 7=other
ID# | Q1
1 | 5
2 | 6
3 | 6
4 | 2
5 | 2
6 | 2
7 | 6
8 | 6
9 | 5
Spreadsheet: 145761d1331736064-sumproduct-range-of-cells-selling-price-test-3-
Sheet: Sheet1

MATERIAL | R/R
DESIGN | 18 3D |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | FINAL SELLING PRICE |  |  |  |  |  |  |  |  |  | FINAL SELLING PRICE |  |  |  |  |  |  |  |  |  | FINAL SELLING PRICE |  |  |  |  |  |  |  |  |  | FINAL SELLING PRICE |  |  |  |  |  |  |  |  |  | FINAL SELLING PRICE |  |  |  |  |  |  |  |  |  | FINAL SELLING PRICE
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | CAT A | CAT B | CAT C | CAT D |  | CAT A | CAT B | CAT C | CAT D |  | CAT A | CAT B | CAT C | CAT D |  | CAT A | CAT B | CAT C | CAT D |  | CAT A | CAT B | CAT C | CAT D |  | CAT A | CAT B | CAT C | CAT D |  | CAT A | CAT B | CAT C | CAT D |  | CAT A | CAT B | CAT C | CAT D |  | CAT A | CAT B | CAT C | CAT D |  | CAT A | CAT B | CAT C | CAT D |  | CAT A | CAT B | CAT C | CAT D |  | CAT A | CAT B | CAT C | CAT D
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | R/R |  |  |  |  | R/R |  |  |  |  | M R/W |  |  |  |  | M R/W |  |  |  |  | C W/W |  |  |  |  | C W/W |  |  |  |  | R/R |  |  |  |  | R/R |  |  |  |  | M R/W |  |  |  |  | M R/W |  |  |  |  | C W/W |  |  |  |  | C W/W
DIMENSIONS |  |  | 18mm |  |  |  |  | 25mm |  |  |  | TOTAL | TOTAL |  |  |  |  |  | 18 3D |  |  |  |  | 18 2D |  |  |  |  | 18 3D |  |  |  |  | 18 2D |  |  |  |  | 18 3D |  |  |  |  | 18 2D |  |  |  |  | 25 3D |  |  |  |  | 25 2D |  |  |  |  | 25 3D |  |  |  |  | 25 2D |  |  |  |  | 25 3D |  |  |  |  | 25 2D
W | H | D | CAT A | CAT B | CAT C | CAT D |  | CAT A | CAT B | CAT C | CAT D |  | 18mm | 18mm | 18mm | 25mm | 25mm | 25mm
 |  |  |  |  |  |  |  |  |  |  |  |  | R/R | M W/W | C W/W | R/R | M W/W | C W/W | € | € | € | € |  | € | € | € | € |  | € | € | € | € |  | € | € | € | € |  | € | € | € | € |  | € | € | € | € |  | € | € | € | € |  | € | € | € | € |  | € | € | € | € |  | € | € | € | € |  | € | € | € | € |  | € | € | € | €
400 | 700 | 550 | 1 |  |  |  |  | 1 |  |  |  | 25 | 10 | 22 | 40 | 15 | 30 | 50 | 10 | 12 | 14 | 16 |  | 12 | 14 | 16 | 18 |  | 22 | 24 | 26 | 28 |  | 25 | 27 | 29 | 31 |  | 40 | 42 | 44 | 46 |  | 45 | 47 | 49 | 51 |  | 15 | 17 | 19 | 21 |  | 18 | 20 | 22 | 24 |  | 30 | 32 | 34 | 36 |  | 35 | 37 | 39 | 41 |  | 50 | 52 | 54 | 56 |  | 52 | 54 | 56 | 58
450 | 700 | 550 | 1 |  |  |  |  | 1 |  |  |  | 29 | 12 | 24 | 42 | 17 | 32 | 52 | 12 | 14 | 16 | 18 |  | 14 | 16 | 18 | 20 |  | 24 | 26 | 28 | 30 |  | 27 | 29 | 31 | 33 |  | 42 | 44 | 46 | 48 |  | 47 | 49 | 51 | 53 |  | 17 | 19 | 21 | 23 |  | 20 | 22 | 24 | 26 |  | 32 | 34 | 36 | 38 |  | 37 | 39 | 41 | 43 |  | 52 | 54 | 56 | 58 |  | 54 | 56 | 58 | 60
500 | 700 | 550 | 1 |  |  |  |  | 1 |  |  |  | 33 | 14 | 26 | 44 | 19 | 34 | 54 | 14 | 16 | 18 | 20 |  | 16 | 18 | 20 | 22 |  | 26 | 28 | 30 | 32 |  | 29 | 31 | 33 | 35 |  | 44 | 46 | 48 | 50 |  | 49 | 51 | 53 | 55 |  | 19 | 21 | 23 | 25 |  | 22 | 24 | 26 | 28 |  | 34 | 36 | 38 | 40 |  | 39 | 41 | 43 | 45 |  | 54 | 56 | 58 | 60 |  | 56 | 58 | 60 | 62
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 1
 |  |  |  |  | TOTAL ROWS ARE ABOUT 2000
Spreadsheet: chris_dorland__1601__holst
Sheet: Sheet1

 | Sumas | Aeco
 | Basis | Basis
2002-03-01 00:00:00 | -0.235 | -0.27
2002-04-01 00:00:00 | -0.325 | -0.385
2002-05-01 00:00:00 | -0.325 | -0.385
2002-06-01 00:00:00 | -0.325 | -0.385
2002-07-01 00:00:00 | -0.405 | -0.4
2002-08-01 00:00:00 | -0.405 | -0.4
2002-09-01 00:00:00 | -0.405 | -0.4
2002-10-01 00:00:00 | -0.295 | -0.385
2002-11-01 00:00:00 | -0.055 | -0.345
2002-12-01 00:00:00 | 0.185 | -0.345
2003-01-01 00:00:00 | 0.23 | -0.345
2003-02-01 00:00:00 | 0.24 | -0.345
2003-03-01 00:00:00 | -0.315 | -0.345
Spreadsheet: 792009d1660691042-offset-formula-to-calculate-rolling-average-returns
Sheet: returns

Date | TSLA | MSFT | TSLA | MSFT
2022-01-01 00:00:00 | -0.007322175732217606 | 0.004288350884811498 |  |  |  |  |  |  | 3
2022-01-02 00:00:00 | 0.009132420091324311 | 0.01302632290146466
2022-01-03 00:00:00 | -0.01079011486251302 | -0.008323551381922867
2022-01-04 00:00:00 | -0.02533427163969049 | -0.001990745722586951
2022-01-05 00:00:00 | 0.02021660649819501 | -0.004366812227074246
2022-01-06 00:00:00 | 0.003538570417551234 | -0.001841022308858631
2022-01-07 00:00:00 | 0.0165726375176305 | -0.001410437235543016
2022-01-08 00:00:00 | -0.004162330905306932 | 0.007877009995653994
2022-01-09 00:00:00 | 0.016370602577499 | 0.01735568371691909
2022-01-10 00:00:00 | 0.009252912954078152 | 0.01324503311258285
2022-01-11 00:00:00 | -0.01188455008488953 | -0.02290196078431372
2022-01-12 00:00:00 | 0.05773195876288661 | -0.02627495050034778
2022-01-13 00:00:00 | -0.02469135802469136 | -0.02495053857990781
Spreadsheet: 715428d1611697724-sum-n-count-of-values-in-rows-sum-first-5-numbers
Sheet: Sheet1

Column 1 | Column 2 | Column 3 | Column 4 | Column 5 | Column 6 | Column 7 | Column 8 | Column 9 | Column 10 | Column 11 | Column 12 | Column 13 | Column 14 | Column 15 | Column 16 | Column 17 | Column 18 | Column 19 | Column 20 | [NAME] in this column to sum first 5 values in each row.
1 |  | 2 |  | 5 |  | 8 | 8 | 7 | 8 |  | 5 |  |  | 6 |  | 5 |  | 8 | 1
5 | 2 |  | 4 |  | 7 | 8 |  | 2 | 2 | 2 |  |  | 8 |  | 3 | 1 | 1 |  | 7
 |  | 8 |  |  |  | 2 | 8 |  | 3 |  | 3 |  | 7 |  |  | 9 |  | 4
5 |  |  | 8 | 7 | 8 |  | 5 | 5 |  |  | 8 | 7 | 8 |  | 5
 | 7 | 8 |  | 2 | 2 | 2 |  |  | 7 |  |  | 2 | 2 | 2 |  |  | 5 | 5
 |  | 2 | 8 |  | 3 |  | 3 |  |  | 2 | 8 |  | 3 |  | 3 | 2 |  |  | 7
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 3
 |  |  |  |  |  |  | 8 | 7 | 8 |  | 5
 |  |  |  |  | 7 | 8 |  | 2 | 2 | 2 |  |  | 8
 |  |  |  |  |  | 2 | 8 |  |  |  | 3 |  | 2 | 2 | 8 |  | 5 | 5
 |  |  |  |  | 5 |  | 8 | 8 |  | 8 |  | 5 | 3 |  | 2 | 2 |  |  | 7
 |  |  |  |  | 5 |  |  | 8 | 7 | 8 |  | 5 |  |  | 3 |  | 3
 |  |  |  |  |  | 7 | 8 |  | 2 | 2 | 2 |  | 8
 |  |  |  |  |  |  | 2 | 8 |  | 3 |  | 3 | 2 | 2 | 8 |  | 5 | 5
 |  |  |  |  |  |  |  |  |  |  |  |  | 3 |  | 2 | 2 |  |  | 7
5 |  | 8 | 8 | 7 |  |  |  |  |  |  |  |  |  |  | 3 |  | 3
 | 7 |  |  | 2
Spreadsheet: 110817d1307413793-search-and-match-search
Sheet: Search File

No. | Items | Description | Serial No. | Internal Reference No | Project or Hostname | Location
1 | Pulsar EX10 | UPS | 4239063T8 | 6 | --- | #01-01G
2 | Pulsar EX10 | UPS | 4239063T4 | 8 | --- | #01-01G
3 | Pulsar EX10 | UPS | 4239063T2 | 9 | --- | #01-01G
4 | IBM Monitor | Monitor | 66-VNR96 | 11 | --- | #01-01G
5 | Victron Net UPS | UPS | 9720A013 | 13 | --- | #01-01G
Spreadsheet: 705521d1606162947-need-help-please-in-distributing-a-number-across-a-date-in-multiple-cells-distribute-number
Sheet: Sheet1

DATE
2020-09-01 |  |  |  |  | Qty
2020-09-01 |  |  |  | 2020-09-01 | 587
2020-09-01 |  |  |  | 2020-09-02 | 869
2020-09-01 |  |  |  | 2020-09-03 | 741
2020-09-01
2020-09-01
2020-09-01
2020-09-01
2020-09-01
2020-09-01
2020-09-01
2020-09-01
2020-09-01
2020-09-01
2020-09-01
2020-09-01
2020-09-01
2020-09-01
2020-09-02
2020-09-03
2020-09-04
2020-09-05
2020-09-06
2020-09-07
2020-09-08
2020-09-09
2020-09-10
Spreadsheet: 216800d1361892391-filter-through-multiple-tabs-to-show-in-new-tab-wawf-gfebs-invoices-fy13-plan-b
Sheet: W912LP-09-P-0248

CONTRACT # | PO # | CAGE CODE | PAYMENT NUMBER | LINE ITEM # | LINE ITEM QUANTITY | WAWF INV # | DATE INV SUBMITTED | DATE INV RECEIVED | DOC DATE | AMOUNT | OUR STATUS | GFEBS # | 103 | 103 DATE | 105 | 105 DATE | DOV  # (Disbursing #) | DOV DATE | INTEREST  ? | TRACE #
W912LP-09-P-0248 |  | 4W999 |  |  |  | 392081 | REJECTED | 2012-11-16 00:00:00 |  | 169 | REVERSED
W912LP-09-P-0248 |  | 4W999 |  |  |  | 395060 | REJECTED | 2012-11-16 00:00:00 |  | 169 | REVERSED
W912LP-09-P-0248 |  | 4W999 |  |  |  | 392028 | REJECTED | 2012-11-19 00:00:00 |  | 169 | REVERSED
W912LP-09-P-0248 |  | 4W999 |  |  |  | 392098 | REJECTED | 2012-11-19 00:00:00 |  | 169 | REVERSED
W912LP-09-P-0248 |  | 4W999 |  |  |  | 395000 | REJECTED | 2012-11-19 00:00:00 |  | 169 | REVERSED
W912LP-09-P-0248 |  | 4W999 |  |  |  | 395105 | REJECTED | 2012-11-19 00:00:00 |  | 169 | REVERSED
W912LP-09-P-0248 |  | 4W999 |  |  |  | 397667 | REJECTED | 2012-11-19 00:00:00 |  | 169 | REVERSED
W912LP-09-P-0248 |  | 4W999 |  |  |  | 397696 | REJECTED | 2012-11-19 00:00:00 |  | 169 | REVERSED
W912LP-09-P-0248 |  | 4W999 |  |  |  | 397706 | REJECTED | 2012-11-19 00:00:00 |  | 169 | REVERSED
W912LP-09-P-0248 |  | 4W999 | 1P |  |  | 392028A | 2012-12-05 00:00:00 | 2012-12-05 00:00:00 |  | 169 | WAITING 103
W912LP-09-P-0248 |  | 4W999 |  |  |  | 392081A | 2012-12-05 00:00:00 | 2012-12-05 00:00:00 |  | 169 | WAITING 103
W912LP-09-P-0248 |  | 4W999 |  |  |  | 392098A | 2012-12-05 00:00:00 | 2012-12-05 00:00:00 |  | 169 | WAITING 103
W912LP-09-P-0248 |  | 4W999 |  |  |  | 395000A | 2012-12-05 00:00:00 | 2012-12-05 00:00:00 |  | 169 | WAITING 103
W912LP-09-P-0248 |  | 4W999 |  |  |  | 395060A | 2012-12-05 00:00:00 | 2012-12-05 00:00:00 |  | 169 | WAITING 103
W912LP-09-P-0248 |  | 4W999 |  |  |  | 395105A | 2012-12-05 00:00:00 | 2012-12-05 00:00:00 |  | 169 | WAITING 103
W912LP-09-P-0248 |  | 4W999 |  |  |  | 397667A | 2012-12-05 00:00:00 | 2012-12-05 00:00:00 |  | 169 | WAITING 103
W912LP-09-P-0248 |  | 4W999 |  |  |  | 397696A | 2012-12-05 00:00:00 | 2012-12-05 00:00:00 |  | 169 | WAITING 103
W912LP-09-P-0248 |  | 4W999 |  |  |  | 397706A | 2012-12-05 00:00:00 | 2012-12-05 00:00:00 |  | 169 | WAITING 103
W912LP-09-P-0248 |  | 4W999 |  |  |  | 400193 | 2012-12-05 00:00:00 | 2012-12-05 00:00:00 |  | 169 | WAITING 103
W912LP-09-P-0248 |  | 4W999 |  |  |  | 400219 | 2012-12-05 00:00:00 | 2012-12-05 00:00:00 |  | 169 | WAITING 103
W912LP-09-P-0248 |  | 4W999 |  |  |  | 400224 | 2012-12-05 00:00:00 | 2012-12-05 00:00:00 |  | 169 | WAITING 103
W912LP-09-P-0248 |  |  |  |  |  |  |  |  | TOTAL
RETURN
Spreadsheet: 141702d1329404694-conditional-formatting-with-lookup-formula-tt-index-copy
Sheet: Charts

 | Training Hours by Group
 | Year | (All)
 | Department | (All)
 | Sum of Hours | Group
 |  | Dublin  C232 | Belfast C213 | Clones C212 | Newry C274 | Derry C260 | Roscommon C267 | Limerick C244 | Cork C245 | Athlone C216 | Retail | Wexford C247 | [NAME] | Tralee C269 | Waterford C283 | Carlow C262 | Telford F230 | Manchester F236 | Galway C246 | [NAME] | Thurles C275 | Castlebar C285 | Garage | National | [NAME] T212 | Newtownbutler | Sales | Maintenance | Clonee
 | Total | 543 | 518 | 162 | 110 | 107 | 103 | 81 | 75 | 74 | 74 | 66 | 66 | 63 | 57 | 49 | 40 | 40 | 39 | 39 | 35 | 30 | 28 | 27 | 3 | 2 | 2 | 0 | 0
Spreadsheet: 863006d1710576410-simple-sumif-not-working-sumif-question-ans
Sheet: Sheet1

Name | Jan  Simple | Feb  Simple | [NAME] | Jan  Detailed | Feb  Detailed | [NAME] | # [NAME] | # [NAME] Detailed |  |  |  | [NAME] | Sue | [NAME]
[NAME] | 0 | 0 | 0 | 0 | 0 | 0 |  |  |  |  | Total Simple
[NAME] | 0 | 0 | 0 | 0 | 1 | 0 |  |  |  |  | Total Detailed
[NAME] | 1 | 0 | 0 | 0 | 0 | 0 |  |  |  |  | Grand Total
[NAME] | 0 | 0 | 0 | 0 | 0 | 0
[NAME] | 0 | 0 | 0 | 0 | 0 | 0
[NAME] | 0 | 0 | 0 | 0 | 0 | 0 |  |  |  |  | Why does this formula not work?  I think I should get 2 for [NAME], 3 for [NAME] and 5 for [NAME]
Sue | 0 | 0 | 0 | 0 | 0 | 0 |  |  |  |  | [NAME] |  |  |  |  |  | =SUMIF(A2:A25,"Jim",H2:I25)
Sue | 0 | 0 | 0 | 0 | 0 | 0 |  |  |  |  | Sue |  | 3 |  |  |  | =SUMIF(A2:A25,"Sue",H2:I25)
Sue | 0 | 0 | 0 | 0 | 0 | 0 |  |  |  |  | [NAME] |  | 5 |  |  |  | =SUMIF(A2:A25,"John",H2:I25)
Sue | 0 | 0 | 0 | 0 | 0 | 0
Sue | 0 | 0 | 0 | 0 | 0 | 1
Sue | 1 | 1 | 0 | 0 | 0 | 0
Sue | 0 | 0 | 0 | 0 | 0 | 0
Sue | 0 | 0 | 0 | 0 | 0 | 0
[NAME] | 0 | 0 | 0 | 0 | 0 | 0
[NAME] | 0 | 0 | 0 | 0 | 1 | 0
[NAME] | 0 | 0 | 0 | 0 | 0 | 0
[NAME] | 0 | 0 | 0 | 0 | 0 | 0
[NAME] | 1 | 1 | 0 | 0 | 1 | 0
[NAME] | 0 | 0 | 0 | 0 | 0 | 0
[NAME] | 0 | 0 | 0 | 0 | 0 | 0
[NAME] | 0 | 0 | 0 | 0 | 0 | 0
[NAME] | 0 | 0 | 0 | 0 | 1 | 0
[NAME] | 0 | 0 | 0 | 0 | 0 | 0
Spreadsheet: phillip_m_love__30650__9906_OA
Sheet: TOTAL

ENRON CAPITAL & TRADE RESOURCES
OPERATIONAL ANALYSIS - CONSOLIDATED VARIANCE
COMPANY:  ALL
REGION: ALL
 |  |  | Reported |  | Actuals |  | [NAME]
 |  |  | 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
FT-Ontario
 |  | Current Month MTM
 |  | Financial Liquidations
 |  | Originations
 |  | TOTAL FIRM TRADING
 |  | TOTAL GL