tianzl66/Sheetpedia huggingface dataset:
Spreadsheet: 329840d1404418515-match-issue-consolidate-columns-of-data-with-match-index-etc-sample-spreadsheet
Sheet: Sheet1

Sample Data
 |  |  |  |  |  |  |  |  |  | This data with these calulations are the ultimate goal for this spreadsheet
 | Source Data |  |  |  | [NAME] | Actual Result | Desired Result | Actual Result | Desired Result | Additional Calc's I Plan to Do
Record | Date 1 | Date 2 | Date 3 | Date 4 | Match | Date | Date | Amount | Amount | Start Date | Amount | Incr 1 Date | Incr 1 Total | Incr 1 Amount | Incr 2 Date | Incr 2 Total | Incr 2 Amount
1 | 150 | 160 | 160 | 170 |  |  | Date 1 |  | 150 | Date 1 | 150 | Date 2 | 160 | 10 | Date 4 | 170 | 10
2 |  | 250 | 250 | 260 |  |  | Date 2 |  | 250 | Date 2 | 250 | Date 4 | 260 | 10
3 | 350 | 360 | 370 |  |  |  | Date 1 |  | 350 | Date 1 | 350 | Date 2 | 360 | 10 | Date 3 | 370 | 10
4 |  | 450 | 460 |  |  |  | Date 2 |  | 450 | Date 2 | 450 | Date 3 | 460 | 10
Spreadsheet: 163264d1340252912-excel-2007-hide-empty-cells-when-plotting-a-graph-hangman_solution
Sheet: Sheet1

Category | Values | [NAME]
A | 10
B | 20
C
D | 20
Category | Values
Spreadsheet: 72625d1273326456-days-money-is-invested-branch-exposure
Sheet: Sheet1

Branch: | IVORY COAST | BRANCH EXPOSURE (Fund inflow v/s outflow) |  |  |  | Month: | APRIL
[NAME]. | INFLOW |  | OUTFLOW |  |  | DAYS                         (Money Investment) | REMARKS
 | Date | Amount (US$) | Date | Amount (US$) | B/L NO.
 | 2010-03-31 00:00:00 | 5000
1 | 2010-04-01 00:00:00 | 74653
2 | 2010-04-02 00:00:00 |  |  | 70000
3 | 2010-04-03 00:00:00
4 | 2010-04-04 00:00:00
5 | 2010-04-05 00:00:00
6 | 2010-04-06 00:00:00
7 | 2010-04-07 00:00:00
8 | 2010-04-08 00:00:00
9 | 2010-04-09 00:00:00
10 | 2010-04-10 00:00:00
11 | 2010-04-11 00:00:00
12 | 2010-04-12 00:00:00
13 | 2010-04-13 00:00:00 | 19619.32
14 | 2010-04-14 00:00:00
15 | 2010-04-15 00:00:00
16 | 2010-04-16 00:00:00
17 | 2010-04-17 00:00:00
18 | 2010-04-18 00:00:00 | 42199.5
19 | 2010-04-19 00:00:00
20 | 2010-04-20 00:00:00 | 91464 |  | 42000
21 | 2010-04-21 00:00:00
22 | 2010-04-22 00:00:00
23 | 2010-04-23 00:00:00
24 | 2010-04-24 00:00:00
25 | 2010-04-25 00:00:00
26 | 2010-04-26 00:00:00 | 99034
27 | 2010-04-27 00:00:00
28 | 2010-04-28 00:00:00 |  |  | 91464
29 | 2010-04-29 00:00:00
30 | 2010-04-30 00:00:00
31 | 2010-05-01 00:00:00 | 57849
 | TOTAL
BALANCE AMOUNT
OVERHEADS' EXP (To be filled only in the closing report) |  |  | 0
NET BRANCH EXPOSURE
Spreadsheet: vkaminski__40901__CASH_EPE_0400MyCopy
Sheet: CF

CASH FLOW - PROJECT
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | Offset For
Current Year |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | "CF_Table"
Calendar Year |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | Totals |  | 1
Months Of Operation - Phase I
Months Of Operation - Phase II
Months Of Operation - Phase III
Total Number Of Months
Revenues
Total Fixed Payments: (Quoted To EletroNorte - Taxes Included)
Total Energy (Variable) Payments | Based On Units Produced
Total Revenues Before Backing Out Taxes
Less: PIS/COFINS
Total Revenues
Operating Expenses
Total Fuel Cost
Total Transportation & Take Or Pay Cost
Total Fixed O&M (R$ Based)
Total Fixed O&M (US$ Based)
Total Variable O&M |  | Grossed Up
Total Operating Expenses
Other Income / (Expenses)
Plus: Interest Income - Partner Loans
Less: Annual Property Tax
Plus: Interest Income WCAP & Maintenance Reserve
Less: OPIC Agency Fee
Less: L/C Fee - Debt Reserve
Less: L/C Fee - Working Capital
Less: L/C YPF Guarantee + Loan Guarantee Fee
Less: Performance Bond
Total Other Income / (Expenses)
Earnings Before Depr, Int & Taxes (EBDIT)
Less: Book Depreciation Expense
Earnings Before Int & Taxes (EBIT)
Less: Interest Expense - Senior Debt
Less: Interest Expense - Subordinated Debt
Less: IDC To Be Expensed
Earnings Before INE Expense & Taxes
Less: INE Interest Expense
Earnings Before Taxes (EBT)
Less:Book Provision For Income Taxes
Earnings Before Sudam Credits
Add: Sudam Credits Applied Against Losses
Project Book Income
Plus: Book Depreciation
Plus: IDC To Be Expensed
Plus: Liquidation Proceeds - Land
Plus: Liquidation Proceeds - Working Capital
Plus: Liquidation Proceeds - Spare Parts
Plus: Book Provision For Income Taxes
Less: Sudam Credits Applied Against Losses
Less: Cash Taxes
Less: Principal Payments - Senior Debt
Net A-T Cashflow Before Subdebt Principal Repayment
Less: Principal Payments - Subordinated Debt
Net A-T Cashflow Before Trapped Cash
Trapped Cash Loaned To Partners
Repayment Of Prior Year Trapped Cash Loans
Net A-T Cashflow Distributed
Spreadsheet: 538523d1505682498-how-to-auto-add-students-grade-and-remarks-to-a-worksheet-score-to-grade-and-comment
Sheet: 1ST TERM

LAGOS STATE GOVERNMENT
EDUCATION DISTRICT V, AGBOJU
SCHOOL
JUNIOR STUDENTS SCORE ENTRY SHEET
 | SESSION |  |  | CLASS |  |  | ENGLISH LANGUAGE
S/N | Name | Date Of Birth | Sex | Times School Opened | Times Present | Times Absent | 40 | 60 | 100 | Grade | Teachers' Comment | Principal'S Comments
1 | Student1 |  | Male | 122 | 120
2 | Student2 |  | Female | 122 | 110
3 | Student3 |  | Male | 122 | 120
4 | Student4 |  | Male | 122 | 90
5 | Student5 |  | Male | 122 | 117
6 | Student6 |  | Male | 122 | 122
7 | Student7 |  | Female | 122 | 122
8 | Student8 |  | Female | 122 | 116
9 | Student9 |  | Male | 122 | 121
Spreadsheet: tracy_geaccone__40252__C0366-112458
Sheet: Dept_100193

ENRON PROPERTY & SERVICES CORP
1400 Smith Street
Houston, Texas   77251 - 1188
MONTHLY INVOICE DETAIL
ENRON BUILDING - Dept. 100193
April, 2001
0366  EOC - Executive
Date | Ticket Number | Work Order | Service Name | Service Description | # [NAME] | Unit Cost | UOM | Service | Ticket
 |  |  |  |  |  |  |  | Total | Total
 |  |  | R/C 112458
2001-04-18 00:00:00 | EBR01/04 -EB 4078 |  | Building Rent | Sq. Ft. Occupied | 372 | 2.08 | /MNTH | 774.99
 |  |  |  |  |  |  | Ticket Total |  | 774.99
2001-04-18 00:00:00 | EBR01/04 -EB 4081 |  | Building Rent | Sq. Ft. Occupied | 294 | 2.08 | /MNTH | 612.49
 |  |  |  |  |  |  | Ticket Total |  | 612.49
 |  |  |  |  |  |  | Total for R/C: 112458 |  | 1387.48
 |  |  |  |  |  |  | Total for Dept_100193 |  | 1387.48
Spreadsheet: 146369d1332152565-copying-equation-from-source-sheet-based-on-dropdown-workouttable-1
Sheet: Exercise List

OL | % | UP | % | LB | % | PLY | % | UB | % | PC | % | PZ |  | SL | % | HIP | % | FMS | %
Push Press |  | [NAME] |  | Back Squat |  | [NAME] |  | Vertical |  | BB RDL |  | Crunches |  | [NAME] |  | [NAME] Up
Push Jerk |  | DB Bench |  | Wide back [NAME] |  | [NAME] |  | Pullups - NG/PRO/SUP |  | DB RDL |  | Situps |  | [NAME] |  | Back Elevated Hip Up
BTN Push Jerk |  | Incline DB Bench |  | Close Back Squat |  | Depth Drops |  | Lat Pulldowns |  | [NAME] |  | Swiss [NAME] |  | Walking DB Lunges |  | Back/Foot Elevated Hip Up
Hang Clean |  | BB Floor Press |  | Front Squat |  | [NAME] Bound |  | Band Pulldowns |  | Alt Reverse Hypers |  | Swiss Ball Stability |  | walking BB Lunges |  | [NAME]
Hang Snatch |  | DB Floor Press |  | [NAME] |  |  |  | SA Band Pulldowns |  | Back Extensions |  | Barbell Rollouts |  | RLE SS |  | Plate Hip Ups
[NAME] |  | DB Suspended Bench |  | Overhead Squat |  |  |  | DB/BB Pullovers |  | Good Mornings |  | Side Hipups |  | [NAME]
DB Cleans |  | Pause Press |  | Goblet Squat |  |  |  | BB/DB Shrugs |  | SL DB RDL |  | Side Bends |  | [NAME]
Clean |  | Band/Chain Bench |  | [NAME] |  |  |  | [NAME] |  | SB Leg Curl |  | [NAME] |  | [NAME]
Snatch |  | Close Grip Bench |  | Deadlift |  |  |  |  |  | GHR |  | [NAME] |  | Lateral Lunges
Shrug/High Pull Variations |  | 1 Board Press | 95 | Snatch Grip Deadlift |  |  |  | Horizontal |  |  |  | [NAME] |  | [NAME]
DB Push Press |  | 2 Board Press | 100 | Elevated Stance Deadlift |  |  |  | Inverted Row |  |  |  | [NAME] |  | Lateral [NAME]
Neutral [NAME] Press |  | 3 Board Press | 105 | [NAME] |  |  |  | Seated Row |  |  |  | [NAME]
 |  | 4 Board Press | 110 | [NAME] |  |  |  | DB Rows
 |  |  |  |  |  |  |  | [NAME]
 |  |  |  |  |  |  |  | DB Pushup/Rows
 |  |  |  |  |  |  |  | BB Rows
 |  |  |  |  |  |  |  | Pendlay Rows
 |  |  |  |  |  |  |  | Chest Supported Rows
 |  | OVERHEADS
 |  | BB Overhead
 |  | Seated DB Overhead
 |  | Standing DB Overhead
 |  | [NAME]
 |  | Neutral Grip DB Overhead
Spreadsheet: 214588d1360981266-finding-the-2nd-lookup-value-when-counter-gets-to-zero-sample
Sheet: Sheet1

TABLE 1 |  |  | TABLE 2
Name | Sessions in Package |  | Name | [NAME]
[NAME] | 12 |  | [NAME]
[NAME] | 18 |  | Kelly
[NAME] | 9 |  | Kelly
Kelly | 4 |  | [NAME]
Adam | 2 |  | Kelly
[NAME] | 10 |  | Kelly
[NAME] | 20 |  | Kelly
Kelly | 4
Spreadsheet: 18e93ffa-58c0-4ac1-b5a1-5ab49153c91b
Sheet: Sheet1

Nombre | Materia | [NAME] | Municipio | [NAME] inicio
Castillo de Bacares (Almería) | Bienes Inmuebles | Almería | Bacares
[NAME] [NAME] | Bienes Inmuebles | [NAME] | [NAME]
Baños árabes de Baza (Granada) | Bienes Inmuebles | Granada | Baza
Torre árabe [NAME] (Granada) | Bienes Inmuebles | Granada | [NAME] (Las)
Iglesia Mudéjar de San Juan de los Reyes (Granada) | Bienes Inmuebles | Granada | Granada
Spreadsheet: 107995d1305114759-excel-2007-need-help-to-solve-vlookup-of-unique-ids-on-multiple-sheets-test-book-101
Sheet: Feb 11

1005513 | Name | Surname | BA (HONS) BUSINESS MANAGEMENT
1005514 | Name | Surname | BA (HONS) BUSINESS MANAGEMENT
1005515 | Name | Surname | BA (HONS) BUSINESS MANAGEMENT
1005516 | Name | Surname | BA (HONS) BUSINESS MANAGEMENT
1005517 | Name | Surname | MBA - Full
1005518 | Name | Surname | MBA - Full
Spreadsheet: 757932d1638540294-calculating-4-threads-issue-with-tracker-pla-learning-journey-example-
Sheet: Stage 1 (Howard)

[NAME] |  |  |  |  |  |  |  |  |  |  | (Please put an x to show all learning has been completed or an E if there is a valid exception)
[NAME] | [NAME] | Front-Line Manager Name | Grade | Location | Tax Regime | Project | Date PJ Commenced | TUD Date | Cohort | Expected Week in Stage 1 Learning | Week 1 | Week 2 | Race Equality Workshop | Week 3 | [NAME] | Case Study 1 | Case Study 2 | Week 4 | Case Study 3 | Week 5 | Case Study 4 | Case Study 5 | Week 6 | Case Study 6 | Case Study 7 | Week 7 | Case Study 8 | Case Study 9 | Week 8 | Exceptions
Spreadsheet: 161075d1339404430-excel-2007-if-column-contains-x-then-cell-x-if-not-then-cell-max-column-master-copy-gas-and-gw-monitoring-sheet-v3
Sheet: Visit 1

JOB DETAILS:
Client: |  |  |  |  |  |  |  |  | Job No:
Site: |  |  |  |  |  |  |  |  | Visit No: |  |  | of
Date: |  |  |  |  |  |  |  |  | Operator: |  |  |  |  | Project Manager:
 | GAS CONCENTRATIONS |  |  |  |  |  |  |  |  |  |  |  | VOLATILES |  | FLOW DATA |  |  |  | Worst-credible GSVs |  | WELL AND WATER DATA |  |  |  |  | Comments
Monitoring Point | Methane (%v/v) |  | %LEL |  | Carbon dioxide (%v/v) |  | Carbon monoxide (ppmv) |  | Hydrogen sulphide (ppmv) |  | Oxygen (%v/v) |  | PID Peak (ppm) | Product thickness (mm) | Flow rate (l/hr) |  | Differential borehole Pressure (Pa) | Time for flow to equalise (secs) | Methane  (l/hr) | CO2 (l/hr) | Water level (mbgl) | Depth of well (m) | Reduced level (mAOD) | Water level (mAOD) | Response Zone
 | Peak | Steady | Peak | Steady | Peak | Steady | Peak | Steady | Peak | Steady | Min. | Steady |  |  | Peak | Steady
 | 12
 | ND
 | ND
 | ND
 | ND
 | ND
 | ND
 | ND
 | ND
 | 13
 | ND
 | ND
 | ND
[NAME]
Min |  | 0
 | ND - | Not detected |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | Worst-possible GSVs
 | NR - | Not recorded
 | NA - | Non applicable
Please Note: | Where no or -ve flow  (l/hr) was recorded the limit of detection (LoD) of the meter has been used = |  |  |  |  |  |  |  | 0.1
METEOROLOGICAL AND SITE INFORMATION: |  |  |  |  |  |  |  | (Select correct box with X or enter data, as applicable)
State of ground: |  |  |  |  | Dry |  |  | Moist |  |  | Wet |  |  | Snow |  |  | Frozen
Wind: |  |  |  |  | [NAME] |  |  | Light |  |  | Moderate |  |  | Strong
Cloud cover: |  |  |  |  | None |  |  | Slight |  |  | Cloudy |  |  | Overcast
Preciptation: |  |  |  |  | None |  |  | Slight |  |  | Moderate |  |  | Heavy
Time monitoring performed: |  |  |  |  |  |  |  | Start |  |  |  |  |  | End
Barometric pressure (mbar): |  |  |  |  |  |  |  | Start |  |  |  |  |  | End
Pressure trend: |  |  |  |  |  |  |  | Falling |  |  | Steady |  |  | Rising
Air Temperature (Deg. C): |  |  |  |  |  |  |  | Before |  |  |  |  |  | After
INSTRUMENTATION TECHNICAL SPECIFICATIONS:
Ground gas meter:
Gas Range: |  | CH4 |  |  | CO2 |  |  | O2
Gas Flow range:
Differential Pressure:
Date of last calibration:
Date of next calibration:
Ambient air check: |  | CH4 |  |  | CO2 |  |  | O2
PID:
Calbrated range:
Calibration gas:
Response time:
[NAME]:
Date of last calibration:
Date of next calibration:
Spreadsheet: 690171d1596909601-ref-when-using-index-match-match-with-tables-excel-query
Sheet: Mapping Tables

Date | Salary |  |  |  | KeyWord | Categories | Type | Fixed/Variable | Date |  |  |  |  |  |  |  | Person 1 |  | January
1 | Person 1 |  |  |  | Derbyshire | Home | Expenditure | Fixed | 15 | 129 | 129 | 100 | 200 |  |  |  | Person 2 |  | February
2 | Person 1 |  |  |  | DVLA | Vehicles | Expenditure | Fixed | 1 | 41.56 | 41.56 | 100 | 200 |  |  |  |  |  | March
3 | Person 1 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | April
5 | Person 1 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | May
6 | Person 1 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | June
7 | Person 1 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | July
8 | Person 1 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | August
9 | Person 1 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | September
10 | Person 2 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | October
11 | Person 2 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | November
12 | Person 2 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | December
13 | Person 2
14 | Person 2
15 | Person 2
16 | Person 2
17 | Person 2
18 | Person 2
19 | Person 2
20 | Person 2
21 | Person 2
22 | Person 2
23 | Person 2
24 | Person 2
25 | Person 1
26 | Person 1
27 | Person 1
28 | Person 1
29 | Person 1
30 | Person 1
31 | Person 1
Spreadsheet: 887807d1738145154-look-up-a-value-in-another-column-return-that-value-match-help-forum
Sheet: Sheet1

 | RAW |  |  |  | LOOKUP |  | OUTPUT NEEDED
 | Ticket | Deliverable | Cycle |  | Cycle 1
 | 1 | FUS-71 | Test cycle 15 | Cycle 1 |  | Cycle 2 |  | FUS-71 | Test cycle 15
 | 2 | FUS-72 | Test Cycle 14 | Cycle 15 |  | Cycle 3 |  | FUS-72 | Test Cycle 14 | Cycle 15
 | 3 | FUS-73 | Test cycle 15 - in progress | Cycle 2 |  | Cycle 4 |  | FUS-73 | Test cycle 15 - in progress | Cycle 2
 | 4 | FUS-74 | Test cycle 15 - in review | Cycle 12 |  | Cycle 5 |  | FUS-74 | Test cycle 15 - in review | Cycle 12
 | 5 | FUS-75 | Test Cycle 15 - done | Cycle 3 |  | Cycle 6 |  | FUS-75 | Test Cycle 15 - done | Cycle 3
 | 6 | FUS-76 | Test cycle 15 - triage | Cycle 14 |  | Cycle 7 |  | FUS-76 | Test cycle 15 - triage | Cycle 14
 | 7 | FUS-77 | Test cycle 15 - backlog | Cycle 1 |  | Cycle 8 |  | FUS-77 | Test cycle 15 - backlog | Cycle 1
 | 8 |  |  |  | Cycle 9
 | 9 |  |  |  | Cycle 10
 | 10 |  |  |  | Cycle 11
 | 11 |  |  |  | Cycle 12
 | 12 |  |  |  | Cycle 13
 | 13 |  |  |  | Cycle 14
 |  |  |  |  | Cycle 15
 |  |  |  |  | Cycle 16
Spreadsheet: 65d1585c-bacd-4a3c-8c1e-c70699475d78
Sheet: Sheet1

PROG ID | ATHLETE ID | ATHLETE FIRST | ATHLETE LAST | NATIONALITY | START NUMBER | SWIM | T1 | BIKE | T2 | RUN | POSITION | TOTAL TIME
8604 | 62988 | [NAME] | Norris | GER | 0 | 01:52:58 | 00:08:24 | 05:40:31 | 00:07:02 | 06:59:16 | 1 | 14:58:10
Spreadsheet: 848871d1699487329-count-pairs-a-and-b-in-same-row-four-columns-down-multiple-rows-book1-bvj-
Sheet: Sheet1

 | Week 1 |  |  |  |  |  |  |  |  |  |  | [NAME] | [NAME] |  |  | names
Tee | Name | Code | Name | Code | Name | Code | Name | Code |  |  |  |  |  |  |  | Al
1 | [NAME] | Host 1 | [NAME] | Host 2 | Sparky | 45 | Kargo | 46 |  |  |  |  |  |  |  | [NAME]
2 | Ray | 1 | [NAME] | 12 | Garth | 23 | [NAME] | 34 |  |  |  |  |  |  |  | [NAME]
3 | [NAME] | 2 | Al | 13 | [NAME] | 24 | [NAME] | 35 |  |  |  |  |  |  |  | [NAME]
4 | [NAME] | 3 | Walter | 14 | [NAME] | 25 | [NAME] | 36 |  |  |  |  |  |  |  | [NAME]
5 | [NAME] | 4 | [NAME] | 15 | [NAME] | 26 | [NAME] | 37 |  |  |  |  |  |  |  | [NAME]
6 | [NAME] | 5 | [NAME] | 16 | [NAME] | 27 | [NAME] | 38 |  |  |  |  |  |  |  | [NAME]
7 | Geoff | 6 | Mario | 17 | [NAME] | 28 | Hans | 39 |  |  |  |  |  |  |  | [NAME]
8 | [NAME] | 7 | [NAME] | 18 | [NAME] | 29 | Dennis | 40 |  |  |  |  |  |  |  | [NAME]
9 | [NAME] | 8 | [NAME] | 19 | [NAME] | 30 | [NAME] | 41 |  |  |  |  |  |  |  | Garth
10 | [NAME] | 9 | Cluade | 20 | [NAME] | 31 | [NAME] | 42 |  |  |  |  |  |  |  | [NAME]
11 | [NAME] | 10 | [NAME] | 21 | [NAME] | 32 | [NAME] | 43 |  |  |  |  |  |  |  | Geoff
12 | Al | 11 | [NAME] | 22 | Sal | 33 | [NAME] | 44 |  |  |  |  |  |  |  | [NAME]
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | [NAME]
 | Week 2 |  |  |  |  |  |  |  |  |  |  |  |  |  |  | [NAME]
Tee | Name | Code | Name | Code | Name | Code | Name | Code |  |  |  |  |  |  |  | Mario
1 | [NAME] | Host 1 | [NAME] | Host 2 | Sparky | 45 | Kargo | 46 |  |  |  |  |  |  |  | [NAME]
2 | Ray | 1 | [NAME] | 12 | [NAME] | 23 | [NAME] | 34 |  |  |  |  |  |  |  | [NAME]
3 | [NAME] | 2 | [NAME] | 13 | Sal | 24 | [NAME] | 35 |  |  |  |  |  |  |  | [NAME]
4 | [NAME] | 3 | Al | 14 | Garth | 25 | [NAME] | 36 |  |  |  |  |  |  |  | [NAME]
5 | [NAME] | 4 | Walter | 15 | [NAME] | 26 | [NAME] | 37 |  |  |  |  |  |  |  | Ray
6 | [NAME] | 5 | [NAME] | 16 | [NAME] | 27 | [NAME] | 38 |  |  |  |  |  |  |  | [NAME]
7 | Geoff | 6 | [NAME] | 17 | [NAME] | 28 | [NAME] | 39 |  |  |  |  |  |  |  | Sal
8 | [NAME] | 7 | Mario | 18 | [NAME] | 29 | [NAME] | 40 |  |  |  |  |  |  |  | Sparky
9 | [NAME] | 8 | [NAME] | 19 | [NAME] | 30 | [NAME] | 41 |  |  |  |  |  |  |  | [NAME]
10 | [NAME] | 9 | [NAME] | 20 | [NAME] | 31 | Hans | 42 |  |  |  |  |  |  |  | Walter
11 | [NAME] | 10 | Cluade | 21 | [NAME] | 32 | Dennis | 43
12 | Al | 11 | [NAME] | 22 | [NAME] | 33 | [NAME] | 44
Spreadsheet: 141051d1329060735-excel-2007-conditional-formatting-optional-life
Sheet: DATA

DATA ENTRY
[NAME]: |  | 2012-03-01 00:00:00
EE Number | First Name | Last Name | Date of Birth | Est. [NAME] | Elected Optional Employee Life | Elected Optional Spouse Life | Elected Optional Children Life |  | Optional Life Check - Fix Any Errors Before Going To List Bill
1001 | Kermit | Frog | 1961-10-13 00:00:00 | 33333.33 | 100000 | 50000 | 10000 |  |  | Employee(s) have less than minimum $10,000 allowed Optional Life
1002 | Miss | Piggy | 1986-11-28 00:00:00 | 180600 | 80000 | 35000 | 12000 |  |  | Employee(s) have more $300,000 allowable Optional Life
1003 | [NAME] | Bear | 1976-07-04 00:00:00 | 26000 | 20000 | 0 | 10000 |  |  | Employee(s) have coverage not in $10,000 increments
1004 | Big | Bird | 1940-05-29 00:00:00 | 102000 | 300000 | 150000 | 9000 |  |  | Spouse(s) have less than minimum $10,000 allowed Optional Life
1005 | Cookie | Monster | 1958-11-05 00:00:00 | 48987 | 25000 | 0 | 0 |  |  | Spouse(s) have more $150,000 allowed Optional Life
1006 | [NAME] | Muppet | 1980-01-27 00:00:00 | 46589.63 | 50000 | 0 | 10000 |  |  | Spouses have more than 50% of Employee Optional Life
1007 | Ernie | Muppet | 1982-04-01 00:00:00 | 46589.63 | 100000 | 30000 | 0 |  |  | Spouse(s) have coverage not in $10,000 increments
1008 | Count | [NAME] | 1944-11-05 00:00:00 | 85634.22 | 500000 | 50000 | 0 |  |  | Child(ren) have incorrect Optional Life (must be $0 or $10,000)
1009 | [NAME] | Grouch | 1979-03-12 00:00:00 | 54897 | 5000 | 0 | 10000 |  |  | Child(ren) have more than 50% of Employee Optional Life
1010 | Snuffle | Upagus | 1990-04-01 00:00:00 | 28560 | 14560 | 0 | 5000
Spreadsheet: 876153d1722846756-need-formula-for-tier-incentive-calculation-calculation-doing-formula-etaf
Sheet: Dr. Alaa Kutaish

Contract Terms (*)
 |  | Description | Commission
 |  | Consumables up to 25% not deducted, over 25% the difference is deducted
 |  | Total Revenue | 0.36
 |  | Ulthera Machine Revenue (After deducting depreciation) | 0.25
Doctor Calculation
 |  | Doctor Revenue | 1180600.55
 |  | Consumables < 25% not to be deducted | 272424.34
 |  | Less Consumables (More Than 25%) | 0
 |  | Net Revenue
 |  | Total Amount to be Paid
 |  | Less Incentive Nurse Mushtaqa | 1000
 |  | Less Incentive Nurse Mai Burai | 1000
 |  | Less Incentive Nurse Joyce Gallaron | 1250
 |  | Less Monthly Salary | 20000
 |  | Net Amount to be Paid
Prepared By …................. |  |  |  | CFO | .......................
Spreadsheet: 701971d1604020845-radio-button-controls-with-2-dimensional-lookup-radio-buttons-based-on-and-options
Sheet: Problem

Lookup Data |  |  |  |  |  | Actual Data
Alpha | M | T | W |  |  |  | M | T | W
Test_11 | Test_11_M | Test_11_T | Test_11_W
Test_12 | Test_12_M | Test_12_T | Test_12_W
Test_13 | Test_13_M | [NAME] | Test_13_W
Bravo | M | T | W |  |  | Radio Group "Org" |  | Radio Group "Schedule"
Test_21 | Test_21_M | [NAME] | Test_21_W
Test_22 | Test_22_M | Test_22_T | Test_22_W
Test_23 | Test_23_M | Test_23_T | Test_23_W
[NAME] | M | T | W
Test_31 | Test_31_M | Test_31_T | Test_31_W
Test_32 | Test_32_M | Test_32_T | [NAME] |  |  | 0 |  | 1
Test_33 | Test_33_M | Test_33_T | Test_33_W
Spreadsheet: 143168d1330253103-using-sum-function-test
Sheet: CAUL_2012-02-25_R1

number 1 | number 2 | number 3 | total
16.09 (1) | 12.05 (2) | 12.23 (2) | total formula to be placed here and should equal 40.37
16.21 (3) | 12.25 (3) | 12.24 (3)
16.52 (5) | 12.70 (6) | 11.99 (6)
16.27 (4) | 12.28 (4) | 12.18 (4)
16.18 (2) | 11.87 (1) | 12.22 (1)
16.58 (6) | 12.41 (5) | 12.17 (5)
Spreadsheet: 213259d1360410456-how-to-prevent-duplicate-records-from-being-entered-on-a-recording-sheet-test-recording-sheet
Sheet: Macro Moths

Macro | Moth records (Please fill in as many of the fields below, leave blank where information is not known. Each row is a complete record so please make sure that all the recorder information is filled in for every row).
Enter species name in this column only ?
BF Log | Status | Species [NAME] | Species Latin name | Place Name | [NAME]. | [NAME]. | [NAME] | Determiners Name | Date of Record | Qty Recorded | Method of Recording | [NAME] type | Stage | Weather | Aspect | Altitude | [NAME]. | Notes
2107 | A | Large Yellow Underwing | Noctua pronuba |  | SO123456 |  |  |  | 2013-03-15 00:00:00
2107 | A | Large Yellow Underwing | Noctua pronuba |  | SO123456 |  |  |  | 2013-03-15 00:00:00
» | » |  | »
» | » |  | »
» | » |  | »
» | » |  | »
» | » |  | »
» | » |  | »
» | » |  | »
» | » |  | »
» | » |  | »
» | » |  | »
» | » |  | »
» | » |  | »
» | » |  | »
» | » |  | »
» | » |  | »
» | » |  | »
» | » |  | »
» | » |  | »
» | » |  | »
» | » |  | »
» | » |  | »
» | » |  | »
» | » |  | »
» | » |  | »
» | » |  | »
» | » |  | »
» | » |  | »
» | » |  | »
» | » |  | »
» | » |  | »
» | » |  | »
» | » |  | »
» | » |  | »
» | » |  | »
» | » |  | »
» | » |  | »
» | » |  | »
» | » |  | »
» | » |  | »
» | » |  | »
» | » |  | »
» | » |  | »
» | » |  | »
» | » |  | »
» | » |  | »
Spreadsheet: 821858d1678954281-vstack-results-of-indirect-references-from-an-array-indirect_example_1
Sheet: data2

 |  | [NAME] | amount | account
Spreadsheet: 546696d1510159660-how-do-i-make-excel-not-count-squared-or-superscripted-numbers-excel-sample
Sheet: Group Sampras

 |  |  |  | W | L | SF | SA | GF | GA | Pts |  |  | 1 | [NAME] | 6 | 4 | 7 7
 |  | 1 | [NAME] |  |  |  |  |  |  |  |  |  | 7 | [NAME] | 3 | 6 | 6 5
 |  | 2 | Dominic Thiem
 |  | 3 | [NAME] |  |  |  |  |  |  |  |  |  | 4 | Dominic Thiem
 |  | 4 | [NAME] |  |  |  |  |  |  |  |  |  | 6 | [NAME]
 |  |  |  |  |  |  |  |  |  |  |  |  | 1 | [NAME]
 |  |  |  |  |  |  |  |  |  |  |  |  | 6 | [NAME]
 |  |  |  |  |  |  |  |  |  |  |  |  | 4 | Dominic Thiem
 |  |  |  |  |  |  |  |  |  |  |  |  | 7 | [NAME]
 |  |  |  |  |  |  |  |  |  |  |  |  | 6 | [NAME]
 |  |  |  |  |  |  |  |  |  |  |  |  | 7 | [NAME]
 |  |  |  |  |  |  |  |  |  |  |  |  | 1 | [NAME]
 |  |  |  |  |  |  |  |  |  |  |  |  | 4 | Dominic Thiem