tianzl66/Sheetpedia huggingface dataset:
Spreadsheet: 53287b36-18bd-4c72-8ac7-2d1350a18c39
Sheet: University Professors

First Name | Last Name | Title | Company/Organization | [NAME] | Phone | Alternate Phone/Cell | Fax | Street | City, State, Zip
Ralf | Sudowe | Assistant Professor for Health Physics and Radiochemistry | Department of Health Physics and Diagnostic Sciences University of Nevada Las Vegas, Office: BHS 349 | [EMAIL] | +[PHONE] |  | +[PHONE] | [NAME], 4505 S. Maryland Parkway | Las Vegas, NV 89154-3037
Alena | Paulenova | Associate Professor | Dept Nuclear Engineering and Radiation Health Physics, Oregon State University | [EMAIL] | [PHONE] |  |  | 100 Radiation Center | [NAME], OR 97331
Mikael | Nilsson | Professor | Chemical Engineering and Materials Science UC Irvine | [EMAIL] | Tel: [PHONE] |  |  | 916 Engineering Tower | [NAME], CA, 92697-2575
[NAME] | [NAME] | Assistant Professor | Environmental Engineering and Earth Sciences, [NAME], Clemson University | [EMAIL] | [PHONE] |  | [PHONE] | 342 Computer Ct. | [NAME], SC 29625
[NAME] | Schultz | Assistant Professor | Radiology and Radiation Oncology | [EMAIL] | [PHONE]
 |  |  | University of Iowa
 |  |  | 500 Newton Road
 |  |  | ML B 180 FRRBP
 |  |  | Iowa City, IA 52242
Spreadsheet: jeff_dasovich__14206__E204_HaasvilleAB_sim
Sheet: REPORT

 |  |  |  |  | Crystal Ball Report
 |  |  |  |  | Simulation started on 11/7/99 at 14:23:06
 |  |  |  |  | Simulation stopped on 11/7/99 at 14:30:42
Forecast:   NPV for Tech. A |  |  |  |  |  |  |  |  | Cell:  I25
 | Summary:
 |  | Certainty Level is 86.99%
 |  | Certainty Range is from -Infinity to $10.500  $
 |  | Display Range is from $9.000 to $11.250 $
 |  | Entire Range is from $8.659 to $11.411 $
 |  | After 10,000 Trials, the [NAME]. Error of the [NAME] is $0.004
 | Statistics: |  |  |  |  |  | Value
 |  | Trials |  |  |  |  | 10000
 |  | Mean |  |  |  |  | 10.0618136551764
 |  | Median |  |  |  |  | 10.06121364512914
 |  | Mode |  |  |  |  | ---
 |  | Standard Deviation |  |  |  |  | 0.3852887343039556
 |  | [NAME] |  |  |  |  | 0.1484474087815441
 |  | Skewness |  |  |  |  | 0.0381369724512386
 |  | Kurtosis |  |  |  |  | 2.903993499925431
 |  | [NAME]. of Variability |  |  |  |  | 0.03829217549718187
 |  | Range Minimum |  |  |  |  | 8.659172942886704
 |  | Range Maximum |  |  |  |  | 11.41099054055709
 |  | Range Width |  |  |  |  | 2.751817597670387
 |  | [NAME]. Error |  |  |  |  | 0.003852887343039556
Forecast:  NPV for Tech. B |  |  |  |  |  |  |  |  | Cell:  I34
 | Summary:
 |  | Certainty Level is 74.05%
 |  | Certainty Range is from -Infinity to $10.500  $
 |  | Display Range is from $7.500 to $12.500 $
 |  | Entire Range is from $6.950 to $13.265 $
 |  | After 10,000 Trials, the [NAME]. Error of the [NAME] is $0.008
 | Statistics: |  |  |  |  |  | Value
 |  | Trials |  |  |  |  | 10000
 |  | Mean |  |  |  |  | 9.982731235799688
 |  | Median |  |  |  |  | 9.985437940469769
 |  | Mode |  |  |  |  | ---
 |  | Standard Deviation |  |  |  |  | 0.82703151298592
 |  | [NAME] |  |  |  |  | 0.68398112347178
 |  | Skewness |  |  |  |  | 0.01285971460416562
 |  | Kurtosis |  |  |  |  | 3.079863404078643
 |  | [NAME]. of Variability |  |  |  |  | 0.08284621647631375
 |  | Range Minimum |  |  |  |  | 6.950044047601624
 |  | Range Maximum |  |  |  |  | 13.26504425286465
 |  | Range Width |  |  |  |  | 6.315000205263027
 |  | [NAME]. Error |  |  |  |  | 0.0082703151298592
Forecast:  Difference (A-B) |  |  |  |  |  |  |  |  | Cell:  I27
 | Summary:
 |  | Certainty Level is 46.03%
 |  | Certainty Range is from -Infinity to ($0.001)  $
 |  | Display Range is from ($2.500) to $2.500 $
 |  | Entire Range is from ($2.951) to $3.504 $
 |  | After 10,000 Trials, the [NAME]. Error of the [NAME] is $0.008
 | Statistics: |  |  |  |  |  | Value
 |  | Trials |  |  |  |  | 10000
 |  | Mean |  |  |  |  | 0.07908241937670914
 |  | Median |  |  |  |  | 0.07921248780182388
 |  | Mode |  |  |  |  | ---
 |  | Standard Deviation |  |  |  |  | 0.8052945666466075
 |  | [NAME] |  |  |  |  | 0.6484993390705474
 |  | Skewness |  |  |  |  | 0.0005292983368445415
 |  | Kurtosis |  |  |  |  | 3.044593820320882
 |  | [NAME]. of Variability |  |  |  |  | 10.18297837867841
 |  | Range Minimum |  |  |  |  | -2.950654134972382
 |  | Range Maximum |  |  |  |  | 3.50377859257297
 |  | Range Width |  |  |  |  | 6.454432727545352
 |  | [NAME]. Error |  |  |  |  | 0.008052945666466074
Spreadsheet: 163177d1340212083-if-index-match-problem-audits
Sheet: Don't Touch

Action | Unit Type | Month | Day | Year | Area |  | [NAME]
U | Vac | Jan | 1 | 2011 | [NAME] |  | Y
S | Pump | Feb | 2 | 2012 | ASHERTON |  | N
N/A | Winch | Mar | 3 |  | BONO |  | N/A
 | Combo | Apr | 4 |  | BRECKENRIDGE
 | [NAME] | May | 5 |  | [NAME]
 |  | Jun | 6 |  | CORPUS CHRISTI
 |  | Jul | 7 |  | CRESSON
 |  | Aug | 8 |  | DECATUR
 |  | Sept | 9 |  | EL CAMPO
 |  | Oct | 10 |  | KENEDY
 |  | Nov | 11 |  | LA GRANGE
 |  | Dec | 12 |  | LONGVIEW
 |  |  | 13 |  | MINDEN
 |  |  | 14 |  | MISSION
 |  |  | 15 |  | NACOGDOCHES
 |  |  | 16 |  | THREE RIVERS
 |  |  | 17 |  | [NAME]
 |  |  | 18 |  | VICTORIA
 |  |  | 19 |  | [NAME]
 |  |  | 20
 |  |  | 21
 |  |  | 22
 |  |  | 23
 |  |  | 24
 |  |  | 25
 |  |  | 26
 |  |  | 27
 |  |  | 28
 |  |  | 29
 |  |  | 30
 |  |  | 31
Spreadsheet: b09104a5-b50c-4d8e-8c78-71ef1264f053
Sheet: Sheet1

PROG ID | ATHLETE ID | ATHLETE FIRST | ATHLETE LAST | NATIONALITY | START NUMBER | RUN | T1 | BIKE | T2 | RUN.1 | POSITION | TOTAL TIME
258982 | 40031 | [NAME] | Gooding | GBR |  | 01:03:00 | 00:01:54 | 01:58:01 | 00:01:45 | [NAME] | 1 | 03:40:55
258982 | 58029 | Regine | Bette | GER |  | [NAME] | 00:01:51 | 01:56:15 | [NAME] | 00:37:51 | 2 | 03:44:53
258982 | 70556 | Boo | Alder | GBR |  | 01:16:39 | 00:02:10 | 02:01:06 | 00:01:59 | 00:39:53 | 3 | 04:01:44
258982 | 74523 | [NAME] | [NAME] | ESP |  | 01:13:40 | 00:02:13 | 02:07:33 | 00:02:18 | 00:40:59 | 4 | 04:06:41
258982 | 46666 | Heike | Steininger | GER |  | 01:11:06 | 00:01:58 | 03:04:33 | 00:00:00 | 00:00:00 | DNF | 00:00:00
Spreadsheet: louise_kitchen__24114__KO_Netco Grp _ EEs on 12-19
Sheet: Gas Vol

Gas Volume Management
GISID | EMPLOYEE_NAME | [NAME] | JOBGROUP
90012457 | ANASTAS, SHERRY L | [NAME] Mgmt | SPECSR-CS
90005487 | CALUB, [NAME] | Spec Volume Mgmt | SPEC-CS
90125044 | CHANCE, [NAME] | Spec Volume Mgmt | SPEC-CS
90137644 | KEITH, RYAN | Spec Volume Mgmt | SPEC-CS
90011831 | SCHUMACK, SHERLYN A | [NAME] Mgmt | SPECSR-CS
90012452 | SPEARS, CHRISTOPHER A | [NAME] Mgmt | SPECSR-CS
90011833 | WYNNE, RITA J | Mgr Volume Mgmt | MGR-CS
 |  | Employees
Spreadsheet: louise_kitchen__22642__Third Qtr Compare 00 - 01 A
Sheet: Sheet1

EOL 3rd Quarter Comparison  2000  vs. 2001
Date: 8/16/01
 | MTD - July 1 - August 15, 2000 |  |  |  | MTD - July 1 - August 15, 2001
Commodity | Deal Count | Volume | UOM |  | Deal Count | Volume | UOM
US Gas | 48269 | 8773146126.57 | MMBtu |  | 101219 | 16335634543.68 | MMBtu
Canadian Gas | 6819 | 656460526.5 | MMBtu |  | 6727 | 355753548.04 | MMBtu
Continental Gas | 138 | 15527500 | MMBtu |  | 352 | 25946711 | MMBtu
UK Gas | 2393 | 333680000 | MMBtu |  | 2126 | 326855139 | MMBtu
US Power | 4831 | 39224800 | MWh |  | 31519 | 286347047 | MWh
Continental Power | 1288 | 13244073 | MWh |  | 3587 | 36956582 | MWh
Nordic Power | 437 | 5530897 | MWh |  | 373 | 7177466 | MWh
UK Power | 260 | 10452960 | MWh |  | 495 | 27034320 | MWh
Crude & Products | 1627 | 52319000 | BBL |  | 10633 | 479919875.01 | BBL
LPG | 201 | 3349000 | BBL |  | 390 | 8788000 | BBL
Petrochemicals | 22 | 600000 | BBL |  | 46 | 476000 | BBL
Coal | 304 | 10798250 | TONNE |  | 85 | 2297500 | TONNE
Emissions | 104 | 260000 | Contracts |  | 13 | 32500 | Contracts
Paper and Pulp | 1 | 1000 | TONNE |  | 67 | 10274 | TONNE
Weather | 192 | 20800 | Contracts |  | 89 | 18301 | Contracts
Metals | 9 | 2798 | MT |  | 13750 | 4774329 | MT
Spreadsheet: 168066d1342204489-excel-2007-help-pay-scale-calculation-sheet-help-test-hourly-timesheet-7-12-12
Sheet: Hourly Timesheet

 |  |  | DATE:
Employee Name:
 |  |  |  |  |  | Daily Timesheet
Date | Time | Hours | Job # | Class | Pay Rate | Total Pay
 | 07:00:00
 | 07:05:00 |  | 1255 | ELEC
 | 08:05:00 |  | 1279 | A/C M
 | 09:05:00 |  | 1252 | INSUL
 | 10:30:00 |  | 1252 | ELEC T
 | 13:30:00 |  | 1252 | A/C SRVC
 | 16:00:00 |  | 1252 | A/C SRVC H
 |  |  | 1252 | ELEC T
 |  |  | 1252 | ELEC
 |  |  | 1252 | ELEC
 |  |  | 1252 | ELEC
 |  |  | 1252 | ELEC
 |  |  | 1252 | ELEC
 |  |  | 1252 | ELEC
 |  |  | 1252 | ELEC
 |  |  | 1252 | ELEC
 |  |  | 1252 | ELEC
 |  |  | 1252 | ELEC
 |  |  | 1252 | ELEC
 |  |  | 1252 | ELEC
 |  |  | 1252 | ELEC
 |  |  | 1252 | ELEC
Current Jobs |  |  | Job Classes | CODE | [NAME]
 | 1252
 | 1254 |  |  | A/C M | A/C MECHANIC
 | 1255 |  |  | A/C M H | A/C MECHANIC HELPER
 | 1257 |  |  | A/C SRVC | A/C SERVICE MAN
 | 1279 |  |  | A/C SRVC H | A/C SERVICE MAN HELPER
 | 1280 |  |  | CRPT | CARPENTER
 |  |  |  | ELEC | ELECTRICIAN
 |  |  |  | ELEC T | ELECTRICIAN TECHNICIAN
 |  |  |  | INSUL | ASBESTOS / INSULATION WORKER
 |  |  |  | IRON WRKR | IRON WORKER
 |  |  |  | LAB | LABORER
 |  |  |  | LAB S | LABORER SKILLED
 |  |  |  | LAB UN-S | LABORER UN-SKILLED
 |  |  |  | PLMB-PFTR | PLUMBER-PIPEFITTER (INCL. HVAC)
 |  |  |  | PLMB-PFTR H | PLUMBER-PIPEFITTER HELPER (INCL. HVAC)
 |  |  |  | SMW | SHEET METAL WORKER
 |  |  |  | SMW DUCT | SHEET METAL WORKER (DUCT)
 |  |  |  | SMW DUCT H | SHEET METAL WORKER (DUCT) HELPER
 |  |  |  | SMW OTHER | SHEET METAL WORKER (OTHER)
 |  |  |  | SMW ROOF | SHEET METAL WORKER (ROOF)
 |  |  |  | SMW ROOF H | SHEET METAL WORKER (ROOF) HELPER
Spreadsheet: 743411d1628488441-adjustment-of-if-formula-for-depreciation-to-accomodate-disposal-and-nondepreciating-asset-ifformulaattempt
Sheet: Sheet1

Kindly asking for help with if formula. I want if Life column is less than the period column, column  (I) do not culculate depreciation.
If column H is blank, no depreciation is calculated. Lastly if disposal occur in column L, no depreciation is calculated.
 |  |  |  |  |  |  |  | depreciation
 | Asset | Price | Year | Salvage | Life | Period | Method | 2021 | B/F Depreciation | Acc Depreciation | Disposal
 | Vehicles | 10000 | 2014 | 1000 | 10 |  | VDB |  |  |  | 0
 | Land | 10000 | 2014 | 1000 | 10 |  |  |  |  |  | 0
 | Vehicles | 10000 | 2014 | 1000 | 10 |  | DB |  |  |  | 0
 | Vehicles | 10000 | 2014 | 1000 | 10 |  | DDB |  |  |  | 30000
 | Vehicles | 10000 | 2014 | 1000 | 10 |  | VDB |  |  |  | 0
 | Desired solution
 | Asset | Price | Year | Salvage | Life | Period | Method | 2021 | B/F Depreciation | Acc Depreciation | Disposal
 | Vehicles | 10000 | 2014 | 1000 | 5 |  | VDB | 0 | 7902.848 | 8322.2784 | 0
 | Land | 10000 | 2014 | 1000 | 10 |  |  | 0 | 0 |  | 0
 | Vehicles | 10000 | 2014 | 1000 | 10 |  | DB |  |  |  | 0
 | Vehicles | 10000 | 2014 | 1000 | 10 |  | DDB | 0 |  | 0 | 30000
 | Vehicles | 10000 | 2014 | 1000 | 10 |  | VDB |  |  |  | 0
 |  |  |  | MY RESULT | Life | Period | Method | 2021 | B/F Depreciation | Acc Depreciation | Disposal
 |  |  |  |  | 5 | 8 | VDB |  |  |  | 0
 |  |  |  |  | 10 | 8 |  |  |  |  | 0
 |  |  |  |  | 10 | 8 | DB |  |  |  | 0
 |  |  |  |  | 10 | 8 | DDB |  |  |  | 30000
 |  |  |  |  | 10 | 8 | VDB |  |  |  | 0
Spreadsheet: 12b0aeed-30dc-407c-8af9-ef1cc8df78e5
Sheet: Form-Snack - Lunch-Supper Only

SFSP PRODUCTION RECORD
 |  |  |  |  | Sponsor Name:
 |  |  |  |  | Site Name:
 |  |  |  |  | Date:
 | Menu component | Menu | Food Item | Serving Size | Quantity Prepared | Leftovers & Recycled Milk | Number Served
SNACK AM-PM | (CHOOSE TWO) |  |  |  |  |  | Children:          ______
 | Meat/Meat Alternate
 |  |  |  |  |  |  | Prog. Adults:    ______
 | Bread/Bread Alternate
 |  |  |  |  |  |  | Non-Prog Adults: ____
 | Fruit/Vegetable
 |  |  |  |  |  |  | Total            _________
 | Milk
LUNCH-SUPPER | Meat/Meat Alternate
 |  |  |  |  |  |  | Children:          ______
 | Bread/Bread Alternate |  |  |  |  |  | Prog. Adults:    ______
 |  |  |  |  |  |  | Non-Prog Adults: ____
 | Fruit/Vegetable
 | Fruit/Vegetable |  |  |  |  |  | Total            _________
 | Milk
 | Other
NOTES:
Spreadsheet: 775496d1649151783-how-to-search-textstrings-for-mentions-match-mentions-and-get-variable-values-for-matches-registry-of-interest-check
Sheet: Registries

Edu1 Full name | Edu1 Forename | Edu1 Surname | Edu2 Full name | Edu2 Forename | Edu2 Surname | Edu3 Full name | Edu3 Forename | Edu3 Surname
 | Anders | [NAME] |  | Anders | [NAME] |  | Niklas | Persson
 | Anne | [NAME] |  | [NAME] | Sjöberg |  | [NAME] | Nilsson
 | Jeanette | Videborn |  |  |  |  | [NAME] | Sjöberg
 | [NAME] | Sjöberg
Spreadsheet: 759253d1639445742-need-help-merging-two-lists-to-a-third-custom-list-with-calculated-fields-2
Sheet: Sheet1

[NAME] | SKU | Είδος | Amount | [NAME] | [NAME] |  | [NAME] | SKU | Είδος | Amount | [NAME] | [NAME]
 |  |  |  |  |  |  |  |  |  |  |  |  |  | Custom sku | Custom Ammount | custom remaining m3
2246 | 10575 |  | 27 | ΚΙΒΩΤΙΑ | 1.06 |  | 2246 | 10575 |  | 28 | ΚΙΒΩΤΙΑ | 1.06
2245 | 10576 |  | 17 | ΚΙΒΩΤΙΑ | 0.77 |  | 2245 | 10576 |  | 17 | ΚΙΒΩΤΙΑ | 0.77 |  | 10576 |  |  | True | True
2244 | 10666 |  | 26 | ΚΙΒΩΤΙΑ | 1.04 |  | 2244 | 10666 |  | 26 | ΚΙΒΩΤΙΑ | 1.04 |  | 10666 |  |  | True | True
2243 | 10667 |  | 47 | ΚΙΒΩΤΙΑ | 1.79 |  | 2243 | 10667 |  | 47 | ΚΙΒΩΤΙΑ | 1.79 |  | 10667 |  |  | True | True
2247 | 11170 |  | 35 | ΚΙΒΩΤΙΑ | 1.44 |  | 2247 | 11170 |  | 35 | ΚΙΒΩΤΙΑ | 1.44 |  | 11170 |  |  | True | True
2242 | 11171 |  | 28 | ΚΙΒΩΤΙΑ | 1.62 |  | 2242 | 11171 |  | 28 | ΚΙΒΩΤΙΑ | 1.62 |  | 11171 |  |  | True | True
2256 | 201132 |  | 45 | ΚΙΒΩΤΙΑ | 2.13 |  | 2256 | 201132 |  | 45 | ΚΙΒΩΤΙΑ | 2.13 |  | 201132 |  |  | True | True
2255 | 201135 |  | 21 | ΚΙΒΩΤΙΑ | 1.29 |  | 2255 | 201135 |  | 21 | ΚΙΒΩΤΙΑ | 1.29 |  | 201135 |  |  | True | True
2241 | 210345 |  | 1 | ΚΙΒΩΤΙΑ | 0.08 |  |  | 212020 |  | 33 |  |  |  | 210345 |  |  | True | True
2267 | 212021 |  | 18 | ΚΙΒΩΤΙΑ | 2.45 |  | 2269 | 212023 |  | 1 | ΚΙΒΩΤΙΑ | 0.11 |  | 212020 |  |  | True | True
2268 | 212022 |  | 9 | ΚΙΒΩΤΙΑ | 1.44 |  | 2260 | 912579,912592 |  | 2891 | ΚΙΒΩΤΙΑ | 14.11 |  | 212021 |  |  | True | True
2269 | 212023 |  | 9 | ΚΙΒΩΤΙΑ | 1.01 |  | 2262 | 195010/195040/195050/195060/11269/11010 |  | 28 | ΚΙΒΩΤΙΑ | 4.65 |  | 212022 |  |  | True | True
2260 | 912579,912592 |  | 2891 | ΚΙΒΩΤΙΑ | 14.11 |  | 2259 | 20-041/20-002 |  | 501 | ΚΙΒΩΤΙΑ | 19.84 |  | 212023 |  |  | True | True
2262 | 195010/195040/195050/195060/11269/11010 |  | 28 | ΚΙΒΩΤΙΑ | 4.65 |  |  |  |  |  |  |  |  | 912579.912592 |  |  | True | True
2259 | 20-041/20-002 |  | 501 | ΚΙΒΩΤΙΑ | 19.84 |  |  |  |  |  |  |  |  | 195010/195040/195050/195060/11269/11010 |  |  | True | True
2257 | 210333_AN |  | 1 | ΚΙΒΩΤΙΑ | 0.04 |  |  |  |  |  |  |  |  | 20-041/20-002 |  |  | True | True
2265 | 210593_AN |  | 6 | ΚΙΒΩΤΙΑ | 0.96 |  |  |  |  |  |  |  |  | 210333_AN |  |  | True | True
2264 | 210593_ANA |  | 1 | ΚΙΒΩΤΙΑ | 0.08 |  |  |  |  |  |  |  |  | 210593_AN |  |  | True | True
 |  |  |  |  |  |  |  |  |  |  |  |  |  | 210593_ANA
Spreadsheet: 115969d1311426698-a-filtering-and-sum-type-function-filter-problem-v2
Sheet: Sheet1

 |  |  |  |  |  | Category |  |  |  |  |  |  | Subcategory |  |  | 9197
 |  |  |  |  |  | Overheating | Overheating |  |  |  |  |  | 598 |  |  | 1
 |  |  |  |  |  | Overheating |  |  |  |  |  |  | 288 |  |  | 6
 |  |  |  |  |  | Overheating |  |  |  |  |  |  | 343 |  |  | 2
 |  |  |  |  |  | Overheating |  |  |  |  |  |  | 312 |  |  | 6192
 |  |  |  |  |  | Overheating |  |  |  |  |  |  | 312 |  |  | 50
 |  |  |  |  |  | Overheating |  |  |  |  |  |  | 471 |  |  | 2
 |  |  |  |  |  | Overheating |  |  |  |  |  |  | 308 |  |  | 31
 |  |  |  |  |  | Shutting off | Shutting off |  |  |  |  |  | 344 |  |  | 2
 |  |  |  |  |  | Shutting off |  |  |  |  |  |  | 343 |  |  | 1
 |  |  |  |  |  | Shutting off |  |  |  |  |  |  | 288 |  |  | 3
 |  |  |  |  |  | Error Message | Error Message |  |  |  |  |  | 598 |  |  | 3
 |  |  |  |  |  | Error Message |  |  |  |  |  |  | 288 |  |  | 6
 |  |  |  |  |  | Error Message |  |  |  |  |  |  | 359 |  |  | 14
 |  |  |  |  |  | Error Message |  |  |  |  |  |  | 312 |  |  | 891
 |  |  |  |  |  | Error Message |  |  |  |  |  |  | 308 |  |  | 1
 |  |  |  |  |  | Error Message | Error Message |  |  |  |  |  | 598 |  |  | 1
 |  |  |  |  |  | Error Message |  |  |  |  |  |  | 288 |  |  | 2
 |  |  |  |  |  | Error Message |  |  |  |  |  |  | 312 |  |  | 961
 |  |  |  |  |  | Physical Defect | Physical Defect |  |  |  |  |  | 288 |  |  | 4
 |  |  |  |  |  | Error Message | Error Message |  |  |  |  |  | 598 |  |  | 1
 |  |  |  |  |  | Error Message |  |  |  |  |  |  | 288 |  |  | 12
 |  |  |  |  |  | Error Message |  |  |  |  |  |  | 312 |  |  | 1011
Spreadsheet: 178122d1346668460-putting-data-in-other-worksheets-corbinsbere-gundogs-competition
Sheet: Entrants

ENTRANTS NUMBER | HANDLERS NAME | DOGS NAME | SPECIAL PUPPY ([NAME]) (Y) | NOVICE ([NAME]) (Y) | OPEN ([NAME]) (Y)
1 | [NAME] | Storm | Y
2 | [NAME] | [NAME] |  | Y
3 | [NAME] | Poppy | Y
4 | [NAME] | Fly |  |  | Y
5 | [NAME] | Trish | Y
6 | [NAME] | Flyn
7 | [NAME] | [NAME] |  | Y
8 | [NAME] | Chick | Y
9 | [NAME] | Reba |  |  | Y
10
11
12
13
14
15
16
17
18
19
20
21
22
23
24
25
26
27
28
29
30
31
32
33
34
35
36
37
38
39
40
41
42
43
44
45
46
47
48
49
50
51
52
53
54
55
56
57
58
59
60
61
62
63
64
65
66
67
68
69
70
71
72
73
74
75
76
77
78
79
80
81
82
83
84
85
86
87
88
89
90
91
92
93
94
95
96
97
98
99
100
Spreadsheet: 860976d1708992699-embeding-qr-code-into-cell-engineering-store-system-
Sheet: INVENTRY

STORES CODE | OEM PART NUMBER | EQUIPMENT | [NAME] | STORES LOCATION | QR CODE | PART TYPE | QUANTITY | UNIT MEASURE | STORE VALUE | MIN STOCK | MAX STOCK | RATING | PRICE AUD | PREVIOUS PRICE | SUPPLIER CURRENCY | BUYING PREF | SUPPLIER | SUPPLIER CONTACT | SUPPLIER PHONE | SUPPLIER EMAIL | SUPPLIER LOCATION | LEAD TIME | NOTES | PHOTO HYPERLINK | DRAWING HYPERLINK |  |  |  | UNIT MEASURE | RATING | SUPPLIER CURRENCY | BUYING PREFERENCE
0001 | 1QAZ | VEEMAG | [NAME] | A01B01 |  | [NAME] | 1 | EA |  | 2 | 6 | CRITICAL | 123 | 123 | AUD | EA | ABC | DISNEY |  |  | USA | 0
0002 | 6002 2RS | FUJI OVER WRAPPER | SKF 6002 DEEP GROOVE BEARING | A02B02 | 1 | BEARING | 2 | EA |  | 2 | 6 | STANDARD | 234 | 234 | AUD | EA | BCD | NETFIX |  |  | USA | 0
0003 | 3EDC | DEPANNER | VALVE | A03B03 | 1 | VALVE | 3 | EA |  | 2 | 6 | CRITICAL | 345 | 345 | AUD | EA | CDE | APPLE |  |  | USA | 0
0004 | 4RFV | OVEN | FILTER | A04BO4 | 1 | FILTER | 4 | EA |  | 2 | 6 | STANDARD | 456 | 456 | AUD | EA | DEF | AMAZON |  |  | USA | 0
0005 | 5TGB | MIXER | MOTOR | A05B05 | 1 | MOTOR | 5 | EA |  | 2 | 6 | CRITICAL | 567 | 567 | AUD | EA | EFG | STAN |  |  | USA | 0
0006 | 6YHN | PALLET CONVEYOR | CLIPSAL SW320 | A06B06 | 1 | SWITCH | 6 | EA |  | 2 | 6 | STANDARD | 678 | 678 | USD | EA | FGH | DISNEY |  |  | USA | 0
0007 | 7UJM | METAL DETECTOR | [NAME] | [NAME] | 1 | BEARING | 7 | EA |  | 2 | 6 | CRITICAL | 789 | 789 | USD | EA | GHI | NETFIX |  |  | USA | 0
0008 | 0OKM | CHECK WEIGHER | DRIVE BELT | A07B08 | 1 | BELT | 8 | EA |  | 2 | 6 | STANDARD | 890 | 890 | USD | EA | HIJ | APPLE |  |  | USA | 0
0009 | [NAME] | SLICER | AB, 3P, 600V, 40A | A07B09 | 1 | CONTACTOR | 9 | EA |  | 2 | 6 | CRITICAL | 901 | 901 | USD | EA | IJK | AMAZON |  |  | USA | 0
0010 | 8UB | RACK | SICK 1234 ZP | A07B10 | 1 | SENSOR / PE | 10 | EA |  | 2 | 6 | STANDARD | 23 | 23 | USD | EA | JKL | STAN |  |  | USA | 0
0011
0012
Spreadsheet: 107809d1304967110-lookup-value-on-seperate-sheet-based-upon-cell-value-book1
Sheet: SHIPPED PARTS

Part Number | Old Part Number | Material | Heat Number | Sheet Qty | Part Qty | Forcasted Yield | Difference | [NAME]
S00104260000 | 6030395 | .156 46177 | [NAME] | 7 | 200 | 196 | 4
S00104260000 | 6030395 | .156 46177 | [NAME] | 2 | 79 | 56 | 23
S00104310000 | 6030394 | .156 46177 | [NAME] | 4 | 120 | 120 | 0
S00100670000 | 6042084 | .140 46177 | A27136-- | 17 | 297 | 272 | 25
S00109700000 | 6031737 | .25 12560-1 | R8239--2BC | 6 | 69 | 72 | -3
S00109720000 | 6031748 | .25 12560-1 | R8239--4BB | 6 | 73 | 72 | 1
D00104270000 | 6030136 | .25 A36 |  |  | 381 | 0 | 381
S00100630000 | 6042085 | .140 46177 | A27136-- | 15 | 299 | 240 | 59
S00104220000 | 6030747 | .375 12560-1 | 0947L-77944- | 2 | 125 | 128 | -3
S00104310000 | 6030394 | .156 46177 | A26240-- | 5 | 148 | 150 | -2
S00104310000 | 6030394 | .156 46177 | [NAME] | 6 | 167 | 180 | -13
[NAME] | 6042494 | .25 A36 |  |  | 361 | 0 | 361
S00109710000 | 6031738 | .25 12560-1 | R7726--3BB | 4 | 16 | 48 | -32
S00109710000 | 6031738 | .25 12560-1 | [NAME] | 6 | 49 | 72 | -23
S00109710000 | 6031738 | .25 12560-1 | R8239--4BA | 2 | 23 | 24 | -1
S00089290000 | 6042088 | .140 46177 | A27136-- | 9 | 403 | 405 | -2
[NAME] | 6042494 | .25 A36 |  |  | 372 | 0 | 372
S00088380000 | 6030568 | .25 12560-1 | R8239--39CG | 2 | 280 | 280 | 0
S00100670000 | 6042084 | .140 46177 | A27136-- | 14 | 241 | 224 | 17
S00104250000 | 6030056 | .312 12560-1 | R7735--3CF | 5 | 30 | 30 | 0
S00104250000 | 6030056 | .312 12560-1 | R7735--3CD | 5 | 30 | 30 | 0
S00104250000 | 6030056 | .312 12560-1 | R7735--3CC | 5 | 30 | 30 | 0
S00104410000 | 6030055 | .312 12560-1 | 4374J-5030- | 5 | 30 | 20 | 10
S00104250000 | 6030056 | .312 12560-1 | 4374J-5031- | 5 | 30 | 30 | 0
S00104250000 | 6030056 | .312 12560-1 | R7735--39CE | 5 | 30 | 30 | 0
S00104250000 | 6030056 | .312 12560-1 | R7735--39BC | 1 | 5 | 6 | -1
S00104410000 | 6030055 | .312 12560-1 | R7735--3CA | 5 | 20 | 20 | 0
S00104410000 | 6030055 | .312 12560-1 | R7735--1BG | 3 | 12 | 12 | 0
S00104410000 | 6030055 | .312 12560-1 | R7735--3CG | 5 | 20 | 20 | 0
S00104410000 | 6030055 | .312 12560-1 | R7735--39AG | 4 | 16 | 16 | 0
S00104260000 | 6030395 | .156 46177 | B29723-- | 2 | 56 | 56 | 0
S00104260000 | 6030395 | .156 46177 | A26240-- | 3 | 83 | 84 | -1
S00104260000 | 6030395 | .156 46177 | [NAME] | 2 | 56 | 56 | 0
S00104410000 | 6030055 | .312 12560-1 | R7735--3CB | 5 | 20 | 20 | 0
S00104410000 | 6030055 | .312 12560-1 | R7735--39AG | 1 | 4 | 4 | 0
S00104220000 | 6030747 | .375 12560-1 | 0947L-77944- | 3 | 193 | 192 | 1
S0087410000 | 6030596 | .25 46100 | R8005--2AC | 2 | 182 | 182 | 0
S0087410000 | 6030596 | .25 46100 | M09401-07J2129-D24 | 3 | 270 | 273 | -3
Spreadsheet: 785611d1656513608-maxium-number-book1
Sheet: Sheet1

3
4
13
6
5
8
7
8
4
8
3
2
1
Spreadsheet: 598686d1542653318-calculating-win-streak-last-10-games-only-winstreaklast10
Sheet: WS

 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | WS last 10 | WinStreak | WS High
A | n/a | n/a | n/a | n/a | n/a | n/a | n/a | n/a | n/a | n/a | n/a | n/a | n/a | n/a | n/a | n/a | n/a | 1 |  |  |  | 1
B | n/a | n/a | n/a | n/a | n/a | n/a | n/a | n/a | n/a | n/a | n/a | 1 | 1 | 1 | 1 | 1 | 1 | 1 |  |  |  | 7
C | 0 | 1 | 1 | 1 | 1 | 1 | 1 | 1 | 1 | 1 | 1 | 1 | 1 | 1 | 1 | 1 | 1 | 1 |  |  |  | 31
D | 1 | 1 | 1 | 1 | 1 | 1 | 1 | 1 | 1 | 1 | 1 | 1 | 1 | 1 | 1 | 1 | 1 | 1 |  |  |  | 46
E | 1 | 1 | 1 | 1 | 1 | 1 | 1 | 1 | 1 | 1 | 1 | 1 | 1 | 1 | 1 | 1 | 1 | 1 |  |  |  | 33
F | 1 | 1 | 1 | 1 | 1 | 1 | 1 | 1 | 1 | 1 | 1 | 0 | 1 | 1 | 1 | 1 | 1 | 0 |  |  |  | 18
G | 1 | 1 | 1 | 1 | 1 | 1 | 1 | 0 | 1 | 1 | 1 | 1 | 1 | 1 | 1 | 1 | 1 | 0 |  |  |  | 15
H | 1 | 0 | 1 | 1 | 0 | 0 | 1 | 1 | 1 | 1 | 1 | 1 | 1 | 1 | 1 | 1 | 1 | 1 |  |  |  | 12