tianzl66/Sheetpedia huggingface dataset:
Spreadsheet: 62875d1263882334-using-nested-if-and-vlookup-to-extract-data-mthly_report
Sheet: Jan

ID | ITEM | Com_Date | ORDER No | CFM_DATE | ETA_DATE | REFERENCE | COMMENTS
1111 | AB123 | 2009-08-14 00:00:00 | 9100 | 2009-11-08 00:00:00 | 2009-11-15 00:00:00
2222 | DB437 | 2009-08-14 00:00:00 | 9100 | 2009-11-08 00:00:00 | 2009-11-15 00:00:00
8278 | CV839 | 2009-08-14 00:00:00 | 8299 | 2009-11-08 00:00:00 | 2009-11-15 00:00:00
7338 | [NAME] | 2009-08-14 00:00:00 | 8399 | 2009-11-08 00:00:00 | 2009-11-15 00:00:00
9567 | DS399 | 2009-08-14 00:00:00 | 8399 | 2009-11-08 00:00:00 | 2009-11-15 00:00:00
5378 | SA111 | 2009-08-14 00:00:00 | 8399 | 2009-11-08 00:00:00 | 2009-11-15 00:00:00
1930 | DZ220 | 2009-08-14 00:00:00 | 1999 | 2009-11-08 00:00:00 | 2009-11-15 00:00:00
6480 | PP930 | 2009-08-14 00:00:00 | 3900 | 2009-11-01 00:00:00 | 2009-11-15 00:00:00
3768 | [NAME] | 2009-08-14 00:00:00 | 3900 | 2009-11-01 00:00:00 | 2009-11-15 00:00:00
Spreadsheet: 865553d1712626580-help-with-index-match-mpp-ask-4-
Sheet: Sheet1

NAMA SALES | AREA | 2024-04-01 00:00:00 | 2024-04-02 00:00:00 | 2024-04-03 00:00:00 | 2024-04-04 00:00:00 | 2024-04-05 00:00:00 | 2024-04-06 00:00:00 | 2024-04-07 00:00:00 | 2024-04-08 00:00:00 | 2024-04-09 00:00:00 | 2024-04-10 00:00:00
SALES 1 | SIDAORJO | 1 | 1 | 1 | 1 | 1 | 1 | OFF | OFF | 1 | L
SALES 2 | SURABAYA | L | TSD | 1 | 1 | 1 | 1 | OFF | OFF | L | L
SALES 3 | SIDOARJO | TSD | 1 | 1 | 1 | TSD | 1 | 1 | OFF | L | 1
SALES 4 | SIDOARJO | 1 | 1 | 1 | 1 | 1 | 1 | OFF | 1 | 1 | 1
SALES 5 | SURABAYA | 1 | 1 | 1 | 1 | L | L | 1 | 1 | 1 | 1
SALES 6 | SURABAYA | 1 | L | 1 | L | L | L | OFF | OFF | 1 | 1
SALES 7 | SIDOARJO | 1 | 1 | TSD | 1 | 1 | 1 | OFF | OFF | 1 | 1
SALES 8 | SURABAYA | TSD | 1 | 1 | 1 | L | L | OFF | OFF | 1 | 1
DATE | 2024-04-01 00:00:00
AREA | SURABAYA
1
L
TSD
OFF
Spreadsheet: geir_solberg__11291__1-04act
Sheet: EPEData

 | 37356.88194444445
 | NEWMAN 1 ,UNAV, -0  , 75  , 39  , 83  ,  0  ,1
 | NEWMAN 2 ,MANL, 58  , 77  , 34  , 83  ,  0  ,1
 | NEWMAN 3 ,AVAL, -0  ,100  , 35  ,103  ,  0  ,1
 | NEWMN/GT1,UNAV,  0  , 60  , 18  , 60  ,  0  ,1
 | NEWMN/GT2,UNAV,  0  , 60  , 18  , 60  ,  0  ,1
 | NM/GT1+ST,UNAV,  0  ,100  , 61  ,107  ,  0  ,1
 | NM/GT2+ST,UNAV,  0  ,100  , 66  ,107  ,  0  ,1
 | NEWMAN 4 ,ECON,180  ,215  , 86  ,214  , 35  ,1
 | NEWMAN   ,, 238 ,  292,  120, 297 ,  35 ,
 | COPPER   ,[NAME], -0  , 69  , 15  , 69  ,  0  ,1
 | RIOGRAN 6,AVAL,  0  , 47  , 29  , 48  ,  0  ,1
 | RIOGRAN 7,AVAL,  0  , 38  , 32  , 49  ,  0  ,1
 | RIOGRAN 8,UNAV,  0  ,121  , 36  ,151  ,  0  ,1
 | RIOGRANDE,,   0 ,    0,    0,   0 ,   0 ,
 | PALOVERDE,MANL,602  ,600  ,600  ,600  ,  0  ,1
 | FOURCRNRS,UNAV, -2  , 90  , 90  ,104  ,  0  ,1
 | LAMBDA, 23.51,  718,  722,   96,  -52,    0, 9626,0
 | APS     ,STRT    ,FC,  ,   1,   1
 | IID     ,EXCS    ,FC,  ,  50,  50
 | IID     ,FIRM    ,PV,  , 100, 100
 | LDWP    ,ECON    ,PV,  ,  80,  80
 | PGT     ,LOSS    ,PV,  ,  -1,  -1
 | PNM     ,CNTG    ,LC,  ,  11,  11
 | PNM     ,LOSS    ,LC,  ,   2,   2
 | SPS     ,FIRM    ,WM,  ,-103,-103
 | SRP     ,FIRM    ,ED,  ,  25,  25
 | SRP     ,LOSS    ,PV,  ,   1,   1
 | TNP     ,FIRM    ,PV,  ,  25,  25
 | TNP     ,LOSS    ,PV,  ,  -5,  -5
 | WAPA    ,PASS    ,WM,HO,  -1,  -1
Spreadsheet: 42402d1240984175-excel-enquiry-over-multiple-sheets-sample-1
Sheet: New York

 |  |  |  |  |  | Qtr 1 | Qtr 2 | Qtr 3 | Qtr 4 | Total |  | Operation | Project | Process | Category | Object | Component | Code
 | Data group 1
 |  | Data group 1 sub 1
 |  |  | Data line 1 |  |  | 157 | 60 | 86 | 125 | 428 |  | 14 | 18 | 11 | 11 | 10 | 11 | [PHONE]
 |  |  | Data line 2 |  |  | 95 | 75 | 48 | 98 | 316 |  | 14 | 18 | 11 | 11 | 11 | 18 | [PHONE]
 |  |  | Data line 3 |  |  | 41 | 44 | 127 | 126 | 338 |  | 14 | 18 | 11 | 11 | 10 | 18 | [PHONE]
 |  | Data group 1 sub 2 |  |  |  |  |  |  |  | 0
 |  |  | Data line 1 |  |  | 36 | 77 | 16 | 142 | 271 |  | 14 | 18 | 18 | 11 | 11 | 18 | [PHONE]
 |  |  | Data line 2 |  |  | 3 | 80 | 14 | 15 | 112 |  | 14 | 18 | 18 | 11 | 13 | 14 | [PHONE]
 |  |  | Data line 3 |  |  | 39 | 7 | 40 | 51 | 137 |  | 14 | 18 | 18 | 13 | 15 | 16 | [PHONE]
 | Data group 3 |  |  |  |  |  |  |  |  | 0
 |  |  | Data line 1 |  |  | 38 | 162 | 50 | 141 | 391 |  | 14 | 13 | 18 | 13 | 15 | 16 | [PHONE]
 |  |  | Data line 2 |  |  | 156 | 49 | 90 | 29 | 324 |  | 14 | 13 | 18 | 18 | 11 | 18 | [PHONE]
 |  |  | Data line 3 |  |  | 55 | 149 | 128 | 120 | 452 |  | 14 | 13 | 18 | 11 | 13 | 14 | [PHONE]
 | Data group 4 |  |  |  |  |  |  |  |  | 0
 |  | Data group 4 sub 1 |  |  |  |  |  |  |  | 0
 |  |  | Data line 1 |  |  | 46 | 63 | 104 | 129 | 342 |  | 14 | 14 | 13 | 18 | 13 | 14 | [PHONE]
 |  |  | Data line 2 |  |  | 18 | 164 | 150 | 154 | 486 |  | 14 | 14 | 13 | 18 | 15 | 16 | [PHONE]
 |  |  | Data line 3 |  |  | 165 | 101 | 78 | 20 | 364 |  | 14 | 14 | 13 | 13 | 11 | 18 | [PHONE]
 |  |  | Overhead 4 |  |  | 161 | 130 | 4 | 121 | 416 |  | 14 | 14 | 13 | 11 | 13 | 14 | [PHONE]
 |  | Data group 4 sub 2 |  |  |  |  |  |  |  | 0
 |  |  | Data line 1 |  |  | 23 | 74 | 19 | 107 | 223 |  | 14 | 15 | 13 | 14 | 11 | 18 | [PHONE]
 |  |  | Data line 2 |  |  | 59 | 72 | 56 | 27 | 214 |  | 14 | 15 | 13 | 16 | 13 | 14 | [PHONE]
 |  |  | Data line 3 |  |  | 115 | 82 | 73 | 66 | 336 |  | 14 | 15 | 13 | 16 | 15 | 16 | [PHONE]
 |  |  | Data line 4 |  |  | 47 | 135 | 143 | 146 | 471 |  | 14 | 15 | 13 | 11 | 11 | 18 | [PHONE]
 |  |  | Data line 5 |  |  | 35 | 112 | 17 | 113 | 277 |  | 14 | 15 | 13 | 18 | 13 | 14 | [PHONE]
 |  |  | Data line 6 |  |  | 92 | 64 | 163 | 160 | 479 |  | 14 | 15 | 13 | 15 | 15 | 14 | [PHONE]
Spreadsheet: 106882d1304021224-excel-2007-rounded-numbers-have-values-many-decimal-places-in-excel-help
Sheet: Sheet1

-3932.42
77.95
15
762.86
178.25
205.25
279.85
103.24
154.52
10.33
276.56
147.68
238.08
200.46
189.71
184.33
308.51
183.43
122.73
193.79
99.89
Spreadsheet: 4a85ab1a-e079-4365-8158-053c08d6a491
Sheet: Sheet1

Student Payroll Pay Rate (Wage) Change Request | Unnamed: 1 | Unnamed: 2 | Unnamed: 3 | Unnamed: 4 | Unnamed: 5 | Unnamed: 6
 |  | This form is to be used by departments to submit wage increase requests for approvel to Human Resources. Submit forms to [EMAIL]; approval will be sent via email to address indicated below.
For guidelines on student wage rates, see "Student Job Classifications", http://www.uwosh.edu/hr/students/StudentJobClassifications.pdf
[NAME]
Fund | Dept ID | Program | Project/Grant ID | Department Title |  | [NAME] to [NAME] To:
Student Name Last, First MI |  |  | EMPL ID / Record # | Old Rate | New Rate | Effective Date
Approvals:
 |  |  |  |  |  | HR Approval Only
Employing Unit Coordinator |  |  |  |  | Date | (HR Representative Initials and Date)
Department Chair/Director |  |  |  |  | Date
Spreadsheet: 104750d1302209144-hlookup-sum-problem-hlookup-problem
Sheet: Sheet1

 | 2010-09-26 00:00:00
 | Sun | Mon | Tue | Wed | Thu | Fri | Sat |  | Sun | Mon | Tue | Wed | Thu | Fri | Sat
Rebag | 1.454099566169029 | 5.956355985824467 | 6.099039364686471 | 5.751586392330017 | 5.213364319967178 | 6.350147132434706 | 1.366769782425621 | 0.0251238632172726 | 2.481738306473405 | 10.03309268377597 | 8.558098608491873 | 8.10355579494363 | 7.801431380887908 | 9.70270751755319 | 2.233564475826064 | 0.04665811501249964
Exceptions | 0.6707321161918225 | 2.747486725196828 | 2.813302249027599 | 2.653032709824194 | 2.404767159117667 | 2.929130661587898 | 0.6304495303087172 | 0.01158887763582228 | 1.000815563167387 | 4.046065323822426 | 3.451241517350374 | 3.267937129156675 | 3.146098813323339 | 3.912830238022718 | 0.9007340068506478 | 0.01881591122269439
 | 2010-09-26 00:00:00
 | I want [NAME] to look the date and sum 7 cell togeather
 | example rebag lookup date 26-Sep and total should be = 32.19
 | 7 day sum | week avg
Spreadsheet: 189655d1351267816-main-information-row-with-sub-row-test_example
Sheet: Transaction

CustID | Part | Qty | [NAME] | TranDate
123 | AA | 2 | Stock | 2012-10-01 00:00:00
123 | AA | 1 | Replace | 2012-09-06 00:00:00
123 | AB | 1 | Stock | 2012-05-03 00:00:00
123 | AB | 1 | Stock | 2012-02-01 00:00:00
123 | AC | 1 | Replace | 2012-03-04 00:00:00
123 | BA | 1 | Stock | 2012-06-04 00:00:00
123 | BA | 2 | Stock | 2012-07-01 00:00:00
123 | BB | 1 | Replace | 2012-07-05 00:00:00
123 | BB | 1 | Stock | 2012-05-03 00:00:00
123 | BB | 1 | Stock | 2012-06-29 00:00:00
Spreadsheet: 30341d1225818750-simple-conditional-formatting-sausages
Sheet: Sheet1

sausages | 1 |  | 1.  [NAME], click Conditional formatting.
 | 2 |  | 2.  Select "Use a formula to determine which cells to format"
bread | 3 |  | 3.  Enter the formula : =$A2="sausages"
milk | 4 |  | 4.  [NAME], click the Format Painter icon, click [NAME]
 | 5
sausages | 6
sausages | 7
 | 8
bread | 9
milk | 10
bread | 11
milk | 12
Spreadsheet: 741425d1627036782-cell-formula-not-working-on-spreadsheet-fixed-assets-register-2021
Sheet: Shep Huts

Year Ending 31 March 2021
Fixed Asset Register
Shed Huts |  |  |  | Cost | [NAME] | C/Fwd | Disposals | Additions | [NAME] | [NAME] | NBV | Proceeds | Profit or Loss
Spreadsheet: 94839d1294607432-retreiving-multiple-matches-values-in-same-row-if-x-is-true-1test
Sheet: Name

NAME
 |  | Line A |  |  |  |  | Line B |  |  |  |  | Line C |  |  |  |  | Line D
 |  | Zone 1 | Zone 2 | Zone 3 | Zone 4 | Zone 5 | Zone 1 | Zone 2 | Zone 3 | Zone 4 | Zone 5 | Zone 1 | Zone 2 | Zone 3 | Zone 4 | Zone 5 | Zone 1 | Zone 2 | Zone 3 | Zone 4 | Zone 5
Saturday | 2011-01-01 00:00:00 | [NAME] | [NAME] | [NAME] | [NAME] | [NAME] | [NAME] | [NAME] | [NAME] | [NAME] | [NAME] | [NAME] | [NAME] Bright | [NAME] | [NAME] | [NAME] | [NAME] | [NAME] | [NAME] | [NAME] | Clarissa Roberson
Sunday | 2011-01-02 00:00:00 | [NAME] | [NAME] | [NAME] | [NAME] | [NAME] | [NAME] | [NAME] | [NAME] | [NAME] | [NAME] | [NAME] | [NAME] Bright | [NAME] | [NAME] | [NAME] | [NAME] | [NAME] | [NAME] | [NAME] | Clarissa Roberson
Monday | 2011-01-03 00:00:00 | [NAME] | [NAME] | [NAME] | [NAME] | [NAME] | [NAME] | [NAME] | [NAME] | [NAME] | [NAME] | [NAME] | [NAME] Bright | [NAME] | [NAME] | [NAME] | [NAME] | [NAME] | [NAME] | [NAME] | Clarissa Roberson
Tuesday | 2011-01-04 00:00:00 | [NAME] | [NAME] | [NAME] | [NAME] | [NAME] | [NAME] | [NAME] | [NAME] | [NAME] | [NAME] | [NAME] | [NAME] Bright | [NAME] | [NAME] | [NAME] | [NAME] | [NAME] | [NAME] | [NAME] | Clarissa Roberson
Wednesday | 2011-01-05 00:00:00 | [NAME] | [NAME] | [NAME] | [NAME] | [NAME] | [NAME] | [NAME] | [NAME] | [NAME] | [NAME] | [NAME] | [NAME] Bright | [NAME] | [NAME] | [NAME] | [NAME] | [NAME] | [NAME] | [NAME] | Clarissa Roberson
Thursday | 2011-01-06 00:00:00 | [NAME] | [NAME] | [NAME] | [NAME] | [NAME] | [NAME] | [NAME] | [NAME] | [NAME] | [NAME] | [NAME] | [NAME] Bright | [NAME] | [NAME] | [NAME] | [NAME] | [NAME] | [NAME] | [NAME] | Clarissa Roberson
Friday | 2011-01-07 00:00:00 | [NAME] | [NAME] | [NAME] | [NAME] | [NAME] | [NAME] | [NAME] | [NAME] | [NAME] | [NAME] | [NAME] | [NAME] Bright | [NAME] | [NAME] | [NAME] | [NAME] | [NAME] | [NAME] | [NAME] | Clarissa Roberson
Saturday | 2011-01-08 00:00:00
Sunday | 2011-01-09 00:00:00
Monday | 2011-01-10 00:00:00
Tuesday | 2011-01-11 00:00:00
Wednesday | 2011-01-12 00:00:00
Thursday | 2011-01-13 00:00:00
Friday | 2011-01-14 00:00:00
Saturday | 2011-01-15 00:00:00
Sunday | 2011-01-16 00:00:00
Monday | 2011-01-17 00:00:00
Tuesday | 2011-01-18 00:00:00
Wednesday | 2011-01-19 00:00:00
Thursday | 2011-01-20 00:00:00
Friday | 2011-01-21 00:00:00
Saturday | 2011-01-22 00:00:00
Sunday | 2011-01-23 00:00:00
Monday | 2011-01-24 00:00:00
Tuesday | 2011-01-25 00:00:00
Wednesday | 2011-01-26 00:00:00
Thursday | 2011-01-27 00:00:00
Friday | 2011-01-28 00:00:00
Saturday | 2011-01-29 00:00:00
Sunday | 2011-01-30 00:00:00
Monday | 2011-01-31 00:00:00
Spreadsheet: 838763d1691376171-trying-to-find-the-sums-of-2tables-838719d1691305078-trying-to-find-the-sums-of-2tables-invoices-2023-
Sheet: ΣΤΑΤΙΣΤΙΚΑ 

ΣΚΦ |  |  |  | ΦΑΙΔΡΑ |  |  |  | ΣΚΦ |  |  |  | ΦΑΙΔΡΑ
ΑΓΟΡΕΣ |  |  |  | ΑΓΟΡΕΣ |  |  |  | ΕΞΟΔΑ |  |  |  | ΕΞΟΔΑ
[NAME] | ΓΕΝΙΚΟ ΣΥΝΟΛΟ ΑΓΟΡΩΝ | ΑΡΙΘΜΟΣ ΤΙΜΟΛΟΓΙΩΝ |  | [NAME] | ΓΕΝΙΚΟ ΣΥΝΟΛΟ ΑΓΟΡΩΝ | ΑΡΙΘΜΟΣ ΤΙΜΟΛΟΓΙΩΝ |  | [NAME] | ΓΕΝΙΚΟ ΣΥΝΟΛΟ ΑΓΟΡΩΝ | ΑΡΙΘΜΟΣ ΤΙΜΟΛΟΓΙΩΝ |  | [NAME] | ΓΕΝΙΚΟ ΣΥΝΟΛΟ ΑΓΟΡΩΝ | ΑΡΙΘΜΟΣ ΤΙΜΟΛΟΓΙΩΝ |  | ΠΡΟΜΗΘΕΥΤΗΣ | Sum of ΠΟΣΟ | Count of ΑΡΙΘΜΟΣ ΤΙΜ
AQUASERA IKE | 1533.38 | 4 |  | ΓΙΑΝΝΑΚΑΚΗΣ | 1213.37 | 3 |  | AMAZON TECHNOLOGY | 52.64 | 1 |  | ΜΑΚΡΗΣ | 371.1 | 8 |  |  | 1533.38 | 4
ECO | 4166.440000000001 | 15 |  | [NAME] | 15520.95 | 25 |  | EASY MARKET | 71.84 | 5 |  | ΠΑΠΑΘΑΝΑΣΗΣ | 156.11 | 2 |  | ECO | 4166.440000000001 | 15
PHARMAID | 11930.01 | 16 |  | ΚΕΣΙΔΗΣ | 52907.17000000002 | 67 |  | GADGET4YOU | 28.85 | 1 |  | [NAME] | 527.21 | 10 |  | PHARMAID | 11930.01 | 16
ΒΑΛΑΗΣ | 691.3000000000001 | 3 |  | ΝΑΟΥΜ | 2062.72 | 3 |  | OGGI | 185.87 | 13 |  |  |  |  |  | ΒΑΛΑΗΣ | 691.3000000000001 | 3
ΓΑΝΩΤΑΚΗΣ | 281.23 | 1 |  | ΡΙΖΕΣ | 4804.21 | 6 |  | PRO COMPIOUTER  SERVISES | 43.4 | 1 |  |  |  |  |  | ΓΑΝΩΤΑΚΗΣ | 281.23 | 1
ΓΙΑΝΝΑΚΑΚΗΣ | 2902.49 | 6 |  | ΣΤΡΕΜΜΕΝΟΣ | 498.48 | 2 |  | STUDIO LIFE | 59 | 1 |  |  |  |  |  | ΓΙΑΝΝΑΚΑΚΗΣ | 4115.860000000001 | 9
[NAME] | 36172.49000000001 | 29 |  | ΦΑΙΣΤΑ | 8446.079999999998 | 23 |  | TECHFACE | 7.4 | 1 |  |  |  |  |  | [NAME] | 51693.44 | 54
ΚΑΛΛΑΣ ΣΤΑΥΡΟΣ | 573.6400000000001 | 3 |  | ΧΟΥΛΗΣ | 8730.839999999998 | 14 |  | ΗΛΕΚΤΡΟΦΑΣΗ | 201.5 | 1 |  |  |  |  |  | ΚΑΛΛΑΣ ΣΤΑΥΡΟΣ | 573.6400000000001 | 3
ΚΕΣΙΔΗΣ | 18752.49 | 21 |  | [NAME] | 94183.82 | 143 |  | ΚΑΤΣΑΜΟΥΝΗΣ | 400 | 1 |  |  |  |  |  | ΚΕΣΙΔΗΣ | 71659.66000000002 | 88
ΜΟΥΤΣΙΟΣ | 29610.02 | 5 |  |  |  |  |  | ΚΟΥΓΙΟΣ | 48.57000000000001 | 3 |  |  |  |  |  | ΜΟΥΤΣΙΟΣ | 29610.02 | 5
ΝΑΟΥΜ | 3550.74 | 5 |  |  |  |  |  | ΚΩΤΣΟΒΟΛΟΣ | 138 | 1 |  |  |  |  |  | ΝΑΟΥΜ | 5613.46 | 8
ΠΟΤΑΜΙΤΗΣ | 654.72 | 2 |  |  |  |  |  | ΜΑΚΡΗΣ | 867.1999999999999 | 21 |  |  |  |  |  | ΠΟΤΑΜΙΤΗΣ | 654.72 | 2
ΡΙΖΕΣ | 4329.25 | 5 |  |  |  |  |  | ΝΤΕΛΗΓΙΩΡΓΗΣ ΒΑΣΙΛΗΣ | 1300 | 1 |  |  |  |  |  | ΡΙΖΕΣ | 9133.46 | 11
ΣΤΡΕΜΜΕΝΟΣ | 1261.08 | 4 |  |  |  |  |  | ΠΑΠΑΘΑΝΑΣΗΣ | 1092.14 | 17 |  |  |  |  |  | ΣΤΡΕΜΜΕΝΟΣ | 1759.56 | 6
ΤΣΑΓΚΟΓΕΩΡΓΑΣ | 208.51 | 1 |  |  |  |  |  | ΣΠΑΝΟΣ | 16.1 | 1 |  |  |  |  |  | ΤΣΑΓΚΟΓΕΩΡΓΑΣ | 208.51 | 1
ΦΑΙΣΤΑ | 21172.86 | 24 |  |  |  |  |  | [NAME] | 4512.510000000004 | 69 |  |  |  |  |  | ΦΑΙΣΤΑ | 29618.94 | 47
ΦΤΑΚΛΑΣ | 333.9 | 1 |  |  |  |  |  |  |  |  |  |  |  |  |  | ΦΤΑΚΛΑΣ | 333.9 | 1
ΧΟΥΛΗΣ | 7537.03 | 7 |  |  |  |  |  |  |  |  |  |  |  |  |  | ΧΟΥΛΗΣ | 16267.87 | 21
[NAME] | 145661.5799999999 | 152 |  |  |  |  |  |  |  |  |  |  |  |  |  | Grand Totals | 239845.4 | 295
Spreadsheet: 00c29aa8-b6b9-44e2-ab5f-e4d0f8f3238f
Sheet: Bihar

Place | Address | Contact Person / NO | Mutt | Other Places near by
Gaya | Manager | Phone No.: [PHONE] | [NAME],
 | Shri Vidyadheesha Bhavana, | [PHONE]
 | [NAME],
 | Vishnapadamandir,
 | Gaya - 823 001. (Bihar)
Gaya | Sri.M.N.Bachu Achar, | 0631 - 2422723.
 | [NAME], Nai Sadak Road,
 | (Near) [NAME], GAYA-823 001.
Gaya | Mantralaya Ramacharya | 0631 – 434685 | [NAME]
 | [NAME], [NAME]
 | GAYA – 823 001, Bihar
Gaya | [NAME] | Shri Raghavendra Acharya
 | Panchmohalla, GAYA – 823 001, Bihar | C/o [NAME]
 |  | 0631 – 2435432;  2422723
Spreadsheet: 92800d1292347330-how-to-do-a-formula-within-a-formula-s-help
Sheet: Sheet1

Team | RANK | POINTS
A | 1
B | 2
C | 3
D | 4
E | 5
A | 1
B | 2
C | 3
D | 4
A | 1
B | 2
C | 3
D | 4
E | 5
F | 6
G | 7
A | 1
B | 2
C | 3
A | 1
B | 2
C | 3
D | 4
E | 5
Spreadsheet: kimberly_watson__20555__imbalsumm0108
Sheet: Citizens

Citizens Communications
 | Measured | Scheduled | Imbalance
56659 | -28297 | -3159
500046 | -659 |  |  |  |  |  |  |  |  | 2000-01-06 00:00:00 | paper | 0.5
500086 |  |  |  |  |  |  |  |  |  |  | lunch | 7.6
500134 | -25
500528
500529
500619
INDEX
2001-07-31 00:00:00 |  |  | -856340.66
2001-08-27 00:00:00
CBS Volume
 |  |  | -187753
Spreadsheet: 77655d1278077612-duplicates-study-number-book1
Sheet: Sheet1

Spreadsheet 1 |  |  | Spreadsheet2
Study number | Hospital number |  | Study number | Hospital number
1 | 2070600 |  |  | 2070600
2 | 2070601 |  |  | 2070600
3 | 2070604 |  |  | 2070600
4 | 2070610 |  |  | 2070600
5 | 2070615 |  |  | 2070600
6 | 2070616 |  |  | 2070600
7 | 2070618 |  |  | 2070600
8 | 2070619 |  |  | 2070601
9 | 2070630 |  |  | 2070601
etc | etc |  |  | 2070604
etc | etc |  |  | 2070604
 |  |  |  | 2070604
 |  |  |  | 2070604
 |  |  |  | 2070604
 |  |  |  | 2070604
 |  |  |  | 2070604
 |  |  |  | etc
 |  |  |  | etc
Spreadsheet: 756380d1637491665-find-unique-values-on-multiple-criteria-and-between-dates-2112021-sample-file
Sheet: Sheet1

Date | StaffName | SalaryCriteria | LWPDays | RetLWPSalary
2021-10-31 00:00:00 | GSD | RET | 0 | 50000 |  |  | Criteria
2021-11-30 00:00:00 | SSD | RET | 0 | 55000 |  |  | Previous month | 2021-10-31 00:00:00 | Current month | 2021-11-30 00:00:00 | SalaryCriteria | LWP
2021-11-30 00:00:00 | PNL | RET | 0 | 25000
2021-11-30 00:00:00 | TPS | LWP | 0 | 60000 |  |  | I want UNIQUE Staff Names from list on above prescribed multiple criterias
2021-11-30 00:00:00 | AMS | LWP | 30 | 36700
2021-11-30 00:00:00 | MSP | CONT | 0 | 175000 |  |  | Result I want is UNIQUE Staff Names
2021-11-30 00:00:00 | CGM | CONT | 0 | 85000 |  |  |  | RetLWPSalary | RetLWPSalary
2021-10-31 00:00:00 | MWL | CONT | 0 | 175000 |  |  | Staff Name |  |  | Difference
2021-10-31 00:00:00 | CGM | CONT | 0 | 85000 |  |  |  | 0 | 60000
2021-10-31 00:00:00 | AMS | LWP | 30 | 36943 |  |  |  | 36943 | 36700
Spreadsheet: 843561d1695333528-creating-a-table-with-variable-values-based-on-dropdown-selection-copy-of-sample-data-
Sheet: Sheet2

 |  |  | Q1 | Q2 | Q3 | Q4 | Total |  |  | Q1 | Q2 | Q3 | Q4 | Total
 |  | Vendor 1 | 10 | 12 | 18 | 19 |  |  | Material 1 | 10 | 40 | 70 | 100
 |  | Vendor 2 | 10 | 10 | 10 | 10 |  |  | Material 2 | 20 | 50 | 80 | 110
 |  | Vendor 3 | 11 | 11 | 11 | 11 |  |  | Material 3 | 30 | 60 | 90 | 20
 |  |  |  |  |  |  |  |  | Material | Material 3 | The table values would change based on the drop down selections
 |  |  |  |  |  |  |  |  | Vendor | Vendor 2
 |  | Car 1 |  |  |  |  |  |  | Car | Car 2
 | Demand Plan |  | Q1 | Q2 | Q3 | Q4 | Total
 |  | USA | 10 |  |  |  |  |  |  | Q1 | Q2 | Q3 | Q4
 |  | CANADA | 20 |  |  |  |  |  | USA
 |  | Mexico | 30 |  |  |  |  |  | CANADA
 |  |  |  |  |  |  |  |  | Mexico
 |  | Car 2
 |  |  | Q1 | Q2 | Q3 | Q4 | Total
 |  | USA
 |  | CANADA |  |  |  |  |  |  | Car 1
 |  | Mexico |  |  |  |  |  |  |  | Vendor 1 | Vendor 2 | Vendor 3 | Vendor 4 | Total
 |  |  |  |  |  |  |  |  | Material 1 | 10 | 40 | 70 | 100
 |  | Car 3 |  |  |  |  |  |  | Material 2 | 50 | 80 | 90 | 220
 |  |  | Q1 | Q2 | Q3 | Q4 | Total |  | Material 3 | 145 | 175 | 185 | 315
 |  | USA
 |  | CANADA |  |  |  |  |  |  | Car 2
 |  | Mexico |  |  |  |  |  |  |  | Vendor 1 | Vendor 2 | Vendor 3 | Vendor 4 | Total
 |  |  |  |  |  |  |  |  | Material 1 | 25 | 100 | 175 | 250
 |  |  |  |  |  |  |  |  | Material 2 | 125 | 200 | 225 | 550
 |  |  |  |  |  |  |  |  | Material 3 | 362.5 | 437.5 | 462.5 | 787.5
 |  |  |  |  |  |  |  |  | Car 3
 |  |  |  |  |  |  |  |  |  | Vendor 1 | Vendor 2 | Vendor 3 | Vendor 4 | Total
 |  |  |  |  |  |  |  |  | Material 1 | 6.25 | 25 | 43.75 | 62.5
 |  |  |  |  |  |  |  |  | Material 2 | 31.25 | 50 | 56.25 | 137.5
 |  |  |  |  |  |  |  |  | Material 3 | 90.625 | 109.375 | 115.625 | 196.875
Spreadsheet: 818803d1677063198-help-neededwith-sumif-moreleta-stock-sale-register
Sheet: STOCK ON HAND

PRODUCT DESCRIPTION | QTY | PRODUCT PRICE | Stock on hand | Discrepancy
AUDIFON BATTERY 10 |  | 40
AUDIFON BATTERY 13 |  | 40
AUDIFON BATTERY 312 |  | 40
AUDIFON BATTERY 675 |  | 40
RAYOVAC BATTERY 10 |  | 50
RAYOVAC BATTERY 13 |  | 50
RAYOVAC BATTERY 312 |  | 50
RAYOVAC BATTERY 675 |  | 50
WAX GUARD (PACK OF 8) |  | 150
WAX GUARD (SINGLE SELL) |  | 20
WAX GUARD (SERVICE) |  | 0
DRYING CAPSULES |  | 30
UNITIP OPEN DOME 7MM |  | 60
UNITIP POWER DOME LARGE |  | 60
UNITIP POWER DOME MEDIUM |  | 60
UNITIP POWER DOME SMALL |  | 60
EGGER DRY TUBE |  | 100
PROWAX |  | 200
WAX GUARD HF 3 BLACK |  | ?
KAPAK ELECTRIC DISINCTION DRYER |  | 1100
NOIZEZZ PREMIUM MUSIC - MILD |  | 1250
NOIZEZZ PREMIUM MUSIC - STRONG |  | 1250
NOIZEZZ PREMIUM MUSIC - MILD |  | 1250
NOIZEZZ PREMIUM - STRONG |  | 650
NOIZEZZ PREMIUM - MILD |  | 650
NOIZEZZ PLUG & PLAY - MEDIUM |  | 300
NOIZEZZ PLUG & PLAY - MILD |  | 300
[NAME] CL7350AD |  | 2300
[NAME] |  | 1400
[NAME] |  | 2200
[NAME] 50 |  | 2700
HF2 FILTER |  | ?
EASY THIN TUBES 0A (RIGHT) |  | 60
EASY THIN TUBES 0A (RIGHT) |  | 60
EASY THIN TUBES 0B (LEFT) |  | 60
EASY THIN TUBES 0B (RIGHT) |  | 60
EASY THIN TUBES 1A (LEFT) |  | 60
EASY THIN TUBES 1A (RIGHT) |  | 60
EASY THIN TUBES 1B (LEFT) |  | 60
EASY THIN TUBES 1B (RIGHT) |  | 60
EASY THIN TUBES 2B (LEFT) |  | 60
EASY THIN TUBES 2B (RIGHT) |  | 60
EASY THIN TUBES 3A (LEFT) |  | 60
EASY THIN TUBES 3A (RIGHT) |  | 60
EASY THIN TUBES 3B (LEFT) |  | 60
EASY THIN TUBES 3B (RIGHT) |  | 60
Full test |  | 600
Spreadsheet: 836035d1689061907-extract-data-based-on-two-dates-sample
Sheet: CT

start | 2023-01-01 00:00:00
end | 2023-12-31 00:00:00
S/N | Customer | Name | Due date
Spreadsheet: 865247d1712300713-median-price-for-a-table-with-price-ranges-and-inventory-median-example-2-aligw
Sheet: Sheet1

SUBCLASS | 29.9 | 35.9 | 39.9 | 45.9 | 55.9 | 69.9 | 89.9 | 99.9 | 109.9 | 129.9 | 139.9 | 149.9 | 159.9 | 189.9 | 199.9 | 249.9 | 279.9 | 299.9 | 349.9 | 499.9 | SUM | Average | Median | AliGW
coats |  |  |  |  |  |  |  |  |  |  |  |  | 6 | 2 | 4 |  | 4 | 5 | 3 |  | 24 | 241.9833333333333 | 239.9
dresses_knitted |  |  |  |  |  | 2 | 2 | 3 | 2 | 2 | 5 | 4 | 1 | 1 |  |  |  |  |  |  | 22 | 124.9 | 134.9
dresses_woven |  |  |  |  | 4 |  | 14 | 20 | 25 | 17 | 27 | 11 | 14 | 5 |  |  |  |  |  |  | 137 | 124.4547445255474 | 129.9
jackets |  |  |  |  |  |  |  |  |  |  | 11 | 1 | 14 | 12 | 8 | 2 | 10 | 3 | 1 | 1 | 63 | 204.0269841269841 | 189.9
jeans_shorts |  |  |  |  |  |  | 5 |  | 15 | 9 | 11 |  | 4 | 1 |  |  |  |  |  |  | 45 | 125.2333333333333 | 129.9
jeans_trousers |  |  |  |  |  |  |  |  | 29 |  | 69 |  | 63 | 16 | 5 | 1 |  | 1 |  |  | 184 | 149.4652173913044 | 139.9
jogging_tops |  |  |  |  |  | 5 | 4 | 4 | 6 | 2 | 8 | 5 | 11 | 14 |  |  |  |  |  |  | 59 | 140.9169491525424 | 149.9
outer_jackets |  |  |  |  |  |  |  |  |  |  |  |  |  | 4 | 4 |  |  |  |  |  | 8 | 194.9 | 194.9
shirts_l_s |  |  |  |  |  |  | 2 | 10 | 16 | 1 | 2 | 3 |  |  |  |  |  |  |  |  | 34 | 111.6647058823529 | 109.9
shirts_s_s |  |  |  |  |  |  | 3 | 3 | 2 |  |  |  |  | 1 |  |  |  |  |  |  | 9 | 108.7888888888889 | 99.9
shorts |  |  | 5 |  | 2 | 3 | 5 | 6 | 10 |  | 6 |  | 2 |  |  |  |  |  |  |  | 39 | 98.15641025641027 | 99.9
skirts |  |  |  |  |  | 6 | 1 | 5 | 16 | 15 | 26 |  | 4 |  |  |  | 1 |  |  |  | 74 | 125.3054054054054 | 129.9
sweaters |  |  |  |  |  |  | 28 | 9 | 22 | 24 | 11 |  | 3 |  |  |  |  |  |  |  | 97 | 113.0958762886598 | 109.9
trousers |  |  |  |  |  | 14 | 1 | 6 | 25 | 31 | 44 |  | 19 | 16 | 4 |  |  |  |  |  | 160 | 134.2125 | 139.9
t-shirts_l_s |  |  | 2 | 14 | 15 | 19 | 26 | 16 | 3 |  |  |  |  | 1 |  |  |  |  |  |  | 96 | 76.50416666666665 | 69.9
t-shirts_s_s | 20 | 8 | 10 | 5 | 21 | 29 | 48 | 55 | 3 | 2 | 4 |  |  |  |  |  |  |  |  |  | 205 | 76.45609756097562 | 89.9
t-shirts_sleeveless | 14 | 8 | 9 | 5 | 28 | 34 | 39 | 22 | 9 | 4 |  |  |  |  |  |  |  |  |  |  | 172 | 72.37674418604652 | 69.9
Spreadsheet: 742572d1627894759-relative-references-to-tables-in-different-workbooks-same-folder-with-indirect-source
Sheet: Data

 | TABLE NAME : | Weight |  | TABLE NAME : | Volume
 | Group | [NAME] |  | Group | litres
 | [NAME] | 5.2 |  | [NAME] | 100
 | [NAME] | 5.1 |  | [NAME] | 97
 | [NAME] | 4.9 |  | [NAME] | 98
 | [NAME] | 9.5 |  | [NAME] | 198
 | [NAME] | 10.2 |  | [NAME] | 200
 | [NAME] | 11 |  | [NAME] | 205
 | [NAME] | 19 |  | [NAME] | 300
 | [NAME] | 20.1 |  | [NAME] | 303
 | [NAME] | 21 |  | [NAME] | 309