tianzl66/Sheetpedia huggingface dataset:
Spreadsheet: d5268c5a-d39b-493e-ae3d-0bdf87b10476
Sheet: GU6

Date | Day | Start Time | Field | Home | Visitor |  | Date | Day | Start Time | Field | Home | Visitor
2013-02-10 00:00:00 | Sunday | 11:00AM | PVF 1 | 657 | 651 |  | 2013-03-10 00:00:00 | Sunday | 11:00AM | PVF 1 | 654 | 655
2013-02-10 00:00:00 | Sunday | 12:00PM | PVF 1 | 656 | 652 |  | 2013-03-10 00:00:00 | Sunday | 12:00PM | PVF 1 | 653 | 656
2013-02-10 00:00:00 | Sunday | 1:00PM | PVF 1 | 654 | 658 |  | 2013-03-10 00:00:00 | Sunday | 1:00PM | PVF 1 | 651 | 658
2013-02-10 00:00:00 | Sunday | 2:00PM | PVF 1 | 655 | 653 |  | 2013-03-10 00:00:00 | Sunday | 2:00PM | PVF 1 | 652 | 657
2013-02-17 00:00:00 | Sunday | 11:00AM | PVF 1 | 651 | 652 |  | 2013-03-17 00:00:00 | Sunday | 11:00AM | PVF 1 | 655 | 656
2013-02-17 00:00:00 | Sunday | 12:00PM | PVF 1 | 657 | 653 |  | 2013-03-17 00:00:00 | Sunday | 12:00PM | PVF 1 | 654 | 657
2013-02-17 00:00:00 | Sunday | 1:00PM | PVF 1 | 655 | 658 |  | 2013-03-17 00:00:00 | Sunday | 1:00PM | PVF 1 | 652 | 658
2013-02-17 00:00:00 | Sunday | 2:00PM | PVF 1 | 656 | 654 |  | 2013-03-17 00:00:00 | Sunday | 2:00PM | PVF 1 | 653 | 651
2013-02-24 00:00:00 | Sunday | 11:00AM | PVF 1 | 652 | 653 |  | 2013-04-07 00:00:00 | Sunday | 11:00AM | PVF 1 | 656 | 657
2013-02-24 00:00:00 | Sunday | 12:00PM | PVF 1 | 651 | 654 |  | 2013-04-07 00:00:00 | Sunday | 12:00PM | PVF 1 | 655 | 651
2013-02-24 00:00:00 | Sunday | 1:00PM | PVF 1 | 656 | 658 |  | 2013-04-07 00:00:00 | Sunday | 1:00PM | PVF 1 | 653 | 658
2013-02-24 00:00:00 | Sunday | 2:00PM | PVF 1 | 657 | 655 |  | 2013-04-07 00:00:00 | Sunday | 2:00PM | PVF 1 | 654 | 652
2013-03-03 00:00:00 | Sunday | 11:00AM | PVF 1 | 653 | 654 |  | 2013-04-14 00:00:00 | Sunday | 11:00AM | PVF 1 | 657 | 651
2013-03-03 00:00:00 | Sunday | 12:00PM | PVF 1 | 652 | 655 |  | 2013-04-14 00:00:00 | Sunday | 12:00PM | PVF 1 | 656 | 652
2013-03-03 00:00:00 | Sunday | 1:00PM | PVF 1 | 657 | 658 |  | 2013-04-14 00:00:00 | Sunday | 1:00PM | PVF 1 | 654 | 658
2013-03-03 00:00:00 | Sunday | 2:00PM | PVF 1 | 651 | 656 |  | 2013-04-14 00:00:00 | Sunday | 2:00PM | PVF 1 | 655 | 653
Spreadsheet: 324c19c6-58aa-4dec-a9c5-7291c9f79c0c
Sheet: Sheet1

Battle ID | Date & Time | Side | Victory | Score | Opp. Score | Opp. ID | Opp. Name | Scenario ID | Front | Start Date | End Date | Name EN | Name FR
42779734 | 2014-08-18 20:31:01 | ALLIES | 1 | 10 | 3 | 417473 | aikobo | 7662 | eastern | 1942-10-22 | 1942-10-22 | Red Barricades Factory | Les Barricades Rouges
42780104 | 2014-08-18 21:04:34 | AXIS | 1 | 10 | 8 | 417473 | aikobo | 7662 | eastern | 1942-10-22 | 1942-10-22 | Red Barricades Factory | Les Barricades Rouges
Spreadsheet: 712834d1610440853-how-to-use-formula-to-directly-calculate-how-many-student-no-excl-the-repeated-no-excel-inq-210112
Sheet: 工作表1

The total student no. inputted:
The no. repetaed:
 |  |  |  | Question: How can I use formula to directly calculate the how many student no. (excluding the repeated no.) occurred in the table?
Serial No. | Student no. | Is it repeated? |  | How many student no. occurred?
1 | A123
2 | A123
3 | B678
4 | A889
5 | B678
6 | A999
7 | A789
8 | B765
9 | B883
10 | B883
Spreadsheet: 872840d1719289873-need-a-formula-for-the-spreadsheet-attached-michaelb24-test-187-aligw
Sheet: Test

 |  | Name | Age | Group |  |  |  | Orange | Age |  |  | Blue | Age |  |  | Purple | Age |  |  | Yellow | Age
 |  | [NAME] | 17 | Orange |  |  | 1 |  | 17 |  | 1 |  | 16 |  | 1 |  | 20 |  | 1 |  | 16
 |  | George | 19 | Orange |  |  | 2 | George | 19 |  | 2 | [NAME] | 15 |  | 2 | [NAME] | 14 |  | 2 | [NAME] | 16
 |  | Marcus | 16 | Yellow |  |  | 3 | [NAME] | 15 |  | 3 | Bianca | 16 |  | 3 |  |  |  | 3 | [NAME] | 19
 |  | [NAME] | 16 | Yellow |  |  | 4 | [NAME] | 18 |  | 4 |  |  |  | 4 |  |  |  | 4
 |  | [NAME] | 15 | Orange |  |  | 5 | [NAME] | 16 |  | 5 |  |  |  | 5 |  |  |  | 5
 |  | Daneil | 20 | Purple |  |  | 6 | [NAME] | 16 |  | 6 |  |  |  | 6 |  |  |  | 6
 |  | [NAME] | 18 | Orange |  |  | 7 | [NAME] | 17 |  | 7 |  |  |  | 7 |  |  |  | 7
 |  | [NAME] | 16 | Blue |  |  | 8 | [NAME] | 20 |  | 8 |  |  |  | 8 |  |  |  | 8
 |  | [NAME] | 15 | Blue |  |  | 9 |  |  |  | 9 |  |  |  | 9 |  |  |  | 9
 |  | [NAME] | 16 | Orange |  |  | 10 |  |  |  | 10 |  |  |  | 10 |  |  |  | 10
 |  | [NAME] | 14 | Purple |  |  | 11 |  |  |  | 11 |  |  |  | 11 |  |  |  | 11
 |  | [NAME] | 16 | Orange |  |  | 12 |  |  |  | 12 |  |  |  | 12 |  |  |  | 12
 |  | Bianca | 16 | Blue |  |  | 13 |  |  |  | 13 |  |  |  | 13 |  |  |  | 13
 |  | [NAME] | 17 | Orange |  |  | 14 |  |  |  | 14 |  |  |  | 14 |  |  |  | 14
 |  | [NAME] | 20 | Orange |  |  | 15 |  |  |  | 15 |  |  |  | 15 |  |  |  | 15
 |  | [NAME] | 19 | Yellow |  |  |  |  |  |  | 16 |  |  |  | 16 |  |  |  | 16
 |  |  |  |  |  |  |  |  |  |  | 17 |  |  |  | 17 |  |  |  | 17
 |  |  |  |  |  |  |  |  |  |  | 18 |  |  |  | 18 |  |  |  | 18
 |  |  |  |  |  |  |  |  |  |  | 19 |  |  |  | 19 |  |  |  | 19
 |  |  |  |  |  |  |  |  |  |  | 20 |  |  |  | 20 |  |  |  | 20
 |  |  |  |  |  |  |  |  |  |  | 21 |  |  |  | 21 |  |  |  | 21
 |  |  |  |  |  |  |  |  |  |  | 22 |  |  |  | 22 |  |  |  | 22
 |  |  |  |  |  |  |  |  |  |  | 23 |  |  |  | 23 |  |  |  | 23
 |  |  |  |  |  |  |  |  |  |  | 24 |  |  |  | 24 |  |  |  | 24
 |  |  |  |  |  |  |  |  |  |  | 25 |  |  |  | 25 |  |  |  | 25
 |  |  |  |  |  |  |  |  |  |  | 26 |  |  |  | 26 |  |  |  | 26
 |  |  |  |  |  |  |  |  |  |  | 27 |  |  |  | 27 |  |  |  | 27
 |  |  |  |  |  |  |  |  |  |  | 28 |  |  |  | 28 |  |  |  | 28
 |  |  |  |  |  |  |  |  |  |  | 29 |  |  |  | 29 |  |  |  | 29
 |  |  |  |  |  |  |  |  |  |  | 30 |  |  |  | 30 |  |  |  | 30
Spreadsheet: 61589d1262526555-two-y-axis-both-using-same-data-series-frost-20iwi-20graphsv1-1-
Sheet: 2- fletton

 | WDR Zone 1 |  | WDR Zone 2 |  | WDR Zone 3 |  | WDR Zone 4
 | Cambridge | London | Grendon Underwood | Wallingford | [NAME] | [NAME] | [NAME] | Rawtenstall
None | 8.93 | 3.38 | 45.81 | 13.68 | 30.59 | 12.12 | 9.33 | 29.46
WF | 33.25 | 39.02 | 55.92 | 30.02 | 54.77 | 31.07 | 19.88 | 40.45
MW | 33.55 | 39.19 | 56.35 | 30.73 | 56.18 | 31.58 | 20.7 | 40.88
EPS | 33.58 | 39.18 | 56.28 | 30.65 | 55.61 | 31.65 | 20.43 | 40.67
PF | 33.64 | 39.77 | 56.75 | 30.44 | 54.58 | 31.5 | 20.24 | 41.17
Fletton brick free water saturation (Wf) |  |  |  | 278 | kg/m3 | 278 is 100%
75% of Wf Fmax |  |  |  | 208.5 | kg/m3
 |  |  | 50 | 139
 |  |  | 25 | 69.5
 |  |  | 20 | 55.6
 |  |  | 10 | 27
 |  |  | 5 | 13.9
 |  |  | 3.5 | 9.73
Spreadsheet: darrell_schoolcraft__7309__imball0201
Sheet: Amarillo

Amarillo Natural Gas |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | Contract  21579
contract 21534
 | poi 28786 |  | poi 56993 |  | poi 500170 |  | poi 10746 |  | poi 13247 |  | poi 500520 |  | poi 500171
 | Adobe [NAME] |  | [NAME] |  | ANG-Scott/Bandy II |  | [NAME] |  | [NAME] |  | [NAME] |  | ANG O Neal&Shadid
 | Measured | Scheduled | Measured | Scheduled | Measured | Scheduled | Measured | Scheduled | Measured | Scheduled | Measured | Scheduled | Measured | Scheduled
1 | -2197 | -2135 |  | -25
2 | -2276 | -2135 | -4 | -25
3 | -2197 | -2135 |  | -25
4 | -2147 | -2135 |  | -25
5 | -2142 | -2135 |  | -25
6 | -2155 | -2135 |  | -25
7 | -2065 | -2135 |  | -25
8 | -2033 | -2135 | -2 | -25
9 | -2041 | -2135 | -2 | -25
10 | -2149 | -2135 |  | -25
11 | -2104 | -2135 |  | -25
12 | -2098 | -2135 |  | -25
13 | -2095 | -2135 |  | -25
14 | -2107 | -2135 |  | -25
15 | -2037 | -2135 |  | -25
16 | -2142 | -2135 |  | -25
17 | -2099 | -2135 |  | -25
18 | -2195 | -2135 |  | -25
19 | -2128 | -2135 |  | -25
20 | -2170 | -2135 |  | -25
21 | -2072 | -2135 |  | -25
22 | -1958 | -2135 |  | -25
23
24
25
26
27
28
29
30
31
index
2001-12-31 00:00:00 |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 93989.4
2002-01-22 00:00:00
CBS Volume
 |  |  | 39070
Spreadsheet: 03027ac1-6626-466c-8f3d-ac53e16ba179
Sheet: FACULTY INFORMATION FORM

Please use capital letters & no punctuation | EXAMPLE | class 1 info | class 2 info | class 3 info | class 4 info | class 5 info | class 6 info
Last Name | LOGAN
First Name | SARAH
MI | M
Printed Course Prefix (e.g. GOVT, PHIL, CRIJ) and Number | PSY3303
Printed Date/Time (e.g. MW 08:00 AM, TR 12:30 PM or MWF 18:00 PM) | TR 18:00 PM
Bubbled in Meeting Days (MTWRFSN) NO [NAME] or Spaces | TR
In the Classroom Survey = Face  OR  Online Survey = Online | Face
Eight Week Course = Y (yes) or N (no).    If YES… 1 for first eight weeks or 2 for second eight weeks | Y-2
For On-line courses ONLY - Print course title. In addition, please provide a class roster with [NAME] "username@angelo .edu" with your FIF.  Dropped students can be withdrawn later. | Learning  and Cognition
Objectives:  (Scale - M = Minor or No Importance,  I = Important,                              E = Essential) | M, I, E | M, I, E | M, I, E | M, I, E | M, I, E | M, I, E | M, I, E
1.  Gaining factual knowledge (terminology, classifications, methods,       trends) | E
2.  Learning fundamental principles, generalizations, or theories | E
3.  Learning to apply course material (to improve thinking, problem       solving,  and decisions) | E
4.  Developing specific skills, competencies, and points of view needed       by professionals in the field most closely related to this course | I
5.  Acquiring skills in working with others as a member of a team | I
6.  Developing creative capacities (writing, inventing, designing,       performing in art, music, drama, etc.) | M
7.  Gaining a broader understanding and appreciation of       intellectual/cultural activity (music, science, literature, etc.) | M
8.  Developing skill in expressing oneself orally or in writing | M
9.  Learning how to find and use resources for answering questions or       solving problems | M
10.  Developing a clearer understanding of, and commitment to, personal         values | M
11.  Learning to analyze and critically evaluate ideas, arguments,         and points of view | M
12.  Acquiring an interest in learning more by asking questions and         seeking answers | M
[NAME] (e.g. POLS, PHIL) | PSY
Discipline codes:  POL SCI  = 4510,   PHIL = 3801,  PUB ADMIN = 4400                                                       (4 digits) | 4200
[NAME] (e.g. 800, 1230, or 1800) | 800
Bubbled Course Number                                                 (4 digits) | 3303
Enrollment | 23
Local Code for GOVT 2301, 2302 = 0400 or Honors  = 0401  (4 digits)
Long (L) or Short (S) Forms | L
Number of Additional Questions to be answered on the Survey  ([NAME]. number of Additional questions that can be asked for Long form = 19 & Short form = 10) | 12
Is this class [NAME]?   Y or N | N
Spreadsheet: 550430d1512329475-removing-duplicate-name-but-adding-sum-to-original-annual-leave-code
Sheet: Sheet1

Pay Number | Name | annual leave
123 | [NAME] | 00:01:00
234 | [NAME] | 00:01:00
134 | Billy | 00:01:00
543 | [NAME] | 00:01:00
123 | [NAME] | 00:01:00
134 | Billy | 00:01:00
Spreadsheet: 118751d1313980239-help-with-function-solved-proposed-srot
Sheet: Sheet1

STUDENT RECORD OF TRAINING
NAME |  | (LAST, FIRST MI) |  |  | SSN: |  | STUDENT #:
SGL  NAME: |  |  |  |  |  |  | CLASS:
EVALUATION |  | SCORE |  | RETEST (70 MAX) |  | RETEST #2 REQUIRES APPROVED  REBUTTAL (70 MAX) |  | FINAL RATING (SUP / SAT / UNSAT)
 |  |  |  | Add scores and divide by number of                                    scores to determine overall class score
 |  |  |  | UNSAT (0 - 69)  SAT (70 - 89)  SUP (90% -100%)
REMARKS:  (e.g. Commandant's List, Distinguished [NAME], [NAME])
NOTE:   [NAME] students passing retest 70% for grade averaging.  However, record the final retest score in                the student's record to establish the level of proficiency attained. (Students do not qualify for class               honors if they must retest in any area listed above).
SGL SIGNATURE and DATE:
STU SIGNATURE and DATE:
 |  |  |  | SH-2-2
Spreadsheet: benjamin_rogers__1244__Simple Cycle (LM6000) Entergy model
Sheet: IDC

IDC CALCULATIONS
Total Construction & Other Costs (000$):
No. of Construction Months:
Interest During Construction:
 |  | Annual | Daily (360-Day)
 |  |  | Turbine Cost | Construction &
IDC Calculations |  |  | including [NAME] | Other Cost | Principal | Balance | Interest | Cum. Interest
Month | Date | % Drawn | (000$) | (000$) | (000$) | (000$) | (000$) | (000$)
1 | 2000-04-01 00:00:00 |  |  |  |  |  | 0 | 0
 | 2000-05-01 00:00:00 |  | 0
 | 2000-06-01 00:00:00 |  | 0
 | 2000-07-01 00:00:00 |  | 0
 | 2000-08-01 00:00:00 |  | 0
 | 2000-09-01 00:00:00 |  | 0
 | 2000-10-01 00:00:00 |  | 0
 | 2000-11-01 00:00:00 |  | 0
 | 2000-12-01 00:00:00 |  | 0
 | 2001-01-01 00:00:00 |  | 0
 | 2001-02-01 00:00:00 |  | 0
 | 2001-03-01 00:00:00 |  | 0
 | 2001-04-01 00:00:00 |  | 0
 | 2001-05-01 00:00:00 |  | 0
 | 2001-06-01 00:00:00 |  | 0
 | 2001-07-01 00:00:00 | 0 | 0
 | 2001-08-01 00:00:00 | 0 | 0
 | 2001-09-01 00:00:00 | 0 | 0
 | 2001-10-01 00:00:00 | 0 | 0
TURBINE DELIVERY SCHEDULE
 |  |  |  |  | *Rough Estimate by [NAME]. Please double-check for deal specific
 |  |  |  |  |  | Turbine No. | 2 | 3 | 4 | 5 | 6
Unit | Turbines | Delivery | LD'S |  | Month | No. of Months | 6 | 6.5 | 7 | 7.5 | 8
Number | Delivered | Schedule | Enforced On |  | 1 |  | 0.17 | 0.17 | 0.17 | 0.17 | 0.17
1-3 | 3 | 2000-07-30 00:00:00 | 2000-10-30 00:00:00 |  | 2 |  | 0.16 | 0.16 | 0.12 | 0.12 | 0.12
4-6 | 3 | 2000-08-30 00:00:00 | 2000-10-30 00:00:00 |  | 3 |  | 0.16 | 0.13 | 0.12 | 0.12 | 0.12
7-8 | 2 | 2000-09-30 00:00:00 | 2000-10-30 00:00:00 |  | 4 |  | 0.16 | 0.16 | 0.14 | 0.14 | 0.14
9-11 | 3 | 2000-10-30 00:00:00 | 2000-10-30 00:00:00 |  | 5 |  | 0.17 | 0.16 | 0.18 | 0.13 | 0.13
12-13 | 2 | 2000-11-30 00:00:00 | 2000-11-30 00:00:00 |  | 6 |  | 0.18 | 0.12 | 0.12 | 0.12 | 0.12
14-15 | 2 | 2000-12-30 00:00:00 | 2000-12-30 00:00:00 |  | 7 |  | 0 | 0.1 | 0.15 | 0.1 | 0.1
16-18 | 3 | 2000-01-30 00:00:00 | 2000-01-30 00:00:00 |  | 8 |  | 0 | 0 | 0 | 0.1 | 0.1
19-20 | 2 | 2001-02-28 00:00:00 | 2001-02-28 00:00:00 |  | 9 |  | 0 | 0 | 0 | 0 | 0
21-22 | 2 | 2001-03-30 00:00:00 | 2001-03-30 00:00:00 |  | 10 |  | 0 | 0 | 0 | 0 | 0
23-24 | 2 | 2001-04-30 00:00:00 | 2001-04-30 00:00:00 |  | 11 |  | 0 | 0 | 0 | 0 | 0
 |  |  |  |  | 12 |  | 0 | 0 | 0 | 0 | 0
 |  |  |  |  | 13 |  | 0 | 0 | 0 | 0 | 0
Summary (000$): |  |  |  |  | 14 |  | 0 | 0 | 0 | 0 | 0
Basis Per Turbine with Enhanced Sprint Option |  |  | 13950 |  | 15 |  | 0 | 0 | 0 | 0 | 0
Carry Cost Per Turbine |  |  | 289.6162739983738 |  | Sum
WestLB Structuring, Restructuring & Legal Fees |  |  | 20.83333333333331
Total Price
Spreadsheet: louise_kitchen__22553__Hot List Update 07-17-01 - Management
Sheet: E-Commerce -50

Deal Description Sheet - 7/17/01
[NAME]
Project Name | Lead Originator | Counterparty | Description | Potential Valuation | Last Customer Contact | Probability | Expected Closing (Month/Year) | Weekly Updates / Comments
[NAME] | [NAME] | EOTT | Back office accounting services. | *$500,000 | 2001-07-13 00:00:00 | 0.25 | 2001-10-01 00:00:00 | EOTT met HMS in mid-June.  ENA has reviewed ATS proposal.  ENA will work with ATS to re-submit a more competitive proposal.  Meeting scheduled for July 25th.
Callon | [NAME] | Callon | Outsourcing | 100000 | 2001-07-14 00:00:00 | 0.1 | 2001-10-01 00:00:00 | Rescheduled meeting with COO for August.
[NAME] | [NAME] | Pure Resources | Integrated outsourcing products. | *$250,000 | 2001-06-11 00:00:00 | 0.25 | 2001-12-01 00:00:00 | Met with Pure senior management on 6/29.  Pure executive meeting on 7/2.  [NAME] has signed a CA and data gathering trip is planned.
Gather Company | ?? | Gather Company | Monetization and metering services. | 200000 | 2001-05-10 00:00:00 | 0.25 | 2001-12-01 00:00:00 | Follow up meeting in July, 2001.
Running Man | [NAME] | Marathon | Integrated outsourcing products. | *$1,000,000 | 2001-06-11 00:00:00 | 0.1 | 2001-12-01 00:00:00 | Meeting in July.
 |  |  |  |  |  |  |  | *Accrual
Spreadsheet: 836912d1689711773-help-with-formatting-format-problem
Sheet: Sheet1

 | Need help with simple formatting
 | Excel 2019
 | Some with decimal places, some without.
 | Formatting for 14 dights drops the decimals
 | That is, 14 digits forced leading zeros.
 | I have tried multiple formats, but can not achive my goal
 | With decimal |  |  | Without Decimal
 |  | [PHONE].67 |  |  | 00000001234567
 |  | [PHONE].78 |  |  | 00000002345678
 | Addition (C4+C5) |  |  | Addition (F4+F5)
 | formatted for 14 digits |  |  | OK
 | Desired Format |  |  | Desired [NAME] (no decimal place)
 |  | [PHONE].45 |  |  | 00000003580245
 |  |  |  |  | Note- No decimal
Spreadsheet: 118071d1313421585-excel-2007-macro-to-merge-columns-a-b-c-d-e-into-1-column-with-a-twist-example
Sheet: Sheet1

A | B | C | D | E | [NAME] | QTY | P/M | SHRINK
G03A8 |  |  |  |  | MAIN | 1 | M | 0.05
 | G03S2 |  |  |  | LS | 1 | M | 0.1
 |  | G03S1 |  |  | BASKET | 1 | M | 0.15
 |  |  | G03C078 |  | BASKET PAINTED | 1 | P | 0.2
 |  |  |  | G03C079 | BASKET MACHINED | 1 | M | 0.25
M LIST | [NAME] | QTY | P/M | SHRINK
G03A8 | MAIN | 1 | M | 0.05
G03S2 | LS | 1 | M | 0.1
G03S1 | BASKET | 1 | M | 0.15
G03C079 | BASKET MD | 1 | M | 0.25
P LIST | [NAME] | QTY | P/M | SHRINK
G03C078 | BASKET PD | 1 | P | 0.2
Spreadsheet: 65821d1266477796-urgently-need-help-sample
Sheet: Search

 |  |  | bn
 |  |  | bt |  | Duration
 |  |  |  |  | 17 |  |  |  |  |  |  | Medical Check Up
 |  |  |  |  |  |  |  |  |  |  |  | 2010-02-02 00:00:00 | Tihama | fit
 |  |  |  |  | Search name
 |  |  |  |  | Name |  | Father name |  | In | to |  | BLK LN
 |  |  |  |  | fatmah | bt | udin |  | 2010-02-01 00:00:00 | saudi |  | [NAME] | 0 | 0
 |  |  |  |  | Mencari: | fatmah bt udin
 |  |  |  |  |  |  |  |  |  |  |  |  | Jakarta, | 2010-02-18 00:00:00
Spreadsheet: 803213d1667316891-formula-to-vlookup-and-search-book6-1-
Sheet: Sheet1

Source 1 | Result |  |  |  |  | Source 2
Welbeeing 05 2022 -   qwerty Name Surname |  |  |  |  |  | asdfgh Name Surname
Welbeeing 05 2022 -asdfgh Name Surname |  |  |  |  |  | qwerty Name Surname
Welbeeing 05 2022 -987654 Name Surname |  |  |  |  |  | 123456 Name Surname
 |  |  |  |  |  | 987654 Name Surname
 |  |  |  |  |  | qazwsx [NAME]
 |  |  |  |  |  | uklyhn Name Surname
Spreadsheet: 140277d1328678348-countif-results-wrong-problem
Sheet: Sheet1

 |  | I have data of times that customers enter a shop during the day, I need a formuala to tally the number entering at specific times
 |  | 01:35:00
 |  | 01:35:00
 |  | 01:36:00
 |  | 01:36:00
 |  | 01:36:00
 |  | 01:36:00
 |  | 01:37:00
 |  | 01:39:00
 |  | 01:40:00
 |  | 01:40:00
 |  | 01:41:00
 |  | 01:41:00
 |  | 01:41:00
 |  | 01:42:00
 |  | 01:46:00
 |  | 01:46:00
 |  | 01:46:00
 |  | 01:47:00
 |  | 01:49:00
 |  | 01:51:00
 |  | 01:51:00 |  | Number that entered | 2 | 4 | 1 | 0 | 1 | 2 | 3 | 1 | 0 | 0 | 0 | 3 | 0 | 0 | 1 | 0 | 2 | 0 | 1 | 0 | 0 | 0 | 0 | 1 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0
 |  | 01:52:00 |  | Time of date | 01:35:00 | 01:36:00 | 01:37:00 | 01:38:00 | 01:39:00 | 01:40:00 | 01:41:00 | 01:42:00 | 01:43:00 | 01:44:00 | 01:45:00 | 01:46:00 | 01:47:00 | 01:48:00 | 01:49:00 | 01:50:00 | 01:51:00 | 01:52:00 | 01:53:00 | 01:54:00 | 01:55:00 | 01:56:00 | 01:57:00 | 01:58:00 | 01:59:00 | 02:00:00 | 02:01:00 | 02:02:00 | 02:03:00 | 02:04:00 | 02:05:00 | 02:06:00 | 02:07:00 | 02:08:00 | 02:09:00 | 02:10:00 | 02:11:00 | 02:12:00 | 02:13:00 | 02:14:00 | 02:15:00 | 02:16:00 | 02:17:00 | 02:18:00 | 02:19:00 | 02:20:00 | 02:21:00 | 02:22:00
 |  | 01:52:00
 |  | 01:52:00
 |  | 01:53:00
 |  | 01:54:00
 |  | 01:55:00
 |  | 01:57:00
 |  | 01:58:00
 |  | 01:59:00
 |  | 02:00:00
 |  | 02:01:00
 |  | 02:03:00
 |  | 02:03:00
 |  | 02:04:00
 |  | 02:04:00
 |  | 02:04:00
 |  | 02:06:00
 |  | 02:08:00
 |  | 02:10:00
 |  | 02:10:00
 |  | 02:11:00
 |  | 02:13:00
 |  | 02:14:00
 |  | 02:14:00
 |  | 02:17:00
 |  | 02:21:00
 |  | 02:21:00
 |  | 02:22:00
Spreadsheet: drew_fossum__8871__captiverecap
Sheet: Recap of captive vs non captive

Captive vs Non Captive Breakout of Market and Field Deliveries (11/98 - 10/99)
 |  | Capacity Release |  |  |  |  | Alternate Deliveries
 |  | Market |  | Field |  |  | Market |  | Field
Winter
Non - Captive |  |  | 1/ |  | 3/ |  |  | 9/ | 7027124 | 11/
Captive |  |  | 2/ |  | 4/ |  |  | 10/ |  | 12/
Total |  | 15465674 |  | 64461671 |  |  | 16903132 |  | 12513472
Summer
Non-Captive |  |  | 5/ |  | 7/ |  |  | 13/ | 10211305 | 15/
Captive |  |  | 6/ |  | 8/ |  |  | 14/ |  | 16/, 17/
Total |  | 19794836 |  | 118332472 |  |  | 65377717
Top 2 Markets in each Category
[NAME], Zone ABC MidAm - 2.7 Bcf
2/ [NAME], Semco Zone EF- [NAME]
3/ PEPL-Mullinville - 2.3 Bcf, ANR-Greensburg - 1.6 Bcf
4/ Demarc - 50 Bcf, Dodge City TBS #1- .4 Bcf
5/ [NAME], Mid Am Zone ABC - 2.1 Bcf
6/ UCU Zone ABC - .8 Bcf, Semco - .7 Bcf
7/ Powertex - 4.8 Bcf, [NAME]
8/ [NAME], UCU Argus - 1 Bcf
9/ [NAME], Glenwood - 1.8 Bcf
10/ LSP Cottage Grove - 1.7 Bcf, UCU Zone ABC - .9 Bcf
11/ ANR Greensburg - 1.9 Bcf, PEPL Mullinville - 1 Bcf
12/ Bushton - 1.3 Bcf, [NAME] - .6 Bcf
13/Glenwood - 12.5 Bcf, [NAME]
14/ Ogden - 33.9 Bcf, LSP Cottage Grove - 2.7 Bcf, Cenex - .9 Bcf
15/ Oasis Waha - 1.4 Bcf, [NAME] - 1.4 Bcf
16/ Bushton - .9 Bcf, [NAME] - .3 Bcf
17/ Also includes 5.2 Bcf Mobil deliveries to Bushton, coded as alternate due to receipt pts
Spreadsheet: 044aa192-1a62-484e-96c0-6ec346c93213
Sheet: PAG 16 - table 1

 | Net finance results |  | 3Q10 | 3Q11 | YTD 10 | YTD 11
 | R$ million
 |  | Interest income | 136.647 | 167.003 | 308.43 | 426.265
 |  | Interest expenses | -172.581 | -151.74 | -488.877 | -451.587
 |  | Gains/(losses) on derivative instruments | 95.362 | -195.783 | 41.095 | -154.824
 |  | Gains/(losses) on non-derivative instruments | 24.344 | -100.895 | 1.168 | -87.647
 |  | Taxes on financial transactions | -7.794 | -10.741 | -28.125 | -32.033
 |  | Other financial income/(expenses), net | -27.867 | -14.184 | -77.704 | -77.357
 | Net finance results |  | 48.11099999999999 | -306.34 | -244.013 | -377.183