tianzl66/Sheetpedia huggingface dataset:
Spreadsheet: 08e8014d-70f5-4430-8564-4d9a5fc1f604
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. [NAME], ECH, RDG, EPSY, SPED) 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.CI) | PSY
Discipline codes:  EDU-Curriculum & Instruction = 1303       (4 digits) | 4200 | 1303 | 1303 | 1303 | 1303 | 1303 | 1303
[NAME] (e.g. 800, 1230, or 1800) | 800
Bubbled Course Number                                                 (4 digits) | 3303
Enrollment | 23
Local Code for EDU 2323 = 0200                                 (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: 31467d1227297525-multiple-table-vlookups-and-results-help
Sheet: Search

 |  | Customer Search
month | Customer Number | Surname | order Date
Jan | 123456 | Bloggs | 2008-01-01 00:00:00
Feb | 445577 | green | 2008-02-01 00:00:00
month | Customer Name | Customer Number | order Date
Jan | bloggs | 39448 | 2008-01-01 00:00:00
Feb | green | 39479 | 2008-02-01 00:00:00
Spreadsheet: 789628d1659253763-dynamic-cumulative-sums-revisited-grouped-calculations-dynamic-cumulative-sumif-gk
Sheet: Sheet1

Thing | Data |  | Cumulative SUM |  | Conventional cumulative SUMIF |  | Dynamic cumulative sum MMULT | Dynamic cumulative sum SUBTOTAL OFFSET |  | Dynamic cumulative SUMIF??? | [NAME] SUMIF?
A | 3 |  |  |  |  |  |  |  |  |  | 3
B | 12 |  |  |  |  |  | 15 |  |  | 12 | 12
B | 5 |  |  |  |  |  | 20 |  |  | 17 | 17
B | 3 |  |  |  |  |  | 23 |  |  | 20 | 20
A | 3 |  |  |  |  |  | 26 |  |  | 6 | 3
A | 1 |  |  |  |  |  | 27 |  |  | 7 | 4
B | 4 |  |  |  |  |  | 31 |  |  | 24 | 4
B | 4 |  |  |  |  |  | 35 |  |  | 28 | 8
C | 8 |  |  |  |  |  | 43 |  |  | 8 | 8
C | 3 |  |  |  |  |  | 46 |  |  | 11 | 11
C | 7 |  |  |  |  |  | 53 |  |  | 18 | 18
D | 1 |  |  |  |  |  | 54 |  |  | 1 | 1
B | 2 |  |  |  |  |  | 56 |  |  | 30 | 2
A | 11 |  |  |  |  |  | 67 |  |  | 18 | 11
Spreadsheet: 761246d1640770503-count-active-cases-between-two-dates-workload-testfile_weekly-open-files_eng-1-ans2
Sheet: Tabelle1

 |  |  |  |  |  |  | verification
 | ID | Date reported | Date closed | Assigned to | Status |  | APR |  | 2021-01-01 00:00:00 | 2021-02-01 00:00:00 | 2021-03-01 00:00:00 | 2021-04-01 00:00:00 | 2021-05-01 00:00:00 | 2021-06-01 00:00:00 | 2021-07-01 00:00:00 |  | ASSIGNER | 2021-01-01 00:00:00 | 2021-02-01 00:00:00 | 2021-03-01 00:00:00 | 2021-04-01 00:00:00 | 2021-05-01 00:00:00 | 2021-06-01 00:00:00 | 2021-07-01 00:00:00
 | 805643 | 2021-01-01 00:00:00 | 2021-03-27 00:00:00 | Person 1 | closed |  |  |  | 1 | 2 | 6 | 9 | 11 | 10 | 6
 | 805699 | 2021-01-15 00:00:00 | 2021-01-19 00:00:00 | Person 2 | closed
 | 805821 | 2021-01-28 00:00:00 |  | Person 3 | open |  | 1
 | 805899 | 2021-02-13 00:00:00 | 2021-05-28 00:00:00 | Person 4 | closed |  | 1
 | 805988 | 2021-02-15 00:00:00 | 2021-03-21 00:00:00 | Person 5 | closed
 | 806077 | 2021-02-27 00:00:00 |  | Person 1 | open |  | 1
 | 806166 | 2021-02-28 00:00:00 | 2021-06-30 00:00:00 | Person 2 | closed |  | 1
 | 806255 | 2021-03-05 00:00:00 | 2021-06-30 00:00:00 | Person 1 | closed |  | 1
 | 806344 | 2021-03-06 00:00:00 |  | Person 2 | open |  | 1
 | 806433 | 2021-03-11 00:00:00 |  | Person 3 | open |  | 1
 | 806522 | 2021-03-28 00:00:00 | 2021-04-15 00:00:00 | Person 4 | closed |  | 1
 | 806611 | 2021-04-01 00:00:00 | 2021-05-20 00:00:00 | Person 5 | closed |  | 1
 | 806700 | 2021-04-15 00:00:00 | 2021-05-19 00:00:00 | Person 1 | closed |  | 1
 | 806789 | 2021-04-18 00:00:00 |  | Person 2 | open |  | 1
 | 806878 | 2021-04-19 00:00:00 | 2021-06-01 00:00:00 | Person 1 | closed |  | 1
 | 806967 | 2021-05-05 00:00:00 | 2021-05-10 00:00:00 | Person 2 | closed
 | 807056 | 2021-05-31 00:00:00 | 2021-06-17 00:00:00 | Person 3 | closed
 | 807145 | 2021-06-18 00:00:00 |  | Person 4 | open
Spreadsheet: tracy_geaccone__40305__Enron Request F&A
Sheet: Sheet1

PORTLAND GENERAL GROUP
FOR THE YEAR 2001
 |  |  |  |  | Total
Department | Department |  |  |  | Annual
# | Description | Headcount | Labor | Other | Forecast
271 | Disbursements & Receivables | 8 | 452526 | 100000
272 | Generation & Property Acctg | 10 | 523180 | 1070100
273 | Financial Acctg & Rptg-Controller | 7 | 436502 | 1589956
274 | Business Decision Support (Budget) | 12 | 780589 | 20040
282 | Corporate Tax | 8 | 618000 | 214150
541 | VP Finance & Acctg | 2 | 174590 | 77650
685 | Finance | 7 | 433258 | 1138573
761 | Financial Analysis | 6 | 407088 | 278892
955 | Corporate Acctg & G/L Ops | 14 | 773461 | 94700
675 | Risk Mgmt Rptg & Control | 8 | 344604 | 65805
891 | VP Risk Mgmt Rptg & Control | 3 | 243236 | 227474
951 | Financial Analysis - Retail & Spcl Projects | 1 | 131053 | 24100
 | Total
Spreadsheet: 709650d1608470022-if-function-between-three-cells-help-sheet
Sheet: Sheet2

Bet | Finished | Price | Price | Price | Outlay | W/L
1 | Unplaced
2 | Unplaced
3 | 2nd | 62 | 66.8 | 68.7 | 6
4 | Unplaced
5 | Unplaced
6 | 3rd | 54.55 | 85.2 | 79.5 | 6
7 | Unplaced
8 | Unplaced
9 | 1st | 152 | 185.2 | 162.4 | 6
10 | 2nd
11 | Unplaced
12 | Unplaced | 254.2 | 295.1 | 240 | 6
13 | Unplaced
14 | 3rd
15 | 1st | 269.3 | 250.4 | 287 | 6
16 | 1st
17 | 2nd
18 | Unplaced | 325.4 | 364.2 | 342.5 | 6
19 | 1st
20 | Unplaced
21 | 3rd | 158.2 | 169.3 | 185.1 | 6
Spreadsheet: andy_zipper__238__DYNEGY-ICE VOL May31
Sheet: ICE-ECC

Enron Canada Corporation
Activity on ICE
UOM | Deals | Volume
 |  |  |  |  |  |  | START | END
Enron Canada Corp.
Commodity Type:  All
Instruments:  All
Trade Dates:   May-31-01 thru May-31-01
Trade Date | Deal ID | Leg ID | B/S | Product | Hub | Strip | START | END | Option | Strike | Style | Counterparty | Price | Price Units | Qty Per Period | Periods | Total Quantity | Qty Units | Trader
Spreadsheet: 799357d1665056578-error-while-splitting-date-and-time-temp1-1-
Sheet: TEMP

DATE & TIME, | DATE | TIME
2022-01-09 11:26:37
2022-01-09 11:28:02
2022-01-09 12:20:19
2022-01-09 12:20:55
2022-01-09 14:01:31
2022-02-09 10:50:49
2022-02-09 10:52:19
2022-02-09 11:49:31
2022-02-09 11:52:45
2022-02-09 12:10:40
2022-02-09 13:54:26
2022-02-09 13:55:31
2022-02-09 13:56:25
2022-03-09 11:36:55
2022-03-09 12:11:41
2022-03-09 12:42:41
2022-03-09 14:01:05
2022-03-09 15:18:41
2022-03-09 15:19:48
2022-03-09 15:20:44
2022-03-09 16:02:55
2022-05-09 13:15:39
2022-05-09 13:38:40
2022-05-09 15:30:23
2022-05-09 15:32:02
2022-05-09 16:04:34
2022-07-09 13:10:30
2022-07-09 14:04:10
2022-07-09 14:05:41
2022-12-09 13:53:08
2022-12-09 13:53:57
2022-12-09 13:54:45
2022-12-09 13:55:23
2022-09-13 10:43:48
2022-09-13 11:32:26
2022-09-13 11:47:19
2022-09-13 11:48:00
2022-09-13 12:41:12
2022-09-13 12:42:14
2022-09-13 13:05:19
2022-09-13 15:45:56
2022-09-14 11:19:52
2022-09-14 12:17:35
2022-09-14 12:19:47
2022-09-14 12:24:12
2022-09-14 12:29:28
2022-09-14 13:41:16
2022-09-14 14:02:35
2022-09-15 11:46:04
2022-09-15 11:48:16
2022-09-15 12:26:13
2022-09-15 15:53:43
2022-09-15 16:40:30
2022-09-15 16:49:21
2022-09-15 17:18:31
2022-09-15 18:00:30
2022-09-15 19:37:33
2022-09-16 12:17:32
2022-09-16 12:25:42
2022-09-16 12:58:16
2022-09-16 13:43:40
2022-09-16 13:51:37
2022-09-16 14:49:37
2022-09-16 15:13:39
2022-09-16 16:35:31
2022-09-17 11:10:11
2022-09-17 11:54:28
2022-09-17 11:55:19
2022-09-17 12:25:02
2022-09-17 12:26:02
2022-09-17 12:32:26
2022-09-17 13:00:38
2022-09-17 15:17:30
2022-09-19 10:57:23
2022-09-19 11:51:38
2022-09-19 12:50:51
2022-09-19 12:51:50
2022-09-19 12:53:15
2022-09-19 14:08:52
2022-09-19 14:09:36
2022-09-19 15:40:13
2022-09-19 15:41:24
2022-09-19 16:28:27
2022-09-19 17:02:05
2022-09-19 17:02:46
2022-09-20 11:19:18
2022-09-20 11:59:07
2022-09-20 11:59:51
2022-09-20 12:33:13
2022-09-20 12:33:57
2022-09-20 13:31:29
2022-09-20 16:12:24
2022-09-20 16:24:26
2022-09-20 16:25:00
2022-09-20 16:26:17
2022-09-20 17:02:10
2022-09-21 11:44:20
2022-09-21 11:44:54
2022-09-21 12:42:18
2022-09-21 12:44:09
2022-09-21 13:15:44
2022-09-21 13:16:40
2022-09-21 14:04:42
2022-09-22 12:15:34
2022-09-22 12:43:41
2022-09-22 12:52:31
2022-09-22 13:03:59
2022-09-22 13:08:40
2022-09-22 14:37:55
2022-09-22 14:38:50
2022-09-22 14:39:28
2022-09-22 15:27:00
2022-09-22 15:36:34
2022-09-22 16:00:12
2022-09-24 13:05:55
2022-09-24 13:37:28
2022-09-24 13:38:07
2022-09-24 14:45:18
2022-09-26 10:46:59
2022-09-26 10:47:56
2022-09-26 11:35:53
2022-09-26 11:38:09
2022-09-26 12:24:47
2022-09-26 12:26:27
2022-09-26 14:57:54
2022-09-27 10:49:46
2022-09-27 11:55:15
2022-09-27 11:56:48
2022-09-27 12:13:19
2022-09-27 13:08:28
2022-09-27 13:09:13
2022-09-27 15:13:49
2022-09-27 15:54:44
2022-09-27 15:56:27
2022-09-27 16:04:25
2022-09-27 16:41:17
2022-09-27 16:41:51
2022-09-27 17:15:23
2022-09-28 11:30:20
2022-09-28 11:34:53
2022-09-28 12:12:28
2022-09-28 12:13:09
2022-09-28 12:13:43
2022-09-28 12:14:44
2022-09-28 13:06:15
2022-09-28 13:07:39
2022-09-28 14:02:10
2022-09-28 14:04:41
Spreadsheet: 270255d1381423660-sumproduct-with-id-numbers-that-has-minus-signs-and-using-time-as-an-array-samplehelp
Sheet: DPS Hours

Actual ID | Sample ID | Start Time | End Time | # of Hours
13-01294-001 | 13-01294 | 05:00:00 | 07:00:00
13-01294-002 | 13-01294 | 12:00:00 | 01:00:00 | 01:00:00
13-01294-003 | 13-01294 | 03:00:00 | 05:00:00
13-01294-004 | 13-01294 | 21:30:00 | 23:30:00
13-01294-005 | 13-01294 | 22:00:00 | 23:00:00
13-01294-006 | 13-01294 | 19:00:00 | 20:00:00
13-01294-007 | 13-01294 | 22:00:00 | 23:00:00
13-01294-008 | 13-01294 | 12:01:00 | 02:01:00 | 02:00:00
13-01294-009 | 13-01294 | 12:30:00 | 02:00:00 | 01:30:00
13-01294-010 | 13-01294 | 04:00:00 | 04:30:00
13-01294-011 | 13-01294 | 18:00:00 | 20:00:00
13-00842-012 | 13-00842 | 20:00:00 | 22:00:00
13-00842-013 | 13-00842 | 20:00:00 | 22:00:00
13-00842-014 | 13-00842 | 20:00:00 | 22:00:00
13-00842-015 | 13-00842 | 20:00:00 | 22:00:00
13-00842-085 | 13-00842 | 20:00:00 | 23:59:00
13-00842-086 | 13-00842 | 20:00:00 | 23:59:00
13-00842-016 | 13-00842 | 20:00:00 | 22:00:00
13-00842-017 | 13-00842 | 20:00:00 | 22:00:00
13-00842-018 | 13-00842 | 20:00:00 | 23:00:00 |  |  |  | Sumproduct of 13-01294
13-00842-019 | 13-00842 | 20:00:00 | 22:00:00 |  |  |  | Sumproduct of 13-00842
13-00842-020 | 13-00842 | 20:00:00 | 22:00:00
13-00842-087 | 13-00842 | 20:00:00 | 23:59:00
13-00842-088 | 13-00842 | 20:00:00 | 23:59:00
13-00842-021 | 13-00842 | 20:00:00 | 22:00:00
13-00842-022 | 13-00842 | 20:00:00 | 22:00:00
13-00842-023 | 13-00842 | 20:00:00 | 22:00:00
13-00842-024 | 13-00842 | 20:00:00 | 22:00:00
13-00842-025 | 13-00842 | 20:00:00 | 22:00:00
13-00842-089 | 13-00842 | 20:00:00 | 23:59:00
13-00842-090 | 13-00842 | 20:00:00 | 23:59:00
13-00842-026 | 13-00842 | 20:00:00 | 22:00:00
13-00842-027 | 13-00842 | 20:00:00 | 22:00:00
13-00842-028 | 13-00842 | 20:00:00 | 22:00:00
13-00842-029 | 13-00842 | 20:00:00 | 22:00:00
 |  |  |  | # of Hours
Spreadsheet: 796754d1663502437-get-all-results-from-number-2-unique-numbers-hd
Sheet: Feuil1

[NAME] | 7 | 24 | 17 | 8 | 11 | 4 |  | Numbers | COUNT | <<---- | For the unique numbers Filter COUNT=1
24
17
8
11
4
ADDITION
Spreadsheet: 737647d1624529461-formula-error-from-live-data-skip-tracker
Sheet: Sheet1

6T Skip Number | [NAME] | Inspection Date | Inspection Category | Days on Hire
BCAB5003 | 6 Tonne | 2021-05-01 00:00:00 | Outbound
BCAB5002 | 6 Tonne | 2021-05-01 00:00:00 | Outbound
BCAB5001 | 6 Tonne | 2021-05-07 00:00:00 | Outbound
BCAB5019 | 6 Tonne | 2021-05-07 00:00:00 | Outbound
BCAB5020 | 6 Tonne | 2021-05-08 00:00:00 | Outbound
BCAB5021 | 6 Tonne | 2021-05-10 00:00:00 | Outbound
BCAB5003 | 6 Tonne | 2021-05-22 00:00:00 | Inbound
BCAB5002 | 6 Tonne | 2021-05-24 00:00:00 | Inbound
BCAB5001 | 6 Tonne | 2021-05-25 00:00:00 | Inbound
BCAB5019 | 6 Tonne | 2021-05-27 00:00:00 | Inbound
BCAB5020 | 6 Tonne | 2021-05-27 00:00:00 | Inbound
BCAB5021 | 6 Tonne | 2021-05-29 00:00:00 | Inbound
BCAB5003 | 6 Tonne | 2021-06-02 00:00:00 | Outbound
BCAB5002 | 6 Tonne | 2021-06-05 00:00:00 | Outbound
BCAB5001 | 6 Tonne | 2021-06-09 00:00:00 | Outbound
BCAB5003 | 6 Tonne | 2021-06-19 00:00:00 | Inbound
BCAB5002 | 6 Tonne | 2021-06-21 00:00:00 | Inbound
BCAB5001 | 6 Tonne | 2021-06-23 00:00:00 | Inbound
Spreadsheet: d3f8c489-23df-4486-896d-9fc65c46a577
Sheet: Sheet1

PROG ID | ATHLETE ID | ATHLETE FIRST | ATHLETE LAST | NATIONALITY | START NUMBER | SWIM | T1 | BIKE | T2 | RUN | POSITION | TOTAL TIME
7653 | 39858 | Mikel | Garmendia | ESP | 75 | 01:15:16 | 00:04:40 | 03:50:35 | 00:02:49 | [NAME] | 1 | 08:14:47
7653 | 22817 | [NAME] | Basilio | POR | 74 | 01:11:09 | 00:02:41 | 04:21:34 | 00:03:01 | 03:08:47 | 2 | 08:47:10
7653 | 49382 | [NAME] | [NAME] | ESP | 73 | 01:20:10 | 00:04:43 | 04:26:15 | 00:04:13 | 03:37:41 | 3 | 09:33:02
Spreadsheet: 779644d1651932779-calculating-range-and-remainder-calculatingfolderandposition
Sheet: Sheet1

Folder | Folder size | Cumulative | [NAME], as first step |  |  | Number entered | Result wanted Folder,Position | Explanation
1 | 4 | 4 |  |  |  | 1 | 1,1 | Calculate by testing Number against the ranges
2 | 14 |  |  |  |  | 5 | 2,1 | Calculate by testing Number against the ranges
3 | 328 |  |  |  |  | 8 | 2,4 | Calculate by testing Number against the ranges
4 |  |  |  |  |  | 20 | 3,2 | Calculate by testing Number against the ranges
5 |  |  |  |  |  | 100 | 3,82 | Calculate by testing Number against the ranges
6 |  |  |  |  |  | 300 | 3282 | Calculate by testing Number against the ranges
7 |  |  |  |  |  | 350 | 1,1 | Outside all ranges so default tol '1,1'
8 |  |  |  |  |  | 15
9 |  |  |  |  |  | 18
10 |  |  |  |  |  | 330
Enter number in C13 |  | 2
Note: Only using 3 of the 10 intended folders for this example
Spreadsheet: 677139d1589210928-populate-calendar-and-summary-invercargill-leave-copy
Sheet: MasterData

Name |  | Location |  | Date | Public Holidays |  | Leave Type
Name1 |  | [NAME] |  | 2020-01-01 00:00:00 | New Year's Day |  | Annual |  |  | This is Master Data where we register these Master Information
[NAME] |  | Christchurch |  | 2020-01-02 00:00:00 | Day after New Year's Day |  | Long Service
Name3 |  | Dunedin |  | 2020-02-06 00:00:00 | Waitangi Day |  | Sick
Name4 |  | Invercargill |  | 2020-04-10 00:00:00 | Good Friday
Name5 |  | Palmerston North |  | 2020-04-13 00:00:00 | Easter Monday
Name6 |  | Southdown |  | 2020-04-27 00:00:00 | Anzac Day
Name7 |  | Te Rapa |  | 2020-06-01 00:00:00 | Queen's Birthday
Name8 |  | Timaru |  | 2020-10-26 00:00:00 | Labour Day
Name9 |  | Wellington |  | 2020-12-25 00:00:00 | Christmas Day
Name10 |  |  |  | 2020-12-26 00:00:00 | Boxing Day
Name11
Name12
Name13
Name14
Name15
[NAME]
Name17
Name18
Name19
[NAME]
Name21
Name22
Name23
Name24
Name25
Name26
Name27
Name28
Name29
Name30
Name31
Name32
Name33
[NAME]
Name35
Name36
Name37
Name38
[NAME]
Name40
Name41
Name42
Name43
Name44
Name45
Name46
[NAME]
Name48
Name49
Name50
Name51
[NAME]
Name53
Name54
Name55
Name56
Name57
Name58
Name59
Name60
Name61
Name62
Name63
Name64
Name65
Name66
[NAME]
[NAME]
Name69
Name70
Name71
Name72
[NAME]
Name74
Name75
Name76
Name77
Name78
Name79
Name80
Name81
Name82
Name83
Name84
Name85
Name86
Name87
[NAME]
Name89
Name90
Name91
Name92
[NAME]
[NAME]
Name95
Name96
Name97
Name98
Name99
Name100
Name101
Name102
Name103
Name104
Name105
Name106
[NAME]
Name108
Name109
Name110
Name111
[NAME]
Name113
Name114
Name115
Name116
[NAME]
Name118
Name119
Name120
Name121
Name122
Name123
[NAME]
Name125
Name126
Name127
Name128
Name129
Name130
Name131
Name132
Name133
Name134
Name135
Name136
Name137
Name138
Name139
Name140
Name141
Name142
Name143
Name144
[NAME]
Name146
[NAME]
Name148
Name149
Name150
Name151
Name152
Name153
Name154
Name155
Name156
Name157
Name158
Name159
Name160
Name161
Name162
Name163
Name164
Name165
Name166
Name167
Name168
Name169
Spreadsheet: 886192d1736218550-calculate-drawdowns-peak-to-valley_drawdowns_example_2025_0106
Sheet: Sheet1

x | y | Drawdowns | % Drawdowns |  |  |  | [NAME]. Drawdown (Intra-day Peak to Valley)
1 | 1
2 | 2 |  |  |  |  |  | Displays the greatest loss drawdown, from the previous highest equity run-up, bar to bar looking across all trades, during the specified period.
3 | 3 |  |  |  |  |  | If a new bar equity run-up high occurs, the low equity value is reset  to 0 so that the next maximum drawdown can be calculated from that point.
4 | 4
5 | 3 |  |  |  |  |  | You can roughly see this value on a detailed equity curve graph by looking from the highest peaks to the lowest peaks moving forward. (Peak to Valley)
6 | 2
7 | 3
8 | 4
9 | 5
10 | 6
11 | 4
12 | 5
13 | 4
14 | 3
15 | 4
16 | 5
17 | 6
MAX DRAWDOWN
Spreadsheet: 125050d1318849407-excel-2007-return-number-1-if-cell-between-1-of-2-time-intervals-schedule_help
Sheet: Sheet1

total
person | schedule |  |  |  | time intervals
 |  |  |  |  | 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
person A | 08:30:00 | 10:30:00 | 11:30:00 | 12:30:00
person B | 09:00:00 | 10:00:00
person C | 10:00:00 | 11:00:00 | 12:00:00 | 13:00:00
this is how the result would have to be
total
person | schedule |  |  |  | time intervals
 |  |  |  |  | 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
person A | 08:30:00 | 10:30:00 | 11:30:00 | 12:30:00 |  | 1 | 1 | 1 | 1 |  |  | 1 | 1
person B | 09:00:00 | 10:00:00 |  |  |  |  | 1 | 1
person C | 10:00:00 | 11:00:00 | 12:00:00 | 13:00:00 |  |  |  |  | 1 | 1 |  |  | 1 | 1
Spreadsheet: 871993d1718363373-summarization-of-data-based-on-date-sample-sheet
Sheet: PRE

 |  |  |  |  |  |  |  |  | Babu Garu |  |  |  |  | [NAME] BOOKS
NURSERY |  |  |  |  |  |  |  |  | NURSERY |  |  |  |  | CLASS | QTY | PRICE | AMT.
PARTICULARS | QTY | PRICE |  |  |  |  |  |  | PARTICULARS | QTY | PRICE |  |  | CLASS-III
CYGNET S2 | 2 | 700 |  |  |  |  |  |  | CYGNET S2 | 2 | 700 |  |  | ENGLISH CW | 10 | 160 | 1600
FR | 1 | 30 |  |  |  |  |  |  |  |  |  |  |  | HINDI CW | 10 | 99 | 990
CR | 1 | 30 |  |  |  |  |  |  | L.K.G. |  |  |  |  | TELUGU | 10 | 99 | 990
DIARY | 1 | 75 |  |  |  |  |  |  | PARTICULARS | QTY | PRICE | Total |  |  |  |  | 3580
ART FUN | 1 | 150 | 285 |  |  |  |  |  | CYGNET S3 TEXT | 10 | 750 | 7500
STAT. CHARGES |  | 550 |  |  |  |  |  |  | CYGNET S3 PC | 10 | 380 | 3800 |  | CLASS-IV
 |  |  |  |  |  |  |  |  | SK TELUGU | 10 | 180 | 1800 |  | ENGLISH CW | 10 | 160 | 1600
TOTAL |  | 1535 |  |  |  |  |  |  |  |  |  | 13100 |  | HINDI CW | 10 | 99 | 990
 |  |  |  |  |  |  |  |  | U.K.G. |  |  |  |  | TELUGU | 10 | 99 | 990
L.K.G. |  |  |  |  |  |  |  |  | PARTICULARS | QTY | PRICE | Total |  |  |  |  | 3580
PARTICULARS | QTY | PRICE |  |  |  |  |  |  | CYGNET S3 TEXT | 10 | 750 | 7500
CYGNET S3 TEXT | 3 | 750 |  |  |  |  |  |  | CYGNET S3 PC | 10 | 380 | 3800 |  | CLASS-V
CYGNET S3 PC | 3 | 380 |  |  |  |  |  |  | SK TELUGU | 10 | 200 | 2000 |  | ENGLISH CW | 10 | 160 | 1600
SK TELUGU | 1 | 180 |  |  |  |  |  |  | SK HINDI | 10 | 160 | 1600 |  | HINDI CW | 10 | 99 | 990
ART FUN | 1 | 150 | 1460 |  |  |  |  |  |  |  |  | 14900 |  | TELUGU | 10 | 99 | 990
FR | 2 | 60 |  |  |  |  |  |  | CLASS-I |  |  |  |  |  |  |  | 3580
DR | 1 | 30 |  |  |  |  |  |  | PARTICULARS | QTY | PRICE | Total |  | TOTAL |  |  | 10740
CR | 1 | 30 |  |  |  |  |  |  | [NAME] | 10 | 1350 | 13500 |  | (-50%) |  |  | 5370
DIARY | 1 | 75 | 195 |  |  |  |  |  | HINDI | 10 | 160 | 1600
STAT. CHARGES |  | 550 |  |  |  |  |  |  | SK TELUGU | 10 | 230 | 2300
 |  |  |  |  |  |  |  |  |  |  |  | 17400
TOTAL |  | 2205
 |  |  |  |  |  |  |  |  | CLASS-II
U.K.G. |  |  |  |  |  |  |  |  | PARTICULARS | QTY | PRICE | Total
PARTICULARS | QTY | PRICE |  |  |  |  |  |  | [NAME] | 20 | 1450 | 29000
CYGNET S3 TEXT | 3 | 750 |  |  |  |  |  |  | HINDI | 20 | 160 | 3200
CYGNET S3 PC | 3 | 380 |  |  |  |  |  |  | SK TELUGU | 20 | 230 | 4600
SK TELUGU | 1 | 200 |  |  |  |  |  |  |  |  |  | 36800
SK HINDI | 1 | 160 | 1490
ART FUN | 1 | 150
COPY WRITING | 1 | 110 |  |  |  |  |  |  | LKG | 13100
FR | 2 | 60 |  |  |  |  |  |  | UKG | 14900
DR | 1 | 30 |  |  |  |  |  |  | CLASS-I | 17400
BR | 1 | 30 |  |  |  |  |  |  | CLASS-II | 36800
CR | 1 | 30 |  |  |  |  |  |  | TOTAL | 82200
DIARY | 1 | 75 | 485 |  |  |  |  |  | (-50%) | 41100
STAT. CHARGES |  | 550
TOTAL |  | 2525
Spreadsheet: f44eea28-65fc-4057-95f4-9b37f3d883d5
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
43513823 | 2014-10-10 03:15:03 | AXIS | 1 | 5 | 1 | 1509251 | mrmanley31 | 8709 | mediterranean | 1942-06-12 | 1942-06-12 | Knightsbridge | Knightsbridge
43513960 | 2014-10-10 03:36:58 | ALLIES | 1 | 5 | 4 | 1509251 | mrmanley31 | 8709 | mediterranean | 1942-06-12 | 1942-06-12 | Knightsbridge | Knightsbridge
43550009 | 2014-10-12 16:50:27 | ALLIES | 1 | 6 | 2 | 621893 | 420017 | 8708 | western | 1944-07-25 | 1944-07-25 | Operation Spring | Opération Spring
43550372 | 2014-10-12 17:10:46 | AXIS | 1 | 6 | 4 | 621893 | 420017 | 8708 | western | 1944-07-25 | 1944-07-25 | Operation Spring | Opération Spring
43615684 | 2014-10-17 08:06:19 | ALLIES | 1 | 5 | 3 | 723549 | [NAME] | 7665 | pacific | 1942-10-23 | 1942-10-23 | Matanikau River | Rivière Matanikau
43615899 | 2014-10-17 08:24:19 | AXIS | 0 | 1 | 5 | 723549 | [NAME] | 7665 | pacific | 1942-10-23 | 1942-10-23 | Matanikau River | Rivière Matanikau