tianzl66/Sheetpedia huggingface dataset:
Spreadsheet: 260529d1377444920-vlookup-from-different-sheets-data-tracker
Sheet: Loan Tracker

Number | Number 1 | BPO AS IS | BPO AS REPAIRED | BPO DATE
609504303 | 1710814581 |  |  |  |  | FIND CELL A1 IN BPO DATA IF NOT FOUND THEN FIND B1 IN BPO DATA
609563069 | 1712011132
596742648 | 1703840432 |  |  |  |  | FIND CELL B1 IN PREVIOUS SERVICER DATA IF NOT FOUND THEN FIND IN BPO DATA
608800058 | 1695459050
607442100 | 1702444472 |  |  |  |  | FOR DATE IF CELL FOUND VALUE THEN PICK UP DATE
596727439 | 1702306108
596525701 | 1701700436 |  |  |  |  |  | INDICATE COMMAN VALUES
607314119 | 1700641726
596727993 | 1702320619 |  |  |  |  |  | INDICATE COMMAN VALUES
609258306 | 1703291783
607420874 | 1701981556
596700976 | 4004493368
609141643 | 1700086794
609377395 | 1705384087
609208558 | 1702315855
596681015 | 1697135301
596671974 | 1702254854
596534311 | 1702810514
596730937 | 1702781037
596677124 | 1689863882
607614815 | 1703601399
596723753 | 1702099286
596507585 | 1702282766
596724979 | 1702218691
596525492 | 1701629464
609430095 | 1706719698
596648461 | 1706850536
598631380 | 1704611723
609155585 | 1700505789
607663242 | 1704890140
596942463 | 1705070525
596477890 | 4005759238
606848844 | 1686472321
596580579 | 1706653973
259426015 | 1716808228
596534980 | 1703264523
596434732 | 1704321551
596427948 | 1697469440
596549844 | 1703933424
596451109 | 1703799810
596533671 | 1702538490
596731266 | 1702555946
596700996 | 1698561072
607023819 | 1706213563
288308768 | 4005885770
596497416 | 1702283508
596643924 | 1706054601
596725279 | 1702102531
596571850 | 4005764834
598474468 | 1704324948
608905154 | 1695851661
596508046 | 4005343991
596743543 | 1705233446
596577926 | 1706228625
252112766 | 1716903252
596643444 | 1705395837
596813058 | 4005234280
596627763 | 1705288879
598071116 | 1699598126
598222057 | 1702884562
596682774 | 1704022467
596735368 | 1703214074
596617331 | 1701449652
609165493 | 1701637359
607805017 | 1705751160
Spreadsheet: 010e3a86-af13-4057-9314-b07990d32b2b
Sheet: Sheet1

Unnamed: 0 | Unnamed: 1 | Unnamed: 2 | Unnamed: 3 | Unnamed: 4 | Unnamed: 5 | Unnamed: 6 | Unnamed: 7 | Unnamed: 8 | Unnamed: 9 | Unnamed: 10 | Unnamed: 11 | Unnamed: 12 | Unnamed: 13 | Unnamed: 14
Cuadro 3.23-10-9
[NAME]
[NAME] ingresos y egresos [NAME] región Sureste por sub-región y provincia, según año, 1998-2007
(Valor en RD$)
[NAME] | total del Saldo Región Sur Este | Saldo según provincia Sub Región de Valdesia | Saldo según provincia Distrito Nacional | Saldo según provincia Santo [NAME] | Saldo según provincia [NAME] | Saldo según provincia Peravia | Saldo según [NAME] | Saldo según provincia [NAME] | Saldo según provincia Sub Región del Yuma | Saldo según [NAME] | Saldo según [NAME] | Saldo según [NAME] | Saldo según provincia [NAME] | Saldo según provincia Hato Mayor
1998 | 12455228 | 2077755 | … | … | … | 592643 | 1485549 | -437 | 10377473 | -170110 | 1752199 | 3433095 | 7364393 | -2002104
1999 | -690805 | -896624 | 3852003 | … | … | -760404 | -2788109 | -1200114 | 205819 | 837492 | -1129652 | 1354586 | -390532 | -466075
2000 | -27051436 | -23208810 | … | … | … | 4232273 | -28709688 | 1268605 | -3842626 | -1545719 | -302736 | -4718141 | -235033 | 2959003
2001 | 120625816 | 78893542 | … | … | 1448645 | 5540157 | 69957417 | 1947323 | 41732274 | 8144480 | -652363 | 16927132 | 16010273 | 1302752
2002 | 14197994 | 11530165 | … | … | … | 3454002 | -90086 | 8166249 | 2667829 | 3788238 | 0 | -3935253 | 2856209 | -41365
2003 | -3526666 | 1081948 | … | … | … | 3246622 | -291902 | -1872772 | -4608614 | … | … | -9841979 | 5233365 | …
2004 | -8773129 | -8086974 | … | 2120939 | 1576885 | -462611 | -10348534 | -973653 | -686155 | -6491681 | 7406655 | -2494764 | 568353 | 325282
2005 | 23958369 | -35270247 | … | 7548942 | -554236 | -16889155 | -14735468 | -10640330 | 59228616 | -628462 | 32830178 | 6350307 | 20250363 | 426230
2006 | 135644003.24 | 118023721.03 | 43947609.98 | 7956678 | -761596.09 | 4059786.82 | 55072325 | 7748917.32 | 17620282.21 | -5048241.95 | -3417244.43 | -3198528 | 15476796.59 | 13807500
2007P | 54228810526.55 | 39433256842.48 | -68516445.64999962 | 20583074518 | 3292856613.44 | 5891040394.790001 | 413066806.9 | 9321734955 | 14795553684.07 | -8366927.209999993 | 717522455.95 | 1518166929 | 9410846562.330002 | 3157384664
(P): [NAME] preliminares
Fuentes: [NAME] y la Liga Municipal Dominicana
Spreadsheet: 145904d1331809632-conditional-formatting-based-on-a-row-number-row-number-based-cf
Sheet: Sheet1

Client Name 1
Client Name 2
Client Name 3
Client Name 4
Client Name 5
Client Name 6 |  | total
Client Name 7
Client Name 8 |  | 20%
Client Name 9
Client Name 10
Client Name 11
Client Name 12
Client Name 13
Client Name 14
Client Name 15
Client Name 16
Client Name 17
Client Name 18
Client Name 19
Client Name 20
Client Name 21
Client Name 22
Client Name 23
Client Name 24
Spreadsheet: 144339d1330939222-using-multiple-if-and-vlookup-functions-sample-excel-problem
Sheet: Patient Input

 | Name | Fruit | Vegetable | Do you Drink? | Do you Smoke? | Do you Exercise? | How Healthy you are
 | [NAME] |  |  |  |  |  |  | <-- Need a formula here which can calculate the health status based on the entries from Column C to G and referring to Tab "Health Status - Fixed" for giving the status
 | [NAME]
 | [NAME]
 |  | Fruit | Vegetable | Do you Drink? | Do you Smoke? | Do you Exercise?
 |  | Apple | Potato | Yes | Yes | Yes
 |  | Mango | Tomato | No | No | No
Spreadsheet: 789643d1659266700-adding-black-space-in-a-cell-before-text-or-data-blankspaces-aligw
Sheet: Sheet1

Blank cells before text | 2 | 3 | 4 | 5 | 6 | 2 | 3 | 4
Data/TEXT | 02052022 | CO20 | HKD | USD | 3000 | 22052022 | JournalEntry | YES
Expected Results | '02052022 | CO20 | HKD | USD | 3000 | 22052022 | JournalEntry | YES
[NAME] row 3
[NAME] row 5
Diff
[NAME] 1
AliGW's solution:
Spreadsheet: 723025d1615481742-index-match-vs-vlookup-or-is-there-a-better-way-sample_pr
Sheet: ALCO-G001^

Job Number: | ALCO-G001^ |  |  | Certified? |  |  |  | Prevailing Wage?
Job Description:
Customer: |  |  |  | OCIP? |  |  |  | Base Rate:
 |  |  |  |  |  |  |  | Fringe:
Portal: |  |  |  |  |  |  |  | Total Rate:
Notes/Instructions:
Employee First Name | Employee Last Name | Employee Number | Date | Job Number | Job Description | City | State | Earning Code | Hours Amount | Note
Spreadsheet: 36076d1233839511-match-function-doesnt-find-values-match
Sheet: Sheet1

Length | 2
x | Mp1 | Value | RowNo.
0 | 0
0.05 | 0.1434375
0.1 | 0.286875
0.15 | 0.4303125
0.2 | 0.57375
0.25 | 0.6921875
0.3 | 0.810625
0.35 | 0.9290625
0.4 | 1.0475
0.45 | 1.1409375
0.5 | 1.234375
0.55 | 1.3278125
0.6 | 1.42125
0.65 | 1.4896875
0.7 | 1.558125
0.75 | 1.6265625
0.8 | 1.695
0.85 | 1.7384375
0.9 | 1.781875
0.95 | 1.8253125
1 | 1.86875
1.05 | 0 | 0.95 | 22
1.1 | 0 | 0.8999999999999999 | #N/A
1.15 | 0 | 0.8500000000000001 | #N/A
1.2 | 0 | 0.8 | 19
1.25 | 0 | 0.75 | 18
1.3 | 0 | 0.7 | 17
1.35 | 0 | 0.6499999999999999 | #N/A
1.4 | 0 | 0.6000000000000001 | #N/A
1.45 | 0 | 0.55 | 14
1.5 | 0 | 0.5 | 13
1.55 | 0 | 0.45 | #N/A
1.6 | 0 | 0.3999999999999999 | #N/A
1.65 | 0 | 0.3500000000000001 | #N/A
1.7 | 0 | 0.3 | #N/A
1.75 | 0 | 0.25 | 8
1.8 | 0 | 0.2 | #N/A
1.85 | 0 | 0.1499999999999999 | #N/A
1.9 | 0 | 0.1000000000000001 | #N/A
1.95 | 0 | 0.05000000000000004 | #N/A
2 | 0 | 0 | 3
2.05 | 0
2.1 | 0
2.15 | 0
2.2 | 0
2.25 | 0
2.3 | 0
2.35 | 0
2.4 | 0
2.45 | 0
2.5 | 0
2.55 | 0
2.6 | 0
2.65 | 0
2.7 | 0
2.75 | 0
2.8 | 0
2.85 | 0
2.9 | 0
2.95 | 0
3 | 0
Spreadsheet: ec29677c-f717-4bfc-8eb7-7718022ecaf1
Sheet: Sheet1

LABEL | UPC | ARTIST | TITLE | RELEASEDATE | PRODUCTTYPE | GENRE | PRICE | [NAME] | STATUS
Metro One | 74948819123 | Travail | Beautiful Loneliness | 2000-09-19 | Compact Disc | Rock | 13.99 | N | To Be Retired
Spreadsheet: 214202d1360844050-calculation-for-angular-distances-angular
Sheet: Sheet1

EXAMPLE
Object | Ang.dis |  |  |  |  |  | To find the Angular Distance between group of objects keeping one object as centric
 |  |  |  |  |  |  | (keeping  the range of centric object as [NAME] or -5)
A | 165
 |  |  |  |  |  |  | Example:
B | 185 |  |  |  |  |  | Keeping object A as  centric.., If any object falls in the range of object A i.e +5 or -5 the answer should be as shown in the example
C | 161
D | 172 |  |  |  |  |  | NOTE :
E | 170 |  |  |  |  | 1 | Pls note that object A is always centric &  the values will be changing
F | 192 |  |  |  |  | 2 | Only With respect to Object A we are refering other objects…
G | 200 |  |  |  |  | 3 | Other objects value will also be changing regualrly
I | 164
J | 190
ANS
A-C | -4
A-E | 5
A-I | -1
Spreadsheet: 02349497-baa6-433c-94c4-4b248cc03eee
Sheet: Sheet1

Unnamed: 0 | Unnamed: 1 | Unnamed: 2 | Unnamed: 3 | Unnamed: 4 | Unnamed: 5 | Unnamed: 6 | Unnamed: 7 | Unnamed: 8 | Unnamed: 9 | Unnamed: 10 | Unnamed: 11
 | Time Series Workbook
 | 6427.0 Producer Price Indexes, Australia
 | Table 24. Output of the Professional, scientific and technical services industries, group and class index numbers
Related Information: | Summary Publication | Explanatory Notes | Inquiries
Data Item Description |  |  | Series Type | Series ID | Series Start | Series End | No. Obs. | Unit | Data Type | [NAME]. | Collection Month
Index Numbers ;  691 Scientific research services ; |  |  | Original | A2314187F | 1998-09-01 00:00:00 | 2012-09-01 00:00:00 | 57 | Index Numbers | INDEX | Quarter | 3
Index Numbers ;  692 Architectural, engineering and technical services ; |  |  | Original | A3343916F | 2001-09-01 00:00:00 | 2012-09-01 00:00:00 | 45 | Index Numbers | INDEX | Quarter | 3
Index Numbers ;  6921  Architectural services ; |  |  | Original | A2314196J | 1998-09-01 00:00:00 | 2012-09-01 00:00:00 | 57 | Index Numbers | INDEX | Quarter | 3
Index Numbers ;  6922 Surveying and mapping services ; |  |  | Original | A2314199R | 1997-12-01 00:00:00 | 2012-09-01 00:00:00 | 60 | Index Numbers | INDEX | Quarter | 3
Index Numbers ;  6923 Engineering design and engineering consulting services ; |  |  | Original | [NAME]T | 1998-09-01 00:00:00 | 2012-09-01 00:00:00 | 57 | Index Numbers | INDEX | Quarter | 3
Index Numbers ;  6924 Other specialised design services ; |  |  | Original | A2314235L | 1998-03-01 00:00:00 | 2012-09-01 00:00:00 | 59 | Index Numbers | INDEX | Quarter | 3
Index Numbers ;  693 Legal and accounting services ; |  |  | Original | A2314220W | 1998-09-01 00:00:00 | 2012-09-01 00:00:00 | 57 | Index Numbers | INDEX | Quarter | 3
Index Numbers ;  6931 Legal services ; |  |  | Original | A2314223C | 1998-09-01 00:00:00 | 2012-09-01 00:00:00 | 57 | Index Numbers | INDEX | Quarter | 3
Index Numbers ;  6932  Accounting services ; |  |  | Original | A2314226K | 1998-09-01 00:00:00 | 2012-09-01 00:00:00 | 57 | Index Numbers | INDEX | Quarter | 3
Index Numbers ;  695 Market research and statistical services ; |  |  | Original | A3343918K | 2001-09-01 00:00:00 | 2012-09-01 00:00:00 | 45 | Index Numbers | INDEX | Quarter | 3
Index Numbers ;  6962 Management advice and related consulting services ; |  |  | Original | A3343920W | 2001-09-01 00:00:00 | 2012-09-01 00:00:00 | 45 | Index Numbers | INDEX | Quarter | 3
Index Numbers ;  697 Veterinary services ; |  |  | Original | A4406512L | 2001-09-01 00:00:00 | 2012-09-01 00:00:00 | 45 | Index Numbers | INDEX | Quarter | 3
Index Numbers ;  700 Computer system design and related services ; |  |  | Original | A3343922A | 2001-09-01 00:00:00 | 2012-09-01 00:00:00 | 45 | Index Numbers | INDEX | Quarter | 3
© Commonwealth of Australia  2012
Spreadsheet: 729659d1619238882-search-and-match-value-cross-multiple-sheets-and-return-values-sample
Sheet: Orders

Date Created | Order Number | Description | Client | Notes | Score | Comment
2021-04-15 00:00:00 | 1-2342241 | Blue L | [NAME]
2021-04-15 00:00:00 | 1-5555234 | Blue M | Christie
2021-04-15 00:00:00 | 1-4234555 | Black S | [NAME]
2021-04-16 00:00:00 | 1-3453453 | Black S | [NAME]
2021-04-16 00:00:00 | 1-8886785 | Pink S | Jacinta
2021-04-17 00:00:00 | 1-4333545 | Pink S | Briana
Spreadsheet: 389851d1429300606-count-issue-shifts18-4
Sheet: Pivot table

# of Jobs
Part Number | End date | Total
161 | 2014-10-19 00:00:00 | 1 |  |  | 161 | 2014-10-19 00:00:00 | 1
167 | 2014-06-22 00:00:00 | 1 |  |  | 167 | 2014-06-22 00:00:00 | 1
 | 2014-07-06 00:00:00 | 1 |  |  | 167 | 2014-07-06 00:00:00 | 1
 | 2014-07-13 00:00:00 | 2 | 153 |  | 167 | 2014-07-13 00:00:00 | 2
208 | 2014-07-27 00:00:00 | 3 |  |  | 208 | 2014-07-27 00:00:00 | 2
Grand Total |  | 8
Spreadsheet: 01143036-aedf-4572-9a4b-7a0742b020e6
Sheet: Sheet1

Unnamed: 0 | Unnamed: 1 | Unnamed: 2 | Unnamed: 3 | Unnamed: 4 | Unnamed: 5 | Unnamed: 6 | Unnamed: 7 | Unnamed: 8 | Unnamed: 9 | Unnamed: 10 | Unnamed: 11
 | Time Series Workbook
 | 5671.0 Lending Finance, Australia
 | TABLE 13. LENDING FINANCE SEASONAL FACTORS, BY PURPOSE
Related Information: | Summary Publication | Explanatory Notes | Inquiries
 | Glossary
Data Item Description |  |  | Series Type | Series ID | Series Start | Series End | No. Obs. | Unit | Data Type | [NAME]. | Collection Month
Commercial finance for fixed loan facilities ; |  |  | Original | A2433160J | 1985-01-01 00:00:00 | 2012-02-01 00:00:00 | 326 | Number | FACTOR | Month | 1
Commercial finance for revolving credit facilities ; |  |  | Original | A2433161K | 1985-01-01 00:00:00 | 2012-02-01 00:00:00 | 326 | Number | FACTOR | Month | 1
Total lease finance commitments ; |  |  | Original | A2433163R | 1985-01-01 00:00:00 | 2012-02-01 00:00:00 | 326 | Number | FACTOR | Month | 1
Personal finance for fixed loan facilities ; |  |  | Original | A2433157V | 1985-01-01 00:00:00 | 2012-02-01 00:00:00 | 326 | Number | FACTOR | Month | 1
Personal finance for revolving credit facilities ; |  |  | Original | A2433158W | 1985-01-01 00:00:00 | 2012-02-01 00:00:00 | 326 | Number | FACTOR | Month | 1
Investment housing, Construction of dwellings for rent and resale ; |  |  | Original | A2434908R | 1985-01-01 00:00:00 | 2012-02-01 00:00:00 | 326 | Number | FACTOR | Month | 1
Investment housing, Purchase for rent/resale by individuals ; |  |  | Original | A2434909T | 1985-01-01 00:00:00 | 2012-02-01 00:00:00 | 326 | Number | FACTOR | Month | 1
Investment housing, Purchase for rent/resale by others ; |  |  | Original | A2434910A | 1985-01-01 00:00:00 | 2012-02-01 00:00:00 | 326 | Number | FACTOR | Month | 1
© Commonwealth of Australia  2011
Spreadsheet: darrell_schoolcraft__7807__imbalsumm0108
Sheet: DEFS

 | 23995 |  | 22051
 | 59687 |  | 10703
Day | Measured | Scheduled | Measured | Scheduled | Totals
1 |  |  | 17879 | 24612
2 |  |  | 15280 | 24612
3 |  |  | 22363 | 24612
4 |  |  | 22522 | 24612
5 |  |  | 25194 | 24612
6 |  |  | 25342 | 24612
7 |  |  | 26046 | 24612
8 | 11 |  | 24733 | 24612
9 | 22 |  | 26013 | 24612
10 | 1 |  | 25516 | 24612
11 |  |  | 25869 | 24612
12 |  |  | 25308 | 24612
13 |  |  | 25349 | 24612
14 |  |  | 26042 | 24612
15 |  |  | 25954 | 24612
16 |  |  | 26036 | 24612
17 |  |  | 13182 | 24612
18 |  |  | 21303 | 24612
19 |  |  | 20687 | 24612
20 |  |  | 15373 | 24612
21
22
23
24
25
26
27
28
29
30 |  |  |  |  |  |  | CBS Volume | 23995 | 22051
31 |  |  |  |  |  |  |  | -178485 | -80532
 |  |  |  |  |  |  |  |  | 22864 | -24566
2001-07-31 00:00:00 | Balance | -1023166 |  | -496043.34 |  |  |  |  | 20379 | 2979
2001-08-20 00:00:00 | Balance |  |  |  |  |  |  |  | 21459 | 6776
 |  |  |  |  |  |  |  |  | 26357 | 26521
 |  |  |  |  |  |  |  |  | 21544 | 36108
 |  |  |  | Contract # |  |  |  |  | 24532 | 17769
 |  |  |  | 22864 | -58339.66 | Zia
 |  |  |  | 20379 | -51695.87 | Grayco/Artesia
 |  |  |  | 21459 | 10570.56
 |  |  |  | 26357 | 44144.84 | [NAME]
 |  |  |  | 21544 | 61340.16 | [NAME], [NAME]
 |  |  |  | 24532 | -762222.24 | 500211,500212,500219,500230 - Coburn points
 |  |  |  | Duke
Spreadsheet: 143241d1330321321-problems-with-pivot-table-sales-summary-test-1-vlad-
Sheet: Pivot

Channel | Brands
 | Values
Row Labels | Units Sold | $ Sales | $ GM | % GMN | Margin
Medium screw | 360 | 402.45 | 284.85 | 0.7077897875512486
Product B | 360 | 402.45 | 284.85 | 0.7077897875512486
Small screw | 46 | 31.35 | 15.8 | 0.5039872408293461
Product A | 1 | 1.2 | 0.95 | 0.7916666666666666
Product B | 45 | 30.15 | 14.85 | 0.4925373134328359
Grand Total | 406 | 433.8000000000001 | 300.65 | 0.6930613185799908
Spreadsheet: 147454d1332800082-decimal-correspond-to-full-number-book2
Sheet: Sheet1

Starting Inventory
Cartons | Pieces
50 | 0
Log |  |  |  | Balance
Date | Action | Cartons | Pieces | Cartons | Pieces
2012-01-01 00:00:00 | Sold | 2 | 0
2012-01-01 00:00:00 | Opened | 1 | 0
2012-01-01 00:00:00 | Gave Out | 0 | 10
2012-01-02 00:00:00 | Sold | 2 | 0
2012-01-02 00:00:00 | Gave Out | 0 | 10
2012-01-02 00:00:00 | Sold | 2 | 0
2012-01-02 00:00:00 | Gave Out | 0 | 10
2012-01-03 00:00:00 | Sold | 2 | 0
2012-01-03 00:00:00 | Opened | 1 | 0
2012-01-03 00:00:00 | Gave Out | 0 | 10
Spreadsheet: 745386d1629895732-sum-if-vlookup-matches-criteria-copy-of-raw-data-v2
Sheet: Lists

 |  | Fuel Category |  | Vehicles Type |  | DRIVERS |  | PUMP STATION
 |  | DIESEL MILOTO |  | VOLVO |  | [NAME] |  | STATION 1
 |  | DIESEL HEAVY MACHINERY |  | FREIGHTLINER |  | [NAME] |  | STATION 2
 |  | DIESEL OTHER VEHICLES |  | IVECO |  | [NAME] |  | STATION 3
 |  | DIESEL BUSES |  | BENZ |  | [NAME]
 |  |  |  | ASTRA |  | [NAME]
 |  |  |  | HEAVY MACHINERY |  | [NAME]
 |  |  |  | OTHER VEHICLES |  | Borniface Tembo
 |  |  |  | BUSES |  | [NAME]
 |  |  |  |  |  | Bright Mazila
 |  |  |  |  |  | [NAME]
 |  |  |  |  |  | [NAME]
 |  |  |  |  |  | [NAME]
 |  |  |  |  |  | [NAME]
 |  |  |  |  |  | [NAME]
 |  |  |  |  |  | Davy Chimbula
 |  |  |  |  |  | [NAME]
 |  |  |  |  |  | [NAME]
 |  |  |  |  |  | [NAME]
 |  |  |  |  |  | [NAME]
 |  |  |  |  |  | [NAME]
 |  |  |  |  |  | [NAME]
 |  |  |  |  |  | [NAME]
 |  |  |  |  |  | [NAME]
 |  |  |  |  |  | [NAME]
 |  |  |  |  |  | [NAME]
 |  |  |  |  |  | [NAME]
 |  |  |  |  |  | [NAME]
 |  |  |  |  |  | [NAME]
 |  |  |  |  |  | [NAME]
 |  |  |  |  |  | Given Mweemba
 |  |  |  |  |  | [NAME]
 |  |  |  |  |  | [NAME]
 |  |  |  |  |  | [NAME]
 |  |  |  |  |  | [NAME]
 |  |  |  |  |  | [NAME]
 |  |  |  |  |  | [NAME]
 |  |  |  |  |  | [NAME]
 |  |  |  |  |  | [NAME]
 |  |  |  |  |  | [NAME]
 |  |  |  |  |  | [NAME]
 |  |  |  |  |  | Mabvuto Musukwa
 |  |  |  |  |  | [NAME]
 |  |  |  |  |  | [NAME]
 |  |  |  |  |  | [NAME]
 |  |  |  |  |  | [NAME]
 |  |  |  |  |  | [NAME]
 |  |  |  |  |  | [NAME]
 |  |  |  |  |  | Moses Miyasu
 |  |  |  |  |  | Mukonde Sondashi
 |  |  |  |  |  | [NAME]
 |  |  |  |  |  | [NAME]
 |  |  |  |  |  | [NAME]
 |  |  |  |  |  | [NAME]
 |  |  |  |  |  | [NAME]
 |  |  |  |  |  | [NAME]
 |  |  |  |  |  | [NAME]
 |  |  |  |  |  | [NAME]
 |  |  |  |  |  | [NAME]
 |  |  |  |  |  | [NAME]
 |  |  |  |  |  | [NAME]
 |  |  |  |  |  | [NAME]
 |  |  |  |  |  | [NAME]
 |  |  |  |  |  | [NAME]
 |  |  |  |  |  | Recent Mweemba
 |  |  |  |  |  | [NAME]
 |  |  |  |  |  | [NAME]
 |  |  |  |  |  | [NAME]
 |  |  |  |  |  | [NAME]
 |  |  |  |  |  | [NAME]
 |  |  |  |  |  | [NAME]
 |  |  |  |  |  | [NAME]
 |  |  |  |  |  | [NAME]
 |  |  |  |  |  | [NAME]
 |  |  |  |  |  | [NAME]
 |  |  |  |  |  | [NAME]
 |  |  |  |  |  | [NAME]
 |  |  |  |  |  | [NAME]
 |  |  |  |  |  | Sunday Mumba
 |  |  |  |  |  | [NAME]
 |  |  |  |  |  | [NAME]
 |  |  |  |  |  | [NAME]
 |  |  |  |  |  | [NAME]
 |  |  |  |  |  | [NAME]
 |  |  |  |  |  | [NAME]
 |  |  |  |  |  | [NAME]
 |  |  |  |  |  | [NAME]
 |  |  |  |  |  | [NAME]
 |  |  |  |  |  | [NAME]
 |  |  |  |  |  | [NAME]
Spreadsheet: 75405d1275994089-sumif-or-it-might-be-something-else-copy-of-sumif
Sheet: Sheet1

Cleint No. | due amount
43051 | 0.067
43051 | 20 |  |  |  |  |  |  |  | Row Labels | Sum of due amount
43186 | 10 |  |  |  |  |  |  |  | 43051 | 20.067
46347 | 10 |  |  |  |  |  |  |  | 43186 | 10
48053 | 40 |  |  |  |  |  |  |  | 46347 | 10
90002988 | 164.81 |  |  |  |  |  |  |  | 48053 | 40
94000068 | 61.761 |  |  |  |  |  |  |  | 90002988 | 164.81
94000068 | 29.5 |  |  |  |  |  |  |  | 94000068 | 162.471
94000068 | 29.5 |  |  |  |  |  |  |  | 94000079 | 255.509
94000068 | 40.71 |  |  |  |  |  |  |  | 94000106 | 298.038
94000068 | 1 |  |  |  |  |  |  |  | 94000162 | 138.392
94000079 | 65.709 |  |  |  |  |  |  |  | 94000174 | 216.3
94000079 | 63 |  |  |  |  |  |  |  | 94000315 | 30.861
94000079 | 63 |  |  |  |  |  |  |  | 94000362 | 176.695
94000079 | 63.8 |  |  |  |  |  |  |  | 94000546 | 175.689
94000106 | 63.961 |  |  |  |  |  |  |  | 94000558 | 195.136
94000106 | 60.077 |  |  |  |  |  |  |  | 94000592 | 20.368
94000106 | 75 |  |  |  |  |  |  |  | 94000684 | 13.25
94000106 | 49.5 |  |  |  |  |  |  |  | 94000685 | 13.25
94000106 | 49.5 |  |  |  |  |  |  |  | Grand Total | 1940.836
94000162 | 0.05
94000162 | 26.769
94000162 | 16.073
94000162 | 65
94000162 | 15.25
94000162 | 15.25
94000174 | 15.25
94000174 | 15.25
94000174 | 75
94000174 | 15.25
94000174 | 65
94000174 | 30.55
94000315 | 2.5
94000315 | 2.277
94000315 | 14.121
94000315 | 9.463
94000315 | 2.5
94000362 | 63.21
94000362 | 104.485
94000362 | 9
94000546 | 10.5
94000546 | 102.886
94000546 | 21.768
94000546 | 40.535
94000558 | 28.63
94000558 | 14.5
94000558 | 14.5
94000558 | 37.506
94000558 | 100
94000592 | 3
94000592 | 3
94000592 | 8.368
94000592 | 3
94000592 | 3
94000684 | 3.25
94000684 | 2.5
94000684 | 2.5
94000684 | 2.5
94000684 | 2.5
94000685 | 2.5
94000685 | 2.5
94000685 | 2.5
94000685 | 3.25
94000685 | 2.5
Spreadsheet: 101684d1299765494-complex-lookup-budget
Sheet: $

 |  |  |  | A555 | FFS | A566 | Total | A555 | FFS | A566 | Total
 | Titles | G/L Acct | F / P / C / O | HGH | HGH | HGH [NAME] | HGH | MSR | MSR | MSR [NAME] | MSR
 |  |  |  | Medium | Medium | Medium |  | Medium | Medium | Medium
1 | Executive Director | 410A | F
2 | Director, Finance & Administration | 410A | F
3 | Manager - Fee for Service | 410A | F
4 | Manager  - Justice | 410A | F
5 | Manager  - Mental Health | 410A | F
6 | Manager  - Respite | 410A | F
Spreadsheet: 110303d1307017427-finding-if-price-data-between-cells-satisfies-conditions-copy-of-copy-of-findvalue-1
Sheet: Sheet1

 | Price |  | Action | Test Y to 1st x back | Test Y to 2nd x back | Test Y to 3rd x back | etc
2009-04-10 00:00:00 | 94.45 | x
2009-04-17 00:00:00 | 121 | x
2009-04-24 00:00:00 | 93.3
2009-05-01 00:00:00 | 93.5 | x | Y
2009-05-08 00:00:00 | 93.2
2009-05-15 00:00:00 | 94.65
2009-05-22 00:00:00 | 100.5 | x | Y |  |  |  | Indicates if cell(d8)= Y then find if price at previous x is > than all prices from x+1 to subsequent Y
2009-05-29 00:00:00 | 103.7
2009-06-05 00:00:00 | 102.1
2009-06-12 00:00:00 | 100 | x
2009-06-19 00:00:00 | 99.9
2009-06-26 00:00:00 | 103.3
2009-07-03 00:00:00 | 94.65 |  | Y |  |  |  | Indicates if cell(d14)= Y then find if price at previous x is > than all prices from x+1 to subsequent Y
2009-07-10 00:00:00 | 93.5
2009-07-17 00:00:00 | 103.7
 |  | Test is to see if in column D = 'Y' then test to find if price at previous x is > or < than all prices from x+1 to subsequent Y