tianzl66/Sheetpedia huggingface dataset:
Spreadsheet: 729652d1619234306-ranking-list-based-on-test-scores-new-hire-testing-2-
Sheet: Sheet1

 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | I am working on an Excel sheet that places a rank by each person based on their score for a certain part of a hiring test, each section is tested individually and then the average of the rank of each list is used to rank them overall. It will only rank if each all scores are listed, but I would like to to rank regardless of if all section scores are entered and regardless of if each persons scores are entered. If I delete even one score the overall averages go to #value!. Also I may have 30 people testing one time but only 5 people testing the next time so I may not have each cell filled out. I will attach the file for reference.
Name A-Z |  | Written Exam |  | Fintess Eval |  | Interview |  | Average of 3 tests | Overall Rank
Last | First | Score | Place | Score | Place | Score | Place |  |  |  |  | Written Exam Helper 1 | Written Exam Helper 2 | Fitness Eval Helper 1 | Fitness Eval Helper 2 | Interview Helper 1 | Interview Helper 2
a | a | 88 |  | 22 |  | 58
b | b | 100 |  | 88 |  | 90
c | c | 100 |  | 85 |  | 25
d | d | 100 |  | 86 |  | 23
e | e | 100 |  | 87 |  | 24
Spreadsheet: kevin_hyatt__19604__Base Model 111601
Sheet: Debt

[NAME]
[NAME] (US $000's)
 |  |  |  | Beginning | Amount of | Interest |  | Amort
 |  |  |  | Balance | Debt | Rate | Term | Method | % Amort
Senior Tranche A (US$)
Senior Tranche B (US$)
Junior Debt (US$)
Revolver/New Financing (US$) |  |  |  | 0
Total Debt
 |  |  |  | Projected Fiscal Year Ending December 31,
 |  |  |  | 2001 | 2002 | 2003 | 2004 | 2005 | 2006 | 2007 | 2008 | 2009 | 2010
 |  |  | Year | 1 | 2 | 3 | 4 | 5 | 6 | 7 | 8 | 9 | 10
Beginning Balance
Drawdown
Repayment
Ending Balance
Interest Expense
Beginning Balance
[NAME]
Discretionary Principal Repayment |  |  |  | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0
Ending Balance
Interest Expense
Beginning Balance
[NAME]
Discretionary Principal Repayment |  |  |  | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0
Ending Balance
Interest Expense
Beginning Balance
[NAME]
Discretionary Principal Repayment |  |  |  | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0
Ending Balance
Interest Expense
Discretionary Principal Repayment Schedule
Cash Flow Available for Repayment (includes Cash on the balance sheet)
Scheduled Borrowing (Repayment)
Cash Flow Available for Additional Debt Paydown
Principle Repayment Scenarios
Option 1 |  |  |  | Projected Fiscal Year Ending December 31,
No Amortization |  |  |  | 2001 | 2002 | 2003 | 2004 | 2005 | 2006 | 2007 | 2008 | 2009 | 2010
 |  |  | Year | 1 | 2 | 3 | 4 | 5 | 6 | 7 | 8 | 9 | 10
Option 2 |  |  |  | Projected Fiscal Year Ending December 31,
Partial Amortization |  |  |  | 2001 | 2002 | 2003 | 2004 | 2005 | 2006 | 2007 | 2008 | 2009 | 2010
 |  |  | Year | 1 | 2 | 3 | 4 | 5 | 6 | 7 | 8 | 9 | 10
[NAME]
[NAME]
End Balance
[NAME]
[NAME]
End Balance
[NAME]
[NAME]
End Balance
Option 3 |  |  |  | Projected Fiscal Year Ending December 31,
Mortgage Style |  |  |  | 2001 | 2002 | 2003 | 2004 | 2005 | 2006 | 2007 | 2008 | 2009 | 2010
 |  |  | Year | 1 | 2 | 3 | 4 | 5 | 6 | 7 | 8 | 9 | 10
[NAME]
Payment
Interest Payment
Ending Balance
[NAME]
Payment
Interest Payment
Ending Balance
Junior Debt
[NAME]
Payment
Interest Payment
Ending Balance
Spreadsheet: 03c35933-326e-4af4-bff9-47d725caf011
Sheet: Other

vr1 | Active
 | Inactive
vr2
 | Yes
 | No
 | Federal
 | Match
 | Program Income
 | Instructional Program- ABE/ESL
 | Instructional Program - ASE
 | Administration
 | Instructional Program - ABE/ESL
 | Instructional Program - ASE
 | Administration
 | Employee Benefits (0200)
 | Purch Prof & Tech Serv (0300)
 | Other Purch Serv (0500)
 | Supplies (0600)
 | Equipment (0730)
 | Original Budget
 | [NAME]
 | Yes (0730)
 | No (0735)
 |  | 0500, 0800
 |  | 0300, 0500
 |  | 0100, '0200, 0300, 0500, 0600
 |  | 0300, 0500, 0600
 | No Transfers
 | REAP | No Transfers
 | Non-improvement | 1
 | Improvement | 0.5
 | BOCES | 0.3
 |  | BOCES - see below
Spreadsheet: 3fdfe860-45f0-47e6-a0f8-0c641dcf4625
Sheet: MATH

Old course number | New course number
MATH-320 | MATH-2131
MATH-322 | MATH-2141
MATH-325 | MATH-1423
MATH-330 | [NAME]
MATH-335 | MATH-2137
MATH-336 | MATH-3109
MATH-337 | MATH-4337
MATH-340 | MATH-3137
MATH-350 | MATH-2221
MATH-355 | MATH-2281
MATH-390 | MATH-3290 and MATH-3220
MATH-391 | MATH-3229
MATH-392 | MATH-3259
MATH-393 | MATH-4637
MATH-440 | MATH-3449
MATH-450 | MATH-4621
MATH-455 | MATH-3271
MATH-460 | MATH-4451
MATH-460 | MATH-6451
MATH-465 | MATH-4133
MATH-470 | MATH-4700
MATH-472 | MATH-4241
MATH-474 | MATH-4243
MATH-490 | MATH-4229
MATH-505 | MATH-5171
MATH-531 | [NAME]
MATH-531 | MATH-6373
MATH-537 | MATH-6337
MATH-540 | MATH-4557
MATH-540 | MATH-6557
MATH-593 | MATH-6637
MATH-642 | MATH-6449
MATH-721 | MATH-7211
MATH-WS2 | MATH-0925
MATH-WS3 | [NAME]
Spreadsheet: 412280d1438935396-calculate-difot-on-time-and-late-difot-sample-calculations
Sheet: Sheet1

POQtyOrder | Required_Ship_Date | PO_Ship_Date | [NAME] 1 | PO_Ship_Date | [NAME] 2 | PO_Ship_Date | [NAME] 3 | Qty Not Shipped | Past Due Days Ship 1 | Past Due Days Ship 2 | Past Due Days Ship 3 | OT % Score Ship 1 | OT/Late 1 | OT % Score Ship 2 | OT/Late 2 | OT % Score Ship 3 | OT/Late 3 | Total qty Ship O/time | % line shipped on time | Total Qty Shipped Late | %line Not Shipped On time
800 | 2015-07-15 00:00:00 | 2015-07-20 00:00:00 | 680 | 2015-07-28 00:00:00 | 118 | 2015-08-04 00:00:00 | 2
800 | 2015-07-15 00:00:00 | 2015-07-20 00:00:00 | 228 | 2015-08-04 00:00:00 | 572 |  |  |  |  |  |  |  |  | 0.5
600 | 2015-07-15 00:00:00 | 2015-07-20 00:00:00 | 600
Spreadsheet: 847468d1698387873-adding-up-how-many-times-a-unqie-number-appears-aligw
Sheet: Sheet1

 | Monday | Tuesday | Wenesday | Thursday | Friday
Week 1 |  | 3 | 2 | 4 | 2
Week 2 | 2 | 2 | 2 | 3 | 4
Week 3 |  | 3 | 2 | 1 | 3
Week 4 | 4 | 2 | 3 | 1
Spreadsheet: 586968d1534773240-deriving-values-from-different-columns-from-different-sheets-example
Sheet: Sheet 2

Person ID | No consequence | Wage
123 |  | 120401
567 |  | 11230031
342 |  | 1249184
178 |  | 1243818
123 |  | 1249188
233 |  | 1204818
466 |  | 1294817
431 |  | 1284818
222 |  | 12848181
Spreadsheet: 552132d1513306447-issue-dealing-with-simple-excel-issue-formula-and-pivot-s666-exercise
Sheet: Raw

Customer | Ind
Cesco Environmental Technologies Pte Ltd | OTRS |  |  |  | Ind | Customer | Distinct Count of Customer
Cesco Environmental Technologies Pte Ltd | OTRS |  |  |  | ACAD | BMSI -Biomedical Sciences Institute | 1
Cesco Environmental Technologies Pte Ltd | OTRS |  |  |  |  | BMSI -Biomedical Sciences Institute R | 1
Cesco Environmental Technologies Pte Ltd | OTRS |  |  |  |  | Nanyang Technological University | 1
Cesco Pipeline Technologies Pte Ltd | SI |  |  |  |  | Nanyang Technological University-RRR | 1
Cesco Pipeline Technologies Pte Ltd | SI |  |  |  |  | Singapore Polytechnic | 1
Cesco Pipeline Technologies Pte Ltd | SI |  |  |  | ACAD Total |  | 5
Cesco Pipeline Technologies Pte Ltd | SI |  |  |  | OTRS | Cesco Environmental Technologies Pte Ltd | 1
Fisher Scientific Pte Ltd | PHAR |  |  |  | OTRS Total |  | 1
Fisher Scientific Pte Ltd | PHAR |  |  |  | PHAR | [NAME] | 1
Fisher Scientific Pte Ltd | PHAR |  |  |  |  | [NAME], Singapore Branch | 1
Fisher Scientific Pte Ltd | PHAR |  |  |  |  | Fisher Scientific Pte Ltd | 1
Fisher Scientific Pte Ltd | PHAR |  |  |  |  | Fluidigm Singapore Pte Ltd | 1
Fisher Scientific Pte Ltd | PHAR |  |  |  |  | Illumina Singapore Pte Ltd | 1
PPD Global Central Lab | PHAR |  |  |  |  | JMS Singapore Pte Ltd | 1
PPD Global Central Lab | PHAR |  |  |  |  | Lion TCR Pte Ltd | 1
BMSI -Biomedical Sciences Institute | ACAD |  |  |  |  | Lonza Biologics Tuas Pte Ltd | 1
BMSI -Biomedical Sciences Institute | ACAD |  |  |  |  | PPD Global Central Lab | 1
Tessa Therapeutics Pte Ltd | PHAR |  |  |  |  | Tessa Therapeutics Pte Ltd | 1
Nanyang Technological University-RRR | ACAD |  |  |  | PHAR Total |  | 10
Nanyang Technological University | ACAD |  |  |  | SI | Cesco Pipeline Technologies Pte Ltd | 1
Nanyang Technological University | ACAD |  |  |  | SI Total |  | 1
Nanyang Technological University | ACAD |  |  |  | TEST | Bio-Rad Laboratories (S) Pte Ltd | 1
Lonza Biologics Tuas Pte Ltd | PHAR |  |  |  |  | National Neuroscience Institute | 1
National Neuroscience Institute | TEST |  |  |  | TEST Total |  | 2
BMSI -Biomedical Sciences Institute R | ACAD |  |  |  | Grand Total |  | 19
Lonza Biologics Tuas Pte Ltd | PHAR
Illumina Singapore Pte Ltd | PHAR
Illumina Singapore Pte Ltd | PHAR
Fluidigm Singapore Pte Ltd | PHAR
Fluidigm Singapore Pte Ltd | PHAR
Fluidigm Singapore Pte Ltd | PHAR
Illumina Singapore Pte Ltd | PHAR
Singapore Polytechnic | ACAD
BMSI -Biomedical Sciences Institute | ACAD
BMSI -Biomedical Sciences Institute | ACAD
Bio-Rad Laboratories (S) Pte Ltd | TEST
Lion TCR Pte Ltd | PHAR
Lion TCR Pte Ltd | PHAR
[NAME] | PHAR
[NAME] | PHAR
[NAME], Singapore Branch | PHAR
[NAME], Singapore Branch | PHAR
[NAME], Singapore Branch | PHAR
[NAME], Singapore Branch | PHAR
[NAME], Singapore Branch | PHAR
JMS Singapore Pte Ltd | PHAR
Cesco Pipeline Technologies Pte Ltd | SI
Cesco Pipeline Technologies Pte Ltd | SI
Cesco Pipeline Technologies Pte Ltd | SI
Cesco Pipeline Technologies Pte Ltd | SI
Spreadsheet: 7e05735c-bd6e-47ef-81fa-180830f91b4d
Sheet: Sheet1

PROG ID | ATHLETE ID | ATHLETE FIRST | ATHLETE LAST | NATIONALITY | START NUMBER | SWIM | T1 | BIKE | T2 | RUN | POSITION | TOTAL TIME
3725 | 6150 | [NAME] | Riveros | CHI | 31 | 00:22:08 | 00:01:03 | 01:23:13 | 00:00:31 | 00:42:27 | 1 | 02:29:22
3725 | 15935 | Rebecca | Witinok- Huber | USA | 34 | 00:21:51 | 00:01:06 | [NAME] | 00:00:12 | 00:47:17 | 2 | 02:34:38
3725 | 23541 | [NAME] | Tastets | CHI | 35 | 00:22:11 | 00:01:11 | [NAME] | 00:00:00 | 00:00:00 | DNF | 00:00:00
Spreadsheet: 140399d1328731659-excel-2007-getting-price-to-autofill-after-picking-product-from-dropdown-list-myprob
Sheet: PeçasMaterial

Diversos | Preço | Inox | Preço | [NAME] | Preço | PVC | Preço
Electrodes Normal 2.5 | 0.3 | [NAME] 125 INOX | 2.5 | União Niquelada 15x1/2 M. | 1.38 | Lata Cola PVC 1/4 TANGITT | 9.5
[NAME] 1/2 | 5.56 | [NAME] 15mm | 0.5 | [NAME] 15mm | 1.68 | Valvulas PVC 25mm JIMTEN | 7.8
Spreadsheet: 866478d1713385698-looking-for-a-way-to-filter-a-text-variable-kansas-scheduler-v4-6-eba
Sheet: Not in Production (Kitting)

[NAME] from date below↓ |  | DO NOT EDIT IN THIS REPORT
2024-02-21 00:00:00
Not in Production (Kitting)
Client | Job # | # of Stores | # of Pieces | Ship Date | Notes
 | HHGJ 188 | 69 | 89 | 2024-03-01 00:00:00 | [NAME]
E03055560- MENS Vans Q1 0226 | 0 | 18 | 5 | 2024-03-01 00:00:00 | 0
BASS 245365 [1] | 245365 | 34 | 34 | 2024-03-01 00:00:00 | 0
DXL | 244647 | 240 | 242 | 2024-03-04 00:00:00 | PLACEMARKER
DXL | 244653 | 2 | 2 | 2024-03-04 00:00:00 | 0
HHGJ | 166 | 69 | 145 | 2024-03-04 00:00:00 | PLACEMARKER- + 4pcs of Sintra- Nike Swim- E03074917
North American | 0 | 0 | 549 | 2024-03-06 00:00:00 | PLACEMARKER
CRMX 245439 [7] | 245439 | ? | 22 | 2024-03-07 00:00:00 | 0
NAC 244862 [11] | 244862 | 559 | 574 | 2024-03-11 00:00:00 | 0
Blast Media March All Gender Run Campaign | 0 | 92 | 185 | 2024-03-12 00:00:00 | [NAME]
HHGJ 206 [18] | 206 | 218 | 784 | 2024-03-18 00:00:00 | 0
E03092536- adidas Always On Terrace Culture | 0 | 218 | 1447 | 2024-03-25 00:00:00 | 0
Hallmark- [NAME] | 0 | ? | 0 | 2024-03-27 00:00:00 | PLACEMARKER
[NAME] | [NAME] 3311 | ? | 0 | 2024-04-09 00:00:00 | PLACEMARKER
HHGJ 253 | 0 | 51 | 108 | 2024-04-09 00:00:00 | 0
E03082789- [NAME] Badge of Sports.xlsx | HHGJ 271 | 0 | 0 | 2024-04-09 00:00:00 | 0
CALERES | 246177 | 1175 | 0 | 2024-04-17 00:00:00 | 0
CALERES | 246183 | 125 | 0 | 2024-04-18 00:00:00 | 0
CKCC | 45790 | ? | 0 | 2024-04-23 00:00:00 | PLACEMARKER
CKCC BLOCK | 0 | ? | 0 | 2024-04-23 00:00:00 | PLACEMARKER
CKCC BLOCK | 0 | ? | 0 | 2024-04-24 00:00:00 | PLACEMARKER
TMOBILE | 0 | ? | 0 | 2024-05-01 00:00:00 | PLACEMARKER
GGPM | 0 | ? | 0 | 2024-05-03 00:00:00 | PLACEMARKER
TMOBILE 5 jobs from Timeline Requests | 0 | ? | 0 | 2024-05-08 00:00:00 | PLACEMARKER
North American Corporation | 0 | ? | 573 | 2024-05-17 00:00:00 | PLACEMARKER
GGPM | 0 | ? | 0 | 2024-09-04 00:00:00 | PLACEMARKER
TMOB- APPLE NPI- FALL | 0 | ? | 0 | 2024-09-14 00:00:00 | PLACEMARKER
Spreadsheet: 762362d1641509611-countif-department-matches-and-date-range-30-matches-fake-report-keebellah-
Sheet: Dashboard

Department | Number of AD accounts | No login date | Last logged in >30 days | Last logged in >60 days | Last logged in >90 days
Fake Department 1
Fake Department 2
Fake Department 3
Spreadsheet: 76265d1276792073-charts-and-pivot-tables-help
Sheet: Sheet1

Product | Singapore - Location |  |  |  |  | Total Sales of Product | Average | MAX | MIN
 | Bedok | [NAME] | Woodlands | Orchard | Kallang
Children Books | 100000 | 65000 | 105000 | 145000 | 115000 | 530000 | 106000 | 145000 | 65000
Art and Craft | 60000 | 66000 | 80000 | 106000 | 94000 | 406000 | 81200 | 106000 | 60000
Puzzles and Games | 56000 | 60000 | 40000 | 136000 | 80000 | 372000 | 74400 | 136000 | 40000
Furnitures | 250000 | 150000 | 300000 | 400000 | 400000 | 1500000 | 300000 | 400000 | 150000
Classroom Supplies | 240000 | 160000 | 236000 | 304000 | 280000 | 1220000 | 244000 | 304000 | 160000
[NAME] | 750000 | 1375000 | 1175000 | 2250000 | 1750000 | 7300000 | 1460000 | 2250000 | 750000
Block Play | 440000 | 376000 | 264000 | 648000 | 520000 | 2248000 | 449600 | 648000 | 264000
CD-ROMS | 315000 | 273000 | 245000 | 455000 | 455000 | 1743000 | 348600 | 455000 | 245000
Total Sales in Location
Spreadsheet: 825564d1681397095-pull-data-from-one-sheet-to-another-from-last-data-entered-in-a-column-and-the-12-24-above-ak-sample3
Sheet: COVER-24

 | AK |  |  |  |  |  | unlock 1111 |  |  |  |  |  |  | combo | Cover
Well No. | 12H | 13H | 14H | 15H | Total |  |  |  |  |  |  |  |  | combo
Start Date: |  |  |  |  |  |  |  |  |  |  |  |  |  | combo
Online/Hrs |  |  |  |  |  |  |  |  |  |  |  |  |  | combo
Choke |  |  |  |  |  |  |  |  |  |  |  |  |  | lt f
[NAME] |  |  |  |  |  |  |  |  |  |  |  |  |  | lt p
Casing PSI |  |  |  |  |  |  | Copy and paste table into email body |  |  |  |  |  |  | fork
Surface Csg |  |  |  |  |  |  |  |  |  |  |  |  |  | lift
[NAME] |  |  |  |  |  |  |  |  |  |  |  |  |  | trash
Water / Day |  |  |  |  |  | Clear | enter water totals in this row.  the row above where 0 is will calculate bbl per hour |  |  |  |  |  |  | ft
[NAME] |  |  |  |  |  |  |  |  |  |  |  |  |  | ft
Oil / Day |  |  |  |  |  |  | enter oil totals in this row.  the row above where 0 is will calculate bbl per hour |  |  |  |  |  |  | plug C
[NAME] to sales |  |  |  |  |  |  |  |  |  |  |  |  |  | plug C
Gas / Day |  |  |  |  |  |  | enter gas totals in this row.  the row above where 0 is will calculate bbl per hour |  |  |  |  |  |  | plug C
Inj / Day | off | off | off |  |  |  |  |  |  |  |  |  |  | st
 |  |  |  |  |  |  |  |  |  |  |  |  |  | st
Yesterday Lact |  |  |  |  |  |  |  |  |  |  |  |  |  | st
Comments | Hello how are you? Oh Im doing ok. XXXX OPEN WELL XX/128  S/I XXXX psi. Going to the store, I'll be back soon. see you soon. |  |  |  |  |  | gfhghcghghgvhvgvgvhgvhvghvgvgh
 | PM
 | 12H | 13H | 14H | 15H
GAS
WATER
OIL
 | AM |  |  |  |  |  | lact total
 | 12H | 13H | 14H | 15H |  |  | 0430 | 24 b4 |  |  |  |  | IF(g28-h28<0,0,g28-h28)
GAS |  |  |  |  |  | 750 |  | 118029
WATER |  |  |  |  |  | 760
OIL |  |  |  |  |  |  |  | Total
 |  |  |  |  |  |  |  |  | 0
Spreadsheet: 801811d1666381256-previous-quarter-previou-quarter-3-
Sheet: Sheet1

Simulated date/today | 2023-03-10 00:00:00
 |  |  |  | Previous Quarter based on B1 date
 | enter company [NAME] | helper column (convert b column  to 2023) | formula | Desired result | Result formula | Q1 END | Q2 END | [NAME] | [NAME]
 | 2022-02-28 00:00:00 |  |  | 2022-02-28 00:00:00
 | 2022-03-31 00:00:00 |  |  | 2022-12-31 00:00:00
 | 2022-04-30 00:00:00 |  |  | 2022-01-31 00:00:00
 | 2022-05-31 00:00:00 |  |  | 2022-02-28 00:00:00
 | 2022-06-30 00:00:00 |  |  | 2022-12-31 00:00:00
 | 2022-08-31 00:00:00 |  |  | 2022-02-28 00:00:00
 | 2022-09-30 00:00:00 |  |  | 2022-12-31 00:00:00
 | 2022-10-31 00:00:00 |  |  | 2022-01-31 00:00:00
 | 2022-12-31 00:00:00 |  |  | 2022-12-31 00:00:00
Spreadsheet: 141208d1329151525-moving-data-from-one-worksheet-to-another-based-on-certain-values-vlookup01
Sheet: Tab2

Employee_ID | Day1 | Day2 | Day3 | Day4 | Day5 | Day6 | Day7 | Day8 | Day9 | Day10 | Day11 | Day12 | Day13 | Day14 | Day15 | Day16
125432 | 123 | 123 | 123 | 123 | 123 | 123 | 123 | 123 | 123 | 123 | 123 | R | 123 | 123 | 123 | 123
12345 | R | 124 | 124 | 124 | 124 | 124 | 124 | 124 | 124 | 124 | 124 | 124 | 124 | 124 | R | 124
454 | 125 | 125 | R | 125 | 125 | 125 | R | 125 | 125 | 125 | 125 | 125 | 125 | 125 | 125 | 125
444 | 126 | 126 | 126 | 126 | 126 | 126 | 126 | 126 | 126 | R | 126 | 126 | 126 | 126 | 126 | 126
321665 | 127 | 127 | 127 | 127 | R | 127 | 127 | 127 | 127 | 127 | 127 | 127 | R | 127 | 127 | 127
Spreadsheet: 2128d001-83e4-4dcb-88d0-1a337a0ecf0c
Sheet: Rainwater

NON-POTABLE WATER CALCULATOR |  |  |  | NON-POTABLE WATER CALCULATOR
Climate Data for San Francisco |  |  |  | Rainwater Cistern Capture Calculation
 | SF Downtown Gauge |  |  |  | Total Above Grade Area Draining to Cistern (ft2)
 | 24 hour curves |  | C=1
 | Unit Storage | Percent | Percent |  | Rainfall Capture Factor
 | (inches) | Capture | Capture |  | Cistern Size (gallons)
 | 0 | 0 | 0 |  | Rain Event Captured (in)
 | 0.03 | 0.06 | 6 |  | Storm Percentile
 | 0.06 | 0.13 | 13 |  | Annual Runoff Captured
 | 0.12 | 0.2823 | 28.23
 | 0.24 | 0.4922 | 49.22
 | 0.36 | 0.6457999999999999 | 64.58 |  | Assumes cistern is empty at the beginning of September
 | 0.48 | 0.7570999999999999 | 75.71 |  | Month | Ave. Rainfall | Runoff to Cistern | Non-Potable Demand (gal/mth) |  |  | Ending Cistern | Water Captured | Water Reused | Overflow | Net Available Volume
 | 0.6000000000000001 | 0.8345 | 83.45 |  |  | ft3/mth | gal/mth | Irrigation | Indoor | Total | Volume (gal) | (gal/mth) | (gal/mth) | (gal/mth) | (gal/mth)
 | 0.72 | 0.8878 | 88.78 |  | September
 | 0.8400000000000001 | 0.9251 | 92.51 |  | October
 | 0.96 | 0.9501999999999999 | 95.02 |  | November
 | 1.08 | 0.9662999999999999 | 96.63 |  | December
 | 1.2 | 0.9773999999999999 | 97.74 |  | January
 | 1.32 | 0.9845999999999999 | 98.46 |  | February
 | 1.44 | 0.9892 | 98.92 |  | March
 | 1.56 | 0.9923000000000001 | 99.23 |  | April
 | 1.68 | 0.9948 | 99.48 |  | May
 | 1.8 | 0.9963 | 99.63 |  | June
 | 1.92 | 0.9972 | 99.72 |  | July
 | 2.04 | 0.9976999999999999 | 99.77 |  | August
 | 2.16 | 0.998 | 99.8 |  | Totals |  |  |  |  |  |  |  | 0
 | 2.28 | 0.9982 | 99.82
 | 2.4 | 0.9984999999999999 | 99.85
 | 2.52 | 0.9987 | 99.87
 | 2.64 | 0.9989 | 99.89
 | 2.76 | 0.9992 | 99.92
 | 2.88 | 0.9994 | 99.94
 | 3 | 0.9995999999999999 | 99.96
 | 3.12 | 0.9998 | 99.98
 | 3.24 | 0.9998999999999999 | 99.99
 | 3.36 | 1 | 100
 | 3.48 | 1 | 100
Spreadsheet: darrell_schoolcraft__7317__imball0202
Sheet: crosstex

Crosstexx Energy Services |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | Contract  21579
 | contr 21571 - poi 56935 |  | contr 23994 - poi 58444
 | Integrated Services DP |  | I.S.I. Farm Tap- [NAME]
 | Measured | Scheduled | Measured | Scheduled
1 | -2410 | -3699 | -2210 | -2000
2 | -2402 | -3699 | -18 | -2000
3 | -877 | -3699 | -674 | -2000
4 | -2234 | -3699 | -2562 | -2000
5 | -2473 | -3699 | -2615 | -2000
6 | -2204 | -1736 | -2601 | -2000
7
8
9
10
11
12
13
14
15
16
17
18
19
20
21
22
23
24
25
26
27
28
29
30
31
index
2002-01-31 00:00:00 |  |  |  |  | -117510.28 |  | 713.49
2002-02-06 00:00:00
CBS Volume |  |  |  |  |  |  | 2808
 |  |  | -35775
Spreadsheet: 320246d1400816241-same-name-in-cells-is-formatted-differently-how-can-i-replace-with-a-consistent-format-5-22-14-deep-macro-with-ryan-chad-update
Sheet: Beards

3/27: Beards, [NAME], asked re Dez for 1.05, [NAME], & 2015 1st.  I added 2.03 to it, asked [NAME].  [NAME] "solid offer, keep Dez".
Trade Revoked
Brawlin' Beards offers [NAME], [NAME]
Shine On You Crazy Diamond for Year 2014 Draft Pick 2.01
Expires: Fri Mar 28 6:00:00 a.m. ET 2014
[NAME] 21 6:54:10 a.m. ET 2014
Comments: I would Probably hold Wilson, his upside and value are pretty far apart I think. I would consider [NAME] for sure.
In a 14 team league, I would be looking for the 2.01. what do you think about [NAME] and (Graham, Little, or [NAME]) for 2.06 and 2015 2?
By the way [NAME], I love this, so thanks for sending things for me to consider!
I'm really not smitten by those three wrs that you listed, but I do have a thought for you.
You initially asked about [NAME]. I may be in the minority, but I kinda consider him just a smidge higher than Calvin right now, only because of their ages, 28 versus 25.
From what I've been reading, it sounds like a wr like Dez is worth approximately 3 first round draft picks. Now I know that wouldn't be exactly three first round picks. But if you are interested in Dez, what would you think about something like Dez for your 105, '15 1st, [NAME], and [NAME]? If that's interesting at all, let me know how we could tweak it for you to think "yah baby!"  :)
I'm not sure how that sits with you, it sort of depends on if you like veterans vs the potential of the rookies, but let's talk some more!
[NAME]
Good deal.  If you have Dez above Calvin, that makes sense.  I value [NAME] higher than most.  So if we were to add him on my side, I
would probably look for something else added on your side.  Let me know man..
Trade Rejected
Shine On You Crazy Diamond offers Year 2014 Draft Pick 2.06
Brawlin' Beards for [NAME], [NAME], [NAME]  HE TRADED WILSON TO SPEED...
Expires: Fri Mar 28 4:00:00 a.m. ET 2014
[NAME] 21 4:22:52 a.m. ET 2014
Trade Rejected
Brawlin' Beards offers [NAME], [NAME]
Shine On You Crazy Diamond for Year 2014 Draft Pick 1.14
Expires: Thu Mar 27 6:00:00 p.m. ET 2014
[NAME] 20 6:23:17 p.m. ET 2014
Trade Rejected
Shine On You Crazy Diamond offers Year 2014 Draft Pick 2.01;Year 2014 Draft Pick 2.06
Brawlin' Beards for Year 2014 Draft Pick 1.05
Expires: Thu Mar 20 10:00:00 a.m. ET 2014
3-29: round and Round with [NAME], finally went with his [NAME] for [NAME] and my 2.06.  I like [NAME], so does Chad!
3-20-14, [NAME] likes up to 14, Chad likes up to 16, maybe even 18
2.03 (15) might be Moncrief or [NAME]!
Spreadsheet: 744838d1629477790-if-function-less-than-and-greater-than-help-acrylicbox
Sheet: SCRIPT

1 | 1
2 | 1
3 | 1
4 | 1
5 | 1
6 | 1
7 | 1
8 | 1
9 | 1
10 | 1
11 | 1
12 | 1
13 | 1
14 | 1
15 | 1
16 | 1.3
17 | 1.3
18 | 1.3
19 | 1.3
20 | 1.3
21 | 1.45
22 | 1.45
23 | 1.45
24 | 1.45
25 | 1.45
 | 1.45
 | 1.45
 | 1.45
 | 1.45
 | 1.45
Spreadsheet: 704943d1605813786-extract-milliseconds-seconds-and-minutes-from-time-difference-value-rounded-down-example-problem
Sheet: Sheet1

Checkpoints |  | Frame Point | Frame Count | Frame Sum | Frame Reference
0-Start |  | 00:20:24.130000 | - | - | 2
1- Artery vs Vein |  | 00:20:35.200000
2- Venous Puncture |  | 00:23:17.050000
3- [NAME] |  | 00:24:32.290000 |  |  | -
 |  | These values should read 41 and 15 respectively (Minutes rounded DOWN) as I am extracting the milliseconds, seconds, minutes independently
 | to seconds | minutes | min as sec | [NAME] | millisec