tianzl66/Sheetpedia huggingface dataset:
Spreadsheet: 33927d1230849365-sum-skipping-columns-and-date-dependent-sumbgtcolsuptodate
Sheet: Sheet1

 | 1st Quarter |  |  |  |  |  |  |  |  |  | 2nd Quarter |  |  |  |  |  |  |  |  |  | 3rd Quarter |  |  |  |  |  |  |  |  |  | 4th Quarter |  |  |  |  |  |  |  |  |  | Year-to-date
Desc. | 2009-01-31 00:00:00 | Budget | 2009-02-28 00:00:00 | Budget | 2009-03-31 00:00:00 | Budget | Total | Budget | [NAME] | Var. % | 2009-04-30 00:00:00 | Budget | 2009-05-31 00:00:00 | Budget | 2009-06-30 00:00:00 | Budget | Total | Budget | [NAME] | Var. % | 2009-07-31 00:00:00 | Budget | 2009-08-31 00:00:00 | Budget | 2009-09-30 00:00:00 | Budget | Total | Budget | [NAME] | Var. % | 2009-10-31 00:00:00 | Budget | 2009-11-30 00:00:00 | Budget | 2009-12-31 00:00:00 | Budget | Total | Budget | [NAME] | Var. % | Total | Budget | [NAME] | Var. %
Line 1 | 99999 | 100 | 99999 | 100 | 99999 | 105 | 299997 | 305 |  |  |  | 100 |  | 105 |  | 100 |  | 305 |  |  |  | 100 |  | 100 |  | 75 |  | 275 |  |  |  | 75 |  | 100 |  | 100 |  | 275 |  |  |  | 405
Line 2 | 99999 | 125 | 99999 | 125 | 99999 | 115 | 299997 | 365 |  |  |  | 125 |  | 115 |  | 125 |  | 365 |  |  |  | 125 |  | 125 |  | 85 |  | 335 |  |  |  | 75 |  | 125 |  | 125 |  | 325 |  |  |  | 490
Line 3 | 99999 | 75 | 99999 | 75 | 99999 | 100 | 299997 | 250 |  |  |  | 75 |  | 100 |  | 105 |  | 280 |  |  |  | 75 |  | 75 |  | 95 |  | 245 |  |  |  | 85 |  | 75 |  | 75 |  | 235 |  |  |  | 325
Line 4 | 99999 | 150 | 99999 | 135 | 99999 | 150 | 299997 | 435 |  |  |  | 135 |  | 150 |  | 125 |  | 410 |  |  |  | 150 |  | 135 |  | 75 |  | 360 |  |  |  | 105 |  | 150 |  | 135 |  | 390 |  |  |  | 570
Problem: | How to populate cells AQ4:AQ7 (Budget Year to Date) depending on date selected in B17 i.e. if April is selected in B17, AQ4 would contain the total budget figures
 | for January, Febrruary, March and April
Date | 2009-04-30 00:00:00
 | 2009-01-31 00:00:00
 | 2009-02-28 00:00:00
 | 2009-03-31 00:00:00
 | 2009-04-30 00:00:00
 | 2009-05-31 00:00:00
 | 2009-06-30 00:00:00
 | 2009-07-31 00:00:00
 | 2009-08-31 00:00:00
 | 2009-09-30 00:00:00
 | 2009-10-31 00:00:00
 | 2009-11-30 00:00:00
 | 2009-12-31 00:00:00
Spreadsheet: 538737d1505811268-adding-row-content-from-sheet-to-sheet-example
Sheet: Accreditation

 |  |  |  |  | Accreditation
 |  |  |  |  | 2017-09-19 00:00:00
 | Session # | 8
 | 1 | Accreditation |  |  |  |  |  | Date from | Date Due | Status | Notes
 | 1 | Creation of System |  |  |  |  |  |  |  | Pending Approval
 | Session # | 9
 | 1 | Accreditation |  |  |  |  |  | Date from | Date Due | Status | Notes | 0
 |  |  |  |  |  |  |  |  |  | Pending Approval
 | Session # | 10
 | 1 | Accreditation |  |  |  |  |  | Date from | Date Due | Status | Notes | 0
 |  |  |  |  |  |  |  |  |  | Pending Approval
 | Session # | 11
 | 1 | Accreditation |  |  |  |  |  | Date from | Date Due | Status | Notes | 0
 |  |  |  |  |  |  |  |  |  | Pending Approval
 | Session # | 12
 | 1 | Accreditation |  |  |  |  |  | Date from | Date Due | Status | Notes | 0
 |  |  |  |  |  |  |  |  |  | Pending Approval
 | Session # | 13
 | 1 | Accreditation |  |  |  |  |  | Date from | Date Due | Status | Notes | 0
 |  |  |  |  |  |  |  |  |  | Pending Approval
 | Session # | 14
 | 1 | Accreditation |  |  |  |  |  | Date from | Date Due | Status | Notes | 0
 |  |  |  |  |  |  |  |  |  | Pending Approval
 | Session # | 15
 | 1 | Accreditation |  |  |  |  |  | Date from | Date Due | Status | Notes | 0
 |  |  |  |  |  |  |  |  |  | Pending Approval
Spreadsheet: 846951d1698076992-reorganizing-two-columns-to-have-comma-separated-values-be-transposed-instead-sample-to-organize-data
Sheet: Sheet1

Starting Point |  |  |  | Needed End Result
ABC-02 | BRQ-3,BRQ-1,BRQ-55 |  |  | ABC-02 | BRQ-3
ABC-03 | BRQ-2 |  |  | ABC-02 | BRQ-1
ABC-04 | [NAME], BRQ-11 |  |  | ABC-02 | BRQ-55
 |  |  |  | ABC-03 | BRQ-2
 |  |  |  | ABC-04 | [NAME]
 |  |  |  | ABC-04 | BRQ-11
Spreadsheet: 886572d1736612611-creating-a-master-sort-unique-list-from-other-sort-unique-lists-sort-unique
Sheet: Sheet1

Sheet1 | Sheet2 | Sheet3
 |  |  |  | Sort unique needed here to capture all unique entries from previous sort unique lists
2 | 2 | 2
3 | 3 | 3
4 | 4 | 4
5 | 5 | 5
6 | 6 | 6
0 | 7 | 7
 | 0 | 8
 |  | 0
Spreadsheet: 843271d1695166312-a-doosy-complex-logic-for-filtering-can-you-figure-it-out-copy-of-test-formulas
Sheet: Types

Instrument Type | Primary Application | 4 |  | Library Type
[NAME] | Band/Group |  |  | [NAME]
[NAME], Sub | Cinematic |  |  | EXS24
Brass | Orchestral |  |  | Halion
Drone | Sound Effect |  |  | Kontakt
Drums | Trailer |  |  | Massive
Ensemble |  |  |  | MNDALA
Guitar - General |  |  |  | Musio
Guitar - Acoustic |  |  |  | Opus (EastWest)
Guitar - Electric |  |  |  | Play (EastWest)
Harp |  |  |  | Sampletank
[NAME] |  |  |  | sforzando
Organ |  |  |  | SINE (Orchestral Tools)
Pad |  |  |  | SoundPaint
Percussion - Tuned |  |  |  | Spitfire Player
Percussion - Untuned |  |  |  | Spitfire Player LABS
Piano - General |  |  |  | [NAME] (VSL Vienna Symphonic Library)
[NAME] |  |  |  | UVI Workstation
Piano Toy |  |  |  | Vienna Instruments (VSL [NAME])
Piano Upright |  |  |  | VSTi
Sound Design |  |  |  | [NAME]
Sound Effect
Strings
Synth
Texture
Vocal
Woodwinds
Spreadsheet: 490396d1479841641-excel-formula-math-maximum-interest-rate-calculation-without-exceeding-limit-example
Sheet: Sheet1

 |  | 0.13133483 |  | What formula in C1 would caculate the interest rated needed to match the amount of interest in K3?
 |  |  |  | Yellow percentage is the answer but I have to plug and play to get it
 |  |  |  | The sum of the total interest accrued can not be more than |  |  |  |  |  | 9707
 |  | PMT | 1012
 | Balance | Interest | Payment
2016-11-30 00:00:00 | 36061.14
Spreadsheet: 16604f47-2aaf-4a41-b0f1-8957e06a3e91
Sheet: Sheet1

Date | Sport | Opponent | Time | Results
10/01/2011 | Rowing | Head of the Ohio (Pittsburgh, Pa.) | 12:00 AM | Results
10/15/2011 | Rowing | Head of the Kanawha (Charleston, W. Va.) | 12:00 AM | Results
10/29/2011 | Rowing | Head of the [NAME] (Philadelphia, Pa.) | 12:00 AM | Results
11/05/2011 | Rowing | Head of the Occoquan (Fairfax Station, Va.) | 12:00 AM | Results
11/12/2011 | Rowing | [NAME] (Pennsauken, N.J.) | 12:00 AM | Results
Spreadsheet: 85523d1285621746-vlookup-if-statement-example
Sheet: INSTALLED BY MONTH

Product | 2009-11-01 00:00:00 | 2009-12-01 00:00:00 | 2010-01-01 00:00:00 | 2010-02-01 00:00:00 | 2010-03-01 00:00:00 | 2010-04-01 00:00:00 | 2010-05-01 00:00:00 | 2010-06-01 00:00:00
Product 1 | 2 | 4 | 5 | 7 | 8 | 8 | 10 | 11
Product 2 | 1 | 1 | 1 | 2 | 2 | 2 | 2 | 2
Product 3 | 3 | 5 | 7 | 8 | 8 | 8 | 9 | 7
Product 4 | 2 | 4 | 5 | 7 | 8 | 8 | 10 | 11
Product 5 | 1 | 1 | 1 | 2 | 2 | 2 | 2 | 2
Product 6 | 3 | 5 | 7 | 8 | 8 | 8 | 9 | 7
Product 7 | 2 | 4 | 5 | 7 | 8 | 8 | 10 | 11
Product 8 | 1 | 1 | 1 | 2 | 2 | 2 | 2 | 2
Product 9 | 3 | 5 | 7 | 8 | 8 | 8 | 9 | 7
Product 10 | 2 | 4 | 5 | 7 | 8 | 8 | 10 | 11
Product 11 | 1 | 1 | 1 | 2 | 2 | 2 | 2 | 2
Product 12 | 3 | 5 | 7 | 8 | 8 | 8 | 9 | 7
Product 13 | 3 | 5 | 7 | 8 | 8 | 8 | 9 | 7
Spreadsheet: 2c1e4311-c163-41de-a205-ac7466c171dd
Sheet: Report

Unit | Unit Priority | [NAME] | Objective Id | Objective Name | Objective Priority | Strategic Direction | Impact Type
EDCT | 2 | Build awareness about EDCT's mission and program offerings among the District employees | 1.1 | Enhance District-wide dissemination of information regarding EDCT's mission, value and training programs | 2 | None | -- Pick One --
EDCT | 2 | Maximize the marketing and outreach efforts to build awareness in the external community | 2.1 | Market customized training and professional development programs to the community through various outreach efforts, community events, presentations at events and to the businesses | 2 | None | -- Pick One --
EDCT | 1 | Continue efforts to build partnership and leverage funding to sustain and widen the focus and scope of EDCT’s Green Technology job training programs | 3.1 | Obtain grants, sub-grants and contracts for offering green technology workforce training fitting to the regional industrial trends | 1 | None | -- Pick One --
EDCT | 1 | Seek out economic and workforce development grants in emerging technologies and high growth occupational areas to provide short-term job training for the workforce | 4.1 | Search and evaluate economic and workforce development grant opportunities in emerging technologies and apply for grants to provide short-term training for incumbent workers and displaced workers | 1 | None | -- Pick One --
EDCT | 1 | Optimize the entrepreneurial and innovative organizational capability of EDCT and maintain its self-supporting status. | 5.1 | Generate income through contracts, grants and sub-grantee contracts to support all the operational costs and staff salaries and benefits of EDCT | 1 | None | -- Pick One --
Spreadsheet: 278331d1384705980-two-similar-excel-sheets-comparison-and-data-filling-sample-file
Sheet: Second Sheet (Destination)

id | AEndLocation | ZEndLocation | CableSystem | ConnectionType | Bandwidth | Currency | MRC COST | NRC COST | MRC SALE | NRC SALE
7568 | Hong Kong | SGX | NA | Protected | 4Mb | USD | 0 | 0 | 0 | 0
408428 | Hong Kong | SGX | NA | Protected | 6Mb | USD | 0 | 0 | 0 | 0
75195 | Hong Kong | SGX | NA | Protected | 8Mb | USD | 0 | 0 | 0 | 0
374807 | Hong Kong | SGX | NA | Protected | 60Mb | USD | 0 | 0 | 0 | 0
19947 | Hong Kong | SGX | NA | Protected | 70Mb | USD | 0 | 0 | 0 | 0
480763 | Hong Kong | SGX | NA | Protected | 80Mb | USD | 0 | 0 | 0 | 0
104908 | Hong Kong | SGX | NA | Protected | 90Mb | USD | 0 | 0 | 0 | 0
63443 | Hong Kong | SGX | NA | Protected | 2Mb | USD | 0 | 0 | 0 | 0
75179 | Hong Kong | SGX | NA | Protected | 10Mb | USD | 0 | 0 | 0 | 0
64313 | Hong Kong | SGX | NA | Protected | 20Mb | USD | 0 | 0 | 0 | 0
363823 | Hong Kong | SGX | NA | Protected | 30Mb | USD | 0 | 0 | 0 | 0
322551 | Hong Kong | SGX | NA | Protected | 40Mb | USD | 0 | 0 | 0 | 0
461726 | Hong Kong | SGX | NA | Protected | 50Mb | USD | 0 | 0 | 0 | 0
-23284 | Hong Kong | SGX | NA | Protected | 100Mb | USD | 0 | 0 | 0 | 0
52163 | Tokyo | HKEX | NA | Protected | 600Mb | USD | 0 | 0 | 0 | 0
464024 | Tokyo | HKEX | NA | Unprotected | 450Mb | USD | 0 | 0 | 0 | 0
338484 | Tokyo | HKEX | NA | Unprotected | 300Mb | USD | 0 | 0 | 0 | 0
428584 | Tokyo | HKEX | NA | Unprotected | 150Mb | USD | 0 | 0 | 0 | 0
518684 | Tokyo | HKEX | NA | Unprotected | 150Mb | USD | 0 | 0 | 1 | 1
608784 | Hong Kong | SGX | NA | Unprotected | 40Mb | USD | 0 | 0 | 0 | 0
698884 | Hong Kong | SGX | NA | Unprotected | 50Mb | USD | 0 | 0 | 0 | 0
Spreadsheet: 870545d1717051053-list-up-the-sheet1-to-sheet2-depend-on-condition-list-pump-use-2-3-
Sheet: WORKER 1

 | payee : | worker 1
no | location | customer | Status | quantity |  |  | Sub TransferData()
 |  |  |  |  |  |  | Dim ws1 As Worksheet
 |  |  |  |  |  |  | Dim ws2 As Worksheet
 |  |  |  |  |  |  | Dim lastRow As Long
 |  |  |  |  |  |  | Dim i As Long
 |  |  |  |  |  |  | Dim targetRow As Long
 |  |  |  |  |  |  | ' Set references to Sheet1 and Sheet2
 |  |  |  |  |  |  | Set ws1 = ThisWorkbook.Sheets("Sheet1")
 |  |  |  |  |  |  | Set ws2 = ThisWorkbook.Sheets("Sheet2")
 |  |  |  |  |  |  | ' Find the last row in Sheet1 column D
 |  |  |  |  |  |  | lastRow = ws1.Cells(ws1.Rows.Count, "D").End(xlUp).Row
 |  |  |  |  |  |  | ' Loop through each row in Sheet1 column D
 |  |  |  |  |  |  | For i = 2 To lastRow ' Assuming data starts from row 2
 |  |  |  |  |  |  | ' Check if the value in column E of the current row is not empty
 |  |  |  |  |  |  | If [NAME], "E").Value <> "" Then
 |  |  |  |  |  |  | ' Determine the target row in Sheet2
 |  |  |  |  |  |  | targetRow = ws2.Cells(ws2.Rows.Count, "D").End(xlUp).Row + 1
 |  |  |  |  |  |  | ' Copy the value from Sheet1 column D to Sheet2 column D
 |  |  |  |  |  |  | ws2.Cells(targetRow, "D").Value = ws1.Cells(i, "D").Value
 |  |  |  |  |  |  | End If
 |  |  |  |  |  |  | Next i
 |  |  |  |  |  |  | ' Inform user that the transfer is complete
 |  |  |  |  |  |  | MsgBox "Data transfer completed successfully!", vbInformation
 |  |  |  |  |  |  | End Sub
 |  |  |  |  |  |  | Instructions for using the macro:
 |  |  |  |  |  |  | Press Alt + F11 to open the Visual Basic for Applications (VBA) editor.
 |  |  |  |  |  |  | Go to Insert > Module to insert a new module.
 |  |  |  |  |  |  | Copy and paste the above code into the module window.
 |  |  |  |  |  |  | Close the VBA editor.
 |  |  |  |  |  |  | Press Alt + F8, select TransferData, and click Run.
Spreadsheet: 680230d1590863891-index-match-with-3-criteria-index-match_match-type
Sheet: Sheet2

 |  | 2020-05-31 00:00:00 | 2020-04-30 00:00:00 | 2020-03-31 00:00:00 | 2020-02-29 00:00:00 | 2020-01-31 00:00:00
small | haha | 12 | 34 | 56 | 98 | 85
small | hehe | 78 | 89 | 910 | 54 | 52 |  | Area 1
small | hoho | 1112 | 1314 | 1516 | 321 | 63
big | haha | 1 | 2 | 3 | 4 | 5
big | hehe | 6 | 7 | 8 | 9 | 10 |  | Area 2
big | hoho | 11 | 12 | 13 | 14 | 15
big | hihi | 16 | 17 | 18 | 19 | 20
Less than |  | With 2 criteria |  | With 3 criteria
criteria 1 | hihi
criteria 2 | big
criteria 3 | 2020-03-30 00:00:00
Spreadsheet: 295804d1391803642-how-to-find-duplicates-in-a-big-database-file-duplicates_in_3_columns
Sheet: Blad1

a |  |  |  |  |  | z |  |  |  |  |  | 1 | 0 | 1
b |  |  | g |  |  | y |  |  |  |  |  | 2 | 1 | 1
c |  |  | h |  |  | x |  |  |  |  |  | 2 | 2 | 2
r |  |  | i |  |  | w |  |  |  |  |  | 1 | 1 | 1
e |  |  | j |  |  | q |  |  |  |  |  | 1 | 1 | 1
f |  |  | k |  |  |  |  |  |  |  |  | 1 | 1 | 0
 |  |  | l |  |  | d |  |  |  |  |  | 0 | 1 | 1
h |  |  | m |  |  |  |  |  |  |  |  | 2 | 1 | 0
s |  |  | n |  |  |  |  |  |  |  |  | 1 | 1 | 0
 |  |  | o |  |  | b |  |  |  |  |  | 0 | 1 | 2
 |  |  | p |  |  | v |  |  |  |  |  | 0 | 1 | 1
 |  |  |  |  |  | c |  |  |  |  |  | 0 | 0 | 2
 |  |  |  |  |  | x |  |  |  |  |  | 0 | 0 | 2
 |  |  |  |  |  |  |  |  |  |  |  | 0 | 0 | 0
 |  |  |  |  |  |  |  |  |  |  |  | 0 | 0 | 0
 |  |  |  |  |  |  |  |  |  |  |  | 0 | 0 | 0
 |  |  |  |  |  |  |  |  |  |  |  | 0 | 0 | 0
Spreadsheet: 860305d1708447685-counting-value-in-a-cell-if-a-cell-in-the-same-row-but-a-different-column-has-a-set-value-getting-help7
Sheet: Data

Staff member | Manager | Placement | Sap/Resi |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | F2F Trainings overdue | F2F Trainings never completed | F2F Training completed | F2F Training Outstanding | F2F RAG Rating | E-learning Trainings overdue | E-learning Trainings never completed | E-learning Trainings completed | E-learning trainings Outstanding | E-learning [NAME] rating |  | Fire Safety |  | First Aid |  | De-escalation |  | Ligature |  | ROSW |  | Team Teach |  | C-Card
 |  |  | SAP |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | Number of courses needed |  | Number of courses needed |  | Number of courses needed |  | Number of courses needed |  | Number of courses needed |  | Number of courses needed |  | Number of courses needed
 |  |  | SAP
 |  |  | SAP
 |  |  | SAP
 |  |  | SAP
 |  |  | SAP
 |  |  | SAP
 |  |  | SAP
 |  |  | SAP
 |  |  | SAP
 |  |  | SAP
 |  |  | SAP
 |  |  | SAP
 |  |  | SAP
 |  |  | SAP
 |  |  | SAP
 |  |  | SAP
 |  |  | SAP
 |  |  | SAP
 |  |  | RESI
 |  |  | RESI
 |  |  | RESI
 |  |  | RESI
 |  |  | RESI
 |  |  | RESI
 |  |  | RESI
 |  |  | RESI
 |  |  | RESI
 |  |  | RESI
 |  |  | RESI
 |  |  | RESI
 |  |  | RESI
 |  |  | RESI
 |  |  | RESI
 |  |  | SAP
 |  |  | SAP
 |  |  | SAP
 |  |  | SAP
 |  |  | SAP
 |  |  | SAP
 |  |  | SAP
 |  |  | SAP
 |  |  | SAP
 |  |  | SAP
 |  |  | SAP
 |  |  | SAP
 |  |  | SAP
 |  |  | SAP
 |  |  | RESI
F2F Training Completed | F2F Training Outstanding | E-Learning Training Completed | E-Learning Training Outstanding
Spreadsheet: 887977d1738291168-more-efficient-way-to-use-ifs-and-function-example1
Sheet: Sheet1

Date | ID # | Invoice # | Name | Status | Status2 | Status3
01/10/2025 | 44552 | 4478 | [NAME]
01/10/2026 | 25487 |  | [NAME]
01/10/2027 |  | 4458 | Janice
01/10/2028 | 12345 | 1000
01/10/2029 | 23456
01/10/2030 |  | 2000
01/10/2031 |  |  | [NAME]
Spreadsheet: 58271d1258554368-non-identical-lists-display-column-c-help-1-
Sheet: Sheet1

10925677 |  | 10925677 | 0.1345
10925680 |  | 10925680 | 4.0445
10925771 |  | 10925771 | 0.1808
10925800 |  | 10925800 | 0.0291
10925872 |  | 10925872 | 1.3552
10925903 |  | 10925903 | 0.3394
10925926 |  | 10925926 | 0.0152
10925927 |  | 10925951 | 0.3385
10925951 |  | 10926030 | 2.5867
10926030 |  | 10926043 | 0.2265
10926043 |  | 10926149 | 0.1328
Spreadsheet: richard_shapiro__32458__m010508c
Sheet: PGE

 |  |  |  | Annual | Current | Current | Revenue | New Total | New Rates
Rate Class | Rate | Rate Description | Description | Sales (GWh) | Rate (cents) | Revenue (MM) | Increase (MM) | Revenue | (cents/kWh) | Increase % |  | chk
Residential |  |  | E1 | 23367.450386 |  | 2815.65609 | 543.543773
Residential |  |  | EL1 | 1922.3954 |  | 168.120011 | 0
Residential |  |  | E7 | 1199.011059 |  | 121.348091 | 43.721831
Residential |  |  | EL7 | 13.845847 |  | 1.2624 | 0
Residential |  |  | E8 | 2248.111251 |  | 233.953813 | 110.272295
Residential |  |  | EL8 | 96.812372 |  | 7.83134 | 0
Commercial |  |  | A1 | 5906.390342 |  | 769.394109 | 264.987488
Commercial |  |  | A6 | 1973.440548 |  | 195.439149 | 88.537503
Commercial |  |  | A15 | 1.323696 |  | 0.391249 | 0.059387
Commercial |  |  | TC1 | 121.33413 |  | 14.583974 | 5.4436
Commercial |  |  | A10TP | 90.647376 |  | 9.387462 | 4.066853
Commercial |  |  | A10S | 12859.851253 |  | 1401.21743 | 576.951316
Commercial |  |  | E19T | 10.84827 |  | 1.024607 | 0.439792
Commercial |  |  | E19P | 783.953305 |  | 68.394225 | 31.781687
Commercial |  |  | E19S | 10174.449648 |  | 997.553147 | 412.475041
Industrial |  |  | E20T | 7042.130736 |  | 401.088127 | 285.489954
Industrial |  |  | E20P | 6260.946172 |  | 487.568292 | 253.820513
Industrial |  |  | E20S | 3187.593124 |  | 294.668774 | 129.225919
Other |  |  | Stby T | 129.286012 |  | 13.242587 | 5.241291
Other |  |  | Stby P | 29.728443 |  | 4.325888 | 1.205199
Other |  |  | Stby S | 7.352085 |  | 0.881168 | 0.298056
Other |  |  | Other - LS12, LS3, OL1, LS3 | 351.291855 |  | 46.482385 | 15.760548
Agriculture |  |  | AG1A | 179.726421 |  | 39.688226 | 5.953234
Agriculture |  |  | AG1B | 248.92628 |  | 42.927894 | 6.439184
Agriculture |  |  | AGRA | 28.756666 |  | 4.608306 | 0.921661
Agriculture |  |  | AGRB | 25.77279 |  | 3.884174 | 0.776835
Agriculture |  |  | AGVA | 31.177676 |  | 4.927064 | 0.985413
Agriculture |  |  | AGVB | 18.24191 |  | 2.598787 | 0.519757
Agriculture |  |  | AG4A | 136.212371 |  | 20.777026 | 4.155405
Agriculture |  |  | AG4B | 375.224737 |  | 52.111808 | 10.422362
Agriculture |  |  | AG4C | 37.452913 |  | 5.497716 | 1.099543
Agriculture |  |  | AG5A | 83.553832 |  | 10.319364 | 2.063873
Agriculture |  |  | AG5b | 2101.512648 |  | 205.198203 | 41.039641
Agriculture |  |  | AG5C | 156.315959 |  | 15.036344 | 3.007262
Commercial |  |  | ARTP - E19S | 46.126944 |  | 3.565206 | 1.869999
Industrial |  |  | ARTP - E20T | 3.48 |  | 0.259245 | 0.14108
Industrial |  |  | ARTP - E20S | 352.913796 |  | 28.991301 | 14.307224
Industrial |  |  | Special Contracts | 358.848 |  | 21.214926 | 14.547799
Industrial |  |  | Energy Sec | 28.534674 |  | 2.068144 | 1.156804
 |  |  | Total System
 |  |  |  | Annual | Current | Current | Revenue | New Total | New Rates
 |  |  | Description | Sales (GWh) | Rate (cents) | Revenue (MM) | Increase (MM) | Revenue | (cents/kWh) | Increase %
 |  |  | Residential
 |  |  | Commercial
 |  |  | Agricultural
 |  |  | Other
 |  |  | Industrial
 |  |  | Total
 |  |  | Core
 |  |  | Non-Core
 |  |  | Total
Spreadsheet: 127671d1320450197-index-count-sequence-unique-dates-based-on-values-in-another-column-daddy-weeks
Sheet: Sheet2

Product | Sell Date | Week of Campaign
Widget A | 2011-04-09 17:00:00
Widget A | 2011-04-16 17:00:00
Widget A | 2011-04-16 17:00:00
Widget A | 2011-04-16 17:00:00
Widget A | 2011-04-23 17:00:00
Widget A | 2011-04-30 17:00:00
Widget A | 2011-05-07 00:00:00
Widget B | 2011-04-09 17:00:00
Widget B | 2011-04-16 17:00:00
Widget B | 2011-04-16 17:00:00
Widget B | 2011-04-23 00:00:00
Widget B | 2011-04-30 00:00:00
Widget B | 2011-05-07 00:00:00
Widget B | 2011-05-14 00:00:00
Widget B | 2011-05-14 00:00:00
Widget C | 2011-04-30 00:00:00
Widget C | 2011-05-07 00:00:00
Widget C | 2011-05-07 00:00:00
Widget C | 2011-05-14 00:00:00
Spreadsheet: 864016d1711376728-sort-unique-from-multiple-columns-if-criteria-met-filter-mutiple-columns-based-on-criteria-6-aligw
Sheet: Sheet1

 |  | State | Color 1 | Color 2 | Color 3 | Color 4 |  | Colors if State selected |  | Colors (ALL) |  | Desired Outcome
 |  | GEORGIA | Red | Green |  |  |  |  |  | beige |  | Black
CALIFORNIA |  | GEORGIA | Yellow | Green |  | Gray |  | Black |  | Black |  | Gray
 |  | MARYLAND |  | [NAME] |  |  |  | blue |  | blue |  | Green
 |  | GEORGIA | Gray | Yellow |  | Black |  | blue violet |  | blue violet |  | Orange
 |  | FLORIDA |  | Maroon |  | Green |  | [NAME] |  | [NAME] |  | Red
 |  | GEORGIA | Orange | Red | White |  |  | crimson |  | crimson |  | White
 |  | OHIO | Blue | Gray | Yellow | Gray |  | [NAME] |  | [NAME] |  | Yellow
 |  |  |  |  |  |  |  | gold |  | gold
 |  |  |  |  |  |  |  | gray |  | gray
 |  |  |  |  |  |  |  | green |  | green
 |  |  |  |  |  |  |  | indigo |  | indigo
 |  |  |  |  |  |  |  | khaki |  | khaki
 |  |  |  |  |  |  |  | lavender |  | lavender
 |  |  |  |  |  |  |  | lime green |  | lime green
 |  |  |  |  |  |  |  | magenta |  | magenta
 |  |  |  |  |  |  |  | maroon |  | maroon
 |  |  |  |  |  |  |  | navy blue |  | navy blue
 |  |  |  |  |  |  |  | olive |  | olive
 |  |  |  |  |  |  |  | orange |  | orange
 |  |  |  |  |  |  |  | pink |  | pink
 |  |  |  |  |  |  |  | plum |  | plum
 |  |  |  |  |  |  |  | purple |  | purple
 |  |  |  |  |  |  |  | red |  | red
 |  |  |  |  |  |  |  | salmon |  | salmon
 |  |  |  |  |  |  |  | silver |  | silver
 |  |  |  |  |  |  |  | sky blue |  | sky blue
 |  |  |  |  |  |  |  | teal |  | teal
 |  |  |  |  |  |  |  | violet |  | violet
 |  |  |  |  |  |  |  | white |  | white
 |  |  |  |  |  |  |  | yellow |  | yellow
 |  |  |  |  |  |  |  | 0
Spreadsheet: 686928d1594877117-multiple-functions-in-one-cell-markbook-practice-ii-autosaved-
Sheet: VCAL

 |  |  | Learning Outcomes Summary |  |  |  | Self Expression |  |  |  |  |  |  |  |  |  | Knowledge |  |  |  |  |  |  |  |  |  | Public Debate |  |  |  |  |  |  |  |  |  | Practical Purposes
Name | Surname | Overall | Self Expression | Knowledge | Public Debate | Practical Purposes
[NAME] | ASPINALL
[NAME] | BAJIC
[NAME] | BEFEKADU
[NAME] | CHU SINGH
[NAME] | CHU SINGH
Indygo | COWTON
Lartia | CRAWFORD - EDWARDS
[NAME] | DENG
[NAME] | JARDINE
[NAME] | MATTSSON
Alyssa | MCDONOUGH
[NAME] | PERESE
Jake | RIPPON
[NAME] | SMITH
Russel | SMITH
Marlon | [NAME]
Atareta | TIMU