tianzl66/Sheetpedia huggingface dataset:
Spreadsheet: 818858d1677083765-loan-amortization-sheet-is-not-dynamic-problem-excel
Sheet: Assumptions

 |  | Assumptions
 |  | Year |  |  | Units
 |  |  |  | New Debt
 |  |  |  | Loan |  |  | Currency | Loan Amount | Loan Start Date | Tenor (months) | [NAME] period (every x months) | Principle Repayments | Principal repayment Start | [NAME] | Interest Rate (Annual) | Total Interest Payment | Interest Pay Period
 |  |  |  |  |  |  | EURO | 10000000 | 2023-06-30 00:00:00 | 24 | 3 |  |  |  | 0.1
 |  |  |  |  |  |  | USD | 10000000
Spreadsheet: 694031d1599310866-if-any-index-match-combination-contains-value-flag-2020-09-05-oeldere-jm45t3r5-694030d1599310136-if-any-index-match-combination-contains-value-
Sheet: Sheet2

 |  |  | Any contract not signed? |  | Should say…
 |  | Gucci |  |  | Fine
 |  | Patagonia |  |  | Check
 |  | Nike |  |  | Check
 |  | Adidas |  |  | Fine
 |  | Rijlabels | Count
 |  | Not Signed | 4
 |  | Nike | 1
 |  | Patagonia | 3
 |  | Signed | 16
 |  | Adidas | 5
 |  | Gucci | 4
 |  | Nike | 4
 |  | Patagonia | 2
 |  | (leeg) | 1
 |  | Eindtotaal | 20
Spreadsheet: 879073d1726507420-index-match-with-dynamic-range-dynamic-range-workbook
Sheet: TY SBCs

Column1 | Column2 | Column3 | Column4 | Column5 | Column6 | Column7 | Column8 | Column9 | Column10 | Column11 | Column12 |  |  |  | Current | Option 1
 | Current |  |  |  |  |  | Option 1
 | 1 |  | 2 |  | 3 |  | 1 |  | 2 |  | 3
Category | Fruit |  | Fruit |  | Fruit |  | Fruit |  | Fruit |  | Fruit
Name | Apple |  | [NAME] |  | Kiwi |  | Apple |  | [NAME] |  | Kiwi |  | Attribute | Sum
 |  |  |  |  |  |  |  |  |  |  |  |  | Current | 600
 |  |  |  |  |  |  |  |  |  |  |  |  | Option 1 | 630
Monthly cost Per fruit | 100 |  | 200 |  | 300 |  | 110 |  | 210 |  | 310
Spreadsheet: a5ec482d-9d5f-43c6-a626-7138bd139bd2
Sheet: 3PlansTiers

 | Insured HRA Quote for:
 | Current Plans
 |  | Status | # |  |  |  | # |  | # |  | Total
 |  | Employee
 |  | 2 Person
 |  | Emp/Child
 |  | Family
 | Renewal Plans
 |  | Status | # |  |  |  | # |  | # |  | Total
 |  | Employee
 |  | 2 Person
 |  | Emp/Child
 |  | Family
 | Proposed Plan 1: Annual Savings Versus Renewal PH HMO
 |  | Status | Census | Medical |  | Insured HRA 250 Ded 80% to $750 |  |  |  |  | Total
 |  | Employee |  | 247.46 |  | 137.81
 |  | 2 Person |  | 593.89 |  | 263.48
 |  | Emp/Child |  |  |  | 0
 |  | Family |  | 742.37 |  | 373.27
 |  |  |  |  |  | 4Kdd/10K
 |  | Status | # |  |  |  | Insured HRA |  |  |  | Total
 | 12 | Employee
 | 0 | 2 Person
 |  | Emp/Child
 | 1 | Family
 |  | Status | # |  |  |  |  |  |  |  | Total
 | 28 | Employee
 | 10 | 2 Person
 |  | Emp/Child
 | 30 | Family
 |  | Proposed Plan Totals
 |  | Status | # |  |  |  |  |  |  |  | Total
 | 28 | Employee
 | 10 | 2 Person
 |  | Emp/Child
 | 30 | Family
 |  |  |  |  |  |  |  |  |  | Plan Totals
 |  | Annual Savings Versus Renewal
 |  | Proposed Plan 2:  Annual Savings Versus Renewal
 |  | Proposed Plan 2:  Annual Savings Versus Renewal
Spreadsheet: 762570d1641639561-looking-for-a-term-that-will-encompass-a-range-of-entries-ermal-como-income-report
Sheet: dec 2022

interpreting / translation
Nr. | Donatori | half day | full day | hourly | pages | > 1 event | half day amount | full day amount | hourly amount | amount translation
1 | TAP |  |  |  | 12
2 | AADF |  |  |  | 12
3 | UNWOMEN |  |  |  | 12
4 | UNICEF |  |  |  | 12
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
32
33
34
35
36
37
38
39
40
Spreadsheet: 94884d1294656730-help-needed-agent-stats-tracker-teamstats
Sheet: KD

 |  | [NAME] | Packs Out | Collections | Packs Back | Col % 2 PB | FMP Out | FMP In | Calls Taken | Calls Out | Attendence
 | 2011-01-17 00:00:00 |  |  |  |  | 1
 | 2011-01-18 00:00:00 | 7.5 | 7 | 5 | 4 | 0.8 | 282
 | 2011-01-19 00:00:00 | 7.5 | 7 | 5 | 4 | 0.8 | 1000
 | 2011-01-20 00:00:00 | 7.5 | 7 | 4 | 4 | 1 | 664
 | 2011-01-21 00:00:00 | 7.5 | 5 | 3 | 3 | 1 | 995
 | Weekly Total | 37.5 | 33 | 21 | 19 | 0.9047619047619048 | 3391 | 0 | 0 | 0 | 0
 | 2011-01-24 00:00:00 |  | 7 | 4 | 4 | 1 | 450
 | 2011-01-25 00:00:00 |  | 7 | 5 | 4 | 0.8 | 282
 | 2011-01-26 00:00:00 |  | 7 | 5 | 4 | 0.8 | 1000
 | 2011-01-27 00:00:00 |  | 7 | 4 | 4 | 1 | 664
 | 2011-01-28 00:00:00 |  | 5 | 3 | 3 | 1 | 995
 | Weekly Total |  | 33 | 21 | 19 | 0.9047619047619048 | 3391 | 0 | 0 |  | 0
 | 2011-01-31 00:00:00 |  | 7 | 4 | 4 | 1 | 450
 | 2011-02-01 00:00:00 |  | 7 | 5 | 4 | 0.8 | 282
 | 2011-02-02 00:00:00 |  | 7 | 5 | 4 | 0.8 | 1000
 | 2011-02-03 00:00:00 |  | 7 | 4 | 4 | 1 | 664
 | 2011-02-04 00:00:00 |  | 5 | 3 | 3 | 1 | 995
 | Weekly Total |  | 33 | 21 | 19 | 0.9047619047619048 | 3391 | 0 | 0 |  | 0
 | 2011-02-07 00:00:00 |  | 7 | 4 | 4 | 1 | 450
 | 2011-02-08 00:00:00 |  | 7 | 5 | 4 | 0.8 | 282
 | 2011-02-09 00:00:00 |  | 7 | 5 | 4 | 0.8 | 1000
 | 2011-02-10 00:00:00 |  | 7 | 4 | 4 | 1 | 664
 | 2011-02-11 00:00:00 |  | 5 | 3 | 3 | 1 | 995
 | Weekly Total |  | 33 | 21 | 19 | 0.9047619047619048 | 3391 | 0 | 0 |  | 0
 | 2011-02-14 00:00:00 |  | 5 | 4 | 4 | 1
 | 2011-02-15 00:00:00 |  | 7 | 5 | 4 | 0.8
 | Weekly Total |  | 12 | 9 | 8 | 0.8888888888888888 | 0 | 0 | 0 |  | 0
 | Monthly Total |  | 144 | 93 | 84 | 0.9032258064516129 | 13564 | 0 | 0 |  | 0
Spreadsheet: 97344d1296571941-multiple-vlookup-copy-of-forumexample-1
Sheet: Sheet1

[NAME] | Count | Total Cost | Shipping | Packaging Cost | Pillow Cost | Total
Pillow Insert 20 x 20; 16x16 Pillow Form Insert PC | 2,1 | 34.48 | 8.95 | 0.8
20x20 Cluster Fiber Pillow Form Insert | 2 | 33.78 | 12.98 | 0.5
18x18 Synthetic Down Pillow Form Insert | 1 | 16.04 | 6.49 | 0.5
Pillow Insert 20 x 20 | 3 | 44.04 | 14.97 | 0.8
Pillow Insert 24 x 24 | 2 | 34.49 | 9.98 | 0.5
Spreadsheet: 271079d1381812570-help-need-a-formula-to-calculate-due-date-but-exclude-weekends-if-due-date-falls-on-it-due-date-sample
Sheet: Docket Tracking

Docket # | *226633*
Date | Sub-job # | Due Date | Special Instructions | Comments
ENTER DATE | *01* | DUE DATE Should Exclude holidays on Stat Holiday Tab and if it falls on a weekend (Sat or Sun) move to the next Business day | CYCLE CHANGES ETC.
2013-10-13 00:00:00 | *02* | 2013-10-13 00:00:00 | DUE Date should go to 10/15/2013 as 10/13 is a weekend and 10/14 is a stat holiday
2013-10-14 00:00:00 | *03* | 2013-10-14 00:00:00 | DUE Date should go to 10/15/2013 as 10/14 is a stat holiday
2013-10-15 00:00:00 | *04* | 2013-10-15 00:00:00 | Due date is ok
 | *05* | 1900-01-01 00:00:00
 | *06* | 1900-01-01 00:00:00
 | *07* | 1900-01-01 00:00:00
Spreadsheet: 768303d1644919509-print-clips-away-last-column-kopia-av-schema-mall-covid-team-2
Sheet: Helg

 | [NAME] |  |  |  |  | Helg |  |  |  |  |  | Carina och My  Ssk
 |  |  |  |  |  |  |  |  |  |  |  | [NAME] och Susanne Usk 6
 | Vecka |  | 6:45 - 15 |  |  | 8:30 - 15 |  | 14:30 - 21:30 |  |  | 21 - 07 |  |  |  | SSK | USK | [NAME] | Diff USK | SSK | USK
 |  | Tel: | SSK | Tel: | USK | SSK | USK | SSK | USK |  | SSK | USK |  | 6:45-15:00 | 13 | 8 |  |  | 14 | 9
 | DASSK / LARM 2 | 35100 | [NAME] |  |  |  |  | [NAME] |  | LARM 2  35905 | [NAME] |  |  | 8:30-15:00 | 1
 | SpotCheck | 33691 | [NAME] |  |  |  |  | [NAME] |  |  | [NAME] |  |  | 14:30-21:30 | 14 | 11 |  |  | 14 | 11
 | LARM TEAM 1 | 35901 | Ssk 3 | LARM1  35903 | Usk 1 |  |  | Ssk 3 | Usk 1 | LARM 1  35901 | Ssk 3 | LARM 1 - 35903 |  | 21:00-07:00 | 10 |  |  |  | 10 | 8
 |  | 35902 | [NAME] |  |  |  |  | [NAME] |  |  |  | Usk 1
 | Larm 2 | 35904 | Ssk 5 |  |  |  |  | Ssk 5 |  |  |  | LARM 2 - 35906 |  | inbokad
 | ÖRON | 35909 |  |  | Usk 2 |  |  | Ssk 13 | Usk 2 |  |  | Usk 2 |  | vakans
 |  | 33932 | Ssk 6 |  |  | ssk 13 |  | Ssk 6 | Usk 3 |  | [NAME] |  |  | sjuk
 | ÖVERVAK | 35054 | [NAME] |  | Usk 3 |  |  | [NAME] | Usk 4 |  |  | Usk 3 |  | extra personal
 | Larm 2 | 35905 | Ssk 8 |  |  |  |  | Ssk 8 |  |  | Ssk 5 |  |  | flytta ej
 | Team 2 - Isolering | 35060 | Ssk 9 |  | Usk 4 |  |  | Ssk 9 | Usk 5 |  | Ssk 6 | Usk 4 |  | observera
 | [NAME] | 35149
 | Team 3 - Linjelöst | 35070 | Ssk 10 | 35057 | Usk 5 |  |  | Ssk 10 | Usk 6 | LARM 2  35904 | [NAME] | Usk 5
 |  |  |  |  |  |  | Usk 6 |  | Usk 7 |  |  | Usk 6
 |  |  |  |  |  |  |  |  | Usk 8
 | Team 4 - Linjelöst | 35162 | [NAME] | LARM2  35906 | Usk 7 |  |  | [NAME] | Usk 9 | LARM 1  35902 | Ssk 8 | Usk 7
 | AOM | 35281 | Ssk 12 | 35283 | USK 8 |  |  | Ssk 12 | Usk 10 |  | Ssk 9 | USK 8
 | ANHÖRING LARM | 35908
 | TRAUMA USK | 35907
 | ODLINGSANSVARIG
 | Vita PCR | 31490
 | KAMRATSTÖDJARE | 35094
 | SERVICEMEDARBETARE | 32014
 | Övrig info:
Spreadsheet: 069f7f65-baa3-4566-a5d4-30679e57f34c
Sheet: 충청남도

사회서비스 제공기관 등록 현황 파악 양식 (행복e음 통해 등록완료 후 전송된 데이터 기준)
* 2012.8.5~2012.11.4 기간 동안 등록제로 등록 전송한 제공기관 현황
시도 | 사업구분 | 제공기관명 | [NAME] | 연락처 | 대표자(제공기관장)
충청남도 | 산모신생아 | (사)수정실버복지재단 예은재가노인복지센터 | 충청남도 금산군 금산읍 16 | [PHONE] | 정인성
충청남도 | 산모신생아 | 곰나루영농조합법인(곰나루재가노인복지센터) | 충청남도 공주시 정안면 111 | [PHONE] | 신홍현
충청남도 | 산모신생아 | [NAME] | 충청남도 논산시 취암동  1059-1 | [PHONE] | 박수정
충청남도 | 산모신생아 | 논산지역자활센터 | 충청남도 논산시 취암동 372-98 | [PHONE] | 최동식
충청남도 | 산모신생아 | 보령여성인력개발센터 | 충청남도 보령시 동대동 1687 영동빌딩 | [PHONE] | 김인자
충청남도 | 산모신생아 | 천안여성인력개발센터 | [NAME]410-4 | [PHONE] | 이정숙
충청남도 | 산모신생아 | 충남부여지역자활센터 | 충청남도 부여군 부여읍 동남리 | [PHONE] | [NAME]
충청남도 | 산모신생아 | 충남예산지역자활센터 | 충청남도 예산군 예산읍 산성리 340-3 | [PHONE] | [NAME]
충청남도 | 산모신생아 | 충남장애인부모회 금산지회 | 충청남도 금산군 [NAME] | [PHONE] | 국중영
충청남도 | 산모신생아 | [NAME] | 충청남도 홍성군 홍성읍 41-8 | [PHONE] | [NAME]
충청남도 | 산모신생아 | 해피케어 당진지점 | 충청남도 당진시 수청동 986번지 오션피스401 | [PHONE] | 김능연
충청남도 | 산모신생아 | 해피케어충남사업소 | 충청남도 천안시 서북구 두정동  1263(SKL빌딩 2층) | [PHONE] | 전미정
충청남도 | 산모신생아 | 해피케어홍성지점 | 충청남도 홍성군 홍성읍 오관리 366-9 대승빌딩 3층 | [PHONE] | 이정자
Spreadsheet: 477145d1472146395-formula-to-add-row-data-if-blank-then-data-from-different-sheet-with-reference-criteria-sumofthings
Sheet: Estimate Full Year

2016-06-01 00:00:00
 |  |  | Help Here
 |  |  | Completed + Plan2 | Plan | Historic | Var C+P2 vs. Plan | % | Var C+P2 vs. [NAME] | %
 |  | C Holcom
 |  | A Ivanson
 |  | B Risuto
 |  | M Franklin
Spreadsheet: matt_motley__26425__EMR Prices
Sheet: Sheet1

 |  | Peak |  | Off-Peak
Region | Delivery Date | Low | High | Low | High
Red numbers indicate flat, 24-hour products.
NW/N. Rockies | 2002-02-05 00:00:00 | 19 | 20.25 | 17.25 | 20
Mid-Columbia | 2002-02-05 00:00:00 | 19 | 20.25 | 17.25 | 20
COB | 2002-02-05 00:00:00 | 21.75 | 22.75 | 18 | 19.5
N. California | 2002-02-05 00:00:00 | 24 | 24.75 | 19.75 | 21
Midway/Sylmar | 2002-02-05 00:00:00 | NA | NA | NA | NA
S. California | 2002-02-05 00:00:00 | 24 | 26 | 18.5 | 21.25
Mead | 2002-02-05 00:00:00 | 23.5 | 25.25 | 18 | 20
Palo Verde | 2002-02-05 00:00:00 | 23 | 24.25 | 15 | 17.5
Inland SW | 2002-02-05 00:00:00 | 23 | 26 | 15 | 20
4-Corners | 2002-02-05 00:00:00 | 23.25 | 24 | 16 | 18.5
Central Rockies | 2002-02-05 00:00:00 | 19 | 23 | 14.5 | 17.25
Spreadsheet: 52717d1252545980-reading-last-non-blank-cell-in-each-row-at-3-column-steps-4david55
Sheet: Sheet1

name | address1 | address2 | [NAME] | date1 | [NAME] | date2 | amount3 | date3 | [NAME] | [NAME] |  | last amount | last date
Smith | A street | Aberystwyth | 12 | 2009-09-08 00:00:00 |  |  |  |  |  |  |  | 12 | 2009-09-08 00:00:00
Jones | B street | Caerdydd | 20 | 2009-09-01 00:00:00 | 55 | 2009-09-08 00:00:00 |  |  |  |  |  | 55 | 2009-09-08 00:00:00
Davies | C street | Llandudno | 30 | 2009-09-08 00:00:00 |  |  |  |  |  |  |  | 30 | 2009-09-08 00:00:00
Spreadsheet: 0081c4ff-12f8-4e46-a763-93e84f382ce3
Sheet: Appendix B

ACCOUNTING STRING
Balance Sheet elements required:
 | Fund - Balance sheet / Statement of Net Assets
 |  | Example: | 100 - 101
 |  |  | General Fund - Cash in Bank
Revenue elements required:
 | Fund - Project / Grant - Revenue
 |  | Example: | 280 - 709 - 4500
 |  |  | Federal Funds - Title II, Part A - Restricted Grants-in-aid from the federal
 |  |  | government through the state
Expenditure elements required:
 | Fund - Project / Grant - Program - Function - Object
 |  | Example: | 280 - 709 - 200 - 2213 - 331
 |  |  | Federal Funds - Title II, Part A - Special Programs - Instructional Staff Training -
 |  |  | Training and Development - Instructional Licensed Personnel
Required Accounting System String:
 | (Fiscal Year ) - Fund - Project / Grant - Revenue - Program - Function - Object -
 |  |  | School Code - Level of Instruction - Balance Sheet
 |  | Fund:  3 characters
 |  | Project/Grant:  3 characters
 |  | Revenue:   4 characters
 |  | Program:  3 characters
 |  | Function:  4 characters
 |  | Object:  3 characters
 |  | School Code:  5 characters (2 character district code plus 3 character school # or 000 for district wide)
 |  | Level of Instruction:  2 characters
 |  | Balance Sheet:  3 characters
 |  | Total:  30 characters
Spreadsheet: 716256d1612123466-have-a-text-value-with-sumifs-forum-excel-31-jan-2021
Sheet: Budget

 | Revenus annuels actuels - Dépenses annuelles actuelles
 | Revenu [NAME] annuelles budgetée
 | CATÉGORIE DE TOUS LES "REVENUS" |  |  |  |  |  |  | CATÉGORIE DE TOUTES LES "DÉPENSES"
 |  | Revenus net annuel actuel: |  |  |  |  |  |  | Dépenses annuelles actuelles:
 |  | Revenus net annuel budgeté: |  |  |  |  |  |  | Dépenses annuelles budgetées:
 | Revenu mensuel total |  |  |  |  |  |  | Dépense mensuelle totale
 |  | Montant budgeté | Montant actuel |  |  |  |  |  | Montant budgeté | Montant actuel
 | Source de revenu | Montant budgetée (Net par Mois) | Montant actuel ([NAME]) | Montant actuel ([NAME]) | % | % du Rev. global ([NAME]) |  | [NAME] | Montant budgetée ([NAME]) | Montant actuel ([NAME]) | Montant actuel ([NAME]) | % | % des Dép. Globales ([NAME])
 |  |  |  |  |  |  |  | Assurance auto | 36
 | Crédit Solidarité Qc |  |  |  |  |  |  | Assurance habitation | 17
 | Intérêt Banque |  |  |  |  |  |  | Divertissement | 50
 | Paye travail |  |  |  |  |  |  | [NAME]/chauffage
 | Paye vacance |  |  |  |  |  |  | Épicerie
 | Remb. Impot Canada |  |  |  |  |  |  | Essence
 | Remb. Impot Québec |  |  |  |  |  |  | Facture médicament
 | [NAME]. prêt fam./ami |  |  |  |  |  |  | Forfait cellulaire
 | Remb. TPS |  |  |  |  |  |  | Impôt retenu Canada
 | Retrait placement CÉLI |  |  |  |  |  |  | Impôt retenu Québec
 | Retrait placement REER |  |  |  |  |  |  | Internet
 |  |  |  |  |  |  |  | Logement
 |  |  |  |  |  |  |  | Paiement carte crédit
 |  |  |  |  |  |  |  | Permis conduire
 |  |  |  |  |  |  |  | Plaque immatriculation
 |  |  |  |  |  |  |  | Prêt famille/amis
 |  |  |  |  |  |  |  | Réparation / entretien auto
 |  |  |  |  |  |  |  | [NAME] (thérapeute divers)
 |  |  |  |  |  |  |  | Vacance/voyage
Spreadsheet: 33747d1230488859-replacing-missed-value-missedval
Sheet: Sheet1

COMPANY | OUTPUT | trial 1 | trial 2 | BVJ
2 | 4782.1 | 0 | 4782.1 | 4782.1
2 | 5905.2 | 0 | 5905.2 | 5905.2
2 | 5840.2 | 0 | 5840.2 | 5840.2
2 | 5229.2 | 0 | 5229.2 | 5229.2
2 | 6434.9 | 0 | 6434.9 | 6434.9
2 | 6864.5 | 0 | 6864.5 | 6864.5
3 | 664.9 | 0 | 664.9 | 664.9
3 | 80.2 | 0 | 80.2 | 80.2
3 | 79.3 | 0 | 79.3 | 79.3
3 | 77.3 | 0 | 77.3 | 77.3
3 | 0 | 78.55 | 78.55 | 78.55
3 | 79.8 | 0 | 79.8 | 79.8
7 | 38226.8 | 0 | 38226.8 | 38226.8
7 | 45926.2 | 0 | 45926.2 | 45926.2
7 | 46933.4 | 0 | 46933.4 | 46933.4
7 | 50078.8 | 0 | 50078.8 | 50078.8
7 | 58772 | 0 | 58772 | 58772
7 | 56489.6 | 0 | 56489.6 | 56489.6
9 | 0 | 2513.8 | 2513.8 | 29459.75
9 | 2429.9 | 0 | 2429.9 | 2429.9
9 | 2597.7 | 0 | 2597.7 | 2597.7
9 | 2655.6 | 0 | 2655.6 | 2655.6
9 | 2735.1 | 0 | 2735.1 | 2735.1
9 | 3300.7 | 0 | 3300.7 | 3300.7
10 | 0 | 3747.4 | 3747.4 | 3453.1
10 | 3605.5 | 0 | 3605.5 | 3605.5
10 | 3889.3 | 0 | 3889.3 | 3889.3
10 | 4232.1 | 0 | 4232.1 | 4232.1
10 | 3772.6 | 0 | 3772.6 | 3772.6
10 | 3705.1 | 0 | 3705.1 | 3705.1
13 | 2250.7 | 0 | 2250.7 | 2250.7
13 | 2474.5 | 0 | 2474.5 | 2474.5
13 | 2419.1 | 0 | 2419.1 | 2419.1
13 | 2118.8 | 0 | 2118.8 | 2118.8
13 | 0 | 2395.6 | 2395.6 | 2395.6
13 | 2672.4 | 0 | 2672.4 | 2672.4
27 | 862.2 | 0 | 862.2 | 862.2
27 | 958.6 | 0 | 958.6 | 958.6
27 | 910.7 | 0 | 910.7 | 910.7
27 | 858.3 | 0 | 858.3 | 858.3
27 | 845.5 | 0 | 845.5 | 845.5
27 | 885.2 | 0 | 885.2 | 885.2
30 | 1172.6 | 0 | 1172.6 | 1172.6
30 | 678.7 | 0 | 678.7 | 678.7
30 | 844.9 | 0 | 844.9 | 844.9
30 | 997.1 | 0 | 997.1 | 997.1
30 | 1060.4 | 0 | 1060.4 | 1060.4
30 | 0 | 0 | 0 | 530.2
Spreadsheet: 724175d1616050529-if-or-statement-not-working-correctly-selection-calculator
Sheet: Lists

 |  | Sensor 1 | Temperature | Relative Humidity | Both
 |  | Sensor 2 | Temperature | Moisture | Both
 |  | Sensor 3 | Temperature | Moisture | Both
 |  | Sensor 4 | Temperature | Moisture | Both
 |  | Sensor 5 | Temperature | Co2 | Both
 |  | Sensor 6 | Differential Pressure | N/A | Both
 |  | Sensor 7 | [NAME].
 |  | Sensor 8 | Temperature
 |  | Sensor 9 | Displacement
 |  | Sensor 10 | Displacement
 |  | Sensor 11 | Heat Flux
 |  | Sensor 12 | Heat Flux
Spreadsheet: 774316d1648389673-sum-large-help-example
Sheet: Points

Season Start Date
2022-01-07 00:00:00
Names | Best 20 Points | Total Season Points | 2022-01-07 00:00:00
My Sum No Error |  |  | 10 | 10 | 10 | 10 | 10 | 10 | 10 | 10 | 10 | 10 | 10 | 10 | 10 | 10 | 10 | 10 | 10 | 10 | 10 | 10 | 10 | 10 | 10 | 10 | 10
Error cus of not 20 values |  |  | 10 | 10 | 10
If [NAME] tried |  |  | 10 | 10 | 10 | 10 | 10 | 10 | 10 | 10 | 10 | 10 | 10 | 10 | 10 | 10 | 10 | 10 | 10 | 10 | 10 | 10 | 10 | 10 | 10 | 10 | 10
If Error Shortened |  |  | 10 | 10 |  |  |  |  |  | 10 | 10 | 10 | 10 | 10 | 10 | 10 | 10 | 10
Spreadsheet: 815200d1674813521-i-need-a-formula-to-copy-a-cell-from-a-specific-column-range-of-values-when-4-other-cond-exemple
Sheet: Add RET

Input | Sector X |  |  |  | Sector Y |  |  |  | Sector Z |  |  |  |  | 24 | 30 | 36
Cabinet No. | 0 |  |  |  | 0 |  |  |  | 0 |  |  |  |  | 25 | 31 | 37
Subrack No. | 4 |  |  |  | 4 |  |  |  | 4 |  |  |  |  | 26 | 32 | 38
Slot No. | 1 |  |  |  | 3 |  |  |  | 5 |  |  |  |  | 27 | 33 | 39
Serial No.&Name 1 | R1 |  | G9 |  | R1 |  | G9 |  | R1 |  | G9 |  |  | 28 | 34 | 40
Serial No.&Name 2 | R2 |  | L8 |  | R2 |  | L8 |  | R2 |  | L8 |  |  | 29 | 35 | 41
Serial No.&Name 3 | Y1 |  | [NAME] |  | Y1 |  | [NAME] |  | Y1 |  | [NAME]
Serial No.&Name 4 | Y2 |  | L18 |  | Y2 |  | L18 |  | Y2 |  | L18
Serial No.&Name 5 | Y3 |  | [NAME] |  | Y3 |  | [NAME] |  | Y3 |  | [NAME]
Serial No.&Name 6 | Y4 |  | L26 |  | Y4 |  | L26 |  | Y4 |  | L26
Vendor Code | HW |  |  |  | HW |  |  |  | HW
 |  | SINGLE_RET
??? ---> to find Vendor Code in sheet SCN ALD when other conditions are met
ADD RET
Sector 1 & Dev No.
Sector 2 & Dev No.
Sector 3 & Dev No.
MOD RETSUBUNIT
Sector 1 SubUnit |  |  |  | `
50
50
50
80
80
80
Sector 2 SubUnit
50
50
50
0
25
45
Sector 3 SubUnit
50
50
50
100
25
45
Spreadsheet: 239814d1370019434-income-expenses-tracking-issue-expenses-breakdown-template
Sheet: Expenses - KY (2)

 |  |  |  |  | Expenses |  |  |  | [NAME] :
 |  |  |  |  |  |  |  |  | Claim Ref No.   :
 |  |  |  |  |  |  |  |  |  | [42]
 | Item No. | DATE | [NAME] |  | Food | Travel | Stationary | Repayments | Other | TOTAL | Receipts
 |  | TOTALS
 |  | * Don't forget to attach receipts * |  |  |  |  |  | SUBTOTAL
 |  |  |  |  |  |  |  | TOTAL REIMBURSEMENT
 |  |  | IBRAHIM |  |  | 2013-04-17 00:00:00
 |  |  | Checked By |  |  | Date
Spreadsheet: 231175d1366972168-data-extract-data
Sheet: Data Base

Cost Centre | GL Code | Title | Amount
11 | 6510 | A | 10000
22 | 6520 | B | 20000
33 | 6530 | C | 30000
44 | 6540 | D | 40000
11 | 6510 | A | 50000
11 | 6510 | A | 25000
11 | 6510 | A | 10000
22 | 6520 | B | 20000
22 | 6511 | B | 30000
11 | 6522 | A | 40000
11 | 6511 | A | 50000
11 | 6522 | A | 30000
11 | 6533 | A | 25000
Spreadsheet: 884477d1733665634-unable-to-get-the-desired-result-with-sumproduct-formulae-sample-
Sheet: Sheet1

 | DATA
 | Order Type | Billed Amt | Month | Date | 1st Advance | Month | Date | 2nd Advance | Total Advance | Month | Date | Delivery | Balance
 | KHI 1 | 123000 |  | 2024-07-30 00:00:00 | 40000 |  |  | 0 |  |  | 2024-09-05 00:00:00 | 83000
 | KHI 2 | 152000 |  | 2024-07-01 00:00:00 | 40000 |  | 2024-07-10 00:00:00 | 50000
 | KHI 3 | 100000 |  | 2024-08-01 00:00:00 | 50000 |  | 2024-08-01 00:00:00 | 20000 |  |  | 2024-08-25 00:00:00 | 30000
 | KHI 4 | 80000 |  | 2024-08-25 00:00:00 | 40000 |  | 00:00:00 | 0 |  |  | 2024-10-10 00:00:00 | 40000
 | KHI 5
 | KHI 6
 |  | OUTPUT RESULT WANTED
 |  | 2024-07-01 00:00:00 | 2024-08-01 00:00:00 | 2024-09-01 00:00:00 | 2024-10-01 00:00:00 | 2024-11-01 00:00:00 | 2024-12-01 00:00:00 | 2025-01-01 00:00:00 | 2025-02-01 00:00:00 | 2025-03-01 00:00:00 | 2025-04-01 00:00:00 | 2025-05-01 00:00:00 | 2025-06-01 00:00:00
 | Advance From Customers
 |  | Need to sum up only column F & Column I that is 1st Advance and 2nd Advance along with below criteria
 |  | Criteria   = | We will not sum up if the month of Column K is same as given in row number 17 for which we will be doing sum up
 |  | When the goods is delivered we insert date in column L and month is calcualted in column k. so suppose if we are summing up all the records at E16 for the month of Sep-2024 then we will
 |  | sum up of all the previous months too  where the month in column k is not matching with July-2024, Aug-2024 & Sep-2024
 | NOTES For Each Month
 | 1 | W will only sum up for the month of Jul-24 since the month of column K is Sep-2024 whis is not same as in C17
 | 2 | W will only sum up for the month of Aug-2024 for only row no. 7 , 8 & 10 and will not sum up of row number 9 since row number 9 has the same month of Aug-2024 in column K as in D17
 | 3 | W will only sum up for the month of Sep-2024 of row [NAME] and row no.10 and will not sum up row no. 7 here since it has the same month of Sep-2024 in Column K as in E17
Spreadsheet: 223789d1364318208-updating-worksheets-from-week-to-week-status-rollover
Sheet: 2

PO Number | PO Item | PO [NAME] | Part Number | PO-Line-Sched | PO [NAME] | All Planning Programming Tooling Complete _ Either  Yes  or Provide Est Completion Date _ mmddyyyy | All Required Material in Plant to include [NAME]_ Hardware_ Sealants_ etc   Either  Yes or Provide Est Latest Matl Availability Date _ mmddyyyy | Current Manufacturing Stage _ Not Started_ Staged_ Fabrication_ Processing_ Assembly_ Inspection_ Shipping | Actual Qty to be Delivered | New On-Dock Commitment Date _  mmddyyyy | [NAME] _ie _ ESPAR Number Submitted on mmddyyyy _ ESQAR Number Submitted mmddyyyy_ Missing Material Specifics_ etc
[PHONE] | 10 | 1 | 3319710-1 |  | 1
[PHONE] | 10 | 1 | 398822-1 |  | 1 | 08/31/2012 | 09/15/2012 | Not Started | 1 | 12/20/2012 | Vendor will try to improve once material is received.
[PHONE] | 10 | 1 | 358995-1 |  | 2
M5343428 | 22 | 3 | 355920-17 |  | 23
M5343215 | 22 | 1 | 3314789-1 |  | 5
[PHONE] | 40 | 4 | 354122-12 |  | 1000
M5343451 | 21 | 2 | 3314789-1 |  | 38
[PHONE] | 10 | 1 | 355920-19 |  | 17
[PHONE] | 10 | 2 | 389438-3 |  | 24
[PHONE] | 20 | 1 | 357918-5 |  | 2
M5343503 | 11 | 4 | 337925-3R |  | 12
[PHONE] | 10 | 1 | 343078 |  | 36
[PHONE] | 10 | 1 | 355920-19 |  | 1
[PHONE] | 10 | 8 | 756021-1 |  | 276
[PHONE] | 10 | 4 | 756021-1 |  | 138
[PHONE] | 10 | 5 | 756021-1 |  | 184
[PHONE] | 10 | 6 | 756021-1 |  | 184
[PHONE] | 10 | 9 | 756021-1 |  | 230
[PHONE] | 10 | 1 | 756021-1 |  | 290
[PHONE] | 10 | 2 | 756021-1 |  | 138
[PHONE] | 10 | 3 | 756021-1 |  | 92
[PHONE] | 10 | 7 | 756021-1 |  | 184
[PHONE] | 20 | 1 | 756021-7 |  | 3
[PHONE] | 10 | 2 | 360622-25 |  | 24
[PHONE] | 10 | 1 | 360622-25 |  | 21
[PHONE] | 10 | 3 | 360622-25 |  | 16
[PHONE] | 20 | 1 | 337925-3R |  | 8
[PHONE] | 10 | 2 | 337925-3L |  | 40
[PHONE] | 10 | 2 | 337925-3R |  | 36
[PHONE] | 10 | 2 | 382195-1 |  | 11
[PHONE] | 10 | 3 | 382195-1 |  | 10
[PHONE] | 10 | 4 | 382195-1 |  | 5
[PHONE] | 10 | 5 | 382195-1 |  | 7
M5343242 | 12 | 3 | 3328543-13 |  | 35
[PHONE] | 10 | 1 | 339837-21 |  | 24
M7150029 | 21 | 2 | 371644-4 |  | 12
M7150029 | 31 | 3 | 371644-4 |  | 3
[PHONE] | 10 | 1 | 339697-5 |  | 7
[PHONE] | 40 | 3 | 354122-12 |  | 1250
[PHONE] | 10 | 1 | 382632-1 |  | 16
[PHONE] | 10 | 3 | 337925-3L |  | 4
[PHONE] | 10 | 4 | 337925-3L |  | 4
[PHONE] | 10 | 1 | 337925-3L |  | 5
[PHONE] | 10 | 2 | 337925-3L |  | 2
[PHONE] | 10 | 5 | 337925-3L |  | 4
[PHONE] | 10 | 6 | 337925-3L |  | 4
[PHONE] | 20 | 6 | 337925-3R |  | 4
[PHONE] | 20 | 1 | 337925-3R |  | 6
[PHONE] | 20 | 2 | 337925-3R |  | 2