tianzl66/Sheetpedia huggingface dataset:
Spreadsheet: 668675d1584974393-conditional-format-a-row-where-multiple-dates-have-expired-and-email-notifcations-r01-operative-matrix-forum-post
Sheet: Personel Matrix

 |  |  |  | Last update |  |  |  |  |  |  |  |  |  |  | List - >
[NAME] MATRIX
Ref | First Name | Last Name |  | Status | D.O.B | Address | Post Code | [NAME] | Mobile No. | Home No. | Emg. Contact Name | Emg. Contact No.
OM-001 | [NAME] | Tebbutt |  | Active |  |  |  |  |  |  |  |  |  |  |  | Active
OM-002 | [NAME] | Appleton |  | Active |  |  |  |  |  |  |  |  |  |  |  | Suspended
OM-003 | [NAME] | Dillon |  | Active |  |  |  |  |  |  |  |  |  |  |  | Pending
OM-004 | [NAME] | Lovel |  | Active |  |  |  |  |  |  |  |  |  |  |  | Removed
OM-005 | [NAME] | Meade |  | Active
OM-006 | [NAME] | Seal |  | Active
OM-007 | [NAME] | Lilly |  | Pending
OM-008 | Ricky | [NAME] |  | Active
OM-009 | [NAME] | Dillon |  | Active
OM-010 | [NAME] | Saunders |  | Active
OM-011 | [NAME] | [NAME] |  | Active
OM-012 | [NAME] | Iandolo |  | Active
OM-013
OM-014
OM-015
OM-016
OM-017
OM-018
OM-019
OM-020
OM-021
OM-022
OM-023
OM-024
OM-025
OM-026
OM-027
OM-028
OM-029
OM-030
OM-031
OM-032
OM-033
OM-034
OM-035
OM-036
OM-037
OM-038
OM-039
OM-040
OM-041
OM-042
OM-043
OM-044
OM-045
OM-046
OM-047
OM-048
OM-049
OM-050
OM-051
OM-052
OM-053
OM-054
OM-055
OM-056
OM-057
OM-058
OM-059
OM-060
OM-061
OM-062
OM-063
OM-064
OM-065
OM-066
OM-067
OM-068
OM-069
OM-070
OM-071
OM-072
OM-073
OM-074
OM-075
OM-076
OM-077
OM-078
OM-079
[NAME]
OM-081
OM-082
OM-083
OM-084
OM-085
OM-086
OM-087
OM-088
OM-089
OM-090
OM-091
OM-092
OM-093
OM-094
OM-095
OM-096
OM-097
OM-098
OM-099
OM-100
OM-101
OM-102
OM-103
OM-104
OM-105
OM-106
OM-107
OM-108
OM-109
OM-110
OM-111
OM-112
OM-113
OM-114
OM-115
OM-116
OM-117
OM-118
OM-119
OM-120
OM-121
OM-122
OM-123
OM-124
OM-125
OM-126
OM-127
OM-128
OM-129
OM-130
OM-131
OM-132
OM-133
OM-134
OM-135
OM-136
OM-137
OM-138
OM-139
OM-140
OM-141
OM-142
OM-143
OM-144
OM-145
OM-146
OM-147
OM-148
OM-149
OM-150
OM-151
OM-152
OM-153
OM-154
OM-155
OM-156
OM-157
OM-158
OM-159
OM-160
OM-161
OM-162
OM-163
OM-164
OM-165
OM-166
OM-167
OM-168
OM-169
OM-170
OM-171
OM-172
OM-173
OM-174
OM-175
OM-176
OM-177
OM-178
OM-179
OM-180
OM-181
OM-182
OM-183
OM-184
OM-185
OM-186
OM-187
OM-188
OM-189
OM-190
OM-191
OM-192
OM-193
OM-194
OM-195
OM-196
OM-197
OM-198
OM-199
OM-200
OM-201
OM-202
OM-203
OM-204
OM-205
OM-206
OM-207
OM-208
OM-209
OM-210
OM-211
OM-212
OM-213
OM-214
OM-215
OM-216
OM-217
OM-218
OM-219
OM-220
OM-221
OM-222
OM-223
OM-224
OM-225
OM-226
[NAME]
OM-228
OM-229
OM-230
OM-231
OM-232
OM-233
OM-234
OM-235
OM-236
OM-237
OM-238
OM-239
OM-240
OM-241
OM-242
OM-243
OM-244
OM-245
[NAME]
OM-247
OM-248
OM-249
OM-250
OM-251
OM-252
OM-253
OM-254
OM-255
OM-256
OM-257
OM-258
OM-259
OM-260
OM-261
OM-262
OM-263
OM-264
OM-265
OM-266
OM-267
OM-268
OM-269
OM-270
OM-271
OM-272
OM-273
OM-274
OM-275
OM-276
OM-277
OM-278
OM-279
OM-280
Spreadsheet: 122932d1317244243-automatically-getting-the-comment-box-to-appear-when-data-is-entered-temp
Sheet: December

Monday |  | Tuesday |  | Wednesday |  | Thursday |  | Friday |  | Saturday |  | Sunday
23 |  | 29 |  | 30 |  | 1 |  | 2 |  | 3 |  | 4
5 |  | 6 |  | 7 |  | 8 |  | 9 |  | 10 |  | 11
12 |  | 13 |  | 14 |  | 15 |  | 16 |  | 17 |  | 18
19 |  | 20 |  | 21 |  | 22 |  | 23 |  | 24 |  | 25
26 | Christmas Day | 27 |  | 28 |  | 29 |  | 30 |  | 31 |  | 1
Spreadsheet: vkaminski__40900__CASH_GasMat_0400MyCopy
Sheet: Ref3

[NAME]
 |  |  |  |  |  |  | Person(s)
 |  | Current |  |  |  | Date Of | Responsible
Assumption Category | Assumption Description | Assumption |  |  | Assumption Reference | Reference | For Assumption | Comments
 | Base Year
 |  |  |  |  | EPE/SCC - EPC Contract | 1997-08-22 00:00:00 | [NAME] | Exhibit C-1
 |  |  |  |  | Monthly Progress Report | 1999-02-18 00:00:00 | [NAME] | Pipeline Cost Summary (Section E)
 |  |  |  |  | EPC Contract Issues | 1999-09-04 00:00:00 | [NAME]Alan Smithe | Update New Change Orders
 |  |  |  |  | [NAME] | 1999-05-17 00:00:00 | [NAME] | Budget Review - 05/18/99
 |  |  |  |  | EPE/SCC - EPC Contract | 1997-08-22 00:00:00 | [NAME] | Exhibit C-2 Section II, Paragraph C
 |  |  |  |  | [NAME] | 1999-05-14 00:00:00 | [NAME] | Budget Review - 05/14/99
 |  |  |  |  | [NAME] | 1999-05-14 00:00:00 | [NAME] | Budget Review - 05/14/99
 |  |  |  |  | [NAME] | 1999-05-18 00:00:00 | [NAME] | Budget Review - 05/18/99
 |  |  |  |  | [NAME] | 1999-05-14 00:00:00 | [NAME] | Budget Review - 05/14/99
 |  |  |  |  | [NAME] | 1999-05-14 00:00:00 | [NAME] | Budget Review - 05/14/99
 |  |  |  |  | [NAME] | 1999-08-31 00:00:00 | [NAME] | Budget Review - 08/31/99
 |  |  |  |  | [NAME] | 1999-08-18 00:00:00 | [NAME] | Update Indigenous People Details
 |  |  |  |  | Calculation
 |  |  |  |  | Calculation
 |  |  |  |  | Calculation
 |  |  |  |  | Calculation
 |  |  |  |  | [NAME] | 1999-05-18 00:00:00 | [NAME] | Budget Review - 05/18/99
 |  |  |  |  | [NAME] | 1999-05-18 00:00:00 | [NAME] | Budget Review - 05/18/99
 |  |  |  |  | [NAME] | 1999-08-31 00:00:00 | [NAME] | Budget Review - 08/31/99
 |  |  |  |  | [NAME] | 1998-12-28 00:00:00 | [NAME] | Premium $875K, Taxes $178K
 |  |  |  |  | [NAME] | 1999-08-31 00:00:00 | [NAME] | Budget Review - 08/31/99
 |  |  |  |  |  |  |  | No Development Fee On Project
 |  |  |  |  | [NAME] | 1999-05-14 00:00:00 | [NAME] | Budget Review - 05/14/99
 |  |  |  |  | Standard Calculation
 |  |  |  |  | Calculation
 |  |  |  |  | Calculation
 |  |  |  |  | Share Purchase Agreement | Dual Dates | [NAME] | Balance Of Remaining Shares
 |  |  |  |  | Share Purchase Agreement | 1998-06-04 00:00:00 | [NAME] | Enron/Shell Share Transfer - 1st Paragraph
 |  |  |  |  | Share Purchase Agreement | 1998-10-02 00:00:00 | [NAME] | Enron/Transrd Share Transfer - 1st Paragraph
Project & Enron Economics |  |  |  |  | Per [NAME] 6/18/97 | 1998-05-01 00:00:00 | RAROC / RADR
 |  | IRR | NPV
 | Project Returns |  |  |  | Calculation | 1997-06-09 00:00:00
 | Enron Returns |  |  |  | Calculation | 1997-06-09 00:00:00
Spreadsheet: 702233d1604190001-minimum-route-using-solver-example-route-optimizer
Sheet: Base

Car | Origin | Destination | Km
A | 1 | 2 | 35.6
A | 1 | 3 | 2.2
A | 1 | 4 | 22.3
A | 2 | 1 | 33.9
A | 2 | 3 | 32.4
A | 2 | 4 | 13.8
A | 3 | 1 | 1.7
A | 3 | 2 | 33.4
A | 3 | 4 | 20.1
A | 4 | 1 | 21.5
A | 4 | 2 | 14.6
A | 4 | 3 | 20
B | 1 | 2 | 35.6
B | 1 | 3 | 22.3
B | 2 | 1 | 33.9
B | 2 | 3 | 13.8
B | 3 | 1 | 21.5
B | 3 | 2 | 14.6
C | 1 | 2 | 9.4
C | 1 | 3 | 51.7
C | 2 | 1 | 10.4
C | 2 | 3 | 42.3
C | 3 | 1 | 52.1
C | 3 | 2 | 42.9
Spreadsheet: 777076d1650123502-pull-data-from-multiple-sheets-floor-stock-sheets-template
Sheet: ER 2003475

ER Trauma 2003475 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | Total | Service Units
Item | Price | Tue | Wed | Thu | Fri | Sat | Sun | Mon | Tue | Wed | Thu | Fri | Sat | Sun | Mon | Tue | Wed | Thu | Fri | Sat | Sun | Mon | Tue | Wed | Thu | Fri | Sat | Sun | Mon | Tue | Wed | Thu
Lemon Lime- Soda | 0.25
Diet Lemon Lime- Soda | 0.25
Cola- Soda | 0.25
Diet Cola- Soda | 0.25
Bottled Tea | 0.86
Crackers, [NAME] | 0.08
[NAME] ea | 0.05
[NAME] | 0.28
[NAME] | 1.13
Pudding-Vanilla | 0.27
Diet Vanilla Pudding | 0.28
Applesauce | 0.32
Juice Orange | 0.23
Juice Apple | 0.23
[NAME] | 0.16
Popsicles | 0.2
[NAME] | 0.25
Milk- Skim | 0.25
2% Milk | 0.25
Coffee, 2.2 LTR
Coffee, Decaf 2.2 LTR | 41.95
Sugar | 0.02
Sweetner-Equal | 0.03
Sweetner-Sweet N Low | 0.02
Sweetner-Splenda | 0.03
[NAME] | 2.5
Bottled Water | 0.13
Plastic Ware (fork,spoon knife) | 0.03
Plates | 0.03
[NAME] | 0.13
[NAME] | 0.11
Ensure | 0.13
Glucerna | 0.4
Nepro | 1.03
Pulmocare | 0.44
Jevity | 0.35
Vital | 3.05
[NAME] | 0.1
[NAME] | 0.1
Refrigerator Thermometer (reg.)
Monthly coffee
Monthly Total
Spreadsheet: 89b7979b-314a-46e4-8605-418c4c010906
Sheet: Sheet1

Unnamed: 0 | Team | Wins | Loss | Tie | PCT | GB | Gaveup | Runs
1 | Hustlers | 10 | 0 | 0 | 1 | --- | 115 | 220
2 | Master [NAME] | 7 | 3 | 0 | 0.7 | 3 | 115 | 173
3 | White Shirts | 6 | 4 | 0 | 0.6 | 4 | 126 | 150
4 | Deadwoods | 6 | 4 | 0 | 0.6 | 4 | 146 | 130
5 | Non Typicals | 6 | 4 | 0 | 0.6 | 4 | 149 | 172
6 | Triple Shots | 3 | 7 | 0 | 0.3 | 7 | 171 | 174
7 | Gone Postal | 2 | 8 | 0 | 0.2 | 8 | 180 | 93
8 | Punishment Softball | 0 | 10 | 0 | 0 | 10 | 191 | 81
Spreadsheet: 3c61519a-6572-4ce0-b8af-f179f3b13573
Sheet: Sheet1

Suggested Timeline for CME Joint Sponsorship Courses | Unnamed: 1 | Unnamed: 2 | Unnamed: 3 | Unnamed: 4
Task | Chronological Timeline | Task Assignee | Due Date | Date Completed
Identify Professional Practice Gaps | 12 Months | Course Director
Identify Intended Program Outcomes | 12 Months | Course Director
Identify Target Audience | 12 Months | Course Director
Contact CME Department to request CME sponsorship | 12 Months | Course Director
Review Joint Sponsorship Documents | 12 Months | Course Director
Assess whether to move forward with CME Joint Sponsorship request | 12 Months | Course Director
Review "What You Need to Know" Planning Document & CME Application | 12 Months | Course Director
Select Planning Committee | 12 Months | Course Director
Select Date | 12 Months | Course Director
Select Location | 12 Months | Course Director
Submit Completed Application to CME | 12 Months | Course Director
Select Specific Topics/Draft Agenda | 9-12 months | Course Director/Committee
Invite Speakers | 9-12 Months | Course Director
Send Speaker Packets | 9-12 Months | Course Director/Support Staff
Create Draft Budget | 6-12 Months | Course Director
Apply for Pharmaceutical Grants | 6-8 Months | CME
Invite Vendors to Display | 6-8 Months | Course Director/Support Staff
Review Speaker COI Forms/Submit to CME | 6-8 Months | Course Director/CME
[NAME] the Date to Marketing (if applicable) | 6 Months | Course Director/Support Staff
Order/Prepare Marketing Distribution Lists | 6 months | Support Staff
Send Marketing STD Draft to CME for approval | 6 months | Support Staff
Distribute Save the Date Card | 4-6 Months | Support Staff
Send Brochure Text to Marketing | 4-6 Months | Support Staff
Send Brochure Drafts to CME for approval | 4-6 Months | Support Staff
Confirm Speaker [NAME] | 4 Months | Support Staff
Confirm Vendor Exhibits | 4 Months | Support Staff
Confirm Audiovisual | 4 Months | Support Staff
Distribute Brochure | 3-4 Months | Support Staff
Register Participants | Ongoing | Support Staff
Confirmation Letters to Participants | Ongoing | Support Staff
Confirm Individual Speakers AV Needs | 6-8 Weeks | Support Staff
Confirm Catering/Room Set Up | 6-8 Weeks | Support Staff
[NAME] | 2-4 Weeks | Support Staff
[NAME] | 2 Weeks | Support Staff
Print Syllabus/Handouts | 1-2 Weeks | Support Staff
Create & Print Sign-In Roster | 1-2 Weeks | Support Staff
Create & Print Evaluation | 1-2 Weeks | Support Staff
Create & Print Name Badges | 1 Week | Support Staff
Finalize Count for Catering | 3-5 Days | Support Staff
Finalize AV Needs | 3-5 Days | Support Staff
Post Conference Documents to CME | 1-2 Weeks Post | Support Staff
Send Certificates | 1-2 Weeks Post | CME
Evaluation Summary | 2-4 Weeks Post | CME
Final Budget to CME | 2-4 Weeks Post | Support Staff
Outcome Measurement Survey | 3 Months Post | CME
Spreadsheet: 475478d1471334667-unique-values-sample
Sheet: Uniques

Cost Centre | Division | # People | Total ($) | P/C ($) | Month
T0081P | Tax | 8 | 593.6500000000001 | 74.20625000000001 | 2016-07-01 00:00:00
Z1142P | Shared Services | 4 | 282.825 | 70.70625 | 2016-07-01 00:00:00
T0008M | Tax | 19 | 1302.625 | 68.55921052631578 | 2016-07-01 00:00:00
Z9069G | Shared Services | 2 | 134.175 | 67.0875 | 2016-07-01 00:00:00
Z9156N | Shared Services | 1 | 53.175 | 53.175 | 2016-07-01 00:00:00
T0085N | Tax | 4 | 201.85 | 50.4625 | 2016-07-01 00:00:00
Z1120N | Shared Services | 4 | 171.05 | 42.76250000000001 | 2016-07-01 00:00:00
D0084N | Advisory | 2 | 84.07500000000002 | 42.03750000000001 | 2016-07-01 00:00:00
F0033N | Advisory | 58 | 2400.725000000001 | 41.3918103448276 | 2016-07-01 00:00:00
T0089N | Tax | 29 | 1065.05 | 36.72586206896552 | 2016-07-01 00:00:00
D0019N | PE | 102 | 3729.400000000001 | 36.56274509803922 | 2016-07-01 00:00:00
F0035N | Advisory | 43 | 1551.9 | 36.0906976744186 | 2016-07-01 00:00:00
Z2063N | Shared Services | 3 | 103.625 | 34.54166666666667 | 2016-07-01 00:00:00
R0011N | Advisory | 58 | 1924.8 | 33.18620689655173 | 2016-07-01 00:00:00
Z1124N | Shared Services | 7 | 227.1 | 32.44285714285714 | 2016-07-01 00:00:00
Z1050A | Shared Services | 4 | 127.575 | 31.89375 | 2016-07-01 00:00:00
Z2032N | Shared Services | 13 | 404.3750000000001 | 31.10576923076923 | 2016-07-01 00:00:00
P0011G | PE | 22 | 671.9749999999998 | 30.54431818181817 | 2016-07-01 00:00:00
T0090N | Tax | 13 | 396.7250000000001 | 30.5173076923077 | 2016-07-01 00:00:00
Z1051B | Shared Services | 12 | 365.6749999999999 | 30.47291666666666 | 2016-07-01 00:00:00
Z1070P | Shared Services | 10 | 302.55 | 30.255 | 2016-07-01 00:00:00
T0093N | Tax | 48 | 1429.399999999999 | 29.77916666666665 | 2016-07-01 00:00:00
Z1142B | Shared Services | 3 | 88.075 | 29.35833333333333 | 2016-07-01 00:00:00
[NAME] | Shared Services | 4 | 117.375 | 29.34375 | 2016-07-01 00:00:00
[NAME] | Shared Services | 114 | 3317.525 | 29.10109649122807 | 2016-07-01 00:00:00
Z9044C | Shared Services | 4 | 115.7 | 28.925 | 2016-07-01 00:00:00
D0067N | Advisory | 35 | 969.9250000000001 | 27.71214285714286 | 2016-07-01 00:00:00
[NAME] | Shared Services | 6 | 164.05 | 27.34166666666667 | 2016-07-01 00:00:00
T0072B | Tax | 11 | 296.6 | 26.96363636363636 | 2016-07-01 00:00:00
Spreadsheet: 039ed1a7-107d-44f3-a00d-224ecc723bf5
Sheet: Sheet1

Test Referenced | Entry Type | Mayo ID | Description | Reporting Description | Method | Collection Container | Temperature | Stability | [NAME] | Unit of Measure | [NAME] | Minimum Volume | Reject Due To | Reference Values | Days/Times Performed | Analytic Time | Maximum Lab Time | CPT Units | CPT Code | LOINC® Code | LOINC® Attributes | Always Performed | Orderable Separately | Performing Location
HEXP | Test | HEXP | Iohexol, Plasma | Iohexol, Plasma | Liquid Chromatography-Tandem Mass Spectrometry (LC-MS/MS) |  |  |  | 0.5 | mL | Collection Container/Tube: Green top (heparin) Submission Container/Tube: Plastic, 6-mL tube (Supply T465) [NAME]: 1 mL  Collection Instructions: Patient should be fasting for 4 hours; 2 hours for diabetic patients. | 0.5 mL | Hemolysis	NA Thawing	Cold OK ; Warm reject;  Lipemia	NA Icterus	NA Other	NA | Not applicable | Monday through Friday; 8 a.m.-4:30 p.m. | 3 days | 4 days | 1 | 83789 |  |  |  |  | Rochester
HEXP | [NAME] | PLHEP | [NAME] |  |  |  | Refrigerated | 7 days
HEXP | Result | 61713 | Iohexol, P | Iohexol, P | Numeric |  |  |  |  | mcg/mL |  |  |  |  |  |  |  |  |  | In Process
Spreadsheet: 31a0ce88-ba70-4162-88a5-e1c8161c7efe
Sheet: Sheet1

Test Referenced | Entry Type | Mayo ID | Description | Reporting Description | Method | Collection Container | Temperature | Stability | [NAME] | Unit of Measure | [NAME] | Minimum Volume | Reject Due To | Reference Values | Days/Times Performed | Analytic Time | Maximum Lab Time | CPT Units | CPT Code | LOINC® Code | LOINC® Attributes | Always Performed | Orderable Separately | Performing Location
SCOC | Test | SCOC | [NAME], Serum | [NAME], S | Complement Fixation (CF) Using [NAME]: IgG Immunodiffusion: IgG and IgM | Serum Gel Tube: SGT |  |  | 2 | mL | Container/Tube:  Preferred: Red top Acceptable: Serum gel [NAME]: 2 mL | 1.2 mL | Hemolysis	Mild OK; Gross reject Thawing	Warm reject; Cold OK Lipemia	Mild OK; Gross reject Icterus	NA Other	NA | COMPLEMENT FIXATION Negative If positive, results are titered.  IMMUNODIFFUSION Negative Results are reported as positive, negative, or equivocal. | Monday through Friday; 9:30 a.m. | 4 days | 7 days | 3 | 86635 |  |  |  |  | Rochester
SCOC | [NAME] | SERUM | Serum |  |  |  | Refrigerated | 14 days
SCOC | Result | 8295 | Cocci Complement F | Cocci Complement F | Alphanumeric |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 5096-3 | Coccidioides immitis Ab:ACnc:Pt:Ser:Ord:Comp fix
SCOC | Result | 21649 | Cocci Immunodiffusion-IgG | Cocci Immunodiffusion-IgG | Alphanumeric |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 22209-1 | Coccidioides immitis Ab.IgG:ACnc:Pt:Ser:Ord:
SCOC | Result | 21648 | Cocci Immunodiffusion-IgM | Cocci Immunodiffusion-IgM | Alphanumeric |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 22210-9 | Coccidioides immitis Ab.IgM:ACnc:Pt:Ser:Ord:
Spreadsheet: 328151d1403797500-need-help-proofing-my-formula-thanks-in-advance-carrothe
Sheet: Sheet2

 | x | y | z
a | 1 | 2 | 3
b | 345 | 435 | 454
c | 7657 | 4563 | 233445
d | 3244 | 78 | 768
e | 234 | 345 | 567
Spreadsheet: 36321d1234209516-intersect-formula-example
Sheet: Sheet1

 | Busan | Calcutta | Chennai | Haimen | Hamburg
Algeciras | 131 | 136 | 133 | 128 | 130
Altamiras | 119 | 122 | 119 | 114 | 116
Antwerp | 123 | 128 | 125 | 120 | 122
Bilbao | 126 | 131 | 128 | 123 | 125
[NAME] | 118 | 123 | 120 | 115 | 117
Durban | 135 | 140 | 137 | 132 | 134
Gdansk | 116 | 121 | 118 | 113 | 115
Hamburg | 127 | 132 | 129 | 124 | 126
Spreadsheet: 147074d1332513609-some-users-cant-see-dropdown-lists-spreadsheet-example
Sheet: Sheet1

Never |  | Technical instruction
Rarely |  | Physical training  sets
Half the time |  | Competition performance
Most of the time |  | Personal preparation
All of the time |  | Other life activities
East |  | 5 or fewer
West |  | 6 to 10
North |  | 11 to 15
Midland |  | 16 to 20
 |  | 20 or more
2 or fewer
2 to 4
4 to 6
6 or more
Spreadsheet: 716060d1612005255-sequential-numbering-with-month-and-year-as-leading-values-book1
Sheet: January 2021

2021-01-01 00:00:00
Spreadsheet: 11a177d5-5f98-45f2-bfe1-b64228f60bec
Sheet: Block 7

Block 7
Sub-mainline Sizing and Pressure
 | 150 | C-value for PVC ID > 5"
 | 145 | C-value for PVC 1.5" < = ID < =  5"
 | 140 | C-value  for PVC < 1.5"
 | 0 | feet, Total Elevation Drop
 |  | feet, Length of Sub-mainline
 |  | ft/ft, Change in Elevation
 | 0.5 | GPH/emitter
 |  | GPM/emitter
 |  | ft, emitter spacing
 | Chg. Elev = Length * ft/ft (elevation change worst case)
 | Chg. P = Chg. Elev + Hf
Section A Uphill
Row | Row Length ft | GPM per Row | Pressure PSI | Length ft | GPM | Pipe ID, in | Velocity, ft/sec | C-Value | Hf (psi) | Chg. Elev (psi) | Chg. P (psi)
Inlet | 0 | 0 | 25 | 0 | 46.3 | 2.193
1 | 361.5 |  |  | 2.3 |  | 2.193
 | 355.4 |  |  | 7.7 |  | 2.193
 | 349.4 |  |  | 7.7 |  | 2.193
 | 343.3 |  |  | 7.7 |  | 2.193
 | 337.2 |  |  | 7.7 |  | 2.193
 | 331.2 |  |  | 7.7 |  | 2.193
 | 325.1 |  |  | 7.7 |  | 2.193
 | 319.1 |  |  | 7.7 |  | 2.193
 | 313 |  |  | 7.7 |  | 2.193
 | 306.9 |  |  | 7.7 |  | 2.193
 | 300.9 |  |  | 7.7 |  | 2.193
Section A Downhill
 | 525.5 |  | 25 | 2.3 | 46.3 | 2.193
 | 526.2 |  |  | 7.7 |  | 2.193
 | 526.5 |  |  | 7.7 |  | 2.193
 | 526.8 |  |  | 7.7 |  | 2.193
 | 527 |  |  | 7.7 |  | 2.193
 | 527.3 |  |  | 7.7 |  | 2.193
 | 527.6 |  |  | 7.7 |  | 2.193
 | 527.9 |  |  | 7.7 |  | 2.193
 | 528.1 |  |  | 7.7 |  | 2.193
 | 528.4 |  |  | 7.7 |  | 2.193
 | 528.7 |  |  | 7.7 |  | 2.193
Section B
 | 286.7 |  |  | 11.6 |  | 1.72
 | 272 |  |  | 11.8 |  | 1.72
 | 257.3 |  |  | 11.8 |  | 1.72
 | 242.5 |  |  | 11.8 |  | 1.72
 | 227 |  |  | 11.8 |  | 1.72
 | 189 |  |  | 11.8 |  | 1.72
 | 151.1 |  |  | 11.8 |  | 1.72
 | 113.1 |  |  | 11.8 |  | 1.72
 | 75.2 |  |  | 11.8 |  | 1.72
 | 37.3 |  |  | 11.8 |  | 1.72
Section C
 | 501.5 |  | 33.7 | 28.7 | 21.9 | 1.72
 | 472.4 |  |  | 30 |  | 1.72
 | 443.4 |  |  | 30 |  | 1.72
 | 414.4 |  |  | 30 |  | 1.72
 | 385.4 |  |  | 30 |  | 1.72
 | 356.4 |  |  | 30 |  | 1.72
 | 327.4 |  |  | 30 |  | 1.72
 | 298.4 |  |  | 30 |  | 1.72
 | 269.4 |  |  | 30 |  | 1.72
Section D
 | 245.6 |  |  | 25.3 |  | 1.72
 | 235.8 |  |  | 12.5 |  | 1.72
 | 226 |  |  | 12.5 |  | 1.72
 | 216.3 |  |  | 12.5 |  | 1.72
 | 206.5 |  |  | 12.5 |  | 1.72
 | 196.8 |  |  | 12.5 |  | 1.72
 | 187 |  |  | 12.5 |  | 1.72
 | 177.3 |  |  | 12.5 |  | 1.72
 | 167.5 |  |  | 12.5 |  | 1.72
 | 157.8 |  |  | 12.5 |  | 1.72
 | 148 |  |  | 12.5 |  | 1.72
 |  | Min P |  | PSI
 |  | [NAME] |  | PSI
 |  | Avg. P, PSI |  | PSI
 |  | Total GPM
 |  | Sub-Main Length, ft
Spreadsheet: 067848f6-25b7-4f33-b783-f68b785d54d0
Sheet: Sheet2

FY_ST | FY_END | AC_YEAR
2004-07-01 00:00:00 | 2005-06-30 00:00:00 | 2004-2005 | 2005
2005-07-01 00:00:00 | 2006-06-30 00:00:00 | 2005-2006 | 2006
2006-07-01 00:00:00 | 2007-06-30 00:00:00 | 2006-2007 | 2007
2007-07-01 00:00:00 | 2008-06-30 00:00:00 | 2007-2008 | 2008
2008-07-01 00:00:00 | 2009-06-30 00:00:00 | 2008-2009 | 2009
2009-07-01 00:00:00 | 2010-06-30 00:00:00 | 2009 - 2010 | 2010
2010-07-01 00:00:00 | 2011-06-30 00:00:00 | 2010 - 2011 | 2011
2011-07-01 00:00:00 | 2012-06-30 00:00:00 | 2011 - 2012 | 2012
2012-07-01 00:00:00 | 2013-06-30 00:00:00 | 2012 - 2013 | 2013
2013-07-01 00:00:00 | 2014-06-30 00:00:00 | 2013 - 2014 | 2014
2014-07-01 00:00:00 | 2015-06-30 00:00:00 | 2014 - 2015 | 2015
2015-07-01 00:00:00 | 2016-06-30 00:00:00 | 2015 - 2016 | 2016
2016-07-01 00:00:00 | 2017-06-30 00:00:00 | 2016 - 2017 | 2017
2017-07-01 00:00:00 | 2018-06-30 00:00:00 | 2017 - 2018 | 2018
2018-07-01 00:00:00 | 2019-06-30 00:00:00 | 2018 - 2019 | 2019
2019-07-01 00:00:00 | 2020-06-30 00:00:00 | 2019 - 2020 | 2020
2020-07-01 00:00:00 | 2021-06-30 00:00:00 | 2020 - 2021 | 2021
2021-07-01 00:00:00 | 2022-06-30 00:00:00 | 2021 - 2022 | 2022
2022-07-01 00:00:00 | 2023-06-30 00:00:00 | 2022 - 2023 | 2023
2023-07-01 00:00:00 | 2024-06-30 00:00:00 | 2023 - 2024 | 2024
2024-07-01 00:00:00 | 2025-06-30 00:00:00 | 2024 - 2025 | 2025
2025-07-01 00:00:00 | 2026-06-30 00:00:00 | 2025 - 2026 | 2026
2026-07-01 00:00:00 | 2027-06-30 00:00:00 | 2026 - 2027 | 2027
2027-07-01 00:00:00 | 2028-06-30 00:00:00 | 2027 - 2028 | 2028
2028-07-01 00:00:00 | 2029-06-30 00:00:00 | 2028 - 2029 | 2029
2029-07-01 00:00:00 | 2030-06-30 00:00:00 | 2029 - 2030 | 2030
2030-07-01 00:00:00 | 2031-06-30 00:00:00 | 2030 - 2031 | 2031
2031-07-01 00:00:00 | 2032-06-30 00:00:00 | 2031 - 2032 | 2032
2032-07-01 00:00:00 | 2033-06-30 00:00:00 | 2032 - 2033 | 2033
2033-07-01 00:00:00 | 2034-06-30 00:00:00 | 2033 - 2034 | 2034
Spreadsheet: 765551d1643383308-conditional-formatting-with-a-difference-sample
Sheet: Sheet1

Q1 2022
 |  | Volume |  | 0.75
 |  | Renewed Value |  | 0.99
 | 0.5 | 0.55 | 0.6 | 0.7 | Volume
0.6 | 250 | 300 | 500 | 600
0.7 | 300 | 500 | 600 | 750
0.8 | 500 | 600 | 750 | 850
0.9 | 600 | 750 | 850 | 1000
Value QTR
Renewal in QTR |  |  | Available | 4 | Volume
Business Name | Value renewed |  |  | 25000 | Value
abc corp | 10800
cde company | 6120