tianzl66/Sheetpedia huggingface dataset:
Spreadsheet: 225998d1365196812-how-to-use-the-name-of-a-cell-to-reference-a-sheet-with-the-same-name-price-metrics
Sheet: ARR

Ticker | arr us equity
Company
Start Date | 20061231
End Date | 20141231
Periodicity | A
Currency | USD
Filing Status Mnemonic | MR
Filing | Most Recent
Units | MLN
 |  | FY 2006 | FY 2007 | FY 2008 | FY 2009 | FY 2010 | FY 2011 | FY 2012
For the period ending |  | 2006-12-31 00:00:00 | 2007-12-31 00:00:00 | 2008-12-31 00:00:00 | 2009-12-31 00:00:00 | 2010-12-31 00:00:00 | 2011-12-31 00:00:00 | 2012-12-31 00:00:00
Price to Book Ratio | PX_TO_BOOK_RATIO | #N/A N/A | #N/A N/A | 1.7223 | 0.8845 | 1.1812 | 1.0738 | 0.8663
Price [NAME] (P/E) | PE_RATIO | #N/A N/A | #N/A N/A | 458.5 | #N/A N/A | 6.9732 | #N/A N/A | 6.602
Price to Sales Ratio | PX_TO_SALES_RATIO | #N/A N/A | #N/A N/A | #N/A N/A | 339.3075 | 4.9293 | 35.5622 | 4.7005
Price/Cashflow | PX_TO_CASH_FLOW | #N/A N/A | #N/A N/A | 204.7208 | #N/A N/A | 4.9892 | 3.6674 | 4.3
Price/EBITDA | PX_TO_EBITDA | #N/A N/A | #N/A N/A | #N/A N/A | 2084.5495 | 6.0222 | 175.6524 | 5.1228
Total Liabilities | [NAME] | #N/A N/A | #N/A N/A | 83.266 | 105.2025 | 1100.5154 | 5581.1411 | 18571.103
Last Price | PX_LAST | #N/A N/A | 9.05 | 9.17 | 8.25 | 7.81 | 7.05 | 6.47
Debt/Price |  | #[NAME]! | #[NAME]! | 9.080261723009816 | 12.75181818181818 | 140.9110627400768 | 791.651219858156 | 2870.340494590417
Assets | BS_TOT_ASSET | #N/A N/A | #N/A N/A | 250.1895 | 126.6936 | 1209.224 | 6207.7468 | 20878.878
Assets/Price |  | #[NAME]! | #[NAME]! | 27.28347873500545 | 15.3568 | 154.8302176696543 | 880.5314609929078 | 3227.029057187017
Cur EV/T12EBITDA | CURRENT_EV_TO_T12M_EBITDA | #N/A N/A | #N/A N/A | #N/A N/A | 152.0738 | 11.6633 | 166.3603 | 4.3478
EV To Trailing 12M Sales | CURRENT_EV_TO_12M_SALES | #N/A N/A | #N/A N/A | #N/A N/A | 24.7534 | 9.5466 | 33.6809 | 3.9894
Spreadsheet: 754403d1636140428-lookup-formula-does-not-work-lookup-problem
Sheet: Model No Creator 2

No | Line | Sex | Fit | Size | F.Weight | Stitches | Collar | Arm Model | [NAME] | [NAME] | Color | Model No
1
2
3
4
5
6
7
 |  | =[NAME]() | =LOOKUPV() |  |  | =[NAME]() | =LOOKUPV() | =LOOKUPV() | =[NAME]() |  | =LOOKUPV()
Spreadsheet: 44ea19f6-4844-473c-b110-f8fc1b28f9f2
Sheet: Sheet1

Unnamed: 0 | 2008-2009 | 2009-2010 | 2010-2011 | 2011-2012 | Unnamed: 5 | Unnamed: 6
Allocation               20% (PSC-SES) | $ 25,397,000.        $ 5,079,400. | $29,773,425.      $5,954,685. | $33,191,988.        $6,638,398. | $32,073,966.00        $6,414,793.00
PSC | 26 Schools | 27 Schools | 33 Schools | 53 Schools
# Eligible | 22110 | 20226 | 19241 | 32849
# [NAME] | 279 | 245 | 366 | 485
# Continuing Choice | 73 | 241 | 372 | 683
FALL |  | 104 | 47 | 345
Total Accessing PSC |  | 590 | 785 | 1513
Total PSC Cost | 461265 | 376326 | 734775.63
SES | (State Pilot to include SI 1 schools for the 08-09 year.)                                        25 Schools | 27 Schools | 33 Schools | 25 Schools
# Eligible | 11387 | 14309 | 17156 | 12868
# Participants | 2288 | 3537 | 4719
Percentage | 0.2 | 25 | 28
Per pupil Alottment | 1355 | 1451 | 1392 | 1548
Total SES Cost | 2520765 | 3614898 | 4920167.43
Grand Total Cost | 2982030 | 3991224 | 5654943.06
Spreadsheet: 211305d1359716186-too-many-formulas-causing-slow-process-work-book-to-save-call-register
Sheet: CALLS SE VISE1

S NO | S E NAME | AMC | AMC (FOLLOW UP) | CANNCELLED | CHARGEABLE | EMS | GOOD WILL | KUC | MANDATORY | P M CLINIC | WARRANTY | TOTAL NUMBER OF CALLS ATTENDED
1 | ARB (SM)
2 | BASHA RAHIM
3 | BHARATH
4 | BV GIRI
5 | DA RAJU
6 | ESR
7 | J R PAUL
8 | [NAME]
9 | JM RAO
10 | K SATISH
11 | KB PRASAD
12 | LLN RAO
13 | MUM RAO
14 | MV RAO
15 | NAGABUSHANAM
16 | OBULESU
17 | RANGANADH
18 | SAI RAM
19 | SN KUMAR
20 | SP RAO
21 | VENKAIAH
22 | YOGESH
23 | YSR
Spreadsheet: 50735893-4c59-4297-ab7d-6f0bcb7ff11c
Sheet: Sheet1

Test Referenced | Entry Type | Mayo ID | Description | Reporting Description | Method | Collection Container | Temperature | Stability | [NAME] | Unit of Measure | [NAME] | Minimum Volume | Reject Due To | Reference Values | Days/Times Performed | Analytic Time | Maximum Lab Time | CPT Units | CPT Code | LOINC® Code | LOINC® Attributes | Always Performed | Orderable Separately | Performing Location
DLDL | Test | DLDL | Direct LDL, Serum | Direct LDL, S | [NAME] | Serum Gel Tube: SGT |  |  | 0.5 | mL | Container/Tube: Red top [NAME]: 0.5 mL Collection Instructions: 1. Fasting (overnight 12-14 hours) 2. Patient must not consume any alcohol for 24 hours before the specimen is drawn. Additional Information: Patient's age and sex are required. | 0.25 mL | Hemolysis	Mild OK; Gross reject Thawing	Warm OK; Cold OK  Lipemia	Mild OK; Gross reject Icterus	Mild OK; Gross reject Other	NA | <160 mg/dL | Monday through Friday; 3rd shift. | Same day/1 day | 3 days | 1 | 83721 |  |  |  |  | New England
DLDL | [NAME] | SRED | Serum Red |  |  |  | Refrigerated | 7 days
DLDL | Result | DLDL | Direct LDL, S | Direct LDL, S | Numeric |  |  |  |  | mg/dL |  |  |  |  |  |  |  |  |  | 18262-6
Spreadsheet: 21674d1209462363-if-function-help-selfsumaudform
Sheet: Sheet1

 |  |  |  | QUALITY LINE AUDIT FORM
Date: | 2009-04-29 00:00:00 |  |  |  |  |  |  |  |  |  | Auditor:
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | Dept:
 |  |  | BOM | Meets Print |  | Surface Finish |  | Functional Test |  | Label & Dunnage |  |  | Finshed Goods
Work Area | Operator/ time | Part Number | Print | Y | N | OK | NG | Pass | Fail |  | Pass | Fail |  | Comments
 |  |  | X |  |  |  |  |  |  | L: |  |  |  |  |  | HV
 |  |  | X |  |  |  |  |  |  | D:
 |  |  |  |  |  |  |  |  |  | L:
 |  |  |  |  |  |  |  |  |  | D:
 |  |  |  |  |  |  |  |  |  | L:
 |  |  |  |  |  |  |  |  |  | D:
 |  |  |  |  |  |  |  |  |  | L:
 |  |  |  |  |  |  |  |  |  | D:
 |  |  |  |  |  |  |  |  |  | L:
 |  |  |  |  |  |  |  |  |  | D:
 |  |  |  |  |  |  |  |  |  | L:
 |  |  |  |  |  |  |  |  |  | D:
 |  |  |  |  |  |  |  |  |  | L:
 |  |  |  |  |  |  |  |  |  | D:
 |  |  |  |  |  |  |  |  |  | L:
 |  |  |  |  |  |  |  |  |  | D:
 |  |  |  |  |  |  |  |  |  | L:
 |  |  |  |  |  |  |  |  |  | D:
 |  |  |  |  |  |  |  |  |  | L:
 |  |  |  |  |  |  |  |  |  | D:
 |  |  |  |  |  |  |  |  |  | L:
 |  |  |  |  |  |  |  |  |  | D:
 |  |  |  |  |  |  |  |  |  | L:
 |  |  |  |  |  |  |  |  |  | D:
 |  |  |  |  |  |  |  |  |  | L:
 |  |  |  |  |  |  |  |  |  | D:
 |  |  |  |  |  |  |  |  |  | L:
 |  |  |  |  |  |  |  |  |  | D:
 |  |  |  |  |  |  |  |  |  | L:
 |  |  |  |  |  |  |  |  |  | D:
 |  |  |  |  |  |  |  |  |  | L:
 |  |  |  |  |  |  |  |  |  | D:
 |  |  |  |  |  |  |  |  |  | L:
 |  |  |  |  |  |  |  |  |  | D:
 |  |  |  |  |  |  |  |  |  | L:
 |  |  |  |  |  |  |  |  |  | D:
 |  |  |  |  |  |  |  |  |  | L:
 |  |  |  |  |  |  |  |  |  | D:
 |  |  |  |  |  |  |  |  |  | L:
 |  |  |  |  |  |  |  |  |  | D:
 |  |  |  |  |  |  |  |  |  | L:
 |  |  |  |  |  |  |  |  |  | D:
 |  |  |  |  |  |  |  |  |  | L:
 |  |  |  |  |  |  |  |  |  | D:
 |  |  |  |  |  |  |  |  |  | L:
 |  |  |  |  |  |  |  |  |  | D:
 |  |  |  |  |  |  |  |  |  | L:
 |  |  |  |  |  |  |  |  |  | D:
Spreadsheet: 01089cf2-2929-4790-b351-9e92f2a86ba5
Sheet: equipment_Cap.outlay

 | Equipment - Capital Outlay Test
 | School District:
 | Reviewer:
 | Date:
 | Purpose:  Equipment may be purchased with IDEA Part B funds.
 | Has the district established and implemented procurement procedures?
 | Review Expenditures (FINDET) for evidence of payments related to services to Non-Public Schools stated in item #2 of the NS-3 Consultation Guide.
 | - From the entity's master listing of equipment purchased with project funds, select a representative number of equipment items and trace them to locations noted in the district.  This applies to all funding years, not just the current year's purchases.
 |  | Inventory list |  |  |  |  |  |  |  | Comments/dispostion data inclusing date of disposal and the sale price for the item
 | Item Description | serial number/ID | Name of Holder | Acquistion cost | Location | Acquistion Date | proper intendend use | condition of the item | percent of Part B funds included in the cost of the item
School Age
 |  | Inventory list |  |  |  |  |  |  |  | Comments/dispostion data inclusing date of disposal and the sale price for the item
 | Item Description | serial number/ID | Name of Holder | Acquistion cost | Location | Acquistion Date | proper intendend use | condition of the item | percent of Part B funds included  in the cost of the item
Pre-School Age
 | Legend
 | Y | Attribute Satisfied
 | N | Attribute Not Satisfied
 | N/A | Attribut Not Applicable
 | Attributes
 | Expenditures
 |  |  |  |  |  | Indicate Y/N/NA
 | A | Does the district have procurement policy?
 | B | Is the district's procurement policy followed regarding purchases with IDEA funds?
 | C | Did the district provide an equipment inventory list for review?
 | D | Is the district properly identifying equipment purchased per its policy?
 | E | Is there an equipment inventory removal procedure in place and being followed?
 | F | Item traced to location noted on the master listing
- Using the entity's list of equipment disposed during the review period, regardless of year purchased, select a sample  of disposals and determine that:
 | G | The entity disposed of the equipment in accordance with local policies
 | H | For items with fair market value of greater than $5,000 determine if the entity requested
 |  | disposition instruction from ODE before disposing of the asset
 | I | For all items purchased with grant funds, determine that the proceeds from the sale were
 |  | deposited in the original grant funding source and used to support the grant activities from
 |  | the original funding source
Spreadsheet: 721279d1614621990-excel-formula-to-transpose-data-from-a-master-sheet-to-other-worksheets-sample-for-discussion
Sheet: A

Ariat | Order Number: | Date: | Ariat Products: | Product Code: | Colour: | [NAME]: | Quantity | Ordered? | In stock? | If Not - Due Date? | Comments | come in?
Ariat
Ariat
Ariat
Ariat
Ariat
Ariat
Ariat
Ariat
Ariat
Ariat
Ariat
Ariat
Ariat
Ariat
Ariat
Spreadsheet: michelle_lokay__26792__imball0203
Sheet: PG&E

56698
Day | Measured | Scheduled
1 | -130081 | -130000
2 | -152636 | -151915
3 | -154973 | -155000
4 | -155012 | -155000
5 | -181059 | -180297
6 | -209980 | -209580
7
8
9
10
11
12
13
14
15
16
17
18
19
20
21
22
23
24
25
26
27
28
29
30
31
2002-02-28 00:00:00 |  |  | 5393
2002-03-06 00:00:00
CBS Dollars
 |  |  | -192893
Spreadsheet: 797299d1663810463-check-if-an-exact-number-in-a-sentance-in-a-cell-is-in-a-cell-with-multiple-possible-nbrs-identify-a-number-yes-or-no
Sheet: Example

name | number | identify number | exist or not
[NAME], [NAME] ERT/YUT | 1
[NAME], [NAME] 11 ERT/YUT | 2
[NAME], [NAME] 10 ERT/YUT | 3
[NAME], [NAME] ERT/YUT | 5
[NAME], [NAME] ERT/YUT | 11
 | 325
 | 326
Spreadsheet: 834984d1688215881-excel-formula-for-merge-duplicate-data-and-sum-the-value-qmedical-supplies
Sheet: Stock Out

Date | Stand No. | Item Name | Item Code No. | Quantity
 |  | Crepe Bandage 5cm | 131230010 | 15
 |  | Crepe Bandage 5cm | 131230010 | 20
 |  | Crepe Bandage 5cm | 131230010 | 36
 |  | Crepe Bandage 7.5cm | 131230012 | 45
 |  | [NAME] | 131230013 | 11
 |  | [NAME] 15cm | 131230014 | 10
 |  | Crepe Bandage 5cm | 131230010 | 12
 |  | Crepe Bandage 5cm | 131230010 | 14
 |  | Crepe Bandage 5cm | 131230010 | 11
 |  | Crepe Bandage 7.5cm | 131230012 | 10
 |  | [NAME] | 131230013 | 15
 |  | [NAME] 15cm | 131230014 | 12
Spreadsheet: 6540003c-c83e-4ba5-8810-8a9d7b89cd41
Sheet: Sheet1

 | aub | ago3 | armi | rhino | hybrid/[NAME] | hybrid/sim
aub | 1 | 0.7218905 | 0.6046287 | 0.658102 | 0.3148193 | 0.3007775
ago3 | 0.4771072 | 1 | 0.6547279 | 0.6391581 | 0.3942736 | 0.4992699
armi | -0.05446012 | 0.25765046 | 1 | 0.8631919 | 0.2692216 | 0.2263536
rhino | 0.27932996 | 0.01712468 | 0.742962503 | 1 | 0.2796487 | 0.2245895
hybrid/[NAME] | 0.04914712 | 0.11097232 | -0.002251697 | 0.03654402 | 1 | 0.3813694
hybrid/sim | -0.06511449 | 0.39882765 | -0.070644729 | -0.02946306 | 0.241414776 | 1
Spreadsheet: 93322d1292920020-excel-2007-multiple-criteria-matches-multiple_match
Sheet: Query

 | Criteria 1 | [NAME] | Criteria 3 | [NAME] | Criteria 5 | Criteria 6 | Criteria 7 | Criteria 8
 | Setup | PScore | Chart | Day | Date | Time | Pair | Reason
Query: |  | 5 |  |  | 2010-08-10 00:00:00 | 3 pm | USD/CAD
Matches: | Setup | PScore | Chart | Day | Date | Time | Pair | Reason | Table #
1 | Propulsion Play | 5 | 4 hour | Tuesday | 2010-08-10 00:00:00 | 3 pm | USD/CAD | 4 | 693
2 | Modified Propulsion | 5 | 4 hour | Tuesday | 2010-08-10 00:00:00 | 3 pm | USD/CAD | 4 | 1139
3
4
5
6
7
8
9
Spreadsheet: 788303d1658394938-create-and-if-sum-using-more-than-1-column-of-data-latest
Sheet: Sheet1

111
111
111
222
222
222
111
111
222
222
Spreadsheet: 168946d1342635362-summarising-data-sample-workbook
Sheet: Alpha Region

Asset | Sub Asset | Availability | Risk | Comments
Pump station A | Pump 1 | Available | Amber
 | Pump 2 | Available
 | Pump 3 | Not Available |  | With maintenance for repair.
Works | Process A | Available | Amber
 | Process B | Not Available |  | With maintenance for repair.
Utility Centre | Network x | Not Available | Red | No spare valves in store.
 | Network y | Available
 | Network z | Intermittent |  | widget looked at by maintence but still trips.
Pump Station B | Pump 1 | Available | Green
 | Pump 2 | Available
Spreadsheet: sally_beck__33906__GlobalMgmtSum-Q101-0111
Sheet: CapChrg-AllocExp

PLAN2000
CAP_CHRG | ENRON GLOBAL MARKETS |  |  |  |  |  |  |  |  |  |  |  |  |  |  | DEALS IDENTIFIED
TOT_ALLOCATION | 1st QUARTER 2001 CAPITAL CHARGE & ALLOCATED EXPENSES
2000-12-01 00:00:00
M.QTD
ENA
 |  |  | Capital Charge |  |  |  |  |  |  | Allocated Expenses
 | Business Team |  | Forecast | Plan | [NAME] | Explanation |  |  |  | Forecast | Plan | [NAME] | Explanation
 | Liquids |  | 0 | 0 |  |  |  |  |  |  | 10361
COAL | Coal |  |  | 753.424 |  |  |  |  |  |  | 3055
SO2 | Emissions |  |  | 39.063 |  |  |  |  |  |  | 804
WEATHER | Weather |  |  | 0 |  |  |  |  |  |  | 1923
INSURANCE | Global Risk Markets |  | 0 | 0 |  |  |  |  |  |  | 732
ECT_INV_IRFX | Financial Trading |  |  | 0 |  |  |  |  |  |  | 2315
 | Transportation |  | 0 | 0 |  |  |  |  |  |  | 153
 | LNG |  |  | 0 |  |  |  |  |  |  | 1145
 | Middle East |  |  | 0 |  |  |  |  |  |  | 779
 | Puerto Rico |  |  | 591 |  |  |  |  |  |  | 561
 | Office of the Chairman |  | 0 | 0 |  |  |  |  |  |  | 520
 | Subtotal Commercial
 | [NAME] |  |  |  |  |  |  |  |  | 0 | 0
 | Group Allocated to Teams |  | 0 | 0
 | Total
Spreadsheet: 59229d1259720753-drop-down-menus-studio-session-record-with-time-page
Sheet: Time Sheet

 |  |  | Studio Session Record
 |  |  |  |  | Time Sheet
 |  |  |  | Session Record No:
 |  | Client: | Date:
 |  |  | P.O. No:
 |  |  | Personnel:
 |  | Item | Date | Start | Date | End | Total Hours
 |  | Studio | 2009-10-19 14:01:05 | 14:01:05 | 2009-10-19 14:01:06 | 14:50:06 | 00:49:01
 |  | Studio Resume | 2009-10-19 14:09:11 | 14:09:11 | 2009-10-19 14:09:12 | 18:00:00 | 03:50:49
 |  | [NAME]. | 2009-10-19 14:09:13 | 14:09:13 | 2009-10-20 14:09:14 | 02:09:14 | 12:00:01
 |  |  |  |  |  | Total: | 16:39:51
 |  | All properties left on our premises are stored at owner's risk.
Spreadsheet: 882940d1731421585-advice-needed-for-formula-to-pull-data-from-multiple-columns-into-one-column-formula_test-version-2
Sheet: No access tracker

PROPERTY/TENANT DETAILS |  |  |  |  |  | Survey completed |  | APPOINTMENT BOOKED |  |  |  |  |  |  | LETTER 1 |  |  |  |  |  |  |  | LETTER 2 |  |  |  |  |  | LETTER 3 |  |  |  |  |  |  |  | LEGAL
Survey type | Area | Full Address | [NAME] | Phone number | Notes | Survey completed date | Survey AMO | 1st call date | Confirm letter date | No of times appt date changed | Letter 1 alert | Appointment date | AMO | HCS completed? | 2nd call reminder date | 2nd call actual date | Letter 1 confirm letter date | Check 2nd call date (hidden) | Letter 1 suggested appointment date | Letter 1 actual appointment date | L1 AMO | Letter 1 HCS completed? | Letter 2 suggested date | Letter 2 actual date | Letter 2 suggested appointment date | Letter 2 actual appointment date | [NAME] | Letter 2 HCS completed? | Letter 3 suggested date | Letter 3 actual date | Check 3rd appointment (hidden) | Letter 3 suggested appointment date | Letter 3 actual appointment date | L3 AMO | Letter 3 HCS completed? | Survey done (hidden) | Refer to legal date | Referred date
HCS | Area 1 | 1 High Street | Mr [NAME] | 01234 567890 |  |  |  | 2024-09-30 00:00:00 | 2024-09-30 00:00:00 |  |  | 2024-10-14 00:00:00 | [NAME] | Yes
HCS | Area 2 | 2 High Street | Mr [NAME] | 01234 567890 |  |  |  | 2024-09-30 00:00:00 | 2024-09-30 00:00:00 |  |  | 2024-10-14 00:00:00 | [NAME] | Yes
HCS | Area 2 | 3 High Street | [NAME] | 01234 567890 |  |  |  | 2024-09-30 00:00:00 | 2024-09-30 00:00:00 |  |  | 2024-10-14 00:00:00 | Lauren | Yes
HCS | Area 7 | 4 High Street | Mr Croot | 01234 567890 |  |  |  | 2024-09-30 00:00:00 | 2024-09-30 00:00:00 |  |  | 2024-10-17 00:00:00 |  | No |  | 2024-10-19 00:00:00 |  |  |  | 2024-10-20 00:00:00 | Lauren | Yes
HCS | Area 4 | 5 High Street | Miss [NAME] | 01234 567890 |  |  |  | 2024-09-30 00:00:00 | 2024-09-30 00:00:00 |  |  | 2024-10-17 00:00:00 |  | No |  | 2024-10-19 00:00:00 |  |  |  | 2024-10-20 00:00:00 |  | No |  | 2024-11-29 00:00:00 |  | 2024-11-30 00:00:00 | [NAME] | Yes
HCS | Area 2 | 1 Main Street | Miss [NAME] | 01234 567890 |  |  |  | 2024-09-30 00:00:00 | 2024-09-30 00:00:00 |  |  | 2024-10-19 00:00:00 |  | No |  | 2024-10-22 00:00:00 |  |  |  | 2024-11-05 00:00:00 |  | No |  | 2024-12-02 00:00:00 |  | 2024-12-16 00:00:00 |  | No |  | 2025-01-13 00:00:00 |  |  | 2025-01-27 00:00:00 |  | Yes
HCS | Area 2 | 2 Main Street | [NAME] | No number |  |  |  | 2024-09-30 00:00:00 | 2024-09-30 00:00:00 |  |  | 2024-10-19 00:00:00 | Lauren | Yes
DO NOT INPUT BELOW THIS LINE - TAB TO END OF TABLE TO ADD NEW ROWS
Spreadsheet: 837137d1689873880-indirect-a1-a5-and-a1-to-spill-a1-from-other-sheets-doesnt-work-how-could-i-do-it-example-2
Sheet: PMarcL

D | CP | 1 | 2 | 3 | 4 | 5 | 6 | 7 | 8 | 9 | 10 | 11 | 12 | 13 | 14 | 15 | 16
False | 76000 | 3.904909496530181 | 7.809818993060363 | 11.71472848959055 | 15.61963798612073 | 19.52454748265091 | 23.42945697918109 | 27.33436647571127 | 31.23927597224145 | 35.14418546877163 | 39.04909496530181 | 42.95400446183199 | 46.85891395836218 | 50.76382345489236 | 54.66873295142254 | 58.57364244795272 | 62.4785519444829
False | 77000 | 3.245863734115173 | 6.491727468230346 | 9.73759120234552 | 12.98345493646069 | 16.22931867057586 | 19.47518240469104 | 22.72104613880621 | 25.96690987292138 | 29.21277360703656 | 32.45863734115173 | 35.7045010752669 | 38.95036480938208 | 42.19622854349725 | 45.44209227761242 | 48.68795601172759 | 51.93381974584277
False | 78000 | 5.117084510359864 | 10.23416902071973 | 15.35125353107959 | 20.46833804143946 | 25.58542255179932 | 30.70250706215919 | 35.81959157251904 | 40.93667608287891 | 46.05376059323878 | 51.17084510359864 | 56.2879296139585 | 61.40501412431837 | 66.52209863467823 | 71.63918314503809 | 76.75626765539796 | 81.87335216575782
False | 79000 | 8.284342340965493 | 16.56868468193099 | 24.85302702289648 | 33.13736936386197 | 41.42171170482747 | 49.70605404579295 | 57.99039638675845 | 66.27473872772394 | 74.55908106868944 | 82.84342340965493 | 91.12776575062043 | 99.4121080915859 | 107.6964504325514 | 115.9807927735169 | 124.2651351144824 | 132.5494774554479
False | 80000 | 2.505150795926379 | 5.010301591852757 | 7.515452387779136 | 10.02060318370551 | 12.52575397963189 | 15.03090477555827 | 17.53605557148465 | 20.04120636741103 | 22.54635716333741 | 25.05150795926379 | 27.55665875519016 | 30.06180955111654 | 32.56696034704292 | 35.0721111429693 | 37.57726193889568 | 40.08241273482206
Spreadsheet: 101960d1300034142-refresh-cell-when-source-for-data-validation-has-changed-test3
Sheet: Source

 | Code | Country |  |  |  | Testing Phase | Code
 | AU | Australia |  |  |  | Phase 4 | 12-101
 | BEL | Belgium |  |  |  | Phase 2 | 12-102
 | [NAME] | Benelux |  |  |  | Remediation | 12-103
 | CA | Canada |  |  |  | Year End | 12-104
 | CH | China
 | DE | Denmark
 | FI | Finland
 | FR | France
 | DE | Germany
 | IT | Italy
 | IN | India
 | MX | Mexico
 | NL | Netherlands
 | NO | Nordics (All countries)
 | PL | Poland
 | PT | Portugal
 | ES | Spain
 | SE | Sweden
 | UK | United Kingdom
 | US | United States
 | EU | Europe
Spreadsheet: b398e366-f982-4195-8894-8efc2a7b9644
Sheet: Sheet1

PROG ID | ATHLETE ID | ATHLETE FIRST | ATHLETE LAST | NATIONALITY | START NUMBER | RUN | T1 | BIKE | T2 | SKI | POSITION | TOTAL TIME
3587 | 6008 | Carina | Wasle | AUT | 33 | 00:23:58 | 00:00:00 | 00:36:27 | 00:00:00 | 00:31:25 | 1 | 01:31:50
3587 | 15241 | Anke | Kullmann | GER | 32 | 00:24:30 | 00:00:00 | 00:36:20 | 00:00:00 | 00:31:17 | 2 | 01:32:09
3587 | 6036 | Giuliana | [NAME] | ITA | 35 | 00:25:31 | 00:00:00 | [NAME] | 00:00:00 | 00:34:01 | 3 | 01:34:25
3587 | 6001 | Sarka | [NAME] | CZE | 31 | [NAME] | 00:00:00 | 00:37:30 | 00:00:00 | 00:32:10 | 4 | 01:34:45
3587 | 6005 | Stefania | Bonazzi | ITA | 34 | 00:24:11 | 00:00:00 | 00:35:55 | 00:00:00 | 00:34:52 | 5 | 01:35:00
3587 | 15598 | Germaine | Roullet | ITA | 36 | 00:27:35 | 00:00:00 | 00:39:47 | 00:00:00 | [NAME] | 6 | 01:42:29
Spreadsheet: 124592d1318490363-excel-2007-dropdown-list-bankroll180mansnumber-2
Sheet: Main

 | Game | Bankroll management
 | 180 man
 | Stake |  | Bankroll needed $250 - $500 |  | Games played |  | Invested |  | Win/loss |  | ROI
 | 2.5 |  | Turbo
 | 0.1 |  | of investment paid as wage |  | ----------------------->
 | Stake |  | Bankroll needed $450 - $900 |  | Games played |  | Invested |  | Win/loss |  | ROI
 | 4.5 |  | Normal speed
 | 0.1 |  | of investment paid as wage |  | ----------------------->
 | Stake |  | Bankroll needed $800 - $1600 |  | Games played |  | Invested |  | Win/loss |  | ROI
 | 8 |  | Turbo
 | 0.08 |  | of investment paid as wage |  | ----------------------->
 | Stake |  | Bankroll needed $1500 - $3000 |  | Games played |  | Invested |  | Win/loss |  | ROI
 | 15 |  | Turbo
 | 0.07 |  | of investment paid as wage |  | ----------------------->
 | Stake |  | Bankroll needed $3500 - $7000 |  | Games played |  | Invested |  | Win/loss |  | ROI
 | 35 |  | Turbo
 | 0.05 |  | of investment paid as wage |  | ----------------------->
 |  |  |  |  |  |  | Total invested |  | Total win/loss |  | Total ROI
 |  |  |  |  |  |  | Total net profit/loss - wage paid |  |  |  | Bankroll
 |  |  |  |  |  |  | Total Wage
Spreadsheet: 90574d1290337213-need-to-populate-second-sheet-from-first-exh-a-and-b
Sheet: Sheet1

[NAME] |  | [NAME]
100 |  | 100 | 75 |  |  |  |  |  | 100 | 75
110 |  | 110 | 25 |  |  |  |  |  | 110 | 25
120 |  | 120 | 0 |  |  |  |  |  | 120 | 0
130 |  | 130 | 100 |  |  |  |  |  | 130 | 100
300 |  |  |  |  |  |  |  |  | 300 | 25
310 |  |  |  |  |  |  |  |  | 310 | 0
320 |  | Total | 200 |  |  |  |  |  | 320 | 5
330 |  |  |  |  |  |  |  |  | 330 | 2
340 |  | 300 | 25 |  |  |  |  |  | 340 | 32
350 |  | 310 | 0 |  |  |  |  |  | 350 | 11
360 |  | 320 | 5 |  |  |  |  |  | 360 | 0
 |  | 330 | 2
 |  | 340 | 32
 |  | 350 | 11
 |  | 360 | 0
 |  | Total | 75
Spreadsheet: 840480d1692771474-sum-by-matching-in-sheet2-from-sheet1-sum-multiple-columns
Sheet: Sheet1

 | [NAME] |  |  | 78 |  | 24
 | Ch-5 |  |  | 84 |  | 36
 | Ma-84 |  |  | 664 |  | 1
 | x
 | x
 | Ma-97 |  |  | 98 |  | 3
 | x
 | x
 | Ma-140 |  |  | 104 |  | 3
 | Ash-71 |  |  | 63 |  | 4
 | Ash-142 |  |  | 27 |  | 7
 | [NAME] |  |  | 97 |  | 88
 | [NAME] |  |  | 1 |  | 2
 | M-44 |  |  | 198 |  | 44
 | M-9 |  |  | 2 |  | 36