tianzl66/Sheetpedia huggingface dataset:
Spreadsheet: 63230d1264156172-freight-calculator-calculator
Sheet: CALCULATOR

 | TYPE IN | TYPE IN | THE VALUE HERE IS PULLED FROM C22
 | COUNTRY | AREA CODE | WEIGHT
 | Spain | 13560
 | FREIGHT COST
 |  |  |  | ???
WEIGHT RANGE FOR ALL COUNTRIES | 1ST STEP: TYPE WEIGHT IN LBS HERE: | 2ND STEP: THE FORMULA CONVERTS KG TO LBS AND ROUNDS UP ACCORDING TO THE WEIGHT RANGE (COLUMN A)
WEIGHT RANGE | PRODUCT WEIGHT (KG) | CALCULATED WEIGHT (LBS)
24000 | 1564
20000
17500
15000
12500
10000
7500
5000
4000
3500
2500
2400
2300
2200
2100
2000
1900
1800
1700
1600
1500
1400
1300
1200
1100
1000
900
800
700
600
500
400
300
200
100
50
Spreadsheet: 837015d1689785859-three-drop-down-lists-comparing-players-data
Sheet: Arkusz1

 | Stage1 | Stage2 | Stage3 | Stage4
Competitor1 | 1 | 4 | 5 | 10 |  |  |  | Stage1
Competitor2 | 2 | 5 | 4 | 7 |  |  | Competitor1 |  |  | Competitor5
Competitor3 | 3 | 1 | 3 | 9
Competitor4 | 4 | 7 | 10 | 3
Competitor5 | 5 | 6 | 9 | 4
Competitor6 | 6 | 10 | 8 | 2
Competitor7 | 7 | 9 | 1 | 6
Competitor8 | 8 | 8 | 2 | 1
Competitor9 | 9 | 2 | 6 | 8
Competitor10 | 10 | 3 | 7 | 5
Spreadsheet: 161367d1339509530-histogram-help-needed-wrong-histogram
Sheet: Wrong histogram

Bin | Score | [NAME] |  | Bin | Frequency | WRONG |  |  |  |  |  |  |  | [NAME] | Frequency
0 | 1.01 | 0 |  | 0 | 5 | 6 |  |  |  |  |  |  |  | 0 | 5
0.2 | 1.35 | 0.2 |  | 0.2 | 1 |  |  |  |  |  |  |  |  | 0.2 | 1
0.4 | 0 | 0.4 |  | 0.4 | 1 |  |  |  |  |  |  |  |  | 0.4 | 1
0.6 | 1.35 | 0.6 |  | 0.6 | 1 |  |  |  |  |  |  |  |  | 0.6 | 1
0.8 | 0 | 0.8 |  | 0.8 | 6 |  |  |  |  |  |  |  |  | 0.8 | 6
1 | 0.23 | 1 |  | 1 | 2 | 3 |  |  |  |  |  |  |  | 1 | 2
1.2 | 0 | 1.2 |  | 1.2 | 2 |  |  |  |  |  |  |  |  | 1.2 | 2
1.4 | 0.08 | 1.4 |  | 1.4 | 2 |  |  |  |  |  |  |  |  | 1.4 | 2
1.6 | 1 | 1.6 |  | 1.6 | 1 |  |  |  |  |  |  |  |  | 1.6 | 1
1.8 | 0.67 | 1.8 |  | 1.8 | 1 |  |  |  |  |  |  |  |  | 1.8 | 1
2 | 0.67 | 2 |  | 2 | 0 |  |  |  |  |  |  |  |  | 2 | 0
2.2 | 0 | 2.2 |  | 2.2 | 0 |  |  |  |  |  |  |  |  | 2.2 | 0
2.4 | 1.68 | 2.4 |  | 2.4 | 0 |  |  |  |  |  |  |  |  | 2.4 | 0
2.6 | 0.99 | 2.6 |  | 2.6 | 0 |  |  |  |  |  |  |  |  | 2.6 | 0
2.8 | 0 | 2.8 |  | 2.8 | 0 |  |  |  |  |  |  |  |  | 2.8 | 0
3 | 1.01 | 3 |  | 3 | 0 |  |  |  |  |  |  |  |  | 3 | 0
 | 0.67 |  |  | More | 0 |  |  |  |  |  |  |  |  | More | 0
 | 1.51 |  |  |  |  |  | Incorrect frequency numbers - why ?
 | 0.67
 | 0.67
 | 0.68
 | 0.5
Spreadsheet: 33315d1229613809-help-with-complex-interpolation-civil-engineering-earthwork-problem-earthwork
Sheet: QuantityReportTemp

STATION | CUT AREA | CUT VOLUME | FILL AREA | FILL VOLUME | CUMULATIVE CUT VOLUME | CUMULATIVE FILL VOLUME
300 | 5.79 | 0 | 0 | 0 | 0 | 0
320 | 5.2 | 109.9 | 2.5 | 25 | 109.9 | 25
340 | 5.72 | 109.2 | 2 | 45 | 219.1 | 70
360 | 5.37 | 110.9 | 1.11 | 31.1 | 330 | 101.1
380 | 6.42 | 117.9 | 1.5 | 26.1 | 447.9 | 127.2
400 | 5.61 | 120.3 | 0.5 | 20 | 568.2 | 147.2
420 | 6.82 | 124.3 | 2 | 25 | 692.5 | 172.2
430.5 | 0 | 35.805 | 2.1 | 21.525 | 728.305 | 193.725
 |  |  |  |  |  |  |  |  | Ranges Station1 | Ranges Station2
 |  |  |  |  |  | Enter Station 1--> | 305 |  | 300 | 400
 |  |  |  |  |  | Enter Station 2--> | 402.35 |  | 305 | 402.35
 |  |  |  |  |  |  |  |  | 320 | 420
THE SOLUTION STEP BY STEP
1.- | Interpolate between 300 and 320 to obtain the 305 Cut Area and Cut Volume |  |  |  |  |  |  |  | Cut Area | Fill Area | Cut Volume | Fill Volume
 | The cut area at 305 would be: |  | 5.6425 |  |  | Station 1
 | The fill area at 305 would be: |  | 0.625 |  |  | Cut and fill areas at 305 |  |  | 5.6425 | 0.625
 |  |  |  |  |  | Cut and [NAME] between 305 and 320 |  |  |  |  | 81.31875000000001 | 23.4375
 | Also interpolate between 400 and 420 to obtain the 402.35 Cut Area and Cut Volume
 | The cut area at 402.35 would be: |  | 5.7521
 | The fill area at 402.35 would be: |  | 0.6762 |  |  | Station 2
 |  |  |  |  |  | Cut and fill areas at 402.35 |  |  | 5.752175000000002 | 0.6762500000000017
2.- | Obtain the volumes between 305 and 320 |  |  |  |  | Cut and [NAME] between 400 and 402.35 |  |  |  |  | 13.35055562500013 | 1.382093750000015
 | Cut volume = | 81.31875000000001
 | Fill volume = | 23.4375
 |  |  |  |  |  | Cut and [NAME] between 320 and 400 |  |  |  |  | 458.3000000000001 | 122.2
 | Also, obtain the volumes between 400 and 402.35
 | Cut volume = | 13.35046750000013 |  |  |  | Total Cut and [NAME] |  |  |  |  | 552.9693056250002 | 147.01959375
 | Fill volume = | 1.382035000000013
3.- | Now find the volumes between 320 and 400
 | Cut volume = | 458.3000000000001
 | Fill volume = | 122.2
4.- | The total volumes between station 305 and 402.35 is:
 | Cut volume = | 552.9692175000002
 | Fill volume = | 147.019535
Spreadsheet: 148423d1333396619-creating-a-report-to-show-vehicle-tax-due-tax-disc-log-trial
Sheet: DX08 HRJ

 |  |  |  |  | DX08 HRJ
Registration number : | DX08 HRJ |  | Date Taxed | Duration | Tax Expiry  Date | Cost (£)
Manufacturer : | DAF |  | 30/03/2008 (By Imperial Commerical) | 12 Months | 2009-04-01 00:00:00 | £1200 + £55 (1st Reg)
Specification : | 6 x 2 A (3 Axle) |  | [NAME] by class change from HGV to RP HGV 30/4/2008
Type : | FTG XF 105.460 |  | 30/04/2008 (New Licence issued) | 11 Months | 2009-04-01 00:00:00 | £700 (RPC)
1st Registered : | 01.04.08 |  | 2009-03-31 00:00:00 | 12 Months | 2010-04-01 00:00:00 | £700 (RPC)
Engine : | MX 340 S2 12.9 litre |  | 2010-03-31 00:00:00 | 12 Months | 2011-04-01 00:00:00 | £700 (RPC)
[NAME] : | 44,000kg |  | 2011-03-31 00:00:00 | 12 Months | 2012-04-01 00:00:00 | £700 (RPC)
Back To Index
Spreadsheet: 821178d1678483850-copying-only-certain-items-to-separate-sheet-based-on-if-formula-new-reports
Sheet: Laser Tag

 | Laser Tag
Time | Party Room | Party Name | Items | Time | Quanity
10:00:00 | 1 | Billys bday | Laser Tag | 13:00:00 | 10
 |  |  | Go Karts | 13:15:00 | 10
11:30:00 | 1 | [NAME] | Go Karts | 14:00:00 | 12
13:00:00 | 1
14:30:00 | 1
16:00:00 | 1
17:30:00 | 1
19:00:00 | 1
20:30:00 | 1
10:00:00 | 2
11:30:00 | 2
13:00:00 | 2
14:30:00 | 2
16:00:00 | 2
17:30:00 | 2
19:00:00 | 2
20:30:00 | 2
10:00:00 | 3
11:30:00 | 3
13:00:00 | 3
14:30:00 | 3
16:00:00 | 3
17:30:00 | 3
19:00:00 | 3
20:30:00 | 3
10:30:00 | 4
12:00:00 | 4
13:30:00 | 4
15:00:00 | 4
16:30:00 | 4
18:00:00 | 4
19:30:00 | 4
10:30:00 | 5
12:00:00 | 5
13:30:00 | 5
15:00:00 | 5
16:30:00 | 5
18:00:00 | 5
19:30:00 | 5
10:30:00 | 6
12:00:00 | 6
13:30:00 | 6
15:00:00 | 6
16:30:00 | 6
18:00:00 | 6
19:30:00 | 6
Spreadsheet: 550098d1512103303-auto-sum-data-by-employee-number-from-5-other-sheets-december-2017-att-contest
Sheet: PREPAID -2

WA ID | QUANTITY | POINTS
105499
110895
110944
110985
110991
111066
111173
111181
111400
111746
111780
112264
113576
114344
114354
114674
Spreadsheet: fd99fc64-a359-4cf4-9902-2c93592018a8
Sheet: Sheet1

Battle ID | Date & Time | Side | Victory | Score | Opp. Score | Opp. ID | Opp. Name | Scenario ID | Front | Start Date | End Date | Name EN | Name FR
43932898 | 2014-11-08 17:34:04 | ALLIES | 1 | 7 | 2 | 1339942 | dragoon1983 | 7668 | pacific | 1945-02-26 | 1945-03-06 | The Meat Grinder | Le Hachoir à viande
43933059 | 2014-11-08 17:52:24 | ALLIES | 1 | 7 | 6 | 1167400 | Chenille | 7668 | pacific | 1945-02-26 | 1945-03-06 | The Meat Grinder | Le Hachoir à viande
43933313 | 2014-11-08 18:05:58 | AXIS | 1 | 7 | 4 | 1167400 | Chenille | 7668 | pacific | 1945-02-26 | 1945-03-06 | The Meat Grinder | Le Hachoir à viande
43995533 | 2014-11-12 21:53:21 | ALLIES | 1 | 10 | 7 | 676026 | JJ HOOVER | 7662 | eastern | 1942-10-22 | 1942-10-22 | Red Barricades Factory | Les Barricades Rouges
43995961 | 2014-11-12 22:28:27 | AXIS | 1 | 10 | 7 | 676026 | JJ HOOVER | 7662 | eastern | 1942-10-22 | 1942-10-22 | Red Barricades Factory | Les Barricades Rouges
44008009 | 2014-11-13 20:32:09 | AXIS | 1 | 6 | 5 | 615831 | cedroxx | 12505 | western | 1945-02-17 | 1945-02-20 | Moyland Wood | [NAME]
44008289 | 2014-11-13 20:52:53 | ALLIES | 0 | 4 | 6 | 615831 | cedroxx | 12505 | western | 1945-02-17 | 1945-02-20 | Moyland Wood | [NAME]
44032502 | 2014-11-15 15:37:29 | AXIS | 1 | 10 | 4 | 1221664 | KG Peiper | 7662 | eastern | 1942-10-22 | 1942-10-22 | Red Barricades Factory | Les Barricades Rouges
44033020 | 2014-11-15 16:22:11 | ALLIES | 0 | 3 | 10 | 1221664 | KG Peiper | 7662 | eastern | 1942-10-22 | 1942-10-22 | Red Barricades Factory | Les Barricades Rouges
44083198 | 2014-11-18 21:35:30 | ALLIES | 0 | 3 | 5 | 506159 | Hurletout | 6157 | western | 1944-11-19 | 1944-11-23 | Saverne Gap | [NAME]
44083436 | 2014-11-18 21:52:08 | AXIS | 0 | 4 | 5 | 506159 | Hurletout | 6157 | western | 1944-11-19 | 1944-11-23 | Saverne Gap | [NAME]
44108291 | 2014-11-20 19:39:00 | ALLIES | 1 | 6 | 2 | 1503257 | noixcoco | 6749 | western | 1944-06-06 | 1944-06-06 | [NAME] | [NAME]
44108457 | 2014-11-20 20:09:58 | AXIS | 0 | 5 | 10 | 859507 | banza¡ | 7662 | eastern | 1942-10-22 | 1942-10-22 | Red Barricades Factory | Les Barricades Rouges
Spreadsheet: 45343d1244100880-incrementing-a-cell-contents-by-1-based-on-a-condition-and-previous-value-test
Sheet: Jan

Emp No | ELIGIBLE | Award
EMP1 | Yes | 5
EMP2 | No
EMP3 | Yes | 2
EMP4 | No
EMP5 | Yes | 6
EMP6 | No
EMP7 | No
[NAME] | Yes | 19
EMP9 | No
EMP10 | No
Spreadsheet: 787257d1657707978-help-on-too-many-arguments-on-a-function-of-an-if-function-with-multiple-conditions-invigilation-fees-calculations-september-2020-business-1
Sheet: Sheet3

FRACCISTOWN COLLEGE OF TECHNICAL AND VOCATIONAL EDUCATION
BOTSWANA UNIFIED REVENUE SERVICES- INCOME TAX WITHHELD
OFFICER NAME MMOPI KEOKEDITSWE
MONTHS | 2016-07-15 00:00:00 | 2016-08-15 00:00:00 | 2016-09-15 00:00:00 | 2016-10-15 00:00:00 | 2016-11-15 00:00:00 | 2016-12-15 00:00:00 | 2016-01-16 00:00:00 | 2016-02-16 00:00:00 | 2016-03-16 00:00:00 | 2016-04-16 00:00:00 | 2016-05-16 00:00:00 | 2016-06-16 00:00:00 | 2016-07-16 00:00:00 | TOTAL
BASIC SALARY |  | 7219 | 7219 | 7219 | 7219 | 7219 | 7219 | 7219 | 7219 | 7219 | 7219 | 7219 | 7436
INCOME TAX |  | 327.4 | 327.4 | 327.4 |  | 327.4 | 1149.55 | 327.4 | 584.45 | 327.4 | 327.4 | 851.55 | 354.5
UPKEEPING |  | 200 | 200 | 200 |  | 200 | 200 | 200 | 200 | 200 | 200 | 200 | 200
INCOME TAX
MONTHS | 2016-07-15 00:00:00 | 2016-08-15 00:00:00 | 2016-09-15 00:00:00 | 2016-10-15 00:00:00 | 2016-11-15 00:00:00 | 2016-12-15 00:00:00 | 2016-01-16 00:00:00 | 2016-02-16 00:00:00 | 2016-03-16 00:00:00 | 2016-04-16 00:00:00 | 2016-05-16 00:00:00 | 2016-06-16 00:00:00 | 2016-07-16 00:00:00 | TOTAL
SEVERANCE |  |  |  |  |  |  | 1968.8 |  |  |  |  |  |  |  |  | 2016-11-15 00:00:00 | 2016-12-15 00:00:00 | 2016-01-16 00:00:00 | 2016-02-16 00:00:00 | 2016-03-16 00:00:00 | 2016-04-16 00:00:00 | 2016-05-16 00:00:00 | 2016-06-16 00:00:00 | 2016-07-16 00:00:00 | TOTAL
INCOME TAX
MONTHS | 2016-07-15 00:00:00 | 2016-08-15 00:00:00 | 2016-09-15 00:00:00 | 2016-10-15 00:00:00 | 2016-11-15 00:00:00 | 2016-12-15 00:00:00 | 2016-01-16 00:00:00 | 2016-02-16 00:00:00 | 2016-03-16 00:00:00 | 2016-04-16 00:00:00 | 2016-05-16 00:00:00 | 2016-06-16 00:00:00 | 2016-07-16 00:00:00 | TOTAL
LEAVE DAYS |  |  |  |  |  |  | 4037.7 |  | 1898.7
INCOME TAX
Spreadsheet: 126589d1319759360-tricky-for-me-if-statement-example-book
Sheet: Sheet2

Item # | Sales Units
00-01 Cat | 50
00-02 Dog | 100
00-03 Horse | 18
00-04 Mouse | 155
00-05 Frog | 252
etc.
etc.
etc.
etc.
etc.
etc.
etc.
etc.
etc.
etc.
etc.
etc.
etc.
etc.
etc.
etc.
etc.
etc.
etc.
etc.
etc.
etc.
etc.
etc.
Spreadsheet: 866740d1713634210-return-sum-of-matching-rows-based-on-value-in-column-grouped-by-value-in-another-excel-forum-help-example-2-aligw
Sheet: Sheet1

Account Number | Adjustment Code | Adjustment Description | Adjustment Amount | Patient Payments |  | AliGW
1234 | 1099 | payment (kiosk) | -124.25 | -285.32
1234 | 1005 | pre-payment | -83.05
1234 | 1099 | payment (kiosk) | -78.02
1235 | *Unspecified | *Unspecified | 304
1235 | 5034 | lean | -304
1236 | *Unspecified | *Unspecified | 98
1236 | 5017 | FA | -98
1237 | *Unspecified | *Unspecified | 190 | -25
1237 | 1000 | payment | -25
1238 | *Unspecified | *Unspecified | 314 | -20
1238 | 1099 | payment (kiosk) | -20
1239 | *Unspecified | *Unspecified | 509 | -33.3
1239 | 1099 | payment (kiosk) | -33.3
1240 | *Unspecified | *Unspecified | 243
1240 | 5034 | lean | -50
1241 | *Unspecified | *Unspecified | 311
1242 | *Unspecified | *Unspecified | 177 | -20
1242 | 1099 | payment (kiosk) | -20
1243 | *Unspecified | *Unspecified | 211 | -45
1243 | 1200 | payment (account) | -45
1244 | *Unspecified | *Unspecified | 348 | -41.76
1244 | 1099 | payment (kiosk) | -41.76
1245 | *Unspecified | *Unspecified | 417 | -73.47
1245 | 1099 | payment (kiosk) | -73.47
1246 | *Unspecified | *Unspecified | 433.68
1246 | 5034 | lean | -260.4
1247 | *Unspecified | *Unspecified | 190 | -36.2
1247 | 1099 | payment (kiosk) | -36.2
1248 | *Unspecified | *Unspecified | 275
1249 | *Unspecified | *Unspecified | 305 | -133.03
1249 | 1099 | payment (kiosk) | -133.03
1250 | *Unspecified | *Unspecified | 687
1250 | 5034 | lean | -545.06
1251 | *Unspecified | *Unspecified | 335 | -21
1251 | 1099 | payment (kiosk) | -21
1252 | *Unspecified | *Unspecified | 80 | -32.09
1252 | 1099 | payment (kiosk) | -6.35
1252 | *Unspecified | *Unspecified | 211
1252 | 1099 | payment (kiosk) | -25.74
1253 | *Unspecified | *Unspecified | 783 | -285.32
1253 | 1099 | payment (kiosk) | -124.25
1253 | *Unspecified | *Unspecified | 0
1253 | *Unspecified | *Unspecified | 1015
1253 | 1005 | pre-payment | -83.05
1253 | 1099 | payment (kiosk) | -78.02
1253 | 1099 | payment (kiosk) | -78.02
Spreadsheet: 168101d1342215329-how-to-turn-certain-cells-green-test
Sheet: Sheet1

 | 1'-5 15/16" | 1'-6" | 1'-6 5/16"
 | 1'-5 15/16" | 1'-6" | 1'-6 5/16"*
 | 1'-5 15/16" | 1'-6" | 1'-6 5/16"*
 | 1'-5 15/16" | 1'-6" | 1'-6 5/16"*
 | 1'-5 15/16" | 1'-6" | 1'-6 5/16"*
 | 1'-5 15/16" | 1'-6" | 1'-6 5/16"*
 | 1'-5 15/16" | 1'-6" | 1'-6 5/16"*
 | 1'-5 15/16" | 1'-5 5/16"* | 1'-6"
 | 1'-5 15/16" | 1'-5 5/16"* | 1'-6"
 | 1'-5 15/16" | 1'-5 5/16"* | 1'-6"
 | 1'-5 15/16" | 1'-5 5/16"* | 1'-6"
 | 1'-5 15/16" | 1'-5 5/16"* | 1'-6"
 | 1'-5 15/16" | 1'-5 5/16"* | 1'-6"
 | 1'-5 15/16" | 1'-5 5/16"* | 1'-6"
 | 1'-5 15/16" | 1'-5 5/16"* | 1'-6"
 | 1'-5 15/16" | 1'-5 5/16"* | 1'-6"
 | 1'-5 15/16" | 1'-5 5/16"* | 1'-6"
 | 1'-5 15/16" | 1'-6" | 1'-1 1/4"*
 | 1'-5 15/16" | 1'-6" | 1'-6"
 | 1'-5 15/16" | 1'-6" | 1'-1 1/4"*
 | 1'-5 15/16" | 1'-6" | 1'-1 1/4"*
 | 1'-5 15/16" | 1'-6" | 1'-1 1/4"*
 | 1'-5 15/16" | 1'-6" | 1'-1 1/4"*
 | 1'-5 15/16" | 1'-6" | 1'-1 1/4"*
Spreadsheet: 726776d1617448830-sumifs-function-doesnt-calculate-values-as-expected-accounting-module
Sheet: Monthly Expenses Summary

 | MONTHLY EXPENSES SUMMARY
 | Slicer to filter data by Account Titles is in this cell.
 | G/L Code | Account Title | January | February | March | April | May | June | July | August | September | October | November | December | Total
 | WGL001 | Building Rent
 | WGL002 | Electricity
 | WGL003 | Fuel
 | WGL004 | Internet Charges
 | WGL005 | Mobile Charges
 | WGL006 | Statationery
 | WGL007 | Travelling Costs
 | WGL008 | Marketing
 | WGL009 | Charitables
 | WGL010 | Sponsorships
 | WGL011 | Entertainment
 | WGL012 | Insurance
 | WGL013 | Water Bill
 | WGL014 | Training
 | WGL015
 | WGL016
 | WGL017
 | WGL018
 | Total
Spreadsheet: john_zufferli__16749__Retention 2001
Sheet: Sheet1

Enron Canada
Retention Program
90 Days
U.S. Dollars
Tier 1:
Borg, [NAME] | 150000
Sangwine, [NAME] | 100000
Oh, Grant | 75000
Biever, [NAME] | 50000
[NAME], [NAME] | 50000
Ellis, [NAME] | 50000
Burnham, [NAME] | 40000 | Gross - will need to be prorated
Tripp, Garrett | 40000
Hrap, [NAME] | 35000 | Gross - will need to be prorated
Dorland, [NAME] | 25000
[NAME], [NAME] | 15000 | Gross - will need to be prorated
Savidant, [NAME] | 15000
Lalani, Sean | 7500
Total Tier 1
[NAME]
Kitagawa, [NAME] | 200000
Wilson, Jan | 50000
[NAME], Cyntia | 35000
Sangermano, [NAME] | 10000 | Gross - will need to be prorated
Dunsmore, [NAME] | 5000
LaPorte, [NAME] | 5000
Torres, [NAME] | 5000
[NAME], [NAME] | 5000
[NAME], | 3000 | Gross - will need to be prorated
Cooke, [NAME] | 5000
Total Tier 2
Spreadsheet: 860167d1708368441-create-a-kpi-dashboard-from-multiple-sheets-samplenew
Sheet: Hawaiian Cluster

[NAME] (oz) | Case Weight (lb) | Speed (per min) | Dough Size 1 (lb) | Dough Size 1 (oz) | Theo Units per Dough |  |  |  | Units per case (ea) |  | Cases per Dough
1.2 |  | 45 | 284 |  |  |  |  |  | 288
 |  | 12 Pocket
 |  | 12
Product | Date | Do's ran | Dough Size | Total Weight(lbs) | [NAME] (hrs) | [NAME] | [NAME] | [NAME] | Pack Stop | [NAME] | Total RT | Theo Pieces | Actual Pieces | [NAME] | Total Cases | Extra | Actual Case Yield | Eff % | Waste % | Overall Eff | Units Per Hour
[NAME] | 2024-01-30 00:00:00 | 0 | 0 |  |  | 00:00:00 | 00:00:00 |  | 00:00:00 | ? |  |  |  |  | 0 | 0
[NAME] | 2024-01-31 00:00:00 | 0 | 0 |  |  | 00:00:00 | 00:00:00 |  | 00:00:00 | ? |  |  |  |  | 0 | 0
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  | Average:
Spreadsheet: 672882d1587052609-count-unique-values-with-criterias-test-data
Sheet: Sheet1

Status | Source | Case | Sub
Inactive | LE | Car | Malibu
Active | LE | Color | Red |  | Formula 1 | Self | LE | Internet
Active | Internet | House | Cousin |  |  |  |  |  | =Unique Cases for each Source type (no references to INV1Status column)
Active | Internet | House | Uncle |  |  |  |  |  | =SUM(IFERROR(1/COUNTIFS(Inv1Case,Inv1Case&"",Inv1Source,"Self"),0))
Adjudicated | Internet | House | Aunt
Active | Self | Mountain | Goat |  | Formula 2 | Self | LE | Internet
Warrant | Self | Shoes | [NAME] |  |  |  |  |  | = Count of unique Cases for each Source type that does not include Adjudicated as a Source
Active | Self | Tree | [NAME] |  |  |  |  |  | This formula does not appear to be correct for the two yellow cells.
Adjudicated | Self | Tree | Bear |  |  |  |  |  | =SUMPRODUCT(((Inv1Source="Self")*(Inv1Status="Adjudicated"))/(COUNTIFS(Inv1Case,Inv1Case,Inv1Source,"Self",Inv1Status,"Adjudicated")+(Inv1Source<>"Self")+(Inv1Status<>"Adjudicated")))
 |  |  |  |  |  | Self | LE | Internet | = Count of unique Case for each Source type excluding the Statuses of Adjudicated and Active
 |  |  |  |  |  | 2 | 1 | 0
 |  |  |  |  | 1) Also need to include "Inactive" in Formula 2 so it is excluding along with Adjudicated.
 |  |  |  |  | 2) Is it possible to combine the two [NAME] (or recreate) so all computations occur within one formula?
Spreadsheet: jeff_dasovich__14036__Agro Case Question 3--Jeff revised
Sheet: Sheet1

Question 3
 |  |  |  | AGF INCOME STATEMENT
 |  |  |  |  |  |  |  | 1995
Income from continuing operations ($000) |  |  |  |  |  |  |  | 9500
Discontinued operations:
Estimated future additional uncollectible receivables |  |  |  |  |  |  | 2036
Lossses and write-down of land, building, and equipment
Recorded between measurement date and end of fiscal year |  |  |  |  |  |  | 1465
Estimated further losses in future dispositions |  |  |  |  |  |  | 6868
Costs and expenses related to discontinuance of operations
Incurred between measurement date and end of fiscal year |  |  |  |  |  |  | 2295
Estimated future liquidation costs, including fiscal year 1996 |  |  |  |  |  |  | 2803
Total costs associated with discontinued operations
Less income tax credits |  |  |  |  |  |  | 11028
Total after income credits
Income before unusual items, extraordinary items and effect
of accounting changes:
Unusual loss from government ban of certain preservatives
Cost of inventory write down |  |  |  |  |  |  | 500
Costs associated with switching products |  |  |  |  |  |  | 300
Litigation costs associated with government action |  |  |  |  |  |  | 75
Total losses resulting from government action
Unusual gain from sale of land assets |  |  |  |  |  |  | 750
Unusual loss from settlement associated with consumer class action suit |  |  |  |  |  |  | 250
Net effect of unusual gains and lossesTotal
Income before extraordinary items and effect of accounting changes:
Extraordinary loss due to tornado damage |  |  |  |  |  |  | 135
Income before effect of accounting changes:
Extraordinary gain due to one-time change in accounting principle
associated with depreciation of assets acquired after March 1995 |  |  |  |  |  |  | 200
Net Income
Spreadsheet: 816167d1675411486-formula-to-fill-series-of-weekdays-from-a-starting-date-fill-weekdays-without-weekend
Sheet: Sheet1

 | Start | 2023-08-14 00:00:00 | End | 2023-10-31 00:00:00 | Period
 |  |  |  |  | (14-18 Aug 2023) | (21-25 Aug 2023)
 |  |  | Wrong |  | Required Output
Spreadsheet: 0f4858ce-3944-480a-9233-9fb80c9b3502
Sheet: Sheet1

Table 2--Soybean meal:  U.S. supply and disappearance | Unnamed: 1 | Unnamed: 2 | Unnamed: 3 | Unnamed: 4 | Unnamed: 5 | Unnamed: 6 | Unnamed: 7 | Unnamed: 8 | Unnamed: 9
 | Supply |  |  |  |  | Disappearance
Year beginning | Beginning |  |  |  |  |  |  |  | Ending
October 1 | stocks | Production | Imports | Total |  | Domestic | Exports | Total | stocks
 | 1,000 short tons
2011/12 | 350 | 41025 | 215.807 | 41590.807 |  | 31548.155 | 9742.652 | 41290.807 | 300
2012/131 | 300 | 39950 | 250 | 40500 |  | 29100 | 11100 | 40200 | 300
2013/142 | 300 | 39285 | 165 | 39750 |  | 29950 | 9500 | 39450 | 300
1 Estimated.  2 Forecast.
Source: USDA, World Agricultural Outlook Board, World Agricultural Supply and Demand Estimates.
Last update: | 2013-09-16 10:09:11.290000
Spreadsheet: kate_symes__18452__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-11 00:00:00 |  | 159.09 | 704 | 116 | 2136
 | 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
 | 2000-12-19 00:00:00 |  | 265.68 | 1180 | 201.43 | 280 | 194.39 | 1310 | 178.74 | 855
 | 2000-12-18 00:00:00 |  | 236.9 | 1680 | 190.62 | 960 | 223.03 | 852 | 172.62 | 525
 | 2000-12-17 00:00:00 |  | 215 | 800 | 200 | 200 | 173.03 | 1450 | 148.06 | 1255
 | 2000-12-16 00:00:00 |  | 275 | 480 | 210 | 400 | 183.11 | 2287 | 181.95 | 535
 | 2000-12-15 00:00:00 |  | 275 | 480 | 210 | 400 | 187.75 | 2655 | 153.05 | 1714
 | 2000-12-14 00:00:00 |  | 327.14 | 560 | 226 | 600 | 186.36 | 2035 | 170.6 | 1669
 | 2000-12-13 00:00:00 |  | 497.86 | 448 | 237.79 | 704 | 287.91 | 1278 | 165.71 | 1791
 | 2000-12-12 00:00:00 |  | 342.11 | 1328 | 239.28 | 1064 | 334.23 | 1940 | 165.94 | 1277