tianzl66/Sheetpedia huggingface dataset:
Spreadsheet: 553793e7-ec28-4a4f-aed4-3a58a005aebd
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
35904121 | 2013-05-12 08:25:01 | ALLIES | 1 | 6 | 2 | 808580 | LMN052 | 7272 | mediterranean | 1942-12-01 | 1942-12-01 | Tunisia | Tunisie
35904237 | 2013-05-12 08:49:18 | AXIS | 1 | 6 | 3 | 808580 | LMN052 | 7272 | mediterranean | 1942-12-01 | 1942-12-01 | Tunisia | Tunisie
35934088 | 2013-05-14 04:32:14 | ALLIES | 0 | 3 | 6 | 1264737 | meredragon | 7667 | pacific | 1945-05-13 | 1945-05-19 | Sugar Loaf and Half Moon | Pain de sucre et demi-lune
35934271 | 2013-05-14 04:53:48 | AXIS | 0 | 4 | 6 | 1264737 | meredragon | 7667 | pacific | 1945-05-13 | 1945-05-19 | Sugar Loaf and Half Moon | Pain de sucre et demi-lune
35934495 | 2013-05-14 05:13:31 | ALLIES | 1 | 6 | 5 | 1327611 | player1327611 | 7667 | pacific | 1945-05-13 | 1945-05-19 | Sugar Loaf and Half Moon | Pain de sucre et demi-lune
35935420 | 2013-05-14 06:47:06 | AXIS | 0 | 3 | 6 | 712434 | Canestri10 | 7667 | pacific | 1945-05-13 | 1945-05-19 | Sugar Loaf and Half Moon | Pain de sucre et demi-lune
35948410 | 2013-05-15 04:06:46 | AXIS | 0 | 5 | 6 | 67493 | [NAME] | 7667 | pacific | 1945-05-13 | 1945-05-19 | Sugar Loaf and Half Moon | Pain de sucre et demi-lune
35948578 | 2013-05-15 04:20:25 | ALLIES | 1 | 6 | 3 | 67493 | [NAME] | 7667 | pacific | 1945-05-13 | 1945-05-19 | Sugar Loaf and Half Moon | Pain de sucre et demi-lune
Spreadsheet: 95440d1295025109-to-return-mutliple-results-with-one-search-item-test1
Sheet: Schedule

Dept | Associate | Monday | Tuesday | Wednesday | Thursday | Friday | Saturday | Sunday
carp | G,[NAME] |  |  |  |  | 11a - 3p |  | 10p - 2a
 | [NAME],[NAME] |  |  |  |  | 11a - 3p |  | 10p - 2a
 | Hain,[NAME] |  |  |  |  | 11a - 3p |  | 10p - 2a
 | Dansen,Dennis |  |  |  |  | 9a - 5p |  | 10p - 6a
 |  | 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
Dept | Associate | Monday | Tuesday | Wednesday | Thursday | Friday | Saturday | Sunday
av | Adder,Ray |  |  |  |  |  | 5p-1a | 6p-12a
carp | [NAME],Shane |  |  |  |  | 9a - 5p |  | 10p - 6a
elec | [NAME],[NAME] |  | 5 AM - 9 AM |  | 5 AM - 9 AM |  | 10 AM - TILL
carp | [NAME],[NAME] |  |  |  |  | 9a - 5p |  | 10p - 6a
carp | Barro,[NAME] |  |  |  |  | 9a - 5p
carp | [NAME],[NAME] |  |  |  |  | 9a - 5p |  | 10p - 6a
av | [NAME],[NAME] |  | 6a-2p
carp | [NAME],[NAME] |  |  |  |  | 9a - 5p |  | 10p - 6a
carp | Corbo,Bessie |  |  |  |  | 11a - 3p /Chairs
carp | Cordero,[NAME] |  |  |  |  | 9a - 5p |  | 10p - 6a
elec | Farina,Ron |  | 5 AM - 9 AM |  | 5 AM - 9 AM |  | 10 AM - TILL | 6:30 PM - TILL
carp | Fere,[NAME] |  |  |  |  | 9a - 5p
carp | G,[NAME] |  |  |  |  | 11a - 3p |  | 10p - 2a
carp | [NAME],[NAME] |  |  |  |  | 11a - 3p |  | 10p - 2a
elec | [NAME],Art |  |  |  |  |  | 10 AM - TILL
carp | Hain,[NAME] |  |  |  |  | 11a - 3p |  | 10p - 2a
carp | Dansen,Dennis |  |  |  |  | 9a - 5p |  | 10p - 6a
elec | [NAME] |  | 3 PM - 7 PM |  |  |  | 6:30 PM - TILL | 6:30 PM - TILL
carp | [NAME],[NAME] |  |  |  |  | 11a - 7p |  | 10p - 6a
av | [NAME],[NAME] |  | 6a-2p | 1:30p-9:30p | 6a-2p |  | 5p-1a | 6p-12a
carp | Krub,[NAME] |  |  |  |  |  |  | 10p - 6a
elec | Kirk,[NAME] |  |  |  |  |  | 10 AM - TILL | 10p - 6a
carp | Loving,[NAME] |  |  |  |  | 9a - 5p |  | 10p - 6a
carp | Mart,[NAME] |  |  |  |  | 9a - 5p |  | 10p - 6a
carp | [NAME],[NAME] |  |  |  |  |  |  | 10p - 2a
audio | Mose,T |  |  |  |  |  | 5P-1A | 4P-12A
carp | Music,[NAME] |  |  |  |  |  |  | 10p - 6a
carp | [NAME],Greg |  |  |  |  | 9a - 5p |  | 10p - 6a
carp | Painter,[NAME] |  |  |  |  | 9a - 5p |  | 10p - 6a
av | Pinto,T |  | 5 AM - 9 AM                           SALONS
carp | Prove,[NAME] |  |  |  |  | 9a - 5p |  | 10p - 6a
carp | Rodge,[NAME] |  |  |  |  | 9a - 5p
av | [NAME],[NAME] |  | 12:30p-5:30p
audio | Stuler,[NAME] |  | 5P-1A |  | 6P-2A | 7P-3A | 7P-3A IZA/ | 6P-2A
carp | Shell,[NAME] |  |  |  |  | 9a - 5p
elec | Shiels,J |  |  |  |  |  | 6:30 PM - TILL | 6:30 PM - TILL
carp | Sunerg,M |  |  |  |  | 9a - 5p
carp | [NAME],[NAME] |  |  |  |  |  |  | 10p - 6a
Spreadsheet: 820497d1678129290-sumifs-function-gives-0-as-result-excel-work
Sheet: Pregled po regionima

 |  | 2019-01-01 00:00:00 | 2019-02-01 00:00:00 | 2019-03-01 00:00:00 | 2019-04-01 00:00:00 | 2019-05-01 00:00:00 | 2019-06-01 00:00:00 | Ukupno
 | Primorje | 128 | 256 | 348 | 345 | 236 | 178
 | Sever | 234 | 134 | 567 | 435 | 345 | 567
 | Centar | 340 | 12 | 786 | 525 | 454 | 956
 | Ukupno
 | Prosečno
Spreadsheet: 128631d1321121878-want-half-decimal-value-in-cell-sheetremovehalf
Sheet: Data

Num1 | Num2 | Num3 | Num4 | Num5
 |  |  |  |  |  | <<This sheet is the original data
Spreadsheet: 828933d1683799144-search-a-text-from-an-array-of-values-fetch-object
Sheet: Data

Text | Find Object | Cheese | Expected Result
1.  Hours and [NAME] (P311221) |  |  | P311221
1. RMA Revisions - P400511 (ZJDE0001) |  |  | P400511 |  |  | P400511
6. Preference Profile (R40400) |  |  | R40400 |  |  | R40400
12. Specify P4113 version to use (Recognize blank LOTS) custom PO's from P4113 to hold TO_LOCATION lot status even though it is blank.   Note - this option is used inline with above PO option value -1.    Default - ZJDE0001 |  |  | P4113 |  |  | P4113
2. Enter Version for R04110ZA |  |  | R04110ZA |  |  | R04110ZA
1. Enter Version for R47011 : |  |  | R47011 |  |  | R47011
3.  Enter the version for [NAME] (cvt to .txt) to call.       Blank = Version XBX0002 with the country        code defined here. |  |  | [NAME] |  |  | [NAME]
12. P42101 [NAME] |  |  | P42101 |  |  | P42101
1. R42565 Version |  |  | R42565 |  |  | R42565
3. Test Results Revisions (P3711) |  |  | P3711 |  |  | TEST, P3711
3.  [NAME] (P43512) |  |  | P43512
8. Tickler Version [P5900088] |  |  | P5900088 |  |  | P5900088
Spreadsheet: 731998d1620739959-extract-data-based-on-a-drop-down-list-selection-version-10
Sheet: Merchant

Code |  | Merchant |  |  |  |  | Boxes | Total
WT
Transaction | Vessel | Species | MSC | Grade | Presentation | Number of Boxes | [NAME] | Unit Price | Total Value
Spreadsheet: 860864d1708888185-bulk-combine-rows-using-lead-column-as-guide-sample-combine-rows-in-bulk
Sheet: Sheet1

[NAME]
Default | Images
DHKIT | /img_to_import/h88ch.jpg&&
DHKIT | /img_to_import/h44blk.jpg&&
DHKIT | /img_to_import/h15sn.jpg&&
DHKIT | /img_to_import/h11db.jpg&&
DHKIT | /img_to_import/h04sb.jpg
L206 | /img_to_import/l20615sn.jpg&&
L206 | /img_to_import/l20644blk.jpg&&
L206 | /img_to_import/l20611db.jpg&&
L206 | /img_to_import/l20688ch.jpg
EL4351 | /img_to_import/l43515sn.jpg&&
EL4351 | /img_to_import/l53511db.jpg
Desired Results
DHKIT | /img_to_import/h88ch.jpg&&/img_to_import/h44blk.jpg&&/img_to_import/h15sn.jpg&&/img_to_import/h11db.jpg&&/img_to_import/h04sb.jpg
DHKIT
DHKIT
DHKIT
DHKIT
L206 | /img_to_import/l20615sn.jpg&&/img_to_import/l20644blk.jpg&&/img_to_import/l20611db.jpg&&/img_to_import/l20688ch.jpg
L206
L206
L206
EL4351 | /img_to_import/l43515sn.jpg&&/img_to_import/l53511db.jpg
EL4351
Spreadsheet: 38834d1236967434-what-if-with-excel-book2
Sheet: Sheet1

alpha | 0.4 |  | Gamma | 0.4 |  | cpus | 1 |  | x | 0.5 |  |  | 1e-06
beta | 0.8 |  | delta | 0.8 |  | we | 0.5 |  | ty | 0.5 |  |  | 0.999999
 |  |  | Alpha | 0.08 |  | cc | 0.0001 |  | H | 2
 |  |  |  |  |  | de | 5
week | s2 | b2 | sb | vc | cd | cc | l | l2 | value | x1 | x2 | x1/x2
0 | 1 | 1 | 1.999992500070312 | 1.000000234375137 | 0.3000004 | 0.6999995999999999 |  |  |  | 0.7578594200349508 | 0.9999999062499604 | 0.7578594910843081
1 | 1.370992780719839 | 0.9999992312611659 | 1.999996698154516 | 0.9999994768385242 | 0.3000005483971123 | 0.6999992925047738 | 0.3709927807198388 | 7.687388341448553e-07 | 0 | 1.039018921287935 | 0.9999994405256719 | 1.039019502592673
2 | 1.370995187967368 | 0.9999992789882359 | 1.999996793624043 | 0.9999995245656361 | 0.3000005483980752 | 0.6999993115955827 | 1.755842600299077e-06 | 4.772710676351344e-08 | 1 | 1.039020725802624 | 0.9999994691619077 | 1.039021277354696
3 | 1.370995240391099 | 0.9999993209901246 | 1.999996877627712 | 0.999999566567535 | 0.3000005483980961 | 0.6999993283963215 | 3.823772074037877e-08 | 4.200191891766904e-08 | 1 | 1.039020748076069 | 0.9999994943630455 | 1.039021273443621
4 | 1.370995286518086 | 0.9999993579517873 | 1.999996951550942 | 0.9999996035292069 | 0.3000005483981146 | 0.6999993431809717 | 3.364489223584198e-08 | 3.696168782783467e-08 | 1 | 1.039020767672232 | 0.9999995165400468 | 1.039021269997407
5 | 1.370995327109835 | 0.9999993904780512 | 1.999997016603386 | 0.9999996360554787 | 0.3000005483981308 | 0.6999993561914644 | 2.960750430744496e-08 | 3.252628478792956e-08 | 1 | 1.039020784916855 | 0.999999536055808 | 1.039021266964737
Spreadsheet: ca950c13-99c6-48a8-8645-c6d1d2731d00
Sheet: Sheet1

Unnamed: 0 | 4 | x | meter | Unnamed: 4 | sim | Unnamed: 6 | Unnamed: 7
 | Klubb: |  |  |  |  |  | GREN
Sträcka | Id.nr. | Namn |  |  | Född | Sträcktid | Tid
1
2
3
4
Heat | Bana |  |  | Ansvarig tränare:
 | 4 | x | meter |  | sim
 | Klubb: |  |  |  |  |  | GREN
Sträcka | Id.nr. | Namn |  |  | Född | Sträcktid | Tid
1
2
3
4
Heat | Bana |  |  | Ansvarig tränare:
Spreadsheet: 143112d1330205563-help-with-if-excel-function-sample_if
Sheet: Sheet3

 |  |  |  |  | ALL PASS | Summary
 |  |  |  | Test 1 | OK
 |  |  |  | Test 2 | OK
 |  |  |  | Test 3 | OK
 |  |  |  | Test 4 | OK
 |  |  |  | Test 5 | OK
 |  |  |  | Test 6 | OK
 |  |  |  | Test 7 | OK
 |  |  |  | Test 8 | OK
 |  |  |  | Test 9 | OK
 |  |  |  | Test 10 | OK
 |  |  |  | Test 11 | OK
 |  |  |  | Test 12 | OK
 |  |  |  | Test 13 | OK
 |  |  |  | Test 14 | OK
 |  |  |  | Test 15 | OK
 |  |  |  | Test 16 | OK
 |  |  |  | Test 17 | OK
 |  |  |  | Test 18 | OK
 |  |  |  | Test 19 | OK
 |  |  |  | Test 20 | OK
 |  |  |  | Test 21 | OK
 |  |  |  | Test 22 | OK
 |  |  |  | Test 23 | OK
 |  |  |  | Test 24 | OK
 |  |  |  | Test 25 | OK
 |  |  |  | Test 26 | OK
 |  |  |  | Test 27 | OK
 |  |  |  | Test 28 | OK
 |  |  |  | Test 29 | OK
 |  |  |  | Test 30 | OK
 |  |  |  | Test 31 | OK
 |  |  |  | Test 32 | OK
 |  |  |  | Test 33 | OK
 |  |  |  | Test 34 | OK
 |  |  |  | Test 35 | OK
 |  |  |  | Test 36 | OK
 |  |  |  | Test 37 | OK
 |  |  |  | Test 38 | OK
 |  |  |  | Test 39 | OK
 |  |  |  | Test 40 | OK
 |  |  |  | Test 41 | OK
 |  |  |  | Test 42 | OK
 |  |  |  | Test 43 | OK
 |  |  |  | Test 44 | OK
Spreadsheet: 866212d1713184526-two-way-row-and-column-lookup-using-index-match-two-way-lookup-using-index-match-aligw
Sheet: Sheet1

 |  |  |  |  |  |  |  | Exam Grades
Roll Number | Name | Date | Grade | AliGW |  |  |  | Roll Number | Name | 2024-04-01 00:00:00 | 2024-04-02 00:00:00 | 2024-04-03 00:00:00 | 2024-04-04 00:00:00 | 2024-04-05 00:00:00 | 2024-04-06 00:00:00 | 2024-04-07 00:00:00 | 2024-04-08 00:00:00 | 2024-04-09 00:00:00 | 2024-04-10 00:00:00
1 | A | 2024-04-01 00:00:00 | A |  |  |  |  | 1 | A | A | A+ | Absent
2 | B | 2024-04-01 00:00:00 | A |  |  |  |  | 2 | B | A | Absent | A+
3 | C | 2024-04-01 00:00:00 | B |  |  |  |  | 3 | C | B | B | A
4 | D | 2024-04-01 00:00:00 | Absent |  |  |  |  | 4 | D | Absent | Absent | Absent
5 | E | 2024-04-01 00:00:00 |  |  |  |  |  | 5 | E
1 | A |  | A+ |  |  |  |  | 6 | F
2 | B |  | Absent |  |  |  |  | 7 | G
3 | C |  | B |  |  |  |  | 8 | H
4 | D |  | Absent |  |  |  |  | 9 | I
5 | E |  |  |  |  |  |  | 10 | J
1 | A |  | Absent
2 | B |  | A+
3 | C |  | A
4 | D |  | Absent
5 | E
Need a Two way lookup formula using Index Match from data highlighted in Blue.
Spreadsheet: 185538d1349758636-formula-to-rank-and-populate-values-base-don-rank-ranking-query-modified
Sheet: Sheet1

RUSSIA | Q3 VS Q2 $ | Ranking (descending order of Column B Data) |  |  | Ranking (ascending order order of Column B Data) |  |  | Pay Out
AB | -14172 | 9 |  |  | 5
BC | 8320 | 5 |  |  | 9
CD | 364.2000000000116 | 6 |  |  | 8
EF | 12962 | 4 |  |  | 10 |  |  | 200
GH | 58741 | 2 |  |  | 12 |  |  | 600
IJ | -5294.919999999984 | 8 |  |  | 6
KL | -106623 | 12 |  |  | 2
LM | 101244.25 | 1 |  |  | 13 |  |  | 800
NO | -3899 | 7 |  | To use formula to rank | 7 |  | To use formula to rank |  |  | Based on the table of payout given below, formula to match payout to rank
PQ | 36674 | 3 |  |  | 11 |  |  | 400 |  | For Eg, If Rank 1 (based on descending order), "LM" will get $800
RS | -53171 | 11 |  |  | 3
 | 35145.53
ITALY
TU | -38473.19 | 10 |  |  | 4
XY | -148197.02 | 13 |  |  | 1
 | -186670.21
Ranking Total Payout: |  | 2000
PSR Rank | 1 | 800
PSR Rank | 2 | 600
PSR Rank | 3 | 400
PSR Rank | 4 | 200
Spreadsheet: 38524d1236690114-summarizing-data-over-several-sheets-new-bolts-list
Sheet: DETAILS2

BOLT | 20 LG Hex head bolt | 25 LG Hex head bolt | 30 LG Hex head bolt | 35 LG Hex head bolt | 40 LG Hex head bolt | 45 LG Hex head bolt | 50 LG Hex head bolt | 55 LG Hex head bolt | 60 LG Hex head bolt | 65 LG Hex head bolt | 70 LG Hex head bolt | 75 LG Hex head bolt | 80 LG Hex head bolt | 85 LG Hex head bolt | 90 LG Hex head bolt | 95 LG Hex head bolt | 100 LG Hex head bolt | 105 LG Hex head bolt | 110 LG Hex head bolt | 115 LG Hex head bolt | 120 LG Hex head bolt | 125 LG Hex head bolt | 130 LG Hex head bolt | 135 LG Hex head bolt | 140 LG Hex head bolt | 145 LG Hex head bolt | 20 LG socket head csk bolt | 25 LG socket head csk bolt | 30 LG socket head csk bolt | 35 LG socket head csk bolt | 40 LG socket head csk bolt | 45 LG socket head csk bolt | 50 LG socket head csk bolt | 55 LG socket head csk bolt | 60 LG socket head csk bolt | 65 LG socket head csk bolt | 70 LG socket head csk bolt | 75 LG socket head csk bolt | 80 LG socket head csk bolt | 85 LG socket head csk bolt | 90 LG socket head csk bolt | 95 LG socket head csk bolt | 100 LG socket head csk bolt | 105 LG socket head csk bolt | 110 LG socket head csk bolt | 115 LG socket head csk bolt | 120 LG socket head csk bolt | 125 LG socket head csk bolt | 130 LG socket head csk bolt | 135 LG socket head csk bolt | 140 LG socket head csk bolt | 145 LG socket head csk bolt
M8
M10
M12
M16
M20
M24
M30
M8CSK
M10CSK
M12CSK
M16CSK
M20CSK
M24CSK
M30CSK
Spreadsheet: 137981d1327453703-forumula-to-get-data-across-pages-sum-across-sheets
Sheet: Jim

 | 150
 | 151
 | 152
 | 153
 | 154
 | 155
 | 156
 | 157
 | 158
 | 159
 | 160
 | 161
 | 162
 | 163
 | 164
 | 165
 | 166
 | 167
 | 168
 | 169
 | 170
 | 171
 | 172
 | 173
 | 174
Spreadsheet: 65968d1266592488-find-identical-item-look-for-true-2-columns-over-sample-bj
Sheet: Sheet1

Card 1 | Card 2 | Possible Combo | Value | Ace | End Hand Total | Possible Hand
A | A |  | 2 | A Low | 0 | 1
2 | A |  | 3 | A Low | 0 | 1
3 | A |  | 4 | A Low | 0 | 1 |  | Need formula in G column that checks to see if "End total" for "Possible Combo" is NOT true for any other exact card order in C
4 | A |  | 5 | A Low | 0 | 1
5 | A |  | 6 | A Low | 0 | 1
6 | A |  | 7 | A Low | 0 | 1
7 | A |  | 8 | A Low | 0 | 0
8 | A |  | 9 | A Low | 0 |  |  | Values should return 0 because identical hands below show "1" for "End Hand Total"
9 | A |  | 10 | A Low | 0
10 | A |  | 11 | A Low | 0
J | A |  | 11 | A Low | 0
Q | A |  | 11 | A Low | 0
K | A |  | 11 | A Low | 0
A | 2 |  | 3 | A Low | 0 | 1
2 | 2 |  | 4 | A Low | 0 | 1
3 | 2 |  | 5 | A Low | 0 | 1
A | A |  | 22 | A Hi | 0 | 0
2 | A |  | 13 | A Hi | 0 | 1
3 | A |  | 14 | A Hi | 0 | 1
4 | A |  | 15 | A Hi | 0 | 1
5 | A |  | 16 | A Hi | 0 | 1
6 | A |  | 17 | A Hi | 0 | 1 |  | (Rule ON: Dealer hits soft 17)
7 | A |  | 18 | A Hi | 1 | 1
8 | A |  | 19 | A Hi | 1 | 1
9 | A |  | 20 | A Hi | 1 | 1
10 | A |  | 21 | A Hi | 1 | 1
J | A |  | 21 | A Hi | 1 | 1
Q | A |  | 21 | A Hi | 1 | 1
K | A |  | 21 | A Hi | 1 | 1
A | 2 |  | 13 | A Hi | 0 | 1
2 | 2 |  | 4 | A Hi | 0 | 1
Spreadsheet: 47703d1246886127-sorting-and-matching-example
Sheet: Users

Order of IDs | id | user_name | first_name | last_name | phone | cell_phone | work_phone | [NAME]
51516 | 49446 | RobertE_MorganJr | [NAME] | Morgan Jr | 99999999 |  |  | 816 19th St
52593 | 51516 | Walgreens2362 |  | Walgreens #2362 | 999999999 |  | 99999999 | 1215 16th St
52413 | 51745 | BledsoeRiggertGuerrettaz |  | [NAME] | 9999999999 |  | 9 | 516 X St
51745 | 52413 | JulieA_Jacobson | [NAME] | [NAME] | 99999999 | 999999 | 99999 | 2021 30th St
49446 | 52593 | Dolph_Becker | Dolph | Becker | 999999 | 9999 | 99999999 | 3812 River Bluff Rd
51745 | 52914 | ShirleyJ_Roberson | [NAME] | Roberson | 99999 | 9999 | 999999999 | 2205 27th St
Spreadsheet: andy_zipper__547__11_19_01GO
Sheet: Sheet1

 |  |  | SCS  OPTION  DATA
 | TICKER | STRIKE | STR BID | STR ASK | B VOL | A VOL | M STD/DAY | WHEN
 | [NAME] | 49 | 350 | 450 | 60.5 | 77.8 | 2.13 | 2001-11-19 10:58:00
 | HU F2 | 50 | 710 | 810 | 56.2 | 64.1 | 1.89 | 2001-11-19 10:58:00
 | HU G2 | 51 | 940 | 1040 | 53.2 | 58.9 | 1.8 | 2001-11-19 10:58:00
 | [NAME] | 52 | 1050 | 1150 | 49.5 | 54.2 | 1.7 | 2001-11-19 10:58:00
 | [NAME] | 58 | 1250 | 1350 | 46.7 | 50.5 | 1.77 | 2001-11-19 10:58:00
 | [NAME] | 59 | 1330 | 1500 | 44 | 49.6 | 1.74 | 2001-11-19 10:58:00
 | [NAME] | 59 | 1450 | 1600 | 43.8 | 48.4 | 1.71 | 2001-11-19 10:58:00
 | HU N2 |  |  |  | 39.3 | 43.3 | 1.64 | 2001-11-14 11:13:00
 | [NAME] |  |  |  | 36.7 | 41.4 | 1.64 | 2001-11-09 14:53:00
 | HU U2 |  |  |  | 36 | 39.4 | 1.59 | 2001-10-29 14:33:00
 | [NAME] |  |  |  | 32.2 | 36.6 | 1.43 | 2001-10-22 14:23:00
 | [NAME] |  |  |  |  |  | 1.26 | 2001-08-20 15:44:00
 | [NAME]
 | HU F3
 | [NAME] |  |  |  |  |  | 0.56 | 2001-07-19 17:15:00
 | HU H3
Spreadsheet: 824753d1680802817-separate-out-accrue-rate-into-excel-column-accrual-rate
Sheet: Sheet1

Accrual Rate
[After 10 Years, accrue 9.334 hours  twice a month] | IF(A2="9.334", value_to_return, "9.334"),IF(A2="6", value_to_return, "6")IF(A2="7.667", value_to_return, "7.667"),"")
[After 0 Days, accrue 6 hours  twice a month] | IF(A2="9.334", value_to_return, "9.334"),IF(A2="6", value_to_return, "6")IF(A2="7.667", value_to_return, "7.667"),"")
[After 2 Years, accrue 7.667 hours  twice a month] | IF(A2="9.334", value_to_return, "9.334"),IF(A2="6", value_to_return, "6")IF(A2="7.667", value_to_return, "7.667"),"")
[After 0 Days, accrue 9.334 hours  twice a month] | IF(A2="9.334", value_to_return, "9.334"),IF(A2="6", value_to_return, "6")IF(A2="7.667", value_to_return, "7.667"),"")
[Not currently assigned to plan] | IF(A2="9.334", value_to_return, "9.334"),IF(A2="6", value_to_return, "6")IF(A2="7.667", value_to_return, "7.667"),"")
expected results
Accrual Rate
[After 10 Years, accrue 9.334 hours  twice a month] | 9.334
[After 0 Days, accrue 6 hours  twice a month] | 6
[After 2 Years, accrue 7.667 hours  twice a month] | 7.667
[After 0 Days, accrue 9.334 hours  twice a month] | 9.334
[Not currently assigned to plan] | "blank"
Spreadsheet: 859598d1707925779-calculating-ot-in-excel-time-card
Sheet: Sheet1

Date | Job duties | Time In | Time Out |  | Lunch/Break | Daily Total | Weekly Total | OT | Training Center | Route Hours | Vacation | Sick | Holiday
 | Week One
2024-02-12 00:00:00 |  | 06:00:00 | 16:00:00 |  | 0.5
 |  | 06:00:00 | 16:00:00 |  | 0.5
 |  | 06:00:00 | 16:00:00 |  | 0.5
 |  |  |  |  | 0 |  |  |  |  |  | 8
 |  | 06:00:00 | 16:00:00 |  | 0.5
 | Week One Totals
 | Week Two
 |  | 06:00:00 | 16:00:00 |  | 0.5
 |  | 06:00:00 | 16:00:00 |  | 0.5
 |  | 06:00:00 | 16:00:00 |  | 0.5
 |  | 06:00:00 | 16:00:00 |  | 0.5
 |  | 06:00:00 | 16:00:00 |  | 0.5
 | Week Two Totals
 | Pay Period Total Hours
Spreadsheet: 804391d1668037293-formula-for-printing-all-sheets-xcvbtr10
Sheet: 26

 |  | [NAME])  YA MSHIRIKA T.A.G HERMON REVIVAL CHURCH |  |  |  |  |  |  |  |  | MWAKA
 |  | JINA KAMILI | WEEKS | JAN | FEB | [NAME] | APRIL | MAY | [NAME] | JULY | AUGU | SEPT | OKT | NOV | DEC | JUMLA
 |  | HT22 | 1
 |  |  | 2
 |  |  | 3
 |  |  | 4
 |  |  | 5
 |  |  | JUMLA
Spreadsheet: 858514d1707167969-comments-or-notes-on-calendar-calendar-1-month-per-tab
Sheet: March

 |  | 2024-02-27 00:00:00 | 2024-02-28 00:00:00 | 2024-02-29 00:00:00 | 2024-03-01 00:00:00 | 2024-03-02 00:00:00 | 2024-03-03 00:00:00
 |  | 2024-03-05 00:00:00 | 2024-03-06 00:00:00 | 2024-03-07 00:00:00 | 2024-03-08 00:00:00 | 2024-03-09 00:00:00 | 2024-03-10 00:00:00
 |  | 2024-03-12 00:00:00 | 2024-03-13 00:00:00 | 2024-03-14 00:00:00 | 2024-03-15 00:00:00 | 2024-03-16 00:00:00 | 2024-03-17 00:00:00
 |  | 2024-03-19 00:00:00 | 2024-03-20 00:00:00 | 2024-03-21 00:00:00 | 2024-03-22 00:00:00 | 2024-03-23 00:00:00 | 2024-03-24 00:00:00
 |  | 2024-03-26 00:00:00 | 2024-03-27 00:00:00 | 2024-03-28 00:00:00 | 2024-03-29 00:00:00 | 2024-03-30 00:00:00 | 2024-03-31 00:00:00
 |  | 2024-04-02 00:00:00 | NOTES
Spreadsheet: 750829d1633664935-sumifs-less-numbers-0-bo-backtesting-temp
Sheet: CALCS

TIME CALCS
START | END | TOTAL TIME | ENTRIES | AVE PRICE | TRADED %
08:00:00 | 08:29:00
08:30:00 | 08:59:00
09:00:00 | 09:29:00
09:30:00 | 09:49:00
09:50:00 | 10:29:00
10:30:00 | 11:29:00
11:30:00 | 15:59:00
FED TAX TABLE
Income
Tax Rate
M-to-M | Yes | Yes
INCOME | RATE
19750 | 0.1
80250 | 0.12
171050 | 0.22
326600 | 0.24
414700 | 0.32
622050 | 0.35
 | 0.37
Spreadsheet: 00d918fa-4f64-453d-b01d-86dbd8cd0e99
Sheet: SUMMARY - Year 1

BUDGET SUMMARY
CATEGORIES
I.       PERSONNEL SERVICES
II.      CONSULTANT  SERVICES
III.     SUBCONTRACT SERVICES
IV.     PATIENT SERVICES
[NAME]
VI.     SUPPLIES
VII.    TRAVEL
VIII.   OTHER COSTS
TOTAL
-2-
Spreadsheet: 50721d1250184813-cross-verification-of-group-total-automatically-group-verification
Sheet: Sheet1

 | Account Code | Account Description | Level | Parent | Debit | Credit
 | 10000 | Account 1 | 1 |  | 100 | 100
 | 11000 | Account 2 | 2 | 10000
 | 11001 | Account 3 | 3 | 11000 | 100
 | 12000 | Account 4 | 2 | 10000 |  | 100
 | 12001 | Account 5 | 3 | 12000 | 50
 | 12002 | Account 6 | 3 | 12000 |  | 150
 | 20000 | Account 7 | 1 |  | 100 | 100
 | 21000 | Account 8 | 2 | 20000
 | 21001 | Account 9 | 3 | 21000 | 100
 | 22000 | Account 10 | 2 | 20000 |  | 100
 | 22001 | Account 11 | 3 | 22000 | 50
 | 22002 | Account 12 | 3 | 22000 |  | 150
Spreadsheet: sally_beck__33737__MgmtSum-Q3-0728
Sheet: GrossMargin

PLAN2000
[NAME] | ENRON NORTH AMERICA |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | DEALS IDENTIFIED
2000-09-01 00:00:00 | 3RD QUARTER 2000 DETAIL OF GROSS MARGIN
M.QTD
ENA |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | Forecast Margin Calculation
 |  |  |  |  |  |  |  |  | Actual | Deals | Forecast | Total | Margin |  |  |  | Earnings Before Allocated Expenses
 | Business Team |  | DPR(1) | MPR | Accruals |  | Other | FTA | Margin | Identified | Margin | Margin | Plan | [NAME] |  |  | Plan | Forecast | [NAME]
[NAME] | Gas Trading |  | -2905
ASST_TRD | Texas Desk |  | -3096
 | Gas Trading
TRD_MKT | Canada Trading |  | -3259
E_PWR_TR_AND_GENCO | East Power Trading
W_PWR_TR | West Power Trading |  | 22091
IR_FX | Financial Drift |  | 8354
ECT_INV_IRFX | Financial Trading
COAL | Coal Trading |  | -2806
SO2 | Emissions (Coal) |  | 1395
WEATHER | Weather |  | -233
CROSS_COMM | Cross Commodity Trading |  | -8235
 | Total Trading & Risk Management
E_ORG | East Midstream
W_ORIG | West Midstream |  |  | 511 | 1 |  | 7900
DWNSTRM_IND_ORIG | Industrial Downstream |  |  | 0
N_BS_DEV | Generation Investments |  |  | 3553
 | Coal-Origination & Finance |  |  | -8 | 107
fin | Canada Origination & Finance |  |  | -2042 |  |  |  |  |  |  |  |  | 11556
ASST_ORIG | Upstream Originations |  | 84 | 136 | 7238 |  | 140
 | HPL |  |  |  | 7413 |  | 1708
 | LRC |  |  |  | 1559
INSURANCE | GRM - New Products
MEXICO | Mexico
 | Total Origination
EQUITY | Principal Investing |  |  | -18333
PROD_FIN | Energy Capital Resources |  |  | -1122 | 260
ASST_MGT_AND_RESTRCT | Special Assets
CTG_ASSETS | CTG Assets |  |  | -26117 | 3051
 | CTG Assets
 | Total Investing
CTG | Commercial Transactions Group
OF_CHAIR | Office of the Chairman |  | -55573
TREASURY_INT | Other Interest Related Charges |  |  |  | -13507
 | Overview |  |  |  |  |  |  |  |  |  |  |  | 42685
 | Total |  |  |  |  | Other Expenses:
 | (1) Excludes Cap. Charge & Operating Costs
 | Check Figures
 | Gas Trading
 | Emerging Businesses