tianzl66/Sheetpedia huggingface dataset:
Spreadsheet: 157beb5f-f070-4624-9f89-e45eb10bd91b
Sheet: Sheet1

Writing Lab Workshops, Spring 2014
Date and Time | Topic | Presenter
[NAME].,  Feb. 11th 1:00 | Organizing and Outlining Ideas | [NAME]
[NAME]., Feb. 18th 12:00 | Writing Thesis Statements | Norris
Wed., Feb. 26th 2:00 | Achieving Coherence | [NAME]
Thurs.,  March 6th 1:00 | Developing Ideas | [NAME]
[NAME]., March 11th 12:00 | Everything You Need to Know about Verbs | Norris
Thurs., March 20th 6:00 | Fixing Comma Splices and Fused Sentences | Ferrell
[NAME]., April 1st 12:00 | Using the IVC Databases | Dorantes
Wed., April 2nd 3:00 | Writing the Argument | Baukholt
Thurs., April 10th 12:00 | Using [NAME] and APA Styles Correctly | Cormier
Wed., April 16th 2:00 | Everything You Need to Know about Verbs | Norris
Thurs., May 8th 12:00 | Open Workshop - You Choose the Topic | Dorantes
Spreadsheet: 675236d1588205911-looking-up-cell-value-based-on-whether-its-the-current-month-or-next-month-sample
Sheet: Schedule

Bills Payment Schedule
Fixed Expenses | Due Date
Text1 | 1
Text2 | 1
Text3 | 3
Text4 | 5
Text5 | 13
Text6 | 14
Text7 | 15
Text8 | 17
Text9 | 17
Text10 | 26
Spreadsheet: 297113d1392290755-sum-duplicate-values-within-an-array-data
Sheet: Sheet1

Source |  |  |  | Result
ID | Name | Sale |  | ID | Sale
1 | [NAME] | 189 |  | 9 | 1661
1 | [NAME] | 782 |  | 1 | 971
4 | [NAME] | 563 |  | 7 | 564
5 | [NAME] | 76 |  | 4 | 563
9 | [NAME] | 899 |  | 8 | 241
8 | [NAME] | 241 |  | 5 | 76
7 | Nick | 564
9 | [NAME] | 762
Spreadsheet: 542695d1508014107-performance-rate-table
Sheet: Sheet1

Name | Goal | Actual | % achieved | % over
[NAME] | 450 | 350
[NAME] | 450 | 150
ted | 450 | 460
Spreadsheet: 36794d1234743693-functions-similar-to-vlookup-standing-sheet
Sheet: BOWLERS

ENTERING AVERAGE FOR THE WEEK 1 (for 1st week only)
 |  | AVE | HCP | GENDER
1 | A [NAME] | 163 | 29 | M
2 | B Black | 141 | 47 | M
3 | C Coles | 129 | 56 | M
4 | [NAME] | 171 | 23 | M
5 | E Ellen | 158 | 33 | F
6 | [NAME] | 174 | 20 | F
7 | G Green | 81 | 95 | F
8 | H Harris | 110 | 72 | F
Spreadsheet: 477560d1472372460-index-match-problem-oeldere-477257d1472208512-index-match-problem-match
Sheet: Sheet1

vaneu | item | value
 | Venue1 |  |  |  | Item |  | Sales
 | 1 | 0.12 |  |  | 1 |  |  |  | Som van value | Kolomlabels
 | 2 | 0.14 |  |  | 8 |  |  |  | Rijlabels | Venue1 | Venue2 | Eindtotaal
 | 3 | 0.13 |  |  | 7 |  |  |  | 1 | 0.12 | 0.16 | 0.28
 | 4 | 0.11 |  |  | 6 |  |  |  | 2 | 0.14 | 0.09 | 0.23
 | 5 | 0.1 |  |  |  |  |  |  | 3 | 0.13 | 0.1 | 0.23
 | 6 | 0.11 |  |  |  |  |  |  | 4 | 0.11 | 0.12 | 0.23
 | 7 | 0.12 |  |  |  |  |  |  | 5 | 0.1 | 0.15 | 0.25
 | 8 | 0.17 |  |  |  |  |  |  | 6 | 0.11 | 0.14 | 0.25
 | Venue2 |  |  |  |  |  |  |  | 7 | 0.12 | 0.12 | 0.24
 | 1 | 0.16 |  |  |  |  |  |  | 8 | 0.17 | 0.11 | 0.28
 | 2 | 0.09 |  |  |  |  |  |  | Eindtotaal | 1 | 0.99 | 1.99
 | 3 | 0.1
 | 4 | 0.12
 | 5 | 0.15
 | 6 | 0.14
 | 7 | 0.12
 | 8 | 0.11
Spreadsheet: 868596d1715279212-really-really-need-help-with-this-contra-entries-with-customer-names-testingonline-updated-for-update-final-chek-this-pleae-online
Sheet: Sheet1

Period | FY Year | FY Month Long Name | Invoice Date | Invoice Number | Invoice Separated | Customer Name | Sum of Revenue | ABS | Countif | Concat | Countif | customer same | Expected results
P1 | 2023 | October | 03/10/2022 | CSOL-1390946 | 1390951 | Sahara | 2985
P1 | 2023 | October | 03/10/2022 | CSOL-1390946 | 1391769 | Sahara | 2985
P1 | 2023 | October | 03/10/2022 | CSOL-1390947 | 1391807 | Flavour | 2985
P1 | 2023 | October | 03/10/2022 | CSOL-1390951 | 1393230 | [NAME] | 2985
P1 | 2023 | October | 03/10/2022 | CSOL-1390951 | 1394846 | Virgin | 2985
P1 | 2023 | October | 03/10/2022 | CSOL-1390951 | 1397943 | Plastic | 2985
P1 | 2023 | October | 03/10/2022 | CSOL-1390953 | 1397943 | Plastic | 2985 |  |  |  |  |  | this should be a 2
P1 | 2023 | October | 03/10/2022 | CSOL-1390954 | 1397943 | Plastic | -2985 |  |  |  |  |  | this should be a 2
P1 | 2023 | October | 03/10/2022 | CSOL-1390957 | 1390957 | ALi | 2077.69 |  |  |  |  |  | this 2 is correct as in column G it is the same customer
P1 | 2023 | October | 03/10/2022 | CSOL-1390960 | 1390957 | ALi | -2077.69 |  |  |  |  |  | this 2 is correct as in column G it is the same customer
P1 | 2023 | October | 03/10/2022 | CSOL-1390961 | 1390961 | Univar Speciality Consumables Limited | 1696.6 |  |  |  |  |  | this is correct as 1's show that there is no matching entry so there is no 1696.6
P1 | 2023 | October | 03/10/2022 | CSOL-1390962 | 1390962 | [NAME] | 565.64 |  |  |  |  |  | this is correct as 1's show that there is no matching entry
P1 | 2023 | October | 03/10/2022 | CSOL-1390963 | 1390963 | Tele | 678.19 |  |  |  |  |  | this is correct as 1's show that there is no matching entry
P1 | 2023 | October | 03/10/2022 | CSOL-1390963 | 1390963 | Tele | 3049.36 |  |  |  |  |  | this is correct as 1's show that there is no matching entry
P1 | 2023 | October | 03/10/2022 | CSOL-1390964 | 1390964 | Remington | 884.34 |  |  |  |  |  | this is correct as 1's show that there is no matching entry
 |  |  |  |  | 123456 | Plastic Reinforcement Fabrics Limited | 2985
 |  |  |  |  | 123456 | Plastic Reinforcement Fabrics Limited | -2985
 |  |  |  |  |  |  |  |  | but lets say the 1's in column L currently as above - if I put more data from row 17 - and if the lines I add  numbers match - it will say 2 in column L as its found a matching number but then we need to make sure it is also the same customer
Spreadsheet: 707782d1607449242-counting-and-entering-data-as-based-on-a-another-cells-value-excel-example-help-2
Sheet: Passenger Names

Number | Date | Trip # | Leg # | Passenger # | Passenger Name
Spreadsheet: 153604d1335971291-excel-2007-problem-with-errors-when-optional-values-are-not-used-waypoints
Sheet: Sheet3

Input in Yellow cells ONLY |  |  |  | (Do not alter any of the values or formulas below except for those in column M.)
 |  |  |  |  |  |  |  |  |  |  |  |  |  | Verified distances:
 |  |  |  |  |  | Latitude | Longitude |  |  |  |  | Distance |  | KBKL to KUKF = 318.55 miles (direct departure to destination)
 |  |  |  | Departure | KBKL | 41.5175 | -81.6833 |  |  |  |  |  |  | KBKL to KCAK = 37.72 miles
Stop 1 | kcak |  |  | Stop 1 |  |  |  |  |  |  |  |  |  | KCAK to KOSU = 89.83 miles
Stop 2 | KOSU |  |  | Stop 2 |  |  |  |  |  |  |  |  |  | KOSU to KLCK = 17.3 miles
Stop 3 | [NAME] |  |  | Stop 3 |  |  |  |  |  |  |  |  |  | KLCK to KLHQ = 12.99 miles
Stop 4 | KLHQ |  |  | Stop 4 |  |  |  |  |  |  |  |  |  | KLHQ to KUNI = 38.17 miles
Stop 5 | KUNI |  |  | Stop 5 |  |  |  |  |  |  |  |  |  | KUNI to KCRW = 58.32 miles
Stop 6 | KCRW |  |  | Stop 6 |  |  |  |  |  |  |  |  |  | KCRW to K6L4 = 34.72 miles
Stop 7 | K6L4 |  |  | Stop 7 |  |  |  |  |  |  |  |  |  | K6L4 to KJFZ = 47.79 miles
Stop 8 | kjfz |  |  | Stop 8 |  |  |  |  |  |  |  |  |  | KJFZ to KGEV = 42.0 miles
Stop 9 | kgev |  |  | Stop 9 |  |  |  |  |  |  |  |  |  | KGEV to KUKF = 20.01 miles
 |  |  |  | Destination | KUKF | 36.2228 | -81.0983
Logically, if removing stops then start from Stop 9 |  |  |  |  |  |  |  |  | Direct Departure to Destination |  |  |  | miles
and work backwards. |  |  |  |  |  |  | Departure to Destination with Waypoints in-between |  |  |  |  |  | miles
 | DO NOT CHANGE THE VALUES BELOW
Stop 1 | KCAK | 40.9161 | -81.4422
Stop 2 | KOSU | 40.0798 | -83.073
Stop 3 | [NAME] | 39.8138 | -82.9278
Stop 4 | KLHQ | 39.7556 | -82.6571
Stop 5 | KUNI | 39.211 | -82.2314
Stop 6 | KCRW | 38.3731 | -81.5932
Stop 7 | K6L4 | 37.8557 | -81.9159
Stop 8 | KJFZ | 37.0637 | -81.7983
Stop 9 | KGEV | 36.4324 | -81.4197
Spreadsheet: 819638d1677606799-remove-characters-from-end-of-value-if-the-value-contains-a-particular-character-dlt
Sheet: Sheet1

3392-9 | 3392
393 | 393
299-410 | 299-410
2424 | 2424
2436-6 | 2436
50-440 | 50-440
504-41 | 504-41
60446 | 60446
7474-5 | 7474
9525 | 9525
3541-1 | 3541
Spreadsheet: 81062d1281345703-due-date-date-programming
Sheet: Sheet1

 |  |  |  |  |  |  |  |  |  | Hello friends…I have a problem here I hope u can help me to solve this problem thanks…
# | Job To Be Done |  |  | Date | Duration | Next date | Reminder
1 | water the plant |  |  | 2009-08-09 00:00:00 | 1 year | 2010-08-09 00:00:00 | DUE
2 | Give cat eat |  |  | 2010-02-09 00:00:00 | 6 month | 2010-08-09 00:00:00 | DUE
3 | give the fertilizer |  |  | 2005-08-09 00:00:00 | 5 years | 2010-08-09 00:00:00 | DUE
 | I plan to make a system. Which is like schedule system. I want a reminder come out like in column H. if date at column G is reached.
Spreadsheet: 709647d1608469459-formulas-required-for-different-options-selected-formula-group-help
Sheet: Sheet1

Sno. | Description |  | Qty |  | Price | Value
1.0 | Item 1 |  | 12345 | sqm
1.1 | Standard Option |  |  | pcs. | 1.16
1.1a | Sub Option a |  |  | pcs. | 1.3
1.1b | Sub Option b |  |  | pcs. | 2.69
1.1c | Sub Option c |  |  | pcs. | 3.69
1.2 | [NAME] |  | 1234 | pcs. | 1.17
1.3 | [NAME] |  | 12 | pcs. | 2.2
1.4 | [NAME] |  | 113 | pcs. | 1.89
1.5 | [NAME] |  | 123 | pcs. | 2.81
1.6 | [NAME] |  | 234 | pcs. | 2.93
1.7 | [NAME] |  | 345 | pcs. | 3.35
1.8 | [NAME] |  | 456 | pcs. | 1.12
 |  | Standard Option
 | Standard Size | 1.12
Spreadsheet: 9144b90d-d6e0-4672-8441-a54514376b10
Sheet: Sheet1

PROGRAM BUDGET
Name of Institution
Focus Area(s)
I. RFA Budget Line Item | II. Item Description | III. Description | IV. Percent of Time on Project | V. Budget Outlined in Application ($) | VI. Actual Spending to Date ($) | VII. Percentage of Budget Used
12.7.1 | Project Director, Co-Director
12.7.2 | Other Professional Staff
12.7.3 | Support Staff
12.7.4 | Work-Study Interns
12.7.5 | Fringe Benefits
12.7.6 | Travel
12.7.7 | Professional or  Other Fees
12.7.8 | Student Incentives (if applicable)
12.7.9 | Other Direct Costs
Total ALL Program Costs (Equals total of 11.7.1 through 11.7.9 above)
 | Cost Sharing from Applicant
Proposal Amount (Equals ALL Program Costs LESS Cost Sharing)
Spreadsheet: 733647d1621679794-using-a-text-value-as-range-by-indirect-function-in-a-vlookup-to-get-a-corresponding-value-label-indirect
Sheet: Label

 | Executive_Rng |  |  |  |  | Team_Leader_Rng |  |  |  |  |  |  |  | 2 | 3 | 4
Sr.No | Employee No | Name as in Official Records | Total |  | Sr.No | Employee No | Name as in Official Records | Total |  | Min | [NAME] | Range To be Used |  | Employee No | Name as in Official Records | Total
1 | 1000 | Executive 1 | 68.39658 |  | 5 | 2000 | Team Leader 1 | 4516 |  |  |  | Executive_Rng |  |  |  |  |  | In this case, I am writing Executive_Rng and then using in VLOOKUP
2 | 1001 | Executive 2 | 23.938803 |  | 6 | 2001 | Team Leader 2 | 1649 |  |  |  | Team_Leader_Rng
 | 1002 | Executive 3 | 60.03710629999999 |  | 7 | 2002 | Team Leader 3 | 2957 |  |  |  |  |  |  |  |  |  | Instead if I could use it this way such as
 | 1003 | Executive 4 | 17.6691165 |  |  | 2003 | Team Leader 4 | 1327 |  |  |  |  |  |  |  |  |  | =VLOOKUP(1,K:M,3,1)
 |  |  |  |  |  | 2004 | Team Leader 5 | 1328 |  |  |  |  |  |  |  |  |  | as the above VLOOKUP wil give me the [NAME] - Executive_Rng for any value between 1 and 4 and Team_Leader_Rng for values between 5 and 8.
 |  |  |  |  |  |  |  |  |  |  |  |  |  | Desired Output using Dynamic Executive_Rng and Team_Leader_Rng
 |  |  |  |  |  |  |  |  |  |  |  |  |  | Employee No | Name as in Official Records | Total
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | In this case only Executive_Rng is Dynamic so its not giving #REF Error.
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | Team_Leader_Rng is a hard-coded range so its correct.
Spreadsheet: 210673d1359525660-reset-formula-buttons-my-japanese
Sheet: Nauns

airplane | ひこうき | hikouki
baby | あかちゃん | akachan
baby-animal | こ　+　animal | [NAME]
[NAME] | ぱんや | [NAME]
ballpen | ﾎﾞ－ﾙﾍﾟﾝ | baalupen
bathroom | ふろば | furoba
bicycle | じてんしゃ | [NAME]
boar | いのしし | いのしし
box | はこ | hako
Bread | パン | pan
bronze | ど
bigbrother | おにいちゃん
bucket | バクツ
camera | ｶﾒﾗ
car | くるま
chair | いす
chocolate | チョコレ―ド
coffee | コーヒー
crab | かに
diary/notebook | てちょう
dictonary | じしょ
doctor | おいしゃさん
elephant | ぞう
engineer | エンジニア
eyedoctor | めいしゃさん
field | はたけ
file case | フャイル
fireworks | はなび
glases | [NAME]
gold | きん
golf | ごるふ
[NAME] | けむし
hat | ばうし
hellikopter | ﾍﾘｺﾌﾟﾀ－
japanese | にほんご
juice | ジュース
keys | かぎ
kindergarden teacher | ようちえんのせんせい
lake | [NAME]
love | あい
nail | つめ
newspaper | しんぶん
notebook | [NAME]
office worker | かいしゃいん
pensil | えんぴつ
pepple | こいし
pound | いけ
radio | ﾗｼﾞｵ
rain | あめ
sharp pen | [NAME]
sheep | ひつじ
shirt | シャス
shoe | くつ
shop | －や
silver | ぎん
bigsister | おねえちゃん
stamp | きって
stone | [NAME]
student | [NAME]
tabaco | ﾀﾊﾞｺ
teacher | [NAME]
text | ﾃｷｽﾄ
tissue | ハンカチ
toilet | おてあらい
towel | タオル
train | [NAME]
umbrella | かさ
wife | おくさん
wife (casual) | すま
work | しごと
yoghurt | [NAME]
[NAME] | ねずみ
chicken | にわとり
ship | ふね
bridge | はし
glasses | [NAME]
strawhat | むりわらぼうし
milk | みるく
mufler | まふらー
mountain | やま
ruby | るびー
apple | りんご
bus | ばす
magasine | ぎっし
square | しかく
triangle | さんかく
circle | まる
pot | んべa
bag | かばん
gloves | てぶくろ
crayons | くれよん
sea | うみ
[NAME] | いちご
candy | あめ
cloud | くも
spider | くも
chopsticks | はし
rain | あめ
Spreadsheet: 781654d1653468002-average-response-time-in-days-by-month-year-and-by-name-average-response-recommendations
Sheet: AVERAGE TIME

LETTER TO CUSTOMER | [NAME] | NAME |  |  |  | 2022 | [NAME] | FEB2022 | MAR2022 |  |  | ASKMEABOUT EXCEL RECOMMENDATION
2022-02-15 00:00:00 | 2022-04-05 00:00:00 | [NAME] |  |  |  | [NAME]
2022-02-15 00:00:00 | 2022-04-05 00:00:00 | [NAME] |  |  |  | [NAME]
2022-03-08 00:00:00 | 2022-03-23 00:00:00 | [NAME] |  |  |  | CHARLIE
2022-03-17 00:00:00 | 2022-03-24 00:00:00 | [NAME] |  |  |  | STEPHANIE
2022-03-24 00:00:00 | 2022-04-21 00:00:00 | [NAME]
2022-04-04 00:00:00 | 2022-04-26 00:00:00 | [NAME] |  |  |  | =IFERROR(SUMPRODUCT((TEXT($A$2:$A$22,"MMMYYYY")=H$1)*($C$2:$C$22=$G2)*($B$2:$B$22-$A$2:$A$22)) |  |  |  |  |  |  |  |  |  |  |  | It says is missing a closing or opening parenthesis
2022-04-04 00:00:00 | 2022-04-27 00:00:00 | [NAME]
2022-04-04 00:00:00 | 2022-04-27 00:00:00 | CHARLIE
2022-04-04 00:00:00 | 2022-04-27 00:00:00 | [NAME]
2022-04-07 00:00:00 | 2022-05-04 00:00:00 | CHARLIE |  |  |  | 2022 | [NAME] | FEB2022 | MAR2022 |  |  | [NAME]
2022-04-11 00:00:00 | 2022-04-15 00:00:00 | STEPHANIE |  |  |  | [NAME]
2022-04-15 00:00:00 | 2022-05-05 00:00:00 | [NAME] |  |  |  | [NAME]
2022-04-14 00:00:00 | 2022-04-19 00:00:00 | STEPHANIE |  |  |  | CHARLIE
2022-04-14 00:00:00 | 2022-04-29 00:00:00 | CHARLIE |  |  |  | STEPHANIE
2022-04-18 00:00:00 | 2022-04-18 00:00:00 | CHARLIE
2022-04-19 00:00:00 | 2022-05-13 00:00:00 | [NAME]
2022-04-19 00:00:00 | 2022-05-13 00:00:00 | [NAME]
2022-04-21 00:00:00 | 2022-05-17 00:00:00 | [NAME]
2022-04-21 00:00:00 | 2022-05-12 00:00:00 | CHARLIE
2022-05-02 00:00:00 | 2022-05-05 00:00:00 | STEPHANIE
2022-04-21 00:00:00 | 2022-05-02 00:00:00 | [NAME]
Spreadsheet: 713396d1610703114-return-headers-from-matches-in-a-list-menu-items-and-inventory-3-
Sheet: CK Inventory

PRODUCT SELECT |  |  |  | Caesar Dressing | Cheese Sauce | Chili Sauce | Choron Mayo | [NAME] | [NAME] Dressing | [NAME] | Lemon Sour Cream | [NAME] | Mayonnaise | [NAME] | [NAME] | Chocolate Sauce | Caramel Sauce | Falafel Balls | Sliced Ham | Roast Beef | Vegan Pumpkin Hummus | MX Spice (Mixed) | SW Spice (Shawarma) | Pickled Beetroot | Pickled Cucumber | Whole Pickled Jalapeño | Sun Dried Tomato | Roasted Nuts | Peanuts | Emmentaler Cheese | Mozzarella Cheese | Cheddar Cheese | Yoghurt | [NAME] | Muffin [NAME] | Pancakes | [NAME]
Ham Cheese Mayo
Select product from list above | CK Items | CK Clashing Items
 |  | Ham & Cheese Toastie
 |  | Ham Cheese Panini
 |  | [NAME]
 |  | Roast Beef & Avocado
 |  | Submarine Supreme
 |  | Lucky 13 Burger
Spreadsheet: 51932116-45da-457b-a0e9-3ab98e5e534e
Sheet: REGIONAL PROJECT TEAM 3 years

 | Project Title: | [NAME] | New Coalitions for Biodiversity - Developing public-private partnerships within protected areas in five countries of the South East Europe - Budget
 | Project Activities: | REGIONAL PROJECT TEAM
 |  | YEAR 1 - 2011 |  |  | YEAR 2 - 2012 |  |  | YEAR 3 -2013 |  |  |  | TOTAL  3 YEARS
 | Category | Donor | WWF MEDPO | Total | Donor | WWF MEDPO | Total | Donor | WWF MEDPO | Total |  | Donor | WWF MEDPO | Total
1 | Project Staff
1.1 | Regional Project leader (36 month - 100%) | 50000
1.2 | Assistant  to Project Leader (36 month - 100%)
1.3 | Director of Conservation WWF-MEDPO
1.4 | Project Administration Staff:   1. WWF-MEDPO administrator 2. Local administrator)
1.5 | BP development lead local (36 month - 100%)
1.6 | PPP Regional Leader (36 month - 100% )
1.7 | PPP Regional Leader Assistant  (36 month - 100%)
1.8 | PPP development international support: 30% /Year, Director of Comms WWF-MEDPO | 28500
1.9 | PPP capacity building international support: 10% of Education & Capacity Building Manager WWF- MEDPO
 | Total 1
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 12000
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | -10000
 | Total 2
3 | Travel
3.1 | Travel project regional Leader | 1000 |  |  | 1000 |  |  | 1000
3.2 | Travel project supervision team (BP component)
3.3 | Travel costs for PPP staff selection | 2000
3.4 | Travel project supervision team (PPP component) | 7000 |  |  | 7000 |  |  | 7000
 | Total 3
4 | Local Office Running Costs
4.3 | ORC for  local lead (4 people)
4.4 | Equipment (4xPC/software/printer and office set up) | 6000
 | Total 4
5 | Management Fees - 8,5%
 | Total
 |  | Donor | WWF MedPO | Total
 | Year 1
 | Year 2
 | Year 3
 | Total 3 years
 | Total Direct Cost for MedPO ORC and Admin
Spreadsheet: daren_farmer__6518__Final_1-1-00
Sheet: GRS Test

Global Rate Services 1/1/2000 Test /Plan
 | Procedure | System | Expected Result | Contingency Plan | Date/Time | Responsible Person
 | Load Exchange rates into ERMS | Telerate/ERMS | Reload Thursday 12/30 prices with 1/1000 added to the price (2.251 vs. 2.25) for Thursday 12/30 and a January futures price.  [NAME] should run with no errors. | Hold book calc until IT can assist with getting prices loaded. | 1/1/00  9:40am | [NAME]
 | Enter manually calc'd prices into Unify | Excel/Unify | Input with no errors. | Manually invoice. | 1/1/00 10:00am | [NAME]
 | Enter prices into Enpower | Enpower | Enter PX prices into Enpower for weekend. | Hold book calc until IT can assist with getting prices loaded. | 1/1/00 10:00am | [NAME]
 | Check PJM/NEPOOL price load into Enpower | Enpower | Verify prices match between PJM internet and Enpower. | Hold book calc until IT can assist with getting prices loaded. | 1/1/00 11:00am | [NAME]
 | [NAME] to ERMS exceptions | Phoenix/ERMS | Minimal exceptions | If Phoenix is in error, any payments or invoices should be manually prepared.  If ERMS is in error, books should not be calced until problem is corrected. | 1/1/2000  9:30am | [NAME]
 | [NAME] with Phoenix prices | Phoenix/Unify | Refresh with no errors.  Verify prices in Unify. | Payments or invoices should be manually prepared. | 1/1/2000 10:15am | [NAME]
 | Access Internet Sites used | Netscape | Verify required pages are accessible and provide information needed | Call publishers for prices. | 1/1/00 9:50am | [NAME]
 | Access Telerate Pages | Telerate | Market closed 1/1/00.  Cannot verify updates. | [NAME] source if problems of 1/4/00 | 1/1/00 9:30am | [NAME]
Spreadsheet: 44836d1243562446-if-statement-logic-between-adjacent-cells-example
Sheet: Sheet1

Open Time | Close Time | Total | Date Range | True/False
2011-10-31 06:00:00 | 2011-10-31 00:00:00 | 88.92 | 2007-10-30 00:00:00 | 0
2011-11-02 07:32:20 | 2011-11-02 00:00:00 | 0 | 2007-10-31 00:00:00 | 88.92
2011-11-02 08:38:46 | 2011-11-02 00:00:00 | 249.44 | 2007-11-01 00:00:00 | 0
2011-11-06 04:28:40 | 2011-11-09 00:00:00 | 0 | 2007-11-02 00:00:00 | 249.44
2011-11-08 03:59:10 | 2011-11-09 00:00:00 | 0 | 2007-11-03 00:00:00 | 0
2011-11-09 06:01:44 | 2011-11-09 00:00:00 | 0 | 2007-11-04 00:00:00 | 0
2011-11-09 06:17:22 | 2011-11-09 00:00:00 | 0 | 2007-11-05 00:00:00 | 0
2011-11-09 22:38:10 | 2011-11-10 00:00:00 | 0 | 2007-11-06 00:00:00 | 0
2011-11-13 19:29:32 | 2011-11-15 00:00:00 | 0 | 2007-11-07 00:00:00 | 0
2011-11-15 04:31:19 | 2011-11-15 00:00:00 | -415.89 | 2007-11-08 00:00:00 | 0
2011-11-15 17:23:04 | 2011-11-16 00:00:00 | -267.39 | 2007-11-09 00:00:00 | 0
2011-11-15 18:19:05 | 2011-11-16 00:00:00 | 0 | 2007-11-10 00:00:00 | 0
2011-11-15 18:40:48 | 2011-11-16 00:00:00 | 0 | 2007-11-11 00:00:00 | 0
2011-11-20 20:58:54 | 2011-11-21 00:00:00 | 0 | 2007-11-12 00:00:00 | 0
2011-11-22 13:24:21 | 2011-11-23 00:00:00 | 0 | 2007-11-13 00:00:00 | 0
2011-11-22 11:06:36 | 2011-11-24 00:00:00 | 183.67 | 2007-11-14 00:00:00 | 0
2011-11-23 04:27:15 | 2011-11-24 00:00:00 | -787.6 | 2007-11-15 00:00:00 | -683.28
2011-11-24 13:34:52 | 2011-11-27 00:00:00 | 0 | 2007-11-16 00:00:00 | 0
Spreadsheet: 99962d1298475880-status-of-the-project-status
Sheet: Sheet1

 | MS01 | MS02 | MS03 | MS04 | MS05
A | 2011-02-05 00:00:00 | 2011-02-15 00:00:00 | 2011-02-21 00:00:00 | 2011-02-22 00:00:00 | 2011-02-23 00:00:00
B | PROBLEM
C | 2011-02-14 00:00:00 | 2011-02-18 00:00:00 | PROBLEM
D | 2011-01-01 00:00:00
E
F
G
H
I
Spreadsheet: 867898d1714658746-conditional-format-any-cell-in-range-that-matches-cell-in-another-range-cfrngsamp
Sheet: Sheet1

1 | 5 | 6 | 9 | 12
44 | 25 | 8 | 27 | 6
34 | 18 | 1 | 50 | 44
1 | 20 | 14 | 50 | 17
34 | 41 | 22 | 18 | 7
24 | 42 | 25 | 44 | 10
Spreadsheet: 189442d1351190338-ho-to-get-only-one-price-if-you-have-two-columns-with-diffident-prices-in-invoice2
Sheet: Invoice

Cash
Check |  | Insert Company Information Here |  |  |  |  |  |  |  |  | Invoice No.
Credit
Other
 |  |  |  |  |  |  |  |  |  |  |  | Invoice
 |  | Customer |  |  |  |  |  |  |  |  | Misc
 |  | Name | jan |  |  |  |  |  |  |  | Date
 |  | Address |  |  | Address 2 |  |  |  |  |  | Order No.
 |  | City |  |  |  | P code
 |  | Phone
 |  | Qty | Description |  |  |  |  |  |  | Sales Price | Unit Price | TOTAL
 |  | 1 | [NAME] en [NAME]
 |  | 4 | [NAME] nie
 |  | 6 | Waar is ek
 |  | 8 | Waar is ek
 |  | 8 | Hoekom is daar !
 |  |  |  |  |  |  |  |  |  |  | SubTotal
 |  |  |  |  |  |  |  |  |  |  | Shipping
 |  | Payment | Select One… |  |  |  |  |  | Tax Rate(s)
 |  | Comments |  |  |  |  |  |  |  |  | TOTAL
 |  | Name
 |  | CC # |  |  |  |  |  |  | Office Use Only
 |  | Expires
 |  | [NAME] Here
 |  |  | [NAME] Here
Spreadsheet: 82696d1282729865-defining-chart-colours-by-cell-entries-chart-colour-dummy
Sheet: Table

Colour | R | G | B | Chart Value
Red | 255 | 0 | 0 | 16
Blue | 0 | 0 | 255 | 13
Green | 0 | 255 | 0 | 7
 | I have this chart: |  |  |  |  |  |  |  |  |  | I want this done automatically:
Spreadsheet: 818417d1676818294-or-function-in-table-format-doesnt-work-example-35-ans
Sheet: Sheet1

 | (Worked) Scenario1: Indicator =1
 |  |  |  |  |  | Expected: |  |  |  | [NAME]:
 |  | Transit | GL | Indicator |  | Transit | GL | Indicator |  | Transit | GL | Indicator
 |  | 11111 | 123456
 |  | 22222 | 2222214
 |  | 33333 | 12123123 | 1 |  | 33333 | 12123123 | 1
 | (Doesn't Worked) Scenario2: Indicator =1 or Indicator [NAME]
 |  |  |  |  |  | Expected: |  |  |  | [NAME]:
 |  | Transit | GL | Indicator |  | Transit | GL | Indicator |  | Transit | GL | Indicator
 |  | 11111 | 123456 | -1 |  | 11111 | 123456 | -1
 |  | 22222 | 2222214
 |  | 33333 | 12123123 | 1 |  | 33333 | 12123123 | 1