tianzl66/Sheetpedia huggingface dataset:
Spreadsheet: 864680d1711765083-need-few-tweaks-and-beautify-my-excel-kpi-dashboard-excel-helper
Sheet: Sheet1

 | MONTH |  | JAN | FEB | MAR |  | 1ST QUARTER AVG. |  | APR | MAY | JUN |  | 2ND QUARTER AVG. |  | JUL | AUG | SEP |  | 3RD QUARTER AVG. |  | OCT | NOV | DEC |  | 4TH QUARTER AVG. |  |  | TOTAL AVG. |  | G. TOTAL
 | 2023 | TARGET | 554355 | 684095 | 865687 |  |  |  | 588615 | 751655 | 663980 |  |  |  | 536283 | 750703 | 609473 |  |  |  | 696947
 |  | ACHIEVED | 494073 | 568961 | 697161 |  |  |  | 462846 | 584089 | 519085 |  |  |  | 442098 | 637810 | 503702 |  |  |  | 662751
 |  | (+/-)
 |  | KPI %
 | 2024 | TARGET
 |  | ACHIEVED
 |  | (+/-)
 |  | KPI %
Spreadsheet: kate_symes__18535__Palo
Sheet: DJ Palo Verde Electricity Index

 |  |  | Firm | Volume | Firm | Volume | Non Firm | Volume | Non Firm | Volume |  | Sunday & NERC | Volume
 | DATE |  | On [NAME] | [NAME] | [NAME] | [NAME] | On [NAME] | [NAME] | [NAME] | [NAME] |  | 24 HOUR | [NAME]
 | 2001-01-29 00:00:00 |  | 252.27 | 12400 | 177.84 | 5440
 | 2001-01-28 00:00:00 |  | 207.5 | 800 | 185 | 200 | 150.26 | 3312 | 132.26 | 2111 |  | 177.78 | 16200
 | 2001-01-27 00:00:00 |  | 225.83 | 13200 | 141.8 | 2840 | 152.11 | 781 | 114.82 | 728
 | 2001-01-26 00:00:00 |  | 225.83 | 13200 | 141.75 | 2800 | 223.17 | 1850 | 161.11 | 180
 | 2001-01-25 00:00:00 |  | 231.78 | 13440 | 144.28 | 3040 | 153.9 | 2315 | 108.66 | 1079
 | 2001-01-24 00:00:00 |  | 222.84 | 13360 | 131.11 | 2880 | 136.45 | 2624 | 93.82 | 933
 | 2001-01-23 00:00:00 |  | 254.26 | 9200 | 143.99 | 4256 | 148.73 | 2079 | 105.08 | 1209
 | 2001-01-22 00:00:00 |  | 324.8 | 9200 | 164 | 2000 | 172.56 | 2925 | 139.79 | 2097
 | 2001-01-21 00:00:00 |  | 177.5 | 2400 | 124.55 | 2200 | 152.69 | 3900 | 141.53 | 2132 |  | 168.33 | 1800
 | 2001-01-20 00:00:00 |  | 452.36 | 4400 | 226.5 | 2000 | 232.31 | 2573 | 148.33 | 1359
 | 2001-01-19 00:00:00 |  | 452.36 | 4400 | 226.5 | 2000 | 273.28 | 6682 | 128.74 | 2093
 | 2001-01-18 00:00:00 |  | 379.51 | 8960 | 214.86 | 2800 | 279.1 | 6115 | 157.96 | 2108
 | 2001-01-17 00:00:00 |  | 220.81 | 12080 | 122 | 3800 | 232.88 | 4018 | 186.65 | 824
 | 2001-01-16 00:00:00 |  | 173.04 | 18112 | 105.14 | 4120 | 231.33 | 632 | 127.03 | 579
 | 2001-01-15 00:00:00 |  | 173.04 | 18112 | 104.82 | 3960 | 169.46 | 718 | 107.24 | 593
 | 2001-01-14 00:00:00 |  | 152.5 | 0 | 103 | 0 | 130.52 | 713 | 116.11 | 446 |  | 107.23 | 13560
 | 2001-01-13 00:00:00 |  | 152.77 | 14160 | 107.23 | 4520 | 138.98 | 1547 | 120.82 | 1165
 | 2001-01-12 00:00:00 |  | 159.03 | 18032 | 90.92 | 3800 | 160.71 | 727 | 98 | 450
 | 2001-01-11 00:00:00 |  | 160.31 | 19472 | 90.92 | 3800 | 153.64 | 1669 | 94.86 | 1106
 | 2001-01-10 00:00:00 |  | 143.16 | 18208 | 84.37 | 3352 | 129.46 | 2981 | 93.14 | 1118
 | 2001-01-09 00:00:00 |  | 132.19 | 14400 | 75.61 | 4552 | 145.14 | 850 | 87.82 | 1753
 | 2001-01-08 00:00:00 |  | 127.4 | 15728 | 68.15 | 5768 | 140.11 | 1652 | 87.68 | 460
 | 2001-01-07 00:00:00 |  | 121.67 | 2400 | 65 | 800 | 84.12 | 1047 | 58.43 | 682 |  | 69.34 | 16944
 | 2001-01-06 00:00:00 |  | 121.11 | 22672 | 71.97 | 5784 | 90.26 | 442 | 59.63 | 622
 | 2001-01-05 00:00:00 |  | 121.35 | 23072 | 72.24 | 5984 | 105.21 | 932 | 98.02 | 734
 | 2001-01-04 00:00:00 |  | 131.61 | 14064 | 79.75 | 6272 | 120.52 | 512 | 71.21 | 514
 | 2001-01-03 00:00:00 |  | 143.06 | 13168 | 85.45 | 3584 | 129.29 | 613 | 75.14 | 791
 | 2001-01-02 00:00:00 |  | 149.82 | 10992 | 93.38 | 2840 | 124.91 | 1327 | 56.75 | 526
 | 2001-01-01 00:00:00 |  | 145 | 0 | 100 | 0 | 70.68 | 2284 | 50.55 | 1025 |  | 93.52 | 7320
 | 2000-12-31 00:00:00 |  | 94.03 | 2480 | 88.53 | 680 | 55.11 | 1961 | 56.69 | 816 |  | 89.07 | 1992
 | 2000-12-30 00:00:00 |  | 121.88 | 6160 | 88.79 | 1344 | 90.2 | 1203 | 69.44 | 897
Spreadsheet: 169672d1343021773-conditional-formatting-based-on-distance-from-median-value-excel-2010-conditional-format-2003
Sheet: My Soltuion 

DIRECT | 2012-07-16 00:00:00 | 2012-07-17 00:00:00 | 2012-07-18 00:00:00 | 2012-07-19 00:00:00 | 2012-07-20 00:00:00 | 2012-07-21 00:00:00 | 2012-07-22 00:00:00 | Weekly Total
 | 0.6956 | 0.8811 | 0.865 | 0.9637 | 0.8594 | 1 | 0.9863 | 0.8568
 | 0.4619 | 0.8321 | 0.6803 | 0.9386 | 0.6488 | 0.9105 | 0.8755 | 0.7134
 | 1 | 1 | 1 | 1 | 1 |  | 0.5 | 0.7778
 | 0.8 | 0.57 | 0.75 | 0.75 | 1 | 1 | 0.5 | 0.72
 | 0.6739 | 0.8205 | 0.8587 | 0.9302 | 0.8906 | 0.963 | 1 | 0.8443
 | 0.4575 | 0.8015 | 0.7332 | 0.9461 | 0.6862 | 0.965 | 0.928 | 0.7459
 | 0.65 | 0.9 | 0.8148 | 1 | 0.7647 | 1 | 1 | 0.84
 | 0.4236 |  | 0.6076 | 0.9286 | 0.6529 | 1 | 0.9524 | 0.6866
 |  | 0.8002 | 0.6155 | 0.9566 | 0.6514 | 0.985 | 0.9648 | 0.6974
 | 0.7048 | 0.5 | 0.7986 | 0.9744 | 0.8819 | 0.9737 | 0.9048 | 0.83
 | 0.4369 | 0.8365 | 0.6612 | 0.9228 | 0.4801 | 0.8434 | 0.8986 | 0.6777
 | 0.4565 | 0.7895 | 0.675 | 0.9737 | 0.6279 | 1 | 1 | 0.7112
 | 1 | 1 | 1 | 1 | 0.8889 | 1 |  | 0.8173
Median | 0.66195 | 0.8263 | 0.75 | 0.9566 | 0.7647 | 0.9924999999999999 | 0.9402
 | 0.8119500000000001 | 0.9763000000000001 | 0.9 | 1.1066 | 0.9147000000000001 | 1.1425 | 1.0902
 | 0.51195 | 0.6763 | 0.6 | 0.8066 | 0.6147 | 0.8424999999999999 | 0.7902
Spreadsheet: 39196d1237391738-help-needed-with-counting-the-number-of-instances-between-blanks-cells-676316_starbucks_junkie
Sheet: PT

 |  | Data
Product | Date | Sum of Stock_Flg | Sum of Movement
Product A | 2009-02-26 00:00:00 | 0 | 0
 | 2009-02-27 00:00:00 | 1 | 1
 | 2009-02-28 00:00:00 | 0 | 0
 | 2009-03-01 00:00:00 | 1 | 1
 | 2009-03-02 00:00:00 | 1 | 0
 | 2009-03-03 00:00:00 | 1 | 0
 | 2009-03-04 00:00:00 | 0 | 0
 | 2009-03-05 00:00:00 | 1 | 1
 | 2009-03-06 00:00:00 | 1 | 0
 | 2009-03-07 00:00:00 | 0 | 0
Product A Total |  | 6 | 3
Product B | 2009-02-26 00:00:00 | 1 | 0
 | 2009-02-27 00:00:00 | 1 | 0
 | 2009-02-28 00:00:00 | 0 | 1
 | 2009-03-01 00:00:00 | 0 | 0
 | 2009-03-02 00:00:00 | 1 | 0
 | 2009-03-03 00:00:00 | 0 | 1
 | 2009-03-04 00:00:00 | 1 | 0
 | 2009-03-05 00:00:00 | 0 | 1
 | 2009-03-06 00:00:00 | 1 | 0
 | 2009-03-07 00:00:00 | 0 | 1
Product B Total |  | 5 | 4
Spreadsheet: 885021d1734430276-extract-date-in-dd-mm-yyyy-format-dd-mm-yyyy-format
Sheet: Sheet1

Date | Answer should be
Mon Oct 26 2020 00:00:00 GMT+0530 (India Standard Time) | 2020-10-26 00:00:00
Tue Oct 27 2020 00:00:00 GMT+0530 (India Standard Time) | 2020-10-27 00:00:00
Wed Oct 28 2020 00:00:00 GMT+0530 (India Standard Time) | 2020-10-28 00:00:00
Thu Oct 29 2020 00:00:00 GMT+0530 (India Standard Time) | 2020-10-29 00:00:00
Fri Oct 30 2020 00:00:00 GMT+0530 (India Standard Time) | 2020-10-30 00:00:00
Mon Nov 02 2020 00:00:00 GMT+0530 (India Standard Time) | 2020-11-02 00:00:00
Tue Nov 03 2020 00:00:00 GMT+0530 (India Standard Time) | 2020-11-03 00:00:00
Wed Nov 04 2020 00:00:00 GMT+0530 (India Standard Time) | 2020-11-04 00:00:00
Thu Nov 05 2020 00:00:00 GMT+0530 (India Standard Time) | 2020-11-05 00:00:00
Spreadsheet: 797719d1664096283-formula-for-finding-and-matching-values-problem-test-sheet
Sheet: Position Reference

 | Game ID | ipl910 | itt1094 | itt1093 | itt1095 | itt1096 | itt1097 | itt1108 | itt1109 | itt1110 | itt1111 | itt1113 | itt1114 | itt1115 | itt1116 | itt1117 | [NAME] | itt1119 | itt1120 | itt1121 | itt1122 | itt1123 | itt1124 | itt1125 | itt1126 | [NAME] | itt1128 | itt1129 | itt1130 | itt1131 | itt1132 | itt1133 | itt1134 | itt1135
74266 | RG Sharma | B1 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | B1 |  | B1
1377783 | IP Kishan | B2 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | C2 | B3
2437039 | [NAME] | B3
264193 | SA Yadav | B4 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | C6 |  |  | B3
1774169 | NT [NAME] | B5
2272567 | H Shokeen | B6
97647 | KA Pollard | B7 |  |  |  |  |  | B6 |  | C6 |  |  |  |  |  |  |  |  |  |  |  |  |  |  | C5 |  | C7 |  | C4
1230394 | [NAME] | B8 |  |  |  |  |  |  |  |  |  |  |  | B7 | B7 |  |  |  |  |  |  | C8 | C8
264173 | [NAME] | B9
1381886 | RP Meredith | B10 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | B11 |  | B10 |  | B11
1196767 | JJ [NAME] | B11
1358247 | [NAME] | C1
8681 | RV Uthappa | C2
952567 | [NAME] | [NAME] |  |  |  |  |  | C7 |  | B7 |  |  |  |  |  | C7 |  |  |  |  |  | B7 | B7 |  |  | C7 |  | C8
8931 | AT Rayudu | C4
1917128 | SR Dubey | C5
94280 | [NAME] | C6 |  |  |  |  |  |  |  |  |  |  | B7
7561 | [NAME] | C7
247668 | D Pretorius | C8 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | C7 | C8 | B8
44613 | DJ Bravo | C9 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | C8 |  | C6 |  | C8
2206768 | MM Theekshana | C10
2266673 | MG Choudhary | C11
166944 | Babar Azam |  | B1 | B1 |  |  |  |  |  |  |  |  |  |  |  |  |  |  | B2 | B2 | [NAME]
251815 | [NAME] |  | B2 | B2
2053717 | [NAME] |  | B3 |  |  |  |  |  |  |  |  |  |  |  |  | B3 | B2 | C2 | B3 | B3 | C2
19345 | [NAME] |  | B4 | B3 |  |  |  |  |  |  |  |  |  |  |  | B4 | B4 | [NAME]
1913878 | [NAME] |  | B5 | B6 |  |  |  |  |  |  |  |  |  |  |  | B5 | B5 | C6
80441 | [NAME] |  | B6 | B8 |  |  |  |  |  |  |  |  |  |  |  | B7 | B8
8219 | [NAME] |  | B7 | B4
69226 | [NAME] |  | B8
24381 | [NAME] |  | B9 |  |  |  |  |  |  |  |  |  |  |  |  | B9 | B9
2248308 | [NAME] |  | B10 | B11 |  |  |  |  |  |  |  |  |  |  |  | B11 | B11 | C10 | B11 | B11
2128597 | [NAME] |  | B11 | B10 |  |  |  |  |  |  |  |  |  |  |  | B10 | B10 | C11 | B10 | B10 | C10
Spreadsheet: monika_causholli__28135__Exports to Brazil
Sheet: Exports to Brazil

Source: US Department of Commerce | .Total, All Districts | Unit : Air-Dried metric tons |  | Brazil
Updated: October 24, 2001
 | 2000 | 2001 | 2000 | 1999 | 1999 | 1998 | 1998 | 1997 | 1997
Exports to Brazil | Value (Dollars) | Jan- Aug
Wood Pulp | 97340475
Mechanical Woodpulp (Air Dry Weight) (Ctn) | 50988 | 0 | 181 | 0 | 0 | 89222 | 241 | 19008008 | 54087
Chemical Woodpulp, [NAME] (Air Dry Wt.) (Ctn) | 5226156 | 4336 | 6494 | 6755742 | 8408 | 7203549 | 7606 | 11572646 | 11395
Chem Wdpulp Soda/Sulfate Gr Conif Unble Air Dry Wt (Ctn) | 103492 | 0 | 377 | 0 | 0 | 0 | 0 | 458790 | 912
Chem Wdpulp Sulfate Gr Nonconif Unblch, Air Dry Wt (Ctn) | 0 | 0 | 0 | 43880 | 81 | 0 | 0 | 0 | 0
Chem Wdpulp Sulfate Gr Conif Semiblech, [NAME] (Ctn) | 418067 | 0 | 979 | 0 | 0 | 0 | 0 | 0 | 0
Chem Wdpulp Sulfate Gr Conif, Bleached, Air Dry Wt (Ctn) | 37427238 | 32200 | 60383 | 26460680 | 53934 | 26155555 | 57474 | 26727906 | 56195
Chem Wdpulp Sulfate Gr Nonconf Semiblch Air Dry Wt (Ctn) | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0
Chem Wdpulp Sulfate Gr Nonconif Bleach, [NAME] (Ctn) | 4776129 | 4322 | 8317 | 7992461 | 19249 | 2488510 | 6317 | 2440179 | 7245
Chem Wdpulp Sulfite Gr Conif Unbleachd, Air Dry Wt (Ctn) | 0 | 0 | 0 | 0 | 0 | 17650 | 72 | 2750 | 12
Chem Wdpulp Sulfite Gr Unblch Nonconif, Air Dry Wt (Ctn) | 4673 | 12 | 40 | 5117 | 24 | 11760 | 53 | 5100 | 23
Chem Wdpulp Sulfite Gr Conif Semiblech, [NAME] (Ctn) | 63260 | 1352 | 93 | 1138010 | 2562 | 5928626 | 13388 | 1268893 | 2821
Chem [NAME] Gr Nonconf Semiblea Air Dry Wt (Ctn) | 278753 | 34 | 465 | 182532 | 327 | 0 | 0 | 0 | 0
[NAME] (Air Dry Weight) (Ctn) | 38697544 | 41484 | 79981 | 34281374 | 79205 | 29639112 | 60973 | 11824873 | 25655
Spreadsheet: 823113d1679715637-summarizing-a-workbook-lego-replacement-parts
Sheet: Set # 8014

Checked | Qty | Part# | Colour | Description
 | 2 | 61190d | Black | Minifigure, Helmet Antenna / Rangefinder for Helmet SW Clone Trooper with Holes
 | 2 | 61190E | Black | LEGO Black Clone Helmet Floodlight
 | 2 | 61190F | Black | LEGO Black Minifig Gun Small Blaster DC-17
 | 1 | 74326 |  | MINI LOWER PART BLAC/WHI
 | 3 | 4529191 |  | MINI UPPER PART NO."1400"
 | 1 | 4529206 |  | Clone Helmet No.3
 | 2 | 4528085 |  | MINI HEAD NO. 525
 | 1 | 44302a | Light Grey | Hinge Plate 1 x 2 Locking with 2 Fingers on End and 9 Teeth with Bottom Groove
 | 1 | 3034 | Light Grey | Plate, 2x8
 | 2 | 4150PB002B |  | Tile, Round 2 x 2 with SW Republic Logo, Black Border, Thick Gaps Pattern (Sticker)
Spreadsheet: 882820d1731310529-help-please-any-idea-for-a-solution-caberetedoc
Sheet: Sheet1

Product | Sales Option | Currency | Wholesale | Retail | Select Product | Select Sales | Select Currency | Wholesale | Retail |  | Product | Sales Option | Currency
One | Agentur | EUR | 100,00 | 200,00 | One | Distribution | EUR
One | Agentur | USD | 120,00 | 240,00 |  |  |  |  |  |  | Two | Distribution | USD
One | Agentur | CHF | 100,00 | 200,00 |  |  |  |  |  |  |  |  | CHF
One | Distribution | EUR | 80,00 | 200,00
One | Distribution | USD | 90,00 | 240,00
One | Distribution | CHF | 80,00 | 200,00
Two | Agentur | EUR | 170,00 | 300,00
Two | Agentur | USD | 210,00 | 370,00
Two | Agentur | CHF | 170,00 | 300,00
Two | Distribution | EUR | 120,00 | 300,00
Two | Distribution | USD | 150,00 | 370,00
Two | Distribution | CHF | 120,00 | 300,00
Spreadsheet: 92753d1292313400-sampling-of-data-sample
Sheet: Sheet1

sample data
NAME | BELONGINGS
[NAME] | PEN
AJAY | PENCIL
[NAME] | RUBBER
[NAME] | CELL
AJAY | PDA
NITA | PEN
DAYANAND | PENCIL
SHASHANK | RUBBER
DAYANAND | PDA
RESULTS SHOULD BE
NAME | BELONGINGS
 | 1 | 2 | 3
[NAME] | PEN | CELL
DAYANAND | PENCIL | PDA
[NAME] | RUBBER
Spreadsheet: 840393d1692706071-return-code-of-a-cell-matched-by-location-and-part-of-the-name-do-not-use-same-results-excel-formula-help2
Sheet: Sheet1

Name Part | Location | Matched Code | [NAME] |  | Name | Location | Code
apple | London |  |  |  | apple pie | Rome | N1
melon | Rome |  |  |  | apple juice | Madrid | N2
pear | Madrid |  |  |  | 555apple | Rome | N3
apple | London |  |  |  | apple4 | Madrid | N4
melon | London |  |  |  | apple5 | London | N5
melon | London |  |  |  | pear1 | London | [NAME]
melon | Rome |  |  |  | pear2 | Rome | N7
pear | Madrid |  |  |  | pear3 | Madrid | N8
apple | Madrid |  |  |  | melon1 | London | N9
pear | Rome |  |  |  | [NAME] | Rome | N10
 |  |  |  |  | apple6 | Madrid | N11
 |  |  |  |  | [NAME] | Rome | N12
Spreadsheet: 433c2e9b-545f-49bd-941c-b67df427c2f1
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
41025231 | 2014-04-17 04:12:51 | AXIS | 1 | 7 | 3 | 1536352 | rrktank | 7594 | eastern | 1943-07-05 | 1943-07-09 | Ponyri | Ponyri
41025500 | 2014-04-17 04:37:56 | AXIS | 1 | 6 | 4 | 1542724 | EllieK | 6749 | western | 1944-06-06 | 1944-06-06 | [NAME] | [NAME]
41025748 | 2014-04-17 05:00:03 | ALLIES | 1 | 6 | 5 | 1542724 | EllieK | 6749 | western | 1944-06-06 | 1944-06-06 | [NAME] | [NAME]
41033807 | 2014-04-17 20:12:28 | ALLIES | 0 | 5 | 7 | 681429 | Caverne | 7668 | pacific | 1945-02-26 | 1945-03-06 | The Meat Grinder | Le Hachoir à viande
41034007 | 2014-04-17 20:30:35 | AXIS | 0 | 6 | 7 | 681429 | Caverne | 7668 | pacific | 1945-02-26 | 1945-03-06 | The Meat Grinder | Le Hachoir à viande
Spreadsheet: 758796d1639070202-averaging-entries-per-day-by-date-excel_example-1-
Sheet: Sheet1

ID | Start time | Completion time | Call Number
43 | 2021-12-06 09:00:03 | 2021-12-06 09:17:47 | 904
44 | 2021-12-06 06:05:43 | 2021-12-06 10:37:33 | 935
45 | 2021-12-06 09:39:49 | 2021-12-06 12:11:45 | 914
46 | 2021-12-06 12:14:06 | 2021-12-06 12:15:18 | 947
47 | 2021-12-06 12:15:22 | 2021-12-06 12:15:58 | 947 |  |  |  | Overall average
48 | 2021-12-06 12:22:30 | 2021-12-06 12:23:18 | 904
49 | 2021-12-06 10:37:38 | 2021-12-06 14:14:43 | 935 |  |  |  | 904's average
50 | 2021-12-06 14:14:53 | 2021-12-06 15:33:54 | 935
51 | 2021-12-06 15:39:35 | 2021-12-06 15:40:27 | 904
52 | 2021-12-06 15:56:19 | 2021-12-06 15:58:58 | 752
53 | 2021-12-06 15:59:01 | 2021-12-06 15:59:37 | 752
54 | 2021-12-07 16:00:17 | 2021-12-07 16:00:17 | 752
55 | 2021-12-07 16:10:08 | 2021-12-07 16:10:08 | 947
56 | 2021-12-07 16:44:02 | 2021-12-07 16:44:02 | 947
Spreadsheet: 1f7df3c1-ca37-4456-b394-b5b43ffa6166
Sheet: $ monographs totals

Total Monographs Expenditures by [NAME] FY09 and FY10
[NAME], Library Budget Only (No Endowments):
Acquisition Type | FY09 | FY10 | % change | % of total FY10 expend.
Approval plan
Kingston (Strand) | 100000 | 149863.36
[NAME] | 0 | 0 | 0 | 0
CCE | 0 | 0 | 0 | 0
Firm orders
Kingston |  | 165993.09
[NAME] (pelf) | 2168.62 | 76.5
CCE (ccef) | 7058.43 | 13780.93
Standing orders
Kingston | 24183.08 | 27708.57
[NAME] | 0 | 0 | 0 | 0
CCE | 0 | 0 | 0 | 0
TOTALS
Total Monograph Endowment Expenditures FY09 and FY10
Acquisition Type | FY09 | FY10 | % change | % of total FY10 expend.
Approval plan | 0 | 0 | 0
Kingston (Strand) | 0 | 0 | 0
[NAME] | 0 | 0 | 0 | 0
CCE | 0 | 0 | 0 | 0
Firm orders
Kingston | 20667.61 | 3459.51
[NAME] (pelf) | 0 | 0 | 0
CCE (ccef) | 0 | 0 | 0
Standing orders
Kingston | 430.4 | 351.17
[NAME] | 0 | 0 | 0 | 0
CCE | 0 | 0 | 0 | 0
TOTALS
Total Monograph Expenditures (Including Endowments) FY09 and FY10:
University Libraries | FY09 | FY10 | % change | % of total FY10 expend.
Library budget (all branches)
Endowments
TOTALS
Spreadsheet: gerald_nemec__11560__Stagecoach Consumption Band
Sheet: Gas True Up

Stagecoach Gas Delivery
[NAME]
100% Load Factor [NAME]. | 10955031.36319463 | 9894867.037724182 | 10955031.36319463 | 10601643.25470448 | 10955031.36319463 | 0 | 0 | 0 | 10601643.25470448 | 10955031.36319463 | 10601643.25470448 | 10955031.36319463
 |  |  |  |  |  |  |  |  |  |  |  |  | Annual
 | Jan | Feb | Mar | Apr | May | Jun | Jul | Aug | Sep | Oct | Nov | Dec | Total
(Compressor Station Load Factor)
Band Maximum Usage
Band Target/Baseline Usage | 0.8 | 0.8 | 0.8 | 0.7 | 0.6 | 0 | 0 | 0 | 0.6 | 0.7 | 0.8 | 0.8
Band Minimum Usage
(In Horsepower Hours)
Band Maximum Usage
Band Target/Baseline Usage
Band Minimum Usage
Gas Delivery / Nomination Examples
Actual Usage (In HP Hrs.) | 8500000 | 9800000 | 7000000 | 6650000 | 5500000 | 0 | 0 | 0 | 7100000 | 7500000 | 9300000 | 8250000
(In MMBTUs)
Standing Monthly Minimum Delivery
Excess Gas (True Up) Delivery (2 Month Lag) | 0 | 0 |  |  |  | 0 | 0 | 0 |  | 0
Total Monthly Nomination
Notes:
This schedule is intended to outline the gas volumetric true-up process only.  All spot vs. contract price variances (for falling outside the band) are outlined on the previous page.
1.  All gas will be delivered by TGP on a daily basis.
2.  Monthly minimum is always delivered by TGP even if usage is below the minimum load factor.
3.  MMBTUs in excess of monthly minimum are delivered two months later, in addition to current month's monthly minimum.
4.  April and May excess MMBTUs are delivered in the month of September, along with the September monthly minimum.
Spreadsheet: 731657d1620486509-v-lookup-based-on-different-sheets-using-data-validation-list-test-sheets-ans
Sheet: May 21

Enter 1st of Month Here -> | 2021-05-01 00:00:00 | CO | VO 1 | VO 2 | VO 3 | VO 4 | VO 5 | VO 6
 | Morning | a may | v1am a may | v2am a may | v3am a may | v4am a may | v5am a may | v6am a may
 | Afternoon |  | v1pm a may | v2pm a may | v3pm a may | v4pm a may | v5pm a may | v6pm a may
 | Morning | b may | v1am b may | v2am b may | v3am b may | v4am b may | v5am b may
 | Afternoon |  | v1pm b may | v2pm b may |  | v4pm b may | v5pm b may
 | Morning | c may | v1am c may | v2am c may | v3am c may | v4am c may | v5am c may | v6am c may
 | Afternoon |  | v1pm c may | v2pm c may | v3pm c may | v4pm c may | v5pm c may | v6pm c may
 | Morning | d may | v1am d may | v2am d may | v3am d may | v4am d may | v5am d may | v6am d may
 | Afternoon |  | v1pm d may | v2pm d may | v3pm d may | v4pm d may | v5pm d may | v6pm d may
 | Morning | e may | v1am e may | v2am e may | v3am e may | v4am e may | v5am e may | v6am e may
 | Afternoon |  | v1pm e may | v2pm e may | v3pm e may | v4pm e may | v5pm e may | v6pm e may
 | Morning | f may | v1am f may | [NAME] may | v3am f may | v4am f may | v5am f may | v6am f may
 | Afternoon |  | v1pm f may | v2pm f may | v3pm f may | v4pm f may | v5pm f may | v6pm f may
 | Morning | g may | v1am g may | v2am g may | v3am g may | v4am g may | v5am g may | v6am g may
 | Afternoon |  | v1pm g may | v2pm g may | v3pm g may | v4pm g may | v5pm g may | v6pm g may
 | Morning | h may | v1am h may | v2am h may | v3am h may | v4am h may | v5am h may | v6am h may
 | Afternoon |  | v1pm h may | v2pm h may | v3pm h may | v4pm h may | v5pm h may | v6pm h may
 | Morning | I may | v1am i may | v2am i may | v3am i may | v4am i may | v5am i may | v6am i may
 | Afternoon |  | v1pm i may | v2pm i may | v3pm i may | v4pm i may | v5pm i may | v6pm i may
 | Morning | j may | v1am j may | v2am j may | v3am j may | v4am j may | v5am j may | v6am j may
 | Afternoon |  | v1pm j may | v2pm j may | v3pm j may | v4pm j may | v5pm j may | v6pm j may
 | Morning | k may | v1am k may | [NAME] may | v3am k may | v4am k may | v5am k may | v6am k may
 | Afternoon |  | v1pm k may | v2pm k may | v3pm k may | v4pm k may | v5pm k may | v6pm k may
 | Morning | l may | v1am l may | v2am l may | v3am l may | v4am l may | v5am l may | v6am l may
 | Afternoon |  | v1pm l may | v2pm l may | v3pm l may | v4pm l may | v5pm l may | v6pm l may
Sat
Sun
Spreadsheet: 586122d1534210605-trying-to-create-a-simple-price-list-from-a-table-is-driving-me-nuts-help-needed-please-data-validation-cascading-dv-with-autocomplete
Sheet: Summary

 | Brand | Product | Price |  | [NAME] used for data validation in B2
 | Taunton Cider Company | Money |  |  | =OFFSET(Data!$F$1,MATCH(LEFT(B2,LEN(B2)),LEFT(Brands,LEN(B2)),0),0,SUMPRODUCT(--(LEFT(Brands,LEN(B2))=B2)),1)
 | ALDOUS | Home Net/Wk Cab Lrg
 | Ciderboys | Hair Tie |  |  | Type at least one letter in the validation list, then click the validationarrow.
 | 3D FURY | 3D Fury Hdmi-Comp
 | [NAME] | Con4 Lg Smart Tv |  |  | [NAME] used in Product Data Validation - C2
 | [NAME] | Button |  |  | Named range "Product"
 |  |  |  |  | =OFFSET(Data!$A$1,MATCH(Summary!B2,Data!$A$2:$A$94,0),1,COUNTIF(Data!$A$2:$A$94,Summary!B2),1)
 |  |  |  |  | [NAME] used in D2
 |  |  |  |  | =IFERROR(LOOKUP(2,1/(Data!$A$2:$A$94=Summary!B2)/(Data!$B$2:$B$94=Summary!C2),(Data!$C$2:$C$94)),"")
 |  |  |  |  | 2 way lookup
 |  |  |  |  | Named [NAME] formulas
 |  |  |  |  | Brand | Refers to Table "Data!F2:F67" |  | Table used so it is dynamic so the formula to determine the length in brands is contained
 |  |  |  |  | Brands | =INDIRECT("Data!$F$2:$F$"&COUNTA(Brand)-COUNTBLANK(Brand)+1) |  | used for the main truncation DV
 |  |  |  |  | Brandlist | =Data!$A$1:$A$94 |  | Used to make unique list in Column F of data
 |  |  |  |  | Pricelist | Refers to Table "Data!A1:C94
 |  |  |  |  | Product | =OFFSET(Data!$A$1,MATCH(Summary!E21,Data!$A$2:$A$94,0),1,COUNTIF(Data!$A$2:$A$94,Summary!E21),1) |  | Used for Product DV
 |  |  |  |  |  | This formula changes depending on which cell you select at time of reading named range above shown is when you click row 21
Spreadsheet: 739174d1625567038-formula-to-state-availability-in-colunn-e-item-listing
Sheet: Availability

 | Item listing
 | Label | Item |  | Availability
 | 1 | Rivet set B1
 | 2 | Rivets set B2
 | 3 | Bosch 10.8V set1
 | 4 | Bosch 10.8V set2
 | 5 | Bosch 10.8V set3
 | 6 | [NAME] set
 | 7 | [NAME]
 | 8 | Stanley sortmaster
 | 9 | Hitachi jigsaw Fcj55
 | 10 | Crimper connector
 | 11 | Stanley Stel345
 | 12 | MD2000 manual dispenser
 | 13 | Metabo SBE 520
 | 14 | Titanuim organizer
 | 15 | Black decker
 | 16 | Bosch jigsaw GST65
 | 17 | DewaLT drill set
 | 18 | Bosch grinder
 | 19 | Mini drill set
 | 20 | Tool box C
 | 21 | Tool box C1
 | 22 | Tool box C2
 | 23 | Fluke power analyser
 | 24 | Vertex standard wakie talkie(pair)
 | 25 | Impedance meter
 | 26 | Light meter
 | 27 | Sound meter
 | 28 | Vernier caliper
 | 29 | Ldm-500 distant laser
 | 30 | Fiber tester
 | 31 | Power tape
 | 32 | Maktec saw
Spreadsheet: 144141d1330720734-coping-data-from-one-sheet-to-other-related-sheets-tenderfoot
Sheet: Players

1 | [NAME] | [NAME]
2 | [NAME] | [NAME]
3 | [NAME] | [NAME]
4 | [NAME] | J.M.T
5 | Theresa Lynes | J.M.T
6 | [NAME] | J.M.T
7 | [NAME] | [NAME]
8 | [NAME] | [NAME]
9 | [NAME] | [NAME]
10 | [NAME] | Way To Go
11 | [NAME] | Way To Go
12 | [NAME] | Way To Go
13 | [NAME] | No Idea
14 | [NAME] | No Idea
15 | [NAME] | No Idea
16 | [NAME] | [NAME]
17 | [NAME] | [NAME]
18 | [NAME] | [NAME]
19 | [NAME] | Nofolk'n'Chance
20 | [NAME] | Nofolk'n'Chance
21 | [NAME] | Nofolk'n'Chance
22 | [NAME] | Cunning Stunts
23 | [NAME] | Cunning Stunts
24 | [NAME] | Cunning Stunts