tianzl66/Sheetpedia huggingface dataset:
Spreadsheet: 846624d1697765177-help-to-control-worked-time-and-holydays-time-dutratp-ex
Sheet: Folha1

Identificação do Trabalhador | Start Date | End Date | Total Months | First Time Holydays | Second time Holydays | Checkbox
Name | 2023-01-01 00:00:00 | 2023-12-31 00:00:00 | 12 | 01-07-2023 Until 31-07-2023 | No Holydays | True when 12 months past
Name | 2023-01-01 00:00:00 | 2024-03-01 00:00:00 | 15 | 01-07-2023 Until 31-07-2024 | 01-01-2024 Until 31-01-2024 | True when 15 months past
Spreadsheet: 112572d1308674563-how-to-count-for-each-category-count-formula
Sheet: Sheet1

 |  |  |  |  | Results
Keyword | Category | Number |  |  |  | Numb 1-5 | Numb 6-10
KW1 | People | 1 |  |  | People
KW2 | People | 7 |  |  | Places
KW3 | places | 4 |  |  | Things
KW4 | things | 4
KW5 | places | 9
KW6 | People | 8
KW7 | places | 2
KW8 | things | 1
Spreadsheet: 222640d1363896000-copying-down-into-blank-cells-tried-special-goto-and-blanks-not-working-trialfile-1-
Sheet: Raw Data

0312 |  | [PHONE] | FF | GOOD | 270 | 365 | 32.7
 |  |  |  |  | 270 | 365 | 32.7
 |  |  |  |  | 270 | 365 | 32.7
 |  |  |  |  | 270 | 365 | 32.7
 |  |  |  |  | 270 | 365 | 32.7
 |  |  |  |  | 270 | 365 | 32.7
 |  |  |  |  | 270 | 365 | 32.7
 |  |  |  |  | 270 | 365 | 32.7
 |  |  |  |  | 270 | 365 | 32.7
1460 |  | [PHONE] |  | GOOD | 270 | 365 | 32.59
 |  |  |  |  | 270 | 365 | 32.59
 |  |  |  |  | 270 | 365 | 32.59
 |  |  |  |  | 270 | 365 | 32.59
 |  |  |  |  | 270 | 365 | 32.59
 |  |  |  |  | 270 | 365 | 32.59
 |  |  |  |  | 270 | 365 | 32.59
 |  |  |  |  | 270 | 365 | 32.59
 |  |  |  |  | 270 | 365 | 32.59
 |  |  |  |  | 270 | 365 | 32.59
 |  |  |  |  | 270 | 365 | 32.59
 |  |  |  |  | 270 | 365 | 32.59
0312 |  | [PHONE] | GG | DAMG | 270 | 365 | 34.65
 |  |  |  |  | 270 | 365 | 34.65
 |  |  |  | GOOD | 270 | 365 | 34.65
 |  |  |  |  | 270 | 365 | 34.65
 |  |  |  |  | 270 | 365 | 34.65
 |  |  |  |  | 270 | 365 | 34.65
 |  |  |  |  | 270 | 365 | 34.65
 |  |  |  |  | 270 | 365 | 34.65
1460 |  | [PHONE] |  | DAMG | 270 | 365 | 34.65
 |  |  |  |  | 270 | 365 | 34.65
 |  |  |  |  | 270 | 365 | 34.65
 |  |  |  | GOOD | 270 | 365 | 34.65
 |  |  |  |  | 270 | 365 | 34.65
 |  |  |  |  | 270 | 365 | 34.65
 |  |  |  |  | 270 | 365 | 34.65
 |  |  |  |  | 270 | 365 | 34.65
 |  |  |  |  | 270 | 365 | 34.65
 |  |  |  |  | 270 | 365 | 34.65
 |  |  |  |  | 270 | 365 | 34.65
0312 |  | [PHONE] | EE | GOOD | 270 | 365 | 38.63
 |  |  |  |  | 270 | 365 | 38.63
 |  |  |  |  | 270 | 365 | 38.63
 |  |  |  |  | 270 | 365 | 38.63
1460 |  | [PHONE] | OO | GOOD | 270 | 365 | 38.63
 |  |  |  |  | 270 | 365 | 38.63
 |  |  |  |  | 270 | 365 | 38.63
 |  |  |  |  | 270 | 365 | 38.63
 |  |  |  |  | 270 | 365 | 38.63
 |  |  |  |  | 270 | 365 | 38.63
 |  |  |  |  | 270 | 365 | 38.63
 |  |  |  |  | 270 | 365 | 38.63
 |  |  |  |  | 270 | 365 | 38.63
 |  |  |  |  | 270 | 365 | 38.63
 |  |  |  |  | 270 | 365 | 38.63
 |  |  |  |  | 270 | 365 | 38.63
 |  |  |  |  | 270 | 365 | 38.63
 |  |  |  |  | 270 | 365 | 38.63
 |  |  |  |  | 270 | 365 | 38.63
 |  |  |  | [NAME] | 270 | 365 | 38.63
0312 |  | [PHONE] | NN | GOOD | 270 | 365 | 30.16
 |  |  |  |  | 270 | 365 | 30.16
 |  |  |  |  | 270 | 365 | 30.16
Spreadsheet: 223909d1364376625-2-cell-values-to-be-linked-together-test
Sheet: Sheet1

Name | Class
[NAME] | IV
[NAME] | V
[NAME] | V
[NAME] | XI
Rock | IX
Zane | VII
Now what I want here is as follows
Jim/IV
[NAME]/V
[NAME]/V
Andy/XI
Rock/IX
Zane/VII
Spreadsheet: 123175d1317390362-how-do-i-copy-from-a-form-and-put-into-correct-columns-excel-columns
Sheet: When I copy and Paste

Quotation ID | XXXX
Quotation Type | Moving Few Items
Name | Rod
Phone 1 | XXXX
Phone 2
[NAME] | XXXX
Contact me
Move From
Street
Suburb | Camberwell
State | Victoria
City / Town | Camberwell
Postal Code
Resident Type
Number of bedrooms
Packing Requirement
Move To
Street
Suburb | Lismore
State | New South Wales
City / Town | Lismore
Postal Code
Anticipated moving date | Wednesday, October 05, 2011
More Details
MoreDetails | 1 x steel four wheel drive bullbar, approx 45kg
Spreadsheet: 213057d1360331490-delete-value-of-dependant-list-automatically-when-mother-list-gets-manually-deleted-test-4
Sheet: Dependancies

Account | ccount_key | Account_No |  |  | Targets | KPIs
Consumer Advertising | AA | 332030
Consumer Public Relations | BB | 332000
Consumer Events | CC | 332035
Sponsor Agreement | DD | 333500
Permanent Displays | EE | 331515
Purchase of POS Material | FF | 332525
Consumer Promotions | GG | 332015
Direkt Marketing | HH | 332040
Trade Advertising | II | 332000
Co-op Advertising | JJ | 330585
Trade Fairs & Events | KK | 333005
Trade Promotions / Contests | LL | 332024
Trade Public Relations | MM | 330530
Purchase of Give-aways | NN | 332515
Printed Paper / Brochures | OO | 331500
Direct Marketing Production | PP | 331535
Reproduction | QQ | 331505
Photography | RR | 331510
Film/Video Production | SS | 332005
Research | TT | 331540
Translations | UU | 331545
Charity Contribution | VV | 333505
Purchase of showroom / trade material | WW | 333000
Agency Work | XX | 331000
Activity | Account_key | Account_No
OOH
Print Advertising - Newspaper / Magazine
Advetorial - Media Cost & Production
TVC
Radio
Magazine - Insert / Showcase
PR & Media Joint Promotion
Press Event
Press Samples
Press Material
Press Trip for consumer Media
PR Agency Fee
WIS
Special Project
Golf Event
Walkathon
Retail Event
Roadshow / Static Display
New Shop Opening
In Store Event / Activations
Local Sponsorship
Permanent Display - Retail & Wholesales Support
POS Material - Retail & Wholesales Support
Retail: Consumer Promotions (Except GWP)
Wholesale: Consumer Promotions (Except GWP)
Global Consumer Promotions
Direct Marketing - Database & Mailing Cost
Direct Marketing - ECCO TV Control System
Print Advertising - Trade Paper / Trade Magazine
Account 1 Plan
Account 2 Plan
Account 3 Plan
Trade Fairs / Exhibitions
Internal Conference / Meetings
Trade event related costs
SS B2B Program
AW B2B Program
Wholesale
Trade Paper
Press Trip for Magazines
Purchase of Giveaways - Retail & Wholesale
Printing Cost
Direct Marketing Production | PP
Various Marketing Materials
Pre-press Materials
Photography Cost
Film / Video Cost
Additional Research not paid for by HQ
Local Translation Cost
Charity Contribution | VV
POS materials for trade fairs, showrooms, internal conferences etc.
Agency Fee
Metrics
Spreadsheet: vkaminski__40917__MERCHANT VAR MONTE CARLO
Sheet: DATA

 |  |  | CHOLESKY
 | DATE
 |  |  |  | INDEP | CORREL |  |  |  | VALUE DATE
 |  |  | UNIVARIATE | NORMAL | NORMAL | GBM | GBM |  | UNDERLYING PRICE
 | AMOUNTS | ST DEV | RANDOM | RANDOM | RANDOM | SIM | ASSET |  | YEARLY VOL
 |  |  |  |  |  |  |  |  | INTEREST RATE | 0.06 | 0.06
 |  |  |  |  |  |  |  |  | STRIKE | 92.678 | 34.825
 |  |  |  |  |  |  |  |  | EXPIRATION | 2003-06-29 00:00:00 | 2003-06-29 00:00:00
 |  |  |  |  |  |  |  |  | INT CALC D1
 |  |  |  |  |  |  |  |  | INT CALC D2
 |  |  |  |  |  |  |  |  | INT CALC TIME TO EXP
 |  |  |  |  |  |  |  |  | SHARES | 5523900 | 5523900
 |  |  |  |  |  |  |  |  |  | CALL | PUT
HC PRICE
 |  |  |  |  |  | SUM
TRUE MODEL | TRUE MODEL |  |  |  |  | STARTING POINT | 1827050151.395195
 | NUMBER OF SIMULATIONS | 5000 |  |  |  | ONE DAY P&L
 | SHOW SIMULATIONS GRAPHICALLY
 | ("YES" OR "NO" -- "NO" IS FASTER) | NO
Spreadsheet: 121684d1316259417-transferring-and-transposing-data-copy-of-2011test
Sheet: 1-Weekly Games

Wk |  | Home Team |  | Opponent | Line | pf | pa | Home Team  ATS | Home Team  SU
1 | 2011-09-03 00:00:00 | TEAM A | vs | TEAM D | 27.5 | 19 | 54 | L | L |  | 40789TEAM A
1 | 2011-09-03 00:00:00 | TEAM B | vs | TEAM E | -6 | 36 | 29 | W | W |  | 40789TEAM B
1 | 2011-09-03 00:00:00 | TEAM C | vs | TEAM F | -35.5 | 51 | 17 | L | W |  | 40789TEAM C
2 | 2011-09-08 00:00:00 | TEAM B | vs | TEAM C | -13.5 | 37 | 14 | W | W |  | 40794TEAM B
2 | 2011-09-08 00:00:00 | TEAM D | vs | TEAM F | -4 | 17 | 24 | L | L |  | 40794TEAM D
2 | 2011-09-08 00:00:00 | TEAM E | vs | TEAM A | 11 | 23 | 28 | W | L |  | 40794TEAM E
Spreadsheet: 723194d1615556747-search-or-index-formula-needed-testalles
Sheet: Blad1

project | wie NL | wie D | inkoop NL | inkoop D | verkoop NL | verkoop D
 |  |  |  |  |  |  |  | uren inkoop |  |  | km inkoop
 |  |  |  |  |  |  |  | [NAME] |  |  | km verkoop
 |  |  |  |  |  |  |  | [NAME] |  |  | [NAME]
5129 | ik | nl | 4 | 256 | 4.5 | 271
5129 | ernst | nl | 4.5 | 261 | 5 | 270 |  | Inkoop NL |  |  | Inkoop D
5129 | willem | nl | 4 | 264 | 4.5 | 269 |  | [NAME] |  |  | Verkoop D
5130 | jan | ics | 3 | 290 | 3.5 | 293 |  | [NAME] |  |  | Verschil D
5130 | klaas | ics | 3.5 | 289 | 4 | 292
5131 | willem | nl | 7 | 600 | 7.5 | 620 |  |  | Totaal inkoop
 |  |  |  |  |  |  |  |  | Totaal verkoop
 |  |  |  |  |  |  |  |  | totaal [NAME]
 |  |  |  |  |  |  |  | search code | count cell B and C | inkoop NL | inkoop D | verkoop NL | verkoop D
 |  |  |  |  |  |  |  | 5129
 |  |  |  |  |  |  |  | number  of  amount (fill in) that i need. In search 5129 that are 6, i can change this number to count the cells
 |  |  | If i put the search code 5129 in cel I15, i would like to show the results from D to G belongs to 5129. somewhere from k15 to m15 or so
 |  |  | the other one i am searchiing for. Is if i put a searchcode in I16 i need to show how much cells are filled in B and C belonging to the searchcode
Spreadsheet: 771728d1646819476-select-conditional-data-from-a-table-preserve-line-breaks-when-using-filter-function-rev-000
Sheet: Sheet1

 |  |  | Original Table |  |  |  |  | Using filter command  =FILTER(Table1[[Product]:[Column4]];Table1[Product]<>"";"Error")  Note issue in yellow cells
 |  |  | Product | TextWithLineBreaks | Column3 | Column4
 |  |  | Apple | Green Healthy Fruit | thb | sf |  |  | Green Healthy Fruit | thb | sf
 |  |  | Orange | Spain Sweet Bright color | gfggf | jhg |  | Orange | Spain Sweet Bright color | gfggf | jhg
 |  |  | [NAME] | thnjmuj | rgv | htf |  | [NAME] | thnjmuj | rgv | htf
 |  |  |  | rr | rgb | ku7 |  | Bread | xd3e | [NAME] | rgbgrb
 |  |  | Bread | xd3e | [NAME] | rgbgrb
Spreadsheet: 710686d1609186269-highlighting-time-range-of-the-day-or-room-occupancy
Sheet: Sheet1

Time | OR 1 | OR 2 | OR 3 | OR 4 | OR 5 | OR 6 | OR 7 | OR 8 |  | Date | OR List | Patient In | Patient Out
00:00:00 |  |  |  |  |  |  |  |  |  | 2020-12-20 00:00:00 | 1 | 08:32:00 | 10:05:00
 |  |  |  |  |  |  |  |  |  | 2020-12-20 00:00:00 | 1 | 10:21:00 | 13:00:00
 |  |  |  |  |  |  |  |  |  | 2020-12-20 00:00:00 | 1 | 13:11:00 | 19:10:00
08:00:00 |  |  |  |  |  |  |  |  |  | 2020-12-20 00:00:00 | 2 | 13:17:00 | 14:20:00
 |  |  |  |  |  |  |  |  |  | 2020-12-20 00:00:00 | 2 | 09:17:00 | 09:52:00
 |  |  |  |  |  |  |  |  |  | 2020-12-20 00:00:00 | 2 | 10:36:00 | 11:59:00
 |  |  |  |  |  |  |  |  |  | 2020-12-20 00:00:00 | 2 | 12:07:00 | 12:45:00
 |  |  |  |  |  |  |  |  |  | 2020-12-20 00:00:00 | 3 | 03:45:00 | 04:26:00
 |  |  |  |  |  |  |  |  |  | 2020-12-20 00:00:00 | 3 | 08:15:00 | 10:45:00
 |  |  |  |  |  |  |  |  |  | 2020-12-20 00:00:00 | 3 | 11:00:00 | 11:32:00
 |  |  |  |  |  |  |  |  |  | 2020-12-20 00:00:00 | 3 | 11:44:00 | 12:12:00
 |  |  |  |  |  |  |  |  |  | 2020-12-20 00:00:00 | 3 | 12:22:00 | 13:50:00
 |  |  |  |  |  |  |  |  |  | 2020-12-20 00:00:00 | 3 | 14:22:00 | 17:50:00
 |  |  |  |  |  |  |  |  |  | 2020-12-20 00:00:00 | 4 | 08:30:00 | 11:44:00
17:00:00 |  |  |  |  |  |  |  |  |  | 2020-12-20 00:00:00 | 4 | 11:57:00 | 13:42:00
 |  |  |  |  |  |  |  |  |  | 2020-12-20 00:00:00 | 4 | 15:13:00 | 16:10:00
 |  |  |  |  |  |  |  |  |  | 2020-12-20 00:00:00 | 5 | 17:31:00 | 18:53:00
23:59:00 |  |  |  |  |  |  |  |  |  | 2020-12-20 00:00:00 | 5 | 08:57:00 | 11:40:00
 |  |  |  |  |  |  |  |  |  | 2020-12-20 00:00:00 | 5 | 11:52:00 | 14:06:00
 |  |  |  |  |  |  |  |  |  | 2020-12-20 00:00:00 | 5 | 14:34:00 | 16:06:00
 |  |  |  |  |  |  |  |  |  | 2020-12-20 00:00:00 | 5 | 18:15:00 | 21:04:00
 |  |  |  |  |  |  |  |  |  | 2020-12-20 00:00:00 | 6 | 08:12:00 | 09:19:00
 |  |  |  |  |  |  |  |  |  | 2020-12-20 00:00:00 | 6 | 09:41:00 | 11:20:00
 |  |  |  |  |  |  |  |  |  | 2020-12-20 00:00:00 | 6 | 11:55:00 | 13:04:00
 |  |  |  |  |  |  |  |  |  | 2020-12-20 00:00:00 | 6 | 13:48:00 | 20:08:00
Spreadsheet: 490380d1479839847-smart-lookup-lookup-example
Sheet: Sheet1

 |  |  |  | Required Output
 | Document | Status | Revision | Previous Status
 | Drawing 1 | F | 4 | D
 | Drawing 1 | E | 4 | D
 | Drawing 1 | D | 3 | B
 | Drawing 1 | C | 3 | B
 | Drawing 1 | B | 2 | A
 | Drawing 1 | A | 1
 | Drawing 2 | D | 4 | C
 | Drawing 2 | C | 3 | B
 | Drawing 2 | B | 2 | A
 | Drawing 2 | A | 1
 | Drawing 3 | F | 4 | D
 | Drawing 3 | E | 4 | D
 | Drawing 3 | D | 3 | C
 | Drawing 3 | C | 2 | A
 | Drawing 3 | B | 2 | A
 | Drawing 3 | A | 1
Spreadsheet: 743372d1628445759-list-values-based-on-other-cells-list-valuesrep
Sheet: Sheet1

1 | 2 | 3 | 4 | 5 | 6 | 7 | 8 | 9 | 10
1 | 7 | 9 | 34 | 38 | 26 | 5 | 36 | 39 | 28
55 | 56 | 57 | 3 | 11 | 22 | 44 | 55 | 38 | 15
18 | 18 | 26 | 5 | 1 | 7 | 5 | 10 | 13 | 38
 |  |  |  |  |  |  |  |  |  |  |  | [NAME] if a2-J2 is between 25 and 40
 |  |  |  |  |  |  |  |  |  | IF(ISNUMBER(VLOOKUP(A2,{1;7;9},1,0)),A1,"")
 |  |  |  |  |  |  |  |  |  | IF(ISNUMBER(VLOOKUP(A2,{1;7;9},1,0)*VLOOKUP(A3,{3;11;22},1,0)*VLOOKUP(A4,{5;10;13},1,0)),A1,"")
Spreadsheet: 844527d1696314880-formula-trying-to-lookup-a-value-in-a-matrix-pbrebate
Sheet: Sheet1

 |  | Business Line |  |  |  |  |  |  |  | *color coded manually to show
 | customer | 1 | 2 | 3 |  |  | customer | [NAME] | rebate | Correct answer
 | Ford | 0.02 | 0.03 | 0.04 |  |  | Ford | 1
 | Ford | 0.34 | 0.05 | 0.64 |  |  | Ford | 2
 | Chevy | 0.03 | 0.46 | 0.07 |  |  | Chevy | 1
 | Chevy | 0.06 | 0.67 | 0.04 |  |  | Chevy | 3
 | Toyota | 0.07 | 0.06 | 0.03 |  |  | Toyota | 1
 | Toyota | 0.08 | 0.09 | 0 |  |  | Toyota | 2
Spreadsheet: 100770d1299015731-increase-range-by-one-using-a-dynamic-range-sum
Sheet: Sheet1

 |  |  | Major |  |  |  |  | Major
 |  | 0.35 | Sub |  |  |  | 0.35 | Sub
 |  | 0.48 | Sub |  |  |  | 0.48 | Sub
 |  | 0.72 | Sub |  |  |  | 0.72 | Sub
 |  | 0.72 | Sub |  |  |  | 0.72 | Sub
 |  | 0.39 | Sub |  |  |  | 0.39 | Sub
 |  |  | Major |  |  |  |  | Major
 |  | 0.8479033036761159 | Sub |  |  |  | 0.8479033036761159 | Sub
 |  | 0.3763652419378677 | Sub |  |  |  | 0.3763652419378677 | Sub
 |  | 0.6921659621845844 | Sub |  |  |  | 0.6921659621845844 | Sub
 |  | 0.4088105214152701 | Sub |  |  |  | 0.4088105214152701 | Sub
 |  | 0.2855184594011411 | Sub |  |  |  | 0.2855184594011411 | Sub
Spreadsheet: 54951d1255001891-copying-a-formula-between-tabs-in-a-worksheet-2009_accom_booking_spreadsheet-d
Sheet: FebSum

feb10 | 1
Room1 | Name | Nights | [NAME] | Departure | [NAME] | Contact Details | Rate | Total
Booking1 |  |  |  |  |  |  |  | 0
Booking2 |  |  |  |  |  |  |  | 0
Booking3 |  |  |  |  |  |  |  | 0
Room2
Booking1 |  |  |  |  |  |  |  | 0
Booking2 |  |  |  |  |  |  |  | 0
Booking3 |  |  |  |  |  |  |  | 0
Room3
Booking1 |  |  |  |  |  |  |  | 0
Booking2 |  |  |  |  |  |  |  | 0
Booking3 |  |  |  |  |  |  |  | 0
 |  |  |  |  |  | Total for month |  | 0
2
Room1 | Name | Nights | [NAME] | Departure | [NAME] | Contact Details |  | Total
Booking1 |  |  |  |  |  |  |  | 0
Booking2 |  |  |  |  |  |  |  | 0
Booking3 |  |  |  |  |  |  |  | 0
Room2
Booking1 |  |  |  |  |  |  |  | 0
Booking2 |  |  |  |  |  |  |  | 0
Booking3 |  |  |  |  |  |  |  | 0
Room3
Booking1 |  |  |  |  |  |  |  | 0
Booking2 |  |  |  |  |  |  |  | 0
Booking3 |  |  |  |  |  |  |  | 0
 |  |  |  |  |  | Total for month |  | 0
3
Room1 | Name | Nights | [NAME] | Departure | [NAME] | Contact Details |  | Total
Booking1 |  |  |  |  |  |  |  | 0
Booking2 |  |  |  |  |  |  |  | 0
Booking3 |  |  |  |  |  |  |  | 0
Room2
Booking1 |  |  |  |  |  |  |  | 0
Booking2 |  |  |  |  |  |  |  | 0
Booking3 |  |  |  |  |  |  |  | 0
Room3
Booking1 |  |  |  |  |  |  |  | 0
Booking2 |  |  |  |  |  |  |  | 0
Booking3 |  |  |  |  |  |  |  | 0
 |  |  |  |  |  | Total for month |  | 0
4
Room1 | Name | Nights | [NAME] | Departure | [NAME] | Contact Details |  | Total
Booking1 |  |  |  |  |  |  |  | 0
Booking2 |  |  |  |  |  |  |  | 0
Booking3 |  |  |  |  |  |  |  | 0
Room2
Booking1 |  |  |  |  |  |  |  | 0
Booking2 |  |  |  |  |  |  |  | 0
Booking3 |  |  |  |  |  |  |  | 0
Room3
Booking1 |  |  |  |  |  |  |  | 0
Booking2 |  |  |  |  |  |  |  | 0
Booking3 |  |  |  |  |  |  |  | 0
 |  |  |  |  |  | Total for month |  | 0
5
Room1 | Name | Nights | [NAME] | Departure | [NAME] | Contact Details |  | Total
Booking1 |  |  |  |  |  |  |  | 0
Booking2 |  |  |  |  |  |  |  | 0
Booking3 |  |  |  |  |  |  |  | 0
Room2
Booking1 |  |  |  |  |  |  |  | 0
Booking2 |  |  |  |  |  |  |  | 0
Booking3 |  |  |  |  |  |  |  | 0
Room3
Booking1 |  |  |  |  |  |  |  | 0
Booking2 |  |  |  |  |  |  |  | 0
Booking3 |  |  |  |  |  |  |  | 0
 |  |  |  |  |  | Total for month |  | 0
6
Room1 | Name | Nights | [NAME] | Departure | [NAME] | Contact Details |  | Total
Booking1 |  |  |  |  |  |  |  | 0
Booking2 |  |  |  |  |  |  |  | 0
Booking3 |  |  |  |  |  |  |  | 0
Room2
Booking1 |  |  |  |  |  |  |  | 0
Booking2 |  |  |  |  |  |  |  | 0
Booking3 |  |  |  |  |  |  |  | 0
Room3
Booking1 |  |  |  |  |  |  |  | 0
Booking2 |  |  |  |  |  |  |  | 0
Booking3 |  |  |  |  |  |  |  | 0
 |  |  |  |  |  | Total for month |  | 0
Spreadsheet: 377801d1424174544-offset-example
Sheet: Sheet1

 | Am | PM
A
b |  |  |  | AM
c |  |  |  | PM
d
e
f
g
Total
A
b
c
d
e
f
g
Total
A
b
c
d
e
f
g
Total
A
b
c
d
e
f
g
Total
Spreadsheet: 96242d1295636345-vlookup-two-criteria-to-return-value-example
Sheet: Forecast

Customer | Sales Team | Product Description | Item # | Forecast |  | Actuals
Target | East | TV | 975 | 50 |  | [NAME]
Walmart | Midwest | Stereo | 12785 | 100 |  | [NAME]
Best Buy | Midwest | Computer | 12451 | 25 |  | [NAME]
Target | South | Vaccuum | 15432 | 18 |  | [NAME]
Walmart | West | Phone | 14231 | 35 |  | [NAME]
Spreadsheet: 42761d1241375155-conditional-formatting-sales-config
Sheet: Config Input Sheet

[NAME]: Access Control
Project: | Area Desrcription |  |  |  |  |  | Cabling and Accessories |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | Door Accessories |  |  |  |  |  |  |  |  |  |  |  | [NAME] |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | [NAME] |  |  |  |  |  |  |  | Visuals |  |  |  |  | Turnstile / Barriers & Accessories |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | CCTV Components |  |  |  |  |  |  |  |  |  |  |  |  |  |  | Software Components
Item # | Door ID |  |  | Commisioning & Testing | Removal Of existing | Site Management | Fibre Optic Cabling | Fibre Optic Splicing | Fibre Optic Pig Tails | UTP Cabling | Mylar -EC to DC - (2Pr) | Mylar- DC to Reader - 6Pr | Door wiring (m) - 2Pr | Door wiring (m) - 1Pr | Cabtye to power source | Steel Conduit | PVC Conduit | 25mm Trunking | Trenching distance (m) | Extra Item 1 | Extra Item 2 | Extra Item 3 | Green Break glass unit | [NAME] to Exit | Top Mount Maglock | Heavy Duty Door Closer | Small Materials | Key Overide | back pl. small | PSU 3A | Medium Enclosure | Extra Item 4 | Extra Item 5 | Extra Item 6 | Ecii - XEC-900 | Ecii IPS - IPS-970 | TRT- XRT911 | TT - XTT900 | O16 - XOT900 | IPS TRT - IPS920 | IPS TT - IPS910 | IPS MFT - IPS930 | MHA - XTT903 | MMA - XTT901 | MA -XTT902 | WMR - WMR900 | WPR - WPR900 | TA -XTA902 | TAR XTA905 | DRB XDB903 | OMA520 | OMA Bracket | MA500 | MA100 | [NAME] | Ident Dongle | Maci | MSO 300 | Polycomp Messaging | Polycomp Date & Time | Green & Red Light Sets | Strobe light | Buzzer - Sound Bomb | FH Double Turnstile | Roofing for Double | FH Single Turnstile | Roofing for Single | Other Types 1 | Other Types 2 | [NAME] | [NAME] | BIO [NAME] | [NAME] | Vehicle Barrier 4M | Vehicle Barrier 5M | Vehicle Barrier 6M | [NAME] | Truck loop | Beams (set) | Traffic lights | Stainless Steel Dual GN | Stainless Steel Gooseneck | CCTV 1 | CCTV 2 | CCTV 3 | CCTV 4 | CCTV 5 | CCTV 6 | CCTV 7 | CCTV 8 | CCTV 9 | CCTV 10 | CCTV 11 | CCTV 12 | CCTV 13 | CCTV 14 | CCTV 15 | ImproNet Engine INS942 | ImproNet Access INS944 | Engine Unlock SQL INM948 | Access Unlock SQL INM950 | ImproNet iTouch INI960 | [NAME] | [NAME] | [NAME] | TimeKeeper Initial | TimeKeeper Annual | AVM Intial Fee | AVM Annual Fee | Software 1 | Software 2 | Software 3 | Software 4
 | Area Desrcription
1 | Front Door | 66 | Door 2 Readers |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 1 |  | 1 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 1 |  |  | 2
2 | Back Door | 61 | Single T&A reader |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 1 |  | 1 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 1 |  |  | 2
3 | [NAME] | 2 | Single T&A reader |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 1 |  |  |  |  |  |  |  | 1 |  |  |  |  |  | 1
4
5
6
7
8
22
23
24
25
26
27
28
29
30
31
32
33
34
35
36
37
38
39
40
41
42
43
44
Sub Total
Total Required
Spreadsheet: 142464d1329849161-create-a-dynamic-drop-down-list-based-on-specific-criteria-active_employees
Sheet: Sheet2

 | Total Active Count
 | 5
Row # | Employees | Sorted List
3 | [NAME], [NAME] | [NAME]
4 | [NAME] | Gates, [NAME]
6 | Lincoln, [NAME] | [NAME], [NAME]
7 | Gates, [NAME] | Lincoln, [NAME]
8 | Santana, [NAME] | Santana, [NAME]
Spreadsheet: 9b690897-831f-4800-ad97-e9653adc5406
Sheet: Sheet1

PROG ID | ATHLETE ID | ATHLETE FIRST | ATHLETE LAST | NATIONALITY | START NUMBER | RUN | T1 | BIKE | T2 | RUN.1 | POSITION | TOTAL TIME
5175 | 30105 | [NAME] | Ocelka*** | HUN | 540 | 00:44:49 | 00:01:39 | 01:13:44 | 00:02:55 | 00:23:29 | 1 | 02:26:39
Spreadsheet: 600651d1543887870-sumproduct-occurrences-occurring-by-month-quarter-and-year-counting-colors2
Sheet: Sheet2 (2)

Date | Color |  | MONTHS | 2018 |  |  | 2019
2018-01-17 00:00:00 | red |  |  | Red | Green | Blue | Red | Green | Blue
2018-02-02 00:00:00 | red | 1 | Jan
2018-02-18 00:00:00 | blue | 2 | Feb
2018-03-06 00:00:00 | green | 3 | Mar
2018-03-22 00:00:00 | green | 4 | Apr
2018-04-07 00:00:00 | blue | 5 | May
2018-04-23 00:00:00 | blue | 6 | Jun
2018-05-09 00:00:00 | green | 7 | Jul
2018-05-25 00:00:00 | green | 8 | Aug
2018-05-10 00:00:00 | blue | 9 | Sep
2018-06-26 00:00:00 | blue | 10 | Oct
2018-07-12 00:00:00 | red | 11 | Nov
2018-07-28 00:00:00 | green | 12 | Dec
2018-08-13 00:00:00 | green
2018-08-14 00:00:00 | blue |  | QTR | Red | Green | Blue |  | YEARS | 2018 | 2019
2018-08-29 00:00:00 | blue | 1 | 1Q18 |  |  |  |  | Red
2018-09-30 00:00:00 | red | 2 | 2Q18 |  |  |  |  | Green
2018-10-16 00:00:00 | green | 3 | 3Q18 |  |  |  |  | Blue
2018-11-01 00:00:00 | red | 4 | 4Q18
2018-11-17 00:00:00 | blue | 1 | 1Q19
2018-12-03 00:00:00 | blue | 2 | 2Q19
2019-01-05 00:00:00 | red | 3 | 3Q19
2019-02-05 00:00:00 | blue | 4 | 4Q19
2019-03-07 00:00:00 | blue
Spreadsheet: michelle_lokay__26699__imball0112
Sheet: NGPL

 | 52862 |  | 6828
 | Measured | Scheduled | Measured | Scheduled | Imbalance
1 | 19565 | 19737
2 | 19701 | 19737
3 | 19719 | 19737
4 |  |  |  |  |  |  |  | Winkler/Eddy OBA |  |  |  |  |  |  | Gray  OBA
5
6 |  |  |  |  |  |  |  | Month | Measured | Scheduled | Imbalance | Index | Amount |  | Month | Measured | Scheduled | Imbalance | Index | Amount
7
8 |  |  |  |  |  |  |  | 2001-05-01 00:00:00 | 1103057 | 1120793 |  | 4.01 |  |  | 2001-05-01 00:00:00 | -202726 | -185000 |  | 4.01 |  |  | 2001-05-01 00:00:00 | 4.01
9 |  |  |  |  |  |  |  | 2001-06-01 00:00:00 |  | 1681871 |  | 3.51 |  |  | 2001-06-01 00:00:00 | -153623 | -88473 |  | 3.51 |  |  | 2001-06-01 00:00:00 | 3.51
10 |  |  |  |  |  |  |  | 2001-07-01 00:00:00 |  | 1270571 |  | 2.94 |  |  | 2001-08-01 00:00:00 | -34269 | -27046 |  | 2.85 |  |  | 2001-07-01 00:00:00 | 2.94
11 |  |  |  |  |  |  |  | 2001-08-01 00:00:00 |  | 1418897 |  | 2.85 |  |  | 2001-09-01 00:00:00 | -1191628 | -1210937 |  | 1.96 |  |  | 2001-08-01 00:00:00 | 2.85
12 |  |  |  |  |  |  |  | 2001-09-01 00:00:00 | 1109912 | 1111335 |  | 1.96 |  |  |  |  |  |  |  |  |  | 2001-09-01 00:00:00 | 1.96
13
14 |  |  |  |  |  |  |  | 5/01 - 9/01  balance |  |  |  |  |  |  | 5/01 - 9/01  balance
15
16 |  |  |  |  |  |  |  | Volume balance @ 4/30/01 |  |  | 19880 |  |  |  | Volume balance @ 4/30/01 |  |  | 37185
17
18
19
20
21
22
23
24
25
26
27
28
29
30
31
2001-11-30 00:00:00 |  |  |  |  | 159450
2001-12-03 00:00:00
CBS Dollars
 |  |  | 416892