tianzl66/Sheetpedia huggingface dataset:
Spreadsheet: 137242bd-8a19-4c90-86d0-1cf6b54ceb45
Sheet: Sheet1

NAME: | Unnamed: 1 | SKILLS INVENTORY | Unnamed: 3
For each of the leadership core competencies, please rate how you perform. These responsibilities will be evaluated by our board selection committee to determine which board canidates will be the best fit in order to make Solar Oregon a well rounded team.
*  Please be honest but not overly critical.
 |  | Rate 1 to 5 with 5 being excellent
[NAME] | SKILL | My level of skill in this area | I am Interested in doing this for SO
Strategic | Create a vision
 | Create a vision with functional tasks
 | Participate in strategic planning
 | Participate in Board meetings
Programs | Develop programs
 | Manage programs
 | Lead programs
 | Present in a public forum
 | Participate in a program committee
 | Participate in a tours committee
 | Participate in a workshop committee
Membership | Develop a membership plan
 | Manage a membership plan
 | Lead a membership plan
 | Solicit new members
 | Contact existing members for renewal
 | Participate in a membership committee
Fundraising | Participate in fundraising activities
 | Identify donors/corporations/foundations
 | Research grants
 | Write proposals/grants
 | Edit written proposals
 | Contact individuals, corporations, foundations
 | Socialize at network events on behalf of organization
 | Develop a fundraising plan
 | Manage a fundraising event
 | Lead a fundraising event
 | Participate in a fundraising committee
Admin. | Train volunteers
Communication
 | Plan marketing efforts
 | Review/update website
 | Write articles
 | Edit articles
 | Design Graphics
 | Coordinate graphic/printing efforts
 | Develop a communications plan
 | Manage a communications plan
 | Lead a communications plan
 | Participate in communications committees
Spreadsheet: 2532feeb-5693-4fe6-b857-1662c8e9ccec
Sheet: 1RD OUT OF 148

ANON# | RANK
10917 | 24
11155 | 32
12194 | 26
12441 | 13
13431 | 18
13886 | 35
17588 | 10
20143 | 16
21130 | 22
25208 | 5
26987 | 34
33727 | 6
35452 | 23
36347 | 33
38201 | 14
39213 | 12
41076 | 28
42924 | 7
46288 | 7
52542 | 11
53323 | 14
53456 | 25
55291 | 1
61674 | 27
62638 | 9
64934 | 36
66320 | 2
66322 | 31
67351 | 17
70153 | 20
76474 | 30
83694 | 4
85350 | 20
88505 | 29
92003 | 19
94088 | 37
94174 | 3
Spreadsheet: 178229d1346721879-pivot-table-query-top-4-items-ignoring-selected-items-from-the-list-pivot-table-query
Sheet: Data

Customer | Sales $ | Period
A | 100 | Jan
A | 120 | Feb
B | 234 | Jan |  |  |  | Pivot table showing Top 4 customers based on Sales in descending order
B | 231 | Feb
C | 2345 | Jan |  |  | 1, | I need to get the Top 4 list ignoring customer EX
C | 324 | Feb |  |  |  | So the Top 4 customers will be H, K, D and C
D | 3456 | Jan |  |  | 2, | How do I remove the (blank) column ?
D | 342 | Feb
EX | 3456 | Jan
EX | 342 | Feb |  |  |  | Sum of Sales | Period
F | 234 | Jan |  |  |  | Customer | Jan | Feb | (blank) | Grand Total
F | 235 | Feb |  |  |  | H | 546 | 5647 |  | 6193
G | 1235 | Jan |  |  |  | K | 4658 | 564 |  | 5222
G | 124 | Feb |  |  |  | EX | 3456 | 342 |  | 3798
H | 546 | Jan |  |  |  | D | 3456 | 342 |  | 3798
H | 5647 | Feb |  |  |  | Grand Total | 12116 | 6895 |  | 19011
I | 1567 | Jan
I | 465 | Feb
J | 465 | Jan
J | 789 | Feb
K | 4658 | Jan
K | 564 | Feb
Spreadsheet: 538814d1505839724-pivot-table-displaying-old-data-53rd-street-cost-schedule
Sheet: Draw 8 - 08.07.17

Description | Line Item | Line Item # | Date | Amount | Payee | Notes |  | Row Labels | Line Number | Sum of Amount
Retaining Wall Materials | Block/Retaining Walls | 345 | 2017-08-06 00:00:00 | 114.52 | Home Depot | Retaining wall materials |  | Block/Retaining Walls | 345 | 114.52
Grading and Export | Rough Grading | 302 | 2017-08-04 00:00:00 | 4750 | B&M Grading | Grading and export material to [NAME] |  | Erosion Control | 211 | 1293.6
Stormwater BMPs | Erosion Control | 211 | 2017-07-31 00:00:00 | 750 | B&M Grading | Stormwater BMPs |  | Rough Grading | 302 | 4750
Stormwater BMPs | Erosion Control | 211 | 2017-08-01 00:00:00 | 134.69 | Summit Erosion Control | Stormwater BMPs |  | Grand Total | 256 | 6158.12
Stormwater BMPs | Erosion Control | 211 | 2017-08-01 00:00:00 | 408.91 | Summit Erosion Control | Stormwater BMPs
Spreadsheet: 84152d1284139927-pull-out-the-top-five-most-common-numbers-in-a-block-of-numbers-cycletimeeval
Sheet: Sheet1

DATE | NUMBERS |  |  |  |  |  |  |  | CycleTime
8-26 | 4 | 10 | 26 | 32 | 41 | 31 |  | 1 |  | 21 | 0 | 41 | 1 | 61 | 0 | 81
8-31 | 10 | 20 | 29 | 47 | 48 | 38 |  | 2 | 0 | 22 | 0 | 42 | 0 | 62 | 0 | 82
9-3 | 4 | 13 | 20 | 28 | 36 | 9 |  | 3 | 0 | 23 | 0 | 43 | 0 | 63 | 0 | 83 |  |  |  | 4 | 10 | 26 | 32 | 41
 |  |  |  |  |  |  |  | 4 | 2 | 24 | 0 | 44 | 0 | 64 | 0 | 84
 |  |  |  |  |  |  |  | 5 | 0 | 25 | 0 | 45 | 0 | 65 | 0 | 85
 |  |  |  |  |  |  |  | 6 | 0 | 26 | 1 | 46 | 0 | 66 | 0 | 86 |  |  |  | 21.66666666666667
 |  |  |  |  |  |  |  | 7 | 0 | 27 | 0 | 47 | 1 | 67 | 0 | 87
 |  |  |  |  |  |  |  | 8 | 0 | 28 | 1 | 48 | 1 | 68 | 0 | 88
 |  |  |  |  |  |  |  | 9 | 1 | 29 | 1 | 49 | 0 | 69 | 0 | 89
 |  |  |  |  |  |  |  | 10 | 2 | 30 | 0 | 50 | 0 | 70 | 0 | 90
 |  |  |  |  |  |  |  | 11 | 0 | 31 | 1 | 51 | 0 | 71 | 0 | 91 |  |  | true
 |  |  |  |  |  |  |  | 12 | 0 | 32 | 1 | 52 | 0 | 72 | 0 | 92
 |  |  |  |  |  |  |  | 13 | 1 | 33 | 0 | 53 | 0 | 73 | 0 | 93 |  |  |  | U15: =MODE(IF(ISNA(MATCH($B$2:$G$21,$U$14:$U14,0)),$B$2:$G$21))
 |  |  |  |  |  |  |  | 14 | 0 | 34 | 0 | 54 | 0 | 74 | 0 | 94 |  |  |  | U15: =MODE(IF(ISNA(MATCH($B$2:$B$21,$U$14:$U14,0)),$B$2:$B$21))
 |  |  |  |  |  |  |  | 15 | 0 | 35 | 0 | 55 | 0 | 75 | 0 | 95 |  |  |  | U15: =MODE(IF(ISNA(MATCH($B$2:$G$21,$I$2:$I2,0)),$B$2:$G$21))
 |  |  |  |  |  |  |  | 16 | 0 | 36 | 1 | 56 | 0 | 76 | 0 | 96 |  |  |  | U15: =MODE(IF(ISNA(MATCH($B$2:$G$21,$I$2:$I2,0)),$B$2:$G$21))
 |  |  |  |  |  |  |  | 17 | 0 | 37 | 0 | 57 | 0 | 77 | 0 | 97 |  |  |  | U15: =MODE(IF(ISNA(MATCH($B$2:$G$21,$I$2:$I2,0)),$B$2:$G$21))
 |  |  |  |  |  |  |  | 18 | 0 | 38 | 1 | 58 | 0 | 78 | 0 | 98 |  |  |  | U15: =MODE(IF(ISNA(MATCH($B$2:$G$21,$I$2:$I2,0)),$B$2:$G$21))
 |  |  |  |  |  |  |  | 19 | 0 | 39 | 0 | 59 | 0 | 79 | 0 | 99
 |  |  |  |  |  |  |  | 20 | 2 | 40 | 0 | 60 | 0 | 80 | 0 | 100
Spreadsheet: 721595d1614783296-conditional-formatting-breaking-when-inserting-deleting-rows-test
Sheet: 2021

Account | B | C | D | New/Renewal | Status | ref | Territory | Occupancy | J | K | L | M | N | Inception Date | [NAME] | Date Received | Currency | Limit (Local CCY) | Excess (Local CCY) | Premium (Local CCY) | Deductions | [NAME] | Limit (USD) | Excess (USD) | [NAME] (USD) | Net Prm 100% (USD) | Our Line (USD) | GWP Geo (USD) | NWP Geo (USD) | Our Exp GWP (USD) | Comments | Rate Movement | AH | Deductions (USD) | Bdx | DGL Peer Reviewed | Territory Continent | Adequacy Ratio | Ascot Premium | Everest Premium | Bound
A | DL | broker | Me | Renewal | Bound | P00308/2021 | Germany | Light Manufacturing |  |  | 0 | 1 |  | 2021-01-01 00:00:00 | 2021-12-31 00:00:00 | 2020-12-21 00:00:00 | EUR | 1 | 1 | 1 | 0.12805 | 0.03 |  |  |  |  |  |  |  |  |  |  | Yes |  |  | To send |  | 1.903288785697178 |  |  | 2021-01-29 00:00:00
B | DL | broker | Me | Renewal | NTU | P00309/2021 | Germany | Light Manufacturing |  |  | 0 | 1 |  | 2021-01-01 00:00:00 |  |  | EUR | 1 | 1 | 1
C | JP | broker | Me | Renewal | NTU | P00312/2021 | France | Steel & Metalworkers (hot) |  |  | 1 | 0 |  | 2021-01-01 00:00:00 |  | 2020-11-11 00:00:00 | USD | 1 | 1 | 1
D | NC | broker | Me | Renewal | Bound | P00159/2021 | Mexico | Mining Open Cast |  |  | 1 | 0 |  | 2021-01-01 00:00:00 |  |  | USD | 1 | 1 | 1 | 0.2 | 0.06 |  |  |  |  |  |  |  |  |  |  | Yes |  |  | Sent |  | 1.3472 |  |  | 2021-01-27 00:00:00
E | DL | broker | Me | Renewal | Bound | P00316/2021 | Saudi Arabia | Food Processing |  |  | 1 | 0 |  | 2021-01-01 00:00:00 | 2021-12-31 00:00:00 | 2020-11-11 00:00:00 | SAR | 1 | 1 | 1 | 0.2 | 0.025 |  |  |  |  |  |  |  |  |  |  | Yes |  |  | Yes |  | 1.295426806016421 |  |  | 2021-01-29 00:00:00
F | CL | broker | Me | Renewal | Bound | P00313/2021 | Germany | Food Processing |  |  | 1 | 0 |  | 2021-01-01 00:00:00 |  |  | EUR | 1 | 1 | 1 | 0.2 | 0.025 |  |  |  |  |  |  |  |  |  |  | yes |  |  |  |  | 1.28 |  |  | 2021-01-25 00:00:00
G | DL | broker | Me | Renewal | NTU | P00247/2021 | France | Food Processing |  |  | 1 | 0 |  | 2021-01-01 00:00:00 | 2021-12-31 00:00:00 | 2020-10-27 00:00:00 | EUR | 1 | 1 | 1 | 0.225 | 0.015
H | DL | broker | Me | Renewal | Quoted | P00164/2021 | France | Paint & mixing |  |  | 1 | 0 |  | 2021-01-01 00:00:00 | 2021-12-31 00:00:00 | 2020-10-27 00:00:00 | EUR | 1 | 1 | 1 | 0.225 | 0.035
I | DL | broker | Me | Renewal | Quoted | P00217/2021 | France | Electronic Manufacturing |  |  | 1 | 0 |  | 2021-01-01 00:00:00 | 2021-12-31 00:00:00 | 2020-10-27 00:00:00 | EUR | 1 | 1 | 1 | 0.225 | 0.04
Spreadsheet: 773070d1647604877-vlookup-based-on-cell-b-string-vlookup-condition-string
Sheet: Sheet1

AEGINNO | 363 STEM |  |  | AEGINNO | GANOINE
CANOEING | C |  |  | ADELNOS | LOADENS
NONIMAGE | M
ANGINOSE | S
GANOINES | S
ADELNOS | 365 STEM
CELADONS | C
DONEGALS | G
SLOGANED | G
NODALISE | I
LODESMAN | M
LADRONES | R
SOLANDER | R
Spreadsheet: 63041d1264007125-conditonal-formatting-formulas-conditional-formatting-example
Sheet: Sheet1

2900 | 0.7920116878321689 | 1.304982736081729
3000 | 0.7656112982377632 | 1.261483311545671
3100 | 0.7409141595849321 | 1.220790301495811
3200 | 0.717760592097903 | 1.182640604574067
3300 | 0.6960102711252393 | 1.146803010496064
3400 | 0.6755393807980264 | 1.113073510187357
3500 | 0.6562382556323685 | 1.081271409896289
3600 | 0.638009415198136 | 1.051236092954726
3700 | 0.6207659174900783 | 1.022824306658652
3800 | 0.604429972292971 | 0.995907877536056
3900 | 0.5889317678752025 | 0.9703717781120547
4000 | 0.5742084736783224 | 0.9461124836592533
4100 | 0.5602033889544609 | 0.9230365694236617
4200 | 0.5468652130269738 | 0.9010595082469078
4300 | 0.5341474173751837 | 0.8801046359620961
4400 | 0.5220077033439295 | 0.8601022578720484
4500 | 0.5104075321585089 | 0.8409888743637807
4600 | 0.4993117162420195 | 0.8227065075297855
4700 | 0.4886880627049552 | 0.805202113752556
4800 | 0.4785070613986021 | 0.7884270697160444
4900 | 0.4687416111659775 | 0.7723367213544925
5000 | 0.4593667789426579 | 0.7568899869274026
5100 | 0.4503595871986842 | 0.7420490067915712
5200 | 0.4416988259064019 | 0.7277788335840409
5300 | 0.4333648857949604 | 0.7140471574786817
5400 | 0.4253396101320907 | 0.7008240619698173
Spreadsheet: 1925c5d7-a35f-4a11-a27c-05b5737e2b86
Sheet: Sheet1

Name of Unit | Degree | Professional | Current | Predicited | Difference | Performance | Director | Recommendation | Unnamed: 9 | Total | % Increase
 |  | Service | Salary | Salary |  | Rating |  |  |  | Salary
 |  |  |  |  |  |  | COLA | Merit | Equity
Agents |  | 2013-01-01 00:00:00 |  |  |  |  | 0 | Increase | Increase
 |  |  |  |  | 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
Total Agent Salaries |  |  | 0 | 0 |  |  | 0 | 0 | 0 | 0
 | Professional |  |  |  |  |  | Hourly
 | Service | Annual | Hourly | Annual | COLA | Performance | Merit/Equity | New Hourly | Total | Total $ | % Increase
Staff | 2013-01-01 00:00:00 | Hours | Salary | Salary | 0 | Rating | Increase | Salary | Salary | Increase
 |  |  |  | 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
Total Staff Salaries |  |  |  | 0 |  |  |  |  | 0 | 0
 |  |  | Agents | Staff | Total
Total Salaries |  |  | 0 | 0 | 0
Total Budgeted Salary Dollars |  |  | 0 |  | Additional Amount available --------> |  |  | 0
KSU 8-37 (July 2013)
Spreadsheet: 783885d1655273534-pick-unique-values-from-column-list-sample
Sheet: Sheet1

Order Date | Fruit | Quantity |  |  |  | Date | Fruit | Total Quantity per day
2022-06-14 00:00:00 | Apple | 2 |  |  |  | 2022-06-14 00:00:00 | Apple | 5
2022-06-14 00:00:00 | Apple | 3 |  |  |  | 2022-06-14 00:00:00 | Orange | 4
2022-06-14 00:00:00 | Orange | 4 |  |  |  | 2022-06-13 00:00:00 | Apple | 2
2022-06-13 00:00:00 | Apple | 2 |  |  |  | 2022-06-12 00:00:00 | Apple | 4
2022-06-12 00:00:00 | Apple | 4 |  |  |  | 2022-06-12 00:00:00 | Orange | 3
2022-06-12 00:00:00 | Orange | 3 |  |  |  | 2022-06-11 00:00:00 | Apple | 1
2022-06-11 00:00:00 | Apple | 1 |  |  |  | 2022-06-10 00:00:00 | Apple | 5
2022-06-10 00:00:00 | Apple | 2
2022-06-10 00:00:00 | Apple | 3
Spreadsheet: 30756e73-8437-48ce-bb7d-f90401ea469c
Sheet: FSTA

FSTA Direct (IFIS)
2007-2008
 | 2007-07-01 00:00:00 | 2007-08-01 00:00:00 | 2007-09-01 00:00:00 | 2007-10-01 00:00:00 | 2007-11-01 00:00:00 | 2007-12-01 00:00:00 | 2008-01-01 00:00:00 | 2008-02-01 00:00:00 | 2008-03-01 00:00:00 | 2008-04-01 00:00:00 | 2008-05-01 00:00:00 | 2008-06-01 00:00:00 | Total | 2007-2008 Price | Price per unit
FSTA Direct
Abstracts viewed | 36 | 88 | 120 | 181 | 183 | 105 | 84 | 323 | 346 | 1348 | 223 | 96 |  | 3914
COUNTER-Compliant?: | No
Spreadsheet: 0e22fb43-7c3c-462c-a196-d55cc3cb0fba
Sheet: Expense Form

 | Bellarmine University Expense Claim Form                     Page 1
 | CARS IV# |  |  |  | Check, U.S. Mail
 | Date Rec'd in A/P |  |  |  | Address
 |  |  |  |  | City, State & Zip Code
 | CARS ID# |  | Acct# |  | Check, specify        Campus Mail                  Hold for pickup
BU Faculty/Staff | Payee Name
BU Student | Department |  |  |  | Extension#
Other |  | A | B | C | D |  | E | F | G
Purpose, Destination, Explanation & Other Required Information | Date of Expense/Receipt (MM/DD/YYYY) | Personal Auto Mileage (32000) | Airfare, Taxis (32000) | [NAME] (35000) | Lodging (32000) |  | Meals (34100) | Conference Fee (54000 Fac) (54500) Staff | Other Expenses (Explain)
Claims for expenses should be submitted every | Total Miles
30 days according to BU policy. | Calculation @ $0.56 per mile |  | Original receipts are required for all expenses in Columns B, C, D, E, F & G.
The IRS requires reimbursement requests to be filed within 60 days of the expense. The date the form is received in Accounts Payable is considered the date of consideration for the 60 days. If reimbursement is approved on those expenses submitted past 60 days, reimbursement will be via payroll as "other income." |  |  | For meals, the detail menu receipt must be submitted as well.
 |  |  |  |  |  |  | Column Totals of A, B, C, D, E, F & G
Payee's Signature
 | Signature denotes expenses are in compliance with University policies & procedures |  |  |  |  |  | Less Personal Expenses
 |  |  |  |  |  |  | Less Cash Advance
Supervisor's/Dean's/Area Head's Signature |  |  |  |  |  |  | Due to payee/(Bellarmine)
Supervisor's/Dean's/Area Head's Printed Name
Account # |  | Account # |  |  |  |  | Entered by A/P  (initials)
Account # |  | Account # |  |  |  |  | Approved by (initials)
See http://www.bellarmine.edu/purchasing/universitypoliciesandprocedures.aspx for Policies concerning this form.
Spreadsheet: 142218d1329741486-looking-up-dates-with-if-problem-sample-project-overview-sheet
Sheet: DATA

 |  | 1 | 2 | 3 | 4 | 5 | 6 | 7 | 8 | 9
 | Event Type 1 (Milestones)
Project 1 |  | 2012-02-21 00:00:00 | 2012-03-07 00:00:00 | 2012-04-03 00:00:00
Project 2 |  | 2012-02-23 00:00:00 | 2012-03-14 00:00:00 | 2012-04-06 00:00:00
 | Event Type 2 (Meetings)
Project 1 |  | 2012-02-24 00:00:00 | 2012-03-16 00:00:00 | etc
Project 2 |  | 2012-03-04 00:00:00 | 2012-04-04 00:00:00 | etc
Spreadsheet: 213365d1360470021-auto-sort-or-auto-filter-test
Sheet: Deans Ice Cream

Deans Ice Cream
Employee Number | Employee |  | Supervisor Assignment | Site  Assignment | Job # | OJT Checklist | Annual [NAME]
 | Last  Name | First  Name
Spreadsheet: 784405d1655723000-return-a-value-based-on-four-lookup-values-excel-forum-20-june-aligw
Sheet: Sheet1

 | 1 | 2 |  | Washing | Bleach | Iron | Dry Tumble | Value to be returned
 | Washing | 30 with two line |  | 30 with two line | Without bleach | With iron one dot | don’t apply dry tumble | <a href="https://postimg.cc/r0GM7dsC" target="_blank"><img src="https://i.postimg.cc/MTNHMV84/77-polyester-23-spandex.png" width="320" height="60"  alt="77-polyester-23-spandex"/></a><br/><br/>
 | Bleach | Without bleach |  | 30 degree wash | Without bleach | iron with one dot | tumble dry with one dot | <a href="https://postimg.cc/KRxRcby8" target="_blank"><img src="https://i.postimg.cc/Hs752WZX/polyester-85-spandex-15.png" width="320" height="60"  alt="polyester-85-spandex-15"/></a><br/><br/>
 | Iron | With iron one dot
 | Dry Tumble | don’t apply dry tumble
 | Return value
Spreadsheet: 267265d1380030871-ranking-by-percentage-of-contribution-to-category-test-file
Sheet: Sheet1

CATEGORY | UPC | UNITS SOLD | CONTRIBUTION TO CATEGORY
 |  |  | BY PERCENTAGE
RTE CEREAL | 1111111111 | 500
RTE CEREAL | 2222222222 | 1500
RTE CEREAL | 3333333333 | 2000
RTE CEREAL | 4444444444 | 1000
RTE CEREAL | 5555555555 | 50
RTE CEREAL | 6666666666 | 20
RTE CEREAL | 7777777777 | 900
RTE CEREAL | 8888888888 | 350
RTE CEREAL | 9999999999 | 200
BAG CEREAL | 11111111110 | 560
BAG CEREAL | 12222222221 | 230
BAG CEREAL | 13333333332 | 235
BAG CEREAL | 14444444443 | 125
BAG CEREAL | 15555555554 | 16
BAG CEREAL | 16666666665 | 877
BAG CEREAL | 17777777776 | 999
NATURAL CEREAL | 18888888887 | 10
NATURAL CEREAL | 19999999998 | 15
NATURAL CEREAL | 21111111109 | 140
NATURAL CEREAL | 22222222220 | 144
NATURAL CEREAL | 23333333331 | 160
NATURAL CEREAL | 24444444442 | 25
NATURAL CEREAL | 25555555553 | 23
Spreadsheet: benjamin_rogers__935__PJM DAILY NEW
Sheet: Forecast_Load

Year | Month | Day | Date | Hour1.Predicted | Hour2.Predicted | Hour3.Predicted | Hour4.Predicted | Hour5.Predicted | Hour6.Predicted | Hour7.Predicted | Hour8.Predicted | Hour9.Predicted | Hour10.Predicted | Hour11.Predicted | Hour12.Predicted | Hour13.Predicted | Hour14.Predicted | Hour15.Predicted | Hour16.Predicted | Hour17.Predicted | Hour18.Predicted | Hour19.Predicted | Hour20.Predicted | Hour21.Predicted | Hour22.Predicted | Hour23.Predicted | Hour24.Predicted | MAX |  |  | [NAME]
PJM TEMP + 3
Year | Month | Day | Date | Hour1.Predicted | Hour2.Predicted | Hour3.Predicted | Hour4.Predicted | Hour5.Predicted | Hour6.Predicted | Hour7.Predicted | Hour8.Predicted | Hour9.Predicted | Hour10.Predicted | Hour11.Predicted | Hour12.Predicted | Hour13.Predicted | Hour14.Predicted | Hour15.Predicted | Hour16.Predicted | Hour17.Predicted | Hour18.Predicted | Hour19.Predicted | Hour20.Predicted | Hour21.Predicted | Hour22.Predicted | Hour23.Predicted | Hour24.Predicted | MAX
PJM TEMP -3
Year | Month | Day | Date | Hour1.Predicted | Hour2.Predicted | Hour3.Predicted | Hour4.Predicted | Hour5.Predicted | Hour6.Predicted | Hour7.Predicted | Hour8.Predicted | Hour9.Predicted | Hour10.Predicted | Hour11.Predicted | Hour12.Predicted | Hour13.Predicted | Hour14.Predicted | Hour15.Predicted | Hour16.Predicted | Hour17.Predicted | Hour18.Predicted | Hour19.Predicted | Hour20.Predicted | Hour21.Predicted | Hour22.Predicted | Hour23.Predicted | Hour24.Predicted | MAX
Spreadsheet: 118705d1313923007-listing-all-dates-that-a-specific-entry-was-made-listing-dates
Sheet: Sheet1

2011-08-08 00:00:00 | 3-1 | 51165/6-04010 | 121 |  |  |  |  | 1
2011-08-09 00:00:00 | 2-1 | 46212-TE009/10 | 125 |  |  |  |  | 2
2011-08-10 00:00:00 | 3-1 | 51165/6-04010 | 125 |  |  |  |  | 1
2011-08-11 00:00:00 | 2-1 | 46212-TE009/10 | 121 |  |  |  |  | 1
2011-08-12 00:00:00 | 3-1 | 51165/6-04010 | 101 |  |  |  |  | 2
2011-08-13 00:00:00 | 2-1 | 46212-TE009/10 | 125 |  |  |  |  | 1
2011-08-14 00:00:00 | 3-1 | 51165/6-04010 | 121 |  |  |  |  | 2
2011-08-15 00:00:00 | 2-1 | 46212-TE009/10 | 125 |  |  |  |  | 2
2011-08-16 00:00:00 | 3-1 | 51165/6-04010 | 105 |  |  |  |  | 1
2011-08-17 00:00:00 | 2-1 | 46212-TE009/10 | 121 |  |  |  |  | 1
2011-08-18 00:00:00 | 3-1 | 51165/6-04010 | 101 |  |  |  |  | 2
2011-08-19 00:00:00 | 2-1 | 46212-TE009/10 | 105 |  |  |  |  | 1
2011-08-20 00:00:00 | 3-1 | 51165/6-04010 | 121 |  |  |  |  | 2
2011-08-21 00:00:00 | 2-1 | 46212-TE009/10 | 125 |  |  |  |  | 2
2011-08-22 00:00:00 | 3-1 | 51165/6-04010 | 105 |  |  |  |  | 1
2011-08-23 00:00:00 | 2-1 | 46212-TE009/10 | 101 |  |  |  |  | 1
2011-08-24 00:00:00 | 3-1 | 51165/6-04010 | 121 |  |  |  |  | 3
2011-08-25 00:00:00 | 2-1 | 46212-TE009/10 | 105 |  |  |  |  | 1
2011-08-26 00:00:00 | 3-1 | 51165/6-04010 | 121 |  |  |  |  | 2
2011-08-27 00:00:00 | 2-1 | 46212-TE009/10 | 105 |  |  |  |  | 2
 |  | Record of entries for each Die# if D:D = 121 or 125
 |  | DIE# |  | 1 | 2 |  | 1 | 2 |  | 1 | 2 |  | 1 | 2 |  | 1 | 2 |  | 1 | 2
 |  | 51165/6-04010 | 2011-08-08 00:00:00 |  |  | 2011-08-10 00:00:00 | X |  | 2011-08-14 00:00:00 |  | X | 2011-08-20 00:00:00 |  | X | 2011-08-24 00:00:00 | X | X | 2011-08-26 00:00:00 |  | X
 |  | 46212-TE009/10 | 2011-08-09 00:00:00 |  | X | 2011-08-11 00:00:00 | X |  | 2011-08-13 00:00:00 | X |  | 2011-08-15 00:00:00 |  | X | 2011-08-17 00:00:00 | X |  | 2011-08-21 00:00:00 |  | X
 |  | DIE# |  | 1 | 2 |  | 1 | 2 |  | 1 | 2 |  | 1 | 2 |  | 1 | 2 |  | 1 | 2
 |  | 51165/6-04010
 |  | 46212-TE009/10
Spreadsheet: 191834d1352227324-click-hyperlink-in-listview-stats-database
Sheet: Sheet1

CLIENT | CODE 2011 | CODE 2012 | DATE | CODE
[NAME] | X0641 | X0641 | APRIL | 75G2
ALLAN | T0180 | T0180 | APRIL | [NAME]
MARK | T0977 | T0977 | APRIL | F1S9
[NAME] | X0461 | X0461 | APRIL | 3YG4
Spreadsheet: 793616d1661581590-pull-turn-static-values-into-a-dynamic-array-without-using-offset-daf-for-model-output-aligw
Sheet: Sheet1

 | [NAME] | 15 |  |  | 1 | 2 | 3 | 4 | 5 | 6 | 7 | 8 | 9 | 10 | 11 | 12 | 13 | 14
Method 1
 |  | INPUT ROW |  |  | 4 |  | 7 |  |  | 10 |  |  | 15
 |  | OUTPUT (USING OFFSET)
Method 2
 |  | INPUT ROW |  |  | 4 |  | 7 |  |  | 10 |  |  | 15
 |  | Step 1 |  |  | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0
 |  | Step 2 |  |  | 4 | 4 | 11 | 11 | 11 | 21 | 21 | 21 | 36 | 36 | 36 | 36 | 36 | 36
 |  | Step 3 |  |  | 4 | 0 | 7 | 0 | 0 | 10 | 0 | 0 | 15 | 0 | 0 | 0 | 0 | 0
 |  |  |  | I usually just place put a IF(time<1 or an IFERROR to make the #N/A = 0
 |  |  |  | But left it as is for the sake of showing how messy this method is
AliGW | Input row is row 5 |  |  |  | 4 | 0 | 7 | 0 | 0 | 10 | 0 | 0 | 15 | 0 | 0 | 0 | 0 | 0