tianzl66/Sheetpedia huggingface dataset:
Spreadsheet: 82582d1282652590-excel-2007-vlookup-formula-for-more-than-one-sheet-and-if-function-workbook-2
Sheet: Gravity Tower

Project A
Subcontractors | Subcontractors Code | Filed in
Tanmiya Realty Development Co. | [NAME] | Filed in Gravity Tower - Tanmiya File No. 01
[NAME] | EmadGT10 | Filed in Gravity Tower - Tanmiya File No. 01
Al-Mashaer Company | MashaerGT10 | Filed in Gravity Tower - Tanmiya File No. 01
OBD10 | OBDGT10 | Filed in Gravity Tower - OBD File No. 01 | Filed in Gravity Tower - Interim Payments File No. 02
[NAME] Establishment | HusseinMoradGT10 | Filed in Gravity Tower - Subcontractors' File No. 01
Al-Raed International Company | RaedGT10 | Filed in Gravity Tower - Subcontractors' File No. 01
[NAME]. Gen. [NAME]. & Cont | [NAME] | Filed in Gravity Tower - Subcontractors' File No. 01
National Cleaning Company | NationalGT10 | Filed in Gravity Tower - Subcontractors' File No. 01
[NAME] | SadakaGT10 | Filed in Gravity Tower - Subcontractors' File No. 01
Tekneen Building Maintenance Services Company | TekneenGT10 | Filed in Gravity Tower - Subcontractors' File No. 01
[NAME] Gen. [NAME]. Company | MuhalhelGT10 | Filed in Gravity Tower - Subcontractors' File No. 01
National Montreal Company | NationalMontrealGT10 | Filed in Gravity Tower - Subcontractors' File No. 01
White Shadow Company | WhiteGT10 | Filed in Gravity Tower - Subcontractors' File No. 01
Eng. [NAME] | AmjadGT10 | Filed in Gravity Tower - Site Correspondences's File No. 01
Eng. [NAME] | [NAME] | Filed in Gravity Tower - Site Correspondences's File No. 01
Eng. [NAME] | NasserGT10 | Filed in Gravity Tower - Site Correspondences's File No. 01
Eng. [NAME] | IbrahimGT10 | Filed in Gravity Tower - Site Correspondences's File No. 01
Eng. [NAME] | MohammadTaherGT10 | Filed in Gravity Tower - Site Correspondences's File No. 01
Eng. [NAME] | AhmadTaherGT10 | Filed in Gravity Tower - Site Correspondences's File No. 01
Media Corner Company | MediaGT10 | Filed in Gravity Tower - Subcontractors' File No. 01
PROEX | PROEXGT10 | Filed in Gravity Tower - Subcontractors' File No. 01
Spreadsheet: 803898d1667783534-calculate-final-price-using-tiered-pricing-more-elegantly-pricing-model
Sheet: Sheet1

 |  |  |  |  |  |  |  | 100 | 200 | 300 | 400 | 500 | price per 100g caffè more than 500g
0.65 | per unit cost |  |  |  |  |  |  |  |  |  |  |  | 130
4 | multiplier applied before 200g
cell F5 | starting price at 100 grams
 | price per 100g caffè more than 500g
 |  | Increase |  | Qty | Total price | Price per gram |  | Qty | Total usng IFS | Total
 |  | 0 |  | 100 |  |  |  | 1
 |  | 0.5 |  | 200 |  |  |  | 99
 |  | 0.25 |  | 300 |  |  |  | 100
 |  | 0.18 |  | 400 |  |  |  | 101
 |  | 0.13 |  | 500 |  |  |  | 199
 |  |  |  | 600 |  |  |  | 200
 |  |  |  | 700 |  |  |  | 201
 |  |  |  | 800 |  |  |  | 299
 |  |  |  | 900 |  |  |  | 300
 |  |  |  | 1000 |  |  |  | 301
 |  |  |  |  |  |  |  | 399
 |  |  |  |  |  |  |  | 400
 |  |  |  |  |  |  |  | 401
 |  |  |  |  |  |  |  | 499
 |  |  |  |  |  |  |  | 500
 |  |  |  |  |  |  |  | 501
 |  |  |  |  |  |  |  | 599
 |  |  |  |  |  |  |  | 250
 |  |  |  |  |  |  |  | 500
 |  |  |  |  |  |  |  | 750
 |  |  |  |  |  |  |  | 1000
Spreadsheet: 587326d1534959894-can-vlookup-help-in-this-situation-ef1181_countries-of-the-world
Sheet: Ref_data

Region | Records
ASIA (EX. NEAR EAST)
BALTICS
C.W. OF IND. STATES
EASTERN EUROPE
LATIN AMER. & CARIB
NEAR EAST
NORTHERN AFRICA
NORTHERN AMERICA
OCEANIA
SUB-SAHARAN AFRICA
WESTERN EUROPE
Spreadsheet: 844574d1696346636-sum-or-sumproduct-or-with-dates-in-the-table-headers-products-sold-sumproduct
Sheet: Blad1

Continent | Country | Product | 1-10-2023 | 2-10-2023 | 3-10-2023 | 4-10-2023 | 5-10-2023 | 6-10-2023 | 7-10-2023 | 8-10-2023 | 9-10-2023 | 10-10-2023 |  | DATE FROM-TO | 2-10-2023 | 8-10-2023 |  |  | COUNTRY
Northern Europe | UK | Apples | 1 | 4 | 1 | 4 | 4 | 4 | 2 | 3 | 1 | 2 |  | FRUIT | QUANTITY
Northern Europe | UK | Oranges | 4 | 2 | 1 | 4 | 3 | 3 | 2 | 2 | 3 | 1 |  | Melons |  |  |  |  | SELECT COUNTRY | FR | IT
Northern Europe | UK | Bananas | 4 | 2 | 2 | 4 | 2 | 4 | 1 | 2 | 2 | 3 |  | Oranges |  |  |  |  | FR | DE
Northern Europe | UK | Pears | 3 | 2 | 4 | 4 | 1 | 2 | 2 | 2 | 2 | 1 |  | Melons |  |  |  |  | DE | IT
Northern Europe | UK | Strawberries | 2 | 2 | 2 | 2 | 4 | 4 | 4 | 3 | 3 | 3 |  | Melons |  |  |  |  | IT | UK
Northern Europe | UK | Pineapples | 2 | 4 | 2 | 1 | 3 | 1 | 4 | 0 | 1 | 3 |  | SELECT FRUIT
Northern Europe | UK | Melons | 4 | 3 | 4 | 4 | 1 | 1 | 2 | 1 | 1 | 0 |  | SELECT FRUIT
Northern Europe | DE | Apples | 3 | 0 | 1 | 3 | 3 | 4 | 3 | 2 | 2 | 2 |  | SELECT FRUIT
Northern Europe | DE | Oranges | 2 | 4 | 2 | 2 | 4 | 0 | 3 | 4 | 1 | 4 |  | SELECT FRUIT
Northern Europe | DE | Bananas | 1 | 1 | 3 | 4 | 1 | 2 | 4 | 3 | 2 | 1 |  | SELECT FRUIT
Northern Europe | DE | Pears | 3 | 3 | 4 | 2 | 1 | 4 | 2 | 1 | 4 | 1 |  | SELECT FRUIT
Northern Europe | DE | Strawberries | 4 | 2 | 1 | 1 | 3 | 2 | 3 | 3 | 2 | 2 |  | SELECT FRUIT
Northern Europe | DE | Pineapples | 2 | 1 | 3 | 0 | 4 | 1 | 1 | 1 | 2 | 3 |  | SELECT FRUIT
Northern Europe | DE | Melons | 1 | 2 | 4 | 2 | 2 | 3 | 3 | 0 | 2 | 1 |  | SELECT FRUIT
Southern Europe | IT | Apples | 3 | 1 | 1 | 2 | 4 | 1 | 2 | 2 | 3 | 4 |  | SELECT FRUIT
Southern Europe | IT | Oranges | 2 | 3 | 4 | 1 | 3 | 4 | 4 | 1 | 2 | 4 |  | SELECT FRUIT
Southern Europe | IT | Bananas | 4 | 1 | 2 | 4 | 3 | 1 | 3 | 1 | 1 | 4
Southern Europe | IT | Pears | 4 | 4 | 4 | 2 | 2 | 2 | 2 | 2 | 4 | 1
Southern Europe | IT | Strawberries | 4 | 0 | 4 | 1 | 1 | 3 | 1 | 1 | 3 | 2
Southern Europe | IT | Pineapples | 2 | 4 | 4 | 3 | 2 | 4 | 3 | 4 | 4 | 0
Southern Europe | IT | Melons | 3 | 3 | 4 | 0 | 4 | 3 | 1 | 2 | 3 | 4
Southern Europe | FR | Apples | 3 | 3 | 1 | 1 | 1 | 4 | 1 | 2 | 4 | 2
Southern Europe | FR | Oranges | 2 | 2 | 2 | 4 | 3 | 4 | 1 | 1 | 4 | 4
Southern Europe | FR | Bananas | 2 | 1 | 1 | 4 | 1 | 1 | 1 | 1 | 4 | 2
Southern Europe | FR | Pears | 4 | 1 | 3 | 2 | 2 | 2 | 2 | 4 | 4 | 4
Southern Europe | FR | Strawberries | 3 | 2 | 1 | 3 | 4 | 1 | 4 | 3 | 3 | 1
Southern Europe | FR | Pineapples | 4 | 1 | 2 | 1 | 4 | 3 | 2 | 2 | 4 | 1
Southern Europe | FR | Melons | 4 | 3 | 3 | 3 | 4 | 3 | 4 | 1 | 3 | 4
Spreadsheet: 91968d1291659809-need-to-add-cells-together-within-a-date-add-cell-together-withen-a-date
Sheet: Sheet1

DATE | COLOUR | FREQUENCY | SUB TOTAL
2009-12-01 00:00:00 | BLACK | 5
2009-12-01 00:00:00 | WHITE | 6
2009-12-01 00:00:00 | BLUE | 9 |  |  | Sum of FREQUENCY
2009-12-01 00:00:00 | RED | 2 |  |  | DATE | Total
2009-12-01 00:00:00 | YELLOW | 5 |  |  | 2009-12-01 00:00:00 | 35
2009-12-01 00:00:00 | ORANGE | 8 | 35 |  | 2009-12-02 00:00:00 | 48
2009-12-02 00:00:00 | BLACK | 5 |  |  | 2009-12-03 00:00:00 | 23
2009-12-02 00:00:00 | WHITE | 7 |  |  | Grand Total | 106
2009-12-02 00:00:00 | BLUE | 4
2009-12-02 00:00:00 | RED | 5
2009-12-02 00:00:00 | YELLOW | 3
2009-12-02 00:00:00 | ORANGE | 8
2009-12-02 00:00:00 | PINK | 8
2009-12-02 00:00:00 | GREEN | 2
2009-12-02 00:00:00 | PURPLE | 6 | 48
2009-12-03 00:00:00 | BLACK | 5
2009-12-03 00:00:00 | PURPLE | 5
2009-12-03 00:00:00 | BLUE | 4
2009-12-03 00:00:00 | PINK | 2
2009-12-03 00:00:00 | YELLOW | 4
2009-12-03 00:00:00 | ORANGE | 1
2009-12-03 00:00:00 | GREEN | 2 | 21
Spreadsheet: 117406d1312794646-likert-scale-graphs-questionnaire-for-masters-with-collected-data
Sheet: ITEM PROPERTY

ITEM | POINTS | DIFFICULTY | DISCRIMINATION
1 | 5 | 0.9071428571428571 | 0.5377575015947458
2 | 5 | 0.9142857142857143 | 0.561352209785813
3 | 5 | 0.85 | 0.7310559537319877
4 | 5 | 0.8928571428571429 | 0.563805935906394
5 | 5 | 0.8857142857142857 | 0.5797608188088879
6 | 5 | 0.85 | 0.2403793899352306
7 | 5 | 0.7928571428571428 | 0.5683155600702322
8 | 5 | 0.85 | 0.6142139240042165
9 | 5 | 0.7642857142857142 | 0.2699988650369752
10 | 5 | 0.8928571428571429 | 0.5284171821350879
11 | 5 | 0.65 | 0.228013322026073
12 | 5 | 0.9285714285714286 | 0.567955136837916
13 | 5 | 0.8357142857142857 | 0.676972691975439
14 | 5 | 0.8928571428571429 | 0.3609081645656083
15 | 5 | 0.8428571428571429 | 0.5097302176992589
16 | 5 | 0.3714285714285714 | 0.2200952083736207
17 | 5 | 0.2928571428571429 | 0.1277545445777572
18 | 5 | 0.3 | 0.3588482018644744
19 | 5 | 0.4214285714285714 | 0.0894386372466347
20 | 5 | 0.5142857142857142 | 0.05631047366930127
21 | 5 | 0.3 | -0.4646226689922088
22 | 5 | 0.9214285714285714 | 0.6155144689663861
23 | 5 | 0.2428571428571429 | -0.4193196527947286
24 | 5 | 0.9142857142857143 | 0.5298188756156128
25 | 5 | 0.85 | 0.441374586039265
ITEM | POINTS | DIFFICULTY | DISCRIMINATION
26 | 5 | 0.9071428571428571 | 0.8091707235269822
27 | 5 | 0.8785714285714286 | 0.8326950454331524
28 | 5 | 0.8571428571428571 | 0.5202992732983104
29 | 5 | 0.8285714285714286 | 0.7097354599492552
30 | 5 | 0.8 | 0.8087685507636808
31 | 5 | 0.9 | 0.5669556772876961
32 | 5 | 0.9214285714285714 | 0.4693591237646074
33 | 5 | 0.8285714285714286 | 0.712510561952413
34 | 5 | 0.9 | 0.5782073721976464
35 | 5 | 0.9142857142857143 | 0.1480126913930599
36 | 5 | 0.6571428571428571 | 0.08112349920688573
37 | 5 | 0.5285714285714286 | 0.4717333492791768
38 | 5 | 0.5571428571428572 | 0.6658659885790101
39 | 5 | 0.8142857142857143 | 0.522498072927279
40 | 5 | 0.5785714285714286 | 0.4796822733059268
41 | 5 | 0.8428571428571429 | 0.1205064916456486
42 | 5 | 0.8357142857142857 | 0.5555443434015556
43 | 5 | 0.9357142857142857 | 0.5269393651666187
44 | 5 | 0.8571428571428571 | 0.62277032767675
45 | 5 | 0.9714285714285714 | 0.05558432065091013
Spreadsheet: 200084d1355410667-calculating-correlation-between-two-series-of-data-correlation-example
Sheet: Sheet1

Customer | Coverage | Sales Won
Customer 1 | 1 | 0.5
Customer 2 | 0.72 | 0.36
Customer 3 | 0.12 | 0.48
Customer 4 | 0.81 | 0.405
Customer 5 | 0.62 | 0.31
Customer 6 | 0.63 | 0.315
Customer 7 | 0.62 | 0.31
Customer 8 | 0.65 | 0.325
Customer 9 | 0.8 | 0.4
Customer 10 | 0.95 | 0.475
Customer 11 | 0.99 | 0.495
Customer 12 | 0.6 | 0.3
Customer 13 | 0.72 | 0.36
Customer 14 | 0.64 | 0.32
Customer 15 | 0.98 | 0.49
Customer 16 | 0.69 | 0.05
Customer 17 | 0.9 | 0.45
Customer 18 | 0.34 | 0.49
Customer 19 | 0.6 | 0.3
Customer 20 | 0.9 | 0.45
Customer 21 | 0.66 | 0.33
Customer 22 | 0.15 | 0.455
Customer 23 | 0.96 | 0.48
Customer 24 | 0.98 | 0.49
Customer 25 | 0.9 | 0.45
Customer 26 | 0.92 | 0.46
Customer 27 | 0.97 | 0.485
Customer 28 | 0.8 | 0.4
Customer 29 | 0.69 | 0.345
Customer 30 | 0.96 | 0.48
Customer 31 | 0.85 | 0.8
Customer 32 | 0.91 | 0.455
Customer 33 | 0.85 | 0.425
Customer 34 | 0.77 | 0.385
Spreadsheet: 0aaf25eb-8796-401f-aa82-6aa6a39f0b03
Sheet: Epi_Curve

Residents
Staff
Spreadsheet: 328938d1404143534-formula-extension-help-publisher-control-sheet-may
Sheet: SpotX revenue

Channel Name | Listing Type | Impressions | Clicks | Net Revenue | Gross Revenue | Ad Requests | Ads Available | [NAME] | CTR | Net eCPM | Gross eCPM |  | 1-31 May
Coull_AdMedia (91479) | InStream/InGame | 12502 | 62 | 77.22140868492724 | 110.3163 | 8392185 | 1186648
Coull_Altitude (91250) | InStream/InGame | 457241 | 425 | 4184.582288736988 | 5977.974800000001 | 32987642 | 1015366
Coull_Anyclip (90875) | InStream/InGame | 983660 | 1067 | 7121.081258728705 | 10172.9734 | 143452013 | 32020553
Coull_Czarina (91471) | InStream/InGame | 232540 | 941 | 1702.01539101485 | 2431.4506 | 19202739 | 3397936
Coull_Dailymotion (91024) | InStream/InGame | 1055778 | 25514 | 10908.91587422227 | 15584.1658 | 80593978 | 4920662
Coull_Kitara (91072) | InStream/InGame | 13474 | 21 | 147.4918874882281 | 210.7027 | 39944983 | 1509127
Coull_Knowlera  (92266) | InStream/InGame | 5357 | 21 | 52.61374910399318 | 75.1625 | 361093 | 23166
Coull_Matomy_Media (92335) | InStream/InGame | 3853 | 8 | 29.5648494965136 | 42.2355 | 657349 | 8423
Coull_Sidereel (90864) | InStream/InGame | 27340 | 604 | 280.9520652154147 | 401.3601000000001 | 3131479 | 1350519
Coull_Stickyads (91542) | InStream/InGame | 22 | 0 | 0.04255999927520752 | 0.0608 | 67 | 37
Coull_Uvidi (91544) | InStream/InGame | 476295 | 1812 | 4089.778980351478 | 5842.541499999999 | 27654939 | 1029882
Coull_Videomize (90991) | InStream/InGame | 649639 | 135 | 3619.029128368299 | 5170.041700000001 | 22859769 | 2240761
Coull_VideoNatives (91539) | InStream/InGame | 38057 | 118 | 179.1039569498777 | 255.8628 | 1564369 | 632294
Coull_Viewster (92106) | InStream/InGame | 147446 | 116 | 1746.611130255389 | 2495.1588 | 2469935 | 239126
Coull_Web3 (92486) | InStream/InGame | 13 | 1 | 0.01728999970555305 | 0.0247 | 749 | 16
 | Totals
Spreadsheet: 743059d1628185995-count-function-based-on-multiple-columns-count-function-question
Sheet: Sheet4

 |  | Vendor | Month Due | Product Delivered
 |  | Acme | July | Staplers |  | Acme
 |  | Acme | July | Staplers |  | July
 |  | Acme | July | Staplers |  |  | UNIQUE PRODUCTS DELIVERED?
 |  | Acme | July | Staplers
 |  | Acme | July | Staplers |  |  | formula to calculate how many unique "Products Delivered" in July by Acme)
 |  | Acme | July | Keyboards |  |  | formula should return "4" (highlighted unique occurences)
 |  | Acme | July | Keyboards
 |  | Acme | July | Keyboards
 |  | Acme | July | Keyboards
 |  | Acme | July | Pens
 |  | Acme | July | Pens
 |  | Acme | July | Staplers
 |  | Acme | August | Staplers
 |  | Acme | August | Pens
 |  | Acme | August | Pens
 |  | Acme | August | Pens
 |  | Acme | August | Pens
 |  | Acme | August | Keyboards
 |  | Bander | May | Pens
 |  | Bander | May | Pens
 |  | Bander | May | Pens
 |  | Bander | May | Pens
 |  | Bander | May | Pens
 |  | Bander | May | Pens
 |  | Bander | May | Staplers
 |  | Bander | May | Staplers
 |  | Bander | May | Staplers
 |  | Bander | May | Staplers
 |  | Bander | May | Staplers
 |  | Bander | May | Staplers
 |  | Acme | May | Batteries
 |  | Acme | May | Batteries
 |  | Acme | May | Staplers
 |  | Bander | May | Pens
 |  | Bander | May | Keyboards
 |  | Acme | July | Staplers
 |  | Acme | July | Cell Phones
 |  | Acme | March | Staplers
 |  | Acme | March | Staplers
 |  | Acme | March | Pens
Spreadsheet: 765466d1643339939-unique-function-showing-duplicate-values-book1
Sheet: Sheet1

5.1
5.2 |  | 5.2
5.3 |  | 5.3
5.4 |  | 5.4
5.5 |  | 5.5
5.800000000000001 |  | 5.800000000000001
5.9 |  | 5.9
6 |  | 6
6.1 |  | 6.1
6.100000000000001 |  | 6.100000000000001
6.2 |  | 6.2
6.3 |  | 6.3
6.4 |  | 6.4
6.5 |  | 6.5
6.6 |  | 6.6
6.8 |  | 6.8
6.800000000000001 |  | 6.800000000000001
6.800000000000001 |  | 7.2
7.2 |  | 7.800000000000001
7.800000000000001 |  | 8
8 |  | 8.200000000000001
8.200000000000001 |  | 8.4
8.4 |  | 8.5
8.5 |  | 8.700000000000001
8.700000000000001 |  | 9
8.700000000000001 |  | 9.1
9 |  | 9.3
9 |  | 9.5
9.1 |  | 9.600000000000001
9.3 |  | 9.9
9.3 |  | 10.1
9.5 |  | 10.2
9.600000000000001 |  | 10.8
9.600000000000001 |  | 11.1
9.9 |  | 11.5
10.1 |  | 11.6
10.1 |  | 12.5
10.2 |  | 12.6
10.2 |  | 12.8
10.8 |  | 12.9
11.1 |  | 13
11.5 |  | 13.3
11.5 |  | 13.5
11.6 |  | 13.6
11.6 |  | 13.9
11.6 |  | 14.2
11.6 |  | 14.3
12.5 |  | 14.4
12.6 |  | 14.5
12.6 |  | 14.6
12.6 |  | 14.9
12.8 |  | 15
12.9 |  | 15.2
13 |  | 15.3
13.3 |  | 15.7
13.3 |  | 15.8
13.5 |  | 16.1
13.6 |  | 16.2
13.9 |  | 16.5
14.2 |  | 16.6
14.3 |  | 16.8
14.4 |  | 17
14.5 |  | 17.2
14.6 |  | 17.5
14.9 |  | 17.7
15 |  | 17.9
15 |  | 18
15.2 |  | 18.6
15.3 |  | 18.7
15.7 |  | 18.9
15.8 |  | 19.1
15.8 |  | 19.2
16.1 |  | 19.3
16.2 |  | 19.4
16.5 |  | 19.5
16.6 |  | 19.8
16.8 |  | 19.9
17 |  | 20
17.2 |  | 20.3
17.5 |  | 20.5
17.7 |  | 20.8
17.9 |  | 20.9
18 |  | 21
18.6 |  | 21.2
18.6 |  | 21.3
18.7 |  | 22
18.9 |  | 22.3
19.1 |  | 22.5
19.2 |  | 23.2
19.3 |  | 23.3
19.3 |  | 23.7
19.4 |  | 24
19.5 |  | 24.5
19.8 |  | 25
19.9 |  | 25.2
19.9 |  | 26.6
20 |  | 27.7
20.3 |  | 27.8
20.5 |  | 28.7
20.5 |  | 28.9
20.8 |  | 29.3
20.8 |  | 30.4
20.9 |  | 32.4
20.9 |  | 32.8
21 |  | 33.3
21.2 |  | 33.4
21.2 |  | 34
21.3 |  | 34.5
21.3 |  | 34.8
22 |  | 35.2
22.3 |  | 36.6
22.5 |  | 37.2
23.2 |  | 37.4
23.3 |  | 40.8
23.7 |  | 42.40000000000001
24 |  | 42.5
24.5 |  | 45.1
25 |  | 50.8
25 |  | 50.90000000000001
25 |  | 51.3
25 |  | 52
25.2 |  | 53.5
26.6
27.7
27.8
28.7
28.9
29.3
30.4
30.4
32.4
32.8
33.3
33.4
34
34.5
34.8
35.2
36.6
37.2
37.4
40.8
42.40000000000001
42.5
45.1
50.8
50.90000000000001
51.3
52
53.5
Spreadsheet: 193337d1352806379-trying-to-apply-multiple-entries-with-vlookup-and-use-two-if-statements-adv-comp-project2
Sheet: Rect Column Detail Sheet

 | RECTANGULAR COLUMN DETAIL SHEET
 |  |  | Input Data |  |  |  |  |  |  |  | Form |  |  |  | Place |  |  |  | Finish |  |  |  | Total
 | Line # | Description | L (LF) | W (LF) | D (IN) | QTY | [NAME] | VAR2 | VOL (CY) | LF (FT) | Labor | Mat'l | Equip | Total | Labor | Mat'l | Equip | Total | Labor | Mat'l | Equip | Total | Labor | Mat'l | Equip | Total
Spreadsheet: 839681d1692156246-countifs-formula-for-filtered-list-to-find-unique-values-ignore-hidden-rows-count-unique-conditional-values-solution-
Sheet: Sheet1

Type | Name | Amount | Manager
Normal | Audi | 6 | [NAME]
Normal | Audi | 5 | [NAME]
Normal | Mercedes | 15 | [NAME]
Normal | Mercedes | 9 | [NAME]
Special | BMW | 4 | [NAME]
Special | BMW | 3 | [NAME]
Special | Audi | 2 | [NAME]
Special | Honda | 10 | [NAME]
Special | Honda | 10 | [NAME]
Unique Count
Normal
Special
Normal & Special | 1
 | B12=SUM(IF(FREQUENCY(IF(SUBTOTAL(3,OFFSET(OFFSET(B1,1,0):B11,ROW(OFFSET(B1,1,0):B11)-ROW(OFFSET(B1,1,0)),,1)), IF(OFFSET(B1,1,0):B11>"",MATCH("~"&OFFSET(B1,1,0):B11,OFFSET(B1,1,0):B11&"",0))),ROW(OFFSET(B1,1,0):B11)-ROW(OFFSET(B1,1,0))+1),1))
Spreadsheet: 0291f465-b049-4124-a850-3c656786fa77
Sheet: Sheet1

Unnamed: 0 | การยืมเงินราชการตามระบบ GFMIS | Unnamed: 2 | Unnamed: 3 | Unnamed: 4 | Unnamed: 5
ผู้รับผิดชอบ |  | ขั้นตอน |  | จุดควบคุม | เวลา
- อรุณี |  | รับเรื่องขอยืมเงินจากหน่วยงาน
- อิทธิพล
 | มีหนี้ | ตรวจสอบว่ามีหนี้เก่าค้างชำระ |  | - ตรวจสอบหนี้เก่าค้างชำระ
 |  | หรือไม่ |  | เพื่อไม่ให้เป็นหนี้ซ้ำ
 |  |  |  | - ตรวจประมาณการเพื่อมิให้เบิก
 |  | ตรวจสอบประมาณการ/สัญญายืม |  | คชจ.เกินความจำเป็นซึ่งเป็นไป
 |  | เงิน และเอกสารหลักฐานประกอบ |  | ตามระเบียบ กค.
 | ไม่ถูกต้อง | การยืมเงิน |  | - ลงวันที่กำกับการส่งเรื่องคืน
 |  |  |  | เพื่อควบคุมระยะเวลาดำเนินงาน
- อรุณี |  | [NAME] |  | ในแต่ละจุด
- สายพิณ |  | และส่งฝ่ายงบประมาณกันเงิน
 |  | งบประมาณ |  |  | 1 วัน
- อิทธิพล
- ฝ่ายการเงิน
- ฝ่ายบริหาร
- ฝ่ายการเงิน |  | ฝ่ายการเงินรับเรื่องที่อนุมัติแล้ว
 |  | ลงทะเบียนคุมการเบิก
- ฝ่ายงบประมาณ |  | ฝ่ายงบประมาณลงทะเบียนคุม
 |  | [NAME] (แยกผลผลิต)
- เฉลิมชัย | บัญชีรับเรื่องรอตรวจสอบการอนุมัติ |  | ฝ่ายการเงินนำเรื่องไปเขียนเช็ค
- ฝ่ายการเงิน | จากกรมบัญชีกลาง (RPT 503) และ |  | และเสนอลงนาม |  | ไม่อาจควบคุม
 | ธนาคารแจ้งการโอนเงิน (Statement) |  |  |  | เวลาได้
 | สำเนา RPT 503 & Statement ที่
 | เกี่ยวข้องให้ฝ่ายการเงิน
- ศรีสุราง |  | ลงบัญชีรับรู้ด้านรับ |  |  | 1 - 2 นาที / เรื่อง
-  ฝ่ายการเงิน |  | ฝ่ายการเงินจ่ายเงินยืม และ
 |  | จัดทำขอจ่าย (ขจ.) |  |  | 5 - 10 นาที
- อรุณี |  | จนท.เงินยืมรับเรื่องที่กรมลงนาม
 |  | ในเช็คสั่งจ่ายแล้วจากฝ่ายการเงิน
 |  | เตรียมเอกสารการจ่าย ติดต่อผู้ยืม/
 |  | ผู้รับมอบฉันทะมารับเงิน
- อรุณี |  | ลงทะเบียนคุมลูกหนี้เงินยืม
 |  | ให้เลขที่รายยืมเรียงตามลำดับที่ |  |  | 5 - 10 นาที
 |  | มารับเงิน
 |  | ผู้ยืมลงนามในทะเบียนคุมลูกหนี้
 |  | สัญญายืมเงินทั้ง 2 ฉบับ และใน
 |  | ใบสำคัญเพื่อจ่าย
 |  | ผู้ยืม / ผู้รับมอบฉันทะถือเรื่องที่
 |  | เกี่ยวข้องไปรับเงินที่ฝ่ายการเงิน |  |  | 1 - 2 นาที / เรื่อง
- ศรีสุราง |  | ฝ่ายบัญชีลงบัญชีรับรู้ด้านจ่าย
 |  | ตั้งเป็นลูกหนี้
 |  |  |  |  | 1 - 2 นาที / เรื่อง
- คณะกรรมการ |  | ส่งใบสำคัญที่บันทึกบัญชีแล้วให้ |  | - มีกรรมการตรวจสอบ
 |  | กรรมการตรวจสอบบัญชี |  | ด้านการเงิน & บัญชี เป็นประจำ
 |  | ประจำวันตรวจสอบความถูกต้อง |  | ทุกวัน | ระยะเวลาตามที่
 |  |  |  |  | กำหนดใน
- อรุณี |  | เก็บรักษาสัญญายืมเงิน |  |  | ระเบียบเงินยืม
 |  | เพื่อรอการล้างหนี้
- อรุณี |  | จนท.ผู้รับผิดชอบเงินยืมตรวจสอบ |  |  | 10 - 15 นาที
 |  | หนี้และจัดทำบันทึกเตือน / ทวงหนี้
 |  | เพื่อให้ลูกหนี้ส่งใช้เงินสด / ใบสำคัญ
 |  | เพื่อล้างหนี้ตามกำหนด 2 ครั้ง ครั้งที่ 3
 |  | เสนอกรมทราบเพื่อขอหักเงินเดือน
 |  | ใช้หนี้เงินยืมที่เกินกำหนดตามระเบียบ
 |  | บันทึกการส่งใช้หนี้เงินยืมทั้งเงินสด &
 |  | ใบสำคัญ ในทะเบียนคุมลูกหนี้และ |  |  | 1 - 2 นาที / เรื่อง
- อรุณี |  | ด้านหลังสัญญายืมเงินทุกครั้ง
 |  |  |  | ไม่ถูกต้อง
- อรุณี
- ฝ่ายการเงิน |  |  |  |  | 15 - 20 นาที
 |  |  |  | [NAME]
 |  | [NAME]
 |  | ส่งฝ่ายบัญชีจัดเก็บตามระเบียบ
Spreadsheet: 135754d1326218872-extracting-text-tc-excel-forum
Sheet: distribution

PERSON/AREA | ENGINE | TC
[NAME] | 1 | 0
AL NAKAYAMA | 1 | 0
DIANNE ASKEW | 1 | 1
[NAME] | 1 | 1
[NAME] | 1 | 0
SUSAN CHURCHILL | 1 | 1
[NAME] MARCHAND | 1 | 0
[NAME] DYKES | 1 | 0
RYAN BOCOOK | 1 | 1
DOC DARDEN | 1 | 1
RYAN GILKEY | 1 | 1
[NAME] | 1 | 0
TOTAL | 12 | 6
Spreadsheet: darrell_schoolcraft__7819__imbalsumm0109
Sheet: NGPL

 | 52862 |  | 6828
 | Measured | Scheduled | Measured | Scheduled | Imbalance
1 | 54408 | 54435 | -44838 | -19695
2 | 54768 | 54751 | -48946 | -19695
3 | 52724 | 52734 | -7981 | -19695
4 | 53199 | 54711 | -10156 | -19695
5 | 49733 | 49711 | -22954 | -30290
6 | 47560 | 47583 | -55424 | -63907
7 | 39727 | 39751 | -14089 | -22398
8 | 39566 | 39634 | -51249 | -49937
9 | 39696 | 39751 | -51429 | -49937
10 | 39685 | 39751 | -52771 | -49937
11 | 39693 | 39751 | -51659 | -54790
12 | 39687 | 39751 | -65758 | -65762
13 | 36525 | 36572 | -38103 | -34262
14 | 29653 | 29751 | -57330 | -56059
15 | 39643 | 39751 | -40107 | -39770
16
17
18
19
20
21
22
23
24
25
26
27
28
29
30
31
2001-08-31 00:00:00
2001-09-15 00:00:00
CBS Dollars
Spreadsheet: 707578d1607352638-request-to-simplify-multiple-nested-if-formula-for-bonus-factor-proportionate-calculator
Sheet: Sheet1

Measure | Threshold | Target | [NAME] for 1.5x | [NAME] for 2x | [NAME] | Result |  | [NAME]
Total Sales | 25 | 75 | 100 | 125 | 115
Department Sales | 10 | 15 | 20 | 25 | 15.4
Expense Management | 95 | 80 | 85 | 75 | 79
Payout Opportunity | 0 | 1 | 1.5 | 2
 |  |  |  |  | Total Multiplier
Spreadsheet: 35227d1232758161-using-lookup-with-conditions-sample-data
Sheet: Sheet1

Raw Data |  |  |  |  |  |  |  |  |  | What I would like to See in My Report
Ticket # | Date | Quantity | Price | Extended | Discount | Net | Supervisor |  |  | Ticket # | Date | Quantity | Price | Extended | Discount | Net | Supervisor
1234567 | 2009-01-01 00:00:00 | 3 | 24.95 |  | 0 |  | ELI
 |  | 5 | 14.95 |  | 0 |  | CIO
 |  | 1 | 17.75 |  | 0 |  | IEW
 |  | 7 |  |  | 0 |  | RT
 |  | 9 | 24.95 |  | 0 |  | ELI
 |  | 3 | 14.95 |  | 0 |  | CIO
 |  | 7 | 17.75 |  | 0 |  | IEW
 |  | 1 |  |  | 0 |  | RT
 |  | 12 | 24.95 |  |  |  | IEW
 |  | 6 | 14.95 |  | 0 |  | RT
 |  | 3 | 17.75 |  | 0 |  | ELI
 |  | 1 |  |  | 0 |  | CIO
 |  | 23 | 24.95 |  | 0 |  | IEW
 |  | 1 | 14.95 |  |  |  | RT
 |  | 7 | 17.75 |  |  |  | ELI
 |  | 15 |  |  |  |  | CIO
 |  | 8 | 24.95 |  | 0 |  | IEW
 |  | 2 | 14.95 |  | 0 |  | RT
 |  | 8 | 17.75 |  | 0 |  | RT
 |  | 2 |  |  | 0 |  | ELI
 |  | 7 | 24.95 |  | 0 |  | CIO
 |  | 3 | 14.95 |  | 0 |  | IEW
Spreadsheet: 843652d1695432338-formula-that-returns-a-value-based-on-alignment-of-a-set-of-columns-stock-comparison
Sheet: Sheet1

 |  | left 3 |  |  |  |  |  |  | right 2
 |  |  | right 2/right 1 |  |  |  |  | align
 |  | l3 | r2 |  |  |  |  | a | r2
 | 1 ext | t2 | t3 | [NAME] | t5 | t6 | t7 | t8 | t9 | t10 | t11 | t12 | t13 | t14 | t15
 | 1 | 0 | 0 | 1 | 2 | 0 | 2 | 1 | 0 | 7 | 2 | 3 | 6 | 8 | 11
all | 1 | 0 | 0 | 1 | 2 | 0 | 2 | 1 | 0 | 7 | 2 | 3 | 6 | 8 | 11
[NAME]) | 1 | 2 | 1 | 2 | 2 | 1 | 4 | 2 | 1 | 8 | 5 | 4 | 8 | 9 | 15
all(s/fexp) | 1 | 2 | 1 | 2 | 2 | 1 | 4 | 2 | 3 | 10 | 7 | 7 | 11 | 15 | 22
all(s/fexp) | 1 | 3 | 1 | 2 | 2 | 2 | 5 | 2 | 3 | 11 | 9 | 9 | 15 | 19 | 26
all(s/fexp) | 1 | 3 | 1 | 2 | 2 | 2 | 5 | 2 | 3 | 11 | 9 | 9 | 17 | 19 | 27
 | 1 | 3 | 1 | 2 | 3 | 3 | 6 | 3 | 4 | 12 | 10 | 10 | 18 | 20 | 29
 | 1 ext | t2 | t3 | [NAME] | t5 | t6 | t7 | t8 | t9 | t10 | t11 | t12 | t13 | t14 | t15
 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 3 | 1 | 2 | 2 | 4 | 6
all | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 4 | 2 | 2 | 2 | 4 | 6
[NAME]) | 0 | 0 | 0 | 0 | 2 | 0 | 1 | 1 | 1 | 5 | 5 | 3 | 4 | 6 | 9
all(s/fexp) | 1 | 1 | 0 | 0 | 2 | 0 | 3 | 2 | 2 | 7 | 7 | 5 | 6 | 8 | 12
all(s/fexp) | 1 | 1 | 0 | 0 | 3 | 0 | 3 | 2 | 2 | 8 | 8 | 7 | 9 | 11 | 15
all(s/fexp) | 1 | 1 | 0 | 0 | 3 | 0 | 3 | 2 | 2 | 8 | 8 | 7 | 9 | 11 | 15
 | 1 | 1 | 0 | 0 | 3 | 0 | 3 | 2 | 3 | 9 | 9 | 8 | 10 | 12 | 16