tianzl66/Sheetpedia huggingface dataset:
Spreadsheet: 742875d1628087426-return-text-if-text-found-in-column-or-sum-column-if-just-numerical-values-support-suggestion
Sheet: Data

 | Load On Trapeze [NAME] at Centre (kN)
Member | 1 | 1.25 | 1.5 | 1.75 | 2 | Safety Factor Applied
P1000T - 41x41 Slotted Unistrut | 2 | 1.6 | 1.3 | 1.1 | 1 | 1.35 Permanent Action, 1.5 Variable | Are any Safety Factors used?
P5500T - 62 x 41 Slotted Unistrut | 3.7 | 2.9 | 2.4 | 2.1 | 1.85 | 1.35 Permanent Action, 1.5 Variable
P1001T - 83 x 41 BtB Slotted Unistrut | 6.1 | 4.9 | 4 | 3.5 | 3 | 1.35 Permanent Action, 1.5 Variable
PFC 100 x 50 | 13 | 11 | 9 | 7 | 6.5 | None applied
PFC 150 x 75 | 38 | 30 | 25 | 21 | 18.5 | None applied
All the above needs checking and validating
Spreadsheet: 752885d1635067382-move-data-from-one-sheet-to-another-which-matches-two-criteria-example-spreadsheet-1
Sheet: Google

 | Site 1 | Site 2 | Site 3 | Site 4 | Site 5
2021-11-01 00:00:00 | Full, Access Issue | Partial, Access Issue | Full | Full, Access Issue | Full
2021-11-02 00:00:00 | Full | Full, Access Issue | Full | None | None
2021-11-03 00:00:00 | Partial, Access Issue | Full | None | Partial, Access Issue | Full
2021-11-04 00:00:00 | Full | None | Full, Access Issue | Full | Partial, Access Issue
2021-11-05 00:00:00 | None | Full | Partial, Access Issue | Full | Full, Access Issue
ALL of the information above is pasted into this sheet from a Google form response. The amount of data will potentially increase an unknown amount of times (both the date as well as the name and number of sites) and the site names may change position  due to their location on the google sheet being moved as new columns are added over time.
The highlighted information then needs to be moved to a master sheet which has other information on it and "matched" to the correct site name and the correct date.
Spreadsheet: 169589d1342971723-if-statement-subtraction-help-ltruong110-example
Sheet: Sheet1

Product 1 | Link 1 | 10 |  |  |  |  |  | < This one sums column C for instances where there is no X in column D
Product 2 | Link 2 | 20 | x |  |  |  |  | < This one does as you asked and subtracts the values agains X's from the value in E2.
Product 3 | Link 3 | 30 |  |  |  |  |  | I prefer the first approach!
Product 4 | Link 4 | 40
Product 5 | Link 5 | 50
Spreadsheet: 786011d1656927765-checking-values-in-an-array-if-they-pass-a-certain-criteria-anode
Sheet: Sheet1

Angle Between supports; 90°; ±0.5°
Top |  |  |  | Bottom
AB | BC | CD | DA | EF | FG | GH | HE
90.11 | 89.84 | 90.03999999999999 | 90.00999999999999 | 90.09 | 89.91 | 90.09 | 89.90999999999997
90.07000000000001 | 90.00999999999999 | 89.94000000000003 | 89.97999999999996 | 89.88999999999999 | 90 | 89.94999999999999 | 90.16000000000003
89.96 | 90.03 | 90.03000000000003 | 89.97999999999996 | 90.00999999999999 | 90.03999999999999 | 90.06000000000003 | 89.88999999999999
Spreadsheet: 154236d1336328042-excel-paste-solution-khanabadosh_file00_06may12_01
Sheet: Sheet1

no. | [NAME] with paste | I want like this with paste special or formula |  | Helper Column | Repeating Values
1 | 1 | 1 |  | 1 | 1
 | 0 | 1 |  | 2 | 1
 | 0 | 1 |  | 3 | 1
 | 0 | 1 |  | 4 | 1
2 | 2 | 2 |  |  | 2
 | 0 | 2 |  |  | 2
 | 0 | 2 |  |  | 2
 | 0 | 2 |  |  | 2
3 | 3 | 3 |  |  | 3
 | 0 | 3 |  |  | 3
 | 0 | 3 |  |  | 3
 | 0 | 3 |  |  | 3
4 | 4 | 4 |  |  | 4
 |  |  |  |  | 4
 |  |  |  |  | 4
 |  |  |  |  | 4
Spreadsheet: 816731d1675795408-how-to-use-lookup-get-multiple-results-and-add-the-results-to-a-single-cell-textjoin-pd-sample
Sheet: Drop Downs

Employee List |  |  |  |  | Description | Fund |  | Description | Dept |  | Description | S/C | Rate |  | Acct |  | OT Earnings ID
PSID | Rcd | Name | Base |  | [NAME] | 48541 |  | Police | 43425 |  | Regular OT | 0 | OTPR |  | 601933 |  | OTPR
110350077 | 0 | BARBA, V | 3505 |  | [NAME] | 90000 |  | Parking | 43426 |  | [NAME]. | 0 | OTPR |  | 601935 |  | OTST
105089348 | 0 | BERGMAN, R | 6548 |  |  | 47205 |  | [NAME] | 63491 |  | COVID 19 | 0 | OTPR
101016366 | 0 | BEST, R | 4541 |  | [NAME] | 46715 |  | Chicano Youth | 62485 |  | [NAME] | 42508 | OTST |  |  |  | HOL Earnings ID
108770460 | 0 | BRANT, K | 4000 |  | Peach [NAME] | 496E5 |  | Feria de Educacion | 62485 |  | RAD - 49631 | 42504 | OTPR |  |  |  | HG6
14816 | 0 | CALDERA, M | 4280 |  | Vintage Days | 496F6 |  | Peach [NAME] | 35309 |  | Training | 42513 | OTPR |  |  |  | OT5
 |  |  |  |  |  |  |  | Vintage Days | 63491 |  | Investigations | 42503 | OTPR
 |  |  |  |  |  |  |  |  |  |  | Striking Activities | 42512 | OTPR
 |  |  |  |  |  |  |  | SD Earnings ID | Rate |  | E-WASTE OT | 42605 | OTPR
 |  |  |  |  |  |  |  | SHE08 | 0.23 |  | Library Services | 42517 | OTPR
 |  |  |  |  |  |  |  | SHGRV | 2.3 |  | Shuttle Service | 42637 | OTPR
 |  |  |  |  |  |  |  | SHN08 | 2.2 |  | [NAME] | 0 | OTPR
 |  |  |  |  |  |  |  | SHSWG | 1.35 |  | Chicano Youth Conference | 48509 | OTPR
 |  |  |  |  |  |  |  |  |  |  | Feria de Educacion | 48511 | OTPR
 |  |  |  |  |  |  |  |  |  |  | Peach [NAME] | 30903 | OTPR
 |  |  |  |  |  |  |  |  |  |  | Vintage Days | 0 | OTPR
Spreadsheet: 742779d1628025332-formula-to-dynamically-reference-cell-in-another-worksheet-sample
Sheet: Summary

 | Current Period | P7
Store 1 | Dept 1
Store 1 | Dept 2
Store 1 | Dept 3
Store 1 | Dept 4
Store 2 | Dept 1
Store 2 | Dept 2
Store 2 | Dept 3
Store 2 | Dept 4
Store 3 | Dept 1
Store 3 | Dept 2
Store 3 | Dept 3
Store 3 | Dept 4
Spreadsheet: 375930d1423412407-need-help-cleaning-up-pasted-text-and-comparing-two-lists-packingnotecomparison-2-
Sheet: Sheet2

Date:
Quantity
2
4
1
8
15
Packed By:
Signature
My Company name [NAME]
My company slogan
Ship To: Shipping Address: (If [NAME]) februari 8, 2015
[Name] [Name] Customer ID: [ABC12345]
[Company Name] [Company Name] Order Date
[Street Address] [Street Address] Purchase Order # [100001]
[City, ST ZIP Code] [City, ST ZIP Code] Salesperson [NAME]
[Phone] [Phone] Packing Date
Description
394948271
[NAME]
123jkhgjh
1546464321
Fatboy sugarbomb
hkjsdhjfkhsdf
1546464321
Fatboy sugarbomb
hkjsdhjfkhsdf WAYS OF SENDING A PACKING SLIP TO A CLIENT
Do not send an Excel Packing Slip file to your clients,
use PDF converter/printer to create a PDF file, that can
be sent to clients via email, alternative method is to print
it and send by mail service.
54878454888
High sugar no vitamins drink
1234545
Special Notes Total Quantity of Goods/Boxes
[Name]
Checked By: [Managers Name]
Thank you for your business! [Managers Signature]
Should you have any enquiries concerning this packing slip or your goods, please contact [NAME] on [PHONE]
111 Street, Town/City, County, ST, 00000
Tel: [PHONE] Fax: [PHONE] E-mail: [EMAIL] Web: www.yourcompanysite.com
Spreadsheet: 454294d1459781106-if-then-subtotal-subtotals
Sheet: Sheet1

Category | Code | Type | Hours | Rate | Subtotal Hrs | Cost | Subtotal Cost
Activity | 1 | ORDINARY HOURS | 311 | 8669.38
Activity | 2 | ANNUAL LEAVE | 93.5 | 2606.4
Activity | 22 | ANNUAL LEAVE LOADING | 93.5 | 456.11
Activity | 52 | PUBLIC HOLIDAY- NOT WRKD | 22 | 613.28
Activity | 55 | COMPASSIONATE LEAVE | 5.5 | 153.32
Total 221 ACOSTA
Activity | 1 | ORDINARY HOURS | 262 | 6916.11
Activity | 2 | ANNUAL LEAVE | 11.5 | 303.57
Activity | 3 | SICK LEAVE WITH CERTIFICATE | 61 | 1610.24
Activity | 12 | TERM - A/L - POST 17/8/93 | 85.0786 | 2245.85
Activity | 14 | TERMINATION - A/L LOADING | 85.0786 | 393.02
Activity | 22 | ANNUAL LEAVE LOADING | 11.5 | 53.13
Activity | 68 | JURY DUTY | 7.5 | 197.98
Total 1134 AGUIRRE
Activity | 1 | ORDINARY HOURS | 545.9 | 18705.69
Activity | 2 | ANNUAL LEAVE | 30.4 | 1041.68
Activity | 3 | SICK LEAVE WITH CERTIFICATE | 7.6 | 260.42
Activity | 4 | SICK LEAVE WITHOUT CERTIFICATE | 7.6 | 260.42
Activity | 22 | ANNUAL LEAVE LOADING | 30.4 | 182.29
Activity | 52 | PUBLIC HOLIDAY- NOT WRKD | 15.2 | 520.84
Allowance | 5 | INTERP ALL [NAME] 38 HOURS |  | 57.69
Total 619 ALBREIHI
Activity | 1 | ORDINARY HOURS | 13 | 403.07
Activity | 52 | PUBLIC HOLIDAY- NOT WRKD | 4.5 | 139.52
Allowance | 2 | PM'S - REGISTERED NURSES |  | 51.8
Total 1251 AL-HASSANY
Spreadsheet: 751613d1634208409-forecast-formula-test-file1
Sheet: Sheet3

YTD Score | Glidepath
-100 |  |  |  |  |  | 60
50 |  |  |  |  |  | 60
40 |  |  |  |  |  | 60
20 |  |  |  |  |  | 60
100 |  |  |  |  |  | 60
50 |  |  |  |  |  | 60
80 |  |  |  |  |  | 60
70 |  |  |  |  |  | 60
50 |  |  |  |  |  | 60
60 |  |  |  |  |  | 60
 | Month 1 | Month 2 | Month 3 | Month 4 | Month 5 | Month 6
Spreadsheet: darrell_schoolcraft__7323__imball0202
Sheet: Agave

Agave imbalance
 | Measured | Scheduled | Imbalance
56339 |  | 635781
78311 |  | 219800 |  |  |  |  |  |  |  | 2000-01-06 00:00:00 | paper | 0.5
500238 |  | 715088 |  |  |  |  |  |  |  |  | lunch | 7.6
500239 |  | 634379
500293 |  | 385310
500302 |  | 5757
500303 |  | 17263
500305 |  | 1001188
500307 |  | 38470
500313 |  | 1826
500314
500655
500657 |  | 32848
INDEX
2002-01-31 00:00:00 |  |  | 121616.94
2002-02-19 00:00:00
CBS Volume
 |  |  | 70652
Spreadsheet: 286815d1388471215-how-to-rum-conditional-formating-for-several-words-using-text-that-contains-conditional-formatting-for-several-words
Sheet: Sheet1

 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | Named
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | Range
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | "checks"
 | Can you get lice from buying a flat iron from [NAME]? |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | lice
 | Could you help me get rid of lice PLEASE? |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | far
 | can one purchase crab lice? |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | can
 | friends help: how can you get body lice?
 | OMG! LICE! help.. are there any natural products?
 | Where could you go to get head lice out and how much would it cost?
 | Head Lice--Can You Help Your Child Avoid It?
 | Are there any home remedies for head lice on furniture carpet etc?
 | Are there any lice free treatments without a comb?
 | Are there any remedies for head lice?
 | Are there lice eggs in Dr. [NAME]?
 | Are there signs of lice if so what are they <3?
 | Can one nit cause lice?
 | Can you shower right after you have a de-lice treatment?
 | Can you use lice treatment to get rid of fleas?
 | Could you get head lice from fleas?
 | Could you get lice from a racoon that has been dead for several days?
 | How can one person only get one lice bug?
 | How far can a lice bug jump to its next host?
 | How far can lice jump?
 | How far can lice jump from human to human?
 | How far do lice and fleas jump?
 | How many different species of lice are there?
 | Would you like to add more questions?
 | There may be many more !
 | Is it bad to have lice?
 | what can be done about it?
 | Should I shave my scalp?
 | How far am I from dead?
Spreadsheet: 537300d1504936302-combining-2-rows-into-1-final-invoice-1-
Sheet: page 5

Description of Goods |  |  |  |  | Quantity | Cost | Total
Item # | Color | UPC Code | Country Origin | HS Code
[NAME]: 8cm Tassels x6 [NAME] |  |  |  |  | 12 | 1.28 | 15.36
CD554B | B) Glam | 775749206395 | CHINA | 5808.90.0000
[NAME]: 8cm Tassels x6 [NAME] |  |  |  |  | 12 | 1.28 | 15.36
CD554C | C) Classic | 775749206401 | CHINA | 5808.90.0000
[NAME]: 1/2"-1" Mini Wood Ladybugs x15 Peel-n-Stick |  |  |  |  | 36 | 0.82 | 29.52
CD672 | - | 775749128017 | CHINA | 4421.90.9099
[NAME]: 1" Mini Wood Clothespins x40 Fashion Colors Asst |  |  |  |  | 24 | 0.82 | 19.68
CD676A | A) Pastel | 775749194876 | CHINA | 4421.90.9099
[NAME]: 1" Mini Wood Clothespins x40 Fashion Colors Asst |  |  |  |  | 24 | 0.82 | 19.68
CD676B | B) Glamour | 775749194883 | CHINA | 4421.90.9099
[NAME]: 1" Mini Wood Clothespins x40 Fashion Colors Asst |  |  |  |  | 24 | 0.82 | 19.68
CD676C | C) Neon | 775749194890 | CHINA | 4421.90.9099
[NAME]: Chalk-It-Up Tags w/Cord x6 |  |  |  |  | 24 | 0.68 | 16.32
CD920A | A) [NAME] | 775749202052 | CHINA | 4821.90.0000
[NAME]: Chalk-It-Up Tags w/Cord x6 |  |  |  |  | 24 | 0.68 | 16.32
CD920B | B) Round Tags | 775749202069 | CHINA | 4821.90.0000
[NAME]: [NAME] |  |  |  |  | 24 | 0.68 | 16.32
CD944A | A) Heart w/Natural Edge | 775749195477 | CHINA | 9610.00.0000
[NAME]: [NAME] |  |  |  |  | 24 | 0.68 | 16.32
CD944B | B) Bracket w/White Border | 775749195484 | CHINA | 9610.00.0000
[NAME]: [NAME] |  |  |  |  | 24 | 0.68 | 16.32
[NAME] | C) Bracket w/Natural Edge | 775749195491 | CHINA | 9610.00.0000
[NAME]: [NAME] |  |  |  |  | 24 | 0.75 | 18
CD945A | A) Bracket w/White Border | 775749208511 | CHINA | 9610.00.0000
[NAME]: [NAME] |  |  |  |  | 24 | 0.75 | 18
CD945B | B) Bracket w/Natural Border | 775749208528 | CHINA | 9610.00.0000
[NAME]: Chalkboard Wall Plaque w/Jute Cord Hanger |  |  |  |  | 24 | 1.28 | 30.72
CD949A | A) [NAME] | 775749200225 | CHINA | 9610.00.0000
[NAME]: Chalkboard Wall Plaque w/Jute Cord Hanger |  |  |  |  | 24 | 1.28 | 30.72
CD949B | B) Oval Designer | 775749200232 | CHINA | 9610.00.0000
[NAME]: Chalkboard Wall Plaque w/Jute Cord Hanger |  |  |  |  | 24 | 1.28 | 30.72
CD949C | C) Bracket Border | 775749200249 | CHINA | 9610.00.0000
[NAME]: [NAME] w/Jute Cord Hanger |  |  |  |  | 24 | 0.88 | 21.12
CD950E | E) Arrow | 775749199185 | CHINA | 9610.00.0000
[NAME]: Chalkboard Wall Plaque w/Jute Cord Hanger |  |  |  |  | 24 | 1.28 | 30.72
CD951A | A) Heart | 775749195422 | CHINA | 9610.00.0000
[NAME]: Chalkboard Wall Plaque w/Jute Cord Hanger |  |  |  |  | 24 | 1.28 | 30.72
CD951B | B) Star | 775749195439 | CHINA | 9610.00.0000
[NAME]: Chalk-It-Up Tag Clothespins |  |  |  |  | 24 | 0.88 | 21.12
CD952A | A) Natural Bracket Border | 775749194937 | CHINA | 9610.00.0000
[NAME]: Chalk-It-Up Tag Clothespins |  |  |  |  | 24 | 0.88 | 21.12
CD952B | B) Word Balloons | 775749194944 | CHINA | 9610.00.0000
Spreadsheet: 714488d1611244124-can-not-use-array-formulas-need-to-pull-a-list-and-cross-check-on-multiple-criteria-example
Sheet: Main Street

Activity | Sub-object
1000 | 195
FY 2020 |  |  |  | Cross Check
Date | Vendor | Invoice | Amt | Posted Amount
2019-10-10 00:00:00 | Smith Farm | 4 | 800 |  | Manually entered
2019-10-10 00:00:00 | Tractor Supply Co | 4 | 800
2019-10-10 00:00:00 | Tractor Supply Co | 5 | 600
2019-10-10 00:00:00 | Tractor Supply Co | 10 | 700
2019-10-10 00:00:00 | Tractor Supply Co | 12 | 800
2019-10-10 00:00:00 | Tractor Supply Co | 13 | 50
 |  |  |  |  | Continue to pull data so it is not manually entered
Spreadsheet: 0e12348e-4136-4c2d-9cb5-a4c0f1141bca
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
FGAKM | Test | FGAKM | [NAME] (FGA) Gene, Known Mutation | [NAME], Known Mutation | Polymerase Chain Reaction (PCR) Followed by DNA Sequence Analysis (PCR is utilized pursuant to a license agreement with Roche Molecular Systems, Inc.) | VACUTAINER: VAC |  |  | 3 | mL | This test can only be performed if a mutation has previously been identified in a family member of this individual.   [NAME] must arrive within 96 hours of draw.   [NAME] blood Container/Tube: Preferred: Lavender top (EDTA) or yellow top (ACD) Acceptable: Any anticoagulant [NAME]: 3 mL Collection Instructions: 1. Invert several times to mix blood. 2. Send specimen in original tube. Forms: 1. Molecular Genetics-Congenital Inherited Diseases Patient Information Sheet (Supply T521) in Special Instructions 2. New York Clients-Informed consent is required. Please document on the request form or electronic order that a copy is on file. An Informed Consent for Genetic Testing (Supply T576) is available in Special Instructions. | 0.5 mL | Hemolysis	NA Thawing	Warm OK; Cold OK Lipemia	NA Icterus	NA Other	Plasma or serum | An interpretive report will be provided. | Friday, 10 am | 10 days | 16 days | 1 | 81479 |  |  |  |  | Rochester
FGAKM | [NAME] | VARIES | Varies |  |  |  | Ambient
FGAKM | Result | 33481 | [NAME] | [NAME] | Alphanumeric
FGAKM | Result | 33482 | [NAME] | [NAME] | Alphanumeric
FGAKM | Result | 33483 | Source | Source | Alphanumeric
FGAKM | Result | 33484 | Order Date | Order Date | Alphanumeric
FGAKM | Result | 33485 | Reason For Referral | Reason For Referral | Alphanumeric
FGAKM | Result | 33486 | Method | Method | Alphanumeric
FGAKM | Result | 33487 | Result | Result | Alphanumeric
FGAKM | Result | 33488 | Interpretation | Interpretation | Alphanumeric
FGAKM | Result | 33489 | Amendment | Amendment | Alphanumeric
FGAKM | Result | 33490 | Reviewed By | Reviewed By | Alphanumeric
FGAKM | Result | 33491 | Release Date | Release Date | Alphanumeric
Spreadsheet: 272968d1382557836-track-employees-which-cross-shifts-and-counted-one-time-each-shift-ef513_2t29
Sheet: Sheet1

 | WORKS IF TIMES ARE BEFORE MIDNIGHT |  |  |  |  |  |  | DON'T WORK IF TIME SPANS MIDNIGHT
 | 07:00:00 | 11:00:00 |  |  |  |  |  | 07:00:00 | 11:00:00
 | 11:00:00 | 16:00:00 |  |  |  |  |  | 11:00:00 | 16:00:00
 | 16:00:00 | 21:00:00 |  |  |  |  |  | 16:00:00 | 21:00:00
 | 07:00:00 | 21:00:00 |  |  |  |  |  | 07:00:00 | 21:00:00
 | 07:00:00 | 23:59:00 |  |  |  |  |  | 07:00:00 | 01:00:00
 |  | 07:00:00 | 11:00:00 |  |  |  |  |  | 07:00:00 | 11:00:00
 |  | 11:00:00 | 16:00:00 |  |  |  |  |  | 11:00:00 | 16:00:00
 |  | 16:00:00 | 21:00:00 |  |  |  |  |  | 16:00:00 | 21:00:00
 |  | 23:00:00 | 23:59:00 |  |  |  |  |  | 23:00:00 | 01:00:00
Spreadsheet: 152300d1335334575-query-a-separate-sheet-for-a-top-10-performance-dummy-performance
Sheet: Data_Table

Performer Data
2012-01-01 00:00:00
Agency Rating
123
3245
789
No Agency
 |  |  |  |  | All data is rolling 12 months unless noted
 |  |  |  |  | Top 10 Criteria
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  | You can Hide them
 |  |  |  | Score | Highest 1 | Highest 2 | Highest 3 | Highest 4 | Highest 5 | Highest 6 | Highest 7 | Highest 8 | Highest 9 | Highest 10 | F | G | H | I | J | K | L | M | N | O
 | Agent Name | Agent # | Agency Name |  | [Best Pipeline Volume] | [Best New Sales Volume] | [Best Conversation Ratio] | [Best Long Term  Retention Rate] | [Best Short Term Retention Rate] | [Best Growth in Membership] | [Largest Block] | [Best Up Seller] | [Best Long Term Performance] | [Best Short Term Performance] | Rank each column |  |  |  |  |  |  |  |  |  | Count how many 1 |  |  |  |  |  |  |  |  |  | Total | Rank
 | Human | E106429 | 789 |  | 360 | 300 |  | 0.78 | 0.95 |  | 25000 | 225 | 2000 | 675
 | Human | E163148 | 123 |  | 390 | 349 |  | 0.77 | 0.86 |  | 40000 | 199.5 | 1800 | 772
 | Human | D041211 | 123 |  | 300 | 240 |  | 0.56 | 0.75 |  | 36000 | 216.25 | 2200 | 450
 | Human | [NAME] | 123 |  | 280 | 221 |  | 0.42 | 0.77 |  | 2000 | 270.35 | 1750 | 312
 | Human | E162936 | 123 |  | 450 | 350 |  | 0.76 | 0.82 |  | 16000 | 235.25 | 1125 | 495
 | Human | E168993 | 123 |  | 300 | 229 |  | 0.72 | 0.81 |  | 21000 | 212.1 | 1685 | 97
 | Human | P204543 | 789 |  | 312 | 261 |  | 0.83 | 0.92 |  | 32000 | 262.12 | 1298 | 900
 | Human | P148806 | 3245 |  | 346 | 290 |  |  | 0.88 |  | 45000 | 201.52 | 1877 | 111
 | Human | A167670 | 3245 |  | 402 | 322 |  | 0.79 | 0.9 |  | 26000 | 239.5 | 1645 | 152
 | Human | A050588 | 3245 |  | 356 | 242 |  |  | 0.74 |  | 45000 | 245.49 | 1485 | 777
 | Human | A293807 | 3245
 | Human | E064388 | 3245
 | Human | [NAME] | 3245
 | Human | E012675 | 3245
 | Human | P179633 | 3245
 | Human | D059724 | 3245
 | Human | P224108 | 3245
 | Human | P060832 | 3245
 | Human | D041211 | 3245
 | Human | P139920 | 3245
 | Human | A047447 | 3245
 | Human | P236125 | 3245
 | Human | E106429 | 3245
 | Human | E163148 | 3245
 | Human | D041211 | 3245
 | Human | P003873 | 3245
 | Human | E091806 | 3245
 | Human | P204543 | 3245
 | Human | P148806 | 3245
 | Human | A167670 | 3245
 | Human | A050588 | 3245
 | Human | A293807 | 3245
 | Human | E064388 | 3245
 | Human | [NAME] | 3245
 | Human | E012675 | 3245
 | Human | P179633 | 3245
 | Human | D059724 | 789
 | Human | P224108 | 789
 | Human | P060832 | 789
 | Human | D041211 | 789
 | Human | P139920 | 789
 | Human | A293807 | No Agency
 | Human | E064388 | No Agency
 | Human | [NAME] | 789
 | Human
 | Human
 | Human
 | Human
 | Human
 | Human
Spreadsheet: 117688d1312966432-ytd-using-match-and-offset-example-ytd
Sheet: DETAIL

 | Mar
 |  | Description | Jan | Feb | Mar | Apr | Jun | Jul | Aug | Sep | Oct | Nov | Dec | FY | YTD
 |  | 1 - TOTAL Project Invoices Issued | 1654 | 5987 | 2356 | 6946 | 8654 | 312 | 6464 | 98654 | 321 | 9633 | 1002
 |  | 2 - TOTAL Project Direct Costs | 654 | 654 | 1654 | 984365 | 35 | 9874 | 6543 | 3516 | 8946 | 3654 | 3514
 |  | 2B - Currency exchange differential | 654 | -654 | 6549 | -9879 | -654 | -32 | 6546 | 23 | 4948 | 655 | -988
 |  | 3 - TOTAL Staff Costs | 15000 | 15000 | 15000 | 15000 | 15000 | 15000 | 15000 | 15000 | 15000 | 15000 | 15000
 |  | 4 - TOTAL Travel/Lodging/Subsistance | 10000 | 10000 | 10000 | 10000 | 10000 | 10000 | 10000 | 10000 | 10000 | 10000 | 10000
 |  | 5 - TOTAL Rent and Insurance | 150 | 150 | 150 | 150 | 150 | 150 | 150 | 150 | 150 | 150 | 150
 |  | 6 - TOTAL Administrative | 20 | 20 | 20 | 20 | 20 | 20 | 20 | 20 | 20 | 20 | 20
 |  | 7 - TOTAL Fixed Assets | 2500 | 2500 | 2500 | 2500 | 2500 | 2500 | 2500 | 2500 | 2500 | 2500 | 2500
 |  | 8 - TOTAL Stock for Resale | 560 | 560 | 560 | 560 | 560 | 560 | 560 | 560 | 560 | 560 | 560
 |  | 9 - TOTAL Debtors | 555 | 555 | 555 | 555 | 555 | 555 | 555 | 555 | 555 | 555 | 555
 |  | 10 - TOTAL Deposits / Prepayments | 654 | 654 | 654 | 654 | 654 | 654 | 654 | 654 | 654 | 654 | 654
 |  | 11 - TOTAL Cash at Bank | 9879 | 9879 | 9879 | 9879 | 9879 | 9879 | 9879 | 9879 | 9879 | 9879 | 9879
 |  | 12 - TOTAL Creditors and Accruals | 89465 | 89465 | 89465 | 89465 | 89465 | 89465 | 89465 | 89465 | 89465 | 89465 | 89465
 |  |  |  | - Need YTD (sum) based on value selected in cell B2
Spreadsheet: 715568d1611767657-extract-actual-data-from-pivot-table-but-have-cell-prepopulated-with-projections-miscitems-formula-test-file
Sheet: Summary Table

 | 11 | 13 | 21 | 23 | 24 | 25 | 26 | 31 | Totals | Running Totals
2020-10-31 00:00:00
2020-11-30 00:00:00
2020-12-31 00:00:00
2021-01-31 00:00:00
2021-02-28 00:00:00
2021-03-31 00:00:00
2021-04-30 00:00:00
2021-05-31 00:00:00
2021-06-30 00:00:00
2021-07-31 00:00:00
2021-08-31 00:00:00
2021-09-30 00:00:00
Total Actuals
Remaining FY Projections
EOY Projections (Total Act+Projections)
Spreadsheet: 622893d1556977796-create-one-master-list-from-lists-on-multiple-worksheets-excel-forum-example-create-one-list-from-multiple-sheets-3
Sheet: Extract (AssetStatus-XHire)

Status | S/G | Item Description | Object No. | Serial No. | Type | Own Depot | Curr Depot | Supplier | P/O No
Available | 999998 | List 2 Description 1 | 9971099 |  | XHire | SIN | SIN
Available | 999998 | List 2 Description 2 | 9971101 |  | XHire | SIN | SIN
Available | 999998 | List 2 Description 3 | 9971429 |  | XHire | SIN | SIN
On [NAME] | 999998 | List 2 Description 4 | 9962347 |  | XHire | HOU | HOU | US20765 | [PHONE]
In Service | 999998 | List 2 Description 5 | 9962032 |  | XHire | HOU | HOU | US20710 | [PHONE]
Available | 999998 | List 2 Description 6 | 9962241 |  | XHire | HOU | HOU | US20697 | [PHONE]