tianzl66/Sheetpedia huggingface dataset:
Spreadsheet: 886155d1736190194-simple-count-question-count
Sheet: Sheet1

COUNTS |  |  |  |  |  |  |  |  |  | < because all are formulas
 |  |  |  |  |  |  |  |  |  | < don't count blank, but even though formula returns "", still counts
 |  |  |  |  |  |  |  |  |  | < basic COUNT counts numbers, but not alpha
 | Table 1 |  |  |  |  |  | Table 2
 | Col A | Col B | Col C | Col D | Col E |  | Col X | Col Y | Col Z
 | A55 | Native | More |  |  |  | [NAME] | Yes | 45
 | [NAME] | Native 2 | More |  |  |  | B22 | Yes
 | B22 | Native | More 1 |  |  |  | C35 | No | 35
 | C35 | Native 2 | More 2 |  |  |  | D11 | Maybe | 25
 | C54 | Native | More 1 |  |  |  | D44 | No | 15
 | D11 | Native | More |  |  |  | E65 | Yes | 55
 | D29 | Native 2 | More 2
 | D44 | Native | More 3
 | D80 | Native 2 | More 1
 | E65 | Native 2 | More
 | F13 | Native 2 | More 3
Spreadsheet: 47874d1247043677-layout-cell-reference-column-test-cell-reference
Sheet: Source

 |  | abc | bca | cab | def | efd | fde
 |  | 12 | 2 | 5 | 1 | 242
 |  | 53 | 45 |  |  |  | 24
 |  | 21 | 2 | 15
 |  | 5 | 1 |  | 2 | 24
Spreadsheet: 3e2968ce-8578-442c-ac6e-42eccd31db33
Sheet: Table 4.4

4.4 Business investment
Quarter | 2009–10 | 2010–11 | 2011–12 | 2012–13 | 2013-14
Chain volume measures (a) (b) – $ million
September | 45985 | 47831 | 61285 | 67810 | 65147
December | 48046 | 49749 | 60015 | 64769 | 62366
March | 46284 | 53008 | 63869 | 65128 | 62549
June | 47689 | 54727 | 66201 | 70861 | 63155
Annual | 188004 | 205315 | 251370 | 268568 | 253217
Annual change (b) – per cent
September | -8.465703252518008 | 4.014352506252039 | 28.12820137567687 | 10.64697723749695 | -3.927149387995876
December | -3.099852772119471 | 3.544519835157978 | 20.635590665139 | 7.921352995084563 | -3.710108230789422
March | -4.76347249943414 | 14.52769855673668 | 20.48936009658919 | 1.971222345738943 | -3.959894361872007
June | -1.922918723264233 | 14.75812032124808 | 20.96588521205256 | 7.039168592619438 | -10.87481125019404
Annual | -4.6 | 9.207782813131637 | 22.43138591919733 | 6.841707443211202 | -5.715870840904351
(a) Reference year for chain volume measures is 2011–12.
(b) Figures are seasonally adjusted.
Source: ABS, Australian National Accounts: National Income, Expenditure and Product,
cat. no. 5206.0, June 2014 release.
 |  |  |  |  |  |  |  | Update
 |  |  |  |  |  |  |  | 2014-12-03 00:00:00
Spreadsheet: 166114d1341473876-how-to-create-worksheet-template-not-workbook-template-copy-of-ct1-patient-log-aaaaa
Sheet: Lookup Table

Number | Fee | Number | Rebate 95% | Number | Rebate 85%
NR | 0 | NR | 0 | NR | 0
Y | 0 | Y | 0 | Y | 0
N | 0 | N | 0 | N | 0
P-Discount | 350 | P-Discount | 350 | P-Discount | 350
P | 440 | P | 440 | P | 440
PA | 176 | PA | 176 | PA | 176
C | 0 | C | 0 | C | 0
56001 | 195.05 | 56001 | 185.2975 | 56001 | 165.7925
56007 | 250 | 56007 | 237.5 | 56007 | 212.5
56013 | 250 | 56013 | 237.5 | 56013 | 212.5
56016 | 290 | 56016 | 275.5 | 56016 | 246.5
56022 | 225 | 56022 | 213.75 | 56022 | 191.25
56028 | 336.8 | 56028 | 319.96 | 56028 | 286.28
56030 | 225 | 56030 | 213.75 | 56030 | 191.25
56101 | 230 | 56101 | 218.5 | 56101 | 195.5
56107 | 340 | 56107 | 323 | 56107 | 289
56219 | 326.2 | 56219 | 309.89 | 56219 | 277.27
56220 | 240 | 56220 | 228 | 56220 | 204
56221 | 240 | 56221 | 228 | 56221 | 204
56223 | 240 | 56223 | 228 | 56223 | 204
56233 | 240 | 56233 | 228 | 56233 | 204
56237 | 240 | 56237 | 228 | 56237 | 204
56301 | 295 | 56301 | 280.25 | 56301 | 250.75
56307 | 400 | 56307 | 380 | 56307 | 340
56401 | 250 | 56401 | 237.5 | 56401 | 212.5
56407 | 360 | 56407 | 342 | 56407 | 306
56409 | 250 | 56409 | 237.5 | 56409 | 212.5
56412 | 360 | 56412 | 342 | 56412 | 306
56501 | 385 | 56501 | 365.75 | 56501 | 327.25
56507 | 480.05 | 56507 | 456.0475 | 56507 | 408.0425
56552 | 600 | 56552 | 570 | 56552 | 510
56554 | 600 | 56554 | 570 | 56554 | 510
56619 | 220 | 56619 | 209 | 56619 | 187
56625 | 334.65 | 56625 | 317.9175 | 56625 | 284.4525
56801 | 466.55 | 56801 | 443.2225 | 56801 | 396.5675
56807 | 560 | 56807 | 532 | 56807 | 476
57001 | 466.65 | 57001 | 443.3174999999999 | 57001 | 396.6525
57007 | 567.75 | 57007 | 539.3625 | 57007 | 482.5875
57341 | 470 | 57341 | 446.5 | 57341 | 399.5
57350 | 510 | 57350 | 484.5 | 57350 | 433.5
57351 | 510 | 57351 | 484.5 | 57351 | 433.5
57356 | 264.15 | 57356 | 250.9425 | 57356 | 224.5275
57360 | 700 | 57360 | 665 | 57360 | 595
18274 |  | 18274 | 0 | 18274 | 0
Spreadsheet: 71963d1272639135-two-criteria-for-sumif-sumif
Sheet: Summary

Week | Date | Status | Workflow 1 | Workflow 2 | Workflow 3 | Workflow 4 | Workflow 5 | Workflow 6 | Workflow 7 | Workflow 8 | Workflow 9 | Workflow 10 | Workflow 11 | Workflow 12 | Workflow 13 | Workflow 14 | Workflow 15 | Workflow 16 | Workflow 17 | Workflow 18 | Workflow 19 | Workflow 20 | Workflow 21 | Workflow 22 | Workflow 23 | Workflow 24 | Workflow 25 | Workflow 26 | Workflow 27 | Workflow 28 | Workflow 29 | Workflow 30 | Workflow 31 | Workflow 32 | Workflow 33 | Workflow 34 | Workflow 35 | Workflow 36 | Workflow 37 | Workflow 38 | Workflow 39 | Workflow 40 | Workflow 41 | Workflow 42 | Workflow 43 | Workflow 44 | Workflow 45 | Workflow 46 | Workflow 47 | Workflow 48 | Workflow 49 | Workflow 50 | Workflow 51 | Workflow 52 | Workflow 53 | Workflow 54 | Workflow 55 | Workflow 56 | Workflow 57 | Workflow 58 | Workflow 59 | Workflow 60 | Workflow 61 | Workflow 62 | Workflow 63 | Workflow 64 | Workflow 65 | [NAME] | [NAME]
Wk 14 | 2010-03-28 00:00:00 | REG
Wk 14 | 2010-03-28 00:00:00 | TEMP
Wk 15 | 2010-04-04 00:00:00 | REG
Wk 15 | 2010-04-04 00:00:00 | TEMP
Wk 16 | 2010-04-11 00:00:00 | REG
Wk 16 | 2010-04-11 00:00:00 | TEMP
Wk 17 | 2010-04-18 00:00:00 | REG
Wk 17 | 2010-04-18 00:00:00 | TEMP
Spreadsheet: 616f29c0-4ff7-4cf8-a542-fdbe0969c6ec
Sheet: Sheet1

Gene | Forward Primer | [NAME] | Amplicon Length (bp)
COL3A1 | ACGTAGATGAATTGGGATGCAG | GGGTTGGGGCAGTCTAGTG | 154
COL4A5 | GTCCACCAGGTACAGAAGGTC | CTCCTTTCAAACCAGGTAAGCC | 111
COL17A1 | AAGTCACCGAGAGAATTGTCAC | AGAGAGCCTGTCTTAGCATATCC | 100
UPK1A | TACACCCACCGCGACTATATG | CCACAACACTCTTGCTCAATCAT | 140
UPK1B | CACTGTTCGTTGCTTCCAGG | GCTTCGAGAAGTGGGTAAAGACT | 129
UPK2 | TGCCCCTGATCCTGATTCTG | CAAGGCAATTAACAGGCTTTCTG | 116
UPK3A | TTCGATAGCTCAGAGCCACTC | GCCGGAAAGTAGTGCTCAGT | 127
UPK3B | AGACCTGATTGCCTACGTGC | GGTGTCCTTAGTTGAGACATGCT | 124
CCL11 | GAATCACCAACAACAGATGCAC | ATCCTGGACCCACTTCTTCTT | 98
IL4 | TGGATCTGGGAGCATCAAGGT | TGGAAGTGCGGATGTAGTCAG | 65
CCL2 | TTAAAAACCTGGATCGGAACCAA | GCATTAGCTTCAGATTTACGGGT | 121
[NAME] | CTCCAAGCCAAAGTCCTTAGAG | GGAGCTGTCATTAGGGACATCA | 184
CD68 | CCATCCTTCACGATGACACCT | GGCAGGGTTATGAGTGACAGTT | 296
NOS2 | ACATCGACCCGTCCACAGTAT | CAGAGGGGTAGGCTTGTCTC | 177
CLDN8 | AGAGCCGCATCTTGCTGAC | TCTGATGATGGAATTGGCAACC | 95
GAPDH | AGGTCGGTGTGAACGGATTTG | TGTAGACCATGTAGTTGAGGTCA | 123
Spreadsheet: 865622d1712665392-sum-function-questions-on-call-calculation
Sheet: On-Call Comp

Date | Name | Comp-related standby time (hours) | Comp-related active oncall time (hours) | Weekend / Public Holiday
2024-02-19 00:00:00 | [NAME] | 5 | 0 | no |  | Jan Compensation |  |  | Jul Compensation
2024-02-20 00:00:00 | [NAME] | 5 | 0 | no |  | Hours at 20% |  |  | Hours at 20%
2024-02-21 00:00:00 | [NAME] | 5 | 0 | no |  | Hours at 150% | 0 |  | Hours at 150% |  |  |  | These are my attempts, none worked for the whole column, but a single cell only
2024-02-22 00:00:00 | [NAME] | 5 | 0 | no |  | Hours at 200% | 0 |  | Hours at 200%
2024-02-23 00:00:00 | [NAME] | 4 | 1 | no
2024-02-24 00:00:00 | [NAME] | 7 | 1 | yes
2024-03-18 00:00:00 | [NAME] | 5 | 0 | no |  | Feb Compensation |  |  | Aug Compensation
2024-03-19 00:00:00 | [NAME] | 5 | 0 | no |  | Hours at 20% |  |  | Hours at 20%
2024-03-20 00:00:00 | [NAME] | 5 | 0 | no |  | Hours at 150% | 0 | <- here should be 1 from D6 | Hours at 150%
2024-03-21 00:00:00 | [NAME] | 5 | 0 | no |  | Hours at 200% | 0 | <- here should be 1 from D7 | Hours at 200%
2024-03-22 00:00:00 | [NAME] | 5 | 0 | no
2024-04-08 00:00:00 | [NAME] | 5 | 0 | no |  | [NAME] |  |  | Sep Compensation
2024-04-09 00:00:00 | [NAME] | 5 | 0 | no |  | Hours at 20% |  |  | Hours at 20%
2024-04-10 00:00:00 | [NAME] | 5 | 0 | no |  | Hours at 150% |  |  | Hours at 150%
2024-04-11 00:00:00 | [NAME] | 5 | 0 | no |  | Hours at 200% |  |  | Hours at 200%
2024-04-12 00:00:00 | [NAME] | 3 | 2 | no
 |  |  |  |  |  | Apr Compensation |  |  | Oct Compensation
 |  |  |  |  |  | Hours at 20% |  |  | Hours at 20%
 |  |  |  |  |  | Hours at 150% |  |  | Hours at 150%
 |  |  |  |  |  | Hours at 200% |  |  | Hours at 200%
 |  |  |  |  |  | May Compensation |  |  | Nov Compensation
 |  |  |  |  |  | Hours at 20% |  |  | Hours at 20%
 |  |  |  |  |  | Hours at 150% |  |  | Hours at 150%
 |  |  |  |  |  | Hours at 200% |  |  | Hours at 200%
 |  |  |  |  |  | Jun Compensation |  |  | Dec Compensation
 |  |  |  |  |  | Hours at 20% |  |  | Hours at 20%
 |  |  |  |  |  | Hours at 150% |  |  | Hours at 150%
 |  |  |  |  |  | Hours at 200% |  |  | Hours at 200%
Spreadsheet: john_griffith__16189__1_30_02LO
Sheet: Sheet1

 |  |  | SCS  OPTION  DATA
 | TICKER | STRIKE | STR BID | STR ASK | B VOL | A VOL | M STD/DAY | WHEN
 | CL H2 | 19 | 165 | 175 | 53.8 | 57 | 0.66 | 2002-01-30 10:36:00
 | CL J2 | 19.5 | 265 | 285 | 49.3 | 53.1 | 0.63 | 2002-01-30 10:36:00
 | CL K2 | 19.5 | 350 | 365 | 49.5 | 51.6 | 0.62 | 2002-01-30 10:36:00
 | CL M2 | 19.5 | 395 | 410 | 47.8 | 49.6 | 0.6 | 2002-01-30 10:36:00
 | CL N2 | 19.5 | 440 | 450 | 46.8 | 47.9 | 0.58 | 2002-01-30 10:36:00
 | CL Q2 | 20 | 470 | 480 | 44.4 | 45.3 | 0.56 | 2002-01-30 10:36:00
 | CL U2 | 20 | 475 | 500 | 41.6 | 43.8 | 0.54 | 2002-01-30 10:36:00
 | [NAME] | 20 | 495 | 510 | 40.3 | 41.5 | 0.51 | 2002-01-30 10:36:00
 | CL X2 | 20 | 500 | 515 | 38.4 | 39.6 | 0.49 | 2002-01-30 10:36:00
 | [NAME] | 20 | 505 | 525 | 37 | 38.5 | 0.47 | 2002-01-30 10:36:00
 | CL F3 | 20 | 505 | 530 | 35.3 | 37 | 0.45 | 2002-01-30 10:36:00
 | CL G3 | 20 | 510 | 535 | 34.2 | 35.9 | 0.44 | 2002-01-30 10:36:00
 | CL M3 | 20.5 | 530 | 560 | 30.5 | 32.2 | 0.4 | 2002-01-30 10:36:00
 | CL Z3 | 20.5 | 540 | 570 | 27 | 28.6 | 0.36 | 2002-01-30 10:36:00
 | CL M4 |  |  |  | 21.8 | 24.4 | 0.31 | 2002-01-04 13:39:00
 |  |  |  |  |  |  |  | ,
Spreadsheet: 472264d1469522463-converting-data-between-tabs-department-performance-current
Sheet: 149798

149798
[NAME]
 | RCV Goal = 30 PPH |  |  | FH Goal = 30 PPH |  |  | [NAME] = 20 PPH
Week | RCV Qty | RCV Time | RCV PPH | FH  Qty | FH  Time | FH  PPH | RCH  Qty | RCH  Time | RCH  PPH | Average PPH | Total Time | Notes
2016-07-03 00:00:00 | 367 | 13.28 |  | 286 | 12.31 |  | 222 | 8.26
2016-07-10 00:00:00 | 653 | 21.15 |  | 41 | 3.26 |  | 0 | 0
2016-07-17 00:00:00 | 987 | 21.25 |  | 1065 | 21.05 |  | 230 | 12.36
2016-07-24 00:00:00
2016-07-31 00:00:00
2016-08-07 00:00:00
2016-08-14 00:00:00
2016-08-21 00:00:00
2016-08-28 00:00:00
2016-09-04 00:00:00
2016-09-11 00:00:00
2016-09-18 00:00:00
2016-09-25 00:00:00
2016-10-02 00:00:00
2016-10-09 00:00:00
2016-10-16 00:00:00
2016-10-23 00:00:00
2016-10-30 00:00:00
2016-11-06 00:00:00
2016-11-13 00:00:00
2016-11-20 00:00:00
2016-11-27 00:00:00
2016-12-04 00:00:00
2016-12-11 00:00:00
2016-12-18 00:00:00
2016-12-25 00:00:00
Spreadsheet: 149518d1333999041-identifying-first-occurrence-of-various-options-sample-workbook
Sheet: Sheet1

Unique ID | Activity | A Identifier | B Identifier | C Identifier | D Idenfitier | E Identifier | F Identifier
1 | A | 1
1 | A
1 | A
1 | B |  | 1
1 | C |  |  | 1
1 | D |  |  |  | 1
1 | E |  |  |  |  | 1
1 | E
22 | C |  |  | 1
22 | A | 1
333 | E |  |  |  |  | 1
333 | F |  |  |  |  |  | 1
Spreadsheet: 164820d1340899045-how-to-setup-summary-sheet-to-transfer-worksheet-data-chryspac-bse-invs
Sheet: Summary-Chy-Inv

CHRYS INVOICE CROSS CHECK WITH BSE INVOICES
CHRYSPAC INVOICE # | CHRYSPAC INVOICE DATE | TOTAL CHRYSPAC INVOICE AMOUNT | CHRY CALCULATED TOTAL LABOR PRICE ONLY | CHRYS CALCULATED TOTAL COMPONENT PRICE ONLY |  |  | COMPONENT PRICE THAT BSE SHOULD HAVE CHARGED CHRYSPAC
14668 | 6.8.2010 | 15138.11 | 3253.89 | 11884.22 |  |  | 11884.22
KEY FOR CALCULATING THE LABOR ONLY ON EACH ASSEMBLY |  |  |  |  |  | KEY FOR CALCULATING BSE'S INVOICE
P/N | Item Name | CHRYSPAC Labor Price Only | # Made | Our Total Labor Price |  | BSE Component price for full Assembly Only | BSE Component Price only | # Made | What BSE should be charging CHRYSPAC
144-0001 | 3/8" [NAME] | 5.13 | 220 | 1128.6 |  | 14.36 | 9.23 | 220 | 2030.6
144-0005 | [NAME] | 7.63 |  | 0 |  | 18.83 | 11.2 | 0 | 0
144-0001 | REWORKED 3/8" [NAME] | 3.39 |  | 0 |  |  | -3.39 | 0 | 0
144-0005 | [NAME] | 4.1 |  | 0 |  |  | -4.1 | 0 | 0
144-0007 | 25kv 8' Cross Arm | 17.11 | 90 | 1539.9 |  | 68.81 | 51.7 | 90 | 4653
144-0008 | 27kv Cut Outs | 7.83 | 53 | 414.99 |  | 86.37 | 78.54 | 53 | 4162.62
144-0014 | 10' Xarm | 11.36 | 15 | 170.4 |  | 80.56 | 69.2 | 15 | 1038
144-0022 | Pedestal | 14.14 |  | 0 |  | 120.48 | 106.34 | 0 | 0
144-0028 | 3-6kv Arrester | 23.3 |  | 0 |  | 212.57 | 189.27 | 0 | 0
144-0030 | 3-10kv Arrester | 23.3 |  | 0 |  | 227.27 | 203.97 | 0 | 0
144-0034 | 3-18kv Arrester | 23.3 |  | 0 |  | 244.85 | 221.55 | 0 | 0
0135-9703WE | # 6 Wire Tie (37 pieces per bundle) | 3.5 |  | 0 |  | 5.07 | 1.57 | 0 | 0
0135-9657WE | # 8 Wire Tie (50 pcs per bundle) | 4.63 |  | 0 |  | 5.39 | 0.7599999999999998 | 0 | 0
180-4400 | Wood Stakes | 0.78 |  | 0 |  | 5.83 | 5.05 | 0 | 0
0136-9831 | [NAME] cover, Warning Label | 0.063 |  | 0 |  | 1.72 | 1.657 | 0 | 0
0136-9833 | [NAME] cover, Warning Label | 0.063 |  | 0 |  | 1.75 | 1.687 | 0 | 0
74-4000 | Gas [NAME] | 7.32 |  | 0 |  |  | -7.32 | 0 | 0
CHRYSTAG | 2x6 with [NAME] | 0.11 |  | 0 |  | 5.41 | 5.3 | 0 | 0
CHRYSWARNSGN | Hi Voltage Sign | 0.22 |  | 0 |  | 4.28 | 4.06 | 0 | 0
CHRYS4TRAY | Tray- 4 place | 0.11 |  | 0 |  | 4.03 | 3.92 | 0 | 0
CHRYSJUMPER | # 4, 7 strnd with lug | 0.47 |  | 0 |  | 4.54 | 4.07 | 0 | 0
 |  |  | SUM | 3253.89 |  |  |  | SUM | 11884.22
Spreadsheet: 88358d1288194309-matching-between-two-sheets-and-pulling-info-onto-the-3rd-sheet-replies
Sheet: Info

 | CUSTOMER_KEY | HOME_LANGUAGE_CODE | CORRESPONDENCE_LANGUAGE_CODE | TITLE | INITIALS | FIRST_NAME | SURNAME | BUSTEL | RESTEL | CELL | EMAIL_ADDRESS | ID_NUMBER | PHYSICAL_ADDR_LINE_1 | PHYSICAL_ADDR_LINE_2 | PHYSICAL_CITY | PHYSICAL_POST_CODE | PHYSICAL_SUBURB | POSTAL_ADDR_LINE_1 | POSTAL_ADDR_LINE_2 | [NAME] | POSTAL_POST_CODE | POSTAL_SUBURB | campaign | OCCUPATIONAL_STATUS_CODE | TELEPHONE4 | SEQUENCE
Pull this info from Orginal file tab | Column AJ | Column H | Column H | Column B | Column C | Column D | Column E | Column S | Column T | Column R |  | Column A | Column i | Column J | Column K | Column L |  | Column M | Column N | Column O | Column P |  |  |  | Column AH
Spreadsheet: 196978d1354175521-min-max-axis-options-issue-songlengthsvswekscharted
Sheet: 2008

Artist | [NAME] | [NAME] | Weeks Charted
[NAME] | I'm Yours | 04:03:00 | 36
Ne-Yo | Closer | 03:55:00 | 35
Coldplay | Viva La Vida | 04:04:00 | 32
[NAME] | Love Remains the Same | 04:10:00 | 28
Saving Abel | Addicted | 03:43:00 | 27
[NAME] | Fall For You | 03:06:00 | 27
Rihanna | Disturbia | 03:59:00 | 26
[NAME] | Better in Time | 03:54:00 | 23
[NAME] | Spotlight | 04:10:00 | 21
[NAME] | Hot N Cold | 03:40:00 | 20
Spreadsheet: 355736d1414770987-populate-column-based-on-selection-from-a-dropdown-book2
Sheet: Sheet2

 | Low | Average | High
1 | 5 | 12 | 27
2 | 7 | 13 | 29
3 | 10 | 17 | 30
4 | 4 | 15 | 23
5 | 6 | 15 | 30
6 | 4 | 13 | 22
7 | 1 | 14 | 27
8 | 3 | 16 | 26
9 | 10 | 19 | 25
10 | 6 | 14 | 24
Spreadsheet: 710290d1608823105-access-data-with-conditional-timeline-report-ans
Sheet: TH

Report |  |  |  |  |  |  |  |  | Report
Time from | 2020-12-01 00:00:00 |  |  |  |  |  |  |  | Time from | 2020-12-01 00:00:00
Time to | 2020-12-04 00:00:00 |  |  |  |  |  |  |  | Time to | 2020-12-04 00:00:00
1. Customer Sales |  | Thanh cong |  |  |  |  |  |  | 1. Customer Sales |  | Thanh cong
Product | No. | Amount Actual day | Accumulation | % Complete |  |  |  |  | Product | No. | Amount Actual day | Accumulation | % Complete
 |  |  |  |  |  |  |  |  | Chocolate cake | 3616100 | 30000 | 110000 | 1.1
 |  |  |  |  |  |  |  |  | Custas cake | 3616102 | 15000 | 52000 | 0.52
 |  |  |  |  |  |  |  |  | 2. [NAME] hàng |  | The Sun
 |  |  |  |  |  |  |  |  | Product | No. | Amount Actual day | Accumulation | % Complete
 |  |  |  |  |  |  |  |  | Huong cake | 3616101 | 13000 | 50200 | 1.004
2. [NAME] hàng |  | The Sun
Product | No. | Amount Actual day | Accumulation | % Complete
Spreadsheet: 40714d1239116236-pull-out-the-top-five-most-common-numbers-in-a-block-of-numbers-top-five-numbers
Sheet: Sheet1

 |  | 5 | 2 | 6 | 5 | 5 |  |  | Top Five Numbers
 |  | 2 | 5 | 11 | 23 | 51 |  | 1
 |  | 13 | 53 | 15 | 12 | 3 |  | 2
 |  | 1 | 56 | 21 | 4 | 23 |  | 3
 |  | 2 | 4 | 21 | 7 | 8 |  | 4
 |  | 5 | 2 | 6 | 5 | 5 |  | 5
 |  | 2 | 5 | 11 | 23 | 51
 |  | 13 | 53 | 15 | 12 | 3
 |  | 1 | 56 | 21 | 4 | 23
 |  | 2 | 5 | 11 | 23 | 51
 |  | 13 | 53 | 15 | 12 | 3
 |  | 1 | 56 | 21 | 4 | 23
 |  | 5 | 56 | 21 | 4 | 23
 |  | 2 | 4 | 21 | 7 | 8
 |  | 5 | 2 | 6 | 5 | 5
 |  | 2 | 5 | 11 | 23 | 51
 |  | 1 | 5 | 5 | 5 | 5
 |  | 1 | 1 | 2 | 2 | 2
 |  | 23 | 23 | 23 | 23 | 23
 |  | 13 | 53 | 15 | 12 | 3
 |  | 5 | 56 | 21 | 4 | 23
 |  | 1 | 56 | 21 | 4 | 23
 |  | 2 | 4 | 21 | 7 | 8
 |  | 5 | 2 | 6 | 5 | 5
 |  | 2 | 5 | 11 | 23 | 51
 |  | 13 | 53 | 15 | 12 | 3
 |  | 1 | 56 | 21 | 4 | 23
Spreadsheet: 802518d1666891182-adding-a-further-criteria-excel-help
Sheet: Malaga

Holiday in Malaga, Spain
at Gran Hotel Cervantes
Wednesday 11th October to Wednesday 28th October
7 nights All-Inclusive, Transfers, 4 rounds with Buggies = |  |  |  |  |  | 799 |  |  | *Non-Golfer |  | 449 |  |  | 7 nights All-Inclusive, Transfers, 4 rounds inc Buggies
Not Inc: Flights available from Birmingham & Gatwick, Luton |  |  |  |  |  |  |  |  | **SINGLE SUPPLEMENT |  | 1044 |  |  | [NAME]
Golf |  |  |  |  |  |  |  |  |  |  |  |  |  | Non-Golfer
Golf at La Cala America, La Cala Asia, |  |  |  |  |  |  | La Cala Europa & Santa Monica
No | Room | NAME |  | PAID | BALANCE |  | No | Room | NAME |  | PAID | BALANCE
1 | 1 | CURT ([NAME]) | G | 0 |  |  | 12 | 7 | MITCHELL ([NAME]) | G | 0
2 |  | CURT (Sean) | G | 799 |  |  | 13 |  | [NAME] ([NAME]) | G | 0
3 | 2 | DONNELLY (Louise) | N/G | 0 |  |  | 14 | 8 | MUNTING ([NAME]) | G | 0
4 |  | DONNELLY ([NAME]) | G | 0 |  |  | 15
5 | 3 | DOWNER ([NAME]) | G | 0 |  |  | 16 | 9 | PYM (Carole) | N/G | 0
6 |  | FRANKS (Carlie) | N/G | 0 |  |  | 17 |  | PYM ([NAME]) | G | 0
7 | 4 | GIBOIN ([NAME]) | G | 0 |  |  | 18 | 10
8 |  |  |  |  |  |  | 19
9 | 5 | LOOM (Scott) | S/S | 0 |  |  | 20 | 11
10 | 6 | MARVESLEY ([NAME]) | G | 36 |  |  | 21
11 |  | MARVESLEY ([NAME])* | N/G | 35
 |  |  |  |  |  |  |  | IN
 |  |  |  |  |  |  |  | OUT
 |  |  |  |  |  |  |  |  | Total
Spreadsheet: 875341d1721926844-sum-based-on-multiple-criteria-demo-250724
Sheet: Vertical

Criteria marked in red font
 |  |  |  |  | Months
Main Vertical | PC Name | PC Code | FS Item/Acct/FA Long | GL Code | 2024-04-01 00:00:00 | 2024-05-01 00:00:00
Head Office | Head Offic | 629050001 | Fully Paid Equity Sh MMC /10010000 | 10010000 |  |  | <------Result
Franchisee | [NAME] | 629060001 | Fully Paid Equity Sh MMC /10010000 | 10010000 |  |  | <------Result
Franchisee | Fran East | 629060002 | Fully Paid Equity Sh MMC /10010000 | 10010000 |  |  | <------Result
Franchisee | Fran East | 629060003 | Fully Paid Equity Sh MMC /10010000 | 10010000 |  |  | <------Result
Head Office | Head Offic | 629050001 | Share Application Eq MMC /10050000 | 10050000 |  |  | <------Result
Franchisee | [NAME] | 629060001 | Share Application Eq MMC /10050000 | 10050000 |  |  | <------Result
Franchisee | Fran East | 629060002 | Share Application Eq MMC /10050000 | 10050000 |  |  | <------Result
Franchisee | Fran East | 629060003 | Share Application Eq MMC /10050000 | 10050000 |  |  | <------Result
Spreadsheet: 119202d1314266428-sumproduct-issue-book1-test
Sheet: Custom Filter

 |  |  |  |  |  |  | Year List |  | Year Calculation
 |  |  |  |  |  |  | 2011 to 2012 |  | 01/07/2011 | 30/06/2012
 |  |  |  |  |  |  | 2012 to 2013 |  | 0 | 0
 |  |  |  |  |  |  | 2013 to 2014 |  | 0 | 0
 |  |  |  |  |  |  | 2014 to 2015 |  | 0 | 0
 |  |  |  |  |  |  | 2015 to 2016 |  | 0 | 0
 |  |  |  |  |  |  | 2016 to 2017 |  | 0 | 0
 |  |  |  |  |  |  | A
 | Step 1: Select Date | 2011 to 2012
 | Step 2: Input File Number | 5118
 | 0
Spreadsheet: 920e0880-cb6e-4e1d-a2b6-3709beb5df31
Sheet: Sheet1

Unnamed: 0 | Unnamed: 1 | Unnamed: 2
 |  | U.S. Census Bureau
 |  | Source: Quarterly Services Survey
 |  | 51: Information: U.S. Total
 |  | Seasonally Adjusted Total Revenue [Millions of Dollars]
 |  | Period: 2003 to 2013
 |  | Data Extracted on: July 26, 2014 (9:10 am)
Period | Value
Q1-2003 | X
Q2-2003 | X
Q3-2003 | X
Q4-2003 | 229371
Q1-2004 | 229646
Q2-2004 | 233241
Q3-2004 | 235336
Q4-2004 | 237875
Q1-2005 | 242085
Q2-2005 | 244136
Q3-2005 | 247183
Q4-2005 | 247443
Q1-2006 | 250954
Q2-2006 | 254990
Q3-2006 | 258328
Q4-2006 | 262731
Q1-2007 | 263776
Q2-2007 | 266272
Q3-2007 | 270025
Q4-2007 | 272054
Q1-2008 | 276019
Q2-2008 | 278206
Q3-2008 | 280691
Q4-2008 | 273572
Q1-2009 | 267266
Q2-2009 | 267665
Q3-2009 | 268736
Q4-2009 | 271174
Q1-2010 | 273058
Q2-2010 | 275612
Q3-2010 | 279685
Q4-2010 | 281383
Q1-2011 | 283078
Q2-2011 | 290271
Q3-2011 | 293177
Q4-2011 | 293795
Q1-2012 | 297910
Q2-2012 | 301286
Q3-2012 | 303811
Q4-2012 | 309614
Q1-2013 | 311967
Q2-2013 | 314808
Q3-2013 | 320087
Q4-2013 | 326348
Spreadsheet: 56ebbad7-6586-4b12-a565-44ad430f5e31
Sheet: Sheet1

Unnamed: 0 | Unnamed: 1 | Unnamed: 2 | Unnamed: 3 | Unnamed: 4 | Unnamed: 5 | Unnamed: 6 | Unnamed: 7
GRADUATORIA  PROVVISORIA
-  NIDO D'INFANZIA COMUNALE  " IL COLIBRI' " -
[NAME]774  del 19.07.2011
ORDINE | L/D | COGNOME E NOME | PUNTEGGIO
 |  |  | A)                                      (condizione figlio) | B)                                          (condizione genitori) | C)                          (condizioni familiari particolari) | D)                                        (condizioni economiche                         in base all'I.S.E.E.) | TOTALE
1 | S | BONACCI GRETA | 0 | 14 | 9 | 5 | 28
2 | L | PESARESI DIEGO | 0 | 14 | 1 | 5 | 20
3 | L | FELICISSIMO OLIMPIA | 0 | 14 | 1 | 5 | 20
4 | S | BUFARINI MICHELE | 0 | 14 | 2 | 4 | 20
5 | S | [NAME] | 0 | 14 | 2 | 4 | 20
6 | L | AQUILANTI FABIO | 0 | 14 | 3 | 2 | 19
7 | L | TROZZI GIADA | 0 | 14 | 2 | 3 | 19
8 | S | ROSI DAVIDE | 0 | 14 | 2 | 2 | 18
9 | L | VIGNONI LEONARDO | 14 | 0 | 0 | 3 | 17
10 | L | GAMBELLI MATTEO | 0 | 14 | 1 | 2 | 17
11 | S | GIANNINI ANNA | 0 | 14 | 1 | 2 | 17
12 | S | SERINI MATTEO | 0 | 10 | 2 | 4 | 16
13 | L | AMBROSIO MARCO | 0 | 14 | 1 | 1 | 16
14 | S | MICARELLI NICOLO' | 0 | 14 | 1 | 1 | 16
15 | L | BASTIANINI CHIARA | 0 | 14 | 2 | 0 | 16
16 | L | FERRATO GIACOMO | 0 | 14 | 1 | 0 | 15
17 | L | ANASTASIO GEMMA | 0 | 10 | 1 | 4 | 15
18 | L | DE FILIPPO SOFIA | 0 | 14 | 1 | 0 | 15
19 | L | GIORGI LARA | 0 | 14 | 1 | 0 | 15
19 | S | MECARELLI GRETA | 0 | 14 | 1 | 0 | 15
21 | L | TINTI CRISTIAN | 14 | 0 | 0 | 0 | 14
22 | D | MARINELLI GABRIELE | 0 | 10 | 1 | 2 | 13
23 | L | MIGNUCCI ENRICO | 0 | 10 | 2 | 0 | 12
24 | D | MANCINI CRISTIAN | 0 | 10 | 1 | 0 | 11
25 | L | MANCINI GRETA | 0 | 10 | 1 | 0 | 11
25 | S | GAVRIL ALEXANDRA EMILIA | 0 | 10 | 1 | 0 | 11
27 | L | STORLAZZI EDOARDO | 0 | 6 | 0 | 0 | 6
27 | S | ROSSI TOMMASO | 0 | 6 | 0 | 0 | 6
29 | D | TOUJANI SOFIA | 0 | 4 | 0 | 0 | 4
30 | S | SOLFANELLI VIOLA | 0 | 14 | 0 | 5 | 19
31 | S | FILIPPONI LORENZO | 0 | 10 | 1 | 5 | 16
 | 19 | SI PROCEDERA' AL SORTEGGIO
 | 25 | SI PROCEDERA' AL SORTEGGIO
 | 27 | SI PROCEDERA' AL SORTEGGIO
 | 0.967741935483871 | NON RESIDENTE
 |  | POSTI DISPONIBILI:      n.20 di cui   n.11  lattanti -  n.4 semidivezzi e n.5 divezzi
 |  |  |  |  | IL CAPO II SETTORE
 |  |  |  |  | ([NAME]. Sandro Gregorini)
 |  | Montemarciano, 19 luglio 2011