tianzl66/Sheetpedia huggingface dataset:
Spreadsheet: 47036d1245942874-vlookup-multiple-lines-value
Sheet: Template

Name |  | xy
Code |  | 111111
Period |  | 2009
Customer
Material | No | Start Date | Description | Result | Defective Qty (ext.) | Nr | Completion Date | Response Time | Target
1 | 2 | 2009-01-13 00:00:00 | x | x | 1 | 3 | 39867 | 5.857142857142857 | 4
1 | 2 | 2009-03-09 00:00:00 | x | x | 1 | 3 | 39910 | 4.142857142857143 | 4
1 | 2 | 2009-03-24 00:00:00 | x | x | 1 | 3 | 39920 | 3.428571428571428 | 4
1 | 2 | 2009-03-30 00:00:00 | x | x | 1 | 3 | 0 | -5700.285714285715 | 4
1 | 2 | 2009-02-24 00:00:00 | x | x | 1 | 3 | 39882 | 2 | 4
 |  |  |  |  |  |  |  | #N/A | 4
 |  |  |  |  |  |  |  | #N/A | 4
 |  |  |  |  |  |  |  | #N/A | 4
 |  |  |  |  |  |  |  | #N/A | 4
 |  |  |  |  |  |  |  | #N/A | 4
 |  |  |  |  |  |  |  | #N/A | 4
 |  |  |  |  |  |  |  | #N/A | 4
 |  |  |  |  |  |  |  | #N/A | 4
 |  |  |  |  |  |  |  | #N/A | 4
 |  |  |  |  |  |  |  |  | 4
 |  |  |  |  |  |  |  |  | 4
 |  |  |  |  |  |  |  |  | 4
 |  |  |  |  |  |  |  |  | 4
 |  |  |  |  |  |  |  |  | 4
 |  |  |  |  |  |  |  |  | 4
 |  |  |  |  |  |  |  |  | 4
 |  |  |  |  |  |  |  |  | 4
 |  |  |  |  |  |  |  |  | 4
 |  |  |  |  |  |  |  |  | 4
 |  |  |  |  |  |  |  |  | 4
 |  |  |  |  |  |  |  |  | 4
 |  |  |  |  |  |  |  |  | 4
 |  |  |  |  |  |  |  |  | 4
 |  |  |  |  |  |  |  |  | 4
 |  |  |  |  |  |  |  |  | 4
 |  |  |  |  |  |  |  |  | 4
 |  |  |  |  |  |  |  |  | 4
 |  |  |  |  |  |  |  |  | 4
 |  |  |  |  |  |  |  |  | 4
 |  |  |  |  |  |  |  |  | 4
 |  |  |  |  |  |  |  |  | 4
 |  |  |  |  |  |  |  |  | 4
 |  |  |  |  |  |  |  |  | 4
 |  |  |  |  |  |  |  |  | 4
 |  |  |  |  |  |  |  |  | 4
 |  |  |  |  |  |  |  |  | 4
Month | Supply Qty | [NAME] (P) | PPM I | Defective (W) | PPM W | Monthly PPM | [NAME] | PPM TARGET
2009-01-01 00:00:00 | 101947 | 77 | 755.2944176876221 | #N/A
2009-02-01 00:00:00 | 89386 | 6 | 67.12460564294184 | #N/A
2009-03-01 00:00:00
2009-04-01 00:00:00
2009-05-01 00:00:00
2009-06-01 00:00:00
2009-07-01 00:00:00
2009-08-01 00:00:00
2009-09-01 00:00:00
2009-10-01 00:00:00
2009-11-01 00:00:00
2009-12-01 00:00:00
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | SUPPLIER | Vendor No
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | xy | 111111
Spreadsheet: john_arnold__15151__Enron INCONTROL Products
Sheet: Control-M Order Form

 |  |  |  |  |  |  | Product Order Form:  Open System Products |  |  |  |  | Product Order Form #
6
 |  |  |  |  | SUPPORT |  | DESIGNATED CPU |  | PRODUCT | LICENSE FEE
 | SLA # | ITEM# | QUANTITY | PRODUCT DESCRIPTION | B=BASE | TIER | MACHINE TYPE & | MANUFACTURE | EFFECTIVE | UNIT COST | TOTAL COST | INSTALLATION LOCATION
 |  |  |  |  | E=EXTENDED |  | MODEL | # | DATE
 | 5839 | 1 | 2 | Enterprise Control Station | E | Flat Rate |  |  | 2000-11-30 00:00:00 | 20055
 |  | 2 | 13 | ECS Additional Seat | E | Seat |  |  | 2000-11-30 00:00:00 | 3500
 |  | 3 | 21 | Control-M/Agent for Windows NT/W2K | E | Workgroup |  |  | 2000-11-30 00:00:00 | 2385
 |  | 4 | 8 | Control-M/Server for Solaris | E | Workgroup |  |  | 2000-11-30 00:00:00 | 4575
 |  | 5 | 4 | Control-M/Agent for Solaris | E | Enterprise 1 |  |  | 2000-11-30 00:00:00 | 47170
 |  | 6 | 3 | Control-M/Agent for Solaris | E | Department |  |  | 2000-11-30 00:00:00 | 18625
 |  | 7 | 10 | Control-M/Agent for Solaris | E | Workgroup |  |  | 2000-11-30 00:00:00 | 3615
 |  | 8 |  | Patrol KM for Control-M for Windows | E | Workgroup |  |  | 2000-11-30 00:00:00 | 1205
 |  | 9 |  | Patrol KM for Control-M for Distributed Systems | E | Enterprise 1 |  |  | 2000-11-30 00:00:00 | 23885
 |  | 10 |  | Patrol KM for Control-M for Distributed Systems | E | Department |  |  | 2000-11-30 00:00:00 | 9430
 |  | 11 |  | Patrol KM for Control-M for Distributed Systems | E | Workgroup |  |  | 2000-11-30 00:00:00 | 1830
 |  | 12 | 1 | Control-M Option for SAP/R3 for Windows | E | Flat Rate |  |  | 2000-11-30 00:00:00 | 24965
 |  | 13 | 2 | Control-M Option for SAP/R3 for Dist. Systems | E | Flat Rate |  |  | 2000-11-30 00:00:00 | 37825
 |  | 14 | 80 | Control-M/Desktop (Seats) | E | Seat |  |  | 2000-11-30 00:00:00 | 450
 |  | 15 | 1 | Control-M/Links for Distributed Systems | E | Flat Rate |  |  | 2000-11-30 00:00:00 | 15000
 |  | 16 | 80 | Control-M/WebAccess | E | Seat |  |  | 2000-11-30 00:00:00 | 225
 |  | 17 | 1 | Control-M/WebAccess Server | E | Department |  |  | 2000-11-30 00:00:00 | 3460
 |  |  |  |  |  |  |  |  |  | Total
 |  |  |  |  |  |  |  |  |  | Less Discount
 |  |  |  |  |  |  |  |  |  | Maintenance
 |  |  | 44 | Professional Services (Rate is Weighted Avg.) |  |  |  |  | Estimate |  | 95000
 | This Product Order Form is valid through November 30, 2000.
 |  | ACCEPTED BY LICENSOR: BMC Software Distribution, Inc. |  |  |  |  | ACCEPTED BY [NAME]: Enron Corporation
 |  | By: |  |  |  |  | By:
 |  | Name: |  |  |  |  | Name:
 |  | Title: |  |  |  |  | Title:
 |  | Date: |  |  |  |  | Date:
 |  | Open Systems Order Form:CNT-ZZ027BMC-POF:09
Spreadsheet: 883777d1732476014-stuck-regarding-an-if-function-example-1
Sheet: Question

 | June |  |  |  |  |  |  | Split | Other
Ck # | Date | Payee | Description | Debit | Credit | [NAME] | Vince
1500 | 2024-06-11 00:00:00 | Aalejandro [NAME] | (PP #12) 78.5 @ 17.00 = 1334.50, SS - 82.74, M-care - 19.35, STW - 14.68, Fed Tax - 97.00 | 1120.73 |  | 560.36 | 560..6 | x
Online | 2024-06-17 00:00:00 | J.M. Equipment Co. Inc. | Cust. #123821, Inv. V115885713 & V416547420,  Dandel mower parts | 57.74 |  | 28.87 | 28.87 | x
Online | 2024-06-25 00:00:00 | EMP DEVEL EDD EFTPMT CCD | Form 943 for Pay Period #13,   Confirmation 00297487 (post date is 7/11/24, pd from new EIN) | 904.5 |  | 600 | 304.5 |  | x
 |  |  |  |  |  | [NAME] | Vince
 |  |  |  | June Totals
Spreadsheet: c6926763-614c-4c5e-9e58-8ff7e4273c3e
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: |  |  | 2012-08-10 09:29:42
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 | 102.125 | 102 | 101.875 | 101.5 |  | and are added to price quote
3.875 | 101.583 | 101.458 | 101.333 | 100.958
3.75 | 101.435 | 101.31 | 101.185 | 100.81 |  | Note: | Refer To Price [NAME]
3.625 | 101.023 | 100.898 | 100.773 | 100.398 |  |  | For all Price Adjs
3.5 | 100.373 | 100.248 | 100.123 | 99.498
3.375 | 99.482 | 99.357 | 99.232 | 98.607
3.25 | 98.518 | 98.393 | 98.268 | 97.643
 |  |  |  |  |  | Please note availability of
 |  |  |  |  |  | TIB Servicing Retained Product
 |  |  |  |  |  | For Conventional Loans Only.
 |  |  |  |  |  | A .25 adjustment to SRP
 |  |  |  |  |  | Will apply.
 |  |  |  |  |  | TIB Annual Mortgage Conference
 |  |  |  |  |  | October 3rd thru 5th
 |  |  |  |  |  | Register Now!!!
Product: Conv-Conforming Fixed Rate 15 Year
Rate | 15 Day | 30 Day | 45 Day | 60 Day
3.375 | 102.121 | 101.996 | 101.871 | 101.496
3.25 | 101.694 | 101.569 | 101.444 | 101.069
3.125 | 101.394 | 101.269 | 101.144 | 100.769
3 | 101.043 | 100.918 | 100.793 | 100.418
2.875 | 100.433 | 100.308 | 100.183 | 99.558
2.75 | 99.774 | 99.649 | 99.524 | 98.899
 |  |  |  |  |  | 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 | 2012-08-24 09:29:42
30 DAY | 2012-09-08 09:29:42
45 DAY | 2012-09-23 09:29:42
60 DAY | 2012-10-08 09:29:42
90 DAY | 2012-11-07 09:29:42
A SERVICE RELEASE PREMIUM WILL BE PAID IN [NAME] WITH THE ATTACHED SCHEDULE.
Spreadsheet: 158809d1338400277-results-summarizing-across-multiple-sheets-guest-comments-card
Sheet: Aquarius Summary

Aquarius Lunch | Very Satisfied | Satisfied | Dissatisfied | Does not Apply
Table reservation handling | 2
Table service |  | 2
Variety of food and beverage menu |  | 1 | 1
Server's knowledge of menu selection |  |  | 2
Quality and presentation of food | 1 | 1
Portion size of food | 1 |  | 1
Quality and presentation of beverage |  | 1 |  | 1
Restaurant atmosphere | 1 | 1
[NAME] handling |  |  | 2
Aquarius Dinner | Very Satisfied | Satisfied | Dissatisfied | Does not Apply
Table reservation handling | 1 |  |  | 1
Table service |  | 1 | 1
Variety of food and beverage menu | 1 |  | 1
Server's knowledge of menu selection |  | 2
Quality and presentation of food | 1 | 1
Portion size of food | 1 |  | 1
Quality and presentation of beverage |  | 1 |  | 1
Restaurant atmosphere |  | 1 | 1
[NAME] handling | 2
[NAME] Dinner | Very Satisfied | Satisfied | Dissatisfied | Does not Apply
Table reservation handling
Table service
Variety of food and beverage menu
Server's knowledge of menu selection
Quality and presentation of food
Portion size of food
Quality and presentation of beverage
Restaurant atmosphere
[NAME] handling
Spreadsheet: 54063d1254073089-problem-nesting-if-and-match-functions-tabla-tp1
Sheet: Tension downfall 12v

 |  | CURRENT [amp]
 | LENGTH | 5 | 10 | 15 | 20 | 25 | 30 | 40 | 50 | 60 | 70 | 80 | 90 | 100
 | 10 | 18 | 14 | 12 | 10 | 10 | 8 | 6 | 6 | 6 | 6 | 6 | 4 | 4
 | 15 | 16 | 12 | 10 | 10 | 8 | 8 | 6 | 6 | 4 | 4 | 4 | 2 | 2
 | 20 | 14 | 10 | 10 | 8 | 6 | 6 | 6 | 4 | 4 | 2 | 2 | 2 | 2
 | 25 | 12 | 10 | 8 | 6 | 4 | 4 | 4 | 2 | 2 | 2 | 2 | 1 | 1
 | 30 | 12 | 10 | 8 | 6 | 6 | 6 | 4 | 4 | 2 | 2 | 2 | 1 | 1
 | 40 | 10 | 8 | 6 | 6 | 4 | 4 | 2 | 2 | 1 | 1/0 | 1/0 | 2/0 | 2/0
 | 50 | 10 | 6 | 6 | 4 | 4 | 2 | 2 | 1 | 1/0 | 2/0 | 3/0 | 4/0 | 4/0
 | 60 | 10 | 6 | 6 | 4 | 2 | 2 | 1 | 1/0 | 2/0 | 3/0 | 3/0 | 4/0 | 4/0
 | 70 | 88 | 6 | 4 | 2 | 2 | 1 | 1/0 | 2/0 | 3/0 | 3/0 | 4/0 | 4/0
 | 80 | 8 | 6 | 4 | 2 | 2 | 1 | 1/0 | 2/0 | 3/0 | 4/0 | 4/0
 | 90 | 8 | 4 | 2 | 2 | 1 | 1/0 | 2/0 | 3/0 | 4/0 | 4/0
 | 100 | 6 | 4 | 2 | 2 | 1 | 1/0 | 2/0 | 3/0 | 4/0
 | 110 | 6 | 4 | 2 | 2 | 1 | 1/0 | 2/0 | 3/0 | 4/0
 | 120 | 6 | 4 | 2 | 1 | 1/0 | 2/0 | 3/0 | 4/0
 | 130 | 6 | 2 | 2 | 1 | 1/0 | 2/0 | 3/0 | 4/0
 | 140 | 6 | 2 | 2 | 1/0 | 1/0 | 3/0 | 4/0
 | 150 | 6 | 2 | 1 | 1/0 | 2/0 | 3/0 | 4/0
 | 160 | 6 | 2 | 1 | 1/0 | 2/0 | 3/0 | 4/0
 | 170 | 6 | 2 | 1 | 1/0 | 3/0 | 3/0 | 4/0
Spreadsheet: 861313d1709215536-calculating-months-between-two-dates-sample-dates
Sheet: Sheet1

Start Date | End Date | Months
2021-02-08 00:00:00 | 2021-07-13 00:00:00 | 5.15
2021-07-14 00:00:00 | 2023-11-30 00:00:00 | 28.6
2023-12-01 00:00:00 | 2024-08-30 00:00:00 | 9.02
2024-08-31 00:00:00 | 2025-06-02 00:00:00 | 9.05
2025-06-03 00:00:00 | 2025-07-02 00:00:00 | 1
2025-07-03 00:00:00 | 2025-08-09 00:00:00 | 1.25
Spreadsheet: andy_zipper__733__LAXData102401
Sheet: Sheet1

 |  | Actual
 | 1961 | 1480.5
 | 1962 | 1117.5
 | 1963 | 1182
 | 1964 | 1321 |  |  | Period | Raw Average | Raw StDv
 | 1965 | 1373 |  |  | 10 Year (10 yrs avail.) | 997 | 227.4716392578791
 | 1966 | 940.5 |  |  | 20 Year (20 yrs avail.) | 1015.8 | 180.3978130337736
 | 1967 | 902.5 |  |  | 30 Year (30 yrs avail.) | 1024.533333333333 | 208.3064760129035
 | 1968 | 1282.5 |  |  | 40 Yr (usr.spc-- 40 yrs avail.) | 1059.4125 | 219.0854830787137
 | 1969 | 824.5
 | 1970 | 1216.5
 | 1971 | 1309
 | 1972 | 1203
 | 1973 | 1187.5 |  |  | Basis
 | 1974 | 1211 |  |  |  | NGI Socal | IF SJ | Diff
 | 1975 | 985.5 |  |  | 2002-01-01 00:00:00 | 13.5 | -21
 | 1976 | 871 |  |  | 2002-02-01 00:00:00 | 9 | -23
 | 1977 | 709.5 |  |  | 2002-03-01 00:00:00 | 7 | -26
 | 1978 | 1385
 | 1979 | 773.5 |  |  | Average
 | 1980 | 785
 | 1981 | 1019.5
 | 1982 | 1047
 | 1983 | 898.5
 | 1984 | 1342.5
 | 1985 | 874
 | 1986 | 952.5
 | 1987 | 997
 | 1988 | 1213.5
 | 1989 | 963.5
 | 1990 | 1038
 | 1991 | 807
 | 1992 | 1008.5
 | 1993 | 833.5
 | 1994 | 990.5
 | 1995 | 830.5
 | 1996 | 932.5
 | 1997 | 1129.5
 | 1998 | 1226.5
 | 1999 | 949.5
 | 2000 | 1262
Spreadsheet: 854412d1704297080-checking-each-field-taking-data-from-latest-field-and-adding-to-one-specific-cell-dummy
Sheet: W1

IDs (Week 1 (Week 13 since letter))
Group 1 | Group 2 |  |  |  | Group 3
No Contact | IDs | Date SMS Scheduled Date | SMS Status | Opted out | IDs | Date SMS Scheduled | SMS Status | Opted out? | Total Scheduled | Total Delivered | Total Opted out | Total Clicks | Total calls made | Total Successful | Total Rescheduled | Total Opt out of calls
 | 8562034278 |  |  |  | 9520646566 | 2024-04-13 00:00:00
 | 9589202725
 | 8057474746
 | 5652751540
 | 4734925930
 | 5966900976
 | 4807853457
 | 7899673125
 | 9483629917
 | 2287361995
 | 9642902272
 | 9716964381
 | 7220465653
 | 7683989698
 | 5568111241
 | 6263706085
 | 2788684122
 | 7576557635
 | 2498823015
 | 9672188603
 | 3038456649
 | 8037716290
 | 3347601087
 | 6318003613
 | 7355562231
 | 3623917937
 | 3830023589
 | 5322641589
Spreadsheet: 167100d1341901330-filtering-one-specific-name-in-excel-2010-copy-of-morning-attendance-2-
Sheet: 04 April 2012

Daily Morning Staff |  |  |  |  | Wednesday
 | 07:30-14:30 |  | 2012-04-04 00:00:00
Name | Staff No. | Title | Time In | Out | Locations | Remarks
Naima Mohamed | 2166 | Client Relation Supervisor | 07:30:00 | 14:30:00 | EFS
Sheikha [NAME] | 2120 | Reservation Officer | 07:30:00 | 14:30:00 | TOPS
Syed Sultan | 2888 | Supervisor | 07:30:00 | 14:30:00 | EFS
[NAME] | 4143 | Aircraft Team Leader | 07:30:00 | 14:30:00 | EFS
Jalil Nushadi | 1889 | Driver | 05:45:00 | 14:30:00 | EFS | last year balance leave 2011
[NAME] | 624 | Driver | 07:30:00 | 14:30:00 | EFS
Soud Sharar | 2097 | [NAME] Officer | 07:30:00 | 14:30:00 | [NAME] | Annual leave
[NAME] | 1897 | Manager | 07:30:00 | 14:30:00 | EFS | Sick leave
[NAME] | 4440 | Attendant | 07:30:00 | 14:30:00 | EFS
[NAME] | 1861 | Duty Officer | 07:30:00 | 14:30:00 | EFS | Comp off
Spreadsheet: robert_badeer__33096__STAR 10 minute meter data with DST explanation
Sheet: Sheet1

This document helps explain the changes in metering data for ISO metered entities which change to 10 minute intervals.
Star | This system always remains on Pacific Standard Time
Settlements | This system follows Daylight Savings Time (DST) and is currently operating in DST.
Since a meter is changed from one interval size to another based on a standard time day, those meters changing to a  10-minute interval will do so effective 8/31/00.  The last hour of Metering day 8/31 becomes the first hour  for the Settlement trade date 9/1, due to the Settlements DST shift.
Metering Day | MDEF File Hour | MDEF File Interval  Minute | STLMT STMT Hour | STLMT STMT Interval | Settlements Day
Metering - Aug. 30th | 24 | 00 | 1 | n/a | Settlements - Sep. 2nd
Metering - Aug. 31st | 1 | 00 | .. | n/a | " | Trade Date Aug. 30th
" | .. | 00 | 23 | n/a | "
" | 23 | 00 | 24 | n/a | "
" | 24 | 00 | 1 | n/a | Settlements - Aug. 31st
Metering - Aug. 31st | 1 | 00 thru 50 |  | n/a | "
" |  | 00 thru 50 |  | n/a | "
" |  | 00 thru 50 |  | n/a | "
" |  | 00 thru 50 |  | n/a | "
" |  | 00 thru 50 |  | n/a | "
" |  | 00 thru 50 |  | n/a | "
" |  | 00 thru 50 |  | n/a | "
" |  | 00 thru 50 |  | n/a | "
" |  | 00 thru 50 |  | n/a | " | Trade Date Aug. 31st
" |  | 00 thru 50 |  | n/a | "
" |  | 00 thru 50 |  | n/a | "
" |  | 00 thru 50 |  | n/a | "
" |  | 00 thru 50 |  | n/a | "
" |  | 00 thru 50 |  | n/a | "
" |  | 00 thru 50 |  | n/a | "
" |  | 00 thru 50 |  | n/a | "
" |  | 00 thru 50 |  | n/a | "
" |  | 00 thru 50 |  | n/a | "
" |  | 00 thru 50 |  | n/a | "
" |  | 00 thru 50 |  | n/a | "
" |  | 00 thru 50 |  | n/a | "
" |  | 00 thru 50 |  | n/a | "
" |  | 00 thru 50 |  | n/a | "
" |  | 00 thru 50 | 1 | 1 thru 6 | Settlements - Sep. 1st
Metering - Sep. 1st | 1 | 00 thru 50 |  | 1 thru 6 | "
" |  | 00 thru 50 |  | 1 thru 6 | "
" |  | 00 thru 50 |  | 1 thru 6 | "
" |  | 00 thru 50 |  | 1 thru 6 | "
" |  | 00 thru 50 |  | 1 thru 6 | "
" |  | 00 thru 50 |  | 1 thru 6 | "
" |  | 00 thru 50 |  | 1 thru 6 | "
" |  | 00 thru 50 |  | 1 thru 6 | "
" |  | 00 thru 50 |  | 1 thru 6 | " | Trade Date Sep. 1st
" |  | 00 thru 50 |  | 1 thru 6 | "
" |  | 00 thru 50 |  | 1 thru 6 | "
" |  | 00 thru 50 |  | 1 thru 6 | "
" |  | 00 thru 50 |  | 1 thru 6 | "
" |  | 00 thru 50 |  | 1 thru 6 | "
" |  | 00 thru 50 |  | 1 thru 6 | "
" |  | 00 thru 50 |  | 1 thru 6 | "
" |  | 00 thru 50 |  | 1 thru 6 | "
" |  | 00 thru 50 |  | 1 thru 6 | "
" |  | 00 thru 50 |  | 1 thru 6 | "
" |  | 00 thru 50 |  | 1 thru 6 | "
" |  | 00 thru 50 |  | 1 thru 6 | "
" |  | 00 thru 50 |  | 1 thru 6 | "
" |  | 00 thru 50 |  | 1 thru 6 | "
" |  | 00 thru 50 | 1 | 1 thru 6 | Settlements - Sep. 2nd
Metering - Sep. 2nd | 1 | 00 thru 50 | .. | 1 thru 6 | " | Trade Date Sep. 2nd
" | .. | 00 thru 50 | 23 | 1 thru 6 | "
" | 23 | 00 thru 50 | 24 | 1 thru 6 | "
" | 24 | 00 thru 50 | 1 | 1 thru 6 | Settlements - Sep. 3rd
Metering - Sep. 3rd | 1 | 00 thru 50 | .. | 1 thru 6 | " | Trade Date Sep. 3rd
" | .. | 00 thru 50 | 23 | 1 thru 6 | "
" | 23 | 00 thru 50 | 24 | 1 thru 6 | "
Spreadsheet: 881863d1730105820-shift-win-and-loss-scores-to-new-column-shift-win-scores
Sheet: Sheet1

 | 1 | 1–0 | 447 | 637 | 190 | Shofola, Christian (#89/CMR) | 637
 | 28 | 1–1 | 416 | 425 | 456 | Ojih, [NAME] (#18/NGA) |  | 425
 | 49 | 1–2 | 284 | 362 | 494 | Ezinore, [NAME] (#26/NGA) |  | 362
 | 36 | 2–2 | 290 | 425 | 419 | Rea, Gwen (#65/ZAF)
 | 50 | 2–3 | 289 | 440 | 441 | Mabinda, [NAME] (#62/UGA)
 | 36 | 3–3 | 444 | 516 | 361 | Umebiye, [NAME] (EXP) (#11/NGA)
 | 45 | 3–4 | 417 | 398 | 425 | Bah, Maju (#80/GMB)
 | 37 | 4–4 | 686 | 653 | 384 | [NAME], [NAME] (#54/UGA)
 | 27 | 5–4 | 763 | 386 | 309 | Darbo, Alhajie (#75/GMB)
 | 19 | 6–4 | 764 | 470 | 469 | Godwin, Victor (GM) (#3/NGA)
 | 31 | 6–5 | 762 | 420 | 422 | Ogedengbe, [NAME] (#10/NGA)
 | 39 | 6–6 | 705 | 382 | 439 | [NAME], [NAME] (#36/KEN)
 | 51 | 6–7 | 540 | 342 | 507 | Onoshevwe, Noble (#8/NGA)
 | 58 | 6–8 | 397 | 309 | 452 | John, Curtis (#17/NGA)
 | 48 | 7–8 | 469 | 504 | 432 | Oyejide, Olumide (#14/NGA)
 | 40 | 8–8 | 537 | 361 | 293 | Nderitu, Gitonga (EXP) (#29/KEN)
 | 33 | 9–8 | 625 | 487 | 399 | Koyyoko, [NAME] (#35/KEN)
 | 39 | 9–9 | 594 | 368 | 399 | John, Curtis (#17/NGA)
 | 33 | 10–9 | 609 | 410 | 395 | Ojih, [NAME] (#18/NGA)
 | 28 | 11–9 | 701 | 482 | 390 | Oyejide, Olumide (#14/NGA)
 | 35 | 11–10 | 585 | 372 | 488 | [NAME], [NAME] (EXP) (#6/KEN)
 | 43 | 11–11 | 525 | 358 | 418 | Akinyi, Wenwa (#40/KEN)
 | 34 | 12–11 | 578 | 461 | 408 | Ubiedi, Stanley (#68/GHA)
 | 45 | 12–12 | 440 | 359 | 497 | Ubiedi, Stanley (#68/GHA)
 | 50 | 12–13 | 256 | 327 | 511 | Nderitu, Gitonga (EXP) (#29/KEN)
 | 42 | 13–13 | 428 | 557 | 385 | Gruzd, [NAME] (#64/ZAF)
 | 46 | 13–14 | 421 | 404 | 411 | John, Curtis (#17/NGA)
 | 56 | 13–15 | 339 | 385 | 467 | Magu, [NAME] (#41/KEN)
 | 48 | 14–15 | 354 | 472 | 457 | John, Curtis (#17/NGA)
 | 56 | 14–16 | 274 | 332 | 412 | Magu, [NAME] (#41/KEN)
 | 64 | 14–17 | 143 | 355 | 486 | John, Curtis (#17/NGA)
 | 71 | 14–18 | 131 | 427 | 439 | Jallow, Babucarr (#81/GMB)
Spreadsheet: 215388d1361367125-how-to-correct-a-sheet-where-one-column-is-populated-with-number-ranges-like-2-210-etc-eample
Sheet: Sheet1

 | atribute(s) |  | range
 | selection or use |  | 4-220
 | rights |  | 121-179
 | consumer perception |  | 4-220
 | finance |  | 180
 | origin |  | 181-260
 | consumer perception |  | 1
 | finance |  | 94
 | finance |  | 221-227
 | finance |  | 2
 | consumer perception |  | 227-229
 | consumer perception |  | 245
 | consumer perception |  | 249-250
 | rights |  | 3
 | rights |  | 82-101
 | selection or use |  | 101-111
 | origin |  | 90-99
 | origin |  | 122
 | consumer perception |  | 16
Spreadsheet: daren_farmer__6635__Texas Nat_Gas Ops 0200 O&M Report
Sheet: Input

Input
 |  |  |  | 2 | 1 | 2000-01-01 00:00:00
 |  |  |  |  | 2 | 2000-02-01 00:00:00
 |  |  |  |  | 3 | 2000-03-01 00:00:00
 |  |  |  |  | 4 | 2000-04-01 00:00:00
 |  |  |  |  | 5 | 2000-05-01 00:00:00
 |  |  |  |  | 6 | 2000-06-01 00:00:00
 |  |  |  |  | 7 | 2000-07-01 00:00:00
 |  |  |  |  | 8 | 2000-08-01 00:00:00
 |  |  |  |  | 9 | 2000-09-01 00:00:00
 |  |  |  |  | 10 | 2000-10-01 00:00:00
 |  |  |  |  | 11 | 2000-11-01 00:00:00
ena |  |  |  |  | 12 | 2000-12-01 00:00:00
For the Month of February, 2000 and YTD
Spreadsheet: be098fbc-dc24-4a07-a594-fb5e960ea495
Sheet: Sheet1

Battle ID | Date & Time | Side | Victory | Score | Opp. Score | Opp. ID | Opp. Name | Scenario ID | Front | Start Date | End Date | Name EN | Name FR
42353377 | 2014-07-18 18:51:51 | AXIS | 0 | 3 | 6 | 458667 | black sheep | 8043 | eastern | 1939-09-08 | 1939-09-26 | Battle of Warsaw | Bataille de Varsovie
42355450 | 2014-07-18 22:06:48 | AXIS | 1 | 5 | 2 | 1600764 | guillaume.rose | 6160 | western | 1944-06-06 | 1944-06-06 | Sword Beach | Sword Beach
42355719 | 2014-07-18 22:23:30 | ALLIES | 1 | 5 | 2 | 1600764 | guillaume.rose | 6160 | western | 1944-06-06 | 1944-06-06 | Sword Beach | Sword Beach
42370281 | 2014-07-19 23:53:08 | AXIS | 0 | 2 | 6 | 1607416 | Unrealik264 | 7429 | mediterranean | 1941-06-15 | 1941-06-17 | [NAME] | [NAME]
42413658 | 2014-07-23 00:11:31 | ALLIES | 1 | 6 | 2 | 417473 | aikobo | 12496 | eastern | 1942-07-23 | 1942-08-08 | Battle of Kalatch | Bataille de Kalatch
42413828 | 2014-07-23 00:21:25 | AXIS | 1 | 6 | 2 | 417473 | aikobo | 12496 | eastern | 1942-07-23 | 1942-08-08 | Battle of Kalatch | Bataille de Kalatch
42420930 | 2014-07-23 15:01:32 | AXIS | 1 | 6 | 2 | 458667 | black sheep | 8043 | eastern | 1939-09-08 | 1939-09-26 | Battle of Warsaw | Bataille de Varsovie
42421091 | 2014-07-23 15:37:30 | ALLIES | 1 | 6 | 4 | 458667 | black sheep | 8043 | eastern | 1939-09-08 | 1939-09-26 | Battle of Warsaw | Bataille de Varsovie
42462359 | 2014-07-26 17:09:00 | ALLIES | 0 | 3 | 6 | 1362585 | NEMAUS | 7471 | mediterranean | 1942-06-05 | 1942-06-05 | Into the Cauldron | Le Chaudron
42462578 | 2014-07-26 17:21:13 | AXIS | 1 | 6 | 1 | 1362585 | NEMAUS | 7471 | mediterranean | 1942-06-05 | 1942-06-05 | Into the Cauldron | Le Chaudron
42491060 | 2014-07-28 17:21:25 | ALLIES | 0 | 4 | 6 | 1611893 | senaleung | 7471 | mediterranean | 1942-06-05 | 1942-06-05 | Into the Cauldron | Le Chaudron
42491231 | 2014-07-28 17:41:23 | AXIS | 0 | 5 | 6 | 1611893 | senaleung | 7471 | mediterranean | 1942-06-05 | 1942-06-05 | Into the Cauldron | Le Chaudron
42506378 | 2014-07-29 18:25:52 | ALLIES | 1 | 6 | 1 | 1467243 | [NAME] | 6150 | mediterranean | 1944-08-25 | 1944-08-25 | [NAME] | [NAME]
42506584 | 2014-07-29 18:41:36 | AXIS | 0 | 5 | 6 | 1467243 | [NAME] | 6150 | mediterranean | 1944-08-25 | 1944-08-25 | [NAME] | [NAME]
42508142 | 2014-07-29 20:48:53 | AXIS | 1 | 4 | 2 | 1611343 | DDB73 | 6161 | western | 1944-06-10 | 1944-06-10 | Mont Mouchet | Mont Mouchet
42508279 | 2014-07-29 21:00:59 | ALLIES | 1 | 4 | 0 | 1611343 | DDB73 | 6161 | western | 1944-06-10 | 1944-06-10 | Mont Mouchet | Mont Mouchet
42514268 | 2014-07-30 05:35:46 | AXIS | 1 | 6 | 1 | 1602528 | player1602528 | 12505 | western | 1945-02-17 | 1945-02-20 | Moyland Wood | [NAME]
42514366 | 2014-07-30 05:55:54 | ALLIES | 0 | 2 | 6 | 1602528 | player1602528 | 12505 | western | 1945-02-17 | 1945-02-20 | Moyland Wood | [NAME]
42524642 | 2014-07-31 00:28:27 | ALLIES | 0 | 4 | 7 | 298050 | MrBlonde | 7597 | eastern | 1941-10-18 | 1941-10-18 | Gates of Moscow | Aux portes [NAME]