tianzl66/Sheetpedia huggingface dataset:
Spreadsheet: mark_taylor__24728__ClickInTradingProducts
Sheet: Coal

Coal
Short Description Boxes: |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | FOR OPTIONS
Coal Physical |  | Specifications |  | Location |  | Term |  | Year |  | Currency |  | Units |  | Option Type |  | Option Strike |  | Expiration Date
Physical Delivery |  | Steam Coal 1 |  | ARA (CIF) |  | Q1 |  | 1999 |  | USD |  | mt |  | Call
Option on Physical Delivery |  | Steam Coal 2 |  |  |  | Q2 |  | 2000 |  | GBP |  |  |  | Put
 |  | Steam Coal 3 |  |  |  | Q3 |  |  |  | EUR |  |  |  | Quartely Calls
 |  | Reject Specifications |  |  |  | Q4 |  |  |  |  |  |  |  | Quartely Puts
Notes: | Physical only trading and non-standardised deals => not for Internet trading for another 6 mth-1year.
Long Descriptions
Instrument Type | Physical Delivery |  | An agreement whereby a physical volume is exchanged  for a fixed price over a specified period
 | Call Option on Physical Delivery |  | An agreement whereby the buyer (the holder) has the right but not the obligation to buy the underlying commodity for a specified price on a specified exercise date in exchange for a premium payment
 | Put Option on Physical Delivery |  | An agreement whereby the buyer (the holder) has the right but not the obligation to sell the underlying commodity for a specified price on a specified exercise date in exchange for a premium payment
Specifications | Steam Coal 1 | NCV 6,000 kcal/kg |  | -- Calorific value, net as received
 |  | [NAME]  [1]% |  | -- Percent by weight of [NAME], dry
 |  | [NAME] [14.5]% |  | -- Percent by weight of Ash, dry
 |  | [NAME] [5-8]% |  | -- Percent by weight of Moisture, as received
 | Reject Specifications
 |  | NCV <5,500 kcal/kg |  | -- Calorific value, net as received
 |  | [NAME]1% |  | -- Percent by weight of [NAME], dry
 |  | [NAME]20% |  | -- Percent by weight of Ash, dry
 |  | [NAME]10% |  | -- Percent by weight of Moisture, as received
Non-spec Price Adjustments
 | [NAME] | ratio of Net Calorific Value of delivered coal to Net Calorific Value of contract coal.  The Contract Base Price is multiplied by this ratio to determine the Final Price, not including any adjustment required for out of spec Ash or [NAME].
 | Ash | price $[1] per [0.1]% greater than maximum specification for Ash content
 | [NAME] | $[1] per [0.1]% greater than maximum specification for [NAME] content
Location | ARA | Amsterdam-Rotterdam-Antwerp port area
Delivery Terms | CIF | Cost, Insurance and Freight as defined by Incoterms 1990
Units | mt | metric tonne [1000 kg]
Examples:
Short Description: | Physical Delivery, Steam Coal 1, CIF ARA, Q3 1999, GBP/mt
Long Description:
Short Description: | Call Option on Physical Delivery, Steam Coal 1, CIF ARA, Q4 2000, USD/mt
Long Description:
Spreadsheet: 862400d1710153055-how-do-i-create-polynomial-coefficients-for-a-table-with-2-variable-inputs-polynomial-generation-v2
Sheet: Sheet1

 |  |  | Fan Speed
 |  |  | 1 | 0.8 | 0.6 | 0.4 | 0.2 |  | 6 | 5 | 4 | 3 | 2 | 1 | 0 |  | Result
 | Density Ratio | 0.2 | 0.5602681786444155 | 0.5242592146626477 | 0.4862250698137789 | 0.4459899534174349 | 0.4033571231574961
 |  | 0.4 | 0.7690471505528507 | 0.7462019507305976 | 0.7220719135659387 | 0.6965455120173826 | 0.6694979266780862
 |  | 0.6 | 0.8813066990653233 | 0.8688018306703822 | 0.8555936757206858 | 0.8416211872134858 | 0.8268160422508499
 |  | 0.8 | 0.9516895842186365 | 0.9464433274230571 | 0.9409020157935861 | 0.9350400378449242 | 0.9288287295834818
 |  | 1 | 1 | 1 | 1 | 1 | 1
 |  | 1.2 | 1.035229615944395 | 1.039166939513177 | 1.043325702175934 | 1.047725125390672 | 1.052386721527437
 |  | 1.4 | 1.062063465303166 | 1.069054263945055 | 1.076438232233882 | 1.084249498262037 | 1.092526257683161
 |  | 1.6 | 1.083185696627049 | 1.092609524244377 | 1.102563357540156 | 1.113093202310873 | 1.124250547560015
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 6
 |  |  |  | Fan Speed = | 0.5 |  |  |  |  |  |  |  |  |  |  | 5
 |  |  |  | Density Ratio = | 0.9 |  |  |  |  |  |  |  |  |  |  | 4
 |  |  |  | Result = |  |  |  |  |  |  |  |  |  |  |  | 3
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 2
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 1
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 0
Spreadsheet: 834877d1688129397-combine-3-tables-in-one-sheet-into-one-table-in-a-new-sheet-data-archive-test
Sheet: Append1

Column1 | Contents & Comments | Review Date (dd/mm/yyyy)
123456789101112 | Test 1 | 45089
0 | 0 | 0
0 | 0 | 0
0 | 0 | 0
0 | 0 | 0
0 | 0 | 0
0 | 0 | 0
0 | 0 | 0
0 | 0 | 0
0 | 0 | 0
0 | 0 | 0
0 | 0 | 0
0 | 0 | 0
0 | 0 | 0
0 | 0 | 0
0 | 0 | 0
0 | 0 | 0
0 | 0 | 0
0 | 0 | 0
0 | 0 | 0
0 | 0 | 0
0 | 0 | 0
0 | 0 | 0
0 | 0 | 0
0 | 0 | 0
0 | 0 | 0
0 | 0 | 0
0 | 0 | 0
0 | 0 | 0
0 | 0 | 0
0 | 0 | 0
0 | 0 | 0
0 | 0 | 0
0 | 0 | 0
0 | 0 | 0
0 | 0 | 0
0 | 0 | 0
0 | 0 | 0
0 | 0 | 0
0 | 0 | 0
12354268547421 | test 2 | 46055
0 | 0 | 0
0 | 0 | 0
0 | 0 | 0
0 | 0 | 0
0 | 0 | 0
0 | 0 | 0
0 | 0 | 0
0 | 0 | 0
0 | 0 | 0
0 | 0 | 0
0 | 0 | 0
0 | 0 | 0
0 | 0 | 0
0 | 0 | 0
0 | 0 | 0
0 | 0 | 0
0 | 0 | 0
0 | 0 | 0
0 | 0 | 0
0 | 0 | 0
0 | 0 | 0
0 | 0 | 0
0 | 0 | 0
0 | 0 | 0
0 | 0 | 0
0 | 0 | 0
0 | 0 | 0
0 | 0 | 0
0 | 0 | 0
0 | 0 | 0
0 | 0 | 0
0 | 0 | 0
0 | 0 | 0
0 | 0 | 0
0 | 0 | 0
0 | 0 | 0
0 | 0 | 0
0 | 0 | 0
0 | 0 | 0
444223687541254 | test 3 | 46491
0 | 0 | 0
0 | 0 | 0
0 | 0 | 0
0 | 0 | 0
0 | 0 | 0
0 | 0 | 0
0 | 0 | 0
0 | 0 | 0
0 | 0 | 0
0 | 0 | 0
0 | 0 | 0
0 | 0 | 0
0 | 0 | 0
0 | 0 | 0
0 | 0 | 0
0 | 0 | 0
0 | 0 | 0
0 | 0 | 0
0 | 0 | 0
0 | 0 | 0
0 | 0 | 0
0 | 0 | 0
0 | 0 | 0
0 | 0 | 0
0 | 0 | 0
0 | 0 | 0
0 | 0 | 0
0 | 0 | 0
0 | 0 | 0
0 | 0 | 0
0 | 0 | 0
0 | 0 | 0
0 | 0 | 0
0 | 0 | 0
0 | 0 | 0
0 | 0 | 0
0 | 0 | 0
0 | 0 | 0
0 | 0 | 0
Spreadsheet: 681076d1591345346-complicated-formula-needed-to-find-value-in-a-range-with-multiple-variables-consolidated-rules-sample-file-
Sheet: Calcultor Current

 |  |  |  |  |  | Fcst | Fcst | Fcst | Fcst | Fcst | Fcst | Fcst
2020-01-01 00:00:00 |  |  |  |  |  | 2020-01-01 00:00:00 | 2020-02-01 00:00:00 | 2020-03-01 00:00:00 | 2020-04-01 00:00:00 | 2020-05-01 00:00:00 | 2020-06-01 00:00:00 | 2020-07-01 00:00:00
 |  |  |  |  | Event Guests | 10 | 15 | 15 | 10 | 45 | 45 | 45
 |  |  |  |  | Total Guests | 80 | 86 | 85 | 86 | 86 | 86 | 86
 |  |  |  |  | Occupied rooms | 80 | 80 | 80 | 80 | 80 | 80 | 80
Business name 1
Department | Status | Unit of Measure | Shift | Code | Position | Fcst | Fcst | Fcst | Fcst | Fcst | Fcst | Fcst
 | Active | n/a | n/a | 10a | Night Auditor
 | Active | Event Guests | Shift 1 | 12b | Planner
 | Active | Event Guests | Shift 2 | 12b | Planner
 | Active | Event Guests | Shift 3 | 12b | Planner
 | Inactive | n/a | n/a | 61a | Manager
 | Active | Total Guests | Shift 1 | 51a | Receptionist
 | Active | Total Guests | Shift 2 | 51a | Receptionist
 | Active | Total Guests | Shift 3 | 51a | Receptionist
 | Inactive | n/a | n/a | 31a | Engineer
 | Active | Occupied rooms | n/a | 40a | [NAME]
 | Active | Occupied rooms | n/a | 40b | Server
 |  |  |  |  |  | *** I started to attempt a formula in cell G22 but gave up. :(
Spreadsheet: 97629d1296753401-cross-sheet-calc-that-would-omit-0-possible-solution-but-am-getting-a-ref-error-2011trending
Sheet: Trending

Trending | Volume completed | Tasks completed per hour | Average Points | Points per hour | Employees | Production Hours
2011-01-03 00:00:00 | 296 | 3.296948095344175 | 96.54 | 16.13 | 12 | 89.78
2011-01-04 00:00:00 | 290 | 3.400961651225519 | 89.93 | 15.82 | 12 | 85.27
2011-01-05 00:00:00 | 358 | 3.869015454447206 | 110.6 | 17.93 | 12 | 92.53
2011-01-06 00:00:00 | 300 | 3.207526996685556 | 89.88 | 15.37 | 12 | 93.53
2011-01-07 00:00:00 | 219 | 2.907980347895366 | 71.57 | 15.2 | 9 | 75.31
2011-01-12 00:00:00 | 224 | 2.916666666666667 | 69.07 | 14.39 | 10 | 76.8
2011-01-13 00:00:00 | 295 | 3.20547647506248 | 85 | 14.78 | 12 | 92.03
2011-01-14 00:00:00 | 293 | 2.687087307410124 | 82.32 | 12.08 | 11 | 109.04
2011-01-18 00:00:00 | 333 | 4.085889570552148 | 85.13 | 16.71 | 15 | 81.5
2011-01-19 00:00:00 | 461 | 4.061674008810573 | 126.25 | 17.8 | 15 | 113.5
2011-01-20 00:00:00 | 318 | 3.654332337393703 | 89.25 | 16.41 | 15 | 87.02
2011-01-21 00:00:00 | 317 | 4.253891572732153 | 79.94 | 17.16 | 13 | 74.52
2011-01-24 00:00:00 | 302 | 3.489715738386873 | 95.57 | 17.67 | 13 | 86.54
2011-01-25 00:00:00 | 439 | 4.27250608272506 | 116.94 | 18.24 | 15 | 102.75
2011-01-26 00:00:00 | 354 | 3.412048192771084 | 103.63 | 15.98 | 15 | 103.75
2011-01-27 00:00:00 | 292 | 3.181867712760162 | 87.81 | 15.31 | 14 | 91.77
2011-01-28 00:00:00 | 314 | 4.683072334079045 | 78 | 18.61 | 11 | 67.05
2011-01-31 00:00:00 | 368 | 4.25286027967179 | 99.44 | 18.39 | 12 | 86.53
2011-02-01 00:00:00 | 555 | 4.845891906050817 | 146.25 | 20.43 | 13 | 114.53
2011-02-02 00:00:00 | 409 | 4.009017839639286 | 115.31 | 18.08 | 14 | 102.02
2011-02-03 00:00:00 |  | #N/A
2011-02-04 00:00:00 |  | #N/A
2011-02-07 00:00:00 |  | #N/A
2011-02-08 00:00:00 |  | #N/A
2011-02-09 00:00:00 |  | #N/A
2011-02-10 00:00:00 |  | #N/A
2011-02-11 00:00:00 |  | #N/A
2011-02-14 00:00:00 |  | #N/A
2011-02-15 00:00:00 |  | #N/A
2011-02-16 00:00:00 |  | #N/A
2011-02-17 00:00:00 |  | #N/A
2011-02-18 00:00:00 |  | #N/A
2011-02-21 00:00:00 |  | #N/A
2011-02-22 00:00:00 |  | #N/A
2011-02-23 00:00:00 |  | #N/A
2011-02-24 00:00:00 |  | #N/A
2011-02-25 00:00:00 |  | #N/A
2011-02-28 00:00:00 |  | #N/A
 |  |  |  |  |  |  |  | Averages | Volume completed | Tasks completed per hour | Average Points | Points per hour | Employees | Production Hours
 |  |  |  |  |  |  |  | Totals | 336.85 | 3.684721528515489 | 95.9215 | 16.6245 | 12.75 | 91.28849999999998
Spreadsheet: darrell_schoolcraft__7783__imbalsumm0107
Sheet: by type

If index is high - payback should be done on Dollar Valued payables
- payback should be done on Volumetric receivable
- payback should not be done on Dollar valued receivables
- payback should not be done on Volumetric payables
TRANSWESTERN  PIPELINE -   SUMMARY OF OBA BALANCES
Positive = due [NAME]
Negative = due operator |  |  |  |  |  |  |  |  |  |  |  |  |  | index
 |  |  |  |  |  |  |  |  |  |  |  |  |  | SJ
Operator | Dollars | Volume | As of Date | Imbal Type | MS rep | Comments |  |  |  |  |  |  |  | AVG
NNG |  |  |  | Dollar Valued | [NAME] |  |  |  |  |  |  |  |  | NTXPH
[NAME] |  |  |  | Dollar Valued | [NAME] | Keystone - to be cashed out
PNM |  |  |  | Dollar Valued | [NAME]
Red Cedar |  |  |  | Dollar Valued | [NAME]
[NAME] |  |  |  | Dollar Valued | [NAME]
Amoco Abo |  |  |  | Dollar Valued | [NAME]
Conoco |  |  |  | Dollar Valued | [NAME] | [NAME] and Maljamar
Mewborne |  |  |  | Dollar Valued | [NAME]
EOG |  |  |  | Dollar Valued | [NAME]
CIG |  |  |  | Dollar Valued | [NAME] | being reconciled with CIG
PG&E TX/EPFS |  |  |  | Dollar Valued | [NAME]
Duke/GPM |  |  |  | Dollar Valued | [NAME] | Crawford, Pecos Diamond, [NAME], Linam Ranch, Artesia
TransColorado |  |  |  | Dollar Valued | [NAME]
Burlington |  |  |  | Dollar Valued | [NAME] | ending 5/31/01 bal of $295,327 invoiced
Continental |  |  |  | Dollar Valued | [NAME]
Agave |  |  |  | Dollar Valued | [NAME]
El Paso Field Services |  |  |  | Dollar Valued | [NAME]
Citizens-Griffith |  |  |  | Dollar Valued | [NAME]
North Star Steel |  |  |  | Dollar Valued | [NAME]
Calpine |  |  |  | Dollar Valued | [NAME]
Citizens Communications |  |  |  | Dollar Valued | [NAME]
$ valued totals
Operator | Dollars | Volume | As of Date | Imbal Type | MS rep | Comments
[NAME] |  |  |  | Volumetric | [NAME] | [NAME], Valverde, [NAME], and Milagro
NGPL |  |  |  | Volumetric | [NAME] | 5,000/DAY scheduled for makeup
El Paso |  |  |  | Volumetric | [NAME] | Blanco and Window Rock
SoCal |  |  |  | Volumetric | [NAME]
Lonestar |  |  |  | Volumetric | [NAME]
Amoco |  |  |  | Volumetric | [NAME]
Panhandle Eastern |  |  |  | Volumetric | [NAME] | Blanco and Window Rock
Oasis |  |  |  | Volumetric | [NAME]
Mojave Pipeline |  |  |  | Volumetric | [NAME]
Northwest |  |  |  | Volumetric | [NAME]
PG&E Topock |  |  |  | Volumetric | [NAME]
volumetric totals
Net $ valued/volumetric
Note -  This report does not represent the total population of imbalances on Transwestern.
Spreadsheet: 0adfcc7d-7130-4951-83bc-beac655e3ca5
Sheet: Sheet1

Unnamed: 0 | Unnamed: 1 | Unnamed: 2 | Unnamed: 3 | Unnamed: 4 | Unnamed: 5 | Unnamed: 6 | Unnamed: 7 | Unnamed: 8 | Unnamed: 9 | Unnamed: 10 | Unnamed: 11
 | Time Series Workbook
 | 8501.0 Retail Trade, Australia
 | TABLE 16. Retail Turnover, Completely Enumerated sector: Australia
Related Information: | Summary Publication | Explanatory Notes | Inquiries
Data Item Description |  |  | Series Type | Series ID | Series Start | Series End | No. Obs. | Unit | Data Type | [NAME]. | Collection Month
Turnover ;  Total CE and [NAME] ; |  |  | Original | [NAME] | 1994-04-01 00:00:00 | 2011-10-01 00:00:00 | 211 | $ Millions | FLOW | Month | 1
Turnover ;  Total CE and [NAME] ; |  |  | Seasonally Adjusted | A3350334L | 1994-04-01 00:00:00 | 2011-10-01 00:00:00 | 211 | $ Millions | FLOW | Month | 1
Turnover ;  Total CE and [NAME] ; |  |  | Trend | A3350340J | 1994-04-01 00:00:00 | 2011-10-01 00:00:00 | 211 | $ Millions | FLOW | Month | 1
% change from preceding month ;  Total CE and [NAME] ; |  |  | Original | A3350329V | 1994-04-01 00:00:00 | 2011-10-01 00:00:00 | 211 | Percent | PERCENT | Month | 1
% change from preceding month ;  Total CE and [NAME] ; |  |  | Seasonally Adjusted | A3350335R | 1994-04-01 00:00:00 | 2011-10-01 00:00:00 | 211 | Percent | PERCENT | Month | 1
% change from preceding month ;  Total CE and [NAME] ; |  |  | Trend | A3350341K | 1994-04-01 00:00:00 | 2011-10-01 00:00:00 | 211 | Percent | PERCENT | Month | 1
© Commonwealth of Australia  2011
Spreadsheet: 877411d1724251865-lookup-based-on-unique-value-and-date-within-a-date-range-employee-number-and-date-within-range-lookup
Sheet: Sheet1

Employee Number | Leave Type | Leave Group | End Date |  |  | Employee Number | Position Start | Position End | Leave Group
1000397 | ANN |  | 2024-08-19 00:00:00 |  |  | 1000397 | 2023-10-05 00:00:00 |  | 724
1000397 | ANN |  | 2024-08-16 00:00:00 |  |  | 1000397 | 2015-01-27 00:00:00 | 2023-10-04 00:00:00 | SA1
1000397 | ANN |  | 2024-07-10 00:00:00
1000397 | ANN |  | 2024-06-20 00:00:00
1000397 | ANN |  | 2024-05-23 00:00:00
1000397 | ANN |  | 2024-05-03 00:00:00
1000397 | ANN |  | 2024-03-22 00:00:00
1000397 | ANN |  | 2023-11-17 00:00:00
1000397 | ANN |  | 2023-11-10 00:00:00
1000397 | ANN |  | 2023-10-10 00:00:00
1000397 | ANN |  | 2023-09-14 00:00:00
1000397 | ANN |  | 2023-09-01 00:00:00
1000397 | ANN |  | 2023-08-30 00:00:00
1000397 | ANN |  | 2023-06-16 00:00:00
1000397 | ANN |  | 2023-05-30 00:00:00
1000397 | ANN |  | 2023-05-19 00:00:00
 |  | Lookup leave group based on unique employee number and leave end date
Spreadsheet: 813520d1673832924-help-with-looking-up-and-deciphering-vin-codes-using-lookups-worksheet-problem-001
Sheet: TEST BASE

 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | YEAR |  |  |  |  |  |  | BODY STYLE |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | UNIT #
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | This |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | was Mustang number
 |  |  |  |  | VIN NUMBER
 |  |  |  |  | 7R03S |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | ASSEMBLY PLANT
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | to roll off the |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | assembly plant.
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | ENGINE
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | It is powered by a
Spreadsheet: 56144d1256238339-calculating-sub-totals-for-different-cost-centres-costcentres
Sheet: Sheet1

October | Cost Centre | Income | Wages | Materials
 | main | 100 | 20 | 1.25
 | red | 56 | 21.5 | 3
 | blue | 11 | 18 | 2.5
 | red | 32 | 29 | 5.25
 | green | 78 | 13.5 | 1
 | red | 108 | 15 | 0
 | blue | 93 | 19 | 0.5
 | main | 42 | 19 | 6
 | pink | 56 | 22 | 0.25
 | pink | 88 | 18 | 0.75
 | pink | 100 | 20 | 1.25
 | blue | 56 | 21.5 | 3
 | pink | 11 | 18 | 2.5
Sub-totals:
 | main | 142 | 39 | 7.25
 | red | 196 | 65.5 | 8.25
 | blue | 160 | 58.5 | 6
 | green | 78 | 13.5 | 1
 | pink | 255 | 78 | 4.75
Spreadsheet: 7049e669-7e98-4343-a23c-d1c77b1566c5
Sheet: ChemOffice1

Entry number | Structure | Compound ID | Primary Screening Activity 10.2µM (%) | Retested? | Retest IC50 T.b.brucei (µM) | Restest IC50 HEK (µM) | Estimated Selectivity Index
1 | C14H16N2OS | WEHI-0051810 | 100 |  | 9% at the top dose
2 | C19H14N2O2S | WEHI-0052293 | -9 | No
3 | C21H21N3OS | WEHI-0078860 | 2 | No
4 | C21H20N2OS | [NAME] | 97 | Yes, but did not pass selectivity criteria | 5.806 | 41.7
5 | C18H15BrN2OS | [NAME] | 48 | No
6 | C19H18N2O3S | [NAME] | 12 | No
7 | C19H18N2OS | WEHI-1195238 | -2 | No
8 | C17H16N4O2 | WEHI-1201161 | -5 | No
9 | C16H14FN3O3 | WEHI-1201166 | 5 | No
10 | C17H17N3O2S | [NAME] | -2 | No
11 | C18H15ClFN3O2 | WEHI-1201171 | 7 | No
12 | C20H25N3O2S | WEHI-1201483 | 6 | No
13 | [NAME] | WEHI-1201484 | 3 | No
14 | C16H16N2OS | WEHI-1201486 | 2 | No
15 | C20H17FN2O3S | WEHI-1203383 | 3 | No
16 | C19H15ClF2N2OS | WEHI-1203384 | 25 | No
17 | C17H15ClN2OS2 | [NAME] | 13 | No
18 | C20H19ClN2O2S | WEHI-1203386 | 3 | No
19 | C16H19ClN2O2S | WEHI-1203387 | 8 | No
20 | C21H21FN2OS | WEHI-1203388 | -3 | No
21 | C19H15ClN2O3S | WEHI-1203390 | -7 | No
22 | C18H13ClF2N2OS | WEHI-1203391 | 2 | No
23 | C16H13FN2OS2 | WEHI-1203392 | 100 | Yes, did not pass medicinal chemistry analysis | 0.0432 | >41.7
24 | C19H17FN2O2S | WEHI-1203393 | 2 | No | 37.5% at the top dose
25 | C16H19FN2OS | WEHI-1203394 | 100 | Yes, parent compound | 0.441 | 41.7
26 | C16H12BrFN2O2S | WEHI-1203395 | 85 | Yes, did not pass selectivity criteria | 8.39 | 41.7
27 | C19H14F4N2OS | WEHI-1203396 | -4 | No
28 | C19H16ClFN2O2S | WEHI-1203397 | 9 | No
29 | C18H15F3N4O | WEHI-1203787 | 8 | No
30 | C17H15ClN4O | WEHI-1203791 | 1 | No
31 | C17H14F2N4O | WEHI-1203794 | 99.5 | Yes, parent compound | 1.93 | 41.7
32 | C17H16ClN5O | WEHI-1203814 | -3 | No
33 | C19H24N2O2S | WEHI-1204300 | 26 | No
34 | C18H18N2O2S | WEHI-1204301 | 0 | No
35 | C19H19N3OS | WEHI-1204303 | 2 | No
36 | C18H17N3OS | WEHI-1204312 | -1 | No
Spreadsheet: 770842d1646298946-need-help-solving-this-transpose-scenario-copy-of-need-help-solving-this-transpose-scenario
Sheet: Summary

Dist | City | Product Code | QTY |  |  | helper_dist1 | helper_dist2 | city_helper1 | city_helper2 | prod_helper1 | prod_helper2 | qty
A | ABC | 32000044 | 132
 |  | 62000076 | 24
 |  | 62000084 | 0
 |  | 62000097 | 0
 |  | 62000098 | 2
 |  | 62000099 | 2
 |  | 62000100 | 2
 |  | 62000101 | 2
 |  | 62000102 | 2
 |  | 62000109 | 2
 |  | 62000111 | 2
B | DEF | 32000044 | 198
 |  | 62000076 | 48
 |  | 62000084 | 2.25
 |  | 62000097 | 3
 |  | 62000098 | 2
 |  | 62000099 | 2
 |  | 62000100 | 2
 |  | 62000101 | 2
 |  | 62000102 | 2
 |  | 62000109 | 2
 |  | 62000111 | 2
Spreadsheet: 868386d1715121342-finance-problem-to-solve-and-develope-in-excel-weighted-value-buckets_v1
Sheet: Inputs

 |  | INPUTS
 |  | Assets - Input | 2000000
 |  | Annual Income needed - Input | 120000
 |  | Years 1-3
 |  |  | PMT
 |  | 0.03 | i/YR
 |  | 0 | FV
 |  | 3 | Nper
 |  |  | PV
 |  | Years 4-8
 |  |  | PMT
 |  | 0.04 | i/YR
 |  | 0 | FV
 |  | 5 | Nper
 |  |  | PV
 |  | Years 9-14
 |  |  | PMT
 |  | 0.06 | i/YR
 |  | 0 | FV
 |  | 6 | Nper
 |  |  | PV
 |  | Years 15+
 |  |  | PV
Spreadsheet: 731466d1620355384-please-help-me-with-these-functions-excel-test-junior-accountant
Sheet: Test 1

 |  |  |  | Group Name | Group Segment | Expense | Region | Adjusted Region
 |  |  |  | [NAME] | Big | 6186.995752359548 | N | 1-North
 |  |  |  | [NAME] | Small | 4918.404737416461 | S | 2-South
 |  |  |  | Examineers Inc | Medium | 4635.026810398586 | E | 3-East
 |  |  |  | [NAME] | Small | 7436.590733418787 | W | 4-West
 |  |  |  | FASST Trax | Small | 3035.751883566108 | SE | 2-South
 |  |  |  | [NAME] | Big | 3597.815628432074 | NE | 1-North
 |  |  |  | Hehehe | Medium | 4903.350075762555 | N | 1-North
 |  |  |  | [NAME] | Small | 2363.567081527782 | S | 2-South
 |  |  |  | Creepy Lada | Medium | 7128.586370287349 | E | 3-East
 |  |  |  | Jokes R Us | Big | 7033.60535246887 | W | 4-West
 |  |  |  | Petie's Palace | Small | 5079.099781827978 | SE | 2-South
Spreadsheet: 760475d1640233031-calculating-risk-level-rodfarrar-example-for-excel-forum
Sheet: Register

 | Risk Register Operation Overlord
 |  |  |  |  |  |  |  |  |  |  |  |  | Consequences to DVA |  |  |  |  |  |  |  |  |  | Consequences to DVA
 | Risk # | Risk title | Causes | Controls that are part of all events that address the causes | Control Owner | Control Status | Control Effectiveness | Controls that are part of all events that address the Consequences | Control Owner | Control Status | Control Effectiveness | Likelihood | Safety | Reputation | Budget | Highest Level Consequence | Current Risk Level | Additional Control Required | Additional Control | Responsible | Date to be Completed | Likelihood | Safety | Reputation | Budget | Highest Level Consequence | Final Risk Level
 |  |  |  |  |  | Status 1 | Partially Effective |  |  | Status 1 | Partially Effective | Possible | Insignificant | Minor | Minor
 |  |  |  |  |  | Status 1 | Partially Effective |  |  | Status 1 | Partially Effective
 |  |  |  |  |  |  |  |  |  |  |  |  | Likelihood | Consequence
 |  |  |  |  |  |  |  |  |  |  |  |  |  | Insignificant | Minor | Moderate | Major | Severe
 |  |  |  |  |  |  |  |  |  |  |  |  | Almost Certain | Low | Low | Medium | High | Extreme
 |  |  |  |  |  |  |  |  |  |  |  |  | Likely | Low | Low | Medium | High | Extreme
 |  |  |  |  |  |  |  |  |  |  |  |  | Possible | Low | Low | Medium | High | High
 |  |  |  |  |  |  |  |  |  |  |  |  | Unlikely | Low | Low | Low | Medium | High
 |  |  |  |  |  |  |  |  |  |  |  |  | Rare | Low | Low | Low | Medium | Medium