tianzl66/Sheetpedia huggingface dataset:
Spreadsheet: 154625d1336497120-algorithm-to-create-single-entry-database-forecast-db-example
Sheet: FCST Template

 |  | 00:00:00 | 00:00:00 | 00:00:00 | 00:00:00 | 00:00:00 | 00:00:00 | 00:00:00 | 00:00:00 | 00:00:00 | 00:00:00 | 00:00:00 | 00:00:00
 | [NAME] FORECAST | Actual | Actual | Actual |  |  |  |  |  |  |  |  |  | Forecast
 |  | Jan | Feb | Mar | Apr | May | Jun | Jul | Aug | Sep | Oct | Nov | Dec | 2012
 | Revenue 1 A | 22 | 24 | 26 | 28 | 30 | 32 | 34 | 36 | 38 | 40 | 42 | 44
 | Revenue 1 B | 1.222 | 1.222 | 1.222 | 1.222 | 1.222 | 1.222 | 1.222 | 1.222 | 1.222 | 1.222 | 1.222 | 1.222
 | Revenue 1 C | 3.5 | 3.5 | 3.5 | 3.5 | 3.5 | 3.5 | 3.5 | 3.5 | 3.5 | 3.5 | 3.5 | 3.5
 | Total Revenue 1
 | Revenue 2 A | 6 | 6 | 6 | 6 | 6 | 6 | 6 | 6 | 6 | 6 | 6 | 6
 | Revenue 3 B | 7 | 7 | 7 | 7 | 7 | 7 | 7 | 7 | 7 | 7 | 7 | 7
 | Total Revenue 2
 | Total Revenue
 | Cost 1 | 5.58078 | 5.58078 | 5.58078 | 5.58078 | 5.58078 | 5.58078 | 5.58078 | 5.58078 | 5.58078 | 5.58078 | 5.58078 | 5.58078
 | Cost 2 | 7.89968 | 7.89968 | 7.89968 | 7.89968 | 7.89968 | 7.89968 | 7.89968 | 7.89968 | 7.89968 | 7.89968 | 7.89968 | 7.89968
 | Cost 3 | 0.25 | 0.25 | 0.25 | 0.25 | 0.25 | 0.25 | 0.25 | 0.25 | 0.25 | 0.25 | 0.25 | 0.25
 | Cost 4 | 11.0122 | 11.0122 | 11.0122 | 11.0122 | 11.0122 | 11.0122 | 11.0122 | 11.0122 | 11.0122 | 11.0122 | 11.0122 | 11.0122
 | Cost 5 | 1.50097 | 1.50097 | 1.50097 | 1.50097 | 1.50097 | 1.50097 | 1.50097 | 1.50097 | 1.50097 | 1.50097 | 1.50097 | 1.50097
 | Total Cost
 | Total Contribution
 |  | 00:00:00 | 00:00:00 | 00:00:00 | 00:00:00 | 00:00:00 | 00:00:00 | 00:00:00 | 00:00:00 | 00:00:00 | 00:00:00 | 00:00:00 | 00:00:00
 | April Forecast | Actual | Actual | Actual | Actual |  |  |  |  |  |  |  |  | Forecast
 |  | Jan | Feb | Mar | Apr | May | Jun | Jul | Aug | Sep | Oct | Nov | Dec | 2012
 | Revenue 1 A | 22 | 24 | 26 | 26 | 28 | 30 | 32 | 34 | 36 | 38 | 40 | 42
 | Revenue 1 B | 1.222 | 1.222 | 1.222 | 1.222 | 1.222 | 1.222 | 1.222 | 1.222 | 1.222 | 1.222 | 1.222 | 1.222
 | Revenue 1 C | 3.5 | 3.5 | 3.5 | 1.5 | 1.5 | 1.5 | 1.5 | 1.5 | 1.5 | 1.5 | 1.5 | 1.5
 | Total Revenue 1
 | Revenue 2 A | 6 | 6 | 6 | 6 | 6 | 6 | 6 | 6 | 6 | 6 | 6 | 6
 | Revenue 3 B | 7 | 7 | 7 | 7 | 7 | 7 | 7 | 7 | 7 | 7 | 7 | 7
 | Total Revenue 2
 | Total Revenue
 | Cost 1 | 5.58078 | 5.58078 | 5.58078 | 5.58078 | 5.58078 | 5.58078 | 5.58078 | 5.58078 | 5.58078 | 5.58078 | 5.58078 | 5.58078
 | Cost 2 | 7.89968 | 7.89968 | 7.89968 | 7.89968 | 7.89968 | 7.89968 | 7.89968 | 7.89968 | 7.89968 | 7.89968 | 7.89968 | 7.89968
 | Cost 3 | 0.25 | 0.25 | 0.25 | 0.25 | 0.25 | 0.25 | 0.25 | 0.25 | 0.25 | 0.25 | 0.25 | 0.25
 | Cost 4 | 11.0122 | 11.0122 | 11.0122 | 11.0122 | 11.0122 | 11.0122 | 11.0122 | 11.0122 | 11.0122 | 11.0122 | 11.0122 | 11.0122
 | Cost 5 | 1.50097 | 1.50097 | 1.50097 | 1.50097 | 1.50097 | 1.50097 | 1.50097 | 1.50097 | 1.50097 | 1.50097 | 1.50097 | 1.50097
 | Total Cost
 | Total Contribution
Spreadsheet: darrell_schoolcraft__7325__imball0202
Sheet: WTGmktg

 | /------------------------------------------  contract 22100  --------------------------------------------------------\
 | 10811 |  | 13234 |  | 16540 |  | 500648
 | Follet |  | Oasis Dairy Farms |  | WTG/TW Winker |  | Sum WTG New Mex
Day | Measured | Scheduled | Measured | Scheduled | Measured | Scheduled | Measured | Scheduled
1 | -194 | -143 |  |  | -1253 | -786
2 | -183 | -143 |  |  | -1189 | -786
3 | -164 | -143 |  |  | -1051 | -786
4 | -162 | -143 |  |  | -1329 | -786
5 | -175 | -143 |  |  | -1492 | -786
6 | -165 | -143 |  |  | -1260 | -786
7 | -135 | -143 |  |  | -1019 | -786
8 | -115 | -143 |  |  | -838 | -786
9 | -233 | -143 |  |  | -1113 | -786
10 | -202 | -143 |  |  | -1390 | -786
11 | -154 | -143 |  |  | -1253 | -786
12 | -160 | -143 |  |  | -1211 | -786
13 | -143 | -143 |  |  | -1225 | -786
14 | -133 | -143 |  |  | -933 | -786
15 | -128 | -143 |  |  | -981 | -786
16 | -104 | -143 |  |  | -840 | -786
17 | -98 | -143 |  |  | -951 | -786
18 | -94 | -143 |  |  | -565 | -786
19 | -111 | -143 |  |  | -808 | -786
20 | -90 | -143 |  |  | -700 | -786
21 | -125 | -143 |  |  | -1086 | -786
22 | -94 | -143 |  |  | -850 | -1278
23 | -64 | -143 |  |  | -552 | -1278
24
25
26
27
28
29
30
31
2002-01-31 00:00:00 |  |  |  |  |  |  |  |  | -37189.77
2002-02-23 00:00:00
CBS Volume
 |  |  | -4227
Spreadsheet: 829028d1683864351-formulas-to-have-multiple-result-in-one-cell-exam2
Sheet: Sheet1

SOURCE A |  |  |  |  |  |  |  |  | wokring Paper
 | STO NO | MODEL | STO Qty |  |  |  |  |  | STO NO | MODEL | Uniq Code | STO Qty | DN No | Ttl QTY DN | Open STO
 | 450012211 | ABCD | 200 |  |  |  |  |  | 450012211 | ABCD |  | 200
 | 450012211 | BCDE | 200 |  |  |  |  |  | 450012211 | BCDE |  | 200
 |  |  |  |  |  |  |  |  |  |  |  |  | Need formula in Yellow Highlighted
SOURCE B
 | STO NO | MODEL | DN No | MODEL | Uniq Code | DN Qty
 | 450012211 | ABCD | 810001 | ABCD |  | 100
 | 450012211 | ABCD | 810002 | ABCD |  | 50
 | 450012211 | ABCD | 810006 | ABCD |  | 50
 | 450012211 | BCDE | 810001 | BCDE |  | 50
 | 450012211 | BCDE | 810002 | BCDE |  | 100
Spreadsheet: kate_symes__18393__Palo
Sheet: DJ Palo Verde Electricity Index

 |  |  | Firm | Volume | Firm | Volume | Non Firm | Volume | Non Firm | Volume |  | Sunday & NERC | Volume
 | DATE |  | On [NAME] | [NAME] | [NAME] | [NAME] | On [NAME] | [NAME] | [NAME] | [NAME] |  | 24 HOUR | [NAME]
 | 2000-12-27 00:00:00 |  | 232 | 10048 | 123.85 | 728
 | 2000-12-26 00:00:00 |  | 250.55 | 12960 | 173.75 | 800 | 124.75 | 1488 | 90.47 | 590
 | 2000-12-25 00:00:00 |  | 217.21 | 2080 | 175 | 0 | 78.91 | 709 | 55.11 | 871 |  | 204.22 | 10800
 | 2000-12-24 00:00:00 |  | 217.21 | 2080 | 175 | 0 | 92.39 | 584 | 65.56 | 160 |  | 204.22 | 10800
 | 2000-12-23 00:00:00 |  | 276.77 | 11728 | 192.64 | 2800 | 140 | 35 | 121.09 | 184
 | 2000-12-22 00:00:00 |  | 276.77 | 11728 | 192.64 | 2800 | 267.5 | 0 | 80 | 375
 | 2000-12-21 00:00:00 |  | 276.77 | 11728 | 192.64 | 2800 | 252.65 | 1831 | 132.45 | 530
 | 2000-12-20 00:00:00 |  | 269.33 | 15200 | 190.33 | 2688 | 198.54 | 3261 | 151.82 | 927
 | 2000-12-19 00:00:00 |  | 258.18 | 10272 | 178.86 | 1968 | 195.85 | 2305 | 133.46 | 718
 | 2000-12-18 00:00:00 |  | 224.43 | 11840 | 176.78 | 1168 | 220.89 | 1072 | 124.85 | 495
 | 2000-12-17 00:00:00 |  | 196.67 | 1200 | 175.71 | 280 | 136.93 | 985 | 113.5 | 500 |  | 177.12 | 2664
 | 2000-12-16 00:00:00 |  | 233.65 | 12880 | 192.27 | 2704 | 130.23 | 922 | 120.83 | 60
 | 2000-12-15 00:00:00 |  | 238.8 | 13024 | 192.27 | 2704 | 180.19 | 1670 | 128.18 | 706
 | 2000-12-14 00:00:00 |  | 334.66 | 15184 | 213.55 | 2480 | 200 | 150 | 174.54 | 271
 | 2000-12-13 00:00:00 |  | 495.62 | 14992 | 223.93 | 4504 | 276 | 3139 | 184.69 | 2161
 | 2000-12-12 00:00:00 |  | 330 | 9200 | 211.98 | 2688 | 347.7 | 2622 | 193.04 | 1826
 | 2000-12-11 00:00:00 |  | 414.56 | 9200 | 213.96 | 2480 | 204.38 | 2263 | 187.04 | 1280
 | 2000-12-10 00:00:00 |  | 254.96 | 2160 | 217.63 | 2280 | 180.88 | 1906 | 161.34 | 780 |  | 172.02 | 600
 | 2000-12-09 00:00:00 |  | 317.74 | 14000 | 176.98 | 2608 | 189.51 | 1364 | 138.71 | 403
 | 2000-12-08 00:00:00 |  | 317.74 | 14000 | 176.98 | 2608 | 290.86 | 1368 | 205.28 | 799
 | 2000-12-07 00:00:00 |  | 262.73 | 15808 | 174.55 | 2816 | 241.93 | 1455 | 118.5 | 865
 | 2000-12-06 00:00:00 |  | 250.5 | 23472 | 154.65 | 3232 | 283.47 | 2363 | 157.27 | 595
 | 2000-12-05 00:00:00 |  | 227.52 | 24992 | 101.29 | 3072 | 232.74 | 2743 | 129.08 | 673
 | 2000-12-04 00:00:00 |  | 190.1 | 29792 | 122.57 | 3880 | 162.07 | 2138 | 113.27 | 707
 | 2000-12-03 00:00:00 |  | 131.13 | 1600 | 119.17 | 600 | 107.99 | 2405 | 107.67 | 1422 |  | 122.75 | 11040
 | 2000-12-02 00:00:00 |  | 137.08 | 30464 | 72.7 | 2560 | 118.37 | 1436 | 90.96 | 1103
 | 2000-12-01 00:00:00 |  | 137.11 | 30144 | 72.7 | 2560 | 118.32 | 2042 | 90.99 | 855
 | 2000-11-30 00:00:00 |  | 171.25 | 27456 | 82.58 | 2392 | 129.11 | 2102 | 91.19 | 576
 | 2000-11-29 00:00:00 |  | 172.05 | 26336 | 87.15 | 3328 | 109.18 | 1495 | 95.66 | 607
 | 2000-11-28 00:00:00 |  | 129.76 | 22496 | 80.75 | 2568 | 119.59 | 2075 | 96.18 | 1478
 | 2000-11-27 00:00:00 |  | 152.95 | 26240 | 92.28 | 1800 | 121.75 | 2397 | 79.26 | 1760
Spreadsheet: 67085d1267713025-adding-data-over-existing-chart-720326
Sheet: Jean Pierre Soullière

 |  | Ligue de Billard De Cowansville
 |  | Points | Mon pointage | Pos. | Résultats | Pos. | Résultats | Pos. | [NAME]
 |  | Aujourdui | Aujourdui | Avant Noël |  | Après Noël
 | Joueurs |  |  |  |  |  |  | Pourcentage actuel
1 |  |  | Partie [NAME] = 2 pts
2 |  |  | Partie Perdue = 1 pts
3
4
5
6
7
8
9
10
11
12
13
14 |  |  | Total Possible
15 |  |  | de la journée
16
17
18
19
20
21 |  | * * * * *
22
23
24
25
Spreadsheet: 9c198b86-8b90-4221-aebe-bf971c90b0ee
Sheet: Sheet1

LABEL | UPC | ARTIST | TITLE | RELEASEDATE | PRODUCTTYPE | GENRE | PRICE | [NAME] | STATUS
Taseis | 14998416224 | [NAME] | Instrument Of Praise | 2007-09-11 | Compact Disc | Ac | 9.99 | Y | Available
Spreadsheet: 2080321e-790b-4a15-8a0c-5f809f3f17e9
Sheet: Sheet1

Test Referenced | Entry Type | Mayo ID | Description | Reporting Description | Method | Collection Container | Temperature | Stability | [NAME] | Unit of Measure | [NAME] | Minimum Volume | Reject Due To | Reference Values | Days/Times Performed | Analytic Time | Maximum Lab Time | CPT Units | CPT Code | LOINC® Code | LOINC® Attributes | Always Performed | Orderable Separately | Performing Location
5207 | Test | 5207 | Surgical Pathology, [NAME] | [NAME], Frozen Section Exam |  | Varies: Var |  |  |  | Varies |  |  | Specimens other than	NA Anticoagulants other than	NA Hemolysis	NA Thawing	NA Lipemia	NA Icteric	NA |  | Monday through Friday Upon arrival | 2 days | 8 days | 1 | 88331 |  |  |  |  | Rochester
5207 | Result | 5207 | Surgical Pathology, Frozen$Section | Surgical Pathology, Frozen$Section
Spreadsheet: 840635d1692880813-provident-fund-calulator-with-multiple-criteria-pf-calculator
Sheet: SALARY DEC 2022

 |  | YEAR
 |  | 2024 | [NAME] | PF RATE |  | Salary | Age | provident fund
 |  | AGE |  |  |  | 5000 | 52
 |  | <55 | <50 | 0 |  | 500 | 63
 |  |  | >50 to 500 | 0.17 |  | 7000 | 56
 |  |  | >500 to 750 | 0.176 |  | 5500 | 71
 |  |  | >750 | 0.37 |  | 3000 | 66
 |  | 55 TO 60 | <50 | 0
 |  |  | >50 to 500 | 0.145
 |  |  | >500 to 750 | 0.1495
 |  |  | >750 | 0.295
 |  | 60-65 | <50 | 0
 |  |  | >50 to 500 | 0.11
 |  |  | >500 to 750 | 0.11285
 |  |  | >750 | 0.205
 |  | 65-70 | <50 | 0
 |  |  | >50 to 500 | 0.085
 |  |  | >500 to 750 | 0.0871
 |  |  | >750 | 0.155
 |  | ABOVE 70 | <50 | 0
 |  |  | >50 to 500 | 0.075
 |  |  | >500 to 750 | 0.0765
 |  |  | >750 | 0.125
Spreadsheet: 69351d1269893286-split-a-cell-function-test
Sheet: February

February Photo Shoot Count - 2010
February |  | Ecomm | Selections | Newspaper | Public Relations | [NAME]. | Misc | Totals
1 |  | 10 |  |  |  |  | 100 | 110
2 |  | 17 |  | 6 |  |  |  | 23
3 |  | 6 |  | 16 |  |  |  | 22
4 |  | 35 |  |  |  |  |  | 35
5 |  | 10 |  |  |  |  |  | 10
6 |  |  |  |  |  |  |  | 0
7 |  |  |  |  |  |  |  | 0
8 |  | 14 |  |  |  | 6 |  | 20
9 |  | 11 |  |  |  |  |  | 11
10 |  |  |  | 5 |  |  | 6 | 11
11 |  | 12 |  |  | 27 |  |  | 39
12 |  | 12 |  |  | 20 |  |  | 32
13 |  |  |  |  |  |  |  | 0
14 |  |  |  |  |  |  |  | 0
15 |  | 9 | 11 |  |  |  |  | 20
16 |  | 10 | 15 |  |  |  |  | 25
17 |  | 8 | 15 |  | 8 |  |  | 31
18 |  | 10 | 5 |  | 8 |  |  | 23
19 |  | 9 | 18 |  | 9 |  |  | 36
20 |  |  |  |  |  |  |  | 0
21 |  |  |  |  |  |  |  | 0
22 |  | 16 | 9 |  | 9 |  |  | 34
23 |  | 18 | 6 |  |  |  |  | 24
24 |  | 19 | 4 |  |  |  |  | 23
25 |  | 10 |  |  |  | 33 |  | 43
26 |  | 10 | 1 |  |  |  |  | 11
27 |  |  |  |  |  |  |  | 0
28 |  |  |  |  |  |  |  | 0
 |  |  |  |  |  |  |  | 0
 |  |  |  |  |  |  |  | 0
 |  |  |  |  |  |  |  | 0
Totals |  | 246 | 84 | 27 | 81 | 39 | 106
 |  |  |  |  |  |  | Month Total | 583
Spreadsheet: 806154d1669132008-if-formula-result-based-on-greater-than-or-less-than-with-sum-excel-forum-example
Sheet: Sheet1

House | [NAME] | Salesperson | Label | Cs (LY) | [NAME] | Cs  to Go | $5 / Cs | Met LY? | $30 / Cs | TOTAL PAYOUT |  |  |  |  | Should Be
Virtual | OFF | AGENT A | Product 1 | 1 | 0 |  |  |  |  |  |  |  |  |  | 0
Virtual | OFF | AGENT A | Product 2 | 4 | 0 |  |  |  |  |  |  |  |  |  | 0
Virtual | OFF | AGENT A | Product 3 | 7 | 0 |  |  |  |  |  |  |  |  |  | 0
Virtual | OFF | AGENT A | Total | 12 | 0
Virtual | OFF | AGENT B | Product 2 | 2 | 4
Virtual | OFF | AGENT B | Total | 2 | 0
Virtual | OFF | AGENT C | Product 1 | 1 | 1 |  |  |  |  |  |  |  |  |  | 5
Virtual | OFF | AGENT C | Product 2 | 1 | 0 |  |  |  |  |  |  |  |  |  | 0
Virtual | OFF | AGENT C | Product 3 | 0 | 1 |  |  |  |  |  |  |  |  |  | 30
Virtual | OFF | AGENT C | Total | 1 | 1
Virtual | OFF | AGENT D | Product 1 | 0 | 10 |  |  |  |  |  |  |  |  |  | 300
Virtual | OFF | AGENT D | Product 2 | 1 | 5
Virtual | OFF | AGENT D | Product 3 | 1 | 1 |  |  |  |  |  |  |  |  |  | 5
Virtual | OFF | AGENT D | Total | 1 | 1
Spreadsheet: 137847d1327409124-ytd-average-required-saluti
Sheet: Sheet1

 |  | HQ | STOKIST | SALE | OCT | NOV | DEC | JAN | FEB | [NAME] | OCT-MARCH | OCT-MARCH
 |  |  |  |  | VALUE | VALUE | VALUE | VALUE | VALUE | VALUE | TOTAL | YPM
 |  | ASANSOL | B.K.MEDICAL AGENCY | PRI | 64104 |  | 23996 | 100000 |  |  | 188100 | 47025
 |  |  |  | SEC |  |  |  |  |  |  | 0 | 0
 |  |  | HINDUSTAN DISTRIBUTOR | PRI |  | 14517 | 33414 |  |  |  | 47931 | 15977
 |  |  |  | SEC |  |  |  |  |  |  | 0 | 0
 |  | ASANSOL TOTAL |  | PRI | 64104 | 14517 | 57410 | 100000 | 0 | 0 | 236031 | 59007.75
 |  |  |  | SEC | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0
 |  | BURDWAN | CHOWDHURY AGENCY | PRI |  |  | 19546 |  |  |  | 19546 | 6515.333333333333
 |  |  |  | SEC |  |  | 6587 |  |  |  | 6587 | 2195.666666666667
 |  |  | JASHODA PHARMACY | PRI | 76195 |  | 14517 |  |  |  | 90712 | 30237.33333333333
 |  |  |  | SEC |  |  |  |  |  |  | 0 | 0
 |  | BURDWAN TOTAL |  | PRI | 76195 | 0 | 34063 | 0 | 0 | 0 | 110258 | 36752.66666666666
 |  |  |  | SEC | 0 | 0 | 6587 | 0 | 0 | 0 | 6587 | 2195.666666666667
Spreadsheet: 328127d1403790902-math-function-returning-wrong-number-book2
Sheet: Sheet1

 | Empoyee or Rate Class |  | DAYS | HOURS | PAY PER | Ins Adder | COST PER | TOTAL
 | APP 1 |  | 0 | 0 |  | 3 |  |  |  | DROP DOWN LIST
 |  |  |  |  |  | 0 |  |  |  | MANUAL ENTRY REQUIRED
 | APP 1 |  | 0 | 0 |  | 3 |  |  |  | LOCKED CELL
 |  |  | 15 |  |  | 0 |  |  |  | OUTPUT
 | APP 2 |  | 0 | 0 |  | 3
 |  |  |  |  |  | 0
 | APP 3 |  | 0 | 0 |  | 3
 |  |  |  |  |  | 0
 | APP 3 |  | 0 | 0 |  | 3
 |  |  |  |  |  | 0
 |  |  |  |  |  |  | TOTAL LABOR
 | Employee Mobilization | [NAME] ONE WAY | DRIVE TIME ONE WAY | DAYS DRIVING ONE WAY | DRIVE TIME PER DAY ONE WAY | [NAME] | DAYS TRAVEL RT | TOTAL DAYS TRAVEL
 | EMPLOYEE PER DIEM
 | OUT OF TOWN? Y/N | y | DAYS OF | PER DAY | TOTAL
 |  |  |  | 40
 |  |  |  | 40
 |  |  |  | 40
 |  |  |  | 40
 |  |  |  | 40
 |  |  |  | TOTAL
 | HOTEL ALLOWANCE
 |  |  | DAYS OF | PER DAY | TOTAL
 |  |  |  | 100
 |  |  |  | 100
 |  |  |  | 100
 |  |  |  | 100
 |  |  |  | 100
 |  |  |  | TOTAL
 | FUEL AND MILEAGE
 | NUMBER OF TRUCKS | [NAME] | [NAME] (RT) | TRIPS | PRICE PER | TOTAL
 | 1 | 10 |  | 2 | 0.5
 |  |  |  | . | TOTAL
Spreadsheet: 879734d1727283520-weird-alignment-issue-excel-alignment-sample
Sheet: Sheet1

Country | Early | On Time | 1-2 Weeks Late | 2-3 Weeks Late | 3-4 Weeks Late | 4+ Weeks Late | Total
China | 52579 | 504727 | 562841 | 5448
Vietnam | 145978 | 980116 | 33769 |  |  | 3481
Indonesia | 8703 | 754147 | 223544 | 443 | 6381
Cambodia | 25550 | 716784 | 143
Bangladesh | 165717 | 666562 | 134374 | 66197 | 71001
India | 220712 | 773056 | 27894 | 1949 |  | 39024
Pakistan | 107549 | 622467 | 86963 | 16277 | 9695 | 5910
Jordan | 140130 | 18777 |  | 518 | 1779 | 898
Africa | 109647 | 52783 | 26293 | 59853 | 1357 | 14330
Total
Spreadsheet: 749032d1632477205-sumifs-offset-how-to-combine-successfully-example111-ans
Sheet: Sheet1

Area | Items | Jan | Feb | Mar | Apr | May | Jun | Jul | Aug | Sep | Oct | Nov | Dec
1 | 111 | 5 | 4 | 3 | 5 | 4 | 3 | 5 | 4 | 3 | 5 | 4 | 3 |  | Sum this many months | 9
1 | 112 | 1 | 1 | 5 | 1 | 1 | 5 | 1 | 1 | 5 | 1 | 1 | 5 |  | Area | 2
1 | 113 | 3 | 2 | 4 | 3 | 2 | 4 | 3 | 2 | 4 | 3 | 2 | 4
1 | 114 | 6 | 9 | 8 | 6 | 9 | 8 | 6 | 9 | 8 | 6 | 9 | 8 |  |  |  |  | Results
2 | 111 | 5 | 4 | 3 | 5 | 4 | 3 | 5 | 4 | 3 | 5 | 4 | 3 |  | Items | 111 |  | sum this many months "Q2", sum this area"Q3", sum items "Q6"
2 | 112 | 1 | 1 | 5 | 1 | 1 | 5 | 1 | 1 | 5 | 1 | 1 | 5 |  |  | 112 |  | same as above
2 | 113 | 3 | 2 | 4 | 3 | 2 | 4 | 3 | 2 | 4 | 3 | 2 | 4 |  |  | 113 |  | same as above
2 | 114 | 6 | 9 | 8 | 6 | 9 | 8 | 6 | 9 | 8 | 6 | 9 | 8 |  |  | 114 |  | same as above
7 | 111 | 5 | 4 | 3 | 5 | 4 | 3 | 5 | 4 | 3 | 5 | 4 | 3
7 | 112 | 1 | 1 | 5 | 1 | 1 | 5 | 1 | 1 | 5 | 1 | 1 | 5
7 | 113 | 3 | 2 | 4 | 3 | 2 | 4 | 3 | 2 | 4 | 3 | 2 | 4
7 | 114 | 6 | 9 | 8 | 6 | 9 | 8 | 6 | 9 | 8 | 6 | 9 | 8
Spreadsheet: 870010d1716524572-copy-scores-across-from-date-or-list-to-match-list-penang-league-ans
Sheet: Fixtures

Competition Fixtures |  |  |  |  |  |  |  |  |  | Teams: | 6
Round | Match | Home Team | Score |  | Score | Away Team | Ground | Dates |  | Games Against Each Other: | 2
 |  |  |  |  |  |  |  | Fri 20/10/23 |  | Team Number | Club Name | Home Ground
 |  |  |  |  |  |  |  | Mon 16/10/23 |  |  | Blackmoor | [NAME] |  |  | [NAME] for 2024/25 Season
 |  |  |  |  |  |  |  | Wed 4/10/23 |  |  | Basingstoke | [NAME]
 |  |  |  |  |  |  |  |  |  |  | Burhill | Burhill GC |  |  | Results
 |  |  |  |  |  |  |  | Wed 3/1/24 |  |  | Camberley Heath | Camberley Heath GC
 |  |  |  |  |  |  |  | Mon 9/10/23 |  |  | West Byfleet | West Byfleet GC
 |  |  |  |  |  |  |  | Wed 3/1/24 |  |  | West Surrey | West Surrey GC |  |  | Date |  | Points | Home Team | Score | Score | Away Team | Points |  |  |  | 1
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  | October
 |  |  | 7 |  | 9 |  |  | Fri 5/1/24 |  |  |  |  |  |  | 4 | Wednesday |  | Blackmoor | 4 | 0 | West Surrey
 |  |  |  |  |  |  |  | Fri 12/1/24 |  |  |  |  |  |  |  |  |  | Blackmoor | 7 | 9 | Camberley Heath
 |  |  |  |  |  |  |  | Thu 6/2/24 |  |  |  |  |  |  |  |  |  | West Surrey | 0 | 7 | West Byfleet
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | Basingstoke | 6 |  | Burhill
 |  |  |  |  |  |  |  | Thu 18/1/24
 |  |  |  |  |  |  |  | Mon 23/10/23
 |  |  | 0 |  | 7 |  |  | Fri 26/1/24
 |  |  |  |  |  |  |  | Fri 20/10/23
 |  |  |  |  |  |  |  | Mon 30/10/23
 |  |  |  |  |  |  |  | Mon 30/10/23
 |  |  |  |  |  |  |  | Thu 15/2/24
 |  |  |  |  |  |  |  | Fri 19/1/24
 |  |  |  |  |  |  |  | Mon 12/2/24
 |  |  |  |  |  |  |  | Wed 15/11/23
 |  |  |  |  |  |  |  | Thu 18/1/24
 |  |  | 6 |  |  |  |  | Mon 19/10/23
 |  |  |  |  |  |  |  | Mon 29/1/24
 |  |  |  |  |  |  |  | Mon 23/10/23
 |  |  |  |  |  |  |  | Thu 9/11/23
 |  |  |  |  |  |  |  | Wed 6/12/23
 |  |  |  |  |  |  |  | Mon 22/1/24
 |  |  |  |  |  |  |  | Fri 26/1/24
 |  |  |  |  |  |  |  | Wed 10/1/24
 |  |  |  |  |  |  |  | Thu 1/2/24
 |  |  |  |  |  |  |  | Fri 2/2/24
Spreadsheet: 677329d1589307059-some-help-on-match-match-sample
Sheet: Sheet1

 | 1 | 2 | 3 | 4
 | 5 | 6 | 7 | 8
 | 9 | 10 | 11 | 12
 | 13 | 14 | 15 | 16
 | Find: | 14
 | Result:
Spreadsheet: benjamin_rogers__1172__Wheatland_New - W 501 D5A
Sheet: Interest During Construction

IDC Calculations
CARRYING COST OF TURBINES, TRANSFORMERS AND CIRCUIT BREAKERS
Turbine Cost |  | 136882
Base Rate
Term (Months) |  | 18
Monthly Rate
Financing Fee (Basis Points) |  | 0.0035
Drawdown Schedule |  | 1
0=Straightline, 1=Custom
Calculated IDC
Month | Percent [NAME] | Principal | Cumulative Principal | Monthly Interest | Cumulative Interest
0 |  | 16673.4 |  | 413.818
1 |  | 43401.65 |  | 239.841
 |  | 0 |  | 375.473
 |  | 4291.075
 |  | 4352.24
 |  | 4480.174
 |  | 4450.698
 |  | 150.287
 |  | 6831.994
 |  | 3879.683
 |  | 2992.452
 |  | 3002.452
 |  | 4242.452
 |  | 7114.118
 |  | 6041.349
 |  | 5239.444
 |  | 5739.444
 |  | 4299.444
 |  | 9699.852
 |  | 0
 |  | 0
 |  | 0
 |  | 0
 |  | 0
 |  | 0
 |  | 0
 |  | 0
 |  | 0
 |  | 0
 |  | 0
 |  | 0
 |  | 0
 |  | 0
 |  | 0
 |  | 0
 |  | 0
 |  | 0
Spreadsheet: 697033d1601116569-sum-unique-distinct-names-values-unique-value
Sheet: Sheet1

a | 10
b | 11
c | 12
d | 13
a | 11
b | 12
e | 33
f | 44 |  | range | A1:A15
g | 55 |  | values | B1:B15
c | 20
answer | 178
Spreadsheet: 768759d1645110558-check-if-cell-contains-any-string-from-another-column-book2
Sheet: Sheet1

VENDOR | LIST | Desired Result | [NAME]
THE HOME DEPOT | This is some text to see if LOWES the formula will detect the vendor | Yes
ACE HARDWARE |  | Blank
LOWES | This is COAST TO COAST some text to see if the formula will detect the vendor | Yes
COAST TO COAST |  | Blank
TRACTOR SUPPLY COMPANY | This is some text to see if the formula will detect the vendor | No
MILLS FLEET FARM | MENARDS INC This is some text to see if the formula will detect the vendor | Yes
MENARDS INC | This MCDONALDS LLC is some text to see if the formula will detect the vendor | No
 | TRACTOR SUPPLY COMPANY | Yes
 |  | Blank
 | This is some text to see if the formula will detect the vendor THE HOME DEPOT | Yes
 |  | Blank
 |  | Blank
 |  | Blank
 |  | Blank
 |  | Blank
 | BURGER KING This is some text to see if the formula will detect the vendor | No
 |  | Blank
 |  | Blank
 |  | Blank
 |  | Blank
 |  | Blank
 | This MCDONALDS LLC is some text to see if the formula will detect the vendor | Yes
 |  | Blank
 |  | Blank
 |  | Blank
 |  | Blank
 |  | Blank
 |  | Blank
 |  | Blank
Spreadsheet: 864799d1711948868-from-static-to-dynamic-cell-reference-via-indirect-function-raw-materials-record
Sheet: MEK

Raw Material |  | MEK
Date | Description | Batch Processed Quantity |  | Quantity Stored ([NAME]'s) | Quantity Issued ([NAME]'s) | Total Quantity Remaining ([NAME]'s) | Bilty or Batch (Description)
 |  | Qty | [NAME]'s
Column1 | Column2 | Column3 | Column4 | Column5 | Column6 | Column7 | Column8
2023-09-30 00:00:00 |  |  |  |  |  | 243
2023-12-05 00:00:00 |  |  |  |  | 174
2024-02-15 00:00:00 | [NAME] |  |  |  | 55 |  | SRN # 7603
Total
Spreadsheet: 271326d1381913423-countifs-a-b-c-or-d-ab-testing-stats-master
Sheet: iPad

iPad | Geek Culture |  |  | Science & Research |  |  | Personal/Opinion |  |  | Historic |  |  | AppStore Rating |  |  | Quotation |  |  | Anecdote/Fact |  |  | Question |  |  | App's Success |  |  | Country Specific |  |  | Endorsement |  |  | Love/Sex
 | No. of Promos | Won | % | No. of Promos | Won | % | No. of Promos | Won | % | No. of Promos | Won | % | No. of Promos | Won | % | No. of Promos | Won | % | No. of Promos | Won | % | No. of Promos | Won | % | No. of Promos | Won | % | No. of Promos | Won | % | No. of Promos | Won | % | No. of Promos | Won | %
Canada
UK
Australia
Germany
Russia
France
Sweden
Spain
Italy
Netherlands
Norway
Denmark
Korea
Turkey
Japan
Finland
Spreadsheet: 165040d1340995564-excel-2007-how-do-i-use-index-match-formula-to-pull-certain-information-sample-master
Sheet: Master SC

2012 Tart Cherry Worksheet |  |  |  |  |  |  |  |  |  | Original |  |  |  |  |  |  |  |  |  |  | Regrade
Date | Time | Receiver # | Receiving Station | Grower # | [NAME] | # of Tanks | Block | Weight | Avg. [NAME] | Decay | Soft | Wind Whip | Undersize | Hail | Splits | Other | Comments | Grader | Sample Size | Grade | Grade | Sample size | Grader | Decay | Soft | Wind Whip | Undersize | Hail | Splits | Other | Comments
 |  |  |  |  | Grower 1 |  |  |  |  |  |  |  |  |  |  |  |  | SG |  | 88
 |  |  |  |  | Grower 1 |  |  |  |  |  |  |  |  |  |  |  |  | AG |  | 89
 |  |  |  |  | Grower 1 |  |  |  |  |  |  |  |  |  |  |  |  | SG |  | 90
 |  |  |  |  | Grower 1
 |  |  |  |  | Grower 1
 |  |  |  |  | Grower 2
 |  |  |  |  | Grower 2
 |  |  |  |  | Grower 2