tianzl66/Sheetpedia huggingface dataset:
Spreadsheet: 493358d1481671738-how-to-have-the-titles-in-2-cells-send-data-from-3rd-cell-to-a-4th-cell-on-another-sheet-forum-help
Sheet: Sheet2

Today's Date |  |  | Day of Week |  |  | Job Name | 860 Garnet
2016-12-01 00:00:00 |  |  |  |  |  | Job#
Job Location |  |  |  |  |  | Daily #
860 Garnet, Pacific Beach |  |  |  |  |  | 1
[NAME] |  |  | Approx Temp |  |  | Site Conditions
[NAME] |  |  | 70 |  |  | Good
Company Competent Person
[NAME]
[NAME]
Crew Members |  |  |  | Start | Finish | Total | Code |  | Title
[NAME] |  |  |  | 07:00:00 | 03:30:00 | 8 | 2010 TRENCHING |  | FMAN
Greg |  |  |  | 07:00:00 | 02:30:00 | 7 | 2010 TRENCHING |  | JOUR
[NAME] |  |  |  | 07:00:00 | 02:30:00 | 7 | 2010 TRENCHING |  | APP
[NAME] |  |  |  | 07:00:00 | 11:00:00 | 4 | 2020 BACKFILL |  | LAB
Work Performed Today
Layout for beer sweeps
Trench for beer sweeps
Special Work Request/Field Order |  |  |  |  |  |  | Authorized By
Per [NAME] use existing 4" ABS sewer for POC
[NAME] (Describe) |  |  |  |  |  |  | Authorized By
Expected Problems/Delays
Special Tools/Equipment Rented |  |  |  | Rented From |  |  |  | Rate | Hrs.
Terex Backhoe |  |  |  | [NAME]. Rentals
Spreadsheet: 847433d1698355388-determine-of-visitors-per-month-based-on-quarter-indicated-hd180-visitors-per-year
Sheet: Solution

 |  |  |  |  | WHEN ARE THE GROUPS GOING TO VISIT? |  |  |  |  | HOW MANY VISITORS PER MONTH (EST)
 |  |  |  |  |  |  |  |  |  | Q1 |  |  | Q2 |  |  | Q3 |  |  | Q4
 | SIMPLE | discount | regular |  | Q1 | Q2 | Q3 | Q4 |  | JAN | FEB | MAR | APR | MAY | JUN | JUL | AUG | SEP | OCT | NOV | DEC
 | Group A | 50 | 50 |  | X |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | no visits in Dec
 | Group B | 32 | 80 |  | X | X
 | Group C | 18 | 25 |  |  | X
 | Group D | 64 | 8 |  |  | X | X
 | Group E | 123 | 31 |  |  |  | X
 | Group F | 0 | 12 |  |  |  | X | X
 | Group G | 81 | 29 |  | X | X | X | X
 |  |  |  |  | WHEN ARE THE GROUPS GOING TO VISIT? |  |  |  |  | HOW MANY VISITORS PER MONTH (EST)
 |  |  |  |  |  |  |  |  |  | Q1 |  |  | Q2 |  |  | Q3 |  |  | Q4
 | COMPLEX | discount | regular |  | Q1 | Q2 | Q3 | Q4 |  | JAN | FEB | MAR | APR | MAY | JUN | JUL | AUG | SEP | OCT | NOV | DEC
 | Group A | 50 | 50 |  | X |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | no visits in Dec
 | Group B | 32 | 80 |  | X | X
 | Group C | 18 | 25 |  | X |  | X
 | Group D | 64 | 8 |  | X |  |  | X
 | Group E | 123 | 31 |  |  | X
 | Group F | 0 | 12 |  |  | X | X
 | Group G | 57 | 18 |  |  | X |  | X
 | Group H | 143 | 39 |  |  |  | X
 | Group I | 6 | 0 |  |  |  | X | X
 | Group J | 0 | 62 |  |  |  |  | X
 | Group K | 81 | 29 |  | X | X | X | X
Spreadsheet: louise_kitchen__24136__North America Plan 01-08 adj
Sheet: West Power Trading

 | West Power Trading
 | 2002 Plan
 |  |  |  |  |  |  |  |  |  |  | Per HC | New HC | Adjust Comp
 |  | 2001-09-01 00:00:00 |  | 2001 |  | 2002 |  | % of |  |  |  |  |  | 2002
 |  | YTD Actual |  | Forecast |  | Plan |  | Total Exp |  |  |  |  |  | Plan
ENACOMP | Compensation |  |  |  |  |  |  |  |  | Compensation | 0 | 64
 | Special Pays |  |  |  |  | 0
 | Analysts & Associates
ENABENTX | Benefits & Payroll Taxes |  |  |  |  |  |  |  |  | Other
ENAEMPEX | Employee Expense
ENAT&EEX | Travel & Entertainment Expense |  |  |  |  |  |  |  |  | Total
ENAOUTSV | Outside Services
ENASUPP | Supplies Expense |  |  |  |  | 55296
ENAMKTEX | Marketing |  |  |  |  | 24000 |  |  |  | [NAME] | 33600 | 0
ENACONTR | Charitable Contributions |  |  |  |  | 7312.8 |  |  |  | [NAME] | 52800 | 0
ENARENT | Rent |  |  |  |  |  |  |  |  | Staff | 54000 | 0
ENATECH | Technology |  |  |  |  |  |  |  |  | Specialist | 63000
ENATRANS | Transportation |  |  |  |  | 0 |  |  |  | Sr. Specialist | 78000
ENAOTHEX | Other Expenses |  |  |  |  | 90000 |  |  |  | Analyst | 66000 | 0
ENATAXES | Taxes Other than Income |  |  |  |  |  |  |  |  | Associate | 97200 | 0
ENATOTDR | Total Direct Expenses |  |  |  |  |  |  |  |  | Manager | 120000 | 0
 |  |  |  |  |  |  |  |  |  | Director | 156000 | 7
 | Headcount |  |  |  |  |  |  |  |  | Sr. Director | 180000 | 0
 |  |  |  |  |  |  |  |  |  | VP | 216000 | 2
 | Analyst & Associate Headcount |  |  |  |  |  |  |  |  | MD | 240000 | 1
 | Total Headcount |  |  |  |  |  |  |  |  |  |  |  |  | 1
 |  |  |  |  |  |  |  |  | Other Expense Calculation
 | Outside Services | 677322
 |  |  |  |  |  |  |  |  | Total Misc Exp | Old HC | Exp/Old HC | New HC | Exp/New HC
Spreadsheet: 72381d1273067384-updating-one-cell-based-on-certain-criteria-samplesheetforpriceupdates
Sheet: buypricetables

SKU | UNITCOST
[NAME] | 36.25
[NAME] | 48.5
AL0416FATIGUE | 32.5
AL0510LINEN | 48.5
AL0512LINEN | 8.75
AL0514LINEN | 90
AL0610LINEN | 56
AL0612LINEN | 43
AL0618LINEN | 16
AL0622LINEN | 28
AL0912LINEN | 23
[NAME] | 65
AL1010RICHBERRY | 36.25
AL1012GRAIN | 48.5
[NAME] | 32.5
AL1018GRAIN | 48.5
AL0314TAPPLE | 8.75
AL0316TAPPLE | 90
AL0318TAPPLE | 56
AL0320TAPPLE | 43
AL0322TAPPLE | 16
AL0410FATIGUE | 28
AL0412FATIGUE | 23
AL0414FATIGUE | 65
AL0416FATIGUE | 75
AL0418FATIGUE | 85
AL0420FATIGUE | 95
AL0422FATIGUE | 105
AL1022RICHBERRY | 115
Spreadsheet: 119778d1314736166-automatically-choose-from-dropdown-menu-by-referencing-cell-values-sample
Sheet: Sheet1

GRADE ROSTER AUTOMATED UPLOAD OF RESULTS |  |  |  |  |  |  | ABS [Absent] | A [Attendance]
 |  |  |  |  |  |  | ABSM [Absent - Medical Certificate] | AC [Attendance & Coursework]
Term: |  | 2101 (Academic Year 2010/11) |  |  |  |  | CO [Class Attend Only - No Result] | ACA [Attendance & Continuous Assessment]
Subject: |  | ECO (Economics - ECO) |  |  |  |  | DEF [Deferred] | ACAE [Attendance, Continuous Assessment & Exam]
Catalog Number: |  | 3203 |  |  |  |  | DTD [Discounted] | ACCA [Attendance, Coursework & Continuous Assessment]
Class: |  | 54431 (Some Economics Class) |  |  |  |  | F [Fail] | ACE [Attendance, Coursework & Exam]
[NAME]: |  |  |  |  |  |  | FN [Failed with No Entitlement] | ACP [Attendance, Coursework & Practical]
Total Students: |  | 3 |  |  |  |  | IF [Include Fail] | AE [Attendance & Exam]
[NAME]: |  | 53.33333333333334 |  |  |  |  | P [Pass] | AEP [Attendance, Exam & Practical]
Standard Deviation: |  | 25.16611478423583 |  |  |  |  | PC1 [Pass by Compensation] | AP [Attendance & Practical]
 |  |  |  |  |  |  | PCR [Pass with Credit] | C [Coursework]
Date of Creation: |  | 22 August 2011 @ 11:52 am |  |  |  |  | PD [Pass with Distinction] | CA [Continuous Assessment]
 |  |  |  |  |  |  | PH [Pass with Honours Restriction] | CAE [Continuous Assessment & Exam]
Student ID | ABCD ID | Seat | Name | [NAME] | Exam Board Note | Elements Failed | REN [Repeat Module] | CAEL [Continuous Assessment, Exam & Lab]
12345678 | 39293 | B, 01 | Woody Allen | 30 | F [Fail] |  | REO [Repeat, Exam Only] | CAEP [Continuous Assessment, Exam & Practical]
34210939 | 39295 | B, 02 | [NAME] | 80 | P [Pass] |  | RF [Referred] | CAL [Continuous Assessment & Lab]
37474747 | 39384 | B, 03 | [NAME] | 50 | P [Pass] |  | RN [Resit as First Attempt] | CAP [Continuous Assessment & Practical]
 |  |  |  |  |  |  | X [Exempt] | CCA [Coursework & Continuous Assessment]
 |  |  |  |  |  |  |  | CCAE [Coursework, Continuous Assessment & Exam]
 |  |  |  |  |  |  |  | CCAEP [[NAME],[NAME], Exam & Practical]
 |  |  |  |  |  |  |  | CCAP [Coursework, Continuous Assessment & Practical]
 |  |  |  |  |  |  |  | CE [Coursework & Exam]
 |  |  |  |  |  |  |  | CEF [Coursework, Exam & Fieldwork]
 |  |  |  |  |  |  |  | CEFP [[NAME], Exam, Fieldwork & Practical]
 |  |  |  |  |  |  |  | CEL [Coursework, Exam & Lab]
 |  |  |  |  |  |  |  | CEP [Coursework, Exam & Practical]
 |  |  |  |  |  |  |  | CF [Coursework & Fieldwork]
 |  |  |  |  |  |  |  | CFP [Coursework, Fieldwork & Practical]
 |  |  |  |  |  |  |  | CO [Coursework & OSCE]
 |  |  |  |  |  |  |  | CP [Coursework & Practical]
 |  |  |  |  |  |  |  | E [Exam]
 |  |  |  |  |  |  |  | EL [Exam & Lab]
 |  |  |  |  |  |  |  | EP [Exam & Practical]
 |  |  |  |  |  |  |  | F [Fieldwork]
 |  |  |  |  |  |  |  | FP [Fieldwork & Practical]
 |  |  |  |  |  |  |  | L [Lab]
 |  |  |  |  |  |  |  | O [OSCE - Objective Structured Clinical Examination]
 |  |  |  |  |  |  |  | P [Practical]
Spreadsheet: 169231d1342733800-vlookup-within-a-vlookup-can-it-be-done-sample_vlookup-data
Sheet: Raw Data

 | Company Name | Market Share
Australia | A Incorporated | 10
Australia | B xxxx | 10
Australia | C | 10
Australia | D | 10
Australia | E | 10
Australia | F | 10
Australia | G | 10
Australia | H | 10
Australia | I | 10
Australia | J | 10
Belgium | A Limited | 20
Belgium | B | 20
Belgium | C | 20
Belgium | D | 20
Belgium | E | 20
Canada | A | 12.5
Canada | B | 12.5
Canada | C | 12.5
Canada | D | 12.5
Canada | E | 12.5
Canada | F | 12.5
Canada | G | 12.5
Canada | H | 12.5
Spreadsheet: 166981d1341857971-how-would-i-have-a-drop-down-box-menu-populate-a-cll-matris-worksheet-with-checkmarks-myincidentlogmatrix
Sheet: Incident calls

 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | TSA-JNU Incident Log
Date: |  |  |  | Time: |  |  |  |  |  |  |  |  | Incident Location: |  |  |  |  |  |  |  |  |  | IR #:
 |  |  |  |  |  |  |  |  |  |  |  |  | Bridge line:  [PHONE] Code 6928571#
Incident Type |  |  |  |  |  |  |  |  |  |  |  |  |  | Incident Description
Alert 1 or 2: Minor or Major aircraft difficuly as reported by Airport Ops; e.g. fire warning light, faulty landing gear, etc.
 |  | Incident Email Group |  |  |  | AFSD-S |  |  |  | Security Manager for airport or on Duty |  |  |  | TSS-E |  |  |  | AFSD-I                          (or if Canine unit requested) |  |  |  | ASFD-G |  |  |  | FSD
Notify: |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 0
Time Notified:
Initials:
 |  | [NAME] AFSD-Inspections Cell: 758-0305 |  |  |  | TSOC (866) 655-7023 |  |  |  | AlaskJNU  Airlines Aiirport Security Director 789-7821 |  |  |  | JNU Airport Security             321-3802 |  |  |  | JNU Police Department |  |  |  | Ten reportable |  |  |  | TSA-JNU Email Group
Notify:
Time Notified:
Initials:
 |  |  |  |  |  |  |  |  |  |  | IR Summary
 |  | MKE Airport OPS 747-5325 (see comment) |  |  |  | Paris report required |  |  |  | TISS Report Required
Notify:
Time Notified:
Initials:
Notify:
Time Notified:
Initials:
CC Officers:
Sensitive Security Information WARNING: This record contains Sensitive Security Information that is controlled under 49 CFR parts 15 and 1520. No part of this record may be disclosed to persons without a “need to know”, as defined in 49 CFR parts 15 and 1520, except with the written permission of the Administrator of the Transportation Security Administration or the Secretary of Transportation. Unauthorized release may result in civil penalty or other action. For U.S. government agencies, public disclosure is governed by 5 U.S.C. 552 and 49 CFR parts 15 and 1520.
Date: |  |  |  | Time: |  |  |  |  |  |  |  |  | Incident Location: |  |  |  |  |  |  |  |  |  | IR #:
Incident Timeline
Time | Actions and Significant Information |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | Initials
CC Officers(s):
Sensitive Security Information WARNING: This record contains Sensitive Security Information that is controlled under 49 CFR parts 15 and 1520. No part of this record may be disclosed to persons without a “need to know”, as defined in 49 CFR parts 15 and 1520, except with the written permission of the Administrator of the Transportation Security Administration or the Secretary of Transportation. Unauthorized release may result in civil penalty or other action. For U.S. government agencies, public disclosure is governed by 5 U.S.C. 552 and 49 CFR parts 15 and 1520.
Spreadsheet: 85081d1285153273-count-instances-of-a-value-across-multiple-sheets-book1
Sheet: Gain 123

Product | Type | Key
a | 1 | JHYU918-9187-088
b | 2 | JHYU918-9187-088
c | 3 | JHYU414-234H-876
d | 4 | JHYU414-234H-877
a | 1 | JHYU414-234H-878
b | 2 | JHYU414-234H-542
c | 3 | JHYU414-234H-543
d | 4 | JHYU414-234H-544
a | 5 | JHYU414-234H-545
b | 6 | JHYU414-234H-544
c | 7 | JHYU414-234H-547
d | 8 | JHYU414-234H-548
a | 9 | JHYU414-234H-886
b | 10 | JHYU414-234H-887
c | 11 | JHYU414-234H-888
d | 12 | JHYU918-9187-088
a | 13 | JHYU918-9187-088
c | 11 | JHYU414-234H-876
Spreadsheet: 799855d1665363436-insert-graphs-that-automatically-update-based-on-variables-graph-reduex
Sheet: Sheet1

 | One |  |  |  | 22
 | Two |  |  |  | 19.5
 | Diff
 |  | 20-13 = |  |  |  |  |  |  |  |  |  | 21-28 =
var→ | -6.79 | -6.22 | -4.73 | -1.14 | 0.25 | 1.75 | 2.64 | 3.14 | 3.54 | 2.85 | 1.35 | 0.54 | -1.84 | -3.82 | -6.81 | -7.21 | A
diff→
rng.→ | 24 - 29 | 23.3 - 28.3 | 21.5 - 26.5 | 19 -24 | 17 - 22 | 15 - 20 | 14 - 19 | 13 - 18 | 13 - 18 | 14 - 19 | 15 - 20 | 17 - 22 | 19 -24 | 21.5 - 26.5 | 23.3 - 28.3 | 24 - 29
→ | 1 | 2 | 3 | 4 | 5 | 6 | 7 | 8 | 9 | 10 | 11 | 12 | 13 | 14 | 15 | 16
 |  | 24-17 = |  |  |  |  |  |  |  |  |  | 25-32=
var→ | -7.11 | -6.31 | -4.71 | -1.83 | -0.64 | 2.06 | 2.85 | 3.35 | 3.55 | 2.95 | 1.56 | -0.43 | -2.43 | -3.2 | -6.91 | -7.81 | B
diff→
rng.→ | 24 - 29 | 23.3 - 28.3 | 21.5 - 26.5 | 19 -24 | 17 - 22 | 15 - 20 | 14 - 19 | 13 - 18 | 13 - 18 | 14 - 19 | 15 - 20 | 17 - 22 | 19 -24 | 21.5 - 26.5 | 23.3 - 28.3 | 24 - 29
→ | 1 | 2 | 3 | 4 | 5 | 6 | 7 | 8 | 9 | 10 | 11 | 12 | 13 | 14 | 15 | 16
var→ | -5.12 | -5.01 | -5.32 | -5.31 | -5.12 | -5.01 | -5.12 | -5.71 | -5.11 | -4.82 | -5.11 | -5.21 | -5.21 | -5.31 | -5.61 | -3.92 | C
→ | 1 | 2 | 3 | 4 | 5 | 6 | 7 | 8 | 9 | 10 | 11 | 12 | 13 | 14 | 15 | 16
var→ | -4.82 | -4.82 | -5.31 | -5.21 | -5.11 | -4.81 | -5.01 | -4.61 | -5.31 | -4.62 | -5.12 | -4.82 | -4.81 | -4.62 | -5.41 | -5.91
→ | 17 | 18 | 19 | 20 | 21 | 22 | 23 | 24 | 25 | 26 | 27 | 28 | 29 | 30 | 31 | 32
var→ | -5.41 | -5.12 | -5.31 | -4.22 | -5.02 | -4.91 | -5.62 | -5.21 | -4.91 | -4.71 | -5.21 | -5.11 | -5.51 | -5.41 | -6.01 | -5.31
→ | 33 | 34 | 35 | 36 | 37 | 38 | 39 | 40 | 41 | 42 | 43 | 44 | 45 | 46 | 47 | 48
var→ | -5.51 | -5.21 | -5.31 | -4.82 | -5.4 | -5.11 | -5.31 | -5.11 | -5.11 | -4.82 | -5.32 | -5.11 | -5.31 | -5.31 | -5.81 | -4.92
→ | 49 | 50 | 51 | 52 | 53 | 54 | 55 | 56 | 57 | 58 | 59 | 60 | 61 | 62 | 63 | 64
 | Average = |  |  |  | Min Lvl |  | (average -1.5) |  |  |  |  | [NAME] |  | (average + 1.5)
Spreadsheet: 718896d1613407660-help-with-vlookup-that-matches-multiple-criteria-sample-2-
Sheet: expenditure

country | expenditure | latest year | expenditure as a share of GDP
Afghanistan | 823864823659856 | 2019
Albania | 47365635 | 2017
Algeria | 93739753975 | 2018
Angola | 378375283965 | 2019
[NAME] and [NAME] | 29375235 | 2016
Argentina | 273957205 | 2017
Armenia | 239750725 | 2019
Aruba | 865836565 | 2018
Azerbaijan | 694766 | 2018
The Bahamas | 496749094 | 2018
Bahrain | 407957459774 | 2018
Spreadsheet: 154741d1336543860-excel-2007-finding-values-from-the-total-sum-5x3
Sheet: Sheet1

 |  |  |  | 1 | 1 | 1 | 3
 |  |  |  | 1 | 0 | 0 | 1
 |  |  |  | 1 | 1 | 1 | 3
 |  |  |  | 1 | 1 | 1 | 3
 |  |  |  | 1 | 0 | 0 | 1
 |  |  |  | 5 | 3 | 3
 |  |  | Error Checker: |  | No Errors
Spreadsheet: 121474d1316090793-how-to-use-multiple-autofilters-nhl94-player-ratings
Sheet: New York R

Rangers
Pos. | Name | Hand | # | Wgt | [NAME] | Spd | Off | Def | [NAME] | Chk | [NAME] | Shot Acc | Endr | Stick Lt | [NAME] | Glove Lt
G | [NAME] Richter | L | 35 | 196 | 55 | 65 | 65 | 65 | 55 | 25 | 25 | 25 | 65 | 65 | 65 | 65
Pos. | Name | Hand | # | Wgt | [NAME] | Spd | Off | Def | [NAME] | Chk | [NAME] | Shot Acc | Endr | ??? | Pass | Aggr
C | [NAME] | L | 11 | 220 | 85 | 65 | 65 | 65 | 55 | 85 | 85 | 55 | 65 | 25 | 85 | 55
C | [NAME] | L | 8 | 188 | 65 | 65 | 65 | 55 | 55 | 45 | 65 | 55 | 65 | 65 | 55 | 45
C | [NAME] | L | 13 | 188 | 65 | 55 | 55 | 85 | 55 | 65 | 55 | 65 | 85 | 45 | 55 | 45
LW | [NAME] | L | 9 | 188 | 65 | 65 | 65 | 55 | 45 | 55 | 55 | 55 | 65 | 85 | 55 | 65
LW | [NAME] | L | 10 | 212 | 85 | 85 | 55 | 65 | 65 | 85 | 65 | 45 | 65 | 65 | 65 | 55
LW | [NAME] | L | 12 | 212 | 65 | 55 | 55 | 55 | 65 | 45 | 65 | 55 | 55 | 65 | 65 | 45
LW | [NAME] | L | 29 | 204 | 45 | 65 | 45 | 55 | 45 | 65 | 55 | 45 | 55 | 45 | 45 | 45
LW | [NAME] | L | 20 | 204 | 55 | 55 | 45 | 55 | 45 | 45 | 55 | 55 | 55 | 25 | 55 | 35
LW | [NAME] | L | 18 | 196 | 45 | 55 | 35 | 25 | 35 | 55 | 35 | 35 | 35 | 85 | 35 | 65
RW | [NAME] | R | 22 | 196 | 85 | 85 | 65 | 65 | 85 | 45 | 85 | 55 | 85 | 85 | 85 | 45
RW | [NAME] | R | 33 | 188 | 65 | 65 | 65 | 55 | 55 | 35 | 55 | 55 | 65 | 55 | 55 | 45
RW | Alexei Kovalev | L | 27 | 196 | 65 | 55 | 55 | 55 | 55 | 35 | 55 | 65 | 55 | 65 | 55 | 55
RW | [NAME] | R | 37 | 196 | 35 | 35 | 45 | 55 | 35 | 45 | 35 | 45 | 45 | 55 | 35 | 45
RW | [NAME] | R | 26 | 204 | 45 | 35 | 35 | 55 | 45 | 55 | 45 | 35 | 45 | 65 | 45 | 65
Pos. | Name | Hand | # | Wgt | [NAME] | Spd | Off | Def | [NAME] | Chk | [NAME] | Shot Acc | Endr | ??? | Pass | Aggr
D | [NAME] | L | 4 | 204 | 65 | 55 | 45 | 65 | 55 | 65 | 65 | 35 | 55 | 35 | 55 | 55
D | [NAME] | L | 2 | 188 | 100 | 55 | 65 | 65 | 65 | 45 | 85 | 35 | 85 | 45 | 85 | 45
D | [NAME] | L | 5 | 212 | 45 | 55 | 55 | 45 | 45 | 45 | 55 | 35 | 45 | 65 | 55 | 45
D | [NAME] | L | 24 | 220 | 45 | 45 | 45 | 45 | 45 | 55 | 45 | 25 | 45 | 35 | 45 | 65
D | [NAME] | R | 3 | 212 | 65 | 65 | 55 | 65 | 65 | 65 | 65 | 35 | 65 | 45 | 65 | 55
D | [NAME] | R | 21 | 196 | 55 | 55 | 55 | 65 | 55 | 55 | 55 | 45 | 55 | 35 | 55 | 25
D | [NAME] | R | 23 | 228 | 45 | 45 | 45 | 65 | 45 | 55 | 45 | 25 | 55 | 25 | 45 | 65
Spreadsheet: 863907d1711303508-pull-only-jan-data-book6a
Sheet: Sheet1

 |  |  |  |  |  |  |  |  |  |  |  |  |  |  | Year | Annual | Jan Dividend | Last Dividend of year
c1 | c2 | c3 | c4 | c5 | c52 | c6 | c7 | c8 | c11 | c13 | c113 | c22 | c23
2022-11-11 00:00:00 | p | 72 | 8.95 |  |  |  |  |  |  | 0 |  |  |  |  |  |  |  | 0
2022-12-15 00:00:00 | p | 2 | 9 |  |  |  |  |  |  | 0 |  |  |  |  | 2023 |  |  | 9.370055099999998
2022-12-28 00:00:00 | p | 6 | 7.95 |  |  |  |  |  |  | 0 |  |  |  |  | 2024 |  |  | 9.6699942
2023-01-03 00:00:00 | d | 0.73086 | 8.1 |  |  |  |  |  |  | 0
2023-01-13 00:00:00 | p | 3 | 8.65 |  |  |  |  |  |  | 0
2023-02-01 00:00:00 | d | 0.70244 | 9.1964 |  |  |  |  |  |  | 0
2023-02-21 00:00:00 | p | 5 | 9.25 |  |  |  |  |  |  | 0
2023-03-01 00:00:00 | d | 0.72007 | 9.374 |  |  |  |  |  |  | 0
2023-03-31 00:00:00 | p | 19 | 8.45 |  |  |  |  |  |  | 0
2023-04-03 00:00:00 | d | 0.84557 | 8.5267
2023-05-01 00:00:00 | d | 0.92364 | 9.5275 |  |  |  |  |  |  | 0
2023-06-01 00:00:00 | d | 0.9682 | 9.1613 |  |  |  |  |  |  | 0
2023-07-03 00:00:00 | d | 0.91793 | 9.7501 |  |  |  |  |  |  | 0
2023-08-01 00:00:00 | d | 0.94947 | 8.833 |  |  |  |  |  |  | 0
2023-09-01 00:00:00 | d | 0.998 | 9.1182 |  |  |  |  |  |  | 0
2023-10-06 00:00:00 | d | 1.092 | 8.4066 |  |  |  |  |  |  | 0
2023-11-09 00:00:00 | d | 1.31 | 7.0763 |  |  |  |  |  |  | 0
2023-12-07 00:00:00 | d | 1.257 | 7.4543 |  |  |  |  |  |  | 0
2024-01-09 00:00:00 | d | 1.272 | 7.445 |  |  |  |  |  |  | 0
2024-02-09 00:00:00 | d | 1.249 | 7.6621 |  |  |  |  |  |  | 0
2024-03-08 00:00:00 | d | 1.234 | 7.8363 |  |  |  |  |  |  | 0
 |  |  |  |  |  |  |  |  |  | 0
 |  |  |  |  |  |  |  |  |  | 0
 |  |  |  |  |  |  |  |  |  | 0
 |  |  |  |  |  |  |  |  |  | 0
Spreadsheet: 65571d1266301366-automatic-filling-karratha-baby-and-toddler-equipment-hire
Sheet: Spending-Earning

Date | Description | Company (if Outgoing) | Invoice # | Receipt # | Incoming | Outgoing
 |  |  |  |  | 0 | 0
 |  |  |  |  | 0 | 0
 |  |  |  |  | 0 | 0
 |  |  |  |  | 0 | 0
 |  |  |  |  | 0 | 0
 |  |  |  |  | 0 | 0
 |  |  |  |  | 0 | 0
 |  |  |  |  | 0 | 0
 |  |  |  |  | 0 | 0
 |  |  |  |  | 0 | 0
 |  |  |  |  | 0 | 0
 |  |  |  |  | 0 | 0
 |  |  |  |  | 0 | 0
 |  |  |  |  | 0 | 0
 |  |  |  |  | 0 | 0
 |  |  |  |  | 0 | 0
 |  |  |  |  | 0 | 0
 |  |  |  |  | 0 | 0
 |  |  |  |  | 0 | 0
 |  |  |  |  | 0 | 0
 |  |  |  |  | 0 | 0
 |  |  |  |  | 0 | 0
 |  |  |  |  | 0 | 0
 |  |  |  |  | 20 | 10
Spreadsheet: 157221d1337667287-excel-2007-lookup-to-return-multiple-rows-of-data-test-template
Sheet: Job 3

 | # | Date | Description | Requested | Spent
 | 1 | 11/16-11/19 | Misc | 1798
 | 1 |  | Misc |  | 224
 | 1 |  | Misc |  | 787.8
 | 1 |  | Misc |  | 521.82
 | 1 |  | Misc |  | 20
 | 1 |  | Misc |  | 210.01
 | 1 |  | Misc |  | 34.5
 | 1 | 11/30 - 12/3 | Misc | 1048
 | 1 |  | Misc |  | 448
 | 1 |  | Misc |  | 600.2
 |  |  | Total
 |  |  | Remaining Amount for Invoice Period
 |  |  | Expense
 | 2 | 2010-11-30 00:00:00 | Expense | 251.9 | 251.9
 | 2 | 2010-12-03 00:00:00 | Expense | 606.09 | 606.09
 | 2 | 2010-11-30 00:00:00 | Expense | 38 | 38
 | 2 | 2010-12-03 00:00:00 | Expense | 60 | 60
 | 2 | 2010-11-30 00:00:00 | Expense | 782.8 | 782.8
 | 2 |  | Expense
 | 2 | 2011-01-27 00:00:00 | Expense | 725.8 | 725.8
 | 2 | 2011-01-31 00:00:00 | Expense | 519.93 | 519.93
 | 2 |  | Expense | 224 | 224
 | 2 | 2011-02-11 00:00:00 | Expense | 46 | 46
 | 2 | 2011-02-11 00:00:00 | Expense | 49 | 49
 | 2 | 2010-02-08 00:00:00 | Expense | 20 | 20
 | 2 | 2011-02-09 00:00:00 | Expense | 158.12 | 158.12
 | 2 |  | Expense
 | 2 | 2011-02-08 00:00:00 | Expense | 347.8 | 347.8
 | 2 | 2011-02-08 00:00:00 | Expense | 317.2 | 317.2
 | 2 | 2011-02-09 00:00:00 | Expense | 212.4 | 212.4
 | 2 |  | Expense
 | 2 | 2011-02-22 00:00:00 | Expense | 275.4 | 275.4
 | 2 | 2011-02-22 00:00:00 | Expense | 275.4 | 275.4
 | 2 | 2011-02-10 00:00:00 | Expense | -142 |  | 142 | Req3
 | 2 | 2011-02-10 00:00:00 | Expense | -56 |  | 56 | Req3
 | 2 | 2011-02-10 00:00:00 | Expense | -290 |  | 290 | Req3
 | 2 | 2011-02-10 00:00:00 | Expense | -62.6 |  | 62.6 | Req3
 |  |  | Total
 |  |  | Remaining Amount for Invoice Period
 | 3
 | 3
 | 3
 | 3
 | 3
 | 3
 | 3
 | 3
 | 3
 | 3 |  |  |  |  | **Added back in due to the fact that [NAME] subtracted them from R#2
 | 3 |  |  |  |  | when they should not have been.  OFCA received the funds from DHS
 | 3 |  |  |  |  | and paid the reimbursements.
 | 3
 | 3
 | 3
 | 3
 | 3
 | 3
 | 3
 |  |  | Total
 |  |  | Remaining Amount for Invoice Period
 | 4
 | 4
 | 4
 | 4
 | 4
 | 4
 | 4
 | 4
 | 4
 | 4
 | 4
 | 4
 | 4
 | 4
 | 4
 | 4
 | 4
 | 4
 | 4
 |  |  | Total
 |  |  | Remaining Amount for Invoice Period
 | 5
 | 5
 | 5
 | 5
 | 5
 | 5
 | 5
 | 5
 | 5
 | 5
 | 5
 | 5
 | 5
 | 5
 |  |  | Total
 |  |  | Remaining Amount for Invoice Period
 | 6
 |  |  | Total
 |  |  | Remaining Amount for Invoice Period
 | 7
 | 7
 | 7
 | 7
 |  |  | Total
 |  |  | Remaining Amount for Invoice Period
 |  |  | Total
 |  |  | Remaining Amount for Invoice Period
 |  |  | Total
 |  |  | Remaining Amount for Invoice Period
Spreadsheet: 141940d1329521589-creating-a-conditional-list-with-multiple-factors-and-sources-amenity1
Sheet: Billing

SALES PROMO - 9735 |  |  |  |  |  | Rooms Promo - 9740
Item |  |  |  | Quantity |  | Item |  |  |  | Quantity
Total Covers Sales |  |  |  |  |  | Total Covers Rooms
x $1.50 Amenity Tip |  |  |  |  |  | x $1.50 Amenity Tip
Total Amenity Tip Sales |  |  |  |  |  | Total Amenity Tip Rooms