tianzl66/Sheetpedia huggingface dataset:
Spreadsheet: 784b6c1c-6235-4a89-8ad9-e14a36375773
Sheet: Sheet1

Unnamed: 0 | แบบบันทึกผลการตรวจสภาวะช่องปากในงานเฝ้าระวังทางทันตสุขภาพระดับชั้นเรียน (ทส.001) | Unnamed: 2 | Unnamed: 3 | Unnamed: 4 | Unnamed: 5 | Unnamed: 6 | Unnamed: 7 | Unnamed: 8 | Unnamed: 9 | Unnamed: 10 | Unnamed: 11 | Unnamed: 12 | Unnamed: 13 | Unnamed: 14 | Unnamed: 15 | Unnamed: 16
 | ชั้น...................โรงเรียน...............................................ตำบล..................................[NAME]ปีการศึกษา...........................
ที่ |  | ครั้งที่ 1 (เดือนมิถุนายน) |  |  |  |  |  |  |  | ครั้งที่ 2 (เดือนธันวาคม)
 |  | [NAME] |  |  |  |  | ฟันถาวร |  |  | [NAME] |  |  |  |  | ฟันถาวร
 | ชื่อ - สกุล | ปกติ | อักเสบ | อักเสบ |  | ปัญหา | ไม่ผุ | ผุ |  | ปกติ | อักเสบ | อักเสบ |  | ปัญหา | ไม่ผุ | ผุ
 |  | (ไม่มี ค,ง,จ) | ไม่มีหินปูน | มีหินปูน |  | เร่งด่วน |  |  |  | (ไม่มี ค,ง,จ) | ไม่มีหินปูน | มีหินปูน |  | เร่งด่วน
 |  | ก. | ค. | ง. |  | จ. | 0 | 1 |  | ก. | ค. | ง. |  | จ. | 0 | 1
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
รวม
สุขภาพช่องปาก |  | สรุปการตรวจครั้งที่  1 |  | ปัญหา |  | ระดับ จ |  |  |  | สรุปการตรวจครั้งที่  2 |  | ปัญหา |  | ระดับ จ
จะถือว่า |  | ระดับ ก. ร้อยละ................. |  | เป็น | ไม่เป็น | 1 = หินปูนเต็มด้าน |  |  |  | ระดับ ก. ร้อยละ................. |  | เป็น | ไม่เป็น | 1 = หินปูนเต็มด้าน
เป็นปัญหาเมื่อ |  | ระดับ ค. ร้อยละ.................. |  |  |  | 2 = รากฟันแทงเหงือก |  |  |  | ระดับ ค. ร้อยละ.................. |  |  |  | 2 = รากฟันแทงเหงือก
[NAME]20 |  | ระดับ ง. ร้อยละ.................. |  |  |  | 3 = ฟันซ้อน |  |  |  | ระดับ ง. ร้อยละ.................. |  |  |  | 3 = ฟันซ้อน
[NAME]10 |  | ระดับ จ. ร้อยละ.................. |  |  |  | 4 = ปวดบวม |  |  |  | ระดับ จ. ร้อยละ.................. |  |  |  | 4 = ปวดบวม
ระดับ ค+ง+จ  >50 |  | ระดับค+ง+จร้อยละ............ |  |  |  | 5 = มีหนองปลายราก |  |  |  | ระดับค+ง+จร้อยละ............ |  |  |  | 5 = มีหนองปลายราก
ฟันถาวรผุ  >20 |  | ฟันถาวรผุ ร้อยละ............... |  |  |  | 6 = มีก้อนเนื้อในรูผุ |  |  |  | ฟันถาวรผุ ร้อยละ............... |  |  |  | 6 = มีก้อนเนื้อในรูผุ
Spreadsheet: 542886d1508156892-table-to-list-help-harrys
Sheet: After

1 | A
2 | A
3 | A
4 | A
5 | A
6 | B
7 | B
8 | B
9 | B
10 | B
11 | B
12 | B
13 | B
14 | C
15 | D
16 | D
17 | D
18 | D
19 | D
20 | D
21 | D
22 | D
23 | D
24 | D
25 | E
26 | E
27 | E
28 | E
29 | E
30 | E
31 | F
32 | F
33 | F
34 | F
35 | F
36 | F
37 | F
38 | F
39 | F
40 | F
Spreadsheet: 847252d1698262744-get-corresponding-text-book1
Sheet: Sheet2

1 | Text 1
2 | Text 2
3 | Text 3
4 | Text 4
5 | Text 5
6 | Text 6
7 | Text 7
8 | Text 8
9 | Text 9
10 | Text 10
11 | Text 11
12 | Text 12
13 | Text 13
14 | Text 14
15 | Text 15
16 | Text 16
17 | Text 17
18 | Text 18
19 | Text 19
20 | Text 20
21 | Text 21
22 | Text 22
23 | Text 23
24 | Text 24
25 | Text 25
26 | Text 26
27 | Text 27
28 | Text 28
29 | Text 29
30 | Text 30
31 | Text 31
32 | Text 32
33 | Text 33
34 | Text 34
35 | Text 35
36 | Text 36
37 | Text 37
38 | Text 38
39 | Text 39
40 | Text 40
41 | Text 41
42 | Text 42
43 | Text 43
44 | Text 44
45 | Text 45
46 | Text 46
47 | Text 47
48 | Text 48
49 | Text 49
50 | Text 50
51 | Text 51
52 | Text 52
53 | Text 53
54 | Text 54
55 | Text 55
56 | Text 56
57 | Text 57
58 | Text 58
59 | Text 59
60 | Text 60
61 | Text 61
62 | Text 62
Spreadsheet: 464018d1464849542-randomly-select-the-numbers-less-than-2955-sample-sheet-1
Sheet: Data

Date | Vehicle Number | Kgs | Vehicles needed | Vehicle Number
 |  |  |  | 1 | 2 | 3 | 4 | 5 | 6 | 7 | 8 | 9
2016-06-01 00:00:00 | KA 20 AA 001 | 1420
2016-06-01 00:00:00 | KA 20 AA 002 | 2110
2016-06-01 00:00:00 | KA 20 AA 003 | 17690
2016-06-01 00:00:00 | KA 20 AA 004 | 4100
2016-06-01 00:00:00 | KA 20 AA 005 | 4210
2016-06-01 00:00:00 | KA 20 AA 006 | 5405
2016-06-01 00:00:00 | KA 20 AA 007 | 3900
2016-06-01 00:00:00 | KA 20 AA 008 | 1680
2016-06-01 00:00:00 | KA 20 AA 009 | 4995
2016-06-01 00:00:00 | KA 20 AA 010 | 750
2016-06-01 00:00:00 | KA 20 AA 011 | 1505
2016-06-01 00:00:00 | KA 20 AA 012 | 935
2016-06-01 00:00:00 | KA 20 AA 013 | 11365
2016-06-01 00:00:00 | KA 20 AA 014 | 5240
2016-06-01 00:00:00 | KA 20 AA 015 | 3635
2016-06-01 00:00:00 | KA 20 AA 016 | 1575
2016-06-01 00:00:00 | KA 20 AA 017 | 17475
2016-06-01 00:00:00 | KA 20 AA 018 | 11455
2016-06-01 00:00:00 | KA 20 AA 019 | 12320
2016-06-01 00:00:00 | KA 20 AA 020 | 1125
Spreadsheet: 707207d1607097085-how-to-return-results-of-a-top-5-lowest-price-top-5-highest-price-and-price-difference-clean-data
Sheet: GDP

Country | GDP (millions) | Level |  | Level of GDP
FRANCE | 2715518.27422745 |  |  | GDP_1_low (<500.000t$) | 500000
SPAIN | 1394116.31076863 |  |  | GDP_2_medium(<1.500.000t$) | 1500000
PORTUGAL | 237686.075634698 |  |  | GDP_3_high(<30.000.000t$) | 30000000
ITALY | 2001244.39204157
GERMANY | 3845630.03082352
USA | 21427700
AUSTRALIA | 1392680.58932914
NEW-ZEALAND | 206928.765543935
DENMARK | 348078.018463905
BRAZIL | 1839758.04076562
POLAND | 592164.400687607
ALGERIA | 169988.236398126
MOROCCO | 118725.27959613
UK | 2827113.18469558
CANADA | 1736425.62951996
RUSSIA | 1699876.57887135
Spreadsheet: 172858d1344356774-creating-budget-by-getting-sublist-transactions-budget
Sheet: July

 |  |  |  |  |  | Month Dates
 | Date | Expense | Category | Description |  | 2012-07-01 00:00:00 | 2012-07-31 00:00:00 |  |  |  |  | Budgeted
 | 2012-07-19 00:00:00 | 11 |  |  |  |  |  |  |  |  | Alcohol | 75
 | 2012-07-20 00:00:00 | 22.22 |  |  |  |  |  |  |  |  | Clothes | 10
 | 2012-07-20 00:00:00 | 55.87 |  |  |  |  |  |  |  |  | Entertainment | 25
 | 2012-07-20 00:00:00 | 45 |  |  |  |  |  |  |  |  | Gas | 100
 | 2012-07-20 00:00:00 | 12 |  |  |  |  |  |  |  |  | Gifts | 15
 | 2012-07-20 00:00:00 | 10 |  |  |  |  |  |  |  |  | Groceries | 100
 | 2012-07-20 00:00:00 | 50 |  |  |  |  |  |  |  |  | Necessities | 10
 | 2012-07-20 00:00:00 | 28 |  |  |  |  |  |  |  |  | Rent and Utilities | 500
 | 2012-07-20 00:00:00 | 45 |  |  |  |  |  |  |  |  | Restaurants | 60
 | 2012-07-20 00:00:00 | 37.05 |  |  |  |  |  |  |  |  | School Stuff | 15
 | 2012-07-20 00:00:00 | 54.25 |  |  |  |  |  |  |  |  | Shopping | 25
 | 2012-07-29 00:00:00 | 10 |  |  |  |  |  |  |  |  | Tithe | 20
 | 2012-07-31 00:00:00 | 12 |  |  |  |  |  |  |  |  | Other | 50
 |  |  |  |  |  |  |  |  |  |  | Total | 1005
Spreadsheet: 679206d1590254065-how-to-search-2-columns-for-the-information-entered-in-one-column-samplefile
Sheet: supply

SCAN | [NAME] | PRICE EACH | Qty | Extended Cost | AREA/ UNIT | ITEM NO | Catalog No | DATE/TIME  STAMP
574-EN95 |  |  |  |  |  |  |  | 2020-05-21 10:42:52
173
174
175
176
Spreadsheet: 271035d1381790021-solved-countifs-problem-between-two-dates-month-10
Sheet: Yearly Summary

 |  |  |  | Jan | Feb | Mar | Apr | May | Jun | Jul | Aug | Sep | Oct | Nov | Dec | Total
 |  |  | Buzz | 247 | 226 | 229 | 241 | 258 | 265 | 331 | 301 | 254 | 89 | 0 | 0 | 2093
 |  |  | Scott | 223 | 246 | 217 | 227 | 268 | 251 | 256 | 187 | 178 | 83 | 0 | 0 | 1845
 |  |  | A Mizu | 101 | 114 | 123 | 154 | 124 | 146 | 182 | 148 | 194 | 62 | 0 | 0 | 1092
 |  |  | Misc | 41 | 63 | 66 | 56 | 49 | 82 | 102 | 89 | 33 | 83 | 0 | 0 | 577
 |  |  | Total | 612 | 649 | 635 | 678 | 699 | 744 | 871 | 724 | 659 | 269 | 0 | 0 | 5607
Spreadsheet: 437944d1451596410-counting-the-number-of-errors-in-column-o-for-each-of-four-names-in-column-d-blank-sheet
Sheet: Sheet2

 | 11/6 through 11/30/15
 | Invoicer | Eddie | [NAME] | [NAME] | Misti
 | # errors | 5 | 14 | 5 | 6
 | # invoiced | 637 | 620 | 571 | 668
 | Error % | 0.007849293563579277 | 0.02258064516129032 | 0.008756567425569177 | 0.008982035928143712
Spreadsheet: 866041d1712972891-num-error-in-xirr-formula-xirr3
Sheet: Sheet1 (2)

SOLV |  |  |  |  |  | WBA
Event | Date | Shares | Price | $ |  | Event | Date | Shares | Price | $
Buy | 2024-04-01 00:00:00 | 51 | 74.40549 |  |  | Buy | 2024-01-02 00:00:00 | 297.619 | 26.87
Spinoff
fr. MMM
Curr. Val. |  |  |  |  |  | Curr. Val.
 | XIRR |  |  |  |  |  | XIRR
Spreadsheet: 72240d1272939224-line-item-extractor-test
Sheet: Day 3

Account Number | Beginning | Consta | Interest | SFEE | Rate | This Rate | That Rate | Penalty | LPMI
251122546 | 250222 | 2565 | 0.086 | 0.005 | 0.00026 | 2 | 1 | 2 | 5.421476666666666
251122584 | 19200 | 2565 | 0.025 | 0.005 | 0.00026 | 2 | 1 | 2 | 0.416
251122622 | 225000 | 1154 | 0.0325 | 0.005 | 0.00026 | 2 | 1 | 2 | 4.874999999999999
251122660 | 139585.333333333 | 881 | 0.0915 | 0.005 | 0.00026 | 2 | 1 | 2 | 3.024348888888881
251122698 | 126974.333333333 | 1125 | 0.086 | 0.005 | 0.00026 | 2 | 1 | 2 | 2.751110555555548
251122736 | 114363.333333333 | 3564 | 0.086 | 0.005 | 0.00026 | 2 | 1 | 2 | 2.477872222222215
251122774 | 101752.333333333 | 6003 | 0.025 | 0.005 | 0.00026 | 2 | 1 | 2 | 2.204633888888881
251122812 | 89141.3333333333 | 8442 | 0.0325 | 0.005 | 0.00026 | 2 | 1 | 2 | 1.931395555555555
251122850 | 76530.3333333333 | 10881 | 0.0915 | 0.005 | 0.00026 | 2 | 1 | 2 | 1.658157222222221
251122888 | 63919.3333333333 | 13320 | 0.086 | 0.005 | 0.00026 | 2 | 1 | 2 | 1.384918888888888
251122926 | 51308.3333333333 | 15759 | 0.025 | 0.005 | 0.00026 | 2 | 1 | 2 | 1.111680555555555
251122964 | 38697.3333333333 | 18198 | 0.0325 | 0.005 | 0.00026 | 2 | 1 | 2 | 0.8384422222222213
251123002 | 26086.3333333333 | 20637 | 0.0915 | 0.005 | 0.00026 | 2 | 1 | 2 | 0.5652038888888881
251123040 | 13475.3333333333 | 23076 | 0.2933 | 0.005 | 0.00026 | 2 | 1 | 2 | 0.2919655555555548
Spreadsheet: 672757d1586987227-payroll-project-for-ytd-payrolefinal
Sheet: Joe's Time Sheet

 |  |  |  |  |  |  |  |  |  |  |  |  | IF(F15>0,M5-F15,0) |  | IF(F15>0,M5-F15,0)
 | WAGE | OT RATE | BONUS | SOC SEC | MEDICARE | FEDERAL | STATE | HEALTH | DENTAL | VISION | 401K | VACATION TIME EARNED | VACATION TIME LEFT | SICK TIME EARNED | SICK TIME LEFT
 | 10.5 | 1.5 | 20 | 0.042 | 0.0145 | 0.2 | 0.0425 | 0 | 0 | 0 | 0 |  |  |  |  |  | 2019-11-10 00:00:00
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 2019-11-17 00:00:00
DATE | TIME IN | TIME OUT | TIME IN | TIME OUT | VACATION TIME USED | SICK TIME USED | TOTAL HOURS | REGULAR HRS | OT HRS | REG GP | OT GP | TOTAL GROSS PAY |  |  |  |  | 2019-11-25 00:00:00
2019-11-04 00:00:00 | 09:00:00 | 12:30:00 | 13:00:00 | 17:00:00
2019-11-05 00:00:00 | 17:30:00 | 22:00:00 | 23:00:00 | 04:00:00
2019-11-06 00:00:00 |  |  |  |  | 8
2019-11-07 00:00:00 | 09:00:00 | 12:30:00 | 13:00:00 | 17:30:00
2019-11-08 00:00:00 | 08:00:00 | 12:30:00 |  |  | 3.5
2019-11-09 00:00:00
2019-11-10 00:00:00
 |  |  |  |  |  |  |  | IF(H8+G8+F8>8,8,H8+F8+G8)
DATE | TIME IN | TIME OUT | TIME IN | TIME OUT | VACATION TIME USED | SICK TIME USED | TOTAL HOURS | REGULAR HRS | OT HRS | REG GP | OT GP | TOTAL GROSS PAY
2019-11-11 00:00:00 | 08:30:00 | 12:00:00 | 13:30:00 | 20:00:00
2019-11-12 00:00:00 |  |  |  |  | 8
2019-11-13 00:00:00 | 17:30:00 | 21:30:00 | 22:30:00 | 03:00:00
2019-11-14 00:00:00 |  |  |  |  |  | 8
2019-11-15 00:00:00 | 06:00:00 | 10:00:00 | 11:00:00 | 15:00:00
2019-11-16 00:00:00
2019-11-17 00:00:00
DATE | TIME IN | TIME OUT | TIME IN | TIME OUT | VACATION TIME USED | SICK TIME USED | TOTAL HOURS | REGULAR HRS | OT HRS | REG GP | OT GP | TOTAL GROSS PAY
2019-11-18 00:00:00 | 08:00:00 |  |  | 17:00:00
2019-11-19 00:00:00 | 08:00:00 |  |  | 16:30:00
2019-11-20 00:00:00 | 08:00:00 |  |  | 17:00:00
2019-11-21 00:00:00 |  |  |  |  | 8
2019-11-22 00:00:00 |  |  |  |  |  | 8
2019-11-23 00:00:00 | 09:00:00 |  |  | 17:00:00
2019-11-24 00:00:00
To subtract an hour for lunch on weekdays |  | IF(AND(ISNUMBER(B11),ISNUMBER(E11)),MOD(E11-B11,1)-IF(WEEKDAY(A11,2)>5,.05/24,1/24),0)*24
To subtract an half hour for lunch on weekends |  |  | time in | time out | time out-time in | date
DATE | TIME IN | TIME OUT | TIME IN | TIME OUT | VACATION TIME USED | SICK TIME USED | TOTAL HOURS | REGULAR HRS | OT HRS | REG GP | OT GP | TOTAL GROSS PAY
2020-03-15 00:00:00 | 09:00:00 |  |  | 17:00:00
2020-03-16 00:00:00 | 09:00:00 |  |  | 17:00:00
2020-03-17 00:00:00 | 09:00:00 |  |  | 17:00:00
2020-03-18 00:00:00 | 09:00:00 |  |  | 17:00:00
2020-03-19 00:00:00 | 09:00:00 | 12:00:00 | 12:30:00 | 17:00:00
DATE | TIME IN | TIME OUT | TIME IN | TIME OUT | VACATION TIME USED | SICK TIME USED | TOTAL HOURS | REGULAR HRS | OT HRS | REG GP | OT GP | TOTAL GROSS PAY
2020-03-22 00:00:00 | 09:00:00 |  |  | 16:00:00
2020-03-23 00:00:00 | 09:00:00 |  |  | 17:00:00
2020-03-24 00:00:00 | 09:00:00 |  |  | 17:00:00
2020-03-25 00:00:00 | 09:00:00 |  |  | 17:00:00
2020-03-26 00:00:00 | 09:00:00 |  |  | 17:00:00
Spreadsheet: 819347d1677440778-formula-to-get-monthly-total-from-full-data-sheet-ytdsalessummary
Sheet: Month_YTD

 |  |  | Jan
 |  |  |  | 2022-01-01 00:00:00 | YTD | 2022-02-01 00:00:00 | YTD | 2022-03-01 00:00:00 | YTD | 2022-04-01 00:00:00 | YTD | 2022-05-01 00:00:00 | YTD | 2022-06-01 00:00:00 | YTD
 |  |  | Beverage
 |  |  | Cakes
 |  |  | Food
 |  |  | Novelties
 |  |  | SoftServe
 |  |  | NetSales
Spreadsheet: 5b685868-ac41-4a8c-99e4-96b5fb826d2d
Sheet: Sheet1

Release: Financial Soundness Indicators | Unnamed: 1 | Unnamed: 2
Link: http://alfred.stlouisfed.org/release?rid=238
ALFRED (ArchivaL Federal Reserve Economic Data)
Economic Research Division
Federal Reserve Bank of St. Louis
File Created: 2014-10-25 7:40 AM [NAME]
 | Real-Time | Period
Name: | Start | End
Financial Soundness Indicators | 2011-11-01 00:00:00 | Current
Link:
http://fsi.imf.org/ | 2011-11-01 00:00:00 | Current
Source:
International Monetary Fund | 2011-11-01 00:00:00 | Current
Notes:
The Financial Soundness Indicators (FSIs) were developed by the IMF, | 2011-11-01 00:00:00 | Current
together with the international community, with the aim of supporting
macroprudential analysis and assessing strengths and vulnerabilities
of financial systems.
The website, hosted by the Statistics Department of the IMF,
disseminates data and metadata on selected FSIs provided by
participating countries. For a description of the various FSIs, as
well as the consolidation basis, consolidation adjustments, and
(http://fsi.imf.org/misc/FSI%20Concepts%20and%20Definitions.pdf). The
Statistics Department will steadily increase the number of countries
reporting FSIs for dissemination on this site.
Reporting countries compile FSI data presented on this website by
using different methodologies, which may also vary for different
points in time for the same country. Users are advised to consult the
accompanying [NAME] (http://fsi.imf.org/CountryList.aspx) to conduct
more meaningful cross-country comparisons or to assess the evolution
of a given FSI for any of the countries. For a customized search of
the database please use the the query builder
(http://elibrary-data.imf.org/QueryBuilder.aspx?s=322&key=1445284&f=1&ts=1&ys=2002&ye=2011&ms=1&me=12&ds=1&de=31&did=323&id=195)
in IMF eLibrary Data.
Release Dates Notes:
Release dates are determined by the following process:
When available, the actual release date as provided by the source is
entered into the ALFRED database.  If a release date is not available
from the source, the release date given by our data providers is used.
If a release date cannot be determined either from the source or from
our data providers, the date that the series was first available in
the St. Louis Fed's FRED database is used.
The release date list contains the dates when any series from this
release was revised.  Note that all series from a release do not
necessarily revise on every release date.
Release Dates:
2011-11-01 00:00:00
2012-02-08 00:00:00
2012-03-01 00:00:00
2012-04-02 00:00:00
2012-05-01 00:00:00
2012-06-01 00:00:00
2012-06-29 00:00:00
2012-08-02 00:00:00
2012-10-01 00:00:00
2012-11-15 00:00:00
2012-12-03 00:00:00
2013-01-02 00:00:00
2013-02-01 00:00:00
2013-03-01 00:00:00
2013-04-01 00:00:00
2013-05-01 00:00:00
2013-06-03 00:00:00
2013-07-01 00:00:00
2013-08-01 00:00:00
2013-09-03 00:00:00
2013-10-01 00:00:00
2013-11-01 00:00:00
2013-12-02 00:00:00
2014-01-01 00:00:00
2014-02-03 00:00:00
2014-03-03 00:00:00
2014-04-01 00:00:00
2014-05-01 00:00:00
2014-06-02 00:00:00
2014-07-01 00:00:00
2014-08-01 00:00:00
2014-09-02 00:00:00
2014-10-01 00:00:00
Spreadsheet: 1e6989b8-7270-4dd2-8278-057cfe0e7bd8
Sheet: 2005-06

Table C
Graduate Student Numbers by Faculty and Year Group
2005-06
Faculty | Year 1 | Year 2 | Year 3 | Year 4 | Year 5+ | Year 6+ | Total
Arts and Humanities | 424 | 172 | 49 | 19 | 7 | 7
Built Environment | 463 | 137 | 76 | 33 | 14 | 15
Clinical Sciences | 407 | 357 | 243 | 122 | 37 | 11
Eastman Dental Institute | 73 | 106 | 67 | 49 | 37 | 4
Engineering | 474 | 227 | 187 | 99 | 46 | 12
Laws | 394 | 29 | 10 | 2 | 1 | 1
Life Sciences | 488 | 272 | 181 | 56 | 17 | 18
Mathematical and Physical Sciences | 228 | 106 | 91 | 21 | 2 | 0
Social and Historical Sciences | 889 | 257 | 115 | 42 | 14 | 7
Total
The Clinical Sciences total includes the Graduate Institutes of Child Health, Neurology and Ophthalmology and the Eastman Dental Institute.
Spreadsheet: 822573d1679420199-add-an-alpha-character-to-duplicate-records-in-a-table-unique-ref-in-table
Sheet: Range

Reference | Working Solution for Duplicate
123456
123456
123456
123456
123456
123456
123456
123456
123456
123456
Spreadsheet: 873852d1720438059-look-up-the-data-and-return-multiple-result-sample-data-tms-gk-jt
Sheet: Sheet1

DATAS |  |  | CALCULATED RESULT |  |  |  |  |  | GK |  |  |  | JT
Name | Choice |  | No | Name | 1st Choice | 2nd Choice | 3rd Choice
[NAME] | Japan |  | 1
[NAME] | Singapore |  | 2
Hanna | Bali |  | 3
Leanne | Phillipine |  | 4
[NAME] | Holland |  | 5
Hanna | Malaysia |  | 6
[NAME] | Vietnam |  | 7
[NAME] | Korea |  | 8
Leanne | India
[NAME] | Nepal
Hanna | Australia |  | EXPECTED RESULT
Leanne | Canada |  | No | Name | 1st Choice | 2nd Choice | 3rd Choice |  | {=IF(D3="","",INDEX($A$3:$A$25,MATCH(0,COUNTIF(E$2:E2,$A$3:$A$25),0))&"")}
[NAME] | Alaska |  | 1 | [NAME] | Japan | Vietnam | Switzerland
[NAME] | Switzerland |  | 2 | [NAME] | Singapore | Korea | England |  | {'=IF($E3="","",IFERROR(INDEX($B$3:$B$20,SMALL(IF($A$3:$A$20=$E3,MATCH(ROW($A$3:$A$20),ROW($A$3:$A$20))),COLUMNS($A$1:A1))),"")&"")}
[NAME] | England |  | 3 | Hanna | Bali | Malaysia | Australia
TMS6 | France |  | 4 | Leanne | Phillipine | India | Canada |  | =IF($E3="","",IFERROR(INDEX($B:$B,AGGREGATE(15,6,ROW($A$3:$A$25)/($A$3:$A$25=$E3),COLUMNS($F3:F3))),""))&""
TMS7 | Germany |  | 5 | [NAME] | Holland | Nepal | Alaska
TMS6 | Spain |  |  |  |  |  |  |  | =IF($D3="","",IFERROR(INDEX($B$3:$B$25,AGGREGATE(15,6,(ROW($A$3:$A$25)-ROW($A$3)+1)/($A$3:$A$25=$E3),COLUMNS($A$1:A$1))),""))&""
TMS7
Spreadsheet: 96779d1296066830-how-can-i-count-and-sum-entries-per-date-book2
Sheet: Sheet1

Date | Item |  |  |  | Count of Date
2011-11-01 00:00:00 | hot |  |  |  | Date | Total
2011-11-01 00:00:00 | cold |  |  |  | 2011-11-01 00:00:00 | 4
2011-11-01 00:00:00 | hot |  |  |  | 2011-11-02 00:00:00 | 1
2011-11-01 00:00:00 | warm |  |  |  | 2011-11-03 00:00:00 | 3
2011-11-02 00:00:00 | hot |  |  |  | Grand Total | 8
2011-11-03 00:00:00 | something
2011-11-03 00:00:00 | cold
2011-11-03 00:00:00 | red
Spreadsheet: 863197d1710777005-vlookup-if-with-conditions-in-two-columns-solar-salaried-employee-list-test_3
Sheet: ENTRY TAB

Emp No | Employee Full Name | First Name | Last Name | PHONE NUMBER | Hire Date
1001
1036
1037
1068
 |  |  |  | Lookup on A2
 |  |  |  | in WD DROP
 |  |  |  | for work phone#
 |  |  |  | if none, then add
 |  |  |  | personal phone #
Spreadsheet: 785551d1656490443-how-index-and-match-with-multiple-criteria-sample-workbook-index-match-
Sheet: Shipment Record

Shipment ID | Name | Total Quantity | # of pallet | Total Weight | Actual Weight
A22052BBB | WO-22052 | 1061 | 3 | 2417
BBB212356 | WO-22053 | 1107 | 3 | 2749
Total
Spreadsheet: 47094d1246004068-copy-sheet-macro-test-results
Sheet: 1 (2)

 |  |  | A
 |  | Test Results | 2009-06-26 09:12:43
 |  | VO2 | 58
 |  | VJ | 60
 |  | 10m | 1.4
 |  | 30m | 4
 |  | Agility | 14
 | Strengths |  | Areas for improvement
 | VO2 |  | 10m
 | Agility |  | VJ
 |  |  | Agility
Spreadsheet: 802722d1666986791-index-match-return-result-which-formula-among-the-combination-is-satisfied-mpf_work_help
Sheet: Sheet1

slab id | primary slab | slab rate | overall rate | first mpf | last mpf | total mpf | match | mpf
1 | 100 | 8 | 10
 | 100 | 8 | 12
 | 100 | 8 | 15
 | 100 | 10 | 8
 | 100 | 10 | 12
 | 100 | 10 | 15
 | 100 | 12 | 8
 | 100 | 12 | 10
 | 100 | 12 | 15
 | 100 | 15 | 8
 | 100 | 15 | 10
 | 100 | 15 | 12
 | 200 | 8 | 10
 | 200 | 8 | 12
 | 200 | 8 | 15
 | 200 | 10 | 8
 | 200 | 10 | 12
 | 200 | 10 | 15
 | 200 | 12 | 8
 | 200 | 12 | 10
 | 200 | 12 | 15
 | 200 | 15 | 8
 | 200 | 15 | 10
 | 200 | 15 | 12
 | 300 | 8 | 10
 | 300 | 8 | 12
 | 300 | 8 | 15
 | 300 | 10 | 8
 | 300 | 10 | 12
 | 300 | 10 | 15
 | 300 | 12 | 8
 | 300 | 12 | 10
 | 300 | 12 | 15
 | 300 | 15 | 8
 | 300 | 15 | 10
 | 300 | 15 | 12
 | 0 | 8 | 0
 | 0 | 10 | 0
 | 0 | 12 | 0
 | 0 | 15 | 0
 | 0 | 16 | 0
 | 0 | 17 | 0
 | 0 | 20 | 0
Spreadsheet: 695650d1600329571-pivottable-formula-that-uses-values-from-pivot-table-book1
Sheet: Table

 | Modell | % | X
 | A | 0.128 | 546
 | B | -0.023 | 231
 | B | 0.018 | 21
 | C | 0.05 | 21321
 | C | 0.01 | 21321
 | A | -0.05 | 2132
 | A | -0.25
 | A | -0.03 | 546
 | A | 0.02 | 51651
 | D | -0.05 | 10
 | D | -0.0423 | 4141
 | C | -0.01 | 41
 | A | -0.01 | 10
 | B | -0.01
 | B | 0.05 | 1
 | C | 0.02
 | C | 0.03 | 10
 | A | 0.02 | 35
 | A | 0.05
 | C | 0.04 | 10
 | A | 0.12
 | D | -0.05
 | D | 0.09 | 10
 | C | 0.0333
 | A | 0.12
 | B | 0.08 | 10
 | B | -0.0333 | 3554
 | C | 0.04
 | C | -0.05 | 10
 | C | -0.02 | 1514
 | A | 0.05 | 10
 | B | 0.02 | 5416
 | B | 0.02 | 10
 | C | 0.06 | 546
 | C | 0.04 | 10
 | C | 0.08 | 10
 | C | 0.1 | 4684
 | D | 0.11 | 10
Spreadsheet: 329704d1404387922-look-up-with-multiple-values-project-hours
Sheet: data

ID | Name | Project ID | Hours
1111 | Arun | 144451 | 40
1111 | Arun | 144451 | 60
1111 | Arun | 144451 | 90
1111 | Arun | 144452 | 25
1111 | Arun | 144453 | 25
2222 | Arjun | 1333321 | 10
2222 | Arjun | 1555521 | 50
3333 | Raju | 1777721 | 120
Spreadsheet: 0b106858-f810-4a98-959f-8ed217704ea5
Sheet: Pers Deductions-Net Incom Wksht

PERSONAL DEDUCTIONS WORKSHEET
 | YOUR DEDUCTIONS : (IF YOU OWN A BUSINESS OR ARE SELF EMPLOYED, GO TO THE BUSINESS INCOME PAGE) |  |  |  |  |  |  |  |  |  |  |  | AMOUNT
 | Mandatory Monthly Paycheck Deductions
 | Fill out ALL of the applicable items:
1 | I have Federal Income Tax withheld every paycheck in the amount of
 | I have Social Security Taxes withheld every paycheck in the amount of
 | I have Medicare withheld every paycheck in the amount of
 | I have Union Dues withheld  every paycheck in the amount of
 | I have Court-ordered Child Support withheld every paycheck in the amount of
 | I have other Court-ordered garnishments withheld every paycheck in the amount of
 | I have health insurance premiums withheld every paycheck in the amount of
8 | List all other mandatory deductions, including amounts, withheld every paycheck:
 | Total MANDATORY Deductions Per Month
 | Voluntary Monthly Paycheck Deductions
 | Fill out ALL of the applicable items:
 | I have Life, Disability, &/or other insurance premiums withheld every paycheck in the amount of |  |  |  |  |  |  |  |  |  | 0
 | I have Federal Health Savings Plan every paycheck withheld in the amount of |  |  |  |  |  |  |  |  |  | 0
 | I have Retirement/Pension/IRA/401(k) withheld every paycheck in the amount of |  |  |  |  |  |  |  |  |  | 0
 | I have Savings withheld every paycheck in the amount of |  |  |  |  |  |  |  |  |  | 0
 | I have other (specify below) voluntary sums withheld every paycheck in the amount of |  |  |  |  |  |  |  |  |  | 0
 | List all other voluntary deductions, including amounts, withheld every paycheck: |  |  |  |  |  |  |  |  |  | 0
 | Total VOLUNTARY Deductions Per Month
 | TOTAL DEDUCTIONS PER MONTH
USE THIS SPACE BELOW FOR ANY NOTES/COMMENTS/EXPLANATION YOU WISH TO PROVIDE REGARDING YOUR DEDUCTIONS