tianzl66/Sheetpedia huggingface dataset:
Spreadsheet: 96732d1296049119-stuck-lookup-help-tcc-new-final-left
Sheet: wk18

Tuesday
06:00:00 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | Rank | Name | Night
Rank | Player | Sets Won | Score |  | Sets Won | Player | Rank |  | MW | ML | GW | GL | GB | SB | Points |  | 1
1 |  |  |  |  |  |  | 2
3 |  |  |  |  |  |  | 4
Rank | Player | Sets Won | Score |  | Sets Won | Player | Rank |  | MW | ML | GW | GL | GB | SB | Points
5 |  |  |  |  |  |  | 6
7 |  |  |  |  |  |  | 8
07:20:00
Rank | Player | Sets Won | Score |  | Sets Won | Player | Rank |  | MW | ML | GW | GL | GB | SB | Points
9 |  |  |  |  |  |  | 10
11 |  |  |  |  |  |  | 12
Rank | Player | Sets Won | Score |  | Sets Won | Player | Rank |  | MW | ML | GW | GL | GB | SB | Points
13 |  |  |  |  |  |  | 14
15 |  |  |  |  |  |  | 16
08:40:00
Rank | Player | Sets Won | Score |  | Sets Won | Player | Rank |  | MW | ML | GW | GL | GB | SB | Points
17 |  |  |  |  |  |  | 18
19 |  |  |  |  |  |  | 20
Rank | Player | Sets Won | Score |  | Sets Won | Player | Rank |  | MW | ML | GW | GL | GB | SB | Points
21 |  |  |  |  |  |  | 22
23 |  |  |  |  |  |  | 24
Wednesday
06:00:00
Rank | Player | Sets Won | Score |  | Sets Won | Player | Rank |  | MW | ML | GW | GL | GB | SB | Points
25 |  |  |  |  |  |  | 26
27 |  |  |  |  |  |  | 28
Rank | Player | Sets Won | Score |  | Sets Won | Player | Rank |  | MW | ML | GW | GL | GB | SB | Points
29 |  |  |  |  |  |  | 30
31 |  |  |  |  |  |  | 32
07:20:00
Rank | Player | Sets Won | Score |  | Sets Won | Player | Rank |  | MW | ML | GW | GL | GB | SB | Points
33 |  |  |  |  |  |  | 34
35 |  |  |  |  |  |  | 36
Rank | Player | Sets Won | Score |  | Sets Won | Player | Rank |  | MW | ML | GW | GL | GB | SB | Points
37 |  |  |  |  |  |  | 38
39 |  |  |  |  |  |  | 40
08:40:00
Rank | Player | Sets Won | Score |  | Sets Won | Player | Rank |  | MW | ML | GW | GL | GB | SB | Points
41 |  |  |  |  |  |  | 42
43 |  |  |  |  |  |  | 44
Rank | Player | Sets Won | Score |  | Sets Won | Player | Rank |  | MW | ML | GW | GL | GB | SB | Points
45 |  |  |  |  |  |  | 46
47 |  |  |  |  |  |  | 48
Thursday
06:00:00
Rank | Player | Sets Won | Score |  | Sets Won | Player | Rank |  | MW | ML | GW | GL | GB | SB | Points
49 |  |  |  |  |  |  | 50
51 |  |  |  |  |  |  | 52
Rank | Player | Sets Won | Score |  | Sets Won | Player | Rank |  | MW | ML | GW | GL | GB | SB | Points
53 |  |  |  |  |  |  | 54
55 |  |  |  |  |  |  | 56
07:20:00
Rank | Player | Sets Won | Score |  | Sets Won | Player | Rank |  | MW | ML | GW | GL | GB | SB | Points
57 |  |  |  |  |  |  | 58
59 |  |  |  |  |  |  | 60
Rank | Player | Sets Won | Score |  | Sets Won | Player | Rank |  | MW | ML | GW | GL | GB | SB | Points
61 |  |  |  |  |  |  | 62
63 |  |  |  |  |  |  | 64
08:40:00
Rank | Player | Sets Won | Score |  | Sets Won | Player | Rank |  | MW | ML | GW | GL | GB | SB | Points
65 |  |  |  |  |  |  | 66
67 |  |  |  |  |  |  | 68
Rank | Player | Sets Won | Score |  | Sets Won | Player | Rank |  | MW | ML | GW | GL | GB | SB | Points
69 |  |  |  |  |  |  | 70
71 |  |  |  |  |  |  | 72
Spreadsheet: 746639d1630925852-calculate-number-of-nights-excel-forum-number-of-nights
Sheet: Number of Nights

Calculate the number of nights correctly while identifying different nights on previous dates
 |  | Raw Data |  |  |  |  |  |  | [NAME]
 |  | Date | Name | Location | Type | House or Hotel | # of Rooms | Rooms | HelpNewAcc |  | Gapfree Cities | Gapfree Acoomodatons | Type | Gapfree Rooms | HelpNights | Help Nights | HelpNights2 | Nights | CountHouse | CountHotel |  |  |  | I want the formula to calculate the correct number of nights per destination and House (the concatenate could look for something else). The [NAME] should recognize that each visit is unique (even if the person goes to the same location twice during the whole trip)
 | 1 | 2022-08-20 00:00:00 | House | New York | NewHome | House | 1 | Roomcategory: 2x [NAME] with Breakfast | 1
 | 2 | 2022-08-21 00:00:00 | House | New York | NewHome | House | 1 | Roomcategory: 2x [NAME] with Breakfast
 | 3 | 2022-08-22 00:00:00 | House | New York | NewHome | House | 1 | Roomcategory: 2x [NAME] with Breakfast
 | 4 | 2022-08-23 00:00:00 | House | Philadephia | PhiliHouse | House | 1 | Roomcategory: 2x [NAME] with Breakfast
 | 5 | 2022-08-24 00:00:00 | House | Washington | DCPlaza | House | 1 | Roomcategory: 2x [NAME] with Breakfast
 | 6 | 2022-08-25 00:00:00 | Hotel Awesomesauce | Baltimore | Hotel Awesomesauce | Hotel | 1 | Zimmerkategorie: 2x Classic Doppelzimmer Breakfast
 | 7 | 2022-08-26 00:00:00 | House | Baltimore | [NAME] | House | 1 | Roomcategory: 2x [NAME] with Breakfast
 | 8 | 2022-08-27 00:00:00 | House | Baltimore | [NAME] | House | 1 | Roomcategory: 2x [NAME] with Breakfast
 | 9 | 2022-08-28 00:00:00 | House | Washington | DCPlaza | House | 1 | Roomcategory: 2x [NAME] with Breakfast
 | 10 | 2022-08-29 00:00:00 | House | Washington | DCPlaza | House | 1 | Roomcategory: 2x [NAME] with Breakfast
 | 11 | 2022-08-30 00:00:00 | House | Baltimore | Baltimouse | House | 1 | Roomcategory: 2x [NAME] with Breakfast
 | 12 | 2022-08-31 00:00:00 | House | Baltimore | [NAME] | House | 1 | Roomcategory: 2x [NAME] with Breakfast
 | 13 | 2022-09-01 00:00:00 | House | Baltimore | [NAME] | House | 1 | Roomcategory: 2x [NAME] with Breakfast
 | 14 | 2022-09-02 00:00:00 | House | Washington | DCPlaza | House | 1 | Roomcategory: 2x [NAME] with Breakfast
 | 15 | 2022-09-03 00:00:00 | House | Philadephia | HeatHouse | House | 1 | Roomcategory: 2x [NAME] with Breakfast
 | 16 | 2022-09-04 00:00:00 |  | New York
 | 17
 | 18
 | 19
 | 20
 | 21
 | 22
 | 23
 | 24
 | 25
 | 26
 | 27
 | 28
 | 29
 | 30
Spreadsheet: 63973d1264810187-count-non-blank-non-numeric-non-zero-non-space-non-error-text-cells-2007-for-excel-forum
Sheet: Sheet1

 | Table1 |  |  |  |  | Table2 |  |  |  |  | Column With Irregularly Spaced
 |  |  |  |  |  |  |  |  |  |  | Valid Row Names
 | C10 |  |  | C21 | C22 | C23 | C24 | C25 |  |  | (interspersed by non-text pollution)
 | 1 |  |  | 1 | 2 | 3 | 4 | 5 |  |  | SumProduct of C10*C21 |  |  |  |  |  | 0
 | 1 |  |  | 1 | 2 | 3 | 4 | 5 |  |  | 0 |  |  |  |  |  | 0
 | 1 |  |  | 1 | 2 | 3 | 4 | 5 |  |  |  |  |  |  |  |  | 1
 | 1 |  |  | 1 | 2 | 3 | 4 | 5 |  |  |  |  |  |  |  |  | 1
 | 1 |  |  | 1 | 2 | 3 | 4 | 5 |  |  | SumProduct of C10*C22 |  |  |  |  |  | 2
 |  |  |  |  |  |  |  |  |  |  | SumProduct of C10*C23 |  |  |  |  |  | 3
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 3
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 3
 |  |  |  |  |  | Contiguous data columns |  |  |  |  | SumProduct of C10*C24 |  |  |  |  |  | 4
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 5
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  | ^^^ |  | ^^^
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  | shg's |  | desired
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  | formula |  | output
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | for
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | column
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | offset
Spreadsheet: 114962d1310619745-automatically-updating-data-from-one-sheet-to-another-june
Sheet: 6566

Date | Trip Details | Amount | Toll | Other | Party | Payment Yes/N0 | [NAME]
2011-06-01 00:00:00
 | Royal Ship
 | Marriage - Aluva
 | Marriage - Palakkad | Yes
 | Munnar
 | Munnar
 | Munnar
 | Intersight Arrrival
 | Panangadu
Spreadsheet: 149375d1333898559-complex-if-statement-example-5
Sheet: Sheet4

 |  |  | [NAME] |  |  | Home | Away
 | Over |  |  |  | Current Score | 1 | 0 |  | 5 |  | 25
 | Under |  |  |  | Final Score | 5 | 0
 |  |  | Asian Handicap IP
Spreadsheet: 803945d1667818776-display-duplicates-rows-from-two-arrays-table-display_duplicates_two_columns-aligw_emptycells
Sheet: Feuil1

DUPLICATES | yellow a (2), blue b (3)
 | expected result |  |  | actual result
level | color
a | yellow
b | yellow
c | black
a | black
a | yellow
b | blue
b | blue
b | black
b | blue
Spreadsheet: 06f0e8d5-73db-434a-a6c4-a19e74c429ef
Sheet: Itemized List 3

Club Name
Event:
Event Date:
Itemized List | Price | Quantity | Total
a
b
c
d
e
f
g
h
i
j
k
l
m
n
o
p
q
r
s
t
u
v
w
x
y
z
TOTAL
Spreadsheet: 600317d1543599320-how-can-i-see-the-formula-used-in-this-example-audit-scorecard-master
Sheet: July

1 | Referral
2 | Assessment
3 | Harm Reduction
4 | Risk Assessment
5 | Recovery Plan
6 | Case Notes
7 | Correspondence
8 | Protection/Safeguarding
9 | Signed docs by clients
10 | Prescribing/project spec
11 | Exit
12 | Database
 | Result
Spreadsheet: 52781d1252597545-nested-if-statement-trouble-bowling
Sheet: Joe Bowler

[NAME]
Last Years Average |  | 90
date | game 1 | game 2 | game 3 | Games | Total Games | series | total pins | Average |  | 75 Over Eligible Score | 75 Over Award | 100 Over Eligible Score | 100 Over Award | 150 Over Series Eligible Score | 150 Over Award | 250 Game Award | 275-279 Game Award | 675-699 Series Award | 700 Series Award | 800 Series Award | 300 Game Award |  | 125 Game Award | 150 Game Award | 175 Game Award | 200 Game Award | 225 Game Award | 250 Game Award | 275 Game Award | 300 Series Award | 400 Series Award | 500 Series Award | 600 Series Award | 700 Series Award
 | 100 | 100 | 80 | 3
 | 80 | 80 | 80 | 3
 | 80 | 80 | 80 | 3
 | 90 | 90 | 90 | 3
 | 120 | 120 | 125 | 3
 | 120 | 120 | 120 | 3
 | 120 | 120 | 120 | 3
 | 120 | 120 | 250 | 3
Spreadsheet: 842706d1694706477-counting-dates-before-a-specific-date-and-event-sample-data-7-
Sheet: Sheet1

Emails sent |  |  |  | Items purchased
Person ID | SENT DATE |  |  | Person ID | Date purcased | Number of emails received before this purchase date
123 | 2022-08-09 00:00:00 |  |  | 123 | 2022-02-15 00:00:00 |  | No email were sent before this purchase date
123 | 2023-05-02 00:00:00 |  |  | 123 | 2023-01-31 00:00:00 |  | After the email which was sent on 09/08/2022, no further emails were sent before this purchase date
123 | 2023-06-22 00:00:00 |  |  | 123 | 2023-01-21 00:00:00 |  | The email sent on 09/08/2022 was sent before this purchase date
Spreadsheet: 22b855dc-3247-4c49-9301-01a61c9f76d7
Sheet: Sheet1

2002 TAX ROLL - PRIVATE, OPEN & CLOSED MANAGED FOREST BREAKDOWN | Unnamed: 1 | Unnamed: 2 | Unnamed: 3 | Unnamed: 4 | Unnamed: 5 | Unnamed: 6 | Unnamed: 7 | Unnamed: 8 | Unnamed: 9 | Unnamed: 10
Closed | Open | Private | J - Closed | J - Open | J - Private | K - Closed | K - Open | K - Private | L - Closed
1122.3 |  |  | 381.84 |  |  | 95.46 |  |  | 645 | 1122.3
76.56 |  |  | 26.05 |  |  | 6.51 |  |  | 44 | 76.56
182.73 |  |  | 62.17 |  |  | 15.54 |  |  | 105.02 | 182.73
163.56 |  |  | 55.65 |  |  | 13.91 |  |  | 94 | 163.56
52.2 |  |  | 17.76 |  |  | 4.44 |  |  | 30 | 52.2
194.88 |  |  | 66.3 |  |  | 16.58 |  |  | 112 | 194.88
 | 11.84 |  |  | 9.47 |  |  | 2.37 |  |  | 11.84
227.94 |  |  | 77.55 |  |  | 19.39 |  |  | 131 | 227.94
285.36 |  |  | 97.09 |  |  | 24.27 |  |  | 164 | 285.36
351.52 |  |  | 119.6 |  |  | 29.9 |  |  | 202.02 | 351.52
267.96 |  |  | 91.17 |  |  | 22.79 |  |  | 154 | 267.96
182.73 |  |  | 62.17 |  |  | 15.54 |  |  | 105.02 | 182.73
 |  | 8.66 |  |  | 6.93 |  |  | 1.73 |  | 8.66
238.93 |  |  | 81.29 |  |  | 20.32 |  |  | 137.32 | 238.93
52.2 |  |  | 17.76 |  |  | 4.44 |  |  | 30 | 52.2
 | 7.4 |  |  | 5.92 |  |  | 1.48 |  |  | 7.4
140.94 |  |  | 47.95 |  |  | 11.99 |  |  | 81 | 140.94
 | 14.8 |  |  | 11.84 |  |  | 2.96 |  |  | 14.8
45.24 |  |  | 15.39 |  |  | 3.85 |  |  | 26 | 45.24
105.88 |  |  | 36.02 |  |  | 9.01 |  |  | 60.85 | 105.88
 | 141.73 |  |  | 113.38 |  |  | 28.35 |  |  | 141.73
270.3 |  |  | 91.97 |  |  | 22.99 |  |  | 155.34 | 270.3
612.18 |  |  | 208.27 |  |  | 52.07 |  |  | 351.84 | 612.1800000000001
36.54 |  |  | 12.43 |  |  | 3.11 |  |  | 21 | 36.54
311.46 |  |  | 105.97 |  |  | 26.49 |  |  | 179 | 311.46
 | 7.4 |  |  | 5.92 |  |  | 1.48 |  |  | 7.4
94.36 |  |  | 32.1 |  |  | 8.03 |  |  | 54.23 | 94.36
5015.77 | 183.17 | 8.66 | 1706.5 | 146.53 | 6.93 | 426.63 | 36.64 | 1.73 | 2882.64 | 5207.599999999999
Closed = | 5015.77
Open = | 183.17
Private = | 8.66
 | 5207.6
Spreadsheet: 0833e800-6293-4dd1-8afe-44ade2bcf08b
Sheet: Sheet1

a \ b | 10 | 11 | 12 | 13 | 14 | 15 |  |  |  | x | [NAME] | yb |  | x10 | y | a | b
15 |  |  |  |  |  |  |  |  |  | 0 |  | 10 |  | 10 | 0 | 10 | 10
14 |  |  |  |  |  |  |  |  |  | 1 |  | 10 |  | 10 | 10 | 11 | 10
13 |  |  |  |  |  |  |  |  |  | 2 |  | 10 |  | 10 | 15 | 12 | 10
12 |  |  |  |  |  |  |  |  |  | 3 |  | 10 |  | 10 | 20 | 13 | 10
11 |  |  |  |  |  |  |  |  |  | 4 |  | 10 |  | 10 | 25 | 10 | 11
10 |  |  |  |  |  |  |  |  |  | 5 |  | 10 |  |  |  | 11 | 11
 |  |  |  |  |  |  |  |  |  | 6 |  | 10 |  |  |  | 12 | 11
 |  |  |  |  |  |  |  |  |  | 7 |  | 10 |  |  |  | 10 | 12
 |  |  |  |  |  |  |  |  |  | 8 |  | 10 |  |  |  | 11 | 12
 |  |  |  |  |  |  |  |  |  | 9 |  | 10 |  |  |  | 10 | 13
 |  |  |  |  |  |  |  |  |  | 10 |  | 10
 |  |  |  |  |  |  |  |  |  | 11 |  | 10
 |  |  |  |  |  |  |  |  |  | 12 |  | 10
 |  |  |  |  |  |  |  |  |  | 13 |  | 10
 |  |  |  |  |  |  |  |  |  | 14 |  | 10
 |  |  |  |  |  |  |  |  |  | 15 |  | 10
 |  |  |  |  |  |  |  |  |  | 16 |  | 10
 |  |  |  |  |  |  |  |  |  | 17 |  | 10
 |  |  |  |  |  |  |  |  |  | 18 |  | 10
 |  |  |  |  |  |  |  |  |  | 19 |  | 10
 |  |  |  |  |  |  |  |  |  | 20 |  | 10
 |  |  |  |  |  |  |  |  |  | 21 |  | 10
 |  |  |  |  |  |  |  |  |  | 22 |  | 10
 |  |  |  |  |  |  |  |  |  | 23 |  | 10
 |  |  |  |  |  |  |  |  |  | 24 |  | 10
 |  |  |  |  |  |  |  |  |  | 25 |  | 10
Spreadsheet: 877742d1724608531-uninterruptable-power-supply-load-calculation-seems-complex-ups_-hydr-
Sheet: 1920W

Total power | sw1 | sw2 | [NAME] | sw4
1920 | 1055 | 559 | 270 | 252 |  | wasted | node level
Spreadsheet: 26a898f0-365b-4c7f-b447-96b36d43431d
Sheet: Sheet1

Battle ID | Date & Time | Side | Victory | Score | Opp. Score | Opp. ID | Opp. Name | Scenario ID | Front | Start Date | End Date | Name EN | Name FR
40877381 | 2014-04-06 23:39:14 | AXIS | 1 | 6 | 2 | 1490692 | Pedroas | 7669 | pacific | 1941-12-23 | 1941-12-23 | Wake Island | Ile de Wake
40877588 | 2014-04-07 00:01:15 | AXIS | 1 | 6 | 3 | 706396 | Intello | 12509 | western | 1944-06-06 |  | [Normandy] Vaumicel Manor | Château de Vaumicel
40877839 | 2014-04-07 00:16:59 | ALLIES | 0 | 3 | 6 | 706396 | Intello | 12509 | western | 1944-06-06 |  | [Normandy] Vaumicel Manor | Château de Vaumicel
40932623 | 2014-04-10 22:09:04 | AXIS | 1 | 6 | 5 | 1444429 | michelecannone | 12505 | western | 1945-02-17 | 1945-02-20 | Moyland Wood | [NAME]
40933127 | 2014-04-10 22:35:31 | ALLIES | 1 | 6 | 2 | 1444429 | michelecannone | 12505 | western | 1945-02-17 | 1945-02-20 | Moyland Wood | [NAME]
40933404 | 2014-04-10 22:55:31 | ALLIES | 1 | 6 | 4 | 1422784 | flarchi | 7595 | eastern | 1939-12-16 | 1939-12-16 | Suomussalmi | Suomussalmi
40933609 | 2014-04-10 23:09:59 | AXIS | 1 | 6 | 3 | 1422784 | flarchi | 7595 | eastern | 1939-12-16 | 1939-12-16 | Suomussalmi | Suomussalmi
40974731 | 2014-04-13 19:52:39 | ALLIES | 0 | 2 | 6 | 1531424 | djarv | 6749 | western | 1944-06-06 | 1944-06-06 | [NAME] | [NAME]
40975247 | 2014-04-13 20:10:02 | AXIS | 1 | 6 | 3 | 1531424 | djarv | 7595 | eastern | 1939-12-16 | 1939-12-16 | Suomussalmi | Suomussalmi
40975506 | 2014-04-13 20:26:12 | ALLIES | 1 | 6 | 1 | 1531424 | djarv | 7595 | eastern | 1939-12-16 | 1939-12-16 | Suomussalmi | Suomussalmi
40975787 | 2014-04-13 20:48:23 | ALLIES | 1 | 7 | 6 | 1490692 | Pedroas | 7661 | eastern | 1944-02-16 | 1944-02-17 | Breakout to Lisyanka | [NAME]
40977069 | 2014-04-13 21:52:12 | AXIS | 1 | 4 | 0 | 291698 | [NAME] | 6149 | western | 1944-08-07 | 1944-08-11 | Counter-attack on Mortain | Contre-attaque de Mortain
40977222 | 2014-04-13 22:18:17 | ALLIES | 1 | 4 | 2 | 291698 | [NAME] | 6149 | western | 1944-08-07 | 1944-08-11 | Counter-attack on Mortain | Contre-attaque de Mortain
40993034 | 2014-04-14 23:07:36 | AXIS | 1 | 10 | 4 | 760708 | borderbattles | 7662 | eastern | 1942-10-22 | 1942-10-22 | Red Barricades Factory | Les Barricades Rouges
40993446 | 2014-04-14 23:59:29 | ALLIES | 1 | 10 | 8 | 760708 | borderbattles | 7662 | eastern | 1942-10-22 | 1942-10-22 | Red Barricades Factory | Les Barricades Rouges
Spreadsheet: 150349d1334445950-using-solver-to-maximize-a-value-product-financial-assump-2012
Sheet: Optimization

Land Use Optimization
 | SUMMARY
 | LAND VALUE CALCULATION (END OF YEAR 1)
 | Residential land value
 | Plus Retail Land value |  |  |  |  | /sqft |  | sqft
 | LESS LAND DEVELOPMENT COSTS (1 YEAR TIME FRAME)
 | Less land Development Costs |  |  |  |  | /sqft
 | Less Costs of Road |  |  |  |  | /sqft |  | sqft
 | Less cost of Park Area |  |  |  |  | /sqft |  | sqft
 | Value of the project at the End of Year 1
 | ESTIMATED RESIDUAL LAND  VALUE |  |  |  |  | (discount rate)
 |  |  |  |  |  |  |  |  |  | /sqft
 |  |  |  |  |  |  |  |  |  | Total Costs | Base Price | Net Profit
A |  |  |  |  |  |  |  |  |  |  |  |  | per DU
B |  |  |  |  |  |  |  |  |  |  |  |  | per DU
C |  |  |  |  |  |  |  |  |  |  |  |  | per DU
D |  |  |  |  |  |  |  |  |  |  |  |  | per DU
Land Constraint |  |  |  | (weeks per acre) |  |  | ([NAME]) |  |  |  |  |  |  |  | (with limits) |  | (With no min limit (i.e. build 0 when below min project size?)
 |  | Net Profit | Net Profit Per Acre | Time to sell |  | Annual Absorption | Minimum Project Size | Minimum Project Acres | Maximum Project Size | Maximum Project Acres | Number of Units | [NAME] |  |  | Number of Units |  | Number of Units
A | SFD Alley | 433000 |  |  | weeks |  |  |  |  |  | 23.76853099588874 |  |  |  | 75.58788959625535 |  | 62.06651782853275
B | TH | 286500 |  |  | weeks |  |  |  | 120 |  | 24.37685884941873 |  |  |  | 82.87499371564044 |  | 68.25000056147535
C | Brownstone | 173500 |  |  | weeks |  |  |  | 80 |  | 32.36060990919099 |  |  |  | 40 |  | 80
D | Podium D | 175500 |  |  | weeks |  |  |  | 320 |  | 113.2076383729869 |  |  |  | 125 |  | 113.2070353068783
 | Podium E | 112000 |  |  | weeks |  |  |  | 320 |  | 123.4990725285084 |  |  |  | 125 |  | 123.5234755726131
 | [NAME] over Retail | 147800 |  |  | weeks |  |  |  | 160 |  | 82.33233670919762 |  |  |  | 40 |  | 82.32874688961869
 |  |  |  |  |  |  |  |  |  |  |  |  | 13.3149 |  | 488.4628833118958 |  | 529.3757761591181
Discount Rate |  |  |  |  | Monthly |  |  |  |  |  |  |  |  | NPV | 89436219.1390217 |  | 92437242.37041411
Sales Revenues |  |  |  |  | Month
 | Absorption: |  | Total | 0 | 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 | 32 | 33 | 34
 | Sales Proceeds
 |  | Cum
 | NPV of Sales Proceeds |  |  | (compounded monthly)
 |  |  |  | (annual, divided by 12)
Spreadsheet: 857154d1706201210-returning-information-but-name-is-offset-to-results-barry-aligw
Sheet: Barry AliGW

Vehicle Reg | [NAME] |  | [NAME] |  |  | Helper |  |  |  |  |  |  | Occurances
Date/Time | Location | Speed | Speed Limit | Speed Exceeded | Speed Exceeded Percentage |  |  |  |  |  | Speeding Occurances | Highest Speed Exceeded | 30 | 40 | 50 | 60
2024-01-24 00:19:00 | [NAME], [NAME] | 41 | 30 | 11 | 37 |  |  |  |  | [NAME]
2024-01-24 01:05:00 | Watling Street, Gravesend | 66 | 60 | 6 | 10 |  |  |  |  | [NAME]
2024-01-24 01:06:00 | Watling Street, Gravesend | 66 | 60 | 6 | 10 |  |  |  |  | [NAME]
2024-01-24 23:07:00 | Hall Road, Gravesend | 33 | 30 | 3 | 10
Vehicle Reg | SK72XWZ [NAME]
Date/Time | Location | Speed | Speed Limit | Speed Exceeded | Speed Exceeded Percentage
2024-01-24 09:29:00 | [NAME], Newbridge | 45 | 40 | 5 | 12
2024-01-24 09:30:00 | [NAME], Newbridge | 47 | 40 | 7 | 18
2024-01-24 09:31:00 | [NAME], Edinburgh | 45 | 40 | 5 | 12
Vehicle Reg | GS69SJV [NAME]
Date/Time | Location | Speed | Speed Limit | Speed Exceeded | Speed Exceeded Percentage
2024-01-24 12:45:00 | Easedale Gardens, Gateshead | 34 | 30 | 4 | 13
2024-01-24 12:47:00 | Hertford, Gateshead | 34 | 30 | 4 | 13
Spreadsheet: 2a40e9ce-0c36-4edd-b29d-c70424f1b61f
Sheet: Sheet1

LOT 8 | Unnamed: 1 | Unnamed: 2 | Unnamed: 3 | Unnamed: 4 | Unnamed: 5 | LOT 9 | Unnamed: 7 | Unnamed: 8 | Unnamed: 9 | Unnamed: 10 | Unnamed: 11 | LOT 10 | Unnamed: 13 | Unnamed: 14 | Unnamed: 15 | Unnamed: 16 | Unnamed: 17 | LOT 11 | Unnamed: 19 | Unnamed: 20 | Unnamed: 21 | Unnamed: 22 | Unnamed: 23 | LOT 12 | Unnamed: 25 | Unnamed: 26 | Unnamed: 27 | Unnamed: 28 | Unnamed: 29 | LOT 13 | Unnamed: 31 | Unnamed: 32 | Unnamed: 33 | Unnamed: 34 | Unnamed: 35 | LOT 14 | Unnamed: 37 | Unnamed: 38 | Unnamed: 39 | Unnamed: 40 | Unnamed: 41
6 | 5 | 4 | 3 | 2 | 1 | 6 | 5 | 4 | 3 | 2 | 1 | 6 | 5 | 4 | 3 | 2 | 1 | 6 | 5 | 4 | 3 | 2 | 1 | 6 | 5 | 4 | 3 | 2 | 1 | 6 | 5 | 4 | 3 | 2 | 1 | 6 | 5 | 4 | 3 | 2 | 1
7 | 8 | 9 | 10 | 11 | 12 | 7 | 8 | 9 | 10 | 11 | 12 | 7 | 8 | 9 | 10 | 11 | 12 | 7 | 8 | 9 | 10 | 11 | 12 | 7 | 8 | 9 | 10 | 11 | 12 | 7 | 8 | 9 | 10 | 11 | 12 | 7 | 8 | 9 | 10 | 11 | 12
LOT 1 |  |  |  |  |  | LOT 2 |  |  |  |  |  | LOT 3 |  |  |  |  |  | LOT 4 |  |  |  |  |  | LOT 5 |  |  |  |  |  | LOT 6 |  |  |  |  |  | LOT 7
6 | 5 | 4 | 3 | 2 | 1 | 6 | 5 | 4 | 3 | 2 | 1 | 6 | 5 | 4 | 3 | 2 | 1 | 6 | 5 | 4 | 3 | 2 | 1 | 6 | 5 | 4 | 3 | 2 | 1 | 6 | 5 | 4 | 3 | 2 | 1 | 6 | 5 | 4 | 3 | 2 | 1
7 | 8 | 9 | 10 | 11 | 12 | 7 | 8 | 9 | 10 | 11 | 12 | 7 | 8 | 9 | 10 | 11 | 12 | 7 | 8 | 9 | 10 | 11 | 12 | 7 | 8 | 9 | 10 | 11 | 12 | 7 | 8 | 9 | 10 | 11 | 12 | 7 | 8 | 9 | 10 | 11 | 12
LOT 21 |  |  |  |  |  | LOT 20 |  |  |  |  |  | LOT 19 |  |  |  |  |  | LOT 18 |  |  |  |  |  | LOT 17 |  |  |  |  |  | LOT 16 |  |  |  |  |  | LOT 15
6 | 5 | 4 | 3 | 2 | 1 | 6 | 5 | 4 | 3 | 2 | 1 | 6 | 5 | 4 | 3 | 2 | 1 | 6 | 5 | 4 | 3 | 2 | 1 | 6 | 5 | 4 | 3 | 2 | 1 | 6 | 5 | 4 | 3 | 2 | 1 | 6 | 5 | 4 | 3 | 2 | 1
7 | 8 | 9 | 10 | 11 | 12 | 7 | 8 | 9 | 10 | 11 | 12 | 7 | 8 | 9 | 10 | 11 | 12 | 7 | 8 | 9 | 10 | 11 | 12 | 7 | 8 | 9 | 10 | 11 | 12 | 7 | 8 | 9 | 10 | 11 | 12 | 7 | 8 | 9 | 10 | 11 | 12
LOT 22 |  |  |  |  |  | LOT 23
6 | 5 | 4 | 3 | 2 | 1 | 6 | 5 | 4 | 3 | 2 | 1
7 | 8 | 9 | 10 | 11 | 12 | 7 | 8 | 9 | 10 | 11 | 12
LOT 24
15 | 16 | 17 | 18 | 19 | 20 | 21 | 22 | 23 | 24 | 25 | 26 | 27 | 0
1 | 2 | 3 | 4 | 5 | 6 | 7 | 8 | 9 | 10 | 11 | 12 | 13 | 14
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 101 | interned
Spreadsheet: 112182d1308310683-dynamic-charts-in-excel-create-chart-with-the-last-12-entries-example_charting_4_using_offsets
Sheet: LNR

Month | Header1 | Header2 | Header3 | Header4 |  |  |  |  |  |  |  |  |  |  |  | [NAME] from scratch(2) file which works
2010-02-01 00:00:00 | 135 | 134 | 0.95 |  |  |  |  |  |  |  |  |  |  |  |  | chrtLNR |  | INDEX(LNR!$A:$A, MATCH(9E+307, LNR!$A:$A)):INDEX(LNR!$E:$E, MATCH(9E+307, LNR!$A:$A)-9)
2010-03-01 00:00:00 | 139 | 139 | 0.95
2010-04-01 00:00:00 | 84 | 83 | 0.95 |  |  |  |  |  |  |  |  |  |  |  |  | tblLnr2 |  | INDEX(LNR!chrtLNR,0,2) |  |  |  |  |  | SERIES(LNR!$B$1,LNR!tblLnrMonth,LNR!tblLnr2,1)
2010-05-01 00:00:00 | 74 | 73 | 0.95
2010-06-01 00:00:00 | 123 | 121 | 0.95 |  |  |  |  |  |  |  |  |  |  |  |  | tblLnr3 |  | INDEX(LNR!chrtLNR, 0, 3) |  |  |  |  |  | SERIES(LNR!$B$1,LNR!tblLnrMonth,LNR!tblLnr3,1)
2010-07-01 00:00:00 | 104 | 101 | 0.95
2010-08-01 00:00:00 | 123 | 120 | 0.95 |  |  |  |  |  |  |  |  |  |  |  |  | tblLnr4 |  | INDEX(LNR!chrtLNR,0,4)
2010-09-01 00:00:00 | 56 | 56 | 0.95
2010-10-01 00:00:00 | 64 | 64 | 0.95 |  |  |  |  |  |  |  |  |  |  |  |  | tblLnr5 |  | INDEX(LNR!chrtLNR, 0, 5)
2010-11-01 00:00:00 | 85 | 84 | 0.95
2010-12-01 00:00:00 | 47 | 47 | 0.95 |  |  |  |  |  |  |  |  |  |  |  |  | tblLnrMonth |  | INDEX(LNR!chrtLNR,0,1)
2011-01-01 00:00:00 | 112 | 111 | 0.95
2011-02-01 00:00:00 | 75 | 111 | 0.95 | 0.99
2011-03-01 00:00:00 | 100 | 15 | 0.95 | 1
2011-04-01 00:00:00