tianzl66/Sheetpedia huggingface dataset:
Spreadsheet: 028fe43d-d94b-4ed7-8b77-d2fcd547725f
Sheet: Sheet1

 |  |  |  | UNIVERSITY OF MARY WASHINGTON
 |  |  |  | WEEKLY TIME CARD
Last Name/First Name: |  | Last/First |  |  | Period Start Date: |  | 2008-05-26 00:00:00
CIPPS Employee ID # |  | 007digits00 |  |  | Department: |  | Dept Name
TIME WORKED
Day | Date | Time In | Time Out | Time In | Time Out | Time In | Time Out | Total Hours Worked
Monday
Tuesday
Wednesday
Thursday
Friday
Saturday
Sunday
 | Weekly Total
· Non-exempt employees must complete the timesheet, print, sign and submit to supervisor at the end of each week.
· Non-exempt employees must be paid at the time & 1/2 hourly rate for hours worked over 40 within the workweek.
· Employees are to obtain pre-approval from their supervisor before working overtime hours.
· Supervisors or departmental time keepers are to keep employee time sheets on file for 4 years.
Employee Signature/Date |  |  |  |  | [NAME]'s or Designee's Signature/Date
By signing above, we certify that the information on this form is accurate and complete.
[NAME]:
Hours should be keyed in military time form as shown below.
A colon must be keyed between the hour and minutes when entering the time.
Minutes should be rounded to the nearest quarter hour and entered as either 00, 15, 30, 45.
Minutes are converted into hundreths for Total Hours Worked column. Payroll pays minutes in hundreths.
 | Actual time | Time to Enter
 | 01:00:00 | 01:00:00
 | 02:00:00 | 02:00:00
 | 03:00:00 | 03:00:00
 | 04:00:00 | 04:00:00 |  | For example:
 | 05:00:00 | 05:00:00 |  | If you have come in or left at 4:30pm, enter as 16:30.
 | 06:00:00 | 06:00:00 |  | Likewise, 4:15pm would be entered as 16:15 and
 | 07:00:00 | 07:00:00 |  | 4:45pm  would be entered as 16:45.
 | 08:00:00 | 08:00:00
 | 09:00:00 | 09:00:00
 | 10:00:00 | 10:00:00
 | 11:00:00 | 11:00:00
 | 12:00:00 | 12:00:00
 | 13:00:00 | 13:00:00
 | 14:00:00 | 14:00:00
 | 15:00:00 | 15:00:00
 | 16:00:00 | 16:00:00
 | 17:00:00 | 17:00:00
 | 18:00:00 | 18:00:00
 | 19:00:00 | 19:00:00
 | 20:00:00 | 20:00:00
 | 21:00:00 | 21:00:00
 | 22:00:00 | 22:00:00
 | 23:00:00 | 23:00:00
 | 1900-01-12 00:00:00 | 1900-01-01 00:00:00
Spreadsheet: 865101d1712165894-multi-vlookup-formula-with-results-in-one-setting-and-set-out-in-paragraphs-mock-up
Sheet: Sheet1

One | Hello
Two | Goodbye
Three | Mong
Four | Lard
Five | Bellow
Six | Beyond
Seven | Several
Eight | Issue
Nine | Terrible
Ten | Figure
Spreadsheet: 188098d1350675883-comparing-two-documents-in-one-excel-please-help
Sheet: Sheet1

Part Name |  |  |  |  |  |  |  |  |  |  |  | QTY 1 | QTY2 | Delta
I would like this to be blank but once information is given to Sheet 2 and Sheet 3 it to show an outcome |  |  |  |  |  |  |  |  |  |  |  | Part amount for P1 for Sheet 2 | Part amount for P1 for Sheet 3 | Part amount difference
same as A2
same as A2
same as A2
same as A2
same as A2
So on and So forth till I do not need any more places for different named parts.
This is what I would like the outcome to look like
Part Name |  | QTY1 | QTY2 | Delta
P1 |  | 18 | 19 | -1
P2 |  | 3 | 3 | 0
P3 |  | 2 | 2 | 0
P4 |  | 2 | 15 | -13
P5 |  | 1 | 5 | -4
Spreadsheet: 96238d1295634877-excel-2007-creating-an-automatic-system-moodlets
Sheet: Database

List of Possible Mood Modifiers
Icon | [NAME] | Effect | Duration | Description | Notes
 | Hungry | No Effect | 3 Hours | You are a wee bit peckish. The stomach growling isn't far behind. | After the 3 hours it will change to "Very Hungry".
 | Very Hungry | -40 | 24 Hours | Gnawing hunger is not a good feeling for you. Eat regularly to avoid. | Changes to Starving when time expires.
 | Starving | -80 | 24 Hours | Allowing yourself to starve is quite cruel! Eat immediately! | -
 | Good Meal | 15 | 8 Hours | You enjoyed that meal more than the standard fare.
 | Great Meal | 25 | 8 Hours | Great meals can be rare, but it will be remembered for some time.
 | Amazing Meal | 40 | 8 Hours | That meal was awesome! The explosion of flavor will be hard to forget.
 | Sleepy | No Effect | 3 Hours | Get yourself to bed soon, to avoid the wrath of the truly tired. | After 3 hours, you will become "Tired".
 | Tired | -40 | 3 Hours | When you get too tired, your mood will begin to go south. | After 3 hours, you will become "Exhausted". |  | Legend
 | Exhausted | -50 | Until Sleep | At this level of sleep deprivation, even the floor looks like a good bed. | - |  |  | Negative Modifier
 | Well Rested | 15 | 10 Hours | It's easy to wake up when you got plenty of time in the bed. | Overrides Sleepy, Tired and Exhausted. |  |  | Positive Modifier
 | Had A Nice Nap | 5 | 5 Hours | Having a great nap may be enough to hold back the onset of sleep. | Overrides Sleepy, Tired and Exhausted. |  |  | Neutral Modifier
These are just a few examples of some of the possible mood modifiers that I will be using in this system. As you can see, each one of them have a different mood effect and lasts for a certain duration.
Note that the first six modifiers (from "Hungry" to "Amazing Meal") are RELATED modifiers since they are all about hunger and how I might currently feel about it.
Please note that negative modifiers (in red) change to even worse modifiers if no related positive modifiers are activated before its time expires.
Also note that positive modifiers may OVERRIDE their related negative modifiers when they are activated (as it happens with B13 and B14, where both overrides B10, B11 and B12 when activated).
Spreadsheet: 766206d1643800228-formula-to-count-max-number-of-simultaneous-events-example
Sheet: Sheet1

2022-01-01 00:00:00 | 2022-01-10 00:00:00
2022-01-01 00:00:00 | 2022-01-02 00:00:00 |  | Date | Number of open events
2022-01-02 00:00:00 | 2022-01-04 00:00:00
2022-01-06 00:00:00 | 2022-01-10 00:00:00 |  | 2022-01-01 00:00:00 |  |  | =COUNTIFS(A:A,"<="&D4,B:B,">="&D4)
2022-01-07 00:00:00 | 2022-01-09 00:00:00 |  | 2022-01-02 00:00:00
 |  |  | 2022-01-03 00:00:00
 |  |  | 2022-01-04 00:00:00
 |  |  | 2022-01-05 00:00:00
 |  |  | 2022-01-06 00:00:00
 |  |  | 2022-01-07 00:00:00
 |  |  | 2022-01-08 00:00:00
 |  |  | 2022-01-09 00:00:00
 |  |  | 2022-01-10 00:00:00
 |  |  | [NAME] |  |  | =MAX(E4:[NAME])
Spreadsheet: 867118d1713997220-changing-template-data-employee-absence-report-copy-
Sheet: December

 | Employee Absence Report
 | December
 | Absence type key | V | Vacation (10) |  |  | P | Paid (2) |  |  | S | Unpaid (1) |  |  | U | Unauthorized |  |  | O | Other
 |  | Dates of absence
 | Employee name | 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 | Total days
 | [NAME]. M  (PMO)
 | [NAME]. P  (PMO)
 | [NAME]. R  (GL)
 | [NAME]. M  (GL)
 | Teddy. M  (GL)
 | Krushna. J  (DLO)
 | [NAME]. W  (PFO)
 | Jaxon. B  (PMO)
 | Daman. S (PMO)
 | Alvin. C  (GL)
 | Baldomero. N  (GL)
 | Junner. B  (GL)
 | Heather. C  (PFO)
 | Jordan. B  (LO)
 | Santos. C  (GL)
 | Sunny. I  (GL)
 | Oliver. M  (PR)
 | [NAME]. C  (TL)
 | Justin. H  (YFO)
 | [NAME]. M  (YFO)
 | [NAME]. T  (YFO)
 | [NAME]. B  (SHC)
 | [NAME]. H  (IM)
 | [NAME]. A  (IM)
 | [NAME]. M  (IM)
 | Maryanne. B  (IMA)
 | Art. P  (MF)
 | Fabrice. M  (MF)
 | [NAME]. T (IE)
 | [NAME]. P  (IE)
 | Justin. N  (IEA)
 | Paige. B  (WMR)
 | Maryann. R  (PSC)
Spreadsheet: 885140d1734556879-add-or-remove-rows-to-only-part-of-the-columns-of-a-table-add-or-embedd-a-row-into-columns-of-an-existing-table-original
Sheet: BooKRef Team E

Team A
Surname | First name | Number | [NAME] | Task A | Part of Task A completed | Next part of Task A | x1 | Task B | Part of Task B completed | Next part of Task B | x2 | Task C | Part of Task C completed | Next part of Task C | [NAME] | Task D | Part of Task D completed | Next part of Task D
 |  |  |  | M05 IME | BSC-IME
 |  |  |  | M05 IME | BSC-SF
 |  |  |  | M07 IME | BSC-TR1
 |  |  |  | M06 IME | ADV-TR1
Spreadsheet: 668627d1584946977-how-to-perform-vlookup-for-the-2nd-criteria-row-in-the-table-array-sample-workbook-problem-1-
Sheet: Sheet1

[NAME] |  | Item | Quantity | Quantity Sold |  |  |  | Surname | First Name | Item
Surname | First Name |  |  |  |  |  |  | Brent
Brent | [NAME] | Tables | 13 | 8
Brent | [NAME] | Doors | 20 | 12
Calvin | [NAME] | Sofa | 21 | 17
[NAME] | Scott | Chairs | 15 | 9
Lopez | [NAME] | Utensils | 10 | 2
Martinez | [NAME] | Bed | 8 | 0
 |  |  |  |  |  |  |  | 2nd "Brent" will not show [NAME] as the vlookup command in the first anem and the [NAME] does not change too.
Spreadsheet: 123889d1317917223-need-to-populate-summary-tab-based-on-other-tabs-data
Sheet: Q1

Name |  | 2011-01-01 00:00:00 | 2011-01-02 00:00:00 | 2011-01-03 00:00:00 | 2011-01-04 00:00:00 | 2011-01-05 00:00:00 | 2011-01-06 00:00:00 | 2011-01-07 00:00:00 | 2011-01-08 00:00:00 | 2011-01-09 00:00:00 | 2011-01-10 00:00:00 | 2011-01-11 00:00:00 | 2011-01-12 00:00:00 | 2011-01-13 00:00:00 | 2011-01-14 00:00:00 | 2011-01-15 00:00:00 | 2011-01-16 00:00:00 | 2011-01-17 00:00:00 | 2011-01-18 00:00:00 | 2011-01-19 00:00:00 | 2011-01-20 00:00:00 | 2011-01-21 00:00:00 | 2011-01-22 00:00:00 | 2011-01-23 00:00:00 | 2011-01-24 00:00:00 | 2011-01-25 00:00:00 | 2011-01-26 00:00:00 | 2011-01-27 00:00:00 | 2011-01-28 00:00:00 | 2011-01-29 00:00:00 | 2011-01-30 00:00:00 | 2011-01-31 00:00:00 | 2011-02-01 00:00:00 | 2011-02-02 00:00:00 | 2011-02-03 00:00:00 | 2011-02-04 00:00:00 | 2011-02-05 00:00:00 | 2011-02-06 00:00:00 | 2011-02-07 00:00:00 | 2011-02-08 00:00:00 | 2011-02-09 00:00:00 | 2011-02-10 00:00:00 | 2011-02-11 00:00:00 | 2011-02-12 00:00:00 | 2011-02-13 00:00:00 | 2011-02-14 00:00:00 | 2011-02-15 00:00:00 | 2011-02-16 00:00:00 | 2011-02-17 00:00:00 | 2011-02-18 00:00:00 | 2011-02-19 00:00:00 | 2011-02-20 00:00:00 | 2011-02-21 00:00:00 | 2011-02-22 00:00:00 | 2011-02-23 00:00:00 | 2011-02-24 00:00:00 | 2011-02-25 00:00:00 | 2011-02-26 00:00:00 | 2011-02-27 00:00:00 | 2011-02-28 00:00:00 | 2011-03-01 00:00:00 | 2011-03-02 00:00:00 | 2011-03-03 00:00:00 | 2011-03-04 00:00:00 | 2011-03-05 00:00:00 | 2011-03-06 00:00:00 | 2011-03-07 00:00:00 | 2011-03-08 00:00:00 | 2011-03-09 00:00:00 | 2011-03-10 00:00:00 | 2011-03-11 00:00:00 | 2011-03-12 00:00:00 | 2011-03-13 00:00:00 | 2011-03-14 00:00:00 | 2011-03-15 00:00:00 | 2011-03-16 00:00:00 | 2011-03-17 00:00:00 | 2011-03-18 00:00:00 | 2011-03-19 00:00:00 | 2011-03-20 00:00:00 | 2011-03-21 00:00:00 | 2011-03-22 00:00:00 | 2011-03-23 00:00:00 | 2011-03-24 00:00:00 | 2011-03-25 00:00:00 | 2011-03-26 00:00:00 | 2011-03-27 00:00:00 | 2011-03-28 00:00:00 | 2011-03-29 00:00:00 | 2011-03-30 00:00:00 | 2011-03-31 00:00:00
ABC
XYZ
Spreadsheet: 33467d1229881069-value-error-how-to-return-blank-when-value-error-bid-0901-upload
Sheet: Bid Number-Manual

Line | Days Off | Hotel Nights | Crew Nights | Effective Days Off | Marginal Crew | Pick
1 | 13 | 5 | 2 | 6 | 0 | 78
2 | 13 | 2 | 2 | 9 | 0 | 1
3 | 13 | 4 | 2 | 7 | 0 | 60
4 | 13 | 4 | 0 | 9 | 0 | 29
5 | 13 | 4 | 0 | 9 | 0 | 25
6 | 13 | 2 | 2 | 9 | 0 | 2
7 | 13 | 4 | 1 | 8 | 0 | 56
8 | 12 | 5 | 1 | 6 | 0 | 79
9 | 12 | 4 | 0 | 8 | 1 | 57
10 | 12 | 3 | 2 | 7 | 0 | 40
11 | 12 | 3 | 1 | 8 | 1 | 26
12 | 12 | 2 | 0 | 10 | 0 | 5
13 | 12 | 3 | 0 | 9 | 0 | 11
14 | 12 | 1 | 3 | 8 | 0 | 14
15 | 12 | 3 | 1 | 8 | 0 | 27
16 | 12 | 2 | 5 | 5 | 0 | 50
17 | 12 | 2 | 1 | 9 | 0 | 8
18 | 12 | 4 | 2 | 6 | 0 | 68
19 | 12 | 4 | 1 | 7 | 1 | 61
20 | 12 | 3 | 2 | 7 | 1 | 41
21 | 12 | 2 | 3 | 7 | 0 | 20
22 | 12 | 3 | 0 | 9 | 0 | 12
23 | 12 | 2 | 4 | 6 | 0 | 48
24 | 12 | 5 | 2 | 5 | 0 | 82
25 | 12 | 2 | 2 | 8 | 0 | 9
26 | 12 | 4 | 1 | 7 | 1 | 62
27 | 12 | 4 | 2 | 6 | 0 | 69
28 | 12 | 4 | 0 | 8 | 0 | 58
29 | 12 | 2 | 2 | 8 | 0 | 18
30 | 12 | 3 | 1 | 8 | 0 | 3
31 | 12 | 3 | 0 | 9 | 1 | 13
32 | 12 | 4 | 2 | 6 | 0 | 70
33 | 12 | 3 | 1 | 8 | 0 | 31 |  | 87
34 | 12 | 3 | 2 | 7 | 1 | 42
35 | 12 | 3 | 1 | 8 | 0 | 32
36 | 12 | 2 | 2 | 8 | 0 | 19
37 | 12 | 4 | 1 | 7 | 0 | 63
38 | 12 | 3 | 3 | 6 | 0 | 49
39 | 12 | 3 | 1 | 8 | 0 | 33
40 | 12 | 3 | 0 | 9 | 1 | 17
41 | 12 | 2 | 0 | 10 | 1 | 6
42 | 12 | 5 | 2 | 5 | 0 | 83
43 | 12 | 3 | 1 | 8 | 0 | 28
44 | 12 | 3 | 3 | 6 | 0 | 51
45 | 12 | 4 | 2 | 6 | 0 | 71
46 | 12 | 2 | 0 | 10 | 0 | 7
47 | 12 | 3 | 1 | 8 | 0 | 30
48 | 12 | 3 | 3 | 6 | 0 | 52
49 | 12 | 1 | 1 | 10 | 0 | 4
50 | 12 | 4 | 0 | 8 | 0 | 59
51 | 12 | 4 | 1 | 7 | 0 | 64
52 | 12 | 3 | 1 | 8 | 0 | 34
53 | 11 | 2 | 1 | 8 | 1 | 10
54 | 11 | 5 | 0 | 6 | 1 | 80
55 | 11 | 3 | 0 | 8 | 1 | 35
56 | 11 | 2 | 2 | 7 | 0 | 24
57 | 11 | 5 | 1 | 5 | 0 | 84
58 | 11 | 5 | 1 | 5 | 0 | 85
59 | 11 | 6 | 1 | 4 | 0 | 87
60 | 11 | 3 | 1 | 7 | 0 | 43
61 | 11 | 2 | 1 | 8 | 0 | 21
62 | 11 | 4 | 0 | 7 | 0 | 65
63 | 11 | 3 | 2 | 6 | 0 | 53
64 | 11 | 3 | 0 | 8 | 1 | 36
65 | 11 | 3 | 1 | 7 | 0 | 44
66 | 11 | 2 | 1 | 8 | 0 | 22
67 | 11 | 3 | 0 | 8 | 0 | 37
68 | 11 | 3 | 1 | 7 | 0 | 45
69 | 11 | 4 | 0 | 7 | 1 | 66
70 | 11 | 4 | 2 | 5 | 0 | 75
71 | 11 | 3 | 0 | 8 | 0 | 38
72 | 11 | 2 | 1 | 8 | 1 | 23
73 | 11 | 3 | 0 | 8 | 0 | 39
74 | 11 | 4 | 1 | 6 | 0 | 72
75 | 11 | 4 | 3 | 4 | 0 | 77
76 | 11 | 4 | 0 | 7 | 0 | 67
77 | 11 | 5 | 1 | 5 | 0 | 86
78 | 11 | 4 | 2 | 5 | 1 | 76
79 | 11 | 3 | 1 | 7 | 1 | 46
80 | 11 | 5 | 0 | 6 | 1 | 81
81 | 11 | 4 | 1 | 6 | 0 | 73
82 | 11 | 3 | 3 | 5 | 0 | 54
83 | 11 | 2 | 0 | 9 | 0 | 15
84 | 11 | 3 | 1 | 7 | 0 | 47
85 | 10 | 3 | 2 | 5 | 0 | 55
86 | 10 | 4 | 0 | 6 | 0 | 74
87 | 10 | 1 | 1 | 8 | 1 | 16
Spreadsheet: 766885d1644147102-pass-a-single-value-array-to-match-book1
Sheet: Sheet1

String |  | MATCH not working |  | MATCH working |  | [NAME] working |  | DV List (A11) |  | String |  | MATCH not working |  | MATCH working |  | [NAME] working |  | DV List (I11) |  | String |  | MATCH not working |  | MATCH not working |  | [NAME] working |  | DV List (I11)
123, 456, 789 |  |  |  |  |  |  |  | 123, 456 |  | abc, def, ghi |  |  |  |  |  |  |  | abc, def |  | abc, 123, ghi |  |  |  |  |  |  |  | abc
123, 789 |  |  |  |  |  |  |  | 123 |  | abc, ghi |  |  |  |  |  |  |  | abc |  | abc, ghi |  |  |  |  |  |  |  | abc, 123
123 |  |  |  |  |  |  |  |  |  | abc |  |  |  |  |  |  |  |  |  | abc |  |  |  |  |  |  |  | 123
456, 789 |  |  |  |  |  |  |  |  |  | def, ghi |  |  |  |  |  |  |  |  |  | def, ghi
 |  |  |  | +{0} |  |  |  |  |  |  |  |  |  | &{""} |  |  |  |  |  |  |  | &{""} |  | +{0}
Removing |  |  |  |  |  |  |  |  |  | Removing |  |  |  |  |  |  |  |  |  | Removing
Block 1 - strings are all numbers. |  |  |  |  |  |  |  |  |  | Block 2 - strings are all text |  |  |  |  |  |  |  |  |  | Block 3 - strings are mixed
Spreadsheet: 9b497efd-209f-4c10-b157-bad9ae818caf
Sheet: Sheet1

Test Referenced | Entry Type | Mayo ID | Description | Reporting Description | Method | Collection Container | Temperature | Stability | [NAME] | Unit of Measure | [NAME] | Minimum Volume | Reject Due To | Reference Values | Days/Times Performed | Analytic Time | Maximum Lab Time | CPT Units | CPT Code | LOINC® Code | LOINC® Attributes | Always Performed | Orderable Separately | Performing Location
FREB | Test | FREB | [NAME] | [NAME] |  | Serum Gel Tube: SGT |  |  |  |  | Draw blood from a fasting patient in a plain, red-top tube(s) or a  serum gel tube(s). Spin down and send 2 mL of serum refrigerate. Required:  Fasting for at least 12 hours. | 0.5 mL | Specimens other than	Serum Anticoagulants other than	NA Hemolysis	Mild OK; Gross reject Thawing	Warm reject; Cold OK Lipemia	NA Icteric	NA | 1.5-6.7 mg/dL    Test Performed By:  Quest Diagnostics/Nichols Institute                                          33608 [NAME]                                          San Juan Capistrano, CA  92690 |  | 1 day |  | 1 | 83883 |  |  |  |  | Quest Diagnostics/Nichols Institute
FREB | Result | Z1558 | [NAME] | [NAME] | Alphanumeric |  |  |  |  | mg/dL |  |  |  |  |  |  |  |  |  | 1836-6 | [NAME] binding protein:MCnc:Pt:Ser/Plas:Qn
Spreadsheet: 884609d1733840235-report-number-of-instances-in-another-sheet-based-on-variable-conditions-tool-order-tracking-development
Sheet: Front

 | Spend | Date From | Date To |  | Name | Tool Type | Quantity
 |  | 2023-09-09 00:00:00 | 2024-12-10 00:00:00 |  | User 1 | Socket Set |  | <- Cell H2 to show the number of instances of the tool type given in Cell G2, that appear in the relevant sheet to the name given in Cell F2, within the date range provided in cells C2 and D2. for example, if C2 = 09/09/2023, D2=03/12/2024, F2="User1" and G2="Socket Set" then H2 should return "1". If [NAME] is changed to "10/12/2024" H2 should then return "2".
User 1
User 2
User 3
User 4
User 5
User 6
User 7
User 8
User 9 |  |  |  |  |  |  |  | The list in Cell F2 is generated fron Column A
User 10
User 11 |  |  |  |  |  |  |  | The List in Cell D2 is generated from data in Sheet "Reference!" to allow for list expansion.
User 12
User 13 |  |  |  |  |  |  |  | In Column A, each User is hyperlinked to an induvidual record sheet of the same name.
User 14
User 15
User 16 |  |  |  |  |  |  |  | In each of the "user" sheets cell A1 is linked back to this sheet, for ease of navigation
User 17
User 18
User 19
User 20 |  |  |  |  |  |  |  | Some additional notes can be seen in Sheet "User1!"
User 21
User 22
User 23
User 24
User 25
User 26
User 27
User 28
User 29
User 30
Total
Spreadsheet: 686950d1594884625-ranking-with-indiex-match-fucntion-match-function-test_ram-3
Sheet: Sheet1

 | Data source |  |  |  | Overall Ranking |  |  |  | Asia only
Continental | Country | No of case | Rank |  | Rank | Country | No of case |  | Rank | Country | No of case
Europe | Spain | 26 |  |  | 1 |  |  |  | 1
Europe | London | 33 |  |  | 2 |  |  |  | 2
Asia | Japan | 26 |  |  | 3 |  |  |  | 3
Asia | Singapore | 22 |  |  | 4 |  |  |  | 4
Asia | India | 38 |  |  | 5 |  |  |  | 5
Asia | Thailand | 38 |  |  | 6 |  |  |  | 6
Asia | Malaysia | 31 |  |  | 7 |  |  |  | 7
N America | Canada | 48 |  |  | 8 |  |  |  | 8
N America | Alaska | 24 |  |  | 9 |  |  |  | 9
Spreadsheet: 96959d1296180783-countif-on-partial-cell-data-test
Sheet: Sheet1

 |  | Date
 |  | 11 Nov 2010 00:00:00 |  |  | Month | Total
 |  | 13 Dec 2010 17:31:41 |  |  | 2010-11-01 00:00:00 | 5
 |  | 12 Nov 2010 00:00:00 |  |  | 2010-12-01 00:00:00 | 9
 |  | 30 Dec 2010 16:35:52 |  |  | 2011-01-01 00:00:00 | 11
 |  | 15 Dec 2010 11:38:30
 |  | 31 Dec 2010 12:35:21
 |  | 30 Dec 2010 12:06:38
 |  | 30 Nov 2010 13:36:57
 |  | 17 Nov 2010 00:00:00
 |  | 22 Dec 2010 14:45:11
 |  | 10 Jan 2011 10:09:04
 |  | 12 Jan 2011 17:22:16
 |  | 12 Jan 2011 11:41:28
 |  | 25 Jan 2011 16:28:51
 |  | 19 Jan 2011 16:27:13
 |  | 14 Jan 2011 14:43:32
 |  | 13 Jan 2011 08:38:01
 |  | 30 Dec 2010 09:31:08
 |  | 20 Jan 2011 15:50:43
 |  | 29 Nov 2010 11:25:53
 |  | 07 Dec 2010 16:11:24
 |  | 10 Jan 2011 10:03:11
 |  | 21 Jan 2011 12:47:10
 |  | 19 Jan 2011 15:54:14
 |  | 16 Dec 2010 16:11:22
Spreadsheet: tracy_geaccone__40367__EMNNG02PL
Sheet: Sales&Liq-COS

PRINT: PRT.1
 |  | JAN | FEB | MAR | APR | MAY | JUN | JUL | AUG | SEP | OCT | NOV | DEC
Merchant Service ($000's)
Gas Sales - Miscellaneous
- Item 2
- Other |  | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0
- Base Gas Sale ??? / Monetization ???
- Other |  | 0
Hyperion Entry / Reversal |  | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0
Total Merchant Service Revenue
Liquids Revenue ($000's)
Condensate
Other
Other
Other |  | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0
Hyperion Entry / Reversal |  | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0
Total Liquids Revenue
Sales & Liquids Rev. Adjust.   (NON-CASH ITEMS ONLY)
Suspense Gas Adjustment |  | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0
Penalty - Misc. |  | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0
Other |  | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0
Other |  | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0
Other |  | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0
Hyperion Entry / Reversal |  | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0
Total Sales & Liquids Revenue Adjustments
TOTAL GAS & LIQUID SALES REVENUE
COST OF SALES ($000's)
Gas Purchases (Item 1)
Item 2
Other |  | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0
Other |  | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0
Hyperion Entry / Reversal |  | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0
TOTAL COST OF SALES
Spreadsheet: 763229d1642066219-formula-calculation-with-multiple-conditions-sample-scaled-lookup-aligw
Sheet: Sheet1

 |  |  |  |  |  |  |  |  |  | >1 | >1001 | >10001 | >50001 | >100001
 |  |  |  |  |  |  |  |  |  | <1000 | <10000 | <50000 | <100000 | <500000
 | Sr. No | Name of  Representative | Name of Donar | Date | Amount |  |  | Name of  Representative | Name of Donar | 1 to 1000 | 1001 to 10000 | 10001 to 50000 | 50001 to 100000 | 100001 to 500000
 | 1 | xyz | a | 2022-01-12 00:00:00 | 500 |  |  | xyz | a
 |  | xyz | b | 2022-01-12 00:00:00 | 1000 |  |  | xyz | b
 |  | xyz | c | 2022-01-12 00:00:00 | 2000 |  |  | xyz | c
 |  | xyz | d | 2022-01-12 00:00:00 | 10000 |  |  | xyz | d
 |  | xyz | a | 2022-01-12 00:00:00 | 500
 |  | xyz | b | 2022-01-12 00:00:00 | 1000
 |  | xyz | c | 2022-01-12 00:00:00 | 2000
 |  | xyz | d | 2022-01-12 00:00:00 | 10000
Spreadsheet: 374046d1422635838-countif-month-and-another-value-match-draft
Sheet: Late On Time Data

Document | DesignDoc.DocStatus | DesignDoc.LateFlag | DesignDoc.Design Date
104050-DR-024 | Open | Late | [NAME] |  |  | 2014-11-01 00:00:00
104050-DR-025 | Open | Late | [NAME] |  |  | 2014-12-01 00:00:00
104050-DR-008 | Open | Late | 21/11/2014 |  |  | 2015-01-01 00:00:00
104050-DR-009 | Open | Late | 19/12/2014 |  |  | 2015-02-01 00:00:00
104050-GA-012 | Open | Late | 31/12/2014 |  |  | 2015-03-01 00:00:00
104050-GA-013 | Open | Late | 31/12/2014 |  |  | 2015-04-01 00:00:00
104050-GA-014 | Open | Late | 31/12/2014
104050-DR-007 | Pending | OK | 16/01/2015
104050-GA-001 | Open | Late | 16/01/2015
BO-0640 | Open | Late | 16/01/2015
104050-GA-004 | Pending | OK | 23/01/2015
104050-PS-003 | Pending | OK | 27/01/2015
104050-DR-011 | Pending | OK | 29/01/2015
104050-DR-005 | Open | OK | 30/01/2015
104050-DR-012 | Open | OK | 30/01/2015
104050-GA-006 | Open | OK | 30/01/2015
104050-GA-007 | Open | OK | 30/01/2015
104050-GA-008 | Open | OK | 30/01/2015
104050-GA-009 | Open | OK | 30/01/2015
104050-GA-010 | Open | OK | 30/01/2015
104050-GA-011 | Open | OK | 30/01/2015
104050-DR-001 | Open | OK | 02/02/2015
104050-DR-002 | Open | OK | 02/02/2015
104050-DR-003 | Open | OK | 02/02/2015
104050-DR-004 | Open | OK | 02/02/2015
104050-DR-017 | Open | OK | 02/02/2015
104050-DR-013 | Open | OK | 27/02/2015
104050-DR-016 | Open | OK | 27/02/2015
104050-DR-026 | Open | OK | 27/02/2015
104050-DR-023 | Open | OK | 28/02/2015
104050-FS-001 | Open | OK | 02/03/2015
104050-IOM-001 | Open | OK | 02/03/2015
104050-PL-001 | Open | OK | 02/03/2015
104050-FAT-001 | Open | OK | 27/03/2015
104050-DR-019 | Open | OK | 03/04/2015
104050-DR-020 | Open | OK | 03/04/2015
104050-DR-010 | Pending | OK
104050-DR-018 | Pending | OK
104050-DR-021 | Pending | OK
104050-GA-002 | Pending | OK
104050-GA-003 | Pending | OK
104050-GA-005 | Pending | OK
104050-GA-015 | Closed | OK
104050-PS-001 | Pending | OK
104050-PS-004 | Pending | OK
104050-PT-030 | Pending | OK
BO-0639 | Pending | OK
BO-0639-DS | Pending | OK
HSUR1002 | Closed | OK
SF0006-PS | Pending | OK
SF0007-PS | Pending | OK