tianzl66/Sheetpedia huggingface dataset:
Spreadsheet: 813058d1673522372-extract-values-from-a-text-string-test-data
Sheet: Sheet1

 |  |  | [NAME]'s way |  | TMS way
PRODUCT | LENGTH | WIDTH | LENGTH | WIDTH | LENGTH | WIDTH
SOUNDPRODUCT TE 2400 X 1200 X 12.5 | 2400 | 1200
DURAPRODUCT TE 2400 X1200 X15
BES DURAPRODUCT T/E 2550 X 1200 X 15 1TL
PRODUCTNAME TEN TE 2400 X 1200 X 12.5
PRODUCTNAME SE 2400 X 1200 X 12.5
PRODUCTNAME TE 2400 X 1200 X 12.5
PRODUCTNAME TE 2700 X 1200 X 12.5 | 2700 | 1200
PRODUCTNAME PRODUCX R TE 2400 X 1200 X 9.5
DURAPRODUCT TE 3000 X 1200 X 15
PRODUCTNAME TE 1800 X 900 X 12.5 | 1800 | 900
PRODUCTNAME SE 1800 X 900 X 9.5
BES PRODUCTNAME TEN T/E 2700 X 1200 X 12.5
DPR Prodex T/E 2700 X 1200 X 15
SOUNDPRODUCT F 3000 X 1200 X 15 TE 1TL
PRODUCTNAME TE 2400 X 900 X 12.5
BES DURAPRODUCT T/E 2750 X 1200 X 15
BES DURAPRODUCT T/E 1925 X 1200 X 15
BES SOUNDPRODUCT T/E 2730 X 1200 X 15 NEW
BES SOUNDPRODUCT T/E 2760 X 1200 X 12.5
Spreadsheet: 25584d1216940278-split-large-spreadsheet-into-multiple-files-example
Sheet: Sheet1

Category | A | B | C | D | …etc
1
1
1
1
1
1
2
2
2
2
2
2
2
2
2
2
2
2
2
2
2
2
2
2
3
3
3
3
4
4
4
4
4
4
4
…etc
Spreadsheet: 484339d1476216661-sumproduct-with-other-sheets-and-criteria-sumproduct-with-criteria
Sheet: Sheet1

 |  |  |  | Example 1
 |  |  |  | M5 | date chosen
 |  |  |  |  |  | Summary | M1 | M2 | M3 | M4 | M5 | M6 | M7 | M8 | M9 | M10 | M11 | M12
 |  |  |  |  |  |  |  | 3
 |  |  |  |  | A1 |  | 10 |  | 456 |  | 65423 |  |  | 45
 |  |  |  |  | A2 |  | 5 | 24 |  |  | 54564 | 56 |  | 5956 |  |  | 8
 |  |  |  |  | A3 |  | 2 |  |  |  |  | 3 |  | 6 | 2
 |  |  |  |  | A4 |  | 20 | 234 | 34234 | 4 | 5 |  | 5 |  |  |  | 56
 |  |  |  |  | A5 |  | 304 |  |  |  |  | 4 |  | 4 | 5
 |  |  |  |  | A6 |  | 405 |  |  | 53 |  | 4 |  | 5
 |  |  |  |  | A7 |  | 435 | 3243 |  |  |  | 678 |  |  | 867
 |  |  |  |  | A8 |  | 45 |  |  | 768 | 67 | 7
 |  |  |  |  | A9 |  |  |  |  |  | 234 |  |  | 7756454
 |  |  |  |  | A10 |  | 78 | 67 |  |  |  |  | 234 |  | 234
 |  |  |  |  | A11 |  | 67 |  |  | 34 |  |  |  | 234 |  | 435
 |  |  |  |  | A12 |  |  | 173 | 45 | 5856 |  | 738 |  | 358 | 56
 |  |  |  |  |  | So this formula (=(SUMPRODUCT(($H$4:$S$4<=$E$2)*(H7:S7)))) is good when [NAME] to A12 is static….however it keeps changing the order
 |  |  |  | Example 2
 |  |  |  |  | Dynamic now
 |  |  |  |  | Areas | Summary | M1 | M2 | M3 | M4 | M5 | M6 | M7 | M8 | M9 | M10 | M11 | M12
 |  |  |  |  | A1 |  | 10 |  | 456 |  | 65423 |  |  | 45
 |  |  |  |  | A10 |  | 78 | 67 |  |  |  |  | 234 |  | 234
 |  |  |  |  | A8 |  | 45 |  |  | 768 | 67 | 7
 |  |  |  |  | A3 |  | 2 |  |  |  |  | 3 |  | 6 | 2
 |  |  |  |  | A6 |  | 405 |  |  | 53 |  | 4 |  | 5
 |  |  |  |  | A12 |  |  | 173 | 45 | 5856 |  | 738 |  | 358 | 56
 |  |  |  |  | A5 |  | 304 |  |  |  |  | 4 |  | 4 | 5
 |  |  |  |  | A9 |  |  |  |  |  | 234 |  |  | 7756454
 |  |  |  |  | A7 |  | 435 | 3243 |  |  |  | 678 |  |  | 867
 |  |  |  |  | A11 |  | 67 |  |  | 34 |  |  |  | 234 |  | 435
 |  |  |  |  | A4 |  | 20 | 234 | 34234 | 4 | 5 |  | 5 |  |  |  | 56
 |  |  |  |  | A2 |  | 5 | 24 |  |  | 54564 | 56 |  | 5956 |  |  | 8
 |  |  |  |  |  | So basically trying to create the same formula but based also on which "Areas" is chosen
 |  |  |  |  |  | so in tab sheet 2 …the grey area is what info I really want and care about
Spreadsheet: 164257d1340713870-need-to-find-column-matches-and-total-values-from-corresponding-rows-rowmatch_c
Sheet: Sheet1

 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | Yield | Yield |  |  |  | Commission
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | % | Total
 |  |  |  |  |  |  |  | CC | PG |  | FTR |  | 6.25 | 0.16 | -- | -0.04370487333550614 | --
 |  |  |  |  |  |  |  | CC | PG |  | FTR |  | 3.5 | 0.2857142857142857 | -- | -0.07785827071638099 | -- |  |  |  | 0.05
 |  |  |  |  |  |  |  | CC | PG |  | FTR |  | 1.6667 | 0.5999880002399952 | -0.04570228595428105 | -0.04370487333550601 | -0.05546039949167381
 |  |  |  |  |  |  |  | SN | FN |  | FTR |  | 1.83 | 0.5464480874316939 | -- | -0.02494766070592522 | --
 |  |  |  |  |  |  |  | SN | FN |  | FTR |  | 3.5 | 0.2857142857142857 | -- | -0.02494766070592533 | --
 |  |  |  |  |  |  |  | SN | FN |  | FTR |  | 5.17 | 0.1934235976789168 | -0.02558597082489644 | -0.0642703711010538 | -0.03319191094000839 |  |  |  | 0.05
 |  |  |  |  |  |  |  | CC | PG |  | UO |  | 1.95 | 0.5128205128205129 | -- | -0.0006250000000000545 | --
 |  |  |  |  |  |  |  | CC | PG |  | UO |  | 2.05 | 0.4878048780487805 | -0.000625390869293474 | -0.00062500000000011 | -0.0006253908692933901
 |  |  |  |  |  |  |  | LM | DN |  | TQ |  | 4.3 | 0.2325581395348837 | -- | 0.03542996768345549 | --
 |  |  |  |  |  |  |  | LM | DN |  | TQ |  | 3.25 | 0.3076923076923077 | -- | 0.03542996768345558 | --
 |  |  |  |  |  |  |  | LM | DN |  | TQ |  | 2.35 | 0.425531914893617 | 0.03421763787919163 | 0.03542996768345563 | 0.03421763787919164
 |  |  |  |  |  |  |  | MT | MC |  | DC |  | 1.5 | 0.6666666666666666 | -- | -0.06962025316455694 | --
 |  |  |  |  |  |  |  | MT | MC |  | DC |  | 2.45 | 0.4081632653061224 | -0.07482993197278898 | -0.09715189873417716 | -0.08606733832773612 |  |  |  | 0.05
 |  |  |  |  |  |  |  | MT | MC |  | FTR |  | 2.35 | 0.425531914893617 | -- | -0.005335230304108179 | --
 |  |  |  |  |  |  |  | MT | MC |  | FTR |  | 3.5 | 0.2857142857142857 | -- | -0.005335230304108345 | --
 |  |  |  |  |  |  |  | MT | MC |  | FTR |  | 3.4 | 0.2941176470588235 | -0.005363847666726373 | -0.005335230304108179 | -0.005363847666726365
 |  |  |  |  |  |  |  |  |  |  |  |  |  | -- | -- | #N/A | --
 |  |  |  |  |  |  |  |  |  |  |  |  |  | -- | -- | #N/A | --
 |  |  |  |  |  |  |  |  |  |  |  |  |  | -- | -- | #N/A | --
 |  |  |  |  |  |  |  |  |  |  |  |  |  | -- | -- | #N/A | --
 |  |  |  |  |  |  |  |  |  |  |  |  |  | -- | -- | #N/A | --
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 0.84 | 1.205702285954281 | 1.045702285954281
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  | -0.3497193138681441
Spreadsheet: eric_saibi__9813__9-24-01
Sheet: Deals

Deal_id | Flow Date | CP | Volume | Price | Start Hr | End Hr | Trans
 |  | Mirant Call | -50 |  | 8 | 24
758660.15 | 2001-09-24 00:00:00 | Enron Call | -100 |  | 7 | 22
784524.1 | 2001-09-24 00:00:00 | [NAME] | 30 | 20.5 | 4 | 6
784524.1 | 2001-09-24 00:00:00 | [NAME] | 35 | 20.5 | 7 | 7
784524.1 | 2001-09-24 00:00:00 | [NAME] | 50 | 20.5 | 8 | 22
784524.1 | 2001-09-24 00:00:00 | [NAME] | 85 | 20.5 | 23 | 24
785255.1 | 2001-09-24 00:00:00 | EPMI-ST-ERCOT | -50 | 20.5 | 7 | 22
785698.1 | 2001-09-24 00:00:00 | ERCOT-IMBALANCE | -30 | 0 | 4 | 6
785698.1 | 2001-09-24 00:00:00 | ERCOT-IMBALANCE | -85 | 0 | 23 | 24
785699.1 | 2001-09-24 00:00:00 | ERCOT-IMBALANCE | 15 | 0 | 7 | 7
Spreadsheet: mary_fischer__25429__Desert Sky Log May '02
Sheet: GRID

DESERT SKY
GRID VARIANCE
 |  |  |  | Chargeable to: A=AEP, N=Force Majeure, E=Enron, T= TXU
Month: | May '02 |  |  | Reason: U=unscheduled outage, S= scheduled outage, F=fluctuation
Charge | Date off | Time off | Date on | Time on | Hrs. | Reason | Comments
E | 2002-05-07 00:00:00 | 09:57 | 2002-05-07 00:00:00 | 10:15 | 0.26 | S | Change taps on 138kV transformer.
Spreadsheet: 850135d1700515137-wrong-sum-up-values-from-a-range-with-xlookup-and-index-match-formula-overtime-blank-format-2017-2-
Sheet: AUTHORIZATION (3)

King Fahd Armed Forces Hospital, Jeddah
مستشفى الملك فهد لللقوات المسلحة بجدة
FINANCE DEPARTMENT
[NAME]
OVERTIME AUTHORIZATION & CONTROL FORM
نموذج تصريح و مراقبة التكليف بالعمل الاضافي
 | Department Name / اسم القسم |  |  |  | Human Resource |  |  |  |  |  |  |  |  | 4701 |  |  |  |  |  |  |  |  |  | Dept. No. / رقم القسم |  |  |  |  |  |  |  | 4701
 | Pay Period Ending / الدفع نهاية الفترة |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 11
# | Emp. # | Employee Name |  |  | 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 | Total | Employee Signature
 | [NAME] | اسم الموظف |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | الإجمالى | توقيع الموظف
1 | 7004 |  |  |  |  |  |  | 3 | 3 | 3 |  | 2 |  | 2 | 2 | 3 | 1 | 3 | 1 |  | 4 | 1 | 3 | 1 | 3 | 2 |  | 4 | 1 | 1 | 1 | 3 | 1
2 | 9089 | [NAME] |  |  |  |  |  | 1 |  | 1 | 1 | 1 |  |  | 1 |  | 1 | 1
3 | 17488 |  |  |  | 2 |  |  |  |  |  |  |  |  | 4 |  | 1 |  |  |  |  |  | 2 |  |  |  |  |  | 3 | 1 | 1
4 | 17523 | KHALID [NAME] |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 8 | 3 | 1 | 2 | 2 | 2 | 2 | 3 |  | 2 |  | 2 | 3 | 1
5 | 4192 |  |  |  |  |  |  | 3 | 3 | 3 |  |  |  |  | 2 | 3 | 3 | 1 | 1 |  |  | 3 | 3 |  | 3 | 3 |  | 5 | 3 | 3 | 0 | 3 | 5
6 | 8363 |  |  |  |  |  |  | 3 | 3 | 3 |  |  |  |  | 3 | 3 | 3 | 3 |  |  | 8 | 3 | 3 | 3 | 3 | 3 |  | 6 | 2 | 4 | 3 | 3 | 3
7 | 13846 | JEFFERSON DALUSON |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 3 |  |  | 8 | 3 | 2 | 3 | 3 | 3 |  | 8 | 3 |  | 3 |  | 3
8 | 14118 |  |  |  |  |  |  | 3 | 3 | 3 |  |  |  |  | 3 | 3 | 3 | 3 | 2 |  | 7 | 3 | 3 | 3 | 3 |  |  | 8 | 2 | 2 | 2 | 2 | 2
9 | 14714 |  |  |  |  |  |  | 3 | 3 | 3 |  |  |  |  | 3 | 3 | 3 | 3 |  |  | 8 | 3 | 3 | 3 | 3 | 2 |  |  | 3 | 3 | 3 | 3 | 3
10 | 14994 |  |  |  |  |  |  | 3 | 3 | 3 |  |  |  |  | 3 | 3 | 3 | 3 |  |  | 8 | 3 | 3 | 3 | 3 | 3 |  | 8 | 3 | 3 | 3 | 3 | 3
11 | 16537 | NESVAN JOY SARMIENTO |  |  |  |  |  | 3 | 3 | 3 |  |  |  |  | 3 | 3 | 3 | 2 |  |  |  | 3 | 3 | 3 | 2 | 2 |  | 5 | 3 | 3 |  | 3
12
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | Total Overtime Hour
 |  |  | Signature / توقيع |  |  |  |  |  |  |  |  |  |  | Approved by  /  الموافقة من |  |  |  |  |  |  |  |  |  |  |  |  |  |  | Certified by / مصدقة من
 |  |  | Department Head |  |  |  |  |  |  |  |  |  | Finance Director |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | Hospital Director
 |  |  | رئيس القسم |  |  |  |  |  |  |  |  |  | مدير [NAME] |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | مدير المستشفى
Spreadsheet: 104008d1301631742-index-match-and-duplicates-top-5
Sheet: Sheet3

Rules | Total | Ongoing | Closed Out
1 For All Work | 50 | 46 | 4
2 Cranes and Lifting | 1 | 1 | 0
3 Working at Height | 1 | 1 | 0
4 Working Near Mobile Plant | 3 | 3 | 0
5 Operating Mobile Plant | 1 | 1 | 0
6 Driving Vehicles | 6 | 6 | 0
7 Working on Energised Equipment | 1 | 1 | 0
8 Working with Electricity | 2 | 1 | 1
9 Trenching | 1 | 1 | 0
10 Working in Confined Space | 2 | 2 | 0
Top 5
Rule | Rank
Spreadsheet: 175711d1345625982-ignore-blank-cells-ef171_ignore-blank-cells
Sheet: Recap

Cost of Sale | Hours | Amount | FICA | Medicare | FUTA | SUTA - 3.2% plus Interest  @ $12.12 Each Employee over $13,000 | Group Ins @  % of Cost | W/C | Total
Spreadsheet: 767873d1644685652-having-trouble-coming-up-with-combination-lookup-value-based-on-rank-result-2021-auto-update-test
Sheet: TOURNEY4

ROCKY FORK LAKE - June 13th, 2021
ANGLER | FISH CT. | WGTS. LBs | BIG BASS | PLACED
 | 3 | 4.74 | 2.32
 | 3 | 3.82 | 0
 | 5 | 7.78 | 2.55
 | 3 | 3.74 | 0
 | 1 | 0.81 | 0
 | 4 | 4.4 | 0
 | 0 | 0 | 0
 | 5 | 4.85 | 0
 | 0 | 0 | 0
 | 0 | 0 | 0
 | 5 | 6.14 | 1.6
 | 2 | 2.51 | 0
 | 0 | 0 | 0
 | 1 | 1.83 | 0
 | 0 | 0 | 0
 | 0 | 0 | 0
 | 0 | 0 | 0
 | 0 | 0 | 0
 | 0 | 0 | 0
 | 0 | 0 | 0
Spreadsheet: 747097d1631218365-calculate-multiple-data-input-without-duplicates-excel-forum-tms
Sheet: Sheet1

Workcenter / Job# | Location
10-21251 | RIVER COMPLEX |  |  |  |  |  | 30- | 70- | 80-
10-21251 | RIVER COMPLEX |  | 10-21252 | 1
10-21251 | RIVER COMPLEX |  | 10-21253 | 1 |  | 2021 RSF SEVERITY | CALDOR | 2021 RMA PREPO | CALDOR
10-21251 | RIVER COMPLEX |  | 10-21254 | 1 |  | CALDOR | DEVILS KNOB COMPLEX | DEEP CREEK CANYON | FOX COMPLEX
10-21252 | 2021 RSF SEVERITY |  | 10-21255 | 1 |  | FOX COMPLEX | FORD CORKSCREW | OIL SPRINGS | PATTON MEADOW
10-21253 | FOX COMPLEX |  | 10-21256 | 1 |  | RIVER COMPLEX | GREEN RIDGE | RED ROCK | RIVER COMPLEX
10-21254 | 2021 RSF ABCD MISC. |  | 30-21231 | 3 |  |  |  | WILLOW CREEK
10-21255 | RIVER COMPLEX |  | 30-21232 | 1
10-21256 | CALDOR |  | 30-21233 | 1
30-21231 | BLACK BUTTE |  | 30-21234 | 1
30-21231 | BLACK BUTTE |  | 30-21235 | 1
30-21231 | BLACK BUTTE |  | 70-21082 | 1
30-21232 | GREEN RIDGE |  | 70-21083 | 1 |  | G1: | =COUNTA(G3#) |  |  | copied across
30-21233 | FORD CORKSCREW |  | 70-21084 | 1 |  | G2: | =TRANSPOSE(UNIQUE(LEFT($A$2:$A$30,3)))
30-21234 | DEVILS KNOB COMPLEX |  | 70-21085 | 1 |  | G3: | =SORT(UNIQUE(FILTER($B$2:$B$30,LEFT($A$2:$A$30,3)=G2))) |  |  | copied across
30-21235 | CALDOR |  | 70-21086 | 1
70-21082 | WILLOW CREEK |  | 70-21087 | 1
70-21083 | DEEP CREEK CANYON |  | 80-21241 | 1
70-21084 | OIL SPRINGS |  | 80-21242 | 1
70-21085 | RED ROCK |  | 80-21243 | 1
70-21086 | 2021 RMA PREPO |  | 80-21244 | 1
70-21087 | 2021 NRGA FIRE SUPPORT |  | 80-21245 | 1
80-21241 | CALDOR |  | 80-21246 | 1
80-21242 | PATTON MEADOW |  | 80-21247 | 1
80-21243 | 2021 RSF SEVERITY
80-21244 | FOX COMPLEX
80-21245 | RIVER COMPLEX
80-21246 | PATTON MEADOW
80-21247 | CALDOR
Spreadsheet: 840401d1692712802-how-can-i-condense-a-list-of-scattered-names-in-a-column-test103
Sheet: Sheet1

our cutomers | Govt List
118 PRINT & DESIGN LIMITED | 10 Motives Ltd |  |  |  | 151 Products Ltd
151 Products Ltd | 151 Products Ltd |  |  |  | 3V Natural FoodsLtd
17MCC | 2K Polymer Systems Ltd |  |  |  | A.E.Rodda & Sons Ltd
19 LTD | 2M Holdings Ltd
1st CLASS PACKAGING LTD | 3M UK Holdings Ltd
2000 TEST EQUIPMENT | 3V Natural Foods Ltd
266 WINES | 4 Degreesc Ltd
2 Co Ltd | 3D Displays Ltd.
2 Recycling Ltd | A & J Scott Ltd
2 SISTERS FOOD GROUP LTD | A 2 C Services Ltd
3A MANUFACTURING LTD | A B LEWIS LTD
3B Design & Print | A H Worth Ltd
3B-IT LTD | A J Webb & Son (Sheffield) Ltd
3V Natural Foods Ltd | A Nelson & Co Ltd
3G Technologies Ltd | A P Taylor Ltd
3P DIRECT | A S Green Ltd
3S SIGNS | [NAME] Gainsborough Ltd
40 DEGREES | A. Schulman Thermoplastic Compounds Ltd
471 PRINT & PROMOTIONS LTD | [NAME] (Drums) Ltd
47 PRINT PARTNERSHIP LIMITED | A.B. PRODUCE PLC
53 North Aviation Ltd | A.B.M. Catering Ltd
5 A DAY BOX | A.C. Worldwide Group Ltd
A.E. Rodda & Son Ltd | A.E. Rodda & Son Ltd
A&A MARKETING | A.E. Rodda & Son Ltd
A & A PACKAGING COMPANY | A.E.Adams(Henfield)Ltd
A&C FOODS LTD | A.E.S. Engineering Ltd
A&E SUPPLIES | A.F.BLAKEMORE AND SON LTD
 | A NILES  T/A EMPRESS LUXURIES
Spreadsheet: 785960d1656871356-add-the-text-from-one-cell-if-the-cell-preceeding-it-contains-specific-text-sso-2023-katnjas-
Sheet: Sheet1

 | Instruction | Selection | Grid Line 2 | Grid Line 3 | Grid Line 4 | Grid Line 5 | Grid Line 6 | Grid Line 7 | Reserve Choice 1 | Reserve Choice 2 | Reserve Choice 3
 |  | VET Pathway
 | Grid Line 2 | Career and Enterprise General
 | Grid Line 3 | *Mathematics Essentials - General
 | Grid Line 4 | English - General
 | Grid Line 5 | Visual Arts – General
 | Reserve Subjects for VET | *Design General: Fashion
 | Reserve Subjects for VET | Visual Arts – General
 | Reserve Subjects for VET | Business Management and Enterprise - General
 |  | [NAME]
 | Grid Line 2 | *Biology – ATAR
 | Grid Line 3 | *Accounting and Finance - ATAR
 | Grid Line 4 | Economics – ATAR
 | Grid Line 5 | *Mathematics Applications – ATAR
 | Grid Line 6 | Politics and Law - ATAR
 | Grid Line 7 | English - ATAR
 | Choose three reserve subjects | *Human Biology – ATAR
 | Choose three reserve subjects | *Physical Education Studies - General
 | Choose three reserve subjects | Visual Arts – ATAR
 |  | General [NAME]
 | Grid Line 2 | English - General
 | Grid Line 3 | Certificate II Sport Coaching
 | Grid Line 5 | *Accounting and Finance - General
 | Grid Line 6 | *Materials Design and Technology Metal – General
 | Grid Line 7 | Visual Arts – ATAR
 | Choose three reserve subjects | Certificate II Engineering
 | Choose three reserve subjects | *Physical Education Studies - General
 | Choose three reserve subjects | *Mathematics Applications – ATAR
Spreadsheet: 881177d1729101031-financial-forecasting-spreadsheet-financial-forecast_sheet
Sheet: AR

JOB NO | CUSTOMER ID | Invoiced Date | Price Total | Customer Terms | Average Days to pay
417523 | 200068 | 2011-01-13 00:00:00 | 9000 | Net 60 | 72
417527 | 200068 | 2016-11-17 00:00:00 | 150000 | Net 60 | 72
417528 | 200005 | 2016-11-19 00:00:00 | 2500 | Net 90 | 95
417539 | 200005 | 2016-11-19 00:00:00 | 2000 | Net 90 | 95
417536 | 200017 | 2016-11-19 00:00:00 | 80000 | Net 30 | 40
417534 | 200027 | 2016-11-19 00:00:00 | 30000 | Net 90 | 95
417532 | 200036 | 2016-11-19 00:00:00 | 10000 | Net 90 | 95
417533 | 200036 | 2016-11-19 00:00:00 | 10500 | Net 90 | 95
417530 | 200046 | 2016-11-19 00:00:00 | 9000 | Net 60 | 65
417531 | 200046 | 2016-11-19 00:00:00 | 10000 | Net 60 | 65
417535 | 200046 | 2016-11-19 00:00:00 | 20000 | Net 60 | 65
417537 | 200068 | 2016-11-19 00:00:00 | 60000 | Net 60 | 72
417538 | 200068 | 2016-11-19 00:00:00 | 80000 | Net 60 | 72
417526 | 200071 | 2016-11-19 00:00:00 | 90000 | Net 90 | 102
417529 | 200046 | 2016-11-20 00:00:00 | 6000 | Net 60 | 65
417525 | 200071 | 2016-12-09 00:00:00 | 25000 | Net 90 | 102
417540 | 200067 | 2017-01-18 00:00:00 | 25000 | Net 45 | 60
417524 | 200076 | 2017-01-20 00:00:00 | 1000 | Net 120 | 125
417542 | 200089 | 2017-02-27 00:00:00 | 15000 | Net 45 | 35
417541 | 200068 | 2019-02-27 00:00:00 | 20000 | Net 60 | 72
Spreadsheet: 809487d1671113875-somewhat-simple-formula-help-needed-simple-formula-ans
Sheet: Sheet1

 | q | w | e |  |  | q | w | e
a | 1 | 2 | 3 |  |  | 2 | 3 | 4
s | 3 | 4 | 1
a | 5 | 5 | 5
a
Spreadsheet: 119208d1314270538-duplicate-name-generation-duplicate-name-generation-modified-by-tigeravatar-
Sheet: Sheet1

Name | Duplicate count formula |  | Name without duplicate and blank row
Accession | 1 | Accession |  | [NAME] is required in column No.F
APJ print world | 1 | APJ print world |  | In Column F blank should not be there, [NAME] name should there without any blank
Brainy Bytes | duplicate
Creative Enterprises | dupicate
Digital park | dupicate
Brainy Bytes | 1 | Brainy Bytes
Creative Enterprises | 1 | Creative Enterprises
Digital park | 1 | Digital park
Spreadsheet: 482963d1475394052-calculate-the-growth-book2
Sheet: Sheet1

Member | Value | Growth | Growth Increase | Growth Decrease
G0857175P | 30
G0857175P | 50 | 20 | 1.66
S8774172I | 30
S8774172I | 150 | 120 | 5
S8734024D | 30
S2699705D | 55
S8026058Z | 25
S8026058Z | 20 | -5 |  | 0.2
Spreadsheet: 40183794-3691-475d-88f9-7006aaa38bb1
Sheet: Sheet1

Table 7--U.S. textile exports, by fiber | Unnamed: 1 | Unnamed: 2 | Unnamed: 3 | Unnamed: 4 | Unnamed: 5
 | Dec. | Jan. | Feb. |  | Feb.
Item | 2012 | 2013 | 2013 |  | 2012
 | 1,000 pounds 1/
[NAME], thread, and fabric: | 199259.183 | 222045.978 | 232166.567 |  | 239435.037
Cotton | 106821.974 | 117057.553 | 125091.201 |  | 126828.246
Linen | 5177.486 | 6127.057 | 6454.416 |  | 6881.516
Wool | 1935.277 | 2271.756 | 2237.92 |  | 2735.883
Silk | 949.171 | 994.378 | 935.661 |  | 958.018
Manmade | 84375.275 | 95595.234 | 97447.369 |  | 102031.374
Apparel: | 23000.191 | 24653.719 | 25407.089 |  | 24288.767
Cotton | 9743.796 | 10788.375 | 10968.529 |  | 10894.415
Linen | 398.307 | 401.518 | 426.099 |  | 453.432
Wool | 1339.082 | 1271.716 | 1402.397 |  | 1233.596
Silk | 1256.69 | 1127.073 | 1346.992 |  | 1082.783
Manmade | 10262.316 | 11065.037 | 11263.072 |  | 10624.541
Home furnishings: | 5040.561 | 4376.311 | 3754.612 |  | 4766.956
Cotton | 2294.028 | 2140.089 | 1745.772 |  | 2385.875
Linen | 319.029 | 216.373 | 185.152 |  | 153.785
Wool | 213.261 | 157.312 | 149.124 |  | 95.997
Silk | 218.306 | 147.514 | 114.085 |  | 95.849
Manmade | 1995.937 | 1715.023 | 1560.479 |  | 2035.45
Floor coverings: | 29988.803 | 28954.466 | 29334.878 |  | 32686.538
Cotton | 2231.594 | 1985.339 | 1958.567 |  | 1921.411
Linen | 1176.003 | 972.227 | 896.93 |  | 891.041
Wool | 3101.786 | 2882.906 | 2714.771 |  | 3204.372
Silk | 33.094 | 17.464 | 46.646 |  | 20.016
Manmade | 23446.326 | 23096.53 | 23717.964 |  | 26649.698
Total exports: 2/ | 257391.037 | 280137.87 | 290766.7120000001 |  | 301273.306
Cotton | 121170.056 | 132055.015 | 139842.121 |  | 142096.08
Linen | 7070.825 | 7717.176 | 7962.596 |  | 8379.774
Wool | 6593.564 | 6585.414 | 6507.678 |  | 7273.767
Silk | 2457.261 | 2286.428 | 2443.385 |  | 2156.665
Manmade | 120099.331 | 131493.837 | 134010.932 |  | 141367.02
1/ Raw-fiber equivalent.  2/ Includes headgear.
Sources: USDA, Economic Research Service; and
U.S. Dept. of Commerce, U.S. Census Bureau.
Last update: 04/12/13.
Spreadsheet: 861074d1709056516-pulling-text-from-a-cell-to-look-at-a-sheet-testing-file2
Sheet: Main

Names | Amount | date | color
[NAME]
[NAME]
[NAME]
[NAME]
Zach
Spreadsheet: 146465d1332190280-combine-comments-from-four-tabs-into-one-column-inspection_tests
Sheet: All

E | EQUIP_NO | DSTRCT_CODE | EQUIP_GRP_ID | Defect Priority | Comment | Assessment
LPN | [PHONE] | 0002 | LINKBOX | C5 - VERY HIGH
LPN | [PHONE] | 0002 | LINKBOX | C5 - VERY HIGH
LPN | [PHONE] | 0002 | LINKBOX | C5 - VERY HIGH
LPN | [PHONE] | 0002 | LINKBOX | C5 - VERY HIGH
LPN | [PHONE] | 0002 | LINKBOX | C5 - VERY HIGH
LPN | [PHONE] | 0002 | LINKBOX | C5 - VERY HIGH
LPN | [PHONE] | 0002 | LINKBOX | C5 - VERY HIGH
LPN | [PHONE] | 0002 | LINKBOX | C5 - VERY HIGH
LPN | [PHONE] | 0002 | LINKBOX | C5 - VERY HIGH
LPN | [PHONE] | 0002 | LINKBOX | C5 - VERY HIGH | Change
LPN | [PHONE] | 0002 | LINKBOX | C5 - VERY HIGH | Change
LPN | [PHONE] | 0002 | LINKBOX | C5 - VERY HIGH | Change
LPN | [PHONE] | 0002 | LINKBOX | C5 - VERY HIGH | No Defect
LPN | [PHONE] | 0002 | LINKBOX | C5 - VERY HIGH
LPN | [PHONE] | 0002 | LINKBOX | C5 - VERY HIGH | Change
LPN | [PHONE] | 0002 | LINKBOX | C5 - VERY HIGH | Change
LPN | [PHONE] | 0002 | LINKBOX | C5 - VERY HIGH | No Defect
LPN | [PHONE] | 0002 | LINKBOX | C5 - VERY HIGH
LPN | [PHONE] | 0002 | LINKBOX | C5 - VERY HIGH
LPN | [PHONE] | 0002 | LINKBOX | C5 - VERY HIGH | No Defect
LPN | [PHONE] | 0002 | LINKBOX | C5 - VERY HIGH | Maintenance
LPN | [PHONE] | 0002 | LINKBOX | C5 - VERY HIGH | No Defect
LPN | [PHONE] | 0002 | LINKBOX | C5 - VERY HIGH
LPN | [PHONE] | 0002 | LINKBOX | C5 - VERY HIGH | No Defect
LPN | [PHONE] | 0002 | LINKBOX | C5 - VERY HIGH | Change
LPN | [PHONE] | 0002 | LINKBOX | C5 - VERY HIGH
LPN | [PHONE] | 0002 | LINKBOX | C5 - VERY HIGH | Change
LPN | [PHONE] | 0002 | LINKBOX | C5 - VERY HIGH
LPN | [PHONE] | 0002 | LINKBOX | C5 - VERY HIGH | Change
Spreadsheet: 38769d1236901270-sum-multiple-criteria-with-unique-value-example2
Sheet: Sheet5

 |  | Ticket Number | Service Type | Charge
 |  | 252 | Service | 40
 |  |  | Retail | 33
 |  | 253 | Service | 162
 |  |  | Retail | 73
 |  |  | Retail | 69
 |  | 255 | Retail | 175
 |  |  | Service | 168
 |  |  | Service | 103
 |  | 258 | Service | 62
 |  | 258 | Retail | 127
 |  |  | Retail | 51
 |  |  | Service | 55
 |  |  | Service | 78
 |  |  | Service | 92
 |  |  | Service | 95
 |  |  | Revenue | Transactions
 |  | Retail
 |  | Service
 |  | Retail & Service