tianzl66/Sheetpedia huggingface dataset:
Spreadsheet: 133479d1324414487-excel-2007-sorting-my-estimate-log-for-follow-up-estimate-log-follow-up
Sheet: GTM Mech

 |  |  | METAL DISTRIBUTORS, INC.  FABRICATION DIVISION, CHARLOTTE, NC |  |  |  |  |  |  | JOB STATUS
Status Codes: 1= we have job; 2= cust. has job; 3= unquoted cust has job; 4=low bidder; 5= lost job, 6= n/a
Quote | Fax List |  | Bid Date | Log In By | Log In Date | Hrs | Ductwork | Est | REP | Rect | Customer | Phone Call
 |  | YTD  Totals
5147 | Y | Doral - Fax | 2011-10-14 00:00:00 | jaw | 2011-10-14 00:00:00 |  | yes |  |  |  | GTM Mechanical
5141 |  | [NAME] Grill #1584 @ Charlotte Midtown | 2011-10-17 00:00:00 | jaw | 2011-10-13 00:00:00 | 1 | 4978 | jtc |  |  | GTM Mechanical
5149 |  | Massage Envy Spa | 2011-10-17 00:00:00 | jaw | 2011-10-14 00:00:00 | 1 | 2757 | jtc |  | 2 | GTM Mechanical
5148 |  | [NAME] | 2011-10-17 00:00:00 | jaw | 2011-10-14 00:00:00 | 1 | 1797 | jtc |  | 2 | GTM Mechanical
5222 |  | [NAME] in Charlotte, NC | 2011-11-14 00:00:00 | jtc | 2011-11-10 00:00:00 | 1 | 5644 | jtc |  |  | GTM Mechanical
5234 |  | Ravin Expansion and Spec Space - Charlotte, NC | 2011-11-18 00:00:00 | jtc | 2011-11-16 00:00:00 | 1 | 1240 | jtc |  |  | GTM Mechanical
5238 |  | Olde Sycamore Golf Club - Charlotte, NC | 2011-11-22 00:00:00 | jtc | 2011-11-22 00:00:00 | 2 | 2933 | jtc |  |  | GTM Mechanical
5241 |  | [NAME], NC | 2011-11-28 00:00:00 | jtc | 2011-11-23 00:00:00 | 1 | 3280 | jtc |  |  | GTM Mechanical
Spreadsheet: 7cca7860-2c4f-4c1f-aca4-398eac4ea76f
Sheet: Sheet1

 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | You may select up to three classroom attributes.  Select only course requirements, as the number of available classrooms will be reduced with each attribute selected.
Subject | Course and Title | Subtitle/Alternate Title | Section | [NAME] | Subterm | Dates | Days | Times | Credits | Instructor(s) | Instructor ID | Contract Code | Percentage | Tuition Detail Code | Amount Per Credit | Registration Approval | [NAME] | Blackboard or LearningHouse | Campus: [NAME], [NAME], Online, Blended | Classroom Attribute A | Classroom Attribute B | Classroom Attribute C | Cross list?   SUBJ CRSE SEC | Comments
Spreadsheet: c319e2ce-6c8e-4172-9758-433f4fef33f6
Sheet: Sheet1

Unnamed: 0 | Reemplaza a: Ninguno | Unnamed: 2 | Emitido: | Unnamed: 4 | Unnamed: 5 | Unnamed: 6 | Página: 1 de 15 | Unnamed: 8 | [NAME] | Unnamed: 10 | Unnamed: 11 | Unnamed: 12
SOLICITUD DE COFINANCIAMIENTO
PREINVERSIÓN DISTRIBUCIÓN AUDIOVISUAL (PI.DA)
I. ESTRUCTURA DE COFINANCIAMIENTO |  |  |  |  |  |  | [NAME]
 |  | $ |  | % | Cargo Año Presupuestario
 |  |  |  |  | Año en curso ($) |  | [NAME] siguiente ($) |  |  | [NAME] |  | …...Meses
Cofinanciamiento  CORFO |  | 0 |  |  |  |  |  |  |  | [NAME] Propiedad Intelectual
Aporte Empresarial |  | 0 |  |  |  |  |  |  |  | Nombre
Costo Total Proyecto |  | 0 |  |  | 0 |  | 0 |  |  | N°
 |  |  |  |  |  |  |  |  |  | Fecha
[NAME] |  | SI____  NO____ |  |  | [NAME] |  | ___%
Origen de Fondos |  | CORFO |  |  |  | Beneficiario Concurso CORFO Desarrollo |  | SÍ |  | NO
II. ANTECEDENTES DE LA EMPRESA
CONTRAPARTE EMPRESARIAL |  |  |  |  |  |  | IDENTIFICACIÓN BENEFICIARIO (S)
Nombre |  |  |  |  |  |  | Rut
Dirección |  |  |  |  |  |  | Razón social
Región |  | [NAME] |  | Comuna |  |  | Nombre Fantasía
[NAME] |  |  |  |  |  |  | Dirección
Comuna |  |  |  |  |  |  | Región
E-mail |  |  |  |  |  |  | [NAME]
Telefono |  | Celular |  | Fax |  |  | Comuna
Dirección Postal |  |  |  |  |  |  | Giro
 |  |  |  |  |  |  | [NAME]
[NAME]
Nombre |  |  |  | Rut |  | Género
Nombre |  |  |  | Rut |  | Género
Socios
Nombre |  |  |  | Rut |  | Participación |  |  | Género
Nombre |  |  |  | Rut |  | Participación |  |  | Género
Nombre |  |  |  | Rut |  | Participación |  |  | Género
 |  |  |  |  |  |  | [NAME]
Spreadsheet: 836010d1689045218-lookup-array-in-another-array-book6
Sheet: Sheet1

 |  |  | Lower | Upper | Class
14 | 3 |  | 1 | 5 | 1
23 | 5 |  | 5 | 10 | 2
2 | 1 |  | 10 | 15 | 3
 |  |  | 15 | 20 | 4
 |  |  | 20 | 25 | 5
Spreadsheet: 817518d1676294447-all-data-pulled-from-different-sheet-to-main-consolidated-sheet-s666-pq-amit-agency-savings-task
Sheet: STK

 | St. Katherine's
 | Name | Employee no. | Position | Contract Hours | Softworks Start Date | Softworks Total worked hours | Approx. Savings rate | Worked weeks holiday pro-rated | Home
 | [NAME] |  | Care Assistant | 44 |  |  | 3.75 |  | STK
 | Aromal Anand |  | Care Assistant | 44 |  |  | 3.75 |  | STK
 | [NAME] | 22638 | Care Assistant | 44 |  |  | 3.75 |  | STK
 | [NAME] | 23066 | Care Assistant | 44 |  |  | 3.75 |  | STK
 | [NAME] | 22840 | Care Assistant | 44 |  |  | 3.75 |  | STK
 | [NAME] |  | Care Assistant | 44 |  |  | 3.75 |  | STK
 | MALAVIKA RAMESH | 22887 | Care Assistant | 44 |  |  | 3.75 |  | STK
 | [NAME] |  | Care Assistant | 44 |  |  | 3.75 |  | STK
 | [NAME] |  | Care Assistant | 44 |  |  | 3.75 |  | STK
 | [NAME] |  | Care Assistant | 44 |  |  | 3.75 |  | STK
 | Nikita Chand |  | Care Assistant | 44 |  |  | 3.75 |  | STK | Who dis?
 | [NAME] |  | Care Assistant | 44 |  |  | 3.75 |  | STK
 | [NAME] | 23065 | Care Assistant | 44 |  |  | 3.75 |  | STK
 | [NAME] |  | Care Assistant | 44 |  |  | 3.75 |  | STK
 | [NAME] |  | Care Assistant | 44 |  |  | 3.75 |  | STK
 | [NAME] |  | Care Assistant | 44 |  |  | 3.75 |  | STK
 | [NAME] | 22649 | Care Assistant | 44 |  |  | 3.75 |  | STK
 | Sarita Panwar |  | Care Assistant | 44 |  |  | 3.75 |  | STK
 | Sonet Antony |  | Care Assistant | 44 |  |  | 3.75 |  | STK
 | TOTAL
 |  |  |  |  |  | LESS Immigration cost
 |  |  |  |  |  | Total Savings
 | GMR | Hours | Hours | Hours | Hours | Hours | Hours | Hours | Hours | Hours | Hours
 | Month | 2022-04-01 00:00:00 | 2022-05-01 00:00:00 | 2022-06-01 00:00:00 | 2022-07-01 00:00:00 | 2022-08-01 00:00:00 | 2022-09-01 00:00:00 | 2022-10-01 00:00:00 | 2022-11-01 00:00:00 | 2022-12-01 00:00:00 | 2023-01-01 00:00:00
 | Agency Care - Regular | 3227.93 | 3130.5 | 3177.25 | 3234.75 | 3513 | 3735.25 | 3279.75 | 1934.5 | 720.5 | 468.5
Spreadsheet: 238968d1369772132-need-to-combine-rows-excel-sample
Sheet: Sheet1

BEFORE
PROD_NBR | OFFRNG_ENG_DESC | SumOfNET_QTY_SOLD | SumOfNET_SALES_AMOUNT | FISCAL_WK_NBR | FISCAL_YR | BUYER_NAM | BUS_CATEGORY_NAM | DIV_NAM | PRM_VNDR_NBR
0420340 | DT SHORE SM PLATTR | 6 | 119.94 | 1 | 2012 | NG, CONNIE | DINING AND ENTERTAINING | LIVING | 9614
0420340 | DT SHORE SM PLATTR | 8 | 159.92 | 2 | 2012 | NG, CONNIE | DINING AND ENTERTAINING | LIVING | 9614
0420340 | DT SHORE SM PLATTR | 7 | 129.93 | 3 | 2012 | NG, CONNIE | DINING AND ENTERTAINING | LIVING | 9614
0420340 | DT SHORE SM PLATTR | 6 | 101.94 | 4 | 2012 | NG, CONNIE | DINING AND ENTERTAINING | LIVING | 9614
0420340 | DT SHORE SM PLATTR | 10 | 199.9 | 5 | 2012 | NG, CONNIE | DINING AND ENTERTAINING | LIVING | 9614
0420369 | DT WOBBLE WINE GLASS | 1 | 4.99 | 1 | 2012 | NG, CONNIE | DINING AND ENTERTAINING | LIVING | 1585
0420369 | DT WOBBLE WINE GLASS | 1 | 6.94 | 4 | 2012 | NG, CONNIE | DINING AND ENTERTAINING | LIVING | 1585
0420369 | DT WOBBLE WINE GLASS | 1 | 4.88 | 8 | 2012 | NG, CONNIE | DINING AND ENTERTAINING | LIVING | 1585
0420369 | DT WOBBLE WINE GLASS | 1 | 6.93 | 9 | 2012 | NG, CONNIE | DINING AND ENTERTAINING | LIVING | 1585
0420369 | DT WOBBLE WINE GLASS | 1 | 6.93 | 11 | 2012 | NG, CONNIE | DINING AND ENTERTAINING | LIVING | 1585
0420369 | DT WOBBLE WINE GLASS | 1 | 4.88 | 12 | 2012 | NG, CONNIE | DINING AND ENTERTAINING | LIVING | 1585
0464512 | BLIND,DT 27X68 BEIGE | 9 | 351.48 | 11 | 2012 | KUPCHANKO, KATH | FLOOR & WINDOW DÉCOR | LIVING | 7038
0464512 | BLIND,DT 27X68 BEIGE | 9 | 331.11 | 12 | 2012 | KUPCHANKO, KATH | FLOOR & WINDOW DÉCOR | LIVING | 7038
0464512 | BLIND,DT 27X68 BEIGE | 14 | 515.06 | 13 | 2012 | KUPCHANKO, KATH | FLOOR & WINDOW DÉCOR | LIVING | 7038
0464513 | BLIND,DT 36X68 BEIGE | 2 | 95.98 | 1 | 2012 | KUPCHANKO, KATH | FLOOR & WINDOW DÉCOR | LIVING | 7038
0464513 | BLIND,DT 36X68 BEIGE | 7 | 307.93 | 2 | 2012 | KUPCHANKO, KATH | FLOOR & WINDOW DÉCOR | LIVING | 7038
0464513 | BLIND,DT 36X68 BEIGE | 1 | 43.99 | 3 | 2012 | KUPCHANKO, KATH | FLOOR & WINDOW DÉCOR | LIVING | 7038
AFTER
PROD_NBR | OFFRNG_ENG_DESC | SumOfNET_QTY_SOLD | SumOfNET_SALES_AMOUNT | FISCAL_WK_NBR | FISCAL_YR | BUYER_NAM | BUS_CATEGORY_NAM | DIV_NAM | PRM_VNDR_NBR
0420340 | DT SHORE SM PLATTR | 37 | 711.63 | 1 | 2012 | NG, CONNIE | DINING AND ENTERTAINING | LIVING | 9614
0420369 | DT WOBBLE WINE GLASS | 6 | 35.55 | 1 | 2012 | NG, CONNIE | DINING AND ENTERTAINING | LIVING | 1585
0464512 | BLIND,DT 27X68 BEIGE | 32 | 1197.65 | 11 | 2012 | KUPCHANKO, KATH | FLOOR & WINDOW DÉCOR | LIVING | 7038
0464513 | BLIND,DT 36X68 BEIGE | 10 | 447.9 | 3 | 2012 | KUPCHANKO, KATH | FLOOR & WINDOW DÉCOR | LIVING | 7038
Spreadsheet: 750536d1633510718-tracking-product-storage-with-multiple-criteria-example-workbook-included-storing-products-excel-help
Sheet: Storing

Date | Method | Product | Quantity | Location | Out of date
 | Storing | Apple |  | Shop1 | 2021-10-10 00:00:00
 | Storing | Apple |  | Shop2 | 2021-10-11 00:00:00
 | Storing | Pear |  | Shop1 | 2021-10-12 00:00:00
 |  |  |  |  | 2021-10-13 00:00:00
Spreadsheet: 691257d1597594210-rank-by-3-position-rank-by-3-criterias-copy
Sheet: Sheet3

 | student | test 1 | test 2 | test 3
 |  |  |  |  |  | Rank  test 1 | Rank  test 2 | Rank  test 3 |  | Final top 30 by  test 1, 2 and 3
1 | [NAME] | 2.14 | 2.53 | 145
2 | N.N. | 2.09 | 2.51 | 140
3 | P.I. | 2.18 | 2.4 | 145
4 | A.P. | 2.19 | 2.35 | 140
5 | C.G. | 2.23 | 2.45 | 140
6 | R.N. | 2.2 | 2.4 | 135
7 | B.G. | 2.11 | 2.3 | 130
8 | N.V. | 2.19 | 2.35 | 135
9 | A.C. | 2.19 | 2.4 | 135
10 | A.R. | 2.25 | 2.4 | 140
11 | V.V. | 2.21 | 2.4 | 130
12 | P.E. | 2.17 | 2.35 | 125
13 | S.V. | 2.31 | 2.35 | 140
14 | P.M. | 2.29 | 2.3 | 140
15 | [NAME] | 2.3 | 2.35 | 135
16 | T.C. | 2.2 | 2.2 | 135
17 | G.M. | 2.3 | 2.37 | 125
18 | S.I. | 2.27 | 2.2 | 135
19 | T.E. | 2.2 | 2.25 | 125
20 | C.J. | 2.21 | 2.35 | 115
21 | F.G. | 2.25 | 2.17 | 130
22 | M.V. | 2.29 | 2.3 | 125
23 | D.J. | 2.27 | 2.3 | 130
24 | D.E. | 2.31 | 2.34 | 120
25 | O.G. | 2.35 | 2.23 | 125
26 | E.I. | 2.37 | 2.15 | 130
27 | G.N. | 2.41 | 2.2 | 115
28 | I.D. | 2.35 | 2.15 | 105
29 | S.D. | 2.47 | 2.05 | 110
30 | B.I. | 2.29 | 2.05 | 110
Spreadsheet: 107648d1304781844-get-data-in-one-sheet-sample-sheet
Sheet: Leave Tracker

From | To | Request | My Id | Agent Id | Agent Name | Reason | Remarks | Days Applied
2011-05-01 00:00:00 | 2011-05-02 00:00:00 | Leave | 100 | 101 | abc | Exams | Please approve | 2
2011-05-06 00:00:00 | 2011-05-06 00:00:00 | Off | 100 | 102 | xyz | Exams | Please approve | 1
2011-05-11 00:00:00 | 2011-05-11 00:00:00 | Leave | 100 | 103 | Sharath | Exams | Please approve | 1
2011-05-16 00:00:00 | 2011-05-16 00:00:00 | Leave | 100 | 104 | Vinay | Exams | Please approve | 1
2011-05-21 00:00:00 | 2011-05-21 00:00:00 | Leave | 100 | 105 | [NAME] | Exams | Please approve | 1
2011-05-26 00:00:00 | 2011-05-26 00:00:00 | Leave | 100 | 106 | Shanta | Exams | Please approve | 1
2011-05-31 00:00:00 | 2011-05-31 00:00:00 | Leave | 100 | 107 | Rakesh | Exams | Please approve | 1
2011-05-05 00:00:00 | 2011-05-15 00:00:00 | Leave | 100 | 101 | abc | Exams | Please approve | 11
2011-06-10 00:00:00 | 2011-06-10 00:00:00 | Leave | 100 | 102 | xyz | Exams | Please approve | 1
2011-06-15 00:00:00 | 2011-06-15 00:00:00 | Leave | 100 | 110 | Avinash | Exams | Please approve | 1
Spreadsheet: 161404d1339512976-hardcoding-formulas-example
Sheet: Sheet1

Balance | 500000
CD Units lost during order setup | 2000
 |  | Target | Capacity | Schedule | Unused Capcity
 |  | 16225.11627906977 | 3
 |  | 17442 | 2
 |  | 16611.42857142857 | 4
 |  | 19340.3076923077 | 1
 |  | 16611.42857142857 | 4
 |  | 19340.3076923077 | 1
 |  | 19340.3076923077 | 1
 |  | 17442 | 2
 |  | 19340.3076923077 | 1
 |  | 19340.3076923077
Spreadsheet: 59532d1260073149-league-spreadsheet-709588-league-spreadsheet
Sheet: Schedule

Schedule | data entry | calculated
week | team no | team name | vs | team no | team name
1 | 4 | green |  | 1 | Blue
1 | 5 | purple |  | 2 | red
1 | 6 | orange |  | 3 | yellow
2 | 1 | Blue |  | 4 | green
2 | 2 | red |  | 5 | purple
2 | 3 | yellow |  | 6 | orange
3 | 2 | red |  | 5 | purple
3 | 3 | yellow |  | 6 | orange
3 | 4 | green |  | 1 | Blue
4 | 3 | yellow |  | 6 | orange
4 | 4 | green |  | 2 | red
4 | 5 | purple |  | 3 | yellow
Spreadsheet: 842597d1694619883-generate-random-number-for-work-from-home-wfh
Sheet: Sheet1

 |  | [NAME] | Betty | Michelle | JR | [NAME] | [NAME] | [NAME] | No of staff |  |  | [NAME] | Betty | Michelle | JR | [NAME] | [NAME] | [NAME]
 | Monday |  | x |  |  |  | x | x |  |  | Monday
 | Tuesday |  |  | x | x | x |  |  |  |  | Tuesday
 | Wednesday | x |  | x |  | x |  |  |  |  | Wednesday
 | Thursday |  | x |  |  |  | x | x |  |  | Thursday
 | Friday | x |  |  | x |  | x |  |  |  | Friday
 | To Office Count
 |  |  |  |  |  |  |  |  |  |  |  | * is there a formula to generate on a random basis?
 |  | *Everyday must have at least 3 staffs, can be more but cannot be less
 |  | *Each Staff to be in office at least 2 times per week. But can be more in the case of [NAME], if there is no choice
Spreadsheet: 36506d1234376140-sports-league-table-defining-positions-1st-2nd-etc-ranking
Sheet: Sheet1

Name | Total | Rank |  |  |  | Legend
[NAME] | 3 |  |  |  |  | 1 | st Place
Sandy | 12 |  |  |  |  | 2 | nd Place
Doug | 6 |  |  |  |  | 3 | rd Place
[NAME] | 11 |  |  |  |  | 4 | th Place
Betty | 15 |  |  |  |  | 21 | st Place
 |  |  |  |  |  | 22 | nd Place
 |  |  |  |  |  | 23 | rd Place
 |  |  |  |  |  | 24 | th Place
 |  |  |  |  |  | 31 | st Place
 |  |  |  |  |  | 32 | nd Place
 |  |  |  |  |  | 33 | rd Place
 |  |  |  |  |  | 34 | th Place
Spreadsheet: 22619d1211643504-couning-instances-in-non-contiguous-range-test-1
Sheet: Sheet1

 |  |  | [NAME] |  | Ella
 |  |  | Item 2 |  | Item 6
 |  |  | Item 3 |  | Item 1
 |  |  | Item 6 |  | Item 2
 |  |  | Item 1 |  | Item 4
 |  |  | Item 5 |  | Item 3
 |  |  | Item 4 |  | Item 5
 |  |  | [NAME] |  | [NAME]
 |  |  | Item 1 |  | Item 6
 |  |  | Item 2 |  | Item 5
 |  |  | Item 3 |  | Item 4
 |  |  | Item 4 |  | Item 3
 |  |  | Item 5 |  | Item 2
 |  |  | Item 6 |  | Item 1
 | 1 | 2 | 3 | 4 | 5 | 6
Item 1 | #N/A
Item 2
Item 3
Item 4
Item 5
Item 6
Spreadsheet: 79062d1279290743-delete-duplicate-add-values-in-cell-testingdraft
Sheet: Problem

Column 1 | Column 2 | Column 3 | Column 4 | Column 5
AA | test | 3 | music | 10 |  |  | Step 1: Copy>Paste Special> Values  Column G (over itself or into E)
AB | test | 5 | game | 10 |  |  | Step 2, Filter on "Delete" and delete those rows
AA | test | 3 | music | 7
AC | xbox | 2 | melody | 4
SE | bad | 5 | music | 6
WW | good | 5 | game | 8
SE | bad | 5 | music | 5
AB | high | 11 | video | 5
SE | bad | 5 | music | 8
Spreadsheet: 736152d1623375651-trimmean-if-trades-1-
Sheet: Sheet1

a | 1
a | 2
b | 1
c | 1
a | 3
a | 4
a | 5
a | 6
a | 7
a | 8
a | 9
a | 10
Spreadsheet: 47071d1245964558-sumif-multiple-worksheets-add-all-cells-adjacent-to-cell-w-value-matching-query-kor-cart-quotas
Sheet: RAH - CS-SPD OR BASIN

K-BRO LINEN SYSTEMS - EDMONTON  PLANT
CS/SPD OR BASIN
FACILITY: | ROYAL ALEXANDRA HOSPITAL
Date:
 | SUNDAY | MONDAY | TUESDAY | WEDNESDAY | THURSDAY | FRIDAY | SATURDAY | STATS
DELIVERY DAYS: | X | X | X | X | X | X |  | X
** If more/less linen required please fax in this order by 7:30 a.m. (FAX # (780) 451-5125)
[NAME] |  |  |  | PACK # |  | QUOTA | SHELF | REC | +/-/HOLD
20-WRAPPER 45" |  |  |  | BP0006 |  | 25
20-WRAPPER 54" |  |  |  | BP0007 |  | 20
20-HUCK TOWELS |  |  |  | BP0009 |  | 10
20-SURGICAL TWL |  |  |  | BP0027 |  | 3
UPDATED:
June 17th 2009
Spreadsheet: b7b07192-952a-43c7-b42f-cc16b71c70fa
Sheet: Sheet1

Marcellus acres within  each Type Curve | Unnamed: 1 | Unnamed: 2 | Unnamed: 3 | Unnamed: 4
Curve | Total PA Acres | Total WV Acres | Total Acres | # of Locations
9 | 112000 | 50000 | 162000 | 1330
7.4 | 90000 | 22000 | 112000 | 915
6.4 | 51000 | 207000 | 258000 | 2125
Total | 253000 | 279000 | 532000 | 4370
Marcellus Wet vs. Dry by Type Curve / State
Curve | Total Acres Wet | Total Acres Dry | Total Acres
9 | 25000 | 137000 | 162000
7.4 | 9000 | 102000 | 111000
6.4 | 156000 | 103000 | 259000
Total | 190000 | 342000 | 532000
Spreadsheet: 850830d1701177935-formulas-not-calculating-debt-payoff
Sheet: SSL

 | Credit Card Info
 | Current Balance | 5000
 | Interest Rate | 0.14
 | Interest-Only Payment | 58.33333333333334
 | A. Calculate Months to Payoff |  |  | Months | Payment | Interest
 | Monthly Payment | 250 |  | 12 | 448.9355880570676 | 387.227056684811
 | (Needs to be greater than the interest-only payment) |  |  | 18 | 309.5758701313707 | 572.3656623646721
 |  |  |  | 24 | 240.0644163419406 | 761.5459922065747
 | Months to Payoff | 22.90715181901191 | (1.91 years) | 30 | 198.491812829008 | 954.7543848702408
 | Total Interest | 726.7879547529783 |  | 36 | 170.8881487901281 | 1151.973356444611
 |  |  |  | 42 | 151.2662300048133 | 1353.181660202156
 | B. Calculate Monthly Payment |  |  | 54 | 125.3233871949682 | 1767.462908528281
 | Payoff Goal (Months) | 36 | (3 years) | 60 | 116.3412542469385 | 1980.475254816309
 | Monthly Payment | 170.8881487901281
 | Total Interest | 1151.973356444611
Spreadsheet: 470102d1468339853-copy-data-from-one-sheet-to-another-based-on-a-certain-criteria-book1
Sheet: Stafforce

AREA:- | Wrappers |  | WEEK COMMENCING |  |  |  |  |  |  |  | STAFF FORCE USE
HOURS WORKED
JW NO | NAME | SURNAME | SUN | MON | TUE | WED | THU | FRI | SAT | TOTAL
3096
Spreadsheet: 856245d1705567742-how-to-use-functions-to-lookup-and-sum-up-qty-filter-and-sum-2
Sheet: Planilha1

 |  | M 1.2024 | M 1.2024 | M 2.2024 | M 2.2024 | M 2.2024 | M 3.2024 | M 4.2024 | M 5.2024 | M 6.2024 |  |  |  | M 1.2024 | M 2.2024 | M 3.2024 | M 4.2024 | M 5.2024 | M 6.2024
А | 1 | 100 | 1 | 200 |  |  | 300 | 400 | 500 | 600 |  | А | 3
А | 2 | 700 | 7 | 800 |  |  | 900 | 1000 | 1100 | 1200
А | 3 | 1300 | 13 | 1400 |  |  | 1500 | 1600 | 1700 | 1800
А | 3 | 1900 | 19 | 2000 |  |  | 2100 | 2200 | 2300 | 2400
B | 1 | 2500 | 25 | 2600 |  |  | 2700 | 2800 | 2900 | 3000
B | 2 | 3100 | 31 | 3200 |  |  | 3300 | 3400 | 3500 | 3600
B | 3 | 3700 | 37 | 3800 |  |  | 3900 | 4000 | 4100 | 4200
Spreadsheet: 125911d1319376795-double-x-axis-two-x-axes
Sheet: Sheet1

Velocity (m/s) | Value | Velocity (mph) | [NAME]
1 | 5 | 0.447
2 | 7.071067811865476 | 0.894
3 | 8.660254037844386 | 1.341
4 | 10 | 1.788
5 | 11.18033988749895 | 2.235
6 | 12.24744871391589 | 2.682
7 | 13.22875655532295 | 3.129
8 | 14.14213562373095 | 3.576
9 | 15 | 4.023
10 | 15.8113883008419 | 4.47
11 | 16.583123951777 | 4.917
12 | 17.32050807568877 | 5.364
13 | 18.02775637731995 | 5.811
14 | 18.70828693386971 | 6.258
15 | 19.36491673103708 | 6.705
16 | 20 | 7.152
17 | 20.6155281280883 | 7.599
18 | 21.21320343559642 | 8.046
19 | 21.79449471770337 | 8.493
20 | 22.3606797749979 | 8.94
21 | 22.9128784747792 | 9.387
22 | 23.45207879911715 | 9.834
23 | 23.9791576165636 | 10.281
24 | 24.49489742783178 | 10.728
25 | 25 | 11.175
26 | 25.49509756796392 | 11.622
27 | 25.98076211353316 | 12.069
28 | 26.45751311064591 | 12.516
29 | 26.92582403567252 | 12.963
30 | 27.38612787525831 | 13.41
31 | 27.83882181415011 | 13.857
32 | 28.2842712474619 | 14.304
33 | 28.72281323269014 | 14.751
34 | 29.1547594742265 | 15.198
35 | 29.58039891549808 | 15.645
36 | 30 | 16.092
37 | 30.4138126514911 | 16.539
38 | 30.82207001484488 | 16.986
39 | 31.22498999199199 | 17.433
Spreadsheet: 807224d1669810067-transfer-of-data-from-a-master-sheet-to-other-sheets-major-last
Sheet: Chart of Accounts

 |  |  | Year
 | Chart Of Accounts |  | All
S. No | Account Name |  | 2023
 | Cash In Hand |  | 2024
 | Cash In Bank |  | 2025
 | Co-Operative Bank |  | 2026
 | Saleem |  | 2027
 | PK Stores |  | 2028
 | Cable TV |  | 2029
 | Falcon Tailors |  | 2030
 | Shafeeq |  | 2031
 | Misc Income |  | 2032
 | Rent Accrual |  | 2033
 | Interest Received |  | 2034
 | Current Liability
 | Acc.Payable
 | Owner Equity
 | Drawings
 | Rental Income
 | Expenses
 | Corp Tax
 | Utility
 | Management Fees
 | Sundry Expenses
 | Maintenanace
 | Misc & Sundry Exp
 | Bank Charges
 | Donation
Spreadsheet: 701270d1603676839-looking-for-a-formula-to-count-the-number-of-times-a-specific-value-appears-in-sequence-in-sample-5
Sheet: Master_Dont_Touch

Positive | Negative | False/Fail | 1 | Answer Im Looking for
 | 1 |  |  |  |  | I want to count the number of times Column B has a value, while ignoring the values in Column C , A value I Column A is what halts the sequence. AliGW was good enough to write the formula in yellow for me for a totally different application . I have been trying to get it to work hear with helper rows etc , but Im stuck Answers Im after are in Column E--Thanks in anticipation
1
 |  | 1
 |  | 1
 | 1
 | 1
 |  | 1
 | 1
 | 1
 | 1 |  |  |  | 5
 |  | 1
 |  | 1
 |  | 1
1
 | 1
 |  | 1
 | 1
 | 1 |  |  |  | 3
1
1
 | 1
 | 1
 | 1
 |  | 1
 | 1
 | 1
 | 1 |  |  |  | 6
Spreadsheet: 36032d1233772987-formula-to-calculate-totals-totals
Sheet: Sheet1

below is an example of what i am trying to achieve there are no fomulas because everyone i have tried doesnt seem to work.  The Balance i would like to automatically
populate when figures are entered in the 1st two colums
Hours Added | Hours deducted | BALANCE
6 |  | 6
4 |  | 10
 | 2 | 8
 | 3 | 5
4 |  | 9
 |  | 9
 |  | 9
 |  | 9
 |  | 9
 |  | 9
 |  | 9
 |  | 9
 |  | 9
 |  | 9
 |  | 9
 |  | 9
 |  | 9
 |  | 9
 |  | 9
 |  | 9
 |  | 9
 |  | 9
 |  | 9
 |  | 9
 |  | 9
 |  | 9
 |  | 9
Spreadsheet: 836750d1689613573-extract-row-based-on-criteria-in-column-j-extract
Sheet: Desired Ouput

Emp ID | Emailaddress | Employee Name | User's Country | Registration Date | Last Login | Course Name | Completion Status | Completion Date | Valid
 | [EMAIL] |  |  | 1 Jul 2023 at 13:15 | 2023-07-01 00:00:00 | CoC | Complete | 2023-07-01 00:00:00
68435554 | [EMAIL] |  |  | 28 Jun 2023 at 09:48 | 2023-06-28 00:00:00 | AB & C | Complete | 2023-06-28 00:00:00
85891970 | [EMAIL] |  |  | 9 Jan 2023 at 14:40 |  | CoC | Not yet started
68435554 | [EMAIL] |  |  | 9 Jan 2023 at 14:41 |  | PBP | Not yet started
95227794 | [EMAIL] |  |  | 9 Jan 2023 at 14:42 |  | PBP | Not yet started
Spreadsheet: 708569d1607933453-reference-cell-content-sample
Sheet: Sheet1

ID | unit cost | quantity | total | payed | Due
1 | 1 | 1 | 1 | 0.5 | 0.5
2 | 1 | 10 | 10 | 10 | 0
1 | 1 | 1 | 1 | 0.5 | IF( MATCH([@ID],A2:A3) > = 1)
Spreadsheet: 758644d1638979729-extracting-same-cell-data-from-multiple-worksheets-variation-tracker-rev-2-
Sheet: 40

NCE Reference:
Description of work | Test
Date:
QTY | Scope of Work Reference | Qty | Unit | Rate | Cost
 | STAFF
 | Staff Sub-Total | 0
 | Mark up Percentage | 0.16
 | Staff Total
 | LABOUR
 | Labour Sub-Total | 0
 | Mark up Percentage | 0.16
 | Labour Total
 | PLANT
 | Plant Sub-Total | 0
 | Mark up Percentage | 0.16
 | Plant Total
 | PERMANENT MATERIALS
 | Perm Materials Sub-Total | 0
 | Mark up Percentage | 0.16
 | Perm Materials Total
 | TEMPORARY MATERIALS
 | Temp Materials Sub-Total | 0
 | Mark up Percentage | 0.16
 | Temp Materials Total
 | SUBCONTRACTOR
 | [NAME] | 0
 | Mark up Percentage | 0.16
 | Subcontractor Total
 | OH/P
 | GRAND TOTAL
 | EOT |  |  | 0 | Days
Spreadsheet: 703882d1605206233-if-isnumber-search-and-or-with-extra-criteria-erf-log-projects
Sheet: Forecast

EQUALS FORMULA | Site [NAME] | Date (Estimate Complete) | SORT ALL FROM HERE Date  (Outage Start) | Notes | SN# or PO# or  WBS# | SO# (ZM02, ZM03) OR MHPS Standard Order
Spreadsheet: 120744d1315494824-projected-component-change-outs-budget
Sheet: 5362

5362 |  |  |  | Current Hours |  | Year
 |  |  |  |  |  | 2012 |  |  |  |  |  |  |  |  |  |  |  | 2013 |  |  |  |  |  |  |  |  |  |  |  | 2014 |  |  |  | 2015 |  |  |  | 2016
 |  |  |  |  |  | 744 | 696 | 744 | 720 | 744 | 720 | 744 | 744 | 720 | 744 | 720 | 744 | 744 | 672 | 744 | 720 | 744 | 720 | 744 | 744 | 720 | 744 | 720 | 744 | 2160 | 2184 | 2208 | 2208 | 2160 | 2184 | 2208 | 2208 | 2184 | 2184 | 2208 | 2208
 |  |  |  |  | Projected 2011 End | Jan | Feb | Mar | Apr | May | Jun | Jul | Aug | Sep | Oct | Nov | Dec | Jan | Feb | Mar | Apr | May | Jun | Jul | Aug | Sep | Oct | Nov | Dec | 1st | 2nd | 3rd | 4th | 1st | 2nd | 3rd | 4th | 1st | 2nd | 3rd | 4th
Projected Future Hours