tianzl66/Sheetpedia huggingface dataset:
Spreadsheet: 794804d1662322819-conditional-formatting-to-highlight-all-values-from-a-cell-table-hd
Sheet: CHORDS

 | Chord intervals |  |  |  |  |  |  | 1 | b2 | 2 | b3 | 3 | 4 | [NAME] | 5 | #5 | 6 | b7 | 7 | 1 | b2 | 2 | b3 | 3 | 4 | [NAME] | 5 | #5 | 6 | b7 | 7 | 1
 | 1 3 b5 b7 |  |  |  |  |  |  | 5 | #5 | 6 | b7 | 7 | 1 | b2 | 2 | b3 | 3 | 4 | [NAME] | 5 | #5 | 6 | b7 | 7 | 1 | b2 | 2 | b3 | 3 | 4 | [NAME] | 5
 |  |  |  |  |  |  |  | b3 | 3 | 4 | [NAME] | 5 | #5 | 6 | b7 | 7 | 1 | b2 | 2 | b3 | 3 | 4 | [NAME] | 5 | #5 | 6 | b7 | 7 | 1 | b2 | 2 | b3
 |  |  |  |  |  |  |  | b7 | 7 | 1 | b2 | 2 | b3 | 3 | 4 | [NAME] | 5 | #5 | 6 | b7 | 7 | 1 | b2 | 2 | b3 | 3 | 4 | [NAME] | 5 | #5 | 6 | b7
 |  |  |  |  |  |  |  | 4 | [NAME] | 5 | #5 | 6 | b7 | 7 | 1 | b2 | 2 | b3 | 3 | 4 | [NAME] | 5 | #5 | 6 | b7 | 7 | 1 | b2 | 2 | b3 | 3 | 4
 |  |  |  |  |  |  |  | 1 | b2 | 2 | b3 | 3 | 4 | [NAME] | 5 | #5 | 6 | b7 | 7 | 1 | b2 | 2 | b3 | 3 | 4 | [NAME] | 5 | #5 | 6 | b7 | 7 | 1
Spreadsheet: c11de222-ecf9-4505-be36-a1af4eba916e
Sheet: Sheet1

Securities | % of Assets
Dollarama Inc. | 4.03%
Fairfax Financial Holding | 3.93%
Metro Inc. | 3.91%
BCE Inc. | 3.74%
Alimentatn Couche-Tard B | 3.69%
Empire Company Cl A NVS | 3.52%
Tim Hortons Inc. | 3.11%
RioCan REIT | 2.91%
Keyera Corp | 2.87%
Rogers Communications Inc | 2.82%
TransCanada Corp. | 2.75%
Pembina Pipeline Inc | 2.72%
TELUS Corp. | 2.71%
Canadian REIT | 2.70%
Weston(George) Ltd. | 2.66%
Cdn Utilities Cl A NVS | 2.62%
Enbridge Inc. | 2.61%
Intact Financial Corp | 2.58%
Loblaw Companies Ltd. | 2.47%
Emera Inc. | 2.47%
Shaw Communicatn Cl B Nvs | 2.36%
Inter Pipeline Ltd. | 2.36%
AltaGas Ltd | 2.20%
Franco-Nevada Corp | 2.16%
ATCO Ltd Class I | 2.13%
Catamaran Corporation | 2.10%
Fortis Inc. | 2.02%
Thomson Reuters Corp | 1.96%
CGI Group Inc Cl A | 1.95%
Saputo Inc. | 1.93%
Open Text Corp. | 1.89%
Valeant Pharmaceuticals | 1.89%
Canadian Tire Corp Cl A | 1.84%
H&R REIT | 1.84%
CI Financial Corp | 1.83%
West Fraser Timber Co Ltd | 1.73%
TransAlta Corp. | 1.61%
National Bank of Canada | 1.57%
IGM Financial Inc. | 1.54%
CAE Inc. | 1.44%
Cash | 0.85%
Total Holdings in Portfolio | 41
Spreadsheet: 839028d1691597582-choose-the-wrigt-waiting-time-depending-on-the-delivery-example-1-
Sheet: Tabelle1

 |  |  |  |  |  |  |  | [NAME] needed for this, so the date
Produkt | Shop 1 need |  | Deliverance 1 | Deliverance 2 | Deliverance 2 | Deliverance 4 |  | Shop 1 Waiting longest time
 | VW 01 |  | 2020-01-01 00:00:00 | 2020-02-01 00:00:00 | 2020-03-01 00:00:00 | 2020-04-01 00:00:00
Product 1 | 20 |  | 5 | 5 | 10
Product 2 | 5 |  | 15 | 2 | 5
Product 3 | 30 |  | 5 | 7 | 6 | 20
Product 4 | 50 |  | 10 | 10 | 10 | 50
Product 5 | 15 |  | 5 | 10 | 2 | 30
Spreadsheet: 134583d1325494535-help-needed-for-total-formula-master-bill
Sheet: Payment

 | Payment |  |  |  | Day | Grand  Total | Total of  the Day | Collection
 |  |  |  |  | 1
 | Date | Paid (RM) |  |  | 2 |  |  |  |  | Total Value
 |  |  |  |  | 3 |  |  |  |  |  | Weekdays | Saturday | Sunday
 |  |  |  |  | 4 |  |  |  |  | Value 1
 |  |  |  |  | 5 |  |  |  |  | Value 2
 |  |  |  |  | 6 |  |  |  |  | Value 3
 |  |  |  |  | 7 |  |  |  |  | Value 4
 |  |  |  |  | 8 |  |  |  |  | Value 5
 |  |  |  |  |  |  |  |  |  | Value 6
 |  |  |  |  |  |  |  |  |  | Value 7
 |  |  |  |  |  |  |  |  |  | Value 8
 |  |  |  |  |  |  |  |  |  | Value 9
 |  |  |  |  |  |  |  |  |  | Value 10
 |  |  |  |  |  |  |  |  |  | Value 11
 |  |  |  |  |  |  |  |  |  | Value 12
 | Salary Per Month
 |  |  |  |  |  | Total
Spreadsheet: 857107d1706177572-lookup-and-sort-from-other-worksheet-inventory-test
Sheet: Baskets

Comments | Qty. | [NAME] | SERIAL # | Weight kg | Ship Date | Basket # | Backload Date
 |  | Container | 803813-9 |  | 2023-12-23 00:00:00
 |  | Tool Set 2-A | B123 |  |  | 803813-9
 |  | Tool Set 2-B | B124 |  |  | 803813-9
 |  | Tool Set 2-C | B125 |  |  | 803813-9
 |  | Tool Set 2-D | B126 |  |  | 803813-9
 |  | Container | DNV39X40029 |  | 2024-01-08 00:00:00
 |  | Broom | B1 |  |  | DNV39X40029
 |  | Scoop | S1 |  |  | DNV39X40029
 |  | Container | 803 799 0 |  | 2024-01-20 00:00:00
 |  | Shovel | SL1 |  |  | 803 799 0
Spreadsheet: 61525d1262406869-comparing-groups-of-numbers-for-duplicates-compare-columns-bvj-
Sheet: Sheet1

2 | 16 | 32 | 50 | 61 | 3 | 19 | 36 | 51 | 2 | 4 | 23 | 2 | 2 | 65 | 13 | 24 | 40 | 54 | 70 |  | 15 | 25 | 45 | 58 | 72
6 | 20 | 31 | 46 | 66 | 9 | 21 | 33 | 52 | 6 | 11 | 27 | 6 | 6 | 69 | 12 | 29 | 41 | 57 | 73 |  | 14 | 30 | 42 | 60 | 75
1 | 17 | 34 | 47 | 62 | 5 | 18 | 35 | 48 | 1 | 7 | 22 | 1 | 1 | 68 | 8 | 26 | 43 | 56 | 71 |  | 10 | 28 | 44 | 59 | 74
1 | 17 | 33 | 47 | 61 | 4 | 21 | 37 | 53 | 1 | 9 | 22 | 1 | 1 | 64 | 11 | 25 | 41 | 58 | 65 |  | 12 | 29 | 44 | 59 | 73
3 | 20 | 31 | 46 | 67 | 6 | 23 | 34 | 48 | 3 | 10 | 24 | 3 | 3 | 69 | 13 | 27 | 40 | 52 | 72 |  | 15 | 30 | 42 | 60 | 75
2 | 16 | 32 | 49 | 62 | 5 | 18 | 35 | 51 | 2 | 7 | 19 | 2 | 2 | 70 | 8 | 26 | 43 | 55 | 71 |  | 14 | 28 | 45 | 57 | 74
2 | 17 | 31 | 47 | 66 | 7 | 21 | 32 | 52 | 2 | 10 | 25 | 2 | 2 | 69 | 13 | 26 | 40 | 55 | 74 |  | 14 | 28 | 41 | 58 | 75
4 | 16 | 35 | 46 | 63 | 5 | 20 | 42 | 48 | 4 | 9 | 22 | 4 | 4 | 68 | 12 | 27 | 44 | 57 | 70 |  | 15 | 30 | 45 | 60 | 72
1 | 18 | 33 | 49 | 61 | 3 | 19 | 34 | 50 | 1 | 6 | 23 | 1 | 1 | 65 | 8 | 24 | 38 | 56 | 71 |  | 11 | 29 | 39 | 59 | 73
4 | 16 | 31 | 48 | 62 | 10 | 18 | 34 | 49 | 4 | 11 | 20 | 4 | 4 | 67 | 14 | 24 | 40 | 54 | 68 |  | 15 | 26 | 42 | 60 | 73
Spreadsheet: 77099d1277546889-conditional-formatting-book1
Sheet: Sheet1

Income | expence | Total | NOW |  | Tasks:
18.4 | 0 |  |  |  | Math book | 22
 |  |  |  |  | Lunch | 5
 |  |  |  |  | Video game | 50
Spreadsheet: 863276d1710836187-pull-only-jan-data-jan-data
Sheet: Sheet1

Column1 | Column2 | Column3 | Column4 | Column5 | Column6 | Column62 | Column7 | year |  |  |  | jan value | last value for year
2023-11-07 00:00:00 | p | 542 | 11.29 |  |  |  |  |  | 2023-01-01 00:00:00 | 2023-01-31 00:00:00 | 2023
2023-12-04 00:00:00 | d | 5.049 | 12.06 |  |  |  |  |  | 2024-01-01 00:00:00 | 2024-01-31 00:00:00 | 2024
2024-01-04 00:00:00 | d | 4.905 | 12.2691
2024-02-05 00:00:00 | d | 4.877 | 12.4482 |  |  |  |  |  |  |  | Correct data
2024-03-06 00:00:00 | d | 4.9 | 12.5 |  |  |  |  |  |  |  |  | Jan Value | Last value for year
2024-03-15 00:00:00 | d |  |  |  |  | 15.3 |  |  |  |  | 2023 | NA | 60.891 |  | NA - No Jan 2023 entry. Need first entry for Jan, there may be 2 or more for Jan of any given year.
 |  |  |  |  |  |  |  |  |  |  | 2024 | 60.18 | 15.3 |  | Jan 2024 value is 60.18
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  | Last entry for 2024 is 15.30
 | Sub-Total |  |  |  |  |  |  |  |  |  |  | Jan Value | Last Value for year
 |  |  |  |  |  |  |  |  |  |  | 2023 | NA | 60.89094000000001
 |  |  |  | Total F & G |  |  |  |  |  |  | 2024 | 60.1799355 | 15.3
 |  |  |  |  | 60.89094000000001
 |  |  |  |  | 60.1799355
 |  |  |  |  | 60.7098714
 |  |  |  |  | 61.25000000000001
 |  |  |  |  | 15.3
 |  |  |  |  | 0
 |  |  |  |  | 0
 |  |  |  |  | 0
Spreadsheet: 115889d1311347855-excel-2007-matching-columns-worksheetone
Sheet: Worksheet1

productID | code | sectionID
2 | 1580420567 | 12
5 | 1880685086 | 12
6 | g6x | 14
8 | 1874061408 | 7
14 | 870678884 | 7
16 | [NAME] | 4
18 | 818400641 | 4
24 | [NAME] | 4
26 | g26x | 12
29 | 948353996 | 13
35 | g35x | 12
36 | 1880685221 | 12
42 | 094598314x | 12
49 | g49x | 12
53 | 9780122407611 | 7
56 | g56x | 7
58 | g58x | 9
59 | 396086810 | 7
60 | 818405295 | 7
67 | 897460294 | 7
68 | g68x | 10
81 | 818405554 | 4
82 | 399526838 | 4
85 | 897460146 | 4
86 | 572017138 | 9
88 | 948353767
89 | g89x | 4
90 | 897460561 | 12
93 | g93x | 12
94 | 1871093120 | 9
95 | 395701317 | 9
96 | 9781874061137 | 12
101 | 897460685 | 4
106 | g106x | 4
107 | 940685876 | 7
108 | 940685752 | 12
125 | [NAME] | 7
129 | g129x | 12
130 | g130x | 4
153 | 933893868 | 9
156 | g156x | 7
158 | g158x | 9
160 | 349115192 | 12
172 | 952823101 | 9
177 | 140145931 | 13
184 | 1 | 12
196 | g196x | 2
202 | 870190067 | 7
207 | g207x | 7
210 | 753510456 | 9
224 | g224x | 7
225 | 870190113 | 2
229 | 896507084 | 7
234 | 870190598 | 8
235 | 870190202 | 7
239 | 870190245 | 12
251 | g251x | 7
260 | g260x | 7
261 | g261x | 7
288 | g288x | 9
294 | 668039728
301 | 879802693 | 9
302 | 879802650 | 9
306 | g306x | 9
313 | g313x | 9
314 | 9780879800703
324 | 085207218X | 8
329 | 9781580422628 | 7
341 | g341x | 7
342 | g342x | 7
347 | [NAME] | 7
348 | 9780091900212 | 7
351 | g351x | 7
354 | 1851588167 | 9
360 | g360x | 7
364 | g364x
369 | g369x | 9
371 | [NAME]
374 | g374x | 7
387 | 942280121 | 7
392 | g392x | 12
398 | g398x | 7
403 | 671656554 | 9
411 | g411x | 7
413 | g413x | 7
418 | 486236307 | 7
419 | 1580420702 | 9
425 | 1860542956 | 8
426 | g426x | 9
427 | g427x | 13
429 | 1880685108 | 12
430 | 1880685000 | 12
439 | 1580420435 | 3
440 | g440x | 7
441 | 940685264 | 13
444 | g444x | 4
445 | 188068523X | 12
446 | 1880685051 | 4
447 | 1880685043 | 7
448 | 1880685035 | 7
449 | g449x | 12
450 | 1880685094 | 12
457 | g457x | 14
464 | 1580421431
465 | g465x | 12
469 | g469x | 9
470 | 395701325 | 9
481 | 1874645043 | 9
486 | 1871093414 | 7
489 | g489x | 12
490 | g490x | 9
492 | 1871093678 | 9
493 | 9780929712130 | 4
496 | g496x
499 | g499x | 12
500 | 929712005 | 7
505 | 940685299 | 12
506 | g506x | 12
511 | g511x | 7
520 | g520x | 7
522 | g522x
523 | 1566250277 | 7
528 | 9781851588169 | 7
531 | 818405538 | 13
535 | g535x
538 | g538x
539 | g539x | 8
550 | g550x
563 | g563x | 9
575 | 9780851315867 | 9
577 | 1580420281 | 4
578 | g578x | 9
579 | [NAME] | 4
581 | [NAME] | 4
582 | g582x | 4
583 | 935926194 | 4
584 | 896508811 | 9
589 | g589x | 1
592 | [NAME]
593 | 935926232 | 4
594 | 312050585 | 16
596 | g596x
601 | g601x
607 | 1580420869 | 8
619 | 1861263287 | 8
624 | 966100727 | 12
627 | 1901982076 | 7
629 | g629x | 12
638 | 1580421032 | 12
644 | 897092066 | 9
652 | 940685469 | 10
653 | g653x | 8
658 | g658x | 7
660 | g660x | 9
663 | g663x | 12
664 | g664x | 12
666 | 158042080X | 12
669 | g669x | 9
677 | g677x
678 | g678x
680 | g680x
681 | 1580420583
689 | g689x
697 | 9780688127909
707 | 1871093821
710 | g710x
712 | 1874061009
721 | 1899506403
745 | 9781580422857
Spreadsheet: 110970d1307509360-multiple-lookup-in-a-single-cell-with-data-validation-multiple-lookup
Sheet: Sheet1

Anil | Mumbai |  |  |  |  | Output
 |  |  |  |  |  | Mother | 2
 |  |  |  |  |  | Father | 5
 |  |  |  |  |  | Brother | 1
 |  |  |  | Data
Input |  |  |  | Ajay
Ajay | Delhi |  |  | Delhi | Mumbai | Kolkata | Chennai | [NAME]
Anil | Mumbai |  |  | 1 | 3 | 2 | 1 | 5
Amit | Kolkata |  |  | 2 | 6 | 4 | 5 | 3
Kartik | Chennai |  |  | 2 | 2 | 3 | 2 | 1
 | [NAME]
 |  |  |  | Anil
 |  |  |  | Delhi | Mumbai | Kolkata | Chennai | [NAME]
 |  |  |  | 4 | 2 | 6 | 1 | 2
 |  |  |  | 7 | 5 | 4 | 3 | 3
 |  |  |  | 3 | 1 | 2 | 2 | 3
 |  |  |  | Amit
 |  |  |  | Delhi | Mumbai | Kolkata | Chennai | [NAME]
 |  |  |  | 3 | 1 | 5 | 6 | 2
 |  |  |  | 5 | 1 | 4 | 2 | 8
 |  |  |  | 1 | 1 | 3 | 4 | 3
 |  |  |  | Kartik
 |  |  |  | Delhi | Mumbai | Kolkata | Chennai | [NAME]
 |  |  |  | 3 | 2 | 8 | 1 | 4
 |  |  |  | 2 | 2 | 5 | 3 | 7
 |  |  |  | 3 | 1 | 2 | 5 | 6
Spreadsheet: 79669d1279883522-excel-2007-trend-line-in-charts-book1
Sheet: Sheet1

 |  | Index
 | 2001 | 127.4888888888889
 | 2002 | 147.15
 | 2003 | 182.075
 | 2004 | 211.9583333333333
 | 2005 | 229.575
 | 2006 | 236.3833333333333
 | 2007 | 248.4
 | 2008 | 242.8916666666667
 | 2009 | 214.7416666666667
 | 2010 | 222.02
 | 2011
 | 2012
 | 2013
 | 2014
 | 2015
 | 2016
 | 2017
 | 2018
 | 2019
 | 2020
 | 2021
 | 2022
 | 2023
 | 2024
 | 2025
 | 2026
 | 2027
 | 2028
 | 2029
 | 2030
 | 2031
Spreadsheet: 88430d1288262387-data-filters-for-making-dynamic-interactive-error-graphs-defect-data-dashboard
Sheet: Raw Defect Data

 | MATRIX OF DEFECT DATA
Resources → | R1 | R2 | R3 | R4 | R5 | R6 | R7 | R8 | R9 | R10 | Total Defects | % of Total Defect
Defect type ↓ |  |  |  |  |  |  |  |  |  |  | in a Row
D1 | 3 | 5 | 7 | 3 | 8 | 3 | 1 | 5 | 5 | 5
D2 | 5 | 2 | 3 | 7 | 4 | 4 | 3 | 3 | 7 | 2
D3 | 8 | 3 | 9 | 3 | 5 | 2 | 7 | 1 | 8 | 3
D4 | 4 | 1 | 2 | 3 | 6 | 5 | 3 | 6 | 2 | 3
D5 | 7 | 3 | 6 | 5 | 4 | 1 | 2 | 5 | 7 | 4
D6 | 3 | 7 | 3 | 6 | 2 | 3 | 6 | 5 | 4 | 7
D7 | 5 | 1 | 4 | 4 | 4 | 3 | 3 | 5 | 1 | 4
D8 | 2 | 2 | 7 | 2 | 3 | 2 | 5 | 6 | 4 | 6
D9 | 4 | 8 | 3 | 1 | 3 | 5 | 7 | 3 | 5 | 3
D10 | 10 | 5 | 5 | 4 | 7 | 3 | 4 | 6 | 5 | 6
Total Number of Defects
% Defect
 |  | Cell with this color shows Maximum value of Defect for the Resource in that column
 |  | Cell with this color shows Minimum value of Defect for the Resource in that column
Spreadsheet: 72443d1273129919-excel-formula-with-nested-if-test
Sheet: Sheet1

 |  |  |  |  |  |  |  |  | 2.72
 |  |  |  |  |  |  |  |  |  |  |  |  | [NAME] results
 |  |  |  |  |  |  |  |  | 7.214260032649146 |  | 40/40 |  | 40/40
 |  |  |  |  |  |  |  |  | 16.8166241123339 |  | 60/30 |  | 40/40
 |  |  |  |  |  |  |  |  | 20.00076284171465 |  | 60/30 |  | 40/40
 |  |  |  |  |  |  |  |  | 23.18490157109544 |  | 80/30 |  | 40/40
 |  |  |  |  |  |  |  |  | 26.36904030047621 |  | 80/30 |  | 40/40
 |  |  |  |  |  |  |  |  | 29.55317902985693 |  | 100/30 |  | 40/40
 |  |  |  |  |  |  |  |  | 32.73731775923771 |  | 100/30 |  | 40/40
 |  |  |  |  |  |  |  |  | 35.92145648861847 |  | 100/30 |  | 40/40
 |  |  |  |  |  |  |  |  | 39.1055952179992 |  | 130/30 |  | 40/40
 |  |  |  |  |  |  |  |  | 42.28973394737996 |  | 130/30 |  | 60/30
 |  |  |  |  |  |  |  |  | 45.47387267676071 |  | 130/30 |  | 60/30
 |  |  |  |  |  |  |  |  | 48.65801140614147 |  | 160/50 |  | 60/30
 |  |  |  |  |  |  |  |  | 51.84215013552222 |  | 160/50 |  | 60/30
 |  |  |  |  |  |  |  |  | 55.02628886490304 |  | 160/50 |  | 60/30
 |  |  |  |  |  |  |  |  | 58.21042759428379 |  | 160/50 |  | 60/30
 |  |  |  |  |  |  |  |  | 61.39456632366451 |  | #N/A |  | 80/30
 |  |  |  |  |  |  |  |  | 64.57870505304527 |  | #N/A |  | 80/30
 |  |  |  |  |  |  |  |  | 67.762843782426 |  | #N/A | errors | 80/30
 |  |  |  |  |  |  |  |  | 70.94698251180678 |  | #N/A |  | 80/30
 |  |  |  |  |  |  |  |  | 74.13112124118751 |  | #N/A |  | 80/30
 |  |  |  |  |  |  |  |  | 57.68793197204739 |  | 160/50 |  | 60/30
Spreadsheet: 840230d1692587690-transforming-database-with-formulas-transforming-database-with-formula-1-1-
Sheet: Transoformed Base

 | Date |  | Dr |  | Our ref. |  |  | Currency code |  | Cr | Amount
 |  | ალექსანდრე Aleksandr კოსილოვ [NAME] | 313100 | Trade and other payables | 0 | 01/31/2022(6) | 0 | USD | Cash and cash equivalents | 122001 | 1080.54 | Result are missing
 |  | შპს ვესტა | 311000 | Trade and other payables | 20004774 | ა/ფ ეა-74 5611772,ელ0651246103 | 0 | GEL | Trade and other receivables | 143000 | 40 | Result are missing
 |  | ამხანაგობა პისიარ დიაგნოსტიკური და კვლევითი ლაბორა | 721026 | Cost of sales | 20004767 | ინვ.#008 | 0 | GEL | Trade and other payables | 311000 | 400
 |  | შპს ჰელიქსირ | 721001 | Cost of sales | 10012775 | ეა-74 5968634. [PHONE] | 0 | GEL | Inventories | 165000 | 4319.9
Spreadsheet: 863589d1711017730-index-with-multiple-criteria-with-results-displayed-horizontally-index-with-multiple-criteria-test-sheet
Sheet: AVAILABILITY

Item | Batch | Quantity One | Quantity Two | Quantity Three
Product 1 | 32165
Product 2 | 36247
Product 3 | 32845
Product 4 | 37415
Product 5 | 39521
Spreadsheet: 126917d1320057797-excel-2007-conditional-formatting-learning
Sheet: Sheet1

 |  |  | S.No. | SLA | Task | Ref No. | Status
 |  |  | 1 | Rejected | V&A | 123 | urgent
 |  |  | 2 | Rejected | CA | 345 | legacy
 |  |  | 3 | Rejected | QC | 456 | urgent
 |  |  | 4 | Rejected | CA | 641 | voip
 |  |  | 5 | Rejected | V&A | 807.5 | legacy
 |  |  | 6 | Rejected | V&A | 974 | voip
 |  |  | 7 | Rejected | QC | 1140.5 | voip
 |  |  | 8 | Rejected | QC | 1307 | voip
 |  |  | 9 | Rejected | CA | 1473.5 | urgent
 |  |  | 10 | Rejected | CA | 1640 | legacy
urgent
legacy
voip |  | Rejected
 |  | Approved
Spreadsheet: 78211d1278608125-using-a-dropdown-list-to-autofill-a-worksheet-example-worksheet
Sheet: Sheet1

ITEM | [NAME] | [NAME] | [NAME]
Company Name | LIST HERE | LIST HERE | LIST HERE
Headquarters Address
Website
Plant Locations
Number of Employees
Company Start Date
Stock Information
Feedstock Material
Products
Process Chemicals
Plant Production Capability
Plant/Capital Cost
Plant Capital Cost
Process Description
Funding Groups
Amount of Funding
Partners
 | Example company info that would be inserted if Abengoa was selected the list of companies in Cells B3 [NAME]
Company Name | Abengoa(selected from drop down list) | Blue Fire Ethanol (selected from drop down list)
Headquarters Address |  | Irving, CA
Website | http://www.abengoabioenergy.com/corp/web/en/index.html | http://bluefireethanol.com/
Plant Locations | Brazil, USA | California
Number of Employees | 200 | 200
Company Start Date | 1982 | 2006
Stock Information
Feedstock Material | corn, trash, sewage sludge | energy crops
Products | Bioethanol, Biodesiel | ethanol
Process Chemicals
Plant Production Capability | No commercial plant yet |  | <---This is the info that would change based on the selection of the company
Plant/Capital Cost | $ | $
Plant Capital Cost | $ | $
Process Description | Gasification and/Uses enzymes to break cellulose into sugar | Concentrated Acid Hydrolysis Technology Process
Funding Groups | Venture Capitalist | Quercus Trust
Amount of Funding | $$$$$$ | $$$$$$
Partners | Owner, operator | Owner, Operator
Companies within the drop down list in cells B3,C3,D3
Abengoa
Alico, Inc
[NAME]
BlueFire
[NAME]
[NAME]
Choren
Codexis
Coskata
Dynamotive
Enerkem
Iogen
LS9, Inc
Masada
Mascoma
POET
Power Energy Fuels Inc.
[NAME]
Sapphire
[NAME]
Standard Alcohol Company
Virent
Zeachem
KiOR
Lignol
Synthetic Genomics
RenTech
Oxford Catalyst
[NAME]
Butamax Advanced Biofuels
[NAME]
[NAME]
Solazyme
Verenium
Spreadsheet: 12180bf4-5387-4d88-91f7-4abc79cf3100
Sheet: Sheet1

Unnamed: 0 | Unnamed: 1 | Unnamed: 2 | Unnamed: 3 | Unnamed: 4 | Unnamed: 5 | Unnamed: 6 | Unnamed: 7 | Unnamed: 8 | Unnamed: 9
 |  |  |  |  |  |  |  |  | FINANCIAL PROJECTIONS WORKSHEET
 |  |  |  |  |  |  |  |  | Enter your company name here
 | Current Year - Actual | % of sales | Year 1 | % of sales | Year 2 | % of sales | Year 3 | % of sales | Assumptions
 |  | % of sales |  | % of sales |  | % of sales |  | % of sales
Revenue |  | 1 | 0 | 1 | 0 | 1 | 0 | 1
Total Revenues | 0 | 1 | 0 | 1 | 0 | 1 | 0 | 1
Cost of Goods Sold
COGS - Materials |  |  | 0 |  | 0 |  | 0
COGS - Labor | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0
COGS - Other | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0
Total COGS | 0 |  | 0 |  | 0 |  | 0
Gross Profit | 0 |  | 0 |  | 0 |  | 0
Expenses
Payroll Expenses(taxes) | 0 |  | 0 |  | 0 |  | 0
Advertising |  |  | 0 |  | 0 |  | 0
Finance Charge | 0 |  | 0 |  | 0 |  | 0
Bank Charges | 0 |  | 0 |  | 0 |  | 0
Health Insurance | 0 |  | 0 |  | 0 |  | 0
Wages - Office | 0 |  | 0 |  | 0 |  | 0
Wages - Officer | 0 |  | 0 |  | 0 |  | 0
Amortization | 0 |  | 0 |  | 0 |  | 0
Automobile Expense |  |  | 0 |  | 0 |  | 0
Depreciation |  |  | 0 |  | 0 |  | 0
Dues & Subscriptions | 0 |  | 0 |  | 0 |  | 0
Equipment Maintenance | 0 |  | 0 |  | 0 |  | 0
Building Maintenance | 0 |  | 0 |  | 0 |  | 0
Freight & Delivery |  |  | 0 |  | 0 |  | 0
Insurance |  |  | 0 |  | 0 |  | 0
Office Expense |  |  | 0 |  | 0 |  | 0
Operating Supplies |  |  | 0 |  | 0 |  | 0
Postage | 0 |  | 0 |  | 0 |  | 0
Professional Fees |  |  | 0 |  | 0 |  | 0
Rent | 0 |  | 0 |  | 0 |  | 0
Shop Supplies |  |  | 0 |  | 0 |  | 0
Taxes (property) | 0 |  | 0 |  | 0 |  | 0
Telephone | 0 |  | 0 |  | 0 |  | 0
Travel & Entertainment |  |  | 0 |  | 0 |  | 0
Utilities |  |  | 0 |  | 0 |  | 0
Waste Pick Up | 0 |  | 0 |  | 0 |  | 0
Other Operating Expenses |  |  | 0 |  | 0 |  | 0
Total | 0 |  | 0 |  | 0 | /=SUM(G44) | 0
Interest Expense |  |  | 0 |  | 0 |  | 0
Other Expense | 0 |  | 0 |  | 0 |  | 0
Other Income | 0 |  | 0 |  | 0 |  | 0
Net Operating Income | 0 |  | 0 |  | 0 |  | 0
Income Taxes | 0 |  | 0 |  | 0 |  | 0 |  | Imputed at 40%
Net Profit | 0 |  | 0 |  | 0 |  | 0
 | 0 |  | 0 |  | 0 |  | 0
 |  |  | 0
Spreadsheet: 96732d1296049119-stuck-lookup-help-tcc-new-final-left
Sheet: wk22

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