tianzl66/Sheetpedia huggingface dataset:
Spreadsheet: 693314d1598911477-help-with-index-match-max-and-avg-formulas-given-multiple-criteria-tracker-sample
Sheet: Input Tab

 |  |  | 2020-08-04 00:00:00 |  |  |  |  |  |  | 2020-08-05 00:00:00 |  |  |  |  |  |  | 2020-08-06 00:00:00
 |  |  | Counts
Category
Counts | Name #1 |  | 35 | 14 | 8 |  |  | 0 |  | 35 | 14 | 8 |  |  | 0 |  | 35 | 14 | 8 |  |  | 0
Counts | Name #2 |  | 90 | 49 | 16 |  |  | 0 |  | 90 | 49 | 16 |  |  | 0 |  | 90 | 48 | 16 |  |  | 0
Counts | Name #3 |  | 85 | 23 | 6 |  |  | 1 |  | 85 | 23 | 6 |  |  | 1 |  | 85 | 23 | 6 |  |  | 1
 |  |  | Product #1
Category |  |  | [NAME] |  | + New In | - Out Used | End Inventory |  |  | [NAME] |  | + New In | - Out Used | End Inventory |  |  | [NAME] |  | + New In | - Out Used | End Inventory
Product #1 | Name #1 |  | 230 |  | 0 | 15 |  |  |  |  |  | 0 | 10 |  |  |  |  |  | 0 | 9
Product #1 | Name #2 |  | 100 |  | 150 | 25 |  |  |  |  |  | 0 | 0 |  |  |  |  |  | 82 | 10
Product #1 | Name #3 |  | 250 |  | 0 | 8 |  |  |  |  |  | 10 | 20 |  |  |  |  |  | 0 | 15
 |  |  | Product #2
Category |  |  | [NAME] |  | + New In | - Out Used | End Inventory |  |  | [NAME] |  | + New In | - Out Used | End Inventory |  |  | [NAME] |  | + New In | - Out Used | End Inventory
Product #2 | Name #1 |  | 500 |  | 0 | 0 |  |  |  |  |  | 0 | 50 |  |  |  |  |  | 200 | 50
Product #2 | Name #2 |  | 400 |  | 10 | 40 |  |  |  |  |  | 0 | 56 |  |  |  |  |  | 100 | 4
Product #2 | Name #3 |  | 300 |  | 5 | 60 |  |  |  |  |  | 200 | 16 |  |  |  |  |  | 0 | 1
Spreadsheet: andy_zipper__734__10_29_01LO
Sheet: Sheet1

 |  |  | SCS  OPTION  DATA
 | TICKER | STRIKE | STR BID | STR ASK | B VOL | A VOL | M STD/DAY | WHEN
 | CL Z1 | 22.5 | 196 | 204 | 52.2 | 54.4 | 0.75 | 2001-10-29 10:07:00
 | CL F2 | 22.5 | 335 | 350 | 52.9 | 55.2 | 0.76 | 2001-10-29 10:07:00
 | CL G2 | 22.5 | 425 | 440 | 51.4 | 53.3 | 0.74 | 2001-10-29 10:07:00
 | CL H2 | 22.5 | 470 | 480 | 48.8 | 49.9 | 0.7 | 2001-10-29 10:07:00
 | CL J2 | 22.5 | 505 | 520 | 46.8 | 48.2 | 0.67 | 2001-10-29 10:07:00
 | CL K2 | 22.5 | 520 | 540 | 43.4 | 45.1 | 0.63 | 2001-10-29 10:07:00
 | CL M2 | 22.5 | 540 | 555 | 41.9 | 43 | 0.6 | 2001-10-29 10:07:00
 | CL N2 | 22.5 | 547 | 562 | 39.5 | 40.6 | 0.57 | 2001-10-29 10:07:00
 | CL Q2 | 22.5 | 550 | 570 | 37.5 | 38.8 | 0.54 | 2001-10-29 10:07:00
 | CL U2 | 22.5 | 555 | 575 | 36 | 37.4 | 0.52 | 2001-10-29 10:07:00
 | [NAME] | 22 | 555 | 575 | 35.1 | 36.4 | 0.49 | 2001-10-29 10:07:00
 | CL X2 | 22 | 560 | 575 | 34 | 34.9 | 0.48 | 2001-10-29 10:07:00
 | [NAME] | 22 | 560 | 580 | 32.9 | 34 | 0.46 | 2001-10-29 10:07:00
 | CL M3 | 21.5 | 550 | 570 | 27.9 | 29 | 0.38 | 2001-10-29 10:07:00
 | CL Z3 | 21.5 | 550 | 570 | 24.9 | 25.8 | 0.34 | 2001-10-29 10:07:00
Spreadsheet: 1bcbfbaf-631f-421a-af25-608c2aa89b9f
Sheet: Sheet1

Table 8--Oilseed prices received by U.S. farmers | Unnamed: 1 | Unnamed: 2 | Unnamed: 3 | Unnamed: 4 | Unnamed: 5 | Unnamed: 6
Marketing | Soybeans2 | Cottonseed3 | Sunflowerseed2 | Canola4 | Peanuts3 | Flaxseed4
year
 | $/bushel | $/short ton | $/cwt. | $/cwt. | Cents/pound | $/bushel
2003/04 | 7.34 | 117 | 12.1 | 10.6 | 19.3 | 5.88
2004/05 | 5.74 | 107 | 13.7 | 10.7 | 18.9 | 8.07
2005/06 | 5.66 | 96 | 12.1 | 9.62 | 17.3 | 5.94
2006/07 | 6.43 | 111 | 14.5 | 11.9 | 17.7 | 5.8
2007/08 | 10.1 | 162 | 21.7 | 18.3 | 20.5 | 13
2008/09 | 9.97 | 223 | 21.8 | 18.7 | 23 | 12.7
2009/10 | 9.59 | 158 | 15.1 | 16.2 | 21.7 | 8.15
2010/11 | 11.3 | 161 | 23.3 | 19.3 | 22.5 | 12.2
2011/12 | 12.5 | 260 | 29.1 | 24 | 31.8 | 13.9
2012/131 | 14.4 | 252 | 25.3 | 26.55 | 30.1 | 13.78
2013/141 | 11.15-13.15 | 275-315 | 21.70-25.00 | 22.20-25.50 | 21.35-24.65 | 13.35-15.35
2012/13
September | 14.3 | 254 | 28.8 | 27 | 35.2 | 13.3
October | 14.2 | 254 | 25.9 | 26.6 | 33.7 | 13.5
November | 14.3 | 255 | 26.3 | 26.7 | 32.6 | 14.1
December | 14.3 | 252 | 24.9 | 27.8 | 36.9 | 13.8
January | 14.3 | 249 | 26 | 26.8 | 31.2 | 13.7
February | 14.6 | 217 | 25.9 | 27.8 | 28.2 | 14.3
March | 14.6 |  | 24.6 | 27.3 | 27.8 | 14.4
April | 14.4 |  | 24.8 | 27.5 | 26.8 | 14.9
May | 14.9 |  | 24 | 28.2 | 27.1 | 15.1
June | 15.1 |  | 24.4 | 27.4 | 27 | 15.2
July | 15.3 |  | 24.2 | 26.2 | 24.2 | 15.1
August | 14.1 |  | 23.7 | 22.2 | 25.1 | 14.9
2013/14
September | 13.3 | 190 | 22.6 | 20.7 | 25.5 | 13.1
October1 | 12.6 | 281 | 19.3 | 19.8 | 25.4 | 13.2
1 Preliminary.  2 September-August.  3August-July. 4 July-June.
NA = Not available. |  | cwt.=hundredweight.
Source: USDA, National Agricultural Statistics Service, Agricultural Prices.
Last update: | 2013-11-13 09:22:30.910000
Spreadsheet: 853809d1703776987-lookup-to-return-x-results-and-punctuation-within-a-statement-book1
Sheet: Sheet1

Name of Participant |  |  |  | Description (if any) |  |  | Place |  |  | Name of Participant |  |  |  | Description (if any) |  |  | Place |  |  | Name of Participant |  |  |  | Description (if any) |  |  | Place
Anna |  |  |  | School 1 |  |  | 146 |  |  | Anna |  |  |  | School 1 |  |  | 146 |  |  | Anna |  |  |  | School 1 |  |  | 146
[NAME] |  |  |  | School 2 |  |  | 6 |  |  | [NAME] |  |  |  | School 2 |  |  | 6 |  |  | [NAME] |  |  |  | School 2 |  |  | 6
[NAME] |  |  |  | School 3 |  |  | 9 |  |  | [NAME] |  |  |  | School 3 |  |  | 9 |  |  | [NAME] |  |  |  | School 3 |  |  | 9
[NAME] |  |  |  | School 4 |  |  | 123 |  |  | [NAME] |  |  |  | School 4 |  |  | 123 |  |  | [NAME] |  |  |  | School 4 |  |  | 123
[NAME] |  |  |  | School 5 |  |  | 121 |  |  | [NAME] |  |  |  | School 5 |  |  | 121 |  |  | [NAME] |  |  |  | School 5 |  |  | 121
Fred |  |  |  | School 6 |  |  | 60 |  |  | Fred |  |  |  | School 6 |  |  | 60 |  |  | Fred |  |  |  | School 6 |  |  | 60
George |  |  |  | School 7 |  |  | 140 |  |  | George |  |  |  | School 7 |  |  | 140 |  |  | George |  |  |  | School 7 |  |  | 140
[NAME] |  |  |  | School 8 |  |  | 135 |  |  | [NAME] |  |  |  | School 8 |  |  | 135 |  |  | [NAME] |  |  |  | School 8 |  |  | 135
[NAME] |  |  |  | School 9 |  |  | 52 |  |  | [NAME] |  |  |  | School 9 |  |  | 52 |  |  | [NAME] |  |  |  | School 9 |  |  | 52
[NAME] |  |  |  | School 10 |  |  | 12 |  |  | [NAME] |  |  |  | School 10 |  |  | 12 |  |  | [NAME] |  |  |  | School 10 |  |  | 12
[NAME] |  |  |  | School 11 |  |  | 6 |  |  | [NAME] |  |  |  | School 11 |  |  | 6 |  |  | [NAME] |  |  |  | School 11 |  |  | 6
[NAME] |  |  |  | School 12 |  |  | 9 |  |  | [NAME] |  |  |  | School 12 |  |  | 9 |  |  | [NAME] |  |  |  | School 12 |  |  | 9
Nick |  |  |  | School 13 |  |  | 10 |  |  | Nick |  |  |  | School 13 |  |  | 10 |  |  | Nick |  |  |  | School 13 |  |  | 10
Qualifying Places: 1 |  |  |  |  |  |  |  |  |  | Qualifying Places: 2 |  |  |  |  |  |  |  |  |  | Qualifying Places: 5
And I can confirm that [NAME] has qualified to the next round. |  |  |  |  |  |  |  |  |  | I can confirm that [NAME] and [NAME] have qualified to the next round. |  |  |  |  |  |  |  |  |  | I can confirm that [NAME], [NAME], [NAME], [NAME] and [NAME] have qualified to the next round.
Spreadsheet: 795235d1662570051-color-cells-of-one-sheet-based-on-contents-from-multiple-other-sheets-class-schedule
Sheet: Teacher 4

Teacher 4 | Monday | Tuesday | Wednesday | Thursday | Friday
08:00:00 | Busy | Free | Free | Free | Busy
08:30:00 | Busy | Free | Free | Free | Busy
09:00:00 | Free | Free | Free | Free | Free
09:30:00 | Free | Free | Free | Free | Free
10:00:00 | Free | Free | Free | Free | Free
10:30:00 | Free | Free | Busy | Free | Busy
11:00:00 | Free | Free | Busy | Free | Busy
11:30:00 | Free | Free | Busy | Free | Busy
12:00:00 | Free | Free | Free | Free | Free
12:30:00 | Free | Free | Free | Free | Free
13:00:00 | Free | Busy | Free | Busy | Free
13:30:00 | Free | Busy | Free | Busy | Free
14:00:00 | Free | Busy | Free | Busy | Free
14:30:00 | Free | Free | Free | Free | Free
15:00:00 | Free | Free | Free | Free | Free
15:30:00 | Free | Free | Free | Free | Free
16:00:00 | Free | Free | Free | Free | Free
16:30:00 | Busy | Busy | Busy | Busy | Busy
17:00:00 | Busy | Free | Busy | Free | Busy
Spreadsheet: 648589d1573122514-dropdown-list-dependent-on-2-criterias-excel_dropdown-example_answer
Sheet: Entry Data

Region | Productcode | Category | Permittance | Comments | Color | helper1 | helper2
USA | 123 | Clothes
Spreadsheet: 786295d1657101194-need-to-sum-multiple-columns-with-multiple-criteria-within-columns-sum-based-on-multiple-criteria-in-mutiple-columns
Sheet: Sheet2

 | Monthly Trial balance for XYZ
 | Description | Ldr code | Jan | Feb | Mar | Dept | Brand
 | Sales | 1000 | 7951.336019162555 | 2109.259290599699 | 9676.44785891797 | 201 | 100 |  | Criteria
 | Sales | 1010 | 3555.932190693826 | 7918.693288024845 | 7654.029994872172 | 202 | 101 |  | Month | Feb
 | Sales | 1020 | 1105.54175854885 | 2491.909312266953 | 772.0147004224586 | 203 | 102 |  | Ledger code | 1000 | 1010 | 1050
 | Sales | 1030 | 6090.01070289184 | 1657.545424733401 | 8759.597734922683 | 204 | 103 |  | Dept | 201 | 202 | 312
 | Sales | 1040 | 8833.059889150889 | 4708.214503346262 | 9563.680112081027 | 310 | 104 |  | Brand | 100 | 101 | 106
 | Sales | 1050 | 3209.732335421173 | 1126.380654982443 | 8380.010807945462 | 312 | 106
 | Sales | 1060 | 4918.548623007205 | 3591.278857102738 | 7324.885599478363 | 315 | 121 |  | Expected Answer
 | ANP | 1000 | 4264.043823554986 | 2992.331527294507 | 3240.028769148852 | 201 | 100 |  | Feb
 | ANP | 1010 | 9111.445405472614 | 3865.739653704561 | 5136.951431883779 | 202 | 101 |  | Monthly Departmental PNL
 | ANP | 1020 | 4979.976265157162 | 7421.347629167809 | 1226.009294667634 | 203 | 102 |  | Dept | Van_Dist.
 | ANP | 1030 | 6952.6653242222 | 1815.790898808724 | 6129.220952817203 | 204 | 103 |  | Sales |  |  |  | Expected Answer
 | ANP | 1040 | 2294.377388126074 | 1456.764767979741 | 9302.064542934177 | 310 | 104 |  | ANP |  |  |  | based on four criteria
 | ANP | 1050 | 1757.866733717183 | 8382.999215666212 | 463.5715776596072 | 312 | 106 |  | Discount |  |  |  | 1.month ,2.ldgr code ,3. Dept and 4.brand
 | ANP | 1060 | 3152.946724664789 | 6653.080362576559 | 8401.02054213432 | 201 | 100
 | Discount | 1000 | 7763.798345291061 | 9841.904093729712 | 9059.983934361724 | 201 | 100 |  | formula  I am trying
 | Discount | 1010 | 5273.034670374152 | 1747.963198003835 | 3096.793706972308 | 202 | 101 |  | =-SUM(SUMIFS(INDEX($D$4:$F$24,0,MATCH($J$11,$D$3:$F$3,0)),$C$4:$C$24,{1000,1010,1050},$G$4:$G$24,{201,202,312},$H$4:$H$24,{100,101,106}))
 | Discount | 1020 | 5686.438594466772 | 2171.911519113546 | 9658.626823803583 | 203 | 102
 | Discount | 1030 | 1830.871176447515 | 4004.884098350612 | 2912.226094067926 | 204 | 103
 | Discount | 1040 | 4858.603308636552 | 731.6280764755135 | 9313.775273999076 | 310 | 104
 | Discount | 1050 | 5343.202010503857 | 5021.490451581648 | 4924.620713349303 | 312 | 106
 | Discount | 1060 | 8778.387157099716 | 7549.098947996322 | 5436.323582511205 | 315 | 100
Spreadsheet: 150086d1334274213-consolidate-text-ef78_example-1-
Sheet: Data Validation

Ian |  |  | Sheet | [NAME]
[NAME] |  |  |  | 0
[NAME] |  |  | 1
Greg |  |  | 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
Spreadsheet: 250223d1373876696-how-to-divide-money-based-on-time-and-amount-of-contribution-profit
Sheet: Sheet1

Date Of commencemnet |  | 2013-07-15 00:00:00
Total value of fund as on Date
Total Profit Earned As on Date |  | 2013-07-20 00:00:00 | 300 | Days Contributed
Name of contributor | Profit Share
[NAME] | 90
[NAME] | 120
[NAME] | 90
Grand Total | 300
Names | Dates |  |  |  | Total | % of Distribution | Profit
 | 2013-07-15 00:00:00 | 2013-07-16 00:00:00 | 2013-07-17 00:00:00 | 2013-07-19 00:00:00
[NAME] | 100
[NAME] |  | 75
[NAME] |  |  | 50
[NAME] |  |  |  | 150
[NAME] |  |  |  | 125
Spreadsheet: 690517d1597150093-redundancy-caslculator-excel-forum-example
Sheet: Sheet1

Emp No | Surname | First name | Job title | Redundancy date | Contractual start date | Notice period In weeks or months? | ER notice period | Length of service at redundancy date plus notice | DOB | AGE AT RED DATE PLUS NOTICE | Number of weeks redundancy
10 | A | 1 | Dogsbody | 2022-06-30 00:00:00 | 2020-01-01 00:00:00 | Weeks | 4 |  | 1970-06-30 00:00:00 |  |  | should be 3
11 | B | 2 | Man Friday | 2022-06-30 00:00:00 | 1996-12-02 00:00:00 | Weeks | 12 |  | 1960-09-27 00:00:00 |  |  | should be 30
12 | C | 3 | Junior Dogsbody | 2022-06-30 00:00:00 | 2005-10-03 00:00:00 | Weeks | 12 |  | 1956-07-13 00:00:00 |  |  | should be 24
13 | D | 4 | [NAME] | 2022-06-30 00:00:00 | 2016-03-01 00:00:00 | Weeks | 12 |  | 1991-12-04 00:00:00 |  |  | But this one is correct…
Spreadsheet: 156287d1337254533-building-multiple-charts-in-one-file-new-wt-and-cg-chart
Sheet: FCF

WEIGHT AND [NAME]BLOCK 1 AIRCRAFT
70116 FCF
DATE | CG | ACFT WT | NOSE WT | TEETER ANGLE (INCHES) | SAR System | Small KU ANT. | Large KU ANT. | EO/IR System | WING PYLONS | HEA | OTHER | BALLAST STATION & AMOUNT |  |  |  |  |  |  | COMPLETED BY | EMPLOYEE # | AMR Reference number
 |  |  |  |  |  |  |  |  |  |  |  | 1 | 2 | 3 | 4 | 5 | 6 | 7
Spreadsheet: 540719d1506919767-having-trouble-with-if-statement-conditions-quartermaster_matrix-v3
Sheet: QuarterMaster_Matrix

 | Number of Nights | 4
 | [NAME]
 | [NAME] | 250
 | [NAME]
 | Food Input - Total | 200
 | Food Inflation Rate | 0.05
 | [NAME] Day | 10 |  |  |  |  |  |  |  |  |  |  |  | #people
 | Tip - Total
 | Person | Day 1 | Day 2 | Day 3 | Day 4 | Day 5 | Day 6 | Day 7 | Day 8 | Day 9 | Day 10 | Dinner $ | FIR | FIR $ Total | Lodging - Total | Food - Total | Expected Column Q Results | Incidentals |  | Participant
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 1.66666666666667
 | [NAME] | 1 | 1 | 1 | 1 |  |  |  |  |  |  |  | 1 |  |  |  | 50.83
 | [NAME] | 1 | 1 | 1 |  |  |  |  |  |  |  |  |  |  |  |  | 26.66666666666666
 | Mark | 1 | 1 | 1 | 1 |  |  |  |  |  |  |  |  |  |  |  | 39.16666666666666
 | [NAME]
 | [NAME] |  |  | 1 | 1 |  |  |  |  |  |  |  |  |  |  |  | 19.16666666666666
 | [NAME] | 1 | 1 | 1 |  |  |  |  |  |  |  |  |  |  |  |  | 26.66666666666666
 | Buddy | 1 | 1 | 1 | 1 |  |  |  |  |  |  |  |  |  |  |  | 39.16666666666666
 | Lodging - Per Day PP
 | Food - Per Day PP
Spreadsheet: 264964d1379024099-looping-through-data-and-finding-cells-that-meet-criteria-test
Sheet: Jane Doe

Supplier # | Supplier | SSR | Discrepancy Type | PO # | PO Date | Stuff | P/n | P/n | Total Order Qty | Received | Total Due | Cost | Balance | Now | Here | When | Ack Qty 1 | Country | Mexico | Canada | Taiwan | Part | Cuba
x | USA | [NAME] | Past Due Ack | y | ? |  | 1 | 1 | 100 | 0 | 0 | 0 | 0 |  |  | ? | 0 | A | 0 | 1 | 0 | 0 | 0
x | USA | [NAME] | Past Due Ack | y | ? |  | 2 | 2 | 100 | 0 | 0 | 0 | 0 |  |  | ? | 0 | A | 0 | 1 | 0 | 0 | 0
x | USA | [NAME] | Past Due Ack | y | ? |  | 3 | 3 | 100 | 0 | 0 | 0 | 0 |  |  | ? | 0 | A | 0 | 1 | 0 | 0 | 0
x | USA | [NAME] | Past Due Ack | y | ? |  | 4 | 4 | 100 | 0 | 0 | 0 | 0 |  |  | ? | 0 | A | 0 | 1 | 0 | 0 | 0
x | USA | [NAME] | Past Due Ack | y | ? |  | 5 | 5 | 100 | 0 | 0 | 0 | 0 |  |  | ? | 0 | A | 0 | 1 | 0 | 0 | 0
x | USA | [NAME] | Past Due Ack | y | ? |  | 6 | 6 | 100 | 0 | 0 | 0 | 0 |  |  | ? | 0 | A | 0 | 1 | 0 | 0 | 0
x | USA | [NAME] | Past Due Ack | y | ? |  | 7 | 7 | 100 | 0 | 0 | 0 | 0 |  |  | ? | 0 | A | 0 | 1 | 0 | 0 | 0
x | USA | [NAME] | Past Due Ack | y | ? |  | 8 | 8 | 100 | 0 | 0 | 0 | 0 |  |  | ? | 0 | A | 0 | 1 | 0 | 0 | 0
x | USA | [NAME] | Past Due Ack | y | ? |  | 9 | 9 | 100 | 0 | 0 | 0 | 0 |  |  | ? | 0 | A | 0 | 1 | 0 | 0 | 0
x | USA | [NAME] | Past Due Ack | y | ? |  | 10 | 10 | 100 | 0 | 0 | 0 | 0 |  |  | ? | 0 | A | 0 | 1 | 0 | 0 | 0
x | USA | [NAME] | Past Due Ack | y | ? |  | 11 | 11 | 100 | 0 | 0 | 0 | 0 |  |  | ? | 0 | A | 0 | 1 | 0 | 0 | 0
Spreadsheet: 72411d1273088602-formula-for-multiple-if-statements-and-lookup-functions-sample
Sheet: Calculations

GFE Box 4 - Title Services and Lender’s Title Insurance
Total Wreath Fees
Type of Transaction |  | Fixed Amount
Purchase |  | 965
Refinance |  | 795
Lender's Coverage - if this is a premier REO, the [NAME] will pay [NAME]'s owner coverage
Type of Transaction |  | Amount
Purchase |  | 50
Refinance |  | see rates below
Lender's Coverage Rate if a Refinance
Loan Amount |  |  |  | Price per $1k
For the first $250k |  |  |  | $2.78 per $1k
Over $250k and up to $500k, add |  |  |  | $2.21 per $1k
Over $500k and up to $1M, add |  |  |  | $1.94 per $1k
Over $1M and up to $5M, add |  |  |  | $1.68 per $1k
Over $5M and up to $15M, add |  |  |  | $1.31 per $1k
Over $15M, add |  |  |  | $1.05 per $1k
Note: The minimum premium is $111.20
GFE Box 5 – Owner’s Title Insurance
Owner's Policy Cost - please see the rate table below
Purchase Price |  |  |  | Price per $1k
For the first $250k |  |  |  | $3.89 per $1k
Over $250k and up to $500k, add |  |  |  | $3.31 per $1k
Over $500k and up to $1M, add |  |  |  | $2.78 per $1k
Over $1M and up to $5M, add |  |  |  | $2.21 per $1k
Over $5M and up to $15M, add |  |  |  | $1.84 per $1k
Over $15M, add |  |  |  | $1.58 per $1k
Note: The minimum premium is $155.60
GFE Box 7 – Government Recording Charges
Item |  | Amount | Note
Deed |  | 40 | always charged
Deed of Trust |  | 40 | only if they have a loan
Power of Attorney |  | 20 | if option is selected this applies
GFE Box 8 – Transfer & Recordation taxes
Please see MD Rates on the next tab. The rates vary by county and change depending on certain variables.
Spreadsheet: 823951d1680207523-golf-combine-formulas-for-single-vs-team-match-play-sample-match-scores
Sheet: Sheet1

 |  |  |  | Scores | Hole | 1 |  |  |  |  |  |  |  |  | Total
 |  |  |  | Player 1 |  | 7 | 4 | 6 | 3 | 4 | 3 | 5 | 5 | 7
 |  |  |  | Player 2 |  | 4 | 4 | 4 | 4 | 3 | 4 | 4 | 3 | 5
 |  |  |  | Opponent 1 |  | 5 | 4 | 6 | 3 | 3 | 5 | 5 | 4 | 5
 |  |  |  | Opponent 2 |  | 6 | 3 | 4 | 4 | 4 | 6 | 4 | 3 | 6
 |  |  |  | Individual Match Points
 |  |  |  | Player 1 Wins
 |  |  |  | Player 2 Wins
 |  |  |  | Opponent 1
 |  |  |  | Opponent 2
 |  |  |  | Team Match Points
 |  |  |  | Match Team 1
 |  |  |  | Match Opponent 1
 |  | Game Format |  | Team | <-- drop down
 |  |  |  | Player 1
 |  |  |  | Player 2
 |  |  |  | Opponent 1
 |  |  |  | Opponent 2
 |  |  |  | Match Points awarded
 |  |  |  | Player 1
 |  |  |  | Player 2
 |  |  |  | Opponent 1
 |  |  |  | Opponent 2
Spreadsheet: 111072d1307559594-array-formula-based-on-cell-entry-internship_program_test
Sheet: Formal

Winter 2011 Internship Report
General Statistics
Approximate start date
Approximate end date
Unique internships offered |  |  |  | 0
Total candidates applied |  |  |  | #N/A
Total interns accepted |  |  |  | #N/A
% interns accepted |  |  |  | #N/A
Los Angeles
Recruitment |  |  |  | [NAME]
Number applied | 1 | Spots avail. | 0 | Marketing
Sources used | 0 | App/source | 0
Number failed | 0 | % Failed | 0
Number eligible | 1 | % Eligible | 1
Number passed interview | 1 | % Passed | 1
Number hold (delayed) | 0 | % Hold | 0
Number hired | 1 | % Hired | 1
Notes
Spreadsheet: 871079d1717515043-split-uneven-number-split-weight
Sheet: Sheet1

Example
SPECIES | MSC | PRESENTATION | TOTAL WEIGHT | TOTAL VALUE | TOTAL BOXES | [NAME] | BOX WEIGHT | BOX VALUE | TOTAL
NEPHROPS |  | WHOLE | 559 | 2638.48 | 31 | 4.72
NEPHROPS |  | TAILS | 375 | 2400 | 16 | 6.4
Results expected
SPECIES | MSC | PRESENTATION | TOTAL WEIGHT | TOTAL VALUE | TOTAL BOXES | [NAME] | BOX WEIGHT | BOX VALUE | TOTAL | TOTAL WEIGHT
NEPHROPS |  | WHOLE |  |  | 30 | 4.72 | 18
NEPHROPS |  | WHOLE |  |  | 1 | 4.72 | 19
NEPHROPS |  | TAIL |  |  | 15 | 6.4 | 23
NEPHROPS |  | TAIL |  |  | 1 | 6.4 | 30
Spreadsheet: 37240d1235167565-moving-specific-dates-to-another-worksheet-sample
Sheet: Sheet2

 | THIS IS WHAT I DONE SO FAR…BUT I JUST WANT THE JANUARY DATES HERE
DATE | ORDER# | PRODUCT | CONTACT
2009-02-10 00:00:00 | 4501233848 | [NAME] | [NAME]
2009-01-23 00:00:00 | 4550039365 | Magnesium Sulfate | [NAME]
2009-02-10 00:00:00 | 4501233848 | [NAME] | [NAME]
2009-01-16 00:00:00 | 4501227375 | Sodium Sulfate | [NAME]
2009-01-16 00:00:00 | 010609-22 | Sodium Acetate Trihydrate | [NAME]
2009-01-27 00:00:00 | 60399447 | Ammouniun Bicarbonate | [NAME] May
2009-01-16 00:00:00 | 95438-B | Calcium Chloride | [NAME]
2009-01-21 00:00:00 | 60398813 | Potassium Chloride | [NAME]
2009-01-27 00:00:00 | 1051703 | Zinc Sulfate | [NAME]
2009-02-08 00:00:00 | 34434967 | Potasium Bi | [NAME]
2009-01-05 00:00:00 | 7897954 | Calcium Dioxide | [NAME]
2009-01-27 00:00:00 | AU452254 | Citric Acid Granular | [NAME]
2009-02-11 00:00:00 | AU452254 | HH | [NAME]
2009-01-29 00:00:00 | 95438-B2 | Calcium Chloride | [NAME]
2009-01-20 00:00:00 | 60398817 | [NAME] | [NAME]
2009-01-20 00:00:00 | 60398810 | [NAME] | [NAME]
2009-02-09 00:00:00 | 1052678 | [NAME] | [NAME]
2009-01-13 00:00:00 | 93140-B | Sodium Sulfate | [NAME]
2008-12-10 00:00:00 | 345464 | Peroxide | [NAME]
2009-01-20 00:00:00 | 4550039427 | Sodium Carbonate | [NAME]
2009-02-03 00:00:00 | 93140-B5 | Ammonium Acetate | [NAME]
2009-02-05 00:00:00 | 20509023 | Sodium Phosphate | [NAME]
2009-02-17 00:00:00 | 103743-A | Calcium Chloride | [NAME]
2009-02-26 00:00:00 | 513395OP | Sodium Tetraborate | [NAME]
2008-12-05 00:00:00 | 567567 | [NAME] | [NAME]
1900-01-01 00:00:00 | 1900-01-01 00:00:00 | 1900-01-01 00:00:00 | 1900-01-01 00:00:00
1900-01-01 00:00:00 | 1900-01-01 00:00:00 | 1900-01-01 00:00:00 | 1900-01-01 00:00:00
1900-01-01 00:00:00 | 1900-01-01 00:00:00 | 1900-01-01 00:00:00 | 1900-01-01 00:00:00
1900-01-01 00:00:00 | 1900-01-01 00:00:00 | 1900-01-01 00:00:00 | 1900-01-01 00:00:00
1900-01-01 00:00:00
Spreadsheet: 271133d1381840429-need-help-summing-two-columns-of-data-if-data-is-present-in-a-third-column-test
Sheet: PALL90x55-P250 (Domestic)

BASE: | PALL90x55-P250 (Domestic) |  |  | OUTBOUND INFORMATION |  |  |  | TOTAL PIECES ON HAND
PO | QUANTITY | DATE AVAILABLE |  | WEBSHIPPER | QUANTITY | DATE OUT
FIRST COUNT | 8 | 2013-10-13 00:00:00 |  | 12345 | 5 | 2013-10-14 00:00:00
9999 | 8 | 2013-10-14 00:00:00
9991 | 2
Spreadsheet: 764538d1642782174-requesting-for-a-nested-formula-to-allot-the-amount-variable-lookup-anil_kumar2011-
Sheet: Sheet1

2021-12-01 00:00:00 |  |  |  |  |  |  |  |  |  |  | Parameter | Criteria
 |  |  |  |  |  |  |  |  |  |  | Attendance | 1 day leave or no leaves
 |  |  |  |  |  |  |  |  |  |  | Other Parameters | >= team average
Name | Cummulative Score | Talktime | Leaves | EMP ID | Eligibility | Category | Amount | Rank | Category Rank
AAA | Not Eligible | 1 | 0 | ED21833273 | Cummulative Score | 5 |  | 31 |  |  | Slab | Criteria | Amount (TBD)
BBB | Not Eligible | 0 | 2 | ED21834339 | Cummulative Score | 5 |  | 28 |  |  | 1 | With 100% attendance & all other criteria | 10000 | 9750 | 9500
CCC | Eligible | 1 | 0 | ED21833277 | Eligible | 2 |  | 4 |  |  | 2 | With 100% attendance & all criteria (except TT >= 2 hour | 8000
DDDD | Not Eligible | 0 | 1 | ED21833479 | Cummulative Score | 5 |  | 34 |  |  | 3 | With 1 day leave & all criteria | 6000
EEEE | Not Eligible | 2 | 1 | ED21817669 | Cummulative Score | 5 |  | 21 |  |  | 4 | With 1 day leave & all criteria (except TT >= 2 hour | 4000
FFFF | Not Eligible | 0 | 4 | ED201804269 | Cummulative Score | 5 |  | 20 |  |  |  | [NAME] | Min | Condition | Count | 1 | 2 | 3 | 4 | 5
GGGG | Not Eligible | 0 | 3 | ED201804270 | Cummulative Score | 5 |  | 37 |  |  | Slab 1 with someone in Slab 2 | 10000 | 9000
HHHH | Not Eligible | 2 | 1 | ED21854295 | Cummulative Score | 5 |  | 27 |  |  | Slab 1 with no one in Slab 2 | 10000 | 7000
IIIII | Eligible | 1 | 0 | ED201705637 | Eligible | 2 |  | 3 |  |  | Slab 2 | 8999 | 7000
JJJJJJ | Eligible | 1 | 4 | ED21834792 | Attendance | 5 |  | 13 |  |  | Slab 3 with someone in Slab 4 | 6999 | 5000
KKKK | Eligible | 1 | 0 | ED201500744 | Eligible | 2 |  | 1 |  |  | Slab 3 with no one in Slab 4 | 6999 | 4000
LLLLLLL | Not Eligible | 0 | 3 | ED21853052 | Cummulative Score | 5 |  | 36 |  |  | Slab 4 | 4999 | 4000