tianzl66/Sheetpedia huggingface dataset:
Spreadsheet: 292328d1390565815-compare-data-on-two-tabs-and-populate-diffrences-on-new-tab-book6
Sheet: New

Request Number | Code | Date | Test No
12-0050 | 1234 | 2013-12-20 00:00:00 | 1
12-0051 | 2222 | 2013-12-21 00:00:00 | 547
12-0052 | 6745 | 2012-05-05 00:00:00 | 22
12-0053 | 6969 | 2012-05-06 00:00:00 | 4
12-0053 | 6969 | 2012-05-07 00:00:00 | 4
12-0054 | 6423 | 2013-12-24 00:00:00 | 3
12-0055 | 6423 | 2013-12-26 00:00:00 | 65
12-0056 | 6423 | 2013-12-26 00:00:00 | 5
12-0057 | 5432 | 2013-12-27 00:00:00 | 67
12-0058 | 6423 | 2013-12-29 00:00:00 | 5
12-0059 | 8765 | 2012-05-05 00:00:00 | 5
12-0061 | 8765 | 2012-05-07 00:00:00 | 765
12-0062 | 8768 | 2012-05-08 00:00:00 | 765
12-0063 | 6423 | 2012-05-09 00:00:00 | 235
12-0064 | 6423 | 2012-05-05 00:00:00 | 654
12-0065 | 5432 | 2012-05-06 00:00:00 | 34
12-0065 | 6423 | 2014-01-05 00:00:00 | 764
12-0065 | 5432 | 2014-01-06 00:00:00 | 34
12-0066 | 5432 | 2014-01-07 00:00:00 | 65
Spreadsheet: 119675d1314647658-vlookup-multiple-2012
Sheet: Multiple

 |  |  | CALCULATION SHEET
 |  |  | No.: |  | 51848 |  |  |  |  | Ref No: |  |  |  | EWSSE | 20451
 |  |  | Country of Export: |  |  | CANADA |  |  | Ex-Works | CIF |  | Terms of Shipment: |  |  | Ex-Works |  | Type of Shipment: |  | FCL
 |  |  | 20' DV | ORIGIN |  | Chicago |  |  | DESTINATION |  |  | Busan |  |  | CARRIER |  | Hapag Lloyd
 |  |  | 40' DV | ORIGIN |  | Chicago |  |  | DESTINATION |  |  | Busan |  |  | CARRIER |  | COSCO
 |  |  |  |  |  | VALUE |  | NO. |  |  |  | VALUE |  | NO.
 |  |  | No. of Containers |  |  |  | x | 1 | 20' Cntr | + |  |  | x | 1 | 40' Cntr
Spreadsheet: 09a15107-bf03-47f2-a9c3-0dbc26c8cf7c
Sheet: Average Cost of Setting

Preschool
7 | Number of students with disabilities enrolled (as of Dec 1)
15000 | Total salary and benefit costs of special education teachers providing service in preschool
3000 | Total salary and benefit costs of special education paraprofessionals providing service in preschool
 | Average Cost Per Preschool Student
General Education
 | Number of students with disabilities enrolled (as of Dec 1)
 | Total salary and benefit costs of special education teachers providing service in the general education classroom
 | Total salary and benefit costs of special education paraprofessionals providing service in the general education classroom
 | Average Cost Per General Education Student
Resource
 | Number of students with disabilities enrolled (as of Dec 1)
 | Total salary and benefit costs of special education teachers providing service using a pull-out (resource) model
 | Total salary and benefit costs of special education paraprofessionals providing service using a pull-out (resource) model
 | Average Cost Per Resource Student
Special Class
 | Number of students with disabilities enrolled (as of Dec 1)
 | Total salary and benefit costs of special education teachers providing service in a special class
 | Total salary and benefit costs of special education paraprofessionals providing service in a special class
 | Average Cost Per Special Class Student
Special School
 | Number of students with disabilities enrolled (as of Dec 1)
 | Total salary and benefit costs of special education teachers providing service in a special school
 | Total salary and benefit costs of special education paraprofessionals providing service in a special school
 | Average Cost Per Special School Student
Spreadsheet: 115639d1311188379-best-way-to-record-data-for-a-chart-time-line
Sheet: Sheet1

 |  |  | type 1-virus 2-worm 3-trojan
year
1971 | 1
1974 | 1
1974 | 1
1981 | 1
1983 | 1
 | 3
1986 | 1
1987 | 1
 | 1
 | 1
 | 1
 | 1
1988 | 1
 | 1
 | 1
1989 | 1
1990 | 1
1992 | 1
1993 | 1
1994 | 1
1995 | 1
1996 | 1
1998 | 1
1999 | 2
 | 2
 | 2
2000 | 2 | 1 | 2
 | 1
 | 2
2001 | 1
 | 2
 | 2
 | 2
 | 2
 | 2
2002 | 1
 | 3
 | 2
 | 3
2002 | 1
 | 3
 | 2
 | 3
2003 | 2
 | 3
 | 3
 | 2
 | 2
 | 2
 | 2
 | 2
 | 2
 | 2
2004 | 2
 | 2
 | 2
 | 2
 | 2
 | 2
 | 3
 | 3
 | 2
2005 | 2
 | 2
 | 3
 | 3
2006 | 2 | 3 | 2 | 2
2007 | 2 | 3
2008 | 3 | 3 | 3 | 3 | 2 | 2
2009 | 2
2010 | 3 | 1
2011 | 3
Spreadsheet: 873603d1720105602-add-additional-calculation-to-existing-if-argument-if-formula3
Sheet: Sheet 1 (2)

 | Minutes |  | 60 | 45 | 30
 | Other Fee Total |  | 60 | 45 | 30
 | House Fee |  | 30 | 25 | 20
 | Shared fee |  | 30 | 20 | 10
 |  |  | Service Fee | Other Fee | Total Charge | Paid  To Me | Paid To House | House owes Me | Total Rec'd
Qty | Time IN | Duration
1 | 6.35 | 60 | 60 |  |  | 60
 | 7.35 | 45 | 60 |  |  | 0
 | 8.35 | 45 | 60 |  |  | 105
Spreadsheet: 80499d1280749118-populate-a-cell-with-information-that-is-based-on-2-items-in-the-spreadsheet-book1-division
Sheet: Sheet1

 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 6 |  | Mighty Mite
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 7 |  | Mighty Mite
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 8 | 70 | Mighty Mite
 |  | Age | Weight |  | Division |  |  | Item Name | 0 |  |  | Weight |  |  |  | 8 | 105 | Mighty Mite
 |  | 11 | 45 |  |  |  |  | 6 | Mighty Mite |  |  | Division |  |  |  | 8 |  | [NAME]
 |  | 7 | 13 |  |  |  |  |  |  |  |  |  |  |  |  | 9 | 100 | [NAME]
 |  | 9 | 105 |  |  |  |  |  | 0 |  |  | Weight |  |  |  | 9 | 130 | Junior
 |  | 6 | 131 |  |  |  |  | 7 | Mighty Mite |  |  | Division |  |  |  | 9 |  | Junior
 |  | 10 | 145 |  |  |  |  |  |  |  |  |  |  |  |  | 10 | 75 | [NAME]
 |  | 12 | 140 |  |  |  |  |  | 0 | 105 |  | Weight |  |  |  | 10 | 120 | Junior
 |  | 12 | 35 |  |  |  |  | 8 | Mighty Mite | [NAME] |  | Division |  |  |  | 10 | 140 | Junior 1
 |  | 13 | 22 |  |  |  |  |  |  |  |  |  |  |  |  | 10 |  | Junior 1
 |  | 14 | 33 |  |  |  |  |  | 0 | 130 |  | Weight |  |  |  | 11 | 100 | Junior
 |  |  |  |  |  |  |  | 9 | [NAME] | Junior |  | Division |  |  |  | 11 | 130 | Junior 1
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 11 | 150 | Junior 2
 |  |  |  |  |  |  |  |  | 0 | 120 | 130 | Weight |  |  |  | 11 |  | Junior 2
 |  |  |  |  |  |  |  | 10 | [NAME] | Junior | Junior 1 | Division |  |  |  | 12 | 110 | Junior 1
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 12 | 140 | Junior 2
 |  |  |  |  |  |  |  |  | 0 | 100 | 130 | Weight |  |  |  | 12 | 200 | Senior
 |  |  |  |  |  |  |  | 11 | Junior | Junior 1 | Junior 2 | Division |  |  |  | 12 |  | Senior
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 13 | 120 | Junior 2
 |  |  |  |  |  |  |  |  | 0 | 110 | 140 | Weight |  |  |  | 13 | 190 | Senior
 |  |  |  |  |  |  |  | 12 | Junior 1 | Junior 2 | Senior | Division |  |  |  | 13 |  | Senior
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 14 | 185 | Senior
 |  |  |  |  |  |  |  |  | 0 | 120 |  | Weight |  |  |  | 14 |  | Senior
 |  |  |  |  |  |  |  | 13 | Junior 2 | Senor |  | Division
 |  |  |  |  |  |  |  |  | 0 |  |  | Weight
 |  |  |  |  |  |  |  | 14 | Senior |  |  | Division
Spreadsheet: 41296d1239792899-vlookup-from-multiple-sheets-shift-schedule
Sheet: RACKING

RACKING
[NAME]. | SAP NO. | NAME | SECTION
 | 1197 |  |  | A,
 | 1250 |  |  | A,
 | 1262 |  |  | A,
 | 1264 |  |  | A,
 | 1337 |  |  | A,
 | 1629 |  |  | A,
 | 2432 |  |  | A,
 | 2701 |  |  | A,
 | 2740 |  |  | A,
 | 2762 |  |  | A,
 |  | 'A' SHIFT
 |  | 'B' SHIFT
 |  | 'C' SHIFT
 |  | 'G' SHIFT
 |  | TOTAL:
Spreadsheet: 714423d1611224646-formula-to-check-date-range-timeline_ex-ans
Sheet: Sheet1 (2)

 | Component | Phases |  |  |  |  |  |  | 2020 |  |  |  |  |  |  |  |  |  |  |  | 2021
 |  | A |  | B |  | C |  |  | 2020-01-01 00:00:00 | 2020-02-01 00:00:00 | 2020-03-01 00:00:00 | 2020-04-01 00:00:00 | 2020-05-01 00:00:00 | 2020-06-01 00:00:00 | 2020-07-01 00:00:00 | 2020-08-01 00:00:00 | 2020-09-01 00:00:00 | 2020-10-01 00:00:00 | 2020-11-01 00:00:00 | 2020-12-01 00:00:00 | 2021-01-01 00:00:00 | 2021-02-01 00:00:00 | 2021-03-01 00:00:00 | 2021-04-01 00:00:00 | 2021-05-01 00:00:00
 | X | 2020-05-25 00:00:00 | 2020-06-29 00:00:00 | 2020-06-30 00:00:00 | 2020-08-04 00:00:00 | 2020-08-05 00:00:00 | 2020-09-09 00:00:00
 | Y | 2020-03-04 00:00:00 | 2020-04-08 00:00:00 | 2020-04-09 00:00:00 | 2020-04-28 00:00:00 | 2020-04-29 00:00:00 | 2020-05-18 00:00:00
 | Z | 2020-09-24 00:00:00 | 2020-10-05 00:00:00 | 2020-10-06 00:00:00 | 2020-11-30 00:00:00 | 2020-12-01 00:00:00 | 2021-01-25 00:00:00
 | S | 2020-01-24 00:00:00 | 2020-03-08 00:00:00 | 2020-03-09 00:00:00 | 2020-04-22 00:00:00 | 2020-04-23 00:00:00 | 2020-07-31 00:00:00
 | T | 2020-07-08 00:00:00 | 2020-08-06 00:00:00 | 2020-08-07 00:00:00 | 2020-09-05 00:00:00 | 2020-09-06 00:00:00 | 2020-12-14 00:00:00
Spreadsheet: 765437d1643315473-determining-work-time-based-on-criteria-splitshiftef-dexter2-
Sheet: Data

Base | 00:10:00 |  |  | Span of Shift
Location A | 00:00:00 |  | Base | Report for Roll Call
Location B | 00:10:00 |  |  | Start 1st Shift of Work | 07:55:00
Location C | 00:15:00 |  |  | End Shift | 10:58:00
Location D | 00:30:00
Combination | 00:15:00 |  |  | Break
 |  |  | Base | Report for 2nd Roll Call
 |  |  |  | Pull out | 14:23:00
 |  |  |  | 11th hr
 |  |  |  | End of 2nd Shift and Work Day | 19:35:00
 |  |  |  | Job Time
 |  |  |  | Report Time
 |  |  |  | Commute Time
 |  |  |  | Work Time
 |  |  |  | Straight Time
 |  |  |  | Over Time
Spreadsheet: larry_may__21870__Gas Daily Option  Offer
Sheet: Sheet1

Offer:  3 yr Gas Daily Fixed Price Straddle at the price, volumes and locations below.
 | El Paso Perm | Waha
Strike | 3.47 | 3.5
Month
2002-01-01 00:00:00 | 13000 | 7000
2002-02-01 00:00:00 | 8000 | 7000
2002-03-01 00:00:00 | 10000 | 7000
2002-04-01 00:00:00 | 9000 | 3000
2002-05-01 00:00:00 | 9000 | 3000
2002-06-01 00:00:00 | 8000 | 3000
2002-07-01 00:00:00 | 5000 | 2000
2002-08-01 00:00:00 | 7000 | 2000
2002-09-01 00:00:00 | 14000 | 2000
2002-10-01 00:00:00 | 10000 | 7000
2002-11-01 00:00:00 | 10000 | 7000
2002-12-01 00:00:00 | 12000 | 7000
2003-01-01 00:00:00 | 14000 | 7000
2003-02-01 00:00:00 | 8000 | 7000
2003-03-01 00:00:00 | 10000 | 7000
2003-04-01 00:00:00 | 10000 | 3000
2003-05-01 00:00:00 | 9000 | 3000
2003-06-01 00:00:00 | 7000 | 3000
2003-07-01 00:00:00 | 7000 | 3000
2003-08-01 00:00:00 | 7000 | 3000
2003-09-01 00:00:00 | 15000 | 3000
2003-10-01 00:00:00 | 11000 | 7000
2003-11-01 00:00:00 | 11000 | 7000
2003-12-01 00:00:00 | 12000 | 7000
2004-01-01 00:00:00 | 13000 | 6000
2004-02-01 00:00:00 | 7000 | 6000
2004-03-01 00:00:00 | 10000 | 6000
2004-04-01 00:00:00 | 9000 | 3000
2004-05-01 00:00:00 | 10000 | 3000
2004-06-01 00:00:00 | 7000 | 3000
2004-07-01 00:00:00 | 8000 | 2000
2004-08-01 00:00:00 | 9000 | 2000
2004-09-01 00:00:00 | 16000 | 2000
2004-10-01 00:00:00 | 12000 | 8000
2004-11-01 00:00:00 | 11000 | 8000
2004-12-01 00:00:00 | 11000 | 8000
Spreadsheet: 33977d1230943180-daily-timesheet-data-collection-timesheet
Sheet: Sheet1

DAILY TIME SHEET
DIVISION
 |  |  |  |  | 9000 | 9001 | 9005 | 9015 | 9025 | 9029 | 9031 |  | * CONTRACT TICKET NUMBER
 |  |  |  |  | [PHONE] | [PHONE] | [PHONE] | 023023000 | [PHONE] | [PHONE] | [PHONE] |  | * Indicates mandatory information which must be completed before time sheet is submitted to payroll
 |  | *CONTRACT NUMBER
SHIFT: |  | DAYS
SHEET |  | 1  OF  8
SITE: |  |  |  |  | CP | CP | CP | CP | CP | CP | CP |  | INDICATE LUMP SUM OR C/P
 |  |  |  |  | ICI | ICI | ICI | ICI | ICI | ICI | ICI |  | *INDICATE ICI, NMA, GPA, EPSCA
DATE |  |  |  |  | MARK NUMBER OF UNITS COMPLETED BELOW
 |  | DAY        MONTH | YEAR
 |  |  |  |  | MARK AN (X) BELOW FOR COMPLETED OPERATIONS |  |  |  |  |  |  |  | $ value for shift premium or substitute rate to be paid that day
FOREMAN:
 |  |  |  |  | MARK OPERATION NUMBERS BELOW
*TRADE | * EMPLOYEE NAME |  | * EMPLOYEE NUMBER |  |  |  |  |  |  |  |  | TOTALS | TOTAL HOURS PAID | SUB  SHIFT PREM | MEAL $ TRAVEL$ BOARD$
 | [NAME] |  |  | ST |  | 3 |  | 6 |  | 2
 |  |  |  | OT |  |  | 3
 |  |  |  | DT
 | BOB |  |  | ST | 4 |  |  |  |  |  | 5
 |  |  |  | OT |  |  |  | 2
 |  |  |  | DT |  |  |  |  |  | 2
 | MARK |  |  | ST | 2 |  | 3 |  | 5
 |  |  |  | OT
 |  |  |  | DT |  |  |  | 4
 |  |  |  | ST
 |  |  |  | OT
 |  |  |  | DT
 |  |  |  | ST
 |  |  |  | OT
 |  |  |  | DT
 |  |  |  | ST
 |  |  |  | OT
 |  |  |  | DT
 |  |  |  | ST
 |  |  |  | OT
 |  |  |  | DT
 |  |  |  | ST
 |  |  |  | OT
 |  |  |  | DT
 |  |  |  | ST
 |  |  |  | OT
 |  |  |  | DT
ST = | hours @ straight time |  | TOTAL | ST
OT = | hours @ time and a half |  | TOTAL | OT
DT = | hours @ double time |  | TOTAL | DT
Signed By: |  |  |  |  |  |  | Approved By:
Spreadsheet: andy_zipper__189__Broker detail 5-22-01
Sheet: BROKER DEAL SUMMARY

EnronOnline Broker Detail for 5/22/2001
Completed Transactions:
TODAY
Date | 2001-05-22 00:00:00
 | Data | Commodity
 | DEAL COUNT |  | BROKER SAVING |  | Total DEAL COUNT | Total BROKER SAVING
Broker | Natural Gas | Power | Natural Gas | Power
APB Energy, Inc. | 5 | 15 | 2600 | 351.84 | 20 | 2951.84
Natsource LLC |  | 12 |  | 1053 | 12 | 1053
Amerex Natural Gas I, Ltd. | 2 |  | 611.25 |  | 2 | 611.25
Amerex Power, Ltd. |  | 1 |  | 120 | 1 | 120
Grand Total | 7 | 28 | 3211.25 | 1524.84 | 35 | 4736.09
LIFE TO DATE (First Trade March 28, 2001)
 | Data | Commodity
 | DEAL COUNT |  | BROKER SAVING |  | Total DEAL COUNT | Total BROKER SAVING
Broker | Natural Gas | Power | Natural Gas | Power
APB Energy, Inc. | 52 | 142 | 14556.25 | 8312.04 | 194 | 22868.29
Natsource LLC | 28 | 190 | 4207.5 | 17469 | 218 | 21676.5
Power Merchants Group, LLC | 8 |  | 634.83 |  | 8 | 634.83
Amerex Natural Gas I, Ltd. | 28 | 1 | 4925 | 4 | 29 | 4929
Amerex Power, Ltd. |  | 4 |  | 512 | 4 | 512
Grand Total | 116 | 337 | 24323.58 | 26297.04 | 453 | 50620.62
Failed Transactions:
TODAY
Date | 2001-05-22 00:00:00
FAILED TRANSACTION COUNT | Commodity
Broker | Natural Gas | Power | Grand Total
Natsource LLC |  | 5 | 5
Power Merchants Group, LLC | 3 |  | 3
Grand Total | 3 | 5 | 8
LIFE TO DATE (First Trade March 28, 2001)
FAILED TRANSACTION COUNT | Commodity
Broker | Natural Gas | Power | Grand Total
APB Energy, Inc. | 20 | 22 | 42
Natsource LLC | 4 | 36 | 40
Power Merchants Group, LLC | 20 |  | 20
Amerex Natural Gas I, Ltd. | 4 |  | 4
Amerex Power, Ltd. |  | 1 | 1
Grand Total | 48 | 59 | 107
Spreadsheet: 107506d1304653031-macro_transpose-macro
Sheet: Sheet1

Year | Rainfall
199701 | 25.5 |  | Year | Jan | Feb | Mar | Apr | May | Jun | Jul | Aug | Sep | Oct | Nov | Dec
199702 | 5 |  | 1997 | 25.5 | 5 | 18.2 | 12.8 | 59.2 | 33.4 | 19.2 | 29.7 | 55.9 | 28.6 | 54.9 | 5.7
199703 | 18.2 |  | 1998
199704 | 12.8 |  | 1999
199705 | 59.2 |  | 2000
199706 | 33.4 |  | 2001
199707 | 19.2 |  | 2002
199708 | 29.7 |  | 2003
199709 | 55.9 |  | 2004
199710 | 28.6 |  | 2005
199711 | 54.9 |  | 2006
199712 | 5.7 |  | 2007
199801 | 52.1 |  | 2008
199802 | 72.4 |  | 2009
199803 | 8.1
199804 | 55.7
199805 | 43.5
199806 | 57.6
199807 | 43.5
199808 | 21
199809 | 32.9
199810 | 87.7
199811 | 56.7
199812 | 62.7
199901 | 29.8
199902 | 35.6
199903 | 47.3
199904 | 25.2
199905 | 55.6
199906 | 47.1
199907 | 15.3
199908 | 76.2
199909 | 28.2
199910 | 59.3
199911 | 32.9
199912 | 101
200001 | 28.9
200002 | 38.5
200003 | 25.8
200004 | 42.2
200005 | 82.2
200006 | 40.4
200007 | 50
200008 | 44.4
200009 | 80.6
200010 | 108.2
200011 | 38
200012 | 34.4
200101 | 12.1
200102 | 8.9
200103 | 85.9
200104 | 114.6
200105 | 17.4
200106 | 59.8
200107 | 13.4
200108 | 51
200109 | 39.9
200110 | 76
200111 | 70.5
200112 | 59.5
200201 | 35.7
200202 | 76
200203 | 28.2
200204 | 42.6
200205 | 35.9
200206 | 28.6
200207 | 26.6
200208 | 40.7
200209 | 34
200210 | 27
200211 | 24.5
200212 | 11
200301 | 11.8
200302 | 19.2
200303 | 18.3
200304 | 67.3
200305 | 24.4
200306 | 34
200307 | 71.6
200308 | 53
200309 | 35.7
200310 | 67.5
200311 | 19.2
200312 | 62.6
200401 | 48
200402 | 14.1
200403 | 14.7
200404 | 48.2
200405 | 24.7
200406 | 43.2
200407 | 33.1
200408 | 67.1
200409 | 56.9
200410 | 65.5
200411 | 112.8
200412 | 44.7
200501 | 19.5
200502 | 157.3
200503 | 10.5
200504 | 28.2
200505 | 10.7
200506 | 40.4
200507 | 26.4
200508 | 60.2
200509 | 44.7
200510 | 42.1
200511 | 55.3
200512 | 61.6
200601 | 50.3
200602 | 54.5
200603 | 17.5
200604 | 47
200605 | 64.1
200606 | 11.7
200607 | 40.7
200608 | 31.8
200609 | 31.5
200610 | 8.5
200611 | 25
200612 | 15.4
200701 | 31.9
200702 | 17.6
200703 | 41.9
200704 | 22.4
200705 | 39.4
200706 | 40.4
200707 | 64.7
200708 | 15.9
200709 | 19.4
200710 | 20.5
200711 | 56.9
200712 | 75.7
Spreadsheet: 721423d1614698975-call-column-for-the-data-from-the-same-group-fruits-group-ans
Sheet: Sheet1

 |  |  |  |  |  | Fruit | Group | Group
 | GroupA | GroupB | GroupC | GroupD |  | [NAME]
 | [NAME] | Orange | Grape | BlueBerry |  | Lychee |  | GroupA , GroupD
 | Lychee | Apple | Orange | Soursop |  | Strawbery |  | GroupA
 | Pomegranate | Pomegranate | Kiwi | Pomegranate |  | Orange |  | GroupB , GroupC
 | Strawbery | Mango | Avocado | Lychee |  | Apple |  | GroupB
 |  |  |  |  |  | Pomegranate |  | GroupA , GroupB , GroupD
 |  |  |  |  |  | Mango |  | GroupB
 |  |  |  |  |  | Grape |  | GroupC
 |  |  |  |  |  | Kiwi |  | GroupC
 |  |  |  |  |  | Avocado |  | GroupC
 |  |  |  |  |  | BlueBerry |  | GroupD
 |  |  |  |  |  | Soursop |  | GroupD
Spreadsheet: 467232d1466622829-range-formula-help-needed-pivot-vs-countifs-and-averageifs
Sheet: VSM-AvgPivot

Average of Median of Total Hours (based on spec.) |  | Motor Type | HP Bucket |  |  |  |  |  |  |  |  | Average of Median of Total Hours (based on spec.) |  | Motor Type | HP Bucket
 |  | [NAME] | [NAME] | (blank) | Grand Total |  |  |  |  |  |  |  |  | Vented Core | Vented Core | Vented Core | Vented Core | (blank) | Grand Total
Frame Family | Pole | 0>700 | 701>1250 | (blank) |  |  |  |  |  |  |  | Frame Family | Pole | 0>700 | 1251>3000 | 3001>18,000 | 701>1250 | (blank)
500 | 2-Pole | 1.9462 |  |  | 1.9462 |  |  |  |  |  |  | 500 | 2-Pole | 2.903062499999999 |  |  | 3.419999999999999 |  | 3.124607142857143
500 Total |  | 1.9462 |  |  | 1.9462 |  |  |  |  |  |  | 500 | 4-Pole | 2.483375 |  |  |  |  | 2.483375
580 | 2-Pole | 1.621166666666667 | 0.923 |  | 1.521428571428572 |  |  |  |  |  |  | 500 | 6-Pole | 3.264 |  |  |  |  | 3.264
580 Total |  | 1.621166666666667 | 0.923 |  | 1.521428571428572 |  |  |  |  |  |  | 500 | 8-Pole | 1.551 |  |  |  |  | 1.551
(blank) | (blank) |  |  |  |  |  |  |  |  |  |  | 500 Total |  | 2.75537037037037 |  |  | 3.419999999999999 |  | 2.959871794871795
(blank) Total |  |  |  |  |  |  |  |  |  |  |  | 580 | 10-Pole | 2.77 |  |  |  |  | 2.77
Grand Total |  | 1.768909090909091 | 0.923 |  | 1.698416666666667 |  |  |  |  |  |  | 580 | 2-Pole | 1.272 | 1.839904761904761 |  | 2.640428571428572 |  | 1.927509803921568
 |  |  |  |  |  |  |  |  |  |  |  | 580 | 4-Pole | 1.324 | 2.304 |  | 3.519 |  | 2.594
 |  |  |  |  |  |  |  |  |  |  |  | 580 | 6-Pole | 2.3305 | 2.445 |  | 2.06325 |  | 2.194142857142857
 |  |  |  |  |  |  |  |  |  |  |  | 580 | 8-Pole | 6.596 |  |  | 3.637 |  | 5.1165
 |  |  |  |  |  |  |  |  |  |  |  | 580 Total |  | 2.556428571428571 | 1.873977777777777 |  | 2.672214285714286 |  | 2.115681818181818
 |  |  |  |  |  |  |  |  |  |  |  | 630 | 4-Pole |  |  | 3.4535 |  |  | 3.4535
 |  |  |  |  |  |  |  |  |  |  |  | 630 Total |  |  |  | 3.4535 |  |  | 3.4535
 |  |  |  |  |  |  |  |  |  |  |  | 680 | 2-Pole | 1.117 | 1.865 | 3.5045 |  |  | 2.146222222222222
 |  |  |  |  |  |  |  |  |  |  |  | 680 | 6-Pole |  | 3.6485 |  |  |  | 3.6485
 |  |  |  |  |  |  |  |  |  |  |  | 680 | 8-Pole |  | 6.182 |  |  |  | 6.182
 |  |  |  |  |  |  |  |  |  |  |  | 680 Total |  | 1.117 | 2.906 | 3.5045 |  |  | 2.863714285714285
 |  |  |  |  |  |  |  |  |  |  |  | 710 | 12-Pole |  |  | 0.663 |  |  | 0.663
 |  |  |  |  |  |  |  |  |  |  |  | 710 Total |  |  |  | 0.663 |  |  | 0.663
 |  |  |  |  |  |  |  |  |  |  |  | 800 | 2-Pole |  | 2.227 | 3.272 |  |  | 2.7495
 |  |  |  |  |  |  |  |  |  |  |  | 800 | 4-Pole |  |  | 3.43 |  |  | 3.43
 |  |  |  |  |  |  |  |  |  |  |  | 800 | 8-Pole |  | 5.643999999999999 |  |  |  | 5.643999999999999
 |  |  |  |  |  |  |  |  |  |  |  | 800 Total |  |  | 3.9355 | 3.335199999999999 |  |  | 3.662636363636364
 |  |  |  |  |  |  |  |  |  |  |  | (blank) | (blank)
 |  |  |  |  |  |  |  |  |  |  |  | (blank) Total
 |  |  |  |  |  |  |  |  |  |  |  | Grand Total |  | 2.668771428571429 | 2.25658064516129 | 3.1255 | 3.017346153846153 |  | 2.579105263157895
Spreadsheet: 723042d1615485933-balance-sheet-samples
Sheet: Sheet1

Debit | Credit | -1403500
 | 1000
 | 500
 | 500
 | 6000
 | 1395500
2000000
500 |  |  | Can anybody correct this formula
 | 1000
 | 3000
 | 20000
 | 5000
 | 20000
 | 20000
 | 20000
 | 5000
 | 3000
 | 1000
 | 4000
 | 7000
 | 5000
 | 2000
 | 20000
 | 20000
Spreadsheet: 860151d1708359084-help-with-transferring-data-from-one-worksheet-to-another-test-1-etaf
Sheet: Sheet2

Date | Room Occupied | Occupancy Rate |  | In the example I have attached I need to extract data from Sheet 1 to sheet 2 however I only need Brazil and I need Column B to start at Cell A4 in Sheet 2 and Column A to start in B4.
 | 1
2024-01-01 00:00:00 | 5
2024-01-03 00:00:00 | 8
2024-01-05 00:00:00 | 9
2024-01-06 00:00:00 | 10
2024-01-02 00:00:00 | 15
2024-01-03 00:00:00 | 8
2024-01-05 00:00:00 | 2
2024-02-05 00:00:00 | 2
Spreadsheet: 106754d1303939077-dragging-formulas-to-adjacent-cells-book1
Sheet: Sheet1

sample number | x_bar 1 | x-bar 2 | x_bar 3 | x_double bar vector
1 | 1 | 2 | 3 | 3
2 | 2 | 3 | 4 | 4
3 | 3 | 4 | 5 | 5
4 | 4 | 5 | 6
5 | 5 | 6 | 7
6 | 6 | 7 | 8
7 | 7 | 8 | 9
8 | 8 | 9 | 10
9 | 9 | 10 | 11
10 | 10 | 11 | 12
11 | 11 | 12 | 13
12 | 12 | 13 | 14
13 | 13 | 14 | 15
14 | 14 | 15 | 16
15 | 15 | 16 | 17
sample number | 1 | 2 | 3 | 4 | 5 | 6 | 7 | 8 | 9 | 10 | 11 | 12 | 13 | 14 | 15
diff 1
diff 2
diff 3
Spreadsheet: 681520d1591624370-formula-to-update-data-on-two-tabs-in-multiple-tables-excel-help_territory-analysis-lwt_6_8_20
Sheet: 4 States

Northeast |  |  |  | Northwest |  |  |  | Southeast |  |  |  | Southwest
State | Orders | Count |  | State | Orders | Count |  | State | Orders | Count |  | State | Orders | Count
CT | 5214 | 17 |  | AK | 409 | 1 |  | AL | 1657 | 16 |  | AZ | 4514 | 18
DE | 672 | 3 |  | IA | 2295 | 12 |  | AR | 1958 | 14 |  | CA | 14736 | 94
IL | 12306 | 44 |  | ID | 596 | 6 |  | FL | 9246 | 48 |  | CO | 4228 | 16
IN | 5559 | 27 |  | MT | 0 | 2 |  | GA | 4260 | 25 |  | HI | 551 | 5
MA | 4476 | 32 |  | ND | 985 | 7 |  | KY | 4486 | 21 |  | KS | 3680 | 17
MD | 5178 | 30 |  | OR | 3191 | 16 |  | LA | 2104 | 10 |  | NE | 1091 | 10
ME | 1164 | 7 |  | SD | 566 | 6 |  | MS | 709 | 4 |  | NM | 0 | 0
MI | 8594 | 44 |  | WA | 3511 | 22 |  | NC | 3734 | 25 |  | NV | 530 | 4
MN | 4299 | 28 |  | WI | 5828 | 35 |  | SC | 2342 | 21 |  | OK | 1469 | 18
MO | 6822 | 30 |  | WY | 0 | 1 |  | TN | 4514 | 23 |  | TX | 10720 | 65
NH | 978 | 7 |  |  |  |  |  |  |  |  |  | UT | 1957 | 14
NJ | 5789 | 34
NY | 13574 | 72
OH | 8860 | 39
PA | 12582 | 46
RI | 1160 | 8
VA | 5400 | 33
VT | 85 | 1
WV | 1051 | 3
Spreadsheet: 106490d1303763576-text-to-columns-rowstocolumns-parsemacros
Sheet: Part 1a2

Server | Group Name | Group ID | User ID | User ID | User ID | User ID | User ID | User ID | User ID
Server 1 | super | 1 | [NAME] | [NAME] | ted
Server 1 | duper | 2 | sting | bowie
Server 1 | admins | 3 | bob | [NAME] | [NAME] | [NAME] | stuart | [NAME] | [NAME]
Server 1 | operator | 4 | bob | [NAME] | [NAME] | [NAME]
Server 2 | admins | 3 | bob | [NAME] | [NAME] | [NAME]
Server 2 | operator | 4 | [NAME] | [NAME] | gordy | batman | ted | [NAME]
Server 2 | dba | 5 | cheetah | leopard | jaguar
 |  |  |  |  |  |  |  | Press Alt-F8 and run the [NAME] macro