tianzl66/Sheetpedia huggingface dataset:
Spreadsheet: 92515d1292071461-find-and-insert-log0
Sheet: List. de Gastos

MATERIAL GASTO NO MÊS DE DEZEMBRO 2010
CÓD. MATERIAL | DESIGNAÇÃO | 0 |  |  |  |  |  |  |  |  |  | 11 | 12 | 13 | 14 | 15 | 16 | TOTAL
 |  | 1 | 2 | 3 | 4 | 5 | 6 | 7 | 8 | 9 | 10
1 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 5
2 |  |  |  | 1
8 |  | 2 | 4
Spreadsheet: 196697d1354078695-find-expired-medication-in-my-medication-inventory-list-by-batchs-expiry-dates-medicines
Sheet: Prescription

Medicine | Dose | Frequency | Abbreviation | Counting from | Valid Days worth of Doses | Valid Months Worth of Doses | Rx finishes
Sertraline | 25mg | every day
[NAME] | 100mg | twice a day |  | 2012-11-25 00:00:00
Amlodipine | 5mg | every day |  | 2012-11-25 00:00:00
Cozaar | 50mg | every day |  | 2012-11-25 00:00:00
Proscar | 1mg | every day |  | 2012-11-25 00:00:00
Spreadsheet: c8d0ae5d-7e0a-4f77-b1e2-e2d06187c16b
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
FBWME | Test | FBWME | Bayberry/Wax Myrtle (Myrica spp) IgE | Bayberry/Wax Myrtle IgE | ImmunoCAP (FEIA) | Plain, Red-Top Tube: Red |  |  | 0.5 | mL | Draw blood in a plain red-top tube(s), serum gel tube(s) is acceptable. Spin down and send 0.5 mL of serum refrigerated in a plastic vial. | 0.5 mL | Hemolysis	NA Thawing	Warm OK; Cold OK Lipemia	Mild OK; Gross reject Icterus	NA Other	NA | <[NAME]/L   Test Performed by: Viracor-IBT Laboratories                              1001 NW Technology Dr                              Lee's Summit, MO 64086 | Monday through Friday | 1 - 2 days | 3 - 6 days | 1 | 86003 |  |  |  |  | Viracor-IBT Laboratories
FBWME | [NAME] | SERUM | Serum |  |  |  | Refrigerated | 28 days
FBWME | Result | Z3130 | Bayberry/Wax Myrtle IgE | Bayberry/Wax Myrtle IgE | Alphanumeric |  |  |  |  |  |  |  |  |  |  |  |  |  |  | In Process
FBWME | Result | Z3131 | Class | Class | Alphanumeric |  |  |  |  |  |  |  |  |  |  |  |  |  |  | In Process
Spreadsheet: 874659d1721217680-formula-to-create-an-index-for-groups-that-increased-by-1-at-each-change-in-a-text-value-rpost
Sheet: Sheet1

 |  |  |  |  | TEXT | TEX T | Group Index
 |  | A |  |  | A
 |  | B |  |  | A
 |  | C |  |  | A
 |  | D |  |  | A
 |  | A |  |  | C
 |  | D |  |  | C
 |  | T |  |  | C
 |  | R |  |  | C
 |  | T |  |  | C
 |  | A |  |  | C
 |  | G |  |  | A
 |  | H |  |  | A
 |  | G |  |  | A
 |  | R |  |  | A
 |  | A |  |  | D
 |  |  |  |  | D
 |  |  |  |  | D
Spreadsheet: 117355d1312713309-excel-2008-almost-solved-vlookup-offset-match-and-countif-copy-of-student-records-and-database
Sheet: Pictures

MemberName | Carlton | [NAME] | Nutbush | Richman | Silverton | Ajob | Henroit | Witchman | Nolan | Percival | Atkins | Goldstein | [NAME] | Edwards | [NAME] | Willis | Ithard | [NAME] | Western | National | Constanine | Royce | Scott | Green | Hanratty
Picture
Member [NAME]
Spreadsheet: 32981d1229173705-a-formula-to-read-values-from-other-sheets-pivot-table-test
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
Spreadsheet: 175268d1345474020-simple-interest-amortization-schedule-i-am-trying-to-model-this-horizontally-amortization
Sheet: Sheet1

1 | Loan Number | Original Principal Balance | Current Principal Balance | Original Interest Rate | [NAME] | Loan Amortization | Note Date | First Payment Date | Rate Type | Loan Product | Index | Margin | Periodic Adjust Period | First Rate Adjustment Date | Fixed Rate Period |  |  | 1
 | 12345 | 500000 | xxxx | 0.055 | 360 | 360 | 2009-11-07 00:00:00 |  | Fixed |  |  |  |  | 2039-12-01 00:00:00 | 360
 |  | 500000 | xxxx | 0.05 | 360 | 360 | 2010-01-15 00:00:00 | 2010-02-01 00:00:00 | Adjustable | 3/1 Arm | 1 Year Libor | 0.03 | 6 | 2013-02-01 00:00:00 | 36
Spreadsheet: 126664d1319812809-column-names-column-names
Sheet: Sheet1

Money | Fines
 | 1
 | 2
 | 3
99 | 4
98 | 5
97 | 6
96 | 7
95 | 8
94 | 9
93 | 10
92 | 11
91 | 12
90 | 13
89 | 14
88 | 15
87 | 16
86 | 17
85 | 18
84 | 19
83 | 20
82
81
80
Spreadsheet: 709128d1608178566-count-peolple-with-1-condition-count-people
Sheet: DL

Time | People | Product |  | Product | A |  |  |  |  |  |  |  |  |  |  |  |  |  | A
2020-12-01 00:00:00 | Anh | D |  | Result |  |  | [NAME] |  |  |  |  |  |  |  |  |  |  |  | B
2020-12-01 00:00:00 | Son | C |  |  |  |  | Linh |  |  |  |  |  |  |  |  |  |  |  | C
2020-12-02 00:00:00 | [NAME] | A |  |  |  |  | Ngoc |  |  |  |  |  |  |  |  |  |  |  | D
2020-12-02 00:00:00 | Linh | A |  |  |  |  | [NAME]
2020-12-03 00:00:00 | Ngoc | A |  |  |  |  | Anh
2020-12-03 00:00:00 | Ngoc | A |  |  |  |  | [NAME]
2020-12-04 00:00:00 | Chi | D |  |  |  |  | [NAME]
2020-12-04 00:00:00 | [NAME] | B |  |  |  |  | Thai
2020-12-04 00:00:00 | Son | B
2020-12-04 00:00:00 | Anh | C
2020-12-04 00:00:00 | [NAME] | A
2020-12-05 00:00:00 | [NAME] | B
2020-12-05 00:00:00 | Anh | A
2020-12-05 00:00:00 | Thai | C
2020-12-06 00:00:00 | [NAME] | B
2020-12-06 00:00:00 | Thai | D
2020-12-06 00:00:00 | [NAME] | B
2020-12-07 00:00:00 | [NAME] | D
2020-12-08 00:00:00 | Son | B
2020-12-09 00:00:00 | [NAME] | C
2020-12-10 00:00:00 | [NAME] | A
2020-12-11 00:00:00 | [NAME] | B
2020-12-12 00:00:00 | Linh | D
2020-12-13 00:00:00 | [NAME] | D
2020-12-14 00:00:00 | Anh | A
2020-12-15 00:00:00 | [NAME] | B
2020-12-16 00:00:00 | Son | B
2020-12-17 00:00:00 | [NAME] | A
2020-12-18 00:00:00 | [NAME] | B
2020-12-19 00:00:00 | [NAME] | D
2020-12-20 00:00:00 | [NAME] | A
2020-12-21 00:00:00 | Linh | C
2020-12-22 00:00:00 | Ngoc | D
2020-12-23 00:00:00 | [NAME] | B
2020-12-24 00:00:00 | [NAME] | A
2020-12-25 00:00:00 | Thai | B
2020-12-26 00:00:00 | Thai | D
2020-12-27 00:00:00 | [NAME] | C
2020-12-28 00:00:00 | [NAME] | A
2020-12-29 00:00:00 | [NAME] | B
2020-12-30 00:00:00 | Linh | D
2020-12-31 00:00:00 | Ngoc | D
2021-01-01 00:00:00 | [NAME] | B
2021-01-02 00:00:00 | Thai | A
2021-01-03 00:00:00 | Son | C
2021-01-04 00:00:00 | Chi | D
2021-01-05 00:00:00 | [NAME] | A
2021-01-06 00:00:00 | [NAME] | C
2021-01-07 00:00:00 | Chi | D
2021-01-08 00:00:00 | Linh | C
Spreadsheet: 41496d1239969570-formula-similar-to-vlookup-needed-program-1704
Sheet: Forearms & Neck

 | Forearms |  |  | Other |  |  | Neck
 | Dumbbell Wrist Flippers |  | 1 | Lying Butt Bridge |  |  | Isometric Neck Exercises - Front & Back
1 | Palms [NAME] Wrist Curls |  |  | [NAME] |  |  | Isometric Neck Exercises - Sides
 | Palms Up Barbell Wrist Curls |  | 2 | Leg Lifts |  | 1 | Lying Face Down Plate Neck Resistance
 | Palms Up Dumbbell Wrist Curls |  |  | One Legged Cable Kickbacks |  | 2 | Lying Face Up Place Neck Resistance
 | [NAME] Curls |  |  | [NAME] |  |  | Seated Head Harness Neck Resistance
 | Reverse Barbell [NAME] |  |  | Single Dumbbell Squats |  |  | Standing Head Harness Neck Resistance
 | Reverse Cable Curls |  |  | Smith Machine Deadlifts |  |  | Head Forward Backward
 | Seated Dumbbell Palms [NAME] |  |  | [NAME] |  |  | Circular Motions
 | Seated Dumbbell Palms Up Wrist Curls |  |  | Leg Presses |  |  | Head Side To Side
 | Single Arm Dumbbell Palms [NAME] |  |  | Exercise Ball Butt Lifts |  |  | Head [NAME]
 | Single Arm Dumbbell Palms Up Wrist Curls |  |  | Dumbbell Bench Step Ups
2 | Seated Palm Up Barbell Wrist Curls |  |  | Smith Machine Squats
 | Seated Palms Down Barbell Wrist Curls |  |  | Elastic Band Kickbacks
 | Seated Low Cable [NAME] |  |  | Exercise Ball Butt Raises
 | Standing Dumbbell Reverse Curls |  |  | Exercise Ball Leg Lifts
 | Standing Plate Fingertip Raises
 | Barbell Wrist Curls Behind The Back
 | Two Arm Palms [NAME] Curls
 | Two Arm Palms Up Wrist Curls
 | [NAME]
Spreadsheet: 0113d040-a519-4ad6-bb1a-393fdfa6e11c
Sheet: Template

AGENCY: | Denver
MO / YR: | 2011-10-01 00:00:00
DOB | VACCINE FUNDING | PAYER SOURCE | PAYER SOURCE - WRITE IN | PRIVATE INSURER NAME | [NAME] IN | WHY VISIT LPHA? | WHY VISIT - WRITE IN | AMOUNT PATIENT PAID | VACCINE 1 | VACCINE 2 | VACCINE 3 | VACCINE 4 | VACCINE 5 | VACCINE 6 | VACCINE 7 | VACCINE 8 | VACCINE 9
Spreadsheet: 680832d1591214630-formula-to-pull-data-from-another-sheet-sum
Sheet: FInal

 |  |  |  |  |  |  |  |  |  | Jan
 |  | Gross | FICA | Mcare | Fed Tax | State Tax | Net |  |  | Feb
A | Apr |  |  |  |  |  |  |  |  | Mar
 |  |  |  |  |  |  |  |  |  | Apr
 |  |  |  |  |  |  |  |  |  | May
 |  |  |  |  |  |  |  |  |  | Jun
 |  |  |  |  |  |  |  |  |  | Jul
 |  |  |  |  |  |  |  |  |  | Aug
 |  |  |  |  |  |  |  |  |  | Sep
 |  |  |  |  |  |  |  |  |  | Oct
 |  |  |  |  |  |  |  |  |  | Nov
 |  |  |  |  |  |  |  |  |  | Dec
Spreadsheet: ed4d21af-6002-47fd-9917-80afbfa93232
Sheet: TableS3

Table S3. Number of gene-disease associations for genes studied at least 50 times, by gene category*, 2001-2010
[NAME] | Gene | HBV | HCV | HIV | Hpylori | Malaria | Sepsis | TB | Other | Total
TNF & related genes
 | TNF | 32 | 38 | 23 | 50 | 21 | 41 | 20 | 155 | 380
 | LTA | 3 | 4 | 3 | 12 | 6 | 16 | 4 | 25 | 73
HLA Class II & related genes
 | HLA-DRB1 | 32 | 40 | 31 | 17 | 8 | 4 | 24 | 137 | 293
 | HLA-DQB1 | 15 | 23 | 23 | 15 | 5 | 3 | 14 | 89 | 187
 | HLA-DQA1 | 11 | 6 | 2 | 11 | 1 | 1 | 4 | 35 | 71
Cytokine & related genes
 | IL10 | 26 | 31 | 20 | 40 | 7 | 27 | 21 | 117 | 289
 | IL1B | 9 | 8 | 8 | 104 | 4 | 15 | 6 | 59 | 213
 | IL6 | 8 | 10 | 7 | 11 | 1 | 24 | 3 | 89 | 153
 | IFNG | 17 | 17 | 6 | 4 | 4 | 5 | 28 | 67 | 148
 | IL1RN | 6 | 4 | 2 | 71 | 2 | 8 | 4 | 44 | 141
 | IL4 | 5 | 8 | 17 | 9 | 11 | 4 | 4 | 48 | 106
 | IL1A | 1 | 3 | 8 | 9 | 2 | 5 | 2 | 32 | 62
 | IL8 | 1 | 0 | 2 | 30 | 1 | 3 | 1 | 23 | 61
 | IL12B | 3 | 6 | 5 | 2 | 4 | 5 | 9 | 19 | 53
 | TGFB1 | 13 | 26 | 2 | 8 | 1 | 4 | 7 | 48 | 109
Chemokine receptor & related genes
 | CCR5 | 8 | 19 | 153 | 0 | 1 | 5 | 2 | 28 | 216
 | [NAME] | 1 | 8 | 78 | 0 | 1 | 1 | 0 | 8 | 97
 | CXCL12 | 2 | 2 | 59 | 0 | 0 | 2 | 1 | 3 | 69
HLA Class I & related genes
 | HLA-A | 7 | 15 | 40 | 4 | 5 | 3 | 6 | 54 | 134
 | HLA-B | 9 | 18 | 83 | 4 | 6 | 5 | 9 | 71 | 205
 | HLA-C | 7 | 19 | 29 | 3 | 0 | 4 | 0 | 30 | 92
Complement & MBL genes
 | MBL2 | 9 | 11 | 22 | 3 | 5 | 26 | 13 | 106 | 195
Toll-like receptor genes
 | TLR4 | 3 | 6 | 11 | 19 | 8 | 25 | 10 | 79 | 161
 | TLR2 | 2 | 2 | 5 | 6 | 5 | 11 | 14 | 41 | 86
 | CD14 | 2 | 3 | 0 | 10 | 0 | 26 | 3 | 36 | 80
Metal transport genes
 | SLC11A1 | 0 | 1 | 3 | 0 | 0 | 0 | 40 | 25 | 69
Red blood cell genes
 | HFE | 13 | 40 | 8 | 0 | 1 | 0 | 0 | 4 | 66
Ig Fc & related receptor genes
 | FCGR2A | 1 | 0 | 7 | 0 | 12 | 8 | 1 | 30 | 59
Genes not categorized
 | TP53 | 7 | 5 | 2 | 10 | 0 | 0 | 0 | 77 | 101
 | ABCB1 | 1 | 0 | 46 | 6 | 2 | 0 | 2 | 4 | 61
 | VDR | 8 | 1 | 7 | 0 | 1 | 1 | 24 | 17 | 59
 | CYP2C19 | 0 | 1 | 5 | 44 | 1 | 0 | 1 | 4 | 56
 | GSTM1 | 10 | 4 | 1 | 10 | 1 | 1 | 8 | 21 | 56
Grand Total |  | 272 | 379 | 718 | 512 | 127 | 283 | 285 | 1625 | 4201
*Categories based on Kaslow et al., 2008.
Spreadsheet: 688769d1595946068-need-formula-to-populate-column-sample
Sheet: Sheet1

Interaction | Activity
Club | Grappling
Club | Flag Football
Club | Fitness
Club | Sandhurst
Club | Fitness
Club | Sandhurst
Club | Snow Sports (Club Skiing)
Club | [NAME] Do
Club | Pre-Medical Society of West Point
Club | Fellowship of Christian Athletes
Club | Flickerball
Club | Flag Football
Club | Flickerball
Spreadsheet: 845240d1696761815-problem-incrementing-or-decrementing-a-cells-value-based-on-a-filters-value-golfscoresmultiplayerold-aligw
Sheet: Summary

 | Golf Scores - Team Summary |  |  |  |  |  |  |  |  |  | Team: | Team2
 | Rounds Played |  |  |  | High Score |  |  |  |  |  |  |  |  | Data Entry |  |  | Below Par
 |  |  |  |  | [NAME] |  |  |  |  |  |  |  |  | Par |  |  | Most frequent
 |  | 1st | 2nd | 3rd | 4th | 5th | 6th | 7th | 8th | 9th | Front | 10th | 11th | 12th | 13th | 14th | 15th | 16th | 17th | 18th | Back | Total
 | Course Par | 4 | 4 | 3 | 5 | 4 | 4 | 4 | 3 | 4 |  | 4 | 4 | 3 | 4 | 5 | 3 | 4 | 4 | 5
 | HighScore
 | AvScore
 | <= -3 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | -3
 | Eagles |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | -2
 | Birdies |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | -1
 | Pars |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 0
 | Bogeys |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 1
 | Double Bogeys |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 2
 | >= +3 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 3
 | Total
Spreadsheet: 163407d1340293329-excel-2007-conditional-formating-based-on-two-sets-of-text-transport-conditional-formatting-dummy-file_reply
Sheet: Sheet1

Call time | Purpose / comments |  |  | Text to look up > | Pick Up Time | Pick Up Time
time 1 | Transport - pick up date XX/XX/XX pick up time x:[NAME] | < - I want this to be filled with color1 |  |  | City1 | City2
time 2 | benefits inquiry - member location [NAME] | < - I want no fill on this because while it contains city1 it does NOT contain "pick up date"
time 3 | Transport - pick up date XX/XX/XX pick up time x:xx pm city2 | < - I want this to be filled with [NAME]
time 4 | transport inquiry - member asked about available transport in city2 | < - no fill
time 5
time 6
 |  | basically I want cells with "pick up date" AND "city1" to be auto filled with color 1
 |  | and cells with "pick up date" AND "city2" to be auto filled with [NAME]
 |  | and cells containing "city1" or "city2" WITHOUT the words "pick up date" to be left alone
 |  | Conditional Formula for Yellow
 |  | =SUMPRODUCT((ISNUMBER(SEARCH($G$1:$G$2,B2)))*1)=2
 |  | Conditional Formula for Blue
 |  | =SUMPRODUCT((ISNUMBER(SEARCH($F$1:$F$2,B2)))*1)=2
Spreadsheet: 55167d1255316668-cell-priorities-time
Sheet: Sheet1

 | Return Date:
 | Dept. Date: |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | =ROUND(U12*24,1).
[NAME] |  |  |  |  |  |  | CLA TIME |  |  |  | CURRENCY |  |  |  |  | FUEL |  |  |  | PER DIEM |  |  | ZULU |  | PER DIEM
Leg | DATE | B/P/C | PF | FROM | TO |  | T.O. | FLIGHT | LDG |  | NIGHT | D/N | P/N | HOLD |  | OUT | IN | TOTAL |  |  |  |  | T.O. | LDG
1 | 2009-10-10 00:00:00 |  |  | VNY | [NAME] |  | 06:00:00 | 02:30:00 |  |  | 00:00:00 |  |  |  |  | 29000 | 0 |  |  |  |  |  |  |  | 2.25
2 | 2009-10-10 00:00:00 |  |  |  | lfpb |  | 10:00:00 | 08:00:00 |  |  | 00:00:00 |  |  |  |  |  | 0 |  |  |  |  |  |  |  | 2.25
3 | 2009-10-10 00:00:00 |  |  |  |  |  | 18:30:00 | 01:00:00 |  |  | 00:00:00 |  |  |  |  |  | 0 |  |  |  |  |  |  |  | 2.25
4 | 2009-10-10 00:00:00 |  |  |  |  |  | 19:45:00 | 00:30:00 |  |  | 00:00:00 |  |  |  |  |  | 0 |  |  |  |  |  |  |  | 2.25
5 | 2009-10-10 00:00:00 |  |  |  |  |  | 20:30:00 | 00:45:00 |  |  | 00:00:00 |  |  |  |  |  | 0 |  |  |  |  |  |  |  | 2.25
6 | 2009-10-11 00:00:00 |  |  |  |  |  | 21:30:00 | 00:45:00 |  |  | 00:00:00 |  |  |  |  |  | 0 |  |  |  |  |  |  |  | 2.25
7 |  |  |  |  |  |  | 00:00:00 | 00:00:00 |  |  | 00:00:00 |  |  |  |  |  | 0
8 |  |  |  |  |  |  | 00:00:00 | 00:00:00 |  |  | 00:00:00 |  |  |  |  |  | 0
9 |  |  |  |  |  | 3 | 00:00:00 | 00:00:00 |  |  | 00:00:00 |  |  |  |  |  | 0
 | PST | 8:00:00
 | DST | 7:00:00
 | Today
 |  |  |  |  | HOURS |  |  | CYCLES |  |  |  |  |  |  |  | In U9 and copy down, =ROUND((J9 - B$9 - H$9)*1440, 0)/1440
Spreadsheet: 818033d1676559107-expected-outcome-based-on-2-criteria-sample-workbook-3-
Sheet: Sheet1

 |  |  |  |  |  | EXPECTED OUTCOME
CAAS | Account Name | GL Balance | Supporting Balances |  |  | GL Balance | Unreconciled/Out of balance
[PHONE]-0224241-0000000-Canadian Dollar | DIRECT FINANCE LEASE RECEIVABLE-NONUS-IL | 70689528.37
[PHONE]-0224241-0000000-Canadian Dollar | UNEARNED FINANCE INCOME-DIRECT LEASE FIN-NONUS-IL | -4952720.45
[PHONE]-0023313-0000000-US Dollar | SECURITY DEPOSIT- IL | 23850
[PHONE]-0027353-0000000-US Dollar | SECURITY DEPOSIT- IL | 87606.3
[PHONE]-0240685-0000000-US Dollar | SECURITY DEPOSIT- IL | 92287.6
[PHONE]-0228034-0000000-Statistical | 30-89 DAYS PD-LOANS TO NONDEPOSITORY FINANCIAL INST-IL | 41010.68
[PHONE]-0240685-0000000-Statistical | 30-89 DAYS PD-LOANS OF STATE/POLITICAL SUBDIVISIONS-IL | 20519.89
[PHONE]-0224241-0000000-Statistical | 30-89 DAYS PD LOANS TO NON-US GOVERNMENTS-IL | 245.31
[PHONE]-0228029-0000000-Statistical | COMMERICAL LOAN UNDISBURSED COMMITMENTS-IL | 3358079
[PHONE]-0211738-0000000-Statistical | COMMERICAL LOAN UNDISBURSED COMMITMENTS-IL | 21620219.08
[PHONE]-0228020-0000000-Statistical | COMMERICAL LOAN UNDISBURSED COMMITMENTS-IL | 10064980.9
[PHONE]-0228021-0000000-Statistical | 30-89 DAYS PAST DUE-COMMERICAL LOANS-IL | 203303.79
[PHONE]-0228036-0000000-Statistical | 30-89 DAYS PAST DUE-COMMERICAL LOANS-IL | 58774.15
[PHONE]-0240695-0000000-Statistical | ASC 842-30-89 DPD-NONDEPOSITORY INSTITUTIONS-IL | 2134.88
 |  |  |  | TOTAL
Spreadsheet: 136701d1326796567-using-several-datasheet-to-generate-a-form-fc-mapping-example
Sheet: IT

Position /Competency Mapping
Proficiency Level Table  : IT Department
 |  |  | Functional Competency
 |  |  | Back up and Recovery System Management | Database Management | Helpdesk support and management | IT Project management | IT Service Management | LAN and Server management | Software Management | System Analysis and Design | System Development
Competency Level: |  |  | FC011 | [NAME] | FC038 | FC045 | [NAME] | FC048 | FC076 | FC081 | FC082
Position Title:
Senior IT Manager |  |  |  |  |  | 5 | 5 | 3 | 5
Application Section Manager |  |  |  | 5 |  | 4 | 3 |  | 5 | 5 | 4
Spreadsheet: 18deace4-4ee8-4622-b1b6-b7ec3bc7a858
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
 | 5671.0 Lending Finance, Australia
 | TABLE 40. OPERATING LEASE FINANCE COMMITMENTS: By Lender: Australia, Original ($000)
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
Banks ; |  |  | Original | A2413831L | 1985-01-01 00:00:00 | 2011-06-01 00:00:00 | 318 | $'000 | FLOW | Month | 1
Finance Companies ; |  |  | Original | A2413832R | 1985-01-01 00:00:00 | 2011-06-01 00:00:00 | 318 | $'000 | FLOW | Month | 1
General Financiers ; |  |  | Original | A2413833T | 1985-01-01 00:00:00 | 2011-06-01 00:00:00 | 318 | $'000 | FLOW | Month | 1
Other Lessors ; |  |  | Original | A2413834V | 1985-01-01 00:00:00 | 2011-06-01 00:00:00 | 318 | $'000 | FLOW | Month | 1
TOTAL OPERATING LEASE FINANCE ; |  |  | Original | A2413835W | 1985-01-01 00:00:00 | 2011-06-01 00:00:00 | 318 | $'000 | FLOW | Month | 1
© Commonwealth of Australia  2011
Spreadsheet: 46293d1245192363-calculating-the-number-of-days-within-differing-years-days_in_year
Sheet: Days

 |  |  | 1995-04-01 00:00:00 | 1996-04-01 00:00:00 | 1997-04-01 00:00:00 | 1998-04-01 00:00:00 | 1999-04-01 00:00:00 | 2000-04-01 00:00:00 | 2001-04-01 00:00:00 | 2002-04-01 00:00:00 | 2003-04-01 00:00:00 | 2004-04-01 00:00:00 | 2005-04-01 00:00:00 | 2006-04-01 00:00:00 | 2007-04-01 00:00:00
 |  | Total days | 1996-03-31 00:00:00 | 1997-03-31 00:00:00 | 1998-03-31 00:00:00 | 1999-03-31 00:00:00 | 2000-03-31 00:00:00 | 2001-03-31 00:00:00 | 2002-03-31 00:00:00 | 2003-03-31 00:00:00 | 2004-03-31 00:00:00 | 2005-03-31 00:00:00 | 2006-03-31 00:00:00 | 2007-03-31 00:00:00 | 2008-03-31 00:00:00 | Total
2001-10-26 00:00:00 | 2002-09-21 00:00:00 | 331 | 0 | 0 | 0 | 0 | 0 | 0 | 157 | 174 | 0 | 0 | 0 | 0 | 0 | 331
2000-11-09 00:00:00 | 2002-08-25 00:00:00 | 655 | 0 | 0 | 0 | 0 | 0 | 143 | 365 | 147 | 0 | 0 | 0 | 0 | 0 | 655
2001-05-10 00:00:00 | 2006-05-27 00:00:00 | 1844 | 0 | 0 | 0 | 0 | 0 | 0 | 326 | 365 | 366 | 365 | 365 | 57 | 0 | 1844
2000-02-01 00:00:00 | 2000-12-18 00:00:00 | 322 | 0 | 0 | 0 | 0 | 60 | 262 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 322
2002-05-09 00:00:00 | 2007-10-21 00:00:00 | 1992 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 327 | 366 | 365 | 365 | 365 | 204 | 1992
1999-07-01 00:00:00 | 2004-04-07 00:00:00 | 1743 | 0 | 0 | 0 | 0 | 275 | 365 | 365 | 365 | 366 | 7 | 0 | 0 | 0 | 1743
1996-07-07 00:00:00 | 2001-11-01 00:00:00 | 1944 | 0 | 268 | 365 | 365 | 366 | 365 | 215 | 0 | 0 | 0 | 0 | 0 | 0 | 1944
2001-07-15 00:00:00 | 2002-12-04 00:00:00 | 508 | 0 | 0 | 0 | 0 | 0 | 0 | 260 | 248 | 0 | 0 | 0 | 0 | 0 | 508
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 1
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 2
 | [NAME] |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 3
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 4
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 5
Spreadsheet: 89059d1288818662-adding-subtracting-cell-addresses-kr335606-filling-a-dynamic-number-of-cells
Sheet: Sheet1

 |  | Start | 99
 |  | 15