tianzl66/Sheetpedia huggingface dataset:
Spreadsheet: 036b3e7e-f9f7-4abf-992d-ad3f0cdea135
Sheet: CDS-D

D. TRANSFER ADMISSION
 | Fall Applicants
D1 |  |  |  | Yes | No
D1 | Does your institution enroll transfer students?  (If no, please skip to Section E) |  |  | X
D1 | If yes, may transfer students earn advanced standing credit by transferring credits earned from course work completed at other colleges/universities? |  |  | X
D2 | Provide the number of students who applied, were admitted, and enrolled as degree-seeking transfer students in Fall 2011.
D2 |  | Applicants | Admitted Applicants | Enrolled Applicants
D2 | Men | 866 | 523 | 378
D2 | Women | 836 | 486 | 306
D2 | Total
 | Application for Admission
D3 | Indicate terms for which transfers may enroll:
D3 | Fall | x
D3 | Winter
D3 | Spring | x
D3 | Summer | x
D4 |  |  |  | Yes | No
D4 | Must a transfer applicant have a minimum number of credits completed or else must apply as an entering freshman? |  |  | X
D4 | If yes, what is the minimum number of credits and the unit of measure? |  |  | 24
D5 | Indicate all items required of transfer students to apply for admission:
D5 |  | Required of All | Recommended of All | Recommended of Some | Required of Some | Not Required
D5 | High school transcript |  |  |  | X
D5 | College transcript(s) | X
D5 | Essay or personal statement |  |  |  | X
D5 | Interview |  |  |  |  | X
D5 | Standardized test scores |  |  |  | X
D5 | Statement of good standing from prior institution(s) | X
D6 | If a minimum high school grade point average is required of transfer applicants, specify (on a 4.0 scale): |  |  | n/a
D7 | If a minimum college grade point average is required of transfer applicants, specify (on a 4.0 scale): |  |  | 2
D8 | List any other application requirements specific to transfer applicants:
D9 | List application priority, closing, notification, and candidate reply dates for transfer students. If applications are reviewed on a continuous or rolling basis, place a check mark in the “Rolling admission” column.
D9 |  | Priority Date | Closing Date | Notification Date | Reply Date | Rolling Admission
D9 | Fall |  |  |  |  | X
D9 | Winter
D9 | Spring |  |  |  |  | X
D9 | Summer |  |  |  |  | X
D10 |  |  |  | Yes | No
D10 | Does an open admission policy, if reported, apply to transfer students? |  |  | N/A
D11 | Describe additional requirements for transfer admission, if applicable:
 | Transfer Credit Policies
D12 | Report the lowest grade earned for any course that may be transferred for credit: |  |  | "C"
D13 |  |  |  | Number | Unit Type
D13 | Maximum number of credits or courses that may be transferred from a two-year institution: |  |  | NONE
D14 |  |  |  | Number | Unit Type
D14 | Maximum number of credits or courses that may be transferred from a four-year institution: |  |  | NONE
D15 | Minimum number of credits that transfers must complete at your institution to earn an associate degree: |  |  | 15 of last 20
D16 | Minimum number of credits that transfers must complete at your institution to earn a bachelor’s degree: |  |  | 30 of last 40
D17 | Describe other transfer credit policies:
Spreadsheet: 718861d1613396574-need-help-removing-non-duplicates-test
Sheet: Ark1

 | SellerID | GrossSales | NetSales
 | 1 | 335 | 335 |  |  |  | 335 | 335
 | 1 | 336 | 336 |  |  | 1 | 336 | 336
 | 2 | 337 | 337 |  |  | 2 | 337 | 337
 | 2 | 338 | 338 |  |  | 2 | 338 | 338
 | 2 | 339 | 340
 | 1 | 340 | 342
 | 1 | 341
 | 2 | 342
Spreadsheet: 145285d1331489459-data-table-function-inadequate-scenariosample
Sheet: Sheet1

 |  |  |  | 10000 | 1000 | 100
 |  |  | Entries |  |  |  | Project
 |  |  | Sum
 | Load
 | a |  | NAMES | Value 1 | Value 2 | Value 3 | TOTAL | Expected
 |  |  | A | 1 | 2 | 3
 |  |  | B | 4 | 5 | 6
 |  |  | C | 7 | 8 | 9
 |  |  | D | 10 | 11 | 12
 |  |  | E | 13 | 14 | 15
 |  |  | range | name
 |  |  | d7:g11 | entriestable
 |  |  | b6 | load
 |  |  | h4 | project
Spreadsheet: 757480d1638284604-get-results-from-large-data-in-excel-book2_3
Sheet: Sheet2

Short description | Symptom | Number | Created | Assignment group
[NAME] | NA | INC98457 | 2021-01-02 00:00:00 | DUMMYWORKPLACE NL
DUMMYISSUE | NA | INC98458 | 2021-01-03 00:00:00 | DUMMWOKRPLACE FRA
DUMMYISSUE | NA | INC98459 | 2021-01-04 00:00:00 | [NAME]
DUMMYISSUE | NA | INC98460 | 2021-01-05 00:00:00 | DUMMWOKRPLACE FRA
Problem_sdtsdfg | NA | INC98461 | 2021-01-06 00:00:00 | [NAME]
Problem_sdtsdfg | NA | INC98462 | 2021-01-07 00:00:00 | DUMMWOKRPLACE FRA
Problem with A | NA | INC98463 | 2021-01-08 00:00:00 | DUMMYWORKPLACE NL
Problem_AGN | NA | INC98464 | 2021-01-09 00:00:00 | DUMMWOKRPLACE FRA
Dummyissue | NA | INC98465 | 2021-01-10 00:00:00 | DUMMWOKRPLACE FRA
Problem with U | NA | INC98466 | 2021-01-11 00:00:00 | DUMMWOKRPLACE FRA
Spreadsheet: 86599d1286545513-color-formating-on-random-like-values-example
Sheet: Sheet1

Raw Data | Formatted
0C8A8%A%C8B1%E81B7E8 | 0C8A8%A%C8B1%E81B7E8
0C8A8%A%C8B1%E81B7E8 | 0C8A8%A%C8B1%E81B7E8
0X6E1X58C1%0E7&06BCE | 0X6E1X58C1%0E7&06BCE
0&%8%5E1X27BCC0A&421 | 0&%8%5E1X27BCC0A&421
14%8EA81B&%%%1X8208A | 14%8EA81B&%%%1X8208A
1%2151AB07E2X6468%&8 | 1%2151AB07E2X6468%&8
2818A07A%675A0A80A48 | 2818A07A%675A0A80A48
80627C88&CB&0A1%X2E2 | 80627C88&CB&0A1%X2E2
8821%5C%E855A%X0XA7X | 8821%5C%E855A%X0XA7X
8821%5C%E855A%X0XA7X | 8821%5C%E855A%X0XA7X
8821%5C%E855A%X0XA7X | 8821%5C%E855A%X0XA7X
8821%5C%E855A%X0XA7X | 8821%5C%E855A%X0XA7X
8821%5C%E855A%X0XA7X | 8821%5C%E855A%X0XA7X
8821%5C%E855A%X0XA7X | 8821%5C%E855A%X0XA7X
86X5E88B077&E5X6&8A2 | 86X5E88B077&E5X6&8A2
87%75C&66E&&CB5&7E&% | 87%75C&66E&&CB5&7E&%
4106&27120X85&21EEX& | 4106&27120X85&21EEX&
4&E&C4XC14147B58%28B | 4&E&C4XC14147B58%28B
5BXX10B0727572%2X67X | 5BXX10B0727572%2X67X
5BXX10B0727572%2X67X | 5BXX10B0727572%2X67X
5BXX10B0727572%2X67X | 5BXX10B0727572%2X67X
5C84B0A4A7%A7%&8605A | 5C84B0A4A7%A7%&8605A
5C84B0A4A7%A7%&8605A | 5C84B0A4A7%A7%&8605A
5C84B0A4A7%A7%&8605A | 5C84B0A4A7%A7%&8605A
5C84B0A4A7%A7%&8605A | 5C84B0A4A7%A7%&8605A
60C001BA7&%4CB0B8%5E | 60C001BA7&%4CB0B8%5E
6C2%7%8B&C0AXX86BC5A | 6C2%7%8B&C0AXX86BC5A
6C2%7%8B&C0AXX86BC5A | 6C2%7%8B&C0AXX86BC5A
6C2%7%8B&C0AXX86BC5A | 6C2%7%8B&C0AXX86BC5A
Spreadsheet: 788979d1658830816-countifs-across-multiple-sheets-with-2-criterias-thank-you-for-your-help-
Sheet: total

 | apple | orange | watermelon |  |  | Sheets
[NAME] |  |  |  |  |  | day1
bob |  |  |  |  |  | day2
caleb |  |  |  |  |  | day3
dominic
Spreadsheet: 138182d1327548737-calculating-probability-with-unknown-sample-mean-randomminoritycounter
Sheet: Sheet1

5 |  | 7 | << Count of less than 8 |  |  | 0 | 2
5 |  |  |  |  | Number of Minorities>> | 1 | 24
11 |  |  |  |  |  | 2 | 157
26 |  | 10000 | <<Number of random tries |  |  | 3 | 398
14 |  |  |  |  |  | 4 | 804
6 |  |  | Fill in the number of random tries |  |  | 5 | 1305
26 |  |  | and then run the |  |  | 6 | 1655
15 |  |  | RunRandCount Macro |  |  | 7 | 1736
11 |  |  |  |  |  | 8 | 1430
25 |  |  |  |  |  | 9 | 1123
16 |  |  |  |  |  | 10 | 717
6 |  |  |  |  |  | 11 | 386
3 |  |  |  |  |  | 12 | 160
8 |  |  |  |  |  | 13 | 69
18 |  |  |  |  |  | 14 | 24
14 |  |  |  |  |  | 15 | 6
22 |  |  |  |  |  | 16 | 4
23 |  |  |  |  |  | 17
15 |  |  |  |  |  | 18
27 |  |  |  |  |  | 19
28 |  |  |  |  |  | 20
12 |  |  |  |  |  | 21
3 |  |  |  |  |  | 22
10 |  |  |  |  |  | 23
6 |  |  |  |  |  | 24
10 |  |  |  |  |  | 25
14 |  |  |  |  |  | 26
26 |  |  |  |  |  | 27
 |  |  |  |  |  | 28
 |  |  |  |  |  |  | 10000
Spreadsheet: 765618d1643424808-double-lookup-lookup-example
Sheet: Sheet1

Worksheet 1:  Daily Stock Values in a Given Month |  |  |  |  |  |  |  |  |  |  | (Rightmost) | Worksheet 2:  What is the Current Value of Each Stock
 |  |  |  |  | E.g February |  | E.g March |  | End of list |  |  | Month | 2022-01-01 00:00:00 | 2022-02-01 00:00:00 | 2022-03-01 00:00:00
Ticker | 2022-01-03 00:00:00 | 2022-01-04 00:00:00 | 2022-01-05 00:00:00 | 2022-01-06 00:00:00 | 2022-02-03 00:00:00 | 2022-02-04 00:00:00 | 2022-03-05 00:00:00 | 2022-03-06 00:00:00 | 2022-12-06 00:00:00
AES | 24.38 | 24.45 | 23.33 | 23.24 | 49 | 11 | 44 | 36 | 44 |  |  | AES
BAGIX | 11.28 | 11.27 | 11.24 | 11.23 | 46 | 44 | 42 | 12 | 38 |  |  | BAGIX
DODIX | 14 | 14 | 13.96 | 13.94 | 18 | 29 | 43 | 38 | 28 |  |  | DODIX
EIX | 67.51 | 66.67 | 65.2 | 64.62 | 34 | 47 | 36 | 32 | 41 |  |  | EIX
Spreadsheet: 715051d1611521407-data-aggregations-with-index-and-matich-sample-aggrigations
Sheet: Sheet1

 |  |  |  |  |  |  |  |  |  |  |  |  |  | [NAME] | Baseball Glove | [NAME] | Track Shoes | [NAME] | [NAME] | Golf Balls | [NAME] | [NAME] | Barbells
 |  | [NAME] | [NAME] | Apparel | Equipment |  |  |  |  |  |  |  |  | [NAME] | 10 | 1 | 2 | 5 | 8 | 12 | 5 | 6 | 2
 |  | [NAME] |  |  |  |  |  |  |  |  |  |  |  | [NAME] | 8 | 30 | 16 | 20 | 18 | 7 | 5 | 3 | 10
 |  | [NAME] |  |  |  |  |  |  |  |  |  |  |  | [NAME] | 6 | 38 | 9 | 22 | 4 | 17 | 90 | 6 | 8
 |  | [NAME] |  |  |  |  |  |  |  |  |  |  |  | Sandy | 4 | 45 | 16 | 32.6666666666667 | 19 | 5 | 45 | 8 | 2
 |  | Sandy |  |  |  |  |  |  |  |  |  |  |  | [NAME] | 2 | 12 | 19.5 | 41.1666666666667 | 50 | 6 | 6 | 16 | 5
 |  | [NAME] |  |  |  |  |  |  |  |  |  |  |  | [NAME] | 0 | 19 | 23 | 49.6666666666667 | 36 | 45 | 8 | 14 | 9
 |  | [NAME] |  |  |  |  |  |  |  |  |  |  |  | [NAME] | 2 | 16 | 26.5 | 58.1666666666667 | 22 | 60 | 12 | 12 | 95
 |  | Terelle |  |  |  |  |  |  |  |  |  |  |  | Terelle | 5 | 9 | 30 | 66.6666666666667 | 0 | 9 | 18 | 9 | 74
 |  | [NAME] |  |  |  |  |  |  |  |  |  |  |  | [NAME] | 9 | 5 | 33.5 | 75.1666666666667 | 15 | 12 | 20 | 12 | 15
 |  | [NAME] |  |  |  |  |  |  |  |  |  |  |  | [NAME] | 16 | 4 | 0 | 83.6666666666667 | 5 | 88 | 25 | 13 | 38
 |  | [NAME] |  |  |  |  |  |  |  |  |  |  |  | [NAME] | 10 | 6 | 40.5 | 92.1666666666667 | 8 | 1 | 35 | 88 | 19
 |  | Brittany |  |  |  |  |  |  |  |  |  |  |  | [NAME] | 12 | 2 | 44 | 100.666666666667 | 3 | 30 | 40 | 19 | 20
 |  |  |  |  |  |  |  |  |  |  |  |  |  | Brittany | 14 | 8 | 47.5 | 109.166666666667 | 2 | 105 | 12 | 47 | 0
Spreadsheet: 792116d1660744601-tier-value-deductions-tier-math-deduction-example-4-
Sheet: Sheet1

Example 1
Allocated Units |  | 1123
Tier | Range |  |  | Charge |  | Balance @ Tier |  | Expected Answers
Tier 1 | 1 | 500 |  | 0.25 |  |  |  | 500
[NAME] | 501 | 1000 |  | 0.75 |  |  |  | 500
Tier 3 | 1001 | 1500 |  | 1 |  |  |  | 123
[NAME] | 1501 | 1600 |  | 1.25 |  |  |  | 0
Spreadsheet: 1fa71ccb-8ed2-454d-8b0d-feda38d540af
Sheet: Sheet1

Unnamed: 0 | Unnamed: 1 | Unnamed: 2 | Unnamed: 3 | Unnamed: 4 | Unnamed: 5 | Unnamed: 6 | Unnamed: 7 | Unnamed: 8 | Unnamed: 9 | Unnamed: 10 | Unnamed: 11
 | Time Series Workbook
 | 5671.0 Lending Finance, Australia
 | TABLE 7. LEASE AND COMMERCIAL FINANCE COMMITMENTS, Stocks and Flows: Australia, Original ($000)
Related Information: | Summary Publication | Explanatory Notes | Inquiries
 | Glossary
Data Item Description |  |  | Series Type | Series ID | Series Start | Series End | No. Obs. | Unit | Data Type | [NAME]. | Collection Month
Lease Finance - Total commitments ; |  |  | Original | A2413496R | 1985-01-01 00:00:00 | 2010-10-01 00:00:00 | 310 | $'000 | FLOW | Month | 1
Lease Finance - Commitments not drawn at end of month ; |  |  | Original | A2413497T | 1985-01-01 00:00:00 | 2010-10-01 00:00:00 | 310 | $'000 | FLOW | Month | 1
Revolving Credit - New and increased credit limits ; |  |  | Original | A2413498V | 1985-01-01 00:00:00 | 2010-10-01 00:00:00 | 310 | $'000 | FLOW | Month | 1
Revolving Credit - Cancellations and reductions ; |  |  | Original | A2413499W | 1985-01-01 00:00:00 | 2010-10-01 00:00:00 | 310 | $'000 | FLOW | Month | 1
Revolving Credit - Total credit limits at end of month ; |  |  | Original | A2413500V | 1985-01-01 00:00:00 | 2010-10-01 00:00:00 | 310 | $'000 | FLOW | Month | 1
Revolving Credit - Credit used at end of month ; |  |  | Original | A2413501W | 1985-01-01 00:00:00 | 2010-10-01 00:00:00 | 310 | $'000 | FLOW | Month | 1
© Commonwealth of Australia  2010
Spreadsheet: 876437d1723120335-count-the-occurance-from-a-cell-if-it-meets-2-criteria-gjjh25-book1-362-365-aligw
Sheet: Sheet1

 |  | Desired results |  |  | Concrete / Stone Surround | Pipe Diameter / Size |  | Length
 |  | 150 |  |  | Stone | 1200 |  | 49.5
 |  | 225 | 9.1 |  | Stone | 1200 |  | 39.7
 |  | 300 |  |  | Stone | 1200 |  | 33.5
 |  | 375 |  |  | Stone | 1200 |  | 51.75
 |  | 450 | 55.79999999999999 |  | Stone | 900 |  | 15.7
 |  | 525 |  |  | Concrete | 450 |  | 48
 |  | 600 |  |  | Stone | 1200 |  | 10
 |  | 675 |  |  | Concrete | 900 |  | 10.5
 |  | 750 |  |  | Stone | 1200 |  | 28.8
 |  | 800 |  |  | Stone | 1200 |  | 34
 |  | 825 |  |  | Stone | 1200 |  | 25.75
 |  | 900 | 10.5 |  | Stone | 1200 |  | 24
 |  | 1050 |  |  | Stone | 1200 |  | 23
 |  | 1200 | 14.2 |  | Stone | 1200 |  | 39.3
 |  | 1350 |  |  | Stone | 1200 |  | 13.5
 |  | 1400 |  |  | Stone | 1200 |  | 20.8
 |  | 1500 |  |  | Stone | 1200 |  | 6.5
 |  | 1600 |  |  | Concrete | 1200 |  | 14.2
 |  | 1650 |  |  | Stone | 1200 |  | 16
 |  | 1800 |  |  | Stone | 1200 |  | 18.5
 |  | 1950 |  |  | Stone | 1200 |  | 18
 |  | 2000 |  |  | Stone | 1200 |  | 43.5
 |  | 2100 |  |  | Concrete | 450 |  | 7.8
 |  | 2200 |  |  | Concrete | 225 |  | 3.6
 |  | 2250 |  |  | Concrete | 225 |  | 5.5
 |  | 2400 |  |  | Stone | 1200 |  | 26.6
Spreadsheet: 263965d1378741362-daily-data-conversion-to-monthly-totals-excelforum
Sheet: Sheet4

Years | Year | Count of Pcp
1916 |  | 366
1917 |  | 365
1918 |  | 365
1919 |  | 365
1920 |  | 366
1921 |  | 365
1922 |  | 365
1923 |  | 365
1924 |  | 366
1925 |  | 365
1926 |  | 365
1927 |  | 365
1928 |  | 366
1929 |  | 365
1930 |  | 365
1931 |  | 365
1932 |  | 366
1933 |  | 365
1934 |  | 365
1935 |  | 365
1936 |  | 366
1937 |  | 365
1938 |  | 365
1939 |  | 365
1940 |  | 366
1941 |  | 365
1942 |  | 365
1943 |  | 365
1944 |  | 366
1945 |  | 365
1946 |  | 365
1947 |  | 365
1948 |  | 366
1949 |  | 365
1950 |  | 365
1951 |  | 365
1952 |  | 366
1953 |  | 365
1954 |  | 365
1955 |  | 365
1956 |  | 366
1957 |  | 365
1958 |  | 365
1959 |  | 365
1960 |  | 366
1961 |  | 365
1962 |  | 365
1963 |  | 365
1964 |  | 366
1965 |  | 365
1966 |  | 365
1967 |  | 365
1968 |  | 366
1969 |  | 365
1970 |  | 365
1971 |  | 365
1972 |  | 366
1973 |  | 365
1974 |  | 365
1975 |  | 365
1976 |  | 366
1977 |  | 365
1978 |  | 365
1979 |  | 365
1980 |  | 366
1981 |  | 365
1982 |  | 365
1983 |  | 365
1984 |  | 366
1985 |  | 365
1986 |  | 365
1987 |  | 365
1988 |  | 366
1989 |  | 365
1990 |  | 365
1991 |  | 365
1992 |  | 366
1993 |  | 365
1994 |  | 365
1995 |  | 365
1996 |  | 366
1997 | Jan | 31
 | Feb | 28
 | Mar | 31
 | Apr | 30
 | May | 31
 | Jun | 30
 | Jul | 31
 | Aug | 31
 | Sep | 30
 | Oct | 31
 | Nov | 30
 | Dec | 31
Grand Total |  | 29951
Spreadsheet: 807262d1669823016-how-to-sumif-with-division-of-2-other-cells-example
Sheet: Sheet1

Variety | Container | PPP | QTY
Acaly | SLINER 50 | 2 | 800
Aptenia | SLINER 51 | 3 | 900
Coleus | SLINER 51 | 1 | 700
Fuchsia | SLINER 50 | 2 | 2000
Hedera Ivy | SLINER 72 | 1 | 1500
Lotus Vine | SLINER 51 | 4 | 1200
Rosemary | SHLINER 72 | 2 | 600
Tarragon | SHLINER 72 | 3 | 1800
Container | Total Trays
SLINER 50 | 28
SLINER 51 | 26
SLINER 72 | 21
SHLINER 72 | 12
Spreadsheet: 765558d1643385870-formula-for-missing-numbers-in-a-range-based-on-criteria-missing-number-ans
Sheet: Sheet1

Report # | Version # | Item # |  | Report | Version | Missing Items
20-A-1 | 0 | 1 |  | 20-A-1 | 0
20-A-1 | 0 | 3 |  | 20-A-1 | 1
20-A-1 | 1 | 1
20-A-1 | 1 | 5
21-B-2 | 0 | 1
21-B-2 | 0 | 2
Spreadsheet: 808449d1670472532-combine-2-sheets-grade33
Sheet: 5 BEST AND WEK FEMALE STUDENT

I. FIVE BEST FEMALE STUDENTS
NO | NAME | SEX M=1 &F=2 | SCHOOL | WARD | SUBJECTS |  |  |  |  |  |  |  |  |  |  |  | TOTAL | AVERAGE | GRADE
 |  |  |  |  | KISW |  | ENGL |  | HIS |  | SAY |  | M/JAM |  | URA
 |  |  |  |  | A | D | A | D | A | D | A | D | A | D | A | D
1
2
3
4
5
J. FIVE WEAK FEMALE STUDENTS
NO | NAME | SEX M=1 &F=2 | SCHOOL | WARD | SUBJECTS |  |  |  |  |  |  |  |  |  |  |  | TOTAL | AVERAGE | GRADE
 |  |  |  |  | KISW |  | ENGL |  | HIS |  | SAY |  | M/JAM |  | URA
 |  |  |  |  | A | D | A | D | A | D | A | D | A | D | A | D
1
2
3
4
5
Spreadsheet: 269175d1381008211-match-and-frequency-formula-fruit-state
Sheet: Example

State | Fruit | Count
WA | Apple | 4
WA | Apple | 4
WA | Apple | 4
WA | Apple | 4
WA | Peach | 1
ID | Apple | 3
ID | Apple | 3
ID | Apple | 3
OR | Pear | 3
OR | Pear | 3
OR | Pear | 3
CA | Orange | 2
CA | Orange | 2
Spreadsheet: 708542d1607925432-looking-formula-from-other-sheet-and-specific-column-sample-check
Sheet: lookup

SEGMEN-BUCKET | RO | SEGMENT | BUCKET | Loss Rate Nov
21 | 2 | OOO | 1 | 0.008245733055289644
22 | 2 | OOO | 2 | 0.08251497098306088
23 | 2 | OOO | 3 | 0.1885622772218451
24 | 2 | OOO | 4 | 0.278443662596005
25 | 2 | OOO | 5 | 0.4013723417819829
31 | 3 | OOO | 1 | 0.00845866999054447
32 | 3 | OOO | 2 | 0.09545138732200557
33 | 3 | OOO | 3 | 0.1960523673399772
34 | 3 | OOO | 4 | 0.2972278671695063
35 | 3 | OOO | 5 | 0.4223639001492558
41 | 4 | OOO | 1 | 0.004902302887784002
42 | 4 | OOO | 2 | 0.08859936856898892
43 | 4 | OOO | 3 | 0.181581375647561
44 | 4 | OOO | 4 | 0.251128332354749
45 | 4 | OOO | 5 | 0.362254226986679
51 | 5 | OOO | 1 | 0.007729791376086096
52 | 5 | OOO | 2 | 0.0792145917226583
53 | 5 | OOO | 3 | 0.1675166690739774
54 | 5 | OOO | 4 | 0.2335535212675079
55 | 5 | OOO | 5 | 0.3173373061941336
61 | 6 | OOO | 1 | 0.003620427136645969
62 | 6 | OOO | 2 | 0.06948185915873285
63 | 6 | OOO | 3 | 0.1511579421151339
64 | 6 | OOO | 4 | 0.2146829510151423
65 | 6 | OOO | 5 | 0.3208682078434202
151 | 15 | OOO | 1 | 0.01251153143479547
152 | 15 | OOO | 2 | 0.1339468787572012
153 | 15 | OOO | 3 | 0.244380539746422
154 | 15 | OOO | 4 | 0.3218812747113032
155 | 15 | OOO | 5 | 0.4742132107255655
Spreadsheet: 472437d1469600405-vlookup-is-not-pulling-information-accounts
Sheet: Sunil

NO. | IMEI | STATUS | CLIENT
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
32
33
34
35
36
37
38
39
40
41
42
43
44
45
46
47
48
49
50
51
52
53
54
55
56
57
58
59
60
61
62
Spreadsheet: 6cd2865b-556c-4076-ac52-c566879f1553
Sheet: Blue JV (CR05)

[NAME]
Student Journal Voucher
Student ID | Student Name | [NAME] | Description | Amount | Term | Comments / Explanation
 |  |  |  |  |  |  |  |  |  |  |  | 200880
 |  |  |  |  |  |  |  |  |  |  |  | 200910
 |  |  |  |  |  |  |  |  |  | T |  | 200950
 |  |  |  |  |  |  |  |  |  | F |  | 200980
 |  |  |  |  |  |  |  |  |  | R |  | 201010
 |  |  |  |  |  |  |  |  |  |  |  | 201050
 |  |  |  |  |  |  |  |  |  |  |  | 201080
 |  |  |  |  |  |  |  |  |  |  |  | 201110
 |  |  |  |  |  |  |  |  |  |  |  | 201150
 |  |  |  |  |  |  |  |  |  |  |  | 201180
 |  |  |  |  |  |  |  |  |  |  |  | 201210
 |  |  |  |  |  |  |  |  |  |  |  | 201250
 |  |  |  |  |  |  |  |  |  |  |  | 201280
Document Total/Hash Total:
Prepared By: |  |  |  | Approved By:
Spreadsheet: 57204d1257346632-date-format-quarter-and-fiscal-year-sample-quarter-date-question
Sheet: Pivot Table

Sum of Gross Sales | Column Labels
Row Labels | Q1 - 2007 | Q1 - 2008 | Q1 - 2009 | Q2 - 2007 | Q2 - 2008 | Q2 - 2009 | Q3 - 2007 | Q3 - 2008 | Q3 - 2009 | Q4 - 2007 | Q4 - 2008 | Q4 - 2009 | Grand Total
JUM 4 |  | 1659976 | 1954164 |  | 999274 |  |  | 411466 | 175638 | 599004 | 4745826 | 667424 | 11212772
[NAME] | 2810079 |  |  | 1157091 | 1676887 | 418622 |  | 690483 | 1961658 |  |  | 938924 | 9653744
ZEK 2 | 1011772 |  |  | 736841 | 1562079 |  | 1216871 | 1050825 | 1404977 |  | 407616 | 2392327 | 9783308
Grand Total | 3821851 | 1659976 | 1954164 | 1893932 | 4238240 | 418622 | 1216871 | 2152774 | 3542273 | 599004 | 5153442 | 3998675 | 30649824
Spreadsheet: 763292d1642095157-formula-not-returning-value-due-to-formatting-formula-formating-help
Sheet: Dollar

In reality below is the PIVOT TABLE (Copied & Pasted to break link)
 | 2021 | 2021 | 2021 | 2021 | 2021 | 2021 | 2021 | 2021 | 2021 | 2021 | 2021 | 2021 | 2022 | 2022 | 2022 | 2022
Row Labels | 1 | 2 | 3 | 4 | 5 | 6 | 7 | 8 | 9 | 10 | 11 | 12 | 1 | 2 | 3 | 4
Paint A | 0 |  |  |  | 0 |  |  | 0 | 0
Paint B | 119925.32 | -51487.37 | 105968.01 | -54238.89 | 6250.26 | -58891.88 | 31747.69 | 90084.99 | -62983.07 | -45293.19 | -37965 | 13218.18 | 84946.38 | 187698.32
Paint C
Paint D | 28200.21 | -22780.13 | -6615.6 | -59113.04 | 97575.75 | 74766.17 | 71488.36 | -9953.079999999998 | -71768.71 | 29223.13 | -124990.61 | -81009.84 | -27142.44 | 13058.46
Paint E | 0 |  |  |  | 0 |  |  | 0
Spreadsheet: 8de8d18d-0f26-4909-8248-2ea6f2fd0092
Sheet: Sheet1

PROG ID | ATHLETE ID | ATHLETE FIRST | ATHLETE LAST | NATIONALITY | START NUMBER | RUN | T1 | BIKE | T2 | SKI | POSITION | TOTAL TIME
7542 | 29863 | Romana | [NAME] | AUT | 57 | 00:23:47 | 00:00:44 | 00:39:23 | [NAME] | 00:32:31 | 1 | 01:37:22
7542 | 28253 | Margarita | Ovsyannikva | RUS | 56 | 00:25:25 | 00:00:36 | [NAME] | [NAME] | 00:35:58 | 2 | 01:40:47
7542 | 28247 | Tone | Dalen | NOR | 58 | 00:26:04 | 00:00:49 | 00:44:40 | 00:00:56 | 00:33:42 | 3 | 01:46:14
7542 | 56046 | Pauliina | Oksanen | FIN | 59 | 00:26:31 | 00:01:01 | 00:46:53 | 00:01:03 | [NAME] | 4 | 01:52:29
7542 | 46580 | [NAME] | Nevenchenko | RUS | 60 | 00:26:28 | [NAME] | 00:46:31 | 00:01:21 | 00:39:28 | 5 | 01:54:31
Spreadsheet: 221049d1363356762-if-then-vlookup-question-vlookup-if-then-1-
Sheet: Sheet2

 |  |  | Code | Description | Price
 |  |  | 1
 |  |  | 5
 |  |  | 4
 |  |  | 3
 |  |  | 2
 |  |  | 1
 |  |  | 1
 |  |  | 1
Spreadsheet: 735218d1622764717-repeat-for-annually-quarterly-between-2-dates-differing-due-date-frequencies-camp2-2-
Sheet: holidays_US

 | Schedule of Federal Banking Holidays for 2013 and 2014
 | Business Day:  "Monday through Friday, excluding federal banking holidays in the United States and Japan"
 | US Federal Banking Holidays (Federal Reserve)
 | www.federalreserve.gov/aboutthefed/k8.htm
 | Japan Federal Banking Holidays (Bank of Japan) |  | me:
 |  |  | http://www.timeanddate.com/holidays/japan/2016
 | Banking Holidays | Country | country | 2021 | 2022 | 2023 | 2024 | 2025 | 2026 | 2027
 | New Year's Day | USA |  | 2021-01-01 00:00:00
 | [NAME] | USA |  | 2021-01-18 00:00:00
 | [NAME]'s Day | USA |  | 2021-02-14 00:00:00
 | Washington's Birthday | USA |  | 2021-02-15 00:00:00
 | Tax Day | USA |  | 2021-04-15 00:00:00
 | Administrative Professionals Day | USA |  | 2021-04-21 00:00:00
 | Mother's Day | USA |  | 2021-05-09 00:00:00
 | Memorial Day | USA |  | 2021-05-31 00:00:00
 | Father's Day | USA |  | 2021-06-20 00:00:00
 | Independence Day | USA |  | 2021-07-04 00:00:00
 | Independence Day (substitute day) | USA |  | 2021-07-05 00:00:00
 | Labor Day | USA |  | 2021-09-06 00:00:00
 | Columbus Day | USA |  | 2021-10-11 00:00:00
 | Halloween | USA |  | 2021-10-31 00:00:00
 | Veterans Day | USA |  | 2021-11-11 00:00:00
 | Thanksgiving Day | USA |  | 2021-11-25 00:00:00
 | Day after Thanksgiving Day | USA |  | 2021-11-26 00:00:00
 | Christmas Eve | USA |  | 2021-12-24 00:00:00
 | Christmas Day (substitute day) | USA |  | 2021-12-24 00:00:00
 | Christmas Day | USA |  | 2021-12-25 00:00:00
 | New Year's Day (substitute day) | USA |  | 2021-12-31 00:00:00
 | New Year's Eve | USA |  | 2021-12-31 00:00:00
 |  | USA
 |  | USA
 |  | USA
 | below "quarters" is not being used in this workbook.  Source is from S&C's file.  Its not any holiday…just quarter displays
 | Quarter |  |  |  | 2014
 | Q1 |  |  |  | 2014-03-31 00:00:00
 | Q2 |  |  |  | 2014-06-30 00:00:00
 | Q3 |  |  |  | 2014-09-30 00:00:00
 | Q4 |  |  |  | 2014-12-31 00:00:00
Spreadsheet: 102590d1300528608-conditional-pop-up-box-conditional-popup-example-1-
Sheet: List

 | On
 | 00:00:00