tianzl66/Sheetpedia huggingface dataset:
Spreadsheet: 192043d1352296564-time-calculation-time-calculation
Sheet: November

 |  |  |  |  |  |  |  |  | Name of the Driver:
OVERTIME AND OTHER ALLOWANCE CALCULATION |  |  |  |  |  |  |  |  |  |  | Month | 2012-11-01 00:00:00 |  |  |  | Year: |  | 2012
REGULAR WORKING HOURS |  |  |  |  | Between | 08:30:00 | And | 17:00:00
Date | TIME |  | USE |  | Overtime minimum unit 1 hour | WE/ Holiday Duty | Lunch |  |  | Dinner |  |  | Breakfast |  |  | Night hold
 | START | STOP |  |  |  |  | [NAME] | District | Dhaka | [NAME] | District | Dhaka | [NAME] | District | Dhaka | [NAME] | District | Dhaka
2012-11-01 00:00:00 | 06:30:00 | 19:30:00 | AD |  | 04:00:00
2012-11-02 00:00:00
2012-11-03 00:00:00
2012-11-04 00:00:00
2012-11-05 00:00:00
2012-11-06 00:00:00
2012-11-07 00:00:00 | 10:30:00 | 02:30:00 |  |  | 1900-01-01 00:00:00
2012-11-08 00:00:00
2012-11-09 00:00:00
2012-11-10 00:00:00
2012-11-11 00:00:00
2012-11-12 00:00:00
2012-11-13 00:00:00
2012-11-14 00:00:00
2012-11-15 00:00:00
2012-11-16 00:00:00
2012-11-17 00:00:00
2012-11-18 00:00:00
2012-11-19 00:00:00
2012-11-20 00:00:00
2012-11-21 00:00:00
2012-11-22 00:00:00
2012-11-23 00:00:00
2012-11-24 00:00:00
2012-11-25 00:00:00
2012-11-26 00:00:00
2012-11-27 00:00:00
2012-11-28 00:00:00
2012-11-29 00:00:00
2012-11-30 00:00:00
2012-12-01 00:00:00
Total Unit |  |  |  |  | 4 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0
Taka/ Unit |  |  |  |  | 75.63 | 408 | 45 | 50 | 70 | 45 | 50 | 70 | 20 | 25 | 30 | 150 | 250 | 500
 |  |  |  |  | 33 |  |  |  |  | B5.2.1.0.3 |  |  | B3.7 |  |  | TOTAL
PAYMENT |  |  |  |  |  |  |  |  |  | 303 |  |  | 0 |  |  | 303
Note: | AD = [NAME] trips e.g., Bank, Meetings, Visit other organizations etc.,… |  |  |  |  |  |  |  |  |  | PC = Purchase trips any where.
 | FI = Clinic visits/ Clinic visit with supply. |  |  |  |  |  |  |  |  |  | PR = Private use
 | HP = Investigations, consultations, other hospital. |  |  |  |  |  |  |  |  |  | DR = Only drug and logistic supply to clinics
 | DB = Dead body carrying
Prepared by: |  |  |  |  | Check & Approved by: |  |  |  |  |  |  |  |  |  |  |  |  | Received by:
Spreadsheet: 845472d1696969492-problem-with-league-table-golfscoresmultiplayerlive
Sheet: Handicaps

 |  |  | 2023-12-04 00:00:00 | 2024-01-08 00:00:00 | 2024-02-05 00:00:00 | 2024-03-04 00:00:00 | 2024-04-08 00:00:00 | 2024-05-06 00:00:00 | 2024-06-03 00:00:00
Team/Hcap | StartHcp
Team1
Player1 | 12
Player2 | 17
Player3 | 16
Player4 | 17
Team2
Player5 | 10
Player6 | 15
Player7 | 19
Player8 | 22
Team3
Player9 | 15
Player10 | 20
Player11 | 25
Player12 | 28
Team4
Player13 | 13
Player14 | 19
Player15 | 21
Player16 | 22
Team5
Player17 | 12
Player18 | 14
Player19 | 19
Player20 | 23
Team6
Player21 | 17
Player22 | 19
Player23 | 22
Player24 | 25
Team7
Player22 | 10
Player23 | 16
Player24 | 22
Player25 | 25
Spreadsheet: darrell_schoolcraft__7812__Southpoint Gas Model
Sheet: Sheet1

Southpoint |  |  | Transwestern's 24 hr Gas Control [PHONE]
 |  |  | Gas Nomination for 1st = 65000
 |  |  | SoCal Gas Price |  | 2.155
 |  |  | San Juan Gas Price |  | 1.91
 |  |  | Unit 1 | Unit 2 | Steam TurB | Total MW | HR | Total Gas Usage
he 6 | 07:00:00 |  | 0 | 0 | 0 | 416 | 7
he 7 | 08:00:00 |  | 0 | 0 | 0 | 495 | 7
he8 | 09:00:00 |  | 0 | 0 | 0 | 495 | 7
he9 | 10:00:00 |  | 0 | 0 | 0 | 495 | 7
he10 | 11:00:00 |  | 0 | 0 | 0 | 495 | 7
he11 | 12:00:00 |  | 0 | 0 | 0 | 495 | 7
he12 | 13:00:00 |  | 0 | 0 | 0 | 495 | 7
[NAME] | 14:00:00 |  | 0 | 0 | 0 | 495 | 7
he14 | 15:00:00 |  | 0 | 0 | 0 | 495 | 7
he15 | 16:00:00 |  | 0 | 0 | 0 | 495 | 7
he16 | 17:00:00 |  | 0 | 0 | 0 | 495 | 7
he17 | 18:00:00 |  | 0 | 0 | 0 | 495 | 7
he18 | 19:00:00 |  | 0 | 0 | 0 | 495 | 7
he19 | 20:00:00 |  | 0 | 0 | 0 | 495 | 7
he20 | 21:00:00 |  | 0 | 0 | 0 | 495 | 7
he21 | 22:00:00 |  | 0 | 0 | 0 | 495 | 7
he22 | 00:00:00 |  | 0 | 0 | 0 | 495 | 7
he23 | 01:00:00 |  | 0 | 0 | 0 | 416 | 7
he24 | 02:00:00 |  | 0 | 0 | 0 | 416 | 7
he1 | 03:00:00 |  | 0 | 0 | 0 | 470 | 7
he2 | 04:00:00 |  | 0 | 0 | 0 | 470 | 7
he3 | 05:00:00 |  | 0 | 0 | 0 | 470 | 7
he4 | 06:00:00 |  | 0 | 0 | 0 | 470 | 7
[NAME] | 07:00:00 |  | 0 | 0 | 0 | 470 | 7
Spreadsheet: 857079d1706156978-calculate-number-from-multiple-columns-book1
Sheet: Sheet1

Quantity in Stock | Reorder Level | Quantity to Reorder | Taken
8 | 12 |  | 4
7 | 12 |  | 5
8 | 12 |  | 5
6 | 12 |  | 6
Spreadsheet: 192851d1352587500-how-to-make-multiple-references-from-one-worksheet-to-another-easily-snack-calendar-gen
Sheet: October

October 2012
Sunday | Monday | Tuesday | Wednesday | Thursday | Friday | Saturday
September 30 | 1 | 2 | 3 | 4 | 5 | 6
 |  |  |  |  | Leftovers Day
7 | 8 | 9 | 10 | 11 | 12 | 13
 |  |  |  |  | Leftovers Day
14 | 15 | 16 | 17 | 18 | 19 | 20
 |  |  |  |  | Leftovers Day
21 | 22 | 23 | 24 | 25 | 26 | 27
 |  |  |  |  | Leftovers Day
28 | 29 | 30 | 31
Spreadsheet: 89206d1288958723-formula-to-calculate-amounts-paid-per-account-book1
Sheet: Sheet1

Account Number |  |  |  |  |  |  |  | Amount Paid
1 |  |  |  |  |  |  |  | -22.99
1 |  |  |  |  |  |  |  | -1091.99
1 |  |  |  |  |  |  |  | -991.92
1 |  |  |  |  |  |  |  | -999.09
1 |  |  |  |  |  |  |  | -299.99
1 |  |  |  |  |  |  |  | -92.99
1 |  |  |  |  |  |  |  | -9.99
1 |  |  |  |  |  |  |  | -1.9
1 |  |  |  |  |  |  |  | 9.99
1 |  |  |  |  |  |  |  | -929.99 | -4430.860000000001
2 |  |  |  |  |  |  |  | -929.99
2 |  |  |  |  |  |  |  | -99.92
2 |  |  |  |  |  |  |  | -22.99
2 |  |  |  |  |  |  |  | -19.99
2 |  |  |  |  |  |  |  | 929.99
2 |  |  |  |  |  |  |  | 1129.99
2 |  |  |  |  |  |  |  | -119.09
2 |  |  |  |  |  |  |  | -109.1
2 |  |  |  |  |  |  |  | -91.09
2 |  |  |  |  |  |  |  | -9.9
2 |  |  |  |  |  |  |  | -2.92 | 654.9899999999999
3 |  |  |  |  |  |  |  | -1.92
3 |  |  |  |  |  |  |  | 22.99
3 |  |  |  |  |  |  |  | 929.99
3 |  |  |  |  |  |  |  | 991.92
3 |  |  |  |  |  |  |  | -1119.99
3 |  |  |  |  |  |  |  | 90.09
3 |  |  |  |  |  |  |  | 999.92
3 |  |  |  |  |  |  |  | -99.99
3 |  |  |  |  |  |  |  | -19.9 | 1793.11
Spreadsheet: 60293d1260863898-collecting-cell-values-example
Sheet: Sheet1

 | [NAME] | Responsible | Cost | Budget | Check | Budget?
 | 1 | Schmitz | 10 | 10 | OK
 | 2 | Meier | 10 | 15 | OK
 | 3 | Mueller | 15 | 10 | BUDGET | Mueller
 | 4 | Schmitz | 50 | 50 | OK
 | 5 | Meier | 20 | 15 | BUDGET | Meier
 | 6 | Mueller | 30 | 50 | OK
 | 7 | Schmitz | 15 | 10 | BUDGET | Schmitz
 | 8 | Meier | 10 | 10 | OK
 | 9 | Mueller | 30 | 20 | BUDGET | Mueller
 | 10 | Schmitz | 50 | 60 | OK
Spreadsheet: 196103-calculate-slope-of-reflection-off-sloped-surface-wowzers-reflected-line
Sheet: Data for plot

Nominal x | Incident |  | Mirror |  | Reflection |  | Normal to Mirror
 | X | Y | X | Y | X | Y | X | Y
-10
0 | 0 |  | 0 |  | 0 |  | 0
10
Spreadsheet: 46289d1245189033-single-cell-array-or-sumproduct-formula-sample
Sheet: Sheet1

 | If performance is less than 80%, $30,000 penalty
 | If performance is between 80 and up to 85%, penalty is $20,000
 | If performance is greater than 85 and up to 90%, $10,000 penalty
 |  | Period | Year to date
 |  | MAR |  |  | Jan | Feb | Mar | Apr | May | Jun | Jul | Aug | Sep | Oct | Nov | Dec
 |  | 20000 |  |  | 0.87 | 0.65 | 0.85 | 0.92 | 0.91 | 0.82
 | Problem: a single cell formula (in D11) without using a 'helper' row or column to calculate the 'year to date' total.
Spreadsheet: jeff_dasovich__14097__Sempra Data
Sheet: Revenue Requirements

SoCalGas & SDG&E
Short Run Avoided Cost of Procurement
Item | Description | Application | Rate | Annual | Implied
 |  |  | $/MMBtu | Load | Cost of
 |  |  |  | Bcf | Procurement
Brokerage Fee | Cost avoided by a 3rd | to Core Load | 0.0201 | 365.39
 | party core provider
Brokerage Fee | Cost avoided by a 3rd | to Non-Core Load | 0.0266
 | party non-core provider
Spreadsheet: 674153d1587677110-help-with-trading-log-file-index-match-and-counts-excel-help
Sheet: Trading Log

 | Date | Ticker | # [NAME] | Entry | Target | Stop Loss | % Risk | Target Gain % | Exit | Var $ | Var % | Profit/Loss
 | 2020-04-16 00:00:00 | Comp A | 100 | 63.7 | 67.51 | 62.43 | -0.0199 | 0.0598 | 63.74 | 0.04 | 0.0006 | 4
 | 2020-04-16 00:00:00 | Comp B | 200 | 63.81 | 65.09 | 62.53 | -0.0201 | 0.0201 | 63.88 | 0.07 | 0.0011 | 14
 | 2020-04-16 00:00:00 | Comp A | 300 | 66.02 | 67.34 | 64.7 | -0.02 | 0.02 | 65.1 | -0.92 | -0.0139 | -276
 | 2020-04-17 00:00:00 | Comp C | 300 | 66.02 | 68.66 | 64.7 | -0.02 | 0.04 | 67.49 | 1.47 | 0.0223 | 441
 | 2020-04-20 00:00:00 | Comp A | 300 | 65.48 | 68.1 | 64.17 | -0.02 | 0.04 | 67.94 | 2.46 | 0.0376 | 738
 | 2020-04-20 00:00:00 | Comp A | 300 | 66.24 | 68.88 | 64.92 | -0.0199 | 0.0399 | 68.22 | 1.98 | 0.0299 | 594
Spreadsheet: 846719d1697846223-tabulating-averages-by-month-and-year-summary-eba
Sheet: Summary

PO prices RMB/ton SCI
 | 2023 | 2022 | 2021
Average January
Average February
Average March
Average April
Average May
Average June
Average July
Average August
Average September
Average October
Average November
Average December
Year Average
Period Average
Spreadsheet: 124082d1318070559-find-max-time-between-dates-copy-of-2007-2010-rwi-lti-mti-free-days-data-2-
Sheet: Sheet1

Date | Injury | Department
2007-01-01 00:00:00 | LTI | Mining |  | Count of Department | Injury
2007-01-01 00:00:00 | RWI | Mining |  | Department | LTI | MTI | RWI | Grand Total
2007-01-12 00:00:00 | MTI | Mining |  | Engineering |  |  | 1 | 1
2007-02-12 00:00:00 | RWI | Mining |  | Geology | 1 |  | 4 | 5
2007-02-23 00:00:00 | RWI | Geology |  | HR & Admin | 1 | 1 |  | 2
2007-02-25 00:00:00 | RWI | Mining |  | [NAME] | 1 |  | 1 | 2
2007-03-04 00:00:00 | RWI | Mining |  | Mining | 5 | 5 | 8 | 18
2007-03-21 00:00:00 | RWI | Mining |  | Projects |  | 1 |  | 1
2007-04-18 00:00:00 | LTI | Mining |  | Grand Total | 8 | 7 | 14 | 29
2007-04-21 00:00:00 | RWI | Geology
2007-04-28 00:00:00 | RWI | Mining
2007-05-05 00:00:00 | LTI | [NAME]
2007-05-07 00:00:00 | LTI | Mining
2007-05-12 00:00:00 | RWI | Engineering
2007-05-22 00:00:00 | MTI | Mining
2007-05-29 00:00:00 | MTI | Mining
2007-06-01 00:00:00 | RWI | Mining
2007-06-01 00:00:00 | RWI | Mining
2007-06-03 00:00:00 | MTI | Mining
2007-06-06 00:00:00 | RWI | [NAME]
2007-07-17 00:00:00 | MTI | Mining
2007-08-01 00:00:00 | LTI | Mining
2007-08-01 00:00:00 | RWI | Geology
2007-08-05 00:00:00 | MTI | Projects
2007-08-14 00:00:00 | LTI | Geology
2007-08-15 00:00:00 | MTI | HR & Admin
2007-09-03 00:00:00 | LTI | HR & Admin
2007-09-20 00:00:00 | RWI | Geology
2007-09-21 00:00:00 | LTI | Mining
Spreadsheet: 47553d1246587557-excel-2007-advanced-filter-with-2-criteries-duplicate-dates
Sheet: Sheet3

Customer name | Number | Date | Name of Magazine |  | Reference
[NAME] |  | 2009-01-01 00:00:00
[NAME] |  | 2009-06-18 00:00:00 |  |  | 1
[NAME] |  | 2009-06-18 00:00:00 |  |  | 1
[NAME] |  | 2009-06-18 00:00:00 |  |  | 1
[NAME] |  | 2009-04-01 00:00:00
[NAME] |  | 2009-06-18 00:00:00 |  |  | 1
[NAME] |  | 2009-09-10 00:00:00 |  |  |  | X
[NAME] |  | 2009-09-11 00:00:00 |  |  |  | X
[NAME] |  | 2009-09-12 00:00:00 |  |  |  | X
[NAME] |  | 2009-06-18 00:00:00 |  |  | 1
Sandy |  | 2009-06-18 00:00:00 |  |  | 1
Sandy |  | 2009-09-13 00:00:00 |  |  |  | X
Sandy |  | 2009-09-14 00:00:00 |  |  |  | X
Sandy |  | 2009-09-15 00:00:00 |  |  |  | X
Sandy |  | 2009-01-01 00:00:00 |  |  |  | X
[NAME] |  | 2009-06-18 00:00:00 |  |  | 1
Spreadsheet: 70a08ca8-7be2-4938-b191-5170f5b8b52c
Sheet: Page 6

Permit No.: |  |  | WQ0000731 |  |  | Facility Name: |  | Lake Toxaway Country Club |  |  |  |  |  | County: | Transylvania |  | Month: |  |  | Year:
Did irrigation occur    at this facility? |  |  |  |  |  | Field Name: |  | T6 |  | Field Name: |  | T7 |  | Field Name: |  |  |  | Field Name:
 |  |  |  |  |  | Area (acres): |  | 4 |  | Area (acres): |  | 1.32 |  | Area (acres): |  |  |  | Area (acres):
 |  |  |  |  |  | Cover Crop: |  | 0.68 |  | Cover Crop: |  |  |  | Cover Crop: |  |  |  | Cover Crop:
 |  |  |  |  |  | [NAME] (in): |  | 0.15 |  | [NAME] (in): |  | 0.23 |  | [NAME] (in): |  |  |  | [NAME] (in):
 |  |  |  |  |  | Annual Rate (in): |  | 32 |  | Annual Rate (in): |  | 25.29 |  | Annual Rate (in): |  |  |  | Annual Rate (in):
Day | Weather |  |  | Freeboard |  | Field Irrigated? |  |  |  | Field Irrigated? |  |  |  | Field Irrigated? |  |  |  | Field Irrigated?
 | Weather Code | Temperature | Precipitation | Storage | 5-Day Upset (if applicable) | Volume Applied | Time   Irrigated | Daily   Loading | Maximum Hourly Loading | Volume Applied | Time    Irrigated | Daily   Loading | Maximum Hourly Loading | Volume Applied | Time   Irrigated | Daily   Loading | Maximum Hourly Loading | Volume Applied | Time   Irrigated | Daily   Loading | Maximum Hourly Loading
 |  | ºF | in | ft | ft | gal | min | in | in | gal | min | in | in | gal | min | in | in | gal | min | in | in
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
Monthly Loading:
12 Month Floating Total (in):
Spreadsheet: 794616d1662141169-need-more-solutions-for-slow-calculations-solutions-for-faster-calculation
Sheet: Sheet1

 | Return to single specific value according to the specific items
 |  |  |  |  |  |  |  |  | tomatoes | <<---- key in any fruit names in the list
 | Date | Inv-numbers | fruit | fruit | fruit | fruit
 | 2015-05-01 00:00:00 | 1 | oranges | grapefruits | tomatoes | limes
 | 2015-05-02 00:00:00 | 2 | nectarines | rockmelons | peaches | plums |  |  |  | Solution 1
 | 2015-05-03 00:00:00 | 3 | bananas | tomatoes | apples | tomatoes |  |  |  | ([NAME]: no need array formula CLRL+Shift+Enter)
 | 2015-05-04 00:00:00 | 4 | strawberries | raspberries | blueberries | kiwifruit |  |  |  | (Cons: take so long time in calculation if the data is big)
 | 2015-05-05 00:00:00 | 5 | apples | pears | oranges | apples |  |  |  | Inv-numbers
 | 2015-05-06 00:00:00 | 6 | watermelons | rockmelons | honeydew | bananas
 | 2015-05-07 00:00:00 | 7 | apples | avocados | apples | nectarines
 | 2015-05-08 00:00:00 | 8 | raspberries | blueberries | peaches | plums
 | 2015-05-09 00:00:00 | 9 | bananas | apricots | peaches | tomatoes
 | 2015-05-10 00:00:00 | 10 | tomatoes | tomatoes | watermelons | tomatoes
Spreadsheet: 104199d1301849524-excel-2007-looking-up-pending-items-lookup
Sheet: Main

Report: Unsolved Problems
 |  |  |  |  | January | Solved
Month | January |  | Description |  | February | Ongoing
 | Ongoing |  |  |  | March
 |  |  |  |  | April
 |  |  |  |  | May
 |  |  |  |  | June
 |  |  |  |  | July
 |  |  |  |  | August
 | =B3=TEXT(Jan!A4,"mmmm") |  |  |  | September
 | =AND(B3=TEXT(Jan!A4,"mmmm"),B4="Ongoing") |  |  |  | October
 |  |  |  |  | November
 |  |  |  |  | December
Spreadsheet: 102273d1300231239-how-do-i-use-check-boxes-to-join-multiple-possible-text-options-into-a-new-worksheet-testdata2
Sheet: Test Data (2)

 | Test Data Page 2
 | Check1 | Check2 | Text1 | Text2 | Text3 | Text4
 |  |  | a | b | c | d
 |  |  | e | f | g | h
 |  |  | I | j | k | l
 |  |  | One, One | Two, One | Three, One | Four, One
 |  |  | One, Two | Two, Two | Three, Two | Four, Two
 |  |  | One, Three | Two, Three | Three, Three | Four, Three
 |  |  | One, One | Two, One | Three, One | Four, One
 |  |  | One, Two | Two, Two | Three, Two | Four, Two
 |  |  | One, One | Two, One | Three, One | Four, One
 |  |  | One, Two | Two, Two | Three, Two | Four, Two
 |  |  | One, Three | Two, Three | Three, Three | Four, Three
Spreadsheet: 866718d1713620636-continue-to-my-last-thread-discussion-sample-2
Sheet: Sheet1

 |  |  |  |  |  |  | Q1. How I Know this A1 which pay is cover the Project 1, project 2 & project3
 |  |  |  |  |  |  | Solution required by formula
 | Name | Project1 | Project2 | Project3 | Total Salary |  | Project1 | Project2 | Project3
 | A1 | 13000 | 9008.718232988998 | 9008.718232988998 |  |  |  | Pay 3&4 |  | =LET(   s,0,   a,SCAN(,C13:I13,LAMBDA(x,y,x+y)),   b,IF(C4=0,s,IFERROR(XLOOKUP(C4,a,SEQUENCe(,7),,1),7))
 | B1 | 0 | 0 | 0 |  |  |  |  |  | SEQUENCe(,7),,1),7)
 | A2 | 5000 | 7000 | 8000 |  |  |  | Pay 2&3 | Pay 4&5
 | A3 | 0 | 0 | 0
 | A4 | 3000 | 4000 | 5000 |  |  |  | Pay 2 | Pay 3&4
 | B2 | 2020.126928551948 | 12000 | 11003 |  |  |  | Pay 2&3&4 | Pay 5&6&7
 | B3 | 0 | 7865 | 6534 |  |  |  | Pay 1&2&3&4 | Pay 5&6&7 | =LET(   s,0,   a,SCAN(,C13:I13,LAMBDA(x,y,x+y)),   b,IF(C4=0,s,IFERROR(XLOOKUP(C4,a,SEQUENCE(,7),,1),7)),   c,SCAN(,CHOOSECOLS(C13:I13,SEQUENCE(7-b,,b+1)),LAMBDA(x,y,x+y)),   d,IF(D4=0,b,IFERROR(XLOOKUP(D4,c,SEQUENCE(,7-b,b+1),,1),7)),   e,SCAN(,CHOOSECOLS(C13:I13,SEQUENCE(7-d,,d+1)),LAMBDA(x,y,x+y)),   f,IF(E4=0,d,IFERROR(XLOOKUP(E4,e,SEQUENCE(,7-d,d+1),,1),7)),   HSTACK(IF(b=0,"","Pay "&TEXTJOIN("&",1,SEQUENCE(b))),IF(d=0,"","Pay "&TEXTJOIN("&",1,SEQUENCE(d-b,,b+1))),IF(d=0,"","Pay "&TEXTJOIN("&",1,SEQUENCE(f-d,,d+1)))) )
 | Name | Pay 1 | Pay 2 | Pay 3 | Pay 4 | Pay 5 | Pay 6 | Pay 7 | Total
 | A1 | 6000 | 7000 | 8000 | 4000 | 8000 | 8000 | 6000
 | B1 | 0 | 0 | 0 | 0 | 0 | 0 | 0
 | A2 | 5000 | 6000 | 6000 | 4000 | 6000 | 6000 | 3000
 | A3 | 0 | 0 | 0 | 0 | 0 | 0 | 0
 | A4 | 3000 | 4000 | 4074.44 | 4000 | 3000 | 3000 | 3000
 | B2 | 4000 | 4000 | 4000 | 4000 | 3000 | 3000 | 3000
 | B3 | 2000 | 2000 | 2000 | 4000 | 2000 | 2000 | 2000
 | B4 | 2000 | 2000 | 2000 | 4000 | 2000 | 2000 | 2000
 | B5 | 2000 | 2000 | 2000 | 4000 | 2000 | 2000 | 2000
 | B6 | 2000 | 2000 | 2000 | 4000 | 2000 | 2000 | 2000
 | B7 | 2000 | 2000 | 2000 | 4000 | 2000 | 2000 | 2000
 | B8 | 2000 | 2000 | 2000 | 4000 | 2000 | 2000 | 2000
 | B9 | 2000 | 2000 | 2000 | 4000 | 2000 | 2000 | 2000
 | B10 | 2000 | 2000 | 2000 | 4000 | 2000 | 2000 | 2000
 | B11 | 2000 | 2000 | 2000 | 4000 | 2000 | 2000 | 2000
Spreadsheet: 255d1d53-7ccd-4a35-bf07-699b18e73cc7
Sheet: 7b

Product1 | EUR3 | USD | GBP | [NAME] | AUD | CAD | OTHER | TOTAL
Basis | 607590 | 8228973 | 2467925 | 2010356 | 371567 | 140632 | 240626 | 14067669
Fixed-Float | 64510636 | 74166279 | 13184513 | 19313563 | 5030215 | 4626224 | 12698141 | 193529571
FRA | 28667341 | 17371424 | 9290904 | 23876 | 274729 | 79619 | 4205183 | 59913076
OIS | 27191122 | 6177644 | 6643152 | 123895 | 1433036 | 1056838 | 980030 | 43605717
Swaption | 7998562 | 8170575 | 1398206 | 2313421 | 346131 | 21038 | 265029 | 20512962
OTHER* | 5617306 | 9775373 | 1144519 | 309071 | 136086 | 42538 | 238187 | 17263080
TOTAL | 134592557 | 123890268 | 34129219 | 24094182 | 7591764 | 5966889 | 18627196 | 348892075
*OTHER variable includes the following products: Cap/Floor, Debt Option, Exotic, Fixed-Fixed, and Inflation.
Spreadsheet: 0f1f7833-0537-44d1-a158-126a5c6b18b8
Sheet: T69

الجدول 69: أسباب الوفيات المسجلة في مصر
Table 69: Registered deaths by cause in Egypt
مصر | 2000 |  |  | 2005 |  |  | اخر سنة متوفرة - 2011
EGYPT |  |  |  |  |  |  | Latest available - 2011
سبب الوفاة (1) | مجموع | ذكور | اناث | مجموع | ذكور | اناث | مجموع | ذكور | اناث
Cause of death (1) | Total | Male | Female | Total | Male | Female | Total | Male | Female
1 | 20652 | 11207 | 9445 | 14879 | 7897 | 6982 |  | 6425 | 4951
2 | 20496 | 11930 | 8566 | 24168 | 13757 | 10411 |  | 17099 | 13355
3 | 11215 | 5030 | 6185 | 15977 | 7369 | 8608 |  | 489 | 519
4 | 1093 | 591 | 502 | 1180 | 569 | 611 |  | 7659 | 9466
5 | 479 | 231 | 248 | 1037 | 569 | 468 |  | 346 | 228
6 | 5086 | 2786 | 2300 | 7210 | 3840 | 3370 |  | 3925 | 3640
7 | 174511 | 91826 | 82685 | 184007 | 94954 | 89053 | … | … | …
8 | 37498 | 19739 | 17759 | 33053 | 17311 | 15742 | … | … | …
9 | 29568 | 18815 | 10753 | 38314 | 24325 | 13989 |  | 93741 | 84601
10 | 13522 | 8015 | 5507 | 15971 | 9206 | 6765 |  | 14593 | 12153
11 | 532 | - | 532 | 1108 | - | 1108 |  | 34169 | 20342
12 | 99 | 58 | 41 | 159 | 69 | 90 |  | 111 | 129
13 | 316 | 155 | 161 | 2219 | 971 | 1248 |  | 1279 | 1526
14 | 6479 | 3517 | 2962 | 6354 | 3291 | 3063 |  | 9006 | 6940
15 | 7992 | 4599 | 3393 | 9831 | 5607 | 4224 |  | - | 356
16 | 57406 | 30072 | 27334 | 66782 | 35247 | 31535 |  | 4836 | 3687
17 | 17755 | 12804 | 4951 | 7503 | 5773 | 1730 |  | 3298 | 2890
18 | … | … | … | 10397 | 7112 | 3285 |  | 56827 | 46926
19 | … | … | … | … | … | … | … | … | …
20 | … | … | … | … | … | … |  | 21730 | 5835
21 | … | … | … | … | … | … | … | … | …
22 | … | … | … | … | … | … | … | … | …
المجموع             Total | 404699 | 221375 | 183324 | 440149 | 237867 | 202282
(1) Causes of death given in annex 1 |  |  |  |  |  |  |  |  | (1) اسباب الوفيات في الملحق رقم 1
Spreadsheet: 33668d1230218851-formula-dependent-on-cell-lookup_formula
Sheet: ref

 | vn |  |  | Criteria vn
1 | $[NAME] |  | 1 | $G$2:$G$26
2 | $C$2:$C$26 |  | 2 | $H$2:$H$26
3 | $[NAME] |  | 3 | $I$2:$I$26
4 | $[NAME] |  | 4 | $[NAME]
5 | $F$2:$F$26 |  | 5 | $[NAME]
Spreadsheet: 884465d1733656753-replicate-rows-in-results-jacc14-tools-spill-365-aligw
Sheet: Sheet1

 |  |  |  |  |  |  |  |  | RESULT
JOB | product | STORE | type | COST a | RESTOCK |  |  |  |  | product | STORE | type | COST a | RESTOCK
51 | DULUX WHITE | WICKES | material | 25 | 2027-01-31 00:00:00 | material 1st job |  |  | 51 | DULUX WHITE | WICKES | material | 25 | 2027-01-31 00:00:00 | material 1st job
51 | CROWN WHITE | WICKES | material | 25 | 2027-02-01 00:00:00 | material 1st job |  |  | 51 | BRUSHES | WICKES | tool | 5 | 2026-05-01 00:00:00 | tool 1st job
51 | BRUSHES | WICKES | tool | 5 | 2026-05-01 00:00:00 | tool 1st job |  |  | 51 | TURPS | WICKES | tool | 7.99 | 2026-05-02 00:00:00 | tool 1st job
51 | TURPS | WICKES | tool | 7.99 | 2026-05-02 00:00:00 | tool 1st job |  |  | 51 | MASKING TAPE | B & Q | tool | 6 | 2026-05-03 00:00:00 | tool 1st job
51 | MASKING TAPE | B & Q | tool | 6 | 2026-05-03 00:00:00 | tool 1st job |  |  | 51 | CROWN WHITE | WICKES | material | 25 | 2027-02-01 00:00:00 | material 1st job
52 | JONSONS BLUE | WICKES | material | 25 | 2027-02-02 00:00:00 | material 2nd job |  |  | 51 | BRUSHES | WICKES | tool | 5 | 2026-05-01 00:00:00 | tool 1st job
52 | DULUX CREAM | WICKES | material | 25 | 2027-02-03 00:00:00 | material 2nd job |  |  | 51 | TURPS | WICKES | tool | 7.99 | 2026-05-02 00:00:00 | tool 1st job
52 | TURPS | WICKES | tool | 7.99 | 2026-05-02 00:00:00 | tool 2nd Job |  |  | 51 | MASKING TAPE | B & Q | tool | 6 | 2026-05-03 00:00:00 | tool 1st job
52 | MASKING TAPE | B & Q | tool | 6 | 2026-05-03 00:00:00 | tool 2nd Job |  |  | 52 | JONSONS BLUE | WICKES | material | 25 | 2027-02-02 00:00:00 | material 2nd
 |  |  |  |  |  |  |  |  | 52 | TURPS | WICKES | tool | 7.99 | 2026-05-02 00:00:00 | tools 2nd job
 |  |  |  |  |  |  |  |  | 52 | MASKING TAPE | B & Q | tool | 6 | 2026-05-03 00:00:00 | tools 2nd job
 |  |  |  |  |  |  |  |  | 52 | DULUX CREAM | WICKES | material | 25 | 2027-02-03 00:00:00 | material 2nd
 |  |  |  |  |  |  |  |  | 52 | TURPS | WICKES | tool | 7.99 | 2026-05-02 00:00:00 | tools 2nd job
 |  |  |  |  |  |  |  |  | 52 | MASKING TAPE | B & Q | tool | 6 | 2026-05-03 00:00:00 | tools 2nd job
Spreadsheet: 862194d1709931544-reverse-tax-calculation-retirment-calculator-excelforum2
Sheet: Tax calculations

 | Taxable income | 150000
 | Total payable
 | Net Income
Federal Tax (Quebec residents)
Quebec abatement (% of federal tax) | 0.165
Present-day Federal basic personal deduction: | 15000
Federal base rate | 0.15
 | Rate | On taxable income up to
 | 0.15
 | 0.15 | 53359
 | 0.205 | 106717
 | 0.26 | 165430
 | 0.29 | 235675
 | Total
 | Refundable quebec abatement
 | Personal deductions:
 | Federal Tax
Spreadsheet: 128292d1320896702-how-to-group-information-from-a-table-regroup-table
Sheet: Array Formula

Heading1 | Heading2 |  | A | B | C
A | 1 |  | 1 | 2 | 3
B | 2 |  | 4 | 5 | 6
C | 3 |  | 7 | 8 | 9
A | 4
B | 5
C | 6
A | 7
B | 8
C | 9
Spreadsheet: 134583d1325494535-help-needed-for-total-formula-master-bill
Sheet: PriceList

Table Array
 | SATURDAY VALUES | SUNDAY VALUES | WEEKDAY VALUE
Value 1 | 1.1 | 1.1 | 0.88
Value 2 | 0.98 | 0.98 | 0.98
Value 3 | 1.63 | 1.22 | 1.22
Value 4 | 1.63 | 1.22 | 1.22
Value 5 | 0.83 | 0.83 | 0.83
Value 6 | 1.01 | 1.01 | 1.01
Value 7 | 1.03 | 1.03 | 1.03
Value 8 | 1.01 | 1.01 | 1.01
Value 9 | 0.8 | 0.8 | 0.8
Value 10 | 1.2 | 1.04 | 1.04
Value 11 | 1.2 | 1.04 | 1.04
Value 12 | 1.2 | 1.04 | 1.04