tianzl66/Sheetpedia huggingface dataset:
Spreadsheet: 769744d1645663349-sumifs-to-add-total-volume-for-specific-user-only-if-another-cell-contains-that-user-id-shamansprise-example
Sheet: Processor #'s

1 | 0 | username | ID | Name | 10 |  |  | code | Job | Subjob | 0.02286245353159851 |  |  | ACL_FL1 |  | 1 |  |  |  | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 |  | 0 | 0 | 0 |  | 0 | 0 | 0 | 0
2 | 0 | [NAME] | ID2 | [NAME] | 10 |  |  | code1 | Job2 | Subjob | 0.02286245353159851 |  |  | [NAME] |  | 2 |  |  |  | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 |  | 0 | 0 | 0 |  | 0 | 0 | 0 | 0
2 | 0 | [NAME] | ID2 | [NAME] | 10 |  |  | code1 | Job2 | Subjob | 0.02286245353159851 |  |  | ACL_FL3 |  | 2 |  |  |  | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 |  | 0 | 0 | 0 |  | 0 | 0 | 0 | 0
2 | 0 | [NAME] | ID2 | [NAME] | 10 |  |  | code1 | Job2 | Subjob | 0.02286245353159851 |  |  |  |  | 2 |  |  |  | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 |  | 0 | 0 | 0 |  | 0 | 0 | 0 | 0
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | Add total numbers from "DA PROD" L:L tab if O2 Contains "ACL_FL1"
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | Add total numbers from "DA PROD" L:L  if [NAME] either "ACL_FL2" or "ACL_FL3"
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | Add total numbers from "DA PROD" L:L tab if O4 Contains either "ACL_FL2" or "ACL_FL3"
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | Should return blank under both columns due to O5 being blank
Spreadsheet: e5ecf372-90a3-4807-9020-718b53a8ee23
Sheet: Sheet1

PROG ID | ATHLETE ID | ATHLETE FIRST | ATHLETE LAST | NATIONALITY | START NUMBER | RUN | T1 | BIKE | T2 | RUN.1 | POSITION | TOTAL TIME
5178 | 29433 | Fabrizio | Vignali | ITA | 536 | 00:41:16 | 00:00:43 | 01:13:45 | 00:01:16 | 00:21:57 | 1 | 02:18:57
5178 | 27354 | Sven | Niebergall | GER | 537 | 00:50:55 | 00:01:20 | 01:26:13 | 00:01:33 | 00:31:37 | 2 | [NAME]
Spreadsheet: 811b184e-d445-47ad-85af-2ad3a21abdfe
Sheet: Sheet1

Reporting School: | Kankakee Valley | Unnamed: 2 | Unnamed: 3 | Unnamed: 4 | Unnamed: 5 | Date: | 2009-12-30 00:00:00 | Unnamed: 8 | Unnamed: 9 | Unnamed: 10 | Unnamed: 11 | Unnamed: 12 | Unnamed: 13 | Unnamed: 14 | Unnamed: 15 | Unnamed: 16
Overall Record:
Conference Record:
School | 1st | 2nd | 3rd | 4th | OT | Final
Rensselaer | 14 | 8 | 25 | 11
Kankakee Valley | 10 | 9 | 13 | 14
Add. Stats
 |  |  |  |  |  |  | Total | Offensive | Defensive | Total |  |  | Blocked
Player | 2PA | 2PM | 3PA | 3PM | FTA | FTM | Points | Rebounds | Rebounds | Rebounds | Assists | Steals | Shots | TO | Fouls | #GM
Zach Overby | 3 | 1 | 0 | 0 | 0 | 0 | 2 | 0 | 1 | 1 | 2 | 1 | 0 | 0 | 1 | 8
Brad Leegwater | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 8
[NAME] | 0 | 0 | 1 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 1 | 8
Zach DeFries | 2 | 0 | 1 | 1 | 0 | 0 | 3 | 0 | 1 | 1 | 0 | 1 | 1 | 2 | 3 | 8
[NAME] Dahm | 1 | 0 | 5 | 4 | 2 | 2 | 14 | 1 | 1 | 2 | 0 | 1 | 0 | 1 | 3 | 8
[NAME] | 6 | 2 | 3 | 1 | 0 | 0 | 7 | 2 | 2 | 4 | 1 | 1 | 0 | 4 | 5 | 8
[NAME] | 11 | 4 | 0 | 0 | 2 | 0 | 8 | 3 | 2 | 5 | 3 | 3 | 2 | 3 | 2 | 8
[NAME] | 5 | 1 | 0 | 0 | 0 | 0 | 2 | 2 | 0 | 2 | 0 | 0 | 0 | 1 | 1 | 8
[NAME] | 5 | 2 | 0 | 0 | 7 | 6 | 10 | 0 | 3 | 3 | 1 | 2 | 0 | 0 | 2 | 8
[NAME] | DNP |  |  |  |  |  | 0 |  |  | 0 |  |  |  |  |  | 8
 |  |  |  |  |  |  | 0 |  |  | 0
 |  |  |  |  |  |  | 0 |  |  | 0
 |  |  |  |  |  |  | 0 |  |  | 0
 |  |  |  |  |  |  | 0 |  |  | 0
 |  |  |  |  |  |  | 0 |  |  | 0
 |  |  |  |  |  |  | 0 |  |  | 0
 |  |  |  |  |  |  | 0 |  |  | 0
 |  |  |  |  |  |  | 0 |  |  | 0
 |  |  |  |  |  |  | 0 |  |  | 0
 |  |  |  |  |  |  | 0 |  |  | 0
 |  |  |  |  |  |  | 0 |  |  | 0
 |  |  |  |  |  |  | 0 |  |  | 0
 |  |  |  |  |  |  | 0 |  |  | 0
 |  |  |  |  |  |  | 0 |  |  | 0
Spreadsheet: 116674d1311975639-selective-columns-priors-hall
Sheet: Hp

Huband. P |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | HANDICAPPING
hole | par | stroke index | adjusted par | pts calc | [NAME] | strokes | points | PAR 3 | INDEX 1 | INDEX 2 | INDEX 3 | adjusted par | pts calc | [NAME] | points | handicap | handicap |  | handicap | catergory | Buffer Zone | css | Nett Differential | adjustment
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | Nett | Nett
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | points | points
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | par 3 |  |  | [NAME]
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | hole | par | stroke index | strokes | points | penalty
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | sss | css adj | "RO"
in
out
total
Spreadsheet: 848118d1698917375-using-formula-to-return-unique-values-works-but-returns-a-double-value-testsheets-3-1-ans
Sheet: Partnerships

 | Partner |  | Budget |  | Actuals |  | Opmerkingen |  | Kwartaal
 | Value 1 |  | 10000 |  | 10000 |  | [NAME] ipsum dolor sit amet, consectetur adipiscing elit |  | Q4
 | Value 2 |  | 5000 |  | 5200 |  |  |  | Q2
 | Value 3 |  | 10000 |  | 10500 |  |  |  | Q1
 | Value 4 |  | 4000 |  | 4000 |  |  |  | Q3
 | Value 3 |  | 2500 |  | 2750
 | Value 2 |  | 500 |  | 500
 | Value 3 |  | 1500 |  | 1750
SUBTOTAAL |  |  |  |  |  |  |  | Q1 |  | undesired result
 |  |  |  |  |  |  |  | Q2
 |  |  |  |  |  |  |  | Q3
 |  |  |  |  |  |  |  | Q4
TOTAAL
Spreadsheet: 736793d1623863824-automatically-select-groups-of-4-numbers-to-arrive-close-to-an-average-sample-worksheet
Sheet: Sheet1

Player
1 | -1 | 1 |  |  | Team 1 | Team 2 | Team 3 | Team 4 | Team 5 | Team 6 | Team 7 | Team 8 | Team 9 | Team 10 | Team 11 | Team 12 | Team 13 | Team 14 | Team 15 | Team 16 | Team 17 | Team 18 | Team 19 | Team 20
2 | 0 | 2 |  | player | 1 | 2 | 3 | 4
3 | 2 | 3 |  |  | 40 | 24 | 23 | 21
4 | 2 | 4 |  |  | 42 | 43 | 41 | 44
5 | 3 |  |  |  | 77 | 78 | 79 | 76
6 | 4 |  |  | team | 43 | 43 | 43 | 43
7 | 4
8 | 4
9 | 4
10 | 5
11 | 6
12 | 6
13 | 6
14 | 6
15 | 6
16 | 7
17 | 7
18 | 7
19 | 7
20 | 7
21 | 7 | 4
22 | 7
23 | 7 | 3
24 | 8 | 2
25 | 8
26 | 8
27 | 8
28 | 8
29 | 8
30 | 8
31 | 8
32 | 8
33 | 8
34 | 8
35 | 8
36 | 8
37 | 8
38 | 8
39 | 8
40 | 9 | 1
41 | 9 | 3
42 | 10 | 1
43 | 10 | 2
44 | 10 | 4
45 | 10
46 | 10
47 | 10
48 | 10
49 | 10
50 | 11
51 | 11
52 | 11
53 | 11
54 | 12
55 | 12
56 | 12
57 | 13
58 | 13
59 | 13
60 | 13
61 | 13
62 | 14
63 | 15
64 | 15
65 | 16
66 | 16
67 | 16
68 | 16
69 | 17
70 | 18
71 | 20
72 | 20
73 | 21
74 | 23
75 | 24
76 | 24 | 4
77 | 25 | 1
78 | 25 | 2
79 | 25 | 3
80 | 25
4-Group Average:
Spreadsheet: 845683d1697095225-filter-cells-starting-with-1-alphabet-excluding-number-and-symbols-sample-workbook
Sheet: Sheet1

SO | Create on | PO | DPO | ISNUMBER FORMULA
10114972 | 2020-06-02 00:00:00 | [PHONE]//MPP05C1 | MPP05C1 |  | =FILTER(A2:D17,IFERROR((CODE(UPPER(LEFT(D2:D100,1)))>=65)*(CODE(UPPER(LEFT(D2:D100,1)))<=90),0))
10115364 | 2020-06-03 00:00:00 | [PHONE]//MPY89W1 | MPY89W1
10291982 | 2021-12-28 00:00:00 | [PHONE]/10 1/2 | /10 1/2 | False
10292373 | 2021-12-29 00:00:00 | [PHONE]/10 1/2 | /10 1/2 | False
10292424 | 2021-12-29 00:00:00 | [PHONE]/10 1/2 | /10 1/2 | False
10331211 | 2022-02-03 00:00:00 | [PHONE]/10 1/2 | /10 1/2 | False
10339069 | 2022-02-14 00:00:00 | [PHONE]/10 1/2 | /10 1/2 | False
10443461 | 2022-07-02 00:00:00 | [PHONE]/10 1/2 | /10 1/2 | False
10443464 | 2022-07-02 00:00:00 | [PHONE]/10 3/3 | /10 3/3 | False
10444217 | 2022-07-05 00:00:00 | [PHONE]/10 1/2 | /10 1/2 | False
10444952 | 2022-07-06 00:00:00 | [PHONE]/10 1/2 | /10 1/2 | False
10452166 | 2022-07-13 00:00:00 | [PHONE]/10 3/3 | /10 3/3 | False
10208536 | 2021-04-12 00:00:00 | [PHONE] | 174794 | True
10209049 | 2021-04-13 00:00:00 | [PHONE] | 177469 | True
10243967 | 2021-07-27 00:00:00 | [PHONE] | 189671 | True
10610264 | 2023-03-21 00:00:00 | [PHONE]/G/G | 301/G/G
Spreadsheet: 836014d1689051771-conditional-formatting-for-dates-based-on-number-of-days-difference-from-another-date-excel-test-data-dates-conditional-formatting
Sheet: Goal

Name | [NAME] | Step 1 (42 days prior) | Step 2 (35 days prior) | Step 3 (14 days prior)
Adam | 2023-08-11 00:00:00 | 2023-06-01 00:00:00 | 2023-06-25 00:00:00 | 2023-07-14 00:00:00
[NAME] | 2023-07-31 00:00:00 | 2023-06-13 00:00:00 | 2023-06-29 00:00:00 | 2023-07-13 00:00:00
[NAME] | 2023-09-01 00:00:00 | 2023-07-01 00:00:00 | 2023-08-08 00:00:00 | 2023-08-20 00:00:00
[NAME] | 2023-06-30 00:00:00 | 2023-06-01 00:00:00 | 2023-06-13 00:00:00 | 2023-06-14 00:00:00
Spreadsheet: 484370d1476237874-regrouping-an-array-array-transformation
Sheet: Sheet1

 | Array 1 | -----------> | [NAME]
 | 1
 | 2 | ----------->
 | 4
 | 2
 | 5 | ----------->
 | 7
 | 1
 | 6 | ----------->
 | 1
 | 1
 | 3 | ----------->
 | 1
Spreadsheet: david_delainey__8063__Walton Cashflow Model 070600
Sheet: Project Assumptions

DOYLE I, LLC
ASSUMPTIONS AND SUMMARY
PROJECT DESCRIPTION: |  | GE7EAs |  | GE7Bs |  | ESTIMATED PASS-THROUGH MAINTENANCE COSTS ($000) |  |  | Yr. 2000 $
No. Turbines |  | 2 |  | 3 |  | Total Pass-through Maintenance Costs |  |  | 2554.947915596575
[NAME] (MW) |  | 82.5 |  | 62.2
Net MW |  |  |  |  |  | Assumed Escalation |  |  | 0.02
Heat Rate (HHV) |  | 11975.91403485782 |  | 12200
Total Project MW |  |  |  |  |  | ESCALATING CAPACITY PAYMENT COSTS ($000) |  |  | Yr. 2000 $
Wtd Avg Heat Rate |  |  |  |  |  | Total Escalating Capacity Payment Costs |  |  | 333
Annual Peak Operating Hours |  |  |  | 1400
[NAME] (Years) |  |  |  | 15 |  | [NAME]. [NAME]. Pmt. Escalation |  |  | 0.02
Start of Commercial Operation |  |  |  | 2000-05-15 00:00:00
Installed Cost ($/kW)
 |  |  |  |  |  | MAJOR [NAME] ASSUMPTIONS
PPA ASSUMPTIONS |  |  |  |  |  | Number of Starts per year |  |  | 110
Fixed Capacity Payment ($/kWmo) |  |  |  | 2.937632781013099 |  | Major [NAME] $ per start per turbine |  |  | 990.6981818181819
Fixed Capacity Payment Escalation |  |  |  | 0
 |  |  |  |  |  | STATE & FEDERAL TAX ASSUMPTIONS
Escalating Capacity Payment ($/kWmo) |  |  |  | 0.086 |  | Federal Income Tax Rate |  |  | 0.35
Escalating Capacity Payment Escalation |  |  |  | 0.02 |  | State Income Tax Rate |  |  | 0.06
 |  |  |  |  |  | Effective Income Tax Rate |  |  | 0.389
Call Option Price of Plant at end of Term ($000) |  |  |  | 10000
 |  |  |  |  |  | PROPERTY TAX ASSUMPTIONS
 |  |  |  |  |  | Assessed Value Multiplier |  |  | 0.4
SOURCES OF FUNDS |  |  |  |  |  | Millage Rate for School Tax |  |  | 0.014
Estimated Equity Capital = Walton EMC Equity ($000) |  |  | 0.03 | 3503.759025174894 |  | Years of School Tax Abatement |  |  | 5
Estimated Permanent Loan ($000) |  |  | 0.97 | 117411.7639951783 |  | Millage rate for County Tax |  |  | 0.014
 |  |  |  |  |  | Years of County Tax Abatement |  |  | 5
Estimated Total Sources ($000) |  |  |  |  |  | Year 1 Pass-through Property Tax Expense |  |  | 126
DEBT FINANCING ASSUMPTIONS: |  |  |  |  |  | OWNERSHIP ASSUMPTIONS
 |  |  |  | 0 |  | ECT Ownership % |  |  | 0.5
 |  |  |  |  |  | WEMC Ownership % |  |  | 0.5
Walton EMC Equity |  |  |  | 0.03
Debt |  |  |  | 0.97
Type of Amortization |  |  |  | Mortgage Style |  | PRE-TAX RETURNS TO WALTON
 |  |  |  |  |  | [NAME] @ 6% discount rate
[NAME] ($000)
Term |  |  |  | 15
Interest Rate |  |  |  | 0.06
Min DSCR
Avg. DSCR
[NAME]
Avg. Life (years) |  |  |  | 9.596657574740416
Spreadsheet: 541296d1507211946-need-something-to-find-duplicates-across-sheets-inventory-accuracy-template
Sheet: Quebec

Area | Region | Location Number | Location Name | Country | Ending Inventory | Total $ Counted | Value Difference | Inventory $ [NAME] | Number Of Parts Counted | Number Of Parts Counted With Errors | Count Error Rate | Book Quantity | Counted Quantity | Piece Count Error Rate | Operational Error Rate | Operational Count Delta | Status | Location Type | Last Wall To Wall
 |  |  | CAN TOTAL
Spreadsheet: 42035d1240569733-random-selection-of-cell-value-from-list-based-on-changing-weighting-681019_partizan
Sheet: list test

Number | Name | Weighting Integar |  |  |  | Weighting Fraction %
1 | Artur Boruc | 1 | 0.01 |  |  | 0.9259259259259258 | 5
2 | Igor Tudor | 5 | 1.01 |  |  | 4.62962962962963 | 25
3 | Alessandro Grandoni | 3 | 6.01 |  |  | 2.777777777777778 | 15
4 | [NAME] | 3 | 9.01 |  |  | 2.777777777777778 | 15
5 | [NAME] | 12 | 12.01 |  |  | 12.03703703703704 | 65
6 | [NAME] | 13 | 24.01 |  |  | 12.96296296296296 | 70
7 | [NAME] | 13 | 37.01 |  |  | 12.96296296296296 | 70
8 | [NAME] | 12 | 50.01 |  |  | 12.03703703703704 | 65
9 | [NAME] | 13 | 62.01 |  |  | 12.96296296296296 | 70
10 | [NAME] | 14 | 75.01 |  |  | 13.88888888888889 | 75
11 | Massimiliano [NAME] | 12 | 89.01 |  |  | 12.03703703703704 | 65
 | 10
Spreadsheet: 464084d1464871139-average-last-10-entries-ignoring-zeros-average-weeks-2
Sheet: Sheet1

Average
Average of last 10 entries (ignoring zeros)
Average ignoring zeros
 | 2017 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 2016
Month | December |  |  | November |  |  |  |  | October |  |  |  | September |  |  |  | August |  |  |  |  | July |  |  |  | June |  |  |  |  | May |  |  |  | April |  |  |  | March |  |  |  |  | February |  |  |  | January |  |  |  | December |  |  |  |  | November |  |  |  |  | October |  |  |  | September |  |  |  | August |  |  |  |  | July |  |  |  | June |  |  |  |  | May |  |  |  | April |  |  |  | March |  |  |  |  | February |  |  |  | January
Wk Number | 52 | 51 | 50 | 49 | 48 | 47 | 46 | 45 | 44 | 43 | 42 | 41 | 40 | 39 | 38 | 37 | 36 | 35 | 34 | 33 | 32 | 31 | 30 | 29 | 28 | 27 | 26 | 25 | 24 | 23 | 22 | 21 | 20 | 19 | 18 | 17 | 16 | 15 | 14 | 13 | 12 | 11 | 10 | 9 | 8 | 7 | 6 | 5 | 4 | 3 | 2 | 1 | 52 | 51 | 50 | 49 | 48 | 47 | 46 | 45 | 44 | 43 | 42 | 41 | 40 | 39 | 38 | 37 | 36 | 35 | 34 | 33 | 32 | 31 | 30 | 29 | 28 | 27 | 26 | 25 | 24 | 23 | 22 | 21 | 20 | 19 | 18 | 17 | 16 | 15 | 14 | 13 | 12 | 11 | 10 | 9 | 8 | 7 | 6 | 5 | 4 | 3 | 2 | 1
Total | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 5 | 48 | 7 | 1 | 2 | 54 | 43 | 1 | 1 | 54 | 6 | 5 | 4 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0
Spreadsheet: 465431d1465646437-calculate-unique-names-and-repeted-names-test
Sheet: FERMA 1

SIRE NAME
ALTAAVALON
ALTAAVALON
ALTAAVALON
ALTAAVALON
ALTAAVALON
ALTAAVALON
ALTAAVALON
ALTAAVALON
ALTAAVALON
ALTAANTRIM
ALTAANTRIM
ALTAANTRIM
ALTAANTRIM
ALTAANTRIM
ALTAANTRIM
ALTAANTRIM
ALTAANTRIM
ALTAARMANI
ALTAARMANI
ALTAARMANI
ALTAARMANI
ALTAARMANI
ALTAARMANI
ALTAARMANI
ALTAARMSTEAD
ALTAARMSTEAD
ALTAARMSTEAD
ALTAARMSTEAD
ALTAARMSTEAD
ALTAARMSTEAD
ALTAARMSTEAD
TUNIS
TUNIS
TUNIS
TUNIS
TUNIS
TUNIS
TUNIS
TWISTER
TWISTER
TWISTER
TWISTER
TWISTER
TWISTER
ALTAAGENCY
ALTAAGENCY
ALTAAGENCY
ALTAAGENCY
YANKEE
YANKEE
YANKEE
URSUS
URSUS
[NAME]
[NAME]
ULTRAFOX
VACHIM
VAN DE VEN
WATSON
WIN 395
WINCEL
Spreadsheet: 742612d1627917007-summing-by-multiple-criteria-multiple-sum-test
Sheet: Sheet1

Date | Weekending | Customer | Tool | Delivery Note | No. Pallets
2021-08-02 00:00:00 |  | Becton | 12086 | D024861 | 16
2021-08-02 00:00:00 |  | Becton | 12086 | D024860 | 16
2021-08-02 00:00:00 |  | UVA | 15525 | D024864 | 24
2021-08-02 00:00:00 |  | Leeds | 16943B | D024862 | 26
2021-08-02 00:00:00 |  | Leeds | 17003B | D024863 | 26
2021-08-02 00:00:00 |  | Compiegne | 16160 | D024859 | 2
Spreadsheet: diana_scholtes__8584__PORTLANDGE August variances worksheet
Sheet: Daily totals

 | Data
Act Date | Sum of Gross MW | Sum of Price | Sum of Total Amt
2001-08-01 00:00:00 | -11 | 1670.17 | -6342.549999999994
2001-08-02 00:00:00 | 3 | 1212.68 | -5437.4
2001-08-03 00:00:00 | 3 | 1371.48 | -5432.400000000009
2001-08-04 00:00:00 | 6 | 1476.94 | -5447.400000000009
2001-08-05 00:00:00 | 0 | 341.96 | -5402.399999999991
2001-08-06 00:00:00 | 3 | 1767.64 | -5432.399999999992
2001-08-07 00:00:00 | 3 | 1820.72 | -5543.700000000005
2001-08-08 00:00:00 | 3 | 1928.24 | -1448.500000000012
2001-08-09 00:00:00 | 3 | 2150.36 | -9902.89999999999
2001-08-10 00:00:00 | 3 | 1580.06 | -5763.700000000012
2001-08-11 00:00:00 | 6 | 1790.38 | -5763.399999999994
2001-08-12 00:00:00 | 0 | 339.4 | -5582.4
2001-08-13 00:00:00 | 3 | 1407.08 | -5503.7
2001-08-14 00:00:00 | 16 | 1426.96 | -5463.5
2001-08-15 00:00:00 | 35 | 979.26 | -5417.400000000008
2001-08-16 00:00:00 | 59 | 947.9 | -5577.400000000023
2001-08-17 00:00:00 | 13 | 1565.14 | -9828.399999999994
2001-08-18 00:00:00 | 19 | 1513.6 | -7928.400000000009
2001-08-19 00:00:00 | 48 | 291.96 | -5402.399999999992
2001-08-20 00:00:00 | 19 | 1039.34 | -8956.600000000017
2001-08-21 00:00:00 | 4 | 1074 | -6057.4
2001-08-22 00:00:00 | 36 | 959.04 | -5477.399999999994
2001-08-23 00:00:00 | 67 | 636 | -5497.4
2001-08-24 00:00:00 | 43 | 630.22 | -5537.4
2001-08-25 00:00:00 | 40 | 687.53 | -5605.649999999994
2001-08-26 00:00:00 | 0 | 235.94 | -5762.399999999994
2001-08-27 00:00:00 | 26 | 898.42 | -5577.4
2001-08-28 00:00:00 | 21 | 666.22 | -5537.4
2001-08-29 00:00:00 | 24 | 753.8 | -5587.400000000012
2001-08-30 00:00:00 | 25 | 497.18 | -5457.4
2001-08-31 00:00:00 | 20 | 497.18 | -5457.4
Grand Total | 540 | 34156.8 | -183131.6
Spreadsheet: 835747d1688780159-can-an-array-formula-refer-to-itself-book1
Sheet: Sheet1

2 | 2
3 | 3
4 | 4
0 | 4
0 | 4
5 | 5
0 | 5
6 | 6
7 | 7
0 | 7
0 | 7
0 | 7
8 | 8
0 | 8
9 | 9
Spreadsheet: 858398d1707120699-options-in-filter-arent-alphabetical-examplenumeric
Sheet: Data

Artikel | Kolom1 | Artikelgroep
0004 | A | 700
0005 | B | 300
0006 | A | 710
0007 | A | 564
0009 | E | 300
0014 | D | 300
0016 | C | 300
0019 | C | 300
0020 | A | 300
0021 | D | 850
46 | A | 300
125 | D | 300
0062 | F | 564
0063 | D | 210
0066 | A | 310
0072 | D | 564
0073 | E | 800
0089 | C | 200
0097 | C | 100
0098 | B | 300
0099 | B | 564
0100 | D | 710
0101 | F | 700
0105 | A | 900
0106 | D | 120
0108 | B | 200
Spreadsheet: 785330d1656344996-convert-date-using-number-that-is-not-formatted-correctly-dummy-list-etaf
Sheet: Sheet1

PHL Loan Number | Months DIFF DUE DATE | Current Due Date | b2/12 | d2*-1 | [NAME]) | DATE(YEAR(A2)+B2,MONTH(A2),DAY(A2))
1234567890 | 108 | 2022-06-01 00:00:00
 | 96 | 2022-06-02 00:00:00
 | 96 | 2022-06-03 00:00:00
 | 108 | 2022-06-04 00:00:00
 | 108 | 2022-06-05 00:00:00
 | 84 | 2022-06-06 00:00:00
 | 108 | 2022-06-07 00:00:00
 | 108 | 2022-06-08 00:00:00
 | 60 | 2022-06-09 00:00:00
 | 84 | 2022-06-10 00:00:00
 | 108 | 2022-06-11 00:00:00
 | 108 | 2022-06-12 00:00:00
 | 72 | 2022-06-13 00:00:00
 | 84 | 2022-06-14 00:00:00
 | 60 | 2022-06-15 00:00:00
 | 108 | 2022-06-16 00:00:00
 | 84 | 2022-06-17 00:00:00
 | 96 | 2022-06-18 00:00:00
 | 96 | 2022-06-19 00:00:00
 | 120 | 2022-06-20 00:00:00
 | 120 | 2022-06-21 00:00:00
 | 84 | 2022-06-22 00:00:00
 | 120 | 2022-06-23 00:00:00
 | 60 | 2022-06-24 00:00:00
 | 72 | 2022-06-25 00:00:00
 | 36 | 2022-06-26 00:00:00
 | 96 | 2022-06-27 00:00:00
 | 108 | 2022-06-28 00:00:00
 | 84 | 2022-06-29 00:00:00
 | 96 | 2022-06-30 00:00:00
 | 84 | 2022-07-01 00:00:00
 | 72 | 2022-07-02 00:00:00
 | 96 | 2022-07-03 00:00:00
 | 84 | 2022-07-04 00:00:00
 | 36 | 2022-07-05 00:00:00
 | 48 | 2022-07-06 00:00:00
 | 12 | 2022-07-07 00:00:00
 | 12 | 2022-07-08 00:00:00
Spreadsheet: 53863d1253791294-multiple-criteria-help-example
Sheet: Sheet2

officename | postcode | OFFICE AND PCODE | OFFICE AND PCODE | projectname | value | [NAME] | orderno | orderflag | STATUS | OFFICE AND PCODE | TOTAL QUOTED | NO. QUOTED | NO. OF ORDERS | ORDER VALUE | NO. OF JOBS THEY WON | % ORDERS FROM JOBS THEY WON | NO. OUTSTANDING | £ [NAME] | % OUTSTANDING | NO. THEY WON WE LOST | £ THEY WON WE LOST | % THEY WON WE LOST
OFFICE A | 1A | OFFICE A 1A | OFFICE A 1A | SCHOOL | 53838 | Order | C1234 | 1 | order | OFFICE A 1A | 61488 | 2 | 1 | 53838
OFFICE B | 2B | OFFICE B 2B | OFFICE B 2B | NURSERY | 2355 |  |  | 0 |  | OFFICE B 2B | 4146 | 3 | 0 | 0
OFFICE C | 3C | OFFICE C 3C | OFFICE C 3C | HOUSE | 0 | Order |  | 0 |  | OFFICE C 3C | 39414 | 3 | 1 | 15670
OFFICE C | 3C | OFFICE C 3C | OFFICE C 3C | HOTEL | 15670 | Order |  | 1 | order
OFFICE B | 2B | OFFICE B 2B | OFFICE B 2B | HOSPITAL | 1421 | Order |  | 0
OFFICE B | 2B | OFFICE B 2B | OFFICE B 2B | WAREHOUSE | 370 | Dead |  | 0 | dead elsewhere
OFFICE A | 1A | OFFICE A 1A | OFFICE A 1A | UNIVERSITY | 7650 | Dead |  | 2 | dead
OFFICE C | 3C | OFFICE C 3C | OFFICE C 3C | COLLEGE | 23744 |  |  | 0
Spreadsheet: tracy_geaccone__40541__tw_actflash_o&m
Sheet: TWOCT01

[NAME]
O&M by Alternate Hierarchy
Period Ending October 31, 2001
6th Workday
 | Actual | Actual | Flash | Over/(Under) | Over/(Under) | Actual | Actual
 | September 2001 | October 2001 | October 2001 | Prior Month | Flash | YTD October 2001 | YTD September 2001
ETS - Commercial (AGR-TP10) | 178210.18 |  | 160000
ETS - Market Services (AGR-TP20) | 141196.53 |  | 146000
ETS - Operations (AGR-TP30) | 1944044.53 |  | 1416000
ETS - Finance & Accounting (AGR-TP40) | 851677.66
ETS - Systems (AGR-TP50) | 262226.53 |  | 487000
ETS - Legal (AGR-TP60) | 53796.93999999994 |  | 160000
ETS - HR (AGR-TP70) | 23786.64 |  | 23000
ETS - Executive (AGR-TP80) | 41060.99 |  | 25000
Total O&M Expense
(A) R111477 includes YTD October Adjustment for FI/CO reconciliation of $(40,550.69) (AGR-NN40)
[NAME]
O&M by Alternate Hierarchy
(000's)
 | Actual | Actual | Flash | Over/(Under) | Over/(Under) | Actual
 |  |  |  | Prior Month | Flash
ETS - Commercial (AGR-TP10)
ETS - Market Services (AGR-TP20)
ETS - Operations (AGR-TP30)
ETS - Finance & Accounting (AGR-TP40)
ETS - Systems (AGR-TP50)
ETS - Legal (AGR-TP60)
ETS - HR (AGR-TP70)
ETS - Executive (AGR-TP80)
Total O&M Expense
Prior Month [NAME]  :
Operations (AGR-TP30)
Increase in Vehicle Equipment Fuel Expense | 113
Increase in M&S Fleet & Equipment Expense | 103
Increase due to electrical motor repairs for Gallup CC 111132 | 283
Other | 21
Total
Finance & Accounting (AGR-TP40)
Reclass Company 1202 O/S Service Allocation from Operations to F&A | 162
Other | 18
Total
Systems (AGR-TP50)
Increase in Computer Exp for CC 111000 (ETS Infrastructure) | 122
Other | 5
Total
Legal (AGR-TP60)
Increase in ETS allocations from company 366 | 73
Total
Spreadsheet: 179615d1347315144-insert-copied-cells-multiple-times-shift-cell-down-forum_red
Sheet: Reduced

1 | 2 | 3 | 4 | 19 | 20 | 21 | 22
1 | 2 | 3 | 4 | 19 | 20
1 | 2 | 3 | 4 | 19 | 21
1 | 2 | 3 | 4 | 19 | 22
1 | 2 | 3 | 4 | 20 | 21
1 | 2 | 3 | 4 | 20 | 22
1 | 2 | 3 | 4 | 21 | 22
1 | 2 | 3 | 19 | 20 | 21
1 | 2 | 3 | 19 | 20 | 22
1 | 2 | 3 | 19 | 21 | 22
1 | 2 | 3 | 20 | 21 | 22
1 | 2 | 4 | 19 | 20 | 21
1 | 2 | 4 | 19 | 20 | 22
1 | 2 | 4 | 19 | 21 | 22
1 | 2 | 4 | 20 | 21 | 22
1 | 2 | 19 | 20 | 21 | 22
1 | 3 | 4 | 19 | 20 | 21
1 | 3 | 4 | 19 | 20 | 22
1 | 3 | 4 | 19 | 21 | 22
1 | 3 | 4 | 20 | 21 | 22
1 | 3 | 19 | 20 | 21 | 22
1 | 4 | 19 | 20 | 21 | 22
2 | 3 | 4 | 19 | 20 | 21
2 | 3 | 4 | 19 | 20 | 22
2 | 3 | 4 | 19 | 21 | 22
2 | 3 | 4 | 20 | 21 | 22
2 | 3 | 19 | 20 | 21 | 22
2 | 4 | 19 | 20 | 21 | 22
3 | 4 | 19 | 20 | 21 | 22
1 | 2 | 3 | 10 | 19 | 20 | 21 | 28
1 | 2 | 3 | 11 | 19 | 20 | 21 | 29
1 | 2 | 4 | 10 | 19 | 20 | 22 | 28
1 | 2 | 4 | 11 | 19 | 20 | 22 | 29
1 | 2 | 10 | 11 | 19 | 20 | 28 | 29
1 | 3 | 4 | 10 | 19 | 21 | 22 | 28
1 | 3 | 4 | 11 | 19 | 21 | 22 | 29
1 | 3 | 10 | 11 | 19 | 21 | 28 | 29
1 | 4 | 10 | 11 | 19 | 22 | 28 | 29
2 | 3 | 4 | 10 | 20 | 21 | 22 | 28
2 | 3 | 4 | 11 | 20 | 21 | 22 | 29
2 | 3 | 10 | 11 | 20 | 21 | 28 | 29
2 | 4 | 10 | 11 | 20 | 22 | 28 | 29
3 | 4 | 10 | 11 | 21 | 22 | 28 | 29
1 | 2 | 3 | 12 | 19 | 20 | 21 | 30
1 | 2 | 4 | 12 | 19 | 20 | 22 | 30
1 | 2 | 10 | 12 | 19 | 20 | 28 | 30
1 | 3 | 4 | 12 | 19 | 21 | 22 | 30
1 | 3 | 10 | 12 | 19 | 21 | 28 | 30
1 | 4 | 10 | 12 | 19 | 22 | 28 | 30
2 | 3 | 4 | 12 | 20 | 21 | 22 | 30
2 | 3 | 10 | 12 | 20 | 21 | 28 | 30
2 | 4 | 10 | 12 | 20 | 22 | 28 | 30
3 | 4 | 10 | 12 | 21 | 22 | 28 | 30
1 | 2 | 3 | 13 | 19 | 20 | 21 | 31
1 | 2 | 4 | 13 | 19 | 20 | 22 | 31
1 | 2 | 10 | 13 | 19 | 20 | 28 | 31
1 | 3 | 4 | 13 | 19 | 21 | 22 | 31
1 | 3 | 10 | 13 | 19 | 21 | 28 | 31
1 | 4 | 10 | 13 | 19 | 22 | 28 | 31
2 | 3 | 4 | 13 | 20 | 21 | 22 | 31
2 | 3 | 10 | 13 | 20 | 21 | 28 | 31
2 | 4 | 10 | 13 | 20 | 22 | 28 | 31
3 | 4 | 10 | 13 | 21 | 22 | 28 | 31
1 | 2 | 11 | 12 | 19 | 20 | 29 | 30
1 | 3 | 11 | 12 | 19 | 21 | 29 | 30