tianzl66/Sheetpedia huggingface dataset:
Spreadsheet: 845214d1696749322-vba-hotel-gantt-chart-with-merged-cells-and-details-of-booking-hotel
Sheet: Data

Direct |  | 1 |  | BACS
Booking |  | 2 |  | Cheque |  | 2 [NAME] |  | 2
 |  | 3 |  | Cash |  | 3 [NAME]
 |  | 4 |  |  |  | 4 Karen Douglas
 |  | 5 |  |  |  | 5 [NAME]
 |  | 6 |  |  |  | 6 [NAME]
 |  | 7
 |  | 8
 |  | 9
 |  | 10
 |  | 11
 |  | 12
Spreadsheet: 824597d1680701215-use-vlookup-and-if-or-sort-unique-and-frequency-sample-data-tryingtohard-
Sheet: Sheet1

Worker ID | [NAME] |  |  |  | Worker ID | Consecutive Weeks
12345678 | 2022-10-09 00:00:00
12345678 | 2022-10-16 00:00:00 |  |  |  | 345987
12345678 | 2022-10-23 00:00:00 |  |  |  | 713190
12345678 | 2022-10-30 00:00:00 |  |  |  | 743911
12345678 | 2022-11-06 00:00:00 |  |  |  | 765402
12345678 | 2022-11-13 00:00:00 |  |  |  | 1645089
12345678 | 2022-11-20 00:00:00 |  |  |  | 12345678
345987 | 2023-01-01 00:00:00 |  |  |  | 66042154
345987 | 2023-01-08 00:00:00 |  |  |  | Worker ID
345987 | 2023-01-15 00:00:00 |  |  |  | 0
345987 | 2023-01-01 00:00:00
345987 | 2023-01-29 00:00:00
345987 | 2023-02-05 00:00:00
1645089 | 2022-09-25 00:00:00
1645089 | 2022-10-02 00:00:00
1645089 | 2022-10-09 00:00:00
713190 | 2023-01-01 00:00:00
713190 | 2023-01-08 00:00:00
713190 | 2023-01-15 00:00:00
713190 | 2023-01-22 00:00:00
713190 | 2023-01-29 00:00:00
125777 | 2023-01-01 00:00:00
125777 | 2023-01-08 00:00:00
125777 | 2023-01-15 00:00:00
125777 | 2023-01-22 00:00:00
125777 | 2023-01-29 00:00:00
743911 | 2022-12-18 00:00:00
743911 | 2022-12-25 00:00:00
743911 | 2023-01-15 00:00:00
765402 | 2022-12-18 00:00:00
765402 | 2022-12-25 00:00:00
765402 | 2023-01-15 00:00:00
66042154 | 2022-11-27 00:00:00
66042154 | 2022-12-04 00:00:00
66042154 | 2022-12-11 00:00:00
66042154 | 2022-12-18 00:00:00
Spreadsheet: chris_germany__2914__02 2000 GELP OIL BY VENDOR
Sheet: Monthly Summary

 | 2000-02-01 00:00:00 | SUMMARY OF FUEL OIL DELIVERIES TO GORDONSVILLE
 | COMMENTS | Plant Recorded Off-Load Meter Reading |  | BP AMOCO "GROSS" DELIVERED | MARATHON ASHLAND "GROSS" DELIVERED | CITGO    "GROSS" DELIVERED
 | Current Month Ordered |  |  | 0 | 75000 | 0
 | pending from previous month |  |  | 165000 | 58351 | 359949
 | Current Month Delivery
 | ESTIMATED Gallons still unaccounted for… | 0 | 0
 |  |  |  |  |  | remaining CITGO not available and will be credited
 | MONTH BEGINNING TANK INVENTORY | ? | (AS STRAPPED BY PLANT)
 | PLANT RECORDED OFFLOAD TOTAL
 | ALL SUPPLIERS "GROSS" DELIVERY RECORD
 | TOTAL DIFFERENCE, Current month
Note: |  |  | ESTIMATED COST SUMMARY (based on BOL, not invoice)
 |  |  |  | "Gross" Gallons Delivered
 |  |  |  | [NAME]. Cost per gallon | 0
 |  |  |  | Estimated Cost of Oil for Month
Spreadsheet: 467202d1466613175-match-up-the-sku-numbers-between-two-pages-and-transfer-the-prices-sku-and-price
Sheet: AFTER

If it is only possible to match up the existing SKUs from Sheet 1 to Sheet 2, then this is the final outcome I am looking for:
SKU | PRICE |  | WHAT
1120-PAR | 155.7248 | Wrong | Parent
1120 | 43.45 | Correct | Box
1120-s | 1.87 | Correct | Sample
16004131TPWV-PAR | 33.9 | Wrong | Parent
16004131TPWV | 85.32 | Correct | Box
16004131TPWV-s | 4.24 | Correct | Sample
17-1700-PAR | 53.25339600000001 | Wrong | Parent
17-1700 | 33.27 | Correct | Box
17-1700-s | 1.87 | Correct | Sample
If it's possible, this other option would be ideal: I need the Parent and Box Prices to be the same as the Box prices on sheet 1, and the Sample price should be the same as the sample prices on sheet 1.
SKU | PRICE |  | WHAT
1120-PAR | 43.45 | Correct | Parent
1120 | 43.45 | Correct | Box
1120-s | 1.87 | Correct | Sample
16004131TPWV-PAR | 85.32 | Correct | Parent
16004131TPWV | 85.32 | Correct | Box
16004131TPWV-s | 4.24 | Correct | Sample
17-1700-PAR | 33.27 | Correct | Parent
17-1700 | 33.27 | Correct | Box
17-1700-s | 1.87 | Correct | Sample
Spreadsheet: 201283d1355937329-link-sheets-so-that-so-that-values-are-automatically-updated-example
Sheet: Sunday

Sunday | 2012-12-09 00:00:00 |  |  | Prepared by: | [NAME] | Sales Goal: | 79000
 |  | Daily Focus: | Approach |  |  | LY: | 54000
Name | Shift Start | Shift End | Signature | Time in | Time Out | Time in | Time Out | 05:00:00 | 06:00:00 | 07:00:00 | 08:00:00 | 09:00:00 | 10:00:00 | 11:00:00 | 12:00:00 | 13:00:00 | 14:00:00 | 15:00:00 | 16:00:00 | 17:00:00 | 18:00:00 | 19:00:00 | 20:00:00 | 21:00:00 | 22:00:00 | 23:00:00 | 1900-01-01 00:00:00
[NAME] | 08:00:00 | 17:00:00 | This area would be used for the employees to sign in and out
[NAME] | 15:00:00 | 22:00:00
[NAME] | 13:00:00 | 17:00:00
[NAME] | 13:00:00 | 16:00:00
Spreadsheet: 2a574487-6478-4971-84a1-fe14d829235b
Sheet: Sheet1

To determine the amount for private vehicle mileage reimbursement, please fill in the yellow highlighted fields.  Personal reimbursement will be at the Hertz Full Size rate or the Employee Car/Minivan rate, whichever is less.  If no FHSU Motor Pool vehicle or Hertz vehicle is available, $0.56 per mile will be the reimbursement rate.  The traveler is not required to use Hertz as the rental company. | Unnamed: 1 | Unnamed: 2 | Unnamed: 3 | Unnamed: 4 | Unnamed: 5 | Unnamed: 6 | Unnamed: 7 | Unnamed: 8 | Unnamed: 9 | Unnamed: 10 | Unnamed: 11 | Unnamed: 12 | Unnamed: 13 | Unnamed: 14 | Unnamed: 15 | Unnamed: 16 | Unnamed: 17
[NAME]'s Name:
PR #:
PO #:
Check Applicable:
 | Pretrip Estimate
 | Complete prior to submitting a PR. Form to be retained by department.
 | Actual Expense
 | Complete after traveler returns. Form to be sent to Accounts Payable along with travel receipts.
Number of Days Vehicle is Required:
Total Miles Driven:
KDOT mileage chart: |  |  |  |  |  | http://kdotapp2.ksdot.org/mileagebetweencities/
Return Travel Date: |  |  |  |  |  |  |  |  | Travel Date must be 07/01/14 or later
Reimbursement Calculation
Employee Car/Minivan when [NAME] is available ($0.22 plus estimated fuel per mile) |  |  |  |  | Employee Car/Minivan when [NAME] and [NAME] NOT available ($0.56 per mile) |  |  |  | Hertz Full Size  rate including the Cost of Fuel |  |  |  |  |  | Department may reduce the rate or limit the amount to be reimbursed.
 |  |  |  |  | 0
Vehicle Data
Current Cost of Fuel per Gallon |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | per gallon
Estimated Miles per Gallon for Rental Full Size |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 25 | miles/gallon
Employee Car/Minivan Rate when Motor [NAME] is available |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | per mile
Employee Car/Minivan Rate when [NAME] and Hertz Vehicle NOT available |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 0.56 | per mile
Hertz Full Size Rate (Unlimited Miles) |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 33.5 | per day
Gas price updated as of |  |  |  |  |  | 2014-08-28 00:00:00
Hertz Contract 37354  Awarded 11-01-12
Comments:
Spreadsheet: 758576d1638957543-extracting-same-cell-data-from-multiple-worksheets-variation-tracker
Sheet: Additional Works Summary Sheet

Project Name
Project Number
EOL Forecast Dated
Ref | Description of Works | Date | Quotation Value £ | Estimated Value/Achieved value  % | Estimated Value/Achieved value  £ | Add to forecast (Y) | Staff | Labour | Plant | Permanent Materials | Temporary Materials | Sub-Contractors | Overhead and Profit | Total
 |  |  |  | 0.8 |  | Y
 |  |  |  | 0
TOTAL
Spreadsheet: 204056d1357329054-data-entry-using-excel-2010-denkai-animal-subsidized-vet-clinic-pack-solution
Sheet: State List

AL
AK
AZ
AR
CA
CO
CT
DE
FL
GA
HI
ID
IL
IN
IA
KS
KY
LA
ME
MD
MA
MI
MN
MS
MO
MT
NE
NV
NH
NJ
NM
NY
NC
ND
OH
OK
OR
PA
RI
SC
SD
TN
TX
UT
VT
VA
WA
WV
WI
WY
Spreadsheet: mary_fischer__25605__926
Sheet: E31.XLS

ENRON CORP AND CONSOLIDATED SUBSIDIARIES
COMPANY 0926
COMPANY NAME Artemis Associates
RECONCILIATION OF STOCKHOLDERS' EQUITY AND INVESTMENT IN SUBS
FOR THE PERIOD ENDING 6-30-2001
PREPARED BY: [NAME]
EXTENSION : 52580 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | E-31
 |  |  |  | 12-31-00 Balance |  |  |  | EQUITY IN |  | DIVIDENDS DECLARED |  |  |  | OTHER ACTIVITY
 |  |  |  | DR  (CR) |  | RECLASS 00 NI |  | EARNINGS |  |  |  |  |  |  |  |  |  | DR  (CR)
 |  | Hyp line |  | BEG BALANCE |  | TO BEG RE |  | /LOSSES |  | COMMON |  | PREFERRED |  | DR (CR) |  | (Describe) |  | END BALANCE
Shareholders Equity by Parent |  | Reverse signs from Hyperion
Common Stock |  | 0901
Paid in Capital |  | 0910
Contribution Received from Parent |  | 0915 |  | -132994575
RE - Beg Bal |  | 0920 |  | -14814197 |  | -18709236
RE - Net Income |  | 0930 |  | -18709236 |  |  |  | 17777997
RE - Net Income (Fair Value Adjustment) |  | 0931
Dividends Decl - Preferred Stock |  | 0935
Dividends Decl - Common Stock |  | 0941
Invest in Subs Plug Account |  | 0942 |  |  |  |  |  | -2
Total Shareholders' Equity |  | TOT_SHARE_EQU
Net Income |  | NET_INCOME
PARENT'S CO #
Investment in Consol Sub (on Parent Books) |  |  |  | Same signs as Hyperion
Investment in CS |  | 0215
Investment in PIC (contrib by parent) |  | 0216
Investment in Equity earnings of sub |  | 0217
Total Investment in Consol Sub
Equity in Consol Sub |  | 1505
Difference between SE (on sub) and Invest (on parent)
Reasons for Differences
A schedule will need to be prepared for each subsidiary.
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | E-31
Spreadsheet: 805759d1668894966-search-tab-for-specific-text-then-offset-from-the-cell-containing-that-text-example
Sheet: Fund 1

 | Transaction Links | Dates | 2022-12-31 00:00:00
 |  | Distributions | 0 | 7.897033991517565 | 0 | 6.013480804520922 | 0 | 4.53544394332155 | 0 | 3.431886901881908
 |  | Distributions | 22.43017550062175 | 0 | 173.8117556586841 | 0 | 202.6633774997705 | 0 | 267.6713243095267 | 0
 |  | Fees | 8.485899289745902 | -0.1362003731834112 | 57.63091617980378 | -0.06897445300892191 | 73.80052705637746 | -2.20400153396699 | 96.91867028270889 | -0.4353141557889346
 |  | Distributions | 0.9926080509970963 | -0.07056994952756433 | 6.849465590579263 | -0.05373802839342566 | 8.968512089571465 | -0.35951927333282 | 11.78152681095504 | -0.09446610722979704
 |  | Capital Calls | 0.9926080509970963 | -0.07056994952756433 | 6.849465590579263 | -0.05373802839342566 | 8.968512089571465 | -0.35951927333282 | 11.78152681095504 | -0.09446610722979704
Spreadsheet: 218681d1362535960-how-can-i-get-rid-of-the-num-error-if-the-loan-is-only-for-20-yrs-and-i-have-a-30-yr-table-mortgage-calculator
Sheet: Calculator

Calculator [NAME]
Original Loan | 270000
Annual Interest Rate | 0.0575
Loan duration in Years | 20
Number of Periods per Year | 12
Monthly Payment
Amortization Table
Period | Remaining Principal | Interest Payment | Principal Payment
1
Spreadsheet: 94394d1294233313-excel-2007-show-hide-names-vacation-calendar-2011-overzicht-verlof-werf-kantoor
Sheet: Werf

 |  |  | VERLOFREGELING   2011 : WERF
 | Maandag | 3 | Januari | 2011 |  | NIEUWJAAR
 | Dinsdag | 4 | Januari | 2011 |  | C.A.O.
 | tot Vrijdag | 7 | Januari | 2011 |  | C.A.O.
 | Donderdag | 21 | April | 2011 |  | KB 213
 | Vrijdag | 22 | April | 2011 |  | KB 213
 | Maandag | 25 | April | 2011 |  | Pasen
 | Maandag | 2 | [NAME] | 2011 |  | FEEST VAN DE ARBEID
 | Donderdag | 2 | Juni | 2011 |  | OH HEMELVAART
 | Vrijdag | 3 | Juni | 2011 |  | KB 213
 | Maandag | 13 | Juni | 2011 |  | PINKSTEREN
 | Maandag | 11 | [NAME] | 2011 |  | VERLOF
 | tot Woensdag | 20 | [NAME] | 2011 |  | VERLOF
 | Donderdag | 21 | [NAME] | 2011 |  | NATIONALE FEESTDAG
 | Vrijdag | 22 | [NAME] | 2011 |  | VERLOF
 | tot vrijdag | 29 | [NAME] | 2011 |  | VERLOF
 | Maandag | 15 | Augustus | 2011 |  | OLV HEMELVAART
 | Dinsdag | 1 | November | 2011 |  | ALLERHEILIGEN
 | Vrijdag | 11 | November | 2011 |  | WAPENSTILSTAND
 | Maandag | 26 | December | 2011 |  | KERSTMIS
 | Dinsdag | 27 | December | 2011 |  | KB 213
 | tot Woensdag | 28 | December | 2011 |  | KB 213
 | Donderdag | 29 | December | 2011 |  | C.A.O.
 | tot Vrijdag | 30 | December | 2011 |  | C.A.O.
Het personeel dat op één dezer data om dienstredenen moet aanwezig zijn, mag deze dagen op een ander tijdstip
nemen.
Het personeel [NAME], [NAME] en/of de Belgische werven, die [NAME] zijn in het
37 3/4 uren systeem en die leidinggeven aan en/of samenwerken met de arbeiders zullen voor de periode van
11.07.2011 tot en met 29.07.2011 collectief verlof opnemen. Voor deze vakantieperiode moeten zij wel een verlofbrief
opmaken.
Spreadsheet: 80235d1280423172-transfer-data-between-tabs-example-engineering
Sheet: Project

 |  |  |  |  |  |  |  |  |  |  |  |  |  |  | January |  |  |  |  | February |  |  |  | March
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 2010-01-02 00:00:00 | 2010-01-09 00:00:00 | 2010-01-16 00:00:00 | 2010-01-23 00:00:00 | 2010-01-30 00:00:00 | 2010-02-06 00:00:00 | 2010-02-13 00:00:00 | 2010-02-20 00:00:00 | 2010-02-27 00:00:00 | 2010-03-06 00:00:00 | 2010-03-13 00:00:00 | 2010-03-20 00:00:00 | 2010-03-27 00:00:00
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  | - | - | - | - | - | - | - | - | - | - | - | - | -
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 2009-12-27 00:00:00 | 2010-01-03 00:00:00 | 2010-01-10 00:00:00 | 2010-01-17 00:00:00 | 2010-01-24 00:00:00 | 2010-01-31 00:00:00 | 2010-02-07 00:00:00 | 2010-02-14 00:00:00 | 2010-02-21 00:00:00 | 2010-02-28 00:00:00 | 2010-03-07 00:00:00 | 2010-03-14 00:00:00 | 2010-03-21 00:00:00
 |  |  |  | Construction | Construction | Construction | Construction | Construction | Construction | Projected | Projected |  | Construction
 |  |  |  | Start | Contract | Ending | Observation | Observation | Observation | Hours | Budget | Contract | Observer | Rate
Job No | Job Description | Client | Project Mgr | Date | Days | Date | Budget | Used to Date | Remaining | Impact | Remaining | Multiplier | Name | Type
12-351 | Sewer Project | Best Waste | Daffy Duck | 2010-01-01 00:00:00 | 60 | 2010-04-01 00:00:00 | 15000 | 11000 |  |  |  |  | [NAME] |  | 4 | 9 |  |  |  |  |  |  |  |  |  | 2
12-352 | Water Project | Nestle | Snoopy | 2010-02-01 00:00:00 | 30 | 2010-03-01 00:00:00 | 2000 | 1000 |  |  |  |  | [NAME] |  | 3 | 1 |  |  |  |  |  |  |  |  |  | 1
12-353 | Pipeline Project | Exxon Mobil | Popeye | 2010-03-01 00:00:00 | 60 | 2010-05-01 00:00:00 | 12500 | 4375 |  |  |  |  | Fog Horn Leg Horn |  | 5 | 6 |  |  |  |  |  |  |  |  |  | 8
Spreadsheet: 838971d1691573950-find-several-values-separated-by-a-comma-and-return-a-value-with-no-duplicates-search-dataset-save-file-mve-1-
Sheet: Blad5

Art | RS | #
Intern | 5.01
Intern | 5.04
Intern | 5.08
Intern | 5.09
Intern | 6.02
Intern | 6.04
Intern | 6.06
Intern | 6.14
Intern | 6.15
Intern | 6.17
Intern | 6.26
Intern | 6.32
Intern | 6.38
Intern | 6.51
Intern | 6.60
Intern | 6.68
Intern | 6.74
Intern | 6.85
Spreadsheet: 11a177d5-5f98-45f2-bfe1-b64228f60bec
Sheet: Block 8

Block 8
Sub-mainline Sizing and Pressure
 | 150 | C-value for PVC ID > 5"
 | 145 | C-value for PVC 1.5" < = ID < =  5"
 | 140 | C-value  for PVC < 1.5"
 | 0 | feet, Total Elevation Drop
 | 235.5 | feet, Length of Sub-mainline
 |  | ft/ft, Change in Elevation
 | 0.5 | GPH/emitter
 |  | GPM/emitter
 |  | ft, emitter spacing
 | Chg. Elev = Length * ft/ft (elevation change worst case)
 | Chg. P = Chg. Elev + Hf
Section A Uphill
Row | Row Length ft | GPM per Row | Pressure PSI | Length ft | GPM | Pipe ID, in | Velocity, ft/sec | C-Value | Hf (psi) | Chg. Elev (psi) | Chg. P (psi)
Inlet | 0 | 0 | 25 | 0 | 46.3 | 2.193
1 | 522 |  |  | 2.2 |  | 2.193
 | 522.1 |  |  | 7.7 |  | 2.193
 | 522.2 |  |  | 7.7 |  | 2.193
 | 522.3 |  |  | 7.7 |  | 2.193
 | 522.3 |  |  | 7.7 |  | 2.193
 | 522.4 |  |  | 7.7 |  | 2.193
 | 522.5 |  |  | 7.7 |  | 2.193
 | 522.6 |  |  | 7.7 |  | 1.72
 | 522.7 |  |  | 7.7 |  | 1.72
 | 522.8 |  |  | 7.7 |  | 1.72
 | 522.9 |  |  | 7.7 |  | 1.72
 | 523 |  |  | 7.7 |  | 1.72
 | 523.1 |  |  | 7.7 |  | 1.72
 | 523.2 |  |  | 7.7 |  | 1.72
 | 523.3 |  |  | 7.7 |  | 1.72
 | 523.4 |  |  | 7.7 |  | 1.72
 | 523.5 |  |  | 7.7 |  | 1.72
 | 523.6 |  |  | 7.7 |  | 1.72
 | 523.7 |  |  | 7.7 |  | 1.72
 | 523.8 |  |  | 7.7 |  | 1.72
 | 523.9 |  |  | 7.7 |  | 1.72
 | 524 |  |  | 7.7 |  | 1.72
 | 524 |  |  | 7.7 |  | 1.72
 | 524.1 |  |  | 7.7 |  | 1.72
 | 524.2 |  |  | 7.7 |  | 1.72
 | 524.3 |  |  | 7.7 |  | 1.72
 | 524.4 |  |  | 7.7 |  | 1.72
 | 524.5 |  |  | 7.7 |  | 1.72
 | 524.6 |  |  | 7.7 |  | 1.72
 | 524.7 |  |  | 7.7 |  | 1.72
 | 524.8 |  |  | 7.7 |  | 1.72
 |  | Min P |  | PSI
 |  | [NAME] |  | PSI
 |  | Avg. P, PSI
 | Total GPM
 | Sub-Main Length, ft
Spreadsheet: 845475d1696972730-problem-with-league-table-golfscoresmultiplayerliveck76
Sheet: Summary

 | Golf Scores - Team Summary |  |  |  |  |  |  |  |  |  | Team: | Team2
 | Rounds Played |  |  |  | High Score |  |  |  |  |  |  |  |  | Data Entry |  |  | Below Par
 |  |  |  |  | [NAME] |  |  |  |  |  |  |  |  | Par |  |  | Most frequent
 |  | 1st | 2nd | 3rd | 4th | 5th | 6th | 7th | 8th | 9th | Front | 10th | 11th | 12th | 13th | 14th | 15th | 16th | 17th | 18th | Back | Total
 | Course Par | 4 | 4 | 3 | 5 | 4 | 4 | 4 | 3 | 4 |  | 4 | 4 | 3 | 4 | 5 | 3 | 4 | 4 | 5
 | HighScore
 | AvScore
 | <= -3 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | -3
 | Eagles |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | -2
 | Birdies |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | -1
 | Pars |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 0
 | Bogeys |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 1
 | Double Bogeys |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 2
 | >= +3 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 3
 | Total
Spreadsheet: 180761d1347740774-formula-for-summing-time-elapsed-within-a-certain-hours-timecard
Sheet: Sheet1

 |  |  | Regular | 12% Differential | 15% Differential | Overtime 50% Differential |  |  | 0.13 | 0.2 | 0.33 | 0.13
in | out | time elapsed | R1 (07:00am-12:59pm) | R2 (01:00pm-10:59pm) | R3 (11:00pm-06:59am) | R1 | R2 | R3 | Weekend Differential | Premium Night Differential | Premium Weekend | Holiday Differential | Total
2012-09-14 18:45:00 | 2012-09-15 19:15:00
Week1
Week2
Total Hrs
Regular Rate | 24
Premium Diff | 0.2
NightShift Diff 3-11p | 0.12
NightShift Diff 11p-7a | 0.15
WeekendShift Diff | 0.13
Holiday Diff | 0.13
Spreadsheet: 803819d1667725548-how-to-do-fast-replacing-of-row-number-accross-different-columns-copy-of-baza-nova-verzija-racuni-1-
Sheet: R22

Ime artikla
Spreadsheet: 7599bca3-a2a0-409a-a143-94e117b176b8
Sheet: Sheet1

PROG ID | ATHLETE ID | ATHLETE FIRST | ATHLETE LAST | NATIONALITY | START NUMBER | SWIM | T1 | BIKE | T2 | RUN | POSITION | TOTAL TIME
265141 | 19245 | [NAME] | Kazmierczak | POL |  | 00:09:26 | 00:00:23 | 00:18:45 | 00:00:24 | 00:04:52 | 1 | 00:33:50
265141 | 64282 | Kacper | Stepniak | POL |  | 00:09:25 | 00:00:25 | 00:18:46 | 00:00:29 | 00:05:01 | 2 | [NAME]
265141 | 42268 | [NAME] | Rak | POL |  | 00:09:36 | [NAME] | 00:19:09 | 00:00:27 | 00:04:43 | 3 | 00:34:21
Spreadsheet: 474724d1470867419-returning-greatest-and-lowest-value-involving-index-match-formula-sample
Sheet: lookup

POSITVE VALUE | NEGATIVE VALUE | PO Number |  | ALREADY ACCRUED (Non-NFSA) | Amount
Spreadsheet: 674815d1588025302-help-with-pulling-in-rows-from-another-sheet-based-on-a-persons-name-template
Sheet: Customer List

Grower | Area | Sub Area | Home 1/4 | Acres | Service | Contact Name | Phone Number | Landline/Other | [NAME] | Sort | Notes | CSM | Student
Grower 1 | Area 1 | Sub Area 1 | Home qrt 1 | 1000 | Service 1 | Name 1 | Number 1 | LL 1 | Email 1 | 1 | Notes 1 | Person 1 | Zach
Grower 2 | Area 2 | Sub Area 2 | Home qrt 2 | 2000 | Service 2 | [NAME] | Number 2 | LL 2 | [NAME] | 2 | Notes 2 | Person 2 | Morgan
Grower 3 | Area 3 | Sub Area 3 | Home qrt 3 | 3000 | Service 3 | Name 3 | Number 3 | LL 3 | [NAME] | 3 | Notes 3 | Person 3 | Morgan
Grower 4 | Area 4 | Sub Area 4 | Home qrt 4 | 4000 | Service 4 | Name 4 | Number 4 | LL 4 | [NAME] | 4 | Notes 4 | Person 4 | Zach
Grower 5 | Area 5 | Sub Area 5 | Home qrt 5 | 5000 | Service 5 | Name 5 | Number 5 | LL 5 | Email 5 | 5 | Notes 5 | Person 5 | Morgan
Grower 6 | Area 6 | Sub Area 6 | Home qrt 6 | 6000 | Service 6 | Name 6 | Number 6 | LL 6 | Email 6 | 6 | Notes 6 | Person 6 | Zach
Grower 7 | Area 7 | Sub Area 7 | Home qrt 7 | 7000 | Service 7 | Name 7 | Number 7 | LL 7 | Email 7 | 7 | Notes 7 | Person 7 | Morgan
Grower 8 | Area 8 | Sub Area 8 | Home qrt 8 | 8000 | Service 8 | Name 8 | Number 8 | LL 8 | [NAME] | 8 | Notes 8 | Person 8 | Zach
Grower 9 | Area 9 | Sub Area 9 | Home qrt 9 | 9000 | Service 9 | Name 9 | Number 9 | LL 9 | [NAME] 9 | 9 | Notes 9 | Person 9 | Morgan
Grower 10 | Area 10 | Sub Area 10 | Home qrt 10 | 10000 | Service 10 | Name 10 | Number 10 | LL 10 | [NAME] 10 | 10 | Notes 10 | Person 10 | Morgan
Grower 11 | Area 11 | Sub Area 11 | Home qrt 11 | 11000 | Service 11 | Name 11 | Number 11 | LL 11 | [NAME] 11 | 11 | Notes 11 | Person 11 | Morgan
Grower 12 | Area 12 | Sub Area 12 | Home qrt 12 | 12000 | Service 12 | Name 12 | Number 12 | LL 12 | [NAME] 12 | 12 | Notes 12 | Person 12 | Zach
Grower 13 | Area 13 | Sub Area 13 | Home qrt 13 | 13000 | Service 13 | Name 13 | Number 13 | LL 13 | [NAME] 13 | 13 | Notes 13 | Person 13 | Morgan
Spreadsheet: 91681d1291344168-automatic-ranking-of-multiple-datasets-formula-or-code-rankgroupsnwv2
Sheet: Sheet1

 |  | Two data colomns both derived from raw data (not true equations) |  | Colomn i want to rank |  |  | Apolagies for previous spreadsheets, this one is more representative of the workbooks i use, however the macros supplied have being saved by me, so that if i do have anything purly numerical (non formulae derived) i can apply them then.
 |  |  |  |  |  |  |  |  |  |  |  |  |  | Equation more representative of those colomns
 |  | Dataset1 |  |  |  |  |  |  |  |  |  |  |  | IF(AND(BF7>0.25,(ISNUMBER(BF7))),(0.004*0.25+0.042),IF(ISNUMBER(BF7),((0.004*BF7+0.042)),IF(AND(BF7="",(ISNUMBER(T7))),(0.042),(""))))
 |  | Data v 1 | Data v 2 | Sum
56 | 54 | 18.66666666666667 | 12 | 30.66666666666667
25 | 25 | 8.333333333333334 | 5.555555555555555 | 13.88888888888889
54 | 36 | 18 | 8 | 26
25 | 78 | 8.333333333333334 | 17.33333333333333 | 25.66666666666666
36 | 36 | 12 | 8 | 20
78 | 78 | 26 | 17.33333333333333 | 43.33333333333333
92 | 92 | 30.66666666666667 | 20.44444444444444 | 51.11111111111111
 |  | Dataset2
25 | 54 | 8.333333333333334 | 12 | 20.33333333333334
36 | 25 | 12 | 5.555555555555555 | 17.55555555555556
78 | 36 | 26 | 8 | 34
92 | 36 | 30.66666666666667 | 8 | 38.66666666666667
 |  | Dataset3
36 | 54 | 12 | 12 | 24
78 | 25 | 26 | 5.555555555555555 | 31.55555555555556
78 | 36 | 26 | 8 | 34
 |  | Dataset4
36 | 54 | 12 | 12 | 24
78 | 25 | 26 | 5.555555555555555 | 31.55555555555556
36 | 36 | 12 | 8 | 20
54 | 25 | 18 | 5.555555555555555 | 23.55555555555556
25 | 36 | 8.333333333333334 | 8 | 16.33333333333334
Spreadsheet: 78590d1278962100-calculating-multiple-payment-types-shifthours2
Sheet: Sheet1

Cells formatted as hh:[NAME] |  |  |  | Cells formatted as number
Start | Finish | Start | Finish | Pre24 | Post24
07:00:00 | 13:00:00 | 18:45:00 | 22:00:00 | 9.249999999999998 | 0 | Change times in formula to suit shift times
 |  | 17:30:00 | 03:00:00 | 6.500000000000001 | 3
06:00:00 | 12:00:00 | 01:00:00 | 03:00:00 | 6 | 2
 |  | 17:00:00 | 21:30:00 | 4.5 | 0
06:00:00 | 14:00:00 |  |  | 8 | 0
Spreadsheet: 770276d1645975121-filling-a-cell-with-only-the-last-available-data-measurement-of-a-sanple-sample-analyses-results-1-
Sheet: Sheet1

Sample ID | Analysis Data |  | Sample ID | Repeated results | Reported results
 |  |  |  | 1 | 100
Sample 1 | 1 |  | Sample 2 | 2
Sample 1 | 100 |  |  | 3 | 200
Sample 2 | 2 |  | Sample 3 | 3
Sample 2 | 3 |  |  | 4
Sample 2 | 200 |  |  | 5 | 300
Sample 3 | 3 |  | Sample 4 | 6
Sample 3 | 4 |  |  | 7
Sample 3 | 5 |  |  | 8
Sample 3 | 300 |  |  | 9 | 400
Sample 4 | 6 |  | Sample 5 | 10
Sample 4 | 7 |  |  | 11
Sample 4 | 8 |  |  | 12 | 500
Sample 4 | 9
Sample 4 | 400
Sample 5 | 10
Sample 5 | 11
Sample 5 | 12
Sample 5 | 500