tianzl66/Sheetpedia huggingface dataset:
Spreadsheet: 876881d1723593430-how-to-link-or-import-data-between-two-excel-workbooks-with-very-different-formats-daily-sheets
Sheet: 06.03.24

 | AM SHIFT REPORT
 |  |  |  | 2024-06-03 00:00:00
 | UNIT | Bed Capacity | [NAME] | Census | Census Pending | RN | RN PD | TRVL | RN OT | RN Sick | Tech | NA | Comments
 | 3RD FL | 13 | 7 | 7 | 0 | 2 | 0 | 1 | 0 | 0 | 1 | 0
 | 4TH FL | 38 | 22 | 25 | 0 | 4 | 0 | 2 | 0 | 1 | 2 | 0
 | 5TH FL | 34 | 20 | 21 | 0 | 4 | 2 | 1 | 0 | 0 | 2 | 0
 | ABC | 27 | 18 | 21 | 0 | 6 | 0 | 2 | 1 | 0 | 2 | 0
 | MNO | 12 | 6 | 6 | 0 | 3 | 0 | 0 | 0 | 0 | 1 | 0
 | Total MED
 | JKL | 26 | 4 | 1 | 0 | 1 | 0 | 0 | 0 | 0 | 0 | 0
 | DEF | 10 | 4 | 3 | 0 | 1 | 0 | 0 | 0 | 0 | 0 | 0
 | GHI | N/A | N/A | 1 | 0 | 3 | 1 | 0 | 0 | 0 | 1 | 0
 | Total MAT
 | Total Holds AM | N/A | N/A | 0 | 0 | 5 | 0 | 0 | 2 | 0 | 2 | 0
 | Total Holds MID |  |  | 0 | 0 | 5 | 0 | 0 | 0 | 0 | 1 | 0
 | Total House Census
 | PM SHIFT REPORT
 |  |  |  | 2024-06-03 00:00:00
 | UNIT | Bed Capacity | [NAME] | Census | Census Pending | RN | RN PD | TRVL | RN OT | RN Sick | Tech | NA | Comments
 | 3RD FL | 13 | 7 | 11 | 0 | 2 | 1 | 0 | 0 | 0 | 1 | 0
 | 4TH FL | 38 | 22 | 23 | 0 | 4 | 1 | 0 | 0 | 1 | 1 | 0
 | 5TH FL | 34 | 20 | 16 | 0 | 3 | 2 | 1 | 0 | 2 | 0 | 0
 | ABC | 27 | 18 | 21 | 0 | 6 | 0 | 4 | 0 | 0 | 1 | 0
 | MNO | 12 | 6 | 6 | 0 | 3 | 0 | 0 | 0 | 0 | 1 | 0
 | Total MED
 | JKL | 26 | 4 | 2 | 0 | 1 | 0 | 0 | 0 | 0 | 0 | 0
 | DEF | 10 | 4 | 2 | 0 | 1 | 0 | 0 | 0 | 0 | 0 | 0
 | GHI | N/A | N/A | 3 | 0 | 3 | 0 | 1 | 0 | 0 | 1 | 0
 | Total MAT
 | Total Holds PM | N/A | N/A | 6 | 0 | 5 | 3 | 0 | 0 | 0 | 2 | 0
 | Total House Census
Spreadsheet: 688726d1595928381-i-need-to-make-table-to-see-my-hours-flown-per-year-and-month-wise-sample
Sheet: Summary

 |  |  | JAN | FEB | MAR | APR | MAY | JUN | JUL | AUG | SEP | OCT | NOV | DEC | TOTAL
 |  | 2009
 |  | 2010
 |  | 2011
 |  | 2012
 |  | 2013 |  |  |  |  |  |  |  |  |  |  |  |  |  |  | In this table I want to calculate hours as per year and month from column J of Logbook and Date is in column A
 |  | 2014
 |  | 2015 |  |  |  |  |  |  |  |  |  |  |  |  |  | <------
 |  | 2016
 |  | 2017
 |  | 2018
 |  | 2019
 |  | 2020
 |  | 2021
 |  | 2022
 |  | 2023
 |  | 2024
 |  | 2025
 |  | 2026
 |  | LAST 90 DAYS |  |  | Made this to look for last 90 days, but I want to see when my 3rd last take off and landing was done and from that date I need to add 90 days to see when it will expiry.
 |  | Take Off | Landing | <-----
Spreadsheet: c1feaa26-594b-4f7d-942f-96c0446c8076
Sheet: Duplicates

Run # | Sample Code | Mass | %N | %C
6 | 26 | 4.365 | 2.598855309623091 | 50.19867524739149
3 | 26 | 4.615 | 2.400650762356571 | 48.97815453077398
 | Avg | 4.49 | 2.499753035989831 | 49.58841488908274
 | STDEV |  | 0.1401517794341657 | 0.8630384752989039
3 | 32 | 4.615 | 1.956214773238762 | 49.23107807774043
3 | 32 | 3.718 | 2.036669517400346 | 49.4730717947286
 | Avg | 4.1665 | 1.996442145319554 | 49.35207493623452
 | STDEV |  | 0.0568900951752848 | 0.1711153982868727 |  |  | `
6 | 35 | 4.669 | 3.132337759046976 | 49.64704837443819
3 | 35 | 3.873 | 3.216328531583963 | 48.97078882259096
 | Avg | 4.271 | 3.17433314531547 | 49.30891859851458
 | STDEV |  | 0.05939044481800055 | 0.4781877149533527
4 | 44 | 4.209 | 2.702436691933155 | 50.46396814972013
4 | 44 | 3.615 | 2.640595436070789 | 50.22789231755714
 | Avg | 3.912 | 2.671516064001972 | 50.34593023363863
 | STDEV |  | 0.04372837137737118 | 0.1669308217967116
6 | 52 | 3.624 | 2.378080639399757 | 49.73652553800365
6 | 52 | 4.524 | 2.48630506243775 | 49.80350749395251
 | Avg | 4.074 | 2.432192850918754 | 49.77001651597808
 | STDEV |  | 0.07652622342016613 | 0.04736339526857863
6 | 60 | 4.499 | 2.204985692872898 | 50.13387786480246
3 | 60 | 4.523 | 2.140791501821756 | 48.82034118544956
 | Avg | 4.510999999999999 | 2.172888597347327 | 49.47710952512601
 | STDEV |  | 0.04539214780504737 | 0.9288106933076904
4 | 76 | 4.435 | 2.926488302180632 | 50.61692557009893
4 | 76 | 3.559 | 2.947137479895534 | 49.25999881099518
 | Avg | 3.997 | 2.936812891038083 | 49.93846219054706
 | STDEV |  | 0.01460117358813337 | 0.9594921129357465
4 | 94 | 4.033 | 3.085081975534962 | 51.77032255927664
4 | 94 | 3.868 | 2.934306591508679 | 51.70991152021131
 | Avg | 3.9505 | 3.009694283521821 | 51.74011703974397
 | STDEV |  | 0.1066142964809903 | 0.04271705538161954
8 | 79 | 3.631 | 2.96349265462306 | 49.24476112955227
8 | 79 | 3.477 | 2.925927493588788 | 48.42719102417903
 | Avg | 3.554 | 2.944710074105924 | 48.83597607686565
 | STDEV |  | 0.0265625801036987 | 0.57810936560482
Spreadsheet: 859259d1707721399-rank-and-count-values-in-a-range-from-the-same-range-across-multiple-sheets-rank-and-count-dj
Sheet: Review

Top 20
Bob2 | <---- | All manually entered
Carmen3 | <----
Marge | <----
Abigail1
[NAME]
[NAME]
[NAME]
[NAME]
Ernie
[NAME]
[NAME]
Priya
[NAME]
Tom5
[NAME]
Mark4
Elaine
Maria
[NAME]
[NAME]
EXPECTED OUTCOME
Abigail1 (10) | <------Formulas in here |  | that checks for the names entered into A2:A21 against the other 12 sheets
Bob2 (8) |  |  | and results in the name in the range that matched the most with the number
Carmen3 (7) |  |  | of times it matched in parenthesis.
Mark4 (6)
Tom5 (5) |  |  | The formula should account for the possibility of blank cells.
Bob2 (8)
Carmen3 (7)
Mark4 (6)
Tom5 (5)
Spreadsheet: 869284d1715878372-schedule-formula-that-indicates-off-days-test-schedule
Sheet: Sheet2

 |  |  | YR | MONTH
9 | 0630-1600 | [NAME], Sun | 2024 | JANUARY
8 | 0700-1530 | 5/4/9 1st Fri off | 2025 | FEBRUARY
9 | 0700-1630 | 5/4/9 2nd Fri off | 2026 | [NAME]
10 | 0700-1730 | 5/4/9 1st Mon off | 2027 | APRIL
8 | 0730-1600 | 5/4/9 2nd Mon off | 2028 | MAY
9 | 0730-1700 | off Mon & Tue | 2029 | [NAME]
8 | 0800-1630 | off Wed & Thur | 2030 | JULY
 |  | 1st Mon, 2nd Mon, and Friday | 2031 | AUGUST
 |  | 1st Mon, 2nd Tue, 3rd Thur, 4th Friday
 |  | 1st Mo, 3rd Mo, 5th Mo
 |  | 1st Fr, [NAME], 5th Fr
9 | 0800-1730 | 4/10 Fri off |  | SEPTEMBER
8 | 0830-1700 | 4/10 Mon off |  | OCTOBER
 | 1530-2400 | [NAME],Mon, Wed |  | NOVEMBER
 | 1430-2300 | Off Mon,[NAME],[NAME] |  | DECEMBER
Spreadsheet: 599482d1543110745-formula-for-extracting-data-according-the-criteria-excel
Sheet: Sheet

 |  | code | RHG
 |  | days | 1
 |  | value | 5
 |  | % | 7
 |  |  | Chooise 1 | Chooise 2 | Chooise 3 | Chooise 4 | Chooise 5
 |  | Code
 |  | days
 |  | value
 |  | Direction
 |  | %
Spreadsheet: 63747d1264616281-euclidean-distance-matrix-prototype-software
Sheet: Master Attributes

 | Attribute
Item | Risk | Cost | Performance
1
2
3
4
5
6
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
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: 704194d1605428075-vlookup-and-if-statement-combination-for-a-date-test-formulas-v2
Sheet: Sheet2

 | POST | NAME | PHONE NUMBER | TRIP # | LICENSE | A | F | R
 | G2 | RICH | [PHONE] | 12-888 | 2021-09-06 00:00:00 | 2021-03-31 00:00:00
 | G2A | DAN | [PHONE] | 12-889 | 2020-09-07 00:00:00 |  | 2021-07-31 00:00:00
 | G6 | GOL | [PHONE] | 12-890 | 2021-03-28 00:00:00 |  |  | 2021-07-31 00:00:00
 | G4A | MOR | [PHONE] |  | 2021-02-08 00:00:00 |  |  | 2020-11-30 00:00:00
 |  | LAN | [PHONE] | 12-892 | 2020-11-20 00:00:00 |  |  | 2021-03-31 00:00:00
 | G6A | HOUSTON | [PHONE] | 12-893 | 2021-04-09 00:00:00
 | G6B | ARIAS | [PHONE] | 12-894
Spreadsheet: 4301674b-b9ea-46d2-9375-eef2491da69b
Sheet: Sheet1

Table S5. TFs with single mutant phenotype | Unnamed: 1 | Unnamed: 2
Locus ID | Gene name | Phenotypic catergory
FGSG_04901 | GzZC271 | Growth on PDA
FGSG_07789 | GzbZIP011 | Growth on PDA
FGSG_03929 | GzZC194 | Growth on MM
FGSG_05958 | GzZC192 | Growth on MM
FGSG_07591 | GzZC189 | Growth on MM
FGSG_09565 | GzGATA007 | Growth on MM
FGSG_10868 | GzHSF003 | Growth on MM
FGSG_04084 | GzC2H025 | Pigmentation
FGSG_06356 | [NAME] | Number of perithecia (NP)
FGSG_09308 | GzbHLH014 | Number of perithecia (NP)
FGSG_01564 | GzZC276 | [NAME] (PM)
FGSG_02608 | GzCCAAT003 | [NAME] (PM)
FGSG_05789 | GzZC228 | [NAME] (PM)
FGSG_06382 | GzZC289 | [NAME] (PM)
FGSG_06701 | GzC2H044 | [NAME] (PM)
FGSG_06966 | GzHOMEL016 | [NAME] (PM)
FGSG_09000 | GzOB036 | [NAME] (PM)
FGSG_00696 | GzHMG004 | Ascospore formation (AF)
FGSG_05604 | GzHMG018 | Ascospore formation (AF)
[NAME] | GzWing012 | Ascospore formation (AF)
FGSG_10286 | GzCCHC010 | Ascospore formation (AF)
FGSG_04109 | GzZC217 | Conidiation
FGSG_07097 | GzHOME005 | Conidiation
FGSG_11561 | GzZC088 | Conidiation
FGSG_13625 | GzZC034 | Conidiation
[NAME] | ZEB2 | ZEA production
FGSG_05857 | GzC2H038 | ZEA production
FGSG_06810 | GzZC131 | ZEA production
FGSG_07265 | GzZC110 | ZEA production
FGSG_10429 | GzZC082 | ZEA production
FGSG_12809 | GzC2H097 | ZEA production
FGSG_00719 | GzZC282 | Virulence
FGSG_01293 | GzZC236 | Virulence
FGSG_08028 | GzZC120 | Virulence
FGSG_08182 | GzZC116 | Virulence
FGSG_08737 | GzOB031 | Virulence
FGSG_10179 | GzLam002 | Virulence
FGSG_11416 | GzC2H093 | Virulence
FGSG_00568 | GzZC083 | Fungicide
FGSG_09904 | GzOB042 | Fungicide
FGSG_07177 | GzZC113 | Cell wall
FGSG_05381 | GzC2H036 | pH11
FGSG_05896 | GzDHHC002 | pH11
FGSG_11364 | [NAME] | pH11
[NAME] | GzC2H005 | pH4
FGSG_11623 | GzbZIP018 | pH4
Spreadsheet: 246d3e9c-b78b-47d1-8bdd-b473e322fcf2
Sheet: 11b

Product1 | EUR3 | USD | GBP | [NAME] | AUD | CAD | OTHER | TOTAL
Cross-Currency Basis | 213 | 233 | 67 | 168 | 195 | 130 | 86 | 1092
Cross-Currency Fixed-Fixed | - | 4 | - | 6 | - | 7 | 5 | 22
Cross-Currency Fixed-Float | 12 | 101 | 1 | 5 | 12 | 1 | 236 | 368
TOTAL | 225 | 338 | 68 | 179 | 207 | 138 | 327 | 1482
Spreadsheet: 37785d1235795073-adding-conditional-inside-formula-workbook2
Sheet: Sheet1

1849810.101694915 | 2059187.660377359 | 19050675
104210 | 122000 | 14582227
 |  | 14176243
 |  | 11244612
 |  | 8830882
 |  | 8119749
 |  | 7485668
 |  | 4788756
 |  | 4748716
 |  | 3078974
 |  | 2761814
 |  | 1226059
 |  | 1148000
 |  | 1073282
 |  | 872621
 |  | 804536
 |  | 786835
 |  | 745995
 |  | 651081
 |  | 600442
 |  | 273542
 |  | 211153
 |  | 202095
 |  | 167343
 |  | 131377
 |  | 131000
 |  | 123565
 |  | 122000
 |  | 118318
 |  | 104210
 |  | 92956
 |  | 90797
 |  | 90410
 |  | 85095
 |  | 77076
 |  | 71813
 |  | 66032
 |  | 30544
 |  | 28555
 |  | 26669
 |  | 17712
 |  | 14900
 |  | 14781
 |  | 12952
 |  | 10737
 |  | 10666
 |  | 8861
 |  | 7252
 |  | 5951
 |  | 3862
 |  | 2738
 |  | 2460
 |  | 2357
 |  | 783
 |  | 382
 |  | 334
 |  | 200
 |  | 100
 |  | 51
1306574.445945946 | 1381221.914285714 | 15163484
126548 | 135681.5 | 12686600
 |  | 8102867
 |  | 7905257
 |  | 6074356
 |  | 5041684
 |  | 4723951
 |  | 4224426
 |  | 4086045
 |  | 3112469
 |  | 4377897
 |  | 2486254
 |  | 2251151
 |  | 1936561
 |  | 1518018
 |  | 1509381
 |  | 1465609
 |  | 1348282
 |  | 1225184
 |  | 775244
 |  | 768618
 |  | 483244
 |  | 470583
 |  | 394766
 |  | 389756
 |  | 364550
 |  | 360445
 |  | 356760
 |  | 346955
 |  | 268293
 |  | 263642
 |  | 237914
 |  | 218640
 |  | 157650
 |  | 146241
 |  | 144154
 |  | 127209
 |  | 125887
 |  | 124139
 |  | 91371
 |  | 88923
 |  | 87000
 |  | 73800
 |  | 73002
 |  | 61493
 |  | 58807
 |  | 53753
 |  | 51891
 |  | 42478
 |  | 34907
 |  | 27423
 |  | 25269
 |  | 24290
 |  | 14168
 |  | 13544
 |  | 13346
 |  | 11545
 |  | 11207
 |  | 9370
 |  | 8945
 |  | 8759
 |  | 7329
 |  | 6971
 |  | 6076
 |  | 4481
 |  | 3321
 |  | 3046
 |  | 1897
 |  | 1610
 |  | 1346
 |  | 429
 |  | 376
 |  | 120
 |  | 50
Spreadsheet: 879344d1726827407-find-a-date-in-a-row-of-data-and-return-the-value-in-the-cell-next-to-it-pompey657-sample-323-365-aligw
Sheet: Sheet1

 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | FIRST DATE
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | late | 2024-09-16 00:00:00 | 2024-09-17 00:00:00 | 2024-09-18 00:00:00 | 2024-09-19 00:00:00 | 2024-09-20 00:00:00 | 2024-09-21 00:00:00 | 2024-09-22 00:00:00 | 2024-09-23 00:00:00 | 2024-09-24 00:00:00 | 2024-09-25 00:00:00 | 2024-09-26 00:00:00 | 2024-09-27 00:00:00 | 2024-09-28 00:00:00 | 2024-09-29 00:00:00 | 2024-09-30 00:00:00 | 2024-10-01 00:00:00 | 2024-10-02 00:00:00 | 2024-10-03 00:00:00 | 2024-10-04 00:00:00 | 2024-10-05 00:00:00
 | RC13029D | 2024-09-12 00:00:00 | 1802 | 2024-09-26 00:00:00 | 3180 | 2024-10-04 00:00:00 | 3180 | 2024-10-11 00:00:00 | 3180 | 2024-10-18 00:00:00 | 1272 |  |  |  | RC13029D | 3600
 | RC40041 | 2024-09-19 00:00:00 | 1982 |  |  |  |  |  |  |  |  |  |  |  | RC40041 | 2400
 | RC90044 | 2024-10-15 00:00:00 | 3663 |  |  |  |  |  |  |  |  |  |  |  | RC90044 | 10912
 | RC15012 |  |  |  |  |  |  |  |  |  |  |  |  |  | RC15012 | 6190
 | RC50059 |  |  |  |  |  |  |  |  |  |  |  |  |  | RC50059 | 12224
 | RC60091 | 2024-09-25 00:00:00 | 6846 | 2024-10-04 00:00:00 | 6846 | 2024-10-13 00:00:00 | 1918-09-28 00:00:00 |  |  |  |  |  |  |  | RC60091 | 8800
 | RC25337 |  |  |  |  |  |  |  |  |  |  |  |  |  | RC25337 | 3300
 | RC60092 | 2024-09-25 00:00:00 | 59014 | 2024-10-02 00:00:00 | 63553 | 2024-10-09 00:00:00 | 2073-12-30 00:00:00 | 2024-10-16 00:00:00 | 1999-06-05 00:00:00 |  |  |  |  |  | RC60092 | 26400
 | RC50057 | 2024-09-20 00:00:00 | 81719 | 2024-10-03 00:00:00 | 40860 | 2024-10-10 00:00:00 | 2011-11-13 00:00:00 | 2024-10-17 00:00:00 | 1949-09-19 00:00:00 |  |  |  |  |  | RC50057 | 15400
 | RC60094 | 2024-10-04 00:00:00 | 13709 | 2024-10-11 00:00:00 | 13709 | 2024-10-18 00:00:00 | 1937-07-13 00:00:00
 | RC60095 | 2024-10-07 00:00:00 | 13834
Spreadsheet: mark_haedicke__24608__SUMMARY
Sheet: summary

MARINER ENERGY, INC.
APPENDIX
WEEKLY DRILLING AND COMPLETION SUMMARY
 |  |  |  |  |  |  |  |  |  |  |  |  | PRESENT |  | PROPOSED
 |  |  | PROSPECT |  | AREA |  | WELL |  | E/D |  | [NAME] |  | DEPTH |  | TD |  | COMMENT
 | I. |  | WELLS CURRENTLY DRILLING
 |  |  | Green Canyon 136 |  | Deepwater |  | OCS-G 4508 #8 |  | D |  | 0.25 |  | 3,687' |  | 7,600' |  | Drilling.
 |  |  | (Shasta)
 |  |  | South Timbalier 316 |  | Deepwater |  | OCS-G #1 |  | E |  | 0.2 |  | 4,900' |  | 13,500' |  | Drilling.
 | II. |  | WELLS REACHING TOTAL DEPTH, TESTING, OR TURNED TO SALES THIS WEEK
 |  |  | Green Cayon 516 |  | Deepwater |  | OCS-G 20074 #1 |  | E |  | 0.5 |  |  |  |  |  | Completed.
 |  |  | (Yosemite)
 | III. |  | WELLS ANTICIPATED TO SPUD WITHIN 90 DAYS
 |  |  | [NAME] 962 |  | Deepwater |  | OCS-G #1 |  | E |  | 0.15 |  |  |  | 4,478' |  | Expected spud date first week November
 |  |  | (Swordfish) |  |  |  |  |  |  |  |  |  |  |  |  |  | 2001
 |  |  | Visoca Knoll 962 |  | Deepwater |  | OCS-G #2 |  | E |  | 0.15 |  |  |  | 3,835' |  | Expected spud date  mid December 2001.
 |  |  | (Swordfish)
 |  |  | Mississippi Canyon 205 |  | Deepwater |  | OCS-G #1 |  | E |  | 0.25 |  |  |  | 3,500' |  | Expected spud date mid December 2001.
 |  |  | (Piston)
 | IV. |  | OTHER
 |  |  | None to report.
Spreadsheet: 99268d1297959508-charting-two-different-time-granularities-764825
Sheet: Sheet1

 | Five Minutes | 1 Hour
12:00:00 | 1
12:05:00 | 2
12:10:00 | 3
12:15:00 | 4
12:20:00 | 3
12:25:00 | 2
12:30:00 | 1
12:35:00 | 2
12:40:00 | 2
12:45:00 | 3
12:50:00 | 4
12:55:00 | 2
00:00:00 |  | 5
01:00:00 |  | 6
02:00:00 |  | 5
03:00:00 |  | 6
04:00:00 |  | 7
05:00:00 |  | 7
06:00:00 |  | 7
07:00:00 |  | 8
08:00:00 |  | 8
09:00:00 |  | 7
10:00:00 |  | 6
11:00:00 |  | 5
12:00:00 |  | 3
13:00:00 |  | 5
14:00:00 |  | 6
15:00:00 |  | 4
16:00:00 |  | 5
17:00:00 |  | 6
18:00:00 |  | 5
19:00:00 |  | 4
20:00:00 |  | 5
21:00:00 |  | 4
22:00:00 |  | 3
23:00:00 |  | 5
Spreadsheet: 864595d1711702073-indexing-correct-match-using-large-formula-with-criteria-book1-282-aligw
Sheet: Paste-ZR63G

Material | MvT | Order | Quantity | UOM | Amount in LC
898-188888 DESCRIPTION 1 | 261 | [PHONE] | -1 | EA | -333 |  |  |  |  | -333
898-555222 DESCRIPTION 2 | 261 | [PHONE] | -1 | EA | -333 |  |  |  | 898-555222 DESCRIPTION 2 | -333
855-895215 DESCRIPTION 3 | 261 | [PHONE] | -2 | EA | -214.68 |  |  |  | 855-895215 DESCRIPTION 3 | -214.68
595-552125 DESCRIPTION 4 | 261 | [PHONE] | -10 | EA | -197.37
 |  |  |  |  |  |  | -333
 |  |  |  |  |  | 898-555222 DESCRIPTION 2 | -333
 |  |  |  |  |  | 855-895215 DESCRIPTION 3 | -214.68
Spreadsheet: darron_c_giron__7978__AGAVE
Sheet: February

Note: Insert the #'s in red to calculate the customer price
 | Crude Merc | IF-Elpaso Perm | IF-HH | IF-Elpaso/SJ | IF-TW-Permian
 | 22.172 | 2.55 | 2.96 | 2.48 | 2.5
 |  |  | Spot price |  | Index Price
CPR# | TAGG # | PanEnergy | Facility | Term | Calculated Price
72678 | E21728 | 2,500/day | 813780 | 7/95-12/2001
CPR# | TAGG # | Union Pacific | Facility | Term | Calculated Price
48853 | E11400 | 2,500/day | 813367 | 7/96-12/2003
CPR# | TAGG # | Union Pacific | Facility | Term | Calculated Price
3217 | E22656 | 7,000/day | 813367 | 1/95-12/2001
CPR# | TAGG # | Vastar | Facility | Term | Calculated Price
3231 | E21977 | 10,000/day | 501079 | 6/96-4/2002
CPR# | TAGG # | Agave/Yates | Facility | Term | Calculated Price
3585 | E20337 | 10,000/day | 58649 | 1/93-12/2002
Spreadsheet: 139891d1328537121-picking-up-the-last-10-entries-which-are-spread-out-forum-sample-6
Sheet: Sheet1

E |  |  |  | E |  | #N/A | #N/A
E |  |  |  | E |  | #N/A | #N/A
E |  |  |  | E |  | #N/A | #N/A
E |  |  |  | E |  | #N/A | #N/A
O |  |  |  | E |  | #N/A | #N/A
O |  |  |  | O |  | #N/A | #N/A
O | 4 | 3 |  | E |  | #N/A | #N/A
E |  |  |  | E |  | #N/A | #N/A
E |  |  |  | E |  | #N/A | #N/A
E |  |  |  | E |  | #N/A | #N/A
E
O
E
E | 6 | 1
E
O
E
O
E
O
O | 3 | 4
O
O
O
E
O
O
E | 2 | 5
E
O
O
E
E
E
E | 5 | 2
E
E
O
E
E
E
E | 6 | 1
E
O
E
E
O
O
O | 3 | 4
E
E
O
O
O
E
E | 4 | 3
E
E
E
O
O
E
E | 5 | 2
O
E
O
O
E
O
O | 2 | 5
O
E
O
E
E
E
O | 4 | 3
O
E
E
O
O
O
O | 2 | 5
E
O
E
O
E
O
E | 4 | 3
O
O
E
O
O
O
O | 1 | 6
O
O
O
E
E
E
O | 3 | 4
O
E
E
E
E
O
O | 4 | 3
E
O
E
O
E
E
E | 5 | 2
E
E
O
E
E
E
E | 6 | 1
 | 3 | 4
Spreadsheet: 857414d1706443404-how-to-add-cells-derived-from-formulas-work-start-and-finish-times-test-etaf
Sheet: 2024

W/C | Mon  In | Mon  Out | Mon  Total | Tue  In | Tue  Out | Tue  Total | Wed  In | Wed  Out | Wed  Total | Thu  In | Thu  Out | Thu  Total | Fri  In | Fri  Out | Fri  Total | Sat  In | Sat  Out | Sat  Total | Sun  In | Sun  Out | Sun  Total | Weekday Hours | Extra Hours | Weekday Total | Weekend Hours | Overall Total | Notes | 00:30:00
2023-01-01 00:00:00 | 06:00:00 | 18:00:00 |  | 05:16:00 | 18:21:00 |  | 05:18:00 | 18:52:00 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | Bank Holiday
 | 05:26:00 | 18:34:00 |  | 05:18:00 | 18:49:00 |  | 05:21:00 | 18:44:00
 | 05:23:00 | 18:35:00 |  | 05:24:00 | 18:25:00 |  | 05:20:00 | 18:38:00 |  |  |  |  |  |  |  |  |  |  | 06:27:00 | 14:30:00
 | 05:26:00 |  |  | 05:17:00 | 18:34:00 |  | 05:21:00 | 19:03:00 |  |  |  |  |  |  |  | 06:23:00 | 14:31:00 |  | 06:21:00
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | Weeks remaining
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | Hours left to work (based on current average)
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | On course for this number of annual hours
Spreadsheet: 771761d1646835477-calculate-value-if-certain-conditions-met-stylist-bonuses-2019-working-v2-help-file-2
Sheet: Goals

Data ----> |  | New Returns |  |  |  | Repeat Returns |  |  |  | Productivity |  |  | Product Sales |  | [NAME]
Salon Name | Salon # | Level 1 | Level 1 Pymt | Level 2 | Level 2 Pymt | Level 1 | Level 1 Pymt | Level 2 | Level 2 Pymt | Non-Floor Budget | Productivity [NAME] | Productivity Pay | Product Goal | Product Sales Pay | Goal | Pay Rate
 |  | 0.27 | 25 | 0.29 | 50 | 0.78 | 25 | 0.8 | 50 | 40 | 30 | 0.05 | 0.01 | 0.01
 |  | 0.27 | 25 | 0.29 | 50 | 0.78 | 25 | 0.8 | 50 | 40 | 30 | 0.05 | 0.03 | 0.01
 |  | 0.27 | 25 | 0.29 | 50 | 0.78 | 25 | 0.8 | 50 | 40 | 30 | 0.05 | 0.03 | 0.01
 |  | 0.27 | 25 | 0.29 | 50 | 0.78 | 25 | 0.8 | 50 | 40 | 30 | 0.05 | 0.03 | 0.01
 |  | 0.27 | 25 | 0.29 | 50 | 0.78 | 25 | 0.8 | 50 | 40 | 30 | 0.05 | 0.03 | 0.01
 |  | 0.27 | 25 | 0.29 | 50 | 0.78 | 25 | 0.8 | 50 | 40 | 30 | 0.05 | 0.03 | 0.01
 |  | 0.27 | 25 | 0.29 | 50 | 0.78 | 25 | 0.8 | 50 | 40 | 30 | 0.05 | 0.03 | 0.01
 |  | 0.27 | 25 | 0.29 | 50 | 0.78 | 25 | 0.8 | 50 | 40 | 30 | 0.05 | 0.03 | 0.01
 |  | 0.27 | 25 | 0.29 | 50 | 0.78 | 25 | 0.8 | 50 | 40 | 30 | 0.05 | 0.03 | 0.01
 |  | 0.27 | 25 | 0.29 | 50 | 0.78 | 25 | 0.8 | 50 | 40 | 30 | 0.05 | 0.03 | 0.01
 |  | 0.27 | 25 | 0.29 | 50 | 0.78 | 25 | 0.8 | 50 | 40 | 30 | 0.05 | 0.03 | 0.01
 |  | 0.27 | 25 | 0.29 | 50 | 0.78 | 25 | 0.8 | 50 | 40 | 30 | 0.05 | 0.03 | 0.01
 |  | 0.27 | 25 | 0.29 | 50 | 0.78 | 25 | 0.8 | 50 | 40 | 30 | 0.05 | 0.03 | 0.01
 |  | 0.27 | 25 | 0.29 | 50 | 0.78 | 25 | 0.8 | 50 | 40 | 30 | 0.05 | 0.03 | 0.01
 |  | 0.27 | 25 | 0.29 | 50 | 0.78 | 25 | 0.8 | 50 | 40 | 30 | 0.05 | 0.03 | 0.01
 |  | 0.27 | 25 | 0.29 | 50 | 0.78 | 25 | 0.8 | 50 | 40 | 30 | 0.05 | 0.03 | 0.01
 |  | 0.27 | 25 | 0.29 | 50 | 0.78 | 25 | 0.8 | 50 | 40 | 30 | 0.05 | 0.03 | 0.01
 |  | 0.27 | 25 | 0.29 | 50 | 0.78 | 25 | 0.8 | 50 | 40 | 30 | 0.05 | 0.03 | 0.01
 |  | 0.27 | 25 | 0.29 | 50 | 0.78 | 25 | 0.8 | 50 | 40 | 30 | 0.05 | 0.03 | 0.01
 |  | 0.27 | 25 | 0.29 | 50 | 0.78 | 25 | 0.8 | 50 | 40 | 30 | 0.05 | 0.03 | 0.01
 |  | 0.27 | 25 | 0.29 | 50 | 0.78 | 25 | 0.8 | 50 | 40 | 30 | 0.05 | 0.03 | 0.01
 |  | 0.27 | 25 | 0.29 | 50 | 0.78 | 25 | 0.8 | 50 | 40 | 30 | 0.05 | 0.03 | 0.01
 |  | 0.27 | 25 | 0.29 | 50 | 0.78 | 25 | 0.8 | 50 | 40 | 30 | 0.05 | 0.03 | 0.01
 |  | 0.27 | 25 | 0.29 | 50 | 0.78 | 25 | 0.8 | 50 | 40 | 30 | 0.05 | 0.03 | 0.01
Product Salon Thresholds
Below 3 %
Spreadsheet: 736986d1624001738-multiple-xlookup-or-vlookup-help-please-autobank-team-croombs
Sheet: Sheet2

CUSTOMER | [NAME] PARAMETERS | HANDLER
Brake Brothers | Brake | [NAME]
toolstation | toolstation | Zoe
Screwfix | Screw | [NAME]
[NAME] | Travis | [NAME]
Waitrose | Waitrose | [NAME]
Sainsburys | Sainsburys | Ellie
Aldi | AALDI | [NAME]