tianzl66/Sheetpedia huggingface dataset:
Spreadsheet: 160664d1339162179-dynamic-charts-help-setting-up-with-named-ranges-book1
Sheet: Sheet1

 |  |  | 2010 | 2010 | 2010 | 2010 | 2010 | 2010 | 2010 | 2010 | 2010 | 2010 | 2010 | 2010
 |  |  | 1 | 2 | 3 | 4 | 5 | 6 | 7 | 8 | 9 | 10 | 11 | 12
 |  | 1000 Series | 7763.5 | 8469.77 | 14815.32 | 11033.26 | 5095.31 | 15453.28 | 10837.89 | 13496.6 | 12830.25 | 10793.5 | 14062.41 | 3788.38
 |  | 2000 Series | 10092.09 | 5325.63 | 22213.71 | 21963.15 | 17151.68 | 9628.29 | 5899.38 | 14082.57 | 14850.55 | 9588.31 | 13304.52 | 3775.56
 |  | 3000 Series | 55873.29 | 62078.31 | 64356.14 | 63029.48 | 80443.55 | 83927.28 | 53788.17 | 78987.78 | 78974.75 | 71375.56 | 74311.65 | 48475.32
 |  | 4000 Series | 7913.15 | 15395.78 | 16422.78 | 9894.11 | 9978.63 | 6662.32 | 5602.92 | 17048.49 | 7927.92 | 5155.61 | 21520.2 | 3586.9
 |  | 5000 Series | 521.16 | 1108.98 | 746.38 | 1367.3 | 1764.27 | 350.64 | 841.5 | 1257.86 | 424.92 | 210.35 | 1380.11 | 191.29
 |  | 6000 Series | 4091.32 | 3364.03 | 4649.13 | 9092.19 | 3881.53 | 8939.77 | 2668.1 | 5458.63 | 8772.13 | 6326.73 | 6112.38 | 1361.8
 |  | 7000 Series | 14251.74 | 15246.56 | 18486.33 | 19455.33 | 14478 | 26037.78 | 19175.95 | 26168.59 | 29650.31 | 17966.23 | 23866.37 | 15728.87
 |  | 9000 Series | 3105.29 | 10053.25 | 6280.81 | 4243.49 | 16914.07 | 4463.59 | 3970.94 | 3268 | 11368.6 | 4175.57 | 16848.46 | 2684.15
 |  | A Series | 1198.03 | 923.14 | 2479.93 | 1869.04 | 3068.3 | 1404.73 | 2249.31 | 2343.26 | 749.7 | 1196.33 | 1258.6 | 1542.07
 |  | E Series | 1001.4 | 1371.32 | 1504.88 | 825.31 | 1492.36 | 1317.29 | 1701.54 | 584.25 | 521.25 | 1423.17 | 2117.41 | 144.64
 |  | G Series |  | 228.33 | 95.16 | 39.18 | 56.76 | 35.02 | 840.5 | 1010.06 | 395.33
 |  | J Series | 36.14 | 28.24 | 281.32 | 131.84 | 1453.73 | 119.9 |  | 85.23 | 39.02 | 144 | 45.72
 |  | W Series | 132.9 | 272.67 | 1227.66 | 329.2 | 633.82 | 245.72 | 91.76 | 334.3 | 393.56 | 915.27 | 614.87 | 118.3
 |  | N Series | 1090.55 | 2402.93 | 2600.24 | 2844.19 | 2537.91 | 2869.28 | 2588.98 | 4274.55 | 4329.64 | 5080.98 | 5025.16 | 325.28
 |  | S Series | 5458.65 | 3048.2 | 1882.55 | 3061.44 | 2758.47 | 3833.47 | 1706.46 | 12187.53 | 4916.46 | 1415.39 | 2662.92 | 484.94
 |  | U Series |  |  | 17.2 |  |  |  |  |  |  | 34.4
 |  | Miscellaneous Income | 3523.17 | 2853.21 | 6695.1 | 7851.87 | 4162.62 | 5827.62 | 3407.48 | 2316.94 | 4447.69 | 6658.86 | 6573.95 | 2276.32
Spreadsheet: 45123d1243894128-creating-a-list-of-selected-items-from-an-order-sheet-sample-order-form
Sheet: Order

Name:
Address:
Phone:
3 | Products Ordered
Entry # | UPC | PK | SIZE | ITEM | CASE PACK | Movement | Cost | Order
1 | 8265763111 | 1 | 700 ML | DEER PARK SPORTS  CAP | 28 | 20.45 | 7.99 | 2
2 | 8265755561 | 1 | 16.9 OZ. | DEER PARK SPRING WATER | 32 | 144.3 | 5.39 | 1
3 | 8265750562 | 1 | 1.5LTR | DEER PARK SPRING WATER | 12 | 8.2 | 8.75 | 3
4
5
6
7
8
9
10
Spreadsheet: 50468d1249924833-conditional-concatenation-conditional-concatenate
Sheet: Sheet1

 | INPUT DATA
 | Person | Date | Activity | Transferred by | Received by
 | Able | 1987-01-01 00:00:00 | Transfer from | Able Co
 |  |  | Transfer to |  | Bain Co
 | Able | 1992-01-03 00:00:00 | Transfer from | Able Co
 |  |  | Transfer to |  | [NAME]
 | [NAME] | 1987-01-03 00:00:00 | Transfer from | [NAME]
 |  |  | Transfer to |  | Smith Co
 | [NAME] | 1987-10-03 00:00:00 | Transfer from | [NAME]
 |  |  | Transfer to |  | [NAME]
DESIRED OUTPUT
From | Transfer Date | To
Able | 1/1/1987, 1/3/92 | Bain Co, [NAME]
[NAME] | 1/3/1987, 10/3/1987 | Smith Co, [NAME]
Spreadsheet: 215002d1361221331-sumproduct-statement-atlanta-rsa-survey-trends-130218
Sheet: Conyers, GA

 | 2012 Q1 | 2012 Q2 | 2012 Q3 | 2012 Q4 | 2013 Q1 | 2013 Q2 | 2013 Q3 | 2013 Q4 | Q1-Q2 Variance | Q2-Q3 Variance | Q3-Q4 Variance | Q4-Q1 Variance | Q1-Q2 Variance | Q2-Q3 Variance | Q3-Q4 Variance
Total Surveys Completed | 17 | 28 | 15 | 14 | 9
Overall Pharmacy Average | 4.029293822792275 | 3.906135514224157 | 3.980849851902483 | 4.157959000064264 | 3.937802840434419
Ease of ordering (e.g. fax, phone) process | 4.058823529411764 | 0 | 3.8 | 3.928571428571428 | 3.888888888888889
Medication accuracy (i.e. Right Drug/Right Patient)
Spreadsheet: 820496d1678129193-count-not-matching-filter-multipul-hazard-in-cell-copy
Sheet: Sheet1

 |  | No Loto | PPE | [NAME] | No/wrong fire extinguisher. | Wrong info on permit | Area not specified | Signiture not applied. | Test
 |  | No Permit Displayed | No Ventilation. | No Fire Watch | Poor Visibility | Coshh | Time not specified. | Weather/tempreture | test1 | polo
 |  | Unsafe practices | [NAME]. | Spills | Dust | No dates attached. | [NAME] not attached.
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | =SUMPRODUCT(SUBTOTAL(3,OFFSET(C8:E35,ROW(C8:E35)-MIN(ROW(C8:E35)),,1))+0)
Contractor | Permit Number | Hazards/none-compliance's/failures
emcore |  | No Loto |  |  |  |  | No Loto
emcore |  | No Loto, fire hazards, PPE |  |  |  |  | No Permit Displayed
emcore |  | [NAME] |  |  |  |  | Unsafe practices |  |  | =SUMPRODUCT(SUBTOTAL(3,OFFSET(B2:B18,ROW(B2:B18)-MIN(ROW(B2:B18)),,1)),ISNUMBER(SEARCH("Test",B2:B18))+0)
SPS |  | No Loto |  |  |  |  | [NAME]
SPS |  | PPE |  |  |  |  | No Fire Watch
SPS |  | Test |  |  |  |  | Spills
emcore |  | Test1 |  |  |  |  | Poor Visibility.
emcore |  | Test |  |  |  |  | No/wrong fire extinguisher.
 |  |  |  |  |  |  | [NAME].
 |  |  |  |  |  |  | Dust
 |  |  |  |  |  |  | PPE
 |  |  |  |  |  |  | Wrong info on permit.
 |  |  |  |  |  |  | COSHH
 |  |  |  |  |  |  | No Ventilation.
 |  |  |  |  |  |  | No dates attached.
 |  |  |  |  |  |  | Area not specified
 |  |  |  |  |  |  | Time not specified.
 |  |  |  |  |  |  | [NAME] not attached.
 |  |  |  |  |  |  | Signiture not applied.
Spreadsheet: 794314d1661974988-golf-trend-with-9-hole-and-18-hole-matches-golf-trend-sample
Sheet: Sheet1

 | 1 | 1 | 0.5 | 1 | 0.5 | 1 | 1 | 0.5 | 0.5 | 0.5 | 1 | 1 | 1
[NAME] | 8/1/2021 | 8/8/2021 | 8/15/2021 | 8/22/2021 | 8/29/2021 | 9/5/2021 | 9/12/2021 | 9/19/2021 | 9/26/2021 | 10/3/2021 | 10/10/2021 | 10/17/2021 | 10/24/2021 |  | Average | last 4 trend
1 | 82 | 85 | 38 |  | 38 |  | 89 | 41
2 | 77 | 75 | 41 | 82 |  | 86 | 88 | 45
3 |  |  | 40 | 82 |  |  | 88 |  | 45 | 42
4 | 85 |  | 44 |  | 39 |  | 78 |  | 43 |  | 75
Spreadsheet: 42e53d86-5179-42b5-9490-0c31faaf2cef
Sheet: Goal 5

 | Agency Name
 | Goal 5: Agencies increase their capacity to achieve results.
 | National Performance Indicator 5.1
 | Agency Development
 | The number of human capital resources available to |  |  |  |  | I.) Resources
 | Community Action that increase agency capacity to |  |  |  |  | in
 | achieve family and community outcomes, as measured |  |  |  |  | Agency
 | by one or more of the following:
 |  |  |  |  |  | (#)
5.1 A | A. Number of Certified Community Action Professionals
5.1 B | B. Number of Nationally Certified ROMA Trainers
5.1 C | C. Number of Family Development Certified Staff
5.1 D | D. Number of Child Development Certified Staff
5.1 E | E. Number of staff attending trainings
5.1 F | F. Number of board members attending trainings
5.1 G | G. Hours of staff in trainings
5.1 H | H. Hours of board members in trainings
 | In the rows below, please include any additional indicators that were not captured above. Please describe these measures in Goal 5 Notes.
5.1 new 1
5.1 new 2
5.1 new 3
 | Next
Spreadsheet: 853763d1703731936-combine-data-from-different-source-combine-1-
Sheet: Combine

Prod_Index | Age_Year | Pocket | Ctry | Code_TX
#1 | 2.1 | A | SG | AxD_7611 |  |  | 2.1 | A | SG | AxD_7611
#2 | 3.5 | A | CHN | AxD_7611 |  | #2 | 3.5 | A | CHN | AxD_7611
#3 | 3.9 | B |  | [NAME] |  | #3 | 3.9 | B |  | [NAME]
#4 | 1.5 | A |  | [NAME] |  | #4 | 1.5 | A |  | [NAME]
#5 |  | C | CHN |  |  | #5 |  | C | CHN
#6 |  | C | TW |  |  | #6 |  | C | TW
#7 |  | B | CHN |  |  | #7 |  | B | CHN
#8 | 8.3 | G |  | Gj_110 |  | #8 | 8.3 | G |  | Gj_110
Spreadsheet: 801719d1666339621-find-if-a-cell-has-a-value-then-return-left-most-with-text-book21
Sheet: Sheet1

 | [NAME] | Adam | Blake |  | [NAME] | Adam | Blake
Pilot | 8 |  | 2
Lawyer | 6 | 4
Teacher | 3 |  | 7
Sales |  | 5
Original Data |  |  |  |  | Desired result is above
Spreadsheet: 238879d1369749198-conditional-formatting-if-equal-or-greater-than-average-in-the-range-of-cells-performance-tracker_2013
Sheet: Progress Tracker

 |  |  |  |  |  |  |  |  |  |  | Overall Progress YTD, % |  |  |  |  |  |  |  | 74.21052631578948
 | Owner: |  |  | Target Met |  | On Schedule |  | Below Target |  |  |  |  |  |  |  |  |  |  |  |  | Plan Progress Criteria
 |  |  |  | STATUS by MONTHS |  |  |  |  |  |  |  |  |  |  |  | YTD |  |  | Average Progress % |  | Apr | May | Jun | Jul | Aug | Sep | Oct | Nov | Dec
 | Category | Indicator | TARGET | Jan | Feb | Mar | Apr | May | Jun | Jul | Aug | Sep | Oct | Nov | Dec |  | % |  |  |  | 20 | #N/A | #N/A | #N/A | #N/A | #N/A | #N/A | #N/A | #N/A
 |  | Such and such training is completed, % | 100 | 0 | 0 | 20 | 40 | 100 |  |  |  |  |  |  |  | 100 | 100 |  | 100 |  | 20 | 30 | 40 | 50 | 60 | 70 | 80 | 90 | 100
 |  | Such and such training 2 is completed, % | 100 | 26.7 | 26.7 | 28 | 30 |  |  |  |  |  |  |  |  | 30 | 30 |  | 30 |  | 20 | 30 | 40 | 50 | 60 | 70 | 80 | 90 | 100
 |  | Such and such training 3 is completed, % | 95 | 88 | 88 | 88 | 88 |  |  |  |  |  |  |  |  | 88 | 92.63157894736842 |  | 92.63157894736842 |  | 20 | 30 | 40 | 50 | 60 | 70 | 80 | 90 | 100
 |  |  |  | 8.333333333333334 | 16.66666666666667 | 25 | 33.33333333333334 | 41.66666666666667 | 50 | 58.33333333333334 | 66.66666666666667 | 75 | 83.33333333333334 | 91.66666666666667 | 100
Spreadsheet: 53729d1253642709-general-ledger-template-general-ledger-wilverley
Sheet: Budget codes

10
11
20
21
1001
1100
1103
1200
1210
1230
2100
4004
4005
4010
4015
4020
4025
4030
4035
4036
4037
4039
5009
6102
6105
6110
6111
6120
6121
6151
6155
7147
7150
7155
7160
7161
7162
7165
7170
7172
7175
7180
7185
7187
7190
7191
7193
7195
7200
7205
7210
7215
7220
7221
7225
7226
7227
7235
7237
7240
7252
7254
Spreadsheet: 169416d1342813654-every-certain-sum-i-want-to-reset-my-cells-need-equation-help
Sheet: Sheet1

Days | Send Out Date | Production
7 | 2012-07-07 00:00:00
7 | 2012-07-14 00:00:00
7 | 2012-07-21 00:00:00
10 | 2012-07-31 00:00:00
4 | 2012-08-04 00:00:00
7 | 2012-08-11 00:00:00
7 | 2012-08-18 00:00:00
7 | 2012-08-25 00:00:00
6 | 2012-08-31 00:00:00
6 | 2012-09-08 00:00:00
7 | 2012-09-15 00:00:00
7 | 2012-09-22 00:00:00
8 | 2012-09-30 00:00:00
6 | 2012-10-06 00:00:00
7 | 2012-10-13 00:00:00
7 | 2012-10-20 00:00:00
7 | 2012-10-27 00:00:00
4 | 2012-10-31 00:00:00
10 | 2012-11-10 00:00:00
7 | 2012-11-17 00:00:00
5 | 2012-11-24 00:00:00
6 | 2012-11-30 00:00:00
8 | 2012-12-08 00:00:00
7 | 2012-12-15 00:00:00
7 | 2012-12-22 00:00:00
6 | 2012-12-31 00:00:00
5 | 2013-01-05 00:00:00
7 | 2013-01-12 00:00:00
7 | 2013-01-19 00:00:00
7 | 2013-01-26 00:00:00
5 | 2013-01-31 00:00:00
9 | 2013-02-09 00:00:00
7 | 2013-02-16 00:00:00
7 | 2013-02-23 00:00:00
5 | 2013-02-28 00:00:00
9 | 2013-03-09 00:00:00
7 | 2013-03-16 00:00:00
7 | 2013-03-23 00:00:00
8 | 2013-03-31 00:00:00
6 | 2013-04-06 00:00:00
7 | 2013-04-13 00:00:00
7 | 2013-04-20 00:00:00
10 | 2013-04-30 00:00:00
11 | 2013-05-11 00:00:00
7 | 2013-05-18 00:00:00
7 | 2013-05-25 00:00:00
6 | 2013-05-31 00:00:00
Spreadsheet: 634199ca-0f1e-436c-b52d-2627d0925307
Sheet: Guidance

Report Information
Agency Name: | [Insert legal agency name] | Agency Number: | [[NAME] agency code]
 |  | Date Submitted: | [[NAME] date of SPR submission]
[NAME]: | [Leave blank] | OAG Reference Number and Receipt Date: | [Leave blank]
OAG Comments: | [Leave blank]
Agency Instructions:
The following guidance is provided to aid agencies with completing this report.
Report Guidance
* Provide a response for all sections of this report unless instructed otherwise in individual section(s). Some responses have been provided for you. Other standard responses may be posted as responses to questions as allowed by the RFQ are posted at www.OhioAttorneyGeneral.gov.    * Recommended and required attachments to accompany this report are indicated in each section, if applicable.  Please include attachments as separate files. Please name attachments according to the following naming convention: Attachment SPRSection# Descriptor – Agency Name (i.e., Attachment 3.1 Flow Chart – ABC Collection Co.)
Submission Guidance
• Agencies shall submit their OH SPR in Word format  on the template developed by the Ohio Attorney General's Office, adapted from Template v4.0 (9/27/2010) developed by the IRS Office of Safeguards.  The most current template is available at www.OhioAttorneyGeneral.gov/FTISP.  • The OH SPR must be accompanied by the agency's completed RFQ for the applicable fiscal year and submitted to: • Special Counsel: [EMAIL]  • Third Party Vendor: [EMAIL]  • Prior to submission, the agency’s SPR should be re-named as follows: Agency name FY14 Ohio SPR (i.e. ABC Collection Co. FY14 Ohio SPR) • Files must be sent encrypted via IRS approved encryption techniques using a secret password.  Encryption guidelines can be found at http://www.ohioattorneygeneral.gov/collectionsforms. The password must be sent by separate email to the appropriate submission email box (listed above). •Due to size limitations, submissions may require multiple emails. • Please enter your agency name into the Header.
• Please note that the Ohio Attorney General does not accept hard copy submissions. Responses received in hard copy or by facsimile or received after the Deadline will be considered nonresponsive.
A complete OH SPR must be submitted by the RFQ submission deadline.
For additional guidance as to when you must submit an OH SPR, review the FTISP Informational Packet at www.OhioAttorneyGeneral.gov/FTISP.
Spreadsheet: darrell_schoolcraft__7310__imball0201
Sheet: WTG inc

 | contract 21816
 | 10518 |  | 13276 |  | 13475 |  | 500176 |  | 500390 |  | 500612
 | WTX Gas Parmer |  | Fred Born #1 |  | WTX Water Systems |  | [NAME] |  | [NAME] |  | TW/WTG Hansford
Day | Measured | Scheduled | Measured | Scheduled | Measured | Scheduled | Measured | Scheduled | Measured | Scheduled | Measured | Scheduled
1 |  |  |  |  |  |  |  |  |  |  | -677 | -581
2 |  |  |  |  |  |  |  |  |  |  | -928 | -581
3 |  |  |  |  |  |  |  |  |  |  | -911 | -581
4 |  |  |  |  |  |  |  |  |  |  | -981 | -581
5 |  |  |  |  |  |  |  |  |  |  | -658 | -581
6 |  |  |  |  |  |  |  |  |  |  | -805 | -581
7 |  |  |  |  |  |  |  |  |  |  | -709 | -581
8 |  |  |  |  |  |  |  |  |  |  | -828 | -581
9 |  |  |  |  |  |  |  |  |  |  | -884 | -581
10 |  |  |  |  |  |  |  |  |  |  | -856 | -581
11 |  |  |  |  |  |  |  |  |  |  | -595 | -581
12 |  |  |  |  |  |  |  |  |  |  | -581 | -581
13 |  |  |  |  |  |  |  |  |  |  | -639 | -778
14 |  |  |  |  |  |  |  |  |  |  | -677 | -778
15 |  |  |  |  |  |  |  |  |  |  | -865 | -778
16 |  |  |  |  |  |  |  |  |  |  | -591 | -778
17 |  |  |  |  |  |  |  |  |  |  | -988 | -778
18 |  |  |  |  |  |  |  |  |  |  | -803 | -778
19 |  |  |  |  |  |  |  |  |  |  | -882 | -778
20 |  |  |  |  |  |  |  |  |  |  | -768 | -778
21 |  |  |  |  |  |  |  |  |  |  | -850 | -778
22 |  |  |  |  |  |  |  |  |  |  | -1060 | -778
23 |  |  |  |  |  |  |  |  |  |  | -1040 | -1765
24 |  |  |  |  |  |  |  |  |  |  | -3584 | -1778
25 |  |  |  |  |  |  |  |  |  |  | -185 | -1778
26 |  |  |  |  |  |  |  |  |  |  | -700 | -1778
27
28
29
30
31
2001-12-31 00:00:00 |  |  |  |  |  |  |  |  |  |  |  |  | 31688.49
2002-01-26 00:00:00
CBS Volume
 |  |  | 11681
Spreadsheet: 841326d1693506154-how-to-find-the-highest-score-and-return-name-of-the-player-scoresheetnonames-1-
Sheet: ScoreCard

 | Europe |  |  |  |  |  | USA |  |  |  |  |  | Player 1 | Player 2 | Player 3 | Player 4
 |  |  |  |  |  |  |  |  |  |  |  | Best Score |  | USAPlayer17
Group | Player 1 | Player 1 Points | Player 2 | Player 2 Points |  | Group | Player 1 | Player 1 Points | Player 2 | Player 2 Points |  | 2nd Best Score | USAPlayer4
1 | EPlayer1 | 21 | EPlayer15 | 25 |  | 1 | USAPlayer1 | 27 | USAPlayer15 | 26 |  | 3rd Best Score | EPlayer21 | USAPlayer6
2 | EPlayer2 | 26 | EPlayer16 | 25 |  | 2 | USAPlayer2 | 21 | USAPlayer16 | 25 |  | 4th Best Score | EPlayer3 | EPlayer4
3 | EPlayer3 | 31 | EPlayer17 | 22 |  | 3 | USAPlayer3 | 30 | USAPlayer17 | 39
4 | EPlayer4 | 31 | EPlayer18 | 26 |  | 4 | USAPlayer4 | 37 | USAPlayer18 | 22
5 | EPlayer5 | 39 | EPlayer19 | 8 |  | 5 | USAPlayer5 | 25 | USAPlayer19 | 30
6 | EPlayer6 | 26 | EPlayer20 | 21 |  | 6 | USAPlayer6 | 32 | USAPlayer20 | 21
7 | EPlayer7 | 30 | EPlayer21 | 32 |  | 7 | USAPlayer7 | 22 | USAPlayer21 | 25
8 | EPlayer8 |  | EPlayer22 |  |  | 8 | USAPlayer8 |  | USAPlayer22
9 | EPlayer9 |  | EPlayer23 |  |  | 9 | USAPlayer9 |  | USAPlayer23
10 | EPlayer10 |  | EPlayer24 |  |  | 10 | USAPlayer10 |  | USAPlayer24
11 | EPlayer11 |  | EPlayer25 |  |  | 11 | USAPlayer11 |  | USAPlayer25
12 | EPlayer12 |  | EPlayer26 |  |  | 12 | USAPlayer12 |  | USAPlayer26
13 | EPlayer13 |  | EPlayer27 |  |  | 13 | USAPlayer13 |  | USAPlayer27
14 | EPlayer14 |  | EPlayer28 |  |  | 14 | USAPlayer14 |  | USAPlayer28
Total Team Points |  |  |  |  |  | Total Team Points
Spreadsheet: 748366d1632128105-expected-outcome-based-on-3-criteria-sample-workbook_1-ans
Sheet: Sheet1

[NAME] |  |  |  |  | All
 |  |  |  |  |  | All |  | Criteria | 1 | Cell A1 Sheet1
 |  |  |  |  |  | ABC |  |  | 2 | Cell F1 Sheet1
 |  |  |  |  |  | DEF |  |  | 3 | Column D Sheet2 as "Yes"
Expected Outcome |  |  |  |  |  | GHI |  |  |  |  |  |  | Expected Outcome
Category | Activity Name | Team Member | Due(Yes/No) |  |  | JKL |  |  |  |  |  |  | Category | Activity Name | Team Member | Due(Yes/No)
 |  |  |  |  |  | MNO |  |  |  |  |  |  | B | DEF | [NAME] | Yes
 |  |  |  |  |  | PQR |  |  |  |  |  |  | G | DEF | Keshav | Yes
Spreadsheet: 43775d1242388420-using-dcount-and-date-based-criteria-example
Sheet: Sheet3

ID | Date Opened | Job Status
 |  | Open |  |  | This works
 |  | Pending
ID | Date Opened | Job Status
 | <=TODAY()-30 | Open |  |  | This does not
 | <=TODAY()-30 | Pending
ID | Date Opened | Job Status
 | <=(15/05/09)-30 | Open |  |  | Neither does this
 | <=(15/05/09)-30 | Pending
Spreadsheet: 163875c2-1aa6-4acf-b9e8-22266ffe6262
Sheet: Sheet1

Unnamed: 0 | Unnamed: 1 | Unnamed: 2 | Unnamed: 3 | Unnamed: 4 | Unnamed: 5 | Unnamed: 6
 |  | Central | IBC | NEPA | Highmark | Totals
 | ADAMS | 176 |  |  |  | 176
 | ALLEGHENY |  |  |  | 4570 | 4570
 | ARMSTRONG |  |  |  | 425 | 425
 | BEAVER |  |  |  | 804 | 804
 | BEDFORD |  |  |  | 325 | 325
 | BERKS | 1012 |  |  |  | 1012
 | BLAIR |  |  |  | 649 | 649
 | BRADFORD |  |  | 177 |  | 177
 | BUCKS |  | 1611 |  |  | 1611
 | BUTLER |  |  |  | 802 | 802
 | CAMBRIA |  |  |  | 1192 | 1192
 | CAMERON |  |  |  | 48 | 48
 | CARBON |  |  | 207 |  | 207
 | CENTRE | 302 |  |  | 122 | 424
 | CHESTER |  | 843 |  |  | 843
 | CLARION |  |  |  | 220 | 220
 | CLEARFIELD |  |  |  | 755 | 755
 | CLINTON |  |  | 135 |  | 135
 | COLUMBIA | 181 |  |  |  | 181
 | CRAWFORD |  |  |  | 507 | 507
 | CUMBERLAND | 360 |  |  |  | 360
 | DAUPHIN | 507 |  |  |  | 507
 | DELAWARE |  | 1806 |  |  | 1806
 | ELK |  |  |  | 314 | 314
 | ERIE |  |  |  | 1922 | 1922
 | FAYETTE |  |  |  | 961 | 961
 | FOREST |  |  |  | 30 | 30
 | FRANKLIN | 325 |  |  |  | 325
 | FULTON | 48 |  |  |  | 48
 | GREENE |  |  |  | 278 | 278
 | HUNTINGDON |  |  |  | 285 | 285
 | INDIANA |  |  |  | 577 | 577
 | JEFFERSON |  |  |  | 322 | 322
 | JUNIATA | 78 |  |  |  | 78
 | [NAME] |  |  | 472 |  | 472
 | LANCASTER | 770 |  |  |  | 770
 | [NAME] |  |  |  | 539 | 539
 | LEBANON | 188 |  |  |  | 188
 | LEHIGH | 718 |  |  |  | 718
 | LUZERNE |  |  | 755 |  | 755
 | LYCOMING |  |  | 199 |  | 199
 | MCKEAN |  |  |  | 240 | 240
 | MERCER |  |  |  | 567 | 567
 | MIFFLIN | 198 |  |  |  | 198
 | MONROE |  |  | 392 |  | 392
 | MONTGOMERY |  | 2081 |  |  | 2081
 | MONTOUR | 22 |  |  |  | 22
 | NORTHAMPTON | 488 |  |  |  | 488
 | NORTHUMBERLAND | 289 |  |  |  | 289
 | PERRY | 131 |  |  |  | 131
 | PHILADELPHIA |  | 7637 |  |  | 7637
 | PIKE |  |  | 138 |  | 138
 | POTTER |  |  |  | 161 | 161
 | SCHUYLKILL | 350 |  |  |  | 350
 | SNYDER | 86 |  |  |  | 86
 | [NAME] |  |  |  | 621 | 621
 | SULLIVAN |  |  | 26 |  | 26
 | SUSQUEHANNA |  |  | 201 |  | 201
 | TIOGA |  |  | 158 |  | 158
 | UNION | 81 |  |  |  | 81
 | VENANGO |  |  |  | 331 | 331
 | WARREN |  |  |  | 235 | 235
 | WASHINGTON |  |  |  | 905 | 905
 | WAYNE |  |  | 140 |  | 140
 | WESTMORELAND |  |  |  | 2059 | 2059
 | WYOMING |  |  | 69 |  | 69
 | YORK | 619 |  |  |  | 619
 | Totals | 6929 | 13978 | 3069 | 20766 | 44742
Spreadsheet: 139302d1328181260-lookup-vertically-maybe-example
Sheet: Sheet1

Username | Location | White | Yellow | Green |  | result
username.1 | 1001 |  | x |  |  | username.1;1001;Yellow
username.2 | 1002 | x |  | x |  | username.2;1002;Green
Username.3 | 1001 | x | x | x |  | Username.3;1001;Green
Username.4 | 1001 |  | x
Spreadsheet: 789713d1659320821-ratio-to-staff-calculator-ratio-calc-copy-hd
Sheet: Sheet1

 |  |  |  | [NAME]'s ratio to staff calcuator
 |  |  |  | Ratio
 |  |  |  | 1:1 | 1:2 | 1:3 | 1:4
 |  |  |  | 0 | 1 | 2 | 3
 |  |  | Total
 |  |  | Total
 |  |  | Total staff
 |  |  | Total + IC
 |  |  | Nursing hours (8hrs)
 |  |  | Nursing night (10hrs)
 |  |  | Total no of pt
Spreadsheet: 550637d1512474465-aligning-new-cells-based-on-existing-values-example-document
Sheet: list with emails

[NAME] | First Name | Last Name | Account name | Address 1 | Address 2 | Town/City | County | Postcode
[EMAIL] | [NAME] | Cove |  | Test 1 | Test 2 | Test Town | Test County | Test Postcode
[EMAIL] | [NAME] | [NAME] |  | Test 1 | Test 2 | Test Town | Test County | Test Postcode
[EMAIL] | [NAME] | Waters |  | Test 1 | Test 2 | Test Town | Test County | Test Postcode
[EMAIL] | [NAME] | Wheeler |  | Test 1 | Test 2 | Test Town | Test County | Test Postcode
[EMAIL] | Kanchel | White |  | Test 1 | Test 2 | Test Town | Test County | Test Postcode
[EMAIL] | Lukasz | Zemanek |  | Test 1 | Test 2 | Test Town | Test County | Test Postcode
Spreadsheet: 857261d1706281218-help-with-calculation-of-dividends-dividend-calculation-example
Sheet: Prio 1

Total proceeds | 100 | 200 | 400 |  |  | Shares | Options
Fully-diluted share price
Shares |  |  |  |  | Shareholder A | 80 | 40
Share dividend per share |  |  |  |  | Shareholder B | 20 | 60
Share dividend
Options
Option Strike Price | 1 | 1 | 1
Option dividend per option
Option dividend
Shareholder A Total Proceeds
Shares proceeds
Options proceeds
Shareholder B Total Proceeds
Shares proceeds
Options proceeds
Spreadsheet: 847198d1698241502-sum-of-specific-numbers-excelhelpupdated
Sheet: Sheet1

Starting point |  |  |  |  |  | Needed end result
name | level | number | date |  |  | level 1 to 2 | level 1 to 3 | level 2 to 2 (stays the same level)
A | 1 | 55 | 2000-01-31 00:00:00 |  |  |  |  |  |  | I need sum of all the numbers that meet each above criteria
B | 1 | 150 | 2000-01-31 00:00:00
C | 2 | 70 | 2000-01-31 00:00:00
D | 1 | 200 | 2000-01-31 00:00:00
E | 1 | 500 | 2000-01-31 00:00:00
A | 2 | 50 | 2000-02-28 00:00:00
B | 3 | 140 | 2000-02-28 00:00:00
C | 2 | 60 | 2000-02-28 00:00:00
D | 2 | 190 | 2000-02-28 00:00:00
E | 3 | 350 | 2000-02-28 00:00:00
Spreadsheet: 777226d1650267545-date-formatting-issue-error-indates-formula2-aligw
Sheet: Sheet1

date
13/04/2022 05:10:40
13/04/2022 05:11:52
13/04/2022 05:15:09
13/04/2022 [NAME]
13/04/2022 05:18:04
13/04/2022 05:19:24
13/04/2022 05:24:29
13/04/2022 05:25:50
13/04/2022 05:48:01
13/04/2022 05:52:46
13/04/2022 06:12:27
13/04/2022 06:26:01
13/04/2022 06:26:26
13/04/2022 06:27:07
13/04/2022 [NAME]
13/04/2022 06:48:39
13/04/2022 06:51:25
13/04/2022 06:53:25
13/04/2022 07:01:00
13/04/2022 07:38:43
13/04/2022 08:23:11
13/04/2022 08:24:38
13/04/2022 08:25:11
13/04/2022 08:35:21
13/04/2022 [NAME]
13/04/2022 08:48:43
13/04/2022 09:02:37
13/04/2022 09:03:20
2022-01-04 00:05:15
2022-01-04 00:09:14
2022-01-04 00:09:21