tianzl66/Sheetpedia huggingface dataset:
Spreadsheet: 843429d1695265339-average-if-cell-shows-up-in-column-a-or-b-last-3-times-only-book2-1-1-
Sheet: Sheet1

AA | CC | 4
BB | AA | 5
CC | BB | 7
AA | CC | 8
BB | AA | 3
CC | BB | 2 |  |  | AA
AA | CC | 4 |  |  | BB
BB | AA | 1 |  |  | CC
CC | BB | 5
AA | CC | 5
BB | AA | 6
CC | BB | 4
Spreadsheet: 691607d1597775538-countif-or-sumif-2020-08-18-oeldere-ron-purpura-691605d1597774973-countif-or-sumif-rvu-total
Sheet: PT

Rijlabels | Som van Work RVU
41026855 | 2.5
6-mrt | 2.5
12554 | 2.5
41026896 | 1.92
9-mrt | 1.92
11498 | 1.92
41032314 | 2.26
24-feb | 2.26
12554 | 2.26
41033149 | 2.39
3-feb | 1.42
12306 | 1.42
29-apr | 0.97
11498 | 0.97
41033728 | 1.42
13-jul | 1.42
11498 | 1.42
41034184 | 1.42
17-jul | 1.42
12554 | 1.42
41034456 | 4.329999999999999
9-mrt | 1.42
11498 | 1.42
2-apr | 0.97
11498 | 0.97
23-apr | 0.97
11498 | 0.97
22-mei | 0.97
11498 | 0.97
41034834 | 1.42
18-mei | 1.42
11498 | 1.42
41035666 | 1.42
20-mei | 1.42
11498 | 1.42
41035818 | 8.32
18-feb | 1.37
12306 | 1.37
24-feb | 1.37
10410 | 1.37
13-mrt | 1.37
12306 | 1.37
17-mrt | 0.5
11498 | 0.5
13-apr | 1.37
10410 | 1.37
15-jun | 1.37
10410 | 1.37
21-jul | 0.97
40248 | 0.97
41035819 | 1.42
30-jul | 1.42
40248 | 1.42
41037139 | 1.72
27-mrt | 0.75
40248 | 0.75
14-mei | 0.97
10410 | 0.97
41037410 | 1.42
24-jun | 1.42
12554 | 1.42
41037932 | 1.42
22-jun | 1.42
12554 | 1.42
41039118 | 0.93
26-mrt | 0.93
40248 | 0.93
41039583 | 2.47
3-jun | 1.5
10410 | 1.5
24-jun | 0.97
10410 | 0.97
41040132 | 5.55
12-mrt | 1.5
11498 | 1.5
29-apr | 0.97
12554 | 0.97
13-mei | 1.54
12554 | 1.54
13-jul | 1.54
12554 | 1.54
41040622 | 2.39
1-jul | 1.42
11498 | 1.42
29-jul | 0.97
11498 | 0.97
41040846 | 1.42
24-jun | 1.42
40248 | 1.42
41041154 | 1.42
2-jul | 1.42
11498 | 1.42
41041273 | 1.42
27-apr | 1.42
40248 | 1.42
41050610 | 1.42
23-apr | 1.42
11498 | 1.42
41052259 | 6.35
27-apr | 1.5
10410 | 1.5
11-mei | 0.97
10410 | 0.97
18-mei | 1.37
10410 | 1.37
11-jun | 0.97
10410 | 0.97
25-jun | 1.54
10410 | 1.54
41052383 | 0.93
24-apr | 0.93
40248 | 0.93
41052740 | 0.93
30-apr | 0.93
11498 | 0.93
41052873 | 1.42
16-jun | 1.42
12554 | 1.42
41052932 | 2.92
5-mei | 1.42
12554 | 1.42
8-jun | 1.5
12554 | 1.5
41053412 | 6.77
8-mei | 1.37
40248 | 1.37
22-mei | 1.37
20788 | 1.37
5-jun | 1.37
20788 | 1.37
23-jun | 0.97
12554 | 0.97
21-jul | 1.69
20788 | 1.69
41053553 | 6.35
11-mei | 1.5
10410 | 1.5
4-jun | 1.37
10410 | 1.37
6-jul | 0.97
12306 | 0.97
16-jul | 1.54
10410 | 1.54
24-jul | 0.97
12306 | 0.97
41054635 | 2.09
20-jul | 2.09
10410 | 2.09
41055036 | 1.42
21-mei | 1.42
11498 | 1.42
41055784 | 1.42
29-mei | 1.42
11498 | 1.42
41082429 | 1.5
10-jun | 1.5
12554 | 1.5
41082899 | 1.42
18-jun | 1.42
11498 | 1.42
41084970 | 1.42
31-jul | 1.42
40248 | 1.42
41091864 | 1.37
28-jul | 1.37
12306 | 1.37
Eindtotaal | 86.71000000000004
Spreadsheet: 149893d1334175308-excel-2007-sumproduct-across-multiple-worksheets-value-error-sample
Sheet: Summary

 | Serial Numbers
Employees | 100 | 101 | 102 | 103 | 104 | 105
Fred
[NAME]
Darry
[NAME]
Susi
[NAME]
Worksheet List
January
February
Spreadsheet: 774902d1648719260-retrieve-a-value-in-another-sheet-based-on-conditions-test-dashboard
Sheet: CLIENTS

CID | DENOMINATION | PHONE | VAT | FIRST NAME | FAMILY NAME | ADDRESS | POST CODE | CITY | COUNTRY | [NAME] | WEBSITE | SUBSCRIPTION | LAST BILLED IN
9 | Client 9 |  |  |  |  |  |  |  |  |  |  |  | 2022
8 | Client 8 |  |  |  |  |  |  |  |  |  |  | Yes | 2022
7 | Client 7 |  |  |  |  |  |  |  |  |  |  | No | 2022
6 | Client 6 |  |  |  |  |  |  |  |  |  |  | No | 2022
5 | Client 5 |  |  |  |  |  |  |  |  |  |  | No | 2022
4 | Client 4 |  |  |  |  |  |  |  |  |  |  | Yes | 2021
3 | Client 3 |  |  |  |  |  |  |  |  |  |  | Yes | 2021
2 | Client 2 |  |  |  |  |  |  |  |  |  |  | Yes | 2021
1 | Client 1 |  |  |  |  |  |  |  |  |  |  | Yes | 2022
Spreadsheet: 271176d1381852994-perpetual-3-month-calendar-formulas-only-3-month-calendar
Sheet: 3 Month Calendar

 | 2 | 3 | 4 | 5 | 6 | 7 | 8
 |  |  | 10 | / | 2013
 | Mon | Tue | Wed | Thu | Fri | Sat | Sun
 | 2 | 3 | 4 | 5 | 6 | 7 | 8
 |  |  | 11 | / | 2013
 | Mon | Tue | Wed | Thu | Fri | Sat | Sun
 | 2 | 3 | 4 | 5 | 6 | 7 | 8
 |  |  | 12 | / | 2013
 | Mon | Tue | Wed | Thu | Fri | Sat | Sun
Spreadsheet: 38371d1236537715-how-many-items-per-month-and-average-accounts
Sheet: Sheet1

 |  |  |  | 2008 | June
 |  |  | [NAME] | Unique list code | Unique list produce | Total units | Average cost per purchase | Average cost per unit | Total cost of the item per month
 |  |  | 195 | 9 | Electricity | 1 | 525 | 525 | 525
 |  |  | 194 | 55 | Newspaper | 1 | 107 | 107 | 107
 |  |  | 193 | 82 | Santharaj | 1 | 1000 | 1000 | 1000
 |  |  | 192 | 81 | Travel Expenses | 1 | 1250 | 1250 | 1250
 |  |  | 191 | 12 | House Rent | 1 | 2500 | 2500 | 2500
 |  |  | 188 | 21 | Sugar | 2 | 34 | 17 | 34
 |  |  | 187 | 17 | Potatoes | 3 | 48 | 16 | 48
 |  |  | 185 | 16 | Onions Sm | 1 | 16 | 16 | 16
 |  |  | 184 | 13 | [NAME] | 10 | 255 | 25.5 | 255
 |  |  | 174 | 52 | Hair Cutting | 4 | 80 | 20 | 80
 |  |  | 169 | 51 | Ginger | 1 | 31 | 31 | 31
 |  |  | 157 | 46 | Gooseberry | 1 | 25 | 25 | 25
 |  |  | 154 | 80 | School Fees | 5 | 235 | 47 | 235
 |  |  | 153 | 40 | Snack Items | 1 | 56 | 56 | 56
 |  |  | 121 | 45 | [NAME] | 1 | 40 | 40 | 40
 |  |  | 93 | 43 | [NAME] | 1 | 28 | 28 | 28
 |  |  | 84 | 79 | [NAME] | 5 | 200 | 40 | 200
 |  |  | 82 | 54 | Car Rent | 2 | 375 | 375 | 750
 |  |  | 80 | 39 | [NAME] | 2 | 48.5 | 48.5 | 97
 |  |  | 79 | 15 | Onions Lrg | 5 | 29.33333333333333 | 17.6 | 88
 |  |  | 67 | 42 | Cumin | 1 | 25 | 25 | 25
 |  |  | 66 | 10 | [NAME] | 1 | 20 | 20 | 20
 |  |  | 58 | 41 | Mango | 3 | 40 | 40 | 120
 |  |  | 46 | 78 | [NAME] | 1 | 63 | 63 | 63
 |  |  | 45 | 38 | Egg | 4 | 56.125 | 56.125 | 224.5
 |  |  | 44 | 37 | Curd | 4 | 20 | 20 | 80
 |  |  | 43 | 36 | Tomato | 3 | 19 | 19 | 57
 |  |  | 40 | 35 | [NAME] | 2 | 9 | 9 | 18
 |  |  | 36 | 34 | Hospital Fees | 2 | 102 | 102 | 204
 |  |  | 24 | 100 | [NAME] | 7 | 424.8571428571428 | 424.8571428571428 | 2974
 |  |  | 21 | 77 | Breakfast | 9 | 90.77777777777777 | 90.77777777777777 | 817
 |  |  | 15 | 75 | Mobile Charge | 4 | 50 | 50 | 200
 |  |  | 14 | 33 | Coriander | 2 | 96 | 48 | 96
 |  |  | 13 | 6 | [NAME] | 2 | 158 | 79 | 158
 |  |  | 12 | 32 | Cake | 2 | 92.5 | 92.5 | 185
 |  |  | 11 | 31 | Lemon | 1 | 30 | 30 | 30
 |  |  | 10 | 30 | Fish | 17 | 102.9411764705882 | 102.9411764705882 | 1750
 |  |  | 9 | 29 | Coconut | 25 | 28.24 | 28.24 | 706
 |  |  | 8 | 76 | Vegetables | 27 | 33.51851851851852 | 33.51851851851852 | 905
 |  |  | 7 | 28 | Photo | 1 | 550 | 550 | 550
 |  |  | 5 | 27 | Biscuits | 17 | 26.84615384615385 | 20.52941176470588 | 349
 |  |  | 4 | 14 | Milk | 180 | 57 | 9.5 | 1710
 |  |  | 3 | 26 | Chicken | 5 | 364 | 364 | 1820
 |  |  | 2 | 25 | Parotte | 175 | 262.5 | 3 | 525
 |  |  | 1 | 24 | Donation | 0 | 0 | #N/A | #N/A
Spreadsheet: 40861d1239252161-link-function-between-3-different-sheets-sample
Sheet: Current Inventory

 | Value | Supplier | product name | Last updated on? | block? | In storage | In warehouse | Total | Reorder count | REORDER? | Remarks
 |  |  | Nano 4G Crystal Case |  |  | 0 | 500
 |  |  | Zune 4GB/80GB Wall AC Charger | 2007-09-14 00:00:00 |  | 0 | 1000
 |  |  | Sansa e200 skn blk | 2007-09-14 00:00:00 |  | 0 | 400
Spreadsheet: 599889d1543348528-index-and-match-function-match-roster
Sheet: Sheet1

Master Nov 26 | Match |  | Overall Master
ANDREITCHOUK, ALEXANDRE - 21784 |  |  | ANDREITCHOUK, [NAME] -21784
BOSTOCK, [NAME] |  |  | ASIF, REHAN B -20421
ASSIBU-GILMORE, DANIELLE N - 3119 |  |  | ASSIBU-GILMORE, DANIELLE N -3119
BEHL, ESHA - 1104 |  |  | BEHL, ESHA -1104
BERG, REBECCA I - 3810 |  |  | BEHMAN, DAISY -5721
BERNARD, [NAME] |  |  | BEHMAN, HAIDY -7626
[NAME], JEROO - 30790 |  |  | BEHNAM, AMIR BABAK -8367
BLACK, MAX -307739 |  |  | BEHNKE, [NAME]
BLANCHARD, ANNE-MARIE -5406 |  |  | BEHNKE, [NAME]  A -37612
BODDU, ROHINI -37396 |  |  | BEHNKE, STEVEN -310443
BUTTS, CIERA -37394 |  |  | BEHR, JACQUELINE MARIE -12551
BRENNER, [NAME] |  |  | BEHRMAN, LINDSEY LEIGH -3497
BROOKS, MARILYN S - 10270 |  |  | BEHRMAN, MATTHEW LOUIS -3487
[NAME], JENNIFER LYNN - 600 |  |  | BEIDEMAN, KRISTEN -22310
BURKE, AMY  J - 40109 |  |  | BEIDERBECKE, DEBORAH -301012
BURKE, CATHERINE A - 5322 |  |  | BEIER, GREGORY -29634
BURROUGHS, KATHRYN A - 19742 |  |  | BEIGH, SHAMEEM AHMAD -868
ASIF, REHAN B - 20421 |  |  | [NAME], ELLEN M - S00117
CABRAL, CHAD  M. - 77700219 |  |  | [NAME], NURSING HOME -6066
CABRAL, PAUL A -18852 |  |  | [NAME], RICHARD -9303
CAMPOS, RAFAEL -29861 |  |  | BEILMAN, RACHAEL -28823
CATONE, [NAME] |  |  | BEINETTI, [NAME]
CHIN, LAWRENCE - 7583 |  |  | BEINETTI, PAUL -26388
CHLELA, MYRIAM -307740 |  |  | BEIRAS, DARCI -15161
CHRISTENSEN, AMY - S04726 |  |  | BEIRNE, JEANNE,MARIE - S00374
CHRISTENSEN, BENJAMIN R - 15337 |  |  | BEIRNE, SANDRA -13965
CLAIR, [NAME] |  |  | BEISHEIM, [NAME]
[NAME], CHERI R - 12668 |  |  | BEISHEIM, MELISSA L -6218
Spreadsheet: 464265d1464960626-help-match-and-retrieve-on-criteria-test
Sheet: Before

Date | Name | Ref | Company Name | Product | Subscripton | New Bus / Renewal | Revenue | Desired | By formula
2016-06-01 00:00:00 | [NAME] | 1 | ABC Ltd | Type 1 | 1 | 1 | 296 | 2016-06-01 00:00:00
2016-06-02 00:00:00 | [NAME] | 2 | Test Company | Type 2 |  | 1 | 2 | 2016-06-02 00:00:00
2016-06-03 00:00:00 | [NAME] | 5 | XYZ | Type 2 |  | 1 | 9 | 2016-06-03 00:00:00
2016-06-04 00:00:00 | [NAME] | 4 | 125 LTD | Type 3 |  | 1 | 10 | 2016-06-04 00:00:00
2016-06-05 00:00:00 | [NAME] | 6 | XYZ | Type 1 | 2 | 1 | 62 | 2016-06-05 00:00:00
2016-06-06 00:00:00 | [NAME] | 6 | Peter & Co | Type 4 | 20 | 1 | 659 | 2016-06-06 00:00:00
2016-06-07 00:00:00 | [NAME] | 8 | 125 LTD | Type 1 | 2 | 1 | 5 | 2016-06-07 00:00:00
2016-06-08 00:00:00 | [NAME] | 2 | ABC Ltd | Type 1 | 2 | 2 | 6 | 2016-06-01 00:00:00
2016-06-09 00:00:00 | [NAME] | 1 | 126 LTD | Type 4 | 50 | 1 | 63 | 2016-06-09 00:00:00
2016-06-10 00:00:00 | [NAME] | 2 | 125 LTD | Type 1 | 5 | 2 | 6 | 2016-06-07 00:00:00
2016-06-11 00:00:00 | [NAME] | 4 | XYZ | Type 2 |  | 2 | 56 | 2016-06-03 00:00:00
2016-06-12 00:00:00 | [NAME] | 2 | Test Company | Type 2 |  | 2 | 56 | 2016-06-02 00:00:00
2016-06-13 00:00:00 | [NAME] | 4 | ABC Ltd | Type 1 | 3 | 2 | 262 | 2016-06-01 00:00:00
2016-06-14 00:00:00 | [NAME] | 8 | XYZ | Type 2 |  | 2 | 64 | 2016-06-03 00:00:00
2016-06-15 00:00:00 | [NAME] | 6 | ABC Ltd | Type 3 |  | 1 | 9 | 2016-06-15 00:00:00
2016-06-16 00:00:00 | [NAME] | 2 | Test Company | Type 1 | 5 | 1 | 26 | 2016-06-16 00:00:00
2016-06-17 00:00:00 | [NAME] | 2 | ABC Ltd | Type 3 |  | 2 | 262 | 2016-06-15 00:00:00
2016-06-18 00:00:00 | [NAME] | 1 | Test Company | Type 2 |  | 2 | 26 | 2016-06-02 00:00:00
2016-06-19 00:00:00 | [NAME] | 45 | XYZ | Type 4 | 10 | 1 | 32 | 2016-06-19 00:00:00
2016-06-20 00:00:00 | [NAME] | 5 | Peter & Co | Type 2 |  | 1 | 26 | 2016-06-20 00:00:00
2016-06-21 00:00:00 | [NAME] | 4 | Peter & Co | Type 2 |  | 2 | 62 | 2016-06-20 00:00:00
2016-06-22 00:00:00 | [NAME] | 2 | Peter & Co | Type 3 |  | 1 | 9 | 2016-06-22 00:00:00
2016-06-23 00:00:00 | [NAME] | 2 | Peter & Co | Type 1 | 4 | 1 | 32 | 2016-06-22 00:00:00
2016-06-24 00:00:00 | [NAME] | 4 | ABC Ltd | Type 4 | 20 | 1 | 9 | 2016-06-24 00:00:00
2016-06-25 00:00:00 | [NAME] | 5 | Peter & Co | Type 2 |  | 2 | 56 | 2016-06-20 00:00:00
2016-06-26 00:00:00 | [NAME] | 4 | 125 LTD | Type 3 |  | 2 | 20 | 2016-06-04 00:00:00
2016-06-27 00:00:00 | [NAME] | 23 | Test Company | Type 3 |  | 1 | 62 | 2016-06-27 00:00:00
2016-06-28 00:00:00 | [NAME] | 22 | XYZ | Type 4 | 30 | 2 | 3 | 2016-06-19 00:00:00
2016-06-29 00:00:00 | [NAME] | 4 | 125 LTD | Type 1 | 4 | 2 | 7 | 2016-06-07 00:00:00
2016-06-30 00:00:00 | [NAME] | 5 | Test Company | Type 1 | 3 | 2 | 59 | 2016-06-16 00:00:00
Spreadsheet: 124810d1318620207-conditionally-show-sheets-based-on-drop-down-disaster-drill-template
Sheet: Program 3

2012 Disaster Drill Tracking Sheet |  | Navigation
Program 3
 | Example | Jan | Feb | Mar | Apr | May | Jun | Jul | Aug | Sep | Oct | Nov | Dec | Total Drills | Total Evacs
Missing Person/Search | TTD | TTD |  |  |  |  |  |  |  |  |  |  |  | 1 | 0
Medical Emergencies |  |  | TTD |  |  |  |  |  |  |  |  |  |  | 1 | 0
Violent/Threatening Situations |  |  |  | TTD |  |  |  |  |  |  |  |  |  | 1 | 0
Gas Leak |  |  |  |  | TTD |  |  |  |  |  |  |  |  | 1 | 0
Loss of Water/Contamination |  |  |  |  |  | FWT |  |  |  |  |  |  |  | 1 | 0
Loss of Electricity, Heat and AC |  |  |  |  |  |  | FWT |  |  |  |  |  |  | 1 | 0
Chemical Spill/Release |  |  |  |  |  |  |  | EAS |  |  |  |  |  | 1 | 1
Severe Storms/ Flooding |  |  |  |  |  |  |  |  | TTD |  |  |  |  | 1 | 0
Terrorist/Radiological | EAS |  |  |  |  |  |  |  |  |  |  |  |  | 0 | 0
Explosion |  |  |  |  |  |  |  |  |  |  | TTD |  |  | 1 | 0
[NAME] |  |  |  |  |  |  |  |  |  |  |  |  |  | 0 | 0
Continuity of Operations Plan (COOP) | EOS |  |  |  |  |  |  |  |  |  |  |  | TTD | 1 | 0
Bomb Threat/Suspicious Mail | FWT |  |  |  |  |  | TTD |  |  |  |  |  |  | 1 | 0
 |  |  |  |  |  |  |  |  |  |  |  |  | TOTAL | 11 | 1
Legend |  |  |  |  |  |  |  |  | Compliance
TTD  - Tabletop Drill |  |  |  |  |  |  |  |  |  | Drills |  |  | Evacs
FWT - Functional Walk Through |  |  |  |  |  |  |  |  | Completed | 11 |  | Completed | 1
EOS  - Evacuation On Site |  |  |  |  |  |  |  |  | Required | 13 |  | Required | 2
EAS  - Evacuation to Alternate Site |  |  |  |  |  |  |  |  | TOTAL | 0.8461538461538461 |  | TOTAL | 0.5
Spreadsheet: 133091d1324163760-simplify-an-if-function-wo-test
Sheet: JAN12

DATE |  | 2012-01-01 00:00:00 | 2012-01-02 00:00:00 | 2012-01-03 00:00:00 | 2012-01-04 00:00:00 | 2012-01-05 00:00:00 | 2012-01-06 00:00:00 | 2012-01-07 00:00:00 | 2012-01-08 00:00:00 | 2012-01-09 00:00:00 | 2012-01-10 00:00:00 | 2012-01-11 00:00:00 | 2012-01-12 00:00:00 | 2012-01-13 00:00:00 | 2012-01-14 00:00:00 | 2012-01-15 00:00:00 | 2012-01-16 00:00:00 | 2012-01-17 00:00:00 | 2012-01-18 00:00:00 | 2012-01-19 00:00:00 | 2012-01-20 00:00:00 | 2012-01-21 00:00:00 | 2012-01-22 00:00:00 | 2012-01-23 00:00:00 | 2012-01-24 00:00:00 | 2012-01-25 00:00:00 | 2012-01-26 00:00:00 | 2012-01-27 00:00:00 | 2012-01-28 00:00:00 | 2012-01-29 00:00:00 | 2012-01-30 00:00:00 | 2012-01-31 00:00:00 | 2012-01-31 00:00:00
 |  | S | M | T | W | T | F | S | S | M | T | W | T | F | S | S | M | T | W | T | F | S | S | M | T | W | T | F | S | S | M |  | T
 | EMP# | 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 | 31
BILLY | 480 | D | D | D | D | D |  |  |  |  |  |  |  | D | D | D | D | D | D | D | WD |  |  |  |  |  |  | D | D | D | D |  | D
JACK | 485 | N | [NAME] | [NAME] | N | N | WN |  |  |  |  |  |  | N | N | N | N | N | N | N |  |  |  |  |  |  |  | N | N | N | N |  | N
[NAME] | 500 |  | WD | WD |  |  | D | D | D | D | D | D | D |  |  |  |  |  |  |  | D | D | D | D | D | D | D |  |  | WD
FRED | 505 |  |  |  |  |  | N | N | N | N | N | N | N |  |  |  |  |  |  |  | N | N | N | N | N | N | N |  |  |  | WD4
 |  | S | M | T | W | T | F | S | S | M | T | W | T | F | S | S | M | T | W | T | F | S | S | M | T | W | T | F | S | S | M |  | T
 |  | 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
[NAME] | 510 | D | D | D | D | D |  |  |  |  |  |  |  | D | D | D | D | D | D | D |  |  |  |  |  |  |  | D | D | D | D |  | D
CARL | 515 | N | N | N | N | N |  |  |  |  |  |  |  | N | N | N | N | N | N | N |  |  |  |  |  |  |  | N | N | N | N |  | N
DON | 520 |  |  |  |  |  | N | N | N | N | N | N | N |  |  |  |  |  |  |  | D | D | D | D | D | D | D
FRANK | 525 |  |  |  | WD |  | D | D | D | D | D | D | D |  |  |  |  |  |  |  | N | N | N | N | N | N | N
 |  |  | #N/A
 |  |  | [NAME] |  | #N/A |  |  | #N/A | #N/A |  |  |  |  |  |  |  | #N/A | #N/A | #N/A | #N/A
 |  |  | WD
 |  |  | 1900-01-01 00:00:00 |  |  |  |  |  |  | #N/A | #N/A | #N/A | #N/A | #N/A | #N/A | #N/A
 |  |  | M
Spreadsheet: 820724d1678268986-formula-to-deal-with-a-changing-pivot-table-file_sample
Sheet: pivot

 | [NAME] | Contagem de Task
 | 11 | 7
11 | Technician 36 | 4
11 | Technician 6 | 3
 | 12 | 8
12 | Technician 36 | 2
12 | Technician 6 | 6
 | 14 | 18
14 | Technician 30 | 18
 | 15 | 22
15 | Technician 16 | 11
15 | Technician 31 | 11
 | 16 | 24
16 | Technician 3 | 15
16 | Technician 37 | 9
 | 17 | 22
17 | Technician 24 | 11
17 | Technician 26 | 11
 | 21 | 15
21 | Technician 4 | 10
21 | Technician 7 | 5
 | 22 | 17
22 | Technician 10 | 13
22 | Technician 47 | 3
22 | Technician 7 | 1
 | 23 | 12
23 | Technician 12 | 11
23 | Technician 7 | 1
 | 32 | 23
32 | Technician 1 | 12
32 | Technician 28 | 11
 | 33 | 13
33 | Technician 41 | 5
33 | Technician 46 | 8
 | 34 | 12
34 | Technician 14 | 12
 | 39 | 17
39 | Technician 22 | 7
39 | Technician 40 | 10
 | 43 | 6
43 | Technician 19 | 6
 | 44 | 6
44 | Technician 5 | 6
 | 49 | 13
49 | Technician 39 | 10
49 | Technician 44 | 3
 | 52 | 15
52 | Technician 33 | 15
 | 53 | 16
53 | Technician 34 | 10
53 | Technician 45 | 6
 | 54 | 2
54 | Technician 27 | 2
 | 55 | 6
55 | Technician 11 | 6
 | 56 | 4
56 | Technician 8 | 4
 | 58 | 10
58 | Technician 35 | 10
 | 59 | 4
59 | Technician 23 | 4
 | 62 | 3
62 | Technician 13 | 3
 | 63 | 18
63 | Technician 13 | 4
63 | Technician 19 | 4
63 | Technician 42 | 8
63 | Technician 9 | 2
 | 65 | 7
65 | Technician 25 | 3
65 | Technician 32 | 4
 | 66 | 14
66 | Technician 17 | 7
66 | Technician 25 | 4
66 | Technician 44 | 3
 | 71 | 7
71 | Technician 18 | 7
 | 72 | 6
72 | Technician 41 | 2
72 | Technician 48 | 4
 | 78 | 4
78 | Technician 21 | 4
 | 82 | 7
82 | Technician 43 | 7
 | 84 | 10
84 | Technician 20 | 9
84 | Technician 32 | 1
 | 89 | 20
89 | Technician 15 | 4
89 | Technician 29 | 16
 | 91 | 5
91 | Technician 2 | 5
 | 96 | 3
96 | Technician 38 | 3
 | (em branco)
 | #N/D
 | (em branco)
 | Total Geral | 396
Spreadsheet: gstorey__12086__Sithe_Jun27_01
Sheet: Summary

VALUE OF SITHE DEAL AT EMPRESS AS OF JUNE 27, 2001
IN CANADA'S BOOKS
JULY 2001 FORWARD
 | Value of Annuity Required from Houston - USD
 |  | P7 Unwind
 |  | IM cost |  |  |  |  |  |  | IM bid | 3.65
 |  | Sithe Fee |  |  |  |  |  |  | July MI
 |  | Total |  |  |  |  |  |  | fx
 |  |  |  |  |  |  |  |  | IM cost
 |  |  |  |  |  |  | POSTID'S | Annuities | Unwind
 |  |  |  |  |  |  | P7 | 1184479 | 1184478
 |  |  |  |  |  |  | INDEX | 1184477 | 1184479
Spreadsheet: 822358d1679303624-formula-index-and-match-pontaj-2023-draft
Sheet: IANUARIE

 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | Date to Find | 2023-03-19 00:00:00
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | Found in
 |  | DATE | 2023-01-01 00:00:00
 |  | NORM |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | Row Number
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | TODAY
 | Nr. [NAME]. | ID | Name |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | NORM HOURS | WORK HOURS | SCREEN HOURS | WEEK HOURS | NIGHT HOURS | CO | CM |  |  | S | P | Z | N | H
 | 1 | 111 | Jhon | S | P | Z | N | H | S | P | Z | N | H | S | P | Z | N | H | S | P | Z | N | H | S | P | Z | N | H | S | P | Z | N | H | S
 | 2 | 112 | [NAME] | H | S | P | Z | N | H | S | P | Z | N | H | S | P | Z | N | H | S | P | Z | N | H | S | P | Z | N | H | S | P | Z | N | H
 | 3 | 113 | Adalyn | N | H | S | P | Z | N | H | S | P | Z | N | H | S | P | Z | N | H | S | P | Z | N | H | S | P | Z | N | H | S | P | Z | N
 | 4 | 114 | [NAME] | Z | N | H | S | P | Z | N | H | S | P | Z | N | H | S | P | Z | N | H | S | P | Z | N | H | S | P | Z | N | H | S | P | Z
 | 5 | 115 | Beverly | P | Z | N | H | S | P | Z | N | H | S | P | Z | N | H | S | P | Z | N | H | S | P | Z | N | H | S | P | Z | N | H | S | P
Spreadsheet: 886185d1736215723-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 |  | 3 | 0.5
Spreadsheet: 831703d1685835796-formular-to-call-data-from-another-sheet-5-and-6-ask-new-vrs
Sheet: MALE

MKOA WA MANYARA
HALMASHAURI Y WILAYA [NAME]
MATOKEO [NAME] WA MUHULA WA KWANZA MEI, 2023 DARASA LA VI WAVULANA
S/N | KATA | SHULE | JINA LA MTAHINIWA | JINSI    1. MV | MASOMO |  |  |  |  |  |  |  |  |  |  |  |  |  | JML | WASTANI | DARAJA | [NAME] | [NAME]
 |  |  |  |  | KISWAHILI |  | ENGLISH |  | HISABATI |  | SAYANSI NA TEKNOLOJIA |  | M/JAM |  | URAIA NA MAADILI |  | S/KAZI
 |  |  |  |  | A | D | A | D | A | D | A | D | A | D | A | D | A | D
1
2
3
4
5
6
7
8
9
10
11
12
13
14
15
16
17
18
19
Spreadsheet: 103602d1301345967-automated-shipping-estimator-daily_rates-1-
Sheet: UPS CWT Tier 7

 |  |  |  |  |  |  |  |  | 2011 Rates
 | Domestic
 | UPS Hundredweight Service Tier 7
 | Guaranteed Delivery Service Options
 | UPS Next Day Air |  |  |  |  |  |  |  |  |  | Hundredweight Shipment Rates Per Pound
 | Zones | 102 | 103 | 104 | 105 | 106 | 107 | 108 | 124 | 125 | 126
 | 100 Lbs. or more | 1.69 | 2.39 | 3.71 | 4.11 | 4.48 | 4.67 | 4.85 | 4.9 | 4.6 | 5.4
 | UPS Next Day Air Saver |  |  |  |  |  |  |  |  |  | Hundredweight Shipment Rates Per Pound
 | Zones | 132 | 133 | 134 | 135 | 136 | 137 | 138 | Service Not Available
 | 100 Lbs. or more | 1.4 | 2.05 | 3.64 | 3.87 | 4.13 | 4.35 | 4.49
 | UPS 2nd Day Air A.M. |  |  |  |  |  |  |  |  |  | Hundredweight Shipment Rates Per Pound
 | Zones | 242 | 243 | 244 | 245 | 246 | 247 | 248 | Service Not Available
 | 100 Lbs. or more | 1.05 | 1.19 | 1.51 | 2.2 | 3.55 | 3.75 | 3.86
 | UPS 2nd Day Air |  |  |  |  |  |  |  |  |  | Hundredweight Shipment Rates Per Pound
 | Zones | 202 | 203 | 204 | 205 | 206 | 207 | 208 | 224 | 225 | 226
 | 100 Lbs. or more | 0.87 | 0.99 | 1.28 | 1.89 | 3.13 | 3.38 | 3.44 | 3.59 | 3.26 | 4.11
 | UPS 3 Day Select |  |  |  |  |  |  |  |  |  | Hundredweight Shipment Rates Per Hundredweight Unit
 | Zones | 302 | 303 | 304 | 305 | 306 | 307 | 308 | Service Not Available
 | 200 to 499 Lbs. | 61.5 | 79.4 | 95.4 | 120.35 | 171.25 | 197.15 | 221.15
 | 500 to 999 Lbs. | 59.75 | 77.15 | 92.75 | 117.3 | 166.7 | 191.95 | 215.05
 | 1,000 Lbs. or more | 62.3 | 80.35 | 96.65 | 122.1 | 173.4 | 199.85 | 223.8
 | [NAME] |  |  |  |  |  |  |  |  |  | Hundredweight Shipment Rates Per Hundredweight Unit
 | Zones | 2 | 3 | 4 | 5 | 6 | 7 | 8 | 44 | 45 | 46
 | 200 to 499 Lbs. | 36.55 | 42.6 | 45.85 | 53.8 | 68.6 | 80.15 | 94.15 | 252.1 | 252.1 | 292.6
 | 500 to 999 Lbs. | 34.15 | 39.9 | 42.9 | 50.4 | 64.25 | 74.8 | 88 | 234.3 | 234.3 | 271
 | 1,000 Lbs. or more | 35 | 40.8 | 43.9 | 51.6 | 65.55 | 76.35 | 89.95 | 238.55 | 238.55 | 276.65
 | Minimum Charges
 | UPS 3 Day Select Zones |  |  | 302 | 303 | 304 | 305 | 306 | 307 | 308 | Service Not Available
 | Minimum Charge |  |  | 69 | 69 | 69 | 69 | 69 | 69 | 69
 | [NAME] |  |  | 2 | 3 | 4 | 5 | 6 | 7 | 8 | 44 | 45 | 46
 | Minimum Charge |  |  | 66.5 | 66.5 | 66.5 | 66.5 | 66.5 | 66.5 | 66.5 | 350 | 350 | 375