tianzl66/Sheetpedia huggingface dataset:
Spreadsheet: 08b573e6-8b84-4126-ba05-603cda8a97ed
Sheet: Sheet1

Table 9--Wheat:  U.S. exports, [NAME] and export sales comparison (1,000 metric tons),7/9/13 | Unnamed: 1 | Unnamed: 2 | Unnamed: 3 | Unnamed: 4 | Unnamed: 5 | Unnamed: 6 | Unnamed: 7
 | 2011/12 |  | 2012/13 |  | 2013/14 (as of 7/04/13)
Importing |  |  |  |  |  | Out-
country |  |  |  |  | Shipments | standing | Total
Data |  | Export |  | Export | Export
source | Census 1/ | sales 2/ | Census 1/ | sales 2/ | sales 2/
Country:
China | 541.5 | 534.3 | 883.4 | 742.7 | 523.4 | 2329 | 2852.4
Japan | 3513.4 | 3512.1 | 3638.5 | 3544 | 159.6 | 554.4 | 714
Mexico | 3794.3 | 3495.9 | 2906.6 | 2760 | 298.8 | 748.9 | 1047.7
Nigeria | 3227.8 | 3248 | 3031.4 | 3002 | 206.6 | 415.2 | 621.8
Philippines | 2050 | 2038.6 | 1850.3 | 1965 | 72.6 | 402.5 | 475.1
Korean Rep. | 2132.9 | 1983 | 1311.4 | 1385 | 52.8 | 153.9 | 206.7
Egypt | 915.5 | 949.8 | 1736.8 | 1678 | 58.1 | 0 | 58.1
Taiwan | 893.2 | 887.9 | 1064.7 | 1038 | 86.8 | 96.7 | 189.4
Indonesia | 794 | 830 | 488.2 | 534 | 57.8 | 40 | 97.8
Venezuela | 642.2 | 593.5 | 631.6 | 631.4 | 7.2 | 182.9 | 190.1
Iraq | 571.8 | 571.8 | 208.9 | 208.9 | 0 | 0 | 0
EU-27 | 1186.3 | 1228.1 | 1322.8 | 970.8 | 56.7 | 43.1 | 99.80000000000001
Total grain | 27950.6 | 26627.3 | 26836.6 | 26348.1 | 2877.4 | 7760.3 | 10637.7
Total (including
products) | 28563 | 26812.5 | 27115.6 | 26410.1 | 2882.2 | 7768.2 | 10650.4
USDA forecast
of Census |  |  |  | 27472 |  |  | 29257
1/ Source:  U.S. Department of Commerce, U.S. Census Bureau
2/ Source:  USDA, Foreign Agricultural Service, U.S. Export Sales.
Source:  USDA, Foreign Agricultural Service, U.S. Export Sales.
Spreadsheet: john_forney__15496__SCHED2001
Sheet: MAY'01

 |  |  |  |  |  |  |  |  |  |  | 24 HOUR SCHEDULE
 |  |  |  |  |  |  |  |  |  |  |  |  | MAY
NAME | TUE | WED | THU | FRI | SAT | SUN | MON | TUE | WED | THU | FRI | SAT | SUN | MON | TUE | WED | THU | FRI | SAT | SUN | MON | TUE | WED | THU | FRI | SAT | SUN | MON | TUE | WED | THU
ERCOT | 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
[NAME] | D | D | D | D |  |  | D | D | D | D | D |  |  | D | D | D | D | D
[NAME]
[NAME] |  |  |  | N | N | N | N |  |  |  |  |  |  |  |  |  | N |  | D | D | D | D | D |  | N | N | N | N | N |  | D
CHRIS WATTS | N | N | N |  | D | D | D | D | D |  |  | N | N |  |  |  |  |  |  |  | N | N | N | N |  |  |  | D | D | D
[NAME] |  |  |  |  |  |  |  | N | N | N |  | V | V | N | N | N |  | N | N | N |  |  |  |  | D | D | D |  |  | N | N
SOUTHEAST
[NAME] | D | D | D | D |  |  | D | D | D | D | D |  |  | D | D | D | D | D |  |  | D | D | D | D | D |  |  | D | D | D | D
RUDY ACEVEDO | D | D | D | D |  |  | D | D | D | D | D |  |  | D | D | D | D | D |  |  | D | D | D | D | D |  |  | D | D | D | D
MIGUEL GARCIA | D | D | D | D |  |  | D | D | D | D | D |  |  | D | D | D | D | D |  |  | D | D | D | D | D |  |  | D | D | D | D
DEAN LAURENT | N | N |  |  | D | D |  |  |  | N | N | N | N |  |  |  |  |  |  |  | D | D | D | D | D |  |  | D | D | D | D
[NAME] |  |  | N | N | N | N |  |  |  |  |  |  |  | N | N | N |  |  | D | D
MAURICIO TREJO |  |  |  |  |  |  | N | N | N |  |  | D | D |  |  |  | N | N | N | N |  |  |  | N | N | N | N
MIDWEST
[NAME] | D | D | D | D |  |  | D | D | D | D | D |  |  | D | D | D | D | D |  |  | D | D | D | D | D |  |  | D | D | D | D
J.D.KINSER | D | D | D | D |  |  | D | D | D | D | D |  |  | D | D | D | D | D |  |  | D | D | D | D | D |  |  | D | D | D | D
[NAME] | D | D | D | D |  |  | D | D | D | D | D |  |  | D | D | D | D | D
VACANT |  |  | N | N | N | N |  |  |  |  |  |  |  | N | N | N |  |  | D | D |  |  |  | N | N | N | N
JUAN PADRON |  | D |  |  |  |  | N | N | N |  |  | D | D | PL | PL | PL | PL | PL | PL | PL |  |  | D | D |  |  |  | N | N | N | N
DUSTIN COLLINS | N | N |  |  | D | D | D | D |  | N | N |  | N |  |  |  |  |  |  |  | N | N | N |  |  | D | D | D
NORTHEAST
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | [NAME].
Spreadsheet: 856134d1705497956-count-distinct-values-help2
Sheet: Sheet1

 | Name | Week 9 Regime
 |  | 12
 |  | #[NAME]!
 |  | #[NAME]!
 |  | #[NAME]!
 |  | #[NAME]!
 |  | #[NAME]!
 |  | #[NAME]!
 |  | #[NAME]!
 |  | #[NAME]!
 |  | #[NAME]!
 |  | #[NAME]!
 |  | #[NAME]!
Spreadsheet: 773103d1647615952-help-moving-table-contents-from-one-sheet-to-another-depending-on-criteria-example-1-fixed
Sheet: Sheet1

Name | On | Off | Y/N
Name | 07:00:00 | 19:00:00 | Yes
Name | 07:00:00 | 19:00:00 | No
dez | 07:00:00 | 19:00:00 | No
fgfgd | 07:00:00 | 19:00:00 | Yes
hgh | 07:00:00 | 19:00:00 | Yes
yyt | 07:00:00 | 19:00:00 | Yes
ee | 07:00:00 | 19:00:00 | No
Spreadsheet: 165326d1341172256-creating-a-calendar-between-2-variable-dates-to-a-specific-format-mobile-date-range-calendar
Sheet: Sheet1

 | Calendar of events   - enter event and add comments box to explain further
 | Drugs charts comments - enter event and add comments box to explain further
 | or
Spreadsheet: 10ef83f5-60e5-4635-9966-387ed1cb15f5
Sheet: Sheet1

Unnamed: 0 | Unnamed: 1 | Unnamed: 2 | Unnamed: 3 | Unnamed: 4 | WAKE COUNTY DEPARTMENT OF ENVIRONMENTAL SERVICES | Unnamed: 6 | Unnamed: 7 | Unnamed: 8 | Unnamed: 9
 |  |  |  |  | PRESSURE MANIFOLD DESIGN
Name: |  |  |  | P.I.N. #: |  |  | D#:
Address: |  |  |  | [NAME]: |  |  | Lot#:
# of BDR: |  | Daily Flow: | 0 | gal/day | L.T.A.R.: | 0 | gal/day/sq.ft
Septic Tank: |  | gals | Pump Tank: |  | gals | Sq. Foot: | 0 | Stone Depth:
Number of Taps: |  |  |  | Length of Trenches: | 0 | ft(See Tap Chart for Details)
Depth of Trenches: |  |  | in |  | [NAME]: | 18 | in
Manifold Diameter: |  | 4in sch 80pvc |  | Tap Configuration: 6 in spacing |  |  |  | side(s) of manifold
Supply Line: length: |  | 0 | ft |  | Diameter: | 2 | in sch 40pvc
Friction Loss + Fitting Loss: |  |  | 0 | ft(supply line length + 70' for fittings in pump tank)
Design Head: |  | 2 | ft | Elevation Head: |  | 6 | ft
Total Head: | 8 | ft |  |  | Pump to Deliver: | 0 | gals/min at | 8 | [NAME]
Dosing Volume: |  | 0 | gals,
Drawdown: | 0 | gals divided by |  | 0 | gals/in = |  | inches
Simplex Control Panel required; elapsed time meter and cycle counter required; [NAME] to be determined
by type of pump tank used. A septic tank filter, |  |  |  |  |  |  | or equal is required.
Possible pumps: |  | Hydromatic: |  | Goulds: |  | Myers:
Zoeller: |  |  | Other:
 |  |  |  | TAP CHART
[NAME] |  | is = 100.00 | set at |  |  |  | Design Head: | 2
Pump tank elev. |  |  | 100 | Pump elev. | 95 |  | Manifold elev. | 101
line | color | rod read | Elevation | length | hole size | flow/tap | gal/day | trench area | LINE LTAR
1 |  |  | 100 |  |  |  |  | 0
2 |  |  | 100 |  |  |  |  | 0
3 |  |  | 100 |  |  |  |  | 0
4 |  |  | 100 |  |  |  |  | 0
5 |  |  | 100 |  |  |  |  | 0
6 |  |  | 100 |  |  |  |  | 0
7 |  |  | 100 |  |  |  |  | 0
8 |  |  | 100 |  |  |  |  | 0
 |  | total | feet  = | 0 | gal/min = | 0 |  | LTAR =
% of [NAME]. |  |  |  | Des. Flow |  |  |  | (ltar + 5%) | 0
Dose Volume |  | 0 |  | Pump Run= |  |  |  | (ltar W/ INOV) | 0
Dose Pump Time |  |  |  | Tank Gal/IN |  |  |  | (ltar + 5%) | 0
Drawdown in Inches |  |  |  | Elev. Head | 6
Supply Line Length
Comments:
Hydraulic Profile
Manifold Elevation |  | 101 | 0
Pump tank elev. |  | 100 | 2
Pump elev. |  | 95 | 0
Spreadsheet: 168734d1342552700-copy-across-multiple-rows-and-columns-the-data-to-one-column-removing-dupilicates-blank-15640
Sheet: Nov4-Nov10m

Main Arena
 | 2012-11-04 00:00:00 |  |  | Thru | 2012-11-10 00:00:00
 | SUN | MON | TUE | WED | THURS | FRI | SAT
 | 2012-11-04 00:00:00 | 2012-11-05 00:00:00 | 2012-11-06 00:00:00 | 2012-11-07 00:00:00 | 2012-11-08 00:00:00 | 2012-11-09 00:00:00 | 2012-11-10 00:00:00 |  |  |  | Blocks | Team | Hours
7:00AM |  |  |  |  |  |  |  | 7:00AM |  |  | 0 | 05 [NAME] | 0
 |  |  |  |  |  |  |  |  |  |  | 0 | 04 Flags | 0
[NAME] |  |  |  |  |  |  |  | [NAME] |  |  | 0 | 03 [NAME] | 0
 |  |  |  |  |  |  |  |  |  |  | 0 | 02 Flags | 0
[NAME] |  |  |  |  |  |  |  | [NAME] |  |  | 0 | 01 Flags | 0
 |  |  |  |  |  |  |  |  |  |  | 0 | 00 Flags | 0
10:00AM |  |  |  |  |  |  |  | 10:00AM |  |  | 0 | 99 Flags | 0
 |  |  |  |  |  |  |  |  |  |  | 0 | 98 Flags | 0
11:00AM |  |  |  |  |  |  |  | 11:00AM |  |  | 0 | Midget A | 0
 |  |  |  |  |  |  |  |  |  |  | 0 | Midget AA | 0
12:00PM |  |  |  |  |  |  |  | 12:00PM
1:00PM |  |  |  |  |  |  |  | 1:00PM
2:00PM |  |  |  |  |  |  |  | 2:00PM
3:00PM |  |  |  |  |  |  |  | 3:00PM
4:00PM |  |  |  |  |  |  |  | 4:00PM
5:00PM |  |  |  |  |  |  |  | 5:00PM
6:00PM |  |  |  |  |  |  |  | 6:00PM
7:00PM |  |  |  |  |  |  |  | 7:00PM
8:00PM |  |  |  |  |  |  |  | 8:00PM
9:00PM |  |  |  |  |  |  |  | 9:00PM
10:00PM |  |  |  |  |  |  |  | 10:00PM
11:00PM |  |  |  |  |  |  |  | 11:00PM
 | Cancellations or Corrections
 | Date | Time | Customer | Operations Personal | Comments
Spreadsheet: darrell_schoolcraft__7804__imbalsumm0108
Sheet: NNG

NNG
 | Measured | Scheduled | Imbalance
1635
3531 | -207875 | -107880
60667
60749 | 248047 | 61726
61206
61334 | -25143
62960
INDEX
2001-07-31 00:00:00 |  |  | 704039.33
2001-08-08 00:00:00
CBS Volume
 |  |  | 80036
Spreadsheet: 32042d1228164953-adding-names-and-showing-on-all-sheets-generic-hours-and-miles_2008
Sheet: June

[NAME] | Month Total | Month Total | 08XXXX | City
CD? Then "Y" |  | CD
 | HOURS | [NAME] | HOURS | CD [NAME]
 |  | 0
Name
 |  | 0
Name
 |  | 0
Name
 |  | 0
Name
 |  | 0
Name
 |  | 0
Name
 |  | 0
Name
 |  | 0
Name
 |  | 0
Name
 |  | 0
Name
 |  | 0
Name
 |  | 0
Name
 |  | 0
Name
 |  | 0
Name
 |  | 0
Name
AB Hours /Job | 0 |  | 0
AB-CD /Job |  | 0
 | 0
Spreadsheet: 799934d1665404764-convert-log-to-nr-log-till-numerisk-2-
Sheet: Blad1

 |  | Log | 3 | 5 | 3.5 | <5 | <1 | <2.8 | <3.6
 |  | Numerisk
 |  |  |  |  |  | <100000 | <10 | <630,[PHONE] | <3981,[PHONE]
Spreadsheet: mary_fischer__25612__32G
Sheet: E1.XLS 

ENRON CORP AND CONSOLIDATED SUBSIDIARIES
COMPANY #  32G
COMPANY NAME  EFG Holdings
FOR THE PERIOD ENDING 6-30-2001
PREPARED BY:  Sonya City
EXTENSION:  3 9690 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | E-1
 |  | 12-31-99 Balance
 |  | BEGINNING |  | OTHER |  | 03-31-2000 |  | OTHER |  | 06-30-2000 |  | OTHER |  | 09-30-2000 |  | OTHER |  | 12-31-2000
[NAME] |  | BALANCE |  | CHANGES |  | BALANCE |  | CHANGES |  | BALANCE |  | CHANGES |  | BALANCE |  | CHANGES |  | BALANCE
 |  | DR. (CR.) |  | DR. (CR.) |  | DR. (CR.) |  | DR. (CR.) |  | DR. (CR.) |  | DR. (CR.) |  | DR. (CR.) |  | DR. (CR.) |  | DR. (CR.)
(PROVIDE DETAIL OF INDIVDUAL ITEMS
IN EXCESS OF $200,000.)
Accts Receivables - Unconsolidated Assoc Companies:
 |  | 0
 |  | 0
 |  | 0
 |  | 0
Total (Hyperion line 0053)
Asset/Expense Accts:  DR/(CR)
Accts Receivables - Other:
Total (Hyperion line 0060)
Asset/Expense Accts:  DR/(CR)
Asset/Expense Accts:  DR/(CR)
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | E-1
Spreadsheet: 93968d1293727657-minimum-and-text-minimum-and-text
Sheet: MIN

 | 2010-12-01 00:00:00 | 2010-12-02 00:00:00 | 2010-12-03 00:00:00 |  | Columns B, C and D have separate formulas in B6, C6, D6
2010 | 1 | T | 4 |  | Looking for the MIN of each in the separate columns (B,C,D)
2009 | 3 | 1 | 4 |  | If a "T" is in the range and NO ZEROS, then return a "T"
2008 | 3 | 1 | 4 |  | If all numbers in the range then return MIN value
2007 | 0 | 6 | 2
Min |  |  |  |  | in B6, zero is the correct value
 |  |  |  |  | In C6, "T" is the correct value ("T" is in range and NO ZEROS)
 |  |  |  |  | in D6, I want it to return the MIN of all the numbers, which would be the value 2 (in D5)
 | The formula in B6 IS
 | =(IF(MIN(B$2:B$5>0,IF(COUNTIF(B$2:B$5,"T")*0,0,"T"),MIN(B$2:B$5))
 | Looking for help in fine tuning the formula in B6, C6 and D6.
Spreadsheet: 860422d1708523406-need-to-work-out-occupancy-rates-test
Sheet: Sheet1

Occupancy | Woodland View | [NAME] | Silver Birch
 | 11 | 13 | 8
Occupancy Rate | Rooms Occupied | Date Only | Week Commencing | Home | Month
 | 3 | 12/02/2024 | Monday 12/02/2024 | [NAME] | February
 | 4 | 25/09/2023 | Monday 25/09/2023 | Silver Birch | September
 | 2 | 01/11/2023 | Wednesday 01/11/2023 | Silver Birch | November
 | 4 | 13/10/2023 | Friday 13/10/2023 | Silver Birch | October
 | 2 | 16/09/2023 | Saturday 16/09/2023 | Silver Birch | September
 | 8 | 24/02/2023 | Friday 24/02/2023 | Silver Birch | February
 | 1 | 22/02/2023 | Wednesday 22/02/2023 | Silver Birch | February
 | 2 | 19/02/2023 | Sunday 19/02/2023 | Silver Birch | February
 | 2 | 20/12/2023 | Wednesday 20/12/2023 | Woodland View | December
 | 10 | 24/11/2023 | Friday 24/11/2023 | Woodland View | November
 | 2 | 20/11/2023 | Monday 20/11/2023 | Woodland View | November
 | 10 | 24/11/2023 | Friday 24/11/2023 | Woodland View | November
 | 2 | 21/11/2023 | Tuesday 21/11/2023 | Woodland View | November
 | 11 | 17/11/2023 | Friday 17/11/2023 | Woodland View | November
 | 2 | 13/11/2023 | Monday 13/11/2023 | Woodland View | November
 | 5 | 06/10/2023 | Friday [NAME] | Woodland View | October
Spreadsheet: 211928d1359992347-pull-data-based-on-day-of-week-from-another-workbook-for-previous-three-weeks-salesreport2013
Sheet: 0117

 | Date: | 2013-01-17 00:00:00
 | Day
 | Time | Trans. | Total Sales | Avg. Sales
 | 09:00:00 | 1 | 10.27
 | 10:00:00 | 9 | 43.18
 | 11:00:00 | 65 | 394.64
 | 12:00:00 | 82 | 483.52
 | 13:00:00 | 55 | 279.93
 | 14:00:00 | 42 | 210.67
 | 15:00:00 | 43 | 245.78
 | 16:00:00 | 60 | 389.06
 | 17:00:00 | 59 | 498.09
 | 18:00:00 | 50 | 415.89
 | 19:00:00 | 53 | 408.84
 | 20:00:00 | 35 | 229
 | 21:00:00 | 28 | 213.31
 | 22:00:00 | 20 | 159.07
 | 23:00:00 | 19 | 90.96
 | 1900-01-01 00:00:00 | 19 | 128.24
 | 1900-01-01 01:00:00 | 0 | 0
 | 1900-01-01 02:00:00 | 0 | 0
 | 1900-01-01 03:00:00 | 0 | 0
 | 04:00:00 | 0 | 0
 | Total
Spreadsheet: 846584d1697730264-how-to-insert-blank-rows-but-by-using-formulas-rows
Sheet: Sheet1

Table 1 |  |  |  |  | Table 1
Order ID | Customer name | Product | Total price |  | Order ID | Customer name | Product | Total price
20191111 | [NAME] | [NAME] burger | 60 |  | 20191111 | [NAME] | [NAME] burger | 60
20191102 | [NAME] | Steak sandwich | 60
20191107 | [NAME] | Steak sandwich | 36
20191113 | [NAME] | Steak sandwich | 12 |  | 20191102 | [NAME] | Steak sandwich | 60
20191117 | [NAME] | Steak sandwich | 48
20191101 | [NAME] | Sausage sandwich | 108
 |  |  |  |  | 20191107 | [NAME] | Steak sandwich | 36
 |  |  |  |  | 20191113 | [NAME] | Steak sandwich | 12
 |  |  |  |  | 20191117 | [NAME] | Steak sandwich | 48
 |  |  |  |  | 20191101 | [NAME] | Sausage sandwich | 108
Spreadsheet: 821630d1678820598-methods-to-find-unique-id-and-list-shared-users-with-each-id-peers2
Sheet: Sheet1

 |  |  |  |  | New User |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | Total
 |  |  | User | Old UNITIDs | CNU | GMU | JMU | LU | NSU | ODU | RU | UMW | UVA | UVAW | VCU | VMI | VSU | VT | WM | RBC | new users
 |  |  | CNU | 4 |  |  |  |  | 4 |  |  |  |  |  |  | 2
 |  |  | GMU
 |  |  | JMU | 1 | 1 |  |  | 1 |  |  |  | 1 |  |  |  |  | 1
 |  |  | LU | 2 |  |  |  |  | 2 |  | 1 |  |  |  |  | 1
 |  |  | NSU
 |  |  | ODU
 |  |  | RU
 |  |  | UMW | 2 | 2 |  |  |  |  |  |  |  |  |  |  | 1
 |  |  | UVA
 |  |  | UVAW
 |  |  | VCU
 |  |  | VMI
 |  |  | VSU | 1 |  |  |  |  | 1 |  | 1
 |  |  | VT
 |  |  | WM
 |  |  | RBC
Spreadsheet: 31099d1226859381-convert-date-to-week-and-month-month-automatically-example
Sheet: Sheet1

 | Date | week | # inspected | # defective | Yield
 | 2008-10-01 00:00:00 | 41 | 100 | 2 | 0.02
 | 2008-10-10 00:00:00 | 42 | 55 | 3 | 0.05454545454545454
 | 2008-11-08 00:00:00 | 46 | 125 | 10 | 0.08
 | 2008-11-17 00:00:00 | 47 | 33 | 5 | 0.1515151515151515
 | This is the current data input where an operator puts in the date and the numbers.....yield is auto-calculated and I have a graph which works on it
 | No issues here....all i want is to auto-calculate the Week Number
 | Secondly based on the above sheet I have another worksheet in say sheet 2
 | Month | # inspected | # defective | yield
 | October | 155 | 5 | 0.03225806451612903
 | November | 158 | 15 | 0.0949367088607595
 |  | So based on the data above.....I want excel to auto-calculate the sums based on say date/week and add it in the respective months in another tab/sheet
Spreadsheet: 149285d1333811931-excel-2007-how-to-count-in-row-and-automic-put-in-another-row-countgroups
Sheet: Sheet1

PAC Number | Number
123
123
123
123
123
123
123
123 | 1
124
124
124
124
124
124 | 2
125
125
125
125
125
125
125
125 | 3
Spreadsheet: 29107d1223907599-multiple-vlookups-incrementalise
Sheet: Sheet2

Sum of purchase amount | CustomerEvent# | paid?
 | 1 |  | 2 | 3 |  | 4 | 5 | 6 | 7 | 8 | 9 | 10 | Grand Total
customer# | Y | N | Y | Y | N | N | Y | Y | N | Y | N | Y
1000 | 123 |  | 234 |  | 345 |  |  |  |  |  |  |  | 702
1001 |  | 9999 |  |  |  |  |  |  |  |  |  |  | 9999
1002 | 200003 |  | 20054 | 200566 |  | 201234 | 200003 | 205656 | 200003 | 202345 | 265666 | 209999 | 1905529
Grand Total | 200126 | 9999 | 20288 | 200566 | 345 | 201234 | 200003 | 205656 | 200003 | 202345 | 265666 | 209999 | 1916230
 | try dragging "paid?" button to right of "customer#" button
Spreadsheet: 92752d1292313212-list-without-duplicates-nonduplicateslist
Sheet: Sheet1

SOURCE |  | Expected DESTINATION |  |  | Trial
(is always in ascending order)
2008 |  | 2008
2009 |  | 2009
2009
2009
2009
2010 |  | 2010
2010
2010
Spreadsheet: geir_solberg__11259__6_07act
Sheet: EPEData

 | 37141.37013888889
 | NEWMAN 1 ,MANL, 43  , 44  , 39  , 83  ,  0  ,1
 | NEWMAN 2 ,MANL, 33  , 74  , 37  , 82  ,  0  ,1
 | NEWMAN 3 ,ECON, 98  ,100  , 35  ,103  ,  3  ,1
 | NEWMN/GT1,AVAL,  0  , 60  , 18  , 60  ,  0  ,1
 | NEWMN/GT2,AVAL,  0  , 60  , 18  , 60  ,  0  ,1
 | NM/GT1+ST,UNAV,  0  ,100  , 61  ,107  ,  0  ,1
 | NM/GT2+ST,AVAL,  0  ,100  , 66  ,107  ,  0  ,1
 | NEWMAN 4 ,MANL,152  ,214  , 86  ,214  ,  0  ,1
 | NEWMAN   ,, 327 ,  432,  197, 482 ,   3 ,
 | COPPER   ,[NAME], -0  , 69  , 15  , 69  ,  0  ,1
 | RIOGRAN 6,MANL, 27  , 47  , 29  , 48  ,  0  ,1
 | RIOGRAN 7,MANL, 34  , 42  , 30  , 49  ,  0  ,1
 | RIOGRAN 8,MANL, 55  , 95  , 55  ,151  ,  0  ,1
 | RIOGRANDE,, 117 ,  184,  114, 248 ,   0 ,
 | PALOVERDE,MANL,593  ,593  ,593  ,600  ,  0  ,1
 | FOURCRNRS,MANL,104  ,104  ,104  ,104  ,  0  ,1
 | LAMBDA, 37.79,  858,  943,  155,   -1,   85,23589,50
 | APS     ,STRT    ,FC,  ,   1,   1
 | IID     ,EXCS    ,FC,  ,  50,  50
 | IID     ,FIRM    ,PV,  , 100, 100
 | LDWP    ,ECON    ,PV,  ,  80,  80
 | PGT     ,LOSS    ,PV,  ,  -1,  -1
 | PNM     ,CNTG    ,LC,  ,  11,  11
 | PNM     ,LOSS    ,LC,  ,   2,   2
 | SPS     ,FIRM    ,WM,  ,-103,-103
 | SRP     ,FIRM    ,ED,  ,  25,  25
 | SRP     ,LOSS    ,PV,  ,   1,   1
 | TNP     ,FIRM    ,PV,  ,  25,  25
 | TNP     ,LOSS    ,PV,  ,  -5,  -5
 | WAPA    ,PASS    ,WM,HO,  -1,  -1
Spreadsheet: 872912d1719367600-calculating-overtime-to-be-paid-after-deductions-are-made-forum-sheet-ot-build-up-rev-06
Sheet: Sheet1

DATE | DAY | [NAME] | CUMULATIVE TIME | LATE RUNNING OVERTIME |  |  | PRE-START & VOLUNTARY OVERTIME
 |  |  |  | [NAME] | CUMULATIVE TIME | OVERTIME TO BE PAID | [NAME] | CUMULATIVE TIME | OVERTIME TO BE PAID
WEEK 1
 | Monday | 5.32 |  | 0 |  |  | 0
 | Tuesday | 6.51 |  | 0.75 |  | 0 | 0 |  | 0
 | Wednesday | 7.17 |  | 0 |  | 0 | 1.2 |  | 1
 | Thursday | 6.65 |  | 0 |  | 0 | 0 |  | 0
 | Friday | 6.13 |  | 0 |  | 0 | 2.4 |  | 2.4
 |  | 7.27 |  | 0 |  | 0 | 0 |  | 0
WEEK 2
 | Monday | 8.25 |  | 0.65 |  |  | 0
 | Tuesday | 7.8 |  | 0.75 |  | 10.14999999999999 | 0 |  | 0
 | Wednesday |  |  | 0 |  | 0 | 1.5 |  | 1.5
 | Thursday |  |  | 1.2 |  | 1.2 | 0 |  | 0
 | Friday | 7.3 |  | 0 |  | 0 | 0.32 |  | 0.32
 |  |  |  | 0 |  | 0 | 0 |  | 0
Spreadsheet: 3e90ad4c-ca55-41c0-8ea4-9ce90e3f7d43
Sheet: Sheet1

Historic prices | Market Leader, Inc. | Unnamed: 2 | Unnamed: 3 | Unnamed: 4
Price | Date | High | Low | Volume
4.68 | 6/15/2012 12:00:00 AM | 4.77 | 4.65 | 113570
4.7 | 6/14/2012 12:00:00 AM | 4.73 | 4.59 | 91525
4.68 | 6/13/2012 12:00:00 AM | 4.69 | 4.53 | 67385
4.7 | 6/12/2012 12:00:00 AM | 4.73 | 4.24 | 74531
4.58 | 6/11/2012 12:00:00 AM | 4.7 | 4.181 | 135196
4.63 | 6/8/2012 12:00:00 AM | 4.69 | 4.25 | 51231
4.62 | 6/7/2012 12:00:00 AM | 4.67 | 4.55 | 49364
4.61 | 6/6/2012 12:00:00 AM | 4.7 | 4.54 | 69122
4.61 | 6/5/2012 12:00:00 AM | 4.64 | 4.5 | 106215
4.63 | 6/4/2012 12:00:00 AM | 4.67 | 4 | 68983
4.52 | 6/1/2012 12:00:00 AM | 4.61 | 4.38 | 108126
4.5 | 5/31/2012 12:00:00 AM | 4.609 | 4.4 | 92511
4.49 | 5/30/2012 12:00:00 AM | 4.51 | 4.38 | 65919
4.4 | 5/29/2012 12:00:00 AM | 4.5 | 4.36 | 39108
4.46 | 5/25/2012 12:00:00 AM | 4.56 | 4.361 | 38662
4.51 | 5/24/2012 12:00:00 AM | 4.52 | 4.2 | 147985
4.47 | 5/23/2012 12:00:00 AM | 4.52 | 4.43 | 99421
4.52 | 5/22/2012 12:00:00 AM | 4.52 | 4.43 | 261240
4.44 | 5/21/2012 12:00:00 AM | 4.44 | 4.171 | 107252
4.25 | 5/18/2012 12:00:00 AM | 4.25 | 4 | 143634
4.1 | 5/17/2012 12:00:00 AM | 4.22 | 4.06 | 63716
4.1 | 5/16/2012 12:00:00 AM | 4.19 | 4.03 | 51554
Spreadsheet: 053ef7c5-aed4-43bb-abb6-f6a8c1a9fb9c
Sheet: Mergent

Mergent
2005-2006
 | 2005-07-01 00:00:00 | 2005-08-01 00:00:00 | 2005-09-01 00:00:00 | 2005-10-01 00:00:00 | 2005-11-01 00:00:00 | 2005-12-01 00:00:00 | 2006-01-01 00:00:00 | 2006-02-01 00:00:00 | 2006-03-01 00:00:00 | 2006-04-01 00:00:00 | 2006-05-01 00:00:00 | 2006-06-01 00:00:00 | Total | 2005-2006 Price | Price per unit
Mergent Online
Logins | 24 | 70 | 42 | 92 | 50 | 31 | 13 | 14 | 8 | 8 | 22 | 4
Searches | 59 | 3766 | 209 | 108 | 133 | 35 | 11 | 94 | 17 | 24 | 59 | 4 |  | 10400
Companies Viewed | 28 | 4519 | 225 | 64 | 82 | 30 | 15 | 72 | 4 | 4 | 26 | 4 |  | 10400
Spreadsheet: 193690d1352916676-how-could-i-group-the-date-by-value-how-could-i-group
Sheet: Sheet1

 |  | 1 | 2 | 3 | 4 | 5 | 6 | 7 | 8 | 9
 |  | 2012-10-01 00:00:00 | 2012-10-02 00:00:00 | 2012-10-03 00:00:00 | 2012-10-04 00:00:00 | 2012-10-05 00:00:00 | 2012-10-06 00:00:00 | 2012-10-07 00:00:00 | 2012-10-08 00:00:00 | 2012-10-09 00:00:00
1 | Item 1 | 3.2 | 3.2 | 3.2 | 3.2 | 3.2 | 3.2 | 3.2 | 3.1 | 3.1
2 | Item 2 | 3.5 | 3.5 | 3.5 | 3.5 | 3.5 | 3.5 | 3.5 | 3.5 | 3.5
3 | Item 3 | 2.8 | 2.8 | 3.9 | 3.9 | 3.9 | 3.9 | 3.9 | 2.6 | 2.6
4 | Item 4 | 3.9 | 3.9 | 3.9 | 3.9 | 3.9 | 3.6 | 3.6 | 3.6 | 3.6
5 | Item 5 | 3.6 | 3.6 | 3.6 | 3.6 | 3.6 | 2.6 | 2.6 | 2.6 | 2.6
6 | Item 6 | 2.6 | 2.6 | 2.6 | 2.6 | 5.1 | 5.1 | 5.1 | 5.1 | 5.1
7 | Item 7 | 1.1 | 3.2 | 3.2 | 3.2 | 3.2 | 3.2 | 3.2 | 3.2 | 3.2
8 | Item 8 | 5.1 | 5.1 | 5.1 | 5.1 | 5.1 | 5.1 | 5.1 | 5.1 | 3.2
9 | Item 9 | 6.5 | 6.5 | 7.2 | 8.5 | 8.5 | 9 | 9 | 8.5 | 8.5
10 | Item10 | 1 | 1 | 1 | 2 | 2 | 2 | 2 | 3 | 4
11
12
13
14
15
Spreadsheet: 833073d1686762257-sum-by-month-of-multiple-worksheets-soma-meses-2-
Sheet: Planilha1

 | Add the months of each worksheet
 |  | 2023-05-01 00:00:00 | 2023-06-01 00:00:00 | 2023-07-01 00:00:00 | 2023-08-01 00:00:00 | 2023-09-01 00:00:00 | 2023-10-01 00:00:00 | 2023-11-01 00:00:00 | 2023-12-01 00:00:00 | 2024-01-01 00:00:00 | 2024-02-01 00:00:00 | 2024-03-01 00:00:00 | 2024-04-01 00:00:00 | 2024-05-01 00:00:00 | 2024-06-01 00:00:00
 | Planilha2
 | Planilha3
 | Planilha4
Spreadsheet: 835458d1688592281-sumifs-with-indirect-references-sumifs-question
Sheet: Sheet1

SUMIFS Question |  |  |  | Choose Column | Color
 |  |  |  | Choose Element | Yellow
 |  | Facility | $ | Color | Length | Material |  |  | SumIFS Total | =SUMIFS(Table1[$],Table1[F1],F2)
 |  | 1 | 339 | Blue | 41 | 335
 |  | 2 | 146 | Yellow | 77 | 154
 |  | 3 | 200 | Green | 487 | 424
 |  | 2 | 442 | Yellow | 232 | 255
 |  | 2 | 82 | Blue | 172 | 256
 |  | 3 | 395 | Green | 252 | 461
 |  | 1 | 350 | Yellow | 421 | 477
 |  | 3 | 206 | Blue | 463 | 318
 |  | 2 | 87 | Green | 317 | 204