tianzl66/Sheetpedia huggingface dataset:
Spreadsheet: 328048d1403777001-control-sheet-formula-needed-mtd-revenue-1-31-may-2014
Sheet: Smaato rev by publisher

Generated on | 2014-06-05 13:34
Publisher | Coull
Adspace(s) | All Adspaces
Displayed date range | 2014-05-01 to 2014-05-31 UTC
Adspace | Ad Requests | [NAME] | Fillrate | Impressions | Clicks | CTR | eCPC | eCPM | Revenue
Future - TechRadar.com | 3856336 | 1234385 | 32.01 | 235760 | 8 | 0 | 3.446 | 0.117 | 27.57
Curse - Minecraft Gamepedia | 2272445 | 387062 | 17.03 | 193507 | 3 | 0 | 12.515 | 0.194 | 37.54
Future - T3.com | 22915 | 5002 | 21.83 | 4421 | 0 | 0 | 0 | 0.125 | 0.55
AnyClip | 7 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0
Curse - LoL Pro | 73887 | 17621 | 23.85 | 17220 | 0 | 0 | 0 | 0.13 | 2.23
Curse - Reign of Gaming | 242235 | 64176 | 26.49 | 59734 | 3 | 0.01 | 3.293 | 0.165 | 9.88
Curse - Marriland | 235654 | 48715 | 20.67 | 44830 | 1 | 0 | 6.904 | 0.154 | 6.9
Curse - MMO-Champion | 1902105 | 178234 | 9.37 | 166981 | 4 | 0 | 5.293 | 0.127 | 21.17
[NAME] All | 323 | 56 | 17.34 | 10 | 0 | 0 | 0 | 0.311 | 0
Curse - Minecraft Forums | 5544074 | 1721548 | 31.05 | 478212 | 16 | 0 | 3.094 | 0.104 | 49.51
Future - CVG | 22383 | 9346 | 41.75 | 8953 | 0 | 0 | 0 | 0.159 | 1.42
Future - Bikeradar | 43817 | 10453 | 23.86 | 7507 | 0 | 0 | 0 | 0.216 | 1.62
MMORPG | 21499 | 4673 | 21.74 | 4407 | 0 | 0 | 0 | 0.111 | 0.49
Cheezburger | 112167 | 20351 | 18.14 | 19180 | 0 | 0 | 0 | 0.267 | 5.12
Spreadsheet: 723728d1615856466-gross-profit-forecast-for-the-year-2021-book1
Sheet: Sheet1

 |  | Base Rate | 145 | 14 | Days working
 |  | Start Date: | 2021-01-01 00:00:00 | 7 | Days non-working
 |  | Month | # of working days | Gross Profit
 |  | 2021-01-01 00:00:00
 |  | 2021-02-01 00:00:00
 |  | 2021-03-01 00:00:00
 |  | 2021-04-01 00:00:00
 |  | 2021-05-01 00:00:00
 |  | 2021-06-01 00:00:00
 |  | 2021-07-01 00:00:00
 |  | 2021-08-01 00:00:00
 |  | 2021-09-01 00:00:00
 |  | 2021-10-01 00:00:00
 |  | 2021-11-01 00:00:00
 |  | 2021-12-01 00:00:00
Spreadsheet: 79671d1279884657-combining-cells-udf-concatenate-range-concrange-
Sheet: Sheet1

 |  |  |  |  |  |  | No separator
Can | you | put | this | into | one | cell? | Canyouputthisintoonecell?
Can
you
put
this
into
one |  |  |  |  |  |  | " " separator (space)
cell? |  |  |  |  |  | - Yes! | Can you put this into one cell? - Yes!
Can
 | you
 |  | put
 |  |  | this
 |  |  |  | into
 |  |  |  |  | one
cell? |  |  |  |  |  | - Yes! | Can you put this into one cell? - Yes!
How to use
If you don't need separators use like this
otherwise
The separator can be any string you might need.
The range can be any size or shape, the function will concatenate by Columns left to right, then by Rows, omitting any blank cells
Spreadsheet: 38f80caf-ba07-47bd-be1d-7e97af454550
Sheet: Sheet1

State Treasurer - REP (North Dakota) | Unnamed: 1 | Unnamed: 2
Downloaded at 4/24/2014 8:30:50 PM
Precincts Reporting: 528/528 - Total Ballots Cast: 102886
2008 Primary Election - OFFICIAL RESULTS
County | [NAME] | TOTALS
Adams | 317 | 317
Barnes | 838 | 838
Benson | 213 | 213
Billings | 108 | 108
Bottineau | 418 | 418
[NAME] | 285 | 285
Burke | 183 | 183
Burleigh | 4643 | 4643
[NAME] | 10728 | 10728
Cavalier | 470 | 470
Dickey | 483 | 483
Divide | 118 | 118
Dunn | 388 | 388
Eddy | 95 | 95
Emmons | 425 | 425
[NAME] | 126 | 126
Golden Valley | 212 | 212
Grand Forks | 4210 | 4210
Grant | 447 | 447
Griggs | 393 | 393
Hettinger | 395 | 395
Kidder | 235 | 235
[NAME] | 431 | 431
Logan | 265 | 265
McHenry | 450 | 450
McIntosh | 489 | 489
McKenzie | 484 | 484
McLean | 600 | 600
Mercer | 755 | 755
[NAME] | 1716 | 1716
[NAME] | 295 | 295
[NAME] | 350 | 350
[NAME] | 192 | 192
Pembina | 740 | 740
Pierce | 174 | 174
Ramsey | 676 | 676
[NAME] | 286 | 286
[NAME] | 157 | 157
Richland | 546 | 546
Rolette | 218 | 218
Sargent | 312 | 312
[NAME] | 285 | 285
Sioux | 70 | 70
Slope | 79 | 79
[NAME] | 2175 | 2175
Steele | 161 | 161
[NAME] | 1689 | 1689
Towner | 205 | 205
Traill | 478 | 478
Walsh | 655 | 655
Ward | 4263 | 4263
Wells | 564 | 564
[NAME] | 921 | 921
TOTAL | 46411 | 46411
Results provided by the Office of North Dakota Secretary of State
Spreadsheet: 04abcc80-e1de-4fd4-b4fb-7aee8fded08d
Sheet: Sheet1

Table 5--Corn: Food, seed, and industrial use (million bushels), 5/14/2013 | Unnamed: 1 | Unnamed: 2 | Unnamed: 3 | Unnamed: 4 | Unnamed: 5 | Unnamed: 6 | Unnamed: 7 | Unnamed: 8 | Unnamed: 9
Mkt year and qtr 1/ |  | High-fructose corn syrup (HFCS) | Glucose and dextrose | Starch | Alcohol for fuel | Alcohol for beverages and manufacturing | Cereals and other products | Seed | Total food, seed, and industrial use
2011/12 | Q1 Sep-Nov | 119.636 | 77.965 | 64.652 | 1266.691 | 33.302 | 50.732 | 0 | 1612.978
 | [NAME] | 115.001 | 73.338 | 62.025 | 1304.805 | 34.93 | 50.732 | 0 | 1640.831
 | [NAME] | 136.829 | 72.977 | 62.138 | 1247.777 | 36.586 | 50.531 | 23.565 | 1630.403
 | [NAME] | 141.894 | 72.327 | 65.153 | 1191.752 | 31.682 | 51.234 | 0.963 | 1555.005
 | MY Sep-Aug | 513.36 | 296.608 | 253.968 | 5011.025 | 136.5 | 203.229 | 24.528 | 6439.218
2012/13 | Q1 Sep-Nov | 122.758 | 70.366 | 63.793 | 1141.52 | 32.936 | 49.902 | 0 | 1481.275
 | [NAME] | 113.435 | 65.349 | 58.682 | 1118.174 | 34.546 | 49.792 | 0 | 1439.978
 | MY Sep-Aug | 495 | 280 | 250 | 4600 | 135 | 200.385 | 24.615 | 5985
2013/14 | MY Sep-Aug | 500 | 300 | 280 | 4850 | 135 | 205 | 24 | 6294
1/ September-August.  Latest data may be preliminary or projected. Source: Calculated by USDA, Economic Research Service.
Date run: 5/13/2013
Spreadsheet: 202a51bb-a596-4062-8393-b1478a81e92d
Sheet: Sheet1

Table 1--Wheat: U.S. market year supply and disappearance, 4/12/2012 | Unnamed: 1 | Unnamed: 2 | Unnamed: 3 | Unnamed: 4 | Unnamed: 5 | Unnamed: 6 | Unnamed: 7 | Unnamed: 8 | Unnamed: 9
Item and unit |  |  | 2005/06 | 2006/07 | 2007/08 | 2008/09 | 2009/10 | 2010/11 | 2011/12
 | Area: Planted | Million acres | 57.2 | 57.3 | 60.5 | 63.2 | 59.2 | 53.6 | 54.4
 | Harvested | Million acres | 50.1 | 46.8 | 51.0 | 55.7 | 49.9 | 47.6 | 45.7
 | Yield | Bushels per acre | 42.0 | 38.6 | 40.2 | 44.9 | 44.5 | 46.3 | 43.7
 | Supply: Beginning stocks | Million bushels | 540.1 | 571.2 | 456.2 | 305.8 | 656.5 | 975.6 | 862.2
 | Production | Million bushels | 2,103.3 | 1,808.4 | 2,051.1 | 2,499.2 | 2,218.1 | 2,206.9 | 1,999.3
 | Imports 1/ | Million bushels | 81.4 | 121.9 | 112.6 | 127.0 | 118.6 | 96.9 | 120.0
 | Total supply | Million bushels | 2,724.8 | 2,501.5 | 2,619.9 | 2,932.0 | 2,993.2 | 3,279.5 | 2,981.6
 | Disappearance: Food use | Million bushels | 917.1 | 937.9 | 947.9 | 926.8 | 918.9 | 925.6 | 930.0
 | Seed use | Million bushels | 77.1 | 81.9 | 87.6 | 78.0 | 69.5 | 70.9 | 78.5
 | Feed and residual use | Million bushels | 156.6 | 117.1 | 16.0 | 255.2 | 149.9 | 131.9 | 180.0
 | Total domestic use | Million bushels | 1,150.8 | 1,136.8 | 1,051.4 | 1,260.0 | 1,138.2 | 1,128.4 | 1,188.5
 | Exports 1/ | Million bushels | 1,002.8 | 908.5 | 1,262.6 | 1,015.4 | 879.3 | 1,288.8 | 1,000.0
 | Total disapperance | Million bushels | 2,153.6 | 2,045.3 | 2,314.1 | 2,275.4 | 2,017.5 | 2,417.2 | 2,188.5
 | Ending stocks | Million bushels | 571.2 | 456.2 | 305.8 | 656.5 | 975.6 | 862.2 | 793.1
 | CCC inventory 2/ | Million bushels | 43.0 | 41.0
 | Stocks-to-use ratio |  | 26.5 | 22.3 | 13.2 | 28.9 | 48.4 | 35.7 | 36.2
 | Loan rate | Dollars per bushel | 2.75 | 2.75 | 2.75 | 2.75 | 2.75 | 2.94 | 2.94
 | Contract/direct payment rate | Dollars per bushel | 0.52 | 0.52 | 0.52 | 0.52 | 0.52 | 0.52 | 0.52
 | Farm price 3/ | Dollars per bushel | 3.42 | 4.26 | 6.48 | 6.78 | 4.87 | 5.70 | 7.20-7.40
 | Government payments | Million dollars | 1,151 | 1,120 | 1,118
 | Market value of production | Million dollars | 7,167 | 7,695 | 13,289 | 16,626 | 10,654 | 12,827 | 14,595
Latest market year is projected; previous market year is estimated. Totals may not add due to rounding. 1/ Includes flour and selected other products expressed in grain-equivalent bushels. 2/ Stocks owned by USDA's Commodity Credit Corporation (CCC). Most CCC-owned inventory is in the Bill Emerson Humanitarian Trust.
3/ U.S. season-average price based on monthly prices weighted by monthly marketings. Prices do not include an allowance for loans outstanding and government purchases. Source: USDA, World Agricultural Outlook Board, World Agricultural Supply and Demand Estimates and supporting materials.
Date run: 4/10/2012
Spreadsheet: louise_kitchen__23955__SepYTD Orig w notes sf
Sheet: East Gas

East Gas
By Team
Originator |  | Commodity |  | Team |  | Total |  | %Total
DePaolis |  | Gas |  | East Gas |  | 2301442.2675
[NAME] |  | Gas |  | East Gas |  | 1853476
Kaiser |  | Gas |  | East Gas |  | 1459732
Ferries |  | Gas |  | East Gas |  | 1116400.6
[NAME] |  | Gas |  | East Gas |  | 756363
[NAME] |  | Gas |  | East Gas |  | 733203.25
Barbe |  | Gas |  | East Gas |  | 674346
Concannon |  | Gas |  | East Gas |  | 550919
Smith,[NAME] |  | Gas |  | East Gas |  | 468625
DeMoes |  | Gas |  | East Gas |  | 150517
Singer |  | Gas |  | East Gas |  | 128978
Martinez |  | Gas |  | East Gas |  | 112742
Jones |  | Gas |  | East Gas |  | 101496
Hodge |  | Gas |  | East Gas |  | 100279.16
Goodell |  | Gas |  | East Gas |  | 81241.5
[NAME] |  | Gas |  | East Gas |  | 42707.5
Ortiz |  | Gas |  | East Gas |  | 2250
Hendrickson |  | Gas |  | East Gas |  | 1106.46
Loving |  | Gas |  | East Gas |  | 869
[NAME] |  | Gas |  | East Gas |  | -2974
Miscellaneous |  | Gas |  | East Gas |  | -10927
Total
Spreadsheet: 828940d1683802813-how-to-find-the-value-count-between-two-time-slots-sample-sheet_find-the-time-slot
Sheet: Output sheet

Start Time | 08:00:00
End Time | 08:30:00 | 09:00:00 | 09:30:00 | 10:00:00 | 10:30:00 | 11:00:00 | 11:30:00 | 12:00:00 | 12:30:00 | 13:00:00 | 13:30:00 | 14:00:00 | 14:30:00 | 15:00:00 | 15:30:00 | 16:00:00 | 16:30:00 | 17:00:00 | 17:30:00 | 18:00:00 | 18:30:00 | 19:00:00
2022-05-01 00:00:00
2022-05-02 00:00:00
2022-05-03 00:00:00
2022-05-04 00:00:00
2022-05-05 00:00:00
2022-05-06 00:00:00
2022-05-07 00:00:00
2022-05-08 00:00:00
2022-05-09 00:00:00
2022-05-10 00:00:00
2022-05-11 00:00:00
2022-05-12 00:00:00
Spreadsheet: 153234d1335814914-need-help-consolidating-data-across-multiple-sheets-warehouse-store-order-list-4-30-12
Sheet: Butters & Jellies

Ordered | Item | Description | Retail | Heat Level | Category
 | P2100 | [NAME], 16oz | 8.95 | 1 | Butters/Jellies
 | P3145 | [NAME], 10 oz. | 7.95 | 3 | Butters/Jellies
 | P3155 | [NAME], 10 oz. | 7.95 | 1 | Butters/Jellies
 | P2105 | [NAME], 16 oz. | 8.95 | 1 | Butters/Jellies
 | P3165 | [NAME], 10 oz. | 7.95 | 1 | Butters/Jellies
 | P3100 | Green Mild Pepper Jelly, 10 oz. | 7.95 | 2 | Butters/Jellies
 | P3130 | Habanero Peppery Peach Preserve, 10 oz | 7.95 | 6 | Butters/Jellies
 | P3170 | Habanero Pineapple Preserves, 10 oz. | 7.95 | 4 | Butters/Jellies
 | P3125 | Habanero [NAME], 10 oz. | 7.95 | 6 | Butters/Jellies
 | P3120 | Holiday Pepper Jelly, 10 oz. (Bell Pepper Jelly) | 7.95 | 1 | Butters/Jellies
 | P3175 | [NAME], 10 oz. | 7.95 | 3 | Butters/Jellies
 | P3115 | [NAME], 10 oz. | 7.95 | 3 | Butters/Jellies
 | P3110 | [NAME], 10 oz. | 7.95 | 3 | Butters/Jellies
 | P295 | [NAME], 16 oz. | 8.95 | 1 | Butters/Jellies
 | P3150 | Peach Preserves, 10 oz. | 7.95 | 1 | Butters/Jellies
 | P2120 | Pumpkin Butter 16 oz. | 8.95 | 1 | Butters/Jellies
 | P3105 | Red Hot Pepper Jelly, 10 oz. | 7.95 | 5 | Butters/Jellies
 | P3140 | Red [NAME], 10 oz. | 7.95 | 3 | Butters/Jellies
 | P3135 | Seven Pepper Jelly, 10 oz. | 7.95 | 3 | Butters/Jellies
 | P3160 | [NAME], 10 oz. | 7.95 | 1 | Butters/Jellies
 | P2115 | Sweet Potato Butter, 16 oz. | 8.95 | 1 | Butters/Jellies
 | P2125 | Sweet Potato Pecan Butter, 16 oz. | 8.95 | 1 | Butters/Jellies
Spreadsheet: 717510d1612709406-index-match-problem-i-cant-seem-to-fix-job-tracking-experimental
Sheet: Project 

Created Date | Project Location |  |  | Project Title / Description |  | PO # / Date |  | Terms | [NAME] Project Manager |  |  | Customer Project Manager
2021-02-04 00:00:00 | Crown Castle Towson |  |  | Phone Room Split Systems |  | 2020-12-30 00:00:00 |  |  | Name |  |  | Name
 |  |  |  |  |  |  |  |  | [NAME] |  |  | [NAME]
 |  |  |  | BMS Job # |  | PO# |  |  | Phone |  |  | Phone
Forecast Project Costs & Profit |  |  |  | Days in Our Court |  | Proj. Completion Date |  | BOD ? |  | Proj. Duration | Reason
Sold Price |  |  | 1000 | Actual Project Costs & Profit |  | 2021-02-28 00:00:00 |  |  |  |  | Weather
Profit |  |  |  | Actual Profit
Percentage |  |  |  | Actual Percentage
Projected Total Project Cost |  |  |  | Actual Total Cost
Projected Equipment Cost |  |  |  | Actual Equipment Cost
Projected Sub Contractor Cost |  |  |  | Actual Sub Contractor Cost
Equipment Vendors |  |  |  | Equipment Description |  |  |  |  |  | Original Quote | Additional Costs | Submittal
Sub Contractors |  |  |  | Sub Contractor Scope
 |  |  |  |  |  |  |  |  |  | Original Quote | Additional Cost | Change Orders
Engineering / Coring / Testing and BOD |  |  |  |  |  | BOD REQUIRED
Mechanical
Electrical
Sheet Metal & Duct
Controls
Rigging
Pipe Fitting
Plumbing
Balancing
Insulation
Fire & Sprinkler
Cleaning & Misc
Spreadsheet: kate_symes__18475__MeadMktplace (2)
Sheet: MeadMktplace

 |  |  | Firm | Volume | Firm | Volume | Non Firm | Volume | Non Firm | Volume
 | DATE |  | On [NAME] | [NAME] | [NAME] | [NAME] | On [NAME] | [NAME] | [NAME] | [NAME]
 | 2001-01-19 00:00:00 |  | 454 | 800 | 275.37 | 1080
 | 2001-01-18 00:00:00 |  | 429.73 | 592 | 228.64 | 1704 | 275.21 | 3577 | 187.25 | 1153
 | 2001-01-17 00:00:00 |  | 235 | 160 | 150.91 | 880 | 284 | 1630 | 156.87 | 546
 | 2001-01-16 00:00:00 |  | 174.75 | 640 | 114.61 | 1264 | 198.32 | 1393 | 118.67 | 961
 | 2001-01-15 00:00:00 |  | 174.29 | 560 | 114.61 | 1264 | 163.34 | 2155 | 121.91 | 913
 | 2001-01-14 00:00:00 |  | 135 | 160 | 102.1 | 496 | 151.06 | 2920 | 119.25 | 1375
 | 2001-01-13 00:00:00 |  | 170 | 160 | 116.65 | 1696 | 149.38 | 3307 | 112.78 | 1208
 | 2001-01-12 00:00:00 |  | 167.65 | 544 | 116 | 2136 | 146.77 | 361 | 110.31 | 1207
 | 2001-01-11 00:00:00 |  | 159.09 | 704 | 116 | 2136 | 147.18 | 1708 | 100.51 | 774
 | 2001-01-10 00:00:00 |  | 150 | 960 | 94.32 | 2280 | 140.57 | 584 | 101.31 | 555
 | 2001-01-09 00:00:00 |  | 127.81 | 1024 | 77.19 | 912 | 156.86 | 390 | 88.91 | 1464
 | 2001-01-08 00:00:00 |  | 132.55 | 1024 | 76.1 | 912 | 127.42 | 1330 | 71.95 | 583
 | 2001-01-07 00:00:00 |  | 115 | 0 | 62.5 | 0 | 63.78 | 2249 | 57.2 | 1278
 | 2001-01-06 00:00:00 |  | 124.17 | 384 | 93.8 | 432 | 102.76 | 521 | 66.24 | 647
 | 2001-01-05 00:00:00 |  | 136.45 | 1216 | 93.11 | 528 | 129.45 | 1527 | 123.46 | 455
 | 2001-01-04 00:00:00 |  | 146.87 | 2016 | 88.03 | 912 | 125.05 | 1851 | 107.45 | 778
 | 2001-01-03 00:00:00 |  | 145.65 | 544 | 75.2 | 32 | 125.71 | 1965 | 99.79 | 652
 | 2001-01-02 00:00:00 |  | 151.43 | 224 | 80 | 32 | 120.29 | 1597 | 76.99 | 944
 | 2001-01-01 00:00:00 |  |  |  |  |  | 102.04 | 432 | 64.43 | 628
 | 2000-12-31 00:00:00 |  |  |  |  |  | 73.65 | 2126 | 66.14 | 1101
 | 2000-12-30 00:00:00 |  | 118.57 | 224 | 75 | 32 | 103.71 | 1824 | 100.69 | 360
 | 2000-12-29 00:00:00 |  | 140 | 64 | 103.1 | 232 | 139.65 | 2163 | 106.37 | 925
 | 2000-12-28 00:00:00 |  | 140 | 64 | 103.1 | 232 | 130.72 | 830 | 120.35 | 1115
 | 2000-12-27 00:00:00 |  | 200 | 64 | 160 | 200 | 121.92 | 1931 | 94.63 | 1065
 | 2000-12-26 00:00:00 |  | 275 | 64 | 203.1 | 232 | 124.96 | 2250 | 71.81 | 666
 | 2000-12-25 00:00:00 |  | 265 | 0 | 210 | 200 | 99.62 | 1532 | 62.74 | 155
 | 2000-12-24 00:00:00 |  | 265 | 0 | 210 | 200 | 131.21 | 1155 | 50.53 | 582
 | 2000-12-23 00:00:00 |  | 291.55 | 464 | 217.19 | 512 | 285 | 0 | 215 | 0
 | 2000-12-22 00:00:00 |  | 291.55 | 464 | 217.19 | 512 | 299 | 25 | 215 | 0
 | 2000-12-21 00:00:00 |  | 291.55 | 464 | 216.99 | 512 | 189.32 | 2060 | 171.06 | 292
 | 2000-12-20 00:00:00 |  | 275 | 0 | 212.86 | 280 | 214.57 | 1110 | 161.24 | 218
Spreadsheet: 272616d1382446695-result-according-2-conditions-sample
Sheet: Sheet1

1 | 2 | 3 | 4 | 5 | 6 | 7 | 8 | Start Date | Finish Date | 11
Sample | Sample | Sample | Sample | Y | Sample | Sample | Sample | 2013-10-22 00:00:00 | 2013-10-30 00:00:00
Sample | Sample | Sample | Sample | Y | Sample | Sample | Sample | 2013-10-22 00:00:00 | 2013-10-25 00:00:00
Sample | Sample | Sample | Sample | Y | Sample | Sample | Sample | 2013-10-19 00:00:00 | 2013-10-22 00:00:00
Sample | Sample | Sample | Sample | N | Sample | Sample | Sample | 2013-10-22 00:00:00 | 2013-12-01 00:00:00
Sample | Sample | Sample | Sample | N | Sample | Sample | Sample | 2013-10-21 00:00:00 | 2013-11-05 00:00:00
Spreadsheet: 88872d1288702248-sumproduct-update-formula-needed-1
Sheet: Sheet1

 |  |  | STATEMENT
Statement to:-
 |  |  | Statement Date: | 02 Novemeber 2010
Our Ref | Invoice Date | Invoice No | Outstanding | Outstanding inc VAT
1 | 2010-09-10 00:00:00 | 1 | 100 | 117.5
2 | 2010-08-10 00:00:00 | 2 | 900 | 1000
 |  |  | Total Outstanding | 1117.5
90+ Days | 61-90 Days | 31-60 Days | 1-30 Days | Total Due
0 | 0 | 0 | 0 | 0
Spreadsheet: 139140d1328100542-how-to-add-dates-and-day-names-automatically-from-sheets-name-book2
Sheet: Apr 2012

[NAME]
2012-04-01 00:00:00
Sun | Mon | Tue | Wed | Thu | Fri | Sat | Sun | Mon | Tue | Wed | Thu | Fri | Sat | Sun | Mon | Tue | Wed | Thu | Fri | Sat | Sun | Mon | Tue | Wed | Thu | Fri | Sat | Sun | Mon | Tue
2012-04-01 00:00:00 | 2012-04-02 00:00:00 | 2012-04-03 00:00:00 | 2012-04-04 00:00:00 | 2012-04-05 00:00:00 | 2012-04-06 00:00:00 | 2012-04-07 00:00:00 | 2012-04-08 00:00:00 | 2012-04-09 00:00:00 | 2012-04-10 00:00:00 | 2012-04-11 00:00:00 | 2012-04-12 00:00:00 | 2012-04-13 00:00:00 | 2012-04-14 00:00:00 | 2012-04-15 00:00:00 | 2012-04-16 00:00:00 | 2012-04-17 00:00:00 | 2012-04-18 00:00:00 | 2012-04-19 00:00:00 | 2012-04-20 00:00:00 | 2012-04-21 00:00:00 | 2012-04-22 00:00:00 | 2012-04-23 00:00:00 | 2012-04-24 00:00:00 | 2012-04-25 00:00:00 | 2012-04-26 00:00:00 | 2012-04-27 00:00:00 | 2012-04-28 00:00:00 | 2012-04-29 00:00:00 | 2012-04-30 00:00:00 |  | 31
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 | 833
833 | 833 | 833 | 833 | 833 | 833 | 833 | 833 | 833 | 833 | 833 | 833 | 833 | 833 | 833 | 833 | 833 | 833 | 833 | 833 | 833 | 833 | 833 | 833 | 833 | 833 | 833 | 833 | 833 | 833 | 833 | 24990
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 1
Balance From Prv Month |  |  |  |  |  | =
Advance |  |  |  |  |  |  |  |  |  |  |  |  |  | Total [NAME] |  |  |  |  |  |  |  |  |  | 25000
Date |  |  | Amount |  |  | Reason |  |  |  |  |  |  |  | Per Day Salary |  |  |  |  |  |  |  |  |  | 833 |  |  |  |  |  |  | 24157 | 6000
2011-11-21 00:00:00 |  |  | 1451 |  |  | orders |  |  |  |  |  |  |  | Date Joined |  |  |  |  |  |  |  |  |  | From Start
2011-12-11 00:00:00 |  |  | 3000
2011-12-14 00:00:00 |  |  | 2000 |  |  |  |  |  |  |  |  |  |  | Allowed Off Days |  |  |  |  |  |  |  |  |  | 0 |  |  |  |  |  |  |  | 1
 |  |  |  |  |  |  |  |  |  |  |  |  |  | Total Working Days |  |  |  |  |  |  |  |  |  | 30
 |  |  |  |  |  |  |  |  |  |  |  |  |  | 1 Off Days |  |  |  |  |  |  |  |  |  | 833 |  |  |  |  |  |  | 1
 |  |  |  |  |  |  |  |  |  |  |  |  |  | Allowed Off Days Amount |  |  |  |  |  |  |  |  |  | 0
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 31 | working days
 |  |  |  |  |  |  |  |  |  |  |  |  |  | Previous Balance |  |  |  |  |  |  |  |  |  | 0 |  |  |  |  |  |  | 30
 |  |  |  |  |  |  |  |  |  |  |  |  |  | Total Salary Due After deducting off days |  |  |  |  |  |  |  |  |  | 24167
 |  |  |  |  |  |  |  |  |  |  |  |  |  | Total Advance Taken |  |  |  |  |  |  |  |  |  | 6451
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 4 | allowed days
 |  |  |  |  |  |  |  |  |  |  |  |  |  | Final Due Salary |  |  |  |  |  |  |  |  |  | 17716
Total |  |  | 6451
Spreadsheet: 838050d1690646085-help-formula-with-dropdown-list-combobox-dummy-data-glenn
Sheet: Dataset

 |  |  |  |  |  |  |  |  |  |  | 2 | 3
 |  |  | North | South | East | West-1 | West-2 | E-Com | India |  | Region | Branch |  |  | COI
 |  |  | CHA | BAN | BHU | MUM | AHM | Flipkart |  |  |  |  |  |  | CHE
 |  |  | DEL | COI | GUW | NAG | IND | Appario |  |  | South |  |  |  | COC
 |  |  | GUR | CHE | KOL | PUN | RAI |  |  |  | East |  |  |  | HYD
 |  |  | JAI | COC | PAT |  |  |  |  |  | West-1 |  |  |  | VIJ
 |  |  | GHA | HYD | RAN |  |  |  |  |  | West-2
 |  |  | LUC | VIJ |  |  |  |  |  |  | E-Com
Spreadsheet: d3660d4c-f8d4-4ce7-b139-5cdc64d236f2
Sheet: Table S3

Table S3: Candidate ULMs, Btz and PRP4 regions in spliceosomal proteins.
MoRF | Protein | Region | Sequence | Protein group | [NAME]
ULM | SF3b155 | 159-201 | ...[NAME]... | U2, SF3B | Abundant
 | SF3b155 | 289-295 | ...[NAME]... | U2, SF3B | Abundant
 | SF3b155 | 333-340 | ...[NAME]... | U2, SF3B | Abundant
 | SF3b125 | 930-937 | ...KRKKSRWD… | U2 snRNP-related | Non-abundant
 | U2AF65 | 84-93 | ...[NAME]... | U2 snRNP-related | Abundant
 | HCNGP | 252-258 | ...[NAME]... | A-complex | Non-abundant
 | SF1 | 15-25 | ...KKRKRSRWNQD... | A-complex | Non-abundant
 | SF4 | 380-392 | ...[NAME]... | A-complex | Non-abundant
 | p68 | 43-50 | ...KKKWNLDE... | A-complex | Non-abundant
 | p72 | 39-44 | ...RKKKWD... | A-complex | Non-abundant
 | [NAME] | 500-505 (*) | ...RKRNWE... | A-complex | Abundant
 | hSnu23 | 13-20 | ...RRKWDKDE... | B-complex | Abundant
 | CCAP2 | 185-191 | ...[NAME]... | hPrp19 / CDC5L | Abundant
 | hPrp22 | 288-292 (*) | ...RKRWE... | step 2 factors | Abundant
 | RBQ-1 | 832-839 | ...[NAME]... | miscellaneous | Non-abundant
Btz | MLN51 | 169-230 | ...[NAME]… | EJC | Non-abundant
 | TRAP150 | 861-955 | ...QKRNREEEWDPEYTPKSKKYYLHDDREGEGSDKWVSRGRGRGAFPRGRGRFMFRKSSTSPKWAHDKFSGEEGEIEDDESGTENREEKDNIQPTTE… | A-complex | Abundant
 | BCLAF1 | 827-899 | ...[NAME]… | [NAME] binding | Non-abundant
PRP4 | U4/U6-60K | 107-137 | ...EVKACLRALGEPITLFGEGPAERRERLRNIL... | U4/U6 di-snRNP | Abundant
 | Prp18 | 77-115 (**) | ...MTLSRQEVIRRLRERGEPIRLFGETDYDAFQRLRKIEIL... | step 2 factors | Abundant
 | SF3a66 | 21-40 (***) | ...ESNRDRRERLRQLALETIDI... | U2, SF3A | Abundant
Footnotes:
Entries in bold represent MoRFs confirmed by an experimentally determined structure.
(*) Found in ordered region.
(**) Ordered.
(***) The PRP4 motif is predicted, but only one helix of the full α-β-α motif is present.
 | ARS2 | 78-86 | ...[NAME]... | [NAME]
Spreadsheet: 695382d1600183132-if-and-or-criteria-for-headcount-report-sample-turnover-file
Sheet: Employee Census

Position ID | Hire Date | Termination Date | 1/1/2020 | 2/1/2020 | 3/1/2020 | 4/1/2020 | 5/1/2020 | 6/1/2020 | 7/1/2020 | 8/1/2020 | 9/1/2020 | 10/1/2020 | 11/1/2020 | 12/1/2020
1 | 2018-10-22 00:00:00 | 2020-01-02 00:00:00
2 | 2015-03-30 00:00:00 | 2020-01-03 00:00:00
3 | 2016-06-16 00:00:00 | 2020-01-03 00:00:00
4 | 2017-12-11 00:00:00 | 2020-01-03 00:00:00
5 | 2013-12-16 00:00:00 | 2020-01-06 00:00:00
6 | 2018-12-26 00:00:00 | 2020-01-06 00:00:00
7 | 2019-09-09 00:00:00 | 2020-01-06 00:00:00
8 | 2019-07-22 00:00:00 | 2020-01-09 00:00:00
9 | 2018-08-13 00:00:00
10 | 2018-10-01 00:00:00
11 | 2019-06-10 00:00:00
12 | 2019-12-30 00:00:00
13 | 2019-08-13 00:00:00
 | If the hire date(Column B) is less than [NAME] AND the term date (Column C) is greater than Column D2 OR is Blank that it returns "Active".  If not that it returns "Inactive"
Spreadsheet: 126180d1319557473-find-and-replace-indirect-example
Sheet: 2012

Field 1 | Field 2 | Field 3 | Field 4
Data 11 | 0.97 | 559 | 37290
Data 12 | 0.23 | 363 | 22421
Data 13 | 0.38 | 741 | 40212
Data 14 | 0.61 | 276 | 28109
Data 15 | 0.11 | 891 | 3224
Data 16 | 0.48 | 254 | 16752
Data 17 | 0.64 | 771 | 57651
Data 18 | 0.66 | 365 | 84694
Data 19 | 0.75 | 186 | 99839
Data 20 | 0.6 | 348 | 35272