tianzl66/Sheetpedia huggingface dataset:
Spreadsheet: 125495d1319059736-creating-a-long-range-calendar-in-excel-calendar-sample
Sheet: Data

DATE | EVENT | TIME | [NAME] | REMARKS
2011-10-05 00:00:00 | TAA Offsite | TBD | VTC | MC Branch Rep
2011-10-06 00:00:00 | TAA Offsite | TBD | VTC | MC Branch Rep
2011-10-07 00:00:00 | TAA Offsite | TBD | VTC | MC Branch Rep
2011-10-06 00:00:00 | QFR IPR W3 | 1000-1130 | [NAME].
2011-10-31 00:00:00 | NIE 12.1 |  | FBTX
2011-11-01 00:00:00 | NIE 12.1 |  | FBTX
2011-11-02 00:00:00 | NIE 12.1 |  | FBTX
2011-11-03 00:00:00 | NIE 12.1 |  | FBTX
2011-11-04 00:00:00 | NIE 12.1 |  | FBTX
2011-11-05 00:00:00 | NIE 12.1 |  | FBTX
2011-11-06 00:00:00 | NIE 12.1 |  | FBTX
2011-11-07 00:00:00 | NIE 12.1 |  | FBTX
2011-11-08 00:00:00 | NIE 12.1 |  | FBTX
2011-11-09 00:00:00 | NIE 12.1 |  | FBTX
2011-11-10 00:00:00 | NIE 12.1 |  | FBTX
2011-11-11 00:00:00 | NIE 12.1 |  | FBTX
2011-11-12 00:00:00 | NIE 12.1 |  | FBTX
2011-11-13 00:00:00 | NIE 12.1 |  | FBTX
2011-11-14 00:00:00 | NIE 12.1 |  | FBTX
2011-11-15 00:00:00 | NIE 12.1 |  | FBTX
2011-11-16 00:00:00 | NIE 12.1 |  | FBTX
2011-11-17 00:00:00 | NIE 12.1 |  | FBTX
2011-11-18 00:00:00 | NIE 12.1 |  | FBTX
2011-10-17 00:00:00 | Resourcing Panel II |  | FLK
2011-10-18 00:00:00 | Resourcing Panel II |  | FLK
2011-10-19 00:00:00 | Resourcing Panel II |  | FLK
2011-10-20 00:00:00 | Resourcing Panel II |  | FLK
2011-10-21 00:00:00 | Resourcing Panel II |  | FLK
2011-10-24 00:00:00 | Unified Quest Alt. Future |  | FMcL
2011-10-25 00:00:00 | Unified Quest Alt. Future |  | FMcL
2011-10-26 00:00:00 | Unified Quest Alt. Future |  | FMcL
2011-10-27 00:00:00 | Unified Quest Alt. Future |  | FMcL
2011-10-28 00:00:00 | Unified Quest Alt. Future |  | FMcL
2011-10-31 00:00:00 | CoC Resourcing |  | FLK
2011-11-01 00:00:00 | CoC Resourcing |  | FLK
2011-11-02 00:00:00 | CoC Resourcing |  | FLK
2011-11-03 00:00:00 | CoC Resourcing |  | FLK
2011-11-04 00:00:00 | CoC Resourcing |  | FLK
2011-11-14 00:00:00 | Unified Quest A Must Do |  | FMcL
2011-11-15 00:00:00 | Unified Quest A Must Do |  | FMcL
2011-11-16 00:00:00 | Unified Quest A Must Do |  | FMcL
2011-11-17 00:00:00 | Unified Quest A Must Do |  | FMcL
2011-11-18 00:00:00 | Unified Quest A Must Do |  | FMcL
Spreadsheet: 813315d1673657507-drag-cells-and-go-every-2-cells-1-expand_torow
Sheet: S

 |  |  |  |  |  |  |  |  | Nb. Cell | 2
 |  |  |  |  |  |  |  |  |  | 5 | 6 | 7 | 8 | 9 | 10 | 11 | 12 | 13 | 14 | 15 | 16 | 17 | 18 | 19 | 20
 |  |  |  |  |  |  |  |  |  |  | 5 | 6 | 6 | 7 | 7 | 8 | 8 | 9 | 9 | 10 | 10 | 11 | 11 | 12 | 12 | 13 | 13 | 14 | 14 | 15 | 15 | 16 | 16 | 17 | 17 | 18 | 18 | 19 | 19 | 20 | 20
Spreadsheet: 686433d1594623776-stock-allocation-example-1-4-
Sheet: Sheet1

 | Stock |  |  |  | Rank |  |  |  |  |  |  |  |  |  |  | Qty to Fulfill
Code | WH1 | WH2 | WH3 |  | Store 1 | Store 2 | Store 3 | Store 4 | Store 5 | Store 6 | Store 7 | Store 8 | Store 9 | Store 10 |  | Store 1 | Store 2 | Store 3 | Store 4 | Store 5 | Store 6 | Store 7 | Store 8 | Store 9 | Store 10
K-123 | 4 | 3 | 1 |  | 1 | 2 | 6 | 4 | 5 | 3 | 8 | 7 | 9 | 10 |  | 2 | 3 | 0 | 1 | 2 | 3 | 0 | 0 | 0 | 0
[NAME] | 5 | 2 | 4 |  | 1 | 2 | 3 | 4 | 5 | 6 | 7 | 8 | 9 | 10 |  | 6 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0
K-125 | 4 | 1 | 2 |  | 2 | 3 | 4 | 5 | 6 | 1 | 7 | 8 | 9 | 10 |  | 0 | 0 | 0 | 0 | 0 | 2 | 0 | 0 | 0 | 0
[NAME] | 2 | 0 | 0 |  | 4 | 5 | 6 | 1 | 2 | 3 | 7 | 8 | 9 | 10 |  | 0 | 0 | 0 | 1 | 1 | 1 | 0 | 0 | 0 | 0
K-127 | 1 | 0 | 0 |  | 3 | 4 | 5 | 6 | 2 | 1 | 7 | 8 | 9 | 10 |  | 0 | 0 | 0 | 0 | 1 | 3 | 0 | 0 | 0 | 0
INPUT |  |  |  |  |  |  |  |  | WH STOCK |  |  |  |  |  |  | Qty left
 |  |  |  |  |  |  |  |  | BEGGINNING |  |  | ENDING |  |  |  | Store 1 | Store 2 | Store 3 | Store 4 | Store 5 | Store 6 | Store 7 | Store 8 | Store 9 | Store 10
CODE | FROM | TO | QTY |  |  |  |  |  | WH1 | WH2 | WH3 | WH1 | WH2 | WH3
Expected
CODE | FROM | TO | QTY
K-123 | WH1 | Store 1 | 2
K-123 | WH1 | Store 2 | 2
K-123 | WH2 | Store 2 | 1
K-123 | WH2 | Store 6 | 2
K-123 | WH3 | Store 6 | 1
[NAME] | WH1 | Store 1 | 5
[NAME] | WH2 | Store 1 | 1
K-125 | WH1 | Store 6 | 2
[NAME] | WH1 | Store 4 | 1
[NAME] | WH1 | Store 5 | 1
K-127 | WH1 | Store 6 | 1
Spreadsheet: 694908d1599882044-if-statement-with-multiple-conditions-book1
Sheet: Sheet1

 |  | With lookup table | Without lookup table |  |  |  |  |  | LOOKUP TABLE
 |  |  |  |  |  |  |  |  |  | Rate
 |  |  |  |  |  |  |  |  | Amount | 0 | 0.025 | 0.05 | 0.075 | 0.1 | 0.125 | 0.15 | 0.175
Amount | Rate | Com % | Com % |  |  |  |  |  | 0 | 0.04
50000 | 0.02 |  |  |  |  |  |  |  | 50001 | 0.03
 |  |  |  |  |  |  |  |  | 250001 | 0.02
 |  |  |  |  |  |  |  |  | 500001 | 0.01
Spreadsheet: 599875d1543343598-summing-numbers-based-on-multiple-conditions-across-a-range-automated-ioc-sheet-desensitized
Sheet: Team 3

Date | [NAME] |  |  |  | PI
 | Sickcall and Med Documentation |  |  |  | SSG W
 | Infection, Asepsis, & Sterile Techniques |  |  |  | SSG So
 | Medication Administration |  |  |  | [NAME]
 | Injections |  |  |  | SSG T
 | Pharmacology |  |  |  | SSG V
 | Venipuncture |  |  |  | SSG W
 | EENT Primary Care |  |  |  | SSG So
 | Respiratory Primary Care |  |  |  | [NAME]
 | Abdominal Primary Care |  |  |  | SSG T
 | Orthopedic Primary Care |  |  |  | SSG V
 | Basic Wound Primary Care |  |  |  | SSG W
 | Skin Disease Primary Care |  |  |  | SSG So
 | Primary Care Pre-Examination Review
 | Primary Care Exam
 | Intro to Battlefield Medicine |  |  |  | SSG W
 | Battlefield Communication/ Documentation |  |  |  | SSG So
 | Casualty Movement |  |  |  | [NAME]
 | Combat Medical Aid Bag |  |  |  | SSG T
 | Combat Casualty Assessment |  |  |  | SSG V
 | Control Bleeding |  |  |  | SSG W
 | Airway Management |  |  |  | SSG So
 | [NAME] Trauma |  |  |  | [NAME]
 | Shock |  |  |  | SSG T
 | Vascular Access |  |  |  | SSG V
 | Fieldcraft 1 Pre-Examination Review
 | Field Craft Exam
 | Head Injuries with Traumatic Brain Injuries |  |  |  | SSG W
 | Ocular Injuries |  |  |  | SSG So
 | Burns |  |  |  | [NAME]
 | [NAME] |  |  |  | SSG T
 | Musculoskeletal Trauma |  |  |  | SSG V
 | [NAME]
 | Field Craft 2 Exam
 | [NAME] Training |  |  |  | SSG W
 | Casualty Triage |  |  |  | SSG So
 | Suicide Prevention |  |  |  | [NAME]
 | [NAME] and Geneva Conv. |  |  |  | SSG T
 | Environmental Threat |  |  |  | SSG V
 | Fieldcraft 3 Pre-Examination Review
 | Field Craft Exam
2018-04-24 00:00:00 | Combat Caualty Assesment ( Table VIII Skills Validation
2018-04-25 00:00:00 | Combat Caualty Assesment ( Table VIII Skills Validation
2018-04-26 00:00:00 | Combat Caualty Assesment ( Table VIII Skills Validation
Spreadsheet: 117124d1312466367-correction-in-the-if-vlookup-and-index-formula-book1
Sheet: Sheet1

 |  |  |  |  |  |  |  |  | Fixed Price or T&M | FP | T&M | FP
 |  | ProjectName |  |  |  |  |  |  | Activity | X | Y | Z
Activity 1 |  | X |  |  |  |  |  |  | Documentation | 1 | 0.75 | 1
 |  | Review |  |  |  |  |  |  | Execution | 1.85 | 1.25 | 2.85
 |  |  |  |  |  |  |  |  | Review | 3 | 4 | 1.5
Activity 2 |  | X |  |  |  |  |  |  | Corrections | 0.09 | 1 | 0.75
 |  | Corrections | 1
 |  |  |  |  |  |  |  |  | Activity | X
 |  |  |  |  |  |  |  |  | Documentation
 |  |  |  |  |  |  |  |  | Execution
 |  |  |  |  |  |  |  |  | Review
 |  |  |  |  |  |  |  |  | Corrections
Spreadsheet: 816539d1675690722-sort-unique-value-over-multiple-sheets-ignoring-zeros-book2
Sheet: MON

Date: | 2023-02-06 00:00:00 |  | 2023
Virgin Part No | Painted Part No | Customer | Product | Variant | Colour | Quantity | [NAME] | Plant | Comments
 | 74500150 |  |  |  |  | 64 |  | TRACK
 | 74500140 |  |  |  |  | 65 |  | TRACK
 | 74500160 |  |  |  |  | 66 |  | TRACK
 | 74500100 |  |  |  |  | 67 |  | TRACK
 | 15707262 |  |  |  |  | 68 |  | TRACK | PRIMER ONLY ( TO BE TOP COATED IN SPRAYBAKE ON FRIDAY)
60034391 | 67402894 |  |  |  |  | 69 |  | TRACK
 | 60034963 |  |  |  |  | 70 |  | TRACK
 | 67401552 |  |  |  |  | 71 |  | TRACK | PRIMER ONLY ( TO BE TOP COATED IN SPRAYBAKE ON FRIDAY)
 |  |  |  |  |  | 72
 | 74110109 |  |  |  |  | 73 |  | BAKE
 | 74110111 |  |  |  |  | 74 |  | BAKE
 | 74110105 |  |  |  |  | 75 |  | BAKE
 | 74110107 |  |  |  |  | 76 |  | BAKE | WIPAC PROCESS REQUIRES EACH JIG TO BE PROCESSED TWICE
 | 74110106 |  |  |  |  | 77 |  | BAKE
 | 74110108 |  |  |  |  | 78 |  | BAKE
 |  |  |  | Trial Parts
Spreadsheet: 726740d1617394215-help-with-highlighting-cells-21-pallet-log-pallet-copy
Sheet: Formula

Formula of # of Signatures Per Pallet for Pallet Tags
Perfect Bound (Pink Paper)
64 pg sigs | Finish Quantity + over's + 6,000 |  | @ | 6500 | per pallet
48 pg sigs | Finish Quantity + over's + 6,000 |  | @ | 10000 | per pallet
32 pg sigs | Finish Quantity + over's + 6,000 |  | @ | 12000 | per pallet
16 pg sigs | Finish Quantity + over's + 6,000 |  | @ | 14000 | per pallet
Saddle Stitched (Green paper)
64 pg sigs | Finish Quantity + over's + 6,500 |  | @ | 6000 | per pallet
48 pg sigs | Finish Quantity + over's + 6,500 |  | @ | 9000 | per pallet
32 pg sigs | Finish Quantity + over's + 6,500 |  | @ | 11000 | per pallet
16 pg sigs | Finish Quantity + over's + 6,500 |  | @ | 13000 | per pallet
Didde
Flat sheets: | Use the same quantity as web divided by the # printed up, divided by the SPI
 | of paper, divided by 108" on pallet.
Folded 8-pg sigs: Use the same Quantity as web |  |  | @ | 16000 | per pallet | 1 sheet/pallet
Add up the # of pallets, times this by 2, and add approx.   10-30 sheets to get total number of pallets estimated.     Then add 1 copy for each envelope needed to get the amount of colored pallet tags to be printed.
Print a white sheet for each envelope                          (approx. 200-225 sheets) plus one for Staging.
Spreadsheet: 873219d1719667615-return-list-of-requirements-from-table-list-example_2024-6-29-bsb-
Sheet: Sheet1

 | Municipality
Requirements | Ann Arbor, MI | Las Vegas, NV | Saginaw, TX | [NAME], NJ | Mesquite, TX | Delaware, OH
# of adults | x |  |  | x |  | x
# of school age children | x |  | x |  | x
# on Non school age children | x |  |  | x |  | x
24 hour emergency Contact | x |  |  | x
[NAME] | x |  | x | x | x
All entity docs for parent companies |  |  | x |  | x | x
Any chemicals or discharged thru the sewer | x |  |  |  | x
APN (number) |  | x |  | x
Inspection |  | x | x | x |  | x
Business entity good standing letter |  | x |  |  | x
 |  |  |  |  |  |  |  | Municipality:
 |  |  |  |  |  |  |  | Ann Arbor, MI
 |  |  |  |  |  |  |  | Requirements:
 |  |  |  |  |  |  |  | # of school age children
 |  |  |  |  |  |  |  | # on Non school age children
 |  |  |  |  |  |  |  | 24 hour emergency Contact
 |  |  |  |  |  |  |  | [NAME]
 |  |  |  |  |  |  |  | Any chemicals or discharged thru the sewer
Spreadsheet: 119608d1314616685-average-incomes-to-matching-towns-file-for-excel-forum
Sheet: Sheet1

MEAN INCOME | Location | Average
89600 | STOCKPORT
87300 | STALYBRIDGE
87000 | WARRINGTON
87000 | WILMSLOW
85800 | WILMSLOW
85300 | WILMSLOW
85000 | WILMSLOW
84900 | WILMSLOW
50400 | WARRINGTON
50400 | WARRINGTON
50400 | WARRINGTON
57600 | Stockport
57500 | Stockport
57500 | Stockport
56800 | Stockport
56700 | Stockport
56700 | Stockport
55800 | Stockport
55500 | Stockport
55400 | STALYBRIDGE
55400 | STALYBRIDGE
55400 | STALYBRIDGE
55400 | STALYBRIDGE
55300 | STALYBRIDGE
55100 | STALYBRIDGE
55000 | STALYBRIDGE
68800 | SALFORD
68800 | SALFORD
Spreadsheet: 93a92c2f-8a8a-4506-8fed-d2b7130f2d4f
Sheet: Sheet1

Unnamed: 0 | Unnamed: 1 | Unnamed: 2 | Unnamed: 3 | Unnamed: 4
 | Risk Balanced Commodity Fund
 | Monthly Performance History
 | Inception Date | 2012-07-09 00:00:00
 |  | Class I | Class N | UBS Dow Jones
 | Date | ARCIX | ARCNX | Commodity Index
* | 2012-07-31 00:00:00 | 0.02699999999999991 | 0.02699999999999991 | 0.03248631122739276
 | 2012-08-31 00:00:00 | 0.03602726387536515 | 0.03505355404089583 | 0.01298355992804878
 | 2012-09-30 00:00:00 | 0.01597744360902253 | 0.01599247412982119 | 0.01705559998270556
 | 2012-10-31 00:00:00 | -0.0545790934320074 | -0.0537037037037037 | -0.03872880663780853
 | 2012-11-30 00:00:00 | -0.004892367906066619 | -0.005870841487279899 | 0.0005160544468780781
 | 2012-12-31 00:00:00 | -0.0294985250737464 | -0.02952755905511817 | -0.0260713221720742
 | 2013-01-31 00:00:00 | 0.04660587639311053 | 0.04665314401622722 | 0.0239726
 | 2013-02-28 00:00:00 | -0.07066795740561471 | -0.07073643410852715 | -0.04086798
 | 2013-03-31 00:00:00 | -0.01770833333333333 | -0.01876955161626692 | 0.00673825
 | 2013-04-30 00:00:00 | -0.05832449628844105 | -0.05844845908607876 | -0.02790998
 | 2013-05-31 00:00:00 | -0.013513514 | -0.013544018 | -0.02242793
 | 2013-06-30 00:00:00 | -0.04794520547945202 | -0.04805491990846678 | -0.04714576
 | 2013-07-31 00:00:00 | 0.01079136690647475 | 0.01081730769230771 | 0.01362443
 | 2013-08-31 00:00:00 | 0.03202846975088969 | 0.03210463733650415 | 0.03402301
 | 2013-09-30 00:00:00 | -0.024137931 | -0.0241935484 | -0.02554184
 | 2013-10-31 00:00:00 | -0.0070671378 | -0.0082644628 | -0.0147661928
 | 2013-11-30 00:00:00 | -0.02016607354685651 | -0.01904761904761909 | -0.008003462071515033
 | 2013-12-31 00:00:00 | 0.003631961 | 0.002427184 | 0.01239895
 | 2014-01-31 00:00:00 | -0.01085645355850418 | -0.01089588377723971 | 0.00297646201515489
 | 2014-02-28 00:00:00 | 0.12317073170732 | 0.12239902080783 | 0.06235249966429
 | * partial month return, inception date 7/9/2012
 | Risk Balanced Commodity Fund
 | [NAME]
 | Month-end Returns as of | Class I | Class N | UBS Dow Jones Commodity
 | February 28, 2014 | ARCIX | ARCNX | Index
 | 1 Year | -0.04062500067799246 | -0.04379562082868116 | -0.01841183775083699
 | 3 Years
 | 5 Years
 | 10 Years
 | Since Inception Cumulative Return | -0.07900000065087287 | -0.08300000037470545 | -0.03943982546421698
 | Since Inception Annualized Return | -0.04890993684154865 | -0.05142910422690161 | -0.02422121936274968
 | Since Inception Annualized Monthly Volatility | 0.1524453218637717 | 0.1517898801349822 | 0.09978565540830862
 | Quarter-end Returns as of | Class I | Class N | UBS Dow Jones Commodity
 | December 31, 2013 | ARCIX | ARCNX | Index
 | 1 Year | -0.1600810542916495 | -0.1622718056161442 | -0.09523320688603654
 | 3 Years
 | 5 Years
 | 10 Years
 | Since Inception Cumulative Return | -0.1710000005858585 | -0.1740000003375184 | -0.0985011202710705
 | Since Inception Annualized Return | -0.1190547961976401 | -0.1212109000920074 | -0.06769115328253228
Spreadsheet: 3b24480e-53e3-4ff5-9e67-dc1bb5e2fa11
Sheet: Sheet1

Unnamed: 0 | Unnamed: 1 | TIB-The Independent BankersBank | Unnamed: 3 | Unnamed: 4 | Unnamed: 5 | .25 cost to Price to Waive Escrows | Unnamed: 7
 |  | 350 [NAME]., [NAME] |  |  |  | LTV must be 80% or less to qualify.
 |  | [PHONE] Toll Free//[PHONE] fax
 |  | Rate Sheet Effective: |  |  | 2011-08-29 09:34:39.060000
Product: Conv-Conforming Fixed Rate 30 Year |  |  |  |  |  | Loan Level Price Adjustment
Rate | 15 Day | 30 Day | 45 Day | 60 Day |  | Price adjustments are cumulative
4.5 | 101.7 | 101.575 | 101.45 | 101.075 |  | and are added to price quote
4.375 | 101.119 | 100.994 | 100.869 | 100.494
4.25 | 100.15 | 100.025 | 99.9 | 99.525 |  | Note: | Refer To Price [NAME]
4.125 | 99.321 | 99.196 | 99.071 | 98.696 |  |  | For all Price Adjs
4 | 98.834 | 98.709 | 98.584
3.875 | 98.155 | 98.03 | 97.905
 |  |  |  |  |  | NEW!!!!!
 |  |  |  |  |  | Please note availability of
 |  |  |  |  |  | Servicing Retained Product for
 |  |  |  |  |  | Conventional Loans Only.
 |  |  |  |  |  | A .25 adjustment to SRP
 |  |  |  |  |  | Will apply.
 |  |  |  |  |  | NEW!!!!
 |  |  |  |  |  | Improved 15 day price for
 |  |  |  |  |  | Conventional Product
Product: Conv-Conforming Fixed Rate 15 Year
Rate | 15 Day | 30 Day | 45 Day | 60 Day
3.75 | 101.321 | 101.196 | 101.071 | 100.696
3.625 | 100.753 | 100.628 | 100.503 | 100.128
3.5 | 100.44 | 100.315 | 100.19 | 99.815
3.375 | 100.047 | 99.922 | 99.797 | 99.422
3.25 | 99.441 | 99.316 | 99.191
 |  |  |  |  |  | Minimum loan amount:
 |  |  |  |  |  | TIB does not have a minimum loan
 |  |  |  |  |  | loan amount, however a 1.00% price
 |  |  |  |  |  | discount will apply to loan amounts
 |  |  |  |  |  | less than $39,999.00
 |  |  |  |  |  | 2010 Conforming Loan Limits
 |  |  |  |  |  | 1 Unit-$417,000
 |  |  |  |  |  | 2 Unit-$533,850
 |  |  |  |  |  | 3 Unit-$645,300
 |  |  |  |  |  | 4 Unit-$801,950
A SERVICE RELEASE PREMIUM WILL BE PAID IN [NAME] WITH THE ATTACHED SCHEDULE.
 |  | TIB-The Independent BankersBank
 |  | 350 [NAME]., [NAME]
 |  | [PHONE] Toll Free//[PHONE] fax
 |  | Rate Sheet Effective:
 |  |  |  |  |  | Loan Level Price Adjustment
Rate | 15 Day | 30 Day | 45 Day |  |  | Price adjustments are cumulative
 |  |  |  |  |  | & adj. Made to the price quote
EXPIRATION DATES:
15 DAY | 2011-09-12 09:34:39.060000
30 DAY | 2011-09-27 09:34:39.060000
45 DAY | 2011-10-12 09:34:39.060000
60 DAY | 2011-10-27 09:34:39.060000
90 DAY | 2011-11-26 09:34:39.060000
A SERVICE RELEASE PREMIUM WILL BE PAID IN [NAME] WITH THE ATTACHED SCHEDULE.
Spreadsheet: 67258d1267833903-how-to-reference-the-result-of-a-filter-exampleworkbook
Sheet: Report

 |  |  | Retained Value | Rating
 | Segment |  |  |  |  | (Performance of Segment vs. All Segments)
 | Vehicle |  |  |  |  | (Performance of [NAME] vs. Segment)
 |  |  | Retained Value | Rating
 | Make |  |  |  |  | (Performance of Make vs. All Makes)
 | Model |  |  |  |  | (Performance of Model vs. All Models)
 | Trim |  |  |  |  | (Performance of [NAME] vs. Segment)
 |  |  | Rating | Percentile
 |  | Vehicle Score
 |  | Weighted Score |  |  |  | (Weighted Score considers Make, Model, and Segment)
Spreadsheet: 10fa9c21-bef0-4bfb-9fcd-21a2fd817624
Sheet: Current Flow

Table 2.3.1.  Current Flow Analysis
Complete the cells in gray.  Some cells have pulldown menus.  Please use if present.
Current Flow Determination Methodology: |  | Method 2 - Large Service Area
Current Flow Appendix Reference: |  | E
Metered Flow
Current Average Daily Flow via [NAME] | Current Average Daily Flow at WWTP | Percentage of Flow to WWTP from Sewershed
(gpd) | (gpd)
9059300 | 11750000
Residential Flow as Percentage of Metered Flow in Sewershed: |  | 0.8
Commercial Flow as Percentage of Metered Flow in Sewershed: |  | 0.2
Pump Runtime
Drawdown Rate (gpm): |  | 4250
Pump Runtime (hrs/day): |  | 12
Peaking Factor: |  | 3
Current Peaked Flow ([NAME]):
Method 1 - Limited Service Area
 | Bedroom Number | Total Bedrooms
 | 2
 | 3
 | 4
 | 5
Total Bedrooms in Place/County:
Total Dwelling Units:
Total Bedrooms/Dwelling Unit:
Dwelling Units in Service Area:
Flow per bedroom (gpd/bedroom):
Peaking Factor: |  | 3
Total Estimated Service Area Peaked Flow ([NAME]):
Method 2 - Large Service Area
I/I Estimation Methodology: |  | WWTP Only
WWTP ADF (gpd): |  | 3650000
WWTP Min ADF (gpd) (if applicable): |  | 3350000
Percent of LGU in WWTP Service Area:
Percent of Sewershed Service Area in WWTP Service Areaa:
 | Water ADF | WW ADF
 | (gpd) | (gpd)
Residential: | 3250000
Commercial: | 450000
Industrial: |  | 200000
Flow Commitments: |  | 300000
Infiltration/Inflow:
Peaking Factor: |  | 3
Total Estimated Peaked Current Flow (gpd):
Provide a justification for the peaking factor used above (applies to all methods but [NAME]).
The peaking factor of 3.00 was selected due to the widespread I/I issues associated with the Central Avenue Sewershed.
aIf the WWTP service area is the entire sewershed service area, then enter 100%.
Spreadsheet: 12f0ce95-b468-4c30-80c1-b9a7da7661b2
Sheet: Sheet1

Unnamed: 0 | Unnamed: 1 | Unnamed: 2 | Unnamed: 3 | Unnamed: 4 | Unnamed: 5 | Unnamed: 6 | Unnamed: 7 | Unnamed: 8 | Unnamed: 9
 |  |  | Wilks Formula Calculation Coefficients
 |  |  | Men | -216.0475144 | 16.2606339 | -0.002388645 | -0.00113732 | 7.01863e-06 | -1.291e-08
 |  |  | Women | 594.31747775582 | -27.23842536447 | 0.82112226871 | -0.00930733913 | 4.731582e-05 | -9.054e-08
 |  |  | The formula is:
 |  |  | total lifted *500/(a+b*x+c*x^2+d*x^3+e*x^4+f*x^5)
 |  |  | where x is the body weight of the lifter
 |  |  | The coefficients for men are:
 |  |  | a= -216,0475144
 |  |  | b= 16,2606339
 |  |  | c= -0,002388645
 |  |  | d= -0,00113732
 |  |  | e= 7,01863E-6
 |  |  | f= -1,291E-8
 |  |  | The coefficients for women are:
 |  |  | a= 594,[PHONE]
 |  |  | b= -27,[PHONE]
 |  |  | c= 0,[PHONE]
 |  |  | d= -0,[PHONE]
 |  |  | e= 0,[PHONE]
 |  |  | f= -0,[PHONE]
Spreadsheet: 032979cd-cc8e-4277-b2ec-9898c5b4130c
Sheet: Sheet1

[NAME]E-1- WIA EMPLOYER SERVICES (RFP #4048): PROGRAM BUDGET TEMPLATE
Date Submitted: |  |  |  |  | Date Received:
APPLICANT INFORMATION
Organization Name: |  |  |  |  | EIN Federal Tax #:
[NAME]:
Contact Name:
Telephone Number: |  |  |  |  | Fax Number:
[NAME]:
TOTAL PROGRAM OPERATING REQUEST
PERSONNEL COSTS *Note: If Personnel Costs are shared, what other programs will operate at this location?
Position/Title |  | Employee Name |  | Annual Salary |  | [NAME] |  | WIA Share  of Cost | Total Program Cost
TOTAL PERSONNEL COSTS
Additional Personnel Cost Notes:
OPERATING EXPENSES *Note: If the shared cost between Operating and Personnel exceed 20%, then explain.
Space Costs by [NAME] (SF)
Size of Space (square footage)  e.g. 2000 SF
Rental Rate including tentative improvements (square footage/month) e.g. $20/SF
Operating Expense: includes maintenance, security, utilities, liability ins., & other related costs (per square foot per month) e.g. $8/SF
Total Rate
Yearly Cost
Monthly Cost
 |  |  |  |  |  |  |  | WIA Share  of Cost | Total Program Cost
Monthly Office Space Cost by SF
General Materials & Supplies
Professional Services
Technology & Equipment
TOTAL OPERATING EXPENSES
Additional Operating Expense Notes:
DIRECT PROGAM EXPENSES
 |  |  |  |  |  | WIA Share  of Cost |  | Total Program Cost
Supplies & Materials
Travel/Transportation
Contractual Services/Consultant Time
TOTAL DIRECT PROGRAM EXPENSES
OTHER ADMINISTRATIVE & OPERATIONAL EXPENSES *Note: These costs are capped at 10%
Personnel Management
Position/Title |  | Employee Name |  | Annual Salary |  | [NAME] |  | WIA Share  of Cost | Total Program Cost
Accounting
Purchasing/Procurement
Payroll
Other Indirect Costs
TOTAL OTHER ADMINISTRATIVE & OPERATIONAL  EXPENSES
LEVERAGED FUNDS (ADMIN AND/OR PROGRAM)
 |  |  |  |  |  | Cash Contributions |  | In-Kind Contributions
Match
Federal Leveraged Resources
Non-Federal Leveraged Resources
TOTAL
Spreadsheet: 119742d1314712982-wind-shear-calculation-windshearlaw
Sheet: Sheet1

Calculation of Wind Shear Law
Height above ground level：z | 50 | m |  | Wind Shear - Power | 11.0756634324829
Roughness length：z0 | 0.5 | m
Reference height：zref | 30 | m
Reference speed：Vref | 10 | m/s
Shear exponent：α | 0.2 |  |  | Wind Shear - Log | 11.24763711505695
Wind Shear - (Power & Log) | Height above ground level：z | Power Formula | [NAME]
 | 0 | 0 | 0
 | 5 | 6.988271187715792 | 5.623818557528477
 | 10 | 8.027415617602307 | 7.316756633516292
 | 15 | 8.705505632961241 | 8.307061924012185
 | 20 | 9.221079114817277 | 9.009694709504105
 | 25 | 9.641925040026273 | 9.554699039069138
 | 30 | 10 | 10
 | 35 | 10.31310306477545 | 10.3764965978916
 | 40 | 10.59223841048812 | 10.70263278549192
 | 45 | 10.84471771197699 | 10.99030529049589
 | 50 | 11.0756634324829 | 11.24763711505695
 | 55 | 11.28881320730198 | 11.48042206599571
 | 60 | 11.48698354997035 | 11.69293807598781
 | 65 | 11.67235319329693 | 11.88843385426715
 | 70 | 11.84664452542244 | 12.06943467387941
 | 75 | 12.01124433981431 | 12.23794240555285
 | 80 | 12.16728683786411 | 12.39557086147973
 | 85 | 12.31571227570561 | 12.54364003566651
 | 90 | 12.45730939615517 | 12.68324336648371
 | 95 | 12.59274676938038 | 12.81529678907336
 | 100 | 12.72259636539392 | 12.94057519104477
Spreadsheet: 454420d1459840182-vlookup-auto-complete-a-column-48-cells-long-from-a-dropdown-box-start-time
Sheet: Sheet1

08:00:00
Spreadsheet: 285809d1387861242-need-all-sheet-to-be-change-if-i-change-the-master-sample10
Sheet: Grains

Item Number | Item Description | Packing | Brand | Category | Total
PRSELA20KG | PRESIDENT SELLA 1121 CREAM SELLA 20 KG | 20 KG | QILA | GRAINS | 991.35
QILLAG20KG | QILLA GOLD 1121 STEAMED BASMATI RICE 20 KG | 2O KG | QILA | GRAINS | 439
[NAME] | QILLA GOLD 1121 STEAMED BASMATI RICE 5 KG | 4X5KG | QILA | GRAINS | 410.75
QILLAG1KG | QILLA GOLD 1121 STEAMED BASMATI RICE 1 KG | 20X1KG | QILA | GRAINS | 205.5
PROQ003 | QILLA GOLD STEAMED BASMATI RICE 5KG+2KG | 4X5KG+2KG | QILA | GRAINS | 23.75
PROQILLA5 | QILLA GOLD BASMATI RICE | 4X5KG | QILA | GRAINS | 0.25
 |  |  |  | Total | 2070.6