tianzl66/Sheetpedia huggingface dataset:
Spreadsheet: 139996d1328579188-how-to-make-dashboard-scroll-table-dashboard-table-scroll
Sheet: Dashboard

 |  | [NAME]
 |  |  |  |  | KPI 1 | KPI 2 | KPI 3 | [NAME] | KPI 5
 |  | 1 | Product Name 1 |  | 284 | 267 | 0.28 | -11 | 348.83
 |  | 2 | Product Name 2 |  | 170 | 218 | 0.86 | -11 | 734.27
 |  | 3 | Product Name 3 |  | 760 | 9 | 0.95 | -30 | 503.34
 |  | 4 | Product Name 4 |  | 366 | 388 | 0.35 | 47 | 367.9
 |  | 5 | Product Name 5 |  | 1345 | 130 | 0.58 | 74 | 477.47
 |  | 6 | Product Name 6 |  | 790 | 181 | 0.97 | -10 | 678.05
 |  | 7 | Product Name 7 |  | 1269 | 319 | 0.78 | 24 | 373.29
 |  | 8 | Product Name 8 |  | 107 | 16 | 0.59 | 61 | 532.21
 |  | 9 | Product Name 9 |  | 501 | 486 | 0.56 | 67 | 265
 |  | 10 | Product Name 10 |  | 953 | 259 | 0.05 | 74 | 855.81
 |  |  |  | ▼
Spreadsheet: 107102d1304309974-excel-2007-exception-reporting-between-worksheets-currentemployees
Sheet: Current Employee

Name | Past?
[NAME]
Fred
[NAME]
[NAME]
[NAME]
[NAME]
Jeanne
[NAME]
[NAME]
Jannet
[NAME]
Spreadsheet: 764390d1642706492-plus-minus-season-long-total-swindy-totals-2
Sheet: Sheet1

 | MUST USE CODES |  |  | TOURNAMENT TOTALS |  |  |  | SWINDERLER | GOLFER LEADERBOARD |  |  | SWINDLER LEADERBOARD
 | SWINDLERS | GOLFERS |  | EVENT/DAY | SWINDLER | GOLFER | PLUS/MINUS | ROUND | GOLFER | SEASON TOTAL |  | SWINDLER | SEASON TOTAL |  | GOLFER | SEASON TOTAL |  | SWINDLER | SEASON TOTAL
 | Bad Boys | JT |  | Tourney of Champs / R1 | Texan | JT | 15 |  |  |  |  |  |  |  | JT |  |  | Bad Boys |  |  | The formula for total round differences is in COL I
 | Bear Jew | Rahm |  |  | Ricky | Rahm | 70 |  |  |  |  |  |  |  | Rahm |  |  | Bear Jew |  |  | The input should stay in the format in Cols F -H
 | Big Cat | X |  |  | Rhino | X | 45 |  |  |  |  |  |  |  | X |  |  | Big Cat
 | [NAME] | [NAME] |  |  | Shetty | [NAME] | 60 |  |  |  |  |  |  |  | [NAME] |  |  | [NAME]
 | Buggy | Hovland |  |  | [NAME] | Hovland | 55 |  |  |  |  |  |  |  | Hovland |  |  | Buggy
 | Chief | Spieth |  |  | [NAME] | Spieth | 35 |  |  |  |  |  |  |  | Spieth |  |  | Chief
 | Dingo | Cantlay |  |  | Big Cat | Cantlay | 75 |  |  |  |  |  |  |  | Cantlay |  |  | Dingo
 | Doc |  |  | Tourney of Champs / R2 | Rhino | JT | 55 |  |  |  |  |  |  |  |  |  |  | Doc
 | Fluff |  |  |  | Rhino | Rahm | 50 |  |  |  |  |  |  |  |  |  |  | Fluff
 | JVC |  |  |  | Shetty | X | 15 |  |  |  |  |  |  |  |  |  |  | JVC
 | Mitchies |  |  |  | Fluff | Hovland | 35 |  |  |  |  |  |  |  |  |  |  | Mitchies
 | Pilot Jon |  |  |  | Mitchies | Hovland | 40 |  |  |  |  |  |  |  |  |  |  | Pilot Jon
 | Redneck |  |  |  | Pilot Jon | Spieth | 60 |  |  |  |  |  |  |  |  |  |  | Redneck
 | Rhino |  |  | Tourney of Champs / R3 |  |  |  |  |  |  |  |  |  |  |  |  |  | Rhino
 | Ricky |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | Ricky
 | Shetty |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | Shetty
 | Snowden |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | Snowden
 | Texan |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | Texan
 | [NAME] |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | [NAME]
 | [NAME] |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | [NAME]
Spreadsheet: gstorey__12024__DEC00
Sheet: table 7

Weighted Average Alberta Border Prices For Exports of Alberta Natural Gas * |  |  |  |  |  |  |  |  |  |  |  |  | Table 7
[NAME] ponderée des prix à la frontière de l'Alberta obtenus pour les exportations de gaz [NAME]
 |  | Firm Sales |  |  |  | Interruptible Sales |  |  |  | Total Sales
 |  | Ventes - service guaranti |  |  |  | Ventes - service interruptible |  |  |  | Total des ventes
 |  |  | [NAME]. | [NAME]. | Avg. Alta. |  | [NAME]. | [NAME]. | Avg. Alta. |  | [NAME]. | [NAME]. | Avg. Alta.
 |  |  | Exp. Price/ | Transp. Cost/ | Border Price/ |  | Exp. Price/ | Transp. Cost/ | Border Price/ |  | Exp. Price/ | Transp. Cost/ | Border Price/
 |  |  | Moy. des prix | Moy. des coûts | Moy. des prix |  | Moy. des prix | Moy. des coûts | Moy. des prix |  | Moy. des prix | Moy. des coûts | Moy. des prix
Period/ |  | Volume | à l'exp | de transp | à la frontière | Volume | à l'exp | de transp | à la frontière | Volume | à l'exp | de transp | à la frontière
[NAME] |  | Millions | ($CDN/GJ) | ($CDN/GJ) | ($CDN/GJ) | Millions | ($CDN/GJ) | ($CDN/GJ) | ($CDN/GJ) | Millions | ($CDN/GJ) | ($CDN/GJ) | ($CDN/GJ)
 |  | m3 |  |  |  | m3 |  |  |  | m3
2000/11 |  | 5016.307767361215 | 6.533658110541094 | 0.3344452418791156 | 6.199212868661978 | 2594.074301271783 | 6.837894426903227 | 0.317371584081162 | 6.520522842822065 | 7610.382068632999 | 6.63742829176481 | 0.328621688054146 | 6.308806603710664
2000/12 |  | 5620.780463180547 | 9.071868852886112 | 0.3288526852904404 | 8.743016167595671 | 2999.377496819451 | 10.17836214793882 | 0.3406199494790782 | 9.837742198459743 | 8620.15796 | 9.457043252321203 | 0.3329489133806763 | 9.124094338940527
2000/11 | 2000/11 | 5016.307767361215 | 6.533658110541094 | 0.3344452418791156 | 6.199212868661978 | 2594.074301271783 | 6.837894426903227 | 0.317371584081162 | 6.520522842822065 | 7610.382068632999 | 6.63742829176481 | 0.328621688054146 | 6.308806603710664
2000/11 | 2000/12 | 10637.08823054176 | 7.879302487515769 | 0.3314803216694128 | 7.547822165846356 | 5593.451798091233 | 8.6346951453288 | 0.3298766232366506 | 8.30481852209215 | 16230.540028633 | 8.13978023716365 | 0.3309273274689011 | 7.80885290969475
Note: *Average alberta border price is net of ex-Alberta transportation costs. |  |  |  |  |  |  |  | Nota: * Il s'agit du prix moyen à la frontière de l'Alberta sans les coûts de
 |  |  |  |  |  |  |  |  | transport hors [NAME]
Figures may not total due to rounding. |  |  |  |  |  |  |  | Les chiffres peuvent ne pas correspondre au total parce qu'ils ont été arrondis.
Spreadsheet: 853716d1703672364-formula-add-trailing-zero-before-right-2-column-book12
Sheet: Sheet1

number | len | rezult | len
1205 |  | 12000005
12305 |  | 12300005
123405 |  | 12340005
1234505 |  | 12345005
Spreadsheet: 161575d1339563256-excel-does-not-recognize-autofill-pattern-autofill-question
Sheet: Sheet1

This is what I want autofill to do | But when I use autofill (using b3:b10), this is what it does…
2012-06-12 00:00:00 | 2012-06-12 00:00:00 | 2012-06-12 00:00:00
2012-06-12 00:00:00 | 2012-06-12 00:00:00
2012-06-12 00:00:00 | 2012-06-12 00:00:00
2012-06-12 00:00:00 | 2012-06-12 00:00:00
2012-06-13 00:00:00 | 2012-06-13 00:00:00 | 2012-06-13 00:00:00
2012-06-13 00:00:00 | 2012-06-13 00:00:00
2012-06-13 00:00:00 | 2012-06-13 00:00:00
2012-06-13 00:00:00 | 2012-06-13 00:00:00
2012-06-14 00:00:00 | 2012-06-12 00:00:00
2012-06-14 00:00:00 | 2012-06-12 00:00:00
2012-06-14 00:00:00 | 2012-06-12 00:00:00
2012-06-14 00:00:00 | 2012-06-12 00:00:00
 | 2012-06-13 00:00:00
 | 2012-06-13 00:00:00
 | 2012-06-13 00:00:00
 | 2012-06-13 00:00:00
Spreadsheet: 844588d1696354681-running-total-with-reset-at-new-value-never-lower-than-zero-example-1
Sheet: Sheet1

 | Net Points |  |  |  |  |  |  |  |  |  |  |  |  | POINTS ASSESSED |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | POINTS CREDITED
 | Current Active Month | 1 Month Prior | 2 Month Prior | 3 Month Prior | 4 Month Prior | 5 Month Prior | 6 Month Prior | 7 Month Prior | 8 Month Prior | 9 Month Prior | 10 Month Prior | 11 Month Prior | 12 Month Prior | Current Active Month | 1 Month Prior | 2 Month Prior | 3 Month Prior | 4 Month Prior | 5 Month Prior | 6 Month Prior | 7 Month Prior | 8 Month Prior | 9 Month Prior | 10 Month Prior | 11 Month Prior | 12 Month Prior | 13 Month Prior | 14 Month Prior | 15 Month Prior | 16 Month Prior | 17 Month Prior | 18 Month Prior | 19 Month Prior | 20 Month Prior | 21 Month Prior | 22 Month Prior | 23 Month Prior | 24 Month Prior | Current Active Month | 1 Month Prior | 2 Month Prior | 3 Month Prior | 4 Month Prior | 5 Month Prior | 6 Month Prior | 7 Month Prior | 8 Month Prior | 9 Month Prior | 10 Month Prior | 11 Month Prior | 12 Month Prior | 13 Month Prior | 14 Month Prior | 15 Month Prior | 16 Month Prior | 17 Month Prior | 18 Month Prior | 19 Month Prior | 20 Month Prior | 21 Month Prior | 22 Month Prior | 23 Month Prior | 24 Month Prior
 |  |  |  |  |  |  |  |  |  |  |  |  |  | 3 | 2 | 0 | 0 | 0 | 0 | 0 | 0 | 2 | 0 | 0 | 0 | 0 | 0 | 2 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | -0.5 | -0.5 | -0.5 | -0.5 | -0.5 | -0.5 | 0 | -0.5 | -0.5 | -0.5 | -0.5 | -0.5 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0
Expected Result | 5 | 2 | 0 | 0 | 0 | 0.5 | 1 | 1.5 | 2 | 0 | 0 | 0.5 | 1
Spreadsheet: 472080d1469439917-time-calculation-formula-not-working-well-copy-of-book16
Sheet: Sheet1

OPEN DATE | RECEIPT DATE | CLOSE DATE | Time period |  |  |  | =ISTEXT(A1) | =ISNUMBER(A1)
2016-12-07 09:37:36 | 2016-12-07 09:39:18 | 2016-12-07 09:39:50
2016-12-07 09:33:20 | 2016-12-07 09:36:33 | 2016-12-07 09:37:19
2016-12-07 07:51:33 | 2016-12-07 07:52:33 | 2016-12-07 07:53:01
2016-12-07 09:54:35 | 2016-12-07 10:08:48 | 2016-12-07 10:09:33
7/13/2016 11:08:27 AM | 7/13/2016 11:15:03 AM | 7/13/2016 11:15:37 AM
7/13/2016 11:41:45 AM | 7/13/2016 11:45:33 AM | 7/13/2016 11:46:10 AM
7/13/2016 11:32:25 AM | 7/13/2016 11:35:54 AM | 7/13/2016 11:36:21 AM
Spreadsheet: 66458d1267104477-vlookup-in-date-range-vlookup-in-date-range
Sheet: Issue

Date | Colour | Value
2007-10-28 00:00:00 | Green | 12
2008-05-28 00:00:00 | Yellow | 20
2008-07-28 00:00:00 | Green | 4 | 12
2008-10-01 00:00:00 | Green | 56 | 4
2010-01-23 00:00:00 | Black | 30
2010-02-23 00:00:00 | Yellow | 6
Spreadsheet: 889490d1740328928-charts-drop-to-zero-cedward-dynamic-charting-with-zeros
Sheet: Quarterly Exp. 

Quarter | 1 | 2 | 3 | 4 | 1 | 2 | 3 | 4 | 1 | 2 | 3 | 4 | 1 | 2 | 3 | 4 | 1 | 2 | 3 | 4 |  | Date
Year | 2025 | 2025 | 2025 | 2025 | 2026 | 2026 | 2026 | 2026 | 2027 | 2027 | 2027 | 2027 | 2028 | 2028 | 2028 | 2028 | 2029 | 2029 | 2029 | 2029 |  | Quarter | 1
Total
Spreadsheet: 142050d1329602464-matching-data-from-worksheet-to-worksheet-example
Sheet: Sheet2

2011-02-25 00:00:00 | [NAME]
2011-03-06 00:00:00 | [NAME])
2011-03-11 00:00:00 | RUGELL(ARG)
2011-03-16 00:00:00 | BIG ZEB(IRE)
2011-03-20 00:00:00 | FREE ART(GB)
2011-03-31 00:00:00 | MY LOVE FAJER(IRE)
2011-04-03 00:00:00 | SHE'S A CHARACTER(GB)
2011-04-14 00:00:00 | DUPLICITY(GB)
2011-04-18 00:00:00 | VICTORY PARADE(IRE)
2011-04-20 00:00:00 | DESERT VISION(GB)
2011-04-25 00:00:00 | [NAME])
2011-04-28 00:00:00 | EVIDENT PRIDE(USA)
2011-04-30 00:00:00 | DESERT VISION(GB)
2011-05-06 00:00:00 | IMPERATOR AUGUSTUS(IRE)
2011-05-10 00:00:00 | HANDSOME FALCON(GB)
2011-05-15 00:00:00 | [NAME])
2011-05-15 00:00:00 | BIG ZEB(GB)
2011-05-25 00:00:00 | KING IN WAITING(IRE)
2011-05-26 00:00:00 | [NAME])
2011-05-26 00:00:00 | LATTE(GB)
Spreadsheet: 694044d1599314552-condensing-down-like-items-in-a-material-list-2020-09-05-oeldere-fenster-694033d1599311575-condensing-down-like-items-in-a-material-list-ex
Sheet: example

 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 0
 | These rows are over multiple sheets |  |  |  |  |  |  |  |  | this is combined on one sheet but would like all like items to be condensed before the final list on a separate sheet |  |  |  |  |  |  |  | FINAL LIST pulls all rows with [NAME] (but I want it with the like items combined shown in the section below starting on row 30)
 |  |  |  | data validation list | data validation list | data validation list |  |  |  | Intermediate list |  |  |  |  |  |  |  | IFERROR(INDEX(K$6:K$16,SMALL(IF($L$6:$L$16>$T$2,ROW($K$6:$K$16)-ROW($K$6)+1),ROWS($K$6:$K7))),"")
 |  |  |  |  |  |  |  |  |  | Item | Qty | Size | Color | Material Type |  |  |  | Item | Qty | Size | Color | Material Type
 |  | Top Bolt | 51 | 1-3/4" | black | Stainless Steel
 |  | [NAME] | 61 | 1" | black | Alloy Steel
 |  | Middle Bolt | 4 | 1-1/2" | red | Stainless Steel
 |  | Right Bolt | 12 | 2" | red | Zinc Plated
 |  | Left Bolt | 0 | 1" | green | Alloy Steel
 |  | Outside Bolt | 18 | 1-3/4" | black | Stainless Steel
 |  | Inside Bolt1 | 1 | 1" | green | Stainless Steel
 |  | Inside Bolt2 | 4 | 1" | red | Stainless Steel
 |  | Inside Bolt3 | 31 | 1" | green | Stainless Steel
 |  | Inside Bolt4 | 4 | 1" | green | Stainless Steel
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | Item | Qty | Size | Color | Material Type
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | Top Bolt | 51 | 1-3/4" | black | Stainless Steel | combined with other black
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | [NAME] | 61 | 1" | black | Alloy Steel
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | Middle Bolt | 4 | 1-1/2" | red | Stainless Steel | combined with other red
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | Right Bolt | 12 | 2" | red | Zinc Plated
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | Outside Bolt | 18 | 1-3/4" | black | Stainless Steel
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | Inside Bolt1 | 1 | 1" | green | Stainless Steel | combined with other green
 |  | Undermount Bolt1 | 16 | 1-1/2" | red | Stainless Steel |  |  |  |  |  |  |  |  |  |  |  | Inside Bolt2 | 4 | 1" | red | Stainless Steel
 |  | Undermount Bolt2 | 8 | 1" | silver | Stainless Steel |  |  |  |  |  |  |  |  |  |  |  | Inside Bolt3 | 31 | 1" | green | Stainless Steel
 |  | Undermount Bolt3 | 4 | 1" | silver | Stainless Steel |  |  |  |  |  |  |  |  |  |  |  | Inside Bolt4 | 4 | 1" | green | Stainless Steel
 |  | Undermount Bolt4 | 16 | 1" | silver | Stainless Steel |  |  |  |  |  |  |  |  |  |  |  | Undermount Bolt1 | 16 | 1-1/2" | red | Stainless Steel
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | Undermount Bolt2 | 8 | 1" | silver | Stainless Steel | combine with other blue
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | Undermount Bolt3 | 4 | 1" | silver | Stainless Steel
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | Undermount Bolt4 | 16 | 1" | silver | Stainless Steel
Spreadsheet: ryan_slinger__33674__5_14act
Sheet: Economics

 | Commodity Revenue (Cost) | Demand Charge | Total | Total Volume | $/Mwhr Commodity Cost | $/Mwhr Total Cost
Purchases
[NAME]. Cost Est. |  |  |  |  | 20 | 0
Incremental Purchases
[NAME]
4C Balancing
4C Realtime
[NAME]
PV Balancing
PV Realtime
SPS Pre
Artesia Balancing
Artesia Realtime
Sales
Incremental Sales
[NAME]
4C Balancing
4C Realtime
[NAME]
PV Balancing
PV Realtime
[NAME]
Artesia Balancing
Artesia Realtime
 |  |  |  |  |  |  | Heat | Fuel
Generation |  |  |  |  |  |  | Rate | Cost
4 Corners Unit 4 |  |  |  |  |  |  | 10.0576 | 1.3
4 Corners Unit 5 |  |  |  |  |  |  | 10.0576 | 1.3
PV Unit 1 |  |  |  |  |  |  | 10.16 | 0.6
PV Unit 2 |  |  |  |  |  |  | 10.16 | 0.6
PV Unit 3 |  |  |  |  |  |  | 10.16 | 0.6
Newman 1
Newman 2
Newman 3
GT 1
GT 2
GT1+ST1
GT2+ST1
Newman 4 |  |  |  |  |  |  |  | 1.96
Copper
Rio Grande 6
Rio Grande 7
Rio Grande 8
Total
Spreadsheet: 727170d1617739310-removing-duplicates-from-dropdown-list-book002
Sheet: RoutingTable

Wire # | From Conn | From [NAME] | FROM MFG. TERMINAL
USB PWR | USB INPUT | 1 | USB-A FEMALE
USB GND | USB INPUT | 4 | USB-A FEMALE
USB DATA+ | USB INPUT | 3 | USB-A FEMALE
USB DATA- | USB INPUT | 2 | USB-A FEMALE
CBL 4B | S-C07 | R
CBL 2B | S-C07 | L
CBL 4A | S-C06 | R
CBL 2A | S-C06 | L
821-C | S-821 | L
821-B | S-821 | R
821-A | S-821 | L
219-C | S-219 | R
219-B | S-219 | R
0C-3AC | S-0C-3A | R
194 | GRAYHILL DISPLAY - B | 13 | 0462-201-16141
CBL 3B | GRAYHILL DISPLAY - A | 16 | [PHONE]
CBL 3A | GRAYHILL DISPLAY - A | 15 | [PHONE]
CBL 1B | GRAYHILL DISPLAY - A | 14 | [PHONE]
CBL 1A | GRAYHILL DISPLAY - A | 13 | [PHONE]
0C-3AB | GRAYHILL DISPLAY - A | 2 | 0462-201-16141
35-B | DISPLAY_JUMPER_B | 20 | 0460-202-16141
219-A | DISPLAY_JUMPER_B | 1 | 0460-202-16141
0C-3AA | DISPLAY_JUMPER_B | 2 | 0460-202-16141
234 | DISPLAY_JUMPER_B | 21 | 0460-202-16141
0C-3AD | BUZZER | B | 15304702
636L-B | 0403-C | 2 | 927847-2
628 | 0403-C | 7 | 927847-2
624 | 0403-C | 3 | 927847-2
35 | 0403-C | 6 | 927847-2
DIG | 0403-B | 7 | 927847-2
636L-A | 0403-B | 3 | 927847-2
471 | 0403-B | 6 | 927847-2
252 | 0403-B | 2 | 927847-2
444 | 0403-A | 6 | 927847-2
443 | 0403-A | 3 | 927847-2
442 | 0403-A | 2 | 927847-2
59 | 0403-A | 7 | 927847-2
Spreadsheet: 139411d1328225599-formula-question-re-if-sum-example2012_summer_internship
Sheet: Summary

 | Summer 2012 Internship Daily Recruitment Report |  |  |  |  |  |  |  |  |  | 2012-01-19 00:00:00
Requisition | Job Title | Spots | Days Open | Hiring Manager | [NAME] | Submittals | New | Routed Resumes | Being Considered | Unconsidered | Interview Process | Cleared Interview | Rejected In Interview | [NAME] | Offer Accepted | [NAME] | [NAME] | Hired
LIV1729 | Dallas Marketing | 2 | 10 |  | [NAME] | 5 | 2 | 0 | 3 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0
LIV1730 | Denver Marketing | 6 | 10 |  | [NAME] | 9 | 2 | 0 | 3 | 4 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0
LIV1731 | Global Partnerships | 1 | 10 |  | [NAME] | 21 | 4 | 0 | 5 | 12 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0
LIV1732 | GV Marketing | 4 | 10 |  | [NAME] | 32 | 8 | 0 | 7 | 17 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0
LIV1733 | Interactive Marketing | 2 | 10 |  | [NAME] | 18 | 4 | 0 | 9 | 5 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0
LIV1734 | Latin Marketing | 1 | 10 |  | [NAME] | 4 | 1 | 0 | 1 | 2 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0
LIV1735 | Talent Buying | 2 | 10 |  | [NAME] | 24 | 7 | 0 | 2 | 15 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0
[NAME] | Showbox Marketing | 1 | 10 |  | [NAME] | 2 | 0 | 0 | 1 | 1 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0
LIV1741 | [NAME] | 1 | 10 |  | [NAME] | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0
[NAME] | [NAME] | 1 | 14 |  | [NAME] | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0
LIV1746 | Nashville Marketing | 1 | 10 |  | [NAME] | 6 | 2 | 0 | 1 | 3 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0
[NAME] | Philly Marketing | 1 | 10 |  | [NAME] | 13 | 3 | 0 | 5 | 5 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0
LIV1749 | SF Ticketing | 1 | 10 |  | [NAME] | 15 | 3 | 0 | 8 | 4 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0
[NAME] | SF Marketing | 1 | 10 |  | [NAME] | 1 | 0 | 0 | 1 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0
LIV1751 | SC Marketing | 1 | 10 |  | [NAME] | 5 | 1 | 0 | 2 | 2 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0
LIV1752 | Florida Marketing | 1 | 10 |  | [NAME] | 5 | 1 | 0 | 2 | 2 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0
LIV1754 | Special Events/Admin. | 1 | 10 |  | [NAME] | 4 | 1 | 0 | 1 | 2 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0
LIV1755 | CW Marketing | 1 | 10 |  | [NAME] | 27 | 9 | 0 | 10 | 8 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0
LIV1756 | El Rey Theatre | 1 | 10 |  | [NAME] | 16 | 3 | 0 | 7 | 6 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0
LIV1757 | Network Live | 1 | 10 |  | [NAME] | 12 | 3 | 0 | 0 | 9 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0
LIV1759 | NY Production | 1 | 10 |  | [NAME] | 12 | 5 | 0 | 1 | 6 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0
 | Total | 32 |  |  |  | 231 | 59 | 0 | 69 | 103 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0
 | *Positions in yellow are at risk, positions in red are at high risk for failing
Spreadsheet: 218359d1362434713-combine-multiple-rows-into-one-comma-separated-column-compantexample
Sheet: ori

CustomerID | Name | UserID | IsActive | FirstName | LastName | Full Name
10000001 | Company Name 1 | 99911 | True | [NAME] | Smith | [NAME]
10000002 | Company Name 2 | 99912 | False | [NAME] | Smith | [NAME]
10000003 | Company Name 3 | 99913 | True | Emily | Smith | [NAME]
10000004 | Company Name 4 | 99914 | True | [NAME] | Smith | [NAME]
10000004 | Company Name 4 | 99915 | True | Robyn | Smith | [NAME]
Spreadsheet: 03b94fcc-88c2-45b9-a40b-8a76fbc758bf
Sheet: Sheet2

F O R M   P R 1 A | C o m m o n w e a l t h   o f   P e n n s y l v a n i a
T Y P E   2 | R e d e v e l o p m e n t   A s s i s t a n c e   C a p i t a l   P r o g r a m
2010-05-01 00:00:00 | A P P L I C A T I O N   F O R   P A Y M E N T   -   R E Q U E S T   N O .   _____
GRANTEE NAME |  |  |  |  | Contract No. ME 300 - |  | Contract No. OB-RACP -
SUB-GRANTEE NAME |  |  |  |  | Grant Contract Period |  | to
PROJECT NAME |  |  |  |  | Legislative Authorization Date |  | Payment Request Date
CONSTRUCTION COSTS | D I S T R I B U T I O N   O F   E S T I M A T E D   C O S T S                                                      (Provide Distribution According to Approved RDA Forms) |  |  | UPDATED COST |  | C O S T S   P A I D   T O   D A T E
For Multi-Faceted Project,                                Provide Phases, Components,                     Contract Names,  & Contract Nos. | Costs Distributed to RACP | Costs Distributed to MATCH | TOTAL | ESTIMATE | % Complete | Costs Attributed to RACP | Costs Attributed to LOCAL MATCH | TOTAL COSTS              Paid to Date
For Single Contract,  Provide Work Items | 1A | 1B | 1C | 2 |  | 3A | 3B | 3C
Contract No 1
[NAME]
Contract No 2
[NAME]
TOTAL
S U B M I T T A L   I N F O R M A T I O N |  |  |  | CERTIFICATION BY GRANTEE, SUBGRANTEE / OWNER, & ARCHITECT / ENGINEER
Provide Names & Numbers for Each Phase. |  |  |  | We Certify that this Application for Payment is Correct and Project Construction is Satisfactory.
Provide Contract Names and Numbers for Each Major Component. |  |  |  | APPROVAL OF: |  | AUTHORIZED REPRESENTATIVE (Print & Sign) |  | DATE
Provide a Total Cost for Each Major Phase & Each Major Component. |  |  |  | GRANTEE
Attach Invoices for ALL Construction Contracts and Work Items.
 |  |  |  | SUB-GRANTEE
 |  |  |  | ARCHITECT or ENGINEER
 |  |  |  | ENGINEER or INSPECTOR
 |  |  |  | (If Applicable)
Spreadsheet: 723169d1615549450-count-duplicate-values-in-the-same-cell-and-in-a-range-example-1-2-1-
Sheet: Sheet1

 | INVOICE DATE | SITE | INVOICE AMOUNT | CHARGABLE | PLOT(S)
 | 2021-02-26 00:00:00 | Gipping [NAME] | 20 | YES | 123, 124, 125, 126
 | 2021-03-04 00:00:00 | Gipping [NAME] | 20 | YES | 108, 110
 | 2021-03-05 00:00:00 | Gipping [NAME] | 20 | NO | 108, 987
 | 2021-03-02 00:00:00 | Gipping [NAME] | 20 | NO | 108
 | 2021-02-03 00:00:00 | Gipping [NAME] | 20 | YES | 109
 | 2021-02-01 00:00:00 | Gipping [NAME] | 20 | NO | 123, 124
 | 2021-02-26 00:00:00 | Gipping [NAME] | 20 | YES | 82, 83
 | 2021-02-25 00:00:00 | Colne Meadows | 20 | NO | 2
 | 2021-02-24 00:00:00 | Colne Meadows | 20 | NO | 1
 | 2021-02-20 00:00:00 | Colne Meadows | 20 | NO | 1, 2
 | 2021-02-19 00:00:00 | Colne Meadows | 20 | NO | 3
 | 2021-02-18 00:00:00 | Colne Meadows | 20 | NO | 3, 4
 | 2021-02-17 00:00:00 | Colne Meadows | 20 | NO | 4
 | 2021-02-15 00:00:00 | Colne Meadows | 20 | NO | 4
 | 2021-02-16 00:00:00 | Gipping [NAME] | 20 | YES | 127
Spreadsheet: 105942d1303216776-index-indirect-match-help-projbudg
Sheet: Timeline

Project Name | Priority | [NAME] | Start Row | End Row | End Row | 2011 |  |  |  |  |  |  |  |  | 2012 |  |  |  |  | 2012 |  |  |  |  |  |  |  |  | 2013 |  |  |  |  | 2013 |  |  |  |  |  |  |  |  | 2014 |  |  | Comments/Status
 |  | Status |  |  |  | A | M | J | J | A | S | O | N | D | J | F | M |  |  | A | M | J | J | A | S | O | N | D | J | F | M |  |  | A | M | J | J | A | S | O | N | D | J | F | M
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  | `
Spreadsheet: 857319d1706344800-vlookup-data-to-new-table-vlookup-to-new-table-
Sheet: Sheet1

Date | Document No |  |  | Code |  |  | Document No | Date | [NAME]
2023-12-01 00:00:00 | OR202312001 |  |  | 300-K0010
 | Date |  | [NAME]
 | 2023-11-15 00:00:00 |  | AV202311043
2023-12-01 00:00:00 | OR202312002 |  |  | 300-T0004
 | Date |  | [NAME]
 | 2023-11-21 00:00:00 |  | AV202311066
 | 2023-11-21 00:00:00 |  | AV202311067
2023-12-01 00:00:00 | OR202312003 |  |  | 300-C0110
 | Date |  | [NAME]
 | 2023-09-19 00:00:00 |  | AV202309072
 | 2023-11-22 00:00:00 |  | AV202311071
2023-12-04 00:00:00 | OR202312004 |  |  | 300-M0030
 | Date |  | [NAME]
 | 2023-11-22 00:00:00 |  | AV202311070
2023-12-02 00:00:00 | OR202312005 |  |  | 300-P0025
 | Date |  | [NAME]
 | 2023-11-28 00:00:00 |  | AV202311094