tianzl66/Sheetpedia huggingface dataset:
Spreadsheet: 86659d1286583779-excel-2008-color-of-the-selecting-box-copy-of-test-pages
Sheet: Schedule

Week | 1 | 1 | 1 | 1 | 1 | 1 | 1 | 1
 |  | Mon | Tue | Wed | Thu | Fri | Sat | Sun
 |  | NS | NS | NS | NS | 0 | 0 | 0
220 | 250 | 280 | 310 | 340 | 370 | 400 | 430 | 460 | 490 | 520 | 550 | 580 | 610 | 640 | 670 | 700 | 730 | 760 | 790 | 820 | 850 | 880 | 910 | 940 | 970 | 1000 | 1030 | 1060 | 1090 | 1120 | 1150 | 1180 | 1210 | 1240 | 1270 | 1300 | 1330 | 1360 | 1390 | 1420 | 1450 | 1480 | 1510
0 | 250 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 500 | 500 | 0 | 0 | 0 | 0 | 0 | 0 | 250 | 250 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 1000 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 250 | 250 | 0 | 0 | 0 | 0 | 0 | 0 | 500 | 500 | 0 | 0 | 0 | 0
 | 0 | 0
 | 225 | 250 |  | 250 | 250
 | 275 | 0 |  | 500 | 500
 | 475 | 500 |  | 750 | 250
 | 525 | 0 |  | 1000 | 1000
 | 725 | 250 |  | 1250 | 250
 | 775 | 0 |  | 1500 | 500
 | 975 | 1000 |  | 1750 | 250
 | 1025 | 0 |  | 2000 | 1000
 | 1225 | 250 |  | 2250 | 250
 | 1275 | 0 |  | 2500 | 500
 | 1475 | 500 |  | 2750 | 250
 | 1525 | 0 |  | 3000 | 1000
 | 1725 | 250 |  | 3250 | 250
 | 1775 | 0 |  | 3500 | 500
 | 1975 | 1000 |  | 3750 | 250
 | 2025 | 0 |  | 4000 | 1000
 | 2225 | 250 |  | 4250 | 250
 | 2275 | 0 |  | 4500 | 500
 | 2475 | 500 |  | 4750 | 250
 | 2525 | 0 |  | 5000 | 1000
 | 2725 | 250 |  | 5250 | 250
 | 2775 | 0 |  | 5500 | 500
 | 2975 | 1000 |  | 5750 | 250
 | 3025 | 0 |  | 6000 | 1000
 | 3225 | 250
 | 3275 | 0
 | 3475 | 500
 | 3525 | 0
 | 3725 | 250
 | 3775 | 0
 | 3975 | 1000
 | 4025 | 0
 | 4225 | 250
 | 4275 | 0
 |  | 500
 |  | 0
 |  | 250
 |  | 0
 |  | 1000
 |  | 0
Spreadsheet: 704823d1605766967-unable-to-make-powerquery-extract-data-correctly-onto-an-excel-sheet-pq-tennispq17-2-1-aligw
Sheet: Tennis Data

I. Hard |  | Name | Age | Wins | Matches | Lost | Surface Win % | Best Surface | Best Surface Win % | Prize Money
[NAME] |  | [NAME] | 23 | 298 | 473 | 175 | 0.6383 | Carpet | 0.7143 | 4442257
Dominic Thiem |  | Dominic Thiem | 27 | 445 | 664 | 219 | 0.5714 | Clay | 0.76 | 22132368
I. Hard |  | Name | Age | Wins | Matches | Lost | Surface Win % | Best Surface | Best Surface Win % | Prize Money
Stefanos Tsitsipas |  | Stefanos Tsitsipas | 22 | 333 | 502 | 169 | 0.6543 | Clay | 0.7283 | 10425605
[NAME] |  | [NAME] | 34 | 1073 | 1303 | 230 | 0.6897 | Clay | 0.9051 | 119601561
Grass |  | Name | Age | Wins | Matches | Lost | Surface Win % | Best Surface | Best Surface Win % | Prize Money
[NAME] |  | [NAME] | 23 | 298 | 473 | 175 | 0.6383 | Carpet | 0.7143 | 4442257
Dominic Thiem |  | Dominic Thiem | 27 | 445 | 664 | 219 | 0.5714 | Clay | 0.76 | 22132368
Clay |  | Name | Age | Wins | Matches | Lost | Surface Win % | Best Surface | Best Surface Win % | Prize Money
Dominic Thiem |  | [NAME] | 23 | 298 | 473 | 175 | 0.6383 | Carpet | 0.7143 | 4442257
[NAME] |  | Dominic Thiem | 27 | 445 | 664 | 219 | 0.5714 | Clay | 0.76 | 22132368
I. Hard |  | Name | Age | Wins | Matches | Lost | Surface Win % | Best Surface | Best Surface Win % | Prize Money
[NAME] |  | [NAME] | 23 | 298 | 473 | 175 | 0.6383 | Carpet | 0.7143 | 4442257
Oceane Dodin |  | Dominic Thiem | 27 | 445 | 664 | 219 | 0.5714 | Clay | 0.76 | 22132368
I. Hard |  | Name | Age | Wins | Matches | Lost | Surface Win % | Best Surface | Best Surface Win % | Prize Money
sara Sorribes Tormo |  | [NAME] | 23 | 298 | 473 | 175 | 0.6383 | Carpet | 0.7143 | 4442257
camila giorgi |  | Dominic Thiem | 27 | 445 | 664 | 219 | 0.5714 | Clay | 0.76 | 22132368
Spreadsheet: 125835d1319237796-matching-on-name-to-phone-email-addresses-sample-1-
Sheet: Email Addresses

Name First | Name Last | Phone/E-mail [NAME] | FullName
[NAME] | Nakama | [EMAIL]
(Joel) Bradley | King | [EMAIL]
A. Jerard | Bryant | [EMAIL]
[NAME] | Green | [EMAIL]
[NAME] | Arce | [EMAIL]
[NAME] | Ayala | [EMAIL]
[NAME] | [NAME] | [EMAIL]
[NAME] | Buxbaum | [EMAIL]
Spreadsheet: larry_campbell__21443__VaR Calculator
Sheet: NG

 | Approximate VaR Calculator
 | Instructions:
 |  | The calculations are very rough and should never be used for trading decisions
 |  | Enter data in the areas clolored as:
 |  | Basis VaR is calculated as a hedge between NYMEX and FP (i.e. Long Nymex, Short FP)
 |  | Do not touch Blue and Red cells
 | Postions |  | 1 | 2 | 3 | 4 | 5
 | Curves |  | Z6-FP | Nymex | SJ - FP | Nymex
 | Contracts per Day |  | 45 | -45 | 0 | 0 | 0
 | Number of Months |  | 4 | 4 | 1 | 5 | 5
 | Price |  |  | 5.42 | 5.22 | 5.42 | 5
 | Vol |  | 0.57 | 0.55 | 0.55 | 0.57 | 0.6
 | Postion (MMBtus)
 | Value-at-Risk
 |  |  |  | 1+2 | 1+2+3 | 1+2+3+4 | 1+2+3+4+5
 | Aggregate Value-at-Risk
 |  | Correlation Matrix
 |  |  | 1
 |  |  | 0.95 | 1
 |  |  | 0.29 | 0.98 | 1
 |  |  | 0.44 | 0.98 | 0.96 | 1
 |  |  | 0 | 0 | 0 | 0 | 1
Spreadsheet: 85983d1285957818-tariff-prices-will-not-continue-to-calculate-when-24-hours-are-reached-king-edward-court_new
Sheet: Sheet1

Carpark Arrival Date & Time
2010-10-01 11:30:00 | Fri | King [NAME] | SUNDAY - FRIDAY | SATURDAY |  | Sat
Parking Duration | NOTES: | UP TO 1 HOUR | 2.2 | 2.5 |  | Sun
02:00:06 |  | 1 - 2 HOURS | 2.7 | 3 | 01:00:00 | Mon
 | 3.8 | 2 - 3 HOURS | 3.8 | 3.8 | 02:00:00 | Tue
Carpark Departure Date & Time | Amount Due: | 3 - 4 HOURS | 5 | 5 | 03:00:00 | Wed
2010-10-01 13:30:06 | 3.8 | 4 - 6 HOURS | 7 | 7 | 04:00:00 | Thu
Fri |  | 6 - 24 HOURS | 15 | 15 | 06:00:00 | Fri
Spreadsheet: mary_fischer__25623__31Y
Sheet: E1.XLS 

ENRON CORP AND CONSOLIDATED SUBSIDIARIES
COMPANY # 031Y
COMPANY NAME  The LINC Corp Holding Company
ANALYSIS OF A/R - OTHER
FOR THE 6 MONTHS ENDED 6-30-2001
PREPARED BY: Sonya City
EXTENSION:  3 9690 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | E-1
 |  | 12-31-2000 Balance
 |  | BEGINNING |  | OTHER |  | 03-31-2001 |  | OTHER |  | 06-30-2001 |  | OTHER |  | 09-30-2001 |  | OTHER |  | 12-31-2001
[NAME] |  | BALANCE |  | CHANGES |  | BALANCE |  | CHANGES |  | BALANCE |  | CHANGES |  | BALANCE |  | CHANGES |  | BALANCE
 |  | DR. (CR.) |  | DR. (CR.) |  | DR. (CR.) |  | DR. (CR.) |  | DR. (CR.) |  | DR. (CR.) |  | DR. (CR.) |  | DR. (CR.) |  | DR. (CR.)
(PROVIDE DETAIL OF INDIVDUAL ITEMS
IN EXCESS OF $200,000.)
Accts Receivables - Unconsolidated Assoc Companies:
Total (Hyperion line 0053)
Asset/Expense Accts:  DR/(CR)
Accts Receivables - Other:
Total (Hyperion line 0060)
Asset/Expense Accts:  DR/(CR)
Asset/Expense Accts:  DR/(CR)
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | E-1
Spreadsheet: 216570d1361813780-still-sumif-question-book2-hb-start-over-14-daily-reconciliation-6
Sheet: Non-Camping Sales Cash Out

 |  |  |  | NON-CAMPING SALES CASH OUT
 |  |  |  |  |  |  | Cash Out #:
 | PREPARED BY: |  |  |  |  | DEPARTMENT:
 | OPENING DATE: |  | 2013-02-06 00:00:00 |  |  | CLOSING DATE:
 |  |  |  |  | Dump | Day Use |  | Season
 |  |  | Begin#/ |  | Fee | Fee | Wood | Pass
 | Date: |  | Receipt# | End # | 5114 | 5125 | 5230 | 5205
1
2
3
4
5
6
7
8
9
10
11
12
13
14
15
16
17
18
19
20
21
 | TOTALS THIS PAGE
 | Totals Page 2 to:
 | GRAND TOTALS:
 | NET SALES:
 | Sales Tax:"%" |  | 0.07
Spreadsheet: 73400d1274071899-how-to-combine-if-vlookup-and-match-lookup
Sheet: LookUp

Date | Model | C1 | C2 | [NAME] | C4 | C5 | C6 | C7 | C8 | C9 | C10 | C11 | C12 | C13 | C14 | C15 | C16 | C17 | C18 | C19 | C20 | C21 | C22 | C23 | C24
2010-03-15 00:00:00 | F4081033 | 12784 | 0 | 0 | 0 | 388 | 388 | 388 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0
2010-03-30 00:00:00 | F4081033 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 5850 | 52360 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 25568 | 0 | 0
2010-04-15 00:00:00 | F4081033 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 9226 | 0 | 70000 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0
2010-04-30 00:00:00 | F4081033 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 388 | 0 | 0 | 0 | 16000 | 0 | 0 | 8378 | 0 | 0 | 65000 | 0 | 0 | 0 | 0 | 127840 | 388
Spreadsheet: 120a420a-d802-4b99-845c-91f38233e10c
Sheet: Table 3.5

Monthly Statistical Bulletin
3.5 Labour productivity
Quarter | 2008–09 | 2009–10 | 2010–11 | 2011–12 | 2012-13
Labour productivity index (a) (b)
September | 96.2 | 99.5 | 100.1 | 101.6 | 103.5
December | 96.5 | 99.1 | 100.1 | 101.2 | 104.5
March | 96.6 | 99.9 | 98.9 | 103 | 105.1
June | 98.3 | 99.5 | 100.8 | 103.1 | 105.4
Annual | 96.9 | 99.5 | 100 | 102.2 | 104.6
Quarterly change (a) – per cent
September | 0 | 1.22075279755849 | 0.6030150753768737 | 0.7936507936507837 | 0.3879728419010604
December | 0.3118503118503071 | -0.4020100502512634 | 0 | -0.3937007874015563 | 0.9661835748792384
March | 0.1036269430051817 | 0.8072653884964751 | -1.198801198801192 | 1.778656126482204 | 0.5741626794258252
June | 1.759834368530022 | -0.4004004004004003 | 1.921132457027298 | 0.09708737864077932 | 0.2854424357754652
Annual change (a) – per cent
\
September |  | 3.430353430353421 | 0.6030150753768737 | 1.498501498501497 | 1.870078740157481
December | 1.047120418848152 | 2.69430051813471 | 1.009081735620583 | 1.098901098901123 | 3.260869565217376
March | 0.9404388714733471 | 3.416149068322994 | -1.001001001001001 | 4.145601617795762 | 2.038834951456309
June | 2.182952182952164 | 1.22075279755849 | 1.306532663316574 | 2.281746031746025 | 2.230843840931158
Annual | 1.042752867570385 | 2.683178534571724 | 0.5025125628140614 | 2.200000000000003 | 2.348336594911942
(a) Quarterly figures are seasonally adjusted.
(b) Reference year for index is 2009–10 = 100.0.
Source: ABS, Australian national accounts: national income, expenditure and product, | http://www.abs.gov.au/AUSSTATS/abs@.nsf/second+level+view?ReadForm&prodno=5206.0&viewtitle=Australian%20National%20Accounts:%20National%20Income,%20Expenditure%20and%20Product~Dec%202007~Latest~5/03/2008&&tabname=Past%20Future%20Issues&prodno=5206.0&issue=Dec%202007
Cat. no. 5206.0 | http://www.abs.gov.au/AUSSTATS/abs@.nsf/second+level+view?ReadForm&prodno=5206.0&viewtitle=Australian%20National%20Accounts:%20National%20Income,%20Expenditure%20and%20Product~Dec%202007~Latest~5/03/2008&&tabname=Past%20Future%20Issues&prodno=5206.0&issue=Dec%202007
 |  |  |  |  |  |  |  | Update
 |  |  |  |  |  |  |  | 2013-12-04 00:00:00
Spreadsheet: 817931d1676515924-filter-item-and-display-in-single-cell-sample2
Sheet: Sheet1

 |  |  |  |  |  | Group
 |  |  |  |  |  | Group | Items | ID
 |  |  |  |  |  | A | Pencil | 1111
 |  |  |  |  |  | A | Pencil | 1111
 |  |  |  |  |  | A | Pencil | 1111
 |  |  |  |  |  | B | Eraser | 2222
 |  |  |  |  |  | B | Eraser | 2222
 |  |  |  |  |  | C | Ruler | 3333
 |  |  |  |  |  | C | Ruler | 3333
Spreadsheet: 165594d1341287962-dealing-with-student-grades-help
Sheet: Sheet1

 | submitted byAce_XL |  |  |  | submitted byvlady |  |  |  |  | what I need to do
Student | Score | Grade | Correct Grade |  | 1 | 10 | F | 0 |  | Student | Score | Grade | Correct Grade (A's<30%)
5 | 95 | A+ | A+ |  | 2 | 91 | A | 0 |  | 1 | 10 | F | F
16 | 94 | A | A |  | 3 | 92 | A | A |  | 2 | 91 | A | [NAME]
19 | 93 | A | A |  | 4 | 94 | A | A |  | 3 | 92 | A | [NAME]
12 | 92 | A | A |  | 5 | 74 | C | A |  | 4 | 94 | A | A
2 | 91 | A | A |  | 6 | 93 | A | 0 |  | 5 | 74 | C | C
20 | 90 | A | A |  | 7 | 35 | F | b+ |  | 6 | 93 | A | A
14 | 89 | A | [NAME] |  | 8 | 56 | F | 0 |  | 7 | 35 | F | F
1 | 88 | [NAME] | [NAME] |  | 9 | 45 | F | 0 |  | 8 | 56 | F | F
6 | 87 | [NAME] | [NAME] |  | 10 | 77 | C+ | 0 |  | 9 | 45 | F | F
7 | 86 | [NAME] | [NAME] |  | 11 | 85 | [NAME] | 0 |  | 10 | 77 | C+ | C+
15 | 85 | B | [NAME] |  | 12 | 88 | [NAME] | 0 |  | 11 | 85 | [NAME] | [NAME]
10 | 84 | B | [NAME] |  | 13 | 84 | B | 0 |  | 12 | 88 | [NAME] | [NAME]
18 | 83 | B | [NAME] |  | 14 | 89 | [NAME] | 0 |  | 13 | 84 | B | B
3 | 82 | B | [NAME] |  | 15 | 99 | A+ | 0 |  | 14 | 89 | [NAME] | [NAME]
4 | 81 | B | [NAME] |  | 16 | 98 | A+ | b+ |  | 15 | 99 | A+ | A+
17 | 80 | C+ | [NAME] |  | 17 | 97 | A+ | b+ |  | 16 | 98 | A+ | A+
13 | 79 | C+ | [NAME] |  | 18 | 96 | A+ | b+ |  | 17 | 97 | A+ | A+
9 | 78 | C+ | [NAME] |  | 19 | 90 | A | b+ |  | 18 | 96 | A+ | A+
11 | 77 | C | [NAME] |  | 20 | 90 | A | b+ |  | 19 | 90 | A | [NAME]
8 | 76 | C | [NAME] |  |  |  |  |  |  | 20 | 90 | A | [NAME]
 |  |  |  |  |  |  |  |  |  | the green cells represent the two lowest A students (m4-23) the exceed the 'only 30% of students can get an A" rule.
 |  |  |  |  |  |  |  |  |  | So I need to formula that does this
Spreadsheet: 785723d1656568706-shuffling-words-to-make-different-phrases-in-excel-30-phrase-generator-hd
Sheet: phrase generator

Words |  | Phrase | [NAME] | Phrase3 | Phrase4 | Phrase5 | Phrase6 | Phrase7 | Phrase8 | Phrase9 | Phrase10 | Phrase11 | Phrase12 | Phrase13 | Phrase14 | Phrase15 | Phrase16 | Phrase17 | Phrase18 | Phrase19 | Phrase20 | Phrase21 | Phrase22 | Phrase23 | Phrase24 | Phrase25 | Phrase26 | Phrase27 | Phrase28 | Phrase29 | Phrase30
try
tasty
water
loan
enfix
swim
fruit
scheme
hard
slam
captain
penalty
slow
trail
resign
sailor
hip
coup
listen
auditor
wrist
coerse
long
primary
double
wealth
shift
[NAME]
leave
brag
sheep
pepper
post
bar
page
define
seal
floor
resist
instal
wedding
matter
true
explain
jockey
pasture
will
qualify
equip
cluster
outfit
infect
stitch
morsel
impulse
cancel
example
cottage
freedom
serve
Spreadsheet: 107687d1304800797-predictive-stock-stock-management_2
Sheet: Summary

Stock_Vol | Period
Row Labels | 2010.12 | 2011.01 | 2011.02 | Total
Chocolate | 15 | 85 |  | 100
Milkshake | 100 | -55 | 100 | 145
[NAME] | 100 |  |  | 100
Total | 215 | 30 | 100 | 345
Spreadsheet: 04d8ed1e-2e65-4431-b5c0-1b548e8832b0
Sheet: Sheet1

Unnamed: 0 | TTF-II | STF | ILCTA | Unnamed: 4
 |  |  | @FNAL
[NAME]: One Cryomodule at ≈ 25 MV/m with | done | 2007 | 3Q 2007
tests for gradient, Q, spreads, quench rates, recovery | done |  | 2007-08
rates, coupler breakdowns, dark currents
S1: One Cryomodule at 31.5 MV/m with | fall 2006 | 2007 | mid 2008
tests for gradient, Q, spreads,  quench rates,
coupler breakdowns, dark currents
pre-S2.1 | done
3 Cryomodules ≈ 25 MV/m, with klystron, modulator |  | 2009 | 2009
RF distribution, LLRF,  measure, gradient, Q, spreads
CM alignment
Run one RF unit (with above CM) for long period | done | 2010 | 2009-10
(6 months) for quench rate and coupler
breakdown rate, dark current, gradient, Q, spreads
Beam available | yes | 2007 | 2008
ILC-like beam available | see comment | 2009 | 2009
Beam tests: beam kicks due to couplers, dipoles, cavity | done | 2009 | 2008-09
tilt, quad rotations..,LLRF with beam loading, trip rates
with beam, HOM power from beam
S2.1
3 Cryomodules at 31.5 MV/m with klystron, | not foreseen | 2009 | 2010
modulator, RF distribution, LLRF,
measure CM alignment,vibrations, gradient, Q, spread,
breakdown rate, recovery rate, dark current, propagation
Run 31.5 MV/m RF unit for long period | summer 2007 | 2010 | 2010-2011
(6 months) for quench rate and coupler
breakdown rate, dark current, system trip rate
Beam tests: beam kicks due to couplers, dipoles, cavity | summer 2007 | 2009 | 2010-2011
tilt, quad rotations..,LLRF with beam loading,
system trip rates with beam, HOM power from beam
Assemble RF Unit with ILC-like cryomodules & 31.5 MV/m | not foreseen |  | 2009
Run 31.5 MV/m RF unit with ILC-like CM for long period |  | 2010 | 2010-2011
(6 months) for quench rate and coupler
breakdown rate, dark current, gradient, Q, spreads…
Added by Kephart:
stand alone CM test stand in MDB |  |  | 2009 | 2009
>3 stand alone CM test stands in IARC building @ FNAL |  |  | 2011 | 2011
2nd 3 Cryomodule 31.5 MV/M ILC RF unit operational |  |  | 2011
Spreadsheet: 231336d1367009468-variable-conditional-formating-for-a-range-conditional-format
Sheet: Sheet1

Values |  |  | Comparison
1 | 2 |  | 0
2 | 5 |  | 0
3 | 3 |  | 3 |  |  |  | <--------- It's all in the technique for applying conditional format + understanding relative/absolute references
4 | 0 |  | 0
5 | 0 |  | 0
6 | 6 |  | 6
7 | 5 |  | 7
8 | 3 |  | 0
9 | 4 |  | 0
10 | 7 |  | 10
Values |  |  | Comparison
1 | 2 |  | 0
2 | 5 |  | 0
3 | 3 |  | 3
4 | 0 |  | 0 |  | <= what it should look like
5 | 0 |  | 0
6 | 6 |  | 6
7 | 5 |  | 7
8 | 3 |  | 0
9 | 4 |  | 0
10 | 7 |  | 10
Spreadsheet: 854977d1704725543-median-over-two-columns-with-different-data-book4
Sheet: Sheet1

date | action |  | QA | C/B | D/P |  |  |  |  |  | Median
2022-07-29 00:00:00 | d |  | 1.255 | 8.6534 |  |  |  |  |  | 2022
2022-08-31 00:00:00 | d |  | 1.259 | 8.6894 |  |  |  |  |  | 2023
2022-09-30 00:00:00 | d |  | 1.501 | 7.3418 |  |  |  |  |  | 2024
2022-10-31 00:00:00 | d |  | 1.421 | 7.8396
2022-11-30 00:00:00 | d |  | 1.153 | 7.8231
2022-12-30 00:00:00 | d |  | 1.204 | 7.5415
2023-01-31 00:00:00 | d |  | 1.159 | 7.8947
2023-02-28 00:00:00 | d |  | 1.203 | 7.6559 |  |  |  |  | Correct answer
2023-03-31 00:00:00 | d |  | 1.198 | 7.7462 |  |  |  |  | 2022
2023-04-28 00:00:00 | d |  | 1.199 | 7.7998 |  |  |  |  | 2023
2023-05-01 00:00:00 | np | 7.84
2023-05-31 00:00:00 | d |  | 1.221 | 7.7068
2023-06-30 00:00:00 | d |  | 1.19 | 7.9664
2023-07-31 00:00:00 | d |  | 1.179 | 8.0916
2023-08-31 00:00:00 | d |  | 1.221 | 7.8706
2023-10-11 00:00:00 | d |  | 1.329 | 7.2837
2023-11-10 00:00:00 | d |  | 1.347 | 8.1931
2023-12-12 00:00:00 | d |  | 1.271 | 7.7262
2023-12-29 00:00:00 | np | 9.89
2024-01-31 00:00:00 | np | 9.99
2024-02-25 00:00:00 | np | 10.12
Spreadsheet: 181fd2d5-b923-45f2-ba3d-dbbd79badfa3
Sheet: 2001-02

Table Q
Full Time Affiliate Student numbers
Department | Undergraduate |  |  | Graduate |  |  | Total
 | Home | Overseas | Total | Home | Overseas | Total
Anatomy and Developmental Biology | 0 | 1 |  | 0 | 0
Anthropology | 4 | 9 |  | 0 | 0
Institute of Archaeology | 1 | 8 |  | 0 | 0
Bartlett School of Architecture | 12 | 1 |  | 4 | 1
Biochemical Engineering | 1 | 0 |  | 0 | 0
Biochemistry and Molecular Biology | 1 | 4 |  | 0 | 0
Biology | 0 | 2 |  | 0 | 1
Chemical Engineering | 7 | 4 |  | 0 | 0
Chemistry | 2 | 3 |  | 0 | 0
Civil and Environmental Engineering | 0 | 3 |  | 0 | 1
Faculty of Clinical Sciences | 1 | 1 |  | 0 | 0
Comparative Literature Affiliates | 2 | 15 |  | 0 | 0
Computer Science | 3 | 3 |  | 2 | 0
[NAME] and Literature | 3 | 0 |  | 0 | 0
Eastman Dental Institute | 0 | 0 |  | 9 | 7
Economics | 0 | 73 |  | 6 | 0
Electronic and Electrical Engineering | 2 | 2 |  | 0 | 0
English Language and Literature | 1 | 26 |  | 0 | 0
Slade School of Fine Art | 4 | 18 |  | 0 | 1
French | 3 | 0 |  | 0 | 0
[NAME] Unit | 0 | 0 |  | 0 | 1
Geography | 5 | 15 |  | 0 | 0
Geological Sciences | 5 | 0 |  | 0 | 0
Geomatic Engineering | 4 | 0 |  | 0 | 1
German | 17 | 1 |  | 0 | 0
Greek and Latin | 3 | 2 |  | 2 | 0
Hebrew and Jewish Studies | 0 | 3 |  | 0 | 0
History | 11 | 38 |  | 0 | 1
History of Art | 3 | 11 |  | 0 | 0
Immunology and Molecular Pathology | 0 | 1 |  | 0 | 0
Italian | 23 | 1 |  | 0 | 0
Laws | 32 | 0 |  | 0 | 36
Mathematics | 0 | 5 |  | 0 | 0
Mechanical Engineering | 0 | 3 |  | 0 | 0
Medical Physics | 1 | 0 |  | 0 | 0
Modern European Studies | 2 | 0 |  | 0 | 0
Institute of Neurology | 0 | 0 |  | 1 | 0
Institute of Ophthalmology | 0 | 0 |  | 0 | 1
Pharmacology | 0 | 1 |  | 0 | 0
Philosophy | 2 | 22 |  | 0 | 0
Phonetics and [NAME] | 0 | 1 |  | 0 | 0
Physics and Astronomy | 0 | 1 |  | 0 | 0
Physiology | 0 | 0 |  | 1 | 0
Psychology | 8 | 44 |  | 0 | 0
School of Slavonic and E. European Stds | 5 | 10 |  | 0 | 0
Scandinavian Studies | 3 | 1 |  | 0 | 0
Science and Technology Studies | 0 | 1 |  | 0 | 0
Spanish and Latin American Studies | 0 | 3 |  | 0 | 0
Statistical Science | 2 | 1 |  | 0 | 0
Total
Faculty | Undergraduate |  |  | Graduate |  |  | Total
 | Home | Overseas | Total | Home | Overseas | Total
Arts and Humanities | 63 | 95 |  | 2 | 1
Built Environment | 12 | 1 |  | 4 | 1
Clinical Sciences | 1 | 1 |  | 1 | 1
Eastman Dental Institute | 0 | 0 |  | 9 | 7
Engineering | 14 | 12 |  | 0 | 2
Laws | 32 | 0 |  | 0 | 36
Life Sciences | 9 | 53 |  | 1 | 2
Mathematical and Physical Sciences | 13 | 14 |  | 2 | 0
Social and Historical Sciences | 29 | 162 |  | 6 | 1
Total
As figures relate to the official HEFCE census date, 1 December, affiliate students who start in January are not included.
Spreadsheet: 220688d1363235770-making-fully-automated-spreadsheet-big-excel-for-forum-help
Sheet: Main

 |  |  |  |  |  |  |  |  |  |  |  |  |  | Customer's PO |  |  | Invoice To Customer |  |  | PO for Sub |  |  |  | Invoice From Sub |  | Hours |  |  | Related Expenses |  |  | [NAME] |  | Gross Profit |  |  | Closeout
Site ID | FA# | Name | Location | City | State | Zip | Customer | SOW | Proposal # | Proposal Date | Start Date | % Complete | Completion Date | Amount | PO # | PO Date | Submitted to [NAME] | Invoice # | Invoice Date | Sub Name | Amount | PO # | PO Date | Invoice # | Invoice Date | Projected | Actual | Cost | Out Of Pocket | Reimbursed | 5% Mark Up | # | Amount | $ | % | Notes | Submitted To | Submitted Date | [Rejected Date] | Final Approval Date
CV301 | 123 | a | One Street | here | VA | 11111 | Apples | Alarm | 1 | 2011-01-01 00:00:00 | 2011-01-02 00:00:00 |  |  | 100 | 11 | 2011-01-02 00:00:00 | 2011-01-02 00:00:00 |  |  | guy1 | 10 | g1 | 2011-01-02 00:00:00 | g11 | 2011-01-03 00:00:00 | 4
CV305 | 456 | b | Two Street | there | VA | 11111 | Pears | Civil | 2 | 2022-02-02 00:00:00 | 2022-02-03 00:00:00 |  |  | 200 | 22 | 2022-02-03 00:00:00 | 2022-02-03 00:00:00 |  |  | guy2 | 20 | g2 | 2022-02-03 00:00:00 | g22 | 2022-02-04 00:00:00 | 5 |  |  |  |  |  | 1 | 500
CV309 | 789 | c | Three Street | nowhere | VA | 11111 | Bananas | Tower | 3 | 1933-03-03 00:00:00 | 1933-03-04 00:00:00 |  | 1933-03-05 00:00:00 | 300 | 33 | 1933-03-04 00:00:00 | 1933-03-04 00:00:00 | 333 | 1933-03-05 00:00:00 | guy3 | 30 | g3 | 1933-03-04 00:00:00 | g33 | 1933-03-05 00:00:00 | 6
Spreadsheet: 539766d1506358427-lookup-formula-sample-workbook-for-lookup-formula
Sheet: Sheet1

 |  |  |  |  |  |  |  |  | Unique List
 |  |  |  |  |  |  |  | 2410.98 | Auto Expen. - Automobile Expenses
 |  |  |  |  |  |  |  | 5567.73 | Bank Serv. Fees - Bank Service Fees
 |  |  |  |  |  |  |  | 0 | Charitable Cont - Charitable Contributions
 |  |  |  |  |  |  |  | 25572.88 | [NAME]
 |  |  |  |  |  |  |  | 0 | Legal & Prof - Legal and Professional Expenses
 |  |  |  |  |  |  |  | 0 | Professional Expenses | 0
Spreadsheet: 288847d1389318133-consolidate-multiple-worksheets-into-one-reference-cover-sheet-excel-forum
Sheet: 2615

Recipient Created Tax Invoice
TO: | worker |  |  |  |  |  | FROM: | Work
 | worker |  |  |  |  |  |  | 123 Work
 | address |  |  |  |  |  |  | Work
 | WA | 6055 |  |  |  |  |  | WA | 6666
 | ABN: | abn |  |  |  |  |  | ABN: | 55 555 555 555
 | Vendor # | 26415
 | APPRENTICE DETAILS |  |  |  |  |  |  | Date: | 2014-01-10 00:00:00
 | Name: |  | [NAME] |  |  |  |  | Invoice #
 | Employee Number: |  | 12388 |  |  |  |  | FN Start
 | Apprenticeship: |  | App Plasterer U/Age Y3 (3YR)
 | G/L Code: |  | 2113
 | 12388#26415
 | Date | Ordinary Hours | Ordinary $ Total | Travel $ Total | OT15 Hours | OT15 $ | OT20 Hours | OT20 $ | Meal | TOTAL
 | 2013-12-09 00:00:00 | 8 | 204.56 | 13.12 |  |  |  |  |  | 217.68
 | 2013-12-10 00:00:00 | 8 | 204.56 | 13.12 |  |  |  |  |  | 217.68
 | 2013-12-11 00:00:00 | 8 | 204.56 | 13.12 |  |  |  |  |  | 217.68
 | 2013-12-12 00:00:00 | 8 | 204.56 | 13.12 |  |  |  |  |  | 217.68
 | 2013-12-13 00:00:00 | 8 | 204.56 | 13.12 |  |  |  |  |  | 217.68
 | 2013-12-16 00:00:00 | 8 | 204.56 | 13.12 |  |  |  |  |  | 217.68
 | 2013-12-17 00:00:00 | 8 | 204.56 | 13.12 |  |  |  |  |  | 217.68
 |  |  |  |  |  |  |  |  |  | 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
 | Less Daily Subsidy | CTF |  |  |  |  |  |  |  | 7.852320000000001
 |  | ABBTF |  |  |  |  |  |  |  | 0
 |  | ABN DISCOUNTS |  |  |  |  |  |  |  | 0
 | Net Invoice |  |  |  |  |  |  |  |  | 1515.90768
 | GST |  |  |  |  |  |  |  |  | 151.590768
 | Total payable inclusive of GST |  |  |  |  |  |  |  |  | 1531.61232