tianzl66/Sheetpedia huggingface dataset:
Spreadsheet: 744226d1629094803-want-to-pull-in-data-automatically-from-other-sheets-working-lessonplan
Sheet: Lesson Plan

SCHOOL: |  |  |  |  | NAME OF EDUCATOR: |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | Monday
WEEK | 2 |  |  |  | DATE: |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | Tuesday
CLASS: |  |  |  |  | DAY: | Tuesday |  |  |  |  | I am planning to computerise my lesson plan |  |  |  |  |  |  |  |  |  | Wednesday
PERIOD: | 1 |  |  |  | SUBJECT: |  |  |  |  |  | the following parameters are to be entered |  |  |  |  |  |  |  |  |  | Thursday
DURATION: |  |  |  |  | TOPIC: |  |  |  |  |  | 1. day for this I have made a list so that I can choose which day for example in the day list I have chosen Monday |  |  |  |  |  |  |  |  |  | Friday
ROLL: |  |  |  |  | SUB TOPIC: |  |  |  |  |  | 2. I have chosen week 2
topic |  |  |  |  |  |  |  |  |  |  | 3. when I choose period "3" the class is automatically inserted in the class field
LEARNING OUTCOMES |  |  |  |  |  |  |  |  |  |  | 4. my issue here is as follows " I have a sheet called scheme of work G8 as we can see the class is [NAME] . I want to be able to call the values from this particular tab and populate my lesson plan
STUDENT'S PRIOR KNOWLEDGE |  |  |  |  |  |  |  |  |  |  | 5. in week 2 the topic is "computer system " I want computer system to be automatically added to cell b7 and so on  depending on what fields are required
TEACHING STRATEGIES | Brainstorming |  |  | Questioning |  |  | Cooperative Learning |  |  |  | 6. now if I choose the day as Tuesday the system should be able to check what I am doing on Tuesday and consequently pull in detais for the classe im having on Tuesday
 | Oral Presentation |  |  | Other:
TEACHING AIDS & RESOURCES
PROCEDURES
EVALUATION/ ASSESSMENT | Questioning |  |  | Homework |  |  | Classwork
 | Student Interaction |  |  | Other:
SELF- REFLECTION/ REMARKS
Spreadsheet: 793182d1661350528-creating-a-results-list-of-multiple-races-finn-resultaten-2022
Sheet: 14 aug

 |  | Place | 1e wedstrijd | 2e wedstrijd |  | place | sailnumber | points | points overall | count
 |  | 1 | 250 | 220 |  | 1 |  | 4 | 17
 |  | 2 | 147 | 147 |  | 2 | 250 | 4 | 16
 |  | 3 | 157 | 250 |  | 3 | 220 | 8 | 15
 |  | 4 | 140 | 960 |  | 4 | 145 | 11 | 14
 |  | 5 | 151 | 145 |  | 5 | 151 | 12 | 13
 |  | 6 | 145 | 108 |  | 6 | 960 | 12 | 12
 |  | 7 | 220 | 151 |  | 7 | 140 | 14 | 11
 |  | 8 | 960 | 113 |  | 8 | 157 | 14 | 10
 |  | 9 | 49 | 49 |  | 9 | 108 | 17 | 9
 |  | 10 | 47 | 140 |  | 10 | 49 | 18 | 8
 |  | 11 | 108 | 157 |  | 11 | 47 | 22 | 7
 |  | 12 | 2 | 47 |  | 12 | 113 | 23 | 6
 |  | 13 | 1018 | 1013 |  | 13 | 2 | 27 | 5
 |  | 14 | 150 | 150 |  | 14 | 150 | 28 | 4
 |  | 15 | 864 | 864 |  | 15 | 1013 | 28 | 3
 |  | 15 | 113 | 1018 |  | 16 | 1018 | 28 | 2
 |  | 15 | 1013 | 2 |  | 17 | 864 | 30 | 1
Spreadsheet: 149999d1334242633-sumif-formula-that-looks-at-specific-names-across-two-seperate-ranges-and-4-different-sheets-excel-help-example
Sheet: Sheet3

PAYEE 19R66: |  |  |  |  |  |  |  | Reclassification |  |  |  |  |  |  | Issue Identification
Tran | [NAME] | Date | Amount | Esc Payee | C/A Payee | RSN | Description | Date | Amount | Esc Payee | C/A Payee | RSN | Description | Adjustment | Category | Avoidance | SubClassification
 |  |  |  |  |  |  |  |  | 500 |  |  |  |  | 500 |  |  | [NAME]
 |  |  |  |  |  |  |  |  | 50 |  |  |  |  | 50 |  |  | Ins fee
 |  |  |  |  |  |  |  |  | 250 |  |  |  |  | 250 |  |  | BPO
Total Deposits: |  |  | 0 |  |  |  |  | Deposits: |  |  |  |  |  | 800
 |  |  |  |  |  |  |  |  | 100 |  |  |  |  | 100 |  |  | [NAME] fees
 |  |  |  |  |  |  |  |  | 350 |  |  |  |  | 350 |  |  | Prop ins
 |  |  |  |  |  |  |  |  | 150 |  |  |  |  | 150 |  |  | Prop appr
Total Disbursement: |  |  | 0 |  |  |  |  | Disbursement: |  |  |  |  |  | 600
Balance: |  |  | 0 |  |  |  |  | Balance: |  |  |  |  |  | 1400
Grand Deposits: |  |  | 0 |  |  |  |  | Grand Deposits: |  |  |  |  |  | 800
Grand Disbursement: |  |  | 0 |  |  |  |  | Grand Disbursement: |  |  |  |  |  | 600
Grand Balance: |  |  | 0 |  |  |  |  | Grand Balance: |  |  |  |  |  | 1400
Spreadsheet: 874649d1721213224-problem-with-loop-in-excel-circular-references-that-creates-errors-ex_model
Sheet: Sheet2

size | 5 | MW
efficiency  system | 0.6
[NAME] | 33 | kwh/kg |  |  | system is dependent on tank inventory
[NAME] - load | 0.8 |  |  |  | tank - start with 100 just the 1h, I dont want tank to go under min, this is why i want to adjust electrolyzer up and down
min -load | 0.2
[NAME] tank | 350 | [NAME]
min-tank | 10 | [NAME]
start tank | 100 | [NAME]
energy (kwh) | system size to meet energy (kw) | system (kW) | biogas produced (kg) | biogas required (kg) | diff [NAME] | energy from system (kwh) | additional heat | [NAME] to tank | adding to tank | Tank inventory (kg)
4567
4568
4569
4570
Spreadsheet: 759896d1639786732-2-criteria-vlookup-from-messy-less-messy-payroll-file-uploadtest
Sheet: Daily Export

 | 2021-08-02 00:00:00 |  | 2021-08-03 00:00:00 |  | 2021-08-04 00:00:00 |  | 2021-08-05 00:00:00
 | Monday |  | Tuesday |  | Wednesday |  | Thursday
Employee | SL | DL | SL | DL | SL | DL | SL | DL
Person1 |  | 8.5 |  | 8.5 | 8.5
Person2 | 8.5 |  |  |  |  | 8.5
Spreadsheet: 100977d1299171930-if-and-if-and-formula-formula-problem
Sheet: Sheet1

Industry Leadership | NEE-UKI
Industry Leadership | NEE-UKI
Industry Leadership | SWE-BeNeLux
Industry Leadership | SWE-France
Industry Leadership | SWE-Italy | #N/A
Industry Leadership | SWE-Italy
Industry Leadership | SWE-Italy
LM Coordinated Audiences | GMU-ASEAN | STG Led
LM Coordinated Audiences | GMU-ASEAN | STG Led
LM Coordinated Audiences | GMU-ASEAN | STG Led
LM Coordinated Audiences | GMU-ASEAN | STG Led
LM Coordinated Audiences | GMU-ASEAN | STG Led
LM Coordinated Audiences | GMU-ASEAN | STG Led
LM Coordinated Audiences | GMU-CEE | STG Led
LM Coordinated Audiences | GMU-CEE | STG Led
LM Coordinated Audiences | GMU-GCG | STG Led
LM Coordinated Audiences | GMU-GCG | STG Led
LM Coordinated Audiences | GMU-GCG | STG Led
LM Coordinated Audiences | GMU-India-South Asia | STG Led
LM Coordinated Audiences | GMU-India-South Asia | STG Led
Industry Leadership | GMU-ASEAN
Industry Leadership | GMU-ASEAN
Industry Leadership | GMU-ASEAN
Industry Leadership | GMU-ASEAN
Industry Leadership | GMU-A/NZ
Industry Leadership | GMU-A/NZ
Industry Leadership | GMU-A/NZ
Industry Leadership | GMU-A/NZ
Industry Leadership | GMU-A/NZ
Industry Leadership | GMU-A/NZ
Industry Leadership | GMU-A/NZ
Industry Leadership | GMU-A/NZ
Industry Leadership | GMU-CEE
Industry Leadership | GMU-CEE
Industry Leadership | GMU-CEE
Industry Leadership | GMU-CEE
Industry Leadership | GMU-GCG
Industry Leadership | GMU-India-South Asia
Industry Leadership | GMU-Korea
Industry Leadership | GMU-Korea
Industry Leadership | GMU-MEA
Industry Leadership | GMU-MEA
Industry Leadership | GMU-MEA
Industry Leadership | GMU-MEA
Spreadsheet: 293286d1390936416-cannot-format-cells-into-currency-1-1-2014-copy
Sheet: CC-Summary

CREATIVE COMMUNITIES
 |  | ARTS |  |  | ARTS EDUCATION |  |  | GREAT PUBLIC SPACES |  |  | TRANSITION |  |  | TOTAL CC
 |  | 2013 | 2014 | 2015-16 | 2013 | 2014 | 2015 | 2013 | 2014 | 2015 | 2013 | 2014 | 2015 | 2013 | 2014 | 2015
ACTUAL | BUDGET | 8005084 | 8000000 | 8000000 | 1700000 | 1700000 | 1700000 | 7500000 | 7500000 | 7500000 | 2000000 | 2000000 | 2000000
 | Prior Year Commitments | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0
 | Available
 | % Remaining
 | Current Year Commitments | 2666251 | 1404830 | 1164633 | 945000 | 435000 | 405000 | 6967500 | 3760000 | 4000000 | 1432500 | 0 | 0
 | Total Commitments
 | Available
 | % Remaining
PIPELINE | Pending Final Approval
 | Total Commitments and Pending Final Approval
 | Available
 | % Remaining
 | In Process |  |  |  |  |  |  |  |  |  |  | 0 | 0
 | Total Commitments, Pending Final Approval, In Process
 | Available
 | % Remaining
 | Note: Budgets for 2014 and 2015 are assumed
 | In Process = Staff Development, LOI, Invited Inquiries
Spreadsheet: 45159d1243945802-bar-chart-help-685860
Sheet: Sheet1

 | Series 1 | Series 2 | Series 3 | Series 4 | Series 5 | Amber Band | Red Band
a | 4 | 3 | 6 | 9 | 5 | 7 | 3
b | 2 | 1 | 2 | 1 | 8 | 7 | 3
c | 2 | 2 | 8 | 6 | 7 | 7 | 3
 | Create Column chart based on A1:H4 plot by columns
 | Move first 5 series to secondary axis
 | format plot area a green or top colour
 | format Amber band with colour
 | Set Overlap =100
 | set gap = 0
Spreadsheet: 155072d1336662190-x-axis-probklem-in-simple-line-charts-export-m
Sheet: MAURITIUS

MAURITIUS
 | 1977 | 1978 | 1979 | 1980 | 1981 | 1982 | 1983 | 1984 | 1985 | 1986 | 1987 | 1988 | 1989 | 1990
Ambassadeurs |  |  |  |  |  |  |  |  |  |  |  |  | 50
Total | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 50 | 0
%  Total Sales | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0
% Export Sales | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0
 | 1991 | 1992 | 1993 | 1994 | 1995 | 1996 | 1997 | 1998 | 1999 | 2000 | 2001 | 2002 | 2003 | 2004
Aremo |  |  |  |  |  |  |  |  |  | 1050 | 2150 |  | 2220 | 1126
Kodalor |  |  | 250 |  |  |  |  |  |  |  | 520 | 1000
General |  |  |  |  |  |  |  |  |  | 200
Total | 0 | 0 | 250 | 0 | 0 | 0 | 0 | 0 | 0 | 1250 | 2670 | 1000 | 2220 | 1126
%  Total Sales | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0.0007233796296296296 | 0.001527299185898052 | 0.0005674670032124307 | 0.0015107364363769 | 0.0006802684099904001
% Export Sales | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0.001015434606011373 | 0.01497896213183731 | 0.0007049690448092424 | 0.001223045482417068 | 0.0005734686705814646
 | 2005 | 2006 | 2007 | 2008 | 2009 | 2010 | 2011 | 2012 | 2013 | 2014 | 2015 | 2016 | 2017 | 2018
Allegra Creations |  |  |  |  |  | 254 | 302
General | 25 |  | 27 |  | 90
Aremo | 1205 | 250 | 0 | 1750
Kodalor | 986 |  | 1155
Total | 2216 | 250 | 1182 | 1750 | 90 | 254 | 302
%  Total Sales | 0 | 0 | 0.000666109509079546 | 0.0009199491767506239 | 0 | 0
% Export Sales | 0 | 0 | 0.0007708566617471838 | 0.001050912191782467 | 0 | 0
Chart data
77 | 0
78 | 0
79 | 0
80 | 0
81 | 0
82 | 0
83 | 0
84 | 0
85 | 0
86 | 0
87 | 0
88 | 0
89 | 50
90 | 0
91 | 0
92 | 0
93 | 250
94 | 0
95 | 0
96 | 0
97 | 0
98 | 0
99 | 0
0 | 1250
1 | 2670
2 | 1000
3 | 2220
4 | 1126
05 | 2216
06 | 250
07 | 1182
08 | 1750
09 | 90
10 | 254
11 | 302
12 | 0
13 | 0
14 | 0
15 | 0
16 | 0
17 | 0
18 | 0
Spreadsheet: 104770d1302224896-question-about-linking-formulas-from-one-page-to-another-new-accts-payable-2011
Sheet: Aug

august expenses
total
advertising
date | po# | suppplier.description | amount
subtotal
x
educational
date | po# | suppplier.description | amount
subtotal
x
supplies. blanks
date | po# | suppplier.description | amount
subtotal
x
supplies. designs
date | po# | suppplier.description | amount
subtotal
s
supplies. notions
date | po# | suppplier.description | amount
subtotal
supplies. machinery
date | po# | suppplier.description | amount
subtotal
supplies. office
date | po# | suppplier.description | amount
subtotal
etsy maintenance
date | po# | suppplier.description | amount
subtotal
website maintenance
date | po# | suppplier.description | amount
subtotal
shipping
date | po# | suppplier.description | amount
subtotal
utilities
date | po# | suppplier.description | amount
subtotal
Spreadsheet: 346c3b30-51fb-4be2-82d6-37e462978879
Sheet: Other - Rural Housing & TX VET

 |  | TIB-The Independent BankersBank
 |  | 350 [NAME]., [NAME]
 |  | [PHONE] Toll Free//[PHONE] fax
 |  | Rate Sheet Effective: |  |  | 2014-06-20 09:49:30.780000
Product: FMHA Rural Housing |  |  |  |  |  | Loan Level Price Adjustment
Rate | 15 Day | 30 Day | 45 Day | 60 Day
4.25 | 100.95 | 100.95 | 100.825 | 100.45 |  | Price adjustments are cumulative
4.125 | 100.625 | 100.625 | 100.5 | 100.125
4 | 100.5 | 100.5 | 100.375 | 100 |  | and are added to price quote
3.875 | 100 | 100 | 99.875 | 99.5
3.75 | 99.5 | 99.5 | 99.375 |  |  | Credit Score Adjustment
 |  |  |  |  |  | 640 - 659 | -0.375
 |  |  |  |  |  | 660 - 719 | 0
 |  |  |  |  |  | 720 + | 0.125
 |  |  |  |  |  | Prices Do Not Include SRP
 |  |  |  |  |  | SRPs
 |  |  |  |  |  | See Government [NAME]
 |  |  |  |  |  | Expiration Dates
 |  |  |  |  |  | 15 Day | 2014-07-05 09:49:30.780000
 |  |  |  |  |  | 30 Day | 2014-07-20 09:49:30.780000
 |  |  |  |  |  | 45 Day | 2014-08-04 09:49:30.780000
 |  |  |  |  |  | 60 Day | 2014-08-19 09:49:30.780000
 |  |  |  |  |  | See Product Matrix for Complete Details
Spreadsheet: 268fb1c8-2960-41ce-a20e-10448a2c158f
Sheet: Sheet5

Department / Read date  6/3/2013 | General Ledger | GL Description | Building | Room | Model | Device Type | [NAME] | Total BW Click Count | Total Color Click Count | BW Click Charge | Color Click Charge | Device Total Click Charge | Serial Number | IP Address | CPC BW | CPC Color | Prev BW Click Count | Current BW Click Count | Prev Color Click Count | Current Color Click Count
Stone [NAME] House | 30_00_031_70275_5505 | Stone [NAME] House | Stone [NAME] House | [NAME] | AF SPC242DN | PTR | 17099827 | 486 | 80 | 12.7332 | 9.44 | 22.1732 | T202P901345 | 144.75.181.15 | 0.0262 | 0.118 | 1098 | 1584 | 126 | 206
Stone [NAME] House | 30_00_031_70275_5505 | Stone [NAME] House | Stone [NAME] House | [NAME] | AF SP4310N | PTR | 17099842 | 635 | 0 | 16.637 | 0 | 16.637 | [NAME] | 144.75.181.14 | 0.0262 | 0.118 | 235 | 870 | 0 | 0
Stone [NAME] House | 30_00_031_70275_5505 | Stone [NAME] House | Stone [NAME] House | [NAME] | AF MPC2051 | MFP | 17099841 | 449 | 187 | 9.2943 | 16.269 | 25.5633 | V9735000740 | 144.75.181.13 | 0.0207 | 0.087 | 99 | 548 | 10 | 197
Spreadsheet: 112284d1308406361-equation-problem-example1
Sheet: Sheet1

Location | Nature | Code | [NAME] | Dispatch | Responding | Arriving | Transporting | At Hosp | Total Response | Total On Scene | Total Trans | Total Patient Care
111 Ave A | [NAME] | 26B99 (ALS) | Xport | 20:08:00 | 20:10:00 | 20:13:00 | 20:39:00 | 20:46:00
111 Ave B | Falls | 17D03 (ALS) | Cancel | 03:35:00 | 03:35:00 | 03:35:00 | 03:35:00 | 03:35:00
111 Ave C | Falls | 17A01G (BLS) | Xport | 18:02:00 | 18:03:00 | 18:16:00 | 18:23:00 | 18:35:00
 |  |  |  |  | Line 3 has a total repsonse time under 10 minutes, I want Col. N to say "Under 10"
 |  |  |  |  | Line 5 has a total response time OVER 10 minutes, I want Col. N to say "Over 10". [NAME] would be nice too, but not required.
 |  |  |  |  | Col. D has "Dispo".  I want a box to calculate to total # of "Xport", or "Cancel", and give me a numerical value.
Spreadsheet: c6c92bf5-d9b9-4165-94f2-3a7d401374e3
Sheet: PAG 16 - table 2

Special items | 4Q10 | 4Q11 | YTD10 | YTD11
R$ million
Restructuring | -10.815 | -5.983000000000001 | -45.692 | -12.477
Proceeds from sale of property | 0 | -7.509 | 0 | 35.564
Impairment disposal Venezuela | -55.886 | 0 | -55.886 | 0
[NAME] closure expenses | 0.5600000000000023 | 0 | -46.171 | 0
Others | -0.3870000000000002 | 0 | -3.076 | 0.017
 | -66.52799999999999 | -13.492 | -150.825 | 23.104
Spreadsheet: kate_symes__18879__Palo
Sheet: DJ Palo Verde Electricity Index

 |  |  | Firm | Volume | Firm | Volume | Non Firm | Volume | Non Firm | Volume |  | Sunday & NERC | Volume
 | DATE |  | On [NAME] | [NAME] | [NAME] | [NAME] | On [NAME] | [NAME] | [NAME] | [NAME] |  | 24 HOUR | [NAME]
 | 2001-03-19 00:00:00 |  | 297.33 | 24848 | 176.6 | 9000
 | 2001-03-18 00:00:00 |  | 220 | 0 | 185 | 0 | 170.47 | 4949 | 156.95 | 2582 |  | 178.66 | 28200
 | 2001-03-17 00:00:00 |  | 195.41 | 17152 | 121.88 | 8832 | 191.77 | 10872 | 180.55 | 1883
 | 2001-03-16 00:00:00 |  | 195.98 | 16352 | 121.88 | 8832 | 219.02 | 5921 | 173.76 | 3142
 | 2001-03-15 00:00:00 |  | 180.19 | 17472 | 98.04 | 5160 | 188.69 | 6005 | 136.45 | 3320
 | 2001-03-14 00:00:00 |  | 162.56 | 17184 | 81.84 | 6960 | 194.59 | 4065 | 117.41 | 1400
 | 2001-03-13 00:00:00 |  | 157.46 | 17840 | 69.39 | 7288 | 171.29 | 4137 | 134.75 | 1330
 | 2001-03-12 00:00:00 |  | 166.55 | 12544 | 91.58 | 6920 | 186.95 | 2928 | 114.77 | 1215
 | 2001-03-11 00:00:00 |  | 163 | 3200 | 90 | 1600 | 104.25 | 1435 | 110.05 | 945 |  | 93.34 | 17760
 | 2001-03-10 00:00:00 |  | 148.73 | 18400 | 66.56 | 5864 | 109.79 | 3007 | 124.99 | 2735
 | 2001-03-09 00:00:00 |  | 148.73 | 18400 | 66.56 | 5864 | 175.73 | 6415 | 122.41 | 1756
 | 2001-03-08 00:00:00 |  | 185.11 | 22848 | 92.66 | 8640 | 191.53 | 4219 | 145.14 | 1004
 | 2001-03-07 00:00:00 |  | 300.27 | 25616 | 169.6 | 6824 | 225.26 | 4337 | 151.01 | 1201
 | 2001-03-06 00:00:00 |  | 309.17 | 20320 | 175.44 | 6728 | 215.32 | 7762 | 192.69 | 3047
 | 2001-03-05 00:00:00 |  | 276.65 | 9792 | 162.76 | 4656 | 215.88 | 4042 | 160.99 | 832
 | 2001-03-04 00:00:00 |  | 240 | 800 | 165 | 0 | 168.1 | 2613 | 141.45 | 365 |  | 163.88 | 14568
 | 2001-03-03 00:00:00 |  | 239.87 | 18240 | 148.58 | 7800 | 188.15 | 5032 | 117.4 | 2417
 | 2001-03-02 00:00:00 |  | 242.68 | 15680 | 149.84 | 6728 | 220.44 | 3332 | 159.56 | 867
 | 2001-03-01 00:00:00 |  | 254.01 | 12752 | 142.32 | 4776 | 234.93 | 3755 | 151.21 | 1609
 | 2001-02-28 00:00:00 |  | 178.77 | 16400 | 103.09 | 5920 | 271.72 | 2187 | 185.29 | 705
 | 2001-02-27 00:00:00 |  | 182.08 | 17920 | 98.83 | 5248 | 173.98 | 1198 | 145.57 | 1235
 | 2001-02-26 00:00:00 |  | 197.33 | 10400 | 128.16 | 4152 | 207.88 | 3693 | 115.94 | 1181
 | 2001-02-25 00:00:00 |  | 150 | 0 | 125 | 0 | 146.95 | 3690 | 109.13 | 1615 |  | 128.16 | 12456
 | 2001-02-24 00:00:00 |  | 183.8 | 14608 | 102.52 | 6472 | 184.67 | 3635 | 150.17 | 855
 | 2001-02-23 00:00:00 |  | 183.8 | 14608 | 102.52 | 6472 | 238.26 | 4340 | 143.66 | 910
 | 2001-02-22 00:00:00 |  | 216.97 | 18320 | 115.4 | 7080 | 206.96 | 2653 | 104.69 | 565
 | 2001-02-21 00:00:00 |  | 218.21 | 20720 | 137.88 | 10600 | 175.48 | 1613 | 94.66 | 1119
 | 2001-02-20 00:00:00 |  | 257.07 | 16960 | 162.15 | 8000 | 139.51 | 4942 | 140.75 | 1333
 | 2001-02-19 00:00:00 |  | 256.44 | 17088 | 163.04 | 8192 | 241.52 | 6020 | 167.98 | 773
 | 2001-02-18 00:00:00 |  | 345 | 400 | 242.5 | 0 | 168.63 | 565 | 156.11 | 1125 |  | 248.98 | 14640
 | 2001-02-17 00:00:00 |  | 317.77 | 5920 | 248.95 | 4888 | 281.44 | 2185 | 224.69 | 964
Spreadsheet: 48527d1247743497-lookup-nutritional_content
Sheet: Diet Sheet

Meal 1 | Description | No. Off | Cals | Protein (g) | Fat (g) | Carbs (g)
 |  |  |  |  |  |  |  | Training 1-2 hours, 3-6 times per week
 |  |  |  |  |  |  |  | Body weight (15/07/09) = 226lbs/101kg
 |  |  |  |  |  |  |  | Daily Intake Requirements
Subtotal |  |  | 0 | 0 | 0 | 0
Meal 2 |  |  |  |  |  |  |  | Type | [NAME]* | Cals* | %
 |  |  |  |  |  |  |  | Protein | 260 | 1040 | 40.24767801857585
 |  |  |  |  |  |  |  | Carbs | 260 | 1040 | 40.24767801857585
 |  |  |  |  |  |  |  | Fats | 56 | 504 | 19.5046439628483
 |  |  |  |  |  |  |  | Total | 576 | 2584 | 100
Subtotal |  |  | 0 | 0 | 0 | 0
Meal 3
 |  |  |  |  |  |  |  |  |  | *minimum requirements
 |  |  |  |  |  |  |  | [NAME]
Subtotal |  |  | 0 | 0 | 0 | 0
Meal 4 |  |  |  |  |  |  |  | Type | [NAME] | Cals | Kilojoules
 |  |  |  |  |  |  |  | Protein | 1 | 4 | 16.7
 |  |  |  |  |  |  |  | Carbs | 1 | 4 | 16.7
 |  |  |  |  |  |  |  | Fats | 1 | 9 | 37.7
Subtotal |  |  | 0 | 0 | 0 | 0
Meal 5
Subtotal |  |  | 0 | 0 | 0 | 0
Meal 6
Subtotal |  |  | 0 | 0 | 0 | 0
Meal 7
Subtotal |  |  | 0 | 0 | 0 | 0
Meal 8
Total |  |  | 0 | 0 | 0 | 0
Daily Total |  |  | 0 | 0 | 0 | 0
Daily Target |  |  | 0 | 260 | 56 | 260
Spreadsheet: 122932d1317244243-automatically-getting-the-comment-box-to-appear-when-data-is-entered-temp
Sheet: January

Monday |  | Tuesday |  | Wednesday |  | Thursday |  | Friday |  | Saturday |  | Sunday
27 |  | 28 |  | 29 |  | 30 |  | 31 | New Years Day* | 1 | New Years Day | 2
3 |  | 4 |  | 5 |  | 6 |  | 7 |  | 8 |  | 9
10 |  | 11 |  | 12 |  | 13 |  | 14 |  | 15 |  | 16
17 | MLK Day | 18 |  | 19 |  | 20 |  | 21 |  | 22 |  | 23
24 |  | 25 |  | 26 |  | 27 |  | 28 |  | 29 |  | 30
31 |  | 1 |  | 2 |  | 3 |  | 4 |  | 5 |  | 6
 |  |  |  |  |  |  |  |  |  | * | Legal public holiday
Spreadsheet: 4b233acd-ea2e-49e4-9450-51bfb632302c
Sheet: Sheet1

PROG ID | ATHLETE ID | ATHLETE FIRST | ATHLETE LAST | NATIONALITY | START NUMBER | SWIM | T1 | BIKE | T2 | RUN | POSITION | TOTAL TIME
4367 | 10336 | [NAME] | [NAME] | IRL | 0 | 00:00:00 | 00:00:00 | 00:00:00 | 00:00:00 | 00:00:00 | 1 | 00:00:00
4367 | 10412 | [NAME] | Beven | AUS | 0 | 00:00:00 | 00:00:00 | 00:00:00 | 00:00:00 | 00:00:00 | 2 | 00:00:00
4367 | 23784 | Nick | Croft | AUS | 0 | 00:00:00 | 00:00:00 | 00:00:00 | 00:00:00 | 00:00:00 | 3 | 00:00:00
Spreadsheet: 844795d1696470782-invalid-reference-problem-tying-pictures-to-dropdown-list-problem-bvj-
Sheet: Catalog

Group A |  | Men's bracket |  |  |  |  |  | Group A |  | Ladies bracket
Field 1 |  |  | Off. position: R / DJ / FJ / SJ |  |  |  |  | Field 3 |  |  | Off. position: R / DJ / FJ / SJ
Home |  |  |  |  | Away |  |  | Home | Team 5 |  | Team 7 |  | Away
[NAME].: #____ / #____ |  |  | [NAME].: #____ / #____ |  |  |  |  | [NAME].: #____ / #____ |  |  | [NAME].: #____ / #____
TD | PAT | SCORE | SCORE | TD | PAT |  |  | TD | PAT | SCORE | SCORE | TD | PAT
[NAME] result: |  |  |  | MVP: # Team: |  |  |  | [NAME] result: |  |  |  | MVP: # Team:
Full time result: |  |  |  |  |  |  |  | Full time result:
Spreadsheet: 329260d1404241043-obtaining-a-average-price-from-vlookup-formula-assembly-evaluation-before
Sheet: Rockwell

Kit # | SKU | Quantity | Initial Cost | eBay     Price | Amazon Price | Averge Price | Percent | Item Cost | StoneEdge Current
RK2810K | RKW-AMB-RK2810K |  | 65 | 98 | 162 |  |  |  | X
 | RKW-DRL-RK2810K | 1 |  | 35 | 40 |  |  |  | X
 | RKW-CHG-RW9162 | 1 |  | 40 | 37 |  |  |  | X
 | RKW-BAT-RW9161 | 1 |  | 65 | 59 |  |  |  | X
 | - | 1 |  | 0 | 0
[NAME] | RKW-AMB-RK2800K |  | 65 | 93 | 95 |  |  |  | X
 | [NAME] | 1 |  | 62 | 67 |  |  |  | X
 | RKW-BAT-RW9161 | 1 |  | 65 | 59 |  |  |  | X
 | RKW-CHG-RW9162 | 1 |  | 40 | 37 |  |  |  | X
 | - | 1 |  | 0 | 0
- |  |  | 0
 |  | 1 |  | 0 | 0
 |  | 1 |  | 0 | 0
 |  | 1 |  | 0 | 0
 |  | 1 |  | 0 | 0
 |  | 1 |  | 0 | 0
 |  | 1 |  | 0 | 0
 |  | 1 |  | 0 | 0
 |  | 1 |  | 0 | 0
Spreadsheet: 828015d1683185501-count-sort-occurrences-with-multiple-variables-sample
Sheet: Data3

Color | Day | Time | State | Name
Red | Mon | Normal | VA | [NAME]
Yellow | Sat | Normal | VA | [NAME]
Blue | Wed | Normal | FL | [NAME]
Green | Sat | Early | GA | [NAME]
Red | Tue | Normal | VA | [NAME]
Yellow | Sat | Normal | VA | [NAME]
Blue | Mon | Early | SC | Mark
Green | Tue | Normal | TN | [NAME]
Red | Sat | Normal | VA | [NAME]
Yellow | Mon | Early | GA | [NAME]
Blue | Sat | Normal | NC | [NAME]
Green | Sat | Normal | VA | [NAME]
Red | Sat | Early | SC | Mark
Yellow | Tue | Normal | TN | [NAME]
Blue | Wed | Late | VA | [NAME]
Green | Mon | Normal | GA | [NAME]
Red | Tue | Normal | NC | [NAME]
Yellow | Wed | Late | VA | [NAME]
Blue | Mon | Early | SC | Mark
Green | Tue | Normal | TN | Helen
Red | Wed | Late | VA | Helen
Yellow | Mon | Early | GA | Helen
Blue | Tue | Normal | VA | [NAME]
Green | Wed | Late | VA | [NAME]
Spreadsheet: 93513d1293074104-connecting-lines-disappeared-in-line-graph-withlines
Sheet: Sheet2

 |  |  |  |  |  | FEB |  | MAR |  | APR |  | MAY |  | JUN |  | JUL |  | AUG |  | SEP |  | OCT
INFO A |  |  |  |  |  | 0 |  | 8 |  | 62 |  | 41 |  | 108 |  | 432 |  | 1155 |  | 2703 |  | 5901
INFO B |  |  |  |  |  | 0 |  | 75 |  | 225 |  | 450 |  | 900 |  | 1875 |  | 3825 |  | 7725 |  | 15000
INFO C |  |  |  |  |  | 0 |  | 5 |  | 20 |  | 50 |  | 110 |  | 235 |  | 490 |  | 1005 |  | 2015
INFO D |  |  |  |  |  | 0 |  | 8 |  | 62 |  | 116 |  | 167 |  | 218 |  | 245 |  | 272 |  | 299
Spreadsheet: 45830d1244624221-count-book4
Sheet: Sheet1

 | Week 01 | Apple
 | Week 02 | [NAME]
 | Week 03 | Apple
 | Week 04 | Orange
 | Week 05 | Orange
 | Week 06 | [NAME]
 | Week 07 | Apple
 | Week 08 | Apple
 | Week 09 | [NAME]
 | Week 10 | Apple
 | Week 11 | Apple
 | Week 12 | [NAME]
 | Winners: | Apple
 | I want to display as "apple" in row 18