tianzl66/Sheetpedia huggingface dataset:
Spreadsheet: 1f7df3c1-ca37-4456-b394-b5b43ffa6166
Sheet: $ by fund - serials

Total Serials Expenditures FY09 and FY10
Fund code | Fund | FY09 | FY010 | % change | % of total FY10 expend.
aafp | Afro/Amer St serial | 323.46 | 194.01
artp | Art serials | 4165.31 | 4618.68
biop | Biology serials | 95064.4 | 91371.22
bmmp | [NAME] serials | 26501.46 | 25393.74
bpsp | Biopharmacy serials | 30048.94 | 27664.5
busp | Business serials | 14704.52 | 14006.77
ccep | CCE serials | 4194.3 | 4460.97
ceep | CCE E-journals | 623.61 | 616.07
[NAME] | Chem Engin. serials | 11915.13 | 12499.92
chmp | Chemistry serials | 19243.25 | 19982.02
cmdp | [NAME] serial | 5474.98 | 5594.29
coep | [NAME] serial | 0 | 0 | 0
comp | Comm Studies serial | 2374.37 | 2574.73
cplp | Com Planning serial | 6460.96 | 4997.4
cscp | [NAME] serial | 2862.21 | 3011.45
cvep | Civil Engin serials | 13845.98 | 15285.01
ecnp | Economics serials | 6391.24 | 5331.99
edcp | Education serials | 12035.25 | 12399.66
elep | Elec Engin serials | 1727.77 | 1710.65
engp | English serials | 6910.41 | 5438.84
feep | [NAME] (HELIN membership) | 63442.65 | 61112.92
flmp | Film Studies serial | 567.12 | 624.45
fstp | Fisheries serials | 2978.4 | 3168.15
[NAME] | Geology Serials | 11658.7 | 9338.31
hdfp | Hum Dev Fam serials | 5667.11 | 4051.69
hisp | History serials | 4441.16 | 4112.29
hltp | Gen Health serials | 348.16 | -43.67
imep | Indus Engin serials | 11476.7 | 12068.4
jorp | Journalism serials | 0 | 643.87 | n/a
kinp | Kinesiology serials | 6416.4 | 5837.65
lanp | Languages serials | 16741.17 | 17437.23
lrsp | Labor Relat serials | 5442.19 | 5813.59
[NAME] | [NAME] serials | 6823.48 | 8675.02
mafp | Marine Aff serials | 12505.04 | 11615.66
mcep | Mech Engin serials | 6321.3 | 4663.09
mthp | Mathematics serials | 11595.1 | 10551.59
musp | Music serials | 1962.43 | 1858.46
nfsp | Nut/Food Sci Serial | 15377.13 | 16394.73
nrsp | Nat Resource serial | 3331.25 | 3472.54
nurp | Nursing serials | 20296.63 | 19825.63
ocep | Ocean Engin serials | 353.91 | 353.91
peep | [NAME] E-journals | 70568.92 | 94234.69
pelp | [NAME] serials | 27264.41 | 10536.48
phlp | Philosophy serials | 1679.25 | 892.18
phpp | Pharm Prac serials | 8882.02 | 8831.29
phyp | Physics serials | 50003.54 | 52927.58
plsp | Plant Sci serials | 13156.7 | 14211.84
pscp | Political Sc serial | 12610.73 | 11216.83
psyp | Psychology serials | 33788.52 | 34280.33
pthp | [NAME] serials | 7544.41 | 7793.04
renp | [NAME] serial | 3089.26 | 2850.48
socp | Soc & Anthro serial | 16287.25 | 15443.84
thep | Theater serials | 2588.11 | 3019.97
tmdp | Textiles serials | 2205.12 | 2323.72
wmsp | Womens [NAME] serials | 0 | 0 | 0
[NAME] | Writing serials | 0 | 0 | 0
zzap | General serials | 21477.65 | 22005.98
zzlp | Library serials | 0 | 0
zzmp | Media serials | 0 | 0
[NAME] | Reference serials | 46932.65 | 45667.63
zzsp | Special Collections serials | 0 | 0 | 0
zzwp | [NAME]. | 1843257.76 | 1956422.76
 | TOTAL
Spreadsheet: 778264d1650963795-allocating-where-the-total-available-is-less-than-the-total-needed-allocation-by-ranking-with-under-supply
Sheet: Sheet1 (2)

RANK ALLOCATION
1 | 0.8
2 | 0.5
3 | 0.2
ORDER |  |  |  |  |  |  |  |  |  | ALLOCATION
 | CUST RANK |  | 1 | 3 | 2 | 2 | 3 | 1
AVAIL STOCK | CUST TOTAL | Minimum | CUST1 | CUST2 | CUST3 | CUST4 | CUST5 | CUST6 |  |  |  |  |  |  |  |  |  |  | TOTAL ALLOCATION | STOCK REMAINING
20 |  |  | 10 | 5 | 2 | 10 | 5 | 1
80 |  |  | 20 | 10 | 5 | 20 | 10 | 2
50 |  |  | 20 | 10 | 5 | 20 | 20 | 2 |  |  |  |  |  |  |  |  |  |  |  |  |  | should be modify
35 |  |  | 10 | 5 | 2 | 20 | 10 | 1 |  |  |  |  |  |  |  |  |  |  |  |  |  | should be modify
10 |  |  | 10 | 5 | 2 | 10 | 5 | 1
Spreadsheet: 695120d1600066799-vlookup-based-on-the-results-exam-vlookup-formula
Sheet: Sheet1

 | STUDENT RESULT
 | SUBJECT | MATH |  | SCIENCE |  | ART |  | ECONOMIC |  | COMPUTER |  | BIOLOGY |  | PHYSIC |  | CHEMISTRY
 | SCORE / GRED | M | G | M | G | M | G | M | G | M | G | M | G | M | G | M | G
 |  | 100 | A | 80 | A | 70 | B | 40 | D | 65 | C | 95 | A | 83 | A | 67 | C
 | CRITERIA CLASS |  |  |  |  |  |  |  | YOUR CLASS 2021
 | CLASS |  | SUBJECT |  | MINIMUM GRED |  |  |  | T4
 | SCIENCE STREAM |  | MATH |  | B
 |  |  | PHYSIC |  | A
 |  |  | BIOLOGY |  | A
 |  |  | CHEMISTRY |  | A
 | ECONOMY |  | MATH |  | B
 |  |  | SCIENCE |  | C
 |  |  | ECONOMIC |  | A
 |  |  | ART |  | C
 |  |  | COMPUTER |  | B
 | LITERATURE |  | ART |  | A
 |  |  | SCIENCE |  | D
 |  |  | COMPUTER |  | C
 |  |  | MATH |  | B
 |  |  | PHYSIC |  | C
Spreadsheet: 0bfe369c-b788-43e2-a597-7c8de940c028
Sheet: Sheet1

Table 8--Wheat: U.S. exports and imports for last 6 months (1,000 bushels), 6/14/2013 | Unnamed: 1 | Unnamed: 2 | Unnamed: 3 | Unnamed: 4 | Unnamed: 5 | Unnamed: 6 | Unnamed: 7
Item |  | Nov | Dec | Jan | Feb | Mar | Apr
 |  | 2012 | 2012 | 2013 | 2013 | 2013 | 2013
Exports | All wheat grain | 46512.04938870002 | 62762.8693062 | 76874.32116889142 | 91025.4292944507 | 101784.6774569142 | 108878.3782226721
 | All wheat flour 1/ | 1020.540156181214 | 1023.336426672353 | 1076.848165719499 | 1111.884357404189 | 927.6449420258741 | 784.5696578630073
 | All wheat products 2/ | 641.8423426731334 | 486.82467069176 | 489.0562170494644 | 596.5609254940301 | 851.2603597636167 | 655.5098454025247
 | Total all wheat | 48174.43188755436 | 64273.03040356412 | 78440.22555166038 | 92733.87457734892 | 103563.5827587037 | 110318.4577259376
Imports | All wheat grain | 8179.758924936902 | 9217.966792429499 | 9522.955191989402 | 9121.387520214903 | 6464.327187870301 | 8629.374349041602
 | All wheat flour 1/ | 830.5642066315149 | 819.7333560972884 | 818.6792741988849 | 847.43763241944 | 848.3643600054846 | 913.8840685517608
 | All wheat products 2/ | 1633.713467199341 | 1573.951869286533 | 1405.744347372017 | 1279.253090188831 | 1562.69362688873 | 1679.918761203055
 | Total all wheat | 10644.03659876776 | 11611.65201781333 | 11747.3788135603 | 11248.07824282317 | 8875.385174764517 | 11223.17717879641
Totals may not add due to rounding. [NAME] in grain-equivalent bushels. Includes meal, groats, and durum. 2/ Expressed in grain-equivalent bushels. Includes bulgur, couscous, and selected categories of pasta. Source: U.S. Department of Commerce, U.S. Census Bureau, Foreign Trade Statistics; and ERS calculations using Census trade statistics.
Date run: 6/12/2013
Spreadsheet: 215921d1361541678-sum-of-sum-tableau-entrep-ts
Sheet: C14

Local 14
Nom: | [NAME] | [PHONE]
Numéro de téléphone: | [PHONE]
[NAME]: | 40
Paiement dû le: | 2013-03-15 00:00:00
[NAME]: | 16
Réservé:
Prix: | 75
Payé: | NON
Mois réservés
Novembre 2011
Décembre 2011
Janvier 2012
Février 2012
Mars 2012
Avril 2012
Mai 2012
[NAME] 2012
Juillet 2012
Août 2012
Septembre 2012
Octobre 2012
Novembre 2012
Décembre 2012
Spreadsheet: 805257d1668606359-multiple-if-in-1-cell-cats-multiple-ifs
Sheet: Sheet1

Client | Cat 1 | Cat 2 | Cat 3 | Total Cats | Start | End | Stay Days | Daily Rate | Transaction Income
[NAME] | Blue | Nala | George |  | 2015-04-22 00:00:00 | 2015-04-27 00:00:00
Ayesha | Simba |  |  |  | 2015-04-16 00:00:00 | 2015-04-19 00:00:00 |  | 90
[NAME] | Marshmallow |  |  |  | 2015-04-16 00:00:00 | 2015-04-19 00:00:00 |  | 90
Lyndsay | [NAME] | Po |  |  | 2015-04-09 00:00:00 | 2015-04-24 00:00:00 |  | 175
[NAME] | Savage | Pestroy |  |  | 2015-04-10 00:00:00 | 2015-04-14 00:00:00 |  | 175
 | Rate
 | Cat 1 | 90
 | Cat 2 | 175
 | Cat 3 | 230
Spreadsheet: 708023d1607589493-how-to-report-the-top-20-and-bottom-20-of-a-data-table-report-with-2-conditions-dashboard
Sheet: DENMARK

Country | Category of item | Brands | Name of item | Reference N of the item | End user price in local currency after VAT | GNI per capita | Bundled | End user price in EUR after VAT |  | Top 5  lowest price | AB | MedEL | Cochlear | OM | Custom label
Country | Category of item | Brands | Name of item | Reference N of the item | End user price in local currency after VAT | GNI per capita | Bundled | End user price in EUR after VAT |  | Top 5  highest price | AB | MedEL | Cochlear | OM | Custom label
Country | Category of item | Brands | Name of item | Reference N of the item | End user price in local currency after VAT | GNI per capita | Bundled | End user price in EUR after VAT |  | Antenna cable | AB | MedEL | Cochlear | OM | Custom label
Country | Category of item | Brands | Name of item | Reference N of the item | End user price in local currency after VAT | GNI per capita | Bundled | End user price in EUR after VAT |  | [NAME] | AB | MedEL | Cochlear | OM | Custom label
Country | Category of item | Brands | Name of item | Reference N of the item | End user price in local currency after VAT | GNI per capita | Bundled | End user price in EUR after VAT |  | Charger | AB | MedEL | Cochlear | OM | Custom label
Country | Category of item | Brands | Name of item | Reference N of the item | End user price in local currency after VAT | GNI per capita | Bundled | End user price in EUR after VAT |  | Recheargable battery | AB | MedEL | Cochlear | OM | Custom label
Country | Category of item | Brands | Name of item | Reference N of the item | End user price in local currency after VAT | GNI per capita | Bundled | End user price in EUR after VAT |  | Full swim kit | AB | MedEL | Cochlear | OM | Custom label
Spreadsheet: 744156d1629031887-find-missing-hours-within-a-day-sample2
Sheet: MISSING TIME

TIME |  | MISSING HOURS |  | HELPER COLUMN |  | MISSING HOURS
2021-08-14 00:00:00
2021-08-14 01:00:00
2021-08-14 05:00:00
2021-08-14 06:00:00
2021-08-14 07:00:00
2021-08-14 08:00:00
2021-08-14 09:00:00
2021-08-14 10:00:00
2021-08-14 11:00:00
2021-08-14 12:00:00
2021-08-14 14:00:00
2021-08-14 15:00:00
2021-08-14 17:00:00
2021-08-14 18:00:00
2021-08-14 20:00:00
Spreadsheet: sally_beck__36248__West PG&E Deal Sum by Desk
Sheet: _tmp_9845_EPMI-ST-WHOURLY_deal_

 |  |  |  |  |  |  | ENRON POW | ER TRADING & | [NAME] |  |  |  |  |  | Run Date | :       04/06 | /01
Report Da | te:  04/06/01 |  |  |  |  |  |  | Deal [NAME] | y |  |  |  |  |  | Run Time | :       18:45 | :06
Post ID: | 9845
Desk: EPM | I-ST-WHOURLY
 |  | Trade | Start | End |  |  |  |  |  |  |  |  |  | Current |  |  |  | Prior Day | Prior
Deal | Counter | Date | Date | Date | Anty | Delivery | PV'd | Swap Vol | PV'd | Option Vol | Notional | Deal Vol |  | Deal | MTM P/L |  | LTD | Hedge | Day
Number | Party | MM/DD/YY | MM/DD/YY | MM/DD/YY | Y/N | Point | Peak | [NAME] | Peak | [NAME] | Peak | [NAME] | Price Mid | Basis Mid | Total Mid | Prudent | Liquidations | Management | Liquidations
--------- | ------------------ | -------- | -------- | -------- | ---- | ------------------------------ | ------------ | ------------ | ------------ | ------------ | ------------ | ------------ | ------------ | ------------ | ------------ | ------------ | ---------------- | --------------- | -------------
566735 | PG&E | 2001-04-02 00:00:00 | 2001-04-02 00:00:00 | 2001-04-02 00:00:00 | No | Four Corners-345KV | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 |  | 0 | 0
568044 | PG&E | 2001-04-02 00:00:00 | 2001-04-02 00:00:00 | 2001-04-02 00:00:00 | No | Four Corners-345KV | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 |  | 0 | 0
 |  |  |  |  |  |  | ------------ | ------------- | ------------- | ------------- | ------------ | ------------- | ------------ | ------------- | ------------- | ------------- | ---------------- | ---------------- | -------------
Total for | Region R7 |  |  |  |  |  | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 |  | 0 | 0
 |  |  |  |  |  |  | ============ | ============= | ============= | ============= | ============ | ============= | ============ | ============= | ============= | ============= | ================ | ================ | =============
Total Pow | er Price Book |  |  |  |  |  | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 |  | 0 | 0
 |  |  |  |  |  |  | ============ | ============= | ============= | ============= | ============ | ============= | ============ | ============= | ============= | ============= | ================ | ================ | =============
Spreadsheet: 870302d1716841036-can-anyone-tell-what-mistake-i-am-doing-in-my-formulas-given-in-the-sample-file-sample-file
Sheet: Table 9

कार्यक्रम PROGRAM |  |  | पदोन्नति पूर्य प्रतिक्षण – र्ेिनमान –II से र्ेिनमान –III (अ.जा./अ.ज.[NAME]) PRE-PROMOTION TRAINING (SC/ST) SCALE II TO III | PROG CODE
 |  |  |  | AIT 0112
तर्षर् समूह/SUBJECT GROUP |  |  | HR, MARKETING, CUSTOMER SERVICE & COMPLIANCE
उद्देश्य/OBJECTIVE |  |  | TO REINFORCE KNOWLEDGE AND EMPOWER THE CANDIDATES FOR BETTER PERFORMANCE IN THE PROMOTION PROCESS
लतक्षि समूह/TARGET GROUP |  |  | SCALE II (SC/ST)
अर्तध/DURATION |  |  | 1 WEEK
DAY | SESSION | CONTENTS
Day 1 | I | All Deposit products- CASA, Term Deposits
 | II | General Banking
 | III | Advances (Bal Sheet and Case studies)
 | IV | Advances - Working Capital, Bank Guarantees & Inland LC
Day 2 | I & II | General Banking
 | III | Advances & Credit Policy
 | IV | Advances - Delegation of powers
Day 3 | I & II | Foreign Exchange
 | III | Advances   &   Consortium/MBF/SYD/BP   &   Risk   Management   & Inspection Policy
 | IV | NPA & Recovery, IRAC & Provisioning
Day 4 | I | Agriculture - Schemes guidelines, lending norms
 | II | Advances & Term Loan/LHV and other schemes
 | III | Priority Sector - revised classification, lending norms
 | IV | Retail Lending Products - norms and various RL products
Day 5 | I | General Banking - staff matters
 | II | Agriculture - Investment and development loans
 | III | Govt. Sponsored Schemes
 | IV | General Banking - SARFAESI Act, DRT
Day 6 | I | Advances, Risk Management & BASEL-II
 | II | Digital Products - Tech products, IMB
 | III | Interview tips and Official Language
 | IV | Valediction
Spreadsheet: 0d200bce-8486-4f03-8a5a-721e54f89c0e
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/13 | 14.4 | 252 | 25.4 | 26.5 | 30.1 | 13.8
2013/141 | 11.50-13.50 | 265-305 | 19.65-22.95 | 18.95-22.25 | 21.35-24.65 | 13.30-15.30
2012/13
September | 14.3 | 254 | 28.9 | 26.5 | 35.2 | 13.3
October | 14.2 | 254 | 26.3 | 27 | 33.7 | 13.6
November | 14.3 | 255 | 26.7 | 26.7 | 32.6 | 14.1
December | 14.3 | 252 | 24.8 | 27.1 | 36.9 | 13.8
January | 14.3 | 249 | 26.3 | 26.8 | 31.2 | 13.7
February | 14.6 | 217 | 26.1 | 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 | 27.1 | 15.4
June | 15.1 |  | 24.4 | 27.4 | 27 | 15.2
July | 15.3 |  | 23.7 | 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
October | 12.5 | 281 | 23 | 21 | 26 | 13.5
November1 | 12.7 | 248 | 19.6 | 20 | 26.2 | 13.3
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-12-12 09:43:00.690000
Spreadsheet: 153819d1336063527-combining-if-statements-with-and-or-formula
Sheet: Sheet1

Tying to write a formula that would requrie a variance explantion if the following criteria are met:
 | 1.  If the variance between the 2012 budget and the 2013 budget exceeds $10,000 (+/-) AND 10%, require an explanation (required "Y", not required "N").
 | 2.  Not subject to the above threshold, if the 2012 forecast is greater than $1,000 but nothing is budgeted for 2013 or the 2013 budget is greater than $1,000 but nothing was forecasted for 2012, require an explanation (required "Y", not required "N").
I've got some rough formulas below.  However, I'm having a tough time combining.
2011 | 2012 Budget | 2012 Forecast | 2013 Budget
0 | 0 | 0 | 1500 |  | if 2013 budget >1000 but nothing forecasted for 2012 then "Y", otherwise "N"
0 | 0 | 1500 | 0 |  | if 2012 forecast >1000 but nothing budgeted for 2013 then "Y", otherwise "N"
1500 | 0 | 0 | 0
0 | 0 | 1500 | 0
175000 | 225000 | 225000 | 185000 |  | if variance between 2012 budget and 2013 budget is <> 10%, then "Y", otherwise "N"
175000 | 185000 | 185000 | 225000 |  | if variance between 2012 budget and 2013 budget exceeds $10,000 (+/-), then "Y", otherwise "N"
Spreadsheet: 847535d1698412072-replacing-ifs-with-dynamic-array-formula-settings-count-fx
Sheet: Sheet1

Size | A | B | C | D | E | F | G | H | A1 | B1 | C1 | D1 | E1 | F1 | [NAME] | H1
1 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0
2 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0
3 | 15 | 37 | 12 | 38 | 9 | 2 | 24 | 19
4 | 2 | 23 | 13 | 13 | 9 | 8 | 9 | 6
5 | 9 | 33 | 13 | 6 | 14 | 24 | 22 | 23
6 | 4 | 15 | 1 | 3 | 2 | 5 | 10 | 5
7 | 6 | 16 | 4 | 4 | 3 | 10 | 11 | 6
8 | 3 | 9 | 3 | 3 | 1 | 2 | 4 | 6
9 | 4 | 21 | 2 | 2 | 1 | 2 | 2 | 3
10 | 2 | 7 | 0 | 2 | 1 | 1 | 2 | 1
11 | 1 | 4 | 1 | 2 | 2 | 0 | 0 | 0
12 | 0 | 15 | 0 | 0 | 0 | 2 | 2 | 0
13 | 1 | 8 | 1 | 1 | 1 | 0 | 1 | 0
14 | 1 | 15 | 1 | 1 | 0 | 0 | 1 | 0
1 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0
2 | 0 | 0 | 0 | 10 | 0 | 0 | 0 | 0
3 | 19 | 42 | 16 | 54 | 10 | 2 | 25 | 22
4 | 2 | 23 | 13 | 13 | 9 | 8 | 9 | 6
5 | 9 | 33 | 13 | 6 | 14 | 24 | 22 | 23
6 | 4 | 15 | 1 | 3 | 2 | 5 | 10 | 5
7 | 6 | 16 | 4 | 4 | 3 | 10 | 11 | 6
8 | 3 | 9 | 3 | 3 | 1 | 2 | 4 | 6
9 | 4 | 21 | 2 | 2 | 1 | 2 | 2 | 3
10 | 2 | 7 | 0 | 2 | 1 | 1 | 2 | 1
11 | 1 | 4 | 1 | 2 | 2 | 0 | 0 | 0
12 | 0 | 15 | 0 | 0 | 0 | 2 | 2 | 0
13 | 1 | 8 | 1 | 1 | 1 | 0 | 1 | 0
14 | 1 | 15 | 1 | 1 | 0 | 0 | 1 | 0
1 | 0 | 0 | 0 | 52 | 1 | 0 | 0 | 0
2 | 0 | 0 | 0 | 16 | 0 | 0 | 0 | 0
3 | 44 | 25 | 27 | 3 | 10 | 22 | 46 | 67
4 | 9 | 39 | 28 | 13 | 13 | 42 | 51 | 16
5 | 6 | 36 | 23 | 1 | 10 | 6 | 25 | 14
6 | 14 | 86 | 8 | 49 | 26 | 33 | 24 | 26
7 | 12 | 70 | 7 | 11 | 13 | 2 | 12 | 4
8 | 8 | 25 | 9 | 7 | 3 | 0 | 2 | 5
9 | 3 | 32 | 2 | 15 | 1 | 3 | 8 | 5
10 | 0 | 21 | 1 | 6 | 0 | 1 | 0 | 1
11 | 2 | 9 | 0 | 1 | 3 | 0 | 0 | 1
12 | 0 | 21 | 0 | 0 | 3 | 0 | 2 | 0
13 | 0 | 13 | 0 | 0 | 1 | 0 | 1 | 0
14 | 0 | 31 | 1 | 2 | 1 | 0 | 1 | 0
Spreadsheet: 731384d1620315252-collate-data-from-different-worksheets-sample-workbook_1
Sheet: Master

 |  | Expected Output
Category | Activity Name | AU | Trainee | India TM | Trainer | Training Date | Time Spent | Training Time | Due Date
Recon | ABC | 120 | abc | def | afasf | 2021-04-30 00:00:00 | 1 | 04:30 PM - 05:30 PM | 2021-05-01 00:00:00
MJE | DEF | 120 | abc | def | afasf | 2021-04-30 00:00:00 | 1 | 04:30 PM - 05:30 PM | 2021-05-01 00:00:00
Other | EFG | 120 | abc | def | afasf | 2021-04-30 00:00:00 | 1 | 04:30 PM - 05:30 PM | 2021-05-01 00:00:00
MJE | GHI | 120 | abc | def | afasf | 2021-04-30 00:00:00 | 1 | 04:30 PM - 05:30 PM | 2021-05-01 00:00:00
 | JKL
MJE | MNO | 120 | abc | def | afasf | 2021-04-30 00:00:00 | 1 | 04:30 PM - 05:30 PM | 2021-05-01 00:00:00
GL | PRQ | 120 | abc | def | afasf | 2021-04-30 00:00:00 | 1 | 04:30 PM - 05:30 PM | 2021-05-01 00:00:00
Other | MIN | 120 | abc | def | afasf | 2021-04-30 00:00:00 | 1 | 04:30 PM - 05:30 PM | 2021-05-01 00:00:00
Recon | SIR | 120 | abc | def | afasf | 2021-04-30 00:00:00 | 1 | 04:30 PM - 05:30 PM | 2021-05-01 00:00:00
Other | OCQ | 120 | abc | def | afasf | 2021-04-30 00:00:00 | 1 | 04:30 PM - 05:30 PM | 2021-05-01 00:00:00
 | PCV
MJE | QTE | 120 | abc | def | afasf | 2021-04-30 00:00:00 | 1 | 04:30 PM - 05:30 PM | 2021-05-01 00:00:00
Spreadsheet: 93703d1293458346-excel-2007-how-to-append-zeroes-and-extract-middle-digits-whattodobook1
Sheet: Sheet1

4
8065 | 65044225 | 3814209 | 1953 |  | 0442 | 1953
0442 | 195364 |  | 8142 |  | 1953 | 8142
1953 | 3814209 |  | 2921 |  | 8142 | 2921
8142 | 66292164 |  | 5322 |  | 2921 | 5322
2921 | 8532241 |  | 3236 |  | 5322 | 3236
5322 | 28323684 |  | 4716 |  | 3236 | 4716
3236 | 10471696 |  | 2406 |  | 4716 | 2406
4716 | 22240656 |  | 7888 |  | 2406 | 7888
2406 | 5788836 |  | 2205 |  | 7888 | 2205
7888 | 62220544 |  | 8620 |  | 2205 | 8620
2205 | 4862025 |  | 3044 |  | 8620 | 3044
8620 | 74304400 |  | 2659 |  | 3044 | 2659
3044 | 9265936 |  | 0702 |  | 2659 | 0702
2659 | 7070281 |  | 4928 |  | 0702 | 4928
0702 | 492804 |  | 2851 |  | 4928 | 2851
4928 | 24285184 |  | 1282 |  | 2851 | 1282
2851 | 8128201 |  | 6435 |  | 1282 | 6435
1282 | 1643524 |  | 4092 |  | 6435 | 4092
6435 | 41409225 |  | 7444 |  | 4092 | 7444
4092 | 16744464 |  | 4131 |  | 7444 | 4131
7444 | 55413136 |  | 0651 |  | 4131 | 0651
4131 | 17065161 |  | 4238 |  | 0651 | 4238
0651 | 423801 |  | 9606 |  | 4238 | 9606
4238 | 17960644 |  | 2752 |  | 9606 | 2752
9606 | 92275236 |  | 5735 |  | 2752 | 5735
2752 | 7573504 |  | 8902 |  | 5735 | 8902
5735 | 32890225 |  | 2456 |  | 8902 | 2456
8902 | 79245604 |  | 0319 |  | 2456 | 0319
2456 | 6031936 |  | 1017 |  | 0319 | 1017
0319 | 101761 |  | 0342 |  | 1017 | 0342
1017 | 1034289 |  | 1169 |  | 0342 | 1169
0342 | 116964 |  | 3665 |  | 1169 | 3665
1169 | 1366561 |  | 4322 |  | 3665 | 4322
3665 | 13432225 |  | 6796 |  | 4322 | 6796
4322 | 18679684 |  | 1856 |  | 6796 | 1856
6796 | 46185616 |  | 4447 |  | 1856 | 4447
1856 | 3444736 |  | 7758 |  | 4447 | 7758
4447 | 19775809 |  | 1865 |  | 7758 | 1865
7758 | 60186564 |  | 4782 |  | 1865 | 4782
1865 | 3478225 |  | 8675 |  | 4782 | 8675
4782 | 22867524 |  | 2556 |  | 8675 | 2556
8675 | 75255625 |  | 5331 |  | 2556 | 5331
2556 | 6533136 |  | 4195 |  | 5331 | 4195
5331 | 28419561 |  | 5980 |  | 4195 | 5980
4195 | 17598025 |  | 7604 |  | 5980 | 7604
5980 | 35760400 |  | 8208 |  | 7604 | 8208
7604 | 57820816 |  | 3712 |  | 8208 | 3712
8208 | 67371264 |  | 7789 |  | 3712 | 7789
3712 | 13778944 |  | 6685 |  | 7789 | 6685
7789 | 60668521 |  | 6892 |  | 6685 | 6892
6685 | 44689225 |  | 4996 |  | 6892 | 4996
6892 | 47499664 |  | 9600 |  | 4996 | 9600
4996 | 24960016 |  | 1600 |  | 9600 | 1600
9600 | 92160000 |  | 5600 |  | 1600 | 5600
1600 | 2560000 |  | 3600 |  | 5600 | 3600
5600 | 31360000 |  | 9600 |  | 3600 | 9600
3600 | 12960000 |  | 1600 |  | 9600 | 1600
Spreadsheet: 820872d1678315865-matching-two-columns-and-returning-the-third-example
Sheet: Merge1

Date | Type | Description | Value | Category
2023-03-01 00:00:00 |  | UKI T/A DIRECTLINE | -10 | wife
2023-03-01 00:00:00 |  | UKI T/A DIRECTLINE | -20 | me
2023-03-02 00:00:00 |  | UKI T/A DIRECTLINE | -30 | dog
2023-03-02 00:00:00 |  | Savings Account | -50 | To Savings
2023-03-03 00:00:00 |  | SAVINGS ACCOUNT | 60 | From Savings
2023-03-04 00:00:00 |  | BRITISH GAS | -20 | Energy
2023-03-05 00:00:00 |  | WATER | -150 | Energy
2023-03-02 00:00:00 |  | UKI T/A DIRECTLINE | -40