tianzl66/Sheetpedia huggingface dataset:
Spreadsheet: 219794d1362950447-conditional-formatting-for-dates-open-cases-inventory
Sheet: Open Cases Inventory

OPEN CASES
INVENTORY
 | Rep | Date   Opened |  | Case Prep |  |  |  |  | Next Action |  | Next Meeting Date | Est. Close Date
NAME | Initials |  | Product | Started | Rep Review | Completed |  |  | Initials | Date |  |  | NOTES
 |  |  |  |  |  |  |  |  | bh | 2013-03-10 00:00:00 | 2013-03-14 00:00:00
 |  |  |  |  |  |  |  |  |  |  | 2013-03-10 00:00:00
 |  |  |  | 2013-03-10 00:00:00 |  |  |  |  |  |  | 2013-03-07 00:00:00
 |  |  |  | 2013-03-09 00:00:00 |  |  |  |  |  |  | 2013-03-09 00:00:00 | 2013-03-09 00:00:00
 |  |  |  | 2013-03-04 00:00:00 |  |  |  |  |  |  | 2013-03-05 00:00:00 | 2013-03-05 00:00:00
 |  |  |  | 2013-03-01 00:00:00
Spreadsheet: 0a5f3775-3d63-4f30-9f5d-6c92f320a2ec
Sheet: Sheet1

Unnamed: 0 | Unnamed: 1 | Unnamed: 2 | Unnamed: 3 | Unnamed: 4 | Unnamed: 5 | Unnamed: 6 | Unnamed: 7
ON-CAMPUS PROGRAM/SERVICE COSTS CALCULATION WORKSHEET
PROGRAM/SERVICE:
STAFF MEMBER: |  |  |  |  | DATE:
 |  | Table A            Calculated Program/Service Costs
 |  | Out-of-Pocket Costs
 |  | Refreshments, Meals |  |  |  |  | 0
 |  | Publications, Handouts, Materials |  |  |  |  | 0
 |  | Room Rental |  |  |  |  | 0
 |  | Postage and Advertising |  |  |  |  | 0
 |  | Supplies and Equipment |  |  |  |  | 0
 |  | Costs of non-Extension Speakers |  |  |  |  | 0
 |  | Other Out-of-Pocket Costs |  |  |  |  | 0
 |  | Subtotal Out-of-Pocket Costs |  |  |  |  | 0
 |  | Personnel and Travel Costs
 |  | Support Personnel Salary/Benefits (from Table B) |  |  |  |  | 0
 |  | Support Personnel Travel |  |  |  |  | 0
 |  | Extension Personnel Directly Involved Salary/Benefits (from Table B) |  |  |  |  | 0
 |  | Extension Personnel Directly Involved Travel |  |  |  |  | 0
 |  | Other Personnel and Travel Costs |  |  |  |  | 0
 |  | Subtotal Personnel and Travel Costs |  |  |  |  | 0
 |  | System Costs
 |  | On-Campus System Cost @ 36.5% |  |  |  |  | 0
 |  | Total Calculated Program/Service Costs |  |  |  |  | 0
 |  | Table B             Personnel and Travel Cost Calculations:
 |  | Salary/Benefits |  |  |  | Travel
 |  | Support Personnel | Hours | Ave $ per Hr | Cost | Travel
 |  |  |  | 0 | 0 | 0
 |  |  |  | 0 | 0 | 0
 |  |  |  | 0 | 0 | 0
 |  |  |  | 0 | 0 | 0
 |  | Total Support Personnel Cost |  |  | 0 | 0
 |  | Direct Personnel | Hours | Ave $ per Hr | Cost | Travel
 |  |  |  | 0 | 0 | 0
 |  |  |  | 0 | 0 | 0
 |  |  |  | 0 | 0 | 0
 |  |  |  | 0 | 0 | 0
 |  |  |  | 0 | 0 | 0
 |  | Total Direct Personnel Cost |  |  | 0 | 0
 |  |  |  |  |  | Paid by Partners | Provided  by           Res & Ext
 |  | Table C  Costs | Subtotals from Program/Service Costs Above |  | Paid by Client
 |  | Out of Pocket | 0 |  | 0 | 0 | 0
 |  | Travel | 0 |  | 0 | 0 | 0
 |  | Personnel | 0 |  | 0 | 0 | 0
 |  | System | 0 |  | 0 | 0 | 0
 |  | Total Allocations | 0 |  | 0 | 0 | 0
 |  | Number of Participants | 0
 |  | Cost per Participant excluding Personnel
 |  | Total Cost per Participant
 |  | Partners:
 | KSU 8-41 A (2/2012)
Spreadsheet: 759210d1639418584-formulas-to-auto-sort-values-sample-1
Sheet: INDEX

0 | 49999 | = | H
50000 | 99999 | = | I
100000 | 149999 | = | J
150000 | 199999 | = | K
200000 | 249999 | = | L
250000 | 299999 | = | M
300000 | 349999 | = | N
350000 | 399999 | = | O
400000 | 499999 | = | P
500000 | 549000 | = | Q
500000 | 5000000 | = | R
Spreadsheet: 50588d1250060518-excel-to-database-sample-to-database-data
Sheet: Customer Data

Customer_ID | Name | Address | P.O. BOX | Lusaka | Phone: | Fax:
1 | A | AB | A11 |  | 12345 | 11589
2 | B | AC | A12 |  | 12346 | 11590
3 | C | AD | A13 |  | 12347 | 11591
4 | D | AE | A14 |  | 12348 | 11592
5 | E | AF | A15 |  | 12349 | 11593
6 | F | AG | A16 |  | 12350 | 11594
7 | G | AH | A17 |  | 12351 | 11595
8 | H | AI | A18 |  | 12352 | 11596
9 | I | AJ | A19 |  | 12353 | 11597
10 | J | AK | A20 |  | 12354 | 11598
Spreadsheet: 1cf407b5-6a7f-49ee-af76-d43eb1ddd8a9
Sheet: Sheet1

Table 7--U.S. feed grain imports by selected sources (1,000 metric tons) 1/, 10/15/2012 | Unnamed: 1 | Unnamed: 2 | Unnamed: 3 | Unnamed: 4 | Unnamed: 5 | Unnamed: 6
Import and country/region |  | ---------- 2010/11 ---------- |  | ---------- 2011/12 ---------- |  | 2012/13
 |  | Mkt year | [NAME] | Mkt year | [NAME] | [NAME]
Oats | Canada | 1393.292808 | 365.50405 | 1556.499397 | 297.91844 | 503.532218
 | Finland | 73.932572 | 51.724542 | 34.84057 | 7.837
 | Jamaica | 0.159212 | 0.006248999999999999 | 0.285218 | 0.095232
 | All other countries | 0.264317 | 0.082076 | 29.802409 | 0.134198 | 0.491874
 | Total 2/ | 1467.648909 | 417.316917 | 1621.427594 | 305.98487 | 504.0240919999999
Malting barley | Canada | 174.724159 | 69.123413 | 263.6603059999999 | 5.771765 | 96.260888
 | All other countries | 0.006579999999999999 |  | 0.244638 | 0.017 | 0.016575
 | Total 2/ | 174.730739 | 69.123413 | 263.904944 | 5.788765 | 96.277463
Other barley 3/ | Canada | 30.697571 | 5.072918 | 89.27383700000001 | 14.675048 | 13.134776
 | All other countries | 1.288141 | 0.173974 | 0.7575109999999999 | 0.01575 | 0.7971750000000001
 | Total 2/ | 31.985712 | 5.246892 | 90.031348 | 14.690798 | 13.931951
1/ Grain only. Market year (June-May) and market year to date. 2/ Totals may not add due to rounding.
3/ Grain for purposes other than malting, such as feed and seed use. Source: U.S. Department of Commerce, Bureau of the Census, Foreign Trade Statistics.
Date run: 10/14/2012
Spreadsheet: 167838d1342115992-problem-with-formula-that-displays-contents-from-some-cells-but-not-others-pilotlog-sample
Sheet: Pilot2

 |  |  |  |  |  |  | Pilot Log Book
 |  |  |  |  |  |  |  | part 1
 |  | Aircraft |  | Captain |  | Holders Operating | Journey or Nature of flight |  | [NAME] | [NAME] | Single Engine
 | Date | Type | Reg |  |  | Capacity | From | To | (GMT) | (GMT) | In Command | Dual | T.Off | LDGs | Remarks |  |  |  |  | Licence No. -
 |  |  |  |  |  |  | Brought forward from previous record |  |  |  |  |  |  |  |  |  |  |  |  | [NAME] expiry
 | 2012-07-10 00:00:00 | Beagle | G-AXNP | [NAME] |  | P1 | EGCV | EGBB | 11:30:00 | 12:30:00 |  |  |  |  |  |  |  |  |  | Revalidation:
 | 2012-07-11 00:00:00 | Cessna | GABCD | Fred |  | PIC | EGBB | EGCV | 10:00:00 | 11:00:00
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | Medical [NAME]
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | Radio-telephony expiry
 |  |  |  |  |  |  |  | Total hours
 |  |  |  |  |  |  | Total hours  Brought Forward
 |  | Aircraft |  | Captain |  | Holders Operating | Journey or Nature of flight |  | [NAME] | [NAME] | Single Engine
 | Date | Type | Reg |  |  | Capacity | From | To | (GMT) | (GMT) | In Command | Dual | T.Off | LDGs | Remarks
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | TO OK
 |  |  |  |  |  |  |  | Total hours | Carried Forward
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  | Click for Next page
 |  |  |  |  |  |  |  | Grand Total |  |  |  | hours
Spreadsheet: 773202d1647689002-budget-account-formula-required-if-possible-budget-table
Sheet: Account 1

Year | Month | Date | Description | Category | Income | Debits | Balance
 |  | 2019-02-07 00:00:00 | Opening Balance |  | 1000 |  | 1000
 |  | 2019-02-08 00:00:00 | Electricity | Utilities |  | 450
 |  | 2019-02-09 00:00:00 | Shopping | Food & Drinks |  | 120
 |  | 2019-02-14 00:00:00 | Work Pay | Income | 1000
 |  | 2019-02-14 00:00:00 | Internet Transfer | Account 2 |  | 100
 |  | 2019-02-19 00:00:00 | Car Registration | Transport |  | 670
 |  | 2019-02-21 00:00:00 | Work Pay | Income | 970
 |  | 2019-02-21 00:00:00 | Internet Transfer | Account 2 |  | 100
Spreadsheet: 672049d1586702707-building-summary-report-find-multiple-matches-in-a-table-find-multiple-matches-1-index-and-small
Sheet: Sheet1

 |  |  |  |  |  |  |  | Criteria
 |  |  |  |  |  |  |  | Type | Sale
Lot | Type | Date | Value | Description |  |  |  | Lot | [NAME]
WM128 | Purchase | 2019-01-13 00:00:00 | 17760 | Widget 1
[NAME] | Sale | 2019-01-15 00:00:00 | 17990 | Widget 2 |  |  |  | Date | Value | Description
[NAME] | Death | 2019-03-24 00:00:00 | 11649 | Widget 3
[NAME] | Purchase | 2019-05-23 00:00:00 | 18701 | Widget 1
WM138 | Sale | 2019-07-23 00:00:00 | 7718 | Widget 2
WM141 | Death | 2019-08-12 00:00:00 | 30400 | Widget 3
WM141 | Purchase | 2019-09-23 00:00:00 | 15033 | Widget 1
[NAME] | Sale | 2020-03-01 00:00:00 | 11022 | Widget 2
[NAME] | Death | 2020-02-21 00:00:00 | 20400 | Widget 3
WM136 | Purchase | 2020-12-14 00:00:00 | 14432 | Widget 4
Spreadsheet: 1112d33f-e9cb-4b8e-a2e6-54c24c67adcd
Sheet: Sheet1

Unnamed: 0 | Unnamed: 1 | Unnamed: 2 | Unnamed: 3 | Name | Unnamed: 5 | Unnamed: 6 | Unnamed: 7 | Unnamed: 8 | Unnamed: 9
 |  |  |  | Learner ID
 |  |  |  | School/College/University
Government and Public Administration: Governance
Career Pathway Plan of Study for ►Learners ►Parents ►Counselors ►Teachers/Faculty
This Career Pathway Plan of Study (based on the Governance Pathway of the Government and Public Administration Career Cluster) can serve as a guide, along with other career planning materials, as learners continue on a career path. Courses listed within this plan are only recommended coursework and should be individualized to meet each learner’s educational and career goals. *This Plan of Study, used for learners at an educational institution, should be customized with course titles and appropriate high school graduation requirements as well as college entrance requirements.
EDUCATION | LEVELS | GRADE | [NAME] | Math | Science | Social Studies/ Sciences | Other Required Courses Other Electives Recommended       Electives                         Learner Activities | *Career and Technical Courses                    and/ or Degree Major Courses for        Governance Pathway | SAMPLE                                   Occupations Relating                            to This Pathway
 |  | Interest Inventory Administered and Plan of Study Initiated for all Learners
[NAME] |  | 9 |  |  |  |  |  |  | ►Assistant, Deputy, or Chief of Staff ►Cabinet Level Secretary ►Commissioner (County, Parish,                 .   City) ►Commissioner (State Agency) ►Congressional Aide ►Governor ►Legislative Aide ►Legislative Assistant ►Lieutenant Governor ►Lobbyist ►Mayor ►Policy Advisor ►President ►Representative (Fed/State) ►Senator (Fed/State) ►Specialist ►Vice President
 |  | 10
 |  | 11
 |  | College Placement Assessments-Academic/Career Advisement Provided
 |  | 12
 |  | Articulation/Dual Credit Transcripted-Postsecondary courses may be taken/moved to the secondary level for articulation/dual credit purposes.
POSTSECONDARY |  | Year 13
 |  | Year14
 |  | Year 15
 |  | Year 16
 |  |  |  |  |  | Project funded by the U.S. Department of Education (VO51B020001)
Spreadsheet: 808618d1670535662-need-to-exclude-weekends-from-total-countif-formula-2022-annual-leave-tracker-sample
Sheet: Mark Leave

ID | EMP ID | EMP Name | Date | Leave Type | Reason | Weekend | Holiday | Use
 | 10001 | TEST Person | 2022-12-01 00:00:00 | V
 | 10001 | TEST Person | 2022-12-05 00:00:00 | HD
 | 10001 | TEST Person | 2022-12-07 00:00:00 | WH
 | 10001 | TEST Person | 2022-12-16 00:00:00 | SL
 | 10001 | TEST Person | 2022-12-17 00:00:00 | SL
Spreadsheet: 770702d1646229772-want-to-get-the-results-of-mavb-for-invoices-and-counts-and-sorted-smallest-to-largest-export-detail-ms-test
Sheet: mawb

 | MAWB | [NAME] | FILE NUMBERS | FILE COUNTS | SMALLEST TO LARGEST
 | 084-1071-2343 | MS-361-2022 | 361 | 1 | 361
 | 092-2112-2452 | MS-421-2022 | 421 | 1 | 405
 | 141-0518-2240 | MS-405-2022, MS-406-2022,  MS-407-2022, MS-408-2022, | 405, 406, 407, 408 | 4 | 406
 | 141-0521-6691 |  |  | 0 | 407
 | 155-0102-5021 | MS-411-2022, MS-445-2022 | 411, 445 | 2 | 408
 | 155-0102-5393 |  |  |  | 411
 |  |  |  |  | 421
 |  |  |  |  | 445
 | DATA AVAILABLE IN SHEET D, COLUM AD | DATA AVAILABLE IN SHEET D, COLUM J | DATA AVAILABLE IN SHEET D, COLUM H | COUNTS TOTAL COMMAS EITHER IN C OR D | ALLIGN ALL SMALLEST TO LARGEST
Spreadsheet: 186717d1350166811-replace-score-needed-score-board-4-final-1-version-1-
Sheet: Sheet2

Place | Name | Country | Score
 | [NAME] | Norway | 371
 | [NAME] | Germany | 370
 | [NAME] | USA | 369
 | [NAME] | USA | 368
Spreadsheet: 21823d1209825420-if-then-horserace
Sheet: Results

Race | Horse | Position | Odds
1 | Last Chance | 2 | 10.1
1 | No Chance | 1 | 5.2
1 | Every Chance | 4 | 3.7
1 | What! | 3 | 4.1
Spreadsheet: 842978d1694958530-cell-value-is-between-or-equal-to-range-return-header-value-header-based-lookup-between-values-solution-
Sheet: Sheet1

Name | 5 | 4 | 3 | 2 | 1 | Achieved Score | Expected Result |  | Solution
Agent1 | 0.35 | 0.33 | 0.3 | 0.25 |  | 0.4 | 5
Agent2 | 0.35 | 0.33 | 0.3 | 0.25 |  | 0.35 | 5 |  | 5
Agent3 | 0.35 | 0.33 | 0.3 | 0.25 |  | 0.3475 | 4 |  | 4
Agent4 | 0.35 | 0.33 | 0.3 | 0.25 |  | 0.33 | 4 |  | 4
Agent5 | 0.35 | 0.33 | 0.3 | 0.25 |  | 0.3275 | 3 |  | 3
Agent6 | 0.35 | 0.33 | 0.3 | 0.25 |  | 0.3 | 3 |  | 3
Agent7 | 0.35 | 0.33 | 0.3 | 0.25 |  | 0.2875 | 2 |  | 2
Agent8 | 0.35 | 0.33 | 0.3 | 0.25 |  | 0.25 | 2 |  | 2
Agent9 | 0.35 | 0.33 | 0.3 | 0.25 |  | 0.17 | 1 |  | 1
Agent10 | 0.35 | 0.33 | 0.3 | 0.25 |  | 0.15 | 1 |  | 1
Spreadsheet: 834099d1687443825-formula-to-average-shipment-weight-by-piece-code-wise-rate-calculation-revised-single-code-ans
Sheet: AA

 | Code | From Date | To Date | Days | Connected Load | Load | Rate/Month | FORMULA | Calculation method used for reference | Remarks
 | AG | 2022-01-01 00:00:00 |  |  |  | 19 |  |  | (20*G2)*E2/30 | 20 is the rate for AG category for the from and to date time frame, 30 is the days for one month
 | AG | 2022-03-28 00:00:00 |  |  |  | 40 |  |  | (20*G3)*E3/30 | 20 is the rate for AG category for the from and to date time frame, 30 is the days for one month
 | AG | 2022-07-23 00:00:00 | 2022-09-25 00:00:00 |  |  | 6 |  |  | (20*G4)*E4/30 | 20 is the rate for AG category for the from and to date time frame, 30 is the days for one month
 | AG | 2022-07-23 00:00:00 | 2022-09-25 00:00:00 |  |  | 60 |  |  | (20*G5)*E5/30 | 20 is the rate for AG category for the from and to date time frame, 30 is the days for one month
 | AG | 2022-09-01 00:00:00 | 2022-11-02 00:00:00 | 62 |  | 75 |  |  | ((20*G6*28)+(5*G6*34))/30 | 20 and 5 is the rate for AG category for the from and to date time frame respectively, 28 days are at the rate 20 and 34 days are for rate 5. 30 is the days for one month
 | AG | 2022-12-01 00:00:00 |  |  |  | 100 |  |  | ((10*E7*7.5)+(5*E7*(G7-7.5)))/30 | Here I have used load brake up as per sheet BB, you can see in sheet BB that there is rate 10 from load 1 to 7.5 and rate 5 7.51 to 999. So I have calculated here First 7.5 load at the rate 10 and then subtracted 7.5 from total load and then remaining load at the rate of 5
 | AG | 2022-12-01 00:00:00 |  |  |  | 22 |  |  | ((7.5*10*E8)+(5*E8*(G8-7.5)))/30 | Here I have used load brake up as per sheet BB, you can see in sheet BB that there is rate 10 from load 1 to 7.5 and rate 5 7.51 to 999. So I have calculated here First 7.5 load at the rate 10 and then subtracted 7.5 from total load and then remaining load at the rate of 5
 | AG | 2023-02-01 00:00:00 |  |  |  | 35 |  |  | ((7.5*10*E9)+(5*E9*(G9-7.5)))/30 | Here same logic applied as per above but here we have to keep one thing in mind, when you see in sheet BB you will see that in this from date to date time frame period there is in to date cells – symbol available, means these rates are presently active and its end date not yet came.
 |  |  |  |  |  |  |  |  | Days difference we have to count by subtracting dates, for example from [NAME] to 02/11/2022 the days will be 63 but we have to count this days as per subtraction method i.e. 62 days.
Spreadsheet: 786235d1657050564-using-the-large-function-without-considering-duplicate-values-book5
Sheet: calculation

 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 10 |  |  | 2403!M38:[NAME] |  |  |  | '2403'!m38
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | rank
 |  |  |  |  |  |  |  |  |  |  |  | 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
 |  |  |  |  |  |  |  |  |  |  |  | 32
 |  |  |  |  |  |  |  |  |  |  |  | 33
 |  |  |  |  |  |  |  |  |  |  |  | 34
 |  |  |  |  |  |  |  |  |  |  |  | 35
 |  |  |  |  |  |  |  |  |  |  |  | 36
 |  |  |  |  |  |  |  |  |  |  |  | 37
 |  |  |  |  |  |  |  |  |  |  |  | 38
 |  |  |  |  |  |  |  |  |  |  |  | 39
 |  |  |  |  |  |  |  |  |  |  |  | 40
 |  |  |  |  |  |  |  |  |  |  |  | 41
 |  |  |  |  |  |  |  |  |  |  |  | 42
 |  |  |  |  |  |  |  |  |  |  |  | 43
 |  |  |  |  |  |  |  |  |  |  |  | 44
 |  |  |  |  |  |  |  |  |  |  |  | 45
 |  |  |  |  |  |  |  |  |  |  |  | 46
 |  |  |  |  |  |  |  |  |  |  |  | 47
 |  |  |  |  |  |  |  |  |  |  |  | 48
 |  |  |  |  |  |  |  |  |  |  |  | 49
 |  |  |  |  |  |  |  |  |  |  |  | 50
 |  |  |  |  |  |  |  |  |  |  |  | 51
 |  |  |  |  |  |  |  |  |  |  |  | 52
 |  |  |  |  |  |  |  |  |  |  |  | 53
 |  |  |  |  |  |  |  |  |  |  |  | 54
 |  |  |  |  |  |  |  |  |  |  |  | 55
 |  |  |  |  |  |  |  |  |  |  |  | 56
 |  |  |  |  |  |  |  |  |  |  |  | 57
 |  |  |  |  |  |  |  |  |  |  |  | 58
 |  |  |  |  |  |  |  |  |  |  |  | 59
 |  |  |  |  |  |  |  |  |  |  |  | 60
 |  |  |  |  |  |  |  |  |  |  |  | 61
 |  |  |  |  |  |  |  |  |  |  |  | 62
 |  |  |  |  |  |  |  |  |  |  |  | 63
 |  |  |  |  |  |  |  |  |  |  |  | 64
 |  |  |  |  |  |  |  |  |  |  |  | 65
 |  |  |  |  |  |  |  |  |  |  |  | 66
 |  |  |  |  |  |  |  |  |  |  |  | 67
 |  |  |  |  |  |  |  |  |  |  |  | 68
 |  |  |  |  |  |  |  |  |  |  |  | 69
 |  |  |  |  |  |  |  |  |  |  |  | 70
Spreadsheet: 113448d1309354283-count-sessions-then-restart-365-days-after-help-example-itsnotfair-
Sheet: Sheet2

Name | session date | count of sessions | Sum of Sessions by Selection >
[NAME] | 2010-08-01 00:00:00 | 1
[NAME] | 2010-08-02 00:00:00 | 2
[NAME] | 2010-09-03 00:00:00 | 3
[NAME] | 2011-08-12 00:00:00 | 1
Fred | 2010-09-06 00:00:00 | 1
Fred | 2010-09-08 00:00:00 | 2
Fred | 2011-09-07 00:00:00 | 1
Fred | 2011-09-08 00:00:00 | 2
Spreadsheet: 773999d1648151487-want-to-sum-up-specific-cells-in-a-cohort-table-sum-of-diagonal-using-index
Sheet: Sheet1

 | 1 | 2 | 3 | 4 | 5 |  | Helper
April | 100
May | 80 | 100
June | 70 | 80 | 80
July | 60 | 70 | 70 | 70
August | 50 | 60 | 60 | 60 | 70
September | 40 | 50 | 50 | 50 | 60
October | 30 | 40 | 40 | 40 | 50
Spreadsheet: 128755d1321261971-display-named-range-showrange
Sheet: Sheet1

martin3 |  | a
 |  | b
 |  | c
 |  | d
 |  | e
 |  | f
 |  | g |  | named ranges are
 |  | h |  | droplist
 |  | i |  | martin1
 |  | j |  | [NAME]
 |  | k |  | martin3
 |  | l
 |  | m
Spreadsheet: 1d364f99-8c7a-4dbb-aac1-65f902658e80
Sheet: Sheet1

Table 6--U.S. rice imports  1/ | Unnamed: 1 | Unnamed: 2 | Unnamed: 3 | Unnamed: 4 | Unnamed: 5 | Unnamed: 6
Country | 2012/13 | 2011/12 | 2011/12 | 2010/11 | 2009/10 | 2008/09
or | through | through | market | market | market | market
region | November | November | year | year | year | year
 |  |  | 1,000 metric tons
ASIA | 229.113 | 171.809 | 541.563 | 529.833 | 563.943544 | 536.401387
China | 0.883 | 1.574 | 3.571 | 3.1 | 3.786815 | 3.951477
India | 47.288 | 33.008 | 110.58 | 96.454 | 94.809691 | 74.049801
Pakistan | 4.347 | 4 | 15.258 | 17.297 | 19.386689 | 16.851572
Thailand | 130.676 | 125.906 | 387.642 | 393.464 | 400.976938 | 422.132044
Vietnam | 44.707 | 6.526 | 21.664 | 15.601 | 41.55395 | 17.477892
Other | 1.21200000000001 | 0.7949999999999697 | 2.84800000000007 | 3.916999999999916 | 3.429461 | 1.938601
EUROPE & FSU | 3.53 | 5.114 | 14.244 | 12.51 | 9.410672 | 7.566448
Italy | 2.48 | 2.375 | 8.201 | 7.53 | 6.220285 | 5.73241
Spain | 0.366 | 2.093 | 4.671 | 3.753 | 1.55218 | 0.419219
Russia | 0.013 | 0.013 | 0.024 | 0.034 | 0.032442 | 0.064456
United Kingdom | 0.112 | 0.037 | 0.039 | 0.009 | 0.126368 | 0.429608
Other | 0.5589999999999998 | 0.5959999999999999 | 1.309000000000001 | 1.183999999999997 | 1.479397 | 0.920755
WESTERN HEMISPHERE | 10.132 | 33.058 | 64.526 | 42.735403 | 42.735 | 31.065164
Argentina | 1.5 | 0.7 | 3.366 | 2.677 | 2.466583 | 1.121503
Brazil | 1.928 | 21.358 | 30.499 | 6.331 | 3.51007 | 3.902248
Canada | 3.453 | 5.014 | 16.323 | 17.067 | 15.357974 | 18.035834
Mexico | 0.347 | 0.494 | 1.085 | 1.264 | 6.120591 | 6.094151
Uruguay | 2.861 | 5.482 | 13.211 | 15.35 | 2.871551 | 1.710958
Other | 0.04299999999999971 | 0.009999999999996234 | 0.04199999999998738 | 0.045744 | 0.030665 | 0.20047
OTHER | 0.406000000000013 | 0.375 | 3.958000000000069 | 3.532636 | 5.470538 | 39.298261
Egypt | 0.015 | 0 | 0 | 0 | 0.644508 | 36.591199
United Arab Emirates | 0.086 | 0.2 | 0.522 | 3.03 | 4.441327 | 2.224564
Other | 0.305000000000013 | 0.175 | 4.2 | 0.5 | 0.384703 | 0.482498
TOTAL | 243.181 | 210.356 | 624.291 | 588.611 | 609.182188 | 614.33126
1/ Columns labeled "market year" are total August-July imports reported by the U.S. Census Bureau.
All data is reported on a product-weight basis.  Categories may not sum to total due to rounding.
Source: U.S. Census Bureau, Department of Commerce.
Last updated January 11, 2013.
Spreadsheet: 803610d1667571691-formula-to-allocate-annual-inputs-by-quarter-with-a-dynamic-start-date-example
Sheet: Example

 |  | Contributions | 100
 |  | Close Date of Transaction | 2022-09-30 00:00:00 | --> this will always be a quarter end date
 |  | Annual Inputs | 2022 |  |  |  |  |  |  |  |  |  |  | Total
 |  | % funded | 0.1 | 0.2 | 0.2 | 0.2 | 0.05 | 0.05 | 0 | 0 | 0 | 0 | 0 |  | if above 100% error
 |  | $ funded
 |  | Quarterly Inputs | 2022-03-31 00:00:00
 |  | % funded | 0 | 0 | 0 | 0.1 | 0.05 | 0.05 | 0.05 | 0.05
 |  | $ funded
 | Notes: | Don’t start before the Start Date
 |  | If the deal closes on 9/30/22, there is only one more quarter in 2022
 |  | If the user inputs 10% of Cash Flow funded in 2022, then it all must be in 12/31/2022, so the quarterly % for 12/31/22 should show 10%, and all other quarters should show 0%
 |  | for 2023, the user inputs 20% of Cash flow, and there are 4 quarters in 2023, so the quarterly % should show 5% per quarter
 |  | If the deal closes on 6/30/22, there are 2 more quarters in 2022
 |  | If the user inputs 10% of cash flow funded in 2022, then half will be in 9/30/22, and the other half will be in 12/31/22 (5% of cash flow in each)
 |  | It would be awesome if these formulas are dynamic so that no matter the close date
 |  | Below is an attempt I made - can definitely abandon all of this logic if there is a better way to do it
 |  | Close Date | 2022-09-30 00:00:00
 |  | End of First Year
 |  | Date | 2022-03-31 00:00:00
 |  | End of Year
 |  |  | 2022-03-31 00:00:00
 |  | $ Funded by Quarter
 |  |  | actually the first period would need to be adjusted depending on the number of quarters we have in this period
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  | <-- doesnt work for the first year, but maybe its close
 |  | Periods left in year
Spreadsheet: 31892d1227890013-weighted-average-weighted-average
Sheet: Sheet1

 | Lives within 1 mile | Total Population in 1 mile
Marlin | 45726 | 1714167 | Need weighted average for Marlin Here
Candidate 1 | 10175 | 622564
Candidate 2 | 16170 | 652147
Candidate 3 | 1537 | 68180
Candidate 4 | 4175 | 267332
Candidate 5 | 13669 | 103944