tianzl66/Sheetpedia huggingface dataset:
Spreadsheet: bc1782e1-96ea-4245-afed-c3f3b5bfe084
Sheet: Sheet1

LABEL | UPC | ARTIST | TITLE | RELEASEDATE | PRODUCTTYPE | GENRE | PRICE | [NAME] | STATUS
Metro One | 74948816122 | T-Bone | [NAME], [NAME] [ | 2002-01-08 | Compact Disc | Rap | 13.99 | N | To Be Retired
Metro One | 74948117229 | T-Bone | Redeemed Hoodlum - Cds [ | 2001-11-06 | Compact Disc | Rap | 13.99 | N | To Be Retired
Spreadsheet: 581550d1531374831-extract-data-to-another-data-sheet-production-report-new-copy
Sheet: D_Prod Report

 | 2018-09-01 00:00:00
 |  | Order # | Ø | PRODUCT |  | TIME |  | ACHIEVED QTY. | STD QTY PER HOUR |  | % | REMARKS |  |  |  |  |  |  |  | CARDER | REJECTS
1 | General [NAME] 01 | 1234 | 111 | abche |  | 07:30:00 | 19:00:00 | 13500 | 1350 |  | 1 | * Order completed. |  |  |  |  |  |  |  | 10 | 136
2
3 | General [NAME] 02 | 2345 | 222 | bcdef |  | 07:30:00 | 17:15:00 | 6000 | 600 |  | 1.212121212121212
4
5 | General [NAME] 03 | 3456 | 333 | cdefg |  | 07:30:00 | 19:00:00 | 3000 | 400 |  | 0.75
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
 | DAILY TOTAL |  |  | 22500 |  |  |  |  |  | TARGET FOR MONTH
 | CUMULATIVE TOTAL |  |  | 36500 |  |  |  |  |  | BALANCE TO BE ACHIEVED |  |  |  | -36500
 | LINE | grms. | PRODUCT |  |  | TIME | ACHIEVED QTY. | DAMAGE
1
2
3
4
 |  |  |  |  |  | .
Spreadsheet: 169384d1342801347-arranging-information-into-tables-new-problem-1
Sheet: Summary

Summary
 | A | B | C | D |  | Sheet | A | B | C | D
1 | Inlet works | Grit removal | Flow | Sampling |  | 1 | 3 | 2 | 1 | 1
2 | [NAME] | Quality of grit | Outlet works | Channels |  | 2 | 5 | 3 | 3 | 3
3 | Channels | Flow | Sampling Equipment | Screen Opereration |  | 3 | 7 | 4 | 5 | 5
4 | Effluent Quality | Flow | Outlet works | Channels |  | 4 | 9 | 5 | 7 | 7
5 | Solids Levels | Flow | Sampling Equipment | Screen Opereration |  | 5 | 11 | 6 | 9 | 9
6 | Effluent Quality | AB | Outlet works | Channels
7 | Solids Levels |  | Sampling Equipment | Screen Opereration
8 | Effluent Quality |  | X | Y
9 | Solids Levels |  | AA | AD
10 | Z
11 | AC
12
13
14
15
16
17
18
19
20
21
22
23
Spreadsheet: 755383d1636822827-index-match-3-lookups-lookup-2007
Sheet: Planilha1

DATE | COL1 | COL2 | [NAME]
2017-06-05 00:00:00 | furpgZ | lrfuf | v[txZ |  |  |  | =LOOKUP(A5&B5&D5,A2:A10&B2:B10&D2:D10,C2:C10)
2017-06-06 00:00:00 | e`qck^ | [[vqi | mlp[\
2017-06-07 00:00:00 | ess`_j | rlp[x | eogii
2017-06-08 00:00:00 | [NAME] | \[gfg | ]lexn
2017-06-09 00:00:00 | `nhama | wpvm\ | pq[vg
2017-06-10 00:00:00 | fbiq\f | ug`ob | wxl_^
2017-06-11 00:00:00 | qlemj] | [brs` | trlth
2017-06-12 00:00:00 | wbba[^ | hppwp | bpmbc
2017-06-13 00:00:00 | ehZkne | [NAME] | \cmdq
Spreadsheet: kate_symes__18404__Cob
Sheet: DJ COB Electricity Index

 |  |  | Firm | Volume | Firm | Volume | Non Firm | Volume | Non Firm | Volume |  | Sunday & NERC | Volume
 | DATE |  | On [NAME] | [NAME] | [NAME] | [NAME] | On [NAME] | [NAME] | [NAME] | [NAME] |  | 24 HOUR | [NAME]
 | 2000-12-29 00:00:00 |  | 219.29 | 5600 | 180 | 296
 | 2000-12-28 00:00:00 |  | 219.29 | 5600 | 180 | 296 | 205.42 | 300 | 181.32 | 285
 | 2000-12-27 00:00:00 |  | 396.43 | 2800 | 255 | 200 | 176.08 | 3130 | 186.7 | 684
 | 2000-12-26 00:00:00 |  | 461.25 | 1600 | 442.5 | 0 | 185 | 65 | 200 | 0
 | 2000-12-25 00:00:00 |  |  |  |  |  |  |  | 300 | 600
 | 2000-12-24 00:00:00 |  |  |  |  |  |  |  | 336.11 | 450
 | 2000-12-23 00:00:00 |  | 470.93 | 3440 | 311.96 | 1528 | 500 | 825 | 250 | 25
 | 2000-12-22 00:00:00 |  | 474.38 | 3200 | 290.77 | 1408 | 484.27 | 1335 | 300 | 25
 | 2000-12-21 00:00:00 |  | 476.11 | 3600 | 290.77 | 1408 | 500 | 1175 | 450 | 600
 | 2000-12-20 00:00:00 |  | 465.71 | 2800 | 375 | 200 | 529.93 | 2100 | 550 | 200
 | 2000-12-19 00:00:00 |  | 450 | 2400 | 346.89 | 1608 | 477.03 | 1720 | 210 | 697
 | 2000-12-18 00:00:00 |  | 377 | 2000 | 325 | 400 | 593.64 | 3048 | 423.21 | 1126
 | 2000-12-17 00:00:00 |  |  |  |  |  |  |  | 551.77 | 2065 |  | 325 | 600
 | 2000-12-16 00:00:00 |  | 306.88 | 3200 | 255.53 | 1808 | 587.5 | 1400 | 537.5 | 1200
 | 2000-12-15 00:00:00 |  | 306.88 | 3200 | 255.53 | 1808 | 571.38 | 3975 | 517.59 | 3375
 | 2000-12-14 00:00:00 |  | 484.61 | 5200 | 256.22 | 1608 | 654.11 | 730 | 437.04 | 1340
 | 2000-12-13 00:00:00 |  | 688.24 | 6800 | 500 | 200 | 454.83 | 6475 | 350 | 100
 | 2000-12-12 00:00:00 |  | 818.75 | 3200 | 300 | 200 | 800 | 0 | 600 | 0
 | 2000-12-11 00:00:00 |  | 3200 | 2800 | 1187.5 | 400 | 597.15 | 1192 | 561.22 | 245
 | 2000-12-10 00:00:00 |  |  |  |  |  |  |  | 740.4 | 5823 |  | 1187.5 | 1200
 | 2000-12-09 00:00:00 |  | 714.44 | 3600 | 400 | 200 | 450 | 450 | 487.5 | 0
 | 2000-12-08 00:00:00 |  | 714.44 | 3600 | 400 | 200 | 325 | 630 | 487.5 | 0
 | 2000-12-07 00:00:00 |  | 679.17 | 2400 | 412.5 | 400 | 505.96 | 235 | 320.47 | 265
 | 2000-12-06 00:00:00 |  | 357.3 | 9600 | 275 | 800 | 342 | 858 | 237.5 | 200
 | 2000-12-05 00:00:00 |  | 278.47 | 7600 | 245 | 200 | 388 | 125 | 237.5 | 0
 | 2000-12-04 00:00:00 |  | 283.12 | 10000 | 255 | 400 | 281.5 | 0 | 255 | 0
 | 2000-12-03 00:00:00 |  |  |  |  |  |  |  | 224 | 375 |  | 255 | 1200
 | 2000-12-02 00:00:00 |  | 270.77 | 12400 | 215 | 200 | 220 | 50 | 200 | 250
 | 2000-12-01 00:00:00 |  | 270.23 | 12800 | 215 | 200 | 246.54 | 517 | 217.5 | 0
 | 2000-11-30 00:00:00 |  | 253.35 | 6800 | 197.33 | 600 | 241.09 | 238 | 205 | 200
 | 2000-11-29 00:00:00 |  | 255.5 | 7200 | 200 | 200 | 264.07 | 295 | 235 | 50
 | Explanatory Notes
 | R = REVISED |  |  | S = SURVEYED DATA |  |  |  | N/Q - NO QUOTE
 | Index: Weighted average price of megawatthours sold at COB. The Index is quoted in $/Mwh.
 | For questions or comments please call Antoine Eustache (609)520-7058 or [NAME] (609) 520-7067.
Spreadsheet: 108982d1305898064-stacked-chart-dilemma-776753
Sheet: Sheet1

 | Red | Green | Blue | Yellow | Red | Green | Blue | Yellow | Red | Green | Blue | Yellow | Red | Green | Blue | Yellow
Area 1 | 1 |  |  |  |  |  |  | 1 |  | 1 |  |  |  |  | 1
Area 2 |  | 1 |  |  |  |  | 1 |  |  |  |  | 1 | 1
Area 3 |  |  | 1 |  |  | 1 |  |  | 1 |  |  |  |  |  |  | 1
Area 4 |  |  |  | 1 | 1 |  |  |  |  |  | 1 |  |  | 1
Spreadsheet: 745c8cff-8ec2-49ab-8597-b29fe6ac0851
Sheet: Sheet1

PROG ID | ATHLETE ID | ATHLETE FIRST | ATHLETE LAST | NATIONALITY | START NUMBER | SWIM | T1 | BIKE | T2 | RUN | POSITION | TOTAL TIME
259167 | 72562 | Caroline | Ljungström | SWE | 501 | 00:39:34 | 00:03:58 | 03:15:28 | 00:01:19 | 03:14:12 | 1 | 07:14:32
Spreadsheet: f4d497d5-cb93-4163-b35c-d1f9e36d609f
Sheet: Sheet1

PROG ID | ATHLETE ID | ATHLETE FIRST | ATHLETE LAST | NATIONALITY | START NUMBER | RUN | T1 | BIKE | T2 | RUN.1 | POSITION | TOTAL TIME
260714 | 74554 | Gilberto | Alavez Lopez | MEX | 1704 | 00:20:11 | 00:01:08 | 00:37:08 | 00:01:34 | [NAME] | 1 | 01:11:18
260714 | 41160 | Adrian | Howden | GBR | 1702 | [NAME] | 00:00:52 | 00:40:11 | 00:01:35 | 00:12:23 | 2 | 01:17:26
Spreadsheet: 3f190b49-f3c1-4ce6-a860-fed9c2e0a7bd
Sheet: 13c

 | Swap Dealers/MSPs4 |  | Others
Product1 | Cleared2 | Uncleared | Cleared | Uncleared
Index Tranche | - | 1616932 | - | 205479
Europe | - | 777163 | - | 109661
North America/Asia | - | 839769 | - | 95818
Index | 3451491 | 7122106 | 766042 | 2173032
Asia | - | 165518 | - | 37353
Europe | 1522397 | 3439838 | 345800 | 862750
North America | 1909621 | 3140325 | 415391 | 1220215
Other | 19473 | 376425 | 4851 | 52714
Other | - | 698154 | - | 325747
Exotic/Total Return Swap | - | 56177 | - | 31815
Swaptions | - | 641977 | - | 293932
TOTAL | 3451491 | 9437192 | 766042 | 2704258
Spreadsheet: tracy_geaccone__40587__CostReportingPilot1
Sheet: Home Page

 |  |  | Month | Jul |  | Year | 2000
 |  |  |  | Aug |  |  | 2001
 |  |  |  | Sep |  |  | 2002
 |  |  |  |  |  |  |  |  | JULY 2000 |  |  |  |  | YTD JULY 2000
 |  |  |  |  |  |  |  | Total Cost | Plan | [NAME] |  |  | Total Cost | Plan | [NAME]
 |  |  | People
 |  |  |  | Salaries and Wages
 |  |  |  |  | 52000500 | Salaries and Wages
 |  |  |  |  | 52505000 | Directors Fees
 |  |  |  |  | 82100002 | Const Mgmt
 |  |  |  |  | 82100009 | [NAME] Assistant
 |  |  |  | Benefits
 |  |  |  | Payroll Taxes
 |  |  | Employee Expense
 |  |  | Office
 |  |  | Outside  Services
 |  |  | Technology
 |  |  | Depreciation
 |  |  | Other
 |  |  |  | Gross |  |  |  | Sum of the above
 |  |  | Capitalized / Deferred
 |  |  |  | Net |  |  |  | Gross + Capitalized / Deferred
 |  |  | Allocations Out
 |  |  |  | Total After Allocations |  |  |  | Net + Allocations Out
 |  |  |  |  | Jan | Feb | Mar | Apr | May | Jun | Jul | Aug | Sep | Oct | Nov | Dec
 |  |  | Headcount
 |  |  |  |  | OPERATING COST DETAILS
Spreadsheet: 882447d1730831907-return-one-value-from-a-range-based-on-three-conditions-book222-modify
Sheet: Sheet1

Wed, Sep 18, 2024 | Wed, Sep 25, 2024 | Wed, Oct 2, 2024 | Wed, Oct 9, 2024 | Wed, Oct 16, 2024 | Wed, Oct 23, 2024 | Wed, Oct 30, 2024 | Wed, Nov 6, 2024 | Wed, Nov 13, 2024 | Wed, Nov 20, 2024 | Wed, Nov 27, 2024 | Wed, Dec 4, 2024
P | P | 2 | P | 2
P | 2 | 2 | P | P
P | P | 2 | P | P
P | P | 2 | P | P
P | P | 2 | P | P
P | P | 2 | P | P
P | 2 | 2 | P | P
P | P | 2 | P | P
P | P | 2 | P | P
P | P | 2 | P | P
P | P | 2 | P | P
P | P | 2 | P | P
P | P | 2 | P | P
P | P | 2 | P | P
P | P | 2 | P | P
P | P | 2 | P | P
P | P | 2 | P | P
Spreadsheet: 179548d1347293177-return-value-from-row-below-rows-question
Sheet: Sheet1

a | b | c | d | e | f
adt5 | gNU% | hcfu | Yh)% | CFt* | Js1?
g | h | i | j | k | l
H$6q | gQ6, | x'B1 | Ms3# | u9P_ | Ea<7
m | n | o | p | q | r
Z1&q | f4R, | m<F3 | x9!G | g1<B | t6_Y
s | t | u | v | w | x
C4b( | d8F\ | fR4< | Wh9& | d8F\ | [NAME]!
y | z | 0 | 1 | 2 | 3
Dg3# | [NAME] | M?7y | V1-y | R6f' | A4=h
4 | 5 | 6 | 7 | 8 | 9
R:6v | Z:6m | q9F* | A-8k | B8=g | p3L?
 | This |  |  |  |  |  | (Below is what I end up with)
 |  | (Need this to equal the value from cell C8)
 |  | (Need this to equal the value from cell B4)
 |  | (Need this to equal the value from cell C4)
 |  | (Need this to equal the value from cell A8)
Spreadsheet: 449407d1457138573-breaks-lunch-counter-copy-of-breakscounterv2-3-ndm
Sheet: Sheet1

Interval | Break | Lunch
00:00:00
00:30:00
01:00:00
01:30:00
02:00:00
02:30:00
03:00:00
03:30:00
04:00:00
04:30:00
05:00:00
05:30:00
06:00:00
06:30:00
07:00:00
07:30:00
08:00:00
08:30:00
09:00:00
09:30:00
10:00:00
10:30:00
11:00:00
11:30:00
12:00:00
12:30:00
13:00:00
13:30:00
14:00:00
14:30:00
15:00:00
15:30:00
16:00:00
16:30:00
17:00:00
17:30:00
18:00:00
18:30:00
19:00:00
19:30:00
20:00:00
20:30:00
21:00:00
21:30:00
22:00:00
22:30:00
23:00:00
23:30:00
1900-01-01 00:00:00
1900-01-01 00:30:00
1900-01-01 01:00:00
1900-01-01 01:30:00
1900-01-01 02:00:00
1900-01-01 02:30:00
1900-01-01 03:00:00
1900-01-01 03:30:00
1900-01-01 04:00:00
1900-01-01 04:30:00
1900-01-01 05:00:00
1900-01-01 05:30:00
1900-01-01 06:00:00
1900-01-01 06:30:00
1900-01-01 07:00:00
1900-01-01 07:30:00
1900-01-01 08:00:00
1900-01-01 08:30:00
1900-01-01 09:00:00
1900-01-01 09:30:00
1900-01-01 10:00:00
1900-01-01 10:30:00
1900-01-01 11:00:00
1900-01-01 11:30:00
1900-01-01 12:00:00
Spreadsheet: 272639d1382451735-summing-portions-of-a-column-until-certain-value-is-met-test-stan9-221013
Sheet: Manual Calculation

Raw Points | Percentage |  | Segment | Volume | Start Raw Pts | End Raw Pts | Totals
0 | 0 |  | 1 | 4 | 0
1 | 0 |  | 2 | 7
2 | 0 |  | 3 | 12
3 | 0 |  | 4 | 17
4 | 0 |  | 5 | 20
5 | 0 |  | 6 | 17 |  | 50
6 | 0 |  | 7 | 12 |  | 53
7 | 0 |  | 8 | 7 |  | 57
8 | 0 |  | 9 | 4 |  | 60
9 | 0
10 | 0
11 | 0.09017132551848511
12 | 0
13 | 0
14 | 0.09017132551848511
15 | 0
16 | 0
17 | 0.1803426510369702
18 | 0.1803426510369702
19 | 0
20 | 0.5410279531109108
21 | 0.3606853020739405
22 | 0.5410279531109108
23 | 0.5410279531109108
24 | 0.9918845807033363
25 | 0.4508566275924256
26 | 0.8115419296663661
27 | 0.6311992786293958
28 | 0.5410279531109108
29 | 1.352569882777277
30 | 1.442741208295762
31 | 1.713255184851217
32 | 1.803426510369702
33 | 2.434625788999099
34 | 3.065825067628494
35 | 2.073940486925157
36 | 2.795311091073039
37 | 2.073940486925157
38 | 3.51668169522092
39 | 3.87736699729486
40 | 4.779080252479711
41 | 4.328223624887286
42 | 3.69702434625789
43 | 4.05770964833183
44 | 4.328223624887286
45 | 3.967538322813345
46 | 5.049594229035167
47 | 5.680793507664562
48 | 4.688908926961227
49 | 4.598737601442742
50 | 3.065825067628494
51 | 4.328223624887286
52 | 2.975653742110009
53 | 3.246167718665464
54 | 1.983769161406673
55 | 2.434625788999099
56 | 1.172227231740307
57 | 1.262398557258792
58 | 1.262398557258792
59 | 0.6311992786293958
60 | 0.3606853020739405
Spreadsheet: 120219d1315088323-two-conditions-meet-one-condition-is-within-data-set-search-for-corresponding-value-example
Sheet: sorted

ID | Name | 190 | 193 | 197 | 200 | 194 | 196 | 198 | 192 | 182 | 195 | 199 | 201 | 187 | 183 | 184 | 186 | 189
1126 | Name 1 |  | 0 | 0 | 0 | 0 | 2 | 2 | 1 | 1 | 1 | 1 | 1 | 6 | - | 2 | 2 | 5
1133 | Name 2 | 4 | 4 | 4 | 4 | 2 | 2 | 2 | 1 | 1 | 1 | 1 | 1 | 6 | 3 | 2 | 2 | 5
1140 | Name 3 | 1 | 1 | 1 | 1 | 2 | 2 | 2 | - | - | - | - | - | 1 | - | - | - | 1
1104 | Name 4 | - | - | - | - | - | - | - | - | - | - | - | - | - | 6* | - | 6 | -
1106 | Name 5 | 2 | 2 | 2 | 2 | 2 | 2 | 2 | 1 | 1 | 1 | 1 | 1 | 4 | - | 4 | - | 3
1124 | Name 6 | 2 | 2 | 2 | 2 | 1 | 1 | 1 | 2 | 2 | 2 | 2 | 2 | 4 | - | 4 | - | 3
1123 | Name 7 | - | - | - | - | - | - | - | - | - | - | - | - | - | 4 | - | 1 | -
1121 | Name 8 | 4 | 4 | 4 | 4 | 1 | 1 | 1 | 2 | 2 | 2 | 2 | 2 | 6 | - | 2 | 1 | 8
1118 | Name 9 | 5 | 5 | 5 | 5 | - | - | - | - | - | - | - | - | 6 | 1 | - | - | 7
1115 | Name 10 | 2 | 2 | 2 | 2 | 1 | 1 | 1 | 2 | 2 | 2 | 2 | 2 | 4 | - | 4 | 6 | 6
1117 | Name 11 | 1 | 1 | 1 | 1 | 2 | 2 | 2 | - | - | - | - | - | 1 | - | - | - | 1
1193 | Name 12 | 7 | 7 | 7 | 7 | 7 | 7 | 7 | 7 | 7 | 7 | 7 | 7 | - | - | 7 | 1 | -
1196 | Name 13 | 2 | 2 | 2 | 2 | 1 | 1 | 1 | 4 | 4 | 4 | 4 | 4 | - | - | 1 | - | -
1198 | Name 14 | 1 | 1 | 1 | 1 | - | - | - | - | - | - | - | - | - | - | - | - | -
1176 | Name 15 | 1 | 1 | 1 | 1 | - | - | - | - | - | - | - | - | - | - | 1 | - | -
 | Name 16 | - | - | - | - | - | - | - | - | - | - | - | - | - | - | - | - | -
 | Name 17 | - | - | - | -
1109 | Name 18 | - | - | - | - | - | - | - | - | - | - | - | - | - | 5 | - | 6 | -
1114 | Name 19 | - | - | - | - | - | - | - | - | - | - | - | - | - | 5 | - | 6 | -
1113 | Name 20 | 2 | 2 | 2 | 2 | 1 | 1 | 1 | 3 | 3 | 3 | 3 | 3 | - | - | 3 | - | 4
1134 | Name 21 | 2 | 2 | 2 | 2 | 1 | 1 | 1 | 4 | 4 | 4 | 4 | 4 | - | 3 | 3 | 1 | 2
1136 | Name 22 | 1 | 1 | 1 | 1 | 2 | 2 | 2 | 3 | 3 | 3 | 3 | 3 | - | - | 1 | - | -
1138 | Name 23 | - | - | - | - | - | - | - | - | - | - | - | - | - | - | - | 6 | -
1120 | Name 24 | 2 | 2 | 2 | 2 | 1 | 1 | 1 | 3 | 3 | 3 | 3 | 3 | 2 | - | 4 | - | 4
1125 | Name 25 | 3 | 3 | 3 | 3 | 4 | 4 | 4 | 1 | 1 | 1 | 1 | 1 | 5 | 2** | 2 | 5 | 6
1129 | Name 26 | 1 | 1 | 1 | 1 | 2 | 2 | 2 | 3 | 3 | 3 | 3 | 3 | - | - | 2 | - | 4
1120 | Name 27 | 2 | 2 | 2 | 2 | 1 | 1 | 1 | 3 | 3 | 3 | 3 | 3 | 2 | - | 4 | - | 4
1110 | Name 28 | 3 | 3 | 3 | 3 | 2 | 2 | 2 | 1 | 1 | 1 | 1 | 1 | 6 | 2 | 1 | 4 | 3
1116 | Name 29 | 4 | 4 | 4 | 4 | 1 | 1 | 1 | 2 | 2 | 2 | 2 | 2 | 6 | - | 3 | 5 | 2
1141 | Name 30 | 5 | 5 | 5 | 5 | 2 | 2 | 2 | 1 | 1 | 1 | 1 | 1 | 6 | 2 | 3 | 3 | 5
1128 | Name 31 | - | - | - | - | - | - | - | - | - | - |  | - | - | - | - | - | -
Spreadsheet: 137589d1327244731-cant-get-if-statement-to-display-contents-of-various-ranges-angrypockets06_charpicker_ron_v1a
Sheet: Sheet2

Name | Size | Strength | Hair
Alpha | Large | Weak | [NAME]
Bravo | Medium | Strong | Blond
[NAME] | Small | Powerful | Red
Delta | Big | Average | Black
Spreadsheet: chris_germany__2296__DecCohCHOICE-ENA
Sheet: Dec 15

 | COH CHOICE NOMINATIONS TO ACTUALS
 | FOR GAS DAY |  |  |  |  |  |  |  | 2000-12-15 00:00:00
 |  | MA | NOM ID |  | FT |  | AT |  | FORECASTED |  | ACTUALS |  | CONTRACT # | % Storage | Over | Sto | [NAME]
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | FT DROP |  | AT DROP
 | COH 3-15 | 22-15 | 3342 |  |  |  |  |  | 1169 |  | 1169 |  | 67694 |  |  |  |  |  | 19 | 1 | 19
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 21 | 2 | 21
 | COH 5-2 | 23N-02 | 3343 |  |  |  |  |  | 5143 |  | 5143 |  | 67694 |  |  |  |  |  | 20 | 3 | 20
 |  |  |  |  |  |  |  |  | 5000 |  | 5000 |  | 68918 | 0 |  |  |  |  | 20 | 4 | 20
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 23 | 5 | 23
 | COH 5-7 | 23N-07 | 3344 |  |  |  |  |  | 1879 |  | 1879 |  | 67694 |  |  |  |  |  | 21 | 6 | 21
 |  |  |  |  |  |  |  |  | 1535 |  | 1535 |  | 68915 | 0 |  |  |  |  | 20 | 7 | 20
 |  |  |  |  |  |  |  |  | 1540 |  | 1540 |  | 69693 | 0 |  |  |  |  | 23 | 8 | 23
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 22 | 9 | 22
 | COH 7-1 | 23-01 | 3788 |  |  |  |  |  | 14422 |  | 14422 |  | 67694 |  |  |  |  |  | 26 | 15 | 26
 |  |  |  |  |  |  |  |  | 673 |  | 673 |  | 69149 | 0 |  |  |  |  | 20 | 35 | 20
 |  |  |  |  |  |  |  |  |  |  |  |  | 68915 | 0 |  |  |  |  | 20 | 39 | 20
 |  |  |  |  |  |  |  |  |  |  |  |  | 68918 | 0
 | COH 7-3 | 23-03 | 3789 |  |  |  |  |  | 1450 |  | 1450 |  | 67694
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | %
 | COH 7-4 | 23-04 | 3345 |  |  |  |  |  | 1062 |  | 1062 |  | 67694 |  |  |  |  |  | Storage
 |  |  |  |  |  |  |  |  | 1915 |  | 1915 |  | 68916 | 0 |  |  |  |  | #67694
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 0.5
 | COH 7-5 | 23-05 | 2777 |  |  |  |  |  | 11644 |  | 11644 |  | 67694
 | COH 7-6 | 23-06 | 3346 |  |  |  |  |  | 1820 |  | 1820 |  | 67694
 | COH 7-8 | 23-08 | 3790 |  |  |  |  |  | 3804 |  | 3804 |  | 67694
 | COH 7-9 | 23-09 | 3791 |  |  |  |  |  | 5035 |  | 5035 |  | 67694
 | COH 8-35 | 24-35 | 3348 |  |  |  |  |  | 586 |  | 586 |  | 67694 | 1
 |  |  |  |  |  |  |  |  | 1000 |  | 1000 |  | 69823 | 0
 | COH 8-39 | 24-39 | 3792 |  |  |  |  |  | 43 |  | 43 |  | 67694 | 1
 |  |  |  |  |  |  |  | x | 1.Nom to COH |  | 1. Email to COH |  |  |  |  |  |  | FOM
 |  |  |  |  |  |  |  | x | 2.Email to ENA |  | 2. Email to ENA |  |  |  |  |  |  | [NAME] from/(Sell to) ENA
Spreadsheet: 878132d1725106478-formula-for-intersection-of-rows-and-columns-extend-excel-8-365-wip-aligw
Sheet: Sheet1

Modules(columns) | T/F |  |  |  |  | Modules(columns) | Analytics | Systems Analyst | Business Analyst | Development | Product Manager | Department Manager | Team Leader
d3 | FALSE |  |  |  |  | d3 | 1 | 2 | 3 | 4 | 5 | 6 | 7
Administration | FALSE |  |  |  |  | Administration | 1 | 2 | 3 | 4 | 5 | 6 | 7
Obstetrics | FALSE |  |  | 15.5 |  | Obstetrics | 1 | 2 | 3 | 4 | 5 | 6 | 7
Pharmacy | FALSE |  | Systems Analyst | 30.5 |  | Pharmacy | 1 | 2 | 3 | 4 | 5 | 6 | 7
BARS - Healthcare Monitoring | TRUE |  |  |  |  | BARS - Healthcare Monitoring | 1 | 2 | 3 | 4 | 5 | 6 | 7
BARS.STAR | TRUE |  |  |  |  | BARS.STAR | 1 | 2 | 3 | 4 | 5 | 6 | 7
Vaccination | TRUE |  |  |  |  | Vaccination | 1 | 2 | 3 | 4 | 5 | 6 | 7
VIMIS RF AKiNEO | TRUE |  |  |  |  | VIMIS RF AKiNEO | 1 | 2 | 3 | 4 | 5 | 6 | 7
VIMIS RF Oncology | TRUE |  |  |  |  | VIMIS RF Oncology | 1 | 2 | 3 | 4 | 5 | 6 | 7
VIMIS RF Prevention | FALSE |  |  |  |  | VIMIS RF Prevention | 1 | 2 | 3 | 4 | 5 | 6 | 7
VIMIS RF CVD | FALSE |  |  |  |  | VIMIS RF CVD | 1 | 2 | 3 | 4 | 5 | 6 | 7
HMP | FALSE |  |  |  |  | HMP | 1 | 2 | 3 | 4 | 5 | 6 | 7
Outside ARM | FALSE |  |  |  |  | Outside ARM | 1 | 2 | 3 | 4 | 5 | 6 | 7
Military registration | FALSE |  |  | Hard-50% |  | Military registration | 1 | 2 | 3 | 4 | 5 | 6 | 7
Hospital physician | FALSE |  |  |  |  | Hospital physician | 1 | 2 | 3 | 4 | 5 | 6 | 7
Diagnostics | FALSE |  | Positions |  |  | Diagnostics | 1 | 2 | 3 | 4 | 5 | 6 | 7
Dispensary registration | FALSE |  | Analytics | TRUE |  | Dispensary registration | 1 | 2 | 3 | 4 | 5 | 6 | 7
Remote monitoring | FALSE |  | Systems Analyst | TRUE |  | Remote monitoring | 1 | 2 | 3 | 4 | 5 | 6 | 7
Health diary | FALSE |  | Business Analyst | FALSE |  | Health diary | 1 | 2 | 3 | 4 | 5 | 6 | 7
Unified registry | FALSE |  | Development | FALSE |  | Unified registry | 1 | 2 | 3 | 4 | 5 | 6 | 7
User information support | FALSE |  | Product Manager | FALSE |  | User information support | 1 | 2 | 3 | 4 | 5 | 6 | 7
IPRA | FALSE |  | Department Manager | FALSE |  | IPRA | 1 | 2 | 3 | 4 | 5 | 6 | 7
IEMC | FALSE |  | Team Leader | FALSE |  | IEMC | 1 | 2 | 3 | 4 | 5 | 6 | 7
Call center | FALSE |  |  |  |  | Call center | 1 | 2 | 3 | 4 | 5 | 6 | 7
 |  |  |  |  |  | The formula should not only find numbers at the intersection of rows and columns and write them into the range starting from the green cell, but also multiply them by 3 and add percentages to the result depending on the complexity. There is data validation with the required percentages. The most important condition is that there is must be only one function and it calculates everything automatically.
Spreadsheet: 34694d1232008839-reset-schedule-oa-boiler-reset_2
Sheet: Sheet2

180 | 130 | 40 | 80 | -1.25
180 | 130 | 40 | 80 | -1.25
180 | 130 | 40 | 80 | -1.25
180 | 130 | 40 | 80 | -1.25
180 | 130 | 40 | 80 | -1.25
180 | 130 | 40 | 80 | -1.25
180 | 130 | 40 | 80 | -1.25
180 | 130 | 40 | 80 | -1.25
180 | 130 | 40 | 80 | -1.25
180 | 130 | 40 | 80 | -1.25
180 | 130 | 40 | 80 | -1.25
180 | 130 | 40 | 80 | -1.25
180 | 130 | 40 | 80 | -1.25
180 | 130 | 40 | 80 | -1.25
180 | 130 | 40 | 80 | -1.25
180 | 130 | 40 | 80 | -1.25
180 | 130 | 40 | 80 | -1.25
180 | 130 | 40 | 80 | -1.25
Spreadsheet: danny_mccarty__4635__Exhibit 7 - 2001- MKM
Sheet: March 2001

 | NORTHERN NATURAL GAS COMPANY |  |  |  | Privileged and Confidential.  Prepared for
 | System Levelized Account |  |  |  | Settlement purposes only.
 | March 2001
 |  |  |  |  |  |  |  |  |  |  | SLA Account
 |  |  |  |  |  |  |  |  |  |  | Total |  | Cash Portion - |  | Future
 |  | Operational |  |  |  |  |  |  |  |  |  |  | Cash Out/ |  | Liability
 |  | Storage |  | SLA Calculation |  |  |  |  |  |  |  |  | (Cash In)
 |  | [NAME] | Volume | Dollar | Dollar |  |  |  | Net |  | SLA Impact |  | Col (e)*-1 |  | Col (d)*(g)
Line |  | (Over)/Under | Valued | Valued | Amount | Cost |  | Monthly | Cost |  | Increase/
No. | Type of Volume | 14 Bcf | [NAME] | [NAME] | (Cash Out)/ | Per Mcf |  | MIP | Per Mcf |  | (Decrease)
 |  | Col (c)+(d) |  |  | Cash In | Col (e)/(d) |  |  | Col (g)-(f) |  | Col (d)*(h)
 | Column (a) | (b) | (c) | (d) | (e) | (f) |  | (g) | (h) |  | (i) |  | (j) |  | (k)
 | March, 2001
1 | 02/01 Balance Per Books: |  | -3475039 | 762985 | -59478600 |  |  | 5.6802 |  |  | 63812507 |  | 59478600
2 | Revalue 02/01 Shortfall @ Current [NAME]: |  |  |  |  |  | 1/ | 5.1093
3 | 03/01 Activity
4 | Dollar Valued Imbalance |  |  | 207686
5 | Imbalance Tiering Gain |  |  |  | 119303
6 | Gas Purchases |  |  | 0 | 0
7 | Miscellaneous
8 | Net 03/01 Activity |  | -330253
9 | 03/01 Balance Per Books:
 | 1/  Prior Month's MIP
Spreadsheet: 164994d1340980130-excel-2007-formula-to-find-and-copy-duplicated-entries-to-another-worksheet-sample_reply
Sheet: TAB B

Duplicated entries
Post Code Sector | COUNCIL | Post Town | AREAS | Date of last visit | Post code select
 |  |  |  |  |  |  | < [NAME] currently to row 32 as an example.
Spreadsheet: 186652d1350140224-count-numbers-that-fall-between-a-range-test
Sheet: Sheet1

Energy Sector
Class Widths | Frequency | m | mf | m²f
6 to 48
49 to 91
92 to 134
135 to 177
178 to 220
Pharmaceutical Sector
Class Widths | Frequency | m | mf | m²f
-66 to -4
-3 to 20
21 to 42
43 to 65
Retail Sector
Class Widths | Frequency | m | mf | m²f
Spreadsheet: 739620d1625827469-need-lookup-on-more-than-one-value-and-sumup-total-with-various-inputs
Sheet: Sheet1

 |  |  |  |  |  |  |  |  | need result as like below
Name | cat1 | cat2 | cat3 | cat4 | cat5
[NAME] | 15 | 25 | 45 | 9 | 0 |  |  |  | Name | Total of all cat
Haja | 67 | 56 | 99 | 56 | 32 |  |  |  | [NAME] | ? | (Note:  In my data - There is more than one [NAME] (i.e. anwar 3 times, so I need all the total of anwar)
Naveed | 63 | 74 | 66 | 7 | 45 |  |  |  | [NAME] | ?
Niyaz | 676 | 53 | 998 | 25 | 25 |  |  |  | Noufal | ?
suhaina | 909 | 7 | 463 | 56 | 56 |  |  |  | Naveed | ? | (Note:  In my data - There is more than one Naveed i.e. naveed 2 times, so I need all the total of Naveed)
Irfaan | 343 | 25 | 55 | 45 | 78
Noufal | 678 | 56 | 78 | 65 | 63
[NAME] | 66 | 90 | 9 | 66 | 676
[NAME] | 998 | 67 | 56 | 90 | 909
[NAME] | 463 | 9 | 7 | 25 | 343
[NAME] | 55 | 56 | 25 | 56 | 678
Naveed | 78 | 87 | 56 | 87 | 543