tianzl66/Sheetpedia huggingface dataset:
Spreadsheet: mark_taylor__24730__legalreview2
Sheet: currency

Currency
3 | Characters
No analysis - currencies and ISO codes preloaded
To add:
Currency Field | Field Abbreviation | Product Group | ID | Long Description Sentences
NOK | NOK | All | 1 | The price is quoted in Norwegian Krone per unit of volume which will be the Contractual Currency.
DEM | DEM | All | 2 | The price is quoted in German Marks per unit of volume.
USD | USD | All | 3 | The price is quoted in US Dollars per unit of volume which will be the Contractual Currency.
GBP | GBP | All | 4 | The price is quoted in British pounds sterling per unit of volume which will be the Contractual Currency.
SEK | SEK | All | 5 | The price is quoted in Swedish Krone per unit of volume.
FIM | FIM | All | 6 | The price is quoted in Finish Marks cents per unit of volume.
NLG | NLG | All | 7 | The price is quoted in Dutch Guilder per unit of volume.
CHF | CHF | All | 8 | The price is quoted in Swiss Francs per unit of volume.
Spreadsheet: phillip_m_love__31142__aaaCredit Report
Sheet: Sheet1

DEAL ORIGINATION REPORT
Deals Input on 10/31/01
PENDING CREDIT ITEMS
Counterparty | Deal Number | Deal Type | Comm | Contact/Action Needed
[NAME], LP | YG0672.1 | F | C3GC | Credit Previously Provided
Energy West Incorporated | YG0659.1 | F | NG | [NAME]
National Gas & Oil Company | YE2547.1 YE2726.1 | P | NG | [NAME]
REBOOK ITEMS
Counterparty | Deal Number | Deal Type | Comm | Rebook To--
Aquila Capital & Trade, Ltd. | YF9277.1 | F | NG | Aquila Capital & Trade, Ltd. (w/ECC)
Enbridge Midcoast Energy, Inc. | YF9240.1 | F | NG | Enbridge Marketing (US) Inc.
Spreadsheet: 863379d1710880989-data-extraction-training-class-schedule
Sheet: Schedule

 | Year | 2024 | Date |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 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 | Column21 | Column22 | Column23 | Column24 | Column25 | Column26
 | Month | 3 | Weekday |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 18 | 19 | 20 | 21 | 22 | 23
 | Name - EMP. ID |  | Month
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | EMP. ID | Name | 1
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 1
Spreadsheet: 217434d1362067972-help-with-a-progressive-average-formula-average-without-blanks-and-zeros
Sheet: Sheet1

Student | marks1 | marks2 | marks3 | marks4 | [NAME] | marks6 | marks7 | Average function including blanks and Zeros
a | 0 |  | 80 | 92 | 0 | 59 | 98
b | 67 | 80 | 74 | 0 | 63 | 59
c | 54 | 0 | 88 | 72 |  | 51 | 88
d | 76 |  | 73 | 84 | 0 | 56
e |  | 98 | 90 | 82 | 78 | 0 | 72
Student | marks1 | marks2 | marks3 | marks4 | [NAME] | marks6 | marks7 | Average function NOT including blanks and Zeros
a | 0 |  | 80 | 92 | 0 | 59 | 98
b | 67 | 80 | 74 | 0 | 63 | 59
c | 54 | 0 | 88 | 72 |  | 51 | 88
d | 76 |  | 73 | 84 | 0 | 56
e |  | 98 | 90 | 82 | 78 | 0 | 72
Spreadsheet: 779783d1652100291-sum-days-hours-and-minutes-to-show-total-minutes-phonestatistics
Sheet: Test per månad

Gruppering | Anonym siffra | Datum | Inloggad dygn.h:min:sek | Inloggad antal minuter | [NAME] dygn.h:min:sek | Tillgänglig antal minuter | [NAME] (%) | Pausad dygn.h:min:sek | Pausad antal minuter | Pausad VS Inloggad (%)
Telefon | 1 | Januari | 2.15:07:57 |  | 1.10:11:17 |  |  | 1.04:56:40
Telefon | 2 | Januari | 5.17:35:06 |  | 4.06:35:10 |  |  | 1.01:33:03
Mail | 4 | Januari | 0.00:17:05 |  | 0.00:00:00 |  |  | 0.00:17:05
Mail | 5 | Januari | 0.01:51:57 |  | 0.01:00:05 |  |  | 0.00:51:07
Mail | 5 | Januari | 0.06:39:50 |  | 0.04:39:13 |  |  | 0.02:00:37
Telefon | 6 | Januari | 6.02:47:10 |  | 3.05:01:07 |  |  | 2.21:46:03
Telefon | 10 | Januari | 6.10:30:32 |  | 2.20:28:17 |  |  | 3.14:02:15
Mail | 11 | Januari | 0.19:43:00 |  | 0.07:44:45 |  |  | 0.11:58:03
Telefon/admin | 12 | Januari | 5.20:03:18 |  | 2.22:20:39 |  |  | 2.21:42:39
Telefon | 1 | Februari | 5.09:39:40 |  | 2.20:35:13 |  |  | 2.13:04:27
Telefon | 2 | Februari | 5.05:35:34 |  | 4.02:22:05 |  |  | 1.03:13:29
Telefon | 3 | Februari | 5.20:23:38 |  | 4.20:21:35 |  |  | 1.00:02:03
Mail | 4 | Februari | 0.01:01:24 |  | 0.00:07:20 |  |  | 0.00:54:04
Mail | 5 | Februari | 0.01:08:37 |  | 0.00:27:03 |  |  | 0.00:41:34
Mail | 5 | Februari | 0.06:09:47 |  | 0.01:12:20 |  |  | 0.04:57:27
Telefon | 6 | Februari | 5.13:57:23 |  | 2.21:28:42 |  |  | 2.16:28:41
Telefon | 7 | Februari | 0.00:00:00 |  | 0.00:00:00 |  |  | 0.00:00:00
Telefon | 10 | Februari | 6.11:29:29 |  | 3.02:21:21 |  |  | 3.09:08:08
Mail | 11 | Februari | 0.23:17:16 |  | 0.09:14:08 |  |  | 0.14:03:08
Telefon/admin | 12 | Februari | 5.04:48:15 |  | 2.15:29:41 |  |  | 2.13:18:34
Spreadsheet: 5ad6eb6d-f050-4e69-8d3f-33db0b8bb111
Sheet: Sheet1

Unnamed: 0 | Unnamed: 1 | TIB-The Independent BankersBank | Unnamed: 3 | Unnamed: 4 | Unnamed: 5 | .25 cost to Price to Waive Escrows | Unnamed: 7
 |  | 350 [NAME]., [NAME] |  |  |  | LTV must be 80% or less to qualify.
 |  | [PHONE] Toll Free//[PHONE] fax
 |  | Rate Sheet Effective: |  |  | 2014-05-16 09:14:29.530000
Product: Conv-Conforming Fixed Rate 30 Year |  |  |  |  |  | Loan Level Price Adjustment
Rate | 15 Day | 30 Day | 45 Day | 60 Day |  | Price adjustments are cumulative
4.75 | 102.875 | 102.75 | 102.625 | 102.25 |  | and are added to price quote
4.625 | 102.725 | 102.6 | 102.475 | 102.1
4.5 | 102.669 | 102.544 | 102.419 | 102.044 |  | Note: | Refer To Price [NAME]
4.375 | 102.188 | 102.063 | 101.938 | 101.563 |  |  | For all Price Adjs
4.25 | 101.58 | 101.455 | 101.33 | 100.705
4.125 | 100.726 | 100.601 | 100.476 | 99.851
4 | 99.713 | 99.588 | 99.463 | 98.838
3.875 | 98.66 | 98.535 | 98.41 | 97.785
3.75 | 97.785 | 97.66 | 97.535 | 96.91
Product: Conv-Conforming Fixed Rate 15 Year
Rate | 15 Day | 30 Day | 45 Day | 60 Day
3.875 | 102.875 | 102.75 | 102.625 | 102.25
3.75 | 102.657 | 102.532 | 102.407 | 102.032
3.625 | 102.512 | 102.387 | 102.262 | 101.887
3.5 | 101.96 | 101.835 | 101.71 | 101.335
3.375 | 101.232 | 101.107 | 100.982 | 100.357
3.25 | 100.484 | 100.359 | 100.234 | 99.609
3.125 | 99.913 | 99.788 | 99.663 | 99.038 |  | Minimum loan amount:
 |  |  |  |  |  | TIB does not have a minimum loan
 |  |  |  |  |  | loan amount, however a 1.00% price
 |  |  |  |  |  | discount will apply to loan amounts
 |  |  |  |  |  | less than $39,999.00
 |  |  |  |  |  | 2010 Conforming Loan Limits
 |  |  |  |  |  | 1 Unit-$417,000
 |  |  |  |  |  | 2 Unit-$533,850
 |  |  |  |  |  | 3 Unit-$645,300
 |  |  |  |  |  | 4 Unit-$801,950
A SERVICE RELEASE PREMIUM WILL BE PAID IN [NAME] WITH THE ATTACHED SCHEDULE.
 |  | TIB-The Independent BankersBank
 |  | 350 [NAME]., [NAME]
 |  | [PHONE] Toll Free//[PHONE] fax
 |  | Rate Sheet Effective:
 |  |  |  |  |  | Loan Level Price Adjustment
Rate | 15 Day | 30 Day | 45 Day |  |  | Price adjustments are cumulative
 |  |  |  |  |  | & adj. Made to the price quote
EXPIRATION DATES:
15 DAY | 2014-05-30 09:14:29.530000
30 DAY | 2014-06-14 09:14:29.530000
45 DAY | 2014-06-29 09:14:29.530000
60 DAY | 2014-07-14 09:14:29.530000
90 DAY | 2014-08-13 09:14:29.530000
A SERVICE RELEASE PREMIUM WILL BE PAID IN [NAME] WITH THE ATTACHED SCHEDULE.
Spreadsheet: 86935d1286892083-automating-filtered-totals-new-microsoft-excel-worksheet
Sheet: Sheet1

Url | Visible | Internal
/programme/pm/aaa/iweriw | 56 | 78
/programme/pm/aaa/sredrf/images | 435 | 787
/new/oddbin | 23 | 87
/new/bin/new/normal | 235 | 666
/new/bin/new/odd | 35 | 46
/helo/mouse/1/2 | 32 | 56
/programme/pm/new/ | 55 | 334
Spreadsheet: louise_kitchen__24127__North America Plan 01-02
Sheet: West - Orig

 | West Gas - Orig
 | 2002 Plan
 |  |  |  |  |  |  |  |  | Per HC | New HC | Adjust Comp |  | ADJUSTED
 |  | 2001-09-01 00:00:00 |  | 2001 |  | % | 2002 |  |  |  |  |  | 2002
 |  | YTD Actual |  | Forecast |  | of Total | Plan |  |  |  |  |  | Plan
ENACOMP | Compensation |  |  |  |  |  | 905850 | Compensation | 0
 | Special Pays |  |  | 0
 | Analyst & Associates |  |  |  |  |  | 0 |  |  |  |  |  | 0
ENABENTX | Benefits & Payroll Taxes |  |  |  |  |  | 181170 | Other
ENAEMPEX | Employee Expense |  |  |  |  |  | 65000 |  |  |  |  |  | 65000
ENAT&EEX | Travel & Entertainment Expense |  |  |  |  |  | 250000 | Total |  |  |  |  | 250000
ENAOUTSV | Outside Services |  |  |  |  |  | 0 |  |  |  |  |  | 0
ENASUPP | Supplies Expense |  |  |  |  |  | 15858
ENAMKTEX | Marketing |  |  |  |  |  | 0 | Intern | 33000 |  |  |  | 0
ENACONTR | Charitable Contributions |  |  |  |  |  | 0 | [NAME] | 48400 | 0 |  |  | 0
ENARENT | Rent |  |  |  |  |  | 100000 | Staff | 49500 | 0 |  |  | 100000
ENATECH | Technology |  |  |  |  |  | 30000 | Specialist | 57750 | 0 |  |  | 30000
ENATRANS | Transportation |  |  |  |  |  | 1 | Sr. Specialist | 71500 | 1 |  |  | 1
ENAOTHEX | Other Expenses |  |  |  |  |  | 10000 | Analyst | 60500 | 0 |  |  | 10000
ENATAXES | Taxes Other than Income |  |  |  |  |  | 0 | Associate | 89100 | 0 |  |  | 0
ENATOTDR | Total Direct Expenses |  |  |  |  |  |  | Manager | 110000 | 1
 |  |  |  |  |  |  |  | Director | 143000
 | Headcount |  |  |  |  |  |  | Sr. Director | 165000 | 0
 |  |  |  |  |  |  |  | VP | 198000
 | A&A Headcount |  |  |  |  |  |  | MD | 220000 | 0
 | Total Headcount |  |  |  |  |  |  |  |  |  | 0.2
 |  |  |  |  |  |  | Other Expense Calculation
 | Outside Services | 254512
 |  |  |  |  |  |  | Total Misc Exp | Old HC | Exp/Old HC | New HC | Exp/New HC
Spreadsheet: 165614d1341298100-formula-to-check-pre-defined-list-and-show-relevant-info-formula-sample
Sheet: Sheet1

Item | full tote qty | Code
702/0007 | 156 | 1958340
702/0014 | 70 | 1467714
702/0021 | 156 | 1958342
702/0038 | 132 | 1958341
702/0052 | 156 | 1937820
702/0069 | 156 | 1937824
702/0076 | 132 | 1937822 |  |  |  |  |  |  | User enters full qty
702/0090 | 156 | 1996163 |  |  |  |  |  |  |  |  |  |  | User enters Item
702/0100 | 78 | 2195443
702/0117 | 156 | 1996169
702/0131 | 156 | 1937840
702/0526 | 100 | 2275363
 |  |  |  |  |  |  | Contains | Qty | x | 300 | CAT | Number | 702/0014
 | [NAME] splits the qty into full totes |  |  |  |  |  |  | Tote | = |  | units | per | tote
 |  | [NAME] adds remainder of qty |  |  |  |  |  | Tote | = | 1 | units | per | tote
 |  |  |  |  |  |  |  |  | Total | of |  | Totes
 |  |  |  |  |  |  |  |  | [NAME] counts total number of totes
Spreadsheet: 758712d1639034050-running-aggregate-using-dynamic-array-aggregate-problem
Sheet: Sheet 1

 |  |  |  | No. | 15
 |  |  | Base | Increment |  | 1 | 2 | 3 | 4 | 5 | 6 | 7 | 8 | 9 | 10 | 11 | 12 | 13 | 14
Step 1 |  | A | 25000 | 0.03 |  | 25750 | 26522.5 | 27318.175 | 28137.72025 | 28981.85185749999 | 29851.307413225 | 30746.84663562175 | 31669.2520346904 | 32619.32959573111 | 33597.90948360304 | 34605.84676811114 | 35644.02217115447 | 36713.3428362891 | 37814.74312137777
Step 2 |  | B | 12000 | 0.02 |  | 12240 | 12484.8 | 12734.496 | 12989.18592 | 13248.9696384 | 13513.949031168 | 13784.22801179136 | 14059.91257202719 | 14341.11082346773 | 14627.93303993708 | 14920.49170073582 | 15218.90153475054 | 15523.27956544555 | 15833.74515675446
Step 3 |  | A + B |  |  |  | 37990 | 39007.3 | 40052.671 | 41126.90617 | 42230.8214959 | 43365.256444393 | 44531.07464741311 | 45729.16460671758 | 46960.44041919884 | 48225.84252354012 | 49526.33846884696 | 50862.92370590501 | 52236.62240173465 | 53648.48827813224
Step 4 |  | Running Aggregate (Offset)
How to do step 4 without using offset?
Spreadsheet: 108984c6-fa13-4e31-b3fa-a713848795e9
Sheet: Sheet1

Table 9--U.S. vegetable oil and fats prices | Unnamed: 1 | Unnamed: 2 | Unnamed: 3 | Unnamed: 4 | Unnamed: 5 | Unnamed: 6 | Unnamed: 7 | Unnamed: 8
Marketing | Soybean | Cottonseed | Sunflowerseed | Canola | Peanut | Corn | Lard 6 | Edible
year | oil 2 | oil 3 | oil 4 | oil 4 | oil 5 | oil 6 |  | tallow 6
 |  |  |  | Cents/pound
2001/02 | 16.46 | 17.98 | 23.25 | 23.45 | 32.23 | 19.14 | 13.55 | 13.87
2002/03 | 22.04 | 37.75 | 33.13 | 29.75 | 46.7 | 28.17 | 18.13 | 17.8
2003/04 | 29.97 | 31.21 | 33.42 | 33.76 | 60.84 | 28.43 | 26.13 | 22.37
2004/05 | 23.01 | 28.01 | 43.71 | 30.78 | 53.63 | 27.86 | 21.8 | 18.48
2005/06 | 23.41 | 29.47 | 40.64 | 31 | 44.48 | 25.18 | 21.74 | 18.16
2006/07 | 31.02 | 35.7 | 58.03 | 40.57 | 52.99 | 31.8 | 28.43 | 27.32
2007/08 | 52.03 | 73.56 | 91.15 | 65.64 | 94.53 | 69.4 | 40.85 | 41.68
2008/09 | 32.16 | 37.1 | 50.24 | 39.54 | 78.49 | 32.75 | 26.72 | 25.47
2009/10 | 35.95 | 40.27 | 52.8 | 42.88 | 59.62 | 39.29 | 31.99 | 32.26
2010/11 | 53.2 | 54.5 | 86.12 | 58.68 | 77.24 | 60.76 | 51.52 | 51.34
2011/121 | 52 | 53.25 | 84 | 57.25 | 100.15 | 56 | 53.5 | 51
2012/131 | 54.0-58.0 | 56.0-60.0 | 86.0-90.0 | 59.5-63.5 | 99.0-103.0 | 58.5-62.5 | 50.0-54.0 | 49.5-53.5
2010/11
October | 44.02 | 47.2 | 56 | 51.45 | 71.4 | 47.5 | 46.64 | 37
November | 47.62 | 50.75 | 63 | 53.63 | 75.13 | 51.96 | 37.32 | 41.75
December | 51.51 | 54 | 62.9 | 58.25 | 77.9 | 54.71 | 38.3 | 45
January | 53.84 | 55.92 | 74.125 | 59.5 | 80.06 | 57.91 | 48.5 | 50.1
February | 54.21 | 56.75 | 85.625 | 60.13 | 79.63 | 63.39 | 49.6 | 49.9
March | 54.07 | 55.5 | 96.75 | 60.25 | 77.5 | 67.72 | 52 | 51.75
April | 56.65 | 57.7 | 101.2 | 62.05 | 78.7 | 68.89 | 51.5 | 52.83
May | 56.09 | 56.06 | 103.75 | 60.19 | 82.81 | 68.33 | 54.31 | 53.87
June | 55.68 | 55.25 | 103.25 | 59.56 | 78.5 | 66.7 | 56.75 | 57.41
July | 55.16 | 54.75 | 97 | 60.7 | 88.05 | 62 | 63 | 60.89
August | 54.39 | 54.75 | 95 | 60 | 95.56 | 62 | 58.96 | 56.35
September | 55.13 | 55.35 | 94.8 | 58.45 | 97.5 | 57.95 | 61.33 | 59.28
2011/12
October | 51.73 | 51.56 | 92.5 | 56.81 | 97 | 54.24 | 61.1 | 52.09
November | 51.44 | 50.5 | 91 | 56.13 | 98.75 | 53.98 | 48.86 | 45.51
December | 50.17 | 51.1 | 91 | 55.4 | 96.1 | 53.36 | 48.71 | 50.78
January | 50.99 | 52.19 | 88.75 | 55.06 | 95.81 | 54 |  | 51.1
February | 52.36 | 54.56 | 86 | 56.94 | 95 | 56.3 | 52.55 | 53.17
March | 53.43 | 55.95 | 82 | 59.1 | 96.6 | 59.31 | 54.6 | 52.24
April | 54.96 | 56.88 | 79 | 60.94 | 102.38 | 60.75 | 52.59 | 49
May | 50.69 | 52 | 80 | 55.88 | 106.13 | 58.05 | 54.82 | 55.48
June | 48.65 | 50.05 | 80.2 | 54.1 | 111 | 52.9 | 54.83 | 49.88
July | 51.96 | 53.75 | 78 | 57.44 | 110 | 54.76 | 53 | 49.13
August1 | 52.65 | 54.65 | 75 | 58.75 | 110 | 57.26 |  | 48.36
1 Preliminary.  2 Decatur, IL.  3 PBSY Greenwood, MS.  4 Midwest. 5 Southeast mills.  6 Chicago.
Sources: USDA, Agricultural Marketing Service,  Monthly Feedstuff Prices and Milling and Baking News.
Last update: | 2012-09-17 13:40:54.690000
Spreadsheet: 155819d1337067012-file-format-for-attachment-car-log-12-new
Sheet: Delivery Accuracy

 |  |  |  |  |  | [NAME]
Invoice Month | Number of Invoices | Errors |  | 2012 | 2011 | 2010 | 2009 | 2008
January |  |  | 0 | #N/A | 0.74235807860262 | 0.9064039408866995 | 0.9113300492610837 | 0.8988095238095238 |  |  |  |  |  |  |  | 2008 av | 0.94
February |  |  | 0 | #N/A | 0.5503875968992248 | 0.9531914893617022 | 0.925531914893617 | 0.9318181818181818 |  |  |  |  |  |  |  | 2009 av | 0.94
March |  |  | 0 | #N/A | 0.7092651757188498 | 0.9333333333333333 | 0.9721115537848606 | 0.9655172413793104 |  |  |  |  |  |  |  | 2010 av | 0.94
April |  |  | 0 | #N/A | 0.7860082304526749 | 0.9259259259259259 | 0.9638009049773756 | 0.933920704845815
May |  |  | 0 | #N/A | 0.7320574162679426 | 0.9726027397260274 | 0.9122807017543859 | 0.9354838709677419
June |  |  | 0 | #N/A | 0.8714859437751004 | 0.9186440677966101 | 0.93 | 0.9372197309417041
July |  |  | 0 | #N/A | 0.7412280701754386 | 0.9385964912280702 | 0.9321266968325792 | 0.9588477366255144
August |  |  | 0 | #N/A | 0.812807881773399 | 0.9877300613496932 | 0.9659090909090909 | 0.9666666666666667 |  |  |  |  |  |  |  | 4186.29 | 2249.18 | 0.5372728597397696
September |  |  | 0 | #N/A | 0.686046511627907 | 0.9271844660194175 | 0.9142857142857143 | 0.9271844660194175
October |  |  | 0 | #N/A | 0.7385321100917431 | 0.9330543933054394 | 0.9230769230769231 | 0.9452054794520548
November |  |  | 0 | #N/A | 0.8442906574394463 | 0.6561514195583596 | 0.9534883720930233 | 0.950207468879668
December |  |  | 0 |  | #N/A | 0.5327102803738317 | 0.9534883720930233 | 0.9455445544554455
Spreadsheet: 86802d1286781310-subtotals-subtotal
Sheet: Sheet1

clockno | name | HourlyRate | new rate | Diff | leaver? | StartDate | DaySequence | hours | store | worked
307794 |  | 4.83 | 4.92 | -0.08999999999999986 | No | 2010-09-12 00:00:00 | 0 | 4
307794 |  | 4.83 | 4.92 | -0.08999999999999986 | No | 2010-09-12 00:00:00 | 3 | 4
307794 |  | 4.83 | 4.92 | -0.08999999999999986 | No | 2010-09-12 00:00:00 | 6 | 4
307794 |  | 4.83 | 4.92 | -0.08999999999999986 | No | 2010-09-19 00:00:00 | 0 | 4 |  | HOLIDAY
307794 Total |  |  |  |  |  |  |  | 16
328006 |  | 5.15 | 5.25 | -0.09999999999999964 | No | 2010-09-26 00:00:00 | 0 | 4
328006 Total |  |  |  |  |  |  |  | 4
328007 |  | 5.15 | 5.25 | -0.09999999999999964 | No | 2010-09-26 00:00:00 | 1 | 4
328007 |  | 5.15 | 5.25 | -0.09999999999999964 | No | 2010-09-26 00:00:00 | 2 | 4
328007 |  | 5.15 | 5.25 | -0.09999999999999964 | No | 2010-09-26 00:00:00 | 4 | 4
Spreadsheet: john_hodge__16368__AFT01
Sheet: Points

 | 185.0416666666667 | 245.8666666666667 | 85.325 | 150.6666666666667 | 86.675 | 297.9166666666667 | 106.375 | 104.7 | 207.1333333333334 | 219.5083333333334 |  | .
 | 78.42233333333334 | 121.3838571428572 | 83.43042857142858 | 90.33892857142858 | 78.92928571428571 | 113.904119047619 | 28.56828571428571 | 80.9415 | 26.97385714285714 | 123.0627857142857
 | 404.1666666666667 | 131.75325 | 303.95325 | 172.04 | 91.41666666666666 | 55.15325 | 46.9865 | 189.7451666666667 | 67.119 | 224.5656666666667
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  | tiger DNP
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  | tiger DNP
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  | tiger DNP
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 1875
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 2250
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  | tiger DNP
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 2250
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  | tiger DNP
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  | tiger DNP
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  | tiger DNP
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  | tiger DNP
Spreadsheet: 703744d1605148353-vlookup-avoiding-rows-with-specific-criteria-example-spreadsheet
Sheet: Sheet2

 | NAME | RANK | W | L | T
 | TEAM 1 | 22.17 | 5 | 2 | 0
 | TEAM 2 | 18.4 | 2 | 5 | 0
 | TEAM 3 | 25.7 | 4 | 3 | 0
 | TEAM 4 | 21.65 | 1 | 6 | 0
 | TEAM 5 | 17.11 | 3 | 4 | 0
Spreadsheet: 77266d1277777411-concatenate-columns-macrohelp
Sheet: Macro 2

 | Sheet one |  | Sheet two |  |  |  |  |  | result on sheet 3
 | 100 |  | 100045 |  | + | a | + |  | 100045 | 100 | + | a | +
 | 200 |  | 100046 |  | + | b | + |  | 100046 | 100 | + | b | +
 | 300 |  | 100047 |  | + | c | + |  | 100047 | 100 | + | c | +
 | 400 |  | 100048 |  | + | d | + |  | 100048 | 100 | + | d | +
 | 500 |  | 100049 |  | + | e | + |  | 100049 | 100 | + | e | +
 | End |  | 100050 |  | + | f | + |  | 100050 | 100 | + | f | +
 |  |  |  |  |  |  |  |  | 100045 | 200 | + | a | +
 |  |  |  |  |  |  |  |  | 100046 | 200 | + | b | +
 |  |  |  |  |  |  |  |  | 100047 | 200 | + | c | +
 |  |  |  |  |  |  |  |  | 100048 | 200 | + | d | +
 |  |  |  |  |  |  |  |  | 100049 | 200 | + | e | +
 |  |  |  |  |  |  |  |  | 100050 | 200 | + | f | +
 |  |  |  |  |  |  |  |  | 100045 | 300 | + | a | +
 |  |  |  |  |  |  |  |  | 100046 | 300 | + | b | +
 |  |  |  |  |  |  |  |  | 100047 | 300 | + | c | +
 |  |  |  |  |  |  |  |  | 100048 | 300 | + | d | +
 |  |  |  |  |  |  |  |  | 100049 | 300 | + | e | +
 |  |  |  |  |  |  |  |  | 100050 | 300 | + | f | +
 |  |  |  |  |  |  |  |  | 100045 | 400 | + | a | +
 |  |  |  |  |  |  |  |  | 100046 | 400 | + | b | +
 |  |  |  |  |  |  |  |  | 100047 | 400 | + | c | +
 |  |  |  |  |  |  |  |  | 100048 | 400 | + | d | +
 |  |  |  |  |  |  |  |  | 100049 | 400 | + | e | +
 |  |  |  |  |  |  |  |  | 100050 | 400 | + | f | +
 |  |  |  |  |  |  |  |  | 100045 | 500 | + | a | +
 |  |  |  |  |  |  |  |  | 100046 | 500 | + | b | +
 |  |  |  |  |  |  |  |  | 100047 | 500 | + | c | +
 |  |  |  |  |  |  |  |  | 100048 | 500 | + | d | +
 |  |  |  |  |  |  |  |  | 100049 | 500 | + | e | +
 |  |  |  |  |  |  |  |  | 100050 | 500 | + | f | +
Spreadsheet: 733301d1621500640-listing-contents-of-cells-based-on-the-cell-above-test
Sheet: Sheet1

 | [NAME] | AMon:2 FR - 2 | AMon:3 FR - 3 | AMon:4 FR - 2 | [NAME] | [NAME] | ATue:2 FR - 2 | ATue:3 FR - 2 | ATue:4 FR - 1 | ATue:5 FR - 2 | [NAME] | AWed:2 FR - 0 | AWed:3 FR - 2 | AWed:4 FR - 3 | AWed:5 FR - 2 | [NAME] | [NAME] | [NAME] | AThu:4 FR - 3 | AThu:5 FR - 2 | [NAME] | AFri:2 FR - 2 | AFri:3 FR - 2 | AFri:4 FR - 2 | AFri:5 FR - 2
1 | 11B/Fr1 | 10B/Fr1 | 12N/Fr1 | 8r/Fr2 | 8s/Fr1 | 8s/Fr1 | 9r/Fr1 | 9r/Fr2 | 11C/Fr1 | 9h/Fr4 | 9h/Fr1 |  | 9h/Fr3 | 12X/Fr1 | 9r/Fr3 | 9r/Fr2 | 8s/Fr2 | 12N/Fr1 | 11C/Fr1 | 10C/Fr1 | 10B/Fr1 | 12N/Fr1 | 9h/Fr2 | 9r/Fr1 | 13N/Fr1
Teacher | A | B | F | A | E | E | E | E
2 | 8s/Fr4 | 9r/Fr5 | 11C/Fr1 | 8r/Fr3 | 8s/Fr2 | 8s/Fr2 | 9r/Fr3 | 8h/Fr1 | 12N/Gm1 | 8s/Fr4 | 9h/Fr2 |  | 8r/Fr1 | 11B/Fr1 | 9r/Fr4 | 9r/Fr4 | 8s/Fr3 | 9r/Fr6 | 8h/Fr1 | 9h/Fr5 | 10B/Gm1 | 8h/Fr2 | 9h/Fr5 | 9h/Fr1 | 10C/Fr1
Teacher | B | C | E | B | C | C | C | C
3 | 11B/Gm1 | 10B/Gm1 | 9r/Fr4 | 8r/Gm2 | 8r/Gm1 | 13L/Gm1 | 9r/Gm1 | 9r/Gm2 | 11C/Gm1 | 9h/Sp2 | 8s/Gm1 |  | 13L/Gm1 | 8r/Fr3 | 8r/Sp2 | 9r/Gm1 | 8s/Gm2 | 12N/Gm1 | 8h/Fr3 | 10C/Gm1 | 13M/Sp1 | 12N/Gm1 | 13L/Gm1 | 13L/Gm1 | 10C/Gm1
Teacher | C | D | D | C | A | B | B | B
4 | 11B/Sp1 | 10B/Sp1 | 11C/Gm1 | 7s/Sp4 | 9r/Sp2 | 7r/Sp1 | 9r/Gm3 | 7h/Sp1 | 11C/Sp1 | 7s/Sp1 | 8s/Gm2 |  | 9h/Gm2 | 11B/Gm1 | 7r/Sp2 | 9r/Gm2 | 13M/Sp1 | 9r/Gm3 | 13L/Gm1 | 9h/Gm1 | 10B/Sp1 | 9r/Sp1 | 9h/Sp1 | 9r/Gm2 | 8h/Gm1
Teacher | D | E | C | D | D | D | D | D
5 | 7r/Sp2 | 9r/Gm3 | 11C/Sp1 |  |  | 7s/Sp2 |  | 7h/Sp2 | 8h/Sp1 |  | 9h/Sp3 |  | 9h/Sp2 | 11B/Sp1 | 7r/Sp3 | 9r/Sp3 | 7h/Sp3 | 9h/Sp1 | 11C/Gm1 | 10C/Sp1 | 7h/Sp1 | 7r/Sp3 | 7s/Sp3 | 9r/Sp2 | 12M/Sp1
Teacher | E | F | B
6 | 7r/Sp3 |  | 7s/Sp3 |  |  |  |  | 7h/Sp3 | 7r/Sp4 |  | 8h/Sp1 |  | 7s/Sp2 | 8r/Sp1 |  | 7s/Sp1 |  | 8h/Sp1 | 11C/Sp1 |  |  |  |  | 8r/Sp2 | 10C/Sp1
Teacher | F |  | A
7 |  |  |  |  |  |  |  |  |  |  |  |  | 7s/Sp3 | 7r/Sp4 |  | 7s/Sp2 |  |  |  |  |  |  |  | 7r/Sp1 | 8h/Sp2
Teacher
 | Class | Teacher(s)
 | 11B/Fr1
 | 8s/Fr4
 | 11B/Gm1
 | 11B/Sp1
Spreadsheet: 144226d1330803244-excel-2007-changing-data-on-one-sheet-to-reflect-changes-on-another-indirect-1-
Sheet: Sheet2

1
9
3
6
8
2
7
4
5