tianzl66/Sheetpedia huggingface dataset:
Spreadsheet: 777044d1650100696-returning-the-most-recent-year-billed-for-each-client-test-dashboard-6
Sheet: CLIENTS

CID | DENOMINATION | PHONE | VAT | FIRST NAME | LAST NAME | ADDRESS | POST | CITY | COUNTRY | [NAME] | WEBSITE | ACTIVITY | LAST BILLED
10
9 | [NAME] |  |  |  |  |  |  |  |  |  |  | Active
8 | Drinkland |  |  |  |  |  |  |  |  |  |  | Active
7 | Air & Chaleur |  |  |  |  |  |  |  |  |  |  | Inactive
6 | [NAME] |  |  |  |  |  |  |  |  |  |  | Active
5 | A.A. [NAME] |  |  |  |  |  |  |  |  |  |  | Active
4 | [NAME] |  |  |  |  |  |  |  |  |  |  | Active
3 | J-R Bat |  |  |  |  |  |  |  |  |  |  | Active
2 | Gremibel |  |  |  |  |  |  |  |  |  |  | Active
1 | DRL Express |  |  |  |  |  |  |  |  |  |  | Active
Spreadsheet: 74534d1275024217-excel-2007-converting-to-million-and-billion-million-conversion
Sheet: Sheet1

Sum in Rs | Sum in Million
0 | 0
0 | 0
500000 | 500000
0 | 0
0 | 0
63107 | 63107
93590.53 | 93590.53
1911556 | 1911556
183522 | 183522
55562 | 55562
33090 | 33090
443574 | 443574
0 | 0
0 | 0
0 | 0
0 | 0
0 | 0
0 | 0
0 | 0
654691 | 654691
0 | 0
1000 | 1000
83503.31 | 83503.31
0 | 0
198409.77 | 198409.77
30149 | 30149
220913.98 | 220913.98
0 | 0
0 | 0
0 | 0
0 | 0
0 | 0
1000 | 1000
8750 | 8750
0 | 0
Spreadsheet: 777863d1650643278-retrieving-average-data-cells-from-sheets-using-lists-test-data
Sheet: Class 6

Name | Age Difference Subject 1 | Age Difference Subject 2 | Age Difference Subject 3 | Age Difference Subject 4 | [NAME]
Name 1 | 2.09 | 2.14 | 0.89 | 2.45 | 123.09
Name 2 | 2.74 | 2.02 | 2.7 | 2.04 | 114.83
Name 3 | 2.23 | -0.02 | 2.31 | 3.55 | 134.08
Name 4 | 2.12 | 2.03 | 2.16 | 3 | 106.3
Name 5 | 1.96 | 0.72 | 2.13 | 2.83 | 134.48
Name 6 | 2.27 | 0.99 | 2.8 | 3.12 | 126.78
Name 7 | 1.92 | 1.02 | 1.69 | 2.54 | 124.82
Name 8 | 2.42 | 1.21 | 2.06 | 1.93 | 126.41
Name 9 | 2.99 | 1.91 | 3.17 | 2.5 | 145
Name 10 | 3.38 | 2.37 | 4.91 | 3.04 | 114.42
 |  |  |  |  |  | Average
Percentage with an Age Difference of > 3 Years
Percentage with an Age Difference of < 0 Years
Spreadsheet: 550211d1512152474-getting-data-from-different-colums-book1
Sheet: MASTER

Montly summary
 |  |  | Produce |  |  |  | Chill
 |  |  | Under 90% | 90 to 100% | 100 to 120% | Over 120% | Under 90% | 90 to 100% | 100 to 120% | Over 120%
Wednesday | 2017-11-01 00:00:00
Thursday | 2017-11-02 00:00:00
Friday | 2017-11-03 00:00:00
Sunday | 2017-11-05 00:00:00
Monday | 2017-11-06 00:00:00
Tuesday | 2017-11-07 00:00:00
Wednesday
Thursday
Friday
Sunday
Monday
Tuesday
Wednesday
Thursday
Friday
Sunday
Monday
Tuesday
Wednesday
Thursday
Friday
Sunday
Monday
Tuesday
Wednesday
Thursday
Spreadsheet: 701728d1603897650-auto-filling-cells-from-table-to-table-book1example
Sheet: Sheet2

 | Column1 | Column2 | Column3 | Column4 | Column5
 | a | 2.1 | 3.1 | 4.1 | 5.1
 | b | 2.2 | 3.2 | 4.2 | 5.2
 | c | 2.3 | 3.3 | 4.3 | 5.3
 | d | 2.4 | 3.4 | 4.4 | 5.4
Spreadsheet: 119833d1314783669-making-excell-count-in-4s-book1
Sheet: FT1 REG

 | aeroplane flying
 | REGISTER 2011 - 12
 | Programme:
 | Tutor:
 | Day
 | Time
 |  |  | Date
 | Name | Student Number
 | C B | 457689
 | C B | 846592
 | D D | 543298
 | K G | 546895
 | C G | 546892
 | T H | 213465
 | E H | 798653
 | J M | 124578
 | j P | 983452
 | J P | 645832
 | B R | 482349
 | J S | 31249
 | C S | 781202
 |  | 0
 | C B
 | D D
 | C G
 | E H
 | j P
 | B R
Spreadsheet: 855648d1705152333-dynamic-hourly-employee-headcount-including-overnight-staff-dynamic-hourly-employee-headcount-including-overnight-staff-2-
Sheet: Sheet1

 |  |  |  |  |  |  |  | Day of Week |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | Monday
 | Day of Week | Role | Name | Start | End |  |  | Monday |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | Tuesday
 | Monday | RN | Julie | 01:00:00 | 19:00:00 |  |  | Supervisor |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | Wednesday
 | Monday | RN | Mark | 07:00:00 | 18:00:00 |  |  | Charge |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | Thursday
 | Monday | RN | Q | 07:30:00 | 18:30:00 |  |  | RN |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | Friday
 | Monday | Tech | W | 08:00:00 | 05:00:00 |  |  | Tech |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | Saturday
 | Monday | Tech | E |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | Sunday
 | Monday | Tech | R
 | Monday | Charge | T
 | Monday | Supervisor | Y
 | Tuesday | RN | U | 19:00:00 | 04:00:00
 | Tuesday | RN | I | 19:00:00 | 07:00:00
 | Tuesday | RN | O
 | Tuesday | RN | P
 | Tuesday | Tech | A
 | Tuesday | Tech | S
 | Tuesday | Tech | D
 | Tuesday | Charge | F
Spreadsheet: 813316d1673659947-nested-if-formula-for-trailing-values-learn-trailing
Sheet: Sheet1

Range of Values | Expected Result |  |  | [NAME]
500 | 0
1000 | 500
1500 | 500
2000 | 1000
2500 | 1000
3000 | 1500
3500 | 1500
4000 | 2000
4500 | 2000
5000 | 2500
5500 | 2500
6000 | 3000
6500 | 3000
7000 | 3500
7500 | 3500
8000 | 4000
8500 | 4000
9000 | 4500
9500 | 4500
10000 | 5000
Spreadsheet: 782415d1654025056-sum-based-on-multiple-non-contiguous-range-with-filter-dynamic-array-helper-sumifs-dynamic-array-date-range
Sheet: Sheet1

Codes | PRO2S |  | PRO3S
 |  | PRO3T
 |  |  |  | PRO4S
 | PRO4T
 |  |  |  |  |  | Return of Dynamic Array
Report Date | 2022-03-31 00:00:00
 |  | 2022-05-31 00:00:00 | 2022-06-30 00:00:00 | 2022-07-31 00:00:00 | 2022-08-31 00:00:00 | 2022-09-30 00:00:00 | 2022-10-31 00:00:00 | 2022-11-30 00:00:00 | 2022-12-31 00:00:00 | 2023-01-31 00:00:00 | 2023-02-28 00:00:00 | 2023-03-31 00:00:00 | 2023-04-30 00:00:00 | 2023-05-31 00:00:00 | 2023-06-30 00:00:00 | 2023-07-31 00:00:00 | 2023-08-31 00:00:00 | 2023-09-30 00:00:00 | 2023-10-31 00:00:00 | 2023-11-30 00:00:00 | 2023-12-31 00:00:00 | 2024-01-31 00:00:00 | 2024-02-29 00:00:00 | 2024-03-31 00:00:00 | 2024-04-30 00:00:00 | 2024-05-31 00:00:00 | 2024-06-30 00:00:00 | 2024-07-31 00:00:00 | 2024-08-31 00:00:00 | 2024-09-30 00:00:00 | 2024-10-31 00:00:00 | 2024-11-30 00:00:00 | 2024-12-31 00:00:00 | 2025-01-31 00:00:00 | 2025-02-28 00:00:00 | 2025-03-31 00:00:00 | 2025-04-30 00:00:00 | 2025-05-31 00:00:00 | 2025-06-30 00:00:00 | 2025-07-31 00:00:00 | 2025-08-31 00:00:00 | 2025-09-30 00:00:00 | 2025-10-31 00:00:00 | 2025-11-30 00:00:00 | 2025-12-31 00:00:00 | 2026-01-31 00:00:00 | 2026-02-28 00:00:00 | 2026-03-31 00:00:00 | 2026-04-30 00:00:00 | 2026-05-31 00:00:00 | 2026-06-30 00:00:00 | 2026-07-31 00:00:00 | 2026-08-31 00:00:00 | 2026-09-30 00:00:00 | 2026-10-31 00:00:00 | 2026-11-30 00:00:00 | 2026-12-31 00:00:00
Desired Return Result
 | 1786460 | 1980556 | 2122702 | … … … | … … … | … … … | … … … | … … … | … … … | … … … | … … … | … … … | … … … | … … … | … … … | … … … | … … … | … … … | … … … | … … … | … … … | … … … | … … … | … … … | … … … | … … … | … … … | … … … | … … … | … … … | … … … | … … … | … … … | … … … | … … … | … … … | … … … | … … … | … … … | … … … | … … … | … … … | … … … | … … … | … … … | … … … | … … … | … … … | … … … | … … … | … … … | … … … | … … … | … … … | … … … | … … … | … … …
Spreadsheet: 799385d1665061191-apply-conditional-formatting-to-multiple-cells-cf-range-application-aligw
Sheet: Sheet1

1 | x | y | z
2 | x | y | z
2 | x | y | z
2 | x | y | z
1 | x | y | z
1 | x | y | z
1 | x | y | z
2 | x | y | z
Spreadsheet: darrell_schoolcraft__7816__imbalsumm0109
Sheet: KN_Westar

 |  |  |  |  |  |  |  |  |  |  |  |  |  | Contract 8289 |  |  |  |  |  |  |  |  |  |  |  |  |  |  | Contract  21579
[NAME] | 12353 | WestarCarson | 500168 | Westar Ward |  | 78161
 | Measured | Scheduled | Measured | Scheduled
1 |  |  | -13751 | -30508
2 |  |  | -6539 | -32145
3 |  |  | -17873 | -31067
4 |  |  |  | -30437
5 |  |  |  | -4178
6
7
8
9
10
11
12
13
14
15
16
17
18
19
20
21
22
23
24
25
26
27
28
29
30
31
index
2001-08-31 00:00:00 |  |  |  |  | 378641
2001-09-05 00:00:00
CBS Volume
 |  |  | -3870
Spreadsheet: 1ad46b1b-6b21-4e40-9644-ebdc8f160b0c
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 33. LEASE FINANCE COMMITMENTS, By Purpose: State (QLD), Original (Number, $000)
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
1 . . . [NAME] ; |  |  | Original | A2413943F | 1985-01-01 00:00:00 | 2009-06-01 00:00:00 | 294 | $'000 | FLOW | Month | 1
1.1 . . . . . New cars and station wagons ; |  |  | Original | A2413944J | 1985-01-01 00:00:00 | 2009-06-01 00:00:00 | 294 | $'000 | FLOW | Month | 1
. . . . . . . . [New cars and station wagons (no.)] ; |  |  | Original | A2413945K | 1985-01-01 00:00:00 | 2009-06-01 00:00:00 | 294 | Number | FLOW | Month | 1
1.2 . . . . . Used cars and station wagons ; |  |  | Original | A2413946L | 1985-01-01 00:00:00 | 2009-06-01 00:00:00 | 294 | $'000 | FLOW | Month | 1
. . . . . . . . [Used cars and station wagons (no.)] ; |  |  | Original | A2413947R | 1985-01-01 00:00:00 | 2009-06-01 00:00:00 | 294 | Number | FLOW | Month | 1
1.3 . . . . . Other motor vehicles  ; |  |  | Original | A2413948T | 1985-01-01 00:00:00 | 2009-06-01 00:00:00 | 294 | $'000 | FLOW | Month | 1
1.3.1a . . . . . . - new trucks ; |  |  | Original | A2413949V | 1985-01-01 00:00:00 | 2009-06-01 00:00:00 | 294 | $'000 | FLOW | Month | 1
. . . . . . . . . . . . [new trucks (no.)] ; |  |  | Original | A2413950C | 1985-01-01 00:00:00 | 2009-06-01 00:00:00 | 294 | Number | FLOW | Month | 1
1.3.3 a. . . . . . - used trucks ; |  |  | Original | A2413951F | 1985-01-01 00:00:00 | 2009-06-01 00:00:00 | 294 | $'000 | FLOW | Month | 1
. . . . . . . . . . . . [used trucks (no.)] ; |  |  | Original | A2413952J | 1985-01-01 00:00:00 | 2009-06-01 00:00:00 | 294 | Number | FLOW | Month | 1
1.3.5 . . . . . . . - trailers, buses, coaches, other MVs ; |  |  | Original | A2413953K | 1985-01-01 00:00:00 | 2009-06-01 00:00:00 | 294 | $'000 | FLOW | Month | 1
2 . . . Other Transport Equipment ; |  |  | Original | A2413954L | 1985-01-01 00:00:00 | 2009-06-01 00:00:00 | 294 | $'000 | FLOW | Month | 1
3 . . . Agricultural, Construction & Manufacturing Equipment ; |  |  | Original | A2413955R | 1985-01-01 00:00:00 | 2009-06-01 00:00:00 | 294 | $'000 | FLOW | Month | 1
4 . . . Office Equipment ; |  |  | Original | A2413956T | 1985-01-01 00:00:00 | 2009-06-01 00:00:00 | 294 | $'000 | FLOW | Month | 1
5 . . . Other ; |  |  | Original | A2413957V | 1985-01-01 00:00:00 | 2009-06-01 00:00:00 | 294 | $'000 | FLOW | Month | 1
TOTAL LEASE FINANCE ; |  |  | Original | A2413958W | 1985-01-01 00:00:00 | 2009-06-01 00:00:00 | 294 | $'000 | FLOW | Month | 1
© Commonwealth of Australia  2009
Spreadsheet: 0308101a-9ee1-4874-b696-2b3b4193895a
Sheet: K-Day

 | K-Day 2009 |  |  | K-Day 2010 (9-10-2010) |  |  | Proposed K-Day 2011 (9-9-2011)
 | Sources of Income | Amounts |  | Sources of Income | Amounts |  | Sources of Income | Amounts
1.) | USG | 17000 | 1.) | USG | 14000 | 1.) | USG
2.) | Carryforward | 2576.79 | 2.) | Carryforward | 2868.77 | 2.) | Carryforward | 3633.79
3.) |  |  | 3.) |  |  | 3.)
4.) |  |  | 4.) |  |  | 4.)
5.) |  |  | 5.) |  |  | 5.)
6.) |  |  | 6.) |  |  | 6.)
7.) |  |  | 7.) |  |  | 7.)
8.) |  |  | 8.) |  |  | 8.)
9.) |  |  | 9.) |  |  | 9.)
10.) |  |  | 10.) |  |  | 10.)
 | Total |  |  | Total |  |  | Total
 | Costs of Events |  |  | Costs of Events |  |  | Costs of Events
1.) | Entertainment | 3975 | 1.) | Entertainment | 3975 | 1.) | Entertainment | 4500
2.) | Food | 7468.5 | 2.) | Food | 4818.2 | 2.) | Food | 6000
3.) | Equipment | 2308.03 | 3.) | Equipment | 1801 | 3.) | Equipment | 2000
4.) | General Supplies | 21 | 4.) | General Supplies | 72.64 | 4.) | General Supplies | 100
5.) | Publicity | 1111.05 | 5.) | Publicity | 868.05 | 5.) | Publicity | 900
6.) | Other | 1824.44 | 6.) | Other | 1950.09 | 6.) | Travel | 1275
7.) |  |  | 7.) |  |  | 7.) | Safety | 500
8.) |  |  | 8.) |  |  | 8.) | Other | 425
9.) |  |  | 9.) |  |  | 9.)
10.) |  |  | 10.) |  |  | 10.)
 | Total |  |  | Total |  |  | Total
 | Carryforward |  |  | Carryforward |  |  | Request 2011 | 15000
 |  |  |  |  | **Not Charged for Facilities Labor Fee or SLS (anticipated)
 | Costs 2011
1.) | Entertainment (TBA by Committee)
2.) | Food (looking into changing menu - ordered less in 2010 due to lower allocation)
3.) | Equipment (Power Generator & Tables/Chairs - Could have to figure in labor costs)
4.) | General Supplies (Tape, Cleaning Supplies & Trash Bags/Containers
5.) | Publicity (Posters, Signs and T-Shirts for Workers to Identify Staff)
6.) | Travel (Buses to transport students to and from McLain State Park)
7.) | Safety (Mercy Ambulance & PSPS)
8.) | Other (Mclain State Park Fee, Lodging of Entertainment & Inflation Costs)
Spreadsheet: 02f49286-7282-4504-8c23-c1d2d87c5e3c
Sheet: Sheet1

Unnamed: 0 | Unnamed: 1 | Unnamed: 2 | Unnamed: 3 | Unnamed: 4 | Unnamed: 5 | Unnamed: 6 | Unnamed: 7
PARTICIPATION FORM
Name of the tournament: |  | THOMAS AND UBER CUPS 2014
Contact person of the organisers |  | Name | [NAME] |  |  | [NAME]. No. | +91-11- 41450524
 |  | Fax No. | +91-11- 41450525 |  | E-mail | [EMAIL]
 |  | Address | 383-384, New Rajender Nagar, New Delhi-110060
Date upto which the information is to be sent |  |  |  |  | 7th April, 2014
Contact details of participating organisation
National Association of
Contact person |  | Name |  |  |  | [NAME]. No.
 |  | Fax No. |  |  | E-mail
 |  | Address
Particulars of Embassy at which the letter of invitation is required to be sent
Designation of the visa issuing authority
Contact person |  | Name |  |  |  | [NAME]. No.
 |  | Fax No. |  |  | E-mail
 |  | Address
Particulars of other requests:
Request / Difficulty |  |  |  |  |  | Action expected from the organisers
Date |  |  | Signature
Spreadsheet: 03770f74-320b-4026-8f94-1e32ca7fee3d
Sheet: Sheet1

Unnamed: 0 | Unnamed: 1 | Unnamed: 2 | Unnamed: 3 | Unnamed: 4 | Unnamed: 5 | Unnamed: 6 | Unnamed: 7 | Unnamed: 8 | Unnamed: 9 | Unnamed: 10
Cost of Production Calculator
by [NAME], [NAME], & Lynn Kime
 |  |  |  |  | A tool to calculate and analyze the money invested in a block of fruit trees in Pennsylvania.
 |  |  |  |  | These totals are calculated under the assumption that the cost of establishment has already
 |  |  |  |  | paid for itself.  Use well-established blocks for best results.  Enter data in white boxes only.
 |  |  |  |  | Directions:
 |  |  |  | 1) | click on 'Farm Info' and provide the costs for your farm in each white box.  Those figures should reflect
 |  |  |  |  | the expenses accrued over one year.  The division of labor should be filled out in consideration of what percent of wages are paid
 |  |  |  |  | for each different task this year.
 |  |  |  | 2) | click on one of the other four tabs ('apples', 'peaches' etc.) .to analyze the cost of production for a block of one of these crops
 |  |  |  |  | Provide information on the block you wish to analyze in the light green block at the top - white boxes only.
 |  |  |  | 3) | Change the defaults in the white boxes below to reflect how this block was managed by answering 'yes' or 'no'.  These defaults are found below
 |  |  |  |  | the light green block.  In the case of the 'custom hire' and 'spray program' defaults - should you report savings in these areas, indicate
 |  |  |  |  | the percent saved over normal in the outlined box below.  For instance, if you had no mites and you believe miticide is 20% of your program,
 |  |  |  |  | by not spraying miticide, you'd have saved 20%.
 |  |  |  | 4) | Should you want to compare one level of production to another, clicking on the 'block comparison' will give you a quick
 |  |  |  |  | comparison of the cost of production between different crops
 |  |  |  |  | Hint: You can analyze any crop in any of the 'apples', 'peaches' etc tabs, not only the one used for the title of the tab.
 |  |  |  |  | Disclaimer: Calculator not accurate for crops in which harvest labor is saved, i.e. mechanized harvested crops such as tart cherries. The accuracy and predictions of fruit production calculators are based on certain cost measures and practices, all results may not be applicable to all opeartions.
 |  |  |  |  |  |  |  |  |  | extension.psu.edu/fruit-production
Spreadsheet: 874144d1720710346-calculate-price-of-bond-11-july-2024
Sheet: Sheet1

Settlement Date | 2024-11-07 00:00:00
Maturity Date | 2028-11-07 00:00:00 |  |  |  | Discount Rate |  | 0.04 | = YTM
Coupon Rate (%) | 0.04 | based on par value
Yield to Maturity (%) | 0.04 | based on purchase price |  |  |  | Time Value |  |  | Cumulative
Redemption Value | 1000 | = par value |  |  | Year | Factor | Cash Flow | DCF | DCF
Coupon Payments per Year | 1 |  |  |  | 0 |  | -1000
Day Count Basis | 0 |  |  |  | 1
 |  |  |  |  | 2
Bond Price |  | should be equal to 1,000 |  |  | 3
 |  | per cash outflow at Year 0 |  |  | 4
Spreadsheet: 879349d1726831559-data-lookup-based-upon-date-range-test-document
Sheet: Report

From Date | 2024-01-01 00:00:00
To Date | 31/09/2024
ID | V1 COMMENTS | REJECTION REASON | V2 COMMENTS | REJECTION REASON
555624
Expected results
Date range set to 01/01/2024 to 20/09/2024
ID | V1 COMMENTS | REJECTION REASON | V2 COMMENTS | REJECTION REASON
555624 | Test comment | Incorrect Colour
Expected results
Date range set to 01/01/2024 to 31/09/2024
ID | V1 COMMENTS | REJECTION REASON | V2 COMMENTS | REJECTION REASON
555624 | Test comment | Incorrect Colour | Test comment number 2 | [NAME]
Expected results
Date range set to 21/09/2024 to 31/09/2024
ID | V1 COMMENTS | REJECTION REASON | V2 COMMENTS | REJECTION REASON
555624 |  |  | Test comment number 2 | [NAME]
Spreadsheet: 875393d1721973983-need-sum-data-vertically-te
Sheet: Data

Column1 | Column2 | Column3 | Column4 | Column5 | Column6 | Column7 | Column8 | Column9 | Column10 | Column11 | Column12 | Column13 | Column14 | Column15 | Column16 | Column17
Emp No | Name | 2023-01-01 00:00:00 |  |  |  |  | 2023-02-01 00:00:00 |  |  |  |  | 2023-03-01 00:00:00
 |  | V | PH | S | U | A | V | PH | S | U | A | V | PH | S | U | A
00001 | [NAME] | 1 | 2 | 3 | 0 | 1 | 1 | 2 | 0 | 1 | 1 | 2 | 0 | 0 | 0 | 0
00002 | Demian | 4 | 0 | 0 | 0 | 0 | 4 | 3 | 0 | 0 | 0 | 2 | 0 | 0 | 0 | 0
00005 | [NAME] | 3 | 1 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 2 | 0 | 0
00015 | MOHAMMAD | 0 | 0 | 0 | 0 | 0 | 9 | 2 | 0 | 0 | 0 | 9 | 0 | 0 | 0 | 0
00018 | MEGZARI | 2 | 1 | 1 | 0 | 0 | 0 | 1 | 0 | 0 | 0 | 19 | 0 | 0 | 1 | 0
Spreadsheet: 842152d1694201660-unique-function-to-remove-duplicate-values-help
Sheet: Sheet1

 | Location | Order | Amount | Sum | What I want to happen | Location | Order | Sum
 | CAL | 1234 | 1500 |  |  | CAL | 1234 | 1500
 | CAL | 1235 | 2000 |  |  | CAL | 1235 | 4500
 | CAL | 1235 | 2500 |  | -----> | CAL | 1236 | 6500
 | CAL | 1236 | 3000
 | CAL | 1236 | 3500
Please fix below formula
Spreadsheet: ada6062b-c14d-4ab1-88f0-05cd1919433f
Sheet: East

ATTACHMENT 9 PRICE SCHEDULE
EAST COUNTY
 | Service Address:
 | East County Division
 | 250 E. Main St.
 | El Cajon, CA 92020
 | MODEL | SERIAL # | [NAME] ID# | OLD ID # | PRICE Base Year | PRICE Year 1 | PRICE Year 2 | PRICE Year 3 | PRICE Year 4
1 | RAPIDPRINT ARL-E | 489874 | 1993 | 92598
2 | RAPIDPRINT ARL-E | 489878 | 2298 | 92595
3 | RAPIDPRINT ARL-E | 489879 | 1997 | 92594
4 | RAPIDPRINT ARL-E | 489875 | 1996 | 92596
5 | RAPIDPRINT ARL-E | 489877 | 1995 | 10762
6 | [NAME] | 468664 | 2002 | 91189
7 | AMANO PIX3000 | 392115826 | 1990 | 91529
8 | [NAME] | 466834 | 1999 | 10509
9 | [NAME] | 857346DF | 2047 | 91070
10 | [NAME] | 846428MD | 2392 | 77167
11 | [NAME] | 467311 | 2001 | 91426
12 | [NAME] | 286992 | 3266 | 10130
13 | [NAME] | 383687 | 2046 | 10494
14 | RAPIDPRINT ARL-E | 507725 | 2000 | 10455
15 | RAPIDPRINT ARL-E | 507726 | 2299 | 10457
16 | RAPIDPRINT ARL-E | 502308 | 2397
17 | RAPIDPRINT ARL-E | 502309 | 2394
18 | RAPIDPRINT ARL-E | 502310 | 2393
19 | RAPIDPRINT ARL-E | 502311 | 2398
20 | RAPIDPRINT ARL-E | 502348 | 2396
21 | RAPIDPRINT ARL-E | 507724 | 2395 | 10456
22 | [NAME] | 509000 | 3158 | 10567
23 | [NAME] | 351037 | 2297 | 76796
24 | AMANO PIX3000 | 323151662 | 2400 | 93379
25 | AMANO PIX3000 | 341161146 | 2399 | 10008
26 | [NAME] | 369456 | 2159 | n/a
27 | RAPIDPRINT ARL-E | 531515 | 2567 | n/a
28 | RAPIDPRINT ARL-E | 531516 | 2568 | n/a
29 | RAPIDPRINT ARL-E | 531517 | 2569 | n/a
 |  |  | TOTAL *
 |  |  | * transfer these totals to summary sheet
Spreadsheet: 835052d1688242881-locate-multiple-match-results-and-return-adjacent-cell-value-s666-pq-locate-multiple-match-results-and-return-adjacent-cell-value
Sheet: Sheet1

 | ⤋  Source Data  ⤋ |  | ⤋  Trying to get Results  ⤋ |  |  |  | ⤋  Source Data  ⤋ |  | ⤋  Expected Result  ⤋
 |  |  |  |  | [NAME]
 | JobCost | JobName | JobCostSort | RowForIndex | JobNameSort1 |  | JobCost | JobName | JobCostSort | JobNameSort
 | 5 | Job 1 |  |  |  |  | 5 | Job 1 |  | Job 18
 | 7 | Job 2 |  |  |  |  | 7 | Job 2 |  | Job 20
 | 0 | Job 3 |  |  |  |  | 0 | Job 3 |  | Job 17
 | 6 | Job 4 |  |  |  |  | 6 | Job 4 |  | Job 19
 | 0 | Job 5 |  |  |  |  | 0 | Job 5 |  | Job 12
 | 12 | Job 6 |  |  |  |  | 12 | Job 6 |  | Job 7
 | 15 | Job 7 |  |  |  |  | 15 | Job 7 |  | Job 15
 | 3 | Job 8 |  |  |  |  | 3 | Job 8 |  | Job 13
 | 2 | Job 9 |  |  |  |  | 2 | Job 9 |  | Job 6
 | 5 | Job 10 |  |  |  |  | 5 | Job 10 |  | Job 14
 | 0 | Job 11 |  |  |  |  | 0 | Job 11 |  | Job 2
 | 16 | Job 12 |  |  |  |  | 16 | Job 12 |  | Job 4
 | 13 | Job 13 |  |  |  |  | 13 | Job 13 |  | Job 1
 | 9 | Job 14 |  |  |  |  | 9 | Job 14 |  | Job 10
 | 14 | Job 15 |  |  |  |  | 14 | Job 15 |  | Job 8
 | 0 | Job 16 |  |  |  |  | 0 | Job 16 |  | Job 9
 | 20 | Job 17 |  |  |  |  | 20 | Job 17 |  | Job 3
 | 25 | Job 18 |  |  |  |  | 25 | Job 18 |  | Job 5
 | 17 | Job 19 |  |  |  |  | 17 | Job 19 |  | Job 11
 | 21 | Job 20 |  |  |  |  | 21 | Job 20 |  | Job 16
Spreadsheet: 88941d1288744492-return-row-for-nth-occurrence-of-text-in-array-nexta
Sheet: Sheet1

^ | 2 | 1st
a | 5 | 2nd
5 | 6 | 3rd
b | 9 | 4th
a | 11 | 5th
a
v
c
a
v
a
Spreadsheet: louise_kitchen__23043__CFs by Industry and Erating
Sheet: Industrial

Industrial Cash Flows
Sorted by E Rating
E rating | Data | Total
0 | Sum of Total CF | -25943.23098999957
 | Sum of Positive CF | 6376118.98441
 | Sum of Negative CF | -6402062.2154
1 | Sum of Total CF | -49571719.09966
 | Sum of Positive CF | 4157730.11074
 | Sum of Negative CF | -53729449.2104
2 | Sum of Total CF | -23848265.993739
 | Sum of Positive CF | 175531024.6691591
 | Sum of Negative CF | -199379290.662898
3 | Sum of Total CF | 70778247.95211004
 | Sum of Positive CF | 96952160.72814001
 | Sum of Negative CF | -26173912.77603001
4 | Sum of Total CF | 37246601.14712499
 | Sum of Positive CF | 122950529.006505
 | Sum of Negative CF | -85703927.85938002
5 | Sum of Total CF | 14012331.36358003
 | Sum of Positive CF | 120188598.85862
 | Sum of Negative CF | -106176267.49504
6 | Sum of Total CF | 61873217.17948999
 | Sum of Positive CF | 138045664.60607
 | Sum of Negative CF | -76172447.42658001
7 | Sum of Total CF | 20109794.12378
 | Sum of Positive CF | 80518265.48517996
 | Sum of Negative CF | -60408471.36139999
8 | Sum of Total CF | 38398557.1246
 | Sum of Positive CF | 110764456.6873
 | Sum of Negative CF | -72365899.5627
9 | Sum of Total CF | -548054434.0796193
 | Sum of Positive CF | 309368616.8170381
 | Sum of Negative CF | -857423050.8966569
10 | Sum of Total CF | 116683586.38626
 | Sum of Positive CF | 198820511.839
 | Sum of Negative CF | -82136925.45274009
11 | Sum of Total CF | -24484818.38829
 | Sum of Positive CF | 28784173.19993
 | Sum of Negative CF | -53268991.58822
12 | Sum of Total CF | 5255659.48282
 | Sum of Positive CF | 12360249.78758
 | Sum of Negative CF | -7104590.304760001
Total Sum of Total CF |  | -281627186.0325333
Total Sum of Positive CF |  | 1404818100.779672
Total Sum of Negative CF |  | -1686445286.812205