tianzl66/Sheetpedia huggingface dataset:
Spreadsheet: eric_saibi__9799__091801R
Sheet: Palo Verde 03 R7

Owner Name | Arizona Public Service Company
Station Name | Palo Verde Nuclear Power Station
Unit Name | Palo Verde 03 R7
NERC Region | WSCC
State | AZ
Fuel Type | Nuclear
Capacity | 1,403 MW
Start Date | 2001-09-29 00:00:00
End Date | 2001-11-03 00:00:00
Prv. Start Date | 2001-09-30 00:00:00
Prv. End Date | 2001-11-03 00:00:00
Comments
SIC | 4911
Plant ID | 1015283
Unit ID | 1007878
Outage ID | 7842
Spreadsheet: 846024d1697316417-help-with-a-conditional-format-on-cells-with-formula-conditional-format-etaf
Sheet: Sheet1

 |  | UPC |  |  |  |  |  | Retail | POS | POS +/-
 |  | [PHONE] |  |  |  |  |  | 19.99
 |  | [PHONE] |  |  |  |  |  | 9.99
 |  | [PHONE] |  |  |  |  |  | 9.99
 |  | [PHONE] |  |  |  |  |  | 9.99
 |  | [PHONE] |  |  |  |  |  | 9.99
 |  | [PHONE] |  |  |  |  |  | 9.99
 |  | [PHONE] |  |  |  |  |  | 8.99
Spreadsheet: 488949d1478911968-automate-calculations-on-a-database-vlookup_hb47
Sheet: Result

ORIGINAL
Category | Score 1 | Score 2 | Score 3 | Average |  |  | Change
a | 34 | 4 | 79 |  |  |  |  |  | Adjust 1 | Adjust 2 | Adjust 3
b | 55 | 6 | 67 |  |  |  | Cat a | Mark
 |  |  |  |  |  |  |  | BBB
ADJUSTED |  |  |  |  |  |  |  | Total
Category | Score 1 | Score 2 | Score 3 | Average |  |  | Cat b | EEE
a |  |  |  |  |  |  |  | HHH
b |  |  |  |  |  |  |  | Total
Spreadsheet: 150264d1334356199-calculated-fields-in-pivot-tables-sample_datq
Sheet: Sheet1

P | Q | M | Qty
A | 1 | 1 | 10
A | 1 | 2 | 20
A | 1 | 3 | 30
A | 2 | 4 | 40
A | 2 | 5 | 50
A | 2 | 6 | 60
A | 3 | 7 | 70
A | 3 | 8 | 80
A | 3 | 9 | 90
A | 4 | 10 | 100
A | 4 | 11 | 110
A | 4 | 12 | 120
B | 1 | 1 | 120
B | 1 | 2 | 110
B | 1 | 3 | 100
B | 2 | 4 | 90
B | 2 | 5 | 80
B | 2 | 6 | 70
B | 3 | 7 | 60
B | 3 | 8 | 50
B | 3 | 9 | 40
B | 4 | 10 | 30
B | 4 | 11 | 20
B | 4 | 12 | 10
Spreadsheet: 266992d1379896799-data-validation-dependant-on-previous-cell-simple-examples-v2
Sheet: Sheet1

[NAME] |  | stained glass |  |  |  | Window |  | Dialog |  | Browser |  | [NAME] |  | [NAME] |  | Browser Dialogue
 |  |  |  |  |  | Sill |  | Something |  | Firefox |  | www.yahoo.ca |  | A |  | 1
 |  |  |  |  |  | Frame |  | Nothing |  | Mozilla |  | www.google.com |  | B |  | 2
 |  |  |  |  |  | [NAME] |  |  |  | Netscape |  |  |  | C |  | 3
 |  |  |  |  |  | stained glass |  |  |  | IE |  |  |  | d |  | 4
 |  |  |  |  |  |  |  |  |  |  |  |  |  | e
 |  |  |  |  |  |  |  |  |  |  |  |  |  | f
Spreadsheet: 737495d1624445599-goal-seek-cant-change-dos-over-30-days-goal-seek-cant-change-dos-over-30-days
Sheet: Sheet1 (2)

 |  |  | 6 | 7 | 8 | 9 | 10 | 11 | 12
 | CODE SAP | SKU | jun | jul | aug | sep | oct | nov | dec
 | 2250068 | 4.5 p100 cy ltc | 2601
 |  | In Transit | 0 | 0 | 0 | 0 | 0 | 0 | 0
 |  | PO's | 456.0000000000001 | 4952.333333333331 | 1499.000000000002 | 2189.666666666666 | 880.5333333333339 | 5379.244444444446 | 2401.746031746031
 |  | Requirement | 3406 | 0 | 0 | 0 | 0 | 0 | 0
 |  | Demand | 2472 | 3535 | 2207 | 2409 | 1498 | 4470 | 2502
 |  | Ending Inventory
 |  | Days of Stock
Spreadsheet: 67654d1268228772-nested-ifs-allied-bonus-plan-worksheet
Sheet: Revenue

Note:  Fill in just the blue sections.  The other areas contain formulas which will automatically calculate.
PT | Month 1 | Month 2 | Month 3 | Month 4 | Mounth 5 | Month 6 | Month 7 | Month 8 | Month 9 | Month 10 | Month 11 | Month 12 | Total | YTD
# of starts | 0 | 2 | 3 | 6 | 8 | 10 | 10 | 12 | 12 | 12 | 12 | 12
No of Billing Staff |  |  | 2 | 5 | 11 | 17 | 24 | 28 | 32 | 34 | 36 | 36
Total Hours |  |  | 160 | 400 | 880 | 1360 | 1920 | 2240 | 2560 | 2720 | 2880 | 2880 | 18000
GP Hourly Profit Rate $10 | 0 | 0 | 1600 | 4000 | 8800 | 13600 | 19200 | 22400 | 25600 | 27200 | 28800 | 28800
Commission | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | Commission in year 1
0 | 10000 | 0
10001 | 14000 | 0.02
14001 | 18000 | 0.03
18001 | 22000 | 0.04
22001 | 26000 | 0.06
26001 |  | 0.07
Potential Customers |  |  |  |  |  | Potential Customers
Name | Client Type | RN | PT |  |  | Name | Client Type | RN | PT | Other
Tools Needed
Spreadsheet: 124739d1318586189-conditional-sumproduct-help-people-model
Sheet: Sheet1

Name | CTC | Months in Mumbai
Employee 1 | 30 | 12
Employee 2 | 21 | 12
Employee 3 | 21 | 12
Employee 4 | 24 | 12
Employee 5 | 18 | 12
Employee 6 | 12 | 12
Employee 7 | 9 | 12
Employee 8 | 5.5 | 6
Employee 9 | 5 | 6
Employee 10 | 3.3 | 12
Employee 11 | 3 | 12
Employee 12 | 3 | 12
Employee 13 | 2.82 | 12
Employee 14 | 1.98 | 9
Employee 15 | 1.44 | 6
Employee 16 | 1.32 | 12
Employee 17 | 1.2 | 12
Employee 18 | 0.72 | 6
Employee 19 | 0.72 | 12
Employee 20 | 0.72 | 12
Employee 21 | 18 | 12
Particulars (in lacs) | Assumptions (p.a) | Months
(Shift Case) |  | 1 | 2 | 3 | 4 | 5 | 6 | 7 | 8 | 9 | 10 | 11 | 12
Total Personnel Cost
Other Personnel Cost (% Pers Cost) | 0.01
Rent,Electricity CAM Charges  (per emp) | 1.85
G&A Expenses (% Pers Cost) | 0.2
Allocation of Corporate Expenses (per emp) | 3.3
Total Cost
Employee count
Spreadsheet: 1ef50df9-fd95-4868-9812-e00d22eb4d07
Sheet: 12a

Product1 | Cleared2 | Uncleared | TOTAL
Cross_Currency Basis | - | 50020 | 50020
Cross_Currency Fixed-Fixed | - | 6213 | 6213
Cross_Currency Fixed-Float | - | 3783 | 3783
TOTAL | - | 60016 | 60016
Spreadsheet: 137347d1327071106-mode-array-vsum
Sheet: Sheet1

Budget line | Spend | Orders | Entity
1005 | 242525 | 333 | MER200
1006 | 34434 | 5454 | MER200
1010 | 5667 | 656 | MER350
1018 | 776878 | 767 | HEY554
1022 | 87 | 77 | MER200
1028 | 9 | 6 | MER350
1034 | 898 | 76 | HEY554
1042 | 89797 | 676 | MER200
1005 | 24728 | 333 | MER200
1006 | 34434 | 5454 | MER200
1010 | 5667 | 656 | MER350
1018 | 776878 | 767 | HEY554
1022 | 87 | 77 | MER200
1028 | 9 | 6 | MER350
1034 | 898 | 76 | HEY554
1042 | 89797 | 676 | MER200
1005 | 19246 | 333 | MER200
1006 | 34434 | 5454 | MER200
1010 | 5667 | 656 | MER350
1018 | 776878 | 767 | HEY554
1022 | 87 | 77 | MER200
1028 | 9 | 6 | MER350
1034 | 898 | 76 | HEY554
1042 | 89797 | 676 | MER200
Spreadsheet: stacey_white__39066__Pwr west P&L
Sheet: Power West P&L 

ENRON POWER TRADING & TRANSMISSION
DAILY PROFIT LOSS STATEMENT - WEST |  |  |  |  |  |  |  |  |  |  |  | YTD  Rolling Check | MTD  Rolling Check
DATE: | 1999-02-11 00:00:00 |  |  |  |  |  |  |  |  |  |  | Figures - If not | Figures - If not
 |  |  |  |  |  |  |  |  |  |  |  | zero, you are | zero, you are
 |  |  |  |  |  |  |  |  |  |  |  | not finished! | not finished!
 |  |  |  |  |  |  |  |  |  |  | CHECK FIGURE
 |  | DESK | 1 DAY | 5 DAY | MTD | 1ST QTD | 2ND QTD | 3RD QTD | 4TH QTD | YTD |  | YTD | Expected Liquidations | YTD check | MTD check | 4th Quarter | 3rd Quarter | 2nd Quarter | 1st Quarter |  | [NAME]
 |  | W-MGMT [NAME] |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | POWER-WM-LT
 |  | Northwest  [NAME] |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | POWER-NW-LT
 |  | [NAME]   [NAME] |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | POWER-CA-LT
 |  | Southwest  [NAME] |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | POWER-SW-LT
 |  | W-Trans  M.Swerzbin, [NAME]
 |  | W- Options  [NAME]
 |  | Spread Option
 |  | Service
 |  | TOTAL  LONG TERM
 |  | California  [NAME] |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | POWER-CA-ST
 |  | Northwest  Sean Crandall, [NAME] |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | POWER-NW-ST
 |  | Southwest  [NAME], [NAME] |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | POWER-SW-ST
 |  | Hourly  [NAME]
 |  | Management
 |  | W-BOM  [NAME]
 |  | W-Services G. Wolfe, [NAME]
 |  | W-RENEWABL Elliot Mainzer
 |  | TOTAL  SHORT TERM
 |  | Middle Market Origination |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 26994388 | 10647640
 |  | TOTAL WEST TRADING |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | [NAME]
 |  | West Origination
 |  | TOTAL WEST
 |  | [NAME] ([NAME])
 |  | [NAME] (Cooper Richey)
 |  | St transmission (Real Time Traders)
 |  | ALBERTA ORIGINATION ([NAME])
 |  | [NAME] ([NAME])
 |  | TOTAL ALBERTA POWER |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | CAND-DPR-VAR
 |  | TOTAL WEST AND ALBERTA
 |  | *Be sure to update VaR date in $I$7 in the morning
 |  | -27151
 |  | 780343.4841893384
 |  | -558558.1094205244
 |  | -74357
 |  | 214990
 |  | 360860
 |  | -274755
 |  | -214
 |  | -76
 |  | 851224
 |  | 97
 |  | -127
 |  | 57
 |  | 0
Spreadsheet: 804463d1668088392-extract-data-from-12-different-sheets-into-one-single-column-without-vba-and-powerquerry-test-4-
Sheet: .

Style No. | Unit Price
WTE181103 | 302
WTE181103 | 302
WTB181657 | 18
WTB181657 | 18
WTB181658 | 16
WTE181123 | 57
WTC181314 | 47.2
WTC181314 | 47.2
WTC181245 | 20.25
WTC181245 | 20.25
WTB181659 | 43.5
WTB181659 | 43.5
WTB181602 | 31.2
WTB181602 | 31.2
WTC181292 | 39
WTC181292 | 39
WTC181311 | 41
WTC181311 | 41
WTC181287 | 46.2
WTC181287 | 46.2
WTB181715 | 165
WTB181715 | 165
WTB181723 | 58.4
WTB181723 | 58.4
[NAME] | 85.6
[NAME] | 85.6
Spreadsheet: john_griffith__16183__1_29_02OH
Sheet: Sheet1

 |  |  | SCS  OPTION  DATA
 | TICKER | STRIKE | STR BID | STR ASK | B VOL | A VOL | M STD/DAY | WHEN
 | HO G2 | EXP |  |  | 43 | 60 | 1.72 | 2002-01-25 15:07:00
 | [NAME] | 52 | 530 | 600 | 47.1 | 53.3 | 1.64 | 2002-01-29 13:48:00
 | HO J2 | 53 | 750 | 850 | 46 | 52.2 | 1.64 | 2002-01-29 13:48:00
 | HO K2 | 53 | 900 | 1000 | 44.3 | 49.3 | 1.56 | 2002-01-29 13:48:00
 | HO M2 | 53 | 1000 | 1100 | 42 | 46.3 | 1.47 | 2002-01-29 13:48:00
 | HO N2 | 54 | 1100 | 1200 | 41 | 44.7 | 1.45 | 2002-01-29 13:48:00
 | HO Q2 | 55 | 1200 | 1300 | 40.1 | 43.4 | 1.44 | 2002-01-29 13:48:00
 | HO U2 | 56 | 1250 | 1350 | 37.9 | 41 | 1.39 | 2002-01-29 13:48:00
 | [NAME] | 57 | 1300 | 1400 | 36.4 | 39.3 | 1.36 | 2002-01-29 13:48:00
 | HO X2 | 58 | 1350 | 1475 | 35 | 38.3 | 1.34 | 2002-01-29 13:48:00
 | [NAME] | 58 | 1375 | 1500 | 34.1 | 37.2 | 1.3 | 2002-01-29 13:48:00
 | HO F3 | 59 | 1400 | 1550 | 32.7 | 36.2 | 1.28 | 2002-01-29 13:48:00
 | [NAME] | 59 | 1475 | 1625 | 33 | 36.4 | 1.29 | 2002-01-29 13:48:00
 | HO H3
 | HO J3 |  |  |  |  |  | 0.72 | 2001-07-18 22:45:00
 | [NAME]
Spreadsheet: sally_beck__33717__POWER REGION BREAKOUT 06-23-00
Sheet: TOTAL AVERAGE

REGION | (All)
Sum of SumOfDEAL COUNT | [NAME] |  |  |  | AVERAGE
MONTH | EOL | NON-EOL | Grand Total | DAYS | EOL | NON-EOL | TOTAL
1999-12-01 00:00:00 | 142 | 3452 | 3594 | 21 | 6.761904761904762 | 164.3809523809524 | 171.1428571428571
2000-01-01 00:00:00 | 1169 | 8487 | 9656 | 20 | 58.45 | 424.35 | 482.8
2000-02-01 00:00:00 | 1744 | 8463 | 10207 | 20 | 87.2 | 423.15 | 510.35
2000-03-01 00:00:00 | 2487 | 10598 | 13085 | 23 | 108.1304347826087 | 460.7826086956522 | 568.9130434782609
2000-04-01 00:00:00 | 2429 | 9396 | 11825 | 19 | 127.8421052631579 | 494.5263157894737 | 622.3684210526316
2000-05-01 00:00:00 | 2035 | 9797 | 11832 | 22 | 92.5 | 445.3181818181818 | 537.8181818181819
2000-06-01 00:00:00 | 1613 | 7003 | 8616 | 17 | 94.88235294117646 | 411.9411764705882 | 506.8235294117647
Grand Total | 11619 | 57196 | 68815 | 142 | 81.82394366197182 | 402.7887323943662 | 484.612676056338
Spreadsheet: 678490d1589913210-combine-multiple-columns-into-one-removing-blanks-sample-delete-blanks
Sheet: Combine Lineups

Column1 | Column2 | Column3 | Column4 | Column5 | Column6
Spreadsheet: 703183d1604825661-calculate-latest-date-from-two-columns-with-exceptions-log-book-demo
Sheet: Flight Logbook

Pilot Logbook |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | CHKR | X
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | SOLO
 |  |  |  | Total To Date: |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | Checkride | IPC | Flt Review |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | CREW
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | IPC
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | TAA
Entry | Date | Aircraft M & M | Aircraft Ident | Points of Departure & Arrival |  |  | Aircraft Category |  |  | Ground Train | Type of Piloting Time |  |  |  |  | Conditions of Flight |  |  |  |  | # [NAME] | Land. Day | Land. Night | Total Duration of Flight | Remarks, Procedures, Maneuvers |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | SPIN
 |  |  |  | From | <> | To | SEL | [NAME] |  |  | Dual Rec | Dual Given | PIC | SIC | Solo | Day | Night | XC | Act Inst | [NAME]
 | 2019-11-11 00:00:00 | PA-28 |  |  |  |  | 1.3 |  |  |  | 1.3 |  |  |  |  | 1.3 |  |  |  |  |  | 1 |  | 1.3
 | 2019-11-13 00:00:00 | PA-28 |  |  |  |  | 1 |  |  |  | 2 |  |  |  |  | 2 |  |  |  |  |  | 2 |  | 2 |  |  |  |  | X
 | 2019-11-14 00:00:00 | PA-28 |  |  |  |  | 1 |  |  |  | 1 |  |  |  |  | 1 |  |  |  |  |  | 1 |  | 1
 | 2019-11-18 00:00:00 | PA-28 |  |  |  |  | 1.5 |  |  |  | 1.5 |  |  |  |  | 1.5 |  |  |  |  |  | 5 |  | 1.5
 | 2019-11-19 00:00:00 | PA-28 |  |  |  |  | 2 |  |  |  | 2 |  |  |  |  | 2 |  |  |  |  |  | 13 |  | 2
 | 2019-11-19 00:00:00 | PA-28 |  |  |  |  | 1.5 |  |  |  | 1.5 |  |  |  |  | 1.5 |  |  |  |  |  | 8 |  | 1.5 |  |  |  |  |  |  | X
 | 2019-11-23 00:00:00 | PA-28 |  |  |  |  | 1.4 |  |  |  | 1.4 |  |  |  |  | 1.4 |  |  |  |  |  | 8 |  | 1.4
 | 2019-11-26 00:00:00 | PA-28 |  |  |  |  | 2.4 |  |  |  | 2.4 |  |  |  |  | 2.4 |  |  |  |  |  | 15 |  | 2.4
 | 2019-12-10 00:00:00 | PA-28 |  |  |  |  | 2.2 |  |  |  | 2.2 |  |  |  |  | 2.2 |  |  |  |  |  | 15 |  | 2.2
 | 2019-12-10 00:00:00 | PA-28 |  |  |  |  | 1.1 |  |  |  | 1.1 |  |  |  |  | 1.1 |  |  |  |  |  | 7 |  | 1.1
 | 2020-10-01 00:00:00 | PA-28 |  |  |  |  | 1 |  |  |  |  |  |  |  |  | 1 |  |  |  |  |  |  | 3 | 1
 | 2020-11-01 00:00:00 | PA-28 |  |  |  |  | 1 |  |  |  |  |  |  |  |  | 1 |  |  |  |  |  | 3 |  | 1
Spreadsheet: 01009194-4b31-4241-bd4d-44c570110903
Sheet: Sheet1

2004-09-14 00:00:00 | Unnamed: 1 | Unnamed: 2 | Unnamed: 3 | Unnamed: 4 | Unnamed: 5 | Unnamed: 6
 | Sorlucco, d | Gallus, r | [NAME] |  |  | Page 1 of 2
Albany | 27 | 0 | 2
Atkinson and [NAME]. Gt. | 0 | 0
[NAME] | 69 | 1 | 2
Bean's Grant | 0 | 0
Bean's Purchase | 0 | 0
[NAME] | 128 | 5
[NAME] | 103 | 12 | 1
[NAME] 3 | 125 | 13
[NAME] 4 | 108 | 3
Bethlehem | 81 | 0
Cambridge | 0 | 0
Carroll | 29 | 0
[NAME]'s Purchase | 0 | 0
[NAME] | 5 | 0
Colebrook | 49 | 1 | 1
Columbia | 2 | 2
Crawford's Purchase | 0 | 0
Cutt's Grant | 0 | 0
[NAME] | 22 | 0
Dix's Grant | 0 | 0
Dixville | 3 | 0
Dummer | 6 | 0
Errol | 8 | 2 | 1
Erving's Location | 0 | 0
Franconia | 68 | 0
[NAME] | 111 | 3 | 1
Green's Grant | 0 | 0
Hadley's Purchase | 0 | 0
Hale's Location | 1 | 0
Hart's Location | 1 | 0
[NAME] | 72 | 0
[NAME] | 21 | 0 | 2
Kilkenny | 0 | 0
Lancaster | 94 | 2
Lincoln | 40 | 0
Lisbon | 19 | 0
Littleton | 156 | 3 | 7
Livermore | 0 | 0
Low and Burbank's Grant | 0 | 0
[NAME] | 20 | 0
Martin's Location | 0 | 0
Milan | 56 | 2
[NAME] | 0 | 0
Northumberland | 40 | 2
[NAME] | 0 | 0
[NAME]'s Grant | 0 | 0
Pittsburg | 12 | 0
Randolph | 48 | 0 | 1
Sargent's Purchase | 0 | 0
Second College Grant | 0 | 0
Shelburne | 17 | 0
[NAME] | 22 | 0
2004-09-14 00:00:00
 | Sorlucco, d | Gallus, r | [NAME] |  |  | Page 2 of 2
Stewartstown | 15 | 0
[NAME] | 18 | 0
Success | 0 | 0
[NAME] | 36 | 0
Thompson & Meserve's Purchase | 0 | 0
Waterville Valley | 14 | 0
Wentworth's Location | 0 | 0
[NAME] | 59 | 2
Totals | 1705 | 53 | 18
Spreadsheet: 756144d1637309799-lookup-longest-date-against-an-order-test-sheet
Sheet: Sheet1

Sheet one |  |  | Sheet two
W/O No. | Order ready by |  | WO Number | Due Date
48483 |  | wrong | 48483 | 2021-11-15 00:00:00
48568 |  | wrong | 48483 | 2021-11-22 00:00:00
48569 |  | correct | 48483 | 2021-12-22 00:00:00 | Longest due date for 48483
48570 |  | correct | 48483 | 2021-12-06 00:00:00
48571 |  |  | 48483 | 2021-12-06 00:00:00
48572 |  |  | 48483 | 2021-12-06 00:00:00
48573 |  | correct | 48483 | 2021-12-06 00:00:00
 |  |  | 48483 | 2021-12-06 00:00:00
 |  |  | 48483 | 2021-12-06 00:00:00
 |  |  | 48568 | 2021-12-25 00:00:00 | Longest due date for 48568
 |  |  | 48568 | 2021-12-20 00:00:00
 |  |  | 48568 | 2021-11-18 00:00:00
 |  |  | 48568 | 2021-12-20 00:00:00
 |  |  | 48568 | 2021-12-20 00:00:00
 |  |  | 48568 | 2021-12-20 00:00:00
 |  |  | 48568 | 2021-12-20 00:00:00
 |  |  | 48569 | 2021-11-23 00:00:00
 |  |  | 48569 | 2021-11-23 00:00:00
 |  |  | 48570 | 2021-12-20 00:00:00
 |  |  | 48570 | 2021-12-20 00:00:00
 |  |  | 48570 | 2021-11-17 00:00:00
 |  |  | 48570 | 2021-12-20 00:00:00
 |  |  | 48573 | 2021-12-16 00:00:00
 |  |  | 48573 | 2021-12-20 00:00:00
Spreadsheet: 103141d1300940719-sorting-out-all-repeat-numbers-workbook16
Sheet: Sheet1

 |  | DOU
037
001
029
038
047
056
002
039
057
066
003
012
049
058
067
022
059
068
077
005
551
398
423
287
966
674
961
133
743
889
501
563
902
001
321
532
652
819
343
662
Spreadsheet: 547022d1510301853-excel-reporting-assistance-book12
Sheet: Sheet1

Last Name | Type Amount | Last Name | Type
Frog General | 50
Frog Donation | 75 |  |  |  |  | Sum of Type Amount | Type
Frog Payment | 35 |  |  |  |  | Last Name2 | Donation | General | Payment | Grand Total
 |  |  |  |  |  | Frog | 75 | 50 | 35 | 160
 |  |  |  |  |  | Grand Total | 75 | 50 | 35 | 160
Spreadsheet: 188288d1350804995-pull-specific-data-from-multiple-dynamic-worksheets-into-one-report-sheet-sample
Sheet: LEGRAND

ORDER DATE | SUPPLIER | PART NO | [NAME] | UM | QTY | PPU | EXPECTED DELIVERY DATE | ORDER STATUS |  | LEGEND
2012-06-26 00:00:00 | Legrand | 874.R4040 | SLOTTED CABLE TRUNK. 40X40 GREY SH.PITCH | ml | 140 | 1 | 2012-11-15 00:00:00 | F/D |  | F/D -  FULL DELIVERY
2012-06-27 00:00:00 | Legrand | 874.R4060 | SLOTTED CABLE TRUNK. 40X60 GREY SH.PITCH | ml | 168 | 1 | 2012-11-16 00:00:00 | F/D |  | P/D - PARTIAL DELIVEY
2012-06-28 00:00:00 | Legrand | 874.R4080 | SLOTTED CABLE TRUNK. 40X80 GREY SH.PITCH | ml | 80 | 1 | 2012-11-17 00:00:00 | F/D |  | N/D - NOT DELIVERED
2012-06-29 00:00:00 | Legrand | 874.R6060 | SLOTTED CABLE TRUNK. 60X60 GREY SH.PITCH | ml | 128 | 1 | 2012-11-18 00:00:00 | F/D
2012-06-30 00:00:00 | Legrand | 116.68 | ANGLED PLUG 2P+E 10A WHITE "BLUELINE" | buc | 50 | 1 | 2012-11-19 00:00:00 | F/D
2012-07-01 00:00:00 | Legrand | 672.2002 | CONSUMER UNIT 2 DIN | buc | 5 | 1 | 2012-11-20 00:00:00 | F/D
2012-07-02 00:00:00 | Legrand | 673.4024B | SURFACE MOUNTING CONSUMER UNIT 24 DIN MO | buc | 5 | 1 | 2012-11-21 00:00:00 | F/D
2012-07-03 00:00:00 | Legrand | 673.4036B | SURFACE MOUNTING CONSUMER UNIT 36 DIN MO | buc | 5 | 1 | 2012-11-22 00:00:00 | F/D
2012-07-04 00:00:00 | Legrand | 673.5054B | SURFACE MOUNTING CONSUMER UNIT 54 DIN MO | buc | 5 | 1 | 2012-11-23 00:00:00 | P/D
2012-07-05 00:00:00 | Legrand | 675.2012B | FLUSH MOUNTING CONSUMER UNIT 12 DIN MOD. | buc | 5 | 1 | 2012-11-24 00:00:00 | P/D
2012-07-06 00:00:00 | Legrand | 675.4024B | FLUSH MOUNTING CONSUMER UNIT 24 DIN MOD. | buc | 5 | 1 | 2012-11-25 00:00:00 | P/D
2012-07-07 00:00:00 | Legrand | 675.4036B | FLUSH MOUNTING CONSUMER UNIT 36 DIN MOD. | buc | 3 | 1 | 2012-11-26 00:00:00 | P/D
2012-07-08 00:00:00 | Legrand | 874.R2580 | SLOTTED CABLE TRUNK. 25X80 GREY SH.PITCH | ml | 112 | 1 | 2012-11-27 00:00:00 | P/D
2012-07-09 00:00:00 | Legrand | 820.725 | HALF SADDLE D.25-26 ZINC PLATED STEEL | buc | 1000 | 1 | 2012-11-28 00:00:00 | P/D
2012-07-10 00:00:00 | Legrand | 512.3257 | EUREKA SURF.M.SOC. ANGLED BOX 3P+N+E 32A | buc | 20 | 1 | 2012-11-29 00:00:00 | P/D
2012-07-11 00:00:00 | Legrand | 515.6357 | SURF.MOUN. SOCKET ANGLED BOX 3P+N+E 63A | buc | 6 | 1 | 2012-11-30 00:00:00 | N/D
2012-07-12 00:00:00 | Legrand | 673.2018B | SURFACE MOUNT. CONSUMER UNIT 18 DIN MOD. | buc | 10 | 1 | 2012-12-01 00:00:00 | N/D
2012-07-13 00:00:00 | Legrand | 673.4024B | SURFACE MOUNTING CONSUMER UNIT 24 DIN MO | buc | 5 | 1 | 2012-12-02 00:00:00 | N/D
2012-07-14 00:00:00 | Legrand | 632.4500-000 | BLOCK4 DISTRIBUTION BOARD WITH CUTOUTS | buc | 10 | 1 | 2012-12-03 00:00:00 | N/D
2012-07-15 00:00:00 | Legrand | 632.3501-000 | BLOCK3 DISTRIB.BOARD WITH CUTOUTS NO DIN | buc | 5 | 1 | 2012-12-04 00:00:00 | N/D
2012-07-16 00:00:00 | Legrand | 874.R4080 | SLOTTED CABLE TRUNK. 40X80 GREY SH.PITCH | bax | 1 | 1 | 2012-12-05 00:00:00 | N/D
Spreadsheet: 270664d1381578100-sumif-advanced-30-daysforum
Sheet: Suppliers

Date (Right Click-Insert Date) | Payment Status | Invoice  Number | Job Number | Supplier | Payment Method | Net (Before VAT) | VAT @ 20% | GROSS (Net + VAT) | Payment terms End of Month + 30 Days? | Payment Terms (In days) | Payment due date
2013-08-01 00:00:00 | Paid |  |  | Edmundsons |  | 100
2013-08-02 00:00:00 | Paid |  |  |  |  | 100
2013-08-03 00:00:00 | Paid |  |  |  |  | 100
2013-08-04 00:00:00 | Paid |  |  |  |  | 100
2013-08-05 00:00:00 | Paid |  |  |  |  | 100
2013-08-06 00:00:00 |  |  |  |  |  | 100
2013-08-07 00:00:00 |  |  |  |  |  | 100
2013-08-08 00:00:00 |  |  |  |  |  | 100
2013-08-09 00:00:00 |  |  |  |  |  | 100
2013-08-10 00:00:00 |  |  |  |  |  | 100
2013-08-11 00:00:00 |  |  |  |  |  | 100
2013-08-12 00:00:00 |  |  |  |  |  | 100
2013-08-13 00:00:00 |  |  |  |  |  | 100
2013-08-14 00:00:00 |  |  |  |  |  | 100
2013-08-15 00:00:00 |  |  |  |  |  | 100
Spreadsheet: 804042d1667853658-ref-error-ref-error-example
Sheet: Part 1

Part 1 | Usage
December | 10
January | 10
February | 10
March | 0
April | 10
May | 10
June | 10
July | 0
August | 10
September | 10
October | 10
November | 10