tianzl66/Sheetpedia huggingface dataset:
Spreadsheet: 39890d1238146326-vlookup-query-amended-pricing-sheet
Sheet: Pricing Sheet

PRICING SHEET |  | PROJECT:
 | Material Description | Unit Price | QTY | Material cost | [NAME] | Labour Total | Remarks
 | Materials Total: |  |  | 0
 | P.C. Sums & Contractors:
 | Light Fittings (B/F from Light fittings sheet) |  |  | See front sheet |  | 0
 |  |  |  | 0 |  | 0
 |  |  |  | 0 |  | 0
 |  |  |  | 0 |  | 0
 |  |  |  | 0 |  | 0
 |  |  |  | 0 |  | 0
 |  |  |  | 0 |  | 0
 |  |  |  | 0 |  | 0
 |  |  |  | 0 |  | 0
 |  |  |  | 0 |  | 0
 |  |  |  | 0 |  | 0
 |  |  |  | 0 |  | 0
 |  |  |  | 0 |  | 0
 |  |  |  | 0 |  | 0
 |  |  |  | 0 |  | 0
 |  |  |  | 0 |  | 0
 |  |  |  | 0 |  | 0
 |  |  |  | 0 |  | 0
 |  |  |  | 0 |  | 0
 |  |  |  | 0 |  | 0
 |  |  |  | 0 |  | 0
 |  |  |  | 0 |  | 0
 |  |  |  | 0 |  | 0
 |  |  |  | 0 |  | 0
 |  |  |  | 0 |  | 0
 |  |  |  | 0 |  | 0
 |  |  |  | 0 |  | 0
 |  |  |  | 0 |  | 0
 |  |  |  | 0 |  | 0
 | P.C.Sum & Contractors Total: |  |  | 0 |  | 0 | Hours
Spreadsheet: 4d927394-5535-47d1-adba-da63a56a1de4
Sheet: Sheet1

Unnamed: 0 | Unnamed: 1 | TIB-The Independent BankersBank | Unnamed: 3 | Unnamed: 4 | Unnamed: 5 | .25 cost to Price to Waive Escrows | Unnamed: 7
 |  | 350 [NAME]., [NAME] |  |  |  | LTV must be 80% or less to qualify.
 |  | [PHONE] Toll Free//[PHONE] fax
 |  | Rate Sheet Effective: |  |  | 2013-10-24 09:39:41.900000
Product: Conv-Conforming Fixed Rate 30 Year |  |  |  |  |  | Loan Level Price Adjustment
Rate | 15 Day | 30 Day | 45 Day | 60 Day |  | Price adjustments are cumulative
4.75 | 102.5 | 102.375 | 102.25 | 101.875 |  | and are added to price quote
4.625 | 102.5 | 102.375 | 102.25 | 101.875
4.5 | 102.44 | 102.315 | 102.19 | 101.815 |  | Note: | Refer To Price [NAME]
4.375 | 101.9 | 101.775 | 101.65 | 101.275 |  |  | For all Price Adjs
4.25 | 101.383 | 101.258 | 101.133 | 100.508
4.125 | 100.615 | 100.49 | 100.365 | 99.74
4 | 99.655 | 99.53 | 99.405 | 98.78
3.875 | 98.64 | 98.515 | 98.39 | 97.765
3.75 | 97.765 | 97.64 | 97.515 | 96.89 |  | Please note availability of
 |  |  |  |  |  | TIB Servicing Retained Product
 |  |  |  |  |  | For Conventional Loans Only.
 |  |  |  |  |  | A .25 adjustment to SRP
 |  |  |  |  |  | Will apply.
Product: Conv-Conforming Fixed Rate 15 Year
Rate | 15 Day | 30 Day | 45 Day | 60 Day
3.75 | 102.5 | 102.375 | 102.25 | 101.875
3.625 | 102.477 | 102.352 | 102.227 | 101.852
3.5 | 101.962 | 101.837 | 101.712 | 101.337
3.375 | 101.21 | 101.085 | 100.96 | 100.585
3.25 | 100.486 | 100.361 | 100.236 | 99.611
3.125 | 99.831 | 99.706 | 99.581 | 98.956
3 | 99.081 | 98.956 | 98.831 | 98.206 |  | Minimum loan amount:
 |  |  |  |  |  | TIB does not have a minimum loan
 |  |  |  |  |  | loan amount, however a 1.00% price
 |  |  |  |  |  | discount will apply to loan amounts
 |  |  |  |  |  | less than $39,999.00
 |  |  |  |  |  | 2010 Conforming Loan Limits
 |  |  |  |  |  | 1 Unit-$417,000
 |  |  |  |  |  | 2 Unit-$533,850
 |  |  |  |  |  | 3 Unit-$645,300
 |  |  |  |  |  | 4 Unit-$801,950
A SERVICE RELEASE PREMIUM WILL BE PAID IN [NAME] WITH THE ATTACHED SCHEDULE.
 |  | TIB-The Independent BankersBank
 |  | 350 [NAME]., [NAME]
 |  | [PHONE] Toll Free//[PHONE] fax
 |  | Rate Sheet Effective:
 |  |  |  |  |  | Loan Level Price Adjustment
Rate | 15 Day | 30 Day | 45 Day |  |  | Price adjustments are cumulative
 |  |  |  |  |  | & adj. Made to the price quote
EXPIRATION DATES:
15 DAY | 2013-11-07 09:39:41.900000
30 DAY | 2013-11-22 09:39:41.900000
45 DAY | 2013-12-07 09:39:41.900000
60 DAY | 2013-12-22 09:39:41.900000
90 DAY | 2014-01-21 09:39:41.900000
A SERVICE RELEASE PREMIUM WILL BE PAID IN [NAME] WITH THE ATTACHED SCHEDULE.
Spreadsheet: 708023d1607589493-how-to-report-the-top-20-and-bottom-20-of-a-data-table-report-with-2-conditions-dashboard
Sheet: NEW ZEALAND

Country | Category of item | Brands | Name of item | Reference N of the item | End user price in local currency after VAT | GNI per capita | Bundled | End user price in EUR after VAT |  | Top 5  lowest price | AB | MedEL | Cochlear | OM | Custom label
Country | Category of item | Brands | Name of item | Reference N of the item | End user price in local currency after VAT | GNI per capita | Bundled | End user price in EUR after VAT |  | Top 5  highest price | AB | MedEL | Cochlear | OM | Custom label
Country | Category of item | Brands | Name of item | Reference N of the item | End user price in local currency after VAT | GNI per capita | Bundled | End user price in EUR after VAT |  | Antenna cable | AB | MedEL | Cochlear | OM | Custom label
Country | Category of item | Brands | Name of item | Reference N of the item | End user price in local currency after VAT | GNI per capita | Bundled | End user price in EUR after VAT |  | [NAME] | AB | MedEL | Cochlear | OM | Custom label
Country | Category of item | Brands | Name of item | Reference N of the item | End user price in local currency after VAT | GNI per capita | Bundled | End user price in EUR after VAT |  | Charger | AB | MedEL | Cochlear | OM | Custom label
Country | Category of item | Brands | Name of item | Reference N of the item | End user price in local currency after VAT | GNI per capita | Bundled | End user price in EUR after VAT |  | Recheargable battery | AB | MedEL | Cochlear | OM | Custom label
Country | Category of item | Brands | Name of item | Reference N of the item | End user price in local currency after VAT | GNI per capita | Bundled | End user price in EUR after VAT |  | Full swim kit | AB | MedEL | Cochlear | OM | Custom label
Spreadsheet: 473198d1470102692-pulling-data-from-another-workbook-book2
Sheet: excel_connection

Workbook 1 (Student_table) | F2 | F3 | F4 | F5 | F6 | F7 | F8
ID | Name | Grade |  | I | don’t | want | this
st01 | [NAME] | A |  | asdfd
st02 | [NAME] | C |  | asfdas
st03 | Foo Bar | D |  |  | dfdasasf |  | f
st… | …. | …. |  | fasf
st9998 | [NAME] | B |  |  |  |  | f
[NAME] | Foo Bar | A |  |  |  | dasf
 |  | I | don't | want | this
Spreadsheet: 60630d1261132036-countif-over-different-fields-testabsence
Sheet: Pivot

Dept | Data | Total
Team 1 | October | 8.5
 | November | 0
 | Decembre | 0
Team 2 | October | 2
 | November | 0
 | Decembre | 0
Total October |  | 10.5
Total November |  | 0
Total Decembre |  | 0
Spreadsheet: 5d835cc9-8a51-4307-8409-34f5fd9a611e
Sheet: Sheet1

Test Referenced | Entry Type | Mayo ID | Description | Reporting Description | Method | Collection Container | Temperature | Stability | [NAME] | Unit of Measure | [NAME] | Minimum Volume | Reject Due To | Reference Values | Days/Times Performed | Analytic Time | Maximum Lab Time | CPT Units | CPT Code | LOINC® Code | LOINC® Attributes | Always Performed | Orderable Separately | Performing Location
BMNA | Test | BMNA | Breast Milk Nutritional Analysis | Breast Milk Nutritional Analysis | Thin-Layer Chromatography (TLC)/Colorimetry/Spectrophotometry (SP)/Other Methodologies as Appropriate | Plastic container: PlCont |  |  | 5 | mL | Container/Tube: Tightly-sealed, plastic container [NAME]: 5 mL Collection Instructions: 1. Specimen must be labeled with the mother's name (not the baby's). 2. Indicate mother's age. | 4 mL | Hemolysis	NA Thawing	Warm reject; Cold reject Lipemia	NA Icterus	NA Other	NA | Post-Partum Day 1	Post-Partum Day 36 Glucose	15-40 mg/dL	15-40 mg/dL Lactose	2,100-6,000 mg/dL	2,700-8,000 mg/dL Triglycerides	420-3,900 mg/dL	1,600-6,400 mg/dL Proteins	1,200-4,700 mg/dL	880-1,920 mg/dL | Monday through Friday; Continuously | 4 days | 7 days |  | Profile |  |  |  |  | Rochester
BMNA | [NAME] | BRSTMLK | Breast Milk |  |  |  | Frozen | 150 days
BMNA | Result | GLBMA | Glucose | Glucose | Numeric |  |  |  |  | mg/dL |  |  |  |  |  |  |  |  |  | 2344-0
BMNA | Result | LACT | Lactose | Lactose | Numeric |  |  |  |  | mg/dL |  |  |  |  |  |  |  |  |  | In Process
BMNA | Result | TGBMA | Triglycerides | Triglycerides | Numeric |  |  |  |  | mg/dL |  |  |  |  |  |  |  |  |  | 12228-3
BMNA | Result | PTBMA | Proteins | Proteins | Numeric |  |  |  |  | mg/dL |  |  |  |  |  |  |  |  |  | 2881-1
BMNA | Billing Component | BMNA |  | Protein, Total |  |  |  |  |  |  |  |  |  |  |  |  |  | 1 | 84157
BMNA | Billing Component | BMNA |  | Glucose, Quantitative |  |  |  |  |  |  |  |  |  |  |  |  |  | 1 | 82945
BMNA | Billing Component | BMNA |  | Triglycerides |  |  |  |  |  |  |  |  |  |  |  |  |  | 1 | 84478
Spreadsheet: 766656d1643987486-nested-if-function-problem-book1-tms
Sheet: Sheet1

Name | PT ID | Payer |  | Outcome | Attempted formula
Some Name | 1234 | Private Pay |  | No note |  |  |  |  |  | Private Pay | No note
Some Name | 2345 | [NAME] |  | Note |  |  |  |  |  | Self Pay | No note
 |  |  |  | Blank (literally blank) |  |  |  |  |  | No insurance | No note
Some Name | 3456 | Self Pay |  | No note |  |  |  |  |  | OPT | No note
Some Name | 5678 | Aetna |  | Note |  |  |  |  |  | MCR-S | No note
Some Name | 7900 | No insurance |  | No note |  |  |  |  |  | MCR-M | No note
 |  | OPT |  | No note |  |  |  |  |  | Dependent | No note
 |  | MCR-S |  | No note
 |  | MCR-M |  | No note
 |  | Dependent |  | No note
Spreadsheet: 00458050-e5b7-4ce7-b6c7-c6b68f87f3a9
Sheet: Sheet1

Sex Offense Victims | Unnamed: 1 | Unnamed: 2 | Unnamed: 3 | Unnamed: 4 | Unnamed: 5 | Unnamed: 6 | Unnamed: 7 | Unnamed: 8 | Unnamed: 9
Sexual Assault with an Object
Sex and Race
by Age, 2011
Age | Total Victims | Sex |  |  | Race
 |  | Male | Female | Unknown | White | Black | American Indian/ Alaskan Native | Asian/Pacific Islander | Unknown
Total | 2951 | 388 | 2556 | 7 | 2380 | 427 | 19 | 21 | 104
15 and under | 1662 | 290 | 1369 | 3 | 1333 | 251 | 4 | 8 | 66
16 – 20 | 443 | 32 | 411 | 0 | 363 | 60 | 4 | 5 | 11
21 – 25 | 250 | 19 | 230 | 1 | 206 | 32 | 3 | 3 | 6
26 – 30 | 160 | 9 | 151 | 0 | 125 | 29 | 2 | 1 | 3
31 – 35 | 106 | 8 | 98 | 0 | 89 | 11 | 1 | 1 | 4
36 – 40 | 79 | 7 | 72 | 0 | 66 | 10 | 1 | 0 | 2
41 – 45 | 73 | 8 | 65 | 0 | 57 | 13 | 1 | 1 | 1
46 – 50 | 55 | 3 | 52 | 0 | 45 | 7 | 2 | 1 | 0
51 – 55 | 33 | 3 | 30 | 0 | 30 | 2 | 1 | 0 | 0
56 – 60 | 24 | 2 | 22 | 0 | 19 | 4 | 0 | 1 | 0
61 – 65 | 12 | 1 | 11 | 0 | 11 | 1 | 0 | 0 | 0
66 and over | 26 | 3 | 23 | 0 | 19 | 6 | 0 | 0 | 1
Unknown Age | 28 | 3 | 22 | 3 | 17 | 1 | 0 | 0 | 10
Spreadsheet: 268027d1380369620-sum-of-cells-with-values-coming-from-a-if-formula-guias-de-remessa
Sheet: Super XXI

SETEMBRO 2013
Produto  Dia | Bijou | Paes Agua | Integrais | Centeio 0,5 Kg | Fermento | Bolo Rei
1
2
3
4
5
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
TOTAL
Spreadsheet: 801892d1666456071-expand-average-formula-with-another-sheet-expense-tracker_excel
Sheet: Forecast

 | 2022-11-01 00:00:00 | Lunch | 150
 | 2022-11-02 00:00:00 | Lunch | 140
Spreadsheet: 526261d1499234019-payload-calculator-formulas-payload-calculator
Sheet: Sheet1

 | Airplane | Pilot
 | PZ-NMM | [NAME]
 |  |  | Departure | Destination | Payload |  | [NAME] landing weight | Fuel Burn leg | T/O Fuel | BEW | Pilot | T/O restriction
 |  | Leg 1 | ZO | LA
 |  | [NAME] | LA | DU
 |  | Leg 3 | DU | ZO
 |  | [NAME]
 |  | Leg 5
Spreadsheet: 0478c1d9-8971-42cb-9381-88acdb976c25
Sheet: 15 BSA Designated Support

15 | District/council designated support: Complete district executive and/or Scout Executive designated program support projects.
 |  | Complete one project |  |  | [NAME] | 75
 |  | Complete two projects |  |  | Silver | 100
 |  | Complete three projects |  |  | Gold | 200
 | District executive/Scout Executive designated program support projects are to be developed during a meeting with the lodge and/or chapter Key 3 with consideration for both the current local council and national Order of the [NAME] strategic plans.  Here are some examples of district executive/Scout Executive designated programs or projects:
 | • | The chapter is to hold its chapter meetings on the same night and at the same location as the district roundtable for Scoutmasters.
 | • | The chapter Key 3 is to meet at least quarterly to discuss progress in the chapter.
 | • | The chapter holds a chapter meeting or gathering at a district event such as a camporee.
 | • | The chapter is to provide manpower, resources, and/or program assistance in support of the district Cub Scout outdoor program or conducts at least two Cub Scout/Webelos Arrow of Light crossover ceremonies for Cub Scout packs requesting them.
 | • | The chapter is to conduct a call out ceremony during the campfire at the district camporee.
 | List the programs or projects the district/Scout Executive designated to the chapter
 | 1.
 |  | When did the executive designate this program or project?
 |  | When did the chapter complete the program or project?
 | 2.
 |  | When did the executive designate this program or project?
 |  | When did the chapter complete the program or project?
 | 3.
 |  | When did the executive designate this program or project?
 |  | When did the chapter complete the program or project?
 |  | What benefit did these projects have?  What should the chapter focus on next year?
 | Plan for Next Year
Spreadsheet: 776872d1649953831-return-two-or-more-strings-from-the-text-located-in-one-cell-return_two_and_more_strings_form_text_in_one_cell_v02-indignus-
Sheet: Cas_Number

CAS Number | [NAME]
106-42-3
106-46-7
106-65-0
107-06-2
108-03-2
108-19-0
108-90-7
108-93-0
109-66-0
109-86-4
109-86-5
109-99-9
110-12-3
110-49-6
110-80-5
11103-86-9
111-03-86-9
111109-77-4
111-15-8
111-15-9
111-84-2
1163-19-5
118-82-1
122-39-4
122-93-4
123-42-2
123-54-6
12656-85-8
127-19-5
13530-65-9
13654-09-6
138495-42-8
138495-42-8
142-82-5
142844-00-6
147783-69-5
150-76-5
16096-31-4
19019-43-3
21850-44-2
25013-15-4
2602-34-8
26172-55-4
2682-20-4
3107-18-4
32536-52-0
34590-94-8
353-50-4
375-03-1
5026-74-4
51160-97-5
5117-12-4
63936-56-1
67584-42-3
68156-01-4
68156-07-0
7439-97-6
75-05-8
75-15-0
7758-97-6
78-59-1
79-00-5
79-20-9
79-46-9
79-94-7
79-94-8
8005-02-5
900169-60-0
91-20-3
98-29-3
Spreadsheet: 884549d1733783622-stuck-with-formula-to-look-up-to-row-based-on-conditions-bulk-barcodes-copy
Sheet: Driver Data

First Name | Last Name | Capitalise | First initial | 4 digits | Concat |  | Month Start Date
Ant | Man |  |  |  |  |  | 2024-12-01 00:00:00
[NAME] | [NAME]
Captain | America
Dare | Devil
[NAME] | Maximoff
Thor | Odinson
Spreadsheet: 329233d1404235628-please-help-dropdown-list-that-removes-previously-selected-item-supervisors
Sheet: Supervisors

Supervisor 1
Supervisor 2
Supervisor 3
[NAME]
Supervisor 5
Supervisor 6
Supervisor 7
Supervisor 8
Supervisor 9
Supervisor 10
Supervisor 11
Supervisor 12
Supervisor 13
Supervisor 14
Supervisor 15
Supervisor 16
Supervisor 17
Supervisor 18
Supervisor 19
Supervisor 20
Spreadsheet: 44450d1243220699-skip-blank-cells-seroleh
Sheet: Sheet1

 |  | data
 |  | No | Name | Y/N
 |  | 631 | [NAME] | 1
 |  | 632 | Beckham
 |  | 633 | [NAME] | 1
 |  | 634 | Lampard | 1
 |  | 635 | Gerrard
 |  | 636 | [NAME]
 |  | 637 | [NAME] | 1
 |  | solution
 |  | No | Name
 |  |  | I don't want the #0 on D15, [NAME] and [NAME]. skip it. Using excel code. I want Like this:
 |  |  | Name
 |  |  | [NAME]
 |  |  | [NAME]
 |  |  | Lampard
 |  |  | [NAME]
Spreadsheet: 0f1f7833-0537-44d1-a158-126a5c6b18b8
Sheet: T63

الجدول 63: وفيات الاطفال (1-4 سنوات) المسجلة، 2000-2012
Table 63: Registered total child (1-4 years) deaths, 2000-2012
Country | 2000 | 2001 | 2002 | 2003 | 2004 | 2005 | 2006 | 2007 | 2008 | 2009 | 2010 | 2011 | 2012 | البلد
Bahrain | 37 | 45 | 27 | 31 | 26 | 31 | 37 | 32 |  |  | … | … | … | البحرين
Egypt | 12423 | 12460 | 11364 | 13050 | 11789 | 10735 | 11026 | 9551 | 10154 | 11678 | 10526 | 10749 | … | مصر
Iraq | … | … | … | … | … | … | … | … | … | … | … | … | … | العراق
Jordan | … | … | … | … | … | … | … | … | … | … | … | … | … | الأردن
Kuwait | 113 | 87 | 74 | 85 | 88 | 84 | 77 | 84 | 80 | 108 | 99 | 71 | … | الكويت
Lebanon | … | … | … | … | … | … | … | … | … | … | … | … | … | لبنان
Libya | … | … | … | … | … | … | … | … | … | … | … | … | … | ليبيا
Morocco | … | … | … | … | … | … | … | … | … | … | … | … | … | [NAME]
Oman | 59 | 57 | 71 | 51 | 55 | 63 | 90 | 103 | 137 | 125 | 113 |  | … | عمان
Palestine | 351 | 366 | 327 | 392 | 330 | 327 | 343 | 339 | 164 | 162 | 160 | 116 | … | فلسطين
Qatar | 15 | 26 | 17 | 23 | 24 | 30 | 37 | 25 | 32 | 31 | 33 | 29 | … | قطر
Saudi Arabia | 2151 | 2094 | 2038 | 1986 | 1935 | 1895 | 1842 | 1789 | 1734 | 1652 | … | ... | … | المملكة العربية السعودية
Sudan | ... | ... | ... | ... | ... | ... | ... | ... | … | … | … | … | … | السودان
Syrian Arab Republic | … | … | 24 | … | … | … | 22 | … | … | 21 | … | … | … | الجمهورية العربية السورية
Tunis | … | … | … | … | … | … | … | … | … | … | … | 641 | … | تونس
United Arab Emirates | 162 | 138 | 159 | 488 | 550 | 138 | 98 | 120 | 161 | 164 | 123 | ... | … | الإمارات العربية المتحدة
Yemen | … | … | … | … | … | … | … | … | … | … | … | … | … | اليمن
Spreadsheet: 673513d1587417049-sumif-and-vlookup-i-think-2020-04-20-oeldere-pt-673484d1587402472-sumif-and-vlookup-i-think-co-tracker
Sheet: Assigned Projects

Store # | Project Location | DD & CD Proposal | CO Totals | Project Total | % Contract Cost Increase
 | Altamonte | 3452
 | Bozeman | 1200 | 19577
 | Red City | 1500
 | Moore | 5444
 | Heights | 3478
 | Clovis | 3000
 | Dickinson | 6245
Spreadsheet: 152950d1335633736-excel-2007-sumif-and-dynamic-names-teng-master-summer-jr-
Sheet: MON

DAILY MOVEMENTS
DAY | Mon |  | DATE | 2010-01-11 00:00:00 |  |  | mon |  |  |  |  | [NAME] | [NAME]
REG | FLT | NO | STA | ATA | TYPE | DEST | FLT | NO | STD | ATD | OIL | MOVE | DLY | BALM | COMMENTS | codes | Dscription |  | BA02
 |  |  |  |  |  |  |  |  |  |  |  | 0
 |  |  |  |  |  |  |  |  |  |  |  | 0 |  |  |  |  | Awaitng spares | 0
 |  |  |  |  |  |  |  |  |  |  |  | 0 |  |  |  |  |  | 0
 |  |  |  |  |  |  |  |  |  |  |  | 0 |  |  |  | DG |  | 0
 |  |  |  |  |  |  |  |  |  |  |  | 0 |  |  | STAYOVER CHECK
 |  |  |  |  |  |  |  |  |  |  |  | 0
 |  |  |  |  |  |  |  |  |  |  |  | 0
 |  |  |  |  |  |  |  |  |  |  |  | 0 |  |  |  |  |  | 0
 |  |  |  |  |  |  |  |  |  |  |  | 0
 |  |  |  |  |  |  |  |  |  |  |  | 0 |  |  |  |  | Toatal Delays | 0
 |  |  |  |  |  |  |  |  |  |  |  | 0
 |  |  |  |  |  |  |  |  |  |  |  | 0
 |  |  |  |  |  |  |  |  |  |  |  | 0
 |  |  |  |  |  |  |  |  |  |  |  | 0
 |  |  |  |  |  |  |  |  |  |  |  | 0
 |  |  |  |  |  |  |  |  |  |  |  | 0
 |  |  |  |  |  |  |  |  |  |  |  | 0
 |  |  |  |  |  |  |  |  |  |  |  | 0
 |  |  |  |  |  |  |  |  |  |  |  | 0
 |  |  |  |  |  |  |  |  |  |  |  | 0 |  |  | TECH ASSIST
 |  |  |  |  |  |  |  |  |  |  |  | 0
 |  |  |  |  |  |  |  |  |  |  |  | 0
 |  |  |  |  |  |  |  |  |  |  |  | 0
 |  |  |  |  |  |  |  |  |  |  |  | 0
 |  |  |  |  |  |  |  |  |  |  |  | 0
 |  |  |  |  |  |  |  |  |  |  |  | 0
 |  |  |  |  |  |  |  |  |  |  |  | 0
 | PA | 1 | 700 |  | 380 | [NAME] | PA | 1 | 800 | 1 | 1 | 1 | TD |  |  | GF
 | PA | 2 | 700 |  | 380 | [NAME] | PA | 2 | 800 | 1 | 1 | 1 | TD
 |  |  |  |  |  |  |  |  | MON TOTAL |  | 2 | 2 | 2
Spreadsheet: 724590d1616251146-i-need-some-help-on-sum-diferent-criterios-centro-de-custos-2021
Sheet: Vale - Cateme

 |  | CENTROS DE CUSTOS
 |  | CATEME
 |  | Data | [NAME] | Req. / Fact nº | Valor - Mzn | Observação
 |  | 2020-09-01 00:00:00 | Combustivel | 54543 | 4297.3 | Logistica
 |  | 2020-09-01 00:00:00 | Combustivel | 54544 | 2784.4 | [NAME]
 |  | 2020-09-03 00:00:00 | Combustivel | 54559 | 1392.2 | Gerador
 |  | 2020-12-06 00:00:00 | Combustivel | 55143 | 2000.1 | Logistica
 |  | 2020-12-29 00:00:00 | Combustivel | 55260 | 4630.7 | Logistica
Spreadsheet: 726460d1617255797-formula-for-negative-balance-on-receivables-on-outstanding-days-negative-balance
Sheet: Age Analysis

I'm kindly asking for a formula to show "Prepaid" if the the debtors outstanding balance is negative instead of showing days as  in cell F9
Invoice Date | Invoice | Invoice Amount | Amount Received | Outstanding Balance | Days Outstanding | Not yet Due | 1- 30 days | 31 - 60 Days | 61-90 Days | >90 Days
Opening Balance | C002 | 1750 | 1000
2021-02-01 00:00:00 | C006 | 1200 | 1100
2021-02-20 00:00:00 | C007 | 4000 | 5000
Opening Balance | C003 | 1500 | 400
2021-02-01 00:00:00 | C005 | 2000 | 0
2021-02-15 00:00:00 | C008 | 500 | 0
Spreadsheet: 270994d1381777469-vlookup-and-min-function-in-same-cell-min-and-vlookup
Sheet: Data

363 | 2010-10-08 00:00:00
363 | 2010-10-09 00:00:00
363 | 2010-10-11 00:00:00
363 | 2010-10-12 00:00:00
363 | 2010-10-13 00:00:00
363 | 2010-10-14 00:00:00
363 | 2010-10-15 00:00:00
363 | 2010-10-16 00:00:00
363 | 2010-10-18 00:00:00
363 | 2010-10-19 00:00:00
363 | 2010-10-20 00:00:00
363 | 2010-10-21 00:00:00
363 | 2010-10-22 00:00:00
363 | 2010-10-23 00:00:00
363 | 2010-10-25 00:00:00
363 | 2010-10-26 00:00:00
363 | 2010-10-27 00:00:00
363 | 2010-10-28 00:00:00
363 | 2010-10-29 00:00:00
363 | 2010-10-30 00:00:00
363 | 2010-11-01 00:00:00
363 | 2010-11-02 00:00:00
363 | 2010-11-03 00:00:00
363 | 2010-11-04 00:00:00
363 | 2010-11-05 00:00:00
363 | 2010-11-06 00:00:00
363 | 2010-11-08 00:00:00
363 | 2010-11-09 00:00:00
363 | 2010-11-10 00:00:00
363 | 2010-11-11 00:00:00
363 | 2010-11-12 00:00:00
363 | 2010-11-13 00:00:00
363 | 2010-11-14 00:00:00
363 | 2010-11-15 00:00:00
5046 | 2010-10-05 00:00:00
5046 | 2010-10-06 00:00:00
5046 | 2010-10-07 00:00:00
5046 | 2010-10-08 00:00:00
5046 | 2010-10-09 00:00:00
5046 | 2010-10-11 00:00:00
5046 | 2010-10-12 00:00:00
5046 | 2010-10-13 00:00:00
5046 | 2010-10-14 00:00:00
5046 | 2010-10-15 00:00:00
5046 | 2010-10-16 00:00:00
5046 | 2010-10-18 00:00:00
5046 | 2010-10-19 00:00:00
5046 | 2010-10-20 00:00:00
5046 | 2010-10-21 00:00:00
5046 | 2010-10-22 00:00:00
5046 | 2010-10-23 00:00:00
5046 | 2010-10-25 00:00:00
5046 | 2010-10-26 00:00:00
5046 | 2010-10-27 00:00:00
5046 | 2010-10-28 00:00:00
5046 | 2010-10-29 00:00:00
5046 | 2010-10-30 00:00:00
5046 | 2010-11-01 00:00:00
5046 | 2010-11-02 00:00:00