tianzl66/Sheetpedia huggingface dataset:
Spreadsheet: 158574d1338309012-how-to-combine-if-and-offset-match-countif-together-time-sheet-validation
Sheet: Tasks

Name: | Short List: | Full List:
A.K | Task for A.K 3 | Task for A.K 1
A.K | Task for A.K 7 | Task for A.K 2
A.K | Task for A.K 11 | Task for A.K 3
A.K | Task for A.K 16 | Task for A.K 4
A.K | Task for A.K 18 | Task for A.K 5
A.K |  | Task for A.K 6
A.K |  | Task for A.K 7
A.K |  | Task for A.K 8
A.K |  | Task for A.K 9
A.K |  | Task for A.K 10
A.K |  | Task for A.K 11
A.K |  | Task for A.K 12
A.K |  | Task for A.K 13
A.K |  | Task for A.K 14
A.K |  | Task for A.K 15
A.K |  | Task for A.K 16
A.K |  | Task for A.K 17
A.K |  | Task for A.K 18
A.K |  | Task for A.K 19
A.K |  | Task for A.K 20
M.C | Task for M.C 5 | Task for M.C 1
M.C | Task for M.C 8 | Task for M.C 2
M.C | Task for M.C 12 | Task for M.C 3
M.C | Task for M.C 15 | Task for M.C 4
M.C | Task for M.C 16 | Task for M.C 5
M.C |  | Task for M.C 6
M.C |  | Task for M.C 7
M.C |  | Task for M.C 8
M.C |  | Task for M.C 9
M.C |  | Task for M.C 10
M.C |  | Task for M.C 11
M.C |  | Task for M.C 12
M.C |  | Task for M.C 13
M.C |  | Task for M.C 14
M.C |  | Task for M.C 15
M.C |  | Task for M.C 16
M.C |  | Task for M.C 17
M.C |  | Task for M.C 18
M.C |  | Task for M.C 19
M.C |  | Task for M.C 20
T.G | Task for T.G 4 | Task for T.G 1
T.G | Task for T.G 6 | Task for T.G 2
T.G | Task for T.G 12 | Task for T.G 3
T.G | Task for T.G 15 | Task for T.G 4
T.G | Task for T.G 19 | Task for T.G 5
T.G |  | Task for T.G 6
T.G |  | Task for T.G 7
T.G |  | Task for T.G 8
T.G |  | Task for T.G 9
T.G |  | Task for T.G 10
T.G |  | Task for T.G 11
T.G |  | Task for T.G 12
T.G |  | Task for T.G 13
T.G |  | Task for T.G 14
T.G |  | Task for T.G 15
T.G |  | Task for T.G 16
T.G |  | Task for T.G 17
T.G |  | Task for T.G 18
T.G |  | Task for T.G 19
T.G |  | Task for T.G 20
Spreadsheet: 850210d1700581345-counting-columns-dependent-on-criteria-excel-help-forum-example-workbook
Sheet: Sheet1

Internal length m | Internal width m
4.85 | 2
4.85 | 2.256
5.45 | 2
5.45 | 2.256
5.064 | 1.992
5.064 | 1.992
4.8 | 2.02
4.8 | 2.19
4.8 | 2.02
4.8 | 2.19
5.48 | 2.12
4.07 | 2.04
4.07 | 2.04
4.64 | 2.04
4.64 | 2.04
5.1 | 2.04
5.57 | 2.04
4.87 | 1.9
4.87 | 2.16
2.48 | 1.28
3.04 | 1.68
2.55 | 1.25
3.04 | 1.5
3.04 | 1.5
3.62 | 1.9
4.27 | 1.9
4.98 | 1.9
4.5 | 2.1
5.05 | 2.1
5.66 | 2.1
6.25 | 2.1
5.6 | 2.1
3.4 | 1.7
Spreadsheet: 526362d1499279479-dynamic-ranges-which-adds-column-inbound-vs-outbound-chemb
Sheet: Inbound vs outbound week

 | Weeknr.
 | 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 | 32 | 33 | 34 | 35 | 36 | 37 | 38 | 39 | 40 | 41 | 42 | 43 | 44 | 45 | 46 | 47 | 48 | 49 | 50 | 51 | 52
Inbound Z | 1263 | 887 | 827 | 609 | 1121 | 697 | 705 | 673 | 820 | 821 | 1368 | 773 | 533 | 716 | 786 | 608 | 852 | 844 | 933 | 630 | 509 | 411 | 612 | 403 |  | 1163
Outbound Z | 499 | 922 | 704 | 409 | 798 | 533 | 795 | 598 | 515 | 566 | 443 | 532 | 659 | 554 | 600 | 217 | 810 | 493 | 1222 | 1352 | 693 | 543 | 415 | 514 | 442 | 445
Inbound U | 400 | 1052 | 456 | 564 | 526 | 562 | 326 | 269 | 342 | 411 | 429 | 545 | 681 | 457 | 379 | 330 | 940 | 446 | 686 | 676 | 374 | 541 | 929 | 835 |  | 449
Outbound U | 350 | 221 | 309 | 356 | 403 | 324 | 416 | 312 | 273 | 287 | 436 | 391 | 1337 | 961 | 450 | 209 | 333 | 387 | 339 | 652 | 594 | 496 | 1024 | 627 |  | 415
Inbound E | 992 | 1834 | 965 | 1065 | 513 | 935 | 1246 | 865 | 486 | 977 | 1091 | 999 | 1513 | 1318 | 975 | 966 | 779 | 1111 | 645 | 1105 | 742 | 1104 | 768 | 1235 | 1015 | 644
Outbound E | 1664 | 1669 | 577 | 978 | 912 | 896 | 496 | 397 | 704 | 766 | 1046 | 1119 | 982 | 937 | 577 | 639 | 1003 |  | 782 | 655 | 744 | 905 | 751 |  |  | 811
Inbound TOT
Outbound TOT
Spreadsheet: elizabeth_sager__9640__MISO Registration Sections 1-2
Sheet: OASIS Certificate Ids

OASIS Certificate Ids
[cn=[NAME], ou=EPMI, l=SPP, o=TradeWave, c=US]
[cn=Ashish Mahajan, ou=EPMI, l=SPP, o=TradeWave, c=US]
[cn=[NAME], ou=EPMI, l=SPP, o=TradeWave, c=US]
[cn=[NAME], ou=EPMI, l=SPP, o=TradeWave, c=US]
[cn=[NAME], ou=EPMI, l=SPP, o=TradeWave, c=US]
[cn=EPMI Control Room Certificate, ou=EPMI, l=SPP, o=TradeWave, c=US]
[cn=EPMI Control Room Certificate, ou=EPMI, l=SPP, o=TradeWave, c=US]
[cn=[NAME], ou=EPMI, l=SPP, o=TradeWave, c=US]
[cn=[NAME], ou=EPMI, l=SPP, o=TradeWave, c=US]
[cn=[NAME], ou=EPMI, l=SPP, o=TradeWave, c=US]
[cn=[NAME], ou=EPMI, l=SPP, o=TradeWave, c=US]
[cn=[NAME], ou=EPMI, l=SPP, o=TradeWave, c=US]
[cn=[NAME], ou=EPMI, l=SPP, o=TradeWave, c=US]
[cn=[NAME], ou=EPMI, l=SPP, o=TradeWave, c=US]
[cn=[NAME], ou=EPMI, l=SPP, o=TradeWave, c=US]
[cn=[NAME], ou=EPMI, l=SPP, o=TradeWave, c=US]
[cn=[NAME], ou=EPMI, l=SPP, o=TradeWave, c=US]
[cn=Madhup Kumar, ou=EPMI, l=SPP, o=TradeWave, c=US]
[cn=[NAME], ou=EPMI, l=SPP, o=TradeWave, c=US]
[cn=[NAME], ou=EPMI, l=SPP, o=TradeWave, c=US]
[cn=[NAME], ou=EPMI, l=SPP, o=TradeWave, c=US]
[cn=[NAME], ou=EPMI, l=SPP, o=TradeWave, c=US]
[cn=[NAME], ou=EPMI, l=SPP, o=TradeWave, c=US]
[cn=[NAME], ou=EPMI, l=SPP, o=TradeWave, c=US]
[cn=[NAME], ou=EPMI, l=SPP, o=TradeWave, c=US]
[cn=[NAME], ou=EPMI, l=SPP, o=TradeWave, c=US]
[cn=[NAME], ou=EPMI, l=SPP, o=TradeWave, c=US]
Spreadsheet: 823559d1680014734-countif-formula-for-names-appearing-in-all-or-some-months-book2
Sheet: Sheet1

Name | Jan | Feb | March |  | Total | All 3 months | Any 2 months | Any 1 month
[NAME] | 15200 | 6950 | 0
[NAME] | 37693 | 74303 | 80712
[NAME] | 366615 | 0 | 0
[NAME] | 4838 | 0 | 6048
[NAME] | 22805 | 0 | 0
[NAME] | 10207 | 0 | 0
[NAME] | 33377 | 0 | 0
Spreadsheet: 754467d1636227203-using-multiple-criteria-with-a-wildcard-to-return-multiple-values-index-countif-wildcard
Sheet: Feuil1

Date | Time | Description | Format changeover
2021-06-07 00:00:00 | 12:00:16 | Verrines |  | Criteria
2021-06-07 00:00:00 | 12:05:16 | Verrines | 0 | 1 | DATE | 2021-06-07 00:00:00
2021-06-07 00:00:00 | 12:10:16 | Verrines | 0 | 2 | FORMAT | GN 1/3 SLOW | GN 1/3*
2021-06-07 00:00:00 | 12:15:16 | GN 1/3 SLOW | 1 | 3 | format changeover | 1
2021-06-07 00:00:00 | 12:20:16 | GN 1/3 SLOW | 0
2021-06-07 00:00:00 | 12:25:16 | GN 1/3 SLOW | 0
2021-06-07 00:00:00 | 12:30:16 | GN 1/3 SLOW | 0
2021-06-07 00:00:00 | 12:30:37 | Print manual | 0 |  | START TIME
2021-06-07 00:00:00 | 12:35:16 | GN 1/3 SLOW | 0
2021-06-07 00:00:00 | 12:39:55 | Verrines | 1
2021-06-07 00:00:00 | 12:44:34 | Verrines | 0
2021-06-07 00:00:00 | 12:49:13 | Verrines | 0
2021-06-07 00:00:00 | 12:53:52 | GN 1/3 SLOW | 1
2021-06-07 00:00:00 | 12:58:31 | GN 1/3 SLOW | 0
2021-06-07 00:00:00 | 13:03:10 | GN 1/3 SLOW | 0
2021-06-07 00:00:00 | 13:07:49 | GN 1/3 SLOW | 0
Spreadsheet: dcf709dc-5e20-4028-af6d-36533e873681
Sheet: Sheet1

GENERAL | Unnamed: 1 | Unnamed: 2 | Unnamed: 3 | Unnamed: 4 | Unnamed: 5 | Unnamed: 6 | Unnamed: 7 | Unnamed: 8 | Unnamed: 9 | Unnamed: 10 | Unnamed: 11 | Unnamed: 12 | Unnamed: 13 | Unnamed: 14 | Unnamed: 15
Ordinance Fact Sheet |  |  |  |  |  |  | Ordinance Number
 | Brief Title |  | Approval Deadline |  | Reason
 | 2007 Fair Housing Assistance Program
 | 2007 EEOC Grant
Details |  |  |  |  | Positions/Recommendations
 | Reason for Legislation |  |  |  | Sponsor |  | [NAME]
 |  |  |  |  | Programs,
 |  |  |  |  | Departments, |  | City Manager
 |  |  |  |  | or Groups
 |  |  |  |  | Affected
 |  |  |  |  | Applicants / |  | Applicant
 |  |  |  |  | Proponents
 |  |  |  |  |  |  |  |  | City Manager
 |  |  |  |  |  |  | City Department
 |  |  |  |  |  |  | Other | Human Relations Division
 |  |  |  |  | Opponents |  | Groups or Individuals
 |  |  |  |  |  |  |  |  | None Known
 |  |  |  |  |  |  | Basis of opposition
 |  |  |  |  | Staff
 |  |  |  |  | Recommendation |  | X |  | For
 |  |  |  |  |  |  |  |  | Against
 |  |  |  |  |  |  | Reason Against
 |  |  |  |  | Board or
 |  |  |  |  | Commission |  | By
 |  |  |  |  | Recommendation
 |  |  |  |  |  |  |  |  | For |  |  |  | Against |  | No action taken
 |  |  |  |  |  |  |  |  | For, with revisions or conditions
 |  |  |  |  |  |  |  |  | (see details column for conditions)
 |  |  |  |  | Council
 |  |  |  |  | Committee |  |  |  | Do pass
 |  |  |  |  | Actions
 |  |  |  |  |  |  |  |  | Do pass (as amended)
 |  |  |  |  |  |  |  |  | Committee Sub.
 |  |  |  |  |  |  |  |  | Without Recommendation
 |  |  |  |  |  |  |  |  | Hold
 |  |  |  |  |  |  |  |  | Do not pass
 |  |  |  |  |  |  |  |  |  |  |  | (Continued on reverse side)
Details |  |  |  |  | Policy/Program Impact
 |  |  |  |  | Policy or Program
 |  |  |  |  | Change |  |  |  | No |  |  |  | Yes
 |  |  |  |  | Operational
 |  |  |  |  | Impact
 |  |  |  |  | Assessment
 |  |  |  |  | Finances
 |  |  |  |  | Cost & Revenue
 |  |  |  |  | Projections --
 |  |  |  |  | Including Indirect
 |  |  |  |  | Costs
 |  |  |  |  | Financial Impact
 |  |  |  |  | Fund Source (s) |  | 2006
 |  |  |  |  | and Appropriation |  | Unbudgeted, Appropriation
 |  |  |  |  | Account Codes |  | 09-1000-105200-B-G10FHAP06
 |  |  |  |  |  |  | 09-1000-105200-479160
 |  |  |  |  |  |  | 09-1000-105210-B-G10EEOC06
 |  |  |  |  |  |  | 09-1000-105210-B-G10EEOC07
 |  |  |  |  |  |  | 09-1000-105210-479220
 |  |  |  |  | (Use this space for further discussion, if necessary)
Applicable Dates:
Fact Sheet Prepared by:
 | [NAME] |  | Date June 24, 2008
 | Senior Analyst
Reviewed by:
 | Troy Schulte |  | Date June 24, 2008
 | Budget Director
Reference Numbers
Spreadsheet: 680652d1591121297-need-a-formula-to-pull-data-from-another-sheets-chart-based-off-age-and-gender-2020-06-02-oeldere-tbingham-680647d1591120212-need-a-formula-to-pull-data-from-another-sheets
Sheet: PT

Rijlabels | Som van value
20-29 | 730
1 | 12
5 | 13
10 | 18
15 | 19
20 | 22
25 | 24
30 | 26
35 | 27
40 | 29
45 | 31
50 | 33
55 | 35
60 | 37
65 | 39
70 | 41
75 | 44
80 | 47
85 | 51
90 | 57
95 | 62
99 | 63
30-34 | 591
1 | 8
5 | 9
10 | 13
15 | 15
20 | 17
25 | 19
30 | 20
35 | 21
40 | 24
45 | 25
50 | 27
55 | 29
60 | 30
65 | 31
70 | 34
75 | 36
80 | 39
85 | 41
90 | 46
95 | 54
99 | 53
35-39 | 515
1 | 6
5 | 7
10 | 11
15 | 12
20 | 14
25 | 16
30 | 17
35 | 18
40 | 21
45 | 22
50 | 24
55 | 25
60 | 27
65 | 28
70 | 30
75 | 32
80 | 34
85 | 37
90 | 41
95 | 46
99 | 47
40-44 | 448
1 | 4
5 | 5
10 | 9
15 | 10
20 | 11
25 | 13
30 | 15
35 | 16
40 | 18
45 | 19
50 | 21
55 | 22
60 | 24
65 | 25
70 | 26
75 | 29
80 | 30
85 | 34
90 | 36
95 | 40
99 | 41
45-49 | 399
1 | 3
5 | 4
10 | 7
15 | 8
20 | 9
25 | 11
30 | 12
35 | 13
40 | 15
45 | 16
50 | 18
55 | 19
60 | 21
65 | 22
70 | 23
75 | 26
80 | 27
85 | 31
90 | 33
95 | 40
99 | 41
50-54 | 361
1 | 2
5 | 3
10 | 6
15 | 7
20 | 8
25 | 9
30 | 10
35 | 11
40 | 13
45 | 14
50 | 15
55 | 17
60 | 19
65 | 20
70 | 21
75 | 24
80 | 25
85 | 28
90 | 30
95 | 39
99 | 40
55-59 | 334
1 | 2
5 | 3
10 | 5
15 | 6
20 | 7
25 | 8
30 | 9
35 | 10
40 | 11
45 | 13
50 | 15
55 | 17
60 | 19
65 | 20
70 | 21
75 | 23
80 | 24
85 | 26
90 | 28
95 | 33
99 | 34
60+ | 306
1 | 1
5 | 2
10 | 4
15 | 5
20 | 6
25 | 7
30 | 8
35 | 9
40 | 10
45 | 12
50 | 15
55 | 16
60 | 18
65 | 20
70 | 21
75 | 22
80 | 23
85 | 24
90 | 26
95 | 28
99 | 29
Eindtotaal | 3684
Spreadsheet: 177845d1346459706-na-error-vlookup-if-statement-excel-spreadsheet
Sheet: Case 2

Pidgeon Corporation wishes to track employee printing and to compare totals with department budget allocation for printing.  A partial spreadsheet is provided.  Your job is to complete the project.
 | DEPARTMENTS AND USAGE BY EMPLOYEE
 | Employee Name | Dept Code | Department Name | Employee Usage | Notation
 | Parker, [NAME] | 104 |  | 24
 | [NAME], [NAME] | 101 |  | 21
 | Arnet, [NAME] | 103 |  | 44
 | Handel, [NAME] | 103 |  | 163
 | [NAME], [NAME] | 104 |  | 102
 | Skyles, Gene | 105 |  | 135
 | Poll, [NAME] | 102 |  | 35
 | [NAME], [NAME] | 103 |  | 44
 | Smith, Alexia | 105 |  | 58
 | Stone, [NAME] | 102 |  | 129
 | Balm, [NAME] | 103 |  | 111
 | Salisbury, [NAME] | 105 |  | 98
 | Departments
 | Dept. Code | Dept. Name | Budget Per Person
 | 101 | Executive Dept. | 550
 | 102 | Finance Dept. | 190
 | 103 | Marketing Dept. | 200
 | 104 | Personnel Dept. | 52
 | 105 | Production Dept. | 166.67
Spreadsheet: 8b0bbb5f-9059-4945-9321-fcb097345d1d
Sheet: Sheet1

PROG ID | ATHLETE ID | ATHLETE FIRST | ATHLETE LAST | NATIONALITY | START NUMBER | RUN | T1 | BIKE | T2 | RUN.1 | POSITION | TOTAL TIME
8490 | 31471 | [NAME] | Brea | VEN | 0 | 00:00:00 | 00:00:00 | 00:00:00 | 00:00:00 | 00:00:00 | 1 | 02:09:11
8490 | 63749 | Blanca Liliana | Moreno | COL | 33 | 00:00:00 | 00:00:00 | 00:00:00 | 00:00:00 | 00:00:00 | 2 | 02:12:03
8490 | 7198 | [NAME] | Urbina | VEN | 31 | 00:00:00 | 00:00:00 | 00:00:00 | 00:00:00 | 00:00:00 | 3 | 02:13:02
8490 | 30747 | [NAME] | [NAME] | ARG | 32 | 00:00:00 | 00:00:00 | 00:00:00 | 00:00:00 | 00:00:00 | 4 | 02:13:36
8490 | 7139 | [NAME] | Bianchi | VEN | 35 | 00:00:00 | 00:00:00 | 00:00:00 | 00:00:00 | 00:00:00 | 5 | 02:14:44
8490 | 33606 | [NAME] | Soto | ARG | 36 | 00:00:00 | 00:00:00 | 00:00:00 | 00:00:00 | 00:00:00 | 6 | 02:20:53
Spreadsheet: 84324d1284386349-return-result-from-two-criteria-book2
Sheet: Sheet1

Employees | 2010-01-03 00:00:00 | 2010-02-03 00:00:00 | 2010-03-03 00:00:00 | 2010-04-03 00:00:00 | 2010-05-03 00:00:00 | 2010-06-03 00:00:00 | 2010-07-03 00:00:00 | 2010-08-03 00:00:00 | 2010-09-03 00:00:00
[NAME] |  |  |  | 0 | 30 | 2758.63 | 0 | 1313.52 | 2499.76
[NAME] |  |  |  | 5413.61 | 7616.44 | 2051.99 | 7318.03 | 3641.81 | 201.5
[NAME] |  |  |  | 712.47 | 1631.44 | 62.4 | 276.1 | 1763.78 | 33.3
[NAME] |  |  |  | 0 | 0 | 0 | 200 | 3072.92 | 56570.32
Collin |  |  |  | 35770.11 | 7191.03 | 49815.79 | 36886.24 | 33964.27 | 44191.69
[NAME] |  |  |  | 852.08 | 1588.12 | 1891.67 | 677.54 | 0 | 4577.21
[NAME] |  |  |  | 4218.06 | 130 | 2821.69 | 3332.43 | 2415.11 | 1027.24
[NAME] |  |  |  | 557.94 | 683.66 | 906.12 | 265.82 | 1754.28 | 292.2
[NAME] |  |  |  | 8185.12 | 1037.42 | 526.72 | 3415.84 | 1746.64 | 3937.97
Ian |  |  |  | 6110.39 | 1694.86 | 4323.29 | 6362.13 | 6631.23 | 789.52
Isabelle |  |  |  | 312.43 | 1141.53 | 398.85 | 121 | 0 | 0
[NAME] |  |  |  | 6699.12 | 30 | 0 | 0 | 233.34 | 0
[NAME] |  |  |  | 3242.88 | 7137.3 | 10161.26 | 7694.95 | 6157.93 | 2208.97
[NAME] |  |  |  | 0 | 0 | 0 | 200 | 1641.36 | 1272.37
[NAME] |  |  |  | 0 | 0 | 0 | 0 | 781.35 | 198.62
[NAME] |  |  |  | 35.55 | 3432.01 | 1626.3 | 2690.4 | 817.9 | 840.4
May |  |  |  | 1667.04 | 1461.77 | 6353.02 | 1998.28 | 1234.89 | 227.51
[NAME] |  |  |  | 0 | 0 | 0 | 200 | 100 | 55.6
[NAME] |  |  |  | 1614.1 | 1076.03 | 1303.6 | 3176.6 | 3014.77 | 3877.97
Penny |  |  |  | 979 | 1424.69 | 1882.87 | 3541.1 | 100 | 941.72
[NAME] |  |  |  | 1608.28 | 5387.85 | 3475.69 | 3371.4 | 4759.84 | 662.94
Stuart |  |  |  | 1590.27 | 436.5 | 2583.08 | 2536.21 | 2398.17 | 4144.59
[NAME] |  |  |  | 123.5 | 283 | 20 | 255.09 | 0 | 20
[NAME] |  |  |  | 17.3 | 47.58 | 197.45 | 84.14 | 18.67 | 17.99
Totals
Employee | Date | Result
[NAME] | 2010-05-03 00:00:00
Spreadsheet: tracy_geaccone__40401__GPM 101021  101073 Recalculation
Sheet: June 2000

KN Processing |  | GPM Agency Agreement |  |  | Prepared by [NAME]
Bushton Plant |  | TFDV Volume & Dollar Calculation
 |  | For
 |  | 2000-06-01 00:00:00
Contract #101021 |  |  | NNG Numbers |  |  | Oneok Numbers |  |  | Difference
 | Total Deliveries |  |  | 3927046 |  |  | 3927046
 |  | Deliveries to Inlet | 3758645 |  |  | 3758645
 |  | Deliveries to PVR
 |  | Non-Fuel Deliveries
 |  | Fuel Retention
 | Total Receipts |  | 3927620 |  |  | 3927620
 |  | [NAME] | 0.0445 |  |  | 0.0445
 |  | Less Fuel Retained
Transport Revenue [NAME]
Contract #101073
 | Total Deliveries |  |  | 895192 |  |  | 694587
 |  | Deliveries to Inlet | 0
 |  | Deliveries to PVR | 856500 |  |  | 663380
 |  | Non-Fuel Deliveries
 |  | Fuel Retention
 | Total Receipts |  | 844696 |  |  | 844696
 |  | [NAME] | 0.0445 |  |  | 0.0445
 |  | Less Fuel Retained
Transport Revenue [NAME]
 |  | Total Both Contracts
 |  | Index |  | 4.094 |  |  | 4.0935
 |  | Total Revenue Due
Total Revenue Billed |  | 101021 |  | 36858.75
 |  | 101073
 |  |  |  |  |  |  | 52232.95
 |  | Amount Due NNG (GPM)
Charge given by NNG on prior reconciliation
 |  | Amount Due NNG (GPM)
Spreadsheet: 5b7752f2-5ed7-4cb2-893d-da9f0d883d96
Sheet: 14a

Product1 | Cleared2 | Uncleared | TOTAL
Index Tranche | - | 389 | 389
Asia | - | - | -
Europe | - | 337 | 337
North America | - | 52 | 52
Other | - | - | -
Index | 2897 | 1285 | 4182
Asia | 1 | 39 | 40
Europe | 1587 | 246 | 1833
North America | 1284 | 950 | 2234
Other | 25 | 50 | 75
Other | 22 | 137 | 159
Exotic | - | 5 | 5
Swaptions | 22 | 132 | 154
Total Return Swap | - | - | -
TOTAL | 2919 | 1811 | 4730
Spreadsheet: 74348d1274884609-identifying-the-next-whole-number-in-a-series-trunc-ex
Sheet: Sheet1

0.54 | 0.54 | 0.54 | 0.54 | 0.54 | 0.54 | 0.54 | 0.54 | 0.54 | 0.54 | 0.54 | 0.54
0.54 | 1.08 | 1.62 | 2.16 | 2.7 | 3.24 | 3.78 | 4.32 | 4.86 | 5.4 | 5.94 | 6.48
0 | 1 | 0 | 2 | 0 | 3 | 0 | 4 | 0 | 5 | 0 | 6
Spreadsheet: 68658d1269258207-excel-2007-help-populating-cells-according-to-combinations-722322-help-populating-cells-according-to-combinations
Sheet: Sheet2 (2)

 |  |  |  |  | Upgrade |  | New |  |  |  | [NAME]
Plan Type | New / Upgrade | Months 12/24 |  | Plan Type | 12 | 24 | 12 | 24
TMP 20 | NEW | 12 |  | TMP 20 | 5 | 9 | 8 | 16 |  | TMP 20 | New | 12
TMP 30 | UPGRADE | 24 |  | TMP 30 | 6 | 12 | 11 | 21
TMP 40 |  |  |  | TMP 40 | 8 | 15 | 13 | 26
TMP 60 |  |  |  | TMP 60 | 9 | 18 | 16 | 32
TMP 80 |  |  |  | TMP 80 | 14 | 27 | 24 | 47
TMP 100 |  |  |  | TMP 100 | 17 | 33 | 29 | 58
TMP 150 |  |  |  | TMP 150 | 23 | 45 | 39 | 79
TMP 250 |  |  |  | TMP 250 | 30 | 60 | 53 | 105
TMP 350 |  |  |  | TMP 350 |  | 81 |  | 142
TMP 500 |  |  |  | TMP 500 |  | 120 |  | 210
*** |  |  |  | ***
3GCAP 49 |  |  |  | 3GCAP 49 | 6 | 12 | 11 | 21
3GCAP 79 |  |  |  | 3GCAP 79 | 12 | 24 | 21 | 42
3GCAP 99 |  |  |  | 3GCAP 99 | 14 | 29 | 25 | 50
3GCAP 129 |  |  |  | 3GCAP 129 | 17 | 35 | 30 | 60
*** |  |  |  | ***
TBMS 20 |  |  |  | TBMS 20 | 15 | 12 | 26 | 21
TBMS 25 |  |  |  | TBMS 25 |  | 15 |  | 26
TBMS 30 |  |  |  | TBMS 30 | 18 | 36 | 32 | 63
TBMS 35 |  |  |  | TBMS 35 |  | 30 |  | 53
TBMS 40 |  |  |  | TBMS 40 | 20 | 39 | 34 | 68
TBMS 45 |  |  |  | TBMS 45 |  | 36 |  | 63
TBMS 50 |  |  |  | TBMS 50 | 21 | 42 | 37 | 74
TBMS 55 |  |  |  | TBMS 55 |  | 39 |  | 68
TBMS 65 |  |  |  | TBMS 65 |  | 42 |  | 74
*** |  |  |  | ***
ULT 55 |  |  |  | ULT 55 | 9 | 15 | 14 | 24
ULT 85 |  |  |  | ULT 85 | 15 | 27 | 24 | 45
ULT 110 |  |  |  | ULT 110 | 17 | 32 | 28 | 53
ULT 150 |  |  |  | ULT 150 | 20 | 39 | 34 | 68
*** |  |  |  | ***
TBFS 30 |  |  |  | TBFS 30 | 8 | 15 | 14 | 26
TBFS 40 |  |  |  | TBFS 40 | 9 | 18 | 16 | 32
TBFS 60 |  |  |  | TBFS 60 | 11 | 22 | 19 | 38
TBFS 80 |  |  |  | TBFS 80 | 16 | 32 | 28 | 57
TBFS 100 |  |  |  | TBFS 100 | 19 | 38 | 33 | 66
TBFS 150 |  |  |  | TBFS 150 | 27 | 54 | 47 | 95
TBFS 250 |  |  |  | TBFS 250 | 36 | 72 | 63 | 126
*** |  |  |  | ***
TMB 20 |  |  |  | TMB 20 | 6 | 12 | 11 | 21
TMB 30 |  |  |  | TMB 30 | 8 | 15 | 13 | 26
TMB 40 |  |  |  | TMB 40 | 9 | 18 | 16 | 32
TMB 60 |  |  |  | TMB 60 | 11 | 22 | 19 | 38
TMB 80 |  |  |  | TMB 80 | 16 | 32 | 28 | 57
TMB 100 |  |  |  | TMB 100 | 19 | 38 | 33 | 66
TMB 150 |  |  |  | TMB 150 | 27 | 54 | 47 | 95
TMB 250 |  |  |  | TMB 250 | 36 | 72 | 63 | 126
TMB 350 |  |  |  | TMB 350 | 50 | 99 | 87 | 173
TMB 500 |  |  |  | TMB 500 | 60 | 120 | 105 | 210
Spreadsheet: 685343d1593939708-lookup-doesn-t-compute-correct-higher-values-wrong-highest-values
Sheet: Tabelle1

0 | 1 | 2 | 3 | 4 | 5 | 6 | 7 | 8 | 9 | 10 | 11 | 12
3 | 1 | 1 | 1 | 2 | 0 | 0 | 0 | 0 | 0 | 0 | 1 | 5 | Aim to get → | First highest value from A4:M4 | Second highest value A4:M4 | Third highest value A4:M4
2 | 0 | 1 | 1 | 2 | 2 | 1 | 3 | 0 | 0 | 0 | 0 | 0
 |  |  |  |  |  |  |  |  |  |  |  |  | Following figures are correct in this table this table it would be correct | 0 | 12 | 4
Spreadsheet: mary_fischer__25419__Sampling Frequency Model 5-15-02
Sheet: Sheet1

 |  |  | Data |  |  | Frequency of Netting Power
 |  |  | Time Interval | Power (Energy if converted for time) |  | 1 x Interval |  | 2 x Interval |  | 3 x Interval
 |  |  | 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
Spreadsheet: juan_hernandez__17711__Electricity Price information
Sheet: Sheet1

PJM SEPTEMBER DAILY AVERAGE
DATE | Price
1998-09-01 00:00:00 | 29.16
1998-09-02 00:00:00 | 26.15
1998-09-03 00:00:00 | 24.13
1998-09-04 00:00:00 | 22.41
1998-09-08 00:00:00 | 31.8
1998-09-09 00:00:00 | 19.23 |  |  |  |  |  |  |  |  |  | Average
1998-09-10 00:00:00 | 18.2
1998-09-11 00:00:00 | 20.03
1998-09-14 00:00:00 | 27.6
1998-09-15 00:00:00 | 45.13
1998-09-16 00:00:00 | 34.71
1998-09-17 00:00:00 | 35.28
1998-09-18 00:00:00 | 35.03
1998-09-21 00:00:00 | 30.21
1998-09-22 00:00:00 | 25.37
1998-09-23 00:00:00 | 21.9
1998-09-24 00:00:00 | 20.78
1998-09-25 00:00:00 | 21.43
1998-09-28 00:00:00 | 35.64
1998-09-29 00:00:00 | 36.15
1998-09-30 00:00:00 | 38.18
1999-09-01 00:00:00 | 25.16
1999-09-02 00:00:00 | 26.44
1999-09-03 00:00:00 | 28.75
1999-09-07 00:00:00 | 29.16
1999-09-08 00:00:00 | 34.97
1999-09-09 00:00:00 | 43.2 |  |  |  |  |  |  |  |  |  | Average
1999-09-10 00:00:00 | 28.32
1999-09-13 00:00:00 | 27.12
1999-09-14 00:00:00 | 26.42
1999-09-15 00:00:00 | 25.98
1999-09-16 00:00:00 | 28.26
1999-09-17 00:00:00 | 27.11
1999-09-20 00:00:00 | 26.52
1999-09-21 00:00:00 | 24.25
1999-09-22 00:00:00 | 24.87
1999-09-23 00:00:00 | 24.43
1999-09-24 00:00:00 | 23.15
1999-09-27 00:00:00 | 29.07
1999-09-28 00:00:00 | 25.35
1999-09-29 00:00:00 | 28.88
1999-09-30 00:00:00 | 29.49
2000-09-01 00:00:00 | 53.61
2000-09-05 00:00:00 | 36.53
2000-09-06 00:00:00 | 22.21
2000-09-07 00:00:00 | 21.79
2000-09-08 00:00:00 | 24.16
2000-09-11 00:00:00 | 34.93 |  |  |  |  |  |  |  |  |  | Average
2000-09-12 00:00:00 | 39.64
2000-09-13 00:00:00 | 35.09
2000-09-14 00:00:00 | 34.82
2000-09-15 00:00:00 | 29.98
2000-09-19 00:00:00 | 35.54
2000-09-20 00:00:00 | 47.35
2000-09-21 00:00:00 | 38.12
2000-09-22 00:00:00 | 28.82
2000-09-25 00:00:00 | 27.51
2000-09-26 00:00:00 | 23.98
2000-09-27 00:00:00 | 23.53
2000-09-28 00:00:00 | 22.96
2000-09-29 00:00:00 | 21.76
Spreadsheet: 680602d1591105621-statistic-layout-with-drop-down-list-with-multi-selections-statistic-layout-petmak-
Sheet: Main

Store 1
 | Bank 1 |  |  |  |  |  |  |  |  |  |  |  |  | Bank 2 |  |  |  |  |  |  |  |  |  |  |  |  | Bank 3
BIN # | A | A | D | D | P | P | E | E | SUM | SUM | % | % |  | A | A | D | D | P | P | E | E | SUM | SUM | % | % |  | A | A | D | D | P | P | E | E | SUM | SUM | % | %
Store 2
 | Bank 1 |  |  |  |  |  |  |  |  |  |  |  |  | Bank 2 |  |  |  |  |  |  |  |  |  |  |  |  | Bank 2
BIN # | A | A | D | D | P | P | E | E | SUM | SUM | % |  |  | A | A | D | D | P | P | E | E | SUM | SUM |  |  |  | A | A | D | D | P | P | E | E | SUM | SUM
 | 25500 | 2000 |  | 2500 | 15 | 700 |  |  |  |  |  |  |  | 32070 | 3570 | 7000 | 10100 |  |  | 2000 | 20 |  |  |  |  |  | 17800 | 26400 | 37180 | 5820 |  | 17680
 | 1700 | 800 | 1500 | 2040 | 2200 |  | 750 | 70 |  |  |  |  |  | 600 | 3500 | 280 | 400 |  |  |  |  |  |  |  |  |  | 577 | 970
[NAME] | Recent Data
 | Historical Data
Approved | A
Pending | P
Error | E
Decline | D
Spreadsheet: 739735d1625904427-phone-format-00-to-1-or-86-excelphone
Sheet: Sheet1

Billing Country | Phone | Should be | remarks
Macedonia | 00389 2 2550 850 |  | double zero to be +
Trinidad and Tobago | [PHONE]
Italy | 0039 [PHONE]
Bahamas | [PHONE]
Trinidad and Tobago | [PHONE]
Nigeria | 00234-[PHONE]
United Kingdom | 0044-1457-860006
Belgium | 0032-14-578100
Macedonia | 00389 2 2461583
Jamaica | [PHONE]
Slovakia | 00421 33 640 00 71
Singapore | 0065 6221 1181
Portugal | 00351 217226110
Guyana | [PHONE]
France | 0033 4 78 04 41 04
Trinidad and Tobago | [PHONE]
China | 00852 2 8322060
Indonesia | 0062 21 - 5152-040
Belgium | 0032-2-7632222
Russia | [PHONE]
Jamaica | [PHONE]
Jamaica | [PHONE]
Trinidad and Tobago | [PHONE]
Macedonia | 00389-2-240-0850
Hungary | 0036-52-418-666
Czech Republic | 0042-[PHONE]
Ireland | 00353-1-8365007
United Kingdom | 00353-48-90738395
Czech Republic | 00420 272 690 799
Canada | [PHONE]
Slovakia | 00421 232115017
United Kingdom | 0044-20-8207 3222
Ireland | 00353 1 276 3500
Argentina | 0054 11 47 33 33 03