tianzl66/Sheetpedia huggingface dataset:
Spreadsheet: 599914d1543357044-change-cell-colour-based-on-the-value-of-one-cell-2019-cohort-qla
Sheet: Higher Reading

 |  | Section A |  |  |  |  |  |  |  |  |  | Section B - Questions in Spanish
 | Question | 1 | 2 | 3 | 4 | 5 | 6 | 7 | 8 | 9 | 10 | 11 | 12 | 13 | 14 | 15 | 16
 | Out of | 1 | 3 | 4 | 4 | 4 | 3 | 5 | 2 | 3 | 4 | 4 | 3 | 3 | 4 | 4 | 9
 | Topic | Life at school | Festivals | Technology in School | Description of my interests | Literary extract | Music and musicians | Reality TV | Smoking law | Culture and tradition | Sport | Literary extract | Voluntary work | Verb conjugation and grammar | Marriage and relationships | School life | Translation (SP>EN) | Total
 | OP1
 | OP3 | 0 | 2 | 4 | 1 | 1 | 3 | 0 | 0 | 0 | 3 | 4 | 2 | 0 | 3 | 3 | 3
 | OP1
 | OP3 | 0 | 0 | 3 | 0 | 0 | 0 | 0 | 0 | 0 | 1 | 1 | 0 | 2 | 0 | 0 | 0
 | OP2
 | OP1
 | OP3
 | OP3
 | OP1
 | OP2
 | OP3 | 0 | 1 | 2 | 0 | 0 | 0 | 0 | 0 | 0 | 1 | 3 | 0 | 0 | 1 | 2 | 2
 | OP3
 | OP2
 | OP1
 | OP2
 | OP3
 | OP1
 | OP2
 | OP1
 | OP3 | 0 | 2 | 4 | 1 | 0 | 2 | 0 | 0 | 0 | 1 | 3 | 2 | 0 | 0 | 1 | 2
 | OP2
 | OP2
 | OP1
 | OP2
 | OP1
 | OP2
 | OP3
 | OP1
 | OP1
 | OP3 | 0 | 2 | 4 | 1 | 0 | 3 | 1 | 0 | 0 | 2 | 3 | 1 | 0 | 1 | 4 | 4
 | OP2
 | OP1
 | OP2
 | OP2
 | OP2
 | OP2
 | OP2
 | OP2
 | OP3
 | OP2
 | OP2
 | OP3
 | OP2
 | OP3 | 1 | 0 | 2 | 0 | 1 | 2 | 0 | 0 | 0 | 2 | 3 | 2 | 0 | 0 | 1 | 0
 | OP2
 | OP3
 | OP3 | 1 | 1 | 3 | 0 | 0 | 2 | 0 | 0 | 0 | 2 | 4 | 2 | 1 | 1 | 3 | 0
 | OP2
 | OP3 | 1 | 0 | 3 | 1 | 0 | 3 | 0 | 0 | 0 | 2 | 1 | 2 | 0 | 0 | 3 | 2
 | OP3 | 0 | 0 | 1 | 0 | 0 | 1 | 0 | 0 | 0 | 3 | 2 | 0 | 0 | 0 | 1 | 1
 | OP1
 | OP1
 | OP2
 | OP2
 | OP2
 | OP1
 | OP2
 | OP1
 | OP2
 | OP3
 | OP3
 | OP1
 | OP2
 | OP1
 | OP1
 | OP1
Spreadsheet: 774285d1648363452-scattered-values-over-several-columns-to-be-listed-in-one-subsequent-order-book3-1-
Sheet: Sheet1

A | F | H | L | N | Q | S | V | X |  | A
B | G | I | M | O | R | T | W | Y |  | B | B | B
C |  | J |  | P |  | U |  | Z |  | C | C | C
D |  | K |  |  |  |  |  |  |  | D | D | D
E |  |  |  |  |  |  |  |  |  | E | E | E
 |  |  |  |  |  |  |  |  |  | F | F | F
 |  |  |  |  |  |  |  |  |  | G | G | G
 |  |  |  |  |  |  |  |  |  | H | H | H
 |  |  |  |  |  |  |  |  |  | I | I | I
 |  |  |  |  |  |  |  |  |  | J | J | J
 |  |  |  |  |  |  |  |  |  | K | K | K
 |  |  |  |  |  |  |  |  |  | L | L | L
 |  |  |  |  |  |  |  |  |  | M | M | M
 |  |  |  |  |  |  |  |  |  | N | N | N
 |  |  |  |  |  |  |  |  |  | O | O | O
 |  |  |  |  |  |  |  |  |  | P | P | P
 |  |  |  |  |  |  |  |  |  | Q | Q | Q
 |  |  |  |  |  |  |  |  |  | R | R | R
 |  |  |  |  |  |  |  |  |  | S | S | S
 |  |  |  |  |  |  |  |  |  | T | T | T
 |  |  |  |  |  |  |  |  |  | U | U | U
 |  |  |  |  |  |  |  |  |  | V | V | V
 |  |  |  |  |  |  |  |  |  | W | W | W
 |  |  |  |  |  |  |  |  |  | X | X | X
 |  |  |  |  |  |  |  |  |  | Y | Y | Y
 |  |  |  |  |  |  |  |  |  | Z | Z | Z
Spreadsheet: 763335d1642108105-xlookup-dual-criteria-book2
Sheet: pick sheet

This is the pick sheet. Enter a name and it looks up the place. Then it looks up the part allowance by place in another tab.
[NAME] | PLACE1 | LOCATION VARIES based on Tech Name
ITEM | ALLOWANCE
PART1 | FORMULA FOR PART BY LOCATION | ALLOWANCE VARIES by Location
PART2 | FORMULA FOR PART BY LOCATION
PART3 | FORMULA FOR PART BY LOCATION
PART4 | FORMULA FOR PART BY LOCATION
PART5 | FORMULA FOR PART BY LOCATION
PART6 | FORMULA FOR PART BY LOCATION
PART7 | FORMULA FOR PART BY LOCATION
[NAME] | FORMULA FOR PART BY LOCATION
PART9 | FORMULA FOR PART BY LOCATION
PART10 | FORMULA FOR PART BY LOCATION
PARTS DON'T CHANGE MUCH
IF I CHANGE THE LOCATION IN B1, THE PARTS SHOULD UPDATE TO THE ALLOWANCES SHOWN IN THE TABLE TO THE RIGHT.
I TRIED USING AN XLOOKUP WITH A MATCH FUNCTION IN THE RETURN COLUMN LOCATION. BUT THAT GIVES ME A NUMBER, WHICH WOULD WORK WITH VLOOKUP.
THE WORKING WORKBOOK HAS HUNDREDS OF PARTS AND DOZENS OF LOCATIONS. SO I'D REALLY RATHER USE XLOOKUP BECAUSE IT SEEMS TO BE FASTER THAN VLOOKUP.
Spreadsheet: e78c1c08-6f58-44db-bddf-894d374ae47c
Sheet: Sheet1

Test Referenced | Entry Type | Mayo ID | Description | Reporting Description | Method | Collection Container | Temperature | Stability | [NAME] | Unit of Measure | [NAME] | Minimum Volume | Reject Due To | Reference Values | Days/Times Performed | Analytic Time | Maximum Lab Time | CPT Units | CPT Code | LOINC® Code | LOINC® Attributes | Always Performed | Orderable Separately | Performing Location
VCRU | Test | VCRU | Vanadium/Creatinine Ratio, Random, [NAME] | Vanadium/Creat Ratio, Random, U | VCR/32498: Dynamic Reaction Cell-Inductively Coupled Plasma-Mass Spectrometry (DRC-ICP-MS)  CDCR/7243: Enzymatic Colorimetric Assay | Plastic urine container with no metal cap or glued insert |  |  | 3 | mL | Collection Container/Tube: Clean, plastic urine collection container Submission Container/Tube: Plastic, 10-mL urine tube (Supply T068) or clean, plastic aliquot container with no metal cap or glued insert [NAME]: 3 mL Collection Instructions:  1. Collect a random urine specimen. 2. See Metals Analysis-Collection and Transport in Special Instructions for complete instructions. Additional Information: High concentrations of gadolinium and iodine are known to interfere with most metals tests. If either gadolinium- or iodine-containing contrast media has been administered, a specimen should not be collected for 96 hours. | 0.8 mL | Hemolysis	NA Thawing	Warm OK; Cold OK Lipemia	NA Icterus	NA Other	NA | > or =16 years: 0.2-0.8 mcg/g Creatinine Reference values have not been established for patients that are <16 years of age. | Tuesday, Thursday; 3 p.m. | 1 day | 5 days |  | Profile |  |  |  |  | Rochester
VCRU | [NAME] | URINE | [NAME] |  |  |  | Refrigerated | 28 days
VCRU | Component | VCR | Vanadium/Creatinine Ratio, [NAME] | Vanadium/Creat Ratio, U | Only orderable as part of a profile. For further information see #60575 Vanadium/Creatinine Ratio, Random, [NAME] |  |  |  |  |  | Only orderable as part of a profile. For further information see #60575 Vanadium/Creatinine Ratio, Random, [NAME] |  |  | Only orderable as part of a profile. For further information see #60575 Vanadium/Creatinine Ratio, Random, [NAME] |  |  |  | 1 | 83789 |  |  | Yes | No
VCR | [NAME] | URINE | [NAME] |  |  |  | Refrigerated | 28 days
VCR | Result | 32877 | Vanadium/Creat Ratio, U | Vanadium/Creat Ratio, U | Numeric |  |  |  |  | mcg/g |  |  |  |  |  |  |  |  |  | In Process
VCR | Result | 32892 | V Concentration | V Concentration | Numeric |  |  |  |  | mcg/L |  |  |  |  |  |  |  |  |  | In Process
VCRU | Component | CDCR | [NAME] | [NAME] | For further information see #8513 "Creatinine, U." |  |  |  | 5 | mL | Only orderable as part of a profile. For further information  see #8513 "Creatinine, [NAME]." |  |  |  |  |  |  |  |  |  |  | Yes | No
CDCR | [NAME] | URINE | [NAME] |  |  |  | Refrigerated | 30 days
CDCR | Result | CDCR | [NAME] | [NAME] | Numeric |  |  |  |  | mg/dL |  |  |  |  |  |  |  |  |  | 35674-1
Spreadsheet: 866915d1713822574-part-of-formula-from-drop-down-option-formula
Sheet: Sheet1

 |  |  |  | YES
 |  |  |  | >=
 |  |  |  | 25
20 |  |  |  |  |  | IF(E$1="NO",0,IF(A5>=$E$3,1,0))
21 |  |  |  |  |  | Is it possible to change >= in above formula with drop down cell E2?
22
23
24
25
26
27
28
29
30
31
32
33
34
35
36
37
Spreadsheet: 0e94e0c9-5fe2-4203-baa0-62a87879807e
Sheet: Sheet1

Test Referenced | Entry Type | Mayo ID | Description | Reporting Description | Method | Collection Container | Temperature | Stability | [NAME] | Unit of Measure | [NAME] | Minimum Volume | Reject Due To | Reference Values | Days/Times Performed | Analytic Time | Maximum Lab Time | CPT Units | CPT Code | LOINC® Code | LOINC® Attributes | Always Performed | Orderable Separately | Performing Location
MDCC3 | Test | MDCC3 | Monospecific Direct Coombs C3, Blood | Monospecific Direct Coombs C3, B | Direct Antiglobulin Test Using Standard AABB Techniques |  |  |  |  |  | [NAME] must arrive within 48 hours of draw.   Container/Tube: Lavender top (EDTA) [NAME]: 6 mL Collection Instructions: Send specimen in original tube. | 3 mL | Hemolysis	NA Thawing	Warm reject; Cold reject Lipemia	NA Icterus	NA Other	NA | Negative If positive, reaction is graded (positive 1+ to 4+). | Monday through Sunday; Varies | 1 day |  | 1 | 86880 |  |  |  |  | Rochester
MDCC3 | [NAME] | WBEDTA | [NAME] EDTA |  |  |  | Ambient | 48 hours
MDCC3 | Result | MDCC3 | Monospecific Direct Coombs C3, B | Monospecific Direct Coombs C3, B | Alphanumeric |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 54410-6 | Direct antiglobulin test.complement [NAME] specific reagent:ACnc:Pt:RBC:[NAME]:
Spreadsheet: chris_stokley__3840__Mock Table to Sort Data
Sheet: SE Extract

SETLMT_ENTITY_CD | Prod_mo | TRANSACTION_TYPE_CD | LEDGER_DT | SumOfSETLMT_AMT | Revenue/Expense | Absolute Value
CAISO | 08/2000 | A | 2000-11-01 00:00:00 | -118913050.3340797
CAISO | 08/2000 | E | 2000-08-01 00:00:00 | -100652322.0300537
CAISO | 08/2000 | M | 2000-11-01 00:00:00 | 1268554.699999994
Spreadsheet: 113378d1309295616-auto-populate-a-cell-when-3-options-are-selected-all-skus
Sheet: Blankets - 1498

Product | P-Code | Size | S-Code | Color | C-Code |  | SKU |  | UPC
Blankets | 1498 | Travel | 12 | Ivory | 20
Blankets | 1498 | Travel | 12 | White | 21
Blankets | 1498 | Travel | 12 | Sage Green | 22
Blankets | 1498 | Travel | 12 | Blue | 30
Blankets | 1498 | Travel | 12 | [NAME] | 31
Blankets | 1498 | Travel | 12 | Plum | 32
Blankets | 1498 | Twin | 13 | Ivory | 20
Blankets | 1498 | Twin | 13 | White | 21
Blankets | 1498 | Twin | 13 | Sage Green | 22
Blankets | 1498 | Twin | 13 | Blue | 30
Blankets | 1498 | Twin | 13 | [NAME] | 31
Blankets | 1498 | Twin | 13 | Plum | 32
Blankets | 1498 | Full | 15 | Ivory | 20
Blankets | 1498 | Full | 15 | White | 21
Blankets | 1498 | Full | 15 | Sage Green | 22
Blankets | 1498 | Full | 15 | Blue | 30
Blankets | 1498 | Full | 15 | [NAME] | 31
Blankets | 1498 | Full | 15 | Plum | 32
Blankets | 1498 | Queen | 16 | Ivory | 20
Blankets | 1498 | Queen | 16 | White | 21
Blankets | 1498 | Queen | 16 | Sage Green | 22
Blankets | 1498 | Queen | 16 | Blue | 30
Blankets | 1498 | Queen | 16 | [NAME] | 31
Blankets | 1498 | Queen | 16 | Plum | 32
Blankets | 1498 | King | 17 | Ivory | 20
Blankets | 1498 | King | 17 | White | 21
Blankets | 1498 | King | 17 | Sage Green | 22
Blankets | 1498 | King | 17 | Blue | 30
Blankets | 1498 | King | 17 | [NAME] | 31
Blankets | 1498 | King | 17 | Plum | 32
Spreadsheet: 172ae265-a1b1-494a-b4af-3a60ad161c38
Sheet: Activites codes

SFY 2015 FEDERAL CODE SHEET
SFY 2015 FEDERAL EDRS-SERVS-UFARS codes crosswalk
EDRS Activity codes
Activity Code | [NAME]
J | Assessment (Consultant Only)
K | Coursework Registration, Tuition or Fee
L | [NAME] (Personnel Development only)
M | Special Education Curriculum Development
N | Special Education Program Evaluation
O | IEP Planning Development, Review Due Process
S | Advisory Committee Activities
T | Conference/Workshop Expenses
V | Professional Membership/Dues Expenses
W | Family Events
X | Interagency Activities
Z | Travel, Mileage, Meals and Lodging
Team Teaching Required for Personnel Type Code 1 Teacher
+ | Team Teaching Model - Regular Class
* | Team Teaching Model - Resource Room
# | Team Teaching Model - Separate Class
Required for Personnel Type Code 12 Cultural Liaison
t | American Indian
u | Bilingual
v | African American
w | Other
Required for CEIS Services FSC Z and M/CEIS Services FSC z
s | Special Education Teacher
R | Regular Education Teacher
Required for Personnel Type Code 62 Extracurricular Activities Staff Only
a | Interpreter Services
b | Assistive Technology Services
c | Para/PCA Services
d | Nursing Services
e | Vision Services
f | Other IEP Specified Services
end of worksheet
Spreadsheet: 820828d1678303190-split-by-cells-used-how-to-avoid-circular-reference-formula-circ-error
Sheet: Sheet1

monthly | week1 | week2 | week3 | week4
48.24
48.24
48.24
48.24
This formula works if I set my options to Enable iterative calcs at 1 iteration
48.24
Spreadsheet: 233127d1367619105-employee-ranking-spreadsheet-based-on-key-areas-employee-productivity
Sheet: Data Entry

 | Sales Productivity Ranking
 | Sales Per Hour | Goal | Average $ Transaction | Goal | Multiple % | Goal | Accessory % | Goal | Handheld % | Goal | Sports Illustrated | Goal
Employee #1 |  | 200 |  | 80 |  | 0.6 |  | 0.15 |  | 0.45 |  | 25
Employee #2 |  | 200 |  | 80 |  | 0.6 |  | 0.15 |  | 0.45 |  | 25
Employee #3 |  | 200 |  | 80 |  | 0.6 |  | 0.15 |  | 0.45 |  | 25
Employee #4 |  | 200 |  | 80 |  | 0.6 |  | 0.15 |  | 0.45 |  | 25
Employee #5 |  | 200 |  | 80 |  | 0.6 |  | 0.15 |  | 0.45 |  | 25
Employee #6 |  | 200 |  | 80 |  | 0.6 |  | 0.15 |  | 0.45 |  | 25
Employee #7 |  | 200 |  | 80 |  | 0.6 |  | 0.15 |  | 0.45 |  | 25
 | 0
Spreadsheet: 102f2f05-6d71-4952-a224-0950acda061c
Sheet: Area 3

Location | Title | Name | Mobile | CRCs | CRC Mobile
Area 3 | Area Manager | [NAME] | 07764 960 387
Essex | RDO | [NAME] | 07889 601 261 | [NAME] | 07921 283179
 |  |  |  | [NAME] | 07595 799472
Essex | RDO | [NAME] | 07725 141 899 | [NAME] | 07738 029263
 |  |  |  | [NAME] | 07732 829972
 |  |  |  | [NAME] | 07894 489752
Sussex | RDO | [NAME] | 07793 167 075 | [NAME] | 07738 648 916
 |  |  |  | [NAME] | 07872 827 162
[NAME] | RDO | [NAME] | 07590 890 764 | [NAME] | 07711 470291
 |  |  |  | [NAME] | 07590 890810
 |  |  |  | La Toya Mason | 07711 385906
[NAME] | RDO | [NAME] | 07734 856 766 | [NAME] | 07809 316975
 |  |  |  | [NAME] | 07711 453867
Kent | RDO | [NAME] | 07764 336 704 | [NAME] | 07738 648829
 |  |  |  | Keith Forward | 07715 856695
 |  |  |  | [NAME] | 07715 856698
Kent | RDO | [NAME] | 07738 648 784 | [NAME] | 07809 512781
 |  |  |  | [NAME] | 07738 648950
 |  |  |  | (NB: GHH covering [NAME]
 |  |  |  | who is on extended leave until
 |  |  |  | 25.09.14)
Area 3 | URDO | [NAME] | 07872 672 478
Area 3 | WRDO | [NAME] (start date TBC) | 07841 367 392
Spreadsheet: louise_kitchen__24093__NEWCO HEADCOUNT NAMES
Sheet: Legal

Lawyers | ok
Houston
Cash, [NAME] | Asst. General Counsel
[NAME], Mary | Sr. Counsel
[NAME], [NAME] | Managing Director
Hodge, [NAME] | VP
Koehler, [NAME] | Sr. Counsel
[NAME], [NAME] | VP
Nemec, [NAME] | Sr. Counsel
Nettelton, Marcus | Sr. Counsel
[NAME], [NAME] | Sr. Counsel
Sager, [NAME] | VP
St. Clair, Carol | VP
[NAME], [NAME] | VP
[NAME], [NAME] | Asst. General Counsel
Portland
Hall, [NAME] | Sr. Counsel
Yoder, Christian | Sr. Counsel
Legal Specialists
Fitzgerald, Genia | Sr. Counsel
Heard, [NAME] | Sr. Counsel
Jones, [NAME] | Sr. Counsel
Admins
[NAME], Janette | [NAME]
Kaiser, Holly | [NAME]
Total | 20
Spreadsheet: 161691d1339600396-pulling-data-from-one-database-into-another-with-multiple-criteria-help-please-v3-modified-by-tigeravatar-
Sheet: Sheet3

[NAME] or Benefits | Name | Date | Amount | PCA
1 | JCHAN | 05/11 0 | 1619.63 | 12226
2 | JCHAN | 05/11 0 | 23.49 | 12226
1 | DANDERSON | 03/11 0 | 1808 | 12113
1 | DANDERSON | 04/11 0 | 1638.5 | 12113
2 | DANDERSON | 03/11 0 | 455.23 | 12113
2 | DANDERSON | 04/11 0 | 412.5400000000001 | 12113
1 | DANDERSON | 05/11 0 | 1635.68 | 12165
2 | DANDERSON | 05/11 0 | 411.83 | 12165
1 | GALVARADO | 11/11 0 | 342.4100000000001 | 12463
2 | GALVARADO | 11/11 0 | 4.960000000000001 | 12463
1 | GALVARADO | 11/11 0 | 1527.24 | 12400
2 | GALVARADO | 11/11 0 | 22.14 | 12400
Spreadsheet: 118291d1313590597-help-with-cse-formula-mode-if-tom_19_cse_mode_if
Sheet: Sheet1

State | Amount
TX | 5 |  |  | =MODE(IF(Table1[[#All],[State]]="TX",Table1[[#All],[Amount]]))
TX | 5
TX | 2
TX | 5
TX | 7
PA | 7
PA | 9
PA | 7
PA | 7
Spreadsheet: 01e118d2-4d57-43b6-b1bf-5ad2f5dedb28
Sheet: Business Certificates 6

BUSINESS
Certificates
Student Name:
ID #
Operations Management | Semester | Grade
Required
___ [NAME] (3) Introduction to Business
___ [NAME] (3) Supervisory Management
OR ___ [NAME] (3) Personal & Organizational Leadership
OR ___ QMS 101 (3) Introduction to Quality Systems
___ [NAME] (3) Operations Management
OR ___ MFG 256 (3) Production Management
___ COM 181 (3) Basic Public Speaking
OR ___ COM 252 (3) Introduction to Interpersonal Communications
Payroll Accounting Specialist
Required
___ ACC 201 (3) Financial Accounting
OR ___ ACT 101 (3) Fundamentals of Accounting I
AND ___ ACT 102 (3) Fundamentals of Accounting II
___ ACT 196 (3) Payroll Accounting
___ ACT 279 (3) Computerized Accounting Systems
Pre-Licensing Real Estate
Required
___ REA 100 (3) Real Estate Principles I
Choose 3 hours from the following Technical Courses.  Students may select other courses as approved by the
Business Administration Systems Program Coordinator.
___ REA 120 (3) Real Estate Marketing
___ REA 200 (3) Real Estate Principles II
___ REA 225 (3) Real Estate Finance
___ REA 230 (3) Real Estate Law
Quality Management
Required
___ QMS 101 (3) Introduction to Quality Systems
___ QMS 240 (3) Statistics for Quality I
___ QMS 201 (3) Customer Service Improvement Skills
___ QMS 202 (3) Performance Management
___ MAT 150 (3) College Algebra
Southeast Kentucky Community & Technical College | Updated Spring 2013
Spreadsheet: 684754d1593524390-populate-owner-name-in-a-cell-populate-with-owner-aligw
Sheet: FeedData

Lot | Feed | Cost | Owner
[NAME] | 450
WM405 | 578
WM567 | 598
HR345 | 5029
GH476 | 5269
GH4758 | 1593
HS3746 | 158
Spreadsheet: 137981d1327453703-forumula-to-get-data-across-pages-sum-across-sheets
Sheet: Joe

 | 175
 | 176
 | 177
 | 178
 | 179
 | 180
 | 181
 | 182
 | 183
 | 184
 | 185
 | 186
 | 187
 | 188
 | 189
 | 190
 | 191
 | 192
 | 193
 | 194
 | 195
 | 196
 | 197
 | 198
 | 199
Spreadsheet: 48587ccc-5a52-4d06-8693-1208e180818b
Sheet: New Table 1_Inde

 | Table 1
 | Grain Transport Cost Indicators1
 |  | Truck | Rail |  | Barge | Ocean
 | Week ending |  | Unit Train | Shuttle |  | Gulf | Pacific
 | 1Indicator:  Base year 2000 = 100; Weekly updates include truck = diesel ($/gallon); rail = near-month secondary rail market bid and monthly tariff rate with fuel
 | surcharge ($/car); barge = Illinois River barge rate (index = percent of tariff rate); and ocean = routes to Japan ($/metric ton)
 | Source:  Transportation & Marketing Programs/AMS/USDA
Spreadsheet: 32992d1229189076-a-formula-to-read-values-from-other-sheets-pivot-table-test1
Sheet: Source Data

CENTER. | Account Name. | Account Name | Beginning Balances. | DR. | CR. | Balances.
A | 111002-Cash Float - | 111002-Cash Float - | 0 | 625867.15 | 398038.67 | 227828.48
B | 111004-Cash Float - | 111004-Cash Float - | -0.5 | 10000 | 0 | 9999.5
C | 111006-Cash Float - | 111006-Cash Float - | 0 | 10000 | 0 | 10000
D | 111008-Cash Float - | 111008-Cash Float - | 0 | 10000 | 5000 | 5000
E | 111010-Cash Float - S | 111010-Cash Float - S | 0 | 10000 | 0 | 10000
F | 111011-Petty Cash- | 111011-Petty Cash- | 2000 | 0 | 0 | 2000
G | 111012-Cash Float - | 111012-Cash Float - | 0 | 10000 | 0 | 10000
H | 111014-Cash Float - | 111014-Cash Float - | 0 | 25000 | 5000 | 20000
I | 111016-Cash Float - | 111016-Cash Float - | -0.55 | 10000 | 0 | 9999.45
J | 111018-Cash Float - | 111018-Cash Float - | 0 | 5000 | 0 | 5000
K | 111020-Cash Float - | 111020-Cash Float - | 0 | 2000 | 0 | 2000
L | 111022-Cash Float - | 111022-Cash Float - | 0 | 5000 | 0 | 5000
M | 111024-Cash Float- | 111024-Cash Float- | 0 | 4083 | 2083 | 2000
N | 111028-Cash Float- | 111028-Cash Float- | 0 | 25000 | 10000 | 15000
O | 111030-Cash Float- | 111030-Cash Float- | 0 | 20000 | 10000 | 10000
P | 111032-Cash Float- | 111032-Cash Float- | 0 | 9000 | 3000 | 6000
Q | 111034-Cash Float- | 111034-Cash Float- | 0 | 5000 | 0 | 5000
R | 111036-Cash Float- | 111036-Cash Float- | 0 | 3000 | 0 | 3000
S | 111038-Cash Float- | 111038-Cash Float- | 0 | 5000 | 0 | 5000
T | 112001-Cash imprest | 112001-Cash imprest | 0 | 30000 | 0 | 30000
U | 112001-Cash imprest | 112001-Cash imprest | 0 | 14600 | 14600 | 0
V | 112001-Cash imprest | 112001-Cash imprest | 0 | 76000 | 1000 | 75000
W | 112001-Cash imprest | 112001-Cash imprest | 10003.85 | 14750 | 10000 | 14753.85
X | 112001-Cash imprest | 112001-Cash imprest | 104868.67 | 52800 | 77644.82 | 80023.85
Y | 112001-Cash imprest | 112001-Cash imprest | 0 | 5500 | 0 | 5500
Z | 112001-Cash imprest | 112001-Cash imprest | 25000 | 5853.6 | 1397.1 | 29456.5
AA | 321001-Accounts Payable Local S | 321001-Accounts Payable Local S | -100 | -100 | -200 | -400
Spreadsheet: 39310d1237477150-macro-to-generate-new-quote-tab-quote
Sheet: Template

Authorisation Form
AF Number |  |  |  | Client AF Number
Business Unit |  |  |  |  | Site |  | City
Client Department No |  |  |  |  | Client Department Name |  | An other
Originator Name |  |  |  |  | Telephone Number
Work Package
Date Required
Task Title
Description
Purchase |  |  |  |  |  |  | Uplift
Cat No/Description |  |  | Qty | Unit Price |  |  | £'s | % | Total £'s
 |  |  | 1 |  |  |  | 0 | 1.25 | 0
 |  |  |  |  |  |  | 0 | 1.25 | 0
 |  |  |  |  |  |  | 0 | 1.25 | 0
 |  |  |  |  |  |  | 0 | 1.25 | 0
 |  |  |  |  |  |  | 0 | 1.25 | 0
 |  |  |  |  |  |  | 0 | 1.25 | 0
 |  |  |  |  |  |  | 0 | 1.25 | 0
 |  |  |  |  |  |  | 0 | 1.25 | 0
 |  |  |  |  |  |  | 0 | 1.25 | 0
 |  |  |  |  |  |  | Purchase Total |  | 0
Labour
Service |  |  |  | Start Date | End Date | Hours | [NAME] |  | Total £'s
 |  |  |  |  |  |  |  |  | 0
 |  |  |  |  |  |  |  |  | 0
 |  |  |  |  |  |  |  |  | 0
 |  |  |  |  |  |  |  |  | 0
 |  |  |  |  |  |  | Labour Total |  | 0
 |  |  |  |  |  |  | Grand Total |  | 0
Organisation Code |  |  | Cost Centre |  | Project Number |  | Project Type
Authorisations |  |  | Signature |  | Printed Name |  | Date
Client User
Client Authorisation
Account Manager
Spreadsheet: 0c23bbe2-f594-4203-a8b8-6d9f5e7eebef
Sheet: Sheet1

Unnamed: 0 | Unnamed: 1 | Unnamed: 2 | Unnamed: 3 | Unnamed: 4 | Unnamed: 5 | Unnamed: 6 | Unnamed: 7 | Unnamed: 8 | Unnamed: 9 | Unnamed: 10 | Unnamed: 11
 | Time Series Workbook
 | 8731.0 Building Approvals, Australia
 | TABLE 21. Value of Dwelling Units Approved in New Residential Buildings, Original, Australia
Related Information: | Summary Publication | Explanatory Notes | Inquiries
 | Glossary
Data Item Description |  |  | Series Type | Series ID | Series Start | Series End | No. Obs. | Unit | Data Type | [NAME]. | Collection Month
Value of Approval ;  New ;  Total houses ; |  |  | Original | A418405W | 1970-07-01 00:00:00 | 2011-03-01 00:00:00 | 489 | $'000 | FLOW | Month | 1
Value of Approval ;  New ;  Semi-detached, row or terrace house, townhouse with one storey and similar ; |  |  | Original | A415787K | 1991-07-01 00:00:00 | 2011-03-01 00:00:00 | 237 | $'000 | FLOW | Month | 1
Value of Approval ;  New ;  Semi-detached, row or terrace house, townhouse with two or more storeys ; |  |  | Original | A422928K | 1991-07-01 00:00:00 | 2011-03-01 00:00:00 | 237 | $'000 | FLOW | Month | 1
Value of Approval ;  New ;  Total semi-detached, row or terrace houses, townhouses and similar ; |  |  | Original | A416423R | 1991-07-01 00:00:00 | 2011-03-01 00:00:00 | 237 | $'000 | FLOW | Month | 1
Value of Approval ;  New ;  Flat, unit or apartment in a building of one or two storeys ; |  |  | Original | A423531F | 1991-07-01 00:00:00 | 2011-03-01 00:00:00 | 237 | $'000 | FLOW | Month | 1
Value of Approval ;  New ;  Flat, unit or apartment in a building of three storeys ; |  |  | Original | A424176T | 1991-07-01 00:00:00 | 2011-03-01 00:00:00 | 237 | $'000 | FLOW | Month | 1
Value of Approval ;  New ;  Flat, unit or apartment in a building of four or more storeys ; |  |  | Original | A424728C | 1991-07-01 00:00:00 | 2011-03-01 00:00:00 | 237 | $'000 | FLOW | Month | 1
Value of Approval ;  New ;  Total flats, units or apartments, excl. [NAME] flats and other/unknown ; |  |  | Original | A417065V | 1991-07-01 00:00:00 | 2011-03-01 00:00:00 | 237 | $'000 | FLOW | Month | 1
Value of Approval ;  New ;  Total other residential building ; |  |  | Original | A419140V | 1970-07-01 00:00:00 | 2011-03-01 00:00:00 | 489 | $'000 | FLOW | Month | 1
Value of Approval ;  New ;  Total residential building ; |  |  | Original | A419826L | 1956-01-01 00:00:00 | 2011-03-01 00:00:00 | 663 | $'000 | FLOW | Month | 1
© Commonwealth of Australia  2011