tianzl66/Sheetpedia huggingface dataset:
Spreadsheet: 217491d1362081764-excel-formula-for-skipping-sundays-excel-forum-ror
Sheet: Edited Data

 |  |  |  |  |  |  |  |  |  |  |  |  |  |  | Date NRTC signed | Proper 3-day Rescission / Midnight Date | Proper 3-Day Rescission / Midnight Date
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 2012-09-03 00:00:00
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 2012-09-04 00:00:00
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 2012-09-05 00:00:00
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 2012-09-06 00:00:00
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 2012-09-07 00:00:00 |  |  | Proper 3 day Right of Rescission date should 9/11/12
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 2012-09-10 00:00:00
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 2012-09-11 00:00:00
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 2012-09-13 00:00:00 |  |  |  |  |  |  |  |  |  |  | 2012-12-31 00:00:00
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 2012-09-14 00:00:00 |  |  | Proper 3 day Right of Rescission date should 9/18/12 |  |  |  |  |  |  |  | 2013-01-01 00:00:00
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 2013-01-21 00:00:00
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 2013-02-18 00:00:00
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 2013-05-27 00:00:00
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 2013-07-04 00:00:00
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 2013-09-02 00:00:00
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 2013-10-14 00:00:00
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 2013-11-11 00:00:00
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 2013-11-28 00:00:00
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 2013-12-25 00:00:00
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 2012-11-22 00:00:00
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 2012-11-23 00:00:00
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 2012-12-25 00:00:00
Spreadsheet: daren_farmer__5731__HPLN0221
Sheet: Sheet1

HPLN0221.XLS |  | Fax # [PHONE]
TO:  DARREN FARMER / ENRON;  CARY METZ / ENRON;  [NAME] / HPL;  LIZ BELLAMY / ENRON
FROM:  MELISSA JONES - TXU ELECTRIC & GAS  (TU ELECTRIC)
 |  |  |  |  |  | REVISED
SUBJECT:  TXU FUELS NOMINATION - February 21, 2001
 |  |  |  |  |  | **Wednesday
HPL AND ENRON NOMINATIONS: |  |  |  |  |  | 2001-02-21 00:00:00
 |  |  |  |  |  | Eff. 0900 hrs.
 |  |  |  |  | PRIOR | NOMINATED
CONTRACT |  | DELIVERY POINT |  | Upstream
 |  | Firm Summary
Enron K#3959 |  | Oasis Sealy  (purchased for same day delivery) |  |  | 20 | 0 | *
 |  | Enron North America Spot/3959
OTHER ENRON/HPL TRANSPORTS: |  |  |  | Downstream
 |  | Total Other Transports:
NOTE:  Additional swing volumes may be requested at Teco Tap, or Texoma by TUFCO Gas Control under either the
Wagner Brown K# 1901 or HPL K# 3949 agreements.
*  Nominations to continue until TU Electric changes such nominations.
CC:   [NAME] | [NAME]
R. Skerik | [NAME]
G. Green | K. English
B. Fleming | GCC Dispatcher
Spreadsheet: 32562d1228760175-if-function-and-conditional-formatting-book-5
Sheet: Sheet1

DATE | INVOICE NUMBER | CONSIGNMENT  NUMBER | GROSS VALUE | NUMBER OF BOOKS | BBJ INVOICE NUMBER | COMMISION FOR BOOKS | NORMAL COMMISION | TOTAL  COMMISION DUE | COMMISION PAID | STATUS
24-09-2007 | 1334 | 54 | 6744 | 0 |  | R0 | 1825.938 | 1825.938 | 1825.94
18-10-2007 | 1347 | 65A | 3024 | 0 |  | R0 | 818.748 | 818.748
04-12-2007 | 1374 | 85 | 5400 | 0 |  | R0 | 1462.05 | 1462.05
04-12-2007 | 1375 | 86 | 4428 | 0 |  | R0 | 1198.881 | 1198.881
04-01-2008 | 1387 | 105 | 768 | 0 |  | R0 | 207.936 | 207.936
04-01-2008 | 1388 | 106 | 2172 | 0 |  | R0 | 588.0690000000001 | 588.0690000000001
04-01-2008 | 1385 | 107 | 3576 | 0 |  | R0 | 968.202 | 968.202
04-01-2008 | 1386 | 108 | 3636 | 0 |  | R0 | 984.447 | 984.447
04-02-2008 | 1394 | 112 | 1188 | 0 |  | R0 | 321.651 | 321.651
04-02-2008 | 1396 | 111 |  | 0 |  | R0
12-02-2008 | 1400 | 114 |  | 0 |  | R0
12-02-2008 | 1401 | 117 |  | 0 |  | R0
10-03-2008 | 1411 | 119 |  | 0 |  | R0
10-03-2008 | 1410 | 120 |  | 0 |  | R0
22-03-2008 | 1412 | 122 |  | 0 |  | R0
22-03-2008 | 1415 | 123 |  | 0 |  | R0
22-03-2008 | 1416 | 124 |  | 0 |  | R0
15-04-2008 | 1425 | 135 |  | 0 |  | R0
15-04-2008 | 1426 | 136 |  | 0 |  | R0
17-04-2008 | 1427 | 137 |  | 0 |  | R0
16-04-2008 | 1428 | 138 |  | 0 |  | R0
16-04-2008 | 1429 | 139 |  | 0 |  | R0
Spreadsheet: 215108d1361267238-entire-row-auto-copied-into-another-datasheet-if-a-value-in-a-particular-cell-is-yes-example-for-excel-forum
Sheet: User Form Request

 |  |  |  |  |  |  |  |  |  | Yes
 |  |  |  |  |  |  |  |  |  | No
 | Login | Full name | First name | Last name | E-mail | 3) Should the user have access to ‘Future’/’Embargo’ material | 5) Would the user need to have access to the Adaptation Tool? (The templating module) | 6) Would the user need to have access to the Planning Tool? | 7.) Is the User included in the Copy Approvals Process?
Example | [NAME] | [NAME] | [NAME] | Smith | [EMAIL] | No | No | No | No
Spreadsheet: 84537d1284583326-filter-list-on-new-sheet-based-on-due-dates-deliveries_testsheet-1-
Sheet: CLIENTS

CLIENT NAME | ACCOUNT # | SUPPLY  # | PLANT SIZE | PLANT TYPE | SILO  SIZE | No. OF COWS | REP | REGION
Client 1 | 10012 | 30001 | 50 | Milfos | 25100 |  | GB
Client 2 | 10013 | 30002 | 50 | DeLaval | 52000 | 750 | GB
Client 3 | 10014 | 30003 | 45 | DeLaval | 7000 | 300 | GB
Client 4 | 10015 | 30004 | 65 | AlfaLaval | 7000 | 220 | GB
Client 5 | 10016 | 30005 | 54 | DeLaval | 16000 | 500 | GB
Spreadsheet: darrell_schoolcraft__7808__imbalsumm0108
Sheet: williams

 | Milagro |  | La Maquina |  | [NAME] |  | [NAME]
Day | Measured | Scheduled | Measured | Scheduled | Measured | Scheduled | Measured | Scheduled |  |  |  |  |  |  |  | San Juan
1 | 320046 | 326630 | 68213 | 62006 | 60282 | 67308 | 134575 | 120400 |  |  |  | Month | Measured | Scheduled | Imbalance | Index | Amount
2 | 322443 | 342258 | 80613 | 62006 | 65523 | 61458 | 114858 | 123670
3 | 339003 | 356730 | 65345 | 62006 | 62518 | 57038 | 133408 | 135294 |  |  |  | 2000-12-01 00:00:00 | 19698194 | 19662410 |  | 7.95
4 | 330189 | 334992 | 71515 | 62006 | 68003 | 60854 | 121528 | 122443 |  |  |  | 2001-01-01 00:00:00 | 18949781 | 18975457 |  | 8.1
5 | 325424 | 357543 | 76506 | 45334 | 60101 | 61458 | 122124 | 116046 |  |  |  | 2001-02-01 00:00:00 | 15193330 | 15256233 |  | 5.61
6 | 338716 | 363512 | 73883 | 62006 | 63277 | 61458 | 128438 | 126142 |  |  |  | 2001-03-01 00:00:00 | 17049350 | 17089226 |  | 4.87
7 | 307409 | 329009 | 81561 | 62006 | 61385 | 66177 | 128949 | 116696 |  |  |  | 2001-04-01 00:00:00 | 17652369 | 17743987 |  | 4.62
8 | 335665 | 339813 | 69904 | 62006 | 64156 | 66309 | 123188 | 131814 |  |  |  | 2001-05-01 00:00:00 | 16124989 | 16282021 |  | 3.44
9 | 339468 | 343257 | 62256 | 62006 | 68558 | 62714 | 133641 | 126893 |  |  |  | 2001-06-01 00:00:00 | 15928675 | 15936227 |  | 2.45
10 | 325004 | 326102 | 61460 | 62006 | 56382 | 53686 | 141587 | 135180 |  |  |  | 2001-07-01 00:00:00 | 16669639 | 16693576 |  | 2.45
11 | 348691 | 329322 | 39888 | 62006 | 62036 | 61116 | 154963 | 154094
12 | 343074 | 331485 | 41056 | 62006 | 63625 | 61306 | 145898 | 141767
13 | 329776 | 327012 | 46642 | 59179 | 62952 | 61308 | 138478 | 126232
14 | 326625 | 336221 | 37103 | 26877 | 56806 | 58064 | 133830 | 131396
15 | 336681 | 332244 | 61849 | 62006 | 56541 | 57130 | 149355 | 149369
16 | 330403 | 330339 | 63183 | 62006 | 56691 | 58312 | 153223 | 151210
17 | 334818 | 346212 | 81572 | 62006 | 63376 | 65126 | 135420 | 142145
18 | 366455 | 357416 | 64878 | 62006 | 59007 | 58705 | 125144 | 131878
19 | 297258 | 320201 | 63849 | 62006 | 57721 | 60383 | 126422 | 129766
20 | 322632 | 322211 | 62973 | 62006 | 57755 | 56963 | 119641 | 119045
21 | 338791 | 340947 | 64404 | 60467 | 52773 | 50154 | 128561 | 132981
22 | 322113 | 321612 | 62032 | 62005 | 59462 | 53971 | 124463 | 122727
23 | 317311 | 313150 | 62012 | 60837 | 54209 | 52721 | 140828 | 137994
24
25
26
27
28
29
30
31
2001-07-31 00:00:00 |  |  |  |  |  |  |  |  | 310268
2001-08-23 00:00:00
CBS Dollars
 |  |  | 1379269.57
 |  |  | 300359.04
 |  |  | -250735.54
 |  |  | 44931.54
 |  |  | 2153062.32
 |  |  | 0.0238
 |  |  | 0.0153
Spreadsheet: 860956d1708967018-average-eoy-headcount-based-off-projected-gains-and-losses-average-eoy-fte-based-off-projected-gains-and-losses
Sheet: Sheet1

 |  |  |  |  |  | 1 | 2 | 3 | 4 | 5 | 6 | 7 | 8 | 9 | 10 | 11 | 12
 |  |  |  |  |  | Oct | Nov | Dec | Jan | Feb | Mar | Apr | May | Jun | Jul | Aug | Sep | Average
 |  |  |  |  | Start of FY | 10 | 10 | 10 | 10 | 10 | 10 | 10 | 10 | 10 | 10 | 10 | 10
 |  |  |  |  | Gain 1 | 0 | 0 | 0 | 0 | 1 | 1 | 1 | 1 | 1 | 1 | 1 | 1
 |  |  |  |  | Gain 2 | 0 | 0 | 0 | 0 | 0 | 0 | 1 | 1 | 1 | 1 | 1 | 1
 |  |  |  |  | Loss 1 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | -1 | -1 | -1 | -1 | -1
 |  |  |  |  | Actuals | 10 | 10 | 10 | 10 | 11 | 11 | 12 | 11 | 11 | 11 | 11 | 11
 |  |  |  |  | average to date
 |  |  |  |  | prior month plus updated average |  |  |  |  | 10.66666666666667 | 10.78333333333333 | 10.75 | 10.90476190476191 | 10.875 | 10.83333333333333 | 10.7833333333333 | 10.72727272727273
 |  |  |  |  | current month plus updated average |  |  |  |  | 10.86666666666667 | 10.91666666666667 | 10.98809523809524 | 10.95833333333333 | 10.91666666666667 | 10.86666666666667 | 10.81060606060606 | 10.75
 |  |  |  |  | average between the two
Spreadsheet: susan_bailey__39375__nevadapower
Sheet: Expired

DEAL # | EOL # | COUNTERPARTY | DEAL DATE | FLOW START | FLOW END | PRICE | VOLUME | TRADER | DELIVERY POINT | DEAL TYPE | CATEGORY | BUY/SALE | PHYSICAL/FINANCIAL | FIRMNESS
427635.1 |  | Nevada Power Company | 2000-10-04 00:00:00 | 2001-01-01 00:00:00 | 2001-12-31 00:00:00 | 82 | 418800 | [NAME]  Motley | Mead-230KV | FORWARD | CMDTY | S | P | Firm
427636.1 |  | Nevada Power Company | 2000-10-04 00:00:00 | 2001-01-01 00:00:00 | 2001-12-31 00:00:00 | 69 | 438000 | [NAME]  Motley | PALO VERDE | FORWARD | CMDTY | B | P | Firm
427886.1 |  | Nevada Power Company | 2000-10-04 00:00:00 | 2001-01-01 00:00:00 | 2001-12-31 00:00:00 | 70.5 | 876000 | [NAME]  Motley | PALO VERDE | FORWARD | CMDTY | B | P | Firm
427887.1 |  | Nevada Power Company | 2000-10-04 00:00:00 | 2001-01-01 00:00:00 | 2001-12-31 00:00:00 | 82 | 837600 | [NAME]  Motley | Mead-230KV | FORWARD | CMDTY | S | P | Firm
430865.1 |  | Nevada Power Company | 2000-10-09 00:00:00 | 2001-01-01 00:00:00 | 2001-12-31 00:00:00 | 44 | 96200 | [NAME] | PALO VERDE | FORWARD | CMDTY | S | P | Firm
469369.1 |  | Nevada Power Company | 2000-11-29 00:00:00 | 2001-10-01 00:00:00 | 2001-12-31 00:00:00 | 92 | 61600 | [NAME] | PALO VERDE | FORWARD | CMDTY | S | P | Firm
474431.1 |  | Nevada Power Company | 2000-12-05 00:00:00 | 2001-01-01 00:00:00 | 2001-12-31 00:00:00 | 250 | 245600 | [NAME]  Motley | PALO VERDE | FORWARD | CMDTY | S | P | Firm
483735.1 |  | Nevada Power Company | 2000-12-20 00:00:00 | 2001-01-01 00:00:00 | 2001-12-31 00:00:00 | 105 | 96200 | [NAME]  Motley | PALO VERDE | FORWARD | CMDTY | S | P | Firm
881984.1 |  | Nevada Power Company | 2001-11-28 00:00:00 | 2001-11-29 00:00:00 | 2001-11-29 00:00:00 | 3.48 | 366 | Les  Rawson | Mead-230KV | FORWARD | TRANS | B | P | Firm
894686.1 |  | Nevada Power Company | 2002-01-02 00:00:00 | 2001-11-30 00:00:00 | 2001-11-30 00:00:00 | 224.39 | 1 | [NAME] | Mead [NAME] | FORWARD | TRANS | B | P | Firm
Spreadsheet: 330560d1404801751-generate-combinations-of-multiple-columns-combinations
Sheet: Sheet1

Manager | Action A | From Side Menu
Supervisor | Action B | From Top Menu
Employee | Action C | From Top Middle
Spreadsheet: 29868d1225082196-merging-two-worksheets-into-one-example
Sheet: Master Donor List Example

Title (Mr., Mrs. [NAME]) | FirstName | LastName | SpouseFirst | SpouseLast | Company | [NAME] | Phone | Address | City | Country | State | ZipCode | Preferred Contact | Donation | PaymentMethod | DateofDonation | Recurring Donor | Tax Deductible | ThankYouNoteSent | Organization | [NAME] | Notes
Mr. | [NAME] | Doe | [NAME] | Doe |  | [EMAIL] | 1112223333 | 1113 Doe Pl | Syracuse | USA | NY | 13210 |  | 100 | Check | 2008-10-25 00:00:00 | No | Yes | Yes |  | No
Ms. | [NAME] | Kent |  |  |  | [EMAIL] | 222222222 | 1111 Doe Pl. | New York | USA | NY | 112233 |  | 50 | Online | 2008-10-26 00:00:00 | No | No | No |  | No
Mr. | Peanut | MM |  |  |  | [EMAIL] | 4444444 | 4411 [NAME] | Los Angeles | USA | CA | 91321
Spreadsheet: 219591d1362801008-conditional-sum-excel-2010-drop-down-lists-2013-planting
Sheet: seed

 |  | PURCHASE |  |  |  |  |  | USED
# | seed | dennis | justin | jay | ron | total | Column2 | dennis2 | [NAME] | jay2 | ron2 | total3 | [NAME] | ron27 | ron22 | ron23 | ron24 | ron3 | total2
1 | 1151 AM |  |  | 9 | 9
2 | 1324 HR | 32 |  |  | 16
3 | 1498 HR | 48 |  |  | 32
4 | 1508 CHR | 32 | 32 |  | 30
5 | 1625 CHR |  |  |  | 30
6 | 1690 HR | 48
7 | 33D42 | 64 |  |  | 32
8 | 33D47 | 32 | 32 | 15 | 44
9 | 92y70 |  |  | 100
10 | 92y83 |  |  |  | 100
11 | DK 63-87 |  | 16
12 | DK 66-87 |  | 16
13
14
15
16
17
18
19
Spreadsheet: 697882d1601581198-counting-occurrences-and-sums-based-on-an-id-sample2
Sheet: Sheet5

ID: | Field1 | Field2 | Field3 | Aggregated Count: | Number of:
1155626 | Audit | A | 50 |  | 1
1155626 | Interim | A | 83 |  | 1
1155626 | Final | A | 96849 |  | 1
1155626 | Final | A | 96849 |  | 1
1155626 | Audit | A | 50 |  | 1
1155626 | Audit | A | 50 |  | 1
1155626 | Interim | B | 74 |  | 1
1155626 | Final | A | 586543 |  | 1
1155626 | Final | A | 586543 |  | 1
1155626 | Audit | C | 50 |  | 1
1158662 | Interim | B | 5 |  | 4
1158662 | Interim | A | 5 |  | 4
1158662 | Final | D | 33325 |  | 4
1158662 | Interim | B | 5 |  | 4
1158662 | Final | F | 0 |  | 4
1158662 | Interim | B | 5 |  | 4
1158662 | Interim | B | 10 |  | 4
1158662 | Interim | A | 5 |  | 2
12493 | Interim | B |  |  | 2
12493 | Interim | A | 5 |  | 2
12493 | Final | D | 33325 |  | 2
12493 | Interim | B |  |  | 2
9393 | Final | B | 3202 |  | 0
9393 | Final | A | 5 |  | 0
9393 | Final | D | 33325 |  | 0
9393 | Final | B | 20023 |  | 0
8393 | Interim | B | 50000 |  | 1
8393 | Interim | C | 100000 |  | 1
8393 | Final | D | 20000 |  | 1
8393 | Final | B | 20000 |  | 1
Spreadsheet: 721372d1614680906-retrieve-info-considering-several-columns-and-apply-color-code-tracker
Sheet: Results

 |  |  |  |  |  |  |  |  |  | Not started
 |  |  |  |  |  |  |  |  |  | in progress |  |  |  | Do not touch
 |  | Control | RE0142 | RE0110 | RE0010 | RE0141 | RE0143 | RE0120
Spreadsheet: 119934d1314873134-sumif-or-vlookup-on-multiple-partial-strings-partial-string-formula-for-multiple-codes
Sheet: Sheet1

 | Staff Costs | Direct Costs
TMOL.0001.01 | 10000 | 47000
TMOL.0001.02 | 20000 | 23000
TMOL.0001.03 | 30000 | 20000
TMOL.0001.04 | 40000 | 3000
TMOL.0002.01.01 | 18000 | 5000
TMOL.0002.01.02 | 17000 | 5000
TPRJ.0016.01.01 | 68000 | 28000
TPRJ.0016.01.02 | 63000 | 2000
TDLS.0005.01 | 80000 | 45000
TDLS.0017.01 | 7000 | 3000
 |  | TMOL.0001 | TMOL.0002 | TPRJ | TDLS
Actual | Staff Costs | 0 | 0 | 0 | 0
Budget | Revenue | 0 | 0 | 0 | 0
[NAME] | Revenue | 0 | 0 | 0 | 0
Actual | Direct Costs | 0 | 0 | 0 | 0
Budget | Staff cost | 0 | 0 | 0 | 0
[NAME] | Staff cost | 0 | 0 | 0 | 0
Spreadsheet: 876913d1723634356-vlookup-looking-at-a-cell-with-formula-formula-help
Sheet: Sheet1

 |  |  |  |  |  |  |  |  | Annual Salary List | Is The [NAME] equal or more than |  |  | Monthly | 4500
 |  |  |  |  |  |  |  |  | 20000 |  |  |  | Salary
 |  |  |  |  |  |  |  |  | 25000
 |  |  |  |  |  |  |  |  | 30000
 |  |  |  |  |  |  |  |  | 35000
 |  |  |  |  |  |  |  |  | 40000
 |  |  |  |  |  |  |  |  | 45000
 |  |  |  |  |  |  |  |  | 50000
 |  |  |  |  |  |  |  |  | 55000
 |  |  |  |  |  |  |  |  | 60000
 |  |  |  |  |  |  |  |  | 65000
 |  |  |  |  |  |  |  |  | 70000
 |  |  |  |  |  |  |  |  | 75000
 |  |  |  |  |  |  |  |  | 80000
 |  |  |  |  |  |  |  |  | 85000
 |  |  |  |  |  |  |  |  | 90000
 |  |  |  |  |  |  |  |  | 95000
 |  |  |  |  |  |  |  |  | 100000
 |  |  |  |  |  |  |  |  | 105000
 |  |  |  |  |  |  |  |  | 110000
 |  |  |  |  |  |  |  |  | 115000
 |  |  |  |  |  |  |  |  | 120000
 |  |  |  |  |  |  |  |  | 125000
 |  |  |  |  |  |  |  |  | 130000
 |  |  |  |  |  |  |  |  | 135000
 |  |  |  |  |  |  |  |  | Actual salary | Is the actual salary on the list? Yes/No
 |  |  |  |  |  |  |  |  |  | ????? | What formula could I use to put yes or no here?
Spreadsheet: 26bc75c7-8788-48ad-89c3-b7342e3c2e2a
Sheet: Sheet1

2014 Buckskin Scout Reservation Fee Worksheet
Eat In Camp Site Only* Unit Provides all of its own food and ice for the week
Leader's Name |  |  | Leader's Telephone Number
TROOP NUMBER |  |  | CAMPSITE |  |  |  | WEEK
FEES
 |  |  |  |  |  | Number | Fee | Total
Number of Boys Registered Prior to May 15th |  |  |  |  |  |  | 135
Number of Boys Registered After May  15th |  |  |  |  |  |  | 140
Number of AWV Participants Registered  prior to May 15th |  |  |  |  |  |  | 365
Number of AWV Participants Registered After May 15th |  |  |  |  |  |  | 390
Youth and Adult Summit Participants Registered before May 15th |  |  |  |  |  |  | 465
Number of Free Adult Leaders |  |  |  |  |  |  | 0
Number of Adult Leaders Paid Before May 15th |  |  |  |  |  |  | 15
Number 0f Adult Leaders Paid After May 15th |  |  |  |  |  |  | 15
Number of Cots |  |  |  |  |  |  | 10
 |  |  |  |  |  | Total Fees Due
DEDUCTIONS
 |  |  |  |  |  | Number | Amount | Total
In Council Scout Discount |  |  |  |  |  |  | 10
Summit High Adventure provide own transportation discount |  |  |  |  |  |  | 40
Number of Brother Discounts |  |  |  |  |  |  | 30
Scholarship 1 | Name |  |  |  |  | 1
Scholarship 2 | Name |  |  |  |  | 1
Scholarship 3 | Name |  |  |  |  | 1
Scholarship 4 | Name |  |  |  |  | 1
Scholarship 5 | Name |  |  |  |  | 1
Scholarship 6 | Name |  |  |  |  | 1
Previous Payments (Site Reservation Fee) |  |  |  |  |  | 1
Other Previous Payments |  |  |  |  |  | 1
 |  |  |  |  |  | Total Deductions
 |  |  |  |  |  | TOTAL DUE
PAYMENTS
Date | Amount | Receipt # | Notes
 |  |  |  |  | TOTAL PAYMENTS
Spreadsheet: 105235d1302652656-hlookup-using-data-in-multiple-columns-hlookup-problem
Sheet: Sheet1

SMITH |  |  |  | JONES |  |  |  | BROWN
1 | 2 | 3 | 4 | 5 | 6 | 7 | 8 | 9 | 10 | 11 | 12
GP | G | A | PIM | GP | G | A | PIM | GP | G | A | PIM
1 |  | 2 | 2 | 1 |  | 2 | 6 | 1 | 1 |  | 2
1 | 1 | 1 |  | 1 |  |  |  | 1 |  | 1
1 |  |  | 4 | 1 |  |  | 8
1 | 2 |  |  | 1 |  | 2 | 5
1 | 1 | 1 |  | 1 | 1 | 1 |  | 1 | 1 | 1 | 2
1 |  |  |  | 1 |  |  |  | 1
1 |  | 2 | 4 | 1 |  |  | 9
 |  |  |  | 1 |  | 1 |  | 1 | 1 | 2
 |  |  |  | 1 | 1 |  |  | 1
1 | 1 |  | 2 | 1 |  | 2 | 2 | 1 | 1 |  | 2
1 |  | 3 |  | 1 |  |  |  | 1 |  | 2
 |  | GP | G | A | Pts | PIM
Smith |  | 9 | 5 | 9 | 14 | 12
Jones |  | 11 | 2 | 8 | 10 | 30
[NAME] |  | 8 | 4 | 6 | 10 | 6
Spreadsheet: 35765d1233384971-interpolate-non-integer-values-in-a-look-up-table-interpolation
Sheet: Sheet1

 | y (rpm)
x | 12200 | 13000 | 15010
34 | 54 | 34 | 35.54
35 | 56 | 32.43 | 65.543
76.9976 | 76.6798 | 43.43 | 43.432
85.78 | 83.653 | 42.432 | 67.543
99.7897 | 78.678 | 482.4323 | 43.432
Interpolate:
x | rpm | y
86.44 | 14543 | 65.65281225861737
Helper Values: (do not delete them)
 | 83.41862667294804 | 63.16050938992248 | 66.40712557014072
85.78 | 83.653 | 42.432 | 67.543
99.7897 | 78.678 | 482.4323 | 43.432
 | 13000 | 15010
 | 63.16050938992248 | 66.40712557014072
Spreadsheet: 828813d1683739334-nested-xlookup-formula-returns-value-error-copyplantmeasurements2023-v3-mo
Sheet: GrowthChart1

Company1-Cust3-'Red'-10-3PP-PW33 |  |  |  |  | <-Select crop from the drop-down menu
Plant Week
Pinch Week |  |  | Min Ht
Sell Week |  |  | [NAME]
Pot Size (in) |  |  | Curve | Standard | <-Select standard or late curve from the drop-down menu
Weeks After Pinch | Calendar Week | Avg Ht | Min Ht | [NAME] | Avg Ht for Company1-Cust3-'Red'-10-3PP-PW33 (should be) | When Company1-Cust3-'Red'-10-3PP-PW33 is selected in the drop down menu at the top, [NAME] should be 8.1, 8.7, 8.4.
 |  |  |  |  | 8.1 | I filtered the results on the Measurement tab for this specific crop.
1 |  |  |  |  | 8.7 | If you select other crops from the drop-down menu, you can see that the Avg Ht populates correctly.
2 |  |  |  |  | 8.4 | But when the Calendar week is a decimal point, the Avg Ht cells are blank.
3
4
5
6
7
8
9
10
11
Spreadsheet: 680948d1591274289-convert-date-text-inside-a-cell-into-date-type-inside-a-function-deadline-tracker-ex
Sheet: Deadline tracker

Deadline tracker
PROJECT/DOCUMENT | [NAME] (RESP.WITH THE TASK) | DEPARTMENT | START DATE | DUE DATE | DAYS REMAINING | STATUS | NOTES
test | test | test |  |  |  | In Progress | test
test | test | I want to make this possible - > | 2020-05-04 00:00:00 | 20/06/2020 |  | <- Formula not working | test
test | test | test |  |  |  | In Progress | test
test | test | test |  |  |  | In Progress | test
test | test | test |  |  |  | Due Today | test
test | test | test | 2020-05-06 00:00:00 |  |  | In Progress | test
test | test | test | 2020-05-04 00:00:00 |  |  | In Progress | test
test | test | test
test | test
test | test | test
test | test | test
test | test | test
test | test | test
test | test | test
test | test | test
test | test | test
test | test | test
test | test | test
test | test | test
test | test | test
test | test | test
test | test | test
test | test | test
test | test | test |  |  |  |  | test
test | test | test
test | test | test
test
test
test
test
test
test
test
test
test
v
Spreadsheet: 123917d1317925920-combine-data-from-multiple-rows-test
Sheet: Trade Calculator

Combined Trade Details
 | Symbol | Side | Shares | Avg. Price | Commision | Exchange | Execution Time | Trade Name | Notional | Notional Commision Adj. | [NAME]. [NAME].
1 | MSFT | BOT | 1895 | 26.39500263852243 | 9.48 | ISLAND | 14:24:23 | MSFT | 50018.53 | 50028.01 | 26.40000527704485
2 | IBM | BOT | 276 | 181.125 | 2 | ISLAND | 14:24:23 | IBM | 49990.5 | 49992.5 | 181.1322463768116
3 | XLY | SLD | 1379 | 36.24000725163162 | 6.9 | ISLAND | 14:24:23 | XLY | 49974.97 | 49981.87 | 36.24501087744743
4 | XRT | SLD | 1032 | 48.42 | 5.16 | ISLAND | 14:24:32 | XRT | 49969.44 | 49974.60000000001 | 48.425
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
Input Target Symbols
 | Symbol | Side | Shares | Avg. Price | Commision | Exchange | Execution Time | Trade Name | Notional | Notional Commision Adj. | [NAME]. [NAME].
1 | MSFT
2 | IBM
3
4
5
6
7
8
9
10
Input Basket Symbols
 | Symbol | Side | Shares | Avg. Price | Commision | Exchange | Execution Time | Trade Name | Notional | Notional Commision Adj. | [NAME]. [NAME].
1 | XLY
2 | XRT
3
4
5
6
7
8
9
10
11
12
13
14
15
16
17
18
19
20
 | Symbol | Side | Shares | Avg. Price | Commision | Exchange | Execution Time | Trade Name
 | IBM | BOT | 138 | 181.12 | 1 | ISLAND | 14:24:23 | MSFT 10_06_11.csv
 | XLY | SLD | 690 | 36.25 | 3.45 | ISLAND | 14:24:23 | MSFT 10_06_11.csv
 | MSFT | BOT | 948 | 26.4 | 4.74 | ISLAND | 14:24:23 | MSFT 10_06_11.csv
+ | XRT | SLD | 516 | 48.43 | 2.58 | ISLAND | 14:24:32 | MSFT 10_06_11.csv
+ | IBM | BOT | 138 | 181.13 | 1 | ISLAND | 14:24:41 | MSFT 10_06_11.csv
 | XRT | SLD | 516 | 48.41 | 2.58 | ISLAND | 14:24:41 | MSFT 10_06_11.csv
+ | XLY | SLD | 689 | 36.23 | 3.45 | ISLAND | 14:24:41 | MSFT 10_06_11.csv
 | MSFT | BOT | 947 | 26.39 | 4.74 | ISLAND | 14:24:41 | MSFT 10_06_11.csv