tianzl66/Sheetpedia huggingface dataset:
Spreadsheet: 165269d1341133940-i-want-the-autofill-drag-function-to-skip-some-cells-from-one-sheet-to-another-sample
Sheet: Address

 | Suhas |  | Khushi |  | Shourya |  | Anil |  | Sunil |  | Vinod
 | [NAME] |  | [NAME] |  | [NAME] |  | [NAME] |  | [NAME] |  | [NAME]
 | Solapur |  | Solapur |  | Solapur |  | Solapur |  | Solapur |  | Solapur
 | Kiran |  | Vimal |  | Anna |  | Vikas |  | Anand |  | Vinash
 | [NAME] |  | [NAME] |  | [NAME] |  | [NAME] |  | [NAME] |  | [NAME]
 | Solapur |  | Solapur |  | Solapur |  | Solapur |  | Solapur |  | Solapur
 | Suresh |  | Sunil |  | [NAME] |  | Kriti |  | Kiran |  | Kshitij
 | [NAME] |  | [NAME] |  | [NAME] |  | [NAME] |  | [NAME] |  | [NAME]
 | Solapur |  | Solapur |  | Solapur |  | Solapur |  | Solapur |  | Solapur
 | Amit |  | Sachi |  | [NAME] |  | [NAME] |  | Dev |  | [NAME]
 | [NAME] |  | [NAME] |  | [NAME] |  | [NAME] |  | [NAME] |  | [NAME]
 | Solapur |  | Solapur |  | Solapur |  | Solapur |  | Solapur |  | Solapur
 | [NAME] |  | [NAME] |  | [NAME] |  | [NAME] |  | [NAME] |  | [NAME]
 | [NAME] |  | [NAME] |  | [NAME] |  | [NAME] |  | [NAME] |  | [NAME]
 | Solapur |  | Solapur |  | Solapur |  | Solapur |  | Solapur |  | Solapur
Spreadsheet: tracy_geaccone__40536__CFNNGTWStan02
Sheet: NNG-Prelim 2002 Plan

NORTHERN NATURAL GAS GROUP
FUNDS FLOW AND NET CASH FLOW
(Millions of Dollars)
FUNDS FLOW [NAME] |  |  |  |  |  |  |  |  |  | Total Year
 | Funds Flow - 2001 Third Current Estimate |  |  |  |  |  |  |  |  | 166.1
 |  | Net Income Change (Excluding Asset Sales Impact $-5.8)
 |  | Non-Cash "Stretch" Margin Impact |  |  |  |  |  |  | -10
 |  | Increased Income Taxes |  |  |  |  |  |  | -10.7
 |  | Lower Trailblazer Distributions ($-2.2) and 2002 Expansion ($-4.5) |  |  |  |  |  |  | -6.7
 |  | Others, net
 |  | Total Variances
 | Funds Flow - 2002 Operating Plan |  |  |  |  |  |  |  |  | 132.5
NET CASH FLOW [NAME]
 | (Increase) / Decrease in Net Cash Flow - 2001 Third Current Estimate |  |  |  |  |  |  |  |  | 32.5
 |  | Net Income Change (Excluding Asset Sales Impact $-5.8)
 |  | Increased Income Taxes |  |  |  |  |  |  | -10.7
 |  | Lower Trailblazer Distributions ($-2.2) and 2002 Expansion ($-4.5) |  |  |  |  |  |  | -6.7
 |  | Higher Capital Expenditures |  |  |  |  |  |  | -37.8
 |  | Partial Base Gas Buyback (8 Bcf of 15.0 Bcf Total) |  |  |  |  |  |  | -25
 |  | Gas/Condensate Sale Revenue, Net Imbalance and Storage Gas Purchases Change |  |  |  |  |  |  | 39
 |  | Others, net
 | (Increase) / Decrease in Net Cash Flow - 2002 Operating Plan |  |  |  |  |  |  |  |  | -10.5
Spreadsheet: 215625d1361434984-if-statement-which-will-result-in-one-of-three-values-copy-book1
Sheet: Sheet1

 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | Expected | my formula
 |  |  |  |  |  |  |  |  | -2 |  |  |  |  |  | -5 | D
 |  |  |  |  |  |  |  |  | 9 |  |  |  |  |  | -3 | H
 |  |  |  |  |  |  |  |  | -7 |  |  |  |  |  | 5 | A
 |  |  |  |  |  |  |  |  | -14 |  |  |  |  |  | 15 | A
 |  |  |  |  |  |  |  |  | -6 |  |  |  |  |  | -12 | H
 |  |  |  |  |  |  |  |  | -3 |  |  |  |  |  | -7 | D
 |  |  |  |  |  |  |  |  | 11 |  |  |  |  |  | 11 | D
 |  |  |  |  |  |  |  |  | -7 |  |  |  |  |  | -4 | D
Spreadsheet: e94dc32d-8614-4f0c-9c63-32d0b3154f0b
Sheet: Sheet1

Unnamed: 0 | Unnamed: 1 | Unnamed: 2 | Unnamed: 3 | Unnamed: 4 | Unnamed: 5 | Unnamed: 6 | Unnamed: 7 | Unnamed: 8
 |  | Coffee exports from Central America, Mexico in 60-kg bags
 |  | 2010/11 | Guatemala | Honduras | Mexico | Costa Rica | Nicaragua | El Salvador
 |  | OCT | 67500 | 17784.8 | 103641 | 34003 | 46441.87 | 1101
 |  | NOV | 90037 | 39785.25 | 99661 | 50531 | 36042.7 | 25831
 |  | DEC | 181227 | 316891 | 133202 | 76321.55 | 96008.68 | 152033
 |  | JAN | 265435 | 540314 | 158182 | 137596 | 223374.72 | 215730
 |  | FEB | 373642 | 598179 | 232618 | 167731 | 175872.76 | 240611
 |  | MAR | 463699 | 560744 | 331318 | 195252.67 | 212175.17 | 278642
 |  | APR | 440012 | 559395 | 313525 | 135660.58 | 195152.92 | 228953
 |  | MAY | 465285 | 552750 | 380160 | 161938.62 | 202988.76 | 220417
 |  | JUN | 436052 | 396110 | 294473 | 125482.32 | 115118.85 | 133237
 |  | JUL | 315719 | 173726 | 256828 | 76506 | 96436.97 | 102774
 |  | AUG | 239479 | 70454 | 215247 | 34302 | 65826.12 | 78054
 |  | SEP | 314372 | 39687 | 199412 | 29333 | 23428 | 60988
 |  | Total 2010/11 | 3652459 | 3865820 | 2718267 | 1224659 | 1488868 | 1738371
 |  | 2011/12
 |  | OCT | 98348 | 17837 | 177792 | 42036 | 37443.45 | 24134
 |  | NOV | 104871 | 73510 | 171050 | 67454 | 21575.35 | 28938
 |  | DEC | 178280 | 363937 | 163190 | 78214 | 52119.55 | 82148
 |  | JAN | 244200 | 504745 | 232860 | 138425 | 108342 | 130571
 |  | FEB | 368910 | 710197 | 275863 | 173882 | 127240 | 161505
 |  | MAR | 460203 | 913497 | 326293 | 191843 | 194744 | 140372
 |  | APR
 |  | MAY
 |  | JUN
 |  | JUL
 |  | AUG
 |  | SEP
 |  | Total 2011/12 | 1454812 | 2583723 | 1347048 | 691854 | 541464 | 567668
 |  | * Some figures are preliminary and may be subject to revision
 |  | Source: national coffee organizations
Spreadsheet: bcaf6d55-29fc-4d4f-8302-2674896b1c65
Sheet: Sheet1

Unnamed: 0 | Unnamed: 1 | Unnamed: 2 | Unnamed: 3 | Unnamed: 4 | Unnamed: 5 | Unnamed: 6 | Unnamed: 7 | Unnamed: 8 | Unnamed: 9 | Unnamed: 10 | Unnamed: 11 | Unnamed: 12 | Unnamed: 13 | Note:  Completed forms should be sent | Unnamed: 15 | Unnamed: 16 | Unnamed: 17 | Unnamed: 18 | Unnamed: 19
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  | to the Business Office
[NAME] OF THE WOODS COLLEGE
CHECK REQUISITION
DATE: |  |  |  |  |  |  |  |  | Typed by: |  |  |  |  |  | Ext#:
CHECK ISSUED TO: |  |  | (PLEASE GIVE COMPLETE ADDRESS FOR MAILING) |  |  |  |  |  | Please indicate with an X
 |  |  |  |  |  |  |  |  |  |  | U.S. Mail Check
 |  |  |  |  |  |  |  |  |  |  | Campus Mail Check to: |  |  |  |  | (Dept.) |  |  | (dept.)
 |  |  |  |  |  |  |  |  |  |  | Attachment to Accompany Check
 |  |  |  |  |  |  |  |  |  |  | Hold in Business Office
 |  |  |  |  |  |  |  |  |  |  | Request use of college credit card
SSN  or ITIN:
 | (for 1099 tax purposes only):
[NAME] |  |  |  |  |  |  |  |  |  |  | VENDOR INVOICE # |  |  |  | AMOUNT
DEPARTMENTAL 14 DIGIT ACCOUNT NUMBER |  |  |  |  |  |  |  |  |  |  |  |  |  |  | AMOUNT
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 0
APPROVALS:
 |  |  |  |  |  |  |  |  |  |  | Business Office Use Only
Requested By:
 |  |  |  |  |  |  |  |  |  |  |  |  |  | Date Processed:
Department Head:
 |  |  |  |  |  |  |  |  |  |  |  |  |  | Invoice Document Number:
Cabinet Member:
 |  |  |  |  |  |  |  |  |  |  |  |  |  | Audited By:
Office of the Controller:
Spreadsheet: 528d3077-a096-4c72-be04-18a2e63361dc
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
[NAME] | Test | [NAME] | KPC (blaKPC) and NDM (blaNDM) Surveillance PCR | KPC and NDM Surveillance PCR | Real-Time Polymerase Chain Reaction (PCR) Using LightCycler and Fluorescent Resonance Energy Transfer (FRET) (PCR is utilized pursuant to a license agreement with Roche Molecular Systems, Inc.) |  |  |  |  |  | Submit only 1 of the following specimens:  Preferred: [NAME], perirectal, rectal  Collection Container/Tube: Culture transport swab  [NAME] Volume: Swab Additional Information: Specimen source is required.  Acceptable: [NAME] Stool Container/Tube: Commercially available transport system specific for recovery of enteric pathogens from fecal specimens (15 mL of non-nutritive transport medium containing phenol red as a pH indicator, either [NAME] or Para-Pak C and S) [NAME] Representative portion of stool |  | Hemolysis	NA Thawing	NA Lipemia	NA Icterus	NA Other	E-swab (pink cap), calcium alginate swab, cotton-tipped swab, swab sent in gel transport medium, swab send in viral or universal transport medium, frozen swab | Not applicable | Monday through Friday | 1 day | 4 days | 2 | 87798 |  |  |  |  | Rochester
[NAME] | [NAME] | VARIES | Varies |  |  |  | Refrigerated | 7 days
[NAME] | Order Question | SRCKP | Specimen source |  | Plain Text
[NAME] | Result | SRCKP | Specimen source | Specimen source | Alphanumeric |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 31208-2 | [NAME] source:Prid:Pt:[NAME]:Nom:
[NAME] | Result | 35165 | KPC PCR | KPC PCR | Alphanumeric |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 49617-4 | Bacterial carbapenemase resistance (bla(KPC)) gene:ACnc:Pt:Isolate:Ord:Prob.amp.tar
[NAME] | Result | 35166 | NDM PCR | NDM PCR | Alphanumeric |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 73982-1 | Bacterial carbapenemase resistance (bla(NDM)) gene:Pr:Pt:Isolate:Ord:Probe.[NAME].Tar
Spreadsheet: 697902d1601603827-ranking-based-on-criteria-test-1-
Sheet: Test

 |  |  |  |  |  |  | 2020-04-12 00:00:00
Item | Price | Category | Date | Rank
CTR_01 | 3.5 | Urgent | 2020-04-04 00:00:00
[NAME] | 3.2 | Not Urgent | 2020-04-05 00:00:00
CTR_03 | 3.44 | Not Urgent | 2020-04-06 00:00:00
CTR_04 | 3 | Urgent | 2020-04-06 00:00:00
CTR_05 | 2.1 | Urgent | 2020-04-08 00:00:00
CTR_06 | 3.4 | Urgent | 2020-04-09 00:00:00
CTR_07 | 3.2 | Urgent | 2020-04-06 00:00:00
CTR_08 | 3.44 | Urgent | 2020-05-11 00:00:00
CTR_09 | 3 | Not Urgent | 2020-04-12 00:00:00
CTR_10 | 2.1 | Not Urgent | 2020-04-06 00:00:00
CTR_11 | 3.4 | Not Urgent | 2020-05-14 00:00:00
CTR_12 | 3.2 | Not Urgent | 2020-04-15 00:00:00
CTR_13 | 3.44 | Not Urgent | 2020-04-16 00:00:00
CTR_14 | 3 | Not Urgent | 2020-04-17 00:00:00
CTR_15 | 2.1 | Not Urgent | 2020-04-18 00:00:00
CTR_16 | 3.4 | Not Urgent | 2020-04-19 00:00:00
CTR_17 | 3.2 | Urgent | 2020-04-20 00:00:00
CTR_18 | 3.44 | Urgent | 2020-04-21 00:00:00
CTR_19 | 3 | Urgent | 2020-04-06 00:00:00
CTR_20 | 2.1 | Urgent | 2020-04-23 00:00:00
Spreadsheet: 163750d1340443000-use-an-ideal-function-to-match-sample-ileasark-oeldere-
Sheet: Blad1

IS FOUND IN | CAT.
BCD1 | (leeg)
Totaal BCD1
BCD1E1 | 1
 | 3
 | 4
 | 5
 | 6
 | 11
 | 13
 | 19
Totaal BCD1E1
BCD1E2 | 4
 | 5
 | 7
 | 10
 | 14
 | 15
 | 17
 | 27
 | 29
Totaal BCD1E2
BCD2 | 25
Totaal BCD2
BCD2E1 | 8
Totaal BCD2E1
BCD2E3 | 9
 | 12
 | 16
 | 22
 | 23
 | 24
 | (leeg)
Totaal BCD2E3
BCD2E4 | 1
 | 2
 | 18
 | 20
 | 21
 | 26
 | 28
 | 30
Totaal BCD2E4
BD2E4 | 31
 | 32
[NAME]
D1 | (leeg)
Totaal D1
(leeg) | (leeg)
Totaal (leeg)
Eindtotaal
Spreadsheet: 219686d1362877984-counting-occurrences-count_occurances
Sheet: cost_inv

ET | 200
ETS | 0
HT | 150
HTS | 450
xx | 0
hindu | 250
hinduS | 350
TIS | 300
TI | 150
IE | 300
IES | 200
Spreadsheet: 864381d1711569364-grouping-2024-shipments-test
Sheet: AUG 2023

Job Number | Customer | Ship To State | Sell Price | Contract (Due) Date | Ready to Ship Date | [NAME] to Ship On Time | Invoice Request Date | LABOR BUDGET $ | TOTAL LABOR $ | LABOR VARIANCE | MATERIAL BUDGET $ | TOTAL MATERIAL $ | MATERIAL [NAME] | TOTAL COST BUDGET | TOTAL ACTUAL COST | [NAME] | ON BUDGET | "As Sold" Budget Margin % | "As Completed" Margin | Difference between Budget / Completed | FREIGHT REIM | Net Profit  (+Gain / -Loss
23-4014 | TECHNOS |  | 605 | 2023-08-09 00:00:00 | 2023-08-08 00:00:00 |  | 2023-08-10 00:00:00 | 55 | 88.91 |  | 351
23-4015 | TECHNOS |  | 1988 | 2023-08-14 00:00:00 | 2023-08-09 00:00:00 |  | 2023-08-10 00:00:00 | 220 | 176 |  | 1066
23-4010 | Bachmann (China) |  | 14020 | 2023-08-01 00:00:00 | 2023-08-01 00:00:00 |  | 2023-08-10 00:00:00 | 2640 | 2909.5 |  | 6799.08 | 4902
23-4024 | [NAME] |  | 500 | 2023-08-16 00:00:00 | 2023-08-15 00:00:00 |  | 2023-08-18 00:00:00 | 115.5 | 128.33 |  | 129 | 101.18
23-4013 | Damper & Control System |  | 4016 | 2023-08-22 00:00:00 | 2023-08-16 00:00:00 |  | 2023-08-18 00:00:00 | 1727 | 1356.67 |  | 1002 | 906.66
23-3998 | Valmet |  | 10532 | 2023-08-21 00:00:00 | 2023-08-21 00:00:00 |  | 2023-08-23 00:00:00 | 3495.25 | 2586.84 |  | 3389.2
23-4021 | Damper & Control System |  | 3848 | 2023-08-31 00:00:00 | 2023-08-22 00:00:00 |  | 2023-08-23 00:00:00 | 1446.5 | 273.17 |  | 1168 | 1136.42
23-4017 | Damper & Control System |  | 1968 | 2023-08-25 00:00:00 | 2023-08-21 00:00:00 |  | 2023-08-23 00:00:00 | 786.5 | 474.83 |  | 547 | 526.13
23-4016 | Damper & Control System |  | 1487 | 2023-08-25 00:00:00 | 2023-08-21 00:00:00 |  | 2023-08-23 00:00:00 | 588.5 | 442.75 |  | 415 | 352.18
23-4012 | Technos |  | 2518 | 2023-08-23 00:00:00 | 2023-08-22 00:00:00 |  | 2023-08-23 00:00:00 | 0 |  |  | 1399 | 1399
23-4029 | Eriks North America |  | 4150 | 2023-08-23 00:00:00 | 2023-08-23 00:00:00 |  | 2023-08-23 00:00:00 | 275 |  |  | 1221.45 | 809.44
23-4033 | Esi, Inc. of Tennessee |  | 3950 | 2023-08-28 00:00:00 | 2023-08-28 00:00:00 |  | 2023-08-28 00:00:00 |  |  |  | 2032 | 2032
23-4030 | Eriks North America |  | 3980 | 2023-08-21 00:00:00 | 2023-08-21 00:00:00 |  | 2023-08-21 00:00:00 | 55 | 198.92 |  | 1502.2
23-4022 | Bachmann (Dos Bocas Refinery) |  | 1080 | 2023-08-31 00:00:00 | 2023-08-22 00:00:00 |  | 2023-08-23 00:00:00 | 440 | 267.67 |  | 180
22-3823 | Mitsubishi Power |  | 149830 |  |  |  |  |  |  |  |  |  |  | 127355.5 | 127355.5
 |  |  |  |  |  |  | Shipments |  |  |  |  |  |  |  | As Sold Margin | As Completed Margin
Spreadsheet: 794072d1661868316-how-to-link-the-min-of-a-series-to-a-character-text-grocery-test
Sheet: Grocery Total

Fruit | *Cheapest fruit name* | *Cheapest fruit cost*
Meat | *Cheapest meat name* | *Cheapest meat cost*
 | Total | =Sum of all groceries
Fruit |  | ='Fruit'!F3
Meat |  | ='Meat'!F3
 | Total | 7
Fruit | Apple | 2
Meat | [NAME] | 5
 | Total | 7
Spreadsheet: 144689d1331102402-hyperlink-vlookup-copying-different-columns-by-order-from-hyperlink-doc-to-another-book1
Sheet: Sheet1

512-15 | 200 | 200 | 20 |  | 2500 | TF |  | 0.8 | 2012-03-02 00:00:00 | 37 | 2012-03-02 00:00:00 | KIR
1112-14 | 180 | 100 | 100 |  | 5800 | TF |  | 1.8 | 2012-03-06 00:00:00 | 75 | 2012-03-07 00:00:00 | F-KA
112-25 | 150 | 140 | 25 |  | 1700 | TD |  | 0.525 | 2012-03-03 00:00:00 | 77 | 2012-03-06 00:00:00 | F-KA
Spreadsheet: danny_mccarty__4660__IdleAire 10-2001 Valuation
Sheet: 2-2001 Value

IDLEAIRE 2-2001 VALUATION SUMMARY
 |  | PRE-MONEY |  |  | POST-MONEY
Valuation Technique
 | Discounted Cash Flow Valuation
 | Comparable Public Company Analysis
 | Comparable Transaction Analysis
 | Average Valuation | 125900000
 | Discount | 0.25
 | New Equity |  |  |  | 10000000
 | Discounted Average Valuation
Common Shares
 | Founders | 36000000
 | Seed Investors | 3410000
 | Key Employees | 1110000
 | 1st Round Investors | 4527600
 | 2nd Round Investors
 | Public Round
 | Total Common Shares Outstanding
 | Total Prefered Shares Outstanding | 0
 | Options & Warrants
 | Fully Diluted Shares
 | Price Per Fully Diluted Share
Spreadsheet: 694435d1599597299-add-a-variable-to-a-sumproduct-sumif-formula-de-pense-nouveaux-employe-s-exemple-sumproduct
Sheet: Production

 |  |  | Modeleur
 | Shotgun |  | Shotgun
 | [NAME] |  | [NAME]
 | VPN |  | VPN
 | [NAME] |  | [NAME]
 | RV |  | RV
 | [NAME] 1 |  | Écran standard
 | [NAME] 2 |  | Écran standard
 | [NAME] 3
 | [NAME]/clavier |  | [NAME]/clavier
 | Caméra |  | Caméra
 | Headset |  | Headset
 | Intous - On request |  | Intuos
 | Amortissement - Renouveller aux 3 ans |  | Workstation MID
 | OS |  | Windows
 | Logiciels |  | Maya
 |  |  | [NAME]
 |  |  | Bulk renamer
 |  |  | 3DsMax
 | Pluggins
 | Total:
 | CAPEX |  |  | Should be 1169$ (Calculating everything in column D here if they are of type CAPEX on next page column D
 | OPEX - An
 | OPEX - 6 mois
 | OPEX - Mois
Spreadsheet: 1cd11b2c-12a7-4b11-ae84-d5354438c094
Sheet: 16b

 |  | TOTAL
Product |  | HY** | IG | Other
Index Tranche* | Asia
 | Europe
 | North America
Index | Asia
 | Europe
 | North America
TOTAL |  | N/A*** | N/A | N/A
Estimated swap dollar volumes, week ending November 16, by product type (total value of trades in millions of USD), all participant types, tenors and currencies, cleared and uncleared. Data are adjusted for double-counting of cleared trades to show a single exposure for each trade. This table will be expanded to reflect participant type as more complete data becomes available.
Total(s) may be less than total shown for this asset class in the All Swaps reports and/or other CFTC Swaps Report tables if products were excluded from this table that (a) presented disclosure risk or (b) did not belong in the categories shown.
*See Data Dictionary for product descriptions.
**See Data Dictionary for product grade descriptions.
***N/A indicates that data are not currently available.
The Commission requests feedback on the format and content of this CFTC Swaps Report table. Submit comments to [EMAIL].
Spreadsheet: 174a123a-b730-4784-8753-600da4111155
Sheet: Peter Moss

[NAME]
Fair Share Fee: Those Who Don't Pay Their Fair Share
Agree
Explain your fair share position, if you choose.
No response
Teachers' Retirement: Support in the State Budget
Agree
Explain your teachers' retirement position, if you choose.
No response
Health Care: Continuing System Reform
Agree
Explain your health care reform position, if you choose
No response
Teaching Career: Retaining New Teachers
Agree
Explain your teaching career position, if you choose
No response
Teaching Profession: Simplifying Professional Relicensing
Agree
Explain your relicensing position, if you choose
No response
Name | email address | Address | Office sought | Are you an incumbent? |  | County
[NAME] | [EMAIL] | Fairfax, VT 05454-0413 | Senate Franklin County | No |  | Franklin
Spreadsheet: 65842d1266494870-help-with-template-test
Sheet: Instructions

 | Task List
 |  |  | Orange cells contain formulas
 |  |  | Enter task information in the blue cells
 |  |  | Enter a start time for each task that you want to appear in the weekly calendar
 |  |  | Enter an estimated number of hours for each task
 |  |  | Enter an end time, or Hours, when a task has been completed.
 |  |  | To delete old tasks, clear the cells in columns B:H. Do not clear the orange cells.
 |  |  | The worksheet is protected, with no password. AutoFilter is allowed
 |  |  | Conditional formatting
 |  |  | Grey -- completed -- end time (column D) or Hours (column F) are entered
 |  |  | Green -- not completed, and activity date is next day
 |  |  | Yellow -- not completed, and activity date in the past
 |  |  | Filter/Sort Buttons
 |  |  | [NAME] -- removes the AutoFilter from the task list
 |  |  | Show All -- Removes any applied filters, and shows all tasks
 |  |  | To Do -- hides completed tasks
 |  |  | Sort -- sorts by date and start time
 | Calendar
 |  |  | Enter a start date and start time in the blue cells
 |  |  | Items from the TaskList appear in the calendar, at their start date and time
 |  |  | If there are multiple tasks for a date and time, only the first listed task will appear
 |  |  | Conditional formatting
 |  |  | Bright green -- heading for current date
 |  |  | Hidden columns
 |  |  | Except for column B, all time columns, to the left of the activity columns, are hidden
 |  |  | Date/time formula columns (P:V), used in the INDEX/MATCH formulas, are hidden
Spreadsheet: 806219d1669172972-rolling-average-excluding-blank-cells-but-including-zeros-rolling-average-excluding-blank-cells-but-including-zeros
Sheet: Sheet1 (2)

ID | VALUE | val_roll_ave | REQUIRED |  |  |  |  |  | Average Same ID | Average Last 15 items Same ID | Count ID, cap @ 15 | Count ID="" | Combined formulas in L & M | Replace "15" in formula in K with formula in N
1 | 123 |  | 123.2739130434782
1 | 8 |  | 65.72695652173913
1 | 42 |  | 57.75685990338164 |  |  |  |  |  |  |  |  |  |  |  |  | Rolling Average excluding blank cells but including zeros
1 |  |  |  | <--- should ignore the blank cell B5 |  |  |  |  |  |  |  |  |  |  |  | https://www.excelforum.com/excel-formulas-and-functions/1394086-rolling-average-excluding-blank-cells-but-including-zeros.html#post5757884
1 | 0 |  |  | <--- should include the 0 in cell [NAME]
1 | 7
1 | 90
1
1 | 13
2 | 121.5333333333333
2 | 39.25
2 | 53.47692307692309
2 | 15.4
2 | 0
2 | 62.0611111111111
2 | 35.8
2 | 70.07499999999999
2 | 49.56666666666666
2 | 126.6560606060606
2 | 23.06666666666667
2 | 126.6560606060606
2 | 23.06666666666667
2 | 177.1351724137931
2 | 8.4
2 | 12
2 |  |  |  | <--- should ignore the blank cell B27
2 | 110
2 | 0 |  |  | <--- should include the 0 in cell B29
2
Spreadsheet: 179235d1347091549-generating-sets-of-random-real-numbers-sample-pgee
Sheet: Sheet1

 | Example of Variables | Additional Notes | Example of Results |  |  | Example of Results
Number of Random Numbers per Set | 5 | Could be up to 30 |  |  | AVG
Average | 5 | Could be any real number | 5.89 | 6
Lowest Random Number | 1 | Could be any real number | 4.5 | 3
Highest Random Number | 8 | Could be any real number | 3.25 | 5.2
Number of Sets | 2 | Could be up to 50 | 3.4 | 4.89
 |  |  | 8 | 5.7
Spreadsheet: darrell_schoolcraft__7325__imball0202
Sheet: williams

 | Milagro |  | La Maquina |  | [NAME] |  | [NAME]
Day | Measured | Scheduled | Measured | Scheduled | Measured | Scheduled | Measured | Scheduled |  |  |  |  |  |  |  | San Juan
1 | 348740 | 348593 | 44952 | 39832 | 34864 | 38368 | 138333 | 132994 |  |  |  | Month | Measured | Scheduled | Imbalance | Index | Amount
2 | 326868 | 331402 | 44933 | 40489 | 36801 | 38316 | 105582 | 103708 |  |  |  | [NAME] |  |  | -34361 |  | 25006
3 | 327137 | 330848 | 45018 | 40410 | 34501 | 39399 | 111726 | 105510 |  |  |  | 2000-12-01 00:00:00 | 19698194 | 19662410 |  | 7.95
4 | 327600 | 330450 | 31087 | 40426 | 42627 | 39399 | 126063 | 126994 |  |  |  | 2001-01-01 00:00:00 | 18949781 | 18975457 |  | 8.1
5 | 305375 | 307821 | 35408 | 35617 | 42536 | 40399 | 135758 | 134714 |  |  |  | 2001-02-01 00:00:00 | 15256233 | 15290953 |  | 5.61
6 | 328360 | 331758 | 32048 | 35617 | 44703 | 37058 | 132131 | 131043 |  |  |  | 2001-03-01 00:00:00 | 17049350 | 17089226 |  | 4.87
7 | 319506 | 320155 | 23179 | 22626 | 38348 | 37079 | 129327 | 126563 |  |  |  | 2001-04-01 00:00:00 | 17652369 | 17743987 |  | 4.62
8 | 286158 | 281186 | 22743 | 22671 | 38426 | 40918 | 111115 | 111192 |  |  |  | 2001-05-01 00:00:00 | 16124989 | 16282021 |  | 3.44
9 | 302691 | 299195 | 19977 | 22175 | 40192 | 40918 | 124988 | 121550 |  |  |  | 2001-06-01 00:00:00 | 15928675 | 15936227 |  | 2.58
10 | 294278 | 299195 | 22860 | 22094 | 42910 | 40918 | 128025 | 125624 |  |  |  | 2001-07-01 00:00:00 | 16669639 | 16693576 |  | 2.45
11 | 308297 | 314941 | 23014 | 21854 | 38296 | 34629 | 136518 | 133999 |  |  |  | 2001-08-01 00:00:00 | 17850737 | 17815859 |  | 2.61
12 | 323009 | 340013 | 23025 | 21500 | 48171 | 28668 | 119665 | 121497 |  |  |  | 2001-09-01 00:00:00 | 16552948 | 16508018 |  | 1.73
13 | 251547 | 255068 | 22924 | 11153 | 34346 | 29840 | 120632 | 119766 |  |  |  | 2001-10-01 00:00:00 | 17924814 | 17872479 |  | 2.06
14 | 302986 | 300798 | 23089 | 12065 | 30114 | 36168 | 118174 | 128285 |  |  |  | 2001-11-01 00:00:00 |  |  |  | 1.98
15 | 320781 | 321683 | 7129 | 11514 | 33386 | 33898 | 132774 | 133680 |  |  |  | 2001-12-04 00:00:00
16 | 294339 | 291714 |  | 4943 | 38975 | 35013 | 131155 | 131546
17 | 290904 | 293264 |  | 4862 | 36131 | 36168 | 126129 | 119066
18 | 305922 | 303311 |  | 4930 | 35067 | 35103 | 117947 | 116578
19 | 301503 | 302180 |  | 4734 | 35148 | 35103 | 120094 | 125238 |  |  |  |  |  |  | 1.98
20 | 265715 | 289822 |  | 5170 | 59179 | 62347 | 132402 | 145053 |  |  |  |  | 1378106 | 1316146
21 | 303431 | 284670 |  | 2659 | 66982 | 79878 | 136456 | 140810 |  |  |  |  | 9216070 | 9272400
22 | 310222 | 298119 |  | 6484 | 37553 | 41168 | 113554 | 115219 |  |  |  |  | 3546065 | 3512740
23 | 301877 | 297710 |  | 4609 | 38106 | 41168 | 108993 | 102575 |  |  |  |  | 1623705 | 1620245
24
25
26
27
28
29
30
31
2002-01-31 00:00:00
2002-02-23 00:00:00
CBS Dollars
 |  |  | 300359.04
 |  |  | -250735.54
 |  |  | 44931.54
 |  |  | 2153062.32
 |  |  | 0.0238
 |  |  | 0.0153
 |  |  | 2444.99
 |  |  | 250