tianzl66/Sheetpedia huggingface dataset:
Spreadsheet: 43077d1241679805-spreadsheet-data-to-chart-graph-help-data-to-chart-graph-help-lizzy-project1
Sheet: Summary& Chart

Age | $ Spent | Hours Spent | # of People | # of Items | Pricing
20-30 | 289 | 9 | 17 | 35 | 17
50+ | 4320.6 | 58.5 | 117 | 134 | 109
30-40 | 693.7 | 7.5 | 24 | 25 | 23
40-50 | 2078.84 | 11.25 | 39 | 45 | 35
Under 20 | 25 | 0.75 | 7 | 5 | 2
Spreadsheet: chris_germany__1934__ENA-Reliant Prepay
Sheet: Daily Activity

ENA Purchases from Reliant - February 2002
For deliveries on FGT Zone 2 & 3
[NAME] |  | [NAME][PHONE]     [EMAIL]
Backup ENA Trader |  | [NAME]  [PHONE]  [EMAIL]
[NAME] |  | [NAME]  [EMAIL]
[NAME] |  | [NAME][PHONE]  [EMAIL]
[NAME] |  | [NAME]  [PHONE]  [EMAIL]
Reliant Contracts |  | [NAME]  [PHONE]  [EMAIL]
 | Date | Volume | Price [NAME] | GD Post | Price | Total |  | Prepayments | Balance
Wed | 2002-02-06 00:00:00 | 0 |  | 0 | 0 |  |  | 22500
Thu |  | 2000 | [NAME] | 2.155 |  |  |  | 0
Fri |  | 2000 | [NAME] | 2.17 |  |  |  | 20000
Sat |  | 0 | [NAME] | 2.215 |  |  |  | 0
Sun |  | 0 | [NAME] | 2.215 |  |  |  | 0
Mon |  | 2000 | [NAME] | 2.215 |  |  |  | 0
Tue |  | 2000 | [NAME] | 2.23 |  |  |  | 0
Wed |  | 2000 | [NAME] | 2.4 |  |  |  | 0
Thu |  | 2000 | [NAME] | 2.365 |  |  |  | 26000
Fri |  | 2000 | [NAME] | 2.265 |  |  |  | 0
Sat |  | 0 | No activity | 2.175 |  |  |  | 0
Sun |  | 0 | No activity | 2.175 |  |  |  | 0
Mon |  | 0 | No activity | 2.175 |  |  |  | 0
Tue |  | 0 | No activity | 2.175 |  |  |  | 0
Wed |  | 2000 | [NAME] | 2.305 |  |  |  | 0
Thu |  | 2000 | [NAME]* | 2.48 |  |  |  | 10000
Fri |  | 0 |  | 0 |  |  |  | 0
Sat |  | 0 |  | 0 |  |  |  | 0
Sun |  | 0 |  | 0 |  |  |  | 0
Mon |  | 0 |  | 0 |  |  |  | 0
Tue |  | 0 |  | 0 |  |  |  | 0
Wed |  | 0 |  | 0 |  |  |  | 0
Thu |  | 0 |  | 0 |  |  |  | 0
 | Sum |  | Sitara Deal #1196673
 | **  Estimated Gas Daily Midpoint used for flow date indicated.
Spreadsheet: 712863d1610458082-count-ids-within-a-timescale-duplicate-ids-with-multiple-visit-dates-book1
Sheet: Sheet1

ID | Plan Start Date | Plan End Date | Date of Visit | ID2 | Days Since Previous Visit | Less than 2 weeks? |  |  |  | Report Date (w/e) | Number of visits within timescale (2 weeks)
536247 | 2019-09-26 00:00:00 | 2020-07-17 00:00:00 | 2020-03-04 00:00:00 |  |  |  |  |  |  | 2020-04-05 00:00:00
536247 | 2019-09-26 00:00:00 | 2020-07-17 00:00:00 | 2020-03-13 00:00:00 |  |  |  |  |  |  | 2020-04-12 00:00:00
536247 | 2019-09-26 00:00:00 | 2020-07-17 00:00:00 | 2020-03-17 00:00:00 |  |  |  |  |  |  | 2020-04-19 00:00:00
536247 | 2019-09-26 00:00:00 | 2020-07-17 00:00:00 | 2020-03-20 00:00:00 |  |  |  |  |  |  | 2020-04-26 00:00:00
536247 | 2019-09-26 00:00:00 | 2020-07-17 00:00:00 | 2020-03-30 00:00:00 |  |  |  |  |  |  | 2020-05-03 00:00:00
536247 | 2019-09-26 00:00:00 | 2020-07-17 00:00:00 | 2020-04-15 00:00:00 |  |  |  |  |  |  | 2020-05-10 00:00:00
536247 | 2019-09-26 00:00:00 | 2020-07-17 00:00:00 | 2020-04-22 00:00:00 |  |  |  |  |  |  | 2020-05-17 00:00:00
536247 | 2019-09-26 00:00:00 | 2020-07-17 00:00:00 | 2020-05-13 00:00:00 |  |  |  |  |  |  | 2020-05-24 00:00:00
536247 | 2019-09-26 00:00:00 | 2020-07-17 00:00:00 | 2020-05-15 00:00:00
536247 | 2019-09-26 00:00:00 | 2020-07-17 00:00:00 | 2020-05-28 00:00:00
536247 | 2019-09-26 00:00:00 | 2020-07-17 00:00:00 | 2020-06-11 00:00:00
536247 | 2019-09-26 00:00:00 | 2020-07-17 00:00:00 | 2020-09-30 00:00:00
1538276 | 2020-06-04 00:00:00 |  | 2020-06-16 00:00:00
1538276 | 2020-06-04 00:00:00 |  | 2020-06-30 00:00:00
1538276 | 2020-06-04 00:00:00 |  | 2020-07-08 00:00:00
1538276 | 2020-06-04 00:00:00 |  | 2020-07-21 00:00:00
1538276 | 2020-06-04 00:00:00 |  | 2020-08-06 00:00:00
1538276 | 2020-06-04 00:00:00 |  | 2020-08-24 00:00:00
1538276 | 2020-06-04 00:00:00 |  | 2020-09-07 00:00:00
1538276 | 2020-06-04 00:00:00 |  | 2020-09-25 00:00:00
1538276 | 2020-06-04 00:00:00 |  | 2020-10-13 00:00:00
1538276 | 2020-06-04 00:00:00 |  | 2020-10-28 00:00:00
1538276 | 2020-06-04 00:00:00 |  | 2020-11-12 00:00:00
1538276 | 2020-06-04 00:00:00 |  | 2020-12-10 00:00:00
1538276 | 2020-06-04 00:00:00 |  | 2020-12-18 00:00:00
53836623 | 2018-10-25 00:00:00 |  | 2020-03-03 00:00:00
53836623 | 2018-10-25 00:00:00 |  | 2020-03-05 00:00:00
53836623 | 2018-10-25 00:00:00 |  | 2020-03-25 00:00:00
53836623 | 2018-10-25 00:00:00 |  | 2020-04-03 00:00:00
53836623 | 2018-10-25 00:00:00 |  | 2020-04-29 00:00:00
53836623 | 2018-10-25 00:00:00 |  | 2020-04-30 00:00:00
53836623 | 2018-10-25 00:00:00 |  | 2020-05-05 00:00:00
53836623 | 2018-10-25 00:00:00 |  | 2020-05-11 00:00:00
53836623 | 2018-10-25 00:00:00 |  | 2020-06-03 00:00:00
53836623 | 2018-10-25 00:00:00 |  | 2020-06-08 00:00:00
53836623 | 2018-10-25 00:00:00 |  | 2020-06-12 00:00:00
53836623 | 2018-10-25 00:00:00 |  | 2020-06-16 00:00:00
Spreadsheet: 757266d1638172515-formula-to-calculate-average-sample-file
Sheet: Sheet1

Name | Score | Expected Score | Comments
[NAME] | 3 |  |  |  | 3
[NAME] | 2 |  | Repeated 4 times, hence took avg score |  | 3.25
[NAME] | 3 |  | Repeated 3 times, hence took avg score |  | 4
[NAME] | 2 |  | Repeated 4 times, hence took avg score |  | 3.25
[NAME] | 5 |  | Repeated 3 times, hence took avg score |  | 4
[NAME] | 4 |  | Repeated 4 times, hence took avg score |  | 3.25
[NAME] | 4 |  | Repeated 3 times, hence took avg score |  | 4
[NAME] | 4 |  |  |  | 4
[NAME] | 5 |  | Repeated 4 times, hence took avg score |  | 3.25
Spreadsheet: 101684d1299765494-complex-lookup-budget
Sheet: Hrs & Pos

 |  |  |  | A555 | FFS | A566 | Total | A555 | FFS | A566 | Total
 | Titles | G/L Acct | Pos / Hours | HGH | HGH | HGH [NAME] | HGH | MSR | MSR | MSR [NAME] | MSR
1 | Executive Director | 410A | # of Pos | 1
 |  |  | Hours / Week - 35
 |  |  | Weeks / Year - 52
 |  |  | Paid Hours/Year
 |  |  | Backfill - N
 |  |  | Worked Hours/Year
2 | Director, Finance & Administration | 410A | # of Pos |  | 1
 |  |  | Hours / Week - 35
 |  |  | Weeks / Year - 52
 |  |  | Paid Hours/Year
 |  |  | Backfill - N
 |  |  | Worked Hours/Year
3 | Manager - Fee for Service | 410A | # of Pos
 |  |  | Hours / Week - 35
 |  |  | Weeks / Year - 52
 |  |  | Paid Hours/Year
 |  |  | Backfill - N
 |  |  | Worked Hours/Year
4 | Manager  - Justice | 410A | # of Pos |  |  | 5
 |  |  | Hours / Week - 35
 |  |  | Weeks / Year - 52
 |  |  | Paid Hours/Year
 |  |  | Backfill - N
 |  |  | Worked Hours/Year
5 | Manager  - Mental Health | 410A | # of Pos |  |  | 10
 |  |  | Hours / Week - 35
 |  |  | Weeks / Year - 52
 |  |  | Paid Hours/Year
 |  |  | Backfill - N
 |  |  | Worked Hours/Year
6 | Manager  - Respite | 410A | # of Pos
 |  |  | Hours / Week - 35
 |  |  | Weeks / Year - 52
 |  |  | Paid Hours/Year
 |  |  | Backfill - N
 |  |  | Worked Hours/Year
Spreadsheet: 115297d1310953247-please-help-with-linking-data-from-one-table-to-another-copy_for_testing-chadoak-delivery-plan
Sheet: Office

 |  |  | Office Staff
 | group |  |  |  | cert |  |  | enrolled y/n
1 | 2 | [NAME] | FROILAND | MECHANIC | 4 | Office | 23_6_11
2 | 2 | [NAME] | GRIFFIN | MANAGING DIRECTOR | 4 | Office | 28_6_11
4 | 1 | [NAME] | GRIFFIN | OPERATIONS DIRECTOR | 4 | Office
5 | 2 | [NAME] | ROSS | ESTIMATOR | 4 | Office | 23_6_11
6 | 1 | SHANNON | TAYLOR | CONTRACT ADMINISTRATOR | 4 | Office | 23_6_11
7 | 2 | MAREE | WOOD | BACKFLOW MANAGER | 4 | Office | 23_6_11
8 | 1 | [NAME] | Hague | Office | dip | Office
9 | 1 | BRIAN | BRANDENBURG | OFFICE AND ACCOUNTING MANAGER | dip | Office | 28_6_11
10 | 2 | SHANNON | SMITH | ESTIMATOR | dip | Office | 23_6_11
11 | 1 | TERRI | DUNN | BUSINESS ADMIN GRADE 5 | dip | Office | 23_6_11
12 | 1 | Radika | Heenpellage | Accounting | dip | Office | 23_6_11
13 | 2 | TRAVIS | THORGERSEN | DRAFTSMAN | dip | Office | 23_6_11
14 | 1 | MONIQUE | KUREK | [NAME] Officer [NAME] | dip | Office
 | 2 | Nero | Sattambiralalage | IT SUPPORT | dip | Office
Spreadsheet: 132239d1323633204-extract-data-into-master-work-sheet-given-format
Sheet: MW-3

LOW FLOW SAMPLING
FIELD DATA SHEETS
 |  |  | Client:
 | Site:
 | Date: |  |  | 2011-11-15 00:00:00
 |  |  | Monitoring Well #: | MW-3 |  |  |  | Well Depth: | 18.4 |  | ft |  |  | Screened/Open Interval: | 3-18' |  | ft
 |  |  | Well Permit #: |  |  |  |  | Well Diameter: | 2 |  | inches
 | PID Readings (ppm)
 |  |  |  | Background: |  | 0 |  |  | Pump Intake Depth: |  |  | 11.5 |  |  | ft below TOC
 |  |  |  | [NAME]: |  | 0 |  |  |  |  |  |  | Depth to Water Before Pump Installation: | 3.48 |  | ft below TOC
 |  |  |  | Beneath Inner Cap: |  | 0 |  |  |  |  |  |  | [NAME] | stainless steel submersible pump
 | TIME | Purging | Sampling |  |  |  |  | Specific |  | Dissolved |  | Redox |  |  |  |  | Depth to
 |  |  |  | pH |  | Temperature |  | Conductivity |  | [NAME] |  | Potential |  | Turbidity |  | Pumping | Water
 |  |  |  | (pH units) |  | (oC) |  | (uS/cm) |  | (mg/L) |  | (mV) |  | (NTU) |  | Rate | (ft below
 |  |  |  | Reading | Change | Reading | Change | Reading | Change | Reading | Change | Reading | Change | Reading | Change | (ml/min) | TOC)
 | 1120 | x |  | 6.98 | NA | 19.57 | NA | 1369 | NA | 0.31 | NA | 185.3 | NA | 13.2 | NA | 210 | 3.72
 | 1125 | x |  | 6.98 |  | 19.6 |  | 1370 |  | 0.24 |  | 177.4 |  | 10.21 |  | 210 | 3.72
 | 1130 | x |  | 6.98 |  | 19.7 |  | 1370 |  | 0.25 |  | 170.7 |  | 9.3 |  | 210 | 3.75
 | 1135 | x |  | 6.98 |  | 19.6 |  | 1371 |  | 0.23 |  | 154.9 |  | 10.42 |  | 210 | 3.77
 | 1140 | x |  | 6.98 |  | 16.6 |  | 1375 |  | 0.17 |  | 138.5 |  | 9.13 |  | 210 | 3.77
 | 1145 | x |  | 6.98 |  | 19.6 |  | 1380 |  | 0.15 |  | 128.4 |  | 8.09 |  | 210 | 3.77
 | 1150 | x |  | 6.98 |  | 19.6 |  | 1379 |  | 0.14 |  | 125.3 |  | 7.97 |  | 210 | 3.77
 | 1155 | x |  | 6.98 |  | 19.6 |  | 1375 |  | 0.14 |  | 128.6 |  | 7.99 |  | 210 | 3.77
 | Comments:
 |  | Purge start: |  |  | 11:12:00 |  |  | Sample time: |  | 11:57:00
 |  | Purge end: |  |  | 11:55:00
 | *INDICATOR PARAMETERS HAVE STABILIZED WHEN 3 CONSECUTIVE READINGS ARE WITHIN: + 0.1 for pH; + 3% for Specific Conductivity and
 | Temperature; + 10 mV for Redox Potential; and + 10% for [NAME] and Turbidity
Spreadsheet: 51932116-45da-457b-a0e9-3ab98e5e534e
Sheet: BP Training BiH

 |  | TRAINING BUDGET TEMPLATE | 1 Workshop
 |  | Training Title: | Business plan development
 |  | Country | BiH | NP Hutovo blato (+ NP Sutjeska participants)
 |  | Regional BP development Lead
 |  | PROJECT STAFF PARTICIPANTS
 | Ref. | ITEM Description |  | number man/days | daily cost | Total cost
 | 1 | Honorare/Personal
 | 1.2 | Training local coordination: x days X Euro
 | 1.3 | External Trainers:  days x Euro
 | 1.4 | Translation fees:  days x  Euro | 2 | 1 | 300
 | 1.5 | Facilitation fees :  days X  Euro
 | Sub-total 1
 | Ref. | ITEM Description |  | number days | daily cost | Total cost
 | 2 | Rent of facilities & insurence
 | 2.1 | Meeting room  and equipment | in-kind
 | 2.2 | Translation cabine (  days x euro) |  | 1 | 53
 | 2.3 | Translation cabine transport |  | 1 | 100 | 100
 | 2.4 | Technician/operator |  | 1 | 50 | 50
 | Sub-total 2
 | Ref. | ITEM Description |  |  |  | Total cost
 | 3 | Travel costs
 |  | Local travel cost for regional project coordinator |  | 1 | 200 | 200
 |  | Local travel cost for regional BP lead |  | 1 | 200 | 200
 | 3.1 | Local travel costs for participants (30x80) | in-kind | 0 | 0 | 0
 | 3.2 | International travel costs lecturers: (Nº  lectures x [NAME] ) |  | 0 | 0 | 1100
 | 3.3 | Travel costs translater: Nº translater x Euro |  | 0 | 0 | 0
 | 3.4 | Local transport ( part x  Euro public transport) |  | 0 | 0 | 0
 | 3.5 | Local transport (Nº lecture + Nº translater x  Euro public transport) |  | 0 | 0 | 0
 | Sub-total 3
 | Ref. | ITEM Description | number participants |  |  | Total cost
 | 4 | Board and Lodging
 |  | Regional project coordinator | 1 | 2 | 32 | 64
 |  | Regional BP lead | 1 | 2 | 32 | 64
 | 4.1 | External Trainers: Nº person x Nº days x  Euro | 1 | 2 | 32 | 64
 | 4.2 | Participants: Nº participants x  days x  Euro | 20 | 1 | 32
 |  | Participants not sleeping in the hotel |  | 0 | 0 | 0
 | 4.3 | [NAME]:  days x  Euro
 | Sub-total 4
 | Ref. | ITEM Description |  | Number items | cost | Total cost
 | 7 | Printing
 | 7.1 | Documentation: Nº pax x  Euro
 | 7.2 | Certificates: Nº0 x  Euro
 | Sub-total 6
 | GRAND TOTAL
Spreadsheet: 696593d1600903397-colour-coding-based-on-multiple-variables-assets-jpjmilton-
Sheet: Sheet1

Item | Serial | Asset
Item | 1234 | 4321
Item | 1235 | 4322
Item | 1236 | 4333
Item | 1237 | 4324
Item | 1230 | 4325
Item | 1239 | 4326
Spreadsheet: 758598d1638965865-rand-names-on-exact-date-randon-names-list-aligw
Sheet: Sheet1

Number: | 2
Date: | 2021-12-01 00:00:00
Name: | Date: |  | Results:
[NAME] | 2021-12-01 00:00:00
Anne | 2021-12-01 00:00:00
[NAME] | 2021-12-01 00:00:00
Mark | 2021-12-01 00:00:00
[NAME] | 2021-12-02 00:00:00
[NAME] | 2021-12-02 00:00:00
[NAME] | 2021-12-02 00:00:00
[NAME] | 2021-12-03 00:00:00
[NAME] | 2021-12-03 00:00:00
[NAME] | 2021-12-03 00:00:00
Spreadsheet: 734766d1622471428-how-to-apply-appropriate-discount-from-a-grid-when-its-based-on-several-factors-fruit-1-
Sheet: Sheet1

 |  |  |  |  |  |  | Discount table
Product | Ordering Location | Price per unit | Quantity | Price after Discount |  |  |  | Ordering Locations
Apple | 1 | 2 | 6 |  |  |  | Product | 1 | 2 | 3
Apple | 2 | 2 | 8 |  |  |  | Apple | 0.05 | 0.2 | 0.2
Apple | 3 | 2 | 9 |  |  |  | Pear | 0.2 | 0.05 | 0.2
Pear | 1 | 3 | 13 |  |  |  | Orange | 0.2 | 0.1 | 0.11
Pear | 2 | 3 | 14
Pear | 3 | 3 | 14
Orange | 1 | 1 | 7
Orange | 2 | 1 | 7
Orange | 3 | 1 | 7
Spreadsheet: 616ce6a5-2ed8-462b-be16-652d4460f8f1
Sheet: Sheet1

Permit No.: | Unnamed: 1 | WQ0018707 | Unnamed: 3 | Facility Name: | Unnamed: 5 | [NAME] | Unnamed: 7 | Unnamed: 8 | Unnamed: 9 | Unnamed: 10 | County: | Bladen | Unnamed: 13 | Month: | Unnamed: 15 | Unnamed: 16 | Year: | Unnamed: 18
PPI: |  | 001 | Flow Measuring Point: |  |  |  |  |  |  | Parameter Monitoring Point:
Parameter Code |  |  | 50050 | 00310 | 31616 | 00610 | 00625 | 00620 | 00400 | 00665 | WQ09C | 00530
Day | ORC Arrival Time | ORC Time On Site | Flow | BOD5 | Fecal Coliform | Ammonia | Total [NAME] | Nitrate | pH | Total Phosphorus | Plant Available Nitrogen | Total Suspended Solids
 | 24-hr | hrs | GPD | mg/L | #/100 mL | mg/L | mg/L | mg/L | su | mg/L | mg/L | mg/L
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
27
28
29
30
31
Average:
Daily Maximum:
Daily Minimum:
Sampling Type: |  |  | Recorder | Grab | Grab | Grab | Grab | Grab | Grab | Grab | Grab | Grab
[NAME]. Limit: |  |  | 12000
Daily Limit:
Sample Frequency: |  |  | [NAME] | 4 x Year | 4 x Year | 4 x Year | 4 x Year | 4 x Year | Weekly | 4 x Year | 4 x Year | 4 x Year
 |  | Average
 |  | Geomean
 |  | MAX/MIN
Spreadsheet: darrell_schoolcraft__7323__imball0202
Sheet: EPFS

 | El Paso/TW Eddy Rec
 | 78093
Day | Measured | Scheduled
1 | 31118 | 31456
2 | 26432 | 31456
3 | 27387 | 31394
4 | 31954 | 31456
5 | 31066 | 34456
6 | 37507 | 36936
7 | 37808 | 38956
8 | 38181 | 39034
9 | 38435 | 39956
10 | 36511 | 39956
11 | 36351 | 34319
12 | 35353 | 39956
13 | 38142 | 39956
14 | 34878 | 37956
15 | 40870 | 37956
16 | 40485 | 39956
17 | 40144 | 39956
18 | 41271 | 40108
19 | 41201 | 40108
20
21
22
23
24
25
26
27
28
29
30
31
2002-01-31 00:00:00 |  |  | 100916
2002-02-19 00:00:00
CBS Volume
 |  |  | 62232
Spreadsheet: 5299ed31-725e-434d-ba0a-c314a3bce204
Sheet: Sheet1

Date | Sport | Opponent | Time_Results
01/23/2010 | Women's Tennis | YOUNGSTOWN STATE | W, 5-1
01/29/2010 | Women's Tennis | Liberty | W, 5-2
01/31/2010 | Women's Tennis | [NAME] | W, 4-3
02/05/2010 | Women's Tennis | at [NAME] | L, 7-0
02/06/2010 | Women's Tennis | vs. Miami (Ohio) | L, 6-1
02/07/2010 | Women's Tennis | at Eastern Kentucky | W, 4-3
02/10/2010 | Women's Tennis | at Pitt | W, 5-2
02/19/2010 | Women's Tennis | GEORGETOWN | W, 4-3
[NAME] | Women's Tennis | vs. Connecticut | W, 6-1
02/28/2010 | Women's Tennis | at Cincinnati | W, 5-2
[NAME] | Women's Tennis | Morehead State | W, 6-1
[NAME] | Women's Tennis | at West Virginia State | W, 6-1
03/14/2010 | Women's Tennis | CALIFORNIA, PA. | W, 4-3
03/16/2010 | Women's Tennis | COASTAL CAROLINA | W, 4-3
03/20/2010 | Women's Tennis | at Missouri | L, 6-1
03/21/2010 | Women's Tennis | vs. Houston | W, 4-3
04/02/2010 | Women's Tennis | at Chicago State | L, 5-2
[NAME] | Women's Tennis | at DePaul | L, 6-1
04/10/2010 | Women's Tennis | at Seton Hall | W, 6-1
[NAME] | Women's Tennis | DUQUESNE | W, 6-1
04/16/2010 | Women's Tennis | at Villanova | W, 4-0
[NAME] | Women's Tennis | at Rutgers | L, 6-1
04/22/2010 | Women's Tennis | Cincinnati (BIG EAST Championships) | W, 4-2
04/23/2010 | Women's Tennis | [NAME] (BIG EAST Championships) | L, 4-0
Spreadsheet: 781044d1652955466-lookup-value-in-nth-occurence-without-using-arrays-with-multiple-criteria-vloookup-nth-occurence
Sheet: VLOOOKUP Nth OCCURENCE

 | DATA |  |  | OUTPUT
 | Emp ID | REMARK |  | Emp ID | REMARK
 | 100 |  |  | 100 | A | Using VLOOKUP this will give blank results so how do we get the first Text Value ignoring BLANK and " " Values in the cells
 | 100 |  |  | 200 | B
 | 100 | A |  | 300 | C
 | 100
 | 100
 | 200 | B
 | 200
 | 200
 | 300
 | 300
 | 300
 | 300 | C
Spreadsheet: 685247d1593844152-sumifs-problem-sum-by-column-header-aligw
Sheet: Summary Tracking

Start date | 2020-07-01 00:00:00
Starting Balance | 123
Date | 2020-07-01 00:00:00 | 2020-08-01 00:00:00 | 2020-08-08 00:00:00 | 15/08/2020 | 22/08/2020 | 29/08/2020 | 2020-09-05 00:00:00 | 2020-09-12 00:00:00 | 19/09/2020 | 26/09/2020 | 2020-10-03 00:00:00 | 2020-10-10 00:00:00 | 17/10/2020 | 24/10/2020 | 31/10/2020 | 2020-11-07 00:00:00 | 14/11/2020 | 21/11/2020 | 28/11/2020 | 2020-12-05 00:00:00 | 2020-12-12 00:00:00 | 19/12/2020 | 26/12/2020 | 2021-01-02 00:00:00 | 2021-01-09 00:00:00 | 16/01/2021 | 23/01/2021 | 30/01/2021 | 2021-02-06 00:00:00 | 13/02/2021 | 20/02/2021 | 27/02/2021 | 2021-03-06 00:00:00 | 13/03/2021 | 20/03/2021 | 27/03/2021
Income
Expenses
Forecasted Amount
Spreadsheet: 629525d1561393917-help-with-a-string-of-if-statements-sample
Sheet: Stressed Case Cashflow

 |  |  |  |  |  |  | Year 1 |  |  |  | Year 2 |  |  |  | Year 3 |  |  |  | Year 4 |  |  |  | Year 5
 |  |  |  |  |  |  | 2019-09-30 00:00:00 | 2019-12-31 00:00:00 | 2020-03-31 00:00:00 | 2020-06-30 00:00:00 | 2020-09-30 00:00:00 | 2020-12-31 00:00:00 | 2021-03-31 00:00:00 | 2021-06-30 00:00:00 | 2021-09-30 00:00:00 | 2021-12-31 00:00:00 | 2022-03-31 00:00:00 | 2022-06-30 00:00:00 | 2022-09-30 00:00:00 | 2022-12-31 00:00:00 | 2023-03-31 00:00:00 | 2023-06-30 00:00:00 | 2023-09-30 00:00:00 | 2023-12-31 00:00:00 | 2024-03-31 00:00:00 | 2024-06-30 00:00:00
Property Address | Tenant | Lease Start | Lease Break | Lease Expiry | Rent | Void (qtrs) | Q3 2019 | Q4 2019 | Q1 2020 | Q2 2020 | Q3 2020 | Q4 2020 | Q1 2021 | Q2 2021 | Q3 2021 | Q4 2021 | Q1 2022 | Q2 2022 | Q3 2022 | [NAME] | Q1 2023 | Q2 2023 | Q3 2023 | Q4 2023 | Q1 2024 | Q2 2024
 |  |  | 2022-06-30 00:00:00 | 2023-09-30 00:00:00 | 500000 | 4
 |  |  | 2022-07-01 00:00:00 | 2023-10-01 00:00:00 | 500000
 |  |  | 2022-07-02 00:00:00 | 2023-10-02 00:00:00 | 500000
 |  |  | 2022-07-03 00:00:00 | 2023-10-03 00:00:00 | 500000
 |  |  | 2022-07-04 00:00:00 | 2023-10-04 00:00:00 | 500000
Initial Loan Requirement |  |  |  | Opening Bal
Property Value |  |  |  | [NAME]
Annuity Loan Profile on |  |  |  | [NAME]
Term |  |  |  | Closing LTV
Gross Rent
Interest p.a.
Service Charges & Costs - lessee
Profit before tax
Tax Payable (estimated) @
Total Interest, Expenses & Tax
Cashflow available pre Principal Repayments p.a.
Net Cashflow Available per above
Add back interest
Cashflow available for Debt Servicing
Cashflow after Debt Servicing
Gross Interest Cover
DSCR Pre Tax
DSCR Post Tax
Surplus Cashflow Available p.a. - pre tax
Surplus Cashflow Available p.a. - post tax
Tax Calculation
Rent
Expenses
Interest
Interest Dissalowed |  |  | 0
Capital Allowance |  |  | 0
Taxable Surplus
Tax Payable @
Rent Reserve
Opening reserve |  |  |  |  |  |  | 0
Surplus Cashflow Available p.a. - post tax
Cumulative reserve
Spreadsheet: 805931d1669019504-apply-formula-based-on-the-equality-of-adjacent-cells-excelforum21-hd
Sheet: Sheet1

Barcode 1 | [NAME] apply downwards
A
A
A
A
B
B
B
B
B
B
B
C
Spreadsheet: danny_mccarty__4660__IdleAire 10-2001 Valuation
Sheet: DCF

Financial Analysis of IdleAire Technologies
 | Discounted Cash Flow Analysis
Overview: |  | · | The discounted cash flow analysis is used to calculate a range of theoretical values for IdleAire based on:
 |  |  |  | - | The net present value of IdleAire's implied annual cash flows through the year 2005
 |  |  |  | - | A terminal value for IdleAire in 2005 calculated as 5.0x times the 2005 cash flow
 |  |  |  | - | Discount rates ranging from 20% - 30%
 |  |  |  | - | Governmental grants (DOE, DOT, TVA, CMAQ etc.) are expected but not forecast
 |  | · | The range of values can then be compared to the consideration being offered in the proposed transaction
 |  | · | The projected financial data for IdleAire for calandar 2000 - 2005 is from IdleAire's 2/2001 Business Plan
 |  |  | 2001 - 2005 |  |  |  |  |  |  |  |  |  |  |  |  |  | Residual
($ millions) |  |  | TOTAL |  | 2000 |  | 2001 |  | 2002 |  | 2003 |  | 2004 |  | 2005 |  | 5
CASH FLOW PROJECTIONS
 | Revenues
 | Revenue Growth
 | Cost of Goods
 | % Revenues
 | Operating Expenses
 | % Revenues
 | Other Expense (Income)
 | % Revenues
 | Income Tax Provision
 | % Revenues
 | Capital Equipment Investments
 | Equity & Debt
NET CASH FLOW
 | 75% of Plan
 | 50% of Plan
DCF VALUATION |  |  | Rate |  | 2000 |  | 2001 |  | 2002 |  | 2003 |  | 2004
 |  |  | 0.2
 | Revenue Multiple (ltm)
 |  |  | 0.25
 | Revenue Multiple (ltm)
 |  |  | 0.3
 | Revenue Multiple (ltm)
 | 75% of Plan
 | 50% of Plan
Spreadsheet: 96045d1295524462-lookup-formula-760859_blackbadger
Sheet: Events

60mH |  | 4x100m |  | 60mH |  | High Jump
60mSprint |  | 4x200m |  | 60mSprint |  | Long Jump
200m |  | 4x400m |  | 200m |  | Pole Vault
400m |  |  |  | 400m |  | Shot
800m |  |  |  | 800m |  | Triple Jump
1500m |  |  |  | 1500m |  | Weight
3000m |  |  |  | 3000m
3000m Walk |  |  |  | 3000m Walk
High Jump
Long Jump
Pole Vault
Shot
Triple Jump
Weight
Spreadsheet: 160239d1339014775-excel-2007-multiple-if-statements-in-one-cell-apt-load-calc-bldg-
Sheet: TABLE

3 | 45
4 | 45
5 | 45
6 | 44
7 | 44
8 | 43
9 | 43
10 | 43
11 | 42
12 | 41
13 | 41
14 | 40
15 | 40
16 | 39
17 | 39
18 | 38
19 | 38
20 | 38
21 | 37
22 | 36
23 | 36
24 | 35
25 | 35
26 | 34
27 | 34
28 | 33
29 | 33
30 | 33
31 | 32
32 | 31
33 | 31
34 | 30
35 | 30
36 | 30
37 | 29
38 | 29
39 | 28
40 | 28
41 | 28
42 | 28
43 | 27
44 | 27
45 | 27
46 | 26
47 | 26
48 | 26
49 | 26
50 | 26
51 | 25
52 | 25
53 | 25
54 | 25
55 | 25
56 | 24
57 | 24
58 | 24
59 | 24
60 | 24
61 | 24
62 | 23
63 | 23
64 | 23
65 | 23
66 | 23
67 | 23
68 | 23
69 | 23
70 | 23
71 | 23
72 | 23
73 | 23
74 | 23
75 | 23
76 | 23
77 | 23
78 | 23
79 | 23
80 | 23
81 | 23
82 | 23
83 | 23
84 | 23
85 | 23
86 | 23
87 | 23
88 | 23
89 | 23
90 | 23
91 | 23
92 | 23
93 | 23
94 | 23
95 | 23
96 | 23
97 | 23
98 | 23
99 | 23
100 | 23
101 | 23