tianzl66/Sheetpedia huggingface dataset:
Spreadsheet: 156012d1337145388-how-to-find-unique-data-from-a-larger-set-of-data-modelingexercises-completed
Sheet: DCF Model

Instructions
Find the shareholder value per share using a discounted cash flow analysis.
Calculate the stock's margin of safety.
Be sure that the formulas behind all calculations are provided in your model.
Note: Use the CAPM to find the cost of equity.
Assumptions
NOPAT in current year 0 | 1100
NOPAT growth | 0.1
Capital use in current year 0 | 100
Growth in capital use | 0.1
Forecast period (in years) | 5
NOPAT growth in perpetuity | 0
Risk-Free Rate | 0.035
Beta | 1.2
Expected return on the market | 0.08
Credit Spread | 0.01
Market value of equity | 15000
Market value of debt | 2500
Marginal Tax Rate | 0.3
Shares outstanding | 1000
Spreadsheet: 485204d1476779380-sort-base-on-creteria-book1
Sheet: Sheet1

Header 1 | [NAME] | [NAME] | [NAME] |  |  |  |  | Helper (hide) | Header 1 | [NAME] | [NAME] | [NAME]
US | Sales | 2016-05-04 00:00:00 | 3.1
GE | Infra | 2016-08-01 00:00:00 | 2
NL | Sales | 2016-01-01 00:00:00 | 1.3
MA | Tech | 2016-03-03 00:00:00 | 4.5
TR | Tech | 2016-01-01 00:00:00 | 1
US | Tech | 2016-08-15 00:00:00 | 2.1
US | Sales | 2016-07-01 00:00:00 | 1.2
MA | Tech | 2016-07-08 00:00:00 | 1.2
Spreadsheet: 50038d1249461128-sorting-data-into-columns-book1a
Sheet: Sheet1

EO |  | NAME | Time | AR | BB | BJ | EG | PK | PS | FS
 | 1 | [NAME] |  | Ar | Bj | Bb | Eg | Pk
 | 2 | [NAME] |  | Ar | Bj | Pk
 | 3 | Mark |  | BJ | Bb | Pk
 | 4 | [NAME] |  | BJ | Bb | Pk
 | 5 | [NAME] |  | Ar | Bj | Bb | Eg |  |  | Fs
 | 6 | Sue |  | [NAME] | Nbb
 | 7
 | 8
 | 9
 | 10
Spreadsheet: 777259d1650288575-shift-pattern-dropdown-list-and-auto-populate-calendar-scheduler-draft-missja-
Sheet: Shifts Details

 | Shifts Details
 |  |  | A | B | C | D | E | F | G
 | ROSTERS > |  | Shift A | Shift B | Shift C | Shift D | Shift E | Shift F | Shift G
 |  |  | 1 | 2 | 3 | 4 | 5 | 6 | 7
 | Day | Shift Name | Day Shift | Day Shift | Day Shift | Day Shift | Day Shift | Day Shift | Day Shift
 |  | Code | D | D | D | D | D | D | D
 |  | Time of Shift | 5:00 AM to 05:00 PM | 5:00 AM to 05:00 PM | 5:00 AM to 05:00 PM | 5:00 AM to 05:00 PM | 5:00 AM to 05:00 PM | 5:00 AM to 05:00 PM | 5:00 AM to 05:00 PM
 | Night | Shift Name | Night Shift | Night Shift | Night Shift | Night Shift | Night Shift | Night Shift | Night Shift
 |  | Code | N | N | N | N | N | N | N
 |  | Time of Shift | 05:00 PM to 05:00 AM | 05:00 PM to 05:00 AM | 05:00 PM to 05:00 AM | 05:00 PM to 05:00 AM | 05:00 PM to 05:00 AM | 05:00 PM to 05:00 AM | 05:00 PM to 05:00 AM
 | OFF | Shift Name | Night Shift | Night Shift | Night Shift | Night Shift | Night Shift | Night Shift | Night Shift
 |  | Code | O | O | O | O | O | O | O
 |  | Time of Shift
 | Day Off Code |  | x | x | x | x | x | x | x
 | Pattern Start Date
 | Shift Pattern |  | doddddd | ddodddd | dddoddd | ddddodd | dddddod | ddddddo | odddddd
Spreadsheet: 809510d1671120313-looking-up-currency-and-returning-usd-book2-5-
Sheet: Sheet1

 |  |  |  |  |  |  |  |  | FX Rates | 1 USD equals
 | Currency | Jan | Feb | Mar | USD Jan | USD Feb | [NAME] |  | USD | 1
 | USD | 2000 | 1000 | 500 |  |  |  |  | GBP | 0.82
 | GBP | 0 | 500 | 500 |  |  |  |  | EUR | 0.94
 | EUR | 1000 | 0 | 200 |  |  |  |  | AUD | 1.49
 | AUD | 50 | 200 | 0 |  |  |  |  | HKD | 7.77
 |  |  |  |  |  |  |  |  | SGD | 1.36
Spreadsheet: 762210d1641453380-if-cell-contains-product-name-then-count-all-the-cells-that-contain-the-letter-a-sumproduct-sample-aligw
Sheet: Sales (2)

 |  |  |  | ACTIVE (a) | DEAD (d) | LOST (l) | CONVERTED (c) | TOTAL
 |  |  | TEFLON - PTFE
 |  |  | NYLON - PA
 |  |  | ACETAL - POM
 |  |  | POLYESTER - PET
 |  |  | TEFLON - PTFE
 |  |  | [NAME]'S
 |  |  | POWER TRANS
 |  |  | CONPRO
 |  |  | Totals
STATE | DATE | CUSTOMER | PRODUCT | [NAME] | QUANTITY | EST VALUE $ | PROJECT NAME | COMPETITORS | 2020
 |  |  |  |  |  |  |  |  | JAN | FEB | MAR | APR | MAY | JUN | JUL | AUG | SEP | OCT | NOV | DEC
QLD | 2021-08-24 00:00:00 |  | CONPRO | STEEL ROLLERS | 8 | 8000 | ROLLER REPLACE | Other
 |  |  | CONPRO |  |  |  |  |  |  |  | a | d | c | l
 |  |  | ACETAL - POM |  |  |  |  |  |  |  | d |  |  |  |  |  | l
 |  |  | POWER TRANS | RELAG WHEELS |  |  |  |  |  | a | d |  |  |  |  |  |  | d
 |  |  | POLYESTER - PET | BUMP STOPS
 |  |  | TEFLON - PTFE | GUIDES |  |  |  |  |  | a | a |  | d | l | c | c |  |  | l
Spreadsheet: 858733d1707309588-trying-to-calculate-tat-witha-formula-found-here-but-error-tat-test-1-
Sheet: Sheet1

Topic | Received from [NAME] | Replied by 1st Level | Categories | Year | Month | Who worked the request | TAT | TAT/working h | [NAME] | End date1 | Startdate2 | End date2
should result either 4:20 or 00:00 | 2024-02-06 04:36:03 | 2024-02-06 08:57:00 | no data | no data | no data | no data |  |  | 09:00:00 | 13:00:00 | 14:00:00 | 18:00:00
 | 2024-02-05 18:17:38 | 2024-02-06 09:04:00 | no data | no data | no data | no data
 | 2024-02-05 07:05:26 | 2024-02-05 12:14:00 | no data | no data | no data | no data
 | 2024-02-01 12:06:38 | 2024-02-05 12:21:00 | no data | no data | no data | no data
should result in 0:55 | 2024-02-02 21:14:45 | 2024-02-02 22:10:00 | no data | no data | no data | no data
 | 2024-02-02 16:17:29 | 2024-02-05 13:48:00 | no data | no data | no data | no data
 | 2024-02-02 16:01:05 | 2024-02-02 16:21:00 | no data | no data | no data | no data
 | 2023-12-08 11:45:31 | 2024-02-02 18:09:00 | no data | no data | no data | no data
 | 2024-02-02 12:07:59 | 2024-02-05 14:26:00 | no data | no data | no data | no data
 | 2024-02-02 00:25:27 | 2024-02-02 11:00:00 | no data | no data | no data | no data
 | 2024-02-01 16:59:35 | 2024-02-05 15:51:00 | no data | no data | no data | no data
 | 2024-01-31 17:38:11 | 2024-02-01 16:56:00 | no data | no data | no data | no data
 | 2024-02-01 15:15:00 | 2024-02-01 15:15:00 | no data | no data | no data | no data
should calculate from 9:00 to 16:11 ideallly | 2024-01-10 20:37:58 | 2024-02-02 16:11:00 | no data | no data | no data | no data
 | 2024-02-01 07:14:59 | 2024-02-02 13:40:00 | no data | no data | no data | no data
 | 2024-02-01 12:38:16 | 2024-02-01 13:19:24 | no data | no data | no data | no data
 | 2024-02-01 12:08:10 | 2024-02-01 15:44:26 | no data | no data | no data | no data
should calculate between years too | 2023-12-19 17:13:55 | 2024-02-05 16:55:00 | no data | no data | no data | no data
 | 2024-01-30 03:08:00 | 2024-02-01 17:03:00 | no data | no data | no data | no data
 | 2024-02-01 06:23:48 | 2024-02-01 13:11:00 | no data | no data | no data | no data
 | 2024-02-01 06:05:28 | 2024-02-01 13:03:00 | no data | no data | no data | no data
 | 2023-12-05 14:02:00 | 2024-01-31 18:04:24 | no data | no data | no data | no data
 | 2024-01-30 16:14:00 | 2024-02-02 14:48:00 | no data | no data | no data | no data
 | 2024-01-31 12:14:49 | 2024-02-01 10:37:00 | no data | no data | no data | no data
 | 2024-01-31 11:35:27 | 2024-02-02 12:47:05 | no data | no data | no data | no data
 | 2024-01-31 10:33:20 | 2024-01-31 11:11:00 | no data | no data | no data | no data
 | 2024-01-17 12:53:29 | 2024-01-31 17:34:00 | no data | no data | no data | no data
 | 2024-01-30 17:12:55 | 2024-01-30 18:33:58 | no data | no data | no data | no data
Spreadsheet: daren_farmer__6367__Devon Avails
Sheet: 0002

[NAME] (PennzEnergy) South Texas Properties
 |  |  | December Volumes
Pipeline | Location | [NAME] | Base | Swing | Total | Comments
[NAME] | [NAME] | Gulf Plains Plant | 8156 | 429
 | [NAME] | Gulf Plains Plant | 3166 | 167
Carthage | American Central | Tailgate | 60089 | 6677
 | [NAME] | Tailgate | 0 | 500
 | Ruby-Lacy | Tailgate | 0 | 250
 | [NAME] | Tailgate | 10705 | 1189 |  | Gathering nomination on [NAME] gathering system as Pennzoil's agent
Corpus Christi Gas Gath. | Virginia | 3358 | 828 | 72
Delhi | Volpe | LL-1-0027 | 731 | 64
 | [NAME] | LL-1-0027 | 41 | 4
 | Comitas C.P. | LL-1-0030 | 264 | 23
 |  |  |  |  |  | Termed up with Delhi (evergreen)
Gulf Energy | [NAME] | 19-1043-00 | 476 | 36 |  | Termed up with Gulf Energy (evergreen)
 | Comitas South | 440-559 | 893 | 78
 | Tejas Plant | 29320 | 106 | 9
 | Jennings 63 Plant | 440-565 | 4274 | 372
 | Haynes Plant | 440-557 | 300 | 26 |  | Termed up with Tejas thru 3/00
 | Haynes 17, 18 | 23-603-01 | 1736 | 151 |  | Termed up with Tejas thru 3/00
 | [NAME] | 31-504-04 | 4390 | 382
 | Garza Plant | 440-552 | 0 | 0 |  | Trevino Plant gas is sometimes re-routed through Garza Plant
 | [NAME] | 21-022-08 | 0 | 71
Lone Star | Sandtrap | 178477 | 3606 | 401 |  | Termed up with TXU Energy thru 11/00
Midcon Texas | [NAME] / TOC | 5553 | 304 | 23
 | Hall Plant | 5576 | 611 | 53
 | Jennings Ranch | 446 | 1311 | 114
Spreadsheet: 87824d1287681358-pivot-table-help-needed-ienjoi-pivot-table-example-lol
Sheet: Pivot Table

Count of Loan ID | Column Labels
Row Labels | (blank) | Jul | Aug | Sep | Grand Total
Car |  | 11 | 9 | 3 | 23
Mortgage |  | 9 | 8 | 7 | 24
Other |  | 5 | 6 | 9 | 20
Personal |  | 7 | 9 | 7 | 23
(blank)
Grand Total |  | 32 | 32 | 26 | 90
Spreadsheet: 72689d1273409719-how-to-shift-down-31-rows-everytime-i-copy-a-cell-testing2
Sheet: Statistics

Test# | Observation before | Observation after
1 | Not present | Not present
2 | Not present 2
3 | Not present 3
4 | #N/A
5 | #N/A
6 | #N/A
7 | #N/A
8 | #N/A
9 | #N/A
10 | #N/A
 | #N/A
Spreadsheet: 81781d1281951522-changing-cell-or-weighting-values-if-more-than-consecutive-cells-the-same-value-example-spreadsheet-for-forum
Sheet: Dan

Thursday | 2010-07-01 00:00:00
Friday | 2010-07-02 00:00:00
Saturday | 2010-07-03 00:00:00
Sunday | 2010-07-04 00:00:00
Monday | 2010-07-05 00:00:00
Tuesday | 2010-07-06 00:00:00
Wednesday | 2010-07-07 00:00:00
Thursday | 2010-07-08 00:00:00
Friday | 2010-07-09 00:00:00
Saturday | 2010-07-10 00:00:00
Sunday | 2010-07-11 00:00:00
Monday | 2010-07-12 00:00:00
Tuesday | 2010-07-13 00:00:00
Wednesday | 2010-07-14 00:00:00
Thursday | 2010-07-15 00:00:00
Friday | 2010-07-16 00:00:00
Saturday | 2010-07-17 00:00:00
Sunday | 2010-07-18 00:00:00
Monday | 2010-07-19 00:00:00
Tuesday | 2010-07-20 00:00:00
Wednesday | 2010-07-21 00:00:00
Thursday | 2010-07-22 00:00:00
Friday | 2010-07-23 00:00:00
Saturday | 2010-07-24 00:00:00
Sunday | 2010-07-25 00:00:00
Monday | 2010-07-26 00:00:00
Tuesday | 2010-07-27 00:00:00
Wednesday | 2010-07-28 00:00:00
Thursday | 2010-07-29 00:00:00
Friday | 2010-07-30 00:00:00
Saturday | 2010-07-31 00:00:00
Sunday | 2010-08-01 00:00:00
Monday | 2010-08-02 00:00:00
Tuesday | 2010-08-03 00:00:00
Wednesday | 2010-08-04 00:00:00
Thursday | 2010-08-05 00:00:00
Friday | 2010-08-06 00:00:00
Saturday | 2010-08-07 00:00:00
Sunday | 2010-08-08 00:00:00
Monday | 2010-08-09 00:00:00
Tuesday | 2010-08-10 00:00:00
Wednesday | 2010-08-11 00:00:00
Thursday | 2010-08-12 00:00:00
Friday | 2010-08-13 00:00:00
Saturday | 2010-08-14 00:00:00
Sunday | 2010-08-15 00:00:00
Monday | 2010-08-16 00:00:00
Tuesday | 2010-08-17 00:00:00
Wednesday | 2010-08-18 00:00:00
Thursday | 2010-08-19 00:00:00
Friday | 2010-08-20 00:00:00
Saturday | 2010-08-21 00:00:00
Sunday | 2010-08-22 00:00:00
Monday | 2010-08-23 00:00:00
Tuesday | 2010-08-24 00:00:00
Wednesday | 2010-08-25 00:00:00
Thursday | 2010-08-26 00:00:00
Friday | 2010-08-27 00:00:00
Saturday | 2010-08-28 00:00:00
Sunday | 2010-08-29 00:00:00
Monday | 2010-08-30 00:00:00
Tuesday | 2010-08-31 00:00:00
Wednesday | 2010-09-01 00:00:00
Thursday | 2010-09-02 00:00:00
Friday | 2010-09-03 00:00:00
Saturday | 2010-09-04 00:00:00
Sunday | 2010-09-05 00:00:00
Monday | 2010-09-06 00:00:00
Tuesday | 2010-09-07 00:00:00
Wednesday | 2010-09-08 00:00:00
Thursday | 2010-09-09 00:00:00
Friday | 2010-09-10 00:00:00
Saturday | 2010-09-11 00:00:00
Sunday | 2010-09-12 00:00:00
Monday | 2010-09-13 00:00:00
Tuesday | 2010-09-14 00:00:00
Wednesday | 2010-09-15 00:00:00
Thursday | 2010-09-16 00:00:00
Friday | 2010-09-17 00:00:00
Saturday | 2010-09-18 00:00:00
Sunday | 2010-09-19 00:00:00
Monday | 2010-09-20 00:00:00
Tuesday | 2010-09-21 00:00:00
Wednesday | 2010-09-22 00:00:00
Thursday | 2010-09-23 00:00:00
Friday | 2010-09-24 00:00:00
Saturday | 2010-09-25 00:00:00
Sunday | 2010-09-26 00:00:00
Monday | 2010-09-27 00:00:00
Tuesday | 2010-09-28 00:00:00
Wednesday | 2010-09-29 00:00:00
Thursday | 2010-09-30 00:00:00
Spreadsheet: 125677d1319157705-index-and-match-formula-combination-test-price
Sheet: Prices

Customer number | Part number | Price
111 | A | 2
222 | B | 3
333 | A | 2
444 | C | 5
555 | D | 5
555 | A | 6
Spreadsheet: f1f3d02a-2677-42dd-b018-b4b9887c4843
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
The data inserted in the various sheets are fictive numbers given as examples. They should be deleted before initialising your own budget
Summary Forward Budget for the Operation
 | Form B/1 |  |  |  |  |  |  |  |  |  | Form B/2
Expenditure | Total Eligible costs |  |  |  |  | Financing plan |  |  |  | Amount EUR | Percentage of eligible costs %
Summary sheet by beneficiary | Total Eligible costs |  | Forward budget
 |  |  | Consolidated expenditure summary sheet | Costs (EUR)
Beneficiary 1 (Coordinator) | 143291.8874464703 |  | 1.1 Beneficiaries' own staff personnel costs ** | 21000
[NAME] | 428 |  | 1.2. Other costs | 17617.65181913113
Beneficiary 3 | 535 |  | 1.2.a - Travel and subsistence expenses | 4063.56361500624 |  | Co-financing by the applicant and Partners (1)+(2) |  |  | total | 42430.22186161758 | 0.25
[NAME] | 642 |  | 1.2.b - Equipment | 5630.390478519605
Beneficiary 5 | 749 |  | 1.2.c - Consumables and supplies | 3961.848862802641 |  | Monetary contribution (1)
Beneficiary 6 | 856 |  | 1.2.d - Miscellaneous / Other costs | 3961.848862802641 |  | Own resources (2) |  |  |  | 42430.22186161758
Beneficiary 7 | 963 |  | 1.3. Services subcontracted | 120000
Beneficiary 8 | 1070 |  |  |  |  | Other third party co-financers* (please specify below) |  |  | total | 0 | 0
Beneficiary 9 | 1177 |  | 1. Total direct costs (1.1 + 1.2 + 1.3) | 158617.6518191311 |  | Name
Beneficiary 10 | 1284 |  |  |  |  | 1.
Beneficiary 11 | 1391 |  | 2.  Indirect costs*** | 11103.23562733918 |  | 2.
Beneficiary 12 | 1498 |  |  |  |  | 3.
Beneficiary 13 | 1605 |  | 3. TOTAL ELIGIBLE  COSTS (1 + 2) | 169720.8874464703 |  | …
Beneficiary 14 | 1712
Beneficiary 15 | 1819 |  | EC Maximum contribution - Percentage | 0.75 |  | Contribution requested from the Commission |  |  | total | 127290.6655848527 | 0.75
Beneficiary 16 | 1926 |  | EC Maximum contribution - Amount | 175000
Beneficiary 17 | 2033 |  |  |  |  | DG Enterprise |  |  |  | 127290.6655848527
Beneficiary 18 | 2140
Beneficiary 19 | 2247
Beneficiary 20 | 2354
TOTAL COSTS |  |  |  |  |  | Direct revenues expected from the operation (please specify below) |  |  | total | 0 | 0
TOTAL ELIGIBLE COSTS | 169720.8874464703 |  |  |  |  | Participants
 |  |  |  |  |  | SUBTOTAL ELIGIBLE REVENUES |  |  |  | 169720.8874464703 | 1
 |  |  |  |  |  | OVERALL TOTAL |  |  |  | 169720.8874464703
 |  |  |  |  |  | * A co-financing statement form ("C") must be filled in for each contributor.
Spreadsheet: 08d4cb67-9a0c-4e7e-82a5-e5a171c07bc4
Sheet: Sheet1

Unnamed: 0 | SVG Coater and [NAME] Use Only | Unnamed: 2 | Unnamed: 3 | Unnamed: 4 | Unnamed: 5 | Unnamed: 6 | Unnamed: 7 | Unnamed: 8 | Unnamed: 9 | Unnamed: 10
 | Week of Mar. 22 - Mar. 28, 2009
 |  | 1um | 1.6um | 7um | 1um | 1.6um | 3um | 1um | 1.6um | 3um
SVG                         Coater | Date (Coat) | 2009-03-24 00:00:00 | 2009-03-24 00:00:00 | 2009-03-24 00:00:00 | 2009-03-24 00:00:00 | 2009-03-24 00:00:00 | 2009-03-24 00:00:00
 | Track | 1 | 1 | 1 | 2 | 2 | 2
 | Prime Program | Yes Oven | Yes Oven | Yes Oven | Yes Oven | Yes Oven | Yes Oven
 | Coat Program | 7 | 8 | 4 | 7 | 8 | 4
 | Oven Program | 1 | 2 | 3 | 1 | 2 | 3
 | Problems
Thickness Measurements                                (NanoSpec) | Date (Measurement) | 2009-03-24 00:00:00 | 2009-03-24 00:00:00 | 2009-03-24 00:00:00 | 2009-03-24 00:00:00 | 2009-03-24 00:00:00 | 2009-03-24 00:00:00 | - | - | -
 | Top (A) | 10284 | 17110 | 72875 | 10275 | 17044 | 30181 | - | - | -
 | Center (A) | 10271 | 17133 | 72886 | 10232 | 17021 | 30193 | - | - | -
 | Flat (A) | 10275 | 17110 | 72826 | 10242 | 17026 | 30154 | - | - | -
 | Left  (A) | 10293 | 17097 | 72829 | 10255 | 17061 | 30211 | - | - | -
 | Right (A) | 10286 | 17132 | 72858 | 10267 | 17043 | 30177 | - | - | -
 | Average (A) | 10282 | 17116 | 72855 | 10254 | 17039 | 30187 | - | - | -
 | [NAME]  (A) | 9 | 16 | 27 | 18 | 16 | 25 | - | - | -
 | Comments
Exposure | Date (Exposure) | 2009-03-24 00:00:00 | 2009-03-24 00:00:00 | 2009-03-24 00:00:00 | 2009-03-24 00:00:00 | 2009-03-24 00:00:00 | 2009-03-24 00:00:00
 | Tool | [NAME] | [NAME] | [NAME] | [NAME] | [NAME] | [NAME] | EValign | EValign | EValign
 | Contact Type | Vac. | Vac. | Vac. | Vac. | Vac. | Vac.
 | Exposure Time | 1.2s | 1.6s | 3.0s x2 | 1.2s | 1.6s | 3.0s
 | Problems
SVG                            Developer | Date (Develop) | 2009-03-24 00:00:00 | 2009-03-24 00:00:00 | 2009-03-24 00:00:00 | 2009-03-24 00:00:00 | 2009-03-24 00:00:00 | 2009-03-24 00:00:00
 | Track | 1 | 1 | 1 | 2 | 2 | 2
 | Pre-bake Program | 1 | 2 | none | 1 | 2 | none
 | Develop Program | 3 | 4 | 6 | 3 | 4 | 7
 | Post-base Program | 1 | 2 | none | 1 | 2 | none
 | Problems
Resolution                         Measurements | Date (Measurement) | 2009-03-18 00:00:00 | 2009-03-18 00:00:00 | 2009-03-18 00:00:00 | 2009-03-19 00:00:00 | 2009-03-19 00:00:00 | 2009-03-19 00:00:00
 | Top (H/V) (um) | 1/1.5 | 1.5/1.5 | 2.5/3 | 1/2 | 2/2 | 2/2.5
 | Center (H/V) (um) | 1.5/1.5 | 1.5/2 | 2.5/3 | 1.5/2 | 1.5/2 | 2.5/3
 | Flat (H/V) (um) | 1/1.5 | 2/2 | 2.5/3 | 2/2 | 1.5/2 | 2.5/3
 | Left (H/V) (um) | 1.5/2 | 1/2 | 3/3 | 1/2 | 2/2 | 2/2.5
 | Right (H/V) (um) | 1.5/2 | 1.5/2 | 3/3 | 1/2 | 1.5/2.5 | 2.5/3
 | Comments |  | Underexposed compared to last measurement. Will increase exposure to 1.8s next week | Generally underexposed. Exposure will be adjusted to 3.2s x2 next week |  |  | Generally underexposed. Will adjust to 3.2s next week
Spreadsheet: 764098d1642588749-dynamic-list-with-multiple-criteria-example
Sheet: Main

Code | 10222300 |  |  | enter code
 | Item Code | Description
1 | 98565 | Lids
2 | 450454 | Tubs
3 | 45487 | Boxes |  |  | populates this from worksheet."data" but only if column 'B' is code 50,60,70,80,90
4 | 454575 | Tape
5 | 457877 | Cardboard
Spreadsheet: 880426d1728108447-excel-lookup-formula-angelos19-data-question-spill-365-aligw
Sheet: Sheet5 (2)

 |  |  |  |  | Name | Type of Food | Cheese | Fish | Ham | Bread
 |  |  |  |  | Cheesecake
 |  |  |  |  | Fishsauce | Fish |  |  |  |  |  | Fish
 |  |  |  |  | Hamhock | Ham |  |  |  |  |  | Ham
 |  |  |  |  | Breadsand | Bread |  |  |  |  |  | Bread
 |  |  |  |  | Cheesesteak | Cheese |  |  |  |  |  | Cheese
 |  |  |  |  | Breadsauce | Bread |  |  |  |  |  | Bread
 |  |  |  |  | Breadcake | Bread |  |  |  |  |  | Bread
 |  |  |  |  | Fishtreacle | Fish |  |  |  |  |  | Fish
 |  |  |  |  | Cheesestick | Cheese |  |  |  |  |  | Cheese
 |  |  |  |  | Hamcake | Ham |  |  |  |  |  | Ham
 |  |  |  |  | Hamsteak | Ham |  |  |  |  |  | Ham
Spreadsheet: 43999d1242665561-need-formula-help-converting-military-time-in-time-card-abc-timecard
Sheet: JUNE

 | NAME: | xxx |  |  |  | EMPLOYEE #: |  | xxx |  | MONTH/YR: | 2009-06-01 00:00:00
 | Day | Date | Time In | Time Out | Time In | Time Out | REG HRS | Trng Hours | OT Hours | OT PAY | Comp Time | VAC Used | SICK Used | COMP Used | Sub
MAY
 | Mon | 25 |  |  |  |  | 0 |  |  |  |  |  |  |  | 0
 | Tue | 26 |  |  |  |  | 0 |  |  |  |  |  |  |  | 0
 | Wed | 27 |  |  |  |  | 0 |  |  |  |  |  |  |  | 0
 | Thu | 28 |  |  |  |  | 0 |  |  |  |  |  |  |  | 0
 | Fri | 29 |  |  |  |  | 0 |  |  |  |  |  |  |  | 0
 | Sat | 30 |  |  |  |  | 0 |  |  |  |  |  |  |  | 0
 | Sun | 31 |  |  |  |  | 0 |  |  |  |  |  |  |  | 0
[NAME] |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 0
 | Mon | 1 |  |  |  |  | 0 |  |  |  |  |  |  |  | 0
 | Tue | 2 |  |  |  |  | 0 |  |  |  |  |  |  |  | 0
 | Wed | 3 |  |  |  |  | 0 |  |  |  |  |  |  |  | 0
 | Thu | 4 |  |  |  |  | 0 |  |  |  |  |  |  |  | 0
 | Fri | 5 |  |  |  |  | 0 |  |  |  |  |  |  |  | 0
 | Sat | 6 |  |  |  |  | 0 |  |  |  |  |  |  |  | 0
 | Sun | 7 |  |  |  |  | 0 |  |  |  |  |  |  |  | 0
 | Mon | 8 |  |  |  |  | 0 |  |  |  |  |  |  |  | 0
 | Tue | 9 |  |  |  |  | 0 |  |  |  |  |  |  |  | 0
 | Wed | 10 |  |  |  |  | 0 |  |  |  |  |  |  |  | 0
 | Thu | 11 |  |  |  |  | 0 |  |  |  |  |  |  |  | 0
 | Fri | 12 |  |  |  |  | 0 |  |  |  |  |  |  |  | 0
 | Sat | 13 |  |  |  |  | 0 |  |  |  |  |  |  |  | 0
 | Sun | 14 |  |  |  |  | 0 |  |  |  |  |  |  |  | 0
 | Mon | 15 |  |  |  |  | 0 |  |  |  |  |  |  |  | 0
 | Tue | 16 |  |  |  |  | 0 |  |  |  |  |  |  |  | 0
 | Wed | 17 |  |  |  |  | 0 |  |  |  |  |  |  |  | 0
 | Thu | 18 |  |  |  |  | 0 |  |  |  |  |  |  |  | 0
 | Fri | 19 |  |  |  |  | 0 |  |  |  |  |  |  |  | 0
 | Sat | 20 |  |  |  |  | 0 |  |  |  |  |  |  |  | 0
 | Sun | 21 |  |  |  |  | 0 |  |  |  |  |  |  |  | 0
 | Mon | 22 |  |  |  |  | 0 |  |  |  |  |  |  |  | 0
 | Tue | 23 |  |  |  |  | 0 |  |  |  |  |  |  |  | 0
 | Wed | 24 |  |  |  |  | 0 |  |  |  |  |  |  |  | 0
 |  |  |  |  |  | TOTALS: | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0
 |  |  |  |  |  |  |  |  |  | OT Pay | C | V | S | CU
NOTES: |  |  |  |  |  |  |  |  |  | Vac |  | Sick |  | Comp
 |  |  |  |  |  |  |  |  | Balance Forward | 60 |  | 60 |  | 0
 |  |  |  |  |  |  |  |  | Used this month | 0 |  | 0 |  | 0
 |  |  |  |  |  |  |  |  | Accumulated |  |  | 60 |  | 0 |  | *
 |  |  |  |  |  |  |  |  | New Balance Forward | 60 |  | 120 |  | 0
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  | *this # includes time & a half
 |  |  |  |  |  |  |  | I CERTIFY THAT THE ABOVE HOURS ARE CORRECT.
Personal Day Off |  |  |  |  |  |  |  | EMPLOYEE: |  |  |  |  | DATE:
Initial for Pay ________ |  |  |  |  |  |  |  | SUPERVISOR: |  |  |  |  | DATE:
Spreadsheet: sally_beck__35523__MgmtSum-Q201-Global-0601
Sheet: AllocExp

PLAN2000
CAP_CHRG | ENRON GLOBAL MARKETS
TOT_ALLOCATION | 2nd QUARTER 2001  ALLOCATED EXPENSES
2000-12-01 00:00:00
M.QTD
ENA
 |  |  | Capital Charge |  |  |  |  |  |  | Allocated Expenses
 | Business Team |  | Forecast | Plan | [NAME] | Explanation |  |  |  | Forecast | Plan | [NAME] | [NAME]
 | Crude & Products |  | 0 | 0 |  |  |  |  |  |  | 9979.172
COAL | Coal / Emissions |  |  | 0
 | Vessel Trading |  |  |  |  |  |  |  |  |  | 377
SO2 | Emissions |  |  | 0 |  |  |  |  |  |  | 0
WEATHER | Weather |  |  | 0
INSURANCE | Global Risk Markets |  | 0 | 0 |  |  |  |  |  |  | 955.693
ECT_INV_IRFX | Financial Trading |  |  | 0 |  |  |  |  |  |  | 2270.631
 | Freight Markets |  | 0 | 0 |  |  |  |  |  |  | 577.418
 | LNG |  |  | 0 |  |  |  |  |  |  | 1191.846
 | Puerto Rico |  |  | 0 |  |  |  |  |  |  | 573.065
 | Finance and Structuring |  |  | 0 |  |  |  |  |  |  | 70.366
 | Office of the Chairman |  | 0 | 0 |  |  |  |  |  |  | 474.024
 | Subtotal Commercial
 | [NAME] |  |  |  |  |  |  |  |  | 0 | 0
 | Group Allocated to Teams |  | 0 | 0
 | Total
Spreadsheet: 882162d1730406313-dynamic-drop-down-using-tables-henighanhome-copy
Sheet: Job Summary

Job Number | Customer Number | Description | Cost Type | [NAME] | Fixed Price | Date | Invoiced | Invoice Date | Paid | Payment Date | Confirmation Email | Invoice Status | Materials | Labour | Total Estimate | Final Labour Cost | Final Invoice | Completion Status | Job Number with Details | Job Number Copy | Customer ID | Invoiceable
 | 100001 - [NAME] | Repair & Gravel Drive, Install Gates, [NAME] and Poly Tunnel. [NAME] | Estimate | Daily |  | 2024-10-05 00:00:00 |  |  | Not Paid
 | 100002 - Vera Henighan | [NAME] and Install Shower | Quote | Fixed | 1500 | 2024-10-05 00:00:00 | Yes | 2024-10-15 00:00:00 | Full | 2024-10-15 00:00:00 | Sent
 | 100003 - Alan Dowdy | Fix mouse hole and repair small section of roof lining in car port. Remove and install customer supplied fence and gate | Estimate | Daily |  | 2024-10-10 00:00:00 | Yes | 2024-10-24 00:00:00 | Full | 2024-10-25 00:00:00 | Sent
 | 100004 - Isobel | General [NAME] and fixes | Estimate | Daily |  | 2024-10-22 00:00:00 | Yes | 2024-10-31 00:00:00 | Not Paid