tianzl66/Sheetpedia huggingface dataset:
Spreadsheet: 217389d1362059674-returning-column-header-value-from-2-way-lookup-lookup
Sheet: Sheet1

[NAME] (Ps) In WC | 2" | 3" | 4"
0.87 | 4700 | 10300 | 16000
1 | 5050 | 11000 | 17200
1.73 | 6630 | 14500 | 22600
2 | 7120 | 15600 | 24200
2.6 | 8100 | 17700 | 27600
3 | 8700 | 19000 | 29600
3.46 | 9330 | 20400 | 31800
4 | 10000 | 21900 | 34100
6 | 12200 | 26700 | 41500
8 | 14000 | 30600 | 47700
10 | 15600 | 34000 | 53000
12 | 17000 | 37100 | 57800
15 | 18800 | 41100 | 64000
20 | 21400 | 46800 | 72900
Set Vacuum | 8
Flow | 25000
[NAME] | 3" | <---I want this to use the 8.00 row, find the first column that exceeds 25000, and return the column header.
Spreadsheet: 42cd56c3-b650-40c9-9738-1f254cea38c0
Sheet: LexisNexis

LexisNexis
2008-2009
 | 2008-07-01 00:00:00 | 2008-08-01 00:00:00 | 2008-09-01 00:00:00 | 2008-10-01 00:00:00 | 2008-11-01 00:00:00 | 2008-12-01 00:00:00 | 2009-01-01 00:00:00 | 2009-02-01 00:00:00 | 2009-03-01 00:00:00 | 2009-04-01 00:00:00 | 2009-05-01 00:00:00 | 2009-06-01 00:00:00 | Total | 2008-2009 Price | Price per unit
Academic
Sessions | N/A | N/A | N/A | N/A | N/A | 452 | 802 | 3478 | 5889 | 5764 | 1220 | 971
Searches | 1304 | 533 | 2429 | 4756 | 3962 | 2391 | 624 | 2418 | 4091 | 3839 | 882 | 563 |  | 22063.1
Congressional
Sessions | N/A | N/A | N/A | N/A | N/A | 2 | 7 | 43 | 125 | 42 | 28 | 13
Searches | 12 | 5 | 78 | 167 | 66 | 29 | 18 | 108 | 0 | 78 | 80 | 46 |  | 7446.6
COUNTER-Compliant?: | Yes (R3)
Updated 5/18/10 ajr
Spreadsheet: 838613d1691165189-timesheet-not-calculating-properly-looking-for-help-blank-timesheet-fy24-2-
Sheet: Sheet1

TIME SHEET |  |  | NAME: | [Name] |  | [Role] |  | Salary
DAY | DATE | Non/Union | IN | OUT | BREAK | TOTAL | TOTAL PAID | Show
MONDAY | 2023-07-31 00:00:00 | N | 09:00:00 | 15:00:00 | 0.5
TUESDAY | 2023-08-01 00:00:00 | N | 11:00:00 | 17:00:00 | 1.5
WEDNESDAY | 2023-08-02 00:00:00 | N | 09:30:00 | 16:30:00 | 1
THURSDAY | 2023-08-03 00:00:00 | N | 09:00:00 | 20:00:00 | 1
FRIDAY | 2023-08-04 00:00:00 | N | 10:30:00 | 17:30:00 | 2.5
SATURDAY | 2023-08-05 00:00:00 | N | 00:00:00 | 17:00:00 | 8
SUNDAY | 2023-08-06 00:00:00
WEEKLY TOTAL: |  | Rate | 25 | Total @ Rate:
 |  | Over Time | 37.5 | Total @ OT:
 |  |  |  | Grand Total:
Submitted by: [NAME] |  |  |  |  | Approved by: |  | [Name]
Spreadsheet: 97952d1297061760-multilookup-alongwith-sorting-for-only-months-plus-clubbing-like-data-multilookup-sort-clubbing
Sheet: R

Sr.No | Policy Holders Name | POLICY NO | Date of  Comm | T-T | MODE | NAME OF THE PLAN | Plan Type | SUM ASSURED
1 | [NAME] | 801848411 | 2000-08-01 00:00:00 | 113-22-14 | [NAME] | CHILDREN`S MONEY BACK ASSURANCE PLAN | Insurance | 200000
2 | [NAME] | 801141846 | 2006-06-26 00:00:00 | 173-90-90 | HLY | JEEVAN PLUS | ULIP+Risk | 50000
3 | [NAME] | 801141848 | 2008-06-28 00:00:00 | 165-35-35 | ECS | JEEVAN SARAL | Insurance | 125000
4 | [NAME] | 801141849 | 2008-12-06 00:00:00 | 14-35-35 | [NAME] | ENDOWMENT  WITH BONUS | Insurance | 400000
5 | [NAME] | 801448161 | 2008-12-06 00:00:00 | 14-36-36 | [NAME] | ENDOWMENT  WITH BONUS | Insurance | 200000
6 | [NAME] | 801448164 | 2008-10-07 00:00:00 | 165-35-35 | [NAME] | JEEVAN SARAL | Insurance | 125000
Spreadsheet: 128067d1320768988-check-position-of-a-value-and-give-checkmark-position-checkmark
Sheet: Sheet1

 |  | 10 | 12 | 14 | 17
 |  | 2 | 34 | 48 | 55
 |  | 3 | 34 | 45 | 55 | ü
 |  | 4 | 1 | 8 | 17
 |  | 5 | 2 | 9 | 19
 |  | 5 | 3 | 10 | 18 | ü | Receive a checkmark whenever a value in a column is right below another value.
 |  | 6 | 4 | 11 | 28
 |  | 7 | 5 | 12 | 28 | ü
 |  | 8 | 6 | 13 | 34
 |  | 8 | 7 | 37 | 37 | ü
 |  | 10 | 12 | 3 | 4 | 5 | 6 | 7
 |  | 1 | 10 | 2 | 18 | 22 | 24 | 3 |  | ü
 |  | 17 | 18 | 19 | 20 | 29 | 39 | 56
 |  | 34 | 37 | 39 | 29 | 24 | 29 | 34 |  | ü
 |  | 33 | 38 | 39 | 37 | 35 | 39 | 60
 |  | 38 | 34 | 38 | 34 | 37 | 36 | 56 |  | ü
 |  | Receive a checkmark when any one number in a row is the same as number on the row above, but on the left or right side of the above number
Spreadsheet: 885016d1734427284-how-to-find-projection-dates-from-a-starting-date-lucas-date
Sheet: Feuil1

FID | 2025-01-04 00:00:00
CPF - Cstr | 2026-01-01 00:00:00 | 9 mois après FID
NWP - Cstr | 2026-01-01 00:00:00 | 9 mois après FID
P.camp - Cstr | 2025-01-03 00:00:00 | 1 mois avant FID
EW - Cstr | [NAME] | 2 mois après FID
Comm. | 2027-07-09 00:00:00 | 29 mois après FID
RFSU | 12/31/2027 | 33 mois après FID
NA
Spreadsheet: 108385d1305437921-if-a-cell-in-a-column-in-any-worksheet-x-copy-entire-row-budget_update
Sheet: Gas

Gas
 |  |  |  |  | Total Gas Budget | Spent So Far | Total Remaining
 |  |  |  |  | 100 | 62 | 38
Date | Location | Memo | Method | Amount
2011-05-01 00:00:00 | Conoco |  | AMEX | 10
2011-05-05 00:00:00 | Texaco |  | DISC | 40
2011-05-06 00:00:00 | Chevron |  | DISC | 12
Spreadsheet: 0e8a0487-861d-4237-b786-85f1a932d313
Sheet: Sheet1

Table 7--Peanuts:  U.S. supply and disappearance | Unnamed: 1 | Unnamed: 2 | Unnamed: 3 | Unnamed: 4 | Unnamed: 5 | Unnamed: 6 | Unnamed: 7 | Unnamed: 8 | Unnamed: 9 | Unnamed: 10 | Unnamed: 11 | Unnamed: 12 | Unnamed: 13 | Unnamed: 14
 | Area |  | Yield | Supply |  |  |  |  | Disappearance
Year beginning | Planted | Harvested |  | Beginning |  |  |  |  | Domestic |  | Seed & |  |  | Ending
August 1 |  |  |  | stocks | Production | Imports | Total |  | food | Crush | residual | Exports | Total | stocks
 | 1,000 acres |  | Pounds/acre | Million pounds
2010/11 | 1288 | 1255 | 3312.223107569721 | 1828.748 | 4156.84 | 64.5919124166918 | 6050.179912416692 |  | 2839.7 | 586.553 | 502.4034567803826 | 605.5844556363093 | 4534.240912416692 | 1515.939
2011/121 | 1140.6 | 1097.6 | 3333.263483965015 | 1515.939 | 3658.59 | 254 | 5428.529 |  | 2805 | 603.601 | 471.5970000000003 | 545 | 4425.198 | 1003.331
2012/132 | 1638 | 1608 | 4192.412935323383 | 1003.331 | 6741.4 | 70 | 7814.731 |  | 2949 | 742 | 605.7309999999998 | 1200 | 5496.731 | 2318
1 Estimated.  2 Forecast.
Sources: USDA, National Agricultural Statistics Service, Crop Production and Peanut Stocks and Processing,and U.S. Department of Commerce,
U.S. Census Bureau, Foreign Trade Statistics.
Last update: | 2013-02-12 10:47:50.170000
Spreadsheet: 2be316c3-8d75-49e7-8f98-a7d52a2ddc9f
Sheet: Generation Asset Hourly

Forward Capacity Market Availability Settlement Detail Report |  |  |  |  |  |  |  |  |  |  |  |  |  | Forward Capacity Market Availability Detail Report
SD_FCMAVAIL_<customer id>_<settlement_date>_<version>.CSV |  |  |  |  |  |  |  |  |  |  |  |  |  | SD_FCMAVAIL_<customer id>_<settlement_date>_<version>.CSV
<[NAME] |  |  |  |  |  |  |  |  |  |  |  |  |  | <[NAME]
Date: <mm/dd/yyyy> and Version: <mm/dd/yyyy hh:[NAME]:ss> GMT |  |  |  |  |  |  |  |  |  |  |  |  |  | Date: <mm/dd/yyyy> and Version: <mm/dd/yyyy hh:[NAME]:ss> GMT
Asset Information |  |  |  |  |  |  |  |  |  |  | Amount Delivered
Shortage Event ID | Trading Date | Trading Interval | Resource ID | Asset ID | Asset Name | Asset Type | Cold Notification Time | Cold StartUp Time | Cold StartUp Exempt Flag | Denied Self- Schedule Flag | [NAME] | TMNSR Designation | TMOR Designation | External Transaction Sales | Revenue Quality Metering | Asset Competitive Offer MW | Calculated Asset Hourly Available MW | Asset Hourly Override Description | Asset Hourly Available MW | Asset Available To Supplement
Number | Date | Hour End | Number | Number | String | String | Hours | Hours | Flag | Flag | MW | MW | MW | MW | MW | MW | MW | String | MW | MW
Spreadsheet: 548125d1510880392-how-to-open-all-hyperlinks-in-excel-sheet-in-default-browser-workbook2
Sheet: Sheet1

box 1 | box pics
box 2 | box pics
box 3 | box pics
box 4 | box pics
box 5 | box pics
box 6 | box pics
box 7 | box pics
box 8 | box pics |  |  |  | How can I open all the links from box 1 to box 10 at once in my defulat broswer on mac os  or windows ?
box 9 | box pics
box 10 | box pics
 |  |  | can I make a one clickable cell right here to open all above links at once in my  defualt brsower ?
Spreadsheet: 65139d1265871408-sum-product-or-sum-if-between-2-dates-2010-team-stimpson-summary-
Sheet: Sales Volume

TOTAL SALES | JANUARY | FEBRUARY | [NAME] | APRIL | MAY | [NAME] | JULY | AUGUST | SEPTEMBER | OCTOBER | NOVEMBER | DECEMBER
SALES VOLUME REVENUE | #N/A | #N/A | #N/A | #N/A
SALES PRICE EXISTING | 520000 | 450000 | 0 | 0 | 125000 | 0 | 0 | 0 | 0 | 0 | 0 | 0
TEAM AGENT SALES
SALES VOLUME REVENUE | #N/A
SALES PRICE EXISTING | 0
TOTAL SALES =
Total of all "Sales Volume" for sales period (Jan-Dec) from Revenue Sheets
Total of all "Sales Price" for sales period (Jan-Dec) from Existing Listings Sheet (with the following criteria)
 | Multiply sales price x1 if Listing OR Selling agent is = to one of our agents (Names listed on a pulldown validated cell)
 | Multiply sales price x2 if Listing AND Selling agent is = to one of our agents (Names listed on a pulldown validated cell)
TOTAL AGENT SALES =
Total of all "Sales Price" for sales on Revenue sheets in a period when selling agent = Team Stimpson
Total of all "Sales Price" for sales on Existing Listing sheet in a period with criteria as follows:
 | x1 if listing OR selling agent = to one of our agents
 | x2 if Listing AND Selling agent = to one of our agents
 | have been trying to figure out what I am doing wrong and I am at a loss. What I need is to put the total sales for each month into the cells Jan-Dec in D53-64  For example - For January total sales: If B3:[NAME] is between 1/1/10 and 1/31/10 then give me the total sales for that period from D3:D50 the formula I was trying to use is: =SUMIF(B3:B50,"<="&DATE(1/1/10),D3:D50)+SUMIF(B3:B50,"<"&DATE(1/31/10),D3:50)  I have also tried: =SUMPRODUCT(--(B3:B50<=DATEVALUE("1/1/10")),--(B3:B50<DATEVALUE("1/31/10")),D3:D50)
#N/A
Spreadsheet: louise_kitchen__23092__EastPower1
Sheet: 2's

2's = 22
[NAME], [NAME]
Lenartowich, [NAME]
Baughman, [NAME]
Tricoli, [NAME]
Luong, [NAME]
Tapscott, [NAME]
Dypiangco, [NAME]
Booth, [NAME]
Ward, [NAME]
Hill, [NAME]
Ahmed, Naveed
Kroll, Heather
Grace, [NAME]
Irani, [NAME]
[NAME], [NAME]
Trefz, Greg
Munoz, Victor
Forster, [NAME]
Mitro, Fred
[NAME], Greg
Jafry, [NAME]
Hiemstra, Nick
Spreadsheet: 158845d1338406620-best-way-of-setting-up-exam-database-exam-data
Sheet: Sheet1

Series Year | Series Code | Candidate name | Entry Code | Result UMS/Points
2011 | 1A | student a | exam1 | 44
2011 | 1A | student b | exam1 | 56
2011 | 1A | student c | exam1 | 65
2011 | 1A | student d | exam1 | 45
2011 | 6A | student a | exam2 | 78
2011 | 6A | student b | exam2 | 45
2011 | 6A | student c | exam2 | 67
2012 | 1A | student a | exam1 | 78
2012 | 1A | student a | exam3 | 46
2012 | 1A | student b | exam2 | 78
2012 | 1A | student c | exam1 | 54
2012 | 6A | student a | exam4 | 35
2012 | 6A | student b | exam3 | 56
2012 | 6A | student c | exam2 | 54
2012 | 6A | student c | exam3 | 34
Filter
Sum - Result UMS/Points |  | Series Year | Series Code |  |  |  | Maximum Module Mark
 |  | 2011 |  | 2012 |  | Total Result
Candidate name | Entry Code | 1A | 6A | 1A | 6A
student a | exam1 | 44 |  | 78 |  | 122 | 78
 | exam2 |  | 78 |  |  | 78 | 78
 | exam3 |  |  | 46 |  | 46 | 46
 | exam4 |  |  |  | 35 | 35 | 35
student b | exam1 | 56 |  |  |  | 56 | 56
 | exam2 |  | 45 | 78 |  | 123 | 78
 | exam3 |  |  |  | 56 | 56 | 56
student c | exam1 | 65 |  | 54 |  | 119 | 65
 | exam2 |  | 67 |  | 54 | 121 | 67
 | exam3 |  |  |  | 34 | 34 | 34
student d | exam1 | 45 |  |  |  | 45 | 45
Total Result |  | 210 | 190 | 256 | 179 | 835
Spreadsheet: 821151d1678467278-conditional-formatting-for-specific-phone-number-format-phone-
Sheet: Sheet1

Phone |  |  | What I want it to look like
(425) 821-9224 |  |  | (425) 821-9224
[PHONE] |  |  | [PHONE]
[PHONE] |  |  | [PHONE]
425- 455-6411 |  |  | [PHONE]
(425) 455-6411 |  |  | (425) 455-6411
[PHONE] |  |  | [PHONE]
123 |  |  | 123
333-333 |  |  | 333-333
(123) 123456 |  |  | (123) 123456
000-000-00 |  |  | 000-000-00
[PHONE] |  |  | [PHONE]
Spreadsheet: 860024d1708259143-counting-numbers-0-multiple-times-count-non-zeros
Sheet: Sheet1

0 | 1
0 | 0
0 | 0
14.43584042165273 | 0
14.43584042165273 | 0
0 | 1 | 2
33.32641979857416 | 0
59.19567239229082 | 0
59.19567239229082 | 0
0 | 1 | 3
0 | 0
43.38322126100849 | 0
43.38322126100849 | 0
43.38322126100849 | 0
0 | 1 | 3
0 | 0
0 | 0
0 | 0
0 | 0
0 | 0
5.499207347122933 | 0
0 | 1 | 1
10.1360505686755 | 0
0 | 1 | 1
0 | 0
0 | 0
2.698633692109752 | 0
78.91008069917098 | 0
78.91008069917098 | 0
78.91008069917098 | 0
78.91008069917098 | 0
78.91008069917098 | 0
0 | 1 | 6
0 | 0
21.06415986469347 | 0
0 | 1 | 1
0 | 0
0.08873615273614632 | 0
10.85757714625788 | 0
0 | 1 | 2
0 | 0
85.48851158912294 | 0
105.2114251941405 | 0
105.2114251941405 | 0
105.2114251941405 | 0
105.2114251941405 | 0
105.2114251941405 | 0
105.2114251941405 | 0
105.2114251941405 | 0
105.2114251941405 | 0
105.2114251941405 | 0
105.2114251941405 | 0
105.2114251941405 | 0
105.2114251941405 | 0
105.2114251941405 | 0
105.2114251941405 | 0
105.2114251941405 | 0
105.2114251941405 | 0
105.2114251941405 | 0
0 | 1 | 18
49.45140161752033 | 0
49.45140161752033 | 0
0 | 1 | 2
20.68253649969643 | 0
21.07889541254076 | 0
0 | 1 | 2
Spreadsheet: 887344d1737578242-index-issue-issue
Sheet: CIVIL SET

SHEET NAME | DWG NO. | SHEET NO. | Start STA | End STA |  | 30% |  |  |  |  |  |  |  |  |  |  |  | 60% |  |  |  |  |  |  |  |  |  |  |  | 90% |  |  |  |  |  |  |  |  |  |  |  | COMMENTS | ENGINEERING/PM QUESTIONS
 |  |  |  |  |  |  | PDF |  |  |  | PDF |  |  |  | PDF |  |  |  | PDF |  |  |  | PDF |  |  |  | PDF |  |  |  | PDF |  |  |  | PDF |  |  |  | PDF
 |  |  |  |  |  | CREATED |  | BACKCHECK 1 |  | UPDATE 1 |  | BACKCHECK 2 |  | UPDATE 2 |  | BACKCHECK 3 |  | UPDATE 1 |  | BACKCHECK 1 |  | UPDATE 2 |  | BACKCHECK 2 |  | UPDATE 3 |  | BACKCHECK 3 |  | UPDATE 1 |  | BACKCHECK 1 |  | UPDATE 2 |  | BACKCHECK 2 |  | UPDATE 3 |  | BACKCHECK 3
 | Cover and Parcel |  |  |  |  | Date |  | Date |  | Date |  | Date |  | Date |  | Date |  | Date |  | Date |  | Date |  | Date |  | Date |  | Date
COVER | 0000 | 1
INDEX | 0001 | 2
HYDROTEST | 0002 | 3
PARCEL | 0003 | 3
PARCEL | 0004 | 4
 | PIPELINE
ALIGNMENT | 1000 | 5 | 0+00 | 12+00
ALIGNMENT | 1001 | 6 |  | 39+00
ALIGNMENT | 1002 | 7 |  | 66+00
ALIGNMENT | 1003 | 8 |  | 93+00
ALIGNMENT | 1004 | 9 |  | 117+00
Spreadsheet: 828347d1683425809-calculate-normal-and-after-hours-from-start-and-finish-time-example-time-calculation-take-3
Sheet: Actual implementation

 |  |  |  |  |  |  |  |  |  | Based on Roel's Formula
 |  |  | Start Time: | Finish Time: | STD Time | After Hours | TTL Hours: |  |  | Function used
 |  |  | 23:00:00 | 08:00:00 |  |  |  |  |  | Time | Fractions
 |  |  |  |  | 7:30-16:30 | 16:30-7:30
 |  |  |  | This uses from 16:30 - 7:30 for after hours
 |  |  |  | Works unless start and finish are on the same day
 |  |  | This is the exact implementation I need to use in my final spreadsheet
 |  |  | Either calculate A/H or STD HRS and subtract from TTL to derive the other is fine
Spreadsheet: 041bf08c-b527-4e24-baf1-a0fddf3cf40f
Sheet: Sheet1

Table 9--U.S. vegetable oil and fats prices | Unnamed: 1 | Unnamed: 2 | Unnamed: 3 | Unnamed: 4 | Unnamed: 5 | Unnamed: 6 | Unnamed: 7 | Unnamed: 8
Marketing | Soybean | Cottonseed | Sunflowerseed | Canola | Peanut | Corn | Lard 6 | Edible
year | oil 2 | oil 3 | oil 4 | oil 4 | oil 5 | oil 6 |  | tallow 6
 | Cents/pound
2002/03 | 22.04 | 37.75 | 33.13 | 29.75 | 46.7 | 28.17 | 18.13 | 17.8
2003/04 | 29.97 | 31.21 | 33.42 | 33.76 | 60.84 | 28.43 | 26.13 | 22.37
2004/05 | 23.01 | 28.01 | 43.71 | 30.78 | 53.63 | 27.86 | 21.8 | 18.48
2005/06 | 23.41 | 29.47 | 40.64 | 31 | 44.48 | 25.18 | 21.74 | 18.16
2006/07 | 31.02 | 35.7 | 58.03 | 40.57 | 52.99 | 31.8 | 28.43 | 27.32
2007/08 | 52.03 | 73.56 | 91.15 | 65.64 | 94.53 | 69.4 | 40.85 | 41.68
2008/09 | 32.16 | 37.1 | 50.24 | 39.54 | 78.49 | 32.75 | 26.72 | 25.47
2009/10 | 35.95 | 40.27 | 52.8 | 42.88 | 59.62 | 39.29 | 31.99 | 32.26
2010/11 | 53.2 | 54.5 | 86.12 | 58.68 | 77.24 | 60.76 | 51.52 | 51.34
2011/12 | 51.9 | 53.22 | 83.2 | 57.19 | 100.15 | 56.09 | 48.11 | 50.33
2012/131 | 47 | 48.5 | 65 | 57 | 91.83 | 46.5 | 48.25 | 43
2013/141 | 44.0-48.0 | 47.0-51.0 | 69.0-73.0 | 55.0-59.0 | 89.0-93.0 | 48.0-52.0 | 39.0-43.0 | 38.0-42.0
2011/12
October | 51.73 | 51.56 | 92.5 | 56.81 | 97 | 54.24 | 61.1 | 52.09
November | 51.44 | 50.5 | 91 | 56.13 | 98.75 | 53.98 | 48.86 | 45.51
December | 50.17 | 51.1 | 91 | 55.4 | 96.1 | 53.36 | 48.71 | 50.78
January | 50.99 | 52.19 | 88.75 | 55.06 | 95.81 | 54 |  | 51.1
February | 52.36 | 54.56 | 86 | 56.94 | 95 | 56.3 | 52.55 | 53.17
March | 53.43 | 55.95 | 82 | 59.1 | 96.6 | 59.31 | 54.6 | 52.24
April | 54.96 | 56.88 | 79 | 60.94 | 102.38 | 60.75 | 52.59 | 49
May | 50.69 | 52 | 80 | 55.88 | 106.13 | 58.05 | 54.82 | 55.48
June | 48.65 | 50.05 | 80.2 | 54.1 | 111 | 52.9 | 54.83 | 49.88
July | 51.96 | 53.75 | 78 | 57.44 | 110 | 54.76 | 53 | 49.13
August | 52.65 | 54.65 | 75 | 58.75 | 110 | 57.26 |  | 48.36
September | 53.81 | 55.5 | 75 | 59.75 | 104.5 | 58.21 |  | 47.19
2012/13
October | 49.31 | 51.31 | 74 | 57.5 | 103 | 54.75 | 51.6 | 42.27
November | 46.27 | 49.05 | 70.3 | 58.2 | 99.9 | 51.93 | 57 | 37.15
December | 47.16 | 50.06 | 67.5 | 57.13 | 98.56 | 50.63 |  | 40.92
January | 48.85 | 50.94 | 65.25 | 57.19 | 96.75 | 52.06 | 52.45 | 43.5
February | 49.33 | 51.56 | 65 | 59.38 | 86 | 51.71 | 45.56 | 41.93
March | 48.62 | 50.2 | 64.6 | 58.95 | 79.05 | 47.76 |  | 45
April | 49.28 | 49.94 | 64 | 60.44 | 77.5 | 47.06 | 43.5 | 43.5
May | 49.31 | 49.75 | 64 | 60.45 | 80 | 45.23 | 44.5 | 43.86
June | 47.84 | 48.25 | 64 | 57.5 | 82.75 | 42.5 | 48.5 | 48.44
July1 | 45.19 | 46.19 | 64 | 53.25 | 84 | 38.91 | 53.25 | 49.13
1 Preliminary.  2 Decatur, IL.  3 PBSY Greenwood, MS.  4 Midwest. 5 Southeast mills.  6 Chicago.
NA = Not available.
Sources: USDA, Agricultural Marketing Service,  Monthly Feedstuff Prices and Milling and Baking News.
Last update: | 2013-08-23 11:17:02.690000
Spreadsheet: 679308d1590327568-how-to-find-subtotals-in-variable-positions-testfile2
Sheet: Sheet1

 |  |  |  |  | 42 |  |  |  | The position of the gaps (hence totals) can alter
 |  |  |  |  | 53
 |  |  |  |  | 54 |  |  |  | We will always want to sum from gap to gap
 |  |  |  |  | 91 |  |  |  | or from gap to start
 |  |  |  |  | 49 |  |  |  | or from end to gap
 |  |  |  |  | 82 |  |  |  | the number of gaps will stay constant ,  2 + end in this example
 |  |  |  |  | 57
 |  |  |  |  | 59
 |  |  |  |  | 93
 |  |  |  |  | 15
 |  |  |  |  | 40
 |  |  |  |  | 49
 |  |  |  |  | 4
 |  |  |  |  | 4
 |  |  |  |  | 70
 |  |  |  |  | 2
 |  |  |  |  | 78
 |  |  |  |  | 10
Spreadsheet: 795275d1662593925-need-help-to-find-a-formula-to-repeat-a-previous-value-until-there-there-is-new-value-help-in-formula
Sheet: Sheet1

 | Year | Month | Name | Science Score | [NAME] to display
 | 2022 | Jan | [NAME] | 90 | 90
 | 2022 | Feb | [NAME] |  | 90
 | 2022 | March | [NAME] |  | 90
 | 2022 | March | Mark | 75 | 75
 | 2022 | April | Mark |  | 75
 | 2022 | April | [NAME] | 50 | 50
 | 2022 | May | Mark |  | 75
 | 2022 | May | [NAME] |  | 50
 | 2022 | Jun | Mark | 60 | 60
 | 2022 | Jun | [NAME] |  | 50
 | 2022 | July | Mark |  | 60
 | 2022 | Aug | Mark |  | 60
Spreadsheet: 848075d1698871844-filtering-vba-pivot-table-dummy-sheet-2
Sheet: Perfect Attendance

Month | April
Has Month | TRUE |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | January
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | February
Emp Number | Employee Name |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | March
25814 | [NAME] |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | April
78901 | [NAME] |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | May
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | June
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | July
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | August
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | September
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | October
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | November
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | December
Spreadsheet: 584408d1533156087-take-x-until-a-certain-value-is-met-then-take-100-billing-calculations-example-sumproduct
Sheet: Billing Period Totals

Billing Period | Cumulative Total Collected |  |  |  | 2018-01-01 00:00:00 | Running Total | 2018-02-01 00:00:00 |  | 2018-03-01 00:00:00 |  | 2018-04-01 00:00:00 |  | 2018-05-01 00:00:00 |  | 2018-06-01 00:00:00 |  | 2018-07-01 00:00:00 |  | 2018-08-01 00:00:00 |  | 2018-09-01 00:00:00 |  | 2018-10-01 00:00:00 |  | 2018-11-01 00:00:00 |  | 2018-12-01 00:00:00 |  | 2019-01-01 00:00:00 |  | 2019-02-01 00:00:00 |  | 2019-03-01 00:00:00 |  | 2019-04-01 00:00:00 |  | 2019-05-01 00:00:00 |  | 2019-06-01 00:00:00 |  | 2019-07-01 00:00:00 |  | 2019-08-01 00:00:00 |  | 2019-09-01 00:00:00 |  | 2019-10-01 00:00:00 |  | 2019-11-01 00:00:00 |  | 2019-12-01 00:00:00
2018-01-01 00:00:00 |  |  |  |  | 880
2018-02-01 00:00:00 |  |  |  |  | 880
2018-03-01 00:00:00 |  |  |  |  | 4687
2018-04-01 00:00:00 |  |  |  |  | 800
2018-05-01 00:00:00 |  |  |  |  | 880
2018-06-01 00:00:00 |  |  |  |  | 880
2018-07-01 00:00:00 |  |  |  |  | 880
2018-08-01 00:00:00 |  |  |  |  | 1760
2018-09-01 00:00:00 |  |  |  |  | 880
2018-10-01 00:00:00 |  |  |  |  | 3000
2018-11-01 00:00:00 |  |  |  |  | 5000
2018-12-01 00:00:00 |  |  |  |  | 1000
2019-01-01 00:00:00 |  |  |  |  | 1200
2019-02-01 00:00:00
2019-03-01 00:00:00
2019-04-01 00:00:00
2019-05-01 00:00:00
2019-06-01 00:00:00
2019-07-01 00:00:00
2019-08-01 00:00:00
2019-09-01 00:00:00
2019-10-01 00:00:00
2019-11-01 00:00:00
2019-12-01 00:00:00
2020-01-01 00:00:00
2020-02-01 00:00:00
2020-03-01 00:00:00
2020-04-01 00:00:00
2020-05-01 00:00:00
2020-06-01 00:00:00
2020-07-01 00:00:00
2020-08-01 00:00:00
2020-09-01 00:00:00
2020-10-01 00:00:00
2020-11-01 00:00:00
2020-12-01 00:00:00
Spreadsheet: 372805d1422210903-parse-text-string-based-on-unique-input-parse-gk
Sheet: Sheet1

 | Name | Address | Postcode | Town
[NAME]. 38 45242 Camus 032 682 20 56 | [NAME] | Streetnumber. 38 | 45242 | Camus
[NAME]. 30 45153 Shortview 032 626 40 00 | [NAME] | Streetname.30 | 45153 | Shortview
[NAME]. 1 14352 Dudvile 032 682 22 12 | [NAME] | [NAME]. 1 | 14352 | Dudvile
Copel-Minx Antonia Beech Bruno Hextown. 23 45646 Kruger 032 675 42 12 | Copel-Minx Antonia Beech | Hextown.23 | 45646 | Kruger