tianzl66/Sheetpedia huggingface dataset:
Spreadsheet: 151958d1335196787-count-if-greater-than-formula-switch-form
Sheet: detail

device | FTHG | FTAG | TG
Switch | 0 | 2
Switch | 1 | 0
Switch | 3 | 0
Switch | 2 | 1
Switch | 3 | 1
Switch | 3 | 0
Switch | 1 | 1
Switch | 1 | 0
Switch | 1 | 1
Switch | 1 | 0
Switch | 1 | 2
Switch | 7 | 1
Switch | 5 | 2
Switch | 2 | 1
Switch | 3 | 0
Switch | 1 | 0
Router | 3 | 1
Router | 0 | 0
Spreadsheet: chris_germany__1683__200004strg
Sheet: Sheet3

Actual Storage MDQ Effective 4/1/2000
 | FSS-SCQ | 6050607
 | SST-MDQ-W | ???
 | SST-MDQ-S | 54327
 | [NAME] 3/31/2000 | 170981
 | [NAME]
 | [NAME] | Inject % |  | Balance | Monthly | Daily
 | 2000-04-01 00:00:00 | 0.13 |  | 170981
 | 2000-05-01 00:00:00 | 0.18
 | 2000-06-01 00:00:00 | 0.18
 | 2000-07-01 00:00:00 | 0.18
 | 2000-08-01 00:00:00 | 0.18
 | 2000-09-01 00:00:00 | 0.13
 | 2000-10-01 00:00:00 | 0.02
 | 2000-11-01 00:00:00 | 0
 | 2000-12-01 00:00:00 | 0
Spreadsheet: 86572d1286522028-i-need-a-formula-that-does-averages-only-if-a-certain-number-is-in-the-box-sampleutah
Sheet: Sheet1

 |  |  |  | [NAME]
 |  |  |  | 2 Pointers |  | 3 Pointers |  | Free Throws |  | Totals per game |  |  |  |  |  |  | Other
 |  |  |  | Made | Attem. | Made | Attem. | Made | Attem. | Points |  | Reb | Assists | Blocks | Steals | TO's | Minutes | Eff.
 |  | Away | 1 | 11 | 17 | 4 | 6 | 14 | 16 | 48 |  | 10 | 6 | 2 | 2 | 3 | 43 | 55
 |  | Home | 2 | 12 | 19 | 2 | 3 | 8 | 9 | 38 |  | 8 | 7 | 2 | 1 | 1 | 39 | 46
 |  | Away | 3 | 12 | 20 | 2 | 5 | 6 | 8 | 36 |  | 6 | 8 | 3 | 1 | 4 | 42 | 37
 |  | Home | 4
 |  | Away | 5
 |  | Home | 6
 |  | Away | 7
 |  | Away | 8
 |  | Away | 9
 |  | Away | 10
 |  | Home | 75
 |  | Home | 76
 |  | Away | 77
 |  | Away | 78
 |  | Home | 79
 |  | Away | 80
 |  | Away | 81
 |  | Home | 82
 |  |  | HIGH | 12 | 20 | 4 | 6 | 14 | 16 | 48 |  | 10 | 8 | 3 | 2 | 4 | 43
 |  |  | LOW | 11 | 17 | 2 | 3 | 6 | 8 | 36 |  | 6 | 6 | 2 | 1 | 1 | 39
 |  |  | Totals | 35 | 56 | 8 | 14 | 28 | 33 | 122 |  | 24 | 21 | 7 | 4 | 8
 |  |  |  | Made | Attem. | Made | Attem. | Made | Attem. | Points |  | Reb | Assists | Steals | Blocks | TO's | Minutes | Eff.
 |  |  |  | 2 Pointers |  | 3 Pointers |  | Free Throws |  | Totals per game |  |  |  |  |  |  | Other
 |  |  |  | Season Totals: [NAME]
 |  |  |  | 2 Point % |  | 3 Point % |  | Free Throw % |  | FG % | PPG | RPG | APG | SPG | BPG | A TO's | Minutes | Eff.
 |  |  |  | 0.625 |  | 0.5714285714285714 |  | 0.8484848484848485 |  | 0.6142857142857143 | 40.66666666666666 | 8 | 7 | 2.333333333333333 | 1.333333333333333 | 2.666666666666667 | 41.33333333333334 | 46
 |  |  | At Home
 |  |  | On Road
 |  |  | In Wins
 |  |  | In Losses
 |  |  |  | 2 Point % |  | 3 Point % |  | Free Throw % |  | FG% | PPG | RPG | APG | SPG | BPG | A To's | Minutes | Eff.
Spreadsheet: 71686d1272443368-can-i-use-a-formula-for-introducing-a-formula-try1
Sheet: Sheet1

Activity | [NAME] |  |  |  | Activities |  |  |  | Parameter values
Sowing | Previous - 0,1*((i-x)/365) |  |  | 1994-01-01 00:00:00 | 0.9 |  |  | 1994-01-01 00:00:00
Fertilization | No effect |  |  | 1994-01-02 00:00:00 | 0.9 |  |  | 1994-01-02 00:00:00
Harvest | 0,2 + 0,8*((i-x)/365) |  |  | 1994-01-03 00:00:00 | 0.9 |  |  | 1994-01-03 00:00:00
Plough | 1- 0,2*((i-x)/365) |  |  | 1994-01-04 00:00:00 | Sowing |  |  | 1994-01-04 00:00:00
 |  |  |  | 1994-01-05 00:00:00 |  |  |  | 1994-01-05 00:00:00
 |  |  |  | 1994-01-06 00:00:00 | Fertilization |  |  | 1994-01-06 00:00:00
 |  |  |  | 1994-01-07 00:00:00 |  |  |  | 1994-01-07 00:00:00
 |  |  |  | 1994-01-08 00:00:00 |  |  |  | 1994-01-08 00:00:00
 |  |  |  | 1994-01-09 00:00:00 |  |  |  | 1994-01-09 00:00:00
 |  |  |  | 1994-01-10 00:00:00 |  |  |  | 1994-01-10 00:00:00
 |  |  |  | 1994-01-11 00:00:00 | Harvest |  |  | 1994-01-11 00:00:00
 |  |  |  | 1994-01-12 00:00:00 |  |  |  | 1994-01-12 00:00:00
 |  |  |  | 1994-01-13 00:00:00 |  |  |  | 1994-01-13 00:00:00
 |  |  |  | 1994-01-14 00:00:00 | Plough |  |  | 1994-01-14 00:00:00
 |  |  |  | 1994-01-15 00:00:00 |  |  |  | 1994-01-15 00:00:00
 |  |  |  | 1994-01-16 00:00:00 |  |  |  | 1994-01-16 00:00:00
 |  |  |  | 1994-01-17 00:00:00 |  |  |  | 1994-01-17 00:00:00
 |  |  |  | 1994-01-18 00:00:00 |  |  |  | 1994-01-18 00:00:00
Spreadsheet: 736284d1623455023-shifting-values-for-several-columns-sampledata
Sheet: Sheet1

ID | FirstName | LastName | City | State | Purchase Date | Purchase | Description | Label | Price
1 | [NAME] | Smith | Menlo Park | CA | 2021-05-06 09:36:55.220000 | xyz | abc | nmo | psr
1 | [NAME] | Smith | Menlo Park | CA | 2021-06-02 11:20:52.840000 | bcd | efg | hij | klm
1 | [NAME] | Smith | Menlo Park | CA | 2021-05-05 14:05:45.703000 | noq | qrs | tuv | wyz
1 | [NAME] | Smith | Menlo Park | CA | 2021-05-05 14:05:45.703000 | ctv | dne | egp | gig
2 | [NAME] | [NAME] | Oakville | IA | 2021-05-02 14:59:46.853000 | [NAME] | nno | pwr | ano
2 | [NAME] | [NAME] | Oakville | IA | 2021-04-30 17:19:30.930000 | skp | del | [NAME] | jis
3 | [NAME] | [NAME] | Orlando | FL | 2021-04-23 17:19:31 | aak | gep | csj | mtn
3 | [NAME] | [NAME] | Orlando | FL | 2021-04-19 17:19:31 | cop | byi | spr | nlp
3 | [NAME] | [NAME] | Orlando | FL | 2021-04-10 17:19:31 | stf | mts | cal | waz
ID | FirstName | LastName | City | State | Purchase Date | current [NAME] | current [NAME] | current [NAME] | current Price | previous [NAME] | previous [NAME] | previous [NAME] | previous Price
1 | [NAME] | Smith | Menlo Park | CA | 2021-05-06 09:36:55.220000 | xyz | abc | nmo | psr | bcd | efg | hij | klm
1 | [NAME] | Smith | Menlo Park | CA | 2021-06-02 11:20:52.840000 | bcd | efg | hij | klm | noq | qrs | tuv | wyz
1 | [NAME] | Smith | Menlo Park | CA | 2021-05-05 14:05:45.703000 | noq | qrs | tuv | wyz | ctv | dne | egp | gig
2 | [NAME] | [NAME] | Oakville | IA | 2021-05-02 14:59:46.853000 | [NAME] | nno | pwr | ano | skp | del | [NAME] | jis
3 | [NAME] | [NAME] | Orlando | FL | 2021-04-23 17:19:31 | aak | gep | csj | mtn | cop | byi | spr | nlp
3 | [NAME] | [NAME] | Orlando | FL | 2021-04-19 17:19:31 | cop | byi | spr | nlp | stf | mts | cal | waz
Spreadsheet: 271102d1381825241-shift-pattern-help-2014-shifts
Sheet: Yearly

Year | Shift Start Date |  |  |  | Shift Start Date |  |  |  | Shift Start Date |  |  |  | Shift Start Date
2014-01-01 00:00:00 | 2014-01-06 00:00:00 |  |  |  | 2014-01-05 00:00:00 |  |  |  | 2014-01-09 00:00:00 |  |  |  | 2014-01-08 00:00:00 |  |  |  |  |  | To [NAME] a yearly shift pattern certain fileds must be filled in, YEAR, Each shifts first start date of full week, what week number they will be starting on (all shifts should start on the same week # and wheather they are starting there shift as Days or Nights
 | A |  |  |  | B |  |  |  | C |  |  |  | D
JAN | 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
DAY | B | D | D | D |  | A | A | A | C | C | C |  | C | C | C | A | A | A |  | D | D | D | B | B | B |  | C | C | C | A | A
NIGHT | C | C | C |  | B | B | B | D | D | D |  | D | D | D | B | B | B |  | C | C | C | A | A | A |  | D | D | D | B | B | B
FEB | 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
DAY
NIGHT
MAR | 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
DAY
NIGHT
APR | 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
DAY
NIGHT
MAY | 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
DAY
NIGHT
[NAME] | 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
DAY
NIGHT
JULY | 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
DAY
NIGHT
AUG | 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
DAY
NIGHT
SEPT | 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
DAY
NIGHT
OCT | 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
DAY
NIGHT
NOV | 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
DAY
NIGHT
DEC | 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
DAY
NIGHT
Spreadsheet: 173882d1344834789-listbox-for-each-cell-listbox-example
Sheet: Lookup

[NAME]
√ |  |  |  | √
√*
O
OT
S
×
AL
MC
ML
FL
PML
MTL
POML
PL
OL
NP
SP
CL
R
Spreadsheet: 684344d1593315665-data-analysis-on-variance-reporting-wanted-maybe-pivot-tables-shifts-and-targets-taranakigirl-
Sheet: Sheet1

 |  |  |  |  |  |  |  |  |  | Date | Jun
 |  |  |  |  |  |  |  |  |  | Day of the week | Shift Code | Average of % Variance | Average of Positive Target | Average of Negative Target
 |  |  |  |  |  |  |  |  |  | Sunday | D | 0.05711795859931934 | 0.1285 | -0.085
 |  |  |  |  |  |  |  |  |  |  | A | 0.1466057177419355 | 0.1285 | -0.085
 |  |  |  |  |  |  |  |  |  |  | N | -0.09871823044057204 | 0.1285 | -0.085
 |  |  |  |  |  |  |  |  |  | Monday | D | 0.2792602492008137 | 0.1285 | -0.085
 |  |  |  |  |  |  |  |  |  |  | A | 0.2403086294261294 | 0.1285 | -0.085
 |  |  |  |  |  |  |  |  |  |  | N | 0.1670684351276743 | 0.1285 | -0.085
 |  |  |  |  |  |  |  |  |  | Tuesday | D | 0.1518503326745718 | 0.1285 | -0.085
 |  |  |  |  |  |  |  |  |  |  | A | -0.1094707389277389 | 0.1285 | -0.085
 |  |  |  |  |  |  |  |  |  |  | N | -0.06626854925775971 | 0.1285 | -0.085
 |  |  |  |  |  |  |  |  |  | Wednesday | D | -0.00762619778869783 | 0.1285 | -0.085
 |  |  |  |  |  |  |  |  |  |  | A | 0.1570171704260652 | 0.1285 | -0.085
 |  |  |  |  |  |  |  |  |  |  | N | 0.2027212630672734 | 0.1285 | -0.085
 |  |  |  |  |  |  |  |  |  | Thursday | D | -0.1240057462686568 | 0.1285 | -0.085
 |  |  |  |  |  |  |  |  |  |  | A | 0.08579612453264307 | 0.1285 | -0.085
 |  |  |  |  |  |  |  |  |  |  | N | 0.2655300732323232 | 0.1285 | -0.085
 |  |  |  |  |  |  |  |  |  | Friday | D | 0.1222077751196172 | 0.1285 | -0.085
 |  |  |  |  |  |  |  |  |  |  | A | 0.1412976700680271 | 0.1285 | -0.085
 |  |  |  |  |  |  |  |  |  |  | N | 0.1764374782386073 | 0.1285 | -0.085
 |  |  |  |  |  |  |  |  |  | Saturday | D | 0.157090694182504 | 0.1285 | -0.085
 |  |  |  |  |  |  |  |  |  |  | A | 0.1836999483264827 | 0.1285 | -0.085
 |  |  |  |  |  |  |  |  |  |  | N | 0.1306556108597285 | 0.1285 | -0.085
 |  |  |  |  |  |  |  |  |  | Grand Total |  | 0.1075512222923948 | 0.1284999999999999 | -0.08499999999999998
Spreadsheet: 98373d1297289835-trying-to-lookup-multiple-values-example
Sheet: Sheet1 (2)

Upper | Lower |  |  |  |  |  |  |  |  |  |  | Upper | Lower
Vacant | Vacant |  |  |  |  |  |  |  |  |  |  | Santiago,[NAME] | Munoz,[NAME]
Santiago,[NAME] | Munoz,[NAME] |  |  |  |  |  |  |  |  |  |  |  | Keaney,[NAME]
Vacant | Vacant |  |  |  |  |  |  |  |  |  |  |  | O'Reilly,Shane Z
Vacant | Vacant |  |  |  |  |  |  |  |  |  |  |  | Viele,[NAME]
Vacant | Vacant
Santiago,[NAME] | Munoz,[NAME] |  |  |  |  |  |  |  |  |  |  | Bowers,[NAME] | Ackenheil,Erin P
Santiago,[NAME] | Keaney,[NAME]
Santiago,[NAME] | Keaney,[NAME] |  |  |  |  |  |  |  |  |  |  | SEAMAN,[NAME] R | [NAME],[NAME]
Vacant | Vacant
Santiago,[NAME] | Munoz,[NAME] |  |  |  |  |  |  |  |  |  |  | [NAME],[NAME] | PENCZEK,[NAME]
Santiago,[NAME] | Munoz,[NAME] |  |  |  |  |  |  |  |  |  |  |  | jones, [NAME]
Santiago,[NAME] | Munoz,[NAME] |  |  |  |  |  |  |  |  |  |  |  | [NAME], Nate
Santiago,[NAME] | Munoz,[NAME] |  |  |  |  |  |  |  |  |  |  |  | ROGERS,MELISSA A
Santiago,[NAME] | Keaney,[NAME]
Vacant | Vacant
Vacant | Vacant
TBD | TBD
Santiago,[NAME] | O'Reilly,Shane Z
Santiago,[NAME] | Munoz,[NAME]
Santiago,[NAME] | O'Reilly,Shane Z
Vacant | Vacant
Santiago,[NAME] | O'Reilly,Shane Z
TBD | TBD
Santiago,[NAME] | Viele,[NAME]
TBD | TBD
Santiago,[NAME] | Munoz,[NAME]
Santiago,[NAME] | Munoz,[NAME]
Santiago,[NAME] | Viele,[NAME]
Santiago,[NAME] | Viele,[NAME]
Santiago,[NAME] | Viele,[NAME]
Santiago,[NAME] | Viele,[NAME]
TBD | TBD
Santiago,[NAME] | Munoz,[NAME]
Santiago,[NAME] | Munoz,[NAME]
Santiago,[NAME] | Munoz,[NAME]
Santiago,[NAME] | Munoz,[NAME]
Santiago,[NAME] | Munoz,[NAME]
TBD | TBD
Vacant | Vacant
Vacant | Vacant
Bowers,[NAME] | Ackenheil,Erin P
SEAMAN,[NAME] R | [NAME],[NAME]
Vacant | Vacant
[NAME],[NAME] | PENCZEK,[NAME]
[NAME],[NAME] | jones, [NAME]
[NAME],[NAME] | [NAME], Nate
[NAME],[NAME] | ROGERS,MELISSA A
[NAME],[NAME] | ROGERS,MELISSA A
Spreadsheet: 134766d1325622890-if-i-need-help-sample
Sheet: Sheet1

a | 1 | a1=n
b | 2 | a2=o
c | 1 | b1=p
d | 2 | b2=q
e | 1 | c1=r
f | 2 | c2=s
a | 2 | d1=t
b | 1 | d2=u
c | 2 | e1=v
d | 2 | e2=w
e | 1 | [NAME]x
f | 1 | f2=y
Spreadsheet: 142552d1329906529-moving-annual-total-example205-2-
Sheet: Sheet1

2010-01-01 00:00:00 | 720 |  | 11072 | sum 12 month starting | jan
2010-02-01 00:00:00 | 989 |  | 11432 | sum 12 month starting | feb
2010-03-01 00:00:00 | 896 |  | 11489 | sum 12 month starting | [NAME]
2010-04-01 00:00:00 | 1132 |  | 11223 | sum 12 month starting | apr
2010-05-01 00:00:00 | 817 |  | 11080 | sum 12 month starting | may
2010-06-01 00:00:00 | 582
2010-07-01 00:00:00 | 501
2010-08-01 00:00:00 | 1254
2010-09-01 00:00:00 | 882
2010-10-01 00:00:00 | 1386
2010-11-01 00:00:00 | 1153
2010-12-01 00:00:00 | 760
2011-01-01 00:00:00 | 1080
2011-02-01 00:00:00 | 1046
2011-03-01 00:00:00 | 630
2011-04-01 00:00:00 | 989
2011-05-01 00:00:00 | 1465
2011-06-01 00:00:00 | 620
2011-07-01 00:00:00 | 1436
2011-08-01 00:00:00 | 576
2011-09-01 00:00:00 | 536
2011-10-01 00:00:00 | 1213
2011-11-01 00:00:00 | 820
2011-12-01 00:00:00 | 1052
Spreadsheet: 115109d1310734006-highlighting-cells-project-tracker-document
Sheet: Tracker

Facilities capital projects 2011 |  |  |  |  |  |  |  |  |  |  |  |  |  | Role
 |  |  |  | Project | - | ?? |  |  |  | Team members - | 1 | ?? | - | ??
 |  |  |  | Project Manager | - | ?? |  |  |  |  | 2 | ?? | - | ??
 |  |  |  | Project sponsor | - | ?? |  |  |  |  | 3 | ?? | - | ??
Preliminaries |  |  |  | Sponsor assigned |  | Project manager identified |  | Project team identified |  |  |  |  |  |  |  | Complete?
 |  |  | Target
 |  |  | Actual | 2011-06-01 00:00:00 |  | 2011-06-20 00:00:00 |  | 2011-07-09 00:00:00
Design |  |  |  | Need for project defined |  | Discuss project need with stakeholders |  | Design ideas (drawings) |  | Stakeholder design approval |  |  |  |  |  | Complete?
 |  |  | Target
 |  |  | Actual
Charter & contract |  |  |  | Create project charter |  | Project charter approved |  | Create management of change document |  | Management of change approved |  |  |  |  |  | Complete?
 |  |  | Target
 |  |  | Actual
Costing |  |  |  | Send drawings out to tender |  | Create budget tracker |  | tenders approved by stakeholders |  | Approve succesful tenders |  | Raise RFA |  | RFA approval |  | Complete?
 |  |  | Target
 |  |  | Actual
Health & safety |  |  |  | Aquire contractor risk assessments |  | Aquire contractor method statments |  | CTT job specific risk assesment |  | Submit all H&S information to on site H&S |  | On site H&S approval |  | Assign individual contractor work permits |  | Complete?
 |  |  | Target
 |  |  | Actual
Management |  |  |  | Raise orders |  | Orders approved |  | Project start date |  | Commencement of schedule of works |  | Continuous on site management |  | Project completion |  | Complete?
 |  |  | Target
 |  |  | Actual
Sign off |  |  |  | Snagging list compiled |  | Snagging works completed |  | Completion certificate handed over |  | Receive orders |  | Subit invoices to accounts |  | Ensure Ariba 3 way match |  | Complete?
 |  |  | Target
 |  |  | Actual
Sustain |  |  |  | Update facilities documentation |  | Learn lessons |  | Close off project |  |  |  |  |  |  |  | Complete?
 |  |  | Target
 |  |  | Actual
Completion |  |  |  | Target completion date |  | Actual complation date
 |  |  | Target
 |  |  | Actual
Spreadsheet: 677837d1589550748-earliest-or-latest-date-based-on-variable-criteria-under-construction-copy-of-4116-tracking-mirror
Sheet: Dashboard

Manual Payments
0
IV-E Pymts | JohnL | [NAME] |  | Total |  | Earliest | Most Recent |  |  |  | FY20 Holidays
[NAME] Per Day |  |  |  |  |  |  |  |  |  |  | 2019-09-02 00:00:00
Total Processed YTD |  |  |  |  |  |  |  |  |  |  | 2019-11-11 00:00:00
Average Turnaround (days) |  |  |  |  |  |  |  |  |  |  | 2019-11-28 00:00:00
Average Dollar Value |  |  |  |  |  |  |  |  |  |  | 2019-11-29 00:00:00
Has Voucher |  |  |  |  |  |  |  |  |  |  | 2019-12-24 00:00:00
No Voucher Yet |  |  |  |  |  |  |  |  |  |  | 2019-12-25 00:00:00
0 |  |  |  |  |  |  |  |  |  |  | 2019-12-26 00:00:00
FCL Monitor |  |  |  |  |  | Earliest | Most Recent |  |  |  | 2020-01-01 00:00:00
[NAME] Per Day |  |  |  |  |  |  |  |  |  |  | 2020-01-20 00:00:00
Total Processed YTD |  |  |  |  |  |  |  |  |  |  | 2020-02-17 00:00:00
Average Turnaround (days) |  |  |  |  |  |  |  |  |  |  | 2020-05-25 00:00:00
Average Dollar Value |  |  |  |  |  |  |  |  |  |  | 0
Has Voucher |  |  |  |  |  |  |  |  |  |  | 0
No Voucher Yet |  |  |  |  |  |  |  |  |  |  | 0
0
Translation Vouchers |  |  |  |  |  | Earliest | Most Recent
[NAME] Per Day
Total Processed YTD
Average Turnaround (days) |  |  |  |  |  |  | DayCare
Average Dollar Value |  |  |  |  |  |  | Daycare
Has Voucher
No Voucher Yet
0
Travel Vouchers |  |  |  |  |  | Earliest | Most Recent
[NAME] Per Day
Total Processed YTD
Average Turnaround (days)
Average Dollar Value
Has Voucher
No Voucher Yet
0
All FY 20 Reqs |  |  |  |  |  | Earliest | Most Recent
[NAME] Per Day
Total Processed YTD
Average Turnaround (days)
Average Dollar Value
Has Voucher
No Voucher Yet
0
Overall Avg Received Per Day
Spreadsheet: 683390d1592688617-assistance-with-vlookup-function-clean-sheets-examplevlookup
Sheet: CLEAN WORKSHEET

PROPERTY | GUEST NAME | CHECK IN DATE | NEXT GUEST | CHECK IN DATE
Holiday House 1 | Guest 1 | 2020-06-18 00:00:00 | Guest 11 | 2020-06-28 00:00:00
Holiday House 2 | Guest 2 | 2020-06-19 00:00:00 | Guest 12 | 2020-06-29 00:00:00
Holiday House 3 | Guest 3 | 2020-06-20 00:00:00 | Guest 13 | 2020-06-30 00:00:00
Holiday House 4 | Guest 4 | 2020-06-21 00:00:00 | Guest 14 | 2020-07-01 00:00:00
Holiday House 5 | Guest 5 | 2020-06-22 00:00:00 | Guest 15 | 2020-07-02 00:00:00
Holiday House 6 | Guest 6 | 2020-06-23 00:00:00 | Guest 16 | 2020-07-03 00:00:00
Holiday House 7 | Guest 7 | 2020-06-24 00:00:00 | Guest 17 | 2020-07-04 00:00:00
Holiday House 8 | Guest 8 | 2020-06-25 00:00:00 | Guest 18 | 2020-07-05 00:00:00
Holiday House 9 | Guest 9 | 2020-06-26 00:00:00 | Guest 19 | 2020-07-06 00:00:00
Holiday House 10 | Guest 10 | 2020-06-27 00:00:00 | Guest 11 | 2020-06-28 00:00:00
Holiday House 1 | Guest 11 | 2020-06-28 00:00:00 | Guest 11 | 2020-06-28 00:00:00
Holiday House 2 | Guest 12 | 2020-06-29 00:00:00 | Guest 12 | 2020-06-29 00:00:00
Holiday House 3 | Guest 13 | 2020-06-30 00:00:00 | Guest 13 | 2020-06-30 00:00:00
Holiday House 4 | Guest 14 | 2020-07-01 00:00:00 | Guest 14 | 2020-07-01 00:00:00
Holiday House 5 | Guest 15 | 2020-07-02 00:00:00 | Guest 15 | 2020-07-02 00:00:00
Holiday House 6 | Guest 16 | 2020-07-03 00:00:00 | Guest 16 | 2020-07-03 00:00:00
Holiday House 7 | Guest 17 | 2020-07-04 00:00:00 | Guest 17 | 2020-07-04 00:00:00
Holiday House 8 | Guest 18 | 2020-07-05 00:00:00 | Guest 18 | 2020-07-05 00:00:00
Holiday House 9 | Guest 19 | 2020-07-06 00:00:00 | Guest 19 | 2020-07-06 00:00:00
Holiday House 10 | Guest 20 | 2020-07-07 00:00:00 | Guest 11 | 2020-06-28 00:00:00
Spreadsheet: 476068d1471599682-vlookup-with-indirect-and-substitute-quoteform-test
Sheet: Quote

 |  |  |  | QC | 2 |  |  |  |  |  |  | Cost Price | Cost price Total | Retail Total | Gross Profit
Client: |  | Test Client |  | Section Notes: |  |  |  |  |  |  |  |  | Cost Total | Retail Total | Gross Profit
Price Group: |  |  |  | Cell [NAME] the price group being quoted, which is obtained from choosing the range and style, taking its 'PG' number from the selected door style in cell C5. Cell C4 Specifies which Table is being used for the quote. |  |  |  |  |  |  |  | TOTALS:
Range: |  | Caledonia In Frame | <--- ** 1. Choose the 'Range' **
Door: |  | D 567 Lomond Natural Oak | <--- ** 2. Then Choose the Style **
Painted Door Colour: |  | N/A
Carcase: |  | Graphite GF U961
MATCHINGS / END PANELS: |  | Match Door
[NAME]: |  | [NAME]
Worktop: |  | AK Arkosa Sand 2550
Plinth: |  | SSP30 Stainless Steel
Unit No. | Unit Code | Description |  | [NAME] | Depth | Height | Handing | Qty | Quote Price | Total |  | Cost Price | Cost price Total | Retail Total | Gross Profit
1 | BFH3 |  |  |  |  |  | Left | 1 |  |  |  | If B13 is blank, then 0, otherwise Vlookup B13 on Range Table matching C4 headers returning the matched result for C3 from the price group column
2 | bfh10
3 | bfh6
4
*** Please hover your mouse over the sections with Comment corners, to see what it is that I need to acheive ***  To create a quote, the user must 1st select the 'Range' they will be using, then select an available 'Door' finish from that range.  Once these are selected, the 'Price Group' is shown in C3, which will determine the price of the selected items.  The user will then go on to select the other relevant selections and proceed to add their quote items into the 'Unit Code' section, and the price returned will be based on the selections made.
Spreadsheet: 121466d1316085692-graphing-issue-graph-issue-dc
Sheet: Report(1) (5)

need a 100% bar chart which shows each question. People were asked to select how they felt, 1 being min 10 [NAME] and na not bothered col d is # of vaote received .
Question # | Site Aspects | Scale: n/a = not bothered. 1 = min facilities. 10 = [NAME] facilities | Total number of votes
1 | Minimal facilities | N/A | 25
 |  | 1 | 41
 |  | 2 | 35
 |  | 3 | 40
 |  | 4 | 128
 |  | 5 | 127
 |  | 6 | 57
 |  | 7 | 78
 |  | 8 | 66
 |  | 9 | 30
 | Load of facilities | 10 | 92
2 | Quiet | N/A | 86
 |  | 1 | 105
 |  | 2 | 83
 |  | 3 | 63
 |  | 4 | 137
 |  | 5 | 107
 |  | 6 | 32
 |  | 7 | 24
 |  | 8 | 7
 |  | 9 | 2
 | Lively | 10 | 2
3 | Adults only | N/A | 17
 |  | 1 | 14
 |  | 2 | 9
 |  | 3 | 10
 |  | 4 | 43
 |  | 5 | 37
 |  | 6 | 14
 |  | 7 | 28
 |  | 8 | 34
 |  | 9 | 49
 | Open to all ages | 10 | 462
4 | Small number of pitches | N/A | 40
 |  | 1 | 42
 |  | 2 | 59
 |  | 3 | 54
 |  | 4 | 237
 |  | 5 | 155
 |  | 6 | 24
 |  | 7 | 31
 |  | 8 | 16
 |  | 9 | 8
 | Large number of pitches | 10 | 26
5 | Remote location | N/A | 27
 |  | 1 | 51
 |  | 2 | 67
 |  | 3 | 45
 |  | 4 | 216
 |  | 5 | 146
 |  | 6 | 53
 |  | 7 | 43
 |  | 8 | 22
 |  | 9 | 6
 | In the centre of things | 10 | 24
6 | Mostly grass pitches | N/A | 25
 |  | 1 | 29
 |  | 2 | 24
 |  | 3 | 30
 |  | 4 | 180
 |  | 5 | 146
 |  | 6 | 46
 |  | 7 | 44
 |  | 8 | 47
 |  | 9 | 23
 | Mostly hardstandings | 10 | 132
7 | Screened small pitching areas | N/A | 79
 |  | 1 | 87
 |  | 2 | 62
 |  | 3 | 43
 |  | 4 | 134
 |  | 5 | 101
 |  | 6 | 26
 |  | 7 | 35
 |  | 8 | 22
 |  | 9 | 15
 | Wide open site layout | 10 | 52
8 | For CC members only | N/A | 136
 |  | 1 | 95
 |  | 2 | 41
 |  | 3 | 35
 |  | 4 | 71
 |  | 5 | 68
 |  | 6 | 14
 |  | 7 | 14
 |  | 8 | 10
 |  | 9 | 13
 | Open to all | 10 | 45
9 | `Rules` atmosphere | N/A | 26
 |  | 1 | 44
 |  | 2 | 41
 |  | 3 | 49
 |  | 4 | 140
 |  | 5 | 101
 |  | 6 | 50
 |  | 7 | 53
 |  | 8 | 55
 |  | 9 | 32
 | Relaxed atmosphere | 10 | 133
10 | No electric hooks up available | N/A | 3
 |  | 1 | 2
 |  | 2 | 3
 |  | 3 | 3
 |  | 4 | 24
 |  | 5 | 16
 |  | 6 | 9
 |  | 7 | 40
 |  | 8 | 53
 |  | 9 | 48
 | Every pitch has EHU | 10 | 546
11 | No showers/toilets | N/A | 11
 |  | 1 | 10
 |  | 2 | 7
 |  | 3 | 5
 |  | 4 | 34
 |  | 5 | 29
 |  | 6 | 17
 |  | 7 | 20
 |  | 8 | 25
 |  | 9 | 48
 | Showers/toilets available | 10 | 536