tianzl66/Sheetpedia huggingface dataset:
Spreadsheet: 880063d1727702124-function-for-excluding-0-data-file
Sheet: Sheet1

 | quantity | need to get this data but exclude 0
A | 0
B | 0 |  |  |  |  |  | Percentile 1 | 0.15
C | 14.92537313432836 |  |  |  |  |  | Percentile 2 | 0.5
D | 0 |  |  |  |  |  | Percentile 3 | 0.85
A | 0 |  |  |  |  |  | Percentile 4 | 1
B | 38.80597014925373
C | 0
D | 1.492537313432836 |  | IF(C4<=PERCENTILE.INC(C$3:C$40,Բանաձևեր!$B$5),1,IF(C4<=PERCENTILE.INC($C$3:$C$40,Բանաձևեր!$B$6),2,IF(C4<PERCENTILE.INC($C$3:$C$40,Բանաձևեր!$B$7),3,4)))
A | 0
B | 32.83582089552239
C | 0
D | 0
A | 1.492537313432836
B | 0
C | 0
D | 1.492537313432836
A | 0
B | 1.492537313432836
C | 2.985074626865671
D | 0
A | 0
B | 0
C | 0
D | 0
A | 0
B | 0
C | 0
D | 2.985074626865671
A | 0
B | 0
C | 0
D | 0
A | 1.492537313432836
B | 0
C | 0
D | 0
A | 0
B | 0
Spreadsheet: 61701d1262634421-excel-2007-time-calculation-tidrapport
Sheet: Jan2010

United Parcel Service Sweden AB
Närvaro och övertidsrapport
 |  | Månad: |  |  | År:
Namn: | [NAME] |  |  | Personnr: | [PHONE]
Funktion: | Sorterare |  |  | Anst. Nummer:
Datum | [NAME] | [NAME] | [NAME] | Totala Timmar | OB | mertid | enkel        ö-tid | [NAME]
2010-01-01 00:00:00
 | 22:30:00 | 08:00:00 | 00:30:00
Total
Jag vill har min övertid i: |  |  |  | [NAME] |  | X | [NAME]
Signatur: _______________________________   Datum:_______________
[NAME]:________________________________________________
Enkel ö-tid: vardag fram till kl 20:00
Kval ö-tid: vardag från kl 20:00 till 06:00 och från fredag kl 20:00 till måndag kl 06:00
Spreadsheet: 862661d1710328076-formula-to-merge-data-table-data-table
Sheet: Data Table

 | A | B | C | D | E | F | G | H |  |  |  |  |  |  | A | B | C | D | E | F | G | H
1 | A1 | B1 |  | D1 | E1 |  |  |  |  |  |  |  |  | 1 |  | B1 | 0 | D1 | E1 | 0 | G3 | H3
2 |  |  |  | D2 | E2 |  |  |  |  |  |  |  |  | 2 | 0 | 0 | 0 | D2 | E2 | 0 | G4 | H4
1 |  |  |  |  |  |  | G3 | H3
2 |  |  |  |  |  |  | G4 | H4
Spreadsheet: daren_farmer__5743__Equistar Activity 2001
Sheet: FEB 01

 | EQUISTAR  ACTIVITY for February 2001 |  |  |  |  |  |  | file name: Equistar Activity 2001.xls
 | Effective 2/1/01
 |  |  |  |  | from | to
 | Meter # |  | Deal # | Price ($) | Volume |  | Matrix
 | 1062 |  | 378904 | Greater of $3.22 or Index - $.10 | 3000 |  | ENA |  | x
 | 1334
 | 1373 |  | 157572 | Greater of $2.23 or Index - $.05 | 10000 |  |  | ***** see below | 157572?
 | 1373 |  | 380735 | 4.35 or Index-$.10 |  |  | HPLC | expired
 | 1373 |  | 378904 | Greater of $3.22 or Index - $.10 | 2000 |  | ENA |  | x
 | 1373 |  | 165373 | Greater of $2.15 | 10000 |  | HPLC |  | x
 | 1373 |  | 128806 | Greater of $2.05 or Index - $.055 | 5000 |  | HPLC |  | x
 | 1373 |  | 202387 | $2.21 or Index -$.07 | 0 |  | HPLC
 | 1373 |  | 487588 | $2.68 or Index-$.10 | 0 |  | HPLC
 | 1373 |  | 394489 | Greater of $4.08 or Index - $.20 | 5000 |  | ENA |  | x
 | 1384 |  | 128806 | Greater of $2.05 or Index - $.055 | 0
 | 1384 |  | 240061 | $2.20 or Index -$.05 | 5000 |  | ENA |  | x
 | 1384 |  | 378904 | Greater of $3.22 or Index - $.10 | 0
 | 1384 |  | 394489 | Greater of $4.08 or Index - $.20 | 0 |  | ENA
 | 1399 |  | 165372 | $2.11or Index -$.07 | 5000 |  | HPLC |  | x
 | 1552 |  | 202387 | $2.21 or Index -$.07 | 5000 |  | ENA |  | x
 | 1552 |  | 487588 | $2.68 or Index-$.10 | 5000 |  | ENA |  | x
 | 1552 |  | 394489 | $4.08 or Index-$.20 | 5000 |  | ENA |  | x
 | 1553 |  | 378904 | $3.22 or Index-$.10 | 0 |  | ENA |  | x
 | 8024 |  | 240061 | $2.20 or Index -$.05 | 5000 |  | ENA |  | x
 | 1266/1165 |  |  |  |  |  | HPLC
 |  |  |  |  | Less: Phillips {1.500/d}, [NAME] {0.0/d}
 |  |  |  |  | Third Party ( Sempra; 0.0/d )
 | NOTE:  Highlighted rows mean changes. |  |  |  | Note:   Channel / Syngas :    = 15.0/d
 | ***** | new deal per Janice @ Equistar eff. 2/1/01.
Spreadsheet: 879083d1726518474-sumproduct-w-index-match-that-uses-indirect-breaks-with-sort-of-underlying-allocation-and-risk-data
Sheet: Current Model

Update Date: | 2024-04-01 00:00:00
 |  | Symbol | Aggressive | Mod. Agg. | Moderate | Mod. Cons. | Conservative
 |  | AAA | 0.4 | 0.5 | 0 | 0 | 0
 |  | ABC | 0.5 | 0 | 0 | 0 | 0.05
 |  | BBB | 0.1 | 0.5 | 0.3 | 0 | 0
 |  | CCC | 0 | 0 | 0.2 | 0.3 | 0.95
 |  | DDD | 0 | 0 | 0.5 | 0.7 | 0
Spreadsheet: b1fabf70-3aa6-4b6e-a22b-42b7a7ad0a9a
Sheet: Sheet1

PROG ID | ATHLETE ID | ATHLETE FIRST | ATHLETE LAST | NATIONALITY | START NUMBER | SNOWSHOE | T1 | SKATE | T2 | SKI | POSITION | TOTAL TIME
5427 | 9955 | [NAME] | Bethaz | ITA | 0 | 00:15:33 | 00:00:36 | 00:15:32 | 00:01:03 | 00:18:13 | 1 | 00:50:59
5427 | 10264 | Ivo | [NAME] | CZE | 116 | 00:16:24 | 00:00:43 | 00:15:41 | 00:01:02 | 00:17:55 | 2 | 00:51:44
5427 | 7722 | Philip E.c. | Schadler | LIE | 120 | 00:18:54 | 00:01:10 | 00:18:25 | 00:01:06 | 00:20:06 | 3 | 00:59:42
5427 | 14202 | [NAME] | Gudalov | RUS | 115 | 00:18:54 | 00:01:06 | 00:18:35 | 00:01:37 | 00:20:42 | 4 | 01:00:55
5427 | 39392 | Stephen | Gray | GBR | 117 | 00:19:16 | 00:01:03 | [NAME] | 00:02:09 | 00:36:07 | 5 | 01:18:12
Spreadsheet: 296801d1392199649-create-unique-list-from-data-ef574_example2
Sheet: Department Information

 | Department Name: Development | Applications & Development |  | Interview 1 date: enter date here |  |  | Interview 2 date: enter date here
 | User Surname | User First Name
 | Please insert additional rows in the above table as required
Spreadsheet: 118227d1313545131-tax-threshold-formula-payroll-tax-per-employee
Sheet: Sheet1

Payroll Tax Threshold | 678000
Payroll Tax | 0.0545
Workers Comp | 0.0025
Superannuation | 0.09
Emp | Base | Super | Gross | Payroll Tax | Workers Comp | Total
A | 150000
B | 145000
C | 120000
D | 140000
E | 150000
Total
Spreadsheet: 889527d1740384650-paste-values-where-is-blank-cells-paste-on-blank-cells-1-
Sheet: before

 |  |  |  |  | 1 |  |  | 7
 |  |  |  |  |  |  |  | 8
 |  |  |  |  | 3 |  |  | 9
 |  |  |  |  |  |  |  | 10
 |  |  |  |  |  |  |  | 11
 |  |  |  |  | 2 |  |  | 12
 |  |  |  |  |  |  |  | 13
 |  |  |  |  | 5 |  |  | 14
 |  |  |  |  | 6
 |  |  |  |  | 4
Spreadsheet: 785104d1656152523-skip-duplicate-to-unique-list-by-ordering-list-without-helper-column-skip-duplicate-to-unique-list-by-ordering
Sheet: Sheet1

 |  |  |  |  |  |  |  |  |  |  | skip duplicate to unique list by ordering without help column
 |  |  |  |  |  |  | data |  | incorrect |  | correct
 |  |  |  |  |  |  | 6 |  |  |  | 1
 |  |  |  |  |  |  | 5 |  |  |  | 2
 |  |  |  |  |  |  | 5 |  |  |  | 3
 |  |  |  |  |  |  | 1 |  |  |  | 4
 |  |  |  |  |  |  | 3 |  |  |  | 5
 |  |  |  |  |  |  | 2 |  |  |  | 6
 |  |  |  |  |  |  | 4
Spreadsheet: 165754d1341332738-excel-solver-entering-a-product-mix-constraint-from-a-percentage-product-mix-solver
Sheet: Sensitivity Report 1

Microsoft Excel 14.0 Sensitivity Report
Worksheet: [Assignment 2 - Solver.xlsx]Sheet1
Report Created: 7/3/2012 11:18:34 AM
Variable Cells
 |  |  | Final | Reduced
 | Cell | Name | Value | Gradient
 | $B$17 | Optimal Quantity iPods | 6.428571451379328 | 0
 | $C$17 | Optimal Quantity Cell Phones | 4.285714194482691 | 0
Constraints
 |  |  | Final | Lagrange
 | Cell | Name | Value | Multiplier
 | $B$21 | Floor Space Constraint iPods | 6.428571371551683 | 0
 | $B$22 | Marketing Constraint iPods | 6.428571451379328 | -38.92857001980353
 | $B$23 | Capital Constraint iPods | 1500 | 0.1464285629630398
 | $B$24 | Non zero constraint X iPods | 6.428571451379328 | 0
 | $B$25 | Non zero constraint Y iPods | 4.285714194482691 | 0
Spreadsheet: 76523d1277090153-excel-2007-using-if-function-for-increasing-a-count-example
Sheet: Sheet1

Section | Report Number
A | 1
A | 2
A | 3
A | 4
A | 5
B | 1
B | 2
B | 3
B | 4
B | 5
C | 1
C | 2
C | 3
C | 4
C | 5
B
Spreadsheet: 97497d1296660374-matching-and-conditional-referncing-calculation-excel-help
Sheet: WS-Sheet1

 |  |  | 2011 / 2012 | 2011-04-01 00:00:00 | 2012-03-31 00:00:00
Scheme name |  |  |  | <<PENTSO,WHITSO
Scheme Reference No. | <<PENTSO,WHITSO
Business Unit | FMO
Number of houses | x
Number of flats | 15
Total units | 15
Charges apply from | 2011-04-01 00:00:00
 |  | # OF UNITS
RPI inflation % to be applied to cost = RPI (Jan 2010) |  |  | 0.037
Audit Fee costs per fee quote (including VAT)= |  |  | ?????
Management fee per unit for flat |  |  | 100
Management fee per unit for shared ownership house |  |  | 120
Management fee per unit if EMA involved in managing estate |  |  | ?????
Insurance cost per unit |  |  | xxx
New Green - Cleaning | 165.08 |  | ????
 |  | CURRENT DATA |  | PAST DATA
 |  | Actual | Budget | Actual | Budget
 |  | Up to Date | 2011/ 2012 | 2009 / 2010 | 2010 / 2011
ESTATE COSTS
[NAME] | LTGM | 0 | 200 | 0 | 708
[NAME] | LTBH | 0 | 300 | 0 | 0
BULK REFUSE | LTBR | 0 | 450 | 54.34 | 0
REPAIRS | LTCA | 0 | 600 | 0 | 0
OTHER ESTATE SERVICES | LTOE | 0 | 200 | 0 | 0
MANAGEMENT FEE | LTMF | 0 | 120 | 2625 | 2625
AUDIT & ACCOUNTANCY FEE | LTAA | 0 | 320 | 220 | 219.96
BUILDING INSURANCE | LTPI | 0 | 125 | 900 | 900
EXTERNAL AGENT COSTS | [NAME] | 0 | 225 | 0 | 0
GROUND RENT | LTGR | 0 | 335 | 0 | 0
Spreadsheet: benjamin_rogers__1051__Consolidated 6 Peaker-051800
Sheet: IS

[NAME]
('000 $)
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 0
Revenue
Demand Payment
Energy Payment
Start Charge
Amortization of Power Contract
Merchant Period:
Demand Payment
Variable Revenue
Interest Income
Total Revenue
Expense
Fixed O&M
Variable O&M
Major [NAME]
Owner's Expense
Property Taxes
Franchise Tax
Total Expense
EBITDA
Depreciation & Amortization
EBIT
Interest Expense
EBT
Book State Tax Benefit / (Expense)
Shareholder Fed. Tax Benefit / (Expense)
Net Income
Spreadsheet: 545263d1509380779-using-data-in-a-linked-cell-from-combobox-combobox-test
Sheet: Sheet1

 | How do I get the linked A8 cell to be seen as a value
 |  |  |  |  |  |  |  | 1
 |  |  |  |  |  |  |  | 2
 |  |  |  |  |  |  |  | 3
 |  |  |  |  |  |  |  | 4
 |  |  |  |  |  |  |  | 5
7 |  |  |  |  |  |  |  | 6
2 | 2 |  |  |  |  |  |  | 7
1 | 1 |  |  |  |  |  |  | 8
 |  |  |  |  |  |  |  | 9
 |  |  |  |  |  |  |  | 10
Sum | Sum
Spreadsheet: 872985d1719426591-highlight-column-in-red-based-on-a-saturday-date-in-a-row-sample
Sheet: Sheet1

 | Date Started:
 | 100
 | 95
 | 90
 | 85
 | 80
 | 75
 | 70
 | 65
 | 60
 | 55
 | 50
 | 45
 | 40
 | 35
 | 30
 | 25
 | 20
 | 15
 | 10
 | 5
 | # Obs Day
 | Date:
Spreadsheet: 888507d1739018266-update-needed-to-formula-to-only-show-data-for-month-joshdog13-sample-sheet-copy-tms
Sheet: YTD Survey Data

Exclude Survey "Yes or No" | Notes from CM Review | [NAME] or Replaced | Roof Decision Correct? | Estimator | Claim # | Cat Code | [NAME] | Sub Peril | [NAME] | Zip Code | County | City | Survey Month Completed | CSAT Answer | Call back requested | Comments
No |  | N/A | N/A | [NAME] |  |  |  |  |  |  |  |  | 2025-01 | Somewhat satisfied |  |  |  |  | Yes |  | Replaced
No |  | N/A | N/A | [NAME] |  |  |  |  |  |  |  |  | 2025-01 | Extremely satisfied |  |  |  |  | No | Not Handled by Rep | Repaired
No |  | N/A | N/A | [NAME] |  |  |  |  |  |  |  |  | 2025-01 | Extremely satisfied |  |  |  |  | N/A | Proper [NAME], but insured not happy with settlement | N/A
No |  | Repaired | Yes | [NAME] |  |  |  |  |  |  |  |  | 2025-01 | Extremely dissatisfied |  |  |  |  |  | Result of DA handling
No |  | Repaired | Yes | [NAME] |  |  |  |  |  |  |  |  | 2025-01 | Extremely satisfied |  |  |  |  |  | Result of Supplement handling
No |  | Repaired | Yes | [NAME] |  |  |  |  |  |  |  |  | 2025-01 | Somewhat dissatisfied
No | ITEL repair report used | Repaired | Yes | [NAME] |  |  |  |  |  |  |  |  | 2025-01 | Somewhat dissatisfied
No |  | N/A | N/A | [NAME] |  |  |  |  |  |  |  |  | 2025-01 | Somewhat satisfied
No |  | N/A | N/A | [NAME] |  |  |  |  |  |  |  |  | 2025-01 | Extremely satisfied
Yes | Not Handled by Rep | N/A | N/A | [NAME] |  |  |  |  |  |  |  |  | 2025-01 | Somewhat dissatisfied
Yes | Not Handled by Rep | N/A | N/A | [NAME] |  |  |  |  |  |  |  |  | 2025-02 | Extremely dissatisfied
No |  | Repaired | Yes | [NAME] |  |  |  |  |  |  |  |  | 2025-02 | Extremely dissatisfied
No |  | Repaired | Yes | [NAME] |  |  |  |  |  |  |  |  | 2025-02 | Extremely dissatisfied
Spreadsheet: 795503d1662728311-formula-required-to-calculate-time-difference-between-total-hours-and-hours-worked-time-difference-between-total-hours-and-hours-worked
Sheet: Sheet1

Period | Total Hours | Worked Hours | Difference Formula Required in hh:[NAME]
2022-01-01 00:00:00 |  | 1 day, 21:18:00 | Col B - Col C
2022-02-01 00:00:00 |  | 4 days, 2:22:00 | Col B - Col C
2022-03-01 00:00:00 |  | 7 days, 2:03:00 | Col B - Col C
2022-04-01 00:00:00 |  | 6 days, 23:42:00 | Col B - Col C
2022-05-01 00:00:00 |  | 7 days, 9:02:00 | Col B - Col C
2022-06-01 00:00:00 |  | 8 days, 3:24:00 | Col B - Col C
2022-07-01 00:00:00 |  | 7 days, 4:52:00 | Col B - Col C
2022-08-01 00:00:00 |  | 8 days, 15:16:00 | Col B - Col C
Spreadsheet: 672757d1586987227-payroll-project-for-ytd-payrolefinal
Sheet: Joe's Vac & Sick

January | 8 |  | January | 8
February | 8 |  | February | 8
March | 8 |  | March | 8
April | 8 |  | April | 8
May | 8 |  | May | 8
June | 8 |  | June | 8
July | 8 |  | July | 8
August | 8 |  | August | 8
September | 8 |  | September | 8
October | 8 |  | October | 8
November | 8 |  | November | 8
December | 8 |  | December | 8
Spreadsheet: 327726d1403666205-help-with-sumif-s-and-dates-excel-forum-example
Sheet: Entry Sheet

Site # | Date | Refrigerant | Rack 1 | Rack 2 | Rack 3 | Rack 4 | Total
784 | 2013-07-11 00:00:00 | R404a | 18kgs |  | 18kgs | 18kgs
761 | 2013-07-25 00:00:00
285 | 2013-08-05 00:00:00
865 | 2013-08-08 00:00:00
7731 | 2013-08-08 00:00:00
678 | 2013-08-10 00:00:00
4512 | 2013-08-12 00:00:00
4556 | 2013-08-14 00:00:00
680 | 2013-08-19 00:00:00
667 | 2013-08-21 00:00:00
843 | 2013-08-26 00:00:00
4332 | 2013-08-26 00:00:00
7739 | 2013-08-28 00:00:00
8759 | 2013-08-29 00:00:00
8713 | 2013-09-05 00:00:00
289 | 2013-09-12 00:00:00
4674 | 2013-09-19 00:00:00
4525 | 2013-09-23 00:00:00
872 | 2013-10-03 00:00:00
4539 | 2013-10-03 00:00:00
4461 | 2013-10-17 00:00:00
772 | 2013-10-25 00:00:00
299 | 2013-10-28 00:00:00
306 | 2013-10-30 00:00:00
4540 | 2013-10-30 00:00:00
4537 | 2013-11-04 00:00:00
4508 | 2013-11-06 00:00:00
936 | 2013-11-14 00:00:00
4579 | 2013-11-20 00:00:00
293 | 2013-11-25 00:00:00
682 | 2013-11-25 00:00:00
903 | 2013-11-26 00:00:00
503 | 2013-11-28 00:00:00
760 | 2013-11-30 00:00:00
Spreadsheet: 675389d1588265676-if-formula-help-database_copy
Sheet: MICHIGAN 2020

 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | -
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | -
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | -
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | -
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | -
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | -
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | -
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | -
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | -
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | -
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | -
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | - | 100
Spreadsheet: 699762d1602755703-removing-duplicates-in-filter-list-containing-vlookup-formula-duplicates
Sheet: Sheet1

NAMES |  |  |  | S INDEX |  | FILTER LIST
[NAME] |  |  |  |  | [NAME] |  | [NAME]
[NAME] |  |  |  |  | [NAME]
[NAME] |  |  |  |  | [NAME]
[NAME] |  |  |  |  | [NAME]
[NAME] |  |  |  |  | [NAME]
[NAME] |  |  |  |  | [NAME]
Elijah |  |  |  |  | Elijah
Lucas |  |  |  |  | Lucas
Mason |  |  |  |  | Mason
Logan |  |  |  |  | Logan
[NAME] |  |  |  |  | [NAME]
[NAME] |  |  |  |  | [NAME]
[NAME] |  |  |  |  | [NAME]
[NAME] |  |  |  |  | [NAME]
[NAME] |  |  |  |  | [NAME]
[NAME] |  |  |  |  | [NAME]
[NAME] |  |  |  |  | [NAME]
[NAME] |  |  |  |  | [NAME]
Aiden |  |  |  |  | Aiden
[NAME] |  |  |  |  | [NAME]
[NAME] |  |  |  |  | [NAME]
[NAME] |  |  |  |  | [NAME]
[NAME] |  |  |  |  | [NAME]
[NAME] |  |  |  |  | [NAME]
[NAME] |  |  |  |  | [NAME]
[NAME] |  |  |  |  | [NAME]
[NAME] |  |  |  |  | [NAME]
[NAME] |  |  |  |  | [NAME]
[NAME] |  |  |  |  | [NAME]
Jayden |  |  |  |  | Jayden
[NAME] |  |  |  |  | [NAME]
[NAME] |  |  |  |  | [NAME]
[NAME] |  |  |  |  | [NAME]
[NAME] |  |  |  |  | [NAME]
[NAME] |  |  |  |  | [NAME]
Julian |  |  |  |  | Julian
Mateo |  |  |  |  | Mateo
[NAME] |  |  |  |  | [NAME]
Jaxon |  |  |  |  | Jaxon
Lincoln |  |  |  |  | Lincoln
[NAME] |  |  |  |  | [NAME]
[NAME] |  |  |  |  | [NAME]
[NAME] |  |  |  |  | [NAME]
Theodore |  |  |  |  | Theodore
Caleb |  |  |  |  | Caleb
[NAME] |  |  |  |  | [NAME]
Asher |  |  |  |  | Asher
Nathan |  |  |  |  | Nathan
[NAME] |  |  |  |  | [NAME]
Leo |  |  |  |  | Leo
[NAME] |  |  |  |  | [NAME]
[NAME] |  |  |  |  | [NAME]
Josiah |  |  |  |  | Josiah
0 |  |  |  |  | 0
Christian |  |  |  |  | Christian
[NAME] |  |  |  |  | [NAME]
Connor |  |  |  |  | Connor
Eli |  |  |  |  | Eli
[NAME] |  |  |  |  | [NAME]
[NAME] |  |  |  |  | [NAME]
Landon |  |  |  |  | Landon
Adrian |  |  |  |  | Adrian
[NAME] |  |  |  |  | [NAME]
Nolan |  |  |  |  | Nolan
Jeremiah |  |  |  |  | Jeremiah
Easton |  |  |  |  | Easton
Elias |  |  |  |  | Elias
Colton |  |  |  |  | Colton
Cameron |  |  |  |  | Cameron
[NAME] |  |  |  |  | [NAME]
[NAME] |  |  |  |  | [NAME]
[NAME] |  |  |  |  | [NAME]
Maverick |  |  |  |  | Maverick
[NAME] |  |  |  |  | [NAME]
Dominic |  |  |  |  | Dominic
Jaxson |  |  |  |  | Jaxson
Greyson |  |  |  |  | Greyson
Adam |  |  |  |  | Adam
Ian |  |  |  |  | Ian
[NAME] |  |  |  |  | [NAME]
0 |  |  |  |  | 0
Jordan |  |  |  |  | Jordan
Cooper |  |  |  |  | Cooper
Brayden |  |  |  |  | Brayden
Roman |  |  |  |  | Roman
Ezekiel |  |  |  |  | Ezekiel
Xavier |  |  |  |  | Xavier
Jace |  |  |  |  | Jace
Jameson |  |  |  |  | Jameson
[NAME] |  |  |  |  | [NAME]
Axel |  |  |  |  | Axel
[NAME] |  |  |  |  | [NAME]
Parker |  |  |  |  | Parker
Kayden |  |  |  |  | Kayden
[NAME] |  |  |  |  | [NAME]
Sawyer |  |  |  |  | Sawyer
. [NAME] |  |  |  |  | . [NAME]
[NAME] |  |  |  |  | [NAME]
Mason |  |  |  |  | Mason
[NAME] |  |  |  |  | [NAME]
[NAME] |  |  |  |  | [NAME]
[NAME] |  |  |  |  | [NAME]
[NAME] |  |  |  |  | [NAME]
[NAME] |  |  |  |  | [NAME]
[NAME] |  |  |  |  | [NAME]
Spreadsheet: 43561d1242209483-viewing-multiple-worksheets-on-one-main-worksheet-2009-10-calendar
Sheet: July C4U

[NAME]2009
Sunday |  | Monday |  | Tuesday |  | Wednesday |  | Thursday |  | Friday |  | Saturday
 |  |  |  |  |  | 2009-07-01 00:00:00 |  | 2009-07-02 00:00:00 |  | 2009-07-03 00:00:00 |  | 2009-07-04 00:00:00
2009-07-05 00:00:00 |  | 2009-07-06 00:00:00 |  | 2009-07-07 00:00:00 |  | 2009-07-08 00:00:00 |  | 2009-07-09 00:00:00 |  | 2009-07-10 00:00:00 |  | 2009-07-11 00:00:00
2009-07-12 00:00:00 |  | 2009-07-13 00:00:00 |  | 2009-07-14 00:00:00 |  | 2009-07-15 00:00:00 |  | 2009-07-16 00:00:00 |  | 2009-07-17 00:00:00 |  | 2009-07-18 00:00:00
2009-07-19 00:00:00 |  | 2009-07-20 00:00:00 |  | 2009-07-21 00:00:00 |  | 2009-07-22 00:00:00 |  | 2009-07-23 00:00:00 |  | 2009-07-24 00:00:00 |  | 2009-07-25 00:00:00
2009-07-26 00:00:00 |  | 2009-07-27 00:00:00 |  | 2009-07-28 00:00:00 |  | 2009-07-29 00:00:00 |  | 2009-07-30 00:00:00 |  | 2009-07-31 00:00:00
 |  |  |  |  |  |  |  |  |  | Notes:
Spreadsheet: 600331d1543601616-formula-to-create-table-or-list-based-on-team-members-sample
Sheet: Team

 |  | desired
 |  | [NAME] |  | 2018-11-26 00:00:00 | 2018-12-03 00:00:00 | 2018-12-10 00:00:00
 |  | write xmas cards |  | 2
 |  | write new years cards |  | 10 | 9
 |  | design paper |  | 3 | 6
 |  | envelope |  | 12 | 12
 |  | Lyn
 |  | write xmas cards |  |  | 1 | 2
 |  | design paper |  | 3 | 5
 |  | envelope |  | 4 | 2
Spreadsheet: 85684d1285749381-sum-values-with-multiple-criteria-xr_254
Sheet: Sheet4

west 1080feet
8000feet hight
Paid today 89.35 |  | Modified
150 cars |  | Modified
7192 atterbury |  | Modified
memphis,TN 38116 |  | Modified
200feet
qw678po
Spreadsheet: 4ac0f8fd-1af1-44f0-92eb-f1ecf6f5aef1
Sheet: Sheet1

ORGANIZATION_CODE | SASID | SCHOOL_CODE | STUDENT_FIRST_NAME | STUDENT_LAST_NAME | GENDER | BIRTH_DATE | ENTRY_DATE | GRADE_LEVEL | ENTRY_TYPE | EXIT_DATE | EXIT_TYPE | RETENTION_CODE | ATTENDANCE_INFO | JOINT_RESIDENT_COUNTY_CODE | DISTRICT_PARENT_RES | COUNTRY_PARENT_RES | STATE_PARENT_RES | PUBLIC_SCHOOL_FINANCE_STATUS | CONTRACT_THIRD_PARTY | CONTINUOUS_CO | TIME_IN_DISTRICT | TIME_IN_SCHOOL | [NAME] | PRIMARY_SCHOOL | INDEPENDENT_STUDY_FLAG | EXPELLED_FLAG | [NAME]
Spreadsheet: 15d026e7-cbe4-4c8b-b785-513b0853321f
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
CAT | Test | CAT | Cat Epithelium, IgE | Cat Epithelium, IgE | Fluorescence Enzyme Immunoassay (FEIA) | Serum Gel Tube: SGT |  |  | 0.5 | mL | Container/Tube:  Preferred: Red top Acceptable: Serum gel [NAME]: 0.5 mL for each 5 allergens requested Additional Information: Designate specific allergens from the list in Allergens-IgE Antibodies in Special Instructions. Forms: If not ordering electronically, submit an Allergen Request Form (Supply T236) with the specimen. | For 1 allergen: 0.3 mL/For more | Hemolysis	Mild OK; Gross OK Thawing	Warm reject; Cold OK Lipemia	Mild OK; [NAME] OK Icterus	NA Other	NA | Class	IgE kU/L	Interpretation 0	<0.35	Negative 1	0.35-0.69	Equivocal 2	0.70-3.49	Positive 3	3.50-17.4	Positive 4	17.5-49.9	Strongly positive 5	50.0-99.9	Strongly positive 6	> or =100	Strongly positive Reference values apply to all ages. | Monday through Friday; 9 a.m. - 8 p.m., Saturday; 8 a.m. - 3 p.m. | Same day/1 day | 3 days | 1 | 86003 |  |  |  |  | Rochester
CAT | [NAME] | SERUM | Serum |  |  |  | Refrigerated | 14 days
CAT | Result | CAT | Cat Epithelium, IgE | Cat Epithelium, IgE | Numeric |  |  |  |  | kU/L |  |  |  |  |  |  |  |  |  | 6833-8
Spreadsheet: 841495d1693670970-calculate-exchange-rate-for-shipments-example1-v6093486218-
Sheet: example

transfer date | Total TRY | Total USD after convercion | exchange rate | We convert liras into dollars, buy goods with dollars, then sell  purchased goods for liras. I need to calculate exchange rate for every shipment based on transfers exchange rate
2023-08-23 00:00:00 | 500000 | 18716
2023-09-12 00:00:00 | 500000 | 18620
2023-09-27 00:00:00 | 500000 | 19117
2023-10-15 00:00:00 | 500000 | 18560
2023-10-28 00:00:00 | 500000 | 18980
Purchase date | Order number | Order price total | Order exchange rate? | Is it possible to write a formula that will calculate "Order exchange rate" following description below?
2023-08-24 00:00:00 | 1 | 14550 | 26.72 | order was purchased with the money from the first transfer, so exhange rate is 26.72
2023-09-19 00:00:00 | 2 | 12600 | 26.81 | order was purchased with the money from the first and second transfer. First transfer remainder is 18 716 - 14 550 = 4 166usd. Second transfer part is 12 600 - 4 166 = 8 434usd. Exchange rate is ((4 166usd*26.72) + (8 434usd*26.85))/12 600usd = 26.81
2023-09-29 00:00:00 | 3 | 7400 | 26.85 | order was purchased with the money from the second transfer. Second transfer remainder is 18 620usd - 8 434usd = 10 186usd. Exchange rate is 26.85
2023-11-11 00:00:00 | 4 | 34800 | 26.5 | order was purchased with the money from the second, third and fourth transfer. Second transfer remainder is 10 186 - 7 400 = 2 786usd. Third transfer part is 19 117usd. Fourth transfer part is 34 800 - (2 786usd + 19 117usd) = 12 897usd. Exchange rate is ((2 786usd*26.85) + (19 117usd*26.15)+ (12 897usd*26.94))/34800usd = 26.50
2023-11-23 00:00:00 | 5 | 16700 |  | etc…
2023-12-02 00:00:00 | 6 | 4900